explain.depesz.com

PostgreSQL's explain analyze made readable

Result: erJ3

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 255.515 ↓ 0.0 0 1

Nested Loop (cost=1,000.28..95,108.47 rows=1 width=542) (actual time=255.515..255.515 rows=0 loops=1)

2. 3.210 255.513 ↓ 0.0 0 1

Gather (cost=1,000.00..94,997.54 rows=1 width=489) (actual time=255.513..255.513 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 252.303 252.303 ↓ 0.0 0 3

Parallel Seq Scan on user_pre_bookings upb (cost=0.00..93,997.44 rows=1 width=489) (actual time=252.303..252.303 rows=0 loops=3)

  • Filter: ((updated_at >= '2019-07-11 23:16:00'::timestamp without time zone) AND (updated_at < '2019-07-11 23:17:00'::timestamp without time zone))
  • Rows Removed by Filter: 731029
4. 0.000 0.000 ↓ 0.0 0

Index Scan using pre_book_config_pkey on pre_book_config pbc (cost=0.28..8.29 rows=1 width=21) (never executed)

  • Index Cond: (pre_bookable_session_id = upb.pre_bookable_session_id)
5.          

SubPlan (forNested Loop)

6. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=102.62..102.63 rows=1 width=32) (never executed)

7. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=102.30..102.55 rows=3 width=37) (never executed)

  • Group Key: pbsd.day, pbsd.display_text
8. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=102.30..102.43 rows=3 width=56) (never executed)

  • Group Key: pbsd.day, pbsd.display_text, c.display_name
9. 0.000 0.000 ↓ 0.0 0

Sort (cost=102.30..102.31 rows=3 width=40) (never executed)

  • Sort Key: pbsd.day, pbsd.display_text, c.display_name
10. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..102.27 rows=3 width=40) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..80.97 rows=3 width=39) (never executed)

  • Join Filter: (pbss.show_number = sn.id)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on show_names sn (cost=0.00..1.05 rows=5 width=12) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.29..79.70 rows=3 width=31) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..79.69 rows=3 width=31) (never executed)

  • Join Filter: (pbss.cinema_id = c.id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using pre_book_session_shows_pkey on pre_book_session_shows pbss (cost=0.29..78.08 rows=10 width=20) (never executed)

  • Index Cond: (id = ANY (upb.show_ids))
16. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.06 rows=4 width=23) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on locations c (cost=0.00..1.04 rows=4 width=23) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using pre_book_session_days_pkey on pre_book_session_days pbsd (cost=0.28..7.10 rows=1 width=13) (never executed)

  • Index Cond: (id = pbss.day_id)
19.          

SubPlan (forGroupAggregate)

20. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=32) (never executed)

21.          

SubPlan (forGroupAggregate)

22. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=32) (never executed)

23.          

SubPlan (forAggregate)

24. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=32) (never executed)

Planning time : 2.324 ms
Execution time : 257.895 ms