explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eAFe

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

Limit (cost=0.48..0.55 rows=1 width=4) (actual time=0.249..0.250 rows=1 loops=1)

  • Buffers: shared hit=1 read=3
  • I/O Timings: read=0.174
2. 0.248 0.248 ↑ 105,970.5 2 1

Index Only Scan using i1 on public.ci_job_artifacts (cost=0.42..13,350.43 rows=211,941 width=4) (actual time=0.247..0.248 rows=2 loops=1)

  • Index Cond: (ci_job_artifacts.job_id >= 571)
  • Heap Fetches: 0
  • Buffers: shared hit=1 read=3
  • I/O Timings: read=0.174