Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.11.2020 01:27
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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 17168940 kB
MemAvailable 31420116 kB
Buffers 0 kB
Cached 14492296 kB
SwapCached 2836 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.7
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 2020-11-12 01:27:04
DTS_END                         2020-11-12 01:27:04.5480
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36532
TRN_ID                          244422
ATT_ID                          722
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: 9545.78 20421 1145494
customer order: creation 175.26 344 21031
customer order: refuse 15.98 320 1917
order to supplier: creation 45.87 1303 5504
order to supplier: removal 3.49 101254 419
invoice (draft): creation 46.55 3208 5586
invoice (draft): removal 54.53 803 6544
invoice accept: apply 43.25 16513 5190
invoice accept: cancel 49.50 787 5940
customer reserve: creation 3926.75 165 471210
customer reserve: removal 4878.01 56 585361
realization accept: apply 83.34 180 10001
realization accept: cancel 93.91 108 11269
payment from customer: creation 58.95 142 7074
payment from customer: removal 5.57 95 668
payment to supplier: creation 49.29 154 5915
payment to supplier: removal 3.38 106 405
service: total inventory turnovers 4.53 1182 544
service: total monetary turnovers 6.80 40 816
service: aggregate perf. data 0.80 22570 96
service: refresh index statistics 0.03 259099 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-11-2020 01:28:01 to 12-11-2020 01:28:03.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5450
TEST_TIME 2 3628
TEST_TIME 3 4013
TEST_TIME 4 3966
TEST_TIME 5 4170
TEST_TIME 6 3912
TEST_TIME 7 4342
TEST_TIME 8 4402
TEST_TIME 9 4951
TEST_TIME 10 5749
TEST_TIME 11 6180
TEST_TIME 12 6232
TEST_TIME 13 6451
TEST_TIME 14 6720
TEST_TIME 15 6694
TEST_TIME 16 7103
TEST_TIME 17 7162
TEST_TIME 18 7796
TEST_TIME 19 8137
TEST_TIME 20 8716
TEST_TIME 21 9118
TEST_TIME 22 9402
TEST_TIME 23 9543
TEST_TIME 24 9947
TEST_TIME 25 10007
TEST_TIME 26 9982
TEST_TIME 27 10185
TEST_TIME 28 10258
TEST_TIME 29 10647
TEST_TIME 30 10893
TEST_TIME 31 10637
TEST_TIME 32 10657
TEST_TIME 33 10553
TEST_TIME 34 10553
TEST_TIME 35 10800
TEST_TIME 36 10768
TEST_TIME 37 10617
TEST_TIME 38 10627
TEST_TIME 39 10473
TEST_TIME 40 10303
TEST_TIME 41 10350
TEST_TIME 42 10255
TEST_TIME 43 10267
TEST_TIME 44 10084
TEST_TIME 45 10000
TEST_TIME 46 10067
TEST_TIME 47 10009
TEST_TIME 48 10103
TEST_TIME 49 10114
TEST_TIME 50 9989
TEST_TIME 51 9983
TEST_TIME 52 9893
TEST_TIME 53 9876
TEST_TIME 54 9752
TEST_TIME 55 9725
TEST_TIME 56 9654
TEST_TIME 57 9622
TEST_TIME 58 9651
TEST_TIME 59 9562
TEST_TIME 60 9502
TEST_TIME 61 9482
TEST_TIME 62 9605
TEST_TIME 63 9682
TEST_TIME 64 9679
TEST_TIME 65 9734
TEST_TIME 66 9691
TEST_TIME 67 9771
TEST_TIME 68 9810
TEST_TIME 69 9865
TEST_TIME 70 9921
TEST_TIME 71 9928
TEST_TIME 72 9906
TEST_TIME 73 9911
TEST_TIME 74 9871
TEST_TIME 75 9773
TEST_TIME 76 9804
TEST_TIME 77 9755
TEST_TIME 78 9749
TEST_TIME 79 9739
TEST_TIME 80 9692
TEST_TIME 81 9675
TEST_TIME 82 9620
TEST_TIME 83 9525
TEST_TIME 84 9550
TEST_TIME 85 9567
TEST_TIME 86 9564
TEST_TIME 87 9604
TEST_TIME 88 9579
TEST_TIME 89 9587
TEST_TIME 90 9620
TEST_TIME 91 9620
TEST_TIME 92 9653
TEST_TIME 93 9732
TEST_TIME 94 9704
TEST_TIME 95 9824
TEST_TIME 96 9821
TEST_TIME 97 9824
TEST_TIME 98 9796
TEST_TIME 99 9820
TEST_TIME 100 9871
TEST_TIME 101 9781
TEST_TIME 102 9732
TEST_TIME 103 9684
TEST_TIME 104 9697
TEST_TIME 105 9673
TEST_TIME 106 9659
TEST_TIME 107 9630
TEST_TIME 108 9605
TEST_TIME 109 9566
TEST_TIME 110 9570
TEST_TIME 111 9525
TEST_TIME 112 9556
TEST_TIME 113 9532
TEST_TIME 114 9535
TEST_TIME 115 9546
TEST_TIME 116 9578
TEST_TIME 117 9557
TEST_TIME 118 9547
TEST_TIME 119 9617
TEST_TIME 120 9547

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-11-2020 01:28:04 to 12-11-2020 01:28:08.

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 1583469 1583469 0 0.00 0 25401 6 0 0
doc_list_biud 1583467 1583467 0 0.00 0 28628 27 0 0
sp_add_invoice_to_stock 5301 5190 111 2.09 33 157397 16513 0 111
sp_cancel_adding_invoice 5940 5940 0 0.00 3 62515 788 0 0
sp_cancel_client_order 1917 1917 0 0.00 4 22229 320 0 0
sp_cancel_customer_reserve 585361 585361 0 0.00 1 27327 56 0 0
sp_cancel_pay_from_customer 668 668 0 0.00 3 12884 96 0 0
sp_cancel_pay_to_supplier 405 405 0 0.00 3 5881 106 0 0
sp_cancel_supplier_invoice 6552 6544 8 0.12 1 22051 803 0 8
sp_cancel_supplier_order 419 419 0 0.00 9 907404 101254 0 0
sp_cancel_write_off 11269 11269 0 0.00 1 13014 108 0 0
sp_client_order 21031 21031 0 0.00 4 23513 345 0 0
sp_customer_reserve 471210 471210 0 0.00 0 47372 165 0 0
sp_fill_shopping_cart 32110 32110 0 0.00 1 16413 36 0 0
sp_fill_shopping_cart_clo_res 471206 471206 0 0.00 0 16275 16 0 0
sp_get_clo_for_invoice 5186 5186 0 0.00 0 38064 297 0 0
sp_kill_cost_storno 18282 18282 0 0.00 0 9368 58 0 0
sp_kill_qstorno_ret_qs2qd 1188954 1188954 0 0.00 0 26246 31 0 0
sp_kill_qty_storno 626637 626637 0 0.00 0 28627 67 0 0
sp_lock_selected_doc 21107 21107 0 0.00 0 9510 7 0 0
sp_make_cost_storno 28176 28176 0 0.00 0 14470 54 0 0
sp_multiply_rows_for_pdistr 28175 28175 0 0.00 0 25372 36 0 0
sp_multiply_rows_for_qdistr 21031 21031 0 0.00 0 14251 167 0 0
sp_pay_from_customer 7074 7074 0 0.00 4 25406 142 0 0
sp_pay_to_supplier 5915 5915 0 0.00 5 16227 154 0 0
sp_payment_common 12988 12988 0 0.00 1 15111 48 0 0
sp_qd_handle_on_cancel_clo 1917 1917 0 0.00 0 12458 280 0 0
sp_qd_handle_on_invoice_upd_sts 11126 11126 0 0.00 0 28625 351 0 0
sp_qd_handle_on_reserve_upd_sts 10001 10001 0 0.00 0 22805 60 0 0
sp_reserve_write_off 10001 10001 0 0.00 6 24310 180 0 0
sp_supplier_invoice 5586 5586 0 0.00 6 93443 3209 0 0
sp_supplier_order 5504 5504 0 0.00 4 34603 1303 0 0
srv_aggregate_perf_data 96 96 0 0.00 3262 468429 22570 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1117 119004 31570 0 0
srv_find_qd_qs_mism 1098027 1098027 0 0.00 0 24827 5 0 0
srv_make_invnt_saldo 544 544 0 0.00 34 76767 1182 0 0
srv_make_money_saldo 816 816 0 0.00 1 10766 41 0 0
srv_recalc_idx_stat 4 4 0 0.00 142038 439437 259100 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5190 5190 0 0.00 0 37846 200 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 1981 72 0 0
t$perf-norm:sp_cancel_client_order 1917 1917 0 0.00 0 4650 13 0 0
t$perf-norm:sp_cancel_customer_reserve 647 647 0 0.00 0 4426 27 0 0
t$perf-norm:sp_cancel_pay_from_customer 668 668 0 0.00 0 2796 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 405 405 0 0.00 0 2052 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 416 416 0 0.00 0 722 12 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 23045 1646 0 0
t$perf-norm:sp_cancel_write_off 1035 1035 0 0.00 0 2662 7 0 0
t$perf-norm:sp_client_order 21031 21031 0 0.00 0 33123 22 0 0
t$perf-norm:sp_customer_reserve 991 991 0 0.00 0 6393 24 0 0
t$perf-norm:sp_pay_from_customer 7074 7074 0 0.00 0 10157 12 0 0
t$perf-norm:sp_pay_to_supplier 5915 5915 0 0.00 0 3879 10 0 0
t$perf-norm:sp_reserve_write_off 10001 10001 0 0.00 0 12330 11 0 0
t$perf-norm:sp_supplier_invoice 5586 5586 0 0.00 0 6653 18 0 0
t$perf-norm:sp_supplier_order 5504 5504 0 0.00 0 7710 17 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 338 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 775 11 0 0
t$perf-norm:srv_make_invnt_saldo 544 544 0 0.00 0 9860 41 0 0
t$perf-norm:srv_make_money_saldo 816 816 0 0.00 0 3952 28 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10594 10372 222 2.09 0 11192 17 0 222
v_all_customers 38320 38320 0 0.00 0 39 1 0 0
v_all_suppliers 30642 30642 0 0.00 0 23 1 0 0
v_all_wares 42060 42060 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 529 6 0 0
v_cancel_client_order 3834 3834 0 0.00 0 20937 12 0 0
v_cancel_customer_prepayment 1336 1336 0 0.00 0 522 3 0 0
v_cancel_customer_reserve 1294 1294 0 0.00 0 654 4 0 0
v_cancel_payment_to_supplier 810 810 0 0.00 0 1544 5 0 0
v_cancel_supplier_invoice 848 832 16 1.88 0 21203 45 0 16
v_cancel_supplier_order 838 838 0 0.00 0 2338 6 0 0
v_cancel_write_off 2070 2070 0 0.00 0 2766 13 0 0
v_max_id_clo_ord 5504 5504 0 0.00 0 16403 4 0 0
v_max_id_clo_res 991 991 0 0.00 0 2609 17 0 0
v_max_id_ord_sup 5576 5576 0 0.00 0 5707 4 0 0
v_max_non_paid_invoice 1674 1674 0 0.00 0 3894 5 0 0
v_max_non_paid_realizn 3647 3647 0 0.00 0 5355 9 0 0
v_min_id_clo_ord 5504 5504 0 0.00 0 2998 7 0 0
v_min_id_clo_res 991 991 0 0.00 0 8721 17 0 0
v_min_id_ord_sup 5576 5576 0 0.00 0 6408 9 0 0
v_min_non_paid_invoice 5915 5915 0 0.00 0 12059 41 0 0
v_min_non_paid_realizn 7073 7073 0 0.00 0 13377 33 0 0
v_our_firm 10592 10592 0 0.00 0 12 1 0 0
v_reserve_write_off 20002 20002 0 0.00 0 22984 7 0 0
x_lock_depdocs_on_canc_invoice 12068 12068 0 0.00 0 17750 109 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 14195 410 0 0
x_make_qstorno_1000_1200 5504 5504 0 0.00 2 34588 1222 0 0
x_make_qstorno_1200_2000 5586 5586 0 0.00 3 93432 3082 0 0
x_make_qstorno_2100_3300 471210 471210 0 0.00 0 46342 147 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-11-2020 01:28:09 to 12-11-2020 01:28:13.

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
22:57:08 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:14 20180 8192000000 10273464032 10582675456 973015040 10.616 75 56 110 1 993591728 2683968 17892720
22:57:44 40841 8192000000 10350064960 10665422848 1394364192 14.545 100 90 180 0 1429645856 5680528 29601136
22:58:34 16325 8192000000 10359139280 10680717312 1415144464 14.730 100 89 178 0 1452324704 7243216 29937024
22:58:58 19440 8192000000 10383558672 10707423232 1437357712 14.926 100 86 172 1 1472978256 7525040 28095504
22:59:29 17966 8192000000 10407517936 10736443392 1453478064 15.069 100 88 177 0 1490300544 8152224 28670256
23:00:00 29289 8192000000 10439901968 10773716992 1490324672 15.392 100 88 176 0 1527957584 9037840 28595072
23:00:44 16720 8192000000 10452626816 10793791488 1516673376 15.621 100 84 168 1 1553245008 9945632 26626000
23:01:11 17065 8192000000 10504645520 10849955840 1555154912 15.954 100 77 154 1 1588985616 10142944 23687760
23:01:37 16194 8192000000 10529255440 10878324736 1577788752 16.149 100 77 154 1 1611927184 10599952 23538480
23:02:01 16513 8192000000 10550017136 10903097344 1598007152 16.322 100 79 158 2 1633103568 11615664 23480752
23:02:27 14918 8192000000 10564258432 10925887488 1626795856 16.568 100 80 160 1 1663290912 12049328 24445728
23:02:49 14621 8192000000 10594927456 10954080256 1641348832 16.691 100 80 158 1 1677153904 12280688 23524384
23:03:13 11651 8192000000 10607133408 10971340800 1658907120 16.840 100 79 158 0 1694849776 12459936 23482720
23:03:32 9886 8192000000 10621852176 10988003328 1680584560 17.022 100 76 152 1 1715796512 13118176 22093776
23:03:49 11498 8192000000 10641594112 11006574592 1696709424 17.158 100 79 158 1 1733637520 13851248 23076848
23:04:08 7084 8192000000 10637056176 11013976064 1708108480 17.253 100 74 148 1 1743075312 13520624 21446208
23:04:24 5984 8192000000 10656377312 11029905408 1722505904 17.373 100 81 162 2 1758925472 13083424 23336144
23:04:40 5636 8192000000 10661036240 11040456704 1726233648 17.404 100 72 144 3 1759850032 12912032 20704352
23:04:52 5962 8192000000 10675765280 11053846528 1740475792 17.523 100 78 156 0 1775897616 12957984 22463840
23:05:05 4136 8192000000 10683213728 11064385536 1754001088 17.635 100 77 153 0 1787446416 11811232 21634096
23:05:15 5765 8192000000 10702636400 11079688192 1762131376 17.702 100 84 168 0 1798482784 12928016 23423392
23:05:28 5526 8192000000 10703178176 11085586432 1771204384 17.777 100 91 181 0 1810093488 13397088 25492016
23:05:40 3490 8192000000 10709644464 11089547264 1777971072 17.833 100 80 159 1 1811690832 12027088 21692672
23:05:51 4819 8192000000 10706093024 11091156992 1778019472 17.833 100 77 155 0 1812130592 12975984 21135136
23:06:03 3636 8192000000 10733206528 11117699072 1790697712 17.938 100 79 158 3 1826148864 13605280 21845872
23:06:14 3973 8192000000 10753630016 11133841408 1804802544 18.053 100 81 158 1 1841768048 14222640 22742864
23:06:24 2646 8192000000 10753953248 11140661248 1812580720 18.117 100 82 164 3 1849201728 13164400 23456608
23:06:34 1445 8192000000 10767114128 11151511552 1823626128 18.207 100 91 182 2 1862660544 13217120 25817296
23:06:44 2367 8192000000 10778720272 11163656192 1836101584 18.309 100 89 179 0 1875244640 12920800 26222256
23:06:54 1792 8192000000 10781199712 11165229056 1839956944 18.340 100 87 174 0 1876474656 12418688 24099024
23:07:02 1845 8192000000 10794034464 11178057728 1847096176 18.399 100 92 185 3 1885813856 12319968 26397712
23:07:11 1892 8192000000 10795201840 11181244416 1850069296 18.423 100 89 179 0 1888786048 13575056 25141696
23:07:19 1944 8192000000 10796099312 11182338048 1852591632 18.443 100 95 191 1 1893984880 14261360 27131888
23:07:27 2060 8192000000 10792743312 11182809088 1853930400 18.454 100 85 170 1 1890243328 12419488 23893440
23:07:36 1861 8192000000 10796797808 11185676288 1856197328 18.472 100 78 155 4 1890348352 12033424 22117600
23:07:44 1349 8192000000 10798779344 11190124544 1864401824 18.539 100 87 175 0 1901961344 12747328 24812192
23:07:52 1558 8192000000 10808167392 11198029824 1864837008 18.542 100 86 170 0 1901736128 12531984 24367136
23:08:00 1975 8192000000 10810588720 11199021056 1866838112 18.559 100 84 166 1 1904123904 13782640 23503152
23:08:09 1585 8192000000 10816624192 11205394432 1869721136 18.582 100 91 182 1 1909477744 13729136 26027472
23:08:19 3274 8192000000 10815509616 11203727360 1873657712 18.614 100 84 168 2 1910692144 14270560 22763872
23:08:28 1723 8192000000 10815679872 11211571200 1873400560 18.612 100 85 170 1 1911670608 14497968 23772080
23:08:36 2973 8192000000 10816000080 11208761344 1875815088 18.631 100 76 155 1 1913310720 15706640 21788992
23:08:46 22524 8192000000 10771973232 11201302528 1865531920 18.548 100 25 50 1 1879559040 7135488 6891632
23:09:15 5926 8192000000 10779774832 11202203648 1873494880 18.613 100 29 58 1 1888105328 6906096 7704352
23:09:32 1875 8192000000 10802407536 11212099584 1877095648 18.642 100 51 104 0 1899493632 7443120 14954864
23:09:39 8303 8192000000 10782360512 11211046912 1875748960 18.631 100 28 56 1 1895880352 12689648 7441744
23:09:54 6443 8192000000 10787753312 11213643776 1875384384 18.628 100 19 38 0 1887250320 6640048 5225888
23:10:07 8705 8192000000 10779805296 11214057472 1879650528 18.662 100 19 38 0 1890955520 5755600 5549392
23:10:24 6277 8192000000 10793065184 11222388736 1883569360 18.694 100 20 38 1 1894684432 5942256 5172816
23:10:39 7474 8192000000 10783969280 11222245376 1885039712 18.706 100 16 32 2 1895554176 6018176 4496288
23:10:56 9066 8192000000 10792844688 11229999104 1890051600 18.746 100 15 31 0 1900153808 6088880 4013328
23:11:11 5343 8192000000 10803053584 11231375360 1892853936 18.769 100 22 45 1 1904708528 5711840 6142752
23:11:25 10724 8192000000 10798900576 11232182272 1893374288 18.773 100 13 26 1 1903273520 6201104 3698128
23:11:48 5934 8192000000 10803510720 11234267136 1899198208 18.820 100 37 75 1 1916283920 6645424 10440288
23:12:04 16588 8192000000 10799390288 11234869248 1895551728 18.790 100 21 42 3 1907308912 6124112 5633072
23:12:31 21398 8192000000 10826123200 11246231552 1906744752 18.881 100 31 59 1 1920975760 4822640 9408368
23:13:00 40635 8192000000 10832711952 11259412480 1908573200 18.895 100 39 77 4 1926019504 5623632 11822672
23:14:13 4599 8192000000 10839062144 11268722688 1913671472 18.936 100 46 92 1 1936133584 9794432 12667680
23:14:28 5671 8192000000 10837138000 11266654208 1914816704 18.945 100 34 68 2 1930941840 6094704 10030432
23:14:41 9247 8192000000 10832566032 11267731456 1914613584 18.944 100 31 62 0 1931896720 7636496 9646640
23:14:59 5409 8192000000 10827207440 11262914560 1908703264 18.896 100 23 46 1 1921133488 5769488 6660736
23:15:10 9601 8192000000 10823536048 11258064896 1903904560 18.858 100 23 45 1 1916017984 6107840 6005584
23:15:26 7056 8192000000 10819641264 11260448768 1908654768 18.896 100 18 37 1 1920235264 6314368 5266128
23:15:43 6075 8192000000 10804944160 11237543936 1886701920 18.719 99 24 48 4 1900200352 6589344 6909088
23:15:57 8166 8192000000 10832573600 11261136896 1908502496 18.895 100 29 58 1 1922280272 5999136 7778640
23:16:12 3418 8192000000 10831885248 11263913984 1910222336 18.908 100 27 54 1 1928350240 10788672 7339232
23:16:31 7693 8192000000 10818033440 11249807360 1888941168 18.737 99 21 42 0 1901167152 6197824 6028160
23:16:45 9642 8192000000 10793073008 11224215552 1804025520 18.047 95 24 48 5 1815618736 5472928 6120288
23:17:02 7059 8192000000 10809940336 11236208640 1886113616 18.714 100 31 63 2 1905266240 9862832 9289792
23:17:18 6106 8192000000 10779309648 11204280320 1832722064 18.282 97 28 55 2 1847420144 6883952 7814128
23:17:30 73781 8192000000 10726789184 11153289216 1636043968 16.646 87 25 48 0 1647982384 4962928 6975488
23:18:51 9981 8192000000 10705223872 11131473920 1725580064 17.399 95 18 36 3 1736701072 5783376 5337632
23:19:09 7726 8192000000 10730631616 11151790080 1764064192 17.718 96 26 52 1 1777976336 5497312 8414832
23:19:26 7364 8192000000 10700736544 11115913216 1724358320 17.389 94 27 54 0 1737581536 5310496 7912720
23:19:44 5250 8192000000 10718739584 11130441728 1738787584 17.509 96 24 48 1 1751689712 6049104 6853024
23:19:59 8271 8192000000 10724084512 11136872448 1721650528 17.366 95 28 55 2 1734752704 5485072 7617104
23:20:15 5706 8192000000 10691299536 11097538560 1700841984 17.192 95 23 44 1 1713251680 4964112 7445584
23:20:27 4249 8192000000 10698991968 11111325696 1750679328 17.607 98 25 50 1 1763411952 5533072 7199552
23:20:41 7761 8192000000 10695854000 11119071232 1772328928 17.786 99 22 43 0 1784278016 5725328 6223760
23:20:57 5990 8192000000 10722819072 11140984832 1800858640 18.021 100 27 54 2 1814911760 5612592 8440528
23:21:12 8075 8192000000 10727186736 11149340672 1796279440 17.983 99 18 36 0 1807362944 5909104 5174400
23:21:26 7751 8192000000 10688351504 11103997952 1737739328 17.500 96 18 36 1 1748939504 5525712 5674464
23:21:40 8297 8192000000 10727480336 11146383360 1807253616 18.073 100 25 50 3 1819242544 5371728 6617200
23:21:55 9580 8192000000 10713575888 11131834368 1785223424 17.892 99 17 33 2 1795019776 4962080 4834272
23:22:15 8178 8192000000 10733980032 11152748544 1813422912 18.124 100 24 47 1 1824487392 5285984 5778496
23:22:31 80444 8192000000 10743848768 11176579072 1840275696 18.343 100 38 76 0 1857082880 4903360 11903824
23:23:58 8934 8192000000 10771396208 11181768704 1842458640 18.361 100 25 49 0 1854620976 5586128 6576208
23:24:13 10526 8192000000 10769269088 11189432320 1846123776 18.391 100 20 40 0 1856853584 5097328 5632480
23:24:34 8411 8192000000 10762415728 11192561664 1853369328 18.449 100 28 55 1 1866810384 5833296 7607760
23:24:50 7638 8192000000 10765740224 11195408384 1853412832 18.450 100 19 38 3 1865183664 5786752 5984080
23:25:08 8810 8192000000 10768972432 11204395008 1856741136 18.477 100 14 28 0 1865833840 5179888 3912816
23:25:25 7350 8192000000 10771788800 11204636672 1860920272 18.511 100 21 42 2 1873171808 6375712 5875824
23:25:41 12256 8192000000 10777741776 11208749056 1861080240 18.512 100 14 28 0 1870182320 5474720 3627360
23:26:03 9605 8192000000 10778798224 11211968512 1864924256 18.543 100 18 36 2 1875908688 6023520 4960912
23:26:20 8163 8192000000 10779573696 11210842112 1868067584 18.569 100 18 35 2 1879102688 6050016 4985088
23:26:35 10601 8192000000 10784682256 11216609280 1868409744 18.571 100 19 38 2 1880088816 5321200 6357872
23:26:52 11469 8192000000 10786575776 11219058688 1871420368 18.596 100 10 20 1 1879480368 5286208 2773792
23:27:10 43930 8192000000 10832051456 11249008640 1899622528 18.823 100 31 62 3 1914459280 5303776 9532976
23:28:04 19744 8192000000 10836978944 11264016384 1912354992 18.926 100 46 90 3 1934675808 9392416 12928400
23:28:32 9870 8192000000 10850449040 11272036352 1923330464 19.014 100 43 86 2 1944933200 9830768 11771968
23:28:52 39755 8192000000 10866032416 11294683136 1935985728 19.115 100 53 107 1 1961480144 10707440 14786976
23:30:10 62607 8192000000 10871546768 11300880384 1929784624 19.065 99 47 92 3 1958333072 14340000 14208448
23:31:21 40983 8192000000 10877419536 11312205824 1927393216 19.046 99 35 70 1 1953222656 15858432 9971008
23:32:11 12165 8192000000 10878601472 11317002240 1946270848 19.197 100 35 70 1 1974179840 18094592 9814400
23:32:32 26938 8192000000 10887334480 11331227648 1952427488 19.246 100 26 53 1 1977830832 17514176 7889168
23:33:09 20434 8192000000 10898535632 11341234176 1958099584 19.291 100 25 50 2 1989070544 24064208 6906752
23:33:47 11717 8192000000 10913913488 11348275200 1973078864 19.410 100 40 80 0 2005249184 19832976 12337344
23:34:07 9237 8192000000 10897500192 11335405568 1962972480 19.330 100 42 84 0 1996234400 20160176 13101744
23:34:24 16785 8192000000 10902909856 11339055104 1962540688 19.326 100 42 84 0 1995156592 20007808 12608096
23:34:50 12869 8192000000 10915087776 11349962752 1970777584 19.392 100 43 86 0 2009142144 24167760 14196800
23:35:12 21548 8192000000 10933423632 11365490688 1977405696 19.444 100 51 102 3 2019888496 26699216 15783584
23:35:44 16432 8192000000 10925847680 11356102656 1958857296 19.297 99 49 98 0 2003139360 29365920 14916144
23:36:07 13371 8192000000 10939502464 11370622976 1977955712 19.449 100 46 92 0 2026299408 33864848 14478848
23:36:28 10182 8192000000 10953983936 11381297152 1985296608 19.507 100 48 96 2 2032780576 32332032 15151936
23:36:46 4642 8192000000 10957399360 11387129856 1992443280 19.563 100 57 114 0 2042208352 31886048 17879024
23:37:03 12605 8192000000 10944005264 11379363840 1986089456 19.513 100 59 118 0 2036316800 31717648 18509696
23:37:27 10932 8192000000 10955013360 11386830848 1993156016 19.569 100 55 108 0 2040872928 31214656 16502256
23:37:47 3009 8192000000 10956563600 11388456960 2002423024 19.642 100 67 133 2 2048572304 26496256 19653024
23:37:58 2967 8192000000 10942104992 11370295296 1986172976 19.514 99 73 138 1 2034057232 26991680 20892576
23:38:09 2922 8192000000 10968372768 11391344640 2005205952 19.664 100 65 129 1 2045535664 21434736 18894976
23:38:21 2034 8192000000 10955309264 11384467456 2001960256 19.638 100 72 146 3 2045486528 22180976 21345296
23:38:32 10456 8192000000 10944658256 11373883392 1993000240 19.567 100 66 131 0 2035413440 23063840 19349360
23:38:52 2968 8192000000 10967460688 11382026240 2001051360 19.631 100 80 159 0 2048368768 23491808 23825600
23:39:01 3131 8192000000 10978562864 11398160384 2013322048 19.728 100 76 151 0 2062293424 26856384 22114992
23:39:11 4070 8192000000 10987237264 11404673024 2018736288 19.770 100 82 162 0 2070429984 27711936 23981760
23:39:27 3751 8192000000 10991384624 11410464768 2023270608 19.806 100 78 156 0 2076856704 29033760 24552336
23:39:38 1869 8192000000 10997355584 11418177536 2028011168 19.843 100 85 170 0 2084418368 31089952 25317248
23:39:49 2666 8192000000 10977336368 11401400320 2010616896 19.706 100 80 160 1 2066879408 31915840 24346672
23:40:02 1397 8192000000 10973219344 11381993472 1982667664 19.486 99 90 183 2 2042597008 32104816 27824528
23:40:10 4814 8192000000 10954443328 11375955968 1971821168 19.400 99 74 148 0 2026413104 32328592 22263344
23:40:22 3539 8192000000 10954468144 11370377216 1978130160 19.450 100 74 148 1 2035612704 35468000 22014544
23:40:32 2104 8192000000 10959225168 11376254976 1986661840 19.517 100 80 157 0 2041828048 31204720 23961488
23:40:40 2109 8192000000 10945422576 11365572608 1969109712 19.378 99 77 154 0 2024582128 32690000 22782416
23:40:50 4401 8192000000 10949090928 11365924864 1977106880 19.442 100 75 151 0 2034133264 33968080 23058304
23:41:04 4601 8192000000 10951084672 11370328064 1966014416 19.354 99 76 152 4 2024902928 35030544 23857968
23:41:17 4681 8192000000 10952324832 11376177152 1980195552 19.466 100 67 134 3 2036870912 36069632 20605728
23:41:32 7374 8192000000 10959315600 11383230464 1987004976 19.520 100 64 128 0 2042074192 35223216 19846000
23:41:50 9503 8192000000 10937719056 11366023168 1971228528 19.395 99 60 120 0 2024212944 32810848 20173568
23:42:06 3778 8192000000 10954848976 11378888704 1983672560 19.494 100 67 132 1 2038170528 33229632 21268336
23:42:18 4187 8192000000 10965032336 11384909824 1976362512 19.436 99 84 167 0 2037193936 35427872 25403552
23:42:32 4979 8192000000 10967896528 11379560448 1983463200 19.492 100 76 153 1 2043239888 35671664 24105024
23:42:54 7949 8192000000 10977838880 11394588672 1992255072 19.562 100 79 158 3 2056644448 39776000 24613376
23:43:09 1114 8192000000 10966311936 11380740096 1979382416 19.460 100 86 172 1 2047788256 40665536 27740304
23:43:19 3294 8192000000 10957620768 11382497280 1977878448 19.448 100 68 136 0 2042601360 43150896 21572016
23:43:29 2232 8192000000 10966217984 11382079488 1978605904 19.454 100 83 163 3 2041554288 37743744 25204640
23:43:39 2046 8192000000 10964163616 11378040832 1977834928 19.448 100 86 173 0 2043675248 38158432 27681888
23:43:49 2356 8192000000 10965946912 11377520640 1979949184 19.464 100 87 174 0 2046293728 39246736 27097808
23:43:58 2288 8192000000 10973545632 11382468608 1982743904 19.486 100 90 179 2 2050507264 39959248 27804112
23:44:08 1212 8192000000 10979027376 11386015744 1983134304 19.490 100 95 190 3 2055428656 42648672 29645680
23:44:16 4259 8192000000 10956003792 11367337984 1958150784 19.291 99 81 160 0 2027828512 44172672 25505056
23:44:27 4173 8192000000 10943775488 11357065216 1953383360 19.253 99 79 152 4 2022447888 44813584 24250944
23:44:38 3575 8192000000 10934372912 11341012992 1927996272 19.051 98 75 150 1 1997567104 45699520 23871312
23:44:48 6173 8192000000 10952850256 11371786240 1965830272 19.352 100 79 158 3 2038929648 47432480 25666896
23:45:05 4323 8192000000 10940033328 11363680256 1954286288 19.261 100 72 143 1 2028722320 50527040 23908992
23:45:19 3246 8192000000 10952920320 11373404160 1961777312 19.320 100 58 116 1 2029007456 47537040 19693104
23:45:30 2090 8192000000 10976837136 11388669952 1979130896 19.458 100 83 166 2 2055675712 49813104 26731712
23:45:39 9856 8192000000 10920287280 11346841600 1927826192 19.049 98 57 113 1 1991171648 44959408 18386048
23:45:59 8024 8192000000 10915636704 11338182656 1905812320 18.873 98 52 103 3 1966777664 44076320 16889024
23:46:26 4012 8192000000 10915224272 11330658304 1924101504 19.020 100 56 112 2 1986536768 43972400 18462864
23:46:37 1382 8192000000 10940886464 11353509888 1949672288 19.224 100 89 178 0 2022901296 45847504 27381504
23:46:45 2771 8192000000 10949785120 11365249024 1953699744 19.256 100 69 135 2 2022319280 47433168 21186368
23:46:56 8271 8192000000 10945470960 11367571456 1956407136 19.277 100 70 139 2 2027666096 48403296 22855664
23:47:12 6055 8192000000 10955449472 11384180736 1962931296 19.329 100 63 126 1 2040720416 57407376 20381744
23:47:41 15464 8192000000 10929164448 11385970688 1946728400 19.200 99 40 80 5 2014979600 54097808 14153392
23:48:10 13210 8192000000 10922867760 11375210496 1941636800 19.160 99 35 70 3 2002930272 49412112 11881360
23:48:31 10435 8192000000 10921048608 11369979904 1962553312 19.326 100 34 68 3 2008738160 34703600 11481248
23:49:04 9429 8192000000 10912477472 11353710592 1927415296 19.046 99 33 66 0 1977451424 38582288 11453840
23:49:21 19906 8192000000 10893646096 11334086656 1901820912 18.841 98 33 66 2 1948790384 35919776 11049696
23:49:49 10055 8192000000 10912516128 11348500480 1940935872 19.154 100 37 72 1 1988474480 36062064 11476544
23:50:12 5488 8192000000 10934508816 11362263040 1952100656 19.243 100 53 106 1 2008364160 39425088 16838416
23:50:24 18561 8192000000 10917277824 11366367232 1953904080 19.258 100 33 66 2 2005976944 40951360 11121504
23:50:55 19490 8192000000 10925950864 11371257856 1937826368 19.129 99 29 58 1 1993412912 45070624 10515920
23:51:21 57356 8192000000 10919828640 11365228544 1955819104 19.273 100 23 46 0 1994435040 28822832 9793104
23:52:27 9492 8192000000 10937269360 11378380800 1970545216 19.390 100 45 88 0 2017020480 32776624 13698640
23:52:49 25819 8192000000 10911222992 11372097536 1947307136 19.205 99 25 50 1 1988246096 32831728 8107232
23:53:21 20934 8192000000 10915065584 11373690880 1959800656 19.304 100 18 36 0 1997571408 31656480 6114272
23:53:50 26666 8192000000 10890882416 11354120192 1931701120 19.080 99 14 28 1 1974377632 37770480 4906032
23:54:23 24955 8192000000 10904098784 11374919680 1931994080 19.083 99 20 40 0 1972446576 33701904 6750592
23:54:54 28462 8192000000 10877417168 11347718144 1928967136 19.059 100 12 24 2 1965734256 32871392 3895728
23:55:35 43926 8192000000 10881372352 11343740928 1929570336 19.063 100 17 34 2 1965028896 29785104 5673456
23:56:28 41371 8192000000 10880937168 11339833344 1907076320 18.883 98 19 37 2 1940166736 27411504 5678912
23:57:19 80887 8192000000 10912409008 11351777280 1942615872 19.168 99 31 61 2 1964731984 12403872 9712240
23:58:49 70222 8192000000 10861348864 11313299456 1868241536 18.570 95 10 20 2 1882100784 11830272 2028976
00:00:08 20488 8192000000 10896599072 11347324928 1960607664 19.311 100 18 36 1 1978088448 12908560 4572224
00:00:36 55124 8192000000 10904095600 11366682624 1925659072 19.032 98 10 21 2 1946840880 18548496 2633312
00:01:41 112195 8192000000 10889984192 11349180416 1901943360 18.842 97 4 8 1 1921163680 18549120 671200
00:03:39 66053 8192000000 10903349680 11349893120 1950108704 19.227 99 19 39 1 1963286432 7548896 5628832
00:04:53 38622 8192000000 10922008912 11361918976 1947825056 19.209 99 21 42 2 1968860176 15426384 5608736
00:05:39 70310 8192000000 10929264640 11383779328 1977503520 19.445 100 60 121 5 2006617392 11421936 17691936
00:07:25 98236 8192000000 10919177264 11389947904 1965396832 19.349 99 28 55 3 1989822608 16696960 7728816
00:09:10 9652 8192000000 10911091440 11365355520 1966725712 19.359 99 49 93 3 1986240960 6416112 13099136
00:09:28 76983 8192000000 10885783712 11353772032 1921392976 18.998 97 31 62 1 1942351280 11444624 9513680
00:10:51 76650 8192000000 10904803136 11375382528 1975201392 19.427 100 10 20 0 1994025760 15660304 3164064
00:12:15 20818 8192000000 10913269952 11379908608 1981202624 19.474 100 19 38 1 2005003104 18552624 5247856
00:12:43 16470 8192000000 10948417200 11394314240 1992845888 19.566 100 44 88 2 2021225200 16284848 12094464
00:13:09 53037 8192000000 10901433568 11373453312 1922496864 19.007 97 13 26 0 1944735104 18302960 3935280
00:14:23 69865 8192000000 10941428224 11402022912 1988166016 19.529 100 15 30 0 2007922976 15316336 4440624
00:15:46 32289 8192000000 10921039680 11401121792 1997809920 19.605 100 27 54 0 2018023456 13051584 7161952
00:16:24 58604 8192000000 10921503536 11410649088 2000546880 19.627 100 10 20 0 2014949216 11720240 2682096
00:17:29 28162 8192000000 10909781488 11382702080 1962500592 19.326 98 5 11 0 1976040096 12119008 1420496
00:18:04 32868 8192000000 10915117696 11391950848 1992391552 19.563 100 11 22 2 2005338384 9904720 3042112
00:19:19 50477 8192000000 10918277680 11398348800 1986435984 19.516 99 7 14 1 1997886656 9125264 2325408
00:20:31 44358 8192000000 10911849968 11397140480 1990116512 19.545 100 7 14 1 2001536720 9558912 1861296
00:21:31 66954 8192000000 10899977488 11389890560 1970330912 19.388 99 15 31 0 1984064336 10039152 3694272
00:22:44 50880 8192000000 10921384384 11399962624 1977552768 19.445 99 17 34 0 1988950048 6914048 4483232
00:24:01 29947 8192000000 10926793568 11401900032 2007306864 19.680 100 16 32 2 2020904592 8834272 4763456
00:24:38 43532 8192000000 10898230400 11380305920 1924453920 19.023 96 14 28 0 1939803424 11257088 4092416
00:26:49 61165 8192000000 10890134832 11373649920 1915012768 18.947 96 20 40 1 1934040720 13597008 5430944
00:28:15 52383 8192000000 10885345264 11362766848 1914174016 18.940 97 18 36 1 1931133392 11861888 5097488
00:29:15 41925 8192000000 10874124032 11328905216 1914487056 18.943 98 11 22 1 1931667520 14652896 2527568
00:30:04 32333 8192000000 10878549280 11347263488 1931665024 19.080 99 20 40 1 1945784320 9053232 5066064
00:30:42 30825 8192000000 10892097840 11358326784 1947759424 19.209 99 18 36 0 1960693696 7851616 5082656
00:31:24 52873 8192000000 10881597664 11353935872 1906625936 18.880 97 18 36 0 1925584768 13375552 5583280
00:32:23 29937 8192000000 10857228384 11324370944 1881401536 18.676 96 25 50 2 1901197584 12709936 7086112
00:33:05 30944 8192000000 10891492288 11344355328 1921385984 18.998 98 36 72 0 1946975376 15152192 10437200
00:33:44 17124 8192000000 10873468304 11330666496 1908787504 18.897 98 53 106 1 1942617168 18727168 15102496
00:34:10 31729 8192000000 10868501520 11322839040 1877922880 18.648 97 24 48 2 1902474624 17787056 6764688
00:34:49 68988 8192000000 10848810544 11312619520 1829283008 18.253 95 22 44 1 1853432080 17613584 6535488
00:36:04 51727 8192000000 10849032128 11308888064 1818254816 18.163 95 11 22 0 1836351488 15150208 2946464
00:37:04 95363 8192000000 10873503904 11329695744 1888482384 18.734 98 17 34 1 1906369136 13146400 4740352
00:38:46 37695 8192000000 10857460864 11322286080 1913959776 18.938 99 25 46 1 1930695360 10300272 6435312
00:39:34 28528 8192000000 10854400320 11309080576 1857019584 18.479 96 24 48 1 1873017712 9538864 6459264
00:40:11 39046 8192000000 10885026080 11335815168 1937643424 19.128 100 27 54 2 1956067696 11015376 7408896
00:40:59 28027 8192000000 10883074128 11321962496 1890535568 18.750 97 52 104 2 1915710720 10785856 14389296
00:43:02 62915 8192000000 10861035024 11327586304 1902865104 18.849 98 23 46 1 1926880304 17187888 6827312
00:44:13 46372 8192000000 10875992080 11319320576 1915779040 18.953 99 45 82 0 1933144192 6055264 11309888
00:45:06 1302 8192000000 10904988784 11328319488 1946056144 19.195 100 95 193 6 1982035072 8290640 27688288
00:45:14 55603 8192000000 10862009504 11334410240 1932626736 19.088 99 48 96 1 1957640560 11405648 13608176
00:46:23 57416 8192000000 10859936960 11343613952 1924000624 19.019 99 7 14 0 1936100656 9995584 2104448
00:47:27 41759 8192000000 10872216368 11347587072 1948231088 19.212 100 15 30 2 1960427104 7921248 4274768
00:48:15 79394 8192000000 10861992128 11334225920 1897662688 18.807 97 26 52 2 1914150384 8904016 7583680
00:49:41 69488 8192000000 10870915680 11339202560 1950266976 19.229 100 14 28 1 1963015568 8600624 4147968
00:51:10 30049 8192000000 10863479568 11348140032 1926929472 19.042 99 22 43 2 1945437584 12151472 6356640
00:51:46 55912 8192000000 10857870064 11337367552 1927701488 19.048 99 10 20 0 1941549440 11085680 2762272
00:52:50 76970 8192000000 10880598992 11351375872 1941457376 19.158 100 8 16 2 1955138640 11351328 2329936
00:54:54 10451 8192000000 10874538912 11335319552 1936928768 19.122 99 45 90 3 1959128032 8181680 14017584
00:55:14 33015 8192000000 10865091824 11323121664 1872390240 18.604 96 25 50 0 1891662480 12511904 6760336
00:56:08 51146 8192000000 10897884320 11351212032 1952603488 19.247 100 28 56 3 1974548256 14358240 7586528
00:57:05 22034 8192000000 10923169552 11372609536 1964525776 19.342 100 38 76 0 1986494112 11545584 10422752
00:57:34 77752 8192000000 10896400448 11376857088 1948326512 19.213 99 20 40 0 1970878736 16879104 5673120
00:58:58 53397 8192000000 10905100976 11371565056 1954958064 19.266 99 21 42 2 1970202544 9720272 5524208
01:00:00 60427 8192000000 10904592128 11385098240 1954607328 19.263 99 9 18 0 1970261184 13112368 2541488
01:01:12 74235 8192000000 10913200224 11391934464 1948484176 19.214 98 8 16 0 1966460224 15618880 2357168
01:02:33 95916 8192000000 10905414992 11384016896 1951846800 19.241 99 11 22 0 1979913664 24967536 3099328
01:05:00 39399 8192000000 10924926464 11371626496 1972502704 19.405 100 31 63 3 1994401232 13449024 8449504
01:05:51 43635 8192000000 10924337696 11397775360 1985100640 19.505 100 25 49 2 2006394480 14419184 6874656
01:06:41 119004 8192000000 10917085280 11385602048 1971713456 19.399 99 14 28 1 1995151168 19798880 3638832
01:08:46 94339 8192000000 10924716016 11391672320 1976202784 19.435 99 21 42 1 1988870544 6629280 6038480
01:10:28 47580 8192000000 10893968768 11386912768 1967879328 19.369 99 22 44 2 1986863424 12382032 6602064
01:11:53 54584 8192000000 10903664400 11393503232 1986032768 19.512 100 7 13 1 1996209440 8259232 1917440
01:13:03 41731 8192000000 10884088544 11368476672 1947439024 19.206 98 12 24 0 1958715232 7547424 3728784
01:13:51 15055 8192000000 10917471808 11363676160 1957456800 19.286 99 14 30 1 1967549472 6556128 3536544
01:14:14 67818 8192000000 10893669984 11375554560 1922619840 19.008 97 11 22 0 1933119152 7149552 3349760
01:15:38 54139 8192000000 10878182240 11354378240 1897819280 18.809 96 11 22 1 1909661152 8640736 3201136
01:16:46 52526 8192000000 10872920736 11342884864 1918893632 18.978 98 22 44 3 1933595296 8759952 5941712
01:17:53 85964 8192000000 10874598048 11353059328 1916337728 18.957 98 12 24 0 1931080192 11304704 3437760
01:19:29 51611 8192000000 10827476352 11294916608 1797484256 17.993 92 12 24 1 1813372592 12277232 3611104
01:20:27 39926 8192000000 10826375264 11284328448 1782439584 17.870 92 36 68 1 1801425104 9001712 9983808
01:21:39 31783 8192000000 10835844544 11289767936 1857682816 18.484 97 25 50 0 1873844832 8628160 7533856
01:22:20 38389 8192000000 10860502848 11321208832 1905584832 18.871 99 33 65 1 1926047360 11130128 9332400
01:23:05 70215 8192000000 10833867840 11295293440 1835483248 18.304 95 27 53 0 1854031792 11002656 7545888
01:24:27 78449 8192000000 10864405696 11333017600 1899741952 18.824 98 27 55 1 1922590672 15005344 7843376
01:26:23 48598 8192000000 9361326192 9644687360 499581584 5.747 26 9 18 0 509821968 7145280 3095104

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 12-11-2020 01:28:15 to 12-11-2020 01:28:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 111 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-11-2020 01:28:47 to 12-11-2020 01:28:49.

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          241499
MON$OLDEST_ACTIVE               244729
MON$OLDEST_SNAPSHOT             244729
MON$NEXT_TRANSACTION            244729
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                       2048288
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:293: 
:294: mscs-test-161.budzdorov.ru    Thu Nov 12 01:27:13 2020
:295:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:296: 
:297: 
:298: mscs-test-161.budzdorov.ru    Thu Nov 12 01:27:16 2020
:299:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:300: 
:301: 
:302: mscs-test-161.budzdorov.ru    Thu Nov 12 01:27:18 2020
:303:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:304: 
--- end of diff output ---

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

12.11.20 01:28:50. 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
2020-11-12 01:28:53 No severe PSQL-related problems occured
12.11.20 01:28:54. End of report.