Changes between Version 23 and Version 24 of OtherTopics
- Timestamp:
- 03/03/26 08:04:19 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
OtherTopics
v23 v24 390 390 391 391 {{{ 392 "Incremental Sort (cost=18709.65..51808.79 rows=139071 width=321) (actual time=15 02.222..5150.389rows=54435.00 loops=1)"392 "Incremental Sort (cost=18709.65..51808.79 rows=139071 width=321) (actual time=1599.321..4115.097 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))" 395 395 " Full-sort Groups: 12 Sort Method: quicksort Average Memory: 30kB Peak Memory: 30kB" 396 396 " Pre-sorted Groups: 12 Sort Method: quicksort Average Memory: 568kB Peak Memory: 615kB" 397 " Buffers: shared hit=3632, temp read=117 7 written=1180"398 " -> GroupAggregate (cost=18708.99..48041.17 rows=139071 width=321) (actual time=12 44.690..4960.802rows=54435.00 loops=1)"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.823 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 " Buffers: shared hit=3632, temp read=117 7 written=1180"401 " -> Incremental Sort (cost=18708.99..42478.33 rows=139071 width=287) (actual time=12 44.650..4576.663rows=137806.00 loops=1)"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.995 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))" 404 404 " Full-sort Groups: 12 Sort Method: quicksort Average Memory: 30kB Peak Memory: 30kB" 405 405 " Pre-sorted Groups: 12 Sort Method: quicksort Average Memory: 1262kB Peak Memory: 1387kB" 406 " Buffers: shared hit=3632, temp read=117 7 written=1180"407 " -> Nested Loop (cost=18708.54..38710.70 rows=139071 width=287) (actual time=12 18.041..1921.274rows=137806.00 loops=1)"408 " Buffers: shared hit=3632, temp read=117 7 written=1180"409 " -> Gather Merge (cost=18708.38..34558.39 rows=139071 width=49) (actual time=12 17.896..1527.876rows=137806.00 loops=1)"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.549 rows=137806.00 loops=1)" 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.543 rows=137806.00 loops=1)" 410 410 " Workers Planned: 1" 411 411 " Workers Launched: 1" 412 " Buffers: shared hit=3626, temp read=117 7 written=1180"413 " -> Sort (cost=17708.37..17912.89 rows=81806 width=49) (actual time=10 35.053..1072.735rows=68903.00 loops=2)"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.136 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: 3808kB"416 " Buffers: shared hit=3626, temp read=117 7 written=1180"417 " Worker 0: Sort Method: external merge Disk: 5 608kB"418 " -> Hash Left Join (cost=3417.20..8236.54 rows=81806 width=49) (actual time= 187.902..755.631 rows=68903.00 loops=2)"415 " Sort Method: external merge Disk: 4016kB" 416 " Buffers: shared hit=3626, temp read=1176 written=1178" 417 " Worker 0: Sort Method: external merge Disk: 5392kB" 418 " -> Hash Left Join (cost=3417.20..8236.54 rows=81806 width=49) (actual time=255.672..807.691 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= 187.231..600.377rows=68903.00 loops=2)"421 " -> Hash Left Join (cost=3415.08..8001.47 rows=81806 width=41) (actual time=252.428..677.672 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= 186.809..561.244rows=68903.00 loops=2)"424 " -> Hash Join (cost=3412.95..7766.40 rows=81806 width=34) (actual time=244.604..579.219 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= 178.945..485.528 rows=68903.00 loops=2)"427 " -> Parallel Hash Join (cost=3233.45..7371.99 rows=81806 width=30) (actual time=233.780..521.518 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 33..63.853rows=149971.00 loops=2)"430 " -> Parallel Seq Scan on sale_item si (cost=0.00..3675.36 rows=176436 width=18) (actual time=0.059..150.696 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= 177.467..177.471rows=22972.00 loops=2)"432 " -> Parallel Hash (cost=2892.53..2892.53 rows=27274 width=16) (actual time=233.129..233.132 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= 0.572..152.678rows=22972.00 loops=2)"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)" 436 436 " Filter: (date_time >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone) - '11 mons'::interval))" 437 437 " Rows Removed by Filter: 27028" 438 438 " Buffers: shared hit=1569" 439 " -> Hash (cost=117.00..117.00 rows=5000 width=12) (actual time= 7.722..7.723rows=5000.00 loops=2)"439 " -> Hash (cost=117.00..117.00 rows=5000 width=12) (actual time=10.740..10.741 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= 5.217..6.503 rows=5000.00 loops=2)"442 " -> Seq Scan on product p (cost=0.00..117.00 rows=5000 width=12) (actual time=0.680..9.123 rows=5000.00 loops=2)" 443 443 " Buffers: shared hit=134" 444 " -> Hash (cost=1.50..1.50 rows=50 width=15) (actual time= 0.402..0.403rows=50.00 loops=2)"444 " -> Hash (cost=1.50..1.50 rows=50 width=15) (actual time=7.694..7.695 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= 0.367..0.375rows=50.00 loops=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)" 448 448 " Buffers: shared hit=2" 449 " -> Hash (cost=1.50..1.50 rows=50 width=16) (actual time= 0.511..0.512rows=50.00 loops=2)"449 " -> Hash (cost=1.50..1.50 rows=50 width=16) (actual time=2.823..2.824 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= 0.479..0.486rows=50.00 loops=2)"452 " -> Seq Scan on supplier sup (cost=0.00..1.50 rows=50 width=16) (actual time=2.792..2.798 rows=50.00 loops=2)" 453 453 " Buffers: shared hit=2" 454 " -> Memoize (cost=0.15..0.17 rows=1 width=222) (actual time=0.00 1..0.001rows=1.00 loops=137806)"454 " -> Memoize (cost=0.15..0.17 rows=1 width=222) (actual time=0.000..0.000 rows=1.00 loops=137806)" 455 455 " Cache Key: s.warehouse_id" 456 456 " Cache Mode: logical" 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 29..0.029rows=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.035..0.035 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: 3.051ms"466 "Execution Time: 5241.032ms"467 }}} 468 465 "Planning Time: 20.237 ms" 466 "Execution Time: 4141.771 ms" 467 }}} 468
