Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.06.2021 16: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 58e1ddde69c44dad93d327777e5becec
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-05-09 08:45
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 4793.92
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 17411880 kB
MemAvailable 31379376 kB
Buffers 0 kB
Cached 14231844 kB
SwapCached 32 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-06-14 16:27:39
DTS_END                         2021-06-14 16:27:39.3690
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/44388
TRN_ID                          247533
ATT_ID                          717
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: 9066.53 22116 1087983
customer order: creation 181.06 365 21727
customer order: refuse 15.47 355 1856
order to supplier: creation 49.78 1315 5974
order to supplier: removal 3.48 89055 418
invoice (draft): creation 47.06 3452 5647
invoice (draft): removal 50.15 799 6018
invoice accept: apply 43.53 17053 5224
invoice accept: cancel 44.93 743 5392
customer reserve: creation 3971.38 170 476565
customer reserve: removal 4349.79 55 521975
realization accept: apply 89.28 172 10714
realization accept: cancel 81.71 109 9805
payment from customer: creation 63.79 113 7655
payment from customer: removal 5.75 63 690
payment to supplier: creation 52.72 120 6326
payment to supplier: removal 3.58 61 430
service: total inventory turnovers 4.85 1099 582
service: total monetary turnovers 7.27 24 872
service: aggregate perf. data 0.91 21282 109
service: refresh index statistics 0.03 305905 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-06-2021 16:28:32 to 14-06-2021 16:28:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5718
TEST_TIME 2 4173
TEST_TIME 3 4810
TEST_TIME 4 5138
TEST_TIME 5 5035
TEST_TIME 6 5147
TEST_TIME 7 5384
TEST_TIME 8 5250
TEST_TIME 9 5869
TEST_TIME 10 6088
TEST_TIME 11 6250
TEST_TIME 12 6553
TEST_TIME 13 6996
TEST_TIME 14 7186
TEST_TIME 15 7264
TEST_TIME 16 7461
TEST_TIME 17 7729
TEST_TIME 18 7760
TEST_TIME 19 8263
TEST_TIME 20 8547
TEST_TIME 21 8722
TEST_TIME 22 9027
TEST_TIME 23 9096
TEST_TIME 24 9178
TEST_TIME 25 9681
TEST_TIME 26 9601
TEST_TIME 27 10311
TEST_TIME 28 10674
TEST_TIME 29 10502
TEST_TIME 30 10161
TEST_TIME 31 10192
TEST_TIME 32 10033
TEST_TIME 33 9901
TEST_TIME 34 9798
TEST_TIME 35 9699
TEST_TIME 36 9630
TEST_TIME 37 9459
TEST_TIME 38 9321
TEST_TIME 39 9515
TEST_TIME 40 9411
TEST_TIME 41 9424
TEST_TIME 42 9366
TEST_TIME 43 9210
TEST_TIME 44 9171
TEST_TIME 45 9088
TEST_TIME 46 9022
TEST_TIME 47 8965
TEST_TIME 48 8870
TEST_TIME 49 8936
TEST_TIME 50 9067
TEST_TIME 51 9032
TEST_TIME 52 9178
TEST_TIME 53 9131
TEST_TIME 54 9224
TEST_TIME 55 9317
TEST_TIME 56 9312
TEST_TIME 57 9314
TEST_TIME 58 9340
TEST_TIME 59 9315
TEST_TIME 60 9316
TEST_TIME 61 9345
TEST_TIME 62 9220
TEST_TIME 63 9164
TEST_TIME 64 9147
TEST_TIME 65 9062
TEST_TIME 66 8991
TEST_TIME 67 9067
TEST_TIME 68 9052
TEST_TIME 69 9031
TEST_TIME 70 9101
TEST_TIME 71 9125
TEST_TIME 72 9090
TEST_TIME 73 9051
TEST_TIME 74 9070
TEST_TIME 75 9189
TEST_TIME 76 9213
TEST_TIME 77 9237
TEST_TIME 78 9192
TEST_TIME 79 9323
TEST_TIME 80 9322
TEST_TIME 81 9361
TEST_TIME 82 9259
TEST_TIME 83 9223
TEST_TIME 84 9170
TEST_TIME 85 9154
TEST_TIME 86 9117
TEST_TIME 87 9089
TEST_TIME 88 9030
TEST_TIME 89 8972
TEST_TIME 90 9021
TEST_TIME 91 9016
TEST_TIME 92 9116
TEST_TIME 93 9111
TEST_TIME 94 9111
TEST_TIME 95 9139
TEST_TIME 96 9164
TEST_TIME 97 9123
TEST_TIME 98 9244
TEST_TIME 99 9227
TEST_TIME 100 9240
TEST_TIME 101 9269
TEST_TIME 102 9251
TEST_TIME 103 9292
TEST_TIME 104 9285
TEST_TIME 105 9249
TEST_TIME 106 9190
TEST_TIME 107 9142
TEST_TIME 108 9152
TEST_TIME 109 9108
TEST_TIME 110 9071
TEST_TIME 111 9043
TEST_TIME 112 9016
TEST_TIME 113 9047
TEST_TIME 114 9070
TEST_TIME 115 9062
TEST_TIME 116 9060
TEST_TIME 117 9108
TEST_TIME 118 9110
TEST_TIME 119 9079
TEST_TIME 120 9069

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-06-2021 16:28:36 to 14-06-2021 16:28:39.

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 1528658 1528658 0 0.00 0 14170 6 0 0
doc_list_biud 1528658 1528658 0 0.00 0 36247 25 0 0
sp_add_invoice_to_stock 5416 5224 192 3.54 25 235696 17053 0 192
sp_cancel_adding_invoice 5392 5392 0 0.00 5 50814 743 0 0
sp_cancel_client_order 1856 1856 0 0.00 4 8530 355 0 0
sp_cancel_customer_reserve 521975 521975 0 0.00 1 19723 56 0 0
sp_cancel_pay_from_customer 690 690 0 0.00 3 1718 64 0 0
sp_cancel_pay_to_supplier 430 430 0 0.00 2 2893 62 0 0
sp_cancel_supplier_invoice 6040 6018 22 0.36 2 36259 799 0 22
sp_cancel_supplier_order 418 418 0 0.00 9 1013097 89056 0 0
sp_cancel_write_off 9805 9805 0 0.00 1 8506 110 0 0
sp_client_order 21727 21727 0 0.00 3 24862 366 0 0
sp_customer_reserve 476565 476565 0 0.00 0 49909 170 0 0
sp_fill_shopping_cart 33322 33322 0 0.00 1 13375 38 0 0
sp_fill_shopping_cart_clo_res 476549 476549 0 0.00 0 21523 15 0 0
sp_get_clo_for_invoice 5208 5208 0 0.00 0 22174 333 0 0
sp_kill_cost_storno 16317 16317 0 0.00 0 7875 53 0 0
sp_kill_qstorno_ret_qs2qd 1060191 1060191 0 0.00 0 36243 31 0 0
sp_kill_qty_storno 561386 561386 0 0.00 0 36245 67 0 0
sp_lock_selected_doc 22016 22016 0 0.00 0 11054 4 0 0
sp_make_cost_storno 29903 29903 0 0.00 0 10338 45 0 0
sp_multiply_rows_for_pdistr 29903 29903 0 0.00 0 8923 27 0 0
sp_multiply_rows_for_qdistr 21727 21727 0 0.00 0 24780 178 0 0
sp_pay_from_customer 7655 7655 0 0.00 4 13457 113 0 0
sp_pay_to_supplier 6326 6326 0 0.00 5 13255 121 0 0
sp_payment_common 13981 13981 0 0.00 1 13005 28 0 0
sp_qd_handle_on_cancel_clo 1856 1856 0 0.00 0 8519 330 0 0
sp_qd_handle_on_invoice_upd_sts 10600 10600 0 0.00 0 19776 314 0 0
sp_qd_handle_on_reserve_upd_sts 10714 10714 0 0.00 0 11799 67 0 0
sp_reserve_write_off 10714 10714 0 0.00 6 13362 172 0 0
sp_supplier_invoice 5647 5647 0 0.00 5 90486 3452 0 0
sp_supplier_order 5974 5974 0 0.00 5 29354 1315 0 0
srv_aggregate_perf_data 109 109 0 0.00 2351 410190 21283 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1199 139483 32437 0 0
srv_find_qd_qs_mism 1037491 1037491 0 0.00 0 14155 5 0 0
srv_make_invnt_saldo 582 582 0 0.00 35 65666 1100 0 0
srv_make_money_saldo 872 872 0 0.00 0 1061 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 205551 477164 305906 0 0
t$perf-abend:sp_add_invoice_to_stock 192 192 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 22 22 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5224 5224 0 0.00 0 8937 145 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 0 2497 65 0 0
t$perf-norm:sp_cancel_client_order 1856 1856 0 0.00 0 3172 12 0 0
t$perf-norm:sp_cancel_customer_reserve 742 742 0 0.00 0 4051 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 690 690 0 0.00 0 1699 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 430 430 0 0.00 0 815 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 2265 16 0 0
t$perf-norm:sp_cancel_supplier_order 418 418 0 0.00 0 23642 1343 0 0
t$perf-norm:sp_cancel_write_off 1096 1096 0 0.00 0 868 4 0 0
t$perf-norm:sp_client_order 21727 21727 0 0.00 0 9792 14 0 0
t$perf-norm:sp_customer_reserve 1030 1030 0 0.00 0 856 5 0 0
t$perf-norm:sp_pay_from_customer 7655 7655 0 0.00 0 5248 8 0 0
t$perf-norm:sp_pay_to_supplier 6326 6326 0 0.00 0 4519 9 0 0
t$perf-norm:sp_reserve_write_off 10714 10714 0 0.00 0 6468 11 0 0
t$perf-norm:sp_supplier_invoice 5647 5647 0 0.00 0 6980 15 0 0
t$perf-norm:sp_supplier_order 5974 5974 0 0.00 0 6404 16 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 267 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 117 2 0 0
t$perf-norm:srv_make_invnt_saldo 582 582 0 0.00 0 1143 23 0 0
t$perf-norm:srv_make_money_saldo 872 872 0 0.00 0 4002 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10800 10416 384 3.55 0 4149 16 0 384
v_all_customers 39432 39432 0 0.00 0 17 1 0 0
v_all_suppliers 32256 32256 0 0.00 0 30 1 0 0
v_all_wares 43454 43454 0 0.00 0 205 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 225 6 0 0
v_cancel_client_order 3712 3712 0 0.00 0 1718 3 0 0
v_cancel_customer_prepayment 1380 1380 0 0.00 0 1587 4 0 0
v_cancel_customer_reserve 1484 1484 0 0.00 0 218 3 0 0
v_cancel_payment_to_supplier 860 860 0 0.00 0 690 4 0 0
v_cancel_supplier_invoice 912 868 44 4.82 0 4152 23 0 44
v_cancel_supplier_order 836 836 0 0.00 0 1448 6 0 0
v_cancel_write_off 2192 2192 0 0.00 0 2541 14 0 0
v_max_id_clo_ord 5974 5974 0 0.00 0 743 1 0 0
v_max_id_clo_res 1030 1030 0 0.00 0 2632 14 0 0
v_max_id_ord_sup 5621 5621 0 0.00 0 7210 7 0 0
v_max_non_paid_invoice 1792 1792 0 0.00 0 201 2 0 0
v_max_non_paid_realizn 4178 4178 0 0.00 0 2756 5 0 0
v_min_id_clo_ord 5974 5974 0 0.00 0 3608 5 0 0
v_min_id_clo_res 1030 1030 0 0.00 0 8020 15 0 0
v_min_id_ord_sup 5620 5620 0 0.00 0 8927 8 0 0
v_min_non_paid_invoice 6326 6326 0 0.00 0 7877 19 0 0
v_min_non_paid_realizn 7655 7655 0 0.00 0 12999 20 0 0
v_our_firm 10976 10976 0 0.00 0 21 1 0 0
v_reserve_write_off 21428 21428 0 0.00 0 2876 4 0 0
x_lock_depdocs_on_canc_invoice 10976 10976 0 0.00 0 19738 114 0 0
x_lock_depdocs_on_canc_sup_ord 418 418 0 0.00 0 3064 286 0 0
x_make_qstorno_1000_1200 5974 5974 0 0.00 1 29310 1238 0 0
x_make_qstorno_1200_2000 5647 5647 0 0.00 2 90478 3304 0 0
x_make_qstorno_2100_3300 476565 476565 0 0.00 0 49900 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-06-2021 16:28:40 to 14-06-2021 16:28:44.

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
13:57:42 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
13:57:49 16288 8192000000 10251741552 10557902848 833293312 9.232 66 50 102 0 852144672 2374544 16476816
13:58:12 31745 8192000000 10319308304 10636963840 1372382560 14.348 100 88 176 1 1406309936 4663968 29263408
13:59:02 16362 8192000000 10367426960 10689781760 1425598560 14.822 100 82 164 0 1458269536 5701792 26969184
13:59:28 20135 8192000000 10393914080 10718613504 1452654832 15.061 100 91 182 0 1488869120 6737456 29476832
14:00:02 24773 8192000000 10417691328 10748821504 1474374144 15.252 100 85 170 1 1509158144 7542592 27241408
14:00:38 13748 8192000000 10429786784 10762420224 1488704480 15.378 100 87 174 0 1524559744 7885248 27970016
14:01:14 18725 8192000000 10455698432 10794729472 1518914928 15.641 100 84 168 0 1554130080 8591088 26624064
14:01:44 14163 8192000000 10479841360 10823090176 1538385824 15.810 100 81 162 1 1572575408 8966784 25222800
14:02:13 10552 8192000000 10505945360 10857091072 1568035792 16.065 100 69 138 0 1598939312 9492592 21410928
14:02:31 13461 8192000000 10537520368 10893234176 1602099792 16.357 100 81 160 2 1636410224 9950320 24360112
14:02:52 15370 8192000000 10565228544 10922479616 1622050368 16.527 100 79 158 0 1656193840 10823888 23319584
14:03:17 14039 8192000000 10591266336 10951749632 1649174352 16.757 100 83 166 0 1684850528 11336624 24339552
14:03:39 8886 8192000000 10624776624 10987520000 1676299040 16.986 100 82 165 0 1712528768 11889456 24340272
14:03:58 12421 8192000000 10628932432 10995408896 1689198928 17.095 100 78 155 1 1723942928 12404240 22339760
14:04:18 8853 8192000000 10637805856 11011096576 1697996608 17.168 100 72 142 3 1731272928 12717456 20558864
14:04:35 5995 8192000000 10651562608 11025305600 1715808144 17.317 100 76 151 0 1749855616 12533744 21513728
14:04:49 7766 8192000000 10660886064 11034673152 1725902544 17.401 100 77 153 1 1761009712 12782016 22325152
14:05:04 7559 8192000000 10674219408 11050545152 1737174096 17.495 100 77 154 3 1773109920 13809936 22125888
14:05:18 6306 8192000000 10684318640 11062022144 1750022320 17.602 100 80 161 1 1785064336 12958256 22083760
14:05:34 9426 8192000000 10692822704 11073359872 1762371728 17.704 100 81 162 1 1798578848 13307792 22899328
14:05:51 4129 8192000000 10716137744 11093360640 1772908768 17.791 100 79 155 1 1806881568 12394320 21578480
14:06:01 4788 8192000000 10705413184 11091038208 1777590912 17.830 100 68 134 1 1809063024 13124880 18347232
14:06:14 4995 8192000000 10712815248 11096219648 1786467584 17.903 100 79 156 2 1820728640 12873632 21387424
14:06:26 4416 8192000000 10728013488 11106783232 1790952304 17.940 100 80 156 2 1824658208 12174704 21531200
14:06:37 9795 8192000000 10736353936 11125780480 1804357072 18.050 100 76 151 1 1838730336 12653488 21719776
14:06:53 6851 8192000000 10747295056 11134058496 1805757216 18.061 100 76 151 2 1840479360 12977120 21745024
14:07:07 1942 8192000000 10757199904 11150356480 1821263520 18.188 100 82 164 0 1858088400 13375584 23449296
14:07:18 2760 8192000000 10764916592 11153911808 1830180416 18.261 100 73 147 2 1862923184 12000400 20742368
14:07:27 3239 8192000000 10768201696 11158515712 1833794048 18.290 100 81 162 1 1869281360 12143488 23343824
14:07:37 2806 8192000000 10782150464 11169939456 1839680000 18.338 100 88 174 3 1876325712 12568864 24076848
14:07:47 1283 8192000000 10785817680 11174920192 1845783152 18.388 100 89 178 4 1882350656 11663632 24903872
14:07:55 1832 8192000000 10801062256 11184656384 1849629712 18.419 100 91 178 2 1887658720 12643808 25385200
14:08:04 1728 8192000000 10800219856 11186274304 1855316288 18.465 100 90 181 1 1894368800 13671840 25380672
14:08:12 1442 8192000000 10807137808 11192803328 1865547024 18.548 100 92 184 0 1904459968 13993888 24919056
14:08:20 1954 8192000000 10796782656 11188572160 1857809728 18.486 100 88 176 3 1895909040 13609776 24489536
14:08:29 2698 8192000000 10816192784 11200565248 1865271488 18.546 100 90 180 1 1904017008 13998240 24747280
14:08:38 1716 8192000000 10816857792 11203563520 1870603904 18.589 100 91 184 2 1911927424 15288592 26034928
14:08:47 1513 8192000000 10818087632 11208318976 1867701792 18.566 100 90 180 1 1908588272 15773968 25112512
14:08:54 1338 8192000000 10814607936 11203121152 1871727840 18.598 100 93 186 1 1912002208 13932720 26341648
14:09:02 1615 8192000000 10818888080 11209052160 1873234704 18.610 100 91 182 0 1913636592 12999296 27402592
14:09:10 33503 8192000000 10795150128 11204444160 1870591024 18.589 100 60 115 2 1895832176 6789360 18451792
14:09:51 18127 8192000000 10802332592 11207385088 1871828640 18.599 100 62 122 2 1896168752 7141824 17198288
14:10:15 1552 8192000000 10821321152 11217641472 1881043296 18.674 100 83 166 1 1915001744 10385584 23572864
14:10:23 11110 8192000000 10800010352 11213348864 1875371744 18.628 100 48 96 1 1899449216 11103680 12973792
14:10:42 6689 8192000000 10801982768 11218997248 1875728832 18.631 100 34 68 1 1897018608 12284928 9004848
14:10:56 3606 8192000000 10799612688 11217883136 1880234832 18.667 100 58 116 1 1905226720 8535024 16456864
14:11:07 7112 8192000000 10783496432 11214561280 1873007968 18.609 100 21 42 1 1889269488 10832800 5428720
14:11:20 6581 8192000000 10789682272 11216896000 1876557216 18.637 100 31 62 0 1892346384 7167440 8621728
14:11:34 5955 8192000000 10779291248 11211022336 1876038000 18.633 100 28 56 1 1889679664 5543136 8098528
14:11:48 5463 8192000000 10783304048 11214815232 1877369376 18.644 100 27 55 0 1891752752 6215344 8168032
14:12:02 5111 8192000000 10795045472 11220058112 1880877168 18.672 100 30 61 0 1895930304 7065392 7987744
14:12:15 11325 8192000000 10781467392 11220271104 1883351184 18.692 100 21 42 0 1895530208 5899040 6279984
14:12:33 3873 8192000000 10791129328 11224694784 1887104752 18.722 100 31 61 3 1902349824 5495344 9749728
14:12:45 12137 8192000000 10792674000 11228561408 1886217488 18.715 100 26 50 2 1900510064 6079328 8213248
14:13:03 7871 8192000000 10792376896 11227508736 1886537216 18.718 100 15 30 2 1896093328 5499904 4056208
14:13:27 15229 8192000000 10801940640 11235676160 1893214688 18.772 100 19 37 0 1904695744 6369264 5111792
14:13:49 13096 8192000000 10825570832 11240501248 1894938080 18.786 100 22 44 0 1906460128 4623808 6898240
14:14:10 70097 8192000000 10856420032 11261321216 1906102832 18.875 100 52 105 5 1927045936 5972352 14970752
14:15:26 5723 8192000000 10830554848 11265925120 1908388336 18.894 100 34 68 0 1930564608 12264944 9911328
14:15:38 5585 8192000000 10820684896 11253514240 1889654608 18.743 99 17 34 0 1900808544 6008720 5145216
14:15:49 6082 8192000000 10834743584 11267526656 1913239440 18.933 100 36 70 1 1930843280 7016016 10587824
14:16:04 4698 8192000000 10833993968 11265708032 1914251456 18.941 100 38 76 1 1933409296 8241520 10916320
14:16:17 4996 8192000000 10814622896 11242995712 1874452656 18.620 98 33 66 2 1890779008 6430560 9895792
14:16:29 4147 8192000000 10827266480 11254902784 1904842880 18.865 100 26 52 2 1917521872 5761680 6917312
14:16:40 5962 8192000000 10817637216 11252776960 1904491792 18.862 100 40 81 0 1922849168 7237520 11119856
14:16:53 8321 8192000000 10804834288 11246620672 1887465360 18.725 99 23 46 1 1900295696 5857648 6972688
14:17:08 7899 8192000000 10811424704 11237888000 1884786192 18.704 99 16 32 0 1894904224 5361664 4756368
14:17:22 10119 8192000000 10797000672 11227127808 1855045216 18.463 98 11 22 0 1863741200 5747312 2948672
14:17:39 9372 8192000000 10795497728 11229659136 1857542208 18.483 98 24 48 4 1870397552 5220976 7634368
14:17:54 60955 8192000000 10755242832 11190173696 1754133296 17.636 93 27 54 1 1767743328 5137072 8472960
14:19:02 9509 8192000000 10760497088 11192832000 1825227744 18.220 98 25 50 0 1839027344 6726144 7073456
14:19:17 6861 8192000000 10755490352 11179384832 1797718800 17.995 96 32 64 1 1813113008 6291408 9102800
14:19:31 3145 8192000000 10742975840 11163222016 1775706080 17.814 96 21 42 0 1788409856 6794560 5909216
14:19:40 5903 8192000000 10745113728 11158618112 1791901376 17.947 98 31 62 3 1805889296 4862224 9125696
14:19:56 4685 8192000000 10750137888 11161001984 1779976816 17.849 97 32 62 4 1796458240 6834176 9647248
14:20:08 8116 8192000000 10712912256 11132153856 1752022928 17.618 96 20 40 3 1763776480 5546944 6206608
14:20:24 7379 8192000000 10724488528 11139112960 1784340368 17.885 98 23 46 1 1796432528 5705744 6386416
14:20:38 8579 8192000000 10719817744 11140395008 1779646608 17.847 98 29 58 2 1794229040 6713248 7869184
14:20:55 7189 8192000000 10683079008 11098558464 1727753584 17.417 97 29 58 1 1741842784 5644880 8444320
14:21:09 5231 8192000000 10693924848 11103649792 1745775088 17.567 97 35 70 0 1760860576 4627680 10457808
14:21:22 9579 8192000000 10696119440 11103633408 1717519952 17.332 96 18 36 0 1728249120 5492720 5236448
14:21:38 6964 8192000000 10709835472 11131822080 1796795056 17.988 100 19 39 1 1807761600 5891088 5075456
14:21:56 9781 8192000000 10733018864 11151179776 1776554592 17.821 98 20 40 1 1789026240 5730240 6741408
14:22:13 67503 8192000000 10703043472 11127910400 1747477072 17.581 96 40 78 0 1764533552 5204464 11852016
14:23:30 10215 8192000000 10732028480 11151167488 1804190304 18.048 99 27 53 1 1817259040 5764656 7304080
14:23:49 6471 8192000000 10746178560 11163770880 1826236272 18.229 100 29 57 0 1839856160 6359312 7260576
14:24:02 11909 8192000000 10753760208 11172175872 1835037504 18.300 100 29 58 1 1850280432 6432656 8810272
14:24:20 7275 8192000000 10747576272 11175763968 1838643664 18.330 100 21 40 1 1850136560 5417008 6075888
14:24:34 8013 8192000000 10764816240 11183796224 1842240528 18.359 100 23 45 2 1855072256 6817536 6014192
14:24:55 7177 8192000000 10769033168 11189739520 1848067472 18.406 100 16 30 3 1857822512 5281712 4473328
14:25:11 8531 8192000000 10771065024 11198554112 1855452528 18.466 100 31 62 3 1870789184 5857344 9479312
14:25:34 7279 8192000000 10773431856 11200192512 1857583792 18.484 100 24 48 0 1870189136 5448304 7157040
14:25:48 9159 8192000000 10775806656 11203407872 1860043488 18.504 100 14 28 1 1869834672 5649152 4142032
14:26:05 9639 8192000000 10772776032 11207716864 1863574480 18.532 100 18 36 1 1875171488 6290640 5306368
14:26:23 10028 8192000000 10773681504 11209285632 1867727968 18.566 100 17 34 1 1878769952 5653856 5388128
14:26:40 10659 8192000000 10771341184 11209691136 1868712224 18.574 100 14 27 2 1878120288 5300720 4107344
14:26:57 57682 8192000000 10832424560 11242823680 1884553712 18.702 100 48 95 0 1904827232 4985088 15288432
14:28:00 18575 8192000000 10829292624 11253915648 1905059104 18.867 100 22 45 0 1915958368 4612672 6286592
14:29:16 9309 8192000000 10846412352 11273895936 1926371248 19.038 100 37 72 1 1943646528 6925872 10349408
14:29:33 21652 8192000000 10862280704 11291045888 1936872208 19.122 100 46 92 0 1958007072 8262240 12872624
14:30:03 10912 8192000000 10878599648 11303473152 1945136672 19.188 100 56 110 2 1969392560 8724448 15531440
14:30:28 9996 8192000000 10886884528 11311239168 1953812384 19.257 100 59 116 3 1981992032 11760448 16419200
14:30:45 53609 8192000000 10885733440 11328057344 1956224864 19.276 100 39 78 1 1978056560 10884464 10947232
14:31:48 55440 8192000000 10876998720 11322023936 1942582784 19.167 99 30 60 0 1965074000 13674528 8816688
14:33:07 6902 8192000000 10902637936 11335933952 1953005520 19.250 99 49 98 1 1981762848 13099104 15658224
14:33:22 12462 8192000000 10911720912 11342114816 1971749392 19.399 100 53 104 2 2002064640 14822528 15492720
14:33:45 10950 8192000000 10920601232 11351273472 1978661728 19.454 100 54 108 2 2009024944 14775376 15587840
14:34:03 1945 8192000000 10924633152 11347161088 1978826096 19.455 100 64 126 0 2013291024 15281968 19182960
14:34:15 8529 8192000000 10926815216 11356270592 1985638336 19.509 100 57 112 0 2017040896 15731120 15671440
14:34:31 8355 8192000000 10929282144 11361234944 1990544592 19.548 100 61 121 2 2023020672 15330224 17145856
14:34:47 18574 8192000000 10928197408 11364225024 1991954576 19.559 100 54 106 1 2026096192 18509344 15632272
14:35:13 10659 8192000000 10928169840 11363598336 1974104320 19.418 99 50 98 2 2008386864 19363296 14919248
14:35:34 15050 8192000000 10932744736 11358941184 1961479584 19.318 99 52 105 4 1999885088 22659424 15746080
14:35:57 18803 8192000000 10925514352 11363753984 1983080768 19.489 100 61 122 0 2023184528 21720288 18383472
14:36:26 6652 8192000000 10937104848 11369361408 1985897072 19.511 100 46 90 2 2023609136 23954240 13757824
14:36:40 4520 8192000000 10945977648 11382489088 1994269792 19.578 100 54 106 1 2033881360 23494576 16116992
14:36:55 3446 8192000000 10951666192 11384995840 1999242800 19.617 100 71 143 1 2043085152 22887952 20954400
14:37:06 8855 8192000000 10958353696 11388837888 2003767712 19.652 100 63 123 0 2046067968 23628160 18672096
14:37:25 5032 8192000000 10973166048 11400720384 2012442960 19.721 100 69 133 1 2056005856 24006816 19556080
14:37:37 11758 8192000000 10970780016 11401273344 2010730928 19.707 100 65 130 1 2053179360 23824208 18624224
14:37:58 7314 8192000000 10966809216 11398537216 2007883216 19.685 100 59 118 0 2051321680 26475024 16963440
14:38:12 10534 8192000000 10983355248 11409272832 2014278320 19.735 100 72 141 2 2063776192 27813840 21684032
14:38:34 3512 8192000000 10961552864 11396464640 2003782672 19.653 100 55 110 1 2049208304 28375408 17050224
14:38:45 3300 8192000000 10970853680 11404517376 2010925696 19.709 100 58 113 3 2058175744 29788896 17461152
14:38:57 7198 8192000000 10950966752 11383844864 1991791568 19.558 99 60 119 1 2039991088 29573824 18625696
14:39:16 8568 8192000000 10964273024 11404333056 2005298688 19.664 100 54 106 0 2051372464 29770720 16303056
14:39:37 2794 8192000000 10980156752 11410038784 2015967984 19.748 100 73 146 2 2068296352 29833824 22494544
14:39:46 3025 8192000000 11002066880 11421761536 2021415984 19.791 100 86 172 1 2079867632 32422080 26029568
14:39:56 1561 8192000000 10982209552 11396603904 1994588432 19.580 99 91 183 0 2056472176 34632000 27251744
14:40:07 2089 8192000000 10988568736 11404296192 2008004160 19.686 100 92 184 1 2071034784 34415216 28615408
14:40:15 5132 8192000000 10949020704 11373817856 1978355664 19.452 99 70 141 2 2029501968 30112080 21034224
14:40:29 5024 8192000000 10963498160 11389870080 1996751600 19.597 100 79 158 1 2051102192 30396736 23953856
14:40:46 6558 8192000000 10954887696 11379060736 1989149600 19.537 100 74 148 1 2041223040 29586928 22486512
14:41:00 21453 8192000000 10969849504 11398524928 2003471744 19.650 100 72 143 1 2059560784 34497296 21591744
14:41:36 15063 8192000000 10933564688 11374653440 1962334064 19.325 99 50 100 3 2012538800 34822816 15381920
14:42:00 4251 8192000000 10945304560 11372687360 1970611664 19.390 99 53 106 0 2016277904 29870624 15795616
14:42:12 3222 8192000000 10946957616 11373645824 1981227360 19.474 100 69 137 0 2030915616 29090512 20597744
14:42:23 7035 8192000000 10951151936 11374354432 1971023104 19.394 99 73 141 1 2022882352 31057104 20802144
14:42:38 2271 8192000000 10948588752 11365134336 1971225216 19.395 99 79 158 0 2029028768 32759840 25043712
14:42:48 2835 8192000000 10966120832 11375710208 1953296912 19.253 98 86 172 1 2013805840 33939536 26569392
14:42:58 1445 8192000000 10945940128 11359817728 1971485392 19.397 99 89 172 1 2029387024 32677184 25224448
14:43:08 3729 8192000000 10959863072 11372548096 1965375344 19.349 99 90 180 0 2026591664 33419856 27796464
14:43:23 5742 8192000000 10962592848 11384995840 1987367024 19.523 100 76 152 0 2047022720 35702064 23953632
14:43:38 3979 8192000000 10973383408 11392098304 1994104320 19.576 100 74 144 2 2052555728 35974656 22476752
14:43:49 2103 8192000000 10965533856 11380318208 1980851664 19.471 99 77 153 3 2041820384 37692736 23275984
14:44:00 5938 8192000000 10979313248 11402211328 1982858800 19.487 99 77 152 1 2045034208 38773264 23402144
14:44:14 1195 8192000000 10965439168 11387617280 1980631968 19.470 99 73 141 0 2039324224 36404960 22287296
14:44:23 3551 8192000000 10970982512 11392749568 1990158256 19.545 100 74 148 0 2051108304 37775104 23174944
14:44:33 2121 8192000000 10975414464 11395977216 1993468176 19.571 100 79 158 0 2057855136 39012672 25374288
14:44:43 1816 8192000000 10983746608 11398864896 1987234064 19.522 99 84 166 1 2050480704 38508752 24737888
14:44:52 4101 8192000000 10915593008 11326263296 1932906272 19.090 98 86 169 1 1999962832 40247312 26809248
14:45:02 2863 8192000000 10942901472 11362770944 1964056112 19.338 100 79 156 0 2027771984 39457216 24258656
14:45:17 2612 8192000000 10948366288 11366653952 1961611488 19.319 100 79 158 1 2030384288 44210640 24562160
14:45:30 4299 8192000000 10952468064 11376828416 1972384096 19.404 100 68 136 0 2039223696 45111888 21727712
14:45:42 1999 8192000000 10971386608 11386294272 1978915920 19.456 100 85 169 1 2051117344 44982288 27219136
14:45:52 3815 8192000000 10945363536 11364954112 1948466032 19.214 99 76 152 0 2018203504 46033920 23703552
14:46:06 5361 8192000000 10953224896 11375607808 1968344544 19.372 100 68 134 2 2037548704 47797296 21406864
14:46:26 1539 8192000000 10954857744 11373359104 1964717872 19.344 100 66 132 1 2034638096 49246176 20674048
14:46:38 4197 8192000000 10934172032 11357880320 1949978336 19.226 99 65 128 1 2018033504 47690752 20364416
14:46:58 4661 8192000000 10932346560 11361796096 1955628784 19.271 100 55 109 2 2017241936 43985984 17627168
14:47:10 12420 8192000000 10915994176 11355033600 1931943536 19.082 99 45 90 1 1990714144 44437456 14333152
14:47:40 15639 8192000000 10893097280 11334377472 1896978432 18.802 98 34 68 1 1960296464 51624720 11693312
14:48:11 6453 8192000000 10904749232 11326566400 1921453856 18.998 99 52 102 0 1980962320 43149312 16359152
14:48:23 8809 8192000000 10908915312 11350614016 1943348240 19.173 100 41 82 1 2000715200 44370544 12996416
14:48:42 9800 8192000000 10912343840 11347451904 1937833408 19.129 100 41 82 1 1991670672 40757520 13079744
14:49:02 17245 8192000000 10922122944 11362979840 1953347744 19.253 100 35 70 0 2006047968 40879296 11820928
14:49:33 5572 8192000000 10947060528 11374747648 1963846592 19.337 100 50 97 0 2023494304 43609424 16038288
14:49:49 19195 8192000000 10921838544 11372097536 1952840336 19.249 99 34 68 1 2001834288 37979552 11014400
14:50:20 14113 8192000000 10933222256 11383324672 1966305248 19.356 100 28 56 1 2014720320 39470128 8944944
14:50:41 13279 8192000000 10936542384 11377434624 1952737152 19.248 99 30 60 0 2003320944 39929440 10654352
14:51:06 8058 8192000000 10919233504 11365793792 1924732816 19.025 98 32 64 2 1978087456 42796288 10558352
14:51:28 14618 8192000000 10925001360 11372769280 1949607888 19.223 100 34 68 0 2005793312 45100432 11084992
14:51:49 4325 8192000000 10943568624 11372720128 1953409792 19.254 100 46 93 1 2018134128 48789936 15934400
14:52:02 17033 8192000000 10922894080 11374673920 1955835424 19.273 100 23 46 2 2004167440 40304992 8027024
14:52:28 24725 8192000000 10915637456 11369254912 1964461072 19.341 100 22 44 2 2002544112 30947664 7135376
14:52:59 26403 8192000000 10925444448 11375181824 1922972064 19.011 98 23 45 2 1968992928 38342384 7678480
14:53:32 28097 8192000000 10931995280 11384406016 1960320208 19.309 100 26 52 2 2009979552 40865936 8793408
14:54:07 36764 8192000000 10924465328 11387215872 1957465472 19.286 100 20 40 0 2008678400 44128416 7084512
14:54:55 54568 8192000000 10899567536 11343327232 1903031168 18.851 97 11 22 1 1922794352 16451760 3311424
14:55:58 29861 8192000000 10884590432 11332866048 1941189120 19.156 99 41 81 0 1963343616 9723616 12430880
14:56:52 84659 8192000000 10885723552 11334836224 1939331904 19.141 99 26 52 5 1957085184 10394384 7358896
14:58:24 44559 8192000000 10888798432 11352412160 1933859392 19.098 98 10 20 1 1951056304 14260864 2936048
14:59:15 43539 8192000000 10895514288 11352379392 1949516496 19.223 99 19 38 1 1966631088 11925392 5189200
15:00:19 101833 8192000000 10895326224 11351023616 1920951632 18.994 97 27 54 0 1935026656 6848976 7226048
15:02:11 38324 8192000000 10887057584 11351506944 1940096800 19.148 98 19 38 1 1957217584 11657600 5463184
15:03:02 35134 8192000000 10900589408 11361566720 1957731536 19.288 99 15 30 1 1974304176 12539232 4033408
15:05:57 85401 8192000000 10905613760 11385925632 1969299856 19.380 99 19 38 0 1994907728 20181936 5425936
15:07:56 21676 8192000000 10907002080 11371569152 1972093984 19.402 99 45 88 0 1997784688 11874256 13816448
15:08:34 31391 8192000000 10923183392 11379933184 1986823776 19.519 100 28 56 0 2007518848 12299440 8395632
15:09:39 36615 8192000000 10908407184 11378343936 1978883472 19.456 99 23 45 0 1994325920 9246736 6195712
15:10:22 56129 8192000000 10912207936 11385905152 1972263360 19.403 99 14 28 1 1988969824 12836368 3870096
15:12:09 53853 8192000000 10911251152 11384438784 1997149296 19.600 100 27 54 0 2011743664 7462320 7132048
15:13:13 29393 8192000000 10895476992 11368804352 1970323248 19.388 99 23 45 3 1982831584 6506272 6002064
15:14:10 56848 8192000000 10908839072 11393867776 1998256944 19.609 100 16 31 2 2014350704 11559952 4533808
15:15:44 47604 8192000000 10918996720 11398672384 1980152656 19.466 99 10 20 1 1995581248 13002640 2425952
15:16:46 46259 8192000000 10913502672 11398242304 1992714544 19.565 100 19 38 0 2009719120 11697600 5306976
15:17:43 54892 8192000000 10934580624 11403005952 1986320608 19.515 99 25 50 2 2005880896 12302000 7258288
15:18:44 94472 8192000000 10930947648 11414568960 1970067360 19.386 98 16 32 1 1987201408 12422480 4711568
15:20:28 52252 8192000000 10909179808 11380539392 1897066064 18.803 95 23 46 1 1917642208 14012544 6563600
15:21:26 55028 8192000000 10917868592 11397124096 1966327184 19.356 99 16 32 1 1987710768 16451456 4932128
15:22:27 82551 8192000000 10899443664 11385528320 1940957296 19.154 98 12 24 0 1956770640 12535760 3277584
15:23:58 87764 8192000000 10914711024 11387543552 1951438912 19.238 98 23 46 0 1968817792 11715984 5662896
15:25:32 45080 8192000000 10898996832 11368558592 1924885424 19.026 97 20 40 2 1944015376 12784176 6345776
15:26:26 18405 8192000000 10910847600 11367874560 1938491136 19.135 98 39 78 1 1958078960 8730256 10857568
15:26:59 29467 8192000000 10903723632 11341938688 1888032448 18.730 96 30 60 1 1904533104 8190112 8310544
15:27:35 18949 8192000000 10886440304 11338874880 1900481008 18.830 97 41 81 0 1927249024 15600592 11167424
15:28:01 43532 8192000000 10892610880 11343441920 1894597472 18.783 97 41 82 1 1921292912 14762608 11932832
15:30:00 57336 8192000000 10869468816 11327754240 1906463008 18.878 98 36 72 1 1925912016 9096336 10352672
15:31:08 54214 8192000000 10861716048 11335241728 1932603856 19.088 99 17 32 2 1944138944 7069040 4466048
15:32:09 35667 8192000000 10863720832 11335401472 1913710048 18.936 98 8 16 1 1922552832 6194272 2648512
15:32:51 59458 8192000000 10860998656 11325399040 1885998736 18.714 97 8 16 0 1897467424 9629728 1838960
15:34:05 50284 8192000000 10854670368 11331186688 1929448160 19.062 100 17 34 1 1949072544 14392400 5231984
15:35:03 26952 8192000000 10866626064 11344523264 1895846288 18.793 97 9 18 0 1907501008 9276080 2378640
15:35:36 40113 8192000000 10876526384 11340500992 1929906448 19.066 99 26 50 0 1945652048 8539712 7205888
15:36:25 68642 8192000000 10870786000 11349512192 1884514128 18.702 96 20 40 1 1898424544 8711952 5198464
15:37:40 139483 8192000000 10890603536 11362017280 1856346720 18.474 95 15 30 0 1871710336 11635104 3728512
15:40:21 53670 8192000000 10903597280 11358765056 1953207616 19.252 99 36 72 2 1980628576 17666400 9754560
15:41:39 79655 8192000000 10890261648 11353866240 1921356032 18.998 98 9 18 0 1935775232 12479168 1940032
15:43:05 67809 8192000000 10882700192 11349000192 1876283216 18.635 96 16 32 1 1891432784 10707120 4442448
15:44:25 94340 8192000000 10892107712 11351801856 1950871024 19.233 100 17 32 1 1966506976 11326832 4309120
15:46:06 69106 8192000000 10881810672 11360088064 1901924992 18.842 97 20 38 2 1921887824 14696016 5266816
15:47:22 131984 8192000000 10897161328 11381682176 1918524560 18.975 98 19 38 0 1956110944 32760064 4826320
15:49:41 90657 8192000000 10873932480 11340046336 1899185424 18.820 97 29 55 1 1913625440 7076384 7363632
15:51:18 23733 8192000000 10905004112 11352567808 1958216768 19.292 100 43 83 0 1984178016 13518512 12442736
15:51:48 26847 8192000000 10878850272 11344572416 1936442864 19.118 99 26 52 1 1953250096 9539104 7268128
15:52:30 72603 8192000000 10868167872 11346366464 1950301088 19.229 100 13 26 0 1965023440 11155024 3567328
15:53:49 23213 8192000000 10860531008 11343347712 1942057440 19.163 100 3 6 0 1954689584 11748432 883712
15:55:21 69807 8192000000 10895856832 11359191040 1945350848 19.189 99 29 57 1 1967478240 13584464 8542928
15:56:36 23788 8192000000 10893273040 11369021440 1961906592 19.321 100 23 46 0 1987594192 18541616 7145984
15:57:45 86539 8192000000 10913525328 11379970048 1970611984 19.390 100 13 26 2 1993695840 19669856 3414000
15:59:37 66720 8192000000 10893748400 11361492992 1916147776 18.956 97 12 24 2 1932464368 12799808 3516784
16:00:52 70346 8192000000 10911951184 11385384960 1977447056 19.444 100 12 24 2 1991976576 11335888 3193632
16:02:14 72616 8192000000 10902580064 11369226240 1902798656 18.849 96 15 30 3 1915037792 8126416 4112720
16:03:43 41483 8192000000 10928980736 11374362624 1942751392 19.169 98 22 44 0 1956648176 8084400 5812384
16:04:32 114987 8192000000 10896386944 11370319872 1914370464 18.942 97 22 44 1 1935596656 15131280 6094912
16:06:49 51869 8192000000 10892516512 11345387520 1851689872 18.436 94 18 36 0 1867942848 11430736 4822240
16:07:51 56517 8192000000 10874334992 11355136000 1903861952 18.857 98 14 28 1 1927887440 20045120 3980368
16:08:54 56441 8192000000 10908057936 11365380096 1940650864 19.152 99 32 64 1 1963677136 15103104 7923168
16:09:59 102392 8192000000 10890324368 11351076864 1849795408 18.420 94 22 44 1 1872405168 16511440 6098320
16:11:51 74206 8192000000 10896942464 11357700096 1962650208 19.327 100 35 69 1 1981983744 10013648 9319888
16:13:33 64650 8192000000 10885053472 11362902016 1966502592 19.358 100 14 28 0 1977649904 7137760 4009552
16:15:06 58959 8192000000 10850619376 11328786432 1871065920 18.593 95 9 18 0 1881143824 7770464 2307440
16:16:16 44591 8192000000 10860386432 11339567104 1911096576 18.915 98 7 14 0 1919757712 7120368 1540768
16:17:06 46710 8192000000 10861533200 11339259904 1910172064 18.908 98 9 18 0 1920911248 8423024 2316160
16:17:59 47880 8192000000 10880068048 11356430336 1954329568 19.261 100 16 32 3 1969259744 10437632 4492544
16:18:54 53007 8192000000 10877506288 11359817728 1942017936 19.163 99 12 24 0 1958160000 12752496 3389568
16:20:36 46661 8192000000 10870985552 11338780672 1911315024 18.917 98 17 34 2 1929774704 13622176 4837504
16:21:33 34028 8192000000 10853151744 11332632576 1891695600 18.759 97 19 38 1 1903731648 6263248 5772800
16:22:14 47871 8192000000 10860561312 11324059648 1851980928 18.438 95 20 40 2 1863850480 6349840 5519712
16:23:19 35489 8192000000 10861001008 11320664064 1897387888 18.805 98 11 22 1 1909468688 9630976 2449824
16:24:14 33678 8192000000 10867127328 11324772352 1885950272 18.713 98 32 64 2 1908181232 13449200 8781760
16:25:03 55606 8192000000 10856165024 11323416576 1896489072 18.798 98 19 38 1 1909310288 7222400 5598816
16:26:06 36801 8192000000 10862247360 11316527104 1858329424 18.490 96 20 40 1 1870737056 7184736 5222896
16:26:52 36544 8192000000 10879477600 11335651328 1901979936 18.842 98 38 76 2 1931554688 19106864 10467888
16:27:35 19253 8192000000 9366251360 9656266752 513190592 5.895 27 1 2 0 519566208 6313488 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 14-06-2021 16:28:46 to 14-06-2021 16:29:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 192 v_add_invoice_to_stock 335544517
except 22 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-06-2021 16:29:18 to 14-06-2021 16:29:20.

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          248782
MON$OLDEST_ACTIVE               248783
MON$OLDEST_SNAPSHOT             248783
MON$NEXT_TRANSACTION            248783
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                       2007808
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.33473 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33473 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33473 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33473 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'

14.06.21 16:29:21. 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-06-14 16:29:23 No severe PSQL-related problems occured
14.06.21 16:29:25. End of report.