explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N5p6

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 71.275 ↓ 0.0 0 1

Update on iboe_grosses (cost=85.46..93.41 rows=1 width=220) (actual time=71.274..71.275 rows=0 loops=1)

2. 0.001 71.272 ↓ 0.0 0 1

Nested Loop (cost=85.46..93.41 rows=1 width=220) (actual time=71.272..71.272 rows=0 loops=1)

3. 0.001 71.271 ↓ 0.0 0 1

HashAggregate (cost=85.02..85.03 rows=1 width=104) (actual time=71.271..71.271 rows=0 loops=1)

  • Group Key: ig.id
4. 0.594 71.270 ↓ 0.0 0 1

Hash Left Join (cost=28.76..85.02 rows=1 width=104) (actual time=71.270..71.270 rows=0 loops=1)

  • Hash Cond: ((ig.theater_id = sig.theater_id) AND (ig.title_id = sig.title_id) AND (ig.booking_date = sig.booking_date))
  • Filter: (sig.id IS NULL)
  • Rows Removed by Filter: 637
5. 7.021 70.403 ↓ 29.0 637 1

Hash Semi Join (cost=3.64..55.18 rows=22 width=118) (actual time=1.815..70.403 rows=637 loops=1)

  • Hash Cond: (ig.theater_id = "*VALUES*".column1)
6. 8.862 63.305 ↓ 32.3 35,707 1

Nested Loop (cost=0.58..48.98 rows=1,106 width=90) (actual time=0.711..63.305 rows=35,707 loops=1)

7. 0.005 0.080 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=88) (actual time=0.079..0.080 rows=1 loops=1)

  • Group Key: "ANY_subquery".column1
8. 0.072 0.075 ↑ 1.0 1 1

Subquery Scan on ANY_subquery (cost=0.00..0.02 rows=1 width=88) (actual time=0.075..0.075 rows=1 loops=1)

9. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1)

10. 54.363 54.363 ↓ 3,246.1 35,707 1

Index Scan using ix_iboe_grosses_country_dist_date on iboe_grosses ig (cost=0.56..48.84 rows=11 width=66) (actual time=0.509..54.363 rows=35,707 loops=1)

  • Index Cond: ((country_id = 'US'::text) AND (distributor_id = "ANY_subquery".column1) AND (booking_date >= '2019-04-12'::date) AND (booking_date <= '2019-04-18'::date))
11. 0.022 0.077 ↑ 1.0 122 1

Hash (cost=1.53..1.53 rows=122 width=32) (actual time=0.077..0.077 rows=122 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
12. 0.055 0.055 ↑ 1.0 122 1

Values Scan on "*VALUES*" (cost=0.00..1.53 rows=122 width=32) (actual time=0.013..0.055 rows=122 loops=1)

13. 0.156 0.273 ↓ 1.2 637 1

Hash (cost=15.50..15.50 rows=550 width=34) (actual time=0.273..0.273 rows=637 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 53kB
14. 0.117 0.117 ↓ 1.2 637 1

Seq Scan on staged_iboe_grosses sig (cost=0.00..15.50 rows=550 width=34) (actual time=0.018..0.117 rows=637 loops=1)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_iboe_grosses on iboe_grosses (cost=0.44..8.38 rows=1 width=98) (never executed)

  • Index Cond: (id = ig.id)