postgresql.seq_rows_read

Rows read by seq scans

Dimensions:None

Available on:

Datadog (1)Native (1)

Prometheus (1)

Interface Metrics (3)

Datadog

postgresql.seq_rows_read

Enabled with `relations`. The number of live rows fetched by sequential scans. This metric is tagged with db, schema, table.

Dimensions:None

Native

seq_tup_read

Number of live rows fetched by sequential scans

Dimensions:None

Prometheus

stat_user_tables_seq_tup_read

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 (8)

CLI Commands (5)

CREATE INDEX idx_orders_status_created ON orders (status, created_at);remediation

EXPLAIN ANALYZE SELECT o.id, o.total, c.name FROM orders o JOIN customers c ON c.id = o.customer_id WHERE o.created_at > '2026-01-01' AND o.status = 'completed';

diagnostic

CREATE INDEX idx_orders_customer ON orders(customer_id);remediation

SELECT relname AS table, seq_scan, seq_tup_read, idx_scan, seq_tup_read / NULLIF(seq_scan, 0) AS avg_seq_tup FROM pg_stat_user_tables WHERE seq_scan > 0 ORDER BY seq_tup_read DESC LIMIT 20;

diagnostic

SELECT schemaname || '.' || relname AS table, seq_scan, idx_scan, n_live_tup, round(100.0 * seq_scan / NULLIF(seq_scan + idx_scan, 0), 2) AS seq_scan_pct FROM pg_stat_user_tables WHERE seq_scan > 1000 AND n_live_tup > 10000 ORDER BY seq_scan DESC;

diagnostic

Technical References (3)

Seq ScancomponentBitmap Index Scancomponentpg_stat_user_tablescomponent

Related Insights (2)

Sequential scan reads excessive rows due to missing indexwarning

▸

Missing indexes on WHERE clause columns cause full table scanscritical

▸