explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8JNg

Settings
# exclusive inclusive rows x rows loops node
1. 1.524 1,210.050 ↑ 1.7 643 1

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

  • Buffers: shared hit=1850 read=1455 dirtied=28
  • I/O Timings: read=1183.403
2. 37.623 37.623 ↑ 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.050..37.623 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=295 read=424 dirtied=8
  • I/O Timings: read=31.166
3. 1,170.903 1,170.903 ↑ 1.0 1 643

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

  • Index Cond: (projects.id = rs.source_id)
  • Buffers: shared hit=1555 read=1031 dirtied=20
  • I/O Timings: read=1152.237