explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gS6i : Optimization for: plan #cDeY

Settings

Optimization path:

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

Limit (cost=0.000..5.590 rows=30 width=1,136) (actual time=0.018..0.059 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.056 0.056 ↑ 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.017..0.056 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