explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eH0u

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 20,355.505 ↑ 1.0 5 1

Limit (cost=2,647,174.05..2,647,174.18 rows=5 width=50) (actual time=20,355.496..20,355.505 rows=5 loops=1)

2. 0.019 20,355.501 ↑ 2,469,675.6 5 1

GroupAggregate (cost=2,647,174.05..2,966,908.84 rows=12,348,378 width=50) (actual time=20,355.495..20,355.501 rows=5 loops=1)

  • Group Key: ld.live_delivery_id, am.audience_sk, am.audience
3. 13,788.867 20,355.482 ↑ 1,202,764.1 11 1

Sort (cost=2,647,174.05..2,680,250.06 rows=13,230,405 width=26) (actual time=20,355.479..20,355.482 rows=11 loops=1)

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

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

5. 2,314.422 2,314.422 ↓ 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.011..2,314.422 rows=298,002 loops=1)

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

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

7. 0.182 0.237 ↑ 1.0 45 1

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

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

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

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