explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5RCt

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.297 ↑ 1.0 1 1

Limit (cost=1.27..841.08 rows=1 width=4) (actual time=2.296..2.297 rows=1 loops=1)

2. 0.016 2.296 ↑ 3.0 1 1

Nested Loop Left Join (cost=1.27..2,520.69 rows=3 width=4) (actual time=2.296..2.296 rows=1 loops=1)

  • Filter: (index_statuses.last_commit IS NULL)
  • Rows Removed by Filter: 219
3. 0.139 1.840 ↑ 4.9 220 1

Nested Loop (cost=1.00..2,193.74 rows=1,079 width=4) (actual time=0.040..1.840 rows=220 loops=1)

4. 0.601 0.601 ↑ 5.1 220 1

Index Scan using index_routes_on_path_text_pattern_ops on routes rs (cost=0.56..3.59 rows=1,116 width=4) (actual time=0.023..0.601 rows=220 loops=1)

  • Index Cond: (((path)::text ~>=~ 'gitlab-org/'::text) AND ((path)::text ~<~ 'gitlab-org0'::text))
  • Filter: (((path)::text ~~ 'gitlab-org/%'::text) AND ((source_type)::text = 'Project'::text))
  • Rows Removed by Filter: 31
5. 1.100 1.100 ↑ 1.0 1 220

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

  • Index Cond: (id = rs.source_id)
  • Heap Fetches: 19
6. 0.440 0.440 ↑ 1.0 1 220

Index Scan using index_index_statuses_on_project_id on index_statuses (cost=0.28..0.29 rows=1 width=45) (actual time=0.002..0.002 rows=1 loops=220)

  • Index Cond: (project_id = projects.id)