526
526
"expr" :" irate(pgwatch_pg_statio_all_tables_tidx_blks_hit{schemaname=~\" $schema_name\" , datname=\" $db_name\" , cluster=\" $cluster_name\" , node_name=\" $node_name\" , relname=\" $table_name\" }[$__rate_interval])" ,
527
527
"hide" :false ,
528
528
"instant" :false ,
529
+ "interval" :" 20" ,
529
530
"legendFormat" :" tidx" ,
530
531
"range" :true ,
531
532
"refId" :" B"
539
540
"expr" :" irate(pgwatch_pg_statio_all_tables_toast_blks_hit{schemaname=~\" $schema_name\" , datname=\" $db_name\" , cluster=\" $cluster_name\" , node_name=\" $node_name\" , relname=\" $table_name\" }[$__rate_interval])" ,
540
541
"hide" :false ,
541
542
"instant" :false ,
543
+ "interval" :" 20" ,
542
544
"legendFormat" :" TOAST" ,
543
545
"range" :true ,
544
546
"refId" :" C"
552
554
"expr" :" irate(pgwatch_pg_statio_all_tables_idx_blks_hit{schemaname=~\" $schema_name\" , datname=\" $db_name\" , cluster=\" $cluster_name\" , node_name=\" $node_name\" , relname=\" $table_name\" }[$__rate_interval])" ,
553
555
"hide" :false ,
554
556
"instant" :false ,
557
+ "interval" :" 20" ,
555
558
"legendFormat" :" Index" ,
556
559
"range" :true ,
557
560
"refId" :" D"
668
671
"expr" :" irate(pgwatch_pg_statio_all_tables_tidx_blks_read{schemaname=~\" $schema_name\" , datname=\" $db_name\" , cluster=\" $cluster_name\" , node_name=\" $node_name\" , relname=\" $table_name\" }[$__rate_interval])" ,
669
672
"hide" :false ,
670
673
"instant" :false ,
674
+ "interval" :" 20" ,
671
675
"legendFormat" :" tidx" ,
672
676
"range" :true ,
673
677
"refId" :" B"
681
685
"expr" :" irate(pgwatch_pg_statio_all_tables_toast_blks_read{schemaname=~\" $schema_name\" , datname=\" $db_name\" , cluster=\" $cluster_name\" , node_name=\" $node_name\" , relname=\" $table_name\" }[$__rate_interval])" ,
682
686
"hide" :false ,
683
687
"instant" :false ,
688
+ "interval" :" 20" ,
684
689
"legendFormat" :" TOAST" ,
685
690
"range" :true ,
686
691
"refId" :" C"
694
699
"expr" :" irate(pgwatch_pg_statio_all_tables_idx_blks_read{schemaname=~\" $schema_name\" , datname=\" $db_name\" , cluster=\" $cluster_name\" , node_name=\" $node_name\" , relname=\" $table_name\" }[$__rate_interval])" ,
695
700
"hide" :false ,
696
701
"instant" :false ,
702
+ "interval" :" 20" ,
697
703
"legendFormat" :" Index" ,
698
704
"range" :true ,
699
705
"refId" :" D"
1702
1708
]
1703
1709
},
1704
1710
"time" : {
1705
- "from" :" now-12h " ,
1711
+ "from" :" now-3h " ,
1706
1712
"to" :" now"
1707
1713
},
1708
1714
"timepicker" : {},
1709
1715
"timezone" :" utc" ,
1710
1716
"title" :" 09. Single table analysis" ,
1711
1717
"uid" :" 9-single-table-analysis" ,
1712
- "version" :19
1718
+ "version" :21
1713
1719
}