Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 31.03.2021 16:29
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 df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
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.26
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 17248368 kB
MemAvailable 31511144 kB
Buffers 0 kB
Cached 14450840 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-31 16:27:25
DTS_END                         2021-03-31 16:27:25.4980
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(195:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54412
TRN_ID                          239247
ATT_ID                          609
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: 9243.15 19875 1109178
customer order: creation 174.73 343 20967
customer order: refuse 14.27 379 1712
order to supplier: creation 46.78 1210 5613
order to supplier: removal 3.62 93125 434
invoice (draft): creation 47.59 3110 5711
invoice (draft): removal 53.60 732 6432
invoice accept: apply 41.34 16843 4961
invoice accept: cancel 47.84 759 5741
customer reserve: creation 3774.24 167 452909
customer reserve: removal 4732.28 55 567874
realization accept: apply 84.41 186 10129
realization accept: cancel 90.72 119 10886
payment from customer: creation 59.73 133 7167
payment from customer: removal 5.63 95 676
payment to supplier: creation 49.98 146 5998
payment to supplier: removal 3.53 52 424
service: total inventory turnovers 4.60 1151 552
service: total monetary turnovers 7.33 36 879
service: aggregate perf. data 0.91 20051 109
service: refresh index statistics 0.03 258803 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-03-2021 16:29:31 to 31-03-2021 16:29:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2985
TEST_TIME 2 4232
TEST_TIME 3 4483
TEST_TIME 4 4768
TEST_TIME 5 4933
TEST_TIME 6 4953
TEST_TIME 7 4935
TEST_TIME 8 5594
TEST_TIME 9 5807
TEST_TIME 10 6348
TEST_TIME 11 6248
TEST_TIME 12 6425
TEST_TIME 13 6669
TEST_TIME 14 6805
TEST_TIME 15 6950
TEST_TIME 16 7037
TEST_TIME 17 7637
TEST_TIME 18 7788
TEST_TIME 19 8551
TEST_TIME 20 9048
TEST_TIME 21 9112
TEST_TIME 22 9304
TEST_TIME 23 9472
TEST_TIME 24 9722
TEST_TIME 25 9714
TEST_TIME 26 10004
TEST_TIME 27 10414
TEST_TIME 28 10513
TEST_TIME 29 10767
TEST_TIME 30 10802
TEST_TIME 31 10806
TEST_TIME 32 10662
TEST_TIME 33 10521
TEST_TIME 34 10354
TEST_TIME 35 10420
TEST_TIME 36 10331
TEST_TIME 37 10296
TEST_TIME 38 10166
TEST_TIME 39 10113
TEST_TIME 40 10028
TEST_TIME 41 10124
TEST_TIME 42 10203
TEST_TIME 43 10123
TEST_TIME 44 10146
TEST_TIME 45 10087
TEST_TIME 46 10109
TEST_TIME 47 10112
TEST_TIME 48 10068
TEST_TIME 49 9874
TEST_TIME 50 9727
TEST_TIME 51 9787
TEST_TIME 52 9758
TEST_TIME 53 9712
TEST_TIME 54 9665
TEST_TIME 55 9627
TEST_TIME 56 9724
TEST_TIME 57 9608
TEST_TIME 58 9568
TEST_TIME 59 9550
TEST_TIME 60 9651
TEST_TIME 61 9545
TEST_TIME 62 9602
TEST_TIME 63 9601
TEST_TIME 64 9654
TEST_TIME 65 9618
TEST_TIME 66 9720
TEST_TIME 67 9734
TEST_TIME 68 9717
TEST_TIME 69 9686
TEST_TIME 70 9742
TEST_TIME 71 9789
TEST_TIME 72 9802
TEST_TIME 73 9730
TEST_TIME 74 9771
TEST_TIME 75 9762
TEST_TIME 76 9749
TEST_TIME 77 9705
TEST_TIME 78 9654
TEST_TIME 79 9573
TEST_TIME 80 9542
TEST_TIME 81 9534
TEST_TIME 82 9570
TEST_TIME 83 9525
TEST_TIME 84 9496
TEST_TIME 85 9443
TEST_TIME 86 9421
TEST_TIME 87 9427
TEST_TIME 88 9430
TEST_TIME 89 9498
TEST_TIME 90 9467
TEST_TIME 91 9441
TEST_TIME 92 9491
TEST_TIME 93 9490
TEST_TIME 94 9500
TEST_TIME 95 9544
TEST_TIME 96 9551
TEST_TIME 97 9556
TEST_TIME 98 9598
TEST_TIME 99 9588
TEST_TIME 100 9572
TEST_TIME 101 9612
TEST_TIME 102 9598
TEST_TIME 103 9681
TEST_TIME 104 9642
TEST_TIME 105 9588
TEST_TIME 106 9558
TEST_TIME 107 9515
TEST_TIME 108 9451
TEST_TIME 109 9540
TEST_TIME 110 9505
TEST_TIME 111 9476
TEST_TIME 112 9464
TEST_TIME 113 9440
TEST_TIME 114 9397
TEST_TIME 115 9352
TEST_TIME 116 9323
TEST_TIME 117 9335
TEST_TIME 118 9291
TEST_TIME 119 9224
TEST_TIME 120 9246

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 31-03-2021 16:29:34 to 31-03-2021 16:29:38.

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 1530537 1530537 0 0.00 0 28695 6 0 0
doc_list_biud 1530537 1530537 0 0.00 0 159305 26 0 0
sp_add_invoice_to_stock 5035 4961 74 1.46 42 170991 16844 0 74
sp_cancel_adding_invoice 5741 5741 0 0.00 5 57446 759 0 0
sp_cancel_client_order 1712 1712 0 0.00 4 12839 379 0 0
sp_cancel_customer_reserve 567874 567874 0 0.00 1 24205 56 0 0
sp_cancel_pay_from_customer 676 676 0 0.00 2 7106 95 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 3 1063 52 0 0
sp_cancel_supplier_invoice 6435 6432 3 0.04 2 43333 732 0 3
sp_cancel_supplier_order 434 434 0 0.00 5 1033904 93126 0 0
sp_cancel_write_off 10886 10886 0 0.00 1 159320 119 0 0
sp_client_order 20967 20967 0 0.00 3 20421 343 0 0
sp_customer_reserve 452909 452909 0 0.00 0 32821 168 0 0
sp_fill_shopping_cart 32287 32287 0 0.00 1 19301 38 0 0
sp_fill_shopping_cart_clo_res 452900 452900 0 0.00 0 15810 12 0 0
sp_get_clo_for_invoice 4952 4952 0 0.00 0 23589 271 0 0
sp_kill_cost_storno 17727 17727 0 0.00 0 8707 54 0 0
sp_kill_qstorno_ret_qs2qd 1153500 1153500 0 0.00 0 159304 30 0 0
sp_kill_qty_storno 608160 608160 0 0.00 0 159304 65 0 0
sp_lock_selected_doc 20951 20951 0 0.00 0 7944 5 0 0
sp_make_cost_storno 28246 28246 0 0.00 0 26927 55 0 0
sp_multiply_rows_for_pdistr 28246 28246 0 0.00 0 9340 35 0 0
sp_multiply_rows_for_qdistr 20967 20967 0 0.00 0 12872 132 0 0
sp_pay_from_customer 7167 7167 0 0.00 4 15004 133 0 0
sp_pay_to_supplier 5998 5998 0 0.00 5 13946 146 0 0
sp_payment_common 13165 13165 0 0.00 1 13994 32 0 0
sp_qd_handle_on_cancel_clo 1712 1712 0 0.00 0 12829 343 0 0
sp_qd_handle_on_invoice_upd_sts 10693 10693 0 0.00 0 22274 324 0 0
sp_qd_handle_on_reserve_upd_sts 10129 10129 0 0.00 0 18503 70 0 0
sp_reserve_write_off 10129 10129 0 0.00 7 18629 187 0 0
sp_supplier_invoice 5711 5711 0 0.00 6 86926 3111 0 0
sp_supplier_order 5613 5613 0 0.00 6 30725 1210 0 0
srv_aggregate_perf_data 110 109 1 0.90 2658 400680 20052 0 1
srv_fill_mon_cache_memory 158 158 0 0.00 1093 175691 34275 0 0
srv_find_qd_qs_mism 1062219 1062219 0 0.00 0 12015 5 0 0
srv_make_invnt_saldo 552 552 0 0.00 43 83690 1152 0 0
srv_make_money_saldo 879 879 0 0.00 1 6697 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 135037 417126 258803 0 0
t$perf-abend:sp_add_invoice_to_stock 74 74 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 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 4961 4961 0 0.00 0 36595 175 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 1 3695 71 0 0
t$perf-norm:sp_cancel_client_order 1712 1712 0 0.00 0 2689 15 0 0
t$perf-norm:sp_cancel_customer_reserve 713 713 0 0.00 0 11051 32 0 0
t$perf-norm:sp_cancel_pay_from_customer 676 676 0 0.00 0 3157 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 161 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 553 10 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 46541 2211 0 0
t$perf-norm:sp_cancel_write_off 1083 1083 0 0.00 0 5200 14 0 0
t$perf-norm:sp_client_order 20967 20967 0 0.00 0 14025 20 0 0
t$perf-norm:sp_customer_reserve 1011 1011 0 0.00 0 4798 14 0 0
t$perf-norm:sp_pay_from_customer 7167 7167 0 0.00 0 11086 15 0 0
t$perf-norm:sp_pay_to_supplier 5998 5998 0 0.00 0 8176 14 0 0
t$perf-norm:sp_reserve_write_off 10129 10129 0 0.00 0 11716 17 0 0
t$perf-norm:sp_supplier_invoice 5711 5711 0 0.00 0 9452 24 0 0
t$perf-norm:sp_supplier_order 5613 5613 0 0.00 0 11259 20 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 1296 31 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 159 2 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 5106 45 0 0
t$perf-norm:srv_make_money_saldo 879 879 0 0.00 0 2892 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 10038 9890 148 1.47 0 8888 20 0 148
v_all_customers 38452 38452 0 0.00 0 15 1 0 0
v_all_suppliers 31686 31686 0 0.00 0 19 1 0 0
v_all_wares 41934 41934 0 0.00 0 26 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 460 6 0 0
v_cancel_client_order 3424 3424 0 0.00 0 8142 11 0 0
v_cancel_customer_prepayment 1352 1352 0 0.00 0 551 4 0 0
v_cancel_customer_reserve 1426 1426 0 0.00 0 4718 7 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 414 4 0 0
v_cancel_supplier_invoice 878 872 6 0.68 0 2940 16 0 6
v_cancel_supplier_order 868 868 0 0.00 0 470 4 0 0
v_cancel_write_off 2166 2166 0 0.00 0 7382 19 0 0
v_max_id_clo_ord 5613 5613 0 0.00 0 1891 1 0 0
v_max_id_clo_res 1011 1011 0 0.00 0 3649 24 0 0
v_max_id_ord_sup 5707 5707 0 0.00 0 9564 4 0 0
v_max_non_paid_invoice 1475 1475 0 0.00 0 5196 12 0 0
v_max_non_paid_realizn 3614 3614 0 0.00 0 822 4 0 0
v_min_id_clo_ord 5613 5613 0 0.00 0 2926 6 0 0
v_min_id_clo_res 1011 1011 0 0.00 0 12622 18 0 0
v_min_id_ord_sup 5707 5707 0 0.00 0 8801 8 0 0
v_min_non_paid_invoice 5998 5998 0 0.00 0 13931 18 0 0
v_min_non_paid_realizn 7166 7166 0 0.00 0 7367 21 0 0
v_our_firm 10588 10588 0 0.00 0 13 1 0 0
v_reserve_write_off 20258 20258 0 0.00 0 5653 6 0 0
x_lock_depdocs_on_canc_invoice 11737 11737 0 0.00 0 12853 105 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 11172 295 0 0
x_make_qstorno_1000_1200 5613 5613 0 0.00 2 30696 1125 0 0
x_make_qstorno_1200_2000 5711 5711 0 0.00 2 83746 2981 0 0
x_make_qstorno_2100_3300 452909 452909 0 0.00 0 32820 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-03-2021 16:29:39 to 31-03-2021 16:29:43.

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:29 6 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:35 18339 8192000000 10276568832 10587914240 1088048752 11.724 83 61 122 0 1110785184 3013328 19723104
13:58:03 41078 8192000000 10379463264 10700894208 1424183296 14.810 100 85 169 0 1457276480 5799648 27293536
13:58:56 32891 8192000000 10423408240 10750783488 1464886576 15.169 100 91 182 0 1502285792 7974912 29424304
13:59:36 33260 8192000000 10443056736 10777538560 1490882096 15.397 100 89 178 0 1528658768 9141264 28635408
14:00:19 22733 8192000000 10469230320 10803695616 1518541808 15.638 100 93 186 1 1558000560 10132128 29326624
14:00:54 21318 8192000000 10487430128 10827472896 1533676976 15.769 100 86 172 0 1571806688 10928512 27201200
14:01:23 17693 8192000000 10503303216 10849095680 1556586208 15.967 100 87 174 0 1594593856 11229920 26777728
14:01:51 20553 8192000000 10516264720 10865627136 1576516848 16.138 100 87 174 0 1615364288 11752032 27095408
14:02:22 17887 8192000000 10540498208 10895609856 1591347520 16.265 100 82 163 2 1627970160 11771136 24851504
14:02:49 21801 8192000000 10575171216 10930900992 1623757216 16.542 100 82 162 2 1659860816 11763664 24339936
14:03:18 14459 8192000000 10587100688 10945449984 1650229680 16.766 100 83 166 2 1688156784 13489952 24437152
14:03:41 11457 8192000000 10611630928 10974416896 1663341392 16.877 100 79 158 0 1699853520 13755968 22756160
14:04:00 8174 8192000000 10616208688 10983809024 1680007888 17.017 100 81 162 1 1717013152 13521520 23483744
14:04:15 9224 8192000000 10638808192 11008741376 1695794752 17.150 100 80 160 1 1732334272 13353424 23186096
14:04:32 8126 8192000000 10655711952 11028807680 1716760448 17.325 100 84 167 2 1754708512 13978240 23969824
14:04:47 6376 8192000000 10667047360 11041771520 1729205392 17.429 100 81 162 1 1767068624 14499984 23363248
14:05:01 5079 8192000000 10674534608 11053199360 1738348656 17.505 100 81 162 2 1775638512 14422176 22867680
14:05:13 4949 8192000000 10690120400 11063820288 1747498128 17.581 100 73 144 1 1780872576 12895088 20479360
14:05:26 4983 8192000000 10693442784 11077398528 1764987488 17.726 100 75 150 0 1799264976 12969968 21307520
14:05:39 5642 8192000000 10715303712 11093245952 1775842608 17.815 100 80 158 3 1809600976 11512656 22245712
14:05:51 10578 8192000000 10704636192 11094429696 1778942496 17.841 100 71 140 1 1809955952 11723824 19289632
14:06:09 3666 8192000000 10738232336 11119988736 1788103984 17.916 100 80 160 4 1822901184 12450464 22346736
14:06:19 3888 8192000000 10742741536 11126538240 1808066288 18.080 100 81 162 0 1844072256 13091808 22914160
14:06:30 3203 8192000000 10750459264 11135500288 1813900544 18.128 100 81 161 3 1849570736 12839216 22830976
14:06:40 3823 8192000000 10762958448 11151613952 1819795008 18.176 100 79 158 0 1855682224 13135808 22751408
14:06:52 3394 8192000000 10770041936 11157348352 1833002272 18.284 100 83 167 1 1868368032 12456928 22908832
14:07:02 3933 8192000000 10777239088 11165450240 1835477392 18.304 100 85 171 1 1871818752 12244896 24096464
14:07:13 3063 8192000000 10789743888 11178299392 1841570432 18.354 100 85 168 1 1878471648 13082912 23818304
14:07:23 1305 8192000000 10795289584 11179257856 1846748816 18.396 100 86 172 0 1884656256 13730976 24176464
14:07:30 3084 8192000000 10794889648 11184074752 1854238288 18.457 100 90 179 1 1893206576 13796528 25171760
14:07:40 2438 8192000000 10795813936 11185639424 1856837280 18.478 100 88 176 2 1894241472 12579648 24824544
14:07:49 2210 8192000000 10795905616 11187568640 1859499200 18.499 100 88 179 0 1898027056 13124176 25403680
14:07:58 3265 8192000000 10802498272 11194105856 1862268944 18.522 100 82 165 2 1896977280 11903936 22804400
14:08:07 2462 8192000000 10811069184 11199066112 1867736624 18.566 100 83 167 0 1903295984 12030400 23528960
14:08:17 3470 8192000000 10803859840 11200507904 1870357840 18.587 100 89 180 1 1907250336 11643264 25249232
14:08:27 2463 8192000000 10821989728 11210080256 1871890192 18.600 100 95 191 0 1912465616 13071216 27504208
14:08:36 1851 8192000000 10814763472 11205455872 1873880976 18.616 100 90 181 1 1911720592 13125312 24714304
14:08:45 1010 8192000000 10823767184 11212574720 1874330736 18.619 100 92 187 1 1913464384 12640016 26493632
14:08:52 2021 8192000000 10819276112 11209461760 1876903712 18.640 100 91 182 1 1916328560 13451776 25973072
14:09:00 1977 8192000000 10826551712 11219554304 1883190720 18.691 100 91 185 1 1921412640 12416608 25805312
14:09:08 16079 8192000000 10808287984 11214405632 1881359920 18.676 100 59 118 2 1908941184 10777792 16803472
14:09:31 1439 8192000000 10808216512 11216846848 1882867248 18.688 100 65 130 1 1913502560 12990800 17644512
14:09:39 1718 8192000000 10830076576 11223232512 1888118176 18.731 100 82 164 1 1923152720 11740752 23293792
14:09:48 2274 8192000000 10819600320 11223523328 1890372848 18.749 100 76 152 0 1923905856 12170544 21362464
14:09:56 2088 8192000000 10826218272 11224260608 1892069104 18.762 100 77 158 0 1924985552 11057808 21858640
14:10:06 4304 8192000000 10819843264 11229306880 1889198672 18.739 100 65 131 3 1919121104 12166128 17756304
14:10:17 24982 8192000000 10827642160 11227090944 1891880352 18.761 100 71 139 1 1922601696 10195840 20525504
14:10:48 1569 8192000000 10824120784 11234603008 1895067408 18.787 100 74 149 0 1928641280 12237008 21336864
14:11:00 2035 8192000000 10814908080 11230457856 1891941536 18.761 100 56 114 0 1918346544 10346208 16058800
14:11:08 5362 8192000000 10814131344 11227373568 1893342960 18.773 100 45 88 4 1915045856 9581264 12121632
14:11:21 3301 8192000000 10816747280 11238645760 1893394320 18.773 100 42 85 2 1917905024 13588640 10922064
14:11:31 3790 8192000000 10821962736 11238166528 1897273488 18.804 100 43 85 2 1918411904 7907520 13230896
14:11:41 6353 8192000000 10804024160 11232579584 1894192944 18.780 100 26 54 1 1907903344 6807920 6902480
14:11:59 4788 8192000000 10828731792 11239464960 1899880608 18.825 100 47 94 2 1921481344 8163600 13437136
14:12:10 2853 8192000000 10811309120 11239755776 1901559632 18.839 100 46 91 1 1922286192 8415200 12311360
14:12:19 7089 8192000000 10815264192 11236130816 1900144672 18.827 100 42 82 0 1920434928 6894400 13395856
14:12:33 50458 8192000000 10821332432 11246460928 1903654768 18.856 100 36 70 3 1919644912 6091136 9899008
14:13:32 8537 8192000000 10807717232 11242156032 1901000976 18.834 100 27 54 1 1916348992 7366608 7981408
14:13:47 7141 8192000000 10806535456 11243261952 1899432272 18.822 100 22 43 3 1911255920 5609648 6214000
14:14:01 8673 8192000000 10813660592 11249733632 1902550064 18.847 100 23 46 0 1915088320 6228848 6309408
14:14:16 3721 8192000000 10824214784 11250118656 1907155568 18.884 100 31 62 1 1922763824 6665488 8942768
14:14:26 4147 8192000000 10817524320 11241414656 1887728080 18.727 99 27 55 0 1905819728 10703808 7387840
14:14:37 9017 8192000000 10815565536 11252305920 1908053216 18.891 100 30 61 1 1922701360 6640576 8007568
14:14:54 6682 8192000000 10831386752 11256266752 1908629808 18.896 100 34 65 3 1924468208 6499936 9338464
14:15:07 4551 8192000000 10826444400 11255889920 1907126512 18.884 100 18 36 1 1917459712 5570224 4762976
14:15:18 4597 8192000000 10820561184 11247685632 1892592288 18.767 99 38 73 1 1910797728 7628176 10577264
14:15:34 4709 8192000000 10826612656 11257982976 1909740864 18.905 100 31 62 3 1925615744 7141232 8733648
14:15:48 8417 8192000000 10829771840 11260502016 1910476192 18.910 100 21 42 0 1922821968 5928592 6417184
14:16:04 15904 8192000000 10822670816 11256635392 1911759728 18.921 100 23 46 2 1924177552 5912688 6505136
14:16:28 12130 8192000000 10832478576 11263221760 1917247072 18.965 100 38 77 1 1934259936 5602576 11410288
14:16:53 73128 8192000000 10794806800 11226660864 1813694304 18.126 95 23 46 1 1825325680 5212528 6418848
14:18:16 4106 8192000000 10808821552 11240935424 1892260544 18.764 100 37 74 4 1915144272 12176784 10706944
14:18:28 3948 8192000000 10807309632 11223056384 1865819792 18.550 99 47 93 2 1885530864 6473344 13237728
14:18:38 3021 8192000000 10775391392 11195047936 1848858592 18.413 99 45 91 0 1870040240 8347216 12834432
14:18:48 4181 8192000000 10778258336 11208736768 1855824912 18.469 99 35 70 0 1873809200 7545792 10438496
14:18:59 4148 8192000000 10763471344 11191517184 1842713984 18.363 99 38 76 1 1861036816 7500864 10821968
14:19:11 5126 8192000000 10771783936 11190673408 1811113760 18.105 97 40 80 2 1828346848 5849312 11383776
14:19:22 4034 8192000000 10788804864 11211501568 1868778048 18.574 100 40 78 3 1887516656 7284384 11454224
14:19:37 5505 8192000000 10755056288 11175731200 1814394160 18.132 98 27 54 0 1828888752 6401568 8093024
14:19:49 5682 8192000000 10766488608 11185676288 1839460544 18.336 100 30 60 2 1858554784 11036704 8057536
14:20:02 8086 8192000000 10740953296 11156480000 1768168880 17.752 96 19 38 0 1782879792 9380464 5330448
14:20:18 8777 8192000000 10728577568 11149082624 1800675600 18.019 99 21 40 3 1811780000 5171616 5932784
14:20:35 7857 8192000000 10694212432 11104989184 1687985120 17.084 93 25 49 2 1700631888 4783280 7863488
14:20:56 8687 8192000000 10707848816 11117924352 1770330880 17.770 99 27 54 2 1783809824 5584000 7894944
14:21:13 14812 8192000000 10692882448 11103449088 1690997920 17.110 94 28 56 3 1704166992 5288848 7880224
14:21:34 58349 8192000000 10696995472 11107782656 1716412560 17.322 96 31 62 0 1731273152 5973280 8887312
14:22:44 9265 8192000000 10684557984 11096379392 1742474304 17.539 97 20 38 1 1754122320 6328112 5319904
14:23:00 6722 8192000000 10728246784 11143729152 1788544208 17.920 99 24 47 2 1801978000 5839456 7594336
14:23:13 5512 8192000000 10717259488 11138719744 1806750784 18.069 100 20 40 0 1823461072 10691904 6018384
14:23:25 9118 8192000000 10722065584 11136757760 1787777456 17.914 98 30 60 3 1803191264 6603312 8810496
14:23:40 6333 8192000000 10737169232 11154374656 1808557648 18.084 99 22 44 0 1821595424 6304352 6733424
14:23:54 5557 8192000000 10751434512 11167170560 1830627600 18.264 100 25 49 1 1842480464 5114064 6738800
14:24:09 9771 8192000000 10746864064 11170357248 1821659872 18.191 99 16 31 1 1832313584 5723424 4930288
14:24:27 10489 8192000000 10754825360 11184869376 1843078224 18.366 100 14 28 0 1852073616 4981584 4013808
14:24:44 10648 8192000000 10767722992 11192037376 1852330800 18.441 100 32 63 1 1866817488 4993440 9493248
14:25:01 7391 8192000000 10765117360 11192348672 1852635296 18.444 100 26 52 1 1866139408 6040048 7464064
14:25:14 11086 8192000000 10771009680 11197984768 1855406672 18.466 100 33 68 3 1870699184 5528384 9764128
14:25:32 10640 8192000000 10784875568 11202867200 1858721072 18.493 100 17 35 2 1868852496 4825696 5305728
14:25:49 44296 8192000000 10785670864 11211382784 1870542256 18.589 100 29 58 0 1884409472 4973744 8893472
14:27:08 8415 8192000000 10802190400 11228139520 1881013760 18.673 100 23 46 0 1897334096 9342448 6977888
14:27:22 37562 8192000000 10807946960 11227897856 1868689168 18.574 99 23 46 0 1879832608 5082880 6060560
14:28:19 11010 8192000000 10835919456 11252592640 1903339056 18.853 100 47 92 3 1922849264 7394944 12115264
14:28:39 14267 8192000000 10847024384 11263303680 1914681376 18.944 100 58 116 2 1941119184 10623152 15814656
14:29:04 23261 8192000000 10862038240 11275608064 1920402032 18.990 100 47 94 2 1944667328 10839360 13425936
14:29:36 9239 8192000000 10867441728 11282268160 1924840160 19.026 100 61 122 1 1952276928 10495888 16940880
14:29:55 9788 8192000000 10856523520 11281432576 1929036496 19.059 100 54 107 1 1955584560 11171104 15376960
14:30:12 12089 8192000000 10865645280 11287269376 1932414080 19.086 100 52 104 1 1957860608 10523104 14923424
14:30:59 21372 8192000000 10861885200 11295358976 1934743312 19.105 100 35 69 1 1955305408 10390800 10171296
14:31:31 35670 8192000000 10867020256 11304968192 1943534608 19.175 100 38 76 2 1965933904 11293424 11105872
14:32:17 22079 8192000000 10875469424 11309158400 1947170800 19.204 100 36 72 0 1968516912 10435152 10910960
14:32:54 5459 8192000000 10897390160 11317596160 1955992304 19.274 100 51 102 1 1981466688 10525632 14948752
14:33:06 8122 8192000000 10898413760 11320840192 1957840416 19.289 100 49 96 3 1984088128 12167824 14079888
14:33:21 18509 8192000000 10908709680 11332907008 1965485808 19.350 100 62 124 1 1996755760 13824048 17445904
14:33:48 6597 8192000000 10912365616 11337293824 1971292304 19.396 100 61 117 0 2003289488 14761488 17235696
14:34:04 11979 8192000000 10911750544 11343912960 1976217200 19.435 100 51 102 2 2009175440 18614896 14343344
14:34:24 13803 8192000000 10912721440 11338309632 1971234128 19.395 100 60 118 1 2001441440 13834288 16373024
14:34:49 17809 8192000000 10912907744 11346063360 1976753296 19.439 100 47 94 0 2007628768 16265216 14610256
14:35:13 9383 8192000000 10931733120 11358167040 1981056016 19.473 100 56 112 0 2018718096 20623008 17039072
14:35:29 13279 8192000000 10934878016 11355570176 1968244784 19.372 99 66 130 1 2011379536 23206976 19927776
14:35:51 9387 8192000000 10938666624 11364093952 1984161008 19.498 100 63 126 1 2026666480 23282288 19223184
14:36:09 5849 8192000000 10940764384 11366481920 1993408000 19.571 100 68 136 2 2033274688 19468880 20397808
14:36:22 6166 8192000000 10945860176 11369664512 1991581536 19.556 100 63 126 1 2030519728 19633984 19304208
14:36:37 28097 8192000000 10937219920 11377782784 1992533232 19.564 100 54 106 0 2029236352 20285440 16417680
14:37:13 12712 8192000000 10944255280 11385114624 1999700448 19.620 100 53 105 4 2037290896 21791264 15799184
14:37:33 8512 8192000000 10931801712 11370811392 1984776480 19.502 99 48 95 3 2021681296 21158512 15746304
14:37:57 7325 8192000000 10951836176 11387662336 2007365104 19.681 100 58 115 1 2046124928 21736912 17022912
14:38:14 3245 8192000000 10965742656 11397070848 2012053280 19.718 100 64 128 3 2054004976 23255248 18696448
14:38:31 2148 8192000000 10970851904 11399389184 2014780336 19.739 100 69 138 0 2059319440 23776832 20762272
14:38:42 11181 8192000000 10976901360 11407626240 2018692048 19.770 100 59 114 0 2062695440 26675920 17327472
14:39:01 3676 8192000000 10977659472 11414114304 2023326784 19.806 100 61 120 1 2068098080 26721264 18050032
14:39:13 8067 8192000000 10982499632 11412557824 2024653168 19.817 100 68 133 1 2070067232 25339872 20074192
14:39:29 4206 8192000000 10979075520 11409793024 2019334848 19.775 100 69 136 2 2066538240 26248032 20955360
14:39:41 4935 8192000000 10978796096 11415953408 2022330896 19.798 100 66 130 1 2070080800 27367120 20382784
14:39:55 6613 8192000000 10980129776 11411636224 2017909328 19.764 100 65 127 0 2065802560 28101792 19791440
14:40:11 5809 8192000000 10965182768 11404247040 2013293968 19.727 100 69 138 1 2063738112 28829424 21614720
14:40:26 6025 8192000000 10954996208 11381080064 1990848752 19.550 99 66 129 1 2039683584 28882784 19952048
14:40:41 3835 8192000000 10984864464 11407925248 2013224752 19.727 100 81 161 0 2068691744 31452720 24014272
14:40:52 4421 8192000000 10983516560 11410673664 2018623088 19.769 100 74 148 1 2070479392 29765536 22090768
14:41:06 3562 8192000000 10980805056 11411972096 2019380592 19.775 100 69 134 3 2073437136 32736352 21320192
14:41:17 2620 8192000000 10984359136 11411439616 2018882704 19.771 100 81 162 1 2071705392 28666656 24156032
14:41:28 3084 8192000000 10984459632 11414298624 2019648768 19.777 100 68 133 0 2068603968 28803600 20151600
14:41:37 3063 8192000000 10994592224 11415916544 2023057600 19.804 100 80 160 0 2078532528 30981120 24493808
14:41:47 1576 8192000000 10986313664 11409141760 2021538224 19.792 100 88 176 0 2076716224 27864048 27313952
14:41:55 2927 8192000000 11000169680 11418820608 2027219760 19.837 100 91 180 0 2084487968 30055504 27212704
14:42:05 3765 8192000000 11009356000 11425402880 2030162576 19.860 100 87 173 2 2087290352 30584592 26543184
14:42:16 2450 8192000000 11000653664 11419471872 2024775424 19.818 100 84 166 0 2081149248 30547904 25825920
14:42:25 1846 8192000000 10986701088 11403182080 2008202192 19.687 100 88 176 1 2065596960 30941024 26453744
14:42:34 5708 8192000000 10969039488 11395923968 1996422832 19.595 100 73 145 0 2052150336 33645392 22082112
14:42:47 5041 8192000000 10984342736 11410092032 2009898128 19.701 100 74 144 1 2066641632 34119536 22623968
14:43:00 2201 8192000000 10992279568 11414519808 2017046064 19.757 100 80 157 3 2071934464 30898800 23989600
14:43:10 3076 8192000000 10974461440 11394113536 1976607472 19.438 98 86 174 2 2036847584 32900592 27339520
14:43:21 5538 8192000000 10971913152 11389935616 1982202064 19.482 99 86 172 0 2043827792 34503264 27122464
14:43:34 5302 8192000000 10985302160 11405647872 2002813328 19.645 100 79 155 1 2063586752 36196912 24576512
14:43:47 1093 8192000000 10969270384 11384008704 1981101328 19.473 99 78 157 0 2043049728 37140064 24808336
14:43:57 5805 8192000000 10986908432 11408080896 1997428144 19.602 100 83 166 1 2062318768 38785888 26104736
14:44:09 1276 8192000000 10975598416 11392196608 1991566240 19.556 99 90 181 0 2057889280 39085488 27237552
14:44:17 2389 8192000000 10995770560 11414642688 2007691600 19.683 100 84 166 0 2072828256 39443680 25692976
14:44:27 2809 8192000000 10979499088 11391471616 1985677216 19.510 99 77 150 1 2050230912 40488016 24065680
14:44:37 1595 8192000000 10985722784 11400544256 1995662224 19.589 100 89 176 3 2064481632 40775792 28043616
14:44:46 15712 8192000000 10934324896 11382710272 1954624640 19.263 98 43 86 3 2006752448 37799440 14328368
14:45:12 3463 8192000000 10981260512 11403563008 1988432992 19.531 100 57 112 1 2046718096 39872592 18412512
14:45:25 3260 8192000000 11003054672 11422093312 2006135664 19.671 100 85 169 2 2079029008 45309824 27583520
14:45:38 2132 8192000000 10992654304 11415646208 2001586368 19.635 100 81 163 1 2075544608 47673200 26285040
14:45:49 4344 8192000000 10992209216 11415265280 1993184464 19.569 99 83 166 1 2064999984 45758416 26057104
14:46:01 2197 8192000000 10972353584 11400187904 1975547104 19.429 99 75 149 2 2043802480 44002288 24253088
14:46:10 5550 8192000000 10953676128 11390361600 1982535776 19.485 100 52 103 1 2038206656 39726752 15944128
14:46:24 4398 8192000000 10951595408 11385106432 1967905408 19.369 99 62 122 0 2026965088 39330816 19728864
14:46:44 9599 8192000000 10926646144 11371847680 1951703200 19.240 99 38 76 0 2004439088 39811152 12924736
14:47:00 7844 8192000000 10937270592 11388833792 1974361728 19.420 100 38 75 4 2028653168 41741456 12549984
14:47:15 5670 8192000000 10967856752 11401928704 1987992864 19.528 100 56 112 2 2048150736 40546224 19611648
14:47:29 2364 8192000000 10979928624 11401760768 1992715312 19.565 100 79 154 2 2058593360 41910560 23967488
14:47:38 12326 8192000000 10943526320 11390726144 1957787440 19.288 98 40 80 0 2012747968 41267168 13693360
14:47:57 4179 8192000000 10930370608 11370323968 1947490752 19.206 99 37 74 1 1997450528 37819264 12140512
14:48:14 9964 8192000000 10909910800 11352322048 1923213504 19.013 98 33 66 1 1967858480 34022176 10622800
14:48:32 7453 8192000000 10907537280 11342761984 1927445872 19.046 99 40 80 1 1975117456 34504272 13167312
14:48:47 2240 8192000000 10946487136 11369144320 1968329968 19.372 100 80 156 1 2028950592 35235152 25385472
14:48:56 5733 8192000000 10948597584 11379204096 1973559616 19.414 100 70 139 2 2035107664 39247328 22300720
14:49:12 10978 8192000000 10933657120 11372556288 1959749392 19.304 100 36 72 3 2014294000 41753072 12791536
14:49:29 11153 8192000000 10925175232 11373637632 1932214160 19.085 98 42 83 1 1987209936 41518720 13477056
14:49:54 19100 8192000000 10911366176 11356164096 1920408720 18.990 98 36 72 0 1971558272 39133104 12016448
14:50:36 21188 8192000000 10909250368 11351339008 1926020384 19.035 99 27 54 2 1974441968 38518432 9903152
14:51:05 6430 8192000000 10909579024 11339612160 1903139840 18.852 98 58 116 1 1961112704 39771968 18200896
14:51:20 9973 8192000000 10891850160 11329437696 1916583088 18.959 99 32 62 0 1967313552 40651344 10079120
14:51:51 19288 8192000000 10894709872 11348897792 1934960320 19.107 100 23 46 1 1980444720 37700736 7783664
14:52:18 35304 8192000000 10907259936 11352227840 1937659120 19.128 100 23 44 2 1988577968 42592784 8326064
14:53:03 31379 8192000000 10914108592 11375730688 1946942768 19.202 100 22 44 2 2003490576 48850736 7697072
14:53:47 21861 8192000000 10912913088 11365273600 1927036912 19.043 99 20 38 0 1981349504 47634608 6677984
14:54:16 19961 8192000000 10903886704 11357806592 1931391168 19.078 100 18 36 0 1979234640 41231568 6611904
14:54:43 46011 8192000000 10893477120 11340218368 1916804736 18.961 99 26 52 1 1965165664 39790784 8570144
14:55:45 56821 8192000000 10850552976 11320827904 1865888048 18.551 97 10 20 0 1896198320 27117152 3193120
14:57:04 50363 8192000000 10848160480 11320295424 1907721888 18.888 100 11 22 0 1936183888 25214688 3247312
14:58:02 27727 8192000000 10856862400 11337654272 1919822336 18.985 100 5 10 0 1941250144 20257024 1170784
14:58:37 6120 8192000000 10859985632 11341987840 1922139344 19.004 100 5 10 0 1946641632 23501664 1000624
14:58:51 104021 8192000000 10861146960 11313061888 1863743808 18.534 97 12 24 0 1886058768 19178560 3136400
15:00:42 92013 8192000000 10865986640 11316789248 1881877296 18.680 97 24 49 0 1898681184 9613408 7190480
15:02:26 114610 8192000000 10864418448 11327533056 1875752784 18.631 97 7 15 0 1889902688 12362704 1787200
15:05:50 122335 8192000000 10890800528 11344162816 1927654352 19.048 99 12 24 1 1949506144 18272784 3579008
15:07:59 80277 8192000000 10889802864 11363692544 1930421648 19.070 99 15 30 2 1957948848 23156608 4370592
15:10:12 97079 8192000000 10908608912 11385749504 1931458448 19.079 98 7 14 0 1947593664 14092416 2042800
15:12:02 133043 8192000000 10927741264 11396689920 1988939760 19.535 100 12 24 2 2006076032 13653808 3482464
15:14:23 142269 8192000000 10932029888 11391692800 1958671312 19.295 98 15 30 0 1974895072 12157360 4066400
15:17:02 87503 8192000000 10925474160 11395891200 1975022480 19.425 99 32 65 1 1999089872 14307104 9760288
15:18:36 175691 8192000000 10912707888 11378241536 1894689264 18.784 95 40 78 4 1916550016 11088352 10772400
15:21:41 40857 8192000000 10925355184 11390418944 1992386288 19.563 100 24 48 2 2009722352 10517856 6818208
15:22:34 23710 8192000000 10932134368 11394736128 1993139424 19.569 100 41 82 1 2018867440 13372112 12355904
15:23:12 16760 8192000000 10949908640 11405422592 2001149088 19.632 100 56 110 0 2035891760 17166080 17576592
15:23:36 39025 8192000000 10928706208 11411353600 1981098080 19.473 99 16 32 0 1998470704 12855456 4517168
15:24:45 57413 8192000000 10919719776 11404128256 1994901392 19.583 100 23 45 3 2016188176 14539568 6747216
15:25:50 39027 8192000000 10908820736 11381616640 1976024624 19.433 99 7 14 0 1994784736 16365376 2394736
15:26:35 26554 8192000000 10902621984 11393777664 1976377120 19.436 100 20 41 2 2006808144 24464864 5966160
15:27:50 31586 8192000000 10895675184 11360677888 1958789376 19.296 100 10 20 1 1970973088 9585792 2597920
15:28:36 31659 8192000000 10894079248 11369078784 1957517552 19.286 99 18 36 0 1970656864 8779216 4360096
15:29:14 76880 8192000000 10889626832 11362578432 1881818128 18.680 95 13 26 2 1902557504 17547152 3192224
15:30:52 82721 8192000000 10901988544 11373068288 1926228496 19.037 98 11 22 0 1945247040 16110016 2908528
15:32:21 46712 8192000000 10886302528 11352821760 1893018144 18.770 96 17 34 0 1912688768 14499136 5171488
15:33:20 113094 8192000000 10862082192 11345313792 1841039504 18.349 94 8 16 0 1863148448 20069424 2039520
15:35:50 48658 8192000000 10888393984 11342663680 1925404896 19.030 99 27 54 0 1944269792 11596288 7268608
15:36:45 47954 8192000000 10861250624 11336908800 1890964224 18.754 97 29 58 0 1914573856 15099024 8510608
15:37:45 52490 8192000000 10877920848 11354124288 1952005232 19.242 100 29 58 0 1970903456 10633520 8264704
15:38:44 42388 8192000000 10893300432 11368759296 1962861072 19.329 100 15 29 3 1976028496 8345664 4821760
15:39:38 39089 8192000000 10870022336 11325411328 1863583072 18.532 95 31 62 1 1879635376 6996400 9055904
15:40:24 22786 8192000000 10866640896 11312672768 1864141520 18.537 96 44 89 1 1886382768 10297104 11944144
15:41:12 49777 8192000000 10838827824 11302805504 1799159296 18.007 94 30 60 1 1819509632 12181504 8168832
15:42:10 100725 8192000000 10864340672 11344646144 1886566896 18.718 98 31 62 1 1911449808 15990752 8892160
15:43:57 138193 8192000000 10862394848 11329372160 1882030048 18.681 97 27 54 2 1899226736 9783136 7413552
15:46:21 57972 8192000000 10879769216 11334832128 1910022096 18.907 98 39 78 0 1932075152 10740128 11312928
15:47:28 42508 8192000000 10872369168 11335208960 1932615040 19.088 99 42 84 3 1959009744 14487440 11907264
15:48:23 71980 8192000000 10873518592 11354710016 1946600832 19.199 100 20 40 0 1967925568 15410240 5914496
15:49:50 57823 8192000000 10895221952 11352293376 1918634688 18.976 98 22 44 0 1939090512 14278528 6177296
15:50:55 46419 8192000000 10818319664 11293327360 1845650800 18.387 95 21 42 3 1862271056 10014912 6605344
15:52:01 66542 8192000000 10853621632 11324461056 1913478736 18.935 99 17 34 1 1931960048 13277504 5203808
15:53:19 83414 8192000000 10860982256 11339567104 1916974656 18.963 99 13 26 0 1933574208 12915984 3683568
15:54:49 48718 8192000000 10876644368 11353763840 1919873600 18.986 99 8 16 1 1932447104 10487728 2085776
15:55:44 62733 8192000000 10875530240 11357597696 1945872720 19.194 100 14 27 1 1965604400 15702064 4029616
15:56:54 49170 8192000000 10890532480 11351576576 1939617360 19.144 99 19 38 1 1952907072 8585392 4704320
15:57:51 17679 8192000000 10895405008 11361071104 1949489280 19.222 99 37 74 1 1966936576 7799840 9647456
15:58:20 23469 8192000000 10924151936 11383709696 1975678400 19.430 100 39 78 1 1998077632 11904144 10495088
15:58:50 48795 8192000000 10914777840 11389054976 1962922592 19.329 99 22 44 0 1985310944 16030928 6357424
15:59:46 95718 8192000000 10913268096 11388440576 1944094384 19.179 98 10 20 1 1959077488 12264000 2719104
16:01:28 50468 8192000000 10919044048 11393597440 1966768368 19.360 99 18 36 0 1980478528 8694816 5015344
16:02:25 88438 8192000000 10920621296 11388821504 1958646576 19.295 98 24 48 0 1974818448 9242944 6928928
16:04:06 26687 8192000000 10926767952 11397791744 1975174368 19.426 99 30 60 2 1992128032 8298064 8655600
16:04:44 61345 8192000000 10912693216 11397890048 1969303632 19.380 99 17 35 2 1986011440 11467088 5240720
16:05:57 55912 8192000000 10908366096 11387301888 1947846304 19.209 98 10 20 0 1962287952 11392400 3049248
16:06:59 45656 8192000000 10930100768 11395313664 1973174720 19.411 99 31 63 1 1991081600 9906704 8000176
16:07:56 86238 8192000000 10916240288 11405475840 1957771296 19.288 98 25 50 0 1976751840 12405136 6575408
16:09:28 72701 8192000000 10894242304 11369721856 1833470720 18.288 92 13 26 0 1851211360 13900944 3839696
16:10:48 163011 8192000000 10885746496 11363364864 1940505536 19.151 99 14 28 0 1959393840 14908048 3980256
16:13:40 60593 8192000000 10890596656 11375517696 1955937040 19.274 99 15 30 1 1969058240 8914592 4206608
16:15:08 110890 8192000000 10896188304 11401928704 1949121136 19.219 98 12 24 0 1968545408 15507888 3916384
16:17:05 66788 8192000000 10902955600 11380658176 1927731040 19.049 97 15 30 0 1940411936 8372176 4308720
16:18:20 52920 8192000000 10897129072 11382005760 1952038848 19.243 99 12 24 0 1966064928 10362064 3664016
16:19:48 47003 8192000000 10886634688 11372687360 1939060800 19.139 98 13 26 0 1951344416 8179232 4104384
16:20:58 59204 8192000000 10884972464 11363295232 1923070496 19.011 97 20 40 0 1935479104 6613696 5794912
16:22:25 65000 8192000000 10870868224 11360145408 1927733504 19.049 98 17 34 0 1940755152 8342304 4679344
16:24:01 74676 8192000000 10845751072 11326222336 1887516432 18.726 97 12 24 0 1902436800 11575408 3344960
16:25:24 66197 8192000000 10848102336 11326971904 1886469296 18.717 97 8 15 2 1898948288 10091904 2387088
16:26:38 59407 8192000000 9271753728 9553371136 430664160 4.994 23 2 4 0 434150096 3332096 153840

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 31-03-2021 16:29:45 to 31-03-2021 16:30:16.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 74 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 31-03-2021 16:30:17 to 31-03-2021 16:30:19.

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          239094
MON$OLDEST_ACTIVE               239526
MON$OLDEST_SNAPSHOT             239526
MON$NEXT_TRANSACTION            239526
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                       2046368
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:226: 
:227: mscs-test-161.budzdorov.ru    Wed Mar 31 16:27:44 2021
:228:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:229: 
:230: 
:231: mscs-test-161.budzdorov.ru    Wed Mar 31 16:27:50 2021
:232:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:233: 
--- end of diff output ---

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

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