explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jdQj

Settings
# exclusive inclusive rows x rows loops node
1. 145.736 648.968 ↓ 3.2 3,483 1

GroupAggregate (cost=0.57..76,027.37 rows=1,076 width=281) (actual time=0.619..648.968 rows=3,483 loops=1)

  • Group Key: chunk_seq_num, node_id, channel_id, chunk_day
2. 503.232 503.232 ↑ 1.0 10,449 1

Index Scan using tfs_chunks_chunk_id_key_20190611 on chunk (cost=0.57..75,882.21 rows=10,752 width=281) (actual time=0.158..503.232 rows=10,449 loops=1)

  • Index Cond: ((node_id = 190) AND (channel_id = 6) AND (chunk_day = 6735) AND (chunk_seq_num >= 0) AND (chunk_seq_num <= 3488))
  • Filter: (active AND (removed IS NULL) AND (ctype_id = 360))
  • Rows Removed by Filter: 99259