melkij
7d8552b127
added global report for Postgresql 16 (symlink)
2 years ago
Maxim Boguk
7950d96cfe
added global report for Postgresql 15
3 years ago
Maxim Boguk
1b6c20cd10
create version specific symlinks for query_stat_total_*.sql
4 years ago
Alexey Ermakov
106d00ba9d
adding support for pg_stat_statements 1.8 (introduced on postgresql 13) for query_stat_total.sql report (in separate file)
5 years ago
Alexey Ermakov
598cd5833e
query_stat_total.sql fixes: display "unknown" for rows in pg_stat_statements with null in query column. fix "division by zero" error for pg13 when call column could be 0.
5 years ago
Alexey Ermakov
d9e225fd6f
show queries from dropped users and databases as from "unknown" instead of empty rows.
6 years ago
Alexey Ermakov
e23528fc94
query_stat_total improvements:
...
1) display warnings when DB is close to xidWrapLimit by 200M transactions
2) remove '\r' symbol from queries for better display at email clients
fix incorrect numbering of queries when there is no 'other' query, fix IO percentage at total time when there is very little / no activity on database since last pg_stat_statements reset.
9 years ago
Alexey Ermakov
cc7c928b3f
query_stat_total improvements:
...
1) display track utilities information
2) display most returning rows queries with % of total rows
3) speed up execution in case of very long queries
4) truncate query to 8kb size in report
fix possible incorrect filtration of top I/O queries.
10 years ago
Alexey Ermakov
276e35ca8f
add version/settings info in header
11 years ago
Alexey Ermakov
bd654e5073
query stat total report: formatting fixes
11 years ago
Alexey Ermakov
29aedc4353
query stat total report: formatting fixes
11 years ago
Alexey Ermakov
46e3e80d30
query stat total report: various fixes
11 years ago
PostgreSQL administrator
d002d1349c
changes to regexps
11 years ago
Alexey Ermakov
895c590d72
query stat total report: fix group by query issue
11 years ago
Alexey Ermakov
1263a1e0a6
query stat total report: add most frequent queries
11 years ago
Alexey Ermakov
90065ed1ee
query stat total report: combine ((?::bigint, …, ?::bigint) expressions into (?)
11 years ago
Alexey Ermakov
7be631417a
query stat total report: combine (?, …, ?) expressions into (?)
11 years ago
Alexey Ermakov
b6827af0c1
query stat total report: handle zero io cases
11 years ago
Alexey Ermakov
93093fa5a0
query stat total report: row numbers fix
11 years ago
Alexey Ermakov
f545d505c7
add query stat total report
11 years ago
Alexey Lesovsky
bc6ec95d14
add sql/global_reports
11 years ago