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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17220140 kB
MemAvailable 31160096 kB
Buffers 0 kB
Cached 14440620 kB
SwapCached 4780 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-02-09 19:27:18
DTS_END                         2021-02-09 19:27:18.2490
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/56754
TRN_ID                          246174
ATT_ID                          685
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: 8963.30 21546 1075596
customer order: creation 178.90 380 21468
customer order: refuse 15.63 334 1875
order to supplier: creation 46.23 1263 5547
order to supplier: removal 3.23 107096 388
invoice (draft): creation 48.41 3747 5809
invoice (draft): removal 47.21 831 5665
invoice accept: apply 43.84 17099 5261
invoice accept: cancel 42.74 823 5129
customer reserve: creation 4029.73 169 483567
customer reserve: removal 4212.31 65 505477
realization accept: apply 87.10 170 10452
realization accept: cancel 75.55 114 9066
payment from customer: creation 60.27 107 7232
payment from customer: removal 6.00 68 720
payment to supplier: creation 50.08 114 6009
payment to supplier: removal 3.60 99 432
service: total inventory turnovers 5.09 968 611
service: total monetary turnovers 6.54 49 785
service: aggregate perf. data 0.83 19005 99
service: refresh index statistics 0.03 278415 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-02-2021 19:28:26 to 09-02-2021 19:28:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4060
TEST_TIME 2 3890
TEST_TIME 3 4755
TEST_TIME 4 4119
TEST_TIME 5 4512
TEST_TIME 6 4822
TEST_TIME 7 4668
TEST_TIME 8 4924
TEST_TIME 9 5224
TEST_TIME 10 5257
TEST_TIME 11 5532
TEST_TIME 12 5771
TEST_TIME 13 5940
TEST_TIME 14 6207
TEST_TIME 15 6314
TEST_TIME 16 6429
TEST_TIME 17 7110
TEST_TIME 18 7577
TEST_TIME 19 7872
TEST_TIME 20 8500
TEST_TIME 21 8735
TEST_TIME 22 9127
TEST_TIME 23 9413
TEST_TIME 24 9513
TEST_TIME 25 10577
TEST_TIME 26 10842
TEST_TIME 27 11297
TEST_TIME 28 11124
TEST_TIME 29 10926
TEST_TIME 30 10729
TEST_TIME 31 10675
TEST_TIME 32 10563
TEST_TIME 33 10355
TEST_TIME 34 10096
TEST_TIME 35 10057
TEST_TIME 36 9982
TEST_TIME 37 9823
TEST_TIME 38 9752
TEST_TIME 39 9677
TEST_TIME 40 9585
TEST_TIME 41 9544
TEST_TIME 42 9510
TEST_TIME 43 9525
TEST_TIME 44 9580
TEST_TIME 45 9461
TEST_TIME 46 9310
TEST_TIME 47 9381
TEST_TIME 48 9282
TEST_TIME 49 9303
TEST_TIME 50 9261
TEST_TIME 51 9318
TEST_TIME 52 9478
TEST_TIME 53 9466
TEST_TIME 54 9440
TEST_TIME 55 9475
TEST_TIME 56 9539
TEST_TIME 57 9486
TEST_TIME 58 9469
TEST_TIME 59 9578
TEST_TIME 60 9653
TEST_TIME 61 9592
TEST_TIME 62 9466
TEST_TIME 63 9416
TEST_TIME 64 9345
TEST_TIME 65 9332
TEST_TIME 66 9301
TEST_TIME 67 9226
TEST_TIME 68 9149
TEST_TIME 69 9199
TEST_TIME 70 9149
TEST_TIME 71 9084
TEST_TIME 72 9102
TEST_TIME 73 9113
TEST_TIME 74 9175
TEST_TIME 75 9147
TEST_TIME 76 9164
TEST_TIME 77 9166
TEST_TIME 78 9137
TEST_TIME 79 9247
TEST_TIME 80 9229
TEST_TIME 81 9231
TEST_TIME 82 9214
TEST_TIME 83 9310
TEST_TIME 84 9344
TEST_TIME 85 9309
TEST_TIME 86 9288
TEST_TIME 87 9235
TEST_TIME 88 9200
TEST_TIME 89 9165
TEST_TIME 90 9167
TEST_TIME 91 9111
TEST_TIME 92 9055
TEST_TIME 93 9054
TEST_TIME 94 9036
TEST_TIME 95 9098
TEST_TIME 96 9064
TEST_TIME 97 9065
TEST_TIME 98 9169
TEST_TIME 99 9174
TEST_TIME 100 9204
TEST_TIME 101 9240
TEST_TIME 102 9225
TEST_TIME 103 9208
TEST_TIME 104 9227
TEST_TIME 105 9275
TEST_TIME 106 9275
TEST_TIME 107 9262
TEST_TIME 108 9194
TEST_TIME 109 9142
TEST_TIME 110 9146
TEST_TIME 111 9154
TEST_TIME 112 9111
TEST_TIME 113 9088
TEST_TIME 114 9046
TEST_TIME 115 9010
TEST_TIME 116 9010
TEST_TIME 117 9002
TEST_TIME 118 9001
TEST_TIME 119 9015
TEST_TIME 120 8965

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-02-2021 19:28:30 to 09-02-2021 19:28:33.

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 1520684 1520684 0 0.00 0 11925 6 0 0
doc_list_biud 1520684 1520684 0 0.00 0 30601 27 0 0
sp_add_invoice_to_stock 5363 5261 102 1.90 33 155439 17100 0 102
sp_cancel_adding_invoice 5129 5129 0 0.00 5 67605 823 0 0
sp_cancel_client_order 1875 1875 0 0.00 5 16215 334 0 0
sp_cancel_customer_reserve 505477 505477 0 0.00 1 30602 66 0 0
sp_cancel_pay_from_customer 720 720 0 0.00 3 2951 68 0 0
sp_cancel_pay_to_supplier 432 432 0 0.00 3 6017 100 0 0
sp_cancel_supplier_invoice 5674 5665 9 0.15 1 11829 831 0 9
sp_cancel_supplier_order 388 388 0 0.00 6 1210520 107096 0 0
sp_cancel_write_off 9066 9066 0 0.00 1 9572 114 0 0
sp_client_order 21468 21468 0 0.00 4 29382 380 0 0
sp_customer_reserve 483567 483567 0 0.00 0 60635 169 0 0
sp_fill_shopping_cart 32788 32788 0 0.00 1 18564 42 0 0
sp_fill_shopping_cart_clo_res 483562 483562 0 0.00 0 25337 14 0 0
sp_get_clo_for_invoice 5253 5253 0 0.00 0 36948 317 0 0
sp_kill_cost_storno 15347 15347 0 0.00 0 10662 56 0 0
sp_kill_qstorno_ret_qs2qd 1026073 1026073 0 0.00 0 30414 35 0 0
sp_kill_qty_storno 543305 543305 0 0.00 0 30601 76 0 0
sp_lock_selected_doc 21708 21708 0 0.00 0 11287 8 0 0
sp_make_cost_storno 28946 28946 0 0.00 0 11513 49 0 0
sp_multiply_rows_for_pdistr 28946 28946 0 0.00 0 11289 26 0 0
sp_multiply_rows_for_qdistr 21468 21468 0 0.00 0 15822 169 0 0
sp_pay_from_customer 7232 7232 0 0.00 4 12516 108 0 0
sp_pay_to_supplier 6009 6009 0 0.00 5 12088 115 0 0
sp_payment_common 13241 13241 0 0.00 1 12510 27 0 0
sp_qd_handle_on_cancel_clo 1875 1875 0 0.00 0 16149 313 0 0
sp_qd_handle_on_invoice_upd_sts 10382 10382 0 0.00 0 25594 324 0 0
sp_qd_handle_on_reserve_upd_sts 10452 10452 0 0.00 0 13927 61 0 0
sp_reserve_write_off 10452 10452 0 0.00 6 13945 171 0 0
sp_supplier_invoice 5809 5809 0 0.00 5 85499 3747 0 0
sp_supplier_order 5547 5547 0 0.00 4 21468 1264 0 0
srv_aggregate_perf_data 99 99 0 0.00 3341 193634 19006 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1135 190622 32899 0 0
srv_find_qd_qs_mism 1024818 1024818 0 0.00 0 9524 6 0 0
srv_make_invnt_saldo 611 611 0 0.00 32 65480 969 0 0
srv_make_money_saldo 785 785 0 0.00 1 19062 49 0 0
srv_recalc_idx_stat 4 4 0 0.00 176967 342376 278416 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 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 5261 5261 0 0.00 0 7679 152 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 0 2660 74 0 0
t$perf-norm:sp_cancel_client_order 1875 1875 0 0.00 0 4368 15 0 0
t$perf-norm:sp_cancel_customer_reserve 707 707 0 0.00 0 1972 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 720 720 0 0.00 0 2425 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 432 432 0 0.00 0 500 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 395 395 0 0.00 0 1897 17 0 0
t$perf-norm:sp_cancel_supplier_order 388 388 0 0.00 0 20626 1480 0 0
t$perf-norm:sp_cancel_write_off 1069 1069 0 0.00 0 2881 11 0 0
t$perf-norm:sp_client_order 21468 21468 0 0.00 0 7018 14 0 0
t$perf-norm:sp_customer_reserve 1052 1052 0 0.00 0 1125 5 0 0
t$perf-norm:sp_pay_from_customer 7232 7232 0 0.00 0 4549 7 0 0
t$perf-norm:sp_pay_to_supplier 6009 6009 0 0.00 0 3999 9 0 0
t$perf-norm:sp_reserve_write_off 10452 10452 0 0.00 0 7009 11 0 0
t$perf-norm:sp_supplier_invoice 5809 5809 0 0.00 0 5627 16 0 0
t$perf-norm:sp_supplier_order 5547 5547 0 0.00 0 4836 15 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 163 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 686 8 0 0
t$perf-norm:srv_make_invnt_saldo 611 611 0 0.00 0 1470 19 0 0
t$perf-norm:srv_make_money_saldo 785 785 0 0.00 0 2212 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 15 6 0 0
v_add_invoice_to_stock 10710 10506 204 1.90 0 7385 18 0 204
v_all_customers 38632 38632 0 0.00 0 61 1 0 0
v_all_suppliers 31138 31138 0 0.00 0 73 1 0 0
v_all_wares 42934 42934 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 4849 14 0 0
v_cancel_client_order 3750 3750 0 0.00 0 4829 4 0 0
v_cancel_customer_prepayment 1440 1440 0 0.00 0 1465 5 0 0
v_cancel_customer_reserve 1414 1414 0 0.00 0 1420 5 0 0
v_cancel_payment_to_supplier 864 864 0 0.00 0 2037 8 0 0
v_cancel_supplier_invoice 808 790 18 2.22 0 1384 18 0 18
v_cancel_supplier_order 776 776 0 0.00 0 1673 10 0 0
v_cancel_write_off 2138 2138 0 0.00 0 4456 18 0 0
v_max_id_clo_ord 5545 5545 0 0.00 0 1707 1 0 0
v_max_id_clo_res 1052 1052 0 0.00 0 3218 15 0 0
v_max_id_ord_sup 5776 5776 0 0.00 0 6210 7 0 0
v_max_non_paid_invoice 1761 1761 0 0.00 0 1246 3 0 0
v_max_non_paid_realizn 4077 4077 0 0.00 0 3179 4 0 0
v_min_id_clo_ord 5545 5545 0 0.00 0 1762 5 0 0
v_min_id_clo_res 1052 1052 0 0.00 0 3028 7 0 0
v_min_id_ord_sup 5776 5776 0 0.00 0 7861 10 0 0
v_min_non_paid_invoice 6009 6009 0 0.00 0 6168 17 0 0
v_min_non_paid_realizn 7232 7232 0 0.00 0 5670 13 0 0
v_our_firm 10612 10612 0 0.00 0 18 1 0 0
v_reserve_write_off 20904 20904 0 0.00 0 4235 6 0 0
x_lock_depdocs_on_canc_invoice 10399 10399 0 0.00 0 28283 137 0 0
x_lock_depdocs_on_canc_sup_ord 388 388 0 0.00 0 18110 446 0 0
x_make_qstorno_1000_1200 5547 5547 0 0.00 1 21460 1192 0 0
x_make_qstorno_1200_2000 5809 5809 0 0.00 2 80762 3575 0 0
x_make_qstorno_2100_3300 483567 483567 0 0.00 0 60631 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-02-2021 19:28:34 to 09-02-2021 19:28:38.

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:22 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:28 10450 8192000000 10183648688 10488725504 895011120 9.849 72 46 91 0 912937888 2417744 15509024
16:57:48 28189 8192000000 10331650656 10643042304 1374571360 14.368 100 92 182 1 1410154128 4470048 31112720
16:58:25 25777 8192000000 10358788112 10678362112 1413617664 14.716 100 85 170 0 1447568544 5547056 28403824
16:58:58 27178 8192000000 10388470560 10710147072 1438464400 14.936 100 89 178 0 1474486048 6488768 29532880
16:59:36 16049 8192000000 10403048448 10730393600 1458318768 15.111 100 88 176 0 1494793376 7202544 29272064
17:00:00 28391 8192000000 10416230624 10750124032 1472482304 15.236 100 83 166 0 1507205168 7765552 26957312
17:00:44 14267 8192000000 10456700416 10791301120 1512272624 15.583 100 88 176 1 1548539936 8450448 27816864
17:01:08 6721 8192000000 10470770592 10805817344 1524546496 15.690 100 85 170 0 1560500160 8944048 27009616
17:01:22 17710 8192000000 10479942304 10823380992 1533143072 15.764 100 84 168 1 1569413008 9479904 26790032
17:01:48 8888 8192000000 10500808688 10851131392 1564483824 16.035 100 81 162 1 1599088112 9522784 25081504
17:02:06 17112 8192000000 10530833248 10884530176 1582386064 16.189 100 74 148 0 1614851536 10012208 22453264
17:02:32 13427 8192000000 10549969440 10908483584 1613302448 16.453 100 71 142 0 1643980064 9289184 21388432
17:02:59 9382 8192000000 10566522496 10931568640 1636715984 16.652 100 74 148 0 1668637488 10090608 21830896
17:03:29 9853 8192000000 10605622448 10971172864 1669598896 16.930 100 79 158 2 1704191232 11392480 23199856
17:03:49 8781 8192000000 10627008816 10993745920 1685780848 17.066 100 76 152 0 1719345200 11512288 22052064
17:04:06 8876 8192000000 10651450352 11023585280 1705641328 17.232 100 76 151 1 1738960144 11356384 21962432
17:04:23 5993 8192000000 10664565488 11039539200 1730003776 17.436 100 76 148 3 1763485312 11926496 21555040
17:04:36 5399 8192000000 10683767904 11059355648 1747505200 17.581 100 81 162 2 1782811248 12057328 23248720
17:04:50 5518 8192000000 10704744880 11079024640 1765251056 17.728 100 82 164 3 1800848608 12901984 22695568
17:05:02 6565 8192000000 10703296864 11082092544 1772780240 17.790 100 81 162 2 1808530640 13651840 22098560
17:05:16 4656 8192000000 10727888368 11105759232 1785123104 17.892 100 87 175 3 1823460560 13920432 24417024
17:05:28 4409 8192000000 10729830592 11107794944 1788219328 17.917 100 85 171 0 1826389904 14733584 23436992
17:05:40 3955 8192000000 10739615920 11116093440 1791830256 17.947 100 85 167 0 1829445680 14525184 23090240
17:05:51 3291 8192000000 10741430208 11120320512 1797698864 17.995 100 90 176 3 1836287424 14199824 24388736
17:06:02 4959 8192000000 10739910544 11123982336 1803815840 18.045 100 86 172 3 1842465008 14605696 24043472
17:06:14 1872 8192000000 10752556688 11136339968 1810714160 18.102 100 88 173 0 1850276480 14704528 24857792
17:06:23 2336 8192000000 10758021952 11139080192 1819634384 18.175 100 91 181 1 1862078448 17525856 24918208
17:06:32 7776 8192000000 10753704176 11138379776 1822262448 18.196 100 86 171 0 1858908528 13118224 23527856
17:06:48 5783 8192000000 10760539232 11148070912 1823016304 18.202 100 81 162 1 1859449984 14189488 22244192
17:07:00 2669 8192000000 10783690160 11168661504 1840159664 18.342 100 91 180 2 1879490080 15366960 23963456
17:07:09 1975 8192000000 10796013024 11179458560 1845099904 18.382 100 94 188 3 1891924000 20295248 26528848
17:07:18 1958 8192000000 10793447952 11177869312 1845206768 18.383 100 94 187 2 1886518368 14459632 26851968
17:07:26 1306 8192000000 10795837296 11180523520 1849280352 18.416 100 94 188 1 1891641040 15578416 26782272
17:07:34 2245 8192000000 10796691920 11187650560 1857713920 18.485 100 90 180 1 1897245712 14150048 25381744
17:07:43 1582 8192000000 10804583568 11188875264 1861090224 18.512 100 93 187 2 1900200656 12684016 26426416
17:07:51 1588 8192000000 10805158912 11189915648 1859955936 18.503 100 93 186 1 1899861264 13854528 26050800
17:07:59 1904 8192000000 10814033152 11200327680 1867017088 18.560 100 95 190 1 1906665600 12454176 27194336
17:08:07 1609 8192000000 10809509008 11199340544 1868692544 18.574 100 88 176 1 1906332528 12037824 25602160
17:08:15 2235 8192000000 10814061456 11206778880 1874952944 18.624 100 83 162 1 1909457888 10826064 23678880
17:08:23 23492 8192000000 10808324416 11203059712 1872489840 18.604 100 72 143 1 1902626240 10128720 20007680
17:08:53 16713 8192000000 10807520624 11203846144 1870797328 18.591 100 51 100 0 1893969264 9667920 13504016
17:09:17 8174 8192000000 10803804512 11206311936 1871060672 18.593 100 41 82 0 1891366704 9075056 11230976
17:09:33 7342 8192000000 10790254848 11211677696 1873526896 18.613 100 37 74 1 1892143904 8160384 10456624
17:09:53 7176 8192000000 10813514000 11214782464 1876747120 18.639 100 37 74 3 1898406640 11095584 10563936
17:10:08 10430 8192000000 10792878320 11215290368 1879883312 18.664 100 30 60 3 1895077936 6858160 8336464
17:10:24 5312 8192000000 10805352784 11219177472 1883701584 18.695 100 35 69 1 1899470272 6105280 9663408
17:10:36 9034 8192000000 10787404592 11216580608 1881630688 18.678 100 14 26 1 1891005568 5960240 3414640
17:10:52 7734 8192000000 10792215344 11222802432 1884854640 18.704 100 20 40 2 1897207232 6830480 5522112
17:11:06 8035 8192000000 10784596096 11220594688 1883994208 18.697 100 15 30 0 1893874672 5389456 4491008
17:11:24 11568 8192000000 10794847280 11222859776 1886321728 18.716 100 19 39 0 1898693152 6487472 5883952
17:11:42 21834 8192000000 10790029984 11228045312 1887237472 18.724 100 14 28 1 1896805776 6155040 3413264
17:12:11 18637 8192000000 10790969904 11226845184 1891585872 18.759 100 27 52 1 1905154400 5800704 7767824
17:12:36 49720 8192000000 10834162128 11242598400 1892207264 18.764 100 40 80 2 1908780480 4587344 11985872
17:13:32 9696 8192000000 10805770128 11236397056 1890037744 18.746 100 19 38 0 1902100864 6702336 5360784
17:13:53 5068 8192000000 10813223040 11243577344 1894722816 18.784 100 30 57 1 1909765856 6350288 8692752
17:14:05 6396 8192000000 10819781760 11246231552 1896310160 18.797 100 32 64 2 1911431728 6386624 8734944
17:14:18 3852 8192000000 10816165568 11245379584 1897926048 18.810 100 29 57 0 1912275712 6661248 7688416
17:14:30 4391 8192000000 10809556928 11237699584 1877629840 18.646 99 29 58 1 1892406736 6371840 8405056
17:14:40 4853 8192000000 10814858576 11245481984 1897737584 18.808 100 33 65 3 1913373024 6487440 9148000
17:14:57 9684 8192000000 10816131488 11248508928 1900351552 18.829 100 17 34 0 1914726912 9565104 4810256
17:15:13 13658 8192000000 10811374752 11247775744 1884241360 18.699 99 18 37 0 1894974448 5376384 5356704
17:15:37 8427 8192000000 10809249344 11247153152 1884427040 18.701 99 20 40 0 1895680656 5819584 5434032
17:15:52 11239 8192000000 10801869008 11236155392 1880074592 18.666 99 16 32 0 1890334240 5223600 5036048
17:16:10 4787 8192000000 10806637104 11239227392 1879629168 18.662 99 24 48 4 1892693744 6578896 6485680
17:16:23 10118 8192000000 10799874624 11231698944 1884034928 18.698 100 22 45 0 1896498048 5872432 6590688
17:16:42 15886 8192000000 10800188416 11214245888 1834955232 18.300 97 16 32 2 1845123328 5716256 4451840
17:17:05 74398 8192000000 10745840464 11173982208 1667378048 16.911 88 21 43 0 1677478416 4356640 5743728
17:18:26 7621 8192000000 10734378960 11158470656 1791184512 17.942 98 22 44 0 1802977488 5526144 6266832
17:18:40 6352 8192000000 10741363392 11159171072 1792958528 17.956 98 26 52 0 1807604384 5715440 8930416
17:18:54 3410 8192000000 10757817776 11176079360 1832709648 18.281 100 42 83 0 1851239888 7206096 11324144
17:19:06 6508 8192000000 10721642112 11146657792 1771916928 17.783 97 25 50 2 1784420096 5601152 6902016
17:19:21 6122 8192000000 10708191376 11130327040 1758588368 17.673 97 31 60 1 1777206688 10100576 8517744
17:19:37 5912 8192000000 10710887024 11124101120 1787783504 17.914 100 30 60 0 1803025296 6492768 8749024
17:19:53 7117 8192000000 10724378592 11135385600 1767610576 17.747 98 25 50 0 1780740800 6085392 7044832
17:20:09 11418 8192000000 10720229984 11136548864 1756037968 17.652 97 22 44 2 1767779104 5253072 6488064
17:20:30 6993 8192000000 10697988736 11097595904 1699387360 17.180 94 28 56 0 1716839840 9417360 8035120
17:20:44 8621 8192000000 10718579440 11137654784 1794861232 17.972 100 22 44 0 1806532480 5413328 6257920
17:21:03 11601 8192000000 10721007232 11136897024 1744450976 17.556 96 26 54 2 1757276848 5196672 7629200
17:21:21 5776 8192000000 10732359264 11149459456 1808177808 18.081 100 28 56 0 1822401936 6161936 8062192
17:21:33 19522 8192000000 10697390176 11120463872 1729983376 17.435 95 37 74 2 1745376800 5845232 9548192
17:21:59 52283 8192000000 10731578896 11159535616 1817246032 18.155 100 33 65 0 1836098048 9168896 9683120
17:22:58 11828 8192000000 10752087696 11173396480 1830352656 18.262 100 18 36 1 1844702688 9606240 4743792
17:23:19 5718 8192000000 10761636832 11178643456 1837490672 18.320 100 40 80 0 1855927936 7297168 11140096
17:23:32 4574 8192000000 10744418880 11174055936 1834911104 18.299 100 28 55 0 1849035888 5207152 8917632
17:23:45 8511 8192000000 10758908288 11186741248 1847417424 18.401 100 34 68 0 1864160928 6716256 10027248
17:24:03 4891 8192000000 10755719024 11184553984 1845042256 18.382 100 25 51 2 1858919920 5845248 8032416
17:24:17 8843 8192000000 10769044736 11195244544 1853538128 18.451 100 24 49 1 1866649280 5739104 7372048
17:24:33 4985 8192000000 10771865152 11204542464 1858237344 18.489 100 26 53 0 1872315936 6595264 7483328
17:24:47 7924 8192000000 10765984512 11200290816 1859720768 18.501 100 27 53 2 1873167952 5709120 7738064
17:25:03 7791 8192000000 10770906272 11206873088 1862567392 18.524 100 21 42 0 1874551776 5329952 6654432
17:25:20 8799 8192000000 10779102560 11210051584 1867109040 18.561 100 33 66 1 1883044352 6061264 9874048
17:25:36 9616 8192000000 10782636448 11210891264 1865684016 18.549 100 19 40 1 1876424832 5172416 5568400
17:25:52 13292 8192000000 10771515936 11210817536 1869195344 18.578 100 18 36 0 1880282816 6296464 4791008
17:26:15 13812 8192000000 10775985392 11214290944 1865760800 18.550 100 9 18 0 1873467952 5129552 2577600
17:26:40 107916 8192000000 10810180208 11242864640 1880905456 18.672 100 40 79 0 1898940432 4821392 13213584
17:28:36 8592 8192000000 10839515392 11256823808 1906709568 18.880 100 40 80 0 1926398112 9076944 10611600
17:28:52 6671 8192000000 10861926832 11277185024 1917850208 18.970 100 49 99 0 1942047664 9867008 14330448
17:29:11 10941 8192000000 10867608160 11285413888 1923942080 19.018 100 56 112 1 1950677888 10734672 16001136
17:29:30 25462 8192000000 10860406608 11290030080 1932177072 19.084 100 55 111 0 1961512208 14056112 15279024
17:30:06 10873 8192000000 10880640192 11307503616 1938479488 19.135 100 45 90 1 1966833200 15545744 12807968
17:30:29 18132 8192000000 10877374496 11310702592 1928988080 19.059 99 43 85 0 1958499088 17170608 12340400
17:30:59 20868 8192000000 10901994608 11324674048 1951184336 19.236 100 58 116 0 1987749488 20162944 16402208
17:31:28 12685 8192000000 10906549536 11329458176 1955364608 19.269 100 56 112 0 1996266736 24115904 16786224
17:31:58 13990 8192000000 10916071376 11341381632 1961188960 19.315 100 61 120 2 2003648928 25198176 17261792
17:32:19 21513 8192000000 10914693104 11342954496 1964571856 19.342 100 53 106 2 2007504336 27507776 15424704
17:32:53 21142 8192000000 10919994208 11353194496 1968061728 19.370 100 42 85 1 2009086848 28878384 12146736
17:33:23 11537 8192000000 10926365728 11359715328 1977955328 19.449 100 54 104 1 2021841184 27877760 16008096
17:33:42 6933 8192000000 10934858096 11365953536 1983906624 19.496 100 55 108 3 2028281504 27909648 16465232
17:33:56 13921 8192000000 10933775232 11367727104 1985768656 19.510 100 51 102 1 2030174144 28664560 15740928
17:34:19 6657 8192000000 10951180160 11380301824 1989531024 19.540 100 56 111 2 2040120880 34103536 16486320
17:34:35 6779 8192000000 10950652864 11382235136 1991872096 19.559 100 62 123 1 2042831088 32312288 18646704
17:34:53 24995 8192000000 10956243824 11387125760 1999421008 19.618 100 58 116 1 2048413712 32074576 16918128
17:35:30 5469 8192000000 10959737264 11392184320 2000701200 19.628 100 49 94 2 2046669264 31088464 14879600
17:35:43 9353 8192000000 10963335328 11389116416 2001815776 19.637 100 66 130 1 2052638576 31118192 19704608
17:36:00 6344 8192000000 10965680832 11387396096 1999837632 19.621 100 70 139 1 2053729856 32016480 21875744
17:36:14 11045 8192000000 10970520272 11398791168 2005470128 19.666 100 69 138 2 2059795824 33956016 20369680
17:36:36 6372 8192000000 10981117760 11407155200 2012158576 19.719 100 70 138 2 2067572400 34813344 20600480
17:36:53 13266 8192000000 10976471904 11408883712 2012909328 19.724 100 63 126 0 2066654432 34607312 19137792
17:37:21 6827 8192000000 10986811808 11419430912 2017696544 19.762 100 62 123 1 2074423200 37576096 19150560
17:37:39 10215 8192000000 10990218448 11417133056 2006266544 19.672 99 64 128 2 2063787856 38069968 19451344
17:37:59 1186 8192000000 10995096048 11420512256 2020060544 19.781 100 71 140 2 2080312912 39079552 21172816
17:38:10 3111 8192000000 10974424624 11394764800 1994403264 19.579 100 72 144 0 2056141824 39936608 21801952
17:38:20 1853 8192000000 10988966928 11407859712 2005512560 19.666 100 82 164 0 2072053184 41356112 25184512
17:38:31 6421 8192000000 10981679600 11404668928 1989211920 19.538 99 72 142 4 2052393360 40207136 22974304
17:38:46 1902 8192000000 10986666448 11400118272 1998873824 19.614 100 83 166 2 2064848224 40356864 25617536
17:38:56 5114 8192000000 10978113088 11403423744 2003801408 19.653 100 68 136 2 2066045232 40618352 21625472
17:39:09 4992 8192000000 10976484624 11402821632 2001628768 19.636 100 67 133 0 2062763056 39919280 21215008
17:39:23 4203 8192000000 10960609248 11376336896 1981732576 19.478 99 74 147 1 2042192608 38884272 21575760
17:39:34 4609 8192000000 10945738208 11372163072 1975784192 19.431 100 65 127 1 2034434416 39021136 19629088
17:39:47 8815 8192000000 10943419168 11372089344 1959669808 19.303 99 59 118 0 2022671104 45361744 17639552
17:40:05 2396 8192000000 10974875664 11391660032 1988365024 19.531 100 79 158 2 2055282304 42605920 24311360
17:40:18 2365 8192000000 10983423712 11400843264 1998147728 19.608 100 87 170 1 2071038224 47062176 25828320
17:40:28 7067 8192000000 10978073120 11396378624 1987426672 19.523 100 76 150 2 2058589456 48985440 22177344
17:40:44 11038 8192000000 10986557152 11410345984 1995418992 19.587 100 69 138 0 2064693792 47961424 21313376
17:41:04 3096 8192000000 10994686864 11405385728 1997576432 19.604 100 85 169 2 2074804992 51069232 26159328
17:41:16 3468 8192000000 10997368864 11409502208 2001823488 19.637 100 89 178 0 2081285360 52720416 26741456
17:41:27 6227 8192000000 10986234592 11406794752 1997382400 19.602 100 85 171 0 2077456768 53862304 26212064
17:41:46 5164 8192000000 10990048048 11404558336 1991157296 19.553 100 80 159 0 2068255488 52086592 25011600
17:41:59 5315 8192000000 10991124784 11406520320 1992103264 19.560 100 81 162 2 2071909568 54948640 24857664
17:42:13 1842 8192000000 10995966064 11408781312 1998114432 19.608 100 87 175 0 2080924832 55942704 26867696
17:42:24 4116 8192000000 10996225344 11412336640 1993099872 19.568 100 80 159 3 2075206048 57502864 24603312
17:42:36 3378 8192000000 10991379136 11408756736 1992447504 19.563 100 84 168 1 2078075904 59442032 26186368
17:42:48 4624 8192000000 10989229008 11410329600 1991061232 19.552 100 75 150 0 2075117120 59834128 24221760
17:43:06 2476 8192000000 10999458512 11415715840 1990178416 19.545 100 72 145 0 2072851760 59750560 22922784
17:43:17 3049 8192000000 10996786160 11411988480 1992937648 19.567 100 82 162 1 2078985328 60816640 25231040
17:43:28 1135 8192000000 10999643824 11406401536 1981763104 19.479 100 95 190 2 2074992720 63637200 29592416
17:43:36 3757 8192000000 10963913072 11372367872 1939500688 19.143 99 89 177 0 2032719552 65648640 27570224
17:43:47 2717 8192000000 10980922944 11383525376 1949867568 19.225 99 93 185 1 2045043888 66997488 28178832
17:43:56 1862 8192000000 10959172512 11363090432 1945450496 19.190 99 85 170 0 2040596464 67858672 27287296
17:44:05 1452 8192000000 10986774512 11393724416 1968914800 19.377 100 92 184 0 2066819312 68686368 29218144
17:44:12 3076 8192000000 10989693232 11398172672 1970647760 19.391 100 86 170 1 2064644064 66218400 27777904
17:44:25 1569 8192000000 10980453312 11395039232 1967926192 19.369 100 89 179 1 2063868352 68065312 27876848
17:44:34 3744 8192000000 10979279760 11398615040 1971427024 19.397 100 83 166 0 2067918496 69414256 27077216
17:44:45 6650 8192000000 10962666944 11394379776 1970723744 19.391 100 60 120 1 2060014144 69081088 20209312
17:44:58 4200 8192000000 10968293136 11399356416 1973788448 19.415 100 51 102 1 2053439088 62677008 16973632
17:45:11 8614 8192000000 10969947328 11404816384 1975301984 19.427 100 41 82 0 2055131632 65750704 14078944
17:45:31 6279 8192000000 10962247376 11393974272 1972045984 19.402 100 58 116 1 2050645136 59500368 19098784
17:45:45 11640 8192000000 10941741568 11379511296 1938015696 19.131 99 45 90 0 2015943696 62636192 15291808
17:46:08 18470 8192000000 10926712672 11375329280 1918418096 18.974 98 33 66 1 1989169184 59203584 11547504
17:46:36 12228 8192000000 10943462608 11371520000 1952130288 19.243 100 46 91 0 2025335904 58324752 14880864
17:46:59 7337 8192000000 10943924800 11375648768 1935313952 19.109 99 55 110 2 2014538448 60865632 18358864
17:47:14 2231 8192000000 10968500592 11391733760 1955019536 19.266 100 80 155 0 2044922512 65172000 24730976
17:47:23 11732 8192000000 10944559536 11381362688 1952603888 19.247 100 47 94 0 2025506912 57198304 15704720
17:47:42 3173 8192000000 10965173488 11384029184 1962992864 19.330 100 63 125 2 2041111472 57830144 20288464
17:47:52 3564 8192000000 10961160928 11392286720 1968304480 19.372 100 56 112 1 2041352304 55263824 17784000
17:48:10 27641 8192000000 10938366720 11392409600 1970086736 19.386 100 36 71 1 2038100896 55864064 12150096
17:48:49 14454 8192000000 10958879664 11399856128 1970263344 19.388 100 42 84 1 2043569776 58712656 14593776
17:49:19 9426 8192000000 10962269216 11404185600 1974718544 19.423 100 50 101 0 2050126816 58492432 16915840
17:49:39 14117 8192000000 10953506768 11395969024 1975023920 19.425 100 29 58 0 2040357408 55260880 10072608
17:50:04 27188 8192000000 10943695248 11397947392 1978002192 19.449 100 30 58 2 2034154304 46357776 9794336
17:50:56 23466 8192000000 10922085680 11377360896 1952458752 19.246 100 25 50 0 2013172272 51391056 9322464
17:51:27 17404 8192000000 10901852576 11356815360 1903713792 18.856 98 26 52 2 1963354080 50445136 9195152
17:51:51 11663 8192000000 10909278592 11360501760 1910241872 18.909 99 25 50 0 1971712672 52224096 9246704
17:52:09 23952 8192000000 10885912240 11343654912 1913343152 18.933 99 21 43 0 1967429168 46570512 7515504
17:52:39 44646 8192000000 10878749104 11342811136 1929549408 19.063 100 18 36 1 1958303408 23633504 5120496
17:53:30 62067 8192000000 10845226000 11324342272 1857178016 18.480 96 13 26 0 1887258368 25750224 4330128
17:54:40 35369 8192000000 10815066960 11268177920 1843420368 18.369 97 17 34 0 1861294784 12878656 4995760
17:55:22 11237 8192000000 10834061616 11266756608 1884378480 18.700 99 47 92 0 1906421936 7954816 14088640
17:55:46 106286 8192000000 10844822736 11284819968 1878494992 18.653 98 14 27 1 1888159040 6583216 3080832
17:57:55 91243 8192000000 10885706784 11334025216 1911082048 18.915 98 18 36 0 1923660992 6935088 5643856
17:59:34 131265 8192000000 10896065328 11338768384 1943837024 19.177 99 36 72 1 1961095472 6614416 10644032
18:02:01 50109 8192000000 10882386352 11345874944 1966218768 19.355 100 27 55 0 1980868000 7329552 7319680
18:02:57 41014 8192000000 10918553920 11358732288 1955529008 19.270 99 33 66 0 1972285744 7255024 9501712
18:03:46 60215 8192000000 10910275280 11357110272 1940572960 19.151 98 28 56 0 1957093344 8628080 7892304
18:05:08 77251 8192000000 10928184896 11377733632 1976540784 19.437 100 20 40 1 1991383744 8885744 5957216
18:06:33 46197 8192000000 10919089280 11385159680 1996239120 19.593 100 26 52 0 2015834496 12041712 7553664
18:07:34 48121 8192000000 10903198064 11361161216 1955007312 19.266 98 20 39 0 1975661888 14521456 6133120
18:08:33 19954 8192000000 10931065600 11372453888 1968566240 19.374 99 52 102 1 1995287120 11367088 15353792
18:09:02 63730 8192000000 10930727392 11391025152 1992071328 19.560 100 43 84 1 2019838368 14583056 13183984
18:10:40 66879 8192000000 10910397776 11402285056 1991258976 19.554 100 9 18 1 2010466848 16530464 2677408
18:12:37 70030 8192000000 10914174560 11372335104 1981217344 19.474 100 18 35 1 1996426224 10192960 5015920
18:14:22 52531 8192000000 10878648544 11353542656 1905385632 18.870 96 7 14 0 1916373536 9128336 1859568
18:15:21 22371 8192000000 10920165056 11364442112 1963146688 19.331 99 45 90 1 1983102400 7273936 12681776
18:15:51 19923 8192000000 10910298848 11368525824 1983139312 19.490 100 55 109 3 2006666032 9041376 14485344
18:16:21 23742 8192000000 10922475056 11387518976 1987874176 19.527 100 29 58 1 2005045952 9306960 7864816
18:16:51 50403 8192000000 10927568848 11399045120 1998665424 19.612 100 23 46 1 2019083584 12576064 7842096
18:17:50 93774 8192000000 10929529152 11408744448 1981090672 19.473 99 14 28 1 2003875200 18638560 4145968
18:19:35 65557 8192000000 10892472160 11364114432 1919692688 18.984 97 10 20 0 1937342944 14677280 2972976
18:20:54 23671 8192000000 10913681680 11361689600 1947017200 19.203 98 47 92 0 1967351856 6842000 13492656
18:21:27 34554 8192000000 10900244960 11362992128 1957770416 19.288 99 28 56 1 1974571408 9274032 7526960
18:22:15 27437 8192000000 10886721408 11342049280 1908341104 18.893 97 22 44 0 1923574720 9680112 5553504
18:22:57 70500 8192000000 10876948320 11353882624 1914769104 18.945 98 17 34 0 1933264544 13776928 4718512
18:24:14 27885 8192000000 10866539392 11325730816 1878400352 18.652 96 25 50 1 1892342144 7404816 6536976
18:24:54 75319 8192000000 10875243168 11344433152 1888093040 18.730 97 27 54 0 1909982240 14346080 7543120
18:26:48 190622 8192000000 10875640608 11322867712 1868091168 18.569 95 17 34 0 1883944400 10759232 5094000
18:30:05 60683 8192000000 10856906240 11311144960 1859666784 18.501 95 25 50 1 1873815760 7254256 6894720
18:31:12 26908 8192000000 10856049216 11312197632 1911455072 18.918 98 30 60 1 1928998656 9187616 8355968
18:31:50 4692 8192000000 10869682704 11324362752 1937600384 19.128 100 35 70 1 1957311920 9918016 9793520
18:32:03 9558 8192000000 10887929232 11336540160 1942455760 19.166 100 23 44 1 1956488912 8080032 5953120
18:32:20 8114 8192000000 10888113392 11332202496 1945514624 19.191 100 62 122 2 1974336544 10974048 17847872
18:32:35 16150 8192000000 10856469008 11307409408 1906574976 18.879 98 56 109 1 1933719920 11117328 16027616
18:33:00 34084 8192000000 10842036736 11309633536 1879892336 18.664 97 26 52 0 1897876752 10957184 7027232
18:33:40 51746 8192000000 10829106064 11295531008 1902662352 18.848 99 12 23 1 1915854816 9923056 3269408
18:34:46 59233 8192000000 10836273776 11300364288 1876189296 18.634 97 16 32 1 1893518080 12020496 5308288
18:35:51 43845 8192000000 10843790208 11310010368 1886009824 18.714 98 18 36 1 1906534512 15136320 5388368
18:36:43 42525 8192000000 10829559456 11297505280 1901296816 18.837 99 19 38 0 1916949184 10045024 5607344
18:37:47 72822 8192000000 10842699536 11300036608 1866786368 18.558 97 28 57 2 1883962608 9259264 7916976
18:39:06 36869 8192000000 10827570624 11291308032 1880806944 18.672 98 13 26 1 1897178688 12778784 3592960
18:39:56 57563 8192000000 10847287440 11312709632 1879531056 18.661 98 14 29 1 1897345504 13141712 4672736
18:41:02 80947 8192000000 10828547760 11289915392 1788311680 17.918 93 32 64 1 1808684656 11356080 9016896
18:42:29 8606 8192000000 10839829776 11291357184 1914979200 18.947 100 37 74 2 1932406880 7103952 10323728
18:43:28 40543 8192000000 10835830976 11298537472 1905161872 18.868 100 15 30 1 1917139808 7895424 4082512
18:44:16 29485 8192000000 10872914432 11317383168 1918808448 18.977 100 24 48 0 1934328992 9046224 6474320
18:44:54 51302 8192000000 10861871856 11322630144 1903280928 18.853 98 39 78 3 1926468272 11946896 11240448
18:45:58 58784 8192000000 10860766896 11329699840 1929393472 19.062 100 23 45 1 1955689536 19770608 6525456
18:47:06 45497 8192000000 10869311264 11336622080 1941964144 19.162 100 15 30 0 1957255168 11080256 4210768
18:48:06 60335 8192000000 10882890864 11337949184 1915641232 18.952 98 22 44 1 1929349632 7923504 5784896
18:49:14 57224 8192000000 10890431616 11358326784 1938457280 19.134 99 33 66 3 1962611664 14756032 9398352
18:50:19 115303 8192000000 10877835968 11352821760 1916623776 18.960 98 13 26 0 1938860976 18709456 3527744
18:52:20 106350 8192000000 10888906080 11353796608 1937769120 19.129 99 20 40 0 1952992000 9640640 5582240
18:54:32 79409 8192000000 10878857776 11350704128 1920857872 18.994 98 20 40 3 1936781712 9950400 5973440
18:56:04 33406 8192000000 10897793616 11353608192 1948106176 19.211 99 40 80 0 1969692656 10281328 11305152
18:56:46 20904 8192000000 10880984240 11349520384 1957579552 19.287 100 21 42 0 1972227792 8728176 5920064
18:57:13 13513 8192000000 10882511136 11351109632 1961815424 19.320 100 14 29 1 1972798352 6490800 4492128
18:57:39 46801 8192000000 10883967504 11361402880 1950191520 19.228 99 15 30 0 1966429040 12433168 3804352
18:58:37 56355 8192000000 10889986576 11370897408 1968524448 19.374 100 10 20 1 1983635808 12678144 2433216
19:00:07 76403 8192000000 10903142400 11381297152 1942849568 19.169 98 12 24 0 1961977040 15911216 3216256
19:01:51 79302 8192000000 10914114992 11382386688 1952055776 19.243 99 18 36 0 1980162384 22456400 5650208
19:03:20 21937 8192000000 10926746240 11390676992 1990205200 19.545 100 42 82 1 2017749504 15023040 12521264
19:03:52 40792 8192000000 10920279664 11389542400 1976678720 19.438 99 25 50 2 1998202752 14424288 7099744
19:04:46 68344 8192000000 10907605424 11383664640 1962422592 19.325 99 16 32 0 1990322384 22611712 5288080
19:06:17 83329 8192000000 10899474608 11391795200 1946716192 19.200 98 12 24 0 1965584224 15245424 3622608
19:07:47 125833 8192000000 10900112912 11365343232 1891474752 18.758 95 17 33 0 1907036352 10862496 4699104
19:10:00 60561 8192000000 10913025696 11378515968 1928607472 19.056 97 25 50 1 1945059088 9712320 6739296
19:11:15 99049 8192000000 10886362240 11367211008 1856694144 18.476 94 10 20 1 1868851152 9745472 2411536
19:13:00 56604 8192000000 10891686048 11352420352 1890872160 18.753 96 28 56 1 1908396560 9730320 7794080
19:14:10 131844 8192000000 10887664672 11364536320 1947564576 19.207 99 22 44 1 1966517408 12376512 6576320
19:16:35 71596 8192000000 10885620624 11362979840 1932228896 19.085 98 15 30 0 1949070256 12829744 4011616
19:18:00 42032 8192000000 10854754528 11329388544 1900208912 18.828 98 9 17 1 1913672976 11084672 2379392
19:18:49 57985 8192000000 10841193072 11321380864 1898782736 18.817 98 5 10 0 1907337312 7419712 1134864
19:19:53 54168 8192000000 10868013136 11352739840 1943543824 19.175 100 15 29 0 1958777120 11878224 3355072
19:21:48 89586 8192000000 10869008832 11353276416 1919267120 18.981 98 19 38 1 1934570624 9749200 5554304
19:23:23 54964 8192000000 10846241840 11336155136 1890671824 18.751 97 3 6 0 1902859472 11414896 772752
19:24:24 19906 8192000000 10857424800 11322109952 1859906448 18.503 96 17 34 0 1872962256 8153952 4901856
19:25:02 24129 8192000000 10863373792 11326160896 1907729840 18.888 98 29 58 1 1922989232 6761472 8497920
19:25:40 40357 8192000000 10852760960 11329847296 1906688752 18.880 98 18 36 0 1920538496 8880464 4969280
19:26:28 42194 8192000000 10875044912 11345981440 1916356160 18.958 98 25 49 2 1933244448 9291296 7596992
19:27:17 9714 8192000000 9114915920 9361420288 279954816 3.304 15 2 4 0 282074160 1594320 525024

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 09-02-2021 19:28:40 to 09-02-2021 19:29:12.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 102 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 09-02-2021 19:29:12 to 09-02-2021 19:29:14.

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

09.02.21 19:29:15. 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-02-09 19:29:18 No severe PSQL-related problems occured
09.02.21 19:29:19. End of report.