Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.02.2021 01: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 16924408 kB
MemAvailable 31188096 kB
Buffers 0 kB
Cached 14771688 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 01:27:20
DTS_END                         2021-02-12 01:27:20.3430
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35634
TRN_ID                          240565
ATT_ID                          706
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: 9381.79 18822 1125815
customer order: creation 179.87 354 21584
customer order: refuse 15.98 348 1917
order to supplier: creation 48.04 1332 5765
order to supplier: removal 3.45 100706 414
invoice (draft): creation 47.92 3574 5750
invoice (draft): removal 53.44 727 6413
invoice accept: apply 42.95 19050 5154
invoice accept: cancel 48.58 921 5830
customer reserve: creation 3924.22 191 470906
customer reserve: removal 4709.94 59 565193
realization accept: apply 87.18 188 10462
realization accept: cancel 84.18 106 10102
payment from customer: creation 62.05 101 7446
payment from customer: removal 5.98 89 718
payment to supplier: creation 51.79 119 6215
payment to supplier: removal 3.47 61 416
service: total inventory turnovers 4.95 1123 594
service: total monetary turnovers 6.84 29 821
service: aggregate perf. data 0.93 19464 111
service: refresh index statistics 0.03 227902 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-02-2021 01:28:52 to 12-02-2021 01:28:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4003
TEST_TIME 2 6614
TEST_TIME 3 6542
TEST_TIME 4 6522
TEST_TIME 5 6274
TEST_TIME 6 6565
TEST_TIME 7 6709
TEST_TIME 8 7418
TEST_TIME 9 7177
TEST_TIME 10 7270
TEST_TIME 11 7515
TEST_TIME 12 7315
TEST_TIME 13 7499
TEST_TIME 14 7676
TEST_TIME 15 7741
TEST_TIME 16 7843
TEST_TIME 17 7904
TEST_TIME 18 8081
TEST_TIME 19 8495
TEST_TIME 20 8731
TEST_TIME 21 8780
TEST_TIME 22 8810
TEST_TIME 23 9088
TEST_TIME 24 9160
TEST_TIME 25 9448
TEST_TIME 26 9851
TEST_TIME 27 9762
TEST_TIME 28 9949
TEST_TIME 29 10223
TEST_TIME 30 10529
TEST_TIME 31 10897
TEST_TIME 32 10862
TEST_TIME 33 10690
TEST_TIME 34 10592
TEST_TIME 35 10763
TEST_TIME 36 10664
TEST_TIME 37 10625
TEST_TIME 38 10507
TEST_TIME 39 10559
TEST_TIME 40 10520
TEST_TIME 41 10469
TEST_TIME 42 10337
TEST_TIME 43 10192
TEST_TIME 44 10067
TEST_TIME 45 10065
TEST_TIME 46 9915
TEST_TIME 47 9905
TEST_TIME 48 9804
TEST_TIME 49 9761
TEST_TIME 50 9847
TEST_TIME 51 9903
TEST_TIME 52 9816
TEST_TIME 53 9710
TEST_TIME 54 9789
TEST_TIME 55 9766
TEST_TIME 56 9698
TEST_TIME 57 9635
TEST_TIME 58 9576
TEST_TIME 59 9582
TEST_TIME 60 9839
TEST_TIME 61 9922
TEST_TIME 62 9942
TEST_TIME 63 9899
TEST_TIME 64 9928
TEST_TIME 65 9982
TEST_TIME 66 9963
TEST_TIME 67 9919
TEST_TIME 68 9948
TEST_TIME 69 9907
TEST_TIME 70 9852
TEST_TIME 71 9839
TEST_TIME 72 9781
TEST_TIME 73 9723
TEST_TIME 74 9740
TEST_TIME 75 9695
TEST_TIME 76 9643
TEST_TIME 77 9592
TEST_TIME 78 9545
TEST_TIME 79 9520
TEST_TIME 80 9474
TEST_TIME 81 9499
TEST_TIME 82 9515
TEST_TIME 83 9495
TEST_TIME 84 9471
TEST_TIME 85 9481
TEST_TIME 86 9485
TEST_TIME 87 9481
TEST_TIME 88 9490
TEST_TIME 89 9508
TEST_TIME 90 9533
TEST_TIME 91 9547
TEST_TIME 92 9572
TEST_TIME 93 9571
TEST_TIME 94 9585
TEST_TIME 95 9666
TEST_TIME 96 9606
TEST_TIME 97 9554
TEST_TIME 98 9532
TEST_TIME 99 9538
TEST_TIME 100 9504
TEST_TIME 101 9473
TEST_TIME 102 9460
TEST_TIME 103 9406
TEST_TIME 104 9409
TEST_TIME 105 9427
TEST_TIME 106 9424
TEST_TIME 107 9413
TEST_TIME 108 9445
TEST_TIME 109 9504
TEST_TIME 110 9475
TEST_TIME 111 9555
TEST_TIME 112 9525
TEST_TIME 113 9507
TEST_TIME 114 9542
TEST_TIME 115 9545
TEST_TIME 116 9566
TEST_TIME 117 9549
TEST_TIME 118 9482
TEST_TIME 119 9456
TEST_TIME 120 9385

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-02-2021 01:28:55 to 12-02-2021 01:28:59.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1562695 1562695 0 0.00 0 22788 7 0 0
doc_list_biud 1562685 1562685 0 0.00 0 76841 27 0 0
sp_add_invoice_to_stock 5224 5154 70 1.33 44 145324 19051 0 70
sp_cancel_adding_invoice 5830 5830 0 0.00 4 100009 922 0 0
sp_cancel_client_order 1917 1917 0 0.00 4 7793 348 0 0
sp_cancel_customer_reserve 565193 565193 0 0.00 1 76842 59 0 0
sp_cancel_pay_from_customer 718 718 0 0.00 3 8016 89 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 2 4371 61 0 0
sp_cancel_supplier_invoice 6415 6413 2 0.03 2 25289 728 0 2
sp_cancel_supplier_order 414 414 0 0.00 10 933319 100706 0 0
sp_cancel_write_off 10102 10102 0 0.00 1 8425 106 0 0
sp_client_order 21584 21584 0 0.00 4 24682 355 0 0
sp_customer_reserve 470906 470906 0 0.00 0 44494 191 0 0
sp_fill_shopping_cart 33086 33086 0 0.00 1 14374 40 0 0
sp_fill_shopping_cart_clo_res 470898 470898 0 0.00 0 22727 12 0 0
sp_get_clo_for_invoice 5146 5146 0 0.00 0 20732 286 0 0
sp_kill_cost_storno 17066 17066 0 0.00 0 9004 55 0 0
sp_kill_qstorno_ret_qs2qd 1147315 1147315 0 0.00 0 76840 32 0 0
sp_kill_qty_storno 605470 605470 0 0.00 0 76841 69 0 0
sp_lock_selected_doc 21627 21627 0 0.00 0 7752 5 0 0
sp_make_cost_storno 29269 29269 0 0.00 0 19643 57 0 0
sp_multiply_rows_for_pdistr 29265 29265 0 0.00 0 7428 28 0 0
sp_multiply_rows_for_qdistr 21584 21584 0 0.00 0 11319 152 0 0
sp_pay_from_customer 7446 7446 0 0.00 4 9463 101 0 0
sp_pay_to_supplier 6215 6215 0 0.00 4 23678 120 0 0
sp_payment_common 13659 13659 0 0.00 1 23669 27 0 0
sp_qd_handle_on_cancel_clo 1917 1917 0 0.00 0 7787 316 0 0
sp_qd_handle_on_invoice_upd_sts 10971 10971 0 0.00 0 23112 356 0 0
sp_qd_handle_on_reserve_upd_sts 10460 10460 0 0.00 0 16776 59 0 0
sp_reserve_write_off 10462 10462 0 0.00 6 19651 188 0 0
sp_supplier_invoice 5750 5750 0 0.00 6 98081 3574 0 0
sp_supplier_order 5765 5765 0 0.00 5 87066 1332 0 0
srv_aggregate_perf_data 111 111 0 0.00 2286 285217 19465 0 0
srv_fill_mon_cache_memory 177 177 0 0.00 1070 124448 29331 0 0
srv_find_qd_qs_mism 1076690 1076690 0 0.00 0 22787 6 0 0
srv_make_invnt_saldo 594 594 0 0.00 29 32707 1123 0 0
srv_make_money_saldo 821 821 0 0.00 1 4709 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 117989 387589 227903 0 0
t$perf-abend:sp_add_invoice_to_stock 70 70 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5154 5154 0 0.00 0 13802 174 0 0
t$perf-norm:sp_cancel_adding_invoice 453 453 0 0.00 0 9155 120 0 0
t$perf-norm:sp_cancel_client_order 1917 1917 0 0.00 0 6466 15 0 0
t$perf-norm:sp_cancel_customer_reserve 678 678 0 0.00 0 8246 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 718 718 0 0.00 0 377 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 1650 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 377 377 0 0.00 0 2280 23 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 35024 1765 0 0
t$perf-norm:sp_cancel_write_off 1054 1054 0 0.00 0 7505 14 0 0
t$perf-norm:sp_client_order 21584 21584 0 0.00 0 13063 19 0 0
t$perf-norm:sp_customer_reserve 1063 1063 0 0.00 0 16129 32 0 0
t$perf-norm:sp_pay_from_customer 7446 7446 0 0.00 0 7661 11 0 0
t$perf-norm:sp_pay_to_supplier 6215 6215 0 0.00 0 5917 14 0 0
t$perf-norm:sp_reserve_write_off 10462 10462 0 0.00 0 10583 11 0 0
t$perf-norm:sp_supplier_invoice 5750 5750 0 0.00 0 15978 26 0 0
t$perf-norm:sp_supplier_order 5765 5765 0 0.00 0 9796 20 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 1452 28 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 805 9 0 0
t$perf-norm:srv_make_invnt_saldo 594 594 0 0.00 0 928 20 0 0
t$perf-norm:srv_make_money_saldo 821 821 0 0.00 0 1943 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 12 5 0 0
v_add_invoice_to_stock 10418 10278 140 1.34 0 7733 18 0 140
v_all_customers 39542 39542 0 0.00 0 21 1 0 0
v_all_suppliers 31962 31962 0 0.00 0 24 1 0 0
v_all_wares 43166 43166 0 0.00 0 63 1 0 0
v_cancel_adding_invoice 906 906 0 0.00 0 7576 20 0 0
v_cancel_client_order 3834 3834 0 0.00 0 2301 6 0 0
v_cancel_customer_prepayment 1436 1436 0 0.00 0 978 5 0 0
v_cancel_customer_reserve 1356 1356 0 0.00 0 3581 7 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 508 4 0 0
v_cancel_supplier_invoice 758 754 4 0.52 0 706 13 0 4
v_cancel_supplier_order 828 828 0 0.00 0 3284 8 0 0
v_cancel_write_off 2108 2108 0 0.00 0 1601 13 0 0
v_max_id_clo_ord 5758 5758 0 0.00 0 156 1 0 0
v_max_id_clo_res 1063 1063 0 0.00 0 2154 12 0 0
v_max_id_ord_sup 5743 5743 0 0.00 0 6836 7 0 0
v_max_non_paid_invoice 1733 1733 0 0.00 0 424 3 0 0
v_max_non_paid_realizn 3860 3860 0 0.00 0 2616 5 0 0
v_min_id_clo_ord 5758 5758 0 0.00 0 6958 9 0 0
v_min_id_clo_res 1063 1063 0 0.00 0 1968 6 0 0
v_min_id_ord_sup 5743 5743 0 0.00 0 6773 7 0 0
v_min_non_paid_invoice 6213 6213 0 0.00 0 23664 19 0 0
v_min_non_paid_realizn 7446 7446 0 0.00 0 9353 17 0 0
v_our_firm 10796 10796 0 0.00 0 17 1 0 0
v_reserve_write_off 20920 20920 0 0.00 0 3465 6 0 0
x_lock_depdocs_on_canc_invoice 11866 11866 0 0.00 0 21538 121 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 5400 315 0 0
x_make_qstorno_1000_1200 5765 5765 0 0.00 1 87056 1247 0 0
x_make_qstorno_1200_2000 5750 5750 0 0.00 2 89090 3429 0 0
x_make_qstorno_2100_3300 470906 470906 0 0.00 0 44492 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-02-2021 01:29:00 to 12-02-2021 01:29:04.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:24 9 8192000000 8801229776 8812527616 6918096 0.084 2 1 2 0 7037472 56816 62560
22:57:30 17630 8192000000 10271103168 10581045248 1034275520 11.210 80 60 118 1 1055207168 2647376 18284272
22:57:59 30686 8192000000 10363872352 10684932096 1400729456 14.601 100 80 160 0 1431658352 5260704 25668192
22:58:38 29594 8192000000 10394514576 10719346688 1444832032 14.992 100 89 178 1 1481862240 7222944 29807264
22:59:20 35770 8192000000 10424765584 10753572864 1471338464 15.225 100 90 180 0 1509133424 8349456 29445504
23:00:06 20032 8192000000 10437284416 10767650816 1492116656 15.407 100 90 180 0 1529939664 9055488 28767520
23:00:37 14917 8192000000 10450337024 10784321536 1508817936 15.553 100 86 173 0 1544836048 9264304 26753808
23:01:09 14462 8192000000 10462419712 10804473856 1521313264 15.662 100 83 166 0 1557116160 9625856 26177040
23:01:33 14491 8192000000 10480392640 10825093120 1540958896 15.832 100 84 168 0 1576853616 9765376 26129344
23:02:00 11152 8192000000 10514732064 10862501888 1572423296 16.103 100 81 162 2 1606963600 10186192 24354112
23:02:33 13912 8192000000 10563844320 10915901440 1610849200 16.432 100 81 163 1 1646331904 11060832 24421872
23:02:57 13644 8192000000 10577686592 10934943744 1629143712 16.588 100 78 155 0 1663930032 11255680 23530640
23:03:19 5557 8192000000 10580326496 10940170240 1642005776 16.697 100 79 159 0 1677593712 12092336 23495600
23:03:33 13366 8192000000 10610161168 10969669632 1660457888 16.853 100 84 168 1 1696983552 12228896 24296768
23:03:54 8453 8192000000 10616810944 10984308736 1679192256 17.011 100 82 162 2 1716017344 12713440 24111648
23:04:11 7557 8192000000 10628353200 10996490240 1690100944 17.102 100 72 144 0 1723566416 12360128 21105344
23:04:28 11565 8192000000 10636164960 11014668288 1706831344 17.242 100 77 153 2 1741000336 12200608 21968384
23:04:50 7086 8192000000 10661519328 11039358976 1728656688 17.424 100 68 137 2 1759147248 11124752 19365808
23:05:04 7688 8192000000 10680353472 11058302976 1744097552 17.553 100 75 150 0 1777634144 11667856 21868736
23:05:20 6776 8192000000 10699257520 11075895296 1754878288 17.642 100 78 154 1 1789253760 12290032 22085440
23:05:33 5601 8192000000 10700421552 11079356416 1766621120 17.739 100 79 157 0 1801384192 12502528 22260544
23:05:46 4604 8192000000 10713249360 11089461248 1771506624 17.779 100 82 164 1 1807842752 13303040 23033088
23:05:58 3860 8192000000 10718659648 11096678400 1780449248 17.853 100 90 180 2 1819595584 14642928 24503408
23:06:08 3953 8192000000 10730085824 11106304000 1790874752 17.939 100 89 177 0 1829045824 13516416 24654656
23:06:19 2474 8192000000 10732779264 11111129088 1797175184 17.991 100 87 174 1 1835642800 14898128 23569488
23:06:28 3200 8192000000 10732741216 11116085248 1798744480 18.004 100 86 172 2 1837927264 15626832 23555952
23:06:38 4723 8192000000 10738254528 11124551680 1798267344 18.000 100 78 156 0 1833781664 14441744 21072576
23:06:50 5340 8192000000 10739290032 11123752960 1803701744 18.044 100 81 163 2 1840790896 14375200 22713952
23:07:02 2896 8192000000 10760924592 11143811072 1816504320 18.149 100 82 162 0 1851936208 12480256 22951632
23:07:11 3033 8192000000 10766966688 11151659008 1825501360 18.223 100 89 176 2 1863263920 12535424 25227136
23:07:21 3211 8192000000 10775354176 11157262336 1826964288 18.235 100 88 171 3 1864367424 12961360 24441776
23:07:30 2686 8192000000 10781358752 11163181056 1835188608 18.302 100 94 189 1 1876924848 14545936 27190304
23:07:39 3042 8192000000 10777012096 11162935296 1837934496 18.324 100 88 176 1 1876383760 13193616 25255648
23:07:49 1933 8192000000 10783434832 11169083392 1843770368 18.371 100 91 183 2 1882489280 13334336 25384576
23:07:57 1059 8192000000 10793883680 11175538688 1845464224 18.385 100 93 187 0 1884722960 13057264 26201472
23:08:04 2103 8192000000 10797341648 11182010368 1851608416 18.435 100 94 187 1 1892183808 14016176 26559216
23:08:12 2063 8192000000 10788757456 11178438656 1856421664 18.474 100 92 182 0 1894641488 12256720 25963104
23:08:21 1746 8192000000 10802233072 11188736000 1856094112 18.472 100 94 188 0 1896344128 13327712 26922304
23:08:29 1561 8192000000 10809101600 11194634240 1861807232 18.518 100 93 188 2 1902007200 12649408 27550560
23:08:37 2512 8192000000 10809733904 11197145088 1866684080 18.557 100 88 177 2 1904466928 12113344 25669504
23:08:46 1791 8192000000 10813394960 11199135744 1866857696 18.559 100 92 184 1 1905944640 12322688 26764256
23:08:54 1942 8192000000 10810386016 11204562944 1869063936 18.577 100 88 178 2 1910432400 16691760 24676704
23:09:03 3754 8192000000 10803643312 11202822144 1871340640 18.595 100 76 152 1 1904908144 12590928 20976576
23:09:15 37668 8192000000 10801712080 11207663616 1869092416 18.577 100 60 119 2 1899652640 13691088 16869136
23:10:00 1796 8192000000 10828156400 11214811136 1878354112 18.652 100 94 188 0 1917841408 11423664 28063632
23:10:08 5765 8192000000 10792977872 11202871296 1869532544 18.580 100 46 92 1 1891692080 8817712 13341824
23:10:20 6599 8192000000 10781360704 11206127616 1876663760 18.638 100 43 86 4 1901599952 12947552 11988640
23:10:34 4229 8192000000 10798179440 11217051648 1879235408 18.659 100 53 104 1 1902836592 8715744 14885440
23:10:45 6297 8192000000 10797080720 11215785984 1879729312 18.663 100 44 89 1 1901714960 9455312 12530336
23:11:01 6769 8192000000 10796228256 11214999552 1878444400 18.653 100 38 74 2 1897328544 8459504 10424640
23:11:14 3862 8192000000 10793434432 11214815232 1878337168 18.652 100 36 72 0 1896855168 8064880 10453120
23:11:24 6831 8192000000 10791567680 11215450112 1879353520 18.660 100 29 57 2 1893742816 6370752 8018544
23:11:39 5489 8192000000 10797458240 11220529152 1886004672 18.714 100 39 78 0 1904658944 7275968 11378304
23:11:55 2808 8192000000 10786785408 11219619840 1886585072 18.718 100 23 46 2 1900307632 5639808 8082752
23:12:06 4760 8192000000 10803709344 11227258880 1885279776 18.708 100 28 56 3 1900043184 6754288 8009120
23:12:22 24375 8192000000 10808119824 11227676672 1887471440 18.725 100 26 52 0 1901115248 5914656 7729152
23:12:56 58983 8192000000 10833490768 11243429888 1897578032 18.807 100 54 104 5 1918038704 4971664 15489008
23:14:01 1679 8192000000 10857047408 11256176640 1907537904 18.887 100 95 191 1 1945101680 9992528 27571248
23:14:11 6543 8192000000 10812132624 11244421120 1896733024 18.800 100 30 60 2 1911891296 6866656 8291616
23:14:32 5123 8192000000 10822042400 11251707904 1904864480 18.865 100 32 63 2 1920321776 6560384 8896912
23:14:45 6596 8192000000 10813625760 11248812032 1904179904 18.860 100 27 54 2 1918959296 7320080 7459312
23:14:59 6485 8192000000 10821354624 11250917376 1907108064 18.883 100 36 73 0 1924864816 7006720 10750032
23:15:12 7927 8192000000 10827952528 11259211776 1908900352 18.898 100 28 57 0 1927752160 10372416 8479392
23:15:28 7767 8192000000 10827336304 11261833216 1911328096 18.917 100 34 68 1 1928520544 6655552 10536896
23:15:44 6224 8192000000 10821752128 11256475648 1907854432 18.889 100 17 34 3 1918487072 5840112 4792528
23:15:56 10366 8192000000 10825325472 11256991744 1909336832 18.901 100 18 36 3 1920303872 5736672 5230368
23:16:14 7483 8192000000 10830892544 11261808640 1912676384 18.928 100 22 43 2 1924396512 5414592 6305536
23:16:29 6117 8192000000 10797022528 11232358400 1864953984 18.543 98 19 38 3 1877268640 6136080 6178576
23:16:42 8432 8192000000 10809884224 11237318656 1890472288 18.750 100 16 32 0 1900325040 5397216 4455536
23:17:01 44242 8192000000 10823830800 11236552704 1876461616 18.637 99 52 105 2 1898456128 5990368 16004144
23:17:54 10414 8192000000 10798031440 11229204480 1871309680 18.595 99 21 42 1 1883373648 5825872 6238096
23:18:12 8493 8192000000 10793847760 11222032384 1854327216 18.457 98 24 48 0 1867738256 6750144 6660896
23:18:27 5343 8192000000 10811900288 11234267136 1876413152 18.636 99 40 80 2 1897824224 10183296 11227776
23:18:42 6212 8192000000 10792261680 11215048704 1859466976 18.499 99 26 53 1 1873947120 7036400 7443744
23:18:55 4006 8192000000 10784993520 11208814592 1867862304 18.567 100 37 74 0 1885812688 7518320 10432064
23:19:07 6884 8192000000 10770747616 11199909888 1859836304 18.502 100 28 55 1 1873679552 5914800 7928448
23:19:23 5212 8192000000 10764354000 11189485568 1842816304 18.364 99 33 66 2 1859056096 6283744 9956048
23:19:35 6586 8192000000 10761699088 11172474880 1788556736 17.920 97 26 51 4 1801358800 5036560 7765504
23:19:51 7752 8192000000 10715335904 11136651264 1762749808 17.707 97 22 44 1 1775952240 6487344 6715088
23:20:05 12037 8192000000 10747285024 11164073984 1824394800 18.214 100 21 42 0 1835763552 5035088 6333664
23:20:24 6622 8192000000 10753606064 11169337344 1819515200 18.174 99 31 63 1 1833572544 5074448 8982896
23:20:38 11654 8192000000 10734133424 11156738048 1740344224 17.521 94 29 56 1 1754220672 5498736 8377712
23:20:57 6626 8192000000 10734825488 11156082688 1774225248 17.802 97 19 38 5 1785567312 4986400 6355664
23:21:12 7696 8192000000 10704989408 11122855936 1725023136 17.394 95 24 47 2 1737855008 4948336 7883536
23:21:27 60127 8192000000 10733748176 11125207040 1740690144 17.524 96 56 113 1 1762696016 5049008 16956864
23:22:33 12383 8192000000 10714469344 11137605632 1773112464 17.793 98 27 54 3 1787644800 6958496 7573840
23:22:52 5983 8192000000 10711508240 11131514880 1774357024 17.803 98 20 40 0 1785808464 5498672 5952768
23:23:05 8361 8192000000 10730539504 11142356992 1779642640 17.847 98 34 67 1 1794524352 5609920 9271792
23:23:22 7574 8192000000 10736659520 11155021824 1817502752 18.157 100 28 56 2 1832177712 6287984 8386976
23:23:36 8645 8192000000 10732424480 11156688896 1825326336 18.221 100 34 64 3 1840665088 5651936 9686816
23:23:52 7390 8192000000 10739862016 11170320384 1819025120 18.170 99 23 44 4 1831696064 6203408 6467536
23:24:06 5335 8192000000 10757775760 11179245568 1843797568 18.372 100 24 48 1 1856947152 5464384 7685200
23:24:17 8066 8192000000 10775123456 11193905152 1848893856 18.413 100 19 39 2 1859611104 5155120 5562128
23:24:37 15306 8192000000 10769792000 11199053824 1858318864 18.490 100 20 41 0 1869771872 5540432 5912576
23:24:59 17826 8192000000 10782463136 11208065024 1864523216 18.540 100 40 80 1 1882606896 5523712 12559968
23:25:23 58578 8192000000 10752418528 11181309952 1826639936 18.232 98 20 36 4 1836469776 4434752 5395088
23:26:28 14372 8192000000 10772461280 11209531392 1863960016 18.535 100 16 30 1 1873900736 5151824 4788896
23:26:48 8916 8192000000 10786727120 11214688256 1868866848 18.575 100 23 45 1 1881054960 6078064 6110048
23:27:06 5788 8192000000 10812999296 11232047104 1886970912 18.721 100 34 69 2 1903209648 6932384 9306352
23:27:19 24051 8192000000 10835831120 11251400704 1896084272 18.795 100 41 81 0 1912487536 5003408 11399856
23:27:50 16868 8192000000 10851215568 11263049728 1915496560 18.951 100 63 124 2 1943098464 10742928 16858976
23:28:29 2179 8192000000 10867075552 11280957440 1925052816 19.027 100 66 130 1 1956560560 13140448 18367296
23:28:39 25701 8192000000 10871359152 11290505216 1929487504 19.063 100 64 128 1 1960893248 14031568 17374176
23:29:12 11705 8192000000 10872417312 11292647424 1935623136 19.112 100 69 138 2 1970012784 15270800 19118848
23:29:31 6849 8192000000 10875707088 11296215040 1937301760 19.125 100 54 108 2 1965974864 13183456 15489648
23:29:52 2474 8192000000 10880388000 11303022592 1945168208 19.188 100 64 126 1 1977306272 13221632 18916432
23:30:01 11772 8192000000 10885339424 11305086976 1947688288 19.208 100 62 120 0 1977317728 13071072 16558368
23:30:21 34009 8192000000 10871154336 11311894528 1949923232 19.226 100 41 82 0 1974250928 12834672 11493024
23:31:03 13165 8192000000 10876998896 11314118656 1952207120 19.244 100 40 80 2 1978264784 13780112 12277552
23:31:23 2950 8192000000 10881514672 11315859456 1955421968 19.270 100 43 86 1 1979445552 11049584 12974000
23:31:34 10501 8192000000 10897542672 11321683968 1959109776 19.299 100 49 96 1 1984505344 11891312 13504256
23:31:53 7126 8192000000 10900409952 11329617920 1963619696 19.335 100 52 105 0 1991839424 12945216 15274512
23:32:11 9917 8192000000 10898516848 11323842560 1960561920 19.311 100 57 114 0 1991317120 14344608 16410592
23:32:29 10885 8192000000 10910779424 11335307264 1963948688 19.337 100 49 98 0 1992407056 14859424 13598944
23:32:49 10891 8192000000 10908881216 11337949184 1969025072 19.378 100 54 107 1 2000062656 15341520 15696064
23:33:12 2457 8192000000 10924525792 11341991936 1974686848 19.423 100 65 129 0 2008531664 15675856 18168960
23:33:21 6442 8192000000 10905385520 11326140416 1961098976 19.315 99 69 136 1 1995689536 15890976 18699584
23:34:02 12637 8192000000 10923546720 11354972160 1979851072 19.464 100 58 114 1 2013770384 17305968 16613344
23:34:25 8403 8192000000 10935703440 11359805440 1987120080 19.521 100 67 132 0 2024066032 17824944 19121008
23:34:41 3432 8192000000 10943712384 11372187648 1997193472 19.601 100 72 143 2 2041856176 24214720 20447984
23:34:51 5804 8192000000 10961122448 11377123328 2000286048 19.625 100 76 154 2 2043087312 20222976 22578288
23:35:05 3933 8192000000 10957605200 11381698560 1999433808 19.618 100 65 130 0 2039205536 20145216 19626512
23:35:19 6433 8192000000 10943287936 11375861760 2001075520 19.631 100 59 118 1 2033799312 15242080 17481712
23:35:32 25940 8192000000 10942721952 11384500224 2002296448 19.641 100 53 106 2 2034451424 16355728 15799248
23:36:06 8000 8192000000 10953555952 11390652416 2006503984 19.674 100 43 86 3 2035747760 16234112 13009664
23:36:43 5460 8192000000 10962794768 11400531968 2015401232 19.744 100 53 105 1 2054055536 22661552 15992752
23:36:56 7635 8192000000 10957039936 11404754944 2015455728 19.744 100 49 97 1 2054151520 22977424 15718368
23:37:12 6258 8192000000 10977239424 11413393408 2021339856 19.791 100 59 118 2 2066858304 27515184 18003264
23:37:27 3395 8192000000 10964640288 11402739712 2004011456 19.654 99 67 133 0 2044979840 21047104 19921280
23:37:39 6918 8192000000 10970151536 11401719808 2015946384 19.748 100 70 139 1 2058705264 22003056 20755824
23:37:53 4769 8192000000 10989131584 11410370560 2022413888 19.799 100 73 141 0 2065427680 22104464 20909328
23:38:12 2610 8192000000 10978860448 11415699456 2023822880 19.810 100 61 123 0 2068587440 26522496 18242064
23:38:22 8648 8192000000 10976993872 11405733888 2008677392 19.691 99 56 110 0 2051544800 26915824 15951584
23:38:38 11593 8192000000 10962966640 11411009536 2006952256 19.678 99 68 134 2 2054954848 27170640 20831952
23:39:02 2929 8192000000 10965587664 11401850880 2015652880 19.746 100 62 125 2 2052736640 19373232 17710528
23:39:12 6378 8192000000 10975160688 11409072128 2024171744 19.813 100 69 136 1 2064303056 20802688 19328624
23:39:28 21866 8192000000 10961726656 11404169216 2005863008 19.669 99 54 108 2 2045174288 23160656 16150624
23:40:12 10309 8192000000 10966826800 11406172160 2012733936 19.723 100 49 99 1 2052926352 25114864 15077552
23:40:28 1409 8192000000 10960219664 11392729088 2001585216 19.635 99 62 125 1 2047337936 26253424 19499296
23:40:41 2166 8192000000 10983621280 11409186816 2014768416 19.739 100 63 125 0 2061137824 27347024 19022384
23:40:54 6335 8192000000 10965819776 11403231232 2011656352 19.715 100 61 122 0 2056052672 25640592 18755728
23:41:09 14290 8192000000 10951172240 11387084800 1977869856 19.448 98 58 113 1 2021529520 26008128 17651536
23:41:37 2150 8192000000 10971708576 11387674624 1999043728 19.615 100 85 163 1 2051999856 26716944 26239184
23:41:47 5809 8192000000 10956797584 11393982464 2003947728 19.654 100 70 137 1 2051602064 25515184 22139152
23:42:00 12799 8192000000 10955877008 11393019904 1988908672 19.535 99 60 120 0 2034250752 25782288 19559792
23:42:19 5473 8192000000 10943548368 11370708992 1968717504 19.375 99 66 132 1 2016349936 26637088 20995344
23:42:31 1886 8192000000 10964444640 11384782848 1979840736 19.463 99 81 156 3 2029864640 26012000 24011904
23:42:40 3017 8192000000 10936157280 11347230720 1967298912 19.364 99 90 180 1 2020864304 26176032 27389360
23:42:50 4581 8192000000 10949290144 11367886848 1979700784 19.462 100 82 165 0 2032186096 27423920 25061392
23:43:03 4266 8192000000 10955507296 11370647552 1977683856 19.446 100 89 178 0 2034511376 28609072 28218448
23:43:17 11701 8192000000 10919288224 11349757952 1957339216 19.285 100 69 138 0 2007970256 29371728 21259312
23:43:38 8179 8192000000 10937728080 11366387712 1970706560 19.391 100 68 137 0 2021701600 29656592 21338448
23:43:54 1070 8192000000 10948837440 11363340288 1972237808 19.403 100 76 145 2 2025273056 29473872 23561376
23:44:01 3266 8192000000 10935874128 11352817664 1957963360 19.290 99 74 146 2 2011485456 30703696 22818400
23:44:11 2866 8192000000 10924860416 11347345408 1942765136 19.169 99 75 150 0 1998353088 31790000 23797952
23:44:22 10498 8192000000 10937032464 11365085184 1969272384 19.380 100 65 129 1 2022667888 33256576 20138928
23:44:45 2202 8192000000 10937349008 11360448512 1969409184 19.381 100 65 130 0 2019980336 30090528 20480624
23:44:54 3850 8192000000 10953608032 11371560960 1977604656 19.446 100 78 157 0 2032038736 30767872 23666208
23:45:06 2496 8192000000 10936382576 11344601088 1954399456 19.261 99 81 159 5 2009948960 31275808 24273696
23:45:15 1914 8192000000 10964843952 11370651648 1981574192 19.477 100 95 191 1 2040547392 30367040 28606160
23:45:25 1189 8192000000 10960534432 11368153088 1980072608 19.465 100 94 182 1 2038698048 30557104 28068336
23:45:35 3628 8192000000 10964987760 11378610176 1986104128 19.513 100 88 176 1 2044864080 32129088 26630864
23:45:45 3837 8192000000 10961111088 11381043200 1990516320 19.548 100 82 164 0 2048049600 31914448 25618832
23:45:56 4189 8192000000 10977740960 11388604416 1990990608 19.552 100 92 183 1 2053784880 34600784 28193488
23:46:07 4397 8192000000 10972128432 11391782912 1993586640 19.572 100 83 166 3 2056704912 36508304 26609968
23:46:19 3788 8192000000 10961109440 11388702720 1987106336 19.521 100 69 138 0 2044644128 35616048 21921744
23:46:30 4450 8192000000 10959492208 11383218176 1982549568 19.485 100 68 136 2 2038829280 35103632 21176080
23:46:41 5553 8192000000 10933756112 11366027264 1957170416 19.284 99 56 112 1 2009730240 34996912 17562912
23:46:56 8316 8192000000 10942819296 11371864064 1971374064 19.396 100 58 116 0 2022293312 32780864 18138384
23:47:12 2667 8192000000 10950595712 11357712384 1961636432 19.319 99 88 176 1 2025169232 36211600 27321200
23:47:21 4388 8192000000 10946788048 11371053056 1972947680 19.409 100 73 145 1 2033618080 38672800 21997600
23:47:31 15999 8192000000 10902604304 11335413760 1929620880 19.064 98 42 84 3 1975499424 32371136 13507408
23:47:57 8554 8192000000 10923430144 11356372992 1960713680 19.312 100 47 93 2 2009972352 34463808 14794864
23:48:21 14375 8192000000 10910651936 11352293376 1924654704 19.024 98 34 68 0 1967983184 32153616 11174864
23:48:44 4248 8192000000 10944860224 11368808448 1971274608 19.396 100 80 161 3 2031554640 35926400 24353632
23:48:56 12876 8192000000 10926651280 11364425728 1953493936 19.254 99 45 89 2 2005691232 37719376 14477920
23:49:15 6813 8192000000 10934044368 11364073472 1955034256 19.267 99 44 88 0 2013499360 43388896 15076208
23:49:38 16684 8192000000 10945980320 11383713792 1967317968 19.364 100 37 73 1 2019727408 40536000 11873440
23:50:07 12443 8192000000 10926277536 11380727808 1967122672 19.363 99 36 72 1 2019883808 40796704 11964432
23:50:32 6029 8192000000 10947669232 11388588032 1986070592 19.513 100 47 95 3 2037303168 35663072 15569504
23:50:44 11746 8192000000 10939003440 11384041472 1965119280 19.347 99 38 76 1 2015309136 37616384 12573472
23:51:12 10535 8192000000 10928207232 11366948864 1931449920 19.078 98 42 83 2 1985822384 40673344 13699120
23:51:51 2134 8192000000 10957506816 11374964736 1968432768 19.373 100 85 170 2 2036143120 40812480 26897872
23:52:02 5206 8192000000 10933595760 11363074048 1952813552 19.249 100 57 109 1 2013826528 44077440 16935536
23:52:17 16343 8192000000 10926579696 11377086464 1956852144 19.281 100 36 72 1 2015749072 46759104 12137824
23:52:50 14775 8192000000 10915752192 11365228544 1954928672 19.266 100 31 62 0 2005836160 40143280 10764208
23:53:20 28214 8192000000 10891831424 11352686592 1911886880 18.922 98 23 46 0 1959429904 39572464 7970560
23:53:55 14139 8192000000 10897531504 11344670720 1938057824 19.131 100 28 54 3 1983125376 36056880 9010672
23:54:23 64320 8192000000 10890537696 11343491072 1932324688 19.085 100 33 67 1 1981571568 38094640 11152240
23:55:36 19245 8192000000 10901800928 11353698304 1938803024 19.137 100 27 53 0 1981486016 33852928 8830064
23:56:02 10684 8192000000 10888564816 11352776704 1942647632 19.168 100 19 38 4 1982586768 33441376 6497760
23:56:19 18363 8192000000 10884928432 11347533824 1928241568 19.053 99 19 38 1 1964307520 29756480 6309472
23:56:43 40553 8192000000 10898042144 11356041216 1942800720 19.169 100 23 46 0 1978449168 28552480 7095968
23:57:40 47734 8192000000 10890647248 11361845248 1947433952 19.206 100 13 26 0 1974493712 23075632 3984128
23:58:34 51856 8192000000 10894978992 11366744064 1952089296 19.243 100 5 9 0 1973553264 20319280 1144688
23:59:32 47344 8192000000 10895857456 11353882624 1928498720 19.055 98 34 65 1 1947496384 10314768 8682896
00:00:26 81827 8192000000 10885389024 11348717568 1907790288 18.889 97 13 27 2 1928467936 16865680 3811968
00:01:57 96556 8192000000 10898200096 11359498240 1955413408 19.270 100 11 23 1 1975999952 17382336 3204208
00:03:57 83584 8192000000 10909424096 11372085248 1954477088 19.262 99 23 46 3 1972087744 11042208 6568448
00:05:59 53723 8192000000 10913466912 11366817792 1953461968 19.254 99 20 40 1 1973168992 13519904 6187120
00:07:00 45317 8192000000 10901023824 11360788480 1935827136 19.113 98 33 67 1 1958212400 12598624 9786640
00:07:54 76043 8192000000 10904028176 11368529920 1965486032 19.350 100 19 38 0 1986553264 15788624 5278608
00:09:17 93223 8192000000 10910056224 11365789696 1971435568 19.397 100 19 38 0 1984835184 7889120 5510496
00:11:03 38838 8192000000 10913252304 11361521664 1940623984 19.152 98 36 71 2 1961074304 10109520 10340800
00:11:49 26136 8192000000 10929633648 11374260224 1958910624 19.297 99 58 116 2 1989200896 13600976 16689296
00:12:21 31175 8192000000 10877887456 11349139456 1944534432 19.183 99 21 42 1 1962025056 11669552 5821072
00:13:24 37672 8192000000 10902948256 11357790208 1950963520 19.234 99 33 67 1 1971133904 9460352 10710032
00:14:08 52166 8192000000 10892910192 11357319168 1955604640 19.271 99 26 52 0 1976192608 13048048 7539920
00:15:18 52225 8192000000 10924116928 11382247424 1965562688 19.350 99 27 50 3 1990237312 16352048 8322576
00:16:33 46227 8192000000 10918093712 11393044480 1986376112 19.515 100 24 49 0 2013052128 18976496 7699520
00:17:27 49498 8192000000 10921879952 11407171584 1982007952 19.481 100 15 28 1 2010576096 24112720 4455424
00:18:27 28255 8192000000 10915818432 11411689472 1988214080 19.530 100 12 24 0 2009516128 17734624 3567424
00:20:18 25894 8192000000 10915763216 11393605632 1989071824 19.536 100 9 17 2 2006749248 14209040 3468384
00:20:50 55511 8192000000 10894708464 11378335744 1963076496 19.330 99 15 30 1 1977033280 9758608 4198176
00:21:56 42089 8192000000 10900947936 11391336448 1962466128 19.326 99 5 10 0 1972760240 8986304 1307808
00:22:46 51362 8192000000 10917022656 11396972544 1951466352 19.238 98 12 24 0 1969076432 13861328 3748752
00:23:43 62353 8192000000 10930540192 11397537792 1971963696 19.401 99 21 43 1 1995762544 18039920 5758928
00:24:55 84495 8192000000 10936664624 11395866624 1946603536 19.199 98 21 42 3 1974650656 21994064 6053056
00:26:27 65275 8192000000 10920679136 11406270464 1942816016 19.169 98 25 50 2 1975106528 25395440 6895072
00:27:39 66557 8192000000 10910952064 11392851968 1958100816 19.291 99 10 20 1 1985670864 24434448 3135600
00:28:53 67624 8192000000 10869917920 11339456512 1861948912 18.519 95 10 21 0 1886528160 22081712 2497536
00:30:07 54819 8192000000 10861413184 11311316992 1784364560 17.885 91 13 26 0 1795407776 7530384 3512832
00:31:09 42363 8192000000 10856574752 11320442880 1879503792 18.661 97 34 68 2 1900336400 11455456 9377152
00:32:06 74438 8192000000 10888513904 11327344640 1877599616 18.646 97 18 36 1 1897102784 13050896 6452272
00:33:28 33296 8192000000 10883943136 11347128320 1946534256 19.199 100 36 72 0 1967158656 10147216 10477184
00:34:11 36271 8192000000 10882116512 11340406784 1932072208 19.083 99 26 52 0 1949285376 9770560 7442608
00:35:02 50898 8192000000 10906090800 11373686784 1961661632 19.319 100 17 34 1 1983254016 16915856 4676528
00:36:01 43171 8192000000 10893508432 11373760512 1959671888 19.303 100 11 22 1 1983553488 20641104 3240496
00:36:54 113766 8192000000 10875688208 11334782976 1874368944 18.620 96 18 36 0 1889443200 9917104 5157152
00:39:03 52998 8192000000 10863861488 11324370944 1909049888 18.899 98 33 64 1 1926710800 8818304 8842608
00:40:04 11980 8192000000 10893684160 11331411968 1945701104 19.192 100 60 123 0 1971619504 8265696 17652704
00:40:24 13139 8192000000 10866628176 11315826688 1919947312 18.986 99 43 86 2 1941715840 10345824 11422704
00:40:43 36512 8192000000 10831616912 11308654592 1917322096 18.965 100 39 78 0 1937851536 9432320 11097120
00:41:29 37258 8192000000 10829690496 11308933120 1903280224 18.853 99 21 42 1 1916679472 7074720 6324528
00:42:13 32858 8192000000 10829581952 11298390016 1880340720 18.668 98 10 20 1 1889108848 5938496 2829632
00:42:57 21385 8192000000 10829988000 11301007360 1883893664 18.697 98 16 33 0 1894975312 6563984 4517664
00:43:36 38770 8192000000 10839376560 11310620672 1892677040 18.767 98 21 42 0 1906558832 7805344 6076448
00:44:21 62406 8192000000 10854317728 11326644224 1934049328 19.099 100 14 28 0 1946833040 8601456 4182256
00:45:36 64053 8192000000 10875940080 11340005376 1926726528 19.041 99 16 32 0 1941446656 9984640 4735488
00:46:46 56582 8192000000 10867098704 11343745024 1949759088 19.225 100 16 32 1 1965062784 10717456 4586240
00:47:49 39593 8192000000 10859911456 11341176832 1938772896 19.137 100 17 34 2 1955864144 10776176 6315072
00:48:38 30497 8192000000 10875859376 11332386816 1929420224 19.062 99 37 74 1 1947778544 8227168 10131152
00:49:24 59952 8192000000 10840775920 11324657664 1899070624 18.819 98 11 22 0 1910487648 8383136 3033888
00:50:34 48387 8192000000 10879549840 11343736832 1924913552 19.026 99 21 42 0 1941067952 10540720 5613680
00:51:32 71222 8192000000 10863915840 11343953920 1911524560 18.919 98 21 42 0 1930755376 12826320 6404496
00:52:50 53762 8192000000 10862317808 11342741504 1909455744 18.902 98 13 25 0 1922186688 8709040 4021904
00:53:50 34482 8192000000 10853753264 11320565760 1866188960 18.553 96 39 78 1 1886155168 9119264 10846944
00:54:36 12356 8192000000 10880666000 11336421376 1937341264 19.126 100 29 56 1 1953822896 8399328 8082304
00:54:56 42518 8192000000 10874135808 11343626240 1913369472 18.934 98 37 74 0 1933991408 10295392 10326544
00:55:50 18308 8192000000 10893262384 11348135936 1951453344 19.238 100 35 70 1 1970307184 9427792 9426048
00:56:15 31518 8192000000 10890048416 11358388224 1944577664 19.183 99 38 76 1 1970376560 15637120 10161776
00:57:52 74830 8192000000 10919435040 11371950080 1952910928 19.250 99 25 49 1 1968463488 9151088 6401472
00:59:18 61051 8192000000 10897106544 11362181120 1864138304 18.537 94 20 40 0 1883661664 13972384 5550976
01:00:44 96802 8192000000 10916129520 11400249344 1910806016 18.913 97 12 24 0 1934300256 20403488 3090752
01:02:27 62726 8192000000 10910954240 11372126208 1938475520 19.135 98 15 30 1 1957054368 13998800 4580048
01:03:38 51760 8192000000 10924330928 11393163264 1986697328 19.518 100 38 77 2 2008837280 11479744 10660208
01:04:36 124448 8192000000 10903114928 11393335296 1949108256 19.219 98 15 30 2 1967963152 14497872 4357024
01:07:05 15690 8192000000 10912731408 11402756096 1986933888 19.520 100 16 32 1 2003360880 12137664 4289328
01:07:26 9386 8192000000 10906514672 11399049216 1983333456 19.491 100 5 10 0 1995960464 11381040 1245968
01:07:42 70743 8192000000 10910656112 11396726784 1972840992 19.408 99 28 56 0 1994068560 13351504 7876064
01:08:59 53791 8192000000 10924247344 11407699968 1992543024 19.564 100 9 18 0 2006394304 11182064 2669216
01:09:59 52956 8192000000 10883415504 11366027264 1917810944 18.969 96 12 24 0 1932823296 11172016 3840336
01:10:59 47104 8192000000 10897903152 11375382528 1942691360 19.168 98 19 38 2 1962435184 14059664 5684160
01:11:53 43997 8192000000 10883210608 11372437504 1934927520 19.106 98 16 32 2 1952824976 13213456 4684000
01:13:07 61373 8192000000 10891956496 11367686144 1914793792 18.945 97 10 20 2 1928869808 11479936 2596080
01:14:32 43636 8192000000 10913671952 11398176768 1941296384 19.157 98 21 42 1 1968435648 20588048 6551216
01:16:01 66003 8192000000 10907217696 11393789952 1949595632 19.223 99 15 30 0 1976236272 22425936 4214704
01:17:14 60587 8192000000 10907485024 11387072512 1915666352 18.952 97 17 34 1 1937595472 17304480 4624640
01:18:24 80708 8192000000 10875366992 11348582400 1848863168 18.413 94 10 20 0 1862583840 11180608 2540064
01:19:57 19143 8192000000 10902767792 11365314560 1963159792 19.331 100 43 86 2 1984962240 9063104 12739344
01:20:29 51302 8192000000 10864276256 11331203072 1884316688 18.700 96 40 80 5 1909370240 13470032 11583520
01:21:35 31682 8192000000 10887522272 11352252416 1926746224 19.041 99 26 52 1 1946487344 12517920 7223200
01:22:17 39453 8192000000 10892503360 11363520512 1931935488 19.082 99 29 58 0 1957315696 17071584 8308624
01:23:13 64160 8192000000 10862155344 11342098432 1889918096 18.745 97 19 38 3 1914264736 19108224 5238416
01:24:23 59336 8192000000 10861260560 11334283264 1907241376 18.884 98 21 43 1 1921101840 7929264 5931200
01:26:14 72432 8192000000 9926779408 10301874176 1058852208 11.445 54 11 20 1 1067112624 5813184 2447232

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 12-02-2021 01:29:06 to 12-02-2021 01:29:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 70 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          240402
MON$OLDEST_ACTIVE               240901
MON$OLDEST_SNAPSHOT             240901
MON$NEXT_TRANSACTION            240901
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                       2042464
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 ---
:237: 
:238: mscs-test-161.budzdorov.ru    Fri Feb 12 01:27:42 2021
:239:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:240: 
:241: 
:242: mscs-test-161.budzdorov.ru    Fri Feb 12 01:27:43 2021
:243:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:244: 
:245: 
:246: mscs-test-161.budzdorov.ru    Fri Feb 12 01:27:44 2021
:247:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:248: 
--- end of diff output ---

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

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