Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.12.2020 19: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 17561288 kB
MemAvailable 31412348 kB
Buffers 0 kB
Cached 14107872 kB
SwapCached 4820 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-12-29 19:27:09
DTS_END                         2020-12-29 19:27:09.0050
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/60716
TRN_ID                          238862
ATT_ID                          711
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: 9158.59 21214 1099031
customer order: creation 175.18 352 21022
customer order: refuse 15.23 357 1828
order to supplier: creation 46.44 1245 5573
order to supplier: removal 3.33 95487 400
invoice (draft): creation 47.23 3132 5668
invoice (draft): removal 51.18 717 6142
invoice accept: apply 42.73 17253 5127
invoice accept: cancel 46.40 819 5568
customer reserve: creation 3929.62 172 471554
customer reserve: removal 4503.88 56 540465
realization accept: apply 84.47 151 10136
realization accept: cancel 81.44 111 9773
payment from customer: creation 59.81 117 7177
payment from customer: removal 5.53 84 663
payment to supplier: creation 49.92 103 5990
payment to supplier: removal 3.57 86 428
service: total inventory turnovers 4.84 1061 581
service: total monetary turnovers 6.78 53 813
service: aggregate perf. data 0.99 14924 119
service: refresh index statistics 0.03 288004 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-12-2020 19:28:10 to 29-12-2020 19:28:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4471
TEST_TIME 2 4877
TEST_TIME 3 4973
TEST_TIME 4 5373
TEST_TIME 5 5125
TEST_TIME 6 4947
TEST_TIME 7 5176
TEST_TIME 8 5366
TEST_TIME 9 5709
TEST_TIME 10 5996
TEST_TIME 11 6203
TEST_TIME 12 6491
TEST_TIME 13 6576
TEST_TIME 14 6833
TEST_TIME 15 7195
TEST_TIME 16 7859
TEST_TIME 17 8701
TEST_TIME 18 8798
TEST_TIME 19 9256
TEST_TIME 20 9382
TEST_TIME 21 9222
TEST_TIME 22 9456
TEST_TIME 23 9459
TEST_TIME 24 9499
TEST_TIME 25 9535
TEST_TIME 26 10694
TEST_TIME 27 10795
TEST_TIME 28 10711
TEST_TIME 29 10592
TEST_TIME 30 10496
TEST_TIME 31 10365
TEST_TIME 32 10140
TEST_TIME 33 10075
TEST_TIME 34 9963
TEST_TIME 35 10022
TEST_TIME 36 10194
TEST_TIME 37 10040
TEST_TIME 38 9917
TEST_TIME 39 9803
TEST_TIME 40 9772
TEST_TIME 41 9574
TEST_TIME 42 9463
TEST_TIME 43 9637
TEST_TIME 44 9542
TEST_TIME 45 9494
TEST_TIME 46 9439
TEST_TIME 47 9380
TEST_TIME 48 9477
TEST_TIME 49 9426
TEST_TIME 50 9444
TEST_TIME 51 9660
TEST_TIME 52 9690
TEST_TIME 53 9615
TEST_TIME 54 9850
TEST_TIME 55 9901
TEST_TIME 56 9877
TEST_TIME 57 9823
TEST_TIME 58 9913
TEST_TIME 59 9893
TEST_TIME 60 9734
TEST_TIME 61 9689
TEST_TIME 62 9642
TEST_TIME 63 9617
TEST_TIME 64 9627
TEST_TIME 65 9556
TEST_TIME 66 9482
TEST_TIME 67 9380
TEST_TIME 68 9338
TEST_TIME 69 9322
TEST_TIME 70 9311
TEST_TIME 71 9341
TEST_TIME 72 9324
TEST_TIME 73 9289
TEST_TIME 74 9380
TEST_TIME 75 9411
TEST_TIME 76 9389
TEST_TIME 77 9366
TEST_TIME 78 9338
TEST_TIME 79 9400
TEST_TIME 80 9438
TEST_TIME 81 9505
TEST_TIME 82 9513
TEST_TIME 83 9456
TEST_TIME 84 9397
TEST_TIME 85 9376
TEST_TIME 86 9353
TEST_TIME 87 9347
TEST_TIME 88 9339
TEST_TIME 89 9305
TEST_TIME 90 9280
TEST_TIME 91 9186
TEST_TIME 92 9225
TEST_TIME 93 9241
TEST_TIME 94 9232
TEST_TIME 95 9243
TEST_TIME 96 9262
TEST_TIME 97 9267
TEST_TIME 98 9285
TEST_TIME 99 9277
TEST_TIME 100 9236
TEST_TIME 101 9299
TEST_TIME 102 9338
TEST_TIME 103 9341
TEST_TIME 104 9333
TEST_TIME 105 9350
TEST_TIME 106 9419
TEST_TIME 107 9385
TEST_TIME 108 9340
TEST_TIME 109 9291
TEST_TIME 110 9307
TEST_TIME 111 9254
TEST_TIME 112 9224
TEST_TIME 113 9211
TEST_TIME 114 9176
TEST_TIME 115 9210
TEST_TIME 116 9174
TEST_TIME 117 9167
TEST_TIME 118 9142
TEST_TIME 119 9237
TEST_TIME 120 9162

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 29-12-2020 19:28:13 to 29-12-2020 19:28:17.

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 1534632 1534632 0 0.00 0 39736 6 0 0
doc_list_biud 1534628 1534628 0 0.00 0 29630 25 0 0
sp_add_invoice_to_stock 5249 5127 122 2.32 28 179323 17253 0 122
sp_cancel_adding_invoice 5568 5568 0 0.00 5 78022 819 0 0
sp_cancel_client_order 1828 1828 0 0.00 3 11780 358 0 0
sp_cancel_customer_reserve 540465 540465 0 0.00 1 24947 56 0 0
sp_cancel_pay_from_customer 663 663 0 0.00 2 7645 85 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 2 6208 86 0 0
sp_cancel_supplier_invoice 6154 6142 12 0.19 1 15488 718 0 12
sp_cancel_supplier_order 400 400 0 0.00 7 844357 95487 0 0
sp_cancel_write_off 9773 9773 0 0.00 1 21207 112 0 0
sp_client_order 21022 21022 0 0.00 3 16479 353 0 0
sp_customer_reserve 471554 471554 0 0.00 0 148410 172 0 0
sp_fill_shopping_cart 32250 32250 0 0.00 0 16701 40 0 0
sp_fill_shopping_cart_clo_res 471552 471552 0 0.00 0 17976 14 0 0
sp_get_clo_for_invoice 5122 5122 0 0.00 0 21835 312 0 0
sp_kill_cost_storno 16432 16432 0 0.00 0 13901 52 0 0
sp_kill_qstorno_ret_qs2qd 1097245 1097245 0 0.00 0 24944 30 0 0
sp_kill_qty_storno 579434 579434 0 0.00 0 29629 66 0 0
sp_lock_selected_doc 21151 21151 0 0.00 0 8691 5 0 0
sp_make_cost_storno 28425 28425 0 0.00 0 39726 44 0 0
sp_multiply_rows_for_pdistr 28425 28425 0 0.00 0 22967 28 0 0
sp_multiply_rows_for_qdistr 21022 21022 0 0.00 0 12076 175 0 0
sp_pay_from_customer 7177 7177 0 0.00 4 39603 118 0 0
sp_pay_to_supplier 5990 5990 0 0.00 5 15194 104 0 0
sp_payment_common 13162 13162 0 0.00 1 39553 29 0 0
sp_qd_handle_on_cancel_clo 1828 1828 0 0.00 0 11774 324 0 0
sp_qd_handle_on_invoice_upd_sts 10690 10690 0 0.00 0 29628 309 0 0
sp_qd_handle_on_reserve_upd_sts 10136 10136 0 0.00 0 20413 56 0 0
sp_reserve_write_off 10136 10136 0 0.00 6 20434 151 0 0
sp_supplier_invoice 5668 5668 0 0.00 6 98942 3133 0 0
sp_supplier_order 5573 5573 0 0.00 5 32832 1245 0 0
srv_aggregate_perf_data 120 119 1 0.83 2291 134677 14924 0 1
srv_fill_mon_cache_memory 152 152 0 0.00 1297 152396 34673 0 0
srv_find_qd_qs_mism 1049909 1049909 0 0.00 0 18738 6 0 0
srv_make_invnt_saldo 581 581 0 0.00 9 64329 1061 0 0
srv_make_money_saldo 813 813 0 0.00 1 26814 54 0 0
srv_recalc_idx_stat 4 4 0 0.00 226267 413303 288005 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5127 5127 0 0.00 0 7707 154 0 0
t$perf-norm:sp_cancel_adding_invoice 426 426 0 0.00 0 2802 83 0 0
t$perf-norm:sp_cancel_client_order 1828 1828 0 0.00 0 5775 14 0 0
t$perf-norm:sp_cancel_customer_reserve 702 702 0 0.00 0 4568 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 663 663 0 0.00 0 6710 25 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 7061 21 0 0
t$perf-norm:sp_cancel_supplier_invoice 394 394 0 0.00 0 1054 17 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 26105 1480 0 0
t$perf-norm:sp_cancel_write_off 1055 1055 0 0.00 0 2354 16 0 0
t$perf-norm:sp_client_order 21023 21023 0 0.00 0 7420 17 0 0
t$perf-norm:sp_customer_reserve 1037 1037 0 0.00 0 4855 17 0 0
t$perf-norm:sp_pay_from_customer 7177 7177 0 0.00 0 6167 11 0 0
t$perf-norm:sp_pay_to_supplier 5990 5990 0 0.00 0 8348 13 0 0
t$perf-norm:sp_reserve_write_off 10137 10137 0 0.00 0 8736 16 0 0
t$perf-norm:sp_supplier_invoice 5668 5668 0 0.00 0 8327 21 0 0
t$perf-norm:sp_supplier_order 5573 5573 0 0.00 0 3770 15 0 0
t$perf-norm:srv_aggregate_perf_data 119 119 0 0.00 0 154 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 1556 21 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 4960 27 0 0
t$perf-norm:srv_make_money_saldo 813 813 0 0.00 0 805 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10484 10240 244 2.32 0 8186 17 0 244
v_all_customers 38556 38556 0 0.00 0 48 1 0 0
v_all_suppliers 30948 30948 0 0.00 0 27 1 0 0
v_all_wares 42044 42044 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 852 852 0 0.00 0 218 5 0 0
v_cancel_client_order 3656 3656 0 0.00 0 2400 4 0 0
v_cancel_customer_prepayment 1326 1326 0 0.00 0 581 3 0 0
v_cancel_customer_reserve 1404 1404 0 0.00 0 1681 4 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 4506 12 0 0
v_cancel_supplier_invoice 812 788 24 2.95 0 1473 16 0 24
v_cancel_supplier_order 800 800 0 0.00 0 2368 7 0 0
v_cancel_write_off 2110 2110 0 0.00 0 2864 14 0 0
v_max_id_clo_ord 5571 5571 0 0.00 0 972 1 0 0
v_max_id_clo_res 1037 1037 0 0.00 0 5586 17 0 0
v_max_id_ord_sup 5657 5657 0 0.00 0 3030 4 0 0
v_max_non_paid_invoice 1739 1739 0 0.00 0 3503 5 0 0
v_max_non_paid_realizn 3728 3728 0 0.00 0 4022 4 0 0
v_min_id_clo_ord 5571 5571 0 0.00 0 2925 7 0 0
v_min_id_clo_res 1037 1037 0 0.00 0 3305 6 0 0
v_min_id_ord_sup 5657 5657 0 0.00 0 5900 12 0 0
v_min_non_paid_invoice 5985 5985 0 0.00 0 5984 15 0 0
v_min_non_paid_realizn 7177 7177 0 0.00 0 19539 16 0 0
v_our_firm 10386 10386 0 0.00 0 12 1 0 0
v_reserve_write_off 20270 20270 0 0.00 0 2402 4 0 0
x_lock_depdocs_on_canc_invoice 11316 11316 0 0.00 0 15520 123 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 10924 346 0 0
x_make_qstorno_1000_1200 5573 5573 0 0.00 2 32795 1170 0 0
x_make_qstorno_1200_2000 5668 5668 0 0.00 3 98893 2987 0 0
x_make_qstorno_2100_3300 471554 471554 0 0.00 0 148409 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-12-2020 19:28:18 to 29-12-2020 19:28:22.

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
16:57:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:19 8944 8192000000 10172563296 10477490176 900264224 9.901 71 48 96 0 918087968 2443696 15380048
16:57:36 33373 8192000000 10336125632 10653655040 1384367376 14.456 100 86 172 0 1417048256 4740976 27939904
16:58:19 40516 8192000000 10385191440 10709336064 1431693984 14.876 100 90 179 1 1468660096 7122032 29844080
16:59:13 23921 8192000000 10402024352 10731532288 1454014176 15.073 100 84 168 0 1490092528 7864880 28213472
16:59:48 25494 8192000000 10428323424 10759049216 1479081840 15.293 100 92 184 0 1517541520 8305312 30154368
17:00:29 22498 8192000000 10455901232 10790744064 1511985472 15.581 100 91 183 0 1550401744 9443472 28972800
17:01:03 12745 8192000000 10469945072 10808897536 1525279456 15.696 100 84 168 0 1561722576 9788944 26654176
17:01:26 18500 8192000000 10503658176 10848268288 1552768064 15.934 100 81 162 0 1588317456 10042080 25507312
17:01:51 20217 8192000000 10524979104 10879246336 1578934000 16.159 100 83 167 2 1614588800 10333872 25320928
17:02:20 19487 8192000000 10549239904 10909073408 1607968224 16.407 100 83 166 1 1644520048 11336656 25215168
17:02:48 10940 8192000000 10576499104 10940342272 1635325040 16.640 100 78 156 1 1670428080 11677712 23425328
17:03:09 7924 8192000000 10596434304 10959466496 1657477536 16.828 100 84 168 1 1694544048 11847968 25218544
17:03:28 11093 8192000000 10606667872 10980257792 1675629888 16.981 100 78 156 1 1710929040 12086464 23212688
17:03:47 12010 8192000000 10641902096 11009658880 1693757312 17.133 100 79 158 1 1728911696 11717792 23436592
17:04:07 8527 8192000000 10650658144 11020750848 1708130560 17.253 100 82 163 2 1745100160 12610768 24358832
17:04:29 8566 8192000000 10670517824 11045990400 1730477952 17.439 100 69 138 2 1762146944 11907696 19761296
17:04:46 6634 8192000000 10690246352 11068735488 1751172944 17.611 100 80 160 1 1785578544 11575968 22829632
17:05:01 5397 8192000000 10706182592 11082682368 1762743984 17.707 100 75 151 0 1795865328 11677872 21443472
17:05:15 5392 8192000000 10710578928 11094331392 1773345456 17.795 100 74 147 2 1805502704 11908112 20249136
17:05:27 4941 8192000000 10723550368 11104456704 1787608240 17.912 100 82 162 2 1822605360 12204640 22792480
17:05:39 5165 8192000000 10734364528 11115995136 1793157760 17.958 100 85 168 0 1829375744 13456640 22761344
17:05:51 3242 8192000000 10736295504 11118051328 1797913616 17.997 100 81 162 1 1833687008 13079088 22694304
17:06:02 3994 8192000000 10739486832 11120775168 1805010480 18.055 100 90 179 2 1842377104 12810256 24556368
17:06:13 3941 8192000000 10748492976 11130671104 1808998960 18.088 100 84 169 2 1845771984 13367408 23405616
17:06:24 3281 8192000000 10753333680 11135991808 1815175840 18.138 100 89 175 1 1853599936 14383792 24040304
17:06:35 2900 8192000000 10753361936 11140046848 1815722384 18.143 100 86 172 0 1853143792 12882208 24539200
17:06:44 10431 8192000000 10758692768 11151503360 1824660624 18.216 100 84 168 2 1861865936 13356608 23848704
17:07:02 6314 8192000000 10773852656 11166330880 1830265968 18.261 100 81 162 1 1865927168 12885248 22775952
17:07:15 2312 8192000000 10779324080 11167215616 1844917744 18.381 100 85 167 1 1881233936 12397648 23918544
17:07:24 2532 8192000000 10794866064 11180388352 1850599200 18.427 100 94 187 0 1890214160 13549904 26065056
17:07:32 2392 8192000000 10796517264 11186909184 1852320144 18.441 100 88 176 0 1891878928 15620464 23938320
17:07:41 1527 8192000000 10797696928 11189579776 1855557792 18.467 100 85 170 1 1894040112 15224000 23258320
17:07:50 2241 8192000000 10791285648 11185229824 1857420352 18.482 100 88 175 2 1895499216 13714096 24364768
17:07:59 1950 8192000000 10807092848 11196739584 1861907744 18.519 100 94 187 1 1901237968 13122928 26207296
17:08:07 1750 8192000000 10814840352 11202473984 1865765008 18.550 100 91 180 0 1905132112 13274432 26092672
17:08:15 1757 8192000000 10811291296 11198201856 1862986896 18.527 100 89 178 2 1902364336 13862848 25514592
17:08:23 1693 8192000000 10814977968 11203710976 1870698960 18.590 100 95 190 5 1910681744 13633568 26349216
17:08:31 1540 8192000000 10815607072 11204505600 1869650848 18.581 100 92 184 1 1908587728 13421440 25515440
17:08:39 2830 8192000000 10811483136 11205537792 1870227296 18.586 100 87 174 1 1908057776 12333056 25497424
17:08:48 1504 8192000000 10819770416 11211055104 1874837008 18.623 100 94 187 2 1913749136 12700576 26211552
17:08:56 25675 8192000000 10805172592 11209519104 1874888176 18.624 100 64 129 0 1903177904 10491568 17798160
17:09:30 1466 8192000000 10828139584 11219988480 1881332208 18.676 100 91 182 0 1920704384 11787024 27585152
17:09:37 4848 8192000000 10787773184 11208429568 1873528688 18.613 100 49 98 3 1897369616 9407232 14433696
17:09:49 8666 8192000000 10798357024 11213168640 1875320032 18.627 100 51 100 1 1897181376 8225232 13636112
17:10:04 4272 8192000000 10791173552 11212185600 1875706608 18.630 100 34 68 3 1894023808 9153376 9163824
17:10:14 4387 8192000000 10796568400 11217596416 1878633712 18.654 100 35 72 1 1895506032 6849936 10022384
17:10:26 7315 8192000000 10793117760 11221831680 1880380112 18.668 100 33 66 0 1897975664 8596464 8999088
17:10:40 6253 8192000000 10794368368 11222061056 1882796304 18.688 100 34 69 0 1899818832 7539712 9482816
17:10:58 8189 8192000000 10794682624 11221692416 1890477040 18.750 100 35 68 1 1906845072 6824672 9543360
17:11:16 4435 8192000000 10801843824 11225403392 1890819040 18.752 100 33 66 1 1906750336 5828368 10102928
17:11:29 59036 8192000000 10823929520 11243098112 1896521856 18.798 100 36 72 0 1911890928 5004720 10364352
17:12:34 15409 8192000000 10799569872 11237580800 1895036768 18.786 100 30 59 1 1909969504 6623328 8309408
17:12:59 9913 8192000000 10812533600 11241340928 1893463376 18.774 100 20 40 1 1905087152 6402192 5221584
17:13:18 8269 8192000000 10803193088 11242524672 1897711232 18.808 100 35 70 0 1914713920 6765856 10236832
17:13:35 7178 8192000000 10813038848 11244822528 1896939856 18.802 100 24 48 0 1909641664 6063040 6638768
17:13:49 10466 8192000000 10809739776 11248390144 1898374720 18.813 100 16 32 0 1909144848 6126640 4643488
17:14:07 6267 8192000000 10806209344 11249192960 1900993120 18.834 100 22 44 1 1913629344 5945680 6690544
17:14:20 5730 8192000000 10802988832 11245748224 1904955552 18.866 100 22 45 0 1916860176 5498640 6405984
17:14:32 9576 8192000000 10822767376 11257286656 1902494448 18.846 100 18 36 1 1921366240 13706304 5165488
17:14:48 13733 8192000000 10811725728 11247652864 1899912016 18.826 100 16 31 2 1910196112 5956544 4327552
17:15:12 8469 8192000000 10822775440 11255812096 1901183808 18.836 100 24 49 2 1917862496 10033696 6644992
17:15:33 7031 8192000000 10817297200 11256774656 1903665744 18.856 100 19 38 1 1914615952 5767632 5182576
17:15:47 7241 8192000000 10811475504 11254157312 1904396288 18.862 100 23 46 1 1917678416 7115392 6166736
17:16:00 13977 8192000000 10826558368 11236573184 1887792000 18.728 99 27 55 2 1901385296 5445200 8148096
17:16:20 63183 8192000000 10769645056 11212533760 1801854016 18.029 95 31 60 2 1816971216 5978336 9138864
17:17:31 10095 8192000000 10768232544 11204984832 1825792320 18.225 97 19 38 1 1840591808 9215120 5584368
17:17:48 5026 8192000000 10791871712 11221331968 1865073920 18.544 99 24 46 1 1877480672 6057648 6349104
17:18:02 6176 8192000000 10799091904 11222913024 1880288720 18.667 100 37 73 1 1897312288 6677104 10346464
17:18:14 5903 8192000000 10781925840 11210506240 1866481808 18.556 100 34 67 2 1882170640 6034048 9654784
17:18:27 3286 8192000000 10791711776 11224125440 1878633632 18.654 100 34 69 1 1894937312 6634176 9669504
17:18:41 7371 8192000000 10755303744 11181432832 1788274496 17.918 96 26 52 1 1801161008 5276320 7610192
17:18:59 7945 8192000000 10759145616 11178143744 1771041072 17.776 95 27 52 1 1784162032 5437584 7683376
17:19:17 11330 8192000000 10740179088 11163529216 1769123008 17.760 96 11 22 0 1777346512 5292336 2931168
17:19:35 7402 8192000000 10712124864 11130540032 1747564336 17.581 96 27 54 1 1760738912 5676816 7497760
17:19:49 10333 8192000000 10738654128 11153612800 1799056656 18.006 99 28 56 1 1813164640 5522992 8584992
17:20:05 12316 8192000000 10721724752 11146244096 1769386352 17.762 97 31 62 0 1784956560 5800048 9770160
17:20:26 10657 8192000000 10696294864 11113066496 1697736656 17.166 94 22 44 0 1709250304 5194784 6318864
17:20:49 72916 8192000000 10682894112 11095015424 1587570880 16.233 89 24 48 1 1598856976 4707760 6578336
17:22:11 8077 8192000000 10689919856 11106623488 1751356928 17.613 98 32 64 0 1767133936 6346240 9430768
17:22:28 7759 8192000000 10714886464 11115851776 1768770656 17.757 99 37 74 1 1786518912 6965728 10782528
17:22:43 9537 8192000000 10728906032 11138220032 1785690304 17.896 99 30 60 0 1800247440 5987248 8569888
17:23:01 5052 8192000000 10730998576 11149930496 1812295072 18.115 100 26 52 2 1826583584 6252864 8035648
17:23:15 9708 8192000000 10761027920 11172962304 1825874768 18.226 100 31 61 3 1848402176 14076848 8450560
17:23:34 6018 8192000000 10782551216 11180032000 1840893856 18.348 100 37 74 0 1858954592 7251616 10809120
17:23:50 5647 8192000000 10768992944 11180531712 1822581968 18.199 99 27 52 1 1836737344 6001920 8153456
17:24:03 9850 8192000000 10766220432 11188838400 1843222112 18.367 100 22 44 1 1855158272 5417456 6518704
17:24:20 13483 8192000000 10769446752 11195990016 1848775712 18.412 100 27 55 0 1862076640 5154912 8146016
17:24:42 4808 8192000000 10756501232 11192139776 1855837984 18.470 100 25 50 3 1869880416 5586224 8456208
17:24:53 8010 8192000000 10772637392 11196665856 1856000512 18.471 100 30 59 2 1871168944 5973376 9195056
17:25:10 82028 8192000000 10798298768 11212333056 1867094832 18.561 100 30 58 2 1880760896 5133344 8532720
17:26:39 10208 8192000000 10777933808 11206623232 1863592000 18.532 100 17 34 1 1873896480 5311248 4993232
17:26:55 9951 8192000000 10783065392 11212480512 1867473968 18.564 100 21 42 0 1879753152 6172944 6106240
17:27:12 35288 8192000000 10824462896 11239112704 1890597552 18.751 100 36 73 0 1905544992 4922096 10025344
17:27:54 26062 8192000000 10848237744 11261550592 1908755776 18.897 100 56 112 1 1933795200 9585808 15453616
17:28:27 20223 8192000000 10852760080 11267543040 1916518768 18.959 100 60 120 1 1945269904 12133360 16617776
17:28:59 9515 8192000000 10852988224 11270008832 1921664448 19.000 100 54 108 1 1949408880 12705728 15038704
17:29:16 23476 8192000000 10854494032 11279519744 1922510288 19.007 100 48 97 0 1949125408 12989680 13625440
17:29:55 17171 8192000000 10859477520 11284402176 1929576736 19.063 100 39 78 2 1952663888 12239584 10847568
17:30:20 16671 8192000000 10872146736 11299504128 1942164832 19.164 100 44 88 0 1970258352 15662352 12431168
17:30:48 28567 8192000000 10875264352 11308916736 1939894464 19.146 100 40 80 0 1971368816 19719600 11754752
17:31:30 19926 8192000000 10883071488 11313111040 1944424832 19.182 100 41 78 1 1970286976 13807264 12054880
17:32:00 24270 8192000000 10893796672 11323138048 1960305648 19.308 100 44 86 0 1989565824 16357520 12902656
17:32:41 17256 8192000000 10899910752 11335839744 1964900560 19.345 100 41 82 1 1997000016 18952992 13146464
17:33:05 17761 8192000000 10922738704 11346489344 1969077584 19.378 100 46 91 4 2006375728 23975504 13322640
17:33:33 23799 8192000000 10929276912 11347234816 1972379296 19.404 100 46 92 0 2008866640 22175104 14312240
17:34:13 20885 8192000000 10912977232 11351298048 1973282768 19.411 100 46 92 0 2011730480 24040624 14407088
17:34:43 16844 8192000000 10912946880 11355279360 1973036864 19.410 100 36 72 1 2007872320 23762608 11072848
17:35:08 17967 8192000000 10932940400 11368640512 1983618000 19.493 100 45 88 2 2021474048 24638112 13217936
17:35:44 6453 8192000000 10934666448 11367997440 1988940000 19.535 100 49 98 0 2026812064 23164784 14707280
17:35:57 2170 8192000000 10952564432 11376168960 1994971248 19.583 100 72 146 1 2038454144 22589920 20892976
17:36:07 2123 8192000000 10962734208 11377082368 1998907312 19.614 100 70 138 3 2041100352 21665200 20527840
17:36:17 4518 8192000000 10964098832 11383197696 2005063392 19.663 100 69 138 4 2047627120 22284128 20279600
17:36:29 1787 8192000000 10978826336 11393667072 2008201568 19.687 100 87 173 1 2059036272 25581520 25253184
17:36:38 10408 8192000000 10970119792 11390582784 2012599632 19.722 100 79 157 0 2062557344 27163872 22793840
17:36:56 9381 8192000000 10960956848 11385561088 2000802912 19.629 100 72 144 0 2048427424 26719840 20904672
17:37:18 5016 8192000000 10975702000 11388088320 2007769712 19.684 100 68 132 3 2055067872 26853584 20444576
17:37:29 3964 8192000000 10959936656 11381968896 1988194960 19.530 99 65 128 2 2031836256 24175216 19466080
17:37:42 9320 8192000000 10955215088 11371819008 1983441568 19.492 99 64 126 2 2028216448 26188576 18586304
17:37:59 15216 8192000000 10953342224 11381399552 1997716416 19.605 100 51 102 1 2039238496 25830976 15691104
17:38:28 5740 8192000000 10963815232 11390640128 2009522880 19.698 100 67 134 0 2056489584 26945440 20021264
17:38:41 3095 8192000000 10971988064 11398471680 2013056960 19.726 100 67 134 0 2058464080 24952160 20454960
17:38:51 4656 8192000000 10977037248 11396161536 1997422384 19.602 99 79 158 0 2048141424 26755552 23963488
17:39:06 2355 8192000000 10995555840 11405398016 2020293536 19.782 100 92 183 4 2076043744 28375600 27374608
17:39:15 3137 8192000000 10986938256 11406897152 2019385488 19.775 100 84 165 2 2073884304 29355600 25143216
17:39:25 2980 8192000000 10985962144 11398979584 2012756272 19.723 100 88 177 1 2067887232 28804320 26326640
17:39:35 3308 8192000000 10976707312 11390115840 2004824272 19.661 100 84 168 1 2058498640 28975056 24699312
17:39:45 3973 8192000000 10971820992 11384922112 1988063728 19.528 99 82 162 1 2044137808 30820512 25253568
17:39:55 5237 8192000000 10951912688 11377487872 1988577136 19.533 100 72 144 3 2041266864 30501456 22188272
17:40:14 12562 8192000000 10961643632 11391057920 1997405936 19.602 100 57 112 3 2047816864 32496016 17914912
17:40:33 3143 8192000000 10975245072 11399798784 2007017056 19.678 100 69 138 0 2061875136 33679968 21178112
17:40:48 14199 8192000000 10976278192 11407523840 2010849056 19.708 100 63 126 1 2063151536 33136592 19165888
17:41:18 7731 8192000000 10981634704 11422707712 2021777056 19.794 100 56 112 0 2078680416 38927888 17975472
17:41:35 2377 8192000000 11000350240 11428618240 2024392208 19.815 100 72 145 1 2086494192 39092624 23009360
17:41:47 4230 8192000000 11001029312 11425132544 2019182128 19.774 100 74 148 0 2082933072 40758880 22992064
17:41:58 5556 8192000000 11000101152 11420319744 2001263424 19.633 99 75 149 2 2066599520 41983808 23352288
17:42:10 2784 8192000000 11000251568 11426549760 2020175664 19.782 100 82 164 0 2087344304 42073792 25094848
17:42:23 4240 8192000000 10991541248 11423399936 2012104064 19.718 100 68 133 1 2076759024 43264560 21390400
17:42:38 7099 8192000000 11002562432 11429199872 2019074080 19.773 100 75 150 2 2088539680 45861408 23604192
17:42:55 3906 8192000000 10986109072 11408252928 1989244208 19.538 99 77 153 0 2056298000 43772816 23280976
17:43:06 1296 8192000000 10994165520 11414802432 2005069424 19.663 100 79 157 2 2075531376 45002912 25459040
17:43:14 3758 8192000000 10997741072 11421634560 2007970640 19.686 100 75 148 0 2077990944 47373808 22646496
17:43:26 3036 8192000000 11000804560 11431931904 2016310432 19.751 100 74 148 0 2089433328 49288880 23834016
17:43:36 4131 8192000000 10988881072 11415601152 2001385808 19.634 100 77 154 1 2073137328 46727760 25023760
17:43:51 2199 8192000000 11002228672 11426140160 2014803440 19.739 100 81 161 1 2087683696 47556432 25323824
17:43:59 2574 8192000000 10967935024 11410714624 2000582400 19.627 100 63 126 2 2062633728 42614272 19437056
17:44:14 6901 8192000000 10963538192 11401981952 1984110448 19.497 99 55 110 2 2039637200 38269072 17257680
17:44:32 4518 8192000000 10952132032 11401035776 1996262272 19.593 100 40 80 0 2041659168 32098064 13298832
17:44:43 15224 8192000000 10948321664 11398156288 1982771568 19.487 99 44 88 0 2024816480 28666336 13378576
17:45:06 2159 8192000000 10966834192 11404267520 1981139872 19.474 99 57 114 2 2034810128 36234336 17435920
17:45:18 7508 8192000000 10945964960 11388903424 1986343872 19.515 100 41 82 1 2031454880 31944960 13166048
17:45:45 21395 8192000000 10930855440 11379273728 1928725936 19.057 97 25 50 1 1973486224 36092448 8667840
17:46:13 27689 8192000000 10916123136 11381252096 1952537680 19.247 99 23 46 1 1996755280 36135968 8081632
17:46:52 12789 8192000000 10951807824 11386183680 1981572416 19.477 100 48 96 0 2024182944 28085072 14525456
17:47:11 4288 8192000000 10944278144 11376521216 1980070336 19.465 100 67 136 1 2031253952 30888560 20295056
17:47:26 23053 8192000000 10896717024 11349344256 1913597056 18.936 97 31 62 0 1950851296 27572752 9681488
17:48:04 4683 8192000000 10919050096 11359318016 1963930720 19.337 100 42 84 0 2003257472 26732240 12594512
17:48:19 14370 8192000000 10904764160 11350917120 1936462896 19.119 99 29 57 1 1975705376 30357936 8884544
17:48:39 10776 8192000000 10908554928 11353567232 1942294064 19.165 99 24 48 0 1980697600 30531088 7872448
17:48:58 17031 8192000000 10905099856 11352813568 1932872208 19.090 99 22 44 0 1974129520 33580800 7676512
17:49:22 4211 8192000000 10883020400 11321049088 1911473248 18.918 98 33 66 1 1958087040 35025680 11588112
17:49:40 17442 8192000000 10911107744 11372457984 1955153872 19.268 100 28 56 5 2003255728 38539632 9562224
17:50:04 30622 8192000000 10894780544 11349106688 1912093632 18.923 98 21 42 1 1954441904 35472912 6875360
17:50:41 20498 8192000000 10876371168 11322748928 1855322144 18.465 96 20 41 1 1902115968 40198400 6595424
17:51:08 17708 8192000000 10869734800 11309314048 1883104048 18.690 98 30 60 2 1930097840 37084000 9909792
17:51:37 14785 8192000000 10860579936 11309543424 1874869712 18.624 98 25 50 0 1922133008 38066112 9197184
17:52:06 44240 8192000000 10872567008 11319504896 1851981024 18.438 97 20 40 0 1903501232 44486096 7034112
17:52:58 36038 8192000000 10842931552 11303608320 1871071552 18.593 98 14 27 1 1900035536 24211840 4752144
17:53:42 18326 8192000000 10864323360 11314606080 1920130704 18.988 100 26 52 2 1949968848 21464864 8373280
17:54:10 57458 8192000000 10864321936 11315580928 1888918992 18.737 98 13 27 0 1905232368 12931872 3381504
17:55:18 23736 8192000000 10846350448 11299418112 1889129552 18.739 98 38 76 4 1913909840 13987728 10792560
17:55:55 120386 8192000000 10870681088 11320393728 1907976064 18.890 99 35 70 2 1933355568 15042128 10337376
17:58:10 50348 8192000000 10851715248 11313688576 1886932784 18.721 97 14 28 2 1904368384 13916176 3519424
18:00:15 70435 8192000000 10849801024 11291336704 1831674464 18.273 94 28 56 0 1854943248 14736112 8532672
18:01:33 24919 8192000000 10869285088 11305168896 1919624576 18.984 100 48 93 2 1950046224 16208192 14213456
18:02:09 53570 8192000000 10848722368 11309576192 1900207472 18.828 99 19 38 2 1925659584 20243824 5208288
18:04:03 48451 8192000000 10861745856 11320844288 1937046848 19.123 100 15 30 0 1948436416 7170032 4219536
18:04:59 152396 8192000000 10877484016 11340304384 1891477056 18.758 97 16 32 0 1904411376 8479440 4454880
18:07:50 88847 8192000000 10892288080 11343630336 1939541888 19.143 99 14 28 0 1959700368 15776992 4381488
18:09:47 50373 8192000000 10881193744 11347980288 1958644896 19.295 100 33 66 3 1984967392 16312176 10010320
18:11:21 21358 8192000000 10871301536 11336650752 1935067984 19.107 99 24 46 2 1949359776 7731136 6560656
18:11:55 63045 8192000000 10881014384 11354800128 1968553184 19.374 100 28 56 1 1990408912 13747360 8108368
18:13:08 57244 8192000000 10875747040 11343560704 1924457168 19.023 98 10 19 1 1934656880 7360000 2839712
18:14:11 30666 8192000000 10884430496 11355521024 1966322864 19.356 100 24 48 2 1980876400 8080480 6473056
18:15:11 59652 8192000000 10902516848 11376648192 1957916720 19.289 99 37 74 0 1982291040 13592224 10782096
18:16:26 42975 8192000000 10921116208 11380764672 1981345296 19.475 100 22 44 2 2005737872 18006272 6386304
18:17:17 78983 8192000000 10907621696 11396259840 1980879888 19.472 100 15 30 0 2005434016 19944400 4609728
18:18:52 83432 8192000000 10919830176 11383537664 1963145152 19.331 99 13 26 1 1980756688 13767296 3844240
18:20:31 48846 8192000000 10911257600 11390029824 1954214560 19.260 98 25 50 2 1977669488 16213392 7241536
18:21:26 78204 8192000000 10911836096 11398119424 1955181376 19.268 99 14 28 3 1973473760 14359680 3932704
18:22:50 65234 8192000000 10920677248 11393404928 1966618624 19.359 99 30 60 3 1986932528 12046000 8267904
18:24:02 58149 8192000000 10946095520 11389628416 1980100816 19.465 99 18 36 1 1994847104 10082032 4664256
18:25:07 31323 8192000000 10933103360 11393089536 1981397696 19.476 99 24 48 2 1997909072 10053392 6457984
18:25:49 122088 8192000000 10909670064 11384926208 1935162416 19.108 97 13 26 0 1956006480 17476608 3367456
18:27:59 99796 8192000000 10903907584 11375673344 1954350736 19.261 98 32 63 0 1975643216 12788592 8503888
18:29:50 36773 8192000000 10896690320 11374026752 1912823184 18.929 96 27 54 1 1937503360 17411168 7269008
18:30:40 25881 8192000000 10888426576 11358375936 1942249296 19.165 98 22 40 1 1958556992 10434512 5873184
18:31:53 68263 8192000000 10866037600 11338620928 1901420528 18.838 96 12 24 0 1911296512 6638592 3237392
18:33:12 58302 8192000000 10876467744 11346841600 1952671088 19.248 100 16 32 1 1965694256 8335520 4687648
18:34:48 45497 8192000000 10874070320 11346485248 1938387424 19.134 99 16 32 0 1951557376 8870960 4298992
18:36:52 56971 8192000000 10851854816 11330928640 1880002560 18.665 96 14 28 0 1893306688 9267440 4036688
18:38:03 51625 8192000000 10843333728 11314061312 1883795920 18.696 97 12 24 0 1902736128 15003920 3936288
18:39:05 77721 8192000000 10878801584 11351822336 1945355072 19.189 100 10 20 0 1962433152 13793216 3284864
18:40:31 30584 8192000000 10896271968 11357478912 1911054784 18.915 97 30 60 1 1934849808 15583264 8211760
18:41:22 63595 8192000000 10886879760 11365777408 1940363856 19.150 99 13 26 0 1958370144 14566512 3439776
18:42:32 41256 8192000000 10871595872 11316371456 1823999536 18.210 93 32 64 0 1840386128 7752704 8633888
18:43:20 55489 8192000000 10852331888 11309199360 1844141696 18.375 95 24 48 0 1861252032 10565648 6544688
18:44:25 27507 8192000000 10859530352 11318620160 1894933296 18.786 98 26 52 2 1913743344 11606336 7203712
18:45:01 25145 8192000000 10863759904 11315908608 1892752704 18.768 98 31 62 2 1910431776 8764640 8914432
18:45:39 46072 8192000000 10854680384 11317026816 1897470176 18.806 98 28 56 1 1918794208 12676816 8647216
18:46:33 60170 8192000000 10863985840 11342663680 1922957488 19.011 100 18 36 0 1947725152 19528720 5238944
18:48:44 46751 8192000000 10874748912 11337691136 1937019360 19.123 100 9 18 0 1949908256 10615488 2273408
18:49:55 91396 8192000000 10847247616 11303026688 1873880624 18.616 97 33 66 1 1893752320 10462480 9409216
18:51:33 53155 8192000000 10839674784 11295055872 1865864320 18.551 97 21 42 0 1878518496 6747984 5906192
18:52:58 62235 8192000000 10846779504 11319734272 1921322736 18.997 100 21 42 4 1944636896 17182096 6132064
18:54:07 12787 8192000000 10841046080 11325235200 1920402352 18.990 100 5 8 1 1936736080 15171056 1162672
18:54:31 54328 8192000000 10845882704 11326365696 1913372240 18.934 99 17 34 2 1925528208 7522624 4633344
18:55:32 34215 8192000000 10844291440 11323281408 1915504544 18.951 99 6 12 0 1926791264 9599168 1687552
18:56:12 21521 8192000000 10851429808 11320860672 1929356928 19.062 100 6 12 0 1940729872 9718144 1654800
18:56:40 66556 8192000000 10851857680 11317014528 1884145040 18.699 97 17 32 3 1897152368 7991264 5016064
18:58:02 75843 8192000000 10837160720 11306631168 1884158944 18.699 97 23 46 1 1898634928 7763328 6712656
18:59:28 62359 8192000000 10877881712 11335614464 1923477664 19.015 99 12 24 1 1933804848 7306160 3021024
19:00:50 50501 8192000000 10874813360 11335372800 1948946832 19.218 100 18 35 1 1961296448 7769392 4580224
19:01:50 82515 8192000000 10886499504 11352264704 1920336704 18.990 98 24 47 0 1935155600 8212800 6606096
19:03:22 91265 8192000000 10907397408 11380633600 1976677872 19.438 100 15 30 0 1990746592 9722336 4346384
19:05:00 82980 8192000000 10904785520 11373641728 1942524960 19.167 98 10 20 0 1958847616 13888368 2434288
19:06:41 39548 8192000000 10928927552 11390275584 1993807824 19.574 100 36 69 0 2017775584 14866672 9101088
19:07:28 38710 8192000000 10947624528 11404275712 1997827056 19.606 100 36 72 1 2026470640 18737808 9905776
19:08:14 76620 8192000000 10930743152 11403972608 1998119584 19.608 100 32 63 1 2025771664 18870640 8781440
19:09:44 59841 8192000000 10913869408 11368910848 1962643072 19.327 98 26 52 2 1979852864 9881616 7328176
19:10:56 46330 8192000000 10925665968 11390418944 1958304064 19.293 98 31 62 0 1977898496 11037360 8557072
19:11:56 10995 8192000000 10937603872 11387076608 1976509008 19.437 99 53 107 0 2002162752 10307808 15345936
19:12:19 10787 8192000000 10922529920 11376889856 1971275744 19.396 99 36 72 1 1991791248 10613888 9901616
19:12:42 43744 8192000000 10932157456 11391029248 1959324368 19.301 98 26 53 2 1979084688 12425872 7334448
19:13:40 115889 8192000000 10923794320 11397345280 1972442976 19.405 99 11 22 1 1996160496 20276832 3440688
19:15:42 105599 8192000000 10882897216 11353649152 1910756992 18.913 96 18 35 1 1929615872 13625984 5232896
19:17:42 37080 8192000000 10886163792 11367190528 1951439024 19.238 99 8 16 0 1964927936 11413136 2075776
19:18:31 52158 8192000000 10890556272 11349508096 1932364880 19.086 98 6 12 0 1943347280 9362448 1619952
19:19:30 84761 8192000000 10884011760 11358416896 1907497856 18.887 97 17 32 0 1920748656 9103824 4146976
19:21:01 44997 8192000000 10893445856 11362672640 1972374832 19.404 100 13 26 1 1986314128 10310496 3628800
19:22:03 64473 8192000000 10860495728 11347972096 1924117600 19.020 98 13 26 0 1936606752 9070336 3418816
19:23:31 48909 8192000000 10854325104 11325120512 1878733920 18.655 96 17 33 2 1894227952 10801840 4692192
19:24:26 40493 8192000000 10878836096 11349143552 1935135360 19.108 99 24 48 0 1954857376 12449456 7272560
19:25:13 46463 8192000000 10837902880 11293241344 1828246208 18.245 94 20 40 0 1849167264 14884288 6036768
19:26:05 59958 8192000000 10846741920 11315400704 1871037248 18.593 97 17 33 1 1889254384 13128032 5089104

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 29-12-2020 19:28:23 to 29-12-2020 19:28:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 122 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-12-2020 19:28:54 to 29-12-2020 19:28:56.

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          239880
MON$OLDEST_ACTIVE               239881
MON$OLDEST_SNAPSHOT             239881
MON$NEXT_TRANSACTION            239881
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                       2003136
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:71: 
:72: mscs-test-161.budzdorov.ru    Tue Dec 29 19:27:18 2020
:73:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:74: 
--- end of diff output ---

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

29.12.20 19:28:57. 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-12-29 19:29:00 No severe PSQL-related problems occured
29.12.20 19:29:01. End of report.