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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17525724 kB
MemAvailable 31416932 kB
Buffers 0 kB
Cached 14148144 kB
SwapCached 4820 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-29 22:27:12
DTS_END                         2020-12-29 22:27:12.0470
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/34288
TRN_ID                          240251
ATT_ID                          676
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: 8971.26 19530 1076551
customer order: creation 174.33 373 20920
customer order: refuse 15.10 328 1812
order to supplier: creation 47.88 1290 5746
order to supplier: removal 3.48 90695 418
invoice (draft): creation 47.51 3300 5701
invoice (draft): removal 49.81 787 5977
invoice accept: apply 42.08 17607 5050
invoice accept: cancel 44.75 855 5370
customer reserve: creation 3868.32 175 464198
customer reserve: removal 4382.96 57 525955
realization accept: apply 83.97 194 10076
realization accept: cancel 80.05 118 9606
payment from customer: creation 59.33 129 7120
payment from customer: removal 6.02 86 722
payment to supplier: creation 49.53 146 5943
payment to supplier: removal 3.68 78 442
service: total inventory turnovers 4.93 1040 592
service: total monetary turnovers 6.64 21 797
service: aggregate perf. data 0.85 20766 102
service: refresh index statistics 0.03 252545 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7348
TEST_TIME 2 3975
TEST_TIME 3 5111
TEST_TIME 4 5334
TEST_TIME 5 5082
TEST_TIME 6 5185
TEST_TIME 7 5079
TEST_TIME 8 5449
TEST_TIME 9 5768
TEST_TIME 10 5880
TEST_TIME 11 5985
TEST_TIME 12 6075
TEST_TIME 13 5931
TEST_TIME 14 6014
TEST_TIME 15 5996
TEST_TIME 16 6603
TEST_TIME 17 6893
TEST_TIME 18 6993
TEST_TIME 19 7335
TEST_TIME 20 8306
TEST_TIME 21 8653
TEST_TIME 22 8614
TEST_TIME 23 9026
TEST_TIME 24 9212
TEST_TIME 25 9416
TEST_TIME 26 10395
TEST_TIME 27 10428
TEST_TIME 28 10232
TEST_TIME 29 10419
TEST_TIME 30 10265
TEST_TIME 31 10325
TEST_TIME 32 10243
TEST_TIME 33 9980
TEST_TIME 34 9812
TEST_TIME 35 9868
TEST_TIME 36 9641
TEST_TIME 37 9569
TEST_TIME 38 9593
TEST_TIME 39 9532
TEST_TIME 40 9633
TEST_TIME 41 9568
TEST_TIME 42 9457
TEST_TIME 43 9396
TEST_TIME 44 9367
TEST_TIME 45 9289
TEST_TIME 46 9242
TEST_TIME 47 9161
TEST_TIME 48 9138
TEST_TIME 49 9151
TEST_TIME 50 9113
TEST_TIME 51 9036
TEST_TIME 52 8953
TEST_TIME 53 9131
TEST_TIME 54 9334
TEST_TIME 55 9348
TEST_TIME 56 9369
TEST_TIME 57 9396
TEST_TIME 58 9458
TEST_TIME 59 9514
TEST_TIME 60 9562
TEST_TIME 61 9530
TEST_TIME 62 9512
TEST_TIME 63 9519
TEST_TIME 64 9458
TEST_TIME 65 9425
TEST_TIME 66 9459
TEST_TIME 67 9398
TEST_TIME 68 9344
TEST_TIME 69 9311
TEST_TIME 70 9246
TEST_TIME 71 9224
TEST_TIME 72 9173
TEST_TIME 73 9169
TEST_TIME 74 9149
TEST_TIME 75 9111
TEST_TIME 76 9194
TEST_TIME 77 9143
TEST_TIME 78 9181
TEST_TIME 79 9236
TEST_TIME 80 9189
TEST_TIME 81 9353
TEST_TIME 82 9317
TEST_TIME 83 9313
TEST_TIME 84 9302
TEST_TIME 85 9404
TEST_TIME 86 9308
TEST_TIME 87 9234
TEST_TIME 88 9195
TEST_TIME 89 9193
TEST_TIME 90 9153
TEST_TIME 91 9135
TEST_TIME 92 9103
TEST_TIME 93 9095
TEST_TIME 94 9075
TEST_TIME 95 9096
TEST_TIME 96 9162
TEST_TIME 97 9175
TEST_TIME 98 9131
TEST_TIME 99 9111
TEST_TIME 100 9157
TEST_TIME 101 9134
TEST_TIME 102 9148
TEST_TIME 103 9206
TEST_TIME 104 9238
TEST_TIME 105 9223
TEST_TIME 106 9249
TEST_TIME 107 9218
TEST_TIME 108 9144
TEST_TIME 109 9107
TEST_TIME 110 9094
TEST_TIME 111 9074
TEST_TIME 112 9062
TEST_TIME 113 9029
TEST_TIME 114 9017
TEST_TIME 115 9001
TEST_TIME 116 8991
TEST_TIME 117 9006
TEST_TIME 118 9041
TEST_TIME 119 9041
TEST_TIME 120 8973

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-12-2020 22:28:24 to 29-12-2020 22:28:27.

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 1505302 1505302 0 0.00 0 31148 6 0 0
doc_list_biud 1505301 1505301 0 0.00 0 29215 26 0 0
sp_add_invoice_to_stock 5149 5050 99 1.92 22 153818 17607 0 99
sp_cancel_adding_invoice 5370 5370 0 0.00 5 76625 856 0 0
sp_cancel_client_order 1812 1812 0 0.00 4 9715 329 0 0
sp_cancel_customer_reserve 525955 525955 0 0.00 1 28150 57 0 0
sp_cancel_pay_from_customer 722 722 0 0.00 2 7112 86 0 0
sp_cancel_pay_to_supplier 442 442 0 0.00 3 5350 79 0 0
sp_cancel_supplier_invoice 5980 5977 3 0.05 2 14279 788 0 3
sp_cancel_supplier_order 418 418 0 0.00 9 971961 90696 0 0
sp_cancel_write_off 9606 9606 0 0.00 1 24180 119 0 0
sp_client_order 20920 20920 0 0.00 3 15165 373 0 0
sp_customer_reserve 464198 464198 0 0.00 0 99960 176 0 0
sp_fill_shopping_cart 32344 32344 0 0.00 1 14170 43 0 0
sp_fill_shopping_cart_clo_res 464194 464194 0 0.00 0 17894 15 0 0
sp_get_clo_for_invoice 5042 5042 0 0.00 0 35208 315 0 0
sp_kill_cost_storno 16140 16140 0 0.00 0 8561 54 0 0
sp_kill_qstorno_ret_qs2qd 1067911 1067911 0 0.00 0 28139 31 0 0
sp_kill_qty_storno 564255 564255 0 0.00 0 29215 68 0 0
sp_lock_selected_doc 21060 21060 0 0.00 0 8152 6 0 0
sp_make_cost_storno 28181 28181 0 0.00 0 31128 59 0 0
sp_multiply_rows_for_pdistr 28180 28180 0 0.00 0 9571 31 0 0
sp_multiply_rows_for_qdistr 20920 20920 0 0.00 0 10075 185 0 0
sp_pay_from_customer 7120 7120 0 0.00 4 15901 129 0 0
sp_pay_to_supplier 5943 5943 0 0.00 5 18106 147 0 0
sp_payment_common 13063 13063 0 0.00 1 18050 42 0 0
sp_qd_handle_on_cancel_clo 1812 1812 0 0.00 0 9709 305 0 0
sp_qd_handle_on_invoice_upd_sts 10411 10411 0 0.00 0 20598 305 0 0
sp_qd_handle_on_reserve_upd_sts 10076 10076 0 0.00 0 29214 69 0 0
sp_reserve_write_off 10076 10076 0 0.00 6 29247 195 0 0
sp_supplier_invoice 5701 5701 0 0.00 6 77670 3301 0 0
sp_supplier_order 5746 5746 0 0.00 5 29697 1290 0 0
srv_aggregate_perf_data 102 102 0 0.00 2289 441208 20767 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1410 154492 31574 0 0
srv_find_qd_qs_mism 1027678 1027678 0 0.00 0 26400 6 0 0
srv_make_invnt_saldo 592 592 0 0.00 15 54631 1041 0 0
srv_make_money_saldo 797 797 0 0.00 0 822 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 131747 318938 252546 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 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5050 5050 0 0.00 0 17491 162 0 0
t$perf-norm:sp_cancel_adding_invoice 447 447 0 0.00 0 9189 118 0 0
t$perf-norm:sp_cancel_client_order 1812 1812 0 0.00 0 3924 15 0 0
t$perf-norm:sp_cancel_customer_reserve 697 697 0 0.00 0 625 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 722 722 0 0.00 0 6570 22 0 0
t$perf-norm:sp_cancel_pay_to_supplier 442 442 0 0.00 0 24170 64 0 0
t$perf-norm:sp_cancel_supplier_invoice 394 394 0 0.00 0 572 14 0 0
t$perf-norm:sp_cancel_supplier_order 418 418 0 0.00 0 20325 1485 0 0
t$perf-norm:sp_cancel_write_off 1013 1013 0 0.00 0 4200 9 0 0
t$perf-norm:sp_client_order 20921 20921 0 0.00 0 12059 17 0 0
t$perf-norm:sp_customer_reserve 1054 1054 0 0.00 0 933 6 0 0
t$perf-norm:sp_pay_from_customer 7120 7120 0 0.00 0 13183 11 0 0
t$perf-norm:sp_pay_to_supplier 5943 5943 0 0.00 0 12085 15 0 0
t$perf-norm:sp_reserve_write_off 10076 10076 0 0.00 0 15308 11 0 0
t$perf-norm:sp_supplier_invoice 5701 5701 0 0.00 0 8092 17 0 0
t$perf-norm:sp_supplier_order 5746 5746 0 0.00 0 13213 19 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 634 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 769 7 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 713 19 0 0
t$perf-norm:srv_make_money_saldo 797 797 0 0.00 0 2550 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10280 10082 198 1.92 0 5557 17 0 198
v_all_customers 37428 37428 0 0.00 0 127 1 0 0
v_all_suppliers 31260 31260 0 0.00 0 187 1 0 0
v_all_wares 41838 41838 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 894 894 0 0.00 0 1159 9 0 0
v_cancel_client_order 3624 3624 0 0.00 0 2920 7 0 0
v_cancel_customer_prepayment 1444 1444 0 0.00 0 1865 6 0 0
v_cancel_customer_reserve 1394 1394 0 0.00 0 2052 6 0 0
v_cancel_payment_to_supplier 884 884 0 0.00 0 2051 7 0 0
v_cancel_supplier_invoice 794 788 6 0.75 0 1664 15 0 6
v_cancel_supplier_order 836 836 0 0.00 0 278 3 0 0
v_cancel_write_off 2026 2026 0 0.00 0 4131 16 0 0
v_max_id_clo_ord 5742 5742 0 0.00 0 2705 2 0 0
v_max_id_clo_res 1054 1054 0 0.00 0 4851 18 0 0
v_max_id_ord_sup 5683 5683 0 0.00 0 3790 3 0 0
v_max_non_paid_invoice 1738 1738 0 0.00 0 1873 4 0 0
v_max_non_paid_realizn 3943 3943 0 0.00 0 5509 8 0 0
v_min_id_clo_ord 5742 5742 0 0.00 0 6415 8 0 0
v_min_id_clo_res 1054 1054 0 0.00 0 4277 11 0 0
v_min_id_ord_sup 5683 5683 0 0.00 0 8302 11 0 0
v_min_non_paid_invoice 5943 5943 0 0.00 0 18047 28 0 0
v_min_non_paid_realizn 7120 7120 0 0.00 0 15895 29 0 0
v_our_firm 10764 10764 0 0.00 0 19 1 0 0
v_reserve_write_off 20148 20148 0 0.00 0 5563 6 0 0
x_lock_depdocs_on_canc_invoice 10953 10953 0 0.00 0 14642 111 0 0
x_lock_depdocs_on_canc_sup_ord 418 418 0 0.00 0 16060 364 0 0
x_make_qstorno_1000_1200 5746 5746 0 0.00 2 29690 1209 0 0
x_make_qstorno_1200_2000 5701 5701 0 0.00 2 77660 3143 0 0
x_make_qstorno_2100_3300 464198 464198 0 0.00 0 99958 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-12-2020 22:28:28 to 29-12-2020 22:28:32.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:15 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:22 31672 8192000000 10305656544 10620379136 1134102000 12.160 84 70 140 0 1159650064 3215280 22332784
19:58:03 38060 8192000000 10372357504 10694078464 1419267248 14.766 100 91 182 0 1454730464 5874640 29588576
19:58:51 27295 8192000000 10405469104 10736328704 1452961824 15.064 100 82 164 0 1486586720 7027360 26597536
19:59:30 13428 8192000000 10436620976 10767183872 1488965216 15.380 100 90 180 1 1526272416 8173968 29133232
19:59:55 15238 8192000000 10446600592 10778955776 1500518528 15.481 100 91 182 2 1538833008 8800784 29513696
20:00:22 17747 8192000000 10447142096 10786058240 1508838032 15.553 100 86 172 0 1545640944 9110864 27692048
20:00:53 24718 8192000000 10464507680 10805522432 1519923936 15.650 100 80 160 1 1555052160 9402832 25725392
20:01:26 22154 8192000000 10481923536 10826825728 1541352464 15.835 100 83 166 0 1577373760 9758512 26262784
20:01:56 14979 8192000000 10507114592 10858553344 1566953120 16.056 100 75 150 0 1600552624 9857856 23741648
20:02:19 18761 8192000000 10544027696 10898284544 1599549120 16.336 100 85 170 1 1636214224 10381440 26283664
20:02:47 12552 8192000000 10555283104 10914869248 1617514576 16.489 100 73 146 2 1650483584 10633248 22335760
20:03:08 7988 8192000000 10582082432 10945445888 1641007872 16.688 100 77 154 1 1674606400 10490080 23108448
20:03:23 12294 8192000000 10604954128 10971017216 1658295600 16.834 100 80 160 2 1693536272 11519168 23721504
20:03:43 7936 8192000000 10619028800 10986586112 1674899152 16.974 100 79 158 1 1710116272 12129904 23087216
20:04:00 9221 8192000000 10639521232 11009687552 1700321376 17.188 100 85 170 3 1737934720 12840128 24773216
20:04:16 8217 8192000000 10657381024 11028226048 1716112400 17.320 100 87 175 0 1755095632 13800832 25182400
20:04:32 7571 8192000000 10662819760 11039010816 1721461056 17.364 100 78 154 0 1756817728 13383088 21973584
20:04:49 9576 8192000000 10669730208 11047436288 1731915040 17.451 100 77 155 2 1767001168 13588880 21497248
20:05:08 5526 8192000000 10689193312 11064819712 1744437904 17.555 100 86 172 2 1782526160 13951312 24136944
20:05:19 4204 8192000000 10686107248 11064987648 1754052256 17.635 100 82 164 4 1791712320 13701008 23959056
20:05:31 4853 8192000000 10706751856 11083456512 1762091328 17.702 100 80 160 0 1798633792 14106912 22435552
20:05:43 5412 8192000000 10718576192 11095564288 1773826160 17.799 100 85 170 2 1812177056 14563728 23787168
20:05:55 2764 8192000000 10720162320 11100413952 1779672368 17.847 100 81 160 1 1816199712 14361056 22166288
20:06:05 3446 8192000000 10723101008 11105116160 1787084272 17.908 100 85 170 1 1824982688 14090352 23808064
20:06:15 3159 8192000000 10737011056 11119583232 1794857104 17.972 100 87 175 0 1834157648 14643760 24656784
20:06:32 4044 8192000000 10743774160 11130261504 1796832224 17.988 100 82 162 3 1833842192 13832576 23177392
20:06:44 2958 8192000000 10751121280 11146584064 1818508768 18.165 100 78 155 1 1852060400 11277520 22274112
20:06:53 3460 8192000000 10763731680 11154157568 1826991632 18.235 100 87 169 1 1863306544 11545552 24769360
20:07:03 3060 8192000000 10778421424 11161718784 1834600880 18.297 100 89 176 1 1871928288 12521040 24806368
20:07:13 2255 8192000000 10783580112 11173183488 1834957888 18.300 100 81 161 3 1874393760 16731312 22704560
20:07:21 3101 8192000000 10777752816 11171373056 1843903472 18.373 100 74 148 1 1877253856 12306880 21043504
20:07:30 2110 8192000000 10782260576 11176964096 1853585584 18.451 100 93 183 1 1891461504 12022864 25853056
20:07:39 1887 8192000000 10799424096 11187949568 1856537120 18.475 100 89 181 1 1894473824 12774640 25162064
20:07:48 2389 8192000000 10801530944 11192201216 1857868400 18.486 100 87 171 1 1895820784 14054304 23898080
20:07:57 1499 8192000000 10804252736 11192872960 1858402320 18.490 100 88 176 1 1898176176 15145040 24628816
20:08:05 1615 8192000000 10795017392 11188785152 1862105264 18.520 100 87 174 0 1900690416 14593104 23992048
20:08:14 2762 8192000000 10799134208 11192811520 1866724688 18.558 100 83 165 1 1902316832 12613888 22978256
20:08:24 2104 8192000000 10812146224 11202719744 1868607408 18.573 100 87 174 1 1905523520 12592784 24323328
20:08:33 1758 8192000000 10806593152 11199467520 1868831024 18.575 100 81 163 2 1903697248 12350880 22515344
20:08:42 2127 8192000000 10812449120 11207618560 1874587280 18.621 100 89 176 1 1912284272 11637488 26059504
20:08:50 3881 8192000000 10809780416 11206598656 1875192576 18.626 100 86 173 1 1911663936 12078976 24392384
20:09:01 15527 8192000000 10815824464 11214655488 1876736960 18.639 100 80 165 0 1912433008 12537408 23158640
20:09:23 1493 8192000000 10827694592 11219668992 1884508960 18.702 100 91 183 1 1922846880 12712384 25625536
20:09:31 1956 8192000000 10832866928 11224641536 1887785200 18.728 100 93 185 1 1927235056 13359680 26090176
20:09:40 10718 8192000000 10823022416 11221540864 1888257328 18.732 100 75 147 3 1921951136 13894496 19799312
20:09:57 3405 8192000000 10824710928 11225784320 1889864208 18.745 100 81 162 0 1925555952 12675568 23016176
20:10:12 7558 8192000000 10816348544 11226619904 1885516512 18.710 100 51 102 0 1910937584 11341072 14080000
20:10:26 5002 8192000000 10814505568 11226562560 1889493104 18.742 100 54 108 0 1915415712 10867936 15054672
20:10:38 3937 8192000000 10796991872 11222224896 1893385296 18.773 100 43 86 0 1913728240 8644224 11698720
20:10:49 4158 8192000000 10805177776 11224748032 1885336352 18.708 100 33 67 1 1901117360 6537872 9243136
20:11:00 4900 8192000000 10806894288 11222130688 1890981696 18.754 100 39 78 0 1908732528 6633968 11116864
20:11:11 2813 8192000000 10800027504 11226910720 1893917712 18.777 100 40 80 0 1911422480 6678464 10826304
20:11:21 4575 8192000000 10805111936 11233132544 1893067968 18.770 100 34 66 2 1911362624 8583088 9711568
20:11:36 5518 8192000000 10802626464 11229798400 1892198912 18.763 100 23 46 1 1905637536 6569472 6869152
20:11:53 4690 8192000000 10817570768 11237711872 1898075984 18.811 100 39 79 3 1917321776 8390976 10854816
20:12:05 8597 8192000000 10811061296 11238342656 1897496528 18.806 100 27 54 2 1912293744 7358800 7438416
20:12:20 10227 8192000000 10808901232 11238387712 1900900176 18.834 100 24 48 1 1914982016 7143504 6938336
20:12:36 5557 8192000000 10812512672 11241422848 1905253152 18.869 100 26 52 3 1920071296 6790736 8027408
20:12:50 6486 8192000000 10817081968 11246325760 1904826400 18.865 100 29 58 2 1919984672 6784976 8373296
20:13:05 6039 8192000000 10823071792 11249319936 1904874496 18.865 100 21 42 2 1917774016 7148016 5751504
20:13:20 10604 8192000000 10834484272 11252236288 1907119600 18.884 100 27 54 2 1920995888 6061552 7814736
20:13:37 66227 8192000000 10831868432 11260280832 1911212752 18.916 100 36 72 3 1927783424 5531824 11038848
20:14:51 6306 8192000000 10830467840 11263512576 1912135888 18.924 100 38 76 1 1931615840 8692848 10787104
20:15:04 10843 8192000000 10831648848 11260178432 1909444112 18.902 100 26 52 1 1922652176 6110976 7097088
20:15:22 6774 8192000000 10832512944 11264729088 1912151104 18.924 100 32 64 2 1928203408 7831360 8220944
20:15:38 6552 8192000000 10823777440 11263033344 1915166048 18.948 100 30 58 4 1930203696 6754128 8283520
20:15:50 5341 8192000000 10833458080 11268562944 1913665568 18.936 100 19 38 0 1924882048 6123104 5093376
20:16:04 5925 8192000000 10823720096 11264905216 1911663248 18.920 100 22 44 1 1924011792 5789264 6559280
20:16:16 4231 8192000000 10827502496 11264573440 1914065920 18.939 100 30 60 1 1930124448 6793248 9265280
20:16:27 6080 8192000000 10839763312 11265323008 1894474768 18.782 99 29 58 1 1908463616 5265424 8723424
20:16:40 8686 8192000000 10819515600 11259805696 1911348720 18.917 100 18 36 1 1922238304 6190864 4698720
20:16:56 6868 8192000000 10814008192 11250421760 1883933776 18.697 99 17 34 2 1894150688 5737472 4479440
20:17:11 4695 8192000000 10800049312 11223257088 1859183248 18.497 98 38 75 3 1875610592 5658928 10768416
20:17:24 10338 8192000000 10788537232 11217498112 1844012928 18.373 98 21 42 0 1856400480 6105696 6281856
20:17:41 7663 8192000000 10783933648 11217805312 1869717296 18.582 100 22 43 1 1881843408 5791808 6334304
20:17:55 15371 8192000000 10778306976 11195449344 1793539728 17.961 96 29 58 1 1808078816 6250944 8288144
20:18:17 59778 8192000000 10780513552 11191259136 1780192544 17.851 95 30 59 1 1794646832 5239152 9215136
20:19:24 8251 8192000000 10757234944 11173625856 1809597520 18.093 97 43 85 0 1830051504 8126816 12327168
20:19:42 8228 8192000000 10759566896 11191463936 1848082400 18.407 100 22 44 1 1860655696 6207568 6365728
20:19:58 7564 8192000000 10748314080 11165974528 1774742224 17.806 96 12 24 1 1783262528 5050912 3469392
20:20:13 3140 8192000000 10755686832 11170127872 1829037008 18.251 100 58 114 0 1855280704 9390544 16853152
20:20:24 3490 8192000000 10736584672 11133468672 1787511104 17.911 99 38 74 3 1804689552 5601904 11576544
20:20:34 5917 8192000000 10727445744 11149099008 1810990320 18.104 100 22 44 1 1824064416 7025936 6048160
20:20:46 7673 8192000000 10713917744 11129683968 1770855072 17.774 98 41 83 1 1789007936 6553296 11599568
20:21:00 5777 8192000000 10715421136 11120214016 1762251568 17.703 98 43 87 1 1781137312 6529920 12355824
20:21:14 2844 8192000000 10695569632 11100200960 1758558480 17.672 99 45 88 0 1779734240 7044656 14131104
20:21:25 6678 8192000000 10694459072 11102052352 1760054432 17.685 99 33 66 1 1775865088 6260704 9549952
20:21:41 6326 8192000000 10718848432 11134877696 1784651920 17.888 99 26 52 1 1798518496 5848960 8017616
20:21:55 8558 8192000000 10717826384 11139940352 1773511904 17.796 98 25 50 2 1790904288 10683744 6708640
20:22:09 5317 8192000000 10719876880 11129257984 1792234160 17.950 99 27 54 1 1806077568 6442592 7400816
20:22:22 7336 8192000000 10735628256 11143110656 1793514720 17.961 99 41 80 1 1810964352 6182976 11266656
20:22:38 7314 8192000000 10714313184 11123662848 1739786928 17.517 96 29 59 3 1753186096 4570736 8828432
20:22:52 10636 8192000000 10757496752 11151196160 1789766656 17.930 99 23 46 0 1800787296 4976080 6044560
20:23:09 62145 8192000000 10772184736 11175641088 1832506880 18.280 100 48 96 2 1853587296 6965968 14114448
20:24:17 5680 8192000000 10742229920 11173965824 1834795488 18.298 100 28 56 1 1850164208 7772224 7596496
20:24:30 8758 8192000000 10756362720 11172679680 1821205488 18.188 99 29 58 0 1835417120 6166880 8044752
20:24:45 6312 8192000000 10749862496 11178885120 1844153600 18.375 100 36 72 6 1860580800 5762128 10665072
20:24:57 6862 8192000000 10752516768 11181293568 1845087776 18.382 100 34 68 1 1860273584 5341200 9844608
20:25:11 4657 8192000000 10775653888 11185827840 1846704176 18.395 100 31 62 0 1860981232 6097856 8179200
20:25:23 6345 8192000000 10771506992 11184246784 1842805008 18.364 100 25 48 0 1855869504 5746816 7317680
20:25:37 9969 8192000000 10768542304 11189952512 1849120912 18.415 100 30 61 0 1863632048 5193280 9317856
20:25:55 10560 8192000000 10764693216 11180306432 1828989248 18.251 99 27 55 2 1842109856 5531344 7589264
20:26:13 11729 8192000000 10771953024 11194871808 1847686992 18.403 100 32 64 0 1863198304 5165248 10346064
20:26:31 9715 8192000000 10769536128 11193118720 1836289616 18.311 99 30 60 3 1851241408 5943264 9008528
20:26:50 6944 8192000000 10767161680 11200151552 1859119296 18.496 100 37 74 1 1876828544 5985120 11724128
20:27:03 13983 8192000000 10800443904 11220946944 1876207760 18.634 100 41 81 2 1893415664 5607312 11600592
20:27:26 9826 8192000000 10838381520 11245207552 1892719136 18.768 100 63 122 2 1920992144 10767376 17505632
20:27:47 25364 8192000000 10834033552 11247456256 1897920736 18.810 100 43 85 3 1917534160 7976688 11636736
20:28:25 112919 8192000000 10831638336 11266170880 1906559024 18.879 100 37 73 2 1924820032 8053680 10207328
20:31:35 19984 8192000000 10858313632 11291340800 1934155456 19.100 100 39 78 3 1956334640 9931552 12247632
20:32:06 21248 8192000000 10873787632 11305418752 1939095120 19.140 100 45 89 3 1961591040 10178640 12317280
20:32:35 9292 8192000000 10882605856 11309211648 1947595968 19.207 100 51 103 1 1974250240 11789344 14864928
20:32:52 13586 8192000000 10892525776 11320942592 1956660608 19.279 100 52 104 1 1984252736 12931104 14661024
20:33:15 19780 8192000000 10892030288 11322892288 1940654688 19.152 99 53 107 1 1969498080 13429392 15414000
20:33:42 21877 8192000000 10896083920 11334332416 1957271872 19.284 100 31 62 0 1981236464 14554896 9409696
20:34:17 9983 8192000000 10908002288 11342483456 1974701552 19.423 100 52 105 0 2007472736 17052912 15718272
20:34:39 10326 8192000000 10924052592 11351924736 1977328880 19.444 100 57 114 1 2011752208 17797088 16626240
20:35:00 2260 8192000000 10933659760 11357495296 1982479520 19.484 100 64 126 1 2017233280 16685056 18068704
20:35:12 9075 8192000000 10934975584 11361288192 1987366608 19.523 100 74 146 1 2028152128 19826352 20959168
20:35:28 5220 8192000000 10941808656 11366051840 1988779344 19.534 100 70 140 0 2029510000 20845856 19884800
20:35:41 3690 8192000000 10950656096 11368939520 1991811040 19.558 100 78 157 0 2034305424 20222848 22271536
20:35:54 10655 8192000000 10956405072 11374555136 1996123504 19.592 100 77 154 0 2039994224 21938048 21932672
20:36:14 5618 8192000000 10942346880 11374166016 1996081392 19.592 100 62 124 2 2036329920 22342496 17906032
20:36:27 7067 8192000000 10950156880 11381989376 2001472016 19.634 100 62 124 2 2042286832 22120544 18694272
20:36:43 4510 8192000000 10944651888 11380469760 1982366080 19.483 99 57 114 3 2018612928 19336672 16910176
20:37:01 11042 8192000000 10933165632 11369377792 1981318464 19.475 99 61 122 3 2020309968 20248848 18742656
20:37:21 4925 8192000000 10945893664 11373244416 1991680816 19.557 100 58 116 1 2029687552 20275552 17731184
20:37:33 5338 8192000000 10955493424 11377680384 1996490384 19.595 100 70 140 0 2038898432 21480832 20927216
20:37:46 8944 8192000000 10953951920 11380441088 2001811808 19.637 100 78 151 2 2046562608 22691952 22058848
20:38:02 3713 8192000000 10956135808 11387355136 2002280976 19.641 100 66 130 0 2047114880 24890256 19943648
20:38:13 9441 8192000000 10960264240 11391750144 2002826736 19.645 100 65 130 0 2049050640 26457984 19765920
20:38:36 13818 8192000000 10954741408 11395014656 2007123760 19.679 100 54 108 2 2048329136 24880976 16324400
20:38:57 9028 8192000000 10949942384 11385188352 1983461296 19.492 99 55 106 3 2026465248 26451232 16552720
20:39:14 2796 8192000000 10963003024 11386871808 1987027280 19.520 99 75 150 0 2037484048 27668224 22788544
20:39:24 6087 8192000000 10954446096 11385253888 1997261360 19.601 100 63 125 0 2044969648 28486816 19221472
20:39:39 5836 8192000000 10967771424 11398029312 2004211600 19.656 100 63 126 0 2051861200 29081152 18568448
20:40:02 4434 8192000000 10959450032 11382444032 1991835056 19.558 99 75 150 0 2041884512 28163488 21885968
20:40:15 6262 8192000000 10967834752 11399647232 2008487920 19.690 100 64 126 3 2057471488 29750432 19233136
20:40:44 15870 8192000000 10975711888 11406868480 1997463008 19.603 99 58 116 1 2045230416 29854576 17912832
20:41:10 4635 8192000000 10981465264 11410927616 2015487712 19.745 100 62 121 1 2065518096 30859792 19170592
20:41:23 2074 8192000000 10981125824 11407036416 2013069344 19.726 100 72 141 1 2065482032 30261120 22151568
20:41:33 4469 8192000000 10971925360 11395354624 1991057840 19.552 99 72 143 2 2044080528 30597360 22425328
20:41:47 3597 8192000000 10976674080 11397328896 1998286560 19.609 100 72 143 1 2053199920 32301376 22611984
20:42:04 2617 8192000000 10981690656 11408150528 2005088000 19.663 100 67 132 0 2063029488 36609648 21331840
20:42:19 4498 8192000000 10974467600 11395391488 1986002016 19.512 99 72 141 1 2044223392 35840848 22380528
20:42:30 2879 8192000000 10966233248 11384700928 1975040864 19.425 99 72 143 0 2034363024 36431152 22891008
20:42:41 2270 8192000000 10981856400 11399479296 2001143008 19.632 100 84 167 1 2065200496 38848272 25209216
20:42:53 3883 8192000000 10985149488 11406041088 2006308272 19.672 100 83 164 2 2071263376 39969440 24985664
20:43:07 3084 8192000000 10992842800 11415465984 2012114768 19.718 100 72 144 0 2075514608 40741552 22658288
20:43:19 1807 8192000000 10979822128 11392266240 1975447536 19.429 98 80 160 0 2047073488 47492640 24133312
20:43:29 2460 8192000000 10992190928 11413839872 2005062112 19.663 100 87 173 1 2080351808 48810928 26478768
20:43:37 2058 8192000000 10999066224 11421016064 2009671296 19.699 100 81 162 1 2077235280 42919792 24644192
20:43:48 4133 8192000000 10984733168 11414716416 2006289936 19.672 100 71 141 1 2071736864 43455744 21991184
20:44:03 6812 8192000000 10942015312 11382276096 1967086672 19.362 99 42 84 2 2020554640 39346944 14121024
20:44:24 7622 8192000000 10953667392 11386478592 1978540496 19.453 100 50 100 0 2041099184 45550048 17008640
20:44:39 7118 8192000000 10938926944 11368140800 1964733696 19.344 100 57 114 2 2024375360 40806112 18835552
20:44:56 9391 8192000000 10937213520 11371114496 1954812736 19.265 99 44 90 2 2012171728 41788784 15570208
20:45:12 3571 8192000000 10944892592 11369717760 1949984816 19.226 99 64 130 0 2015932192 44220144 21727232
20:45:22 1794 8192000000 10948474256 11363631104 1957821744 19.289 100 79 157 1 2027445072 44216528 25406800
20:45:31 11836 8192000000 10915387424 11340947456 1929208848 19.061 99 57 113 0 1994837264 46231856 19396560
20:45:57 4539 8192000000 10943970576 11363360768 1951995328 19.242 100 73 144 3 2020242704 45910928 22336448
20:46:10 6252 8192000000 10930008128 11340824576 1936397472 19.118 99 77 155 3 2014337968 50936352 27004144
20:46:24 4582 8192000000 10946972368 11369168896 1954503056 19.262 100 73 145 1 2031885984 53362592 24020336
20:46:39 6212 8192000000 10945634400 11365392384 1948302768 19.213 100 71 142 2 2027377120 55839728 23234624
20:46:58 1403 8192000000 10944746032 11359928320 1939719584 19.145 99 81 167 3 2020122928 54154800 26248544
20:47:07 3384 8192000000 10969459456 11386986496 1968726400 19.375 100 82 163 1 2052233488 56825504 26681584
20:47:22 4653 8192000000 10965922176 11389366272 1968965984 19.377 100 72 146 2 2048385424 55808368 23611072
20:47:35 10348 8192000000 10949016208 11389767680 1963288944 19.332 100 60 119 2 2039701872 56294496 20118432
20:47:58 19142 8192000000 10928766800 11389599744 1964616768 19.343 100 28 56 3 2010873904 36792320 9464816
20:48:43 16078 8192000000 10903271712 11346026496 1899270240 18.820 97 27 54 3 1947710256 39463920 8976096
20:49:06 9330 8192000000 10890171632 11339067392 1902342352 18.845 98 26 52 1 1951114640 40517088 8255200
20:49:25 13916 8192000000 10889517472 11328139264 1893914944 18.777 98 30 58 1 1941053952 36992896 10146112
20:49:47 6891 8192000000 10895803936 11339661312 1933011056 19.091 100 34 67 0 1983795888 39723136 11061696
20:50:12 9257 8192000000 10930922544 11358453760 1942713008 19.168 100 40 80 0 1995652688 40219440 12720240
20:50:30 19854 8192000000 10881381616 11330592768 1884303760 18.700 97 24 48 4 1931119584 38566608 8249216
20:50:57 24438 8192000000 10881511760 11334397952 1903605648 18.855 99 21 41 2 1944290560 33657008 7027904
20:51:28 32161 8192000000 10875390528 11331702784 1892568544 18.766 98 24 48 1 1940662688 40354544 7739600
20:52:09 36660 8192000000 10857901888 11305701376 1852398400 18.442 97 19 38 0 1894046416 35052256 6595760
20:52:52 11041 8192000000 10864265120 11308404736 1884316896 18.700 99 32 63 3 1935391264 41006864 10067504
20:53:10 7877 8192000000 10845894416 11300974592 1889266960 18.740 100 16 32 1 1933560976 38984208 5309808
20:53:31 78560 8192000000 10829478240 11292192768 1820390624 18.181 96 10 20 0 1839417856 15813984 3213248
20:54:56 24535 8192000000 10824456224 11273560064 1863664960 18.533 98 13 27 2 1878075136 10600944 3809232
20:55:30 79842 8192000000 10811111120 11279245312 1853773072 18.453 98 10 20 1 1875603616 19083888 2746656
20:56:56 31734 8192000000 10851376032 11285331968 1891997536 18.762 99 40 76 1 1909571904 7905968 9668400
20:57:35 13829 8192000000 10816411296 11250872320 1837086896 18.317 96 40 78 3 1858522928 9843168 11592864
20:58:07 63994 8192000000 10828306272 11290169344 1889910960 18.745 99 21 42 2 1906074048 9972544 6190544
20:59:18 52483 8192000000 10845838064 11290001408 1886994256 18.722 98 24 48 0 1901930560 8576272 6360032
21:00:17 107767 8192000000 10854928032 11307319296 1890743488 18.752 98 26 52 1 1910031840 11877552 7410800
21:02:11 115638 8192000000 10871885120 11310391296 1899874960 18.825 99 11 20 0 1911250176 8812704 2562512
21:04:13 8668 8192000000 10875937808 11316318208 1906371440 18.878 98 38 76 3 1929741744 12426128 10944176
21:04:53 43605 8192000000 10875718656 11328020480 1940208544 19.148 100 34 68 1 1962287104 12007664 10070896
21:05:54 30482 8192000000 10879438128 11337105408 1949504400 19.223 100 40 79 2 1974099344 13048224 11546720
21:06:32 26009 8192000000 10888762496 11336630272 1930773104 19.073 99 18 36 2 1949594800 13107824 5713872
21:07:06 29300 8192000000 10877830640 11340664832 1928479040 19.055 99 16 32 0 1952149792 18026768 5643984
21:07:43 32923 8192000000 10876897264 11347517440 1948448576 19.214 100 6 12 0 1962856816 12528640 1879600
21:08:23 39643 8192000000 10878493808 11343876096 1955153072 19.267 100 17 35 3 1971984768 11100064 5731632
21:09:18 78694 8192000000 10885285456 11355250688 1960606640 19.311 100 8 16 1 1976105776 13558096 1941040
21:10:44 48591 8192000000 10882266688 11348320256 1944626512 19.184 99 11 21 0 1960908288 12793168 3488608
21:11:43 48210 8192000000 10880310368 11355033600 1961963200 19.322 100 11 22 0 1974770848 9701504 3106144
21:12:38 3887 8192000000 10880883760 11355799552 1964900624 19.345 100 11 22 2 1976186208 8317648 2967936
21:12:48 25045 8192000000 10889643088 11364270080 1971810624 19.400 100 15 30 0 1986788608 10941744 4036240
21:13:20 28411 8192000000 10887871792 11364687872 1954976736 19.266 99 8 16 0 1965940304 8720560 2243008
21:13:54 45615 8192000000 10896770544 11369238528 1974658608 19.422 100 18 36 0 1987519648 7466960 5394080
21:15:49 53172 8192000000 10902579760 11375718400 1979304368 19.459 100 14 28 0 1990696448 7722752 3669328
21:17:14 14668 8192000000 10925648400 11375079424 1969890720 19.385 99 38 75 0 1989966864 9413616 10662528
21:17:36 44478 8192000000 10921373488 11392303104 1990182768 19.545 100 22 44 1 2010563936 14079728 6301440
21:18:42 57314 8192000000 10942214672 11411959808 2003750352 19.652 100 26 52 1 2028605088 17095216 7759520
21:19:46 45255 8192000000 10937206800 11418226688 2004483744 19.658 100 19 38 2 2027624624 17059248 6081632
21:21:06 72203 8192000000 10928009072 11386155008 1958173376 19.292 98 20 40 1 1983986032 20100896 5711760
21:22:28 64316 8192000000 10917357120 11395280896 1990077392 19.544 100 11 22 0 2003929424 10857312 2994720
21:23:39 42141 8192000000 10935852304 11396952064 1956504288 19.278 98 32 63 3 1975676528 10163488 9008752
21:24:32 75363 8192000000 10919477184 11390550016 1934695376 19.104 97 14 28 2 1951296688 12801248 3800064
21:25:54 79947 8192000000 10894198880 11358797824 1885784816 18.712 95 14 28 0 1910881232 20857248 4239168
21:27:22 41515 8192000000 10892584000 11347841024 1900390704 18.829 97 17 34 2 1911924320 7261488 4272128
21:28:10 35312 8192000000 10930584448 11385966592 1973995760 19.417 100 46 92 1 2000113744 13660416 12457568
21:28:52 55284 8192000000 10879384224 11342098432 1898389808 18.813 96 19 38 2 1923481616 19590288 5501520
21:30:10 98264 8192000000 10846313616 11309531136 1873005040 18.609 96 13 26 1 1896052272 19254336 3792896
21:32:09 24770 8192000000 10890276208 11362545664 1956463712 19.278 100 25 50 0 1977795136 14598848 6732576
21:32:40 11349 8192000000 10887897744 11365691392 1957995360 19.290 100 21 42 1 1979574800 15550912 6028528
21:33:06 22180 8192000000 10862561584 11339923456 1916759120 18.961 98 9 18 0 1932693744 13620880 2313744
21:34:04 55757 8192000000 10864324512 11346710528 1898211408 18.812 97 8 16 1 1912524864 12191024 2122432
21:35:06 56336 8192000000 10862029888 11330064384 1912059520 18.923 98 8 16 0 1922353920 8030192 2264208
21:36:09 52578 8192000000 10862594864 11342594048 1931969408 19.083 99 15 29 2 1944788112 8210608 4608096
21:37:13 60882 8192000000 10843736928 11318620160 1850225136 18.424 95 21 42 0 1865606416 9118096 6263184
21:38:20 57106 8192000000 10844899216 11330207744 1910545232 18.911 99 18 36 2 1925495808 10083072 4867504
21:39:24 31280 8192000000 10857208144 11321765888 1922698224 19.008 99 5 10 0 1934359456 10780832 880400
21:40:03 44837 8192000000 10855973792 11322572800 1871983520 18.600 96 24 49 2 1885902256 7570160 6348576
21:40:54 17051 8192000000 10881723888 11336511488 1929680832 19.064 99 29 56 1 1944753088 6894256 8178000
21:41:21 35789 8192000000 10853859120 11311710208 1880076688 18.666 96 29 58 4 1897628496 8809808 8742000
21:42:03 49948 8192000000 10868991808 11328135168 1920547056 18.991 99 19 37 0 1935726240 9577856 5601328
21:43:04 42532 8192000000 10834412576 11312943104 1851336944 18.433 95 26 52 0 1866901632 8129120 7435568
21:44:03 30257 8192000000 10862573680 11314016256 1894060480 18.778 98 33 66 0 1911165024 7991360 9113184
21:44:52 25715 8192000000 10868399456 11316043776 1881578656 18.678 97 43 85 0 1906412832 12914832 11919344
21:45:29 38949 8192000000 10844405776 11322368000 1898813424 18.817 99 42 85 1 1928705280 18022720 11869136
21:46:31 39332 8192000000 10876961904 11336577024 1917719360 18.969 99 17 34 1 1934066032 11650912 4695760
21:47:17 38581 8192000000 10880852560 11341463552 1915433408 18.950 98 34 68 0 1938757024 13511408 9812208
21:48:17 48455 8192000000 10866706864 11347521536 1902587920 18.847 98 16 32 2 1923418432 16302768 4527744
21:49:12 49085 8192000000 10868660064 11322122240 1845899104 18.389 95 12 24 0 1858712688 9363376 3450208
21:50:09 15421 8192000000 10871060240 11325022208 1929365712 19.062 100 41 83 0 1952518672 11064064 12088896
21:50:41 22144 8192000000 10878582336 11320856576 1900341280 18.829 98 36 72 1 1920040688 9981008 9718400
21:51:12 17658 8192000000 10882139072 11334848512 1945106064 19.187 100 52 102 3 1972161808 12431008 14624736
21:51:45 40800 8192000000 10864270304 11322638336 1881029728 18.673 97 22 44 2 1901456576 14300480 6126368
21:52:36 98177 8192000000 10842912768 11306979328 1887272272 18.724 98 16 32 1 1907045776 15592880 4180624
21:55:14 10176 8192000000 10849027456 11307573248 1921589008 19.000 100 28 55 1 1937429104 7914208 7925888
21:55:30 34402 8192000000 10852252480 11317338112 1929928560 19.066 100 15 30 0 1941668256 7625472 4114224
21:56:14 67522 8192000000 10868401536 11347107840 1949103312 19.219 100 21 42 1 1965516224 10575008 5837904
21:57:28 52626 8192000000 10877566128 11362160640 1956650320 19.279 100 7 14 0 1970393088 11918512 1824256
21:58:30 32188 8192000000 10877839088 11367976960 1958398096 19.293 100 5 10 0 1972876048 13318368 1159584
21:59:30 72656 8192000000 10895349056 11370930176 1951426688 19.238 99 9 18 1 1960219488 6611104 2181696
22:00:49 63070 8192000000 10918967616 11390066688 1964586576 19.342 99 14 28 1 1976100864 7979664 3534624
22:01:58 51035 8192000000 10920192624 11389673472 1958678976 19.296 98 18 36 0 1977634896 13959984 4995936
22:02:55 52172 8192000000 10911274224 11395682304 1966434640 19.357 99 20 40 2 1989487744 17215248 5837856
22:03:58 64986 8192000000 10930460048 11396337664 1989491472 19.540 100 18 36 1 2007472048 12866208 5114368
22:05:14 27943 8192000000 10949538928 11400400896 2004576512 19.659 100 53 101 0 2026959120 7215728 15166880
22:05:50 32066 8192000000 10927711200 11384885248 1991088400 19.552 100 33 66 0 2008804272 9201120 8514752
22:06:31 33457 8192000000 10927227552 11387346944 1980471392 19.468 99 38 75 4 2004000320 13203280 10325648
22:07:18 69793 8192000000 10892215680 11359531008 1933457168 19.095 97 27 54 1 1955535488 14990096 7088224
22:08:37 60936 8192000000 10929854768 11381637120 1950043648 19.227 98 33 67 1 1971743888 12293632 9406608
22:10:29 80992 8192000000 10891611104 11373318144 1913370464 18.934 97 10 20 1 1934187136 17431552 3385120
22:12:01 154492 8192000000 10910701616 11370442752 1833596912 18.289 93 11 21 0 1847525200 11039072 2889216
22:14:46 105127 8192000000 10859305120 11334758400 1931328528 19.077 98 33 66 0 1950633344 8854720 10450096
22:16:37 37160 8192000000 10900362704 11356909568 1957305824 19.285 99 30 60 2 1972491616 6217760 8968032
22:17:21 91358 8192000000 10899365776 11381571584 1977790736 19.447 100 20 40 1 1995516688 12337376 5388576
22:20:40 39672 8192000000 10904174400 11385860096 1952795728 19.249 98 18 37 2 1970004256 11770320 5438208
22:21:25 43355 8192000000 10921180496 11400380416 1992068656 19.560 100 17 34 1 2009820864 12951984 4800224
22:22:21 78677 8192000000 10899324176 11365212160 1913091744 18.931 96 21 41 0 1933284016 14001488 6190784
22:23:49 75597 8192000000 10872888048 11342024704 1815741648 18.143 92 12 24 0 1840556144 21323536 3490960
22:25:10 48090 8192000000 10850591616 11312963584 1889369680 18.741 97 18 36 1 1902451088 8077104 5004304
22:26:36 50201 8192000000 9374167488 9658097664 524244032 6.014 28 2 4 0 528852848 4190448 418368

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 29-12-2020 22:28:34 to 29-12-2020 22:29:06.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-12-2020 22:29:07 to 29-12-2020 22:29: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          240684
MON$OLDEST_ACTIVE               240685
MON$OLDEST_SNAPSHOT             240685
MON$NEXT_TRANSACTION            240685
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                       2008960
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:80: 
:81: mscs-test-161.budzdorov.ru    Tue Dec 29 22:27:31 2020
:82:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:83: 
:84: 
:85: mscs-test-161.budzdorov.ru    Tue Dec 29 22:27:31 2020
:86:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:87: 
--- end of diff output ---

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

29.12.20 22:29: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-29 22:29:13 No severe PSQL-related problems occured
29.12.20 22:29:14. End of report.