explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.259 771.112 ↓ 203.0 203 1

Sort (cost=149,671.99..149,671.99 rows=1 width=386) (actual time=750.787..771.112 rows=203 loops=1)

  • Sort Key: romeo2.november, romeo8.three_zulu, romeo3.three_zulu
  • Sort Method: quicksort Memory: 129kB
2. 0.762 770.853 ↓ 203.0 203 1

Nested Loop Left Join (cost=1,001.40..149,671.98 rows=1 width=386) (actual time=223.950..770.853 rows=203 loops=1)

3. 0.081 769.482 ↓ 203.0 203 1

Nested Loop Left Join (cost=1,001.12..149,671.66 rows=1 width=206) (actual time=223.929..769.482 rows=203 loops=1)

4. 0.042 768.995 ↓ 203.0 203 1

Nested Loop Left Join (cost=1,000.85..149,669.16 rows=1 width=153) (actual time=223.921..768.995 rows=203 loops=1)

5. 0.148 768.547 ↓ 203.0 203 1

Nested Loop Left Join (cost=1,000.57..149,666.66 rows=1 width=128) (actual time=223.912..768.547 rows=203 loops=1)

6. 1.850 768.196 ↓ 203.0 203 1

Nested Loop (cost=1,000.43..149,666.51 rows=1 width=131) (actual time=223.904..768.196 rows=203 loops=1)

7. 24.644 752.585 ↓ 4,587.0 4,587 1

Gather (cost=1,000.00..149,663.86 rows=1 width=32) (actual time=223.835..752.585 rows=4,587 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 727.941 727.941 ↓ 1,529.0 1,529 3 / 3

Parallel Seq Scan on alpha four_uniform (cost=0.00..148,663.76 rows=1 width=32) (actual time=216.572..727.941 rows=1,529 loops=3)

  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (kilo_sierra >= 'four_foxtrot'::timestamp without time zone) AND (kilo_sierra <= 'uniform_hotel'::timestamp without time zone))
  • Rows Removed by Filter: 1,835,968
9. 13.761 13.761 ↓ 0.0 0 4,587

Index Scan using victor on foxtrot_romeo foxtrot_juliet (cost=0.43..2.65 rows=1 width=123) (actual time=0.003..0.003 rows=0 loops=4,587)

  • Index Cond: (quebec = romeo1.sierra_foxtrot)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (juliet = 2))
  • Rows Removed by Filter: 1
10. 0.203 0.203 ↑ 1.0 1 203

Index Scan using uniform_romeo on tango five_echo (cost=0.14..0.15 rows=1 width=13) (actual time=0.001..0.001 rows=1 loops=203)

  • Index Cond: (quebec = romeo2.four_sierra)
11. 0.406 0.406 ↑ 1.0 1 203

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

  • Index Cond: (quebec = romeo1.delta)
12. 0.406 0.406 ↑ 1.0 1 203

Index Scan using kilo_kilo on oscar three_quebec (cost=0.28..2.49 rows=1 width=69) (actual time=0.002..0.002 rows=1 loops=203)

  • Index Cond: (quebec = romeo1.four_delta)
13. 0.609 0.609 ↑ 1.0 1 203

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

  • Index Cond: (quebec = romeo2.lima)
Planning time : 1.541 ms
Execution time : 771.288 ms