explain.depesz.com

PostgreSQL's explain analyze made readable

Result: USuk

Settings
# exclusive inclusive rows x rows loops node
1. 0.992 10.811 ↓ 0.0 0 1

Insert on staged_iboe_grosses (cost=6,870.36..8,607.57 rows=200 width=119) (actual time=10.811..10.811 rows=0 loops=1)

2. 0.561 9.819 ↓ 3.2 637 1

Nested Loop Left Join (cost=6,870.36..8,607.57 rows=200 width=119) (actual time=4.888..9.819 rows=637 loops=1)

3. 0.557 5.436 ↓ 3.2 637 1

GroupAggregate (cost=6,869.80..6,886.57 rows=200 width=124) (actual time=4.843..5.436 rows=637 loops=1)

  • Group Key: "*VALUES*".column2, "*VALUES*".column3, "*VALUES*".column4
4. 0.379 4.879 ↓ 1.0 637 1

Sort (cost=6,869.80..6,871.39 rows=634 width=124) (actual time=4.816..4.879 rows=637 loops=1)

  • Sort Key: "*VALUES*".column2, "*VALUES*".column3, "*VALUES*".column4
  • Sort Method: quicksort Memory: 92kB
5. 0.108 4.500 ↓ 1.0 637 1

Nested Loop (cost=0.71..6,840.29 rows=634 width=124) (actual time=0.677..4.500 rows=637 loops=1)

6. 0.031 3.118 ↓ 1.0 637 1

Nested Loop (cost=0.42..3,819.75 rows=634 width=124) (actual time=0.223..3.118 rows=637 loops=1)

7. 1.176 1.176 ↓ 1.0 637 1

Values Scan on "*VALUES*" (cost=0.00..7.96 rows=634 width=124) (actual time=0.125..1.176 rows=637 loops=1)

  • Filter: (column6 IS NOT NULL)
8. 1.911 1.911 ↑ 1.0 1 637

Index Only Scan using pk_theaters on theaters th (cost=0.42..6.01 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=637)

  • Index Cond: (id = "*VALUES*".column2)
  • Heap Fetches: 637
9. 1.274 1.274 ↑ 1.0 1 637

Index Only Scan using pk_titles on titles ti (cost=0.29..4.76 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=637)

  • Index Cond: (id = "*VALUES*".column3)
  • Heap Fetches: 637
10. 3.822 3.822 ↑ 1.0 1 637

Index Scan using uq_iboe_grosses_1 on iboe_grosses ib (cost=0.56..8.58 rows=1 width=33) (actual time=0.006..0.006 rows=1 loops=637)

  • Index Cond: ((theater_id = "*VALUES*".column2) AND (title_id = "*VALUES*".column3) AND (booking_date = "*VALUES*".column4))
Planning time : 6.363 ms
Execution time : 11.004 ms