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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-06-13 22:27:36
DTS_END                         2021-06-13 22:27:36.5370
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/60728
TRN_ID                          247795
ATT_ID                          678
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: 9254.46 23618 1110535
customer order: creation 182.63 338 21915
customer order: refuse 15.50 367 1860
order to supplier: creation 48.51 1322 5821
order to supplier: removal 3.19 103170 383
invoice (draft): creation 48.31 3436 5797
invoice (draft): removal 49.96 801 5995
invoice accept: apply 44.10 19187 5292
invoice accept: cancel 45.29 846 5435
customer reserve: creation 4029.96 192 483595
customer reserve: removal 4479.96 57 537595
realization accept: apply 87.97 171 10556
realization accept: cancel 82.09 102 9851
payment from customer: creation 63.27 142 7592
payment from customer: removal 5.93 73 711
payment to supplier: creation 50.50 136 6060
payment to supplier: removal 3.92 73 470
service: total inventory turnovers 5.25 960 630
service: total monetary turnovers 7.19 26 863
service: aggregate perf. data 0.92 19592 110
service: refresh index statistics 0.03 321361 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-06-2021 22:29:09 to 13-06-2021 22:29:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4817
TEST_TIME 2 2802
TEST_TIME 3 4927
TEST_TIME 4 5713
TEST_TIME 5 5908
TEST_TIME 6 6083
TEST_TIME 7 6107
TEST_TIME 8 6470
TEST_TIME 9 6294
TEST_TIME 10 6378
TEST_TIME 11 6462
TEST_TIME 12 6633
TEST_TIME 13 6599
TEST_TIME 14 6802
TEST_TIME 15 7264
TEST_TIME 16 7239
TEST_TIME 17 7092
TEST_TIME 18 7000
TEST_TIME 19 7617
TEST_TIME 20 7757
TEST_TIME 21 8266
TEST_TIME 22 8405
TEST_TIME 23 8845
TEST_TIME 24 9099
TEST_TIME 25 9264
TEST_TIME 26 9144
TEST_TIME 27 9436
TEST_TIME 28 9913
TEST_TIME 29 9860
TEST_TIME 30 10189
TEST_TIME 31 10160
TEST_TIME 32 10847
TEST_TIME 33 10646
TEST_TIME 34 10802
TEST_TIME 35 10625
TEST_TIME 36 10626
TEST_TIME 37 10525
TEST_TIME 38 10329
TEST_TIME 39 10187
TEST_TIME 40 10269
TEST_TIME 41 10091
TEST_TIME 42 10092
TEST_TIME 43 10061
TEST_TIME 44 10023
TEST_TIME 45 10137
TEST_TIME 46 10049
TEST_TIME 47 9989
TEST_TIME 48 9880
TEST_TIME 49 9914
TEST_TIME 50 9851
TEST_TIME 51 9846
TEST_TIME 52 9752
TEST_TIME 53 9663
TEST_TIME 54 9761
TEST_TIME 55 9916
TEST_TIME 56 9922
TEST_TIME 57 9957
TEST_TIME 58 9867
TEST_TIME 59 9830
TEST_TIME 60 9951
TEST_TIME 61 9909
TEST_TIME 62 10013
TEST_TIME 63 10048
TEST_TIME 64 9927
TEST_TIME 65 9798
TEST_TIME 66 9835
TEST_TIME 67 9845
TEST_TIME 68 9735
TEST_TIME 69 9685
TEST_TIME 70 9662
TEST_TIME 71 9580
TEST_TIME 72 9575
TEST_TIME 73 9497
TEST_TIME 74 9465
TEST_TIME 75 9468
TEST_TIME 76 9423
TEST_TIME 77 9352
TEST_TIME 78 9432
TEST_TIME 79 9386
TEST_TIME 80 9371
TEST_TIME 81 9478
TEST_TIME 82 9493
TEST_TIME 83 9458
TEST_TIME 84 9545
TEST_TIME 85 9494
TEST_TIME 86 9524
TEST_TIME 87 9606
TEST_TIME 88 9565
TEST_TIME 89 9655
TEST_TIME 90 9649
TEST_TIME 91 9580
TEST_TIME 92 9520
TEST_TIME 93 9574
TEST_TIME 94 9557
TEST_TIME 95 9510
TEST_TIME 96 9465
TEST_TIME 97 9489
TEST_TIME 98 9482
TEST_TIME 99 9522
TEST_TIME 100 9532
TEST_TIME 101 9517
TEST_TIME 102 9507
TEST_TIME 103 9494
TEST_TIME 104 9564
TEST_TIME 105 9539
TEST_TIME 106 9539
TEST_TIME 107 9511
TEST_TIME 108 9571
TEST_TIME 109 9549
TEST_TIME 110 9534
TEST_TIME 111 9491
TEST_TIME 112 9491
TEST_TIME 113 9466
TEST_TIME 114 9456
TEST_TIME 115 9420
TEST_TIME 116 9387
TEST_TIME 117 9365
TEST_TIME 118 9327
TEST_TIME 119 9307
TEST_TIME 120 9260

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-06-2021 22:29:13 to 13-06-2021 22:29:16.

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 1558130 1558130 0 0.00 0 20982 6 0 0
doc_list_biud 1558130 1558130 0 0.00 0 55449 25 0 0
sp_add_invoice_to_stock 5428 5292 136 2.50 28 175036 19188 0 136
sp_cancel_adding_invoice 5435 5435 0 0.00 5 55277 846 0 0
sp_cancel_client_order 1860 1860 0 0.00 4 14472 367 0 0
sp_cancel_customer_reserve 537595 537595 0 0.00 1 55450 58 0 0
sp_cancel_pay_from_customer 711 711 0 0.00 3 4800 74 0 0
sp_cancel_pay_to_supplier 470 470 0 0.00 3 2943 74 0 0
sp_cancel_supplier_invoice 6003 5995 8 0.13 1 16161 801 0 8
sp_cancel_supplier_order 383 383 0 0.00 5 1121314 103170 0 0
sp_cancel_write_off 9851 9851 0 0.00 1 19815 103 0 0
sp_client_order 21915 21915 0 0.00 4 50477 338 0 0
sp_customer_reserve 483595 483595 0 0.00 0 55610 193 0 0
sp_fill_shopping_cart 33524 33524 0 0.00 1 27064 39 0 0
sp_fill_shopping_cart_clo_res 483584 483584 0 0.00 0 18770 13 0 0
sp_get_clo_for_invoice 5281 5281 0 0.00 0 21444 260 0 0
sp_kill_cost_storno 16467 16467 0 0.00 0 20968 58 0 0
sp_kill_qstorno_ret_qs2qd 1091419 1091419 0 0.00 0 55446 31 0 0
sp_kill_qty_storno 576956 576956 0 0.00 0 55449 68 0 0
sp_lock_selected_doc 21910 21910 0 0.00 0 7807 5 0 0
sp_make_cost_storno 29489 29489 0 0.00 0 13102 54 0 0
sp_multiply_rows_for_pdistr 29489 29489 0 0.00 0 18735 33 0 0
sp_multiply_rows_for_qdistr 21915 21915 0 0.00 0 50469 147 0 0
sp_pay_from_customer 7592 7592 0 0.00 4 18744 143 0 0
sp_pay_to_supplier 6060 6060 0 0.00 4 20885 137 0 0
sp_payment_common 13652 13652 0 0.00 1 20287 36 0 0
sp_qd_handle_on_cancel_clo 1860 1860 0 0.00 0 14445 337 0 0
sp_qd_handle_on_invoice_upd_sts 10716 10716 0 0.00 0 13886 349 0 0
sp_qd_handle_on_reserve_upd_sts 10556 10556 0 0.00 0 16057 49 0 0
sp_reserve_write_off 10556 10556 0 0.00 6 16077 172 0 0
sp_supplier_invoice 5797 5797 0 0.00 6 82494 3437 0 0
sp_supplier_order 5821 5821 0 0.00 5 54999 1323 0 0
srv_aggregate_perf_data 111 110 1 0.90 2350 248258 19593 0 1
srv_fill_mon_cache_memory 185 185 0 0.00 1165 122928 26861 0 0
srv_find_qd_qs_mism 1060135 1060135 0 0.00 0 16104 6 0 0
srv_make_invnt_saldo 630 630 0 0.00 23 38146 960 0 0
srv_make_money_saldo 863 863 0 0.00 1 705 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 100192 587463 321362 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 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 5292 5292 0 0.00 0 10263 166 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 1 3725 89 0 0
t$perf-norm:sp_cancel_client_order 1860 1860 0 0.00 0 5702 19 0 0
t$perf-norm:sp_cancel_customer_reserve 729 729 0 0.00 0 1956 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 711 711 0 0.00 0 1836 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 470 470 0 0.00 0 1213 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 410 410 0 0.00 0 3544 19 0 0
t$perf-norm:sp_cancel_supplier_order 383 383 0 0.00 0 40879 2028 0 0
t$perf-norm:sp_cancel_write_off 1087 1087 0 0.00 0 4171 11 0 0
t$perf-norm:sp_client_order 21915 21915 0 0.00 0 20114 20 0 0
t$perf-norm:sp_customer_reserve 1043 1043 0 0.00 0 1544 7 0 0
t$perf-norm:sp_pay_from_customer 7592 7592 0 0.00 0 9733 10 0 0
t$perf-norm:sp_pay_to_supplier 6060 6060 0 0.00 0 12867 12 0 0
t$perf-norm:sp_reserve_write_off 10556 10556 0 0.00 0 15858 11 0 0
t$perf-norm:sp_supplier_invoice 5797 5797 0 0.00 0 7221 20 0 0
t$perf-norm:sp_supplier_order 5821 5821 0 0.00 0 4688 16 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 645 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 185 185 0 0.00 0 742 14 0 0
t$perf-norm:srv_make_invnt_saldo 630 630 0 0.00 0 2975 29 0 0
t$perf-norm:srv_make_money_saldo 863 863 0 0.00 0 1166 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10834 10562 272 2.51 0 5625 22 0 272
v_all_customers 39996 39996 0 0.00 0 22 1 0 0
v_all_suppliers 31596 31596 0 0.00 0 22 1 0 0
v_all_wares 43830 43830 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 1779 8 0 0
v_cancel_client_order 3720 3720 0 0.00 0 3564 7 0 0
v_cancel_customer_prepayment 1422 1422 0 0.00 0 1814 5 0 0
v_cancel_customer_reserve 1458 1458 0 0.00 0 5623 9 0 0
v_cancel_payment_to_supplier 940 940 0 0.00 0 2915 7 0 0
v_cancel_supplier_invoice 836 820 16 1.91 0 385 12 0 16
v_cancel_supplier_order 766 766 0 0.00 0 3701 8 0 0
v_cancel_write_off 2174 2174 0 0.00 0 2305 16 0 0
v_max_id_clo_ord 5816 5816 0 0.00 0 362 1 0 0
v_max_id_clo_res 1043 1043 0 0.00 0 3510 11 0 0
v_max_id_ord_sup 5792 5792 0 0.00 0 2629 4 0 0
v_max_non_paid_invoice 1870 1870 0 0.00 0 782 2 0 0
v_max_non_paid_realizn 4104 4104 0 0.00 0 5010 4 0 0
v_min_id_clo_ord 5816 5816 0 0.00 0 1996 7 0 0
v_min_id_clo_res 1043 1043 0 0.00 0 5872 10 0 0
v_min_id_ord_sup 5792 5792 0 0.00 0 5023 8 0 0
v_min_non_paid_invoice 6060 6060 0 0.00 0 20282 26 0 0
v_min_non_paid_realizn 7592 7592 0 0.00 0 17075 24 0 0
v_our_firm 10810 10810 0 0.00 0 27 1 0 0
v_reserve_write_off 21112 21112 0 0.00 0 5632 7 0 0
x_lock_depdocs_on_canc_invoice 11020 11020 0 0.00 0 26685 111 0 0
x_lock_depdocs_on_canc_sup_ord 383 383 0 0.00 0 3825 360 0 0
x_make_qstorno_1000_1200 5821 5821 0 0.00 2 54933 1237 0 0
x_make_qstorno_1200_2000 5797 5797 0 0.00 3 82455 3298 0 0
x_make_qstorno_2100_3300 483595 483595 0 0.00 0 52601 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-06-2021 22:29:17 to 13-06-2021 22:29:21.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:40 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
19:57:46 9053 8192000000 10194420064 10493603840 816023280 9.058 64 44 89 0 832342592 2146800 14172512
19:58:04 31218 8192000000 10322209376 10640371712 1367858272 14.308 100 81 162 1 1399019936 4593952 26567712
19:58:46 21241 8192000000 10363692448 10682658816 1420529600 14.777 100 87 174 1 1455229792 5915136 28785056
19:59:16 28452 8192000000 10402259552 10727174144 1448200256 15.022 100 89 178 0 1484886304 6883920 29802128
20:00:00 16131 8192000000 10430811728 10761596928 1488152768 15.373 100 88 176 0 1523964624 7493920 28317936
20:00:27 19872 8192000000 10449036864 10780332032 1502057600 15.494 100 92 184 1 1540090096 8336208 29696288
20:00:58 12577 8192000000 10460508240 10794119168 1512233008 15.583 100 84 168 0 1547786640 8685024 26868608
20:01:19 18841 8192000000 10463706928 10805149696 1524371072 15.688 100 87 174 0 1561117584 9011904 27734608
20:01:47 15059 8192000000 10483779248 10824454144 1545056288 15.867 100 90 178 1 1582054512 9356896 27641328
20:02:11 8200 8192000000 10495058176 10843484160 1556468208 15.966 100 77 154 0 1589413504 9486448 23458848
20:02:29 11243 8192000000 10528515296 10876272640 1585151968 16.212 100 76 153 0 1617111424 9145664 22813792
20:02:52 15170 8192000000 10560638864 10918486016 1625170960 16.554 100 81 162 0 1659393008 10223456 23998592
20:03:14 14178 8192000000 10586698032 10949197824 1651115600 16.774 100 74 146 2 1683405696 11138800 21151296
20:03:38 11098 8192000000 10620125344 10980954112 1677536736 16.997 100 85 168 0 1713838288 11397344 24904208
20:03:58 9808 8192000000 10626144672 10991390720 1687860272 17.083 100 78 156 1 1722453776 12016176 22577328
20:04:15 12402 8192000000 10651988768 11023581184 1703821248 17.217 100 72 144 0 1736937184 11851744 21264192
20:04:35 10226 8192000000 10664233264 11035262976 1723535664 17.382 100 77 152 1 1758332896 12211728 22585504
20:04:54 9695 8192000000 10677128016 11050258432 1736303936 17.488 100 86 172 0 1774385264 13181328 24900000
20:05:11 6384 8192000000 10682492512 11057737728 1740863344 17.526 100 79 156 0 1776378224 13601968 21912912
20:05:25 6247 8192000000 10697023200 11071115264 1755222640 17.645 100 90 181 3 1794657008 13667152 25767216
20:05:39 6168 8192000000 10705811232 11081650176 1761874272 17.700 100 81 162 1 1797522160 12525200 23122688
20:05:53 6369 8192000000 10717854896 11096952832 1774410720 17.803 100 78 156 1 1809510096 12958816 22140560
20:06:06 3800 8192000000 10724575616 11103477760 1785489904 17.895 100 84 169 0 1821844256 13013840 23340512
20:06:17 5967 8192000000 10731749472 11110981632 1792676112 17.954 100 83 167 0 1829216912 13947248 22593552
20:06:29 5873 8192000000 10745433296 11124477952 1795405568 17.976 100 89 179 1 1834647280 14448704 24793008
20:06:41 4462 8192000000 10740169616 11125227520 1800522576 18.018 100 84 167 1 1838177552 14065712 23589264
20:06:53 2019 8192000000 10747711792 11128082432 1809122832 18.089 100 85 168 1 1845808128 13792256 22893040
20:07:02 3822 8192000000 10753193088 11139092480 1812271168 18.114 100 85 168 0 1849540880 14838448 22431264
20:07:12 2767 8192000000 10757655184 11138871296 1815898992 18.144 100 86 173 1 1855221728 15061696 24261040
20:07:22 2897 8192000000 10759428560 11144314880 1819976048 18.177 100 80 158 0 1856625056 14111216 22537792
20:07:31 4628 8192000000 10758999344 11146629120 1825647680 18.224 100 84 170 3 1862485760 12845424 23992656
20:07:43 2914 8192000000 10775640688 11164004352 1830465760 18.263 100 85 168 5 1866774688 13214896 23094032
20:07:53 2637 8192000000 10780815584 11173498880 1848086368 18.407 100 87 175 1 1884913584 11810208 25017008
20:08:02 1805 8192000000 10800035616 11188461568 1856635008 18.476 100 89 177 2 1893838704 11816192 25387504
20:08:10 1906 8192000000 10802209648 11195052032 1860142080 18.504 100 84 166 0 1896266944 12233712 23891152
20:08:19 1632 8192000000 10812905120 11199516672 1867128064 18.561 100 91 178 1 1905340560 12162016 26050480
20:08:27 1749 8192000000 10818066048 11207356416 1879760288 18.663 100 92 179 1 1916740704 11775440 25204976
20:08:35 1598 8192000000 10821392128 11208683520 1875747792 18.631 100 94 187 1 1916164848 14631968 25785088
20:08:44 1668 8192000000 10827984720 11215257600 1882482384 18.685 100 90 180 0 1922398960 15235984 24680592
20:08:52 1509 8192000000 10821539104 11212967936 1880159728 18.666 100 87 175 0 1918813776 13402432 25251616
20:08:59 9414 8192000000 10813052384 11216646144 1880625936 18.670 100 74 148 0 1912346432 10946432 20774064
20:09:16 16521 8192000000 10816631920 11216863232 1883429360 18.693 100 65 132 0 1912497376 9990704 19077312
20:09:39 25884 8192000000 10792397840 11218788352 1882939504 18.689 100 50 99 1 1906685136 9665888 14079744
20:10:11 5217 8192000000 10794743824 11217780736 1880691936 18.671 100 31 60 3 1896797040 7603904 8501200
20:10:23 2783 8192000000 10794393344 11221880832 1884655376 18.703 100 42 82 1 1904831888 7791296 12385216
20:10:32 3990 8192000000 10796399408 11218804736 1884773136 18.704 100 38 75 6 1903102768 5692416 12637216
20:10:45 2955 8192000000 10813633888 11226718208 1889037136 18.738 100 34 66 0 1904118640 5553904 9527600
20:10:57 6654 8192000000 10797738240 11226673152 1889165744 18.739 100 24 48 1 1903031648 6929808 6936096
20:11:10 4237 8192000000 10797698736 11227103232 1893788240 18.776 100 39 78 2 1911236576 6846864 10601472
20:11:21 10211 8192000000 10799969408 11231985664 1897014576 18.802 100 32 61 3 1911349168 5464512 8870080
20:11:37 10991 8192000000 10798733216 11232382976 1896499936 18.798 100 12 24 1 1905790096 5894208 3395952
20:11:57 15210 8192000000 10805618832 11237081088 1897591760 18.807 100 20 39 2 1909047616 5678496 5777360
20:12:22 12047 8192000000 10810356464 11242274816 1900371376 18.829 100 20 40 2 1911851760 6134384 5346000
20:12:42 7385 8192000000 10801975552 11239473152 1904075472 18.859 100 32 64 4 1919879904 6004080 9800352
20:12:56 8447 8192000000 10805275632 11241615360 1902910128 18.850 100 18 36 0 1913510720 5408096 5192496
20:13:20 9676 8192000000 10817262576 11246571520 1904965456 18.866 100 14 28 1 1914033728 5260528 3807744
20:13:36 78645 8192000000 10840635568 11268124672 1910615888 18.912 100 23 48 0 1922859296 5368880 6874528
20:15:06 8615 8192000000 10822539120 11257434112 1893617264 18.775 99 22 44 0 1906463680 6085472 6760944
20:15:21 8373 8192000000 10833674000 11267190784 1912524240 18.927 100 31 62 0 1928017264 7277840 8215184
20:15:37 4492 8192000000 10845377360 11272998912 1916906144 18.962 100 53 106 0 1940693584 9316160 14471280
20:15:48 5692 8192000000 10836845312 11267874816 1915089648 18.947 100 36 71 1 1932665248 7598240 9977360
20:16:01 5856 8192000000 10847513472 11274379264 1900053360 18.827 99 35 70 1 1924988416 15595920 9339136
20:16:16 7833 8192000000 10836111888 11270115328 1915165584 18.948 100 28 56 2 1930100160 6329504 8605072
20:16:33 9304 8192000000 10799279488 11237335040 1876736192 18.639 98 20 40 3 1888520096 6251280 5532624
20:16:49 8007 8192000000 10826478080 11253702656 1888439456 18.733 99 23 45 4 1900572608 5612848 6520304
20:17:03 7464 8192000000 10821344304 11250323456 1894030240 18.778 100 26 52 1 1907556960 6158256 7368464
20:17:17 7477 8192000000 10824320624 11253927936 1895923904 18.793 100 19 38 2 1907501792 6162800 5415088
20:17:32 7586 8192000000 10821888800 11248091136 1869889952 18.583 98 34 68 3 1887059024 7830208 9338864
20:17:50 12251 8192000000 10804854064 11236868096 1845389472 18.385 97 21 41 2 1856997248 5993424 5614352
20:18:09 10730 8192000000 10789303232 11221581824 1861133744 18.512 99 22 44 1 1873350688 5930880 6286064
20:18:26 16917 8192000000 10762934256 11193753600 1771601808 17.780 94 17 34 0 1782321872 6086080 4633984
20:18:55 62532 8192000000 10720229296 11145830400 1658968304 16.840 89 28 56 0 1671304976 5106992 7229680
20:20:07 6190 8192000000 10737844240 11156422656 1788808816 17.922 98 27 55 0 1802376720 5844592 7723312
20:20:21 5899 8192000000 10733042128 11150843904 1800228384 18.016 99 33 66 1 1816456576 6838336 9389856
20:20:37 4879 8192000000 10690346752 11103133696 1743989920 17.552 97 32 64 3 1758498176 5779456 8728800
20:20:48 6081 8192000000 10702288944 11119017984 1749981152 17.601 97 28 56 2 1764117680 5976352 8160176
20:21:01 8307 8192000000 10702617248 11109453824 1739675360 17.516 97 33 66 4 1755646864 6424224 9547280
20:21:17 7620 8192000000 10702928992 11102973952 1707405776 17.247 95 33 66 0 1722916800 5978864 9532160
20:21:31 6960 8192000000 10712164320 11130486784 1775970480 17.816 99 19 38 0 1787095472 5819344 5305648
20:21:45 5992 8192000000 10703108992 11122044928 1757308832 17.662 98 31 62 1 1773771632 7604736 8858064
20:21:59 5265 8192000000 10711784304 11121307648 1777673280 17.830 99 22 44 1 1790215104 5702624 6839200
20:22:13 5821 8192000000 10716748016 11136602112 1788199952 17.917 99 29 58 3 1804128368 6994096 8934320
20:22:26 7093 8192000000 10717427952 11134504960 1784723840 17.888 99 27 53 4 1798247456 5458032 8065584
20:22:46 7481 8192000000 10715049232 11130781696 1772188720 17.785 98 23 46 2 1783985904 5461984 6335200
20:23:03 10604 8192000000 10730049968 11151093760 1787372512 17.910 99 16 30 1 1797354672 5282912 4699248
20:23:23 63080 8192000000 10743818016 11173171200 1835743024 18.306 100 42 83 1 1854455152 5658688 13053440
20:24:39 15945 8192000000 10762041888 11188215808 1846687152 18.395 100 30 60 1 1860987696 6088480 8212064
20:25:01 5389 8192000000 10761933760 11182776320 1831206832 18.269 99 33 64 1 1846857456 6787648 8862976
20:25:13 8931 8192000000 10781820448 11195633664 1850302432 18.425 100 46 92 1 1870744416 7779024 12662960
20:25:29 6505 8192000000 10764332304 11194675200 1849870016 18.421 100 28 56 3 1865248896 7044096 8334784
20:25:42 5458 8192000000 10777631696 11200757760 1855347776 18.466 100 35 70 0 1872903744 7393008 10162960
20:25:55 10838 8192000000 10772059456 11196493824 1852188176 18.440 100 18 36 1 1862708816 5442016 5078624
20:26:14 4333 8192000000 10769023408 11198894080 1855403216 18.466 100 31 62 0 1871127856 6656720 9067920
20:26:29 11546 8192000000 10776992848 11203612672 1860343936 18.506 100 27 54 0 1873659856 5822304 7493616
20:26:49 11180 8192000000 10796356544 11213455360 1860609120 18.508 100 23 46 1 1872313360 5747792 5956448
20:27:06 8206 8192000000 10803364208 11223437312 1877822032 18.648 100 21 42 0 1888716160 5288896 5605232
20:27:20 13947 8192000000 10801550496 11228663808 1884828208 18.704 100 22 44 1 1895853328 4970304 6054816
20:27:41 17776 8192000000 10831835424 11249627136 1893034400 18.770 100 32 63 1 1911872624 10090304 8747920
20:28:12 14670 8192000000 10833178112 11253501952 1903590896 18.855 100 39 74 3 1920716288 6283728 10841664
20:28:35 13648 8192000000 10841717952 11267284992 1914999520 18.947 100 53 106 2 1937789040 7167408 15622112
20:29:01 83749 8192000000 10851821328 11284795392 1922559136 19.007 100 59 118 2 1951897392 12112944 17225312
20:30:39 12937 8192000000 10868084448 11300261888 1926258768 19.037 100 43 86 1 1954152512 16015664 11878080
20:31:03 34963 8192000000 10865820688 11300790272 1934272608 19.101 100 39 79 2 1961091552 15816816 11002128
20:31:50 7324 8192000000 10876177296 11304857600 1934690544 19.104 100 47 94 0 1959038368 10908144 13439680
20:32:07 3523 8192000000 10883405536 11310039040 1939546016 19.143 100 60 119 1 1965370496 9199648 16624832
20:32:19 30565 8192000000 10884672928 11315511296 1944543040 19.183 100 59 118 0 1976505088 14720880 17241168
20:33:01 14695 8192000000 10894866080 11329196032 1952218464 19.244 100 46 90 2 1979714368 14702784 12793120
20:33:26 12127 8192000000 10908386848 11336486912 1961448896 19.318 100 56 112 0 1995832624 18022336 16361392
20:33:52 5357 8192000000 10913359904 11339264000 1965230624 19.348 100 55 110 2 1999187744 17788464 16168656
20:34:04 1469 8192000000 10931649200 11352481792 1974580432 19.422 100 82 165 2 2020069920 20904160 24585328
20:34:13 7847 8192000000 10914328672 11341254656 1952616000 19.247 99 59 118 0 1988473264 18983952 16873312
20:34:28 17495 8192000000 10899519504 11330166784 1942715184 19.168 99 57 112 2 1978228000 19693952 15818864
20:34:52 3633 8192000000 10913028848 11340050432 1962983984 19.330 100 56 110 0 1998747760 19239856 16523920
20:35:04 9246 8192000000 10898734912 11328020480 1943727616 19.176 99 63 124 3 1982494800 21136528 17630656
20:35:23 9752 8192000000 10901112720 11339214848 1962094032 19.323 100 51 102 1 1997738864 20681856 14962976
20:35:46 2394 8192000000 10931664048 11347197952 1974634320 19.422 100 76 152 1 2016751040 19925408 22191312
20:35:57 7622 8192000000 10920085264 11343810560 1959337264 19.301 99 68 136 1 1999734928 20394416 20003248
20:36:12 5972 8192000000 10926843936 11356319744 1975270352 19.427 100 59 117 0 2015850960 22747264 17833344
20:36:25 10130 8192000000 10943011568 11361390592 1983224032 19.490 100 73 145 2 2026030256 21735504 21070720
20:36:43 8992 8192000000 10939307136 11367604224 1983890880 19.495 100 66 133 0 2024037952 21378432 18768640
20:37:01 4410 8192000000 10947632704 11375067136 1991036288 19.552 100 69 134 1 2034994928 24568320 19390320
20:37:15 8106 8192000000 10954568704 11379220480 1996629520 19.596 100 74 146 3 2042700384 24566960 21503904
20:37:35 11742 8192000000 10961627248 11381116928 1997423664 19.602 100 61 121 1 2039301216 24782864 17094688
20:37:59 2316 8192000000 10961777840 11386286080 2000382464 19.626 100 68 136 2 2047056704 27128832 19545408
20:38:09 6920 8192000000 10964075280 11390746624 2005217456 19.664 100 68 136 0 2053621216 28026752 20377008
20:38:25 2394 8192000000 10977820800 11398774784 2009389792 19.697 100 71 141 0 2058480080 28547216 20543072
20:38:37 4245 8192000000 10969761104 11399389184 2006036208 19.670 100 79 156 2 2058269616 29099920 23133488
20:38:49 6693 8192000000 10961870064 11390451712 1998005792 19.607 100 68 136 1 2047146864 29170624 19970448
20:39:10 1708 8192000000 10963153024 11390050304 1999363632 19.618 100 77 153 2 2052399552 29513600 23522320
20:39:19 7590 8192000000 10977193904 11398475776 2005818272 19.669 100 77 155 2 2061141392 32356016 22967104
20:39:34 5024 8192000000 10978094096 11399876608 2008815152 19.692 100 73 145 1 2064877120 34232816 21829152
20:39:48 7524 8192000000 10971588432 11404435456 2007962800 19.685 100 69 137 2 2063024768 34146128 20915840
20:40:02 5875 8192000000 10978803248 11408834560 2007957264 19.685 100 71 142 4 2066601792 37276224 21368304
20:40:17 2944 8192000000 10978846048 11401150464 1989206576 19.538 99 66 129 2 2041658832 32386336 20065920
20:40:28 2272 8192000000 10951909776 11372040192 1978057440 19.449 99 84 163 3 2036596560 32709504 25829616
20:40:38 6988 8192000000 10957556032 11376873472 1978487216 19.453 99 73 144 1 2034969072 34906400 21575456
20:40:55 4332 8192000000 10941656832 11362881536 1967392560 19.365 99 73 146 1 2026037488 36454976 22189952
20:41:13 7009 8192000000 10956317808 11380404224 1983137424 19.490 100 71 142 3 2042628032 37740128 21750480
20:41:29 4260 8192000000 10963219664 11385053184 1986843856 19.519 100 77 152 0 2049245296 38992688 23408752
20:41:47 4245 8192000000 10944880720 11366264832 1955139712 19.267 99 81 159 1 2019713168 39534864 25038592
20:41:58 2936 8192000000 10951413152 11369058304 1955080688 19.267 99 81 157 1 2018823376 38986192 24756496
20:42:08 1164 8192000000 10931434384 11341025280 1933539856 19.095 98 87 171 2 1997929056 38538768 25850432
20:42:16 2110 8192000000 10942002624 11349921792 1953654224 19.256 100 89 175 1 2018360128 38088336 26617568
20:42:27 4649 8192000000 10934600992 11351957504 1958213792 19.292 100 78 156 0 2017229472 35731552 23284128
20:42:40 5296 8192000000 10943668128 11360063488 1964833648 19.344 100 79 156 2 2024515600 35647552 24034400
20:42:52 1919 8192000000 10946084592 11362492416 1969806192 19.384 100 81 158 0 2029589744 36102960 23680592
20:43:03 3932 8192000000 10927881296 11343056896 1950867472 19.233 100 75 149 0 2010060928 36157152 23036304
20:43:13 3201 8192000000 10931822224 11347181568 1941505600 19.159 99 80 158 2 2003084128 37193184 24385344
20:43:25 10550 8192000000 10935282208 11349585920 1936015280 19.115 99 77 154 1 2003543696 44314512 23213904
20:43:43 3230 8192000000 10931277152 11351564288 1952486336 19.246 100 75 150 2 2017732576 41792384 23453856
20:44:04 5484 8192000000 10925107216 11351330816 1948248416 19.213 100 56 112 2 2009167008 43272784 17645808
20:44:17 3797 8192000000 10933830352 11356622848 1957889632 19.289 100 72 142 1 2020832800 41017408 21925760
20:44:30 10910 8192000000 10933166848 11361566720 1955423712 19.270 100 61 122 2 2018024304 42347472 20253120
20:44:51 31588 8192000000 10909411776 11344109568 1908735296 18.896 98 45 91 1 1968202096 44190592 15276208
20:45:32 8832 8192000000 10917869536 11346583552 1923121632 19.012 99 51 102 1 1987476352 47024912 17329808
20:45:51 15670 8192000000 10920181216 11358789632 1925808656 19.033 99 39 78 0 1990014048 50270448 13934944
20:46:15 6672 8192000000 10911177792 11343994880 1902274464 18.845 98 44 87 3 1964424576 47427552 14722560
20:46:29 2563 8192000000 10926712080 11337732096 1902152448 18.844 98 74 147 1 1974264976 48590752 23521776
20:46:38 5360 8192000000 10920056976 11345031168 1931519776 19.079 100 57 114 3 1998386144 47778848 19087520
20:46:50 4506 8192000000 10946546928 11367686144 1943154816 19.172 100 68 133 0 2016207280 51941184 21111280
20:47:02 3243 8192000000 10939023200 11348365312 1938673616 19.136 99 85 167 4 2011166992 47412000 25081376
20:47:13 3641 8192000000 10928689984 11344150528 1897649056 18.807 97 77 154 3 1969769600 48297280 23823264
20:47:27 3228 8192000000 10917095696 11330187264 1924935488 19.026 100 77 153 2 2001353376 53005104 23412784
20:47:37 1450 8192000000 10932296848 11338153984 1929894208 19.066 100 95 192 3 2009923328 49733392 30295728
20:47:46 3164 8192000000 10932050064 11341058048 1920367616 18.990 99 82 163 0 1994758800 49670208 24720976
20:48:00 2586 8192000000 10934983008 11348766720 1923585136 19.016 99 93 182 6 2000530256 48367632 28577488
20:48:09 2090 8192000000 10939009552 11354419200 1939561664 19.143 100 86 171 0 2015834448 49662208 26610576
20:48:19 2044 8192000000 10958506416 11365449728 1962656160 19.327 100 91 182 0 2037684928 46764256 28264512
20:48:28 4895 8192000000 10926692432 11348516864 1945888752 19.194 100 62 123 2 2006572560 41465872 19217936
20:48:43 4330 8192000000 10938771184 11362045952 1957046976 19.283 100 63 126 2 2019690960 42893696 19750288
20:48:55 8236 8192000000 10920393024 11354947584 1938960464 19.138 99 50 100 1 1997830560 42004896 16865200
20:49:12 3838 8192000000 10931780496 11358007296 1956248896 19.276 100 66 130 2 2013771712 36915152 20607664
20:49:23 5750 8192000000 10927151744 11356569600 1942721840 19.168 99 69 136 3 1999059184 35585520 20751824
20:49:35 2478 8192000000 10940818448 11354939392 1954799408 19.265 100 80 161 0 2017014304 37753120 24461776
20:49:45 4171 8192000000 10949237776 11363872768 1965103104 19.347 100 82 163 1 2030487760 41295568 24089088
20:49:58 3528 8192000000 10958105296 11372900352 1963048640 19.330 100 82 164 1 2033111984 44915040 25148304
20:50:11 8196 8192000000 10926491120 11363540992 1942951600 19.170 99 46 94 3 2001847440 44080464 14815376
20:50:41 16208 8192000000 10931751760 11386347520 1959331840 19.301 100 40 80 2 2023602176 51071344 13198992
20:51:10 12488 8192000000 10928385584 11379265536 1966611712 19.359 100 30 60 0 2017321360 40419264 10290384
20:51:31 6568 8192000000 10945734640 11374383104 1961656304 19.319 100 42 81 1 2011937824 37463792 12817728
20:51:46 8834 8192000000 10936669504 11376463872 1967847840 19.368 100 45 90 0 2019979824 37449344 14682640
20:52:08 14575 8192000000 10932749840 11377610752 1952257216 19.244 99 32 64 1 1996264912 33551184 10456512
20:52:29 13089 8192000000 10930975360 11378040832 1978211072 19.451 100 33 66 0 2021107104 32660720 10235312
20:52:50 16099 8192000000 10923678640 11369193472 1947688240 19.208 99 25 49 1 1992313856 36426528 8199088
20:53:35 14567 8192000000 10913355824 11358973952 1932753760 19.089 99 28 56 0 1983300288 41123552 9422976
20:53:56 20084 8192000000 10928021056 11371659264 1949742160 19.224 100 30 60 2 2004462512 44083488 10636864
20:54:25 8978 8192000000 10924754480 11367370752 1937471104 19.127 99 37 74 0 1993836880 44235136 12130640
20:55:02 19454 8192000000 10931040128 11374948352 1954682592 19.264 100 28 56 0 2006768624 41259520 10826512
20:55:28 36088 8192000000 10893161984 11349696512 1897502192 18.806 97 32 64 1 1938858480 31159056 10197232
20:56:11 15327 8192000000 10899931520 11344257024 1937210640 19.124 100 30 59 2 1976100176 29765536 9124000
20:56:40 10512 8192000000 10912815584 11350437888 1945343744 19.189 100 45 90 1 1992469456 32354688 14771024
20:56:59 16994 8192000000 10901699120 11349688320 1930109072 19.068 99 32 64 1 1970747936 31159536 9479328
20:57:42 51742 8192000000 10877180528 11333931008 1908627664 18.896 98 14 28 1 1945688880 32391840 4669376
20:59:01 34709 8192000000 10873769936 11331784704 1915754736 18.953 98 13 26 2 1950172400 30176368 4241296
20:59:44 40624 8192000000 10876090528 11333066752 1921725584 19.001 99 10 20 1 1937468224 13360096 2382544
21:00:31 43737 8192000000 10897255824 11345620992 1952525776 19.247 100 20 41 0 1975947936 17450576 5971584
21:01:32 122928 8192000000 10909961360 11370323968 1954271952 19.260 99 15 30 1 1976240976 18188464 3780560
21:03:42 60511 8192000000 10903224608 11358986240 1951193664 19.236 99 21 40 2 1971086240 14557168 5335408
21:04:55 91612 8192000000 10912900080 11367063552 1953368736 19.253 99 34 68 0 1973739984 10353824 10017424
21:06:43 108365 8192000000 10929843648 11380776960 1983445936 19.492 100 35 70 0 2006886944 12763376 10677632
21:08:38 11285 8192000000 10929477584 11379920896 1988161696 19.529 100 42 84 2 2010012624 9959744 11891184
21:08:57 8605 8192000000 10959647056 11393851392 1998274272 19.609 100 66 133 0 2027857984 11241248 18342464
21:09:13 6722 8192000000 10946651808 11393589248 1995617440 19.588 100 57 114 1 2024024672 12432720 15974512
21:09:30 9753 8192000000 10918627648 11379208192 1984005152 19.496 100 33 66 0 2005129632 11161008 9963472
21:09:47 27600 8192000000 10920281440 11375841280 1950540224 19.231 98 25 50 2 1966111392 8059264 7511904
21:10:26 33816 8192000000 10924568672 11386236928 1990359904 19.547 100 38 73 0 2011011680 9552640 11099136
21:11:07 41328 8192000000 10925676256 11391860736 1990952640 19.551 100 45 90 1 2017223824 12928576 13342608
21:12:01 15880 8192000000 10911500448 11390840832 1987858688 19.527 100 16 33 2 2008823728 16207296 4757744
21:12:28 33989 8192000000 10915825600 11398094848 1991229728 19.554 100 13 26 1 2005012176 9914576 3867872
21:13:08 27651 8192000000 10920948016 11399991296 1996658416 19.596 100 14 28 0 2012448656 11350368 4439872
21:13:55 38896 8192000000 10919186448 11401166848 1999392448 19.618 100 15 30 0 2014348912 10674384 4282080
21:16:55 18687 8192000000 10919593424 11405811712 1997408944 19.602 100 14 28 2 2011920896 10342864 4169088
21:17:19 17778 8192000000 10911866480 11405344768 1977643472 19.446 99 5 10 0 1988285120 9395552 1246096
21:17:43 5604 8192000000 10886955088 11377266688 1963423008 19.333 99 3 6 0 1972518144 8537728 557408
21:17:55 5263 8192000000 10906632128 11390926848 1980636224 19.470 100 4 8 0 1989868496 8130240 1102032
21:18:11 26283 8192000000 10915521424 11393097728 1975497296 19.429 99 11 23 0 1989767216 10148032 4121888
21:19:01 30759 8192000000 10932985824 11396505600 1964143664 19.339 98 38 76 1 1982268288 7116912 11007712
21:19:44 36016 8192000000 10930755552 11391578112 1960330912 19.309 98 26 52 2 1980238720 12255760 7652048
21:20:31 45087 8192000000 10901145984 11369844736 1934656464 19.104 97 34 68 0 1958053248 13250448 10146336
21:21:33 36603 8192000000 10897488304 11391283200 1940982816 19.155 98 14 28 0 1963376544 18472640 3921088
21:22:21 77042 8192000000 10877794080 11349098496 1864334208 18.538 94 13 26 1 1886594032 18853232 3406592
21:23:52 66545 8192000000 10876324448 11352862720 1902471552 18.846 97 17 35 0 1918988880 11392176 5125152
21:25:14 21230 8192000000 10853003360 11302092800 1856417920 18.474 96 23 46 1 1869660992 6963552 6279520
21:25:42 18095 8192000000 10886110640 11326619648 1898863136 18.817 98 53 106 0 1925879616 11821488 15194992
21:26:10 21365 8192000000 10883826064 11334729728 1935113072 19.108 100 41 82 2 1961276000 14594384 11568544
21:27:29 94656 8192000000 10827942736 11289366528 1790899856 17.939 92 18 33 3 1814072800 17099776 6073168
21:29:10 49932 8192000000 10862749920 11314151424 1887017408 18.722 98 14 28 0 1904247216 13743744 3486064
21:30:07 43766 8192000000 10884569904 11350994944 1926235360 19.037 99 33 66 1 1944720256 9804704 8680192
21:30:59 105139 8192000000 10896714768 11357986816 1948387408 19.214 100 20 40 0 1967166160 13198960 5579792
21:33:35 8316 8192000000 10887420416 11342766080 1933695312 19.096 99 34 66 1 1953688736 11288112 8705312
21:33:50 31506 8192000000 10859387792 11333660672 1926759840 19.041 99 34 68 0 1948295568 11970208 9565520
21:34:34 53989 8192000000 10864084560 11348873216 1945132320 19.188 100 8 16 0 1958627376 11224752 2270304
21:35:34 18496 8192000000 10871825264 11350118400 1948375552 19.214 100 8 16 0 1962493056 12053536 2063968
21:35:58 41800 8192000000 10850363936 11330551808 1893462288 18.774 97 14 28 3 1909756864 12241232 4053344
21:36:49 54894 8192000000 10816687568 11292299264 1834970224 18.300 95 7 14 1 1845731664 8487168 2274272
21:37:59 65515 8192000000 10852654704 11310362624 1875154512 18.626 97 15 30 0 1886385632 7247760 3983360
21:39:16 77138 8192000000 10829605648 11305975808 1844468096 18.377 95 13 26 1 1859140144 10850016 3822032
21:40:40 4935 8192000000 10843641312 11300507648 1900423152 18.830 99 24 44 2 1915335424 8232480 6679792
21:40:53 31410 8192000000 10827500736 11280347136 1866794208 18.558 97 23 44 4 1881923728 8671696 6457824
21:41:34 39060 8192000000 10843979456 11324690432 1928626256 19.056 100 40 80 0 1952120000 11721376 11772368
21:42:28 83321 8192000000 10840318896 11326140416 1918443296 18.974 99 23 46 1 1934842528 8891984 7507248
21:44:23 35353 8192000000 10872800416 11344633856 1940225296 19.149 100 20 40 1 1956493664 9712144 6556224
21:45:55 63218 8192000000 10873990896 11336863744 1883899536 18.697 97 15 30 0 1904953632 16921648 4132448
21:47:05 38969 8192000000 10869180272 11337089024 1921314368 18.997 99 31 62 0 1941908528 11294800 9299360
21:47:59 42418 8192000000 10883920672 11360026624 1945708608 19.192 100 19 38 2 1969333568 18043600 5581360
21:48:47 101985 8192000000 10882081968 11354963968 1894193840 18.780 97 14 28 0 1916505152 17720336 4590976
21:50:44 77370 8192000000 10850071408 11321491456 1832336496 18.278 94 20 40 1 1856036560 18115792 5584272
21:52:15 16011 8192000000 10889848592 11336749056 1918065488 18.971 99 36 73 0 1936188064 7821712 10300864
21:52:38 26080 8192000000 10912769376 11366473728 1956471040 19.278 100 58 116 1 1988935664 16130768 16333856
21:53:20 31687 8192000000 10866083280 11336859648 1893785728 18.776 97 27 54 0 1917111632 15627888 7698016
21:54:02 51320 8192000000 10867167568 11348369408 1932204256 19.084 100 13 26 0 1951958576 16061168 3693152
21:55:02 22644 8192000000 10908107440 11364814848 1953205504 19.252 100 28 56 0 1972129888 11150992 7773392
21:55:32 7727 8192000000 10920406320 11371073536 1963114576 19.331 100 47 94 0 1990971216 15069840 12786800
21:55:47 9000 8192000000 10907302176 11351470080 1944152848 19.180 99 51 100 1 1974899472 17271872 13474752
21:56:02 6319 8192000000 10909969024 11364548608 1958053296 19.291 100 49 98 1 1985233568 13748288 13431984
21:56:15 35744 8192000000 10892552784 11366510592 1953444352 19.254 100 33 66 0 1976213072 13675040 9093680
21:56:59 57754 8192000000 10879854736 11364274176 1940846416 19.154 99 11 22 0 1954152272 10138048 3167808
21:58:03 26850 8192000000 10890300112 11364392960 1966146416 19.355 100 30 60 1 1984331360 9731456 8453488
21:59:04 86749 8192000000 10909247536 11395125248 1975522816 19.429 100 40 81 0 2003056432 15630096 11903520
22:00:55 49641 8192000000 10897439968 11399622656 1974145120 19.418 100 9 18 1 1991785328 15653824 1986384
22:02:00 42374 8192000000 10895098720 11384987648 1976548576 19.437 100 7 14 0 1985602496 7536112 1517808
22:03:09 70922 8192000000 10917604064 11397783552 1987627552 19.525 100 4 8 0 1995577424 7140400 809472
22:04:30 69629 8192000000 10890196928 11367751680 1914938496 18.946 96 9 18 0 1924414256 7095584 2380176
22:05:47 33097 8192000000 10901335360 11376508928 1959399936 19.301 99 25 50 1 1973906624 7877536 6629152
22:06:43 45119 8192000000 10908716352 11376037888 1943773408 19.177 98 37 71 3 1961618240 7820384 10024448
22:07:35 85652 8192000000 10882980656 11364900864 1856202096 18.472 94 17 34 0 1870059984 9090976 4766912
22:09:07 59516 8192000000 10870391424 11329368064 1812440336 18.116 92 31 60 0 1830088512 9346848 8301328
22:10:13 27969 8192000000 10865943712 11322105856 1874398896 18.620 97 35 70 2 1897266032 12619776 10247360
22:10:48 42120 8192000000 10866289568 11319808000 1874974800 18.625 97 47 94 2 1902431904 14062768 13394336
22:11:55 101228 8192000000 10876209392 11339767808 1865171968 18.545 96 16 32 1 1886735648 16954720 4608960
22:13:45 34180 8192000000 10903437600 11349983232 1913310848 18.933 98 18 36 2 1927429760 9240784 4878128
22:14:26 37152 8192000000 10902408384 11363237888 1937390368 19.126 99 34 68 0 1959359872 12335152 9634352
22:15:14 114541 8192000000 10873010640 11346497536 1810051840 18.096 93 11 22 1 1826182720 13077104 3053776
22:17:15 51837 8192000000 10869203888 11326005248 1854851040 18.462 95 34 66 0 1877793616 13579488 9363088
22:18:16 73059 8192000000 10859832336 11341209600 1914089920 18.939 99 23 45 2 1935458016 14239504 7128592
22:19:54 75292 8192000000 10850004976 11326341120 1876027536 18.633 97 16 32 1 1893402608 12610896 4764176
22:21:15 24160 8192000000 10827444544 11319697408 1893465152 18.774 99 3 6 1 1905871648 11797760 608736
22:21:46 23462 8192000000 10826029200 11307266048 1894795808 18.784 99 9 18 0 1906635712 9243408 2596496
22:22:27 67730 8192000000 10813599760 11294752768 1878807024 18.655 98 11 22 0 1890607552 8765472 3035056
22:24:19 74700 8192000000 10854442768 11339767808 1915924752 18.954 99 9 18 0 1924923408 6482880 2515776
22:25:40 80182 8192000000 10847711408 11340812288 1923995600 19.019 99 18 36 1 1940380704 11063408 5321696
22:27:06 34879 8192000000 9665493664 10011574272 803551840 8.932 42 7 14 0 810551024 5403024 1596160

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:34, from 13-06-2021 22:29:23 to 13-06-2021 22:29:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 136 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 13-06-2021 22:29:58 to 13-06-2021 22:30:00.

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          248265
MON$OLDEST_ACTIVE               248624
MON$OLDEST_SNAPSHOT             248624
MON$NEXT_TRANSACTION            248624
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                       2041888
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.33473 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33473 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33473 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33473 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 ---
:104: 
:105: mscs-test-161.budzdorov.ru    Sun Jun 13 22:27:47 2021
:106:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:107: 
:108: 
:109: mscs-test-161.budzdorov.ru    Sun Jun 13 22:27:47 2021
:110:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:111: 
:112: 
:113: mscs-test-161.budzdorov.ru    Sun Jun 13 22:27:49 2021
:114:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:115: 
--- end of diff output ---

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

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