explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 19Z : Optimization for: plan #6K3u

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.007 137.677 ↓ 0.0 0 1

Sort (cost=43,228.68..43,234.95 rows=2,505 width=219) (actual time=121.896..137.677 rows=0 loops=1)

  • Sort Key: romeo1.lima, romeo1.foxtrot_bravo DESC, romeo1.mike DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.002 137.670 ↓ 0.0 0 1

Nested Loop (cost=1,001.26..43,087.27 rows=2,505 width=219) (actual time=121.889..137.670 rows=0 loops=1)

3. 0.010 0.010 ↑ 1.0 1 1

Index Scan using kilo on oscar_oscar victor (cost=0.28..2.49 rows=1 width=69) (actual time=0.008..0.010 rows=1 loops=1)

  • Index Cond: (quebec = 152)
4. 18.728 137.658 ↓ 0.0 0 1

Gather (cost=1,000.99..43,059.73 rows=2,505 width=166) (actual time=121.878..137.658 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
5. 3.225 118.930 ↓ 0.0 0 2 / 2

Nested Loop (cost=0.99..41,809.23 rows=1,474 width=166) (actual time=118.930..118.930 rows=0 loops=2)

6. 35.115 35.115 ↑ 2.0 8,954 2 / 2

Parallel Index Scan using papa_yankee on foxtrot_romeo four_uniform (cost=0.56..6,935.31 rows=17,814 width=166) (actual time=0.039..35.115 rows=8,954 loops=2)

  • Index Cond: ((lima)::text = ANY ('oscar_quebec'::text[]))
  • Filter: ((NOT papa_bravo) OR (papa_bravo five NULL))
  • Rows Removed by Filter: 4,762
7. 80.590 80.590 ↓ 0.0 0 17,909 / 2

Index Scan using charlie on uniform india (cost=0.43..1.95 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=17,909)

  • Index Cond: (sierra = romeo1.quebec)
  • Filter: (four_delta = 152)
  • Rows Removed by Filter: 1
Planning time : 0.435 ms
Execution time : 137.730 ms