explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TDDf

Settings
# exclusive inclusive rows x rows loops node
1. 4.418 384.979 ↓ 11.9 2,763 1

GroupAggregate (cost=0.57..26,287.50 rows=233 width=20) (actual time=0.414..384.979 rows=2,763 loops=1)

  • Group Key: chunk_day, chunk_seq_num, node_id, channel_id, ctype_id
2. 380.561 380.561 ↓ 3.6 8,289 1

Index Scan using tfs_chunks_chunk_id_key_20190507_01 on chunk (cost=0.57..26,238.61 rows=2,328 width=20) (actual time=0.146..380.561 rows=8,289 loops=1)

  • Index Cond: ((node_id = 120) AND (channel_id = 153) AND (chunk_day = 6705) AND (chunk_seq_num >= 703) AND (chunk_seq_num <= 3465))
  • Filter: (active AND (ctype_id = 305))
  • Rows Removed by Filter: 41445
Planning time : 1.312 ms
Execution time : 385.396 ms