Introduction to pg_stat_statements

This is quick tutorial to get up and running with pg_stat_statements, a PostgreSQL extension that provides statistics about database table perfomance.

[dmitrybaycharov]

my postgresql.conf file was actually located in /etc/postgres/10/main/

the directory outputted by running the 'SHOW data_directory' command only had a postgres.auto.conf file

[pravinmahandule]

in result set of pg_stat_statements max_exec_time records e.g. 19sec while mean_exec_time records 0.7sec there is huge difference for calls around 500...I couldn't find the cause of this huge difference in time..could you please help