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