explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BfV9

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.090 ↓ 17.0 17 1

Sort (cost=4.82..4.82 rows=1 width=48) (actual time=0.089..0.090 rows=17 loops=1)

  • Sort Key: seats.seat_number DESC
  • Sort Method: quicksort Memory: 26kB
2.          

CTE rootseatpath

3. 0.013 0.013 ↑ 1.0 1 1

Index Scan using seats_pkey on seats seats_1 (cost=0.14..2.36 rows=1 width=293) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (seat_id = '5e799a7a-4a59-4e9b-887c-ed0a585b1de4'::uuid)
4.          

CTE seats

5. 0.058 0.074 ↓ 17.0 17 1

Index Scan using seats_seat_ancestor_path_gist_idx on seats seats_2 (cost=0.20..2.43 rows=1 width=21) (actual time=0.057..0.074 rows=17 loops=1)

  • Index Cond: (seat_ancestor_path <@ $1)
  • Filter: ((seat_ancestor_path <> $2) AND ((seat_number)::double precision <= ((($3)::double precision * '32768'::double precision) + '32767'::double precision)))
  • Rows Removed by Filter: 1
6.          

Initplan (forIndex Scan)

7. 0.015 0.015 ↑ 1.0 1 1

CTE Scan on rootseatpath (cost=0.00..0.02 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=1)

8. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on rootseatpath rootseatpath_1 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)

9. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on rootseatpath rootseatpath_2 (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=1)

10. 0.080 0.080 ↓ 17.0 17 1

CTE Scan on seats (cost=0.00..0.02 rows=1 width=48) (actual time=0.058..0.080 rows=17 loops=1)

Planning time : 0.184 ms
Execution time : 0.117 ms