# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.048 | ↓ 0.0 | 0 | 1 |
→
Nested Loop Left Join (cost=309.41..19,927.44 rows=17,225 width=1,512) (actual time=0.048..0.048 rows=0 loops=1) |
2. | 0.000 | 0.048 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=308.98..2,223.00 rows=17,225 width=165) (actual time=0.048..0.048 rows=0 loops=1) |
3. | 0.000 | 0.048 | ↓ 0.0 | 0 | 1 |
→
HashAggregate (cost=9.15..9.16 rows=1 width=8) (actual time=0.048..0.048 rows=0 loops=1)
|
4. | 0.009 | 0.048 | ↓ 0.0 | 0 | 1 |
→
Hash Join (cost=2.21..9.14 rows=1 width=8) (actual time=0.048..0.048 rows=0 loops=1)
|
5. | 0.023 | 0.023 | ↑ 67.0 | 1 | 1 |
→
Seq Scan on provider provider3_ (cost=0.00..6.67 rows=67 width=16) (actual time=0.023..0.023 rows=1 loops=1) |
6. | 0.001 | 0.016 | ↓ 0.0 | 0 | 1 |
→
Hash (cost=2.20..2.20 rows=1 width=8) (actual time=0.016..0.016 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.83..2,041.60 rows=17,225 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.53 rows=20,433 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.968 ms |
---|