explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vQoy

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=65,686.68..65,686.69 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,302.57..65,686.64 rows=17 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,008.46..60,686.34 rows=17 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,008.32..60,579.03 rows=17 width=48) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,008.32..60,578.52 rows=17 width=324) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..60,436.74 rows=17 width=384) (actual rows= loops=)

  • Workers Planned: 2
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on booking (cost=0.00..59,435.04 rows=7 width=384) (actual rows= loops=)

  • Filter: ((dropbox_file_request IS NOT NULL) AND ((dropbox_file_request -> 'auto_raw_editing'::text) IS NULL) AND ((status)::text <> 'cancelled'::text) AND ((status)::text = ANY ('{paid,completed}'::text[])))
8. 0.000 0.000 ↓ 0.0

Limit (cost=8.31..8.32 rows=1 width=144) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Sort (cost=8.31..8.32 rows=1 width=144) (actual rows= loops=)

  • Sort Key: booking_submission.created_at DESC
10. 0.000 0.000 ↓ 0.0

Index Scan using booking_submission_booking_uid_index on booking_submission (cost=0.29..8.30 rows=1 width=144) (actual rows= loops=)

  • Index Cond: (booking_uid = booking.uid)
11. 0.000 0.000 ↓ 0.0

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

12. 0.000 0.000 ↓ 0.0

Index Scan using location_polygon_idx on location (cost=0.15..6.30 rows=1 width=1,276) (actual rows= loops=)

  • Index Cond: (st_flipcoordinates(booking.point) && st_flipcoordinates(polygon))
  • Filter: _st_intersects(st_flipcoordinates(booking.point), st_flipcoordinates(polygon))
13. 0.000 0.000 ↓ 0.0

Limit (cost=294.11..294.12 rows=1 width=32) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Sort (cost=294.11..294.12 rows=1 width=32) (actual rows= loops=)

  • Sort Key: editor_time.started_at DESC
15. 0.000 0.000 ↓ 0.0

Seq Scan on editor_time (cost=0.00..294.10 rows=1 width=32) (actual rows= loops=)

  • Filter: (booking_uid = booking.uid)