Re: [PERFORM] pg_stat_statements query normalization

2013-06-19 Thread Sameer Thakur
>Why don't you play around with it and see for yourself? I did that. Populated a sample table and then queried on it multiple times for each condition (=,>,<) with different constant values. Then queried pg_stat_statements view. Saw three different records corresponding to each condition query text

Re: [PERFORM] pg_stat_statements query normalization

2013-06-17 Thread Peter Geoghegan
On Sun, Jun 16, 2013 at 11:58 PM, Sameer Thakur wrote: > Consider query > SELECT * FROM pgbench_branches LEFT JOIN pgbench_tellers ON > pgbench_tellers.bid= pgbench_branches.bid WHERE pgbench_branches.bID=5 > > Does this mean that all queries with just the constant changing are > normalized > > pg

[PERFORM] pg_stat_statements query normalization

2013-06-16 Thread Sameer Thakur
Hello, Reading code documentation of pg_stat_statements it says * As of Postgres 9.2, this module normalizes query entries. Normalization * is a process whereby similar queries, typically differing only in their * constants (though the exact rules are somewhat more subtle than that) are * reco