explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g9Vq

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 0.141 ↑ 1.0 1 1

Limit (cost=0.13..3.68 rows=1 width=144) (actual time=0.140..0.141 rows=1 loops=1)

  • Buffers: shared hit=1 read=1
  • I/O Timings: read=0.040
2. 0.086 0.086 ↑ 1.0 1 1

Index Scan using i1 on public.environments (cost=0.13..3.68 rows=1 width=144) (actual time=0.086..0.086 rows=1 loops=1)

  • Index Cond: (environments.auto_stop_at < now())
  • Buffers: shared hit=1 read=1
  • I/O Timings: read=0.040