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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-06 22:27:14
DTS_END                         2021-02-06 22:27:14.9650
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/40576
TRN_ID                          241956
ATT_ID                          628
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: 9262.84 20777 1111541
customer order: creation 168.94 350 20273
customer order: refuse 14.38 325 1725
order to supplier: creation 44.26 1149 5311
order to supplier: removal 3.39 103695 407
invoice (draft): creation 44.75 3230 5370
invoice (draft): removal 54.30 766 6516
invoice accept: apply 41.12 19270 4934
invoice accept: cancel 49.36 789 5923
customer reserve: creation 3769.66 194 452359
customer reserve: removal 4780.97 58 573716
realization accept: apply 82.86 172 9943
realization accept: cancel 80.82 107 9698
payment from customer: creation 58.00 118 6960
payment from customer: removal 6.09 68 731
payment to supplier: creation 48.05 130 5766
payment to supplier: removal 3.68 94 441
service: total inventory turnovers 4.98 913 598
service: total monetary turnovers 6.49 44 779
service: aggregate perf. data 0.73 23669 87
service: refresh index statistics 0.03 260393 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-02-2021 22:29:23 to 06-02-2021 22:29:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1934
TEST_TIME 2 2974
TEST_TIME 3 4185
TEST_TIME 4 5168
TEST_TIME 5 4793
TEST_TIME 6 4845
TEST_TIME 7 4681
TEST_TIME 8 5368
TEST_TIME 9 5572
TEST_TIME 10 5458
TEST_TIME 11 5525
TEST_TIME 12 5585
TEST_TIME 13 5964
TEST_TIME 14 6193
TEST_TIME 15 6455
TEST_TIME 16 6794
TEST_TIME 17 6735
TEST_TIME 18 7033
TEST_TIME 19 7496
TEST_TIME 20 8119
TEST_TIME 21 8493
TEST_TIME 22 8718
TEST_TIME 23 9501
TEST_TIME 24 9588
TEST_TIME 25 9637
TEST_TIME 26 9703
TEST_TIME 27 10907
TEST_TIME 28 10807
TEST_TIME 29 10691
TEST_TIME 30 10863
TEST_TIME 31 10986
TEST_TIME 32 10807
TEST_TIME 33 10558
TEST_TIME 34 10438
TEST_TIME 35 10339
TEST_TIME 36 10137
TEST_TIME 37 9989
TEST_TIME 38 10024
TEST_TIME 39 10006
TEST_TIME 40 10076
TEST_TIME 41 10201
TEST_TIME 42 10051
TEST_TIME 43 9941
TEST_TIME 44 9800
TEST_TIME 45 9935
TEST_TIME 46 9875
TEST_TIME 47 9904
TEST_TIME 48 9788
TEST_TIME 49 9729
TEST_TIME 50 9676
TEST_TIME 51 9540
TEST_TIME 52 9486
TEST_TIME 53 9518
TEST_TIME 54 9507
TEST_TIME 55 9483
TEST_TIME 56 9544
TEST_TIME 57 9558
TEST_TIME 58 9616
TEST_TIME 59 9699
TEST_TIME 60 9709
TEST_TIME 61 9692
TEST_TIME 62 9738
TEST_TIME 63 9746
TEST_TIME 64 9807
TEST_TIME 65 9804
TEST_TIME 66 9829
TEST_TIME 67 9873
TEST_TIME 68 9886
TEST_TIME 69 9751
TEST_TIME 70 9744
TEST_TIME 71 9701
TEST_TIME 72 9664
TEST_TIME 73 9648
TEST_TIME 74 9648
TEST_TIME 75 9585
TEST_TIME 76 9537
TEST_TIME 77 9465
TEST_TIME 78 9439
TEST_TIME 79 9524
TEST_TIME 80 9558
TEST_TIME 81 9550
TEST_TIME 82 9538
TEST_TIME 83 9535
TEST_TIME 84 9517
TEST_TIME 85 9519
TEST_TIME 86 9531
TEST_TIME 87 9528
TEST_TIME 88 9609
TEST_TIME 89 9601
TEST_TIME 90 9661
TEST_TIME 91 9738
TEST_TIME 92 9706
TEST_TIME 93 9628
TEST_TIME 94 9597
TEST_TIME 95 9521
TEST_TIME 96 9583
TEST_TIME 97 9556
TEST_TIME 98 9510
TEST_TIME 99 9474
TEST_TIME 100 9464
TEST_TIME 101 9420
TEST_TIME 102 9415
TEST_TIME 103 9390
TEST_TIME 104 9447
TEST_TIME 105 9423
TEST_TIME 106 9408
TEST_TIME 107 9431
TEST_TIME 108 9441
TEST_TIME 109 9420
TEST_TIME 110 9492
TEST_TIME 111 9492
TEST_TIME 112 9487
TEST_TIME 113 9477
TEST_TIME 114 9501
TEST_TIME 115 9471
TEST_TIME 116 9432
TEST_TIME 117 9395
TEST_TIME 118 9379
TEST_TIME 119 9325
TEST_TIME 120 9264

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-02-2021 22:29:27 to 06-02-2021 22:29:30.

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 1530216 1530216 0 0.00 0 24472 7 0 0
doc_list_biud 1530200 1530200 0 0.00 0 57659 28 0 0
sp_add_invoice_to_stock 5032 4934 98 1.94 32 201195 19271 0 98
sp_cancel_adding_invoice 5923 5923 0 0.00 5 96279 789 0 0
sp_cancel_client_order 1725 1725 0 0.00 4 9795 326 0 0
sp_cancel_customer_reserve 573716 573716 0 0.00 1 57660 58 0 0
sp_cancel_pay_from_customer 731 731 0 0.00 3 4218 68 0 0
sp_cancel_pay_to_supplier 441 441 0 0.00 3 6316 94 0 0
sp_cancel_supplier_invoice 6524 6516 8 0.12 2 19830 766 0 8
sp_cancel_supplier_order 407 407 0 0.00 5 1029002 103695 0 0
sp_cancel_write_off 9698 9698 0 0.00 1 9662 107 0 0
sp_client_order 20273 20273 0 0.00 3 21488 350 0 0
sp_customer_reserve 452359 452359 0 0.00 0 50175 195 0 0
sp_fill_shopping_cart 30949 30949 0 0.00 1 21113 37 0 0
sp_fill_shopping_cart_clo_res 452359 452359 0 0.00 0 13305 12 0 0
sp_get_clo_for_invoice 4933 4933 0 0.00 0 18757 271 0 0
sp_kill_cost_storno 16793 16793 0 0.00 0 9629 57 0 0
sp_kill_qstorno_ret_qs2qd 1164053 1164053 0 0.00 0 57657 32 0 0
sp_kill_qty_storno 612851 612851 0 0.00 0 57659 68 0 0
sp_lock_selected_doc 20692 20692 0 0.00 0 10007 5 0 0
sp_make_cost_storno 27601 27601 0 0.00 0 24468 50 0 0
sp_multiply_rows_for_pdistr 27585 27585 0 0.00 0 17393 30 0 0
sp_multiply_rows_for_qdistr 20273 20273 0 0.00 0 13746 147 0 0
sp_pay_from_customer 6960 6960 0 0.00 4 17413 119 0 0
sp_pay_to_supplier 5766 5766 0 0.00 4 16358 131 0 0
sp_payment_common 12719 12719 0 0.00 1 16885 24 0 0
sp_qd_handle_on_cancel_clo 1725 1725 0 0.00 0 9785 289 0 0
sp_qd_handle_on_invoice_upd_sts 10847 10847 0 0.00 0 15174 321 0 0
sp_qd_handle_on_reserve_upd_sts 9942 9942 0 0.00 0 16717 61 0 0
sp_reserve_write_off 9943 9943 0 0.00 6 16818 173 0 0
sp_supplier_invoice 5370 5370 0 0.00 7 76987 3231 0 0
sp_supplier_order 5311 5311 0 0.00 6 29803 1149 0 0
srv_aggregate_perf_data 87 87 0 0.00 2737 318131 23670 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1041 153528 31746 0 0
srv_find_qd_qs_mism 1064582 1064582 0 0.00 0 17690 6 0 0
srv_make_invnt_saldo 598 598 0 0.00 41 33357 913 0 0
srv_make_money_saldo 779 779 0 0.00 1 15554 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 167021 360716 260394 0 0
t$perf-abend:sp_add_invoice_to_stock 98 98 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4934 4934 0 0.00 0 17045 216 0 0
t$perf-norm:sp_cancel_adding_invoice 430 430 0 0.00 0 11068 168 0 0
t$perf-norm:sp_cancel_client_order 1725 1725 0 0.00 0 1960 13 0 0
t$perf-norm:sp_cancel_customer_reserve 702 702 0 0.00 0 2411 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 731 731 0 0.00 0 7889 22 0 0
t$perf-norm:sp_cancel_pay_to_supplier 441 441 0 0.00 0 5267 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 1118 16 0 0
t$perf-norm:sp_cancel_supplier_order 407 407 0 0.00 0 23011 1790 0 0
t$perf-norm:sp_cancel_write_off 988 988 0 0.00 0 3800 16 0 0
t$perf-norm:sp_client_order 20273 20273 0 0.00 0 15111 22 0 0
t$perf-norm:sp_customer_reserve 958 958 0 0.00 0 1822 7 0 0
t$perf-norm:sp_pay_from_customer 6960 6960 0 0.00 0 8935 19 0 0
t$perf-norm:sp_pay_to_supplier 5766 5766 0 0.00 0 6045 14 0 0
t$perf-norm:sp_reserve_write_off 9943 9943 0 0.00 0 8402 14 0 0
t$perf-norm:sp_supplier_invoice 5370 5370 0 0.00 0 8145 23 0 0
t$perf-norm:sp_supplier_order 5311 5311 0 0.00 0 14601 20 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 339 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 2185 29 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 1971 21 0 0
t$perf-norm:srv_make_money_saldo 779 779 0 0.00 0 6339 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 10044 9848 196 1.95 0 12323 22 0 196
v_all_customers 36890 36890 0 0.00 0 85 1 0 0
v_all_suppliers 29546 29546 0 0.00 0 81 1 0 0
v_all_wares 40546 40546 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 860 860 0 0.00 0 428 7 0 0
v_cancel_client_order 3450 3450 0 0.00 0 4717 8 0 0
v_cancel_customer_prepayment 1462 1462 0 0.00 0 4177 6 0 0
v_cancel_customer_reserve 1404 1404 0 0.00 0 1111 7 0 0
v_cancel_payment_to_supplier 882 882 0 0.00 0 1592 10 0 0
v_cancel_supplier_invoice 820 804 16 1.95 0 2654 20 0 16
v_cancel_supplier_order 814 814 0 0.00 0 2318 13 0 0
v_cancel_write_off 1976 1976 0 0.00 0 2194 16 0 0
v_max_id_clo_ord 5310 5310 0 0.00 0 2562 2 0 0
v_max_id_clo_res 958 958 0 0.00 0 985 8 0 0
v_max_id_ord_sup 5365 5365 0 0.00 0 4020 5 0 0
v_max_non_paid_invoice 1662 1662 0 0.00 0 546 3 0 0
v_max_non_paid_realizn 3757 3757 0 0.00 0 1639 3 0 0
v_min_id_clo_ord 5310 5310 0 0.00 0 1811 6 0 0
v_min_id_clo_res 958 958 0 0.00 0 6255 17 0 0
v_min_id_ord_sup 5365 5365 0 0.00 0 2450 3 0 0
v_min_non_paid_invoice 5760 5760 0 0.00 0 7201 14 0 0
v_min_non_paid_realizn 6959 6959 0 0.00 0 4762 14 0 0
v_our_firm 10060 10060 0 0.00 0 80 1 0 0
v_reserve_write_off 19884 19884 0 0.00 0 11831 8 0 0
x_lock_depdocs_on_canc_invoice 12037 12037 0 0.00 0 23950 111 0 0
x_lock_depdocs_on_canc_sup_ord 407 407 0 0.00 0 3001 311 0 0
x_make_qstorno_1000_1200 5311 5311 0 0.00 2 29795 1068 0 0
x_make_qstorno_1200_2000 5370 5370 0 0.00 4 76958 3100 0 0
x_make_qstorno_2100_3300 452359 452359 0 0.00 0 50171 180 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-02-2021 22:29:31 to 06-02-2021 22:29:35.

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:18 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:24 8496 8192000000 10185363776 10480312320 892913056 9.828 72 57 115 1 914560752 2708048 18939648
19:57:41 27779 8192000000 10329347920 10640187392 1354459792 14.188 100 80 160 0 1385571984 4678368 26433824
19:58:26 21826 8192000000 10365315056 10686828544 1415892416 14.736 100 84 168 1 1449812544 6597184 27322944
19:58:56 31441 8192000000 10415381408 10739888128 1451283616 15.049 100 89 178 1 1487930720 7433776 29213328
19:59:37 21045 8192000000 10430120096 10761166848 1484883648 15.344 100 88 176 0 1525496928 12361520 28251760
20:00:17 10468 8192000000 10451707456 10783318016 1508126368 15.547 100 89 178 0 1545537744 8856224 28555152
20:00:42 19403 8192000000 10468941904 10803597312 1520035296 15.651 100 88 176 0 1556700688 9377984 27287408
20:01:09 18745 8192000000 10481674240 10822213632 1543484624 15.854 100 80 158 1 1577966720 9581184 24900912
20:01:41 12903 8192000000 10504730304 10854408192 1567637024 16.062 100 77 154 0 1600852848 9812128 23403696
20:02:06 14854 8192000000 10545211568 10898370560 1598336848 16.325 100 74 148 3 1630863168 10331776 22194544
20:02:32 15939 8192000000 10577748496 10933673984 1624924912 16.552 100 78 156 0 1659358064 11050640 23382512
20:02:56 14833 8192000000 10595272976 10955497472 1657018320 16.824 100 82 164 1 1693088256 12410368 23659568
20:03:21 9444 8192000000 10616189216 10978586624 1674298544 16.969 100 86 172 0 1713386736 13773680 25314512
20:03:38 11176 8192000000 10627484736 10994589696 1677404544 16.996 100 78 156 0 1713655664 13697120 22554000
20:03:56 6939 8192000000 10648366592 11016138752 1700093232 17.186 100 85 170 0 1737687376 13505088 24089056
20:04:11 6984 8192000000 10653199376 11021508608 1713493792 17.298 100 84 169 0 1751686784 14039072 24153920
20:04:25 6940 8192000000 10664572672 11039666176 1728748304 17.425 100 80 159 0 1764462752 13032960 22681488
20:04:42 5347 8192000000 10683063792 11057627136 1742304064 17.538 100 82 163 0 1778819888 13460976 23054848
20:04:55 5312 8192000000 10684532736 11065991168 1747801216 17.583 100 80 158 0 1783693216 13349216 22542784
20:05:07 3557 8192000000 10700224864 11075031040 1758927600 17.676 100 84 165 1 1795441392 13191088 23322704
20:05:19 3745 8192000000 10700512080 11077128192 1766209744 17.736 100 81 162 1 1802230896 13437072 22584080
20:05:30 3686 8192000000 10713004416 11092672512 1771295712 17.778 100 82 163 1 1808026080 13965264 22765104
20:05:40 2831 8192000000 10724389088 11103977472 1781255584 17.860 100 81 160 1 1816948400 13407296 22285520
20:05:49 4383 8192000000 10727915632 11108663296 1793299584 17.959 100 86 172 0 1834814656 18043888 23471184
20:06:00 2536 8192000000 10749154144 11131101184 1800300096 18.016 100 86 168 1 1837492176 13397856 23794224
20:06:09 4314 8192000000 10744624464 11129036800 1805115696 18.056 100 75 148 3 1838629872 13170992 20343184
20:06:21 3607 8192000000 10759766912 11141357568 1807310368 18.074 100 77 153 2 1842111488 12798752 22002368
20:06:31 1525 8192000000 10774424944 11156127744 1833774720 18.290 100 88 174 0 1871997696 13499856 24723120
20:06:39 2528 8192000000 10770358656 11156750336 1833854096 18.291 100 91 183 3 1873659920 13788416 26017408
20:06:48 1238 8192000000 10780270016 11165753344 1840206656 18.342 100 92 185 1 1879250448 13139104 25904688
20:06:55 1980 8192000000 10785122112 11172540416 1845845872 18.388 100 86 172 2 1884559424 14044944 24668608
20:07:04 2292 8192000000 10791637152 11179962368 1851934464 18.438 100 92 184 1 1890818720 12859392 26024864
20:07:12 1285 8192000000 10800646928 11186286592 1861714528 18.517 100 94 188 0 1900373152 13126000 25532624
20:07:20 2012 8192000000 10795813536 11186556928 1856037296 18.471 100 86 173 0 1894302016 14138176 24126544
20:07:28 1946 8192000000 10807498400 11196026880 1863691552 18.533 100 95 190 1 1904615312 14546080 26377680
20:07:37 1886 8192000000 10812194464 11202973696 1870210368 18.586 100 93 185 0 1911104704 14338016 26556320
20:07:45 1935 8192000000 10808781520 11200720896 1871747792 18.598 100 92 184 2 1911460320 13599968 26112560
20:07:53 2329 8192000000 10818145312 11207049216 1875446944 18.628 100 83 167 1 1911752656 12148960 24156752
20:08:02 2322 8192000000 10805009712 11209822208 1878794928 18.655 100 62 124 0 1907802352 11305248 17702176
20:08:10 1804 8192000000 10811617328 11210186752 1877070928 18.641 100 61 122 1 1905640800 11031088 17538784
20:08:20 2944 8192000000 10807089680 11216019456 1884917248 18.705 100 72 145 1 1916605728 11373792 20314688
20:08:30 6585 8192000000 10807256352 11217866752 1883366640 18.692 100 55 110 1 1908978752 10673296 14938816
20:08:44 41112 8192000000 10792441952 11222306816 1883123888 18.690 100 39 78 2 1901204544 7235056 10845600
20:09:31 10222 8192000000 10804907776 11224637440 1887024112 18.722 100 30 59 6 1900447248 5668112 7755024
20:09:49 7893 8192000000 10807844480 11229675520 1888267952 18.732 100 23 45 0 1901232464 6599360 6365152
20:10:06 5036 8192000000 10803136288 11228909568 1890312944 18.748 100 30 60 1 1906135936 7294320 8528672
20:10:21 13040 8192000000 10795016368 11228352512 1890438448 18.749 100 20 40 0 1906013696 9849888 5725360
20:10:43 7657 8192000000 10814211152 11237646336 1894199296 18.780 100 30 60 1 1914336592 11278640 8858656
20:10:57 7064 8192000000 10795693360 11233423360 1891726224 18.760 100 18 36 3 1903654608 6908320 5020064
20:11:13 10825 8192000000 10799076240 11231281152 1892366768 18.765 100 19 38 1 1903390752 5679296 5344688
20:11:30 7831 8192000000 10798415440 11232784384 1892558016 18.766 100 13 26 1 1901077120 5135840 3383264
20:11:46 9357 8192000000 10800399840 11234414592 1893215488 18.772 100 9 18 0 1900893344 4868016 2809840
20:12:04 9005 8192000000 10808018224 11238719488 1897212160 18.804 100 20 40 1 1908493808 5830224 5451424
20:12:19 9502 8192000000 10808016736 11239342080 1897211344 18.804 100 20 40 1 1909378560 7181936 4985280
20:12:35 20936 8192000000 10825818208 11257376768 1906788624 18.881 100 28 55 3 1921121904 5748032 8585248
20:13:02 59614 8192000000 10826326160 11257602048 1904960592 18.866 100 18 36 1 1915399536 5212656 5226288
20:14:09 5754 8192000000 10825051728 11260325888 1910901968 18.914 100 29 58 2 1925883680 6155552 8826160
20:14:21 5017 8192000000 10832063536 11263840256 1913617456 18.936 100 41 82 1 1932776592 7497616 11661520
20:14:33 6635 8192000000 10806383712 11244425216 1886235456 18.715 99 30 60 1 1901777408 7048944 8493008
20:14:46 8141 8192000000 10807417920 11244138496 1882624336 18.686 99 16 31 0 1892101872 5333136 4144400
20:15:03 5610 8192000000 10814455376 11246682112 1882286304 18.684 99 25 48 4 1895442560 6071456 7084800
20:15:17 6294 8192000000 10830377152 11255197696 1900959312 18.834 100 35 72 1 1917224768 5934880 10330576
20:15:32 9523 8192000000 10813547152 11250683904 1901218464 18.836 100 21 42 1 1913033056 5886176 5928416
20:15:52 7263 8192000000 10825876448 11258056704 1905883072 18.874 100 23 46 1 1918904304 6477440 6543792
20:16:08 5735 8192000000 10823780208 11252908032 1901616080 18.839 100 26 52 0 1915938736 6595696 7726960
20:16:22 11988 8192000000 10795713376 11232555008 1860175376 18.505 98 14 28 1 1870110112 5848528 4086208
20:16:40 10372 8192000000 10793219824 11233652736 1872134688 18.602 99 19 38 0 1883924144 6574256 5215200
20:16:59 7193 8192000000 10796172112 11238436864 1889438272 18.741 100 19 38 3 1900664400 6150528 5075600
20:17:20 9080 8192000000 10739433216 11169882112 1769552128 17.763 95 20 38 2 1780636208 5320400 5763680
20:17:35 16723 8192000000 10710372816 11132522496 1726685792 17.408 94 24 48 2 1739816464 5535520 7595152
20:17:58 61918 8192000000 10732731008 11153100800 1780683824 17.855 98 31 60 1 1795754128 6640784 8429520
20:19:13 5156 8192000000 10700414544 11120431104 1774281344 17.802 98 24 46 2 1787850560 6044704 7524512
20:19:26 7976 8192000000 10713748416 11128303616 1749999952 17.602 97 25 50 1 1762724736 5884976 6839808
20:19:41 4653 8192000000 10675186288 11084668928 1720229696 17.354 97 28 56 2 1735063120 6371520 8461904
20:19:51 5807 8192000000 10653821968 11057242112 1716626320 17.324 98 29 58 4 1731507696 6448784 8432592
20:20:04 5173 8192000000 10662378240 11069157376 1716484016 17.323 98 41 82 2 1734284896 6276752 11524128
20:20:16 6525 8192000000 10682189632 11106365440 1776048688 17.817 100 26 51 0 1790196864 6401232 7746944
20:20:30 6563 8192000000 10692711600 11104104448 1756121184 17.652 99 27 54 0 1769691856 5668352 7902320
20:20:43 7337 8192000000 10690372096 11096821760 1732196960 17.454 97 18 34 1 1742349408 5186624 4965824
20:20:57 6743 8192000000 10727240048 11133362176 1797879664 17.997 100 36 72 0 1814897408 5715424 11302320
20:21:10 7228 8192000000 10711924720 11126870016 1770158224 17.768 98 28 56 1 1784601328 4971360 9471744
20:21:25 8719 8192000000 10717942704 11138744320 1803897696 18.046 100 33 66 0 1820476192 7135520 9442976
20:21:45 5557 8192000000 10739062160 11163484160 1825730528 18.224 100 27 51 0 1838672672 5417504 7524640
20:22:00 6202 8192000000 10745804016 11165061120 1826055584 18.227 100 31 62 0 1842123168 7055440 9012144
20:22:15 13802 8192000000 10743040480 11166568448 1813610288 18.125 99 19 38 1 1824289504 5336160 5343056
20:22:35 64366 8192000000 10748581216 11176140800 1839263520 18.335 100 33 64 3 1853614464 4558656 9792288
20:23:50 11094 8192000000 10755867120 11186446336 1844857408 18.380 100 25 50 0 1857616240 5476048 7282784
20:24:08 10657 8192000000 10762461520 11185807360 1834072688 18.293 99 36 71 3 1850001280 6086912 9841680
20:24:27 9522 8192000000 10754617104 11184447488 1845192880 18.383 100 32 65 1 1860824656 6149840 9481936
20:24:46 8147 8192000000 10757141344 11189919744 1849826960 18.421 100 18 35 0 1860644064 5276208 5540896
20:25:01 7633 8192000000 10787703280 11201740800 1854394176 18.458 100 32 64 1 1868569616 4354624 9820816
20:25:21 10061 8192000000 10787526160 11205140480 1860038768 18.504 100 27 54 0 1874186800 6346944 7801088
20:25:38 12347 8192000000 10774624608 11207983104 1862296608 18.522 100 22 42 0 1874133424 5605680 6231136
20:25:58 14366 8192000000 10784120656 11212591104 1865743312 18.550 100 16 32 1 1876014272 5861568 4409392
20:26:22 9681 8192000000 10787438144 11217031168 1869897408 18.583 100 22 43 1 1881351488 5111136 6342944
20:26:37 9015 8192000000 10789994864 11216519168 1872116944 18.601 100 26 53 0 1885391072 5635520 7638608
20:26:56 27061 8192000000 10797415472 11231068160 1881272016 18.675 100 22 42 2 1891372416 4445088 5655312
20:28:19 22630 8192000000 10844880816 11262799872 1908696704 18.896 100 48 94 2 1929819424 7110960 14011760
20:28:49 13843 8192000000 10857129296 11276132352 1919018528 18.979 100 61 118 0 1944805504 9876768 15910208
20:29:10 11838 8192000000 10867933536 11279093760 1920914416 18.994 100 73 145 0 1953224432 11638928 20671088
20:29:38 8527 8192000000 10871379968 11284770816 1926042976 19.035 100 64 126 4 1955457328 11733936 17680416
20:29:55 17559 8192000000 10866852592 11290370048 1925690208 19.032 100 54 107 1 1950995376 11061120 14244048
20:30:22 15244 8192000000 10873787920 11294932992 1933140224 19.092 100 57 113 2 1961427984 12786032 15501728
20:30:48 6732 8192000000 10877158480 11298562048 1926085760 19.036 99 67 129 0 1958144784 13666496 18392528
20:31:03 20581 8192000000 10875537056 11299065856 1936122704 19.116 100 52 104 2 1966048640 15258496 14667440
20:31:37 35934 8192000000 10873275712 11313201152 1942333072 19.165 100 39 77 2 1966302208 13678320 10290816
20:32:25 17037 8192000000 10900516576 11331022848 1957690656 19.288 100 39 76 2 1982904144 14542608 10670880
20:32:50 10116 8192000000 10906367312 11333541888 1965973984 19.353 100 48 96 0 1995506336 16046752 13485600
20:33:17 3622 8192000000 10911680336 11331723264 1957716880 19.288 99 58 113 2 1990881888 17443760 15721248
20:33:28 5364 8192000000 10923017984 11346337792 1975340240 19.428 100 54 107 2 2009720976 18573328 15807408
20:33:40 8596 8192000000 10922043808 11346161664 1959301696 19.300 99 58 115 2 1995052912 19291856 16459360
20:34:01 11291 8192000000 10932612704 11354435584 1977838848 19.448 100 61 122 1 2017181184 21398416 17943920
20:34:20 22822 8192000000 10933705168 11367165952 1981443792 19.476 100 55 110 0 2023276672 25229504 16603376
20:34:55 14863 8192000000 10932764784 11369074688 1983040880 19.489 100 48 96 2 2026330544 28481296 14808368
20:35:21 7325 8192000000 10948910928 11374759936 1987783792 19.526 100 55 110 1 2031878832 27712192 16382848
20:35:37 13350 8192000000 10945520016 11378860032 1990297040 19.546 100 52 101 2 2034510384 28651792 15561552
20:36:05 19877 8192000000 10937902416 11383164928 1996073216 19.592 100 44 88 1 2035753344 25994608 13685520
20:36:32 13115 8192000000 10948203056 11383951360 1997571088 19.604 100 51 103 2 2039276720 25965440 15740192
20:36:55 9560 8192000000 10957033040 11388620800 1997527056 19.603 100 50 100 1 2041408832 29029728 14852048
20:37:13 9548 8192000000 10961867936 11401461760 2009556704 19.698 100 48 96 0 2055560032 30402128 15601200
20:37:35 11988 8192000000 10949939648 11383529472 1982577232 19.485 99 46 92 1 2023680688 25994480 15108976
20:37:59 7491 8192000000 10953020752 11389644800 2003625872 19.651 100 46 92 0 2046431344 28216752 14588720
20:38:16 8179 8192000000 10927764976 11356667904 1968873264 19.377 98 59 116 0 2018535504 31400608 18261632
20:38:32 4716 8192000000 10953612720 11382964224 1989494096 19.540 100 58 115 1 2037537152 29403968 18639088
20:38:51 2978 8192000000 10962395936 11392286720 1999211120 19.617 100 68 136 2 2052619072 32094768 21313184
20:39:03 9635 8192000000 10972162592 11397861376 2005285440 19.664 100 80 160 2 2062606928 33266032 24055456
20:39:23 1969 8192000000 10985880336 11407310848 2007394736 19.681 100 74 148 0 2065388912 36210032 21784144
20:39:33 3434 8192000000 10981058064 11406901248 1991773840 19.558 99 71 141 2 2050901232 36867712 22259680
20:39:45 3359 8192000000 10981969184 11402719232 2004662816 19.659 100 77 153 1 2065561392 37665728 23232848
20:39:55 3458 8192000000 10992957280 11413598208 2013865104 19.732 100 78 156 0 2076285552 38670592 23749856
20:40:07 2897 8192000000 10993747920 11405434880 2005995376 19.670 100 93 185 3 2073410512 38861424 28553712
20:40:18 2923 8192000000 10986337120 11411468288 2009988896 19.701 100 77 154 1 2073657024 40374064 23294064
20:40:29 5889 8192000000 10983670240 11411554304 2008849664 19.692 100 79 157 0 2073236944 40347872 24039408
20:40:51 3296 8192000000 10987003040 11406909440 2005842848 19.669 100 64 128 0 2065869232 40107936 19918448
20:41:06 4894 8192000000 10954923184 11382644736 1975420016 19.428 99 59 118 2 2033569824 39032128 19117680
20:41:17 6068 8192000000 10967697008 11384635392 1969849248 19.384 99 77 152 2 2033564752 41042816 22672688
20:41:32 7008 8192000000 10963963152 11390435328 1974131168 19.418 99 71 142 1 2039076928 42942112 22003648
20:41:47 1869 8192000000 10963097632 11372830720 1971826496 19.400 100 86 171 0 2042852096 43444944 27580656
20:41:55 3574 8192000000 10974281312 11388518400 1980634576 19.470 100 83 164 0 2046914080 41107056 25172448
20:42:06 3271 8192000000 10975386320 11396124672 1985361104 19.507 100 88 174 0 2053772704 41378976 27032624
20:42:18 3724 8192000000 10964984736 11383758848 1985466704 19.508 100 74 148 2 2047971440 39916448 22588288
20:42:30 4759 8192000000 10960513168 11378409472 1969639072 19.383 99 75 148 0 2032882976 40502736 22741168
20:42:43 2110 8192000000 10951396496 11363880960 1966593040 19.358 99 84 168 2 2034603040 42172496 25837504
20:42:52 5458 8192000000 10964328368 11387789312 1980882880 19.472 100 64 129 0 2044886016 43330576 20672560
20:43:04 3302 8192000000 10976177056 11397971968 1993016960 19.568 100 74 148 2 2057110352 41317552 22775840
20:43:14 3125 8192000000 10991638144 11407118336 2001185856 19.632 100 84 165 2 2067102640 41861216 24055568
20:43:25 1035 8192000000 10977143040 11384360960 1980802800 19.471 100 88 176 2 2048898208 41363264 26732144
20:43:32 1367 8192000000 10965643360 11376164864 1971327728 19.396 100 88 174 1 2040320464 42279184 26713552
20:43:41 1971 8192000000 10976470016 11383586816 1979520608 19.461 100 89 176 0 2050196624 43082816 27593200
20:43:49 5116 8192000000 10948945264 11378802688 1970798224 19.392 100 63 125 2 2034525104 43891760 19835120
20:44:08 13269 8192000000 10922161792 11356323840 1948496752 19.215 99 39 78 4 2005532272 43623664 13411856
20:44:29 8289 8192000000 10953954832 11385180160 1970298928 19.388 100 45 90 0 2033978144 48197168 15482048
20:44:46 2115 8192000000 10972072016 11383492608 1971156832 19.395 100 94 188 2 2052938352 51214960 30566560
20:44:55 6977 8192000000 10956170720 11377643520 1964939696 19.345 100 71 142 2 2040902960 53043424 22919840
20:45:11 1912 8192000000 10960306080 11374395392 1962204256 19.324 100 85 168 4 2042456608 53362544 26889808
20:45:20 4986 8192000000 10952738864 11371237376 1957992400 19.290 100 81 160 1 2039782960 55628688 26161872
20:45:35 3840 8192000000 10979918336 11394015232 1974690304 19.423 100 84 167 1 2058559664 56847888 27021472
20:45:47 1844 8192000000 10976910144 11384573952 1964326432 19.340 99 88 174 1 2048521216 56000064 28194720
20:45:58 2380 8192000000 10978927744 11397582848 1980428432 19.468 100 79 159 0 2061032544 55152304 25451808
20:46:11 13048 8192000000 10943570640 11377758208 1941764144 19.161 99 44 86 4 2012198608 56055536 14378928
20:46:32 10562 8192000000 10935858720 11366273024 1943247472 19.173 100 50 100 1 2018767456 58724256 16795728
20:46:53 9292 8192000000 10905956576 11335471104 1901350768 18.837 98 46 92 1 1978084448 60617856 16115824
20:47:17 3777 8192000000 10916633328 11340255232 1926903376 19.042 100 64 127 0 1998675392 51634080 20137936
20:47:31 5803 8192000000 10917458368 11339202560 1922254288 19.005 100 66 131 0 1994602032 51390640 20957104
20:47:43 6324 8192000000 10923930944 11350740992 1930904752 19.074 100 55 108 3 1998552512 50266880 17380880
20:48:05 19103 8192000000 10909455600 11355443200 1933345216 19.094 100 35 70 1 1997426592 51725248 12356128
20:48:31 10900 8192000000 10904022752 11339255808 1910738608 18.913 99 32 63 2 1969293856 47392368 11162880
20:48:49 3045 8192000000 10918923440 11355459584 1937555520 19.127 100 57 114 1 2009437888 53562720 18319648
20:48:59 3368 8192000000 10926832208 11364339712 1939325312 19.141 100 52 104 1 2011578896 54964656 17288928
20:49:09 8554 8192000000 10912580320 11362471936 1936649104 19.120 100 43 86 3 2003913040 52563872 14700064
20:49:25 16952 8192000000 10917090896 11360124928 1938574384 19.135 100 33 65 4 1998153232 48467600 11111248
20:49:53 8210 8192000000 10932542416 11375996928 1949298320 19.221 100 40 80 3 2015440416 52511840 13630256
20:50:08 9976 8192000000 10917233696 11370041344 1957483872 19.286 100 30 61 1 2006034224 38684432 9865920
20:50:33 20522 8192000000 10920485360 11371032576 1958632432 19.295 100 28 56 2 2003476032 35573936 9269664
20:51:08 33220 8192000000 10915831552 11375247360 1959721280 19.304 100 19 38 0 1997819536 31715648 6382608
20:51:56 52621 8192000000 10911985120 11377455104 1946185536 19.196 100 19 38 1 1994680048 41457760 7036752
20:52:56 39704 8192000000 10908896192 11366199296 1919294272 18.981 99 21 42 1 1981788592 54815056 7679264
20:54:17 34334 8192000000 10864510112 11325112320 1877407840 18.644 97 15 30 0 1911316816 29304768 4604208
20:55:07 33820 8192000000 10872295200 11335598080 1938054288 19.131 100 16 32 0 1959749408 16609488 5085632
20:55:48 37959 8192000000 10876188288 11336171520 1910391680 18.910 99 10 20 2 1939151152 25219552 3539920
20:56:36 37480 8192000000 10861617776 11305369600 1875836640 18.631 97 34 66 3 1902791648 16167104 10787904
20:57:32 153528 8192000000 10880623504 11342696448 1880684464 18.671 97 12 25 0 1897368672 13868960 2815248
21:00:17 105059 8192000000 10897317632 11353522176 1937472016 19.127 99 23 46 0 1952053200 7826640 6754544
21:02:12 102261 8192000000 10906034176 11356844032 1948451392 19.214 99 35 70 0 1969522560 10651280 10419888
21:04:12 11980 8192000000 10882329264 11324526592 1910687648 18.912 97 39 78 0 1933082336 11163280 11231408
21:04:30 17001 8192000000 10911231248 11354947584 1963943424 19.337 100 39 78 0 1989261536 13861328 11456784
21:04:56 31287 8192000000 10911756960 11368173568 1947356896 19.205 99 32 64 2 1974800896 17453264 9990736
21:05:40 45701 8192000000 10908361840 11378491392 1969855328 19.384 100 22 45 4 1994910352 18433312 6621712
21:06:49 88768 8192000000 10904909408 11382177792 1969257104 19.380 100 33 66 0 2001488496 21834640 10396752
21:08:32 43048 8192000000 10910877056 11363696640 1953480608 19.254 99 36 71 0 1975300864 10746096 11074160
21:09:24 51304 8192000000 10896638496 11360714752 1956055296 19.275 99 18 36 0 1971161488 9956080 5150112
21:10:23 59906 8192000000 10903184112 11380219904 1978030640 19.449 100 12 24 2 1994797408 13050736 3716032
21:12:39 52878 8192000000 10916574352 11390234624 1957331840 19.285 99 14 28 0 1976044752 14861856 3851056
21:13:56 83271 8192000000 10902678752 11391287296 1973147408 19.410 100 13 26 1 1993322768 16632512 3542848
21:15:27 19317 8192000000 10931198304 11385442304 1982333728 19.483 100 20 40 1 1996500544 8913104 5253712
21:15:53 71862 8192000000 10909780928 11389947904 1968517328 19.374 99 23 46 1 1986603008 11472800 6612880
21:17:13 55174 8192000000 10911860944 11392860160 1986791776 19.518 100 9 18 1 2001095952 11645248 2658928
21:18:15 20910 8192000000 10900634624 11386527744 1970677152 19.391 99 16 32 1 1985276880 9708128 4891600
21:18:57 67358 8192000000 10904025456 11389607936 1978323472 19.451 100 11 22 1 1992487456 11150816 3013168
21:20:17 77917 8192000000 10886152112 11352403968 1898380704 18.813 96 10 19 1 1909646928 8374608 2891616
21:21:47 36976 8192000000 10899346784 11357077504 1924344096 19.022 98 18 36 1 1937050576 7623856 5082624
21:22:32 15454 8192000000 10906242464 11361603584 1972868752 19.408 100 59 117 1 1998206368 8254192 17083424
21:22:56 32053 8192000000 10900328704 11354292224 1948212704 19.212 99 28 56 3 1968811072 12721152 7877216
21:23:40 88022 8192000000 10913507056 11388596224 1947524896 19.207 99 19 38 1 1966622176 13607520 5489760
21:25:15 69677 8192000000 10897188560 11378950144 1941596080 19.159 98 11 22 0 1962871184 18479952 2795152
21:27:15 30074 8192000000 10901052800 11363717120 1948664176 19.216 99 21 40 0 1961663616 7179792 5819648
21:27:51 19405 8192000000 10888253632 11344343040 1913748880 18.937 97 33 66 0 1932067008 9501104 8817024
21:28:20 30040 8192000000 10866985856 11322408960 1879090928 18.658 96 36 72 0 1900092944 11381280 9620736
21:28:56 43278 8192000000 10873976496 11343761408 1912890624 18.930 98 22 44 0 1932844704 13965232 5988848
21:29:46 31997 8192000000 10887513600 11343585280 1903533552 18.855 97 27 52 1 1921220864 10735184 6952128
21:30:28 28660 8192000000 10872668112 11339034624 1898031856 18.810 98 23 45 2 1922242112 18016560 6193696
21:31:03 62153 8192000000 10877288032 11345350656 1881189120 18.675 97 13 26 0 1901506720 16988752 3328848
21:32:12 66220 8192000000 10884965456 11358920704 1907374704 18.886 98 21 42 3 1931607888 17742624 6490560
21:33:30 17073 8192000000 10875828416 11329929216 1928987376 19.059 99 29 56 1 1949812480 12312448 8512656
21:33:54 21891 8192000000 10879958672 11326390272 1898980448 18.818 98 39 78 1 1923362992 13701488 10681056
21:34:24 15742 8192000000 10889356800 11337850880 1915600080 18.952 99 39 78 1 1942001344 15524576 10876688
21:34:51 39279 8192000000 10857879648 11322966016 1870926160 18.592 97 37 74 1 1904383264 22744688 10712416
21:35:37 66962 8192000000 10849604000 11314352128 1913943024 18.938 100 11 22 1 1933524320 16479648 3101648
21:37:00 65239 8192000000 10855911792 11317690368 1837700096 18.322 95 22 45 0 1851656736 7830048 6126592
21:38:21 65925 8192000000 10871772304 11324633088 1882084080 18.682 97 46 88 3 1908228160 12564512 13579568
21:39:34 50449 8192000000 10866388608 11332374528 1933955584 19.098 100 43 85 1 1959278816 13450720 11872512
21:40:32 40114 8192000000 10857158464 11328376832 1933536608 19.095 100 13 26 2 1948401680 11024144 3840928
21:41:27 51303 8192000000 10871202944 11340820480 1912460880 18.926 99 14 27 0 1925388624 9409040 3518704
21:42:29 58880 8192000000 10825465120 11291013120 1859899760 18.502 96 17 34 1 1874833184 10155776 4777648
21:43:35 72979 8192000000 10870142192 11342987264 1937128912 19.124 100 15 30 1 1956839392 15207648 4502832
21:44:54 38123 8192000000 10877014080 11358146560 1943112080 19.172 100 10 20 0 1971770208 25268960 3389168
21:45:43 72958 8192000000 10863408032 11349602304 1886391456 18.717 97 15 30 0 1912842512 22074752 4376304
21:47:11 74854 8192000000 10861118672 11345846272 1922646640 19.008 99 11 22 1 1947506768 21477696 3382432
21:48:34 32968 8192000000 10885984032 11352264704 1930735552 19.073 99 22 46 1 1948462768 11909568 5817648
21:49:18 42305 8192000000 10872601488 11346141184 1930889936 19.074 99 38 76 0 1953905936 12230880 10785120
21:50:07 61859 8192000000 10899441440 11344875520 1893098992 18.771 97 31 62 1 1909729360 8059744 8570624
21:51:15 16711 8192000000 10896197712 11349921792 1950355488 19.229 100 47 94 1 1973468352 10362144 12750720
21:51:43 31371 8192000000 10873833360 11340509184 1906977760 18.882 98 36 71 2 1928664352 12372400 9314192
21:52:22 56646 8192000000 10886902928 11353894912 1942346208 19.165 100 27 53 2 1960813680 10802048 7665424
21:53:30 30141 8192000000 10896131808 11351191552 1939924224 19.146 99 29 58 0 1957363344 9776816 7662304
21:54:06 40407 8192000000 10896740336 11364130816 1959042848 19.298 100 41 81 1 1984692544 14606064 11043632
21:54:53 99020 8192000000 10897047984 11388678144 1919122064 18.980 98 15 29 1 1936621776 13800368 3699344
21:56:38 76030 8192000000 10891941312 11369590784 1881768512 18.679 96 16 32 0 1909266304 23169216 4328576
21:58:00 57861 8192000000 10906702256 11392512000 1949878704 19.226 99 10 20 0 1979561424 27019568 2663152
21:59:04 127448 8192000000 10904486080 11375689728 1966229216 19.356 100 18 36 1 1985731296 14458032 5044048
22:01:25 62481 8192000000 10913589984 11373690880 1957639952 19.287 99 18 36 0 1975987136 13288416 5058768
22:02:33 38124 8192000000 10926476608 11397828608 1987703008 19.526 100 41 82 2 2015531296 15733808 12094480
22:03:30 74006 8192000000 10892952000 11389870080 1942825808 19.169 98 7 14 0 1966870496 22033280 2011408
22:04:50 35255 8192000000 10880357904 11356520448 1954029744 19.259 99 11 23 1 1969330992 12502240 2799008
22:05:32 37851 8192000000 10905710064 11381702656 1983665504 19.494 100 29 59 0 1999206368 7736048 7804816
22:06:19 68255 8192000000 10900579136 11376840704 1946264592 19.197 98 17 34 1 1963657584 12256832 5136160
22:07:34 80236 8192000000 10908192784 11388633088 1975848320 19.432 100 12 25 1 1995004896 14751152 4405424
22:09:04 54754 8192000000 10901672752 11378782208 1957355472 19.285 99 9 19 1 1967862512 7303808 3203232
22:10:05 47274 8192000000 10890552816 11364896768 1942499488 19.167 98 13 26 1 1957705376 11018688 4187200
22:10:58 55796 8192000000 10862353680 11346915328 1853765536 18.453 94 14 28 1 1871407888 13363664 4278688
22:12:25 16015 8192000000 10878634544 11343716352 1916269776 18.957 98 40 79 0 1933624304 6583312 10771216
22:12:52 26602 8192000000 10870825584 11334316032 1935076624 19.107 100 23 46 1 1949805776 8424688 6304464
22:13:25 27564 8192000000 10888657984 11338584064 1908785184 18.897 98 32 64 3 1926465376 8681584 8998608
22:13:59 43581 8192000000 10855618768 11326488576 1903318960 18.853 98 28 56 1 1922769712 11415408 8035344
22:15:45 76247 8192000000 10880544880 11347525632 1911176736 18.916 98 14 28 2 1930182608 14904256 4101616
22:17:23 59964 8192000000 10882924944 11352899584 1913819232 18.937 98 21 42 4 1930700880 10677808 6203840
22:18:30 31052 8192000000 10893014992 11361067008 1937839536 19.130 99 26 51 2 1954997040 10329104 6828400
22:19:09 50693 8192000000 10888200512 11347095552 1879262256 18.659 96 31 62 1 1898367824 10463904 8641664
22:20:06 27639 8192000000 10876915952 11329785856 1889809840 18.744 97 33 66 1 1913179984 14808384 8561760
22:20:41 30469 8192000000 10885564464 11341737984 1912267472 18.925 98 45 90 0 1936717200 12213440 12236288
22:21:20 112062 8192000000 10855146208 11330916352 1889776352 18.744 98 23 46 1 1909333232 13568192 5988688
22:23:23 86444 8192000000 10848801968 11325186048 1878862848 18.656 97 14 27 1 1893158384 10076976 4218560
22:25:02 53697 8192000000 10845157888 11324723200 1907563088 18.887 99 9 18 3 1918916080 9121024 2231968
22:26:24 58453 8192000000 9762118736 10117079040 897865520 9.877 47 4 8 1 903423344 4482048 1075776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 06-02-2021 22:29:37 to 06-02-2021 22:30:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 98 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-02-2021 22:30:10 to 06-02-2021 22:30:12.

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          239533
MON$OLDEST_ACTIVE               242290
MON$OLDEST_SNAPSHOT             242290
MON$NEXT_TRANSACTION            242290
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                       2038752
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 ---
:36: 
:37: mscs-test-161.budzdorov.ru    Sat Feb  6 22:27:32 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Sat Feb  6 22:27:32 2021
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43: 
:44: 
:45: mscs-test-161.budzdorov.ru    Sat Feb  6 22:27:32 2021
:46:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:47: 
:48: 
:49: mscs-test-161.budzdorov.ru    Sat Feb  6 22:27:34 2021
:50:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:51: 
--- end of diff output ---

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

06.02.21 22:30:13. 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-06 22:30:15 No severe PSQL-related problems occured
06.02.21 22:30:17. End of report.