explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2ooA : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #3czy; plan #AGRF; plan #6hLh; plan #H9NA; plan #4qUs; plan #KVr2

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.279 195.534 ↓ 233.0 233 1

Sort (cost=125,442.24..125,442.25 rows=1 width=386) (actual time=163.984..195.534 rows=233 loops=1)

  • Sort Key: romeo2.november, romeo8.three_zulu, romeo3.three_zulu
  • Sort Method: quicksort Memory: 144kB
2. 0.824 195.255 ↓ 233.0 233 1

Nested Loop Left Join (cost=1,001.97..125,442.23 rows=1 width=386) (actual time=0.667..195.255 rows=233 loops=1)

3. 36.106 193.965 ↓ 233.0 233 1

Gather (cost=1,001.70..125,441.92 rows=1 width=232) (actual time=0.653..193.965 rows=233 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.115 157.859 ↓ 78.0 78 3 / 3

Nested Loop Left Join (cost=1.70..124,441.82 rows=1 width=232) (actual time=52.394..157.859 rows=78 loops=3)

  • Join Filter: (romeo2.four_sierra = romeo6.quebec)
  • Rows Removed by Join Filter: 108
5. 0.049 157.666 ↓ 78.0 78 3 / 3

Nested Loop (cost=1.70..124,440.53 rows=1 width=235) (actual time=52.388..157.666 rows=78 loops=3)

6. 0.072 157.462 ↓ 78.0 78 3 / 3

Nested Loop Left Join (cost=1.42..124,438.03 rows=1 width=243) (actual time=52.367..157.462 rows=78 loops=3)

7. 0.048 157.157 ↓ 78.0 78 3 / 3

Nested Loop Left Join (cost=1.14..124,435.53 rows=1 width=192) (actual time=52.352..157.157 rows=78 loops=3)

8. 0.090 156.954 ↓ 78.0 78 3 / 3

Nested Loop (cost=0.86..124,435.24 rows=1 width=139) (actual time=52.334..156.954 rows=78 loops=3)

9. 156.312 156.312 ↓ 92.0 92 3 / 3

Parallel Index Scan using golf on foxtrot_romeo foxtrot_juliet (cost=0.43..124,432.58 rows=1 width=123) (actual time=52.301..156.312 rows=92 loops=3)

  • Index Cond: (juliet_hotel = 2)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (mike >= 'four_foxtrot'::timestamp without time zone) AND (mike <= 'uniform_hotel'::timestamp without time zone))
  • Rows Removed by Filter: 52,416
10. 0.552 0.552 ↑ 1.0 1 276 / 3

Index Scan using juliet_six on alpha four_uniform (cost=0.43..2.65 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=276)

  • Index Cond: (sierra_foxtrot = romeo2.quebec)
  • Filter: ((NOT papa_bravo) OR (papa_bravo five_romeo NULL))
11. 0.155 0.155 ↑ 1.0 1 233 / 3

Index Scan using kilo on oscar three_quebec (cost=0.28..0.29 rows=1 width=69) (actual time=0.002..0.002 rows=1 loops=233)

  • Index Cond: (romeo1.four_delta = quebec)
12. 0.233 0.233 ↑ 1.0 1 233 / 3

Index Scan using sierra_delta on sierra_three india (cost=0.28..2.50 rows=1 width=67) (actual time=0.003..0.003 rows=1 loops=233)

  • Index Cond: (romeo2.lima = quebec)
13. 0.155 0.155 ↑ 1.0 1 233 / 3

Index Only Scan using two on echo xray (cost=0.27..2.49 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=233)

  • Index Cond: (quebec = 2)
  • Heap Fetches: 215
14. 0.078 0.078 ↑ 6.5 2 233 / 3

Seq Scan on tango five_echo (cost=0.00..1.13 rows=13 width=13) (actual time=0.001..0.001 rows=2 loops=233)

15. 0.466 0.466 ↑ 1.0 1 233

Index Scan using uniform_golf on whiskey papa_seven (cost=0.28..0.30 rows=1 width=41) (actual time=0.002..0.002 rows=1 loops=233)

  • Index Cond: (romeo1.delta = quebec)
Planning time : 1.709 ms
Execution time : 195.697 ms