# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=6,848.56..6,848.57 rows=4 width=554) (actual rows= loops=) |
||
2. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=6,848.56..6,848.57 rows=4 width=554) (actual rows= loops=)
|
||
3. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=644.93..6,848.52 rows=4 width=554) (actual rows= loops=) |
||
4. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Semi Join (cost=644.51..6,814.47 rows=4 width=514) (actual rows= loops=) |
||
5. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on artisans (cost=639.34..5,861.99 rows=25 width=514) (actual rows= loops=)
|
||
6. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on index_artisans_on_latitude_and_longitude (cost=0.00..639.34 rows=5,022 width=0) (actual rows= loops=)
|
||
7. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Semi Join (cost=5.17..38.09 rows=1 width=16) (actual rows= loops=) |
||
8. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Semi Join (cost=4.89..37.77 rows=1 width=48) (actual rows= loops=) |
||
9. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on qualifications_obtenues (cost=4.48..35.98 rows=2 width=32) (actual rows= loops=)
|
||
10. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on index_qualifications_obtenues_on_artisan_id (cost=0.00..4.48 rows=8 width=0) (actual rows= loops=)
|
||
11. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Semi Join (cost=0.41..0.88 rows=1 width=16) (actual rows= loops=) |
||
12. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using index_operations_qualifications_on_qualification_id on operations_qualifications operations_qualifications_1 (cost=0.28..0.33 rows=3 width=32) (actual rows= loops=)
|
||
13. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using index_types_travaux_on_operation_id on types_travaux (cost=0.14..0.17 rows=1 width=16) (actual rows= loops=)
|
||
14. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using index_operations_qualifications_on_qualification_id on operations_qualifications (cost=0.28..0.33 rows=3 width=16) (actual rows= loops=)
|
||
15. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using entreprises_pkey on entreprises (cost=0.42..8.44 rows=1 width=16) (actual rows= loops=)
|