explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 65Ol

Settings
# exclusive inclusive rows x rows loops node
1. 0.432 0.432 ↑ 54.8 5 1

Index Scan using ci_job_artifacts_pkey on ci_job_artifacts (cost=0.43..49.90 rows=274 width=4) (actual time=0.100..0.432 rows=5 loops=1)

  • Index Cond: ((id >= 1) AND (id <= 1,000))
  • Filter: ((file_store = 1) OR (file_store IS NULL))
  • Rows Removed by Filter: 375
  • Buffers: shared hit=144
Planning time : 0.251 ms
Execution time : 0.454 ms