explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PrMY

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 20.390 ↑ 1.0 1 1

Limit (cost=75.69..2,825.24 rows=1 width=4) (actual time=20.388..20.390 rows=1 loops=1)

  • Buffers: shared hit=1219 read=439 dirtied=11
  • I/O Timings: read=16.264
2. 0.185 20.387 ↑ 1.0 1 1

Hash Left Join (cost=75.69..2,825.24 rows=1 width=4) (actual time=20.387..20.387 rows=1 loops=1)

  • Hash Cond: (projects.id = index_statuses.project_id)
  • Filter: ((NOT index_statuses.records_initially_indexed) OR (index_statuses.records_initially_indexed IS NULL))
  • Rows Removed by Filter: 219
  • Buffers: shared hit=1219 read=439 dirtied=11
  • I/O Timings: read=16.264
3. 0.283 19.734 ↑ 5.0 220 1

Nested Loop (cost=1.00..2,746.42 rows=1,095 width=4) (actual time=0.116..19.734 rows=220 loops=1)

  • Buffers: shared hit=686 read=439 dirtied=11
  • I/O Timings: read=16.264
4. 10.211 10.211 ↑ 5.0 220 1

Index Scan using index_routes_on_path_text_pattern_ops on public.routes rs (cost=0.56..4.59 rows=1,111 width=4) (actual time=0.026..10.211 rows=220 loops=1)

  • Index Cond: (((rs.path)::text ~>=~ 'gitlab-org/'::text) AND ((rs.path)::text ~<~ 'gitlab-org0'::text))
  • Filter: (((rs.path)::text ~~ 'gitlab-org/%'::text) AND ((rs.source_type)::text = 'Project'::text))
  • Rows Removed by Filter: 31
  • Buffers: shared hit=32 read=225 dirtied=6
  • I/O Timings: read=8.804
5. 9.240 9.240 ↑ 1.0 1 220

Index Only Scan using projects_pkey on public.projects (cost=0.43..2.46 rows=1 width=4) (actual time=0.042..0.042 rows=1 loops=220)

  • Index Cond: (projects.id = rs.source_id)
  • Heap Fetches: 21
  • Buffers: shared hit=654 read=214 dirtied=5
  • I/O Timings: read=7.460
6. 0.111 0.468 ↑ 1.0 644 1

Hash (cost=66.65..66.65 rows=644 width=5) (actual time=0.468..0.468 rows=644 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
  • Buffers: shared hit=530
7. 0.357 0.357 ↑ 1.0 644 1

Index Scan using index_index_statuses_on_project_id on public.index_statuses (cost=0.28..66.65 rows=644 width=5) (actual time=0.004..0.357 rows=644 loops=1)

  • Buffers: shared hit=530