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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17507096 kB
MemAvailable 31456336 kB
Buffers 0 kB
Cached 14139232 kB
SwapCached 0 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-03-30 01:27:24
DTS_END                         2021-03-30 01:27:24.0580
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/57586
TRN_ID                          241428
ATT_ID                          650
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: 9270.80 23412 1112496
customer order: creation 176.88 400 21225
customer order: refuse 14.91 341 1789
order to supplier: creation 46.28 1402 5553
order to supplier: removal 3.48 105521 417
invoice (draft): creation 45.86 3284 5503
invoice (draft): removal 52.48 770 6298
invoice accept: apply 41.63 17793 4995
invoice accept: cancel 47.56 811 5707
customer reserve: creation 3840.23 175 460828
customer reserve: removal 4697.86 62 563743
realization accept: apply 84.74 186 10169
realization accept: cancel 86.69 109 10403
payment from customer: creation 60.76 113 7291
payment from customer: removal 5.53 69 663
payment to supplier: creation 50.08 129 6010
payment to supplier: removal 3.43 87 412
service: total inventory turnovers 5.01 1155 601
service: total monetary turnovers 6.61 32 793
service: aggregate perf. data 0.77 22552 92
service: refresh index statistics 0.03 313257 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-03-2021 01:28:17 to 30-03-2021 01:28:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4061
TEST_TIME 2 4774
TEST_TIME 3 4143
TEST_TIME 4 5260
TEST_TIME 5 4779
TEST_TIME 6 4580
TEST_TIME 7 4862
TEST_TIME 8 5314
TEST_TIME 9 5625
TEST_TIME 10 6028
TEST_TIME 11 6046
TEST_TIME 12 6038
TEST_TIME 13 5996
TEST_TIME 14 6212
TEST_TIME 15 6686
TEST_TIME 16 6681
TEST_TIME 17 6908
TEST_TIME 18 7415
TEST_TIME 19 7213
TEST_TIME 20 7693
TEST_TIME 21 7658
TEST_TIME 22 7926
TEST_TIME 23 8566
TEST_TIME 24 9240
TEST_TIME 25 9146
TEST_TIME 26 10082
TEST_TIME 27 11257
TEST_TIME 28 10941
TEST_TIME 29 10769
TEST_TIME 30 10653
TEST_TIME 31 10561
TEST_TIME 32 10438
TEST_TIME 33 10287
TEST_TIME 34 10179
TEST_TIME 35 10202
TEST_TIME 36 10096
TEST_TIME 37 10037
TEST_TIME 38 9806
TEST_TIME 39 9765
TEST_TIME 40 9754
TEST_TIME 41 9695
TEST_TIME 42 9559
TEST_TIME 43 9485
TEST_TIME 44 9359
TEST_TIME 45 9318
TEST_TIME 46 9429
TEST_TIME 47 9327
TEST_TIME 48 9261
TEST_TIME 49 9391
TEST_TIME 50 9497
TEST_TIME 51 9556
TEST_TIME 52 9549
TEST_TIME 53 9520
TEST_TIME 54 9601
TEST_TIME 55 9552
TEST_TIME 56 9474
TEST_TIME 57 9670
TEST_TIME 58 9705
TEST_TIME 59 9664
TEST_TIME 60 9530
TEST_TIME 61 9500
TEST_TIME 62 9419
TEST_TIME 63 9401
TEST_TIME 64 9306
TEST_TIME 65 9363
TEST_TIME 66 9316
TEST_TIME 67 9361
TEST_TIME 68 9290
TEST_TIME 69 9311
TEST_TIME 70 9369
TEST_TIME 71 9332
TEST_TIME 72 9348
TEST_TIME 73 9398
TEST_TIME 74 9425
TEST_TIME 75 9422
TEST_TIME 76 9383
TEST_TIME 77 9420
TEST_TIME 78 9468
TEST_TIME 79 9524
TEST_TIME 80 9428
TEST_TIME 81 9403
TEST_TIME 82 9341
TEST_TIME 83 9327
TEST_TIME 84 9310
TEST_TIME 85 9266
TEST_TIME 86 9219
TEST_TIME 87 9289
TEST_TIME 88 9254
TEST_TIME 89 9247
TEST_TIME 90 9259
TEST_TIME 91 9291
TEST_TIME 92 9314
TEST_TIME 93 9313
TEST_TIME 94 9316
TEST_TIME 95 9339
TEST_TIME 96 9388
TEST_TIME 97 9421
TEST_TIME 98 9400
TEST_TIME 99 9429
TEST_TIME 100 9451
TEST_TIME 101 9410
TEST_TIME 102 9389
TEST_TIME 103 9358
TEST_TIME 104 9385
TEST_TIME 105 9347
TEST_TIME 106 9326
TEST_TIME 107 9267
TEST_TIME 108 9249
TEST_TIME 109 9232
TEST_TIME 110 9214
TEST_TIME 111 9243
TEST_TIME 112 9229
TEST_TIME 113 9216
TEST_TIME 114 9273
TEST_TIME 115 9274
TEST_TIME 116 9267
TEST_TIME 117 9271
TEST_TIME 118 9321
TEST_TIME 119 9309
TEST_TIME 120 9279

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 30-03-2021 01:28:20 to 30-03-2021 01:28:24.

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 1541044 1541044 0 0.00 0 20371 6 0 0
doc_list_biud 1541036 1541036 0 0.00 0 61116 28 0 0
sp_add_invoice_to_stock 5141 4995 146 2.83 42 147011 17793 0 146
sp_cancel_adding_invoice 5707 5707 0 0.00 5 72068 812 0 0
sp_cancel_client_order 1789 1789 0 0.00 4 19497 341 0 0
sp_cancel_customer_reserve 563743 563743 0 0.00 1 61118 62 0 0
sp_cancel_pay_from_customer 663 663 0 0.00 2 3409 69 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 4560 87 0 0
sp_cancel_supplier_invoice 6304 6298 6 0.09 2 14684 770 0 6
sp_cancel_supplier_order 417 417 0 0.00 7 1266691 105522 0 0
sp_cancel_write_off 10403 10403 0 0.00 1 10189 110 0 0
sp_client_order 21225 21225 0 0.00 3 21690 400 0 0
sp_customer_reserve 460828 460828 0 0.00 0 71758 176 0 0
sp_fill_shopping_cart 32280 32280 0 0.00 1 16576 36 0 0
sp_fill_shopping_cart_clo_res 460817 460817 0 0.00 0 17802 15 0 0
sp_get_clo_for_invoice 4978 4978 0 0.00 0 23593 321 0 0
sp_kill_cost_storno 17185 17185 0 0.00 0 6824 53 0 0
sp_kill_qstorno_ret_qs2qd 1144604 1144604 0 0.00 0 61110 33 0 0
sp_kill_qty_storno 603501 603501 0 0.00 0 61116 72 0 0
sp_lock_selected_doc 20937 20937 0 0.00 0 7879 5 0 0
sp_make_cost_storno 28448 28448 0 0.00 0 20364 51 0 0
sp_multiply_rows_for_pdistr 28445 28445 0 0.00 0 11053 29 0 0
sp_multiply_rows_for_qdistr 21225 21225 0 0.00 0 21682 192 0 0
sp_pay_from_customer 7291 7291 0 0.00 4 17703 114 0 0
sp_pay_to_supplier 6010 6010 0 0.00 5 15147 129 0 0
sp_payment_common 13297 13297 0 0.00 1 7744 30 0 0
sp_qd_handle_on_cancel_clo 1789 1789 0 0.00 0 19490 309 0 0
sp_qd_handle_on_invoice_upd_sts 10685 10685 0 0.00 0 32473 316 0 0
sp_qd_handle_on_reserve_upd_sts 10166 10166 0 0.00 0 26902 70 0 0
sp_reserve_write_off 10169 10169 0 0.00 6 26973 187 0 0
sp_supplier_invoice 5503 5503 0 0.00 7 127712 3285 0 0
sp_supplier_order 5553 5553 0 0.00 5 39687 1403 0 0
srv_aggregate_perf_data 92 92 0 0.00 2209 517279 22553 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1293 152986 31865 0 0
srv_find_qd_qs_mism 1065086 1065086 0 0.00 0 10004 5 0 0
srv_make_invnt_saldo 601 601 0 0.00 53 88646 1155 0 0
srv_make_money_saldo 793 793 0 0.00 1 6239 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 148111 494066 313258 0 0
t$perf-abend:sp_add_invoice_to_stock 146 146 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 4995 4995 0 0.00 0 7216 163 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 0 6509 90 0 0
t$perf-norm:sp_cancel_client_order 1789 1789 0 0.00 0 9230 25 0 0
t$perf-norm:sp_cancel_customer_reserve 687 687 0 0.00 0 9912 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 663 663 0 0.00 0 3701 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 1142 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 392 392 0 0.00 0 599 10 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 19484 1462 0 0
t$perf-norm:sp_cancel_write_off 1011 1011 0 0.00 0 1075 5 0 0
t$perf-norm:sp_client_order 21225 21225 0 0.00 0 9915 17 0 0
t$perf-norm:sp_customer_reserve 1038 1038 0 0.00 0 1551 7 0 0
t$perf-norm:sp_pay_from_customer 7291 7291 0 0.00 0 2607 7 0 0
t$perf-norm:sp_pay_to_supplier 6010 6010 0 0.00 0 5010 10 0 0
t$perf-norm:sp_reserve_write_off 10169 10169 0 0.00 0 9341 13 0 0
t$perf-norm:sp_supplier_invoice 5503 5503 0 0.00 0 6328 17 0 0
t$perf-norm:sp_supplier_order 5553 5553 0 0.00 0 4582 15 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 304 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 1179 15 0 0
t$perf-norm:srv_make_invnt_saldo 601 601 0 0.00 0 2415 26 0 0
t$perf-norm:srv_make_money_saldo 793 793 0 0.00 0 1364 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 15 6 0 0
v_add_invoice_to_stock 10246 9954 292 2.84 0 10551 22 0 292
v_all_customers 38992 38992 0 0.00 0 14 1 0 0
v_all_suppliers 31082 31082 0 0.00 0 230 1 0 0
v_all_wares 42450 42450 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 224 6 0 0
v_cancel_client_order 3578 3578 0 0.00 0 4687 8 0 0
v_cancel_customer_prepayment 1326 1326 0 0.00 0 2932 8 0 0
v_cancel_customer_reserve 1374 1374 0 0.00 0 3340 9 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 2865 8 0 0
v_cancel_supplier_invoice 796 784 12 1.50 0 1111 14 0 12
v_cancel_supplier_order 834 834 0 0.00 0 1193 5 0 0
v_cancel_write_off 2022 2022 0 0.00 0 4769 19 0 0
v_max_id_clo_ord 5553 5553 0 0.00 0 136 1 0 0
v_max_id_clo_res 1038 1038 0 0.00 0 6864 25 0 0
v_max_id_ord_sup 5502 5502 0 0.00 0 5057 5 0 0
v_max_non_paid_invoice 1521 1521 0 0.00 0 7664 12 0 0
v_max_non_paid_realizn 3683 3683 0 0.00 0 5143 6 0 0
v_min_id_clo_ord 5553 5553 0 0.00 0 2024 4 0 0
v_min_id_clo_res 1038 1038 0 0.00 0 6154 19 0 0
v_min_id_ord_sup 5502 5502 0 0.00 0 12702 6 0 0
v_min_non_paid_invoice 6007 6007 0 0.00 0 6810 18 0 0
v_min_non_paid_realizn 7290 7290 0 0.00 0 7405 18 0 0
v_our_firm 10672 10672 0 0.00 0 18 1 0 0
v_reserve_write_off 20332 20332 0 0.00 0 17585 10 0 0
x_lock_depdocs_on_canc_invoice 11613 11613 0 0.00 0 28030 129 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 3592 332 0 0
x_make_qstorno_1000_1200 5553 5553 0 0.00 2 39667 1334 0 0
x_make_qstorno_1200_2000 5503 5503 0 0.00 3 127390 3149 0 0
x_make_qstorno_2100_3300 460828 460828 0 0.00 0 71757 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-03-2021 01:28:25 to 30-03-2021 01:28:29.

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:27 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:34 5222 8192000000 10121812224 10413834240 815055312 9.049 66 54 111 2 834850880 2216240 17579328
22:57:45 35588 8192000000 10341569632 10660597760 1366138288 14.292 100 81 162 1 1397528784 4800960 26589536
22:58:29 27301 8192000000 10388841072 10712117248 1438236432 14.934 100 86 172 0 1472571728 6404352 27930944
22:59:12 31962 8192000000 10434035488 10767314944 1479432176 15.296 100 87 174 0 1515025424 7659280 27933968
22:59:54 21789 8192000000 10447325616 10780925952 1502150720 15.495 100 89 178 0 1539615248 8781424 28683104
23:00:33 28334 8192000000 10479358224 10818146304 1534413024 15.775 100 93 186 0 1573736304 9824528 29498752
23:01:10 25225 8192000000 10493737600 10835906560 1545836416 15.874 100 89 178 0 1583759792 9812096 28111280
23:01:47 19154 8192000000 10499953808 10848686080 1554935408 15.953 100 77 154 0 1589380432 10335008 24110016
23:02:17 15358 8192000000 10529685040 10882560000 1588442400 16.241 100 86 172 0 1625235424 10401392 26391632
23:02:43 12151 8192000000 10547973824 10905104384 1608991584 16.416 100 79 157 1 1643891632 11125760 23774288
23:03:08 12578 8192000000 10581293568 10939760640 1637476576 16.658 100 83 166 0 1674094656 12025616 24592464
23:03:28 10818 8192000000 10596309840 10956800000 1652619040 16.787 100 82 164 0 1689466896 12767824 24080032
23:03:47 10688 8192000000 10604606752 10972147712 1664033088 16.883 100 76 152 0 1699153680 12772416 22348176
23:04:05 9795 8192000000 10622549392 10990514176 1679657616 17.014 100 70 140 0 1712604480 12652352 20294512
23:04:24 9726 8192000000 10646898208 11019059200 1707856448 17.251 100 79 158 1 1743715824 12741280 23118096
23:04:44 7745 8192000000 10652409680 11025162240 1717103856 17.328 100 85 170 1 1754484864 12798976 24582032
23:04:59 8962 8192000000 10671148496 11046768640 1730954944 17.443 100 72 144 0 1764809600 12942544 20912112
23:05:15 6697 8192000000 10674813392 11052589056 1740307968 17.521 100 82 164 2 1777457472 13793520 23355984
23:05:28 4009 8192000000 10686177696 11062177792 1750522144 17.606 100 82 164 1 1787896416 14036336 23337936
23:05:39 6952 8192000000 10687076672 11074015232 1753986400 17.635 100 79 157 1 1790864272 14525312 22352560
23:05:56 6065 8192000000 10694751296 11078529024 1762644064 17.706 100 70 137 1 1794576448 12692944 19239440
23:06:09 3798 8192000000 10717992384 11101790208 1779857776 17.848 100 82 164 1 1816539152 12496528 24184848
23:06:19 3149 8192000000 10727774384 11108925440 1788225616 17.917 100 75 149 1 1821731680 12170240 21335824
23:06:30 2339 8192000000 10720567280 11114659840 1794514656 17.969 100 77 154 1 1828197568 11889856 21793056
23:06:39 3219 8192000000 10731571680 11120898048 1802927664 18.038 100 79 160 0 1836849200 12025440 21896096
23:06:50 3565 8192000000 10744122560 11131351040 1806876080 18.070 100 77 156 5 1840772608 11983408 21913120
23:07:00 2575 8192000000 10751569088 11138068480 1815927024 18.144 100 86 173 1 1852963120 12671440 24364656
23:07:09 2353 8192000000 10765349136 11150372864 1823111296 18.203 100 89 175 2 1861234848 13209792 24913760
23:07:18 1819 8192000000 10770149232 11157663744 1833795776 18.290 100 89 178 0 1873076608 14314288 24966544
23:07:27 2161 8192000000 10779503312 11164192768 1839546240 18.337 100 90 180 1 1878326384 13161568 25618576
23:07:35 2842 8192000000 10787710080 11170459648 1838794176 18.331 100 86 172 3 1876150160 12367440 24988544
23:07:45 2185 8192000000 10786033504 11169198080 1840697936 18.346 100 88 174 3 1877938816 12217696 25023184
23:07:53 1984 8192000000 10788758816 11176292352 1847592304 18.403 100 89 178 2 1886138160 13706416 24839440
23:08:02 1942 8192000000 10794721536 11179970560 1853014768 18.447 100 93 186 3 1892318848 12419120 26884960
23:08:10 2059 8192000000 10797692032 11184300032 1854081616 18.455 100 88 173 3 1891867632 12709392 25076624
23:08:19 2456 8192000000 10807848800 11193995264 1857343888 18.482 100 97 195 1 1898390496 14160864 26885744
23:08:28 2099 8192000000 10807123312 11193065472 1864669424 18.541 100 89 176 0 1903793088 13429104 25694560
23:08:36 7782 8192000000 10778859696 11187855360 1858382944 18.490 100 83 166 1 1895739200 14068016 23288240
23:09:11 2153 8192000000 10788488272 11194699776 1861599296 18.516 100 59 117 1 1889217664 11157328 16461040
23:09:21 1805 8192000000 10812856720 11208081408 1874100384 18.617 100 77 158 0 1905141632 8288144 22753104
23:09:30 6276 8192000000 10803534928 11208572928 1874839072 18.623 100 43 87 1 1894955712 8254768 11861872
23:09:43 4971 8192000000 10793099968 11210678272 1875494704 18.629 100 44 87 2 1895720400 8480912 11744784
23:09:55 6305 8192000000 10792567168 11212607488 1877690656 18.646 100 31 62 1 1894709584 8282768 8736160
23:10:07 3477 8192000000 10799442464 11215724544 1883566464 18.694 100 50 98 4 1905355600 6528000 15261136
23:10:17 5173 8192000000 10801807904 11221049344 1887130448 18.723 100 36 73 1 1905565392 8610224 9824720
23:10:30 6480 8192000000 10784946256 11217408000 1884799456 18.704 100 26 52 1 1897936704 5852000 7285248
23:10:47 8164 8192000000 10799005824 11221504000 1884347216 18.700 100 32 63 3 1900428192 7474912 8606064
23:11:04 8827 8192000000 10785911680 11219476480 1886763264 18.720 100 21 42 1 1898980784 6357200 5860320
23:11:19 10220 8192000000 10799699504 11224252416 1887041120 18.722 100 23 46 2 1899060848 6041936 5977792
23:11:36 1575 8192000000 10811631264 11227652096 1895452208 18.790 100 56 109 4 1917290240 5798800 16039232
23:11:44 66417 8192000000 10834952048 11241349120 1891290096 18.756 100 50 99 4 1912258000 5335248 15632656
23:12:57 7161 8192000000 10808990736 11238023168 1890665728 18.751 100 38 76 0 1910498736 9206432 10626576
23:13:12 6076 8192000000 10808525680 11239727104 1890267504 18.748 100 38 74 2 1912614240 11842224 10504512
23:13:25 8680 8192000000 10808925168 11239780352 1889357776 18.741 100 19 38 0 1900888032 6571088 4959168
23:13:41 6708 8192000000 10818720128 11247300608 1902359600 18.845 100 45 90 1 1923296512 7229088 13707824
23:13:54 4187 8192000000 10818029712 11246010368 1900578944 18.831 100 34 68 4 1916627376 6233696 9814736
23:14:07 8643 8192000000 10803791136 11243462656 1900144608 18.827 100 21 42 1 1912555808 6551696 5859504
23:14:21 6364 8192000000 10802172912 11243184128 1901096592 18.835 100 29 59 1 1915957392 6461104 8399696
23:14:36 7524 8192000000 10816126720 11248050176 1900223488 18.828 100 24 48 4 1913781392 6507104 7050800
23:14:53 7199 8192000000 10809351504 11247427584 1904861712 18.865 100 32 62 1 1920503776 6363216 9278848
23:15:08 6740 8192000000 10814889168 11249762304 1901944320 18.842 100 27 54 2 1916252416 6618240 7689856
23:15:23 3975 8192000000 10820719792 11251048448 1906463056 18.878 100 44 88 2 1925705648 6479552 12763040
23:15:36 5622 8192000000 10803995504 11242360832 1894938720 18.786 100 27 54 2 1909987024 7447136 7601168
23:15:47 15156 8192000000 10809280864 11244204032 1883938416 18.697 99 41 81 4 1900742912 5071600 11732896
23:16:08 64885 8192000000 10806465488 11246272512 1897630352 18.807 100 22 44 1 1909497136 5288000 6578784
23:17:22 10674 8192000000 10802115088 11240124416 1879497680 18.661 99 23 46 3 1892428688 6157120 6773888
23:17:39 4578 8192000000 10812083776 11242455040 1880798352 18.672 99 37 74 2 1897584416 5798576 10987488
23:17:53 4912 8192000000 10788872560 11224530944 1867824864 18.567 99 33 66 4 1883717328 5680064 10212400
23:18:05 6053 8192000000 10795219152 11215564800 1842307648 18.360 98 32 63 1 1856974688 5880576 8786464
23:18:21 5497 8192000000 10774397184 11203358720 1841521024 18.353 98 25 50 0 1855361568 7026880 6813664
23:18:33 6533 8192000000 10751799728 11172970496 1772968176 17.792 95 34 69 2 1788491936 5928032 9595728
23:18:50 7989 8192000000 10724054128 11150745600 1775330464 17.811 97 21 42 0 1787312880 5450496 6531920
23:19:07 5905 8192000000 10673540704 11088658432 1709096416 17.261 95 21 42 3 1720993328 5522560 6374352
23:19:20 8249 8192000000 10677050224 11093819392 1725052800 17.394 96 21 43 2 1736954832 5668208 6233824
23:19:40 7003 8192000000 10690129200 11096756224 1695775168 17.150 95 41 82 0 1717458512 8705280 12978064
23:19:55 7986 8192000000 10662177952 11078369280 1698716368 17.174 96 22 44 0 1710819984 5467520 6636096
23:20:11 8308 8192000000 10694973680 11109683200 1779441488 17.845 100 14 28 1 1789114880 5171936 4501456
23:20:27 59262 8192000000 10690278064 11103739904 1739618928 17.515 97 48 98 0 1763142640 9470176 14053536
23:21:33 9911 8192000000 10696883600 11120545792 1764268656 17.720 98 19 38 0 1774793120 5232352 5292112
23:21:49 10195 8192000000 10700927456 11121000448 1767084848 17.743 98 32 64 3 1783166512 5685904 10395760
23:22:11 6831 8192000000 10726925648 11146625024 1798462880 18.001 99 37 74 3 1816879360 7967584 10448896
23:22:24 6864 8192000000 10722503568 11136610304 1803700784 18.044 100 23 45 2 1816584256 5527632 7355840
23:22:39 8132 8192000000 10724649168 11140112384 1796101680 17.982 99 34 68 0 1812292560 5861504 10329376
23:22:54 5800 8192000000 10719443760 11143069696 1804820160 18.053 100 24 48 0 1819007280 7422064 6765056
23:23:09 7136 8192000000 10729144352 11138564096 1778217632 17.835 98 27 53 2 1790772256 5530576 7024048
23:23:26 11833 8192000000 10735550480 11151626240 1802772800 18.037 99 22 43 1 1814738256 5526320 6439136
23:23:44 9675 8192000000 10728624896 11163082752 1830075776 18.260 100 24 48 0 1842961984 5143328 7742880
23:24:00 7771 8192000000 10749909648 11172728832 1834811248 18.299 100 22 43 3 1846600496 5584960 6204288
23:24:17 12219 8192000000 10758136544 11181871104 1838345168 18.327 100 13 26 2 1847919024 6133696 3440160
23:24:35 9715 8192000000 10757836608 11182534656 1841192288 18.351 100 12 24 0 1850855024 5849904 3812832
23:24:52 11742 8192000000 10757900656 11191033856 1850393648 18.425 100 14 28 0 1864075856 9974144 3708064
23:25:10 65490 8192000000 10772203392 11195752448 1858927648 18.495 100 36 70 4 1876549488 5511792 12110048
23:26:26 6724 8192000000 10768272784 11202338816 1860147152 18.504 100 19 37 1 1871231168 5748288 5335728
23:26:43 7761 8192000000 10784386336 11209064448 1867283648 18.562 100 39 78 1 1885151520 6602528 11265344
23:26:57 7019 8192000000 10784154048 11210035200 1867361472 18.563 100 25 47 1 1879547840 5679296 6507072
23:27:13 7203 8192000000 10810575424 11230883840 1889667840 18.743 100 35 69 1 1905777392 6538912 9570640
23:27:29 19065 8192000000 10829992896 11246858240 1900372144 18.829 100 52 104 3 1921755840 6891312 14492384
23:28:05 17594 8192000000 10835236704 11258933248 1907722064 18.888 100 39 78 1 1928533248 9519424 11291760
23:28:30 25570 8192000000 10845879104 11267268608 1914466256 18.942 100 45 90 0 1937157072 10472448 12218368
23:29:05 4333 8192000000 10858697040 11276881920 1925206240 19.029 100 63 124 2 1954856080 11799328 17850512
23:29:18 15163 8192000000 10857213280 11280297984 1928327840 19.054 100 54 108 2 1954588864 10705696 15555328
23:29:45 3965 8192000000 10874250160 11290882048 1934110192 19.100 100 54 107 2 1962241888 13527120 14604576
23:29:57 9883 8192000000 10873383232 11295350784 1935217648 19.109 100 53 105 2 1965820144 14409664 16192832
23:30:24 30832 8192000000 10886994784 11312672768 1943983536 19.179 100 55 110 3 1980556304 21313984 15258784
23:31:04 24748 8192000000 10872192464 11316215808 1943610464 19.176 100 35 70 3 1969016400 15241504 10164432
23:31:37 16506 8192000000 10883178976 11315019776 1953027808 19.251 100 35 69 2 1977218000 14092800 10097392
23:32:02 39883 8192000000 10886480880 11322884096 1955189520 19.268 100 34 68 2 1978985392 13639328 10156544
23:33:04 15864 8192000000 10899040992 11327864832 1957233472 19.284 100 32 64 1 1987240144 20219760 9786912
23:33:35 13951 8192000000 10895702112 11332907008 1959844592 19.305 100 39 78 2 1991175760 19595232 11735936
23:34:06 32908 8192000000 10893107664 11339816960 1963229872 19.332 100 38 76 1 1995548096 20876512 11441712
23:34:52 15774 8192000000 10916901328 11355897856 1975150176 19.426 100 36 70 1 2007492960 21661280 10681504
23:35:16 9093 8192000000 10932504272 11362689024 1983150272 19.490 100 56 111 2 2024461600 23765392 17545936
23:35:32 3840 8192000000 10941312176 11369910272 1988004496 19.528 100 62 123 1 2034726592 28330560 18391536
23:35:48 7088 8192000000 10943337920 11376418816 1992246608 19.562 100 57 114 0 2037168992 27824944 17097440
23:36:04 3524 8192000000 10940815408 11372650496 1987780976 19.526 100 62 122 1 2032814496 27587904 17445616
23:36:16 1766 8192000000 10955941712 11380822016 1993969776 19.575 100 62 124 0 2039772512 27568256 18234480
23:36:24 8073 8192000000 10944000960 11370594304 1988300880 19.530 100 68 135 1 2036878144 29076032 19501232
23:36:41 4537 8192000000 10952872048 11378638848 1995578176 19.588 100 64 128 0 2044043344 29799536 18665632
23:36:54 2329 8192000000 10970998096 11391635456 1999858592 19.622 100 74 148 1 2053496304 31781792 21855920
23:37:04 6513 8192000000 10969287808 11394834432 2000884272 19.630 100 71 143 0 2055288064 33239792 21164000
23:37:18 4472 8192000000 10975328800 11394584576 2009672880 19.699 100 81 162 2 2069040096 36249168 23118048
23:37:33 3446 8192000000 10985363152 11410485248 2011775456 19.715 100 70 140 2 2065334112 33020336 20538320
23:37:43 5320 8192000000 10968466832 11393249280 1975734992 19.431 98 73 145 1 2031871376 33475104 22661280
23:37:56 2981 8192000000 10960910864 11377262592 1982684656 19.486 99 85 168 1 2044526576 37287840 24554080
23:38:09 6293 8192000000 10973358368 11394916352 2003261728 19.648 100 68 135 3 2057726288 34281408 20183152
23:38:23 4664 8192000000 10957994928 11381239808 1991277808 19.554 100 68 136 4 2044554720 33246416 20030496
23:38:36 3974 8192000000 10956925856 11373268992 1970431888 19.389 99 74 148 0 2027141872 33768944 22941040
23:38:48 9567 8192000000 10949465264 11371642880 1982081776 19.481 100 64 128 0 2035921648 34450224 19389648
23:39:13 13321 8192000000 10951868288 11375063040 1979991120 19.465 100 62 123 1 2035002000 36350704 18660176
23:39:52 8200 8192000000 10969131968 11396751360 1997346160 19.602 100 62 124 2 2052510736 35984608 19179968
23:40:09 4722 8192000000 10948471856 11374632960 1981415872 19.476 100 63 122 4 2036581856 36003024 19162960
23:40:24 6185 8192000000 10949548336 11377811456 1982100960 19.481 100 52 104 0 2036487632 37047376 17339296
23:40:37 8112 8192000000 10963238688 11391692800 1988165184 19.529 100 56 112 2 2045051360 38958752 17927424
23:40:53 1793 8192000000 10961182704 11381198848 1980153744 19.466 99 65 130 2 2045137808 44757280 20226784
23:41:03 5995 8192000000 10965051920 11387629568 1985479520 19.508 99 67 134 2 2051338960 44773520 21085920
23:41:15 4075 8192000000 10976878000 11399479296 1994573200 19.580 100 62 124 0 2058923840 44825744 19524896
23:41:30 2824 8192000000 10958398768 11381612544 1976828336 19.440 99 75 148 2 2044657360 44981632 22847392
23:41:49 4787 8192000000 10973444320 11396399104 1978160448 19.450 99 75 150 2 2047666720 45632384 23873888
23:42:06 3180 8192000000 10985691248 11394826240 1992375120 19.563 100 84 168 0 2067819088 48223920 27220048
23:42:15 2479 8192000000 10972230960 11386519552 1983833280 19.495 100 81 162 1 2058112736 48805120 25474336
23:42:25 5688 8192000000 10973242128 11386073088 1980077552 19.465 100 75 148 2 2051484128 48622480 22784096
23:42:40 2853 8192000000 10980146432 11397779456 1991907024 19.559 100 86 173 1 2066616448 48381200 26328224
23:42:49 1293 8192000000 10988935680 11399909376 1997832464 19.606 100 95 190 4 2071731696 44144736 29754496
23:42:57 2247 8192000000 10992605296 11405520896 2001767184 19.637 100 87 175 0 2073142032 44345168 27029680
23:43:08 7270 8192000000 10980014496 11407704064 1998343328 19.610 100 72 143 0 2064463760 44601184 21519248
23:43:24 3842 8192000000 10979718640 11403755520 1987582816 19.525 99 81 160 4 2058759584 45465776 25710992
23:43:38 3519 8192000000 10981595936 11404619776 2003538256 19.651 100 74 147 0 2072388288 45824992 23025040
23:43:49 2853 8192000000 11001485152 11419582464 2008446848 19.689 100 77 154 2 2078754480 46257008 24050624
23:44:00 3674 8192000000 10997180400 11412434944 1998288544 19.609 100 83 166 1 2075304912 50210640 26805728
23:44:10 3133 8192000000 10990822976 11413241856 2001076144 19.631 100 83 163 2 2078809296 51523408 26209744
23:44:20 9546 8192000000 10969519104 11393212416 1956176304 19.276 98 71 142 4 2028379744 49379488 22823952
23:44:41 2939 8192000000 10948074256 11365302272 1956807920 19.281 100 76 148 1 2029588288 49762224 23018144
23:44:52 1707 8192000000 10953781952 11362951168 1947393392 19.206 99 83 164 2 2023972368 51159808 25419168
23:45:02 1562 8192000000 10967953456 11377483776 1967658752 19.367 100 84 169 3 2046411744 52262336 26490656
23:45:11 3764 8192000000 10957329760 11385905152 1973237712 19.411 100 65 128 1 2044605104 50792032 20575360
23:45:38 7879 8192000000 10942646704 11378880512 1966114144 19.355 100 43 86 2 2026218800 46005616 14099040
23:45:56 8150 8192000000 10928865616 11360616448 1928130016 19.052 98 38 76 0 1987348928 46758976 12459936
23:46:11 4310 8192000000 10953639488 11374059520 1968438368 19.373 100 77 150 2 2040440512 47769776 24232368
23:46:24 3046 8192000000 10959556368 11371220992 1936200400 19.116 98 85 170 3 2015434928 52119184 27115344
23:46:37 2391 8192000000 10976413712 11386335232 1973959824 19.417 100 90 174 1 2055982688 54590848 27432016
23:46:46 3432 8192000000 10984278448 11395854336 1978922480 19.456 100 83 166 0 2061115216 56472272 25720464
23:46:57 2137 8192000000 10996016400 11407749120 1988829168 19.535 100 83 166 1 2074996080 59827520 26339392
23:47:06 4022 8192000000 11004842592 11416268800 1996553088 19.596 100 90 178 1 2085749040 61277200 27918752
23:47:17 2762 8192000000 11001522384 11414151168 1991755936 19.558 100 86 167 1 2081465760 63257568 26452256
23:47:28 6105 8192000000 10993558384 11421425664 1991971376 19.559 100 69 138 1 2079270608 64422976 22876256
23:47:41 8088 8192000000 10978647760 11423465472 1987493344 19.524 100 42 84 0 2062022528 59297680 15231504
23:48:05 4962 8192000000 10964021504 11395792896 1965582704 19.350 99 48 96 1 2040390816 58551920 16256192
23:48:21 6407 8192000000 10966637792 11404980224 1975794192 19.431 100 46 92 1 2051002768 58942256 16266320
23:48:36 10669 8192000000 10972536256 11411709952 1977268224 19.443 100 39 76 1 2053340448 61659680 14412544
23:48:56 4690 8192000000 10985429728 11415818240 1981154048 19.474 100 45 90 0 2062296688 64916496 16226144
23:49:09 4837 8192000000 10995150880 11422965760 1987544688 19.524 100 65 130 1 2075460064 66729184 21186192
23:49:22 1984 8192000000 11007021696 11424407552 1991147744 19.553 100 82 162 1 2084732896 66353568 27231584
23:49:31 1881 8192000000 10987600192 11395616768 1961497488 19.318 99 90 181 1 2059995568 68804896 29693184
23:49:43 9341 8192000000 10964976656 11399872512 1964662528 19.343 100 50 100 0 2050712496 69124864 16925104
23:50:00 10253 8192000000 10959806192 11403468800 1965658000 19.351 100 40 80 0 2052149984 72039008 14452976
23:50:19 15597 8192000000 10948673808 11396292608 1963001392 19.330 100 30 60 0 2036068144 62362752 10704000
23:50:42 18316 8192000000 10952016240 11395772416 1967832080 19.368 100 34 68 0 2031623088 51984720 11806288
23:51:08 17579 8192000000 10917219760 11374608384 1941291168 19.157 99 30 60 1 1999007440 48039456 9676816
23:52:02 29991 8192000000 10922588592 11375214592 1951405088 19.238 100 28 56 1 2010971552 49453808 10112656
23:53:08 45250 8192000000 10902668912 11382575104 1912359184 18.926 99 22 44 0 1978887520 58210640 8317696
23:54:01 39314 8192000000 10870528576 11360993280 1912111472 18.924 99 11 22 1 1962827952 46993856 3722624
23:54:46 47041 8192000000 10881205392 11342225408 1931012544 19.075 100 12 24 1 1964074208 28867408 4194256
23:55:49 1617 8192000000 10907687344 11337805824 1953220240 19.252 100 63 128 0 1979313808 7752208 18341360
23:55:59 8896 8192000000 10905751440 11341467648 1957286160 19.284 100 53 106 4 1981789136 9247360 15255616
23:56:19 15561 8192000000 10899342864 11347312640 1960879616 19.313 100 33 66 1 1981582432 10702192 10000624
23:56:44 29672 8192000000 10882738672 11344998400 1923097744 19.012 98 21 42 1 1940083568 11248096 5737728
23:57:20 40029 8192000000 10904830672 11357569024 1969898608 19.385 100 29 57 3 1987197888 9052736 8246544
23:58:09 119637 8192000000 10901709216 11366330368 1931220432 19.077 98 18 36 0 1945279984 9745280 4314272
00:00:17 42651 8192000000 10893060896 11368144896 1949339184 19.221 99 6 12 1 1964011872 13399120 1273568
00:01:19 44016 8192000000 10896754112 11360239616 1940233296 19.149 99 19 36 2 1958786032 12907280 5645456
00:02:10 124576 8192000000 10853893776 11322175488 1828029008 18.243 93 23 46 2 1843816736 8956272 6831456
00:04:21 127846 8192000000 10859263168 11310559232 1900041424 18.827 98 18 36 1 1913986800 8977536 4967840
00:06:36 18819 8192000000 10866994704 11327373312 1945425904 19.190 100 38 74 1 1965055024 8533920 11095200
00:07:57 55495 8192000000 10863255712 11338039296 1950237568 19.228 100 19 38 0 1966206224 10171424 5797232
00:09:02 44333 8192000000 10888249632 11352846336 1965011424 19.346 100 16 31 1 1977541648 7993424 4536800
00:10:47 61985 8192000000 10899816160 11374968832 1980911904 19.472 100 13 26 1 1996377264 10187216 5278144
00:12:10 53192 8192000000 10885738080 11375448064 1963805872 19.336 99 15 30 0 1980361696 12059920 4495904
00:13:19 67487 8192000000 10902934880 11377598464 1953975472 19.258 99 12 24 0 1967771232 10573360 3222400
00:14:33 41393 8192000000 10901942528 11375415296 1962936336 19.329 99 12 24 0 1978765264 12464800 3364128
00:15:21 64600 8192000000 10898110512 11388465152 1972741376 19.407 99 23 45 1 1993746464 14316112 6688976
00:16:39 40832 8192000000 10893105616 11374796800 1950219456 19.228 99 18 36 0 1975945936 20247440 5479040
00:17:27 36533 8192000000 10903706960 11369668608 1967433488 19.365 100 21 41 2 1986470192 12846528 6190176
00:18:09 62637 8192000000 10919199808 11386888192 1976525856 19.437 100 16 32 1 1992684720 10953824 5205040
00:20:09 152985 8192000000 10893596896 11364282368 1882323360 18.684 95 10 20 1 1895932992 10874304 2735328
00:22:48 41768 8192000000 10910106320 11368546304 1961645936 19.319 99 47 94 0 1986866672 11249344 13971392
00:24:04 90880 8192000000 10868535536 11357122560 1873710880 18.614 95 11 22 2 1896147968 19235616 3201472
00:25:43 52610 8192000000 10869097520 11317682176 1878598320 18.654 96 29 59 0 1895781360 9438480 7744560
00:28:06 85124 8192000000 10908965248 11347652608 1921715104 19.001 98 45 90 1 1948495840 13092256 13688480
00:29:37 41270 8192000000 10861620896 11321438208 1884700912 18.703 96 41 82 2 1908942752 12728704 11513136
00:30:31 63083 8192000000 10868062704 11344551936 1953185264 19.252 100 12 24 0 1967249552 10991936 3072352
00:31:50 53394 8192000000 10862520224 11352592384 1951184448 19.236 100 11 22 1 1968587792 14053872 3349472
00:32:53 39588 8192000000 10852797408 11335282688 1909647056 18.904 98 12 25 0 1917921024 5515072 2758896
00:33:39 45406 8192000000 10869204432 11338575872 1899154256 18.819 97 17 33 0 1910665792 6348112 5163424
00:34:55 47951 8192000000 10860759920 11323535360 1883359024 18.692 96 17 34 1 1894926624 6965888 4601712
00:35:52 37281 8192000000 10862350352 11327979520 1926198512 19.036 99 38 76 1 1945565648 9018896 10348240
00:36:51 51641 8192000000 10861981600 11339087872 1903491040 18.854 98 6 12 0 1915267424 10235456 1540928
00:38:16 50174 8192000000 10853719232 11336273920 1905776240 18.873 98 22 44 0 1925788304 13355552 6656512
00:39:13 67834 8192000000 10869961280 11330244608 1867863568 18.567 96 12 24 0 1883461232 12464512 3133152
00:40:27 96774 8192000000 10839785328 11316559872 1845205184 18.383 95 12 24 2 1860648752 12236560 3207008
00:42:32 54604 8192000000 10865249168 11318788096 1897986080 18.810 98 18 36 0 1914637712 11726880 4924752
00:43:38 56333 8192000000 10850339504 11316645888 1858091104 18.488 96 28 56 2 1879483616 13884608 7507904
00:44:41 62681 8192000000 10837255280 11306160128 1822087728 18.195 95 14 28 1 1841705040 15528064 4089248
00:45:50 108419 8192000000 10846936096 11326951424 1891203840 18.755 98 17 34 0 1911506720 15789504 4513376
00:48:11 70858 8192000000 10859081584 11319894016 1915577792 18.951 99 15 30 2 1927041872 7686080 3778000
00:49:46 46346 8192000000 10859587872 11340226560 1949647264 19.224 100 40 80 0 1969952288 8539360 11765664
00:50:48 33436 8192000000 10847025008 11332575232 1923258560 19.013 99 9 18 0 1935053728 9373952 2421216
00:51:42 30598 8192000000 10847597472 11329925120 1901577776 18.839 98 6 12 0 1911539248 8448224 1513248
00:52:47 71902 8192000000 10850582384 11327062016 1903365088 18.853 98 14 28 0 1919380400 11877968 4137344
00:54:05 67542 8192000000 10849369168 11341086720 1897621808 18.807 98 8 16 0 1914464720 14567776 2275136
00:55:19 41385 8192000000 10862644656 11340599296 1936362496 19.118 100 10 20 0 1951778192 12941280 2474416
00:56:08 29629 8192000000 10866339680 11329843200 1918782160 18.977 99 29 58 0 1935505120 7893920 8829040
00:56:46 32615 8192000000 10872889696 11342663680 1947928912 19.210 100 30 60 2 1963483728 7317888 8236928
00:57:27 43141 8192000000 10897840320 11339804672 1920105648 18.988 98 30 59 1 1936110576 7043168 8961760
00:58:16 88556 8192000000 10882309728 11359924224 1917850752 18.970 98 20 40 0 1933525520 10351808 5322960
01:00:02 28379 8192000000 10872606192 11338313728 1901138080 18.835 97 16 32 0 1914666608 9174560 4353968
01:00:38 44603 8192000000 10877464384 11335254016 1898535296 18.815 97 35 70 0 1919950320 12125840 9289184
01:01:34 53925 8192000000 10901505312 11370397696 1947164544 19.204 100 30 60 1 1970619232 15250480 8204208
01:02:56 104242 8192000000 10895551600 11360329728 1927604560 19.048 98 11 22 1 1948143008 17244256 3294192
01:04:48 20898 8192000000 10926631760 11367632896 1957376384 19.285 99 47 94 1 1978583472 7944944 13262144
01:05:22 56594 8192000000 10922964304 11379216384 1956269456 19.276 99 42 84 3 1979027088 10507776 12249856
01:06:26 37058 8192000000 10889254176 11364782080 1928821488 19.057 98 31 62 0 1955386912 17611184 8954240
01:07:10 76672 8192000000 10893697376 11363414016 1903855168 18.857 97 6 12 0 1916364672 10465744 2043760
01:08:42 99710 8192000000 10904325504 11368095744 1935941936 19.114 98 40 78 0 1960382992 12351840 12089216
01:10:38 98675 8192000000 10873367376 11344441344 1878499632 18.653 96 23 46 2 1898485632 12975936 7010064
01:12:23 68185 8192000000 10862960272 11342479360 1921382416 18.998 99 14 29 1 1934164768 8758128 4024224
01:14:38 62414 8192000000 10911668432 11381702656 1970861072 19.392 100 21 42 2 1993945696 17088992 5995632
01:16:10 83828 8192000000 10895913520 11375087616 1938178320 19.132 98 18 36 0 1959754768 16631648 4944800
01:18:50 34945 8192000000 10885462112 11357032448 1926677184 19.040 98 26 52 1 1940884784 7390528 6817072
01:19:39 63776 8192000000 10872232912 11347652608 1879073472 18.658 96 18 36 0 1896124992 12067184 4984336
01:20:53 73942 8192000000 10895096672 11352981504 1917100800 18.964 98 17 33 1 1933084688 10950608 5033280
01:22:13 70880 8192000000 10873182944 11339747328 1860517040 18.507 95 14 28 0 1874091168 9661184 3912944
01:23:30 63386 8192000000 10896423568 11356028928 1916191536 18.956 98 25 50 1 1939419120 16256400 6971184
01:24:41 64671 8192000000 10861847328 11342274560 1873178768 18.610 96 14 28 1 1891842688 14549808 4114112
01:26:01 76020 8192000000 10886209536 11360268288 1916092688 18.956 98 18 34 0 1938783776 17838192 4852896
01:27:24 10458 8192000000 9288535888 9564442624 439331968 5.089 23 3 4 1 444787472 4864256 591248

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 30-03-2021 01:28:31 to 30-03-2021 01:29:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 146 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 30-03-2021 01:29:03 to 30-03-2021 01:29:05.

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          241914
MON$OLDEST_ACTIVE               242518
MON$OLDEST_SNAPSHOT             242518
MON$NEXT_TRANSACTION            242518
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                       2007872
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:173: 
:174: mscs-test-161.budzdorov.ru    Tue Mar 30 01:27:45 2021
:175:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:176: 
--- end of diff output ---

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

30.03.21 01:29:06. 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-03-30 01:29:08 No severe PSQL-related problems occured
30.03.21 01:29:09. End of report.