# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.020 | 11.939 | ↓ 6.0 | 6 | 1 |
→
Hash Join (cost=2,190.00..3,169.14 rows=1 width=5,684) (actual time=0.248..11.939 rows=6 loops=1)
|
2. |
CTE clients_rescore |
|||||
3. | 0.014 | 0.074 | ↑ 18.8 | 8 | 1 |
→
Nested Loop (cost=0.29..1,078.75 rows=150 width=32) (actual time=0.027..0.074 rows=8 loops=1) |
4. | 0.012 | 0.012 | ↑ 18.8 | 8 | 1 |
→
Seq Scan on clients_fa_tmp cf (cost=0.00..11.50 rows=150 width=516) (actual time=0.006..0.012 rows=8 loops=1) |
5. | 0.048 | 0.048 | ↑ 1.0 | 1 | 8 |
→
Index Scan using clients_pkey on clients c_1 (cost=0.29..7.10 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=8)
|
6. |
CTE accounts_rescore |
|||||
7. | 0.013 | 0.092 | ↑ 12.5 | 12 | 1 |
→
Nested Loop (cost=0.41..1,101.50 rows=150 width=54) (actual time=0.016..0.092 rows=12 loops=1) |
8. | 0.007 | 0.007 | ↑ 12.5 | 12 | 1 |
→
Seq Scan on accounts_fa_tmp af (cost=0.00..11.50 rows=150 width=516) (actual time=0.003..0.007 rows=12 loops=1) |
9. | 0.072 | 0.072 | ↑ 1.0 | 1 | 12 |
→
Index Scan using accounts_pkey on accounts a_1 (cost=0.41..7.26 rows=1 width=54) (actual time=0.006..0.006 rows=1 loops=12)
|
10. | 6.095 | 11.831 | ↑ 12.5 | 12 | 1 |
→
Hash Join (cost=4.88..983.44 rows=150 width=2,601) (actual time=0.143..11.831 rows=12 loops=1)
|
11. | 5.620 | 5.620 | ↑ 1.0 | 24,150 | 1 |
→
Seq Scan on client_accounts r (cost=0.00..886.50 rows=24,150 width=44) (actual time=0.003..5.620 rows=24,150 loops=1) |
12. | 0.010 | 0.116 | ↑ 12.5 | 12 | 1 |
→
Hash (cost=3.00..3.00 rows=150 width=3,096) (actual time=0.116..0.116 rows=12 loops=1)
|
13. | 0.106 | 0.106 | ↑ 12.5 | 12 | 1 |
→
CTE Scan on accounts_rescore a (cost=0.00..3.00 rows=150 width=3,096) (actual time=0.018..0.106 rows=12 loops=1) |
14. | 0.007 | 0.088 | ↑ 18.8 | 8 | 1 |
→
Hash (cost=3.00..3.00 rows=150 width=3,096) (actual time=0.088..0.088 rows=8 loops=1)
|
15. | 0.081 | 0.081 | ↑ 18.8 | 8 | 1 |
→
CTE Scan on clients_rescore c (cost=0.00..3.00 rows=150 width=3,096) (actual time=0.029..0.081 rows=8 loops=1) |