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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17212240 kB
MemAvailable 31482540 kB
Buffers 0 kB
Cached 14464232 kB
SwapCached 3092 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-11-23 22:27:08
DTS_END                         2020-11-23 22:27:08.0230
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/54874
TRN_ID                          238058
ATT_ID                          713
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: 9765.00 23706 1171800
customer order: creation 165.46 378 19855
customer order: refuse 14.50 340 1740
order to supplier: creation 45.12 1157 5414
order to supplier: removal 3.74 110083 449
invoice (draft): creation 43.83 2945 5260
invoice (draft): removal 58.65 758 7038
invoice accept: apply 40.88 17426 4906
invoice accept: cancel 53.26 688 6391
customer reserve: creation 3818.82 170 458258
customer reserve: removal 5215.47 62 625856
realization accept: apply 81.07 191 9728
realization accept: cancel 100.26 121 12031
payment from customer: creation 56.34 132 6761
payment from customer: removal 5.38 70 645
payment to supplier: creation 46.99 149 5639
payment to supplier: removal 3.62 66 434
service: total inventory turnovers 4.92 1199 590
service: total monetary turnovers 5.93 31 711
service: aggregate perf. data 0.75 25669 90
service: refresh index statistics 0.03 312490 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-11-2020 22:28:01 to 23-11-2020 22:28:03.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6497
TEST_TIME 2 4967
TEST_TIME 3 4312
TEST_TIME 4 4386
TEST_TIME 5 4464
TEST_TIME 6 5060
TEST_TIME 7 5294
TEST_TIME 8 5482
TEST_TIME 9 5543
TEST_TIME 10 5427
TEST_TIME 11 5521
TEST_TIME 12 5531
TEST_TIME 13 6051
TEST_TIME 14 6369
TEST_TIME 15 6547
TEST_TIME 16 7087
TEST_TIME 17 7345
TEST_TIME 18 7270
TEST_TIME 19 7247
TEST_TIME 20 7718
TEST_TIME 21 8514
TEST_TIME 22 8537
TEST_TIME 23 9388
TEST_TIME 24 9331
TEST_TIME 25 9842
TEST_TIME 26 9789
TEST_TIME 27 9894
TEST_TIME 28 11701
TEST_TIME 29 11519
TEST_TIME 30 11431
TEST_TIME 31 11442
TEST_TIME 32 11249
TEST_TIME 33 11217
TEST_TIME 34 11247
TEST_TIME 35 11161
TEST_TIME 36 11121
TEST_TIME 37 11016
TEST_TIME 38 10747
TEST_TIME 39 10806
TEST_TIME 40 10669
TEST_TIME 41 10585
TEST_TIME 42 10474
TEST_TIME 43 10337
TEST_TIME 44 10453
TEST_TIME 45 10410
TEST_TIME 46 10442
TEST_TIME 47 10309
TEST_TIME 48 10314
TEST_TIME 49 10234
TEST_TIME 50 10195
TEST_TIME 51 10055
TEST_TIME 52 10054
TEST_TIME 53 10108
TEST_TIME 54 10147
TEST_TIME 55 10048
TEST_TIME 56 9923
TEST_TIME 57 9885
TEST_TIME 58 9877
TEST_TIME 59 9916
TEST_TIME 60 9922
TEST_TIME 61 9928
TEST_TIME 62 9936
TEST_TIME 63 9995
TEST_TIME 64 10044
TEST_TIME 65 10021
TEST_TIME 66 10125
TEST_TIME 67 10097
TEST_TIME 68 10114
TEST_TIME 69 10126
TEST_TIME 70 10142
TEST_TIME 71 10276
TEST_TIME 72 10297
TEST_TIME 73 10277
TEST_TIME 74 10148
TEST_TIME 75 10187
TEST_TIME 76 10087
TEST_TIME 77 10061
TEST_TIME 78 10076
TEST_TIME 79 10005
TEST_TIME 80 9992
TEST_TIME 81 9970
TEST_TIME 82 9927
TEST_TIME 83 9857
TEST_TIME 84 9845
TEST_TIME 85 9856
TEST_TIME 86 9843
TEST_TIME 87 9928
TEST_TIME 88 9927
TEST_TIME 89 9901
TEST_TIME 90 9882
TEST_TIME 91 9932
TEST_TIME 92 9984
TEST_TIME 93 9947
TEST_TIME 94 10009
TEST_TIME 95 10010
TEST_TIME 96 10040
TEST_TIME 97 10024
TEST_TIME 98 10043
TEST_TIME 99 10048
TEST_TIME 100 10010
TEST_TIME 101 9935
TEST_TIME 102 9927
TEST_TIME 103 9914
TEST_TIME 104 9869
TEST_TIME 105 9914
TEST_TIME 106 9848
TEST_TIME 107 9838
TEST_TIME 108 9808
TEST_TIME 109 9846
TEST_TIME 110 9783
TEST_TIME 111 9778
TEST_TIME 112 9763
TEST_TIME 113 9806
TEST_TIME 114 9801
TEST_TIME 115 9766
TEST_TIME 116 9767
TEST_TIME 117 9820
TEST_TIME 118 9838
TEST_TIME 119 9824
TEST_TIME 120 9770

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-11-2020 22:28:05 to 23-11-2020 22:28:08.

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 1598157 1598157 0 0.00 0 19850 6 0 0
doc_list_biud 1598157 1598157 0 0.00 0 42934 30 0 0
sp_add_invoice_to_stock 5071 4906 165 3.25 27 178621 17427 0 165
sp_cancel_adding_invoice 6391 6391 0 0.00 4 116820 688 0 0
sp_cancel_client_order 1740 1740 0 0.00 4 13282 340 0 0
sp_cancel_customer_reserve 625856 625856 0 0.00 1 42935 62 0 0
sp_cancel_pay_from_customer 645 645 0 0.00 2 4289 70 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 3 3479 67 0 0
sp_cancel_supplier_invoice 7048 7038 10 0.14 2 19083 758 0 10
sp_cancel_supplier_order 449 449 0 0.00 10 1014855 110084 0 0
sp_cancel_write_off 12031 12031 0 0.00 1 23752 122 0 0
sp_client_order 19855 19855 0 0.00 4 28911 379 0 0
sp_customer_reserve 458258 458258 0 0.00 0 116045 171 0 0
sp_fill_shopping_cart 30529 30529 0 0.00 1 13844 33 0 0
sp_fill_shopping_cart_clo_res 458252 458252 0 0.00 0 17982 12 0 0
sp_get_clo_for_invoice 4896 4896 0 0.00 0 13781 247 0 0
sp_kill_cost_storno 19501 19501 0 0.00 0 5828 60 0 0
sp_kill_qstorno_ret_qs2qd 1271230 1271230 0 0.00 0 42923 33 0 0
sp_kill_qty_storno 668128 668128 0 0.00 0 42934 71 0 0
sp_lock_selected_doc 20315 20315 0 0.00 0 11577 6 0 0
sp_make_cost_storno 27023 27023 0 0.00 0 19747 56 0 0
sp_multiply_rows_for_pdistr 27023 27023 0 0.00 0 8757 31 0 0
sp_multiply_rows_for_qdistr 19855 19855 0 0.00 0 12784 166 0 0
sp_pay_from_customer 6761 6761 0 0.00 4 11936 132 0 0
sp_pay_to_supplier 5639 5639 0 0.00 6 19870 150 0 0
sp_payment_common 12400 12400 0 0.00 1 11800 39 0 0
sp_qd_handle_on_cancel_clo 1740 1740 0 0.00 0 13248 310 0 0
sp_qd_handle_on_invoice_upd_sts 11286 11286 0 0.00 0 18888 299 0 0
sp_qd_handle_on_reserve_upd_sts 9728 9728 0 0.00 0 17606 66 0 0
sp_reserve_write_off 9728 9728 0 0.00 6 19059 192 0 0
sp_supplier_invoice 5260 5260 0 0.00 8 103282 2946 0 0
sp_supplier_order 5414 5414 0 0.00 6 27696 1158 0 0
srv_aggregate_perf_data 90 90 0 0.00 2455 632326 25669 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1093 136953 33090 0 0
srv_find_qd_qs_mism 1126406 1126406 0 0.00 0 16821 4 0 0
srv_make_invnt_saldo 590 590 0 0.00 57 73509 1200 0 0
srv_make_money_saldo 711 711 0 0.00 0 4079 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 143593 556216 312491 0 0
t$perf-abend:sp_add_invoice_to_stock 165 165 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4906 4906 0 0.00 0 15189 180 0 0
t$perf-norm:sp_cancel_adding_invoice 402 402 0 0.00 1 5965 107 0 0
t$perf-norm:sp_cancel_client_order 1740 1740 0 0.00 0 18198 34 0 0
t$perf-norm:sp_cancel_customer_reserve 663 663 0 0.00 0 6193 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 645 645 0 0.00 0 1840 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 2675 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 1643 20 0 0
t$perf-norm:sp_cancel_supplier_order 449 449 0 0.00 0 23322 1534 0 0
t$perf-norm:sp_cancel_write_off 960 960 0 0.00 0 1517 8 0 0
t$perf-norm:sp_client_order 19855 19855 0 0.00 0 12115 17 0 0
t$perf-norm:sp_customer_reserve 982 982 0 0.00 0 4769 12 0 0
t$perf-norm:sp_pay_from_customer 6761 6761 0 0.00 0 5228 11 0 0
t$perf-norm:sp_pay_to_supplier 5639 5639 0 0.00 0 5720 14 0 0
t$perf-norm:sp_reserve_write_off 9728 9728 0 0.00 0 18292 16 0 0
t$perf-norm:sp_supplier_invoice 5260 5260 0 0.00 0 6602 19 0 0
t$perf-norm:sp_supplier_order 5414 5414 0 0.00 0 7114 19 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 484 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 285 5 0 0
t$perf-norm:srv_make_invnt_saldo 590 590 0 0.00 0 9397 35 0 0
t$perf-norm:srv_make_money_saldo 711 711 0 0.00 0 776 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10120 9790 330 3.26 0 11509 21 0 330
v_all_customers 36574 36574 0 0.00 0 86 1 0 0
v_all_suppliers 29710 29710 0 0.00 0 14 1 0 0
v_all_wares 39710 39710 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 804 804 0 0.00 0 4714 12 0 0
v_cancel_client_order 3480 3480 0 0.00 0 3254 7 0 0
v_cancel_customer_prepayment 1290 1290 0 0.00 0 4258 7 0 0
v_cancel_customer_reserve 1326 1326 0 0.00 0 1886 5 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 2229 8 0 0
v_cancel_supplier_invoice 818 798 20 2.44 0 2005 15 0 20
v_cancel_supplier_order 898 898 0 0.00 0 2970 10 0 0
v_cancel_write_off 1920 1920 0 0.00 0 19008 30 0 0
v_max_id_clo_ord 5414 5414 0 0.00 0 8877 3 0 0
v_max_id_clo_res 982 982 0 0.00 0 2010 14 0 0
v_max_id_ord_sup 5260 5260 0 0.00 0 1997 2 0 0
v_max_non_paid_invoice 1458 1458 0 0.00 0 5790 7 0 0
v_max_non_paid_realizn 3379 3379 0 0.00 0 6337 10 0 0
v_min_id_clo_ord 5414 5414 0 0.00 0 8237 9 0 0
v_min_id_clo_res 982 982 0 0.00 0 9098 17 0 0
v_min_id_ord_sup 5260 5260 0 0.00 0 7345 4 0 0
v_min_non_paid_invoice 5639 5639 0 0.00 0 9935 28 0 0
v_min_non_paid_realizn 6761 6761 0 0.00 0 11794 21 0 0
v_our_firm 9900 9900 0 0.00 0 85 1 0 0
v_reserve_write_off 19456 19456 0 0.00 0 18991 8 0 0
x_lock_depdocs_on_canc_invoice 13030 13030 0 0.00 0 25306 125 0 0
x_lock_depdocs_on_canc_sup_ord 449 449 0 0.00 0 7731 354 0 0
x_make_qstorno_1000_1200 5414 5414 0 0.00 2 27689 1081 0 0
x_make_qstorno_1200_2000 5260 5260 0 0.00 3 103187 2836 0 0
x_make_qstorno_2100_3300 458258 458258 0 0.00 0 116043 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-11-2020 22:28:09 to 23-11-2020 22:28:13.

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:11 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:18 26325 8192000000 10284840768 10595225600 945410832 10.346 71 55 113 0 965583824 2543184 17629808
19:57:52 24921 8192000000 10349717344 10668183552 1396896576 14.567 100 89 177 0 1431267104 5088816 29281712
19:58:29 17781 8192000000 10391536848 10713563136 1442764576 14.974 100 90 180 0 1478835808 6648368 29422864
19:58:57 14412 8192000000 10408741808 10736209920 1468212688 15.198 100 93 186 1 1506248112 7729008 30306416
19:59:26 9908 8192000000 10423772688 10757378048 1486457840 15.358 100 88 176 0 1523184304 8465168 28261296
19:59:47 15803 8192000000 10443547904 10780250112 1499694176 15.474 100 84 168 0 1535631504 8819536 27117792
20:00:18 10811 8192000000 10462315120 10800058368 1517376400 15.627 100 89 178 1 1555017376 9558160 28082816
20:00:38 21034 8192000000 10482327424 10821922816 1540374096 15.827 100 90 180 0 1578564944 10048192 28142656
20:01:10 3900 8192000000 10494147536 10838372352 1552750800 15.934 100 84 168 0 1589368304 10665200 25952304
20:01:24 18163 8192000000 10522738576 10869497856 1575482048 16.129 100 84 168 0 1612142672 10939424 25721200
20:01:53 16792 8192000000 10529107792 10883362816 1590189888 16.255 100 80 160 0 1625844736 11360416 24294432
20:02:22 13063 8192000000 10549328112 10908585984 1606200384 16.392 100 77 154 3 1640723744 11595952 22927408
20:02:44 20626 8192000000 10585961248 10945077248 1634063584 16.629 100 84 167 0 1674709376 16400960 24244832
20:03:14 12053 8192000000 10596244496 10960977920 1657558016 16.828 100 78 156 0 1692743152 12093824 23091312
20:03:33 6569 8192000000 10610262880 10976796672 1674127472 16.968 100 79 157 1 1709166896 12389920 22649504
20:03:47 10225 8192000000 10638054064 11007619072 1694086240 17.136 100 80 159 1 1730037104 12053744 23897120
20:04:05 6193 8192000000 10648154768 11025252352 1712425520 17.289 100 78 156 3 1747492688 12384800 22682368
20:04:19 7539 8192000000 10666445920 11042828288 1725450272 17.398 100 84 167 1 1762125120 12668448 24006400
20:04:33 5748 8192000000 10677366592 11053985792 1738678304 17.508 100 82 164 0 1774438272 12348224 23411744
20:04:47 5147 8192000000 10683782496 11065020416 1748241392 17.587 100 75 150 0 1781795552 12520352 21033808
20:04:59 5075 8192000000 10704890864 11081662464 1761976048 17.701 100 84 169 0 1799754816 13949104 23829664
20:05:13 3195 8192000000 10719999024 11096039424 1772468224 17.787 100 90 179 1 1811763776 14081984 25213568
20:05:24 4715 8192000000 10715784576 11097919488 1780353696 17.852 100 90 180 0 1820263552 14309664 25600192
20:05:37 5007 8192000000 10726627552 11105570816 1787433072 17.911 100 91 182 1 1827134288 13627040 26074176
20:05:50 3223 8192000000 10727878640 11107053568 1791181696 17.941 100 90 179 2 1830602640 13911264 25509680
20:06:02 2706 8192000000 10740358048 11122778112 1806340656 18.066 100 94 185 3 1845822624 13884528 25597440
20:06:12 2535 8192000000 10747255696 11133538304 1810029488 18.096 100 85 170 1 1847352208 13786416 23536304
20:06:21 4188 8192000000 10749538032 11138469888 1810766272 18.102 100 78 156 4 1846563120 13273136 22523712
20:06:31 6801 8192000000 10747826528 11139301376 1820048272 18.178 100 71 139 4 1851238512 11984096 19206144
20:06:45 3132 8192000000 10782780064 11174244352 1840094304 18.342 100 81 162 2 1875186368 12672688 22419376
20:06:54 2393 8192000000 10792326656 11182178304 1849959120 18.422 100 91 183 1 1890352768 14267984 26125664
20:07:03 2261 8192000000 10791437472 11183513600 1854709152 18.460 100 84 168 1 1890756336 12606112 23441072
20:07:12 2082 8192000000 10808744976 11198054400 1858621488 18.492 100 89 178 0 1896580768 13632128 24327152
20:07:20 2104 8192000000 10806338656 11197169664 1861667696 18.517 100 92 184 0 1903039808 15873728 25498384
20:07:29 1448 8192000000 10814009184 11204358144 1866052128 18.552 100 92 186 1 1904895840 13319888 25523824
20:07:37 1736 8192000000 10813177824 11201372160 1870072208 18.585 100 92 184 1 1909040752 12996096 25972448
20:07:45 1359 8192000000 10812061440 11201396736 1871390208 18.596 100 91 180 1 1910634736 14015296 25229232
20:07:53 1669 8192000000 10820276960 11210149888 1873033712 18.609 100 93 184 0 1912508320 14070464 25404144
20:08:01 2161 8192000000 10821233808 11211886592 1880278976 18.667 100 91 182 0 1919839840 13683184 25877680
20:08:11 1167 8192000000 10819161472 11214966784 1880477200 18.669 100 82 164 3 1915955936 12938736 22540000
20:08:18 2288 8192000000 10802765120 11212386304 1875644304 18.630 100 62 120 1 1904213344 11919984 16649056
20:08:27 3816 8192000000 10817044448 11217948672 1882318336 18.684 100 60 121 0 1910831152 11643776 16869040
20:08:37 2887 8192000000 10809126128 11215372288 1878987424 18.657 100 53 106 0 1904359664 10717120 14655120
20:08:47 3888 8192000000 10796957360 11211677696 1878772880 18.655 100 42 84 0 1899734000 9526704 11434416
20:08:58 5304 8192000000 10782826944 11215589376 1879891200 18.664 100 34 69 0 1896869664 6962496 10015968
20:09:13 6233 8192000000 10795684544 11217125376 1881795520 18.680 100 37 74 3 1897819904 6504336 9520048
20:10:13 21178 8192000000 10801422032 11229233152 1888173808 18.731 100 38 74 0 1906574688 8226512 10174368
20:10:41 3907 8192000000 10817007168 11236012032 1890323168 18.748 100 33 66 1 1907563184 7178208 10061808
20:10:51 6697 8192000000 10817041376 11240882176 1895074128 18.787 100 42 84 4 1915042048 8002656 11965264
20:11:07 6055 8192000000 10809391792 11238993920 1893755136 18.776 100 27 54 2 1908062144 6619440 7687568
20:11:19 3259 8192000000 10823047296 11245637632 1899826384 18.825 100 41 83 0 1919721072 8155728 11738960
20:11:30 5936 8192000000 10809000816 11244814336 1896629968 18.799 100 23 46 1 1909999520 6447040 6922512
20:11:42 4877 8192000000 10821043216 11250601984 1899197536 18.820 100 37 75 1 1915782464 6210384 10374544
20:11:54 8249 8192000000 10817572144 11244720128 1900110304 18.827 100 31 62 0 1914007328 4937792 8959232
20:12:10 9021 8192000000 10814080960 11247124480 1896348880 18.797 100 20 40 0 1908152800 6567104 5236816
20:12:26 12595 8192000000 10813761136 11247783936 1899592256 18.823 100 23 46 2 1911903360 6207552 6103552
20:12:45 6738 8192000000 10816538352 11248578560 1901679536 18.840 100 25 50 0 1915592688 6227760 7685392
20:12:58 5462 8192000000 10811531392 11248037888 1903403904 18.854 100 24 46 0 1915338096 5788512 6145680
20:13:10 7188 8192000000 10812937072 11248541696 1902174608 18.844 100 27 54 1 1915872752 5704464 7993680
20:13:23 11640 8192000000 10803942608 11249623040 1901875488 18.841 100 19 38 2 1914014272 6736768 5402016
20:13:41 17245 8192000000 10814084368 11255291904 1904584864 18.863 100 35 70 4 1924409680 10291600 9533216
20:14:05 62655 8192000000 10808465040 11252719616 1907239744 18.884 100 22 42 0 1918790480 5056288 6494448
20:15:14 8348 8192000000 10818750592 11259400192 1904894752 18.866 100 21 42 0 1916358048 5587792 5875504
20:15:36 6483 8192000000 10805275920 11242782720 1865544576 18.548 98 15 27 2 1874506336 5051360 3910400
20:15:49 6074 8192000000 10812186144 11251310592 1896884672 18.801 100 25 50 1 1910647856 5559504 8203680
20:16:01 10854 8192000000 10812651312 11246440448 1882372304 18.684 99 19 38 1 1893666512 6249968 5044240
20:16:18 6812 8192000000 10815804656 11246243840 1895405968 18.789 100 32 63 1 1912021600 7542032 9073600
20:16:35 6727 8192000000 10807594944 11244908544 1893861760 18.777 100 34 68 3 1911119488 7407568 9850160
20:16:50 6541 8192000000 10797277824 11226755072 1870642528 18.589 99 25 50 2 1883733792 6303120 6788144
20:17:02 4960 8192000000 10754485424 11179114496 1803853136 18.046 97 19 38 3 1815544992 5310448 6381408
20:17:16 7780 8192000000 10761958400 11191050240 1846152336 18.391 100 23 46 1 1859318928 6471472 6695120
20:17:33 6647 8192000000 10757502608 11181936640 1823650032 18.208 99 29 56 1 1842399488 11132816 7616640
20:17:48 6028 8192000000 10747900464 11173441536 1817343040 18.156 98 21 42 2 1829068640 5292432 6433168
20:18:01 8152 8192000000 10745561824 11171962880 1806708096 18.069 98 29 58 2 1821006336 5779968 8518272
20:18:19 6497 8192000000 10735980400 11156389888 1804636224 18.052 99 18 36 1 1815156304 5034640 5485440
20:18:39 70213 8192000000 10649618192 11057979392 1477047248 15.276 82 23 46 0 1488808960 4171152 7590560
20:19:57 9398 8192000000 10655829456 11066015744 1666571856 16.904 95 17 34 2 1677140544 5137808 5430880
20:20:15 8070 8192000000 10656261808 11056365568 1665536480 16.896 95 24 47 1 1677944256 6089360 6318416
20:20:32 8729 8192000000 10693995072 11111411712 1768047168 17.751 99 20 40 0 1779812112 5632608 6132336
20:20:48 4515 8192000000 10717905696 11127926784 1794996080 17.973 100 30 60 1 1810748208 7457136 8294992
20:20:59 4580 8192000000 10731354736 11141963776 1813809328 18.127 100 36 72 2 1832205392 7281264 11114800
20:21:11 4796 8192000000 10726978880 11139686400 1796758192 17.987 99 27 54 1 1810820896 5779680 8283024
20:21:22 8187 8192000000 10737202384 11158900736 1819840096 18.176 100 28 57 1 1834645248 6422736 8382416
20:21:38 8083 8192000000 10727556304 11141210112 1807432256 18.075 100 22 44 3 1819727376 5905984 6389136
20:21:57 4122 8192000000 10739139216 11140620288 1809747456 18.094 100 46 92 1 1829533280 5550736 14235088
20:22:11 13021 8192000000 10738938528 11156250624 1817798480 18.160 100 27 54 1 1830990032 4915248 8276304
20:22:31 11039 8192000000 10739212464 11161542656 1814828880 18.135 99 15 31 1 1824622640 5186624 4607136
20:22:52 8300 8192000000 10743904272 11169001472 1833625968 18.289 100 14 28 1 1843002816 5323200 4053648
20:23:07 11023 8192000000 10744636928 11171676160 1818156704 18.163 99 11 20 0 1825668496 4766272 2745520
20:23:24 11673 8192000000 10753381072 11171942400 1838299840 18.327 100 13 26 0 1846871248 5115472 3455936
20:23:43 71209 8192000000 10752180896 11178569728 1829482144 18.255 99 34 68 0 1845697552 6163696 10051712
20:25:00 9972 8192000000 10768661616 11188408320 1847953312 18.405 100 23 45 0 1860357584 6453184 5951088
20:25:16 4301 8192000000 10770171840 11192954880 1852932224 18.446 100 40 80 1 1872157792 7896896 11328672
20:25:29 11285 8192000000 10775826496 11197284352 1856389792 18.474 100 33 66 0 1872985792 7158752 9437248
20:25:49 7740 8192000000 10779829088 11204468736 1861371840 18.514 100 31 62 3 1878358016 7459552 9526624
20:26:03 9908 8192000000 10770880608 11204063232 1863115872 18.529 100 18 36 0 1873706848 5730176 4860800
20:26:19 6150 8192000000 10776734464 11207798784 1868022832 18.568 100 25 49 2 1881368480 5968320 7377328
20:26:39 12729 8192000000 10781624480 11213852672 1870451440 18.588 100 13 26 2 1879776832 5346720 3978672
20:26:58 9540 8192000000 10793330048 11223375872 1875081280 18.625 100 23 46 2 1891168304 9873296 6213728
20:27:18 13327 8192000000 10824399968 11240259584 1899919808 18.826 100 41 81 2 1916154400 4632832 11601760
20:27:42 22777 8192000000 10831494816 11256877056 1907272176 18.885 100 36 72 0 1925717248 8720032 9725040
20:28:12 11905 8192000000 10851339840 11267416064 1917155264 18.964 100 48 96 0 1940908192 10031392 13721536
20:28:38 3680 8192000000 10866206992 11279429632 1928017424 19.051 100 66 131 1 1958262336 12467952 17776960
20:28:50 18753 8192000000 10868008576 11287621632 1930422448 19.070 100 62 122 2 1960522240 12637920 17461872
20:29:29 11813 8192000000 10878246800 11297443840 1939246544 19.141 100 55 109 2 1969104208 14950896 14906768
20:29:49 62615 8192000000 10892974160 11313958912 1943254656 19.173 100 60 120 2 1976130400 16083952 16791792
20:31:26 24919 8192000000 10871427056 11311398912 1944684576 19.184 100 31 62 1 1972758688 19166432 8907680
20:32:00 23306 8192000000 10886685104 11318255616 1949556144 19.223 100 35 70 2 1979328160 19377792 10394224
20:32:30 26152 8192000000 10892905296 11330678784 1953146832 19.252 100 34 68 1 1982739136 19810960 9781344
20:33:07 6111 8192000000 10904990144 11333525504 1962916032 19.329 100 40 81 0 1997870720 22037424 12917264
20:33:23 23935 8192000000 10902182816 11343568896 1962760096 19.328 100 37 74 3 1996836352 23014304 11061952
20:33:59 20859 8192000000 10932966976 11360690176 1979478000 19.461 100 54 108 1 2019024832 23311952 16234880
20:34:39 9218 8192000000 10941701904 11372380160 1990870224 19.551 100 48 95 2 2031134304 26840560 13423520
20:34:56 1362 8192000000 10967303248 11380727808 1995817184 19.590 100 69 137 0 2042508992 26862480 19829328
20:35:04 4513 8192000000 10953787088 11380744192 1997965024 19.607 100 64 128 1 2044032528 27307808 18759696
20:35:16 9550 8192000000 10959401712 11386425344 1981776320 19.479 99 66 130 2 2032926896 32463056 18687520
20:35:36 5608 8192000000 10957217808 11386429440 1996887552 19.598 100 58 115 1 2042862672 29524464 16450656
20:35:56 12474 8192000000 10955732528 11384238080 1997927920 19.606 100 68 132 2 2047389872 29412976 20048976
20:36:19 2485 8192000000 10950709328 11377537024 1995742528 19.589 100 62 122 0 2042139776 27934048 18463200
20:36:37 13521 8192000000 10948240432 11381489664 1982685920 19.486 99 50 100 4 2026839104 28465392 15687792
20:37:01 8446 8192000000 10971199664 11395895296 2003219376 19.648 100 60 119 1 2055201584 33775824 18206384
20:37:28 7884 8192000000 10972880736 11401289728 2010921536 19.709 100 59 116 1 2062910256 34430768 17557952
20:37:47 6248 8192000000 10985730416 11407503360 2011297968 19.712 100 74 148 3 2074168336 39847024 23023344
20:38:01 2447 8192000000 10999078560 11421171712 2019359648 19.775 100 74 148 0 2083815856 42268256 22187952
20:38:15 8334 8192000000 10991072112 11420131328 2020755776 19.786 100 71 142 0 2079916160 38121088 21039296
20:38:34 9426 8192000000 10997672256 11425501184 2021982400 19.796 100 66 130 2 2082928176 41227728 19718048
20:38:54 6507 8192000000 10997168768 11429478400 2025974816 19.827 100 67 134 2 2088703664 42324272 20404576
20:39:09 6090 8192000000 11000830448 11423301632 2004774080 19.660 99 66 132 1 2068415136 43079072 20561984
20:39:25 4597 8192000000 10998402144 11427872768 2022972832 19.803 100 69 137 0 2086542496 43291120 20278544
20:39:38 3509 8192000000 11001807104 11430379520 2023824832 19.810 100 72 142 0 2089012944 43734912 21453200
20:39:49 1679 8192000000 10997841472 11410067456 2003247552 19.648 99 80 158 0 2075133008 46932816 24952640
20:39:59 2627 8192000000 10998840048 11421609984 2014837312 19.740 100 82 163 0 2084059408 44804768 24417328
20:40:09 2553 8192000000 10991677408 11406188544 1995213472 19.585 99 79 158 1 2062165504 42471136 24480896
20:40:21 3953 8192000000 10993535824 11414155264 2009962240 19.701 100 71 142 1 2075763712 44184960 21616512
20:40:33 1953 8192000000 11002210928 11425255424 2020115328 19.781 100 86 172 2 2093205264 45293584 27796352
20:40:43 3521 8192000000 11000482560 11423444992 2005292208 19.664 99 75 149 2 2071606992 43955152 22359632
20:41:06 2826 8192000000 11003323104 11430244352 2018230896 19.766 100 71 142 1 2088723840 48610432 21882512
20:41:17 2296 8192000000 11027732048 11443449856 2027799808 19.841 100 85 168 1 2102681744 49524800 25357136
20:41:26 5315 8192000000 11024026128 11441123328 2025859824 19.826 100 87 172 3 2104310240 51658256 26792160
20:41:40 1088 8192000000 11020432512 11442597888 2026921904 19.834 100 80 160 0 2105706592 52918864 25865824
20:41:48 3003 8192000000 11015063424 11439837184 2026877968 19.834 100 88 175 2 2105435056 50247952 28309136
20:42:01 6995 8192000000 11017273296 11444838400 2027430064 19.838 100 71 142 1 2100903280 51373936 22099280
20:42:15 6590 8192000000 11012197616 11442012160 2015777552 19.747 99 76 152 1 2093079872 53710352 23591968
20:42:32 3573 8192000000 11024248096 11442909184 2011651104 19.715 99 80 158 2 2091653216 55269744 24732368
20:42:43 2054 8192000000 11025984016 11446161408 2023814208 19.810 100 81 160 1 2104592080 56754160 24023712
20:42:54 3842 8192000000 11027010272 11449151488 2028897472 19.850 100 76 150 0 2108069184 56210784 22960928
20:43:04 6030 8192000000 11006677376 11427606528 2002949712 19.646 99 84 170 2 2086395472 57093392 26352368
20:43:19 1609 8192000000 11028605488 11447914496 2028370560 19.846 100 88 174 1 2107882448 52211024 27300864
20:43:27 2071 8192000000 11016780160 11437785088 2021041632 19.788 100 83 167 2 2099075776 52039472 25994672
20:43:37 5241 8192000000 11007756848 11438657536 2017882112 19.764 100 70 138 1 2092981936 51829504 23270320
20:43:51 2367 8192000000 10997395792 11419283456 2002272912 19.641 100 77 150 2 2073867536 48322736 23271888
20:44:05 3720 8192000000 10989597488 11419353088 1990142288 19.545 99 74 147 0 2065749376 53017264 22589824
20:44:15 6504 8192000000 10972687600 11405230080 1967965712 19.369 98 53 107 0 2037894784 53137696 16791376
20:44:30 6820 8192000000 10977452208 11419553792 2002289904 19.641 100 47 94 1 2065868960 48178512 15400544
20:44:50 6754 8192000000 10960115088 11394105344 1971864368 19.400 99 55 111 1 2036089776 46104656 18120752
20:45:05 2589 8192000000 10974903760 11410231296 1990596288 19.549 100 48 96 1 2055005152 48791056 15617808
20:45:18 1884 8192000000 10983126672 11401895936 1985848288 19.511 100 77 151 5 2060097616 50879632 23369696
20:45:26 5785 8192000000 11000583488 11424022528 2003715200 19.652 100 77 154 0 2083494528 55707984 24071344
20:45:40 2121 8192000000 10985847376 11404718080 1981966384 19.480 99 74 149 3 2062949472 57306736 23676352
20:45:49 5604 8192000000 10985344960 11408744448 1962611216 19.327 98 68 136 0 2045092160 60213824 22267120
20:46:03 7959 8192000000 10994685168 11423514624 1995451616 19.587 100 65 129 0 2078199744 61321152 21426976
20:46:18 1380 8192000000 11008294752 11424034816 1997560240 19.603 100 84 168 1 2087953024 63310048 27082736
20:46:26 4202 8192000000 11007205648 11432243200 1999448320 19.618 100 70 140 3 2087856992 65135536 23273136
20:46:39 8096 8192000000 10999499200 11427512320 1992695632 19.565 100 67 132 2 2080676576 65643280 22337664
20:46:55 5674 8192000000 11013369328 11431092224 2005137184 19.663 100 83 164 0 2100359664 68432320 26790160
20:47:10 7668 8192000000 11016583744 11449905152 2007941104 19.685 100 64 128 0 2101586800 71425344 22220352
20:47:30 9720 8192000000 11001554352 11446910976 1988077328 19.529 99 47 94 1 2074262400 69104272 17080800
20:47:51 6951 8192000000 11025243440 11464220672 2017065680 19.757 100 55 108 3 2109842768 74159456 18617632
20:48:13 8290 8192000000 11005674592 11448426496 1974737632 19.423 98 50 99 0 2071760976 79694000 17329344
20:48:31 7899 8192000000 10997024624 11433607168 1989268000 19.538 99 54 108 0 2074731136 66928592 18534544
20:48:45 7954 8192000000 10987410256 11426246656 1960627232 19.311 98 51 102 0 2046559680 68534576 17397872
20:49:00 12025 8192000000 10959939120 11401879552 1957708480 19.288 99 44 88 0 2035591088 62532944 15349664
20:49:21 12514 8192000000 10946174240 11390734336 1946592256 19.199 99 39 78 0 2022840096 62206400 14041440
20:49:40 14724 8192000000 10964356864 11404636160 1965390992 19.349 100 38 74 0 2044439952 65813696 13235264
20:50:04 14399 8192000000 10953767392 11401691136 1954221296 19.260 100 34 68 1 2036134352 69379152 12533904
20:50:30 11450 8192000000 10949564064 11400609792 1957278832 19.284 100 34 67 1 2035015536 66204912 11531792
20:51:04 22643 8192000000 10955849024 11400486912 1965108256 19.347 100 28 56 3 2031344704 56379856 9856592
20:51:33 13853 8192000000 10955100464 11408277504 1969716016 19.383 100 29 58 1 2036863248 57190720 9956512
20:51:55 19855 8192000000 10949888448 11410317312 1951298640 19.237 99 35 70 0 2024510192 61413968 11797584
20:52:22 12163 8192000000 10939655264 11399696384 1947775600 19.209 99 32 64 1 2010672944 51842784 11054560
20:52:43 15734 8192000000 10929299376 11390222336 1943348416 19.173 99 26 52 1 2004031936 51995856 8687664
20:53:12 22521 8192000000 10929270880 11384930304 1920410352 18.990 99 20 40 1 1990341360 62656864 7274144
20:53:44 20703 8192000000 10927557264 11393683456 1930729664 19.073 100 19 38 0 2009641264 71445648 7465952
20:54:26 6469 8192000000 10924676336 11397611520 1930263120 19.069 100 12 24 2 2008973024 73541312 5168592
20:54:42 12784 8192000000 10942467056 11394146304 1934455792 19.102 100 26 52 4 2022769440 79029584 9284064
20:55:46 42045 8192000000 10829986656 11284197376 1855441696 18.466 97 8 16 1 1867426688 9522400 2462592
20:56:35 50951 8192000000 10861732960 11326259200 1920407520 18.990 100 13 26 0 1941613040 18077552 3127968
20:57:33 64525 8192000000 10878668176 11335077888 1920391184 18.990 99 25 49 0 1939487776 12753152 6343440
20:58:49 98886 8192000000 10850922640 11301629952 1829599104 18.256 94 17 34 1 1843819328 10107664 4112560
21:01:18 118996 8192000000 10859249136 11316002816 1800789904 18.020 93 15 30 2 1817932784 13117056 4025824
21:03:24 136953 8192000000 10883437504 11336462336 1902823168 18.849 98 20 40 0 1918954016 10400256 5730592
21:05:47 33820 8192000000 10880472208 11344715776 1953961904 19.258 100 26 50 3 1970538624 9166912 7409808
21:06:34 56280 8192000000 10901166112 11357589504 1941261168 19.157 99 28 54 1 1960291040 10768608 8261264
21:07:40 71094 8192000000 10905371008 11366592512 1969677216 19.383 100 37 74 1 1993202240 12850336 10674688
21:08:58 20549 8192000000 10913173392 11374120960 1974038128 19.417 100 18 36 1 1990149952 11053600 5058224
21:09:35 55655 8192000000 10921003712 11385290752 1990112848 19.545 100 32 63 4 2012023504 11527952 10382704
21:10:45 54208 8192000000 10911987520 11396390912 1992099200 19.560 100 26 51 1 2013867952 13828640 7940112
21:12:01 43424 8192000000 10918242400 11384586240 1966592208 19.358 99 14 28 1 1987185696 16416736 4176752
21:12:52 74493 8192000000 10919431120 11388895232 1966378336 19.357 99 11 22 2 1979289680 10170240 2741104
21:14:13 53078 8192000000 10923221216 11397406720 1998905104 19.614 100 15 30 2 2013971056 10134448 4931504
21:16:11 75372 8192000000 10912266112 11389763584 1957422048 19.286 98 17 33 1 1975060896 12983168 4655680
21:17:51 43236 8192000000 10885924080 11355275264 1926700624 19.040 97 15 30 3 1945338272 14000384 4637264
21:18:40 69499 8192000000 10917629408 11395911680 1981546192 19.477 100 23 46 0 2006939184 18510480 6882512
21:20:03 94918 8192000000 10903118096 11381821440 1979214736 19.458 100 8 16 0 1996151248 14831856 2104656
21:21:46 34494 8192000000 10915159456 11398914048 1994229648 19.577 100 15 29 1 2008099680 9951488 3918544
21:22:27 40374 8192000000 10907981728 11385987072 1990859584 19.551 100 19 38 0 2010365264 14145424 5360256
21:23:14 48734 8192000000 10919589056 11394928640 1971840160 19.400 99 21 42 1 1996152768 18073056 6239552
21:24:48 58923 8192000000 10919123504 11420250112 1995790672 19.590 100 6 12 0 2015449488 17817744 1841072
21:25:53 43096 8192000000 10902072704 11398705152 1951680368 19.240 98 6 12 1 1969826480 16576064 1570048
21:26:43 38528 8192000000 10870262096 11352506368 1897961728 18.810 96 12 24 0 1912746896 11435888 3349280
21:27:27 47946 8192000000 10894517952 11373195264 1969177712 19.379 100 14 28 0 1981265904 8491728 3596464
21:28:37 98444 8192000000 10903325232 11375415296 1927370608 19.046 97 19 38 2 1943551552 11347424 4833520
21:30:24 73033 8192000000 10875500608 11344986112 1859935216 18.503 94 9 18 1 1872994560 10813344 2246000
21:32:44 37039 8192000000 10884188240 11359047680 1884050944 18.698 96 32 62 2 1906290656 13301936 8937776
21:33:28 68506 8192000000 10890378944 11342700544 1919181616 18.980 98 15 30 2 1934234928 10528768 4524544
21:34:43 26779 8192000000 10919227984 11370831872 1964091424 19.339 100 55 110 1 1989817136 10556832 15168880
21:35:16 63726 8192000000 10881030944 11357290496 1874718624 18.622 95 28 56 2 1897437744 15043488 7675632
21:36:53 36351 8192000000 10891102272 11349225472 1890802496 18.752 97 34 68 4 1913424640 13234912 9387232
21:37:42 35351 8192000000 10892203696 11355873280 1907515888 18.887 98 33 66 1 1938030384 21107680 9406816
21:38:23 66752 8192000000 10887068656 11358830592 1922743184 19.009 99 12 24 0 1942725456 16926576 3055696
21:39:36 44989 8192000000 10883819472 11339423744 1905377936 18.870 98 19 38 3 1926901312 16350048 5173328
21:40:32 122526 8192000000 10867051072 11335098368 1909397472 18.902 98 41 82 2 1933888704 12987968 11503264
21:42:51 83277 8192000000 10847082144 11300454400 1849157600 18.415 95 18 36 1 1863590672 9227296 5205776
21:44:21 28001 8192000000 10880187344 11328274432 1924984144 19.027 99 34 68 4 1942984560 8169232 9831184
21:44:57 43552 8192000000 10831420384 11300421632 1856463856 18.475 96 21 42 2 1868796864 6548768 5784240
21:45:57 76452 8192000000 10853842960 11323621376 1896389040 18.797 98 13 25 0 1908264928 8431808 3444080
21:47:20 62913 8192000000 10860323024 11336318976 1921381104 18.998 99 9 18 0 1937328160 13647664 2299392
21:49:26 53945 8192000000 10854272272 11330359296 1909085728 18.899 98 18 36 0 1925942752 11319184 5537840
21:50:28 53249 8192000000 10849190096 11336593408 1917594864 18.968 99 16 32 1 1936274608 13879952 4799792
21:51:44 82902 8192000000 10871639504 11345461248 1897448688 18.806 98 8 16 0 1910135984 10757296 1930000
21:53:13 73596 8192000000 10861420112 11357057024 1907368240 18.886 98 14 28 0 1934747232 22396096 4982896
21:54:37 60426 8192000000 10866939376 11340607488 1896898608 18.801 98 21 42 0 1917635664 14478448 6258608
21:55:44 50728 8192000000 10861950064 11325014016 1882004144 18.681 97 36 71 3 1900812096 8893968 9913984
21:56:50 43730 8192000000 10882173680 11347628032 1911178160 18.916 98 31 62 0 1932217168 12197792 8841216
21:57:41 74712 8192000000 10884450816 11361370112 1958132800 19.291 100 15 30 0 1976279424 14192800 3953824
21:59:17 78768 8192000000 10903636640 11365978112 1947704112 19.208 99 14 27 0 1958154992 7324544 3126336
22:00:42 70078 8192000000 10906753392 11379154944 1933930864 19.098 98 19 38 2 1948056624 9335056 4790704
22:02:02 103257 8192000000 10929270336 11401318400 1965533424 19.350 99 12 24 0 1983670480 14538960 3598096
22:03:53 55856 8192000000 10927381760 11390758912 1962691328 19.327 98 37 73 2 1982808048 10306496 9810224
22:04:55 78168 8192000000 10921583440 11392921600 1933430496 19.094 97 16 32 0 1947836160 9841520 4564144
22:06:32 69117 8192000000 10934321056 11391746048 1954381120 19.261 98 28 56 1 1976383968 14340608 7662240
22:07:50 73101 8192000000 10914289088 11383816192 1986440560 19.516 100 23 45 1 2003263680 10868720 5954400
22:09:24 98476 8192000000 10893559648 11365621760 1906182992 18.876 96 14 28 0 1920040080 10375952 3481136
22:12:06 79131 8192000000 10906836544 11399823360 1959228560 19.300 99 13 26 0 1978635456 15791584 3615312
22:13:34 57570 8192000000 10918905536 11383816192 1947310480 19.205 98 19 38 1 1969603952 16458672 5834800
22:14:37 52219 8192000000 10917211376 11389394944 1969685600 19.383 99 24 48 1 1985879584 9375296 6818688
22:16:29 50649 8192000000 10884592720 11379097600 1957356624 19.285 99 6 12 0 1968853536 9630272 1866640
22:17:26 44363 8192000000 10874252864 11351150592 1898641424 18.815 96 20 41 1 1911161088 6760384 5759280
22:18:25 62892 8192000000 10895237120 11378032640 1954981360 19.266 99 21 42 1 1971056816 9307680 6767776
22:19:34 71455 8192000000 10903725568 11399409664 1984692112 19.502 100 13 26 1 2001772016 12967056 4112848
22:20:54 83206 8192000000 10926283872 11389812736 1917140544 18.964 96 13 26 0 1930660928 10052128 3468256
22:22:23 41749 8192000000 10941570736 11397107712 1988563520 19.532 100 24 47 0 2007899824 13020336 6315968
22:23:11 55001 8192000000 10882963808 11354714112 1895103552 18.787 95 40 80 2 1922848304 15808432 11936320
22:24:21 49951 8192000000 10897803728 11378040832 1924331200 19.022 98 12 24 0 1941181504 13323456 3526848
22:25:25 73209 8192000000 10866191984 11338174464 1866147344 18.553 95 9 18 0 1878090960 9738160 2205456
22:26:45 22839 8192000000 10659187104 11094917120 1693847568 17.134 87 20 40 0 1707140256 7680656 5612032

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 23-11-2020 22:28:15 to 23-11-2020 22:28:46.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 165 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-11-2020 22:28:47 to 23-11-2020 22:28:49.

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          237550
MON$OLDEST_ACTIVE               238563
MON$OLDEST_SNAPSHOT             238563
MON$NEXT_TRANSACTION            238563
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                       2049248
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
:160: 
:161: mscs-test-161.budzdorov.ru    Mon Nov 23 22:27:12 2020
:162:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:163: 
:164: 
:165: mscs-test-161.budzdorov.ru    Mon Nov 23 22:27:20 2020
:166:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:167: 
--- end of diff output ---

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

23.11.20 22:28:50. 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-11-23 22:28:52 No severe PSQL-related problems occured
23.11.20 22:28:54. End of report.