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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17572936 kB
MemAvailable 31586252 kB
Buffers 0 kB
Cached 14125480 kB
SwapCached 1988 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-12-07 16:27:07
DTS_END                         2020-12-07 16:27:07.1920
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/50488
TRN_ID                          250339
ATT_ID                          729
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: 9764.00 17878 1171680
customer order: creation 178.29 343 21395
customer order: refuse 15.41 249 1849
order to supplier: creation 47.37 1048 5684
order to supplier: removal 3.79 79352 455
invoice (draft): creation 46.97 2624 5636
invoice (draft): removal 56.33 609 6759
invoice accept: apply 43.88 16018 5265
invoice accept: cancel 51.34 713 6161
customer reserve: creation 3975.50 163 477060
customer reserve: removal 5036.30 48 604356
realization accept: apply 87.34 165 10481
realization accept: cancel 87.99 101 10559
payment from customer: creation 61.08 101 7330
payment from customer: removal 5.78 85 694
payment to supplier: creation 50.75 122 6090
payment to supplier: removal 3.50 65 420
service: total inventory turnovers 4.68 1075 561
service: total monetary turnovers 6.78 21 814
service: aggregate perf. data 0.89 16495 107
service: refresh index statistics 0.03 238160 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-12-2020 16:28:43 to 07-12-2020 16:28:45.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6286
TEST_TIME 2 6859
TEST_TIME 3 6624
TEST_TIME 4 6349
TEST_TIME 5 6662
TEST_TIME 6 7226
TEST_TIME 7 8346
TEST_TIME 8 8444
TEST_TIME 9 9096
TEST_TIME 10 8887
TEST_TIME 11 8984
TEST_TIME 12 9258
TEST_TIME 13 9547
TEST_TIME 14 10105
TEST_TIME 15 10273
TEST_TIME 16 11006
TEST_TIME 17 10628
TEST_TIME 18 10732
TEST_TIME 19 11676
TEST_TIME 20 12380
TEST_TIME 21 13472
TEST_TIME 22 12915
TEST_TIME 23 12519
TEST_TIME 24 12575
TEST_TIME 25 12323
TEST_TIME 26 12103
TEST_TIME 27 11827
TEST_TIME 28 11605
TEST_TIME 29 11463
TEST_TIME 30 11360
TEST_TIME 31 11100
TEST_TIME 32 10967
TEST_TIME 33 10902
TEST_TIME 34 10762
TEST_TIME 35 10706
TEST_TIME 36 10873
TEST_TIME 37 10919
TEST_TIME 38 10817
TEST_TIME 39 10710
TEST_TIME 40 10724
TEST_TIME 41 10951
TEST_TIME 42 10853
TEST_TIME 43 10796
TEST_TIME 44 10947
TEST_TIME 45 10849
TEST_TIME 46 10806
TEST_TIME 47 10868
TEST_TIME 48 10830
TEST_TIME 49 10724
TEST_TIME 50 10626
TEST_TIME 51 10504
TEST_TIME 52 10423
TEST_TIME 53 10443
TEST_TIME 54 10334
TEST_TIME 55 10297
TEST_TIME 56 10202
TEST_TIME 57 10105
TEST_TIME 58 10007
TEST_TIME 59 10072
TEST_TIME 60 10031
TEST_TIME 61 10125
TEST_TIME 62 10166
TEST_TIME 63 10162
TEST_TIME 64 10187
TEST_TIME 65 10236
TEST_TIME 66 10146
TEST_TIME 67 10161
TEST_TIME 68 10165
TEST_TIME 69 10116
TEST_TIME 70 10055
TEST_TIME 71 10254
TEST_TIME 72 10316
TEST_TIME 73 10257
TEST_TIME 74 10151
TEST_TIME 75 10100
TEST_TIME 76 10105
TEST_TIME 77 10056
TEST_TIME 78 10043
TEST_TIME 79 9968
TEST_TIME 80 9922
TEST_TIME 81 9913
TEST_TIME 82 9920
TEST_TIME 83 9899
TEST_TIME 84 9875
TEST_TIME 85 9844
TEST_TIME 86 9915
TEST_TIME 87 9909
TEST_TIME 88 9894
TEST_TIME 89 9915
TEST_TIME 90 9975
TEST_TIME 91 10018
TEST_TIME 92 10057
TEST_TIME 93 10069
TEST_TIME 94 10079
TEST_TIME 95 10130
TEST_TIME 96 10078
TEST_TIME 97 10004
TEST_TIME 98 9960
TEST_TIME 99 9924
TEST_TIME 100 9936
TEST_TIME 101 9887
TEST_TIME 102 9872
TEST_TIME 103 9831
TEST_TIME 104 9770
TEST_TIME 105 9790
TEST_TIME 106 9816
TEST_TIME 107 9777
TEST_TIME 108 9795
TEST_TIME 109 9812
TEST_TIME 110 9801
TEST_TIME 111 9761
TEST_TIME 112 9829
TEST_TIME 113 9834
TEST_TIME 114 9803
TEST_TIME 115 9840
TEST_TIME 116 9827
TEST_TIME 117 9845
TEST_TIME 118 9914
TEST_TIME 119 9851
TEST_TIME 120 9770

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-12-2020 16:28:47 to 07-12-2020 16:28:50.

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 1615248 1615248 0 0.00 0 19338 6 0 0
doc_list_biud 1615241 1615241 0 0.00 0 52506 23 0 0
sp_add_invoice_to_stock 5360 5265 95 1.77 29 154709 16018 0 95
sp_cancel_adding_invoice 6161 6161 0 0.00 5 56986 713 0 0
sp_cancel_client_order 1849 1849 0 0.00 4 7576 250 0 0
sp_cancel_customer_reserve 604356 604356 0 0.00 1 52507 48 0 0
sp_cancel_pay_from_customer 694 694 0 0.00 3 5416 86 0 0
sp_cancel_pay_to_supplier 420 420 0 0.00 3 5181 65 0 0
sp_cancel_supplier_invoice 6767 6759 8 0.11 2 18168 609 0 8
sp_cancel_supplier_order 455 455 0 0.00 9 896144 79352 0 0
sp_cancel_write_off 10559 10559 0 0.00 1 12849 102 0 0
sp_client_order 21395 21395 0 0.00 3 12896 344 0 0
sp_customer_reserve 477060 477060 0 0.00 0 108010 163 0 0
sp_fill_shopping_cart 32710 32710 0 0.00 1 26395 35 0 0
sp_fill_shopping_cart_clo_res 477048 477048 0 0.00 0 11812 12 0 0
sp_get_clo_for_invoice 5253 5253 0 0.00 0 14595 269 0 0
sp_kill_cost_storno 17834 17834 0 0.00 0 7596 43 0 0
sp_kill_qstorno_ret_qs2qd 1226485 1226485 0 0.00 0 52499 26 0 0
sp_kill_qty_storno 645866 645866 0 0.00 0 52506 56 0 0
sp_lock_selected_doc 21801 21801 0 0.00 0 7503 7 0 0
sp_make_cost_storno 29154 29154 0 0.00 0 19322 46 0 0
sp_multiply_rows_for_pdistr 29149 29149 0 0.00 0 7477 23 0 0
sp_multiply_rows_for_qdistr 21395 21395 0 0.00 0 11708 166 0 0
sp_pay_from_customer 7330 7330 0 0.00 4 10392 101 0 0
sp_pay_to_supplier 6090 6090 0 0.00 4 19357 123 0 0
sp_payment_common 13420 13420 0 0.00 1 9845 28 0 0
sp_qd_handle_on_cancel_clo 1849 1849 0 0.00 0 6886 217 0 0
sp_qd_handle_on_invoice_upd_sts 11409 11409 0 0.00 0 19918 262 0 0
sp_qd_handle_on_reserve_upd_sts 10479 10479 0 0.00 0 10879 61 0 0
sp_reserve_write_off 10481 10481 0 0.00 6 16922 165 0 0
sp_supplier_invoice 5636 5636 0 0.00 6 96473 2624 0 0
sp_supplier_order 5684 5684 0 0.00 5 31515 1049 0 0
srv_aggregate_perf_data 108 107 1 0.92 2944 121714 16496 0 1
srv_fill_mon_cache_memory 144 144 0 0.00 1010 164309 38553 0 0
srv_find_qd_qs_mism 1123294 1123294 0 0.00 0 11606 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 49 59008 1076 0 0
srv_make_money_saldo 814 814 0 0.00 1 1342 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 167973 327911 238161 0 0
t$perf-abend:sp_add_invoice_to_stock 95 95 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 5266 5266 0 0.00 0 20580 131 0 0
t$perf-norm:sp_cancel_adding_invoice 445 445 0 0.00 0 8891 119 0 0
t$perf-norm:sp_cancel_client_order 1849 1849 0 0.00 0 1712 8 0 0
t$perf-norm:sp_cancel_customer_reserve 747 747 0 0.00 0 374 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 694 694 0 0.00 0 3669 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 420 420 0 0.00 0 764 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 417 417 0 0.00 0 3233 25 0 0
t$perf-norm:sp_cancel_supplier_order 455 455 0 0.00 0 37462 1375 0 0
t$perf-norm:sp_cancel_write_off 1047 1047 0 0.00 0 901 4 0 0
t$perf-norm:sp_client_order 21395 21395 0 0.00 0 15845 15 0 0
t$perf-norm:sp_customer_reserve 1080 1080 0 0.00 0 447 2 0 0
t$perf-norm:sp_pay_from_customer 7330 7330 0 0.00 0 10590 13 0 0
t$perf-norm:sp_pay_to_supplier 6090 6090 0 0.00 0 7060 11 0 0
t$perf-norm:sp_reserve_write_off 10481 10481 0 0.00 0 16079 10 0 0
t$perf-norm:sp_supplier_invoice 5636 5636 0 0.00 0 9670 16 0 0
t$perf-norm:sp_supplier_order 5684 5684 0 0.00 0 10326 14 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 588 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 144 144 0 0.00 0 46 1 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 525 10 0 0
t$perf-norm:srv_make_money_saldo 814 814 0 0.00 0 1677 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10686 10496 190 1.77 0 6294 19 0 190
v_all_customers 38802 38802 0 0.00 0 17 0 0 0
v_all_suppliers 31654 31654 0 0.00 0 106 1 0 0
v_all_wares 42790 42790 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 890 890 0 0.00 0 1398 8 0 0
v_cancel_client_order 3698 3698 0 0.00 0 2298 5 0 0
v_cancel_customer_prepayment 1388 1388 0 0.00 0 5391 14 0 0
v_cancel_customer_reserve 1494 1494 0 0.00 0 1312 4 0 0
v_cancel_payment_to_supplier 840 840 0 0.00 0 674 4 0 0
v_cancel_supplier_invoice 850 834 16 1.88 0 3826 18 0 16
v_cancel_supplier_order 910 910 0 0.00 0 4378 9 0 0
v_cancel_write_off 2094 2094 0 0.00 0 2894 16 0 0
v_max_id_clo_ord 5681 5681 0 0.00 0 163 1 0 0
v_max_id_clo_res 1080 1080 0 0.00 0 1336 7 0 0
v_max_id_ord_sup 5634 5634 0 0.00 0 6128 6 0 0
v_max_non_paid_invoice 1578 1578 0 0.00 0 716 3 0 0
v_max_non_paid_realizn 4136 4136 0 0.00 0 6588 4 0 0
v_min_id_clo_ord 5681 5681 0 0.00 0 10701 8 0 0
v_min_id_clo_res 1080 1080 0 0.00 0 6018 22 0 0
v_min_id_ord_sup 5634 5634 0 0.00 0 7729 9 0 0
v_min_non_paid_invoice 6090 6090 0 0.00 0 7474 17 0 0
v_min_non_paid_realizn 7330 7330 0 0.00 0 6685 18 0 0
v_our_firm 10376 10376 0 0.00 0 137 1 0 0
v_reserve_write_off 20958 20958 0 0.00 0 4881 6 0 0
x_lock_depdocs_on_canc_invoice 12503 12503 0 0.00 0 24892 110 0 0
x_lock_depdocs_on_canc_sup_ord 455 455 0 0.00 0 12420 254 0 0
x_make_qstorno_1000_1200 5684 5684 0 0.00 1 20074 980 0 0
x_make_qstorno_1200_2000 5636 5636 0 0.00 2 91656 2499 0 0
x_make_qstorno_2100_3300 477060 477060 0 0.00 0 108008 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-12-2020 16:28:51 to 07-12-2020 16:28:55.

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:09 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:15 18412 8192000000 10280467632 10593325056 937688496 10.270 72 57 113 1 959723856 2785152 19250208
13:57:42 32346 8192000000 10363776176 10685722624 1414751776 14.726 100 84 168 0 1446717248 5165360 26800112
13:58:27 15715 8192000000 10401990160 10728099840 1455243488 15.084 100 88 177 0 1490827888 6986192 28598208
13:58:50 22669 8192000000 10424898384 10756198400 1482887248 15.327 100 93 186 0 1520674112 8134144 29652720
13:59:25 18410 8192000000 10448753200 10784776192 1501282480 15.487 100 89 178 0 1538226688 8675984 28268224
13:59:54 28792 8192000000 10474664400 10811527168 1525670256 15.699 100 91 182 0 1563914160 9392976 28850928
14:00:31 14559 8192000000 10483715456 10823774208 1536962256 15.797 100 86 172 1 1573875024 9735936 27176832
14:00:53 18087 8192000000 10495676224 10841088000 1555774416 15.960 100 85 170 0 1593032400 10330976 26927008
14:01:19 15559 8192000000 10523579696 10872655872 1581212176 16.179 100 84 168 0 1617626288 10793408 25620704
14:01:41 14588 8192000000 10544278720 10901213184 1601808288 16.355 100 80 161 1 1636955072 11148208 23998576
14:02:05 10989 8192000000 10583184224 10940755968 1638470688 16.667 100 89 178 1 1676575456 11412544 26692224
14:02:26 11551 8192000000 10589896624 10954571776 1649090944 16.757 100 74 148 3 1683050288 11667808 22291536
14:02:48 9643 8192000000 10615056448 10978770944 1673160576 16.960 100 83 166 3 1710928960 12961840 24806544
14:03:05 10096 8192000000 10629750544 10996744192 1685680992 17.065 100 81 162 5 1722504672 12888576 23935104
14:03:23 8669 8192000000 10638556624 11011903488 1700935728 17.193 100 82 164 0 1737547120 12864800 23746592
14:03:43 6636 8192000000 10644836288 11023007744 1709744352 17.267 100 78 156 1 1744773760 12256544 22772864
14:03:57 4532 8192000000 10661080176 11034660864 1719594752 17.349 100 78 154 3 1754589440 12563264 22431424
14:04:10 5510 8192000000 10670095616 11043786752 1736975328 17.494 100 83 166 0 1774519728 14079456 23464944
14:04:26 5907 8192000000 10690897040 11071954944 1756634656 17.657 100 84 164 2 1792577136 12667488 23274992
14:04:38 5884 8192000000 10705196736 11085058048 1765086592 17.726 100 76 153 0 1799905120 13534256 21284272
14:04:51 5269 8192000000 10713859664 11096645632 1776212480 17.818 100 83 166 0 1812981024 12923952 23844592
14:05:04 10050 8192000000 10720253392 11106082816 1781023840 17.858 100 65 130 0 1811088480 11768192 18296448
14:05:23 2321 8192000000 10738942000 11124322304 1805738448 18.061 100 77 153 3 1840693520 12436480 22518592
14:05:31 3583 8192000000 10753904096 11139395584 1817064896 18.154 100 79 158 0 1852406592 12839472 22502224
14:05:42 2075 8192000000 10766793280 11150499840 1823953600 18.210 100 83 166 0 1860794576 13482064 23358912
14:05:51 1733 8192000000 10776868080 11161178112 1832630656 18.281 100 89 178 2 1871777984 13892992 25254336
14:05:59 2136 8192000000 10781193568 11170222080 1840510896 18.345 100 86 172 2 1878730864 13889440 24330528
14:06:07 1485 8192000000 10786333344 11173519360 1845583376 18.386 100 96 192 0 1886446880 13270320 27593184
14:06:15 1433 8192000000 10782730464 11173449728 1849939744 18.422 100 93 183 2 1888276000 12820272 25515984
14:06:23 2288 8192000000 10800766192 11186896896 1853312336 18.449 100 98 196 0 1894012288 12900448 27799504
14:06:32 2113 8192000000 10799432128 11191713792 1856627520 18.476 100 90 180 0 1896297632 13526752 26143360
14:06:40 1533 8192000000 10801021072 11191074816 1857926224 18.486 100 86 172 2 1896103248 14564704 23612320
14:06:49 1321 8192000000 10807193232 11197169664 1860159568 18.505 100 84 166 0 1897995184 15202656 22632960
14:06:57 1465 8192000000 10796740784 11194388480 1865656912 18.549 100 82 165 0 1902143520 13376400 23110208
14:07:04 2683 8192000000 10810383904 11198873600 1864412720 18.539 100 88 173 1 1902273120 12936400 24924000
14:07:14 6950 8192000000 10811628576 11202007040 1869519488 18.580 100 77 154 2 1903463248 11956128 21987632
14:07:27 19563 8192000000 10788456208 11201089536 1865041376 18.544 100 56 110 1 1889849312 9162336 15645600
14:07:53 4134 8192000000 10780062288 11198816256 1865158336 18.545 100 46 91 0 1886254416 7904208 13191872
14:08:03 4126 8192000000 10778099808 11202793472 1867447488 18.564 100 48 96 1 1890422272 9477248 13497536
14:08:14 4994 8192000000 10781249824 11203821568 1868228640 18.570 100 34 68 0 1885466720 7909248 9328832
14:08:25 5233 8192000000 10782105840 11201314816 1868499344 18.572 100 28 56 0 1883272608 7058176 7715088
14:08:39 8150 8192000000 10781195792 11205226496 1869341856 18.579 100 17 34 1 1879589056 5096720 5150480
14:08:53 5755 8192000000 10785210976 11216908288 1877354336 18.644 100 33 67 3 1898177216 11635120 9187760
14:09:05 8955 8192000000 10781298912 11213942784 1879951408 18.665 100 18 36 1 1890580400 5927504 4701488
14:09:21 11450 8192000000 10782001072 11219259392 1878034096 18.649 100 12 24 0 1887239744 5492384 3713264
14:09:39 7912 8192000000 10803506032 11226669056 1884678320 18.703 100 26 49 4 1898083056 6614880 6789856
14:09:53 14210 8192000000 10793658256 11225178112 1886319920 18.716 100 16 32 2 1897012768 6630064 4062784
14:10:18 9388 8192000000 10796402976 11231961088 1891873584 18.761 100 22 42 2 1904065056 6355312 5836160
14:10:34 5889 8192000000 10801025984 11232874496 1893367088 18.773 100 21 43 1 1905627664 5702944 6557632
14:10:46 65970 8192000000 10832020016 11252781056 1904524816 18.863 100 32 66 3 1919227680 4954592 9748272
14:11:59 21527 8192000000 10823017856 11252903936 1906069264 18.875 100 24 48 2 1919371248 5942768 7359216
14:12:28 11173 8192000000 10813764416 11251294208 1903045392 18.851 100 20 40 1 1914369632 5726000 5598240
14:12:45 4743 8192000000 10827714000 11257032704 1907056752 18.883 100 39 80 0 1926526720 7827920 11642048
14:12:56 7446 8192000000 10836329760 11260284928 1907934016 18.890 100 32 64 1 1923202352 5838000 9430336
14:13:10 5836 8192000000 10831326816 11264172032 1908404752 18.894 100 18 36 0 1919634656 5645360 5584544
14:13:22 4622 8192000000 10840673712 11272048640 1915775328 18.953 100 39 71 1 1935460992 8962928 10722736
14:13:34 10523 8192000000 10827561376 11266568192 1914949040 18.946 100 24 48 0 1928857904 7130752 6778112
14:13:50 10783 8192000000 10828411552 11266560000 1914094384 18.940 100 12 24 0 1922945312 5115312 3735616
14:14:08 11196 8192000000 10818880288 11269439488 1916186288 18.956 100 16 32 1 1926390304 5738240 4465776
14:14:25 4016 8192000000 10807429664 11236560896 1889939888 18.745 99 22 44 1 1901343856 5034368 6369600
14:14:36 6262 8192000000 10837775328 11273744384 1915044000 18.947 100 28 56 1 1935402448 11049520 9308928
14:14:51 5619 8192000000 10826947264 11264552960 1912034944 18.923 100 26 52 2 1925619248 6581536 7002768
14:15:05 9891 8192000000 10832798096 11263733760 1897282224 18.804 99 17 33 1 1907923696 5854304 4787168
14:15:23 8118 8192000000 10822617952 11251781632 1870984736 18.592 98 24 49 0 1888067088 9838768 7243584
14:15:40 59623 8192000000 10826341520 11244687360 1854546128 18.459 97 44 86 1 1872473200 4742528 13184544
14:16:45 15270 8192000000 10785955808 11220697088 1822897504 18.201 96 18 37 3 1833043920 5194176 4952240
14:17:07 11531 8192000000 10772493488 11197804544 1795391104 17.976 95 28 56 0 1810291296 6610256 8289936
14:17:25 5737 8192000000 10697901312 11110252544 1724164912 17.387 94 29 58 2 1739382896 6963248 8254736
14:17:38 7761 8192000000 10716658816 11137990656 1776932416 17.824 97 26 51 1 1793833952 9346480 7555056
14:17:54 4102 8192000000 10730349264 11144962048 1785208992 17.892 98 33 65 2 1801427920 6725888 9493040
14:18:06 6161 8192000000 10744590480 11171561472 1833532144 18.288 100 23 46 1 1846934208 6988112 6413952
14:18:22 6171 8192000000 10736529936 11164606464 1825237552 18.220 100 23 46 1 1837551840 5309552 7004736
14:18:35 16576 8192000000 10735537920 11155841024 1783375024 17.877 98 25 49 3 1804212944 13881664 6956256
14:19:01 7618 8192000000 10714714128 11129737216 1767125584 17.743 98 28 55 2 1782451904 6224368 9101952
14:19:15 7940 8192000000 10710401408 11122053120 1767849264 17.749 99 21 41 2 1779236784 5364928 6022592
14:19:29 7742 8192000000 10671778080 11094683648 1726714480 17.408 97 15 31 0 1736992432 5567760 4710192
14:19:44 5699 8192000000 10675272704 11087921152 1722639504 17.374 97 22 44 0 1734872352 5871008 6361840
14:20:00 10147 8192000000 10692684176 11102834688 1743468304 17.547 97 29 56 2 1757344992 5078832 8797856
14:20:21 67627 8192000000 10694742352 11118653440 1729393216 17.430 96 27 52 1 1743161888 5218384 8550288
14:21:35 12028 8192000000 10736872144 11155267584 1809827408 18.094 100 30 60 1 1824700768 6900320 7973040
14:21:57 5336 8192000000 10757919632 11169636352 1829031488 18.251 100 35 69 1 1845051328 7107824 8912016
14:22:11 8244 8192000000 10746867216 11174076416 1837524240 18.321 100 43 86 1 1856040272 5320032 13196000
14:22:27 5148 8192000000 10754920544 11180118016 1842450144 18.361 100 33 66 1 1858050144 6172752 9427248
14:22:40 5345 8192000000 10756202960 11184816128 1847730464 18.404 100 24 48 1 1861537776 6713824 7093488
14:22:56 9326 8192000000 10764260112 11192729600 1848978496 18.414 100 24 48 3 1862069664 5135776 7955392
14:23:14 7488 8192000000 10768362176 11195211776 1853469088 18.450 100 32 64 0 1869453728 6182192 9802448
14:23:29 12213 8192000000 10768588048 11196166144 1852903104 18.446 100 18 36 3 1864239664 5407872 5928688
14:23:48 14737 8192000000 10766183360 11196690432 1854847872 18.461 100 12 24 1 1863668384 5459520 3360992
14:24:12 9396 8192000000 10767300512 11200376832 1858033840 18.487 100 27 54 3 1871409744 5748320 7627584
14:24:32 9329 8192000000 10777825632 11208495104 1860808528 18.510 100 16 32 0 1871086160 5665376 4612256
14:24:49 13763 8192000000 10766951440 11206156288 1863774064 18.534 100 16 33 0 1873965408 5494288 4697056
14:25:10 67949 8192000000 10787361984 11217821696 1868591184 18.573 100 35 70 3 1883744032 5452960 9699888
14:26:31 12854 8192000000 10783100336 11214327808 1867919072 18.567 100 17 34 0 1878048256 5666032 4463152
14:26:54 6052 8192000000 10795206528 11220946944 1878904336 18.656 100 38 76 2 1895861216 6719088 10237792
14:27:08 27643 8192000000 10839721728 11254804480 1898244112 18.812 100 48 93 0 1917717936 6766176 12707648
14:27:44 21786 8192000000 10854556080 11270172672 1918609072 18.976 100 67 133 2 1946946832 9933152 18404608
14:28:15 7220 8192000000 10876540528 11288346624 1931025216 19.075 100 71 139 3 1963546608 13115456 19405936
14:28:31 22893 8192000000 10876243408 11295920128 1939155968 19.140 100 62 124 0 1971522096 14670144 17695984
14:29:03 24821 8192000000 10873926368 11303854080 1941600928 19.160 100 39 78 2 1967440096 14515712 11323456
14:29:37 7169 8192000000 10862849248 11289849856 1930893408 19.074 99 43 84 0 1957743184 13563488 13286288
14:29:52 8503 8192000000 10879067120 11313053696 1946227104 19.196 100 32 64 0 1970486896 14200624 10059168
14:30:11 41123 8192000000 10888769168 11326988288 1960344208 19.309 100 39 76 3 1989539344 16774560 12420576
14:31:01 25368 8192000000 10893471248 11327606784 1943949168 19.178 99 33 66 4 1969468256 15021840 10497248
14:31:41 19978 8192000000 10899216880 11331223552 1945772016 19.193 99 44 88 1 1979787232 20438896 13576320
14:32:08 7522 8192000000 10901431200 11326312448 1958012032 19.290 100 45 90 3 1988268656 16885776 13370848
14:32:22 8842 8192000000 10910372592 11337838592 1966795120 19.360 100 49 97 2 1998247872 17959792 13492960
14:32:38 4649 8192000000 10907562880 11327893504 1959448864 19.302 100 65 130 1 1998034848 18977632 19608352
14:32:51 1009 8192000000 10927840384 11337011200 1972028048 19.402 100 85 166 1 2016399936 20256064 24115824
14:32:58 3184 8192000000 10921099056 11342266368 1969712896 19.383 100 69 136 1 2011433088 21910128 19810064
14:33:08 3379 8192000000 10929498560 11345883136 1973752384 19.415 100 71 142 1 2017104784 22062624 21289776
14:33:18 6603 8192000000 10927467008 11341459456 1966999536 19.362 100 70 140 0 2012084144 23993440 21091168
14:33:34 8092 8192000000 10919909552 11347402752 1971310592 19.396 100 62 124 0 2017266848 27124432 18831824
14:33:50 11253 8192000000 10917109664 11337355264 1963859360 19.337 100 70 140 2 2008690736 23903216 20928160
14:34:12 12122 8192000000 10919232544 11344601088 1945731440 19.192 99 59 115 1 1991823216 27597536 18494240
14:34:34 6339 8192000000 10938882512 11357712384 1976608144 19.438 100 66 131 2 2021217024 25402528 19206352
14:34:47 5057 8192000000 10929931088 11349610496 1968239632 19.371 100 79 157 0 2018663872 27048816 23375424
14:35:05 14795 8192000000 10921876112 11356884992 1968725888 19.375 100 51 102 1 2010175040 25939296 15509856
14:35:28 12174 8192000000 10921517056 11354255360 1971418288 19.397 100 44 87 3 2010600032 26048992 13132752
14:35:52 5048 8192000000 10930358736 11357822976 1970513136 19.390 100 57 110 0 2017400432 29702608 17184688
14:36:07 4741 8192000000 10919218512 11350716416 1960939408 19.314 100 52 102 3 2008196688 31219456 16037824
14:36:20 7638 8192000000 10917860992 11345035264 1928586656 19.056 98 48 96 0 1975186160 31515328 15084176
14:36:35 5618 8192000000 10938524320 11358572544 1973237200 19.411 100 69 136 1 2025539104 31759824 20542080
14:36:52 8389 8192000000 10919854288 11342368768 1935785008 19.113 98 68 133 2 1984483152 29485616 19212528
14:37:12 8547 8192000000 10923748640 11352170496 1965365472 19.349 100 57 114 0 2012028688 29797040 16866176
14:37:29 5555 8192000000 10917941904 11341246464 1913892480 18.938 97 59 118 0 1965877296 33534592 18450224
14:37:41 4474 8192000000 10908436752 11331829760 1932605536 19.088 99 63 126 2 1985393296 33290384 19497376
14:37:53 1873 8192000000 10922692544 11335159808 1938999280 19.139 99 83 166 2 1998956208 34788432 25168496
14:38:02 3020 8192000000 10936614304 11350593536 1957529552 19.286 100 82 166 4 2018529792 36319904 24680336
14:38:12 1241 8192000000 10949928576 11359907840 1969686256 19.383 100 89 179 0 2036116096 37815712 28614128
14:38:20 2047 8192000000 10954593648 11366694912 1970775840 19.392 100 80 160 0 2036000672 40629184 24595648
14:38:29 1979 8192000000 10944849184 11350519808 1956976224 19.282 100 85 167 0 2025379584 42227280 26176080
14:38:38 3130 8192000000 10950724640 11363282944 1966229376 19.356 100 84 168 0 2036290352 44209216 25851760
14:38:48 2188 8192000000 10932924384 11337994240 1947940464 19.210 99 83 162 4 2014492016 42897920 23653632
14:39:00 2795 8192000000 10935094976 11347148800 1942551120 19.167 99 77 153 0 2008809056 42611584 23646352
14:39:11 1919 8192000000 10929997392 11339755520 1945250800 19.189 100 80 160 2 2014074672 43673040 25150832
14:39:20 2016 8192000000 10949996336 11358670848 1961979248 19.322 100 86 168 2 2032057872 44778432 25300192
14:39:28 4679 8192000000 10960829152 11368968192 1972918064 19.409 100 79 156 1 2039585792 42479728 24188000
14:39:42 4112 8192000000 10967321984 11379662848 1975668672 19.430 100 77 154 1 2045766928 45772992 24325264
14:39:56 4899 8192000000 10972098320 11393122304 1985941616 19.512 100 71 142 1 2058589280 49493936 23153728
14:40:08 4486 8192000000 10974512096 11396296704 1986708688 19.518 100 63 126 1 2057529904 50292272 20528944
14:40:21 4591 8192000000 10978897600 11400957952 1989275328 19.538 100 66 130 1 2062752064 52067808 21408928
14:40:33 2527 8192000000 10974040016 11400728576 1991424128 19.555 100 61 122 0 2061294112 49851280 20018704
14:40:44 4303 8192000000 10985554272 11406045184 1996272608 19.593 100 64 128 1 2067779984 50633120 20874256
14:40:55 7579 8192000000 10962232224 11400175616 1985992016 19.512 100 48 96 0 2052549024 50567408 15989600
14:41:09 7047 8192000000 10964905232 11406929920 1987803216 19.526 100 37 73 0 2048788048 48672016 12312816
14:41:23 8168 8192000000 10950983776 11389988864 1949790160 19.225 98 42 83 1 2013138336 49079120 14269056
14:41:37 3718 8192000000 10893171120 11321286656 1901321232 18.837 97 56 111 0 1964679248 45614560 17743456
14:41:47 3759 8192000000 10906657648 11337371648 1932591904 19.088 100 49 98 0 1994548304 45390288 16566112
14:41:59 10641 8192000000 10910623872 11345498112 1940557728 19.151 100 39 79 1 1997261184 44250848 12452608
14:42:17 10654 8192000000 10911259568 11346333696 1926805216 19.041 99 41 82 2 1987725456 47470128 13450112
14:42:37 9566 8192000000 10922946144 11359457280 1947236080 19.204 100 42 82 0 2004945360 44361232 13348048
14:42:54 4952 8192000000 10921498960 11345375232 1942189488 19.164 100 66 132 1 2010957040 47388736 21378816
14:43:07 10729 8192000000 10925147664 11356950528 1947140880 19.204 100 38 75 2 2006833936 47279216 12413840
14:43:34 14291 8192000000 10904730144 11344588800 1920986896 18.995 99 28 56 1 1977836896 46589744 10260256
14:43:55 8993 8192000000 10899265552 11342983168 1932299776 19.085 100 32 64 0 1985608384 42434816 10873792
14:44:11 14714 8192000000 10888227744 11326001152 1898697728 18.816 98 28 56 0 1949435824 41850656 8887440
14:44:32 10169 8192000000 10880714224 11317694464 1908005168 18.891 99 34 68 2 1964559472 45733632 10820672
14:45:03 9898 8192000000 10887386272 11327131648 1918881616 18.978 100 32 66 1 1976754688 47044992 10828080
14:45:26 21382 8192000000 10895881136 11330273280 1887337424 18.724 98 37 74 2 1950174512 50718048 12119040
14:46:10 32769 8192000000 10882814416 11320987648 1838005424 18.325 96 22 44 1 1904350112 57829504 8515184
14:47:32 54180 8192000000 10878689792 11344367616 1914928208 18.946 100 13 26 0 1958225264 38538592 4758464
14:48:44 57050 8192000000 10883173360 11318456320 1915295584 18.949 99 29 56 1 1934198928 10508320 8395024
14:49:48 154835 8192000000 10876361744 11338514432 1884232208 18.699 97 25 50 0 1905327728 13777616 7317904
14:52:30 116172 8192000000 10836408512 11293466624 1815867680 18.144 94 15 30 1 1828370816 8526240 3976896
14:54:33 27724 8192000000 10844426272 11310551040 1918890752 18.978 100 9 18 2 1932474416 10695008 2888656
14:55:08 25031 8192000000 10848536816 11321122816 1930155520 19.068 100 6 12 0 1943069040 11265712 1647808
14:56:53 58340 8192000000 10860916224 11321733120 1908283120 18.893 98 23 46 0 1924009744 9723168 6003456
14:58:13 80727 8192000000 10877243840 11338764288 1933257216 19.093 99 16 32 0 1948582720 10515472 4810032
14:59:49 69041 8192000000 10898689808 11351142400 1947635584 19.208 99 36 72 2 1966121088 8115456 10370048
15:01:05 67887 8192000000 10887290496 11356844032 1949022208 19.219 99 17 34 1 1963204400 9595488 4586704
15:02:19 78614 8192000000 10897113440 11375939584 1967854752 19.368 100 9 18 0 1982550080 12021696 2673632
15:03:46 69128 8192000000 10890001392 11371184128 1937859696 19.130 98 23 47 2 1959431280 14654080 6917504
15:05:03 35553 8192000000 10923054032 11374538752 1981262912 19.475 100 31 62 1 1999467952 8899920 9305120
15:05:46 30767 8192000000 10914301680 11367940096 1982352544 19.483 100 33 63 3 2003094272 11838272 8903456
15:06:25 71996 8192000000 10933308688 11402252288 1977901888 19.448 99 26 52 1 2003019040 17580544 7536608
15:07:44 100669 8192000000 10896169392 11355119616 1924955840 19.027 97 8 16 0 1944459088 17042112 2461136
15:09:35 33032 8192000000 10924841792 11373096960 1962464816 19.326 99 29 58 0 1982555744 12233504 7857424
15:10:14 44909 8192000000 10910944912 11364585472 1969100384 19.378 99 29 58 0 1991658352 14446128 8111840
15:11:06 80205 8192000000 10903914784 11362295808 1942686784 19.168 98 19 38 0 1961707680 13929552 5091344
15:12:34 45190 8192000000 10929234336 11383508992 1982164720 19.482 100 24 48 1 1997990768 9219088 6606960
15:13:36 53803 8192000000 10923262800 11390234624 1979836544 19.463 99 23 46 1 1999987600 13780480 6370576
15:14:36 164308 8192000000 10903117504 11383390208 1938842432 19.138 97 16 32 0 1962360912 19104752 4413728
15:17:27 97796 8192000000 10914779392 11381239808 1916590064 18.960 96 16 32 1 1935392912 14480640 4322208
15:19:11 34165 8192000000 10913778672 11371577344 1966842848 19.360 99 18 36 1 1984444528 12775552 4826128
15:20:09 49489 8192000000 10897906704 11378704384 1957059184 19.283 99 9 18 0 1973782656 14183808 2539664
15:21:41 70832 8192000000 10871368080 11340500992 1872324864 18.603 94 10 20 0 1881152256 6438976 2388416
15:22:58 52849 8192000000 10899223984 11374882816 1983452800 19.492 100 27 54 0 2005165232 13868704 7843728
15:23:57 94817 8192000000 10888576496 11366318080 1923081760 19.012 97 13 27 0 1940342384 13552800 3707824
15:25:38 16907 8192000000 10890514496 11365560320 1956046720 19.275 99 11 22 0 1978880368 19630432 3203216
15:26:08 54025 8192000000 10890133056 11373142016 1953624688 19.255 99 18 36 1 1976868112 18079568 5163856
15:27:08 78337 8192000000 10899037936 11383459840 1934046992 19.099 98 11 22 2 1951577152 14666960 2863200
15:28:57 51469 8192000000 10870207632 11349266432 1893589136 18.775 96 12 24 2 1906983088 9996400 3397552
15:29:55 57232 8192000000 10881981824 11349680128 1897469504 18.806 96 16 32 0 1909352464 7925520 3957440
15:31:01 53867 8192000000 10870143792 11335393280 1885612192 18.710 96 22 44 6 1901307808 9484048 6211568
15:32:01 58627 8192000000 10865344976 11330531328 1855199840 18.464 95 27 55 1 1877496528 14671968 7624720
15:33:50 41057 8192000000 10862866352 11313754112 1882396592 18.684 97 34 68 1 1906266368 14317760 9552016
15:34:37 47945 8192000000 10862679856 11323195392 1894632176 18.783 98 29 58 0 1913003312 10799520 7571616
15:35:32 62352 8192000000 10900559712 11352031232 1924960736 19.027 99 16 32 0 1939995952 10702272 4332944
15:36:44 59094 8192000000 10897922304 11341926400 1905961632 18.874 97 43 86 1 1934875584 16764016 12149936
15:37:55 17515 8192000000 10885404960 11339223040 1927625584 19.048 99 39 78 2 1958366000 19407616 11332800
15:38:30 137230 8192000000 10845750992 11307606016 1783854064 17.881 92 8 16 0 1797138224 11269408 2014752
15:40:53 79624 8192000000 10840610640 11279572992 1811638768 18.109 94 33 66 2 1829634528 7610944 10384816
15:42:24 79756 8192000000 10844376352 11310866432 1855184448 18.464 97 26 53 1 1870795120 8247728 7362944
15:43:50 39081 8192000000 10853712928 11319808000 1913739792 18.937 99 25 50 1 1930846048 9449120 7657136
15:44:36 11392 8192000000 10848621728 11326189568 1932733168 19.089 100 13 26 0 1946901216 10583264 3584784
15:44:55 20948 8192000000 10846662096 11325595648 1932098752 19.084 100 6 12 0 1944119248 10368080 1652416
15:45:48 53760 8192000000 10863936288 11336007680 1937105200 19.124 100 8 15 1 1948874432 9761264 2007968
15:46:48 70434 8192000000 10871502048 11334266880 1909357392 18.901 98 17 34 0 1924301728 9765792 5178544
15:48:04 82162 8192000000 10876194400 11357282304 1956805280 19.281 100 16 32 0 1971152896 9886704 4460912
15:49:37 66860 8192000000 10892465952 11362287616 1962483328 19.326 100 11 21 2 1976189792 10206496 3499968
15:50:53 57706 8192000000 10900801968 11367985152 1937830640 19.129 98 35 69 1 1957335952 10420032 9085280
15:51:59 85806 8192000000 10910367920 11383087104 1956363872 19.277 99 20 40 1 1976089728 13678064 6047792
15:53:32 56721 8192000000 10901390320 11380170752 1960909856 19.313 99 16 32 0 1979402992 13617872 4875264
15:54:35 54132 8192000000 10910397472 11369926656 1956564016 19.279 99 19 38 1 1972155264 10303216 5288032
15:55:50 60126 8192000000 10925266512 11399000064 1977283232 19.443 100 15 30 0 1999553120 17589488 4680400
15:56:58 105929 8192000000 10915233216 11390349312 1934414704 19.102 97 9 18 2 1954013104 17145296 2453104
15:58:58 82618 8192000000 10914732272 11379957760 1942634272 19.168 98 14 28 2 1963016272 16618864 3763136
16:00:27 56280 8192000000 10948177488 11411087360 1989673664 19.541 100 12 24 1 2017818624 25009440 3135520
16:01:31 36112 8192000000 10942932736 11393101824 1975727456 19.431 99 31 62 0 2003307744 18900304 8679984
16:02:15 67295 8192000000 10928834144 11397836800 1989507792 19.540 100 9 18 0 2002166384 10320192 2338400
16:03:28 131542 8192000000 10899565120 11369746432 1921137440 18.996 96 27 54 0 1936110256 8161360 6811456
16:05:52 63988 8192000000 10916206304 11386683392 1952939440 19.250 98 29 58 0 1972324064 10899344 8485280
16:07:54 42898 8192000000 10788189968 11245162496 1785180816 17.892 91 25 51 3 1798268480 4953440 8134224
16:08:46 91109 8192000000 10861806704 11339378688 1933036896 19.091 100 14 28 2 1949338448 11930192 4371360
16:10:31 70549 8192000000 10867164368 11341185024 1929705296 19.065 99 12 24 0 1948101824 14609280 3787248
16:12:58 78749 8192000000 10851234560 11338072064 1909500512 18.903 98 11 22 1 1921558784 9070304 2987968
16:14:23 23355 8192000000 10876772320 11335913472 1911523056 18.919 98 40 79 3 1932049184 9222384 11303744
16:14:57 59026 8192000000 10867286624 11339423744 1914668352 18.944 98 20 41 2 1931680592 11316592 5695648
16:16:16 60507 8192000000 10878870192 11347800064 1922443520 19.006 98 13 26 0 1934087072 8253040 3390512
16:17:23 59877 8192000000 10874185424 11335073792 1840186672 18.342 94 18 37 1 1854393952 9010480 5196800
16:18:32 22276 8192000000 10855948016 11292893184 1845735440 18.387 95 41 82 2 1869664480 12362816 11566224
16:19:00 55118 8192000000 10846158000 11304194048 1858731472 18.493 97 34 68 0 1882920544 14746976 9442096
16:20:09 57569 8192000000 10818828320 11280084992 1832851984 18.283 96 14 29 1 1852659616 15384272 4423360
16:21:20 28445 8192000000 10859181952 11309854720 1916785616 18.961 100 23 46 0 1932604752 9448432 6370704
16:22:06 48412 8192000000 10842384464 11311017984 1885745952 18.711 98 34 68 1 1906180768 11033632 9401184
16:23:05 78850 8192000000 10840486960 11301253120 1810187936 18.097 94 17 34 1 1824303152 9415184 4700032
16:24:36 85286 8192000000 10849569872 11329105920 1898735552 18.816 99 18 36 2 1924047904 20241968 5070384
16:26:07 70005 8192000000 10343390768 10761396224 1430853232 14.869 75 18 36 0 1444246768 8701072 4692464

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 07-12-2020 16:28:57 to 07-12-2020 16:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 95 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 07-12-2020 16:29:27 to 07-12-2020 16:29:29.

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          250397
MON$OLDEST_ACTIVE               250570
MON$OLDEST_SNAPSHOT             250570
MON$NEXT_TRANSACTION            250570
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                       2017408
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:130: 
:131: mscs-test-161.budzdorov.ru    Mon Dec  7 16:27:35 2020
:132:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:133: 
:134: 
:135: mscs-test-161.budzdorov.ru    Mon Dec  7 16:27:38 2020
:136:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:137: 
:138: 
:139: mscs-test-161.budzdorov.ru    Mon Dec  7 16:27:38 2020
:140:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:141: 
--- end of diff output ---

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

07.12.20 16:29:30. 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-12-07 16:29:32 No severe PSQL-related problems occured
07.12.20 16:29:34. End of report.