2021-08-24 12:52:39.914
f2ca16443f985984cd74a71d7cda7670
 0.961 ms
#5 IS |
tilemap |  piechart
time | bufferstilemap
#
node, ms
tree, ms
rows
loops
CTE Scan on dcFunction Scan on unnest idLimitIndex Scan using doc_customer_id_dt_idx on doc
sh.ht
.0847
итоговые результаты
19
0
.008
.084
7
CTE Scan on dc
1
  CTE dc
2
.013
.076
7
   ->  Function Scan on unnest id
3
        SubPlan 1
4
.007
.063
7
7
         ->  Limit
5
.056
7
7
              ->  Index Scan using doc_customer_id_dt_idx on doc
19
.215
 
Planning Time
.040
.124
Execution Time
по затраченному времени | по использованию данныхdoc_customer_id_dt_idxdocdoc_customer_id_dt_idxdoc7LimitLimit71unnest idunnest iddcdcdc
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"
время % rows loops тип узла таблица индекс узлы sh.ht
.056
66.7
7
7
Index Scan
doc
doc_customer_id_dt_idx
5
19
.013
15.5
7
Function Scan
unnest
2
.008
9.5
7
CTE Scan
dc
0
.007
8.3
7
7
Limit
4
tooltip