Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.11.2020 22:29
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 17668688 kB
MemAvailable 31527148 kB
Buffers 0 kB
Cached 14062476 kB
SwapCached 2868 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.7
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-02 22:26:57
DTS_END                         2020-11-02 22:26:57.8950
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/34266
TRN_ID                          235229
ATT_ID                          637
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: 9038.10 20489 1084572
customer order: creation 172.05 396 20646
customer order: refuse 13.81 376 1657
order to supplier: creation 44.76 1354 5371
order to supplier: removal 3.22 105274 386
invoice (draft): creation 45.89 3519 5507
invoice (draft): removal 51.02 841 6122
invoice accept: apply 41.83 17613 5020
invoice accept: cancel 46.08 830 5530
customer reserve: creation 3790.35 177 454842
customer reserve: removal 4536.73 58 544407
realization accept: apply 83.14 192 9977
realization accept: cancel 84.02 109 10082
payment from customer: creation 57.48 113 6898
payment from customer: removal 5.37 64 644
payment to supplier: creation 47.38 152 5685
payment to supplier: removal 3.13 84 375
service: total inventory turnovers 4.41 1097 529
service: total monetary turnovers 6.60 28 792
service: aggregate perf. data 0.82 23948 98
service: refresh index statistics 0.03 253562 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-11-2020 22:29:20 to 02-11-2020 22:29:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5247
TEST_TIME 2 4432
TEST_TIME 3 3473
TEST_TIME 4 3820
TEST_TIME 5 5627
TEST_TIME 6 5557
TEST_TIME 7 5750
TEST_TIME 8 5504
TEST_TIME 9 5430
TEST_TIME 10 5850
TEST_TIME 11 5950
TEST_TIME 12 6030
TEST_TIME 13 6162
TEST_TIME 14 6537
TEST_TIME 15 6686
TEST_TIME 16 7143
TEST_TIME 17 7151
TEST_TIME 18 7972
TEST_TIME 19 7967
TEST_TIME 20 7973
TEST_TIME 21 8008
TEST_TIME 22 8132
TEST_TIME 23 8658
TEST_TIME 24 8761
TEST_TIME 25 9064
TEST_TIME 26 9704
TEST_TIME 27 10387
TEST_TIME 28 10177
TEST_TIME 29 10267
TEST_TIME 30 10132
TEST_TIME 31 10181
TEST_TIME 32 10286
TEST_TIME 33 10156
TEST_TIME 34 9999
TEST_TIME 35 9969
TEST_TIME 36 9815
TEST_TIME 37 9632
TEST_TIME 38 9552
TEST_TIME 39 9551
TEST_TIME 40 9431
TEST_TIME 41 9485
TEST_TIME 42 9436
TEST_TIME 43 9327
TEST_TIME 44 9423
TEST_TIME 45 9360
TEST_TIME 46 9364
TEST_TIME 47 9244
TEST_TIME 48 9112
TEST_TIME 49 9209
TEST_TIME 50 9239
TEST_TIME 51 9134
TEST_TIME 52 9102
TEST_TIME 53 9052
TEST_TIME 54 8945
TEST_TIME 55 8897
TEST_TIME 56 8966
TEST_TIME 57 9176
TEST_TIME 58 9154
TEST_TIME 59 9200
TEST_TIME 60 9234
TEST_TIME 61 9261
TEST_TIME 62 9240
TEST_TIME 63 9329
TEST_TIME 64 9306
TEST_TIME 65 9274
TEST_TIME 66 9368
TEST_TIME 67 9443
TEST_TIME 68 9410
TEST_TIME 69 9452
TEST_TIME 70 9339
TEST_TIME 71 9294
TEST_TIME 72 9264
TEST_TIME 73 9264
TEST_TIME 74 9237
TEST_TIME 75 9176
TEST_TIME 76 9111
TEST_TIME 77 9055
TEST_TIME 78 9023
TEST_TIME 79 9073
TEST_TIME 80 9132
TEST_TIME 81 9176
TEST_TIME 82 9153
TEST_TIME 83 9174
TEST_TIME 84 9145
TEST_TIME 85 9182
TEST_TIME 86 9197
TEST_TIME 87 9256
TEST_TIME 88 9265
TEST_TIME 89 9276
TEST_TIME 90 9337
TEST_TIME 91 9383
TEST_TIME 92 9316
TEST_TIME 93 9253
TEST_TIME 94 9230
TEST_TIME 95 9202
TEST_TIME 96 9147
TEST_TIME 97 9118
TEST_TIME 98 9082
TEST_TIME 99 9149
TEST_TIME 100 9113
TEST_TIME 101 9101
TEST_TIME 102 9154
TEST_TIME 103 9131
TEST_TIME 104 9135
TEST_TIME 105 9171
TEST_TIME 106 9263
TEST_TIME 107 9224
TEST_TIME 108 9216
TEST_TIME 109 9284
TEST_TIME 110 9306
TEST_TIME 111 9264
TEST_TIME 112 9248
TEST_TIME 113 9218
TEST_TIME 114 9202
TEST_TIME 115 9218
TEST_TIME 116 9182
TEST_TIME 117 9139
TEST_TIME 118 9104
TEST_TIME 119 9074
TEST_TIME 120 9043

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-11-2020 22:29:24 to 02-11-2020 22:29:27.

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 1505777 1505777 0 0.00 0 30494 6 0 0
doc_list_biud 1505776 1505776 0 0.00 0 36035 27 0 0
sp_add_invoice_to_stock 5137 5020 117 2.27 25 190773 17614 0 117
sp_cancel_adding_invoice 5530 5530 0 0.00 4 72896 830 0 0
sp_cancel_client_order 1657 1657 0 0.00 3 15504 376 0 0
sp_cancel_customer_reserve 544407 544407 0 0.00 1 36037 58 0 0
sp_cancel_pay_from_customer 644 644 0 0.00 2 2269 65 0 0
sp_cancel_pay_to_supplier 375 375 0 0.00 3 3641 84 0 0
sp_cancel_supplier_invoice 6128 6122 6 0.09 1 30251 842 0 6
sp_cancel_supplier_order 386 386 0 0.00 6 1001309 105274 0 0
sp_cancel_write_off 10082 10082 0 0.00 1 15709 110 0 0
sp_client_order 20646 20646 0 0.00 3 26115 396 0 0
sp_customer_reserve 454842 454842 0 0.00 0 51785 178 0 0
sp_fill_shopping_cart 31518 31518 0 0.00 1 39290 40 0 0
sp_fill_shopping_cart_clo_res 454835 454835 0 0.00 0 13067 15 0 0
sp_get_clo_for_invoice 5013 5013 0 0.00 0 32795 294 0 0
sp_kill_cost_storno 16631 16631 0 0.00 0 11909 56 0 0
sp_kill_qstorno_ret_qs2qd 1105404 1105404 0 0.00 0 36028 32 0 0
sp_kill_qty_storno 583174 583174 0 0.00 0 36035 69 0 0
sp_lock_selected_doc 20570 20570 0 0.00 0 7515 6 0 0
sp_make_cost_storno 27573 27573 0 0.00 0 25000 55 0 0
sp_multiply_rows_for_pdistr 27573 27573 0 0.00 0 17949 30 0 0
sp_multiply_rows_for_qdistr 20646 20646 0 0.00 0 16071 176 0 0
sp_pay_from_customer 6898 6898 0 0.00 4 8633 113 0 0
sp_pay_to_supplier 5685 5685 0 0.00 4 18024 153 0 0
sp_payment_common 12583 12583 0 0.00 1 9098 33 0 0
sp_qd_handle_on_cancel_clo 1657 1657 0 0.00 0 15488 335 0 0
sp_qd_handle_on_invoice_upd_sts 10543 10543 0 0.00 0 35341 348 0 0
sp_qd_handle_on_reserve_upd_sts 9977 9977 0 0.00 0 24018 59 0 0
sp_reserve_write_off 9977 9977 0 0.00 6 26093 193 0 0
sp_supplier_invoice 5507 5507 0 0.00 6 110870 3519 0 0
sp_supplier_order 5371 5371 0 0.00 5 40793 1354 0 0
srv_aggregate_perf_data 98 98 0 0.00 2850 274124 23948 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 894 139374 33241 0 0
srv_find_qd_qs_mism 1037680 1037680 0 0.00 0 30486 5 0 0
srv_make_invnt_saldo 529 529 0 0.00 44 51133 1098 0 0
srv_make_money_saldo 792 792 0 0.00 0 2754 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 167094 352927 253563 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5021 5021 0 0.00 0 10521 185 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 2714 93 0 0
t$perf-norm:sp_cancel_client_order 1657 1657 0 0.00 0 3166 15 0 0
t$perf-norm:sp_cancel_customer_reserve 722 722 0 0.00 0 4639 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 644 644 0 0.00 0 4165 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 375 375 0 0.00 0 230 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 387 387 0 0.00 0 4850 48 0 0
t$perf-norm:sp_cancel_supplier_order 386 386 0 0.00 0 19739 1516 0 0
t$perf-norm:sp_cancel_write_off 1009 1009 0 0.00 0 8599 30 0 0
t$perf-norm:sp_client_order 20646 20646 0 0.00 0 22505 21 0 0
t$perf-norm:sp_customer_reserve 1014 1014 0 0.00 0 22473 27 0 0
t$perf-norm:sp_pay_from_customer 6898 6898 0 0.00 0 8655 17 0 0
t$perf-norm:sp_pay_to_supplier 5685 5685 0 0.00 0 4791 10 0 0
t$perf-norm:sp_reserve_write_off 9977 9977 0 0.00 0 7961 12 0 0
t$perf-norm:sp_supplier_invoice 5507 5507 0 0.00 0 6762 20 0 0
t$perf-norm:sp_supplier_order 5371 5371 0 0.00 0 3294 15 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 574 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 1307 9 0 0
t$perf-norm:srv_make_invnt_saldo 529 529 0 0.00 0 868 21 0 0
t$perf-norm:srv_make_money_saldo 792 792 0 0.00 0 1496 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 2 1 0 0
v_add_invoice_to_stock 10260 10026 234 2.28 0 6441 21 0 234
v_all_customers 37074 37074 0 0.00 0 21 1 0 0
v_all_suppliers 29712 29712 0 0.00 0 17 1 0 0
v_all_wares 41292 41292 0 0.00 0 68 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 3981 12 0 0
v_cancel_client_order 3314 3314 0 0.00 0 8705 15 0 0
v_cancel_customer_prepayment 1288 1288 0 0.00 0 853 4 0 0
v_cancel_customer_reserve 1444 1444 0 0.00 0 8804 12 0 0
v_cancel_payment_to_supplier 750 750 0 0.00 0 1482 7 0 0
v_cancel_supplier_invoice 786 774 12 1.52 0 2050 16 0 12
v_cancel_supplier_order 772 772 0 0.00 0 654 3 0 0
v_cancel_write_off 2018 2018 0 0.00 0 5015 24 0 0
v_max_id_clo_ord 5370 5370 0 0.00 0 1954 2 0 0
v_max_id_clo_res 1014 1014 0 0.00 0 2901 21 0 0
v_max_id_ord_sup 5502 5502 0 0.00 0 7354 7 0 0
v_max_non_paid_invoice 1701 1701 0 0.00 0 870 4 0 0
v_max_non_paid_realizn 3758 3758 0 0.00 0 2240 4 0 0
v_min_id_clo_ord 5370 5370 0 0.00 0 4029 5 0 0
v_min_id_clo_res 1014 1014 0 0.00 0 2271 13 0 0
v_min_id_ord_sup 5502 5502 0 0.00 0 4920 8 0 0
v_min_non_paid_invoice 5685 5685 0 0.00 0 8872 19 0 0
v_min_non_paid_realizn 6898 6898 0 0.00 0 7200 21 0 0
v_our_firm 10498 10498 0 0.00 0 18 1 0 0
v_reserve_write_off 19954 19954 0 0.00 0 9072 8 0 0
x_lock_depdocs_on_canc_invoice 11265 11265 0 0.00 0 18866 117 0 0
x_lock_depdocs_on_canc_sup_ord 386 386 0 0.00 0 9931 426 0 0
x_make_qstorno_1000_1200 5371 5371 0 0.00 2 40712 1277 0 0
x_make_qstorno_1200_2000 5507 5507 0 0.00 3 107663 3372 0 0
x_make_qstorno_2100_3300 454842 454842 0 0.00 0 51776 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-11-2020 22:29:28 to 02-11-2020 22:29:32.

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
19:57:01 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:08 25506 8192000000 10271658544 10583171072 846809872 9.368 64 57 116 0 868087184 2465616 18811696
19:57:46 30333 8192000000 10357597936 10679721984 1408018128 14.666 100 87 174 0 1441959376 5464784 28476464
19:58:27 25345 8192000000 10389529792 10716127232 1441840816 14.966 100 85 170 1 1476853840 6901344 28111680
19:58:59 27440 8192000000 10422403296 10752413696 1476173632 15.268 100 91 182 1 1512825024 7468800 29182592
19:59:36 20572 8192000000 10441799328 10775191552 1498417296 15.462 100 89 178 0 1534987088 8010672 28559120
20:00:06 14731 8192000000 10454851968 10790256640 1508593744 15.551 100 84 168 1 1543745232 8625376 26526112
20:00:42 13879 8192000000 10478952288 10817536000 1534629088 15.777 100 89 178 0 1576194992 13452112 28113792
20:01:05 21860 8192000000 10502909584 10847682560 1550315216 15.913 100 79 158 1 1584263856 9534512 24414128
20:01:35 10027 8192000000 10515108224 10866835456 1578796528 16.158 100 82 164 1 1614333472 10297264 25239680
20:01:52 12887 8192000000 10555158928 10908622848 1601529920 16.352 100 75 150 0 1634457680 10494272 22433488
20:02:14 4656 8192000000 10568446720 10925735936 1623937168 16.543 100 86 171 2 1665396448 15898320 25560960
20:02:31 14798 8192000000 10587994672 10949763072 1645017840 16.722 100 82 164 1 1680712704 11432272 24262592
20:02:54 13122 8192000000 10600857808 10969575424 1663331136 16.877 100 84 168 0 1701892544 12410400 26151008
20:03:16 10481 8192000000 10633699664 10996654080 1687543312 17.081 100 82 163 1 1723440016 12333408 23563296
20:03:35 8716 8192000000 10642426480 11012943872 1705104624 17.228 100 83 165 0 1741338544 12820528 23413392
20:03:53 8103 8192000000 10667934304 11038466048 1719074416 17.344 100 86 172 1 1757274288 13331760 24868112
20:04:08 6618 8192000000 10668991328 11044524032 1731617200 17.449 100 84 167 0 1768799280 13306864 23875216
20:04:22 4417 8192000000 10684906448 11062738944 1745247008 17.562 100 89 178 2 1784227248 13026992 25953248
20:04:34 6686 8192000000 10698265456 11076431872 1757675376 17.665 100 82 164 1 1793836176 13001728 23159072
20:04:49 6566 8192000000 10705418336 11081994240 1764446256 17.721 100 84 168 1 1801394720 12984256 23964208
20:05:02 4858 8192000000 10718153504 11100102656 1776083808 17.817 100 85 170 1 1813158288 13308112 23766368
20:05:14 3886 8192000000 10731524480 11108040704 1785773504 17.897 100 88 174 0 1825393712 14823792 24796416
20:05:25 4528 8192000000 10729683872 11108724736 1792397680 17.951 100 81 162 0 1829551696 14475056 22678960
20:05:36 2842 8192000000 10739658416 11119337472 1794611168 17.970 100 87 173 0 1834034496 15803296 23620032
20:05:46 2839 8192000000 10746046592 11125563392 1802823344 18.037 100 85 169 0 1841111216 15248816 23039056
20:05:55 2828 8192000000 10747379600 11130347520 1808453168 18.083 100 88 173 0 1847261472 14810992 23997312
20:06:05 3178 8192000000 10754952256 11137937408 1813483952 18.124 100 86 171 0 1851312256 14542288 23286016
20:06:14 3368 8192000000 10755863264 11141996544 1817394848 18.156 100 87 174 1 1856452000 15061520 23995632
20:06:24 5162 8192000000 10765456400 11147403264 1819516272 18.174 100 86 173 1 1857925312 15037568 23371472
20:06:37 2021 8192000000 10769982448 11156389888 1829417312 18.255 100 87 174 0 1868778704 14966256 24395136
20:06:46 1986 8192000000 10783858176 11168403456 1838240736 18.326 100 90 178 0 1877329440 14427392 24661312
20:06:54 2474 8192000000 10788586432 11174567936 1844159456 18.375 100 88 175 1 1881536592 13152112 24225024
20:07:03 1865 8192000000 10792939744 11178905600 1851218560 18.432 100 89 177 0 1888602992 12900832 24483600
20:07:11 1688 8192000000 10789524096 11179950080 1853419088 18.450 100 92 181 2 1892715248 13996704 25299456
20:07:19 1396 8192000000 10800267952 11188527104 1857287488 18.481 100 91 185 3 1894837472 12160560 25389424
20:07:26 1259 8192000000 10803908288 11190394880 1856809024 18.477 100 93 187 1 1897248144 14007728 26431392
20:07:35 1447 8192000000 10807384944 11194814464 1859500096 18.499 100 93 187 2 1898294592 12587280 26207216
20:07:42 2299 8192000000 10792384656 11194155008 1860320400 18.506 100 79 160 1 1896578688 13181504 23076784
20:07:51 31518 8192000000 10796044704 11192123392 1860084000 18.504 100 59 118 1 1886819440 10036672 16698768
20:08:29 1485 8192000000 10814289536 11202043904 1866381472 18.555 100 90 180 1 1902140288 10571696 25187120
20:08:37 4028 8192000000 10783198752 11197562880 1861958672 18.519 100 44 88 0 1884905376 10529440 12417264
20:08:47 3138 8192000000 10808535744 11205365760 1869314672 18.579 100 54 109 0 1892509088 7550192 15644224
20:08:57 3829 8192000000 10794096496 11205636096 1874813664 18.623 100 58 116 1 1900870944 9463920 16593360
20:09:09 4215 8192000000 10794776272 11207647232 1872147024 18.602 100 44 88 1 1893995232 9402240 12445968
20:09:21 10416 8192000000 10799042928 11214209024 1876845552 18.640 100 37 75 0 1893504464 5545376 11113536
20:09:38 45578 8192000000 10814539280 11217702912 1879232896 18.659 100 58 117 1 1902595472 5984208 17378368
20:10:30 10039 8192000000 10792403872 11219124224 1877331920 18.644 100 36 72 1 1895082480 8064192 9686368
20:10:47 6879 8192000000 10801183152 11222323200 1877343376 18.644 100 27 54 0 1896610992 11539424 7728192
20:11:01 7361 8192000000 10803350992 11220000768 1880931472 18.673 100 31 63 2 1896565904 6660096 8974336
20:11:15 10346 8192000000 10793281536 11223408640 1884741072 18.703 100 27 54 2 1903296480 10680336 7875072
20:11:31 6757 8192000000 10799003184 11229642752 1886392112 18.717 100 18 34 3 1897646272 5911456 5342704
20:11:49 8580 8192000000 10798340736 11229261824 1888828688 18.736 100 25 50 2 1901746160 5850368 7067104
20:12:09 9051 8192000000 10802582576 11234242560 1890177152 18.747 100 23 44 3 1903374160 6682368 6514640
20:12:27 11285 8192000000 10797222304 11234889728 1891271216 18.756 100 15 30 0 1905618256 10523856 3823184
20:12:48 10465 8192000000 10816700752 11243393024 1893607696 18.775 100 17 34 1 1908810528 9770720 5432112
20:13:05 3587 8192000000 10819622768 11245289472 1901410176 18.838 100 38 75 3 1918888608 5043616 12434816
20:13:21 9002 8192000000 10804179040 11243315200 1898268160 18.812 100 21 43 0 1918796384 15002368 5525856
20:13:36 9651 8192000000 10800140000 11242061824 1898341232 18.813 100 20 40 2 1910582672 6391488 5849952
20:13:54 16085 8192000000 10816954032 11240325120 1888695680 18.735 99 31 65 0 1903599152 5438464 9465008
20:14:57 23019 8192000000 10813869456 11251834880 1902089216 18.843 100 21 42 0 1913429792 4917776 6422800
20:15:27 17128 8192000000 10818921360 11261272064 1910360944 18.910 100 18 36 0 1921668528 6392368 4915216
20:15:53 4132 8192000000 10825313456 11258507264 1909597136 18.903 100 37 73 2 1928483840 8332048 10554656
20:16:03 5619 8192000000 10817424544 11253481472 1893854144 18.777 99 29 58 1 1907587648 5250928 8482576
20:16:14 9139 8192000000 10799994352 11238940672 1886630944 18.719 99 17 34 2 1897942336 6374096 4937296
20:16:30 9706 8192000000 10826510336 11259199488 1910394848 18.910 100 30 60 0 1926114832 6607472 9112512
20:16:46 6418 8192000000 10818282320 11252105216 1892633968 18.767 99 26 52 0 1906473504 5872416 7967120
20:17:01 12109 8192000000 10800196992 11231330304 1811146272 18.105 95 18 36 3 1821837104 5501040 5189792
20:17:19 9794 8192000000 10788928512 11224268800 1848573424 18.411 98 19 38 0 1860008864 6235408 5200032
20:17:41 5123 8192000000 10802899824 11232530432 1881357712 18.676 100 33 66 1 1897699616 7038432 9303472
20:17:52 7362 8192000000 10790614848 11219513344 1850389776 18.425 98 21 42 1 1861961824 5723456 5848592
20:18:06 4931 8192000000 10769157920 11194732544 1812623072 18.117 97 24 48 2 1825238912 5997488 6618352
20:18:17 8070 8192000000 10737007888 11166674944 1786875184 17.906 97 15 30 0 1796242800 5376304 3991312
20:18:35 14203 8192000000 10720178464 11143254016 1710768880 17.275 93 16 32 0 1720283408 5147152 4367376
20:18:58 63579 8192000000 10709285136 11136618496 1763106048 17.710 97 38 75 0 1779841344 5208224 11527072
20:20:10 10672 8192000000 10695065200 11111854080 1713576848 17.299 95 34 68 2 1730240656 6586608 10077200
20:20:31 7767 8192000000 10728264432 11139866624 1802197344 18.032 100 36 72 1 1820081072 7916048 9967680
20:20:47 2768 8192000000 10724703728 11135152128 1777209024 17.826 98 44 88 0 1797175600 7687536 12279040
20:20:58 8312 8192000000 10697154784 11120631808 1749236016 17.595 97 24 48 2 1762479008 5620576 7622416
20:21:17 4688 8192000000 10686845504 11096731648 1737620224 17.499 97 26 50 0 1750130656 5337424 7173008
20:21:28 5655 8192000000 10691881488 11107979264 1750337360 17.604 98 23 47 1 1762863472 5629744 6896368
20:21:44 9233 8192000000 10718183008 11139796992 1789307936 17.926 99 28 55 5 1802273296 4887280 8078080
20:22:01 10685 8192000000 10722444752 11138830336 1747395440 17.580 96 25 50 2 1760260848 5386880 7478528
20:22:20 8480 8192000000 10723304320 11144122368 1794394960 17.968 99 22 44 4 1806108304 5668416 6044928
20:22:35 9338 8192000000 10742703584 11159531520 1824964048 18.218 100 30 61 1 1840638784 5811664 9863072
20:22:54 10255 8192000000 10739531952 11169521664 1837318240 18.319 100 27 52 1 1850650992 5639440 7693312
20:23:11 9878 8192000000 10746506608 11174445056 1835661184 18.305 100 15 29 1 1845566752 5532176 4373392
20:23:33 57706 8192000000 10756837344 11182211072 1844276352 18.376 100 37 74 1 1861572496 6008368 11287776
20:24:37 16918 8192000000 10744811248 11179712512 1838075552 18.325 100 13 26 0 1846846448 4997728 3773168
20:25:00 3413 8192000000 10757891664 11186221056 1847674512 18.403 100 27 54 2 1861528464 6200432 7653520
20:25:13 6435 8192000000 10767159168 11191058432 1852029424 18.439 100 34 68 2 1869123424 7701760 9392240
20:25:32 7211 8192000000 10788214640 11201327104 1862001488 18.520 100 45 90 0 1882313744 7431488 12880768
20:25:46 7766 8192000000 10774441120 11202650112 1858641584 18.492 100 23 46 0 1871377712 6119200 6616928
20:26:00 9138 8192000000 10772452704 11205677056 1862910832 18.527 100 20 40 0 1874420528 5643104 5866592
20:26:19 7042 8192000000 10783706208 11210178560 1869926656 18.584 100 27 52 3 1883623264 5912000 7784608
20:26:33 13152 8192000000 10778013984 11205685248 1851793104 18.437 99 25 49 2 1865065200 6025792 7246304
20:26:53 9391 8192000000 10800696288 11219103744 1866196032 18.553 100 20 38 1 1877930336 5845136 5889168
20:27:11 894 8192000000 10845163984 11243229184 1900568928 18.831 100 80 160 2 1928697792 5352848 22776016
20:27:20 15269 8192000000 10834651952 11248197632 1900799104 18.833 100 43 85 1 1919583584 7335648 11448832
20:27:44 32969 8192000000 10848722336 11269406720 1921932096 19.002 100 55 110 3 1946108672 8621584 15554992
20:28:25 95202 8192000000 10853814368 11285352448 1930941936 19.074 100 45 90 3 1955082752 10544144 13596672
20:30:09 26956 8192000000 10857044976 11290427392 1930754736 19.073 100 22 44 0 1947338512 10091920 6491856
20:30:42 20345 8192000000 10875456752 11302981632 1942044448 19.163 100 48 95 0 1970992464 14752960 14195056
20:31:28 2854 8192000000 10894625296 11315732480 1950282720 19.229 100 64 129 0 1984978624 16129104 18566800
20:31:39 3773 8192000000 10884100960 11305840640 1932353664 19.086 99 61 122 1 1964498848 15056768 17088416
20:31:50 5277 8192000000 10888866464 11307008000 1945405264 19.190 100 71 139 2 1980186688 15184048 19597376
20:32:02 18979 8192000000 10890128400 11312517120 1951537584 19.239 100 64 128 0 1986855280 16344528 18973168
20:32:37 5554 8192000000 10904808384 11327037440 1960793744 19.312 100 62 120 0 1995779888 17428320 17557824
20:32:53 32822 8192000000 10906011008 11334959104 1963848688 19.337 100 45 90 0 1995225456 17768512 13608256
20:33:34 14366 8192000000 10902516032 11336671232 1970127504 19.386 100 42 84 1 2000927936 18751776 12048656
20:34:00 4793 8192000000 10915647728 11347927040 1972249840 19.403 100 55 108 3 2009008688 21207024 15551824
20:34:21 12537 8192000000 10927947152 11354296320 1976240272 19.435 100 53 106 1 2010020352 18320992 15459088
20:34:51 9237 8192000000 10920758192 11357761536 1980577600 19.469 100 44 87 2 2015602448 22041696 12983152
20:35:11 5975 8192000000 10946263712 11371601920 1989542784 19.540 100 68 136 0 2033961664 24385280 20033600
20:35:25 21197 8192000000 10942931776 11374538752 1991359632 19.555 100 62 125 3 2038715200 29539680 17815888
20:35:54 5698 8192000000 10957540032 11386359808 1996737584 19.597 100 67 132 3 2050230176 33686256 19806336
20:36:07 5756 8192000000 10955956112 11383656448 1997121664 19.600 100 63 125 1 2045808016 30105824 18580528
20:36:21 8670 8192000000 10941849520 11370639360 1959653616 19.303 98 58 114 1 2008436320 31378128 17404576
20:36:42 5197 8192000000 10952576656 11380105216 1992183808 19.561 100 59 113 2 2036060432 27352176 16524448
20:36:56 4487 8192000000 10950829616 11378032640 1993924496 19.575 100 66 127 2 2041034736 28119504 18990736
20:37:17 5048 8192000000 10930336928 11357822976 1951902752 19.242 98 61 120 0 1998897696 29122192 17872752
20:37:30 6409 8192000000 10951379232 11374198784 1986320032 19.515 100 62 123 2 2037863360 33140320 18403008
20:37:45 6043 8192000000 10954856560 11387891712 1996994400 19.599 100 61 121 2 2048713984 32593280 19126304
20:37:59 4015 8192000000 10972633600 11397279744 2006433440 19.673 100 69 137 1 2058451984 31017728 21000816
20:38:14 11172 8192000000 10968836720 11393732608 1986174736 19.514 99 57 114 0 2034472000 31200768 17096496
20:38:37 3335 8192000000 10998156000 11410874368 2014097536 19.734 100 79 159 1 2077387504 38434672 24855296
20:38:47 3885 8192000000 10985761696 11414085632 2016781440 19.755 100 71 143 1 2077055728 38953232 21321056
20:38:59 5489 8192000000 10964026352 11393667072 1992963408 19.567 99 59 118 0 2049168816 37524640 18680768
20:39:10 2415 8192000000 10958024352 11383156736 1988953472 19.536 99 60 120 1 2046399776 38179264 19267040
20:39:21 7741 8192000000 10983718256 11408986112 2003288576 19.649 100 64 126 0 2059830944 37338736 19203632
20:39:36 2363 8192000000 11004413264 11417460736 2017730048 19.762 100 88 177 3 2083694896 38846208 27118640
20:39:47 4712 8192000000 10950033776 11374256128 1968436640 19.373 98 64 128 0 2026439232 38279632 19722960
20:40:01 2238 8192000000 10987479760 11399577600 1983475952 19.492 99 79 158 3 2048005168 40854960 23674256
20:40:10 4250 8192000000 10969754960 11389353984 1986278016 19.514 99 83 163 0 2051633872 39862768 25493088
20:40:23 3136 8192000000 10985215760 11398205440 2001218176 19.632 100 83 164 1 2067665792 40985280 25462336
20:40:34 3409 8192000000 10986569008 11403661312 2003712304 19.652 100 83 164 2 2070399760 41493072 25194384
20:40:45 4186 8192000000 10970883936 11390406656 1984528416 19.501 99 73 146 1 2050076016 42874608 22672992
20:40:57 8070 8192000000 10959622944 11387748352 1971216528 19.395 99 64 126 2 2033469920 42696256 19557136
20:41:14 3005 8192000000 10965797360 11391311872 1986228720 19.514 100 73 145 3 2048922384 40974368 21719296
20:41:24 5819 8192000000 10967087456 11389001728 1974533200 19.421 99 74 147 3 2038016528 41398160 22085168
20:41:37 8152 8192000000 10956294976 11382173696 1968571472 19.374 99 68 136 2 2031913600 42972560 20369568
20:41:54 4773 8192000000 10940773264 11353894912 1938101872 19.132 98 79 157 0 2007682352 45341232 24239248
20:42:06 4467 8192000000 10943553616 11355578368 1954835280 19.265 100 78 155 1 2026005360 47000880 24169200
20:42:17 2001 8192000000 10936357792 11339702272 1930864656 19.074 98 83 164 2 2004613296 48096688 25651952
20:42:26 3919 8192000000 10933763968 11352223744 1942776992 19.169 99 75 150 1 2011535728 45363264 23395472
20:42:36 2483 8192000000 10938173472 11348918272 1952424640 19.246 100 88 175 0 2024282800 43878864 27979296
20:42:46 2969 8192000000 10932508640 11351826432 1938455872 19.134 99 71 142 1 2005160944 44682704 22022368
20:42:56 6094 8192000000 10936064624 11344506880 1946406800 19.198 100 82 161 1 2018606944 46760640 25439504
20:43:09 2794 8192000000 10946079456 11352113152 1950941872 19.234 100 83 166 2 2022258080 46476768 24839440
20:43:22 4052 8192000000 10939327696 11347181568 1943348304 19.173 99 86 166 1 2015165280 46669904 25147072
20:43:33 2744 8192000000 10913366784 11318157312 1902913696 18.850 97 85 169 1 1977727776 47738032 27076048
20:43:42 5120 8192000000 10950514368 11355226112 1947242864 19.205 100 82 161 3 2021937040 50488832 24205344
20:43:55 2699 8192000000 10957766240 11366731776 1958695648 19.296 100 85 170 0 2037007408 52231760 26080000
20:44:04 1437 8192000000 10961804816 11371495424 1963235824 19.332 100 87 175 0 2044477904 54257792 26984288
20:44:14 4276 8192000000 10942393072 11354214400 1954112576 19.259 100 79 156 2 2033406624 53905552 25388496
20:44:25 7685 8192000000 10929367984 11360882688 1957048192 19.283 100 53 106 0 2022022688 47526544 17447952
20:44:41 12030 8192000000 10915741856 11353559040 1941690768 19.160 99 52 104 0 2000650032 42299072 16660192
20:45:01 9999 8192000000 10911668800 11342843904 1917261104 18.965 98 42 84 1 1973657936 43218480 13178352
20:45:23 20438 8192000000 10918997776 11342647296 1911417664 18.918 98 39 78 1 1965871456 42134560 12319232
20:45:51 1963 8192000000 10927418608 11345932288 1931286960 19.077 99 68 133 1 1997031776 44054016 21690800
20:46:00 7553 8192000000 10926117200 11348930560 1950495296 19.230 100 53 107 2 2009825040 43240416 16089328
20:46:17 4579 8192000000 10927459680 11356528640 1955815712 19.273 100 45 91 0 2015729056 44852928 15060416
20:46:28 4450 8192000000 10926984256 11349397504 1946855472 19.201 100 50 98 1 2008139488 46116368 15167648
20:46:39 8990 8192000000 10931847280 11359805440 1951145472 19.236 100 49 98 2 2013903520 47186176 15571872
20:47:01 13286 8192000000 10913926448 11337744384 1892481696 18.766 97 45 90 1 1955103344 47994512 14627136
20:47:22 10599 8192000000 10915792928 11353718784 1936096016 19.116 100 33 66 0 1999488432 52222624 11169792
20:47:39 15732 8192000000 10917618096 11357863936 1934869024 19.106 100 34 68 1 2002894912 56315856 11710032
20:48:07 10933 8192000000 10931357728 11365888000 1945494016 19.191 100 37 71 0 2013873152 55628544 12750592
20:48:27 4161 8192000000 10941352704 11365617664 1946072176 19.195 100 58 116 0 2023903168 58401776 19429216
20:48:41 6268 8192000000 10933561408 11369594880 1950628368 19.231 100 37 74 0 2021610336 58203168 12778800
20:48:59 11543 8192000000 10929760752 11370557440 1930583072 19.072 99 34 66 1 2000313952 58504960 11225920
20:49:18 21756 8192000000 10916740400 11358044160 1942021424 19.163 100 29 58 1 1998653536 46481968 10150144
20:49:56 20179 8192000000 10916054704 11356913664 1938606304 19.136 100 30 60 3 1997680096 48676832 10396960
20:51:27 14455 8192000000 10913442272 11358830592 1920646880 18.992 99 23 46 0 1984270848 54276384 9347584
20:51:51 12414 8192000000 10913270608 11361857536 1929257776 19.061 100 33 64 3 1993288304 53080592 10949936
20:52:11 26379 8192000000 10882524960 11350700032 1929665440 19.064 100 33 66 0 1981435904 40604096 11166368
20:52:43 41204 8192000000 10878999968 11342147584 1913644192 18.936 99 17 34 1 1958460560 38638608 6177760
20:53:31 55794 8192000000 10896991008 11341139968 1946035312 19.195 100 23 46 2 1969141744 16551984 6554448
20:54:36 23450 8192000000 10878138928 11323875328 1894644064 18.783 97 33 66 0 1918267920 13820192 9803664
20:55:17 17800 8192000000 10893773808 11355447296 1945594000 19.191 100 16 32 2 1969061344 18801984 4665360
20:55:41 3022 8192000000 10892259184 11346157568 1956666560 19.280 100 21 42 3 1978644688 15777536 6200592
20:55:51 4583 8192000000 10887636560 11347439616 1953738864 19.256 100 11 22 1 1974520608 16895312 3886432
20:56:02 96861 8192000000 10890100896 11358621696 1934841360 19.106 99 22 44 1 1961983824 21080176 6062288
20:57:45 59211 8192000000 10894101552 11346964480 1955663920 19.272 100 22 42 2 1972699664 11375856 5659888
20:58:51 86937 8192000000 10890754992 11355475968 1946185312 19.196 99 20 40 0 1959726912 7991360 5550240
21:00:24 75840 8192000000 10889987392 11360522240 1940984416 19.155 98 21 42 0 1957286720 10057760 6244544
21:02:53 104666 8192000000 10896938064 11360153600 1968252560 19.372 100 31 61 2 1993168304 15794336 9121408
21:04:45 8624 8192000000 10896272976 11351875584 1949737760 19.224 99 37 74 0 1981558560 20321168 11499632
21:05:00 14368 8192000000 10870026704 11339030528 1951469200 19.238 100 12 24 1 1965178800 10623360 3086240
21:05:26 30218 8192000000 10886639088 11349942272 1943607280 19.176 99 11 22 0 1957414960 10420640 3387040
21:06:06 36846 8192000000 10901319680 11341234176 1952244864 19.244 99 34 69 0 1971782448 9599472 9938112
21:06:51 49616 8192000000 10913751632 11366297600 1979061328 19.457 100 31 62 0 2000480816 12580160 8839328
21:07:54 55129 8192000000 10888005840 11366473728 1972458848 19.405 100 14 28 2 1989080832 12181024 4440960
21:08:55 48737 8192000000 10893441584 11347763200 1913902480 18.938 97 20 40 1 1931975184 12356736 5715968
21:09:55 43585 8192000000 10867604176 11346563072 1937126496 19.124 99 16 32 0 1957469680 15346864 4996320
21:11:02 39369 8192000000 10880761824 11349532672 1956202960 19.276 100 10 20 0 1967734480 8475072 3056448
21:11:47 41766 8192000000 10873569888 11330019328 1945603760 19.191 99 12 24 0 1959203120 9633168 3966192
21:12:45 63523 8192000000 10910474464 11358593024 1971368192 19.396 100 20 43 0 1991422336 14044464 6009680
21:14:02 72546 8192000000 10918003456 11364974592 1974444448 19.421 100 39 77 1 2001522336 15877504 11200384
21:15:25 75654 8192000000 10892250464 11370094592 1977566912 19.445 100 22 44 0 2002298800 18406032 6325856
21:16:47 34637 8192000000 10880450320 11334778880 1913824624 18.937 97 19 37 0 1929468432 10740352 4903456
21:17:31 44997 8192000000 10861361952 11327250432 1865752256 18.550 95 20 39 2 1883834352 12443936 5638160
21:18:51 88633 8192000000 10896302384 11364941824 1948314176 19.213 99 22 43 0 1971259408 16482688 6462544
21:20:26 94518 8192000000 10915200816 11389886464 1980821568 19.471 100 17 34 2 2003131840 17617744 4692528
21:22:07 51416 8192000000 10920659040 11394490368 1979842880 19.463 100 18 36 1 2008855168 23979168 5033120
21:23:05 78669 8192000000 10919018768 11387809792 1942770384 19.169 98 24 48 1 1971060848 21140960 7149504
21:24:31 78722 8192000000 10902072896 11359047680 1871430224 18.596 94 14 28 1 1888168032 12495696 4242112
21:25:57 21073 8192000000 10892003952 11346432000 1949330384 19.221 99 31 62 3 1968609392 10663904 8615104
21:26:33 44310 8192000000 10883877904 11345813504 1891454784 18.758 96 18 36 0 1905860400 9835488 4570128
21:27:23 40201 8192000000 10882521104 11342807040 1921433504 18.998 98 28 55 2 1937180304 8827504 6919296
21:28:18 25440 8192000000 10912350320 11368574976 1952314400 19.245 99 29 58 1 1972836960 12744752 7777808
21:28:55 69539 8192000000 10883752528 11360284672 1938573024 19.135 98 28 57 1 1957344912 11407856 7364032
21:30:13 57442 8192000000 10922386752 11369623552 1939139968 19.140 98 24 48 1 1956296656 10498544 6658144
21:31:18 63204 8192000000 10910685840 11379298304 1922791600 19.009 97 35 70 0 1944582704 12436288 9354816
21:32:30 82116 8192000000 10895344704 11365785600 1930175904 19.068 98 8 16 0 1949085376 16299168 2610304
21:33:59 75602 8192000000 10905313152 11368484864 1916989072 18.963 97 15 30 0 1938604800 17789616 3826112
21:35:22 66523 8192000000 10874696064 11339771904 1901720800 18.840 97 13 26 0 1921631056 16432176 3478080
21:36:58 133961 8192000000 10891598048 11352977408 1927271424 19.045 98 27 54 0 1943713040 9315536 7126080
21:39:18 42415 8192000000 10876759504 11347742720 1928743456 19.057 98 21 41 0 1944862704 10349104 5770144
21:40:10 36551 8192000000 10867906304 11335032832 1885590208 18.710 96 11 18 2 1894728576 6534496 2603872
21:40:53 35272 8192000000 10843835824 11309359104 1872590832 18.605 96 11 22 0 1884337520 8581440 3165248
21:41:37 76812 8192000000 10863557664 11318530048 1893397888 18.773 98 14 27 1 1910268720 12149152 4721680
21:43:00 61602 8192000000 10860771136 11317927936 1887179296 18.723 97 15 30 1 1909317680 17179536 4958848
21:44:29 67559 8192000000 10874829920 11347836928 1944506736 19.183 100 17 34 1 1968427808 18938752 4982320
21:47:11 88031 8192000000 10866957600 11325054976 1866513888 18.556 96 16 32 1 1880657792 9669152 4474752
21:48:45 35344 8192000000 10858444224 11312357376 1876377776 18.636 97 19 37 1 1893331520 11313200 5640544
21:49:27 38720 8192000000 10865744112 11322298368 1915042912 18.947 99 24 48 1 1934836896 12905152 6888832
21:50:18 53112 8192000000 10873962624 11339526144 1939726656 19.145 100 28 56 0 1962356576 14559520 8070400
21:51:26 40211 8192000000 10880076928 11334754304 1892825952 18.769 97 28 56 1 1914860832 14846096 7188784
21:52:19 92141 8192000000 10869039648 11327434752 1872982336 18.608 97 16 32 2 1895848848 18482624 4383888
21:53:59 33140 8192000000 10877128144 11325755392 1922057296 19.003 99 40 80 0 1947584656 14630208 10897152
21:54:46 40844 8192000000 10890597888 11336048640 1930204416 19.069 99 41 84 1 1953672432 11824192 11643824
21:55:36 27584 8192000000 10875050336 11325026304 1890586768 18.751 97 35 70 1 1913535376 13393232 9555376
21:56:11 87017 8192000000 10874883088 11353305088 1908897936 18.898 99 14 28 0 1935225184 22177456 4149792
21:57:51 104963 8192000000 10871623904 11335901184 1894725072 18.784 97 13 26 0 1912263184 14491440 3046672
21:59:49 49431 8192000000 10891889600 11338248192 1934456912 19.102 99 37 74 1 1954176736 9289936 10429888
22:00:46 51616 8192000000 10890677968 11358584832 1960992800 19.314 100 21 41 3 1977585216 10784592 5807824
22:01:49 74761 8192000000 10880073904 11355672576 1963563968 19.334 100 7 14 0 1976451056 11084736 1802352
22:03:10 29990 8192000000 10899703424 11367419904 1967504368 19.366 100 10 20 0 1982717248 12320608 2892272
22:04:15 63996 8192000000 10900749408 11366174720 1930698816 19.072 98 13 26 0 1947122656 11736832 4687008
22:05:56 31966 8192000000 10902762304 11363753984 1949363760 19.221 99 22 40 3 1962816032 7650256 5802016
22:06:57 69738 8192000000 10886256112 11345215488 1898510288 18.814 96 18 36 1 1914293200 10012832 5770080
22:08:13 88260 8192000000 10901067376 11370672128 1944202528 19.180 99 15 31 0 1959961536 11405280 4353728
22:09:49 56000 8192000000 10915979696 11379146752 1959288544 19.300 99 30 59 4 1982863680 14997808 8577328
22:10:54 75974 8192000000 10905652272 11382280192 1922570480 19.007 97 17 34 0 1945213824 17750976 4892368
22:12:18 59685 8192000000 10897047600 11360063488 1963099952 19.331 100 4 8 1 1980094384 15997072 997360
22:13:24 28804 8192000000 10920624336 11371442176 1957231776 19.284 99 25 50 0 1972139280 8006480 6901024
22:13:59 83679 8192000000 10906009504 11381694464 1974743088 19.423 100 20 40 1 1992140848 11782016 5615744
22:15:30 90465 8192000000 10886757344 11362074624 1879444832 18.661 95 9 18 0 1894796192 12787120 2564240
22:17:17 139374 8192000000 10865939600 11335348224 1863848240 18.534 95 23 46 0 1884999696 14584592 6566864
22:19:46 61882 8192000000 10873108896 11346489344 1911313632 18.917 98 19 38 0 1927487360 11284416 4889312
22:21:29 74092 8192000000 10852902768 11332599808 1873880320 18.616 96 5 10 0 1884986032 10079216 1026496
22:22:49 20359 8192000000 10861486704 11345858560 1942858336 19.170 100 6 12 0 1956225456 11923088 1444032
22:23:16 24297 8192000000 10864236624 11339935744 1942669872 19.168 100 6 12 0 1954287408 9959088 1658448
22:23:46 29078 8192000000 10870284256 11342372864 1947909488 19.210 100 8 16 2 1961476912 11052432 2514992
22:24:22 57466 8192000000 10873596192 11341967360 1938346304 19.134 99 12 23 0 1947666048 5967856 3351888
22:25:25 56063 8192000000 10867265648 11336572928 1922683088 19.008 98 26 52 1 1937987952 7693792 7611072
22:26:31 37978 8192000000 9719037136 10061795328 857846896 9.479 44 9 18 0 868270240 8166144 2257200

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 02-11-2020 22:29:34 to 02-11-2020 22:30:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 117 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-11-2020 22:30:06 to 02-11-2020 22:30:08.

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          236471
MON$OLDEST_ACTIVE               236984
MON$OLDEST_SNAPSHOT             236984
MON$NEXT_TRANSACTION            236984
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                       2010368
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33383 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33383 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33383 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33383 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 ---
:246: 
:247: mscs-test-161.budzdorov.ru    Mon Nov  2 22:27:36 2020
:248:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:249: 
:250: 
:251: mscs-test-161.budzdorov.ru    Mon Nov  2 22:27:36 2020
:252:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:253: 
:254: 
:255: mscs-test-161.budzdorov.ru    Mon Nov  2 22:27:36 2020
:256:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:257: 
:258: 
:259: mscs-test-161.budzdorov.ru    Mon Nov  2 22:27:36 2020
:260:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:261: 
:262: 
:263: mscs-test-161.budzdorov.ru    Mon Nov  2 22:27:36 2020
:264:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:265: 
--- end of diff output ---

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

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