Kernel and Application Profiles

[Linux Perf Data ]

Database Details

Parameters | Disaster Report

Query Plans

Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22

Query Results

Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22 RF1 RF2

Charts

Processor

Block Devices

Database

db-stat-dbt3-blocks.png

db-stat-dbt3-connections.png

db-stat-dbt3-xacts.png

Tables

table-stat-customer-heap_blks_hit.png

table-stat-customer-heap_blks_read.png

table-stat-customer-idx_blks_hit.png

table-stat-customer-idx_blks_read.png

table-stat-customer-idx_scan.png

table-stat-customer-idx_tup_fetch.png

table-stat-customer-n_dead_tup.png

table-stat-customer-n_live_tup.png

table-stat-customer-n_tup_del.png

table-stat-customer-n_tup_hot_upd.png

table-stat-customer-n_tup_ins.png

table-stat-customer-n_tup_upd.png

table-stat-customer-seq_scan.png

table-stat-customer-seq_tup_read.png

table-stat-customer-toast_blks_read.png

table-stat-lineitem-heap_blks_hit.png

table-stat-lineitem-heap_blks_read.png

table-stat-lineitem-idx_blks_hit.png

table-stat-lineitem-idx_blks_read.png

table-stat-lineitem-idx_scan.png

table-stat-lineitem-idx_tup_fetch.png

table-stat-lineitem-n_dead_tup.png

table-stat-lineitem-n_live_tup.png

table-stat-lineitem-n_tup_del.png

table-stat-lineitem-n_tup_hot_upd.png

table-stat-lineitem-n_tup_ins.png

table-stat-lineitem-n_tup_upd.png

table-stat-lineitem-seq_scan.png

table-stat-lineitem-seq_tup_read.png

table-stat-lineitem-toast_blks_read.png

table-stat-nation-heap_blks_hit.png

table-stat-nation-heap_blks_read.png

table-stat-nation-idx_blks_hit.png

table-stat-nation-idx_blks_read.png

table-stat-nation-idx_scan.png

table-stat-nation-idx_tup_fetch.png

table-stat-nation-n_dead_tup.png

table-stat-nation-n_live_tup.png

table-stat-nation-n_tup_del.png

table-stat-nation-n_tup_hot_upd.png

table-stat-nation-n_tup_ins.png

table-stat-nation-n_tup_upd.png

table-stat-nation-seq_scan.png

table-stat-nation-seq_tup_read.png

table-stat-nation-toast_blks_read.png

table-stat-orders-heap_blks_hit.png

table-stat-orders-heap_blks_read.png

table-stat-orders-idx_blks_hit.png

table-stat-orders-idx_blks_read.png

table-stat-orders-idx_scan.png

table-stat-orders-idx_tup_fetch.png

table-stat-orders-n_dead_tup.png

table-stat-orders-n_live_tup.png

table-stat-orders-n_tup_del.png

table-stat-orders-n_tup_hot_upd.png

table-stat-orders-n_tup_ins.png

table-stat-orders-n_tup_upd.png

table-stat-orders-seq_scan.png

table-stat-orders-seq_tup_read.png

table-stat-orders-toast_blks_read.png

table-stat-part-heap_blks_hit.png

table-stat-part-heap_blks_read.png

table-stat-part-idx_blks_hit.png

table-stat-part-idx_blks_read.png

table-stat-part-idx_scan.png

table-stat-part-idx_tup_fetch.png

table-stat-part-n_dead_tup.png

table-stat-part-n_live_tup.png

table-stat-part-n_tup_del.png

table-stat-part-n_tup_hot_upd.png

table-stat-part-n_tup_ins.png

table-stat-part-n_tup_upd.png

table-stat-part-seq_scan.png

table-stat-part-seq_tup_read.png

table-stat-partsupp-heap_blks_hit.png

table-stat-partsupp-heap_blks_read.png

table-stat-partsupp-idx_blks_hit.png

table-stat-partsupp-idx_blks_read.png

table-stat-partsupp-idx_scan.png

table-stat-partsupp-idx_tup_fetch.png

table-stat-partsupp-n_dead_tup.png

table-stat-partsupp-n_live_tup.png

table-stat-partsupp-n_tup_del.png

table-stat-partsupp-n_tup_hot_upd.png

table-stat-partsupp-n_tup_ins.png

table-stat-partsupp-n_tup_upd.png

table-stat-partsupp-seq_scan.png

table-stat-partsupp-seq_tup_read.png

table-stat-partsupp-toast_blks_read.png

table-stat-part-toast_blks_read.png

table-stat-region-heap_blks_hit.png

table-stat-region-heap_blks_read.png

table-stat-region-idx_blks_hit.png

table-stat-region-idx_blks_read.png

table-stat-region-idx_scan.png

