explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xlat : https://gitlab.com/gitlab-org/gitlab/-/merge_requests/24891

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3,852.251 3,968.069 ↓ 0.0 0 1

Bitmap Heap Scan on public.lfs_objects (cost=4.89..6.91 rows=1 width=4) (actual time=3,968.069..3,968.069 rows=0 loops=1)

  • Filter: ((lfs_objects.id >= 1) AND (lfs_objects.id <= 1000))
  • Rows Removed by Filter: 18
  • Buffers: shared hit=1 read=5601 dirtied=4682
  • I/O Timings: read=3870.361
2. 0.003 115.818 ↓ 0.0 0 1

BitmapOr (cost=4.89..4.89 rows=1 width=0) (actual time=115.818..115.818 rows=0 loops=1)

  • Buffers: shared hit=1 read=112
  • I/O Timings: read=111.312
3. 3.026 3.026 ↓ 13.0 13 1

Bitmap Index Scan using index_lfs_objects_on_file_store (cost=0.00..2.44 rows=1 width=0) (actual time=3.026..3.026 rows=13 loops=1)

  • Index Cond: (lfs_objects.file_store = 1)
  • Buffers: shared read=3
  • I/O Timings: read=3.006
4. 112.789 112.789 ↓ 27,814.0 27,814 1

Bitmap Index Scan using index_lfs_objects_on_file_store (cost=0.00..2.44 rows=1 width=0) (actual time=112.789..112.789 rows=27,814 loops=1)

  • Index Cond: (lfs_objects.file_store IS NULL)
  • Buffers: shared hit=1 read=109
  • I/O Timings: read=108.306