explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FevS : Optimization for: plan #ctr

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=25,230.870..25,230.880 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=25,230.660..25,230.870 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=24,230.660..24,230.670 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.850..24,230.660 rows=1 width=0) (actual rows= loops=)

  • Join Filter: ((xray.tango)::text = (alpha_november.bravo_tango)::text)
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.850..24,196.890 rows=1 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.430..24,189.100 rows=1 width=20) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on november (cost=0.000..23,401.570 rows=94 width=24) (actual rows= loops=)

  • Filter: ((six_victor >= 'two_victor'::timestamp with time zone) AND (six_victor <= 'five_bravo'::timestamp with time zone) AND (quebec_five = 90) AND (two_charlie = 1) AND (six_whiskey = 75))
8. 0.000 0.000 ↓ 0.0

Index Scan using zulu_three on three alpha_november (cost=0.430..8.380 rows=1 width=37) (actual rows= loops=)

  • Index Cond: ((echo)::text = (november.alpha_golf)::text)
  • Filter: (juliet = ANY ('five_mike'::integer[]))
9. 0.000 0.000 ↓ 0.0

Index Scan using bravo_xray on zulu_hotel (cost=0.420..7.790 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (zulu_kilo = november.quebec_seven)
10. 0.000 0.000 ↓ 0.0

Seq Scan on bravo_two xray (cost=0.000..23.340 rows=834 width=21) (actual rows= loops=)