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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17620256 kB
MemAvailable 31574616 kB
Buffers 0 kB
Cached 14068676 kB
SwapCached 1984 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 2020-12-06 22:27:02
DTS_END                         2020-12-06 22:27:02.9000
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/38634
TRN_ID                          248848
ATT_ID                          700
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: 9566.48 19123 1147978
customer order: creation 181.01 330 21721
customer order: refuse 15.16 282 1819
order to supplier: creation 47.55 1188 5706
order to supplier: removal 3.49 90129 419
invoice (draft): creation 48.29 2946 5795
invoice (draft): removal 54.24 837 6509
invoice accept: apply 44.06 16644 5287
invoice accept: cancel 49.03 717 5884
customer reserve: creation 4023.61 168 482833
customer reserve: removal 4784.02 50 574082
realization accept: apply 89.30 160 10716
realization accept: cancel 89.18 100 10702
payment from customer: creation 63.14 96 7577
payment from customer: removal 6.37 59 764
payment to supplier: creation 51.69 114 6203
payment to supplier: removal 3.82 65 458
service: total inventory turnovers 4.63 920 555
service: total monetary turnovers 7.05 39 846
service: aggregate perf. data 0.82 21410 98
service: refresh index statistics 0.03 246206 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-12-2020 22:27:51 to 06-12-2020 22:27:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5407
TEST_TIME 2 4841
TEST_TIME 3 5226
TEST_TIME 4 5605
TEST_TIME 5 5544
TEST_TIME 6 6547
TEST_TIME 7 6754
TEST_TIME 8 7317
TEST_TIME 9 7572
TEST_TIME 10 7626
TEST_TIME 11 7896
TEST_TIME 12 8431
TEST_TIME 13 8430
TEST_TIME 14 8368
TEST_TIME 15 9003
TEST_TIME 16 9223
TEST_TIME 17 9304
TEST_TIME 18 9327
TEST_TIME 19 9463
TEST_TIME 20 9843
TEST_TIME 21 10524
TEST_TIME 22 12634
TEST_TIME 23 12650
TEST_TIME 24 12323
TEST_TIME 25 11925
TEST_TIME 26 11568
TEST_TIME 27 11345
TEST_TIME 28 11430
TEST_TIME 29 11190
TEST_TIME 30 11279
TEST_TIME 31 11062
TEST_TIME 32 10886
TEST_TIME 33 10777
TEST_TIME 34 10495
TEST_TIME 35 10550
TEST_TIME 36 10439
TEST_TIME 37 10244
TEST_TIME 38 10153
TEST_TIME 39 10153
TEST_TIME 40 10047
TEST_TIME 41 9908
TEST_TIME 42 9860
TEST_TIME 43 10000
TEST_TIME 44 10171
TEST_TIME 45 10153
TEST_TIME 46 10294
TEST_TIME 47 10253
TEST_TIME 48 10247
TEST_TIME 49 10268
TEST_TIME 50 10272
TEST_TIME 51 10160
TEST_TIME 52 10143
TEST_TIME 53 10147
TEST_TIME 54 10035
TEST_TIME 55 10009
TEST_TIME 56 9946
TEST_TIME 57 9842
TEST_TIME 58 9893
TEST_TIME 59 9783
TEST_TIME 60 9720
TEST_TIME 61 9710
TEST_TIME 62 9712
TEST_TIME 63 9651
TEST_TIME 64 9653
TEST_TIME 65 9622
TEST_TIME 66 9664
TEST_TIME 67 9688
TEST_TIME 68 9761
TEST_TIME 69 9742
TEST_TIME 70 9783
TEST_TIME 71 9759
TEST_TIME 72 9792
TEST_TIME 73 9775
TEST_TIME 74 9805
TEST_TIME 75 9863
TEST_TIME 76 9883
TEST_TIME 77 9918
TEST_TIME 78 9873
TEST_TIME 79 9798
TEST_TIME 80 9844
TEST_TIME 81 9790
TEST_TIME 82 9813
TEST_TIME 83 9751
TEST_TIME 84 9701
TEST_TIME 85 9652
TEST_TIME 86 9640
TEST_TIME 87 9620
TEST_TIME 88 9639
TEST_TIME 89 9696
TEST_TIME 90 9682
TEST_TIME 91 9677
TEST_TIME 92 9747
TEST_TIME 93 9707
TEST_TIME 94 9708
TEST_TIME 95 9752
TEST_TIME 96 9804
TEST_TIME 97 9784
TEST_TIME 98 9806
TEST_TIME 99 9872
TEST_TIME 100 9875
TEST_TIME 101 9853
TEST_TIME 102 9828
TEST_TIME 103 9795
TEST_TIME 104 9764
TEST_TIME 105 9755
TEST_TIME 106 9699
TEST_TIME 107 9660
TEST_TIME 108 9643
TEST_TIME 109 9600
TEST_TIME 110 9596
TEST_TIME 111 9598
TEST_TIME 112 9631
TEST_TIME 113 9643
TEST_TIME 114 9621
TEST_TIME 115 9625
TEST_TIME 116 9613
TEST_TIME 117 9624
TEST_TIME 118 9618
TEST_TIME 119 9647
TEST_TIME 120 9568

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-12-2020 22:27:55 to 06-12-2020 22:27:58.

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 1594396 1594396 0 0.00 0 23717 6 0 0
doc_list_biud 1594396 1594396 0 0.00 0 84195 24 0 0
sp_add_invoice_to_stock 5453 5287 166 3.04 47 226077 16644 0 166
sp_cancel_adding_invoice 5884 5884 0 0.00 4 41092 718 0 0
sp_cancel_client_order 1819 1819 0 0.00 4 13156 282 0 0
sp_cancel_customer_reserve 574082 574082 0 0.00 1 84197 50 0 0
sp_cancel_pay_from_customer 764 764 0 0.00 2 6363 59 0 0
sp_cancel_pay_to_supplier 458 458 0 0.00 2 8251 65 0 0
sp_cancel_supplier_invoice 6521 6509 12 0.18 1 16248 838 0 12
sp_cancel_supplier_order 419 419 0 0.00 5 1062144 90130 0 0
sp_cancel_write_off 10702 10702 0 0.00 1 9609 100 0 0
sp_client_order 21721 21721 0 0.00 3 18935 331 0 0
sp_customer_reserve 482833 482833 0 0.00 0 45496 169 0 0
sp_fill_shopping_cart 33203 33203 0 0.00 1 24471 36 0 0
sp_fill_shopping_cart_clo_res 482828 482828 0 0.00 0 15504 13 0 0
sp_get_clo_for_invoice 5282 5282 0 0.00 0 19249 275 0 0
sp_kill_cost_storno 17808 17808 0 0.00 0 23676 50 0 0
sp_kill_qstorno_ret_qs2qd 1165794 1165794 0 0.00 0 84190 28 0 0
sp_kill_qty_storno 615413 615413 0 0.00 0 84195 61 0 0
sp_lock_selected_doc 22074 22074 0 0.00 0 8454 5 0 0
sp_make_cost_storno 29778 29778 0 0.00 0 16513 46 0 0
sp_multiply_rows_for_pdistr 29778 29778 0 0.00 0 9228 24 0 0
sp_multiply_rows_for_qdistr 21721 21721 0 0.00 0 13401 158 0 0
sp_pay_from_customer 7577 7577 0 0.00 4 29206 96 0 0
sp_pay_to_supplier 6203 6203 0 0.00 5 15384 115 0 0
sp_payment_common 13780 13780 0 0.00 1 29200 28 0 0
sp_qd_handle_on_cancel_clo 1819 1819 0 0.00 0 13151 258 0 0
sp_qd_handle_on_invoice_upd_sts 11166 11166 0 0.00 0 27884 294 0 0
sp_qd_handle_on_reserve_upd_sts 10716 10716 0 0.00 0 24658 62 0 0
sp_reserve_write_off 10716 10716 0 0.00 6 24672 161 0 0
sp_supplier_invoice 5795 5795 0 0.00 7 65862 2946 0 0
sp_supplier_order 5706 5706 0 0.00 4 54078 1189 0 0
srv_aggregate_perf_data 98 98 0 0.00 2830 198335 21410 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1146 156289 34702 0 0
srv_find_qd_qs_mism 1097414 1097414 0 0.00 0 14784 6 0 0
srv_make_invnt_saldo 555 555 0 0.00 37 62287 920 0 0
srv_make_money_saldo 846 846 0 0.00 1 13549 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 83828 324388 246206 0 0
t$perf-abend:sp_add_invoice_to_stock 166 166 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5287 5287 0 0.00 0 15625 177 0 0
t$perf-norm:sp_cancel_adding_invoice 433 433 0 0.00 1 10796 133 0 0
t$perf-norm:sp_cancel_client_order 1819 1819 0 0.00 0 11092 20 0 0
t$perf-norm:sp_cancel_customer_reserve 734 734 0 0.00 0 1099 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 764 764 0 0.00 0 3802 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 458 458 0 0.00 0 1617 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 441 441 0 0.00 0 2223 17 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 39291 1587 0 0
t$perf-norm:sp_cancel_write_off 1010 1010 0 0.00 0 10444 27 0 0
t$perf-norm:sp_client_order 21721 21721 0 0.00 0 17526 18 0 0
t$perf-norm:sp_customer_reserve 1081 1081 0 0.00 0 3579 8 0 0
t$perf-norm:sp_pay_from_customer 7577 7577 0 0.00 0 15450 11 0 0
t$perf-norm:sp_pay_to_supplier 6203 6203 0 0.00 0 12389 15 0 0
t$perf-norm:sp_reserve_write_off 10716 10716 0 0.00 0 10616 8 0 0
t$perf-norm:sp_supplier_invoice 5795 5795 0 0.00 0 10501 20 0 0
t$perf-norm:sp_supplier_order 5706 5706 0 0.00 0 7705 12 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 3816 41 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 1495 12 0 0
t$perf-norm:srv_make_invnt_saldo 555 555 0 0.00 0 5875 24 0 0
t$perf-norm:srv_make_money_saldo 846 846 0 0.00 0 8290 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10894 10562 332 3.04 0 12716 18 0 332
v_all_customers 39616 39616 0 0.00 0 15 0 0 0
v_all_suppliers 31942 31942 0 0.00 0 16 1 0 0
v_all_wares 43440 43440 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 866 866 0 0.00 0 1820 10 0 0
v_cancel_client_order 3638 3638 0 0.00 0 7468 6 0 0
v_cancel_customer_prepayment 1528 1528 0 0.00 0 638 4 0 0
v_cancel_customer_reserve 1468 1468 0 0.00 0 1531 4 0 0
v_cancel_payment_to_supplier 916 916 0 0.00 0 428 4 0 0
v_cancel_supplier_invoice 906 882 24 2.64 0 1486 19 0 24
v_cancel_supplier_order 838 838 0 0.00 0 1867 7 0 0
v_cancel_write_off 2020 2020 0 0.00 0 3233 17 0 0
v_max_id_clo_ord 5702 5702 0 0.00 0 1060 1 0 0
v_max_id_clo_res 1081 1081 0 0.00 0 3438 11 0 0
v_max_id_ord_sup 5781 5781 0 0.00 0 3359 2 0 0
v_max_non_paid_invoice 1715 1715 0 0.00 0 354 2 0 0
v_max_non_paid_realizn 4109 4109 0 0.00 0 6428 5 0 0
v_min_id_clo_ord 5702 5702 0 0.00 0 2219 5 0 0
v_min_id_clo_res 1081 1081 0 0.00 0 2437 6 0 0
v_min_id_ord_sup 5781 5781 0 0.00 0 9329 10 0 0
v_min_non_paid_invoice 6203 6203 0 0.00 0 9025 15 0 0
v_min_non_paid_realizn 7577 7577 0 0.00 0 6038 16 0 0
v_our_firm 10760 10760 0 0.00 0 13 1 0 0
v_reserve_write_off 21430 21430 0 0.00 0 5050 6 0 0
x_lock_depdocs_on_canc_invoice 11952 11952 0 0.00 0 15070 107 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 16191 380 0 0
x_make_qstorno_1000_1200 5706 5706 0 0.00 1 54067 1125 0 0
x_make_qstorno_1200_2000 5795 5795 0 0.00 3 65848 2815 0 0
x_make_qstorno_2100_3300 482833 482833 0 0.00 0 41406 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-12-2020 22:27:59 to 06-12-2020 22:28:03.

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
19:57:06 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:12 17089 8192000000 10243812128 10550255616 922936464 10.125 73 58 116 0 944780512 2542928 19301120
19:57:37 19399 8192000000 10337667600 10657263616 1380032544 14.417 100 78 157 0 1410215968 4835776 25347648
19:58:06 31404 8192000000 10396319568 10719547392 1431324400 14.873 100 86 172 1 1466146816 6576672 28245744
19:58:45 17412 8192000000 10428359344 10756235264 1464629904 15.167 100 92 184 0 1501765088 7564848 29570336
19:59:12 23069 8192000000 10431320992 10761699328 1482585520 15.324 100 89 178 0 1519787472 8464672 28737280
19:59:46 19378 8192000000 10447727296 10784034816 1501383888 15.488 100 87 175 2 1538563552 8991680 28187984
20:00:20 15091 8192000000 10466860128 10804391936 1520916352 15.658 100 89 178 1 1558312864 9476784 27919728
20:00:49 13335 8192000000 10485537920 10830176256 1540659488 15.829 100 80 160 1 1575454064 9990688 24803888
20:01:12 10883 8192000000 10517041248 10867023872 1570133312 16.083 100 78 156 0 1608380784 14754464 23493008
20:01:31 11789 8192000000 10533401728 10885820416 1593065072 16.280 100 79 157 1 1627913104 10889840 23958192
20:01:51 5184 8192000000 10550974736 10907869184 1611633632 16.439 100 79 158 0 1646293152 11451632 23207888
20:02:05 10204 8192000000 10570752048 10930102272 1630432224 16.599 100 82 164 0 1665682256 11171760 24078272
20:02:24 11225 8192000000 10593268752 10952994816 1651293056 16.775 100 82 164 3 1687650288 12275856 24081376
20:02:42 11503 8192000000 10610983568 10977730560 1664892704 16.890 100 87 174 0 1703282672 12884288 25505680
20:03:01 8063 8192000000 10634986976 11000786944 1685199920 17.061 100 79 155 0 1720602016 12787264 22614832
20:03:16 9746 8192000000 10649787264 11022458880 1708001856 17.252 100 82 162 1 1744076912 12651104 23423952
20:03:36 6857 8192000000 10669752256 11040215040 1723731424 17.383 100 83 166 0 1760378176 12633456 24013296
20:03:51 5811 8192000000 10667824736 11045060608 1736043552 17.486 100 76 152 2 1770104160 12390096 21670512
20:04:05 3666 8192000000 10683690032 11059769344 1746804176 17.575 100 79 155 3 1781201936 11990368 22407392
20:04:16 5124 8192000000 10685560592 11069739008 1754576192 17.640 100 78 158 0 1788157120 11615488 21965440
20:04:27 4332 8192000000 10703624816 11080966144 1766680240 17.740 100 84 163 3 1802256800 12833632 22742928
20:04:38 3900 8192000000 10709233168 11089588224 1770130352 17.768 100 82 161 0 1805639104 13026160 22482592
20:04:49 3856 8192000000 10719380592 11099512832 1781385760 17.861 100 85 168 1 1818863200 13668944 23808496
20:04:59 2511 8192000000 10727969328 11110338560 1787922672 17.915 100 84 167 2 1825313104 14282112 23108320
20:05:08 2528 8192000000 10738951152 11119190016 1800051504 18.014 100 92 178 2 1839728944 14830448 24846992
20:05:18 7562 8192000000 10745519952 11125886976 1802531520 18.035 100 83 167 0 1840249360 15320368 22397472
20:05:34 6141 8192000000 10743421168 11134013440 1804701584 18.052 100 76 150 2 1838734288 13972928 20059776
20:05:47 1542 8192000000 10767376336 11151949824 1826639568 18.232 100 86 172 1 1864553024 12907104 25006352
20:05:55 2344 8192000000 10779516240 11161321472 1830704656 18.265 100 88 176 0 1868367248 12544224 25118368
20:06:04 1954 8192000000 10790851152 11172470784 1838119136 18.325 100 93 184 1 1877014448 12485280 26410032
20:06:12 2026 8192000000 10791731760 11174866944 1843973648 18.373 100 87 172 0 1881860240 12848144 25038448
20:06:20 1838 8192000000 10791224448 11178352640 1849540688 18.418 100 92 184 2 1889294928 14323664 25430576
20:06:28 1480 8192000000 10789728928 11178164224 1851685696 18.436 100 90 179 0 1891150432 14582928 24881808
20:06:36 1461 8192000000 10801328784 11187105792 1856641792 18.476 100 91 184 0 1895032208 12333616 26056800
20:06:43 3012 8192000000 10788506992 11183792128 1854120992 18.456 100 81 162 0 1889739840 11906912 23711936
20:06:53 4564 8192000000 10801971728 11190333440 1860144784 18.504 100 80 157 2 1893488512 10913920 22429808
20:07:03 1702 8192000000 10781454928 11191046144 1857355888 18.482 100 58 115 1 1884915120 11183520 16375712
20:07:11 3183 8192000000 10772886336 11187134464 1862324704 18.522 100 54 109 0 1886048528 8082960 15640864
20:07:22 2581 8192000000 10779976464 11193442304 1860742048 18.509 100 52 104 0 1885190976 10038112 14410816
20:07:31 3359 8192000000 10791585280 11199135744 1865890256 18.551 100 54 108 0 1892469168 11055488 15523424
20:07:41 2017 8192000000 10810335824 11206680576 1871218720 18.594 100 70 143 2 1901356416 10552208 19585488
20:07:50 6204 8192000000 10774609392 11197362176 1871394992 18.596 100 45 91 1 1892002784 8219776 12388016
20:08:05 43282 8192000000 10812302592 11208937472 1873968736 18.616 100 55 105 0 1894799232 6048688 14781808
20:08:54 15678 8192000000 10817173984 11213549568 1882450496 18.685 100 76 150 0 1912394368 8636848 21307024
20:09:16 10283 8192000000 10802762464 11220267008 1883340896 18.692 100 79 159 0 1918165744 11903952 22920896
20:09:41 15699 8192000000 10785865328 11216019456 1875947344 18.632 100 20 40 1 1887078976 5534688 5596944
20:10:10 5782 8192000000 10787773232 11220529152 1882669104 18.687 100 27 54 1 1896884688 7029536 7186048
20:10:23 4609 8192000000 10794292352 11223203840 1888087152 18.730 100 32 64 0 1904134864 6799392 9248320
20:10:38 8151 8192000000 10791098336 11223425024 1885230896 18.707 100 26 52 0 1899378512 6130704 8016912
20:10:54 7050 8192000000 10794407824 11227533312 1889220496 18.739 100 31 61 1 1905283424 7225872 8837056
20:11:09 5586 8192000000 10800092704 11229265920 1888368416 18.733 100 21 42 1 1899194912 5497488 5329008
20:11:24 5129 8192000000 10795803312 11232149504 1889762672 18.744 100 19 37 3 1901132448 6082144 5287632
20:11:37 12573 8192000000 10798548768 11236352000 1892118208 18.763 100 18 36 2 1902147920 5236144 4793568
20:12:00 6327 8192000000 10802696432 11236487168 1896166128 18.795 100 24 49 1 1909423120 5616848 7640144
20:12:15 11249 8192000000 10797710288 11237478400 1897220576 18.804 100 22 44 0 1909876128 6722624 5932928
20:12:35 7407 8192000000 10811260272 11246174208 1899604624 18.823 100 20 41 0 1915391184 9779136 6007424
20:12:48 7812 8192000000 10807836240 11243683840 1900661904 18.832 100 19 37 3 1911883472 5693808 5527760
20:13:02 10235 8192000000 10804726800 11244068864 1898935552 18.818 100 10 20 0 1907202464 5696672 2570240
20:13:21 12218 8192000000 10814742240 11244752896 1900624432 18.831 100 12 24 1 1909457088 5595376 3237280
20:13:43 60910 8192000000 10834721344 11260727296 1911201184 18.916 100 33 66 1 1926292176 5228896 9862096
20:14:50 14550 8192000000 10815583984 11253137408 1890587056 18.751 99 17 34 1 1901170464 5877744 4705664
20:15:12 6941 8192000000 10823165920 11251417088 1885599312 18.710 99 22 43 1 1897169536 5770112 5800112
20:15:29 4782 8192000000 10823030480 11253960704 1908020640 18.891 100 35 72 0 1924257312 5268672 10968000
20:15:42 4947 8192000000 10819660464 11250917376 1901845472 18.841 100 29 57 3 1917369568 7538816 7985280
20:15:58 5329 8192000000 10796401376 11228659712 1859751312 18.501 98 31 62 1 1875854304 7778576 8324416
20:16:11 4988 8192000000 10795061120 11224428544 1867079776 18.561 99 30 60 2 1882624640 7557984 7986880
20:16:22 9349 8192000000 10775721744 11212038144 1850278464 18.424 98 27 54 1 1863798608 5900384 7619760
20:16:38 8056 8192000000 10765274192 11196747776 1804918144 18.054 96 27 54 1 1818906464 5625744 8362576
20:16:58 8190 8192000000 10752982688 11175895040 1796542640 17.986 97 26 52 1 1809793232 5500416 7750176
20:17:16 5264 8192000000 10755162384 11182899200 1828257728 18.245 99 22 42 2 1840035408 5808144 5969536
20:17:33 8963 8192000000 10724278992 11148279808 1727729520 17.417 94 13 26 0 1736150512 4848176 3572816
20:17:49 10294 8192000000 10699618272 11115745280 1666483232 16.904 92 19 38 0 1677938000 5421936 6032832
20:18:07 5715 8192000000 10694736032 11116077056 1754103024 17.636 98 17 34 2 1764173808 5231008 4839776
20:18:19 11928 8192000000 10703686544 11122655232 1774361424 17.803 99 16 32 3 1783994576 5242128 4391024
20:18:43 61983 8192000000 10682040800 11105935360 1725079616 17.395 96 32 63 2 1744377264 10037376 9260272
20:19:51 8528 8192000000 10680470128 11100590080 1696874592 17.159 95 18 35 0 1706770624 5239328 4656704
20:20:09 3953 8192000000 10695541296 11104960512 1736033504 17.486 97 32 64 2 1752574928 7435008 9106416
20:20:22 4809 8192000000 10695578976 11107250176 1747913248 17.584 98 34 69 0 1763725632 6234384 9578000
20:20:35 4942 8192000000 10702604944 11111849984 1766615968 17.739 98 41 82 3 1785826304 7443808 11766528
20:20:46 7763 8192000000 10711425648 11129495552 1766034416 17.734 98 24 49 2 1779420560 6249952 7136192
20:21:02 8612 8192000000 10702406016 11124289536 1781212016 17.859 99 29 58 2 1795359040 6270032 7876992
20:21:18 8120 8192000000 10713423136 11136577536 1789289952 17.926 99 23 46 0 1802465376 6036832 7138592
20:21:36 9583 8192000000 10731888928 11149824000 1793384624 17.960 99 18 36 2 1804063488 5711856 4967008
20:21:52 9098 8192000000 10736611840 11153698816 1814915712 18.136 100 24 48 0 1826990160 5483616 6590832
20:22:08 10538 8192000000 10755730848 11171692544 1830308272 18.262 100 25 50 2 1843249296 5767616 7173408
20:22:28 10415 8192000000 10745486400 11172597760 1833469408 18.288 100 22 44 0 1845117632 5307104 6341120
20:22:46 15721 8192000000 10751263696 11180826624 1847143648 18.399 100 20 40 3 1857726560 5086656 5496256
20:23:07 11998 8192000000 10735501600 11163844608 1831001392 18.267 99 10 20 0 1838406640 4846960 2558288
20:23:27 72690 8192000000 10765050512 11192975360 1855537520 18.467 100 40 80 1 1874506432 7043200 11925712
20:24:47 11138 8192000000 10770799584 11191738368 1855288112 18.465 100 21 42 0 1866910672 5310544 6312016
20:25:05 6682 8192000000 10774564224 11201875968 1863306864 18.530 100 37 74 1 1881760832 7411008 11042960
20:25:19 8982 8192000000 10774747696 11208179712 1865051040 18.544 100 23 46 2 1878406016 6686224 6668752
20:25:34 10379 8192000000 10793269248 11211448320 1866406288 18.555 100 26 51 1 1879300368 6097824 6796256
20:25:53 9112 8192000000 10773396096 11210391552 1872481296 18.604 100 41 82 2 1891522704 6999136 12042272
20:26:10 5692 8192000000 10787047504 11213783040 1871538864 18.597 100 28 56 2 1884881152 5563040 7779248
20:26:23 9184 8192000000 10782107152 11214073856 1872408288 18.604 100 25 50 1 1885464480 4856176 8200016
20:26:39 6452 8192000000 10786391472 11217203200 1871803824 18.599 100 18 36 2 1883285808 5972896 5509088
20:26:54 9198 8192000000 10800510256 11227684864 1876278208 18.635 100 16 32 0 1885916400 4672560 4965632
20:27:10 11006 8192000000 10829885920 11246411776 1901493328 18.838 100 51 100 1 1921704784 5491712 14719744
20:27:52 11700 8192000000 10853616864 11276222464 1916231376 18.957 100 40 78 1 1940070112 13058240 10780496
20:28:18 19720 8192000000 10867282272 11288457216 1932875584 19.090 100 49 98 0 1957580864 10712832 13992448
20:28:48 53121 8192000000 10876030336 11299553280 1940413840 19.150 100 48 97 1 1965970752 12328736 13228176
20:30:05 55847 8192000000 10868171408 11309998080 1931684800 19.080 99 33 66 1 1954504384 13258480 9561104
20:31:09 57993 8192000000 10879437200 11324784640 1955876384 19.273 100 22 44 0 1978770384 16335136 6558864
20:32:24 9957 8192000000 10895164144 11337424896 1965751024 19.352 100 31 62 2 1990159952 15558368 8850560
20:32:40 6276 8192000000 10900823360 11336294400 1965764768 19.352 100 49 97 2 1997768640 17726336 14277536
20:32:56 4652 8192000000 10913500784 11337367552 1965418256 19.349 100 55 109 2 1999847104 18507504 15921344
20:33:09 3679 8192000000 10927151872 11347099648 1972447952 19.405 100 71 140 1 2013787168 20586944 20752272
20:33:19 4079 8192000000 10919797904 11344510976 1969064816 19.378 100 64 128 2 2007798608 20771568 17962224
20:33:31 5783 8192000000 10911797680 11333001216 1954492544 19.262 99 69 138 1 1996113760 22478528 19142688
20:33:44 12262 8192000000 10914442224 11346456576 1968304592 19.372 100 60 117 1 2003509184 17845536 17359056
20:34:02 6992 8192000000 10929058672 11351334912 1975998736 19.433 100 64 129 0 2015297792 20934864 18364192
20:34:17 2549 8192000000 10940539168 11359428608 1981374960 19.476 100 70 141 0 2025759984 24757856 19627168
20:34:32 3148 8192000000 10947258736 11374411776 1989296224 19.538 100 72 144 1 2037465344 27594688 20574432
20:34:43 4504 8192000000 10948640256 11370885120 1972598848 19.406 99 65 129 1 2020716880 29428832 18689200
20:34:56 6877 8192000000 10944478688 11370397696 1981757712 19.479 100 63 124 2 2030567488 30416704 18393072
20:35:10 15102 8192000000 10957438432 11383488512 1991604864 19.556 100 59 118 3 2039947504 30737760 17604880
20:35:32 5812 8192000000 10957529104 11387138048 1995774144 19.589 100 54 108 0 2042969136 31322400 15872592
20:35:46 1788 8192000000 10958190032 11385921536 2002337088 19.641 100 66 126 1 2046264496 25657168 18270240
20:35:56 2166 8192000000 10982667264 11393835008 2011234080 19.711 100 84 167 0 2062757344 26392624 25130640
20:36:11 3436 8192000000 10965767952 11397062656 2009804416 19.700 100 57 113 3 2052651728 25561216 17286096
20:36:21 3330 8192000000 10969880288 11397406720 2011118512 19.710 100 70 138 2 2058792848 26794016 20880320
20:36:32 9810 8192000000 10964262208 11385790464 1995571360 19.588 100 70 141 1 2046436512 29833344 21031808
20:36:51 2198 8192000000 10966473200 11385278464 1996524416 19.595 100 74 148 0 2049309392 29716320 23068656
20:37:01 2044 8192000000 10967465664 11379372032 1996607376 19.596 100 82 163 1 2049309504 28651296 24050832
20:37:10 5356 8192000000 10969115488 11393658880 2002245968 19.640 100 77 154 1 2055365264 29987712 23131584
20:37:23 2653 8192000000 10980497264 11404414976 2013458864 19.729 100 82 163 0 2070197488 32057776 24680848
20:37:32 2854 8192000000 10985570128 11405803520 2009637440 19.699 100 78 154 0 2067433600 34268384 23527776
20:37:44 9442 8192000000 10980816896 11410812928 2013358656 19.728 100 75 150 3 2071231456 34975312 22897488
20:38:00 2488 8192000000 10979975984 11399823360 2002246016 19.640 99 73 143 0 2061909664 37363328 22300320
20:38:09 2509 8192000000 10987942160 11415674880 2015450304 19.744 100 73 138 0 2073701744 37023792 21227648
20:38:24 6792 8192000000 10994716304 11424206848 2019913040 19.779 100 62 121 0 2075719712 37082256 18724416
20:38:37 5271 8192000000 11000557936 11417403392 2012296944 19.720 100 73 144 3 2072550800 38804912 21448944
20:38:51 3746 8192000000 10967113584 11391127552 1966992992 19.362 98 69 136 2 2029071600 40917504 21161104
20:39:01 2999 8192000000 10982478160 11399495680 2003507440 19.650 100 83 165 0 2068180400 39865632 24807328
20:39:11 3207 8192000000 10993870240 11411603456 2007181248 19.679 100 84 168 0 2074236704 41361856 25693600
20:39:21 3404 8192000000 10987305520 11404374016 1983224672 19.490 99 88 176 0 2053276208 43550992 26500544
20:39:33 3133 8192000000 10989555024 11403636736 2001850640 19.637 100 83 164 1 2067681296 41574848 24255808
20:39:43 6316 8192000000 10973085152 11399741440 2002618096 19.643 100 74 148 0 2064981216 39869024 22494096
20:40:04 7537 8192000000 10959819072 11391647744 1990954736 19.551 100 62 122 0 2049147728 39426720 18766272
20:40:18 4062 8192000000 10928551888 11349561344 1938926080 19.138 98 63 128 3 1999174832 38885360 21363392
20:40:30 1143 8192000000 10942767456 11354513408 1939599536 19.144 99 80 159 1 2003471216 40210864 23660816
20:40:38 2145 8192000000 10945105040 11357999104 1958786176 19.296 100 80 159 2 2025746352 42829792 24130384
20:40:47 5036 8192000000 10931574912 11348631552 1949099584 19.219 100 70 137 2 2014954400 44412048 21442768
20:40:59 5846 8192000000 10940603776 11360268288 1961499792 19.318 100 71 142 0 2026981424 43449488 22032144
20:41:12 1327 8192000000 10959258192 11372519424 1968290592 19.372 100 85 169 2 2038914480 43785152 26838736
20:41:20 1738 8192000000 10959816592 11373137920 1967603936 19.366 100 80 161 0 2040135488 47010416 25521136
20:41:29 1868 8192000000 10970246000 11381047296 1975916832 19.432 100 87 172 2 2050050816 47525728 26608256
20:41:37 2558 8192000000 10976622128 11393564672 1986320208 19.515 100 83 167 2 2062112080 49921200 25870672
20:41:47 5003 8192000000 10956953616 11371630592 1948848064 19.217 98 86 172 4 2027471712 51509984 27113664
20:42:01 3455 8192000000 10986593488 11392782336 1977977968 19.449 100 85 170 1 2057419888 53018400 26423520
20:42:12 2093 8192000000 10971846816 11381538816 1972750144 19.407 99 82 163 3 2051070560 52533072 25787344
20:42:23 9832 8192000000 10928528944 11360165888 1921285488 18.997 98 55 110 2 1990851744 51166400 18399856
20:42:39 7645 8192000000 10936477440 11369811968 1958370208 19.293 100 42 85 1 2021894288 48760896 14763184
20:42:56 5319 8192000000 10939367568 11382829056 1970870320 19.392 100 46 91 4 2034613520 48135472 15607728
20:43:08 3258 8192000000 10951773056 11384934400 1962249360 19.324 99 53 106 5 2026028848 47282608 16496880
20:43:19 14133 8192000000 10947912896 11380019200 1938649296 19.136 98 48 97 2 2006934016 52227648 16057072
20:43:46 20259 8192000000 10958622272 11406336000 1975860704 19.432 100 34 68 1 2042634688 55449024 11324960
20:44:13 7704 8192000000 10966955904 11408986112 1985023904 19.504 100 39 78 0 2053217680 55574896 12618880
20:44:27 7732 8192000000 10955082912 11388313600 1951374032 19.237 98 46 92 1 2018728880 51939888 15414960
20:44:43 5006 8192000000 10951808304 11395047424 1961536544 19.318 99 38 76 0 2027951696 54195952 12219200
20:44:58 12880 8192000000 10926474560 11366952960 1922173712 19.004 98 35 68 2 1985660016 52193936 11292368
20:45:32 15980 8192000000 10918080992 11356008448 1929408064 19.062 99 36 72 1 1994399424 52615344 12376016
20:45:57 18198 8192000000 10924228816 11360575488 1939920800 19.146 100 37 74 1 2010707488 57086112 13700576
20:46:28 28625 8192000000 10921261728 11374878720 1922164384 19.004 99 34 68 0 2004342240 69979952 12197904
20:47:04 30300 8192000000 10928790464 11384582144 1933463072 19.095 100 28 56 0 2014411584 70062208 10886304
20:47:50 41759 8192000000 10924507632 11378655232 1924705056 19.025 100 26 50 1 1998797616 64267296 9825264
20:48:38 22985 8192000000 10932697136 11367727104 1898150128 18.811 98 35 70 2 1979820080 69335712 12334240
20:49:08 10173 8192000000 10907791344 11365122048 1924564272 19.023 100 26 52 1 1996741936 62605008 9572656
20:49:31 46947 8192000000 10882603840 11338207232 1933681552 19.096 100 26 49 2 1986675360 43873888 9119920
20:50:25 24159 8192000000 10871688480 11336364032 1936492160 19.119 100 24 48 2 1960006496 16361920 7152416
20:50:55 64564 8192000000 10860715296 11322654720 1911825648 18.921 98 18 37 1 1926728560 9574176 5328736
20:52:08 54269 8192000000 10869508144 11317477376 1905867008 18.873 98 31 62 1 1926003632 11068160 9068464
20:53:19 121024 8192000000 10845821472 11315552256 1854045120 18.455 96 19 37 1 1877590896 19118880 4426896
20:55:30 63370 8192000000 10834424064 11309772800 1874336896 18.619 98 13 26 0 1897478576 19474384 3667296
20:56:57 82421 8192000000 10835087024 11295043584 1843226944 18.367 96 18 36 0 1863665616 15665328 4773344
20:58:26 32088 8192000000 10870213104 11304873984 1915960288 18.954 99 31 57 1 1929132656 6282320 6890048
20:59:04 72495 8192000000 10872913808 11333013504 1944681296 19.184 100 14 28 0 1956990176 8595904 3712976
21:00:26 90776 8192000000 10878966944 11338874880 1936712560 19.121 99 15 27 0 1952746880 11940864 4093456
21:02:04 69516 8192000000 10881722224 11342356480 1939302400 19.141 99 26 52 2 1959071552 12698000 7071152
21:04:39 67846 8192000000 10858744640 11328483328 1915462096 18.950 98 11 22 1 1925356128 7238944 2655088
21:05:57 37514 8192000000 10870581344 11342614528 1953807120 19.257 100 31 61 1 1970491392 8193728 8490544
21:06:46 84766 8192000000 10916638992 11368247296 1976962256 19.441 100 18 36 2 1992136624 10274912 4899456
21:08:19 77823 8192000000 10933243664 11398230016 1994750880 19.581 100 18 36 1 2017856880 17726352 5379648
21:09:49 54605 8192000000 10940065168 11413147648 1974412016 19.420 99 14 28 1 2005556832 27034240 4110576
21:10:54 69530 8192000000 10914711328 11390189568 1967161568 19.363 99 14 29 0 1998969776 27210464 4597744
21:12:19 109818 8192000000 10914860528 11391856640 1960478704 19.310 99 8 16 1 1983398400 20523040 2396656
21:14:23 55009 8192000000 10920289360 11374694400 1968748736 19.376 99 21 40 1 1984358992 8680896 6929360
21:15:24 62731 8192000000 10933525760 11378483200 1955612160 19.271 98 33 66 2 1978512256 13655264 9244832
21:16:33 38312 8192000000 10902662848 11366850560 1959997600 19.306 99 27 53 1 1982509200 14677280 7834320
21:17:24 49051 8192000000 10903539552 11357753344 1918544720 18.975 97 30 60 1 1937340080 10848880 7946480
21:18:19 27911 8192000000 10919849920 11368804352 1974932496 19.425 100 37 74 0 1997827456 12264416 10630544
21:19:11 156288 8192000000 10914626240 11374325760 1973310560 19.412 100 36 72 0 1999495376 16355872 9828944
21:21:58 27773 8192000000 10918663392 11373199360 1968098512 19.370 99 48 97 2 1993942608 12003232 13840864
21:23:40 49315 8192000000 10906887744 11381346304 1965309536 19.348 99 10 20 0 1985499008 17382928 2806544
21:24:35 53887 8192000000 10883412000 11371585536 1937949792 19.130 98 5 10 0 1952411136 13090464 1370880
21:25:35 28019 8192000000 10882026224 11358396416 1950574400 19.231 99 10 20 0 1963851232 9947360 3329472
21:26:30 83336 8192000000 10895840976 11360915456 1927887840 19.050 97 24 48 0 1948959104 14330752 6740512
21:28:05 48955 8192000000 10876785200 11349561344 1939276656 19.141 98 7 14 1 1954375600 13395696 1703248
21:29:00 62824 8192000000 10859642640 11342143488 1893405952 18.773 96 11 22 0 1905813072 9728416 2678704
21:30:10 40828 8192000000 10857145504 11326644224 1926437056 19.038 99 7 14 0 1936377952 8383232 1557664
21:31:01 53170 8192000000 10848083296 11317075968 1821910080 18.193 93 10 20 0 1834349520 10017952 2421488
21:32:00 34769 8192000000 10834205520 11295027200 1883084608 18.690 97 25 50 1 1900081760 9783360 7213792
21:32:43 30796 8192000000 10872476416 11324968960 1914485312 18.943 99 45 92 0 1940339840 13029312 12825216
21:33:20 61040 8192000000 10872762208 11338080256 1888380016 18.733 97 11 22 2 1900363232 8957840 3025376
21:34:43 54730 8192000000 10857020688 11314954240 1827672832 18.240 94 13 25 2 1848878640 17290160 3915648
21:35:47 91581 8192000000 10820637360 11293687808 1677661024 16.998 88 15 30 2 1692942576 11304912 3976640
21:37:25 42648 8192000000 10838874976 11292913664 1883826208 18.696 99 15 30 2 1895092736 7543360 3723168
21:38:16 23473 8192000000 10864473392 11308855296 1893327120 18.773 98 42 83 1 1913195648 8491248 11377280
21:38:46 41802 8192000000 10860637232 11311198208 1877258720 18.643 97 47 94 1 1908353968 18191568 12903680
21:39:34 47204 8192000000 10863543184 11320934400 1916074080 18.955 99 27 54 0 1934646288 10667472 7904736
21:40:31 77505 8192000000 10859475824 11318145024 1859733904 18.501 96 23 46 1 1876182176 9850848 6597424
21:41:59 38234 8192000000 10864101120 11313926144 1892857120 18.769 98 26 52 0 1911669488 11515600 7296768
21:42:59 62767 8192000000 10860421920 11327389696 1876832432 18.640 97 23 44 1 1896455728 13711152 5912144
21:44:13 88305 8192000000 10865935616 11334868992 1912693456 18.928 99 14 28 0 1936873968 19733680 4446832
21:46:36 99298 8192000000 10836321760 11294703616 1856063600 18.471 96 31 62 1 1879940240 15037872 8838768
21:48:34 13322 8192000000 10857293104 11311468544 1926234784 19.037 100 28 56 0 1941687904 7725552 7727568
21:48:53 25696 8192000000 10861437120 11315937280 1917388160 18.966 99 33 64 0 1933846784 7822560 8636064
21:49:28 55440 8192000000 10825600864 11302350848 1887959600 18.729 98 9 18 0 1897057312 6353344 2744368
21:50:30 35904 8192000000 10828501424 11303219200 1899537568 18.823 99 7 14 0 1907582304 6259616 1785120
21:51:13 33713 8192000000 10850941328 11307671552 1900337904 18.829 99 22 44 0 1913377984 6652640 6387440
21:51:55 77297 8192000000 10854318528 11327414272 1929071680 19.059 100 9 18 1 1942831088 10997648 2761760
21:53:40 57187 8192000000 10854252896 11334709248 1922911008 19.010 99 10 20 1 1938601392 12839264 2851120
21:54:52 53144 8192000000 10863228528 11339341824 1925503152 19.031 99 14 29 2 1941827792 12171888 4152752
21:55:51 36367 8192000000 10881382736 11345698816 1931273104 19.077 99 24 48 0 1950711216 12747744 6690368
21:56:34 54570 8192000000 10882618944 11331858432 1912325952 18.925 98 16 30 1 1922548896 6289744 3933200
21:57:34 24779 8192000000 10897433488 11354210304 1964474368 19.342 100 38 77 0 1982188848 7682496 10031984
21:58:12 36627 8192000000 10918256016 11374182400 1975027952 19.425 100 35 68 2 1996033440 11951536 9053952
21:59:04 58442 8192000000 10870901888 11348938752 1896196000 18.796 96 25 51 0 1915633808 12273056 7164752
22:00:09 54050 8192000000 10882925808 11338784768 1887423024 18.725 96 32 62 0 1906610512 10505376 8682112
22:01:09 55963 8192000000 10908770640 11373158400 1943353024 19.174 99 16 32 3 1962229072 13949088 4926960
22:02:48 67515 8192000000 10895709248 11350773760 1925849040 19.034 98 15 30 0 1943136752 12613504 4674208
22:04:02 38624 8192000000 10915332992 11357474816 1908326544 18.893 97 38 76 0 1928320656 9179728 10814384
22:05:08 62504 8192000000 10899176592 11374276608 1952973680 19.250 99 36 72 1 1978572032 15669232 9929120
22:06:19 122295 8192000000 10900848688 11358674944 1849383104 18.417 94 8 16 0 1865930944 14554880 1992960
22:08:33 59701 8192000000 10886753312 11355496448 1892039344 18.762 96 17 34 0 1912837680 16020016 4778320
22:09:54 110243 8192000000 10859162912 11324633088 1891547104 18.758 97 17 34 1 1904148528 7942944 4658480
22:11:54 15221 8192000000 10857653616 11323322368 1935613136 19.112 100 23 46 1 1951060672 8882448 6565088
22:12:16 19819 8192000000 10849011808 11319988224 1901134592 18.835 98 13 26 0 1914618768 9559504 3924672
22:13:33 71983 8192000000 10859938624 11332018176 1941367984 19.158 100 13 24 1 1957117936 12385888 3364064
22:15:31 61027 8192000000 10842689856 11309080576 1838139008 18.326 94 19 38 1 1854735328 11379584 5216736
22:16:41 48141 8192000000 10860764320 11331211264 1907270240 18.885 99 20 40 0 1928016512 14805008 5941264
22:18:08 84013 8192000000 10852346000 11320881152 1873994816 18.617 97 19 38 0 1890820272 11512336 5313120
22:19:38 66259 8192000000 10876438336 11322814464 1895992064 18.794 98 18 35 1 1910399568 8965536 5441968
22:20:53 96140 8192000000 10848063168 11324411904 1842540880 18.361 95 24 48 0 1859395888 10066208 6788800
22:22:36 34082 8192000000 10859720720 11292278784 1878695008 18.655 97 35 68 0 1896526544 7902032 9929504
22:23:18 19129 8192000000 10867950944 11317477376 1923164896 19.012 100 54 104 1 1951773264 14224416 14383952
22:23:44 57243 8192000000 10864496208 11310407680 1892808448 18.768 98 35 70 0 1917235744 14423232 10004064
22:24:50 31718 8192000000 10862314848 11309342720 1893985472 18.778 98 36 72 2 1915437808 11537520 9914816
22:25:29 38551 8192000000 10881898672 11329699840 1933090176 19.092 100 37 74 1 1955279408 11880288 10308944
22:26:20 26703 8192000000 10885249984 11335356416 1937134400 19.124 100 49 98 1 1963500688 12782720 13583568
22:26:56 19177 8192000000 9055968000 9260474368 219258576 2.606 12 2 4 0 221849376 2254672 336128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 06-12-2020 22:28:05 to 06-12-2020 22:28:36.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 166 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-12-2020 22:28:36 to 06-12-2020 22:28:38.

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          249840
MON$OLDEST_ACTIVE               251327
MON$OLDEST_SNAPSHOT             251327
MON$NEXT_TRANSACTION            251327
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                       2013760
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:88: 
:89: mscs-test-161.budzdorov.ru    Sun Dec  6 22:27:17 2020
:90:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:91: 
:92: 
:93: mscs-test-161.budzdorov.ru    Sun Dec  6 22:27:18 2020
:94:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:95: 
:96: 
:97: mscs-test-161.budzdorov.ru    Sun Dec  6 22:27:18 2020
:98:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:99: 
:100: 
:101: mscs-test-161.budzdorov.ru    Sun Dec  6 22:27:18 2020
:102:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:103: 
:104: 
:105: mscs-test-161.budzdorov.ru    Sun Dec  6 22:27:18 2020
:106:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:107: 
--- end of diff output ---

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

06.12.20 22:28:39. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-12-06 22:28:42 No severe PSQL-related problems occured
06.12.20 22:28:43. End of report.