{
    "global": {
        "pg_stat_archiver": {
            "archived_count": "0", 
            "stats_reset": "2017-11-10 10:59:47.397075-05", 
            "failed_count": "0"
        }, 
        "pg_stat_bgwriter": {
            "buffers_backend": "81032", 
            "checkpoints_timed": "1277", 
            "buffers_alloc": 4914, 
            "buffers_clean": "49590", 
            "buffers_backend_fsync": "0", 
            "checkpoint_sync_time": "19", 
            "checkpoints_req": "2", 
            "checkpoint_write_time": "597851", 
            "maxwritten_clean": "325", 
            "buffers_checkpoint": "33250", 
            "stats_reset": "2017-11-10 10:59:47.397075-05"
        }
    }, 
    "local": {
        "table": {
            "pg_stat_user_tables": {
                "customer": {
                    "last_autoanalyze": "2017-11-20 15:59:18.824212-05", 
                    "n_live_tup": "60000", 
                    "vacuum_count": "0", 
                    "n_tup_ins": 46752, 
                    "n_tup_hot_upd": "262", 
                    "autoanalyze_count": "1", 
                    "n_tup_del": "0", 
                    "n_dead_tup": "1510", 
                    "n_mod_since_analyze": "1594", 
                    "relname": "customer", 
                    "analyze_count": "0", 
                    "idx_scan": "125261", 
                    "idx_tup_fetch": "85299628", 
                    "autovacuum_count": "0", 
                    "n_tup_upd": "1594", 
                    "schemaname": "public", 
                    "seq_scan": "3", 
                    "seq_tup_read": "0", 
                    "relid": "16540"
                }, 
                "district": {
                    "last_autoanalyze": "2017-11-20 19:23:34.201509-05", 
                    "n_live_tup": "20", 
                    "vacuum_count": "0", 
                    "n_tup_ins": 31239, 
                    "n_tup_hot_upd": "1754", 
                    "autoanalyze_count": "2", 
                    "n_tup_del": "0", 
                    "n_dead_tup": "33", 
                    "n_mod_since_analyze": "0", 
                    "relname": "district", 
                    "analyze_count": "0", 
                    "idx_scan": "122234", 
                    "idx_tup_fetch": "122234", 
                    "autovacuum_count": "0", 
                    "n_tup_upd": "1754", 
                    "schemaname": "public", 
                    "seq_scan": "2221", 
                    "seq_tup_read": "41522", 
                    "relid": "16549"
                }, 
                "order_line": {
                    "last_autoanalyze": "2017-11-20 16:00:11.017507-05", 
                    "n_live_tup": "608373", 
                    "vacuum_count": "0", 
                    "n_tup_ins": 38861, 
                    "n_tup_hot_upd": "5393", 
                    "autoanalyze_count": "1", 
                    "n_tup_del": "0", 
                    "n_dead_tup": "2550", 
                    "n_mod_since_analyze": "16230", 
                    "relname": "order_line", 
                    "analyze_count": "0", 
                    "idx_scan": "1655", 
                    "idx_tup_fetch": "33762", 
                    "autovacuum_count": "0", 
                    "n_tup_upd": "7329", 
                    "schemaname": "public", 
                    "seq_scan": "3", 
                    "seq_tup_read": "0", 
                    "relid": "16513"
                }, 
                "new_order": {
                    "last_autoanalyze": "2017-11-20 16:00:11.217111-05", 
                    "n_live_tup": "16964", 
                    "vacuum_count": "0", 
                    "n_tup_ins": 38698, 
                    "n_tup_hot_upd": "0", 
                    "autoanalyze_count": "1", 
                    "n_tup_del": "740", 
                    "n_dead_tup": "751", 
                    "n_mod_since_analyze": "1629", 
                    "relname": "new_order", 
                    "analyze_count": "0", 
                    "idx_scan": "1481", 
                    "idx_tup_fetch": "1480", 
                    "autovacuum_count": "0", 
                    "n_tup_upd": "0", 
                    "schemaname": "public", 
                    "seq_scan": "1", 
                    "seq_tup_read": "0", 
                    "relid": "16518"
                }, 
                "item": {
                    "last_autoanalyze": "2017-11-20 15:59:26.613728-05", 
                    "n_live_tup": "102000", 
                    "vacuum_count": "0", 
                    "n_tup_ins": 50065, 
                    "n_tup_hot_upd": "0", 
                    "autoanalyze_count": "1", 
                    "n_tup_del": "0", 
                    "n_dead_tup": "0", 
                    "n_mod_since_analyze": "2000", 
                    "relname": "item", 
                    "analyze_count": "0", 
                    "idx_scan": "209020", 
                    "idx_tup_fetch": "209009", 
                    "autovacuum_count": "0", 
                    "n_tup_upd": "0", 
                    "schemaname": "public", 
                    "seq_scan": "1", 
                    "seq_tup_read": "0", 
                    "relid": "16554"
                }, 
                "oorder": {
                    "last_autoanalyze": "2017-11-20 15:59:54.690984-05", 
                    "n_live_tup": "60889", 
                    "vacuum_count": "0", 
                    "n_tup_ins": 68200, 
                    "n_tup_hot_upd": "662", 
                    "autoanalyze_count": "1", 
                    "n_tup_del": "0", 
                    "n_dead_tup": "117", 
                    "n_mod_since_analyze": "1629", 
                    "relname": "oorder", 
                    "analyze_count": "0", 
                    "idx_scan": "627652", 
                    "idx_tup_fetch": "627652", 
                    "autovacuum_count": "0", 
                    "n_tup_upd": "740", 
                    "schemaname": "public", 
                    "seq_scan": "4", 
                    "seq_tup_read": "0", 
                    "relid": "16528"
                }, 
                "warehouse": {
                    "last_autoanalyze": "2017-11-20 19:23:34.236294-05", 
                    "n_live_tup": "2", 
                    "vacuum_count": "0", 
                    "n_tup_ins": 66112, 
                    "n_tup_hot_upd": "854", 
                    "autoanalyze_count": "2", 
                    "n_tup_del": "0", 
                    "n_dead_tup": "0", 
                    "n_mod_since_analyze": "0", 
                    "relname": "warehouse", 
                    "last_autovacuum": "2017-11-20 19:23:34.235793-05", 
                    "analyze_count": "0", 
                    "idx_scan": "202634", 
                    "idx_tup_fetch": "202634", 
                    "autovacuum_count": "2", 
                    "n_tup_upd": "854", 
                    "schemaname": "public", 
                    "seq_scan": "1", 
                    "seq_tup_read": "0", 
                    "relid": "16559"
                }, 
                "stock": {
                    "last_autoanalyze": "2017-11-20 15:59:01.368483-05", 
                    "n_live_tup": "200000", 
                    "vacuum_count": "0", 
                    "n_tup_ins": 66271, 
                    "n_tup_hot_upd": "5305", 
                    "autoanalyze_count": "1", 
                    "n_tup_del": "0", 
                    "n_dead_tup": "4364", 
                    "n_mod_since_analyze": "8901", 
                    "relname": "stock", 
                    "analyze_count": "0", 
                    "idx_scan": "644561", 
                    "idx_tup_fetch": "644561", 
                    "autovacuum_count": "0", 
                    "n_tup_upd": "8901", 
                    "schemaname": "public", 
                    "seq_scan": "3", 
                    "seq_tup_read": "0", 
                    "relid": "16523"
                }, 
                "history": {
                    "last_autoanalyze": "2017-11-20 15:59:02.567618-05", 
                    "n_live_tup": "60854", 
                    "vacuum_count": "0", 
                    "n_tup_ins": 67987, 
                    "n_tup_hot_upd": "0", 
                    "autoanalyze_count": "1", 
                    "n_tup_del": "0", 
                    "n_dead_tup": "0", 
                    "relname": "history", 
                    "analyze_count": "0", 
                    "n_mod_since_analyze": "854", 
                    "autovacuum_count": "0", 
                    "n_tup_upd": "0", 
                    "schemaname": "public", 
                    "seq_scan": "2", 
                    "seq_tup_read": "0", 
                    "relid": "16536"
                }
            }, 
            "pg_statio_user_tables": {
                "customer": {
                    "relid": "16540", 
                    "idx_blks_read": "2716", 
                    "relname": "customer", 
                    "tidx_blks_read": "0", 
                    "toast_blks_hit": "0", 
                    "idx_blks_hit": "1411491", 
                    "tidx_blks_hit": "0", 
                    "toast_blks_read": "0", 
                    "heap_blks_hit": "70136669", 
                    "schemaname": "public", 
                    "heap_blks_read": "13826"
                }, 
                "district": {
                    "relid": "16549", 
                    "heap_blks_hit": "249754", 
                    "idx_blks_hit": "122259", 
                    "relname": "district", 
                    "idx_blks_read": "5", 
                    "schemaname": "public", 
                    "heap_blks_read": "3"
                }, 
                "order_line": {
                    "relid": "16513", 
                    "heap_blks_hit": "1869417", 
                    "idx_blks_hit": "1788651", 
                    "relname": "order_line", 
                    "idx_blks_read": "3708", 
                    "schemaname": "public", 
                    "heap_blks_read": "12419"
                }, 
                "new_order": {
                    "relid": "16518", 
                    "heap_blks_hit": "37856", 
                    "idx_blks_hit": "38225", 
                    "relname": "new_order", 
                    "idx_blks_read": "134", 
                    "schemaname": "public", 
                    "heap_blks_read": "192"
                }, 
                "item": {
                    "relid": "16554", 
                    "heap_blks_hit": "509702", 
                    "idx_blks_hit": "617914", 
                    "relname": "item", 
                    "idx_blks_read": "877", 
                    "schemaname": "public", 
                    "heap_blks_read": "4542"
                }, 
                "oorder": {
                    "relid": "16528", 
                    "heap_blks_hit": "1378399", 
                    "idx_blks_hit": "3979052", 
                    "relname": "oorder", 
                    "idx_blks_read": "1881", 
                    "schemaname": "public", 
                    "heap_blks_read": "928"
                }, 
                "warehouse": {
                    "relid": "16559", 
                    "heap_blks_hit": "404486", 
                    "idx_blks_hit": "202643", 
                    "relname": "warehouse", 
                    "idx_blks_read": "6", 
                    "schemaname": "public", 
                    "heap_blks_read": "80"
                }, 
                "stock": {
                    "relid": "16523", 
                    "heap_blks_hit": "1920817", 
                    "idx_blks_hit": "2447522", 
                    "relname": "stock", 
                    "idx_blks_read": "1530", 
                    "schemaname": "public", 
                    "heap_blks_read": "11757"
                }, 
                "history": {
                    "schemaname": "public", 
                    "relname": "history", 
                    "heap_blks_hit": "184380", 
                    "heap_blks_read": "746", 
                    "relid": "16536"
                }
            }
        }, 
        "database": {
            "pg_stat_database_conflicts": {
                "tpcc": {
                    "datname": "tpcc", 
                    "confl_deadlock": "0", 
                    "confl_bufferpin": "0", 
                    "datid": "16384", 
                    "confl_tablespace": "0", 
                    "confl_lock": "0", 
                    "confl_snapshot": "0"
                }, 
                "template0": {
                    "datname": "template0", 
                    "confl_deadlock": "0", 
                    "confl_bufferpin": "0", 
                    "datid": "12557", 
                    "confl_tablespace": "0", 
                    "confl_lock": "0", 
                    "confl_snapshot": "0"
                }, 
                "postgres": {
                    "datname": "postgres", 
                    "confl_deadlock": "0", 
                    "confl_bufferpin": "0", 
                    "datid": "12558", 
                    "confl_tablespace": "0", 
                    "confl_lock": "0", 
                    "confl_snapshot": "0"
                }, 
                "template1": {
                    "datname": "template1", 
                    "confl_deadlock": "0", 
                    "confl_bufferpin": "0", 
                    "datid": "1", 
                    "confl_tablespace": "0", 
                    "confl_lock": "0", 
                    "confl_snapshot": "0"
                }
            }, 
            "pg_stat_database": {
                "tpcc": {
                    "numbackends": "0", 
                    "datname": "tpcc", 
                    "blks_read": "0", 
                    "deadlocks": "0", 
                    "temp_files": "0", 
                    "blks_hit": "0", 
                    "temp_bytes": "0", 
                    "blk_write_time": "0", 
                    "datid": "16384", 
                    "xact_commit": 37612, 
                    "blk_read_time": "0", 
                    "xact_rollback": "0", 
                    "conflicts": "0", 
                    "tup_inserted": "0", 
                    "tup_returned": "0", 
                    "tup_updated": "0", 
                    "tup_deleted": "0", 
                    "tup_fetched": "0"
                }, 
                "template0": {
                    "numbackends": "0", 
                    "datname": "template0", 
                    "blks_read": "0", 
                    "deadlocks": "0", 
                    "temp_files": "0", 
                    "blks_hit": "0", 
                    "temp_bytes": "0", 
                    "blk_write_time": "0", 
                    "datid": "12557", 
                    "xact_commit": 49929, 
                    "blk_read_time": "0", 
                    "xact_rollback": "0", 
                    "conflicts": "0", 
                    "tup_inserted": "0", 
                    "tup_returned": "0", 
                    "tup_updated": "0", 
                    "tup_deleted": "0", 
                    "tup_fetched": "0"
                }, 
                "postgres": {
                    "numbackends": "1", 
                    "datname": "postgres", 
                    "blks_read": "104188", 
                    "deadlocks": "0", 
                    "temp_files": "0", 
                    "stats_reset": "2017-11-10 11:14:57.116228-05", 
                    "blks_hit": "115229324", 
                    "temp_bytes": "0", 
                    "blk_write_time": "0", 
                    "datid": "12558", 
                    "xact_commit": 52595, 
                    "blk_read_time": "0", 
                    "xact_rollback": "17", 
                    "conflicts": "0", 
                    "tup_inserted": "2210752", 
                    "tup_returned": "110741743", 
                    "tup_updated": "32675", 
                    "tup_deleted": "1818", 
                    "tup_fetched": "103355344"
                }, 
                "template1": {
                    "numbackends": "0", 
                    "datname": "template1", 
                    "blks_read": "0", 
                    "deadlocks": "0", 
                    "temp_files": "0", 
                    "blks_hit": "0", 
                    "temp_bytes": "0", 
                    "blk_write_time": "0", 
                    "datid": "1", 
                    "xact_commit": 39030, 
                    "blk_read_time": "0", 
                    "xact_rollback": "0", 
                    "conflicts": "0", 
                    "tup_inserted": "0", 
                    "tup_returned": "0", 
                    "tup_updated": "0", 
                    "tup_deleted": "0", 
                    "tup_fetched": "0"
                }
            }
        }, 
        "indexes": {
            "pg_stat_user_indexes": {
                "customer": {
                    "indexrelid": "16564", 
                    "relid": "16540", 
                    "indexrelname": "idx_customer_name", 
                    "relname": "customer", 
                    "idx_tup_fetch": "85256809", 
                    "idx_tup_read": "85256841", 
                    "idx_scan": "82442", 
                    "schemaname": "public"
                }, 
                "district": {
                    "indexrelid": "16552", 
                    "relid": "16549", 
                    "indexrelname": "district_pkey", 
                    "relname": "district", 
                    "idx_tup_fetch": "122234", 
                    "idx_tup_read": "122234", 
                    "idx_scan": "122234", 
                    "schemaname": "public"
                }, 
                "order_line": {
                    "indexrelid": "16516", 
                    "relid": "16513", 
                    "indexrelname": "order_line_pkey", 
                    "relname": "order_line", 
                    "idx_tup_fetch": "33762", 
                    "idx_tup_read": "35698", 
                    "idx_scan": "1655", 
                    "schemaname": "public"
                }, 
                "new_order": {
                    "indexrelid": "16521", 
                    "relid": "16518", 
                    "indexrelname": "new_order_pkey", 
                    "relname": "new_order", 
                    "idx_tup_fetch": "1480", 
                    "idx_tup_read": "2200", 
                    "idx_scan": "1481", 
                    "schemaname": "public"
                }, 
                "item": {
                    "indexrelid": "16557", 
                    "relid": "16554", 
                    "indexrelname": "item_pkey", 
                    "relname": "item", 
                    "idx_tup_fetch": "209009", 
                    "idx_tup_read": "209009", 
                    "idx_scan": "209020", 
                    "schemaname": "public"
                }, 
                "oorder": {
                    "indexrelid": "16565", 
                    "relid": "16528", 
                    "indexrelname": "idx_order", 
                    "relname": "oorder", 
                    "idx_tup_fetch": "616371", 
                    "idx_tup_read": "616371", 
                    "idx_scan": "616371", 
                    "schemaname": "public"
                }, 
                "warehouse": {
                    "indexrelid": "16562", 
                    "relid": "16559", 
                    "indexrelname": "warehouse_pkey", 
                    "relname": "warehouse", 
                    "idx_tup_fetch": "201331", 
                    "idx_tup_read": "202634", 
                    "idx_scan": "202634", 
                    "schemaname": "public"
                }, 
                "stock": {
                    "indexrelid": "16526", 
                    "relid": "16523", 
                    "indexrelname": "stock_pkey", 
                    "relname": "stock", 
                    "idx_tup_fetch": "644561", 
                    "idx_tup_read": "647319", 
                    "idx_scan": "644561", 
                    "schemaname": "public"
                }
            }, 
            "pg_statio_user_indexes": {
                "customer": {
                    "indexrelid": "16564", 
                    "relid": "16540", 
                    "indexrelname": "idx_customer_name", 
                    "idx_blks_hit": 43641, 
                    "relname": "customer", 
                    "idx_blks_read": "1589", 
                    "schemaname": "public"
                }, 
                "district": {
                    "indexrelid": "16552", 
                    "relid": "16549", 
                    "indexrelname": "district_pkey", 
                    "idx_blks_hit": 69722, 
                    "relname": "district", 
                    "idx_blks_read": "5", 
                    "schemaname": "public"
                }, 
                "order_line": {
                    "indexrelid": "16516", 
                    "relid": "16513", 
                    "indexrelname": "order_line_pkey", 
                    "idx_blks_hit": 34427, 
                    "relname": "order_line", 
                    "idx_blks_read": "3708", 
                    "schemaname": "public"
                }, 
                "new_order": {
                    "indexrelid": "16521", 
                    "relid": "16518", 
                    "indexrelname": "new_order_pkey", 
                    "idx_blks_hit": 41934, 
                    "relname": "new_order", 
                    "idx_blks_read": "134", 
                    "schemaname": "public"
                }, 
                "item": {
                    "indexrelid": "16557", 
                    "relid": "16554", 
                    "indexrelname": "item_pkey", 
                    "idx_blks_hit": 68779, 
                    "relname": "item", 
                    "idx_blks_read": "877", 
                    "schemaname": "public"
                }, 
                "oorder": {
                    "indexrelid": "16565", 
                    "relid": "16528", 
                    "indexrelname": "idx_order", 
                    "idx_blks_hit": 48553, 
                    "relname": "oorder", 
                    "idx_blks_read": "733", 
                    "schemaname": "public"
                }, 
                "warehouse": {
                    "indexrelid": "16562", 
                    "relid": "16559", 
                    "indexrelname": "warehouse_pkey", 
                    "idx_blks_hit": 69018, 
                    "relname": "warehouse", 
                    "idx_blks_read": "6", 
                    "schemaname": "public"
                }, 
                "stock": {
                    "indexrelid": "16526", 
                    "relid": "16523", 
                    "indexrelname": "stock_pkey", 
                    "idx_blks_hit": 48945, 
                    "relname": "stock", 
                    "idx_blks_read": "1530", 
                    "schemaname": "public"
                }
            }
        }
    }
}