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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17295436 kB
MemAvailable 31600772 kB
Buffers 0 kB
Cached 14375408 kB
SwapCached 1928 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-01 19:27:01
DTS_END                         2020-12-01 19:27:01.1160
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(131:22) ==> SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42938
TRN_ID                          241496
ATT_ID                          669
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: 9654.86 21567 1158583
customer order: creation 175.52 352 21062
customer order: refuse 15.03 384 1803
order to supplier: creation 47.56 1315 5707
order to supplier: removal 3.68 107680 441
invoice (draft): creation 46.86 3249 5623
invoice (draft): removal 57.58 873 6909
invoice accept: apply 42.63 17293 5116
invoice accept: cancel 51.63 831 6195
customer reserve: creation 3871.68 173 464602
customer reserve: removal 5031.34 61 603761
realization accept: apply 85.99 193 10319
realization accept: cancel 92.16 112 11059
payment from customer: creation 61.53 123 7383
payment from customer: removal 5.98 94 718
payment to supplier: creation 49.55 149 5946
payment to supplier: removal 3.25 72 390
service: total inventory turnovers 4.88 1062 586
service: total monetary turnovers 7.18 44 861
service: aggregate perf. data 0.82 19770 98
service: refresh index statistics 0.03 277508 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-12-2020 19:27:52 to 01-12-2020 19:27:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5227
TEST_TIME 2 5114
TEST_TIME 3 4119
TEST_TIME 4 4507
TEST_TIME 5 4801
TEST_TIME 6 4663
TEST_TIME 7 5179
TEST_TIME 8 5172
TEST_TIME 9 5277
TEST_TIME 10 5549
TEST_TIME 11 5585
TEST_TIME 12 5844
TEST_TIME 13 6070
TEST_TIME 14 6158
TEST_TIME 15 6356
TEST_TIME 16 6718
TEST_TIME 17 6931
TEST_TIME 18 7119
TEST_TIME 19 7585
TEST_TIME 20 7789
TEST_TIME 21 8133
TEST_TIME 22 8309
TEST_TIME 23 8513
TEST_TIME 24 8785
TEST_TIME 25 9041
TEST_TIME 26 9413
TEST_TIME 27 9730
TEST_TIME 28 9836
TEST_TIME 29 10837
TEST_TIME 30 11205
TEST_TIME 31 11195
TEST_TIME 32 11026
TEST_TIME 33 11136
TEST_TIME 34 10981
TEST_TIME 35 10969
TEST_TIME 36 10992
TEST_TIME 37 10877
TEST_TIME 38 10875
TEST_TIME 39 10680
TEST_TIME 40 10549
TEST_TIME 41 10404
TEST_TIME 42 10448
TEST_TIME 43 10340
TEST_TIME 44 10398
TEST_TIME 45 10291
TEST_TIME 46 10219
TEST_TIME 47 10165
TEST_TIME 48 10263
TEST_TIME 49 10194
TEST_TIME 50 10106
TEST_TIME 51 10053
TEST_TIME 52 10085
TEST_TIME 53 10051
TEST_TIME 54 10003
TEST_TIME 55 9875
TEST_TIME 56 9889
TEST_TIME 57 9823
TEST_TIME 58 9872
TEST_TIME 59 9866
TEST_TIME 60 9889
TEST_TIME 61 9875
TEST_TIME 62 9866
TEST_TIME 63 9987
TEST_TIME 64 9984
TEST_TIME 65 9947
TEST_TIME 66 9982
TEST_TIME 67 10003
TEST_TIME 68 10099
TEST_TIME 69 10111
TEST_TIME 70 10132
TEST_TIME 71 10108
TEST_TIME 72 10025
TEST_TIME 73 9935
TEST_TIME 74 9969
TEST_TIME 75 9880
TEST_TIME 76 9856
TEST_TIME 77 9814
TEST_TIME 78 9824
TEST_TIME 79 9781
TEST_TIME 80 9742
TEST_TIME 81 9763
TEST_TIME 82 9708
TEST_TIME 83 9684
TEST_TIME 84 9658
TEST_TIME 85 9654
TEST_TIME 86 9665
TEST_TIME 87 9651
TEST_TIME 88 9643
TEST_TIME 89 9710
TEST_TIME 90 9740
TEST_TIME 91 9767
TEST_TIME 92 9769
TEST_TIME 93 9814
TEST_TIME 94 9775
TEST_TIME 95 9838
TEST_TIME 96 9828
TEST_TIME 97 9868
TEST_TIME 98 9889
TEST_TIME 99 9886
TEST_TIME 100 9798
TEST_TIME 101 9774
TEST_TIME 102 9771
TEST_TIME 103 9728
TEST_TIME 104 9694
TEST_TIME 105 9701
TEST_TIME 106 9643
TEST_TIME 107 9662
TEST_TIME 108 9616
TEST_TIME 109 9592
TEST_TIME 110 9560
TEST_TIME 111 9633
TEST_TIME 112 9630
TEST_TIME 113 9595
TEST_TIME 114 9633
TEST_TIME 115 9716
TEST_TIME 116 9682
TEST_TIME 117 9719
TEST_TIME 118 9702
TEST_TIME 119 9740
TEST_TIME 120 9659

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-12-2020 19:27:56 to 01-12-2020 19:27:59.

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 1591657 1591657 0 0.00 0 17410 6 0 0
doc_list_biud 1591656 1591656 0 0.00 0 83160 30 0 0
sp_add_invoice_to_stock 5204 5116 88 1.69 51 211515 17294 0 88
sp_cancel_adding_invoice 6195 6195 0 0.00 5 64729 832 0 0
sp_cancel_client_order 1803 1803 0 0.00 4 17462 384 0 0
sp_cancel_customer_reserve 603761 603761 0 0.00 1 67293 61 0 0
sp_cancel_pay_from_customer 718 718 0 0.00 3 6985 95 0 0
sp_cancel_pay_to_supplier 390 390 0 0.00 2 5228 72 0 0
sp_cancel_supplier_invoice 6919 6909 10 0.14 2 83165 874 0 10
sp_cancel_supplier_order 441 441 0 0.00 6 1315737 107681 0 0
sp_cancel_write_off 11059 11059 0 0.00 1 16801 113 0 0
sp_client_order 21062 21062 0 0.00 3 54265 352 0 0
sp_customer_reserve 464602 464602 0 0.00 0 152575 174 0 0
sp_fill_shopping_cart 32389 32389 0 0.00 1 15589 39 0 0
sp_fill_shopping_cart_clo_res 464598 464598 0 0.00 0 21725 13 0 0
sp_get_clo_for_invoice 5110 5110 0 0.00 0 23940 262 0 0
sp_kill_cost_storno 18362 18362 0 0.00 0 16682 60 0 0
sp_kill_qstorno_ret_qs2qd 1225931 1225931 0 0.00 0 83159 33 0 0
sp_kill_qty_storno 645597 645597 0 0.00 0 83160 72 0 0
sp_lock_selected_doc 21337 21337 0 0.00 0 9120 5 0 0
sp_make_cost_storno 28758 28758 0 0.00 0 17292 61 0 0
sp_multiply_rows_for_pdistr 28758 28758 0 0.00 0 14035 32 0 0
sp_multiply_rows_for_qdistr 21062 21062 0 0.00 0 54231 163 0 0
sp_pay_from_customer 7383 7383 0 0.00 4 17455 124 0 0
sp_pay_to_supplier 5946 5946 0 0.00 4 19838 150 0 0
sp_payment_common 13329 13329 0 0.00 1 17222 37 0 0
sp_qd_handle_on_cancel_clo 1803 1803 0 0.00 0 17453 358 0 0
sp_qd_handle_on_invoice_upd_sts 11305 11305 0 0.00 0 34064 351 0 0
sp_qd_handle_on_reserve_upd_sts 10319 10319 0 0.00 0 19395 63 0 0
sp_reserve_write_off 10319 10319 0 0.00 6 19452 193 0 0
sp_supplier_invoice 5623 5623 0 0.00 5 90331 3250 0 0
sp_supplier_order 5707 5707 0 0.00 5 80571 1315 0 0
srv_aggregate_perf_data 98 98 0 0.00 2935 236305 19771 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 954 191927 30588 0 0
srv_find_qd_qs_mism 1111410 1111410 0 0.00 0 14336 5 0 0
srv_make_invnt_saldo 586 586 0 0.00 24 27921 1062 0 0
srv_make_money_saldo 861 861 0 0.00 0 8862 45 0 0
srv_recalc_idx_stat 4 4 0 0.00 205115 404780 277509 0 0
t$perf-abend:sp_add_invoice_to_stock 88 88 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5116 5116 0 0.00 0 9883 167 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 1 4947 99 0 0
t$perf-norm:sp_cancel_client_order 1803 1803 0 0.00 0 3736 12 0 0
t$perf-norm:sp_cancel_customer_reserve 703 703 0 0.00 0 858 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 718 718 0 0.00 0 1154 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 390 390 0 0.00 0 2998 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 1181 23 0 0
t$perf-norm:sp_cancel_supplier_order 441 441 0 0.00 0 19406 1430 0 0
t$perf-norm:sp_cancel_write_off 1036 1036 0 0.00 0 2858 10 0 0
t$perf-norm:sp_client_order 21062 21062 0 0.00 0 11559 20 0 0
t$perf-norm:sp_customer_reserve 1040 1040 0 0.00 0 2348 8 0 0
t$perf-norm:sp_pay_from_customer 7383 7383 0 0.00 0 4572 13 0 0
t$perf-norm:sp_pay_to_supplier 5946 5946 0 0.00 0 6097 15 0 0
t$perf-norm:sp_reserve_write_off 10319 10319 0 0.00 0 10820 13 0 0
t$perf-norm:sp_supplier_invoice 5623 5623 0 0.00 0 5895 18 0 0
t$perf-norm:sp_supplier_order 5707 5707 0 0.00 0 5923 20 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 773 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 512 9 0 0
t$perf-norm:srv_make_invnt_saldo 586 586 0 0.00 0 701 14 0 0
t$perf-norm:srv_make_money_saldo 861 861 0 0.00 0 1554 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 10396 10220 176 1.69 0 5712 20 0 176
v_all_customers 38822 38822 0 0.00 0 30 1 0 0
v_all_suppliers 31294 31294 0 0.00 0 69 1 0 0
v_all_wares 42124 42124 0 0.00 0 69 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 118 5 0 0
v_cancel_client_order 3606 3606 0 0.00 0 2655 7 0 0
v_cancel_customer_prepayment 1436 1436 0 0.00 0 971 6 0 0
v_cancel_customer_reserve 1406 1406 0 0.00 0 2917 8 0 0
v_cancel_payment_to_supplier 780 780 0 0.00 0 1288 6 0 0
v_cancel_supplier_invoice 846 826 20 2.36 0 1392 17 0 20
v_cancel_supplier_order 882 882 0 0.00 0 2258 9 0 0
v_cancel_write_off 2072 2072 0 0.00 0 4668 18 0 0
v_max_id_clo_ord 5707 5707 0 0.00 0 1114 2 0 0
v_max_id_clo_res 1040 1040 0 0.00 0 5368 19 0 0
v_max_id_ord_sup 5620 5620 0 0.00 0 4779 4 0 0
v_max_non_paid_invoice 1626 1626 0 0.00 0 2708 6 0 0
v_max_non_paid_realizn 3753 3753 0 0.00 0 5127 6 0 0
v_min_id_clo_ord 5707 5707 0 0.00 0 4321 9 0 0
v_min_id_clo_res 1040 1040 0 0.00 0 9944 25 0 0
v_min_id_ord_sup 5620 5620 0 0.00 0 15583 14 0 0
v_min_non_paid_invoice 5946 5946 0 0.00 0 16503 21 0 0
v_min_non_paid_realizn 7383 7383 0 0.00 0 17207 29 0 0
v_our_firm 10562 10562 0 0.00 0 17 1 0 0
v_reserve_write_off 20638 20638 0 0.00 0 4079 5 0 0
x_lock_depdocs_on_canc_invoice 12691 12691 0 0.00 0 17939 118 0 0
x_lock_depdocs_on_canc_sup_ord 441 441 0 0.00 0 21277 470 0 0
x_make_qstorno_1000_1200 5707 5707 0 0.00 2 78647 1228 0 0
x_make_qstorno_1200_2000 5623 5623 0 0.00 2 90294 3113 0 0
x_make_qstorno_2100_3300 464602 464602 0 0.00 0 152572 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-12-2020 19:28:00 to 01-12-2020 19:28:04.

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
16:57:04 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:11 2571 8192000000 9784289184 10008432640 724469456 8.125 61 45 96 0 741746640 2104240 15172944
16:57:21 28360 8192000000 10302809136 10615857152 1341263728 14.069 100 83 166 0 1373750576 4316288 28170560
16:58:02 25203 8192000000 10368821632 10690191360 1413374192 14.714 100 88 176 0 1448048704 5757008 28917504
16:58:39 29353 8192000000 10402880192 10730143744 1452211744 15.057 100 87 174 0 1487798784 6978752 28608288
16:59:22 16943 8192000000 10426168240 10756628480 1475689648 15.264 100 84 168 0 1510756016 7614544 27451824
16:59:51 29564 8192000000 10463330224 10797244416 1511424816 15.576 100 91 182 1 1549233440 8729376 29079248
17:00:30 11931 8192000000 10464386448 10803429376 1523438480 15.680 100 85 170 1 1559586544 9250368 26897696
17:00:53 18104 8192000000 10492815424 10833076224 1543443728 15.853 100 86 172 1 1580090208 9805808 26840672
17:01:25 15394 8192000000 10507913968 10855886848 1562433968 16.017 100 79 158 0 1597019520 10274832 24310720
17:01:49 17899 8192000000 10538334240 10890018816 1590740480 16.260 100 86 172 3 1628269952 11189328 26340144
17:02:15 6661 8192000000 10552966720 10911309824 1615995680 16.476 100 81 162 1 1652098496 11881344 24221472
17:02:33 14762 8192000000 10581538320 10943184896 1637304336 16.657 100 83 166 0 1674661408 12343392 25013680
17:02:56 10876 8192000000 10601552816 10962472960 1659118032 16.841 100 85 170 0 1696969200 13058720 24792448
17:03:16 11021 8192000000 10622230512 10986680320 1676241120 16.986 100 86 172 3 1715315120 13902000 25172000
17:03:36 7129 8192000000 10619609280 10986848256 1685823216 17.066 100 82 164 1 1723155712 13361536 23970960
17:03:51 9726 8192000000 10636252176 11005067264 1697501264 17.164 100 82 164 1 1733980240 13080640 23398336
17:04:08 7620 8192000000 10646953056 11018117120 1711404496 17.280 100 90 181 0 1751572416 13762368 26405552
17:04:24 7093 8192000000 10665552272 11037401088 1719990416 17.352 100 86 170 1 1757960400 13863424 24106560
17:04:38 6496 8192000000 10683196736 11054329856 1736168144 17.487 100 87 174 1 1774953360 14234560 24550656
17:04:53 5910 8192000000 10691100128 11067633664 1747648128 17.582 100 81 162 3 1785816400 14690160 23478112
17:05:06 4777 8192000000 10687641136 11065356288 1751910992 17.617 100 75 150 3 1786014528 13421456 20682080
17:05:18 5545 8192000000 10694682784 11072917504 1755179136 17.644 100 78 155 4 1790607264 13244832 22183296
17:05:31 4037 8192000000 10707682960 11083431936 1765902336 17.733 100 77 155 0 1801739616 13830048 22007232
17:05:42 4542 8192000000 10715216704 11095969792 1771588192 17.780 100 86 172 1 1810420720 14357456 24475072
17:05:54 4985 8192000000 10717612224 11100082176 1778255520 17.835 100 75 150 0 1811287296 12639232 20392544
17:06:05 3258 8192000000 10731405648 11111030784 1790750720 17.938 100 91 182 1 1829518496 13190448 25577328
17:06:15 9257 8192000000 10743807488 11127308288 1800633888 18.019 100 84 167 0 1837513440 13849296 23030256
17:06:32 5730 8192000000 10742037600 11129520128 1802393552 18.034 100 81 160 0 1839321648 14295952 22632144
17:06:44 1884 8192000000 10763451488 11148529664 1821819984 18.193 100 90 181 0 1860599152 13178944 25600224
17:06:53 2488 8192000000 10769070800 11155288064 1822928432 18.202 100 86 173 1 1860170992 12621392 24621168
17:07:02 1934 8192000000 10776689312 11160944640 1828959920 18.251 100 93 184 0 1868273504 13642576 25671008
17:07:10 3367 8192000000 10777179136 11163598848 1833867280 18.291 100 94 186 1 1873810304 13613600 26329424
17:07:19 2020 8192000000 10785978336 11170611200 1840713520 18.347 100 92 183 0 1880647040 14312992 25620528
17:07:28 1659 8192000000 10792021024 11180421120 1851194944 18.432 100 94 188 0 1891575744 14391680 25989120
17:07:36 1533 8192000000 10797553200 11180429312 1853913312 18.454 100 83 164 1 1891528960 13847152 23768496
17:07:43 2774 8192000000 10797058016 11184021504 1854345904 18.457 100 93 185 1 1892839104 12522224 25970976
17:07:53 2695 8192000000 10803167808 11190513664 1856484496 18.475 100 91 183 0 1896263776 13898656 25880624
17:08:02 1844 8192000000 10799972048 11187974144 1859231408 18.497 100 93 186 2 1900010336 13849920 26929008
17:08:10 1578 8192000000 10807944992 11193733120 1861250048 18.513 100 96 195 0 1902475856 12887856 28337952
17:08:18 4676 8192000000 10794586080 11192786944 1860050496 18.504 100 81 162 1 1896036352 12500800 23485056
17:08:30 32809 8192000000 10797190800 11196030976 1860640896 18.508 100 69 138 3 1891203552 10887184 19675472
17:09:09 2301 8192000000 10818942160 11208040448 1871526240 18.597 100 96 193 2 1910275360 10476624 28272496
17:09:18 7081 8192000000 10799607776 11205603328 1869319312 18.579 100 73 147 0 1901196512 10929264 20947936
17:09:32 7126 8192000000 10789150992 11199733760 1866434176 18.555 100 49 100 0 1889380352 9406512 13539664
17:09:45 3188 8192000000 10787177584 11203514368 1868356432 18.571 100 53 106 1 1892956784 9898256 14702096
17:09:58 4368 8192000000 10786681600 11204796416 1867149328 18.561 100 44 88 2 1887861456 8848592 11863536
17:10:09 5278 8192000000 10776761376 11198124032 1865271600 18.546 100 15 30 1 1875930640 6504320 4154720
17:10:22 5039 8192000000 10785322784 11212267520 1873350400 18.611 100 44 90 2 1897031840 10900768 12780672
17:10:35 7022 8192000000 10778950880 11209646080 1872240784 18.602 100 20 39 1 1884578736 6445328 5892624
17:10:48 8059 8192000000 10781377648 11214016512 1873832048 18.615 100 27 55 0 1887197568 5895776 7469744
17:11:02 7658 8192000000 10792889696 11221471232 1879137104 18.658 100 35 70 4 1895709616 6796624 9775888
17:11:17 8491 8192000000 10792654304 11222380544 1880403200 18.668 100 18 35 2 1891013536 5399744 5210592
17:11:32 9655 8192000000 10796542832 11222925312 1883452896 18.693 100 24 47 1 1896154064 5901360 6799808
17:11:48 8004 8192000000 10792012544 11228188672 1887158880 18.723 100 22 44 2 1899852832 6380304 6313648
17:12:04 9817 8192000000 10791315776 11230285824 1888668576 18.735 100 22 44 1 1900924304 6003648 6252080
17:12:20 9875 8192000000 10800845968 11232931840 1887789664 18.728 100 17 34 1 1898824128 6414096 4620368
17:12:36 11025 8192000000 10793287744 11230212096 1892231824 18.764 100 22 44 0 1905422000 7050192 6139984
17:12:54 17595 8192000000 10808025104 11236954112 1893730352 18.776 100 27 54 0 1906629952 5935440 6964160
17:13:19 66050 8192000000 10824168448 11254484992 1898676000 18.816 100 31 62 0 1913052368 6089920 8286448
17:14:33 11206 8192000000 10808927504 11251113984 1898835552 18.817 100 20 40 1 1911420272 6395040 6189680
17:14:52 8437 8192000000 10822438736 11256569856 1898916544 18.818 100 21 41 0 1915341552 10132016 6292992
17:15:07 8977 8192000000 10819727904 11253628928 1898494768 18.814 100 19 38 0 1909858464 5811184 5552512
17:15:25 7802 8192000000 10829847040 11257233408 1904354160 18.861 100 25 50 1 1917333152 5578032 7400960
17:15:40 10074 8192000000 10814413008 11253211136 1903961360 18.858 100 26 52 2 1917957264 5768448 8227456
17:15:57 8809 8192000000 10820661472 11254349824 1903665200 18.856 100 41 83 2 1927535200 11225280 12644720
17:16:16 10950 8192000000 10820559280 11255934976 1904935824 18.866 100 27 53 3 1918463552 5607952 7919776
17:16:36 7063 8192000000 10803743472 11242958848 1867621616 18.565 98 21 42 2 1879193600 5590720 5981264
17:16:50 8862 8192000000 10819727232 11255967744 1902267408 18.845 100 20 39 2 1913919600 5289776 6362416
17:17:05 9245 8192000000 10796048416 11226947584 1811777728 18.110 95 25 50 0 1828288192 9402704 7107760
17:17:21 16167 8192000000 10757562304 11185332224 1777082112 17.825 95 12 24 0 1786341328 5649616 3609600
17:17:43 10588 8192000000 10767522384 11191283712 1834203856 18.294 99 19 38 2 1845210224 6085136 4921232
17:18:02 9312 8192000000 10757858608 11187609600 1845865600 18.389 100 16 32 1 1856111792 5894240 4351952
17:18:17 53832 8192000000 10781674064 11186618368 1813303824 18.123 97 62 123 4 1837953008 6447312 18201872
17:19:22 9537 8192000000 10743747696 11180687360 1786656496 17.904 96 18 36 4 1801209280 10276720 4276064
17:19:39 9881 8192000000 10721713136 11139993600 1701628064 17.199 93 19 38 2 1712119824 5192352 5299408
17:19:56 4699 8192000000 10732672368 11149312000 1774502880 17.804 97 46 92 1 1794641840 6942144 13196816
17:20:09 4279 8192000000 10723185568 11134689280 1741008960 17.527 96 37 74 0 1758909584 7305024 10595600
17:20:21 6740 8192000000 10699986960 11115061248 1756205792 17.653 98 39 78 2 1779399392 11580528 11613072
17:20:34 5984 8192000000 10703922592 11122151424 1784982224 17.891 100 30 60 1 1801305776 7317360 9006192
17:20:46 6212 8192000000 10710252816 11125260288 1772661824 17.789 98 36 71 3 1792810672 10216464 9932384
17:20:59 5590 8192000000 10728578608 11135270912 1766542832 17.738 98 28 56 2 1780518112 5348208 8627072
17:21:11 7451 8192000000 10703380864 11118051328 1774965648 17.808 98 24 48 1 1787933904 5947904 7020352
17:21:33 8854 8192000000 10705565936 11118280704 1726598256 17.407 96 21 42 1 1741544656 9126848 5819552
17:21:48 10362 8192000000 10714553152 11125936128 1762947312 17.709 98 20 40 1 1774244864 4979648 6317904
17:22:05 11025 8192000000 10723511104 11138674688 1769537040 17.763 98 28 56 2 1783525648 5110656 8877952
17:22:22 7554 8192000000 10718770448 11133833216 1770042976 17.767 98 28 57 1 1784672800 6082720 8547104
17:22:41 7505 8192000000 10735938896 11150905344 1792341344 17.951 99 24 48 3 1809564256 10202704 7020208
17:22:59 68309 8192000000 10739614784 11170746368 1834257264 18.294 100 25 47 1 1850514672 9331040 6926368
17:24:16 8928 8192000000 10768208768 11187396608 1846571936 18.394 100 25 48 2 1858730816 5374832 6784048
17:24:31 5189 8192000000 10767441872 11192975360 1848715376 18.412 100 16 32 1 1863157120 10224864 4216880
17:24:43 7651 8192000000 10768664544 11199832064 1854378352 18.458 100 21 42 1 1866304224 5862816 6063056
17:24:59 6906 8192000000 10777766640 11203518464 1862677920 18.525 100 31 62 1 1877062352 5881744 8502688
17:25:13 8996 8192000000 10770922544 11205939200 1861278576 18.514 100 21 42 2 1877690128 10762720 5648832
17:25:29 8408 8192000000 10772214944 11205496832 1862811456 18.526 100 17 34 3 1872834864 5316768 4706640
17:25:43 4973 8192000000 10790401664 11210719232 1868455104 18.572 100 44 89 2 1887912768 6082672 13374992
17:25:57 6254 8192000000 10774902512 11207024640 1868404240 18.571 100 21 42 4 1880414640 6169552 5840848
17:26:09 7299 8192000000 10784038096 11210350592 1868489168 18.572 100 22 44 2 1880502336 5851040 6162128
17:26:23 9962 8192000000 10783926928 11214569472 1865441136 18.547 100 13 25 2 1874504288 5386768 3676384
17:26:44 9054 8192000000 10789893792 11217104896 1871872288 18.599 100 12 24 0 1880514208 5418816 3223104
17:27:02 36831 8192000000 10827874944 11240722432 1892166992 18.763 100 37 75 3 1907768064 5145952 10455120
17:27:46 13623 8192000000 10845987712 11256909824 1906595312 18.879 100 50 100 2 1928632320 8326336 13710672
17:28:07 68451 8192000000 10846096352 11270168576 1919424944 18.982 100 57 114 2 1946320480 11231424 15664112
17:29:24 31365 8192000000 10846801824 11275354112 1919940912 18.986 100 31 62 2 1938487472 9515312 9031248
17:30:03 89083 8192000000 10857013968 11294294016 1932473552 19.087 100 31 62 1 1953230224 11341168 9415504
17:31:46 66301 8192000000 10871810096 11309326336 1944375760 19.182 100 28 54 5 1965477120 13506288 7595072
17:32:59 7935 8192000000 10898072352 11321135104 1955956448 19.274 100 48 93 1 1981640832 12928912 12755472
17:33:15 2935 8192000000 10904529104 11324678144 1960622144 19.311 100 44 88 0 1987884416 14565120 12697152
17:33:31 12428 8192000000 10904860448 11336237056 1969172608 19.379 100 49 98 1 1999545152 16414304 13958240
17:33:51 17844 8192000000 10910463888 11345424384 1974548992 19.422 100 49 98 0 2004668384 16429488 13689904
17:34:17 8058 8192000000 10910599440 11344805888 1977162992 19.442 100 52 104 1 2007864352 15933824 14767536
17:34:34 7804 8192000000 10924040048 11348312064 1981666112 19.478 100 55 111 1 2013789344 15245616 16877616
17:34:55 6047 8192000000 10913098784 11351162880 1980669920 19.470 100 47 94 2 2010812640 15824816 14317904
17:35:11 14945 8192000000 10933520272 11361017856 1984607392 19.501 100 48 93 1 2013186352 15905968 12672992
17:35:34 12650 8192000000 10957361408 11381600256 2005178976 19.664 100 62 123 1 2040261296 17777120 17305200
17:35:55 8179 8192000000 10958383248 11389378560 2008897248 19.693 100 61 122 0 2047919456 21513072 17509136
17:36:14 9945 8192000000 10954706688 11380379648 2004571360 19.659 100 63 126 2 2043939104 21435440 17932304
17:36:37 4546 8192000000 10972695136 11392557056 2010093360 19.702 100 66 133 1 2054702384 25659872 18949152
17:36:49 3108 8192000000 10977715984 11396964352 2014905744 19.740 100 83 166 2 2065508448 26353184 24249520
17:36:59 5157 8192000000 10971146688 11394600960 2013747104 19.731 100 72 144 2 2062100848 27264560 21089184
17:37:13 7029 8192000000 10978115472 11404001280 2018501776 19.768 100 73 146 2 2067613616 27832080 21279760
17:37:29 3930 8192000000 10966182128 11392749568 1996329184 19.594 99 66 132 1 2042107168 26076768 19701216
17:37:42 3913 8192000000 10971287840 11392184320 2009538400 19.698 100 75 150 2 2057988432 25211168 23238864
17:37:54 9423 8192000000 10968781456 11398418432 2016237072 19.751 100 71 142 0 2063297696 25862256 21198368
17:38:15 3738 8192000000 10967700480 11393220608 2009352832 19.696 100 71 142 1 2058426064 27339664 21733568
17:38:27 7776 8192000000 10971441984 11397767168 2013756064 19.731 100 79 158 1 2066072720 28240688 24075968
17:38:52 6345 8192000000 10980548944 11415052288 2022233472 19.798 100 61 122 0 2073587760 32890784 18463504
17:39:04 2442 8192000000 10980993936 11405582336 2002428448 19.642 99 61 122 2 2050941184 29898096 18614640
17:39:14 3230 8192000000 10977432896 11406938112 2017774656 19.763 100 76 149 1 2071175440 29930448 23470336
17:39:24 5774 8192000000 10949666960 11373002752 1981169584 19.474 99 69 138 1 2034467456 31974096 21323776
17:39:40 1390 8192000000 10990256032 11402350592 2012289344 19.720 100 92 182 2 2074095168 33822864 27982960
17:39:49 4549 8192000000 10981795408 11405778944 2011645888 19.714 100 73 143 0 2069457888 34003024 23808976
17:40:09 3259 8192000000 10993424752 11406774272 2016728192 19.754 100 75 148 4 2070389360 31018064 22643104
17:40:22 2824 8192000000 10993478128 11411083264 2017948400 19.764 100 81 160 1 2077156064 34640080 24567584
17:40:32 4227 8192000000 10996725056 11420397568 2023734784 19.809 100 84 167 1 2084800368 35650880 25414704
17:40:43 5947 8192000000 10996908864 11420618752 2021119856 19.789 100 81 162 1 2081595696 35617312 24858528
17:40:56 3395 8192000000 10983949680 11411673088 2017856192 19.763 100 76 151 4 2077226672 36670240 22700240
17:41:07 1790 8192000000 11000789744 11423830016 2023728848 19.809 100 77 155 1 2083911552 36834512 23348192
17:41:16 4985 8192000000 10972724080 11405598720 1996078704 19.592 99 67 131 0 2055013296 38102432 20832160
17:41:28 2744 8192000000 10986260928 11410317312 2004062560 19.655 99 85 168 3 2067906608 37184816 26659232
17:41:42 12795 8192000000 10970712400 11398492160 1997900256 19.606 99 64 126 0 2057042528 39455184 19687088
17:42:04 11194 8192000000 10975520736 11412246528 2009647392 19.699 100 55 110 2 2067021632 40595872 16778368
17:42:26 4186 8192000000 10969452496 11387043840 1948794688 19.217 97 73 145 1 2011929904 38829632 24305584
17:42:36 3643 8192000000 10980960160 11396026368 1991648144 19.557 100 75 147 0 2054201536 40106912 22446480
17:42:48 2566 8192000000 10995857952 11408502784 2007184400 19.679 100 90 181 5 2078306608 42700240 28421968
17:42:57 2607 8192000000 10995104832 11412508672 2008015600 19.686 100 81 162 3 2077527776 44364656 25147520
17:43:07 1676 8192000000 11006271104 11423969280 2018035712 19.765 100 88 176 2 2090127168 43915344 28176112
17:43:14 4650 8192000000 10988208016 11406938112 1985660240 19.509 99 78 154 0 2053848560 44979360 23208960
17:43:28 2033 8192000000 11003466224 11412152320 2003096064 19.647 100 86 168 2 2074513712 45821056 25596592
17:43:39 3883 8192000000 10983728528 11395391488 1989646512 19.541 100 87 173 0 2059985360 43727312 26611536
17:43:50 1290 8192000000 10985534880 11399524352 1994600016 19.580 100 94 188 3 2065791632 43176144 28015472
17:43:57 1854 8192000000 10992277104 11405017088 2000090736 19.623 100 91 182 2 2073765936 45843808 27831392
17:44:08 4004 8192000000 10979599280 11395346432 1996431632 19.595 100 74 148 2 2061769648 41913952 23424064
17:44:20 3235 8192000000 10986668272 11404513280 2001996528 19.638 100 82 162 1 2070062288 43128800 24936960
17:44:31 2644 8192000000 10976376976 11395440640 1992329920 19.562 100 79 159 1 2062071648 44652320 25089408
17:44:42 2623 8192000000 10973312944 11386175488 1977266752 19.443 99 81 159 3 2048726560 45324928 26134880
17:44:52 7036 8192000000 10979735776 11407622144 1999571664 19.619 100 66 132 2 2068095552 47261264 21262624
17:45:11 3228 8192000000 10990720144 11397742592 1973660704 19.414 99 86 172 0 2051679648 50625792 27393152
17:45:23 2883 8192000000 10981449024 11389198336 1983340048 19.491 100 82 161 3 2058816448 50464496 25011904
17:45:33 2194 8192000000 10993791904 11407745024 1993098512 19.568 100 82 162 0 2072788864 53473728 26216624
17:45:43 1999 8192000000 10987923920 11400056832 1989409872 19.539 100 88 174 2 2069156912 52485440 27261600
17:45:53 4126 8192000000 10977591920 11395883008 1973642032 19.414 99 67 135 1 2048752592 52960592 22149968
17:46:04 5413 8192000000 10999636608 11414315008 2000588864 19.627 100 85 169 1 2079767984 52954000 26225120
17:46:18 1695 8192000000 10994026752 11398295552 1989096320 19.537 99 93 184 1 2072009552 54053168 28860064
17:46:26 1104 8192000000 10988562208 11399041024 1980600192 19.469 99 89 177 0 2060118560 51610288 27908080
17:46:34 2690 8192000000 10986937536 11408359424 1995035696 19.584 100 77 155 2 2073083520 53294064 24753760
17:46:44 5056 8192000000 10952046336 11378331648 1971063072 19.394 100 57 113 0 2040712960 50349712 19300176
17:46:59 2920 8192000000 10967145888 11386806272 1977546304 19.445 100 71 139 0 2050393232 50455264 22391664
17:47:13 3240 8192000000 10986643776 11402866688 1987306640 19.523 100 79 153 1 2061544048 50816224 23421184
17:47:24 3721 8192000000 10962013792 11386982400 1960330640 19.309 99 58 116 0 2031469856 52384128 18755088
17:47:36 5085 8192000000 10970734080 11391852544 1964479344 19.342 99 64 126 1 2039796752 54358304 20959104
17:47:49 10656 8192000000 10964308208 11398615040 1978672416 19.454 100 54 108 0 2053351968 56765760 17913792
17:48:16 1282 8192000000 10963123808 11388575744 1959384064 19.301 99 64 129 2 2034099840 53579888 21135888
17:48:35 3944 8192000000 10969112784 11391266816 1973266576 19.411 100 68 136 1 2053423792 57562560 22594656
17:48:46 952 8192000000 10967907232 11387142144 1966969040 19.361 100 68 136 1 2048244080 59350672 21924368
17:48:55 7396 8192000000 10956282816 11393126400 1969687472 19.383 100 45 90 1 2040254672 55141120 15426080
17:49:18 19125 8192000000 10946328576 11388674048 1969510944 19.382 100 39 77 1 2038503712 55316688 13676080
17:49:52 5873 8192000000 10959237664 11386400768 1975220880 19.427 100 60 120 2 2047847296 52636016 19990400
17:50:10 3534 8192000000 10957341856 11384152064 1952955040 19.250 99 59 117 4 2026813616 54208288 19650288
17:50:20 11050 8192000000 10953920752 11397193728 1971925600 19.401 100 49 98 2 2047000656 58263488 16811568
17:50:45 19323 8192000000 10957825344 11396222976 1954374640 19.261 99 40 80 0 2027092544 58386048 14331856
17:51:13 18720 8192000000 10940201024 11385425920 1954184384 19.260 99 35 70 1 2017497136 51243648 12069104
17:51:51 22751 8192000000 10933979936 11382157312 1940583280 19.151 99 35 70 2 2010548960 57821984 12143696
17:52:23 13818 8192000000 10933108832 11387600896 1954930576 19.266 100 30 61 1 2028039328 62562320 10546432
17:52:43 13475 8192000000 10941866928 11389374464 1956303808 19.277 100 34 68 2 2028574384 60790816 11479760
17:53:04 18141 8192000000 10931284320 11386105856 1933335328 19.094 99 32 64 0 2006671744 61531280 11805136
17:53:29 14904 8192000000 10946811744 11395629056 1943986656 19.179 100 28 56 1 2023202720 68776896 10439168
17:53:59 24645 8192000000 10930090304 11389018112 1946080400 19.195 100 20 40 0 2015516704 61591344 7844960
17:54:35 19140 8192000000 10933664016 11386667008 1950406816 19.230 100 30 61 0 2012721296 51545824 10768656
17:55:08 7530 8192000000 10940247280 11394793472 1953563888 19.255 100 34 68 0 2018268304 53355184 11349232
17:55:23 8261 8192000000 10928052416 11388551168 1955616256 19.271 100 23 46 0 2018771936 55281072 7874608
17:56:01 36996 8192000000 10917471344 11405303808 1908971760 18.898 98 24 48 3 1979241520 61694512 8575248
17:57:27 81532 8192000000 10893768736 11349950464 1869314560 18.579 96 17 34 1 1886176608 12251248 4610800
17:58:59 59626 8192000000 10916177520 11357429760 1962955984 19.330 100 24 48 2 1981296064 11072000 7268080
18:00:16 28475 8192000000 10890854576 11352973312 1945191776 19.188 99 18 36 2 1960512464 10505808 4814880
18:01:05 78655 8192000000 10891916704 11348389888 1913973760 18.939 97 22 43 1 1927612608 7925376 5713472
18:03:27 69926 8192000000 10911608320 11345362944 1925666864 19.032 98 25 50 2 1942851968 9762240 7422864
18:04:46 45305 8192000000 10917923808 11364687872 1969879200 19.384 100 41 82 3 1989837888 8023120 11935568
18:05:37 72966 8192000000 10915038048 11367776256 1934949104 19.106 98 24 48 0 1955136112 12852736 7334272
18:07:28 92447 8192000000 10906096656 11366223872 1962290784 19.324 99 34 68 2 1985323872 13832512 9200576
18:09:10 64349 8192000000 10922668096 11373268992 1964640176 19.343 99 19 38 0 1986744784 16446912 5657696
18:10:23 35952 8192000000 10941813632 11392716800 1984855456 19.503 100 40 78 0 2012078688 15152336 12070896
18:11:13 143836 8192000000 10922724288 11392409600 1974314560 19.420 99 19 38 0 1988912688 9258368 5339760
18:13:46 52576 8192000000 10947417136 11402620928 2005609280 19.667 100 55 113 1 2036756000 13978928 17167792
18:15:05 27157 8192000000 10938746448 11396067328 1990108400 19.545 99 49 96 3 2012310048 8924336 13277312
18:15:42 20168 8192000000 10905625328 11378741248 1955314432 19.269 98 41 82 1 1977074512 10464256 11295824
18:16:11 41388 8192000000 10909371392 11384561664 1947156256 19.204 98 21 42 3 1962116384 9181376 5778752
18:17:06 29092 8192000000 10904996720 11382063104 1968974976 19.377 99 15 31 1 1985662144 12417632 4269536
18:17:42 21946 8192000000 10886878080 11365257216 1950918480 19.234 99 11 22 0 1967248192 13096688 3233024
18:18:10 14664 8192000000 10866610112 11344252928 1942202960 19.164 99 4 8 0 1956346112 12939696 1203456
18:18:35 47946 8192000000 10888715296 11367862272 1952875488 19.249 99 15 30 0 1973297120 16100672 4320960
18:21:02 45390 8192000000 10885765296 11379879936 1974357424 19.420 100 6 12 0 1986648416 10547120 1743872
18:21:55 18976 8192000000 10892193696 11389517824 1981042928 19.473 100 8 16 1 1994216032 10081728 3091376
18:22:29 3665 8192000000 10898325840 11392430080 1981311056 19.475 100 11 22 1 1995454784 11217184 2926544
18:22:47 41523 8192000000 10880198848 11356123136 1917337728 18.966 97 7 14 0 1930535184 11107568 2089888
18:23:37 35677 8192000000 10867109072 11353993216 1920386144 18.990 98 9 18 1 1934447584 11583968 2477472
18:24:55 58155 8192000000 10883984576 11372843008 1951542032 19.239 99 21 42 0 1966428336 8548640 6337664
18:26:00 54855 8192000000 10896740768 11373584384 1953163152 19.252 99 8 16 0 1966126672 10979408 1984112
18:27:01 64223 8192000000 10893708704 11339419648 1859292304 18.498 94 26 51 0 1874022480 8055248 6674928
18:28:13 30248 8192000000 10882366656 11339886592 1938430416 19.134 99 44 86 1 1960104880 9511104 12163360
18:28:57 64038 8192000000 10871292944 11337490432 1864694544 18.541 95 17 34 1 1879760592 10575584 4490464
18:30:08 84476 8192000000 10854271776 11334582272 1836342880 18.311 94 19 38 2 1861046656 19717888 4985888
18:31:40 27983 8192000000 10883004512 11326087168 1881520496 18.677 97 31 61 1 1898720832 7852240 9348096
18:32:18 13130 8192000000 10864690160 11306979328 1862077312 18.520 96 57 113 1 1887189184 9306272 15805600
18:32:43 71955 8192000000 10836793648 11306328064 1859947168 18.503 97 20 40 0 1877142544 11630640 5564736
18:34:01 54802 8192000000 10836404160 11304275968 1844535184 18.378 96 20 40 1 1866502304 15881280 6085840
18:35:03 40677 8192000000 10852958896 11329478656 1914231824 18.941 100 13 26 1 1939055680 20617696 4206160
18:35:54 66163 8192000000 10853914304 11318288384 1882540624 18.686 98 6 12 0 1898040224 13962672 1536928
18:37:11 60296 8192000000 10854165632 11319623680 1859871600 18.502 96 9 18 1 1870557088 8409904 2275584
18:38:19 191927 8192000000 10858188208 11328389120 1882175296 18.683 97 20 40 2 1902112352 14145616 5791440
18:41:37 69965 8192000000 10859147792 11337998336 1934641376 19.104 100 6 12 0 1948873488 12445744 1786368
18:42:53 35582 8192000000 10869183808 11338870784 1910256672 18.909 98 28 56 0 1928838240 10350800 8230768
18:43:40 7153 8192000000 10874656960 11322073088 1917970560 18.971 98 62 123 4 1943136768 7217872 17948336
18:43:58 107956 8192000000 10861823008 11341168640 1909883088 18.906 98 23 45 0 1926235280 10199616 6152576
18:45:55 55492 8192000000 10876429184 11337654272 1943251408 19.173 100 23 46 4 1959916688 10176272 6489008
18:46:58 73391 8192000000 10833797200 11298775040 1839933776 18.340 95 19 38 1 1857092336 11353280 5805280
18:48:23 92230 8192000000 10835183344 11304726528 1882242240 18.683 98 14 28 0 1893535664 7405040 3888384
18:51:06 44260 8192000000 10861167312 11323736064 1908126240 18.892 99 20 38 1 1919483568 6139520 5217808
18:51:59 62132 8192000000 10859305648 11332964352 1917283648 18.965 99 25 50 0 1935500192 11365632 6850912
18:53:10 79372 8192000000 10893555216 11360346112 1954888208 19.265 100 16 32 1 1973155472 13844000 4423264
18:54:35 64228 8192000000 10907284160 11376902144 1967279984 19.364 100 19 36 0 1985916736 13589296 5047456
18:55:49 65045 8192000000 10896588384 11366338560 1889870224 18.745 96 11 22 0 1905920800 13025120 3025456
18:57:02 81278 8192000000 10896298848 11369279488 1911752176 18.921 97 13 26 0 1936621984 20483888 4385920
18:58:36 50397 8192000000 10898510192 11350036480 1925503104 19.031 98 14 27 1 1941179520 11975248 3701168
18:59:34 37846 8192000000 10904718928 11377102848 1972215888 19.403 100 23 46 0 1988874544 10438336 6220320
19:00:19 80482 8192000000 10904571440 11366215680 1881232880 18.675 95 12 24 1 1894128656 9885136 3010640
19:01:46 32987 8192000000 10923687584 11371413504 1955055584 19.267 99 41 82 2 1982920864 16692624 11172656
19:02:34 24489 8192000000 10919398656 11385053184 1974888160 19.424 100 37 73 2 2004604000 19678512 10037328
19:03:06 27363 8192000000 10922139520 11385978880 1963335280 19.333 99 29 58 2 1984648400 13436576 7876544
19:03:39 41415 8192000000 10902976960 11374694400 1945013008 19.187 98 24 48 0 1964412080 12484768 6914304
19:04:33 31266 8192000000 10907705728 11368566784 1933513008 19.095 98 24 48 2 1948007776 8157440 6337328
19:05:19 78504 8192000000 10894552288 11371712512 1938093200 19.132 98 12 24 2 1954173632 12949008 3131424
19:06:52 130698 8192000000 10901420880 11365183488 1918072320 18.971 97 28 56 1 1936259520 9817008 8370192
19:09:09 50804 8192000000 10901309536 11365654528 1936150256 19.116 98 25 50 0 1953643376 10257200 7235920
19:10:23 22997 8192000000 10899739152 11370221568 1969514736 19.382 100 30 60 1 1990514608 11850656 9149216
19:10:52 21639 8192000000 10900413760 11370491904 1962521968 19.326 99 26 52 1 1979891456 9904144 7465344
19:11:22 36602 8192000000 10890023744 11365761024 1948600560 19.215 99 15 29 1 1963531760 10585504 4345696
19:12:05 72118 8192000000 10904328352 11387183104 1957693008 19.288 99 12 25 0 1973127296 11762736 3671552
19:13:39 69954 8192000000 10885912576 11366797312 1924821088 19.025 97 17 33 0 1942880592 13006992 5052512
19:16:19 58871 8192000000 10867829728 11345461248 1915744576 18.953 97 19 37 3 1935509584 14400560 5364448
19:17:41 48114 8192000000 10876127632 11359051776 1903487328 18.854 97 26 52 0 1926804144 15856752 7460064
19:18:49 23067 8192000000 10852208320 11316097024 1878494080 18.653 96 27 54 4 1893245328 7007136 7744112
19:19:21 47256 8192000000 10855617744 11315920896 1841166576 18.350 95 20 40 0 1857483968 11068336 5249056
19:20:21 76310 8192000000 10877823520 11352453120 1913731968 18.937 98 28 52 0 1934960512 13682080 7546464
19:21:49 94740 8192000000 10867396032 11340062720 1908396336 18.894 98 17 34 2 1933818816 20625472 4797008
19:23:30 83965 8192000000 10886535632 11351924736 1914041520 18.939 98 18 36 0 1935142560 15948672 5152368
19:25:29 31491 8192000000 10879089472 11337637888 1910882368 18.914 98 23 47 0 1928989200 11549920 6556912
19:26:16 56158 8192000000 9215153152 9478918144 352611648 4.126 19 5 10 0 364382496 10349360 1421488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 01-12-2020 19:28:06 to 01-12-2020 19:28:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 88 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-12-2020 19:28:39 to 01-12-2020 19:28:41.

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          242772
MON$OLDEST_ACTIVE               242773
MON$OLDEST_SNAPSHOT             242773
MON$NEXT_TRANSACTION            242773
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                       2052704
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:189: 
:190: mscs-test-161.budzdorov.ru    Tue Dec  1 19:27:20 2020
:191:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:192: 
:193: 
:194: mscs-test-161.budzdorov.ru    Tue Dec  1 19:27:22 2020
:195:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:196: 
:197: 
:198: mscs-test-161.budzdorov.ru    Tue Dec  1 19:27:24 2020
:199:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:200: 
--- end of diff output ---

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

01.12.20 19:28:42. 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-01 19:28:44 No severe PSQL-related problems occured
01.12.20 19:28:46. End of report.