explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ui1j : Optimization for: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/24891; plan #xlat

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.025 0.025 ↓ 0.0 0 1

Index Scan using index_lfs_objects_on_file_store on public.lfs_objects (cost=0.44..2.46 rows=1 width=4) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (lfs_objects.file_store = 1)
  • Filter: ((lfs_objects.id >= 1) AND (lfs_objects.id <= 1000))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=4