Created
January 2, 2014 18:36
-
-
Save senior/8224147 to your computer and use it in GitHub Desktop.
1.6.0 differential benchmark
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-[ RECORD 1 ]-----+------------------------------ | |
relid | 405164 | |
schemaname | public | |
relname | resource_params | |
seq_scan | 0 | |
seq_tup_read | 0 | |
idx_scan | 0 | |
idx_tup_fetch | 0 | |
n_tup_ins | 102106 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 102093 | |
n_dead_tup | 0 | |
last_vacuum | | |
last_autovacuum | | |
last_analyze | | |
last_autoanalyze | 2014-01-02 11:43:48.527536-06 | |
vacuum_count | 0 | |
autovacuum_count | 0 | |
analyze_count | 0 | |
autoanalyze_count | 5 | |
-[ RECORD 2 ]-----+------------------------------ | |
relid | 405426 | |
schemaname | public | |
relname | catalogs | |
seq_scan | 345 | |
seq_tup_read | 52078 | |
idx_scan | 403806 | |
idx_tup_fetch | 402752 | |
n_tup_ins | 527 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 486 | |
n_dead_tup | 41 | |
last_vacuum | | |
last_autovacuum | | |
last_analyze | | |
last_autoanalyze | 2014-01-02 11:45:01.785107-06 | |
vacuum_count | 0 | |
autovacuum_count | 0 | |
analyze_count | 0 | |
autoanalyze_count | 3 | |
-[ RECORD 3 ]-----+------------------------------ | |
relid | 405185 | |
schemaname | public | |
relname | schema_migrations | |
seq_scan | 0 | |
seq_tup_read | 0 | |
idx_scan | 2 | |
idx_tup_fetch | 40 | |
n_tup_ins | 0 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 0 | |
n_dead_tup | 0 | |
last_vacuum | | |
last_autovacuum | | |
last_analyze | | |
last_autoanalyze | | |
vacuum_count | 0 | |
autovacuum_count | 0 | |
analyze_count | 0 | |
autoanalyze_count | 0 | |
-[ RECORD 4 ]-----+------------------------------ | |
relid | 405304 | |
schemaname | public | |
relname | latest_reports | |
seq_scan | 0 | |
seq_tup_read | 0 | |
idx_scan | 0 | |
idx_tup_fetch | 0 | |
n_tup_ins | 0 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 0 | |
n_dead_tup | 0 | |
last_vacuum | | |
last_autovacuum | | |
last_analyze | | |
last_autoanalyze | | |
vacuum_count | 0 | |
autovacuum_count | 0 | |
analyze_count | 0 | |
autoanalyze_count | 0 | |
-[ RECORD 5 ]-----+------------------------------ | |
relid | 405248 | |
schemaname | public | |
relname | resource_events | |
seq_scan | 0 | |
seq_tup_read | 0 | |
idx_scan | 0 | |
idx_tup_fetch | 0 | |
n_tup_ins | 0 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 0 | |
n_dead_tup | 0 | |
last_vacuum | | |
last_autovacuum | | |
last_analyze | | |
last_autoanalyze | | |
vacuum_count | 0 | |
autovacuum_count | 0 | |
analyze_count | 0 | |
autoanalyze_count | 0 | |
-[ RECORD 6 ]-----+------------------------------ | |
relid | 405323 | |
schemaname | public | |
relname | resource_params_cache | |
seq_scan | 6 | |
seq_tup_read | 16132 | |
idx_scan | 959372 | |
idx_tup_fetch | 598996 | |
n_tup_ins | 18328 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 15487 | |
n_dead_tup | 1837 | |
last_vacuum | | |
last_autovacuum | 2014-01-02 11:40:47.142193-06 | |
last_analyze | | |
last_autoanalyze | 2014-01-02 11:43:52.215253-06 | |
vacuum_count | 0 | |
autovacuum_count | 2 | |
analyze_count | 0 | |
autoanalyze_count | 4 | |
-[ RECORD 7 ]-----+------------------------------ | |
relid | 405363 | |
schemaname | public | |
relname | catalog_resources | |
seq_scan | 189 | |
seq_tup_read | 40034172 | |
idx_scan | 1674 | |
idx_tup_fetch | 173350 | |
n_tup_ins | 402179 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 399113 | |
n_dead_tup | 0 | |
last_vacuum | | |
last_autovacuum | | |
last_analyze | | |
last_autoanalyze | 2014-01-02 11:46:04.735667-06 | |
vacuum_count | 0 | |
autovacuum_count | 0 | |
analyze_count | 0 | |
autoanalyze_count | 6 | |
-[ RECORD 8 ]-----+------------------------------ | |
relid | 405192 | |
schemaname | public | |
relname | certname_facts | |
seq_scan | 0 | |
seq_tup_read | 0 | |
idx_scan | 0 | |
idx_tup_fetch | 0 | |
n_tup_ins | 0 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 0 | |
n_dead_tup | 0 | |
last_vacuum | | |
last_autovacuum | | |
last_analyze | | |
last_autoanalyze | | |
vacuum_count | 0 | |
autovacuum_count | 0 | |
analyze_count | 0 | |
autoanalyze_count | 0 | |
-[ RECORD 9 ]-----+------------------------------ | |
relid | 405212 | |
schemaname | public | |
relname | certname_facts_metadata | |
seq_scan | 0 | |
seq_tup_read | 0 | |
idx_scan | 0 | |
idx_tup_fetch | 0 | |
n_tup_ins | 0 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 0 | |
n_dead_tup | 0 | |
last_vacuum | | |
last_autovacuum | | |
last_analyze | | |
last_autoanalyze | | |
vacuum_count | 0 | |
autovacuum_count | 0 | |
analyze_count | 0 | |
autoanalyze_count | 0 | |
-[ RECORD 10 ]----+------------------------------ | |
relid | 405235 | |
schemaname | public | |
relname | reports | |
seq_scan | 1 | |
seq_tup_read | 0 | |
idx_scan | 0 | |
idx_tup_fetch | 0 | |
n_tup_ins | 0 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 0 | |
n_dead_tup | 0 | |
last_vacuum | | |
last_autovacuum | | |
last_analyze | | |
last_autoanalyze | | |
vacuum_count | 0 | |
autovacuum_count | 0 | |
analyze_count | 0 | |
autoanalyze_count | 0 | |
-[ RECORD 11 ]----+------------------------------ | |
relid | 405411 | |
schemaname | public | |
relname | edges | |
seq_scan | 0 | |
seq_tup_read | 0 | |
idx_scan | 486 | |
idx_tup_fetch | 0 | |
n_tup_ins | 620308 | |
n_tup_upd | 0 | |
n_tup_del | 0 | |
n_tup_hot_upd | 0 | |
n_live_tup | 616857 | |
n_dead_tup | 0 | |
last_vacuum | | |
last_autovacuum | | |
last_analyze | | |
last_autoanalyze | 2014-01-02 11:47:59.831645-06 | |
vacuum_count | 0 | |
autovacuum_count | 0 | |
analyze_count | 0 | |
autoanalyze_count | 7 | |
-[ RECORD 12 ]----+------------------------------ | |
relid | 405087 | |
schemaname | public | |
relname | certnames | |
seq_scan | 204014 | |
seq_tup_read | 22338164 | |
idx_scan | 418650 | |
idx_tup_fetch | 418234 | |
n_tup_ins | 527 | |
n_tup_upd | 527 | |
n_tup_del | 0 | |
n_tup_hot_upd | 524 | |
n_live_tup | 486 | |
n_dead_tup | 64 | |
last_vacuum | | |
last_autovacuum | 2014-01-02 11:45:01.653159-06 | |
last_analyze | | |
last_autoanalyze | 2014-01-02 11:47:59.872861-06 | |
vacuum_count | 0 | |
autovacuum_count | 4 | |
analyze_count | 0 | |
autoanalyze_count | 6 | |
-[ RECORD 1 ]--+------------------------------ | |
datid | 405086 | |
datname | puppetdb | |
numbackends | 1 | |
xact_commit | 1587 | |
xact_rollback | 41 | |
blks_read | 914083 | |
blks_hit | 20028950 | |
tup_returned | 64530035 | |
tup_fetched | 1617971 | |
tup_inserted | 1145187 | |
tup_updated | 633 | |
tup_deleted | 238 | |
conflicts | 0 | |
temp_files | 129 | |
temp_bytes | 67217650 | |
deadlocks | 0 | |
blk_read_time | 0 | |
blk_write_time | 0 | |
stats_reset | 2014-01-02 11:12:44.845502-06 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment