explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uhVr

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

Update on iboe_grosses (cost=2,496.61..2,504.56 rows=1 width=220) (actual time=605.938..605.938 rows=0 loops=1)

2. 0.001 605.937 ↓ 0.0 0 1

Nested Loop (cost=2,496.61..2,504.56 rows=1 width=220) (actual time=605.936..605.937 rows=0 loops=1)

3. 0.001 605.936 ↓ 0.0 0 1

HashAggregate (cost=2,496.17..2,496.18 rows=1 width=104) (actual time=605.936..605.936 rows=0 loops=1)

  • Group Key: ig.id
4. 0.356 605.935 ↓ 0.0 0 1

Hash Left Join (cost=47.06..2,496.17 rows=1 width=104) (actual time=605.935..605.935 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. 4.146 604.968 ↓ 29.0 637 1

Hash Semi Join (cost=21.94..2,466.33 rows=22 width=118) (actual time=270.257..604.968 rows=637 loops=1)

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

Nested Loop (cost=18.89..2,460.13 rows=1,106 width=90) (actual time=260.963..600.716 rows=35,707 loops=1)

7. 0.006 0.015 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=88) (actual time=0.014..0.015 rows=1 loops=1)

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

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

9. 0.000 0.000 ↑ 1.0 1 1

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

10. 338.015 595.166 ↓ 3,246.1 35,707 1

Bitmap Heap Scan on iboe_grosses ig (cost=18.87..2,459.99 rows=11 width=66) (actual time=260.943..595.166 rows=35,707 loops=1)

  • Recheck Cond: ((country_id = 'US'::text) AND (distributor_id = "ANY_subquery".column1))
  • Filter: ((booking_date >= '2019-04-12'::date) AND (booking_date <= '2019-04-18'::date))
  • Rows Removed by Filter: 2288834
  • Heap Blocks: exact=25098
11. 257.151 257.151 ↓ 3,689.7 2,324,541 1

Bitmap Index Scan on ix_iboe_grosses_country_distributor (cost=0.00..18.86 rows=630 width=0) (actual time=257.151..257.151 rows=2,324,541 loops=1)

  • Index Cond: ((country_id = 'US'::text) AND (distributor_id = "ANY_subquery".column1))
12. 0.035 0.106 ↑ 1.0 122 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
13. 0.071 0.071 ↑ 1.0 122 1

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

14. 0.152 0.611 ↓ 1.2 637 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 53kB
15. 0.459 0.459 ↓ 1.2 637 1

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

16. 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)
Planning time : 1.849 ms
Execution time : 606.415 ms