explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J6LB

Settings
# exclusive inclusive rows x rows loops node
1. 7.054 2,931.889 ↓ 7.8 2,763 1

GroupAggregate (cost=0.57..41,391.14 rows=352 width=20) (actual time=0.867..2,931.889 rows=2,763 loops=1)

  • Group Key: chunk_day, chunk_seq_num, node_id, channel_id, ctype_id
  • Buffers: shared hit=5894 read=43421
2. 2,924.835 2,924.835 ↓ 2.4 8,289 1

Index Scan using tfs_chunks_chunk_id_key_20190507_01 on chunk (cost=0.57..41,317.28 rows=3,517 width=20) (actual time=0.118..2,924.835 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
  • Buffers: shared hit=5894 read=43421