# alter system set auto_explain.log_analyze = on; ALTER SYSTEM # alter system set auto_explain.log_min_duration=0; ALTER SYSTEM # alter system set auto_explain.log_timing=off; ALTER SYSTEM # select pg_reload_Conf(); pg_reload_conf ---------------- t (1 row) $ pgbench -i postgres $ for i in {1..10}; do pgbench -n -M prepared -T 10 -S postgres | grep tps; done tps = 11313.865802 tps = 11353.239133 tps = 11278.210905 tps = 11254.050329 tps = 11322.879711 tps = 11204.294425 tps = 11175.276264 tps = 11211.813427 tps = 11229.452802 tps = 11049.732047 # alter system set auto_explain.log_buffers=1; ALTER SYSTEM # select pg_reload_conf(); pg_reload_conf ---------------- t (1 row) $ for i in {1..10}; do pgbench -n -M prepared -T 10 -S postgres | grep tps; done tps = 10509.378765 tps = 11077.139873 tps = 11232.809410 tps = 11141.543652 tps = 11003.065838 tps = 11121.254826 tps = 11136.912487 tps = 11039.627884 tps = 11079.197251 tps = 11122.450776 # alter system set auto_explain.log_min_duration=-1; ALTER SYSTEM # select pg_reload_conf(); pg_reload_conf ---------------- t (1 row) $ for i in {1..10}; do pgbench -n -M prepared -T 10 -S postgres | grep tps; done tps = 12663.516909 tps = 13456.062885 tps = 13245.672977 tps = 13326.781348 tps = 13501.902909 tps = 13156.941863 tps = 13212.124942 tps = 13372.313995 tps = 13164.414056 tps = 13236.860009