explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QGxl

Settings
# exclusive inclusive rows x rows loops node
1. 43.664 10,386.105 ↑ 1.0 1 1

Aggregate (cost=132,453.87..132,453.88 rows=1 width=4) (actual time=10,386.105..10,386.105 rows=1 loops=1)

  • Buffers: shared hit=14144 read=161218 dirtied=91 written=92
2. 10,342.441 10,342.441 ↑ 1.0 181,440 1

Index Scan using tfs_chunks_chunk_id_key_20190507_01 on chunk (cost=0.57..131,998.82 rows=182,022 width=4) (actual time=0.943..10,342.441 rows=181,440 loops=1)

  • Index Cond: ((node_id = 120) AND (channel_id = 87) AND (chunk_day = 6691) AND (chunk_seq_num >= 0) AND (chunk_seq_num <= 4319))
  • Filter: (active AND (removed IS NULL))
  • Buffers: shared hit=14144 read=161218 dirtied=91 written=92