explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X80

Settings
# exclusive inclusive rows x rows loops node
1. 1.754 334.142 ↓ 1.3 904 1

GroupAggregate (cost=0.57..44,040.76 rows=697 width=20) (actual time=0.948..334.142 rows=904 loops=1)

  • Group Key: chunk_day, chunk_seq_num, node_id, channel_id, ctype_id
2. 332.388 332.388 ↑ 2.6 2,712 1

Index Scan using tfs_chunks_chunk_id_key_20190507_01 on chunk (cost=0.57..43,894.55 rows=6,962 width=20) (actual time=0.604..332.388 rows=2,712 loops=1)

  • Index Cond: ((node_id = 120) AND (channel_id = 82) AND (chunk_day = 6705) AND (chunk_seq_num >= 1993) AND (chunk_seq_num <= 2896))
  • Filter: (active AND (ctype_id = 1222))
  • Rows Removed by Filter: 35256