Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.06.2021 22:30
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 58e1ddde69c44dad93d327777e5becec
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 2021-05-09 08:45
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 4793.92
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 17162900 kB
MemAvailable 31414076 kB
Buffers 0 kB
Cached 14540676 kB
SwapCached 2432 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-06-20 22:27:38
DTS_END                         2021-06-20 22:27:38.1010
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_CLIENT_ORDER(32:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57796
TRN_ID                          247060
ATT_ID                          663
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: 9533.82 16820 1144058
customer order: creation 182.40 343 21888
customer order: refuse 15.42 343 1850
order to supplier: creation 47.30 1257 5676
order to supplier: removal 3.40 112664 408
invoice (draft): creation 47.43 3266 5692
invoice (draft): removal 51.98 949 6237
invoice accept: apply 43.62 20543 5234
invoice accept: cancel 47.27 916 5672
customer reserve: creation 4105.68 201 492682
customer reserve: removal 4686.86 63 562423
realization accept: apply 86.86 178 10423
realization accept: cancel 80.81 116 9697
payment from customer: creation 62.87 123 7544
payment from customer: removal 5.61 119 673
payment to supplier: creation 50.06 125 6007
payment to supplier: removal 3.32 82 398
service: total inventory turnovers 4.77 1145 572
service: total monetary turnovers 7.30 46 876
service: aggregate perf. data 0.85 21601 102
service: refresh index statistics 0.03 172318 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-06-2021 22:30:27 to 20-06-2021 22:30:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1805
TEST_TIME 2 1102
TEST_TIME 3 4700
TEST_TIME 4 5615
TEST_TIME 5 5467
TEST_TIME 6 5262
TEST_TIME 7 5116
TEST_TIME 8 5387
TEST_TIME 9 5412
TEST_TIME 10 5576
TEST_TIME 11 5381
TEST_TIME 12 5466
TEST_TIME 13 5517
TEST_TIME 14 5728
TEST_TIME 15 5684
TEST_TIME 16 6136
TEST_TIME 17 6672
TEST_TIME 18 6875
TEST_TIME 19 6810
TEST_TIME 20 7060
TEST_TIME 21 7284
TEST_TIME 22 7677
TEST_TIME 23 7820
TEST_TIME 24 7851
TEST_TIME 25 7917
TEST_TIME 26 7858
TEST_TIME 27 8150
TEST_TIME 28 8989
TEST_TIME 29 9182
TEST_TIME 30 9625
TEST_TIME 31 10789
TEST_TIME 32 10680
TEST_TIME 33 10577
TEST_TIME 34 10443
TEST_TIME 35 10274
TEST_TIME 36 10234
TEST_TIME 37 10191
TEST_TIME 38 10141
TEST_TIME 39 10319
TEST_TIME 40 10183
TEST_TIME 41 10179
TEST_TIME 42 10002
TEST_TIME 43 9968
TEST_TIME 44 9939
TEST_TIME 45 9983
TEST_TIME 46 10169
TEST_TIME 47 10058
TEST_TIME 48 10009
TEST_TIME 49 9912
TEST_TIME 50 9841
TEST_TIME 51 9783
TEST_TIME 52 9737
TEST_TIME 53 9644
TEST_TIME 54 9666
TEST_TIME 55 9573
TEST_TIME 56 9518
TEST_TIME 57 9536
TEST_TIME 58 9564
TEST_TIME 59 9521
TEST_TIME 60 9494
TEST_TIME 61 9509
TEST_TIME 62 9616
TEST_TIME 63 9576
TEST_TIME 64 9587
TEST_TIME 65 9676
TEST_TIME 66 9829
TEST_TIME 67 9826
TEST_TIME 68 9838
TEST_TIME 69 9864
TEST_TIME 70 9794
TEST_TIME 71 9750
TEST_TIME 72 9975
TEST_TIME 73 9877
TEST_TIME 74 9838
TEST_TIME 75 9775
TEST_TIME 76 9703
TEST_TIME 77 9665
TEST_TIME 78 9687
TEST_TIME 79 9618
TEST_TIME 80 9630
TEST_TIME 81 9649
TEST_TIME 82 9588
TEST_TIME 83 9612
TEST_TIME 84 9601
TEST_TIME 85 9649
TEST_TIME 86 9638
TEST_TIME 87 9616
TEST_TIME 88 9642
TEST_TIME 89 9684
TEST_TIME 90 9653
TEST_TIME 91 9648
TEST_TIME 92 9655
TEST_TIME 93 9650
TEST_TIME 94 9712
TEST_TIME 95 9730
TEST_TIME 96 9719
TEST_TIME 97 9685
TEST_TIME 98 9599
TEST_TIME 99 9655
TEST_TIME 100 9621
TEST_TIME 101 9596
TEST_TIME 102 9580
TEST_TIME 103 9552
TEST_TIME 104 9497
TEST_TIME 105 9479
TEST_TIME 106 9423
TEST_TIME 107 9414
TEST_TIME 108 9467
TEST_TIME 109 9499
TEST_TIME 110 9490
TEST_TIME 111 9502
TEST_TIME 112 9499
TEST_TIME 113 9504
TEST_TIME 114 9544
TEST_TIME 115 9529
TEST_TIME 116 9533
TEST_TIME 117 9508
TEST_TIME 118 9529
TEST_TIME 119 9574
TEST_TIME 120 9536

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 20-06-2021 22:30:30 to 20-06-2021 22:30:34.

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 1599602 1599602 0 0.00 0 28144 7 0 0
doc_list_biud 1599599 1599599 0 0.00 0 41360 29 0 0
sp_add_invoice_to_stock 5364 5234 130 2.42 19 208883 20544 0 130
sp_cancel_adding_invoice 5672 5672 0 0.00 5 76271 917 0 0
sp_cancel_client_order 1850 1850 0 0.00 4 11864 344 0 0
sp_cancel_customer_reserve 562423 562423 0 0.00 1 39897 64 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 3 16153 119 0 0
sp_cancel_pay_to_supplier 398 398 0 0.00 3 3442 83 0 0
sp_cancel_supplier_invoice 6243 6237 6 0.09 1 41381 949 0 6
sp_cancel_supplier_order 408 408 0 0.00 6 1222206 112664 0 0
sp_cancel_write_off 9697 9697 0 0.00 1 18445 116 0 0
sp_client_order 21888 21888 0 0.00 4 61867 343 0 0
sp_customer_reserve 492682 492682 0 0.00 0 57099 202 0 0
sp_fill_shopping_cart 33248 33248 0 0.00 1 27499 38 0 0
sp_fill_shopping_cart_clo_res 492681 492681 0 0.00 0 29348 15 0 0
sp_get_clo_for_invoice 5231 5231 0 0.00 0 31632 274 0 0
sp_kill_cost_storno 16440 16440 0 0.00 0 16142 65 0 0
sp_kill_qstorno_ret_qs2qd 1141188 1141188 0 0.00 0 41347 35 0 0
sp_kill_qty_storno 601941 601941 0 0.00 0 41356 75 0 0
sp_lock_selected_doc 21641 21641 0 0.00 0 8845 6 0 0
sp_make_cost_storno 29205 29205 0 0.00 0 20948 57 0 0
sp_multiply_rows_for_pdistr 29205 29205 0 0.00 0 20346 32 0 0
sp_multiply_rows_for_qdistr 21888 21888 0 0.00 0 27676 155 0 0
sp_pay_from_customer 7544 7544 0 0.00 4 26448 124 0 0
sp_pay_to_supplier 6007 6007 0 0.00 4 20462 125 0 0
sp_payment_common 13549 13549 0 0.00 1 26443 42 0 0
sp_qd_handle_on_cancel_clo 1850 1850 0 0.00 0 11824 320 0 0
sp_qd_handle_on_invoice_upd_sts 10903 10903 0 0.00 0 19781 350 0 0
sp_qd_handle_on_reserve_upd_sts 10423 10423 0 0.00 0 15644 51 0 0
sp_reserve_write_off 10423 10423 0 0.00 6 21070 179 0 0
sp_supplier_invoice 5692 5692 0 0.00 7 86921 3266 0 0
sp_supplier_order 5676 5676 0 0.00 5 33303 1257 0 0
srv_aggregate_perf_data 102 102 0 0.00 3047 210589 21601 0 0
srv_fill_mon_cache_memory 187 187 0 0.00 1329 138286 27482 0 0
srv_find_qd_qs_mism 1093464 1093464 0 0.00 0 28142 7 0 0
srv_make_invnt_saldo 572 572 0 0.00 25 115759 1146 0 0
srv_make_money_saldo 876 876 0 0.00 0 22107 47 0 0
srv_recalc_idx_stat 4 4 0 0.00 95058 217356 172319 0 0
t$perf-abend:sp_add_invoice_to_stock 130 130 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5234 5234 0 0.00 0 25079 191 0 0
t$perf-norm:sp_cancel_adding_invoice 443 443 0 0.00 0 2780 85 0 0
t$perf-norm:sp_cancel_client_order 1850 1850 0 0.00 0 11757 25 0 0
t$perf-norm:sp_cancel_customer_reserve 765 765 0 0.00 0 10287 26 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 425 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 398 398 0 0.00 0 6432 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 1805 20 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 38404 1713 0 0
t$perf-norm:sp_cancel_write_off 1037 1037 0 0.00 0 971 5 0 0
t$perf-norm:sp_client_order 21888 21888 0 0.00 0 16391 17 0 0
t$perf-norm:sp_customer_reserve 1019 1019 0 0.00 0 13898 35 0 0
t$perf-norm:sp_pay_from_customer 7544 7544 0 0.00 0 14572 15 0 0
t$perf-norm:sp_pay_to_supplier 6007 6007 0 0.00 0 4766 7 0 0
t$perf-norm:sp_reserve_write_off 10423 10423 0 0.00 0 6755 9 0 0
t$perf-norm:sp_supplier_invoice 5692 5692 0 0.00 0 6010 20 0 0
t$perf-norm:sp_supplier_order 5676 5676 0 0.00 0 17101 21 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 238 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 187 187 0 0.00 0 4924 28 0 0
t$perf-norm:srv_make_invnt_saldo 572 572 0 0.00 0 2565 28 0 0
t$perf-norm:srv_make_money_saldo 876 876 0 0.00 0 8102 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10722 10462 260 2.42 0 5082 18 0 260
v_all_customers 39984 39984 0 0.00 0 27 1 0 0
v_all_suppliers 31352 31352 0 0.00 0 24 1 0 0
v_all_wares 43776 43776 0 0.00 0 26 1 0 0
v_cancel_adding_invoice 886 886 0 0.00 0 193 5 0 0
v_cancel_client_order 3700 3700 0 0.00 0 2856 6 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 1954 6 0 0
v_cancel_customer_reserve 1530 1530 0 0.00 0 2847 9 0 0
v_cancel_payment_to_supplier 796 796 0 0.00 0 3163 14 0 0
v_cancel_supplier_invoice 838 826 12 1.43 0 5683 25 0 12
v_cancel_supplier_order 816 816 0 0.00 0 1088 6 0 0
v_cancel_write_off 2074 2074 0 0.00 0 2200 13 0 0
v_max_id_clo_ord 5673 5673 0 0.00 0 4143 3 0 0
v_max_id_clo_res 1019 1019 0 0.00 0 3413 11 0 0
v_max_id_ord_sup 5686 5686 0 0.00 0 5280 4 0 0
v_max_non_paid_invoice 1689 1689 0 0.00 0 5841 7 0 0
v_max_non_paid_realizn 3996 3996 0 0.00 0 8931 6 0 0
v_min_id_clo_ord 5673 5673 0 0.00 0 3121 8 0 0
v_min_id_clo_res 1019 1019 0 0.00 0 7653 14 0 0
v_min_id_ord_sup 5686 5686 0 0.00 0 4332 4 0 0
v_min_non_paid_invoice 6006 6006 0 0.00 0 18956 21 0 0
v_min_non_paid_realizn 7543 7543 0 0.00 0 20302 37 0 0
v_our_firm 10886 10886 0 0.00 0 42 1 0 0
v_reserve_write_off 20846 20846 0 0.00 0 3177 4 0 0
x_lock_depdocs_on_canc_invoice 11496 11496 0 0.00 0 17049 126 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 15857 427 0 0
x_make_qstorno_1000_1200 5676 5676 0 0.00 1 29976 1171 0 0
x_make_qstorno_1200_2000 5692 5692 0 0.00 3 86908 3134 0 0
x_make_qstorno_2100_3300 492682 492682 0 0.00 0 57097 184 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-06-2021 22:30:35 to 20-06-2021 22:30:39.

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:41 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
19:57:47 16558 8192000000 10228794496 10527469568 812645824 9.024 63 54 110 0 833066080 2310624 18109632
19:58:15 29590 8192000000 10320829632 10632740864 1365853328 14.290 100 87 174 0 1399661408 4733872 29074208
19:58:59 19366 8192000000 10364543584 10684309504 1408660672 14.672 100 87 174 0 1443414512 6032128 28721712
19:59:31 21217 8192000000 10386898480 10710777856 1434765024 14.903 100 84 168 0 1469654272 6696352 28192896
20:00:12 23682 8192000000 10423959648 10754146304 1482183488 15.321 100 87 174 1 1518214112 7821584 28209040
20:00:45 13717 8192000000 10442975488 10773901312 1497093728 15.451 100 89 178 0 1534315280 8558160 28663392
20:01:14 20826 8192000000 10447185536 10786570240 1513143168 15.591 100 83 166 1 1548349904 9046832 26159904
20:01:45 9402 8192000000 10471870672 10813906944 1529856688 15.736 100 85 170 0 1565884608 9488256 26539664
20:02:07 23651 8192000000 10523969808 10872745984 1570611808 16.088 100 84 168 0 1607487568 10601968 26273792
20:02:39 11620 8192000000 10555810288 10907660288 1612528912 16.446 100 86 172 0 1649383072 10685456 26168704
20:03:03 14696 8192000000 10562943120 10921254912 1623968688 16.544 100 81 161 3 1664182528 15622112 24591728
20:03:27 11804 8192000000 10592938448 10952871936 1643640192 16.711 100 81 162 1 1679654304 11602240 24411872
20:03:47 10474 8192000000 10598198080 10960912384 1654846384 16.805 100 74 148 1 1689189280 12216480 22126416
20:04:05 9977 8192000000 10625893760 10988769280 1679109104 17.010 100 83 166 0 1716825904 12649280 25067520
20:04:23 6176 8192000000 10624288688 10997342208 1690246960 17.103 100 75 150 1 1725681776 12923120 22511696
20:04:37 7080 8192000000 10642470640 11016540160 1705115728 17.228 100 78 153 2 1739101920 11866912 22119280
20:04:52 5205 8192000000 10654482848 11034128384 1719096944 17.345 100 71 142 0 1751622320 11759008 20766368
20:05:05 7883 8192000000 10673900800 11046932480 1735608528 17.482 100 82 163 0 1770890336 12091936 23189872
20:05:20 5967 8192000000 10691093776 11068162048 1749944336 17.601 100 78 157 1 1784425760 12340128 22141296
20:05:34 5290 8192000000 10698363168 11079643136 1762865648 17.708 100 82 163 1 1799013328 12500352 23647328
20:05:47 5321 8192000000 10718976736 11096387584 1776050640 17.817 100 81 162 0 1811029568 12258272 22720656
20:05:59 5397 8192000000 10726337648 11104026624 1788507536 17.920 100 82 163 1 1823316592 12612176 22196880
20:06:12 4092 8192000000 10736298048 11116883968 1797559680 17.994 100 87 174 0 1834789376 12724432 24505264
20:06:23 4193 8192000000 10746128656 11127562240 1809801648 18.094 100 86 170 0 1845866400 12760272 23304480
20:06:34 2229 8192000000 10747038656 11129102336 1806988240 18.071 100 92 185 1 1846792288 14483872 25320176
20:06:43 3565 8192000000 10759680432 11139985408 1810197152 18.097 100 86 172 0 1848502672 14854592 23450928
20:06:53 3738 8192000000 10754920592 11138248704 1815972736 18.145 100 89 178 1 1855533360 15071568 24489056
20:07:03 7676 8192000000 10760082448 11140960256 1818412048 18.165 100 87 172 4 1857434272 15503968 23518256
20:07:19 4313 8192000000 10765574512 11151310848 1819951168 18.177 100 79 158 1 1855709632 13749056 22009408
20:07:30 2938 8192000000 10780466960 11165569024 1839230736 18.335 100 87 174 1 1878048144 14427168 24390240
20:07:39 2697 8192000000 10795123440 11179470848 1851039792 18.431 100 89 178 0 1890380624 14746368 24594464
20:07:48 3805 8192000000 10789281824 11178131456 1856260672 18.473 100 89 176 3 1893381728 13045264 24075792
20:07:59 2223 8192000000 10795493504 11184775168 1855300096 18.465 100 91 181 1 1895957936 14336512 26321328
20:08:07 2214 8192000000 10803818240 11191730176 1861188672 18.513 100 89 179 2 1900159312 13494208 25476432
20:08:16 1967 8192000000 10808546368 11196706816 1863206144 18.529 100 91 180 1 1903335088 13935312 26193632
20:08:25 1621 8192000000 10806346496 11195301888 1865107328 18.545 100 84 168 3 1901374000 13070016 23196656
20:08:33 2922 8192000000 10817381584 11203223552 1870802496 18.591 100 88 177 0 1907903040 12368592 24731952
20:08:42 1788 8192000000 10811796272 11199664128 1873513216 18.613 100 88 174 2 1911479344 12390640 25575488
20:08:51 1617 8192000000 10807938448 11201507328 1873917952 18.616 100 87 175 0 1911127216 13179616 24029648
20:08:59 1262 8192000000 10829006640 11218169856 1879693920 18.663 100 96 192 0 1920028560 13136912 27197728
20:09:07 39084 8192000000 10788018096 11205226496 1877593232 18.646 100 60 118 1 1904709328 10220240 16895856
20:09:52 1843 8192000000 10828710656 11222335488 1884014048 18.698 100 81 158 0 1916795200 10083568 22697584
20:10:01 13276 8192000000 10794220752 11212406784 1877533552 18.645 100 45 90 1 1900373424 9783280 13056592
20:10:25 6193 8192000000 10791713968 11211456512 1879015232 18.657 100 40 82 3 1898096832 7836736 11244864
20:10:38 4917 8192000000 10792932144 11213787136 1881669024 18.679 100 34 67 1 1898556336 7284608 9602704
20:10:50 3769 8192000000 10806633312 11224604672 1883240176 18.691 100 39 78 1 1906011216 12211344 10559696
20:11:00 6185 8192000000 10797519456 11211882496 1880821248 18.672 100 26 52 0 1895352160 6810080 7720832
20:11:13 3939 8192000000 10795966064 11218153472 1884848240 18.704 100 37 74 0 1903396992 7971280 10577472
20:11:23 7868 8192000000 10791338720 11221000192 1885318816 18.708 100 27 54 0 1899910608 6628560 7963232
20:11:39 11243 8192000000 10800222656 11226656768 1888720704 18.735 100 26 53 0 1901987520 5238064 8028752
20:11:56 10752 8192000000 10809694400 11235962880 1890289296 18.748 100 20 40 0 1902431888 6967952 5174640
20:12:13 8431 8192000000 10805190304 11231117312 1893528480 18.774 100 22 44 1 1905331264 5554288 6248496
20:12:31 6473 8192000000 10799616240 11234512896 1896640896 18.799 100 16 32 1 1907706400 6457472 4608032
20:12:44 9356 8192000000 10808044608 11239038976 1899511248 18.822 100 15 30 0 1909512176 5050016 4950912
20:13:02 9894 8192000000 10803456176 11237781504 1901253824 18.836 100 19 38 2 1912650448 6212080 5184544
20:13:22 5536 8192000000 10810061808 11244187648 1902175712 18.844 100 17 33 3 1916878496 10171392 4531392
20:13:34 18081 8192000000 10806343712 11244728320 1906713632 18.880 100 23 44 4 1917796784 5511088 5572064
20:13:58 61909 8192000000 10859335504 11265433600 1913618592 18.936 100 43 87 3 1931643760 4938784 13086384
20:15:07 6538 8192000000 10826667488 11266330624 1918367632 18.974 100 30 60 0 1933930064 7376448 8185984
20:15:20 3690 8192000000 10837139200 11268567040 1919049616 18.979 100 24 48 0 1931084000 5186016 6848368
20:15:30 5137 8192000000 10840001168 11270746112 1920762896 18.993 100 28 56 0 1935026928 6204384 8059648
20:15:44 5673 8192000000 10851010000 11273494528 1920277600 18.989 100 38 76 1 1940576336 10428944 9869792
20:15:56 7152 8192000000 10826214768 11260477440 1901292064 18.837 99 31 62 1 1916849984 6135168 9422752
20:16:11 6338 8192000000 10836934144 11260801024 1911816384 18.921 100 26 51 1 1925176768 5317648 8042736
20:16:24 8327 8192000000 10831733232 11267018752 1920005936 18.987 100 28 57 0 1934940064 6479024 8455104
20:16:39 8311 8192000000 10836406112 11266830336 1902851952 18.849 99 37 74 1 1920820912 7537440 10431520
20:16:53 6323 8192000000 10829201392 11264819200 1917347824 18.966 100 31 62 1 1933081216 6714880 9018512
20:17:08 8214 8192000000 10814620560 11244584960 1887638336 18.727 99 27 55 0 1901395536 4593792 9163408
20:17:22 6619 8192000000 10803377856 11237793792 1860345808 18.506 98 27 54 2 1873394080 5044304 8003968
20:17:37 4730 8192000000 10792991168 11215323136 1827445392 18.238 97 34 68 0 1849217568 12069360 9702816
20:17:48 6511 8192000000 10783890640 11202883584 1839048016 18.333 98 35 69 2 1856546128 7576912 9921200
20:18:02 4234 8192000000 10772424544 11198984192 1827948176 18.243 98 29 58 1 1846025760 9346256 8731328
20:18:12 6880 8192000000 10771549328 11195457536 1826838208 18.234 98 20 40 2 1838061040 5517856 5704976
20:18:29 62343 8192000000 10741874976 11155169280 1698563120 17.173 91 35 71 5 1713259712 5321872 9374720
20:19:40 12648 8192000000 10732008528 11151097856 1714682752 17.308 93 19 38 1 1725528848 5637552 5208544
20:19:59 4542 8192000000 10739528384 11153293312 1786820016 17.906 98 37 74 0 1804833312 7600752 10412544
20:20:14 7339 8192000000 10726038688 11142230016 1769258784 17.761 97 37 75 2 1785518992 5674528 10585680
20:20:28 3973 8192000000 10747413968 11162718208 1810030880 18.096 99 28 56 3 1824777376 6486960 8259536
20:20:38 7762 8192000000 10755251024 11178536960 1835202384 18.302 100 28 55 2 1848702432 5732176 7767872
20:20:55 6775 8192000000 10726531072 11143716864 1770345152 17.770 97 29 58 0 1784662672 5935648 8381872
20:21:08 9527 8192000000 10669213008 11079802880 1653633232 16.795 91 22 44 0 1665065280 4962288 6469760
20:21:29 7393 8192000000 10703509104 11108212736 1750085312 17.602 98 24 48 1 1762845904 5947344 6813248
20:21:45 6356 8192000000 10705847712 11124367360 1792600624 17.953 100 25 50 0 1806349136 5825104 7923408
20:21:59 7968 8192000000 10699708768 11108986880 1735372592 17.480 96 20 40 1 1746702048 4897472 6431984
20:22:14 4824 8192000000 10703897680 11109728256 1760094880 17.685 98 38 74 2 1776880336 5522064 11263392
20:22:28 9019 8192000000 10720576928 11135795200 1802092944 18.031 100 30 60 1 1816307968 5131856 9083168
20:22:44 8771 8192000000 10732052464 11153506304 1799489488 18.010 99 25 50 3 1812788864 5475744 7823632
20:22:59 20260 8192000000 10751387184 11168587776 1810410800 18.099 99 24 47 1 1823524448 6619888 6493760
20:23:58 33303 8192000000 10752346096 11180118016 1823591808 18.207 99 25 49 1 1836079776 5320800 7167168
20:24:38 7139 8192000000 10767825552 11187548160 1843312864 18.368 100 14 28 2 1852133792 5021488 3799440
20:24:51 7790 8192000000 10758163232 11190550528 1850578160 18.427 100 30 60 2 1865823824 6901824 8343840
20:25:05 6537 8192000000 10773486144 11199430656 1857207568 18.481 100 33 66 2 1873640640 6111312 10321760
20:25:24 11068 8192000000 10768504752 11198160896 1855680992 18.468 100 20 40 3 1867310672 5715872 5913808
20:25:43 9821 8192000000 10769990800 11204022272 1862397152 18.523 100 27 54 1 1875909184 5623680 7888352
20:26:01 5677 8192000000 10775199920 11207467008 1865989728 18.552 100 29 57 1 1879929184 5640416 8299040
20:26:16 7144 8192000000 10787270352 11215732736 1865285584 18.546 100 14 29 1 1874448528 4897744 4265200
20:26:29 8332 8192000000 10786667776 11216031744 1873125968 18.610 100 21 43 0 1884732720 5467296 6139456
20:26:50 10033 8192000000 10795069088 11226562560 1874378560 18.620 100 17 34 1 1888600592 9769104 4452928
20:27:07 19346 8192000000 10805666304 11236872192 1890821536 18.752 100 17 34 4 1900417632 5204736 4391360
20:27:34 9666 8192000000 10827109760 11249180672 1899667760 18.824 100 28 56 1 1913301440 4474624 9159056
20:27:51 30857 8192000000 10848576224 11264929792 1914101104 18.940 100 49 96 0 1934517328 6951248 13464976
20:28:50 95320 8192000000 10856967792 11277881344 1919369760 18.982 100 36 71 2 1939101904 9876592 9855552
20:30:33 7500 8192000000 10851422160 11284131840 1930405344 19.070 100 50 99 0 1952287200 7531920 14349936
20:30:54 8380 8192000000 10882441840 11297611776 1935588400 19.112 100 63 128 3 1961864288 8605136 17670752
20:31:13 13750 8192000000 10864034272 11293949952 1916885936 18.962 99 44 88 0 1940271296 10505600 12879760
20:31:39 16583 8192000000 10882637888 11300700160 1938958784 19.138 100 61 122 1 1965890768 9112224 17819760
20:32:04 16533 8192000000 10882150160 11309277184 1945813536 19.193 100 51 99 0 1967875344 8728256 13333552
20:32:36 15512 8192000000 10878667968 11320713216 1952309152 19.245 100 38 76 4 1974930432 11681440 10939840
20:33:04 34840 8192000000 10892719776 11331231744 1961081952 19.315 100 49 98 1 1989330880 13809152 14439776
20:34:00 2108 8192000000 10892617120 11317014528 1947346656 19.205 99 51 103 2 1976583168 14526320 14710192
20:34:12 8207 8192000000 10903343280 11336548352 1950612160 19.231 99 51 100 0 1980445872 14642672 15191040
20:34:28 5227 8192000000 10906619120 11335593984 1945936784 19.194 99 45 88 0 1975171904 16025904 13209216
20:34:41 25217 8192000000 10914227360 11349127168 1966116576 19.355 100 58 116 0 2001390672 17851776 17422320
20:35:16 11732 8192000000 10929002912 11359637504 1974418816 19.420 100 58 117 0 2012101184 20595952 17086416
20:35:37 7788 8192000000 10941990640 11365539840 1982944208 19.488 100 60 119 1 2019175984 19530976 16700800
20:35:55 9579 8192000000 10944002016 11366289408 1987713584 19.526 100 71 136 1 2027309504 19563728 20032192
20:36:13 4518 8192000000 10942466560 11370037248 1986267456 19.514 100 58 112 0 2022129376 19796688 16065232
20:36:25 5727 8192000000 10913292224 11338698752 1929707088 19.065 98 65 128 1 1969527040 20640736 19179216
20:36:37 1984 8192000000 10918919472 11342069760 1964921664 19.345 100 66 132 1 2006051360 21390976 19738720
20:36:49 2842 8192000000 10922963056 11344945152 1966684656 19.359 100 73 144 2 2011026784 22783136 21558992
20:36:58 30393 8192000000 10910629792 11350528000 1969568752 19.382 100 51 102 1 2007199728 22771248 14859728
20:37:47 9249 8192000000 10902714992 11344666624 1950083936 19.227 99 42 84 0 1983168432 20396480 12688016
20:38:10 18611 8192000000 10904608560 11339722752 1950502960 19.230 99 43 87 1 1982433456 18967776 12962720
20:38:39 11160 8192000000 10904206720 11338498048 1955047952 19.267 99 43 84 3 1986835520 19976176 11811392
20:39:01 8333 8192000000 10922057904 11356545024 1976075680 19.434 100 53 107 0 2013467840 21798464 15593696
20:39:18 12392 8192000000 10931791680 11363471360 1975641344 19.430 100 51 102 0 2015410336 25008576 14760416
20:39:43 2986 8192000000 10930694688 11370881024 1983690192 19.494 100 49 98 2 2026108352 27994320 14423840
20:39:59 5861 8192000000 10945532480 11378601984 1990190768 19.545 100 54 107 1 2031337520 25299968 15846784
20:40:13 3035 8192000000 10950674384 11381055488 1994819424 19.582 100 59 117 2 2037696544 26115888 16761232
20:40:26 3545 8192000000 10955756736 11370205184 1981677168 19.478 99 71 142 4 2031273536 27141424 22454944
20:40:37 2306 8192000000 10959598544 11382996992 2000071888 19.623 100 79 158 0 2051939984 28216192 23651904
20:40:50 3811 8192000000 10971755520 11396816896 2006934160 19.677 100 73 144 0 2058683152 29731200 22017792
20:41:01 2365 8192000000 10981900144 11398971392 2013619408 19.730 100 83 167 0 2066345792 29020560 23705824
20:41:13 4838 8192000000 10978237008 11407843328 2014946304 19.740 100 73 146 0 2067615136 31038736 21630096
20:41:27 4142 8192000000 10967876576 11402510336 2009500240 19.698 100 62 124 0 2058484240 30562016 18421984
20:41:38 2296 8192000000 10968833136 11399110656 2004441888 19.658 100 59 118 1 2054298448 31149184 18707376
20:41:48 3131 8192000000 10945588656 11375910912 1978878768 19.456 99 62 122 1 2029075808 30959744 19237296
20:42:00 6572 8192000000 10948710160 11382534144 1988061152 19.528 100 58 116 2 2036955808 30991200 17903456
20:42:13 3596 8192000000 10952767136 11381972992 1969817152 19.384 99 60 121 1 2021834864 33809280 18208432
20:42:26 7744 8192000000 10944856864 11376988160 1964521120 19.342 99 55 110 2 2017864368 36166768 17176480
20:42:46 11010 8192000000 10960212656 11391582208 1987634624 19.525 100 58 113 2 2045599296 40117232 17847440
20:43:05 1605 8192000000 10977592528 11398537216 1995300048 19.586 100 73 144 1 2056221056 39056400 21864608
20:43:14 2106 8192000000 10988821840 11409780736 2009380624 19.697 100 87 171 0 2074938400 39399136 26158640
20:43:24 5736 8192000000 10982503360 11411849216 2012294576 19.720 100 75 150 1 2075767920 40224400 23248944
20:43:41 1404 8192000000 10976464160 11398721536 1996119760 19.592 99 83 163 0 2061952224 40601792 25230672
20:43:50 3210 8192000000 10972608608 11391217664 1977341136 19.444 99 79 155 1 2042524896 40988448 24195312
20:44:06 2721 8192000000 10977840720 11394097152 1991823344 19.558 100 82 162 0 2059542832 42473808 25245680
20:44:21 2522 8192000000 10948151152 11368075264 1961927808 19.321 99 71 140 1 2023124352 40199712 20996832
20:44:30 3273 8192000000 10950583536 11368374272 1975019744 19.425 100 68 136 3 2028634848 32873632 20741472
20:44:41 4412 8192000000 10948302208 11372240896 1975570160 19.430 100 60 119 0 2026476848 32824064 18082624
20:44:52 2151 8192000000 10954118144 11375394816 1979490432 19.461 100 72 144 1 2036458640 35001216 21966992
20:45:10 8462 8192000000 10930543488 11373998080 1963581344 19.334 99 42 84 3 2014059344 36993632 13484368
20:45:30 6522 8192000000 10918430176 11362594816 1963748416 19.336 99 42 84 1 2013734432 36237680 13748336
20:45:44 6270 8192000000 10917859456 11350462464 1946502416 19.199 99 49 95 2 1999687056 38964336 14220304
20:45:58 5497 8192000000 10945357072 11370438656 1975157760 19.426 100 68 134 2 2032408000 36743360 20506880
20:46:11 1701 8192000000 10960509408 11380076544 1980078592 19.465 100 78 157 0 2042800320 38801056 23920672
20:46:24 1428 8192000000 10977712736 11390824448 1988303216 19.530 100 94 188 1 2058110928 40987920 28819792
20:46:31 2205 8192000000 10965323568 11379265536 1953795552 19.257 98 85 170 1 2022115776 42206576 26113648
20:46:41 5766 8192000000 10981933504 11395813376 1987261968 19.522 100 82 164 1 2057685568 45603360 24820240
20:46:54 3037 8192000000 10987760800 11399753728 1990705856 19.549 100 85 169 1 2063097808 45750800 26641152
20:47:06 3462 8192000000 10991078432 11408195584 2000329584 19.625 100 85 170 0 2072995760 45916432 26749744
20:47:17 2682 8192000000 10984410848 11405053952 1994265024 19.577 100 78 156 1 2067715776 48534544 24916208
20:47:27 2612 8192000000 11001676208 11419041792 2003018816 19.647 100 80 158 2 2078315328 50614512 24682000
20:47:39 2970 8192000000 10981832480 11396911104 1973702000 19.415 99 85 168 0 2049607744 49173168 26732576
20:47:49 7080 8192000000 10954571936 11383128064 1967785312 19.368 100 67 134 2 2041424048 51863296 21775440
20:48:03 1551 8192000000 10959858848 11384856576 1976051776 19.433 100 76 150 0 2049380768 49170048 24158944
20:48:25 6195 8192000000 10941019568 11373826048 1943200384 19.172 99 64 127 1 2008574432 44473296 20900752
20:48:39 4911 8192000000 10950216544 11363471360 1944193280 19.180 99 74 149 1 2013971216 46166912 23611024
20:48:50 5968 8192000000 10946132608 11361828864 1943072048 19.171 99 76 151 0 2014690656 47640288 23978320
20:49:06 1983 8192000000 10956048896 11361886208 1953321232 19.253 100 91 183 2 2035264144 53370400 28572512
20:49:15 1327 8192000000 10958775104 11368124416 1963441248 19.333 100 89 178 2 2040256560 48651536 28163776
20:49:24 3279 8192000000 10949741456 11370057728 1947552416 19.207 99 69 138 1 2018815584 50126192 21136976
20:49:45 7099 8192000000 10946336992 11380920320 1965596720 19.351 100 53 106 1 2029838000 46873136 17368144
20:49:58 12620 8192000000 10948994096 11389501440 1971807200 19.400 100 47 94 1 2038216128 50950272 15458656
20:50:37 12124 8192000000 10944977040 11378696192 1964328608 19.340 99 42 85 1 2025265520 47379712 13557200
20:50:57 6322 8192000000 10960869968 11402694656 1983239376 19.490 100 36 72 0 2043509760 48053968 12216416
20:51:12 4896 8192000000 10969696656 11405737984 1989594128 19.541 100 51 102 1 2055418272 48708000 17116144
20:51:25 4468 8192000000 10990067008 11412475904 1994482752 19.579 100 66 128 2 2065632880 50498080 20652048
20:51:36 14247 8192000000 10974254768 11423457280 1995826400 19.590 100 42 84 0 2062997216 52794400 14376416
20:52:03 15075 8192000000 10971243856 11415277568 1981589312 19.477 99 37 73 0 2043174672 49370176 12215184
20:52:35 13374 8192000000 10956858016 11403583488 1974543552 19.421 99 35 70 1 2043767808 57304976 11919280
20:52:55 7653 8192000000 10964010096 11410288640 1965072352 19.346 99 39 78 0 2035784992 56959824 13752816
20:53:10 4840 8192000000 10942425120 11385516032 1955841040 19.273 100 34 68 1 2028486048 59925616 12719392
20:54:01 5066 8192000000 10964748176 11403182080 1965299200 19.348 100 46 92 1 2048773760 66947616 16526944
20:54:16 5455 8192000000 10975863472 11411361792 1969301312 19.380 100 48 96 3 2058741120 71751824 17687984
20:54:30 11800 8192000000 10980203168 11424952320 1975308880 19.428 100 44 87 1 2063656592 72593536 15754176
20:54:50 21294 8192000000 10976535376 11437064192 1979329456 19.459 100 40 80 0 2065566512 72097744 14139312
20:55:25 23378 8192000000 10948788672 11430993920 1971549104 19.398 100 30 60 2 2041876448 59463264 10864080
20:55:56 21213 8192000000 10945613408 11409829888 1967592160 19.366 100 26 53 1 2033280064 56027584 9660320
20:56:23 28970 8192000000 10938855200 11405783040 1944137424 19.180 99 25 50 2 2004647632 51608416 8901792
20:56:59 16810 8192000000 10907646016 11370708992 1924406544 19.022 99 22 44 0 1984510176 51455808 8647824
20:57:48 42656 8192000000 10902649376 11386515456 1924178176 19.020 99 14 28 0 1978236448 48747504 5310768
20:58:37 62063 8192000000 10862916720 11322408960 1901332384 18.837 98 4 8 0 1919918960 17646992 939584
20:59:46 17483 8192000000 10899590464 11324862464 1928847920 19.058 99 47 88 0 1947068192 5393344 12826928
21:00:10 3475 8192000000 10909725664 11343065088 1956489552 19.278 100 56 110 3 1979368256 7442448 15436256
21:00:20 14155 8192000000 10905339648 11355774976 1971151696 19.395 100 46 90 3 1992625296 8331184 13142416
21:00:40 49672 8192000000 10897481776 11338076160 1911826640 18.921 97 33 68 3 1928895664 7999072 9069952
21:01:43 138285 8192000000 10889631872 11353128960 1945316688 19.189 99 23 46 0 1961208080 9157152 6734240
21:04:10 56942 8192000000 10873705152 11334086656 1866541632 18.556 95 12 24 0 1876754624 7271072 2941920
21:05:13 102902 8192000000 10880600224 11358482432 1961762192 19.320 100 26 52 1 1992829744 23785968 7281584
21:07:02 48302 8192000000 10910421168 11358150656 1948933328 19.218 99 24 48 1 1968088640 12381312 6774000
21:07:59 45812 8192000000 10882144096 11353665536 1940475248 19.151 99 18 36 2 1957969936 11950672 5544016
21:08:59 25458 8192000000 10895211760 11352588288 1961794832 19.320 100 22 44 1 1981384688 13110192 6479664
21:09:30 2485 8192000000 10895551472 11354341376 1962165520 19.323 100 17 34 0 1981071328 13637792 5268016
21:09:39 10713 8192000000 10892339424 11352952832 1962978224 19.330 100 17 34 2 1980995872 12547968 5469680
21:09:56 18603 8192000000 10919019472 11368189952 1973335712 19.412 100 30 60 0 1997987088 16146288 8505088
21:10:22 7041 8192000000 10940597200 11380498432 1982027312 19.481 100 61 122 1 2015055680 15918832 17109536
21:10:37 16384 8192000000 10893575568 11352412160 1940498832 19.151 98 34 68 2 1965894144 15898096 9497216
21:11:10 23696 8192000000 10910079728 11372056576 1971273840 19.396 100 29 58 0 1996882304 16645616 8962848
21:11:47 30662 8192000000 10927374160 11369771008 1959491328 19.302 99 47 94 3 1992066624 18425488 14149808
21:12:29 9526 8192000000 10940347632 11374686208 1979422160 19.460 100 47 90 0 2010260192 17729840 13108192
21:12:49 17410 8192000000 10920192384 11372326912 1962332624 19.325 99 48 97 0 1992332912 16523968 13476320
21:13:12 33823 8192000000 10889465728 11365724160 1950636768 19.232 99 28 54 1 1975753152 17298672 7817712
21:13:56 54014 8192000000 10872221904 11345485824 1954779568 19.265 100 10 20 0 1966629968 8792016 3058384
21:15:01 26833 8192000000 10884016848 11354894336 1963949200 19.337 100 7 14 1 1973417648 7297760 2170688
21:15:34 8364 8192000000 10887482192 11359350784 1968393536 19.373 100 4 9 0 1977511408 7834224 1283648
21:15:49 5872 8192000000 10883838672 11362426880 1969317728 19.380 100 4 8 1 1977600736 7374592 908416
21:16:05 31943 8192000000 10902435296 11372675072 1974561024 19.422 100 16 32 1 1986832688 7910416 4361248
21:16:45 44547 8192000000 10889502896 11364818944 1961796208 19.320 99 18 35 2 1980608256 13567984 5244064
21:17:36 98497 8192000000 10901006160 11373969408 1961180448 19.315 99 17 34 1 1974385824 7835376 5370000
21:19:22 75050 8192000000 10888236096 11375198208 1957928512 19.290 99 13 26 0 1971051360 9320512 3802336
21:20:44 10909 8192000000 10902198624 11372388352 1980060048 19.465 100 25 48 1 1995151760 8432864 6658848
21:21:15 38554 8192000000 10875687008 11346997248 1938967600 19.139 98 19 38 2 1954235888 9505280 5763008
21:22:04 26373 8192000000 10891943264 11370520576 1950739200 19.232 99 14 28 0 1963766896 9148560 3879136
21:22:36 69942 8192000000 10899206672 11373899776 1977480672 19.445 100 22 44 0 1994617424 10885936 6250816
21:24:11 53811 8192000000 10901493568 11390873600 1978268480 19.451 100 5 10 0 1995373552 16005552 1099520
21:25:29 38068 8192000000 10876418256 11351838720 1915705728 18.952 97 19 38 2 1930603232 9809008 5088496
21:26:17 25479 8192000000 10876356960 11341328384 1917894544 18.970 97 48 94 2 1940470432 8123760 14452128
21:26:49 25990 8192000000 10890545856 11350671360 1921525136 18.999 98 26 52 0 1938397744 9671040 7201568
21:27:23 22281 8192000000 10874921680 11334037504 1885209040 18.707 96 42 82 0 1907210432 11072928 10928464
21:27:55 54396 8192000000 10877325712 11348201472 1933054160 19.091 99 20 40 0 1953056000 14029888 5971952
21:28:58 55840 8192000000 10864243536 11334742016 1878119408 18.650 96 9 18 1 1893246832 13147920 1979504
21:30:06 32037 8192000000 10860715440 11322134528 1864483072 18.540 96 27 54 1 1885510608 13586496 7441040
21:30:48 47615 8192000000 10879264096 11349127168 1900864736 18.833 98 18 36 0 1921951392 16187968 4898688
21:32:17 84428 8192000000 10870910816 11364020224 1913397168 18.934 99 12 24 1 1944130400 26823616 3909616
21:33:52 35232 8192000000 10860032176 11308523520 1865734080 18.550 96 31 62 2 1884940848 10608928 8597840
21:34:38 27651 8192000000 10850337408 11310030848 1894356816 18.781 98 32 63 0 1912353936 9638864 8358256
21:35:13 81069 8192000000 10841339264 11316854784 1865359232 18.547 97 18 37 1 1880953648 10762608 4831808
21:36:42 51830 8192000000 10893729712 11334840320 1884421696 18.701 97 26 52 2 1901323520 9127264 7774560
21:37:47 66459 8192000000 10898130144 11359932416 1934561856 19.103 99 41 78 0 1966033648 20626640 10845152
21:39:00 68904 8192000000 10887637616 11371847680 1929169088 19.060 99 8 16 0 1958678640 27192048 2317504
21:41:15 93735 8192000000 10884312800 11352547328 1918570208 18.975 98 19 38 0 1936271200 12334032 5366960
21:42:56 27923 8192000000 10886162688 11347529728 1938975984 19.139 99 32 64 0 1959835584 11124352 9735248
21:43:34 63673 8192000000 10891886176 11365752832 1960136000 19.307 100 13 26 0 1979946880 16115456 3695424
21:45:42 51466 8192000000 10874771952 11352072192 1921702368 19.000 98 9 18 0 1935847984 11442960 2702656
21:47:00 66082 8192000000 10852718192 11333586944 1875194608 18.626 96 15 30 0 1891149808 11580848 4374352
21:48:16 6294 8192000000 10867344752 11331055616 1928037008 19.051 100 28 56 1 1949221776 11828128 9356640
21:48:30 27065 8192000000 10844654448 11318775808 1897812736 18.809 98 33 65 1 1915230016 7268256 10149024
21:49:08 41629 8192000000 10871514928 11329671168 1925460480 19.031 99 39 78 2 1946150096 9980448 10709168
21:50:09 38847 8192000000 10832115104 11302330368 1880117200 18.666 97 19 36 3 1897544416 12194704 5232512
21:50:58 43903 8192000000 10860845008 11320508416 1888599056 18.734 98 18 36 1 1906523536 12531712 5392768
21:51:48 49119 8192000000 10883221648 11339874304 1947915488 19.210 100 32 64 4 1966557232 9813776 8827968
21:52:54 66721 8192000000 10852427184 11320807424 1868525472 18.572 96 11 20 3 1880230160 8510656 3194032
21:54:07 25058 8192000000 10887607104 11347152896 1950248736 19.228 100 32 64 1 1972770944 13240688 9281520
21:54:40 80764 8192000000 10869279344 11333734400 1892076144 18.763 97 14 28 0 1911524928 14253120 5195664
21:56:22 89585 8192000000 10922318352 11362410496 1932683360 19.088 99 19 38 1 1946475184 8837392 4954432
21:58:01 32997 8192000000 10911970032 11365040128 1938541120 19.135 98 39 78 3 1960160384 11303504 10315760
21:58:42 19455 8192000000 10913679776 11370229760 1974631888 19.422 100 41 82 0 1997986944 12036336 11318720
21:59:10 49778 8192000000 10923153664 11379183616 1960252944 19.308 99 30 60 2 1980560496 12041424 8266128
22:00:06 23685 8192000000 10936250384 11389366272 1985873824 19.511 100 28 56 1 2002836048 9080576 7881648
22:00:39 34919 8192000000 10917919040 11388059648 1987701632 19.526 100 29 58 1 2008145776 12022672 8421472
22:01:22 103724 8192000000 10905053584 11381186560 1927105728 19.044 97 14 28 3 1945786656 14582096 4098832
22:03:14 27905 8192000000 10922736128 11382136832 1967638528 19.367 99 32 64 1 1986437792 9877232 8922032
22:03:48 108814 8192000000 10932180368 11410939904 1972718864 19.407 99 26 52 1 1992764880 13118640 6927376
22:06:11 107802 8192000000 10913844288 11388149760 1972955568 19.409 99 20 40 1 1994526672 15000272 6570832
22:08:14 28667 8192000000 10929782304 11398565888 2001424928 19.634 100 52 104 0 2026711472 10664608 14621936
22:08:50 50764 8192000000 10900744384 11381440512 1957796368 19.289 98 25 50 0 1972718976 8414336 6508272
22:09:47 69778 8192000000 10888844656 11368685568 1931124688 19.076 97 12 24 1 1943229536 8554720 3550128
22:11:03 50416 8192000000 10888455616 11363299328 1961757712 19.320 99 12 24 0 1977552048 12239968 3554368
22:12:03 30767 8192000000 10877954912 11354763264 1946618448 19.200 99 18 34 1 1969148752 17934016 4596288
22:12:46 46906 8192000000 10892205904 11369357312 1940758800 19.153 99 17 33 0 1965168896 19342896 5067200
22:13:39 36596 8192000000 10897236448 11369222144 1942740432 19.169 99 17 32 0 1965735056 17727696 5266928
22:14:23 37269 8192000000 10892114544 11370250240 1948615920 19.215 99 15 30 0 1969308880 16043392 4649568
22:15:06 46350 8192000000 10874900496 11357175808 1907679424 18.888 97 19 38 0 1932202352 18675632 5847296
22:16:22 43521 8192000000 10852322672 11332767744 1854982528 18.463 95 27 53 0 1873236432 10585472 7668432
22:17:12 51355 8192000000 10874080304 11338203136 1874456432 18.620 96 17 34 0 1888175936 8909408 4810096
22:18:21 76314 8192000000 10840775664 11306971136 1791342160 17.943 92 19 38 1 1812535424 15684736 5508528
22:19:46 74087 8192000000 10874457616 11330113536 1891853168 18.761 98 37 74 1 1918915008 16706208 10355632
22:21:06 56734 8192000000 10878148384 11344781312 1936408064 19.118 100 23 46 1 1956141312 12838016 6895232
22:22:10 76054 8192000000 10854073520 11304058880 1771731360 17.781 91 29 58 1 1790327200 10851152 7744688
22:23:33 34892 8192000000 10837704656 11297902592 1867695952 18.566 98 23 45 2 1884804608 10350592 6758064
22:24:15 18052 8192000000 10866542848 11312226304 1902343888 18.845 99 42 83 1 1923601696 10035440 11222368
22:24:42 16401 8192000000 10879026368 11322245120 1911077936 18.915 99 50 100 2 1939998192 15078336 13841920
22:25:09 20012 8192000000 10886809584 11336798208 1924416288 19.022 100 48 96 0 1955171264 17475216 13279760
22:25:37 23912 8192000000 10868021264 11327774720 1920496928 18.991 100 48 96 0 1951993920 18329536 13167456
22:26:09 87568 8192000000 10864115008 11325132800 1871467984 18.596 97 21 42 1 1891320496 14418768 5433744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:34, from 20-06-2021 22:30:41 to 20-06-2021 22:31:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 130 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 20-06-2021 22:31:16 to 20-06-2021 22:31:17.

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          246323
MON$OLDEST_ACTIVE               247202
MON$OLDEST_SNAPSHOT             247202
MON$NEXT_TRANSACTION            247202
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                       2038048
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:124: 
:125: mscs-test-161.budzdorov.ru    Sun Jun 20 22:27:53 2021
:126:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:127: 
:128: 
:129: mscs-test-161.budzdorov.ru    Sun Jun 20 22:28:18 2021
:130:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:131: 
:132: 
:133: mscs-test-161.budzdorov.ru    Sun Jun 20 22:28:50 2021
:134:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:135: 
--- end of diff output ---

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

20.06.21 22:31:18. 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-06-20 22:31:21 No severe PSQL-related problems occured
20.06.21 22:31:22. End of report.