table-stat-region-idx_tup_fetch.png

table-stat-region-n_dead_tup.png

table-stat-region-n_live_tup.png

table-stat-region-n_tup_del.png

table-stat-region-n_tup_hot_upd.png

table-stat-region-n_tup_ins.png

table-stat-region-n_tup_upd.png

table-stat-region-seq_scan.png

table-stat-region-seq_tup_read.png

table-stat-region-toast_blks_read.png

table-stat-supplier-heap_blks_hit.png

table-stat-supplier-heap_blks_read.png

table-stat-supplier-idx_blks_hit.png

table-stat-supplier-idx_blks_read.png

table-stat-supplier-idx_scan.png

table-stat-supplier-idx_tup_fetch.png

table-stat-supplier-n_dead_tup.png

table-stat-supplier-n_live_tup.png

table-stat-supplier-n_tup_del.png

table-stat-supplier-n_tup_hot_upd.png

table-stat-supplier-n_tup_ins.png

table-stat-supplier-n_tup_upd.png

table-stat-supplier-seq_scan.png

table-stat-supplier-seq_tup_read.png

table-stat-supplier-toast_blks_read.png

table-stat-time_statistics-idx_scan.png

table-stat-time_statistics-seq_scan.png

table-stat-time_statistics-seq_tup_read.png

Indexes

index-stat-customer_c_mktsegment_c_custkey_idx-idx_blks_hit.png

index-stat-customer_c_mktsegment_c_custkey_idx-idx_blks.png

index-stat-customer_c_mktsegment_c_custkey_idx-idx_blks_read.png

index-stat-customer_c_mktsegment_c_custkey_idx-idx_scan.png

index-stat-customer_c_mktsegment_c_custkey_idx-idx_tup_fetch.png

index-stat-customer_c_mktsegment_c_custkey_idx-idx_tup_read.png

index-stat-customer_c_nationkey_c_custkey_brin_idx-idx_blks_hit.png

index-stat-customer_c_nationkey_c_custkey_brin_idx-idx_blks.png

index-stat-customer_c_nationkey_c_custkey_brin_idx-idx_blks_read.png

index-stat-customer_c_nationkey_c_custkey_brin_idx-idx_scan.png

index-stat-customer_c_nationkey_c_custkey_brin_idx-idx_tup_fetch.png

index-stat-customer_c_nationkey_c_custkey_brin_idx-idx_tup_read.png

index-stat-customer_c_phone_idx_c_acctbal-idx_blks_hit.png

index-stat-customer_c_phone_idx_c_acctbal-idx_blks.png

index-stat-customer_c_phone_idx_c_acctbal-idx_blks_read.png

index-stat-customer_c_phone_idx_c_acctbal-idx_scan.png

index-stat-customer_c_phone_idx_c_acctbal-idx_tup_fetch.png

index-stat-customer_c_phone_idx_c_acctbal-idx_tup_read.png

index-stat-customer_c_phone_idx-idx_blks_hit.png

index-stat-customer_c_phone_idx-idx_blks.png

index-stat-customer_c_phone_idx-idx_blks_read.png

index-stat-customer_c_phone_idx-idx_scan.png

index-stat-customer_c_phone_idx-idx_tup_fetch.png

index-stat-customer_c_phone_idx-idx_tup_read.png

index-stat-lineitem_l_orderkey_brin_idx-idx_blks_hit.png

index-stat-lineitem_l_orderkey_brin_idx-idx_blks.png

index-stat-lineitem_l_orderkey_brin_idx-idx_blks_read.png

index-stat-lineitem_l_orderkey_brin_idx-idx_scan.png

index-stat-lineitem_l_orderkey_brin_idx-idx_tup_fetch.png

index-stat-lineitem_l_orderkey_brin_idx-idx_tup_read.png

index-stat-lineitem_l_orderkey_idx_brin_part1-idx_blks_hit.png

index-stat-lineitem_l_orderkey_idx_brin_part1-idx_blks.png

index-stat-lineitem_l_orderkey_idx_brin_part1-idx_blks_read.png

index-stat-lineitem_l_orderkey_idx_brin_part1-idx_scan.png

index-stat-lineitem_l_orderkey_idx_brin_part1-idx_tup_fetch.png

index-stat-lineitem_l_orderkey_idx_brin_part1-idx_tup_read.png

index-stat-lineitem_l_orderkey_idx_brin_part2-idx_blks_hit.png

index-stat-lineitem_l_orderkey_idx_brin_part2-idx_blks.png

index-stat-lineitem_l_orderkey_idx_brin_part2-idx_blks_read.png

index-stat-lineitem_l_orderkey_idx_brin_part2-idx_scan.png

index-stat-lineitem_l_orderkey_idx_brin_part2-idx_tup_fetch.png

