Changes between Version 25 and Version 26 of OtherTopics
- Timestamp:
- 03/03/26 08:10:42 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
OtherTopics
v25 v26 390 390 391 391 {{{ 392 "Incremental Sort (cost=18709.65..51808.79 rows=139071 width=321) (actual time=1 599.321..4115.097 rows=54435.00 loops=1)"392 "Incremental Sort (cost=18709.65..51808.79 rows=139071 width=321) (actual time=1203.775..4048.807 rows=54435.00 loops=1)" 393 393 " Sort Key: (to_char(date_trunc('month'::text, s.date_time), 'YYYY-MM'::text)) DESC, (sum(((si.quantity)::numeric * si.unit_price_at_sale))) DESC" 394 394 " Presorted Key: (to_char(date_trunc('month'::text, s.date_time), 'YYYY-MM'::text))" … … 396 396 " Pre-sorted Groups: 12 Sort Method: quicksort Average Memory: 568kB Peak Memory: 615kB" 397 397 " Buffers: shared hit=3632, temp read=1176 written=1178" 398 " -> GroupAggregate (cost=18708.99..48041.17 rows=139071 width=321) (actual time= 1209.156..4037.823rows=54435.00 loops=1)"398 " -> GroupAggregate (cost=18708.99..48041.17 rows=139071 width=321) (actual time=962.536..3915.891 rows=54435.00 loops=1)" 399 399 " Group Key: (to_char(date_trunc('month'::text, s.date_time), 'YYYY-MM'::text)), w.name, c.name, sup.name" 400 400 " Buffers: shared hit=3632, temp read=1176 written=1178" 401 " -> Incremental Sort (cost=18708.99..42478.33 rows=139071 width=287) (actual time= 1208.198..3762.995rows=137806.00 loops=1)"401 " -> Incremental Sort (cost=18708.99..42478.33 rows=139071 width=287) (actual time=962.508..3639.938 rows=137806.00 loops=1)" 402 402 " Sort Key: (to_char(date_trunc('month'::text, s.date_time), 'YYYY-MM'::text)) DESC, w.name, c.name, sup.name, s.sale_id" 403 403 " Presorted Key: (to_char(date_trunc('month'::text, s.date_time), 'YYYY-MM'::text))" … … 405 405 " Pre-sorted Groups: 12 Sort Method: quicksort Average Memory: 1262kB Peak Memory: 1387kB" 406 406 " Buffers: shared hit=3632, temp read=1176 written=1178" 407 " -> Nested Loop (cost=18708.54..38710.70 rows=139071 width=287) (actual time= 1201.290..1877.549rows=137806.00 loops=1)"407 " -> Nested Loop (cost=18708.54..38710.70 rows=139071 width=287) (actual time=954.168..1565.615 rows=137806.00 loops=1)" 408 408 " Buffers: shared hit=3632, temp read=1176 written=1178" 409 " -> Gather Merge (cost=18708.38..34558.39 rows=139071 width=49) (actual time= 1200.687..1491.543rows=137806.00 loops=1)"409 " -> Gather Merge (cost=18708.38..34558.39 rows=139071 width=49) (actual time=954.104..1231.027 rows=137806.00 loops=1)" 410 410 " Workers Planned: 1" 411 411 " Workers Launched: 1" 412 412 " Buffers: shared hit=3626, temp read=1176 written=1178" 413 " -> Sort (cost=17708.37..17912.89 rows=81806 width=49) (actual time= 1024.503..1057.136rows=68903.00 loops=2)"413 " -> Sort (cost=17708.37..17912.89 rows=81806 width=49) (actual time=800.477..843.097 rows=68903.00 loops=2)" 414 414 " Sort Key: (to_char(date_trunc('month'::text, s.date_time), 'YYYY-MM'::text)) DESC" 415 " Sort Method: external merge Disk: 4 016kB"415 " Sort Method: external merge Disk: 4384kB" 416 416 " Buffers: shared hit=3626, temp read=1176 written=1178" 417 " Worker 0: Sort Method: external merge Disk: 5 392kB"418 " -> Hash Left Join (cost=3417.20..8236.54 rows=81806 width=49) (actual time= 255.672..807.691rows=68903.00 loops=2)"417 " Worker 0: Sort Method: external merge Disk: 5024kB" 418 " -> Hash Left Join (cost=3417.20..8236.54 rows=81806 width=49) (actual time=120.116..557.712 rows=68903.00 loops=2)" 419 419 " Hash Cond: (p.supplier_id = sup.supplier_id)" 420 420 " Buffers: shared hit=3618" 421 " -> Hash Left Join (cost=3415.08..8001.47 rows=81806 width=41) (actual time= 252.428..677.672rows=68903.00 loops=2)"421 " -> Hash Left Join (cost=3415.08..8001.47 rows=81806 width=41) (actual time=119.725..377.104 rows=68903.00 loops=2)" 422 422 " Hash Cond: (p.category_id = c.category_id)" 423 423 " Buffers: shared hit=3616" 424 " -> Hash Join (cost=3412.95..7766.40 rows=81806 width=34) (actual time= 244.604..579.219rows=68903.00 loops=2)"424 " -> Hash Join (cost=3412.95..7766.40 rows=81806 width=34) (actual time=119.386..319.506 rows=68903.00 loops=2)" 425 425 " Hash Cond: (si.product_id = p.product_id)" 426 426 " Buffers: shared hit=3614" 427 " -> Parallel Hash Join (cost=3233.45..7371.99 rows=81806 width=30) (actual time= 233.780..521.518 rows=68903.00 loops=2)"427 " -> Parallel Hash Join (cost=3233.45..7371.99 rows=81806 width=30) (actual time=116.983..266.418 rows=68903.00 loops=2)" 428 428 " Hash Cond: (si.sale_id = s.sale_id)" 429 429 " Buffers: shared hit=3480" 430 " -> Parallel Seq Scan on sale_item si (cost=0.00..3675.36 rows=176436 width=18) (actual time=0.0 59..150.696 rows=149971.00 loops=2)"430 " -> Parallel Seq Scan on sale_item si (cost=0.00..3675.36 rows=176436 width=18) (actual time=0.010..27.036 rows=149971.00 loops=2)" 431 431 " Buffers: shared hit=1911" 432 " -> Parallel Hash (cost=2892.53..2892.53 rows=27274 width=16) (actual time= 233.129..233.132rows=22972.00 loops=2)"432 " -> Parallel Hash (cost=2892.53..2892.53 rows=27274 width=16) (actual time=116.725..116.728 rows=22972.00 loops=2)" 433 433 " Buckets: 65536 Batches: 1 Memory Usage: 2688kB" 434 434 " Buffers: shared hit=1569" 435 " -> Parallel Seq Scan on sale s (cost=0.00..2892.53 rows=27274 width=16) (actual time= 43.247..214.762 rows=22972.00 loops=2)"435 " -> Parallel Seq Scan on sale s (cost=0.00..2892.53 rows=27274 width=16) (actual time=0.738..209.158 rows=45944.00 loops=1)" 436 436 " Filter: (date_time >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone) - '11 mons'::interval))" 437 " Rows Removed by Filter: 27028"437 " Rows Removed by Filter: 54056" 438 438 " Buffers: shared hit=1569" 439 " -> Hash (cost=117.00..117.00 rows=5000 width=12) (actual time= 10.740..10.741rows=5000.00 loops=2)"439 " -> Hash (cost=117.00..117.00 rows=5000 width=12) (actual time=2.353..2.354 rows=5000.00 loops=2)" 440 440 " Buckets: 8192 Batches: 1 Memory Usage: 279kB" 441 441 " Buffers: shared hit=134" 442 " -> Seq Scan on product p (cost=0.00..117.00 rows=5000 width=12) (actual time=0. 680..9.123rows=5000.00 loops=2)"442 " -> Seq Scan on product p (cost=0.00..117.00 rows=5000 width=12) (actual time=0.305..1.369 rows=5000.00 loops=2)" 443 443 " Buffers: shared hit=134" 444 " -> Hash (cost=1.50..1.50 rows=50 width=15) (actual time= 7.694..7.695rows=50.00 loops=2)"444 " -> Hash (cost=1.50..1.50 rows=50 width=15) (actual time=0.321..0.321 rows=50.00 loops=2)" 445 445 " Buckets: 1024 Batches: 1 Memory Usage: 11kB" 446 446 " Buffers: shared hit=2" 447 " -> Seq Scan on category c (cost=0.00..1.50 rows=50 width=15) (actual time= 7.644..7.651 rows=50.00 loops=2)"447 " -> Seq Scan on category c (cost=0.00..1.50 rows=50 width=15) (actual time=0.294..0.301 rows=50.00 loops=2)" 448 448 " Buffers: shared hit=2" 449 " -> Hash (cost=1.50..1.50 rows=50 width=16) (actual time= 2.823..2.824 rows=50.00 loops=2)"449 " -> Hash (cost=1.50..1.50 rows=50 width=16) (actual time=0.243..0.244 rows=50.00 loops=2)" 450 450 " Buckets: 1024 Batches: 1 Memory Usage: 11kB" 451 451 " Buffers: shared hit=2" 452 " -> Seq Scan on supplier sup (cost=0.00..1.50 rows=50 width=16) (actual time= 2.792..2.798rows=50.00 loops=2)"452 " -> Seq Scan on supplier sup (cost=0.00..1.50 rows=50 width=16) (actual time=0.219..0.226 rows=50.00 loops=2)" 453 453 " Buffers: shared hit=2" 454 454 " -> Memoize (cost=0.15..0.17 rows=1 width=222) (actual time=0.000..0.000 rows=1.00 loops=137806)" … … 457 457 " Hits: 137803 Misses: 3 Evictions: 0 Overflows: 0 Memory Usage: 1kB" 458 458 " Buffers: shared hit=6" 459 " -> Index Scan using warehouse_pkey on warehouse w (cost=0.14..0.16 rows=1 width=222) (actual time=0.0 35..0.035 rows=1.00 loops=3)"459 " -> Index Scan using warehouse_pkey on warehouse w (cost=0.14..0.16 rows=1 width=222) (actual time=0.015..0.015 rows=1.00 loops=3)" 460 460 " Index Cond: (warehouse_id = s.warehouse_id)" 461 461 " Index Searches: 3" … … 463 463 "Planning:" 464 464 " Buffers: shared hit=36" 465 "Planning Time: 20.237ms"466 "Execution Time: 4 141.771ms"467 }}} 468 469 '''Времетраење: 4 141.771ms'''465 "Planning Time: 1.863 ms" 466 "Execution Time: 4099.577 ms" 467 }}} 468 469 '''Времетраење: 4099.577 ms''' 470 470 471 471 '''Анализа:''' По добро.
