Anton [Mgn, az09@osm]
14.02.2018
20:39:37
в конфиге выставил log_min_duration_statement = 1000 однако вижу в логих гигабайты следов от работы pg_top очевидно
2018-02-14 20:39:50.529 UTC,"postgres","postgres",32039,"[local]",5a849e96.7d27,1,"SHOW",2018-02-14 20:39:50 UTC,2/0,0,LOG,00000,"duration: 0.418 ms",,,,,,,,,""
2018-02-14 20:39:50.533 UTC,"postgres","postgres",32039,"[local]",5a849e96.7d27,2,"SELECT",2018-02-14 20:39:50 UTC,2/0,0,LOG,00000,"duration: 4.053 ms",,,,,,,,,""
2018-02-14 20:39:50.569 UTC,"postgres","postgres",32040,"[local]",5a849e96.7d28,1,"SELECT",2018-02-14 20:39:50 UTC,2/0,0,LOG,00000,"duration: 14.022 ms",,,,,,,,,""
2018-02-14 20:39:55.578 UTC,"postgres","postgres",32043,"[local]",5a849e9b.7d2b,1,"SHOW",2018-02-14 20:39:55 UTC,2/0,0,LOG,00000,"duration: 0.392 ms",,,,,,,,,""
2018-02-14 20:39:55.582 UTC,"postgres","postgres",32043,"[local]",5a849e9b.7d2b,2,"SELECT",2018-02-14 20:39:55 UTC,2/0,0,LOG,00000,"duration: 3.790 ms",,,,,,,,,""
2018-02-14 20:39:55.604 UTC,"postgres","postgres",32044,"[local]",5a849e9b.7d2c,1,"SELECT",2018-02-14 20:39:55 UTC,2/0,0,LOG,00000,"duration: 13.714 ms",,,,,,,,,""
типа такого (сорри за портянку)
сейчас вырубил пг_топ и эти записи прекратили появляться
Anton [Mgn, az09@osm]
14.02.2018
21:13:48
каждые 5 секунд
2018-02-14 21:14:39.028 UTC,"postgres","postgres",365,"[local]",5a84a6bf.16d,1,"SHOW",2018-02-14 21:14:39 UTC,3/0,0,LOG,00000,"duration: 0.459 ms",,,,,,,,,""
2018-02-14 21:14:39.032 UTC,"postgres","postgres",365,"[local]",5a84a6bf.16d,2,"SELECT",2018-02-14 21:14:39 UTC,3/0,0,LOG,00000,"duration: 3.636 ms",,,,,,,,,""
2018-02-14 21:14:39.055 UTC,"postgres","postgres",366,"[local]",5a84a6bf.16e,1,"SELECT",2018-02-14 21:14:39 UTC,3/0,0,LOG,00000,"duration: 14.525 ms",,,,,,,,,""