index-stat-lineitem_l_orderkey_idx_brin_part2-idx_tup_read.png

index-stat-lineitem_l_orderkey_l_linenumber_l_shipdate_brin_idx-idx_blks_hit.png

index-stat-lineitem_l_orderkey_l_linenumber_l_shipdate_brin_idx-idx_blks.png

index-stat-lineitem_l_orderkey_l_linenumber_l_shipdate_brin_idx-idx_blks_read.png

index-stat-lineitem_l_orderkey_l_linenumber_l_shipdate_brin_idx-idx_scan.png

index-stat-lineitem_l_orderkey_l_linenumber_l_shipdate_brin_idx-idx_tup_fetch.png

index-stat-lineitem_l_orderkey_l_linenumber_l_shipdate_brin_idx-idx_tup_read.png

index-stat-lineitem_l_partkey_l_quantity_brin_idx-idx_blks_hit.png

index-stat-lineitem_l_partkey_l_quantity_brin_idx-idx_blks.png

index-stat-lineitem_l_partkey_l_quantity_brin_idx-idx_blks_read.png

index-stat-lineitem_l_partkey_l_quantity_brin_idx-idx_scan.png

index-stat-lineitem_l_partkey_l_quantity_brin_idx-idx_tup_fetch.png

index-stat-lineitem_l_partkey_l_quantity_brin_idx-idx_tup_read.png

index-stat-lineitem_l_partkey_l_quantity_idx-idx_blks_hit.png

index-stat-lineitem_l_partkey_l_quantity_idx-idx_blks.png

index-stat-lineitem_l_partkey_l_quantity_idx-idx_blks_read.png

index-stat-lineitem_l_partkey_l_quantity_idx-idx_scan.png

index-stat-lineitem_l_partkey_l_quantity_idx-idx_tup_fetch.png

index-stat-lineitem_l_partkey_l_quantity_idx-idx_tup_read.png

index-stat-lineitem_l_shipdate_l_suppkey_brin_idx-idx_blks_hit.png

index-stat-lineitem_l_shipdate_l_suppkey_brin_idx-idx_blks.png

index-stat-lineitem_l_shipdate_l_suppkey_brin_idx-idx_blks_read.png

index-stat-lineitem_l_shipdate_l_suppkey_brin_idx-idx_scan.png

index-stat-lineitem_l_shipdate_l_suppkey_brin_idx-idx_tup_fetch.png

index-stat-lineitem_l_shipdate_l_suppkey_brin_idx-idx_tup_read.png

index-stat-orders_o_orderdate_o_orderkey_brin_idx-idx_blks_hit.png

index-stat-orders_o_orderdate_o_orderkey_brin_idx-idx_blks.png

index-stat-orders_o_orderdate_o_orderkey_brin_idx-idx_blks_read.png

index-stat-orders_o_orderdate_o_orderkey_brin_idx-idx_scan.png

index-stat-orders_o_orderdate_o_orderkey_brin_idx-idx_tup_fetch.png

index-stat-orders_o_orderdate_o_orderkey_brin_idx-idx_tup_read.png

index-stat-orders_o_orderkey_o_orderdate_brin_idx-idx_blks_hit.png

index-stat-orders_o_orderkey_o_orderdate_brin_idx-idx_blks.png

index-stat-orders_o_orderkey_o_orderdate_brin_idx-idx_blks_read.png

index-stat-orders_o_orderkey_o_orderdate_brin_idx-idx_scan.png

index-stat-orders_o_orderkey_o_orderdate_brin_idx-idx_tup_fetch.png

index-stat-orders_o_orderkey_o_orderdate_brin_idx-idx_tup_read.png

index-stat-part_p_container_p_brand_p_partkey_idx-idx_blks_hit.png

index-stat-part_p_container_p_brand_p_partkey_idx-idx_blks.png

index-stat-part_p_container_p_brand_p_partkey_idx-idx_blks_read.png

index-stat-part_p_container_p_brand_p_partkey_idx-idx_scan.png

index-stat-part_p_container_p_brand_p_partkey_idx-idx_tup_fetch.png

index-stat-part_p_container_p_brand_p_partkey_idx-idx_tup_read.png

index-stat-part_p_name_idx-idx_blks_hit.png

index-stat-part_p_name_idx-idx_blks.png

index-stat-part_p_name_idx-idx_blks_read.png

index-stat-part_p_name_idx-idx_scan.png

index-stat-part_p_name_idx-idx_tup_fetch.png

index-stat-part_p_name_idx-idx_tup_read.png

index-stat-part_p_size_brin_idx-idx_blks_hit.png

index-stat-part_p_size_brin_idx-idx_blks.png

index-stat-part_p_size_brin_idx-idx_blks_read.png

