explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2eHj : Optimization for: Queri original; plan #Xq4J, Anadido columna en tabla

Settings

Optimization path:

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

Limit (cost=0.000..5.590 rows=30 width=1,136) (actual time=0.020..0.063 rows=30 loops=1)

  • Output: golf, november_foxtrot, delta, juliet, oscar_five, (xray(kilo, 'oscar_papa'::text)), oscar_juliet
  • Buffers: shared hit=8
2. 0.060 0.060 ↑ 4,000.0 30 1

Index Scan using echo on five_seven november_mike (cost=0.000..22,374.260 rows=120,000 width=1,136) (actual time=0.020..0.060 rows=30 loops=1)

  • Output: golf, november_foxtrot, delta, juliet, oscar_five, xray(kilo, 'oscar_papa'::text), oscar_juliet
  • Filter: ((november_mike.oscar_juliet five_romeo NOT NULL) AND (november_mike.mike = 1) AND (november_mike.delta <> 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