explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TOHf

Settings
# exclusive inclusive rows x rows loops node
1. 0.467 16.100 ↑ 1.7 643 1

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

  • Buffers: shared hit=3214 read=9
  • I/O Timings: read=0.608
2. 2.130 2.130 ↑ 1.7 643 1

Index Scan using routes_type_and_path_pattern_ops on public.routes rs (cost=0.56..4.59 rows=1,124 width=4) (actual time=0.376..2.130 rows=643 loops=1)

  • Index Cond: (((rs.source_type)::text = 'Project'::text) AND ((rs.path)::text ~>=~ 'gitlab-org/'::text) AND ((rs.path)::text ~<~ 'gitlab-org0'::text))
  • Filter: ((rs.path)::text ~~ 'gitlab-org/%'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=640 read=9
  • I/O Timings: read=0.608
3. 13.503 13.503 ↑ 1.0 1 643

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

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