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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-31 19:27:13
DTS_END                         2021-01-31 19:27:13.9490
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57910
TRN_ID                          237419
ATT_ID                          633
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: 9021.54 20297 1082585
customer order: creation 166.38 364 19966
customer order: refuse 14.46 309 1735
order to supplier: creation 44.58 1214 5349
order to supplier: removal 3.29 111915 395
invoice (draft): creation 43.80 3168 5256
invoice (draft): removal 52.88 766 6345
invoice accept: apply 39.36 18291 4723
invoice accept: cancel 47.60 755 5712
customer reserve: creation 3676.42 178 441170
customer reserve: removal 4639.88 62 556785
realization accept: apply 81.99 208 9839
realization accept: cancel 86.78 117 10414
payment from customer: creation 56.92 173 6830
payment from customer: removal 5.12 147 614
payment to supplier: creation 46.76 168 5611
payment to supplier: removal 3.26 114 391
service: total inventory turnovers 4.52 1119 542
service: total monetary turnovers 6.84 22 821
service: aggregate perf. data 0.69 23618 83
service: refresh index statistics 0.03 243230 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-01-2021 19:28:44 to 31-01-2021 19:28:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8545
TEST_TIME 2 5467
TEST_TIME 3 4893
TEST_TIME 4 4638
TEST_TIME 5 4955
TEST_TIME 6 4690
TEST_TIME 7 4660
TEST_TIME 8 4916
TEST_TIME 9 5078
TEST_TIME 10 5208
TEST_TIME 11 5542
TEST_TIME 12 5787
TEST_TIME 13 5769
TEST_TIME 14 6077
TEST_TIME 15 6740
TEST_TIME 16 6980
TEST_TIME 17 7064
TEST_TIME 18 7215
TEST_TIME 19 7570
TEST_TIME 20 8074
TEST_TIME 21 8651
TEST_TIME 22 8646
TEST_TIME 23 8980
TEST_TIME 24 9133
TEST_TIME 25 9074
TEST_TIME 26 9665
TEST_TIME 27 9794
TEST_TIME 28 10567
TEST_TIME 29 10669
TEST_TIME 30 10611
TEST_TIME 31 10372
TEST_TIME 32 10292
TEST_TIME 33 10182
TEST_TIME 34 10178
TEST_TIME 35 10210
TEST_TIME 36 10193
TEST_TIME 37 10004
TEST_TIME 38 9986
TEST_TIME 39 9856
TEST_TIME 40 9744
TEST_TIME 41 9682
TEST_TIME 42 9589
TEST_TIME 43 9581
TEST_TIME 44 9638
TEST_TIME 45 9581
TEST_TIME 46 9603
TEST_TIME 47 9437
TEST_TIME 48 9376
TEST_TIME 49 9351
TEST_TIME 50 9319
TEST_TIME 51 9270
TEST_TIME 52 9155
TEST_TIME 53 9263
TEST_TIME 54 9337
TEST_TIME 55 9405
TEST_TIME 56 9366
TEST_TIME 57 9345
TEST_TIME 58 9390
TEST_TIME 59 9370
TEST_TIME 60 9326
TEST_TIME 61 9467
TEST_TIME 62 9439
TEST_TIME 63 9445
TEST_TIME 64 9443
TEST_TIME 65 9404
TEST_TIME 66 9312
TEST_TIME 67 9272
TEST_TIME 68 9227
TEST_TIME 69 9176
TEST_TIME 70 9143
TEST_TIME 71 9112
TEST_TIME 72 9109
TEST_TIME 73 9027
TEST_TIME 74 9078
TEST_TIME 75 9107
TEST_TIME 76 9102
TEST_TIME 77 9062
TEST_TIME 78 9077
TEST_TIME 79 9201
TEST_TIME 80 9170
TEST_TIME 81 9233
TEST_TIME 82 9211
TEST_TIME 83 9258
TEST_TIME 84 9399
TEST_TIME 85 9357
TEST_TIME 86 9326
TEST_TIME 87 9261
TEST_TIME 88 9241
TEST_TIME 89 9213
TEST_TIME 90 9175
TEST_TIME 91 9164
TEST_TIME 92 9153
TEST_TIME 93 9152
TEST_TIME 94 9179
TEST_TIME 95 9141
TEST_TIME 96 9112
TEST_TIME 97 9111
TEST_TIME 98 9201
TEST_TIME 99 9161
TEST_TIME 100 9148
TEST_TIME 101 9231
TEST_TIME 102 9197
TEST_TIME 103 9279
TEST_TIME 104 9240
TEST_TIME 105 9259
TEST_TIME 106 9297
TEST_TIME 107 9334
TEST_TIME 108 9330
TEST_TIME 109 9266
TEST_TIME 110 9230
TEST_TIME 111 9192
TEST_TIME 112 9194
TEST_TIME 113 9165
TEST_TIME 114 9158
TEST_TIME 115 9147
TEST_TIME 116 9121
TEST_TIME 117 9068
TEST_TIME 118 9107
TEST_TIME 119 9087
TEST_TIME 120 9024

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 31-01-2021 19:28:48 to 31-01-2021 19:28:51.

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 1491698 1491698 0 0.00 0 24608 7 0 0
doc_list_biud 1491697 1491697 0 0.00 0 61949 29 0 0
sp_add_invoice_to_stock 4849 4723 126 2.59 50 162290 18291 0 126
sp_cancel_adding_invoice 5712 5712 0 0.00 5 72520 756 0 0
sp_cancel_client_order 1735 1735 0 0.00 4 11919 309 0 0
sp_cancel_customer_reserve 556785 556785 0 0.00 1 61955 63 0 0
sp_cancel_pay_from_customer 614 614 0 0.00 2 9275 147 0 0
sp_cancel_pay_to_supplier 391 391 0 0.00 3 6399 114 0 0
sp_cancel_supplier_invoice 6355 6345 10 0.15 1 24080 767 0 10
sp_cancel_supplier_order 395 395 0 0.00 6 968769 111916 0 0
sp_cancel_write_off 10414 10414 0 0.00 1 17988 118 0 0
sp_client_order 19966 19966 0 0.00 3 29936 364 0 0
sp_customer_reserve 441170 441170 0 0.00 0 56675 178 0 0
sp_fill_shopping_cart 30569 30569 0 0.00 1 9658 36 0 0
sp_fill_shopping_cart_clo_res 441166 441166 0 0.00 0 30877 15 0 0
sp_get_clo_for_invoice 4718 4718 0 0.00 0 33259 343 0 0
sp_kill_cost_storno 17131 17131 0 0.00 0 20478 64 0 0
sp_kill_qstorno_ret_qs2qd 1130724 1130724 0 0.00 0 61947 33 0 0
sp_kill_qty_storno 595943 595943 0 0.00 0 61949 72 0 0
sp_lock_selected_doc 20023 20023 0 0.00 0 7392 7 0 0
sp_make_cost_storno 26998 26998 0 0.00 0 24595 60 0 0
sp_multiply_rows_for_pdistr 26998 26998 0 0.00 0 17499 42 0 0
sp_multiply_rows_for_qdistr 19966 19966 0 0.00 0 29931 172 0 0
sp_pay_from_customer 6830 6830 0 0.00 4 31547 173 0 0
sp_pay_to_supplier 5611 5611 0 0.00 5 19811 168 0 0
sp_payment_common 12441 12441 0 0.00 2 31450 52 0 0
sp_qd_handle_on_cancel_clo 1735 1735 0 0.00 0 11894 286 0 0
sp_qd_handle_on_invoice_upd_sts 10430 10430 0 0.00 0 21149 330 0 0
sp_qd_handle_on_reserve_upd_sts 9839 9839 0 0.00 0 21031 56 0 0
sp_reserve_write_off 9839 9839 0 0.00 6 22483 209 0 0
sp_supplier_invoice 5256 5256 0 0.00 5 70493 3168 0 0
sp_supplier_order 5349 5349 0 0.00 5 32792 1215 0 0
srv_aggregate_perf_data 83 83 0 0.00 2754 276978 23619 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1005 139370 32807 0 0
srv_find_qd_qs_mism 1037099 1037099 0 0.00 0 11143 5 0 0
srv_make_invnt_saldo 542 542 0 0.00 39 40126 1119 0 0
srv_make_money_saldo 821 821 0 0.00 1 484 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 145161 433999 243231 0 0
t$perf-abend:sp_add_invoice_to_stock 126 126 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 4723 4723 0 0.00 0 15205 174 0 0
t$perf-norm:sp_cancel_adding_invoice 375 375 0 0.00 0 3992 103 0 0
t$perf-norm:sp_cancel_client_order 1735 1735 0 0.00 0 9721 19 0 0
t$perf-norm:sp_cancel_customer_reserve 646 646 0 0.00 0 1488 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 614 614 0 0.00 0 2766 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 391 391 0 0.00 0 2876 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 1995 17 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 20960 1842 0 0
t$perf-norm:sp_cancel_write_off 919 919 0 0.00 0 7051 17 0 0
t$perf-norm:sp_client_order 19966 19966 0 0.00 0 15410 18 0 0
t$perf-norm:sp_customer_reserve 952 952 0 0.00 0 7310 16 0 0
t$perf-norm:sp_pay_from_customer 6830 6830 0 0.00 0 8552 14 0 0
t$perf-norm:sp_pay_to_supplier 5611 5611 0 0.00 0 16239 15 0 0
t$perf-norm:sp_reserve_write_off 9839 9839 0 0.00 0 8755 18 0 0
t$perf-norm:sp_supplier_invoice 5256 5256 0 0.00 0 15324 19 0 0
t$perf-norm:sp_supplier_order 5349 5349 0 0.00 0 6497 18 0 0
t$perf-norm:srv_aggregate_perf_data 83 83 0 0.00 0 256 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 3231 35 0 0
t$perf-norm:srv_make_invnt_saldo 542 542 0 0.00 0 2311 27 0 0
t$perf-norm:srv_make_money_saldo 821 821 0 0.00 0 1383 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 9688 9436 252 2.60 0 18651 22 0 252
v_all_customers 36186 36186 0 0.00 0 80 1 0 0
v_all_suppliers 29514 29514 0 0.00 0 16 1 0 0
v_all_wares 39932 39932 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 750 750 0 0.00 0 20812 38 0 0
v_cancel_client_order 3470 3470 0 0.00 0 2887 5 0 0
v_cancel_customer_prepayment 1228 1228 0 0.00 0 6613 32 0 0
v_cancel_customer_reserve 1292 1292 0 0.00 0 1677 6 0 0
v_cancel_payment_to_supplier 782 782 0 0.00 0 3690 12 0 0
v_cancel_supplier_invoice 802 782 20 2.49 0 550 16 0 20
v_cancel_supplier_order 790 790 0 0.00 0 421 3 0 0
v_cancel_write_off 1838 1838 0 0.00 0 6978 17 0 0
v_max_id_clo_ord 5349 5349 0 0.00 0 2885 2 0 0
v_max_id_clo_res 952 952 0 0.00 0 9587 43 0 0
v_max_id_ord_sup 5254 5254 0 0.00 0 6247 6 0 0
v_max_non_paid_invoice 1457 1457 0 0.00 0 861 3 0 0
v_max_non_paid_realizn 3709 3709 0 0.00 0 1997 5 0 0
v_min_id_clo_ord 5349 5349 0 0.00 0 2734 7 0 0
v_min_id_clo_res 952 952 0 0.00 0 2272 5 0 0
v_min_id_ord_sup 5254 5254 0 0.00 0 3630 5 0 0
v_min_non_paid_invoice 5611 5611 0 0.00 0 16413 34 0 0
v_min_non_paid_realizn 6830 6830 0 0.00 0 15737 40 0 0
v_our_firm 9988 9988 0 0.00 0 22 1 0 0
v_reserve_write_off 19678 19678 0 0.00 0 22390 11 0 0
x_lock_depdocs_on_canc_invoice 11666 11666 0 0.00 0 23709 124 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 7560 409 0 0
x_make_qstorno_1000_1200 5349 5349 0 0.00 2 32783 1134 0 0
x_make_qstorno_1200_2000 5256 5256 0 0.00 2 67428 3042 0 0
x_make_qstorno_2100_3300 441170 441170 0 0.00 0 56674 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-01-2021 19:28:52 to 31-01-2021 19:28:56.

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:17 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:23 7812 8192000000 10113084208 10402521088 801580400 8.912 65 48 98 0 824670656 6594544 16495712
16:57:39 40117 8192000000 10339838608 10651418624 1372190688 14.347 100 86 172 0 1405422592 4741024 28490880
16:58:32 22883 8192000000 10374595024 10694045696 1415893936 14.736 100 89 177 1 1452315584 6758128 29663520
16:59:07 16397 8192000000 10392316160 10713980928 1443332960 14.979 100 87 173 0 1479711216 7714848 28663408
16:59:32 12075 8192000000 10406374000 10732625920 1461095536 15.136 100 87 174 0 1497510816 8165920 28249360
16:59:58 12800 8192000000 10414518992 10743943168 1473958448 15.248 100 92 184 0 1512912816 8455632 30498736
17:00:19 16961 8192000000 10426598192 10758496256 1485337152 15.348 100 85 170 0 1521407008 8711616 27358240
17:00:51 16061 8192000000 10449201456 10785665024 1504875088 15.519 100 86 172 0 1541182288 9108320 27198880
17:01:19 24219 8192000000 10492243872 10837295104 1540794608 15.830 100 87 174 1 1577811696 10288112 26728976
17:01:54 14196 8192000000 10525491984 10873868288 1579908672 16.167 100 89 179 1 1619036528 11593232 27534624
17:02:18 18511 8192000000 10555020480 10906730496 1600070592 16.340 100 75 150 2 1634420416 11628160 22721664
17:02:47 12228 8192000000 10575937728 10936291328 1632911648 16.620 100 78 156 0 1668754720 12617552 23225520
17:03:07 11242 8192000000 10592823024 10953994240 1651123440 16.774 100 79 159 1 1686877536 12533632 23220464
17:03:26 10300 8192000000 10616124656 10975752192 1669278272 16.927 100 78 155 0 1703648016 11537328 22832416
17:03:44 5857 8192000000 10624194944 10995310592 1683895408 17.050 100 73 147 3 1717388496 11722432 21770656
17:03:59 9286 8192000000 10622211072 10999357440 1694176752 17.136 100 71 140 3 1725748416 11188944 20382720
17:04:15 6932 8192000000 10645469392 11019476992 1711476400 17.281 100 83 166 0 1746464864 11035568 23952896
17:04:30 7303 8192000000 10656837552 11032494080 1720880960 17.360 100 84 167 1 1757005664 12302224 23822480
17:04:46 7053 8192000000 10671675824 11049168896 1733281680 17.463 100 68 136 1 1763191504 11309984 18599840
17:05:01 5923 8192000000 10693679408 11068432384 1750595712 17.607 100 84 167 1 1786829552 12572592 23661248
17:05:14 6179 8192000000 10705316224 11081183232 1757623840 17.665 100 84 170 0 1794866720 13320032 23922848
17:05:27 4874 8192000000 10718820896 11093831680 1767424128 17.746 100 81 163 0 1802927504 13232336 22271040
17:05:39 10832 8192000000 10712582400 11101708288 1783273680 17.876 100 77 154 0 1818326960 13754096 21299184
17:05:57 5116 8192000000 10741131184 11122302976 1789876112 17.931 100 74 146 2 1824200656 12931616 21392928
17:06:09 3131 8192000000 10750068768 11133554688 1811880944 18.111 100 84 168 1 1853336320 17967968 23487408
17:06:18 3435 8192000000 10769808288 11153268736 1822026912 18.194 100 91 183 1 1862461120 14222480 26211728
17:06:28 2818 8192000000 10770320640 11157491712 1826335888 18.229 100 86 170 3 1865632688 15415600 23881200
17:06:38 3214 8192000000 10775334400 11163504640 1833452224 18.287 100 89 177 2 1874234704 15707072 25075408
17:06:48 2637 8192000000 10774641520 11163942912 1835230176 18.302 100 80 159 0 1870520880 13295168 21995536
17:06:57 2284 8192000000 10787222128 11174215680 1842662736 18.362 100 91 184 0 1882412880 13687936 26062208
17:07:06 2499 8192000000 10786907536 11174158336 1849617056 18.419 100 93 185 2 1889287744 14146960 25523728
17:07:15 1850 8192000000 10800044736 11183767552 1853063392 18.447 100 90 180 1 1892145328 14286736 24795200
17:07:24 2586 8192000000 10808028224 11193319424 1857985248 18.487 100 96 188 2 1899480160 15015808 26479104
17:07:33 1735 8192000000 10804074528 11193614336 1862130016 18.521 100 92 184 3 1902403392 13972064 26301312
17:07:41 1378 8192000000 10810804464 11200012288 1870374688 18.587 100 92 185 0 1910923600 14464496 26084416
17:07:49 1935 8192000000 10814376864 11202211840 1866961056 18.560 100 94 185 0 1908634864 14910768 26763040
17:07:57 1367 8192000000 10815819840 11204984832 1868221936 18.570 100 91 183 0 1908133488 13508272 26403280
17:08:05 4160 8192000000 10815319744 11203035136 1868969136 18.576 100 91 181 0 1908600608 13125424 26506048
17:08:15 1443 8192000000 10817035600 11207151616 1869942544 18.584 100 90 182 0 1909198128 12276336 26979248
17:08:24 6042 8192000000 10776022704 11189944320 1869450192 18.580 100 70 139 1 1899834208 10655632 19728384
17:08:39 27027 8192000000 10790075456 11197181952 1867586848 18.565 100 39 78 2 1885065696 5918544 11560304
17:09:12 14704 8192000000 10803122960 11203141632 1870407408 18.588 100 63 128 1 1901531568 12289264 18834896
17:09:33 23349 8192000000 10772006976 11204722688 1872597824 18.605 100 39 78 1 1892645136 8830544 11216768
17:10:03 2972 8192000000 10797332288 11211972608 1876013072 18.633 100 57 115 1 1898890608 5234544 17642992
17:10:13 5571 8192000000 10790863104 11213864960 1874449424 18.620 100 31 62 2 1890693072 7597504 8646144
17:10:26 5466 8192000000 10789973456 11219632128 1877788640 18.647 100 39 78 1 1901808592 12835472 11184480
17:10:38 3272 8192000000 10802906832 11219456000 1881923584 18.681 100 47 92 3 1902050400 6464992 13661824
17:10:50 4706 8192000000 10792149600 11217870848 1883173248 18.691 100 22 45 0 1896326400 6148144 7005008
17:11:03 6074 8192000000 10796320240 11223748608 1885443408 18.709 100 29 58 0 1900153408 6824464 7885536
17:11:17 4321 8192000000 10793587584 11223248896 1887941824 18.729 100 27 52 2 1901926176 6662576 7321776
17:11:28 5479 8192000000 10802040608 11225231360 1888981632 18.738 100 26 52 1 1902235712 6003312 7250768
17:11:42 9574 8192000000 10805714256 11230494720 1889160144 18.739 100 24 47 2 1901408192 5064416 7183632
17:12:02 11327 8192000000 10797905680 11229593600 1891905792 18.761 100 26 52 2 1905663680 6488832 7269056
17:12:20 4750 8192000000 10804578320 11236114432 1894933360 18.786 100 30 60 0 1913345792 10093216 8319216
17:12:32 7379 8192000000 10804942016 11235610624 1895864288 18.793 100 19 38 0 1907085552 6015760 5205504
17:12:45 7592 8192000000 10802726464 11237376000 1897717952 18.808 100 20 39 1 1909827328 6320912 5788464
17:12:59 8545 8192000000 10802109072 11238514688 1898277008 18.812 100 16 33 0 1908667056 5471648 4918400
17:13:14 15909 8192000000 10815189392 11245268992 1905670096 18.872 100 27 54 0 1919466016 5968208 7827712
17:13:37 39706 8192000000 10824768112 11250810880 1905480080 18.870 100 20 40 0 1921112416 10046288 5586048
17:14:30 14930 8192000000 10863081664 11266211840 1914627968 18.944 100 71 144 0 1941351024 5517264 21205792
17:14:51 6770 8192000000 10816696496 11252584448 1905920064 18.874 100 41 82 1 1926176624 8976768 11279792
17:15:06 5710 8192000000 10820203616 11247566848 1886207984 18.715 99 21 42 1 1898140128 5572384 6359760
17:15:21 5873 8192000000 10818076384 11254738944 1904197200 18.860 100 21 42 0 1916885088 6617760 6070128
17:15:33 5194 8192000000 10841245808 11260440576 1906372800 18.878 100 19 38 0 1917505504 5701664 5431040
17:15:45 5337 8192000000 10830934352 11264565248 1913625056 18.936 100 30 58 1 1929081840 6846608 8610176
17:15:59 6234 8192000000 10831966144 11266924544 1915857712 18.954 100 23 44 3 1928334560 6100160 6376688
17:16:13 8551 8192000000 10836176880 11267493888 1902138832 18.843 99 23 46 1 1915109632 6131120 6839680
17:16:29 6981 8192000000 10827276288 11267760128 1919272896 18.981 100 20 40 0 1930505024 5592560 5639568
17:16:42 8087 8192000000 10810870320 11243524096 1879985552 18.665 98 20 38 2 1890336368 5149008 5201808
17:16:57 5791 8192000000 10783784080 11222597632 1844879664 18.381 97 27 54 1 1858592704 5902368 7810672
17:17:10 10495 8192000000 10804590624 11232694272 1875666160 18.630 99 26 52 1 1889075232 5635264 7773808
17:17:28 9866 8192000000 10794435536 11226398720 1845340832 18.384 97 32 64 0 1865531152 11018128 9172192
17:17:44 7647 8192000000 10778619600 11204399104 1834093440 18.293 98 20 40 1 1844892800 5361808 5437552
17:17:59 55523 8192000000 10753444480 11182972928 1784320768 17.885 95 32 65 1 1799070176 5332624 9416784
17:19:00 5194 8192000000 10730844256 11157389312 1770053536 17.767 96 26 51 5 1783678704 5671920 7953248
17:19:13 5768 8192000000 10738480896 11159011328 1796241504 17.983 98 33 66 1 1812355680 6915424 9198752
17:19:26 6743 8192000000 10717492240 11138482176 1766965824 17.742 97 39 80 0 1783994928 5735520 11293584
17:19:39 5796 8192000000 10724600576 11139125248 1805026176 18.055 99 45 90 1 1824993200 6869152 13097872
17:19:51 3698 8192000000 10755163600 11167629312 1813727584 18.126 99 32 64 2 1829656592 5796880 10132128
17:20:02 7952 8192000000 10712750416 11120975872 1677466672 16.996 92 42 84 4 1696494272 6059952 12967648
17:20:16 6253 8192000000 10683242208 11085291520 1689955888 17.101 95 29 58 0 1703343088 5199360 8187840
17:20:29 7141 8192000000 10689467376 11107704832 1734816496 17.476 97 36 72 3 1751351216 6416928 10117792
17:20:43 7111 8192000000 10710190848 11128061952 1784549488 17.887 99 22 44 1 1795957024 5110976 6296560
17:20:57 3358 8192000000 10725136256 11134124032 1767537616 17.747 98 32 64 2 1783452128 5166400 10748112
17:21:10 11442 8192000000 10696803520 11110756352 1715701280 17.316 95 19 38 1 1730561056 9480096 5379680
17:21:28 7047 8192000000 10704776480 11122294784 1764096640 17.718 98 25 50 0 1777925728 5753504 8075584
17:21:41 8997 8192000000 10734256592 11153608704 1811073664 18.105 100 25 50 1 1828431552 9728928 7628960
17:21:57 9827 8192000000 10730479408 11150508032 1799568560 18.010 99 20 40 1 1810284672 5160576 5555536
17:22:17 11992 8192000000 10747390112 11165790208 1823619248 18.207 100 32 65 0 1839062592 5676544 9766800
17:22:35 62030 8192000000 10767374752 11183984640 1841254160 18.351 100 40 79 2 1859609136 5348656 13006320
17:23:47 16957 8192000000 10756393344 11181514752 1839308752 18.335 100 29 58 1 1853180064 5919920 7951392
17:24:12 6587 8192000000 10761466768 11189493760 1848554448 18.410 100 35 68 4 1865086768 6881344 9650976
17:24:26 6001 8192000000 10763357760 11189395456 1849998448 18.422 100 23 46 2 1862971008 6276912 6695648
17:24:38 6458 8192000000 10773034000 11201495040 1859113232 18.496 100 37 75 0 1877462512 7389760 10959520
17:24:53 4364 8192000000 10784400768 11205234688 1863315936 18.530 100 40 82 0 1879917200 5137280 11463984
17:25:06 7368 8192000000 10775788528 11201900544 1859103856 18.496 100 16 31 2 1868474544 4705584 4665104
17:25:20 7025 8192000000 10775500144 11207380992 1866050864 18.552 100 32 64 0 1881156848 5317744 9788240
17:25:35 7050 8192000000 10777214208 11209117696 1865748592 18.550 100 20 40 1 1878097360 6514624 5834144
17:25:48 7477 8192000000 10784149920 11210764288 1867967968 18.568 100 30 60 2 1883123488 5405616 9749904
17:26:05 13491 8192000000 10791984144 11217612800 1870093728 18.585 100 27 55 0 1883973424 5930000 7949696
17:26:24 5769 8192000000 10793007104 11222798336 1874359072 18.620 100 21 43 0 1886504752 5891152 6254528
17:26:40 7634 8192000000 10786556048 11217768448 1872780256 18.607 100 17 32 2 1882942976 5233712 4929008
17:26:53 16897 8192000000 10793269024 11227025408 1864992720 18.544 99 16 32 3 1874948800 5388384 4567696
17:27:18 14615 8192000000 10831785360 11249844224 1899057456 18.819 100 31 61 0 1912021312 4545104 8418752
17:27:41 15396 8192000000 10846841008 11264741376 1911741760 18.921 100 42 84 2 1929864752 6497808 11625184
17:28:03 4750 8192000000 10852306432 11272867840 1921896992 19.002 100 60 120 0 1947776224 8738944 17140288
17:28:15 92523 8192000000 10850571632 11282415616 1930496384 19.071 100 38 76 0 1948713808 6856576 11360848
17:29:55 19179 8192000000 10866271472 11297292288 1936104768 19.116 100 39 78 1 1959790080 12471248 11214064
17:30:23 7378 8192000000 10862774592 11294908416 1924754528 19.025 99 52 101 2 1948591520 8605120 15231872
17:30:47 43025 8192000000 10872755616 11312144384 1946453072 19.198 100 33 66 0 1967444288 10850528 10140688
17:31:49 9692 8192000000 10885141584 11323604992 1956319120 19.277 100 36 71 1 1981858688 14711760 10827808
17:32:10 31949 8192000000 10890132752 11327614976 1964174336 19.339 100 34 68 0 1988179520 14043088 9962096
17:32:55 26854 8192000000 10906801936 11342024704 1969998352 19.385 100 40 80 0 1997317264 15379840 11939072
17:33:31 13961 8192000000 10910517904 11349356544 1978350944 19.452 100 37 74 0 2004755856 14817552 11587360
17:33:53 8579 8192000000 10927187584 11356958720 1984981472 19.504 100 51 100 2 2015603584 16424256 14197856
17:34:15 21237 8192000000 10924631936 11355283456 1980143632 19.466 100 50 100 0 2014255024 19498896 14612496
17:34:51 11039 8192000000 10923442032 11354472448 1978562576 19.453 100 45 90 1 2011697552 20045104 13089872
17:35:13 10326 8192000000 10926192800 11361636352 1983737888 19.494 100 43 86 0 2016740592 19853408 13149296
17:35:34 10386 8192000000 10911491552 11343376384 1962360320 19.325 99 58 116 1 1998175456 18606032 17209104
17:35:53 6190 8192000000 10924972272 11353538560 1979106656 19.458 100 51 102 0 2013317824 19172208 15038960
17:36:06 2537 8192000000 10941581840 11365408768 1986204384 19.514 100 66 130 3 2026423600 19753600 20465616
17:36:17 16967 8192000000 10944584224 11371446272 1992950464 19.567 100 66 130 1 2034318512 21807600 19560448
17:36:45 4954 8192000000 10945677232 11377127424 1992916048 19.567 100 59 118 1 2036527536 25129536 18481952
17:36:58 11289 8192000000 10945593888 11381493760 1997582768 19.604 100 58 116 1 2039200608 24096160 17521680
17:37:19 17514 8192000000 10931626112 11369103360 1983978960 19.496 99 58 116 1 2023843712 22241376 17623376
17:38:15 5773 8192000000 10946553952 11381796864 1983907904 19.496 99 60 116 2 2025094048 23608432 17577712
17:38:30 3847 8192000000 10950831856 11372507136 1994058512 19.576 100 64 122 0 2035274112 22629040 18586560
17:38:47 4849 8192000000 10952643552 11381641216 1997184464 19.601 100 56 112 0 2039503904 25768416 16551024
17:39:02 12605 8192000000 10940917760 11381235712 1981772624 19.479 99 47 93 0 2020785232 24817712 14194896
17:39:22 3139 8192000000 10948496208 11385081856 2000391552 19.626 100 53 104 2 2038243280 22481856 15369872
17:39:32 1618 8192000000 10974629952 11399499776 2013191392 19.727 100 81 161 0 2061237408 23146400 24899616
17:39:41 3627 8192000000 10951431232 11366604800 1985813424 19.511 98 83 166 1 2035358160 24997424 24547312
17:39:52 1669 8192000000 10940942864 11355598848 1949922720 19.226 98 82 164 0 2000450512 26328016 24199776
17:40:02 3622 8192000000 10945416288 11365498880 1980269392 19.467 100 74 150 3 2029419472 26095328 23054752
17:40:12 8348 8192000000 10904564048 11324866560 1900250640 18.828 96 63 126 3 1947652512 27395952 20005920
17:40:31 9052 8192000000 10922662224 11351830528 1961792656 19.320 100 67 133 1 2010594256 27900832 20900768
17:40:48 23458 8192000000 10917706048 11348054016 1945274400 19.189 99 60 120 1 1993851248 29507552 19069296
17:41:22 8489 8192000000 10928565904 11359424512 1968526016 19.374 100 51 101 1 2018977216 33766416 16684784
17:41:39 3079 8192000000 10945197008 11354034176 1952605504 19.247 99 74 141 2 2007882784 33402864 21874416
17:41:49 3204 8192000000 10942048144 11367800832 1973725984 19.415 100 69 135 0 2034210608 38793456 21691168
17:42:00 3067 8192000000 10918846720 11338432512 1938664816 19.136 99 70 140 1 1994254320 33787600 21801904
17:42:10 1030 8192000000 10958077216 11371528192 1978194272 19.450 100 85 169 0 2036913264 32639056 26079936
17:42:18 1579 8192000000 10947493328 11355455488 1966009248 19.354 100 88 172 0 2024936528 32142368 26784912
17:42:26 5119 8192000000 10927615248 11347279872 1949570592 19.223 99 84 166 1 2004552704 28587360 26394752
17:42:40 3445 8192000000 10895444352 11305197568 1905289392 18.869 97 73 145 1 1956338896 28814128 22235376
17:42:49 3910 8192000000 10927325968 11337134080 1937057440 19.123 99 78 155 3 1991454112 30857408 23539264
17:43:00 2253 8192000000 10932657696 11343155200 1938276464 19.133 99 83 165 2 1993966592 30617296 25072832
17:43:10 4649 8192000000 10924615744 11329126400 1939455280 19.142 99 81 162 1 1993250336 29781616 24013440
17:43:21 4190 8192000000 10938137680 11353640960 1965191552 19.347 100 77 154 0 2020457920 31882064 23384304
17:43:33 5686 8192000000 10920094576 11334156288 1931642176 19.080 98 71 139 4 1982747184 29716608 21388400
17:43:45 3427 8192000000 10929405600 11349950464 1957158032 19.283 100 70 139 4 2011609792 32307936 22143824
17:43:59 4210 8192000000 10936571680 11359080448 1969174720 19.379 100 71 141 0 2023761264 32980224 21606320
17:44:13 2436 8192000000 10929066416 11349446656 1957158224 19.283 99 70 141 4 2017031056 37666928 22205904
17:44:23 3943 8192000000 10941242400 11358826496 1963601824 19.335 100 77 152 0 2026330400 39446464 23282112
17:44:33 1001 8192000000 10949493152 11359875072 1963374128 19.333 100 91 179 3 2033660416 41959024 28327264
17:44:42 1599 8192000000 10950128640 11357818880 1951552816 19.239 99 83 167 1 2023163760 43912640 27698304
17:44:51 2794 8192000000 10951540512 11368456192 1964265792 19.340 100 77 154 0 2032102384 42519920 25316672
17:45:01 2865 8192000000 10933404384 11350396928 1936559152 19.119 99 82 165 1 2006227616 43366048 26302416
17:45:11 8664 8192000000 10918910784 11353292800 1948522576 19.215 100 51 102 1 2009457536 44278368 16656592
17:45:26 8023 8192000000 10894199456 11322720256 1921084416 18.996 99 52 103 3 1981686080 42552816 18048848
17:45:42 2798 8192000000 10884882992 11290607616 1882678576 18.687 97 71 142 2 1950337456 45264416 22394464
17:45:51 3836 8192000000 10927517712 11336069120 1933950320 19.098 100 85 167 1 2007418624 47273808 26194496
17:46:02 4919 8192000000 10920361344 11332059136 1930646368 19.072 100 77 153 2 2004414896 49044272 24724256
17:46:15 1333 8192000000 10928800464 11333177344 1928683808 19.056 100 87 172 1 2006514320 50415456 27415056
17:46:24 2790 8192000000 10924893072 11333468160 1929924832 19.066 100 77 153 0 2006225616 52019936 24280848
17:46:35 2167 8192000000 10957886032 11362070528 1952225344 19.244 100 86 170 3 2033398464 53898448 27274672
17:46:45 2938 8192000000 10950280240 11366547456 1953072496 19.251 100 79 158 0 2034487792 55894224 25521072
17:46:55 8315 8192000000 10937226928 11363377152 1953326080 19.253 100 52 103 1 2020417856 48709232 18382544
17:47:19 6198 8192000000 10942000656 11364622336 1950164496 19.228 100 57 115 0 2020402992 51019152 19219344
17:47:33 1611 8192000000 10941227696 11356905472 1955658480 19.272 100 81 161 1 2022491728 40571776 26261472
17:47:41 3634 8192000000 10935389616 11355295744 1957135280 19.283 100 67 134 0 2017128240 38009392 21983568
17:47:55 3457 8192000000 10951793552 11370254336 1969569184 19.382 100 71 142 0 2035327504 43418336 22339984
17:48:09 2121 8192000000 10954631824 11367530496 1968399248 19.373 100 74 147 1 2034919488 43330560 23189680
17:48:18 2395 8192000000 10966397360 11375849472 1969976080 19.385 100 84 166 0 2042062384 46108144 25978160
17:48:30 8329 8192000000 10915686112 11354927104 1922016032 19.003 98 50 100 1 1987004752 48368656 16620064
17:49:05 11152 8192000000 10901068464 11333668864 1932254000 19.085 100 40 80 2 1984011088 38715856 13041232
17:49:25 6989 8192000000 10913268320 11344384000 1941726800 19.161 100 45 91 1 1997419008 40875696 14816512
17:49:38 5529 8192000000 10912890704 11345760256 1942140128 19.164 100 48 95 0 1998708480 40886752 15681600
17:49:58 21425 8192000000 10918521024 11357786112 1953124528 19.251 100 39 78 2 2008910448 42643648 13142272
17:50:27 18504 8192000000 10917038960 11361005568 1951108992 19.235 100 30 60 2 1995521984 34354464 10058528
17:50:56 18683 8192000000 10920778352 11361816576 1954296944 19.261 100 30 60 3 2000383856 36187664 9899248
17:51:49 18957 8192000000 10905099392 11353190400 1930042704 19.067 99 22 44 1 1974466768 37341344 7082720
17:52:14 19717 8192000000 10910518832 11358035968 1941773312 19.161 100 21 42 1 1991276096 42054432 7448352
17:53:00 19859 8192000000 10908006048 11360628736 1923685808 19.016 99 27 54 1 1981669968 48333360 9650800
17:53:26 13251 8192000000 10909517952 11381334016 1929376544 19.062 100 20 40 0 1988562912 52084144 7102224
17:54:34 30995 8192000000 10898786032 11354542080 1917867904 18.970 99 19 36 0 1976106384 51610272 6628208
17:55:12 24418 8192000000 10883239728 11350532096 1919892416 18.986 99 18 36 0 1973743552 47970848 5880288
17:55:42 42067 8192000000 10881194624 11347861504 1932252592 19.085 100 8 16 0 1958529520 23675840 2601088
17:56:33 53941 8192000000 10884202976 11325423616 1900949888 18.834 98 18 36 0 1928899536 22727616 5222032
17:57:37 86968 8192000000 10865555184 11313647616 1917980048 18.971 98 39 79 0 1939091888 9491152 11620688
17:59:13 73921 8192000000 10864975648 11332943872 1912450016 18.926 98 16 32 0 1930778320 14023888 4304416
18:00:36 17033 8192000000 10880269808 11326234624 1934610992 19.104 99 45 88 3 1956792368 9602704 12578672
18:00:59 64674 8192000000 10861382016 11322925056 1919566096 18.983 98 25 49 0 1937845168 11475456 6803616
18:02:11 13567 8192000000 10881291440 11339878400 1944176800 19.180 100 21 42 0 1969127248 18871712 6078736
18:02:31 38297 8192000000 10871059536 11341459456 1932624352 19.088 99 12 24 1 1950205488 14325792 3255344
18:04:27 48040 8192000000 10882564848 11347804160 1947012224 19.203 100 15 30 1 1975318000 24555360 3750416
18:05:45 44194 8192000000 10886077200 11350007808 1955135664 19.267 100 15 30 1 1971396432 12365952 3894816
18:07:14 55071 8192000000 10905111360 11367624704 1972367552 19.404 100 20 40 1 1992145984 13908128 5870304
18:08:16 42688 8192000000 10902919232 11378196480 1979041616 19.457 100 10 20 1 1999242096 16972704 3227776
18:09:04 6489 8192000000 10903324784 11379445760 1980324096 19.467 100 10 20 0 1999319664 15931680 3063888
18:09:19 60309 8192000000 10922825488 11396055040 1979713168 19.462 100 18 36 0 2011756288 26434016 5609104
18:11:01 54332 8192000000 10876743264 11341705216 1944174800 19.180 98 27 53 1 1963139136 11004704 7959632
18:12:02 68208 8192000000 10889954368 11356778496 1959234112 19.300 99 23 46 3 1974871584 8448976 7188496
18:13:18 46895 8192000000 10900478016 11370160128 1972715600 19.407 100 14 28 2 1986401200 9732928 3952672
18:14:15 88799 8192000000 10896534544 11382857728 1984788480 19.503 100 12 24 1 2001296880 12722400 3786000
18:15:52 66993 8192000000 10878577264 11354935296 1962034624 19.322 99 15 29 0 1976353824 10272816 4046384
18:17:11 87094 8192000000 10909522384 11388125184 1988507376 19.532 100 15 29 0 2001922464 9976896 3438192
18:18:51 61817 8192000000 10929037168 11397214208 1993966272 19.575 100 10 20 0 2012693072 15587440 3139360
18:20:00 54173 8192000000 10902676272 11370774528 1952392224 19.246 98 9 18 0 1971113712 15918896 2802592
18:21:01 60097 8192000000 10916512016 11382120448 1953714576 19.256 98 24 48 0 1972167360 11793920 6658864
18:22:34 79199 8192000000 10919166240 11377295360 1946681264 19.200 98 18 36 1 1963095536 11583168 4831104
18:24:03 47849 8192000000 10915311696 11380621312 1971980832 19.401 99 32 64 0 1991424720 10903296 8540592
18:24:58 82358 8192000000 10901755856 11366412288 1905134720 18.868 96 14 27 1 1922575376 14018032 3422624
18:26:32 34322 8192000000 10903460976 11352854528 1921327744 18.997 97 33 66 1 1940463072 10265952 8869376
18:27:15 11078 8192000000 10932454576 11378933760 1982057488 19.481 100 66 130 1 2009930208 10181968 17690752
18:27:33 8800 8192000000 10933308400 11374985216 1968397168 19.373 99 57 114 1 1996019152 12242624 15379360
18:29:00 83305 8192000000 10874798256 11336212480 1807011968 18.071 91 21 43 1 1822082816 8993904 6076944
18:30:29 69813 8192000000 10887086896 11342426112 1867674672 18.565 96 26 52 1 1887350064 12559296 7116096
18:32:03 112086 8192000000 10860405120 11327475712 1873949632 18.616 96 26 52 2 1890309056 9467232 6892192
18:34:22 56878 8192000000 10858945072 11319205888 1898984608 18.818 98 27 54 0 1913904752 7723696 7196448
18:35:29 40159 8192000000 10846800096 11306962944 1894869024 18.785 98 31 61 1 1913929632 10847840 8212768
18:36:37 59889 8192000000 10838017200 11308400640 1886945712 18.721 98 12 24 0 1900413088 9244176 4223200
18:37:43 63512 8192000000 10833318896 11307536384 1885667472 18.711 98 6 12 0 1901918400 14641408 1609520
18:38:53 48053 8192000000 10839593216 11313262592 1881153616 18.674 98 7 14 0 1898671328 15604912 1912800
18:39:55 57719 8192000000 10827508480 11298426880 1892998848 18.770 99 15 30 1 1915254928 17586704 4669376
18:41:00 62984 8192000000 10837921600 11315163136 1902697696 18.848 99 11 22 0 1925810096 19600256 3512144
18:42:14 43715 8192000000 10843445744 11301163008 1851916800 18.438 96 19 39 1 1873466800 16375920 5174080
18:43:07 38789 8192000000 10875762288 11329515520 1931776544 19.081 100 31 61 1 1956482336 16011184 8694608
18:44:15 49719 8192000000 10852712592 11307020288 1866578432 18.557 96 25 50 1 1886613536 13102928 6932176
18:45:11 87241 8192000000 10851773712 11299856384 1863171840 18.529 97 15 30 0 1881834928 14130448 4532640
18:46:47 33133 8192000000 10849682128 11309649920 1907112224 18.883 99 30 61 0 1924271504 8896320 8262960
18:47:33 29266 8192000000 10865702000 11314769920 1872062720 18.601 97 27 54 0 1895735680 16118432 7554528
18:48:20 68120 8192000000 10821339488 11280551936 1818416528 18.165 95 20 40 1 1839753152 15373152 5963472
18:49:38 40365 8192000000 10833150272 11274457088 1842774928 18.363 97 20 40 1 1866357280 17670960 5911392
18:50:25 68431 8192000000 10850856240 11314728960 1905924560 18.874 100 24 48 1 1933218464 20318960 6974944
18:51:57 89506 8192000000 10868390816 11329921024 1924834608 19.026 100 10 20 1 1949142560 21986400 2321552
18:53:33 139370 8192000000 10882489584 11351117824 1945139360 19.188 100 26 52 0 1971775808 19063840 7572608
18:56:25 37998 8192000000 10868840752 11333795840 1892204416 18.764 97 27 54 1 1917686944 17787120 7695408
18:57:34 69398 8192000000 10864875360 11340324864 1947380944 19.206 100 13 26 1 1961952368 10738880 3832544
18:58:50 54929 8192000000 10882240096 11358994432 1952037360 19.243 100 9 18 0 1968877872 14625808 2214704
18:59:55 39915 8192000000 10865243184 11331436544 1889699952 18.743 97 6 12 0 1900434224 9367024 1367248
19:00:41 67641 8192000000 10880348864 11347537920 1935845504 19.114 99 15 30 0 1948076880 7840848 4390528
19:01:55 56762 8192000000 10895761664 11355070464 1942909232 19.170 99 24 48 0 1961408624 11437712 7061680
19:02:58 39660 8192000000 10889383584 11348848640 1927814208 19.049 98 22 44 0 1944366608 10776784 5775616
19:03:49 12375 8192000000 10893400192 11351547904 1961431888 19.317 100 42 83 2 1984179920 9812736 12935296
19:04:29 94436 8192000000 10878834832 11360321536 1927225088 19.045 98 19 38 2 1958688560 26174256 5289216
19:06:09 47301 8192000000 10914985216 11361144832 1947742112 19.208 99 36 72 1 1972494112 14771744 9980256
19:07:04 27220 8192000000 10904589264 11357077504 1952255712 19.244 99 39 78 0 1974720048 11897040 10567296
19:07:42 52706 8192000000 10893965760 11372720128 1932944384 19.090 98 31 62 1 1958064240 16165808 8954048
19:09:12 65532 8192000000 10896515616 11366219776 1950805920 19.233 99 19 38 0 1965375152 9392496 5176736
19:10:52 53748 8192000000 10902730800 11360964608 1950712528 19.232 99 24 48 0 1967988128 10790528 6485072
19:11:55 86338 8192000000 10908178464 11382067200 1933862560 19.098 98 20 40 2 1952227808 12947712 5417536
19:13:28 77124 8192000000 10926131600 11388411904 1950921264 19.234 99 17 34 0 1972109312 16668144 4519904
19:14:52 90205 8192000000 10884517696 11355672576 1877346912 18.644 95 7 14 0 1892425616 13077616 2001088
19:16:28 81566 8192000000 10834083520 11300106240 1893397264 18.773 97 26 53 0 1909345328 8047264 7900800
19:17:59 66927 8192000000 10892499584 11358765056 1941343808 19.157 99 30 60 0 1959742832 10404304 7994720
19:19:13 42736 8192000000 10866760624 11349897216 1936474432 19.119 99 14 27 2 1954198192 13329504 4394256
19:20:02 90115 8192000000 10872276752 11357999104 1957603184 19.287 100 9 18 1 1972271760 12107568 2561008
19:21:38 65437 8192000000 10868186848 11340308480 1904074528 18.859 97 14 28 0 1918218160 9829216 4314416
19:23:11 70583 8192000000 10868266016 11335372800 1927210656 19.045 99 11 22 1 1940066592 9513968 3341968
19:24:34 81875 8192000000 10854123440 11341246464 1915519808 18.951 98 22 44 2 1937330800 15798224 6012768
19:26:08 65172 8192000000 10830604320 11310858240 1893078736 18.771 98 11 22 1 1907446160 11522784 2844640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 126 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 31-01-2021 19:29:31 to 31-01-2021 19:29:33.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          237406
MON$OLDEST_ACTIVE               237568
MON$OLDEST_SNAPSHOT             237568
MON$NEXT_TRANSACTION            237568
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                       2024320
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.33409 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33409 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33409 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33409 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 ---
:23: 
:24: mscs-test-161.budzdorov.ru    Sun Jan 31 19:27:18 2021
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
:27: 
:28: mscs-test-161.budzdorov.ru    Sun Jan 31 19:27:23 2021
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:30: 
:31: 
:32: mscs-test-161.budzdorov.ru    Sun Jan 31 19:27:24 2021
:33:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:34: 
:35: 
:36: mscs-test-161.budzdorov.ru    Sun Jan 31 19:27:24 2021
:37:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:38: 
:39: 
:40: mscs-test-161.budzdorov.ru    Sun Jan 31 19:27:25 2021
:41:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:42: 
--- end of diff output ---

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

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