2025-03-15 09:12:41.304
2e0cff23-9440-0adb-efaf-bc28f70d3190
 0.518 ms
tilemap |  piechart
timetilemap
#
node, ms
tree, ms
rows
node
187754.3403612425
итоговые результаты (110MB = rows=3612425 x width=32)
0
168845.485
187754.340
3612425
Hash Right Join
1
4216.992
8210240
  ->  Seq Scan on dds__do_task_3 task
2
13827.236
14691.863
3612425
  ->  Hash
3
864.627
3612425
       ->  Index Only Scan using "6b47db6c79341ca5aaa6ff7203ab391b" on dds__do_bp_full_3 bp
10.739
 
Planning Time
184.033
 
JIT
187.112
187941.452
Execution Time
Hash Right Join  (cost=205714.37..1275091.05 rows=10321111 width=32) (actual time=16465.514..187754.340 rows=3612425 loops=1)
  Hash Cond: (task.id = bp.parent_task_id)
  ->  Seq Scan on dds__do_task_3 task  (cost=0.00..765518.61 rows=8311061 width=32) (actual time=0.042..4216.992 rows=8210240 loops=1)
  ->  Hash  (cost=135889.73..135889.73 rows=3611091 width=32) (actual time=14691.861..14691.863 rows=3612425 loops=1)
        Buckets: 131072 (originally 131072)  Batches: 524288 (originally 64)  Memory Usage: 63604kB
        ->  Index Only Scan using "6b47db6c79341ca5aaa6ff7203ab391b" on dds__do_bp_full_3 bp  (cost=0.43..135889.73 rows=3611091 width=32) (actual time=1.646..864.627 rows=3612425 loops=1)
              Heap Fetches: 131
Planning Time: 10.739 ms
JIT:
  Functions: 8
  Options: Inlining true, Optimization true, Expressions true, Deforming true
  Timing: Generation 1.387 ms, Inlining 5.920 ms, Optimization 40.474 ms, Emission 136.252 ms, Total 184.033 ms
Execution Time: 187941.452 ms
      
время % rows тип узла таблица индекс узлы
168845.485
89.9
3612425
Hash Right Join
0
13827.236
7.4
3612425
Hash
2
4216.992
2.2
8210240
Seq Scan
dds__do_task_3
1
864.627
0.5
3612425
Index Only Scan
dds__do_bp_full_3
6b47db6c79341ca5aaa6ff7203ab391b
3
tooltip