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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-12 16:27:20
DTS_END                         2021-02-12 16:27:20.4320
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(601:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44898
TRN_ID                          241502
ATT_ID                          651
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: 9430.36 22731 1131643
customer order: creation 175.28 336 21033
customer order: refuse 15.04 333 1805
order to supplier: creation 46.36 1287 5563
order to supplier: removal 3.60 101618 432
invoice (draft): creation 46.55 3413 5586
invoice (draft): removal 53.38 867 6405
invoice accept: apply 42.39 17542 5087
invoice accept: cancel 48.73 742 5847
customer reserve: creation 3901.85 173 468222
customer reserve: removal 4791.02 59 574923
realization accept: apply 85.72 174 10286
realization accept: cancel 89.53 113 10743
payment from customer: creation 59.18 90 7101
payment from customer: removal 5.63 106 676
payment to supplier: creation 50.67 105 6080
payment to supplier: removal 3.62 101 434
service: total inventory turnovers 4.74 1253 569
service: total monetary turnovers 6.24 37 749
service: aggregate perf. data 0.82 22404 98
service: refresh index statistics 0.03 303866 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 12-02-2021 16:28:40 to 12-02-2021 16:28:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3673
TEST_TIME 2 4987
TEST_TIME 3 4885
TEST_TIME 4 4585
TEST_TIME 5 4449
TEST_TIME 6 4354
TEST_TIME 7 4306
TEST_TIME 8 4425
TEST_TIME 9 5112
TEST_TIME 10 5421
TEST_TIME 11 5727
TEST_TIME 12 6501
TEST_TIME 13 6536
TEST_TIME 14 6821
TEST_TIME 15 7028
TEST_TIME 16 7026
TEST_TIME 17 7262
TEST_TIME 18 7614
TEST_TIME 19 7621
TEST_TIME 20 7876
TEST_TIME 21 8106
TEST_TIME 22 8506
TEST_TIME 23 9238
TEST_TIME 24 9278
TEST_TIME 25 9299
TEST_TIME 26 9649
TEST_TIME 27 10237
TEST_TIME 28 10772
TEST_TIME 29 11148
TEST_TIME 30 11158
TEST_TIME 31 11011
TEST_TIME 32 10916
TEST_TIME 33 11010
TEST_TIME 34 10700
TEST_TIME 35 10657
TEST_TIME 36 10548
TEST_TIME 37 10372
TEST_TIME 38 10305
TEST_TIME 39 10178
TEST_TIME 40 10130
TEST_TIME 41 10148
TEST_TIME 42 10112
TEST_TIME 43 9999
TEST_TIME 44 9954
TEST_TIME 45 9844
TEST_TIME 46 9823
TEST_TIME 47 9693
TEST_TIME 48 9772
TEST_TIME 49 9675
TEST_TIME 50 9579
TEST_TIME 51 9609
TEST_TIME 52 9531
TEST_TIME 53 9482
TEST_TIME 54 9395
TEST_TIME 55 9514
TEST_TIME 56 9568
TEST_TIME 57 9613
TEST_TIME 58 9591
TEST_TIME 59 9639
TEST_TIME 60 9687
TEST_TIME 61 9769
TEST_TIME 62 9743
TEST_TIME 63 9755
TEST_TIME 64 9852
TEST_TIME 65 9949
TEST_TIME 66 9963
TEST_TIME 67 9898
TEST_TIME 68 9789
TEST_TIME 69 9821
TEST_TIME 70 9735
TEST_TIME 71 9758
TEST_TIME 72 9752
TEST_TIME 73 9668
TEST_TIME 74 9702
TEST_TIME 75 9653
TEST_TIME 76 9569
TEST_TIME 77 9570
TEST_TIME 78 9517
TEST_TIME 79 9482
TEST_TIME 80 9465
TEST_TIME 81 9526
TEST_TIME 82 9572
TEST_TIME 83 9587
TEST_TIME 84 9549
TEST_TIME 85 9592
TEST_TIME 86 9573
TEST_TIME 87 9564
TEST_TIME 88 9695
TEST_TIME 89 9680
TEST_TIME 90 9721
TEST_TIME 91 9722
TEST_TIME 92 9634
TEST_TIME 93 9599
TEST_TIME 94 9611
TEST_TIME 95 9567
TEST_TIME 96 9560
TEST_TIME 97 9597
TEST_TIME 98 9546
TEST_TIME 99 9524
TEST_TIME 100 9550
TEST_TIME 101 9598
TEST_TIME 102 9601
TEST_TIME 103 9618
TEST_TIME 104 9606
TEST_TIME 105 9657
TEST_TIME 106 9641
TEST_TIME 107 9694
TEST_TIME 108 9693
TEST_TIME 109 9629
TEST_TIME 110 9566
TEST_TIME 111 9571
TEST_TIME 112 9518
TEST_TIME 113 9460
TEST_TIME 114 9485
TEST_TIME 115 9460
TEST_TIME 116 9470
TEST_TIME 117 9466
TEST_TIME 118 9474
TEST_TIME 119 9484
TEST_TIME 120 9434

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-02-2021 16:28:44 to 12-02-2021 16:28:48.

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 1565995 1565995 0 0.00 0 21024 6 0 0
doc_list_biud 1565995 1565995 0 0.00 0 30259 28 0 0
sp_add_invoice_to_stock 5188 5087 101 1.94 18 209143 17542 0 101
sp_cancel_adding_invoice 5847 5847 0 0.00 5 61285 743 0 0
sp_cancel_client_order 1805 1805 0 0.00 4 11582 333 0 0
sp_cancel_customer_reserve 574923 574923 0 0.00 1 21314 59 0 0
sp_cancel_pay_from_customer 676 676 0 0.00 2 7861 107 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 3 6120 102 0 0
sp_cancel_supplier_invoice 6412 6405 7 0.10 2 25423 868 0 7
sp_cancel_supplier_order 432 432 0 0.00 5 1003138 101618 0 0
sp_cancel_write_off 10743 10743 0 0.00 1 15883 114 0 0
sp_client_order 21033 21033 0 0.00 4 58046 336 0 0
sp_customer_reserve 468222 468222 0 0.00 0 81321 174 0 0
sp_fill_shopping_cart 32171 32171 0 0.00 1 13608 36 0 0
sp_fill_shopping_cart_clo_res 468215 468215 0 0.00 0 13344 14 0 0
sp_get_clo_for_invoice 5076 5076 0 0.00 0 17745 315 0 0
sp_kill_cost_storno 17700 17700 0 0.00 0 7851 62 0 0
sp_kill_qstorno_ret_qs2qd 1167426 1167426 0 0.00 0 30256 32 0 0
sp_kill_qty_storno 615517 615517 0 0.00 0 30258 70 0 0
sp_lock_selected_doc 21304 21304 0 0.00 0 8770 5 0 0
sp_make_cost_storno 28543 28543 0 0.00 0 21021 48 0 0
sp_multiply_rows_for_pdistr 28543 28543 0 0.00 0 10859 27 0 0
sp_multiply_rows_for_qdistr 21033 21033 0 0.00 0 58035 157 0 0
sp_pay_from_customer 7101 7101 0 0.00 4 7743 90 0 0
sp_pay_to_supplier 6080 6080 0 0.00 5 7860 105 0 0
sp_payment_common 13181 13181 0 0.00 1 7738 20 0 0
sp_qd_handle_on_cancel_clo 1805 1805 0 0.00 0 11561 310 0 0
sp_qd_handle_on_invoice_upd_sts 10923 10923 0 0.00 0 24845 333 0 0
sp_qd_handle_on_reserve_upd_sts 10286 10286 0 0.00 0 21543 62 0 0
sp_reserve_write_off 10286 10286 0 0.00 6 21589 174 0 0
sp_supplier_invoice 5586 5586 0 0.00 7 83194 3414 0 0
sp_supplier_order 5563 5563 0 0.00 5 28755 1288 0 0
srv_aggregate_perf_data 98 98 0 0.00 2453 177310 22404 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1310 143395 33410 0 0
srv_find_qd_qs_mism 1083619 1083619 0 0.00 0 11494 5 0 0
srv_make_invnt_saldo 569 569 0 0.00 29 95586 1254 0 0
srv_make_money_saldo 749 749 0 0.00 1 3674 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 144824 410053 303867 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 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 5087 5087 0 0.00 0 11074 183 0 0
t$perf-norm:sp_cancel_adding_invoice 430 430 0 0.00 0 3076 99 0 0
t$perf-norm:sp_cancel_client_order 1805 1805 0 0.00 0 5731 14 0 0
t$perf-norm:sp_cancel_customer_reserve 717 717 0 0.00 0 1053 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 676 676 0 0.00 0 1303 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 1476 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 404 404 0 0.00 0 3739 43 0 0
t$perf-norm:sp_cancel_supplier_order 432 432 0 0.00 0 22173 1712 0 0
t$perf-norm:sp_cancel_write_off 1044 1044 0 0.00 0 6102 14 0 0
t$perf-norm:sp_client_order 21033 21033 0 0.00 0 16162 24 0 0
t$perf-norm:sp_customer_reserve 993 993 0 0.00 0 6071 20 0 0
t$perf-norm:sp_pay_from_customer 7101 7101 0 0.00 0 6528 12 0 0
t$perf-norm:sp_pay_to_supplier 6080 6080 0 0.00 0 6084 12 0 0
t$perf-norm:sp_reserve_write_off 10286 10286 0 0.00 0 7392 14 0 0
t$perf-norm:sp_supplier_invoice 5586 5586 0 0.00 0 5486 22 0 0
t$perf-norm:sp_supplier_order 5563 5563 0 0.00 0 5661 17 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 166 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 86 1 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 2824 26 0 0
t$perf-norm:srv_make_money_saldo 749 749 0 0.00 0 4543 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 22 8 0 0
v_add_invoice_to_stock 10354 10152 202 1.95 0 7236 16 0 202
v_all_customers 38296 38296 0 0.00 0 87 1 0 0
v_all_suppliers 31094 31094 0 0.00 0 98 1 0 0
v_all_wares 42066 42066 0 0.00 0 32 1 0 0
v_cancel_adding_invoice 860 860 0 0.00 0 4202 11 0 0
v_cancel_client_order 3610 3610 0 0.00 0 3126 5 0 0
v_cancel_customer_prepayment 1352 1352 0 0.00 0 2203 7 0 0
v_cancel_customer_reserve 1434 1434 0 0.00 0 472 3 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 2421 10 0 0
v_cancel_supplier_invoice 822 808 14 1.70 0 2595 19 0 14
v_cancel_supplier_order 864 864 0 0.00 0 2708 6 0 0
v_cancel_write_off 2088 2088 0 0.00 0 2206 14 0 0
v_max_id_clo_ord 5563 5563 0 0.00 0 1771 1 0 0
v_max_id_clo_res 993 993 0 0.00 0 2080 13 0 0
v_max_id_ord_sup 5575 5575 0 0.00 0 4133 5 0 0
v_max_non_paid_invoice 1671 1671 0 0.00 0 208 2 0 0
v_max_non_paid_realizn 3734 3734 0 0.00 0 544 3 0 0
v_min_id_clo_ord 5563 5563 0 0.00 0 1979 5 0 0
v_min_id_clo_res 993 993 0 0.00 0 1120 5 0 0
v_min_id_ord_sup 5575 5575 0 0.00 0 8889 13 0 0
v_min_non_paid_invoice 6080 6080 0 0.00 0 5254 11 0 0
v_min_non_paid_realizn 7101 7101 0 0.00 0 5718 14 0 0
v_our_firm 10504 10504 0 0.00 0 14 1 0 0
v_reserve_write_off 20572 20572 0 0.00 0 4208 5 0 0
x_lock_depdocs_on_canc_invoice 11848 11848 0 0.00 0 14759 109 0 0
x_lock_depdocs_on_canc_sup_ord 432 432 0 0.00 0 10765 332 0 0
x_make_qstorno_1000_1200 5563 5563 0 0.00 2 28737 1207 0 0
x_make_qstorno_1200_2000 5586 5586 0 0.00 3 83166 3286 0 0
x_make_qstorno_2100_3300 468222 468222 0 0.00 0 81319 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-02-2021 16:28:49 to 12-02-2021 16:28:53.

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:24 4 8192000000 8800931168 8812138496 6918096 0.084 2 1 2 0 7037472 56816 62560
13:57:30 15051 8192000000 10245126464 10550026240 983009904 10.713 77 52 105 0 1002336800 2580000 16746896
13:57:54 37822 8192000000 10351009856 10669572096 1377774832 14.397 100 83 166 2 1410538464 4892560 27871072
13:58:46 18238 8192000000 10385559808 10707181568 1437024864 14.923 100 87 174 1 1471923088 6601696 28296528
13:59:19 33108 8192000000 10423626800 10749386752 1473754192 15.247 100 93 186 0 1511814240 7733936 30326112
14:00:00 24104 8192000000 10430021776 10762780672 1483474256 15.332 100 89 178 0 1520649136 8443888 28730992
14:00:39 24100 8192000000 10456272592 10791845888 1504845280 15.518 100 93 185 2 1543423632 9122048 29456304
14:01:14 10172 8192000000 10476040608 10811801600 1524567392 15.690 100 91 182 2 1562949808 9455632 28926784
14:01:34 15305 8192000000 10479247264 10823753728 1542145760 15.842 100 83 166 0 1577874128 9434064 26294304
14:02:00 13286 8192000000 10500926736 10853707776 1554926000 15.952 100 74 148 0 1587982688 9924352 23132336
14:02:22 15535 8192000000 10528344928 10882609152 1581105984 16.178 100 71 142 0 1612682128 10044560 21531584
14:02:46 11163 8192000000 10567062560 10923540480 1618234560 16.495 100 81 162 0 1653642752 10269456 25138736
14:03:06 13268 8192000000 10583830528 10945486848 1645478176 16.726 100 86 172 0 1682555680 11424816 25652688
14:03:30 7394 8192000000 10602527088 10966753280 1659499136 16.845 100 74 148 0 1693031856 12067184 21465536
14:03:46 5676 8192000000 10620891184 10982727680 1678830688 17.007 100 87 174 1 1717063808 12591664 25641456
14:04:02 8933 8192000000 10626129696 11001761792 1687134352 17.077 100 66 132 0 1718090704 11805008 19151344
14:04:22 6454 8192000000 10638998656 11014270976 1703314016 17.213 100 71 143 1 1735442720 11102896 21025808
14:04:37 6916 8192000000 10660554256 11037192192 1726623312 17.407 100 83 166 0 1762391472 11796000 23972160
14:04:51 5071 8192000000 10662531184 11041456128 1725109696 17.395 100 70 138 0 1756954272 12312512 19532064
14:05:03 4663 8192000000 10683004080 11057717248 1740364096 17.522 100 78 157 1 1775546240 13120832 22061312
14:05:17 5950 8192000000 10690154512 11065204736 1750759824 17.608 100 83 166 0 1789040544 14630032 23650688
14:05:31 5121 8192000000 10696834368 11075440640 1758096752 17.669 100 79 157 0 1793750336 13279520 22374064
14:05:43 4316 8192000000 10700383584 11083476992 1767946512 17.750 100 67 134 1 1798909200 11912432 19050256
14:05:56 5166 8192000000 10705344112 11089960960 1772833600 17.790 100 68 135 1 1803776544 11274320 19668624
14:06:09 3039 8192000000 10723642656 11107364864 1783839184 17.881 100 73 144 2 1815479888 10540336 21100368
14:06:20 9552 8192000000 10714592064 11107860480 1793661152 17.962 100 62 122 1 1822031632 10902000 17468480
14:06:36 5212 8192000000 10732160384 11124436992 1802195968 18.032 100 70 137 1 1832725232 10752320 19776944
14:06:50 3369 8192000000 10760966208 11154591744 1824145168 18.212 100 83 167 1 1860812992 12225440 24442384
14:06:59 2145 8192000000 10775224784 11159756800 1828663440 18.248 100 78 157 2 1863990544 13312128 22014976
14:07:08 2465 8192000000 10765853680 11156471808 1839183904 18.334 100 82 162 0 1875668960 13266080 23218976
14:07:17 3412 8192000000 10780348704 11168366592 1843131584 18.366 100 89 178 1 1881518624 13073024 25314016
14:07:27 2840 8192000000 10779879632 11169697792 1844193472 18.375 100 84 165 2 1880587168 13168032 23225664
14:07:37 1995 8192000000 10802548864 11186982912 1852247280 18.440 100 90 181 0 1891340816 13539392 25554144
14:07:46 1329 8192000000 10798240736 11186954240 1853933808 18.454 100 91 183 3 1893492640 13366560 26192272
14:07:54 2545 8192000000 10802569344 11191934976 1859206896 18.497 100 90 180 2 1899036384 14011200 25818288
14:08:03 1961 8192000000 10810252944 11197505536 1865258832 18.546 100 94 189 2 1905614512 13322144 27033536
14:08:12 2010 8192000000 10813194864 11200376832 1868039664 18.568 100 92 186 1 1907254832 13148624 26066544
14:08:20 6587 8192000000 10805930496 11199385600 1861746688 18.517 100 80 161 1 1896639680 13313760 21579232
14:08:34 1517 8192000000 10813058128 11202838528 1866974976 18.560 100 94 188 1 1909014144 14833328 27205840
14:08:41 3615 8192000000 10803423504 11205132288 1864981536 18.544 100 75 150 1 1903540896 18036064 20523296
14:08:52 19237 8192000000 10804457376 11200999424 1867423440 18.563 100 72 143 0 1898596688 10671488 20501760
14:09:18 12332 8192000000 10791471584 11203375104 1869280896 18.578 100 58 116 1 1894876608 9773872 15821840
14:09:38 3849 8192000000 10787740384 11202154496 1866794832 18.558 100 47 97 0 1889285328 9104512 13385984
14:09:48 2579 8192000000 10797304544 11206660096 1871029312 18.593 100 51 103 1 1893615712 8204832 14381568
14:10:00 4799 8192000000 10794782048 11212423168 1873058080 18.609 100 45 90 0 1894755968 9269600 12428288
14:10:11 7611 8192000000 10782038960 11207946240 1875915456 18.632 100 41 82 1 1896771792 8992096 11864240
14:10:26 11368 8192000000 10788442672 11209011200 1874727472 18.623 100 25 50 1 1887896688 6370832 6798384
14:10:44 4780 8192000000 10782406736 11213729792 1878107744 18.650 100 34 68 2 1895250224 7509328 9633152
14:10:55 4265 8192000000 10793482528 11220168704 1879805168 18.664 100 34 68 1 1897289280 7788768 9695344
14:11:06 13594 8192000000 10798043872 11225686016 1882745440 18.687 100 24 49 1 1895470864 6083936 6641488
14:11:26 10523 8192000000 10792572288 11222114304 1885288896 18.708 100 13 26 1 1898623168 9655520 3678752
14:11:43 5124 8192000000 10799769072 11229245440 1889686352 18.743 100 35 70 2 1907355600 8085952 9583296
14:11:54 7193 8192000000 10793439248 11227762688 1888894000 18.737 100 17 34 2 1899775856 5976240 4905616
14:12:11 9516 8192000000 10803379552 11231649792 1890293024 18.748 100 11 22 0 1898819008 5173888 3352096
14:12:27 8880 8192000000 10794339248 11233538048 1891219696 18.756 100 9 18 2 1899636224 6117024 2299504
14:12:46 67372 8192000000 10829694944 11248054272 1901344384 18.837 100 28 55 1 1914575664 5374384 7856896
14:14:00 9474 8192000000 10811883632 11249094656 1900889376 18.833 100 36 72 0 1920147968 9526608 9731984
14:14:15 7942 8192000000 10816209808 11250622464 1899123728 18.819 100 21 42 1 1911198208 6250096 5824384
14:14:32 4071 8192000000 10831847520 11253616640 1905229376 18.868 100 41 82 0 1924764656 8737232 10798048
14:14:44 4661 8192000000 10826893024 11251884032 1903992848 18.858 100 35 70 2 1920642128 6553328 10095952
14:14:58 4196 8192000000 10827450288 11253825536 1904950064 18.866 100 49 101 0 1928519792 8624144 14945584
14:15:09 7845 8192000000 10819784864 11250630656 1900236656 18.828 100 23 46 1 1913996288 6135152 7624480
14:15:23 6725 8192000000 10824051360 11252105216 1900825024 18.833 100 22 44 3 1913439600 6020400 6594176
14:15:38 7587 8192000000 10815688864 11252711424 1905445728 18.870 100 29 58 0 1920276288 6469184 8361376
14:15:56 6387 8192000000 10832087968 11261710336 1910880000 18.914 100 30 60 1 1925617376 5420384 9316992
14:16:14 9108 8192000000 10813913376 11248955392 1888599808 18.734 99 20 40 1 1899886912 5326816 5960288
14:16:29 8061 8192000000 10828338288 11259662336 1903873824 18.857 100 16 31 0 1913579072 5168384 4536864
14:16:46 9214 8192000000 10824397280 11254923264 1872168112 18.602 98 21 42 2 1883840704 5810384 5862208
14:17:05 46988 8192000000 10789037232 11216363520 1859429088 18.499 98 29 58 1 1873578320 5694656 8454576
14:17:58 18037 8192000000 10797541392 11230601216 1871208016 18.594 99 32 64 1 1886913008 6640944 9064048
14:18:23 9287 8192000000 10753578000 11186634752 1736622352 17.491 92 18 37 1 1747374048 6037296 4714400
14:18:39 5306 8192000000 10752572128 11169161216 1806506208 18.067 98 30 60 0 1821410080 6114704 8789168
14:18:50 10574 8192000000 10748706128 11172712448 1773611888 17.797 96 27 53 2 1786838384 5624720 7601776
14:19:07 6336 8192000000 10764004880 11184668672 1821248336 18.188 99 26 52 1 1834180896 5457312 7475248
14:19:20 6610 8192000000 10729569424 11145494528 1769979312 17.767 97 26 52 2 1783025776 5569600 7476864
14:19:38 5209 8192000000 10695652448 11115200512 1754807952 17.641 96 27 54 2 1769309648 5567248 8934448
14:19:49 7159 8192000000 10704518128 11125829632 1753077888 17.627 97 26 52 1 1766948560 6885136 6985536
14:20:04 6508 8192000000 10702477264 11117936640 1759572464 17.681 98 31 60 2 1773695664 5422256 8700944
14:20:18 7409 8192000000 10705206128 11112521728 1740203184 17.520 97 24 48 3 1752911280 5941056 6767040
14:20:31 10308 8192000000 10683953728 11098095616 1710962192 17.277 95 22 44 1 1722921872 5763120 6196560
14:20:48 8729 8192000000 10696699872 11118186496 1751304480 17.612 98 25 50 0 1764613744 6071936 7237328
14:21:06 7127 8192000000 10709517328 11130572800 1766167360 17.735 98 20 40 0 1777337440 5431648 5738432
14:21:25 9463 8192000000 10715478928 11134337024 1774473264 17.804 98 20 40 3 1785683488 5410656 5799568
14:21:41 16536 8192000000 10733608048 11132395520 1757295536 17.662 97 19 38 2 1768981648 5094688 6591424
14:22:05 61518 8192000000 10737069872 11161559040 1824493984 18.214 100 20 40 1 1835207792 4810144 5903664
14:23:13 7740 8192000000 10745803168 11169038336 1803050992 18.039 98 20 39 0 1818459856 10255200 5153664
14:23:28 10085 8192000000 10759329984 11186917376 1843548656 18.370 100 20 40 1 1854172272 5329904 5293712
14:23:52 5264 8192000000 10750590944 11185606656 1847100896 18.399 100 25 50 0 1860546608 6039280 7406432
14:24:04 3757 8192000000 10771209808 11193839616 1839341440 18.335 99 34 68 1 1855988752 6863760 9783552
14:24:16 5408 8192000000 10769825824 11198799872 1859119648 18.496 100 34 68 1 1876147136 7228592 9798896
14:24:30 4813 8192000000 10756219008 11181719552 1842826960 18.364 99 31 60 2 1857457952 5657280 8973712
14:24:45 6259 8192000000 10758925504 11196661760 1855397920 18.466 100 22 42 0 1867672960 6238128 6036912
14:25:00 9666 8192000000 10775081472 11200733184 1859277056 18.497 100 19 38 2 1870395120 5464880 5653184
14:25:16 9395 8192000000 10775716368 11208454144 1866229344 18.554 100 22 44 0 1878373072 5326240 6817488
14:25:33 8696 8192000000 10774552544 11209211904 1867397552 18.563 100 25 50 2 1880630384 6157584 7075248
14:25:48 11906 8192000000 10791562448 11211288576 1866194112 18.553 100 17 34 0 1876689776 4974784 5520880
14:26:06 6481 8192000000 10778586400 11213549568 1868028640 18.568 100 13 26 0 1877190688 5090480 4071568
14:26:20 8157 8192000000 10783294864 11213295616 1871060672 18.593 100 15 30 0 1879802928 5023120 3719136
14:26:37 95436 8192000000 10828068352 11240726528 1880502512 18.669 100 32 62 2 1895454256 5208304 9743440
14:28:21 11274 8192000000 10847174912 11265118208 1915243152 18.949 100 64 129 0 1942385728 8911808 18230768
14:28:59 14436 8192000000 10855746912 11281731584 1926828176 19.042 100 46 90 1 1948436496 8998832 12609488
14:29:22 8477 8192000000 10867737952 11292536832 1937141472 19.124 100 56 112 0 1963103696 9905536 16056688
14:29:38 8117 8192000000 10866163840 11297886208 1939104176 19.140 100 47 93 0 1962260896 9990240 13166480
14:29:56 24481 8192000000 10873365216 11304820736 1948379728 19.214 100 46 92 0 1971120928 9446768 13294432
14:30:27 5007 8192000000 10889059152 11312254976 1954220864 19.260 100 64 128 2 1984006352 11047664 18737824
14:30:40 24664 8192000000 10881992256 11313930240 1955644480 19.271 100 51 100 4 1981008608 10781472 14582656
14:31:14 15546 8192000000 10898421424 11327922176 1959737120 19.304 100 48 97 0 1987422496 14055008 13630368
14:31:44 24969 8192000000 10898924576 11336429568 1966614624 19.359 100 39 75 0 1990847056 13499792 10732640
14:32:17 19360 8192000000 10908522864 11341623296 1972729408 19.407 100 43 86 1 2001555664 16206816 12619440
14:32:51 37534 8192000000 10916072752 11352625152 1976685616 19.438 100 39 78 1 2005498160 16805872 12006672
14:33:38 18097 8192000000 10923180592 11365416960 1986342304 19.515 100 33 66 3 2017936912 21280176 10314432
14:34:05 10998 8192000000 10937565648 11375976448 1995874640 19.590 100 48 95 0 2032470272 22000192 14595440
14:34:30 14174 8192000000 10945784928 11382550528 1998494704 19.611 100 46 92 1 2038404144 25520832 14388608
14:34:51 2692 8192000000 10941884528 11380842496 1980487088 19.469 99 46 92 1 2026239696 31155520 14597088
14:35:10 5769 8192000000 10956144736 11385044992 2001138768 19.632 100 56 111 1 2050792000 32394128 17259104
14:35:28 6520 8192000000 10956481472 11390132224 2001800480 19.637 100 56 112 1 2047815808 29173040 16842288
14:35:46 4882 8192000000 10968915440 11393220608 2007655824 19.683 100 73 146 0 2061916320 30913104 23347392
14:36:02 12988 8192000000 10974916096 11398365184 2009734912 19.699 100 56 110 1 2059079216 31694688 17649616
14:36:29 10613 8192000000 10962392576 11404607488 2011815824 19.716 100 56 110 0 2060754080 31321024 17617232
14:36:50 3761 8192000000 10948766992 11383832576 1969595872 19.382 98 60 120 1 2018767856 31317584 17854400
14:37:06 11208 8192000000 10933059360 11378135040 1983903104 19.496 100 36 72 1 2024881664 29013488 11965072
14:37:24 5598 8192000000 10953978560 11382595584 1992350896 19.562 100 66 129 2 2045539808 33528144 19660768
14:37:37 12161 8192000000 10948565248 11392364544 1996050752 19.592 100 50 100 3 2040846000 29233728 15561520
14:37:59 8958 8192000000 10972764720 11407507456 2007600176 19.683 100 56 110 1 2056811952 31896320 17315456
14:38:19 6425 8192000000 10945084448 11379232768 1970861232 19.392 99 62 124 0 2023664560 33036784 19766544
14:38:41 10903 8192000000 10951473024 11388112896 1987560288 19.525 100 52 104 0 2039736320 34949936 17226096
14:39:06 4640 8192000000 10965068160 11392417792 1989106864 19.537 100 64 126 0 2045049792 35504928 20438000
14:39:18 2805 8192000000 10975759888 11397632000 1995882448 19.590 100 74 146 0 2056259680 37247552 23129680
14:39:29 16192 8192000000 10969224304 11405946880 2004912224 19.661 100 67 134 0 2063779472 37854864 21012384
14:40:05 8933 8192000000 10953044272 11392122880 1996045664 19.592 100 59 116 2 2045581552 31014752 18521136
14:40:21 1949 8192000000 10957294656 11388067840 1995094112 19.584 100 63 123 0 2044381504 30308064 18979328
14:40:31 3291 8192000000 10981059296 11405901824 2004505904 19.658 100 83 165 2 2065645792 35762944 25376944
14:40:41 3936 8192000000 10982746176 11403051008 2003344304 19.649 100 79 157 1 2063256880 36539088 23373488
14:40:52 3088 8192000000 10987454496 11411795968 2012356064 19.720 100 83 166 0 2074358704 36947440 25055200
14:41:06 1476 8192000000 10988265088 11413573632 2015015584 19.741 100 79 155 1 2075258528 37540304 22702640
14:41:14 3187 8192000000 10989598512 11405090816 2002592000 19.643 100 87 172 0 2066017232 37962304 25462928
14:41:24 2355 8192000000 10982527584 11395129344 1983751024 19.494 99 87 174 2 2048145184 38374128 26020032
14:41:33 7214 8192000000 10968345120 11390132224 1976385264 19.436 99 70 139 1 2036142304 38948592 20808448
14:41:47 2906 8192000000 10972168368 11384950784 1973799248 19.416 99 91 181 0 2042651104 41079504 27772352
14:41:57 2549 8192000000 10978312096 11392905216 1990482048 19.548 100 83 167 1 2057171536 40971824 25717664
14:42:07 4534 8192000000 10968101664 11387101184 1978818912 19.455 99 81 162 0 2045478976 41149936 25510128
14:42:18 3769 8192000000 10963628576 11386236928 1970410208 19.389 99 71 142 0 2032558384 40730976 21417200
14:42:40 2403 8192000000 10963689936 11378999296 1973354304 19.412 99 72 141 2 2035896368 41432800 21109264
14:42:54 6450 8192000000 10964573728 11388985344 1970719648 19.391 99 71 141 1 2035374000 43131776 21522576
14:43:07 9001 8192000000 10974698800 11398856704 1990260032 19.546 100 66 132 1 2055129296 44514352 20354912
14:43:24 3009 8192000000 10978844272 11399630848 1987769296 19.526 100 75 150 0 2056557040 46007072 22780672
14:43:40 2297 8192000000 10961828752 11385651200 1967773424 19.368 99 70 139 3 2033955600 45040720 21141456
14:43:49 4208 8192000000 10968249568 11394011136 1983586960 19.493 100 71 139 0 2051455792 46574896 21293936
14:44:00 4034 8192000000 10974368096 11395919872 1974477072 19.421 99 72 142 1 2044146848 47536720 22133056
14:44:11 2914 8192000000 10969969136 11383898112 1961449200 19.318 99 82 162 1 2036626224 49517728 25659296
14:44:20 8807 8192000000 10970727088 11392352256 1973716080 19.415 100 75 148 2 2047521632 50514448 23291104
14:44:37 2817 8192000000 10973902800 11394424832 1983873760 19.495 100 75 146 3 2054990160 48655104 22461296
14:44:48 4442 8192000000 10974450160 11405070336 1990474336 19.548 100 65 130 4 2058105184 47571296 20059552
14:45:00 2393 8192000000 10988129008 11409367040 1998673776 19.612 100 85 168 2 2072818640 48458592 25686272
14:45:09 3963 8192000000 10965902352 11387215872 1982819984 19.487 100 79 158 1 2051463392 44325952 24317456
14:45:20 4588 8192000000 10965504608 11377266688 1960646736 19.311 99 81 161 3 2029769616 44877008 24245872
14:45:32 1305 8192000000 10954214544 11362803712 1952643232 19.248 99 92 185 0 2025279872 44228016 28408624
14:45:41 7015 8192000000 10950992384 11373330432 1969702992 19.383 100 63 126 1 2031515664 42576944 19235728
14:45:56 1572 8192000000 10978488624 11387879424 1980309696 19.467 100 92 185 0 2054809664 45722416 28777552
14:46:04 3181 8192000000 10959101568 11374927872 1964149616 19.339 99 82 164 1 2036397232 46167056 26080560
14:46:15 1377 8192000000 10975360560 11384348672 1975638512 19.430 100 85 171 0 2049674208 47623408 26412288
14:46:23 3769 8192000000 10976591168 11393437696 1983087936 19.489 100 80 160 2 2056170832 47795744 25287152
14:46:35 1806 8192000000 10970263776 11381256192 1969300160 19.380 99 90 181 0 2046714800 49234672 28179968
14:46:46 2547 8192000000 10959283152 11379965952 1971350240 19.396 100 80 160 2 2046067264 49720496 24996528
14:46:56 2942 8192000000 10976770160 11390746624 1975917104 19.432 100 76 152 1 2051949632 52244720 23787808
14:47:06 10624 8192000000 10928757664 11366871040 1916230992 18.957 97 46 92 1 1982763168 51423200 15108976
14:47:27 10810 8192000000 10930986000 11367620608 1934804672 19.105 99 45 88 1 2005918128 56430240 14683216
14:47:45 7312 8192000000 10946983360 11376103424 1943756928 19.177 99 51 102 0 2018392144 57145952 17489264
14:48:05 7976 8192000000 10955962000 11388510208 1964314464 19.340 100 45 89 1 2036903552 55920144 16668944
14:48:20 2781 8192000000 10973277648 11394347008 1974186240 19.419 100 69 137 0 2055806624 58670320 22950064
14:48:37 4400 8192000000 10982823312 11398459392 1970407248 19.389 100 70 138 1 2055674976 62422352 22845376
14:48:58 12911 8192000000 10947570000 11389566976 1960386800 19.309 100 34 68 0 2030119136 57616176 12116160
14:49:21 12686 8192000000 10950726608 11380838400 1960414592 19.309 100 34 66 1 2026378992 53630784 12333616
14:49:46 5542 8192000000 10959522336 11395153920 1973014288 19.409 100 48 97 3 2044488320 54237856 17236176
14:49:59 1942 8192000000 10981951920 11396820992 1980578912 19.469 100 85 165 2 2063180496 56257360 26344224
14:50:07 8959 8192000000 10961726736 11405656064 1978461280 19.453 100 52 103 0 2047860016 52769968 16628768
14:50:23 16192 8192000000 10929901936 11383820288 1954458288 19.262 99 29 58 1 2003956672 40086096 9412288
14:50:47 19070 8192000000 10931966032 11376476160 1960987008 19.314 99 32 64 0 2010456912 39181424 10288480
14:51:24 20906 8192000000 10934949856 11383021568 1961827328 19.321 100 23 46 1 2013241488 42809808 8604352
14:51:52 21431 8192000000 10925208256 11370655744 1923457968 19.015 98 27 53 1 1974901904 42741376 8702560
14:52:37 32855 8192000000 10919690080 11367796736 1936273088 19.117 99 36 72 3 1998703600 49930512 12500000
14:53:21 17374 8192000000 10911899088 11366424576 1927382736 19.046 99 29 58 2 1985299344 47407376 10509232
14:53:50 29613 8192000000 10915563408 11378327552 1925902896 19.034 99 25 50 1 1984432560 49989456 8540208
14:54:26 27497 8192000000 10921206256 11393781760 1943405344 19.174 100 18 36 2 2003650288 53594112 6650832
14:55:01 26933 8192000000 10898614288 11380998144 1941040480 19.155 100 9 18 1 1981396400 36917072 3438848
14:55:35 14855 8192000000 10892532192 11362684928 1945854688 19.193 100 9 18 0 1984267888 35337664 3075536
14:55:56 14114 8192000000 10893601440 11350134784 1919986032 18.987 99 10 20 0 1950469824 26943232 3540560
14:56:17 44989 8192000000 10886150384 11357122560 1927979904 19.051 99 12 24 1 1945168352 14041296 3147152
14:57:08 61127 8192000000 10898610432 11363127296 1950937120 19.234 99 14 28 1 1976731120 21922352 3871648
14:58:22 134874 8192000000 10876719600 11349032960 1903708240 18.856 97 10 21 1 1921943520 16237600 1997680
15:00:45 143394 8192000000 10885009392 11332190208 1887910336 18.729 96 18 35 1 1902582048 9872336 4799376
15:03:16 74966 8192000000 10905253024 11348758528 1926723632 19.041 98 27 54 1 1946506000 12605504 7176864
15:05:05 75244 8192000000 10876183376 11337609216 1904356272 18.861 97 21 42 0 1919343216 9028608 5958336
15:06:32 48292 8192000000 10897204720 11350790144 1947221424 19.204 99 32 64 2 1965385536 8674624 9489488
15:07:30 36592 8192000000 10914283648 11367309312 1973540592 19.414 100 46 92 0 1998841520 11139120 14161808
15:08:15 66940 8192000000 10883143728 11362734080 1933698032 19.096 98 9 18 1 1946529760 10040512 2791216
15:09:31 48582 8192000000 10893437664 11358662656 1971801424 19.400 100 19 39 1 1984520832 7857904 4861504
15:10:26 36719 8192000000 10896897376 11360120832 1955795616 19.273 99 20 40 0 1968525440 7222896 5506928
15:11:12 43410 8192000000 10903862608 11374149632 1979342224 19.459 100 23 45 1 1999951328 14054912 6554192
15:14:04 69180 8192000000 10898737376 11391148032 1963977936 19.338 99 10 20 0 1978870704 12240624 2652144
15:15:26 82034 8192000000 10890826608 11369435136 1947824048 19.209 98 13 26 0 1965450720 13331408 4295264
15:17:17 17322 8192000000 10925637536 11386576896 1995364304 19.586 100 50 99 0 2023169056 13070608 14734144
15:17:47 82274 8192000000 10906428448 11395264512 1989714976 19.542 100 22 44 1 2008096704 11610000 6771728
15:19:31 87277 8192000000 10893634160 11375362048 1934012720 19.099 97 10 20 0 1947387696 10351648 3023328
15:21:04 41647 8192000000 10897119536 11369758720 1963516448 19.334 99 22 44 1 1985529264 15822432 6190384
15:22:01 86166 8192000000 10894624560 11369811968 1917046320 18.963 97 12 24 0 1931754336 11409600 3298416
15:23:35 61834 8192000000 10876400688 11351371776 1941480704 19.159 98 26 52 1 1959648832 10960896 7207232
15:25:00 35475 8192000000 10898347936 11362467840 1936770288 19.121 98 36 72 0 1957074192 9085696 11218208
15:25:44 55738 8192000000 10883545984 11360174080 1927241360 19.045 98 18 36 0 1940992608 8655408 5095840
15:26:47 55354 8192000000 10904566560 11380604928 1981684320 19.478 100 28 56 1 1999888704 10632864 7571520
15:28:49 66760 8192000000 10863136592 11333521408 1878247184 18.651 95 15 29 1 1899805824 17810384 3748256
15:30:12 69624 8192000000 10892063600 11366412288 1914786896 18.945 97 18 36 0 1928968112 9376800 4804416
15:31:29 52903 8192000000 10899564816 11364978688 1928040176 19.051 98 6 12 0 1942463248 13252672 1170400
15:32:28 77159 8192000000 10893741600 11375276032 1946318256 19.197 99 8 16 1 1961236464 12411504 2506704
15:33:52 55106 8192000000 10922955296 11367170048 1931731232 19.081 97 47 92 3 1956127216 10466400 13929584
15:34:56 102861 8192000000 10881478608 11351089152 1928301808 19.053 98 26 52 0 1944377888 8972800 7103280
15:36:49 59626 8192000000 10878004800 11338162176 1886099648 18.714 96 27 54 3 1906678784 12954464 7624672
15:37:55 15165 8192000000 10889916384 11350777856 1949724928 19.224 100 27 54 1 1973230736 15865408 7640400
15:38:52 70779 8192000000 10840555280 11316305920 1857571216 18.484 96 11 22 0 1869788448 8820528 3396704
15:40:09 55550 8192000000 10838866720 11312320512 1876102800 18.634 97 17 35 0 1888692016 7653488 4935728
15:41:10 59775 8192000000 10846618752 11318898688 1872149616 18.602 97 10 20 0 1886828736 12138112 2541008
15:42:18 51206 8192000000 10853554736 11324567552 1872049520 18.601 97 19 36 2 1887960656 11152912 4758224
15:43:28 104327 8192000000 10846136096 11333955584 1914054560 18.939 99 17 35 0 1929434096 10379904 4999632
15:45:19 35747 8192000000 10831978992 11311996928 1882086176 18.682 97 10 20 2 1892525744 7526496 2913072
15:46:06 39695 8192000000 10841236464 11309400064 1859098736 18.496 96 25 50 0 1873954288 7924496 6931056
15:46:52 16626 8192000000 10866084640 11326431232 1931068592 19.075 100 27 54 1 1946674784 8547744 7058448
15:47:25 52194 8192000000 10846830128 11321442304 1868543232 18.572 96 38 76 0 1891616400 12571536 10501632
15:48:24 34002 8192000000 10849642640 11311951872 1893292512 18.772 98 17 34 2 1907930928 9520592 5117824
15:49:04 44640 8192000000 10877143904 11340013568 1920919504 18.994 99 26 52 2 1939025488 10958528 7147456
15:50:01 74417 8192000000 10868599360 11333554176 1889807440 18.744 97 14 28 1 1902036912 8331936 3897536
15:51:23 32522 8192000000 10886387504 11345440768 1932397616 19.086 99 26 52 0 1950364816 10747232 7219968
15:52:06 31924 8192000000 10872373072 11327418368 1882557280 18.686 97 31 62 1 1903379776 12444688 8377808
15:53:57 37905 8192000000 10912154320 11355004928 1936513136 19.119 99 41 82 0 1961521968 13828672 11180160
15:54:46 67514 8192000000 10869069536 11359621120 1936486608 19.119 99 21 42 0 1961825984 19760272 5579104
15:56:05 111183 8192000000 10881271104 11357380608 1875087104 18.625 96 9 18 0 1887692496 10316832 2288560
15:58:02 113672 8192000000 10875601536 11343683584 1940096768 19.148 99 18 35 2 1955786064 10959040 4730256
16:00:08 57214 8192000000 10890271440 11360460800 1949095552 19.219 99 11 22 0 1960439280 8942208 2401520
16:01:12 74288 8192000000 10892516112 11362971648 1944822272 19.185 99 5 10 0 1956712288 10760560 1129456
16:02:33 30066 8192000000 10904286032 11349245952 1930372912 19.070 98 40 80 3 1950223392 8166880 11683600
16:03:13 68279 8192000000 10888268656 11361972224 1943872304 19.178 99 21 42 0 1957813040 8599856 5340880
16:04:27 83287 8192000000 10890531568 11355656192 1932237584 19.085 98 15 30 2 1947683712 11036848 4409280
16:06:08 56826 8192000000 10890445136 11346874368 1893883504 18.777 96 27 54 0 1911522784 9925824 7713456
16:07:16 112079 8192000000 10876869488 11354222592 1896435088 18.798 97 10 20 0 1908726304 9310720 2980496
16:09:14 56764 8192000000 10903351216 11368247296 1944708576 19.184 99 11 22 0 1959297808 11841088 2748144
16:10:22 63658 8192000000 10890036256 11352682496 1904208496 18.860 97 13 26 1 1922757280 15042240 3506544
16:11:42 30211 8192000000 10885427264 11352444928 1925581072 19.032 98 41 81 0 1950667808 13527200 11559536
16:12:24 73174 8192000000 10905527648 11355664384 1891870784 18.761 96 31 63 0 1909458864 9242032 8346048
16:13:43 8391 8192000000 10916319008 11357589504 1958018240 19.290 100 53 107 0 1981607888 8929664 14659984
16:13:58 16422 8192000000 10918359088 11366535168 1966786144 19.360 100 52 104 1 1992610944 11509104 14315696
16:14:23 44412 8192000000 10901035424 11385139200 1974235936 19.419 100 30 60 0 2000601472 18222224 8143312
16:15:14 110638 8192000000 10903087760 11382648832 1958868640 19.297 99 17 34 1 1979543136 16243072 4431424
16:17:10 98453 8192000000 10888875872 11376721920 1937711808 19.128 98 21 42 0 1959499712 15614288 6173616
16:19:04 93060 8192000000 10898406544 11377725440 1943604544 19.176 98 16 32 0 1966376016 18136400 4635072
16:20:43 62784 8192000000 10886637824 11370438656 1916182368 18.956 97 14 28 0 1933411024 13116832 4111824
16:22:16 65268 8192000000 10872788672 11350712320 1916700080 18.960 98 16 32 0 1936035248 14135152 5200016
16:23:42 77785 8192000000 10858582448 11348242432 1916214096 18.956 98 19 38 0 1932539136 10756592 5568448
16:25:06 58512 8192000000 10878207360 11335815168 1905653776 18.872 98 18 36 0 1917994752 7278800 5062176
16:26:16 60086 8192000000 10855781776 11323117568 1888100560 18.730 97 21 42 0 1903660480 9342368 6217552

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 12-02-2021 16:28:55 to 12-02-2021 16:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 101 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 12-02-2021 16:29:27 to 12-02-2021 16:29:29.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          241501
MON$OLDEST_ACTIVE               241900
MON$OLDEST_SNAPSHOT             241900
MON$NEXT_TRANSACTION            241900
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                       2034528
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:254: 
:255: mscs-test-161.budzdorov.ru    Fri Feb 12 16:27:26 2021
:256:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:257: 
:258: 
:259: mscs-test-161.budzdorov.ru    Fri Feb 12 16:27:27 2021
:260:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:261: 
--- end of diff output ---

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

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