explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yPAa

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 32.469 ↓ 0.0 0 1

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

2. 0.001 32.468 ↓ 0.0 0 1

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

3. 0.000 32.467 ↓ 0.0 0 1

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

  • Group Key: ig.id
4. 0.270 32.467 ↓ 0.0 0 1

Hash Left Join (cost=28.76..85.02 rows=1 width=104) (actual time=32.466..32.467 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. 3.247 32.017 ↓ 29.0 637 1

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

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

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

7. 0.006 3.881 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=88) (actual time=3.880..3.881 rows=1 loops=1)

  • Group Key: "ANY_subquery".column1
8. 3.874 3.875 ↑ 1.0 1 1

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

9. 0.001 0.001 ↑ 1.0 1 1

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

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

Index Scan using ix_iboe_grosses_country_distributor on iboe_grosses ig (cost=0.56..48.84 rows=11 width=66) (actual time=0.122..20.755 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.033 0.085 ↑ 1.0 122 1

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

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

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

13. 0.091 0.180 ↓ 1.2 637 1

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

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

Seq Scan on staged_iboe_grosses sig (cost=0.00..15.50 rows=550 width=34) (actual time=0.010..0.089 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)