explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6mnX

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 5.861 ↑ 1.7 643 1

Nested Loop (cost=1.00..4,994.44 rows=1,095 width=719) (actual time=0.038..5.861 rows=643 loops=1)

  • Buffers: shared hit=3293
2. 1.302 1.302 ↑ 1.7 643 1

Index Scan using index_routes_on_path_text_pattern_ops on public.routes rs (cost=0.56..4.59 rows=1,124 width=4) (actual time=0.023..1.302 rows=643 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: 71
  • Buffers: shared hit=719
3. 4.501 4.501 ↑ 1.0 1 643

Index Scan using projects_pkey on public.projects (cost=0.43..4.43 rows=1 width=719) (actual time=0.006..0.007 rows=1 loops=643)

  • Index Cond: (projects.id = rs.source_id)
  • Buffers: shared hit=2574