Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.02.2021 01: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 17300544 kB
MemAvailable 31219104 kB
Buffers 0 kB
Cached 14377624 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-02-02 01:27:18
DTS_END                         2021-02-02 01:27:18.2460
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/49138
TRN_ID                          237025
ATT_ID                          600
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: 9293.40 22865 1115208
customer order: creation 174.08 341 20890
customer order: refuse 14.12 338 1694
order to supplier: creation 46.24 1220 5549
order to supplier: removal 3.42 108653 410
invoice (draft): creation 46.66 3221 5599
invoice (draft): removal 53.72 871 6446
invoice accept: apply 41.43 18707 4971
invoice accept: cancel 48.53 788 5824
customer reserve: creation 3858.33 185 462999
customer reserve: removal 4710.10 61 565212
realization accept: apply 84.65 178 10158
realization accept: cancel 82.51 116 9901
payment from customer: creation 58.83 107 7059
payment from customer: removal 5.53 73 664
payment to supplier: creation 49.78 139 5974
payment to supplier: removal 3.24 84 389
service: total inventory turnovers 4.89 987 587
service: total monetary turnovers 6.34 22 761
service: aggregate perf. data 0.98 14026 117
service: refresh index statistics 0.03 307187 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-02-2021 01:28:08 to 02-02-2021 01:28:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3560
TEST_TIME 2 4628
TEST_TIME 3 4365
TEST_TIME 4 4313
TEST_TIME 5 4463
TEST_TIME 6 4270
TEST_TIME 7 4392
TEST_TIME 8 4483
TEST_TIME 9 4826
TEST_TIME 10 5024
TEST_TIME 11 5865
TEST_TIME 12 6139
TEST_TIME 13 6360
TEST_TIME 14 6425
TEST_TIME 15 6507
TEST_TIME 16 6994
TEST_TIME 17 7207
TEST_TIME 18 7512
TEST_TIME 19 7843
TEST_TIME 20 8639
TEST_TIME 21 8673
TEST_TIME 22 8523
TEST_TIME 23 8587
TEST_TIME 24 8931
TEST_TIME 25 9732
TEST_TIME 26 10234
TEST_TIME 27 11053
TEST_TIME 28 10844
TEST_TIME 29 10705
TEST_TIME 30 10377
TEST_TIME 31 10463
TEST_TIME 32 10592
TEST_TIME 33 10304
TEST_TIME 34 10256
TEST_TIME 35 10215
TEST_TIME 36 10234
TEST_TIME 37 10104
TEST_TIME 38 10034
TEST_TIME 39 9901
TEST_TIME 40 9795
TEST_TIME 41 9760
TEST_TIME 42 9621
TEST_TIME 43 9661
TEST_TIME 44 9760
TEST_TIME 45 9686
TEST_TIME 46 9640
TEST_TIME 47 9650
TEST_TIME 48 9729
TEST_TIME 49 9635
TEST_TIME 50 9545
TEST_TIME 51 9679
TEST_TIME 52 9813
TEST_TIME 53 9870
TEST_TIME 54 9861
TEST_TIME 55 9889
TEST_TIME 56 9937
TEST_TIME 57 9990
TEST_TIME 58 9978
TEST_TIME 59 9978
TEST_TIME 60 9829
TEST_TIME 61 9776
TEST_TIME 62 9687
TEST_TIME 63 9760
TEST_TIME 64 9672
TEST_TIME 65 9730
TEST_TIME 66 9689
TEST_TIME 67 9616
TEST_TIME 68 9610
TEST_TIME 69 9600
TEST_TIME 70 9574
TEST_TIME 71 9699
TEST_TIME 72 9681
TEST_TIME 73 9650
TEST_TIME 74 9652
TEST_TIME 75 9731
TEST_TIME 76 9766
TEST_TIME 77 9765
TEST_TIME 78 9728
TEST_TIME 79 9783
TEST_TIME 80 9808
TEST_TIME 81 9798
TEST_TIME 82 9707
TEST_TIME 83 9657
TEST_TIME 84 9608
TEST_TIME 85 9554
TEST_TIME 86 9605
TEST_TIME 87 9543
TEST_TIME 88 9516
TEST_TIME 89 9490
TEST_TIME 90 9439
TEST_TIME 91 9351
TEST_TIME 92 9367
TEST_TIME 93 9347
TEST_TIME 94 9318
TEST_TIME 95 9340
TEST_TIME 96 9415
TEST_TIME 97 9416
TEST_TIME 98 9452
TEST_TIME 99 9425
TEST_TIME 100 9464
TEST_TIME 101 9459
TEST_TIME 102 9475
TEST_TIME 103 9471
TEST_TIME 104 9506
TEST_TIME 105 9559
TEST_TIME 106 9542
TEST_TIME 107 9465
TEST_TIME 108 9405
TEST_TIME 109 9342
TEST_TIME 110 9338
TEST_TIME 111 9320
TEST_TIME 112 9317
TEST_TIME 113 9297
TEST_TIME 114 9272
TEST_TIME 115 9274
TEST_TIME 116 9342
TEST_TIME 117 9312
TEST_TIME 118 9279
TEST_TIME 119 9347
TEST_TIME 120 9296

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-02-2021 01:28:12 to 02-02-2021 01:28:15.

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 1544388 1544388 0 0.00 0 23934 7 0 0
doc_list_biud 1544388 1544388 0 0.00 0 24100 28 0 0
sp_add_invoice_to_stock 5103 4971 132 2.58 33 179493 18708 0 132
sp_cancel_adding_invoice 5824 5824 0 0.00 4 102787 789 0 0
sp_cancel_client_order 1694 1694 0 0.00 4 12513 338 0 0
sp_cancel_customer_reserve 565212 565212 0 0.00 1 23708 61 0 0
sp_cancel_pay_from_customer 664 664 0 0.00 3 3821 73 0 0
sp_cancel_pay_to_supplier 389 389 0 0.00 3 8888 84 0 0
sp_cancel_supplier_invoice 6458 6446 12 0.18 1 24107 871 0 12
sp_cancel_supplier_order 410 410 0 0.00 5 1112358 108653 0 0
sp_cancel_write_off 9901 9901 0 0.00 1 7115 117 0 0
sp_client_order 20890 20890 0 0.00 3 15523 342 0 0
sp_customer_reserve 462999 462999 0 0.00 0 92469 185 0 0
sp_fill_shopping_cart 32031 32031 0 0.00 1 12760 36 0 0
sp_fill_shopping_cart_clo_res 462992 462992 0 0.00 0 18393 14 0 0
sp_get_clo_for_invoice 4963 4963 0 0.00 0 11991 294 0 0
sp_kill_cost_storno 16778 16778 0 0.00 0 7153 58 0 0
sp_kill_qstorno_ret_qs2qd 1147181 1147181 0 0.00 0 24098 34 0 0
sp_kill_qty_storno 604608 604608 0 0.00 0 24100 72 0 0
sp_lock_selected_doc 20750 20750 0 0.00 0 9654 6 0 0
sp_make_cost_storno 28154 28154 0 0.00 0 23825 51 0 0
sp_multiply_rows_for_pdistr 28154 28154 0 0.00 0 7911 31 0 0
sp_multiply_rows_for_qdistr 20890 20890 0 0.00 0 10228 167 0 0
sp_pay_from_customer 7059 7059 0 0.00 4 14130 108 0 0
sp_pay_to_supplier 5974 5974 0 0.00 4 23968 140 0 0
sp_payment_common 13033 13033 0 0.00 1 14100 30 0 0
sp_qd_handle_on_cancel_clo 1694 1694 0 0.00 0 12505 311 0 0
sp_qd_handle_on_invoice_upd_sts 10787 10787 0 0.00 0 23051 323 0 0
sp_qd_handle_on_reserve_upd_sts 10158 10158 0 0.00 0 16822 59 0 0
sp_reserve_write_off 10158 10158 0 0.00 6 16853 179 0 0
sp_supplier_invoice 5599 5599 0 0.00 8 96727 3221 0 0
sp_supplier_order 5549 5549 0 0.00 5 39417 1220 0 0
srv_aggregate_perf_data 117 117 0 0.00 2535 82969 14026 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 982 156059 34824 0 0
srv_find_qd_qs_mism 1067459 1067459 0 0.00 0 12396 6 0 0
srv_make_invnt_saldo 587 587 0 0.00 25 44274 988 0 0
srv_make_money_saldo 761 761 0 0.00 1 1073 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 140523 443784 307187 0 0
t$perf-abend:sp_add_invoice_to_stock 132 132 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4971 4971 0 0.00 0 14958 168 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 0 3297 72 0 0
t$perf-norm:sp_cancel_client_order 1694 1694 0 0.00 0 5418 16 0 0
t$perf-norm:sp_cancel_customer_reserve 650 650 0 0.00 0 5323 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 664 664 0 0.00 0 1255 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 389 389 0 0.00 0 2025 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 2471 14 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 24904 1640 0 0
t$perf-norm:sp_cancel_write_off 1022 1022 0 0.00 0 4726 17 0 0
t$perf-norm:sp_client_order 20890 20890 0 0.00 0 42981 18 0 0
t$perf-norm:sp_customer_reserve 965 965 0 0.00 0 1439 6 0 0
t$perf-norm:sp_pay_from_customer 7059 7059 0 0.00 0 7499 11 0 0
t$perf-norm:sp_pay_to_supplier 5974 5974 0 0.00 0 43049 18 0 0
t$perf-norm:sp_reserve_write_off 10158 10158 0 0.00 0 5880 11 0 0
t$perf-norm:sp_supplier_invoice 5599 5599 0 0.00 0 8330 18 0 0
t$perf-norm:sp_supplier_order 5549 5549 0 0.00 0 5265 14 0 0
t$perf-norm:srv_aggregate_perf_data 117 117 0 0.00 0 1792 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 89 1 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 2256 26 0 0
t$perf-norm:srv_make_money_saldo 761 761 0 0.00 0 989 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 163 42 0 0
v_add_invoice_to_stock 10186 9922 264 2.59 0 7620 22 0 264
v_all_customers 37700 37700 0 0.00 0 20 1 0 0
v_all_suppliers 31152 31152 0 0.00 0 25 1 0 0
v_all_wares 41780 41780 0 0.00 0 88 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 680 6 0 0
v_cancel_client_order 3388 3388 0 0.00 0 3763 8 0 0
v_cancel_customer_prepayment 1328 1328 0 0.00 0 3783 9 0 0
v_cancel_customer_reserve 1300 1300 0 0.00 0 3783 6 0 0
v_cancel_payment_to_supplier 778 778 0 0.00 0 1026 5 0 0
v_cancel_supplier_invoice 796 772 24 3.01 0 2027 22 0 24
v_cancel_supplier_order 820 820 0 0.00 0 3788 14 0 0
v_cancel_write_off 2044 2044 0 0.00 0 2554 15 0 0
v_max_id_clo_ord 5546 5546 0 0.00 0 395 1 0 0
v_max_id_clo_res 965 965 0 0.00 0 2997 12 0 0
v_max_id_ord_sup 5595 5595 0 0.00 0 5840 3 0 0
v_max_non_paid_invoice 1539 1539 0 0.00 0 2884 9 0 0
v_max_non_paid_realizn 3798 3798 0 0.00 0 4484 6 0 0
v_min_id_clo_ord 5546 5546 0 0.00 0 1998 4 0 0
v_min_id_clo_res 965 965 0 0.00 0 7131 18 0 0
v_min_id_ord_sup 5595 5595 0 0.00 0 6670 8 0 0
v_min_non_paid_invoice 5974 5974 0 0.00 0 9720 18 0 0
v_min_non_paid_realizn 7059 7059 0 0.00 0 8940 19 0 0
v_our_firm 10602 10602 0 0.00 0 22 1 0 0
v_reserve_write_off 20316 20316 0 0.00 0 4435 7 0 0
x_lock_depdocs_on_canc_invoice 11884 11884 0 0.00 0 27595 127 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 8423 402 0 0
x_make_qstorno_1000_1200 5549 5549 0 0.00 1 39409 1149 0 0
x_make_qstorno_1200_2000 5599 5599 0 0.00 3 96667 3093 0 0
x_make_qstorno_2100_3300 462999 462999 0 0.00 0 92467 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-02-2021 01:28:16 to 02-02-2021 01:28:20.

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
22:57:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:28 27853 8192000000 10272564336 10585063424 835218592 9.252 65 54 110 0 855046240 2251056 17576592
22:58:05 28364 8192000000 10335325184 10652274688 1387124688 14.480 100 85 170 0 1420023792 5255280 27643824
22:58:45 21018 8192000000 10380212016 10698133504 1424630416 14.814 100 91 182 1 1461223840 6639584 29953840
22:59:18 29724 8192000000 10410942912 10736226304 1456794832 15.098 100 84 168 0 1491705008 7832656 27077520
22:59:56 26991 8192000000 10435303152 10762190848 1478847856 15.291 100 89 178 0 1516129456 8793152 28488448
23:00:33 19129 8192000000 10449031280 10778787840 1500410560 15.480 100 91 182 0 1538727984 9610432 28706992
23:01:05 28258 8192000000 10471309632 10813128704 1518868384 15.640 100 79 158 2 1553755664 10121104 24766176
23:01:46 13355 8192000000 10501308640 10848690176 1560723328 16.002 100 83 166 0 1596527856 10258128 25546400
23:02:11 14187 8192000000 10513681824 10866089984 1574290368 16.119 100 72 144 0 1607062416 10789872 21982176
23:02:33 17570 8192000000 10542029200 10898391040 1597582016 16.319 100 73 146 0 1630463264 10590576 22290672
23:03:00 13517 8192000000 10573814736 10936778752 1629079744 16.587 100 73 146 0 1661327888 11060800 21187344
23:03:22 13947 8192000000 10594339904 10960187392 1656917568 16.823 100 80 160 0 1692725952 12214976 23593408
23:03:46 7926 8192000000 10627842816 10993647616 1684164848 17.052 100 77 155 0 1718216032 11934000 22117184
23:04:02 10815 8192000000 10637698384 11010727936 1700468272 17.189 100 78 156 1 1735776752 12833392 22475088
23:04:21 8166 8192000000 10658608864 11027451904 1717561808 17.332 100 83 166 0 1754815536 13065376 24188352
23:04:37 7429 8192000000 10666857984 11037757440 1727180640 17.412 100 81 162 0 1763452944 13550464 22721840
23:04:53 8359 8192000000 10665795808 11044491264 1733470128 17.464 100 80 160 0 1769463616 13233744 22759744
23:05:10 3879 8192000000 10677558352 11057508352 1744548288 17.556 100 80 158 1 1780421136 13256304 22616544
23:05:21 6443 8192000000 10683125696 11068678144 1753187360 17.628 100 71 142 0 1786110848 12559152 20364336
23:05:34 5265 8192000000 10697600256 11081900032 1767276960 17.745 100 80 160 3 1802214304 12830192 22107152
23:05:47 5559 8192000000 10710311744 11094704128 1775456656 17.812 100 73 146 0 1808484816 12825984 20202176
23:05:59 4855 8192000000 10717606624 11096817664 1779139440 17.842 100 75 147 0 1812407312 13055984 20211888
23:06:10 10039 8192000000 10711764336 11097141248 1780544080 17.854 100 69 136 1 1812656736 13027744 19084912
23:06:28 3653 8192000000 10745563136 11126857728 1804837440 18.054 100 87 170 3 1846758976 17438336 24483200
23:06:39 3444 8192000000 10743007616 11130597376 1807446704 18.075 100 83 166 1 1843314544 12360912 23506928
23:06:50 2879 8192000000 10760088688 11143241728 1815463168 18.141 100 86 172 2 1854091776 14240128 24388480
23:06:59 2979 8192000000 10759407584 11146739712 1823458368 18.206 100 77 152 2 1857201648 12501232 21242048
23:07:09 2659 8192000000 10765622384 11152236544 1829260048 18.253 100 83 165 1 1865749296 12891648 23597600
23:07:18 2500 8192000000 10780142288 11165048832 1837964416 18.324 100 92 185 1 1877559056 14300112 25294528
23:07:27 1917 8192000000 10787424528 11169021952 1840858976 18.348 100 92 186 1 1882301792 15328768 26114048
23:07:35 2269 8192000000 10783833360 11169828864 1844863584 18.380 100 93 189 2 1884951664 14217440 25870640
23:07:44 1693 8192000000 10780148944 11168681984 1843657824 18.371 100 83 163 1 1881486736 14052752 23776160
23:07:52 2660 8192000000 10788439376 11176779776 1846821504 18.396 100 89 178 1 1885416048 12790112 25804432
23:08:01 1490 8192000000 10790828208 11178758144 1852241088 18.440 100 93 182 0 1890678944 11996256 26441600
23:08:10 1729 8192000000 10797375520 11183022080 1855015712 18.463 100 95 188 0 1894459568 12661136 26782720
23:08:18 2339 8192000000 10801501024 11186982912 1855710496 18.468 100 86 170 1 1891695728 12088336 23896896
23:08:27 2043 8192000000 10802173504 11192958976 1857706656 18.485 100 86 172 2 1893668304 11588480 24373168
23:08:35 2372 8192000000 10801674240 11191873536 1863072624 18.528 100 90 179 1 1902494576 14007648 25414304
23:08:44 31694 8192000000 10805193808 11200122880 1866605312 18.557 100 80 157 1 1901522832 11812096 23105424
23:09:22 5463 8192000000 10782259936 11197968384 1858959776 18.495 100 46 92 3 1884533088 13172096 12401216
23:09:37 4085 8192000000 10786514432 11197992960 1862412736 18.523 100 48 96 1 1885928016 10015280 13500000
23:09:48 6126 8192000000 10766606592 11193786368 1861956384 18.519 100 37 74 0 1880896560 8268736 10671440
23:10:01 6381 8192000000 10786013952 11192668160 1863709488 18.533 100 44 88 1 1882760192 6696384 12354320
23:10:14 3541 8192000000 10785897424 11199913984 1865126480 18.545 100 41 80 1 1884714304 7348944 12238880
23:10:25 3328 8192000000 10778735632 11199299584 1869226528 18.578 100 39 79 2 1886829168 6588992 11013648
23:10:34 5382 8192000000 10778895440 11207917568 1873989680 18.617 100 42 84 1 1894588400 9170608 11428112
23:10:46 4579 8192000000 10784077136 11204825088 1872966432 18.608 100 37 73 0 1889847872 6467952 10413488
23:10:58 9610 8192000000 10769256144 11204014080 1871531808 18.597 100 20 39 4 1884130912 5966832 6632272
23:11:13 4903 8192000000 10795006192 11213479936 1875843472 18.632 100 43 86 1 1896046544 8142528 12060544
23:11:25 9403 8192000000 10779522528 11209150464 1876940464 18.640 100 28 55 3 1891906720 6603088 8363168
23:11:40 52887 8192000000 10794733712 11218694144 1876733632 18.639 100 34 69 1 1892630864 6178960 9718272
23:12:40 25380 8192000000 10803282512 11223408640 1877308768 18.643 100 16 31 1 1886930944 5988288 3633888
23:13:12 5365 8192000000 10796139072 11224682496 1883044368 18.690 100 25 48 1 1896704528 6585040 7075120
23:13:30 6326 8192000000 10804509504 11233636352 1888063056 18.730 100 27 54 1 1903625728 8085856 7476816
23:13:45 5483 8192000000 10802935616 11237949440 1890963472 18.754 100 29 59 0 1905344352 6593872 7787008
23:13:57 7450 8192000000 10802125936 11235729408 1891175072 18.755 100 23 43 2 1903662656 6171888 6315696
23:14:16 7756 8192000000 10808310944 11243163648 1896831376 18.801 100 23 45 1 1910164656 6701936 6631344
23:14:30 5893 8192000000 10824218976 11249545216 1898484656 18.814 100 25 48 3 1911301856 6296080 6521120
23:14:44 5036 8192000000 10817020112 11248087040 1908292720 18.893 100 31 62 2 1922190528 5412112 8485696
23:14:58 8615 8192000000 10824108720 11253604352 1904560288 18.863 100 21 40 4 1916202048 6077648 5564112
23:15:14 8240 8192000000 10818102096 11248660480 1899296704 18.821 100 25 48 2 1912155888 6189312 6669872
23:15:35 6896 8192000000 10821270480 11247349760 1899487280 18.822 100 29 58 2 1913432944 6280976 7664688
23:15:50 8217 8192000000 10821751104 11254898688 1906947200 18.882 100 32 64 2 1922823280 6833344 9042736
23:16:13 65302 8192000000 10824156336 11245752320 1872526960 18.605 98 28 55 2 1885880272 5470976 7882336
23:17:25 10629 8192000000 10808056544 11248541696 1887311600 18.724 99 27 54 0 1903064608 7959248 7793760
23:17:46 11792 8192000000 10805034352 11235938304 1843150528 18.366 97 16 32 2 1853782608 5408144 5223936
23:18:06 7575 8192000000 10810149760 11237756928 1885934192 18.713 99 35 70 1 1902991344 7703376 9353776
23:18:19 4792 8192000000 10794287856 11227435008 1879259728 18.659 99 31 62 1 1894946048 6885904 8800416
23:18:32 4680 8192000000 10812865968 11226017792 1849558000 18.419 98 34 68 2 1865206384 6326016 9322368
23:18:46 7536 8192000000 10768530192 11191623680 1826127648 18.228 97 25 51 0 1843496128 10072976 7295504
23:18:59 4724 8192000000 10749944832 11173314560 1759778160 17.683 94 21 42 1 1771230816 5399360 6053296
23:19:13 4577 8192000000 10736565888 11157884928 1786994576 17.907 97 26 52 0 1800231312 5459488 7777248
23:19:25 9325 8192000000 10741732944 11163992064 1801687008 18.028 98 22 44 0 1813964816 6209152 6068656
23:19:43 8345 8192000000 10718955888 11140722688 1764655376 17.723 97 17 34 2 1774850640 5224000 4971264
23:20:01 8598 8192000000 10686252800 11102633984 1738984016 17.510 96 17 34 1 1749187248 5569168 4634064
23:20:18 9503 8192000000 10721581792 11141931008 1747382960 17.580 96 26 52 0 1760958480 6214800 7360720
23:20:34 66988 8192000000 10684423360 11098423296 1589958512 16.253 88 33 66 0 1605442704 4986544 10497648
23:21:52 10640 8192000000 10702272144 11118264320 1771042224 17.776 99 28 56 2 1789351568 10546288 7763056
23:22:11 5432 8192000000 10712841952 11120123904 1774673312 17.806 99 37 74 2 1790474704 5313632 10487760
23:22:23 6668 8192000000 10716304240 11130540032 1783746128 17.880 99 32 65 3 1798825312 6091360 8987824
23:22:39 10252 8192000000 10719736624 11125272576 1754978736 17.643 97 28 53 3 1769362384 6172544 8211104
23:22:58 7155 8192000000 10682804656 11095912448 1731225280 17.446 96 23 45 4 1746710416 9214800 6270336
23:23:11 6550 8192000000 10711537584 11126304768 1776447488 17.820 99 32 64 6 1791873056 5900528 9525040
23:23:24 8426 8192000000 10729525696 11153354752 1812723152 18.118 100 20 40 1 1824002000 5373920 5904928
23:23:42 7949 8192000000 10746927744 11173470208 1828657600 18.248 100 24 48 2 1841939568 6206304 7075664
23:23:56 11988 8192000000 10764404832 11188281344 1844232704 18.375 100 36 70 1 1864573024 10019376 10320944
23:24:16 11272 8192000000 10766110256 11187208192 1842666736 18.363 100 18 36 2 1853599808 5254064 5679008
23:24:34 5337 8192000000 10774886944 11195535360 1850884992 18.429 100 37 74 2 1872313552 10736208 10692352
23:24:48 7634 8192000000 10755858224 11191746560 1850856016 18.429 100 19 35 2 1862207424 5752384 5599024
23:25:04 10221 8192000000 10774732704 11194335232 1856874432 18.478 100 18 36 2 1867848288 5472944 5500912
23:25:20 56510 8192000000 10799790624 11201417216 1860963456 18.511 100 29 57 2 1875345296 5176176 9205664
23:26:26 18552 8192000000 10773284080 11203833856 1861804656 18.518 100 22 44 0 1874376336 5911488 6660192
23:26:51 10495 8192000000 10781721568 11208028160 1863572544 18.532 100 33 66 1 1878616176 5634336 9409296
23:27:07 7057 8192000000 10797902528 11223359488 1877162800 18.642 100 31 62 0 1892021680 6754752 8104128
23:27:20 30506 8192000000 10820384704 11241947136 1893405072 18.773 100 36 72 2 1910231120 5655088 11170960
23:28:00 10568 8192000000 10831165568 11248668672 1901590448 18.839 100 38 76 0 1919295520 7203392 10501680
23:28:20 17274 8192000000 10829266560 11256414208 1906415024 18.878 100 43 83 1 1925390784 7774496 11201264
23:28:45 46259 8192000000 10855491248 11277062144 1915951376 18.954 100 41 81 0 1938543168 11202528 11389264
23:29:44 27461 8192000000 10866084672 11290980352 1928516480 19.055 100 32 64 0 1950871728 13034736 9320512
23:30:18 53158 8192000000 10876780240 11310419968 1942169056 19.164 100 34 68 0 1970739184 16982400 11587728
23:31:21 22563 8192000000 10891396032 11322740736 1948193712 19.212 100 43 86 2 1978418784 17654960 12570112
23:31:51 18417 8192000000 10889505888 11319513088 1950868608 19.233 100 42 82 4 1980788800 17210448 12709744
23:32:20 20545 8192000000 10897480096 11331715072 1959194528 19.300 100 62 122 1 2001510608 23774192 18541888
23:32:51 15258 8192000000 10903368912 11335139328 1962244912 19.324 100 52 104 0 1997532800 20195872 15092016
23:33:16 11747 8192000000 10918919792 11341352960 1966753984 19.360 100 61 122 2 2005690976 21408720 17528272
23:33:42 27312 8192000000 10909288832 11345989632 1968053504 19.370 100 45 90 1 2004041296 22444592 13543200
23:34:34 15698 8192000000 10921414896 11355107328 1975067648 19.426 100 53 106 4 2018569408 26617280 16884480
23:35:27 16539 8192000000 10934266544 11364229120 1983340096 19.491 100 61 120 0 2023750528 22668560 17741872
23:35:57 7883 8192000000 10942139088 11369062400 1986614144 19.517 100 55 109 1 2027102656 23730752 16757760
23:36:11 5014 8192000000 10953740288 11370303488 1989819648 19.542 100 61 120 4 2032010320 23617008 18573664
23:36:23 5440 8192000000 10956960992 11375558656 1994618912 19.580 100 68 131 1 2039647296 24838160 20190224
23:36:36 2102 8192000000 10968148112 11385004032 1999153376 19.616 100 81 163 1 2049973680 25292560 25527744
23:36:49 2416 8192000000 10966913120 11387441152 2000268304 19.625 100 81 162 1 2050590912 26773248 23549360
23:37:00 2498 8192000000 10958912336 11381723136 1996923664 19.598 100 70 139 2 2044690288 26666592 21100032
23:37:10 14700 8192000000 10955569088 11384356864 1995817152 19.590 100 63 126 1 2042746944 27338032 19591760
23:37:33 9459 8192000000 10966953824 11392462848 2001712688 19.636 100 68 134 1 2052404688 29941536 20750464
23:37:51 4090 8192000000 10969122432 11395145728 1999806720 19.621 100 60 120 1 2049642256 30960144 18875392
23:38:06 3495 8192000000 10975660272 11399708672 2008589664 19.690 100 80 161 0 2065931248 31931568 25410016
23:38:18 13406 8192000000 10962166160 11392045056 1999194240 19.616 100 61 122 2 2048524944 29795232 19535472
23:38:43 6109 8192000000 10946846864 11381874688 1977396736 19.444 99 59 117 1 2029940480 33904608 18639136
23:38:56 5565 8192000000 10948860368 11383967744 1993195680 19.569 100 55 110 0 2038609408 28093472 17320256
23:39:09 5025 8192000000 10967140000 11392790528 2002166400 19.640 100 72 144 0 2053676848 28768048 22742400
23:39:21 4722 8192000000 10962906016 11395031040 1999697872 19.620 100 67 133 2 2050056048 30518400 19839776
23:39:35 2765 8192000000 10973667648 11392393216 1985837936 19.511 99 79 157 0 2037927664 28705808 23383920
23:39:45 4428 8192000000 10972940336 11389976576 2000709472 19.628 100 82 165 0 2055123168 29713872 24699824
23:39:58 4784 8192000000 10968683184 11391152128 2000692128 19.628 100 75 147 2 2053686784 30648560 22346096
23:40:11 7504 8192000000 10981645616 11404771328 2008456688 19.689 100 81 162 1 2062816032 30801968 23557376
23:40:27 8620 8192000000 10986211296 11410608128 2015318768 19.743 100 82 163 3 2071616192 31731376 24566048
23:40:43 2422 8192000000 10996420128 11414921216 2020080640 19.781 100 86 173 0 2076372880 31101312 25190928
23:40:52 2992 8192000000 10993083680 11418742784 2027652512 19.840 100 82 162 1 2082854672 31207840 23994320
23:41:02 5164 8192000000 10991379968 11418292224 2022967872 19.803 100 80 159 1 2079144720 32111360 24065488
23:41:20 976 8192000000 11007632272 11428151296 2027938928 19.842 100 78 153 2 2084777872 32888032 23950912
23:41:29 6193 8192000000 10994171552 11422584832 2026256336 19.829 100 76 152 2 2082829088 33368384 23204368
23:41:45 4074 8192000000 11000527968 11424448512 2018725056 19.770 100 76 151 2 2079132224 36902656 23504512
23:42:01 6292 8192000000 11003289456 11426549760 2023983952 19.811 100 77 152 1 2083689312 36669280 23036080
23:42:15 1816 8192000000 11001322192 11432722432 2025548784 19.824 100 77 147 3 2086422192 37377392 23496016
23:42:26 3631 8192000000 11007507216 11432902656 2023956672 19.811 100 75 148 2 2085096672 38880784 22259216
23:42:41 1363 8192000000 11009725360 11427500032 2022711008 19.801 100 85 170 2 2089034384 40357392 25965984
23:42:50 3309 8192000000 11020219616 11436765184 2026418096 19.831 100 80 158 0 2093102640 41873296 24811248
23:43:02 5766 8192000000 10992864736 11418148864 2008270784 19.688 99 72 143 0 2072900752 42204832 22425136
23:43:14 2197 8192000000 11013240528 11430510592 2017989040 19.764 100 87 174 1 2088229712 44256608 25984064
23:43:23 1980 8192000000 11011666432 11435806720 2019837632 19.779 100 83 164 0 2095722352 50188608 25696112
23:43:32 8422 8192000000 11005071424 11431305216 2012457808 19.721 100 81 160 0 2089279584 51358432 25463344
23:43:48 2832 8192000000 11009547984 11435487232 2024287200 19.814 100 85 168 0 2096128960 44613632 27228128
23:43:57 1781 8192000000 11013314976 11432820736 2016281872 19.751 100 83 165 1 2089172064 46359856 26530336
23:44:09 2497 8192000000 10995498432 11414659072 2009029696 19.694 100 87 173 2 2082781952 45807280 27944976
23:44:22 5899 8192000000 11011329984 11435474944 2012561136 19.722 100 76 152 1 2089719920 52554464 24604320
23:44:42 3432 8192000000 10997496416 11423494144 1996142896 19.592 99 86 171 0 2070933216 47071984 27718336
23:44:53 8857 8192000000 11001654288 11434565632 2011126512 19.710 100 69 139 1 2082533040 48770640 22635888
23:45:15 3313 8192000000 10989747328 11432546304 2007392784 19.681 100 56 111 0 2077251264 50441328 19417152
23:45:31 9078 8192000000 11002406592 11436630016 2013924752 19.732 100 56 113 2 2079054816 45496608 19633456
23:45:50 9272 8192000000 10970463952 11405340672 1971638112 19.398 98 54 110 1 2036525872 46779104 18108656
23:46:10 3944 8192000000 10998022208 11428188160 1992489008 19.563 99 67 132 2 2065018336 50167520 22361808
23:46:21 4984 8192000000 10995032928 11426959360 2007367392 19.681 100 68 137 1 2080385408 50303408 22714608
23:46:34 3824 8192000000 10982682192 11404197888 1985610976 19.509 99 87 175 1 2062671344 49738128 27322240
23:46:46 1340 8192000000 11006775968 11421954048 1999696064 19.620 100 93 186 2 2078130176 49223888 29210224
23:46:53 6749 8192000000 10994491456 11417554944 1992952784 19.567 100 73 145 0 2068552752 52590384 23009584
23:47:18 11450 8192000000 10947830592 11381702656 1967075536 19.362 99 57 115 2 2022758080 36981136 18701408
23:47:50 12488 8192000000 10925506224 11358162944 1956874864 19.281 99 45 89 1 2001294192 30073904 14345424
23:48:21 7461 8192000000 10920434832 11358572544 1957030288 19.282 99 52 104 2 2006896656 33020064 16846304
23:48:43 17189 8192000000 10937729104 11388817408 1976647232 19.438 100 38 76 0 2026719520 37895184 12177104
23:49:20 14633 8192000000 10953131888 11398574080 1984271200 19.499 100 32 64 6 2033389344 37987488 11130656
23:49:45 17574 8192000000 10929816976 11381841920 1960565392 19.311 99 32 64 0 2014071712 42115600 11390720
23:50:09 21215 8192000000 10943940656 11400282112 1973321760 19.412 100 34 68 2 2033236304 47163568 12750976
23:50:47 15891 8192000000 10920886272 11373756416 1935365456 19.110 99 26 52 0 1994228720 48660528 10202736
23:51:27 15786 8192000000 10895879776 11349233664 1897472704 18.806 98 21 42 2 1955066624 48732592 8861328
23:51:50 28445 8192000000 10905995504 11357802496 1907425856 18.886 99 26 52 0 1973690336 56579040 9685440
23:52:25 29630 8192000000 10866011184 11334864896 1868578336 18.573 97 23 45 6 1926089040 47979344 9531360
23:53:08 37776 8192000000 10853775328 11309015040 1880982960 18.673 98 17 34 1 1926527584 39666608 5878016
23:53:52 86958 8192000000 10835877440 11299360768 1787644128 17.912 93 4 8 1 1807395536 18491392 1260016
23:55:31 69615 8192000000 10841296432 11294597120 1865932080 18.551 97 23 46 2 1884381808 11648176 6801552
23:57:41 102555 8192000000 10844965376 11310608384 1853219808 18.448 96 34 68 0 1877614000 14630384 9763808
23:59:34 82596 8192000000 10842170656 11300982784 1815299616 18.139 95 16 32 0 1836678368 17231728 4147024
00:01:04 9559 8192000000 10862642832 11303366656 1919328320 18.981 100 41 80 0 1950457920 19832336 11297264
00:01:25 19749 8192000000 10856117968 11305578496 1908827136 18.897 99 16 31 1 1922073600 9219600 4026864
00:01:52 7728 8192000000 10859834848 11320176640 1931716672 19.081 100 13 26 0 1945806832 10365024 3725136
00:02:12 16462 8192000000 10881662768 11323371520 1928052224 19.051 99 34 66 1 1944537440 6573488 9911728
00:02:35 33226 8192000000 10861988704 11319365632 1903162064 18.852 98 33 62 2 1925122912 13095216 8865632
00:03:22 64316 8192000000 10849096576 11320754176 1920951696 18.994 99 5 10 0 1930432464 8503856 976912
00:04:33 145001 8192000000 10889494880 11352203264 1928529760 19.055 98 18 37 0 1943910688 10286832 5094096
00:07:09 49410 8192000000 10899276624 11365515264 1954981248 19.266 99 25 50 0 1977364032 15229808 7152976
00:08:12 39771 8192000000 10880000080 11358666752 1949341520 19.221 99 12 24 0 1967279728 13717024 4221184
00:09:01 56443 8192000000 10892114192 11356766208 1951704704 19.240 99 24 49 1 1972588368 13546208 7337456
00:10:07 37494 8192000000 10906235680 11371388928 1969400544 19.381 100 26 50 0 2002213312 25441392 7371376
00:12:42 62659 8192000000 10894650880 11362652160 1959608768 19.303 99 25 50 0 1977319536 9902192 7808576
00:13:51 59899 8192000000 10927249232 11377971200 1962795664 19.328 99 20 40 1 1975878736 7830368 5252704
00:14:57 59698 8192000000 10909453376 11388166144 1971723760 19.399 99 23 46 1 1987247072 9540288 5983024
00:16:32 39725 8192000000 10935350368 11398467584 1982154192 19.482 99 27 54 1 2006284896 16477024 7653680
00:17:20 43403 8192000000 10944781872 11404034048 1984438272 19.500 99 29 58 1 2014376896 21314064 8624560
00:18:21 93594 8192000000 10944242176 11415150592 1995762256 19.589 100 17 35 0 2020739024 20136032 4840736
00:20:00 58726 8192000000 10953346208 11396755456 1981669952 19.478 99 23 46 0 2005637216 17518768 6448496
00:21:07 34200 8192000000 10928155904 11390169088 1965602432 19.351 98 23 46 1 1981524368 9464624 6457312
00:21:51 58778 8192000000 10939964704 11401211904 1965358512 19.349 98 33 66 1 1986603584 12310656 8934416
00:22:55 77770 8192000000 10923689856 11399208960 1962873744 19.329 98 26 52 0 1985696416 14897808 7924864
00:24:27 66502 8192000000 10934256800 11403644928 1980250000 19.467 99 24 48 1 2004650224 17531840 6868384
00:25:40 119098 8192000000 10919003280 11380088832 1939888160 19.146 97 12 25 1 1955833328 12050176 3894992
00:27:57 57051 8192000000 10941713184 11399913472 1982600496 19.485 99 27 54 1 1999767536 9946992 7220048
00:29:11 44699 8192000000 10953683824 11418398720 1975520480 19.429 98 33 66 0 2003183504 18611344 9051680
00:30:02 32147 8192000000 10925498928 11417059328 1986538032 19.516 99 24 48 0 2022252576 28842176 6872368
00:30:41 28436 8192000000 10909379472 11393368064 1941046400 19.155 97 12 24 0 1964322112 20122624 3153088
00:31:17 49304 8192000000 10910807984 11389743104 1966554512 19.358 98 21 42 2 1988928224 16623168 5750544
00:32:17 55125 8192000000 10905008656 11392245760 1975114976 19.426 99 10 20 0 1990642480 13098592 2428912
00:33:18 56521 8192000000 10902579008 11376386048 1929662304 19.064 97 15 31 0 1941718112 7206448 4849360
00:34:26 37611 8192000000 10890571136 11366596608 1966967680 19.361 99 14 27 0 1979940992 8648352 4324960
00:35:37 75697 8192000000 10932376240 11400368128 1961320352 19.317 98 18 36 0 1977815776 11330592 5164832
00:36:59 36755 8192000000 10914892384 11390484480 1976574224 19.438 99 23 46 0 1995506368 12081520 6850624
00:38:00 107526 8192000000 10883064912 11353067520 1844599520 18.378 93 12 24 0 1861028080 12749440 3679120
00:39:55 38343 8192000000 10870104240 11343011840 1914700608 18.944 98 11 22 0 1927187824 9461360 3025856
00:40:40 28735 8192000000 10894757888 11342118912 1924541792 19.023 98 41 82 1 1946531360 9632064 12357504
00:41:19 64890 8192000000 10849942512 11316801536 1853704624 18.452 95 23 46 2 1871118288 11035472 6378192
00:43:30 127989 8192000000 10859112592 11322945536 1813463840 18.124 93 18 36 0 1830184608 11382560 5338208
00:45:46 40645 8192000000 10883745248 11346538496 1931517328 19.079 99 27 53 0 1951731840 12594672 7619840
00:46:40 54040 8192000000 10847059264 11328565248 1847916336 18.405 95 15 30 0 1867446176 15333312 4196528
00:47:55 108474 8192000000 10855277632 11322466304 1878808096 18.655 97 14 28 0 1894554160 12110688 3635376
00:50:26 80963 8192000000 10872836704 11333791744 1886091856 18.714 97 31 62 0 1907257856 12554240 8611760
00:51:53 30274 8192000000 10892657984 11345465344 1944401408 19.182 100 39 76 2 1971065776 16376832 10287536
00:52:30 27969 8192000000 10852365536 11309006848 1914786720 18.945 98 44 88 0 1940741568 13800240 12154608
00:53:07 78949 8192000000 10864391920 11351044096 1944296112 19.181 100 21 42 0 1960812240 10681072 5835056
00:54:32 46241 8192000000 10867961840 11345588224 1932605088 19.088 99 8 16 1 1945542848 10873136 2064624
00:55:25 42446 8192000000 10847212800 11318616064 1867881888 18.567 96 14 28 1 1878560608 6689360 3989360
00:56:14 72644 8192000000 10846305024 11314909184 1876644800 18.638 97 13 26 0 1890982800 10822512 3515488
00:57:33 51671 8192000000 10852880752 11327823872 1937487904 19.127 100 9 18 0 1949438160 10054128 1896128
00:58:30 60850 8192000000 10864395248 11347099648 1914448544 18.942 98 14 28 1 1926657712 8148304 4060864
00:59:41 42607 8192000000 10863351872 11339431936 1926521280 19.039 99 2 4 0 1936382032 9722352 138400
01:00:42 73886 8192000000 10903710912 11371048960 1966085312 19.354 100 17 34 0 1984436656 13370256 4981088
01:02:03 44839 8192000000 10912115872 11383918592 1983868544 19.495 100 27 53 1 2004796800 13195008 7733248
01:02:58 70644 8192000000 10900298464 11393167360 1963612928 19.335 99 13 26 1 1985741584 17567920 4560736
01:04:18 39082 8192000000 10902695680 11362676736 1925474336 19.031 97 38 76 1 1949875936 13576096 10825504
01:05:10 37090 8192000000 10900124224 11373056000 1941146208 19.156 98 33 65 1 1960338496 10355872 8836416
01:05:55 45487 8192000000 10911249792 11376795648 1957642928 19.287 99 23 46 3 1974589408 10002912 6943568
01:06:47 25281 8192000000 10922346400 11383717888 1986336496 19.515 100 48 96 1 2009457248 9514464 13606288
01:07:24 48189 8192000000 10899010944 11369762816 1955162512 19.268 99 26 52 0 1972728048 10653552 6911984
01:08:18 17310 8192000000 10899195648 11354628096 1950862352 19.233 99 40 79 0 1969503296 7812288 10828656
01:08:55 31113 8192000000 10917316144 11372236800 1971394288 19.397 100 42 84 3 1994111696 11094832 11622576
01:09:36 80975 8192000000 10924969312 11386920960 1983589584 19.493 100 34 68 2 2006316656 13315376 9411696
01:11:03 37516 8192000000 10916669568 11381923840 1949841472 19.225 98 24 48 0 1970640304 13992640 6806192
01:11:51 52541 8192000000 10909136240 11398017024 1963169696 19.331 99 24 48 0 1985076960 14818992 7088272
01:12:52 156059 8192000000 10894425312 11369082880 1917456864 18.966 97 11 22 0 1933131280 12791968 2882448
01:15:34 146105 8192000000 10887955936 11375562752 1946011504 19.195 98 16 32 0 1964847200 14087984 4747712
01:18:08 89766 8192000000 10881718208 11355295744 1906403840 18.878 97 12 23 1 1926382592 16238064 3740688
01:20:06 60567 8192000000 10906492704 11380326400 1973208320 19.411 100 14 28 0 1994178592 16972432 3997840
01:21:13 55615 8192000000 10890762656 11362410496 1864598608 18.541 94 26 52 1 1888618880 16465568 7554704
01:22:35 80569 8192000000 10881844224 11365789696 1884060832 18.698 96 11 22 1 1905107264 17363504 3682928
01:24:17 44013 8192000000 10883764336 11352428544 1905858528 18.873 97 28 56 3 1921895712 8258336 7778848
01:25:23 35540 8192000000 10902332400 11363647488 1949946928 19.226 99 49 98 0 1977403392 13743984 13712480
01:26:07 40160 8192000000 10902578928 11371577344 1964692864 19.343 100 31 62 1 1989046096 15559568 8793664

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 02-02-2021 01:28:22 to 02-02-2021 01:28:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 132 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-02-2021 01:28:53 to 02-02-2021 01:28:55.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          236617
MON$OLDEST_ACTIVE               237329
MON$OLDEST_SNAPSHOT             237329
MON$NEXT_TRANSACTION            237329
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                       2006208
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.33411 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33411 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33411 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33411 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 ---
:53: 
:54: mscs-test-161.budzdorov.ru    Tue Feb  2 01:27:28 2021
:55:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:56: 
--- end of diff output ---

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

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