explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xq4J : Queri original

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 0.214 ↑ 1.0 30 1

Limit (cost=0.000..20.190 rows=30 width=1,136) (actual time=0.101..0.214 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=59 read=10
2. 0.024 0.211 ↑ 2,769.2 30 1

Nested Loop (cost=0.000..55,903.560 rows=83,077 width=1,136) (actual time=0.100..0.211 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=59 read=10
3. 0.127 0.127 ↑ 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.075..0.127 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=1 read=8
4. 0.060 0.060 ↑ 1.0 1 30

Index Scan using foxtrot on delta_november three (cost=0.000..0.270 rows=1 width=41) (actual time=0.001..0.002 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=2