explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7lB9

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

Index Scan using ci_job_artifacts_pkey on ci_job_artifacts (cost=0.43..51.74 rows=274 width=4) (actual time=0.029..0.401 rows=5 loops=1)

  • Index Cond: ((id >= 1) AND (id <= 1,000))
  • Filter: (((expire_at IS NULL) OR (expire_at > '2020-06-22 23:20:35.372104+00'::timestamp with time zone)) AND ((file_store = 1) OR (file_store IS NULL)))
  • Rows Removed by Filter: 375
  • Buffers: shared hit=144
Planning time : 0.396 ms
Execution time : 0.428 ms