>Why are you posting this to the -performance list?
Sorry, maybe -general was the correct place. I thought that
pg_stat_statements was a performance diagnostics tool, so -performance was
the correct forum
Thank you
Sameer
Hello,
I understand that when the pg_stat_statements.save=true the
statement statistics are saved at global/pg_stat_statements.stat. This file
is read on next startup and then deleted.
If there is a crash i understand that pg_stat_statements.stat file is not
created even if pg_stat_statements.save
>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
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
Hello,
After executing make install for pg_statsinfo when i start the server i see
error
ERROR: could not connect to repository
WARNING: writer discards 1 items
LOG: pg_statsinfo launcher shutting down
DEBUG: shmem_exit(0): 0 callbacks to make
DEBUG: proc_exit(0): 0 callbacks to make
DEBUG: ex
Hello,
I am trying to find predicate information for a given SQL query plan as
provided by Oracle using DBMS_XPLAN. I am looking at the EXPLAIN command
for getting this query plan information, with no luck so far.
Does the EXPLAIN command provide predicate information?
Thank you
Sameer
