explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yp73

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 21,089.609 ↑ 1.0 5 1

Limit (cost=2,647,174.05..2,647,174.18 rows=5 width=50) (actual time=21,089.594..21,089.609 rows=5 loops=1)

2. 0.047 21,089.598 ↑ 2,469,675.6 5 1

GroupAggregate (cost=2,647,174.05..2,966,908.84 rows=12,348,378 width=50) (actual time=21,089.592..21,089.598 rows=5 loops=1)

  • Group Key: ld.live_delivery_id, am.audience_sk, am.audience
3. 14,478.329 21,089.551 ↑ 1,202,764.1 11 1

Sort (cost=2,647,174.05..2,680,250.06 rows=13,230,405 width=26) (actual time=21,089.548..21,089.551 rows=11 loops=1)

  • Sort Key: ld.live_delivery_id, am.audience_sk, am.audience
  • Sort Method: external merge Disk: 538960kB
4. 2,877.632 6,611.222 ↓ 1.0 13,410,090 1

Nested Loop (cost=4.63..449,091.19 rows=13,230,405 width=26) (actual time=0.109..6,611.222 rows=13,410,090 loops=1)

5. 2,541.582 2,541.582 ↓ 1.0 298,002 1

Seq Scan on live_delivery ld (cost=0.00..283,675.67 rows=294,009 width=35) (actual time=0.043..2,541.582 rows=298,002 loops=1)

  • Filter: (demo_block = 'f_65_plus_delivery'::text)
  • Rows Removed by Filter: 8642058
6. 1,191.837 1,192.008 ↑ 1.0 45 298,002

Materialize (cost=4.63..35.56 rows=45 width=29) (actual time=0.000..0.004 rows=45 loops=298,002)

7. 0.130 0.171 ↑ 1.0 45 1

Bitmap Heap Scan on audience_map am (cost=4.63..35.34 rows=45 width=29) (actual time=0.060..0.171 rows=45 loops=1)

  • Recheck Cond: ((demo_block)::text = 'f_65_plus_delivery'::text)
  • Heap Blocks: exact=25
8. 0.041 0.041 ↑ 1.0 45 1

Bitmap Index Scan on demo_block_idx (cost=0.00..4.62 rows=45 width=0) (actual time=0.041..0.041 rows=45 loops=1)

  • Index Cond: ((demo_block)::text = 'f_65_plus_delivery'::text)