explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cDeY

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.143 ↑ 1.0 30 1

Limit (cost=0.000..20.190 rows=30 width=1,136) (actual time=0.069..0.143 rows=30 loops=1)

  • Output: november_mike.golf, november_mike.november_foxtrot, november_mike.delta_xray, november_mike.juliet, november_mike.oscar_five, (xray(november_mike.kilo, 'oscar_papa'::text)), three.oscar_juliet
  • Buffers: shared hit=66 read=3
2. 0.023 0.141 ↑ 2,769.2 30 1

Nested Loop (cost=0.000..55,903.560 rows=83,077 width=1,136) (actual time=0.069..0.141 rows=30 loops=1)

  • Output: november_mike.golf, november_mike.november_foxtrot, november_mike.delta_xray, november_mike.juliet, november_mike.oscar_five, xray(november_mike.kilo, 'oscar_papa'::text), three.oscar_juliet
  • Buffers: shared hit=66 read=3
3. 0.028 0.028 ↑ 4,000.0 30 1

Index Scan using echo on five_seven november_mike (cost=0.000..22,074.260 rows=120,000 width=1,099) (actual time=0.010..0.028 rows=30 loops=1)

  • Output: november_mike.golf, november_mike.november_foxtrot, november_mike.delta_xray, november_mike.juliet, november_mike.oscar_five, november_mike.kilo
  • Filter: ((november_mike.mike = 1) AND (november_mike.delta_xray <> november_november ('november_kilo'::integer[])) AND ((NOT november_mike.papa_papa) OR (november_mike.papa_papa AND (november_mike.papa_tango < (zulu() - 'november_zulu'::interval)))))
  • Buffers: shared hit=8
4. 0.090 0.090 ↑ 1.0 1 30

Index Scan using foxtrot on delta_november three (cost=0.000..0.270 rows=1 width=41) (actual time=0.002..0.003 rows=1 loops=30)

  • Output: three.delta_xray, three.india_five, three.oscar_juliet, three.india_delta, three.kilo, three.papa_tango, three.yankee, three.hotel, three.oscar_five, three.november_uniform
  • Index Cond: (three.delta_xray = november_mike.delta_xray)
  • Filter: (three.oscar_juliet five_romeo NOT NULL)
  • Buffers: shared hit=58 read=3