Technologies/PostgreSQL/seq_tup_read
PostgreSQLPostgreSQLMetric

seq_tup_read

Sequential scan rows
Dimensions:None
Available on:DatadogDatadog (1)Native (1)PrometheusPrometheus (1)
Interface Metrics (3)
DatadogDatadog
Enabled with `relations`. The number of live rows fetched by sequential scans. This metric is tagged with db, schema, table.
Dimensions:None
Native
Number of live rows fetched by sequential scans
Dimensions:None
PrometheusPrometheus
Number of live rows fetched by sequential scans
Dimensions:None
Sources
postgresql.seq_rows_readgithub.com
seq_tup_readgithub.com
stat_user_tables_seq_tup_readgithub.com

Technical Annotations (6)

CLI Commands (3)
ANALYZE table_name;remediation
SELECT datname, stats_reset FROM pg_stat_database;diagnostic
SELECT relname, seq_scan, seq_tup_read / seq_scan AS tup_per_scan FROM pg_stat_user_tables WHERE seq_scan > 0;diagnostic
Technical References (3)
pg_stat_user_tablescomponentpg_stat_statementscomponentpg_stat_databasecomponent
Related Insights (2)
High sequential scan counts indicate missing indexesinfo
▸
High sequential scan count may indicate missing indexes requiring query optimizationwarning
▸