-
Size of opm database
Sizes of databases
-
Connections by type on opm database
Connections by type including idle ones
-
Affected tuples per operation on opm database
Affected rows on databases grouped by statement family
-
Cache hit/miss ratio on opm database
Per database cache hit/miss ratio
-
Commits/Rollbacks per second on opm database
Number of commits / rollbacks per second and number of backends by database
-
Write ratio on opm database
Write ratio on databases excluding templates and postgres
-
Read tuples on opm database
Show entries returned from the index and live rows fetched from the table. The latter will be less if any dead or not-yet-committed rows are fetched using the index
-
Connections on opm database
Number of clients connected to a database
-
Number of deadlocks on opm database
Number of deadlocks detected in this database
-
Number of canceled queries on opm database
Number of queries canceled due to conflicts with recovery in this database. [Conflicts occur only on standby servers]
-
Number of temporary files on opm database
Number of temporary files created by queries per database.
-
Size of temporary data on opm database
Amount of data written to temporary files created by queries per database.
-
Conflicts per type on opm database
Per database statistics about query cancels occurring due to conflicts with recovery on standby servers.
NO DATASET
-
Statements statistics on opm database
Top N statistics about slowest or most used queries
Query Calls Avg. time Total time Rows Temp read Temp write UPDATE pgbench_branches SET bbalance = bbalance + ? WHERE bid = ?; 18000 0.054s 16m25s 18000 0 0 UPDATE pgbench_tellers SET tbalance = tbalance + ? WHERE tid = ?; 18000 0.047s 14m15s 18000 0 0 UPDATE pgbench_accounts SET abalance = abalance + ? WHERE aid = ?; 18000 0s 2.139s 18000 0 0 copy pgbench_accounts from stdin 3 0.426s 1.281s 300000 0 0 SELECT abalance FROM pgbench_accounts WHERE aid = ?; 24000 0s 0.796s 24000 0 0 COPY (SELECT date_trunc('seconds'. now()). category. name. setting. unit. context. source FROM pg_settings ORDER BY category.name) TO STDOUT CSV DELIMITER ';'; 35 0.013s 0.488s 7980 0 0 alter table pgbench_accounts add primary key (aid) 3 0.159s 0.477s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). checkpoints_timed. checkpoints_req. checkpoint_write_time. checkpoint_sync_time. buffers_checkpoint. buffers_clean. maxwritten_clean. buffers_backend. buffers_backend_fsync. buffers_alloc. date_trunc('seconds'. stats_reset) AS stats_reset FROM pg_stat_bgwriter ) TO STDOUT CSV DELIMITER ';'; 36 0.012s 0.447s 36 0 0 INSERT INTO pgbench_history (tid. bid. aid. delta. mtime) VALUES (?. ?. ?. ?. CURRENT_TIMESTAMP); 18000 0s 0.405s 18000 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). relname. 'CREATE INDEX idx_' || relname || '_' || array_to_string(column_name_list. '_') || ' ON ' || conrelid || ' (' || array_to_string(column_name_list. '.') || ')' AS ddl FROM (SELECT DISTINCT conrelid. array_agg(attname) AS column_name_list. array_agg(attnum) AS column_list FROM pg_attribute JOIN (SELECT conrelid::regclass. conname. unnest(conkey) AS column_index FROM (SELECT DISTINCT conrelid. conname. conkey FROM pg_constraint JOIN pg_class ON pg_class.oid = pg_constraint.conrelid JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE nspname !~ '^pg_' AND nspname <> 'information_schema' ) fkey ) fkey ON fkey.conrelid = pg_attribute.attrelid AND fkey.column_index = pg_attribute.attnum 35 0.011s 0.390s 91 0 0 COPY (SELECT date_trunc('seconds'. now()). spcname. pg_tablespace_size(spcname). CASE WHEN pg_tablespace_location(oid) = '' THEN CASE WHEN spcname = 'pg_default' THEN (select setting from pg_settings where name='data_directory')||'/base' ELSE (select setting from pg_settings where name='data_directory')||'/global' END ELSE pg_tablespace_location(oid) END as tablespace_location FROM pg_tablespace ORDER BY spcname) TO STDOUT CSV DELIMITER ';'; 35 0.010s 0.372s 140 0 0 vacuum analyze pgbench_accounts 3 0.114s 0.345s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). n.nspname. c.relname. c.relkind. c.reltuples. c.relpages. pg_relation_size(c.oid) FROM pg_class c. pg_namespace n WHERE n.oid=c.relnamespace AND n.nspname <> 'information_schema' AND n.nspname <> 'pg_catalog' ORDER BY n.nspname. c.relname) TO STDOUT CSV DELIMITER ';'; 35 0.007s 0.269s 1437 0 0 vacuum pgbench_branches 8 0.031s 0.255s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). datid. datname. pg_database_size(datid) AS size FROM pg_stat_database ORDER BY datname) TO STDOUT CSV DELIMITER ';'; 36 0.007s 0.253s 216 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). schemaname. relname. indexrelname. pg_get_indexdef(pg_stat_user_indexes.indexrelid) FROM pg_stat_user_indexes INNER JOIN pg_index ON pg_index.indexrelid = pg_stat_user_indexes.indexrelid WHERE NOT indexrelname ILIKE 'fki%' AND NOT indexrelname ILIKE 'pk%' AND indisunique = FALSE AND idx_scan = 0 ORDER BY schemaname. relname. indexrelname) TO STDOUT CSV DELIMITER ';'; 35 0.007s 0.248s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_statio_user_tables WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 35 0.006s 0.220s 121 0 0 COPY (SELECT date_trunc('seconds'. now()). r.rolname. d.datname. regexp_replace(regexp_replace(query. E'[\s\n]+'. ' '. 'g'). E';'. '#SEMICOLON#'. 'g'). calls. total_time. rows. shared_blks_hit. shared_blks_read. shared_blks_written. local_blks_hit. local_blks_read. local_blks_written. temp_blks_read. temp_blks_written FROM pg_stat_statements q. pg_database d. pg_roles r WHERE q.userid=r.oid and q.dbid=d.oid ORDER BY r.rolname. d.datname) TO STDOUT CSV DELIMITER ';'; 16 0.012s 0.205s 2302 0 0 vacuum analyze pgbench_branches 3 0.062s 0.188s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). relid. schemaname. relname. seq_scan. seq_tup_read. idx_scan. idx_tup_fetch. n_tup_ins. n_tup_upd. n_tup_del. n_tup_hot_upd. n_live_tup. n_dead_tup. date_trunc('seconds'. last_vacuum) AS last_vacuum. date_trunc('seconds'. last_autovacuum) AS last_autovacuum. date_trunc('seconds'.last_analyze) AS last_analyze. date_trunc('seconds'.last_autoanalyze) AS last_autoanalyze. vacuum_count. autovacuum_count. analyze_count. autoanalyze_count FROM pg_stat_user_tables WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 35 0.004s 0.156s 121 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_stat_user_functions WHERE schemaname <> 'information_schema' ORDER BY schemaname. funcname) TO STDOUT CSV DELIMITER ';'; 35 0.004s 0.154s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). r.rolname. d.datname. regexp_replace(regexp_replace(query. E'[\s\n]+'. ' '. 'g'). E';'. 'SEMICOLON'. 'g'). calls. total_time. rows. shared_blks_hit. shared_blks_read. shared_blks_written. local_blks_hit. local_blks_read. local_blks_written. temp_blks_read. temp_blks_written FROM pg_stat_statements q. pg_database d. pg_roles r WHERE q.userid=r.oid and q.dbid=d.oid ORDER BY r.rolname. d.datname) TO STDOUT CSV DELIMITER ';'; 13 0.011s 0.153s 1617 0 0 alter table pgbench_branches add primary key (bid) 3 0.050s 0.153s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_statio_user_indexes WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 35 0.004s 0.145s 91 0 0 COPY (SELECT date_trunc('seconds'. now()). count(*) AS num_file. pg_xlogfile_name(pg_current_xlog_location()) AS current. sum(is_recycled::int) AS is_recycled. sum((NOT is_recycled)::int) AS written. CASE WHEN max_wal1 > max_wal2 THEN max_wal1 ELSE max_wal2 END AS max_wal FROM ( SELECT file > first_value(file) OVER w AS is_recycled .1 + ( current_setting('checkpoint_segments')::float4 * ( 2 + current_setting('checkpoint_completion_target')::float4 )) AS max_wal1. 1 + current_setting('wal_keep_segments')::float4 + current_setting('checkpoint_segments')::float4 AS max_wal2 FROM pg_ls_dir('pg_xlog') as file WHERE file ~ '^[0-9A-F]{24}$' WINDOW w AS ( ORDER BY (pg_stat_file('pg_xlog/'||file)).modification DESC ) ) AS t GROUP BY 6 ) TO STDOUT CSV DELIMITER ';'; 35 0.003s 0.131s 35 0 0 alter table pgbench_tellers add primary key (tid) 3 0.040s 0.121s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_xact_user_tables WHERE schemaname <> 'information_schema' ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';'; 35 0.003s 0.111s 121 0 0 COPY (SELECT date_trunc('seconds'. now()). COUNT(*) AS total. coalesce(SUM((state NOT LIKE 'idle%')::integer). 0) AS active. coalesce(SUM(waiting::integer). 0) AS waiting. coalesce(SUM((state = 'idle in transaction')::integer). 0) AS idle_in_xact. datname FROM pg_stat_activity WHERE pid <> pg_backend_pid() GROUP BY datname) TO STDOUT CSV DELIMITER ';'; 36 0.002s 0.101s 10 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_stat_user_indexes WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 35 0.002s 0.100s 91 0 0 COPY (SELECT date_trunc('seconds'. now()). r.rolname. d.datname. regexp_replace(regexp_replace(query. E'[ \n]+'. ' '. 'g'). E';'. ';'. 'g'). calls. total_time. rows. shared_blks_hit. shared_blks_read. shared_blks_written. local_blks_hit. local_blks_read. local_blks_written. temp_blks_read. temp_blks_written FROM pg_stat_statements q. pg_database d. pg_roles r WHERE q.userid=r.oid and q.dbid=d.oid ORDER BY r.rolname. d.datname) TO STDOUT CSV DELIMITER ';'; 5 0.018s 0.090s 762 0 0 create extension pg_stat_statements; 1 0.089s 0.089s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). pid. usesysid. usename. application_name. client_addr. client_hostname. client_port. date_trunc('seconds'. backend_start) AS backend_start. state. pg_current_xlog_location() AS master_location. sent_location. write_location. flush_location. replay_location. sync_priority. sync_state FROM pg_stat_replication ORDER BY application_name) TO STDOUT CSV DELIMITER ';'; 36 0.002s 0.084s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_xact_user_functions WHERE schemaname <> 'information_schema' ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';'; 35 0.002s 0.075s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_database_conflicts ORDER BY datname) TO STDOUT CSV DELIMITER ';'; 36 0.002s 0.073s 216 0 0 vacuum analyze pgbench_tellers 3 0.021s 0.066s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_statio_user_sequences WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 35 0.001s 0.063s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). 'lock_granted'::text as label. granted. count(granted) as count FROM pg_locks GROUP BY granted) TO STDOUT CSV DELIMITER ';'; 35 0.001s 0.059s 42 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). pg_get_indexdef(indexrelid) AS contained. pg_get_indexdef(index_backward) AS container FROM ( SELECT indexrelid. indrelid. array_to_string(indkey.'+') AS colindex. lag(array_to_string(indkey.'+')) OVER search_window AS colindexbackward. lag(indexrelid) OVER search_window AS index_backward FROM pg_index WINDOW search_window AS (PARTITION BY indrelid ORDER BY array_to_string(indkey.'+') DESC) ) AS tmp WHERE colindexbackward LIKE (colindex || '+%')) TO STDOUT CSV DELIMITER ';'; 35 0.001s 0.055s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). datid. datname. numbackends. xact_commit. xact_rollback. blks_read. blks_hit. tup_returned. tup_fetched. tup_inserted. tup_updated. tup_deleted. conflicts. date_trunc('seconds'. stats_reset) AS stats_reset. temp_files. temp_bytes. deadlocks. blk_read_time. blk_write_time FROM pg_stat_database ORDER BY datname) TO STDOUT CSV DELIMITER ';'; 36 0.001s 0.049s 216 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). 'lock_mode'::text as label. mode. count(mode) as count FROM pg_locks GROUP BY mode) TO STDOUT CSV DELIMITER ';'; 35 0.001s 0.048s 84 0 0 create table pgbench_branches(bid int not null.bbalance int.filler char(88)) with (fillfactor=100) 3 0.012s 0.037s 0 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). 'lock_type'::text as label. locktype. count(locktype) as count FROM pg_locks GROUP BY locktype) TO STDOUT CSV DELIMITER ';'; 35 0s 0.028s 84 0 0 vacuum pgbench_tellers 8 0.003s 0.026s 0 0 0 SELECT setting FROM pg_settings WHERE name IN (?.?.?) ORDER BY name; 9 0.002s 0.018s 27 0 0 COPY (SELECT date_trunc('seconds'. now()). r.rolname. d.datname. regexp_replace(regexp_replace(query. E'[ \n]+'. ' '. 'g'). E';'. '#SEMICOLON#'. 'g'). calls. total_time. rows. shared_blks_hit. shared_blks_read. shared_blks_written. local_blks_hit. local_blks_read. local_blks_written. temp_blks_read. temp_blks_written FROM pg_stat_statements q. pg_database d. pg_roles r WHERE q.userid=r.oid and q.dbid=d.oid ORDER BY r.rolname. d.datname) TO STDOUT CSV DELIMITER ';'; 1 0.017s 0.018s 147 0 0 BEGIN; 18000 0s 0.017s 0 0 0 "SELECT n.nspname as ""Schema"". c.relname as ""Name"". CASE c.relkind WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? END as ""Type"". pg_catalog.pg_get_userbyid(c.relowner) as ""Owner"" FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN (?.?.?.?.?.?) AND n.nspname <> ? AND n.nspname <> ? AND n.nspname !~ ? AND pg_catalog.pg_table_is_visible(c.oid) ORDER BY 1.2;" 9 0.001s 0.017s 31 0 0 END; 18000 0s 0.016s 0 0 0 SELECT n.nspname||?||p.proname FROM pg_proc p. pg_namespace n WHERE p.pronamespace=n.oid AND n.nspname NOT IN (?. ?); 9 0.001s 0.014s 18 0 0 vacuum analyze pgbench_history 3 0.004s 0.013s 0 0 0 COPY (SELECT date_trunc(?. now()). r.rolname. d.datname. regexp_replace(regexp_replace(query. ?. ?. ?). ?. ?. ?). calls. total_time. rows. shared_blks_hit. shared_blks_read. shared_blks_written. local_blks_hit. local_blks_read. local_blks_written. temp_blks_read. temp_blks_written FROM pg_stat_statements q. pg_database d. pg_roles r WHERE q.userid=r.oid and q.dbid=d.oid ORDER BY r.rolname. d.datname) TO STDOUT CSV DELIMITER ';'; 1 0.009s 0.010s 132 0 0 select * from pg_stat_statements; 1 0.004s 0.004s 201 0 0 SELECT pg_catalog.quote_ident(c.relname) FROM pg_catalog.pg_class c WHERE c.relkind IN (?) AND substring(pg_catalog.quote_ident(c.relname).?.?)=? AND pg_catalog.pg_table_is_visible(c.oid) AND c.relnamespace <> (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = ?) UNION SELECT pg_catalog.quote_ident(n.nspname) || ? FROM pg_catalog.pg_namespace n WHERE substring(pg_catalog.quote_ident(n.nspname) || ?.?.?)=? AND (SELECT pg_catalog.count(*) FROM pg_catalog.pg_namespace WHERE substring(pg_catalog.quote_ident(nspname) || ?.?.?) = substring(?.?.pg_catalog.length(pg_catalog.quote_ident(nspname))+?)) > ? UNION SELECT pg_catalog.quote_ident(n.nspname) || ? || pg_catalog.quote_ident(c.relname) FROM pg_catalog.pg_class c. pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND c.relkind IN (?) AND substring(pg_catalog.quote_ident(n.nspname) || ? || pg_catalog.quote_ident(c.relname).?.?)=? AND substring(pg_catalog.quote_ident(n.nspname) || ?.?.?) = substring(?.?.pg_catalog.length(pg_catalog.quote_ident(n.nspname 7 0s 0.004s 16 0 0 drop table pgbench_tellers cascade; 2 0.001s 0.003s 0 0 0 create table pgbench_history(tid int.bid int.aid int.delta int.mtime timestamp.filler char(22)) 3 0.001s 0.003s 0 0 0 truncate pgbench_history 8 0s 0.003s 0 0 0 drop table pgbench_accounts cascade; 2 0.001s 0.003s 0 0 0 create table pgbench_tellers(tid int not null.bid int.tbalance int.filler char(84)) with (fillfactor=100) 3 0s 0.003s 0 0 0 create table pgbench_accounts(aid int not null.bid int.abalance int.filler char(84)) with (fillfactor=100) 3 0s 0.002s 0 0 0 drop table pgbench_branches cascade; 2 0s 0.002s 0 0 0 SELECT datname FROM pg_database WHERE NOT datistemplate AND datallowconn; 44 0s 0.002s 176 0 0 SELECT nspname FROM pg_namespace WHERE nspname !~ ? AND nspname <> ? ORDER BY 1 9 0s 0.001s 9 0 0 truncate pgbench_accounts 3 0s 0.001s 0 0 0 drop table pgbench_history cascade; 2 0s 0.001s 0 0 0 SELECT ? FROM pg_proc p. pg_namespace n WHERE p.proname=? AND p.pronamespace=n.oid; 11 0s 0.001s 11 0 0 drop table if exists pgbench_branches 3 0s 0.001s 0 0 0 insert into pgbench_tellers(tid.bid.tbalance) values (?.?.?) 30 0s 0.001s 30 0 0 SELECT version(); 9 0s 0.000s 9 0 0 select count(*) from pgbench_branches 8 0s 0.000s 8 0 0 insert into pgbench_branches(bid.bbalance) values(?.?) 3 0s 0.000s 3 0 0 SELECT extname FROM pg_extension; 9 0s 0.000s 18 0 0 drop table if exists pgbench_history 3 0s 0.000s 0 0 0 SELECT count(tgname) FROM pg_trigger WHERE NOT tgisinternal; 9 0s 0.000s 9 0 0 drop table if exists pgbench_tellers 3 0s 0.000s 0 0 0 drop table if exists pgbench_accounts 3 0s 0.000s 0 0 0 commit 6 0s 0.000s 0 0 0 begin 6 0s 0.000s 0 0 0 -
Database opm
- 2.88 GB Total size
- 2 Installed extensions (plpgsql,hstore)
- 3 Schemas (pr_grapher,public,wh_nagios)
- - Last manual vacuum
- - Last manual analyze
- 101 Stored procedures
- 2 Triggers