explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aOrVl

Settings
# exclusive inclusive rows x rows loops node
1. 1.082 10.851 ↑ 1.4 1,102 1

Nested Loop (cost=1.00..5,362.80 rows=1,499 width=734) (actual time=0.050..10.851 rows=1,102 loops=1)

  • Buffers: shared hit=5,517
2. 2.055 2.055 ↑ 1.4 1,102 1

Index Scan using index_routes_on_path_text_pattern_ops_and_source_type on public.routes rs (cost=0.56..3.59 rows=1,564 width=4) (actual time=0.029..2.055 rows=1,102 loops=1)

  • Index Cond: (((rs.path)::text ~>=~ 'gitlab-org/'::text) AND ((rs.path)::text ~<~ 'gitlab-org0'::text) AND ((rs.source_type)::text = 'Project'::text))
  • Filter: ((rs.path)::text ~~ 'gitlab-org/%'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,108
3. 7.714 7.714 ↑ 1.0 1 1,102

Index Scan using projects_pkey on public.projects (cost=0.43..3.43 rows=1 width=734) (actual time=0.007..0.007 rows=1 loops=1,102)

  • Index Cond: (projects.id = rs.source_id)
  • Buffers: shared hit=4,409