explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SgHx

Settings
# exclusive inclusive rows x rows loops node
1. 20.884 2,106.213 ↑ 1.0 1 1

Aggregate (cost=74,328.29..74,328.30 rows=1 width=4) (actual time=2,106.213..2,106.213 rows=1 loops=1)

  • Buffers: shared hit=10465 read=102460 dirtied=9 written=90
2. 2,085.329 2,085.329 ↓ 1.1 116,640 1

Index Scan using tfs_chunks_chunk_id_key_20190507_01 on chunk (cost=0.57..74,074.13 rows=101,664 width=4) (actual time=0.071..2,085.329 rows=116,640 loops=1)

  • Index Cond: ((node_id = 120) AND (channel_id = 86) AND (chunk_day = 6695) AND (chunk_seq_num >= 0) AND (chunk_seq_num <= 4319))
  • Filter: (active AND (removed IS NULL))
  • Buffers: shared hit=10465 read=102460 dirtied=9 written=90