explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OKN1 : Current

Settings

Optimization(s) for this plan:

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

Nested Loop (cost=1.270..9,663.610 rows=1 width=1,264) (actual time=98.723..98.723 rows=0 loops=1)

2. 0.024 98.723 ↓ 0.0 0 1

Nested Loop (cost=0.570..9,660.480 rows=1 width=886) (actual time=98.723..98.723 rows=0 loops=1)

  • Join Filter: ((alpha_charlie.india_juliet)::text = (kilo_foxtrot.november_lima)::text)
  • Rows Removed by Join Filter: 345
3. 98.609 98.609 ↓ 3.0 3 1

Index Scan using november_november on zulu alpha_charlie (cost=0.570..9,653.870 rows=1 width=886) (actual time=82.293..98.609 rows=3 loops=1)

  • Index Cond: ((yankee_seven >= 'kilo_uniform'::timestamp with time zone) AND (yankee_seven <= 'six'::timestamp with time zone) AND (papa_xray >= 395083813) AND (papa_xray <= 840000000))
  • 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 ((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: 98861
4. 0.090 0.090 ↑ 1.0 115 3

Seq Scan on delta_seven kilo_foxtrot (cost=0.000..5.180 rows=115 width=16) (actual time=0.005..0.030 rows=115 loops=3)

  • Filter: ((golf_quebec)::text = 'foxtrot'::text)
  • Rows Removed by Filter: 59
5. 0.000 0.000 ↓ 0.0 0

Index Scan using xray on uniform yankee_foxtrot (cost=0.700..3.120 rows=1 width=252) (never executed)

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