explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3czy

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 59.841 1,310.130 ↑ 1.9 314 1

Gather Merge (cost=186,494.63..186,564.63 rows=600 width=386) (actual time=1,265.409..1,310.130 rows=314 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.285 1,250.289 ↑ 2.9 105 3 / 3

Sort (cost=185,494.60..185,495.35 rows=300 width=386) (actual time=1,250.269..1,250.289 rows=105 loops=3)

  • Sort Key: romeo2.november, romeo8.three_zulu, romeo3.three_zulu
  • Sort Method: quicksort Memory: 77kB
3. 0.606 1,250.004 ↑ 2.9 105 3 / 3

Nested Loop Left Join (cost=2.83..185,482.26 rows=300 width=386) (actual time=1,171.684..1,250.004 rows=105 loops=3)

4. 0.045 1,249.084 ↑ 2.9 105 3 / 3

Nested Loop Left Join (cost=2.56..185,385.29 rows=300 width=204) (actual time=1,171.616..1,249.084 rows=105 loops=3)

5. 0.176 1,248.725 ↑ 2.9 105 3 / 3

Hash Left Join (cost=2.28..185,293.62 rows=300 width=179) (actual time=1,171.594..1,248.725 rows=105 loops=3)

  • Hash Cond: (romeo2.four_sierra = romeo6.quebec)
6. 0.081 1,246.410 ↑ 2.9 105 3 / 3

Nested Loop (cost=0.99..185,291.29 rows=300 width=182) (actual time=1,169.346..1,246.410 rows=105 loops=3)

7. 0.093 1,246.015 ↑ 2.9 105 3 / 3

Nested Loop Left Join (cost=0.71..184,541.29 rows=300 width=190) (actual time=1,169.294..1,246.015 rows=105 loops=3)

8. 1.663 1,245.399 ↑ 2.9 105 3 / 3

Nested Loop (cost=0.43..184,450.13 rows=300 width=139) (actual time=1,169.268..1,245.399 rows=105 loops=3)

9. 1,229.750 1,229.750 ↑ 4.8 2,331 3 / 3

Parallel Seq Scan on alpha four_uniform (cost=0.00..159,840.01 rows=11,176 width=32) (actual time=1,165.448..1,229.750 rows=2,331 loops=3)

  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND ((kilo_sierra)::date >= 'whiskey_kilo'::date) AND ((kilo_sierra)::date <= 'golf'::date))
  • Rows Removed by Filter: 1,835,110
10. 13.986 13.986 ↓ 0.0 0 6,993 / 3

Index Scan using victor on foxtrot_romeo foxtrot_juliet (cost=0.43..2.20 rows=1 width=123) (actual time=0.006..0.006 rows=0 loops=6,993)

  • Index Cond: (quebec = romeo1.sierra_foxtrot)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (juliet = 2))
  • Rows Removed by Filter: 1
11. 0.523 0.523 ↑ 1.0 1 314 / 3

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

  • Index Cond: (romeo2.lima = quebec)
12. 0.314 0.314 ↑ 1.0 1 314 / 3

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

  • Index Cond: (quebec = 2)
  • Heap Fetches: 102
13. 0.009 2.139 ↑ 1.0 13 3 / 3

Hash (cost=1.13..1.13 rows=13 width=13) (actual time=2.139..2.139 rows=13 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 2.130 2.130 ↑ 1.0 13 3 / 3

Seq Scan on tango five_echo (cost=0.00..1.13 rows=13 width=13) (actual time=0.011..2.130 rows=13 loops=3)

15. 0.314 0.314 ↑ 1.0 1 314 / 3

Index Scan using uniform on whiskey_tango papa_seven (cost=0.28..0.31 rows=1 width=41) (actual time=0.003..0.003 rows=1 loops=314)

  • Index Cond: (romeo1.delta = quebec)
16. 0.314 0.314 ↑ 1.0 1 314 / 3

Index Scan using kilo_kilo on oscar three_quebec (cost=0.28..0.31 rows=1 width=69) (actual time=0.003..0.003 rows=1 loops=314)

  • Index Cond: (romeo1.four_delta = quebec)
Planning time : 1.993 ms
Execution time : 1,310.290 ms