# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.022 | 0.180 | ↓ 1.2 | 7 | 1 |
→
Sort (cost=89.53..89.54 rows=6 width=125) (actual time=0.180..0.180 rows=7 loops=1)
|
2. |
CTE cmr_with_prev |
|||||
3. | 0.022 | 0.051 | ↑ 1.0 | 13 | 1 |
→
WindowAgg (cost=32.28..32.70 rows=13 width=67) (actual time=0.035..0.051 rows=13 loops=1) |
4. | 0.016 | 0.029 | ↑ 1.0 | 13 | 1 |
→
Sort (cost=32.28..32.31 rows=13 width=50) (actual time=0.026..0.029 rows=13 loops=1)
|
5. | 0.008 | 0.013 | ↑ 1.0 | 13 | 1 |
→
Bitmap Heap Scan on customer_mrr_readings cmr (cost=4.38..32.04 rows=13 width=50) (actual time=0.009..0.013 rows=13 loops=1)
|
6. | 0.005 | 0.005 | ↑ 1.0 | 13 | 1 |
→
Bitmap Index Scan on index_customer_mrr_readings_on_customer_id_and_date (cost=0.00..4.38 rows=13 width=0) (actual time=0.005..0.005 rows=13 loops=1)
|
7. |
CTE cmr_with_is_change |
|||||
8. | 0.063 | 0.063 | ↑ 1.0 | 13 | 1 |
→
CTE Scan on cmr_with_prev (cost=0.00..0.39 rows=13 width=94) (actual time=0.037..0.063 rows=13 loops=1) |
9. |
CTE cmr_with_end_date |
|||||
10. | 0.007 | 0.092 | ↓ 1.2 | 7 | 1 |
→
WindowAgg (cost=0.34..0.47 rows=6 width=102) (actual time=0.087..0.092 rows=7 loops=1) |
11. | 0.014 | 0.085 | ↓ 1.2 | 7 | 1 |
→
Sort (cost=0.34..0.35 rows=6 width=94) (actual time=0.084..0.085 rows=7 loops=1)
|
12. | 0.071 | 0.071 | ↓ 1.2 | 7 | 1 |
→
CTE Scan on cmr_with_is_change (cost=0.00..0.26 rows=6 width=94) (actual time=0.038..0.071 rows=7 loops=1)
|
13. |
CTE mrr_intervals |
|||||
14. | 0.002 | 0.153 | ↓ 1.2 | 7 | 1 |
→
Nested Loop (cost=0.85..55.77 rows=6 width=86) (actual time=0.101..0.153 rows=7 loops=1) |
15. | 0.002 | 0.144 | ↓ 1.2 | 7 | 1 |
→
Nested Loop (cost=0.71..54.69 rows=6 width=86) (actual time=0.099..0.144 rows=7 loops=1) |
16. | 0.001 | 0.135 | ↓ 1.2 | 7 | 1 |
→
Nested Loop (cost=0.56..53.63 rows=6 width=74) (actual time=0.097..0.135 rows=7 loops=1) |
17. | 0.006 | 0.127 | ↓ 1.2 | 7 | 1 |
→
Nested Loop (cost=0.42..51.04 rows=6 width=62) (actual time=0.095..0.127 rows=7 loops=1) |
18. | 0.009 | 0.114 | ↓ 1.2 | 7 | 1 |
→
Nested Loop (cost=0.28..49.97 rows=6 width=37) (actual time=0.093..0.114 rows=7 loops=1) |
19. | 0.098 | 0.098 | ↓ 1.2 | 7 | 1 |
→
CTE Scan on cmr_with_end_date (cost=0.00..0.12 rows=6 width=13) (actual time=0.088..0.098 rows=7 loops=1) |
20. | 0.007 | 0.007 | ↑ 1.0 | 1 | 7 |
→
Index Scan using customer_mrr_readings_pkey on customer_mrr_readings cmr_1 (cost=0.28..8.30 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=7)
|
21. | 0.007 | 0.007 | ↑ 1.0 | 1 | 7 |
→
Index Scan using customer_subscriptions_pkey on customer_subscriptions cs (cost=0.14..0.17 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=7)
|
22. | 0.007 | 0.007 | ↑ 1.0 | 1 | 7 |
→
Index Scan using customers_pkey on customers c (cost=0.14..0.42 rows=1 width=20) (actual time=0.001..0.001 rows=1 loops=7)
|
23. | 0.007 | 0.007 | ↑ 1.0 | 1 | 7 |
→
Index Scan using plans_pkey on plans (cost=0.14..0.17 rows=1 width=20) (actual time=0.001..0.001 rows=1 loops=7)
|
24. | 0.007 | 0.007 | ↑ 1.0 | 1 | 7 |
→
Index Scan using currencies_pkey on currencies (cost=0.14..0.17 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=7)
|
25. | 0.158 | 0.158 | ↓ 1.2 | 7 | 1 |
→
CTE Scan on mrr_intervals (cost=0.00..0.12 rows=6 width=125) (actual time=0.103..0.158 rows=7 loops=1) |