explain.depesz.com

PostgreSQL's explain analyze made readable

Result: layu

Settings
# exclusive inclusive rows x rows loops node
1. 6,921.455 31,076.336 ↓ 11.7 10,132,068 1

GroupAggregate (cost=349,381.66..371,817.87 rows=866,502 width=50) (actual time=21,466.585..31,076.336 rows=10,132,068 loops=1)

  • Group Key: ld.live_delivery_id, am.audience_sk, am.audience
2. 17,330.455 24,154.881 ↓ 14.4 13,410,090 1

Sort (cost=349,381.66..351,702.65 rows=928,395 width=26) (actual time=21,466.560..24,154.881 rows=13,410,090 loops=1)

  • Sort Key: ld.live_delivery_id, am.audience_sk, am.audience
  • Sort Method: external merge Disk: 538960kB
3. 2,694.446 6,824.426 ↓ 14.4 13,410,090 1

Nested Loop (cost=4.63..235,142.89 rows=928,395 width=26) (actual time=21.671..6,824.426 rows=13,410,090 loops=1)

4. 2,639.970 2,639.970 ↓ 14.4 298,002 1

Seq Scan on live_delivery ld (cost=0.00..223,502.50 rows=20,631 width=48) (actual time=0.044..2,639.970 rows=298,002 loops=1)

  • Filter: (demo_block = 'f_65_plus_delivery'::text)
  • Rows Removed by Filter: 8642058
5. 1,468.327 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)

6. 0.089 21.683 ↑ 1.0 45 1

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

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

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

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