Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.03.2021 19:29
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17313204 kB
MemAvailable 31644052 kB
Buffers 0 kB
Cached 14388900 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-08 19:27:22
DTS_END                         2021-03-08 19:27:22.4500
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(127:13) ==> X_MAKE_QSTORNO_2100_3300(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38554
TRN_ID                          243350
ATT_ID                          674
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9581.98 20452 1149837
customer order: creation 173.73 332 20847
customer order: refuse 14.98 305 1798
order to supplier: creation 46.34 1256 5561
order to supplier: removal 3.63 97866 435
invoice (draft): creation 46.88 3692 5626
invoice (draft): removal 55.32 758 6638
invoice accept: apply 42.60 17641 5112
invoice accept: cancel 49.90 705 5988
customer reserve: creation 3947.23 174 473668
customer reserve: removal 4903.43 57 588411
realization accept: apply 83.66 190 10039
realization accept: cancel 82.64 97 9917
payment from customer: creation 60.14 121 7217
payment from customer: removal 5.94 70 713
payment to supplier: creation 49.83 132 5980
payment to supplier: removal 3.39 46 407
service: total inventory turnovers 4.69 1166 563
service: total monetary turnovers 6.73 27 808
service: aggregate perf. data 0.88 19492 105
service: refresh index statistics 0.03 264910 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-03-2021 19:29:30 to 08-03-2021 19:29:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3513
TEST_TIME 2 3228
TEST_TIME 3 2961
TEST_TIME 4 3621
TEST_TIME 5 3366
TEST_TIME 6 4229
TEST_TIME 7 4787
TEST_TIME 8 5078
TEST_TIME 9 5940
TEST_TIME 10 6248
TEST_TIME 11 6967
TEST_TIME 12 7472
TEST_TIME 13 7683
TEST_TIME 14 7797
TEST_TIME 15 7821
TEST_TIME 16 7942
TEST_TIME 17 8055
TEST_TIME 18 8328
TEST_TIME 19 8526
TEST_TIME 20 8598
TEST_TIME 21 8756
TEST_TIME 22 8736
TEST_TIME 23 9026
TEST_TIME 24 9041
TEST_TIME 25 9633
TEST_TIME 26 9492
TEST_TIME 27 9969
TEST_TIME 28 11211
TEST_TIME 29 11228
TEST_TIME 30 11031
TEST_TIME 31 10883
TEST_TIME 32 10766
TEST_TIME 33 10763
TEST_TIME 34 10773
TEST_TIME 35 10663
TEST_TIME 36 10865
TEST_TIME 37 10787
TEST_TIME 38 10729
TEST_TIME 39 10508
TEST_TIME 40 10325
TEST_TIME 41 10340
TEST_TIME 42 10186
TEST_TIME 43 10242
TEST_TIME 44 10170
TEST_TIME 45 10164
TEST_TIME 46 10246
TEST_TIME 47 10235
TEST_TIME 48 10098
TEST_TIME 49 10166
TEST_TIME 50 10116
TEST_TIME 51 9961
TEST_TIME 52 9931
TEST_TIME 53 9975
TEST_TIME 54 9895
TEST_TIME 55 9804
TEST_TIME 56 9842
TEST_TIME 57 9816
TEST_TIME 58 9882
TEST_TIME 59 9842
TEST_TIME 60 9870
TEST_TIME 61 9918
TEST_TIME 62 9947
TEST_TIME 63 10014
TEST_TIME 64 10059
TEST_TIME 65 10060
TEST_TIME 66 10031
TEST_TIME 67 10021
TEST_TIME 68 10077
TEST_TIME 69 10051
TEST_TIME 70 10061
TEST_TIME 71 10001
TEST_TIME 72 9927
TEST_TIME 73 9940
TEST_TIME 74 9903
TEST_TIME 75 9870
TEST_TIME 76 9828
TEST_TIME 77 9812
TEST_TIME 78 9761
TEST_TIME 79 9822
TEST_TIME 80 9758
TEST_TIME 81 9746
TEST_TIME 82 9733
TEST_TIME 83 9767
TEST_TIME 84 9785
TEST_TIME 85 9762
TEST_TIME 86 9801
TEST_TIME 87 9806
TEST_TIME 88 9796
TEST_TIME 89 9814
TEST_TIME 90 9785
TEST_TIME 91 9857
TEST_TIME 92 9938
TEST_TIME 93 9931
TEST_TIME 94 9849
TEST_TIME 95 9802
TEST_TIME 96 9769
TEST_TIME 97 9720
TEST_TIME 98 9695
TEST_TIME 99 9704
TEST_TIME 100 9656
TEST_TIME 101 9616
TEST_TIME 102 9628
TEST_TIME 103 9609
TEST_TIME 104 9607
TEST_TIME 105 9604
TEST_TIME 106 9606
TEST_TIME 107 9588
TEST_TIME 108 9627
TEST_TIME 109 9620
TEST_TIME 110 9595
TEST_TIME 111 9582
TEST_TIME 112 9626
TEST_TIME 113 9724
TEST_TIME 114 9732
TEST_TIME 115 9739
TEST_TIME 116 9750
TEST_TIME 117 9710
TEST_TIME 118 9634
TEST_TIME 119 9623
TEST_TIME 120 9583

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-03-2021 19:29:34 to 08-03-2021 19:29:37.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1588993 1588993 0 0.00 0 21130 6 0 0
doc_list_biud 1588977 1588977 0 0.00 0 92840 27 0 0
sp_add_invoice_to_stock 5250 5112 138 2.62 27 169383 17641 0 138
sp_cancel_adding_invoice 5988 5988 0 0.00 4 61573 706 0 0
sp_cancel_client_order 1798 1798 0 0.00 4 12412 305 0 0
sp_cancel_customer_reserve 588411 588411 0 0.00 1 23157 57 0 0
sp_cancel_pay_from_customer 713 713 0 0.00 3 4163 70 0 0
sp_cancel_pay_to_supplier 407 407 0 0.00 3 2240 47 0 0
sp_cancel_supplier_invoice 6654 6638 16 0.24 2 92849 759 0 16
sp_cancel_supplier_order 435 435 0 0.00 6 981345 97867 0 0
sp_cancel_write_off 9917 9917 0 0.00 1 11806 97 0 0
sp_client_order 20847 20847 0 0.00 3 20390 333 0 0
sp_customer_reserve 473668 473668 0 0.00 0 36613 175 0 0
sp_fill_shopping_cart 32009 32009 0 0.00 1 13462 36 0 0
sp_fill_shopping_cart_clo_res 473664 473664 0 0.00 0 20856 12 0 0
sp_get_clo_for_invoice 5108 5108 0 0.00 0 31352 276 0 0
sp_kill_cost_storno 17025 17025 0 0.00 0 9971 51 0 0
sp_kill_qstorno_ret_qs2qd 1193812 1193812 0 0.00 0 92835 31 0 0
sp_kill_qty_storno 628334 628334 0 0.00 0 92839 67 0 0
sp_lock_selected_doc 21071 21071 0 0.00 0 9284 6 0 0
sp_make_cost_storno 28344 28344 0 0.00 0 12877 57 0 0
sp_multiply_rows_for_pdistr 28344 28344 0 0.00 0 12314 31 0 0
sp_multiply_rows_for_qdistr 20847 20847 0 0.00 0 8895 137 0 0
sp_pay_from_customer 7217 7217 0 0.00 4 12349 122 0 0
sp_pay_to_supplier 5980 5980 0 0.00 5 15177 133 0 0
sp_payment_common 13193 13193 0 0.00 1 11953 35 0 0
sp_qd_handle_on_cancel_clo 1798 1798 0 0.00 0 12404 277 0 0
sp_qd_handle_on_invoice_upd_sts 11096 11096 0 0.00 0 17982 309 0 0
sp_qd_handle_on_reserve_upd_sts 10039 10039 0 0.00 0 19022 62 0 0
sp_reserve_write_off 10039 10039 0 0.00 6 19036 190 0 0
sp_supplier_invoice 5626 5626 0 0.00 7 108721 3693 0 0
sp_supplier_order 5561 5561 0 0.00 5 36371 1256 0 0
srv_aggregate_perf_data 105 105 0 0.00 2513 235297 19492 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1369 174145 32015 0 0
srv_find_qd_qs_mism 1101511 1101511 0 0.00 0 13394 5 0 0
srv_make_invnt_saldo 563 563 0 0.00 53 39286 1167 0 0
srv_make_money_saldo 808 808 0 0.00 1 2422 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 159130 307568 264911 0 0
t$perf-abend:sp_add_invoice_to_stock 138 138 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5112 5112 0 0.00 0 13518 170 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 1 4254 110 0 0
t$perf-norm:sp_cancel_client_order 1798 1798 0 0.00 0 2275 13 0 0
t$perf-norm:sp_cancel_customer_reserve 710 710 0 0.00 0 739 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 713 713 0 0.00 0 850 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 407 407 0 0.00 0 4340 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 393 393 0 0.00 0 6864 36 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 26170 1692 0 0
t$perf-norm:sp_cancel_write_off 1037 1037 0 0.00 0 3113 9 0 0
t$perf-norm:sp_client_order 20847 20847 0 0.00 0 11661 17 0 0
t$perf-norm:sp_customer_reserve 979 979 0 0.00 0 1563 9 0 0
t$perf-norm:sp_pay_from_customer 7217 7217 0 0.00 0 7163 10 0 0
t$perf-norm:sp_pay_to_supplier 5980 5980 0 0.00 0 3482 7 0 0
t$perf-norm:sp_reserve_write_off 10039 10039 0 0.00 0 12187 13 0 0
t$perf-norm:sp_supplier_invoice 5626 5626 0 0.00 0 8415 25 0 0
t$perf-norm:sp_supplier_order 5561 5561 0 0.00 0 6110 18 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 485 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 315 5 0 0
t$perf-norm:srv_make_invnt_saldo 563 563 0 0.00 0 2728 25 0 0
t$perf-norm:srv_make_money_saldo 808 808 0 0.00 0 2328 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 856 216 0 0
v_add_invoice_to_stock 10490 10214 276 2.63 0 4133 18 0 276
v_all_customers 38586 38586 0 0.00 0 15 1 0 0
v_all_suppliers 30874 30874 0 0.00 0 227 1 0 0
v_all_wares 41680 41680 0 0.00 0 179 1 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 4673 19 0 0
v_cancel_client_order 3596 3596 0 0.00 0 1827 4 0 0
v_cancel_customer_prepayment 1426 1426 0 0.00 0 4101 7 0 0
v_cancel_customer_reserve 1420 1420 0 0.00 0 2826 6 0 0
v_cancel_payment_to_supplier 814 814 0 0.00 0 2220 7 0 0
v_cancel_supplier_invoice 818 786 32 3.91 0 2560 17 0 32
v_cancel_supplier_order 870 870 0 0.00 0 3510 14 0 0
v_cancel_write_off 2074 2074 0 0.00 0 5555 19 0 0
v_max_id_clo_ord 5558 5558 0 0.00 0 1040 1 0 0
v_max_id_clo_res 979 979 0 0.00 0 4047 12 0 0
v_max_id_ord_sup 5611 5611 0 0.00 0 6605 6 0 0
v_max_non_paid_invoice 1711 1711 0 0.00 0 561 3 0 0
v_max_non_paid_realizn 3626 3626 0 0.00 0 6375 8 0 0
v_min_id_clo_ord 5558 5558 0 0.00 0 2003 4 0 0
v_min_id_clo_res 979 979 0 0.00 0 6417 10 0 0
v_min_id_ord_sup 5611 5611 0 0.00 0 9108 6 0 0
v_min_non_paid_invoice 5979 5979 0 0.00 0 8463 23 0 0
v_min_non_paid_realizn 7214 7214 0 0.00 0 11947 22 0 0
v_our_firm 10270 10270 0 0.00 0 13 1 0 0
v_reserve_write_off 20078 20078 0 0.00 0 4034 6 0 0
x_lock_depdocs_on_canc_invoice 12233 12233 0 0.00 0 13168 112 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 10402 362 0 0
x_make_qstorno_1000_1200 5561 5561 0 0.00 2 36360 1180 0 0
x_make_qstorno_1200_2000 5626 5626 0 0.00 4 108699 3550 0 0
x_make_qstorno_2100_3300 473668 473668 0 0.00 0 36611 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-03-2021 19:29:38 to 08-03-2021 19:29:42.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:26 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:33 27842 8192000000 10297229440 10605199360 1095265632 11.793 85 62 124 0 1119454480 2944624 21244224
16:58:07 35414 8192000000 10355193248 10677637120 1398772288 14.584 100 84 167 0 1432026752 5477904 27776560
16:58:52 11993 8192000000 10392069472 10717802496 1452121680 15.057 100 88 175 0 1487494608 6494000 28878928
16:59:19 24963 8192000000 10417362704 10748334080 1471554944 15.227 100 84 168 0 1505715424 7397760 26762720
16:59:54 17185 8192000000 10453242144 10786357248 1508220528 15.548 100 90 180 0 1545365008 8537296 28607184
17:00:21 16788 8192000000 10456078000 10795167744 1516095344 15.616 100 90 180 0 1553985328 9469328 28420656
17:00:48 18413 8192000000 10474987728 10815066112 1525941536 15.702 100 83 166 0 1562257280 9928240 26387504
17:01:23 17325 8192000000 10485785216 10832936960 1547677648 15.890 100 85 170 0 1584876352 10242512 26956192
17:01:48 17374 8192000000 10515120880 10867519488 1568492528 16.069 100 79 157 1 1602887168 10109296 24285344
17:02:17 14289 8192000000 10544567840 10898685952 1603215504 16.367 100 84 168 0 1639857120 11305792 25335824
17:02:47 13432 8192000000 10562459568 10922614784 1622290528 16.529 100 81 162 2 1658449696 11625760 24533408
17:03:10 13687 8192000000 10599436624 10960908288 1649829552 16.763 100 75 150 0 1683573072 11762288 21981232
17:03:35 12981 8192000000 10616585776 10985521152 1677590336 16.997 100 79 158 0 1713306448 12639792 23076320
17:03:56 9510 8192000000 10630079104 10999066624 1686909440 17.075 100 81 162 1 1723743392 13096704 23737248
17:04:12 6360 8192000000 10645165520 11017248768 1706465216 17.239 100 78 154 3 1741454256 12677584 22311456
17:04:25 8166 8192000000 10661709616 11037061120 1723452848 17.381 100 84 168 0 1760826576 13062928 24310800
17:04:41 10909 8192000000 10680271952 11055591424 1738785152 17.509 100 81 162 1 1774110960 12062384 23263424
17:05:01 5409 8192000000 10688369488 11065470976 1750752960 17.608 100 81 160 1 1785304032 11824000 22727072
17:05:13 5465 8192000000 10701914112 11083894784 1767305296 17.745 100 76 150 2 1800616304 12565920 20745088
17:05:26 6334 8192000000 10719331616 11098353664 1781505936 17.862 100 80 157 0 1815587008 12224688 21856384
17:05:39 3518 8192000000 10729571248 11107201024 1789478752 17.927 100 86 173 0 1827194864 12736080 24980032
17:05:51 4056 8192000000 10732420976 11115913216 1796785728 17.988 100 79 159 0 1832148256 13181200 22181328
17:06:02 4053 8192000000 10745694208 11127353344 1805685424 18.061 100 88 174 1 1844482352 13783776 25013152
17:06:13 2579 8192000000 10748340496 11129864192 1807599104 18.076 100 84 167 2 1844597248 13355504 23642640
17:06:22 2256 8192000000 10753715136 11139788800 1813717232 18.126 100 82 165 0 1849487200 12778896 22991072
17:06:32 7579 8192000000 10750726752 11138850816 1817488992 18.157 100 82 164 0 1854090416 13843136 22758288
17:06:47 4339 8192000000 10767640592 11157590016 1819293280 18.172 100 82 163 3 1855155088 13275600 22586208
17:06:58 2397 8192000000 10782051984 11165233152 1835833984 18.307 100 87 174 1 1873928656 12657056 25437616
17:07:06 2792 8192000000 10776744000 11166294016 1839684880 18.338 100 84 168 1 1877027600 13327392 24015328
17:07:16 2514 8192000000 10788466032 11175591936 1847514176 18.402 100 97 193 1 1889946400 13883664 28548560
17:07:25 1653 8192000000 10792594448 11182071808 1853236592 18.448 100 86 172 1 1890585136 12814000 24534544
17:07:34 2056 8192000000 10800852672 11188002816 1858360800 18.490 100 87 175 1 1897012096 14117840 24533456
17:07:42 1890 8192000000 10802812000 11191570432 1859889536 18.502 100 90 181 0 1899845040 13748096 26207408
17:07:51 1988 8192000000 10814475488 11199655936 1865403952 18.547 100 92 184 0 1905585824 13800800 26381072
17:08:00 1445 8192000000 10819053152 11204575232 1868121600 18.569 100 94 188 0 1908203024 13678656 26402768
17:08:08 2537 8192000000 10816944800 11206090752 1874040896 18.617 100 91 182 2 1912759408 12974160 25744352
17:08:17 2258 8192000000 10826516096 11216629760 1877774960 18.647 100 92 187 1 1916055296 11875856 26404480
17:08:26 4521 8192000000 10793965040 11204247552 1873734560 18.614 100 52 104 0 1899886432 11599776 14552096
17:08:38 31290 8192000000 10806650896 11218038784 1878584176 18.654 100 51 102 1 1899608384 6324976 14699232
17:09:15 5296 8192000000 10780376816 11213955072 1877014832 18.641 100 34 68 0 1894859872 8136880 9708160
17:09:33 7060 8192000000 10786207072 11218722816 1878772512 18.655 100 21 42 0 1891786592 7064240 5949840
17:09:46 6654 8192000000 10791956496 11215630336 1879885168 18.664 100 25 51 1 1892496736 5889904 6721664
17:09:59 6028 8192000000 10792809984 11224793088 1883081120 18.690 100 31 62 1 1899508912 7241568 9186224
17:10:11 6495 8192000000 10797063840 11224616960 1884960272 18.705 100 26 52 3 1898831584 6544608 7326704
17:10:26 10817 8192000000 10794420912 11223121920 1883897872 18.697 100 19 38 0 1895756928 6521424 5337632
17:10:46 7893 8192000000 10798580768 11230334976 1890301376 18.748 100 23 46 2 1904387376 7365472 6720528
17:11:00 16162 8192000000 10797908832 11233038336 1891081440 18.754 100 15 29 2 1901466416 6146912 4238064
17:11:22 8623 8192000000 10815331792 11242754048 1895975440 18.794 100 16 32 2 1906954832 6048048 4931344
17:11:38 10415 8192000000 10800226128 11238551552 1897173504 18.804 100 17 34 1 1907846832 5701616 4971712
17:11:55 4373 8192000000 10812829456 11243905024 1901689616 18.840 100 21 42 1 1913431968 5860800 5881552
17:12:06 11149 8192000000 10801986224 11242405888 1900702592 18.832 100 12 24 1 1909803088 5865120 3235376
17:12:27 65748 8192000000 10812440416 11254906880 1906574384 18.879 100 28 57 2 1920436016 5714160 8147472
17:13:40 9506 8192000000 10833451872 11265982464 1910143872 18.908 100 25 50 1 1927148320 10400160 6604288
17:13:56 4219 8192000000 10836967984 11265683456 1912086304 18.923 100 35 70 3 1928263728 7143584 9033840
17:14:07 2370 8192000000 10854012096 11272400896 1917944128 18.970 100 55 109 2 1943030384 9447584 15638672
17:14:17 2564 8192000000 10841134896 11269939200 1916557712 18.959 100 40 80 1 1936292480 8268736 11466032
17:14:27 5393 8192000000 10829884736 11266600960 1915651200 18.952 100 29 57 4 1930008272 6409200 7947872
17:14:41 6668 8192000000 10828623184 11264167936 1916618096 18.960 100 22 43 1 1928596864 5220512 6758256
17:14:54 8528 8192000000 10832894752 11268182016 1916855232 18.962 100 28 56 1 1930881120 5994128 8031760
17:15:13 6172 8192000000 10840106256 11271389184 1917357280 18.966 100 23 47 0 1929504160 5669152 6477728
17:15:28 8335 8192000000 10831169776 11270885376 1917196384 18.964 100 22 44 0 1929424464 6096640 6131440
17:15:43 15331 8192000000 10811938656 11253039104 1899401440 18.821 99 17 34 2 1910069824 6020320 4648064
17:16:08 8034 8192000000 10811652160 11243532288 1884681552 18.703 99 17 34 0 1894547776 5181136 4685088
17:16:24 14906 8192000000 10801236192 11232825344 1827150080 18.236 96 15 30 0 1836939856 5455776 4334000
17:16:45 11554 8192000000 10779145264 11206873088 1812743056 18.118 96 11 22 0 1824650304 9073104 2834144
17:17:02 62712 8192000000 10759952160 11198013440 1820122192 18.179 97 38 76 3 1840389648 9469552 10797904
17:18:11 11317 8192000000 10770140496 11199467520 1841694112 18.355 99 17 34 0 1852832736 5706528 5432096
17:18:29 8980 8192000000 10758834384 11180183552 1828917584 18.250 98 30 60 0 1843556432 6240016 8398832
17:18:47 7389 8192000000 10759625696 11176001536 1797638192 17.995 97 27 54 0 1813249808 6277584 9334032
17:19:01 6743 8192000000 10744488096 11166785536 1804650160 18.052 98 28 56 0 1818873824 6347264 7876400
17:19:19 6072 8192000000 10727508592 11146510336 1745381056 17.563 95 30 61 1 1760396560 5822496 9193008
17:19:31 5819 8192000000 10702114320 11124670464 1789643136 17.929 99 31 61 3 1805132512 5988512 9500864
17:19:43 6655 8192000000 10717619120 11131428864 1765185584 17.727 97 19 38 1 1775620848 5401072 5034192
17:19:56 4100 8192000000 10732391360 11147878400 1814660032 18.134 99 40 80 2 1831882272 5499856 11722384
17:20:08 6908 8192000000 10751447648 11171586048 1816087408 18.146 99 25 50 2 1829740160 6052880 7599872
17:20:21 5907 8192000000 10742357952 11162791936 1796594944 17.986 98 28 55 4 1810010000 4954544 8460512
17:20:33 6134 8192000000 10706402288 11116474368 1741077280 17.528 95 25 50 0 1753953344 5996000 6880064
17:20:45 7736 8192000000 10733058576 11141595136 1755300304 17.645 97 27 54 0 1768627008 4900816 8425888
17:21:00 15687 8192000000 10712953600 11127746560 1729209728 17.429 96 23 46 1 1742042848 5633808 7199312
17:21:22 9684 8192000000 10717922208 11137048576 1779081824 17.842 99 14 28 0 1792262304 9235088 3945392
17:21:37 67198 8192000000 10724383616 11152052224 1785230560 17.893 98 30 60 0 1799037712 5328384 8478768
17:22:53 9563 8192000000 10744039632 11168071680 1828374912 18.246 100 30 60 1 1842345344 5718416 8252016
17:23:11 7083 8192000000 10767204992 11180830720 1821589408 18.191 99 27 54 0 1834372032 5287456 7495168
17:23:24 5066 8192000000 10750607472 11170598912 1803854400 18.046 98 30 60 0 1819557504 7354912 8348192
17:23:37 4607 8192000000 10762520096 11183038464 1844787728 18.380 100 38 74 3 1863846992 8066896 10992368
17:23:50 4365 8192000000 10768896432 11188404224 1844333120 18.376 100 33 64 0 1859794064 5714624 9746320
17:24:01 5017 8192000000 10764111520 11190611968 1849565200 18.419 100 39 78 1 1868974464 7260848 12148416
17:24:13 6119 8192000000 10767447792 11190177792 1851106208 18.431 100 29 58 2 1865583360 6146672 8330480
17:24:26 8824 8192000000 10770333792 11195609088 1853640096 18.452 100 22 45 1 1865393472 5902256 5851120
17:24:43 7928 8192000000 10768448432 11197628416 1852568608 18.443 100 23 46 2 1865437056 6481888 6386560
17:24:59 11698 8192000000 10787084176 11203162112 1855212704 18.464 100 20 40 0 1871840304 9595776 7031824
17:25:21 10577 8192000000 10775248976 11207872512 1868894032 18.575 100 22 44 2 1880510784 5109152 6507600
17:25:37 4968 8192000000 10786840576 11213848576 1867673536 18.565 100 29 59 0 1883052384 6716416 8662432
17:25:48 12391 8192000000 10776112160 11209908224 1864565456 18.540 100 13 26 2 1873237936 4977056 3695424
17:26:07 7769 8192000000 10787112784 11214401536 1868509856 18.572 100 17 33 1 1879162368 5818560 4833952
17:26:21 13390 8192000000 10776764288 11212984320 1869363136 18.579 100 14 28 0 1879105136 5498944 4243056
17:26:44 112646 8192000000 10837813856 11253411840 1884658864 18.703 100 42 82 1 1907106768 10025904 12422000
17:28:46 12332 8192000000 10841528640 11266134016 1917412576 18.966 100 46 92 1 1938115184 6804224 13898384
17:29:05 4492 8192000000 10869490208 11277701120 1928901328 19.058 100 48 96 1 1954520000 11955936 13662736
17:29:34 8313 8192000000 10866398944 11292131328 1935974496 19.115 100 52 102 0 1960827392 9537760 15315136
17:30:02 29420 8192000000 10877275360 11299622912 1940881824 19.154 100 51 101 1 1966057520 10373616 14802080
17:30:49 27299 8192000000 10880626368 11309539328 1947638416 19.208 100 41 82 0 1972426992 13125168 11663408
17:31:23 34639 8192000000 10884190848 11319332864 1954843056 19.265 100 40 77 1 1979497968 13362432 11292480
17:32:15 8423 8192000000 10900926720 11326128128 1961071264 19.315 100 45 89 2 1989112832 14974816 13066752
17:32:32 16643 8192000000 10907846400 11330854912 1963286384 19.332 100 56 112 3 1996823024 17167184 16369456
17:33:10 9509 8192000000 10908091184 11341447168 1972650016 19.406 100 51 102 1 2005376432 17201584 15524832
17:33:26 4049 8192000000 10929405968 11348570112 1978939168 19.456 100 64 127 3 2015529232 17362128 19227936
17:33:44 7854 8192000000 10918245168 11350769664 1978697808 19.454 100 57 110 0 2013123984 17610288 16815888
17:34:01 8861 8192000000 10920822080 11352223744 1980001680 19.465 100 48 96 0 2012148672 17552288 14594704
17:34:17 8354 8192000000 10932081024 11360006144 1988679600 19.533 100 64 128 1 2026977984 18157456 20140928
17:34:31 10552 8192000000 10918431104 11350896640 1978903616 19.456 100 58 112 2 2013720864 17748112 17069136
17:34:51 7323 8192000000 10927633600 11358453760 1979584352 19.461 100 60 119 1 2018706896 21666432 17456112
17:35:15 5905 8192000000 10935940208 11360714752 1983923280 19.496 100 62 124 1 2021231600 19232576 18075744
17:35:32 12405 8192000000 10931948192 11353714688 1980154848 19.466 100 69 136 1 2021428032 20964304 20308880
17:35:52 8691 8192000000 10935667504 11360026624 1984522080 19.500 100 58 116 1 2024124576 21473488 18129008
17:36:10 9244 8192000000 10944958336 11371503616 1989728992 19.542 100 71 140 2 2032548640 21316112 21503536
17:36:36 3242 8192000000 10950713536 11374440448 1996534976 19.595 100 73 143 2 2041237632 23291488 21411168
17:36:47 5163 8192000000 10927439360 11356962816 1964819888 19.344 99 65 130 0 2002564048 18148096 19596064
17:37:08 4285 8192000000 10945706240 11372130304 1991085088 19.552 100 61 118 4 2027972624 20279952 16607584
17:37:19 3672 8192000000 10941956192 11370074112 1995728784 19.589 100 67 133 4 2036892672 21271840 19892048
17:37:31 1908 8192000000 10947978736 11366760448 1976251120 19.435 99 87 169 4 2024254448 22079152 25924176
17:37:39 1673 8192000000 10948154064 11368857600 1985318432 19.507 100 70 139 2 2029624560 23287632 21018496
17:37:48 4267 8192000000 10951220016 11364978688 1981580208 19.477 100 78 155 2 2028787696 24245168 22962320
17:38:00 6532 8192000000 10934113984 11356295168 1955710656 19.272 99 71 142 0 2003211552 25958976 21541920
17:38:16 2007 8192000000 10932150576 11347652608 1962131728 19.323 100 80 158 0 2013908672 27873728 23903216
17:38:24 5109 8192000000 10924130704 11352735744 1962334992 19.325 100 61 120 0 2008715744 28173216 18207536
17:38:36 2171 8192000000 10934280000 11351212032 1970769856 19.392 100 80 159 2 2018504576 24892832 22841888
17:38:45 1743 8192000000 10918183312 11324715008 1940967424 19.154 99 91 182 0 1995250432 26323776 27959232
17:38:53 2902 8192000000 10925737680 11343998976 1962414240 19.325 100 79 157 1 2012843584 26804464 23624880
17:39:04 8817 8192000000 10934175232 11358273536 1972571728 19.406 100 76 148 1 2022981216 27774800 22634688
17:39:21 5523 8192000000 10945689936 11358494720 1973655632 19.414 100 77 154 0 2023181920 26361216 23165072
17:39:35 5575 8192000000 10939294112 11367227392 1979052736 19.457 100 68 132 1 2024530384 25977328 19500320
17:39:47 2946 8192000000 10942930960 11355848704 1965668448 19.351 99 83 166 1 2018894896 27979696 25246752
17:39:56 4945 8192000000 10946370272 11369541632 1980871776 19.472 100 76 152 2 2031979680 28464016 22643888
17:40:09 2061 8192000000 10939511136 11354628096 1956147232 19.275 99 84 167 0 2008593456 26965840 25480384
17:40:20 6513 8192000000 10925303520 11341111296 1954605392 19.263 99 79 156 0 2006247392 28788880 22853120
17:40:36 4067 8192000000 10948800704 11367780352 1977155440 19.442 100 84 166 2 2031893504 29971328 24766736
17:40:49 4856 8192000000 10922056528 11351027712 1938902032 19.138 98 68 134 0 1987076656 28077840 20096784
17:41:00 3460 8192000000 10923671872 11343609856 1958724416 19.296 100 78 155 0 2010982400 29031856 23226128
17:41:15 7246 8192000000 10930476928 11357904896 1964381456 19.341 100 69 136 0 2013749088 28676224 20691408
17:41:37 8131 8192000000 10903498016 11329421312 1943452176 19.174 99 53 104 0 1986920192 26716688 16751328
17:41:52 9102 8192000000 10928128144 11348570112 1930084016 19.068 98 57 114 1 1981644192 33121808 18438368
17:42:10 2936 8192000000 10936343600 11357437952 1964135120 19.339 100 78 151 2 2017312192 29243440 23933632
17:42:22 4180 8192000000 10927544544 11356364800 1964660400 19.343 100 61 122 0 2012997072 29111600 19225072
17:42:37 4548 8192000000 10951908640 11366035456 1976178240 19.434 100 83 167 2 2029886000 28502000 25205760
17:42:52 3466 8192000000 10957097712 11375710208 1982708208 19.486 100 79 157 0 2035623040 29174784 23740048
17:43:02 1926 8192000000 10967075392 11379884032 1980373632 19.468 100 96 191 1 2044988592 35486224 29128736
17:43:11 4223 8192000000 10938687872 11344691200 1953296496 19.253 99 95 189 4 2018515248 36807472 28411280
17:43:21 2834 8192000000 10919187952 11329490944 1922567312 19.007 98 87 174 4 1992505968 43087456 26851200
17:43:31 2511 8192000000 10936270512 11346702336 1952892576 19.250 100 82 164 1 2016568992 38305376 25371040
17:43:42 2747 8192000000 10924906512 11337486336 1918319360 18.973 98 82 164 0 1982989712 39658144 25012208
17:43:52 5451 8192000000 10935157312 11344883712 1943301088 19.173 100 84 168 0 2014665872 45530976 25833808
17:44:04 3642 8192000000 10937595344 11347496960 1937085872 19.123 99 85 170 2 2007492688 44362864 26043952
17:44:14 2848 8192000000 10955388752 11363532800 1959953728 19.306 100 95 190 1 2035281344 46423936 28903680
17:44:23 1817 8192000000 10950594208 11357057024 1957745360 19.288 100 95 190 3 2032234864 45138096 29351408
17:44:34 3570 8192000000 10953127744 11367702528 1960212272 19.308 100 86 168 2 2035098672 49204464 25681936
17:44:48 1904 8192000000 10942526656 11347644416 1942818816 19.169 99 90 179 3 2015676640 45294272 27563552
17:44:57 1778 8192000000 10937005712 11341131776 1938844496 19.138 99 85 170 1 2011942112 46448560 26649056
17:45:06 2165 8192000000 10960184624 11365351424 1962842528 19.329 100 83 165 0 2036439408 47922576 25674304
17:45:15 3365 8192000000 10965104672 11375583232 1969897216 19.385 100 86 171 1 2047126304 49981504 27247584
17:45:26 2058 8192000000 10975634960 11381297152 1974396080 19.420 100 90 174 1 2051294480 49777744 27120656
17:45:35 1364 8192000000 10984054128 11393437696 1982572704 19.485 100 88 174 1 2061419312 50993616 27852992
17:45:44 1928 8192000000 10964881664 11376177152 1965346048 19.349 99 81 162 5 2042258768 50795184 26117536
17:45:56 1444 8192000000 10970508768 11392081920 1978873984 19.456 100 69 136 1 2053126432 53058640 21193808
17:46:04 7732 8192000000 10948717264 11377590272 1965927344 19.353 100 50 99 0 2030531984 48377440 16227200
17:46:20 4461 8192000000 10976339024 11388272640 1977128224 19.442 100 86 171 0 2053359728 50308016 25923488
17:46:31 2690 8192000000 10965966512 11385282560 1973491408 19.413 100 72 144 0 2046389648 50800512 22097728
17:46:41 3753 8192000000 10966008976 11385589760 1975199664 19.427 100 70 141 0 2046919984 49785488 21934832
17:46:56 7524 8192000000 10961526336 11389878272 1983013312 19.489 100 57 114 1 2049701776 48917840 17770624
17:47:14 8350 8192000000 10951193856 11391221760 1981069632 19.473 100 54 106 1 2042078272 43905824 17102816
17:47:39 11821 8192000000 10950302032 11382243328 1944008320 19.179 98 45 90 1 2004322736 45197600 15116816
17:48:04 10180 8192000000 10948346208 11381649408 1955934048 19.274 99 53 106 0 2022142416 48851552 17356816
17:48:22 4648 8192000000 10948530240 11382091776 1957633200 19.287 99 61 121 1 2028665472 50644304 20387968
17:48:49 24846 8192000000 10940829088 11378286592 1945151632 19.188 99 36 72 4 2010164928 52694352 12318944
17:49:22 15039 8192000000 10956056352 11387072512 1963576688 19.334 100 37 73 0 2028072656 51749424 12746544
17:49:44 6313 8192000000 10951274960 11383611392 1953636608 19.255 99 52 104 0 2023510032 52508432 17364992
17:50:11 20320 8192000000 10934497392 11381694464 1950597152 19.231 100 33 66 1 2017517360 55348672 11571536
17:51:02 11539 8192000000 10943809616 11384090624 1964531920 19.342 100 38 75 2 2030618112 53140448 12945744
17:51:22 23627 8192000000 10924276304 11357503488 1920590720 18.992 98 33 65 0 1984546176 52540176 11415280
17:51:53 35351 8192000000 10908064672 11360260096 1921291232 18.997 99 32 64 1 1989893328 57285456 11316640
17:53:16 25793 8192000000 10910662480 11362840576 1946000944 19.195 100 25 50 0 2003520032 49097776 8421312
17:53:49 22209 8192000000 10924907056 11376828416 1942205088 19.164 100 27 54 0 2009645152 57427632 10012432
17:54:27 29584 8192000000 10919232672 11370721280 1924517312 19.023 99 19 38 0 1983286192 51479360 7289520
17:55:03 46086 8192000000 10909192992 11393728512 1916853136 18.962 99 16 32 2 1983950192 60991936 6105120
17:56:02 101395 8192000000 10866824112 11327778816 1865858288 18.551 96 8 16 0 1886364432 18645392 1860752
17:58:02 64626 8192000000 10874910272 11327524864 1905395744 18.870 97 34 68 1 1924574624 9802736 9376144
17:59:13 75047 8192000000 10894966928 11348414464 1935370544 19.110 99 10 20 1 1949923632 11897168 2655920
18:00:35 103216 8192000000 10920049760 11385663488 1968691408 19.375 100 6 12 0 1985770784 15327840 1751536
18:02:25 75968 8192000000 10942405920 11406450688 1984017392 19.496 100 12 24 1 2005204384 18082608 3104384
18:04:41 67563 8192000000 10928710000 11400835072 1997221616 19.601 100 14 28 0 2013845584 12050944 4573024
18:05:57 73714 8192000000 10934306704 11397898240 2000713856 19.628 100 31 62 2 2017481840 7067504 9700480
18:07:23 18869 8192000000 10959386848 11405103104 2009177712 19.695 100 56 112 0 2033545968 8182080 16186176
18:07:52 62760 8192000000 10955419600 11421384704 2010699360 19.707 100 39 78 0 2036751792 15098960 10953472
18:10:09 21792 8192000000 10924439696 11392778240 1976823664 19.440 99 29 58 1 1998746976 13685776 8237536
18:10:48 36115 8192000000 10914919264 11391221760 1981257792 19.475 100 15 30 1 2000096096 14357920 4480384
18:11:31 24620 8192000000 10948447296 11404423168 1996573264 19.596 100 39 77 1 2024475696 17363488 10538944
18:12:02 68021 8192000000 10932697824 11421093888 2004340464 19.657 100 37 73 3 2031057600 16004880 10712256
18:14:07 49518 8192000000 10917311648 11389820928 1960307072 19.308 98 18 36 1 1975241936 9892496 5042368
18:15:04 10254 8192000000 10917552480 11395145728 1995185280 19.585 100 13 27 0 2009235104 10325456 3724368
18:15:23 27618 8192000000 10930550720 11404902400 1998929008 19.614 100 6 12 1 2013368720 12565056 1874656
18:15:57 29294 8192000000 10923366016 11405074432 1982355920 19.483 99 14 28 0 1997313680 10845856 4111904
18:16:37 24982 8192000000 10899412976 11387158528 1948907360 19.218 98 9 18 1 1961617552 10128176 2582016
18:17:08 13514 8192000000 10897623792 11373518848 1961039840 19.314 99 13 27 1 1974369840 9212176 4117824
18:17:34 22243 8192000000 10899870240 11380379648 1981207632 19.474 100 22 44 2 1994055504 7148000 5699872
18:18:04 76554 8192000000 10919871728 11386875904 1969060288 19.378 99 31 62 0 1988841808 10416528 9364992
18:19:41 59030 8192000000 10896422432 11397017600 1961452464 19.318 99 14 28 0 1983077264 17767616 3857184
18:21:00 17828 8192000000 10901269776 11395895296 1978189760 19.450 100 4 8 1 1994832624 15795664 847200
18:21:24 13734 8192000000 10912382400 11388993536 1981699440 19.478 100 11 22 1 1997088800 11658720 3730640
18:21:44 19931 8192000000 10911930752 11391266816 1992035440 19.560 100 24 48 2 2008967072 9777888 7153744
18:22:28 61793 8192000000 10900905344 11398352896 1987431440 19.523 100 18 36 0 2000149376 7715648 5002288
18:23:38 58988 8192000000 10915730528 11411914752 1995396080 19.586 100 12 25 0 2009378016 10146992 3834944
18:24:43 79881 8192000000 10912143808 11394486272 1973342928 19.412 99 13 26 2 1986976352 10347408 3286016
18:26:09 42764 8192000000 10897146224 11366424576 1913180272 18.932 96 18 36 1 1930636688 11935920 5520496
18:27:00 31427 8192000000 10925220208 11378044928 1965028432 19.346 99 39 75 0 1988495680 13251008 10216240
18:27:38 40051 8192000000 10896112288 11369574400 1918902496 18.978 97 22 44 3 1942784832 17621136 6261200
18:28:36 61934 8192000000 10872343568 11348553728 1877646704 18.646 96 12 24 0 1898099520 17358960 3093856
18:29:45 46577 8192000000 10842871760 11297554432 1750626560 17.607 90 13 26 0 1762156928 8439968 3090400
18:30:38 74096 8192000000 10826594416 11295383552 1783910992 17.882 93 20 40 0 1801596208 11986880 5698336
18:31:59 74745 8192000000 10877390288 11341787136 1896742000 18.800 98 18 35 1 1909150928 7434336 4974592
18:33:20 53526 8192000000 10868772240 11327205376 1892391824 18.765 97 32 63 2 1911405792 10070096 8943872
18:34:22 41700 8192000000 10879587392 11342204928 1942207456 19.164 100 29 58 2 1961801584 11409808 8184320
18:35:10 55389 8192000000 10850671248 11309142016 1804045392 18.047 93 22 44 0 1820221344 10213488 5962464
18:36:15 40549 8192000000 10867892592 11329298432 1907313056 18.885 99 19 38 1 1924327088 11642016 5372016
18:37:07 165903 8192000000 10826770688 11296358400 1835016432 18.300 95 24 48 0 1856774992 15059536 6699024
18:40:01 69375 8192000000 10835549760 11300315136 1872730608 18.606 97 22 44 2 1887400544 8568928 6101008
18:41:17 33497 8192000000 10843418064 11304837120 1877762944 18.647 98 15 30 0 1891231088 9400080 4068064
18:43:56 61970 8192000000 10844126864 11322994688 1907377872 18.886 99 16 32 0 1921717744 9396432 4943440
18:45:07 77320 8192000000 10840868816 11323346944 1893051968 18.770 98 10 20 2 1904390208 8388704 2949536
18:46:43 66109 8192000000 10842521536 11327778816 1888191392 18.731 98 9 18 0 1900573424 9991024 2391008
18:47:57 71608 8192000000 10866193248 11344625664 1918593200 18.976 99 15 30 0 1934967808 11931744 4442864
18:49:17 78946 8192000000 10877627552 11361267712 1911816048 18.921 98 18 36 1 1930779536 13940000 5023488
18:50:50 50959 8192000000 10888444304 11360559104 1914908176 18.946 98 18 36 1 1931593136 11519472 5165488
18:52:32 20346 8192000000 10899969552 11367452672 1963681088 19.335 100 40 80 1 1987204624 11194912 12328624
18:52:59 25638 8192000000 10905034848 11367456768 1966366656 19.357 100 39 78 1 1989336720 12207424 10762640
18:53:37 76660 8192000000 10901327712 11370524672 1947469088 19.206 99 16 32 0 1966477424 14557088 4451248
18:55:43 41246 8192000000 10922441056 11388911616 1977311120 19.443 100 34 68 0 1997657136 11016672 9329344
18:56:31 56195 8192000000 10915231824 11390398464 1976435600 19.436 100 41 83 0 1999754608 12065344 11253664
18:57:34 15485 8192000000 10942422096 11395854336 1985479280 19.508 100 37 74 1 2004142720 8871456 9791984
18:57:56 22159 8192000000 10935704976 11397959680 1988539120 19.532 100 39 78 1 2010510160 11560848 10410192
18:58:26 29033 8192000000 10907519104 11376095232 1943030704 19.171 98 35 70 2 1971334960 18953792 9350464
18:59:04 174145 8192000000 10911105408 11402330112 1946041296 19.195 98 17 34 0 1973106096 22285520 4779280
19:02:07 114743 8192000000 10899438192 11381940224 1907008368 18.883 96 18 36 0 1924067216 12079136 4979712
19:04:08 47118 8192000000 10885876448 11368771584 1935083200 19.108 98 17 34 2 1954659728 14709760 4866768
19:05:06 74740 8192000000 10899139024 11395006464 1974023552 19.417 100 8 16 1 1991284416 14849536 2411328
19:06:48 57695 8192000000 10900387280 11389755392 1962840896 19.329 99 9 18 0 1972851536 7839088 2171552
19:07:52 39189 8192000000 10912141680 11398356992 1989090336 19.537 100 20 41 0 2009310576 14248592 5971648
19:08:37 74558 8192000000 10915779440 11400519680 1966618656 19.359 99 7 14 0 1979703744 11062016 2023072
19:10:00 64840 8192000000 10927063712 11401650176 1963737088 19.336 99 19 39 0 1980955264 12206544 5011632
19:11:17 35668 8192000000 10902820784 11388575744 1939683168 19.144 97 39 79 4 1958525984 7516624 11326192
19:12:00 91678 8192000000 10893028368 11371708416 1880631888 18.670 95 19 38 0 1898477824 12124576 5721360
19:13:38 52842 8192000000 10861809312 11331018752 1844639920 18.379 94 22 44 1 1858225872 7652816 5933136
19:14:56 89865 8192000000 10861334208 11331702784 1817017408 18.153 93 14 28 0 1833946624 12733536 4195680
19:16:32 80131 8192000000 10867248288 11324829696 1798136704 17.999 93 19 38 0 1817791376 14612896 5041776
19:17:58 38826 8192000000 10871923936 11330551808 1880917088 18.673 97 45 90 0 1907561152 13969600 12674464
19:19:01 38946 8192000000 10856341984 11326607360 1875734832 18.631 98 37 74 2 1904281728 17725184 10821712
19:20:00 114432 8192000000 10865500560 11349053440 1896487328 18.798 98 10 20 0 1915350272 15888096 2974848
19:22:05 146281 8192000000 10866326240 11360681984 1847714608 18.404 95 7 14 1 1870568960 20937680 1916672
19:24:42 92641 8192000000 10869532576 11333390336 1902234400 18.844 98 33 66 1 1920732608 9825520 8672688
19:26:26 56397 8192000000 10732764800 11210731520 1762220880 17.703 91 9 18 0 1772947248 8529040 2197328

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 08-03-2021 19:29:44 to 08-03-2021 19:30:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 138 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-03-2021 19:30:16 to 08-03-2021 19:30:18.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          243349
MON$OLDEST_ACTIVE               243571
MON$OLDEST_SNAPSHOT             243571
MON$NEXT_TRANSACTION            243571
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2055520
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:186: 
:187: mscs-test-161.budzdorov.ru    Mon Mar  8 19:27:36 2021
:188:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:189: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

08.03.21 19:30:19. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-03-08 19:30:22 No severe PSQL-related problems occured
08.03.21 19:30:23. End of report.