explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gHjs

Settings
# exclusive inclusive rows x rows loops node
1. 159,239.366 264,323.443 ↓ 0.0 0 1

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

2. 40,095.760 105,084.077 ↑ 1.0 58,110,390 1

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

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

Nested Loop (cost=0.42..1,379,690.32 rows=58,433,505 width=173) (actual time=64.506..64,968.517 rows=58,110,390 loops=1)

4. 28,767.403 28,767.403 ↑ 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=64.494..28,767.403 rows=298,002 loops=1)

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

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

6. 0.046 19.800 ↑ 1.0 195 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
7. 0.777 19.754 ↑ 1.0 195 1

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

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

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