Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.03.2021 16:33
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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 17427076 kB
MemAvailable 31570752 kB
Buffers 0 kB
Cached 14270824 kB
SwapCached 0 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-03-19 16:32:38
DTS_END                         2021-03-19 16:32:38.0360
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/38954
TRN_ID                          240184
ATT_ID                          648
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: 9133.08 22192 1095970
customer order: creation 175.13 343 21016
customer order: refuse 14.66 330 1759
order to supplier: creation 46.45 1279 5574
order to supplier: removal 3.44 112940 413
invoice (draft): creation 46.69 3455 5603
invoice (draft): removal 51.74 934 6209
invoice accept: apply 41.46 18416 4975
invoice accept: cancel 45.64 891 5477
customer reserve: creation 3882.46 179 465895
customer reserve: removal 4532.70 66 543924
realization accept: apply 82.23 189 9867
realization accept: cancel 78.53 126 9423
payment from customer: creation 60.13 138 7216
payment from customer: removal 6.18 75 742
payment to supplier: creation 50.31 168 6037
payment to supplier: removal 3.48 84 417
service: total inventory turnovers 4.98 1124 598
service: total monetary turnovers 6.14 61 737
service: aggregate perf. data 0.70 28111 84
service: refresh index statistics 0.03 274921 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-03-2021 16:34:19 to 19-03-2021 16:34:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2238
TEST_TIME 2 2068
TEST_TIME 3 1628
TEST_TIME 4 1862
TEST_TIME 5 2300
TEST_TIME 6 2980
TEST_TIME 7 3112
TEST_TIME 8 3659
TEST_TIME 9 3756
TEST_TIME 10 4142
TEST_TIME 11 4571
TEST_TIME 12 4628
TEST_TIME 13 4656
TEST_TIME 14 4746
TEST_TIME 15 4728
TEST_TIME 16 4996
TEST_TIME 17 5159
TEST_TIME 18 5315
TEST_TIME 19 5346
TEST_TIME 20 5462
TEST_TIME 21 5620
TEST_TIME 22 5934
TEST_TIME 23 6558
TEST_TIME 24 6643
TEST_TIME 25 6771
TEST_TIME 26 7068
TEST_TIME 27 7314
TEST_TIME 28 7665
TEST_TIME 29 8480
TEST_TIME 30 8936
TEST_TIME 31 9287
TEST_TIME 32 9880
TEST_TIME 33 9722
TEST_TIME 34 9873
TEST_TIME 35 9974
TEST_TIME 36 9778
TEST_TIME 37 9695
TEST_TIME 38 9624
TEST_TIME 39 9486
TEST_TIME 40 9518
TEST_TIME 41 9666
TEST_TIME 42 9615
TEST_TIME 43 9557
TEST_TIME 44 9482
TEST_TIME 45 9278
TEST_TIME 46 9262
TEST_TIME 47 9237
TEST_TIME 48 9177
TEST_TIME 49 9266
TEST_TIME 50 9214
TEST_TIME 51 9166
TEST_TIME 52 9221
TEST_TIME 53 9208
TEST_TIME 54 9161
TEST_TIME 55 9094
TEST_TIME 56 9086
TEST_TIME 57 9021
TEST_TIME 58 8975
TEST_TIME 59 8967
TEST_TIME 60 8950
TEST_TIME 61 8862
TEST_TIME 62 8905
TEST_TIME 63 8887
TEST_TIME 64 8914
TEST_TIME 65 8982
TEST_TIME 66 8944
TEST_TIME 67 9081
TEST_TIME 68 9069
TEST_TIME 69 9070
TEST_TIME 70 9105
TEST_TIME 71 9180
TEST_TIME 72 9137
TEST_TIME 73 9186
TEST_TIME 74 9210
TEST_TIME 75 9224
TEST_TIME 76 9157
TEST_TIME 77 9150
TEST_TIME 78 9123
TEST_TIME 79 9095
TEST_TIME 80 9105
TEST_TIME 81 9058
TEST_TIME 82 9019
TEST_TIME 83 9019
TEST_TIME 84 9140
TEST_TIME 85 9117
TEST_TIME 86 9127
TEST_TIME 87 9102
TEST_TIME 88 9173
TEST_TIME 89 9160
TEST_TIME 90 9247
TEST_TIME 91 9230
TEST_TIME 92 9258
TEST_TIME 93 9294
TEST_TIME 94 9315
TEST_TIME 95 9410
TEST_TIME 96 9322
TEST_TIME 97 9269
TEST_TIME 98 9257
TEST_TIME 99 9244
TEST_TIME 100 9199
TEST_TIME 101 9149
TEST_TIME 102 9098
TEST_TIME 103 9063
TEST_TIME 104 9088
TEST_TIME 105 9123
TEST_TIME 106 9099
TEST_TIME 107 9151
TEST_TIME 108 9131
TEST_TIME 109 9155
TEST_TIME 110 9145
TEST_TIME 111 9234
TEST_TIME 112 9227
TEST_TIME 113 9273
TEST_TIME 114 9256
TEST_TIME 115 9274
TEST_TIME 116 9235
TEST_TIME 117 9316
TEST_TIME 118 9259
TEST_TIME 119 9192
TEST_TIME 120 9137

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-03-2021 16:34:23 to 19-03-2021 16:34:26.

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 1527348 1527348 0 0.00 0 27766 7 0 0
doc_list_biud 1527348 1527348 0 0.00 0 43822 30 0 0
sp_add_invoice_to_stock 5058 4975 83 1.64 48 188230 18417 0 83
sp_cancel_adding_invoice 5477 5477 0 0.00 3 89622 891 0 0
sp_cancel_client_order 1759 1759 0 0.00 4 12357 330 0 0
sp_cancel_customer_reserve 543924 543924 0 0.00 1 30406 67 0 0
sp_cancel_pay_from_customer 742 742 0 0.00 3 6791 76 0 0
sp_cancel_pay_to_supplier 417 417 0 0.00 3 5278 84 0 0
sp_cancel_supplier_invoice 6214 6209 5 0.08 1 18336 934 0 5
sp_cancel_supplier_order 413 413 0 0.00 9 1378588 112940 0 0
sp_cancel_write_off 9423 9423 0 0.00 1 18931 127 0 0
sp_client_order 21016 21016 0 0.00 3 24485 344 0 0
sp_customer_reserve 465895 465895 0 0.00 0 131293 180 0 0
sp_fill_shopping_cart 32191 32191 0 0.00 1 11755 38 0 0
sp_fill_shopping_cart_clo_res 465891 465891 0 0.00 0 27710 13 0 0
sp_get_clo_for_invoice 4969 4969 0 0.00 0 29349 303 0 0
sp_kill_cost_storno 16059 16059 0 0.00 0 10455 68 0 0
sp_kill_qstorno_ret_qs2qd 1103893 1103893 0 0.00 0 30403 36 0 0
sp_kill_qty_storno 582041 582041 0 0.00 0 43821 78 0 0
sp_lock_selected_doc 20795 20795 0 0.00 0 7473 5 0 0
sp_make_cost_storno 28089 28089 0 0.00 0 27749 65 0 0
sp_multiply_rows_for_pdistr 28089 28089 0 0.00 0 26329 34 0 0
sp_multiply_rows_for_qdistr 21016 21016 0 0.00 0 14897 166 0 0
sp_pay_from_customer 7216 7216 0 0.00 4 26088 138 0 0
sp_pay_to_supplier 6037 6037 0 0.00 5 36080 168 0 0
sp_payment_common 13253 13253 0 0.00 1 25927 56 0 0
sp_qd_handle_on_cancel_clo 1759 1759 0 0.00 0 12348 303 0 0
sp_qd_handle_on_invoice_upd_sts 10446 10446 0 0.00 0 43820 363 0 0
sp_qd_handle_on_reserve_upd_sts 9867 9867 0 0.00 0 13917 50 0 0
sp_reserve_write_off 9867 9867 0 0.00 6 24444 189 0 0
sp_supplier_invoice 5603 5603 0 0.00 6 86318 3455 0 0
sp_supplier_order 5574 5574 0 0.00 5 46732 1280 0 0
srv_aggregate_perf_data 85 84 1 1.17 2062 633706 28111 0 1
srv_fill_mon_cache_memory 162 162 0 0.00 1382 165972 33155 0 0
srv_find_qd_qs_mism 1047491 1047491 0 0.00 0 16838 5 0 0
srv_make_invnt_saldo 598 598 0 0.00 35 140717 1125 0 0
srv_make_money_saldo 737 737 0 0.00 1 27739 61 0 0
srv_recalc_idx_stat 4 4 0 0.00 182176 357850 274921 0 0
t$perf-abend:sp_add_invoice_to_stock 83 83 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4975 4975 0 0.00 0 7617 150 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 1 4810 112 0 0
t$perf-norm:sp_cancel_client_order 1759 1759 0 0.00 0 4980 14 0 0
t$perf-norm:sp_cancel_customer_reserve 716 716 0 0.00 0 2832 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 742 742 0 0.00 0 1428 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 417 417 0 0.00 0 3689 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 428 428 0 0.00 0 2587 23 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 30061 1618 0 0
t$perf-norm:sp_cancel_write_off 1068 1068 0 0.00 0 1379 5 0 0
t$perf-norm:sp_client_order 21016 21016 0 0.00 0 22334 18 0 0
t$perf-norm:sp_customer_reserve 958 958 0 0.00 0 4527 13 0 0
t$perf-norm:sp_pay_from_customer 7216 7216 0 0.00 0 6722 9 0 0
t$perf-norm:sp_pay_to_supplier 6037 6037 0 0.00 0 11782 11 0 0
t$perf-norm:sp_reserve_write_off 9867 9867 0 0.00 0 11789 12 0 0
t$perf-norm:sp_supplier_invoice 5603 5603 0 0.00 0 21038 22 0 0
t$perf-norm:sp_supplier_order 5574 5574 0 0.00 0 4884 17 0 0
t$perf-norm:srv_aggregate_perf_data 84 84 0 0.00 0 123 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 701 13 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 7182 41 0 0
t$perf-norm:srv_make_money_saldo 737 737 0 0.00 0 1316 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10104 9938 166 1.64 0 9714 17 0 166
v_all_customers 38602 38602 0 0.00 0 15 1 0 0
v_all_suppliers 31332 31332 0 0.00 0 40 1 0 0
v_all_wares 42032 42032 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 398 6 0 0
v_cancel_client_order 3518 3518 0 0.00 0 4189 5 0 0
v_cancel_customer_prepayment 1484 1484 0 0.00 0 2519 6 0 0
v_cancel_customer_reserve 1432 1432 0 0.00 0 2163 6 0 0
v_cancel_payment_to_supplier 834 834 0 0.00 0 1119 3 0 0
v_cancel_supplier_invoice 866 856 10 1.15 0 753 14 0 10
v_cancel_supplier_order 826 826 0 0.00 0 2632 8 0 0
v_cancel_write_off 2136 2136 0 0.00 0 9736 19 0 0
v_max_id_clo_ord 5574 5574 0 0.00 0 268 1 0 0
v_max_id_clo_res 958 958 0 0.00 0 3865 14 0 0
v_max_id_ord_sup 5601 5601 0 0.00 0 2868 3 0 0
v_max_non_paid_invoice 1546 1546 0 0.00 0 267 2 0 0
v_max_non_paid_realizn 3778 3778 0 0.00 0 1730 5 0 0
v_min_id_clo_ord 5574 5574 0 0.00 0 5490 13 0 0
v_min_id_clo_res 958 958 0 0.00 0 6241 15 0 0
v_min_id_ord_sup 5601 5601 0 0.00 0 5347 4 0 0
v_min_non_paid_invoice 6037 6037 0 0.00 0 23020 41 0 0
v_min_non_paid_realizn 7216 7216 0 0.00 0 25923 46 0 0
v_our_firm 10306 10306 0 0.00 0 15 1 0 0
v_reserve_write_off 19734 19734 0 0.00 0 10029 7 0 0
x_lock_depdocs_on_canc_invoice 11258 11258 0 0.00 0 23514 128 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 4574 374 0 0
x_make_qstorno_1000_1200 5574 5574 0 0.00 1 46721 1195 0 0
x_make_qstorno_1200_2000 5603 5603 0 0.00 3 86298 3316 0 0
x_make_qstorno_2100_3300 465895 465895 0 0.00 0 131292 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-03-2021 16:34:27 to 19-03-2021 16:34:31.

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
14:02:41 5 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:47 7743 8192000000 10123503856 10413993984 888892272 9.788 72 56 121 0 910235536 2331088 19012176
14:03:03 28208 8192000000 10319192896 10634297344 1354759760 14.190 100 71 142 0 1381851104 4020800 23070544
14:03:40 27127 8192000000 10389278640 10712629248 1434213120 14.899 100 86 172 0 1467297280 5859328 27224832
14:04:19 30674 8192000000 10422636800 10753515520 1476113008 15.267 100 90 180 0 1512612672 7255600 29244064
14:04:59 23415 8192000000 10452865216 10785968128 1505778144 15.527 100 90 180 0 1542968624 8524256 28666224
14:05:35 20562 8192000000 10465044336 10801844224 1517714480 15.630 100 90 180 0 1555946080 9441088 28790512
14:06:08 2415 8192000000 10469920560 10807808000 1526356512 15.705 100 91 181 1 1564913024 10108384 28448128
14:06:23 20220 8192000000 10477940320 10821988352 1532824672 15.761 100 86 172 2 1570244832 10394000 27026160
14:06:53 16124 8192000000 10506595216 10847080448 1553526448 15.940 100 84 168 1 1589939072 10471408 25941216
14:07:23 14442 8192000000 10518305552 10868482048 1580414320 16.172 100 89 178 0 1618485600 10919680 27151600
14:07:48 15577 8192000000 10545011264 10898706432 1597105536 16.315 100 79 158 3 1632365216 10797936 24461744
14:08:11 18153 8192000000 10572072656 10930147328 1623004512 16.535 100 81 162 0 1659180112 11652320 24523280
14:08:40 15479 8192000000 10593237024 10951864320 1643976464 16.713 100 83 166 0 1680892912 12370016 24546432
14:09:04 13573 8192000000 10602813104 10969694208 1659036080 16.841 100 80 160 0 1695830288 12721856 24072352
14:09:31 9794 8192000000 10628212896 10995445760 1684016912 17.051 100 86 172 1 1722684016 12844960 25822144
14:09:49 11144 8192000000 10632710288 11005808640 1698538224 17.173 100 80 160 0 1735729280 13679408 23511648
14:10:10 9279 8192000000 10655145328 11025641472 1711177472 17.279 100 81 162 0 1748627792 13674752 23775568
14:10:26 10417 8192000000 10668940928 11043766272 1724145344 17.387 100 76 152 1 1757916560 11657408 22113808
14:10:43 4633 8192000000 10666656736 11047776256 1733080432 17.461 100 71 142 1 1766058544 12474544 20503568
14:10:56 5245 8192000000 10686700784 11067363328 1749538000 17.598 100 70 140 1 1781128608 11883072 19707536
14:11:08 5289 8192000000 10696567328 11074318336 1762109680 17.702 100 81 161 2 1797348048 12268352 22970016
14:11:20 6502 8192000000 10705270032 11084787712 1770589136 17.772 100 85 170 2 1812401584 17839456 23972992
14:11:34 3183 8192000000 10719015904 11094061056 1778331360 17.836 100 84 169 1 1815419728 12980992 24107376
14:11:43 3474 8192000000 10717061744 11103035392 1784308592 17.885 100 78 153 1 1818886432 12549664 22028176
14:11:55 3999 8192000000 10737904368 11121319936 1799633296 18.011 100 85 170 0 1837186544 12705264 24847984
14:12:06 3585 8192000000 10746710736 11130335232 1806111120 18.064 100 86 171 1 1843400896 13034208 24255568
14:12:17 4009 8192000000 10751364240 11133804544 1809667312 18.093 100 88 170 4 1847157632 13547824 23942496
14:12:28 7693 8192000000 10756164016 11141423104 1816483152 18.149 100 85 169 3 1852139344 12728176 22928016
14:12:43 3168 8192000000 10747498816 11137810432 1820689056 18.183 100 87 172 1 1857902368 13849168 23364144
14:12:55 2294 8192000000 10769531632 11158765568 1832062960 18.276 100 82 164 0 1868814096 13185888 23565248
14:13:04 3455 8192000000 10784776464 11167952896 1840579136 18.346 100 89 177 2 1880203488 14239456 25384896
14:13:14 2236 8192000000 10789969088 11174711296 1843882656 18.372 100 88 173 1 1882000272 15006048 23111568
14:13:22 1838 8192000000 10786733168 11175174144 1844547456 18.378 100 91 181 1 1885781920 15534416 25700048
14:13:31 1707 8192000000 10796589312 11183960064 1853652032 18.452 100 88 174 1 1891854592 13624704 24577856
14:13:40 3388 8192000000 10798584576 11188215808 1855814992 18.469 100 91 182 1 1895087136 13409360 25862784
14:13:49 1938 8192000000 10801569344 11190329344 1861705904 18.517 100 90 180 2 1900500768 13357728 25437136
14:13:58 1599 8192000000 10808668944 11194454016 1866987104 18.560 100 94 188 0 1906857008 13397312 26472592
14:14:05 1226 8192000000 10812566896 11201835008 1870229344 18.586 100 89 178 1 1907688480 13149776 24309360
14:14:13 1739 8192000000 10816563920 11206221824 1870097968 18.585 100 84 168 0 1909163280 14834592 24230720
14:14:21 3929 8192000000 10825535792 11214372864 1877217936 18.643 100 92 184 1 1918233648 14606080 26409632
14:14:31 1475 8192000000 10822897440 11212390400 1876846624 18.640 100 92 180 0 1916754240 13141488 26766128
14:14:39 2698 8192000000 10803365776 11212386304 1874857520 18.624 100 66 132 1 1905722816 12401568 18463728
14:15:00 33880 8192000000 10799514416 11208970240 1873645152 18.614 100 43 84 1 1892789696 6385696 12758848
14:15:41 20421 8192000000 10780102880 11209199616 1872538848 18.605 100 24 48 1 1885258576 5747952 6971776
14:16:09 6486 8192000000 10775671616 11209781248 1871767024 18.599 100 19 37 1 1882864368 5883536 5213808
14:16:27 6148 8192000000 10789663984 11217203200 1878409984 18.652 100 35 70 2 1896589232 8412816 9766432
14:16:41 6301 8192000000 10792465280 11217354752 1880385904 18.668 100 28 56 1 1895759616 7017616 8356096
14:16:55 5796 8192000000 10786430224 11223441408 1881321264 18.676 100 23 46 3 1899311680 12059184 5931232
14:17:09 6292 8192000000 10807039632 11225690112 1883413104 18.693 100 24 48 3 1895614784 5329392 6872288
14:17:24 5360 8192000000 10805681648 11233538048 1887390208 18.725 100 31 63 0 1907548272 11230448 8927616
14:17:35 11390 8192000000 10793745136 11224788992 1885239360 18.707 100 18 36 1 1896277008 6059120 4978528
14:17:53 7500 8192000000 10798024624 11230703616 1889833360 18.744 100 20 40 1 1902294624 6722880 5738384
14:18:07 11607 8192000000 10804521056 11238850560 1894578816 18.783 100 18 36 0 1910165024 9856224 5729984
14:18:26 6557 8192000000 10806263760 11237171200 1895355184 18.789 100 14 28 1 1904646880 5301776 3989920
14:18:39 8696 8192000000 10808042688 11242643456 1900148928 18.827 100 19 38 1 1911289824 6010800 5130096
14:18:55 12743 8192000000 10803773520 11244535808 1902354816 18.845 100 23 47 1 1914911264 6094080 6462368
14:19:19 11779 8192000000 10815829744 11248406528 1905527936 18.871 100 24 47 0 1919259584 6235488 7496160
14:19:38 74491 8192000000 10854710208 11264180224 1907376144 18.886 100 35 70 0 1924090560 5752800 10961616
14:20:59 2554 8192000000 10835083344 11264016384 1913155744 18.932 100 49 98 1 1935567040 9290192 13121104
14:21:10 8943 8192000000 10828977456 11259215872 1909640688 18.904 100 31 60 1 1925265840 7154112 8471040
14:21:26 4958 8192000000 10842364112 11263692800 1910923856 18.914 100 38 76 1 1928593136 7244512 10424768
14:21:37 4397 8192000000 10822264848 11255459840 1894969424 18.786 99 40 79 2 1917229104 11496144 10763536
14:21:49 3801 8192000000 10814073984 11250040832 1904376992 18.861 100 29 59 2 1923658608 10862256 8419360
14:22:00 5136 8192000000 10806664768 11239383040 1881893888 18.680 99 30 56 3 1897131024 4788688 10448448
14:22:12 5200 8192000000 10814556960 11249197056 1898530096 18.814 100 34 68 5 1914408144 6743888 9134160
14:22:23 6727 8192000000 10810271360 11246690304 1898865680 18.817 100 18 36 1 1910331360 5836960 5628720
14:22:36 7234 8192000000 10778804336 11217903616 1876113120 18.634 99 16 32 0 1886372448 5730496 4528832
14:22:52 7334 8192000000 10780249744 11215470592 1832818080 18.282 97 19 36 2 1844562912 5805344 5939488
14:23:05 15671 8192000000 10776766416 11209023488 1843883936 18.372 98 19 38 2 1854741936 5637040 5220960
14:23:27 55761 8192000000 10750464800 11182903296 1747414256 17.580 93 28 56 1 1761390320 5938576 8037488
14:24:29 10631 8192000000 10735865088 11153256448 1720219168 17.354 93 20 39 2 1731367136 5692768 5455200
14:24:49 5265 8192000000 10761361488 11182985216 1822169488 18.195 99 33 64 0 1842066064 11380560 8516016
14:25:00 7572 8192000000 10753976480 11175198720 1812382064 18.115 98 24 48 1 1825160592 5811264 6967264
14:25:15 10371 8192000000 10726657536 11148918784 1767486304 17.746 96 13 26 0 1776870512 5762704 3621504
14:25:32 5871 8192000000 10740374000 11160403968 1810596016 18.101 99 24 48 1 1822945680 5105504 7244160
14:25:44 5433 8192000000 10706452960 11130814464 1736436464 17.489 95 18 36 1 1746636400 5099792 5100144
14:25:57 8357 8192000000 10704485440 11111469056 1760591616 17.689 98 16 32 1 1770540496 5267200 4681680
14:26:15 8001 8192000000 10710052848 11117543424 1740081424 17.519 97 29 56 3 1758093344 10220432 7791488
14:26:31 13745 8192000000 10684134768 11101396992 1714257920 17.304 96 15 30 0 1724523280 5572048 4693312
14:26:53 8128 8192000000 10700594576 11110457344 1738555632 17.507 97 36 72 4 1754404480 4948464 10900384
14:27:08 11601 8192000000 10684747600 11093700608 1698907248 17.176 95 24 46 1 1710328144 4859376 6561520
14:27:26 8127 8192000000 10716582944 11129430016 1767341440 17.745 99 22 44 1 1783515968 10371040 5803488
14:27:40 77807 8192000000 10704155536 11116703744 1660112640 16.850 92 19 38 1 1669619376 4304304 5202432
14:29:04 12443 8192000000 10717396480 11138555904 1778736064 17.839 99 23 46 1 1791263184 6600880 5926240
14:29:23 5602 8192000000 10730034400 11145830400 1810267120 18.098 100 33 66 2 1827628368 7206752 10154496
14:29:36 7342 8192000000 10748659024 11162886144 1821167360 18.187 100 33 66 1 1836781904 5787296 9827248
14:29:49 6792 8192000000 10730120400 11155275776 1809235568 18.090 99 24 48 0 1821149344 5127072 6786704
14:30:03 12052 8192000000 10745149936 11173167104 1834748880 18.298 100 21 44 1 1846515520 5849216 5917424
14:30:21 6510 8192000000 10747741264 11177127936 1841340112 18.352 100 28 55 1 1854895088 5472864 8082112
14:30:35 9110 8192000000 10760378240 11184594944 1845449056 18.385 100 14 28 0 1855448704 5709152 4290496
14:30:55 10752 8192000000 10769311344 11187277824 1848910368 18.413 100 21 42 1 1860536256 5248720 6377168
14:31:13 11178 8192000000 10772022416 11198271488 1857010864 18.479 100 26 52 1 1870747776 5982864 7754048
14:31:33 14540 8192000000 10766207920 11200655360 1856456480 18.475 100 15 30 1 1865850400 5284560 4109360
14:31:54 16355 8192000000 10783621936 11214413824 1866151904 18.553 100 12 24 1 1874627664 4904160 3571600
14:32:16 11616 8192000000 10799581440 11225853952 1883493152 18.693 100 8 16 0 1890421104 4936960 1990992
14:32:34 62493 8192000000 10828635584 11249999872 1896107488 18.795 100 26 50 1 1907460128 4169696 7182944
14:33:49 128285 8192000000 10849501248 11277840384 1916568816 18.959 100 30 60 1 1934027040 8708096 8750128
14:36:12 15966 8192000000 10863053568 11284250624 1932647376 19.088 100 54 105 1 1960287936 12283584 15356976
14:36:38 9452 8192000000 10875139216 11298189312 1936945504 19.122 100 53 102 2 1965261968 13107808 15208656
14:37:17 14663 8192000000 10870858576 11298230272 1937504656 19.127 100 43 86 2 1963499664 13819728 12175280
14:38:00 10151 8192000000 10869911584 11304128512 1942226240 19.165 100 34 70 1 1966331872 13322144 10783488
14:38:18 43023 8192000000 10875227152 11317141504 1946296736 19.197 100 32 64 1 1968318896 12241744 9780416
14:39:25 7875 8192000000 10902855120 11327651840 1957334560 19.285 100 43 85 1 1986399760 16411648 12653552
14:39:39 32875 8192000000 10915770480 11345907712 1970619184 19.390 100 47 95 0 2003448144 18420912 14408048
14:40:27 24482 8192000000 10904761392 11340824576 1955897232 19.273 99 48 97 0 1987187376 16335216 14954928
14:41:04 28366 8192000000 10918262816 11356655616 1978664624 19.454 100 39 78 0 2009108752 18569072 11875056
14:41:41 17766 8192000000 10930381952 11363831808 1987558928 19.525 100 37 73 0 2019710240 20629360 11521952
14:42:15 12092 8192000000 10938135184 11376410624 1989036400 19.536 100 49 96 0 2027239072 22682656 15520016
14:42:36 12078 8192000000 10945825248 11385909248 1995854176 19.590 100 51 100 1 2039841824 29032384 14955264
14:42:56 3116 8192000000 10945334560 11372232704 1997099728 19.600 100 65 129 0 2035796416 19508512 19188176
14:43:06 5345 8192000000 10958550384 11381735424 1999164064 19.616 100 74 148 0 2044238352 23085856 21988432
14:43:25 1675 8192000000 10972916240 11387940864 2003585040 19.651 100 79 157 0 2050810256 24268464 22956752
14:43:33 16218 8192000000 10952717520 11385061376 2001621456 19.636 100 58 114 2 2040419664 22004912 16793296
14:44:07 15071 8192000000 10944603296 11385278464 2003992576 19.654 100 40 80 1 2037316928 20637568 12686784
14:44:38 14631 8192000000 10952936448 11393253376 1989647552 19.541 99 40 80 2 2022668400 21075168 11945680
14:45:05 18358 8192000000 10954226560 11388633088 2007456800 19.681 100 45 88 2 2042120368 21563312 13100256
14:45:37 7834 8192000000 10962689056 11396603904 2010632592 19.706 100 51 102 2 2051084928 25194624 15257712
14:45:54 11162 8192000000 10954881136 11391762432 2007593680 19.683 100 54 105 2 2048942560 25207200 16141680
14:46:12 12524 8192000000 10964477088 11398885376 2009848400 19.700 100 51 102 2 2052166800 26587696 15730704
14:46:36 6388 8192000000 10973369040 11405004800 2011242816 19.711 100 60 121 4 2060998032 30619840 19135376
14:46:50 4983 8192000000 10962114720 11393802240 2006010608 19.670 100 58 116 0 2052841424 29320336 17510480
14:47:04 9116 8192000000 10974254880 11406663680 2013776928 19.731 100 58 116 2 2062174336 30671008 17726400
14:47:21 1381 8192000000 10982843584 11407523840 1995728336 19.589 99 70 139 1 2048017168 31600256 20688576
14:47:29 1629 8192000000 10973501664 11386286080 1989542112 19.540 99 83 165 1 2047450576 32425168 25483296
14:47:38 9495 8192000000 10975713872 11401351168 2007792064 19.684 100 70 139 0 2063427136 34084928 21550144
14:47:57 6836 8192000000 10965580256 11394265088 2000596736 19.627 100 71 140 1 2056401264 34455472 21349056
14:48:14 4523 8192000000 10973123648 11397595136 1988542352 19.532 99 63 126 0 2039294672 31144784 19607536
14:48:27 13229 8192000000 10953948240 11376259072 1976824592 19.440 99 67 133 2 2029351568 32218816 20308160
14:48:54 4986 8192000000 10965510928 11389034496 1993141280 19.569 100 72 144 2 2048600048 33330096 22128672
14:49:07 1714 8192000000 10970550208 11387715584 1996313136 19.594 100 84 167 2 2056466656 34367824 25785696
14:49:16 9220 8192000000 10963222400 11389923328 1993454480 19.571 100 69 138 0 2050717808 35478080 21785248
14:49:35 3570 8192000000 10976190800 11394433024 2002373040 19.641 100 82 164 0 2062428000 35942976 24111984
14:49:47 6638 8192000000 10987787536 11408515072 2010235904 19.703 100 76 151 2 2070600000 37402560 22961536
14:50:08 1879 8192000000 10993503280 11408666624 2013123632 19.726 100 89 176 2 2076080512 35509104 27447776
14:50:20 4733 8192000000 10979011920 11399921664 1993547216 19.572 99 89 180 1 2056056608 36230272 26279120
14:50:37 3494 8192000000 10993847744 11413000192 2015729856 19.747 100 77 154 0 2077447856 37222672 24495328
14:50:48 10280 8192000000 10985497600 11411939328 2012420352 19.721 100 81 162 1 2074090576 36039424 25630800
14:51:09 3583 8192000000 10982684976 11410669568 1994252512 19.577 99 70 140 2 2055309696 38519792 22537392
14:51:19 3920 8192000000 10994767232 11420254208 2015006704 19.741 100 78 153 0 2079412432 41029440 23376288
14:51:32 5140 8192000000 11009803136 11434270720 2024040512 19.812 100 84 168 1 2092608688 43204128 25364048
14:51:47 7192 8192000000 11012811472 11437969408 2025866512 19.826 100 82 164 0 2096806656 45354848 25585296
14:52:06 5992 8192000000 11012316576 11443142656 2026612720 19.832 100 69 138 2 2096392528 48366288 21413520
14:52:21 4578 8192000000 11019810992 11448152064 2034389568 19.893 100 67 132 0 2102412736 47732912 20290256
14:52:33 2323 8192000000 10987970448 11403001856 1991038176 19.552 98 85 169 2 2065349312 47549168 26761968
14:52:45 4793 8192000000 10992564192 11412619264 2002753232 19.644 99 70 141 2 2072245136 46688656 22803248
14:53:06 2975 8192000000 11015908688 11440386048 2022817648 19.802 100 78 156 0 2097635424 49003648 25814128
14:53:16 3436 8192000000 11016244480 11438256128 2020948176 19.788 100 86 171 0 2101243456 53083216 27212064
14:53:27 2777 8192000000 11013827072 11430215680 2009092832 19.694 100 83 164 2 2090957184 55611808 26252544
14:53:39 3035 8192000000 11000790624 11418394624 1990675920 19.549 99 85 169 1 2071263664 53571904 27015840
14:53:49 2210 8192000000 11013210016 11433218048 2014664432 19.738 100 82 166 1 2094005728 53607568 25733728
14:53:58 4041 8192000000 11004642880 11427184640 2006407616 19.673 100 79 155 1 2086855616 54772864 25675136
14:54:12 4025 8192000000 11022666272 11437735936 2018375088 19.767 100 83 168 0 2100654992 55626560 26653344
14:54:22 2494 8192000000 11028795840 11445948416 2024834912 19.818 100 91 181 2 2111148208 57211200 29102096
14:54:31 2195 8192000000 11022570592 11433558016 2012189440 19.719 100 92 184 1 2099760352 58416736 29154176
14:54:41 2417 8192000000 11015870640 11441160192 2019017920 19.772 100 82 163 1 2103561280 58290272 26253088
14:54:50 2068 8192000000 11017933888 11436593152 2015162160 19.742 100 84 164 0 2096924752 55692368 26070224
14:55:00 2351 8192000000 11002992848 11420651520 1996392976 19.594 99 82 162 2 2078035872 56566080 25076816
14:55:09 3486 8192000000 10999202192 11429650432 1995970224 19.591 99 83 166 1 2079700624 57968800 25761600
14:55:25 10386 8192000000 10957172576 11398660096 1955931712 19.274 98 53 104 3 2029253136 55788688 17532736
14:55:53 6028 8192000000 10940005504 11378565120 1951159616 19.236 99 46 92 0 2015205920 48621248 15425056
14:56:11 7851 8192000000 10964047936 11386241024 1968593552 19.374 100 59 117 3 2033536496 46484544 18458400
14:56:25 2495 8192000000 10960027568 11385757696 1972868400 19.408 100 67 134 1 2042653472 47544336 22240736
14:56:34 3939 8192000000 10959561136 11385991168 1960570688 19.311 99 64 128 0 2031386544 49861040 20954816
14:56:47 10909 8192000000 10961368400 11400880128 1984434432 19.500 100 44 88 1 2050409072 51199232 14775408
14:57:06 5899 8192000000 10968172512 11407507456 1990062160 19.544 100 41 82 1 2053755072 49607888 14085024
14:57:20 7648 8192000000 10996912288 11417071616 1999419520 19.618 100 62 122 1 2070321440 49859280 21042640
14:57:36 1446 8192000000 11020024064 11431337984 2008445280 19.689 100 88 175 1 2087927040 51109808 28371952
14:57:52 3393 8192000000 11002899472 11427536896 1992327760 19.562 99 71 142 3 2072112960 56577696 23207504
14:58:14 14014 8192000000 10941763264 11376689152 1952619152 19.247 98 44 88 0 2023596064 55343920 15632992
14:58:50 21745 8192000000 10962149888 11402100736 1973651104 19.414 100 41 82 0 2050378032 61815056 14911872
14:59:22 15633 8192000000 10939985616 11376799744 1933176016 19.092 99 49 98 0 2016916000 65632960 18107024
14:59:48 14213 8192000000 10952504032 11398512640 1954768672 19.264 100 39 78 2 2033094256 63961504 14364080
15:00:25 18748 8192000000 10940638000 11389566976 1939759568 19.145 99 33 66 2 2015644736 63305456 12579712
15:01:07 17916 8192000000 10934351328 11405303808 1959524032 19.302 100 29 58 3 2028821680 58872944 10424704
15:01:34 30861 8192000000 10906064752 11375304704 1933522096 19.095 99 24 48 1 1992201904 48915376 9764432
15:02:13 52497 8192000000 10895511744 11354505216 1911783376 18.921 98 22 44 1 1957073104 38293040 6996688
15:03:20 40445 8192000000 10901724976 11367075840 1935725760 19.113 99 33 66 2 1982072656 36278944 10067952
15:04:09 72908 8192000000 10872256864 11346485248 1896386112 18.797 97 10 20 1 1917146176 17871824 2888240
15:05:33 128571 8192000000 10882258640 11349823488 1875855216 18.632 96 7 14 0 1888829504 11448864 1525424
15:07:48 91048 8192000000 10891264208 11321237504 1872281760 18.603 96 21 41 4 1890029536 12437712 5310064
15:09:35 93953 8192000000 10857578736 11300683776 1848920096 18.413 95 13 25 1 1859078128 7149504 3008528
15:11:16 87902 8192000000 10870146976 11329019904 1884173808 18.699 97 32 64 0 1903409264 9844576 9390880
15:12:55 61273 8192000000 10862347632 11331801088 1915446272 18.950 99 11 22 0 1932899760 14436032 3017456
15:14:04 109313 8192000000 10888591504 11355832320 1935312704 19.109 100 4 8 0 1953225808 17091312 821792
15:16:00 148695 8192000000 10908980208 11362295808 1936366096 19.118 99 22 43 1 1955512416 11970240 7176080
15:18:36 44727 8192000000 10914315472 11369689088 1970120528 19.386 100 44 89 1 1997506048 14852640 12532880
15:19:29 165970 8192000000 10902941104 11383353344 1979363456 19.460 100 46 91 0 2003869616 11580896 12925264
15:22:27 14724 8192000000 10932141264 11388583936 1992328480 19.562 100 42 83 1 2011156736 6987312 11840944
15:22:51 42246 8192000000 10930206704 11385741312 1980215280 19.466 99 49 98 0 2002490944 8636272 13639392
15:23:41 28058 8192000000 10928874592 11389161472 1989967680 19.544 100 47 94 1 2014179808 11271632 12940496
15:24:19 59378 8192000000 10918303040 11386216448 1971178496 19.395 99 16 30 1 1984991952 9590048 4223408
15:25:29 31717 8192000000 10908587248 11387760640 1987448096 19.524 100 17 34 3 2000328032 8271904 4608032
15:27:03 68166 8192000000 10899300096 11378327552 1974338400 19.420 100 8 15 1 1983710608 6997136 2375072
15:28:19 23551 8192000000 10907925024 11388125184 1986918144 19.519 100 10 20 1 1999475312 9534448 3022720
15:28:49 37521 8192000000 10902714032 11381235712 1967698896 19.367 99 13 25 1 1980405744 8575712 4131136
15:29:37 85424 8192000000 10910192864 11379388416 1963790272 19.336 99 18 36 0 1977170528 7924688 5455568
15:31:09 42792 8192000000 10913090512 11391897600 1986692832 19.518 100 24 48 1 2002436256 8729936 7013488
15:32:01 40152 8192000000 10890983648 11372285952 1926489392 19.039 97 13 26 0 1938966064 9227440 3249232
15:32:51 31793 8192000000 10865836768 11344359424 1919958960 18.987 97 12 24 0 1931005952 7933888 3113104
15:33:48 52430 8192000000 10877145920 11363770368 1943486448 19.175 99 6 12 0 1954718368 9644544 1587376
15:34:57 45905 8192000000 10886220816 11364167680 1931994832 19.083 98 10 20 1 1941670640 7583776 2092032
15:35:51 17394 8192000000 10895646432 11358957568 1963706672 19.335 100 20 40 0 1975835680 6672768 5456240
15:36:23 14781 8192000000 10899435984 11358822400 1931350528 19.078 98 35 70 0 1950203888 8605488 10247872
15:36:49 31259 8192000000 10884653696 11351724032 1939088880 19.139 99 25 50 2 1955300752 9810048 6401824
15:37:27 61749 8192000000 10887899936 11350769664 1915539776 18.951 98 20 40 1 1933462832 12332960 5590096
15:38:36 13980 8192000000 10903055904 11349123072 1942720160 19.168 99 54 108 1 1966680832 8802720 15157952
15:39:01 56499 8192000000 10866757360 11349479424 1926599472 19.040 99 31 62 0 1947806032 12570416 8636144
15:40:06 35735 8192000000 10872557632 11342147584 1918023632 18.971 98 20 40 0 1937003568 13474128 5505808
15:41:01 33389 8192000000 10849647008 11315122176 1878540560 18.653 97 30 60 0 1896813360 9925904 8346896
15:41:41 53378 8192000000 10875342720 11343892480 1923651856 19.016 99 28 56 3 1942166752 10399360 8115536
15:42:45 48267 8192000000 10850891040 11319119872 1838602576 18.329 95 13 26 1 1854124432 11386272 4135584
15:43:43 25181 8192000000 10824586640 11274616832 1821642464 18.191 95 23 46 3 1836413776 7956304 6815008
15:44:17 16678 8192000000 10870227152 11317317632 1921269904 18.997 100 50 100 1 1945176816 10428672 13478240
15:44:47 23556 8192000000 10860412256 11319844864 1902274720 18.845 99 41 82 1 1930196512 16653440 11268352
15:45:16 70256 8192000000 10867874320 11331842048 1871916288 18.600 97 43 84 2 1895845824 12695008 11234528
15:46:37 21704 8192000000 10873477056 11324223488 1898523712 18.814 98 34 68 0 1916384432 8364384 9496336
15:47:17 22930 8192000000 10842776864 11300532224 1867018304 18.560 97 34 68 2 1889387888 12959952 9409632
15:47:47 90829 8192000000 10846700384 11302760448 1876906096 18.640 98 31 61 3 1897083664 11770480 8407088
15:49:26 84401 8192000000 10838614416 11317776384 1892508736 18.766 99 20 40 0 1917745264 18392432 6844096
15:51:09 66439 8192000000 10824554256 11304570880 1855650288 18.468 97 14 28 1 1874173680 14708144 3815248
15:52:25 46974 8192000000 10820759360 11305611264 1886107392 18.714 99 8 17 0 1905356480 16617664 2631424
15:53:19 16098 8192000000 10820942640 11310407680 1902549568 18.847 100 3 6 0 1916366896 13407808 409520
15:53:41 6697 8192000000 10823467408 11312148480 1902681536 18.848 100 3 6 0 1916380896 13288064 411296
15:53:54 42527 8192000000 10853562848 11323809792 1920727632 18.993 100 19 37 3 1933481120 7296064 5457424
15:54:43 49631 8192000000 10857303664 11321475072 1876276032 18.635 97 22 44 0 1894170656 11244448 6650176
15:55:41 74602 8192000000 10834452160 11314388992 1896185072 18.796 99 13 26 0 1917570992 17052304 4333616
15:57:08 45079 8192000000 10828835872 11283279872 1829999568 18.259 96 21 42 0 1843746528 7961248 5785712
15:58:08 30561 8192000000 10832043568 11295596544 1898995472 18.818 100 29 59 1 1920632432 12519856 9117104
15:58:48 50006 8192000000 10851610176 11313139712 1913515968 18.935 100 15 30 0 1928324256 10737680 4070608
15:59:53 56840 8192000000 10847122032 11332104192 1909172352 18.900 99 14 28 0 1927250112 13977024 4100736
16:00:56 43341 8192000000 10852455344 11323801600 1886726016 18.719 98 13 26 1 1898749456 8501952 3521488
16:01:45 115062 8192000000 10879538448 11349082112 1905155344 18.868 98 22 44 0 1924972192 13519760 6297088
16:03:48 31991 8192000000 10884040752 11345850368 1914256496 18.941 98 23 46 1 1928871056 8748720 5865840
16:04:32 51318 8192000000 10868717120 11332763648 1855862864 18.470 95 18 36 1 1869663344 9397280 4403200
16:05:30 72882 8192000000 10885355184 11352756224 1914569808 18.943 98 10 20 0 1930259840 13808256 1881776
16:06:49 102980 8192000000 10884317232 11356893184 1917753776 18.969 98 14 28 0 1936812688 15685824 3373088
16:09:20 59845 8192000000 10869470464 11346825216 1921597920 19.000 99 23 45 0 1940832608 12608736 6625952
16:10:33 23240 8192000000 10865087776 11350376448 1940732512 19.153 100 8 16 0 1954801120 11626544 2442064
16:11:02 33532 8192000000 10872513456 11346120704 1944822576 19.185 100 20 40 1 1959593648 9279744 5491328
16:11:42 64791 8192000000 10883929808 11353591808 1908883728 18.898 98 10 21 0 1918397184 6693456 2820000
16:12:53 52535 8192000000 10883972144 11363155968 1954140736 19.259 100 10 20 1 1965771616 8765440 2865440
16:13:52 58999 8192000000 10897575248 11377954816 1963956624 19.337 100 12 22 2 1982401104 15536208 2908272
16:15:00 69124 8192000000 10876921120 11360292864 1910159280 18.908 97 17 34 1 1936853360 21548560 5145520
16:16:24 69448 8192000000 10879360528 11359195136 1923441456 19.014 99 13 26 1 1948860224 21218416 4200352
16:17:43 78667 8192000000 10893651488 11364413440 1922428480 19.006 98 12 23 2 1935215776 9423056 3364240
16:19:39 50207 8192000000 10894035984 11362193408 1909967840 18.906 97 21 40 2 1924097696 8349328 5780528
16:20:35 108409 8192000000 10898024928 11375521792 1887366208 18.725 96 18 36 2 1902361552 9785312 5210032
16:23:16 65706 8192000000 10899186528 11377983488 1927112736 19.044 98 12 24 0 1940814864 10204432 3497696
16:24:30 29739 8192000000 10910899024 11375796224 1929450864 19.062 98 27 54 0 1952744128 15872672 7420592
16:25:10 83830 8192000000 10880709520 11357937664 1880582336 18.670 96 13 26 2 1898891584 14836784 3472464
16:26:46 26197 8192000000 10868994928 11335262208 1891631184 18.759 97 22 44 0 1906990800 8654384 6705232
16:27:27 60238 8192000000 10874471248 11342778368 1871451024 18.596 96 14 28 0 1886443360 11155168 3837168
16:28:40 27151 8192000000 10887030912 11350786048 1929638640 19.064 99 38 75 1 1955242352 14081312 11522400
16:29:20 53456 8192000000 10870980528 11357401088 1920903072 18.994 99 23 46 1 1941275504 14139824 6232608
16:30:19 99756 8192000000 10869446576 11340709888 1907684320 18.888 98 16 32 0 1923096096 10809584 4602192
16:32:06 23988 8192000000 10866793968 11332669440 1905791616 18.873 98 25 50 1 1922094592 9453968 6849008
16:32:36 8080 8192000000 9708140192 10053943296 839050032 9.290 44 3 6 0 851512928 12267408 195488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 19-03-2021 16:34:33 to 19-03-2021 16:35:04.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 83 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-03-2021 16:35:05 to 19-03-2021 16:35:07.

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          239672
MON$OLDEST_ACTIVE               240652
MON$OLDEST_SNAPSHOT             240652
MON$NEXT_TRANSACTION            240652
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                       2033952
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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'

19.03.21 16:35:08. 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-03-19 16:35:10 No severe PSQL-related problems occured
19.03.21 16:35:11. End of report.