Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.03.2021 19:28
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 17596512 kB
MemAvailable 31600168 kB
Buffers 0 kB
Cached 14063492 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-06 19:27:22
DTS_END                         2021-03-06 19:27:22.0010
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35838
TRN_ID                          237311
ATT_ID                          671
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: 9040.33 22385 1084839
customer order: creation 173.37 364 20804
customer order: refuse 15.30 358 1836
order to supplier: creation 46.10 1341 5532
order to supplier: removal 3.23 104198 387
invoice (draft): creation 46.00 3280 5520
invoice (draft): removal 51.18 772 6141
invoice accept: apply 41.43 16979 4972
invoice accept: cancel 46.25 801 5550
customer reserve: creation 3743.67 171 449240
customer reserve: removal 4581.44 58 549773
realization accept: apply 84.48 173 10137
realization accept: cancel 76.80 108 9216
payment from customer: creation 60.90 107 7308
payment from customer: removal 5.97 69 716
payment to supplier: creation 48.51 118 5821
payment to supplier: removal 3.55 61 426
service: total inventory turnovers 4.88 1067 586
service: total monetary turnovers 6.37 27 764
service: aggregate perf. data 0.88 20693 106
service: refresh index statistics 0.03 296955 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-03-2021 19:28:36 to 06-03-2021 19:28:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1172
TEST_TIME 2 2984
TEST_TIME 3 3863
TEST_TIME 4 3887
TEST_TIME 5 4097
TEST_TIME 6 4237
TEST_TIME 7 4394
TEST_TIME 8 5178
TEST_TIME 9 5180
TEST_TIME 10 5208
TEST_TIME 11 5383
TEST_TIME 12 5617
TEST_TIME 13 5976
TEST_TIME 14 6264
TEST_TIME 15 6680
TEST_TIME 16 7343
TEST_TIME 17 7543
TEST_TIME 18 7882
TEST_TIME 19 8092
TEST_TIME 20 8204
TEST_TIME 21 8535
TEST_TIME 22 8720
TEST_TIME 23 9222
TEST_TIME 24 9705
TEST_TIME 25 9761
TEST_TIME 26 10425
TEST_TIME 27 10685
TEST_TIME 28 10761
TEST_TIME 29 10764
TEST_TIME 30 10597
TEST_TIME 31 10474
TEST_TIME 32 10541
TEST_TIME 33 10345
TEST_TIME 34 10126
TEST_TIME 35 10122
TEST_TIME 36 9956
TEST_TIME 37 10054
TEST_TIME 38 9986
TEST_TIME 39 9883
TEST_TIME 40 9717
TEST_TIME 41 9610
TEST_TIME 42 9533
TEST_TIME 43 9387
TEST_TIME 44 9438
TEST_TIME 45 9546
TEST_TIME 46 9387
TEST_TIME 47 9279
TEST_TIME 48 9373
TEST_TIME 49 9385
TEST_TIME 50 9349
TEST_TIME 51 9381
TEST_TIME 52 9460
TEST_TIME 53 9419
TEST_TIME 54 9495
TEST_TIME 55 9483
TEST_TIME 56 9427
TEST_TIME 57 9570
TEST_TIME 58 9525
TEST_TIME 59 9601
TEST_TIME 60 9566
TEST_TIME 61 9530
TEST_TIME 62 9397
TEST_TIME 63 9407
TEST_TIME 64 9308
TEST_TIME 65 9355
TEST_TIME 66 9283
TEST_TIME 67 9300
TEST_TIME 68 9241
TEST_TIME 69 9217
TEST_TIME 70 9213
TEST_TIME 71 9205
TEST_TIME 72 9206
TEST_TIME 73 9231
TEST_TIME 74 9214
TEST_TIME 75 9259
TEST_TIME 76 9310
TEST_TIME 77 9298
TEST_TIME 78 9341
TEST_TIME 79 9397
TEST_TIME 80 9389
TEST_TIME 81 9480
TEST_TIME 82 9377
TEST_TIME 83 9301
TEST_TIME 84 9292
TEST_TIME 85 9287
TEST_TIME 86 9273
TEST_TIME 87 9209
TEST_TIME 88 9156
TEST_TIME 89 9117
TEST_TIME 90 9108
TEST_TIME 91 9034
TEST_TIME 92 9127
TEST_TIME 93 9100
TEST_TIME 94 9107
TEST_TIME 95 9118
TEST_TIME 96 9189
TEST_TIME 97 9188
TEST_TIME 98 9188
TEST_TIME 99 9207
TEST_TIME 100 9204
TEST_TIME 101 9271
TEST_TIME 102 9285
TEST_TIME 103 9312
TEST_TIME 104 9313
TEST_TIME 105 9296
TEST_TIME 106 9322
TEST_TIME 107 9289
TEST_TIME 108 9255
TEST_TIME 109 9229
TEST_TIME 110 9197
TEST_TIME 111 9162
TEST_TIME 112 9114
TEST_TIME 113 9102
TEST_TIME 114 9077
TEST_TIME 115 9105
TEST_TIME 116 9124
TEST_TIME 117 9104
TEST_TIME 118 9097
TEST_TIME 119 9072
TEST_TIME 120 9041

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 06-03-2021 19:28:39 to 06-03-2021 19:28:43.

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 1502071 1502071 0 0.00 0 14857 6 0 0
doc_list_biud 1502070 1502070 0 0.00 0 46002 27 0 0
sp_add_invoice_to_stock 5118 4972 146 2.85 37 133358 16979 0 146
sp_cancel_adding_invoice 5550 5550 0 0.00 5 70698 801 0 0
sp_cancel_client_order 1836 1836 0 0.00 4 17668 358 0 0
sp_cancel_customer_reserve 549773 549773 0 0.00 1 23202 58 0 0
sp_cancel_pay_from_customer 716 716 0 0.00 3 5183 69 0 0
sp_cancel_pay_to_supplier 426 426 0 0.00 3 2724 62 0 0
sp_cancel_supplier_invoice 6155 6141 14 0.22 2 14652 773 0 14
sp_cancel_supplier_order 387 387 0 0.00 6 1183303 104198 0 0
sp_cancel_write_off 9216 9216 0 0.00 1 7766 108 0 0
sp_client_order 20804 20804 0 0.00 4 23049 364 0 0
sp_customer_reserve 449240 449240 0 0.00 0 40736 171 0 0
sp_fill_shopping_cart 31850 31850 0 0.00 1 28776 38 0 0
sp_fill_shopping_cart_clo_res 449238 449238 0 0.00 0 32375 14 0 0
sp_get_clo_for_invoice 4970 4970 0 0.00 0 37532 326 0 0
sp_kill_cost_storno 15908 15908 0 0.00 0 12953 55 0 0
sp_kill_qstorno_ret_qs2qd 1115290 1115290 0 0.00 0 23072 31 0 0
sp_kill_qty_storno 588010 588010 0 0.00 0 46001 68 0 0
sp_lock_selected_doc 20986 20986 0 0.00 0 7766 4 0 0
sp_make_cost_storno 28236 28236 0 0.00 0 12537 50 0 0
sp_multiply_rows_for_pdistr 28236 28236 0 0.00 0 7503 28 0 0
sp_multiply_rows_for_qdistr 20804 20804 0 0.00 0 23037 168 0 0
sp_pay_from_customer 7308 7308 0 0.00 4 13762 107 0 0
sp_pay_to_supplier 5821 5821 0 0.00 5 10250 119 0 0
sp_payment_common 13129 13129 0 0.00 1 10383 24 0 0
sp_qd_handle_on_cancel_clo 1836 1836 0 0.00 0 17662 323 0 0
sp_qd_handle_on_invoice_upd_sts 10520 10520 0 0.00 0 46000 334 0 0
sp_qd_handle_on_reserve_upd_sts 10137 10137 0 0.00 0 13781 59 0 0
sp_reserve_write_off 10137 10137 0 0.00 6 13951 174 0 0
sp_supplier_invoice 5520 5520 0 0.00 7 95919 3281 0 0
sp_supplier_order 5532 5532 0 0.00 5 47072 1342 0 0
srv_aggregate_perf_data 106 106 0 0.00 2153 431905 20693 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 965 185480 35595 0 0
srv_find_qd_qs_mism 1037908 1037908 0 0.00 0 14856 5 0 0
srv_make_invnt_saldo 586 586 0 0.00 39 45942 1067 0 0
srv_make_money_saldo 764 764 0 0.00 0 728 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 161871 403939 296956 0 0
t$perf-abend:sp_add_invoice_to_stock 146 146 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4972 4972 0 0.00 0 14148 169 0 0
t$perf-norm:sp_cancel_adding_invoice 401 401 0 0.00 1 9892 142 0 0
t$perf-norm:sp_cancel_client_order 1836 1836 0 0.00 0 3932 17 0 0
t$perf-norm:sp_cancel_customer_reserve 690 690 0 0.00 0 3471 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 716 716 0 0.00 0 432 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 426 426 0 0.00 0 4240 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 410 410 0 0.00 0 1364 13 0 0
t$perf-norm:sp_cancel_supplier_order 387 387 0 0.00 0 23116 1475 0 0
t$perf-norm:sp_cancel_write_off 1013 1013 0 0.00 0 1929 9 0 0
t$perf-norm:sp_client_order 20804 20804 0 0.00 0 10421 20 0 0
t$perf-norm:sp_customer_reserve 968 968 0 0.00 0 6477 13 0 0
t$perf-norm:sp_pay_from_customer 7308 7308 0 0.00 0 4429 8 0 0
t$perf-norm:sp_pay_to_supplier 5821 5821 0 0.00 0 6169 9 0 0
t$perf-norm:sp_reserve_write_off 10137 10137 0 0.00 0 6147 10 0 0
t$perf-norm:sp_supplier_invoice 5520 5520 0 0.00 0 7524 17 0 0
t$perf-norm:sp_supplier_order 5532 5532 0 0.00 0 6086 18 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 641 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 400 4 0 0
t$perf-norm:srv_make_invnt_saldo 586 586 0 0.00 0 3212 30 0 0
t$perf-norm:srv_make_money_saldo 764 764 0 0.00 0 1115 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10232 9940 292 2.85 0 6921 22 0 292
v_all_customers 38118 38118 0 0.00 0 18 1 0 0
v_all_suppliers 30502 30502 0 0.00 0 17 1 0 0
v_all_wares 41608 41608 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 802 802 0 0.00 0 3004 10 0 0
v_cancel_client_order 3672 3672 0 0.00 0 6584 8 0 0
v_cancel_customer_prepayment 1432 1432 0 0.00 0 5113 9 0 0
v_cancel_customer_reserve 1380 1380 0 0.00 0 2724 7 0 0
v_cancel_payment_to_supplier 852 852 0 0.00 0 2701 7 0 0
v_cancel_supplier_invoice 848 820 28 3.30 0 466 15 0 28
v_cancel_supplier_order 774 774 0 0.00 0 2648 10 0 0
v_cancel_write_off 2026 2026 0 0.00 0 935 11 0 0
v_max_id_clo_ord 5532 5532 0 0.00 0 434 1 0 0
v_max_id_clo_res 968 968 0 0.00 0 3290 16 0 0
v_max_id_ord_sup 5514 5514 0 0.00 0 2545 5 0 0
v_max_non_paid_invoice 1616 1616 0 0.00 0 1687 4 0 0
v_max_non_paid_realizn 3840 3840 0 0.00 0 2543 4 0 0
v_min_id_clo_ord 5532 5532 0 0.00 0 3673 6 0 0
v_min_id_clo_res 968 968 0 0.00 0 11240 20 0 0
v_min_id_ord_sup 5514 5514 0 0.00 0 5620 6 0 0
v_min_non_paid_invoice 5821 5821 0 0.00 0 4540 14 0 0
v_min_non_paid_realizn 7308 7308 0 0.00 0 6127 13 0 0
v_our_firm 10426 10426 0 0.00 0 17 1 0 0
v_reserve_write_off 20274 20274 0 0.00 0 8165 8 0 0
x_lock_depdocs_on_canc_invoice 11281 11281 0 0.00 0 18083 117 0 0
x_lock_depdocs_on_canc_sup_ord 387 387 0 0.00 0 8275 388 0 0
x_make_qstorno_1000_1200 5532 5532 0 0.00 2 47046 1264 0 0
x_make_qstorno_1200_2000 5520 5520 0 0.00 3 91446 3140 0 0
x_make_qstorno_2100_3300 449240 449240 0 0.00 0 40735 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-03-2021 19:28:44 to 06-03-2021 19:28:48.

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:25 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:32 20778 8192000000 10269659248 10577416192 1029201424 11.161 79 61 122 1 1051978464 2801328 19975712
16:58:00 33038 8192000000 10339507280 10657087488 1376240240 14.383 100 86 171 1 1409545472 5416576 27888656
16:58:41 19950 8192000000 10373347824 10695827456 1429150528 14.854 100 90 180 0 1465507728 6763744 29593456
16:59:11 29120 8192000000 10398473280 10722971648 1457889728 15.107 100 90 180 0 1495182544 7751680 29541136
16:59:52 10522 8192000000 10418566352 10747875328 1471791472 15.229 100 87 174 0 1508694672 8508736 28394464
17:00:15 20460 8192000000 10431275824 10765115392 1482825968 15.326 100 85 170 2 1519547424 8751920 27969536
17:00:47 18860 8192000000 10460221472 10792914944 1513482784 15.594 100 92 184 0 1552304256 9632800 29188672
17:01:14 9220 8192000000 10464295376 10800910336 1518850144 15.640 100 86 171 1 1555287840 9592448 26845248
17:01:34 8503 8192000000 10472898704 10817896448 1538812800 15.813 100 76 152 0 1571726272 9400336 23513136
17:01:57 15494 8192000000 10512310032 10862010368 1565941136 16.047 100 83 166 1 1601759312 10339344 25478832
17:02:20 15788 8192000000 10545994528 10898960384 1593921072 16.287 100 76 151 2 1627357984 10825328 22611584
17:02:45 10872 8192000000 10567043152 10924802048 1620944080 16.518 100 73 146 0 1654150752 11151056 22055616
17:03:03 20056 8192000000 10612310944 10972454912 1660724944 16.855 100 85 170 0 1697847280 12214544 24907792
17:03:30 11953 8192000000 10624406464 10992242688 1688023584 17.085 100 82 164 1 1724902784 12977488 23901712
17:03:50 9602 8192000000 10641651840 11010068480 1693021872 17.127 100 77 154 0 1728910928 13245664 22643392
17:04:09 10097 8192000000 10657941552 11025022976 1715824320 17.317 100 83 166 1 1754182672 14074736 24283616
17:04:27 10363 8192000000 10661435936 11034198016 1726481936 17.406 100 82 163 2 1763378976 13088128 23808912
17:04:45 6773 8192000000 10674213088 11050131456 1733889232 17.468 100 81 161 1 1770222864 13197968 23135664
17:05:00 6350 8192000000 10689958256 11065921536 1744675280 17.557 100 68 136 0 1776415232 12116592 19623360
17:05:14 4426 8192000000 10704059248 11082440704 1762786832 17.707 100 82 164 2 1802064880 15871584 23406464
17:05:25 4817 8192000000 10703972448 11082469376 1767776464 17.749 100 85 171 0 1807981696 17068704 23136528
17:05:37 3331 8192000000 10713033600 11094061056 1773911568 17.799 100 71 142 0 1808147232 13114864 21120800
17:05:48 4185 8192000000 10719373504 11101483008 1781220928 17.860 100 75 150 0 1815029808 12776608 21032272
17:05:59 4485 8192000000 10727168016 11107966976 1790986624 17.940 100 89 174 1 1829042800 12847408 25208768
17:06:18 5369 8192000000 10727797200 11120021504 1797573072 17.994 100 76 151 1 1831779920 12663824 21543024
17:06:32 2884 8192000000 10761646816 11142082560 1818174928 18.163 100 88 179 2 1856680272 13491152 25014192
17:06:41 2995 8192000000 10765872160 11153510400 1828721552 18.249 100 81 162 0 1864081552 12321520 23038480
17:06:51 3895 8192000000 10780098128 11163721728 1834881904 18.299 100 86 172 1 1872186016 13600432 23703680
17:07:02 3666 8192000000 10784308640 11173974016 1844638480 18.379 100 88 173 1 1882135904 13363008 24134416
17:07:13 2723 8192000000 10786644352 11174780928 1849016656 18.414 100 81 163 2 1883423040 11831168 22575216
17:07:22 2249 8192000000 10796054032 11186098176 1852246304 18.440 100 84 167 1 1888561056 11415728 24899024
17:07:31 2249 8192000000 10802994896 11191541760 1862269472 18.522 100 92 182 2 1900431744 11917424 26244848
17:07:40 1957 8192000000 10814802656 11201056768 1869712928 18.582 100 90 178 1 1907557360 12858848 24985584
17:07:48 2956 8192000000 10816650544 11204681728 1870949520 18.592 100 91 181 0 1909996208 13331424 25715264
17:07:58 2061 8192000000 10809523408 11201040384 1872923664 18.608 100 87 174 2 1909701504 12352384 24425456
17:08:07 1984 8192000000 10816982864 11206610944 1874145664 18.618 100 88 175 3 1912579648 13825664 24608320
17:08:15 2447 8192000000 10817009760 11209789440 1877764464 18.647 100 91 182 1 1917807040 13243888 26798688
17:08:24 3316 8192000000 10829103040 11219943424 1884617136 18.702 100 89 178 1 1921324096 11770400 24936560
17:08:34 2203 8192000000 10827711632 11218202624 1884071280 18.698 100 92 184 1 1923195872 12524720 26599872
17:08:42 1336 8192000000 10829389808 11220418560 1883861232 18.696 100 89 176 2 1921092640 12235840 24995568
17:08:50 1837 8192000000 10838527504 11231125504 1886634000 18.719 100 95 188 1 1932050896 18486496 26930400
17:08:58 1449 8192000000 10829848016 11223678976 1886955392 18.721 100 91 182 0 1926246640 13843296 25447952
17:09:06 2702 8192000000 10820722208 11228647424 1891600096 18.759 100 78 155 1 1926135104 12871744 21663264
17:09:15 33415 8192000000 10816978176 11224399872 1883633360 18.694 100 46 85 3 1903284224 6896992 12753872
17:09:55 17916 8192000000 10831572848 11229999104 1890859776 18.753 100 77 154 4 1922493216 9476368 22157072
17:10:20 1164 8192000000 10848588064 11244961792 1901795296 18.841 100 91 181 0 1940728944 12877600 26056048
17:10:28 5423 8192000000 10834801056 11241246720 1901238016 18.836 100 78 156 0 1935584352 12381584 21964752
17:10:41 2918 8192000000 10825152400 11240366080 1897337424 18.805 100 55 111 1 1924575616 10400640 16837552
17:10:51 3711 8192000000 10826811904 11241070592 1899884656 18.825 100 55 110 0 1925805312 10227664 15692992
17:11:02 2225 8192000000 10827885776 11243659264 1900778128 18.833 100 53 106 1 1926758080 10787696 15192256
17:11:11 4348 8192000000 10827096528 11241033728 1901768128 18.841 100 61 121 2 1928643856 10592336 16283392
17:11:22 2274 8192000000 10825464176 11241947136 1900958384 18.834 100 55 110 1 1925706992 9594976 15153632
17:11:31 4184 8192000000 10827371264 11241779200 1902738720 18.848 100 58 116 1 1927333728 8181296 16413712
17:11:42 4114 8192000000 10819801968 11242942464 1899766096 18.824 100 39 78 0 1919879232 9201232 10911904
17:11:53 5182 8192000000 10800147424 11236720640 1898829584 18.817 100 35 70 2 1916670704 7707232 10133888
17:12:05 7712 8192000000 10816655472 11241578496 1901062464 18.835 100 28 56 1 1915556976 6211568 8282944
17:12:20 5811 8192000000 10813028816 11240747008 1900481392 18.830 100 30 60 0 1914939888 5558096 8900400
17:12:34 8151 8192000000 10809092928 11243552768 1899948048 18.826 100 27 54 4 1917917120 10744288 7224784
17:12:49 9104 8192000000 10801077120 11240185856 1901165104 18.836 100 25 51 2 1915504928 7106992 7232832
17:13:07 11920 8192000000 10804721280 11242352640 1898531968 18.814 100 12 24 0 1907702768 5912512 3258288
17:13:26 6453 8192000000 10813845856 11249799168 1903051088 18.851 100 24 46 3 1919188464 9970928 6166448
17:13:38 14584 8192000000 10815615888 11248107520 1906385424 18.878 100 26 51 2 1919212992 5484352 7343216
17:14:01 67105 8192000000 10864621600 11267063808 1914152336 18.940 100 67 136 1 1940634688 5473424 21008928
17:15:15 6111 8192000000 10827682848 11261902848 1910234704 18.909 100 36 70 0 1928490896 8291904 9964288
17:15:29 3816 8192000000 10825660048 11258617856 1912464416 18.926 100 48 96 1 1932805920 6437824 13903680
17:15:39 6376 8192000000 10827233200 11250364416 1897809904 18.809 99 42 83 0 1921425840 11685856 11930080
17:15:55 2790 8192000000 10833271440 11258601472 1894201792 18.780 99 46 91 1 1916206800 8741280 13263728
17:16:05 3884 8192000000 10826101904 11255300096 1890647264 18.751 99 49 96 2 1913370368 9388480 13334624
17:16:15 5751 8192000000 10818647248 11245436928 1892481504 18.766 99 38 76 0 1911159776 8030112 10648160
17:16:27 4794 8192000000 10831785328 11256049664 1906051584 18.875 100 26 52 1 1920271696 6724160 7495952
17:16:39 4700 8192000000 10821895168 11261411328 1911276032 18.917 100 33 65 1 1930731552 10567440 8888080
17:16:50 6435 8192000000 10822200368 11257933824 1907635648 18.888 100 20 40 0 1919369024 5966752 5766624
17:17:04 9944 8192000000 10831920096 11262103552 1914045312 18.939 100 19 37 0 1925252864 5983456 5224096
17:17:21 6057 8192000000 10832042528 11267665920 1919275728 18.981 100 32 64 1 1936102304 8050624 8775952
17:17:33 14158 8192000000 10821670960 11242266624 1855571024 18.467 97 22 45 1 1866564832 5081328 5912480
17:17:54 50120 8192000000 10803092912 11211743232 1818336704 18.164 96 39 77 0 1836160112 6443056 11380352
17:18:50 12875 8192000000 10740760096 11164753920 1768646320 17.756 94 20 40 1 1779694192 5145888 5901984
17:19:11 9564 8192000000 10764495824 11191128064 1806618000 18.068 97 32 64 4 1820889056 5865632 8405424
17:19:27 6626 8192000000 10773171616 11194023936 1826175840 18.228 98 39 78 2 1845040944 8264176 10600928
17:19:42 6650 8192000000 10765876112 11184254976 1816172864 18.146 98 34 67 2 1833058608 6916288 9969456
17:19:57 6999 8192000000 10759898656 11174678528 1777382800 17.828 96 28 56 5 1790451808 5250640 7818368
17:20:11 6493 8192000000 10735717568 11159064576 1782644112 17.871 97 28 56 0 1797373904 6287040 8442752
17:20:26 6542 8192000000 10713370944 11126747136 1746622592 17.574 96 19 38 0 1757198032 5561680 5013760
17:20:42 6279 8192000000 10703205648 11119534080 1749619712 17.598 97 42 84 1 1768567984 6424848 12523424
17:20:55 4403 8192000000 10728531376 11142172672 1807779872 18.078 100 29 58 2 1822390496 6206992 8403632
17:21:10 10090 8192000000 10717707600 11140792320 1790961632 17.940 99 19 38 0 1802712608 5718064 6032912
17:21:26 5724 8192000000 10717840464 11135193088 1803310704 18.041 100 26 52 1 1817528016 6752592 7464720
17:21:42 14896 8192000000 10694553136 11113148416 1731717200 17.450 96 22 44 2 1744041616 5896176 6428240
17:22:03 15915 8192000000 10739302144 11145326592 1782983232 17.874 99 20 40 0 1794298176 5618400 5696544
17:22:25 61489 8192000000 10731566848 11142033408 1783616656 17.879 98 39 78 0 1804711072 9705936 11388480
17:23:33 9071 8192000000 10735555840 11162173440 1820031600 18.178 100 17 34 0 1830706208 5903680 4770928
17:23:48 10516 8192000000 10731538240 11161214976 1792379472 17.951 98 12 24 1 1801383376 4831568 4172336
17:24:05 8224 8192000000 10737750464 11166441472 1816338656 18.148 99 37 74 1 1832857808 5428464 11090688
17:24:19 5166 8192000000 10744801776 11167952896 1827503840 18.239 100 27 54 1 1841042208 5552640 7985728
17:24:32 6656 8192000000 10755563200 11183611904 1843357312 18.368 100 30 60 2 1858530976 6320464 8853200
17:24:45 5756 8192000000 10782572704 11189952512 1848706656 18.412 100 36 72 2 1864348336 5098704 10542976
17:24:58 5804 8192000000 10779034496 11188494336 1850037376 18.422 100 57 110 2 1872969728 4923008 18009344
17:25:10 5743 8192000000 10762759472 11187068928 1845987136 18.390 100 19 38 1 1857757760 6053248 5717376
17:25:22 6725 8192000000 10765689744 11191525376 1848403056 18.409 100 23 43 2 1860546784 5203360 6940368
17:25:39 4928 8192000000 10768251920 11188396032 1850884944 18.429 100 31 63 1 1865906272 5778784 9242544
17:25:51 10277 8192000000 10758102960 11191922688 1855061312 18.463 100 33 68 0 1870302016 5959312 9281392
17:26:10 7684 8192000000 10782595984 11201003520 1855978224 18.471 100 27 54 4 1868989344 5102736 7908384
17:26:24 5768 8192000000 10772948080 11200937984 1857849648 18.486 100 29 60 0 1871424928 5050336 8524944
17:26:36 3727 8192000000 10779626720 11202150400 1857047920 18.479 100 23 45 0 1869410048 5924400 6437728
17:26:47 9272 8192000000 10779431184 11202883584 1862915664 18.527 100 21 40 2 1873624272 5175104 5533504
17:27:02 97104 8192000000 10811340752 11233071104 1877136384 18.642 100 30 61 3 1892044800 4850208 10058208
17:28:48 14859 8192000000 10832420128 11252641792 1897941360 18.810 100 39 78 1 1918386704 9049024 11396320
17:29:10 20679 8192000000 10847655568 11271491584 1915419504 18.950 100 54 108 0 1942065936 11400896 15245536
17:29:39 3377 8192000000 10856692832 11279560704 1924906528 19.026 100 56 112 3 1953193840 12385424 15901888
17:29:52 13581 8192000000 10856957392 11281534976 1927169456 19.044 100 59 118 2 1956660768 12835872 16655440
17:30:21 10124 8192000000 10875209280 11297009664 1935482176 19.111 100 57 114 0 1967034064 15503632 16048256
17:30:37 13743 8192000000 10868229264 11298422784 1938167760 19.132 100 48 94 0 1970549744 18801936 13580048
17:30:59 6974 8192000000 10876010384 11300306944 1939325168 19.141 100 49 97 1 1970122848 16224192 14573488
17:31:14 18356 8192000000 10889586320 11311366144 1948920800 19.218 100 57 111 1 1982769344 18016032 15832512
17:31:42 10022 8192000000 10892139024 11319308288 1951360400 19.237 100 46 87 2 1984663360 20526000 12776960
17:32:03 17336 8192000000 10891425824 11317690368 1935219008 19.109 99 43 85 1 1967872432 20462304 12191120
17:32:40 8421 8192000000 10900251888 11326406656 1956388192 19.277 100 48 93 6 1990644064 19769872 14486000
17:32:56 19618 8192000000 10913488448 11337773056 1963753664 19.336 100 49 98 2 1999309168 21204256 14351248
17:33:25 10958 8192000000 10911289072 11342528512 1969930528 19.385 100 50 99 0 2006644928 22221680 14492720
17:33:44 5209 8192000000 10925528112 11351560192 1977030240 19.441 100 58 115 1 2017103344 22620384 17452720
17:33:58 12248 8192000000 10921688816 11354013696 1977241648 19.443 100 58 116 0 2018249280 24292448 16715184
17:34:28 22618 8192000000 10935270720 11368374272 1976958640 19.441 100 49 98 0 2020443232 29064480 14420112
17:35:02 10362 8192000000 10927037056 11361722368 1978828496 19.455 100 44 88 0 2021431968 28851744 13751728
17:35:22 5022 8192000000 10940050992 11366875136 1984814512 19.503 100 55 109 1 2027135600 26887120 15433968
17:35:34 6752 8192000000 10945072016 11371245568 1987739024 19.526 100 63 126 1 2033214432 27174576 18300832
17:35:48 4989 8192000000 10943530592 11371630592 1987655728 19.525 100 62 124 2 2033604736 28032896 17916112
17:36:07 10962 8192000000 10929993840 11367153664 1979506640 19.461 100 45 89 1 2020118752 27925904 12686208
17:36:35 12638 8192000000 10939682816 11374845952 1989109248 19.537 100 49 97 3 2031404544 27865152 14430144
17:36:56 2957 8192000000 10960149488 11376779264 1971575696 19.398 99 66 133 0 2024502688 33486464 19440528
17:37:12 5714 8192000000 10957557088 11373367296 1982737008 19.486 100 69 138 3 2040532672 36334352 21461312
17:37:34 2868 8192000000 10959970160 11387686912 1990408656 19.547 100 70 141 2 2049225584 37269008 21547920
17:37:45 21991 8192000000 10974904192 11400568832 1996971952 19.599 100 67 134 0 2055078832 38158080 19948800
17:38:16 7657 8192000000 10971344336 11403165696 1999889600 19.622 100 59 118 1 2058255008 40790000 17575408
17:38:34 9903 8192000000 10967250320 11404984320 2002421568 19.642 100 61 122 1 2063027904 41939760 18666576
17:38:53 10421 8192000000 10973407904 11406417920 2002469152 19.642 100 53 104 0 2058327616 40067168 15791296
17:39:18 3866 8192000000 10963460144 11399868416 1996538288 19.595 100 61 119 2 2055323152 40770608 18014256
17:39:31 5562 8192000000 10973838560 11402686464 1987734656 19.526 99 67 132 2 2048716688 40889840 20092192
17:39:46 6235 8192000000 10983514832 11412889600 2005657808 19.667 100 67 134 2 2068939248 42646592 20634848
17:39:59 2872 8192000000 10980114416 11410391040 2007841504 19.685 100 72 142 1 2072276064 43309952 21124608
17:40:09 2176 8192000000 10996190384 11421741056 2013651664 19.730 100 72 144 0 2079905728 44717792 21536272
17:40:20 1810 8192000000 10989716192 11404623872 1999152768 19.616 99 89 177 1 2070055088 43845440 27056880
17:40:30 1813 8192000000 11000555984 11419963392 2013364224 19.728 100 89 174 1 2083885936 43983840 26537872
17:40:39 1197 8192000000 10996784192 11414601728 2005610352 19.667 100 94 189 0 2083583888 49225584 28747952
17:40:47 3423 8192000000 10992781968 11409375232 1989720608 19.542 99 89 178 1 2061649056 45174816 26753632
17:40:57 1808 8192000000 10969402368 11384406016 1974406752 19.420 99 84 166 0 2045254368 45228848 25618768
17:41:06 6726 8192000000 10987608768 11404984320 1978315568 19.451 99 85 170 1 2051438544 47586432 25536544
17:41:22 964 8192000000 10986828256 11404410880 1995346832 19.586 100 84 169 1 2070524960 50046176 25131952
17:41:30 2761 8192000000 10987005104 11403878400 1995780800 19.589 100 77 152 0 2068778368 48805216 24192352
17:41:39 2915 8192000000 10977117760 11397525504 1988103552 19.529 100 81 162 2 2060772224 47914848 24753824
17:41:49 3683 8192000000 10938833328 11358171136 1953490928 19.254 99 75 149 1 2024829472 48463184 22875360
17:42:01 2180 8192000000 10954623600 11367825408 1936754016 19.121 98 86 169 1 2012841344 49973312 26114016
17:42:11 6653 8192000000 10957013184 11371405312 1960512112 19.310 100 81 159 2 2036085488 51414672 24158704
17:42:26 1154 8192000000 10975668944 11384692736 1958621136 19.295 99 87 174 1 2038573376 52796400 27155840
17:42:34 6289 8192000000 10965346288 11390943232 1973736720 19.415 100 71 140 2 2049121040 52154720 23229600
17:42:48 4606 8192000000 10956172432 11382669312 1962297872 19.324 99 81 162 0 2037165680 49988032 24879776
17:43:00 3285 8192000000 10956407968 11374981120 1956327120 19.277 99 82 163 0 2032462560 51224032 24911408
17:43:13 3132 8192000000 10960562032 11384958976 1971248672 19.395 100 67 133 2 2042921296 50417392 21255232
17:43:24 1754 8192000000 10957604000 11375259648 1963280384 19.332 100 71 142 1 2036141744 50469904 22391456
17:43:32 4310 8192000000 10963214528 11385049088 1974472448 19.421 100 78 156 2 2050061872 50762720 24826704
17:43:44 4693 8192000000 10957866960 11388563456 1975763328 19.431 100 62 123 2 2047306624 52378336 19164960
17:43:57 9102 8192000000 10945724992 11388891136 1975221936 19.427 100 38 76 1 2035924272 47899840 12802496
17:44:14 18628 8192000000 10937029552 11383934976 1957265504 19.284 99 29 58 0 2010879568 44058560 9555504
17:44:43 4313 8192000000 10952768864 11378413568 1970712032 19.391 100 67 133 2 2037329776 45325536 21292208
17:44:56 2499 8192000000 10947117072 11372072960 1963085536 19.331 100 83 167 2 2039010768 49472192 26453040
17:45:07 8498 8192000000 10930934624 11369463808 1944478416 19.182 99 43 86 0 2004821600 46678736 13664448
17:45:28 4132 8192000000 10954768640 11372257280 1961370704 19.317 100 67 132 2 2029817936 47495024 20952208
17:45:42 3024 8192000000 10944826096 11356463104 1947130080 19.204 100 74 145 2 2019388992 49452272 22806640
17:45:52 2996 8192000000 10952747232 11359817728 1959112000 19.299 100 84 166 0 2030491168 45079328 26299840
17:46:04 1784 8192000000 10937814944 11358257152 1952338736 19.245 100 68 136 0 2021927776 48629248 20959792
17:46:13 3792 8192000000 10970415168 11383181312 1973309312 19.412 100 79 155 1 2046729056 49561920 23857824
17:46:26 2824 8192000000 10957480608 11369209856 1955350048 19.269 99 82 162 2 2029081056 49143728 24587280
17:46:43 8631 8192000000 10946622576 11383472128 1967959088 19.369 100 51 102 2 2034556928 49850848 16746992
17:47:00 3558 8192000000 10949120352 11380064256 1968044784 19.370 100 54 105 1 2033732976 48900272 16787920
17:47:11 9223 8192000000 10961540000 11391803392 1976060560 19.433 100 54 108 1 2048475360 54371168 18043632
17:47:30 2066 8192000000 10982244208 11402489856 1985053424 19.505 100 75 147 0 2060942240 52345728 23543088
17:47:44 2096 8192000000 10992992992 11413209088 1992403696 19.563 100 81 157 3 2073323760 55224496 25695568
17:47:54 9745 8192000000 10963127008 11414253568 1989073856 19.536 100 53 106 2 2061960048 55543888 17342304
17:48:15 17210 8192000000 10957110240 11406786560 1966907888 19.361 99 35 67 1 2032166032 52995776 12262368
17:48:46 14858 8192000000 10972577520 11415023616 1989799680 19.542 100 42 84 0 2056495280 51846464 14849136
17:49:08 10984 8192000000 10948993840 11394359296 1972251152 19.403 100 39 78 0 2037823792 51838928 13733712
17:49:27 11500 8192000000 10949247008 11384672256 1946372272 19.198 99 42 84 2 2019947536 58504560 15070704
17:49:47 17283 8192000000 10933831328 11384733696 1961665120 19.319 100 33 67 1 2026319552 52752896 11901536
17:50:31 10099 8192000000 10938112064 11376234496 1954999120 19.266 100 42 83 1 2021705552 52512000 14194432
17:50:49 22672 8192000000 10912891024 11360149504 1928678320 19.056 99 35 70 1 1985313296 45250368 11384608
17:51:20 28188 8192000000 10910228448 11360792576 1931386816 19.078 99 28 56 0 1976650336 36070064 9193456
17:52:25 30675 8192000000 10886222944 11332210688 1894342384 18.781 98 25 50 1 1936276320 33419280 8514656
17:53:02 35417 8192000000 10892801488 11353112576 1934105472 19.100 100 22 44 0 1982724272 40717104 7901696
17:53:59 31801 8192000000 10880317616 11357757440 1923675200 19.016 99 15 30 1 1956536864 28126368 4735296
17:54:45 50840 8192000000 10876010992 11318657024 1874021616 18.617 97 19 38 1 1905383200 25533216 5828368
17:55:43 34804 8192000000 10905556800 11336704000 1942238448 19.165 100 39 78 1 1963111792 10195760 10677584
17:56:58 92866 8192000000 10869791104 11331588096 1896544016 18.798 97 22 44 2 1916255840 13521088 6190736
17:58:37 44503 8192000000 10879720464 11341025280 1949008480 19.219 100 15 30 0 1971164464 18412448 3743536
17:59:57 63784 8192000000 10862874880 11322671104 1922276800 19.005 99 11 22 1 1932866448 7848816 2740832
18:01:07 22188 8192000000 10878402512 11340718080 1954365152 19.261 100 9 18 0 1967512560 10625152 2522256
18:01:36 77808 8192000000 10887511024 11353165824 1924225792 19.021 98 18 35 1 1943424880 14560640 4638448
18:03:05 159345 8192000000 10878742848 11340722176 1914253072 18.941 98 15 30 3 1933863664 15408912 4201680
18:05:54 38160 8192000000 10856714752 11324854272 1929649056 19.064 99 21 41 0 1943443776 8016160 5778560
18:06:50 38886 8192000000 10879354928 11340533760 1958791392 19.296 100 17 34 1 1970321312 6718144 4811776
18:08:59 36842 8192000000 10910650656 11381669888 1988544928 19.532 100 37 75 0 2011314736 11904592 10865216
18:09:43 31107 8192000000 10905674800 11374415872 1971465184 19.397 99 20 40 0 1994000816 16353232 6182400
18:10:25 29578 8192000000 10948986000 11389153280 1994028752 19.576 100 42 84 3 2020426352 13478000 12919600
18:11:05 85099 8192000000 10902626240 11398463488 1970986384 19.393 99 14 28 1 1991986624 16907360 4092880
18:12:41 52556 8192000000 10882676896 11360821248 1959038960 19.298 99 13 26 0 1977860416 14883776 3937680
18:14:16 48457 8192000000 10898549568 11369406464 1953406464 19.254 99 10 20 1 1966328256 10271376 2650416
18:15:11 79083 8192000000 10869072128 11344224256 1858528480 18.491 94 11 22 0 1870309088 8685392 3095216
18:16:36 105829 8192000000 10907376880 11391234048 1970084752 19.386 100 22 44 2 1991867664 15193024 6589888
18:19:13 51065 8192000000 10923311616 11379941376 1962726816 19.328 99 27 54 0 1981276304 11025360 7524128
18:20:16 58090 8192000000 10911804672 11381727232 1966626848 19.359 99 33 66 0 1989417056 13639248 9150960
18:21:22 57326 8192000000 10921805520 11374120960 1965527280 19.350 99 29 59 1 1986340464 12032512 8780672
18:22:31 69990 8192000000 10915156128 11382910976 1945700400 19.192 98 38 76 2 1972732000 16271104 10760496
18:23:48 95075 8192000000 10899328704 11374465024 1919695552 18.984 97 15 30 0 1939264624 15374544 4194528
18:25:29 40947 8192000000 10899276224 11359375360 1922764304 19.009 97 16 32 0 1937986048 10637072 4584672
18:26:18 86973 8192000000 10884428544 11342544896 1833573632 18.288 93 24 48 0 1853770368 14012160 6184576
18:27:52 53767 8192000000 10887051632 11349532672 1941404272 19.158 99 31 62 1 1962458848 12048720 9005856
18:28:52 73925 8192000000 10873952896 11335221248 1912081200 18.923 98 20 40 0 1929118048 11725072 5311776
18:30:22 59265 8192000000 10860748736 11332665344 1936611920 19.120 100 18 36 0 1950913552 9512416 4789216
18:31:40 56627 8192000000 10870658480 11335512064 1907983776 18.890 97 36 71 1 1930827040 12864672 9978592
18:32:51 132962 8192000000 10864136176 11355316224 1898468320 18.814 97 9 19 0 1917398272 16646400 2283552
18:35:10 17388 8192000000 10863043120 11348635648 1942184192 19.164 100 7 13 1 1960294160 16264608 1845360
18:35:36 13487 8192000000 10868841728 11356049408 1947701520 19.208 100 12 23 1 1966752160 16032192 3018448
18:36:05 100243 8192000000 10865344672 11337568256 1868358144 18.571 95 17 34 1 1882980128 9845760 4776224
18:38:00 55234 8192000000 10877564912 11329589248 1870431152 18.588 96 20 40 1 1885525632 9357456 5737024
18:39:02 85182 8192000000 10840684912 11310710784 1843576768 18.370 95 20 40 1 1861853840 12612368 5664704
18:40:33 89132 8192000000 10866176464 11332898816 1883011312 18.689 97 15 30 1 1900648240 13107488 4529440
18:42:15 94361 8192000000 10853546240 11318210560 1848367616 18.409 95 16 32 1 1872260080 19310112 4582352
18:44:00 52142 8192000000 10865883696 11330674688 1896999584 18.802 98 24 48 0 1922832896 18760192 7073120
18:44:58 106583 8192000000 10864640512 11325882368 1845590896 18.386 95 16 32 0 1865275168 15449632 4234640
18:46:53 185480 8192000000 10860694464 11346956288 1862383088 18.523 96 12 24 1 1888484512 22682368 3419056
18:50:22 92835 8192000000 10861163056 11332014080 1885765600 18.712 97 26 52 2 1904938176 12168544 7004032
18:52:03 14706 8192000000 10852061264 11331043328 1934618976 19.104 100 22 42 0 1953177504 12461808 6096720
18:52:26 36577 8192000000 10859536480 11329904640 1919029440 18.979 99 12 24 0 1933994480 11870960 3094080
18:53:15 48735 8192000000 10828048544 11304423424 1861259808 18.513 96 9 18 0 1873990672 10102960 2627904
18:54:10 25404 8192000000 10834451280 11310465024 1920464960 18.991 100 4 8 0 1931917280 10422784 1029536
18:54:43 89002 8192000000 10867656112 11340394496 1939642208 19.144 100 16 32 1 1953506528 9353504 4510816
18:56:48 103381 8192000000 10881071616 11350966272 1937519808 19.127 99 19 38 2 1956690048 13742560 5427680
18:58:52 46790 8192000000 10887043680 11371085824 1963241744 19.332 100 13 24 0 1985852016 19065232 3545040
18:59:54 55785 8192000000 10890969152 11368087552 1972109552 19.402 100 17 34 0 1986947536 10325840 4512144
19:01:26 91208 8192000000 10898766128 11369873408 1862798240 18.526 94 12 24 0 1876507872 10198592 3511040
19:03:06 55648 8192000000 10881199984 11371147264 1944442464 19.182 99 25 49 0 1961846016 9916112 7487440
19:04:09 72393 8192000000 10892201584 11370774528 1950254496 19.229 99 9 18 0 1962205200 9616080 2334624
19:06:19 49562 8192000000 10905726064 11382673408 1961713408 19.320 99 43 86 0 1989703424 15457472 12532544
19:07:24 85175 8192000000 10890539392 11376070656 1908607728 18.895 97 18 36 1 1942480000 28538944 5333328
19:08:55 72722 8192000000 10884755552 11367297024 1952668512 19.248 99 15 30 2 1967758096 11132912 3956672
19:10:14 106074 8192000000 10927005216 11378958336 1917853584 18.970 97 17 34 1 1932585008 10041472 4689952
19:12:07 55450 8192000000 10905713904 11361185792 1918898816 18.978 97 28 55 2 1936614320 9801120 7914384
19:13:09 46922 8192000000 10927830608 11392856064 1974789008 19.423 100 37 74 1 2002817824 18168464 9860352
19:14:03 94597 8192000000 10907390208 11380092928 1937596416 19.128 98 15 30 0 1956565712 14644112 4325184
19:15:43 69291 8192000000 10894686432 11351904256 1894992784 18.786 96 34 68 0 1919562016 15031328 9537904
19:16:59 53545 8192000000 10906832960 11382706176 1963342480 19.333 100 22 43 1 1985297024 16090528 5864016
19:17:59 51046 8192000000 10893619104 11374411776 1970286080 19.388 100 10 20 0 1988820496 15260624 3273792
19:18:58 90339 8192000000 10904044864 11388329984 1977910352 19.448 100 14 28 0 1995157664 13038384 4208928
19:20:42 59989 8192000000 10886613360 11366821888 1915342576 18.950 97 13 26 0 1936462048 16761136 4358336
19:21:50 61105 8192000000 10882129504 11371163648 1920614128 18.992 98 13 25 1 1940309552 15812992 3882432
19:23:03 59310 8192000000 10876382624 11356086272 1909143600 18.900 97 14 26 2 1923720096 10825408 3751088
19:24:09 56216 8192000000 10906659344 11361452032 1950472144 19.230 99 18 36 0 1964311360 8759344 5079872
19:25:14 55594 8192000000 10882448464 11353006080 1891624832 18.759 96 28 56 0 1908741168 9317376 7798960
19:26:34 52833 8192000000 9726601792 10072989696 833895936 9.238 43 9 18 0 844621968 8123984 2602048

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 06-03-2021 19:28:50 to 06-03-2021 19:29:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 146 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-03-2021 19:29:22 to 06-03-2021 19:29:24.

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          237310
MON$OLDEST_ACTIVE               240028
MON$OLDEST_SNAPSHOT             240028
MON$NEXT_TRANSACTION            240028
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                       2018368
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 ---
--- end of diff output ---

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

06.03.21 19:29:25. 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-06 19:29:27 No severe PSQL-related problems occured
06.03.21 19:29:29. End of report.