explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sIjL : Optimization for: Optimization for: plan #jG7T; plan #RGAU

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.087 2,300.646 ↓ 0.0 0 1

Sort (cost=520,127.93..520,413.28 rows=114,140 width=56) (actual time=2,300.565..2,300.646 rows=0 loops=1)

  • Sort Key: hotel.foxtrot, hotel.mike DESC, hotel.lima DESC
  • Sort Method: quicksort Memory: 25kB
2.          

CTE hotel

3. 0.002 2,300.637 ↓ 0.0 0 1

Recursive Union (cost=113,115.89..508,257.11 rows=114,140 width=56) (actual time=2,300.557..2,300.637 rows=0 loops=1)

4. 0.004 2,300.631 ↓ 0.0 0 1

Sort (cost=113,115.89..113,398.44 rows=113,020 width=56) (actual time=2,300.552..2,300.631 rows=0 loops=1)

  • Sort Key: (five(echo.sierra)) DESC
  • Sort Method: quicksort Memory: 25kB
5. 74.595 2,300.627 ↓ 0.0 0 1

Finalize HashAggregate (cost=102,499.80..103,630.00 rows=113,020 width=56) (actual time=2,300.548..2,300.627 rows=0 loops=1)

  • Group Key: echo.sierra
  • Filter: (five(echo.sierra) > 1)
  • Rows Removed by Filter: 121,409
6. 52.686 2,226.032 ↓ 1.3 121,409 1

Gather (cost=91,904.10..101,793.42 rows=94,184 width=16) (actual time=2,163.384..2,226.032 rows=121,409 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
7. 70.963 2,173.346 ↓ 1.3 60,704 2 / 2

Partial HashAggregate (cost=90,904.10..91,375.02 rows=47,092 width=16) (actual time=2,152.803..2,173.346 rows=60,704 loops=2)

  • Group Key: echo.sierra
8. 2,102.383 2,102.383 ↓ 1.3 60,704 2 / 2

Parallel Seq Scan on echo (cost=0.00..90,668.64 rows=47,092 width=8) (actual time=2,000.019..2,102.383 rows=60,704 loops=2)

  • Filter: (victor_five >= 'golf'::timestamp without time zone)
  • Rows Removed by Filter: 2,819,058
9. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.43..39,257.59 rows=112 width=56) (actual time=0.003..0.004 rows=0 loops=1)

10. 0.003 0.003 ↓ 0.0 0 1

WorkTable Scan on (cost=0.00..25,429.50 rows=5,651 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (mike = 'delta'::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using papa on echo victor_romeo (cost=0.43..2.44 rows=1 width=16) (never executed)

  • Index Cond: (sierra = juliet1.foxtrot)
  • Filter: (victor_five >= 'golf'::timestamp without time zone)
12. 2,300.559 2,300.559 ↓ 0.0 0 1

CTE Scan on hotel (cost=0.00..2,282.80 rows=114,140 width=56) (actual time=2,300.559..2,300.559 rows=0 loops=1)

Planning time : 0.261 ms
Execution time : 2,303.171 ms