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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16972020 kB
MemAvailable 31132688 kB
Buffers 0 kB
Cached 14728128 kB
SwapCached 3892 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-22 22:27:22
DTS_END                         2021-02-22 22:27:22.1190
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34992
TRN_ID                          240934
ATT_ID                          706
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: 9500.91 19784 1140109
customer order: creation 176.01 330 21121
customer order: refuse 14.70 330 1764
order to supplier: creation 46.96 1224 5635
order to supplier: removal 3.64 98327 437
invoice (draft): creation 46.48 3128 5578
invoice (draft): removal 53.68 889 6442
invoice accept: apply 42.61 16907 5113
invoice accept: cancel 48.83 798 5860
customer reserve: creation 3952.90 166 474348
customer reserve: removal 4817.61 57 578113
realization accept: apply 84.79 179 10175
realization accept: cancel 80.78 117 9693
payment from customer: creation 60.12 118 7214
payment from customer: removal 5.82 67 698
payment to supplier: creation 50.39 139 6047
payment to supplier: removal 3.69 61 443
service: total inventory turnovers 4.71 1200 565
service: total monetary turnovers 6.35 25 762
service: aggregate perf. data 0.81 23165 97
service: refresh index statistics 0.03 248450 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-02-2021 22:28:42 to 22-02-2021 22:28:44.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5712
TEST_TIME 2 5048
TEST_TIME 3 5737
TEST_TIME 4 5371
TEST_TIME 5 5116
TEST_TIME 6 5267
TEST_TIME 7 5378
TEST_TIME 8 5238
TEST_TIME 9 5854
TEST_TIME 10 5822
TEST_TIME 11 6068
TEST_TIME 12 6228
TEST_TIME 13 6484
TEST_TIME 14 6465
TEST_TIME 15 6802
TEST_TIME 16 6766
TEST_TIME 17 7438
TEST_TIME 18 7557
TEST_TIME 19 7742
TEST_TIME 20 8473
TEST_TIME 21 9107
TEST_TIME 22 9811
TEST_TIME 23 9635
TEST_TIME 24 9761
TEST_TIME 25 10116
TEST_TIME 26 10107
TEST_TIME 27 10260
TEST_TIME 28 10737
TEST_TIME 29 11218
TEST_TIME 30 11024
TEST_TIME 31 11036
TEST_TIME 32 10923
TEST_TIME 33 10744
TEST_TIME 34 10528
TEST_TIME 35 10362
TEST_TIME 36 10385
TEST_TIME 37 10363
TEST_TIME 38 10246
TEST_TIME 39 10174
TEST_TIME 40 10270
TEST_TIME 41 10291
TEST_TIME 42 10120
TEST_TIME 43 10049
TEST_TIME 44 9917
TEST_TIME 45 9827
TEST_TIME 46 9742
TEST_TIME 47 9847
TEST_TIME 48 9807
TEST_TIME 49 9750
TEST_TIME 50 9682
TEST_TIME 51 9694
TEST_TIME 52 9678
TEST_TIME 53 9706
TEST_TIME 54 9680
TEST_TIME 55 9765
TEST_TIME 56 9695
TEST_TIME 57 9794
TEST_TIME 58 9847
TEST_TIME 59 9802
TEST_TIME 60 9807
TEST_TIME 61 9975
TEST_TIME 62 9934
TEST_TIME 63 9983
TEST_TIME 64 10027
TEST_TIME 65 10003
TEST_TIME 66 9973
TEST_TIME 67 9856
TEST_TIME 68 9858
TEST_TIME 69 9826
TEST_TIME 70 9783
TEST_TIME 71 9716
TEST_TIME 72 9682
TEST_TIME 73 9668
TEST_TIME 74 9581
TEST_TIME 75 9624
TEST_TIME 76 9621
TEST_TIME 77 9614
TEST_TIME 78 9630
TEST_TIME 79 9660
TEST_TIME 80 9730
TEST_TIME 81 9674
TEST_TIME 82 9767
TEST_TIME 83 9763
TEST_TIME 84 9806
TEST_TIME 85 9788
TEST_TIME 86 9869
TEST_TIME 87 9886
TEST_TIME 88 9894
TEST_TIME 89 9811
TEST_TIME 90 9779
TEST_TIME 91 9747
TEST_TIME 92 9737
TEST_TIME 93 9668
TEST_TIME 94 9733
TEST_TIME 95 9716
TEST_TIME 96 9681
TEST_TIME 97 9674
TEST_TIME 98 9650
TEST_TIME 99 9717
TEST_TIME 100 9732
TEST_TIME 101 9758
TEST_TIME 102 9760
TEST_TIME 103 9766
TEST_TIME 104 9753
TEST_TIME 105 9771
TEST_TIME 106 9798
TEST_TIME 107 9825
TEST_TIME 108 9865
TEST_TIME 109 9779
TEST_TIME 110 9755
TEST_TIME 111 9710
TEST_TIME 112 9719
TEST_TIME 113 9687
TEST_TIME 114 9681
TEST_TIME 115 9650
TEST_TIME 116 9617
TEST_TIME 117 9554
TEST_TIME 118 9571
TEST_TIME 119 9562
TEST_TIME 120 9508

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 22-02-2021 22:28:45 to 22-02-2021 22:28:49.

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 1578185 1578185 0 0.00 0 15717 6 0 0
doc_list_biud 1578184 1578184 0 0.00 0 62268 27 0 0
sp_add_invoice_to_stock 5201 5113 88 1.69 34 173630 16907 0 88
sp_cancel_adding_invoice 5860 5860 0 0.00 5 48938 798 0 0
sp_cancel_client_order 1764 1764 0 0.00 4 12142 330 0 0
sp_cancel_customer_reserve 578113 578113 0 0.00 1 62269 57 0 0
sp_cancel_pay_from_customer 698 698 0 0.00 3 4525 68 0 0
sp_cancel_pay_to_supplier 443 443 0 0.00 3 2337 61 0 0
sp_cancel_supplier_invoice 6451 6442 9 0.13 2 24081 889 0 9
sp_cancel_supplier_order 437 437 0 0.00 6 1091928 98327 0 0
sp_cancel_write_off 9693 9693 0 0.00 1 9369 118 0 0
sp_client_order 21121 21121 0 0.00 4 43260 330 0 0
sp_customer_reserve 474348 474348 0 0.00 0 138751 166 0 0
sp_fill_shopping_cart 32320 32320 0 0.00 1 15406 36 0 0
sp_fill_shopping_cart_clo_res 474333 474333 0 0.00 0 15678 13 0 0
sp_get_clo_for_invoice 5098 5098 0 0.00 0 26837 285 0 0
sp_kill_cost_storno 16694 16694 0 0.00 0 6532 56 0 0
sp_kill_qstorno_ret_qs2qd 1172798 1172798 0 0.00 0 61513 31 0 0
sp_kill_qty_storno 617581 617581 0 0.00 0 62267 68 0 0
sp_lock_selected_doc 21109 21109 0 0.00 0 7868 5 0 0
sp_make_cost_storno 28533 28533 0 0.00 0 15710 53 0 0
sp_multiply_rows_for_pdistr 28533 28533 0 0.00 0 11554 28 0 0
sp_multiply_rows_for_qdistr 21121 21121 0 0.00 0 43248 160 0 0
sp_pay_from_customer 7214 7214 0 0.00 4 14636 118 0 0
sp_pay_to_supplier 6047 6047 0 0.00 5 15646 139 0 0
sp_payment_common 13260 13260 0 0.00 1 11311 33 0 0
sp_qd_handle_on_cancel_clo 1764 1764 0 0.00 0 12132 298 0 0
sp_qd_handle_on_invoice_upd_sts 10957 10957 0 0.00 0 15552 312 0 0
sp_qd_handle_on_reserve_upd_sts 10175 10175 0 0.00 0 13635 64 0 0
sp_reserve_write_off 10175 10175 0 0.00 6 15399 179 0 0
sp_supplier_invoice 5578 5578 0 0.00 6 93266 3128 0 0
sp_supplier_order 5635 5635 0 0.00 5 25309 1225 0 0
srv_aggregate_perf_data 98 97 1 1.02 2902 455558 23166 0 1
srv_fill_mon_cache_memory 162 162 0 0.00 1610 182899 32729 0 0
srv_find_qd_qs_mism 1090690 1090690 0 0.00 0 14330 5 0 0
srv_make_invnt_saldo 565 565 0 0.00 41 90902 1200 0 0
srv_make_money_saldo 762 762 0 0.00 1 823 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 207023 289663 248451 0 0
t$perf-abend:sp_add_invoice_to_stock 88 88 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5113 5113 0 0.00 0 13613 188 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 2904 82 0 0
t$perf-norm:sp_cancel_client_order 1764 1764 0 0.00 0 4193 19 0 0
t$perf-norm:sp_cancel_customer_reserve 712 712 0 0.00 0 4905 29 0 0
t$perf-norm:sp_cancel_pay_from_customer 698 698 0 0.00 0 4641 24 0 0
t$perf-norm:sp_cancel_pay_to_supplier 443 443 0 0.00 0 2065 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 346 346 0 0.00 0 635 13 0 0
t$perf-norm:sp_cancel_supplier_order 437 437 0 0.00 0 25311 1740 0 0
t$perf-norm:sp_cancel_write_off 1030 1030 0 0.00 0 4832 21 0 0
t$perf-norm:sp_client_order 21121 21121 0 0.00 0 10812 17 0 0
t$perf-norm:sp_customer_reserve 985 985 0 0.00 0 5729 15 0 0
t$perf-norm:sp_pay_from_customer 7214 7214 0 0.00 0 7689 12 0 0
t$perf-norm:sp_pay_to_supplier 6047 6047 0 0.00 0 8958 14 0 0
t$perf-norm:sp_reserve_write_off 10175 10175 0 0.00 0 7084 11 0 0
t$perf-norm:sp_supplier_invoice 5578 5578 0 0.00 0 7849 21 0 0
t$perf-norm:sp_supplier_order 5635 5635 0 0.00 0 6412 21 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 279 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 743 10 0 0
t$perf-norm:srv_make_invnt_saldo 565 565 0 0.00 0 2252 25 0 0
t$perf-norm:srv_make_money_saldo 762 762 0 0.00 0 1165 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 12 6 0 0
v_add_invoice_to_stock 10366 10190 176 1.69 0 12896 18 0 176
v_all_customers 38198 38198 0 0.00 0 83 1 0 0
v_all_suppliers 31452 31452 0 0.00 0 83 1 0 0
v_all_wares 42238 42238 0 0.00 0 46 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 715 7 0 0
v_cancel_client_order 3528 3528 0 0.00 0 6460 6 0 0
v_cancel_customer_prepayment 1396 1396 0 0.00 0 4515 7 0 0
v_cancel_customer_reserve 1424 1424 0 0.00 0 6952 8 0 0
v_cancel_payment_to_supplier 886 886 0 0.00 0 2333 8 0 0
v_cancel_supplier_invoice 710 692 18 2.53 0 1003 14 0 18
v_cancel_supplier_order 874 874 0 0.00 0 1566 6 0 0
v_cancel_write_off 2060 2060 0 0.00 0 8657 30 0 0
v_max_id_clo_ord 5629 5629 0 0.00 0 1411 1 0 0
v_max_id_clo_res 985 985 0 0.00 0 1402 9 0 0
v_max_id_ord_sup 5572 5572 0 0.00 0 2168 3 0 0
v_max_non_paid_invoice 1522 1522 0 0.00 0 1953 3 0 0
v_max_non_paid_realizn 3911 3911 0 0.00 0 1173 3 0 0
v_min_id_clo_ord 5629 5629 0 0.00 0 4146 7 0 0
v_min_id_clo_res 985 985 0 0.00 0 1197 5 0 0
v_min_id_ord_sup 5572 5572 0 0.00 0 4639 6 0 0
v_min_non_paid_invoice 6047 6047 0 0.00 0 11181 20 0 0
v_min_non_paid_realizn 7213 7213 0 0.00 0 11306 25 0 0
v_our_firm 10644 10644 0 0.00 0 29 1 0 0
v_reserve_write_off 20348 20348 0 0.00 0 5893 6 0 0
x_lock_depdocs_on_canc_invoice 11956 11956 0 0.00 0 38178 128 0 0
x_lock_depdocs_on_canc_sup_ord 437 437 0 0.00 0 2476 262 0 0
x_make_qstorno_1000_1200 5635 5635 0 0.00 1 25296 1143 0 0
x_make_qstorno_1200_2000 5578 5578 0 0.00 3 93243 3003 0 0
x_make_qstorno_2100_3300 474348 474348 0 0.00 0 138706 151 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-02-2021 22:28:50 to 22-02-2021 22:28:54.

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:26 4 8192000000 8803747328 8815738880 9504384 0.115 2 2 3 0 9682832 66144 112304
19:57:33 17525 8192000000 10275507360 10584477696 1094017712 11.781 85 64 128 0 1119248176 3003232 22227232
19:58:00 27819 8192000000 10354286256 10669703168 1399321568 14.589 100 88 176 1 1432265408 4847168 28096672
19:58:36 18010 8192000000 10373146432 10693783552 1428940608 14.852 100 90 180 0 1464354688 6124256 29289824
19:59:08 17838 8192000000 10394676384 10719772672 1453648336 15.070 100 93 186 2 1490993536 7371360 29973840
19:59:36 24014 8192000000 10419059328 10746032128 1467143712 15.189 100 93 186 0 1505058592 7879904 30034976
20:00:10 20865 8192000000 10438069312 10766098432 1489039424 15.380 100 92 184 1 1527680096 8732112 29908560
20:00:50 22670 8192000000 10448895456 10781409280 1501122720 15.486 100 89 178 0 1539040144 9186688 28730736
20:01:21 25843 8192000000 10487458256 10828673024 1525226512 15.696 100 88 176 0 1563106784 9699344 28180928
20:01:57 16050 8192000000 10510284416 10858663936 1566939536 16.056 100 75 150 0 1599419552 9603280 22876736
20:02:22 17998 8192000000 10544033120 10901893120 1603974640 16.373 100 80 159 2 1637422656 9425184 24022832
20:02:56 11161 8192000000 10571968000 10934747136 1631517200 16.608 100 73 146 0 1662831696 10154160 21160336
20:03:15 15304 8192000000 10596664368 10961334272 1656804656 16.822 100 73 146 1 1689684656 11101136 21778864
20:03:37 10486 8192000000 10619779184 10988105728 1681635616 17.031 100 75 150 0 1715194912 11352144 22207152
20:04:01 7467 8192000000 10633498768 11005194240 1697430864 17.164 100 78 154 0 1731664304 12207056 22026384
20:04:15 11330 8192000000 10654081856 11024048128 1718898224 17.343 100 79 158 1 1754366960 12927728 22541008
20:04:37 5826 8192000000 10653810496 11028709376 1721549296 17.365 100 78 155 1 1756302160 13025904 21726960
20:04:51 8260 8192000000 10682003808 11056455680 1740971376 17.527 100 74 149 2 1774827488 13080288 20775824
20:05:06 5037 8192000000 10688371024 11063914496 1750259152 17.604 100 74 144 1 1783827296 12717600 20850544
20:05:19 4433 8192000000 10697766176 11077554176 1761688928 17.698 100 74 148 0 1795257328 12483200 21085200
20:05:31 5057 8192000000 10710648400 11088285696 1781525792 17.862 100 86 171 2 1816984192 12205536 23252864
20:05:43 5665 8192000000 10722923792 11103346688 1781950192 17.866 100 82 164 1 1817776224 12858448 22967584
20:05:57 7763 8192000000 10727470576 11109462016 1787206864 17.909 100 79 157 0 1827205280 18122592 21875824
20:06:13 2864 8192000000 10742415632 11121975296 1804151408 18.048 100 76 153 3 1838467632 12644656 21671568
20:06:23 3982 8192000000 10749382000 11132407808 1812841008 18.119 100 79 156 2 1846653248 12202640 21609600
20:06:35 3835 8192000000 10756121008 11143938048 1818050128 18.162 100 80 161 2 1852688944 12990112 21648704
20:06:46 2958 8192000000 10770697520 11154636800 1824536064 18.215 100 83 166 0 1860862576 13731328 22595184
20:06:55 3173 8192000000 10759321536 11144368128 1826325904 18.229 100 85 172 0 1864262112 14488112 23448096
20:07:05 4127 8192000000 10770512128 11158568960 1829767152 18.257 100 93 187 2 1871263024 15234016 26261856
20:07:16 3146 8192000000 10777717488 11161645056 1835319840 18.303 100 93 183 1 1879215728 19327696 24568192
20:07:25 2026 8192000000 10779804176 11168210944 1843302960 18.368 100 90 181 2 1882725424 13935824 25486640
20:07:34 2224 8192000000 10791159376 11173789696 1847442448 18.401 100 87 174 5 1886011312 13356448 25212416
20:07:42 3042 8192000000 10791307984 11174481920 1845158336 18.383 100 87 174 2 1883671088 14167472 24345280
20:07:52 1429 8192000000 10794637856 11179782144 1849199536 18.416 100 91 183 0 1889353408 14451728 25702144
20:08:00 2809 8192000000 10799070192 11187523584 1856449392 18.474 100 90 180 2 1895610640 14869040 24292208
20:08:09 1887 8192000000 10802065648 11190128640 1856621072 18.476 100 95 191 0 1898889008 16121232 26146704
20:08:17 1505 8192000000 10807347904 11194052608 1858213216 18.489 100 94 189 1 1899478416 14380256 26884944
20:08:25 1838 8192000000 10803966128 11194728448 1861992896 18.519 100 92 184 1 1902329392 13719328 26617168
20:08:33 1824 8192000000 10809335392 11196121088 1863294576 18.530 100 84 167 0 1899789776 12555632 23939568
20:08:41 25248 8192000000 10802670736 11198263296 1868288816 18.570 100 69 138 1 1901797264 13016704 20491744
20:09:16 14588 8192000000 10806356960 11204308992 1870514912 18.588 100 66 131 2 1899146672 9442752 19189008
20:09:37 3388 8192000000 10804666144 11217264640 1878882240 18.656 100 75 150 0 1912263312 11702592 21678480
20:09:49 9468 8192000000 10785628048 11208007680 1870836448 18.591 100 28 57 0 1886375040 8069600 7468992
20:10:07 2066 8192000000 10800818960 11218624512 1876872656 18.640 100 50 98 2 1903423472 12040688 14510128
20:10:19 5154 8192000000 10799298000 11211595776 1877855152 18.648 100 46 93 2 1898757696 7132992 13769552
20:10:32 6737 8192000000 10780413072 11211309056 1874949408 18.624 100 22 44 2 1887536784 6729344 5858032
20:10:49 5188 8192000000 10778327536 11212062720 1877068576 18.641 100 21 42 2 1889555888 6142576 6344736
20:11:03 4049 8192000000 10789490560 11218452480 1880773760 18.671 100 30 60 0 1899211424 9853872 8583792
20:11:20 61612 8192000000 10815953344 11232362496 1887120400 18.723 100 33 66 1 1907184080 9293648 10770032
20:12:29 1839 8192000000 10835863408 11248877568 1902645888 18.848 100 84 169 1 1937691408 10404496 24641024
20:12:37 6320 8192000000 10814938416 11237642240 1893236064 18.772 100 35 71 2 1911584432 8938272 9410096
20:12:50 7729 8192000000 10803915488 11238727680 1893970528 18.778 100 31 61 2 1910618528 8059648 8588352
20:13:05 7102 8192000000 10813345120 11243798528 1898983248 18.818 100 32 64 3 1913078960 5540288 8555424
20:13:21 7131 8192000000 10834534752 11256639488 1902634096 18.847 100 26 52 1 1920538880 10571824 7332960
20:13:35 4497 8192000000 10819962528 11253067776 1906733232 18.880 100 25 50 0 1920579808 6400160 7446416
20:13:50 4609 8192000000 10823618720 11255001088 1906538160 18.879 100 22 44 0 1919026752 5678544 6810048
20:14:02 7797 8192000000 10824550400 11254976512 1907872896 18.890 100 29 59 2 1922676528 7023664 7779968
20:14:19 7143 8192000000 10813907168 11250315264 1891479616 18.758 99 31 61 1 1907386112 6446432 9460064
20:14:35 10273 8192000000 10823909488 11259731968 1916716352 18.961 100 31 63 1 1933047984 6763968 9567664
20:14:54 8166 8192000000 10837823552 11267219456 1917351024 18.966 100 21 42 2 1929216976 6002576 5863376
20:15:11 13359 8192000000 10827721328 11268026368 1919894816 18.986 100 14 28 1 1930384336 5757296 4732224
20:15:32 58957 8192000000 10846886384 11273822208 1923549136 19.015 100 35 67 2 1938910944 5628336 9733472
20:16:37 9595 8192000000 10829120944 11267600384 1918436960 18.974 100 21 42 0 1931080320 6172960 6470400
20:16:54 9436 8192000000 10823709968 11258724352 1883682448 18.695 98 23 44 0 1895147600 5348400 6116752
20:17:11 4549 8192000000 10823174608 11255259136 1897255872 18.804 99 36 73 1 1914833456 6194480 11383104
20:17:24 4840 8192000000 10827050240 11257872384 1893197440 18.772 99 25 51 0 1910103904 10005664 6900800
20:17:35 7099 8192000000 10826620672 11254386688 1903394656 18.854 100 23 46 1 1915748576 5876608 6477312
20:17:48 4964 8192000000 10789072448 11215884288 1870275088 18.587 99 37 74 0 1887680976 6450960 10954928
20:18:03 7731 8192000000 10791751904 11221450752 1836075776 18.309 97 37 74 4 1856953904 9932752 10945376
20:18:19 4305 8192000000 10770916432 11196739584 1808746464 18.086 96 18 36 3 1819072848 5349152 4977232
20:18:33 6290 8192000000 10787975808 11213381632 1868494096 18.572 100 19 38 2 1880260544 5816928 5949520
20:18:46 8098 8192000000 10775951648 11200348160 1842150112 18.358 99 25 49 2 1858866480 9753728 6962640
20:19:01 11169 8192000000 10738424848 11162394624 1760619408 17.690 95 19 38 0 1771601200 5498240 5483552
20:19:18 14845 8192000000 10732050032 11164041216 1738368384 17.505 94 24 48 3 1750066896 4972672 6725840
20:19:41 8068 8192000000 10720912384 11133743104 1722091152 17.370 94 18 36 1 1733302656 5756096 5455408
20:19:56 68866 8192000000 10686856800 11099103232 1630223136 16.597 90 32 64 2 1648547392 9537200 8787056
20:21:13 10626 8192000000 10705673504 11125510144 1751357328 17.613 98 30 60 0 1766259728 5506384 9396016
20:21:33 5658 8192000000 10712118752 11131564032 1737528832 17.498 96 32 63 3 1752818560 5433472 9856256
20:21:44 6348 8192000000 10696121616 11101822976 1749886448 17.601 98 35 71 1 1766273392 5959008 10427936
20:21:57 5202 8192000000 10706493664 11122544640 1778952624 17.841 99 25 50 0 1792692064 6591648 7147792
20:22:10 5323 8192000000 10711525424 11128131584 1770068192 17.768 98 35 68 2 1785728816 5327984 10332640
20:22:24 8152 8192000000 10715545072 11141894144 1807668432 18.077 100 25 51 4 1820562112 5574368 7319312
20:22:38 5904 8192000000 10737394688 11153133568 1804475856 18.051 99 19 38 2 1815363360 4905072 5982432
20:22:51 8017 8192000000 10744187552 11168571392 1829437456 18.255 100 29 58 2 1843382544 5412816 8532272
20:23:10 5342 8192000000 10747783968 11163238400 1802411136 18.034 98 35 72 3 1817442448 4851616 10179696
20:23:23 9046 8192000000 10743038224 11168088064 1831719120 18.273 100 22 43 3 1844256816 5582864 6954832
20:23:41 6363 8192000000 10749199824 11174961152 1824065984 18.211 99 22 45 1 1836038176 5892912 6079280
20:23:55 7062 8192000000 10758658832 11188699136 1845968672 18.389 100 12 24 0 1859000224 9576096 3455456
20:24:08 7573 8192000000 10755149520 11187564544 1851139584 18.431 100 29 59 3 1865358656 5617776 8601296
20:24:22 6211 8192000000 10779505088 11201232896 1854474304 18.458 100 24 47 2 1871075536 9497456 7103776
20:24:37 64244 8192000000 10759569232 11200102400 1859636880 18.500 100 20 40 0 1869997696 5417232 4943584
20:25:48 9970 8192000000 10765862160 11201503232 1860616528 18.508 100 15 30 0 1870139328 5028832 4493968
20:26:05 11005 8192000000 10777081136 11207581696 1865325248 18.546 100 22 44 4 1876552432 5641104 5586080
20:26:22 9144 8192000000 10780188528 11212566528 1868944528 18.576 100 29 58 1 1884908544 6897232 9066784
20:26:38 10866 8192000000 10785704912 11215319040 1872472592 18.604 100 35 70 2 1888854176 6245408 10136176
20:26:56 8794 8192000000 10790187072 11219972096 1873142496 18.610 100 26 52 0 1886809776 6661632 7005648
20:27:12 10601 8192000000 10813703120 11234578432 1889011296 18.738 100 30 60 0 1903075376 6026224 8037856
20:27:33 17768 8192000000 10824339616 11244167168 1897083968 18.803 100 37 73 3 1913784848 6022112 10678768
20:27:58 10346 8192000000 10843428480 11256819712 1910298176 18.909 100 60 120 2 1936210480 7936208 17976096
20:28:25 42771 8192000000 10848594448 11270107136 1915051424 18.947 100 40 80 0 1934931776 8821952 11058400
20:29:19 17573 8192000000 10844035168 11273793536 1922409056 19.006 100 38 76 0 1941742352 8737344 10595952
20:29:45 20554 8192000000 10862506176 11290116096 1931269200 19.077 100 43 85 1 1955366608 12165728 11931680
20:30:27 26583 8192000000 10860924800 11295350784 1935260304 19.109 100 35 70 1 1955582560 9655808 10666448
20:31:01 15552 8192000000 10876241280 11304423424 1942804784 19.169 100 47 93 0 1968246384 12505632 12935968
20:31:27 28932 8192000000 10884424512 11314515968 1949776192 19.225 100 47 94 2 1979336912 16227952 13332768
20:32:15 5980 8192000000 10901066880 11324035072 1957457904 19.286 100 54 108 1 1990698192 17909584 15330704
20:32:34 10046 8192000000 10897841024 11330813952 1962272032 19.324 100 53 106 1 1996349328 18793760 15283536
20:32:53 6466 8192000000 10905784192 11335745536 1966221056 19.355 100 56 111 1 2001731968 19036368 16474544
20:33:10 22880 8192000000 10911183728 11351130112 1970016656 19.386 100 48 96 2 2005088688 20712064 14359968
20:33:59 11198 8192000000 10909344016 11355488256 1975430880 19.429 100 41 81 0 2009767104 21871760 12464464
20:34:16 6469 8192000000 10930923232 11359481856 1980382608 19.468 100 54 108 0 2019351440 22881472 16087360
20:34:29 10097 8192000000 10925226800 11363487744 1982145792 19.482 100 53 104 2 2022817120 24699344 15971984
20:34:49 7325 8192000000 10928211856 11364102144 1981472288 19.476 100 46 90 4 2019937856 25046976 13418592
20:35:07 11017 8192000000 10932847664 11371339776 1989042064 19.536 100 50 101 2 2029910000 25590608 15277328
20:35:29 19242 8192000000 10949707680 11374288896 1986080736 19.513 100 44 88 2 2026119168 26260560 13777872
20:36:00 11393 8192000000 10952635344 11383193600 1995964560 19.591 100 54 108 0 2038781248 27168624 15648064
20:36:19 9305 8192000000 10956572144 11385053184 1995224416 19.585 100 61 121 1 2042075152 28113152 18737584
20:36:41 11196 8192000000 10951458304 11392851968 2003487904 19.650 100 54 106 1 2049141392 29706096 15947392
20:37:19 11999 8192000000 10965062720 11396272128 2009031568 19.694 100 62 124 1 2055120496 28180528 17908400
20:37:41 8221 8192000000 10978393200 11396902912 2009311840 19.696 100 77 152 2 2061517056 29353552 22851664
20:38:01 2547 8192000000 10982021920 11404091392 2015412000 19.744 100 78 156 0 2070668320 31440736 23815584
20:38:10 1608 8192000000 10986205360 11397611520 2009536864 19.698 100 89 176 2 2067896352 31876336 26483152
20:38:19 4205 8192000000 10966840048 11391045632 1989180432 19.537 99 76 150 1 2043800000 31470592 23148976
20:38:31 8597 8192000000 10985438320 11398840320 2008031968 19.686 100 73 143 1 2058302224 29322016 20948240
20:38:48 3885 8192000000 10986264416 11405221888 2014168832 19.734 100 68 136 1 2066563952 31242288 21152832
20:39:05 2480 8192000000 11000227456 11417370624 2025832448 19.826 100 83 164 2 2081999360 31739152 24427760
20:39:17 3599 8192000000 11004160032 11426340864 2031265456 19.869 100 80 161 1 2088745488 34263456 23216576
20:39:30 6085 8192000000 10999695712 11425062912 2025964496 19.827 100 74 147 1 2081835184 34007920 21862768
20:39:43 2380 8192000000 11007285216 11430645760 2030432752 19.862 100 75 147 0 2089018208 35790672 22794784
20:39:53 1974 8192000000 11013537088 11431567360 2038119632 19.922 100 85 166 1 2097400688 35170720 24110336
20:40:02 6283 8192000000 11009821008 11436236800 2037751616 19.919 100 78 156 1 2099013552 37714032 23547904
20:40:20 8748 8192000000 11014766384 11440939008 2032317152 19.877 100 68 133 2 2093589136 41526256 19745728
20:40:39 2475 8192000000 11009352624 11430969344 2029356800 19.854 100 79 157 1 2092513328 38326640 24829888
20:40:48 3380 8192000000 10984724736 11407757312 2003864400 19.653 99 74 145 0 2065663408 39477488 22321520
20:41:03 2553 8192000000 10987912208 11410841600 2013503968 19.729 100 77 154 0 2074093040 37257232 23331840
20:41:13 5849 8192000000 10976341888 11406835712 2005801248 19.668 100 67 134 0 2064661456 37638704 21221504
20:41:25 5460 8192000000 10986634336 11419193344 2016445984 19.752 100 66 132 0 2076311296 38622640 21242672
20:41:40 4944 8192000000 10993379904 11426299904 2020028176 19.780 100 62 124 2 2078947632 39653552 19265904
20:41:53 3447 8192000000 11001307056 11420905472 2018739712 19.770 100 63 125 0 2077076736 38212176 20124848
20:42:05 2588 8192000000 10997970208 11414822912 2010011152 19.702 100 86 171 0 2076253264 40261696 25980416
20:42:15 1709 8192000000 10978905808 11392995328 1989479504 19.540 99 90 180 2 2061029424 43239552 28310368
20:42:26 4823 8192000000 10998272608 11413037056 2004510272 19.658 100 84 169 1 2073770912 42893264 26367376
20:42:38 3390 8192000000 10981181168 11408834560 2009032432 19.694 100 78 159 2 2073018832 39950288 24036112
20:42:50 5371 8192000000 10990790416 11410407424 1994708352 19.581 99 73 146 0 2058164352 40407200 23048800
20:43:04 3205 8192000000 10983253840 11397226496 1998000352 19.607 100 67 133 2 2059321424 40627856 20693216
20:43:14 5141 8192000000 11007810976 11421028352 2016175088 19.750 100 76 151 1 2081910880 41806288 23929504
20:43:26 7145 8192000000 10992845824 11420426240 2011338688 19.712 100 74 147 1 2078526352 43317136 23870528
20:43:40 7946 8192000000 10976446080 11408277504 1984664016 19.502 99 67 133 1 2050606288 44285152 21657120
20:43:56 3755 8192000000 10984462064 11410022400 1997503424 19.603 100 69 136 1 2066710192 47643840 21562928
20:44:08 4438 8192000000 11000435744 11419541504 1997374656 19.602 100 83 166 1 2072539856 49201296 25963904
20:44:20 3080 8192000000 10986962432 11402547200 1989811328 19.542 100 80 159 1 2063247664 48150096 25286240
20:44:29 2477 8192000000 10989209056 11410571264 1996324512 19.594 100 81 162 1 2069856992 47829168 25703312
20:44:38 5391 8192000000 10992641584 11421175808 2008023024 19.686 100 87 173 1 2078457456 43320384 27114048
20:44:51 2897 8192000000 10973917024 11393581056 1990245328 19.546 99 78 156 2 2057796384 42135696 25415360
20:45:00 2573 8192000000 10967790528 11394031616 1985860336 19.511 100 67 133 0 2049335232 41837744 21637152
20:45:16 9348 8192000000 10948322288 11393855488 1981282832 19.475 100 48 96 1 2040153392 43326528 15544032
20:45:34 9337 8192000000 10956363568 11394510848 1983574368 19.493 100 42 83 1 2042040624 44539488 13926768
20:45:50 7652 8192000000 10944301312 11386032128 1966774816 19.360 100 45 88 0 2028676896 46627008 15275072
20:46:04 2860 8192000000 10937911504 11374596096 1958126384 19.291 100 45 89 1 2020825552 47696976 15002192
20:46:16 4765 8192000000 10946866720 11384516608 1966955152 19.361 100 53 106 0 2032350000 47645024 17749824
20:46:29 2332 8192000000 10956964480 11390943232 1971930256 19.401 100 73 143 0 2046680784 50373888 24376640
20:46:40 3248 8192000000 10961177488 11387166720 1974395184 19.420 100 75 148 1 2045489856 47715264 23379408
20:46:54 5892 8192000000 10965704208 11395379200 1974644944 19.422 100 69 138 0 2048357008 50671360 23040704
20:47:07 8634 8192000000 10956894720 11393056768 1970207072 19.387 100 66 132 2 2050885104 58893552 21784480
20:47:22 2211 8192000000 10964405520 11385815040 1940146064 19.148 98 73 148 0 2019805984 55796448 23863472
20:47:32 1643 8192000000 10951591472 11377659904 1953824784 19.257 100 75 148 0 2034790368 56308992 24656592
20:47:44 12576 8192000000 10912486048 11344191488 1912592464 18.927 98 38 76 0 1969844592 43075584 14176544
20:48:15 17960 8192000000 10899911024 11340226560 1897618016 18.807 98 39 78 1 1952311616 41328480 13365120
20:48:42 9502 8192000000 10890457792 11338002432 1929908352 19.066 100 24 48 0 1975257984 35965904 9383728
20:49:19 25391 8192000000 10848232432 11302285312 1887426656 18.725 98 28 54 1 1932817872 36174992 9216224
20:49:51 19809 8192000000 10864167008 11320119296 1901997472 18.842 99 24 48 0 1938499856 28923504 7578880
20:50:53 7064 8192000000 10896148496 11328086016 1927177168 19.044 100 41 82 1 1972838752 32474224 13187360
20:51:09 15222 8192000000 10909613536 11346620416 1934697168 19.104 100 28 57 2 1979584912 35600800 9286944
20:51:49 11520 8192000000 10895050464 11355058176 1935121424 19.108 100 28 56 1 1986985328 42353248 9510656
20:52:07 12310 8192000000 10890418080 11333197824 1923074576 19.011 99 23 46 1 1955924160 25344352 7505232
20:52:29 17601 8192000000 10891390592 11333615616 1919237760 18.981 99 33 66 0 1962438192 32380208 10820224
20:53:00 13513 8192000000 10893894048 11355877376 1939024432 19.139 100 21 42 2 1976996448 30856256 7115760
20:53:22 18205 8192000000 10871470800 11326742528 1929653392 19.064 99 22 44 5 1962764384 25939472 7171520
20:53:46 14646 8192000000 10875497632 11331694592 1925169008 19.028 100 15 30 0 1958375808 27359456 5847344
20:54:07 11290 8192000000 10895583856 11343441920 1932493280 19.087 100 26 51 1 1971647456 29979824 9174352
20:54:39 18777 8192000000 10864546256 11323228160 1913576080 18.935 100 22 44 1 1951257712 29731824 7949808
20:55:11 22823 8192000000 10868508992 11337256960 1903373184 18.853 99 17 34 1 1943234016 33503680 6357152
20:56:22 80470 8192000000 10881732784 11326619648 1921314240 18.997 99 12 21 2 1941217856 17621152 2282464
20:57:51 85793 8192000000 10861426816 11320717312 1848252752 18.408 95 7 14 0 1862051456 12263328 1535376
21:00:05 25451 8192000000 10892379920 11333763072 1934559328 19.103 99 35 71 1 1951939728 7906192 9474208
21:00:37 115741 8192000000 10916752032 11362336768 1962810160 19.328 100 44 88 2 1985262208 9350368 13101680
21:02:42 102572 8192000000 10901407392 11376111616 1970962016 19.393 100 18 36 1 1993265296 16929232 5374048
21:04:40 27954 8192000000 10853582912 11321815040 1928214480 19.053 99 12 24 4 1945775056 14006816 3553760
21:05:15 12812 8192000000 10865058048 11326947328 1925601584 19.032 99 23 46 2 1939902128 7604416 6696128
21:05:34 49674 8192000000 10892801328 11359940608 1959300048 19.300 100 22 44 1 1975021824 9559712 6162064
21:06:33 14510 8192000000 10923664336 11368357888 1980009120 19.465 100 54 110 1 2006732416 10087392 16635904
21:06:55 61589 8192000000 10896769216 11373109248 1960452768 19.310 99 32 64 2 1985333600 14988272 9892560
21:08:03 66778 8192000000 10892901232 11384950784 1966572480 19.358 100 6 12 0 1984934432 16598160 1763792
21:09:45 182898 8192000000 10922092192 11392425984 1978115328 19.450 100 27 52 0 1993703728 8399648 7188752
21:13:52 54123 8192000000 10888360176 11373649920 1939941728 19.146 98 23 45 2 1959833872 12910688 6981456
21:14:53 57716 8192000000 10904453728 11380670464 1974529008 19.421 100 18 36 0 1990815872 11085296 5201568
21:15:57 39497 8192000000 10919229936 11391221760 1983625376 19.493 100 17 34 0 1999348720 11133632 4589712
21:16:56 53756 8192000000 10899347392 11379503104 1970797936 19.392 99 36 70 2 1999393472 18305920 10289616
21:17:57 81538 8192000000 10903357648 11391692800 1967793088 19.368 99 18 36 0 1989796656 16194384 5809184
21:19:36 42348 8192000000 10902239920 11393323008 1977383328 19.444 100 9 18 2 1999583584 19649664 2550592
21:20:31 45458 8192000000 10914717968 11385667584 1988087296 19.529 100 24 48 0 2006417776 11655120 6675360
21:21:24 24764 8192000000 10914244704 11376177152 1949092752 19.219 98 25 50 1 1966775728 10503184 7179792
21:21:58 33703 8192000000 10907712000 11378315264 1925399488 19.030 97 26 52 0 1944326112 11946016 6980608
21:22:38 54724 8192000000 10901144736 11360550912 1931541616 19.079 98 9 17 2 1946499200 12639760 2317824
21:23:58 51439 8192000000 10929727072 11395080192 1983992240 19.496 100 24 48 0 2002712608 12133632 6586736
21:24:55 22745 8192000000 10910568272 11379798016 1949740064 19.224 98 16 32 0 1967490736 12675952 5074720
21:25:29 62808 8192000000 10910329504 11377963008 1944489424 19.183 98 19 38 1 1964494240 14782128 5222688
21:26:43 15739 8192000000 10930634064 11387621376 1989355664 19.539 100 51 102 3 2013925680 10325872 14244144
21:27:05 47317 8192000000 10899283008 11363106816 1931521248 19.079 97 30 60 2 1953525856 13912960 8091648
21:27:59 72246 8192000000 10883047920 11365904384 1890726512 18.752 96 13 26 1 1909069520 14798480 3544528
21:29:17 81414 8192000000 10886086800 11349135360 1910109600 18.908 97 20 40 0 1924334576 8912672 5312304
21:30:50 100476 8192000000 10891089456 11363815424 1898454512 18.814 97 13 26 1 1917896720 16042032 3400176
21:32:42 124622 8192000000 10836240624 11285471232 1840404544 18.344 94 18 36 2 1860955968 15222400 5329024
21:34:52 89566 8192000000 10847888512 11324510208 1872256592 18.603 96 24 48 1 1891401520 12398432 6746496
21:36:29 25998 8192000000 10837825472 11307843584 1889142816 18.739 98 15 30 0 1901294272 8165536 3985920
21:37:12 62915 8192000000 10798789616 11267248128 1790071904 17.932 93 18 36 0 1801765824 6564704 5129216
21:38:21 51519 8192000000 10800118992 11272294400 1843575312 18.370 97 7 14 1 1852484544 6797952 2111280
21:39:18 79192 8192000000 10838625760 11287461888 1871478912 18.596 98 15 29 1 1885230544 9044864 4706768
21:40:46 79235 8192000000 10833868480 11311751168 1885528448 18.710 98 14 28 2 1897813552 8503984 3781120
21:42:42 53126 8192000000 10828814128 11309502464 1877892992 18.648 98 5 10 0 1891278864 12037040 1348832
21:43:41 13379 8192000000 10808518320 11272671232 1840166240 18.342 96 24 46 2 1854400928 7584688 6650000
21:44:01 24322 8192000000 10827670736 11275841536 1853172400 18.448 98 33 66 1 1871139008 8507088 9459520
21:44:34 15312 8192000000 10834216336 11291512832 1901732928 18.840 100 46 92 2 1924901824 10638096 12530800
21:44:58 52354 8192000000 10839470304 11308269568 1888690272 18.735 99 19 38 1 1903177936 9209856 5277808
21:45:56 24970 8192000000 10840303568 11306307584 1898246144 18.812 99 19 38 1 1916366368 12505136 5615088
21:46:34 60763 8192000000 10859322064 11311669248 1879667488 18.662 98 26 52 1 1898645264 11855904 7121872
21:47:50 47673 8192000000 10856382544 11320258560 1905367360 18.869 99 25 50 3 1926489296 13990272 7131664
21:48:50 69783 8192000000 10868942128 11340595200 1930975392 19.075 100 28 56 0 1960171584 21105328 8090864
21:50:17 101173 8192000000 10858629392 11337580544 1882791424 18.688 97 20 40 1 1899097904 10834112 5472368
21:52:15 77232 8192000000 10861225200 11347165184 1906359632 18.877 98 7 14 1 1923893904 15792464 1741808
21:53:43 178093 8192000000 10882245600 11352969216 1884460448 18.701 97 17 33 1 1904050880 14293920 5296512
21:57:11 69611 8192000000 10876867680 11349196800 1943450256 19.174 99 19 38 3 1958529792 9964800 5114736
21:58:26 21753 8192000000 10889079856 11352993792 1925485792 19.031 98 32 64 1 1945440160 11161776 8792592
21:59:05 63342 8192000000 10875902560 11364073472 1953155920 19.252 100 17 34 1 1972305664 14208480 4941264
22:00:15 39127 8192000000 10882347888 11363971072 1952419184 19.246 100 9 18 2 1972472000 17365872 2686944
22:01:06 33501 8192000000 10872552224 11364114432 1939448448 19.142 99 10 20 0 1952571824 10605312 2518064
22:01:48 48086 8192000000 10878166112 11358838784 1948393808 19.214 99 19 38 1 1962209536 7724976 6090752
22:02:43 35208 8192000000 10917397008 11382550528 1977771008 19.447 100 19 36 3 1989230288 6425552 5033728
22:03:27 30698 8192000000 10918656208 11385229312 1983005040 19.488 100 40 78 2 2005638192 10953232 11679920
22:04:11 56692 8192000000 10933041584 11409125376 1987865376 19.527 100 15 30 0 2004676080 12853168 3957536
22:05:13 95715 8192000000 10930725936 11417436160 1991650176 19.557 100 13 26 0 2015764880 20147184 3967520
22:07:09 142518 8192000000 10920805568 11403100160 1898441424 18.814 95 12 24 0 1917180688 16403104 2336160
22:09:38 65004 8192000000 10928609552 11397263360 1957608528 19.287 98 19 38 1 1973415184 10348176 5458480
22:10:55 69080 8192000000 10905237312 11364601856 1873918048 18.616 94 24 48 2 1890600576 10037424 6645104
22:12:11 36189 8192000000 10901233264 11374145536 1950472256 19.230 99 22 45 1 1967682256 11010816 6199184
22:12:53 41030 8192000000 10922022464 11384287232 1947179664 19.204 98 30 60 2 1965124176 9728832 8215680
22:13:44 52041 8192000000 10892552512 11381645312 1938548336 19.135 98 10 20 1 1955156720 13876352 2732032
22:14:48 97458 8192000000 10896778496 11391045632 1950885392 19.234 99 7 14 0 1964676992 12027664 1763936
22:17:14 86310 8192000000 10879708288 11348815872 1872320288 18.603 95 21 42 3 1885722880 6992256 6410336
22:18:56 15727 8192000000 10876465072 11339456512 1943164064 19.172 100 50 99 1 1966456800 9660608 13632128
22:19:25 46744 8192000000 10844890560 11330781184 1916570384 18.959 98 34 68 1 1935638736 9865936 9202416
22:20:25 57618 8192000000 10843124544 11324592128 1884773360 18.704 97 4 8 0 1895099376 9195168 1130848
22:21:29 58727 8192000000 10822252528 11308560384 1836555536 18.313 95 12 24 1 1851608672 11210272 3842864
22:22:34 51552 8192000000 10843746928 11334021120 1919812240 18.985 100 9 18 0 1933819728 11310512 2696976
22:23:40 79468 8192000000 10859105552 11337015296 1920424272 18.990 99 16 32 1 1932449664 7524016 4501376
22:25:15 49584 8192000000 10840925792 11328831488 1859361952 18.498 96 17 34 0 1875347408 11551856 4433600
22:26:25 37135 8192000000 10854356048 11323621376 1896199408 18.796 98 17 34 1 1907696800 6850096 4647296
22:27:12 16662 8192000000 8968947648 9296326656 83524608 1.009 5 1 2 0 84043168 456432 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 22-02-2021 22:28:56 to 22-02-2021 22:29:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 88 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

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          241546
MON$OLDEST_ACTIVE               241547
MON$OLDEST_SNAPSHOT             241547
MON$NEXT_TRANSACTION            241547
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                       2033440
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

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