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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17330036 kB
MemAvailable 31479508 kB
Buffers 0 kB
Cached 14385752 kB
SwapCached 2820 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.7
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-11-09 16:27:03
DTS_END                         2020-11-09 16:27:03.8510
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/55342
TRN_ID                          245040
ATT_ID                          679
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: 9532.62 24843 1143914
customer order: creation 173.09 325 20771
customer order: refuse 15.34 318 1841
order to supplier: creation 47.06 1243 5647
order to supplier: removal 3.46 91083 415
invoice (draft): creation 47.39 3192 5687
invoice (draft): removal 54.57 697 6548
invoice accept: apply 43.83 16951 5260
invoice accept: cancel 48.78 726 5853
customer reserve: creation 4033.25 168 483990
customer reserve: removal 4761.71 52 571405
realization accept: apply 85.31 172 10237
realization accept: cancel 85.96 112 10315
payment from customer: creation 60.79 130 7295
payment from customer: removal 6.03 90 723
payment to supplier: creation 50.43 149 6052
payment to supplier: removal 3.39 68 407
service: total inventory turnovers 4.76 1135 571
service: total monetary turnovers 6.48 57 777
service: aggregate perf. data 0.97 17627 116
service: refresh index statistics 0.03 362557 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-11-2020 16:29:06 to 09-11-2020 16:29:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7950
TEST_TIME 2 5441
TEST_TIME 3 5071
TEST_TIME 4 4217
TEST_TIME 5 4231
TEST_TIME 6 4587
TEST_TIME 7 5012
TEST_TIME 8 5391
TEST_TIME 9 5518
TEST_TIME 10 5741
TEST_TIME 11 6132
TEST_TIME 12 6327
TEST_TIME 13 6681
TEST_TIME 14 7303
TEST_TIME 15 7878
TEST_TIME 16 8052
TEST_TIME 17 8178
TEST_TIME 18 8571
TEST_TIME 19 8459
TEST_TIME 20 9284
TEST_TIME 21 9226
TEST_TIME 22 9485
TEST_TIME 23 10087
TEST_TIME 24 10260
TEST_TIME 25 10847
TEST_TIME 26 10756
TEST_TIME 27 11394
TEST_TIME 28 11299
TEST_TIME 29 11204
TEST_TIME 30 11049
TEST_TIME 31 11003
TEST_TIME 32 11019
TEST_TIME 33 10963
TEST_TIME 34 10742
TEST_TIME 35 10511
TEST_TIME 36 10447
TEST_TIME 37 10403
TEST_TIME 38 10439
TEST_TIME 39 10365
TEST_TIME 40 10250
TEST_TIME 41 10302
TEST_TIME 42 10347
TEST_TIME 43 10261
TEST_TIME 44 10149
TEST_TIME 45 10244
TEST_TIME 46 10173
TEST_TIME 47 10077
TEST_TIME 48 9977
TEST_TIME 49 10021
TEST_TIME 50 9990
TEST_TIME 51 9911
TEST_TIME 52 9846
TEST_TIME 53 9772
TEST_TIME 54 9744
TEST_TIME 55 9674
TEST_TIME 56 9626
TEST_TIME 57 9581
TEST_TIME 58 9635
TEST_TIME 59 9631
TEST_TIME 60 9680
TEST_TIME 61 9728
TEST_TIME 62 9783
TEST_TIME 63 9858
TEST_TIME 64 9826
TEST_TIME 65 9842
TEST_TIME 66 9902
TEST_TIME 67 9904
TEST_TIME 68 9922
TEST_TIME 69 9955
TEST_TIME 70 9993
TEST_TIME 71 9969
TEST_TIME 72 9868
TEST_TIME 73 9820
TEST_TIME 74 9773
TEST_TIME 75 9776
TEST_TIME 76 9751
TEST_TIME 77 9715
TEST_TIME 78 9687
TEST_TIME 79 9622
TEST_TIME 80 9576
TEST_TIME 81 9590
TEST_TIME 82 9604
TEST_TIME 83 9642
TEST_TIME 84 9603
TEST_TIME 85 9609
TEST_TIME 86 9679
TEST_TIME 87 9635
TEST_TIME 88 9659
TEST_TIME 89 9682
TEST_TIME 90 9747
TEST_TIME 91 9685
TEST_TIME 92 9752
TEST_TIME 93 9815
TEST_TIME 94 9874
TEST_TIME 95 9785
TEST_TIME 96 9717
TEST_TIME 97 9668
TEST_TIME 98 9685
TEST_TIME 99 9640
TEST_TIME 100 9612
TEST_TIME 101 9597
TEST_TIME 102 9577
TEST_TIME 103 9507
TEST_TIME 104 9481
TEST_TIME 105 9499
TEST_TIME 106 9507
TEST_TIME 107 9498
TEST_TIME 108 9477
TEST_TIME 109 9521
TEST_TIME 110 9537
TEST_TIME 111 9511
TEST_TIME 112 9493
TEST_TIME 113 9539
TEST_TIME 114 9565
TEST_TIME 115 9569
TEST_TIME 116 9609
TEST_TIME 117 9581
TEST_TIME 118 9577
TEST_TIME 119 9616
TEST_TIME 120 9536

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 09-11-2020 16:29:09 to 09-11-2020 16:29:13.

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 1589364 1589364 0 0.00 0 19638 6 0 0
doc_list_biud 1589364 1589364 0 0.00 0 45880 24 0 0
sp_add_invoice_to_stock 5345 5260 85 1.59 22 172739 16951 0 85
sp_cancel_adding_invoice 5853 5853 0 0.00 5 47092 726 0 0
sp_cancel_client_order 1841 1841 0 0.00 4 9297 319 0 0
sp_cancel_customer_reserve 571405 571405 0 0.00 1 45883 52 0 0
sp_cancel_pay_from_customer 723 723 0 0.00 2 5048 90 0 0
sp_cancel_pay_to_supplier 407 407 0 0.00 3 2761 69 0 0
sp_cancel_supplier_invoice 6554 6548 6 0.09 2 13954 697 0 6
sp_cancel_supplier_order 415 415 0 0.00 7 1010031 91083 0 0
sp_cancel_write_off 10315 10315 0 0.00 1 24558 112 0 0
sp_client_order 20771 20771 0 0.00 3 45440 326 0 0
sp_customer_reserve 483990 483990 0 0.00 0 113740 168 0 0
sp_fill_shopping_cart 32098 32098 0 0.00 1 14366 39 0 0
sp_fill_shopping_cart_clo_res 483983 483983 0 0.00 0 16173 13 0 0
sp_get_clo_for_invoice 5251 5251 0 0.00 0 40260 277 0 0
sp_kill_cost_storno 17298 17298 0 0.00 0 7308 51 0 0
sp_kill_qstorno_ret_qs2qd 1160088 1160088 0 0.00 0 45874 28 0 0
sp_kill_qty_storno 611865 611865 0 0.00 0 45880 62 0 0
sp_lock_selected_doc 21522 21522 0 0.00 0 9353 6 0 0
sp_make_cost_storno 28835 28835 0 0.00 0 17556 55 0 0
sp_multiply_rows_for_pdistr 28835 28835 0 0.00 0 7618 28 0 0
sp_multiply_rows_for_qdistr 20771 20771 0 0.00 0 36569 148 0 0
sp_pay_from_customer 7295 7295 0 0.00 4 19890 131 0 0
sp_pay_to_supplier 6052 6052 0 0.00 4 19229 150 0 0
sp_payment_common 13347 13347 0 0.00 1 19877 44 0 0
sp_qd_handle_on_cancel_clo 1841 1841 0 0.00 0 9269 297 0 0
sp_qd_handle_on_invoice_upd_sts 11104 11104 0 0.00 0 25119 324 0 0
sp_qd_handle_on_reserve_upd_sts 10237 10237 0 0.00 0 26766 58 0 0
sp_reserve_write_off 10237 10237 0 0.00 6 26779 173 0 0
sp_supplier_invoice 5687 5687 0 0.00 6 77212 3193 0 0
sp_supplier_order 5647 5647 0 0.00 5 18497 1243 0 0
srv_aggregate_perf_data 116 116 0 0.00 2065 148944 17627 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1214 190591 32630 0 0
srv_find_qd_qs_mism 1093383 1093383 0 0.00 0 16266 5 0 0
srv_make_invnt_saldo 571 571 0 0.00 37 101744 1136 0 0
srv_make_money_saldo 777 777 0 0.00 0 17276 57 0 0
srv_recalc_idx_stat 4 4 0 0.00 171662 584710 362557 0 0
t$perf-abend:sp_add_invoice_to_stock 85 85 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5261 5261 0 0.00 0 11395 153 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 0 5464 93 0 0
t$perf-norm:sp_cancel_client_order 1841 1841 0 0.00 0 1685 11 0 0
t$perf-norm:sp_cancel_customer_reserve 717 717 0 0.00 0 5265 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 723 723 0 0.00 0 3807 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 407 407 0 0.00 0 133 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 446 446 0 0.00 0 2388 21 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 30812 1553 0 0
t$perf-norm:sp_cancel_write_off 1062 1062 0 0.00 0 1821 6 0 0
t$perf-norm:sp_client_order 20771 20771 0 0.00 0 9620 16 0 0
t$perf-norm:sp_customer_reserve 1064 1064 0 0.00 0 688 4 0 0
t$perf-norm:sp_pay_from_customer 7295 7295 0 0.00 0 8958 9 0 0
t$perf-norm:sp_pay_to_supplier 6052 6052 0 0.00 0 8957 12 0 0
t$perf-norm:sp_reserve_write_off 10237 10237 0 0.00 0 9609 12 0 0
t$perf-norm:sp_supplier_invoice 5687 5687 0 0.00 0 10083 22 0 0
t$perf-norm:sp_supplier_order 5647 5647 0 0.00 0 12020 18 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 379 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 302 5 0 0
t$perf-norm:srv_make_invnt_saldo 571 571 0 0.00 0 955 18 0 0
t$perf-norm:srv_make_money_saldo 777 777 0 0.00 0 1375 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 10672 10502 170 1.59 0 3020 15 0 170
v_all_customers 37794 37794 0 0.00 0 20 1 0 0
v_all_suppliers 31332 31332 0 0.00 0 28 1 0 0
v_all_wares 41542 41542 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 829 6 0 0
v_cancel_client_order 3682 3682 0 0.00 0 1890 4 0 0
v_cancel_customer_prepayment 1446 1446 0 0.00 0 2982 8 0 0
v_cancel_customer_reserve 1434 1434 0 0.00 0 248 3 0 0
v_cancel_payment_to_supplier 814 814 0 0.00 0 1028 5 0 0
v_cancel_supplier_invoice 904 892 12 1.32 0 214 13 0 12
v_cancel_supplier_order 830 830 0 0.00 0 1323 4 0 0
v_cancel_write_off 2124 2124 0 0.00 0 2154 13 0 0
v_max_id_clo_ord 5647 5647 0 0.00 0 2404 2 0 0
v_max_id_clo_res 1064 1064 0 0.00 0 2587 11 0 0
v_max_id_ord_sup 5679 5679 0 0.00 0 5054 3 0 0
v_max_non_paid_invoice 1712 1712 0 0.00 0 396 2 0 0
v_max_non_paid_realizn 4020 4020 0 0.00 0 1364 4 0 0
v_min_id_clo_ord 5647 5647 0 0.00 0 14213 11 0 0
v_min_id_clo_res 1064 1064 0 0.00 0 3806 12 0 0
v_min_id_ord_sup 5679 5679 0 0.00 0 5852 10 0 0
v_min_non_paid_invoice 6052 6052 0 0.00 0 14404 34 0 0
v_min_non_paid_realizn 7295 7295 0 0.00 0 14402 32 0 0
v_our_firm 10298 10298 0 0.00 0 32 1 0 0
v_reserve_write_off 20474 20474 0 0.00 0 4817 5 0 0
x_lock_depdocs_on_canc_invoice 11955 11955 0 0.00 0 15769 105 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 5114 298 0 0
x_make_qstorno_1000_1200 5647 5647 0 0.00 2 16904 1158 0 0
x_make_qstorno_1200_2000 5687 5687 0 0.00 2 74184 3059 0 0
x_make_qstorno_2100_3300 483990 483990 0 0.00 0 113737 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-11-2020 16:29:14 to 09-11-2020 16:29:18.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:12 10420 8192000000 10171606304 10468057088 887390608 9.773 71 51 103 1 907571728 2550032 17631088
13:57:32 24196 8192000000 10341731248 10659827712 1354465584 14.188 100 73 147 0 1382403760 4300320 23637856
13:58:09 41818 8192000000 10384432784 10710335488 1439571664 14.946 100 91 182 1 1475638960 6613664 29453632
13:59:07 24168 8192000000 10416124928 10745241600 1466735728 15.185 100 87 174 0 1502833056 7846432 28250896
13:59:40 22665 8192000000 10433019872 10763120640 1486183216 15.356 100 88 175 2 1523183136 8350864 28649056
14:00:14 4614 8192000000 10445032560 10778525696 1503236816 15.504 100 87 174 1 1539707936 8643136 27827984
14:00:30 22713 8192000000 10467051216 10803134464 1513982960 15.598 100 89 178 1 1552249632 9464208 28802464
14:01:09 16272 8192000000 10490301968 10835251200 1535432224 15.784 100 78 156 0 1569239808 9842352 23965232
14:01:35 13090 8192000000 10507602192 10858487808 1572445872 16.103 100 84 169 0 1608859872 10524960 25889040
14:02:02 17713 8192000000 10547489056 10905800704 1606714992 16.397 100 78 156 0 1641326272 11019104 23592176
14:02:28 13941 8192000000 10572469872 10932502528 1631499216 16.608 100 82 164 2 1667144016 11289056 24355744
14:02:52 10478 8192000000 10593907424 10956644352 1647662176 16.745 100 79 157 0 1682662160 11869200 23130784
14:03:12 10447 8192000000 10605450672 10973659136 1663745232 16.880 100 73 146 1 1696844528 12002224 21097072
14:03:29 8066 8192000000 10623221184 10989096960 1680944272 17.025 100 77 156 2 1715506352 11847392 22714688
14:03:46 7383 8192000000 10645730608 11011497984 1696452736 17.155 100 76 152 2 1730613344 12489408 21671200
14:04:02 10591 8192000000 10651713664 11028185088 1713016336 17.294 100 80 160 1 1753323952 16451472 23856144
14:04:20 7434 8192000000 10659239344 11041488896 1730482256 17.440 100 68 136 2 1761678976 11961568 19235152
14:04:35 6103 8192000000 10675323552 11053240320 1742098064 17.536 100 75 150 1 1774728848 11012976 21617808
14:04:47 6472 8192000000 10684724752 11065655296 1755268032 17.645 100 70 138 2 1786081040 10748016 20064992
14:05:02 3045 8192000000 10688958832 11077435392 1764072640 17.718 100 69 137 1 1799155184 15601424 19481120
14:05:13 3243 8192000000 10711326208 11091836928 1777338672 17.828 100 70 139 3 1807789712 10700064 19750976
14:05:23 6062 8192000000 10721692656 11103834112 1783239536 17.876 100 74 148 1 1816035264 11555264 21240464
14:05:36 3457 8192000000 10728707968 11117699072 1788350880 17.918 100 69 138 1 1818723984 11673872 18699232
14:05:46 4175 8192000000 10736980208 11125420032 1801929104 18.030 100 75 150 2 1835147440 11452576 21765760
14:05:57 4836 8192000000 10749357360 11137617920 1816049072 18.145 100 73 145 0 1848166288 12024992 20092224
14:06:11 3064 8192000000 10748098576 11145543680 1824535408 18.215 100 83 166 0 1860050816 12351600 23163808
14:06:20 2992 8192000000 10763333136 11152490496 1827210752 18.237 100 79 160 2 1860927296 11508208 22208336
14:06:30 2739 8192000000 10771372912 11160637440 1829395584 18.254 100 79 157 0 1864194016 12834400 21964032
14:06:39 2403 8192000000 10775095120 11158671360 1836927088 18.316 100 87 175 0 1873853408 12678656 24247664
14:06:48 3176 8192000000 10783556800 11170418688 1845054000 18.382 100 88 173 4 1880699968 11379968 24266000
14:06:57 1859 8192000000 10787362880 11174014976 1844368736 18.376 100 89 178 0 1882354256 13597008 24388512
14:07:06 2936 8192000000 10789185184 11178823680 1851119552 18.431 100 86 173 0 1888895040 13261712 24513776
14:07:15 2570 8192000000 10785918416 11176644608 1850849680 18.429 100 80 160 3 1885408560 12027504 22531376
14:07:24 2660 8192000000 10799020544 11190280192 1854991344 18.463 100 86 172 2 1891847056 12541952 24313760
14:07:33 2778 8192000000 10806269248 11193241600 1862471376 18.523 100 91 183 0 1902115968 13791744 25852848
14:07:43 2890 8192000000 10805537008 11194478592 1861908784 18.519 100 89 177 1 1899778048 13677536 24191728
14:07:53 5701 8192000000 10802838560 11188891648 1859490560 18.499 100 83 166 0 1897815472 15020384 23304528
14:08:05 3557 8192000000 10794872192 11189108736 1860076064 18.504 100 78 153 1 1895379264 13228272 22074928
14:08:15 1813 8192000000 10802804464 11192381440 1862551600 18.524 100 82 165 3 1898546576 12147184 23847792
14:08:24 2148 8192000000 10800708768 11199201280 1865859248 18.551 100 87 175 0 1903732064 13491536 24381280
14:08:33 11296 8192000000 10805158960 11199795200 1862200384 18.521 100 59 119 1 1889860736 10955040 16705312
14:08:51 16913 8192000000 10787887104 11197091840 1865483440 18.548 100 60 119 0 1893800560 11169632 17147488
14:09:14 4356 8192000000 10785351408 11199545344 1865145408 18.545 100 48 96 1 1887278896 8489888 13643600
14:09:26 2583 8192000000 10792186576 11204173824 1876204064 18.634 100 63 128 1 1902868944 8863296 17801584
14:09:35 3049 8192000000 10782113120 11200159744 1867063536 18.561 100 43 87 0 1887623856 8449264 12111056
14:09:46 7544 8192000000 10784659312 11194335232 1865727376 18.550 100 26 49 0 1878029232 5986912 6314944
14:10:01 4883 8192000000 10784561920 11200585728 1866346608 18.555 100 33 66 1 1884100640 8298128 9455904
14:10:12 5894 8192000000 10779906096 11201142784 1871337616 18.595 100 36 73 2 1887265328 5801552 10126160
14:10:28 8855 8192000000 10775290656 11201622016 1869580144 18.581 100 29 59 2 1884148336 6079664 8488528
14:10:46 7331 8192000000 10775224608 11203530752 1868522032 18.572 100 14 27 0 1879734656 6334768 4877856
14:11:04 10682 8192000000 10784441648 11210764288 1871583136 18.597 100 19 38 1 1887118224 10357888 5177200
14:11:23 8404 8192000000 10776653728 11207729152 1876430800 18.636 100 32 65 0 1891959200 6272480 9255920
14:11:42 7543 8192000000 10783515488 11209134080 1873592304 18.613 100 19 38 1 1885959904 7117952 5249648
14:11:58 9317 8192000000 10786112720 11214073856 1878198768 18.651 100 21 42 2 1890570688 6049216 6322704
14:12:15 67843 8192000000 10826856224 11228459008 1885631216 18.711 100 53 104 3 1906030432 5517344 14881872
14:13:29 1633 8192000000 10821340976 11236659200 1893478464 18.774 100 74 148 3 1925329792 10564928 21286400
14:13:37 5568 8192000000 10801132752 11228336128 1885450272 18.709 100 35 70 1 1904546784 8419184 10677328
14:13:49 6584 8192000000 10790827808 11226886144 1885310784 18.708 100 30 61 1 1900422048 6160192 8951072
14:14:02 5025 8192000000 10806898720 11233284096 1888058368 18.730 100 36 73 2 1905723504 7547424 10117712
14:14:15 4269 8192000000 10811407792 11239473152 1890105008 18.747 100 25 51 2 1908444832 10261312 8078512
14:14:27 5216 8192000000 10810600192 11237281792 1894476000 18.782 100 39 77 4 1912845184 6905280 11463904
14:14:40 6460 8192000000 10814927488 11239948288 1890183968 18.747 100 25 50 1 1903857696 5733648 7940080
14:14:52 5925 8192000000 10809135536 11242487808 1893405056 18.773 100 28 56 1 1908728544 7353600 7969888
14:15:08 52818 8192000000 10805972816 11246321664 1902331632 18.845 100 25 50 2 1914524896 5046288 7146976
14:16:07 10523 8192000000 10810725856 11244273664 1894537824 18.782 100 22 45 0 1905657776 5316880 5803072
14:16:24 6992 8192000000 10817406496 11247456256 1897382016 18.805 100 27 54 0 1911527328 6819296 7326016
14:16:38 4041 8192000000 10806669280 11237990400 1892133504 18.763 100 36 72 1 1909246400 6952784 10160112
14:16:52 4446 8192000000 10795913424 11218104320 1861819536 18.518 99 28 56 0 1875831168 6078176 7933456
14:17:03 5260 8192000000 10795765840 11217305600 1860561696 18.508 99 17 34 0 1871269216 5266864 5440656
14:17:16 9231 8192000000 10779087552 11218104320 1850355824 18.425 98 34 68 1 1866847040 6720720 9770496
14:17:33 8538 8192000000 10769406432 11192868864 1804039344 18.047 96 27 54 2 1817132224 5225680 7867200
14:17:50 6041 8192000000 10763637120 11181600768 1787938928 17.915 96 31 61 3 1801904688 5135040 8830720
14:18:04 5165 8192000000 10750963360 11167490048 1803385952 18.042 98 36 72 1 1819972032 6280688 10305392
14:18:15 5058 8192000000 10744540176 11165708288 1803641696 18.044 98 27 54 0 1818308960 6135040 8532224
14:18:28 6672 8192000000 10719473584 11147321344 1777497488 17.829 97 22 44 1 1789820688 5903744 6419456
14:18:42 9148 8192000000 10695413936 11112312832 1658333824 16.835 91 25 51 2 1671120000 5144592 7641584
14:18:59 66909 8192000000 10698132848 11122475008 1708754272 17.258 94 31 61 4 1722512320 4892368 8865680
14:20:14 9755 8192000000 10699554016 11119521792 1744131872 17.553 97 24 47 2 1757274832 5799840 7343120
14:20:36 5818 8192000000 10696433520 11111440384 1771388976 17.778 99 43 86 1 1794238544 10458480 12391088
14:20:50 5415 8192000000 10694590048 11106115584 1736429168 17.489 97 28 56 0 1750209904 5670096 8110640
14:21:04 6269 8192000000 10681660224 11094126592 1755737248 17.649 99 31 62 2 1770206000 5390064 9078688
14:21:17 5671 8192000000 10697253056 11112542208 1770777664 17.773 99 29 58 1 1785619472 6426032 8415776
14:21:31 10622 8192000000 10726537552 11142754304 1787032624 17.907 99 20 41 0 1802221616 9609024 5579968
14:21:48 12724 8192000000 10719584704 11138097152 1762494112 17.705 97 27 54 0 1776088752 4974768 8619872
14:22:08 7439 8192000000 10734575296 11150467072 1798999728 18.006 99 26 52 0 1811764160 4664000 8100432
14:22:21 7635 8192000000 10741410496 11157569536 1821383824 18.189 100 31 60 1 1839950512 9481136 9085552
14:22:35 10741 8192000000 10742622624 11162566656 1828024864 18.243 100 28 54 1 1841672544 5562096 8085584
14:22:52 7476 8192000000 10744211408 11157925888 1811105984 18.105 99 22 44 1 1823507936 5847168 6554784
14:23:09 13857 8192000000 10741211584 11169619968 1835886000 18.307 100 18 36 2 1846860112 5703184 5270928
14:23:29 6771 8192000000 10756126480 11179245568 1843062512 18.366 100 15 30 1 1852191936 5138288 3991136
14:23:43 20611 8192000000 10770699120 11183931392 1846453760 18.393 100 23 46 3 1859331776 5344960 7533056
14:24:10 68248 8192000000 10776751120 11202707456 1853927184 18.454 100 39 78 0 1874585120 10126704 10531232
14:25:27 8142 8192000000 10766479808 11198173184 1859163488 18.496 100 24 48 2 1872362656 6016688 7182480
14:25:42 3344 8192000000 10784293200 11205517312 1864149792 18.537 100 43 86 1 1883955024 7781584 12023648
14:25:52 6624 8192000000 10792014080 11210055680 1865825616 18.550 100 42 84 1 1884501760 6734448 11941696
14:26:07 9613 8192000000 10791772112 11212722176 1869787072 18.583 100 34 68 2 1886470048 5993328 10689648
14:26:24 5243 8192000000 10788630896 11213811712 1869078208 18.577 100 23 46 2 1881435040 5481568 6875264
14:26:37 8108 8192000000 10780826832 11213029376 1872901296 18.608 100 33 65 4 1888600480 5716800 9982384
14:26:56 5073 8192000000 10793042416 11219488768 1877731840 18.647 100 29 58 2 1893132480 5898736 9501904
14:27:34 9860 8192000000 10830389392 11243687936 1899213056 18.820 100 46 92 0 1923077584 9540256 14324272
14:27:58 5662 8192000000 10845463776 11258220544 1910068512 18.907 100 59 118 2 1936997936 9942528 16986896
14:28:11 25131 8192000000 10846199856 11267620864 1917803648 18.969 100 50 100 0 1943163456 10670720 14689088
14:28:49 8768 8192000000 10856980784 11279409152 1924962960 19.027 100 45 88 2 1946883056 10037904 11882192
14:29:05 28071 8192000000 10865139360 11290046464 1933944256 19.098 100 49 98 1 1961181040 13283824 13952960
14:29:41 52765 8192000000 10866628128 11302490112 1929752912 19.065 99 46 92 1 1956751408 14147040 12851456
14:30:44 63343 8192000000 10895585184 11318636544 1955634976 19.271 100 44 88 1 1983740096 14938000 13167120
14:32:24 33233 8192000000 10887114064 11330543616 1958928688 19.298 100 31 62 0 1986672944 18910032 8834224
14:33:04 30802 8192000000 10885547536 11336159232 1960387152 19.309 100 25 49 1 1984765792 17026592 7352048
14:33:43 16215 8192000000 10904020064 11340214272 1968425728 19.373 100 37 74 2 1997676864 17637344 11613792
14:34:25 26574 8192000000 10910655824 11354005504 1979131984 19.458 100 45 90 3 2013503408 20486608 13884816
14:35:01 10269 8192000000 10918492448 11356061696 1981133248 19.474 100 42 84 2 2013245664 18944064 13168352
14:35:20 4833 8192000000 10944783312 11368108032 1986669888 19.517 100 58 116 0 2024424784 19511344 18243552
14:35:32 3041 8192000000 10934029936 11357331456 1984075456 19.497 100 65 128 0 2021582704 18522880 18984368
14:35:59 9211 8192000000 10940427776 11375632384 1992311984 19.562 100 51 100 0 2028167632 20697392 15158256
14:36:15 2601 8192000000 10951191520 11377225728 2000117888 19.624 100 73 146 1 2043469248 20900608 22450752
14:36:26 3787 8192000000 10940046496 11372326912 1975775056 19.431 99 53 106 0 2016861488 25229152 15857280
14:36:37 6719 8192000000 10950355632 11378511872 1994020288 19.576 100 59 113 1 2036887280 24902672 17964320
14:36:55 4144 8192000000 10955119616 11387285504 1997208032 19.601 100 56 110 1 2038774864 25357680 16209152
14:37:08 6358 8192000000 10952142720 11386970112 2000559936 19.627 100 54 108 3 2044066176 26585168 16921072
14:37:22 1213 8192000000 10962695040 11395698688 2004325120 19.657 100 58 117 1 2048334032 26931456 17077456
14:37:30 3466 8192000000 10969105856 11395993600 1996280368 19.593 99 76 150 4 2044746672 26670656 21795648
14:37:43 8786 8192000000 10982517360 11401785344 2010452656 19.705 100 77 154 0 2062449568 28930128 23066784
14:38:02 4830 8192000000 10979890976 11399327744 2008765664 19.692 100 79 158 0 2063262800 30504512 23992624
14:38:15 5288 8192000000 10974140272 11399757824 2010525136 19.706 100 69 138 1 2059553648 28244144 20784368
14:38:29 6259 8192000000 10963514864 11379085312 1996742080 19.597 100 82 164 3 2050165968 28640640 24783248
14:38:49 1781 8192000000 10973989024 11393294336 2002303952 19.641 100 80 160 1 2057661072 31449680 23907440
14:39:01 4590 8192000000 10953851120 11378249728 1977649360 19.446 99 75 148 1 2032627504 32411520 22566624
14:39:17 5165 8192000000 10959081408 11376046080 1985457280 19.508 100 86 173 2 2046597760 34107664 27032816
14:39:33 5408 8192000000 10957077952 11380408320 1989858448 19.543 100 81 162 1 2050388160 35452320 25077392
14:39:45 12175 8192000000 10955051264 11379949568 1983877632 19.495 100 65 130 3 2038631952 34420096 20334224
14:40:07 1408 8192000000 10972678176 11394654208 1995511984 19.587 100 82 165 2 2059335120 38290272 25532864
14:40:17 4093 8192000000 10962266016 11383054336 1984027216 19.497 100 70 140 1 2043794448 38469248 21297984
14:40:34 2469 8192000000 10968021632 11394592768 1990056080 19.544 100 72 143 1 2052034880 39324096 22654704
14:40:44 2029 8192000000 10987470032 11406045184 2001600192 19.635 100 70 139 0 2066532112 43779488 21152432
14:40:53 7117 8192000000 10966321072 11386851328 1974452464 19.421 99 71 142 0 2037023584 39853808 22717312
14:41:07 4427 8192000000 10955139408 11380994048 1957321088 19.285 98 73 147 1 2021993888 40926656 23746144
14:41:17 3231 8192000000 10972384912 11394461696 1991116064 19.553 100 80 160 1 2056713008 40666528 24930416
14:41:29 3121 8192000000 10975200976 11394289664 1987129824 19.521 100 84 167 1 2054186640 41978976 25077840
14:41:39 2094 8192000000 10971211184 11392212992 1974229856 19.419 99 73 146 0 2040493008 43065712 23197440
14:41:49 3317 8192000000 10975620944 11396759552 1995278768 19.585 100 82 161 1 2061006272 40818624 24908880
14:41:59 4290 8192000000 10962656496 11383177216 1971295552 19.396 99 77 152 0 2032444224 38004480 23144192
14:42:12 1936 8192000000 10971723152 11384229888 1988604592 19.533 100 90 177 2 2047073984 31976672 26492720
14:42:22 2138 8192000000 10959362464 11379163136 1987150720 19.521 100 81 161 3 2044730192 33089328 24490144
14:42:31 6451 8192000000 10951842784 11378130944 1966795248 19.360 99 65 130 1 2023385744 37219264 19371232
14:42:46 5324 8192000000 10958495984 11384070144 1984659952 19.502 100 61 121 2 2037541408 33957328 18924128
14:43:00 3351 8192000000 10949428112 11387617280 1990237728 19.546 100 61 122 1 2044536608 34611168 19687712
14:43:13 20308 8192000000 10933609136 11372797952 1931161056 19.076 97 32 64 0 1971653696 29247296 11245344
14:43:41 2737 8192000000 10928986064 11352231936 1948521152 19.215 98 69 136 0 2000764256 30956336 21286768
14:43:51 3441 8192000000 10956906432 11370741760 1978926384 19.456 100 85 169 1 2038398272 33622800 25849088
14:44:01 5025 8192000000 10943270160 11371589632 1973455648 19.413 100 62 124 1 2028740704 36159520 19125536
14:44:15 14106 8192000000 10937057120 11377025024 1974341024 19.420 100 38 76 0 2018659808 32050208 12268576
14:44:37 5681 8192000000 10932218176 11353341952 1943070368 19.171 98 67 132 4 1997472080 33795472 20606240
14:44:51 2285 8192000000 10937637712 11355058176 1958657088 19.295 99 75 148 2 2019388656 36938240 23793328
14:45:02 4496 8192000000 10969156736 11383431168 1982613632 19.485 100 84 168 1 2047382832 38509344 26259856
14:45:14 2313 8192000000 10961247472 11374718976 1975688800 19.431 100 82 166 0 2040422720 38772256 25961664
14:45:23 7410 8192000000 10970670816 11390607360 1983296704 19.491 100 72 144 1 2046872288 41500656 22074928
14:45:37 1423 8192000000 10958874960 11370119168 1969011440 19.378 100 86 172 0 2036340080 41235120 26093520
14:45:45 1602 8192000000 10966382256 11377954816 1976698288 19.439 100 78 156 2 2041376848 40597936 24080624
14:45:55 5327 8192000000 10937301920 11360591872 1961406992 19.317 99 63 128 1 2018812928 37639776 19766160
14:46:09 10637 8192000000 10937107168 11370565632 1970324912 19.388 100 47 94 1 2021223904 35620576 15278416
14:46:34 3817 8192000000 10960090144 11373707264 1964491744 19.342 99 80 161 0 2027748784 38043440 25213600
14:46:46 4275 8192000000 10979785040 11388530688 1983481568 19.492 100 82 165 0 2049325632 40057296 25786768
14:46:58 5023 8192000000 10976050320 11384700928 1983588864 19.493 100 88 175 3 2054291952 43294608 27408480
14:47:10 16514 8192000000 10943824880 11380920320 1971059312 19.394 100 63 125 2 2036281552 45935360 19286880
14:47:38 11093 8192000000 10906308608 11367047168 1930596592 19.072 98 24 48 0 1974975728 36348064 8031072
14:47:55 15862 8192000000 10912487952 11363221504 1942156432 19.164 99 26 52 1 1985510912 34534784 8819696
14:48:25 18567 8192000000 10914872800 11364937728 1960514960 19.310 100 33 66 2 2010407936 38898656 10994320
14:48:58 11157 8192000000 10920381584 11360247808 1950401712 19.230 100 35 70 1 2003961888 41313328 12246848
14:49:17 17889 8192000000 10894052928 11343650816 1882325344 18.684 96 36 72 2 1936951344 42526880 12099120
14:49:52 6419 8192000000 10910960304 11344723968 1931431952 19.078 100 48 93 0 1987282208 40597712 15252544
14:50:07 7797 8192000000 10911681824 11361206272 1945812128 19.193 100 43 86 2 2005769776 45635728 14321920
14:50:22 31047 8192000000 10885618800 11334754304 1927545344 19.047 99 27 54 1 1977255424 40296608 9413472
14:51:01 21207 8192000000 10886458912 11341537280 1897394768 18.805 98 21 42 0 1945433472 40364768 7673936
14:51:34 5726 8192000000 10901372608 11332456448 1902451520 18.846 98 51 101 1 1954756080 36755840 15548720
14:51:54 20274 8192000000 10898061344 11327180800 1913448544 18.934 99 25 50 0 1955332224 33590208 8293472
14:52:22 24764 8192000000 10891211216 11338448896 1933216608 19.093 100 25 50 0 1970816448 29866656 7733184
14:53:05 50840 8192000000 10830534384 11275124736 1828821168 18.250 95 13 26 1 1855636208 22352560 4462480
14:54:19 22008 8192000000 10842518464 11301220352 1886287472 18.716 99 11 22 0 1921172320 30992544 3892304
14:54:49 13426 8192000000 10846807280 11305525248 1909118592 18.900 100 3 6 0 1919100720 9257408 724720
14:55:09 86694 8192000000 10876771456 11327381504 1911854640 18.922 99 11 22 0 1930015312 14921600 3239072
14:56:47 45039 8192000000 10877633536 11311288320 1881405232 18.676 97 27 55 0 1897748304 7620336 8722736
14:57:43 40686 8192000000 10886178752 11328626688 1940105728 19.148 100 28 56 0 1956577952 9301184 7171040
14:58:31 43037 8192000000 10886072848 11351629824 1956743296 19.280 100 12 24 2 1971359152 11189248 3426608
14:59:24 50135 8192000000 10893190016 11341094912 1910415184 18.910 97 30 61 0 1928635888 10326976 7893728
15:00:22 124009 8192000000 10884429168 11322478592 1862891168 18.527 95 30 60 2 1880250048 9231904 8126976
15:02:40 35367 8192000000 10889534160 11334135808 1935141072 19.108 99 30 60 2 1954128768 10287040 8700656
15:03:31 39843 8192000000 10879996208 11349696512 1936214864 19.117 99 28 56 2 1962440928 17886976 8339088
15:04:36 68129 8192000000 10895444848 11351728128 1960662656 19.311 100 14 29 0 1978446256 13596096 4187504
15:05:51 10109 8192000000 10889042240 11355635712 1968876880 19.377 100 14 26 1 1983742336 11530912 3334544
15:06:08 26875 8192000000 10912788736 11370676224 1980513888 19.469 100 29 54 1 1997751760 9929280 7308592
15:06:47 35407 8192000000 10948617504 11390611456 1994374752 19.578 100 49 94 0 2021030000 13005712 13649536
15:07:32 38317 8192000000 10938225008 11400056832 1996384896 19.594 100 52 104 2 2032876976 21347840 15144240
15:08:20 44372 8192000000 10904452704 11375628288 1956715616 19.280 98 27 54 1 1980305376 15932672 7657088
15:09:17 163247 8192000000 10908807264 11368030208 1891569696 18.758 95 16 30 2 1908726192 12795584 4360912
15:12:12 49461 8192000000 10894402720 11363409920 1950858464 19.233 99 17 34 1 1969785744 14223232 4704048
15:13:14 37458 8192000000 10887428720 11361562624 1967354960 19.364 100 18 35 0 1982487616 10200720 4931936
15:13:57 18682 8192000000 10901287616 11371040768 1977635856 19.446 100 18 36 0 1995340000 12563280 5140864
15:14:26 14441 8192000000 10893599456 11368235008 1952549680 19.247 99 9 18 0 1969613648 14552768 2511200
15:14:47 16782 8192000000 10897919088 11375640576 1974894976 19.424 100 7 14 0 1991644272 14738800 2010496
15:15:10 10102 8192000000 10896841808 11372732416 1956695136 19.280 99 7 14 0 1974721920 16063456 1963328
15:15:30 19166 8192000000 10906416816 11370881024 1968828272 19.376 100 12 22 0 1989302640 17279696 3194672
15:16:00 92107 8192000000 10903148624 11373338624 1951769056 19.241 99 6 12 0 1961448112 7435872 2243184
15:17:49 55500 8192000000 10897834704 11383853056 1980897120 19.472 100 23 46 1 2001338592 13853312 6588160
15:18:51 42423 8192000000 10890416048 11367014400 1938819776 19.137 98 12 24 0 1951831088 9724944 3286368
15:19:53 65733 8192000000 10873637936 11344703488 1900724560 18.832 96 16 30 1 1918718880 13812832 4181488
15:21:08 73063 8192000000 10875094496 11354370048 1950071152 19.227 100 6 12 0 1960015648 8384848 1559648
15:22:27 29991 8192000000 10859021664 11332194304 1920627440 18.992 98 10 19 1 1934739264 11819696 2292128
15:23:04 50916 8192000000 10852386048 11328581632 1880015632 18.665 96 7 14 1 1888155008 6301152 1838224
15:24:02 21166 8192000000 10876991040 11340161024 1909843408 18.905 98 20 39 2 1924271296 8902496 5525392
15:24:29 61039 8192000000 10884881872 11361087488 1927431808 19.046 98 14 27 1 1942103136 10731568 3939760
15:25:38 27529 8192000000 10872220832 11342778368 1919441328 18.982 98 22 44 2 1937570064 12087680 6041056
15:26:12 22160 8192000000 10888174704 11351404544 1954397136 19.261 100 40 81 2 1978827808 13001328 11429344
15:26:43 35763 8192000000 10877248704 11346436096 1919588208 18.984 98 21 42 0 1940134528 14654992 5891328
15:27:25 77697 8192000000 10861724400 11343446016 1875093504 18.625 96 20 39 0 1893608992 12580880 5934608
15:28:50 22513 8192000000 10894113664 11351220224 1944031808 19.179 99 30 60 2 1962369760 10242000 8095952
15:29:22 42107 8192000000 10859143616 11329548288 1891468032 18.758 96 21 42 0 1911674944 14230064 5976848
15:30:11 45947 8192000000 10848552032 11310051328 1795506720 17.977 92 15 30 0 1810288896 10437824 4344352
15:31:10 55543 8192000000 10863075344 11323404288 1897006256 18.802 98 27 54 2 1917622752 13065424 7551072
15:32:17 48324 8192000000 10875590704 11342737408 1929450176 19.062 99 26 51 1 1947425520 10921712 7053632
15:33:25 43341 8192000000 10879806896 11342675968 1897329728 18.805 97 18 37 0 1912296944 9799664 5167552
15:34:28 40774 8192000000 10880239680 11338883072 1912395120 18.926 98 29 58 1 1931586320 10791488 8399712
15:35:17 14930 8192000000 10894454832 11345100800 1913464592 18.934 98 40 81 2 1935207152 10346480 11396080
15:35:43 63471 8192000000 10859537072 11332562944 1831292816 18.270 94 24 48 0 1853071360 15099808 6678736
15:37:32 45902 8192000000 10869575232 11348832256 1924046752 19.019 99 13 26 1 1939217600 11739008 3431840
15:38:24 49860 8192000000 10885243664 11347300352 1933748016 19.097 99 37 74 1 1955555376 11081872 10725488
15:39:34 75000 8192000000 10849179104 11314823168 1867159168 18.561 96 34 67 0 1884984768 8431776 9393824
15:40:56 96384 8192000000 10890080384 11362717696 1950132336 19.228 100 21 42 2 1968067312 11747728 6187248
15:42:45 17900 8192000000 10869033712 11359608832 1952444336 19.246 100 11 22 1 1967113872 11640432 3029104
15:43:13 32949 8192000000 10863879312 11346685952 1919413616 18.982 98 14 28 0 1935034608 11826432 3794560
15:43:52 27014 8192000000 10865502240 11355738112 1952293904 19.245 100 4 8 0 1965698208 12255664 1148640
15:44:34 19961 8192000000 10845396080 11320463360 1888941888 18.737 97 14 28 0 1902648240 10285808 3420544
15:45:00 87193 8192000000 10874571840 11343003648 1917037824 18.963 99 15 30 1 1934241056 12903936 4299296
15:46:33 50433 8192000000 10882405136 11363962880 1958081312 19.291 100 17 34 1 1974847248 11332672 5433264
15:47:34 70466 8192000000 10875840128 11356020736 1893711344 18.776 97 8 16 0 1912305456 16112912 2481200
15:48:51 45495 8192000000 10866913200 11350323200 1923990080 19.019 99 12 24 2 1946237312 18119856 4127376
15:49:43 24584 8192000000 10865740848 11337015296 1946867232 19.202 100 23 46 0 1963780800 10282800 6630768
15:50:14 61483 8192000000 10882267600 11362234368 1947683488 19.208 100 12 24 0 1959418752 8451456 3283808
15:51:22 38397 8192000000 10914515216 11376721920 1969025280 19.378 100 22 44 2 1986614240 11066912 6522048
15:52:29 71152 8192000000 10910285168 11399217152 1979240944 19.459 100 18 36 1 2003480368 18855488 5383936
15:53:49 40799 8192000000 10897576992 11361902592 1945946208 19.194 98 15 28 2 1961143824 10199936 4997680
15:54:38 44316 8192000000 10913898016 11396841472 1988223440 19.530 100 29 58 0 2017636208 21155312 8257456
15:55:31 58125 8192000000 10914574544 11395080192 1951943664 19.242 98 31 62 0 1977667248 16000960 9722624
15:56:35 108508 8192000000 10908996608 11367579648 1845456512 18.385 93 16 32 0 1864859408 14977200 4425696
15:58:30 19504 8192000000 10920811984 11375190016 1977900032 19.448 100 40 78 1 1999750992 11167264 10683696
15:58:55 22643 8192000000 10914749376 11378683904 1960804192 19.312 99 35 70 2 1983106624 12916208 9386224
15:59:27 85638 8192000000 10914466496 11396521984 1980369984 19.468 100 15 30 1 1999973104 15785728 3817392
16:01:06 157658 8192000000 10908644192 11372552192 1916041376 18.955 96 18 36 0 1934040400 13268448 4730576
16:03:50 31872 8192000000 10918624544 11379691520 1988523936 19.532 100 34 68 2 2006359104 7692816 10142352
16:04:28 63732 8192000000 10902602368 11376652288 1953518096 19.254 98 28 54 1 1968363184 7581408 7263680
16:05:45 57648 8192000000 10903887552 11395764224 1981122304 19.474 100 11 22 0 1992679984 8607392 2950288
16:07:53 62265 8192000000 10881972368 11362734080 1926667680 19.040 97 15 30 0 1940385040 9450416 4266944
16:09:05 87315 8192000000 10880073408 11353530368 1926270688 19.037 98 9 18 0 1943009744 14324672 2414384
16:10:43 46448 8192000000 10892829936 11358986240 1955032960 19.267 99 31 58 1 1975835200 11631328 9170912
16:11:36 55225 8192000000 10876137072 11358826496 1925949472 19.034 98 22 45 1 1947793312 15738816 6105024
16:12:37 113496 8192000000 10889363968 11379499008 1941605280 19.160 99 6 12 1 1956855552 13806432 1443840
16:14:50 51317 8192000000 10888157168 11366395904 1918803776 18.977 97 18 36 0 1931005520 7111360 5090384
16:15:47 88699 8192000000 10892629072 11389546496 1974130224 19.418 100 19 38 2 1991245392 11642032 5473136
16:17:25 77433 8192000000 10893070512 11356590080 1852754992 18.444 94 15 30 0 1865157216 8932464 3469760
16:18:49 31669 8192000000 10901940704 11355742208 1921253136 18.997 98 35 70 0 1941459456 10608896 9597424
16:19:31 44359 8192000000 10877193120 11352465408 1919974848 18.987 98 35 70 1 1945314832 15316976 10023008
16:20:25 61104 8192000000 10897548912 11367612416 1924134960 19.020 98 18 36 1 1939190032 10489504 4565568
16:21:32 190591 8192000000 10843697792 11311718400 1742299664 17.538 89 8 16 0 1758107072 13639824 2167584
16:24:49 22986 8192000000 10890301744 11338125312 1919516800 18.983 99 33 66 2 1939823712 10728384 9578528
16:25:22 11462 8192000000 10889984960 11331522560 1929815600 19.065 99 59 119 2 1959139968 12974784 16349584
16:25:42 43375 8192000000 10840810528 11312254976 1863159568 18.529 96 34 69 6 1889362704 16777728 9425408
16:26:35 45598 8192000000 9552720304 9873272832 696395328 7.834 36 2 4 0 702278448 5035072 848048

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-11-2020 16:29:20 to 09-11-2020 16:29:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 85 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-11-2020 16:29:53 to 09-11-2020 16:29:55.

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          245379
MON$OLDEST_ACTIVE               245380
MON$OLDEST_SNAPSHOT             245380
MON$NEXT_TRANSACTION            245380
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                       2039136
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:142: 
:143: mscs-test-161.budzdorov.ru    Mon Nov  9 16:27:32 2020
:144:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:145: 
:146: 
:147: mscs-test-161.budzdorov.ru    Mon Nov  9 16:27:32 2020
:148:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:149: 
--- end of diff output ---

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

09.11.20 16:29:56. 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-11-09 16:29:58 No severe PSQL-related problems occured
09.11.20 16:29:59. End of report.