May 2018
Intermediate to advanced
576 pages
30h 25m
English
pg_stat_statements collects data on all running queries by accumulating data in memory, producing minimal overheads.
Similar SQL statements are normalized so that the constants and parameters used for execution are removed. This allows you to see all similar SQL statements in one line of the report, rather than seeing thousands of lines, which would be fairly useless. While useful, it can sometimes mean that it's hard to work out which parameter values are actually causing the problem.