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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-06 01:27:12
DTS_END                         2021-02-06 01:27:12.8290
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(226:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55430
TRN_ID                          243108
ATT_ID                          695
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: 9294.13 22698 1115295
customer order: creation 175.53 362 21064
customer order: refuse 14.53 345 1743
order to supplier: creation 47.85 1245 5742
order to supplier: removal 3.40 109988 408
invoice (draft): creation 48.18 3573 5781
invoice (draft): removal 51.45 853 6174
invoice accept: apply 42.72 18191 5126
invoice accept: cancel 46.24 841 5549
customer reserve: creation 3991.79 178 479015
customer reserve: removal 4565.12 65 547814
realization accept: apply 85.68 186 10281
realization accept: cancel 87.23 116 10467
payment from customer: creation 61.68 145 7402
payment from customer: removal 5.86 98 703
payment to supplier: creation 50.66 150 6079
payment to supplier: removal 3.56 111 427
service: total inventory turnovers 4.91 983 589
service: total monetary turnovers 6.95 22 834
service: aggregate perf. data 0.78 21416 93
service: refresh index statistics 0.03 295088 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-02-2021 01:27:54 to 06-02-2021 01:27:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6871
TEST_TIME 2 4977
TEST_TIME 3 5057
TEST_TIME 4 5758
TEST_TIME 5 5214
TEST_TIME 6 5724
TEST_TIME 7 5453
TEST_TIME 8 5412
TEST_TIME 9 5507
TEST_TIME 10 5931
TEST_TIME 11 5930
TEST_TIME 12 6218
TEST_TIME 13 6433
TEST_TIME 14 6630
TEST_TIME 15 6937
TEST_TIME 16 7206
TEST_TIME 17 7568
TEST_TIME 18 7655
TEST_TIME 19 8190
TEST_TIME 20 8221
TEST_TIME 21 8093
TEST_TIME 22 8343
TEST_TIME 23 8477
TEST_TIME 24 8695
TEST_TIME 25 8957
TEST_TIME 26 9372
TEST_TIME 27 9801
TEST_TIME 28 10779
TEST_TIME 29 10747
TEST_TIME 30 10583
TEST_TIME 31 10474
TEST_TIME 32 10583
TEST_TIME 33 10362
TEST_TIME 34 10340
TEST_TIME 35 10165
TEST_TIME 36 10208
TEST_TIME 37 10206
TEST_TIME 38 10291
TEST_TIME 39 10199
TEST_TIME 40 10122
TEST_TIME 41 10028
TEST_TIME 42 9854
TEST_TIME 43 9786
TEST_TIME 44 9690
TEST_TIME 45 9788
TEST_TIME 46 9746
TEST_TIME 47 9703
TEST_TIME 48 9649
TEST_TIME 49 9761
TEST_TIME 50 9746
TEST_TIME 51 9717
TEST_TIME 52 9770
TEST_TIME 53 9681
TEST_TIME 54 9771
TEST_TIME 55 9715
TEST_TIME 56 9761
TEST_TIME 57 9762
TEST_TIME 58 9933
TEST_TIME 59 9797
TEST_TIME 60 9673
TEST_TIME 61 9579
TEST_TIME 62 9589
TEST_TIME 63 9525
TEST_TIME 64 9504
TEST_TIME 65 9465
TEST_TIME 66 9429
TEST_TIME 67 9378
TEST_TIME 68 9381
TEST_TIME 69 9308
TEST_TIME 70 9444
TEST_TIME 71 9562
TEST_TIME 72 9498
TEST_TIME 73 9516
TEST_TIME 74 9551
TEST_TIME 75 9521
TEST_TIME 76 9521
TEST_TIME 77 9596
TEST_TIME 78 9675
TEST_TIME 79 9583
TEST_TIME 80 9513
TEST_TIME 81 9449
TEST_TIME 82 9450
TEST_TIME 83 9430
TEST_TIME 84 9356
TEST_TIME 85 9303
TEST_TIME 86 9266
TEST_TIME 87 9352
TEST_TIME 88 9324
TEST_TIME 89 9313
TEST_TIME 90 9347
TEST_TIME 91 9335
TEST_TIME 92 9398
TEST_TIME 93 9361
TEST_TIME 94 9443
TEST_TIME 95 9411
TEST_TIME 96 9475
TEST_TIME 97 9502
TEST_TIME 98 9525
TEST_TIME 99 9532
TEST_TIME 100 9527
TEST_TIME 101 9506
TEST_TIME 102 9474
TEST_TIME 103 9415
TEST_TIME 104 9346
TEST_TIME 105 9373
TEST_TIME 106 9344
TEST_TIME 107 9282
TEST_TIME 108 9272
TEST_TIME 109 9285
TEST_TIME 110 9302
TEST_TIME 111 9291
TEST_TIME 112 9281
TEST_TIME 113 9258
TEST_TIME 114 9349
TEST_TIME 115 9325
TEST_TIME 116 9332
TEST_TIME 117 9347
TEST_TIME 118 9380
TEST_TIME 119 9366
TEST_TIME 120 9298

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-02-2021 01:27:58 to 06-02-2021 01:28:01.

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 1557733 1557733 0 0.00 0 18457 7 0 0
doc_list_biud 1557732 1557732 0 0.00 0 55078 29 0 0
sp_add_invoice_to_stock 5236 5126 110 2.10 28 224739 18192 0 110
sp_cancel_adding_invoice 5549 5549 0 0.00 5 78431 841 0 0
sp_cancel_client_order 1743 1743 0 0.00 4 11424 346 0 0
sp_cancel_customer_reserve 547814 547814 0 0.00 1 55080 66 0 0
sp_cancel_pay_from_customer 703 703 0 0.00 3 11213 99 0 0
sp_cancel_pay_to_supplier 427 427 0 0.00 3 8096 112 0 0
sp_cancel_supplier_invoice 6182 6174 8 0.12 1 13437 854 0 8
sp_cancel_supplier_order 408 408 0 0.00 9 1015518 109989 0 0
sp_cancel_write_off 10467 10467 0 0.00 1 13224 116 0 0
sp_client_order 21064 21064 0 0.00 3 36602 362 0 0
sp_customer_reserve 479015 479015 0 0.00 0 98379 178 0 0
sp_fill_shopping_cart 32577 32577 0 0.00 1 16582 45 0 0
sp_fill_shopping_cart_clo_res 479008 479008 0 0.00 0 22035 14 0 0
sp_get_clo_for_invoice 5119 5119 0 0.00 0 30658 305 0 0
sp_kill_cost_storno 17146 17146 0 0.00 0 18090 58 0 0
sp_kill_qstorno_ret_qs2qd 1112677 1112677 0 0.00 0 55075 35 0 0
sp_kill_qty_storno 587554 587554 0 0.00 0 55078 75 0 0
sp_lock_selected_doc 21265 21265 0 0.00 0 7457 6 0 0
sp_make_cost_storno 28881 28881 0 0.00 0 12563 58 0 0
sp_multiply_rows_for_pdistr 28881 28881 0 0.00 0 15964 36 0 0
sp_multiply_rows_for_qdistr 21064 21064 0 0.00 0 28786 178 0 0
sp_pay_from_customer 7402 7402 0 0.00 4 18538 146 0 0
sp_pay_to_supplier 6079 6079 0 0.00 5 18351 151 0 0
sp_payment_common 13481 13481 0 0.00 2 18372 37 0 0
sp_qd_handle_on_cancel_clo 1743 1743 0 0.00 0 11418 316 0 0
sp_qd_handle_on_invoice_upd_sts 10668 10668 0 0.00 0 21253 318 0 0
sp_qd_handle_on_reserve_upd_sts 10280 10280 0 0.00 0 22649 52 0 0
sp_reserve_write_off 10281 10281 0 0.00 6 22684 187 0 0
sp_supplier_invoice 5781 5781 0 0.00 6 113211 3573 0 0
sp_supplier_order 5742 5742 0 0.00 5 27424 1245 0 0
srv_aggregate_perf_data 94 93 1 1.06 2810 487205 21417 0 1
srv_fill_mon_cache_memory 162 162 0 0.00 929 177949 32904 0 0
srv_find_qd_qs_mism 1065345 1065345 0 0.00 0 10959 5 0 0
srv_make_invnt_saldo 589 589 0 0.00 31 54416 984 0 0
srv_make_money_saldo 834 834 0 0.00 1 447 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 201979 403383 295089 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5127 5127 0 0.00 0 11480 137 0 0
t$perf-norm:sp_cancel_adding_invoice 435 435 0 0.00 0 2309 103 0 0
t$perf-norm:sp_cancel_client_order 1743 1743 0 0.00 0 2015 12 0 0
t$perf-norm:sp_cancel_customer_reserve 705 705 0 0.00 0 4350 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 703 703 0 0.00 0 4155 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 427 427 0 0.00 0 1102 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 620 15 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 22193 1559 0 0
t$perf-norm:sp_cancel_write_off 1037 1037 0 0.00 0 3276 8 0 0
t$perf-norm:sp_client_order 21064 21064 0 0.00 0 9460 14 0 0
t$perf-norm:sp_customer_reserve 1003 1003 0 0.00 0 205 2 0 0
t$perf-norm:sp_pay_from_customer 7402 7402 0 0.00 0 3460 8 0 0
t$perf-norm:sp_pay_to_supplier 6079 6079 0 0.00 0 5754 8 0 0
t$perf-norm:sp_reserve_write_off 10281 10281 0 0.00 0 10014 8 0 0
t$perf-norm:sp_supplier_invoice 5781 5781 0 0.00 0 7750 17 0 0
t$perf-norm:sp_supplier_order 5742 5742 0 0.00 0 1104 10 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 268 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 1828 14 0 0
t$perf-norm:srv_make_invnt_saldo 589 589 0 0.00 0 2280 25 0 0
t$perf-norm:srv_make_money_saldo 834 834 0 0.00 0 676 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10458 10238 220 2.10 0 4123 18 0 220
v_all_customers 38586 38586 0 0.00 0 17 1 0 0
v_all_suppliers 31726 31726 0 0.00 0 22 1 0 0
v_all_wares 42128 42128 0 0.00 0 39 1 0 0
v_cancel_adding_invoice 870 870 0 0.00 0 5223 22 0 0
v_cancel_client_order 3486 3486 0 0.00 0 3838 8 0 0
v_cancel_customer_prepayment 1406 1406 0 0.00 0 5812 12 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 4033 11 0 0
v_cancel_payment_to_supplier 854 854 0 0.00 0 1437 6 0 0
v_cancel_supplier_invoice 832 816 16 1.92 0 1082 15 0 16
v_cancel_supplier_order 816 816 0 0.00 0 989 5 0 0
v_cancel_write_off 2074 2074 0 0.00 0 5277 18 0 0
v_max_id_clo_ord 5740 5740 0 0.00 0 608 1 0 0
v_max_id_clo_res 1003 1003 0 0.00 0 3955 18 0 0
v_max_id_ord_sup 5773 5773 0 0.00 0 6007 3 0 0
v_max_non_paid_invoice 1729 1729 0 0.00 0 4754 6 0 0
v_max_non_paid_realizn 3931 3931 0 0.00 0 2836 6 0 0
v_min_id_clo_ord 5740 5740 0 0.00 0 8352 8 0 0
v_min_id_clo_res 1003 1003 0 0.00 0 1580 5 0 0
v_min_id_ord_sup 5773 5773 0 0.00 0 10996 7 0 0
v_min_non_paid_invoice 6079 6079 0 0.00 0 15897 20 0 0
v_min_non_paid_realizn 7402 7402 0 0.00 0 15928 24 0 0
v_our_firm 10484 10484 0 0.00 0 14 1 0 0
v_reserve_write_off 20560 20560 0 0.00 0 5949 8 0 0
x_lock_depdocs_on_canc_invoice 11315 11315 0 0.00 0 15561 115 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 12204 335 0 0
x_make_qstorno_1000_1200 5742 5742 0 0.00 1 27412 1166 0 0
x_make_qstorno_1200_2000 5781 5781 0 0.00 2 113134 3402 0 0
x_make_qstorno_2100_3300 479015 479015 0 0.00 0 98338 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-02-2021 01:28:02 to 06-02-2021 01:28:06.

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
22:57:16 7 8192000000 8800795728 8812068864 6918096 0.084 2 1 2 0 7037472 56816 62560
22:57:23 18152 8192000000 10261186384 10569912320 932000080 10.214 72 55 110 0 953355120 2711440 18643600
22:57:50 35164 8192000000 10368245392 10686193664 1394264736 14.544 100 84 168 0 1426654336 4862688 27526912
22:58:35 15634 8192000000 10387578176 10707087360 1447577664 15.017 100 89 178 0 1482681360 6482848 28620848
22:58:59 22331 8192000000 10411528320 10741161984 1465387472 15.173 100 78 156 0 1497533216 6885872 25259872
22:59:30 14843 8192000000 10448051680 10778685440 1500389952 15.480 100 87 174 0 1535426496 7564416 27472128
22:59:55 14525 8192000000 10469361904 10804670464 1525309680 15.696 100 86 171 1 1560029952 8394256 26326016
23:00:22 18792 8192000000 10478642576 10816696320 1538316704 15.809 100 92 184 1 1576473104 8978320 29178080
23:00:54 17887 8192000000 10497649840 10841210880 1556537856 15.966 100 84 168 2 1592483744 9971392 25974496
23:01:30 21730 8192000000 10537409200 10884931584 1579406480 16.163 100 83 166 2 1614997888 9809888 25781520
23:02:05 18582 8192000000 10553278512 10907488256 1615645104 16.473 100 81 162 3 1650262112 10591360 24025648
23:02:35 15943 8192000000 10586887072 10943324160 1641100896 16.689 100 86 172 1 1678256016 11468368 25686752
23:03:01 12649 8192000000 10595081584 10959601664 1658694928 16.838 100 81 161 1 1694045488 11493328 23857232
23:03:21 11956 8192000000 10613679744 10977587200 1667975152 16.916 100 75 150 0 1701853936 12022384 21856400
23:03:41 12167 8192000000 10619439696 10983878656 1683117872 17.044 100 79 158 1 1718452432 12615968 22718592
23:04:00 8021 8192000000 10641049856 11008589824 1697653856 17.165 100 88 174 0 1735259776 12777888 24828032
23:04:18 8245 8192000000 10649785616 11017793536 1705355072 17.230 100 79 158 0 1741394192 13235808 22803312
23:04:34 7707 8192000000 10652251440 11027812352 1721267056 17.363 100 80 160 0 1756541920 12492416 22782448
23:04:49 7045 8192000000 10670222160 11042668544 1729566752 17.432 100 75 148 2 1763153664 12596144 20990768
23:05:03 4963 8192000000 10681334752 11056033792 1744238640 17.554 100 76 153 1 1779237744 13171568 21827536
23:05:14 4422 8192000000 10698517520 11072331776 1755650320 17.648 100 83 167 0 1792324576 13089584 23584672
23:05:26 5463 8192000000 10702052272 11080036352 1761128240 17.694 100 83 166 2 1797837120 13753968 22954912
23:05:39 4316 8192000000 10713027296 11088453632 1774373456 17.803 100 82 166 0 1810820976 13540800 22906720
23:05:51 4733 8192000000 10720467776 11100110848 1785694624 17.896 100 85 168 0 1822164624 12932800 23537200
23:06:03 4566 8192000000 10732114608 11112730624 1792282176 17.951 100 79 158 0 1831396928 17083952 22030800
23:06:14 3211 8192000000 10732653744 11116371968 1793964048 17.964 100 83 165 1 1830813200 13655152 23194000
23:06:24 3336 8192000000 10741679856 11121336320 1800154992 18.015 100 88 176 0 1839338608 14022832 25160784
23:06:35 3419 8192000000 10737979600 11122528256 1807137792 18.072 100 84 168 1 1843870992 12837456 23895744
23:06:45 5047 8192000000 10742803120 11130937344 1806506624 18.067 100 71 142 1 1838437696 11397184 20533888
23:06:57 6311 8192000000 10758787696 11144491008 1817958880 18.161 100 85 170 1 1855580960 12732624 24889456
23:07:10 3146 8192000000 10774104960 11153768448 1834463504 18.296 100 86 172 1 1872389456 13640112 24285840
23:07:20 2733 8192000000 10780958432 11161788416 1832511232 18.280 100 89 178 1 1872161664 14572688 25077744
23:07:29 1956 8192000000 10788106064 11171131392 1843185360 18.367 100 95 191 2 1884685536 14921968 26578208
23:07:38 3060 8192000000 10783385808 11164893184 1838692224 18.330 100 88 175 3 1876776576 12269648 25814704
23:07:47 1910 8192000000 10791888256 11176181760 1847564752 18.402 100 92 184 2 1887805824 14037728 26203344
23:07:55 1821 8192000000 10797980560 11181215744 1853978256 18.454 100 92 184 0 1894680080 14005824 26696000
23:08:04 2104 8192000000 10802548192 11186671616 1852757680 18.445 100 91 183 1 1891884784 13510176 25616928
23:08:12 1532 8192000000 10806125136 11189071872 1863557312 18.532 100 96 189 2 1904102160 13601872 26942976
23:08:20 2000 8192000000 10810783872 11196698624 1864856288 18.543 100 94 188 0 1905082224 13290480 26935456
23:08:28 1119 8192000000 10810526656 11198095360 1865652096 18.549 100 88 176 0 1903254384 12404912 25197376
23:08:36 26087 8192000000 10777431376 11189690368 1858455200 18.491 100 53 106 1 1883084000 8681136 15947664
23:09:11 18678 8192000000 10804066976 11200479232 1868977024 18.576 100 67 133 5 1895828384 7651648 19199712
23:09:36 1641 8192000000 10818572880 11212001280 1879359056 18.660 100 89 178 0 1917188864 12180064 25649744
23:09:43 12669 8192000000 10805195616 11206483968 1874073712 18.617 100 61 122 2 1902326032 11797728 16454592
23:10:02 4968 8192000000 10806214816 11209117696 1876311328 18.635 100 55 110 0 1902073168 10614464 15147376
23:10:14 4976 8192000000 10790886864 11210825728 1874045728 18.617 100 36 72 1 1897148416 13385936 9716752
23:10:26 4624 8192000000 10798717264 11211206656 1876039680 18.633 100 43 85 1 1899769264 11392592 12336992
23:10:38 3414 8192000000 10798523360 11211591680 1876079728 18.633 100 43 84 2 1895622848 7317104 12226016
23:10:49 5019 8192000000 10792733120 11217727488 1874093712 18.617 100 32 64 4 1894795408 12243600 8458096
23:11:03 6110 8192000000 10789540768 11211689984 1875906656 18.632 100 27 51 0 1889754368 6675664 7172048
23:11:16 4841 8192000000 10796708368 11214045184 1878609504 18.654 100 31 62 2 1895023600 7504544 8909552
23:11:30 5786 8192000000 10775706944 11208388608 1877331296 18.644 100 18 35 2 1888145872 5780160 5034416
23:11:44 6232 8192000000 10787819648 11216805888 1879989360 18.665 100 25 50 2 1894171360 7359488 6822512
23:12:00 6887 8192000000 10792320352 11223330816 1889379360 18.741 100 37 72 4 1906226544 6368176 10479008
23:12:16 7679 8192000000 10792392416 11224297472 1894213824 18.780 100 27 55 1 1908412112 5720448 8477840
23:12:35 10562 8192000000 10800628480 11230494720 1895559472 18.791 100 15 31 0 1905618144 5874544 4184128
23:12:53 10579 8192000000 10801121536 11232976896 1894718144 18.784 100 21 42 1 1907441840 6620208 6103488
23:13:16 24818 8192000000 10809831152 11245207552 1901197456 18.836 100 32 64 2 1918307216 6449664 10660096
23:14:14 28532 8192000000 10817488560 11246563328 1900832800 18.833 100 22 44 1 1913241536 5855824 6552912
23:14:49 5538 8192000000 10832796608 11253719040 1904309072 18.861 100 33 64 1 1920331680 6783664 9238944
23:15:01 6990 8192000000 10819726176 11251838976 1903058016 18.851 100 27 54 0 1916613520 5612848 7942656
23:15:14 4715 8192000000 10827618640 11255062528 1905826416 18.873 100 33 66 0 1921542624 6273920 9442288
23:15:26 4911 8192000000 10817146784 11251859456 1905097472 18.867 100 30 59 0 1919651760 6858752 7695536
23:15:40 9075 8192000000 10822124992 11254259712 1906577760 18.879 100 19 38 1 1917446784 5240976 5628048
23:16:01 9630 8192000000 10838144752 11260571648 1908832736 18.897 100 27 54 2 1922798384 5739936 8225712
23:16:17 8393 8192000000 10807982800 11251453952 1906159904 18.876 100 27 54 0 1919875168 6445888 7269376
23:16:32 6711 8192000000 10809765712 11245248512 1893692832 18.776 100 21 43 1 1909938640 10325168 5920640
23:16:49 6222 8192000000 10804392704 11238080512 1893916160 18.777 100 22 45 1 1905809520 5702880 6190480
23:17:06 9073 8192000000 10803988224 11239964672 1882076544 18.682 99 26 52 2 1895518080 5335344 8106192
23:17:21 8868 8192000000 10790733072 11225653248 1856118352 18.472 98 14 28 2 1865005280 5042176 3844752
23:17:37 10530 8192000000 10786538928 11214528512 1814799216 18.135 96 15 30 1 1824983328 5649840 4534272
23:17:56 13444 8192000000 10759894592 11167608832 1795553968 17.977 96 26 50 3 1809236080 5714624 7967488
23:19:02 16982 8192000000 10748237360 11180507136 1767957184 17.750 95 19 38 3 1778992480 5374896 5660400
23:19:25 5008 8192000000 10730111312 11153031168 1813132288 18.122 99 23 46 1 1826325776 6833232 6360256
23:19:39 6919 8192000000 10708032016 11125428224 1736686368 17.491 95 19 38 0 1747293040 5613152 4993520
23:19:52 4579 8192000000 10715690976 11135152128 1786379056 17.902 99 35 70 2 1807845408 11226912 10239440
23:20:04 5429 8192000000 10703014176 11112001536 1751683968 17.616 98 33 66 3 1767913728 6827888 9401872
23:20:18 11279 8192000000 10701964512 11125547008 1761190320 17.694 98 28 57 1 1775207744 5525152 8492272
23:20:36 6354 8192000000 10705229376 11118542848 1770185728 17.769 99 23 45 2 1782857344 6445120 6226496
23:20:49 7123 8192000000 10710542640 11124232192 1777385840 17.828 99 20 40 2 1788156432 5023152 5747440
23:21:02 6907 8192000000 10721280592 11137826816 1790860896 17.939 99 28 56 0 1804908976 5537968 8510112
23:21:18 8868 8192000000 10704070976 11120586752 1752119648 17.619 97 16 32 1 1761767696 5288160 4359888
23:21:35 7185 8192000000 10709136832 11120173056 1753446576 17.630 98 25 48 0 1766397632 5200528 7750528
23:21:49 9946 8192000000 10715789872 11123322880 1758329072 17.671 98 28 56 1 1772399872 5076000 8994800
23:22:11 12729 8192000000 10720803248 11141210112 1788167568 17.917 99 21 41 0 1798813888 5153744 5492576
23:22:30 7434 8192000000 10696611168 11113496576 1770417680 17.770 98 19 37 0 1781424112 5290608 5715824
23:22:45 17044 8192000000 10724914304 11152912384 1770865136 17.774 97 36 70 5 1788188448 5071232 12252080
23:23:11 74966 8192000000 10753035104 11171553280 1819416368 18.173 99 37 73 3 1834551696 5014848 10120480
23:24:34 9337 8192000000 10771596896 11189374976 1849585504 18.419 100 35 70 2 1865771280 6830416 9355360
23:24:50 7788 8192000000 10760652176 11190759424 1846595968 18.394 100 23 48 0 1859561904 6564880 6401056
23:25:06 7438 8192000000 10768928528 11191496704 1846619584 18.395 100 11 22 0 1854633632 4751328 3262720
23:25:21 4908 8192000000 10774556016 11197140992 1852975312 18.446 100 23 46 1 1864855040 4964176 6915552
23:25:32 6581 8192000000 10770232352 11199836160 1857145040 18.480 100 23 46 1 1868913696 4660848 7107808
23:25:46 10374 8192000000 10774868592 11206279168 1862121024 18.520 100 25 51 0 1874788624 5340400 7327200
23:26:04 11295 8192000000 10774445600 11208290304 1866374176 18.555 100 18 36 2 1876807520 5625808 4807536
23:26:22 13371 8192000000 10779011808 11213529088 1868181728 18.570 100 26 52 1 1881811968 5827008 7803232
23:26:45 8640 8192000000 10788246592 11216482304 1873815008 18.615 100 39 76 2 1890643168 4948512 11879648
23:27:01 8663 8192000000 10811619248 11226628096 1883053552 18.690 100 27 55 1 1896497856 5177296 8267008
23:27:19 18753 8192000000 10829885072 11246686208 1896480752 18.798 100 42 84 1 1918253856 10141536 11631568
23:27:47 27940 8192000000 10842141696 11258880000 1909663744 18.904 100 50 100 2 1931846640 7377472 14805424
23:28:26 94662 8192000000 10852649152 11278483456 1918889520 18.978 100 37 74 3 1937218864 7678144 10651200
23:30:08 46329 8192000000 10862955424 11296231424 1928826448 19.057 100 43 86 1 1951373968 9010800 13536720
23:31:02 35889 8192000000 10861775104 11307024384 1932558144 19.087 100 32 64 1 1958771936 16973088 9240704
23:31:45 37358 8192000000 10881556128 11314561024 1943350560 19.173 100 30 61 1 1967594832 15260656 8983616
23:32:40 15785 8192000000 10912338832 11335176192 1966629984 19.359 100 62 122 0 1997918096 13521792 17766320
23:33:12 18147 8192000000 10897570096 11336347648 1967863360 19.368 100 54 108 2 2001056816 17365744 15827712
23:33:49 20189 8192000000 10907145216 11344896000 1971638656 19.398 100 44 87 2 1999086832 14518144 12930032
23:34:18 22774 8192000000 10910163104 11349602304 1975842512 19.432 100 42 82 2 2003552544 14514272 13195760
23:34:55 6662 8192000000 10925975120 11360686080 1982251472 19.483 100 44 88 0 2013097280 17578112 13267696
23:35:23 7205 8192000000 10935815968 11371376640 1990499728 19.548 100 55 109 1 2027425664 20609680 16316256
23:35:39 8644 8192000000 10947872080 11379843072 1994073584 19.576 100 55 110 2 2031414864 20579120 16762160
23:35:59 10688 8192000000 10948095376 11376771072 1991975504 19.559 100 64 128 0 2039087696 28151680 18960512
23:36:22 9509 8192000000 10954381392 11382358016 1984183072 19.498 99 57 114 1 2025847952 24925664 16739216
23:36:48 8616 8192000000 10970357904 11391508480 2006905088 19.677 100 76 152 0 2057211120 27336912 22969120
23:37:04 12320 8192000000 10964504288 11393728512 2006460240 19.674 100 65 130 1 2054087968 28109168 19518560
23:37:24 12012 8192000000 10968384064 11405135872 2012015152 19.717 100 58 116 1 2056972624 27486624 17470848
23:37:50 9479 8192000000 10970867216 11407294464 2016122368 19.750 100 54 108 1 2057737936 25389664 16225904
23:38:06 4121 8192000000 10969894272 11405766656 2012237568 19.719 100 61 122 1 2057218720 26263216 18717936
23:38:21 6575 8192000000 10954757104 11392630784 1987577712 19.525 99 57 114 1 2033932752 28580000 17775040
23:38:38 6022 8192000000 10971832464 11403251712 2009490992 19.698 100 66 130 0 2058957984 29513920 19953072
23:38:58 8489 8192000000 10977301440 11410644992 2011619936 19.714 100 61 122 2 2059925120 29853696 18451488
23:39:15 10176 8192000000 10984034432 11418062848 2023050976 19.804 100 66 131 3 2073516784 31042032 19423776
23:39:31 4538 8192000000 10989092112 11418648576 2024543744 19.816 100 71 142 1 2075906928 29250416 22112768
23:39:49 5666 8192000000 10989618256 11414212608 2020463184 19.784 100 76 151 0 2073099552 29630336 23006032
23:40:05 4398 8192000000 10996868096 11416006656 2019317920 19.775 100 77 152 3 2072171456 29926240 22927296
23:40:20 3784 8192000000 10978034832 11411718144 2013802784 19.731 100 66 132 1 2067793904 33557440 20433680
23:40:31 5763 8192000000 10992615152 11422601216 2021328240 19.791 100 76 152 1 2079339664 34718704 23292720
23:40:48 929 8192000000 11010653168 11427049472 2022581520 19.800 100 84 168 0 2085342672 37429152 25332000
23:40:57 1455 8192000000 10980750064 11397021696 1988074480 19.529 98 83 164 1 2051864592 38499712 25290400
23:41:05 4543 8192000000 11002430880 11427778560 2018388240 19.767 100 76 153 1 2080925808 38736976 23800592
23:41:17 1207 8192000000 11006877552 11429830656 2026708192 19.833 100 81 164 0 2089195952 37659712 24828048
23:41:25 7790 8192000000 10997271600 11419918336 2019769792 19.778 100 77 153 0 2080718816 37266336 23682688
23:41:42 2008 8192000000 10983909312 11402366976 1996204144 19.593 99 92 184 3 2062184032 38539088 27440800
23:41:52 2842 8192000000 10996799056 11421872128 2013845728 19.732 100 77 154 0 2079710960 42839600 23025632
23:42:02 4173 8192000000 10994148672 11416391680 2012867904 19.724 100 81 161 1 2078194800 41361632 23965264
23:42:15 3488 8192000000 11000781200 11428429824 2017909088 19.764 100 69 138 0 2084399152 44225360 22264704
23:42:27 5763 8192000000 10997985792 11427266560 2017689904 19.762 100 76 152 1 2085819040 44696272 23432864
23:42:42 2518 8192000000 10987513536 11411427328 2005482256 19.666 100 90 178 1 2078359456 45862240 27014960
23:42:52 2106 8192000000 11002613920 11425783808 2011375680 19.712 100 81 159 1 2085394784 49100736 24918368
23:43:02 6197 8192000000 10998576400 11425837056 2013852544 19.732 100 82 162 0 2087297856 47271616 26173696
23:43:16 3404 8192000000 10975694864 11390652416 1980935184 19.472 100 86 170 0 2054716512 47252752 26528576
23:43:28 5421 8192000000 10975737632 11395829760 1983836048 19.495 100 67 133 0 2055565184 50332080 21397056
23:43:41 3832 8192000000 10977006480 11399827456 1966161840 19.355 99 76 152 0 2045783040 55805088 23816112
23:43:52 3336 8192000000 10976882576 11401613312 1986777312 19.518 100 80 159 0 2063588528 52137136 24674080
23:44:02 2049 8192000000 10991307392 11407007744 1994212320 19.577 100 92 182 0 2074345120 51375904 28756896
23:44:16 3554 8192000000 10995960928 11420004352 2003912096 19.654 100 77 151 1 2079649024 51433392 24303536
23:44:26 1015 8192000000 11010164720 11422638080 2012760704 19.723 100 93 187 1 2087490832 46014560 28715568
23:44:33 2403 8192000000 11002407504 11429502976 2017668976 19.762 100 78 157 0 2090567808 47695968 25202864
23:44:42 3342 8192000000 10994403616 11415785472 1997122800 19.600 99 76 150 0 2067757136 46742768 23891568
23:44:55 7190 8192000000 10979391888 11405144064 1993131520 19.569 100 74 148 0 2063724928 47388848 23204560
23:45:10 3480 8192000000 10970949264 11395801088 1982474320 19.484 100 66 132 1 2052644080 48600048 21569712
23:45:21 2765 8192000000 10981206096 11395567616 1984704432 19.502 100 84 168 5 2061293056 50191200 26397424
23:45:31 4342 8192000000 10984610128 11401543680 1986189936 19.514 100 82 164 1 2065236896 52903280 26143680
23:45:42 4086 8192000000 10994813872 11412631552 1992627808 19.565 100 86 170 1 2074725520 54968240 27129472
23:45:58 1344 8192000000 11007703216 11419852800 2001775088 19.637 100 89 177 1 2085466224 56455456 27235680
23:46:10 2384 8192000000 10995394096 11414646784 1990630256 19.549 100 79 158 2 2074548064 58744128 25173680
23:46:21 2718 8192000000 10981276160 11407712256 1968077312 19.370 99 69 138 0 2051763344 61087024 22599008
23:46:35 13327 8192000000 10975009504 11413360640 1987319824 19.523 100 53 106 1 2061048624 55945040 17783760
23:46:59 14200 8192000000 10958585056 11394805760 1952427808 19.246 98 42 84 2 2018390672 51981776 13981088
23:47:24 3632 8192000000 10986658192 11407659008 1992003744 19.560 100 69 137 1 2064869904 49460896 23405264
23:47:34 3447 8192000000 10988161152 11416166400 1997557376 19.603 100 59 118 2 2067578144 51058256 18962512
23:47:45 7065 8192000000 10984821200 11419717632 1997725712 19.605 100 52 104 2 2066590560 52110944 16753904
23:48:25 17531 8192000000 10957982512 11398078464 1967322960 19.364 100 42 84 2 2043188560 61834112 14031488
23:49:11 15471 8192000000 10962455472 11404845056 1973194208 19.411 100 43 86 1 2048775312 60782576 14798528
23:49:36 19540 8192000000 10950461440 11396075520 1939866080 19.146 98 40 80 0 2008422496 55149056 13407360
23:50:08 14973 8192000000 10971082384 11407196160 1972813680 19.408 100 47 95 2 2046733360 57358208 16561472
23:50:41 14906 8192000000 10966881456 11412078592 1978298640 19.451 100 41 82 0 2054084352 61425936 14359776
23:51:09 7181 8192000000 10969812080 11420504064 1978821360 19.455 100 29 58 1 2048889232 59609280 10458592
23:51:23 20055 8192000000 10950013600 11405881344 1959477392 19.302 99 38 75 1 2032605296 60058064 13069840
23:52:17 30926 8192000000 10948881824 11405074432 1966917856 19.361 100 32 64 1 2034922592 56234544 11770192
23:53:16 36790 8192000000 10933704176 11392589824 1935613824 19.112 99 26 52 0 2008043248 62691952 9737472
23:54:11 32123 8192000000 10908268480 11383750656 1915920848 18.954 99 20 40 1 1979587616 56463424 7203344
23:54:56 50761 8192000000 10831724992 11276648448 1722647696 17.374 89 11 22 0 1754127760 28342576 3137488
23:55:55 19334 8192000000 10791353984 11242307584 1826753600 18.233 97 13 26 1 1848102368 17471712 3877056
23:56:23 83059 8192000000 10839601360 11293491200 1899040640 18.819 100 25 50 2 1919833072 13370832 7421600
23:57:58 38278 8192000000 10889354592 11316367360 1935066656 19.107 100 51 98 0 1957608208 8698592 13842960
23:58:43 36793 8192000000 10813874896 11259891712 1853371024 18.450 96 32 64 0 1870339888 8385088 8583776
23:59:26 83225 8192000000 10834653808 11282321408 1841936944 18.357 96 28 56 0 1860137440 10890960 7309536
00:01:08 4927 8192000000 10851635584 11290619904 1896793232 18.800 99 38 78 1 1917895744 11046592 10055920
00:01:19 21753 8192000000 10862677232 11299950592 1903903904 18.858 99 51 102 0 1931349696 13092496 14353296
00:01:55 33004 8192000000 10856753648 11304398848 1908142304 18.892 99 28 55 3 1929450048 13532624 7775120
00:02:35 28041 8192000000 10889895328 11332988928 1936421008 19.118 100 45 92 2 1962476672 12850512 13205152
00:03:23 56111 8192000000 10855931136 11322662912 1918676560 18.976 99 24 48 0 1948392464 21941280 7774624
00:04:27 18232 8192000000 10858600064 11333439488 1927894128 19.050 100 13 26 0 1950797200 19089376 3813696
00:05:01 54321 8192000000 10864991648 11337359360 1933552944 19.095 100 15 30 1 1958862272 20866400 4442928
00:06:11 28381 8192000000 10844235200 11312357376 1933522496 19.095 100 7 15 0 1944321776 8309088 2490192
00:06:46 177949 8192000000 10859617552 11324751872 1884089840 18.698 97 13 26 1 1896679328 9085984 3503504
00:09:57 40668 8192000000 10889693680 11339223040 1950353424 19.229 100 43 86 2 1970871824 7973872 12544528
00:10:45 97235 8192000000 10868557680 11361017856 1934956096 19.106 99 8 16 1 1954469856 17207536 2306224
00:12:28 33799 8192000000 10877337968 11364052992 1948052768 19.211 100 9 18 1 1966741984 16054208 2635008
00:13:08 12962 8192000000 10895811808 11352281088 1960974528 19.314 100 28 54 2 1981794192 12949168 7870496
00:13:36 10672 8192000000 10895861312 11358560256 1973225504 19.411 100 44 88 1 1994000480 8863968 11911008
00:13:53 28588 8192000000 10928932032 11371114496 1973131632 19.410 100 27 54 1 1987692240 7253328 7307280
00:14:30 35985 8192000000 10907033888 11370360832 1974641248 19.422 100 24 48 0 1991885792 10064784 7179760
00:15:12 75728 8192000000 10904048496 11368087552 1951454640 19.238 99 12 25 2 1969012192 13254432 4303120
00:16:38 32306 8192000000 10904172576 11366469632 1972239184 19.403 100 24 48 2 1986147248 7544464 6363600
00:17:16 28211 8192000000 10906874768 11369082880 1971779632 19.400 100 14 28 2 1981501168 6147792 3573744
00:17:51 35928 8192000000 10918536272 11378589696 1982149008 19.482 100 33 66 2 2000471584 9364352 8958224
00:18:42 24077 8192000000 10918039664 11381895168 1981718992 19.478 100 32 64 0 2005034016 14346736 8968288
00:19:12 35992 8192000000 10892288288 11370389504 1941610368 19.160 98 25 51 0 1965641936 16582672 7448896
00:19:55 23409 8192000000 10911511984 11363983360 1951983424 19.242 99 29 58 0 1967844864 7283712 8577728
00:20:25 24160 8192000000 10910868272 11368701952 1972417552 19.405 100 30 60 1 1992047056 11341984 8287520
00:20:58 22616 8192000000 10923808272 11384975360 1978609504 19.454 100 35 70 0 2002813664 14038656 10165504
00:21:28 99898 8192000000 10908130768 11370377216 1905863552 18.873 96 24 46 2 1926067488 13357280 6846656
00:23:16 38500 8192000000 10910176352 11373531136 1975040816 19.425 100 25 50 1 1996505728 14242880 7222032
00:24:04 96467 8192000000 10898991232 11389095936 1900760864 18.832 96 11 22 1 1920873696 17280784 2832048
00:25:46 93255 8192000000 10895004848 11358502912 1926784512 19.041 98 13 26 0 1943992048 14017168 3190368
00:27:28 59464 8192000000 10886805040 11338616832 1899100064 18.819 96 36 72 0 1916728480 7930016 9698400
00:28:41 17413 8192000000 10881621136 11331211264 1923991424 19.019 98 44 88 0 1945994672 9949040 12054208
00:29:10 48362 8192000000 10856247712 11326427136 1914495392 18.943 98 33 64 2 1932904000 9481840 8926768
00:30:04 34483 8192000000 10852816512 11327815680 1911104016 18.916 98 9 18 2 1924877168 10895744 2877408
00:30:55 29383 8192000000 10852074464 11327672320 1922432224 19.006 99 9 18 0 1937619824 12907344 2280256
00:31:31 39000 8192000000 10860619008 11338076160 1938692416 19.136 100 12 24 0 1951466368 9640512 3133440
00:32:16 42105 8192000000 10839676544 11300560896 1838753488 18.331 95 7 13 1 1851317712 11340112 1224112
00:33:07 71779 8192000000 10869797152 11335536640 1898665328 18.816 98 13 26 0 1916223648 14504528 3053792
00:34:30 43753 8192000000 10876836112 11335110656 1891478064 18.758 97 22 44 0 1914114048 15780864 6855120
00:35:22 51510 8192000000 10881279040 11350540288 1914833808 18.945 98 18 36 2 1939096416 18757616 5504992
00:36:20 50705 8192000000 10860138224 11323138048 1891400192 18.757 97 18 36 0 1917196480 20383600 5412688
00:37:49 61184 8192000000 10828625952 11291983872 1837870464 18.323 95 11 21 2 1857176544 15952192 3353888
00:39:19 22797 8192000000 10884153072 11323277312 1903915488 18.858 98 40 80 3 1922397072 7289776 11191808
00:39:57 37401 8192000000 10889912608 11340029952 1925992464 19.035 99 36 71 1 1952525744 16669488 9863792
00:40:43 86425 8192000000 10815391472 11272892416 1790523584 17.936 93 12 24 0 1804784448 10858208 3402656
00:42:15 45430 8192000000 10851105456 11306614784 1867685120 18.566 97 33 66 0 1886629936 9426256 9518560
00:43:07 38394 8192000000 10843145872 11290603520 1844061200 18.374 96 28 56 2 1861176368 9391584 7723584
00:43:54 73810 8192000000 10835278048 11299409920 1846887584 18.397 97 25 50 1 1872352288 18394176 7070528
00:45:23 102725 8192000000 10853669872 11317215232 1852025392 18.439 96 21 42 0 1872984304 15181808 5777104
00:47:12 97102 8192000000 10852164672 11318587392 1905183072 18.868 99 23 46 0 1922337232 10569776 6584384
00:48:55 29073 8192000000 10854221872 11321729024 1931786720 19.081 100 16 32 1 1943580400 7474176 4319504
00:49:31 23162 8192000000 10878228000 11326525440 1941070800 19.155 100 46 92 0 1962752480 8256048 13425632
00:50:00 23560 8192000000 10854623232 11333812224 1926165008 19.036 99 29 58 0 1942499264 8657888 7676368
00:50:37 88548 8192000000 10844731696 11316731904 1888589376 18.734 97 12 24 0 1902625440 10342768 3693296
00:52:16 85349 8192000000 10868716400 11339976704 1919780464 18.985 99 14 28 1 1936998656 12884464 4333728
00:54:17 45754 8192000000 10871001856 11357077504 1941253520 19.157 100 5 10 0 1952328384 9548400 1526464
00:55:10 39523 8192000000 10908917008 11357835264 1956981888 19.282 100 23 45 1 1974510304 10992288 6536128
00:56:03 48328 8192000000 10890928896 11364614144 1959881264 19.305 100 16 32 0 1978608192 14047712 4679216
00:56:58 51190 8192000000 10894422288 11373494272 1953183216 19.252 99 22 43 0 1976229728 17156240 5890272
00:58:00 64577 8192000000 10919713984 11386757120 1973277040 19.411 100 17 34 0 1999251984 21379968 4594976
00:59:11 46372 8192000000 10900968400 11365531648 1971855040 19.400 99 29 58 2 1992787136 12902880 8029216
01:00:04 66161 8192000000 10892508016 11366797312 1896019904 18.794 95 30 60 2 1918454320 13868336 8566080
01:01:18 66967 8192000000 10907162352 11382976512 1953122464 19.251 99 20 40 0 1975147344 16554208 5470672
01:02:32 64134 8192000000 10916299104 11396980736 1982191872 19.482 100 19 38 0 2004173024 16040496 5940656
01:03:56 54832 8192000000 10910230112 11384369152 1948944752 19.218 98 13 26 0 1968921088 16508656 3467680
01:05:01 34247 8192000000 10891722768 11365314560 1945071168 19.187 99 25 50 1 1964048928 11922160 7055600
01:05:42 48279 8192000000 10904159536 11377229824 1970509520 19.389 100 12 24 0 1984443008 11023856 2909632
01:06:44 82093 8192000000 10944501744 11387064320 1953209488 19.252 98 27 54 2 1969619520 8709888 7700144
01:08:16 17718 8192000000 10917117520 11382517760 1973463280 19.413 99 35 68 1 1991560016 8725856 9370880
01:08:51 78976 8192000000 10915542240 11396452352 1991492720 19.556 100 34 68 1 2011019120 9830512 9695888
01:10:22 45947 8192000000 10900914432 11375902720 1974311712 19.420 99 21 42 1 1988883696 8913360 5658624
01:12:51 47386 8192000000 10850970160 11329523712 1870660784 18.590 95 9 18 0 1881419744 8299552 2459408
01:14:35 47366 8192000000 10881300640 11354890240 1958534352 19.294 100 11 23 1 1971706304 10170288 3001664
01:15:29 54232 8192000000 10863673184 11343831040 1921292688 18.997 98 19 38 0 1940945600 13242368 6410544
01:16:29 64796 8192000000 10866721872 11352027136 1913015296 18.931 98 14 28 0 1926920288 9888768 4016224
01:17:45 69381 8192000000 10875593600 11350585344 1882056912 18.682 96 15 28 2 1895418352 9477600 3883840
01:19:09 45756 8192000000 10886401952 11353083904 1907771024 18.889 97 25 50 1 1925068480 9987984 7309472
01:20:03 79986 8192000000 10883100176 11359985664 1905772608 18.873 97 19 38 0 1927724016 16620496 5330912
01:21:37 68591 8192000000 10856406400 11320000512 1841427600 18.352 95 13 26 0 1853757088 8749808 3579680
01:22:57 60349 8192000000 10847998592 11311149056 1864820496 18.542 96 29 58 0 1886378384 12632128 8925760
01:24:04 59175 8192000000 10876449264 11343683584 1928877216 19.058 100 23 46 3 1950169552 14928336 6364000
01:25:09 73251 8192000000 10876788464 11342237696 1927726096 19.049 99 16 32 1 1944276144 12022640 4527408
01:26:40 41945 8192000000 9243998880 9501839360 401648528 4.673 22 5 10 0 405794160 2966448 1179184

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 06-02-2021 01:28:08 to 06-02-2021 01:28:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 110 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-02-2021 01:28:40 to 06-02-2021 01:28:42.

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

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