\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u043d\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0442\u0430 pg_stat_history<\/b><\/p>\n\n \u0422\u0430\u0431\u043b\u0438\u0446\u0430 \"public.pg_stat_history\"\n \u041a\u043e\u043b\u043e\u043d\u043a\u0430 | \u0422\u0438\u043f | \u041c\u043e\u0434\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440\u0438\n---------------------+-----------------------------+-------------------------------------------\n id | \u0446\u044f\u043b\u043e\u0441\u0442\u043d\u043e | \u043d\u0435 \u0435 null \u043f\u043e \u043f\u043e\u0434\u0440\u0430\u0437\u0431\u0438\u0440\u0430\u043d\u0435 nextval('pg_stat_history_id_seq'::regclass)\n snapshot_timestamp | \u0432\u0440\u0435\u043c\u0435\u0432\u0430 \u043f\u0435\u0447\u0430\u0442 \u0431\u0435\u0437 \u0432\u0440\u0435\u043c\u0435\u0432\u0430 \u0437\u043e\u043d\u0430 |\n database_id | \u0446\u044f\u043b\u043e\u0441\u0442\u043d\u043e |\n dbid | oid |\n userid | oid |\n queryid | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n query | \u0442\u0435\u043a\u0441\u0442 |\n calls | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n total_time | \u0434\u0432\u043e\u0439\u043d\u0430 \u043f\u0440\u0435\u0446\u0438\u0437\u043d\u043e\u0441\u0442 |\n min_time | \u0434\u0432\u043e\u0439\u043d\u0430 \u043f\u0440\u0435\u0446\u0438\u0437\u043d\u043e\u0441\u0442 |\n max_time | \u0434\u0432\u043e\u0439\u043d\u0430 \u043f\u0440\u0435\u0446\u0438\u0437\u043d\u043e\u0441\u0442 |\n mean_time | \u0434\u0432\u043e\u0439\u043d\u0430 \u043f\u0440\u0435\u0446\u0438\u0437\u043d\u043e\u0441\u0442 |\n stddev_time | \u0434\u0432\u043e\u0439\u043d\u0430 \u043f\u0440\u0435\u0446\u0438\u0437\u043d\u043e\u0441\u0442 |\n rows | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n shared_blks_hit | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n shared_blks_read | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n shared_blks_dirtied | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n shared_blks_written | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n local_blks_hit | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n local_blks_read | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n local_blks_dirtied | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n local_blks_written | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n temp_blks_read | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n temp_blks_written | \u0433\u043e\u043b\u044f\u043c\u043e \u0446\u044f\u043b\u043e |\n blk_read_time | \u0434\u0432\u043e\u0439\u043d\u0430 \u043f\u0440\u0435\u0446\u0438\u0437\u043d\u043e\u0441\u0442 |\n blk_write_time | \u0434\u0432\u043e\u0439\u043d\u0430 \u043f\u0440\u0435\u0446\u0438\u0437\u043d\u043e\u0441\u0442 |\n baseline_id | \u0446\u044f\u043b\u043e\u0441\u0442\u043d\u043e |\n\u0418\u043d\u0434\u0435\u043a\u0441\u0438:\n \"pg_stat_history_pkey\" \u041f\u042a\u0420\u0412\u0418\u0427\u0415\u041d \u041a\u041b\u042e\u0427, btree (id)\n \"database_idx\" btree (database_id)\n \"queryid_idx\" btree (queryid)\n \"snapshot_timestamp_idx\" btree (snapshot_timestamp)\n\u0427\u0443\u0436\u0434\u0435\u0441\u0442\u0440\u0430\u043d\u043d\u0438 \u043a\u043b\u044e\u0447\u043e\u0432\u0438 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f:\n \"database_id_fk\" \u0427\u0423\u0416\u0414\u0415\u0421\u0422\u0420\u0410\u041d\u0415\u041d \u041a\u041b\u042e\u0427 (database_id) \u0423\u041a\u0410\u0417\u0412\u0410 \u043d\u0430 database(id) \u041f\u0420\u0418 \u0418\u0417\u0422\u0420\u0418\u0412\u0410\u041d\u0415 CASCADE<\/pre>\n\n\u041a\u0430\u043a\u0442\u043e \u0441\u0435 \u0432\u0438\u0436\u0434\u0430, \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0442\u0430 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0432\u0430 \u0441\u0430\u043c\u043e \u043a\u0443\u043c\u0443\u043b\u0430\u0442\u0438\u0432\u043d\u0438 \u0434\u0430\u043d\u043d\u0438 \u043e\u0442 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u044f\u043d\u0435 pg_stat_statements <\/b> \u0432 \u0446\u0435\u043b\u0435\u0432\u0430\u0442\u0430 \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u043d\u0438.<\/p>\n\u0418\u0437\u043f\u043e\u043b\u0437\u0432\u0430\u043d\u0435\u0442\u043e \u043d\u0430 \u0442\u0430\u0437\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u0435 \u043c\u043d\u043e\u0433\u043e \u043f\u0440\u043e\u0441\u0442\u043e<\/h3>\n
\npg_stat_history<\/b> \u0449\u0435 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0432\u0430 \u043d\u0430\u0442\u0440\u0443\u043f\u0430\u043d\u0430 \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430 \u0437\u0430 \u0438\u0437\u043f\u044a\u043b\u043d\u0435\u043d\u0438\u0435\u0442\u043e \u043d\u0430 \u0437\u0430\u044f\u0432\u043a\u0438\u0442\u0435 \u0437\u0430 \u0432\u0441\u0435\u043a\u0438 \u0447\u0430\u0441. \u0412 \u043d\u0430\u0447\u0430\u043b\u043e\u0442\u043e \u043d\u0430 \u0432\u0441\u0435\u043a\u0438 \u0447\u0430\u0441, \u0441\u043b\u0435\u0434 \u0437\u0430\u043f\u044a\u043b\u0432\u0430\u043d\u0435\u0442\u043e \u043d\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0442\u0430, \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430\u0442\u0430 pg_stat_statements<\/b> \u0441\u0435 \u043d\u0443\u043b\u0438\u0440\u0430 \u0441 \u043f\u043e\u043c\u043e\u0449\u0442\u0430 \u043d\u0430 pg_stat_statements_reset()<\/b>.
\n\u0411\u0435\u043b\u0435\u0436\u043a\u0430: \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430 \u0441\u0435 \u0441\u044a\u0431\u0438\u0440\u0430 \u0437\u0430 \u0437\u0430\u044f\u0432\u043a\u0438 \u0441 \u0432\u0440\u0435\u043c\u0435\u0442\u0440\u0430\u0435\u043d\u0435 \u043d\u0430 \u0438\u0437\u043f\u044a\u043b\u043d\u0435\u043d\u0438\u0435\u0442\u043e \u043d\u0430\u0434 1 \u0441\u0435\u043a\u0443\u043d\u0434\u0430.<\/i>
\n\u0417\u0430\u043f\u044a\u043b\u0432\u0430\u043d\u0435 \u043d\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0442\u0430 pg_stat_history<\/b><\/p>\n--pg_stat_history.sql\nCREATE OR REPLACE FUNCTION pg_stat_history( ) RETURNS boolean AS $$\nDECLARE\n endpoint_rec record ;\n database_rec record ;\n pg_stat_snapshot record ;\n current_snapshot_timestamp timestamp without time zone;\nBEGIN\n current_snapshot_timestamp = date_trunc('minute',now()); \n \n FOR endpoint_rec IN SELECT * FROM endpoint \n LOOP\n FOR database_rec IN SELECT * FROM database WHERE endpoint_id = endpoint_rec.id \n\t LOOP\n\t \n\t\tRAISE NOTICE '\u0421\u042a\u0417\u0414\u0410\u0412\u0410 \u0421\u0415 \u041d\u041e\u0412 \u0421\u041d\u0418\u041c\u041a\u0410';\n\t\t\n\t\t--\u0421\u0432\u044a\u0440\u0437\u0432\u0430\u043d\u0435 \u0441 \u0446\u0435\u043b\u0435\u0432\u0430\u0442\u0430 \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u043d\u0438\t \n\t EXECUTE 'SELECT dblink_connect(''LINK1'',''host='||endpoint_rec.host||' dbname='||database_rec.name||' user=USER password=PASSWORD '')';\n \n RAISE NOTICE 'host % \u0438 dbname % ',endpoint_rec.host,database_rec.name;\n\t\tRAISE NOTICE '\u0421\u044a\u0437\u0434\u0430\u0432\u0430\u043d\u0435 \u043d\u0430 \u0441\u043d\u0438\u043c\u043a\u0430 \u043d\u0430 pg_stat_statements \u0437\u0430 \u0431\u0430\u0437\u0430\u0442\u0430 \u0434\u0430\u043d\u043d\u0438 %',database_rec.name;\n\t\t\n\t\tSELECT \n\t *\n\t\tINTO \n\t\t pg_stat_snapshot\n\t FROM dblink('LINK1',\n\t 'SELECT \n\t dbid , SUM(calls),SUM(total_time),SUM(rows) ,SUM(shared_blks_hit) ,SUM(shared_blks_read) ,SUM(shared_blks_dirtied) ,SUM(shared_blks_written) , \n SUM(local_blks_hit) , SUM(local_blks_read) , SUM(local_blks_dirtied) , SUM(local_blks_written) , SUM(temp_blks_read) , SUM(temp_blks_written) , SUM(blk_read_time) , SUM(blk_write_time)\n\t FROM pg_stat_statements WHERE dbid=(SELECT oid from pg_database where datname=current_database() ) \n\t\t GROUP BY dbid\n \t '\n\t )\n\t AS t\n\t ( dbid oid , calls bigint , \n \t total_time double precision , \n\t rows bigint , shared_blks_hit bigint , shared_blks_read bigint ,shared_blks_dirtied bigint ,shared_blks_written\t bigint ,\n local_blks_hit\t bigint ,local_blks_read bigint , local_blks_dirtied bigint ,local_blks_written bigint ,\n temp_blks_read\t bigint ,temp_blks_written bigint ,\n blk_read_time double precision , blk_write_time double precision\t \n\t );\n\t\t \n\t\tINSERT INTO pg_stat_history\n ( \n\t\t snapshot_timestamp ,database_id ,\n\t\t\tdbid , calls ,total_time ,\n rows ,shared_blks_hit ,shared_blks_read ,shared_blks_dirtied ,shared_blks_written ,local_blks_hit , \t \n local_blks_read,local_blks_dirtied,local_blks_written,temp_blks_read,temp_blks_written, \t\n blk_read_time, blk_write_time \n\t\t )\t\t \n\t VALUES\n\t (\n\t current_snapshot_timestamp ,\n\t\t database_rec.id ,\n\t pg_stat_snapshot.dbid ,pg_stat_snapshot.calls,\n\t pg_stat_snapshot.total_time,\n\t pg_stat_snapshot.rows ,pg_stat_snapshot.shared_blks_hit ,pg_stat_snapshot.shared_blks_read ,pg_stat_snapshot.shared_blks_dirtied ,pg_stat_snapshot.shared_blks_written , \n pg_stat_snapshot.local_blks_hit , pg_stat_snapshot.local_blks_read , pg_stat_snapshot.local_blks_dirtied , pg_stat_snapshot.local_blks_written , \n\t pg_stat_snapshot.temp_blks_read , pg_stat_snapshot.temp_blks_written , pg_stat_snapshot.blk_read_time , pg_stat_snapshot.blk_write_time \t \n\t );\t\t \n\t\t \n RAISE NOTICE '\u0421\u044a\u0437\u0434\u0430\u0432\u0430\u043d\u0435 \u043d\u0430 \u0441\u043d\u0438\u043c\u043a\u0430 \u043d\u0430 pg_stat_statements \u0437\u0430 \u0437\u0430\u044f\u0432\u043a\u0438 \u0441 min_time \u043f\u043e-\u0433\u043e\u043b\u044f\u043c \u043e\u0442 1000ms';\n\t\n FOR pg_stat_snapshot IN\n --\u0412\u0441\u0438\u0447\u043a\u0438 \u0437\u0430\u044f\u0432\u043a\u0438 \u0441 max_time \u043f\u043e-\u0433\u043e\u043b\u044f\u043c \u043e\u0442 1000 ms\n\t SELECT \n\t *\n\t FROM dblink('LINK1',\n\t 'SELECT \n\t dbid , userid ,queryid,query,calls,total_time,min_time ,max_time,mean_time, stddev_time ,rows ,shared_blks_hit ,\n\t\t\t shared_blks_read ,shared_blks_dirtied ,shared_blks_written , \n local_blks_hit , local_blks_read , local_blks_dirtied , \n\t\t\t local_blks_written , temp_blks_read , temp_blks_written , blk_read_time , \n\t\t\t blk_write_time\n\t FROM pg_stat_statements \n\t\t\t WHERE dbid=(SELECT oid from pg_database where datname=current_database() AND min_time >= 1000 ) \n \t '\n\n\t )\n\t AS t\n\t ( dbid oid , userid oid , queryid bigint ,query text , calls bigint , \n \t total_time double precision ,min_time double precision\t ,max_time double precision\t , mean_time double precision\t , stddev_time double precision\t , \n\t rows bigint , shared_blks_hit bigint , shared_blks_read bigint ,shared_blks_dirtied bigint ,shared_blks_written\t bigint ,\n local_blks_hit\t bigint ,local_blks_read bigint , local_blks_dirtied bigint ,local_blks_written bigint ,\n temp_blks_read\t bigint ,temp_blks_written bigint ,\n blk_read_time double precision , blk_write_time double precision\t \n\t )\n\t LOOP\n\t\t INSERT INTO pg_stat_history\n ( \n\t\t snapshot_timestamp ,database_id ,\n\t\t\tdbid ,userid , queryid , query , calls ,total_time ,min_time ,max_time ,mean_time ,stddev_time ,\n rows ,shared_blks_hit ,shared_blks_read ,shared_blks_dirtied ,shared_blks_written ,local_blks_hit , \t \n local_blks_read,local_blks_dirtied,local_blks_written,temp_blks_read,temp_blks_written, \t\n blk_read_time, blk_write_time \n\t\t )\t\t \n\t VALUES\n\t (\n\t current_snapshot_timestamp ,\n\t\t database_rec.id ,\n\t pg_stat_snapshot.dbid ,pg_stat_snapshot.userid ,pg_stat_snapshot.queryid,pg_stat_snapshot.query,pg_stat_snapshot.calls,\n\t pg_stat_snapshot.total_time,pg_stat_snapshot.min_time ,pg_stat_snapshot.max_time,pg_stat_snapshot.mean_time, pg_stat_snapshot.stddev_time ,\n\t pg_stat_snapshot.rows ,pg_stat_snapshot.shared_blks_hit ,pg_stat_snapshot.shared_blks_read ,pg_stat_snapshot.shared_blks_dirtied ,pg_stat_snapshot.shared_blks_written , \n pg_stat_snapshot.local_blks_hit , pg_stat_snapshot.local_blks_read , pg_stat_snapshot.local_blks_dirtied , pg_stat_snapshot.local_blks_written , \n\t pg_stat_snapshot.temp_blks_read , pg_stat_snapshot.temp_blks_written , pg_stat_snapshot.blk_read_time , pg_stat_snapshot.blk_write_time \t \n\t );\n\t\t \n END LOOP;\n\n PERFORM dblink_disconnect('LINK1'); \n\t\t\t\t\n\t END LOOP ;--FOR database_rec IN SELECT * FROM database WHERE endpoint_id = endpoint_rec.id \n \n END LOOP;\n\nRETURN TRUE; \nEND\n$$ LANGUAGE plpgsql;<\/code><\/pre>\n\u0412 \u0440\u0435\u0437\u0443\u043b\u0442\u0430\u0442 \u043d\u0430 \u0442\u043e\u0432\u0430, \u0441\u043b\u0435\u0434 \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e \u0432\u0440\u0435\u043c\u0435 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0442\u0430 pg_stat_history<\/b> \u0449\u0435 \u0438\u043c\u0430\u043c\u0435 \u043d\u0430\u0431\u043e\u0440 \u043e\u0442 \u0441\u043d\u0438\u043c\u043a\u0438 \u043d\u0430 \u0441\u044a\u0434\u044a\u0440\u0436\u0430\u043d\u0438\u0435\u0442\u043e \u043d\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0442\u0430 pg_stat_statements <\/b>\u043d\u0430 \u0446\u0435\u043b\u0435\u0432\u0430\u0442\u0430 \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u043d\u0438. <\/p>\n\u0421\u044a\u0449\u0438\u043d\u0441\u043a\u043e \u043e\u0442\u0447\u0438\u0442\u0430\u043d\u0435<\/h2>\n
\n\u0418\u0437\u043f\u043e\u043b\u0437\u0432\u0430\u0439\u043a\u0438 \u043f\u0440\u043e\u0441\u0442\u0438 \u0437\u0430\u044f\u0432\u043a\u0438, \u043c\u043e\u0436\u0435\u043c \u0434\u0430 \u043f\u043e\u043b\u0443\u0447\u0438\u043c \u0434\u043e\u0441\u0442\u0430 \u043f\u043e\u043b\u0435\u0437\u043d\u0438 \u0438 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u0438 \u043e\u0442\u0447\u0435\u0442\u0438.<\/p>\n
\u0410\u0433\u0440\u0435\u0433\u0438\u0440\u0430\u043d\u0438 \u0434\u0430\u043d\u043d\u0438 \u0437\u0430 \u0437\u0430\u0434\u0430\u0434\u0435\u043d \u043f\u0435\u0440\u0438\u043e\u0434 \u043e\u0442 \u0432\u0440\u0435\u043c\u0435<\/h2>\n
\u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0435<\/b><\/p>\nSELECT \n database_id , \n SUM(calls) AS calls ,SUM(total_time) AS total_time ,\n SUM(rows) AS rows , SUM(shared_blks_hit) AS shared_blks_hit,\n SUM(shared_blks_read) AS shared_blks_read ,\n SUM(shared_blks_dirtied) AS shared_blks_dirtied,\n SUM(shared_blks_written) AS shared_blks_written , \n SUM(local_blks_hit) AS local_blks_hit , \n SUM(local_blks_read) AS local_blks_read , \n SUM(local_blks_dirtied) AS local_blks_dirtied , \n SUM(local_blks_written) AS local_blks_written,\n SUM(temp_blks_read) AS temp_blks_read, \n SUM(temp_blks_written) temp_blks_written , \n SUM(blk_read_time) AS blk_read_time , \n SUM(blk_write_time) AS blk_write_time\nFROM \n pg_stat_history\nWHERE \n queryid IS NULL AND\n database_id = DATABASE_ID AND\n snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT\nGROUP BY database_id ;<\/code><\/pre>\n<\/p>\n
\u0412\u0440\u0435\u043c\u0435 \u043d\u0430 \u0431\u0430\u0437\u0430\u0442\u0430 \u0434\u0430\u043d\u043d\u0438<\/h4>\nto_char(interval '1 millisecond' * pg_total_stat_history_rec.total_time, 'HH24:MI:SS.MS')<\/p><\/blockquote>\n
<\/p>\n
I\/O \u0412\u0440\u0435\u043c\u0435<\/h4>\nto_char(interval '1 millisecond' * (pg_total_stat_history_rec.blk_read_time + pg_total_stat_history_rec.blk_write_time), 'HH24:MI:SS.MS')<\/p><\/blockquote>\n
TOP10 SQL \u043f\u043e \u043e\u0431\u0449\u043e \u0432\u0440\u0435\u043c\u0435<\/h3>\n
\u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0435<\/b><\/p>\nSELECT \n queryid , \n SUM(calls) AS calls ,\n SUM(total_time) AS total_time \t\nFROM \n pg_stat_history\nWHERE \n queryid IS NOT NULL AND \n database_id = DATABASE_ID AND\n snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT \nGROUP BY queryid \nORDER BY 3 DESC \nLIMIT 10<\/code><\/pre>\n-------------------------------------------------------------------------------------\n| TOP10 SQL \u041f\u041e \u041e\u0411\u0429\u041e \u0412\u0420\u0415\u041c\u0415 \u0417\u0410 \u0418\u0417\u041f\u042a\u041b\u041d\u0415\u041d\u0418\u0415\n| #| queryid| calls| calls %| total_time (ms) | dbtime %\n+----+-----------+-----------+-----------+--------------------------------+----------\n| 1| 821760255| 2| .00001|00:03:23.141( 203141.681 ms.)| 5.42\n| 2| 4152624390| 2| .00001|00:03:13.929( 193929.215 ms.)| 5.17\n| 3| 1484454471| 4| .00001|00:02:09.129( 129129.057 ms.)| 3.44\n| 4| 655729273| 1| .00000|00:02:01.869( 121869.981 ms.)| 3.25\n| 5| 2460318461| 1| .00000|00:01:33.113( 93113.835 ms.)| 2.48\n| 6| 2194493487| 4| .00001|00:00:17.377( 17377.868 ms.)| .46\n| 7| 1053044345| 1| .00000|00:00:06.156( 6156.352 ms.)| .16\n| 8| 3644780286| 1| .00000|00:00:01.063( 1063.830 ms.)| .03\n<\/pre>\nTOP10 SQL \u043f\u043e \u043e\u0431\u0449\u043e I\/O \u0432\u0440\u0435\u043c\u0435<\/h4>\n
\u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0435<\/b><\/p>\nSELECT \n queryid , \n SUM(calls) AS calls ,\n SUM(blk_read_time + blk_write_time) AS io_time\nFROM \n pg_stat_history\nWHERE \n queryid IS NOT NULL AND \n database_id = DATABASE_ID AND\n snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT\nGROUP BY queryid \nORDER BY 3 DESC \nLIMIT 10<\/code><\/pre>\n----------------------------------------------------------------------------------------\n| \u0422\u041e\u041f10 SQL \u041f\u041e \u041e\u0411\u0429\u041e \u0412\u0420\u0415\u041c\u0415 \u0417\u0410 \u0412\u0412\u041e\u0414\/\u0418\u0417\u0412\u041e\u0414\n| #| queryid| \u0438\u0437\u0432\u0438\u043a\u0432\u0430\u043d\u0438\u044f| % \u0438\u0437\u0432\u0438\u043a\u0432\u0430\u043d\u0438\u044f| \u0412\u0440\u0435\u043c\u0435 \u0437\u0430 I\/O (\u043c\u0441)|% \u0432\u0440\u0435\u043c\u0435 \u0437\u0430 I\/O \u043d\u0430 \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u043d\u0438\n+----+-----------+-----------+-----------+--------------------------------+-------------\n| 1| 4152624390| 2| .00001|00:08:31.616( 511616.592 \u043c\u0441.)| 31.06\n| 2| 821760255| 2| .00001|00:08:27.099( 507099.036 \u043c\u0441.)| 30.78\n| 3| 655729273| 1| .00000|00:05:02.209( 302209.137 \u043c\u0441.)| 18.35\n| 4| 2460318461| 1| .00000|00:04:05.981( 245981.117 \u043c\u0441.)| 14.93\n| 5| 1484454471| 4| .00001|00:00:39.144( 39144.221 \u043c\u0441.)| 2.38\n| 6| 2194493487| 4| .00001|00:00:18.182( 18182.816 \u043c\u0441.)| 1.10\n| 7| 1053044345| 1| .00000|00:00:16.611( 16611.722 \u043c\u0441.)| 1.01\n| 8| 3644780286| 1| .00000|00:00:00.436( 436.205 \u043c\u0441.)| .03\n<\/pre>\n\u0422\u041e\u041f10 SQL \u043f\u043e \u043c\u0430\u043a\u0441\u0438\u043c\u0430\u043b\u043d\u043e \u0432\u0440\u0435\u043c\u0435 \u043d\u0430 \u0438\u0437\u043f\u044a\u043b\u043d\u0435\u043d\u0438\u0435<\/h4>\n
\u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0435<\/b><\/p>\nSELECT \n id AS snapshotid , \n queryid , \n snapshot_timestamp , \n max_time \nFROM \n pg_stat_history \nWHERE \n queryid IS NOT NULL AND \n database_id = DATABASE_ID AND\n snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT\nORDER BY 4 DESC \nLIMIT 10<\/code><\/pre>\n<\/p>\n
-----------------------------------------------------------------------------------------\n| \u0422\u041e\u041f10 SQL \u041f\u041e \u041c\u0410\u041a\u0421\u0418\u041c\u0410\u041b\u041d\u041e \u0412\u0420\u0415\u041c\u0415 \u041d\u0410 \u0418\u0417\u041f\u042a\u041b\u041d\u0415\u041d\u0418\u0415\n| #| snapshot| snapshotID| queryid| max_time (\u043c\u0441)\n+----+------------------+-----------+-----------+----------------------------------------\n| 1| 05.04.2019 01:03| 4169| 655729273| 00:02:01.869( 121869.981 \u043c\u0441.)\n| 2| 04.04.2019 17:00| 4153| 821760255| 00:01:41.570( 101570.841 \u043c\u0441.)\n| 3| 04.04.2019 16:00| 4146| 821760255| 00:01:41.570( 101570.841 \u043c\u0441.)\n| 4| 04.04.2019 16:00| 4144| 4152624390| 00:01:36.964( 96964.607 \u043c\u0441.)\n| 5| 04.04.2019 17:00| 4151| 4152624390| 00:01:36.964( 96964.607 \u043c\u0441.)\n| 6| 05.04.2019 10:00| 4188| 1484454471| 00:01:33.452( 93452.150 \u043c\u0441.)\n| 7| 04.04.2019 17:00| 4150| 2460318461| 00:01:33.113( 93113.835 \u043c\u0441.)\n| 8| 04.04.2019 15:00| 4140| 1484454471| 00:00:11.892( 11892.302 \u043c\u0441.)\n| 9| 04.04.2019 16:00| 4145| 1484454471| 00:00:11.892( 11892.302 \u043c\u0441.)\n| 10| 04.04.2019 17:00| 4152| 1484454471| 00:00:11.892( 11892.302 \u043c\u0441.)\n<\/pre>\n\u0422\u041e\u041f10 SQL \u043f\u043e \u0447\u0435\u0442\u0435\u043d\u0435\/\u043f\u0438\u0441\u0430\u043d\u0435 \u043d\u0430 SHARED buffer<\/h4>\n
\u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0435<\/b><\/p>\nSELECT \n id AS snapshotid , \n queryid ,\n snapshot_timestamp , \n shared_blks_read , \n shared_blks_written \nFROM \n pg_stat_history\nWHERE \n queryid IS NOT NULL AND \n database_id = DATABASE_ID AND\n snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT AND\n ( shared_blks_read > 0 OR shared_blks_written > 0 )\nORDER BY 4 DESC , 5 DESC \nLIMIT 10<\/code><\/pre>\n--------------------------------------------------------------------------------------------\n| \u0422\u041e\u041f10 SQL \u041f\u041e \u0427\u0418\u0422\u0410\u041d\u0415\/\u0417\u0410\u041f\u0418\u0421 \u0412 \u0421\u041f\u041e\u0414\u0415\u041b\u0415\u041d \u0411\u0423\u0424\u0415\u0420\n| #| \u043c\u043e\u043c\u0435\u043d\u0442| snapshotID| queryid| \u043f\u0440\u043e\u0447\u0435\u0442\u0435\u043d\u0438 \u0441\u043f\u043e\u0434\u0435\u043b\u0435\u043d\u0438 \u0431\u043b\u043e\u043a\u043e\u0432\u0435| \u0437\u0430\u043f\u0438\u0441\u0430\u043d\u0438 \u0441\u043f\u043e\u0434\u0435\u043b\u0435\u043d\u0438 \u0431\u043b\u043e\u043a\u043e\u0432\u0435\n+----+------------------+-----------+-----------+---------------------+---------------------\n| 1| 04.04.2019 17:00| 4153| 821760255| 797308| 0\n| 2| 04.04.2019 16:00| 4146| 821760255| 797308| 0\n| 3| 05.04.2019 01:03| 4169| 655729273| 797158| 0\n| 4| 04.04.2019 16:00| 4144| 4152624390| 756514| 0\n| 5| 04.04.2019 17:00| 4151| 4152624390| 756514| 0\n| 6| 04.04.2019 17:00| 4150| 2460318461| 734117| 0\n| 7| 04.04.2019 17:00| 4155| 3644780286| 52973| 0\n| 8| 05.04.2019 01:03| 4168| 1053044345| 52818| 0\n| 9| 04.04.2019 15:00| 4141| 2194493487| 52813| 0\n| 10| 04.04.2019 16:00| 4147| 2194493487| 52813| 0\n--------------------------------------------------------------------------------------------\n<\/pre>\n\u0425\u0438\u0441\u0442\u043e\u0433\u0440\u0430\u043c\u0430 \u043d\u0430 \u0440\u0430\u0437\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435\u0442\u043e \u043d\u0430 \u0437\u0430\u044f\u0432\u043a\u0438\u0442\u0435 \u043f\u043e \u043c\u0430\u043a\u0441\u0438\u043c\u0430\u043b\u043d\u043e \u0432\u0440\u0435\u043c\u0435 \u0437\u0430 \u0438\u0437\u043f\u044a\u043b\u043d\u0435\u043d\u0438\u0435<\/h4>\n
\u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0438\u044f<\/b><\/p>\nSELECT \n MIN(max_time) AS hist_min , \n MAX(max_time) AS hist_max , \n (( MAX(max_time) - MIN(min_time) ) \/ hist_columns ) as hist_width\nFROM \n pg_stat_history \nWHERE \n queryid IS NOT NULL AND\n database_id = DATABASE_ID AND\n snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT ;\n\nSELECT \n SUM(calls) AS calls\nFROM \n pg_stat_history \nWHERE \n queryid IS NOT NULL AND\n database_id = DATABASE_ID AND\n snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT AND \n ( max_time >= hist_current_min AND max_time < hist_current_max ) ;\n<\/code><\/pre>\n|-----------------------------------------------------------------------------------------------\n| \u0425\u0418\u0421\u0422\u041e\u0413\u0420\u0410\u041c\u0410 \u041d\u0410 MAX_TIME\n| \u041e\u0411\u0429\u041e \u041f\u041e\u0417\u0412\u041e\u041d\u042f\u0412\u0410\u041d\u0418\u042f : 33851920\n| \u041c\u0418\u041d\u0418\u041c\u0410\u041b\u041d\u041e \u0412\u0420\u0415\u041c\u0415 : 00:00:01.063\n| \u041c\u0410\u041a\u0421\u0418\u041c\u0410\u041b\u041d\u041e \u0412\u0420\u0415\u041c\u0415 : 00:02:01.869\n---------------------------------------------------------------------------------\n| \u043c\u0438\u043d \u043f\u0440\u043e\u0434\u044a\u043b\u0436\u0438\u0442\u0435\u043b\u043d\u043e\u0441\u0442| \u043c\u0430\u043a\u0441 \u043f\u0440\u043e\u0434\u044a\u043b\u0436\u0438\u0442\u0435\u043b\u043d\u043e\u0441\u0442| \u043f\u043e\u0432\u0438\u043a\u0432\u0430\u043d\u0438\u044f\n+----------------------------------+----------------------------------+----------\n| 00:00:01.063( 1063.830 ms.) | 00:00:13.144( 13144.445 ms.) | 9\n| 00:00:13.144( 13144.445 ms.) | 00:00:25.225( 25225.060 ms.) | 0\n| 00:00:25.225( 25225.060 ms.) | 00:00:37.305( 37305.675 ms.) | 0\n| 00:00:37.305( 37305.675 ms.) | 00:00:49.386( 49386.290 ms.) | 0\n| 00:00:49.386( 49386.290 ms.) | 00:01:01.466( 61466.906 ms.) | 0\n| 00:01:01.466( 61466.906 ms.) | 00:01:13.547( 73547.521 ms.) | 0\n| 00:01:13.547( 73547.521 ms.) | 00:01:25.628( 85628.136 ms.) | 0\n| 00:01:25.628( 85628.136 ms.) | 00:01:37.708( 97708.751 ms.) | 4\n| 00:01:37.708( 97708.751 ms.) | 00:01:49.789( 109789.366 ms.) | 2\n| 00:01:49.789( 109789.366 ms.) | 00:02:01.869( 121869.981 ms.) | 0\n<\/pre>\n\u0422\u041e\u041f10 \u0421\u043d\u0438\u043c\u043a\u0438 \u043f\u043e \u0417\u0430\u044f\u0432\u043a\u0438 \u043d\u0430 \u0421\u0435\u043a\u0443\u043d\u0434\u0430<\/h4>\n
\u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0438\u044f<\/b><\/p>\n--pg_qps.sql\n--\u0418\u0437\u0447\u0438\u0441\u043b\u044f\u0432\u0430\u043d\u0435 \u043d\u0430 \u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0438\u044f \u043d\u0430 \u0412\u0442\u043e\u0440\u0430\nCREATE OR REPLACE FUNCTION pg_qps( pg_stat_history_id integer ) RETURNS double precision AS $$\nDECLARE\n pg_stat_history_rec record ;\n prev_pg_stat_history_id integer ;\n prev_pg_stat_history_rec record;\n total_seconds double precision ;\n result double precision;\nBEGIN \n result = 0 ;\n \n SELECT *\n INTO pg_stat_history_rec\n FROM \n pg_stat_history\n WHERE id = pg_stat_history_id ;\n\n IF pg_stat_history_rec.snapshot_timestamp IS NULL \n THEN\n RAISE EXCEPTION '\u0413\u0420\u0415\u0428\u041a\u0410 - \u041d\u0435 \u0435 \u043d\u0430\u043c\u0435\u0440\u0435\u043d\u0430 pg_stat_history \u0437\u0430 id = %',pg_stat_history_id;\n END IF ; \n \n --RAISE NOTICE 'pg_stat_history_id = % , snapshot_timestamp = %', pg_stat_history_id , \n pg_stat_history_rec.snapshot_timestamp ;\n \n SELECT \n MAX(id) \n INTO\n prev_pg_stat_history_id\n FROM\n pg_stat_history\n WHERE \n database_id = pg_stat_history_rec.database_id AND\n\tqueryid IS NULL AND\n\tid 0 \n THEN\n result = pg_stat_history_rec.calls \/ total_seconds ;\n ELSE\n result = 0 ; \n END IF;\n \n RETURN result ;\nEND\n$$ LANGUAGE plpgsql;\n\n\nSELECT \n id , \n snapshot_timestamp ,\n calls , \t\n total_time , \n ( select pg_qps( id )) AS QPS ,\n blk_read_time ,\n blk_write_time\nFROM \n pg_stat_history\nWHERE \n queryid IS NULL AND \n database_id = DATABASE_ID AND\n snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT AND\n ( select pg_qps( id )) IS NOT NULL \nORDER BY 5 DESC \nLIMIT 10\n<\/code><\/pre>\n|-----------------------------------------------------------------------------------------------\n| TOP10 \u0421\u043d\u0438\u043c\u043a\u0438 \u043f\u043e \u0431\u0440\u043e\u0439 \u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0438\u044f \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0438\n-----------------------------------------------------------------------------------------------------------------------------------------------\n| #| \u0441\u043d\u0438\u043c\u043a\u0430| ID \u043d\u0430 \u0441\u043d\u0438\u043c\u043a\u0430| \u043f\u043e\u0432\u0438\u043a\u0432\u0430\u043d\u0438\u044f| \u043e\u0431\u0449\u043e \u0432\u0440\u0435\u043c\u0435 \u0432 \u0411\u0414| QPS| I\/O \u0432\u0440\u0435\u043c\u0435| % I\/O \u0432\u0440\u0435\u043c\u0435\n+-----+------------------+-----------+-----------+----------------------------------+-----------+----------------------------------+-----------\n| 1| 04.04.2019 20:04| 4161| 5758631| 00:06:30.513( 390513.926 ms.)| 1573.396| 00:00:01.470( 1470.110 ms.)| .376\n| 2| 04.04.2019 17:00| 4149| 3529197| 00:11:48.830( 708830.618 ms.)| 980.332| 00:12:47.834( 767834.052 ms.)| 108.324\n| 3| 04.04.2019 16:00| 4143| 3525360| 00:10:13.492( 613492.351 ms.)| 979.267| 00:08:41.396( 521396.555 ms.)| 84.988\n| 4| 04.04.2019 21:03| 4163| 2781536| 00:03:06.470( 186470.979 ms.)| 785.745| 00:00:00.249( 249.865 ms.)| .134\n| 5| 04.04.2019 19:03| 4159| 2890362| 00:03:16.784( 196784.755 ms.)| 776.979| 00:00:01.441( 1441.386 ms.)| .732\n| 6| 04.04.2019 14:00| 4137| 2397326| 00:04:43.033( 283033.854 ms.)| 665.924| 00:00:00.024( 24.505 ms.)| .009\n| 7| 04.04.2019 15:00| 4139| 2394416| 00:04:51.435( 291435.010 ms.)| 665.116| 00:00:12.025( 12025.895 ms.)| 4.126\n| 8| 04.04.2019 13:00| 4135| 2373043| 00:04:26.791( 266791.988 ms.)| 659.179| 00:00:00.064( 64.261 ms.)| .024\n| 9| 05.04.2019 01:03| 4167| 4387191| 00:06:51.380( 411380.293 ms.)| 609.332| 00:05:18.847( 318847.407 ms.)| 77.507\n| 10| 04.04.2019 18:01| 4157| 1145596| 00:01:19.217( 79217.372 ms.)| 313.004| 00:00:01.319( 1319.676 ms.)| 1.666\n<\/pre>\n\u0427\u0430\u0441\u043e\u0432\u0430 \u0438\u0441\u0442\u043e\u0440\u0438\u044f \u043d\u0430 \u0438\u0437\u043f\u044a\u043b\u043d\u0435\u043d\u0438\u0435\u0442\u043e \u0441 QPS \u0438 I\/O \u0432\u0440\u0435\u043c\u0435<\/h4>\n
\u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0435<\/b><\/p>\nSELECT \n id , \n \u0432\u0440\u0435\u043c\u0435_\u043d\u0430_\u0441\u043d\u0438\u043c\u043a\u0430\u0442\u0430 ,\n \u043f\u043e\u0432\u0438\u043a\u0432\u0430\u043d\u0438\u044f , \t\n \u043e\u0431\u0449\u043e_\u0432\u0440\u0435\u043c\u0435 , \n ( select pg_qps( id )) AS QPS ,\n blk_read_time ,\n blk_write_time\nFROM \n pg_stat_history\nWHERE \n queryid IS NULL AND \n database_id = DATABASE_ID AND\n \u0432\u0440\u0435\u043c\u0435_\u043d\u0430_\u0441\u043d\u0438\u043c\u043a\u0430\u0442\u0430 BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT\nORDER BY 2\n<\/code><\/pre>\n|-----------------------------------------------------------------------------------------------\n| \u0418\u0421\u0422\u041e\u0420\u0418\u042f \u041d\u0410 \u0418\u0417\u041f\u042a\u041b\u041d\u0415\u041d\u0418\u0415 \u041f\u041e \u0427\u0410\u0421\u041e\u0412\u0415 \u0421 QueryPerSeconds \u0438 I\/O \u0432\u0440\u0435\u043c\u0435\n-----------------------------------------------------------------------------------------------------------------------------------------------\n| \u0418\u0421\u0422\u041e\u0420\u0418\u042f \u041d\u0410 \u041a\u0412\u041e\u0422\u0418\u0422\u0415 \u0417\u0410 \u0421\u0415\u041a\u0423\u041d\u0414\u0410\n| #| \u043c\u043e\u043c\u0435\u043d\u0442| snapshotID| \u043f\u043e\u0432\u0438\u043a\u0432\u0430\u043d\u0438\u044f| \u043e\u0431\u0449\u043e \u0432\u0440\u0435\u043c\u0435 \u0432 \u0411\u0414| QPS| I\/O \u0432\u0440\u0435\u043c\u0435| % I\/O \u0432\u0440\u0435\u043c\u0435\n+-----+------------------+-----------+-----------+----------------------------------+-----------+----------------------------------+-----------\n| 1| 04.04.2019 11:00| 4131| 3747| 00:00:00.835( 835.374 ms.)| 1.041| 00:00:00.000( .000 ms.)| .000\n| 2| 04.04.2019 12:00| 4133| 1002722| 00:01:52.419( 112419.376 ms.)| 278.534| 00:00:00.149( 149.105 ms.)| .133\n| 3| 04.04.2019 13:00| 4135| 2373043| 00:04:26.791( 266791.988 ms.)| 659.179| 00:00:00.064( 64.261 ms.)| .024\n| 4| 04.04.2019 14:00| 4137| 2397326| 00:04:43.033( 283033.854 ms.)| 665.924| 00:00:00.024( 24.505 ms.)| .009\n| 5| 04.04.2019 15:00| 4139| 2394416| 00:04:51.435( 291435.010 ms.)| 665.116| 00:00:12.025( 12025.895 ms.)| 4.126\n| 6| 04.04.2019 16:00| 4143| 3525360| 00:10:13.492( 613492.351 ms.)| 979.267| 00:08:41.396( 521396.555 ms.)| 84.988\n| 7| 04.04.2019 17:00| 4149| 3529197| 00:11:48.830( 708830.618 ms.)| 980.332| 00:12:47.834( 767834.052 ms.)| 108.324\n| 8| 04.04.2019 18:01| 4157| 1145596| 00:01:19.217( 79217.372 ms.)| 313.004| 00:00:01.319( 1319.676 ms.)| 1.666\n| 9| 04.04.2019 19:03| 4159| 2890362| 00:03:16.784( 196784.755 ms.)| 776.979| 00:00:01.441( 1441.386 ms.)| .732\n| 10| 04.04.2019 20:04| 4161| 5758631| 00:06:30.513( 390513.926 ms.)| 1573.396| 00:00:01.470( 1470.110 ms.)| .376\n| 11| 04.04.2019 21:03| 4163| 2781536| 00:03:06.470( 186470.979 ms.)| 785.745| 00:00:00.249( 249.865 ms.)| .134\n| 12| 04.04.2019 23:03| 4165| 1443155| 00:01:34.467( 94467.539 ms.)| 200.438| 00:00:00.015( 15.287 ms.)| .016\n| 13| 05.04.2019 01:03| 4167| 4387191| 00:06:51.380( 411380.293 ms.)| 609.332| 00:05:18.847( 318847.407 ms.)| 77.507\n| 14| 05.04.2019 02:03| 4171| 189852| 00:00:10.989( 10989.899 ms.)| 52.737| 00:00:00.539( 539.110 ms.)| 4.906\n| 15| 05.04.2019 03:01| 4173| 3627| 00:00:00.103( 103.000 ms.)| 1.042| 00:00:00.004( 4.131 ms.)| 4.010\n| 16| 05.04.2019 04:00| 4175| 3627| 00:00:00.085( 85.235 ms.)| 1.025| 00:00:00.003( 3.811 ms.)| 4.471\n| 17| 05.04.2019 05:00| 4177| 3747| 00:00:00.849( 849.454 ms.)| 1.041| 00:00:00.006( 6.124 ms.)| .721\n| 18| 05.04.2019 06:00| 4179| 3747| 00:00:00.849( 849.561 ms.)| 1.041| 00:00:00.000( .051 ms.)| .006\n| 19| 05.04.2019 07:00| 4181| 3747| 00:00:00.839( 839.416 ms.)| 1.041| 00:00:00.000( .062 ms.)| .007\n| 20| 05.04.2019 08:00| 4183| 3747| 00:00:00.846( 846.382 ms.)| 1.041| 00:00:00.000( .007 ms.)| .001\n| 21| 05.04.2019 09:00| 4185| 3747| 00:00:00.855( 855.426 ms.)| 1.041| 00:00:00.000( .065 ms.)| .008\n| 22| 05.04.2019 10:00| 4187| 3797| 00:01:40.150( 100150.165 ms.)| 1.055| 00:00:21.845( 21845.217 ms.)| 21.812\n<\/pre>\n\u0422\u0435\u043a\u0441\u0442 \u043d\u0430 \u0432\u0441\u0438\u0447\u043a\u0438 SQL-\u0437\u0430\u044f\u0432\u043a\u0438<\/h4>\n
\u0417\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0435<\/b><\/p>\n\u0418\u0417\u0411\u0415\u0420\u0418 \n queryid , \n query \n\u041e\u0422 \n pg_stat_history\n\u041a\u042a\u0414\u0415 \n queryid \u0415 \u041d\u0415 NULL \u0418 \n database_id = DATABASE_ID \u0418\n snapshot_timestamp \u041d\u0410\u041c\u0415\u0421\u0422\u041e BEGIN_TIMEPOINT \u0418 END_TIMEPOINT\n\u0413\u0420\u0423\u041f\u0418\u0420\u0410\u0419 \u041f\u041e queryid , query\n<\/code><\/pre>\n\u0420\u0435\u0437\u044e\u043c\u0435<\/h2>\n
\n\u041a\u0430\u043a\u0442\u043e \u043c\u043e\u0436\u0435 \u0434\u0430 \u0441\u0435 \u0432\u0438\u0434\u0438, \u0441 \u0434\u043e\u0441\u0442\u0430 \u043f\u0440\u043e\u0441\u0442\u0438 \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430 \u043c\u043e\u0436\u0435\u043c \u0434\u0430 \u043f\u043e\u043b\u0443\u0447\u0438\u043c \u0434\u043e\u0441\u0442\u0430 \u043f\u043e\u043b\u0435\u0437\u043d\u0430 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f \u0437\u0430 \u043d\u0430\u0442\u043e\u0432\u0430\u0440\u0435\u043d\u043e\u0441\u0442\u0442\u0430 \u0438 \u0441\u044a\u0441\u0442\u043e\u044f\u043d\u0438\u0435\u0442\u043e \u043d\u0430 \u0431\u0430\u0437\u0430\u0442\u0430. <\/p>\n
\u0417\u0430\u0431\u0435\u043b\u0435\u0436\u043a\u0430:<\/b>\u0410\u043a\u043e \u0432 \u0437\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0438\u044f\u0442\u0430 \u0444\u043e\u043a\u0443\u0441\u0438\u0440\u0430\u043c\u0435 queryid, \u0449\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u043c \u0438\u0441\u0442\u043e\u0440\u0438\u044f \u0437\u0430 \u043e\u0442\u0434\u0435\u043b\u043d\u043e \u0437\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0435 (\u0441 \u0446\u0435\u043b \u0441\u043f\u0435\u0441\u0442\u044f\u0432\u0430\u043d\u0435 \u043d\u0430 \u043c\u044f\u0441\u0442\u043e, \u043e\u0442\u0447\u0435\u0442\u0438\u0442\u0435 \u0437\u0430 \u043e\u0442\u0434\u0435\u043b\u043d\u043e \u0437\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0435 \u0441\u0430 \u043f\u0440\u043e\u043f\u0443\u0441\u043d\u0430\u0442\u0438).<\/p>\n
\u0418 \u0442\u0430\u043a\u0430, \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0442\u0435 \u0434\u0430\u043d\u043d\u0438 \u0437\u0430 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u043d\u043e\u0441\u0442\u0442\u0430 \u043d\u0430 \u0437\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0438\u044f\u0442\u0430 \u2014 \u043d\u0430\u043b\u0438\u0447\u043d\u0438 \u0438 \u0441\u044a\u0431\u0438\u0440\u0430\u043d\u0438.
\n\u041f\u044a\u0440\u0432\u0438\u044f\u0442 \u0435\u0442\u0430\u043f \u201e\u0441\u044a\u0431\u0438\u0440\u0430\u043d\u0435 \u043d\u0430 \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0434\u0430\u043d\u043d\u0438\u201c \u2014 \u0437\u0430\u0432\u044a\u0440\u0448\u0435\u043d.<\/p>\n
\u041c\u043e\u0436\u0435\u043c \u0434\u0430 \u043f\u0440\u0435\u043c\u0438\u043d\u0435\u043c \u043a\u044a\u043c \u0432\u0442\u043e\u0440\u0438\u044f \u0435\u0442\u0430\u043f \u2013 \u201e\u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u043d\u0430 \u043c\u0435\u0442\u0440\u0438\u043a\u0438\u0442\u0435 \u0437\u0430 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u043d\u043e\u0441\u0442\u201c.
\n![\"\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433](\"\/wp-content\/uploads\/2019\/04\/a893e49280d4cb425e4667a5c51d2397.jpeg\")
\n
\n\u041d\u043e \u0442\u043e\u0432\u0430 \u0432\u0435\u0447\u0435 \u0435 \u0441\u044a\u0432\u0441\u0435\u043c \u0434\u0440\u0443\u0433\u0430 \u0438\u0441\u0442\u043e\u0440\u0438\u044f.<\/b><\/p>\n
\u041f\u0440\u043e\u0434\u044a\u043b\u0436\u0435\u043d\u0438\u0435 \u0441\u043b\u0435\u0434\u0432\u0430\u2026<\/i>
\n
\u0418\u0437\u0442\u043e\u0447\u043d\u0438\u043a: habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"\u0418\u043d\u0436\u0435\u043d\u0435\u0440 \u2014 \u0432 \u043f\u0435\u0440\u0435\u0432\u043e\u0434\u0435 \u0441 \u043b\u0430\u0442\u044b\u043d\u0438 \u2014 \u0432\u0434\u043e\u0445\u043d\u043e\u0432\u0435\u043d\u043d\u044b\u0439. \u0418\u043d\u0436\u0435\u043d\u0435\u0440 \u043c\u043e\u0436\u0435\u0442 \u0432\u0441\u0451. (\u0441) \u0420.\u0414\u0438\u0437\u0435\u043b\u044c. \u042d\u043f\u0438\u0433\u0440\u0430\u0444\u044b. \u0418\u043b\u0438 \u0438\u0441\u0442\u043e\u0440\u0438\u044f \u043e \u0442\u043e\u043c, \u0437\u0430\u0447\u0435\u043c \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0442\u043e\u0440\u0443 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0441\u043f\u043e\u043c\u0438\u043d\u0430\u0442\u044c \u0441\u0432\u043e\u0435 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0441\u0442\u0441\u043a\u043e\u0435 \u043f\u0440\u043e\u0448\u043b\u043e\u0435. \u041f\u0440\u0435\u0434\u0438\u0441\u043b\u043e\u0432\u0438\u0435 \u0412\u0441\u0435 \u0438\u043c\u0435\u043d\u0430 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u044b. \u0421\u043e\u0432\u043f\u0430\u0434\u0435\u043d\u0438\u044f \u0441\u043b\u0443\u0447\u0430\u0439\u043d\u044b. \u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0441\u043e\u0431\u043e\u0439 \u0438\u0441\u043a\u043b\u044e\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043b\u0438\u0447\u043d\u043e\u0435 \u043c\u043d\u0435\u043d\u0438\u0435 \u0430\u0432\u0442\u043e\u0440\u0430. Disclaimer of warranties: \u0432 \u043f\u043b\u0430\u043d\u0438\u0440\u0443\u0435\u043c\u043e\u043c \u0446\u0438\u043a\u043b\u0435 \u0441\u0442\u0430\u0442\u0435\u0439 \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u043e\u0433\u043e \u0438 \u0442\u043e\u0447\u043d\u043e\u0433\u043e \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 \u0438 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":24168,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-32353","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 \u043d\u0430 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u043d\u043e\u0441\u0442\u0442\u0430 \u043d\u0430 \u0437\u0430\u043f\u0438\u0442\u0432\u0430\u043d\u0438\u044f\u0442\u0430 \u0432 PostgreSQL. \u0427\u0430\u0441\u0442 1 \u2014 \u0440\u0435\u043f\u043e\u0440\u0442\u0438\u0440\u0430\u043d\u0435 | ProHoster","description":"\u0418\u043d\u0436\u0435\u043d\u0435\u0440 \u2014 \u0432 \u043f\u0440\u0435\u0432\u043e\u0434 \u043e\u0442 \u043b\u0430\u0442\u0438\u043d\u0441\u043a\u0438 \u2014 \u0432\u0434\u044a\u0445\u043d\u043e\u0432\u0435\u043d. \u0418\u043d\u0436\u0435\u043d\u0435\u0440\u044a\u0442 \u043c\u043e\u0436\u0435 \u0432\u0441\u0438\u0447\u043a\u043e. (\u0441) \u0420.\u0414\u0438\u0437\u0435\u043b. \u0415\u043f\u0438\u0433\u0440\u0430\u0444\u0438.","canonical_url":"https:\/\/prohoster.info\/bg\/blog\/administrirovanie\/monitoring-proizvoditelnosti-zaprosov-postgresql-chast-1-reporting","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"bg_BG","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 PostgreSQL. \u0427\u0430\u0441\u0442\u044c 1 \u2014 \u0440\u0435\u043f\u043e\u0440\u0442\u0438\u043d\u0433 | ProHoster","og:description":"\u0418\u043d\u0436\u0435\u043d\u0435\u0440 \u2014 \u0432 \u043f\u0435\u0440\u0435\u0432\u043e\u0434\u0435 \u0441 \u043b\u0430\u0442\u044b\u043d\u0438 \u2014 \u0432\u0434\u043e\u0445\u043d\u043e\u0432\u0435\u043d\u043d\u044b\u0439. \u0418\u043d\u0436\u0435\u043d\u0435\u0440 \u043c\u043e\u0436\u0435\u0442 \u0432\u0441\u0451. (\u0441) \u0420.\u0414\u0438\u0437\u0435\u043b\u044c. \u042d\u043f\u0438\u0433\u0440\u0430\u0444\u044b.","og:url":"https:\/\/prohoster.info\/bg\/blog\/administrirovanie\/monitoring-proizvoditelnosti-zaprosov-postgresql-chast-1-reporting","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T18:46:32+00:00","article:modified_time":"2019-10-31T18:46:32+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"32353","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-21 10:28:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 19:13:42","updated":"2026-01-21 10:28:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/bg\/wp-json\/wp\/v2\/posts\/32353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/bg\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/bg\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bg\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bg\/wp-json\/wp\/v2\/comments?post=32353"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/bg\/wp-json\/wp\/v2\/posts\/32353\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bg\/wp-json\/wp\/v2\/media\/24168"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/bg\/wp-json\/wp\/v2\/media?parent=32353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/bg\/wp-json\/wp\/v2\/categories?post=32353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/bg\/wp-json\/wp\/v2\/tags?post=32353"}],"curies":[{"name":"\u0432\u043f","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433](\"\/wp-content\/uploads\/2019\/04\/9a2640267ea05006b94e03642b864ddc.jpeg\")