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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17282868 kB
MemAvailable 31403212 kB
Buffers 0 kB
Cached 14423376 kB
SwapCached 2412 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-21 19:27:38
DTS_END                         2021-06-21 19:27:38.6090
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43496
TRN_ID                          248654
ATT_ID                          670
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: 9101.66 19137 1092199
customer order: creation 181.61 350 21793
customer order: refuse 15.87 368 1904
order to supplier: creation 47.57 1234 5708
order to supplier: removal 3.29 94766 395
invoice (draft): creation 48.06 3028 5767
invoice (draft): removal 47.92 776 5750
invoice accept: apply 44.32 17985 5318
invoice accept: cancel 43.25 841 5190
customer reserve: creation 4085.34 176 490241
customer reserve: removal 4287.62 58 514514
realization accept: apply 87.39 191 10487
realization accept: cancel 72.34 112 8681
payment from customer: creation 62.74 135 7529
payment from customer: removal 6.02 79 722
payment to supplier: creation 51.73 159 6207
payment to supplier: removal 3.60 81 432
service: total inventory turnovers 4.92 1181 590
service: total monetary turnovers 7.16 36 859
service: aggregate perf. data 0.90 19212 108
service: refresh index statistics 0.03 241976 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-06-2021 19:29:47 to 21-06-2021 19:29:49.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1275
TEST_TIME 2 1437
TEST_TIME 3 2217
TEST_TIME 4 3068
TEST_TIME 5 3663
TEST_TIME 6 4595
TEST_TIME 7 4621
TEST_TIME 8 4928
TEST_TIME 9 4994
TEST_TIME 10 5102
TEST_TIME 11 5271
TEST_TIME 12 5287
TEST_TIME 13 5558
TEST_TIME 14 5897
TEST_TIME 15 6020
TEST_TIME 16 6074
TEST_TIME 17 6343
TEST_TIME 18 6519
TEST_TIME 19 6760
TEST_TIME 20 7103
TEST_TIME 21 7521
TEST_TIME 22 7845
TEST_TIME 23 8124
TEST_TIME 24 8223
TEST_TIME 25 8728
TEST_TIME 26 8993
TEST_TIME 27 9235
TEST_TIME 28 9828
TEST_TIME 29 10251
TEST_TIME 30 10120
TEST_TIME 31 10429
TEST_TIME 32 10398
TEST_TIME 33 10393
TEST_TIME 34 10321
TEST_TIME 35 10210
TEST_TIME 36 10064
TEST_TIME 37 9984
TEST_TIME 38 9939
TEST_TIME 39 9929
TEST_TIME 40 9900
TEST_TIME 41 9856
TEST_TIME 42 9747
TEST_TIME 43 9664
TEST_TIME 44 9535
TEST_TIME 45 9667
TEST_TIME 46 9918
TEST_TIME 47 9819
TEST_TIME 48 9722
TEST_TIME 49 9664
TEST_TIME 50 9571
TEST_TIME 51 9493
TEST_TIME 52 9498
TEST_TIME 53 9397
TEST_TIME 54 9315
TEST_TIME 55 9410
TEST_TIME 56 9388
TEST_TIME 57 9372
TEST_TIME 58 9400
TEST_TIME 59 9425
TEST_TIME 60 9428
TEST_TIME 61 9440
TEST_TIME 62 9510
TEST_TIME 63 9469
TEST_TIME 64 9507
TEST_TIME 65 9599
TEST_TIME 66 9592
TEST_TIME 67 9568
TEST_TIME 68 9599
TEST_TIME 69 9586
TEST_TIME 70 9623
TEST_TIME 71 9516
TEST_TIME 72 9470
TEST_TIME 73 9408
TEST_TIME 74 9406
TEST_TIME 75 9379
TEST_TIME 76 9357
TEST_TIME 77 9398
TEST_TIME 78 9317
TEST_TIME 79 9244
TEST_TIME 80 9220
TEST_TIME 81 9242
TEST_TIME 82 9227
TEST_TIME 83 9210
TEST_TIME 84 9215
TEST_TIME 85 9285
TEST_TIME 86 9279
TEST_TIME 87 9333
TEST_TIME 88 9296
TEST_TIME 89 9358
TEST_TIME 90 9403
TEST_TIME 91 9421
TEST_TIME 92 9463
TEST_TIME 93 9421
TEST_TIME 94 9337
TEST_TIME 95 9310
TEST_TIME 96 9300
TEST_TIME 97 9275
TEST_TIME 98 9220
TEST_TIME 99 9196
TEST_TIME 100 9175
TEST_TIME 101 9231
TEST_TIME 102 9201
TEST_TIME 103 9221
TEST_TIME 104 9231
TEST_TIME 105 9220
TEST_TIME 106 9208
TEST_TIME 107 9235
TEST_TIME 108 9255
TEST_TIME 109 9256
TEST_TIME 110 9306
TEST_TIME 111 9293
TEST_TIME 112 9332
TEST_TIME 113 9308
TEST_TIME 114 9287
TEST_TIME 115 9254
TEST_TIME 116 9219
TEST_TIME 117 9226
TEST_TIME 118 9176
TEST_TIME 119 9159
TEST_TIME 120 9102

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 21-06-2021 19:29:50 to 21-06-2021 19:29:54.

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 1544299 1544299 0 0.00 0 20355 7 0 0
doc_list_biud 1544277 1544277 0 0.00 0 26447 25 0 0
sp_add_invoice_to_stock 5438 5318 120 2.20 19 199616 17986 0 120
sp_cancel_adding_invoice 5190 5190 0 0.00 5 63723 842 0 0
sp_cancel_client_order 1904 1904 0 0.00 4 16908 369 0 0
sp_cancel_customer_reserve 514514 514514 0 0.00 1 22537 58 0 0
sp_cancel_pay_from_customer 722 722 0 0.00 2 6786 79 0 0
sp_cancel_pay_to_supplier 432 432 0 0.00 3 5007 81 0 0
sp_cancel_supplier_invoice 5759 5750 9 0.15 2 13677 776 0 9
sp_cancel_supplier_order 395 395 0 0.00 10 1139785 94766 0 0
sp_cancel_write_off 8681 8681 0 0.00 1 14934 112 0 0
sp_client_order 21793 21793 0 0.00 3 38409 350 0 0
sp_customer_reserve 490241 490241 0 0.00 0 88113 177 0 0
sp_fill_shopping_cart 33263 33263 0 0.00 1 8545 36 0 0
sp_fill_shopping_cart_clo_res 490240 490240 0 0.00 0 22429 14 0 0
sp_get_clo_for_invoice 5317 5317 0 0.00 0 25484 282 0 0
sp_kill_cost_storno 15025 15025 0 0.00 0 6719 56 0 0
sp_kill_qstorno_ret_qs2qd 1043854 1043854 0 0.00 0 22528 31 0 0
sp_kill_qty_storno 552227 552227 0 0.00 0 26441 68 0 0
sp_lock_selected_doc 21904 21904 0 0.00 0 9875 7 0 0
sp_make_cost_storno 29540 29540 0 0.00 0 20350 65 0 0
sp_multiply_rows_for_pdistr 29525 29525 0 0.00 0 5474 29 0 0
sp_multiply_rows_for_qdistr 21793 21793 0 0.00 0 38404 160 0 0
sp_pay_from_customer 7529 7529 0 0.00 4 18795 136 0 0
sp_pay_to_supplier 6207 6207 0 0.00 5 15543 159 0 0
sp_payment_common 13725 13725 0 0.00 1 16327 35 0 0
sp_qd_handle_on_cancel_clo 1904 1904 0 0.00 0 16902 341 0 0
sp_qd_handle_on_invoice_upd_sts 10502 10502 0 0.00 0 26433 308 0 0
sp_qd_handle_on_reserve_upd_sts 10481 10481 0 0.00 0 23479 70 0 0
sp_reserve_write_off 10487 10487 0 0.00 7 23665 192 0 0
sp_supplier_invoice 5767 5767 0 0.00 6 94621 3028 0 0
sp_supplier_order 5708 5708 0 0.00 5 50583 1235 0 0
srv_aggregate_perf_data 108 108 0 0.00 2712 239446 19212 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 1047 132114 30752 0 0
srv_find_qd_qs_mism 1040815 1040815 0 0.00 0 16960 6 0 0
srv_make_invnt_saldo 590 590 0 0.00 34 35793 1181 0 0
srv_make_money_saldo 859 859 0 0.00 1 11553 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 193060 355491 241976 0 0
t$perf-abend:sp_add_invoice_to_stock 120 120 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5319 5319 0 0.00 0 9873 151 0 0
t$perf-norm:sp_cancel_adding_invoice 434 434 0 0.00 1 3044 92 0 0
t$perf-norm:sp_cancel_client_order 1904 1904 0 0.00 0 651 7 0 0
t$perf-norm:sp_cancel_customer_reserve 703 703 0 0.00 0 14177 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 722 722 0 0.00 0 1780 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 432 432 0 0.00 0 414 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 418 418 0 0.00 0 1265 19 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 22219 1456 0 0
t$perf-norm:sp_cancel_write_off 1103 1103 0 0.00 0 894 4 0 0
t$perf-norm:sp_client_order 21793 21793 0 0.00 0 14866 19 0 0
t$perf-norm:sp_customer_reserve 1051 1051 0 0.00 0 1947 8 0 0
t$perf-norm:sp_pay_from_customer 7529 7529 0 0.00 0 7902 10 0 0
t$perf-norm:sp_pay_to_supplier 6207 6207 0 0.00 0 3830 10 0 0
t$perf-norm:sp_reserve_write_off 10487 10487 0 0.00 0 10010 11 0 0
t$perf-norm:sp_supplier_invoice 5767 5767 0 0.00 0 4189 18 0 0
t$perf-norm:sp_supplier_order 5708 5708 0 0.00 0 2805 16 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 1001 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 679 9 0 0
t$perf-norm:srv_make_invnt_saldo 590 590 0 0.00 0 4208 31 0 0
t$perf-norm:srv_make_money_saldo 859 859 0 0.00 0 1928 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 14 6 0 0
v_add_invoice_to_stock 10864 10624 240 2.20 0 15388 21 0 240
v_all_customers 39850 39850 0 0.00 0 162 1 0 0
v_all_suppliers 31838 31838 0 0.00 0 17 1 0 0
v_all_wares 43586 43586 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 868 868 0 0.00 0 458 7 0 0
v_cancel_client_order 3808 3808 0 0.00 0 2325 6 0 0
v_cancel_customer_prepayment 1444 1444 0 0.00 0 3851 6 0 0
v_cancel_customer_reserve 1406 1406 0 0.00 0 1129 4 0 0
v_cancel_payment_to_supplier 864 864 0 0.00 0 935 6 0 0
v_cancel_supplier_invoice 854 836 18 2.10 0 457 14 0 18
v_cancel_supplier_order 790 790 0 0.00 0 3655 9 0 0
v_cancel_write_off 2206 2206 0 0.00 0 2986 14 0 0
v_max_id_clo_ord 5708 5708 0 0.00 0 469 2 0 0
v_max_id_clo_res 1051 1051 0 0.00 0 3669 21 0 0
v_max_id_ord_sup 5762 5762 0 0.00 0 3215 4 0 0
v_max_non_paid_invoice 1751 1751 0 0.00 0 243 2 0 0
v_max_non_paid_realizn 4005 4005 0 0.00 0 2811 4 0 0
v_min_id_clo_ord 5708 5708 0 0.00 0 6114 15 0 0
v_min_id_clo_res 1051 1051 0 0.00 0 9239 20 0 0
v_min_id_ord_sup 5762 5762 0 0.00 0 6613 11 0 0
v_min_non_paid_invoice 6200 6200 0 0.00 0 11215 26 0 0
v_min_non_paid_realizn 7523 7523 0 0.00 0 16325 23 0 0
v_our_firm 10772 10772 0 0.00 0 12 1 0 0
v_reserve_write_off 20962 20962 0 0.00 0 4044 4 0 0
x_lock_depdocs_on_canc_invoice 10522 10522 0 0.00 0 36569 125 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 9593 365 0 0
x_make_qstorno_1000_1200 5708 5708 0 0.00 1 45001 1144 0 0
x_make_qstorno_1200_2000 5767 5767 0 0.00 3 94597 2910 0 0
x_make_qstorno_2100_3300 490241 490241 0 0.00 0 88111 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-06-2021 19:29:55 to 21-06-2021 19:29:59.

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:42 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
16:57:49 29838 8192000000 10293591008 10601963520 984274912 10.726 75 57 114 1 1005318544 2606656 18436976
16:58:29 3172 8192000000 10332229728 10642866176 1394492144 14.546 100 90 181 0 1428580384 4815456 29272784
16:58:45 16282 8192000000 10367224832 10684522496 1420996608 14.782 100 90 180 0 1456863856 5938832 29928416
16:59:11 28404 8192000000 10401180128 10729439232 1452774944 15.062 100 87 174 1 1488332784 6983008 28574832
16:59:56 26973 8192000000 10438528448 10770780160 1494533120 15.428 100 88 176 0 1530504400 8048032 27923248
17:00:29 27729 8192000000 10461527808 10795540480 1508954992 15.554 100 86 172 0 1545298624 8758464 27585168
17:01:09 16664 8192000000 10480523984 10818347008 1537300400 15.800 100 86 172 0 1573556880 9280624 26975856
17:01:33 15469 8192000000 10490763552 10831360000 1547318320 15.887 100 86 172 1 1584427792 9796960 27312512
17:01:58 13271 8192000000 10505766304 10850930688 1565286032 16.042 100 82 164 1 1601576368 10286816 26003520
17:02:28 15123 8192000000 10523944640 10877931520 1582964544 16.194 100 75 149 1 1616629520 10736048 22928928
17:02:50 19075 8192000000 10569131664 10925150208 1615410848 16.471 100 84 168 0 1651668336 11128768 25128720
17:03:18 13251 8192000000 10587428912 10951442432 1641533776 16.693 100 77 154 1 1675921296 11402032 22985488
17:03:40 11456 8192000000 10605942528 10971586560 1663356272 16.877 100 80 160 0 1699374080 12266720 23751088
17:04:00 9015 8192000000 10615102688 10983813120 1675419856 16.979 100 78 156 2 1710507920 12073376 23014688
17:04:16 9108 8192000000 10623119664 10992750592 1688647712 17.090 100 82 164 0 1725095808 12222400 24225696
17:04:32 6874 8192000000 10650351680 11018522624 1706147632 17.237 100 85 170 1 1743423008 12721920 24553456
17:04:46 7626 8192000000 10645829776 11017711616 1709787088 17.267 100 74 149 0 1743767744 12849264 21131392
17:05:01 7819 8192000000 10664202800 11036983296 1721009712 17.361 100 82 164 0 1757577248 13190560 23376976
17:05:16 9687 8192000000 10663188256 11044409344 1728305536 17.421 100 70 140 2 1761475520 13057696 20112288
17:05:36 6740 8192000000 10683141552 11062034432 1747283760 17.579 100 80 160 2 1783539040 13093184 23162096
17:05:49 4051 8192000000 10687637024 11067760640 1756013584 17.651 100 70 136 1 1786938384 12104240 18820560
17:06:00 4578 8192000000 10703445760 11083735040 1766052912 17.734 100 77 154 1 1799036640 11460848 21522880
17:06:11 4398 8192000000 10713156560 11095306240 1776086816 17.817 100 72 143 2 1807622848 11559904 19976128
17:06:23 5549 8192000000 10720429296 11108143104 1787698864 17.913 100 70 140 1 1819309840 12168640 19442336
17:06:41 6199 8192000000 10732624992 11121201152 1799759856 18.012 100 70 140 1 1830937200 11838640 19338704
17:06:55 2983 8192000000 10753082640 11135639552 1811696400 18.110 100 83 165 1 1847388304 12336336 23355568
17:07:05 4294 8192000000 10761790992 11148496896 1820086112 18.178 100 84 168 3 1856788160 13336864 23365184
17:07:16 2962 8192000000 10774800608 11160092672 1829622128 18.256 100 83 166 0 1866255456 13245712 23387616
17:07:26 2799 8192000000 10775639408 11162152960 1833243392 18.286 100 88 177 0 1872702464 14243536 25215536
17:07:35 2792 8192000000 10781120320 11165634560 1838068112 18.325 100 93 186 2 1879428992 14815552 26545328
17:07:44 2978 8192000000 10786896672 11170181120 1841622272 18.354 100 94 187 1 1882243584 14254368 26366944
17:07:54 1780 8192000000 10783724800 11170902016 1843828768 18.372 100 77 154 2 1878652784 12522832 22301184
17:08:02 2080 8192000000 10794912752 11178323968 1850304464 18.425 100 95 191 1 1890271712 13074656 26892592
17:08:12 2252 8192000000 10795630752 11181076480 1850353360 18.425 100 85 170 1 1887257056 11450112 25453584
17:08:20 2041 8192000000 10794558352 11181776896 1854210016 18.456 100 93 186 0 1893943184 13800672 25932496
17:08:29 1825 8192000000 10801355296 11190026240 1857878336 18.486 100 91 182 0 1897428384 14324272 25225776
17:08:37 1712 8192000000 10807080384 11191173120 1861383776 18.514 100 92 184 0 1903462880 15728400 26350704
17:08:45 1382 8192000000 10812003456 11198865408 1865177904 18.545 100 93 186 0 1907007856 15521728 26308224
17:08:53 1890 8192000000 10810210784 11196473344 1866315904 18.554 100 92 184 3 1906340576 13342416 26682256
17:09:01 1780 8192000000 10815020576 11203514368 1870879824 18.591 100 95 189 2 1910833424 13063072 26890528
17:09:10 1488 8192000000 10822077920 11210264576 1871784016 18.599 100 93 187 1 1913126976 14655600 26687360
17:09:17 10303 8192000000 10793318384 11199541248 1868825296 18.575 100 69 138 1 1899314800 10676336 19813168
17:09:35 1891 8192000000 10802611584 11205066752 1872401648 18.604 100 79 158 2 1906412624 11167488 22843488
17:09:45 11982 8192000000 10817737552 11209347072 1872596640 18.605 100 76 151 1 1905926880 12928032 20402208
17:10:03 37964 8192000000 10805611408 11206778880 1874495600 18.621 100 61 122 3 1900809904 9028080 17286224
17:10:48 21664 8192000000 10784211856 11210924032 1871279760 18.595 100 41 81 0 1891229440 8316448 11633232
17:11:16 9814 8192000000 10786197248 11211497472 1874888880 18.624 100 24 46 0 1887248272 5492576 6866816
17:11:35 5466 8192000000 10787781040 11215618048 1880300208 18.668 100 51 105 1 1905815264 9809136 15705920
17:11:46 10581 8192000000 10791174512 11217600512 1877343120 18.644 100 17 34 3 1888815920 6506272 4966528
17:12:09 6346 8192000000 10793753392 11215441920 1879516832 18.661 100 27 54 0 1893332080 5595808 8219440
17:12:21 7732 8192000000 10781643248 11219533824 1884009344 18.697 100 16 32 0 1895202432 6579152 4613936
17:12:37 10425 8192000000 10784242000 11222327296 1883873952 18.696 100 27 54 1 1898437632 7133616 7430064
17:12:56 7875 8192000000 10801852816 11228946432 1888007024 18.730 100 25 50 0 1901761728 5429200 8325504
17:13:11 8222 8192000000 10796966448 11231014912 1888594736 18.734 100 20 39 1 1901203168 6709488 5898944
17:13:31 9512 8192000000 10797091520 11229548544 1892780560 18.768 100 18 36 3 1904751712 5853200 6117952
17:13:47 3234 8192000000 10806700352 11235639296 1898528752 18.814 100 21 42 0 1910097344 5534544 6034048
17:13:59 7172 8192000000 10802595376 11237101568 1898635840 18.815 100 23 46 1 1911134560 6344400 6154320
17:14:14 19323 8192000000 10796796768 11238514688 1896359520 18.797 100 11 22 0 1904404624 5180608 2864496
17:14:40 8999 8192000000 10806056208 11239686144 1898794208 18.817 100 15 30 3 1909110896 5446576 4870112
17:14:55 9020 8192000000 10805011024 11243057152 1899385088 18.821 100 15 30 1 1910906832 5593344 5928400
17:15:17 10216 8192000000 10813059376 11243417600 1903394336 18.854 100 25 51 3 1916177760 6170272 6613152
17:15:35 82078 8192000000 10833693008 11249709056 1886976592 18.721 99 30 58 1 1901278976 5222576 9079808
17:17:03 1525 8192000000 10856435568 11261300736 1912971792 18.930 100 93 190 3 1950571104 9613104 27986208
17:17:11 5626 8192000000 10817391520 11251245056 1900867328 18.833 100 28 56 2 1916683680 8044944 7771408
17:17:23 5526 8192000000 10825578672 11255508992 1909500528 18.903 100 39 76 2 1927195424 7123728 10571168
17:17:35 5510 8192000000 10833877936 11253874688 1905877296 18.874 100 45 89 3 1925732720 7306448 12548976
17:17:47 4421 8192000000 10820294000 11245404160 1886262752 18.716 99 59 118 5 1911823088 9033504 16526832
17:18:02 4397 8192000000 10771498688 11199082496 1847922464 18.405 99 30 61 1 1863217296 6549760 8745072
17:18:13 8419 8192000000 10785089632 11199909888 1851268208 18.432 99 26 50 2 1865041312 6126928 7646176
17:18:28 14319 8192000000 10784577712 11185516544 1795818880 17.980 96 27 56 0 1809871120 5439824 8612416
17:18:49 43028 8192000000 10753310064 11179331584 1788145024 17.917 96 39 79 3 1805681776 6988992 10547760
17:19:40 5484 8192000000 10728119280 11142193152 1766717056 17.740 96 26 52 1 1779637792 5541632 7379104
17:19:52 5619 8192000000 10734291072 11151462400 1812944544 18.120 99 32 64 0 1830801040 8311424 9545072
17:20:05 6351 8192000000 10676192976 11081854976 1692243120 17.120 94 24 48 1 1704904448 5490976 7170352
17:20:18 5456 8192000000 10707472208 11121872896 1790716832 17.938 100 33 67 4 1806157872 6212064 9228976
17:20:29 12314 8192000000 10718604320 11132252160 1750282048 17.604 97 23 46 0 1762531424 5153808 7095568
17:20:52 6610 8192000000 10700523328 11115704320 1770408336 17.770 99 26 51 4 1784549040 6202464 7938240
17:21:05 7866 8192000000 10701743904 11117748224 1760397728 17.688 98 23 46 0 1772756032 5591600 6766704
17:21:20 6582 8192000000 10714639472 11139219456 1793066144 17.957 99 23 45 1 1805576288 5910512 6599632
17:21:39 4391 8192000000 10675293392 11091599360 1743812944 17.550 98 26 52 1 1757918576 6519616 7586016
17:21:50 8830 8192000000 10694456992 11115696128 1757230224 17.661 98 17 34 2 1767768000 5945696 4592080
17:22:05 11394 8192000000 10719376896 11136589824 1753452064 17.630 97 17 34 1 1763921792 5432432 5037296
17:22:25 12467 8192000000 10713328368 11123740672 1775167728 17.810 99 26 50 0 1792335136 10128064 7039344
17:22:43 11509 8192000000 10725400976 11141820416 1794259296 17.967 99 39 78 3 1811839056 4805504 12774256
17:23:21 32922 8192000000 10738335856 11159244800 1821782752 18.192 100 48 96 0 1842875072 7197744 13894576
17:24:03 13571 8192000000 10727619552 11150123008 1811722112 18.110 99 22 43 4 1824231312 5989120 6520080
17:24:25 7633 8192000000 10770330512 11185713152 1843250976 18.367 100 44 85 2 1862875008 8177456 11446576
17:24:40 4853 8192000000 10767113120 11184058368 1845143248 18.383 100 44 88 2 1865280608 7043248 13094112
17:24:51 6873 8192000000 10765819488 11189145600 1847820944 18.404 100 25 51 0 1860542560 5155072 7566544
17:25:07 7411 8192000000 10761351776 11186364416 1833852080 18.291 99 19 40 3 1844154464 4913696 5388688
17:25:23 5349 8192000000 10764550832 11185790976 1846691088 18.395 100 27 55 2 1860453232 5920656 7841488
17:25:35 12427 8192000000 10759290912 11187552256 1849916528 18.421 100 24 48 1 1866683664 9640448 7126688
17:25:55 10148 8192000000 10761197840 11197939712 1859173728 18.497 100 19 36 0 1868972640 5605776 4193136
17:26:11 15302 8192000000 10776707440 11206098944 1861295552 18.514 100 15 30 2 1870243536 5323072 3624912
17:26:35 9990 8192000000 10780986432 11209740288 1866692640 18.558 100 16 31 0 1876357152 5106768 4557744
17:26:51 10576 8192000000 10788813344 11216986112 1871201408 18.594 100 25 52 1 1883458144 5377872 6878864
17:27:10 15675 8192000000 10805134048 11231129600 1885065488 18.706 100 21 41 2 1896084512 5116544 5902480
17:27:34 26184 8192000000 10816532064 11240407040 1899446080 18.822 100 34 65 0 1914144512 4588992 10109440
17:28:07 132114 8192000000 10853696272 11273060352 1900431760 18.830 99 45 91 0 1926407648 13011024 12964864
17:30:25 6855 8192000000 10846684848 11271864320 1920507360 18.991 100 44 85 2 1941940416 9807552 11625504
17:30:41 29253 8192000000 10862239728 11289124864 1928067472 19.051 100 45 88 1 1950488208 10257744 12162992
17:31:30 4446 8192000000 10863644816 11290439680 1937467616 19.127 100 48 92 2 1961246208 10265248 13513344
17:31:41 34350 8192000000 10872558752 11304755200 1936679712 19.120 100 37 74 1 1959998064 12656512 10661840
17:32:25 24956 8192000000 10866720544 11303092224 1943060448 19.171 100 38 74 0 1965626688 11054672 11511568
17:33:00 13711 8192000000 10880766192 11310776320 1949369328 19.221 100 47 94 1 1972729264 9703456 13656480
17:33:22 23379 8192000000 10888398768 11321524224 1952382912 19.245 100 43 86 3 1974550528 9431680 12735936
17:33:54 5286 8192000000 10882529760 11318026240 1955072320 19.267 100 36 68 2 1975682368 11121600 9488448
17:34:18 9376 8192000000 10897954976 11328917504 1967011488 19.362 100 54 107 3 1995128320 12899824 15217008
17:34:39 2306 8192000000 10913457728 11335278592 1969724224 19.383 100 64 128 0 2001213888 13891616 17598048
17:34:48 17034 8192000000 10900924112 11332915200 1968470032 19.373 100 61 119 3 1999439760 14282496 16687232
17:35:20 8900 8192000000 10918506752 11344154624 1971629040 19.398 100 60 121 0 2005191152 15817264 17744848
17:35:36 19456 8192000000 10917779248 11343638528 1953338064 19.253 99 56 112 0 1988349760 18136976 16874720
17:36:09 13451 8192000000 10919731248 11350417408 1969924400 19.385 100 46 89 0 2002015216 18582464 13508352
17:36:34 9312 8192000000 10911078192 11347664896 1973884928 19.416 100 50 98 2 2007846704 19173120 14788656
17:36:58 12994 8192000000 10921224800 11357777920 1960597072 19.311 99 47 94 0 2001064384 25722128 14745184
17:37:20 10462 8192000000 10937769136 11364773888 1982603744 19.485 100 50 100 2 2019905440 22349104 14952592
17:37:39 7111 8192000000 10926723152 11355570176 1969519104 19.382 99 63 126 0 2013458832 24450816 19488912
17:37:54 15772 8192000000 10938225104 11371401216 1988472352 19.532 100 60 120 0 2032873872 26375712 18025808
17:38:18 16531 8192000000 10930253040 11378049024 1987186064 19.522 100 45 90 1 2029922384 28366752 14369568
17:38:44 5515 8192000000 10937543744 11363201024 1968376688 19.373 99 65 129 0 2010914000 23472112 19065200
17:38:59 3262 8192000000 10951578032 11374448640 1984285936 19.499 100 63 126 1 2028298064 25040832 18971296
17:39:10 2432 8192000000 10950021008 11371266048 1990719984 19.549 100 65 130 1 2036198336 26287728 19190624
17:39:19 19571 8192000000 10957431216 11385032704 1996727552 19.597 100 67 133 2 2042901168 26771024 19402592
17:39:52 5995 8192000000 10958528224 11392266240 1996216976 19.593 100 49 98 1 2039967376 28892768 14857632
17:40:11 12591 8192000000 10946228176 11377487872 1971906064 19.401 99 51 101 2 2016457440 29086912 15464464
17:40:33 4312 8192000000 10950071968 11377766400 1975423168 19.428 99 65 131 1 2027949088 31535952 20989968
17:40:45 5842 8192000000 10954361536 11383717888 1991109936 19.553 100 66 130 3 2043416272 32128704 20177632
17:41:13 21956 8192000000 10921858928 11362684928 1959698112 19.304 99 43 85 2 2001003808 27751888 13553808
17:41:43 6081 8192000000 10932267536 11372703744 1985904112 19.511 100 60 121 2 2031868496 27417904 18546480
17:42:01 2139 8192000000 10943863728 11375435776 1985925392 19.512 100 55 111 1 2032002640 29185936 16891312
17:42:15 4826 8192000000 10962682800 11391430656 2000341232 19.625 100 65 130 0 2050458752 30947120 19170400
17:42:28 2188 8192000000 10966395584 11380916224 1991743424 19.558 100 82 160 1 2046044992 30922448 23379120
17:42:38 3086 8192000000 10962987216 11382910976 1994389520 19.578 100 78 155 0 2049055552 32164624 22501408
17:42:47 2158 8192000000 10958845056 11369984000 1981113136 19.474 99 87 171 2 2039866896 32732256 26021504
17:42:56 2373 8192000000 10969308736 11386826752 1989711680 19.542 100 79 157 1 2046221488 33207200 23302608
17:43:05 1321 8192000000 10973509168 11394035712 2000320576 19.625 100 84 171 3 2058792480 32844592 25627312
17:43:15 1503 8192000000 10958019728 11379179520 1987473728 19.524 100 75 146 2 2041830576 32446512 21910336
17:43:24 3332 8192000000 10967923472 11384991744 1990581472 19.548 100 69 137 0 2044502464 32851792 21069200
17:43:35 8126 8192000000 10974125136 11391717376 1995893696 19.590 100 84 167 1 2055504640 34679680 24931264
17:43:50 2522 8192000000 10965521088 11376041984 1977669936 19.446 99 87 175 0 2040046704 35664080 26712688
17:44:00 4173 8192000000 10972153456 11390611456 1994569696 19.580 100 84 162 2 2059689520 40956928 24162896
17:44:11 1712 8192000000 10977615840 11395338240 1997886272 19.606 100 85 169 1 2060594208 36841904 25866032
17:44:23 2566 8192000000 10982074848 11396182016 1979473120 19.461 99 79 156 2 2048081408 44668128 23940160
17:44:36 3543 8192000000 10943014080 11369787392 1941583408 19.159 98 74 147 0 2005385440 41004048 22797984
17:44:46 3644 8192000000 10941000896 11359428608 1945353728 19.189 99 68 135 2 2006809120 39982016 21473376
17:45:02 7375 8192000000 10922051472 11344297984 1951402016 19.238 100 78 153 1 2014266272 39148016 23716240
17:45:17 4684 8192000000 10930299568 11350769664 1947820208 19.209 99 78 154 1 2012864496 40556736 24487552
17:45:31 3474 8192000000 10940449888 11366789120 1962329232 19.325 100 64 124 0 2023012688 41173984 19509472
17:45:43 3394 8192000000 10942631392 11355070464 1926899488 19.042 98 83 164 3 1990897440 38884416 25113536
17:45:54 3792 8192000000 10943891984 11355717632 1958665008 19.295 100 88 173 1 2025923392 40733008 26525376
17:46:05 2388 8192000000 10947450816 11354587136 1958963344 19.298 100 97 192 0 2030723104 42327504 29432256
17:46:17 3764 8192000000 10932711888 11345879040 1947682288 19.208 100 81 162 0 2013882192 41087264 25112640
17:46:29 2664 8192000000 10943878544 11354947584 1957080352 19.283 100 80 159 0 2022931808 41190560 24660896
17:46:39 2847 8192000000 10934015888 11342876672 1942891520 19.170 100 91 182 1 2015876192 43882032 29102640
17:46:48 4090 8192000000 10919498992 11326050304 1917443072 18.966 99 85 170 0 1988251968 43898608 26910288
17:47:01 7136 8192000000 10894058640 11323736064 1913517680 18.935 99 61 122 1 1976711104 43778112 19415312
17:47:16 4960 8192000000 10914109072 11335061504 1919462304 18.983 99 59 119 2 1982672752 43265792 19944656
17:47:30 3612 8192000000 10913207792 11330011136 1921617648 19.000 99 55 108 1 1983542864 43843376 18081840
17:47:40 3560 8192000000 10933677104 11347267584 1939216720 19.141 100 66 132 0 2006748208 46496880 21034608
17:47:51 3363 8192000000 10924391056 11342802944 1939122688 19.140 100 69 138 1 2005348464 44629184 21596592
17:48:05 13530 8192000000 10899703264 11340275712 1921576992 18.999 99 43 85 2 1978109056 42094048 14438016
17:48:25 5592 8192000000 10911495104 11345711104 1939546480 19.143 100 35 70 1 1991785136 40435072 11803584
17:48:37 8206 8192000000 10908044976 11343867904 1927332640 19.046 99 39 77 2 1980676960 41079136 12265184
17:48:54 6425 8192000000 10935095728 11361288192 1946415168 19.198 100 66 131 2 2009933312 42025536 21492608
17:49:08 4670 8192000000 10927115008 11348066304 1943719344 19.176 100 65 128 3 2009526848 45668928 20138576
17:49:20 1855 8192000000 10944664512 11350294528 1930607648 19.072 99 90 181 1 2005467584 46776288 28083648
17:49:28 3592 8192000000 10939771120 11348631552 1935299408 19.109 99 80 154 4 1999633280 40429552 23904320
17:49:43 4317 8192000000 10948116944 11352838144 1951793792 19.241 100 89 178 0 2022108880 42846640 27468448
17:49:54 1046 8192000000 10958129136 11364691968 1961705696 19.320 100 89 177 2 2033104352 43906576 27492080
17:50:01 2218 8192000000 10967944976 11379834880 1971296176 19.396 100 88 176 1 2045686848 46993840 27396832
17:50:10 5209 8192000000 10934680256 11373670400 1966983472 19.362 100 48 96 1 2026203232 44200272 15019488
17:50:25 16238 8192000000 10920564704 11362336768 1953495536 19.254 100 33 66 1 2007962352 43516096 10950720
17:50:53 9194 8192000000 10927371856 11369926656 1957696336 19.288 100 36 73 2 2013883920 44090416 12097168
17:51:14 13511 8192000000 10933292992 11373940736 1960163472 19.307 100 37 74 0 2018112048 45101952 12846624
17:51:35 21273 8192000000 10914887504 11359748096 1906070208 18.875 97 35 68 2 1965879200 48350656 11458336
17:52:09 12945 8192000000 10916724672 11362185216 1929628912 19.064 99 30 61 0 1990135840 50006560 10500368
17:52:57 15489 8192000000 10898837968 11339747328 1913628144 18.936 99 23 46 2 1964314704 42416224 8270336
17:53:28 23280 8192000000 10894470192 11338801152 1913039856 18.931 99 20 40 0 1961728784 41757648 6931280
17:54:03 21577 8192000000 10895364992 11337601024 1923032704 19.011 100 38 76 2 1976620160 41879360 11708096
17:54:31 9185 8192000000 10897771408 11344957440 1927442224 19.046 100 34 68 1 1978858128 39965024 11450880
17:54:47 26000 8192000000 10876428048 11329458176 1916421040 18.958 100 18 36 0 1965659744 43083472 6155232
17:55:20 28478 8192000000 10848247424 11315044352 1874617344 18.622 98 8 16 0 1911008592 33202240 3189008
17:55:55 43917 8192000000 10864894288 11312709632 1887340832 18.724 98 21 41 1 1910651824 17215472 6095520
17:56:50 34055 8192000000 10876250416 11328315392 1931547920 19.079 100 12 25 0 1951671200 16604528 3518752
17:57:30 41610 8192000000 10891295216 11343667200 1932114960 19.084 100 15 29 1 1959165600 22675600 4375040
17:58:18 36442 8192000000 10880024448 11357577216 1920897600 18.994 99 11 22 0 1949394128 25303888 3192640
17:59:00 90357 8192000000 10885283712 11320160256 1903309216 18.853 98 19 36 2 1924608384 14732976 6566192
18:00:47 37119 8192000000 10884566928 11338137600 1918284448 18.973 98 11 22 0 1928173984 7350144 2539392
18:01:40 110134 8192000000 10893640992 11348586496 1923171456 19.012 98 27 54 0 1943353760 12555472 7626832
18:04:20 49415 8192000000 10901022192 11361484800 1960162048 19.307 100 21 42 0 1977617184 11410784 6044352
18:05:25 72705 8192000000 10929810480 11375951872 1984439168 19.500 100 37 72 0 2006716528 10944656 11332704
18:06:45 52570 8192000000 10932398656 11388571648 1991449728 19.555 100 35 71 0 2017215536 15996656 9769152
18:07:51 49897 8192000000 10922032800 11388022784 1991538816 19.556 100 29 57 1 2014278656 13937392 8802448
18:08:51 79607 8192000000 10931798448 11391979520 1962918944 19.329 98 22 44 2 1982847296 13398256 6530096
18:10:18 38994 8192000000 10927889472 11393961984 1976481328 19.437 99 17 33 1 1996172304 14224960 5466016
18:11:18 34369 8192000000 10933020272 11384250368 1983829792 19.495 100 28 56 0 2014092448 21588864 8673792
18:12:21 22351 8192000000 10925948912 11390255104 1984837360 19.503 100 27 54 0 2019103888 25147760 9118768
18:12:57 17927 8192000000 10911660928 11385241600 1978427024 19.452 100 18 36 0 2002693648 18633856 5632768
18:13:23 17892 8192000000 10905397600 11391475712 1975249360 19.427 100 6 12 0 1992872256 15734496 1888400
18:13:51 21203 8192000000 10900346000 11382587392 1979614464 19.462 100 11 22 0 1993053552 10319056 3120032
18:14:18 25460 8192000000 10889818000 11374804992 1959433824 19.302 99 7 14 0 1972355088 11281600 1639664
18:14:54 22892 8192000000 10890148528 11361214464 1953844992 19.257 99 12 24 1 1963867840 7021248 3001600
18:15:27 28504 8192000000 10905110800 11366379520 1979723472 19.463 100 29 58 2 1994079088 6869520 7486096
18:16:03 39401 8192000000 10908188608 11377737728 1983601808 19.493 100 13 26 0 1994624592 7594128 3428656
18:16:59 40852 8192000000 10890067712 11358232576 1946971280 19.202 98 21 40 3 1962900320 10134032 5795008
18:17:46 72762 8192000000 10896037504 11379638272 1963162464 19.331 99 15 27 3 1980042192 12435344 4444384
18:19:04 37954 8192000000 10899325024 11379838976 1956951520 19.282 99 7 14 0 1972182176 13303664 1926992
18:19:51 67458 8192000000 10890712048 11372224512 1939840784 19.145 98 11 22 2 1957633920 14723440 3069696
18:21:05 41368 8192000000 10862254928 11330719744 1873442576 18.612 95 17 34 0 1891227248 13113760 4670912
18:21:53 59487 8192000000 10846610976 11335884800 1899762416 18.824 98 10 18 1 1911542016 9064576 2715024
18:23:05 60631 8192000000 10848712576 11319144448 1888188576 18.731 97 13 25 1 1899729728 7863968 3677184
18:24:13 23223 8192000000 10858314320 11321421824 1908877872 18.898 98 36 70 0 1927141696 8151776 10112048
18:24:42 22367 8192000000 10861697456 11317456896 1912293776 18.925 99 33 66 1 1928847504 7639168 8914560
18:25:16 24798 8192000000 10847407568 11306123264 1883858560 18.696 98 37 74 1 1903831808 9381776 10591472
18:25:47 61705 8192000000 10831921328 11308089344 1891810544 18.760 99 18 36 0 1907382272 10630352 4941376
18:26:55 41372 8192000000 10860447248 11323777024 1894918544 18.785 98 21 42 0 1910615280 9604624 6092112
18:27:42 46642 8192000000 10863520144 11328954368 1906935920 18.882 98 17 34 1 1921612000 9903632 4772448
18:29:02 46926 8192000000 10836400592 11312640000 1859280960 18.497 96 21 42 2 1875515136 10547984 5686192
18:29:58 62640 8192000000 10851026048 11310403584 1844369200 18.376 96 11 20 0 1854727536 7745104 2613232
18:31:09 72285 8192000000 10859395856 11324514304 1840867632 18.348 95 16 32 1 1858234192 12570928 4795632
18:33:28 35872 8192000000 10848089712 11304996864 1849575472 18.419 96 38 76 1 1867666832 7629088 10462272
18:34:13 15277 8192000000 10873234928 11316781056 1923991136 19.019 100 38 75 2 1944156576 9938720 10226720
18:34:35 14799 8192000000 10875413360 11323252736 1931034544 19.075 100 43 85 0 1953850704 11233024 11583136
18:34:58 13149 8192000000 10879161872 11325022208 1917043216 18.963 99 41 82 1 1938931360 11055232 10832912
18:35:26 89650 8192000000 10847064464 11316838400 1826902320 18.234 94 23 46 1 1849132528 15841888 6388320
18:37:02 112530 8192000000 10842859088 11310907392 1875569536 18.629 97 16 32 0 1890595040 10996704 4028800
18:39:13 70529 8192000000 10836110080 11305820160 1871174864 18.594 97 13 26 1 1884047088 8767152 4105072
18:40:30 10684 8192000000 10856507888 11320463360 1927886528 19.050 100 31 62 0 1947476592 11039296 8550768
18:40:47 34794 8192000000 10850166272 11323064320 1907751920 18.889 99 24 48 1 1930779312 16648496 6378896
18:41:37 45220 8192000000 10856922864 11340849152 1933689328 19.096 100 9 18 0 1946507920 10219104 2599488
18:42:28 68815 8192000000 10859871424 11336642560 1944603008 19.183 100 11 22 1 1956235376 8591120 3041248
18:44:04 71936 8192000000 10825823344 11303186432 1865167808 18.545 96 17 34 2 1881723616 11312048 5243760
18:45:22 57306 8192000000 10860586880 11328839680 1933304752 19.093 100 18 34 1 1946406096 8214656 4886688
18:46:26 68719 8192000000 10835469152 11322605568 1880955568 18.673 97 9 18 1 1890652480 6966256 2730656
18:47:41 49573 8192000000 10839156272 11311820800 1879824928 18.664 97 11 23 0 1888875008 6399632 2650448
18:48:37 46981 8192000000 10869921856 11341430784 1934008784 19.099 100 24 47 2 1948812432 8334192 6469456
18:49:38 25723 8192000000 10898184512 11348451328 1902859584 18.849 98 19 38 0 1915259600 7115232 5284784
18:50:10 36246 8192000000 10863619504 11338489856 1925455488 19.031 99 17 34 1 1941960720 11102560 5402672
18:50:53 46900 8192000000 10871208128 11338309632 1905272848 18.869 98 18 36 0 1923539120 13531392 4734880
18:52:06 101252 8192000000 10888384656 11366809600 1947561104 19.207 100 12 24 0 1972550880 21653888 3335888
18:54:02 65262 8192000000 10891726496 11358822400 1935385712 19.110 99 16 32 1 1948707696 9070512 4251472
18:55:15 12017 8192000000 10911395504 11371335680 1967999872 19.370 100 37 74 1 1988803536 9838832 10964832
18:55:33 37634 8192000000 10905690752 11377049600 1976993632 19.441 100 39 78 1 2001486128 13222400 11270096
18:57:43 38839 8192000000 10912017984 11378212864 1954917056 19.266 99 36 72 0 1973578048 8989232 9671760
18:58:36 42339 8192000000 10892345600 11374796800 1966653648 19.359 100 19 38 1 1986073072 14293824 5125600
18:59:25 68920 8192000000 10909878928 11380322304 1976334320 19.436 100 12 24 1 1989039936 10116336 2589280
19:00:42 5348 8192000000 10953054928 11393036288 1997010592 19.599 100 72 146 2 2026438768 7638736 21789440
19:00:54 105132 8192000000 10934595344 11401502720 2000877824 19.630 100 53 106 1 2027173952 11043968 15252160
19:02:45 70909 8192000000 10904229472 11392880640 1971349008 19.396 99 16 32 1 1984805472 9428640 4027824
19:04:02 34390 8192000000 10891275056 11387179008 1969031872 19.378 99 9 16 2 1980468160 9283008 2153280
19:04:46 54012 8192000000 10906381376 11391143936 1987204816 19.522 100 6 12 3 1996291216 7399456 1686944
19:05:51 56107 8192000000 10900877952 11383885824 1955594512 19.271 98 11 22 0 1966447776 7308192 3545072
19:06:55 51389 8192000000 10909405936 11382685696 1979703216 19.462 99 19 38 0 1995873616 10584896 5585504
19:07:53 103085 8192000000 10913426208 11395829760 1977641712 19.446 99 9 18 1 1993600496 13686064 2272720
19:09:45 63516 8192000000 10895976784 11378651136 1928081520 19.052 97 14 28 0 1941035424 8723536 4230368
19:10:56 80220 8192000000 10869227648 11345584128 1805431616 18.058 91 15 30 0 1819063536 9629664 4002256
19:12:22 58555 8192000000 10886268464 11360641024 1952004128 19.242 100 19 38 2 1966371040 9174912 5192000
19:13:27 72364 8192000000 10839857216 11319857152 1824974336 18.218 93 17 34 0 1842244432 11792688 5477408
19:14:46 77438 8192000000 10877133888 11357028352 1916223152 18.957 98 22 44 3 1937744736 15345856 6175728
19:16:10 61617 8192000000 10853040608 11327877120 1869210304 18.578 96 16 32 1 1888904128 15117392 4576432
19:17:24 70274 8192000000 10872531456 11346432000 1879697808 18.663 96 20 40 2 1900592768 14895680 5999280
19:18:43 53959 8192000000 10850342640 11309494272 1794460352 17.968 93 26 52 0 1813741632 12281568 6999712
19:19:47 46713 8192000000 10847026464 11305115648 1862785456 18.526 97 28 56 2 1880266736 9725264 7756016
19:20:43 43865 8192000000 10861193568 11330211840 1929126496 19.060 100 40 80 1 1950938640 10558768 11253376
19:22:07 50316 8192000000 10850286960 11317129216 1898724736 18.816 98 29 56 2 1914012848 7281328 8006784
19:23:06 38645 8192000000 10869589616 11325341696 1906781216 18.881 98 44 86 3 1926615632 8405728 11428688
19:23:51 41931 8192000000 10838215248 11318919168 1927026080 19.043 100 25 50 1 1942807648 9079808 6701760
19:24:39 31172 8192000000 10830126784 11308560384 1906819648 18.881 99 6 12 0 1916605648 7834784 1951216
19:25:20 67100 8192000000 10858237440 11331878912 1895422320 18.789 98 13 25 1 1909985680 10126800 4436560
19:26:34 56574 8192000000 10842540544 11325558784 1911213584 18.916 99 13 26 1 1932158896 16830032 4115280

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 21-06-2021 19:30:01 to 21-06-2021 19:30:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 120 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-06-2021 19:30:34 to 21-06-2021 19:30:36.

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          247065
MON$OLDEST_ACTIVE               248829
MON$OLDEST_SNAPSHOT             248829
MON$NEXT_TRANSACTION            248829
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                       2026592
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:159: 
:160: mscs-test-161.budzdorov.ru    Mon Jun 21 19:27:48 2021
:161:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:162: 
:163: 
:164: mscs-test-161.budzdorov.ru    Mon Jun 21 19:27:56 2021
:165:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:166: 
:167: 
:168: mscs-test-161.budzdorov.ru    Mon Jun 21 19:27:59 2021
:169:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:170: 
:171: 
:172: mscs-test-161.budzdorov.ru    Mon Jun 21 19:27:59 2021
:173:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:174: 
--- end of diff output ---

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

21.06.21 19:30:37. 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-21 19:30:39 No severe PSQL-related problems occured
21.06.21 19:30:41. End of report.