#5
IS |
tilemap |
piechart
#
|
node, ms
|
tree, ms
|
rows
|
loops
|
|
|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
.084 | 7 | 19
| ||||||||||||
0 | .008
| .084
| 7
|
| ||||||||||
1 |
| |||||||||||||
2 | .013
| .076
| 7
|
| ||||||||||
3 |
| |||||||||||||
4 | .007
| .063
| 7
| 7 |
| |||||||||
5 | .056
| 7
| 7 |
|
19
| |||||||||
.215 |
| |||||||||||||
.040 | .124 |
| ||||||||||||
CTE Scan on dc (actual time=0.053..0.084 rows=7 loops=1) Buffers: shared hit=19 CTE dc -> Function Scan on unnest id (actual time=0.049..0.076 rows=7 loops=1) Buffers: shared hit=19 SubPlan 1 -> Limit (actual time=0.008..0.009 rows=1 loops=7) Buffers: shared hit=19 -> Index Scan using doc_customer_id_dt_idx on doc (actual time=0.008..0.008 rows=1 loops=7) Index Cond: (customer_id = id.id) Buffers: shared hit=19 Planning Time: 0.215 ms Execution Time: 0.124 ms
Scan CTE dc CTE dc -> Scan Function unnest SubPlan 1 -> Limit -> Scan Table doc
"CTE Scan on dc (actual time=0.053..0.084 rows=7 loops=1)" " Buffers: shared hit=19" " CTE dc" " -> Function Scan on unnest id (actual time=0.049..0.076 rows=7 loops=1)" " Buffers: shared hit=19" " SubPlan 1" " -> Limit (actual time=0.008..0.009 rows=1 loops=7)" " Buffers: shared hit=19" " -> Index Scan using doc_customer_id_dt_idx on doc (actual time=0.008..0.008 rows=1 loops=7)" " Index Cond: (customer_id = id.id)" " Buffers: shared hit=19" "Planning Time: 0.215 ms" "Execution Time: 0.124 ms"