Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.01.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 17236324 kB
MemAvailable 31355468 kB
Buffers 0 kB
Cached 14426548 kB
SwapCached 4864 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-01-08 22:27:09
DTS_END                         2021-01-08 22:27:09.8320
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/49732
TRN_ID                          242761
ATT_ID                          699
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: 9293.88 22794 1115265
customer order: creation 175.94 388 21113
customer order: refuse 15.41 325 1849
order to supplier: creation 46.94 1297 5633
order to supplier: removal 3.38 103904 405
invoice (draft): creation 46.21 3509 5545
invoice (draft): removal 53.78 719 6454
invoice accept: apply 41.20 18789 4944
invoice accept: cancel 48.34 786 5801
customer reserve: creation 3831.53 185 459784
customer reserve: removal 4734.43 60 568132
realization accept: apply 85.90 175 10308
realization accept: cancel 79.02 112 9482
payment from customer: creation 59.28 122 7113
payment from customer: removal 5.93 72 712
payment to supplier: creation 50.03 118 6003
payment to supplier: removal 3.43 90 411
service: total inventory turnovers 5.13 1058 615
service: total monetary turnovers 7.20 44 864
service: aggregate perf. data 0.78 19136 93
service: refresh index statistics 0.03 304981 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-01-2021 22:28:24 to 08-01-2021 22:28:26.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5726
TEST_TIME 2 4546
TEST_TIME 3 4379
TEST_TIME 4 4649
TEST_TIME 5 5639
TEST_TIME 6 5866
TEST_TIME 7 6112
TEST_TIME 8 6510
TEST_TIME 9 7218
TEST_TIME 10 7779
TEST_TIME 11 7739
TEST_TIME 12 7497
TEST_TIME 13 7568
TEST_TIME 14 7733
TEST_TIME 15 7942
TEST_TIME 16 8143
TEST_TIME 17 8576
TEST_TIME 18 8426
TEST_TIME 19 8901
TEST_TIME 20 9138
TEST_TIME 21 9129
TEST_TIME 22 9051
TEST_TIME 23 9295
TEST_TIME 24 9131
TEST_TIME 25 9621
TEST_TIME 26 10401
TEST_TIME 27 11482
TEST_TIME 28 11399
TEST_TIME 29 11359
TEST_TIME 30 11141
TEST_TIME 31 10964
TEST_TIME 32 10924
TEST_TIME 33 10947
TEST_TIME 34 10815
TEST_TIME 35 10701
TEST_TIME 36 10618
TEST_TIME 37 10589
TEST_TIME 38 10510
TEST_TIME 39 10548
TEST_TIME 40 10518
TEST_TIME 41 10394
TEST_TIME 42 10345
TEST_TIME 43 10201
TEST_TIME 44 10134
TEST_TIME 45 10156
TEST_TIME 46 10036
TEST_TIME 47 9896
TEST_TIME 48 9842
TEST_TIME 49 9977
TEST_TIME 50 9981
TEST_TIME 51 9965
TEST_TIME 52 9920
TEST_TIME 53 10048
TEST_TIME 54 9988
TEST_TIME 55 9922
TEST_TIME 56 10050
TEST_TIME 57 10018
TEST_TIME 58 10042
TEST_TIME 59 10028
TEST_TIME 60 10210
TEST_TIME 61 10306
TEST_TIME 62 10147
TEST_TIME 63 10052
TEST_TIME 64 10035
TEST_TIME 65 10040
TEST_TIME 66 9956
TEST_TIME 67 9924
TEST_TIME 68 9872
TEST_TIME 69 9807
TEST_TIME 70 9705
TEST_TIME 71 9673
TEST_TIME 72 9665
TEST_TIME 73 9635
TEST_TIME 74 9598
TEST_TIME 75 9518
TEST_TIME 76 9566
TEST_TIME 77 9556
TEST_TIME 78 9533
TEST_TIME 79 9498
TEST_TIME 80 9558
TEST_TIME 81 9568
TEST_TIME 82 9652
TEST_TIME 83 9740
TEST_TIME 84 9732
TEST_TIME 85 9698
TEST_TIME 86 9714
TEST_TIME 87 9748
TEST_TIME 88 9858
TEST_TIME 89 9845
TEST_TIME 90 9740
TEST_TIME 91 9681
TEST_TIME 92 9656
TEST_TIME 93 9620
TEST_TIME 94 9592
TEST_TIME 95 9609
TEST_TIME 96 9613
TEST_TIME 97 9601
TEST_TIME 98 9568
TEST_TIME 99 9582
TEST_TIME 100 9642
TEST_TIME 101 9592
TEST_TIME 102 9599
TEST_TIME 103 9575
TEST_TIME 104 9629
TEST_TIME 105 9682
TEST_TIME 106 9662
TEST_TIME 107 9649
TEST_TIME 108 9654
TEST_TIME 109 9596
TEST_TIME 110 9544
TEST_TIME 111 9532
TEST_TIME 112 9497
TEST_TIME 113 9460
TEST_TIME 114 9403
TEST_TIME 115 9376
TEST_TIME 116 9422
TEST_TIME 117 9397
TEST_TIME 118 9395
TEST_TIME 119 9370
TEST_TIME 120 9296

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 08-01-2021 22:28:27 to 08-01-2021 22:28:31.

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 1541411 1541411 0 0.00 0 14220 6 0 0
doc_list_biud 1541411 1541411 0 0.00 0 53579 28 0 0
sp_add_invoice_to_stock 5019 4944 75 1.49 33 190868 18789 0 75
sp_cancel_adding_invoice 5801 5801 0 0.00 5 71393 787 0 0
sp_cancel_client_order 1849 1849 0 0.00 4 21146 326 0 0
sp_cancel_customer_reserve 568132 568132 0 0.00 1 53579 60 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 3 5773 72 0 0
sp_cancel_pay_to_supplier 411 411 0 0.00 3 6494 90 0 0
sp_cancel_supplier_invoice 6459 6454 5 0.07 2 11549 720 0 5
sp_cancel_supplier_order 405 405 0 0.00 18 969004 103904 0 0
sp_cancel_write_off 9482 9482 0 0.00 1 13745 113 0 0
sp_client_order 21113 21113 0 0.00 3 17672 389 0 0
sp_customer_reserve 459784 459784 0 0.00 0 105119 186 0 0
sp_fill_shopping_cart 32291 32291 0 0.00 1 11781 38 0 0
sp_fill_shopping_cart_clo_res 459782 459782 0 0.00 0 16443 15 0 0
sp_get_clo_for_invoice 4942 4942 0 0.00 0 21197 292 0 0
sp_kill_cost_storno 16406 16406 0 0.00 0 4585 53 0 0
sp_kill_qstorno_ret_qs2qd 1152605 1152605 0 0.00 0 53577 32 0 0
sp_kill_qty_storno 607373 607373 0 0.00 0 53578 69 0 0
sp_lock_selected_doc 21195 21195 0 0.00 0 5438 4 0 0
sp_make_cost_storno 28366 28366 0 0.00 0 14142 50 0 0
sp_multiply_rows_for_pdistr 28366 28366 0 0.00 0 6392 32 0 0
sp_multiply_rows_for_qdistr 21113 21113 0 0.00 0 17608 190 0 0
sp_pay_from_customer 7113 7113 0 0.00 4 11054 122 0 0
sp_pay_to_supplier 6003 6003 0 0.00 5 11507 119 0 0
sp_payment_common 13116 13116 0 0.00 1 8478 30 0 0
sp_qd_handle_on_cancel_clo 1849 1849 0 0.00 0 20637 300 0 0
sp_qd_handle_on_invoice_upd_sts 10743 10743 0 0.00 0 21674 319 0 0
sp_qd_handle_on_reserve_upd_sts 10308 10308 0 0.00 0 22949 56 0 0
sp_reserve_write_off 10308 10308 0 0.00 6 23002 176 0 0
sp_supplier_invoice 5545 5545 0 0.00 6 90177 3510 0 0
sp_supplier_order 5633 5633 0 0.00 5 23145 1298 0 0
srv_aggregate_perf_data 94 93 1 1.06 2791 324459 19137 0 1
srv_fill_mon_cache_memory 174 174 0 0.00 1226 110811 29698 0 0
srv_find_qd_qs_mism 1067273 1067273 0 0.00 0 11872 5 0 0
srv_make_invnt_saldo 615 615 0 0.00 39 104000 1058 0 0
srv_make_money_saldo 864 864 0 0.00 0 8588 45 0 0
srv_recalc_idx_stat 4 4 0 0.00 132864 405466 304981 0 0
t$perf-abend:sp_add_invoice_to_stock 75 75 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 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 4944 4944 0 0.00 0 12071 176 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 1 3207 84 0 0
t$perf-norm:sp_cancel_client_order 1849 1849 0 0.00 0 1796 13 0 0
t$perf-norm:sp_cancel_customer_reserve 683 683 0 0.00 0 2694 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 712 712 0 0.00 0 1778 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 411 411 0 0.00 0 267 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 435 435 0 0.00 0 2001 15 0 0
t$perf-norm:sp_cancel_supplier_order 405 405 0 0.00 0 20414 1615 0 0
t$perf-norm:sp_cancel_write_off 1040 1040 0 0.00 0 1332 8 0 0
t$perf-norm:sp_client_order 21113 21113 0 0.00 0 8472 19 0 0
t$perf-norm:sp_customer_reserve 1027 1027 0 0.00 0 3966 9 0 0
t$perf-norm:sp_pay_from_customer 7113 7113 0 0.00 0 8806 8 0 0
t$perf-norm:sp_pay_to_supplier 6003 6003 0 0.00 0 4591 11 0 0
t$perf-norm:sp_reserve_write_off 10308 10308 0 0.00 0 8659 12 0 0
t$perf-norm:sp_supplier_invoice 5545 5545 0 0.00 0 4631 18 0 0
t$perf-norm:sp_supplier_order 5633 5633 0 0.00 0 4300 15 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 112 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 29 1 0 0
t$perf-norm:srv_make_invnt_saldo 615 615 0 0.00 0 2238 25 0 0
t$perf-norm:srv_make_money_saldo 864 864 0 0.00 0 2786 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 10028 9878 150 1.49 0 7660 19 0 150
v_all_customers 38394 38394 0 0.00 0 17 1 0 0
v_all_suppliers 31270 31270 0 0.00 0 18 1 0 0
v_all_wares 42226 42226 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 6485 19 0 0
v_cancel_client_order 3698 3698 0 0.00 0 3834 6 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 3522 10 0 0
v_cancel_customer_reserve 1366 1366 0 0.00 0 9113 15 0 0
v_cancel_payment_to_supplier 822 822 0 0.00 0 6481 17 0 0
v_cancel_supplier_invoice 880 870 10 1.13 0 2667 14 0 10
v_cancel_supplier_order 810 810 0 0.00 0 3605 10 0 0
v_cancel_write_off 2080 2080 0 0.00 0 4821 15 0 0
v_max_id_clo_ord 5633 5633 0 0.00 0 313 1 0 0
v_max_id_clo_res 1027 1027 0 0.00 0 3897 22 0 0
v_max_id_ord_sup 5545 5545 0 0.00 0 3205 3 0 0
v_max_non_paid_invoice 1545 1545 0 0.00 0 1132 4 0 0
v_max_non_paid_realizn 3758 3758 0 0.00 0 3315 6 0 0
v_min_id_clo_ord 5633 5633 0 0.00 0 2285 6 0 0
v_min_id_clo_res 1027 1027 0 0.00 0 272 2 0 0
v_min_id_ord_sup 5545 5545 0 0.00 0 5221 8 0 0
v_min_non_paid_invoice 6003 6003 0 0.00 0 5842 18 0 0
v_min_non_paid_realizn 7113 7113 0 0.00 0 6791 19 0 0
v_our_firm 10542 10542 0 0.00 0 14 1 0 0
v_reserve_write_off 20614 20614 0 0.00 0 9112 8 0 0
x_lock_depdocs_on_canc_invoice 11820 11820 0 0.00 0 16240 108 0 0
x_lock_depdocs_on_canc_sup_ord 405 405 0 0.00 0 9094 363 0 0
x_make_qstorno_1000_1200 5633 5633 0 0.00 2 23138 1218 0 0
x_make_qstorno_1200_2000 5545 5545 0 0.00 2 87078 3375 0 0
x_make_qstorno_2100_3300 459784 459784 0 0.00 0 105118 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-01-2021 22:28:32 to 08-01-2021 22:28:36.

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:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:20 13065 8192000000 10209373568 10506375168 875672320 9.657 70 53 107 0 896500432 2616000 18212112
19:57:42 15931 8192000000 10301254288 10614894592 1348114768 14.131 100 81 162 0 1379394688 4021600 27258320
19:58:10 20137 8192000000 10348853696 10669158400 1406448320 14.652 100 85 168 2 1438822864 5238432 27136112
19:58:42 18763 8192000000 10391998848 10715475968 1444354016 14.988 100 87 174 0 1478796016 6127504 28314496
19:59:12 22130 8192000000 10413781984 10741272576 1467778000 15.194 100 91 182 0 1504157152 6867664 29511488
19:59:41 24241 8192000000 10431224960 10761400320 1484780544 15.343 100 89 178 1 1521042704 7825552 28436608
20:00:15 17582 8192000000 10447273408 10781507584 1502964016 15.502 100 90 180 1 1544069376 12539424 28565936
20:01:13 17986 8192000000 10496183312 10845749248 1549683840 15.907 100 80 160 0 1583481744 8989920 24807984
20:01:43 13398 8192000000 10517065904 10873774080 1584259168 16.205 100 77 154 0 1617140064 9203984 23676912
20:02:05 13955 8192000000 10553016128 10909749248 1609890016 16.424 100 77 154 0 1642740848 9497808 23353024
20:02:28 18853 8192000000 10569539440 10936377344 1631311680 16.606 100 73 144 2 1663576128 10660064 21604384
20:02:57 10112 8192000000 10594421008 10962042880 1659851216 16.848 100 74 148 1 1692879104 11023376 22004512
20:03:19 12034 8192000000 10630602640 11000377344 1683816848 17.049 100 74 148 0 1716284272 11148320 21319104
20:03:42 8759 8192000000 10634991136 11008413696 1699424416 17.180 100 77 153 0 1734907504 12892208 22590880
20:04:00 7945 8192000000 10655528000 11023257600 1712711200 17.291 100 86 172 0 1750262432 13045152 24506080
20:04:15 8994 8192000000 10656602176 11033006080 1724258336 17.388 100 78 156 0 1759472736 12698480 22515920
20:04:31 6142 8192000000 10675697072 11054444544 1740515088 17.523 100 75 150 2 1774916400 12711968 21689344
20:04:45 4852 8192000000 10680385280 11060211712 1750624192 17.607 100 79 158 0 1785666128 12778496 22263440
20:04:56 6396 8192000000 10704170992 11083792384 1763511344 17.713 100 73 145 1 1796233360 12667568 20054448
20:05:11 7400 8192000000 10722169072 11098267648 1773498688 17.796 100 79 158 4 1808729328 13169520 22061120
20:05:25 9331 8192000000 10717921728 11101126656 1777435088 17.828 100 80 160 2 1813612080 13990176 22186816
20:05:44 5487 8192000000 10726682144 11109601280 1783764800 17.880 100 79 158 0 1819835568 14139616 21931152
20:05:56 3274 8192000000 10735133056 11122188288 1800653696 18.019 100 77 154 1 1835625488 13218896 21752896
20:06:06 3020 8192000000 10733349120 11124711424 1804590336 18.052 100 78 157 2 1840867728 13841968 22435424
20:06:18 3731 8192000000 10753888832 11135651840 1813528240 18.125 100 86 172 0 1851520496 13702352 24289904
20:06:28 2649 8192000000 10750866288 11140853760 1817684016 18.159 100 85 170 0 1855054960 13749744 23621200
20:06:37 5007 8192000000 10760364032 11147829248 1822485808 18.198 100 71 142 0 1855639920 12711616 20442496
20:06:49 3722 8192000000 10770784320 11155566592 1829874048 18.258 100 74 148 1 1862744384 12559520 20310816
20:07:00 2849 8192000000 10781429056 11166507008 1834662944 18.297 100 87 174 4 1872816128 13161120 24992064
20:07:09 2165 8192000000 10781865536 11167891456 1839695696 18.338 100 86 173 1 1877563808 13267952 24600160
20:07:18 1890 8192000000 10782514464 11168985088 1844892896 18.381 100 79 155 1 1879358432 12315488 22150048
20:07:26 3257 8192000000 10797380832 11181580288 1852208864 18.440 100 92 183 0 1890628288 12980256 25439168
20:07:36 2190 8192000000 10799490336 11184922624 1852063088 18.439 100 93 184 1 1891753456 13839792 25850576
20:07:44 2362 8192000000 10801001536 11186827264 1861147392 18.513 100 93 186 1 1900182528 12898576 26136560
20:07:53 2177 8192000000 10809615872 11195404288 1863219072 18.529 100 91 181 1 1902522752 13733648 25570032
20:08:02 2355 8192000000 10810812976 11199418368 1865790640 18.550 100 92 182 0 1906056816 14011280 26254896
20:08:10 1193 8192000000 10813699200 11198541824 1867772928 18.566 100 98 197 3 1910065280 14237152 28055200
20:08:18 2099 8192000000 10815929296 11202592768 1867629168 18.565 100 93 187 3 1907304064 12969184 26705712
20:08:27 1465 8192000000 10817524896 11207561216 1869431664 18.580 100 96 193 4 1909646912 13185360 27029888
20:08:34 1868 8192000000 10816904432 11205480448 1872820592 18.607 100 92 181 2 1911559440 12131472 26607376
20:08:43 1567 8192000000 10817674720 11210489856 1875933072 18.632 100 82 166 0 1911511232 12416528 23161632
20:08:51 2767 8192000000 10822446992 11212341248 1877280160 18.643 100 86 170 1 1913894720 12080016 24534544
20:09:00 36841 8192000000 10816499472 11207720960 1877988448 18.649 100 68 136 1 1906841856 8415856 20437552
20:09:43 2493 8192000000 10833219936 11224199168 1883442608 18.693 100 96 192 0 1922726608 12581024 26702976
20:09:52 1844 8192000000 10815571392 11221643264 1879253680 18.659 100 62 123 2 1908836288 12969680 16612928
20:10:00 4701 8192000000 10792632224 11214770176 1877755440 18.647 100 48 97 1 1901940608 10626144 13559024
20:10:12 8105 8192000000 10796436048 11214241792 1874422832 18.620 100 26 50 3 1887965456 6274176 7268448
20:10:29 4838 8192000000 10789367056 11212369920 1878006912 18.649 100 26 52 0 1892218544 6348176 7863456
20:10:40 7010 8192000000 10794150800 11219681280 1881301360 18.676 100 30 60 1 1897087888 7033312 8753216
20:10:57 9690 8192000000 10783322720 11220889600 1886086272 18.714 100 17 34 1 1896372928 5600160 4686496
20:11:17 15755 8192000000 10794421696 11226230784 1892278080 18.764 100 34 66 1 1913147616 10362224 10507312
20:11:39 51004 8192000000 10811632656 11236921344 1886961552 18.721 100 15 30 1 1896807456 5395312 4450592
20:12:49 10040 8192000000 10804111712 11238449152 1892773376 18.768 100 20 40 3 1903158768 5170544 5214848
20:13:05 6638 8192000000 10813907136 11239374848 1893207072 18.772 100 24 48 3 1906513008 6563504 6742432
20:13:19 7323 8192000000 10816684576 11247280128 1896871184 18.801 100 34 68 1 1912155424 6370048 8914192
20:13:34 5875 8192000000 10806825392 11240951808 1895177568 18.787 100 28 56 1 1909307072 6077200 8052304
20:13:49 9125 8192000000 10813221152 11247411200 1897426608 18.806 100 18 36 0 1908554544 5682464 5445472
20:14:05 4272 8192000000 10825279824 11250475008 1904368064 18.861 100 39 75 3 1921218864 5853552 10997248
20:14:17 8860 8192000000 10821089488 11253198848 1901778576 18.841 100 20 40 2 1912474832 5165200 5531056
20:14:34 7096 8192000000 10815340240 11253510144 1905459776 18.870 100 24 47 2 1919567648 6661440 7446432
20:14:49 6697 8192000000 10808735072 11247820800 1899685056 18.824 100 18 37 0 1914582544 9408048 5489440
20:15:05 8211 8192000000 10810712800 11247460352 1889736064 18.744 99 18 36 0 1901086128 6166688 5183376
20:15:19 11636 8192000000 10816500512 11254460416 1906016608 18.875 100 17 33 0 1916262768 5337680 4908480
20:15:40 8135 8192000000 10806344512 11246034944 1885830688 18.712 99 24 47 4 1898830848 6217648 6782512
20:15:54 16860 8192000000 10815196352 11231420416 1844006032 18.373 97 14 28 2 1851770592 4251568 3512992
20:16:20 56815 8192000000 10833688896 11249995776 1877306592 18.643 99 29 58 0 1890828864 5982912 7539360
20:17:23 19319 8192000000 10794446064 11229892608 1860047856 18.504 98 18 36 1 1870147840 4816912 5283072
20:17:50 9527 8192000000 10794192624 11230232576 1863271904 18.530 98 27 54 3 1875722080 5609184 6840992
20:18:05 6836 8192000000 10806025776 11236065280 1872954592 18.608 99 27 54 0 1886971760 6248848 7768320
20:18:20 8417 8192000000 10782481056 11198889984 1807603952 18.076 96 25 49 1 1820587792 5484912 7498928
20:18:35 6431 8192000000 10726019968 11143512064 1729596112 17.432 93 17 34 1 1739781712 5506080 4679520
20:18:47 9290 8192000000 10749044240 11167494144 1793072160 17.957 97 25 50 2 1805685552 5922112 6691280
20:19:06 5853 8192000000 10730234464 11153231872 1802003904 18.030 99 29 58 2 1816653216 6453440 8195872
20:19:19 12845 8192000000 10704636224 11123609600 1664848064 16.890 91 13 26 1 1673349376 5099296 3402016
20:19:39 9325 8192000000 10721283952 11139244032 1747984128 17.585 96 21 40 3 1759872320 5505568 6382624
20:19:58 6302 8192000000 10686882608 11104645120 1758877616 17.675 99 28 56 0 1773699808 6419680 8402512
20:20:10 7181 8192000000 10672151760 11071844352 1694196688 17.136 96 41 82 3 1712010400 5783328 12030384
20:20:24 12398 8192000000 10689492992 11100291072 1727784912 17.417 97 13 26 0 1740741488 9388128 3568448
20:20:43 8185 8192000000 10708083856 11118256128 1745333840 17.563 97 29 58 1 1764077632 10135424 8608368
20:21:00 63349 8192000000 10721489952 11108085760 1749063792 17.594 97 36 74 0 1764374832 4175104 11135936
20:22:09 13507 8192000000 10710002784 11133935616 1801970256 18.030 100 21 41 0 1814036976 6317968 5748752
20:22:29 7356 8192000000 10700637088 11125653504 1783075040 17.875 99 16 31 2 1793174816 5943552 4156224
20:22:43 6841 8192000000 10722963904 11144400896 1801184416 18.024 99 35 66 2 1817014256 5858736 9971104
20:22:58 5943 8192000000 10728548544 11146354688 1800930704 18.022 99 27 52 3 1815389056 7260656 7197696
20:23:12 8196 8192000000 10743217328 11165495296 1830114912 18.260 100 24 48 1 1842654624 5240720 7298992
20:23:29 6530 8192000000 10758287360 11178807296 1841538064 18.353 100 30 58 1 1855638976 5168544 8932368
20:23:42 7572 8192000000 10744212080 11176935424 1841476656 18.353 100 14 28 2 1850982640 5827792 3678192
20:23:56 7801 8192000000 10759157648 11186245632 1846321920 18.392 100 23 47 2 1859193888 6012000 6859968
20:24:09 10510 8192000000 10764005856 11191312384 1851379312 18.433 100 23 46 0 1863244032 5587632 6277088
20:24:27 6709 8192000000 10768587152 11192074240 1852552032 18.443 100 29 59 0 1866523504 5101248 8870224
20:24:41 7048 8192000000 10777324192 11203235840 1858325488 18.490 100 14 28 0 1868362016 5257360 4779168
20:25:00 10428 8192000000 10771111152 11204780032 1862698368 18.525 100 22 44 4 1879016736 9464384 6853984
20:25:17 9874 8192000000 10769300336 11202064384 1862302240 18.522 100 17 34 3 1872720384 4994960 5423184
20:25:35 23869 8192000000 10792041984 11212517376 1868185040 18.570 100 17 33 1 1877943696 5616048 4142608
20:26:14 60233 8192000000 10809039008 11232956416 1875025360 18.625 100 27 54 0 1888639376 5684752 7929264
20:27:34 15989 8192000000 10832969648 11251900416 1904382192 18.862 100 41 82 3 1922058992 5671376 12005424
20:28:00 8691 8192000000 10851096240 11266641920 1916514656 18.959 100 45 88 1 1936219024 7036000 12668368
20:28:16 20220 8192000000 10857820384 11277770752 1928628288 19.056 100 50 97 1 1950585776 8273232 13684256
20:28:43 7173 8192000000 10871132080 11289550848 1941299376 19.157 100 63 126 2 1969127216 9417440 18410400
20:28:59 25974 8192000000 10886350096 11304988672 1948975488 19.218 100 64 126 1 1977844336 11236752 17632096
20:29:34 43146 8192000000 10886592640 11318890496 1953732368 19.256 100 50 100 1 1979904624 11813072 14359184
20:30:27 44681 8192000000 10884030432 11321729024 1958466432 19.294 100 36 70 3 1981650496 12685488 10498576
20:31:20 33314 8192000000 10894900864 11330105344 1962705744 19.328 100 35 70 0 1986742928 13541248 10495936
20:32:02 5401 8192000000 10913146688 11331321856 1965477344 19.350 100 60 120 1 1999186528 15557200 18151984
20:32:23 17398 8192000000 10894903888 11328217088 1958800048 19.297 100 45 89 0 1987381840 14938736 13643056
20:32:54 5573 8192000000 10896990288 11324477440 1959221184 19.300 100 52 104 0 1987525248 12793248 15510816
20:33:18 3791 8192000000 10898467328 11321204736 1956758624 19.280 100 64 125 2 1987557056 12610976 18187456
20:33:28 9018 8192000000 10899074400 11328786432 1965579952 19.350 100 52 103 0 1994416960 12822048 16014960
20:33:45 3049 8192000000 10912537600 11334815744 1968995312 19.377 100 61 120 1 2000401760 13794080 17612368
20:33:58 8822 8192000000 10921089728 11339427840 1972757936 19.407 100 63 126 1 2006456448 15472144 18226368
20:34:16 11368 8192000000 10924547136 11347419136 1974459872 19.421 100 66 131 0 2010731904 16763072 19508960
20:34:36 1619 8192000000 10913935184 11336568832 1961191344 19.316 99 66 130 2 1996429856 15496112 19742400
20:34:46 8488 8192000000 10925402288 11352252416 1980886720 19.472 100 60 121 1 2016490032 18042576 17560736
20:35:01 6877 8192000000 10924448576 11346337792 1960701680 19.312 99 72 144 2 2000960976 18963552 21295744
20:35:20 5380 8192000000 10934509904 11354931200 1981420000 19.476 100 76 150 1 2023452128 20827504 21204624
20:35:35 5092 8192000000 10930578000 11354718208 1980819312 19.471 100 69 138 1 2023393920 22371920 20202688
20:35:50 6620 8192000000 10931950288 11364134912 1979458416 19.460 100 49 99 2 2016902016 22277456 15166144
20:36:13 7256 8192000000 10932818144 11371368448 1990531648 19.548 100 60 118 2 2033139488 24103120 18504720
20:36:27 2336 8192000000 10943060336 11369377792 1990710400 19.549 100 80 157 1 2037471056 22660368 24100288
20:36:37 11705 8192000000 10940202496 11375960064 1987933824 19.527 100 56 112 0 2028767168 24105264 16728080
20:36:56 4810 8192000000 10950103520 11378823168 1996289904 19.593 100 72 143 0 2040071168 22366576 21414688
20:37:12 3911 8192000000 10949625632 11384877056 1996606848 19.596 100 50 99 3 2035010208 23511104 14892256
20:37:22 3291 8192000000 10956419520 11382226944 1999233616 19.617 100 62 123 0 2037833600 20448864 18151120
20:37:32 7238 8192000000 10962542448 11384422400 2006813952 19.676 100 75 150 2 2049555632 20462496 22279184
20:37:50 11304 8192000000 10957441392 11389743104 2006104160 19.671 100 56 112 2 2040498848 18038304 16356384
20:38:09 1251 8192000000 10962781792 11386433536 2007118976 19.679 100 72 142 1 2049294064 20220864 21954224
20:38:18 6074 8192000000 10956626912 11392499712 2007941232 19.685 100 64 128 0 2048810896 21675808 19193856
20:38:31 8070 8192000000 10959746144 11398447104 2008712352 19.691 100 53 101 1 2046270240 22533360 15024528
20:38:47 3777 8192000000 10963072784 11393564672 1995404000 19.586 99 65 126 2 2037127616 22977152 18746464
20:38:59 7020 8192000000 10968878992 11399647232 2012182096 19.719 100 62 124 0 2053819536 22825760 18811680
20:39:16 12419 8192000000 10968628080 11406647296 2016748352 19.755 100 54 108 2 2061198576 28214320 16235904
20:39:36 3694 8192000000 10976959520 11406831616 2016349568 19.751 100 72 145 1 2061021280 23100432 21571280
20:39:48 5194 8192000000 10992121024 11420246016 2023787008 19.810 100 77 152 1 2073518656 26905328 22826320
20:40:02 1851 8192000000 10998140080 11427270656 2032072192 19.875 100 73 146 0 2082622496 27586816 22963488
20:40:10 1857 8192000000 11013646848 11431342080 2037743824 19.919 100 85 168 1 2090910624 28148160 25018640
20:40:19 4083 8192000000 11002533648 11427815424 2018391568 19.768 99 83 167 1 2074086512 30560736 25134208
20:40:30 2433 8192000000 10996817312 11415216128 2009180272 19.695 99 86 172 1 2063442976 29899536 24363168
20:40:41 2795 8192000000 10998228096 11418898432 2023820832 19.810 100 85 169 0 2079194752 30646672 24727248
20:40:51 4287 8192000000 10987467808 11402178560 2009485392 19.697 99 83 168 1 2065921232 31321088 25114752
20:41:03 6890 8192000000 10989130848 11413680128 2015406240 19.744 100 72 144 0 2068852384 31968512 21477632
20:41:21 6063 8192000000 10988580304 11410477056 1984349280 19.499 98 76 152 1 2044720928 37554256 22817392
20:41:40 2548 8192000000 10988171472 11412471808 1997207120 19.601 99 67 134 1 2056919616 39554640 20157856
20:41:50 1328 8192000000 10966229536 11381821440 1981395408 19.476 99 84 168 1 2044735088 37618608 25721072
20:41:58 2504 8192000000 10968392432 11388936192 1965257712 19.348 98 84 165 2 2028630128 38782320 24590096
20:42:07 4525 8192000000 10968158448 11389308928 1993810128 19.574 100 82 162 1 2057785104 39731872 24243104
20:42:19 2461 8192000000 10926678032 11333832704 1917871280 18.970 97 73 146 1 1979420800 39087968 22461552
20:42:30 2262 8192000000 10959445552 11372539904 1969583312 19.382 100 83 164 1 2037187344 42430272 25173760
20:42:38 1224 8192000000 10979153424 11387146240 1984651712 19.502 100 90 178 1 2055127360 43126832 27348816
20:42:46 1640 8192000000 10955066352 11369193472 1959635360 19.303 99 82 164 0 2028321824 42695696 25990768
20:42:55 2650 8192000000 10973044304 11384782848 1979658928 19.462 100 82 164 0 2048349744 43271440 25419376
20:43:09 4577 8192000000 10958169280 11371372544 1956309168 19.277 99 86 169 1 2026661920 44548896 25803856
20:43:20 3574 8192000000 10952786144 11362918400 1949635232 19.224 99 77 147 2 2015603504 43331568 22636704
20:43:30 1969 8192000000 10954007168 11365175296 1962225184 19.324 100 76 150 1 2027812896 42672848 22914864
20:43:39 2513 8192000000 10961272592 11375681536 1973369424 19.412 100 76 152 1 2040861344 44462240 23029680
20:43:48 4903 8192000000 10953401792 11365318656 1961263328 19.316 99 80 159 1 2031427120 45641280 24522512
20:44:00 1490 8192000000 10972222736 11382169600 1975806832 19.431 100 89 179 2 2049666288 46859728 26999728
20:44:08 3921 8192000000 10948926768 11360788480 1944990576 19.187 99 77 154 0 2015575120 46932224 23652320
20:44:19 8845 8192000000 10941143296 11365130240 1959203136 19.300 100 63 124 1 2027646272 48947840 19495296
20:44:36 16468 8192000000 10921861520 11351945216 1936969936 19.123 99 40 80 2 1996366096 45864048 13532112
20:45:06 2383 8192000000 10948387808 11370917888 1963347184 19.333 100 53 104 1 2025562384 44352176 17863024
20:45:16 3839 8192000000 10953477840 11367940096 1960689248 19.312 100 77 154 0 2031173168 46400128 24083792
20:45:28 6979 8192000000 10943322688 11360464896 1942095792 19.163 99 67 133 1 2011175328 47998816 21080720
20:45:44 4106 8192000000 10963634688 11374104576 1964998192 19.346 100 84 166 0 2042391968 50736784 26656992
20:45:56 5340 8192000000 10972099536 11390398464 1970147680 19.387 100 71 142 0 2048040944 55655600 22237664
20:46:09 3010 8192000000 10976020192 11398258688 1979079712 19.457 100 74 148 1 2062050880 59101712 23869456
20:46:19 9595 8192000000 10960331408 11390906368 1976084336 19.434 100 61 121 0 2049745296 53625200 20035760
20:46:39 7566 8192000000 10952958288 11391733760 1976938416 19.440 100 44 87 1 2040786720 49631472 14216832
20:46:54 12579 8192000000 10946811360 11392331776 1961007872 19.314 99 38 76 0 2025144560 51026832 13109856
20:47:15 5339 8192000000 10961163888 11386101760 1960786496 19.312 99 55 106 2 2029090240 50781216 17522528
20:47:27 7875 8192000000 10932454256 11368329216 1940996480 19.155 99 40 78 1 2009792896 56334688 12461728
20:47:43 6429 8192000000 10928345664 11359739904 1943560896 19.175 99 38 76 1 2002151584 46178144 12412544
20:48:16 15122 8192000000 10943697168 11378782208 1960328592 19.309 100 36 73 1 2021033248 48933760 11770896
20:48:43 14563 8192000000 10935587936 11378372608 1956511152 19.278 100 33 66 1 2017356000 49738064 11106784
20:49:05 9091 8192000000 10959828896 11388194816 1968851312 19.376 100 39 78 0 2034361312 52181232 13328768
20:49:22 9026 8192000000 10956588352 11394727936 1970506096 19.389 100 37 74 2 2041001696 57317232 13178368
20:50:09 17757 8192000000 10948431296 11404521472 1955014400 19.266 99 27 54 2 2017197632 53037984 9145248
20:50:45 16941 8192000000 10948325376 11395915776 1966094576 19.354 100 29 58 2 2033828496 57305168 10428752
20:51:27 17002 8192000000 10959663968 11403984896 1972465280 19.405 100 30 60 1 2040778128 57489632 10823216
20:51:53 19637 8192000000 10953982640 11400568832 1966010096 19.354 100 27 54 0 2039321024 63225392 10085536
20:52:48 22071 8192000000 10934757776 11399548928 1936088352 19.116 99 24 48 1 2009296848 63913760 9294736
20:53:18 20713 8192000000 10926855808 11381862400 1903872384 18.857 98 21 42 0 1980413200 67807840 8732976
20:53:45 47337 8192000000 10893481536 11375755264 1910837152 18.913 99 13 26 0 1974090832 58112720 5140960
20:54:40 39969 8192000000 10871534624 11320987648 1881247776 18.675 97 11 22 0 1904690496 19806208 3636512
20:55:33 34840 8192000000 10866836304 11329953792 1937352560 19.126 100 21 40 0 1955027488 11117472 6557456
20:56:37 53089 8192000000 10865808848 11321008128 1894323504 18.781 97 19 37 5 1906381040 7307312 4750224
20:57:38 28245 8192000000 10911376416 11335958528 1939362720 19.142 99 51 99 0 1960280128 7343728 13573680
20:58:13 103852 8192000000 10907679552 11352317952 1941956464 19.162 99 29 58 1 1961208400 10870176 8381760
21:00:06 72334 8192000000 10887901648 11346399232 1937612656 19.128 98 52 101 2 1962328576 10372992 14342928
21:01:28 58165 8192000000 10887100992 11350913024 1953913392 19.258 99 24 48 1 1971964496 10855792 7195312
21:02:33 110541 8192000000 10898506432 11361140736 1921296800 18.997 97 18 36 0 1935738656 8770048 5671808
21:04:30 22443 8192000000 10908230480 11371028480 1978724848 19.455 100 20 40 2 1996414592 11653040 6036704
21:04:59 46443 8192000000 10898348368 11366129664 1964251920 19.340 99 37 73 1 1995268640 19712176 11304544
21:05:59 39531 8192000000 10869060608 11343982592 1937842512 19.130 98 13 27 1 1957608928 15638160 4128256
21:06:46 38394 8192000000 10886622896 11366293504 1965956928 19.353 100 7 14 0 1981535264 13553360 2024976
21:07:33 25492 8192000000 10886681312 11360604160 1950554080 19.231 99 10 20 0 1967820416 14409648 2856688
21:08:08 22317 8192000000 10893612176 11365687296 1970340912 19.388 100 16 33 0 1988619008 13200448 5077648
21:08:45 33472 8192000000 10903011344 11372224512 1957579408 19.287 99 21 42 1 1979681472 15941984 6160080
21:09:24 64165 8192000000 10900836800 11353788416 1955536080 19.271 99 9 18 2 1970481680 12669504 2276096
21:10:36 28539 8192000000 10906680048 11376525312 1980840112 19.471 100 13 27 2 1999332208 14683872 3808224
21:11:11 46022 8192000000 10902900400 11378319360 1966467936 19.357 99 26 52 1 1986290656 11797248 8025472
21:12:03 21557 8192000000 10923987328 11392327680 1983525552 19.493 100 15 30 1 2006274848 17969360 4779936
21:13:46 73285 8192000000 10918546032 11387461632 1990992304 19.552 100 19 38 1 2010363584 13198624 6172656
21:16:03 54375 8192000000 10888232224 11370827776 1922357408 19.006 97 7 14 1 1940673184 15853424 2462352
21:17:03 45765 8192000000 10883654992 11350016000 1944980320 19.186 99 23 48 1 1963002928 11392928 6629680
21:17:56 48737 8192000000 10912766720 11379101696 1972956608 19.409 100 17 34 1 1991925376 14214768 4754000
21:18:53 31681 8192000000 10904876560 11367108608 1946529216 19.199 98 21 42 0 1963029360 10642640 5857504
21:19:31 43406 8192000000 10883174224 11365908480 1952223104 19.244 99 12 24 1 1967302112 11371248 3707760
21:21:07 25239 8192000000 10923434640 11372773376 1946884080 19.202 98 60 120 5 1974571120 10705680 16981360
21:21:39 25006 8192000000 10903545200 11356442624 1933038240 19.091 98 45 88 0 1959435920 13918208 12479472
21:22:24 68655 8192000000 10890329600 11365728256 1911781456 18.921 97 28 56 0 1935871952 16216880 7873616
21:23:52 58806 8192000000 10904861424 11356950528 1924308800 19.021 98 21 42 1 1938432256 7838960 6284496
21:25:00 27147 8192000000 10912786976 11363500032 1939616000 19.144 98 48 96 2 1963376928 10498416 13262512
21:25:36 66116 8192000000 10886776864 11339124736 1832495792 18.280 93 21 42 2 1856421392 17845440 6080160
21:26:52 59304 8192000000 10881287696 11360403456 1922828464 19.009 99 10 20 0 1944563088 19148160 2586464
21:27:58 77550 8192000000 10867921616 11347558400 1892332944 18.765 97 8 16 0 1909345952 15063600 1949408
21:29:21 90731 8192000000 10854763200 11314536448 1834382816 18.295 94 24 48 0 1852315712 11544304 6388592
21:30:59 64270 8192000000 10888113264 11346841600 1927977520 19.051 99 34 66 0 1950419632 12566048 9876064
21:32:55 42537 8192000000 10850175536 11330666496 1922393760 19.006 99 12 24 2 1934814064 8620304 3800000
21:33:50 79224 8192000000 10856742896 11318919168 1865414384 18.547 96 12 25 0 1875951376 7110912 3426080
21:35:21 58138 8192000000 10874127584 11327918080 1922678624 19.008 99 11 22 1 1933878784 7860864 3339296
21:36:36 86124 8192000000 10858648608 11325915136 1920610224 18.992 98 19 38 1 1933393152 6899136 5883792
21:38:13 39488 8192000000 10873747888 11335819264 1919962480 18.987 98 24 48 0 1936813184 9517936 7332768
21:39:05 5084 8192000000 10880275616 11341291520 1954840736 19.265 100 36 72 2 1976655680 10972640 10842304
21:39:19 13313 8192000000 10871442512 11341127680 1939087216 19.139 99 29 59 2 1957836272 10034512 8714544
21:39:46 24493 8192000000 10847294512 11315765248 1930042160 19.067 99 13 24 3 1941362992 7774928 3545904
21:40:23 37624 8192000000 10869048560 11340640256 1936200752 19.116 99 17 32 3 1947533424 6670720 4661952
21:41:14 59574 8192000000 10866923744 11335991296 1908440096 18.894 97 24 48 3 1923852688 8701680 6710912
21:42:21 78742 8192000000 10868987616 11351441408 1954061728 19.259 100 20 40 0 1968225536 8009696 6154112
21:43:58 72522 8192000000 10885418944 11346173952 1916032400 18.955 98 8 16 1 1930093344 11908672 2152272
21:45:17 49823 8192000000 10897298896 11364655104 1929965312 19.067 98 26 52 1 1952852048 15332448 7554288
21:46:14 46814 8192000000 10894223920 11355779072 1915351232 18.950 97 31 63 0 1941721504 17026768 9343504
21:47:09 69824 8192000000 10889905424 11357204480 1920678144 18.992 98 9 18 0 1940414176 16780736 2955296
21:48:36 55160 8192000000 10878492576 11353788416 1903599600 18.855 97 20 40 1 1926767200 17164240 6003360
21:50:06 57405 8192000000 10878616400 11355832320 1951381248 19.237 100 15 30 2 1968157744 12413984 4362512
21:51:09 44409 8192000000 10896384128 11358687232 1930480848 19.071 98 32 64 1 1947877680 9179872 8216960
21:52:00 23590 8192000000 10904772448 11352383488 1946316832 19.197 99 40 79 0 1966706096 9686464 10702800
21:52:41 12844 8192000000 10918479488 11358941184 1966672800 19.359 100 54 107 1 1991058656 9517600 14868256
21:53:00 25337 8192000000 10913492784 11370205184 1971098288 19.394 100 40 80 2 1993850208 11545712 11206208
21:53:34 26094 8192000000 10913676832 11370770432 1953997536 19.258 99 33 66 1 1979828784 17008672 8822576
21:54:13 25990 8192000000 10915388608 11378921472 1962714752 19.328 99 43 85 2 1987271312 11972752 12583808
21:54:54 46022 8192000000 10905476304 11384479744 1955125552 19.267 99 17 34 1 1979144464 19073952 4944960
21:55:47 53670 8192000000 10907270880 11381129216 1956551952 19.279 99 6 12 0 1974170112 16058640 1559520
21:56:59 88074 8192000000 10922481344 11376185344 1983768496 19.495 100 39 78 2 2004166448 9988352 10409600
21:58:34 10183 8192000000 10921765472 11377197056 1991334416 19.554 100 36 73 0 2009005152 8034560 9636176
21:58:51 52224 8192000000 10890916272 11364478976 1956972960 19.282 98 24 44 1 1974074336 9951520 7149856
21:59:56 61197 8192000000 10901813600 11385708544 1989213328 19.538 100 8 16 1 2001102000 10015376 1873296
22:01:08 68465 8192000000 10908669584 11388825600 1966194704 19.355 99 15 30 0 1978840400 8839744 3805952
22:02:23 69071 8192000000 10875733440 11351896064 1869220784 18.578 94 11 22 0 1884662992 12787584 2654624
22:03:41 60329 8192000000 10881576736 11346497536 1872738656 18.606 95 12 24 0 1887498896 11701872 3058368
22:04:47 41680 8192000000 10902108032 11370930176 1950012224 19.227 99 17 34 0 1966751472 11707264 5031984
22:05:36 40964 8192000000 10904640752 11362975744 1933498272 19.095 98 21 43 0 1950822320 11068672 6255376
22:06:32 50219 8192000000 10865839488 11350155264 1901147680 18.836 97 23 46 1 1923637104 15649952 6839472
22:07:35 59461 8192000000 10887803632 11349454848 1920300576 18.989 98 16 32 0 1940398432 15448784 4649072
22:09:11 84708 8192000000 10896097104 11360940032 1890941856 18.753 96 18 36 0 1907424928 11516560 4966512
22:10:42 101957 8192000000 10902434112 11378868224 1926487312 19.039 98 13 26 1 1946965520 16996816 3481392
22:12:49 28767 8192000000 10900170736 11348328448 1892838784 18.769 96 36 72 0 1913002528 10363936 9799808
22:13:24 10059 8192000000 10908602320 11349229568 1955097696 19.267 100 58 113 0 1982105728 11632560 15375472
22:13:40 29246 8192000000 10900633152 11361079296 1961695728 19.320 100 44 88 1 1986788672 13156176 11936768
22:14:23 25025 8192000000 10888988208 11343507456 1920081712 18.987 98 28 56 0 1938492496 10478592 7932192
22:15:32 110811 8192000000 10859906432 11329048576 1895634208 18.791 97 34 68 0 1914729360 9124032 9971120
22:18:06 47928 8192000000 10850399648 11330293760 1906116848 18.875 98 11 22 0 1920515728 11348528 3050352
22:19:02 50714 8192000000 10825468992 11289325568 1860438336 18.507 96 8 16 0 1870756768 8215808 2102624
22:20:11 36077 8192000000 10837826176 11313426432 1908253280 18.893 99 9 18 0 1917795456 6128256 3413920
22:21:00 70093 8192000000 10836988928 11319255040 1912301712 18.925 99 12 24 0 1923331616 7508000 3521904
22:22:29 55839 8192000000 10866248416 11348013056 1946803264 19.201 100 19 38 4 1961362816 9336032 5223520
22:23:39 65693 8192000000 10849104528 11315056640 1872208880 18.602 96 11 22 0 1882577840 7408544 2960416
22:25:03 64381 8192000000 10866425824 11338428416 1907754816 18.889 98 17 33 0 1920068672 8207472 4106384
22:26:19 59457 8192000000 9824910624 10182475776 942087872 10.313 49 7 14 0 949657120 5986352 1582896

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-01-2021 22:28:38 to 08-01-2021 22:29:10.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 75 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

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

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          243035
MON$OLDEST_ACTIVE               243036
MON$OLDEST_SNAPSHOT             243036
MON$NEXT_TRANSACTION            243036
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                       2031264
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:584: 
:585: mscs-test-161.budzdorov.ru    Fri Jan  8 22:27:25 2021
:586:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:587: 
--- end of diff output ---

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

08.01.21 22:29:14. 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-01-08 22:29:16 No severe PSQL-related problems occured
08.01.21 22:29:18. End of report.