Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.02.2021 22: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 17163040 kB
MemAvailable 31231696 kB
Buffers 0 kB
Cached 14557596 kB
SwapCached 4872 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-08 22:27:17
DTS_END                         2021-02-08 22:27:17.2780
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/43386
TRN_ID                          236687
ATT_ID                          686
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: 9391.53 20965 1126983
customer order: creation 173.57 355 20828
customer order: refuse 14.73 346 1768
order to supplier: creation 45.77 1142 5492
order to supplier: removal 3.40 103632 408
invoice (draft): creation 45.79 3151 5495
invoice (draft): removal 53.19 786 6383
invoice accept: apply 42.60 16328 5112
invoice accept: cancel 48.26 772 5791
customer reserve: creation 3869.44 164 464333
customer reserve: removal 4789.11 58 574693
realization accept: apply 84.79 184 10175
realization accept: cancel 89.98 98 10797
payment from customer: creation 59.93 108 7192
payment from customer: removal 5.71 57 685
payment to supplier: creation 49.41 117 5929
payment to supplier: removal 3.39 118 407
service: total inventory turnovers 5.07 952 608
service: total monetary turnovers 6.51 38 781
service: aggregate perf. data 0.85 15658 102
service: refresh index statistics 0.03 275244 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-02-2021 22:28:55 to 08-02-2021 22:28:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5135
TEST_TIME 2 3377
TEST_TIME 3 5755
TEST_TIME 4 5385
TEST_TIME 5 5501
TEST_TIME 6 5416
TEST_TIME 7 5939
TEST_TIME 8 5911
TEST_TIME 9 5979
TEST_TIME 10 6195
TEST_TIME 11 6560
TEST_TIME 12 6417
TEST_TIME 13 6637
TEST_TIME 14 6719
TEST_TIME 15 7083
TEST_TIME 16 7146
TEST_TIME 17 7475
TEST_TIME 18 7884
TEST_TIME 19 7862
TEST_TIME 20 8108
TEST_TIME 21 8425
TEST_TIME 22 9064
TEST_TIME 23 9310
TEST_TIME 24 9177
TEST_TIME 25 9518
TEST_TIME 26 10551
TEST_TIME 27 11011
TEST_TIME 28 10884
TEST_TIME 29 10712
TEST_TIME 30 10647
TEST_TIME 31 10642
TEST_TIME 32 10530
TEST_TIME 33 10646
TEST_TIME 34 10539
TEST_TIME 35 10268
TEST_TIME 36 10186
TEST_TIME 37 10207
TEST_TIME 38 10051
TEST_TIME 39 10008
TEST_TIME 40 9940
TEST_TIME 41 10017
TEST_TIME 42 9963
TEST_TIME 43 9825
TEST_TIME 44 9867
TEST_TIME 45 9735
TEST_TIME 46 9718
TEST_TIME 47 9627
TEST_TIME 48 9625
TEST_TIME 49 9592
TEST_TIME 50 9514
TEST_TIME 51 9616
TEST_TIME 52 9624
TEST_TIME 53 9617
TEST_TIME 54 9670
TEST_TIME 55 9666
TEST_TIME 56 9607
TEST_TIME 57 9750
TEST_TIME 58 9753
TEST_TIME 59 9850
TEST_TIME 60 9744
TEST_TIME 61 9838
TEST_TIME 62 9943
TEST_TIME 63 9793
TEST_TIME 64 9818
TEST_TIME 65 9749
TEST_TIME 66 9720
TEST_TIME 67 9666
TEST_TIME 68 9655
TEST_TIME 69 9578
TEST_TIME 70 9592
TEST_TIME 71 9533
TEST_TIME 72 9530
TEST_TIME 73 9498
TEST_TIME 74 9476
TEST_TIME 75 9498
TEST_TIME 76 9473
TEST_TIME 77 9535
TEST_TIME 78 9534
TEST_TIME 79 9700
TEST_TIME 80 9761
TEST_TIME 81 9785
TEST_TIME 82 9735
TEST_TIME 83 9742
TEST_TIME 84 9781
TEST_TIME 85 9699
TEST_TIME 86 9621
TEST_TIME 87 9618
TEST_TIME 88 9602
TEST_TIME 89 9579
TEST_TIME 90 9559
TEST_TIME 91 9538
TEST_TIME 92 9513
TEST_TIME 93 9481
TEST_TIME 94 9511
TEST_TIME 95 9494
TEST_TIME 96 9594
TEST_TIME 97 9631
TEST_TIME 98 9598
TEST_TIME 99 9629
TEST_TIME 100 9648
TEST_TIME 101 9647
TEST_TIME 102 9688
TEST_TIME 103 9627
TEST_TIME 104 9688
TEST_TIME 105 9716
TEST_TIME 106 9751
TEST_TIME 107 9675
TEST_TIME 108 9635
TEST_TIME 109 9607
TEST_TIME 110 9591
TEST_TIME 111 9608
TEST_TIME 112 9549
TEST_TIME 113 9509
TEST_TIME 114 9515
TEST_TIME 115 9518
TEST_TIME 116 9470
TEST_TIME 117 9449
TEST_TIME 118 9477
TEST_TIME 119 9469
TEST_TIME 120 9399

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-02-2021 22:28:59 to 08-02-2021 22:29:02.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1557099 1557099 0 0.00 0 16450 6 0 0
doc_list_biud 1557091 1557091 0 0.00 0 42100 27 0 0
sp_add_invoice_to_stock 5278 5112 166 3.14 28 185560 16329 0 166
sp_cancel_adding_invoice 5791 5791 0 0.00 4 61271 773 0 0
sp_cancel_client_order 1768 1768 0 0.00 5 9560 347 0 0
sp_cancel_customer_reserve 574693 574693 0 0.00 1 37673 58 0 0
sp_cancel_pay_from_customer 685 685 0 0.00 3 1961 58 0 0
sp_cancel_pay_to_supplier 407 407 0 0.00 3 12511 119 0 0
sp_cancel_supplier_invoice 6390 6383 7 0.10 2 22922 787 0 7
sp_cancel_supplier_order 408 408 0 0.00 8 995140 103632 0 0
sp_cancel_write_off 10797 10797 0 0.00 1 13978 98 0 0
sp_client_order 20828 20828 0 0.00 4 47684 355 0 0
sp_customer_reserve 464333 464333 0 0.00 0 46316 165 0 0
sp_fill_shopping_cart 31813 31813 0 0.00 1 13674 35 0 0
sp_fill_shopping_cart_clo_res 464324 464324 0 0.00 0 23434 16 0 0
sp_get_clo_for_invoice 5103 5103 0 0.00 0 28074 283 0 0
sp_kill_cost_storno 17680 17680 0 0.00 0 8281 53 0 0
sp_kill_qstorno_ret_qs2qd 1166974 1166974 0 0.00 0 42094 31 0 0
sp_kill_qty_storno 615116 615116 0 0.00 0 42098 68 0 0
sp_lock_selected_doc 21082 21082 0 0.00 0 7759 5 0 0
sp_make_cost_storno 28399 28399 0 0.00 0 16334 58 0 0
sp_multiply_rows_for_pdistr 28397 28397 0 0.00 0 8372 28 0 0
sp_multiply_rows_for_qdistr 20828 20828 0 0.00 0 47421 182 0 0
sp_pay_from_customer 7192 7192 0 0.00 4 15908 108 0 0
sp_pay_to_supplier 5929 5929 0 0.00 5 16166 117 0 0
sp_payment_common 13118 13118 0 0.00 1 15979 30 0 0
sp_qd_handle_on_cancel_clo 1768 1768 0 0.00 0 9552 327 0 0
sp_qd_handle_on_invoice_upd_sts 10894 10894 0 0.00 0 18102 309 0 0
sp_qd_handle_on_reserve_upd_sts 10173 10173 0 0.00 0 16403 56 0 0
sp_reserve_write_off 10175 10175 0 0.00 6 18189 184 0 0
sp_supplier_invoice 5495 5495 0 0.00 6 106694 3151 0 0
sp_supplier_order 5492 5492 0 0.00 5 24418 1143 0 0
srv_aggregate_perf_data 103 102 1 0.97 2710 119524 15658 0 1
srv_fill_mon_cache_memory 160 160 0 0.00 1246 165565 32644 0 0
srv_find_qd_qs_mism 1079005 1079005 0 0.00 0 13836 5 0 0
srv_make_invnt_saldo 608 608 0 0.00 44 54846 953 0 0
srv_make_money_saldo 781 781 0 0.00 0 5811 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 196824 341748 275245 0 0
t$perf-abend:sp_add_invoice_to_stock 166 166 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 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 5112 5112 0 0.00 0 15365 164 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 1 4695 85 0 0
t$perf-norm:sp_cancel_client_order 1768 1768 0 0.00 0 2656 11 0 0
t$perf-norm:sp_cancel_customer_reserve 712 712 0 0.00 0 2864 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 685 685 0 0.00 0 3274 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 407 407 0 0.00 0 446 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 392 392 0 0.00 0 3906 29 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 21798 1587 0 0
t$perf-norm:sp_cancel_write_off 1019 1019 0 0.00 0 3715 16 0 0
t$perf-norm:sp_client_order 20828 20828 0 0.00 0 9721 19 0 0
t$perf-norm:sp_customer_reserve 1067 1067 0 0.00 0 1183 5 0 0
t$perf-norm:sp_pay_from_customer 7192 7192 0 0.00 0 8562 15 0 0
t$perf-norm:sp_pay_to_supplier 5929 5929 0 0.00 0 11690 21 0 0
t$perf-norm:sp_reserve_write_off 10175 10175 0 0.00 0 9082 14 0 0
t$perf-norm:sp_supplier_invoice 5495 5495 0 0.00 0 11355 24 0 0
t$perf-norm:sp_supplier_order 5492 5492 0 0.00 0 12894 18 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 669 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 222 3 0 0
t$perf-norm:srv_make_invnt_saldo 608 608 0 0.00 0 4393 24 0 0
t$perf-norm:srv_make_money_saldo 781 781 0 0.00 0 977 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10536 10204 332 3.15 0 5957 18 0 332
v_all_customers 37692 37692 0 0.00 0 24 1 0 0
v_all_suppliers 30666 30666 0 0.00 0 41 1 0 0
v_all_wares 41652 41652 0 0.00 0 38 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 1911 9 0 0
v_cancel_client_order 3536 3536 0 0.00 0 2981 4 0 0
v_cancel_customer_prepayment 1370 1370 0 0.00 0 1863 5 0 0
v_cancel_customer_reserve 1424 1424 0 0.00 0 1210 3 0 0
v_cancel_payment_to_supplier 814 814 0 0.00 0 6186 13 0 0
v_cancel_supplier_invoice 798 784 14 1.75 0 299 13 0 14
v_cancel_supplier_order 816 816 0 0.00 0 570 5 0 0
v_cancel_write_off 2038 2038 0 0.00 0 3298 14 0 0
v_max_id_clo_ord 5490 5490 0 0.00 0 1777 2 0 0
v_max_id_clo_res 1067 1067 0 0.00 0 11624 30 0 0
v_max_id_ord_sup 5494 5494 0 0.00 0 3668 4 0 0
v_max_non_paid_invoice 1577 1577 0 0.00 0 857 3 0 0
v_max_non_paid_realizn 3873 3873 0 0.00 0 2080 4 0 0
v_min_id_clo_ord 5490 5490 0 0.00 0 1924 6 0 0
v_min_id_clo_res 1067 1067 0 0.00 0 4307 6 0 0
v_min_id_ord_sup 5494 5494 0 0.00 0 7168 7 0 0
v_min_non_paid_invoice 5926 5926 0 0.00 0 11068 17 0 0
v_min_non_paid_realizn 7192 7192 0 0.00 0 15839 19 0 0
v_our_firm 10598 10598 0 0.00 0 14 1 0 0
v_reserve_write_off 20346 20346 0 0.00 0 6249 5 0 0
x_lock_depdocs_on_canc_invoice 11782 11782 0 0.00 0 21153 122 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 18694 373 0 0
x_make_qstorno_1000_1200 5492 5492 0 0.00 2 24404 1058 0 0
x_make_qstorno_1200_2000 5495 5495 0 0.00 4 106613 3035 0 0
x_make_qstorno_2100_3300 464333 464333 0 0.00 0 44139 147 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-02-2021 22:29:03 to 08-02-2021 22:29:07.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:27 12176 8192000000 10200500240 10499493888 882864064 9.728 70 58 114 1 905543904 2481744 20198096
19:57:49 26987 8192000000 10325165632 10638503936 1349617312 14.144 100 82 164 0 1380824960 4437840 26769808
19:58:28 26695 8192000000 10370083680 10693861376 1421437840 14.785 100 84 168 0 1454830160 6319024 27073296
19:59:04 8229 8192000000 10389062080 10714083328 1450462896 15.042 100 89 178 0 1486414896 7193008 28758992
19:59:24 22391 8192000000 10411138208 10740195328 1470294768 15.216 100 92 182 3 1508055760 8153856 29607136
20:00:07 26064 8192000000 10443143968 10775343104 1492897776 15.414 100 89 178 1 1535030064 13454352 28677936
20:00:45 19885 8192000000 10472128784 10807967744 1513730560 15.596 100 85 170 0 1549898160 9265984 26901616
20:01:19 25461 8192000000 10489583472 10829557760 1539157376 15.816 100 85 170 0 1575720224 9925312 26637536
20:01:53 11844 8192000000 10500355232 10846117888 1555508144 15.958 100 81 162 0 1590835072 10431744 24895184
20:02:14 19253 8192000000 10539683744 10888130560 1588315264 16.239 100 83 166 0 1624940048 10385136 26239648
20:02:43 14245 8192000000 10556223664 10910367744 1611592448 16.438 100 81 162 1 1646991920 10840496 24558976
20:03:08 12711 8192000000 10574159104 10934726656 1632982032 16.620 100 73 146 1 1665649280 11042688 21624560
20:03:31 13539 8192000000 10598518576 10961428480 1652857872 16.789 100 75 150 1 1687112592 11978944 22275776
20:03:53 12897 8192000000 10613386688 10981109760 1673582304 16.963 100 72 144 1 1706975440 12128384 21264752
20:04:14 7849 8192000000 10626971328 10995068928 1688457200 17.088 100 74 148 2 1721674512 11819360 21397952
20:04:30 8425 8192000000 10650310592 11019608064 1712273328 17.288 100 79 158 1 1746964400 11631936 23059136
20:04:47 7102 8192000000 10662265680 11036213248 1720748768 17.358 100 79 154 1 1755239792 12502736 21988288
20:05:01 5925 8192000000 10677104032 11050897408 1735843904 17.484 100 73 146 1 1769182960 12724080 20614976
20:05:15 6828 8192000000 10690639744 11064926208 1751132704 17.611 100 80 160 0 1787192720 13012976 23047040
20:05:30 4892 8192000000 10705781360 11080699904 1761864176 17.700 100 85 169 2 1799447664 13265072 24318416
20:05:42 3881 8192000000 10712472080 11092455424 1772455680 17.787 100 79 158 1 1807559600 13114448 21989472
20:05:53 5119 8192000000 10717718064 11096989696 1776396800 17.820 100 85 170 1 1814224784 13756192 24071792
20:06:06 4698 8192000000 10718783088 11098091520 1780270880 17.852 100 76 153 1 1816112112 14071120 21770112
20:06:18 3562 8192000000 10726443328 11105943552 1785957936 17.899 100 85 169 1 1823854656 14186880 23709840
20:06:29 6587 8192000000 10729218752 11118198784 1788537728 17.920 100 75 150 0 1823258896 13879760 20841408
20:06:44 4960 8192000000 10749409600 11133915136 1809386736 18.091 100 77 153 1 1848000352 17004528 21609088
20:06:55 2503 8192000000 10753211856 11138215936 1817559520 18.158 100 76 152 0 1852952704 13479456 21913728
20:07:05 2134 8192000000 10758155472 11143761920 1821799632 18.192 100 79 159 2 1856083520 11913696 22370192
20:07:13 4097 8192000000 10770400080 11150663680 1828051824 18.243 100 88 173 1 1865852288 12997744 24802720
20:07:25 2778 8192000000 10768574480 11154341888 1831577472 18.272 100 84 167 2 1866996000 12329392 23089136
20:07:34 3009 8192000000 10775158512 11161882624 1835825888 18.307 100 91 180 4 1874887872 13751632 25310352
20:07:44 3740 8192000000 10788085536 11172179968 1842974976 18.365 100 87 174 2 1880755568 13840768 23939824
20:07:54 2148 8192000000 10791731328 11173130240 1845151760 18.383 100 91 179 1 1884456480 13865104 25439616
20:08:03 2090 8192000000 10791067184 11174891520 1850368464 18.425 100 85 170 0 1887233008 12556240 24308304
20:08:12 3022 8192000000 10785331152 11177713664 1846502576 18.394 100 73 147 0 1880277424 13274496 20500352
20:08:23 3324 8192000000 10792090240 11176939520 1854522464 18.459 100 92 185 2 1893205072 12306192 26376416
20:08:32 2942 8192000000 10800907904 11187924992 1854493632 18.459 100 92 184 2 1893628784 12863344 26271808
20:08:42 1468 8192000000 10806503248 11189571584 1857825296 18.486 100 94 188 0 1897468496 12821872 26821328
20:08:51 1451 8192000000 10800912496 11185328128 1859114192 18.496 100 93 184 3 1899121904 12597184 27410528
20:08:59 1202 8192000000 10806903776 11191377920 1861489696 18.515 100 92 184 2 1899931056 13414576 25026784
20:09:06 2100 8192000000 10810300304 11196055552 1864430096 18.539 100 91 183 1 1903568992 13073904 26064992
20:09:15 1863 8192000000 10812198688 11195596800 1865030544 18.544 100 92 186 1 1904284464 12896608 26357312
20:09:24 1752 8192000000 10807493968 11193757696 1867994560 18.568 100 89 178 0 1906858704 13856176 25007968
20:09:32 25518 8192000000 10796547760 11195678720 1867343168 18.563 100 57 110 1 1891487360 8434496 15709696
20:10:04 23524 8192000000 10818430240 11210153984 1875227920 18.627 100 74 148 3 1905230624 9513024 20489680
20:10:34 2082 8192000000 10823621856 11218563072 1881868768 18.680 100 90 178 3 1917830832 11168240 24793824
20:10:42 1623 8192000000 10823602448 11217330176 1884584720 18.702 100 93 184 0 1923061200 12690688 25785792
20:10:51 5743 8192000000 10821454992 11222937600 1884281104 18.700 100 78 154 1 1918291968 12935904 21074960
20:11:04 2539 8192000000 10817160976 11223207936 1883788640 18.696 100 78 156 1 1918642640 13202320 21651680
20:11:22 3002 8192000000 10788072560 11215679488 1876819488 18.639 100 38 74 1 1900550224 12831824 10898912
20:11:32 3103 8192000000 10807491232 11212660736 1881679120 18.679 100 53 104 3 1902688624 6059872 14949632
20:11:42 4356 8192000000 10803300992 11219255296 1880667792 18.670 100 44 89 1 1905680256 13431168 11581296
20:11:53 5099 8192000000 10805758192 11221078016 1880977552 18.673 100 43 86 1 1902898944 9281648 12639744
20:12:06 5427 8192000000 10803561232 11224739840 1887215536 18.723 100 49 95 2 1910199456 9688032 13295888
20:12:20 2652 8192000000 10828703504 11227729920 1891150176 18.755 100 47 94 2 1911858256 7852608 12855472
20:12:30 6020 8192000000 10806401760 11223470080 1889023280 18.738 100 31 62 2 1906430752 5529008 11878464
20:12:44 4287 8192000000 10807557776 11229663232 1893842848 18.777 100 31 62 1 1909439280 6527840 9068592
20:13:00 8389 8192000000 10803248912 11231350784 1893889248 18.777 100 23 44 0 1905554352 5076528 6588576
20:13:17 6701 8192000000 10804433056 11234267136 1897208736 18.804 100 26 52 1 1910470496 6022736 7239024
20:13:30 7091 8192000000 10813113536 11236114432 1899061296 18.819 100 34 67 2 1915499952 6234432 10204224
20:13:43 9742 8192000000 10813301168 11244183552 1896466768 18.798 100 21 43 0 1912300032 10172064 5661200
20:13:59 9891 8192000000 10802424512 11235438592 1899992080 18.826 100 14 28 1 1910710896 5365888 5352928
20:14:18 4551 8192000000 10806312768 11239280640 1902333216 18.845 100 27 54 3 1921233392 11168752 7731424
20:14:32 71166 8192000000 10832473440 11252838400 1906411072 18.878 100 34 68 2 1921600320 5124576 10064672
20:15:50 4435 8192000000 10832310432 11260866560 1912328416 18.925 100 51 102 2 1936673488 9733680 14611392
20:16:05 6405 8192000000 10820713696 11256827904 1907375920 18.886 100 27 53 1 1926270048 11074336 7819792
20:16:17 6388 8192000000 10827690864 11257024512 1911704272 18.920 100 44 86 2 1930568672 6335728 12528672
20:16:31 10675 8192000000 10833251968 11251335168 1890815648 18.752 99 35 70 1 1907598240 7216400 9566192
20:16:48 4202 8192000000 10821481824 11247730688 1887111808 18.722 99 31 62 3 1903829088 8016464 8700816
20:16:59 6265 8192000000 10818705120 11242041344 1884561200 18.702 99 34 68 1 1900202816 6048656 9592960
20:17:13 6641 8192000000 10798927520 11213475840 1820396000 18.181 96 28 54 1 1834319168 5123904 8799264
20:17:26 6234 8192000000 10800889792 11228815360 1883793008 18.696 100 31 60 0 1899231888 7285648 8153232
20:17:43 6688 8192000000 10797037120 11230105600 1870277280 18.587 99 25 50 0 1883567376 5953424 7336672
20:18:01 12700 8192000000 10801195920 11236802560 1892077344 18.763 100 16 32 2 1902116560 5166576 4872640
20:18:20 9792 8192000000 10776380368 11198918656 1800902336 18.021 95 18 36 4 1811119184 4636096 5580752
20:18:37 52086 8192000000 10789669568 11195334656 1805747536 18.061 96 58 116 0 1829181440 6244832 17189072
20:19:38 11619 8192000000 10751604192 11169964032 1759215920 17.678 95 15 30 0 1768735152 5052224 4467008
20:19:58 3716 8192000000 10787238752 11181989888 1829520496 18.255 99 46 93 0 1852543664 10902464 12120704
20:20:08 5090 8192000000 10733060688 11138383872 1755633312 17.648 96 34 68 0 1773533392 7914496 9985584
20:20:19 7010 8192000000 10714092032 11138113536 1748728688 17.591 96 26 51 3 1762108064 5775040 7604336
20:20:33 5743 8192000000 10708427888 11110752256 1755512016 17.647 97 27 55 1 1769053328 6377600 7163712
20:20:45 6192 8192000000 10724756400 11144765440 1796478160 17.985 99 33 67 1 1812250992 5771488 10001344
20:20:59 6441 8192000000 10714233104 11134173184 1765887424 17.733 97 40 79 0 1784416192 6260944 12267824
20:21:14 4456 8192000000 10739638576 11145129984 1793491584 17.960 99 40 78 2 1810382096 4983744 11906768
20:21:27 9790 8192000000 10727479680 11140116480 1772488176 17.788 98 20 40 1 1784238288 5777344 5972768
20:21:43 8243 8192000000 10717391408 11141709824 1795997584 17.981 99 22 44 3 1807615728 5303360 6314784
20:21:57 5776 8192000000 10718693168 11136274432 1799843792 18.013 99 29 58 1 1814673536 5929280 8900464
20:22:09 9626 8192000000 10721381648 11135991808 1756674944 17.657 97 26 52 1 1770379008 5532016 8172048
20:22:25 6479 8192000000 10731122016 11143770112 1792556816 17.953 99 33 64 0 1808246336 6075424 9614096
20:22:40 9357 8192000000 10736632992 11154182144 1812056304 18.113 100 21 42 3 1827742080 9605232 6080544
20:22:55 59301 8192000000 10744270128 11150778368 1774881904 17.807 97 42 84 2 1796417488 9689600 11845984
20:24:04 15322 8192000000 10717669520 11136364544 1788830512 17.922 99 17 34 1 1799004320 5797904 4375904
20:24:26 6839 8192000000 10732427248 11151925248 1816850688 18.152 100 32 64 2 1833119552 7733952 8534912
20:24:40 6511 8192000000 10757734448 11174473728 1830482512 18.263 100 48 97 1 1856393040 12268848 13641680
20:24:55 5892 8192000000 10761043040 11175034880 1838672752 18.330 100 42 84 1 1856511600 6331712 11507136
20:25:09 9461 8192000000 10769683520 11184578560 1839943504 18.340 100 23 45 3 1852812800 6095264 6774032
20:25:25 5059 8192000000 10751692496 11178946560 1841560272 18.354 100 27 53 4 1854588592 5345424 7682896
20:25:39 5998 8192000000 10749325392 11172601856 1835982608 18.308 100 25 50 3 1848364016 4946080 7435328
20:25:53 9790 8192000000 10759679296 11183554560 1839739744 18.339 100 14 28 0 1849834624 5598544 4496336
20:26:09 7294 8192000000 10765860208 11191803904 1850192544 18.424 100 25 50 1 1862726800 5076496 7457760
20:26:24 8004 8192000000 10758631360 11194744832 1854689456 18.460 100 19 36 1 1866690976 6572368 5429152
20:26:39 12336 8192000000 10773226096 11198074880 1854231376 18.456 100 17 33 1 1864062208 5051584 4779248
20:26:58 14037 8192000000 10794769680 11218124800 1869749296 18.582 100 18 36 0 1880294720 4973840 5571584
20:27:18 42480 8192000000 10819783520 11235008512 1884844784 18.704 100 30 60 1 1901204064 7678576 8680704
20:28:08 10259 8192000000 10832694976 11247853568 1898167520 18.812 100 46 92 1 1920757280 9621712 12968048
20:28:26 70168 8192000000 10854552624 11276308480 1911514624 18.919 100 51 100 1 1936118800 10589712 14014464
20:30:39 34710 8192000000 10851164336 11293147136 1922255392 19.005 100 18 36 1 1945095088 17315504 5524192
20:31:21 12371 8192000000 10856048128 11295272960 1931622272 19.080 100 33 66 0 1955297376 12824512 10850592
20:31:41 14140 8192000000 10871818336 11302039552 1938455408 19.134 100 33 66 1 1960714768 12963856 9295504
20:32:03 27035 8192000000 10874995104 11309740032 1942976736 19.171 100 46 92 3 1970561584 14812352 12772496
20:33:46 31746 8192000000 10908834784 11341156352 1958832992 19.297 100 35 70 0 1987289696 18221648 10235056
20:34:37 5780 8192000000 10907889488 11340066816 1969298000 19.380 100 45 90 0 1998851504 16386512 13166992
20:34:50 2844 8192000000 10913186800 11344437248 1974227184 19.419 100 59 117 1 2006208848 13995920 17985744
20:35:00 3524 8192000000 10915933760 11343593472 1976707280 19.439 100 58 113 1 2007963600 14454848 16801472
20:35:11 2543 8192000000 10927859904 11353268224 1982139488 19.482 100 66 132 1 2017375968 15365728 19870752
20:35:26 15791 8192000000 10930497024 11358109696 1984316976 19.499 100 57 111 0 2017811120 16835248 16658896
20:35:53 8407 8192000000 10934293568 11368329216 1988894640 19.535 100 54 108 0 2024061872 18712096 16455136
20:36:09 5774 8192000000 10937326336 11369230336 1990147632 19.545 100 57 113 0 2026335312 19688752 16498928
20:36:22 4337 8192000000 10954175408 11375955968 1993430192 19.571 100 67 133 0 2034578224 20902368 20245664
20:36:37 9682 8192000000 10944067440 11375763456 1994474528 19.579 100 58 115 1 2033103456 21468432 17160496
20:37:01 22169 8192000000 10964835216 11402399744 2001890368 19.638 100 57 113 1 2041310848 22737712 16682768
20:37:32 3942 8192000000 10956782352 11378454528 1969872720 19.384 98 55 108 2 2009477344 23107328 16497296
20:37:44 1926 8192000000 10971098080 11392360448 2005269728 19.664 100 75 149 0 2052628096 24702992 22655376
20:37:55 2384 8192000000 10968468192 11390300160 2008996384 19.694 100 79 158 1 2059760768 26449600 24314784
20:38:09 4651 8192000000 10953408320 11377102848 1987146064 19.521 99 70 139 1 2036885680 29179072 20560544
20:38:20 7841 8192000000 10962200272 11384848384 2002745584 19.644 100 71 143 1 2050239008 26204544 21288880
20:38:35 9115 8192000000 10958459344 11387297792 1998772160 19.613 100 67 132 1 2047730272 28552480 20405632
20:38:52 4090 8192000000 10961474464 11391918080 2003264192 19.648 100 60 117 0 2049011808 27411152 18336464
20:39:03 6512 8192000000 10977387952 11399110656 2009171280 19.695 100 70 140 0 2057230480 26467008 21592192
20:39:19 12159 8192000000 10978643440 11406823424 2014402192 19.736 100 67 132 1 2063288448 28799488 20086768
20:39:43 9778 8192000000 10977501616 11413340160 2017863408 19.763 100 61 122 1 2068541264 31970560 18707296
20:40:05 5997 8192000000 10974005600 11418771456 2003509552 19.650 99 48 94 0 2048438160 30628144 14300464
20:40:19 3109 8192000000 10984060192 11415375872 2016421920 19.752 100 63 126 2 2066778944 31067088 19289936
20:40:29 1539 8192000000 10984716608 11406290944 2002268832 19.641 99 84 168 2 2060848112 32551584 26027696
20:40:37 2032 8192000000 11005585296 11422953472 2021490560 19.792 100 87 174 1 2081389968 33328624 26570784
20:40:46 4498 8192000000 10991784448 11411431424 2013969376 19.733 100 69 136 0 2069346960 34478800 20898784
20:40:59 9338 8192000000 10984536432 11411771392 2012273584 19.719 100 77 154 0 2072572368 36745120 23553664
20:41:16 2291 8192000000 10991255488 11415461888 2016232256 19.751 100 77 153 1 2076310976 36816848 23261872
20:41:26 1506 8192000000 10963261408 11385249792 1962594704 19.327 97 79 156 1 2023392752 36902416 23895632
20:41:38 3101 8192000000 10970028512 11390103552 1990409104 19.547 99 80 160 1 2052693008 37947056 24336848
20:41:48 3622 8192000000 10998556544 11412426752 2005271984 19.664 100 89 177 0 2071512080 39700800 26539296
20:41:58 12484 8192000000 10980044464 11408138240 2003833056 19.653 100 68 136 3 2064371984 40135392 20403536
20:42:27 2345 8192000000 10974638832 11395395584 1993141296 19.569 100 81 162 0 2059360256 41094160 25124800
20:42:37 1924 8192000000 10991695520 11407572992 2000531120 19.627 100 84 167 0 2069880224 43329248 26019856
20:42:45 5710 8192000000 10980072128 11410345984 2001765808 19.637 100 76 149 0 2066633760 41750352 23117600
20:43:00 1243 8192000000 11003615248 11421433856 2017736832 19.762 100 86 172 0 2085557072 41268592 26551648
20:43:09 1766 8192000000 11010221040 11423490048 2005031728 19.662 99 85 168 3 2073055568 42298784 25725056
20:43:18 3992 8192000000 10995617168 11421138944 2013074336 19.726 100 71 141 0 2076626544 41918480 21633728
20:43:29 1927 8192000000 11001855840 11421560832 2014663872 19.738 100 84 167 0 2085146272 43734688 26747712
20:43:39 5809 8192000000 10994700480 11421990912 2012662432 19.722 100 77 149 2 2081166144 44516016 23987696
20:43:52 10402 8192000000 10997653696 11427049472 2015344544 19.744 100 62 122 0 2081175968 46059376 19772048
20:44:10 5237 8192000000 11003341776 11428020224 2001508272 19.635 99 68 136 0 2070854720 47011040 22335408
20:44:23 5474 8192000000 11000998688 11433263104 2015717552 19.746 100 67 133 2 2085328224 47799264 21811408
20:44:37 1969 8192000000 10987426032 11411017728 1997785520 19.605 100 80 159 0 2069763840 47404432 24573888
20:44:47 1341 8192000000 10990532800 11403456512 1991190016 19.553 100 88 171 1 2067859808 48659184 28010608
20:44:56 1431 8192000000 10994169392 11409498112 1999515424 19.619 100 86 170 5 2074978576 49352720 26110432
20:45:05 1682 8192000000 10996945584 11418660864 2006821344 19.676 100 85 171 0 2083264976 49767872 26675760
20:45:13 9680 8192000000 10962258832 11411918848 1980942656 19.472 99 46 92 1 2045262592 48995328 15324608
20:45:35 8149 8192000000 10959135456 11397021696 1976023824 19.433 99 40 80 1 2030220880 41207408 12989648
20:45:50 5772 8192000000 10938231600 11362525184 1943581216 19.175 98 66 128 3 2004650752 41983936 19085600
20:46:02 6306 8192000000 10958096736 11388899328 1979995376 19.465 100 61 118 1 2042241088 43619920 18625792
20:46:16 2877 8192000000 10976525440 11392794624 1987792544 19.526 100 85 171 1 2060218496 45340704 27085248
20:46:26 1865 8192000000 10986312576 11396194304 1986866416 19.519 100 90 178 0 2062355984 47974464 27515104
20:46:36 3748 8192000000 10973263072 11409219584 1992956704 19.567 100 56 112 0 2059796144 48986736 17852704
20:46:47 9388 8192000000 10957042224 11392131072 1953444624 19.254 98 44 87 0 2016699072 48606528 14647920
20:47:04 5378 8192000000 10965538240 11400663040 1983196112 19.490 100 49 96 0 2049820800 50049056 16575632
20:47:17 1483 8192000000 10988237328 11413549056 1996749616 19.597 100 67 129 1 2068534128 51845328 19939184
20:47:26 3633 8192000000 11012912656 11429441536 2006721856 19.676 100 84 165 4 2088778208 54954576 27101776
20:47:43 5291 8192000000 10990867168 11421478912 1997584192 19.604 100 54 106 0 2072192752 56252256 18356304
20:48:02 4809 8192000000 10995036624 11429539840 2004297968 19.657 100 57 115 2 2078561344 55615792 18647584
20:48:15 9232 8192000000 10985508048 11429466112 2002360224 19.641 100 39 78 1 2073174448 57438896 13375328
20:48:31 4644 8192000000 10972360144 11398062080 1976696352 19.439 99 58 116 3 2051384080 55440480 19247248
20:48:42 4666 8192000000 10995880464 11427778560 1998391968 19.610 100 65 130 2 2077549232 57730896 21426368
20:49:18 26833 8192000000 10956836272 11413737472 1976816752 19.439 100 25 50 1 2040463504 54412576 9234176
20:49:51 25498 8192000000 10941669840 11392053248 1958233824 19.292 99 23 44 2 2013873488 47757712 7881952
20:50:37 27303 8192000000 10918801168 11372969984 1945697344 19.192 99 27 54 0 1998555824 43502080 9356400
20:51:26 8657 8192000000 10929771936 11378094080 1958837136 19.297 100 38 75 2 2014860608 44519376 11504096
20:51:46 10043 8192000000 10917900848 11363954688 1948742464 19.216 100 29 58 0 2006639920 47699296 10198160
20:52:03 13051 8192000000 10925968240 11374489600 1950700944 19.232 100 30 60 2 2014464400 52951200 10812256
20:52:39 31936 8192000000 10913034432 11370364928 1908641024 18.896 98 19 38 1 1961519008 45207056 7670928
20:53:27 16581 8192000000 10896181136 11356344320 1937763056 19.129 100 19 38 0 1985313344 40228272 7322016
20:53:50 56530 8192000000 10877918176 11353096192 1895057616 18.787 98 15 29 0 1933739200 33483984 5197600
20:54:53 34646 8192000000 10867448960 11313111040 1890278784 18.748 98 14 28 0 1904290496 10321056 3690656
20:55:43 48531 8192000000 10835524112 11293736960 1878376128 18.652 97 12 26 0 1890859296 8798528 3684640
20:56:45 40233 8192000000 10883905232 11328425984 1922704080 19.008 99 32 64 0 1942627648 10825536 9098032
20:57:49 28949 8192000000 10888264224 11339243520 1953461008 19.254 100 32 64 1 1971944000 9973312 8509680
20:58:24 93296 8192000000 10899089328 11362312192 1947120544 19.204 99 17 33 0 1961800928 10313632 4366752
21:01:16 161756 8192000000 10892458816 11353624576 1887769344 18.728 96 17 34 0 1910284192 17394224 5120624
21:04:03 113600 8192000000 10921168256 11359956992 1945810496 19.193 99 31 59 2 1964796976 10372768 8613712
21:06:04 39272 8192000000 10908040256 11371094016 1973739200 19.415 100 32 64 0 1992889936 10287536 8863200
21:06:50 52121 8192000000 10923206080 11385327616 1982138528 19.482 100 24 48 0 1998262192 9137456 6986208
21:08:06 25742 8192000000 10917272912 11393060864 1988887056 19.535 100 19 38 0 2008991008 13226448 6877504
21:08:39 16081 8192000000 10892873872 11370610688 1955105520 19.267 99 16 32 0 1971991952 11910880 4975552
21:09:02 24900 8192000000 10916393040 11366924288 1954981744 19.266 99 20 41 2 1970331488 9845552 5504192
21:09:35 69653 8192000000 10871085136 11342540800 1900938240 18.834 96 11 22 1 1915199296 11090832 3170224
21:11:20 22899 8192000000 10893551840 11374346240 1965779136 19.352 100 9 18 0 1985047552 16881360 2387056
21:11:50 14896 8192000000 10890701040 11367555072 1965337792 19.348 100 6 12 0 1979087488 12122064 1627632
21:12:11 19581 8192000000 10899647056 11376685056 1973775312 19.415 100 10 20 1 1986909408 10339264 2794832
21:12:37 34074 8192000000 10909879104 11382706176 1978412976 19.452 100 9 18 0 1995335280 14317664 2604640
21:13:17 53854 8192000000 10898038576 11380035584 1963566336 19.334 99 12 24 0 1978708096 11757984 3383776
21:14:29 56554 8192000000 10894327008 11371536384 1972979840 19.409 100 25 47 0 1986414640 7172704 6262096
21:15:31 63581 8192000000 10886615968 11364806656 1938315472 19.133 98 11 22 2 1952584016 10930800 3337744
21:16:42 58383 8192000000 10898695680 11373539328 1939448912 19.142 98 13 24 2 1948987504 6545376 2993216
21:17:47 55650 8192000000 10903150416 11380027392 1963475568 19.334 99 28 55 3 1979221504 8361232 7384704
21:18:49 32235 8192000000 10911369072 11361415168 1937126976 19.124 98 17 34 2 1949157456 7495248 4535232
21:19:30 33651 8192000000 10904277808 11373604864 1957588848 19.287 99 23 46 0 1972748160 8843920 6315392
21:20:15 29811 8192000000 10912315952 11381010432 1961140064 19.315 99 20 40 0 1975370192 8795248 5434880
21:20:51 71465 8192000000 10902874240 11367387136 1919233920 18.981 97 6 12 0 1931237120 10207824 1795376
21:22:09 51866 8192000000 10888863968 11349831680 1856010432 18.471 94 17 34 1 1869678848 9057936 4610480
21:23:07 24196 8192000000 10918422800 11362619392 1967524384 19.366 100 37 73 0 1988345232 10609088 10211760
21:23:41 31030 8192000000 10899034384 11361566720 1930575616 19.071 98 35 70 1 1958138640 17427152 10135872
21:24:27 60018 8192000000 10880130464 11364970496 1915613408 18.952 98 7 14 0 1944943504 27213632 2116464
21:25:44 67001 8192000000 10863459584 11329449984 1878227200 18.651 96 20 40 0 1904657712 20589872 5840640
21:27:05 22984 8192000000 10921636112 11364798464 1958620336 19.295 100 39 76 2 1976619936 7555856 10443744
21:27:34 28413 8192000000 10902912192 11344375808 1933758544 19.097 98 46 91 0 1959716336 13327872 12629920
21:28:08 106683 8192000000 10892585200 11353927680 1891621024 18.759 97 15 30 0 1911854272 15568224 4665024
21:30:06 103577 8192000000 10874658544 11342917632 1895272480 18.788 97 13 26 1 1907802224 9392128 3137616
21:31:58 35224 8192000000 10883829968 11345821696 1936265664 19.117 99 27 54 1 1952682592 9452032 6964896
21:32:42 14876 8192000000 10887541664 11344990208 1946495888 19.199 100 30 60 0 1963413424 9080800 7836736
21:33:06 81015 8192000000 10870534512 11347247104 1922627136 19.008 98 23 46 1 1940303552 11197824 6478592
21:34:35 52036 8192000000 10876757360 11354091520 1943447360 19.174 99 11 23 2 1957195776 10744448 3003968
21:35:34 40494 8192000000 10866930416 11349454848 1915439280 18.950 98 6 12 0 1927806368 10637120 1729968
21:36:45 77322 8192000000 10850288080 11329986560 1887638768 18.727 97 17 34 0 1905998928 13025472 5334688
21:38:20 52611 8192000000 10838004928 11310657536 1841155376 18.350 96 7 14 0 1862006544 19231840 1619328
21:39:19 75912 8192000000 10858649504 11320918016 1863604480 18.532 97 28 56 0 1886842480 15290848 7947152
21:40:42 46871 8192000000 10852968256 11317510144 1915041840 18.947 99 24 48 0 1931041088 9216000 6783248
21:41:35 70547 8192000000 10877204016 11351769088 1906162816 18.876 98 17 34 0 1923662624 12265408 5234400
21:42:52 57085 8192000000 10880617808 11345068032 1908234400 18.892 98 27 52 0 1935564864 19178704 8151760
21:44:00 75906 8192000000 10858713088 11312709632 1827759616 18.241 94 27 54 1 1855378944 19671440 7947888
21:45:24 57014 8192000000 10862754896 11345203200 1887039376 18.722 98 19 38 0 1917310608 24672224 5599008
21:46:28 102920 8192000000 10858795664 11320655872 1843795360 18.372 96 8 14 0 1863012496 16876016 2341120
21:48:19 55864 8192000000 10861101968 11328651264 1891275296 18.756 98 15 30 0 1904795840 9406704 4113840
21:49:21 29834 8192000000 10899539728 11341660160 1942828416 19.169 100 46 89 2 1966902080 11049776 13023888
21:50:03 11568 8192000000 10893260352 11336482816 1924889216 19.026 99 52 104 2 1952346224 12701696 14755312
21:50:21 15811 8192000000 10892929040 11348971520 1923655104 19.016 99 48 96 2 1955572064 18877200 13039760
21:50:49 60812 8192000000 10857193776 11344498688 1932829680 19.089 100 22 44 2 1954746224 15765216 6151328
21:52:41 67505 8192000000 10893861952 11355852800 1951574832 19.239 100 29 58 3 1968421680 9222624 7624224
21:54:38 32257 8192000000 10856865184 11327447040 1930449584 19.070 99 19 37 0 1945218544 9236896 5532064
21:55:16 69948 8192000000 10854057824 11336499200 1908762480 18.897 98 15 30 0 1927022592 13824512 4435600
21:56:33 29725 8192000000 10864936512 11346485248 1939808016 19.145 100 8 16 1 1953059904 10699760 2552128
21:57:09 7623 8192000000 10865009424 11350085632 1946987328 19.202 100 8 16 0 1959813872 10893168 1933376
21:57:22 2361 8192000000 10854209104 11340718080 1926569456 19.039 99 6 12 0 1939194096 11160672 1463968
21:57:31 29772 8192000000 10864624304 11352117248 1944598400 19.183 100 7 13 0 1955638048 9518464 1521184
21:58:19 58926 8192000000 10885358816 11364306944 1943391792 19.174 99 9 18 0 1951887200 6492560 2002848
22:00:01 89088 8192000000 10897107600 11371266048 1864629712 18.541 94 16 32 0 1882281232 13372992 4278528
22:01:52 52303 8192000000 10917331616 11388243968 1978313216 19.451 100 28 56 2 2003667744 17258576 8095952
22:02:51 65046 8192000000 10913483904 11392659456 1980715840 19.470 100 24 47 3 2009534624 21807536 7011248
22:04:12 63772 8192000000 10903270064 11368173568 1905854944 18.873 96 22 45 0 1919511248 7569824 6086480
22:05:24 20026 8192000000 10930054560 11383967744 1972364624 19.404 100 37 72 3 1991169152 7506560 11297968
22:06:14 96452 8192000000 10909923904 11383812096 1942452160 19.166 98 11 22 0 1958010272 12643024 2915088
22:07:56 72845 8192000000 10934090752 11405643776 1986438528 19.516 100 17 31 3 2000911632 10128992 4344112
22:09:18 78034 8192000000 10930358624 11390623744 1965926032 19.353 99 15 30 1 1980011408 10077264 4008112
22:10:47 47171 8192000000 10913013072 11386408960 1941440432 19.158 98 35 69 1 1967166704 16165408 9560864
22:11:41 122073 8192000000 10899637328 11388141568 1860894240 18.511 94 8 16 1 1876677584 13154672 2628672
22:13:49 165565 8192000000 10881032464 11373060096 1914907232 18.946 97 20 40 1 1935167424 14518096 5742096
22:16:49 17065 8192000000 10871646608 11365425152 1935481872 19.111 99 7 14 0 1951775104 14459120 1834112
22:17:12 2373 8192000000 10874342928 11354533888 1939766304 19.145 100 9 16 2 1955925488 13622160 2537024
22:17:24 36983 8192000000 10859092608 11340533760 1890681328 18.751 97 15 28 2 1907847296 13426208 3739760
22:18:08 62828 8192000000 10850025776 11345698816 1897850160 18.809 98 5 10 0 1911671504 12545024 1276320
22:20:19 75592 8192000000 10861226704 11346927616 1940933856 19.154 100 14 28 0 1956038912 9925600 5179456
22:21:44 87461 8192000000 10874988688 11350360064 1906737136 18.880 98 30 61 2 1923461696 8314560 8410000
22:23:18 67684 8192000000 10886326752 11359088640 1935258080 19.109 99 20 40 1 1954916656 14039328 5619248
22:25:03 106196 8192000000 10893870048 11370708992 1933377696 19.094 99 8 16 0 1951100736 15360928 2362112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 08-02-2021 22:29:09 to 08-02-2021 22:29:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 166 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-02-2021 22:29:42 to 08-02-2021 22:29:44.

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          237474
MON$OLDEST_ACTIVE               237475
MON$OLDEST_SNAPSHOT             237475
MON$NEXT_TRANSACTION            237475
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                       2023104
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:108: 
:109: mscs-test-161.budzdorov.ru    Mon Feb  8 22:27:38 2021
:110:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:111: 
:112: 
:113: mscs-test-161.budzdorov.ru    Mon Feb  8 22:27:39 2021
:114:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:115: 
:116: 
:117: mscs-test-161.budzdorov.ru    Mon Feb  8 22:27:45 2021
:118:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:119: 
--- end of diff output ---

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

08.02.21 22:29:45. 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-08 22:29:47 No severe PSQL-related problems occured
08.02.21 22:29:48. End of report.