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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17242628 kB
MemAvailable 31281860 kB
Buffers 0 kB
Cached 14479564 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-30 19:27:14
DTS_END                         2021-01-30 19:27:14.4900
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42432
TRN_ID                          232084
ATT_ID                          625
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: 9018.92 22811 1082271
customer order: creation 164.35 361 19722
customer order: refuse 14.08 389 1690
order to supplier: creation 43.15 1345 5178
order to supplier: removal 3.42 95660 410
invoice (draft): creation 44.34 3788 5321
invoice (draft): removal 51.75 736 6210
invoice accept: apply 39.58 19321 4749
invoice accept: cancel 47.03 796 5643
customer reserve: creation 3718.20 189 446184
customer reserve: removal 4609.97 55 553196
realization accept: apply 80.05 187 9606
realization accept: cancel 80.56 111 9667
payment from customer: creation 56.46 130 6775
payment from customer: removal 5.33 80 639
payment to supplier: creation 46.26 124 5551
payment to supplier: removal 2.98 63 358
service: total inventory turnovers 4.19 1229 503
service: total monetary turnovers 6.44 51 773
service: aggregate perf. data 0.77 21998 92
service: refresh index statistics 0.03 309612 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-01-2021 19:28:45 to 30-01-2021 19:28:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6481
TEST_TIME 2 4397
TEST_TIME 3 4072
TEST_TIME 4 5119
TEST_TIME 5 5229
TEST_TIME 6 5379
TEST_TIME 7 5674
TEST_TIME 8 6019
TEST_TIME 9 5945
TEST_TIME 10 5761
TEST_TIME 11 5964
TEST_TIME 12 6196
TEST_TIME 13 6265
TEST_TIME 14 6498
TEST_TIME 15 6668
TEST_TIME 16 6987
TEST_TIME 17 7116
TEST_TIME 18 7513
TEST_TIME 19 7681
TEST_TIME 20 8336
TEST_TIME 21 8754
TEST_TIME 22 8893
TEST_TIME 23 9270
TEST_TIME 24 9320
TEST_TIME 25 9675
TEST_TIME 26 10365
TEST_TIME 27 10156
TEST_TIME 28 9891
TEST_TIME 29 9966
TEST_TIME 30 10064
TEST_TIME 31 10094
TEST_TIME 32 10014
TEST_TIME 33 10103
TEST_TIME 34 10140
TEST_TIME 35 10058
TEST_TIME 36 9896
TEST_TIME 37 9785
TEST_TIME 38 9659
TEST_TIME 39 9594
TEST_TIME 40 9570
TEST_TIME 41 9688
TEST_TIME 42 9723
TEST_TIME 43 9624
TEST_TIME 44 9558
TEST_TIME 45 9532
TEST_TIME 46 9462
TEST_TIME 47 9424
TEST_TIME 48 9452
TEST_TIME 49 9662
TEST_TIME 50 9617
TEST_TIME 51 9505
TEST_TIME 52 9583
TEST_TIME 53 9512
TEST_TIME 54 9474
TEST_TIME 55 9493
TEST_TIME 56 9665
TEST_TIME 57 9742
TEST_TIME 58 9702
TEST_TIME 59 9800
TEST_TIME 60 9754
TEST_TIME 61 9843
TEST_TIME 62 9692
TEST_TIME 63 9606
TEST_TIME 64 9596
TEST_TIME 65 9521
TEST_TIME 66 9540
TEST_TIME 67 9435
TEST_TIME 68 9392
TEST_TIME 69 9422
TEST_TIME 70 9408
TEST_TIME 71 9377
TEST_TIME 72 9353
TEST_TIME 73 9318
TEST_TIME 74 9330
TEST_TIME 75 9269
TEST_TIME 76 9227
TEST_TIME 77 9255
TEST_TIME 78 9303
TEST_TIME 79 9291
TEST_TIME 80 9325
TEST_TIME 81 9303
TEST_TIME 82 9380
TEST_TIME 83 9388
TEST_TIME 84 9378
TEST_TIME 85 9347
TEST_TIME 86 9399
TEST_TIME 87 9458
TEST_TIME 88 9421
TEST_TIME 89 9327
TEST_TIME 90 9289
TEST_TIME 91 9308
TEST_TIME 92 9255
TEST_TIME 93 9183
TEST_TIME 94 9156
TEST_TIME 95 9122
TEST_TIME 96 9162
TEST_TIME 97 9213
TEST_TIME 98 9190
TEST_TIME 99 9215
TEST_TIME 100 9275
TEST_TIME 101 9260
TEST_TIME 102 9260
TEST_TIME 103 9313
TEST_TIME 104 9283
TEST_TIME 105 9346
TEST_TIME 106 9298
TEST_TIME 107 9306
TEST_TIME 108 9408
TEST_TIME 109 9337
TEST_TIME 110 9268
TEST_TIME 111 9267
TEST_TIME 112 9246
TEST_TIME 113 9193
TEST_TIME 114 9164
TEST_TIME 115 9155
TEST_TIME 116 9151
TEST_TIME 117 9102
TEST_TIME 118 9067
TEST_TIME 119 9085
TEST_TIME 120 9022

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 30-01-2021 19:28:49 to 30-01-2021 19:28:52.

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 1495714 1495714 0 0.00 0 21191 6 0 0
doc_list_biud 1495714 1495714 0 0.00 0 24630 26 0 0
sp_add_invoice_to_stock 4826 4749 77 1.59 41 218211 19321 0 77
sp_cancel_adding_invoice 5643 5643 0 0.00 4 63383 796 0 0
sp_cancel_client_order 1690 1690 0 0.00 4 21373 389 0 0
sp_cancel_customer_reserve 553196 553196 0 0.00 1 24631 55 0 0
sp_cancel_pay_from_customer 639 639 0 0.00 3 6135 81 0 0
sp_cancel_pay_to_supplier 358 358 0 0.00 3 1732 63 0 0
sp_cancel_supplier_invoice 6215 6210 5 0.08 1 15529 736 0 5
sp_cancel_supplier_order 410 410 0 0.00 9 942892 95661 0 0
sp_cancel_write_off 9667 9667 0 0.00 1 14285 112 0 0
sp_client_order 19722 19722 0 0.00 4 32265 362 0 0
sp_customer_reserve 446184 446184 0 0.00 0 54390 190 0 0
sp_fill_shopping_cart 30208 30208 0 0.00 1 24290 41 0 0
sp_fill_shopping_cart_clo_res 446181 446181 0 0.00 0 14750 14 0 0
sp_get_clo_for_invoice 4740 4740 0 0.00 0 16768 299 0 0
sp_kill_cost_storno 16307 16307 0 0.00 0 15597 57 0 0
sp_kill_qstorno_ret_qs2qd 1122679 1122679 0 0.00 0 24625 30 0 0
sp_kill_qty_storno 591160 591160 0 0.00 0 24629 66 0 0
sp_lock_selected_doc 19828 19828 0 0.00 0 8596 5 0 0
sp_make_cost_storno 26670 26670 0 0.00 0 18290 57 0 0
sp_multiply_rows_for_pdistr 26670 26670 0 0.00 0 13417 31 0 0
sp_multiply_rows_for_qdistr 19722 19722 0 0.00 0 15881 148 0 0
sp_pay_from_customer 6775 6775 0 0.00 4 31936 130 0 0
sp_pay_to_supplier 5551 5551 0 0.00 5 13543 124 0 0
sp_payment_common 12326 12326 0 0.00 1 31920 41 0 0
sp_qd_handle_on_cancel_clo 1690 1690 0 0.00 0 21367 357 0 0
sp_qd_handle_on_invoice_upd_sts 10381 10381 0 0.00 0 18460 366 0 0
sp_qd_handle_on_reserve_upd_sts 9606 9606 0 0.00 0 20394 60 0 0
sp_reserve_write_off 9606 9606 0 0.00 6 20411 187 0 0
sp_supplier_invoice 5321 5321 0 0.00 6 84953 3788 0 0
sp_supplier_order 5178 5178 0 0.00 5 45380 1345 0 0
srv_aggregate_perf_data 92 92 0 0.00 3126 227237 21999 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 972 137113 32856 0 0
srv_find_qd_qs_mism 1036783 1036783 0 0.00 0 21183 5 0 0
srv_make_invnt_saldo 503 503 0 0.00 66 67127 1229 0 0
srv_make_money_saldo 773 773 0 0.00 0 13014 51 0 0
srv_recalc_idx_stat 4 4 0 0.00 256179 382006 309612 0 0
t$perf-abend:sp_add_invoice_to_stock 77 77 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4749 4749 0 0.00 0 17152 180 0 0
t$perf-norm:sp_cancel_adding_invoice 395 395 0 0.00 1 6026 134 0 0
t$perf-norm:sp_cancel_client_order 1690 1690 0 0.00 0 5233 20 0 0
t$perf-norm:sp_cancel_customer_reserve 628 628 0 0.00 0 5420 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 639 639 0 0.00 0 722 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 358 358 0 0.00 0 582 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 412 412 0 0.00 0 646 11 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 19979 1653 0 0
t$perf-norm:sp_cancel_write_off 952 952 0 0.00 0 4984 12 0 0
t$perf-norm:sp_client_order 19722 19722 0 0.00 0 12802 19 0 0
t$perf-norm:sp_customer_reserve 934 934 0 0.00 0 5108 12 0 0
t$perf-norm:sp_pay_from_customer 6775 6775 0 0.00 0 7747 12 0 0
t$perf-norm:sp_pay_to_supplier 5551 5551 0 0.00 0 2524 7 0 0
t$perf-norm:sp_reserve_write_off 9606 9606 0 0.00 0 8435 10 0 0
t$perf-norm:sp_supplier_invoice 5321 5321 0 0.00 0 9963 21 0 0
t$perf-norm:sp_supplier_order 5178 5178 0 0.00 0 7589 17 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 1315 33 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 95 3 0 0
t$perf-norm:srv_make_invnt_saldo 503 503 0 0.00 0 1363 26 0 0
t$perf-norm:srv_make_money_saldo 773 773 0 0.00 0 5986 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 355 92 0 0
v_add_invoice_to_stock 9630 9476 154 1.59 0 9940 20 0 154
v_all_customers 36136 36136 0 0.00 0 17 1 0 0
v_all_suppliers 29218 29218 0 0.00 0 16 1 0 0
v_all_wares 39440 39440 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 790 790 0 0.00 0 3007 14 0 0
v_cancel_client_order 3380 3380 0 0.00 0 3723 6 0 0
v_cancel_customer_prepayment 1278 1278 0 0.00 0 2744 6 0 0
v_cancel_customer_reserve 1256 1256 0 0.00 0 850 4 0 0
v_cancel_payment_to_supplier 716 716 0 0.00 0 1722 10 0 0
v_cancel_supplier_invoice 834 824 10 1.19 0 2962 24 0 10
v_cancel_supplier_order 820 820 0 0.00 0 2484 7 0 0
v_cancel_write_off 1904 1904 0 0.00 0 2746 18 0 0
v_max_id_clo_ord 5177 5177 0 0.00 0 1467 2 0 0
v_max_id_clo_res 934 934 0 0.00 0 4029 20 0 0
v_max_id_ord_sup 5310 5310 0 0.00 0 3396 4 0 0
v_max_non_paid_invoice 1429 1429 0 0.00 0 607 4 0 0
v_max_non_paid_realizn 3453 3453 0 0.00 0 1337 5 0 0
v_min_id_clo_ord 5177 5177 0 0.00 0 9696 11 0 0
v_min_id_clo_res 934 934 0 0.00 0 3035 14 0 0
v_min_id_ord_sup 5310 5310 0 0.00 0 6908 7 0 0
v_min_non_paid_invoice 5551 5551 0 0.00 0 13347 22 0 0
v_min_non_paid_realizn 6775 6775 0 0.00 0 15983 31 0 0
v_our_firm 9948 9948 0 0.00 0 17 1 0 0
v_reserve_write_off 19212 19212 0 0.00 0 3631 6 0 0
x_lock_depdocs_on_canc_invoice 11441 11441 0 0.00 0 17064 111 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 8858 341 0 0
x_make_qstorno_1000_1200 5178 5178 0 0.00 2 45359 1257 0 0
x_make_qstorno_1200_2000 5321 5321 0 0.00 4 84943 3647 0 0
x_make_qstorno_2100_3300 446184 446184 0 0.00 0 54388 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-01-2021 19:28:53 to 30-01-2021 19:28:57.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:18 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:24 18875 8192000000 10219191936 10525949952 817489680 9.073 67 50 102 0 836501824 2362640 16649504
16:57:51 11310 8192000000 10296827920 10608754688 1349633792 14.144 100 85 170 0 1381652464 4204432 27814240
16:58:12 29990 8192000000 10351402176 10667560960 1397561184 14.573 100 83 166 0 1430055648 5737136 26757328
16:58:55 26559 8192000000 10391479328 10713350144 1441980864 14.967 100 87 174 0 1477063024 6727168 28354992
16:59:32 28961 8192000000 10408356144 10732539904 1461335696 15.138 100 91 182 0 1498781776 7811824 29634256
17:00:11 15307 8192000000 10414233312 10741379072 1472597904 15.237 100 90 180 1 1510185680 8509440 29078336
17:00:40 23401 8192000000 10440417872 10768990208 1488887600 15.379 100 90 180 1 1527344336 9187408 29269328
17:01:20 15977 8192000000 10449053360 10789879808 1509918048 15.563 100 80 160 1 1544927232 9536272 25472912
17:01:44 14701 8192000000 10475922752 10819248128 1537060832 15.798 100 84 168 0 1573742080 9870496 26810752
17:02:13 12000 8192000000 10507076368 10853761024 1568324000 16.068 100 74 148 1 1600233104 9597344 22311760
17:02:34 13465 8192000000 10526512064 10881314816 1592532720 16.276 100 70 139 1 1623496848 10082576 20881552
17:02:57 16448 8192000000 10566924816 10922110976 1623695952 16.541 100 79 159 1 1658157152 11346064 23115136
17:03:22 11796 8192000000 10600765072 10957811712 1650549264 16.769 100 87 174 1 1689306720 13102656 25654800
17:03:42 13863 8192000000 10617154496 10981281792 1666928352 16.907 100 82 164 0 1704266320 13418016 23919952
17:04:04 10927 8192000000 10631032240 10999824384 1684571760 17.056 100 80 160 2 1720716192 13245808 22898624
17:04:22 7986 8192000000 10653858832 11019923456 1706928736 17.243 100 82 164 2 1743232624 13030352 23273536
17:04:37 7932 8192000000 10656965120 11032940544 1719065024 17.344 100 83 164 1 1760297456 17796768 23435664
17:04:53 5368 8192000000 10662576400 11042312192 1731481200 17.448 100 72 143 1 1764056064 11981392 20593472
17:05:07 6045 8192000000 10679687344 11058880512 1744676448 17.557 100 77 154 1 1778248736 11926608 21645680
17:05:22 6136 8192000000 10698486464 11069341696 1755661664 17.648 100 75 149 1 1788795360 12806144 20327552
17:05:36 4133 8192000000 10711420080 11084472320 1768996720 17.759 100 81 160 1 1805399440 13501440 22901280
17:05:47 5200 8192000000 10721803584 11101691904 1784440704 17.886 100 85 168 3 1821840640 14168048 23231888
17:05:59 4549 8192000000 10733977552 11111510016 1788759424 17.922 100 86 170 0 1825710176 13536368 23414384
17:06:10 3081 8192000000 10736261456 11112493056 1793721792 17.962 100 89 178 2 1833060928 14629408 24709728
17:06:20 9091 8192000000 10737126960 11124760576 1805273952 18.057 100 91 181 2 1844490272 13926272 25290048
17:06:36 2099 8192000000 10751458960 11131363328 1812995200 18.120 100 92 184 0 1853742144 15456160 25290784
17:06:44 1956 8192000000 10760385072 11144638464 1815119424 18.138 100 89 178 2 1855337696 14948672 25269600
17:06:53 2294 8192000000 10764628144 11150671872 1823187040 18.204 100 87 172 0 1861904368 14409280 24308048
17:07:02 1472 8192000000 10774394896 11158876160 1830677520 18.265 100 85 169 3 1868471344 14208432 23585392
17:07:10 2157 8192000000 10777262576 11161653248 1834090096 18.293 100 85 167 1 1871098256 12732304 24275856
17:07:19 1612 8192000000 10785124432 11167256576 1837253744 18.318 100 94 188 3 1877567776 13161664 27152368
17:07:27 2155 8192000000 10778420912 11165859840 1840972736 18.349 100 88 176 1 1879632880 13488992 25171152
17:07:35 1359 8192000000 10787179600 11170836480 1843023216 18.365 100 97 192 2 1884077552 14242304 26812032
17:07:43 1913 8192000000 10789445568 11178315776 1850552208 18.427 100 88 177 1 1889039856 13768880 24718768
17:07:51 1051 8192000000 10802571712 11186274304 1853920320 18.454 100 99 197 0 1895339568 13643824 27775424
17:07:59 1719 8192000000 10800491248 11186556928 1855377408 18.466 100 91 183 0 1895140464 13758400 26004656
17:08:07 15105 8192000000 10789756256 11188563968 1856113360 18.472 100 66 130 0 1885951296 11342000 18495936
17:08:29 2369 8192000000 10794445280 11197767680 1861286768 18.514 100 67 134 0 1893145088 12854064 19004256
17:08:38 1747 8192000000 10799520496 11204648960 1868781072 18.574 100 61 122 1 1902461664 15213648 18466944
17:08:47 8266 8192000000 10776738528 11196268544 1864533936 18.540 100 32 64 1 1882597808 8632208 9431664
17:09:04 6533 8192000000 10783228400 11195764736 1865347696 18.547 100 29 59 1 1880471088 6285600 8837792
17:09:17 8863 8192000000 10776598336 11198795776 1866217936 18.554 100 34 68 1 1883247824 7407952 9621936
17:09:32 6380 8192000000 10784490736 11203649536 1869187888 18.578 100 34 68 1 1886808336 7766720 9853728
17:09:44 8069 8192000000 10785883920 11207307264 1873525936 18.613 100 29 58 1 1889074560 7931520 7617104
17:10:01 15132 8192000000 10788319728 11212574720 1876557712 18.637 100 35 70 1 1893683120 7087680 10037728
17:10:23 71980 8192000000 10788826816 11222261760 1876184432 18.634 100 26 53 0 1888278000 5235040 6858528
17:11:43 10457 8192000000 10780252944 11216322560 1875113104 18.626 100 11 22 0 1883331376 5289968 2928304
17:12:02 8850 8192000000 10793750256 11222454272 1883164944 18.691 100 27 53 4 1896829296 6689312 6975040
17:12:19 4924 8192000000 10793189824 11225202688 1881961040 18.681 100 23 46 1 1894856496 5901536 6993920
17:12:30 6679 8192000000 10802950160 11224879104 1883584016 18.694 100 30 60 1 1899805536 6481136 9740384
17:12:43 8530 8192000000 10812594672 11230052352 1885342400 18.708 100 29 58 2 1899656944 6086096 8228448
17:12:59 9580 8192000000 10799496640 11232403456 1889564128 18.742 100 29 58 0 1905094176 7239440 8290608
17:13:15 5517 8192000000 10804113088 11232923648 1887350704 18.724 100 23 46 1 1900190368 6273744 6565920
17:13:27 4791 8192000000 10805525152 11236085760 1887012832 18.722 100 22 44 0 1898857872 5739152 6105888
17:13:38 10759 8192000000 10801231920 11234689024 1890990880 18.754 100 19 38 2 1901710672 5165856 5553936
17:13:56 7940 8192000000 10799497360 11236868096 1892132112 18.763 100 19 36 1 1903443136 6098896 5212128
17:14:12 5700 8192000000 10803285200 11236216832 1892007520 18.762 100 18 36 1 1903573824 6215152 5351152
17:14:24 12573 8192000000 10811510288 11239682048 1892380368 18.765 100 11 23 2 1901455584 5655056 3420160
17:14:43 63772 8192000000 10843620032 11253207040 1901446240 18.838 100 39 79 2 1918573632 5119632 12007760
17:15:53 3334 8192000000 10820756496 11248328704 1901913264 18.842 100 26 52 0 1916022400 6940512 7168624
17:16:04 5946 8192000000 10813839312 11245400064 1898844336 18.817 100 26 52 3 1912123808 5861280 7418192
17:16:17 7417 8192000000 10822885248 11253415936 1901377328 18.837 100 29 57 1 1919721040 10553568 7790144
17:16:31 5835 8192000000 10822316480 11253235712 1907458576 18.886 100 32 64 0 1924635296 7512960 9663760
17:16:44 3550 8192000000 10823477536 11254484992 1905808576 18.873 100 29 58 2 1919954112 5693968 8451568
17:16:58 4419 8192000000 10818550944 11244789760 1887864336 18.729 99 43 86 0 1907275360 7049392 12361632
17:17:09 3151 8192000000 10813526848 11233759232 1862813072 18.526 98 32 64 1 1877332496 6015312 8504112
17:17:22 4577 8192000000 10801333712 11238326272 1894064848 18.779 100 31 62 1 1910638064 6817216 9756000
17:17:34 7874 8192000000 10783595680 11210645504 1833123360 18.285 97 32 64 1 1848422432 6212272 9086800
17:17:52 4793 8192000000 10786263840 11207319552 1840077568 18.341 98 23 46 0 1856813488 10465152 6270768
17:18:05 8364 8192000000 10751138688 11176009728 1800540144 18.018 97 23 46 1 1813532384 6685680 6306560
17:18:21 15907 8192000000 10705601376 11124379648 1693943008 17.134 91 11 22 0 1702320800 5140544 3237248
17:18:45 7087 8192000000 10710739200 11129831424 1752648880 17.624 96 20 40 1 1764237296 6392864 5195552
17:19:01 72094 8192000000 10712466240 11126820864 1617105328 16.485 88 28 55 2 1629907968 5020960 7781680
17:20:20 4295 8192000000 10736098080 11153858560 1802151632 18.032 99 41 82 1 1821185952 7418080 11616240
17:20:30 4729 8192000000 10749354976 11166097408 1815657232 18.142 99 35 70 2 1832508080 7172128 9678720
17:20:43 8186 8192000000 10732552624 11136880640 1774623712 17.805 98 41 83 4 1793683312 7070112 11989488
17:20:58 5717 8192000000 10725761664 11140378624 1790153104 17.933 99 34 68 1 1806608288 5888976 10566208
17:21:10 6610 8192000000 10719169024 11123560448 1752267344 17.620 97 25 50 1 1765445504 5549760 7628400
17:21:26 8102 8192000000 10716168144 11130785792 1782337728 17.869 98 31 61 2 1797225920 6014496 8873696
17:21:44 6927 8192000000 10719155296 11135586304 1765954464 17.734 97 26 52 0 1778961312 5065648 7941200
17:21:59 11444 8192000000 10725070704 11125891072 1753440368 17.630 97 33 66 0 1769316032 5885920 9989744
17:22:21 6637 8192000000 10719894912 11133706240 1778976992 17.841 98 24 48 2 1791622640 5064672 7580976
17:22:34 16691 8192000000 10719615888 11144105984 1762083968 17.702 97 19 38 2 1772472896 5151440 5237488
17:23:00 9418 8192000000 10737364704 11150114816 1810538800 18.100 100 19 38 0 1821446272 5816304 5091168
17:23:20 61352 8192000000 10731751536 11165155328 1826975280 18.235 100 25 50 0 1838780528 5259920 6545328
17:24:28 12325 8192000000 10759378960 11178278912 1825000176 18.219 99 23 47 0 1836260464 5314416 5945872
17:24:47 7911 8192000000 10767970336 11184234496 1848656704 18.411 100 29 58 1 1863365328 6525296 8183328
17:25:02 7058 8192000000 10786576048 11193167872 1854886336 18.462 100 40 80 1 1872177632 5921632 11369664
17:25:15 6688 8192000000 10763238960 11192356864 1855816464 18.469 100 35 69 1 1873269744 6907664 10545616
17:25:28 5436 8192000000 10779179312 11193339904 1858304960 18.490 100 35 65 3 1874207280 4972944 10929376
17:25:39 6546 8192000000 10778505728 11198193664 1855353200 18.466 100 21 42 0 1867017584 5554864 6109520
17:25:54 5868 8192000000 10762923008 11196014592 1855628224 18.468 100 22 44 0 1868129040 6102096 6398720
17:26:07 7605 8192000000 10772155360 11199037440 1859035488 18.495 100 21 42 1 1870916176 5359696 6520992
17:26:24 7972 8192000000 10776849264 11202215936 1862851264 18.526 100 25 51 0 1876534032 5739680 7943088
17:26:39 11150 8192000000 10780573008 11205787648 1862475360 18.523 100 21 42 0 1874940976 5391456 7074160
17:26:56 8645 8192000000 10782257072 11208593408 1869134832 18.577 100 25 50 1 1881945520 5964400 6846288
17:27:11 10130 8192000000 10803124640 11223523328 1886154240 18.715 100 27 54 1 1899323248 5542240 7626768
17:27:43 10722 8192000000 10831042512 11243446272 1899444368 18.822 100 40 81 3 1917067552 6638528 10984656
17:28:02 46286 8192000000 10842547248 11263717376 1910076560 18.907 100 47 92 5 1932166688 7500992 14589136
17:28:57 10558 8192000000 10845872432 11269066752 1921408752 18.998 100 44 88 2 1944297696 8742336 14146608
17:29:32 93826 8192000000 10846758208 11283099648 1926749504 19.041 100 25 50 0 1942579296 8595712 7234080
17:31:15 31396 8192000000 10856109184 11294547968 1932734576 19.089 100 30 59 1 1954135616 12068528 9332512
17:31:53 5456 8192000000 10889151840 11304128512 1945736768 19.193 100 57 112 1 1972698688 10548288 16413632
17:32:07 21650 8192000000 10890458240 11315113984 1948445072 19.214 100 56 109 0 1975985520 12047184 15493264
17:32:37 8615 8192000000 10899947360 11319431168 1956945472 19.282 100 67 131 5 1988572976 13256384 18371120
17:32:54 2602 8192000000 10898481728 11323883520 1961967168 19.322 100 55 110 2 1994126496 16417040 15742288
17:33:03 4483 8192000000 10919453040 11335684096 1967075648 19.362 100 65 130 0 2004826768 19086176 18664944
17:33:17 17151 8192000000 10919870624 11341471744 1969528768 19.382 100 66 132 2 2009897952 21286400 19082784
17:33:46 4057 8192000000 10906250848 11333099520 1962686800 19.327 100 63 127 2 2004202192 22762992 18752400
17:33:58 13685 8192000000 10908594240 11338256384 1962387616 19.325 100 56 111 4 2002088944 22863680 16837648
17:34:20 7509 8192000000 10908538720 11338072064 1963800944 19.336 100 54 108 0 2000879200 20670480 16407776
17:34:40 10655 8192000000 10910478448 11337453568 1947354528 19.205 99 53 106 1 1982066160 19431744 15279888
17:35:08 4888 8192000000 10900675024 11332001792 1946966608 19.202 99 45 90 0 1980708752 20012240 13729904
17:35:21 8244 8192000000 10902820800 11331870720 1959488176 19.302 100 48 96 1 1993390704 20069264 13833264
17:35:37 6563 8192000000 10917549040 11346001920 1969996512 19.385 100 58 116 0 2008228912 20951328 17281072
17:35:56 28721 8192000000 10916299424 11351060480 1974817664 19.424 100 46 92 1 2010906112 22214176 13874272
17:36:36 16648 8192000000 10923612512 11363377152 1982984160 19.488 100 48 94 1 2020968912 23580400 14404352
17:37:01 6491 8192000000 10929061184 11365613568 1984368624 19.499 100 41 79 4 2019185088 23036176 11780288
17:37:15 8760 8192000000 10931370192 11368878080 1986708048 19.518 100 43 85 2 2023433088 24294080 12430960
17:37:31 15674 8192000000 10938198848 11375656960 1992970944 19.567 100 41 81 0 2030410096 24867312 12571840
17:37:53 5062 8192000000 10949087776 11383431168 1997774064 19.605 100 55 107 2 2040263408 26012288 16477056
17:38:07 6802 8192000000 10945323168 11375513600 1993378224 19.570 100 59 117 0 2039197728 27419984 18399520
17:38:23 4808 8192000000 10958701536 11384410112 1998091072 19.608 100 64 128 1 2045482192 27963216 19427904
17:38:38 2692 8192000000 10975165392 11391287296 2005767328 19.668 100 77 155 2 2056800656 28278832 22754496
17:38:49 2910 8192000000 10952517536 11373940736 1987849424 19.527 99 77 151 1 2038128688 27608736 22670528
17:39:01 6626 8192000000 10961789696 11382353920 1981575184 19.477 99 74 148 1 2032635232 29286880 21773168
17:39:16 5805 8192000000 10958288160 11380555776 1996332416 19.594 100 73 145 3 2048706672 30262800 22111456
17:39:29 2586 8192000000 10973383616 11386175488 2001233120 19.632 100 74 148 0 2051375264 27910656 22231488
17:39:39 5498 8192000000 10943339712 11371311104 1974512432 19.421 99 63 126 1 2020237648 27418544 18306672
17:39:51 2585 8192000000 10949345808 11372277760 1985953456 19.512 100 71 142 0 2036982032 30195344 20833232
17:40:00 9566 8192000000 10935885600 11363856384 1977778240 19.447 100 65 128 3 2025343344 27579120 19985984
17:40:29 5579 8192000000 10949325104 11373764608 1988620304 19.533 100 66 132 2 2037036288 29011584 19404400
17:40:43 9665 8192000000 10940440704 11371028480 1982926960 19.488 100 70 140 0 2036321248 31907792 21486496
17:41:03 2905 8192000000 10950927392 11368423424 1983461904 19.492 100 60 118 2 2031454192 30332192 17660096
17:41:15 6275 8192000000 10934291488 11350753280 1945998928 19.195 98 79 155 0 1998970400 30279104 22692368
17:41:38 2248 8192000000 10949602368 11366420480 1980306672 19.467 100 72 144 4 2036209984 34212560 21690752
17:41:50 1942 8192000000 10925173680 11332354048 1933848048 19.098 98 78 156 1 1992124928 34316160 23960720
17:42:02 5039 8192000000 10956257248 11366338560 1980762928 19.471 100 77 152 1 2037793520 33789088 23241504
17:42:13 3916 8192000000 10956872608 11374833664 1986254928 19.514 100 75 149 1 2041997936 33733904 22009104
17:42:23 2719 8192000000 10954331696 11360083968 1971108352 19.394 100 89 176 1 2030112048 33090720 25912976
17:42:33 3198 8192000000 10959820960 11369644032 1978238640 19.451 100 84 169 2 2039312144 35517424 25556080
17:42:44 2668 8192000000 10948126640 11353665536 1963188768 19.331 99 83 167 1 2025090448 36689232 25212448
17:42:53 971 8192000000 10961288944 11365044224 1975344224 19.428 100 96 195 2 2041102752 37236720 28521808
17:43:01 3358 8192000000 10926696448 11343806464 1954014192 19.258 100 79 160 1 2015680880 37639520 24027168
17:43:12 3232 8192000000 10929083456 11340705792 1950146816 19.228 100 79 155 1 2011752288 37428912 24176560
17:43:23 4026 8192000000 10918546544 11336884224 1952310256 19.245 100 71 143 0 2012567584 37813328 22444000
17:43:37 2789 8192000000 10938672720 11348402176 1958445264 19.294 100 78 156 1 2019241136 36561728 24234144
17:43:46 4012 8192000000 10911408224 11320246272 1919899824 18.986 99 89 178 0 1985840960 38590560 27350576
17:43:57 2289 8192000000 10924540848 11334971392 1942018000 19.163 100 85 168 3 2007794848 39208160 26568688
17:44:09 2292 8192000000 10917964192 11329511424 1938564896 19.135 100 77 152 0 2000442992 38500688 23377408
17:44:23 4768 8192000000 10924040560 11337760768 1946725968 19.200 100 79 157 0 2011661888 39714880 25221040
17:44:39 4892 8192000000 10931702480 11347808256 1951873568 19.241 100 70 138 0 2015661968 42249024 21539376
17:44:52 3045 8192000000 10943396848 11351683072 1955489104 19.270 100 87 173 1 2024486064 41384672 27612288
17:45:02 6212 8192000000 10931516496 11344683008 1945827888 19.193 100 82 164 1 2014578352 42917600 25832864
17:45:17 7031 8192000000 10936980608 11354021888 1954189552 19.260 100 79 158 3 2022210640 43663600 24357488
17:45:32 1997 8192000000 10959501392 11371249664 1967881248 19.369 100 85 170 2 2039970560 46208496 25880816
17:45:42 2233 8192000000 10945886384 11357704192 1956042608 19.275 100 84 166 0 2028964496 47115216 25806672
17:45:51 3305 8192000000 10953589872 11368210432 1962790496 19.328 100 88 175 1 2039471376 48820048 27860832
17:46:02 4430 8192000000 10953941680 11366633472 1967280192 19.364 100 74 148 1 2036144064 45983776 22880096
17:46:13 3795 8192000000 10951562960 11369730048 1950058032 19.227 99 74 145 1 2022291824 49081760 23152032
17:46:34 2250 8192000000 10969641152 11381809152 1972539808 19.406 100 86 172 0 2051303264 51230944 27532512
17:46:42 2166 8192000000 10967034624 11373199360 1959795584 19.304 99 89 175 1 2040231824 52833216 27603024
17:46:51 1895 8192000000 10938916576 11340558336 1936693168 19.120 98 92 184 2 2020347504 55010560 28643776
17:46:59 2287 8192000000 10959361344 11368386560 1957722288 19.288 100 84 167 0 2035282096 51135696 26424112
17:47:17 19581 8192000000 10908122400 11353964544 1929511840 19.063 99 49 98 0 1996952288 50908720 16531728
17:47:47 8703 8192000000 10910081728 11343556608 1932361616 19.086 99 45 90 0 1988009856 40818096 14830144
17:48:05 13122 8192000000 10906761872 11349508096 1928508960 19.055 99 42 83 1 1983811984 41651680 13651344
17:48:25 17366 8192000000 10902369712 11341418496 1945361616 19.190 100 36 72 0 1989339072 31359552 12617904
17:48:51 40735 8192000000 10910852240 11338792960 1935135744 19.108 99 44 88 2 1983545232 32592016 15817472
17:49:39 2333 8192000000 10932955584 11355942912 1932091504 19.084 99 65 128 1 1989781664 36182992 21507168
17:49:48 20826 8192000000 10904091120 11359580160 1947083680 19.203 100 37 74 2 1996738000 36894912 12759408
17:50:21 27357 8192000000 10897750944 11347660800 1930694880 19.072 99 17 34 4 1967122240 30517728 5909632
17:50:58 17684 8192000000 10896259088 11348459520 1940073984 19.147 100 21 42 4 1981054496 33668848 7311664
17:51:32 15400 8192000000 10893509664 11355545600 1924165552 19.020 99 21 42 1 1970389520 38421360 7802608
17:51:54 33718 8192000000 10877082912 11342041088 1914971120 18.947 99 16 32 0 1955502272 34961040 5570112
17:52:55 62978 8192000000 10827365216 11291000832 1788916576 17.923 93 6 12 0 1811903088 20990144 1996368
17:54:04 28571 8192000000 10846002256 11294601216 1876574352 18.637 98 16 33 0 1888585888 7202480 4809056
17:54:46 54676 8192000000 10845369424 11288309760 1866941392 18.560 97 43 85 3 1887943680 7742736 13259552
17:55:56 31852 8192000000 10854936592 11313909760 1921935408 19.002 100 39 78 1 1945415136 12176208 11303520
17:56:34 93361 8192000000 10875251040 11337535488 1916918448 18.962 99 15 30 1 1933341184 12446544 3976192
17:58:14 93227 8192000000 10903342768 11356434432 1963077616 19.330 100 15 30 1 1976350704 9381984 3891104
18:00:00 61792 8192000000 10919133904 11383164928 1934291120 19.101 98 13 26 0 1961303728 23475168 3537440
18:01:33 56309 8192000000 10872354048 11343015936 1908581712 18.895 98 7 14 0 1935745728 24874416 2289600
18:02:35 52516 8192000000 10874689984 11318710272 1904710304 18.864 98 38 74 1 1923558736 7006320 11842112
18:05:16 25045 8192000000 10907046272 11371798528 1969735376 19.383 100 13 26 0 1987621088 13937616 3948096
18:05:55 29114 8192000000 10926196448 11376525312 1982505792 19.485 100 38 76 1 2010503392 15674416 12323184
18:06:32 34382 8192000000 10901007616 11369558016 1959376064 19.301 99 23 46 2 1983758544 17333168 7049312
18:07:18 64954 8192000000 10903448640 11362336768 1947654192 19.208 99 36 72 1 1979586064 18778928 13152944
18:08:35 96947 8192000000 10903398368 11381231616 1972224544 19.403 100 14 27 4 1999505904 22758304 4523056
18:10:19 52081 8192000000 10910098656 11377741824 1978698496 19.454 100 14 28 0 1994316736 11698544 3919696
18:11:28 47560 8192000000 10891319376 11359977472 1945536480 19.191 98 14 28 0 1967632768 17862112 4234176
18:12:22 67358 8192000000 10900044896 11375595520 1953788048 19.257 99 14 28 0 1973940224 15855024 4297152
18:13:40 42153 8192000000 10907621520 11378286592 1980977472 19.472 100 28 55 2 2004322544 15668336 7676736
18:15:11 79474 8192000000 10927747216 11407663104 1982748624 19.486 100 9 18 0 2007449648 21832832 2868192
18:16:44 84791 8192000000 10901966272 11371675648 1933365520 19.094 98 4 8 0 1955456000 21130080 960400
18:18:20 16863 8192000000 10923148352 11380908032 1989170560 19.537 100 43 87 0 2009869024 8176496 12521968
18:18:47 39760 8192000000 10914991024 11392282624 1989411712 19.539 100 32 64 1 2009024208 10818880 8793616
18:19:36 74887 8192000000 10910736464 11376390144 1892405200 18.765 95 13 26 0 1912820688 16889616 3525872
18:21:23 45056 8192000000 10925842048 11389382656 1984867632 19.503 100 27 52 2 2006464880 13570384 8026864
18:22:14 37182 8192000000 10913106832 11370471424 1930391712 19.070 97 26 52 2 1951030496 13320272 7318512
18:23:14 53080 8192000000 10857295552 11332886528 1866327600 18.555 95 14 28 1 1884887136 14957904 3601632
18:24:14 93308 8192000000 10914765200 11381223424 1968221472 19.371 100 23 44 1 1987684336 13895264 5567600
18:26:00 75241 8192000000 10909114320 11375804416 1915887968 18.954 97 12 24 0 1933996384 15147984 2960432
18:27:28 44041 8192000000 10900999296 11370033152 1927974848 19.051 98 15 30 0 1954086752 22107520 4004384
18:28:19 65993 8192000000 10893642272 11376955392 1943289056 19.173 99 4 8 0 1964390768 20581296 520416
18:29:57 68683 8192000000 10893096384 11361468416 1933266896 19.093 98 33 66 0 1951285424 8856016 9162512
18:31:13 66208 8192000000 10866631712 11327537152 1893594528 18.775 96 28 56 3 1913729248 12269968 7864752
18:32:29 43794 8192000000 10906824304 11365392384 1949878144 19.226 99 40 79 2 1976025920 15600976 10546800
18:33:19 80105 8192000000 10888196624 11366260736 1934578352 19.103 98 20 40 0 1959885728 19869680 5437696
18:34:46 57492 8192000000 10915276720 11385806848 1976716080 19.439 100 14 28 1 2000091184 19231200 4143904
18:35:53 49806 8192000000 10897813632 11379445760 1948983360 19.218 98 21 42 2 1979145824 23686912 6475552
18:36:56 22735 8192000000 10895770560 11378384896 1976653616 19.438 100 14 28 0 1993359312 12529936 4175760
18:38:25 64989 8192000000 10882547840 11365974016 1948585440 19.215 99 11 22 1 1961837072 10315200 2936432
18:40:05 76037 8192000000 10843041888 11320594432 1863255120 18.530 96 6 12 0 1880414944 15876144 1283680
18:41:27 32575 8192000000 10858626688 11341664256 1913544912 18.935 99 7 13 1 1929737328 13594864 2597552
18:42:09 60784 8192000000 10865565072 11334467584 1887184208 18.723 97 13 26 0 1907463504 16887696 3391600
18:43:27 34643 8192000000 10867824704 11331297280 1889530016 18.742 97 18 36 0 1910127760 15537952 5059792
18:44:38 44204 8192000000 10849853248 11326754816 1896331936 18.797 98 15 30 1 1914029664 13331056 4366672
18:46:13 40522 8192000000 10879527728 11339563008 1924093104 19.020 99 30 58 1 1945565760 13282320 8190336
18:47:01 49914 8192000000 10874080320 11329122304 1886339456 18.716 97 25 50 0 1902849904 9674048 6836400
18:47:57 36201 8192000000 10885849520 11346145280 1934338976 19.102 99 29 58 1 1954135424 11831584 7964864
18:48:44 44189 8192000000 10876455392 11329875968 1918666592 18.976 98 37 74 0 1943717920 14981776 10069552
18:49:34 76558 8192000000 10864056272 11329945600 1852625056 18.443 95 28 57 1 1873856064 13478448 7752560
18:51:06 40757 8192000000 10867766176 11335884800 1945449664 19.190 100 54 106 2 1969569088 8816832 15302592
18:51:54 8438 8192000000 10882359872 11324936192 1922645760 19.008 99 50 96 4 1943038624 7148768 13244096
18:52:11 29022 8192000000 10886520576 11337244672 1940553184 19.151 100 52 104 1 1966313552 11593984 14166384
18:53:07 55185 8192000000 10896394336 11354988544 1934949280 19.106 99 20 40 0 1954854896 13991216 5914400
18:54:48 137112 8192000000 10869276512 11325386752 1895590416 18.791 97 15 30 1 1912406592 12497376 4318800
18:57:12 12686 8192000000 10874804288 11321417728 1929276576 19.061 99 40 80 0 1948176144 8150416 10749152
18:57:32 35492 8192000000 10865960672 11320328192 1897886320 18.809 97 33 66 0 1916588752 8641456 10060976
18:58:16 50105 8192000000 10846725920 11314294784 1903076112 18.851 98 26 52 1 1918625536 8638416 6911008
18:59:58 41872 8192000000 10867225344 11339431936 1951905712 19.242 100 9 18 0 1960371520 6170688 2295120
19:01:06 60941 8192000000 10872620768 11348860928 1925067344 19.027 98 11 22 0 1939567440 11369168 3130928
19:02:46 48531 8192000000 10888347824 11358064640 1941944864 19.162 99 24 48 2 1961793392 12915632 6932896
19:03:51 61554 8192000000 10866027472 11339247616 1902630736 18.847 97 12 24 0 1916835536 10650720 3554080
19:05:03 53616 8192000000 10914978336 11368067072 1972078784 19.402 100 23 46 0 1987391680 8902976 6409920
19:06:08 55513 8192000000 10903533424 11376906240 1977319856 19.443 100 25 50 0 1996962032 12413840 7228336
19:07:20 72307 8192000000 10911957344 11382611968 1985396704 19.507 100 18 36 0 2001479840 10973776 5109360
19:09:14 48736 8192000000 10918774768 11385819136 1973325152 19.412 99 39 78 2 2000900032 15676304 11898576
19:10:13 50523 8192000000 10917880400 11396616192 1985710944 19.510 100 28 56 0 2004062192 10587040 7764208
19:11:10 45470 8192000000 10904062032 11377270784 1945895344 19.194 98 16 32 2 1963056672 12968048 4193280
19:12:02 59631 8192000000 10883188608 11363147776 1933442016 19.094 98 9 18 0 1949049184 12948272 2658896
19:13:09 108044 8192000000 10929979520 11390156800 1942249792 19.165 98 29 58 0 1962250800 11848912 8152096
19:15:09 82327 8192000000 10900537424 11377594368 1921427792 18.998 97 9 18 0 1942394336 18310512 2656032
19:16:50 126581 8192000000 10893972608 11371147264 1932474448 19.087 98 21 42 2 1948804368 9922992 6406928
19:19:03 45900 8192000000 10874305040 11366342656 1947181984 19.204 99 14 28 0 1964932608 14198752 3551872
19:20:00 59245 8192000000 10863832896 11339669504 1882886864 18.688 96 5 10 1 1891832368 7467792 1477712
19:21:10 63862 8192000000 10856791328 11342258176 1917273680 18.965 98 7 13 0 1927700960 8371408 2055872
19:22:29 80055 8192000000 10865211552 11344429056 1919863600 18.986 98 22 44 1 1933336048 7418240 6054208
19:24:06 74770 8192000000 10870157568 11362697216 1936869536 19.122 99 8 17 0 1951180192 12047792 2262864
19:25:27 32950 8192000000 10885561408 11353829376 1913513920 18.935 98 10 20 1 1928460976 12373392 2573664
19:26:17 44172 8192000000 10865655200 11337043968 1910705856 18.912 98 15 31 0 1924739104 9555168 4478080

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 30-01-2021 19:28:59 to 30-01-2021 19:29:30.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 77 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-01-2021 19:29:31 to 30-01-2021 19:29:33.

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          230414
MON$OLDEST_ACTIVE               232752
MON$OLDEST_SNAPSHOT             232752
MON$NEXT_TRANSACTION            232752
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                       2022464
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.33407 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33407 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33407 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33407 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 ---
:15: 
:16: mscs-test-161.budzdorov.ru    Sat Jan 30 19:27:19 2021
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Sat Jan 30 19:27:20 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Sat Jan 30 19:27:20 2021
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
:27: 
:28: mscs-test-161.budzdorov.ru    Sat Jan 30 19:27:21 2021
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:30: 
:31: 
:32: mscs-test-161.budzdorov.ru    Sat Jan 30 19:27:21 2021
:33:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:34: 
:35: 
:36: mscs-test-161.budzdorov.ru    Sat Jan 30 19:27:21 2021
:37:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:38: 
:39: 
:40: mscs-test-161.budzdorov.ru    Sat Jan 30 19:27:21 2021
:41:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:42: 
:43: 
:44: mscs-test-161.budzdorov.ru    Sat Jan 30 19:27:21 2021
:45:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:46: 
:47: 
:48: mscs-test-161.budzdorov.ru    Sat Jan 30 19:27:22 2021
:49:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:50: 
--- end of diff output ---

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

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