8000 fix: pg_stat_statements column names changed in PG13 · atkawa7/postgres@5906050 · GitHub
[go: up one dir, main page]
Skip to content

Commit 5906050

Browse files
daroradarora
committed
fix: pg_stat_statements column names changed in PG13
1 parent c10fdcc commit 5906050

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

‎ansible/files/queries.yml.j2

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -154,7 +154,7 @@ pg_stat_database_conflicts:
154154
description: "Queries cancelled due to deadlocks"
155155

156156
pg_stat_statements:
157-
query: "SELECT sum(calls) as total_queries, sum(total_time / 1000) as total_time_seconds FROM extensions.pg_stat_statements t1 JOIN pg_database t3 ON (t1.dbid=t3.oid)"
157+
query: "SELECT sum(calls) as total_queries, sum(total_exec_time / 1000) as total_time_seconds FROM extensions.pg_stat_statements t1 JOIN pg_database t3 ON (t1.dbid=t3.oid)"
158158
master: true
159159
metrics:
160160
- total_queries:

0 commit comments

Comments
 (0)
0