Skip to content

Instantly share code, notes, and snippets.

@senior
Created January 2, 2014 18:36
Show Gist options
  • Save senior/8224147 to your computer and use it in GitHub Desktop.
Save senior/8224147 to your computer and use it in GitHub Desktop.
1.6.0 differential benchmark
-[ 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