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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-25 16:27:02
DTS_END                         2020-11-25 16:27:02.3900
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50690
TRN_ID                          238856
ATT_ID                          700
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: 9453.13 23384 1134375
customer order: creation 169.03 375 20284
customer order: refuse 14.81 328 1777
order to supplier: creation 45.56 1244 5467
order to supplier: removal 3.74 87376 449
invoice (draft): creation 45.78 3101 5493
invoice (draft): removal 56.03 668 6724
invoice accept: apply 40.58 17027 4870
invoice accept: cancel 50.83 787 6099
customer reserve: creation 3783.64 167 454037
customer reserve: removal 4945.88 53 593506
realization accept: apply 81.26 174 9751
realization accept: cancel 90.50 100 10860
payment from customer: creation 57.82 119 6938
payment from customer: removal 5.40 75 648
payment to supplier: creation 47.55 132 5706
payment to supplier: removal 3.37 74 404
service: total inventory turnovers 4.81 1061 577
service: total monetary turnovers 5.73 19 688
service: aggregate perf. data 0.78 25336 93
service: refresh index statistics 0.03 329463 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-11-2020 16:27:50 to 25-11-2020 16:27:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5774
TEST_TIME 2 6740
TEST_TIME 3 6611
TEST_TIME 4 6538
TEST_TIME 5 6035
TEST_TIME 6 5772
TEST_TIME 7 5549
TEST_TIME 8 5532
TEST_TIME 9 5773
TEST_TIME 10 5997
TEST_TIME 11 6162
TEST_TIME 12 6381
TEST_TIME 13 6594
TEST_TIME 14 7120
TEST_TIME 15 7604
TEST_TIME 16 8021
TEST_TIME 17 8082
TEST_TIME 18 8411
TEST_TIME 19 8348
TEST_TIME 20 8428
TEST_TIME 21 8516
TEST_TIME 22 8916
TEST_TIME 23 9418
TEST_TIME 24 10187
TEST_TIME 25 10678
TEST_TIME 26 10465
TEST_TIME 27 10286
TEST_TIME 28 10319
TEST_TIME 29 10353
TEST_TIME 30 10329
TEST_TIME 31 10133
TEST_TIME 32 9936
TEST_TIME 33 10071
TEST_TIME 34 9941
TEST_TIME 35 9770
TEST_TIME 36 9650
TEST_TIME 37 9549
TEST_TIME 38 9550
TEST_TIME 39 9418
TEST_TIME 40 9253
TEST_TIME 41 9188
TEST_TIME 42 9236
TEST_TIME 43 9328
TEST_TIME 44 9398
TEST_TIME 45 9303
TEST_TIME 46 9566
TEST_TIME 47 9602
TEST_TIME 48 9702
TEST_TIME 49 9764
TEST_TIME 50 9747
TEST_TIME 51 9866
TEST_TIME 52 9856
TEST_TIME 53 9870
TEST_TIME 54 9824
TEST_TIME 55 9700
TEST_TIME 56 9642
TEST_TIME 57 9579
TEST_TIME 58 9571
TEST_TIME 59 9515
TEST_TIME 60 9429
TEST_TIME 61 9367
TEST_TIME 62 9387
TEST_TIME 63 9412
TEST_TIME 64 9411
TEST_TIME 65 9542
TEST_TIME 66 9478
TEST_TIME 67 9610
TEST_TIME 68 9542
TEST_TIME 69 9530
TEST_TIME 70 9473
TEST_TIME 71 9574
TEST_TIME 72 9562
TEST_TIME 73 9566
TEST_TIME 74 9712
TEST_TIME 75 9772
TEST_TIME 76 9709
TEST_TIME 77 9632
TEST_TIME 78 9579
TEST_TIME 79 9497
TEST_TIME 80 9514
TEST_TIME 81 9509
TEST_TIME 82 9488
TEST_TIME 83 9505
TEST_TIME 84 9424
TEST_TIME 85 9393
TEST_TIME 86 9437
TEST_TIME 87 9420
TEST_TIME 88 9468
TEST_TIME 89 9424
TEST_TIME 90 9481
TEST_TIME 91 9536
TEST_TIME 92 9563
TEST_TIME 93 9634
TEST_TIME 94 9651
TEST_TIME 95 9638
TEST_TIME 96 9706
TEST_TIME 97 9739
TEST_TIME 98 9767
TEST_TIME 99 9737
TEST_TIME 100 9697
TEST_TIME 101 9606
TEST_TIME 102 9642
TEST_TIME 103 9604
TEST_TIME 104 9588
TEST_TIME 105 9552
TEST_TIME 106 9543
TEST_TIME 107 9546
TEST_TIME 108 9546
TEST_TIME 109 9487
TEST_TIME 110 9461
TEST_TIME 111 9459
TEST_TIME 112 9460
TEST_TIME 113 9473
TEST_TIME 114 9460
TEST_TIME 115 9491
TEST_TIME 116 9523
TEST_TIME 117 9523
TEST_TIME 118 9538
TEST_TIME 119 9535
TEST_TIME 120 9455

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 25-11-2020 16:27:53 to 25-11-2020 16:27:57.

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 1555969 1555969 0 0.00 0 25064 6 0 0
doc_list_biud 1555969 1555969 0 0.00 0 62159 25 0 0
sp_add_invoice_to_stock 5002 4870 132 2.63 20 211129 17028 0 132
sp_cancel_adding_invoice 6099 6099 0 0.00 3 72555 787 0 0
sp_cancel_client_order 1777 1777 0 0.00 4 10861 329 0 0
sp_cancel_customer_reserve 593506 593506 0 0.00 1 62167 53 0 0
sp_cancel_pay_from_customer 648 648 0 0.00 3 5485 75 0 0
sp_cancel_pay_to_supplier 404 404 0 0.00 3 5984 74 0 0
sp_cancel_supplier_invoice 6732 6724 8 0.11 2 16659 668 0 8
sp_cancel_supplier_order 449 449 0 0.00 6 885673 87376 0 0
sp_cancel_write_off 10860 10860 0 0.00 1 7259 101 0 0
sp_client_order 20284 20284 0 0.00 4 24973 375 0 0
sp_customer_reserve 454037 454037 0 0.00 0 90425 168 0 0
sp_fill_shopping_cart 31241 31241 0 0.00 1 15738 37 0 0
sp_fill_shopping_cart_clo_res 454036 454036 0 0.00 0 22194 13 0 0
sp_get_clo_for_invoice 4867 4867 0 0.00 0 25276 301 0 0
sp_kill_cost_storno 18011 18011 0 0.00 0 6965 49 0 0
sp_kill_qstorno_ret_qs2qd 1205045 1205045 0 0.00 0 62141 29 0 0
sp_kill_qty_storno 634033 634033 0 0.00 0 62156 62 0 0
sp_lock_selected_doc 20391 20391 0 0.00 0 8847 7 0 0
sp_make_cost_storno 27262 27262 0 0.00 0 25052 55 0 0
sp_multiply_rows_for_pdistr 27262 27262 0 0.00 0 11317 29 0 0
sp_multiply_rows_for_qdistr 20284 20284 0 0.00 0 18118 171 0 0
sp_pay_from_customer 6938 6938 0 0.00 4 12202 120 0 0
sp_pay_to_supplier 5706 5706 0 0.00 5 20707 132 0 0
sp_payment_common 12644 12644 0 0.00 2 20654 31 0 0
sp_qd_handle_on_cancel_clo 1777 1777 0 0.00 0 10828 294 0 0
sp_qd_handle_on_invoice_upd_sts 10966 10966 0 0.00 0 21890 289 0 0
sp_qd_handle_on_reserve_upd_sts 9751 9751 0 0.00 0 12673 52 0 0
sp_reserve_write_off 9751 9751 0 0.00 6 16467 175 0 0
sp_supplier_invoice 5493 5493 0 0.00 6 89378 3102 0 0
sp_supplier_order 5467 5467 0 0.00 5 35550 1245 0 0
srv_aggregate_perf_data 94 93 1 1.06 2600 588748 25336 0 1
srv_fill_mon_cache_memory 151 151 0 0.00 285 130240 35635 0 0
srv_find_qd_qs_mism 1088155 1088155 0 0.00 0 9146 5 0 0
srv_make_invnt_saldo 577 577 0 0.00 41 47080 1061 0 0
srv_make_money_saldo 688 688 0 0.00 0 898 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 229583 449465 329463 0 0
t$perf-abend:sp_add_invoice_to_stock 132 132 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 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 4871 4871 0 0.00 0 19592 181 0 0
t$perf-norm:sp_cancel_adding_invoice 444 444 0 0.00 0 5651 97 0 0
t$perf-norm:sp_cancel_client_order 1777 1777 0 0.00 0 2106 11 0 0
t$perf-norm:sp_cancel_customer_reserve 698 698 0 0.00 0 3538 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 648 648 0 0.00 0 8803 36 0 0
t$perf-norm:sp_cancel_pay_to_supplier 404 404 0 0.00 0 341 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 404 404 0 0.00 0 2466 22 0 0
t$perf-norm:sp_cancel_supplier_order 449 449 0 0.00 0 22828 1420 0 0
t$perf-norm:sp_cancel_write_off 949 949 0 0.00 0 5186 19 0 0
t$perf-norm:sp_client_order 20284 20284 0 0.00 0 12351 14 0 0
t$perf-norm:sp_customer_reserve 1023 1023 0 0.00 0 5895 10 0 0
t$perf-norm:sp_pay_from_customer 6938 6938 0 0.00 0 4847 10 0 0
t$perf-norm:sp_pay_to_supplier 5706 5706 0 0.00 0 4125 8 0 0
t$perf-norm:sp_reserve_write_off 9751 9751 0 0.00 0 5617 11 0 0
t$perf-norm:sp_supplier_invoice 5493 5493 0 0.00 0 5294 15 0 0
t$perf-norm:sp_supplier_order 5467 5467 0 0.00 0 6185 18 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 75 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 2410 23 0 0
t$perf-norm:srv_make_invnt_saldo 577 577 0 0.00 0 1490 20 0 0
t$perf-norm:srv_make_money_saldo 688 688 0 0.00 0 3383 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 9998 9734 264 2.64 0 6909 19 0 264
v_all_customers 37090 37090 0 0.00 0 28 0 0 0
v_all_suppliers 30002 30002 0 0.00 0 86 1 0 0
v_all_wares 40568 40568 0 0.00 0 88 1 0 0
v_cancel_adding_invoice 888 888 0 0.00 0 6109 19 0 0
v_cancel_client_order 3554 3554 0 0.00 0 3391 6 0 0
v_cancel_customer_prepayment 1296 1296 0 0.00 0 4411 10 0 0
v_cancel_customer_reserve 1396 1396 0 0.00 0 5159 13 0 0
v_cancel_payment_to_supplier 808 808 0 0.00 0 5874 14 0 0
v_cancel_supplier_invoice 824 808 16 1.94 0 4245 23 0 16
v_cancel_supplier_order 898 898 0 0.00 0 2772 9 0 0
v_cancel_write_off 1898 1898 0 0.00 0 3380 15 0 0
v_max_id_clo_ord 5467 5467 0 0.00 0 553 1 0 0
v_max_id_clo_res 1023 1023 0 0.00 0 7583 21 0 0
v_max_id_ord_sup 5490 5490 0 0.00 0 5183 6 0 0
v_max_non_paid_invoice 1662 1662 0 0.00 0 659 3 0 0
v_max_non_paid_realizn 3557 3557 0 0.00 0 1652 4 0 0
v_min_id_clo_ord 5467 5467 0 0.00 0 4727 9 0 0
v_min_id_clo_res 1023 1023 0 0.00 0 9301 18 0 0
v_min_id_ord_sup 5490 5490 0 0.00 0 5683 10 0 0
v_min_non_paid_invoice 5706 5706 0 0.00 0 20612 20 0 0
v_min_non_paid_realizn 6938 6938 0 0.00 0 9315 20 0 0
v_our_firm 10240 10240 0 0.00 0 14 1 0 0
v_reserve_write_off 19502 19502 0 0.00 0 6170 8 0 0
x_lock_depdocs_on_canc_invoice 12419 12419 0 0.00 0 15297 97 0 0
x_lock_depdocs_on_canc_sup_ord 449 449 0 0.00 0 20859 375 0 0
x_make_qstorno_1000_1200 5467 5467 0 0.00 2 35543 1171 0 0
x_make_qstorno_1200_2000 5493 5493 0 0.00 2 89363 2968 0 0
x_make_qstorno_2100_3300 454037 454037 0 0.00 0 90424 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-11-2020 16:27:58 to 25-11-2020 16:28:02.

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:05 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:12 16607 8192000000 10230750816 10532265984 998021632 10.859 79 57 114 0 1020464048 2863136 19579280
13:57:37 23221 8192000000 10329084096 10640191488 1356187664 14.203 100 86 172 0 1389771680 4613808 28970208
13:58:10 22089 8192000000 10355326688 10672988160 1412644544 14.707 100 87 174 0 1447352848 5978176 28730128
13:58:41 25107 8192000000 10396099664 10718822400 1441854352 14.966 100 85 170 0 1475920480 6523872 27542256
13:59:19 16265 8192000000 10413012096 10741256192 1467725584 15.194 100 82 164 0 1502009408 7496832 26786992
13:59:43 19030 8192000000 10434925952 10761781248 1482384480 15.322 100 90 180 1 1519935408 8169440 29381488
14:00:17 12469 8192000000 10437495504 10770829312 1497905408 15.458 100 84 168 0 1533299168 8681264 26712496
14:00:40 15751 8192000000 10461220160 10797387776 1507298496 15.540 100 79 158 0 1541604496 9117344 25188656
14:01:05 27851 8192000000 10500090688 10842353664 1541404128 15.836 100 85 170 0 1577525296 9407616 26713552
14:01:50 18125 8192000000 10533568784 10883846144 1591665360 16.268 100 83 166 1 1627204944 10053040 25486544
14:02:16 15932 8192000000 10564290448 10918817792 1622398336 16.530 100 79 156 0 1655835760 10504656 22932768
14:02:41 15684 8192000000 10582021088 10944225280 1644035760 16.714 100 81 163 0 1679595680 11578880 23981040
14:03:07 7778 8192000000 10603422944 10966196224 1660701680 16.855 100 79 157 1 1695802880 12538704 22562496
14:03:25 9122 8192000000 10608432032 10975318016 1671979696 16.950 100 82 165 0 1709295952 12827616 24488640
14:03:43 8978 8192000000 10619427664 10990612480 1686343440 17.071 100 81 162 1 1722996896 13161040 23492416
14:03:58 11263 8192000000 10644080672 11011702784 1697265104 17.162 100 78 156 0 1733387792 13340160 22782528
14:04:17 7396 8192000000 10647812944 11019051008 1705631856 17.232 100 83 164 0 1743259968 13876448 23751664
14:04:33 6246 8192000000 10657745696 11035176960 1718969488 17.344 100 72 145 3 1752208240 12996608 20242144
14:04:46 6289 8192000000 10676308672 11049873408 1732734832 17.458 100 79 156 2 1768484688 12837248 22912608
14:05:02 6935 8192000000 10681774576 11058647040 1744422112 17.555 100 83 166 1 1780990352 12962336 23605904
14:05:16 6266 8192000000 10697973936 11080507392 1757401232 17.663 100 74 149 1 1791064528 12765072 20898224
14:05:30 5513 8192000000 10702709760 11081867264 1772404448 17.787 100 77 152 2 1806326592 12958176 20963968
14:05:43 6017 8192000000 10715004416 11100856320 1777221568 17.827 100 78 155 1 1812223376 13355952 21645856
14:05:58 3375 8192000000 10739248400 11119894528 1793848352 17.963 100 79 158 1 1828435984 12073760 22513872
14:06:08 2953 8192000000 10748519120 11133886464 1811590416 18.109 100 78 155 0 1844796288 11546384 21659488
14:06:19 3980 8192000000 10758789664 11144646656 1816029680 18.145 100 86 171 2 1852241328 12748080 23463568
14:06:30 3577 8192000000 10764238208 11146199040 1823569120 18.207 100 88 177 0 1863346400 14367264 25410016
14:06:40 2174 8192000000 10766168768 11151654912 1825668304 18.224 100 79 158 0 1861432480 13219296 22544880
14:06:49 1952 8192000000 10778317888 11161968640 1834701792 18.298 100 88 175 0 1873082192 13387328 24993072
14:06:58 2287 8192000000 10780379888 11164864512 1841357536 18.352 100 84 168 3 1877482560 12580400 23544624
14:07:07 1614 8192000000 10787715344 11175161856 1848763152 18.412 100 90 178 1 1888038000 12696560 26578288
14:07:15 1886 8192000000 10789637296 11179323392 1849772912 18.420 100 82 164 1 1884950352 11974992 23202448
14:07:24 2479 8192000000 10795350224 11182391296 1852726112 18.444 100 81 163 1 1887065456 10923136 23416208
14:07:34 2835 8192000000 10806495488 11192270848 1860596832 18.508 100 90 180 0 1899321136 13355360 25368944
14:07:43 1423 8192000000 10806950560 11194535936 1864162352 18.537 100 92 186 1 1904022896 13549472 26311072
14:07:53 1900 8192000000 10818167968 11204206592 1865641680 18.549 100 94 189 2 1906615632 14266432 26707520
14:08:01 1745 8192000000 10804801248 11196919808 1865636256 18.549 100 88 174 2 1902052688 12167792 24248640
14:08:09 1488 8192000000 10813944512 11205943296 1869443696 18.580 100 92 185 2 1909415136 13953488 26017952
14:08:19 25133 8192000000 10801775968 11199741952 1868475376 18.572 100 67 133 0 1898435200 10298768 19661056
14:08:50 2279 8192000000 10799030256 11206406144 1868475824 18.572 100 71 142 3 1901525392 12781344 20268224
14:08:59 1840 8192000000 10796244944 11202486272 1867953680 18.568 100 69 139 2 1897639424 10097232 19588512
14:09:07 1953 8192000000 10792809424 11202289664 1867034848 18.560 100 61 119 3 1894404336 9674784 17694704
14:09:16 5311 8192000000 10791008544 11202097152 1865173136 18.545 100 41 81 0 1885931104 9645568 11112400
14:09:28 3829 8192000000 10792958752 11203710976 1868559440 18.573 100 53 107 1 1894020016 9831984 15628592
14:09:41 5111 8192000000 10782462096 11202691072 1869351040 18.579 100 39 78 2 1887893488 7581360 10961088
14:09:55 7189 8192000000 10777704128 11203334144 1870589712 18.589 100 26 52 0 1884254384 6554656 7110016
14:10:12 10679 8192000000 10810376960 11218333696 1878139488 18.650 100 42 85 0 1897084288 6713536 12231264
14:10:31 57286 8192000000 10811098528 11224010752 1884418368 18.701 100 37 73 3 1901169632 5341344 11409920
14:11:35 13010 8192000000 10787911792 11222863872 1879757888 18.663 100 22 45 1 1891208624 5538800 5911936
14:11:56 4801 8192000000 10795251296 11223879680 1884747072 18.703 100 23 46 1 1897329616 5393824 7188720
14:12:08 5391 8192000000 10803264768 11231809536 1884902048 18.705 100 29 59 0 1900142736 7231056 8009632
14:12:20 4481 8192000000 10799908416 11231064064 1887272112 18.724 100 32 64 3 1903293136 7400672 8620352
14:12:33 4925 8192000000 10800860736 11229925376 1888942688 18.737 100 25 50 0 1905143776 7816384 8384704
14:12:45 5954 8192000000 10800605568 11233275904 1895448128 18.790 100 26 50 1 1908512192 6686480 6377584
14:12:58 6267 8192000000 10813896432 11242258432 1891779264 18.760 100 19 39 1 1903695568 6076240 5840064
14:13:12 2488 8192000000 10822124560 11242930176 1896101680 18.795 100 35 71 2 1913098816 7015360 9981776
14:13:22 6974 8192000000 10813478848 11241226240 1895525936 18.790 100 32 62 3 1911850624 8122096 8202592
14:13:38 4006 8192000000 10811613536 11243245568 1896801184 18.801 100 24 48 1 1910544752 6814688 6928880
14:13:49 5195 8192000000 10809910960 11245535232 1899368896 18.821 100 24 48 1 1912769024 6249760 7150368
14:14:05 10478 8192000000 10810573792 11247902720 1903633296 18.856 100 26 52 3 1917449552 6317760 7498496
14:14:26 12040 8192000000 10808039552 11246923776 1901160816 18.836 100 18 36 0 1911859920 5455376 5243728
14:14:46 5301 8192000000 10807761248 11250343936 1902414560 18.846 100 17 34 0 1913723136 6163088 5145488
14:14:57 65100 8192000000 10830439760 11261743104 1908892192 18.898 100 45 90 1 1928481264 5506384 14082688
14:16:09 8309 8192000000 10818750016 11254464512 1904801744 18.865 100 16 31 0 1914685120 4926320 4957056
14:16:23 8002 8192000000 10823399232 11257028608 1907140704 18.884 100 27 54 0 1920732144 6524784 7066656
14:16:39 5413 8192000000 10823857072 11258667008 1901593584 18.839 100 43 84 2 1928317792 14809216 11914992
14:16:53 7639 8192000000 10823527984 11252432896 1903240768 18.852 100 44 88 1 1922090352 7043440 11806144
14:17:10 9154 8192000000 10813447648 11245461504 1899914784 18.826 100 32 65 0 1915496624 6071088 9510752
14:17:29 7766 8192000000 10809070096 11236282368 1873975280 18.616 99 38 76 0 1895909056 11135104 10798672
14:17:44 4495 8192000000 10786912656 11220312064 1877275824 18.643 100 24 48 1 1889865840 5817712 6772304
14:17:57 6434 8192000000 10764032576 11191975936 1826814640 18.233 98 15 30 0 1837429440 5548032 5066768
14:18:11 3768 8192000000 10785631104 11197947904 1859472688 18.499 99 46 93 2 1876742400 4726976 12542736
14:18:22 3856 8192000000 10779904640 11198148608 1855648624 18.468 100 30 61 1 1871301584 6912272 8740688
14:18:34 6197 8192000000 10759098256 11181297664 1801300304 18.025 97 21 42 1 1812885776 6023728 5561744
14:18:51 9588 8192000000 10701029424 11124719616 1755185920 17.645 96 17 34 4 1765794880 5608096 5000864
14:19:09 3318 8192000000 10690920224 11104477184 1757906416 17.667 98 20 39 4 1769556672 6386624 5263632
14:19:19 61251 8192000000 10648110048 11052662784 1607339776 16.402 89 20 40 0 1618058064 4477760 6240528
14:20:26 19966 8192000000 10670887536 11085062144 1619363072 16.504 91 15 30 0 1628681760 4982928 4335760
14:20:53 7999 8192000000 10686052256 11090980864 1711075824 17.278 96 37 74 2 1728530288 7198736 10255728
14:21:08 4770 8192000000 10673585648 11081371648 1725047712 17.394 97 28 56 0 1739104688 6091984 7964992
14:21:21 4378 8192000000 10686214192 11102703616 1767448368 17.746 99 27 54 1 1781270208 6435392 7386448
14:21:34 5549 8192000000 10702152704 11120652288 1759905408 17.684 98 25 50 2 1777758016 10932832 6919776
14:21:46 5277 8192000000 10722753984 11138428928 1801307856 18.025 100 23 46 1 1817234880 9678768 6248256
14:21:57 5621 8192000000 10710057280 11132633088 1787872672 17.914 99 30 60 2 1803268464 6529904 8865888
14:22:09 6071 8192000000 10714847456 11135414272 1803973360 18.047 100 25 49 2 1815883024 4773392 7136272
14:22:21 8542 8192000000 10733617248 11153330176 1817410704 18.157 100 19 36 2 1828235648 5228288 5596656
14:22:36 9831 8192000000 10750019616 11161583616 1812332192 18.115 99 47 94 0 1833109680 5689920 15087568
14:22:54 9058 8192000000 10757949904 11173351424 1833576624 18.288 100 35 70 0 1850322272 5219760 11525888
14:23:10 7241 8192000000 10756319744 11177009152 1840333616 18.344 100 20 38 2 1851322064 5570512 5417936
14:23:24 14476 8192000000 10755358896 11177238528 1822336048 18.197 99 15 30 0 1831528592 5072624 4119920
14:23:47 22184 8192000000 10755210896 11182931968 1846997360 18.398 100 21 41 1 1858346128 4876064 6472704
14:24:17 49218 8192000000 10760355024 11188183040 1852400832 18.442 100 42 84 2 1870148016 6182480 11564704
14:25:21 10056 8192000000 10778976736 11203411968 1859931424 18.503 100 32 62 1 1879536400 11268224 8336752
14:25:38 13173 8192000000 10783871664 11203850240 1859604224 18.500 100 25 50 1 1872526064 5855584 7066256
14:25:59 5812 8192000000 10779351936 11203506176 1861777344 18.518 100 25 50 2 1874741344 6018352 6945648
14:26:12 7006 8192000000 10789079712 11208609792 1866705456 18.558 100 24 48 1 1879195072 5586688 6902928
14:26:28 4107 8192000000 10787095520 11208572928 1866448928 18.556 100 24 48 0 1879154736 5713184 6992624
14:26:44 8429 8192000000 10793423440 11223199744 1869487200 18.580 100 23 46 0 1885890736 9575376 6828160
14:27:05 14992 8192000000 10817570928 11234148352 1889780624 18.744 100 44 86 1 1908747424 5993392 12973408
14:27:32 3041 8192000000 10842044592 11253256192 1904714400 18.864 100 56 104 3 1927471136 8203360 14553376
14:27:44 41876 8192000000 10850210880 11264892928 1917291488 18.965 100 56 111 0 1942356112 9841104 15223520
14:28:38 15533 8192000000 10861994688 11277475840 1923673344 19.016 100 55 110 1 1950570544 11685792 15211408
14:29:04 12212 8192000000 10845791296 11273121792 1925691632 19.032 100 39 76 1 1943402064 7027536 10682896
14:29:32 74568 8192000000 10857746816 11293831168 1935136720 19.108 100 39 78 2 1956531616 9910528 11484368
14:30:53 11354 8192000000 10879164464 11306446848 1944918400 19.186 100 42 83 2 1966997328 10479168 11599760
14:31:13 15440 8192000000 10895688576 11319173120 1953826976 19.257 100 58 116 1 1981158848 11273808 16058064
14:31:39 3595 8192000000 10897431792 11321032704 1962300704 19.324 100 54 108 1 1987063712 10098256 14664752
14:31:49 13851 8192000000 10907789328 11329572864 1968719488 19.375 100 62 124 1 1997934368 10950864 18264016
14:32:15 14431 8192000000 10909719472 11338047488 1971435840 19.397 100 50 99 0 1998999376 13647728 13915808
14:32:42 20688 8192000000 10918036368 11351261184 1978015504 19.449 100 51 101 2 2007072256 13909408 15147344
14:33:17 10182 8192000000 10933555440 11356917760 1985558368 19.509 100 53 103 0 2015023712 13970112 15495232
14:33:43 20725 8192000000 10920369360 11356229632 1986448176 19.516 100 43 84 3 2013528048 14231808 12848064
14:34:24 18178 8192000000 10926763120 11358191616 1971375888 19.396 99 51 100 3 2001866544 15718928 14771728
14:34:51 5516 8192000000 10933394480 11363262464 1991122256 19.553 100 49 98 0 2023212320 16879728 15210336
14:35:05 6698 8192000000 10928395296 11363618816 1992749792 19.566 100 45 90 0 2022552528 16307792 13494944
14:35:18 10594 8192000000 10949334848 11381698560 2003513568 19.650 100 59 118 1 2038444288 17553728 17376992
14:35:47 6722 8192000000 10942121456 11373576192 1989723152 19.542 99 57 112 1 2026732704 20587584 16421968
14:36:03 4983 8192000000 10959803296 11385835520 2006707712 19.676 100 62 122 2 2045844400 21492080 17644608
14:36:18 7292 8192000000 10947108864 11376852992 1988098304 19.529 99 58 117 0 2030970720 25229040 17643376
14:36:32 7762 8192000000 10956584736 11388039168 2007085776 19.679 100 57 114 0 2050055840 25231920 17738144
14:36:47 5171 8192000000 10962999136 11396059136 2010266272 19.704 100 57 110 0 2052605184 25645424 16693488
14:36:59 4310 8192000000 10951999952 11381964800 1987056512 19.521 99 67 133 2 2032461888 24892192 20513184
14:37:19 4429 8192000000 10968931184 11392847872 2006576448 19.675 100 64 128 0 2052334400 26113056 19644896
14:37:31 4024 8192000000 10969767792 11394392064 2014770960 19.739 100 78 156 1 2065349168 27136000 23442208
14:37:42 4527 8192000000 10953958608 11383328768 1985514928 19.508 99 67 133 1 2032452016 26915296 20021792
14:37:56 1814 8192000000 10961861440 11387891712 2001494656 19.635 100 61 120 0 2051317088 30869632 18952800
14:38:07 6011 8192000000 10965133408 11388497920 2002030704 19.639 100 75 150 1 2054560128 28711184 23818240
14:38:23 4991 8192000000 10954658032 11384115200 1998120816 19.608 100 58 116 2 2045802880 29408560 18273504
14:38:41 2464 8192000000 10964447872 11388297216 2002340592 19.641 100 78 155 4 2054811024 28471520 23998912
14:38:53 11151 8192000000 10939330688 11367702528 1940469984 19.151 97 56 111 0 1985802800 28464688 16868128
14:39:20 3191 8192000000 10959446928 11380670464 1990877184 19.551 100 76 150 0 2044591296 30267168 23446944
14:39:31 4385 8192000000 10957171200 11384516608 1995220912 19.585 100 60 118 1 2045367728 31925152 18221664
14:39:43 12651 8192000000 10950157216 11377364992 1958829504 19.297 98 61 120 1 2012003472 34783088 18390880
14:40:06 2513 8192000000 10963822448 11386822656 1996580400 19.596 100 74 146 0 2050715616 30905152 23230064
14:40:16 2918 8192000000 10960625776 11386200064 1998836912 19.614 100 73 147 3 2055699104 32731216 24130976
14:40:26 5296 8192000000 10960512272 11380903936 1988437360 19.531 100 79 157 1 2048210000 34924416 24848224
14:40:45 6514 8192000000 10967839328 11391602688 1994495024 19.579 100 67 135 1 2053262416 37822416 20944976
14:41:00 2287 8192000000 10955849568 11369492480 1974211680 19.419 99 81 161 1 2036517856 36488592 25817584
14:41:09 1590 8192000000 10984703840 11393613824 1993940320 19.575 100 78 156 4 2057238368 38071728 25226320
14:41:18 7087 8192000000 10967812272 11396374528 1998147392 19.608 100 65 125 2 2057413472 39448928 19817152
14:41:34 5591 8192000000 10955886656 11372642304 1963305216 19.332 99 76 149 0 2024052928 36897216 23850496
14:41:49 7521 8192000000 10951747136 11381157888 1981644512 19.478 100 67 134 2 2039164624 36509792 21010320
14:42:10 9349 8192000000 10942690144 11378995200 1962110368 19.323 99 60 119 2 2018698688 37610944 18977376
14:42:35 4243 8192000000 10955317008 11381809152 1983868096 19.495 100 64 127 0 2037978288 34428416 19681776
14:42:47 8276 8192000000 10956077088 11381297152 1968950656 19.377 99 65 130 1 2023646064 34607552 20087856
14:43:03 3820 8192000000 10959507920 11377766400 1980564192 19.469 100 80 153 1 2038908912 34949824 23394896
14:43:14 3712 8192000000 10951900512 11374235648 1982003824 19.481 100 75 148 2 2039672928 35509024 22160080
14:43:28 5555 8192000000 10943530704 11357642752 1952382928 19.245 99 82 164 0 2014911168 37548112 24980128
14:43:41 5654 8192000000 10897814592 11317878784 1923887200 19.018 99 65 130 0 1978602560 35055472 19659888
14:43:57 16750 8192000000 10888896016 11325825024 1903293936 18.853 98 42 84 0 1951902480 35144800 13463744
14:44:21 5627 8192000000 10891066320 11318956032 1922016464 19.003 99 61 120 7 1976204480 35390560 18797456
14:44:35 13576 8192000000 10902726784 11332902912 1911143184 18.916 98 53 105 0 1963467760 35353312 16971264
14:44:58 6368 8192000000 10900090720 11326435328 1906270912 18.877 98 66 132 0 1959546800 32643680 20632208
14:45:12 4842 8192000000 10910985040 11331547136 1936561504 19.119 100 67 133 0 1993906736 36062368 21282864
14:45:26 3404 8192000000 10941547024 11356975104 1953911376 19.258 100 77 154 1 2015784736 38292688 23580672
14:45:39 14217 8192000000 10897262080 11334656000 1904351680 18.861 98 40 80 2 1953166608 36552576 12262352
14:46:05 9629 8192000000 10893708768 11328450560 1934098320 19.100 100 38 76 0 1978548160 32073376 12376464
14:46:24 5783 8192000000 10906721776 11337125888 1945455968 19.190 100 46 92 0 1993433248 33295408 14681872
14:46:39 3590 8192000000 10911893952 11348508672 1952458624 19.246 100 41 82 4 1998051712 32177552 13415536
14:46:58 18586 8192000000 10909419824 11354214400 1956236416 19.276 100 39 78 1 2002607440 33370704 13000320
14:47:28 6145 8192000000 10915832288 11361878016 1961944080 19.321 100 41 82 0 2007658384 32668512 13045792
14:47:41 7041 8192000000 10938048896 11373637632 1964765136 19.344 100 44 86 1 2015512224 36132720 14614368
14:48:01 11266 8192000000 10919937824 11367149568 1959802688 19.304 100 33 66 0 2006041712 35170640 11068384
14:48:19 17064 8192000000 10925326816 11365588992 1944286864 19.181 99 38 76 2 1995470992 38482080 12702048
14:48:42 15779 8192000000 10902364480 11346251776 1929385072 19.062 99 31 62 0 1981393632 41782112 10226448
14:49:06 22971 8192000000 10892485824 11335213056 1929483728 19.063 100 29 58 3 1966826048 27537760 9804560
14:49:41 18240 8192000000 10896823392 11343028224 1924775392 19.025 99 29 58 2 1970882304 36105376 10001536
14:50:32 19518 8192000000 10872322512 11330568192 1893897920 18.777 98 25 50 1 1936916896 34137344 8881632
14:50:57 12001 8192000000 10865998096 11318222848 1904446528 18.862 99 26 51 1 1945760880 32082256 9232096
14:51:16 18889 8192000000 10858307152 11315707904 1891988400 18.762 99 18 36 0 1933735680 35117104 6630176
14:51:49 23232 8192000000 10810306800 11289378816 1816833472 18.152 95 7 14 2 1846373696 27225072 2315152
14:52:22 23624 8192000000 10852274480 11293773824 1892340592 18.765 100 19 38 2 1917110224 19363088 5406544
14:52:52 17019 8192000000 10844701680 11309101056 1910591456 18.911 100 14 28 2 1933861664 18972064 4298144
14:53:30 80293 8192000000 10831259216 11285131264 1857155520 18.480 97 21 42 1 1876787280 13558064 6073696
14:55:09 33575 8192000000 10837058528 11267612672 1849192512 18.416 97 45 90 3 1875893776 13466432 13234832
14:55:55 82289 8192000000 10830526304 11295178752 1869498720 18.580 98 8 16 0 1889938496 18235920 2203856
14:57:26 86493 8192000000 10851481856 11312041984 1923363088 19.014 100 8 17 0 1939461232 14098432 1999712
14:59:01 13176 8192000000 10851149488 11314753536 1913053008 18.931 99 5 10 0 1927380720 13138528 1189184
14:59:20 285 8192000000 10852429840 11315666944 1930088848 19.068 100 7 14 0 1945331424 13432736 1809840
14:59:29 66199 8192000000 10860280432 11330207744 1934962880 19.107 100 8 16 0 1945805184 9019696 1822608
15:01:09 124404 8192000000 10877189952 11328450560 1927696096 19.048 99 31 63 1 1943439440 6212064 9531280
15:03:20 51055 8192000000 10856257120 11316051968 1913350672 18.934 98 23 45 2 1927455424 7726528 6378224
15:04:19 5436 8192000000 10865386240 11320201216 1925715952 19.033 99 27 54 1 1941237792 8154304 7367536
15:04:34 46381 8192000000 10864020640 11324878848 1926912960 19.042 99 22 44 0 1942405568 8964384 6528224
15:06:38 66691 8192000000 10874317488 11346186240 1955982000 19.274 100 14 28 0 1977123456 16691584 4449872
15:07:51 41522 8192000000 10885633104 11354628096 1955030080 19.267 100 15 30 0 1981573696 22200368 4343248
15:09:07 45351 8192000000 10886170672 11353939968 1921133568 18.996 98 12 24 1 1942024208 16257600 4633040
15:10:19 52314 8192000000 10891586448 11354337280 1943400880 19.174 99 27 54 0 1973511712 21830816 8280016
15:12:00 61955 8192000000 10908939632 11372085248 1970793104 19.392 100 22 44 0 1993518544 16661952 6063488
15:13:15 64968 8192000000 10944789872 11385028608 1976589616 19.438 100 34 68 1 2002516880 16592912 9334352
15:14:26 54106 8192000000 10924347616 11391758336 1988140496 19.529 100 21 41 3 2008496912 14482512 5873904
15:15:58 62885 8192000000 10932062992 11399110656 1990015536 19.544 100 16 32 0 2016100432 21368864 4716032
15:17:07 33041 8192000000 10944393344 11401207808 2002946864 19.646 100 37 72 2 2024698256 10999456 10751936
15:17:50 80419 8192000000 10922763904 11403931648 1935969232 19.115 97 11 22 1 1956207824 18041008 2197584
15:19:16 96387 8192000000 10913669408 11370881024 1976940112 19.440 99 18 37 1 1991196640 9353040 4903488
15:20:59 32906 8192000000 10940813872 11382743040 1979055680 19.457 99 33 66 2 1995504672 7542368 8906624
15:21:40 36859 8192000000 10925084560 11383975936 1994542816 19.580 100 37 72 2 2014854304 9942192 10369296
15:22:28 90144 8192000000 10909987296 11375849472 1961545136 19.318 98 42 84 2 1982759024 9995472 11218416
15:24:05 39415 8192000000 10911104128 11364311040 1950590240 19.231 98 36 71 3 1971549968 9920704 11039024
15:24:50 37911 8192000000 10883823952 11365572608 1974964128 19.425 100 25 50 1 1993933792 11763312 7206352
15:25:38 65088 8192000000 10892483856 11375697920 1964156784 19.339 99 12 24 0 1975382768 8317616 2908368
15:26:52 27724 8192000000 10899994368 11374792704 1951947792 19.242 98 12 23 2 1961537904 6606080 2984032
15:27:26 31181 8192000000 10885793696 11360071680 1944498288 19.183 98 13 26 0 1957679056 9391856 3788912
15:28:04 45601 8192000000 10888148128 11359883264 1942666656 19.168 98 15 30 0 1956940272 9935696 4337920
15:29:00 67422 8192000000 10896609584 11382419456 1955407440 19.270 99 6 12 0 1972728192 15764592 1556160
15:30:14 83262 8192000000 10885287728 11351752704 1869591792 18.581 94 15 30 0 1884923072 10347408 4983872
15:31:54 77479 8192000000 10901265472 11385954304 1939479840 19.143 98 16 32 0 1959224000 15366848 4377312
15:33:18 20650 8192000000 10903957664 11358892032 1924723984 19.025 97 40 80 3 1949342336 14579600 10038752
15:33:50 61597 8192000000 10881498032 11350577152 1912176368 18.924 97 20 40 0 1931500752 13721728 5602656
15:34:58 57131 8192000000 10870451552 11320418304 1882028032 18.681 96 11 22 0 1894337072 9465024 2844016
15:36:03 44429 8192000000 10877809440 11333386240 1895142384 18.787 97 18 36 0 1907851200 7982992 4725824
15:36:55 16155 8192000000 10905969888 11347353600 1928747360 19.057 99 48 96 1 1953959808 11359168 13853280
15:37:17 82862 8192000000 10859286144 11324915712 1871663840 18.598 96 40 78 0 1898734160 16198624 10871696
15:38:48 56274 8192000000 10864068544 11321905152 1825447552 18.222 94 28 54 0 1842224512 9069264 7707696
15:39:51 68239 8192000000 10860565968 11324260352 1810051072 18.096 94 25 48 0 1834157168 17746448 6359648
15:41:06 89308 8192000000 10844016304 11315154944 1840299920 18.343 96 12 24 0 1864103440 21008976 2794544
15:42:41 92146 8192000000 10865482560 11322290176 1909818512 18.905 99 27 54 0 1930498880 12754624 7925744
15:44:38 129802 8192000000 10860639184 11322949632 1847708512 18.404 95 18 36 1 1864735584 12181488 4845584
15:46:57 48049 8192000000 10840028368 11313786880 1875464544 18.628 97 29 58 1 1905136240 21358992 8312704
15:48:09 36620 8192000000 10849661904 11330809856 1929715472 19.065 100 9 18 0 1946790448 14663648 2411328
15:48:52 6066 8192000000 10849021424 11331710976 1929163008 19.060 100 5 10 0 1946031984 15375168 1493808
15:49:08 54435 8192000000 10851483072 11314298880 1875880976 18.632 97 15 30 0 1895035600 14671472 4483152
15:50:13 57786 8192000000 10837634800 11303329792 1910829536 18.913 99 12 22 0 1925765136 11306384 3629216
15:51:56 91897 8192000000 10863827904 11356893184 1927470608 19.047 99 8 16 1 1948586560 18428816 2687136
15:53:34 62119 8192000000 10874230304 11326877696 1886916272 18.721 97 14 27 0 1899518672 8585264 4017136
15:54:47 22510 8192000000 10866861008 11328827392 1926653440 19.040 99 21 42 0 1942276112 9147024 6475648
15:55:25 56791 8192000000 10873917760 11339558912 1934152720 19.100 99 26 52 1 1958839088 17441216 7245152
15:56:28 45586 8192000000 10891189584 11359535104 1945259280 19.189 99 39 78 0 1971150384 14562672 11328432
15:57:29 78627 8192000000 10907711184 11380088832 1973459824 19.413 100 15 30 1 1996796912 19217424 4119664
15:58:55 75345 8192000000 10898597104 11364147200 1906742368 18.880 96 22 43 2 1923421568 10774064 5905136
16:00:17 67972 8192000000 10896313520 11372748800 1890038176 18.746 96 10 20 1 1903920208 11631472 2250560
16:01:46 87425 8192000000 10932322640 11395842048 1983759264 19.494 100 18 36 1 2002826128 14628992 4437872
16:03:21 55369 8192000000 10923306288 11402035200 1967349648 19.364 99 10 20 1 1983751120 14252192 2149280
16:04:32 87613 8192000000 10929644608 11401072640 1957165424 19.284 98 18 36 2 1975488128 13781856 4540848
16:06:06 78998 8192000000 10941111584 11395829760 1983499856 19.492 99 27 54 1 1998321232 8009104 6812272
16:07:32 130240 8192000000 10935161872 11412484096 1993120576 19.568 99 38 76 0 2015445168 11217136 11107456
16:09:52 52233 8192000000 10931768208 11415957504 2002627632 19.643 100 16 32 2 2024158000 16965008 4565360
16:10:50 42540 8192000000 10905539856 11377827840 1942679680 19.168 97 8 16 0 1958550480 14181712 1689088
16:11:44 83529 8192000000 10918339888 11390042112 1951495664 19.238 98 15 29 1 1966354976 11155456 3703856
16:13:27 58318 8192000000 10903924928 11382812672 1966724608 19.359 99 14 28 0 1983112832 12260432 4127792
16:14:41 50575 8192000000 10908299328 11382546432 1971657200 19.399 99 14 28 0 1989444144 12941232 4845712
16:16:10 88453 8192000000 10890330016 11377078272 1949202992 19.220 98 14 28 0 1962859968 9734896 3922080
16:17:48 67417 8192000000 10882479984 11363643392 1925716560 19.033 97 13 26 0 1941886128 12295072 3874496
16:19:04 63851 8192000000 10902052912 11382972416 1959007680 19.298 99 9 18 1 1978966944 17569808 2389456
16:20:20 46339 8192000000 10872532416 11336343552 1876413472 18.636 95 20 40 1 1900648464 18601008 5633984
16:21:13 87056 8192000000 10857486752 11339472896 1889163616 18.739 96 20 40 1 1911441776 16141488 6136672
16:23:47 53101 8192000000 10882471600 11347820544 1878206528 18.651 95 12 24 0 1893104416 10975616 3922272
16:24:48 94329 8192000000 10860809280 11327582208 1847857872 18.405 94 19 38 1 1862374336 9357200 5159264
16:26:31 40336 8192000000 9675400208 10003148800 807652416 8.974 41 13 25 1 819125824 8162352 3311056

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 25-11-2020 16:28:04 to 25-11-2020 16:28:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 132 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-11-2020 16:28:35 to 25-11-2020 16:28:37.

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          239501
MON$OLDEST_ACTIVE               239502
MON$OLDEST_SNAPSHOT             239502
MON$NEXT_TRANSACTION            239502
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                       2018880
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
--- end of diff output ---

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

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