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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17327480 kB
MemAvailable 31438100 kB
Buffers 0 kB
Cached 14333232 kB
SwapCached 2540 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-25 16:27:09
DTS_END                         2020-12-25 16:27:09.6860
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(139:30) ==> SP_CANCEL_WRITE_OFF(41:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52648
TRN_ID                          240607
ATT_ID                          715
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: 9629.29 19504 1155515
customer order: creation 176.32 335 21158
customer order: refuse 15.28 315 1833
order to supplier: creation 46.98 1266 5637
order to supplier: removal 3.43 99141 412
invoice (draft): creation 48.01 3018 5761
invoice (draft): removal 54.94 744 6593
invoice accept: apply 43.03 16591 5164
invoice accept: cancel 49.33 783 5920
customer reserve: creation 4017.53 162 482103
customer reserve: removal 4869.67 55 584360
realization accept: apply 86.20 170 10344
realization accept: cancel 85.51 98 10261
payment from customer: creation 60.73 96 7287
payment from customer: removal 6.03 70 724
payment to supplier: creation 50.33 119 6040
payment to supplier: removal 3.41 44 409
service: total inventory turnovers 4.97 1007 596
service: total monetary turnovers 6.71 49 805
service: aggregate perf. data 0.87 21231 104
service: refresh index statistics 0.03 244783 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-12-2020 16:28:09 to 25-12-2020 16:28:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8539
TEST_TIME 2 6099
TEST_TIME 3 5198
TEST_TIME 4 5820
TEST_TIME 5 5572
TEST_TIME 6 5555
TEST_TIME 7 5910
TEST_TIME 8 6089
TEST_TIME 9 5987
TEST_TIME 10 6332
TEST_TIME 11 6371
TEST_TIME 12 6699
TEST_TIME 13 7523
TEST_TIME 14 7470
TEST_TIME 15 7904
TEST_TIME 16 8486
TEST_TIME 17 8494
TEST_TIME 18 8894
TEST_TIME 19 8993
TEST_TIME 20 9043
TEST_TIME 21 9391
TEST_TIME 22 9752
TEST_TIME 23 9901
TEST_TIME 24 10523
TEST_TIME 25 11492
TEST_TIME 26 11450
TEST_TIME 27 11318
TEST_TIME 28 11112
TEST_TIME 29 11273
TEST_TIME 30 11108
TEST_TIME 31 11056
TEST_TIME 32 10939
TEST_TIME 33 10773
TEST_TIME 34 10693
TEST_TIME 35 10473
TEST_TIME 36 10453
TEST_TIME 37 10412
TEST_TIME 38 10401
TEST_TIME 39 10392
TEST_TIME 40 10373
TEST_TIME 41 10198
TEST_TIME 42 10104
TEST_TIME 43 10039
TEST_TIME 44 10132
TEST_TIME 45 10165
TEST_TIME 46 10096
TEST_TIME 47 9975
TEST_TIME 48 9833
TEST_TIME 49 9899
TEST_TIME 50 9807
TEST_TIME 51 9840
TEST_TIME 52 9834
TEST_TIME 53 9913
TEST_TIME 54 9904
TEST_TIME 55 9916
TEST_TIME 56 10079
TEST_TIME 57 10030
TEST_TIME 58 10051
TEST_TIME 59 10132
TEST_TIME 60 10126
TEST_TIME 61 10072
TEST_TIME 62 10175
TEST_TIME 63 10023
TEST_TIME 64 9956
TEST_TIME 65 9980
TEST_TIME 66 9929
TEST_TIME 67 9852
TEST_TIME 68 9766
TEST_TIME 69 9696
TEST_TIME 70 9769
TEST_TIME 71 9750
TEST_TIME 72 9798
TEST_TIME 73 9750
TEST_TIME 74 9776
TEST_TIME 75 9854
TEST_TIME 76 9853
TEST_TIME 77 9933
TEST_TIME 78 9919
TEST_TIME 79 9937
TEST_TIME 80 9909
TEST_TIME 81 10058
TEST_TIME 82 9990
TEST_TIME 83 9931
TEST_TIME 84 9966
TEST_TIME 85 9889
TEST_TIME 86 9861
TEST_TIME 87 9797
TEST_TIME 88 9739
TEST_TIME 89 9678
TEST_TIME 90 9755
TEST_TIME 91 9819
TEST_TIME 92 9807
TEST_TIME 93 9793
TEST_TIME 94 9831
TEST_TIME 95 9849
TEST_TIME 96 9922
TEST_TIME 97 9909
TEST_TIME 98 9904
TEST_TIME 99 9939
TEST_TIME 100 9977
TEST_TIME 101 9988
TEST_TIME 102 10016
TEST_TIME 103 10072
TEST_TIME 104 10031
TEST_TIME 105 9953
TEST_TIME 106 9911
TEST_TIME 107 9893
TEST_TIME 108 9891
TEST_TIME 109 9831
TEST_TIME 110 9834
TEST_TIME 111 9790
TEST_TIME 112 9779
TEST_TIME 113 9734
TEST_TIME 114 9723
TEST_TIME 115 9685
TEST_TIME 116 9685
TEST_TIME 117 9656
TEST_TIME 118 9692
TEST_TIME 119 9704
TEST_TIME 120 9636

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-12-2020 16:28:13 to 25-12-2020 16:28:16.

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 1601147 1601147 0 0.00 0 20854 6 0 0
doc_list_biud 1601143 1601143 0 0.00 0 32471 26 0 0
sp_add_invoice_to_stock 5255 5164 91 1.73 31 224714 16592 0 91
sp_cancel_adding_invoice 5920 5920 0 0.00 5 61591 783 0 0
sp_cancel_client_order 1833 1833 0 0.00 4 8385 315 0 0
sp_cancel_customer_reserve 584360 584360 0 0.00 1 32473 56 0 0
sp_cancel_pay_from_customer 724 724 0 0.00 2 5492 70 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 3 1031 45 0 0
sp_cancel_supplier_invoice 6600 6593 7 0.10 1 14117 744 0 7
sp_cancel_supplier_order 412 412 0 0.00 8 971578 99142 0 0
sp_cancel_write_off 10261 10261 0 0.00 1 8651 98 0 0
sp_client_order 21158 21158 0 0.00 3 54899 336 0 0
sp_customer_reserve 482103 482103 0 0.00 0 120475 163 0 0
sp_fill_shopping_cart 32555 32555 0 0.00 1 9516 33 0 0
sp_fill_shopping_cart_clo_res 482095 482095 0 0.00 0 18931 13 0 0
sp_get_clo_for_invoice 5156 5156 0 0.00 0 30329 296 0 0
sp_kill_cost_storno 17314 17314 0 0.00 0 19865 51 0 0
sp_kill_qstorno_ret_qs2qd 1185986 1185986 0 0.00 0 32467 30 0 0
sp_kill_qty_storno 624877 624877 0 0.00 0 32471 65 0 0
sp_lock_selected_doc 21447 21447 0 0.00 0 8955 7 0 0
sp_make_cost_storno 28827 28827 0 0.00 0 20842 60 0 0
sp_multiply_rows_for_pdistr 28827 28827 0 0.00 0 7750 24 0 0
sp_multiply_rows_for_qdistr 21158 21158 0 0.00 0 34092 155 0 0
sp_pay_from_customer 7287 7287 0 0.00 4 13942 97 0 0
sp_pay_to_supplier 6040 6040 0 0.00 4 13415 120 0 0
sp_payment_common 13325 13325 0 0.00 1 9413 27 0 0
sp_qd_handle_on_cancel_clo 1833 1833 0 0.00 0 8376 286 0 0
sp_qd_handle_on_invoice_upd_sts 11074 11074 0 0.00 0 23459 299 0 0
sp_qd_handle_on_reserve_upd_sts 10344 10344 0 0.00 0 16832 60 0 0
sp_reserve_write_off 10344 10344 0 0.00 6 21396 171 0 0
sp_supplier_invoice 5761 5761 0 0.00 6 77896 3019 0 0
sp_supplier_order 5637 5637 0 0.00 6 32438 1266 0 0
srv_aggregate_perf_data 104 104 0 0.00 2658 461952 21232 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1302 156700 32894 0 0
srv_find_qd_qs_mism 1105783 1105783 0 0.00 0 14159 5 0 0
srv_make_invnt_saldo 596 596 0 0.00 24 81228 1007 0 0
srv_make_money_saldo 805 805 0 0.00 1 12202 50 0 0
srv_recalc_idx_stat 4 4 0 0.00 120600 376362 244783 0 0
t$perf-abend:sp_add_invoice_to_stock 91 91 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5167 5167 0 0.00 0 10528 169 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 5369 106 0 0
t$perf-norm:sp_cancel_client_order 1833 1833 0 0.00 0 3513 14 0 0
t$perf-norm:sp_cancel_customer_reserve 687 687 0 0.00 0 3791 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 724 724 0 0.00 0 645 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 1866 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 441 441 0 0.00 0 5082 20 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 24669 1669 0 0
t$perf-norm:sp_cancel_write_off 1030 1030 0 0.00 0 6105 12 0 0
t$perf-norm:sp_client_order 21158 21158 0 0.00 0 10522 16 0 0
t$perf-norm:sp_customer_reserve 1029 1029 0 0.00 0 972 6 0 0
t$perf-norm:sp_pay_from_customer 7287 7287 0 0.00 0 6450 9 0 0
t$perf-norm:sp_pay_to_supplier 6040 6040 0 0.00 0 9195 13 0 0
t$perf-norm:sp_reserve_write_off 10344 10344 0 0.00 0 7246 12 0 0
t$perf-norm:sp_supplier_invoice 5761 5761 0 0.00 0 8421 19 0 0
t$perf-norm:sp_supplier_order 5637 5637 0 0.00 0 7823 19 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 480 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 1513 24 0 0
t$perf-norm:srv_make_invnt_saldo 596 596 0 0.00 0 602 14 0 0
t$perf-norm:srv_make_money_saldo 805 805 0 0.00 0 442 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10486 10304 182 1.73 0 9288 17 0 182
v_all_customers 38358 38358 0 0.00 0 90 0 0 0
v_all_suppliers 31900 31900 0 0.00 0 124 1 0 0
v_all_wares 42316 42316 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 2377 12 0 0
v_cancel_client_order 3666 3666 0 0.00 0 1761 4 0 0
v_cancel_customer_prepayment 1448 1448 0 0.00 0 1550 4 0 0
v_cancel_customer_reserve 1374 1374 0 0.00 0 703 4 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 346 3 0 0
v_cancel_supplier_invoice 896 882 14 1.56 0 872 14 0 14
v_cancel_supplier_order 824 824 0 0.00 0 1563 6 0 0
v_cancel_write_off 2060 2060 0 0.00 0 2489 14 0 0
v_max_id_clo_ord 5636 5636 0 0.00 0 2421 1 0 0
v_max_id_clo_res 1029 1029 0 0.00 0 6800 26 0 0
v_max_id_ord_sup 5761 5761 0 0.00 0 4609 4 0 0
v_max_non_paid_invoice 1487 1487 0 0.00 0 541 2 0 0
v_max_non_paid_realizn 3916 3916 0 0.00 0 2077 3 0 0
v_min_id_clo_ord 5636 5636 0 0.00 0 2464 4 0 0
v_min_id_clo_res 1029 1029 0 0.00 0 5490 13 0 0
v_min_id_ord_sup 5761 5761 0 0.00 0 5035 5 0 0
v_min_non_paid_invoice 6040 6040 0 0.00 0 7172 18 0 0
v_min_non_paid_realizn 7285 7285 0 0.00 0 7423 16 0 0
v_our_firm 10696 10696 0 0.00 0 157 1 0 0
v_reserve_write_off 20688 20688 0 0.00 0 3512 5 0 0
x_lock_depdocs_on_canc_invoice 12072 12072 0 0.00 0 34141 123 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 9571 318 0 0
x_make_qstorno_1000_1200 5637 5637 0 0.00 2 32414 1200 0 0
x_make_qstorno_1200_2000 5761 5761 0 0.00 3 76824 2899 0 0
x_make_qstorno_2100_3300 482103 482103 0 0.00 0 120475 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-12-2020 16:28:17 to 25-12-2020 16:28:21.

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:13 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:19 9020 8192000000 10190157680 10492170240 819119584 9.090 64 48 96 1 837262672 2203792 15939296
13:57:35 32963 8192000000 10347111968 10667347968 1362430192 14.259 100 84 169 0 1394902128 4386352 28085584
13:58:17 23305 8192000000 10391623440 10718646272 1442501280 14.972 100 95 190 1 1480737824 6765536 31471008
13:58:48 36406 8192000000 10430523072 10760712192 1482499360 15.323 100 94 188 0 1520701488 8167152 30034976
13:59:38 16514 8192000000 10445850512 10782199808 1499977744 15.476 100 88 176 1 1537247008 9084560 28184704
14:00:06 29330 8192000000 10458774864 10798895104 1516630032 15.621 100 88 176 0 1554457552 9897712 27929808
14:00:43 21681 8192000000 10481851136 10823069696 1537658400 15.803 100 89 178 3 1576111792 10438176 28015216
14:01:12 22574 8192000000 10510267488 10858823680 1552507488 15.932 100 85 170 1 1589759968 11076928 26175552
14:01:47 17712 8192000000 10546187376 10898030592 1587671840 16.234 100 83 166 0 1624168800 10951648 25545312
14:02:13 17141 8192000000 10560901168 10918584320 1610942656 16.433 100 83 166 0 1647902016 11605584 25353776
14:02:40 17359 8192000000 10590463536 10951974912 1640005584 16.680 100 76 152 0 1673996416 11410816 22580016
14:03:05 13560 8192000000 10597895264 10961739776 1652027632 16.782 100 76 152 0 1686778832 11940480 22810720
14:03:28 8292 8192000000 10612153632 10982731776 1678634240 17.006 100 81 162 2 1714480416 12232672 23613504
14:03:46 11943 8192000000 10635933712 11006431232 1690064800 17.102 100 76 152 0 1724147600 12063312 22019488
14:04:05 8837 8192000000 10655201216 11025129472 1714512240 17.306 100 85 171 0 1752129568 13113600 24503728
14:04:23 8648 8192000000 10661850496 11037859840 1722146112 17.370 100 79 159 2 1758135024 13475488 22513424
14:04:39 7873 8192000000 10675758416 11046731776 1729154720 17.428 100 74 148 0 1767862400 17862608 20845072
14:04:57 6012 8192000000 10682555936 11059204096 1744260976 17.554 100 76 152 1 1779519744 13770992 21487776
14:05:11 4712 8192000000 10705979856 11082588160 1758186592 17.669 100 87 173 3 1796916272 13400672 25329008
14:05:23 4573 8192000000 10703856080 11085197312 1767370608 17.745 100 77 154 2 1802367184 12790896 22205680
14:05:34 4120 8192000000 10722410224 11101257728 1776603120 17.821 100 73 146 2 1808667616 11607024 20457472
14:05:46 3880 8192000000 10716230752 11101941760 1783238816 17.876 100 72 142 0 1815814784 12989824 19586144
14:05:58 6686 8192000000 10711534480 11101581312 1783523120 17.878 100 76 152 1 1818517488 13744608 21249760
14:06:12 3551 8192000000 10729892624 11115360256 1787586688 17.912 100 75 149 1 1821112976 13160544 20365744
14:06:22 1965 8192000000 10745227520 11128496128 1803075328 18.039 100 83 165 1 1841570528 13971328 24523872
14:06:31 3009 8192000000 10748888208 11134951424 1808686336 18.085 100 81 162 1 1844684352 13588224 22409792
14:06:41 3547 8192000000 10741883040 11138355200 1817571040 18.158 100 83 165 0 1854090688 12746048 23773600
14:06:51 2155 8192000000 10764346304 11147563008 1821902128 18.193 100 83 165 1 1861524688 16155744 23466816
14:07:00 3616 8192000000 10770561760 11160244224 1831945264 18.275 100 90 171 2 1872196480 16088336 24162880
14:07:10 2043 8192000000 10772807664 11156090880 1836685408 18.314 100 89 178 0 1874720992 12883520 25152064
14:07:19 1371 8192000000 10784546096 11174342656 1842865552 18.364 100 85 169 0 1878471504 12771504 22834448
14:07:27 2732 8192000000 10780897120 11168985088 1842693360 18.363 100 83 164 1 1878563120 12875264 22994496
14:07:37 1620 8192000000 10794874096 11178524672 1849152448 18.415 100 91 181 0 1888485776 13883200 25450128
14:07:45 2766 8192000000 10787443104 11179548672 1848561728 18.410 100 85 170 0 1885660224 13257856 23840640
14:07:54 1931 8192000000 10795179360 11182157824 1851062272 18.431 100 95 189 1 1890453520 13337824 26053424
14:08:02 1618 8192000000 10797277984 11183259648 1852127120 18.439 100 95 191 1 1890696800 11899632 26670048
14:08:10 1551 8192000000 10797988016 11187712000 1854117376 18.456 100 91 182 1 1892221680 12232832 25871472
14:08:18 1720 8192000000 10802911088 11190824960 1856411376 18.474 100 91 180 0 1894831280 12573760 25846144
14:08:26 33644 8192000000 10786205808 11188563968 1857323600 18.482 100 55 111 0 1881617280 8241856 16051824
14:09:09 7182 8192000000 10793446560 11191562240 1856861824 18.478 100 52 103 0 1879488080 8155600 14470656
14:09:23 2609 8192000000 10784810896 11190935552 1856025792 18.471 100 51 102 0 1880661712 9581360 15054560
14:09:33 2152 8192000000 10776294688 11192946688 1856487680 18.475 100 49 98 2 1879660000 9513808 13658512
14:09:42 4160 8192000000 10780961104 11191504896 1856264656 18.473 100 36 72 0 1874691680 8585648 9841376
14:09:53 3984 8192000000 10781306912 11194560512 1856302928 18.473 100 35 70 0 1877853440 11758832 9791680
14:10:06 11495 8192000000 10769648960 11190427648 1855916720 18.470 100 21 42 1 1868249216 6587488 5745008
14:10:25 5923 8192000000 10778344368 11195310080 1865733056 18.550 100 39 78 0 1885230000 8573088 10923856
14:10:40 5573 8192000000 10765120128 11197186048 1863839168 18.534 100 24 48 1 1877857472 6830384 7187920
14:10:52 6869 8192000000 10771370480 11199832064 1866039136 18.552 100 15 30 0 1876331120 6350240 3941744
14:11:06 10574 8192000000 10780556640 11208372224 1870254560 18.586 100 25 48 2 1884012832 7124320 6633952
14:11:22 7993 8192000000 10782587328 11209670656 1872920576 18.608 100 24 49 1 1886174448 6915440 6338432
14:11:37 10805 8192000000 10787163696 11212750848 1874036464 18.617 100 19 38 1 1884979232 5658976 5283792
14:12:02 12618 8192000000 10786789312 11219738624 1876484608 18.637 100 23 46 0 1888575232 6197264 5893360
14:12:22 7855 8192000000 10789348928 11213275136 1877707536 18.647 100 21 42 1 1889497408 5491008 6298864
14:12:37 24847 8192000000 10790050272 11224551424 1879972688 18.665 100 18 36 2 1890825440 5452288 5400464
14:13:25 23474 8192000000 10833570576 11235352576 1889651936 18.743 100 71 141 2 1916274496 5840304 20782256
14:13:55 4009 8192000000 10802449632 11229310976 1886020480 18.714 100 38 74 2 1904969744 8607920 10341344
14:14:06 5078 8192000000 10806556576 11229483008 1887705744 18.727 100 33 66 0 1904260304 7231968 9322592
14:14:17 5013 8192000000 10816367744 11241586688 1894315088 18.781 100 40 79 1 1913340224 7227072 11798064
14:14:29 3628 8192000000 10815977072 11241492480 1895782384 18.792 100 47 94 1 1916666928 7641088 13243456
14:14:39 6393 8192000000 10815796832 11241758720 1895175792 18.787 100 35 71 2 1911718960 6834096 9709072
14:14:53 6261 8192000000 10818592752 11247190016 1896964048 18.802 100 30 62 0 1912884880 6740736 9180096
14:15:11 9915 8192000000 10807042352 11244195840 1896921712 18.802 100 16 33 1 1907691632 6368992 4400928
14:15:27 8206 8192000000 10811154848 11246788608 1899491440 18.822 100 22 44 0 1911771728 5814672 6465616
14:15:42 4268 8192000000 10791310864 11228827648 1881806432 18.680 99 31 62 2 1898167760 6945888 9415440
14:15:52 8743 8192000000 10803101392 11234164736 1887570384 18.726 100 27 54 0 1901117648 5982352 7564912
14:16:07 10649 8192000000 10799503536 11228114944 1870940896 18.592 99 10 20 0 1879072640 5318224 2813520
14:16:26 14370 8192000000 10789043584 11224371200 1870794528 18.591 99 31 63 3 1885667440 6094064 8778848
14:16:47 51610 8192000000 10793996688 11226673152 1853399920 18.450 98 29 58 0 1867014624 5400912 8213792
14:17:45 8950 8192000000 10797611536 11229900800 1866889584 18.559 99 13 26 2 1875291120 4878208 3523328
14:18:01 4360 8192000000 10799533936 11227299840 1885157536 18.707 100 28 56 0 1899055408 6415344 7482528
14:18:14 5621 8192000000 10742065856 11154276352 1774658096 17.805 95 35 66 1 1791294224 6486160 10149968
14:18:28 5230 8192000000 10729362976 11157331968 1781179184 17.859 97 28 56 1 1800145456 10654704 8311568
14:18:40 6522 8192000000 10732782240 11149934592 1799293936 18.008 99 35 70 3 1820508480 11806928 9407616
14:18:53 10715 8192000000 10740169520 11163410432 1792969248 17.956 98 21 42 1 1804486896 5406176 6111472
14:19:10 10107 8192000000 10714285104 11134566400 1723308544 17.380 95 16 32 0 1733098704 5319680 4470480
14:19:27 6691 8192000000 10722529312 11144462336 1792339664 17.951 99 21 43 4 1803828992 5845104 5644224
14:19:40 8621 8192000000 10727569440 11149201408 1792214224 17.950 98 22 42 1 1803881152 5661200 6005728
14:19:57 7495 8192000000 10726816944 11136827392 1762164656 17.702 97 19 37 1 1776967024 9246480 5555888
14:20:12 6766 8192000000 10729261600 11142639616 1750061552 17.602 96 16 32 3 1759913232 5031072 4820608
14:20:25 12993 8192000000 10697789584 11117072384 1736972480 17.493 96 26 50 5 1749850480 5386976 7491024
14:20:44 45790 8192000000 10673332544 11093962752 1674243968 16.969 93 23 45 1 1686242176 5327872 6670336
14:21:38 36333 8192000000 10678979008 11098316800 1650318256 16.767 92 20 40 0 1661266528 5146208 5802064
14:22:20 8236 8192000000 10702106352 11112972288 1760530016 17.689 99 32 64 1 1775602432 6074832 8997584
14:22:37 6944 8192000000 10715892544 11128422400 1797525984 17.994 100 39 77 1 1816878736 8345280 11007472
14:22:53 7009 8192000000 10740828704 11158478848 1822974752 18.202 100 31 62 1 1837934432 5598464 9361216
14:23:09 7703 8192000000 10745902448 11163598848 1809993360 18.096 99 24 48 1 1823062192 5689264 7379568
14:23:23 6826 8192000000 10751579216 11171913728 1827012000 18.235 100 12 25 0 1835416736 4736640 3668096
14:23:35 8464 8192000000 10743307520 11167154176 1818779152 18.168 99 25 49 2 1831603088 5420976 7402960
14:23:53 6296 8192000000 10750389952 11174203392 1837202848 18.318 100 29 59 1 1851255904 5632624 8420432
14:24:09 8139 8192000000 10754893040 11176312832 1839106944 18.334 100 31 62 0 1854909360 5984064 9818352
14:24:26 7975 8192000000 10750792208 11179323392 1842075392 18.358 100 17 35 2 1852487504 5004464 5407648
14:24:40 8042 8192000000 10766275200 11186806784 1850356240 18.425 100 24 48 0 1863456400 5959824 7140336
14:24:55 10955 8192000000 10764949552 11194494976 1851858176 18.437 100 12 23 1 1861192848 5748624 3586048
14:25:12 11465 8192000000 10758420048 11194425344 1854845424 18.461 100 14 26 0 1863632256 4928576 3858256
14:25:31 6642 8192000000 10776853904 11194834944 1858121328 18.488 100 21 42 3 1870239040 6333712 5784000
14:25:45 58408 8192000000 10763663984 11199856640 1860589744 18.508 100 28 56 1 1874140416 5215984 8334688
14:26:54 17646 8192000000 10788299056 11219517440 1870767232 18.590 100 20 40 2 1881822816 5383104 5672480
14:27:34 14269 8192000000 10816256368 11235606528 1890512736 18.750 100 43 81 3 1908253056 5268624 12471696
14:27:55 7462 8192000000 10844465056 11260071936 1907788400 18.889 100 46 91 0 1928124960 7099248 13237312
14:28:12 6525 8192000000 10854371760 11272728576 1920417600 18.990 100 59 117 2 1947843312 9610704 17815008
14:28:25 25846 8192000000 10862624464 11282587648 1927218624 19.045 100 52 104 0 1951783888 9644400 14920864
14:28:58 18508 8192000000 10864140592 11293339648 1934290224 19.101 100 42 84 0 1957590720 11841280 11459216
14:29:25 7401 8192000000 10877849168 11298852864 1939583328 19.143 100 52 104 0 1967177888 13336896 14257664
14:29:45 13537 8192000000 10873929952 11303432192 1942025584 19.163 100 45 90 1 1967506704 13069008 12412112
14:30:12 44966 8192000000 10883026768 11314081792 1947636832 19.208 100 43 84 2 1975112656 15834832 11640992
14:31:09 8897 8192000000 10897840752 11324428288 1959161552 19.299 100 50 100 2 1990230720 15963472 15105696
14:31:30 19138 8192000000 10893238208 11331919872 1959612352 19.303 100 39 78 1 1988967936 17399632 11955952
14:32:04 6872 8192000000 10904650592 11335774208 1967551296 19.366 100 35 68 1 1994268112 16309696 10407120
14:32:22 9084 8192000000 10919722672 11345715200 1976080416 19.434 100 57 114 3 2010490960 17234624 17175920
14:32:38 5929 8192000000 10926233680 11348119552 1976897952 19.440 100 56 112 1 2010618224 18080480 15639792
14:32:55 15437 8192000000 10922351168 11354255360 1980605744 19.469 100 56 110 2 2016586896 19505440 16475712
14:33:17 18077 8192000000 10921336752 11354370048 1979724464 19.463 100 36 72 3 2012690736 21652688 11313584
14:33:53 12653 8192000000 10930089920 11358986240 1982755104 19.487 100 50 100 1 2020813568 22717872 15340592
14:34:25 7125 8192000000 10925824528 11362037760 1983091152 19.489 100 42 84 2 2015989904 19972064 12926688
14:34:41 6608 8192000000 10938899664 11368996864 1988991152 19.536 100 51 100 1 2026022544 21604720 15426672
14:35:00 13222 8192000000 10941732000 11375140864 1992014896 19.560 100 56 111 0 2033107488 24408480 16684112
14:35:29 11230 8192000000 10954007344 11381633024 1995998672 19.591 100 52 104 2 2037053712 24852208 16202832
14:35:48 11266 8192000000 10939139488 11380502528 1998934000 19.614 100 54 109 1 2037446320 22467008 16045312
14:36:07 4588 8192000000 10952680752 11382816768 2001475840 19.634 100 68 136 2 2045995360 23838064 20681456
14:36:19 5753 8192000000 10958094208 11390193664 2005618784 19.667 100 56 112 0 2046499584 23478768 17402032
14:36:34 10084 8192000000 10951069632 11384627200 2001191216 19.632 100 59 119 1 2044039584 24832880 18015488
14:36:58 14345 8192000000 10960615344 11397136384 2005310048 19.665 100 53 105 0 2046885776 25662704 15913024
14:37:20 10719 8192000000 10967689264 11403563008 2009738272 19.699 100 53 106 1 2055365088 29013056 16613760
14:37:39 6631 8192000000 10967276672 11406368768 2015279888 19.743 100 54 108 1 2062348592 29275264 17793440
14:37:53 4592 8192000000 10962493888 11385921536 1986575392 19.517 99 71 140 0 2037175616 29552064 21048160
14:38:09 4956 8192000000 10968984368 11388690432 2000563904 19.627 100 82 164 1 2055525632 30558352 24403376
14:38:23 8594 8192000000 10972053776 11396816896 2003286304 19.649 100 67 132 3 2055427936 32502256 19639376
14:38:39 3391 8192000000 10979233344 11400224768 1994057200 19.576 99 87 173 0 2056109296 35592448 26459648
14:38:51 2391 8192000000 10984476624 11406667776 2009088496 19.694 100 79 157 1 2069656592 36783888 23784208
14:39:04 10895 8192000000 10983150640 11411644416 2011162928 19.711 100 71 141 2 2071676752 38438032 22075792
14:39:25 6032 8192000000 10983420576 11418701824 2017353696 19.759 100 61 122 2 2077101216 39702240 20045280
14:39:42 7507 8192000000 10979289952 11420164096 2018494016 19.768 100 57 114 1 2075273584 37946192 18833376
14:40:06 10596 8192000000 10992147488 11429629952 2025201344 19.821 100 62 122 0 2082204032 37167680 19835008
14:40:23 12562 8192000000 10995594592 11440082944 2030196832 19.860 100 63 125 2 2087962656 38190864 19574960
14:40:44 4549 8192000000 11005827264 11443163136 2034350368 19.893 100 56 109 1 2087444432 35528880 17565184
14:40:58 6404 8192000000 11002488032 11439529984 2035746560 19.904 100 62 122 2 2086158176 31606768 18804848
14:41:13 8056 8192000000 11002963056 11440820224 2032832064 19.881 100 67 134 3 2087831232 34238464 20760704
14:41:32 7396 8192000000 11000516096 11435958272 2027867232 19.842 100 66 132 3 2085713360 37006080 20840048
14:41:48 3425 8192000000 11006289168 11445821440 2031432512 19.870 100 63 126 3 2091021104 39770736 19817856
14:42:00 3323 8192000000 11004728256 11437826048 2016422800 19.752 99 77 147 2 2078318048 38748432 23146816
14:42:14 2313 8192000000 11001733232 11427647488 2020555792 19.785 100 77 152 2 2084060944 39128048 24377104
14:42:23 3273 8192000000 10988310288 11414188032 2005690544 19.668 99 81 159 0 2070823168 40454992 24677632
14:42:34 3563 8192000000 10982314880 11412070400 2012063152 19.718 100 74 147 0 2070563520 36107952 22392416
14:42:44 2991 8192000000 10976325312 11404902400 2004955088 19.662 100 81 159 2 2065052896 35119200 24978608
14:42:57 1765 8192000000 10986801456 11416428544 2012438048 19.721 100 69 137 3 2071000864 37136000 21426816
14:43:08 2584 8192000000 10953286224 11381604352 1977203584 19.443 98 63 126 0 2032582592 36044464 19334544
14:43:19 3037 8192000000 10984369344 11402428416 1999734848 19.621 100 87 170 1 2063744256 36907424 27101984
14:43:30 3782 8192000000 10977879360 11409444864 2001275312 19.633 100 67 133 0 2062288192 40501120 20511760
14:43:47 9377 8192000000 10943471648 11380862976 1987137200 19.521 99 57 113 3 2040107744 35644704 17325840
14:44:04 10052 8192000000 10957960336 11387674624 1983286592 19.491 99 60 116 0 2034749360 33563888 17898880
14:44:28 6279 8192000000 10976866672 11413590016 2006308976 19.672 100 55 110 1 2062427456 38403792 17714688
14:44:42 5520 8192000000 10971836304 11409035264 2003508320 19.650 100 48 94 1 2056673936 37851104 15314512
14:45:00 5680 8192000000 10981648400 11414900736 1986881328 19.519 99 69 138 1 2047225648 38196352 22147968
14:45:16 2538 8192000000 10984496144 11404505088 1997161872 19.600 100 83 166 0 2062958304 39309744 26486688
14:45:26 5432 8192000000 10975844880 11402207232 1992923936 19.567 100 72 144 3 2056983456 41425280 22634240
14:45:40 10347 8192000000 10966476448 11403214848 1989870640 19.543 100 45 90 0 2049837952 45217968 14749344
14:45:59 8367 8192000000 10934219168 11380047872 1948862624 19.217 98 40 80 1 1997655056 35056048 13736384
14:46:15 6802 8192000000 10925384736 11367759872 1937977584 19.131 98 38 76 1 1985708512 34199776 13531152
14:46:29 7420 8192000000 10931581264 11369594880 1955193456 19.268 99 37 72 0 1999290624 31358176 12738992
14:47:02 15297 8192000000 10939131216 11384307712 1976896736 19.440 100 39 78 2 2024976032 35242048 12837248
14:47:28 10754 8192000000 10943749536 11386142720 1976728656 19.439 100 37 74 0 2025957504 36686800 12542048
14:47:52 6259 8192000000 10940857040 11378552832 1955350464 19.269 99 47 92 2 2010625456 40198288 15076704
14:48:07 5881 8192000000 10938827520 11371724800 1948880224 19.218 99 50 98 0 2006980096 41854736 16245136
14:48:21 3439 8192000000 10938305216 11360301056 1944433872 19.182 99 66 131 2 2005976624 41388656 20154096
14:48:31 1300 8192000000 10958153264 11370680320 1948212672 19.212 99 89 178 3 2021119936 44360928 28546336
14:48:39 14770 8192000000 10930224464 11380195328 1948816016 19.217 99 46 92 0 2010368720 46280832 15271872
14:49:08 20460 8192000000 10911814576 11359895552 1934299824 19.101 99 28 56 3 1981394656 37471824 9623008
14:49:39 27631 8192000000 10918298864 11367780352 1957124400 19.283 100 30 60 1 2006073184 38526704 10422080
14:50:14 24457 8192000000 10917187664 11373678592 1954637968 19.263 100 33 66 1 2010901552 44839904 11423680
14:50:49 34720 8192000000 10893868144 11371745280 1929687840 19.064 99 24 48 0 1976527264 38286720 8552704
14:51:33 31438 8192000000 10890850944 11350601728 1930313840 19.069 100 18 36 1 1971532672 34771120 6447712
14:52:10 17051 8192000000 10847590672 11295297536 1841872736 18.356 96 12 25 0 1883729632 37459296 4397600
14:52:46 23567 8192000000 10806886096 11262214144 1865068288 18.544 99 16 32 0 1885043600 15077952 4897360
14:53:27 82039 8192000000 10815351920 11261681664 1784439536 17.886 94 9 18 0 1795595504 8801248 2354720
14:54:55 41838 8192000000 10847744288 11292573696 1898664960 18.816 100 26 52 1 1915743872 9611696 7467216
14:55:43 58282 8192000000 10865867408 11316686848 1899837984 18.825 99 25 50 2 1919636000 12526608 7271408
14:56:47 111312 8192000000 10883691200 11330580480 1880524592 18.669 97 18 36 1 1901103728 15597936 4981200
14:59:33 116046 8192000000 10861015136 11314020352 1894797376 18.784 97 21 42 1 1910459152 9573312 6088464
15:01:36 86193 8192000000 10872583936 11335745536 1904491712 18.862 98 19 38 0 1923260640 13155952 5612976
15:03:09 26476 8192000000 10866223072 11313254400 1917831568 18.969 99 25 50 1 1933095456 8034208 7229680
15:03:56 39102 8192000000 10878130720 11324747776 1941153760 19.156 100 36 72 3 1962395856 10551344 10690752
15:04:44 23059 8192000000 10871368208 11323858944 1927728304 19.049 99 42 84 1 1950684176 10340832 12615040
15:05:19 6619 8192000000 10899981696 11334160384 1949233712 19.220 100 56 107 3 1976633136 10886176 16513248
15:05:36 17392 8192000000 10878920336 11327463424 1917445696 18.966 98 40 80 0 1939524096 10635136 11443264
15:06:10 24365 8192000000 10885123504 11336990720 1953495024 19.254 100 44 86 1 1976868096 10355952 13017120
15:06:51 87027 8192000000 10876355440 11340984320 1930825424 19.073 99 11 22 0 1942247840 8555312 2867104
15:08:24 117118 8192000000 10887206112 11349139456 1943037760 19.171 99 21 42 0 1958893280 9579792 6275728
15:10:39 116175 8192000000 10896825184 11381379072 1965910512 19.353 100 23 46 0 1993401968 20283728 7207728
15:12:46 30191 8192000000 10903691712 11360083968 1970336368 19.388 100 15 30 0 1984252912 9820864 4095680
15:13:28 31799 8192000000 10893220688 11366100992 1975879696 19.432 100 21 44 0 1988038320 6337792 5820832
15:14:22 87236 8192000000 10903653104 11378769920 1983783952 19.495 100 15 30 1 1998585568 10664704 4136912
15:15:57 59298 8192000000 10890095712 11385257984 1978325808 19.451 100 12 24 1 1995370096 13463104 3581184
15:17:03 8294 8192000000 10890198464 11385643008 1976196480 19.435 100 2 4 0 1987738416 10966896 575040
15:17:17 37326 8192000000 10944650384 11395096576 1983448000 19.492 100 19 38 0 1997306416 8104896 5753520
15:18:03 47000 8192000000 10918673424 11396505600 1993636464 19.573 100 17 34 0 2013216160 14650432 4929264
15:19:09 40165 8192000000 10922963728 11394777088 1977986240 19.449 99 24 47 2 1993952176 9085328 6880608
15:20:03 34891 8192000000 10914142336 11389272064 1980167296 19.466 99 38 77 2 2000970432 9440400 11362736
15:20:44 36666 8192000000 10916202176 11384250368 1941598080 19.160 97 20 39 0 1955016672 7981584 5437008
15:21:28 61879 8192000000 10925998256 11386200064 1952801408 19.249 98 14 28 2 1969438224 12388480 4248336
15:22:50 51971 8192000000 10903932400 11379499008 1963412048 19.333 99 12 24 1 1984286304 17435840 3438416
15:23:49 23348 8192000000 10891945248 11360882688 1904926800 18.866 96 29 56 2 1923496656 9949472 8620384
15:24:18 40231 8192000000 10922539760 11382960128 1970770848 19.392 100 29 57 0 1993009408 14003968 8234592
15:25:08 47520 8192000000 10898096960 11369742336 1923689328 19.016 97 25 50 0 1942840480 11908464 7242688
15:26:05 54242 8192000000 10890739728 11360452608 1933302896 19.093 98 7 14 1 1946998416 11919472 1776048
15:27:08 31752 8192000000 10906465600 11363373056 1940976352 19.155 98 33 66 1 1958761856 8525504 9260000
15:27:51 70693 8192000000 10923433648 11381108736 1922294016 19.005 97 23 46 0 1937399712 8116576 6989120
15:29:14 102310 8192000000 10850316880 11315863552 1861305360 18.514 95 10 20 0 1874647808 10323376 3019072
15:31:12 78069 8192000000 10860616176 11333779456 1882443088 18.685 96 29 58 3 1899640992 9365888 7832016
15:32:49 10863 8192000000 10852888112 11337228288 1936061968 19.115 100 11 22 0 1949797840 10791472 2944400
15:33:06 28321 8192000000 10845881104 11315212288 1885776064 18.712 97 17 34 0 1897488368 7404768 4307536
15:33:45 48596 8192000000 10833182544 11310415872 1892644448 18.767 98 16 32 0 1906844032 9146064 5053520
15:34:40 55092 8192000000 10863050368 11341717504 1942935232 19.170 100 9 18 0 1955427024 9624816 2866976
15:36:44 59368 8192000000 10847297456 11331883008 1886617984 18.719 97 20 40 2 1908485408 15040736 6826688
15:37:57 69986 8192000000 10850732160 11318554624 1843261872 18.367 95 9 18 1 1860294032 14487072 2545088
15:39:17 52588 8192000000 10844075168 11318386688 1905596528 18.871 99 15 30 1 1929737424 19257488 4883408
15:40:28 36432 8192000000 10884877840 11338948608 1925760960 19.033 99 45 90 0 1956144656 16879072 13504624
15:41:11 70754 8192000000 10850252736 11315707904 1848199488 18.407 95 21 42 1 1870539648 16703824 5636336
15:42:36 21546 8192000000 10872891024 11337666560 1938979424 19.139 100 45 90 1 1968092912 15836528 13276960
15:43:05 33935 8192000000 10841442320 11308523520 1877605872 18.646 97 20 40 1 1896567328 13223968 5737488
15:43:46 83611 8192000000 10829989104 11300282368 1792493184 17.952 93 10 20 0 1808240768 13055472 2692112
15:45:26 76721 8192000000 10870888640 11316477952 1860305792 18.506 96 42 82 3 1882097808 9575712 12216304
15:46:58 31955 8192000000 10871222832 11330547712 1920051712 18.987 99 31 61 0 1941784976 12599312 9133952
15:47:40 26859 8192000000 10877890192 11343081472 1938450992 19.134 100 21 42 0 1960200192 15612080 6137120
15:48:14 70683 8192000000 10863426336 11321659392 1903775008 18.857 98 16 30 1 1920626240 12770256 4080976
15:49:31 19155 8192000000 10909331312 11342872576 1929081824 19.060 99 49 98 0 1953736064 10782144 13872096
15:49:59 123422 8192000000 10880224240 11360559104 1957466368 19.286 100 41 83 2 1989096352 21007280 10622704
15:52:26 24345 8192000000 10892284752 11342512128 1936076544 19.115 99 39 77 0 1954995616 8200272 10718800
15:53:07 51813 8192000000 10878523936 11348955136 1936585408 19.119 99 16 32 2 1951715584 10333200 4796976
15:54:09 57310 8192000000 10877333136 11355783168 1939584848 19.143 99 16 32 2 1960395968 15578416 5232704
15:55:13 24328 8192000000 10887340400 11365400576 1958441680 19.294 100 10 20 0 1976811232 15279936 3089616
15:55:45 46865 8192000000 10887063616 11354271744 1926180176 19.036 98 16 32 0 1949279056 18138640 4960240
15:56:40 77779 8192000000 10879618960 11367591936 1951913472 19.242 100 15 30 1 1975082112 18670944 4497696
15:59:43 57558 8192000000 10902448592 11371409408 1953222480 19.252 99 14 28 0 1972333344 14578400 4532464
16:01:41 45577 8192000000 10914993488 11389046784 1985604784 19.509 100 15 30 0 2003862848 13759808 4498256
16:02:35 78333 8192000000 10907288528 11384492032 1948283376 19.213 98 20 40 1 1965885104 12210864 5390864
16:04:20 50144 8192000000 10931740816 11389861888 1989258352 19.538 100 16 32 2 2002892320 9246096 4387872
16:05:17 53764 8192000000 10941905760 11406319616 1998649152 19.612 100 38 75 1 2018749136 10094016 10005968
16:06:23 86618 8192000000 10936329184 11414781952 1995554368 19.588 100 17 34 1 2017501392 16621840 5325184
16:07:56 88755 8192000000 10925739328 11404578816 1942822000 19.169 97 11 22 2 1961509360 16046688 2640672
16:09:31 156700 8192000000 10919940672 11406155776 1987418192 19.523 100 5 10 0 2006933152 17902240 1612720
16:12:44 66652 8192000000 10899827584 11367137280 1924257472 19.021 97 21 42 3 1941891936 11242512 6391952
16:14:03 10074 8192000000 10912896112 11376848896 1975571008 19.430 100 33 66 1 1996374304 12205072 8598224
16:14:22 27683 8192000000 10884780976 11362021376 1937992704 19.131 98 19 38 1 1950164672 6738320 5433648
16:15:05 55071 8192000000 10862184640 11343486976 1873188976 18.610 95 11 22 1 1886740000 10348560 3202464
16:16:10 35202 8192000000 10869465072 11351322624 1933205184 19.092 99 5 10 1 1950162208 15699296 1257728
16:16:51 5840 8192000000 10863260704 11348054016 1946537984 19.199 100 8 17 0 1960688944 11712864 2438096
16:17:08 74724 8192000000 10869015360 11345383424 1901919232 18.842 97 15 30 0 1913463120 7339008 4204880
16:19:16 89542 8192000000 10862886304 11344244736 1892319792 18.764 97 11 23 0 1906112224 10636960 3155472
16:20:53 34046 8192000000 10839064960 11292020736 1877229472 18.643 97 27 51 3 1892076480 8438816 6408192
16:21:43 62773 8192000000 10856330736 11335958528 1929115264 19.060 100 13 26 1 1943639072 10732912 3790896
16:23:03 57847 8192000000 10810737792 11282771968 1791371440 17.943 93 6 13 0 1807002784 13879824 1751520
16:24:08 30160 8192000000 10856174416 11302477824 1874005984 18.617 98 37 73 1 1892822416 7372592 11443840
16:24:49 55893 8192000000 10850367232 11321888768 1894955792 18.786 99 21 42 1 1915666000 15200144 5510064
16:25:52 61742 8192000000 10807491552 11285405696 1800321520 18.017 94 24 48 2 1820299616 13014608 6963488
16:26:59 18411 8192000000 9251718672 9511899136 409964976 4.765 22 2 4 0 412663872 2574272 124624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 25-12-2020 16:28:23 to 25-12-2020 16:28:55.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 91 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-12-2020 16:28:55 to 25-12-2020 16:28:57.

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          240919
MON$OLDEST_ACTIVE               240920
MON$OLDEST_SNAPSHOT             240920
MON$NEXT_TRANSACTION            240920
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                       2031456
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:358: 
:359: mscs-test-161.budzdorov.ru    Fri Dec 25 16:27:19 2020
:360:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:361: 
--- end of diff output ---

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

25.12.20 16:28:58. 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-25 16:29:01 No severe PSQL-related problems occured
25.12.20 16:29:02. End of report.