#	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)

 Limit  (cost=1.27..841.08 rows=1 width=4) (actual time=2.296..2.297 rows=1 loops=1)
   ->  Nested Loop Left Join  (cost=1.27..2520.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
         ->  Nested Loop  (cost=1.00..2193.74 rows=1079 width=4) (actual time=0.040..1.840 rows=220 loops=1)
               ->  Index Scan using index_routes_on_path_text_pattern_ops on routes rs  (cost=0.56..3.59 rows=1116 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
               ->  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
         ->  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)

Per node type stats

node type	count	sum of times	% of query
Index Only Scan	1	1.100 ms	47.9 %
Index Scan	2	1.041 ms	45.3 %
Limit	1	0.001 ms	0.0 %
Nested Loop	1	0.139 ms	6.1 %
Nested Loop Left Join	1	0.016 ms	0.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
index_statuses	1	0.440 ms	19.2 %
Index Scan	1	0.440 ms	100.0 %
projects	1	1.100 ms	47.9 %
Index Only Scan	1	1.100 ms	100.0 %
routes	1	0.601 ms	26.2 %
Index Scan	1	0.601 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5RCt

Color mode:

Visible columns:

Per node type stats

Per table stats