looks like i do it wrong. I turned auto_explain on with adding next valued to postgresql.conf:
shared_preload_libraries = 'pg_stat_statements,pg_wait_sampling,pg_stat_kcache,auto_explain'
auto_explain.log_min_duration = '3s'
in my monitoring I can see long running queries that exceeded limit of 3s and successfully finished.
'values' here says how long query lasted:
But when I look into my log 'postgresql-Mon.log' (and next days) there is nothing about those queries. Only a few strings about modules during database startup process.
Am I missing something?
But when I look into my log 'postgresql-Mon.log' (and next days) there is nothing about those queries. Only a few strings about modules during database startup process.
Am I missing something?
Asked by Mikhail Aksenov
(430 rep)
Dec 10, 2019, 11:16 AM
Last activity: Aug 9, 2025, 08:06 AM
Last activity: Aug 9, 2025, 08:06 AM