explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EHmJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.292 0.292 ↑ 1.9 380 1

Index Only Scan using ci_job_artifacts_pkey on ci_job_artifacts (cost=0.43..21.30 rows=737 width=4) (actual time=0.007..0.292 rows=380 loops=1)

  • Index Cond: ((id >= 1) AND (id <= 1,000))
  • Heap Fetches: 5
  • Buffers: shared hit=6 read=3
  • I/O Timings: read=0.155
Planning time : 1.527 ms
Execution time : 0.345 ms