explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VVGIh

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 13.742 ↑ 1.0 1 1

Limit (cost=0.56..3.58 rows=1 width=80) (actual time=13.741..13.742 rows=1 loops=1)

  • Buffers: shared read=5
  • I/O Timings: read=13.681
2. 13.740 13.740 ↑ 1.0 1 1

Index Scan using xray on victor (cost=0.56..3.58 rows=1 width=80) (actual time=13.740..13.740 rows=1 loops=1)

  • Index Cond: (((tango.yankee)::text = 'kilo'::text) AND (tango.alpha = 278,964))
  • Buffers: shared read=5
  • I/O Timings: read=13.681