explain.depesz.com

PostgreSQL's explain analyze made readable

Result: khYz

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 122.891 ↓ 0.0 0 1

Hash Join (cost=15.99..20,253.30 rows=1 width=4) (actual time=122.891..122.891 rows=0 loops=1)

  • Hash Cond: (lfs_objects_projects.lfs_object_id = lfs_objects.id)
  • Buffers: shared hit=105,460
2. 0.141 122.122 ↑ 10.7 20 1

Unique (cost=1.12..20,235.74 rows=214 width=4) (actual time=2.675..122.122 rows=20 loops=1)

  • Buffers: shared hit=105,250
3. 16.327 121.981 ↓ 2.4 511 1

Nested Loop (cost=1.12..20,235.20 rows=214 width=4) (actual time=2.673..121.981 rows=511 loops=1)

  • Buffers: shared hit=105,250
4. 8.630 8.630 ↓ 2.5 24,256 1

Index Only Scan using test_index on public.lfs_objects_projects (cost=0.56..464.48 rows=9,759 width=8) (actual time=0.034..8.630 rows=24,256 loops=1)

  • Index Cond: ((lfs_objects_projects.lfs_object_id >= 1) AND (lfs_objects_projects.lfs_object_id <= 1,000))
  • Heap Fetches: 158
  • Buffers: shared hit=7,577
5. 97.024 97.024 ↓ 0.0 0 24,256

Index Only Scan using idx_projects_on_repository_storage_last_repository_updated_at on public.projects (cost=0.56..2.03 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=24,256)

  • Index Cond: ((projects.id = lfs_objects_projects.project_id) AND (projects.repository_storage = 'nfs-file22'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=97,673
6. 0.011 0.720 ↑ 3.2 34 1

Hash (cost=13.49..13.49 rows=110 width=4) (actual time=0.719..0.720 rows=34 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=210
7. 0.709 0.709 ↑ 3.2 34 1

Index Scan using index_lfs_objects_on_file_store on public.lfs_objects (cost=0.56..13.49 rows=110 width=4) (actual time=0.660..0.709 rows=34 loops=1)

  • Index Cond: (lfs_objects.file_store = 1)
  • Buffers: shared hit=210