explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OwxI

Settings
# exclusive inclusive rows x rows loops node
1. 159,898.642 245,991.816 ↓ 0.0 0 1

Insert on live_delivery (cost=51.12..2,329,285.47 rows=58,433,505 width=179) (actual time=245,991.816..245,991.816 rows=0 loops=1)

2. 39,798.315 86,093.174 ↑ 1.0 58,110,390 1

Hash Join (cost=51.12..2,329,285.47 rows=58,433,505 width=179) (actual time=35.511..86,093.174 rows=58,110,390 loops=1)

  • Hash Cond: ("*VALUES*".column1 = (audience_map.audience_genesis_name)::text)
3. 16,751.065 46,293.904 ↑ 1.0 58,110,390 1

Nested Loop (cost=0.42..1,379,690.32 rows=58,433,505 width=173) (actual time=34.532..46,293.904 rows=58,110,390 loops=1)

4. 10,470.711 10,470.711 ↑ 1.0 298,002 1

Index Scan using idx_rate_card_type_code on demo_groups d (cost=0.42..64,936.46 rows=299,659 width=1,218) (actual time=34.499..10,470.711 rows=298,002 loops=1)

  • Index Cond: ((rate_card_type_code)::text = 'std'::text)
5. 19,072.128 19,072.128 ↑ 1.0 195 298,002

Values Scan on "*VALUES*" (cost=0.00..2.44 rows=195 width=64) (actual time=0.000..0.064 rows=195 loops=298,002)

6. 0.049 0.955 ↑ 1.0 195 1

Hash (cost=48.26..48.26 rows=195 width=28) (actual time=0.955..0.955 rows=195 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
7. 0.712 0.906 ↑ 1.0 195 1

HashAggregate (cost=44.36..46.31 rows=195 width=28) (actual time=0.868..0.906 rows=195 loops=1)

  • Group Key: audience_map.audience_sk, audience_map.audience, audience_map.audience_genesis_name
8. 0.194 0.194 ↑ 1.0 1,392 1

Seq Scan on audience_map (cost=0.00..33.92 rows=1,392 width=28) (actual time=0.012..0.194 rows=1,392 loops=1)