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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16982380 kB
MemAvailable 31077956 kB
Buffers 0 kB
Cached 14690788 kB
SwapCached 3276 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-27 01:27:18
DTS_END                         2021-02-27 01:27:18.8630
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/42136
TRN_ID                          244438
ATT_ID                          666
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: 9164.48 23055 1099737
customer order: creation 176.63 380 21195
customer order: refuse 15.65 395 1878
order to supplier: creation 47.38 1402 5685
order to supplier: removal 3.38 104311 406
invoice (draft): creation 47.63 3761 5716
invoice (draft): removal 49.96 975 5995
invoice accept: apply 43.88 19774 5266
invoice accept: cancel 44.70 893 5364
customer reserve: creation 4032.22 197 483866
customer reserve: removal 4406.42 62 528770
realization accept: apply 84.43 185 10131
realization accept: cancel 78.43 119 9411
payment from customer: creation 60.98 133 7317
payment from customer: removal 5.88 82 705
payment to supplier: creation 50.47 133 6056
payment to supplier: removal 3.42 118 410
service: total inventory turnovers 5.47 1002 656
service: total monetary turnovers 6.71 37 805
service: aggregate perf. data 0.84 16462 101
service: refresh index statistics 0.03 310684 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4531
TEST_TIME 2 4029
TEST_TIME 3 4958
TEST_TIME 4 6245
TEST_TIME 5 6256
TEST_TIME 6 6165
TEST_TIME 7 6443
TEST_TIME 8 7044
TEST_TIME 9 6948
TEST_TIME 10 6838
TEST_TIME 11 6756
TEST_TIME 12 7246
TEST_TIME 13 7319
TEST_TIME 14 7132
TEST_TIME 15 7133
TEST_TIME 16 7109
TEST_TIME 17 7197
TEST_TIME 18 7195
TEST_TIME 19 7336
TEST_TIME 20 7546
TEST_TIME 21 8100
TEST_TIME 22 8302
TEST_TIME 23 8296
TEST_TIME 24 8284
TEST_TIME 25 8843
TEST_TIME 26 9183
TEST_TIME 27 10307
TEST_TIME 28 10655
TEST_TIME 29 10569
TEST_TIME 30 10390
TEST_TIME 31 10182
TEST_TIME 32 10029
TEST_TIME 33 10050
TEST_TIME 34 10003
TEST_TIME 35 9999
TEST_TIME 36 9946
TEST_TIME 37 9853
TEST_TIME 38 9825
TEST_TIME 39 9879
TEST_TIME 40 9743
TEST_TIME 41 9736
TEST_TIME 42 9694
TEST_TIME 43 9556
TEST_TIME 44 9431
TEST_TIME 45 9451
TEST_TIME 46 9326
TEST_TIME 47 9394
TEST_TIME 48 9336
TEST_TIME 49 9283
TEST_TIME 50 9220
TEST_TIME 51 9185
TEST_TIME 52 9318
TEST_TIME 53 9294
TEST_TIME 54 9346
TEST_TIME 55 9360
TEST_TIME 56 9378
TEST_TIME 57 9590
TEST_TIME 58 9562
TEST_TIME 59 9581
TEST_TIME 60 9635
TEST_TIME 61 9716
TEST_TIME 62 9643
TEST_TIME 63 9571
TEST_TIME 64 9507
TEST_TIME 65 9498
TEST_TIME 66 9465
TEST_TIME 67 9421
TEST_TIME 68 9422
TEST_TIME 69 9385
TEST_TIME 70 9418
TEST_TIME 71 9430
TEST_TIME 72 9401
TEST_TIME 73 9383
TEST_TIME 74 9504
TEST_TIME 75 9481
TEST_TIME 76 9498
TEST_TIME 77 9527
TEST_TIME 78 9590
TEST_TIME 79 9542
TEST_TIME 80 9612
TEST_TIME 81 9673
TEST_TIME 82 9585
TEST_TIME 83 9571
TEST_TIME 84 9528
TEST_TIME 85 9543
TEST_TIME 86 9518
TEST_TIME 87 9480
TEST_TIME 88 9420
TEST_TIME 89 9406
TEST_TIME 90 9349
TEST_TIME 91 9345
TEST_TIME 92 9341
TEST_TIME 93 9329
TEST_TIME 94 9351
TEST_TIME 95 9342
TEST_TIME 96 9424
TEST_TIME 97 9403
TEST_TIME 98 9416
TEST_TIME 99 9486
TEST_TIME 100 9487
TEST_TIME 101 9490
TEST_TIME 102 9479
TEST_TIME 103 9496
TEST_TIME 104 9489
TEST_TIME 105 9506
TEST_TIME 106 9520
TEST_TIME 107 9447
TEST_TIME 108 9431
TEST_TIME 109 9388
TEST_TIME 110 9371
TEST_TIME 111 9353
TEST_TIME 112 9307
TEST_TIME 113 9262
TEST_TIME 114 9272
TEST_TIME 115 9226
TEST_TIME 116 9196
TEST_TIME 117 9265
TEST_TIME 118 9270
TEST_TIME 119 9231
TEST_TIME 120 9169

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1546954 1546954 0 0.00 0 20059 7 0 0
doc_list_biud 1546930 1546930 0 0.00 0 30737 28 0 0
sp_add_invoice_to_stock 5396 5266 130 2.40 27 209232 19774 0 130
sp_cancel_adding_invoice 5364 5364 0 0.00 5 84854 893 0 0
sp_cancel_client_order 1878 1878 0 0.00 4 11645 395 0 0
sp_cancel_customer_reserve 528770 528770 0 0.00 1 30528 62 0 0
sp_cancel_pay_from_customer 705 705 0 0.00 3 2740 82 0 0
sp_cancel_pay_to_supplier 410 410 0 0.00 3 5817 118 0 0
sp_cancel_supplier_invoice 6000 5995 5 0.08 2 25765 975 0 5
sp_cancel_supplier_order 406 406 0 0.00 7 1215335 104312 0 0
sp_cancel_write_off 9411 9411 0 0.00 1 16657 120 0 0
sp_client_order 21195 21195 0 0.00 3 27499 380 0 0
sp_customer_reserve 483866 483866 0 0.00 0 37895 198 0 0
sp_fill_shopping_cart 32583 32583 0 0.00 1 11191 37 0 0
sp_fill_shopping_cart_clo_res 483857 483857 0 0.00 0 12368 13 0 0
sp_get_clo_for_invoice 5256 5256 0 0.00 0 26363 290 0 0
sp_kill_cost_storno 15890 15890 0 0.00 0 13319 62 0 0
sp_kill_qstorno_ret_qs2qd 1073352 1073352 0 0.00 0 30526 34 0 0
sp_kill_qty_storno 567205 567205 0 0.00 0 30737 74 0 0
sp_lock_selected_doc 21407 21407 0 0.00 0 8861 7 0 0
sp_make_cost_storno 28760 28760 0 0.00 0 11579 58 0 0
sp_multiply_rows_for_pdistr 28756 28756 0 0.00 0 11781 29 0 0
sp_multiply_rows_for_qdistr 21195 21195 0 0.00 0 10746 160 0 0
sp_pay_from_customer 7317 7317 0 0.00 4 11792 133 0 0
sp_pay_to_supplier 6056 6056 0 0.00 5 21918 134 0 0
sp_payment_common 13363 13363 0 0.00 1 6160 26 0 0
sp_qd_handle_on_cancel_clo 1878 1878 0 0.00 0 11638 361 0 0
sp_qd_handle_on_invoice_upd_sts 10616 10616 0 0.00 0 30735 336 0 0
sp_qd_handle_on_reserve_upd_sts 10129 10129 0 0.00 0 25470 66 0 0
sp_reserve_write_off 10131 10131 0 0.00 6 25480 186 0 0
sp_supplier_invoice 5716 5716 0 0.00 6 93509 3762 0 0
sp_supplier_order 5685 5685 0 0.00 5 42708 1403 0 0
srv_aggregate_perf_data 102 101 1 0.98 2504 131471 16462 0 1
srv_fill_mon_cache_memory 182 182 0 0.00 1440 141787 28739 0 0
srv_find_qd_qs_mism 1049839 1049839 0 0.00 0 20059 6 0 0
srv_make_invnt_saldo 656 656 0 0.00 29 83075 1003 0 0
srv_make_money_saldo 805 805 0 0.00 1 8124 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 160230 463477 310685 0 0
t$perf-abend:sp_add_invoice_to_stock 130 130 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 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 5266 5266 0 0.00 0 15931 189 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 0 3869 113 0 0
t$perf-norm:sp_cancel_client_order 1878 1878 0 0.00 0 5787 13 0 0
t$perf-norm:sp_cancel_customer_reserve 691 691 0 0.00 0 8977 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 705 705 0 0.00 0 1454 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 410 410 0 0.00 0 1140 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 440 440 0 0.00 0 2270 23 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 30827 1632 0 0
t$perf-norm:sp_cancel_write_off 1065 1065 0 0.00 0 5177 14 0 0
t$perf-norm:sp_client_order 21195 21195 0 0.00 0 10604 20 0 0
t$perf-norm:sp_customer_reserve 1057 1057 0 0.00 0 5068 9 0 0
t$perf-norm:sp_pay_from_customer 7317 7317 0 0.00 0 6019 11 0 0
t$perf-norm:sp_pay_to_supplier 6056 6056 0 0.00 0 5404 12 0 0
t$perf-norm:sp_reserve_write_off 10131 10131 0 0.00 0 13007 16 0 0
t$perf-norm:sp_supplier_invoice 5716 5716 0 0.00 0 9286 20 0 0
t$perf-norm:sp_supplier_order 5685 5685 0 0.00 0 5682 20 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 432 23 0 0
t$perf-norm:srv_fill_mon_cache_memory 182 182 0 0.00 0 8474 61 0 0
t$perf-norm:srv_make_invnt_saldo 656 656 0 0.00 0 1134 25 0 0
t$perf-norm:srv_make_money_saldo 805 805 0 0.00 0 923 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 45 13 0 0
v_add_invoice_to_stock 10762 10502 260 2.41 0 7028 22 0 260
v_all_customers 38524 38524 0 0.00 0 99 1 0 0
v_all_suppliers 31142 31142 0 0.00 0 18 1 0 0
v_all_wares 42386 42386 0 0.00 0 168 1 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 6303 15 0 0
v_cancel_client_order 3756 3756 0 0.00 0 5530 7 0 0
v_cancel_customer_prepayment 1410 1410 0 0.00 0 2719 9 0 0
v_cancel_customer_reserve 1382 1382 0 0.00 0 2693 6 0 0
v_cancel_payment_to_supplier 820 820 0 0.00 0 5203 22 0 0
v_cancel_supplier_invoice 890 880 10 1.12 0 5450 24 0 10
v_cancel_supplier_order 812 812 0 0.00 0 464 5 0 0
v_cancel_write_off 2130 2130 0 0.00 0 2466 14 0 0
v_max_id_clo_ord 5678 5678 0 0.00 0 3869 3 0 0
v_max_id_clo_res 1057 1057 0 0.00 0 3251 12 0 0
v_max_id_ord_sup 5711 5711 0 0.00 0 2552 2 0 0
v_max_non_paid_invoice 1870 1870 0 0.00 0 2515 4 0 0
v_max_non_paid_realizn 3963 3963 0 0.00 0 1416 4 0 0
v_min_id_clo_ord 5678 5678 0 0.00 0 1772 5 0 0
v_min_id_clo_res 1057 1057 0 0.00 0 1951 8 0 0
v_min_id_ord_sup 5711 5711 0 0.00 0 5137 5 0 0
v_min_non_paid_invoice 6052 6052 0 0.00 0 4683 15 0 0
v_min_non_paid_realizn 7311 7311 0 0.00 0 4695 15 0 0
v_our_firm 10558 10558 0 0.00 0 19 1 0 0
v_reserve_write_off 20258 20258 0 0.00 0 3595 5 0 0
x_lock_depdocs_on_canc_invoice 10919 10919 0 0.00 0 16040 135 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 10300 357 0 0
x_make_qstorno_1000_1200 5685 5685 0 0.00 1 42605 1317 0 0
x_make_qstorno_1200_2000 5716 5716 0 0.00 2 93432 3637 0 0
x_make_qstorno_2100_3300 483866 483866 0 0.00 0 37894 182 0 0

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

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:22 5 8192000000 8804374016 8816398336 10012288 0.122 2 2 3 0 10190720 66144 112288
22:57:28 25188 8192000000 10277650144 10586238976 986534448 10.748 76 62 126 0 1009923440 2760064 20628928
22:58:01 20791 8192000000 10333791536 10648883200 1389424400 14.501 100 90 181 0 1423262704 5114944 28723360
22:58:31 23061 8192000000 10380124080 10698956800 1423504752 14.804 100 85 170 0 1456771616 5997680 27269184
22:59:17 27856 8192000000 10409637504 10733264896 1456337520 15.094 100 89 179 0 1492313632 7196800 28779312
23:00:01 22628 8192000000 10435996208 10764619776 1490290864 15.391 100 91 183 0 1526698576 7751888 28655824
23:00:33 17830 8192000000 10448190016 10779381760 1500990304 15.485 100 88 176 0 1537373920 8201344 28182272
23:00:58 17146 8192000000 10458378336 10790825984 1515450848 15.611 100 92 185 0 1553161008 8642176 29067984
23:01:23 17225 8192000000 10469130864 10808311808 1526814304 15.709 100 85 170 0 1562645216 9428480 26402432
23:01:52 12055 8192000000 10489769088 10834333696 1546950128 15.884 100 75 151 1 1578948592 8848496 23149968
23:02:19 20116 8192000000 10544931472 10897612800 1588131920 16.238 100 71 142 1 1618797280 8844096 21821264
23:02:49 17333 8192000000 10575840448 10936221696 1633634688 16.626 100 74 148 0 1666000496 10059120 22306688
23:03:17 12434 8192000000 10602090240 10964475904 1655136960 16.808 100 74 148 0 1688040544 11227552 21676032
23:03:37 7324 8192000000 10618475424 10982678528 1675791520 16.982 100 73 144 0 1708112160 11418672 20901968
23:03:56 9242 8192000000 10633256064 11005034496 1695339616 17.146 100 75 148 3 1727967408 11388720 21239072
23:04:12 7918 8192000000 10651294512 11021848576 1711687584 17.283 100 77 154 0 1746028208 11850336 22490288
23:04:31 8273 8192000000 10667376160 11038035968 1729733232 17.433 100 81 162 1 1764539536 11563104 23243200
23:04:47 7433 8192000000 10679099600 11053735936 1738240656 17.504 100 75 150 0 1772006256 12179424 21586176
23:05:06 7429 8192000000 10688193552 11065925632 1750033504 17.602 100 76 152 1 1784348480 12696416 21618560
23:05:22 3488 8192000000 10702108656 11080667136 1769667424 17.764 100 85 167 1 1805785216 12493248 23624544
23:05:33 4978 8192000000 10714347040 11092213760 1775864192 17.815 100 82 164 2 1811707520 13335568 22507760
23:05:46 4750 8192000000 10727647120 11102928896 1784051632 17.883 100 88 175 0 1823833968 15071696 24710640
23:05:57 6450 8192000000 10721966000 11105574912 1785979840 17.899 100 79 158 0 1822490960 14037920 22473200
23:06:11 3082 8192000000 10742218592 11118858240 1801226864 18.024 100 82 162 0 1837201952 13189984 22785104
23:06:22 3937 8192000000 10736600848 11123937280 1802017296 18.030 100 83 166 3 1838312784 13264304 23031184
23:06:34 3604 8192000000 10753081072 11131654144 1810656752 18.101 100 83 166 1 1846306672 13015200 22634720
23:06:45 2613 8192000000 10750083568 11135926272 1811055600 18.105 100 76 153 1 1844914880 12177392 21681888
23:06:54 10009 8192000000 10752034304 11141120000 1817808816 18.160 100 74 148 1 1851460720 12796416 20855488
23:07:12 3434 8192000000 10776444288 11160453120 1822112448 18.195 100 79 159 1 1857340672 13216624 22011600
23:07:22 2304 8192000000 10784375328 11169554432 1840366736 18.344 100 90 176 0 1878804368 14196624 24241008
23:07:30 2766 8192000000 10779732672 11167072256 1839600224 18.338 100 81 162 3 1875173056 13134224 22438608
23:07:40 2519 8192000000 10785452224 11169456128 1841369520 18.352 100 86 172 1 1879903664 14244240 24289904
23:07:49 1963 8192000000 10797667744 11182690304 1850500560 18.426 100 91 182 0 1890874896 15663328 24711008
23:07:57 1411 8192000000 10789214880 11176837120 1853835248 18.453 100 88 176 1 1893633152 14811728 24986176
23:08:05 2267 8192000000 10805046624 11188998144 1853883024 18.454 100 92 184 1 1893102112 13660912 25558176
23:08:14 1436 8192000000 10802409744 11187564544 1860912592 18.511 100 93 186 1 1900812752 13919648 25980512
23:08:22 2070 8192000000 10810177136 11195539456 1862304528 18.522 100 96 194 2 1902183056 12842160 27036368
23:08:30 1293 8192000000 10802904320 11192733696 1863186896 18.529 100 90 178 0 1902390336 13618448 25584992
23:08:38 2025 8192000000 10813202192 11198824448 1866520096 18.556 100 89 180 0 1904505520 13181040 24804384
23:08:47 17751 8192000000 10810005312 11203698688 1869107584 18.577 100 80 156 4 1904223584 12360304 22755696
23:09:11 23245 8192000000 10782613984 11193720832 1864564208 18.540 100 52 104 1 1890098128 10980480 14553440
23:09:42 7679 8192000000 10796429472 11202318336 1864366144 18.539 100 39 78 0 1883092544 7394160 11332240
23:09:56 7139 8192000000 10774620192 11197493248 1866908880 18.559 100 31 61 1 1882861968 7020960 8932128
23:10:11 6008 8192000000 10780280784 11206500352 1868329312 18.571 100 23 46 1 1886063216 11183776 6550128
23:10:25 8837 8192000000 10785724896 11209052160 1875724528 18.631 100 35 71 2 1893857872 7841472 10291872
23:10:43 4581 8192000000 10794984240 11216711680 1876410592 18.636 100 34 68 0 1893411680 7357616 9643472
23:10:55 10767 8192000000 10782436816 11217137664 1877270928 18.643 100 21 42 1 1893898080 10740496 5886656
23:11:12 7854 8192000000 10791102016 11219341312 1882618496 18.686 100 32 66 1 1898434624 6215344 9600784
23:11:28 6079 8192000000 10790806352 11218567168 1881673376 18.679 100 25 50 1 1894871408 6485936 6712096
23:11:42 10332 8192000000 10784372288 11221995520 1885752976 18.712 100 14 28 0 1895651440 5498960 4399504
23:12:04 8966 8192000000 10788336816 11224879104 1887932832 18.729 100 22 44 1 1900195712 5943216 6319664
23:12:19 13368 8192000000 10801056848 11228217344 1892661904 18.767 100 27 51 3 1905315376 5549376 7104096
23:12:44 6720 8192000000 10817524864 11240300544 1900541888 18.831 100 30 60 1 1916499216 7923904 8033424
23:12:59 16095 8192000000 10807835232 11234177024 1901389008 18.837 100 25 50 1 1914724336 5178784 8156544
23:13:53 25941 8192000000 10852883168 11259445248 1906820528 18.881 100 59 119 1 1929289728 5209728 17259472
23:14:25 7126 8192000000 10821293744 11253903360 1903144912 18.852 100 29 58 1 1922843616 12152960 7545744
23:14:38 4117 8192000000 10832165312 11255185408 1907983488 18.890 100 42 84 1 1927912800 8878928 11050384
23:14:50 8391 8192000000 10829593136 11259121664 1904770864 18.865 100 36 71 5 1922285184 7446672 10067648
23:15:09 4989 8192000000 10833414288 11258232832 1908951888 18.898 100 37 72 3 1926054784 5951104 11151792
23:15:20 4773 8192000000 10825270064 11250991104 1890347008 18.749 99 42 84 3 1909172320 6418080 12407232
23:15:32 6333 8192000000 10822966288 11251355648 1901333472 18.837 100 29 59 1 1915801488 6207936 8260080
23:15:47 4343 8192000000 10830959184 11259084800 1905074864 18.867 100 24 48 1 1918540480 6163616 7302000
23:15:59 7878 8192000000 10822700928 11259940864 1912760464 18.929 100 36 72 2 1930952336 6811456 11380416
23:16:19 9522 8192000000 10808952464 11251007488 1903677712 18.856 100 27 52 1 1917709712 6582048 7449952
23:16:35 9993 8192000000 10809163376 11244695552 1881558480 18.678 99 16 32 0 1895209504 9560048 4090976
23:16:53 9098 8192000000 10793522848 11224821760 1828731152 18.249 96 26 52 1 1842068592 5750416 7587024
23:17:12 8492 8192000000 10800419920 11230707712 1885079552 18.706 100 24 48 2 1898437424 5950752 7407120
23:17:27 8998 8192000000 10774462208 11208888320 1831028032 18.268 97 19 37 2 1843024352 6400704 5595616
23:17:48 13101 8192000000 10773149872 11206062080 1839982912 18.341 98 25 50 4 1852303568 5035968 7284688
23:18:12 72161 8192000000 10756071424 11180232704 1710640704 17.274 91 28 56 2 1722905904 4864176 7401024
23:19:31 8450 8192000000 10743094704 11166048256 1748926192 17.593 94 26 52 0 1762075440 5567008 7582240
23:19:45 6288 8192000000 10754721200 11170140160 1792537344 17.953 97 44 89 2 1811472112 6708352 12226416
23:19:57 4750 8192000000 10755288112 11167842304 1804547680 18.051 98 45 88 5 1825226304 8506976 12171648
23:20:09 5993 8192000000 10730281264 11143458816 1775726832 17.814 97 30 59 3 1790045968 6016864 8302272
23:20:22 4666 8192000000 10746710576 11158171648 1802322544 18.033 99 30 60 1 1817923856 7145328 8455984
23:20:38 3675 8192000000 10715173952 11122872320 1764112928 17.718 98 31 62 0 1780284128 7182128 8989072
23:20:51 3114 8192000000 10688814160 11103617024 1736137712 17.487 96 40 80 2 1752636720 5011712 11487296
23:21:02 6507 8192000000 10720152336 11136495616 1784269376 17.885 99 25 49 1 1797009584 5740976 6999232
23:21:16 9697 8192000000 10732142336 11149598720 1793410496 17.960 99 24 49 0 1807035200 6629136 6995568
23:21:34 2491 8192000000 10724764960 11132366848 1803027488 18.039 100 30 58 3 1818244288 6493184 8723616
23:21:44 3955 8192000000 10721814208 11135975424 1777749248 17.831 98 30 58 0 1791702896 5802448 8151200
23:21:54 8879 8192000000 10703205888 11112026112 1765509232 17.730 98 16 31 1 1775418416 5252944 4656240
23:22:10 9468 8192000000 10710001152 11126902784 1767236080 17.744 98 28 56 2 1781387472 5585744 8565648
23:22:27 6687 8192000000 10730481104 11148558336 1814434576 18.132 100 34 68 1 1831198384 6538064 10225744
23:22:44 71033 8192000000 10733924976 11159490560 1803167936 18.040 99 29 58 2 1816237840 4811920 8257984
23:24:05 9691 8192000000 10758665712 11174191104 1817134320 18.154 99 22 44 1 1828953376 6019008 5800048
23:24:21 4152 8192000000 10771447808 11187621888 1846875312 18.397 100 40 81 0 1866081520 7996848 11209360
23:24:31 4106 8192000000 10769931360 11190575104 1847911312 18.405 100 29 56 2 1862544080 6787040 7845728
23:24:43 4088 8192000000 10761437248 11190181888 1849103392 18.415 100 27 54 0 1863470592 6998096 7369104
23:24:54 6176 8192000000 10778780624 11193274368 1852985552 18.446 100 34 69 3 1868212976 5656416 9571008
23:25:07 7747 8192000000 10770720640 11198914560 1855485808 18.467 100 31 60 0 1870116816 6116304 8514704
23:25:22 8939 8192000000 10761954320 11195129856 1856939296 18.478 100 28 56 1 1870636688 5196080 8501312
23:25:37 8742 8192000000 10775536176 11200983040 1857399456 18.482 100 17 34 1 1867922640 5350912 5172272
23:25:52 5361 8192000000 10776306384 11205869568 1862378992 18.523 100 28 56 1 1876938144 6719344 7839808
23:26:06 8965 8192000000 10781922672 11213631488 1864894896 18.543 100 26 52 0 1882741152 10473920 7372336
23:26:21 9200 8192000000 10775224704 11211034624 1867003408 18.560 100 15 30 1 1876748768 5110720 4634640
23:26:41 5565 8192000000 10790001776 11222675456 1878687120 18.655 100 13 26 0 1887988848 5646192 3655536
23:26:53 7460 8192000000 10797674240 11227250688 1881111152 18.674 100 25 51 1 1894967184 6148880 7707152
23:27:12 13174 8192000000 10834953552 11251417088 1899219600 18.820 100 25 48 2 1910640352 4857920 6562832
23:28:21 52428 8192000000 10853666416 11276640256 1918742656 18.977 100 52 104 1 1940401104 7169472 14488976
23:29:23 26702 8192000000 10863326432 11291009024 1929739280 19.065 100 51 100 1 1953550192 9348464 14462448
23:29:56 7267 8192000000 10869929872 11296403456 1937333632 19.125 100 55 110 2 1963368768 10373952 15661184
23:30:11 8271 8192000000 10876827328 11301462016 1942242624 19.165 100 58 116 1 1968803280 10542768 16017888
23:30:27 8472 8192000000 10871409424 11304419328 1944427328 19.182 100 47 94 3 1966622112 8404032 13790752
23:30:44 33668 8192000000 10876947440 11305246720 1934909952 19.106 99 55 110 2 1964102272 13514144 15678176
23:31:25 7470 8192000000 10877180128 11291443200 1930327280 19.069 99 58 115 1 1961541264 15302192 15911792
23:31:40 10255 8192000000 10893098512 11310354432 1946356864 19.197 100 70 138 1 1982115248 15774784 19983600
23:31:57 2131 8192000000 10902040080 11318841344 1956054576 19.275 100 77 153 2 1992112576 12881664 23176336
23:32:05 13279 8192000000 10897602528 11319980032 1952439824 19.246 100 68 136 0 1985696944 14554480 18702640
23:32:30 4790 8192000000 10908861472 11326832640 1957823904 19.289 100 74 148 0 1993449728 15371824 20254000
23:32:41 1578 8192000000 10920582784 11334344704 1968110304 19.370 100 85 169 3 2006691648 15735776 22845568
23:32:51 13488 8192000000 10918527792 11339862016 1970223744 19.387 100 70 138 1 2005506688 15637680 19645264
23:33:12 19086 8192000000 10914306000 11337973760 1969286192 19.380 100 64 130 0 2001857936 15310608 17261136
23:33:38 15498 8192000000 10912592848 11342213120 1967133664 19.363 100 63 126 2 2005173792 20153296 17886832
23:34:07 22584 8192000000 10896323200 11332161536 1951004768 19.234 99 55 110 1 1985064672 18267488 15792416
23:34:40 6216 8192000000 10910713648 11344121856 1970003088 19.385 100 46 92 2 2004172704 20377920 13791696
23:34:54 5885 8192000000 10923092368 11346227200 1971783968 19.400 100 62 124 1 2010395680 19480864 19130848
23:35:09 6343 8192000000 10911857776 11350110208 1974896912 19.424 100 56 110 4 2011472128 19835312 16739904
23:35:25 4111 8192000000 10928280240 11345170432 1972341248 19.404 100 67 132 3 2014167808 21942256 19884304
23:35:40 5187 8192000000 10946362432 11360690176 1982045184 19.481 100 72 146 0 2023653616 20574976 21033456
23:35:53 2922 8192000000 10916439248 11323650048 1946995152 19.203 98 87 173 2 1991550560 19371840 25183568
23:36:02 11778 8192000000 10936631024 11355533312 1980324704 19.467 100 81 158 1 2025037200 22057664 22654832
23:36:23 11841 8192000000 10939412912 11360043008 1980950048 19.472 100 72 143 1 2023696640 22235344 20511248
23:36:43 7983 8192000000 10937268640 11363786752 1985805680 19.511 100 69 138 2 2028433984 22256192 20372112
23:37:01 16799 8192000000 10946738496 11377266688 1993700960 19.573 100 74 145 2 2040250768 24819424 21730384
23:37:25 4490 8192000000 10955478448 11378995200 1996336480 19.594 100 59 119 2 2037952000 24408848 17206672
23:37:37 10848 8192000000 10940387344 11372273664 1976966848 19.441 99 56 112 0 2017829712 24275648 16587216
23:37:58 11850 8192000000 10939576352 11374338048 1983127152 19.489 100 58 116 1 2031335840 30592624 17616064
23:38:19 13766 8192000000 10936138688 11371065344 1983093552 19.489 100 57 113 3 2027568736 27398768 17076416
23:38:46 4956 8192000000 10951188688 11377233920 1984186848 19.498 100 58 117 1 2034336048 31701072 18448128
23:39:04 10888 8192000000 10930177392 11362320384 1948204096 19.212 98 57 114 2 1995156752 29704224 17248432
23:39:22 3172 8192000000 10942815840 11369816064 1978758016 19.455 100 61 122 1 2028502160 29220608 20523536
23:39:34 9987 8192000000 10943988400 11370369024 1966905904 19.361 99 57 113 1 2015800016 30750576 18143536
23:39:52 13586 8192000000 10915801216 11344773120 1957802464 19.289 99 57 113 1 2005396832 29868736 17725632
23:40:16 4003 8192000000 10951611344 11373768704 1982458304 19.484 100 57 111 2 2029656256 30214976 16982976
23:40:28 5824 8192000000 10916038000 11342405632 1940974064 19.155 98 66 132 2 1995672720 34232080 20466576
23:40:41 6740 8192000000 10934633616 11356110848 1955344304 19.269 99 67 132 1 2003308352 28398736 19565312
23:40:55 10080 8192000000 10931722640 11354157056 1966384384 19.357 100 64 129 1 2015630640 30361216 18885040
23:41:12 4019 8192000000 10941188256 11367841792 1979256160 19.459 100 67 134 0 2030665792 31142144 20267488
23:41:33 9597 8192000000 10953952960 11382378496 1985499168 19.508 100 65 130 1 2036455984 30665088 20291728
23:41:50 7078 8192000000 10952302912 11383046144 1988715120 19.534 100 59 116 0 2042760256 35901616 18143520
23:42:08 2698 8192000000 10948545248 11360063488 1953349792 19.253 98 76 152 0 2013779968 37212768 23217408
23:42:18 4461 8192000000 10969879200 11384934400 1986850752 19.519 100 81 162 0 2051815984 39384224 25581008
23:42:30 2412 8192000000 10978374576 11390517248 1991728768 19.557 100 89 174 2 2057905696 39154608 27022320
23:42:39 5281 8192000000 10979313840 11397644288 1999151744 19.616 100 67 134 1 2059550176 39563600 20834832
23:42:52 1471 8192000000 10986591536 11397140480 1998433696 19.610 100 92 184 0 2066918992 39717152 28768144
23:43:01 2478 8192000000 10997311952 11406966784 1990647168 19.549 99 90 178 1 2057590544 40135616 26807760
23:43:11 1687 8192000000 10988934256 11405893632 2003866224 19.653 100 85 170 0 2072141104 41707200 26567680
23:43:22 3133 8192000000 10987773984 11404480512 2004053936 19.655 100 84 168 1 2072044176 42103552 25886688
23:43:32 2922 8192000000 10993625792 11410604032 2005668896 19.667 100 77 153 1 2071698672 42066752 23963024
23:43:42 3296 8192000000 10978965072 11395072000 1982063136 19.481 99 76 152 1 2047055360 41590704 23401520
23:43:55 6200 8192000000 10978926624 11399188480 1981501088 19.477 99 74 143 3 2047411952 43324944 22585920
23:44:12 3530 8192000000 10994098144 11408707584 2001298976 19.633 100 83 166 1 2075185040 46943648 26942416
23:44:23 3283 8192000000 10996674112 11407773696 1998902000 19.614 100 90 180 2 2075138320 47853552 28382768
23:44:33 1888 8192000000 10996639088 11409076224 2002315696 19.641 100 79 155 2 2075458288 48771712 24370880
23:44:43 2198 8192000000 10997832608 11411582976 2001924032 19.638 100 75 151 0 2074749520 48933728 23891760
23:44:55 5622 8192000000 11001833376 11418292224 2011419600 19.713 100 78 156 0 2083766432 48299664 24047168
23:45:09 8580 8192000000 10966995136 11386265600 1966432304 19.357 99 69 138 0 2038353952 49100272 22821376
23:45:25 3606 8192000000 10974924144 11391057920 1967700608 19.367 99 76 152 2 2043109584 50967744 24441232
23:45:38 2289 8192000000 10964593216 11383775232 1964009088 19.338 99 71 142 1 2039381184 51492624 23879472
23:45:50 1450 8192000000 10964588704 11374497792 1963317632 19.332 100 86 171 0 2043796096 53096736 27381728
23:46:01 2685 8192000000 10986476144 11392327680 1975597648 19.430 100 84 168 0 2056656144 53359920 27698576
23:46:10 5484 8192000000 10959107584 11367686144 1956370832 19.277 99 83 166 2 2036435184 53027040 27037312
23:46:25 3984 8192000000 10974656640 11385786368 1974712208 19.423 100 87 170 2 2055658912 53411264 27535440
23:46:37 2504 8192000000 10977165968 11390832640 1968175440 19.371 99 89 176 2 2049317328 54040224 27101664
23:46:46 2646 8192000000 10970156224 11382591488 1964332800 19.340 99 88 177 1 2046719904 54584048 27803056
23:46:56 4752 8192000000 10986149632 11400048640 1983885760 19.495 100 89 178 1 2069133952 55837872 29410320
23:47:08 1955 8192000000 10981388784 11403046912 1985191680 19.506 100 80 160 2 2066119024 55128112 25799232
23:47:22 1439 8192000000 10986771824 11398701056 1971177760 19.395 99 87 173 1 2054617440 55997792 27441888
23:47:31 2301 8192000000 10974983280 11389042688 1974374336 19.420 100 86 174 0 2057540432 55664208 27501888
23:47:41 1703 8192000000 10978079152 11386155008 1969718928 19.383 100 86 170 0 2053447360 56924416 26804016
23:47:49 3136 8192000000 10956895920 11367305216 1956867088 19.281 99 82 164 0 2040977280 57336400 26773792
23:48:00 1611 8192000000 10987014608 11397210112 1978347392 19.452 100 86 174 0 2064297440 58329776 27620272
23:48:09 2058 8192000000 10980130800 11392909312 1975836336 19.432 100 86 170 0 2062388272 57964800 28587136
23:48:18 3433 8192000000 10983467840 11402682368 1984909792 19.504 100 82 163 0 2067144464 56326672 25908000
23:48:30 8989 8192000000 10965339984 11390394368 1973651136 19.414 100 63 126 4 2045189680 50219040 21319504
23:48:48 5967 8192000000 10958471408 11390148608 1976485904 19.437 100 50 100 0 2041011008 48240352 16284752
23:49:04 8685 8192000000 10959956912 11395354624 1980066432 19.465 100 48 96 0 2044490016 48540832 15882752
23:49:20 14001 8192000000 10953757088 11389308928 1957879488 19.289 99 38 76 0 2017346272 46778192 12688592
23:49:42 1500 8192000000 10973414928 11387154432 1976297360 19.435 100 85 168 1 2047902128 45376480 26228288
23:49:51 3925 8192000000 10938949824 11367383040 1958694816 19.296 100 53 105 0 2022916192 47556608 16664768
23:50:01 4471 8192000000 10941160272 11376939008 1962754848 19.328 100 43 86 2 2027539760 50864224 13920688
23:50:16 4146 8192000000 10938018784 11366572032 1961247440 19.316 100 58 114 2 2025412704 45752608 18412656
23:50:35 10906 8192000000 10932116736 11365269504 1952868976 19.249 100 42 81 1 2013832544 47713600 13249968
23:50:53 4635 8192000000 10935859536 11371974656 1953348624 19.253 100 39 78 1 2016650272 49467104 13834544
23:51:04 14311 8192000000 10922411536 11361071104 1926893008 19.042 99 32 64 2 1991477552 52704416 11880128
23:51:28 20613 8192000000 10936275232 11371761664 1933561712 19.095 99 40 80 0 2006818336 58794800 14461824
23:51:56 16030 8192000000 10925422672 11375681536 1926910416 19.042 99 32 62 3 1999845344 60761632 12173296
23:52:20 21594 8192000000 10924600512 11365351424 1919115456 18.980 99 30 60 1 1987647408 57667936 10864016
23:53:10 30146 8192000000 10908715840 11368652800 1935073392 19.107 100 23 46 0 2004652432 60159920 9419120
23:53:47 58040 8192000000 10899155200 11366739968 1924525808 19.023 99 22 44 1 1980018144 46713504 8778832
23:54:52 31681 8192000000 10866569856 11330576384 1903667808 18.856 98 20 40 0 1927594336 17593536 6332992
23:55:38 35368 8192000000 10882621328 11332313088 1922059520 19.003 99 8 16 0 1936643056 12362192 2221344
23:56:33 63800 8192000000 10874140096 11328970752 1921623744 19.000 99 17 35 0 1937399744 11496400 4279600
23:57:48 65622 8192000000 10893281488 11345293312 1945961648 19.194 99 21 42 1 1958768320 7121376 5685296
23:59:00 41430 8192000000 10897753632 11338829824 1948738224 19.216 99 48 96 2 1968585824 5826352 14021248
23:59:48 36610 8192000000 10867210320 11311493120 1905571872 18.871 97 37 71 3 1921867952 6537552 9758528
00:00:34 39322 8192000000 10898526880 11354095616 1927817168 19.049 98 32 64 1 1944957904 8488144 8652592
00:01:33 86306 8192000000 10882051376 11355787264 1938494480 19.135 98 33 64 4 1959464304 10508000 10461824
00:03:22 23437 8192000000 10889619936 11353804800 1964200160 19.339 100 11 22 0 1977275952 9848128 3227664
00:03:51 7983 8192000000 10911809248 11362963456 1978566880 19.453 100 34 69 1 1997291120 9235344 9488896
00:04:08 3683 8192000000 10907090352 11358220288 1975202736 19.427 100 35 70 0 1996016256 10689392 10124128
00:04:21 40705 8192000000 10926037568 11366293504 1983471216 19.492 100 47 93 1 2007351840 8873152 15007472
00:05:12 39192 8192000000 10908877984 11351953408 1940988976 19.155 98 24 47 2 1957239008 8169536 8080496
00:05:57 30322 8192000000 10896113872 11366072320 1980988256 19.473 100 47 95 1 2002106464 6875296 14242912
00:06:34 29912 8192000000 10897787696 11377836032 1983293072 19.491 100 26 52 0 2000151216 9218032 7640112
00:07:11 29329 8192000000 10915635456 11378479104 1985162880 19.506 100 20 40 1 1998853696 8160016 5530800
00:07:54 41143 8192000000 10904801760 11382960128 1992563568 19.564 100 17 34 1 2005469904 7942512 4963824
00:09:52 40279 8192000000 10856090464 11317252096 1885971472 18.713 95 14 28 1 1900362384 10283152 4107760
00:10:44 63587 8192000000 10878569712 11347185664 1948187040 19.212 99 16 32 0 1962174496 9070848 4916608
00:11:54 47421 8192000000 10899372528 11363516416 1965467424 19.349 100 28 56 1 1990392736 16394112 8531200
00:12:51 59668 8192000000 10877925248 11329429504 1907515776 18.887 97 35 70 2 1927298496 10209120 9573600
00:13:59 15835 8192000000 10878881024 11334643712 1948427600 19.214 100 41 82 0 1970764912 10945056 11392256
00:14:30 39320 8192000000 10895749408 11355742208 1946747424 19.201 99 21 42 2 1959836464 7459600 5629440
00:15:22 66192 8192000000 10878889136 11367460864 1969593904 19.382 100 16 32 0 1983391040 9078016 4719120
00:16:46 54184 8192000000 10867415056 11344506880 1895846240 18.793 96 5 10 1 1905392784 8045296 1501248
00:17:51 18138 8192000000 10906595840 11356815360 1954915040 19.266 99 48 96 2 1976920704 7479760 14525904
00:18:15 35549 8192000000 10895532016 11359559680 1950145056 19.228 99 32 64 1 1968377856 9626944 8605856
00:20:09 24090 8192000000 10890028528 11338690560 1919910704 18.986 98 23 44 1 1933141024 6528288 6702032
00:20:43 50527 8192000000 10879270480 11341807616 1915988880 18.955 98 21 42 0 1934764960 12773280 6002800
00:21:40 36639 8192000000 10879912672 11346919424 1900955872 18.834 97 19 38 1 1923727312 17238944 5532496
00:22:28 32784 8192000000 10891664832 11361644544 1932954528 19.090 99 18 36 0 1960647120 22047184 5645408
00:23:16 51229 8192000000 10891776544 11363790848 1951768720 19.241 100 15 30 0 1974712224 18581856 4361648
00:24:18 70904 8192000000 10881464560 11345002496 1895144736 18.787 97 11 22 0 1918662432 20170576 3347120
00:25:36 52443 8192000000 10869839296 11322769408 1877578816 18.646 96 23 46 2 1895566368 11747360 6240192
00:26:34 20384 8192000000 10886917424 11329720320 1908780624 18.897 98 47 94 1 1933124624 11261648 13082352
00:27:07 26049 8192000000 10860737456 11324649472 1931100640 19.076 100 45 89 0 1959130912 15267504 12762768
00:27:39 106250 8192000000 10869849712 11325579264 1834264432 18.294 94 10 20 0 1849497232 12732416 2500384
00:29:37 60497 8192000000 10885522448 11351678976 1954710944 19.264 100 26 52 1 1978282512 16445248 7126320
00:31:13 45091 8192000000 10898917872 11350708224 1943876112 19.178 99 32 62 2 1961719856 9293360 8550384
00:32:07 19121 8192000000 10871617488 11339517952 1937276960 19.125 99 29 58 3 1954549680 9842464 7430256
00:33:01 35771 8192000000 10873750896 11347275776 1956546528 19.279 100 13 26 0 1966749568 6943520 3259520
00:33:43 27021 8192000000 10868469552 11346931712 1936075744 19.115 99 4 8 1 1942572416 5772000 724672
00:34:16 48505 8192000000 10891598608 11360260096 1941874736 19.162 99 10 20 0 1952671040 8226880 2569424
00:35:15 58247 8192000000 10901283696 11372662784 1946533360 19.199 99 20 40 0 1967118672 14974464 5610848
00:36:21 62501 8192000000 10890958928 11361619968 1915097952 18.948 97 12 25 0 1929927360 11356928 3472480
00:37:31 30543 8192000000 10903016368 11380555776 1975847504 19.432 100 21 42 0 1996426800 14533152 6046144
00:38:22 58590 8192000000 10846066512 11303751680 1876111008 18.634 95 21 42 0 1896099056 14079072 5908976
00:39:27 54878 8192000000 10910269696 11359682560 1959730128 19.304 100 29 57 0 1981660432 13569248 8361056
00:40:30 26577 8192000000 10911000752 11370553344 1970433136 19.389 100 46 92 1 2000012528 16239984 13339408
00:41:03 71324 8192000000 10887706960 11343994880 1887288976 18.724 96 23 46 0 1903587760 10115408 6183376
00:42:22 60462 8192000000 10892036288 11338997760 1899670432 18.824 97 32 64 1 1918938704 10472848 8795424
00:43:33 36372 8192000000 10875809952 11344646144 1924473968 19.023 99 29 58 1 1946407760 13775040 8158752
00:44:23 81664 8192000000 10849765888 11335413760 1862319488 18.522 96 12 24 0 1879113424 13697664 3096272
00:46:02 26825 8192000000 10878546224 11332521984 1926296112 19.037 99 28 56 0 1944180240 9755760 8128368
00:46:40 56699 8192000000 10889831296 11361972224 1938375136 19.134 99 27 54 1 1958679072 12787856 7516080
00:47:44 109661 8192000000 10882799920 11368554496 1935074784 19.107 99 13 26 0 1958374064 19513424 3785856
00:50:02 117159 8192000000 10902680016 11365339136 1939720272 19.145 99 13 26 1 1956319136 13145248 3453616
00:52:14 21031 8192000000 10885899952 11365535744 1961396624 19.317 100 15 30 1 1981832080 15804160 4631296
00:52:42 10040 8192000000 10899813920 11370770432 1962228400 19.324 100 16 32 2 1981852096 14510928 5112768
00:53:14 69826 8192000000 10880896368 11359068160 1926820528 19.041 98 9 18 1 1938114160 8955232 2338400
00:54:31 40414 8192000000 10860832528 11336101888 1903848768 18.857 97 9 17 0 1914862176 7796096 3217312
00:55:18 78495 8192000000 10870165984 11347238912 1929428608 19.062 99 11 22 1 1943314480 10715040 3170832
00:56:42 48821 8192000000 10868717088 11348602880 1948830432 19.217 100 12 24 1 1964490544 12024592 3635520
00:57:37 31652 8192000000 10826510976 11311869952 1901289360 18.837 98 10 20 0 1913817728 10091392 2436976
00:58:18 79555 8192000000 10870066256 11337183232 1910119888 18.908 98 20 39 2 1922912048 7817408 4974752
00:59:45 65041 8192000000 10891706272 11368071168 1931172928 19.076 99 11 22 0 1941669696 7891760 2605008
01:00:56 41931 8192000000 10871685008 11349889024 1933028208 19.091 98 17 34 3 1950838928 12907392 4903328
01:01:44 53795 8192000000 10885868832 11358175232 1939870000 19.146 99 15 31 1 1960305040 15466288 4968752
01:02:44 67443 8192000000 10905832528 11368951808 1951794160 19.241 99 26 52 0 1973623344 13808336 8020848
01:03:58 43991 8192000000 10911693472 11360464896 1932606944 19.088 98 29 58 0 1953068944 11649872 8812128
01:04:49 24485 8192000000 10910310608 11373826048 1972664784 19.407 100 44 88 0 1997683376 13128960 11889632
01:05:22 87733 8192000000 10892218672 11368480768 1914831888 18.945 97 19 38 1 1933377200 13302512 5242800
01:06:56 78696 8192000000 10893873408 11379773440 1965528384 19.350 100 12 24 0 1981858432 12803952 3526096
01:08:21 52810 8192000000 10866117600 11327856640 1855824752 18.469 94 24 48 0 1871237120 8489248 6923120
01:09:20 33163 8192000000 10888440880 11345768448 1915538960 18.951 98 38 74 3 1935162560 9343600 10280000
01:10:06 65110 8192000000 10889556336 11357433856 1892021392 18.762 97 28 56 1 1912805040 13502464 7281184
01:11:17 86781 8192000000 10879081184 11343003648 1840171680 18.342 94 24 48 1 1857657344 11168160 6317504
01:12:53 141787 8192000000 10886764912 11360149504 1897490560 18.806 97 18 35 1 1916762176 14419104 4852512
01:15:25 102631 8192000000 10894826992 11364491264 1935317952 19.109 99 26 52 1 1956611936 13760496 7533488
01:17:13 7463 8192000000 10849263952 11321069568 1889876672 18.745 97 21 42 0 1911518912 15425936 6216304
01:17:27 27023 8192000000 10858031184 11330961408 1932976608 19.091 100 26 51 0 1956507744 16362736 7168400
01:18:30 53523 8192000000 10836262192 11311755264 1888860688 18.737 97 9 18 0 1899921856 8454448 2606720
01:19:30 48588 8192000000 10875567904 11340439552 1920287888 18.989 99 12 24 0 1935187120 11718512 3180720
01:20:26 56427 8192000000 10855480128 11324407808 1897864656 18.809 97 22 44 0 1919573504 15248896 6459952
01:22:12 68305 8192000000 10865898032 11349864448 1919526864 18.983 99 13 25 1 1943272976 19441808 4304304
01:23:40 53532 8192000000 10881678736 11361587200 1924494144 19.023 99 10 20 1 1949218592 21913056 2811392
01:24:48 61459 8192000000 10858615184 11335159808 1924985936 19.027 99 15 30 0 1942385360 12996624 4402800
01:25:57 31995 8192000000 10889536704 11350605824 1913326960 18.933 98 30 57 2 1928583232 6976976 8279296
01:26:48 45736 8192000000 9480674128 9791041536 632836112 7.171 33 16 28 1 642671552 5398624 4436816

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 130 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 27-02-2021 01:29:30 to 27-02-2021 01:29:32.

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          246088
MON$OLDEST_ACTIVE               246089
MON$OLDEST_SNAPSHOT             246089
MON$NEXT_TRANSACTION            246089
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                       2029472
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

--- start of diff output ---
:349: 
:350: mscs-test-161.budzdorov.ru    Sat Feb 27 01:27:36 2021
:351:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:352: 
:353: 
:354: mscs-test-161.budzdorov.ru    Sat Feb 27 01:27:42 2021
:355:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:356: 
:357: 
:358: mscs-test-161.budzdorov.ru    Sat Feb 27 01:27:46 2021
:359:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:360: 
--- end of diff output ---

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

27.02.21 01:29:33. 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-27 01:29:35 No severe PSQL-related problems occured
27.02.21 01:29:37. End of report.