-
Notifications
You must be signed in to change notification settings - Fork 1
CSV Reference
no0p edited this page Oct 15, 2014
·
2 revisions
txid_current, measured_at
"773166","2014-07-29 01:30:36.858769-07"
db_name, schema_name, relname, reloid, relkind, relpersistence, relam, relpages, reltuples, relallvisible, relchecks, relhaspkey, relhastriggers, rel_size, rel_index_size, measured_at
"postgres","public","x","22931","r","p",,"0","0","0","0","f","f","0","0","2014-07-29 01:31:33.308087-07"
db_name, datconnlimit, datfrozenxid
"postgres","-1","710"
db_name, schema_name, table_name, column_name, null_frac, avg_width, n_distinct, most_common_vals, most_common_freqs, correlation, measured_at
"relsys_development","public","users","email","0","14","-1",,,,"2014-07-29 01:31:34.401461-07"
db_name, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_deleted, tup_updated, conflicts, temp_files, temp_bytes, deadlocks, blk_read_time, blk_write_time, stats_reset, measured_at
"postgres","1","6686","0","1717","134218","1043080","55220","0","0","0","0","0","0","0","0","0","2014-07-24 22:56:03.104434-07","2014-07-29 01:31:33.322878-07"
page_size, total_pages, available_pages, num_online_processors, one_min_load_avg, swap_total, swap_free, cached, buffers, swap_cached
4096,974025,252492,4,1.140000,4038652,4030860,0,126640,1274696
fsname, mntdir, mnt_type, mnt_opts, blksize, fragsize, blks_in_frags, blk_free, blk_avail
/dev/sda1,/,ext4,"rw,errors=remount-ro",4096,4096,60506726,49835042,46755721
db_name, pid, usename, client_addr, backend_start, query_start, state, state_change, application_name, query, lock_type, lock_mode, lock_relation, lock_page, lock_tuple, lock_vxid, lock_txid, lock_granted, lock_holder_vxid, measured_at
"postgres","29246","postgres",,"2014-07-29 01:33:28.927757-07",,,,"","","virtualxid","ExclusiveLock",,,,"3/90",,"true","3/90","2014-07-29 01:33:28.947513-07"
username, application_name, client_addr, client_hostname, client_port, backend_start, state, sent_location, write_location, flush_location, replay_location, sync_priority, sync_state, current_xlog, measured_at
checkpoints_timed, checkpoints_req, checkpoint_write_time, checkpoint_sync_time, buffers_checkpoint, buffers_clean, maxwritten_clean, buffers_backend, buffers_backend_fsync, buffers_alloc, stats_reset, measured_at
"71","0","3","0","0","0","0","0","0","9744","2014-07-24 22:56:02.16601-07","2014-07-29 01:31:01.900609-07"
userid, dbid, query, calls, total_time, rows, shared_blks_hit, shared_blks_read, shared_blks_dirtied, shared_blks_written, local_blks_hit, local_blks_read, local_blks_dirtied, local_blks_written, temp_blks_read, temp_blks_written, blk_read_time, blk_write_time, measured_at
db_name, schemaname, relname, relid, 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, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze, vacuum_count, autovacuum_count, analyze_count, autoanalyze_count, measured_at
"postgres","public","x","22931","0","0",,,"0","0","0","0","0","0",,,,,"0","0","0","0","2014-07-29 01:31:33.340838-07"
db_name, schemaname, name, indexrelid, idx_scan, idx_tup_read, idx_tup_fetch, measured_at
"relsys_development","public","unique_schema_migrations","22952","0","0","0","2014-07-29 01:31:34.434593-07"
db_name, schemaname, name, indexrelid, idx_blks_read, idx_blks_hit, measured_at
"relsys_development","public","unique_schema_migrations","22952","0","0","2014-07-29 01:31:34.440959-07"
db_name, schemaname, relname, relid, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit, measured_at
"benchy","public","pgbench_accounts","22941","0","0",,,,,,,"2014-07-29 01:31:37.682348-07"
db_name, funcoid, schemaname, funcname, calls, total_time, self_time, measured_at