explain.depesz.com

PostgreSQL's explain analyze made readable

Result: esUx

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 8,052.643 ↑ 1.0 1 1

Limit (cost=0.86..50.58 rows=1 width=525) (actual time=8,052.637..8,052.643 rows=1 loops=1)

2. 85.879 8,052.635 ↑ 29,538.0 1 1

WindowAgg (cost=0.86..1,468,775.09 rows=29,538 width=525) (actual time=8,052.634..8,052.635 rows=1 loops=1)

3. 53.779 7,966.756 ↓ 1.0 30,121 1

Nested Loop Left Join (cost=0.86..1,468,405.87 rows=29,538 width=517) (actual time=59.045..7,966.756 rows=30,121 loops=1)

4. 6,045.475 6,045.475 ↓ 1.0 30,121 1

Index Scan using "PK_booking" on booking b (cost=0.43..1,301,348.23 rows=29,538 width=418) (actual time=58.996..6,045.475 rows=30,121 loops=1)

  • Filter: (owner = '50913377'::text)
  • Rows Removed by Filter: 3,676,617
5. 1,867.502 1,867.502 ↑ 1.0 1 30,121

Index Scan using booking_journey_booking_idx on journey j (cost=0.43..5.65 rows=1 width=99) (actual time=0.062..0.062 rows=1 loops=30,121)

  • Index Cond: (b.booking_id = booking_id)
Planning time : 0.417 ms
Execution time : 8,054.571 ms