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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-01 01:27:17
DTS_END                         2021-03-01 01:27:17.0940
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(676:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44870
TRN_ID                          237024
ATT_ID                          611
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: 9693.85 17408 1163262
customer order: creation 170.63 356 20476
customer order: refuse 15.00 350 1800
order to supplier: creation 45.81 1454 5497
order to supplier: removal 3.50 101759 420
invoice (draft): creation 46.10 3180 5532
invoice (draft): removal 58.33 759 7000
invoice accept: apply 40.91 17172 4909
invoice accept: cancel 51.96 701 6235
customer reserve: creation 3816.75 168 458010
customer reserve: removal 5141.42 54 616970
realization accept: apply 82.58 189 9909
realization accept: cancel 92.78 109 11134
payment from customer: creation 58.40 133 7008
payment from customer: removal 5.97 69 716
payment to supplier: creation 48.44 132 5813
payment to supplier: removal 3.55 60 426
service: total inventory turnovers 4.66 1285 559
service: total monetary turnovers 6.29 45 755
service: aggregate perf. data 0.74 24139 89
service: refresh index statistics 0.03 196053 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-03-2021 01:27:55 to 01-03-2021 01:27:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4573
TEST_TIME 2 4536
TEST_TIME 3 4829
TEST_TIME 4 5197
TEST_TIME 5 4989
TEST_TIME 6 5392
TEST_TIME 7 5564
TEST_TIME 8 5603
TEST_TIME 9 5866
TEST_TIME 10 6212
TEST_TIME 11 6507
TEST_TIME 12 6970
TEST_TIME 13 7445
TEST_TIME 14 7368
TEST_TIME 15 7499
TEST_TIME 16 7592
TEST_TIME 17 7669
TEST_TIME 18 7914
TEST_TIME 19 7958
TEST_TIME 20 7999
TEST_TIME 21 8592
TEST_TIME 22 9021
TEST_TIME 23 9005
TEST_TIME 24 9592
TEST_TIME 25 9598
TEST_TIME 26 10129
TEST_TIME 27 10058
TEST_TIME 28 10279
TEST_TIME 29 10733
TEST_TIME 30 11012
TEST_TIME 31 10879
TEST_TIME 32 10790
TEST_TIME 33 10636
TEST_TIME 34 10659
TEST_TIME 35 10652
TEST_TIME 36 10554
TEST_TIME 37 10616
TEST_TIME 38 10812
TEST_TIME 39 10729
TEST_TIME 40 10710
TEST_TIME 41 10645
TEST_TIME 42 10561
TEST_TIME 43 10354
TEST_TIME 44 10313
TEST_TIME 45 10242
TEST_TIME 46 10144
TEST_TIME 47 10107
TEST_TIME 48 10065
TEST_TIME 49 9993
TEST_TIME 50 9965
TEST_TIME 51 10072
TEST_TIME 52 10044
TEST_TIME 53 9936
TEST_TIME 54 9854
TEST_TIME 55 9765
TEST_TIME 56 9698
TEST_TIME 57 9840
TEST_TIME 58 9878
TEST_TIME 59 9931
TEST_TIME 60 9859
TEST_TIME 61 9869
TEST_TIME 62 9903
TEST_TIME 63 9912
TEST_TIME 64 9988
TEST_TIME 65 9917
TEST_TIME 66 10011
TEST_TIME 67 10070
TEST_TIME 68 10098
TEST_TIME 69 10109
TEST_TIME 70 10069
TEST_TIME 71 10014
TEST_TIME 72 9994
TEST_TIME 73 9921
TEST_TIME 74 9910
TEST_TIME 75 9855
TEST_TIME 76 9869
TEST_TIME 77 9817
TEST_TIME 78 9760
TEST_TIME 79 9828
TEST_TIME 80 9757
TEST_TIME 81 9723
TEST_TIME 82 9738
TEST_TIME 83 9710
TEST_TIME 84 9726
TEST_TIME 85 9738
TEST_TIME 86 9716
TEST_TIME 87 9712
TEST_TIME 88 9698
TEST_TIME 89 9748
TEST_TIME 90 9735
TEST_TIME 91 9753
TEST_TIME 92 9773
TEST_TIME 93 9858
TEST_TIME 94 9855
TEST_TIME 95 9879
TEST_TIME 96 9825
TEST_TIME 97 9744
TEST_TIME 98 9762
TEST_TIME 99 9701
TEST_TIME 100 9660
TEST_TIME 101 9677
TEST_TIME 102 9760
TEST_TIME 103 9736
TEST_TIME 104 9708
TEST_TIME 105 9640
TEST_TIME 106 9619
TEST_TIME 107 9589
TEST_TIME 108 9557
TEST_TIME 109 9564
TEST_TIME 110 9588
TEST_TIME 111 9581
TEST_TIME 112 9602
TEST_TIME 113 9586
TEST_TIME 114 9606
TEST_TIME 115 9638
TEST_TIME 116 9690
TEST_TIME 117 9670
TEST_TIME 118 9676
TEST_TIME 119 9771
TEST_TIME 120 9701

Performance per minute, chart


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

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 1588168 1588168 0 0.00 0 16316 6 0 0
doc_list_biud 1588164 1588164 0 0.00 0 27258 27 0 0
sp_add_invoice_to_stock 5011 4909 102 2.03 36 175101 17172 0 102
sp_cancel_adding_invoice 6235 6235 0 0.00 5 81459 701 0 0
sp_cancel_client_order 1800 1800 0 0.00 4 11092 351 0 0
sp_cancel_customer_reserve 616970 616970 0 0.00 1 19363 54 0 0
sp_cancel_pay_from_customer 716 716 0 0.00 3 5338 69 0 0
sp_cancel_pay_to_supplier 426 426 0 0.00 3 2241 60 0 0
sp_cancel_supplier_invoice 7015 7000 15 0.21 2 27264 760 0 15
sp_cancel_supplier_order 420 420 0 0.00 14 917062 101759 0 0
sp_cancel_write_off 11134 11134 0 0.00 1 17065 109 0 0
sp_client_order 20476 20476 0 0.00 4 17966 357 0 0
sp_customer_reserve 458010 458010 0 0.00 0 38341 169 0 0
sp_fill_shopping_cart 31504 31504 0 0.00 1 15463 37 0 0
sp_fill_shopping_cart_clo_res 457991 457991 0 0.00 0 13358 13 0 0
sp_get_clo_for_invoice 4889 4889 0 0.00 0 23548 259 0 0
sp_kill_cost_storno 18511 18511 0 0.00 0 6426 56 0 0
sp_kill_qstorno_ret_qs2qd 1252494 1252494 0 0.00 0 27255 30 0 0
sp_kill_qty_storno 658356 658356 0 0.00 0 27257 64 0 0
sp_lock_selected_doc 20653 20653 0 0.00 0 6826 4 0 0
sp_make_cost_storno 27619 27619 0 0.00 0 12971 54 0 0
sp_multiply_rows_for_pdistr 27618 27618 0 0.00 0 6701 29 0 0
sp_multiply_rows_for_qdistr 20476 20476 0 0.00 0 15393 172 0 0
sp_pay_from_customer 7008 7008 0 0.00 4 27827 133 0 0
sp_pay_to_supplier 5813 5813 0 0.00 5 13300 133 0 0
sp_payment_common 12821 12821 0 0.00 1 27820 46 0 0
sp_qd_handle_on_cancel_clo 1800 1800 0 0.00 0 9596 319 0 0
sp_qd_handle_on_invoice_upd_sts 11123 11123 0 0.00 0 23802 314 0 0
sp_qd_handle_on_reserve_upd_sts 9909 9909 0 0.00 0 16544 72 0 0
sp_reserve_write_off 9909 9909 0 0.00 6 16594 189 0 0
sp_supplier_invoice 5532 5532 0 0.00 7 86868 3180 0 0
sp_supplier_order 5497 5497 0 0.00 5 28879 1455 0 0
srv_aggregate_perf_data 90 89 1 1.11 3109 240407 24139 0 1
srv_fill_mon_cache_memory 158 158 0 0.00 1113 145108 32766 0 0
srv_find_qd_qs_mism 1116283 1116283 0 0.00 0 16315 4 0 0
srv_make_invnt_saldo 559 559 0 0.00 44 131310 1286 0 0
srv_make_money_saldo 755 755 0 0.00 0 11988 45 0 0
srv_recalc_idx_stat 4 4 0 0.00 156263 257238 196054 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 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 4909 4909 0 0.00 0 11762 169 0 0
t$perf-norm:sp_cancel_adding_invoice 385 385 0 0.00 0 4706 110 0 0
t$perf-norm:sp_cancel_client_order 1800 1800 0 0.00 0 6806 18 0 0
t$perf-norm:sp_cancel_customer_reserve 711 711 0 0.00 0 4377 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 716 716 0 0.00 0 2690 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 426 426 0 0.00 0 1824 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 3244 20 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 15448 1597 0 0
t$perf-norm:sp_cancel_write_off 964 964 0 0.00 0 9713 19 0 0
t$perf-norm:sp_client_order 20476 20476 0 0.00 0 12559 20 0 0
t$perf-norm:sp_customer_reserve 981 981 0 0.00 0 4682 14 0 0
t$perf-norm:sp_pay_from_customer 7008 7008 0 0.00 0 14477 20 0 0
t$perf-norm:sp_pay_to_supplier 5813 5813 0 0.00 0 4686 12 0 0
t$perf-norm:sp_reserve_write_off 9909 9909 0 0.00 0 6623 12 0 0
t$perf-norm:sp_supplier_invoice 5532 5532 0 0.00 0 15091 25 0 0
t$perf-norm:sp_supplier_order 5497 5497 0 0.00 0 15312 28 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 233 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 1839 22 0 0
t$perf-norm:srv_make_invnt_saldo 559 559 0 0.00 0 1988 23 0 0
t$perf-norm:srv_make_money_saldo 755 755 0 0.00 0 4938 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 12 4 0 0
v_add_invoice_to_stock 9980 9776 204 2.04 0 6168 19 0 204
v_all_customers 37018 37018 0 0.00 0 93 1 0 0
v_all_suppliers 30658 30658 0 0.00 0 196 1 0 0
v_all_wares 40952 40952 0 0.00 0 113 1 0 0
v_cancel_adding_invoice 770 770 0 0.00 0 15402 26 0 0
v_cancel_client_order 3600 3600 0 0.00 0 11044 8 0 0
v_cancel_customer_prepayment 1432 1432 0 0.00 0 707 5 0 0
v_cancel_customer_reserve 1422 1422 0 0.00 0 2363 6 0 0
v_cancel_payment_to_supplier 852 852 0 0.00 0 2220 7 0 0
v_cancel_supplier_invoice 898 868 30 3.34 0 15388 43 0 30
v_cancel_supplier_order 840 840 0 0.00 0 921 5 0 0
v_cancel_write_off 1928 1928 0 0.00 0 2700 17 0 0
v_max_id_clo_ord 5497 5497 0 0.00 0 410 1 0 0
v_max_id_clo_res 981 981 0 0.00 0 3063 22 0 0
v_max_id_ord_sup 5531 5531 0 0.00 0 7828 6 0 0
v_max_non_paid_invoice 1512 1512 0 0.00 0 182 2 0 0
v_max_non_paid_realizn 3784 3784 0 0.00 0 1690 3 0 0
v_min_id_clo_ord 5497 5497 0 0.00 0 1431 5 0 0
v_min_id_clo_res 981 981 0 0.00 0 6850 12 0 0
v_min_id_ord_sup 5531 5531 0 0.00 0 3080 5 0 0
v_min_non_paid_invoice 5813 5813 0 0.00 0 13254 36 0 0
v_min_non_paid_realizn 7008 7008 0 0.00 0 7203 24 0 0
v_our_firm 10382 10382 0 0.00 0 14 1 0 0
v_reserve_write_off 19818 19818 0 0.00 0 13601 7 0 0
x_lock_depdocs_on_canc_invoice 12801 12801 0 0.00 0 12615 102 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 7355 322 0 0
x_make_qstorno_1000_1200 5497 5497 0 0.00 2 28873 1373 0 0
x_make_qstorno_1200_2000 5532 5532 0 0.00 3 86848 3054 0 0
x_make_qstorno_2100_3300 458010 458010 0 0.00 0 38340 154 0 0

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

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:20 2 8192000000 8804656304 8816791552 10294192 0.125 2 2 3 0 10472624 66144 112288
22:57:27 23456 8192000000 10285078768 10595225600 916054832 10.057 72 53 103 0 935677600 2559536 17063232
22:58:00 10825 8192000000 10334849472 10649632768 1391011088 14.515 100 88 176 0 1425452000 5276144 29164768
22:58:22 21343 8192000000 10361086352 10683490304 1417649920 14.752 100 88 176 0 1452602176 6290048 28662208
22:58:54 17552 8192000000 10387231184 10711363584 1445919936 15.002 100 85 170 0 1480750544 6983744 27846864
22:59:23 23558 8192000000 10425664144 10753413120 1471175536 15.224 100 91 182 0 1508755520 7746960 29833024
22:59:55 13780 8192000000 10428140704 10761314304 1484360800 15.340 100 85 170 0 1520560528 8471136 27728592
23:00:23 16500 8192000000 10453297984 10790256640 1509491024 15.559 100 89 178 0 1546911632 8917504 28503104
23:01:02 18086 8192000000 10478673760 10819215360 1532517216 15.759 100 87 174 1 1569547792 9658704 27371872
23:01:30 13578 8192000000 10502166320 10843328512 1554307824 15.947 100 94 188 0 1593638592 10353552 28977216
23:01:52 17936 8192000000 10517300224 10868330496 1579809328 16.167 100 82 164 2 1615635328 10532704 25293296
23:02:20 15683 8192000000 10545753488 10896736256 1605912224 16.390 100 80 159 0 1640372704 10081840 24378640
23:02:47 13869 8192000000 10562513216 10925281280 1629828816 16.593 100 83 164 0 1665137552 10536992 24771744
23:03:10 11925 8192000000 10578789856 10943524864 1646772624 16.737 100 71 142 2 1678243456 10797168 20673664
23:03:30 11949 8192000000 10614453232 10975420416 1670263088 16.935 100 83 166 1 1706627968 11804560 24560320
23:03:50 10595 8192000000 10623733552 10990493696 1684334528 17.054 100 78 156 0 1719375824 12438528 22602768
23:04:09 8269 8192000000 10637941680 11008659456 1703794224 17.217 100 80 160 1 1739193696 12688784 22710688
23:04:25 6606 8192000000 10661346592 11029889024 1718170800 17.337 100 84 168 0 1754372384 12415616 23785968
23:04:38 6762 8192000000 10657173392 11032223744 1726379648 17.405 100 79 158 1 1761954016 13244512 22329856
23:04:52 8011 8192000000 10674499856 11047190528 1735970464 17.485 100 79 155 1 1771346528 13444592 21931472
23:05:06 5611 8192000000 10687246576 11059355648 1747059200 17.577 100 90 180 1 1786595680 13541920 25994560
23:05:20 5033 8192000000 10694237136 11069816832 1752149360 17.619 100 78 156 2 1787394608 13447600 21797648
23:05:31 3433 8192000000 10709631792 11086090240 1768659520 17.756 100 81 159 1 1804343504 13204208 22479776
23:05:42 2856 8192000000 10716806848 11096403968 1776563776 17.821 100 80 157 0 1811296496 12478688 22254032
23:05:51 3376 8192000000 10741972832 11119767552 1792750896 17.954 100 75 150 1 1825663808 11700016 21212896
23:06:02 4355 8192000000 10747361824 11129614336 1802754672 18.037 100 85 167 1 1838092496 12159824 23178000
23:06:13 4009 8192000000 10749847984 11134607360 1815158224 18.138 100 92 182 2 1858371312 17618480 25594608
23:06:24 6006 8192000000 10756583744 11142496256 1813200320 18.122 100 72 145 0 1845787616 12617568 19969728
23:06:37 3329 8192000000 10772052000 11159265280 1829029456 18.251 100 91 182 0 1868227552 14069696 25128400
23:06:47 3890 8192000000 10775558352 11165212672 1837609888 18.321 100 85 170 2 1875282960 14593664 23079408
23:06:57 1707 8192000000 10790895984 11173642240 1841421984 18.352 100 95 191 1 1884285600 15925680 26937936
23:07:05 2019 8192000000 10787556112 11176194048 1847113040 18.399 100 80 160 2 1883399584 13852240 22434304
23:07:13 2471 8192000000 10790525120 11179798528 1854944944 18.462 100 91 182 1 1894461008 13370672 26145392
23:07:21 2205 8192000000 10798042304 11186204672 1857578656 18.484 100 88 177 0 1896331984 14391696 24361632
23:07:30 1186 8192000000 10804480080 11191791616 1863351392 18.530 100 90 182 1 1901929056 13021744 25555920
23:07:37 2386 8192000000 10815860416 11202981888 1865044336 18.544 100 94 189 1 1905063456 13444816 26574304
23:07:46 1719 8192000000 10813155392 11203305472 1874356848 18.620 100 97 191 1 1914487264 13707520 26422896
23:07:54 32663 8192000000 10806681936 11203170304 1871874688 18.599 100 83 168 1 1907320976 11879712 23566576
23:08:33 2150 8192000000 10803929280 11208343552 1872611520 18.605 100 68 134 2 1902983536 11400448 18971568
23:08:42 5902 8192000000 10802318704 11210006528 1868738752 18.574 100 46 93 0 1892086144 10591536 12755856
23:08:54 3057 8192000000 10797581776 11212820480 1873739216 18.615 100 49 98 1 1896487280 9891472 12856592
23:09:03 7206 8192000000 10802293152 11220037632 1879425664 18.660 100 46 92 0 1906422960 14570704 12426592
23:09:17 9684 8192000000 10796660224 11219705856 1879302288 18.659 100 35 70 0 1898238416 9249136 9686992
23:09:38 5686 8192000000 10780863840 11212050432 1880620944 18.670 100 27 54 6 1895946832 7413360 7912528
23:09:49 8035 8192000000 10790871728 11219062784 1883759952 18.695 100 35 71 2 1900419792 6936176 9723664
23:10:04 9236 8192000000 10788678592 11218685952 1883334432 18.692 100 27 54 2 1897495536 6530976 7630128
23:10:22 12645 8192000000 10792268400 11223937024 1884617872 18.702 100 17 34 1 1895187936 5771232 4798832
23:10:45 7864 8192000000 10798733648 11229802496 1888914064 18.737 100 23 45 2 1901928752 6235776 6778912
23:11:01 62851 8192000000 10819453664 11236954112 1891679600 18.759 100 29 58 0 1906599056 5654832 9264624
23:12:19 16606 8192000000 10806152496 11239579648 1893682864 18.775 100 30 60 1 1908558704 6342000 8533840
23:12:43 12146 8192000000 10816643728 11244171264 1894544208 18.782 100 19 40 0 1905692016 5827456 5320352
23:13:03 5146 8192000000 10813107984 11245162496 1898456896 18.814 100 26 51 4 1912171504 6040048 7674560
23:13:16 6558 8192000000 10818006880 11250716672 1906611968 18.879 100 31 60 4 1921047584 5528768 8906848
23:13:29 5048 8192000000 10813934032 11249729536 1902376944 18.845 100 19 39 0 1913079616 5784352 4918320
23:13:43 5822 8192000000 10818788784 11255459840 1905116912 18.867 100 32 64 0 1921347856 7091984 9138960
23:14:01 6426 8192000000 10831221744 11257778176 1904989344 18.866 100 24 48 0 1918743264 6953792 6800128
23:14:16 9863 8192000000 10825684864 11256774656 1908344912 18.893 100 20 40 2 1923768944 9548224 5875808
23:14:35 10990 8192000000 10815089472 11257069568 1909109968 18.900 100 16 31 2 1919907232 5393408 5403856
23:14:54 8976 8192000000 10819254448 11262398464 1913413472 18.934 100 25 50 2 1927483280 6840784 7229024
23:15:12 6974 8192000000 10814101664 11247493120 1894343248 18.781 99 20 40 1 1905866128 5782400 5740480
23:15:28 9360 8192000000 10815970288 11254046720 1889993168 18.746 99 20 40 0 1901325312 4842912 6489232
23:15:43 13766 8192000000 10812896704 11248123904 1888946400 18.737 99 26 53 0 1901950064 6037968 6965696
23:16:06 45981 8192000000 10837625584 11251871744 1896091232 18.795 99 60 117 3 1918739088 5803568 16844288
23:16:58 14349 8192000000 10797522688 11229261824 1829177088 18.253 96 26 52 2 1842948608 6513376 7258144
23:17:18 8749 8192000000 10800926944 11233931264 1867354912 18.563 99 29 57 2 1882563616 7068608 8140096
23:17:34 8107 8192000000 10799571712 11231092736 1871550240 18.597 99 39 79 2 1897417568 15420736 10446592
23:17:49 5980 8192000000 10785264848 11208724480 1844256608 18.375 98 33 66 1 1859973632 6675568 9041456
23:18:01 6650 8192000000 10785040304 11203665920 1846667248 18.395 99 39 76 1 1864568880 6348176 11553456
23:18:18 5600 8192000000 10796924288 11221196800 1871613056 18.597 100 28 55 2 1886188336 6509584 8065696
23:18:30 6742 8192000000 10784249440 11211124736 1835831648 18.307 98 24 48 1 1853314448 9942816 7539984
23:18:48 7836 8192000000 10723040112 11146096640 1795997440 17.981 98 22 44 0 1808363104 5697056 6668608
23:19:02 8779 8192000000 10707850128 11122438144 1728374720 17.422 95 25 49 2 1741496880 6149520 6972640
23:19:17 8105 8192000000 10699404880 11115429888 1724005344 17.386 95 24 49 0 1741366896 10653888 6707664
23:19:37 9495 8192000000 10683295600 11098292224 1720289872 17.355 96 19 37 2 1731262384 5543120 5429392
23:19:54 8823 8192000000 10696583872 11115458560 1759649184 17.681 98 28 55 2 1773533936 5421008 8463744
23:20:13 49886 8192000000 10668267200 11070672896 1631702688 16.609 91 36 72 2 1647022592 4708768 10611136
23:21:25 12333 8192000000 10670838384 11086569472 1714328736 17.305 97 18 36 0 1725312512 6046064 4937712
23:21:43 12991 8192000000 10717271568 11132739584 1790818352 17.939 100 18 36 2 1805626768 9966864 4841552
23:22:03 7797 8192000000 10716609104 11129069568 1757734688 17.666 98 32 64 0 1777519808 10714000 9071120
23:22:19 4829 8192000000 10725891328 11143176192 1811219152 18.106 100 42 84 3 1829434080 6143920 12071008
23:22:31 8784 8192000000 10744084656 11166961664 1818968720 18.169 100 34 68 2 1835612192 6604256 10039216
23:22:46 8821 8192000000 10736222240 11159318528 1811791392 18.111 99 21 42 0 1823659408 5425888 6442128
23:23:01 11695 8192000000 10737006704 11162943488 1825393664 18.222 100 23 46 3 1837240832 5297488 6549680
23:23:19 9641 8192000000 10759973840 11184680960 1835337168 18.303 100 17 34 0 1844931520 5150512 4443840
23:23:35 8528 8192000000 10760328352 11185405952 1845136160 18.383 100 25 50 2 1862402000 10250880 7014960
23:23:49 10052 8192000000 10770973360 11194576896 1848240176 18.408 100 24 48 0 1865112032 10052144 6819712
23:24:05 12395 8192000000 10765946896 11193241600 1852336032 18.441 100 21 42 0 1864969344 5711584 6921728
23:24:28 10178 8192000000 10773397792 11201703936 1860426704 18.507 100 29 58 2 1875654960 6688304 8539952
23:24:46 9752 8192000000 10774791200 11201716224 1859101232 18.496 100 20 40 0 1871188848 6494592 5593024
23:25:05 5382 8192000000 10772417872 11202437120 1865048176 18.544 100 28 56 0 1880133456 6571264 8514016
23:25:19 19045 8192000000 10773312144 11204943872 1862342896 18.522 100 23 46 2 1875785936 6172384 7270656
23:25:49 76836 8192000000 10782095296 11210854400 1866917664 18.559 100 21 42 1 1878241856 5304528 6019664
23:27:12 7333 8192000000 10803349856 11231981568 1886101104 18.714 100 25 50 0 1898367008 5709968 6555936
23:27:29 14123 8192000000 10831569200 11250376704 1901232896 18.836 100 46 92 1 1921092848 6179264 13680688
23:27:51 24752 8192000000 10845875792 11261640704 1909405520 18.902 100 51 102 2 1932154832 8460320 14288992
23:28:33 25151 8192000000 10851810720 11276115968 1918946352 18.978 100 52 104 1 1943401376 9953760 14501264
23:29:09 11683 8192000000 10862204288 11280519168 1926802144 19.041 100 41 82 1 1947652176 9421216 11428816
23:29:27 33972 8192000000 10858052976 11289640960 1935076880 19.107 100 42 83 0 1957176864 9686912 12413072
23:30:08 36955 8192000000 10865211312 11307233280 1942248608 19.165 100 38 76 2 1965049408 11589472 11211328
23:30:53 49014 8192000000 10876089296 11315683328 1953095312 19.251 100 35 70 1 1976081792 12161232 10825248
23:32:00 32449 8192000000 10891077296 11323359232 1959959776 19.306 100 30 60 1 1984695584 15522864 9212944
23:32:39 9725 8192000000 10909930784 11340083200 1965163824 19.347 100 40 80 0 1991128112 12997424 12966864
23:33:00 24761 8192000000 10905251456 11339366400 1974899728 19.424 100 51 100 2 2002284240 12566256 14818256
23:33:33 10806 8192000000 10916252272 11342979072 1974760224 19.423 100 49 96 1 2005400912 16475072 14165616
23:33:56 22900 8192000000 10908368224 11343527936 1973811840 19.416 100 36 72 0 1997508144 12771344 10924960
23:34:36 13115 8192000000 10919076400 11354382336 1977533280 19.445 100 46 92 0 2006417040 15107200 13776560
23:34:57 5777 8192000000 10924278256 11359465472 1982508384 19.485 100 48 96 3 2013047360 15990992 14547984
23:35:25 21319 8192000000 10930035280 11368710144 1980118096 19.466 100 43 86 1 2010952064 17043536 13790432
23:36:01 20505 8192000000 10941362624 11369406464 1970280320 19.388 99 48 94 0 2003924880 18705072 14939488
23:36:34 12321 8192000000 10938587312 11372093440 1987940688 19.528 100 51 102 1 2024178848 20991712 15246448
23:37:01 6417 8192000000 10942818080 11377197056 1991754576 19.558 100 45 87 3 2028334064 23272464 13307024
23:37:16 4604 8192000000 10952413968 11386503168 1998776560 19.613 100 61 118 3 2038593648 22199536 17617552
23:37:28 2007 8192000000 10956051744 11388628992 2004560704 19.659 100 70 136 1 2046734832 22861312 19312816
23:37:36 2787 8192000000 10976815184 11397496832 2012246384 19.719 100 77 151 1 2059683088 24750400 22686304
23:37:46 3754 8192000000 10978619536 11405266944 2013057568 19.726 100 75 148 0 2062698752 27734768 21906416
23:37:56 2668 8192000000 10979653136 11402219520 1997316672 19.602 99 83 166 0 2048340176 25985872 25037632
23:38:06 3525 8192000000 10986146080 11403841536 2009975152 19.701 100 82 164 1 2062993840 28461328 24557360
23:38:18 3481 8192000000 10971828176 11397525504 1990976320 19.552 99 79 158 0 2042237920 27530496 23731104
23:38:28 2576 8192000000 10980500320 11401637888 2009747056 19.700 100 85 171 2 2069124416 33151712 26225648
23:38:38 3921 8192000000 10983114224 11409268736 2013055520 19.726 100 85 167 2 2069142320 30013728 26073072
23:38:50 7950 8192000000 10984399648 11418148864 2018392240 19.768 100 72 144 2 2075457008 35041392 22023376
23:39:06 8099 8192000000 10968146752 11396431872 1966492192 19.358 98 67 133 0 2015056704 28907472 19657040
23:39:22 7171 8192000000 10960051360 11392397312 1991352288 19.554 100 71 142 2 2046352720 33224128 21776304
23:39:41 5468 8192000000 10952320592 11389575168 1991452464 19.555 100 54 107 1 2040075104 31056752 17565888
23:39:57 10977 8192000000 10941941648 11383001088 1990269600 19.546 100 45 89 2 2031379104 26549152 14560352
23:40:17 5107 8192000000 10955540832 11401768960 2005616304 19.667 100 59 119 3 2051433392 28040800 17776288
23:40:34 3271 8192000000 10968575872 11406815232 2010123728 19.702 100 53 106 1 2054283776 28306928 15853120
23:40:45 5409 8192000000 10995924720 11418591232 2017081072 19.757 100 75 149 0 2070460736 30716672 22662992
23:41:09 15588 8192000000 10992281792 11423625216 2024233664 19.813 100 77 153 1 2074152416 26931296 22987456
23:41:31 6007 8192000000 11002165168 11432304640 2030652800 19.864 100 85 169 1 2085160080 29230080 25277200
23:41:44 9471 8192000000 10993128720 11428376576 2025008032 19.819 100 66 132 0 2073733328 28851872 19873424
23:42:02 3937 8192000000 10997845536 11434606592 2030794624 19.865 100 70 138 1 2082203056 29642976 21765456
23:42:14 5481 8192000000 10985345312 11419234304 2003819008 19.653 99 71 141 0 2056059920 30306784 21934128
23:42:29 3899 8192000000 10989705360 11425325056 2022579440 19.800 100 71 142 0 2077469472 33134128 21755904
23:42:40 1111 8192000000 11007314928 11434909696 2033086368 19.883 100 90 175 1 2088717632 30110880 25520384
23:42:48 5840 8192000000 11004134240 11430285312 2011973376 19.717 99 83 166 1 2069443632 31748752 25721504
23:43:01 1383 8192000000 10998405008 11427303424 2024459280 19.815 100 86 173 1 2084223056 32349376 27414400
23:43:09 1610 8192000000 10998954624 11418591232 2003930592 19.654 99 87 174 2 2062765824 32609760 26225472
23:43:18 2760 8192000000 10991315952 11414306816 2010267136 19.704 100 87 173 1 2071681312 35599888 25814288
23:43:28 2174 8192000000 10995540960 11412881408 2010043504 19.702 100 90 178 1 2073739216 35930192 27765520
23:43:38 2092 8192000000 10987564192 11407716352 2006880224 19.677 100 89 178 0 2070966144 37007248 27078672
23:43:51 2203 8192000000 10996712096 11418120192 2013189712 19.727 100 89 179 1 2078904528 37929424 27785392
23:44:00 4029 8192000000 10969692352 11401994240 1992927792 19.567 99 73 146 0 2055782448 39989808 22864848
23:44:15 11281 8192000000 10938004080 11387154432 1962510768 19.326 99 46 92 1 2016233920 38889936 14833216
23:44:47 12182 8192000000 10941330192 11382439936 1974512784 19.421 100 46 92 0 2029323776 39277184 15533808
23:45:08 6732 8192000000 10977712288 11408801792 1998032864 19.607 100 63 126 1 2058544480 40253632 20257984
23:45:25 2857 8192000000 10962294704 11384573952 1977935776 19.448 99 86 171 1 2046168384 41541264 26691344
23:45:35 12444 8192000000 10954991648 11403005952 1986944112 19.520 100 55 110 1 2052432000 47700336 17787552
23:45:57 9338 8192000000 10942746880 11395121152 1966756672 19.360 99 31 62 1 2018557808 40777920 11023216
23:46:18 6937 8192000000 10960648496 11400826880 1986443872 19.516 100 45 89 0 2041078768 40121888 14513008
23:46:32 3772 8192000000 10972522336 11398709248 1985337072 19.507 100 76 152 3 2053552688 44962944 23252672
23:46:45 8058 8192000000 10950517392 11393089536 1979436480 19.460 100 46 92 1 2041301952 46768416 15097056
23:47:03 9453 8192000000 10942246880 11378139136 1953335008 19.253 99 50 100 0 2016310768 46689040 16286720
23:47:20 1619 8192000000 10965031120 11386679296 1972318624 19.404 100 84 167 0 2048000320 48584832 27096864
23:47:32 4595 8192000000 10962093168 11392106496 1974733120 19.423 100 64 128 0 2044888560 49980656 20174784
23:47:46 10178 8192000000 10952769920 11378683904 1933824128 19.097 98 62 122 3 2006227888 52360768 20042992
23:48:04 6091 8192000000 10948428704 11390046208 1963515840 19.334 100 49 98 2 2033254736 53605616 16133280
23:48:29 15752 8192000000 10923128144 11371864064 1929465888 19.063 98 28 56 1 1983369056 43966784 9936384
23:48:50 5973 8192000000 10929597760 11362279424 1943914352 19.178 99 51 101 0 2006266304 45820304 16531648
23:49:12 10651 8192000000 10900443056 11349118976 1926977296 19.043 99 27 54 1 1978397008 42158528 9261184
23:49:30 15794 8192000000 10901400368 11341570048 1927433680 19.046 99 37 74 0 1984014112 44034480 12545952
23:50:05 11720 8192000000 10876384192 11314089984 1839424576 18.336 95 32 65 3 1894791952 44615280 10752096
23:50:23 10714 8192000000 10880029744 11323547648 1901811248 18.841 100 27 54 0 1958495008 46991152 9692608
23:50:46 3891 8192000000 10929629856 11349237760 1935115712 19.108 100 64 126 2 2002347536 46946336 20285488
23:50:57 8025 8192000000 10919164336 11361169408 1941145312 19.156 100 47 94 0 2007564288 50821920 15597056
23:51:30 18211 8192000000 10899642448 11355422720 1920923664 18.994 99 20 40 1 1966722912 39111728 6687520
23:51:55 16890 8192000000 10918989952 11366805504 1939972704 19.147 100 27 54 1 1993457904 44186448 9298752
23:52:23 27537 8192000000 10920480944 11367735296 1946471232 19.198 100 25 50 2 1997381984 41604640 9306112
23:52:57 29605 8192000000 10898321488 11367034880 1943478096 19.175 100 20 40 3 1991672528 41636208 6558224
23:53:59 18178 8192000000 10903909600 11357265920 1945980112 19.194 100 24 47 0 1985361616 31274832 8106672
23:54:24 15816 8192000000 10890635216 11349020672 1912414672 18.926 98 21 42 1 1953302784 33785392 7102720
23:55:14 28406 8192000000 10886051152 11349209088 1907321984 18.885 98 22 44 0 1951976960 37815616 6839360
23:55:51 29967 8192000000 10876536384 11347410944 1931953776 19.082 100 11 22 1 1967765808 32163904 3648128
23:56:28 37619 8192000000 10882745040 11361816576 1938297040 19.133 100 13 24 2 1963628752 21460240 3871472
23:57:38 123495 8192000000 10896133440 11351609344 1894433968 18.781 96 26 53 1 1914063872 12576144 7053760
23:59:51 64634 8192000000 10905451008 11366416384 1970587520 19.390 100 19 37 1 1987339472 11775472 4976480
00:01:24 104558 8192000000 10888113472 11355815936 1930454528 19.071 98 20 40 1 1944152384 7982128 5715728
00:03:15 78186 8192000000 10893778432 11376029696 1920358192 18.990 98 6 12 0 1935533360 13510480 1664688
00:04:52 112428 8192000000 10887942960 11357503488 1882840384 18.688 96 12 24 0 1913916576 27614688 3461504
00:07:01 145107 8192000000 10911378832 11383754752 1912803712 18.929 97 8 14 1 1933638832 19133584 1701536
00:10:22 76892 8192000000 10912090496 11374485504 1963218384 19.332 99 36 72 0 1987058000 13149264 10690352
00:11:49 30303 8192000000 10907316192 11359518720 1955732960 19.272 99 44 86 2 1977403664 9493888 12176816
00:12:27 39724 8192000000 10912989568 11371233280 1976660816 19.438 100 38 76 0 1996590720 9000608 10929296
00:13:14 39274 8192000000 10929729648 11386703872 1980876240 19.472 100 31 63 3 2000422256 10959936 8586080
00:14:11 14773 8192000000 10934646080 11386122240 1975238848 19.427 99 56 112 0 2007916848 16284688 16393312
00:14:33 11349 8192000000 10915982480 11377094656 1982154896 19.482 100 49 99 0 2013698880 17273136 14270848
00:15:04 31764 8192000000 10902095696 11376394240 1960770464 19.312 99 32 63 4 1983363600 12379856 10213280
00:15:47 12135 8192000000 10931428416 11381927936 1968633840 19.375 99 48 96 2 1996399984 13531120 14235024
00:16:06 38098 8192000000 10924463344 11373744128 1944427392 19.182 98 42 84 2 1971883024 15296368 12159264
00:16:55 46921 8192000000 10921569520 11387215872 1979134816 19.458 100 31 63 1 2011020832 22767760 9118256
00:18:04 37298 8192000000 10921048096 11380514816 1970083344 19.386 100 20 38 1 2000976784 24622816 6270624
00:18:48 27588 8192000000 10892184880 11375173632 1951462320 19.238 99 19 39 0 1969805600 12687904 5655376
00:19:58 59372 8192000000 10910509792 11378585600 1962354240 19.325 99 11 22 0 1977060400 11244592 3461568
00:21:04 51073 8192000000 10921717744 11383836672 1963281248 19.332 99 13 26 0 1979843968 12890480 3672240
00:22:04 53677 8192000000 10911282240 11387961344 1963934976 19.337 99 21 42 1 1987331728 17376480 6020272
00:23:38 53008 8192000000 10906759840 11404345344 1978312432 19.451 100 23 46 1 2004090800 19498064 6280304
00:24:37 61014 8192000000 10906158320 11380600832 1961799472 19.320 99 13 26 0 1977990128 12767888 3422768
00:25:54 80217 8192000000 10913550944 11393605632 1971273616 19.396 99 20 40 0 1988971984 11992752 5705616
00:27:20 29634 8192000000 10933338192 11402383360 1998489104 19.611 100 19 38 0 2011609072 7703568 5416400
00:27:57 24457 8192000000 10958721136 11412647936 1985641936 19.509 99 31 62 1 2000293616 5969136 8682544
00:28:30 73258 8192000000 10919285456 11398053888 1941732288 19.161 97 19 38 0 1959950208 12879344 5338576
00:29:49 80651 8192000000 10920183408 11386855424 1898358272 18.813 95 20 40 1 1923047568 18819744 5869552
00:31:19 75813 8192000000 10898790656 11359846400 1815320432 18.139 92 11 22 0 1833444720 15057360 3066928
00:32:41 88127 8192000000 10906120992 11385524224 1944316256 19.181 99 16 31 0 1967799168 19107744 4375168
00:34:15 91795 8192000000 10893515824 11367100416 1864267536 18.538 95 13 26 0 1887198640 19465520 3465584
00:35:53 48327 8192000000 10895458800 11348791296 1908809952 18.897 98 14 28 0 1925251744 12614656 3827136
00:36:48 49310 8192000000 10884061344 11325833216 1856572400 18.475 95 36 72 3 1873323056 6651824 10098832
00:37:44 5977 8192000000 10874516960 11305832448 1885989120 18.713 98 66 132 1 1915733552 10681408 19063024
00:37:56 17186 8192000000 10864555984 11308646400 1910048928 18.907 100 47 94 1 1936925296 13822288 13054080
00:38:22 76560 8192000000 10868758672 11318734848 1918560240 18.975 100 45 90 0 1947956848 16574016 12822592
00:39:45 109120 8192000000 10819489616 11291975680 1838969808 18.332 95 23 44 2 1855849328 9968544 6910976
00:41:51 58097 8192000000 10833198864 11295895552 1870975248 18.592 97 20 40 0 1888368864 11336400 6057216
00:42:57 44547 8192000000 10825291296 11293077504 1874517776 18.621 98 37 73 0 1898163968 12498704 11147488
00:44:00 56182 8192000000 10828101408 11303206912 1884214528 18.699 99 7 14 0 1901627408 15520880 1892000
00:45:06 76955 8192000000 10830876128 11313639424 1861985152 18.519 97 14 28 0 1880195616 14077936 4132528
00:48:54 65769 8192000000 10834904992 11320057856 1913931248 18.938 100 13 26 1 1931897408 14312736 3653424
00:50:35 52929 8192000000 10860047232 11324411904 1913905488 18.938 99 23 46 1 1929551520 8962256 6683776
00:51:38 60135 8192000000 10846822192 11322994688 1907749328 18.889 99 14 28 0 1923632352 11917808 3965216
00:52:48 68661 8192000000 10865532640 11335462912 1901832928 18.841 98 10 20 1 1913920688 9056288 3031472
00:54:09 50722 8192000000 10884057536 11351531520 1953527776 19.255 100 26 52 0 1969925312 9124016 7273520
00:55:07 28610 8192000000 10873536592 11341385728 1896650288 18.799 97 26 52 0 1912421232 8426560 7344384
00:55:46 33428 8192000000 10887763024 11349012480 1945551328 19.191 100 41 83 2 1970643696 13712048 11380320
00:56:29 44935 8192000000 10870042128 11329073152 1884330112 18.700 97 12 24 0 1897681312 10425072 2926128
00:57:21 31625 8192000000 10890102496 11350126592 1913682816 18.936 98 19 38 1 1929626032 10759408 5183808
00:58:03 33492 8192000000 10893733360 11351011328 1920555136 18.991 98 27 54 1 1939555984 11806640 7194208
00:58:42 63347 8192000000 10893948864 11372036096 1934975968 19.107 99 13 26 1 1956171520 17989824 3205728
00:59:52 96715 8192000000 10900243408 11362988032 1919227712 18.981 98 12 24 1 1938641728 16102672 3311344
01:01:35 46571 8192000000 10890691648 11355602944 1905881584 18.874 97 26 52 1 1925290656 11568976 7840096
01:02:28 87105 8192000000 10904708240 11369459712 1909900496 18.906 97 14 28 0 1927955920 14625296 3430128
01:04:05 124724 8192000000 10917139584 11389427712 1963631280 19.335 100 24 47 0 1983349536 13038848 6679408
01:06:17 48361 8192000000 10909383088 11391672320 1981232800 19.474 100 16 32 0 2004938528 19086528 4619200
01:07:35 25580 8192000000 10908849264 11384745984 1964753664 19.344 99 30 60 0 1990351584 16948096 8649824
01:09:42 52275 8192000000 10895573664 11380731904 1964248768 19.340 99 23 46 2 1981022208 10155760 6617680
01:10:41 40031 8192000000 10910528816 11382853632 1968019328 19.370 99 17 34 0 1980776080 7850528 4906224
01:11:27 36940 8192000000 10894616912 11368972288 1926325232 19.037 97 15 30 1 1937495024 6864976 4304816
01:12:14 70367 8192000000 10877621824 11364962304 1954263856 19.260 99 19 36 1 1966874816 7658000 4952960
01:13:43 34501 8192000000 10871751984 11359367168 1944715168 19.184 99 3 6 0 1953159472 7754944 689360
01:14:34 45589 8192000000 10876774896 11367247872 1929369168 19.062 98 11 22 0 1946729888 14219696 3141024
01:15:26 59143 8192000000 10891752912 11372519424 1949326752 19.221 99 9 19 0 1965599792 13877744 2395296
01:16:37 54156 8192000000 10869352368 11367342080 1892379856 18.765 96 12 25 0 1913017744 16191120 4446768
01:17:40 30330 8192000000 10875544416 11356327936 1942787648 19.169 99 23 46 2 1955327920 6090752 6449520
01:18:16 16018 8192000000 10911585760 11360018432 1944650480 19.184 99 38 76 0 1962757712 7114688 10992544
01:18:40 50596 8192000000 10904534208 11364941824 1956006272 19.274 99 30 60 0 1976683360 12040704 8636384
01:19:44 36569 8192000000 10905010048 11373330432 1947475232 19.206 99 25 48 2 1965931632 11546288 6910112
01:20:58 45578 8192000000 10905400688 11374788608 1960269264 19.308 99 22 44 0 1976991712 10691408 6031040
01:21:50 23921 8192000000 10920393552 11386040320 1962848944 19.329 99 33 66 0 1983603120 11334208 9419968
01:22:22 91931 8192000000 10902543920 11388669952 1962916848 19.329 99 19 38 2 1984192576 15406368 5869360
01:24:02 60994 8192000000 10890107968 11357421568 1884195616 18.699 95 13 26 0 1899273600 11402512 3675472
01:25:09 72715 8192000000 10876211248 11372761088 1928180672 19.052 98 16 32 2 1948881040 15870688 4829680
01:26:35 49753 8192000000 9186748704 9431027712 344973792 4.040 18 3 6 0 352118816 6704976 440048

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 01-03-2021 01:28:09 to 01-03-2021 01:28:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 102 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          237731
MON$OLDEST_ACTIVE               237732
MON$OLDEST_SNAPSHOT             237732
MON$NEXT_TRANSACTION            237732
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                       2040288
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

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

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

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