# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.045 | ↓ 0.0 | 0 | 1 |
→
Nested Loop Left Join (cost=309.53..19,934.69 rows=17,239 width=1,512) (actual time=0.045..0.045 rows=0 loops=1) |
2. | 0.000 | 0.045 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=309.10..2,223.55 rows=17,239 width=165) (actual time=0.045..0.045 rows=0 loops=1) |
3. | 0.001 | 0.045 | ↓ 0.0 | 0 | 1 |
→
HashAggregate (cost=9.15..9.16 rows=1 width=8) (actual time=0.045..0.045 rows=0 loops=1)
|
4. | 0.021 | 0.044 | ↓ 0.0 | 0 | 1 |
→
Hash Join (cost=2.21..9.14 rows=1 width=8) (actual time=0.044..0.044 rows=0 loops=1)
|
5. | 0.008 | 0.008 | ↑ 67.0 | 1 | 1 |
→
Seq Scan on provider provider3_ (cost=0.00..6.67 rows=67 width=16) (actual time=0.008..0.008 rows=1 loops=1) |
6. | 0.000 | 0.015 | ↓ 0.0 | 0 | 1 |
→
Hash (cost=2.20..2.20 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=1)
|
7. | 0.015 | 0.015 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on module module2_ (cost=0.00..2.20 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=1)
|
8. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Bitmap Heap Scan on provider_link providerli0_ (cost=299.96..2,042.00 rows=17,239 width=165) (never executed)
|
|
9. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Bitmap Index Scan on idx_provider_link_provider_id (cost=0.00..295.65 rows=20,449 width=0) (never executed)
|
|
10. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using activation_code_pkey on activation_code activation1_ (cost=0.43..1.02 rows=1 width=1,347) (never executed)
|
Planning time | : | 0.808 ms |
---|