index-stat-part_p_size_brin_idx-idx_scan.png

index-stat-part_p_size_brin_idx-idx_tup_fetch.png

index-stat-part_p_size_brin_idx-idx_tup_read.png

index-stat-part_p_type_p_partkey_idx-idx_blks_hit.png

index-stat-part_p_type_p_partkey_idx-idx_blks.png

index-stat-part_p_type_p_partkey_idx-idx_blks_read.png

index-stat-part_p_type_p_partkey_idx-idx_scan.png

index-stat-part_p_type_p_partkey_idx-idx_tup_fetch.png

index-stat-part_p_type_p_partkey_idx-idx_tup_read.png

index-stat-partsupp_ps_suppkey_idx-idx_blks_hit.png

index-stat-partsupp_ps_suppkey_idx-idx_blks.png

index-stat-partsupp_ps_suppkey_idx-idx_blks_read.png

index-stat-partsupp_ps_suppkey_idx-idx_scan.png

index-stat-partsupp_ps_suppkey_idx-idx_tup_fetch.png

index-stat-partsupp_ps_suppkey_idx-idx_tup_read.png

index-stat-pk_customer-idx_blks_hit.png

index-stat-pk_customer-idx_blks.png

index-stat-pk_customer-idx_blks_read.png

index-stat-pk_customer-idx_scan.png

index-stat-pk_customer-idx_tup_fetch.png

index-stat-pk_customer-idx_tup_read.png

index-stat-pk_lineitem-idx_blks_hit.png

index-stat-pk_lineitem-idx_blks.png

index-stat-pk_lineitem-idx_blks_read.png

index-stat-pk_lineitem-idx_scan.png

index-stat-pk_lineitem-idx_tup_fetch.png

index-stat-pk_lineitem-idx_tup_read.png

index-stat-pk_nation-idx_blks_hit.png

index-stat-pk_nation-idx_blks.png

index-stat-pk_nation-idx_blks_read.png

index-stat-pk_nation-idx_scan.png

index-stat-pk_nation-idx_tup_fetch.png

index-stat-pk_nation-idx_tup_read.png

index-stat-pk_orders-idx_blks_hit.png

index-stat-pk_orders-idx_blks.png

index-stat-pk_orders-idx_blks_read.png

index-stat-pk_orders-idx_scan.png

index-stat-pk_orders-idx_tup_fetch.png

index-stat-pk_orders-idx_tup_read.png

index-stat-pk_part-idx_blks_hit.png

index-stat-pk_part-idx_blks.png

index-stat-pk_part-idx_blks_read.png

index-stat-pk_part-idx_scan.png

index-stat-pk_part-idx_tup_fetch.png

index-stat-pk_part-idx_tup_read.png

index-stat-pk_partsupp-idx_blks_hit.png

index-stat-pk_partsupp-idx_blks.png

index-stat-pk_partsupp-idx_blks_read.png

index-stat-pk_partsupp-idx_scan.png

index-stat-pk_partsupp-idx_tup_fetch.png

index-stat-pk_partsupp-idx_tup_read.png

index-stat-pk_region-idx_blks_hit.png

index-stat-pk_region-idx_blks.png

index-stat-pk_region-idx_blks_read.png

index-stat-pk_region-idx_scan.png

index-stat-pk_region-idx_tup_fetch.png

index-stat-pk_region-idx_tup_read.png

index-stat-pk_supplier-idx_blks_hit.png

index-stat-pk_supplier-idx_blks.png

index-stat-pk_supplier-idx_blks_read.png

index-stat-pk_supplier-idx_scan.png

index-stat-pk_supplier-idx_tup_fetch.png

index-stat-pk_supplier-idx_tup_read.png

index-stat-supplier_s_nationkey_s_suppkey_brin_idx-idx_blks_hit.png

index-stat-supplier_s_nationkey_s_suppkey_brin_idx-idx_blks.png

index-stat-supplier_s_nationkey_s_suppkey_brin_idx-idx_blks_read.png

index-stat-supplier_s_nationkey_s_suppkey_brin_idx-idx_scan.png

index-stat-supplier_s_nationkey_s_suppkey_brin_idx-idx_tup_fetch.png

index-stat-supplier_s_nationkey_s_suppkey_brin_idx-idx_tup_read.png

index-stat-supplier_s_suppkey_idx_like-idx_blks_hit.png

index-stat-supplier_s_suppkey_idx_like-idx_blks.png

index-stat-supplier_s_suppkey_idx_like-idx_blks_read.png

index-stat-supplier_s_suppkey_idx_like-idx_scan.png

index-stat-supplier_s_suppkey_idx_like-idx_tup_fetch.png

index-stat-supplier_s_suppkey_idx_like-idx_tup_read.png