Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.02.2021 22: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 17022208 kB
MemAvailable 31195928 kB
Buffers 0 kB
Cached 14700792 kB
SwapCached 4724 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-14 22:27:16
DTS_END                         2021-02-14 22:27:16.2960
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/51556
TRN_ID                          230686
ATT_ID                          677
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: 9108.68 22158 1093042
customer order: creation 160.67 397 19280
customer order: refuse 13.23 318 1587
order to supplier: creation 42.64 1282 5117
order to supplier: removal 3.53 104674 424
invoice (draft): creation 42.54 3336 5105
invoice (draft): removal 53.98 806 6478
invoice accept: apply 39.07 17997 4688
invoice accept: cancel 49.01 800 5881
customer reserve: creation 3596.14 178 431537
customer reserve: removal 4815.58 60 577870
realization accept: apply 78.99 180 9479
realization accept: cancel 92.86 112 11143
payment from customer: creation 55.26 103 6631
payment from customer: removal 5.22 65 626
payment to supplier: creation 45.85 128 5502
payment to supplier: removal 3.19 93 383
service: total inventory turnovers 4.18 1349 501
service: total monetary turnovers 5.97 48 716
service: aggregate perf. data 0.75 24032 90
service: refresh index statistics 0.03 287209 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-02-2021 22:29:08 to 14-02-2021 22:29:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4350
TEST_TIME 2 5805
TEST_TIME 3 5214
TEST_TIME 4 5264
TEST_TIME 5 4855
TEST_TIME 6 4723
TEST_TIME 7 4711
TEST_TIME 8 4791
TEST_TIME 9 5080
TEST_TIME 10 5090
TEST_TIME 11 5388
TEST_TIME 12 5698
TEST_TIME 13 6005
TEST_TIME 14 6361
TEST_TIME 15 6264
TEST_TIME 16 6479
TEST_TIME 17 7022
TEST_TIME 18 7251
TEST_TIME 19 7764
TEST_TIME 20 8130
TEST_TIME 21 8289
TEST_TIME 22 8823
TEST_TIME 23 8922
TEST_TIME 24 9082
TEST_TIME 25 9480
TEST_TIME 26 9758
TEST_TIME 27 10003
TEST_TIME 28 10299
TEST_TIME 29 10707
TEST_TIME 30 10675
TEST_TIME 31 10582
TEST_TIME 32 10515
TEST_TIME 33 10352
TEST_TIME 34 10051
TEST_TIME 35 10247
TEST_TIME 36 10205
TEST_TIME 37 10007
TEST_TIME 38 9899
TEST_TIME 39 9863
TEST_TIME 40 9822
TEST_TIME 41 9682
TEST_TIME 42 9887
TEST_TIME 43 9873
TEST_TIME 44 9781
TEST_TIME 45 9641
TEST_TIME 46 9600
TEST_TIME 47 9561
TEST_TIME 48 9660
TEST_TIME 49 9610
TEST_TIME 50 9565
TEST_TIME 51 9554
TEST_TIME 52 9485
TEST_TIME 53 9473
TEST_TIME 54 9538
TEST_TIME 55 9560
TEST_TIME 56 9701
TEST_TIME 57 9674
TEST_TIME 58 9711
TEST_TIME 59 9617
TEST_TIME 60 9744
TEST_TIME 61 9851
TEST_TIME 62 9946
TEST_TIME 63 9897
TEST_TIME 64 9819
TEST_TIME 65 9796
TEST_TIME 66 9771
TEST_TIME 67 9715
TEST_TIME 68 9726
TEST_TIME 69 9646
TEST_TIME 70 9586
TEST_TIME 71 9575
TEST_TIME 72 9516
TEST_TIME 73 9531
TEST_TIME 74 9436
TEST_TIME 75 9430
TEST_TIME 76 9384
TEST_TIME 77 9335
TEST_TIME 78 9311
TEST_TIME 79 9338
TEST_TIME 80 9326
TEST_TIME 81 9275
TEST_TIME 82 9258
TEST_TIME 83 9288
TEST_TIME 84 9321
TEST_TIME 85 9341
TEST_TIME 86 9431
TEST_TIME 87 9452
TEST_TIME 88 9449
TEST_TIME 89 9464
TEST_TIME 90 9466
TEST_TIME 91 9503
TEST_TIME 92 9408
TEST_TIME 93 9348
TEST_TIME 94 9384
TEST_TIME 95 9327
TEST_TIME 96 9297
TEST_TIME 97 9287
TEST_TIME 98 9327
TEST_TIME 99 9314
TEST_TIME 100 9318
TEST_TIME 101 9321
TEST_TIME 102 9349
TEST_TIME 103 9400
TEST_TIME 104 9365
TEST_TIME 105 9395
TEST_TIME 106 9368
TEST_TIME 107 9410
TEST_TIME 108 9429
TEST_TIME 109 9493
TEST_TIME 110 9488
TEST_TIME 111 9409
TEST_TIME 112 9359
TEST_TIME 113 9350
TEST_TIME 114 9315
TEST_TIME 115 9273
TEST_TIME 116 9237
TEST_TIME 117 9225
TEST_TIME 118 9214
TEST_TIME 119 9178
TEST_TIME 120 9117

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 14-02-2021 22:29:11 to 14-02-2021 22:29: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 1493833 1493833 0 0.00 0 19194 6 0 0
doc_list_biud 1493831 1493831 0 0.00 0 33784 30 0 0
sp_add_invoice_to_stock 4795 4688 107 2.23 56 249020 17997 0 107
sp_cancel_adding_invoice 5881 5881 0 0.00 4 54527 800 0 0
sp_cancel_client_order 1587 1587 0 0.00 4 5000 319 0 0
sp_cancel_customer_reserve 577870 577870 0 0.00 1 34165 61 0 0
sp_cancel_pay_from_customer 626 626 0 0.00 3 5539 65 0 0
sp_cancel_pay_to_supplier 383 383 0 0.00 3 9339 93 0 0
sp_cancel_supplier_invoice 6489 6478 11 0.16 2 26222 807 0 11
sp_cancel_supplier_order 424 424 0 0.00 12 894592 104675 0 0
sp_cancel_write_off 11143 11143 0 0.00 1 24370 113 0 0
sp_client_order 19280 19280 0 0.00 4 22432 397 0 0
sp_customer_reserve 431537 431537 0 0.00 0 182679 179 0 0
sp_fill_shopping_cart 29495 29495 0 0.00 1 11504 38 0 0
sp_fill_shopping_cart_clo_res 431525 431525 0 0.00 0 18909 15 0 0
sp_get_clo_for_invoice 4674 4674 0 0.00 0 24749 310 0 0
sp_kill_cost_storno 18033 18033 0 0.00 0 19174 55 0 0
sp_kill_qstorno_ret_qs2qd 1173785 1173785 0 0.00 0 27066 33 0 0
sp_kill_qty_storno 617536 617536 0 0.00 0 33783 71 0 0
sp_lock_selected_doc 19553 19553 0 0.00 0 8259 5 0 0
sp_make_cost_storno 26286 26286 0 0.00 0 14605 51 0 0
sp_multiply_rows_for_pdistr 26286 26286 0 0.00 0 7094 28 0 0
sp_multiply_rows_for_qdistr 19280 19280 0 0.00 0 22423 182 0 0
sp_pay_from_customer 6631 6631 0 0.00 4 19235 103 0 0
sp_pay_to_supplier 5502 5502 0 0.00 5 26085 128 0 0
sp_payment_common 12133 12133 0 0.00 2 26037 32 0 0
sp_qd_handle_on_cancel_clo 1587 1587 0 0.00 0 4993 298 0 0
sp_qd_handle_on_invoice_upd_sts 10555 10555 0 0.00 0 33781 346 0 0
sp_qd_handle_on_reserve_upd_sts 9479 9479 0 0.00 0 16192 68 0 0
sp_reserve_write_off 9479 9479 0 0.00 6 16247 180 0 0
sp_supplier_invoice 5105 5105 0 0.00 8 69804 3337 0 0
sp_supplier_order 5117 5117 0 0.00 6 50744 1282 0 0
srv_aggregate_perf_data 90 90 0 0.00 3011 411962 24033 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 431 176243 34807 0 0
srv_find_qd_qs_mism 1049117 1049117 0 0.00 0 19013 4 0 0
srv_make_invnt_saldo 501 501 0 0.00 44 60620 1350 0 0
srv_make_money_saldo 716 716 0 0.00 1 11712 48 0 0
srv_recalc_idx_stat 4 4 0 0.00 190126 422518 287209 0 0
t$perf-abend:sp_add_invoice_to_stock 107 107 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4688 4688 0 0.00 0 15607 197 0 0
t$perf-norm:sp_cancel_adding_invoice 403 403 0 0.00 0 9349 122 0 0
t$perf-norm:sp_cancel_client_order 1587 1587 0 0.00 0 8279 19 0 0
t$perf-norm:sp_cancel_customer_reserve 671 671 0 0.00 0 3859 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 626 626 0 0.00 0 4905 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 383 383 0 0.00 0 2705 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 390 390 0 0.00 0 635 15 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 25337 1849 0 0
t$perf-norm:sp_cancel_write_off 917 917 0 0.00 0 7618 25 0 0
t$perf-norm:sp_client_order 19281 19281 0 0.00 0 13758 20 0 0
t$perf-norm:sp_customer_reserve 937 937 0 0.00 0 10937 22 0 0
t$perf-norm:sp_pay_from_customer 6631 6631 0 0.00 0 9975 17 0 0
t$perf-norm:sp_pay_to_supplier 5502 5502 0 0.00 0 9869 14 0 0
t$perf-norm:sp_reserve_write_off 9479 9479 0 0.00 0 12804 18 0 0
t$perf-norm:sp_supplier_invoice 5105 5105 0 0.00 0 11705 29 0 0
t$perf-norm:sp_supplier_order 5117 5117 0 0.00 0 9942 19 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 1371 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 784 14 0 0
t$perf-norm:srv_make_invnt_saldo 501 501 0 0.00 0 6260 38 0 0
t$perf-norm:srv_make_money_saldo 716 716 0 0.00 0 8820 33 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 9560 9346 214 2.23 0 12486 17 0 214
v_all_customers 35332 35332 0 0.00 0 53 1 0 0
v_all_suppliers 28478 28478 0 0.00 0 111 1 0 0
v_all_wares 38560 38560 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 806 806 0 0.00 0 181 6 0 0
v_cancel_client_order 3174 3174 0 0.00 0 882 4 0 0
v_cancel_customer_prepayment 1252 1252 0 0.00 0 2198 6 0 0
v_cancel_customer_reserve 1342 1342 0 0.00 0 1287 4 0 0
v_cancel_payment_to_supplier 766 766 0 0.00 0 850 4 0 0
v_cancel_supplier_invoice 802 780 22 2.74 0 1204 16 0 22
v_cancel_supplier_order 848 848 0 0.00 0 1203 5 0 0
v_cancel_write_off 1834 1834 0 0.00 0 1008 12 0 0
v_max_id_clo_ord 5114 5114 0 0.00 0 1203 1 0 0
v_max_id_clo_res 937 937 0 0.00 0 2162 14 0 0
v_max_id_ord_sup 5101 5101 0 0.00 0 4507 4 0 0
v_max_non_paid_invoice 1478 1478 0 0.00 0 175 2 0 0
v_max_non_paid_realizn 3427 3427 0 0.00 0 4528 7 0 0
v_min_id_clo_ord 5114 5114 0 0.00 0 7904 11 0 0
v_min_id_clo_res 937 937 0 0.00 0 14957 30 0 0
v_min_id_ord_sup 5101 5101 0 0.00 0 5674 5 0 0
v_min_non_paid_invoice 5502 5502 0 0.00 0 14067 21 0 0
v_min_non_paid_realizn 6631 6631 0 0.00 0 7204 12 0 0
v_our_firm 9636 9636 0 0.00 0 54 1 0 0
v_reserve_write_off 18958 18958 0 0.00 0 3507 4 0 0
x_lock_depdocs_on_canc_invoice 11969 11969 0 0.00 0 24222 129 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 10092 346 0 0
x_make_qstorno_1000_1200 5117 5117 0 0.00 2 50734 1197 0 0
x_make_qstorno_1200_2000 5105 5105 0 0.00 4 69756 3208 0 0
x_make_qstorno_2100_3300 431536 431536 0 0.00 0 182675 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-02-2021 22:29:16 to 14-02-2021 22:29: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
19:57:20 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:26 6802 8192000000 9975358976 10233540608 749890672 8.386 61 46 99 0 768299216 2313472 16095072
19:57:41 16141 8192000000 10272692880 10585149440 1332595520 13.991 100 76 152 0 1361905328 3934144 25375664
19:58:07 31734 8192000000 10359453072 10679234560 1402804336 14.620 100 81 163 1 1434329824 5155264 26370224
19:58:49 25596 8192000000 10391985584 10713931776 1446703584 15.009 100 87 174 0 1481976848 6842768 28430496
19:59:26 29024 8192000000 10419457200 10745905152 1472494336 15.236 100 92 184 0 1510450048 7796624 30159088
20:00:10 30075 8192000000 10448424912 10777972736 1489546528 15.385 100 91 182 0 1528035808 9001616 29487664
20:00:49 21389 8192000000 10465581856 10800521216 1512966288 15.589 100 88 176 1 1550806848 9616528 28224032
20:01:19 9950 8192000000 10479485872 10816700416 1531507552 15.750 100 87 174 0 1568948032 9914816 27525664
20:01:40 13783 8192000000 10491257040 10838560768 1551620368 15.924 100 80 160 0 1587900912 10801696 25478848
20:02:07 11902 8192000000 10523180176 10873307136 1577656112 16.148 100 80 160 0 1613514592 11127200 24731280
20:02:28 11850 8192000000 10550469200 10902695936 1607657056 16.405 100 79 158 0 1643176800 11635904 23883840
20:02:48 11394 8192000000 10562723968 10919526400 1623528240 16.540 100 82 164 1 1659878144 11686240 24663664
20:03:09 10925 8192000000 10584122464 10948861952 1642946256 16.705 100 77 153 0 1677726432 11678832 23101344
20:03:29 11563 8192000000 10617041392 10975903744 1672663456 16.956 100 83 165 0 1708639536 11828144 24147936
20:03:51 7970 8192000000 10634198928 11000651776 1694514992 17.139 100 82 164 1 1730713744 12270704 23928048
20:04:07 11493 8192000000 10635456528 11010269184 1700735360 17.191 100 76 152 1 1734911600 12030224 22146016
20:04:26 6048 8192000000 10655038992 11025960960 1720844640 17.359 100 80 160 0 1756109632 12647696 22617296
20:04:42 6891 8192000000 10678284768 11051200512 1735318304 17.480 100 79 158 1 1772024992 13717728 22988960
20:04:57 6143 8192000000 10688056640 11063070720 1746468016 17.572 100 80 158 0 1781100256 12729648 21902592
20:05:09 6106 8192000000 10693471040 11068882944 1751716288 17.616 100 84 168 1 1788747360 12961424 24069648
20:05:23 5025 8192000000 10697787952 11072212992 1760584960 17.689 100 86 174 0 1797963552 12797312 24581280
20:05:34 5216 8192000000 10705463408 11084627968 1765942992 17.734 100 74 148 0 1799644672 13127296 20574384
20:05:47 4576 8192000000 10714337104 11090288640 1775833760 17.815 100 87 175 0 1814402896 13874832 24694304
20:05:59 3057 8192000000 10734110224 11108986880 1786303184 17.901 100 88 174 1 1823228144 12171920 24753040
20:06:08 3321 8192000000 10729879184 11111567360 1796600656 17.986 100 79 159 1 1831826480 12919952 22305872
20:06:18 3952 8192000000 10742309584 11121254400 1800273552 18.016 100 86 173 1 1836862112 13063376 23525184
20:06:29 2638 8192000000 10753669488 11129073664 1808786064 18.086 100 93 184 0 1848927008 14766560 25374384
20:06:38 2698 8192000000 10757266640 11136479232 1810497264 18.100 100 92 185 1 1851327920 14981424 25849232
20:06:48 8254 8192000000 10758235680 11142582272 1815778992 18.143 100 84 166 1 1853650592 15063888 22807712
20:07:03 5154 8192000000 10775661504 11159519232 1820816640 18.184 100 89 177 0 1860470896 15231136 24423120
20:07:14 2562 8192000000 10786815984 11168423936 1836388496 18.311 100 83 166 1 1874790960 14307216 24095248
20:07:23 1398 8192000000 10782580688 11166167040 1842464480 18.361 100 93 187 0 1882970304 14476928 26028896
20:07:31 1665 8192000000 10788768304 11172589568 1847998288 18.406 100 90 181 0 1887891728 14154800 25738640
20:07:39 2563 8192000000 10781327056 11171799040 1849290304 18.416 100 89 177 1 1887278000 12222224 25765472
20:07:49 1641 8192000000 10799112400 11184435200 1854639568 18.460 100 92 181 1 1891907104 12003344 25264192
20:07:57 1838 8192000000 10798403920 11185487872 1861276704 18.514 100 93 186 0 1898789056 11902192 25610160
20:08:06 2510 8192000000 10814635072 11199639552 1864646304 18.541 100 92 182 2 1903604432 13178384 25779744
20:08:14 1947 8192000000 10816644256 11203080192 1866584880 18.557 100 87 170 2 1902508608 11750864 24172864
20:08:23 1673 8192000000 10802482240 11192840192 1868042960 18.568 100 80 160 3 1901843616 11284768 22515888
20:08:31 1770 8192000000 10816348160 11208003584 1879220144 18.659 100 91 183 2 1921991424 17128720 25642560
20:08:39 21671 8192000000 10806998416 11200163840 1867930352 18.568 100 64 127 0 1896555328 10876752 17748224
20:09:07 976 8192000000 10822287536 11210829824 1878655504 18.654 100 88 176 0 1916058944 12246224 25157216
20:09:20 14653 8192000000 10786605264 11200794624 1868007952 18.568 100 35 70 1 1885577376 7160400 10409024
20:09:41 5276 8192000000 10797673856 11210371072 1874911344 18.624 100 46 92 0 1901032848 13506560 12614944
20:09:53 5465 8192000000 10795977200 11207073792 1877537552 18.645 100 41 82 3 1897109776 7932064 11640160
20:10:05 6238 8192000000 10788564032 11211673600 1873528304 18.613 100 22 44 0 1886153328 6684288 5940736
20:10:17 4562 8192000000 10790659328 11209940992 1877803744 18.647 100 39 78 1 1897254848 8046272 11404832
20:10:30 6507 8192000000 10788256400 11212890112 1880729312 18.671 100 32 64 4 1896465856 6783424 8953120
20:10:43 10581 8192000000 10790197856 11215425536 1881094576 18.674 100 25 50 0 1894109264 5847104 7167584
20:11:00 7555 8192000000 10786023008 11215077376 1883268704 18.691 100 20 40 1 1894791040 5868944 5653392
20:11:16 12503 8192000000 10792932368 11222224896 1883336800 18.692 100 16 32 1 1893064464 5652128 4075536
20:11:36 14274 8192000000 10793061536 11225481216 1887826384 18.728 100 11 22 1 1896601664 5666896 3108384
20:11:59 9286 8192000000 10793993744 11227627520 1891935904 18.761 100 18 36 1 1903182880 6264272 4982704
20:12:18 7994 8192000000 10797935776 11230994432 1893930080 18.777 100 21 40 2 1906496688 6454192 6112416
20:12:36 10406 8192000000 10799083344 11229138944 1894779504 18.784 100 25 48 3 1907288272 6557600 5951168
20:12:53 59322 8192000000 10811395664 11240259584 1897454992 18.806 100 29 59 3 1911345776 5678160 8212624
20:13:59 21268 8192000000 10814132000 11245834240 1901129808 18.835 100 26 52 0 1915038960 6751328 7157824
20:14:30 7440 8192000000 10810668512 11240603648 1883531808 18.694 99 33 66 1 1899726064 7246160 8948096
20:14:48 7454 8192000000 10833268896 11251511296 1901844864 18.841 100 38 76 1 1920167440 7300736 11021840
20:15:03 5328 8192000000 10830516496 11254013952 1904460368 18.862 100 27 52 2 1918579856 6294064 7825424
20:15:15 6672 8192000000 10795225856 11229671424 1884148368 18.699 99 27 54 2 1898932256 7103232 7680656
20:15:30 5055 8192000000 10806957072 11242373120 1899495152 18.822 100 21 42 0 1912038672 6642032 5901488
20:15:43 7451 8192000000 10818023168 11252449280 1900265568 18.828 100 20 40 2 1914956816 9482160 5209088
20:15:57 6756 8192000000 10811363232 11238887424 1881516912 18.677 99 21 42 0 1894677264 6688096 6472256
20:16:11 11188 8192000000 10805453984 11233513472 1863728512 18.533 98 28 55 1 1877670224 5585856 8355856
20:16:29 9598 8192000000 10813630288 11244810240 1896115536 18.795 100 21 42 1 1908122160 6056128 5950496
20:16:47 7976 8192000000 10808116544 11238891520 1880213056 18.667 99 25 50 1 1892724624 5302960 7208608
20:17:02 8431 8192000000 10817991632 11249831936 1901704112 18.840 100 17 33 1 1912152336 5585248 4862976
20:17:17 9505 8192000000 10797329728 11235864576 1868639424 18.573 98 20 40 2 1879072288 5022384 5410480
20:17:34 36178 8192000000 10771173328 11205095424 1782343088 17.869 94 24 48 0 1794056288 5117376 6595824
20:18:33 36329 8192000000 10741259504 11165728768 1705642816 17.232 91 18 35 2 1715464512 4919280 4902416
20:19:16 5320 8192000000 10729457696 11141513216 1784306048 17.885 97 23 46 0 1796914720 5896272 6712400
20:19:29 3630 8192000000 10759445728 11169902592 1808001824 18.080 98 50 100 1 1830949424 9320144 13627456
20:19:41 7753 8192000000 10729708800 11135856640 1718757760 17.342 94 25 50 1 1732032720 5326800 7948160
20:19:56 6569 8192000000 10720808112 11130114048 1785166048 17.892 99 45 90 0 1805789440 7000640 13622752
20:20:12 9766 8192000000 10675208272 11083739136 1688357360 17.088 94 31 61 1 1703205952 5751168 9097424
20:20:31 9261 8192000000 10677157328 11082354688 1680165040 17.019 95 33 66 4 1695469968 5139392 10165536
20:20:48 7061 8192000000 10695213920 11105406976 1747083728 17.577 98 16 29 2 1756434592 5016544 4334320
20:21:02 5262 8192000000 10708966368 11123728384 1789568576 17.928 100 23 46 1 1801897632 5638992 6690064
20:21:16 7608 8192000000 10707058400 11126185984 1766693216 17.740 98 32 64 0 1781869152 5393488 9782448
20:21:30 6326 8192000000 10683246144 11099480064 1759664496 17.682 99 28 56 0 1773904720 5807024 8433200
20:21:45 11184 8192000000 10715843696 11133812736 1798411184 18.001 100 19 38 2 1809529056 5086336 6031536
20:22:03 11246 8192000000 10726124976 11150917632 1797837664 17.996 99 21 42 2 1810515920 6063488 6614768
20:22:22 12210 8192000000 10722973248 11142078464 1793765888 17.963 99 22 44 3 1806286016 5353984 7166144
20:22:43 52296 8192000000 10761022720 11169812480 1828029424 18.243 100 27 52 1 1842052176 6437424 7585328
20:23:58 15485 8192000000 10752287408 11175743488 1836836576 18.315 100 22 45 1 1849798768 6294992 6667200
20:24:21 10501 8192000000 10754715808 11176091648 1836383680 18.311 100 26 52 0 1849594736 5148800 8062256
20:24:38 6603 8192000000 10757802656 11180441600 1842220944 18.359 100 26 52 1 1856861712 6705664 7935104
20:24:53 8408 8192000000 10759221808 11182354432 1843159376 18.367 100 20 40 0 1854574112 5572560 5842176
20:25:09 6779 8192000000 10768577680 11194118144 1849554416 18.419 100 29 55 1 1863402512 5944016 7904080
20:25:24 7302 8192000000 10770215728 11194294272 1852514928 18.443 100 31 62 2 1868001344 5976928 9509488
20:25:39 11450 8192000000 10779928464 11198496768 1854127712 18.456 100 17 34 1 1864392752 5402976 4862064
20:25:58 11634 8192000000 10776682960 11200610304 1857940992 18.487 100 20 40 5 1869191392 5355328 5895072
20:26:19 16593 8192000000 10784747904 11211915264 1866441856 18.555 100 27 54 1 1880180320 5617488 8120976
20:26:41 12566 8192000000 10784641792 11211628544 1865657120 18.549 100 15 30 0 1875244016 5571968 4014928
20:27:00 8323 8192000000 10802366576 11228831744 1875942400 18.632 100 14 28 1 1884957120 5257920 3756800
20:27:17 7933 8192000000 10826459088 11248066560 1897550592 18.807 100 26 50 1 1909840960 5524592 6765776
20:27:32 19960 8192000000 10844899872 11261906944 1895319248 18.789 99 59 119 0 1918882400 7421984 16141168
20:28:05 74097 8192000000 10838113952 11267923968 1915843120 18.954 100 44 88 0 1936563584 8389600 12330864
20:29:29 13566 8192000000 10856392480 11279626240 1925010736 19.027 100 57 113 3 1949197760 7786880 16400144
20:29:51 37022 8192000000 10853426384 11286343680 1929846224 19.066 100 34 67 1 1946583776 7474992 9262560
20:30:37 11859 8192000000 10867142032 11300003840 1940618624 19.152 100 41 81 4 1960894704 8173088 12102992
20:30:58 9713 8192000000 10866484752 11303350272 1942963520 19.170 100 35 68 1 1961901312 8899440 10038352
20:31:18 73106 8192000000 10881790288 11329339392 1958371296 19.293 100 34 67 1 1981176032 12957360 9847376
20:32:43 21949 8192000000 10908357536 11340206080 1954301968 19.261 99 40 80 2 1984920464 18589840 12028656
20:33:20 19534 8192000000 10919956208 11354591232 1981107408 19.473 100 52 104 3 2014049232 17171056 15770768
20:33:48 12524 8192000000 10916238384 11352088576 1969764368 19.384 99 56 111 1 2005122608 17811376 17546864
20:34:14 19262 8192000000 10923572480 11361652736 1986691008 19.518 100 41 82 0 2015613424 16692944 12229472
20:34:40 8561 8192000000 10939683360 11367407616 1990244976 19.546 100 54 104 3 2022428192 16942368 15240848
20:34:56 12502 8192000000 10943532400 11373428736 1996023232 19.591 100 57 109 0 2030895056 18486880 16384944
20:35:17 9614 8192000000 10950545952 11385950208 2002652544 19.644 100 52 104 0 2039829200 21701760 15474896
20:35:42 9737 8192000000 10947229600 11386978304 2007590624 19.683 100 49 98 0 2044150432 21733264 14826544
20:36:01 12590 8192000000 10956692352 11391107072 1990928944 19.551 99 52 104 0 2030100992 23208272 15963776
20:36:22 6510 8192000000 10965553024 11398737920 2010429552 19.705 100 58 116 0 2053706480 26040624 17236304
20:36:40 6177 8192000000 10942553744 11376095232 1986219776 19.514 99 58 115 3 2028138256 24583472 17335008
20:36:54 17834 8192000000 10961505904 11398631424 2007602000 19.683 100 53 106 0 2050614208 26269680 16742528
20:37:20 16685 8192000000 10968118432 11408338944 2016942560 19.756 100 51 100 2 2058925120 26454832 15527728
20:37:45 6188 8192000000 10990193280 11415404544 2023760992 19.810 100 59 117 2 2070123808 28955536 17407280
20:37:59 3279 8192000000 11004635120 11428061184 2034420192 19.893 100 86 173 3 2091368880 30886688 26062000
20:38:09 3937 8192000000 11004248640 11427139584 2037066688 19.914 100 78 155 0 2092588752 32365840 23156224
20:38:23 7649 8192000000 11006244720 11432280064 2034736592 19.896 100 69 137 1 2088426656 32813648 20876416
20:38:37 11397 8192000000 11002890528 11434708992 2037381888 19.916 100 65 130 1 2091859632 34862688 19615056
20:38:56 2077 8192000000 11002515808 11421478912 2025097328 19.820 100 78 145 2 2080659952 33499168 22063456
20:39:05 3580 8192000000 11002384112 11428429824 2032504576 19.878 100 77 153 1 2088166928 32512176 23150176
20:39:16 3100 8192000000 11007693968 11428552704 2032565104 19.879 100 77 152 2 2088038960 32562880 22910976
20:39:26 4071 8192000000 10989845504 11410182144 2017834272 19.763 99 84 168 1 2076406320 33379744 25192304
20:39:39 2440 8192000000 10983618720 11403325440 2000633504 19.628 99 73 146 3 2057887968 34732848 22521616
20:39:50 4570 8192000000 10986538016 11414667264 2016246480 19.751 100 78 155 2 2075779168 36051280 23481408
20:40:12 2979 8192000000 10975770736 11404890112 1985296256 19.507 99 69 136 2 2040918768 34637664 20984848
20:40:23 10650 8192000000 10975289664 11399036928 2005344304 19.665 100 61 121 1 2059492224 35416304 18731616
20:40:42 7275 8192000000 10960153728 11387297792 1988154032 19.529 100 61 123 2 2042939856 35724576 19061248
20:40:58 9377 8192000000 10959031312 11385503744 1963608128 19.335 98 57 115 1 2019500912 37717568 18175216
20:41:15 2360 8192000000 10977653552 11405447168 2007722800 19.684 100 69 138 0 2067358016 38093920 21541296
20:41:24 2438 8192000000 10992331680 11408637952 2009909552 19.701 100 90 179 2 2074191008 37209744 27071712
20:41:33 3838 8192000000 10994383840 11417915392 2019173488 19.774 100 80 160 2 2080714624 37755888 23785248
20:41:46 3980 8192000000 10990818832 11416129536 2012452672 19.721 100 71 142 0 2072668928 38422272 21793984
20:41:57 3315 8192000000 10992520208 11413352448 2009713696 19.699 100 84 167 2 2073572432 38708176 25150560
20:42:06 2498 8192000000 10992548752 11413909504 2010643728 19.707 100 86 170 0 2076276304 39365472 26267104
20:42:20 7127 8192000000 10968771120 11391410176 1990282336 19.546 99 71 143 0 2053281440 41467216 21531888
20:42:44 6516 8192000000 10971471664 11398918144 1990154704 19.545 100 65 124 0 2053796336 43426416 20215216
20:43:02 3424 8192000000 10964130320 11391447040 1982340736 19.483 100 67 134 0 2048514080 44655936 21517408
20:43:30 4176 8192000000 10951205312 11383754752 1963993936 19.338 99 63 126 1 2027633568 43964576 19675056
20:43:42 5223 8192000000 10972177120 11401408512 1992143280 19.561 100 66 131 0 2058215040 45643792 20427968
20:43:59 5444 8192000000 10962726528 11387703296 1964630832 19.343 99 71 142 1 2035178736 47112624 23435280
20:44:13 2628 8192000000 10979170848 11392446464 1984478848 19.500 100 88 175 0 2059957488 48710976 26767664
20:44:28 5538 8192000000 10936080176 11374718976 1957980560 19.290 99 55 110 1 2022853824 46534784 18338480
20:44:42 13642 8192000000 10929448928 11369029632 1937462976 19.127 98 50 101 0 1996935168 42962672 16509520
20:45:02 8358 8192000000 10932932496 11369742336 1960523424 19.310 100 45 90 2 2020150848 44456288 15171136
20:45:28 2522 8192000000 10967675504 11381006336 1962794592 19.328 99 81 160 3 2037432336 48694576 25943168
20:45:40 6918 8192000000 10958677872 11380387840 1966142512 19.355 100 70 140 0 2038542944 50332224 22068208
20:45:58 7194 8192000000 10954578736 11380346880 1956685104 19.280 99 67 132 1 2029957040 51605712 21666224
20:46:16 6724 8192000000 10946024880 11371053056 1956455840 19.278 100 60 120 0 2030687824 53914416 20317568
20:46:34 3558 8192000000 10950330464 11374583808 1967193792 19.363 100 66 131 0 2036621984 47902752 21525440
20:46:45 1127 8192000000 10967656672 11376922624 1962016048 19.322 99 83 166 2 2033815392 45976752 25822592
20:46:53 2252 8192000000 10958850080 11377664000 1969491152 19.381 100 86 169 0 2042741792 46870304 26380336
20:47:05 6892 8192000000 10942244784 11376898048 1964446336 19.341 100 53 106 1 2030628256 48639520 17542400
20:47:21 5141 8192000000 10954989072 11385749504 1969713488 19.383 100 54 106 0 2037515824 50517600 17284736
20:47:33 2072 8192000000 10951965824 11376345088 1966135152 19.355 100 68 136 1 2032000352 44303152 21562048
20:47:43 26886 8192000000 10912731264 11356598272 1918688544 18.976 98 42 84 2 1978677760 45718928 14270288
20:48:20 12578 8192000000 10912888544 11350589440 1936039920 19.115 99 40 79 1 1997110416 47831168 13239328
20:48:45 14002 8192000000 10932193056 11377254400 1960069824 19.307 100 38 76 1 2017569888 44743120 12756944
20:49:07 28003 8192000000 10924819312 11379675136 1943266320 19.173 99 27 54 2 1997580576 45102880 9211376
20:49:48 15842 8192000000 10893145952 11331686400 1899839792 18.825 97 32 62 3 1945706608 35811504 10055312
20:50:13 25582 8192000000 10881318352 11323744256 1907537680 18.887 98 24 48 2 1946310032 31130640 7641712
20:50:46 25586 8192000000 10892626624 11345485824 1922871104 19.010 99 24 47 2 1966464080 35499552 8093424
20:51:24 24725 8192000000 10906661616 11345920000 1909987376 18.907 98 35 70 0 1957042896 36067984 10987536
20:51:57 16036 8192000000 10893028208 11333603328 1914996928 18.947 99 32 65 2 1964614464 38594064 11023472
20:52:27 23876 8192000000 10886057328 11332661248 1909431056 18.902 99 23 46 1 1960562832 42344688 8787088
20:52:58 21244 8192000000 10879668576 11327778816 1907467504 18.886 100 19 38 0 1953208960 39320944 6420512
20:53:25 13904 8192000000 10869711904 11318239232 1896734720 18.800 100 23 46 3 1949079328 44537504 7807104
20:53:50 19671 8192000000 10856299424 11308224512 1879659312 18.662 98 20 40 0 1928050528 41480384 6910832
20:54:16 16649 8192000000 10857194896 11304886272 1901508480 18.838 100 22 44 1 1935238336 26978240 6751616
20:54:39 19223 8192000000 10888703776 11336482816 1920527008 18.991 100 18 36 2 1961409008 35347872 5534128
20:55:26 40498 8192000000 10881527584 11339427840 1931312880 19.077 100 17 35 0 1966994528 29844928 5836720
20:56:13 22638 8192000000 10868546144 11331940352 1889913280 18.745 98 14 29 0 1918694336 24563792 4217264
20:56:42 42222 8192000000 10857222144 11310592000 1904805584 18.865 99 17 34 1 1926630608 16857936 4967088
20:58:02 74169 8192000000 10896172912 11346796544 1922303520 19.005 99 20 40 0 1945475664 18114368 5057776
20:59:31 22755 8192000000 10907033696 11338539008 1957477104 19.286 100 45 90 0 1978650512 8449104 12724304
21:00:02 120687 8192000000 10889440912 11322556416 1922642624 19.008 98 48 97 4 1948935008 11978592 14313792
21:02:13 79134 8192000000 10882174928 11334754304 1935524656 19.111 99 26 52 2 1952047168 9161872 7360640
21:03:41 17897 8192000000 10880226240 11329003520 1932398000 19.086 99 33 65 1 1948982448 7774096 8810352
21:04:06 176243 8192000000 10887125536 11347734528 1914184880 18.940 98 19 38 0 1929238048 9813680 5239488
21:07:09 25932 8192000000 10912378800 11367182336 1973537760 19.414 100 36 72 1 1998398000 14174656 10685584
21:07:56 11025 8192000000 10943132688 11382423552 1994977504 19.583 100 64 127 2 2028618096 14226256 19414336
21:08:17 57325 8192000000 10950405872 11399376896 1999030400 19.615 100 58 116 0 2035356560 19473488 16852672
21:09:32 75911 8192000000 10894529520 11380498432 1943878928 19.178 98 11 22 0 1966102880 18706784 3517168
21:10:55 50180 8192000000 10903935584 11373408256 1973679248 19.415 100 11 22 0 1988117184 11503536 2934400
21:11:52 162297 8192000000 10920084608 11386961920 1949978720 19.226 98 21 42 0 1973702192 17555104 6168368
21:14:51 43384 8192000000 10906300640 11392720896 1982295776 19.483 100 19 38 0 2007337056 19399616 5641664
21:15:46 64219 8192000000 10901478144 11377917952 1961755456 19.320 99 15 30 1 1982099216 15806016 4537744
21:16:57 84883 8192000000 10903794288 11387363328 1959278528 19.300 99 6 12 0 1969625488 8815600 1531360
21:18:31 56678 8192000000 10932064816 11395891200 1977754176 19.447 99 24 47 0 1994892128 10785824 6352128
21:19:36 21843 8192000000 10916425936 11387863040 1975503360 19.429 99 13 26 0 1989398384 10311872 3583152
21:20:10 35773 8192000000 10902165120 11372945408 1957749344 19.288 99 16 32 1 1976058672 13746272 4563056
21:20:57 80022 8192000000 10917981616 11391471616 1965614672 19.351 99 21 42 2 1983920944 12447984 5858288
21:22:25 51647 8192000000 10921455424 11386605568 1977893136 19.448 99 29 58 1 2005335888 18864608 8578144
21:23:22 38974 8192000000 10907587312 11402366976 1984405872 19.500 100 7 14 0 1997064368 10741680 1916816
21:24:15 77878 8192000000 10905256784 11379662848 1929320032 19.061 97 16 32 0 1944560288 11037264 4202992
21:25:46 84372 8192000000 10905617824 11360350208 1903567328 18.855 96 17 34 1 1921701536 13619232 4514976
21:27:17 56089 8192000000 10894036304 11368423424 1941841552 19.161 99 12 24 0 1970649568 25293152 3514864
21:28:20 53559 8192000000 10886072656 11357691904 1890459280 18.749 96 9 17 1 1906922080 14695232 1767568
21:29:21 82607 8192000000 10884438352 11345166336 1819060688 18.170 93 10 20 0 1836278144 14864656 2352800
21:30:50 105938 8192000000 10889245136 11347025920 1914036144 18.939 98 33 64 1 1941684784 18387568 9261072
21:33:08 73351 8192000000 10903387536 11363758080 1939510448 19.143 99 41 82 1 1964530176 13387152 11632576
21:34:28 26413 8192000000 10903572976 11365097472 1967135184 19.363 100 41 82 0 1991387584 12764224 11488176
21:35:22 43721 8192000000 10893180928 11369185280 1972552736 19.406 100 15 30 1 1984815472 7664384 4598352
21:36:12 56673 8192000000 10889793984 11369484288 1940703520 19.152 98 16 32 0 1953442000 8410464 4328016
21:37:15 40466 8192000000 10874380368 11346919424 1898960976 18.818 96 12 24 1 1911794704 9107824 3725904
21:38:02 42995 8192000000 10874656224 11349159936 1943385376 19.174 99 12 24 0 1956852496 10100656 3366464
21:38:51 46191 8192000000 10876953360 11361648640 1931867200 19.082 99 12 24 0 1946640096 11151520 3621376
21:39:44 76726 8192000000 10875859712 11354759168 1946851584 19.201 99 17 35 0 1959463824 7632320 4979920
21:41:08 79065 8192000000 10853142896 11329134592 1935046384 19.107 99 21 41 0 1947989712 7399248 5544080
21:42:34 31278 8192000000 10841458032 11303129088 1878254320 18.651 97 26 52 3 1892364880 6789568 7320992
21:43:12 50378 8192000000 10860873968 11333775360 1901358960 18.837 98 21 42 0 1915996608 9300400 5337248
21:44:10 57211 8192000000 10841714752 11322241024 1866770448 18.558 96 9 18 1 1880811968 11376784 2664736
21:45:31 56390 8192000000 10820832176 11293810688 1865991248 18.552 97 11 22 1 1878916016 9877952 3046816
21:46:58 64492 8192000000 10853963376 11338317824 1913331968 18.933 99 13 26 0 1925728736 8742864 3653904
21:48:08 32754 8192000000 10851067936 11319554048 1888332560 18.732 97 12 23 1 1902289568 10619856 3337152
21:48:53 46427 8192000000 10860537552 11334926336 1910370352 18.910 98 27 54 1 1930224624 12366880 7487392
21:49:56 40496 8192000000 10876603584 11346321408 1897360992 18.805 97 31 62 1 1921647856 15928048 8358816
21:50:45 48627 8192000000 10856451968 11324055552 1899328032 18.821 98 24 46 3 1919517040 13453392 6735616
21:51:40 86853 8192000000 10885977424 11360354304 1947113456 19.203 100 20 39 2 1969862016 16398480 6350080
21:53:27 49985 8192000000 10885674064 11365613568 1950049280 19.227 100 16 32 1 1971663152 16509920 5103952
21:54:25 70345 8192000000 10870327936 11333808128 1876986672 18.641 96 17 34 0 1892736576 11019680 4730224
21:55:41 32837 8192000000 10855140608 11329495040 1902338224 18.845 98 20 40 0 1918495648 10844304 5313120
21:56:29 27302 8192000000 10881466384 11326840832 1908177216 18.892 98 45 89 1 1930300544 9490224 12633104
21:57:02 9045 8192000000 10893890432 11338952704 1944003008 19.179 100 43 86 0 1965281552 9747376 11531168
21:57:17 10729 8192000000 10906022480 11353169920 1957685392 19.288 100 45 90 1 1982254848 12051424 12518032
21:57:42 61182 8192000000 10907342352 11375038464 1966750704 19.360 100 29 58 1 1989414416 14814288 7849424
21:58:52 110933 8192000000 10894608608 11369848832 1960918128 19.313 99 25 50 0 1980375504 12319280 7138096
22:01:01 52681 8192000000 10909011232 11386580992 1974190160 19.419 100 15 30 0 1989709792 11262896 4256736
22:02:01 41959 8192000000 10903633568 11391123456 1985291232 19.507 100 10 20 0 2000580912 12715872 2573808
22:02:54 26150 8192000000 10912627904 11404189696 1989557600 19.540 100 6 12 0 2004453040 13430080 1465360
22:03:27 10677 8192000000 10910534352 11405434880 1988496912 19.532 100 7 14 0 2005854416 15446096 1911408
22:03:43 418 8192000000 10912670032 11406483456 1988855408 19.535 100 7 14 0 2004689536 14097152 1736976
22:03:50 1191 8192000000 10917037360 11409653760 1989470752 19.540 100 10 18 0 2005721632 13864640 2386240
22:04:05 79797 8192000000 10936587072 11415011328 1995965120 19.591 100 13 26 0 2011064384 11287792 3811472
22:05:49 31143 8192000000 10945290464 11414523904 2009132448 19.695 100 34 68 1 2026341904 8078240 9131216
22:06:36 52128 8192000000 10930480880 11419607040 1987085600 19.521 99 14 28 2 2002552160 11336224 4130336
22:07:39 65873 8192000000 10940024560 11415793664 1974620800 19.422 98 19 38 1 1997396384 17153424 5622160
22:08:52 59084 8192000000 10917899136 11408900096 1959802592 19.304 98 12 24 0 1976666144 13362528 3501024
22:09:57 80593 8192000000 10922836240 11404550144 1964168128 19.339 99 9 18 0 1983318304 16858928 2291248
22:11:31 41471 8192000000 10937395584 11414343680 2000852256 19.629 100 37 74 1 2024263264 12678624 10732384
22:12:20 102219 8192000000 10953949248 11413774336 1939588080 19.143 97 18 36 0 1958689856 14170368 4931408
22:14:09 15423 8192000000 10953223264 11420057600 2010143472 19.703 100 57 114 0 2039607648 13307008 16157168
22:14:34 106566 8192000000 10929131872 11428515840 1959353808 19.301 98 11 22 1 1980071040 17760288 2956944
22:16:27 112621 8192000000 10919307984 11422912512 1958422912 19.294 98 6 12 0 1982621200 23016736 1181552
22:18:49 79957 8192000000 10870983376 11353690112 1886804384 18.720 95 12 24 0 1901814992 11736816 3273792
22:20:16 26200 8192000000 10870954880 11333767168 1907115296 18.883 97 30 60 2 1922321136 6955904 8249936
22:20:57 68010 8192000000 10864377904 11344994304 1930379296 19.070 99 10 21 2 1939546928 6693008 2474624
22:22:11 43295 8192000000 10854470336 11335974912 1928750160 19.057 99 6 12 0 1936420848 6327200 1343488
22:23:01 63252 8192000000 10898693888 11374116864 1957600080 19.287 100 18 36 0 1970305616 7554608 5150928
22:24:31 81382 8192000000 10883816784 11367317504 1953431200 19.254 99 20 41 0 1970466352 11275456 5759696
22:26:04 50365 8192000000 10898871712 11381960704 1980196256 19.466 100 19 38 0 2001113232 16172704 4744272
22:27:12 19750 8192000000 9658171728 10001637376 799762464 8.894 41 2 3 0 806745824 6457440 525920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 14-02-2021 22:29:21 to 14-02-2021 22:29:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 107 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 14-02-2021 22:29:54 to 14-02-2021 22:29: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          231010
MON$OLDEST_ACTIVE               231011
MON$OLDEST_SNAPSHOT             231011
MON$NEXT_TRANSACTION            231011
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                       2037344
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:392: 
:393: mscs-test-161.budzdorov.ru    Sun Feb 14 22:27:56 2021
:394:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:395: 
--- end of diff output ---

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

14.02.21 22:29:57. 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-14 22:29:59 No severe PSQL-related problems occured
14.02.21 22:30:00. End of report.