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