Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.12.2020 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 17299836 kB
MemAvailable 31533020 kB
Buffers 0 kB
Cached 14420820 kB
SwapCached 3696 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-20 19:27:04
DTS_END                         2020-12-20 19:27:04.9240
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/58904
TRN_ID                          242702
ATT_ID                          616
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: 9985.21 20887 1198225
customer order: creation 170.41 382 20449
customer order: refuse 14.47 272 1736
order to supplier: creation 45.55 1231 5466
order to supplier: removal 3.83 75483 460
invoice (draft): creation 46.36 2854 5563
invoice (draft): removal 59.57 528 7148
invoice accept: apply 41.35 17913 4962
invoice accept: cancel 54.26 603 6511
customer reserve: creation 3901.98 175 468237
customer reserve: removal 5337.50 43 640500
realization accept: apply 82.47 151 9896
realization accept: cancel 100.78 93 12093
payment from customer: creation 56.66 101 6799
payment from customer: removal 5.58 92 670
payment to supplier: creation 49.17 103 5900
payment to supplier: removal 3.63 59 436
service: total inventory turnovers 4.60 1040 552
service: total monetary turnovers 6.28 21 753
service: aggregate perf. data 0.75 21924 90
service: refresh index statistics 0.03 294673 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-12-2020 19:29:22 to 20-12-2020 19:29:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6940
TEST_TIME 2 5265
TEST_TIME 3 6223
TEST_TIME 4 6441
TEST_TIME 5 6358
TEST_TIME 6 6775
TEST_TIME 7 6738
TEST_TIME 8 7740
TEST_TIME 9 7630
TEST_TIME 10 7605
TEST_TIME 11 7815
TEST_TIME 12 8053
TEST_TIME 13 8214
TEST_TIME 14 9754
TEST_TIME 15 9967
TEST_TIME 16 10006
TEST_TIME 17 9860
TEST_TIME 18 10577
TEST_TIME 19 10389
TEST_TIME 20 10716
TEST_TIME 21 11289
TEST_TIME 22 11630
TEST_TIME 23 11987
TEST_TIME 24 11962
TEST_TIME 25 11811
TEST_TIME 26 11720
TEST_TIME 27 11562
TEST_TIME 28 11764
TEST_TIME 29 11746
TEST_TIME 30 11395
TEST_TIME 31 11161
TEST_TIME 32 10981
TEST_TIME 33 10927
TEST_TIME 34 10883
TEST_TIME 35 10864
TEST_TIME 36 10911
TEST_TIME 37 10765
TEST_TIME 38 10701
TEST_TIME 39 10562
TEST_TIME 40 10639
TEST_TIME 41 10680
TEST_TIME 42 10612
TEST_TIME 43 10715
TEST_TIME 44 10644
TEST_TIME 45 10612
TEST_TIME 46 10784
TEST_TIME 47 10720
TEST_TIME 48 10632
TEST_TIME 49 10744
TEST_TIME 50 10782
TEST_TIME 51 10723
TEST_TIME 52 10759
TEST_TIME 53 10644
TEST_TIME 54 10470
TEST_TIME 55 10485
TEST_TIME 56 10396
TEST_TIME 57 10334
TEST_TIME 58 10390
TEST_TIME 59 10324
TEST_TIME 60 10225
TEST_TIME 61 10241
TEST_TIME 62 10204
TEST_TIME 63 10218
TEST_TIME 64 10263
TEST_TIME 65 10234
TEST_TIME 66 10309
TEST_TIME 67 10303
TEST_TIME 68 10249
TEST_TIME 69 10287
TEST_TIME 70 10327
TEST_TIME 71 10455
TEST_TIME 72 10420
TEST_TIME 73 10403
TEST_TIME 74 10420
TEST_TIME 75 10439
TEST_TIME 76 10345
TEST_TIME 77 10285
TEST_TIME 78 10218
TEST_TIME 79 10201
TEST_TIME 80 10173
TEST_TIME 81 10123
TEST_TIME 82 10080
TEST_TIME 83 10105
TEST_TIME 84 10146
TEST_TIME 85 10099
TEST_TIME 86 10094
TEST_TIME 87 10116
TEST_TIME 88 10116
TEST_TIME 89 10093
TEST_TIME 90 10076
TEST_TIME 91 10106
TEST_TIME 92 10109
TEST_TIME 93 10121
TEST_TIME 94 10194
TEST_TIME 95 10152
TEST_TIME 96 10248
TEST_TIME 97 10208
TEST_TIME 98 10112
TEST_TIME 99 10089
TEST_TIME 100 10063
TEST_TIME 101 10031
TEST_TIME 102 9986
TEST_TIME 103 10035
TEST_TIME 104 9991
TEST_TIME 105 9952
TEST_TIME 106 9924
TEST_TIME 107 9928
TEST_TIME 108 9940
TEST_TIME 109 9922
TEST_TIME 110 9934
TEST_TIME 111 9934
TEST_TIME 112 9967
TEST_TIME 113 9997
TEST_TIME 114 9997
TEST_TIME 115 10018
TEST_TIME 116 9996
TEST_TIME 117 10054
TEST_TIME 118 10097
TEST_TIME 119 10066
TEST_TIME 120 9989

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-12-2020 19:29:26 to 20-12-2020 19:29:29.

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 1632321 1632321 0 0.00 0 22158 6 0 0
doc_list_biud 1632321 1632321 0 0.00 0 59746 21 0 0
sp_add_invoice_to_stock 5061 4962 99 1.95 31 182019 17913 0 99
sp_cancel_adding_invoice 6511 6511 0 0.00 5 74178 603 0 0
sp_cancel_client_order 1736 1736 0 0.00 4 9391 273 0 0
sp_cancel_customer_reserve 640500 640500 0 0.00 1 59747 43 0 0
sp_cancel_pay_from_customer 670 670 0 0.00 2 5900 93 0 0
sp_cancel_pay_to_supplier 436 436 0 0.00 2 4147 59 0 0
sp_cancel_supplier_invoice 7158 7148 10 0.13 2 18321 529 0 10
sp_cancel_supplier_order 460 460 0 0.00 8 809834 75484 0 0
sp_cancel_write_off 12093 12093 0 0.00 1 16579 94 0 0
sp_client_order 20449 20449 0 0.00 4 60083 382 0 0
sp_customer_reserve 468237 468237 0 0.00 0 76450 176 0 0
sp_fill_shopping_cart 31455 31455 0 0.00 1 9240 30 0 0
sp_fill_shopping_cart_clo_res 468222 468222 0 0.00 0 13148 11 0 0
sp_get_clo_for_invoice 4947 4947 0 0.00 0 21806 257 0 0
sp_kill_cost_storno 19710 19710 0 0.00 0 15012 44 0 0
sp_kill_qstorno_ret_qs2qd 1300701 1300701 0 0.00 0 59729 23 0 0
sp_kill_qty_storno 683291 683291 0 0.00 0 59746 51 0 0
sp_lock_selected_doc 20755 20755 0 0.00 0 7964 4 0 0
sp_make_cost_storno 27542 27542 0 0.00 0 22155 46 0 0
sp_multiply_rows_for_pdistr 27542 27542 0 0.00 0 5523 24 0 0
sp_multiply_rows_for_qdistr 20449 20449 0 0.00 0 60072 174 0 0
sp_pay_from_customer 6799 6799 0 0.00 4 12401 101 0 0
sp_pay_to_supplier 5900 5900 0 0.00 5 12515 103 0 0
sp_payment_common 12699 12699 0 0.00 2 12388 29 0 0
sp_qd_handle_on_cancel_clo 1736 1736 0 0.00 0 9385 247 0 0
sp_qd_handle_on_invoice_upd_sts 11458 11458 0 0.00 0 20311 263 0 0
sp_qd_handle_on_reserve_upd_sts 9896 9896 0 0.00 0 23924 55 0 0
sp_reserve_write_off 9896 9896 0 0.00 6 23936 151 0 0
sp_supplier_invoice 5563 5563 0 0.00 6 85057 2855 0 0
sp_supplier_order 5466 5466 0 0.00 4 43240 1232 0 0
srv_aggregate_perf_data 90 90 0 0.00 2994 346034 21924 0 0
srv_fill_mon_cache_memory 144 144 0 0.00 833 140899 38711 0 0
srv_find_qd_qs_mism 1150918 1150918 0 0.00 0 13539 5 0 0
srv_make_invnt_saldo 552 552 0 0.00 37 31902 1041 0 0
srv_make_money_saldo 753 753 0 0.00 0 3008 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 199229 367921 294673 0 0
t$perf-abend:sp_add_invoice_to_stock 99 99 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4962 4962 0 0.00 0 10199 160 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 0 5973 91 0 0
t$perf-norm:sp_cancel_client_order 1736 1736 0 0.00 0 6420 11 0 0
t$perf-norm:sp_cancel_customer_reserve 700 700 0 0.00 0 4232 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 670 670 0 0.00 0 3820 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 436 436 0 0.00 0 515 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 382 382 0 0.00 0 2120 19 0 0
t$perf-norm:sp_cancel_supplier_order 460 460 0 0.00 0 14888 1276 0 0
t$perf-norm:sp_cancel_write_off 1081 1081 0 0.00 0 6655 15 0 0
t$perf-norm:sp_client_order 20449 20449 0 0.00 0 10989 15 0 0
t$perf-norm:sp_customer_reserve 997 997 0 0.00 0 4133 8 0 0
t$perf-norm:sp_pay_from_customer 6799 6799 0 0.00 0 8250 12 0 0
t$perf-norm:sp_pay_to_supplier 5900 5900 0 0.00 0 4264 8 0 0
t$perf-norm:sp_reserve_write_off 9896 9896 0 0.00 0 5989 10 0 0
t$perf-norm:sp_supplier_invoice 5563 5563 0 0.00 0 7160 13 0 0
t$perf-norm:sp_supplier_order 5466 5466 0 0.00 0 8949 12 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 284 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 144 144 0 0.00 0 800 9 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 4100 24 0 0
t$perf-norm:srv_make_money_saldo 753 753 0 0.00 0 553 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10084 9886 198 1.96 0 3447 15 0 198
v_all_customers 36904 36904 0 0.00 0 31 0 0 0
v_all_suppliers 31046 31046 0 0.00 0 14 1 0 0
v_all_wares 40898 40898 0 0.00 0 40 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 2004 10 0 0
v_cancel_client_order 3472 3472 0 0.00 0 1464 3 0 0
v_cancel_customer_prepayment 1340 1340 0 0.00 0 4090 9 0 0
v_cancel_customer_reserve 1400 1400 0 0.00 0 369 3 0 0
v_cancel_payment_to_supplier 872 872 0 0.00 0 2592 6 0 0
v_cancel_supplier_invoice 784 764 20 2.55 0 1972 15 0 20
v_cancel_supplier_order 920 920 0 0.00 0 341 3 0 0
v_cancel_write_off 2162 2162 0 0.00 0 4541 18 0 0
v_max_id_clo_ord 5455 5455 0 0.00 0 102 1 0 0
v_max_id_clo_res 997 997 0 0.00 0 3745 19 0 0
v_max_id_ord_sup 5550 5550 0 0.00 0 3581 4 0 0
v_max_non_paid_invoice 1382 1382 0 0.00 0 3979 6 0 0
v_max_non_paid_realizn 3647 3647 0 0.00 0 1047 3 0 0
v_min_id_clo_ord 5455 5455 0 0.00 0 1698 4 0 0
v_min_id_clo_res 997 997 0 0.00 0 8578 22 0 0
v_min_id_ord_sup 5550 5550 0 0.00 0 9232 8 0 0
v_min_non_paid_invoice 5900 5900 0 0.00 0 4824 17 0 0
v_min_non_paid_realizn 6799 6799 0 0.00 0 12383 18 0 0
v_our_firm 10298 10298 0 0.00 0 19 1 0 0
v_reserve_write_off 19792 19792 0 0.00 0 3210 4 0 0
x_lock_depdocs_on_canc_invoice 13277 13277 0 0.00 0 25528 87 0 0
x_lock_depdocs_on_canc_sup_ord 460 460 0 0.00 0 11733 270 0 0
x_make_qstorno_1000_1200 5466 5466 0 0.00 2 43228 1168 0 0
x_make_qstorno_1200_2000 5563 5563 0 0.00 2 78551 2754 0 0
x_make_qstorno_2100_3300 468237 468237 0 0.00 0 76429 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-12-2020 19:29:30 to 20-12-2020 19:29:34.

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:08 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:15 17291 8192000000 10231898416 10539880448 851148576 9.412 67 54 108 0 871845440 2321872 18374992
16:57:38 21445 8192000000 10325974144 10639339520 1368026624 14.309 100 85 170 0 1400290848 4543296 27720928
16:58:09 24239 8192000000 10353098896 10673545216 1407288432 14.660 100 89 179 1 1443344784 6441584 29614768
16:58:44 18105 8192000000 10380308752 10701873152 1435628816 14.911 100 92 184 0 1473029728 7338608 30062304
16:59:15 7040 8192000000 10394521664 10720788480 1454799440 15.080 100 89 179 0 1491782128 8005344 28977344
16:59:31 22644 8192000000 10423636368 10754797568 1471476720 15.227 100 86 172 1 1508358704 8673488 28208496
17:00:03 19684 8192000000 10437692432 10773889024 1495399216 15.436 100 86 172 0 1532322288 9505584 27417488
17:00:39 21274 8192000000 10468660512 10812030976 1524326688 15.688 100 86 172 1 1561751488 10159920 27264880
17:01:10 17051 8192000000 10502430272 10849562624 1557260048 15.973 100 81 162 0 1592628640 10140432 25228160
17:01:37 18941 8192000000 10532319584 10886905856 1583581120 16.199 100 78 156 0 1617741104 10178272 23981712
17:02:13 11811 8192000000 10568962880 10925568000 1623269392 16.538 100 84 168 1 1659633808 11192144 25172272
17:02:31 8358 8192000000 10571716800 10932629504 1634487808 16.633 100 86 172 1 1672398128 12173696 25736624
17:02:48 8942 8192000000 10591031056 10953965568 1651618704 16.778 100 84 166 0 1689164560 12927408 24618448
17:03:11 10315 8192000000 10617367552 10983882752 1676020208 16.984 100 83 166 0 1713167824 13023648 24123968
17:03:30 8924 8192000000 10647629904 11018932224 1701768512 17.200 100 81 163 0 1737854928 12925840 23160576
17:03:48 7348 8192000000 10664991424 11032866816 1719167888 17.345 100 90 178 2 1758512240 13690960 25653392
17:04:02 6690 8192000000 10667774064 11046232064 1732673168 17.458 100 87 174 3 1772113040 14422272 25017600
17:04:16 6035 8192000000 10680732496 11058028544 1744863280 17.559 100 87 174 0 1785238496 15098624 25276592
17:04:29 4794 8192000000 10700887728 11073097728 1754583504 17.640 100 84 166 1 1792494992 14604512 23306976
17:04:41 3419 8192000000 10707128624 11080994816 1761284240 17.695 100 79 158 2 1797520064 13857136 22378688
17:04:51 2707 8192000000 10709172624 11089743872 1773994624 17.800 100 88 177 2 1812990816 13441584 25554608
17:05:00 2457 8192000000 10705684336 11090145280 1777352048 17.828 100 77 152 2 1810437280 11852144 21233088
17:05:10 2368 8192000000 10723583312 11102601216 1783588528 17.879 100 76 153 2 1816899264 12270192 21040544
17:05:19 2009 8192000000 10738256528 11115532288 1798089456 17.998 100 84 167 1 1832627824 12274640 22263728
17:05:28 2173 8192000000 10739384160 11123077120 1804289904 18.049 100 79 158 2 1839590720 13166272 22134544
17:05:36 4128 8192000000 10743698368 11129266176 1805031040 18.055 100 79 159 2 1840610736 13236512 22343184
17:05:47 1985 8192000000 10760000528 11144306688 1811466784 18.108 100 78 156 1 1844941232 11981712 21492736
17:05:55 2056 8192000000 10762916880 11149275136 1822900272 18.201 100 84 167 1 1860091680 12649600 24541808
17:06:04 2303 8192000000 10769120672 11159687168 1829697488 18.257 100 87 172 1 1866775856 12378144 24700224
17:06:14 2195 8192000000 10784741920 11168927744 1838576528 18.329 100 90 180 0 1878339200 13539760 26222912
17:06:22 2075 8192000000 10787600512 11173560320 1845511280 18.386 100 90 179 1 1884586304 13820544 25254480
17:06:31 1902 8192000000 10796335792 11183972352 1850797968 18.429 100 93 184 0 1889568176 12023248 26746960
17:06:39 1393 8192000000 10803996384 11190284288 1856243840 18.473 100 90 179 0 1894470640 13082096 25144704
17:06:47 1212 8192000000 10801074832 11188416512 1859475872 18.499 100 91 185 1 1898091344 12384592 26230880
17:06:54 1143 8192000000 10810039856 11196039168 1861800032 18.518 100 98 197 2 1901160416 12184928 27175456
17:07:01 1105 8192000000 10805300032 11194494976 1864448528 18.539 100 89 177 3 1902582240 12697408 25436304
17:07:09 29583 8192000000 10784704400 11197894656 1866485136 18.556 100 51 101 2 1890345712 9805200 14055376
17:07:48 11480 8192000000 10777085648 11195547648 1857049440 18.479 100 21 43 2 1869097056 6345840 5701776
17:08:07 7270 8192000000 10768363872 11196215296 1862715552 18.525 100 40 79 2 1882372848 8548336 11108960
17:08:27 5540 8192000000 10775870448 11201273856 1866702144 18.558 100 30 61 2 1882719504 7545296 8472064
17:08:40 9982 8192000000 10776476432 11200794624 1865586224 18.549 100 20 40 1 1878086832 7211680 5288928
17:08:56 3943 8192000000 10787544928 11209302016 1872176576 18.602 100 26 53 1 1886655312 5603024 8875712
17:09:08 10439 8192000000 10772840496 11208327168 1869882896 18.583 100 13 26 3 1879621056 5874832 3863328
17:09:26 14562 8192000000 10773452704 11210452992 1872188736 18.602 100 11 22 1 1880757984 5776240 2793008
17:09:49 5850 8192000000 10781182000 11214442496 1876171456 18.634 100 17 34 1 1886648560 6124544 4352560
17:10:01 4978 8192000000 10782425264 11214393344 1877032704 18.641 100 19 38 0 1888772448 6262432 5477312
17:10:13 6224 8192000000 10791753856 11218657280 1880080496 18.666 100 18 36 1 1891251408 6059008 5111904
17:10:26 16996 8192000000 10798821456 11224109056 1883185600 18.691 100 36 72 2 1901652800 7273120 11194080
17:10:50 72084 8192000000 10799510336 11233378304 1887985984 18.730 100 34 66 2 1907161760 9469184 9706592
17:12:08 2771 8192000000 10815937840 11242463232 1891213712 18.756 100 31 62 1 1907250624 7739664 8297248
17:12:19 8057 8192000000 10808871536 11239460864 1891511728 18.758 100 27 55 1 1905419408 5973136 7934544
17:12:33 4682 8192000000 10813165904 11245514752 1898741568 18.816 100 37 74 1 1916204736 7232336 10230832
17:12:47 4490 8192000000 10811086224 11249520640 1895263200 18.788 100 29 58 2 1910641376 7004224 8373952
17:12:58 6435 8192000000 10820106896 11250708480 1899861216 18.825 100 34 68 1 1916302176 6384160 10056800
17:13:15 7176 8192000000 10816443728 11248070656 1898785680 18.817 100 21 42 1 1910107088 5242496 6078912
17:13:29 8290 8192000000 10815631888 11252793344 1903172400 18.852 100 21 42 1 1915864240 6226496 6465344
17:13:43 5902 8192000000 10817590880 11252178944 1904180496 18.860 100 26 53 4 1917870304 5772048 7917760
17:13:57 6335 8192000000 10817215296 11254554624 1906267152 18.877 100 38 77 0 1923787136 6820192 10699792
17:14:10 5498 8192000000 10808742064 11234877440 1867030352 18.560 98 20 40 2 1878259696 5777216 5452128
17:14:22 8887 8192000000 10810683504 11243450368 1896093488 18.795 100 19 38 2 1906926272 5626240 5206544
17:14:37 7492 8192000000 10806207120 11240947712 1893540864 18.774 100 16 32 0 1903817376 5528944 4747568
17:14:51 7946 8192000000 10799206064 11231940608 1878057136 18.649 99 11 22 2 1887106464 5405424 3643904
17:15:06 10774 8192000000 10778027536 11200491520 1830759632 18.266 97 25 50 1 1842749008 5018768 6970608
17:15:23 35153 8192000000 10779675312 11223474176 1855611280 18.468 98 22 44 2 1867067648 4871184 6585184
17:16:20 26133 8192000000 10781039776 11209768960 1807547920 18.076 96 21 40 2 1818698960 5940416 5210624
17:16:56 7294 8192000000 10775882080 11207696384 1849405008 18.417 99 28 56 1 1863816336 7081616 7329712
17:17:09 5505 8192000000 10778525712 11188310016 1813123792 18.121 98 39 78 4 1830257072 6735488 10397792
17:17:21 7756 8192000000 10763266112 11187961856 1833628240 18.289 99 33 66 1 1850757008 7140720 9988048
17:17:38 8180 8192000000 10748402400 11166982144 1778628784 17.838 97 27 52 5 1793358208 6444576 8284848
17:17:55 7022 8192000000 10736630192 11159478272 1822698832 18.200 100 32 63 3 1838410112 6609840 9101440
17:18:09 8822 8192000000 10731560368 11150864384 1764361936 17.720 97 21 42 1 1780465040 10618976 5484128
17:18:29 8691 8192000000 10719045200 11136937984 1751411648 17.613 97 17 32 3 1765631008 10144896 4074464
17:18:44 5396 8192000000 10690592672 11097849856 1709106096 17.261 95 34 68 0 1725128272 6051760 9970416
17:18:57 7376 8192000000 10720481088 11128516608 1779027440 17.841 99 25 49 1 1796874416 10321216 7525760
17:19:12 9154 8192000000 10698075984 11106353152 1710220416 17.271 96 17 34 2 1720521376 5456048 4844912
17:19:27 10328 8192000000 10684753808 11098431488 1711402512 17.280 96 22 44 0 1723418544 4918912 7097120
17:19:44 14105 8192000000 10723041008 11137499136 1799594496 18.011 100 24 48 2 1813054576 5982208 7477872
17:20:04 13494 8192000000 10701669312 11122819072 1734339584 17.472 96 25 50 2 1747596112 5613296 7643232
17:20:26 20132 8192000000 10727233264 11150163968 1811996464 18.112 100 30 61 2 1826704624 5723392 8984768
17:20:52 51151 8192000000 10724850880 11153158144 1801086864 18.023 99 25 49 0 1813577312 5285712 7204736
17:21:51 8520 8192000000 10737645584 11162988544 1826033696 18.227 100 29 58 2 1840666912 5964256 8668960
17:22:07 8325 8192000000 10740546160 11160862720 1810137936 18.097 99 17 34 0 1820178720 5371168 4669616
17:22:24 5434 8192000000 10756826032 11176161280 1834876368 18.299 100 43 86 0 1858463328 11088064 12498896
17:22:36 3282 8192000000 10791226736 11198324736 1852693664 18.444 100 57 114 4 1878267424 9474128 16099632
17:22:46 7613 8192000000 10773864832 11192995840 1851823184 18.437 100 30 59 2 1865724304 5836016 8065104
17:23:00 3591 8192000000 10771009552 11192373248 1852635632 18.444 100 31 60 0 1866727888 5149232 8943024
17:23:11 6027 8192000000 10770846416 11195772928 1854379808 18.458 100 33 66 1 1870379856 6927120 9072928
17:23:24 9506 8192000000 10775533040 11198672896 1855334128 18.465 100 27 52 3 1868770448 5964640 7471680
17:23:44 9853 8192000000 10783366032 11206434816 1857775904 18.485 100 23 46 1 1869714912 4990256 6948752
17:24:03 10544 8192000000 10787229712 11209170944 1866411056 18.555 100 25 50 1 1879435424 5487664 7536704
17:24:21 5542 8192000000 10791102352 11212668928 1868255664 18.570 100 20 38 1 1879356576 5412688 5688224
17:24:35 8113 8192000000 10785986160 11216187392 1873102656 18.609 100 28 54 2 1886949152 5130992 8715504
17:24:50 11450 8192000000 10784457744 11217895424 1874206096 18.618 100 18 36 1 1885040432 5604064 5230272
17:25:11 26137 8192000000 10793522128 11224690688 1878057136 18.649 100 23 46 0 1890686064 6006160 6622768
17:25:44 53669 8192000000 10789526080 11227176960 1882658160 18.687 100 23 46 1 1894832448 5411792 6762496
17:26:44 13633 8192000000 10798354112 11230941184 1885587072 18.710 100 25 50 4 1899356624 6093296 7676256
17:27:06 25711 8192000000 10832660000 11254960128 1904472528 18.862 100 38 76 0 1921707456 6584352 10650576
17:27:40 9335 8192000000 10853124112 11272773632 1919003904 18.979 100 56 111 1 1942674976 8284416 15386656
17:27:58 26062 8192000000 10847058272 11275386880 1920833584 18.994 100 40 80 0 1940282944 8591856 10857504
17:28:40 16396 8192000000 10866969488 11292606464 1936189568 19.116 100 43 86 0 1957678960 9229312 12260080
17:29:10 29934 8192000000 10873423168 11302928384 1941403216 19.158 100 35 70 0 1960708480 9227792 10077472
17:29:51 10691 8192000000 10901201664 11321552896 1953878096 19.257 100 54 108 2 1983128800 13459984 15790720
17:30:09 29368 8192000000 10900367440 11328835584 1960245200 19.308 100 51 102 2 1990477296 15127392 15104704
17:31:03 13028 8192000000 10886290000 11313676288 1942811552 19.169 99 48 95 1 1973149136 16700192 13637392
17:31:26 24460 8192000000 10906599888 11343073280 1961367040 19.317 100 40 80 1 1993154480 20335936 11451504
17:31:59 23637 8192000000 10896080096 11335831552 1955621856 19.271 99 44 88 0 1985864240 16868736 13373648
17:32:32 16932 8192000000 10903586688 11343192064 1968457408 19.373 100 34 68 3 1998554304 19101760 10995136
17:33:02 16594 8192000000 10919944032 11353968640 1974963552 19.425 100 40 80 2 2008098576 20375760 12759264
17:33:27 35354 8192000000 10917489040 11353387008 1960421552 19.309 99 44 84 1 1992671776 19105248 13144976
17:34:22 6444 8192000000 10913436720 11347988480 1958425344 19.294 99 46 91 3 1992892448 20862464 13604640
17:34:39 6441 8192000000 10927146064 11364139008 1980655600 19.470 100 53 106 2 2018655568 21660384 16339584
17:34:53 10484 8192000000 10932927376 11367415808 1982545136 19.485 100 47 94 1 2020321504 22853056 14923312
17:35:12 4005 8192000000 10941921488 11371696128 1990619024 19.549 100 60 119 1 2029986704 21697776 17669904
17:35:23 2093 8192000000 10953842544 11366690816 1986702208 19.518 100 84 168 2 2033768128 22664752 24401168
17:35:35 1655 8192000000 10956159520 11374776320 1991561232 19.556 100 87 173 0 2041394080 24203344 25629504
17:35:44 2222 8192000000 10968836944 11389763584 1998461248 19.611 100 82 163 0 2046061872 23589616 24011008
17:35:54 3992 8192000000 10938729136 11355373568 1972361648 19.404 99 65 129 0 2013588240 22623376 18603216
17:36:09 831 8192000000 10953634320 11371405312 1990268432 19.546 100 72 144 1 2034327008 22925360 21133216
17:36:16 5998 8192000000 10945639120 11370307584 1976652640 19.438 99 62 123 3 2018948928 23877632 18418656
17:36:44 6987 8192000000 10935376000 11363254272 1954547520 19.263 98 61 122 0 1998775312 25912816 18314976
17:36:57 2811 8192000000 10944518672 11367813120 1981359776 19.475 100 69 138 2 2028170688 25936096 20874816
17:37:07 4724 8192000000 10942679616 11365560320 1980910800 19.472 100 67 130 0 2027632112 27140256 19581056
17:37:18 1251 8192000000 10949890560 11364188160 1971061040 19.394 99 72 144 1 2018639856 26412240 21166576
17:37:29 2602 8192000000 10958425072 11373469696 1990982176 19.552 100 73 146 1 2039714512 26820672 21911664
17:37:39 3973 8192000000 10945115200 11368202240 1972225152 19.403 99 70 140 1 2020312384 26953840 21133392
17:37:50 1361 8192000000 10934307216 11355566080 1972771616 19.407 100 74 146 1 2022669504 26838848 23059040
17:37:58 2908 8192000000 10951753904 11370446848 1982187296 19.482 100 75 150 0 2035039904 30174544 22678064
17:38:08 3153 8192000000 10950401168 11367804928 1983424672 19.492 100 72 144 1 2036037648 31066224 21546752
17:38:19 12576 8192000000 10943118752 11366711296 1960020192 19.306 99 71 142 2 2012723856 31292720 21410944
17:38:39 1890 8192000000 10965277936 11381694464 1989328016 19.538 100 79 154 0 2048109008 35377312 23403680
17:38:49 4660 8192000000 10977693616 11398512640 1999832144 19.621 100 75 150 1 2059568832 36973344 22763344
17:39:07 5183 8192000000 10970332032 11392856064 1995361312 19.586 100 70 137 1 2052654320 36054656 21238352
17:39:20 1684 8192000000 10982734896 11396497408 2001415616 19.634 100 93 181 2 2065918240 36934608 27568016
17:39:29 1336 8192000000 10986416768 11401236480 2002655248 19.644 100 88 171 0 2066210096 36384320 27170528
17:39:37 4925 8192000000 10977699056 11395686400 1996711680 19.597 100 69 137 0 2055396560 37933616 20751264
17:39:49 2543 8192000000 10966721312 11379941376 1971976864 19.401 99 79 155 3 2032945488 36763248 24205376
17:39:57 6393 8192000000 10955933264 11374899200 1975993664 19.433 100 71 141 3 2038112272 40286768 21831840
17:40:11 5781 8192000000 10959192544 11375022080 1971626096 19.398 100 74 143 2 2037750160 43996480 22127584
17:40:24 5755 8192000000 10948287264 11374305280 1969443520 19.381 100 61 122 3 2032524608 43651856 19429232
17:40:37 2230 8192000000 10944920352 11359408128 1955266448 19.268 99 77 153 0 2022765520 43407312 24091760
17:40:47 5203 8192000000 10954420528 11368951808 1964031680 19.338 100 87 174 0 2038028544 46590544 27406320
17:41:04 3330 8192000000 10969705904 11379961856 1974970944 19.425 100 81 161 1 2049219120 48928768 25319408
17:41:14 2052 8192000000 10937323184 11343511552 1936669600 19.120 98 79 158 1 2010812736 48918864 25224272
17:41:25 1837 8192000000 10967123008 11383181312 1972807104 19.408 100 75 150 0 2049490912 53008928 23674880
17:41:37 11774 8192000000 10937060640 11372736512 1969002704 19.378 100 60 118 0 2035421568 47756000 18662864
17:41:56 14542 8192000000 10907390464 11356827648 1910737648 18.913 97 29 58 1 1958740400 38474240 9528512
17:42:18 17505 8192000000 10899232304 11354824704 1947967472 19.210 100 34 68 0 1994969520 36145776 10856272
17:42:42 12144 8192000000 10884550752 11329986560 1914341248 18.941 98 23 46 1 1953508864 31573952 7593664
17:43:08 23674 8192000000 10888128912 11333074944 1887463264 18.725 97 22 44 0 1929375712 34316288 7596160
17:43:38 36164 8192000000 10863576704 11310198784 1852564512 18.443 96 25 50 0 1892345296 31243872 8536912
17:44:24 19101 8192000000 10881464944 11316817920 1895696464 18.792 99 32 64 1 1945167984 38502256 10969264
17:44:57 12441 8192000000 10884507632 11326382080 1887207904 18.723 98 32 64 2 1943518672 44797488 11513280
17:45:15 28921 8192000000 10876397536 11315613696 1895943568 18.794 99 24 48 4 1941895136 37971200 7980368
17:45:57 38538 8192000000 10855104448 11294117888 1865851248 18.551 97 25 50 2 1908458720 34137024 8470448
17:46:46 37316 8192000000 10842950304 11287531520 1851736848 18.436 97 21 42 0 1892480256 33131440 7611968
17:47:51 32054 8192000000 10856394352 11312422912 1898798528 18.817 100 16 32 0 1944532768 40147408 5586832
17:48:40 47563 8192000000 10833991344 11295158272 1856894448 18.478 98 11 22 0 1894248896 33165104 4189344
17:49:34 42084 8192000000 10827885968 11283214336 1844342112 18.376 97 18 33 0 1869207712 20262608 4602992
17:50:36 59257 8192000000 10843377648 11301609472 1911606896 18.920 100 14 28 2 1932607072 17413520 3586656
17:51:42 76330 8192000000 10835322048 11289575424 1858971680 18.495 97 25 48 2 1873885488 8152128 6761680
17:53:07 50376 8192000000 10824434272 11273486336 1831939136 18.275 95 11 22 0 1847206128 11035328 4231664
17:54:13 68034 8192000000 10859655664 11322265600 1923466480 19.015 100 23 44 1 1945796512 15652576 6677456
17:55:56 140899 8192000000 10861730784 11301642240 1862407168 18.523 97 13 26 1 1882183664 16551200 3225296
17:58:37 78635 8192000000 10893827920 11338993664 1943298224 19.173 100 25 50 0 1956706672 6711744 6696704
18:00:02 25551 8192000000 10896033952 11358588928 1965453456 19.349 100 28 56 2 1986749504 13695344 7600704
18:00:37 46311 8192000000 10912160928 11363799040 1970795040 19.392 100 26 52 0 1997938864 19055856 8087968
18:01:38 71014 8192000000 10915728560 11378298880 1968199808 19.371 100 16 32 0 1992962992 19686832 5076352
18:02:58 115953 8192000000 10919417280 11392307200 1980461552 19.468 100 18 36 0 2000956800 15436416 5058832
18:05:00 33440 8192000000 10921862224 11393024000 1992765040 19.566 100 11 22 1 2011036336 15156112 3115184
18:05:45 43568 8192000000 10916614592 11395563520 1990368208 19.547 100 17 34 1 2011387184 15786416 5232560
18:06:50 35347 8192000000 10909087136 11393769472 1974402752 19.420 99 17 34 0 1997994336 18567776 5023808
18:07:56 41785 8192000000 10943817184 11403669504 1998126496 19.608 100 30 58 0 2015133312 8574992 8431824
18:08:57 44535 8192000000 10948628624 11411718144 2006361984 19.673 100 24 48 0 2024427984 11605280 6460720
18:09:49 68204 8192000000 10934025936 11419291648 2010817824 19.708 100 21 42 1 2031637552 14923520 5896208
18:11:08 70176 8192000000 10960470080 11427590144 2021328272 19.791 100 19 38 0 2037310336 10943648 5038416
18:12:25 38292 8192000000 10960051360 11434430464 2022685744 19.801 100 18 36 0 2053618416 25552512 5380160
18:13:17 62103 8192000000 10956834784 11429289984 2021998416 19.796 100 19 38 0 2039783120 12581632 5203072
18:14:31 38568 8192000000 10947977488 11421655040 2001453648 19.634 99 17 34 0 2019181760 13073728 4654384
18:15:16 43927 8192000000 10968469104 11436752896 2028323920 19.845 100 29 57 3 2051958224 15252544 8381760
18:16:09 61607 8192000000 10950511952 11439792128 2005972352 19.670 99 13 26 0 2030357872 20372272 4013248
18:17:16 58419 8192000000 10944582064 11394019328 1936282336 19.117 96 17 34 1 1949978240 8961552 4734352
18:18:25 46506 8192000000 10942191568 11411431424 1993658128 19.573 99 36 72 2 2014521072 11004384 9858560
18:19:18 60624 8192000000 10919576208 11383640064 1907549392 18.887 95 22 44 1 1927897952 14544176 5804384
18:20:31 91823 8192000000 10935335248 11382124544 1950908560 19.234 98 44 88 3 1972277136 9167776 12200800
18:22:18 78692 8192000000 10904891424 11372216320 1934776672 19.105 97 30 60 2 1952618048 9604816 8236560
18:23:45 66171 8192000000 10893746720 11371147264 1941892224 19.162 98 17 34 1 1960932928 14079248 4961456
18:25:09 76175 8192000000 10885499872 11375534080 1937591552 19.128 99 7 14 0 1958223344 18541312 2090480
18:26:31 44438 8192000000 10892546592 11372011520 1966273328 19.356 100 8 16 1 1988407936 19048240 3086368
18:27:26 85968 8192000000 10877638112 11367890944 1912285376 18.925 97 9 18 2 1926663408 12189344 2188688
18:28:58 36841 8192000000 10898947552 11353899008 1940149600 19.148 99 19 37 2 1959772416 14570000 5052816
18:30:19 57985 8192000000 10824132304 11297456128 1791802624 17.947 92 13 25 0 1805501088 10297936 3400528
18:31:30 49173 8192000000 10851982880 11318669312 1875007664 18.625 97 12 24 0 1886680576 8690320 2982592
18:32:29 45235 8192000000 10836208640 11297628160 1837912864 18.324 95 14 28 1 1848846864 7346448 3587552
18:33:27 66064 8192000000 10842010304 11314708480 1825498896 18.223 95 8 16 0 1839467952 11512688 2456368
18:34:40 37585 8192000000 10851334944 11313598464 1875132128 18.626 97 23 46 0 1893046144 11069248 6844768
18:35:28 33478 8192000000 10876711248 11310211072 1869048512 18.577 97 43 86 0 1894106640 12208528 12849600
18:36:12 39832 8192000000 10860544592 11329171456 1913062576 18.931 99 29 58 1 1936100000 14592720 8444704
18:36:58 46500 8192000000 10890142400 11346247680 1942182976 19.164 100 35 70 1 1970297552 17994192 10120384
18:38:26 72911 8192000000 10837633456 11301257216 1813214080 18.122 94 11 22 1 1833816272 17374192 3228000
18:39:46 27719 8192000000 10850670288 11295186944 1888168576 18.731 99 42 85 0 1909472368 9295808 12007984
18:40:22 129419 8192000000 10851318208 11318476800 1824841344 18.217 95 22 44 0 1843203520 12682560 5679616
18:42:49 23641 8192000000 10885691264 11317850112 1925406512 19.030 99 53 102 2 1946847872 7486080 13955280
18:43:27 112082 8192000000 10868244496 11321937920 1908592896 18.895 98 57 112 0 1935770112 10660192 16517024
18:45:30 43866 8192000000 10879062080 11333292032 1935802656 19.113 100 34 68 1 1958535040 12698960 10033424
18:46:21 47752 8192000000 10874341360 11340718080 1916807568 18.961 99 18 36 1 1937110384 15336592 4966224
18:47:18 64466 8192000000 10877915424 11359768576 1943732608 19.177 100 12 24 0 1965469440 18341104 3395728
18:48:29 58685 8192000000 10879245424 11354144768 1931413888 19.078 99 12 24 1 1956475600 21434240 3627472
18:49:35 50892 8192000000 10887732816 11366928384 1952186128 19.244 100 21 42 3 1979932192 20508800 7237264
18:50:35 48936 8192000000 10876120272 11372204032 1950174800 19.228 100 7 14 0 1969358960 17071376 2112784
18:51:32 38376 8192000000 10878422736 11369861120 1953073120 19.251 100 8 16 0 1972196032 16736288 2386624
18:52:21 58655 8192000000 10870408288 11352907776 1950294304 19.229 100 23 46 0 1968481520 11106368 7080848
18:53:48 67636 8192000000 10873275056 11341778944 1930362544 19.070 99 15 30 0 1950219312 15691376 4165392
18:55:03 21215 8192000000 10891083536 11355791360 1962275984 19.324 100 45 88 3 1983796160 8641696 12878480
18:55:46 51886 8192000000 10906424112 11369664512 1970705936 19.391 100 17 34 1 1985249392 9670160 4873296
18:56:44 58469 8192000000 10912730064 11383808000 1978607104 19.454 100 32 64 3 2000337776 13290640 8440032
18:57:49 28074 8192000000 10920752368 11383463936 1967032944 19.362 99 29 57 2 1983658624 9342064 7283616
18:58:28 58139 8192000000 10934911872 11404652544 1992633200 19.565 100 27 54 0 2009760000 10381536 6745264
19:00:21 125491 8192000000 10923720896 11402391552 1999581120 19.619 100 8 16 0 2016063024 14190160 2291744
19:02:39 11274 8192000000 10930691056 11382738944 1974767856 19.423 99 56 111 1 1998963584 7253840 16941888
19:02:57 16129 8192000000 10947403216 11404349440 1997295984 19.601 100 48 96 0 2021323408 10114848 13912576
19:03:27 57579 8192000000 10915700304 11415547904 1984709008 19.502 100 16 32 1 2005821168 16400592 4711568
19:04:31 113205 8192000000 10906234928 11387469824 1945017040 19.187 98 15 30 1 1962649552 13431760 4200752
19:06:31 58784 8192000000 10904608384 11389251584 1944198848 19.180 98 9 18 1 1962200640 15524912 2476880
19:07:36 54397 8192000000 10924024976 11412004864 1984341120 19.499 100 9 18 0 2004550816 17424448 2785248
19:08:55 71984 8192000000 10906427872 11398270976 1949665872 19.224 98 9 18 0 1970976384 18635744 2674768
19:10:17 41540 8192000000 10900771328 11392442368 1975358080 19.428 100 12 24 0 1994769632 15915200 3496352
19:11:15 57158 8192000000 10905453360 11379544064 1948752832 19.217 98 15 30 0 1963544912 10104944 4687136
19:12:22 77665 8192000000 10894388288 11373092864 1939324256 19.141 98 21 42 1 1958426880 13188944 5913680
19:13:54 94039 8192000000 10887492592 11377901568 1900063072 18.827 96 15 30 1 1921890528 17422208 4405248
19:15:35 78273 8192000000 10872833248 11343781888 1905398496 18.870 97 11 22 0 1923438672 14743984 3296192
19:16:59 43585 8192000000 10871273360 11339124736 1905471456 18.870 98 41 81 1 1930262464 12799040 11991968
19:17:53 30318 8192000000 10892568624 11361796096 1936669456 19.120 99 27 54 0 1957176224 12633072 7873696
19:18:49 83796 8192000000 10892201200 11375583232 1909853792 18.905 97 20 40 1 1933287920 17238096 6196032
19:20:21 41942 8192000000 10856723472 11329589248 1859868912 18.502 95 11 22 1 1878806832 15616032 3321888
19:21:09 55317 8192000000 10858549568 11316629504 1848944000 18.414 95 25 50 1 1871254320 14902128 7408192
19:22:12 48975 8192000000 10850449136 11308142592 1845794592 18.388 96 28 56 0 1867151648 13740400 7616656
19:23:11 14697 8192000000 10869907536 11314737152 1895026752 18.786 98 50 100 2 1921946256 13125552 13793952
19:23:33 28872 8192000000 10865801936 11311456256 1899551616 18.823 99 55 110 2 1930046944 15649680 14845648
19:24:10 106044 8192000000 10854206480 11334946816 1868608304 18.573 97 18 36 0 1887366176 13700208 5057664
19:26:03 72165 8192000000 9318306256 9584611328 450457200 5.212 24 8 15 0 457388448 4796848 2134400

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 20-12-2020 19:29:36 to 20-12-2020 19:30:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 99 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-12-2020 19:30:07 to 20-12-2020 19:30:09.

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          243286
MON$OLDEST_ACTIVE               244017
MON$OLDEST_SNAPSHOT             244017
MON$NEXT_TRANSACTION            244017
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                       2044896
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:147: 
:148: mscs-test-161.budzdorov.ru    Sun Dec 20 19:27:39 2020
:149:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:150: 
--- end of diff output ---

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

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