# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.159 | 427,121.186 | ↑ 1.0 | 938 | 1 |
→
Limit (cost=0.99..10,895.95 rows=938 width=12) (actual time=426,984.357..427,121.186 rows=938 loops=1)
|
2. | 0.582 | 427,121.027 | ↑ 239.4 | 938 | 1 |
→
Nested Loop (cost=0.99..2,607,880.61 rows=224,525 width=12) (actual time=426,984.355..427,121.027 rows=938 loops=1)
|
3. | 427,056.185 | 427,056.185 | ↑ 374.9 | 945 | 1 |
→
Index Scan using index_projects_on_last_repository_updated_at on public.projects (cost=0.56..2,385,901.54 rows=354,238 width=12) (actual time=426,973.191..427,056.185 rows=945 loops=1)
|
4. | 64.260 | 64.260 | ↑ 1.0 | 1 | 945 |
→
Index Only Scan using idx_repository_states_on_last_repository_verification_ran_at on public.project_repository_states (cost=0.43..0.62 rows=1 width=4) (actual time=0.068..0.068 rows=1 loops=945)
|