Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.11.2020 16:31
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 17307160 kB
MemAvailable 31407348 kB
Buffers 0 kB
Cached 14350940 kB
SwapCached 2856 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 2020-11-12 16:30:45
DTS_END                         2020-11-12 16:30:45.4090
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/46156
TRN_ID                          246837
ATT_ID                          721
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: 9404.48 16779 1128538
customer order: creation 183.44 380 22013
customer order: refuse 15.62 371 1874
order to supplier: creation 48.48 1327 5817
order to supplier: removal 3.44 116102 413
invoice (draft): creation 47.48 3390 5697
invoice (draft): removal 51.64 872 6197
invoice accept: apply 42.67 18343 5120
invoice accept: cancel 47.68 932 5722
customer reserve: creation 3925.96 182 471115
customer reserve: removal 4725.61 67 567073
realization accept: apply 90.53 175 10864
realization accept: cancel 87.13 123 10455
payment from customer: creation 62.39 117 7487
payment from customer: removal 6.01 76 721
payment to supplier: creation 50.12 126 6014
payment to supplier: removal 3.33 100 399
service: total inventory turnovers 5.05 1232 606
service: total monetary turnovers 6.96 27 835
service: aggregate perf. data 0.93 18899 112
service: refresh index statistics 0.03 172746 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-11-2020 16:32:01 to 12-11-2020 16:32:03.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2401
TEST_TIME 2 1992
TEST_TIME 3 3137
TEST_TIME 4 3814
TEST_TIME 5 4938
TEST_TIME 6 5244
TEST_TIME 7 5427
TEST_TIME 8 5498
TEST_TIME 9 5474
TEST_TIME 10 5450
TEST_TIME 11 5442
TEST_TIME 12 5849
TEST_TIME 13 6143
TEST_TIME 14 6245
TEST_TIME 15 6244
TEST_TIME 16 6591
TEST_TIME 17 6681
TEST_TIME 18 6907
TEST_TIME 19 6875
TEST_TIME 20 6777
TEST_TIME 21 7509
TEST_TIME 22 7779
TEST_TIME 23 8245
TEST_TIME 24 8489
TEST_TIME 25 9527
TEST_TIME 26 9681
TEST_TIME 27 10704
TEST_TIME 28 11057
TEST_TIME 29 11215
TEST_TIME 30 11271
TEST_TIME 31 11175
TEST_TIME 32 11056
TEST_TIME 33 10988
TEST_TIME 34 10939
TEST_TIME 35 10744
TEST_TIME 36 10556
TEST_TIME 37 10540
TEST_TIME 38 10439
TEST_TIME 39 10524
TEST_TIME 40 10381
TEST_TIME 41 10327
TEST_TIME 42 10233
TEST_TIME 43 10124
TEST_TIME 44 10309
TEST_TIME 45 10289
TEST_TIME 46 10213
TEST_TIME 47 10180
TEST_TIME 48 10095
TEST_TIME 49 9986
TEST_TIME 50 9909
TEST_TIME 51 9884
TEST_TIME 52 9852
TEST_TIME 53 9758
TEST_TIME 54 9692
TEST_TIME 55 9646
TEST_TIME 56 9804
TEST_TIME 57 9742
TEST_TIME 58 9703
TEST_TIME 59 9767
TEST_TIME 60 9899
TEST_TIME 61 9941
TEST_TIME 62 9924
TEST_TIME 63 10051
TEST_TIME 64 10041
TEST_TIME 65 10005
TEST_TIME 66 10036
TEST_TIME 67 10129
TEST_TIME 68 10056
TEST_TIME 69 10130
TEST_TIME 70 10060
TEST_TIME 71 9971
TEST_TIME 72 9964
TEST_TIME 73 9861
TEST_TIME 74 9903
TEST_TIME 75 9858
TEST_TIME 76 9830
TEST_TIME 77 9752
TEST_TIME 78 9717
TEST_TIME 79 9750
TEST_TIME 80 9711
TEST_TIME 81 9679
TEST_TIME 82 9666
TEST_TIME 83 9649
TEST_TIME 84 9668
TEST_TIME 85 9833
TEST_TIME 86 9805
TEST_TIME 87 9806
TEST_TIME 88 9814
TEST_TIME 89 9799
TEST_TIME 90 9814
TEST_TIME 91 9811
TEST_TIME 92 9791
TEST_TIME 93 9727
TEST_TIME 94 9664
TEST_TIME 95 9630
TEST_TIME 96 9621
TEST_TIME 97 9561
TEST_TIME 98 9566
TEST_TIME 99 9523
TEST_TIME 100 9521
TEST_TIME 101 9560
TEST_TIME 102 9519
TEST_TIME 103 9521
TEST_TIME 104 9562
TEST_TIME 105 9562
TEST_TIME 106 9598
TEST_TIME 107 9575
TEST_TIME 108 9619
TEST_TIME 109 9586
TEST_TIME 110 9638
TEST_TIME 111 9590
TEST_TIME 112 9513
TEST_TIME 113 9502
TEST_TIME 114 9461
TEST_TIME 115 9417
TEST_TIME 116 9396
TEST_TIME 117 9408
TEST_TIME 118 9442
TEST_TIME 119 9448
TEST_TIME 120 9413

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-11-2020 16:32:04 to 12-11-2020 16:32:08.

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 1566064 1566064 0 0.00 0 18191 6 0 0
doc_list_biud 1566062 1566062 0 0.00 0 23841 30 0 0
sp_add_invoice_to_stock 5248 5120 128 2.43 43 143210 18344 0 128
sp_cancel_adding_invoice 5722 5722 0 0.00 4 105365 933 0 0
sp_cancel_client_order 1874 1874 0 0.00 4 12806 372 0 0
sp_cancel_customer_reserve 567073 567073 0 0.00 1 23843 68 0 0
sp_cancel_pay_from_customer 721 721 0 0.00 2 3326 77 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 3 5211 101 0 0
sp_cancel_supplier_invoice 6208 6197 11 0.17 1 23457 872 0 11
sp_cancel_supplier_order 413 413 0 0.00 5 1405638 116103 0 0
sp_cancel_write_off 10455 10455 0 0.00 1 11838 123 0 0
sp_client_order 22013 22013 0 0.00 3 55341 381 0 0
sp_customer_reserve 471115 471115 0 0.00 0 55628 182 0 0
sp_fill_shopping_cart 33523 33523 0 0.00 1 11718 42 0 0
sp_fill_shopping_cart_clo_res 471105 471105 0 0.00 0 23342 15 0 0
sp_get_clo_for_invoice 5110 5110 0 0.00 0 30657 307 0 0
sp_kill_cost_storno 17297 17297 0 0.00 0 5708 61 0 0
sp_kill_qstorno_ret_qs2qd 1151211 1151211 0 0.00 0 23808 36 0 0
sp_kill_qty_storno 607706 607706 0 0.00 0 23841 77 0 0
sp_lock_selected_doc 22046 22046 0 0.00 0 9971 6 0 0
sp_make_cost_storno 29475 29475 0 0.00 0 14700 48 0 0
sp_multiply_rows_for_pdistr 29473 29473 0 0.00 0 9932 29 0 0
sp_multiply_rows_for_qdistr 22013 22013 0 0.00 0 55330 174 0 0
sp_pay_from_customer 7487 7487 0 0.00 4 10055 118 0 0
sp_pay_to_supplier 6014 6014 0 0.00 5 9993 126 0 0
sp_payment_common 13501 13501 0 0.00 1 10039 25 0 0
sp_qd_handle_on_cancel_clo 1874 1874 0 0.00 0 12799 333 0 0
sp_qd_handle_on_invoice_upd_sts 10831 10831 0 0.00 0 20020 330 0 0
sp_qd_handle_on_reserve_upd_sts 10863 10863 0 0.00 0 11744 58 0 0
sp_reserve_write_off 10864 10864 0 0.00 6 14380 176 0 0
sp_supplier_invoice 5697 5697 0 0.00 7 78634 3391 0 0
sp_supplier_order 5817 5817 0 0.00 5 56564 1328 0 0
srv_aggregate_perf_data 113 112 1 0.88 2334 226218 18900 0 1
srv_fill_mon_cache_memory 181 181 0 0.00 813 115086 29478 0 0
srv_find_qd_qs_mism 1079580 1079580 0 0.00 0 18166 5 0 0
srv_make_invnt_saldo 606 606 0 0.00 23 70603 1233 0 0
srv_make_money_saldo 835 835 0 0.00 1 2534 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 112885 228041 172747 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 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 5120 5120 0 0.00 0 29172 184 0 0
t$perf-norm:sp_cancel_adding_invoice 465 465 0 0.00 0 6584 111 0 0
t$perf-norm:sp_cancel_client_order 1874 1874 0 0.00 0 5798 13 0 0
t$perf-norm:sp_cancel_customer_reserve 734 734 0 0.00 0 1505 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 721 721 0 0.00 0 2660 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 1583 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 673 9 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 24553 1776 0 0
t$perf-norm:sp_cancel_write_off 1065 1065 0 0.00 0 5723 14 0 0
t$perf-norm:sp_client_order 22013 22013 0 0.00 0 5441 17 0 0
t$perf-norm:sp_customer_reserve 1047 1047 0 0.00 0 1555 10 0 0
t$perf-norm:sp_pay_from_customer 7487 7487 0 0.00 0 5464 10 0 0
t$perf-norm:sp_pay_to_supplier 6014 6014 0 0.00 0 11669 14 0 0
t$perf-norm:sp_reserve_write_off 10864 10864 0 0.00 0 4868 13 0 0
t$perf-norm:sp_supplier_invoice 5697 5697 0 0.00 0 25167 26 0 0
t$perf-norm:sp_supplier_order 5817 5817 0 0.00 0 10935 16 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 1193 37 0 0
t$perf-norm:srv_fill_mon_cache_memory 181 181 0 0.00 0 355 4 0 0
t$perf-norm:srv_make_invnt_saldo 606 606 0 0.00 0 1196 24 0 0
t$perf-norm:srv_make_money_saldo 835 835 0 0.00 0 6463 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 10474 10218 256 2.44 0 5587 22 0 256
v_all_customers 40000 40000 0 0.00 0 171 1 0 0
v_all_suppliers 32016 32016 0 0.00 0 23 1 0 0
v_all_wares 44024 44024 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 930 930 0 0.00 0 1645 8 0 0
v_cancel_client_order 3748 3748 0 0.00 0 4251 8 0 0
v_cancel_customer_prepayment 1442 1442 0 0.00 0 3284 9 0 0
v_cancel_customer_reserve 1468 1468 0 0.00 0 2695 6 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 304 4 0 0
v_cancel_supplier_invoice 828 806 22 2.65 0 2431 29 0 22
v_cancel_supplier_order 826 826 0 0.00 0 6360 16 0 0
v_cancel_write_off 2130 2130 0 0.00 0 2735 15 0 0
v_max_id_clo_ord 5815 5815 0 0.00 0 3497 2 0 0
v_max_id_clo_res 1047 1047 0 0.00 0 3940 22 0 0
v_max_id_ord_sup 5696 5696 0 0.00 0 8388 7 0 0
v_max_non_paid_invoice 1517 1517 0 0.00 0 311 2 0 0
v_max_non_paid_realizn 4014 4014 0 0.00 0 3691 5 0 0
v_min_id_clo_ord 5815 5815 0 0.00 0 2155 5 0 0
v_min_id_clo_res 1047 1047 0 0.00 0 12516 19 0 0
v_min_id_ord_sup 5696 5696 0 0.00 0 11710 17 0 0
v_min_non_paid_invoice 6014 6014 0 0.00 0 4697 14 0 0
v_min_non_paid_realizn 7487 7487 0 0.00 0 7401 16 0 0
v_our_firm 10970 10970 0 0.00 0 13 1 0 0
v_reserve_write_off 21726 21726 0 0.00 0 5621 7 0 0
x_lock_depdocs_on_canc_invoice 11516 11516 0 0.00 0 38089 123 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 9575 363 0 0
x_make_qstorno_1000_1200 5817 5817 0 0.00 2 56537 1251 0 0
x_make_qstorno_1200_2000 5697 5697 0 0.00 3 77622 3222 0 0
x_make_qstorno_2100_3300 471115 471115 0 0.00 0 37965 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-11-2020 16:32:09 to 12-11-2020 16:32:13.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:00:49 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:00:55 13242 8192000000 10222755840 10529521664 917848176 10.075 74 54 112 0 939333152 2706672 18778304
14:01:18 28474 8192000000 10366728144 10687516672 1395453776 14.554 100 85 170 0 1427333136 4548864 27330496
14:01:56 32465 8192000000 10394176192 10720206848 1438028944 14.932 100 89 178 0 1473613472 6546272 29038256
14:02:43 22577 8192000000 10422911616 10753597440 1478816128 15.291 100 95 190 0 1518094336 8419504 30858704
14:03:21 18924 8192000000 10452563712 10785636352 1504657792 15.517 100 93 186 0 1543929232 9680144 29591296
14:03:52 24248 8192000000 10463189456 10799665152 1510206432 15.565 100 87 175 0 1548025216 10003952 27814832
14:04:51 16897 8192000000 10486490944 10836504576 1546893472 15.883 100 85 170 3 1583642624 10354320 26394832
14:05:22 17556 8192000000 10520096240 10870661120 1582796176 16.192 100 87 174 1 1620500496 10745184 26959136
14:05:56 16948 8192000000 10560912448 10918293504 1616113360 16.477 100 79 158 0 1651431328 10899008 24418960
14:06:26 9946 8192000000 10578986480 10944196608 1642214256 16.698 100 80 159 1 1677469200 11670064 23584880
14:06:45 13007 8192000000 10597448464 10964729856 1662459296 16.870 100 77 154 1 1697565792 11913872 23192624
14:07:07 7995 8192000000 10633263792 10998857728 1681933376 17.034 100 84 168 1 1718591360 12302576 24355408
14:07:23 11148 8192000000 10638848048 11006537728 1695254480 17.145 100 81 162 1 1732022912 12979872 23788560
14:07:42 8533 8192000000 10648743344 11023921152 1714919952 17.310 100 87 172 0 1753195680 13038992 25236736
14:07:58 8216 8192000000 10668757152 11039522816 1724732624 17.392 100 85 170 1 1761801152 12965360 24103168
14:08:14 6836 8192000000 10678102704 11053453312 1735636576 17.482 100 78 156 0 1770826800 13504912 21685312
14:08:28 5502 8192000000 10681273824 11058135040 1742694144 17.541 100 82 164 2 1780551360 14349280 23507936
14:08:41 5186 8192000000 10690603088 11065966592 1750754992 17.608 100 85 170 1 1788746416 14003488 23987936
14:08:55 4496 8192000000 10693376528 11070271488 1756152736 17.653 100 82 162 5 1793441312 14310816 22977760
14:09:06 4824 8192000000 10709472624 11086831616 1763926096 17.717 100 80 160 1 1800355632 13859888 22569648
14:09:17 3528 8192000000 10717281536 11095912448 1773302240 17.794 100 84 168 3 1811770096 14656048 23811808
14:09:27 3589 8192000000 10734350544 11114004480 1783394576 17.877 100 85 170 1 1825566592 18067568 24104448
14:09:38 3656 8192000000 10727973696 11110780928 1792171776 17.950 100 86 172 0 1831000800 14575296 24253728
14:09:48 9600 8192000000 10722862128 11113398272 1794184352 17.966 100 83 164 2 1830833056 14077168 22571536
14:10:05 3134 8192000000 10742295136 11130470400 1801918640 18.030 100 83 166 3 1838338688 13021152 23398896
14:10:15 2513 8192000000 10754992512 11139211264 1816388896 18.148 100 87 172 0 1853790160 13617232 23784032
14:10:24 3296 8192000000 10769382320 11153297408 1827929120 18.242 100 85 170 2 1864826240 13611008 23286112
14:10:34 2571 8192000000 10778190048 11162279936 1830845792 18.266 100 87 174 0 1869445952 14062752 24537408
14:10:42 2548 8192000000 10773312880 11159416832 1834326448 18.295 100 89 178 1 1873716080 14978240 24411392
14:10:52 1526 8192000000 10786071408 11168657408 1843246048 18.367 100 94 188 0 1882758064 13787200 25724816
14:11:00 2159 8192000000 10789126784 11173498880 1841016720 18.349 100 88 176 1 1880457232 14745904 24694608
14:11:08 2444 8192000000 10791433152 11177828352 1845606000 18.386 100 91 180 1 1883985344 12065552 26313792
14:11:17 1513 8192000000 10788864000 11174531072 1852558528 18.443 100 94 184 2 1890620928 12788336 25274064
14:11:25 1789 8192000000 10799011392 11185057792 1852681728 18.444 100 93 188 1 1892037552 12828688 26527136
14:11:33 1793 8192000000 10797608928 11184439296 1854550512 18.459 100 91 183 2 1894214848 13843072 25821264
14:11:41 1178 8192000000 10799240192 11188420608 1862171776 18.521 100 90 182 1 1900609152 13272288 25165088
14:11:49 2621 8192000000 10801611200 11194851328 1864125024 18.537 100 89 179 3 1903062656 12723328 26214304
14:11:58 1243 8192000000 10809515248 11200421888 1868328160 18.571 100 95 190 4 1909438752 14408224 26702368
14:12:05 2618 8192000000 10815132224 11209158656 1872879360 18.608 100 89 179 1 1912409312 13638848 25891104
14:12:14 23004 8192000000 10809231056 11208228864 1873934640 18.616 100 60 119 1 1901128720 10474976 16719104
14:12:43 17968 8192000000 10810664464 11210686464 1876802896 18.639 100 70 141 1 1907341920 10463760 20075264
14:13:08 1500 8192000000 10824598768 11215605760 1882276240 18.683 100 86 173 0 1917654624 11090032 24288352
14:13:15 1170 8192000000 10830331120 11225120768 1885612480 18.710 100 93 186 1 1926053824 14439648 26001696
14:13:24 7149 8192000000 10825649600 11221561344 1881274320 18.675 100 77 154 0 1917162736 14134000 21754416
14:13:38 15047 8192000000 10783430896 11213803520 1874986144 18.625 100 33 66 0 1896758752 13109408 8663200
14:13:59 3588 8192000000 10788780608 11208830976 1877360096 18.644 100 44 87 3 1897358624 7283840 12714688
14:14:11 2816 8192000000 10805302976 11213037568 1879264144 18.659 100 53 104 1 1900943520 6938160 14741216
14:14:21 4725 8192000000 10794769728 11217838080 1880527712 18.669 100 41 82 1 1900481456 8098320 11855424
14:14:33 4391 8192000000 10802420752 11215659008 1878313520 18.651 100 40 79 1 1898375952 7950064 12112368
14:14:44 5628 8192000000 10788832064 11220279296 1882101712 18.682 100 37 74 2 1899809728 7253888 10454128
14:14:59 4822 8192000000 10811059616 11228803072 1884183040 18.699 100 31 63 0 1902903488 10188944 8531504
14:15:10 8423 8192000000 10794967120 11221667840 1885151360 18.707 100 28 56 1 1901003792 8221536 7630896
14:15:25 6636 8192000000 10793381248 11224629248 1885997696 18.714 100 33 64 0 1901588144 6225568 9364880
14:15:38 6848 8192000000 10809158320 11230666752 1887973488 18.729 100 22 44 2 1900588912 6186192 6429232
14:15:51 10668 8192000000 10788643168 11222044672 1889444816 18.741 100 19 37 2 1900949280 6314816 5189648
14:16:09 10031 8192000000 10792053968 11227435008 1888442880 18.733 100 17 34 1 1899193264 6058304 4692080
14:16:25 6213 8192000000 10800713520 11231842304 1891696560 18.759 100 20 40 0 1903070864 6042048 5332256
14:16:38 6432 8192000000 10814548640 11241263104 1895739632 18.792 100 24 48 1 1912511552 10935760 5836160
14:16:51 10793 8192000000 10817314304 11235102720 1900163072 18.828 100 43 86 1 1924278208 11986400 12128736
14:17:09 58940 8192000000 10802902576 11244253184 1901500784 18.838 100 45 90 0 1920744240 5005056 14238400
14:18:17 11352 8192000000 10821988912 11248140288 1885099360 18.706 99 32 64 1 1900509920 7081824 8328736
14:18:37 10866 8192000000 10814862672 11252183040 1900157904 18.828 100 29 57 1 1915589440 6531424 8900112
14:18:54 10421 8192000000 10821384640 11251580928 1901619648 18.839 100 22 42 0 1913311984 5646416 6045920
14:19:15 4332 8192000000 10826018752 11255611392 1903494016 18.854 100 32 62 1 1919434832 6972800 8968016
14:19:28 5834 8192000000 10830691328 11259797504 1905767728 18.873 100 31 62 0 1920666016 5804112 9094176
14:19:40 5701 8192000000 10828164528 11257274368 1908351200 18.893 100 23 45 2 1924124128 9012560 6760368
14:19:53 8386 8192000000 10821788400 11253043200 1904721792 18.864 100 22 44 1 1916578576 5918848 5937936
14:20:07 6114 8192000000 10817421488 11251785728 1884975200 18.705 99 16 32 1 1898575696 9599712 4000784
14:20:20 5987 8192000000 10812902944 11249225728 1901441616 18.838 100 28 56 1 1916016144 6841392 7733136
14:20:32 6600 8192000000 10813586624 11242598400 1880318544 18.668 99 30 60 3 1894448816 5866464 8263808
14:20:46 9456 8192000000 10797126112 11233734656 1860898832 18.511 98 20 40 0 1872776288 5935856 5941600
14:21:06 7701 8192000000 10780673152 11218747392 1860411952 18.507 99 11 22 1 1869428704 5594224 3422528
14:21:21 8460 8192000000 10798824512 11218776064 1844006400 18.373 98 24 48 1 1857161024 6515680 6638944
14:21:36 64950 8192000000 10749999824 11169566720 1733066528 17.461 92 36 72 2 1752616048 8673488 10876032
14:22:49 9023 8192000000 10698846672 11121598464 1712035520 17.286 94 12 24 0 1720398656 5086064 3277072
14:23:06 6189 8192000000 10723270704 11147509760 1794815088 17.971 99 31 62 1 1810560096 6860720 8884288
14:23:19 4149 8192000000 10751465664 11165237248 1802169056 18.032 98 55 111 1 1826569776 8842144 15558576
14:23:31 3776 8192000000 10737280816 11152297984 1796370464 17.984 99 46 92 2 1820739760 11549184 12820112
14:23:44 8931 8192000000 10695090000 11108515840 1732702144 17.458 96 30 60 3 1747903808 6128208 9073456
14:24:00 3445 8192000000 10681078624 11071324160 1677867760 16.999 94 51 102 0 1698868944 5361248 15639936
14:24:10 6872 8192000000 10666552544 11080654848 1735001488 17.477 98 27 54 0 1748633824 5447488 8184848
14:24:24 5010 8192000000 10699874816 11101331456 1741564896 17.532 97 41 81 2 1757955392 4936496 11454000
14:24:36 8832 8192000000 10702848400 11118931968 1737180784 17.495 97 24 48 2 1754268192 9845696 7241712
14:24:55 5600 8192000000 10720893920 11142836224 1806800432 18.070 100 27 53 1 1820841856 6094032 7947392
14:25:07 6447 8192000000 10738684912 11151470592 1817724208 18.159 100 27 54 1 1830432848 4835936 7872704
14:25:22 9420 8192000000 10739779296 11160305664 1810234832 18.098 99 30 60 1 1825558480 6535024 8788624
14:25:38 7239 8192000000 10764603888 11177467904 1833922768 18.291 100 22 44 1 1845956112 5842736 6190608
14:25:52 6487 8192000000 10742862272 11157983232 1796869360 17.988 98 19 38 1 1807955408 5822112 5263936
14:26:10 53876 8192000000 10749665168 11159203840 1775410880 17.812 97 31 63 0 1789285408 4384592 9489936
14:27:25 11291 8192000000 10745560576 11172671488 1836653712 18.314 100 20 39 2 1849310816 7505440 5151664
14:27:45 11471 8192000000 10770069792 11190820864 1852518640 18.443 100 28 55 0 1866389344 5811696 8059008
14:28:06 6223 8192000000 10777777248 11201302528 1858433040 18.491 100 27 54 1 1872825136 6577584 7814512
14:28:19 5160 8192000000 10773889680 11201490944 1862405056 18.523 100 31 63 2 1877875680 5764816 9705808
14:28:31 6458 8192000000 10780351520 11202895872 1847274656 18.400 99 25 50 0 1859149856 5040960 6834240
14:28:49 8194 8192000000 10773791184 11207315456 1866919200 18.559 100 26 52 2 1880646464 6130656 7596608
14:29:04 13753 8192000000 10787976896 11216486400 1870408944 18.588 100 15 29 1 1880019472 5382016 4228512
14:29:24 5983 8192000000 10793662144 11220062208 1877390736 18.644 100 27 54 0 1891062128 6211984 7459408
14:29:41 8105 8192000000 10783688416 11218305024 1877226416 18.643 100 16 31 0 1886567216 4986960 4353840
14:29:55 12755 8192000000 10796142368 11229138944 1885199120 18.707 100 16 32 1 1895877808 5498336 5180352
14:30:14 13214 8192000000 10820678272 11247722496 1900183536 18.828 100 18 36 0 1910418048 5096784 5137728
14:30:36 59801 8192000000 10831541360 11264729088 1909529792 18.903 100 22 45 0 1921072832 4924592 6618448
14:31:50 39133 8192000000 10857700016 11285045248 1933367664 19.094 100 40 76 2 1949313584 5672176 10273744
14:32:45 22391 8192000000 10866316160 11293716480 1935892720 19.114 100 42 83 0 1957229760 10239104 11097936
14:33:14 5427 8192000000 10886454240 11306106880 1946610848 19.199 100 65 130 1 1976361616 11118544 18632224
14:33:31 15161 8192000000 10890373136 11315830784 1953263536 19.252 100 56 111 3 1982666144 13333552 16069056
14:33:54 7907 8192000000 10893530816 11318460416 1957726848 19.288 100 65 130 0 1991979136 15089568 19162720
14:34:12 20098 8192000000 10904952192 11331076096 1962999344 19.330 100 50 100 1 1993049200 15316832 14733024
14:34:44 9610 8192000000 10909512656 11338592256 1969193424 19.379 100 62 125 0 2005735296 18367504 18174368
14:35:00 14360 8192000000 10909792416 11337879552 1972282864 19.404 100 49 96 0 2004325312 17603952 14438496
14:35:27 14824 8192000000 10920935216 11350233088 1979367840 19.460 100 48 93 0 2010975024 16947200 14659984
14:35:48 11551 8192000000 10919836512 11354136576 1984211648 19.498 100 54 106 0 2017161120 16549328 16400144
14:36:15 18772 8192000000 10941865648 11372261376 1993005200 19.568 100 55 110 0 2027916752 18698112 16213440
14:36:44 12863 8192000000 10928973840 11365695488 1975397056 19.428 99 49 98 2 2009035536 18867616 14770864
14:37:07 19071 8192000000 10930405552 11371634688 1992084320 19.560 100 39 78 0 2021488096 17679968 11723808
14:37:35 8407 8192000000 10930014496 11351740416 1980791600 19.471 99 61 118 2 2017751904 20167024 16793280
14:37:50 23238 8192000000 10950147904 11382259712 2001388384 19.634 100 57 114 3 2041156320 23031952 16735984
14:38:22 20886 8192000000 10959195952 11388575744 2005490048 19.666 100 58 115 2 2045695248 24036512 16168688
14:39:09 13441 8192000000 10951016672 11386654720 2002029536 19.639 100 48 94 2 2039862752 23849568 13983648
14:39:30 12190 8192000000 10963780192 11400556544 2013562608 19.730 100 55 106 4 2053944320 24718720 15662992
14:39:49 8765 8192000000 10970045984 11405221888 2019733936 19.778 100 54 109 0 2061393152 25580224 16078992
14:40:10 2636 8192000000 10989051136 11422953472 2030852400 19.865 100 61 122 2 2077870928 28091728 18926800
14:40:21 2823 8192000000 10988801792 11411030016 2015376352 19.744 99 72 145 3 2065267984 27975376 21916256
14:40:35 2929 8192000000 10999923120 11428651008 2032209888 19.876 100 61 122 1 2085164192 34132288 18822016
14:40:45 4579 8192000000 10998033632 11428302848 2035109568 19.899 100 60 118 2 2088088048 35157712 17820768
14:40:57 4707 8192000000 11009076416 11439534080 2040133536 19.938 100 72 142 1 2098072480 36132960 21805984
14:41:14 9080 8192000000 10997072512 11434127360 2034417456 19.893 100 55 110 0 2089019680 36985152 17617072
14:41:35 6787 8192000000 11007553984 11443290112 2038855456 19.928 100 53 104 1 2095063536 39328384 16879696
14:41:49 3369 8192000000 11018025328 11448467456 2043523408 19.965 100 68 136 1 2105511152 40590432 21397312
14:41:59 3369 8192000000 11027631952 11454689280 2046959280 19.991 100 77 155 1 2111426352 41379968 23087104
14:42:10 3442 8192000000 11019069456 11453968384 2047397648 19.995 100 69 137 1 2109431424 40736752 21297024
14:42:24 2822 8192000000 11023409312 11446906880 2024777824 19.818 99 64 127 3 2082075104 37961088 19336192
14:42:38 6234 8192000000 11014274048 11438538752 2024949008 19.819 99 72 142 1 2086244560 39744192 21551360
14:42:58 5557 8192000000 11018331648 11454218240 2045962544 19.984 100 69 138 0 2108477072 40405888 22108640
14:43:15 5977 8192000000 11012407584 11451801600 2040409536 19.940 100 63 127 1 2102014048 41120608 20483904
14:43:33 6487 8192000000 11012019200 11454251008 2044431440 19.972 100 59 119 3 2104882496 41621040 18830016
14:43:54 7027 8192000000 11014240256 11457310720 2048532816 20.004 100 55 110 1 2105001008 38973456 17494736
14:44:10 7422 8192000000 11012504976 11452616704 2043599280 19.965 100 65 129 0 2105910272 40921584 21389408
14:44:26 2969 8192000000 11016623280 11449401344 2039039920 19.929 100 72 141 3 2102687280 41831008 21816352
14:44:37 3167 8192000000 11026559376 11457368064 2046636528 19.989 100 81 162 1 2114270512 42715808 24918176
14:44:48 3981 8192000000 11033875296 11463794688 2051768448 20.029 100 75 150 0 2117630592 42677552 23184592
14:44:59 4431 8192000000 11016271104 11442360320 2026243440 19.829 99 74 145 0 2090798112 41952992 22601680
14:45:13 7104 8192000000 10999410368 11432005632 2021927200 19.795 99 68 136 1 2087295840 43443552 21925088
14:45:30 4315 8192000000 10982902592 11403370496 1997566864 19.604 98 76 151 2 2064976240 43751840 23657536
14:45:41 2893 8192000000 11011241696 11429732352 2012173744 19.719 99 87 173 2 2083709936 44778224 26757968
14:45:51 4844 8192000000 10989344208 11404840960 1997184368 19.601 99 85 170 3 2068515520 45045328 26285824
14:46:04 4227 8192000000 10993969600 11420188672 2018890528 19.771 100 68 136 1 2081849792 41369360 21589904
14:46:16 3075 8192000000 10996556816 11413635072 2008965072 19.693 99 86 173 1 2078987888 44333264 25689552
14:46:27 2533 8192000000 11001822576 11418583040 1983149712 19.490 98 82 162 0 2053906224 45254096 25502416
14:46:38 4609 8192000000 11006171056 11421704192 2012694896 19.723 100 86 172 1 2085051904 45687104 26669904
14:46:51 1200 8192000000 10996810208 11414528000 2006617168 19.675 100 79 154 3 2077016832 45872256 24527408
14:46:59 5750 8192000000 10991751040 11412828160 2011494304 19.713 100 84 166 2 2083750864 45671136 26585424
14:47:17 2257 8192000000 11011784976 11424579584 2002610800 19.643 99 80 159 0 2072184112 44735904 24837408
14:47:27 2979 8192000000 11005089728 11426652160 2018188448 19.766 100 83 166 1 2093083296 48828256 26066592
14:47:41 5206 8192000000 11011270464 11436736512 2022017168 19.796 100 75 150 1 2095941664 49779856 24144640
14:47:54 2965 8192000000 11009631152 11430486016 2000841312 19.629 99 80 159 1 2076363616 50190816 25331488
14:48:07 2585 8192000000 11017041648 11438604288 2021531792 19.792 100 78 155 2 2096656528 50397088 24727648
14:48:17 2569 8192000000 10978888656 11393757184 1967470480 19.365 97 80 159 3 2045174528 52338288 25365760
14:48:28 2412 8192000000 10978762816 11389853696 1980674592 19.470 99 77 153 1 2056056960 50459760 24922608
14:48:37 2342 8192000000 10997219808 11414614016 2003488864 19.650 100 85 170 3 2080580128 50891344 26199920
14:48:46 1789 8192000000 11006425568 11414384640 2004308720 19.657 100 91 181 2 2083217760 51351104 27557936
14:48:56 1282 8192000000 10994220944 11405012992 1993278416 19.570 100 84 167 0 2070894352 51481376 26134560
14:49:04 1245 8192000000 11002958432 11411881984 1995535904 19.588 100 82 164 0 2074768656 52363424 26869328
14:49:14 1780 8192000000 11006884224 11417399296 2003180096 19.648 100 85 171 0 2084211296 53448240 27582960
14:49:26 3188 8192000000 10999766656 11422040064 2008696912 19.691 100 73 146 2 2085210336 52954448 23558976
14:49:37 1860 8192000000 11006025312 11421540352 2004415440 19.658 100 83 166 1 2085983584 55319440 26248704
14:49:46 3383 8192000000 11007112144 11425832960 2007283776 19.680 100 76 152 1 2087755520 56089568 24382176
14:49:57 1360 8192000000 11010502352 11431256064 2012195856 19.719 100 77 153 0 2096547920 58830192 25521872
14:50:06 7450 8192000000 10993168256 11419672576 1985206928 19.506 99 67 129 0 2066979136 60135904 21636304
14:50:22 4494 8192000000 11017254000 11431542784 1985964352 19.512 99 83 166 2 2082183264 68944448 27274464
14:50:34 3325 8192000000 11012378064 11430461440 1998223536 19.609 100 77 154 2 2091502880 67076432 26202912
14:50:45 1211 8192000000 11007645872 11419017216 1976724160 19.439 99 90 179 2 2073275968 67615376 28936432
14:50:52 5644 8192000000 10998102480 11420815360 1987416320 19.523 100 75 149 0 2082644784 69585936 25642528
14:51:05 2398 8192000000 11008629200 11431264256 1998275104 19.609 100 81 162 2 2094153552 68749152 27129296
14:51:15 2224 8192000000 11032390288 11441500160 2008287552 19.688 100 90 181 0 2102425312 64840288 29297472
14:51:24 3217 8192000000 11026080576 11441668096 2010471376 19.705 100 84 168 0 2105255120 67611136 27172608
14:51:40 5474 8192000000 11022351376 11451682816 2012010816 19.717 100 70 140 1 2111442976 75876704 23555456
14:52:03 22009 8192000000 11001478656 11444703232 2002386576 19.642 100 42 84 0 2082989264 65325264 15277424
14:52:46 5281 8192000000 11006707616 11438755840 1995241808 19.585 100 69 138 0 2089571664 70847984 23481872
14:53:07 11025 8192000000 10992312368 11438972928 1998407632 19.610 100 41 82 4 2078930992 66555648 13967712
14:53:30 19431 8192000000 10955625888 11399847936 1948726400 19.216 99 35 70 1 2027647344 66210960 12709984
14:54:19 12461 8192000000 10951921808 11396964352 1948662608 19.216 99 38 76 1 2025297616 62512992 14122016
14:54:51 12997 8192000000 10957243968 11401183232 1956815200 19.281 100 33 66 1 2037579200 68316128 12447872
14:55:11 34624 8192000000 10937474432 11397177344 1942505104 19.167 99 32 65 0 2020342976 66092416 11745456
14:55:53 37974 8192000000 10930281776 11388026880 1954780688 19.265 100 28 56 1 2011161888 46390816 9990384
14:56:41 34269 8192000000 10916353216 11383554048 1947090896 19.203 100 19 36 1 1998219888 44840672 6288320
14:57:33 25717 8192000000 10896243664 11399266304 1941512960 19.159 100 16 32 1 1998404304 51059872 5831472
14:58:36 48755 8192000000 10900068288 11374485504 1952563328 19.247 100 25 50 3 1973218816 12989392 7666096
14:59:49 84205 8192000000 10890200304 11362779136 1922137904 19.004 98 8 16 0 1945073008 20943824 1991280
15:01:19 68414 8192000000 10868026704 11331686400 1874580304 18.621 96 13 26 0 1889154720 11547648 3026768
15:02:38 26193 8192000000 10881154656 11334619136 1929937872 19.066 99 26 51 0 1945577872 8462832 7177168
15:03:11 33745 8192000000 10894490304 11347353600 1935709408 19.113 99 33 65 3 1956135872 11755360 8671104
15:03:51 78616 8192000000 10905340688 11350093824 1916133680 18.956 98 21 42 1 1937470448 15422832 5913936
15:05:16 75791 8192000000 10872132544 11327037440 1922219344 19.005 98 34 68 3 1939473696 6976736 10277616
15:06:41 48698 8192000000 10881524336 11337555968 1933894720 19.098 99 40 80 3 1953082496 8172688 11015088
15:07:37 50123 8192000000 10873907200 11328618496 1910393328 18.910 98 22 44 2 1927757968 11423488 5941152
15:08:34 46275 8192000000 10913643904 11355521024 1959695568 19.304 100 30 58 1 1982525488 14399072 8430848
15:09:28 78848 8192000000 10864352816 11330658304 1914587744 18.943 98 23 46 1 1936784912 15517504 6679664
15:11:02 11910 8192000000 10856718368 11316375552 1920382064 18.990 99 22 44 1 1936754368 9844480 6527824
15:11:20 813 8192000000 10867277424 11320705024 1934690304 19.104 100 31 63 1 1953164160 9503568 8970288
15:11:28 20270 8192000000 10866104624 11339137024 1948880704 19.218 100 31 62 0 1968394064 10427120 9086240
15:11:59 20418 8192000000 10894948208 11346857984 1935514656 19.111 99 26 50 4 1950861904 8161568 7185680
15:12:29 51142 8192000000 10877374992 11340197888 1917349088 18.966 98 18 37 1 1934146592 11719232 5078272
15:13:26 29272 8192000000 10909896864 11335192576 1916881360 18.962 98 45 90 1 1942325808 12483152 12961296
15:14:05 43898 8192000000 10882724144 11353911296 1951571488 19.239 100 35 71 0 1976085024 13999488 10514048
15:15:02 21477 8192000000 10884981744 11367325696 1957635760 19.287 100 20 40 1 1975589488 12488512 5465216
15:15:46 39275 8192000000 10875954096 11345670144 1953209376 19.252 100 11 22 1 1969713696 13273488 3230832
15:16:44 12795 8192000000 10879992176 11351617536 1959221776 19.300 100 14 28 2 1971678848 8575568 3881504
15:17:16 14985 8192000000 10866922192 11333623808 1929129312 19.060 99 16 32 0 1941045696 7407616 4508768
15:17:48 22057 8192000000 10873038800 11340640256 1952719648 19.248 100 14 28 2 1963986896 7415392 3851856
15:18:20 22807 8192000000 10874982416 11346018304 1955920320 19.274 100 11 23 1 1966177040 6821232 3435488
15:18:49 13482 8192000000 10875630576 11344064512 1955700704 19.272 100 14 28 0 1966766944 7236176 3830064
15:19:09 35160 8192000000 10880867536 11351887872 1961465808 19.318 100 25 50 2 1978202688 9187408 7549472
15:19:50 67852 8192000000 10903923008 11372232704 1967527536 19.366 100 21 43 0 1979946096 6529776 5888784
15:21:08 50703 8192000000 10886313216 11359100928 1939240576 19.141 98 22 44 0 1954929504 9004768 6684160
15:22:13 23391 8192000000 10893622736 11366076416 1972487280 19.405 100 21 42 3 1989089312 10171312 6430720
15:22:44 47686 8192000000 10893844768 11367333888 1975522256 19.429 100 17 34 0 1992530896 11610640 5398000
15:23:39 82315 8192000000 10892092384 11367997440 1955616944 19.271 99 23 46 4 1977959472 15053840 7288688
15:25:22 61719 8192000000 10883591152 11360960512 1927878528 19.050 98 11 22 2 1950286256 18977040 3430688
15:26:30 47257 8192000000 10889291584 11342802944 1899874864 18.825 97 12 24 1 1911652480 8942352 2835264
15:27:25 26743 8192000000 10886238064 11350872064 1942396560 19.166 99 23 45 2 1957472416 8711264 6364592
15:27:59 38910 8192000000 10896993232 11364036608 1951397136 19.238 99 26 52 1 1968157696 9314608 7445952
15:28:46 20996 8192000000 10919810304 11378192384 1984026576 19.497 100 42 84 1 2005551648 9532432 11992640
15:29:18 40713 8192000000 10897825376 11373031424 1952922640 19.250 99 23 46 1 1972848688 12994416 6931632
15:30:07 62384 8192000000 10899296688 11367235584 1918767488 18.977 97 16 32 0 1932020112 9466224 3786400
15:31:16 32227 8192000000 10890282256 11354644480 1916603296 18.960 97 21 41 0 1933095568 11084320 5407952
15:32:07 57828 8192000000 10897310496 11369766912 1922357056 19.006 98 10 20 0 1947302400 22148528 2796816
15:33:20 82874 8192000000 10863043744 11328356352 1886697408 18.719 96 8 16 0 1898089856 9355680 2036768
15:34:50 20474 8192000000 10904817456 11355406336 1941372752 19.158 99 40 80 1 1959672976 6877392 11422832
15:35:17 32275 8192000000 10899889504 11340570624 1897716480 18.808 97 50 100 2 1925163072 13289552 14157040
15:35:59 33878 8192000000 10869528304 11318910976 1873243504 18.611 96 48 96 2 1905828672 19247024 13338144
15:36:45 69600 8192000000 10867539488 11338211328 1889397136 18.741 98 7 14 0 1906123664 14797856 1928672
15:38:04 44666 8192000000 10890879120 11334688768 1889851456 18.745 97 23 45 3 1906717280 10531120 6334704
15:39:02 49231 8192000000 10865242368 11322204160 1903764224 18.857 98 21 42 1 1924123696 14430912 5928560
15:40:06 95115 8192000000 10858180608 11314180096 1849969792 18.422 95 47 94 1 1873701600 9144912 14586896
15:41:56 48442 8192000000 10860384192 11316002816 1893481568 18.774 98 27 54 0 1911293248 9442320 8369360
15:42:51 68591 8192000000 10871205744 11313041408 1902158896 18.844 98 41 80 1 1924712880 11475792 11078192
15:44:06 19661 8192000000 10866678912 11309105152 1919151552 18.980 99 47 94 0 1943101792 10339552 13610688
15:44:33 24451 8192000000 10867456288 11314855936 1917530400 18.967 99 36 70 1 1936120416 8664896 9925120
15:45:04 21809 8192000000 10857137024 11307466752 1896036352 18.794 98 42 85 0 1917492224 9745392 11710480
15:45:47 51779 8192000000 10833075456 11299086336 1889686176 18.743 98 22 44 0 1903543664 7988064 5869424
15:46:46 61788 8192000000 10846835632 11306512384 1865785152 18.550 97 11 22 2 1882494784 13481824 3227808
15:47:55 69564 8192000000 10839128208 11307667456 1900627968 18.831 99 19 38 4 1923791152 17408272 5754912
15:49:11 54429 8192000000 10824568688 11301830656 1875319600 18.627 98 12 24 0 1893832944 14887200 3626144
15:50:12 32718 8192000000 10812697552 11273818112 1833700976 18.290 96 9 18 1 1840739440 5252032 1786432
15:50:57 27849 8192000000 10841638736 11296706560 1894090496 18.779 99 21 42 0 1907145520 6887392 6167632
15:51:32 35960 8192000000 10880757872 11324567552 1905443536 18.870 99 30 60 1 1928351584 14742992 8165056
15:52:16 46651 8192000000 10863883840 11323650048 1915172768 18.948 99 21 42 1 1936298704 15110400 6015536
15:53:10 41860 8192000000 10864362656 11334275072 1924735392 19.025 99 26 52 2 1949400992 16815968 7849632
15:53:58 53149 8192000000 10864330208 11334004736 1882166960 18.683 97 22 44 2 1906252144 17603168 6482016
15:54:59 63132 8192000000 10845791712 11331932160 1889455968 18.741 98 13 26 0 1910229280 17330720 3442592
15:56:09 61471 8192000000 10865246128 11333505024 1920528032 18.991 99 11 22 0 1939730048 15863536 3338480
15:57:18 43631 8192000000 10901081616 11345649664 1948050544 19.211 100 34 68 2 1968306368 9492768 10763056
15:58:21 40403 8192000000 10888306832 11340816384 1948778784 19.217 100 40 81 0 1971395168 11323616 11292768
15:59:25 38504 8192000000 10891251456 11345821696 1930414432 19.070 99 36 72 2 1951358240 10834976 10108832
16:00:17 53169 8192000000 10870040656 11327766528 1881039744 18.674 96 29 58 4 1899233856 10508960 7685152
16:01:20 25893 8192000000 10878017312 11326935040 1912587760 18.927 98 30 60 0 1930787776 9064496 9135520
16:01:54 23995 8192000000 10881114432 11335520256 1930177424 19.068 99 34 68 0 1948498864 8933424 9388016
16:02:25 44547 8192000000 10883890448 11346685952 1959108320 19.299 100 36 72 0 1979643744 9878640 10656784
16:03:33 115086 8192000000 10870009184 11335876608 1911123792 18.916 97 21 42 0 1924174912 7018192 6032928
16:05:34 36631 8192000000 10864729536 11333672960 1905037376 18.867 97 17 34 2 1917214576 7436272 4740928
16:06:17 75841 8192000000 10855383024 11332386816 1916487280 18.959 98 5 10 0 1924138704 6291280 1360144
16:07:47 55004 8192000000 10874458320 11352694784 1959857104 19.305 100 15 30 0 1971448832 7013904 4577824
16:08:50 95834 8192000000 10887085520 11360374784 1929072320 19.059 98 9 18 0 1939843760 8111136 2660304
16:10:36 35590 8192000000 10889168688 11370856448 1972204432 19.403 100 23 45 2 1993716368 15288240 6223696
16:11:23 40285 8192000000 10894645936 11369938944 1940762688 19.153 98 21 41 3 1957950384 11225408 5962288
16:12:16 40379 8192000000 10916238768 11381956608 1961027568 19.314 99 27 54 3 1980079808 10897168 8155072
16:13:14 58578 8192000000 10918439648 11398746112 1967635056 19.367 99 21 42 2 1989785088 15447552 6702480
16:14:23 92081 8192000000 10892568512 11362189312 1925183472 19.028 97 13 26 0 1946151536 17437856 3530208
16:16:01 54088 8192000000 10843732352 11312152576 1823250944 18.204 93 26 52 0 1840078160 9581504 7245712
16:17:02 38364 8192000000 10881332176 11329576960 1888931808 18.737 97 46 92 2 1910103552 8221024 12950720
16:17:49 94955 8192000000 10846295792 11305611264 1872068608 18.601 97 24 45 0 1894224960 16057632 6098720
16:19:33 8449 8192000000 10895003616 11330994176 1935983568 19.115 100 66 130 0 1964892416 10142384 18766464
16:19:48 112493 8192000000 10859708816 11343888384 1845029440 18.382 95 23 46 2 1866878816 16020928 5828448
16:21:48 99599 8192000000 10854186096 11308150784 1892977888 18.770 98 21 42 0 1912124736 12825392 6321456
16:23:34 35877 8192000000 10842652960 11329536000 1934613920 19.104 100 15 30 1 1948579776 9983664 3982192
16:24:17 17099 8192000000 10856992112 11342217216 1936730944 19.121 100 5 10 0 1951280528 13488976 1060608
16:24:41 35838 8192000000 10867877808 11345068032 1941218128 19.156 100 15 30 0 1954240752 9119840 3902784
16:25:31 61270 8192000000 10842102544 11322478592 1906534368 18.879 98 7 14 1 1918778112 10368640 1875104
16:26:53 54315 8192000000 10860842672 11351752704 1938704688 19.136 100 5 10 0 1952217344 12010176 1502480
16:27:54 88439 8192000000 10847115728 11342536704 1861846688 18.518 96 15 31 0 1878344096 12337360 4160048
16:29:51 58802 8192000000 9787532000 10138124288 899418608 9.893 47 10 20 0 911352720 9318736 2615376

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:34, from 12-11-2020 16:32:14 to 12-11-2020 16:32:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 128 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-11-2020 16:32:49 to 12-11-2020 16:32:51.

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          247666
MON$OLDEST_ACTIVE               247667
MON$OLDEST_SNAPSHOT             247667
MON$NEXT_TRANSACTION            247667
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                       2029664
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Thu Nov 12 16:31:03 2020
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

12.11.20 16:32:52. 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
2020-11-12 16:32:54 No severe PSQL-related problems occured
12.11.20 16:32:56. End of report.