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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-28 16:27:20
DTS_END                         2021-02-28 16:27:20.5610
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/39176
TRN_ID                          242958
ATT_ID                          682
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: 9147.68 24772 1097722
customer order: creation 176.18 360 21141
customer order: refuse 15.11 358 1813
order to supplier: creation 47.84 1222 5741
order to supplier: removal 3.26 104791 391
invoice (draft): creation 46.25 3282 5550
invoice (draft): removal 50.04 854 6005
invoice accept: apply 42.93 17572 5151
invoice accept: cancel 45.95 861 5514
customer reserve: creation 3929.26 174 471511
customer reserve: removal 4480.34 60 537641
realization accept: apply 86.38 177 10366
realization accept: cancel 91.07 113 10928
payment from customer: creation 60.78 131 7294
payment from customer: removal 5.63 84 675
payment to supplier: creation 50.86 134 6103
payment to supplier: removal 3.30 76 396
service: total inventory turnovers 4.80 1052 576
service: total monetary turnovers 6.76 30 811
service: aggregate perf. data 0.93 17495 111
service: refresh index statistics 0.03 346612 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 28-02-2021 16:28:37 to 28-02-2021 16:28:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4770
TEST_TIME 2 4723
TEST_TIME 3 5082
TEST_TIME 4 5073
TEST_TIME 5 5093
TEST_TIME 6 4954
TEST_TIME 7 5266
TEST_TIME 8 5243
TEST_TIME 9 5417
TEST_TIME 10 5639
TEST_TIME 11 5644
TEST_TIME 12 6041
TEST_TIME 13 6787
TEST_TIME 14 6968
TEST_TIME 15 6937
TEST_TIME 16 6957
TEST_TIME 17 7086
TEST_TIME 18 7889
TEST_TIME 19 8161
TEST_TIME 20 8267
TEST_TIME 21 8267
TEST_TIME 22 8380
TEST_TIME 23 8770
TEST_TIME 24 9385
TEST_TIME 25 9854
TEST_TIME 26 10721
TEST_TIME 27 10915
TEST_TIME 28 10757
TEST_TIME 29 10557
TEST_TIME 30 10369
TEST_TIME 31 10268
TEST_TIME 32 10138
TEST_TIME 33 9970
TEST_TIME 34 9927
TEST_TIME 35 9776
TEST_TIME 36 9672
TEST_TIME 37 9716
TEST_TIME 38 9585
TEST_TIME 39 9587
TEST_TIME 40 9556
TEST_TIME 41 9483
TEST_TIME 42 9526
TEST_TIME 43 9475
TEST_TIME 44 9535
TEST_TIME 45 9498
TEST_TIME 46 9412
TEST_TIME 47 9462
TEST_TIME 48 9343
TEST_TIME 49 9287
TEST_TIME 50 9497
TEST_TIME 51 9617
TEST_TIME 52 9577
TEST_TIME 53 9620
TEST_TIME 54 9540
TEST_TIME 55 9412
TEST_TIME 56 9354
TEST_TIME 57 9317
TEST_TIME 58 9290
TEST_TIME 59 9316
TEST_TIME 60 9304
TEST_TIME 61 9255
TEST_TIME 62 9175
TEST_TIME 63 9160
TEST_TIME 64 9100
TEST_TIME 65 9121
TEST_TIME 66 9128
TEST_TIME 67 9090
TEST_TIME 68 9317
TEST_TIME 69 9249
TEST_TIME 70 9278
TEST_TIME 71 9362
TEST_TIME 72 9366
TEST_TIME 73 9293
TEST_TIME 74 9363
TEST_TIME 75 9477
TEST_TIME 76 9496
TEST_TIME 77 9600
TEST_TIME 78 9592
TEST_TIME 79 9576
TEST_TIME 80 9507
TEST_TIME 81 9444
TEST_TIME 82 9421
TEST_TIME 83 9351
TEST_TIME 84 9379
TEST_TIME 85 9424
TEST_TIME 86 9361
TEST_TIME 87 9372
TEST_TIME 88 9290
TEST_TIME 89 9259
TEST_TIME 90 9289
TEST_TIME 91 9323
TEST_TIME 92 9343
TEST_TIME 93 9353
TEST_TIME 94 9327
TEST_TIME 95 9375
TEST_TIME 96 9374
TEST_TIME 97 9394
TEST_TIME 98 9413
TEST_TIME 99 9410
TEST_TIME 100 9384
TEST_TIME 101 9449
TEST_TIME 102 9449
TEST_TIME 103 9495
TEST_TIME 104 9485
TEST_TIME 105 9500
TEST_TIME 106 9412
TEST_TIME 107 9376
TEST_TIME 108 9323
TEST_TIME 109 9339
TEST_TIME 110 9307
TEST_TIME 111 9282
TEST_TIME 112 9250
TEST_TIME 113 9234
TEST_TIME 114 9171
TEST_TIME 115 9156
TEST_TIME 116 9161
TEST_TIME 117 9230
TEST_TIME 118 9222
TEST_TIME 119 9193
TEST_TIME 120 9150

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-02-2021 16:28:41 to 28-02-2021 16:28:44.

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 1533069 1533069 0 0.00 0 20221 6 0 0
doc_list_biud 1533069 1533069 0 0.00 0 61203 27 0 0
sp_add_invoice_to_stock 5235 5151 84 1.60 25 170115 17573 0 84
sp_cancel_adding_invoice 5514 5514 0 0.00 3 77350 861 0 0
sp_cancel_client_order 1813 1813 0 0.00 4 10239 358 0 0
sp_cancel_customer_reserve 537641 537641 0 0.00 1 61205 60 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 2 5145 85 0 0
sp_cancel_pay_to_supplier 396 396 0 0.00 3 4146 77 0 0
sp_cancel_supplier_invoice 6009 6005 4 0.06 2 18056 855 0 4
sp_cancel_supplier_order 391 391 0 0.00 6 1096684 104792 0 0
sp_cancel_write_off 10928 10928 0 0.00 1 43640 114 0 0
sp_client_order 21141 21141 0 0.00 4 46914 360 0 0
sp_customer_reserve 471511 471511 0 0.00 0 62364 174 0 0
sp_fill_shopping_cart 32422 32422 0 0.00 1 33646 41 0 0
sp_fill_shopping_cart_clo_res 471504 471504 0 0.00 0 26374 14 0 0
sp_get_clo_for_invoice 5144 5144 0 0.00 0 35358 295 0 0
sp_kill_cost_storno 17513 17513 0 0.00 0 8205 55 0 0
sp_kill_qstorno_ret_qs2qd 1092606 1092606 0 0.00 0 61200 33 0 0
sp_kill_qty_storno 577802 577802 0 0.00 0 61203 71 0 0
sp_lock_selected_doc 21354 21354 0 0.00 0 8133 6 0 0
sp_make_cost_storno 28907 28907 0 0.00 0 8291 48 0 0
sp_multiply_rows_for_pdistr 28907 28907 0 0.00 0 11588 33 0 0
sp_multiply_rows_for_qdistr 21141 21141 0 0.00 0 11164 152 0 0
sp_pay_from_customer 7294 7294 0 0.00 4 14954 131 0 0
sp_pay_to_supplier 6103 6103 0 0.00 4 11608 135 0 0
sp_payment_common 13397 13397 0 0.00 1 10810 35 0 0
sp_qd_handle_on_cancel_clo 1813 1813 0 0.00 0 10231 324 0 0
sp_qd_handle_on_invoice_upd_sts 10658 10658 0 0.00 0 31936 326 0 0
sp_qd_handle_on_reserve_upd_sts 10366 10366 0 0.00 0 12252 55 0 0
sp_reserve_write_off 10366 10366 0 0.00 6 12290 178 0 0
sp_supplier_invoice 5550 5550 0 0.00 8 116236 3283 0 0
sp_supplier_order 5741 5741 0 0.00 5 38152 1222 0 0
srv_aggregate_perf_data 112 111 1 0.89 2382 144099 17495 0 1
srv_fill_mon_cache_memory 164 164 0 0.00 1599 143737 31602 0 0
srv_find_qd_qs_mism 1048206 1048206 0 0.00 0 20220 5 0 0
srv_make_invnt_saldo 576 576 0 0.00 43 61886 1052 0 0
srv_make_money_saldo 811 811 0 0.00 0 5870 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 156426 597930 346613 0 0
t$perf-abend:sp_add_invoice_to_stock 84 84 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 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 5151 5151 0 0.00 0 9561 163 0 0
t$perf-norm:sp_cancel_adding_invoice 449 449 0 0.00 0 3916 99 0 0
t$perf-norm:sp_cancel_client_order 1813 1813 0 0.00 0 3293 10 0 0
t$perf-norm:sp_cancel_customer_reserve 713 713 0 0.00 0 2071 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 669 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 396 396 0 0.00 0 1869 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 829 13 0 0
t$perf-norm:sp_cancel_supplier_order 391 391 0 0.00 0 29632 1527 0 0
t$perf-norm:sp_cancel_write_off 1005 1005 0 0.00 0 5240 14 0 0
t$perf-norm:sp_client_order 21141 21141 0 0.00 0 10464 19 0 0
t$perf-norm:sp_customer_reserve 971 971 0 0.00 0 2340 8 0 0
t$perf-norm:sp_pay_from_customer 7294 7294 0 0.00 0 4937 10 0 0
t$perf-norm:sp_pay_to_supplier 6103 6103 0 0.00 0 7398 12 0 0
t$perf-norm:sp_reserve_write_off 10366 10366 0 0.00 0 4968 11 0 0
t$perf-norm:sp_supplier_invoice 5550 5550 0 0.00 0 4318 17 0 0
t$perf-norm:sp_supplier_order 5741 5741 0 0.00 0 3200 17 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 39 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 959 9 0 0
t$perf-norm:srv_make_invnt_saldo 576 576 0 0.00 0 776 25 0 0
t$perf-norm:srv_make_money_saldo 811 811 0 0.00 0 1855 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 4 0 0
v_add_invoice_to_stock 10456 10288 168 1.60 0 7158 23 0 168
v_all_customers 38404 38404 0 0.00 0 37 1 0 0
v_all_suppliers 31322 31322 0 0.00 0 110 1 0 0
v_all_wares 42282 42282 0 0.00 0 72 1 0 0
v_cancel_adding_invoice 898 898 0 0.00 0 1468 8 0 0
v_cancel_client_order 3626 3626 0 0.00 0 5250 11 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 4273 15 0 0
v_cancel_customer_reserve 1426 1426 0 0.00 0 7025 12 0 0
v_cancel_payment_to_supplier 792 792 0 0.00 0 4124 11 0 0
v_cancel_supplier_invoice 812 804 8 0.98 0 7250 24 0 8
v_cancel_supplier_order 782 782 0 0.00 0 6975 17 0 0
v_cancel_write_off 2010 2010 0 0.00 0 12151 26 0 0
v_max_id_clo_ord 5739 5739 0 0.00 0 2836 2 0 0
v_max_id_clo_res 971 971 0 0.00 0 4842 18 0 0
v_max_id_ord_sup 5542 5542 0 0.00 0 5636 5 0 0
v_max_non_paid_invoice 1723 1723 0 0.00 0 837 3 0 0
v_max_non_paid_realizn 3861 3861 0 0.00 0 4664 4 0 0
v_min_id_clo_ord 5739 5739 0 0.00 0 1853 6 0 0
v_min_id_clo_res 971 971 0 0.00 0 1746 8 0 0
v_min_id_ord_sup 5542 5542 0 0.00 0 6331 7 0 0
v_min_non_paid_invoice 6103 6103 0 0.00 0 8403 23 0 0
v_min_non_paid_realizn 7294 7294 0 0.00 0 8371 25 0 0
v_our_firm 10744 10744 0 0.00 0 18 1 0 0
v_reserve_write_off 20732 20732 0 0.00 0 12142 9 0 0
x_lock_depdocs_on_canc_invoice 11117 11117 0 0.00 0 19443 122 0 0
x_lock_depdocs_on_canc_sup_ord 391 391 0 0.00 0 11116 381 0 0
x_make_qstorno_1000_1200 5741 5741 0 0.00 1 38127 1140 0 0
x_make_qstorno_1200_2000 5550 5550 0 0.00 3 100141 3135 0 0
x_make_qstorno_2100_3300 471511 471511 0 0.00 0 62362 158 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 28-02-2021 16:28:45 to 28-02-2021 16:28:50.

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
13:57:24 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:30 25099 8192000000 10279786784 10585247744 1024200608 11.113 81 60 118 1 1047514432 2973216 20340608
13:58:05 27324 8192000000 10331410864 10646392832 1388221232 14.490 100 89 178 1 1422561456 4823616 29516608
13:58:39 19070 8192000000 10367370864 10683179008 1411640400 14.699 100 86 172 0 1445236832 5554224 28042208
13:59:06 21178 8192000000 10374831360 10696491008 1435088256 14.906 100 91 182 0 1471385728 6683056 29614416
13:59:44 18523 8192000000 10403655360 10725036032 1453417216 15.068 100 88 176 0 1489220288 7074480 28728592
14:00:13 27461 8192000000 10419987328 10747928576 1477005584 15.275 100 92 184 1 1515047248 8142480 29899184
14:00:54 12319 8192000000 10435238352 10768420864 1493554624 15.420 100 85 171 1 1529618640 8466560 27597456
14:01:14 16988 8192000000 10450482288 10789535744 1512134352 15.582 100 83 166 0 1547694128 8454512 27105264
14:01:40 15075 8192000000 10481178400 10827522048 1538578000 15.811 100 77 154 0 1570988672 8800176 23610496
14:02:04 7918 8192000000 10508984368 10861756416 1572359904 16.103 100 75 151 1 1604015024 9013232 22641888
14:02:20 21821 8192000000 10553990128 10907197440 1597546048 16.318 100 78 156 1 1631083248 9498640 24038560
14:02:58 9357 8192000000 10573467632 10935181312 1634961424 16.637 100 77 154 4 1668436144 9966896 23507824
14:03:15 11723 8192000000 10595361696 10957766656 1652981856 16.790 100 77 154 0 1686375696 10047312 23346528
14:03:34 9782 8192000000 10606568368 10976337920 1674443760 16.971 100 73 146 1 1706099024 9984112 21671152
14:03:50 10501 8192000000 10634074592 11007881216 1695098784 17.144 100 73 146 0 1727079248 11095760 20884704
14:04:09 9018 8192000000 10650433280 11021000704 1716206544 17.321 100 84 168 0 1752312976 11792480 24313952
14:04:27 9676 8192000000 10661677424 11036778496 1724794048 17.392 100 80 160 3 1759971008 12409008 22767952
14:04:47 9088 8192000000 10680261568 11061284864 1740302112 17.521 100 69 138 1 1772435104 12849712 19283280
14:05:03 7027 8192000000 10701577888 11077357568 1761529728 17.697 100 85 171 0 1799539664 13813808 24196128
14:05:19 5159 8192000000 10700686832 11082854400 1765980928 17.734 100 84 168 1 1804352112 14235872 24135312
14:05:30 4809 8192000000 10714600288 11090014208 1768604224 17.755 100 80 160 3 1804341952 13226480 22511248
14:05:42 9501 8192000000 10714675344 11094372352 1778155744 17.834 100 80 161 0 1813977520 13474208 22347568
14:06:01 4813 8192000000 10732331616 11114598400 1780830336 17.856 100 74 148 0 1815101456 14047872 20223248
14:06:12 3472 8192000000 10740643056 11119775744 1796990960 17.989 100 82 166 3 1834432176 14216128 23225088
14:06:23 3398 8192000000 10737774928 11124285440 1801392576 18.025 100 83 167 2 1839130992 13924512 23813904
14:06:34 4020 8192000000 10747977168 11130576896 1807268784 18.074 100 87 174 1 1845578128 14052688 24256656
14:06:46 2315 8192000000 10756293504 11141808128 1813133744 18.122 100 82 164 1 1849671232 13124176 23413312
14:06:56 2912 8192000000 10769640576 11152052224 1824822928 18.217 100 88 176 0 1862677248 12722448 25131872
14:07:05 2833 8192000000 10775355200 11157950464 1837152992 18.318 100 88 176 2 1873081152 11974304 23953856
14:07:15 1679 8192000000 10785151600 11169546240 1840152416 18.342 100 90 179 1 1877687488 11801952 25733120
14:07:23 2635 8192000000 10796165408 11179749376 1850482432 18.426 100 98 196 4 1892331040 13836768 28011840
14:07:33 1996 8192000000 10796244704 11185496064 1852682112 18.444 100 91 182 0 1891507232 13457504 25367616
14:07:42 1793 8192000000 10798315824 11186339840 1856806080 18.477 100 93 189 0 1896075552 13143376 26126096
14:07:50 4220 8192000000 10803115616 11189727232 1860180176 18.505 100 89 183 0 1898480544 12901744 25398624
14:08:01 1622 8192000000 10802903040 11195215872 1865965664 18.552 100 87 174 0 1903644160 12177504 25500992
14:08:10 2030 8192000000 10813423552 11200274432 1864672224 18.541 100 89 177 3 1903512592 13445936 25394432
14:08:20 2560 8192000000 10811921952 11202736128 1868856016 18.575 100 93 186 0 1909976096 13914928 27205152
14:08:29 1427 8192000000 10812790608 11198464000 1868850624 18.575 100 94 188 1 1910150624 14259696 27040304
14:08:38 2466 8192000000 10808202064 11203633152 1869177184 18.578 100 82 164 3 1906428864 13114992 24136688
14:08:47 12255 8192000000 10795155792 11202142208 1866490096 18.556 100 53 108 0 1890761872 9587456 14684320
14:09:06 2040 8192000000 10800425760 11201433600 1872356448 18.603 100 65 130 0 1899727344 8990976 18379920
14:09:14 3598 8192000000 10791788080 11202678784 1873641776 18.614 100 40 80 2 1892966880 8200624 11124480
14:09:24 3777 8192000000 10792130640 11202576384 1871372288 18.595 100 31 62 2 1888518016 8838864 8306864
14:09:36 7079 8192000000 10791737728 11207397376 1873361184 18.611 100 42 84 2 1894261664 9446288 11454192
14:09:49 4208 8192000000 10789315888 11205484544 1872980848 18.608 100 40 80 2 1892126736 8017936 11127952
14:10:02 7794 8192000000 10799885440 11211743232 1873845776 18.615 100 34 68 0 1892216880 8941232 9429872
14:10:19 7520 8192000000 10789454720 11213582336 1876906480 18.640 100 33 67 5 1898507888 12181248 9420160
14:10:32 6186 8192000000 10798335264 11220430848 1879670656 18.662 100 32 64 1 1901588288 12488672 9428960
14:10:45 10260 8192000000 10794414304 11220271104 1883276176 18.692 100 23 46 1 1896597728 7137968 6183584
14:11:01 4933 8192000000 10797409568 11222847488 1886263216 18.716 100 31 64 0 1901077056 6716224 8097616
14:11:12 10484 8192000000 10800557792 11227066368 1888754192 18.736 100 26 53 4 1902143008 5898208 7490608
14:11:34 64017 8192000000 10826261392 11237969920 1893486080 18.774 100 31 61 1 1908865312 4888608 10490624
14:12:50 11227 8192000000 10797194832 11232817152 1890516176 18.750 100 25 50 1 1903691840 6468336 6707328
14:13:11 8542 8192000000 10804981376 11235647488 1893455600 18.774 100 23 43 1 1905576352 5946672 6174080
14:13:26 6029 8192000000 10825593760 11242283008 1894592928 18.783 100 36 71 3 1912456336 7682848 10180560
14:13:38 4287 8192000000 10812185184 11237826560 1893543696 18.774 100 32 62 2 1908718656 6767328 8407632
14:13:50 6512 8192000000 10802559184 11237240832 1891742224 18.760 100 22 43 3 1903303920 5780864 5780832
14:14:03 7944 8192000000 10805615408 11242405888 1897054000 18.803 100 34 68 5 1913125984 6210848 9861136
14:14:18 7690 8192000000 10816020080 11247722496 1898748336 18.816 100 27 54 1 1912796944 6101712 7946896
14:14:32 7844 8192000000 10806866832 11243118592 1899112736 18.819 100 21 42 1 1910828944 5085360 6630848
14:14:48 8357 8192000000 10814364960 11252056064 1902112416 18.843 100 23 45 2 1914060896 5333360 6615120
14:15:03 11263 8192000000 10813065552 11251916800 1904594096 18.863 100 15 30 0 1914292160 5288400 4409664
14:15:22 8807 8192000000 10819214208 11255242752 1908422720 18.894 100 26 52 3 1922368736 5295568 8650448
14:15:37 7233 8192000000 10823284768 11259281408 1907863440 18.889 100 17 35 0 1918010592 5475200 4671952
14:15:54 10688 8192000000 10807332352 11245146112 1886011216 18.714 99 22 45 0 1898263680 5871984 6380480
14:16:12 15251 8192000000 10810330544 11240185856 1848221136 18.408 97 20 40 1 1859578432 5674656 5682640
14:16:34 50467 8192000000 10802958992 11231694848 1845437984 18.385 97 48 96 0 1865123824 5476144 14209696
14:17:30 24237 8192000000 10817080416 11246059520 1857853920 18.486 98 14 26 1 1866393824 4544512 3995392
14:18:06 5839 8192000000 10791464480 11216732160 1830693168 18.265 97 24 48 2 1843791680 6298320 6800192
14:18:18 5600 8192000000 10770118656 11191623680 1823430816 18.206 98 30 61 2 1838735984 6854640 8450528
14:18:30 10636 8192000000 10693787744 11111616512 1672725808 16.956 91 24 48 2 1685407296 5876048 6805440
14:18:49 6013 8192000000 10726169616 11137515520 1771588832 17.780 98 28 55 1 1785641248 6083904 7968512
14:19:08 6030 8192000000 10705572784 11115560960 1709343024 17.263 94 23 46 3 1721604048 5403808 6857216
14:19:26 5692 8192000000 10708450640 11124195328 1793339264 17.959 100 38 75 1 1811105984 7423568 10343152
14:19:40 7642 8192000000 10699631968 11108601856 1730374112 17.439 96 24 46 2 1742316896 5193120 6749664
14:19:53 11204 8192000000 10683447600 11090046976 1709028896 17.261 95 23 46 1 1720722592 5067072 6626624
14:20:13 16291 8192000000 10670734336 11089977344 1638600672 16.668 91 16 32 0 1648647184 5090960 4955552
14:20:38 8084 8192000000 10711143664 11129901056 1780171856 17.851 99 26 52 0 1794205344 6889520 7143968
14:20:53 4898 8192000000 10706243712 11122274304 1776860256 17.824 99 34 68 4 1794174784 6898672 10415856
14:21:09 57966 8192000000 10686341392 11085791232 1706763856 17.242 94 35 70 1 1722606672 5371984 10470832
14:22:14 26654 8192000000 10722885056 11139690496 1780581728 17.854 99 21 42 0 1791666432 5517872 5566832
14:22:47 6117 8192000000 10727453968 11153317888 1820972704 18.186 100 38 74 0 1840535456 8007696 11555056
14:23:03 8570 8192000000 10750470816 11169132544 1814533776 18.133 99 34 67 2 1829132928 4950064 9649088
14:23:18 5986 8192000000 10739704992 11160903680 1813607472 18.125 99 38 76 1 1832268832 8301168 10360192
14:23:32 7688 8192000000 10759645184 11178901504 1838564144 18.329 100 34 67 1 1857571200 9763584 9243472
14:23:46 9063 8192000000 10754565152 11181793280 1841532288 18.353 100 16 32 0 1850941712 5100800 4308624
14:24:02 10774 8192000000 10767202752 11194085376 1854728032 18.461 100 21 42 1 1866900784 6286368 5886384
14:24:19 9146 8192000000 10766976448 11197390848 1854107392 18.455 100 21 42 0 1865895872 5524976 6263504
14:24:39 9555 8192000000 10786272592 11208982528 1864384624 18.539 100 42 84 1 1882908848 6019232 12504992
14:24:56 8265 8192000000 10771758912 11207176192 1869155376 18.577 100 36 72 1 1886169584 5434688 11579520
14:25:10 6722 8192000000 10784118288 11212509184 1869193136 18.578 100 34 68 0 1885494000 5702800 10598064
14:25:23 7222 8192000000 10785921328 11211702272 1866262592 18.554 100 15 30 2 1876166784 6043216 3860976
14:25:38 23936 8192000000 10784065984 11217276928 1868248560 18.570 100 15 29 4 1878220432 6110256 3861616
14:26:10 50381 8192000000 10793265408 11220484096 1877556752 18.645 100 14 28 0 1887546368 5067760 4921856
14:27:12 56094 8192000000 10828931968 11255611392 1894652448 18.783 100 34 69 1 1909776384 5226160 9897776
14:28:32 24611 8192000000 10852544560 11278004224 1919333328 18.982 100 45 90 1 1939846848 8448272 12065248
14:29:04 2414 8192000000 10881311040 11292270592 1934814832 19.105 100 76 153 3 1968186368 10928576 22442960
14:29:14 4170 8192000000 10863275760 11286093824 1933023424 19.091 100 50 99 1 1958739472 11207408 14508640
14:29:25 30750 8192000000 10881177456 11303825408 1939895472 19.146 100 53 106 0 1966340768 11371440 15073856
14:30:07 15454 8192000000 10880629168 11307667456 1945479568 19.190 100 45 90 2 1972625712 14566768 12579376
14:30:29 11428 8192000000 10890505616 11317219328 1953456976 19.254 100 60 119 0 1984599120 14581360 16560784
14:30:52 6840 8192000000 10895521104 11321708544 1954628144 19.263 100 54 108 1 1985273408 14931232 15714032
14:31:19 5985 8192000000 10901085120 11328540672 1958428960 19.294 100 66 132 2 1994313232 16766800 19117472
14:31:36 7427 8192000000 10895463008 11327401984 1960500560 19.310 100 59 117 1 1996054080 18485520 17068000
14:31:54 15639 8192000000 10899012288 11333861376 1963137104 19.331 100 45 90 0 1996248272 19878784 13232384
14:32:24 10322 8192000000 10911406576 11344019456 1971901856 19.401 100 47 93 2 2005586576 20365664 13319056
14:32:57 11503 8192000000 10909966752 11348709376 1974700608 19.423 100 39 78 2 2006092448 19811984 11579856
14:33:18 14011 8192000000 10925588144 11356381184 1980761184 19.471 100 56 113 4 2017879776 20126352 16992240
14:33:41 18558 8192000000 10920318448 11354820608 1978505904 19.453 100 51 95 4 2013612496 20862960 14243632
14:34:08 23102 8192000000 10927190000 11361406976 1982042608 19.481 100 53 106 2 2020841360 22981968 15816784
14:34:46 20935 8192000000 10926975488 11370381312 1983106768 19.489 100 34 68 2 2015183040 21740720 10335552
14:35:19 11444 8192000000 10937661856 11380617216 1992213744 19.561 100 32 63 0 2028598016 26677408 9706864
14:35:38 14657 8192000000 10946127920 11386343424 1996612256 19.596 100 44 85 2 2036992944 27211760 13168928
14:36:01 9653 8192000000 10963802608 11400380416 2006654272 19.675 100 55 110 0 2055042656 31622272 16766112
14:36:24 4363 8192000000 10963427696 11398053888 2005583440 19.667 100 58 115 2 2057168096 34358848 17225808
14:36:38 4010 8192000000 10967670736 11397017600 2005534032 19.666 100 58 115 0 2054961120 31528832 17898256
14:36:51 2155 8192000000 10955822112 11383005184 1995938592 19.591 100 65 130 0 2048011296 32584624 19488080
14:37:03 15674 8192000000 10938355872 11370827776 1977215584 19.443 99 69 134 2 2032009680 34288416 20505680
14:37:27 5717 8192000000 10963408512 11392466944 1998107824 19.608 100 66 131 0 2050540080 32756864 19675392
14:37:41 4269 8192000000 10964016384 11397976064 2001300000 19.633 100 61 122 0 2053394112 33987792 18106320
14:37:55 8987 8192000000 10976710272 11406790656 2006879040 19.677 100 69 136 0 2061608608 34884688 19844880
14:38:12 3036 8192000000 10999147360 11419086848 2014321808 19.736 100 94 182 2 2082216560 41299984 26594768
14:38:25 5089 8192000000 10995137376 11420401664 2016112288 19.750 100 79 159 0 2083050592 42507840 24430464
14:38:46 4822 8192000000 10995525760 11423731712 2019963472 19.780 100 79 157 1 2088084288 44537568 23583248
14:39:05 6792 8192000000 10978441952 11412246528 1981293200 19.475 98 62 124 1 2045345824 44430240 19622384
14:39:22 4933 8192000000 10993017104 11412758528 1993127824 19.569 99 80 162 3 2061425344 45170000 23127520
14:39:34 16465 8192000000 10976771008 11413938176 2004103184 19.655 100 51 102 1 2064300208 44144704 16052320
14:40:01 8579 8192000000 10983201552 11413270528 1994008224 19.575 99 63 124 1 2056594736 43783200 18803312
14:40:16 1783 8192000000 10984435552 11408105472 1997071760 19.600 99 76 151 3 2063957600 44386080 22499760
14:40:28 2805 8192000000 10999826176 11426545664 2018931344 19.772 100 87 173 2 2088589536 43968096 25690096
14:40:38 6989 8192000000 11003427184 11430227968 2004439472 19.658 99 74 148 1 2071931712 45516816 21975424
14:40:51 1888 8192000000 11009570544 11426480128 2019666832 19.778 100 91 181 1 2088233456 41699008 26867616
14:41:01 5755 8192000000 10986573904 11411566592 1997930288 19.606 99 83 163 2 2063491216 41185600 24375328
14:41:14 4434 8192000000 10987328864 11411480576 1993912848 19.575 99 75 150 2 2057687568 40843168 22931552
14:41:27 10605 8192000000 10958830192 11384115200 1977956080 19.449 100 73 144 1 2041554752 41449648 22149024
14:41:46 1598 8192000000 10957653216 11364171776 1967163200 19.363 100 85 169 1 2035076992 42010912 25902880
14:41:54 5131 8192000000 10942274960 11363418112 1953398384 19.254 99 71 139 1 2017762016 42657344 21706288
14:42:06 5897 8192000000 10946212736 11362156544 1952729360 19.248 99 66 132 2 2016256704 43032960 20494384
14:42:20 2158 8192000000 10957265584 11374100480 1972132768 19.402 100 85 169 1 2041273088 43703776 25436544
14:42:30 3993 8192000000 10935669232 11353903104 1932741248 19.089 98 77 152 1 2000557408 44488320 23327840
14:42:42 2911 8192000000 10946022080 11364667392 1935710192 19.113 98 77 154 2 2006029760 46709504 23610064
14:42:56 6974 8192000000 10950007968 11375271936 1964021760 19.338 100 68 136 0 2033442496 48184160 21236576
14:43:11 4992 8192000000 10931763920 11353231360 1919752912 18.985 98 63 126 2 1988517552 49034928 19729712
14:43:24 3281 8192000000 10952062400 11363246080 1955739328 19.272 100 80 161 0 2030852480 50482016 24631136
14:43:35 7668 8192000000 10956592000 11379474432 1967529296 19.366 100 77 154 1 2043363648 51746064 24088288
14:43:51 4246 8192000000 10970685856 11391000576 1977821008 19.447 100 74 146 2 2050332176 50293856 22217312
14:44:08 3343 8192000000 10954668736 11373924352 1956646720 19.279 99 77 154 0 2024900640 43954416 24299504
14:44:18 3944 8192000000 10962590032 11384836096 1977154352 19.442 100 65 128 4 2041623216 44149312 20319552
14:44:37 5273 8192000000 10954550144 11379482624 1962615584 19.327 99 73 145 5 2030930416 45675536 22639296
14:44:53 4557 8192000000 10942771296 11367284736 1959326464 19.301 100 56 110 1 2023438752 46687296 17424992
14:45:03 5771 8192000000 10936051104 11356909568 1952141152 19.244 99 71 142 1 2023227936 48829344 22257440
14:45:21 2295 8192000000 10951203104 11362598912 1949082016 19.219 99 85 168 2 2028259424 52266448 26910960
14:45:31 2362 8192000000 10963342416 11379879936 1967963488 19.369 100 74 148 6 2044531520 52363456 24204576
14:45:43 1888 8192000000 10977536864 11386183680 1972630176 19.406 100 79 156 5 2050208304 53235936 24342192
14:45:51 4358 8192000000 10961082112 11387191296 1972856528 19.408 100 68 131 2 2047440976 53599712 20984736
14:46:07 7614 8192000000 10930403344 11364216832 1950463312 19.230 99 53 106 3 2006620464 38723184 17433968
14:46:25 11405 8192000000 10933518528 11371220992 1963869872 19.337 100 41 82 0 2016318400 38706880 13741648
14:46:48 12165 8192000000 10909701552 11337986048 1914757104 18.945 98 42 80 2 1964647776 37087648 12803024
14:47:21 12487 8192000000 10906580224 11347357696 1945405328 19.190 100 36 72 2 1998543232 40331920 12805984
14:47:41 10946 8192000000 10924732240 11360722944 1955498208 19.270 100 46 94 1 2011248080 41109728 14640144
14:47:59 8907 8192000000 10935361232 11370364928 1967534848 19.366 100 46 91 0 2022133872 39863440 14735584
14:48:16 5015 8192000000 10948442304 11377106944 1972181360 19.403 100 47 96 0 2027737696 40954640 14601696
14:48:29 8341 8192000000 10930303776 11371880448 1966952320 19.361 100 45 90 0 2023401552 41561040 14888192
14:48:50 3424 8192000000 10930210048 11359932416 1950770288 19.233 99 48 95 3 2008723280 41824864 16128128
14:49:02 1947 8192000000 10956415216 11363840000 1952947552 19.250 99 88 177 1 2024214000 43207312 28059136
14:49:10 2531 8192000000 10950078672 11377807360 1970578288 19.390 100 70 141 1 2039954384 46621328 22754768
14:49:26 17353 8192000000 10930624160 11372204032 1931319376 19.077 98 37 74 0 1992985168 48441072 13224720
14:49:52 18467 8192000000 10936610464 11375718400 1950134096 19.228 100 38 76 1 2014042096 50278512 13629488
14:50:18 2865 8192000000 10947061792 11376709632 1960091520 19.307 100 59 118 0 2031938048 52032576 19813952
14:50:27 3231 8192000000 10958434480 11379781632 1960068592 19.307 100 80 160 2 2038650224 51963168 26618464
14:50:44 8856 8192000000 10930200240 11368681472 1951779344 19.241 100 52 102 0 2020069568 50309904 17980320
14:51:14 24202 8192000000 10899244944 11343921152 1915853408 18.954 99 27 54 3 1980071248 54106528 10111312
14:51:45 17348 8192000000 10908204880 11353649152 1930803504 19.073 100 37 74 0 1989903552 46374304 12725744
14:52:10 13096 8192000000 10899493968 11347427328 1918949200 18.978 99 31 62 0 1972565216 42416464 11199552
14:52:40 11184 8192000000 10902991296 11355762688 1939697104 19.144 100 29 57 1 1992013536 41636864 10679568
14:52:57 22676 8192000000 10887537712 11346452480 1915786272 18.953 99 23 46 0 1965294848 41397232 8111344
14:53:29 30797 8192000000 10856301440 11327340544 1910980160 18.915 99 20 40 4 1949410016 31265632 7164224
14:54:48 37411 8192000000 10863499008 11293503488 1903952544 18.858 99 44 86 1 1924199296 7921856 12324896
14:55:32 62688 8192000000 10860730192 11308961792 1921802624 19.001 100 39 78 0 1945899008 12978800 11117584
14:56:43 13827 8192000000 10875697328 11311894528 1912236976 18.925 99 49 97 8 1933495264 8133216 13125072
14:57:08 39024 8192000000 10871724128 11316830208 1935997392 19.115 100 37 74 1 1954290880 8019904 10273584
14:57:54 36239 8192000000 10873389248 11328376832 1930188176 19.068 99 32 64 0 1953469472 14598640 8682656
14:58:37 38950 8192000000 10870847536 11332321280 1946930416 19.202 100 10 20 0 1959281856 9825072 2526368
14:59:32 127785 8192000000 10894188256 11363078144 1930822016 19.073 98 16 32 0 1948233856 13022224 4389616
15:01:46 55463 8192000000 10910053648 11369525248 1976030048 19.433 100 17 34 0 1994896048 14370624 4495376
15:03:38 135926 8192000000 10899975680 11356688384 1946638528 19.200 99 24 48 0 1971489280 17483824 7366928
15:06:01 65497 8192000000 10895662256 11373084672 1976189344 19.435 100 16 32 0 1989254960 9105440 3960176
15:07:19 40766 8192000000 10891098000 11353448448 1895490192 18.790 96 6 12 0 1903586048 6816832 1279024
15:08:07 50129 8192000000 10904560576 11363164160 1966495760 19.358 100 26 52 1 1983845984 9193648 8156576
15:09:05 52044 8192000000 10893735600 11364491264 1965471824 19.350 100 20 40 1 1986056864 14572064 6012976
15:10:03 72766 8192000000 10892926912 11361198080 1934584528 19.104 98 15 30 0 1950069664 11437536 4047600
15:11:31 118992 8192000000 10889914496 11339476992 1830270176 18.262 93 9 18 0 1841513552 8130976 3112400
15:13:38 29719 8192000000 10896912432 11349073920 1923110096 19.012 98 33 67 0 1943659712 11432336 9117280
15:14:15 35380 8192000000 10887377488 11354251264 1937894528 19.130 99 22 44 0 1958277776 14018416 6364832
15:15:00 63532 8192000000 10920347824 11376898048 1955511952 19.270 99 17 34 2 1978114624 17575344 5027328
15:16:10 99956 8192000000 10920306320 11392249856 1982322720 19.483 100 23 46 0 2005990272 17217152 6450400
15:18:15 129151 8192000000 10879438192 11362267136 1853751664 18.453 94 11 22 1 1873616960 17052304 2812992
15:20:38 78449 8192000000 10858024624 11318575104 1911283376 18.917 97 26 52 1 1926992576 7353968 8355232
15:22:52 28507 8192000000 10874956544 11337424896 1903922800 18.858 97 27 53 0 1920033264 8549568 7560896
15:23:30 46800 8192000000 10860109264 11325075456 1901423664 18.838 98 25 50 0 1919358896 11137808 6797424
15:24:23 51883 8192000000 10845663008 11305332736 1865957040 18.552 96 34 68 0 1895601312 19520240 10124032
15:25:52 3965 8192000000 10888798944 11331166208 1936912336 19.122 100 44 88 2 1966712192 17755616 12044240
15:26:14 35038 8192000000 10849791648 11315445760 1900111968 18.827 98 32 63 1 1920147968 10697088 9338912
15:27:10 98688 8192000000 10829929840 11308441600 1862760736 18.526 96 9 18 0 1874749936 9880368 2108832
15:28:55 22045 8192000000 10844922752 11330285568 1928048112 19.051 100 5 10 1 1941296368 11912992 1335264
15:29:36 30299 8192000000 10858592800 11333984256 1929712496 19.065 100 9 18 1 1941623264 10466800 1443968
15:30:17 50586 8192000000 10820057568 11299291136 1817440560 18.157 94 5 10 1 1828059152 9497168 1121424
15:31:14 20157 8192000000 10828403584 11294703616 1863911008 18.535 97 23 44 2 1878847952 8763152 6173792
15:31:40 56178 8192000000 10847754336 11313033216 1868080336 18.569 97 19 38 0 1886832352 12873664 5878352
15:32:43 44808 8192000000 10861600448 11331203072 1892921328 18.769 98 22 44 0 1912734320 13679760 6133232
15:33:36 41294 8192000000 10862065968 11312013312 1802848992 18.037 93 24 48 1 1824028192 13549648 7629552
15:34:25 30847 8192000000 10855562720 11316285440 1902957264 18.850 99 32 64 1 1928513040 16078256 9477520
15:35:09 56643 8192000000 10868632336 11348430848 1928468400 19.055 100 11 22 2 1948375616 15676656 4230560
15:36:16 37963 8192000000 10860880608 11314384896 1887172848 18.723 97 26 52 2 1906079168 10788784 8117536
15:37:00 31608 8192000000 10877715408 11323252736 1912452720 18.926 99 31 62 2 1933892256 11663616 9775920
15:37:41 44969 8192000000 10859173728 11333505024 1919876016 18.986 99 23 46 1 1939057760 12059216 7122528
15:38:33 39449 8192000000 10873014752 11341398016 1923640272 19.016 99 23 47 2 1941931760 12044880 6246608
15:39:22 34099 8192000000 10874971952 11327811584 1899187824 18.820 98 17 34 2 1911884304 7754608 4941872
15:40:04 14916 8192000000 10887557120 11338121216 1941639568 19.160 100 30 60 1 1958278304 8625248 8013488
15:40:26 11229 8192000000 10884387648 11325288448 1913711152 18.936 98 51 101 0 1937313792 9334848 14267792
15:40:43 20406 8192000000 10899329184 11338375168 1933366576 19.094 99 65 130 2 1964797568 13105792 18325200
15:41:13 71436 8192000000 10879784864 11362533376 1923256224 19.013 99 30 60 3 1946428432 15064240 8107968
15:42:51 103851 8192000000 10894095984 11366121472 1905926592 18.874 98 11 22 0 1933348464 24106752 3315120
15:44:59 53124 8192000000 10878227280 11351314432 1905361808 18.869 98 7 14 1 1922749712 15801456 1586448
15:45:58 38227 8192000000 10888392928 11345543168 1929426720 19.062 99 13 26 0 1945086992 12132224 3528048
15:46:59 102895 8192000000 10857495056 11325419520 1895041792 18.786 97 21 42 1 1916099744 14977392 6080560
15:49:03 50647 8192000000 10892417936 11364855808 1955745968 19.272 100 28 56 1 1979482000 15133872 8602160
15:50:07 48998 8192000000 10899540560 11361140736 1955110528 19.267 100 24 47 0 1978080112 16060816 6908768
15:51:02 25941 8192000000 10913770304 11371921408 1961684896 19.319 100 36 71 1 1985974112 14594240 9694976
15:51:50 27649 8192000000 10883608656 11364417536 1959146112 19.299 100 18 36 0 1977330720 13284928 4899680
15:52:24 68806 8192000000 10885534480 11362967552 1952745168 19.248 99 15 30 0 1966695392 9530816 4419408
15:53:39 57219 8192000000 10906554016 11385503744 1976049408 19.433 100 18 36 1 1993866064 12233376 5583280
15:55:54 44255 8192000000 10898788576 11370696704 1952217520 19.244 99 16 33 2 1970219472 13010240 4991712
15:56:45 38519 8192000000 10879701904 11361140736 1935525552 19.111 98 22 44 0 1956093392 14045216 6522624
15:57:30 55473 8192000000 10870238320 11347668992 1899291312 18.821 97 9 18 0 1914401072 11984848 3124912
15:58:52 35602 8192000000 10901313856 11368628224 1975225536 19.427 100 29 58 3 1991597728 9276192 7096000
15:59:39 54597 8192000000 10893076784 11360186368 1933075136 19.091 98 11 22 0 1943516128 7761152 2679840
16:00:39 32772 8192000000 10910305632 11372367872 1955767648 19.272 99 23 46 0 1974297120 12563552 5965920
16:01:18 33952 8192000000 10936523424 11389276160 1982630560 19.486 100 38 75 1 2005383776 12036224 10716992
16:02:01 48906 8192000000 10902719568 11383238656 1946081648 19.195 98 24 48 0 1969465440 16463664 6920128
16:02:57 56521 8192000000 10900926624 11369222144 1952825072 19.249 99 23 44 2 1971807712 11900656 7081984
16:04:29 51476 8192000000 10915202352 11375747072 1962813232 19.328 99 29 58 1 1980439296 10219280 7406784
16:05:35 81203 8192000000 10886390768 11353923584 1875379136 18.628 95 15 30 0 1889440528 9926144 4135248
16:07:08 36777 8192000000 10874023744 11329601536 1929519968 19.063 99 37 73 1 1948996944 9459888 10017088
16:07:57 67441 8192000000 10880182880 11367751680 1939574496 19.143 99 18 36 1 1961305296 16664064 5066736
16:09:11 68724 8192000000 10895318368 11363758080 1945548000 19.191 99 11 22 0 1960992768 12642736 2802032
16:10:31 127983 8192000000 10889888960 11372265472 1886679376 18.719 96 4 8 0 1902287888 14649856 958656
16:12:49 143736 8192000000 10881777104 11350769664 1921678288 19.000 98 11 22 1 1934903472 9481120 3744064
16:15:35 16647 8192000000 10885454512 11350159360 1929701264 19.064 98 26 52 4 1946411776 9430288 7280224
16:15:58 14523 8192000000 10877946992 11338330112 1928702608 19.057 99 37 74 0 1949436352 9868640 10865104
16:16:20 28859 8192000000 10856453456 11336097792 1907034656 18.883 98 14 28 3 1921365856 10343840 3987360
16:16:58 58239 8192000000 10854391664 11339177984 1925440816 19.030 99 14 28 0 1939135584 9672032 4022736
16:18:48 60072 8192000000 10862568064 11343015936 1920947552 18.994 99 17 33 0 1933768448 7837936 4982960
16:19:54 87623 8192000000 10857346544 11335008256 1877307216 18.643 96 13 26 1 1895366960 13588976 4470768
16:22:03 92435 8192000000 10841229792 11321929728 1866096096 18.553 96 23 46 1 1888693056 16195936 6401024
16:23:45 60191 8192000000 10844112176 11324739584 1864978640 18.544 97 12 24 0 1892093280 23203696 3910944
16:25:04 94872 8192000000 10832185792 11299307520 1798439056 18.001 93 13 26 2 1816357440 14324784 3593600
16:27:02 24594 8192000000 9303866464 9584480256 457458576 5.288 24 7 14 0 469113504 9892512 1762416

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 28-02-2021 16:28:51 to 28-02-2021 16:29:23.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 84 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-02-2021 16:29:24 to 28-02-2021 16:29:26.

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          242957
MON$OLDEST_ACTIVE               244190
MON$OLDEST_SNAPSHOT             244190
MON$NEXT_TRANSACTION            244190
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                       2015168
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:414: 
:415: mscs-test-161.budzdorov.ru    Sun Feb 28 16:27:32 2021
:416:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:417: 
:418: 
:419: mscs-test-161.budzdorov.ru    Sun Feb 28 16:27:32 2021
:420:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:421: 
:422: 
:423: mscs-test-161.budzdorov.ru    Sun Feb 28 16:27:44 2021
:424:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:425: 
--- end of diff output ---

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

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