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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-14 22:27:06
DTS_END                         2020-12-14 22:27:06.3420
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/49830
TRN_ID                          244821
ATT_ID                          724
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: 9587.58 21427 1150510
customer order: creation 178.58 338 21430
customer order: refuse 15.08 288 1810
order to supplier: creation 47.13 1083 5655
order to supplier: removal 3.40 98094 408
invoice (draft): creation 46.36 2777 5563
invoice (draft): removal 54.07 698 6488
invoice accept: apply 43.08 17104 5169
invoice accept: cancel 49.45 707 5934
customer reserve: creation 4022.61 170 482713
customer reserve: removal 4819.52 56 578342
realization accept: apply 85.22 147 10226
realization accept: cancel 91.95 95 11034
payment from customer: creation 60.32 90 7238
payment from customer: removal 6.18 56 742
payment to supplier: creation 49.44 110 5933
payment to supplier: removal 3.22 52 386
service: total inventory turnovers 4.74 944 569
service: total monetary turnovers 6.36 17 763
service: aggregate perf. data 0.86 18844 103
service: refresh index statistics 0.03 286860 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7835
TEST_TIME 2 7213
TEST_TIME 3 6422
TEST_TIME 4 6585
TEST_TIME 5 6808
TEST_TIME 6 6508
TEST_TIME 7 6205
TEST_TIME 8 6434
TEST_TIME 9 6339
TEST_TIME 10 6361
TEST_TIME 11 6822
TEST_TIME 12 7529
TEST_TIME 13 7670
TEST_TIME 14 8175
TEST_TIME 15 9202
TEST_TIME 16 8938
TEST_TIME 17 8849
TEST_TIME 18 9032
TEST_TIME 19 9099
TEST_TIME 20 9590
TEST_TIME 21 9869
TEST_TIME 22 10230
TEST_TIME 23 12093
TEST_TIME 24 12566
TEST_TIME 25 12267
TEST_TIME 26 12073
TEST_TIME 27 11766
TEST_TIME 28 11604
TEST_TIME 29 11494
TEST_TIME 30 11486
TEST_TIME 31 11303
TEST_TIME 32 11331
TEST_TIME 33 11145
TEST_TIME 34 11028
TEST_TIME 35 10785
TEST_TIME 36 10767
TEST_TIME 37 10567
TEST_TIME 38 10551
TEST_TIME 39 10455
TEST_TIME 40 10360
TEST_TIME 41 10287
TEST_TIME 42 10376
TEST_TIME 43 10297
TEST_TIME 44 10262
TEST_TIME 45 10460
TEST_TIME 46 10442
TEST_TIME 47 10425
TEST_TIME 48 10508
TEST_TIME 49 10433
TEST_TIME 50 10490
TEST_TIME 51 10525
TEST_TIME 52 10519
TEST_TIME 53 10480
TEST_TIME 54 10421
TEST_TIME 55 10294
TEST_TIME 56 10375
TEST_TIME 57 10266
TEST_TIME 58 10209
TEST_TIME 59 10146
TEST_TIME 60 10105
TEST_TIME 61 10181
TEST_TIME 62 10063
TEST_TIME 63 9958
TEST_TIME 64 10044
TEST_TIME 65 10050
TEST_TIME 66 10003
TEST_TIME 67 9967
TEST_TIME 68 10006
TEST_TIME 69 10041
TEST_TIME 70 10176
TEST_TIME 71 10105
TEST_TIME 72 10116
TEST_TIME 73 10121
TEST_TIME 74 10137
TEST_TIME 75 10176
TEST_TIME 76 10172
TEST_TIME 77 10245
TEST_TIME 78 10224
TEST_TIME 79 10106
TEST_TIME 80 10094
TEST_TIME 81 10061
TEST_TIME 82 10011
TEST_TIME 83 9983
TEST_TIME 84 9955
TEST_TIME 85 9949
TEST_TIME 86 9887
TEST_TIME 87 9834
TEST_TIME 88 9898
TEST_TIME 89 9888
TEST_TIME 90 9926
TEST_TIME 91 9941
TEST_TIME 92 9957
TEST_TIME 93 9940
TEST_TIME 94 9938
TEST_TIME 95 9965
TEST_TIME 96 9932
TEST_TIME 97 9922
TEST_TIME 98 9921
TEST_TIME 99 9937
TEST_TIME 100 9936
TEST_TIME 101 9996
TEST_TIME 102 9993
TEST_TIME 103 9995
TEST_TIME 104 9951
TEST_TIME 105 9915
TEST_TIME 106 9858
TEST_TIME 107 9845
TEST_TIME 108 9798
TEST_TIME 109 9776
TEST_TIME 110 9761
TEST_TIME 111 9732
TEST_TIME 112 9679
TEST_TIME 113 9679
TEST_TIME 114 9683
TEST_TIME 115 9671
TEST_TIME 116 9670
TEST_TIME 117 9658
TEST_TIME 118 9627
TEST_TIME 119 9669
TEST_TIME 120 9590

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-12-2020 22:28:33 to 14-12-2020 22:28:36.

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 1598659 1598659 0 0.00 0 26233 6 0 0
doc_list_biud 1598659 1598659 0 0.00 0 65004 25 0 0
sp_add_invoice_to_stock 5250 5169 81 1.54 40 191736 17105 0 81
sp_cancel_adding_invoice 5934 5934 0 0.00 4 69954 708 0 0
sp_cancel_client_order 1810 1810 0 0.00 4 18968 288 0 0
sp_cancel_customer_reserve 578342 578342 0 0.00 1 27419 56 0 0
sp_cancel_pay_from_customer 742 742 0 0.00 2 5853 56 0 0
sp_cancel_pay_to_supplier 386 386 0 0.00 3 3486 53 0 0
sp_cancel_supplier_invoice 6493 6488 5 0.07 1 65072 699 0 5
sp_cancel_supplier_order 408 408 0 0.00 5 895347 98095 0 0
sp_cancel_write_off 11034 11034 0 0.00 1 10119 95 0 0
sp_client_order 21430 21430 0 0.00 3 31228 338 0 0
sp_customer_reserve 482713 482713 0 0.00 0 111690 170 0 0
sp_fill_shopping_cart 32635 32635 0 0.00 1 11131 32 0 0
sp_fill_shopping_cart_clo_res 482692 482692 0 0.00 0 18583 13 0 0
sp_get_clo_for_invoice 5148 5148 0 0.00 0 20500 278 0 0
sp_kill_cost_storno 18096 18096 0 0.00 0 6371 46 0 0
sp_kill_qstorno_ret_qs2qd 1174614 1174614 0 0.00 0 65003 30 0 0
sp_kill_qty_storno 619390 619390 0 0.00 0 65004 64 0 0
sp_lock_selected_doc 21286 21286 0 0.00 0 9430 6 0 0
sp_make_cost_storno 28545 28545 0 0.00 0 26226 44 0 0
sp_multiply_rows_for_pdistr 28545 28545 0 0.00 0 7666 22 0 0
sp_multiply_rows_for_qdistr 21430 21430 0 0.00 0 23651 163 0 0
sp_pay_from_customer 7238 7238 0 0.00 4 9704 90 0 0
sp_pay_to_supplier 5933 5933 0 0.00 5 11922 111 0 0
sp_payment_common 13171 13171 0 0.00 1 9701 26 0 0
sp_qd_handle_on_cancel_clo 1810 1810 0 0.00 0 18960 259 0 0
sp_qd_handle_on_invoice_upd_sts 11082 11082 0 0.00 0 15998 261 0 0
sp_qd_handle_on_reserve_upd_sts 10226 10226 0 0.00 0 13908 48 0 0
sp_reserve_write_off 10226 10226 0 0.00 6 15820 148 0 0
sp_supplier_invoice 5563 5563 0 0.00 6 92860 2777 0 0
sp_supplier_order 5655 5655 0 0.00 5 86451 1083 0 0
srv_aggregate_perf_data 103 103 0 0.00 2919 147203 18845 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1009 144780 35046 0 0
srv_find_qd_qs_mism 1101884 1101884 0 0.00 0 19263 6 0 0
srv_make_invnt_saldo 569 569 0 0.00 31 54729 944 0 0
srv_make_money_saldo 763 763 0 0.00 0 536 18 0 0
srv_recalc_idx_stat 4 4 0 0.00 163713 467380 286861 0 0
t$perf-abend:sp_add_invoice_to_stock 81 81 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5169 5169 0 0.00 0 11728 141 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 0 5277 114 0 0
t$perf-norm:sp_cancel_client_order 1810 1810 0 0.00 0 1849 8 0 0
t$perf-norm:sp_cancel_customer_reserve 711 711 0 0.00 0 2287 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 742 742 0 0.00 0 931 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 386 386 0 0.00 0 1321 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 382 382 0 0.00 0 6021 24 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 14670 1486 0 0
t$perf-norm:sp_cancel_write_off 1050 1050 0 0.00 0 6847 13 0 0
t$perf-norm:sp_client_order 21430 21430 0 0.00 0 10969 16 0 0
t$perf-norm:sp_customer_reserve 967 967 0 0.00 0 7402 13 0 0
t$perf-norm:sp_pay_from_customer 7238 7238 0 0.00 0 11930 15 0 0
t$perf-norm:sp_pay_to_supplier 5933 5933 0 0.00 0 9292 15 0 0
t$perf-norm:sp_reserve_write_off 10226 10226 0 0.00 0 9263 14 0 0
t$perf-norm:sp_supplier_invoice 5564 5564 0 0.00 0 6203 13 0 0
t$perf-norm:sp_supplier_order 5655 5655 0 0.00 0 3408 12 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 386 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 6620 75 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 2105 18 0 0
t$perf-norm:srv_make_money_saldo 763 763 0 0.00 0 6647 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 18 6 0 0
v_add_invoice_to_stock 10448 10286 162 1.55 0 6335 19 0 162
v_all_customers 39324 39324 0 0.00 0 151 0 0 0
v_all_suppliers 31134 31134 0 0.00 0 147 1 0 0
v_all_wares 42860 42860 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 2134 9 0 0
v_cancel_client_order 3620 3620 0 0.00 0 2227 5 0 0
v_cancel_customer_prepayment 1484 1484 0 0.00 0 789 5 0 0
v_cancel_customer_reserve 1422 1422 0 0.00 0 4140 7 0 0
v_cancel_payment_to_supplier 772 772 0 0.00 0 3481 10 0 0
v_cancel_supplier_invoice 774 764 10 1.29 0 3431 25 0 10
v_cancel_supplier_order 816 816 0 0.00 0 226 3 0 0
v_cancel_write_off 2100 2100 0 0.00 0 8223 16 0 0
v_max_id_clo_ord 5651 5651 0 0.00 0 2975 2 0 0
v_max_id_clo_res 967 967 0 0.00 0 9399 25 0 0
v_max_id_ord_sup 5554 5554 0 0.00 0 4414 4 0 0
v_max_non_paid_invoice 1571 1571 0 0.00 0 555 2 0 0
v_max_non_paid_realizn 3656 3656 0 0.00 0 2123 4 0 0
v_min_id_clo_ord 5651 5651 0 0.00 0 5750 7 0 0
v_min_id_clo_res 967 967 0 0.00 0 964 4 0 0
v_min_id_ord_sup 5554 5554 0 0.00 0 2231 4 0 0
v_min_non_paid_invoice 5933 5933 0 0.00 0 5881 17 0 0
v_min_non_paid_realizn 7238 7238 0 0.00 0 9699 18 0 0
v_our_firm 10700 10700 0 0.00 0 24 1 0 0
v_reserve_write_off 20452 20452 0 0.00 0 5046 7 0 0
x_lock_depdocs_on_canc_invoice 12040 12040 0 0.00 0 14661 116 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 11963 345 0 0
x_make_qstorno_1000_1200 5655 5655 0 0.00 1 81349 1018 0 0
x_make_qstorno_1200_2000 5563 5563 0 0.00 2 92844 2665 0 0
x_make_qstorno_2100_3300 482713 482713 0 0.00 0 111688 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-12-2020 22:28:37 to 14-12-2020 22:28:41.

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:10 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:16 14414 8192000000 10248889136 10556928000 956126416 10.451 76 57 112 1 978423936 2704224 19593296
19:57:38 19865 8192000000 10332514064 10646732800 1378621056 14.404 100 88 176 0 1411506576 4637232 28248288
19:58:23 20277 8192000000 10384419008 10708471808 1438173488 14.934 100 87 174 1 1473132576 6506704 28452384
19:58:59 12313 8192000000 10430241840 10757079040 1477483584 15.279 100 91 182 0 1514554464 7823168 29247712
19:59:20 22152 8192000000 10438566624 10770255872 1491323760 15.400 100 89 178 0 1528385264 8422400 28639104
19:59:56 17290 8192000000 10454530768 10789572608 1506204528 15.530 100 86 172 1 1542838688 8892272 27741888
20:00:25 20003 8192000000 10477886352 10816688128 1531119248 15.747 100 92 183 2 1569592896 9605680 28867968
20:01:00 18763 8192000000 10504510608 10847367168 1549748144 15.908 100 80 160 2 1585065792 10252384 25065264
20:01:26 15014 8192000000 10531051328 10879496192 1573013024 16.108 100 82 162 3 1609037664 10925056 25099584
20:01:50 16502 8192000000 10544535456 10899050496 1597414336 16.317 100 88 176 2 1636321264 11742064 27164864
20:02:19 14321 8192000000 10565242992 10920153088 1611564784 16.438 100 78 156 0 1646659728 11723968 23370976
20:02:40 7788 8192000000 10571555568 10932961280 1631794864 16.610 100 77 154 1 1667284976 12562016 22928096
20:02:55 8698 8192000000 10591818656 10953351168 1652754080 16.788 100 85 170 0 1691951072 13791712 25405280
20:03:14 8891 8192000000 10604749936 10971594752 1660340976 16.852 100 77 153 1 1695438224 12753632 22343616
20:03:29 6662 8192000000 10628977216 10992840704 1684584160 17.056 100 82 164 1 1722118224 13849168 23684896
20:03:43 8110 8192000000 10641934912 11012554752 1698836784 17.175 100 83 166 1 1737002448 14111552 24054112
20:03:59 7057 8192000000 10654712448 11028574208 1713291344 17.296 100 82 165 3 1750933536 13709216 23932976
20:04:13 5870 8192000000 10662415632 11038584832 1722214512 17.371 100 79 158 1 1758758208 13696096 22847600
20:04:27 5368 8192000000 10679368496 11058176000 1737104656 17.495 100 75 150 0 1771857744 13145888 21607200
20:04:42 6866 8192000000 10681806416 11064950784 1749068176 17.594 100 77 154 0 1783576080 12742512 21765392
20:04:56 3367 8192000000 10688148944 11069624320 1757322624 17.662 100 71 142 0 1789693952 12214016 20157312
20:05:07 3272 8192000000 10711090176 11093237760 1773144432 17.793 100 86 169 3 1809785152 13026240 23614480
20:05:18 4320 8192000000 10718336544 11099131904 1775542832 17.813 100 82 164 0 1811471536 13166832 22761872
20:05:32 3034 8192000000 10721851296 11110924288 1787945472 17.915 100 84 165 0 1824223872 12683136 23595264
20:05:41 2511 8192000000 10734690032 11126804480 1804532544 18.051 100 75 150 0 1837538464 12013712 20992208
20:05:51 3303 8192000000 10746078064 11136045056 1812592832 18.117 100 75 149 2 1845301696 11417632 21291232
20:06:02 3114 8192000000 10760561648 11148111872 1822262592 18.196 100 81 164 0 1857759008 11623456 23872960
20:06:11 2017 8192000000 10768230848 11156189184 1828837568 18.250 100 86 170 1 1864998528 12298416 23862544
20:06:20 1880 8192000000 10772224608 11160293376 1831664576 18.273 100 88 173 3 1869303072 12841440 24797056
20:06:28 2084 8192000000 10783254240 11166990336 1836504400 18.312 100 92 185 1 1876170736 13097360 26568976
20:06:37 2011 8192000000 10786414000 11174322176 1842494336 18.361 100 87 174 1 1881528928 13899296 25135296
20:06:45 1966 8192000000 10784951056 11177549824 1849901952 18.421 100 85 170 0 1887258368 12774848 24581568
20:06:54 1367 8192000000 10799153488 11186487296 1854290400 18.457 100 93 188 4 1893304752 12115872 26898480
20:07:02 1305 8192000000 10793311488 11186286592 1860078416 18.504 100 86 172 1 1897237632 12731136 24428080
20:07:10 1422 8192000000 10805081328 11194798080 1863188144 18.529 100 95 188 1 1902471920 13399088 25884688
20:07:18 1260 8192000000 10807027664 11201191936 1867607424 18.565 100 89 178 1 1906471168 13937296 24926448
20:07:26 5533 8192000000 10812740352 11204980736 1869242592 18.578 100 76 153 0 1905224944 14382896 21599456
20:07:38 18068 8192000000 10800533648 11201867776 1870599664 18.589 100 72 144 1 1902741248 11264192 20877392
20:08:02 984 8192000000 10822506608 11214708736 1882142864 18.682 100 95 191 0 1923219456 13838448 27238144
20:08:10 14743 8192000000 10805563984 11212193792 1876505024 18.637 100 59 118 3 1902785072 9543664 16736384
20:08:31 2751 8192000000 10789022608 11204182016 1874749248 18.623 100 48 93 2 1895802256 6718592 14334416
20:08:40 4979 8192000000 10791333136 11211464704 1873116768 18.609 100 40 80 1 1892321632 8006960 11197904
20:08:53 4178 8192000000 10798970128 11214393344 1875878768 18.632 100 37 74 0 1895254480 9140064 10235648
20:09:05 4787 8192000000 10796998944 11214417920 1878731856 18.655 100 37 74 1 1897481984 8698864 10051264
20:09:18 3030 8192000000 10789134288 11214225408 1878418704 18.652 100 27 53 1 1893539296 7167744 7952848
20:09:29 6677 8192000000 10795446192 11219148800 1879699216 18.663 100 33 66 2 1896963744 8397440 8867088
20:09:44 6240 8192000000 10814366208 11221962752 1884562416 18.702 100 37 75 1 1903036832 7794768 10679648
20:09:57 8649 8192000000 10791905392 11220316160 1882163872 18.683 100 16 32 1 1892979104 6153568 4661664
20:10:15 11625 8192000000 10795768512 11221078016 1884613696 18.702 100 25 50 2 1898332304 6748144 6970464
20:10:33 12441 8192000000 10790330720 11227025408 1883511136 18.693 100 17 32 0 1894779824 6381184 4887504
20:10:52 9615 8192000000 10796818688 11231232000 1890039984 18.746 100 22 44 0 1902828368 7014352 5774032
20:11:08 8347 8192000000 10813325344 11237179392 1895808032 18.793 100 26 51 2 1909142688 5933136 7401520
20:11:27 13561 8192000000 10804691440 11232370688 1892914464 18.769 100 16 31 2 1902076976 5351360 3811152
20:11:47 13284 8192000000 10819281536 11242815488 1897447968 18.806 100 34 67 1 1912875344 6277360 9150016
20:12:06 53536 8192000000 10848424256 11253305344 1905490128 18.870 100 54 108 2 1928140784 5648368 17002288
20:13:06 7753 8192000000 10815602176 11251421184 1902777424 18.849 100 30 60 0 1919478720 8304288 8397008
20:13:22 5338 8192000000 10807683856 11248005120 1901302000 18.837 100 23 47 2 1914014672 5795568 6917104
20:13:34 9912 8192000000 10821702720 11253604352 1903911424 18.858 100 37 70 3 1921975680 7368864 10695392
20:13:51 4688 8192000000 10827958384 11259207680 1902449808 18.846 100 15 30 0 1912144592 5782688 3912096
20:14:02 8210 8192000000 10815044160 11253350400 1904977504 18.866 100 20 38 1 1917168640 5282080 6909056
20:14:21 8812 8192000000 10831972000 11266105344 1907103296 18.883 100 19 38 1 1917400256 5281440 5015520
20:14:36 5608 8192000000 10838230240 11265904640 1914357472 18.942 100 22 44 0 1927075152 5062752 7654928
20:14:48 10473 8192000000 10827316576 11258908672 1897178144 18.804 99 27 55 1 1910014528 5106480 7729904
20:15:07 5049 8192000000 10826497504 11260727296 1913542912 18.935 100 28 56 4 1927388352 6130096 7715344
20:15:18 9473 8192000000 10817872640 11255111680 1893963696 18.778 99 18 36 3 1904822480 5643536 5215248
20:15:35 6565 8192000000 10808980224 11242610688 1895164656 18.787 100 23 46 4 1907585872 6080496 6340720
20:15:48 11990 8192000000 10795617424 11237822464 1844302048 18.376 97 14 28 2 1853933952 5586096 4045808
20:16:08 7142 8192000000 10792902384 11221749760 1864716736 18.542 99 18 36 1 1875339824 5556608 5066480
20:16:23 60970 8192000000 10818125696 11219234816 1817126368 18.154 96 50 103 3 1837045136 5365584 14553184
20:17:30 8794 8192000000 10760575264 11186135040 1836884016 18.315 99 35 68 1 1855046512 9073472 9089024
20:17:45 8396 8192000000 10757572064 11183366144 1818362928 18.164 98 26 52 1 1833327344 6344688 8619728
20:18:02 2929 8192000000 10746844432 11158519808 1754824032 17.642 95 50 102 1 1775970720 5939216 15207472
20:18:13 10027 8192000000 10706883456 11112349696 1696510736 17.156 93 23 46 1 1709135392 5178448 7446208
20:18:31 9250 8192000000 10729581888 11143098368 1782903312 17.873 98 22 45 1 1794584176 4945968 6734896
20:18:48 6187 8192000000 10720126624 11139973120 1780682784 17.855 98 26 52 0 1794781504 6409664 7689056
20:19:00 8368 8192000000 10696759440 11117113344 1702252752 17.204 94 21 42 1 1713818880 5304160 6261968
20:19:16 6497 8192000000 10723950192 11131203584 1790836112 17.939 100 23 45 4 1803204192 6381328 5986752
20:19:28 7792 8192000000 10676258592 11090059264 1697528064 17.164 94 26 52 1 1710164192 5009552 7626576
20:19:44 8253 8192000000 10683310304 11088625664 1698906768 17.176 95 29 56 2 1711693328 4976544 7810016
20:20:02 7588 8192000000 10664955840 11076886528 1702429168 17.205 96 22 44 2 1713828784 5324224 6075392
20:20:22 9149 8192000000 10707859408 11123908608 1776145744 17.818 99 35 69 0 1791638176 5194896 10297536
20:20:37 70532 8192000000 10714855600 11141677056 1776390416 17.820 98 32 65 1 1791132848 4755008 9987424
20:21:55 9931 8192000000 10732140048 11157360640 1820417504 18.181 100 17 34 1 1830622288 5159360 5045424
20:22:11 14173 8192000000 10745486416 11158413312 1776390640 17.820 97 26 52 0 1789131616 5660032 7080944
20:22:32 6830 8192000000 10750636384 11170705408 1830576576 18.264 100 23 45 1 1841934112 5251216 6106320
20:22:46 12281 8192000000 10762672000 11187490816 1844357904 18.376 100 25 50 0 1857148704 5525152 7265648
20:23:05 7345 8192000000 10763815712 11185217536 1832564960 18.280 99 36 71 2 1849676848 6311232 10800656
20:23:19 4580 8192000000 10776768864 11193040896 1849664832 18.419 100 26 52 1 1863324944 6359248 7300864
20:23:30 5733 8192000000 10776049312 11196960768 1854725344 18.460 100 33 66 2 1870851936 6897744 9228848
20:23:42 8860 8192000000 10781248848 11199418368 1859082912 18.496 100 16 34 3 1868440240 5099040 4258288
20:23:57 9924 8192000000 10775789872 11209039872 1865277792 18.546 100 20 39 1 1876015216 5119008 5618416
20:24:14 3180 8192000000 10787906096 11215151104 1871311312 18.595 100 33 66 2 1887645312 6617200 9716800
20:24:25 13518 8192000000 10783714912 11213066240 1868886320 18.575 100 19 38 0 1880158192 5716064 5555808
20:24:48 8843 8192000000 10791076320 11220803584 1873952912 18.616 100 19 38 3 1884772496 5447840 5371744
20:25:09 9966 8192000000 10784480304 11223146496 1876438288 18.636 100 15 30 0 1886443664 5469088 4536288
20:25:25 68210 8192000000 10785783536 11224899584 1882336048 18.684 100 28 55 4 1896549136 5978336 8234752
20:26:40 9746 8192000000 10792344992 11224440832 1878627616 18.654 100 19 38 0 1889248080 5431632 5188832
20:27:02 21672 8192000000 10816579728 11238408192 1890953216 18.753 100 29 58 0 1904203360 5310576 7939568
20:27:36 7938 8192000000 10836883936 11251101696 1909724320 18.904 100 66 128 2 1935751744 8087216 17940208
20:27:53 5759 8192000000 10855866240 11269746688 1914985040 18.947 100 62 123 1 1944516432 12772224 16759168
20:28:07 11957 8192000000 10858222352 11272359936 1918003488 18.971 100 54 109 0 1945250192 11881936 15364768
20:28:33 7565 8192000000 10861802864 11279122432 1924632736 19.024 100 56 111 2 1953536160 13611856 15291568
20:28:48 7167 8192000000 10857761680 11285479424 1927295440 19.045 100 53 106 1 1954554176 12451632 14807104
20:29:02 20606 8192000000 10864536192 11288616960 1928954736 19.059 100 46 91 0 1953633680 11375328 13303616
20:29:33 13342 8192000000 10872705776 11299139584 1937517872 19.127 100 45 88 1 1962352416 12243904 12590640
20:29:54 12831 8192000000 10875459456 11310018560 1948325168 19.213 100 47 92 1 1973286096 12085152 12875776
20:30:14 28086 8192000000 10903647504 11324329984 1956876000 19.281 100 49 98 1 1983954208 13246272 13831936
20:30:52 13360 8192000000 10895309088 11324235776 1962080976 19.323 100 54 108 0 1991913520 14495376 15337168
20:31:12 8193 8192000000 10899547168 11326754816 1963993040 19.338 100 57 112 0 1994534640 13853536 16688064
20:31:33 4870 8192000000 10910046016 11336982528 1966813120 19.360 100 52 104 1 1996274656 13418976 16042560
20:31:49 13234 8192000000 10899017104 11338657792 1969929536 19.385 100 39 78 1 1996892672 14189568 12773568
20:32:16 25823 8192000000 10900768272 11336843264 1954382272 19.261 99 45 90 0 1984374064 16423952 13567840
20:33:00 16917 8192000000 10902009904 11344531456 1968559888 19.374 100 41 82 1 1995473104 14765104 12148112
20:33:27 11328 8192000000 10905224800 11351162880 1978732352 19.455 100 47 94 1 2005964336 13333248 13898736
20:33:46 23264 8192000000 10918026112 11351760896 1960802640 19.312 99 42 83 1 1987954304 15195168 11956496
20:34:16 3087 8192000000 10921956672 11354206208 1984246688 19.498 100 48 94 1 2014349200 15968288 14134224
20:34:26 3645 8192000000 10933374864 11360845824 1987776032 19.526 100 59 116 1 2021714368 16228864 17709472
20:34:39 5251 8192000000 10935498368 11362926592 1987656992 19.525 100 48 95 0 2019399712 17523104 14219616
20:34:55 14939 8192000000 10938933392 11372589056 1993570016 19.572 100 55 107 1 2028550288 18870992 16109280
20:35:19 16159 8192000000 10947923920 11381805056 1998746560 19.613 100 48 95 2 2034947952 21060032 15141360
20:35:44 8004 8192000000 10954060992 11392987136 2007357456 19.681 100 52 105 1 2047025472 23424544 16243472
20:36:00 4023 8192000000 10946523360 11378089984 1996439424 19.595 100 55 110 2 2035794352 22180336 17174592
20:36:11 7221 8192000000 10948913776 11385786368 2003640096 19.651 100 65 127 3 2046797536 22658576 20498864
20:36:27 12991 8192000000 10945628976 11382345728 1999253728 19.617 100 48 95 3 2037398960 23126656 15018576
20:36:48 11911 8192000000 10959549728 11393900544 1989752368 19.542 99 57 114 3 2036603856 28838784 18012704
20:37:12 5051 8192000000 10951150544 11385630720 1994498032 19.579 99 43 84 0 2037928464 30151856 13278576
20:37:29 9116 8192000000 10968096432 11397865472 2007094064 19.679 100 71 140 3 2062275488 33294128 21887296
20:37:51 6174 8192000000 10981927392 11414032384 2013225888 19.727 100 65 130 0 2072809728 38781040 20802800
20:38:06 3630 8192000000 10976257584 11410403328 1995421024 19.587 99 62 121 2 2056122032 40655712 20045296
20:38:25 2394 8192000000 10989393648 11412369408 2010500976 19.705 100 73 145 1 2073288528 40149904 22637648
20:38:38 2149 8192000000 10989520832 11418492928 2015776192 19.747 100 67 134 4 2077652832 41317504 20559136
20:38:47 4708 8192000000 10988643584 11419983872 2016193920 19.750 100 59 118 2 2076191072 41025360 18971792
20:39:05 2424 8192000000 10971848368 11390365696 1987797408 19.526 100 76 151 2 2052525184 40779536 23948240
20:39:15 4196 8192000000 10948932784 11374608384 1970725600 19.391 99 76 152 1 2036787968 42355520 23706848
20:39:26 4360 8192000000 10962912688 11382747136 1983735088 19.494 100 78 153 3 2047691040 39747632 24208320
20:39:37 8153 8192000000 10977550400 11396796416 1991969296 19.559 100 72 142 2 2055812576 41315632 22527648
20:39:54 5356 8192000000 10971620992 11395579904 1978077904 19.449 99 64 128 4 2040137312 42073392 19986016
20:40:07 2372 8192000000 10967954016 11382788096 1978937984 19.456 100 77 152 2 2047476816 45247712 23291120
20:40:17 2884 8192000000 10965658464 11381239808 1964571344 19.342 99 84 167 0 2036574208 46139792 25863072
20:40:27 3350 8192000000 10973047584 11391041536 1989165024 19.537 100 83 164 0 2061102848 46450944 25486880
20:40:37 2236 8192000000 10958033120 11373228032 1967480304 19.365 100 85 171 2 2040930832 47436416 26014112
20:40:49 2297 8192000000 10975525968 11388739584 1977529360 19.445 100 83 166 0 2053823824 49882000 26412464
20:41:01 2233 8192000000 10967499584 11375706112 1970045888 19.386 99 95 188 2 2050633680 51703248 28884544
20:41:15 2661 8192000000 10986196048 11400822784 1986970592 19.520 100 81 162 1 2065120352 52965232 25184528
20:41:26 3640 8192000000 10973154384 11394572288 1966591616 19.358 99 72 143 1 2045448992 56027200 22830176
20:41:36 2856 8192000000 10945713584 11366563840 1938703072 19.136 98 74 148 1 2017715728 55467984 23544672
20:41:46 1007 8192000000 10972787712 11384745984 1971681152 19.399 100 87 171 2 2052835648 54023248 27131248
20:41:55 3447 8192000000 10972378144 11387981824 1959068464 19.299 99 79 158 1 2038869872 55004896 24796512
20:42:09 4376 8192000000 10969312704 11402047488 1980313696 19.467 100 65 128 0 2057626752 56771872 20541184
20:42:20 4567 8192000000 10974271408 11399012352 1986026512 19.512 100 67 132 1 2052742992 46580032 20136448
20:42:32 5060 8192000000 10974402848 11403939840 1984332528 19.499 100 67 133 0 2052706000 47923872 20449600
20:42:54 8422 8192000000 10956446864 11405369344 1989189728 19.537 100 29 58 0 2044316128 45689376 9437024
20:43:26 10713 8192000000 10952368576 11398553600 1966948480 19.361 99 37 74 0 2027053552 47828720 12276352
20:43:43 10257 8192000000 10950567136 11396579328 1966442528 19.357 99 33 64 1 2026943344 49347712 11153104
20:44:06 17714 8192000000 10960786624 11407343616 1980334704 19.467 100 38 74 1 2043373024 50795760 12242560
20:44:42 10485 8192000000 10963713568 11408945152 1971853648 19.400 99 35 70 4 2038878416 54832272 12192496
20:45:08 7759 8192000000 10933728144 11372859392 1952210064 19.244 100 34 67 2 2019041904 54935344 11896496
20:45:22 9746 8192000000 10949067376 11390238720 1963392368 19.333 100 42 84 1 2036163264 58110144 14660752
20:45:39 4321 8192000000 10960979200 11398176768 1971760288 19.399 100 41 82 1 2047036192 61718832 13557072
20:45:51 13279 8192000000 10959633040 11407347712 1956538960 19.279 99 36 70 0 2030538816 61915520 12084336
20:46:12 14030 8192000000 10963281008 11405807616 1968122368 19.371 100 36 72 2 2041022704 60704096 12196240
20:46:41 9671 8192000000 10977371664 11423350784 1985098784 19.505 100 36 72 0 2059274208 61580832 12594592
20:47:04 13930 8192000000 10950736816 11397226496 1947874864 19.210 99 38 75 2 2022758976 61646608 13237504
20:47:29 16378 8192000000 10963355184 11405180928 1967228784 19.363 100 35 70 1 2041896912 62349632 12318496
20:47:59 23166 8192000000 10932247744 11391782912 1931242864 19.077 98 28 56 1 2006016192 64510800 10262528
20:48:51 21712 8192000000 10901941232 11343208448 1869638784 18.581 96 29 58 1 1948232592 68072592 10521216
20:49:46 50232 8192000000 10885123472 11351826432 1867371328 18.563 98 22 44 1 1953397232 77086784 8939120
20:50:43 16853 8192000000 10845768976 11327582208 1883143120 18.690 100 16 32 1 1938299552 49735632 5420800
20:51:43 37245 8192000000 10840484960 11277242368 1883256592 18.691 99 35 70 0 1902381184 9082544 10042048
20:52:27 29702 8192000000 10820907600 11273764864 1881790288 18.680 99 22 44 1 1896663680 8644672 6228720
20:53:04 27413 8192000000 10858141968 11279851520 1873359920 18.611 98 56 109 2 1897625072 8132352 16132800
20:53:44 38194 8192000000 10843970128 11300032512 1910909520 18.914 100 25 48 3 1926091680 8855296 6326864
20:54:32 142257 8192000000 10820196256 11291295744 1802418608 18.034 94 10 20 0 1816582000 11450224 2713168
20:57:06 50490 8192000000 10854677376 11317645312 1907096400 18.883 100 7 14 0 1918870688 10432016 1342272
20:58:03 61112 8192000000 10878594384 11330396160 1921059552 18.995 99 17 35 2 1935645312 10355712 4230048
20:59:47 80443 8192000000 10869483888 11328851968 1925546640 19.031 99 17 34 3 1940587312 10251712 4788960
21:01:26 66063 8192000000 10875611808 11341156352 1950130944 19.228 100 9 18 0 1959159584 6715440 2313200
21:03:02 97910 8192000000 10892549968 11360919552 1951913360 19.242 99 11 21 1 1967330304 12577968 2838976
21:04:47 31941 8192000000 10884712480 11351498752 1949930064 19.226 99 18 35 0 1963923904 8694432 5299408
21:05:50 85854 8192000000 10911613680 11366572032 1926708576 19.041 98 10 20 0 1936684096 7397648 2577872
21:07:22 42211 8192000000 10896835792 11371020288 1976181808 19.434 100 24 48 2 1991957152 9164144 6611200
21:08:26 48592 8192000000 10902170416 11374940160 1974683024 19.423 100 21 42 0 1993612896 12485856 6444016
21:09:23 50904 8192000000 10904546336 11375583232 1966104000 19.355 99 21 42 3 1980783648 8709680 5969968
21:10:28 44459 8192000000 10915166576 11389677568 1971928800 19.401 99 18 36 0 1988726912 10844064 5954048
21:11:56 68470 8192000000 10912525440 11394207744 1970314352 19.388 99 18 37 0 1995024672 19706688 5003632
21:13:11 119798 8192000000 10917741120 11387633664 1947013952 19.203 98 11 22 0 1964370640 14377408 2979280
21:15:22 76985 8192000000 10924327856 11396042752 1967711584 19.367 99 12 22 2 1984915120 13988816 3214720
21:16:59 33569 8192000000 10927606176 11412336640 1991594864 19.556 100 16 32 0 2015877440 20079488 4203088
21:17:39 60595 8192000000 10935867088 11396943872 1978631072 19.454 99 20 40 2 2000029488 15448288 5950128
21:18:46 93989 8192000000 10916923376 11399163904 1954270816 19.260 98 12 24 1 1970061232 12611648 3178768
21:20:27 86393 8192000000 10925995648 11404640256 2006073792 19.671 100 43 87 1 2026966960 9184336 11708832
21:22:44 98376 8192000000 10894910880 11348291584 1852085664 18.439 93 25 50 2 1869122544 9700096 7336784
21:24:30 48497 8192000000 10906045136 11353419776 1930962976 19.075 98 34 68 0 1949234896 8530768 9741152
21:25:24 25867 8192000000 10908568432 11360845824 1933938880 19.098 98 36 72 1 1953522576 9190416 10393280
21:26:01 44746 8192000000 10857134704 11323797504 1927311904 19.045 98 29 58 1 1947580448 12315648 7952896
21:26:58 51736 8192000000 10872861808 11348004864 1926942864 19.042 98 16 32 0 1943381072 12156400 4281808
21:28:09 23700 8192000000 10872041136 11334897664 1941247280 19.157 99 25 50 4 1963183552 14177440 7758832
21:28:39 55036 8192000000 10897519920 11366371328 1946966704 19.202 99 13 26 1 1960127456 9545312 3615440
21:29:41 58346 8192000000 10895928544 11373780992 1974867056 19.424 100 13 26 0 1992478416 14025008 3586352
21:31:05 66800 8192000000 10890698288 11381583872 1913501120 18.935 97 9 18 0 1933622256 17175968 2945168
21:32:18 69155 8192000000 10865937984 11336957952 1826447440 18.230 93 9 18 0 1836934624 8031664 2455520
21:33:34 12782 8192000000 10891076320 11343728640 1937530192 19.127 99 45 90 1 1957548224 7383328 12634704
21:34:02 29969 8192000000 10908563248 11365388288 1954052336 19.259 99 39 77 0 1974145712 9680208 10413168
21:34:55 54444 8192000000 10871877760 11336224768 1901475312 18.838 97 18 36 0 1918137664 11204320 5458032
21:36:29 90156 8192000000 10842035072 11327533056 1853497104 18.451 96 14 28 2 1876677984 18534848 4646032
21:38:10 31204 8192000000 10885149440 11326574592 1931577696 19.079 100 20 40 1 1942889840 6035904 5276240
21:38:49 37975 8192000000 10872914592 11328045056 1895074096 18.787 97 42 84 1 1917727504 10987104 11666304
21:39:36 57261 8192000000 10855503968 11300880384 1814443648 18.132 94 30 60 2 1835606304 13013232 8149424
21:40:42 52172 8192000000 10865006224 11314606080 1825321488 18.221 95 44 88 0 1855098320 17988880 11787952
21:41:42 72509 8192000000 10824497424 11292930048 1812572016 18.117 95 16 32 0 1832808048 15746448 4489584
21:43:01 67269 8192000000 10830665312 11289038848 1816687696 18.151 95 17 34 2 1836521104 15020400 4813008
21:44:15 60727 8192000000 10826407968 11295559680 1840566256 18.345 96 9 18 0 1855418800 11614384 3238160
21:45:37 117780 8192000000 10847901040 11309101056 1907080848 18.883 99 32 64 1 1924054064 8204960 8768256
21:47:47 83275 8192000000 10871888960 11327631360 1892002768 18.762 98 24 49 2 1912123568 13443552 6677248
21:50:07 46980 8192000000 10862747840 11337281536 1939926384 19.146 100 6 12 0 1952218640 10898416 1393840
21:51:00 16513 8192000000 10857443616 11338551296 1943108080 19.172 100 9 18 0 1957326544 11538224 2680240
21:51:27 36070 8192000000 10854211056 11329331200 1917267856 18.965 99 12 24 0 1932426384 11436400 3722128
21:52:09 38778 8192000000 10853524208 11329474560 1919078224 18.979 99 12 24 0 1934555856 11267824 4209808
21:52:56 82178 8192000000 10875982848 11349131264 1946483376 19.198 100 13 25 1 1963247504 13028080 3736048
21:54:31 51049 8192000000 10866977680 11352145920 1931921024 19.082 99 13 26 0 1952434352 16564304 3949024
21:55:29 71457 8192000000 10889124688 11366379520 1947228368 19.204 100 9 18 0 1965040240 15485696 2326176
21:56:47 59612 8192000000 10888382064 11357892608 1945826976 19.193 99 19 38 0 1964376784 12634704 5915104
21:58:04 132878 8192000000 10911327248 11382263808 1953076752 19.251 99 19 38 0 1968594320 10713232 4804336
22:00:23 48796 8192000000 10897231840 11355164672 1935620928 19.112 98 33 66 2 1954932480 9795712 9515840
22:01:22 44179 8192000000 10909049328 11373764608 1976707248 19.439 100 32 64 1 1999695056 13987472 9000336
22:02:12 100364 8192000000 10925995744 11372613632 1929534160 19.063 97 37 73 1 1951873488 12050480 10288848
22:04:02 13816 8192000000 10910793584 11361660928 1939939968 19.146 98 51 102 1 1965257840 10750864 14567008
22:04:28 24560 8192000000 10897212640 11343998976 1906318400 18.877 97 37 74 2 1927361072 10958944 10083728
22:04:59 9767 8192000000 10905873408 11351347200 1955841872 19.273 100 45 90 1 1978621168 10572080 12207216
22:05:15 21958 8192000000 10893430176 11345641472 1909733648 18.905 97 40 80 2 1932553680 11760192 11059840
22:05:49 71095 8192000000 10888858368 11345608704 1884869696 18.704 96 26 52 0 1904530512 12611856 7048960
22:07:07 15611 8192000000 10905779936 11353223168 1960691328 19.312 100 38 76 0 1981452480 10449328 10311824
22:07:32 31706 8192000000 10888653248 11361673216 1944997952 19.187 99 31 62 2 1970427968 16803792 8626224
22:08:14 48671 8192000000 10889282848 11364560896 1956519392 19.278 100 17 33 0 1981306448 20071808 4715248
22:09:11 37582 8192000000 10892008432 11362193408 1923444912 19.014 98 11 22 1 1942120912 15348096 3327904
22:09:58 144780 8192000000 10872304560 11336986624 1925069200 19.027 98 23 45 1 1945130064 13244992 6815872
22:13:44 2966 8192000000 10889255440 11347845120 1960880480 19.313 100 9 18 1 1972972160 9503744 2587936
22:13:53 30407 8192000000 10878038544 11354193920 1959585184 19.303 100 16 32 1 1971551728 7392000 4574544
22:14:33 26385 8192000000 10886696800 11367333888 1968522192 19.374 100 24 46 2 1984893632 9936816 6434624
22:15:11 40676 8192000000 10869044592 11343126528 1912292736 18.925 97 9 18 0 1922369008 7417168 2659104
22:16:05 48572 8192000000 10876527872 11349626880 1919920000 18.986 98 18 36 0 1938549872 13085168 5544704
22:17:10 73930 8192000000 10840552608 11309199360 1895821184 18.793 97 14 29 1 1910172864 10397552 3954128
22:18:30 85409 8192000000 10859703040 11314348032 1850027152 18.422 95 15 30 1 1862873824 8285840 4560832
22:20:06 89758 8192000000 10812388992 11292028928 1846514864 18.394 96 13 26 1 1865154048 15260032 3379152
22:21:49 71232 8192000000 10844803072 11315818496 1868219680 18.570 97 17 35 0 1883181936 10139344 4822912
22:23:12 52319 8192000000 10876725920 11325476864 1882813056 18.688 97 25 48 2 1896645712 6796432 7036224
22:24:12 23713 8192000000 10870410400 11330465792 1920009504 18.987 99 32 64 1 1940133920 11359024 8765392
22:24:47 53710 8192000000 10866408384 11331289088 1851182112 18.432 95 28 56 1 1876799456 17231056 8386288
22:25:49 94412 8192000000 9416687488 9717649408 556105248 6.356 30 5 10 0 568768288 11391920 1271120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 14-12-2020 22:28:43 to 14-12-2020 22:29:14.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 81 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-12-2020 22:29:14 to 14-12-2020 22:29:16.

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          245422
MON$OLDEST_ACTIVE               245423
MON$OLDEST_SNAPSHOT             245423
MON$NEXT_TRANSACTION            245423
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                       2012096
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
--- end of diff output ---

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

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