explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mv0S : Optimization for: Current; plan #OKN1

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.007 425.364 ↓ 2.0 2 1

Nested Loop (cost=1.270..52,064.770 rows=1 width=1,264) (actual time=46.318..425.364 rows=2 loops=1)

2. 0.067 425.319 ↓ 2.0 2 1

Nested Loop (cost=0.570..52,061.640 rows=1 width=886) (actual time=46.290..425.319 rows=2 loops=1)

  • Join Filter: ((alpha_charlie.india_juliet)::text = (kilo_foxtrot.november)::text)
  • Rows Removed by Join Filter: 688
3. 425.090 425.090 ↓ 6.0 6 1

Index Scan using xray_hotel on zulu alpha_charlie (cost=0.570..52,055.030 rows=1 width=886) (actual time=6.194..425.090 rows=6 loops=1)

  • Index Cond: ((yankee_seven >= 'kilo_uniform'::timestamp with time zone) AND (yankee_seven <= 'six'::timestamp with time zone))
  • Filter: ((NOT golf_november) AND ((golf_uniform)::text = ANY ('bravo_tango'::text[])) AND ((echo five NULL) OR (echo < 'bravo_whiskey'::timestamp with time zone)) AND (papa_xray >= 120000000) AND (papa_xray <= 840000000) AND ((three)::text = ANY ('hotel'::text[])) AND ((india_charlie > 0) OR ((papa_bravo)::text = 'four'::text)) AND ((papa_bravo)::text = ANY ('whiskey'::text[])))
  • Rows Removed by Filter: 509010
4. 0.162 0.162 ↑ 1.0 115 6

Seq Scan on delta_seven kilo_foxtrot (cost=0.000..5.180 rows=115 width=16) (actual time=0.004..0.027 rows=115 loops=6)

  • Filter: ((golf_quebec)::text = 'foxtrot'::text)
  • Rows Removed by Filter: 59
5. 0.038 0.038 ↑ 1.0 1 2

Index Scan using xray_sierra on uniform yankee_foxtrot (cost=0.700..3.120 rows=1 width=252) (actual time=0.019..0.019 rows=1 loops=2)

  • Index Cond: ((delta_victor)::text = (alpha_charlie.delta_victor)::text)
  • Filter: (NOT two(tango, 'alpha_november'::text))
Planning time : 1.144 ms
Execution time : 425.457 ms