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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-30 16:27:11
DTS_END                         2020-12-30 16:27:11.7490
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45928
TRN_ID                          243343
ATT_ID                          687
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: 9295.77 24553 1115492
customer order: creation 174.53 381 20944
customer order: refuse 15.09 346 1811
order to supplier: creation 46.61 1255 5593
order to supplier: removal 3.31 102578 397
invoice (draft): creation 47.62 3411 5714
invoice (draft): removal 52.46 728 6295
invoice accept: apply 42.83 17836 5139
invoice accept: cancel 47.33 772 5679
customer reserve: creation 3963.88 174 475666
customer reserve: removal 4592.33 58 551079
realization accept: apply 86.67 187 10400
realization accept: cancel 90.63 111 10875
payment from customer: creation 60.05 113 7206
payment from customer: removal 5.82 106 698
payment to supplier: creation 50.24 144 6029
payment to supplier: removal 3.45 97 414
service: total inventory turnovers 5.24 991 629
service: total monetary turnovers 6.84 27 821
service: aggregate perf. data 0.83 19232 99
service: refresh index statistics 0.03 342510 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-12-2020 16:28:12 to 30-12-2020 16:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4509
TEST_TIME 2 5379
TEST_TIME 3 4523
TEST_TIME 4 4687
TEST_TIME 5 3961
TEST_TIME 6 3544
TEST_TIME 7 3955
TEST_TIME 8 4189
TEST_TIME 9 5038
TEST_TIME 10 5180
TEST_TIME 11 5299
TEST_TIME 12 5688
TEST_TIME 13 6176
TEST_TIME 14 6292
TEST_TIME 15 6676
TEST_TIME 16 6857
TEST_TIME 17 7098
TEST_TIME 18 7321
TEST_TIME 19 8389
TEST_TIME 20 8361
TEST_TIME 21 8848
TEST_TIME 22 9064
TEST_TIME 23 9218
TEST_TIME 24 10352
TEST_TIME 25 10655
TEST_TIME 26 10955
TEST_TIME 27 10819
TEST_TIME 28 10606
TEST_TIME 29 10561
TEST_TIME 30 10504
TEST_TIME 31 10282
TEST_TIME 32 10430
TEST_TIME 33 10299
TEST_TIME 34 10103
TEST_TIME 35 10079
TEST_TIME 36 10016
TEST_TIME 37 10002
TEST_TIME 38 9983
TEST_TIME 39 9888
TEST_TIME 40 9919
TEST_TIME 41 9882
TEST_TIME 42 9819
TEST_TIME 43 9746
TEST_TIME 44 9558
TEST_TIME 45 9710
TEST_TIME 46 9620
TEST_TIME 47 9582
TEST_TIME 48 9536
TEST_TIME 49 9614
TEST_TIME 50 9537
TEST_TIME 51 9506
TEST_TIME 52 9474
TEST_TIME 53 9650
TEST_TIME 54 9705
TEST_TIME 55 9761
TEST_TIME 56 9807
TEST_TIME 57 9807
TEST_TIME 58 9754
TEST_TIME 59 9765
TEST_TIME 60 9868
TEST_TIME 61 9956
TEST_TIME 62 9869
TEST_TIME 63 9736
TEST_TIME 64 9683
TEST_TIME 65 9687
TEST_TIME 66 9640
TEST_TIME 67 9540
TEST_TIME 68 9524
TEST_TIME 69 9515
TEST_TIME 70 9609
TEST_TIME 71 9609
TEST_TIME 72 9549
TEST_TIME 73 9584
TEST_TIME 74 9548
TEST_TIME 75 9567
TEST_TIME 76 9588
TEST_TIME 77 9662
TEST_TIME 78 9665
TEST_TIME 79 9641
TEST_TIME 80 9641
TEST_TIME 81 9648
TEST_TIME 82 9556
TEST_TIME 83 9578
TEST_TIME 84 9513
TEST_TIME 85 9481
TEST_TIME 86 9462
TEST_TIME 87 9395
TEST_TIME 88 9353
TEST_TIME 89 9351
TEST_TIME 90 9334
TEST_TIME 91 9275
TEST_TIME 92 9308
TEST_TIME 93 9308
TEST_TIME 94 9333
TEST_TIME 95 9325
TEST_TIME 96 9374
TEST_TIME 97 9370
TEST_TIME 98 9369
TEST_TIME 99 9409
TEST_TIME 100 9382
TEST_TIME 101 9416
TEST_TIME 102 9449
TEST_TIME 103 9479
TEST_TIME 104 9531
TEST_TIME 105 9538
TEST_TIME 106 9498
TEST_TIME 107 9447
TEST_TIME 108 9413
TEST_TIME 109 9392
TEST_TIME 110 9345
TEST_TIME 111 9338
TEST_TIME 112 9300
TEST_TIME 113 9279
TEST_TIME 114 9352
TEST_TIME 115 9338
TEST_TIME 116 9327
TEST_TIME 117 9344
TEST_TIME 118 9369
TEST_TIME 119 9374
TEST_TIME 120 9302

Performance per minute, chart


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

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 1554619 1554619 0 0.00 0 20942 6 0 0
doc_list_biud 1554618 1554618 0 0.00 0 23619 26 0 0
sp_add_invoice_to_stock 5236 5139 97 1.85 23 174405 17836 0 97
sp_cancel_adding_invoice 5679 5679 0 0.00 4 71214 772 0 0
sp_cancel_client_order 1811 1811 0 0.00 4 20543 346 0 0
sp_cancel_customer_reserve 551079 551079 0 0.00 1 19640 59 0 0
sp_cancel_pay_from_customer 698 698 0 0.00 3 12832 107 0 0
sp_cancel_pay_to_supplier 414 414 0 0.00 3 4768 98 0 0
sp_cancel_supplier_invoice 6303 6295 8 0.12 1 23342 728 0 8
sp_cancel_supplier_order 397 397 0 0.00 10 1082428 102578 0 0
sp_cancel_write_off 10875 10875 0 0.00 1 12740 111 0 0
sp_client_order 20944 20944 0 0.00 3 21277 381 0 0
sp_customer_reserve 475666 475666 0 0.00 0 101817 175 0 0
sp_fill_shopping_cart 32244 32244 0 0.00 1 9604 40 0 0
sp_fill_shopping_cart_clo_res 475657 475657 0 0.00 0 19984 14 0 0
sp_get_clo_for_invoice 5127 5127 0 0.00 0 32309 317 0 0
sp_kill_cost_storno 17666 17666 0 0.00 0 20930 57 0 0
sp_kill_qstorno_ret_qs2qd 1119725 1119725 0 0.00 0 23325 31 0 0
sp_kill_qty_storno 591663 591663 0 0.00 0 23619 68 0 0
sp_lock_selected_doc 21473 21473 0 0.00 0 10025 7 0 0
sp_make_cost_storno 28762 28762 0 0.00 0 14036 53 0 0
sp_multiply_rows_for_pdistr 28762 28762 0 0.00 0 15838 28 0 0
sp_multiply_rows_for_qdistr 20944 20944 0 0.00 0 16409 179 0 0
sp_pay_from_customer 7206 7206 0 0.00 4 17031 114 0 0
sp_pay_to_supplier 6029 6029 0 0.00 4 19118 145 0 0
sp_payment_common 13235 13235 0 0.00 1 17548 37 0 0
sp_qd_handle_on_cancel_clo 1811 1811 0 0.00 0 20534 304 0 0
sp_qd_handle_on_invoice_upd_sts 10806 10806 0 0.00 0 18747 310 0 0
sp_qd_handle_on_reserve_upd_sts 10400 10400 0 0.00 0 23618 58 0 0
sp_reserve_write_off 10400 10400 0 0.00 6 23660 187 0 0
sp_supplier_invoice 5714 5714 0 0.00 7 81055 3411 0 0
sp_supplier_order 5593 5593 0 0.00 5 27971 1255 0 0
srv_aggregate_perf_data 100 99 1 1.00 2926 307268 19232 0 1
srv_fill_mon_cache_memory 155 155 0 0.00 1280 131246 34068 0 0
srv_find_qd_qs_mism 1065973 1065973 0 0.00 0 12934 6 0 0
srv_make_invnt_saldo 629 629 0 0.00 33 81047 991 0 0
srv_make_money_saldo 821 821 0 0.00 1 4907 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 226052 526148 342511 0 0
t$perf-abend:sp_add_invoice_to_stock 97 97 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5139 5139 0 0.00 0 25055 171 0 0
t$perf-norm:sp_cancel_adding_invoice 424 424 0 0.00 0 2811 99 0 0
t$perf-norm:sp_cancel_client_order 1811 1811 0 0.00 0 6037 22 0 0
t$perf-norm:sp_cancel_customer_reserve 715 715 0 0.00 0 1607 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 698 698 0 0.00 0 2800 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 414 414 0 0.00 0 977 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 441 441 0 0.00 0 1311 18 0 0
t$perf-norm:sp_cancel_supplier_order 397 397 0 0.00 0 19730 1443 0 0
t$perf-norm:sp_cancel_write_off 1046 1046 0 0.00 0 2720 8 0 0
t$perf-norm:sp_client_order 20944 20944 0 0.00 0 11625 18 0 0
t$perf-norm:sp_customer_reserve 1016 1016 0 0.00 0 2082 5 0 0
t$perf-norm:sp_pay_from_customer 7206 7206 0 0.00 0 7658 13 0 0
t$perf-norm:sp_pay_to_supplier 6029 6029 0 0.00 0 8376 13 0 0
t$perf-norm:sp_reserve_write_off 10400 10400 0 0.00 0 8497 13 0 0
t$perf-norm:sp_supplier_invoice 5714 5714 0 0.00 0 7023 16 0 0
t$perf-norm:sp_supplier_order 5593 5593 0 0.00 0 6426 17 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 126 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 6850 50 0 0
t$perf-norm:srv_make_invnt_saldo 629 629 0 0.00 0 6802 47 0 0
t$perf-norm:srv_make_money_saldo 821 821 0 0.00 0 966 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 16 6 0 0
v_add_invoice_to_stock 10448 10254 194 1.85 0 20192 22 0 194
v_all_customers 38202 38202 0 0.00 0 113 1 0 0
v_all_suppliers 31256 31256 0 0.00 0 31 1 0 0
v_all_wares 41888 41888 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 848 848 0 0.00 0 3014 10 0 0
v_cancel_client_order 3622 3622 0 0.00 0 3387 7 0 0
v_cancel_customer_prepayment 1396 1396 0 0.00 0 3891 10 0 0
v_cancel_customer_reserve 1430 1430 0 0.00 0 3157 8 0 0
v_cancel_payment_to_supplier 828 828 0 0.00 0 2642 10 0 0
v_cancel_supplier_invoice 898 882 16 1.78 0 4654 23 0 16
v_cancel_supplier_order 794 794 0 0.00 0 217 3 0 0
v_cancel_write_off 2092 2092 0 0.00 0 7176 16 0 0
v_max_id_clo_ord 5593 5593 0 0.00 0 721 1 0 0
v_max_id_clo_res 1016 1016 0 0.00 0 4010 13 0 0
v_max_id_ord_sup 5707 5707 0 0.00 0 6546 6 0 0
v_max_non_paid_invoice 1701 1701 0 0.00 0 836 2 0 0
v_max_non_paid_realizn 3862 3862 0 0.00 0 2995 5 0 0
v_min_id_clo_ord 5593 5593 0 0.00 0 8114 15 0 0
v_min_id_clo_res 1016 1016 0 0.00 0 2985 14 0 0
v_min_id_ord_sup 5707 5707 0 0.00 0 5522 5 0 0
v_min_non_paid_invoice 6029 6029 0 0.00 0 16182 28 0 0
v_min_non_paid_realizn 7206 7206 0 0.00 0 11558 20 0 0
v_our_firm 10374 10374 0 0.00 0 15 1 0 0
v_reserve_write_off 20800 20800 0 0.00 0 3597 5 0 0
x_lock_depdocs_on_canc_invoice 11533 11533 0 0.00 0 19205 126 0 0
x_lock_depdocs_on_canc_sup_ord 397 397 0 0.00 0 11843 391 0 0
x_make_qstorno_1000_1200 5593 5593 0 0.00 2 27960 1166 0 0
x_make_qstorno_1200_2000 5714 5714 0 0.00 3 81010 3271 0 0
x_make_qstorno_2100_3300 475666 475666 0 0.00 0 101816 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-12-2020 16:28:20 to 30-12-2020 16:28:24.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:15 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:21 19038 8192000000 10236850496 10548547584 925820768 10.153 71 59 120 1 948255168 2723040 19711360
13:57:51 33668 8192000000 10357374208 10673057792 1383112864 14.444 100 82 164 0 1414617264 5032560 26471840
13:58:34 30346 8192000000 10408104000 10734788608 1454283536 15.076 100 89 178 0 1489771744 6751040 28737168
13:59:18 26184 8192000000 10433640160 10763427840 1485744464 15.352 100 90 180 0 1523142464 8251760 29146240
13:59:56 30393 8192000000 10460331984 10795859968 1506944448 15.537 100 94 188 0 1546652336 8877472 30830416
14:00:38 20699 8192000000 10472793840 10810626048 1528145744 15.721 100 90 180 1 1566755792 9589840 29020208
14:01:10 13643 8192000000 10471910672 10817605632 1534122016 15.773 100 85 170 0 1571094608 9788320 27184272
14:01:31 11819 8192000000 10483597328 10833444864 1549572656 15.906 100 86 172 0 1586324928 9766544 26985728
14:01:53 18016 8192000000 10513742608 10866036736 1568556768 16.070 100 80 160 0 1603119680 9464784 25098128
14:02:22 12668 8192000000 10540642448 10901536768 1603424592 16.369 100 81 162 0 1637861888 9991680 24445616
14:02:44 13988 8192000000 10574669296 10935947264 1637725536 16.660 100 79 159 3 1673062320 10702304 24634480
14:03:08 10170 8192000000 10590185680 10953199616 1650347904 16.767 100 76 150 0 1684717296 11981680 22387712
14:03:28 9100 8192000000 10599449152 10970275840 1670173920 16.935 100 81 162 0 1706030336 12048192 23808224
14:03:45 9023 8192000000 10625209056 10991857664 1681889184 17.033 100 77 154 1 1716172064 11998048 22284832
14:04:02 10132 8192000000 10631252704 11004760064 1696803232 17.158 100 77 150 2 1730825328 12430400 21591696
14:04:20 8512 8192000000 10655957888 11026345984 1715752688 17.317 100 83 166 1 1752836240 13466512 23617040
14:04:36 5690 8192000000 10665020352 11039240192 1727359776 17.414 100 81 162 1 1764367664 13764144 23243744
14:04:53 7061 8192000000 10675641312 11053547520 1739509472 17.515 100 75 150 0 1773830496 13323088 20997936
14:05:08 5293 8192000000 10689848848 11067342848 1749386448 17.597 100 76 152 1 1784589312 14012944 21189920
14:05:20 4849 8192000000 10692565200 11073781760 1752294944 17.621 100 72 144 1 1786095744 13498928 20301872
14:05:32 4403 8192000000 10696404656 11076546560 1764041536 17.718 100 78 148 3 1798074016 12446080 21586400
14:05:43 3463 8192000000 10717375888 11095605248 1775776624 17.815 100 88 177 1 1814201888 13756160 24669104
14:06:01 9280 8192000000 10724403072 11107237888 1777431632 17.828 100 72 145 2 1810097712 12643152 20022928
14:06:19 3683 8192000000 10728179120 11117293568 1796789376 17.988 100 74 149 0 1829580160 11951568 20839216
14:06:30 3221 8192000000 10740054384 11121942528 1802987120 18.038 100 88 176 0 1841818960 13255504 25576336
14:06:41 2218 8192000000 10748612640 11136122880 1813959936 18.128 100 87 174 0 1851959472 13672128 24327408
14:06:50 3902 8192000000 10758657456 11143131136 1819827216 18.176 100 78 156 2 1854570320 12783712 21959392
14:07:02 2013 8192000000 10759128240 11143516160 1821775376 18.192 100 91 180 2 1859145072 12145872 25223824
14:07:11 2656 8192000000 10763440352 11147980800 1826533568 18.231 100 86 172 0 1861786256 11250752 24001936
14:07:20 2639 8192000000 10779259824 11165683712 1834998336 18.300 100 88 177 2 1872193616 12787840 24407440
14:07:29 2191 8192000000 10781610432 11169042432 1839976656 18.341 100 88 176 0 1879196224 14364992 24854576
14:07:38 2155 8192000000 10783817024 11173552128 1844317296 18.376 100 88 176 3 1883213904 14301616 24594992
14:07:47 5862 8192000000 10790206704 11180871680 1849389808 18.417 100 82 164 0 1887123104 14097920 23635376
14:08:01 2395 8192000000 10797665632 11187728384 1857603088 18.484 100 90 179 1 1895549856 12677680 25269088
14:08:10 1700 8192000000 10811407392 11198783488 1865042320 18.544 100 93 186 0 1904717392 13683712 25991360
14:08:17 1744 8192000000 10805159296 11195969536 1864819152 18.542 100 88 177 1 1902692720 12506816 25366752
14:08:26 1484 8192000000 10803668240 11194994688 1865349920 18.547 100 87 174 0 1902999952 12487296 25162736
14:08:34 2859 8192000000 10813549888 11201998848 1865976032 18.552 100 85 170 4 1902903360 12826976 24100352
14:08:43 8231 8192000000 10819775152 11206189056 1869552144 18.581 100 88 176 2 1909328672 14961152 24815376
14:08:58 3015 8192000000 10818425984 11206893568 1873930464 18.616 100 92 184 1 1913564416 13876416 25757536
14:09:07 2103 8192000000 10815329232 11208232960 1874082480 18.617 100 92 184 0 1915060608 14262192 26715936
14:09:16 4619 8192000000 10803114000 11204833280 1871804096 18.599 100 75 148 3 1901779024 10253360 19721568
14:09:27 1869 8192000000 10797132736 11204198400 1874146608 18.618 100 65 129 1 1902702736 10063984 18492144
14:09:35 2042 8192000000 10810177344 11211137024 1874760608 18.623 100 66 133 0 1904132656 10721520 18650528
14:09:45 2038 8192000000 10816381312 11215634432 1879176080 18.658 100 78 157 1 1912265840 10875984 22213776
14:09:54 1833 8192000000 10802828768 11214073856 1877627664 18.646 100 62 124 0 1908916640 14495232 16793744
14:10:04 5018 8192000000 10802724352 11213778944 1879717120 18.663 100 59 118 0 1907147520 11204160 16226240
14:10:17 49327 8192000000 10804121488 11215466496 1878996576 18.657 100 48 98 2 1900066000 6760848 14308576
14:11:14 15019 8192000000 10805073632 11225411584 1882229376 18.683 100 45 88 2 1903501376 8797840 12474160
14:11:38 7616 8192000000 10801665104 11222790144 1881417984 18.677 100 33 66 1 1897217440 6201952 9597504
14:11:52 5974 8192000000 10811000704 11221901312 1882444128 18.685 100 33 64 3 1897255872 5753040 9058704
14:12:10 6836 8192000000 10799505136 11228459008 1890749488 18.752 100 43 84 3 1909740336 7185984 11804864
14:12:29 5988 8192000000 10807067360 11234635776 1891267872 18.756 100 52 105 0 1913166688 7375808 14523008
14:12:42 5673 8192000000 10809609696 11229577216 1891031792 18.754 100 41 83 0 1910139344 7318480 11789072
14:12:53 3986 8192000000 10815108096 11227807744 1888344768 18.732 100 29 57 0 1903089856 6345472 8399616
14:13:04 3781 8192000000 10804822064 11235135488 1893715536 18.776 100 37 74 0 1912150352 7301984 11132832
14:13:16 4762 8192000000 10808328864 11233382400 1893985312 18.778 100 30 60 0 1908205856 5721184 8499360
14:13:31 6034 8192000000 10813682928 11236864000 1892746224 18.768 100 29 58 1 1907799504 6119168 8934112
14:13:44 7049 8192000000 10803199600 11235532800 1894254928 18.780 100 31 63 1 1910677568 7454640 8968000
14:13:58 6400 8192000000 10814625920 11242160128 1894851584 18.785 100 19 38 1 1906613600 6325200 5436816
14:14:12 9956 8192000000 10806572688 11244933120 1901442416 18.838 100 16 32 0 1912795440 6536272 4816752
14:14:29 13979 8192000000 10812176352 11249373184 1901122752 18.835 100 9 18 1 1908542608 4956160 2463696
14:14:49 59163 8192000000 10833048800 11258953728 1911197488 18.916 100 30 58 3 1925938128 5808688 8931952
14:15:54 4711 8192000000 10826537392 11260727296 1915217824 18.949 100 38 76 3 1932699616 6345552 11136240
14:16:05 7807 8192000000 10813609824 11253088256 1892727616 18.768 99 19 36 2 1904259232 6671008 4860608
14:16:19 5412 8192000000 10812752752 11237564416 1868240416 18.570 98 25 50 2 1881054976 6307024 6507536
14:16:31 3279 8192000000 10812715968 11237724160 1877401168 18.644 99 40 79 1 1896868496 8304608 11162720
14:16:43 5484 8192000000 10818942448 11250085888 1897638416 18.807 100 25 50 0 1910819024 5645792 7534816
14:16:56 6895 8192000000 10812941536 11237470208 1865401472 18.547 98 30 60 3 1880539328 6617632 8520224
14:17:12 8223 8192000000 10807515328 11239694336 1892232160 18.764 100 22 46 3 1903851744 5088160 6531424
14:17:27 10443 8192000000 10793814800 11225620480 1864945264 18.543 98 25 48 3 1877435312 5620976 6869072
14:17:44 7659 8192000000 10788716288 11218317312 1863423504 18.531 99 16 32 2 1873601744 5430320 4747920
14:17:58 9978 8192000000 10775769296 11195879424 1813826048 18.127 96 15 30 1 1823402016 5260352 4315616
14:18:14 5730 8192000000 10755912656 11186667520 1779271552 17.843 95 24 48 0 1791091600 5057280 6762768
14:18:30 8648 8192000000 10741726672 11158069248 1778162576 17.834 96 24 44 3 1795117680 9692560 7262544
14:18:45 7724 8192000000 10760747808 11190497280 1845374912 18.385 100 20 40 0 1856953360 5540704 6037744
14:18:59 10809 8192000000 10752347024 11175034880 1793639872 17.962 97 32 63 2 1809087808 5486096 9961840
14:19:19 50353 8192000000 10719146880 11120558080 1669073984 16.925 91 32 61 1 1683770624 4369424 10327216
14:20:21 20095 8192000000 10676060880 11097837568 1625083088 16.553 90 10 18 1 1631775088 4276944 2415056
14:20:47 5887 8192000000 10696085264 11100098560 1743701616 17.549 97 28 56 3 1757787424 5586880 8498928
14:20:59 5630 8192000000 10728681264 11135713280 1771962256 17.783 98 39 78 1 1790134208 6741360 11430592
14:21:13 6921 8192000000 10725857968 11144540160 1799716800 18.012 99 33 64 2 1814889824 6161472 9011552
14:21:29 5757 8192000000 10733198368 11141517312 1793117824 17.957 99 38 71 3 1808918688 5113296 10687568
14:21:44 8618 8192000000 10712913392 11128127488 1796320880 17.984 100 27 54 2 1809979936 5981872 7677184
14:22:00 11029 8192000000 10724417168 11138039808 1775249280 17.810 98 25 50 1 1788757792 6180736 7327776
14:22:21 6296 8192000000 10704560208 11109707776 1753387648 17.630 97 43 83 2 1771781296 5509728 12883920
14:22:34 9588 8192000000 10724847040 11140915200 1811403872 18.107 100 26 52 1 1824688736 6436384 6848480
14:22:53 7489 8192000000 10722115664 11147407360 1815825872 18.144 100 23 47 1 1829260368 6625424 6809072
14:23:07 8837 8192000000 10739809264 11155210240 1802191408 18.032 99 35 70 1 1822247264 9365008 10690848
14:23:23 8635 8192000000 10746194112 11164774400 1827537456 18.239 100 16 30 3 1838087504 5890624 4659424
14:23:39 11633 8192000000 10756249664 11180691456 1838098768 18.325 100 19 38 1 1848749216 5236752 5413696
14:23:59 11293 8192000000 10772572976 11177410560 1827973984 18.243 99 19 38 2 1839203632 6253296 4976352
14:24:16 69407 8192000000 10758208160 11190730752 1851737952 18.436 100 20 38 1 1862445744 4901824 5805968
14:25:32 9409 8192000000 10770446256 11200516096 1861529504 18.516 100 24 46 4 1873586144 5573344 6483296
14:25:49 7924 8192000000 10788275504 11214389248 1868071712 18.569 100 30 60 2 1882263392 6178032 8013648
14:26:04 9924 8192000000 10784216672 11213590528 1871866816 18.599 100 31 60 0 1887059968 7055552 8137600
14:26:21 6308 8192000000 10794533040 11220713472 1874674880 18.622 100 29 58 2 1890799184 7182592 8941712
14:26:34 7555 8192000000 10799102448 11225968640 1875177952 18.626 100 19 38 2 1889904896 9951888 4775056
14:26:47 12247 8192000000 10796565664 11227308032 1878243392 18.651 100 19 38 0 1889100320 5279856 5577072
14:27:10 10425 8192000000 10830247408 11247296512 1899077232 18.819 100 22 44 2 1910383120 5123360 6182528
14:27:31 11160 8192000000 10845652128 11264438272 1916676880 18.960 100 46 92 1 1935467504 6500736 12289888
14:28:01 26338 8192000000 10848060992 11269984256 1919589744 18.984 100 45 89 1 1939497264 7441552 12465968
14:28:45 25672 8192000000 10875665792 11295584256 1935606752 19.112 100 43 84 2 1958003472 10799664 11597056
14:29:21 25951 8192000000 10882031888 11314679808 1948998880 19.219 100 51 99 2 1980299312 16331696 14968736
14:29:55 15176 8192000000 10886098928 11315970048 1955921776 19.274 100 44 85 3 1982198224 13175056 13101392
14:30:16 16886 8192000000 10895407504 11326287872 1961966512 19.322 100 49 98 1 1990463472 14210704 14286256
14:30:46 55517 8192000000 10904632560 11344244736 1967584384 19.366 100 40 80 1 1997674000 18224752 11864864
14:32:04 93700 8192000000 10932133440 11373514752 1988884000 19.535 100 49 96 1 2023919184 20383056 14652128
14:33:50 39015 8192000000 10936346704 11373035520 1980039216 19.465 99 38 71 5 2020223312 28959424 11224672
14:34:36 10453 8192000000 10947211664 11385081856 2000912928 19.630 100 55 108 1 2045231744 28203888 16114928
14:34:56 4214 8192000000 10967886944 11393490944 2006324288 19.673 100 63 125 0 2054610000 28936192 19349520
14:35:11 12377 8192000000 10955540128 11392008192 2003982704 19.654 100 58 116 0 2054221824 32467808 17771312
14:35:36 15299 8192000000 10960834240 11402420224 2007237888 19.680 100 52 105 1 2057506528 33887552 16381088
14:36:09 19744 8192000000 10974466400 11410325504 2009781664 19.700 100 50 99 0 2057346832 32121616 15443552
14:36:36 5625 8192000000 10966428368 11402305536 2004629952 19.659 100 45 90 0 2053758768 35492848 13635968
14:36:49 9631 8192000000 10965598912 11403382784 2010232224 19.703 100 53 104 1 2056223216 31371312 14619680
14:37:09 2869 8192000000 10975681520 11398033408 2006877520 19.677 100 69 135 2 2059428368 32521008 20029840
14:37:19 2647 8192000000 10980693056 11402780672 2011565808 19.714 100 78 156 0 2067337680 33112624 22659248
14:37:30 8028 8192000000 10982285136 11402022912 2007194240 19.679 100 69 139 1 2061100304 34192656 19713408
14:37:47 3530 8192000000 10953958528 11384373248 1979121760 19.458 99 59 118 0 2033311344 36307120 17882464
14:37:57 3568 8192000000 10961393472 11379961856 1987123952 19.521 100 67 132 0 2043620800 37144304 19352544
14:38:10 4315 8192000000 10963836848 11381272576 1988879520 19.535 100 72 144 3 2046792480 37097904 20815056
14:38:21 5686 8192000000 10972659920 11392282624 1999686224 19.620 100 82 163 2 2063266560 38917808 24662528
14:38:36 2826 8192000000 10969036448 11387404288 1991929616 19.559 100 82 162 1 2056131312 40581248 23620448
14:38:47 8533 8192000000 10978880064 11392917504 1995329712 19.586 100 85 170 0 2062374704 42506928 24538064
14:39:02 2573 8192000000 10984538144 11401830400 2002208784 19.640 100 85 169 0 2069514672 42527360 24778528
14:39:15 5552 8192000000 10986732464 11406458880 2007264032 19.680 100 84 168 2 2074302928 41556576 25482320
14:39:27 2880 8192000000 10987214208 11408224256 2009522240 19.698 100 80 158 1 2075986032 42423216 24040576
14:39:37 2372 8192000000 10972906016 11393269760 1987457872 19.524 99 80 158 2 2053830480 42377344 23995264
14:39:46 16080 8192000000 10975706496 11404746752 1999300400 19.617 100 67 134 1 2062488976 42701392 20487184
14:40:10 11383 8192000000 10966571952 11404222464 1985053376 19.505 99 50 99 1 2043391856 42420336 15918144
14:40:32 4538 8192000000 10985378896 11418607616 2004014512 19.654 100 52 104 0 2064303808 43468816 16820480
14:40:43 1803 8192000000 10996298688 11414884352 2008150832 19.687 100 82 166 3 2080096608 45551408 26394368
14:40:52 3864 8192000000 10992254656 11412074496 1990604928 19.549 99 79 156 3 2059406560 44944304 23857328
14:41:05 5313 8192000000 10997576368 11421970432 2014602784 19.738 100 84 169 1 2085475184 45067280 25805120
14:41:19 1799 8192000000 10974179360 11386458112 1982489952 19.484 99 82 163 2 2055373664 48945296 23938416
14:41:27 2069 8192000000 10991704832 11404840960 1998185120 19.608 100 91 182 1 2076749376 51504432 27059824
14:41:36 4844 8192000000 10974505232 11396124672 1987415792 19.523 100 80 160 1 2064166000 52664848 24085360
14:41:50 1801 8192000000 10979540928 11390689280 1981827568 19.479 99 75 150 1 2058079600 53099344 23152688
14:41:59 3858 8192000000 10991855088 11413721088 1997685632 19.604 100 77 154 1 2080757504 58909696 24162176
14:42:09 3944 8192000000 10989952064 11411750912 2004662992 19.659 100 80 161 3 2078704336 50650416 23390928
14:42:24 8144 8192000000 10989175840 11414237184 2003404832 19.650 100 67 134 1 2077193328 52661120 21127376
14:42:45 5609 8192000000 10980424144 11409248256 1994529520 19.580 100 66 132 0 2071386768 55595296 21261952
14:43:02 3783 8192000000 10966756480 11387379712 1961605552 19.319 99 70 138 0 2037945776 54371776 21968448
14:43:13 1278 8192000000 10954661072 11365351424 1952882688 19.249 99 78 156 0 2033149008 55727792 24538528
14:43:22 2673 8192000000 10934392272 11338653696 1912617456 18.928 97 91 181 1 1998323440 57387216 28318768
14:43:32 3024 8192000000 10960892288 11364044800 1956277184 19.276 100 85 168 1 2039089776 55828688 26983904
14:43:43 3535 8192000000 10968400064 11374022656 1963706064 19.335 100 87 170 1 2045683488 55069936 26907488
14:43:54 2057 8192000000 10968254800 11375947776 1952338944 19.245 99 88 175 2 2036276752 56307584 27630224
14:44:03 3640 8192000000 10968136240 11384061952 1969627408 19.382 100 80 160 1 2051832112 56643840 25560864
14:44:23 13868 8192000000 10963087600 11391488000 1981199568 19.474 100 67 132 0 2057381344 55094016 21087760
14:44:45 3602 8192000000 10979933600 11400208384 1986538720 19.516 100 70 142 1 2066596864 56882624 23175520
14:44:56 2919 8192000000 10985690384 11393634304 1974775664 19.423 100 88 178 3 2064198768 60357888 29065216
14:45:06 1681 8192000000 10972275152 11379355648 1966797664 19.360 99 89 177 1 2054160912 59127664 28235584
14:45:16 8701 8192000000 10979653280 11401883648 1977338864 19.444 100 71 142 4 2061795680 61096608 23360208
14:45:36 3071 8192000000 10992230624 11400568832 1982161088 19.482 100 84 166 1 2071178224 61283264 27733872
14:45:46 6349 8192000000 10982192032 11398995968 1962421440 19.325 99 74 148 0 2049075920 62744432 23910048
14:46:01 1835 8192000000 10992360448 11409035264 1988382672 19.531 100 80 160 1 2077467360 63847920 25236768
14:46:10 2510 8192000000 10993622192 11416944640 1987986064 19.528 100 71 142 0 2075448448 63862752 23599632
14:46:21 14786 8192000000 10953700112 11398492160 1958062448 19.291 99 38 76 1 2032883344 61724528 13096368
14:46:47 7825 8192000000 10933794000 11383926784 1949159776 19.220 99 40 80 3 2019411664 56054544 14197344
14:47:20 7976 8192000000 10935341488 11370614784 1964915088 19.345 100 41 81 0 2019658720 41228400 13515232
14:47:38 11293 8192000000 10938860816 11379146752 1971202752 19.395 100 47 94 1 2030580656 43601280 15776624
14:47:57 11107 8192000000 10920012832 11368792064 1951006800 19.234 99 40 80 0 2010269904 45445856 13817248
14:48:32 11015 8192000000 10906309008 11355009024 1950810640 19.233 100 34 68 1 2002096576 39443520 11842416
14:48:53 35148 8192000000 10906053328 11351244800 1931240240 19.077 99 27 54 1 1982418880 42626640 8552000
14:49:56 22031 8192000000 10910204624 11356598272 1924601040 19.024 99 23 45 0 1976959072 44421776 7936256
14:50:50 29327 8192000000 10883161072 11341651968 1896346352 18.797 98 23 46 1 1950115008 45481472 8287184
14:51:26 29740 8192000000 10867944848 11335487488 1907584960 18.887 99 19 38 2 1951218896 36773280 6860656
14:52:10 35150 8192000000 10854338800 11322241024 1902533632 18.847 99 12 24 1 1932685856 26387792 3764432
14:52:52 36341 8192000000 10849812672 11320102912 1900438784 18.830 99 12 25 1 1927078048 22173744 4465520
14:54:22 58300 8192000000 10855793792 11314700288 1910262112 18.909 99 17 34 2 1929380752 14430688 4687952
14:55:27 76395 8192000000 10840932832 11299717120 1868018496 18.568 97 42 81 3 1899039296 19177712 11843088
14:56:52 25883 8192000000 10821805824 11290222592 1890749904 18.752 99 13 25 3 1911644256 16782528 4111824
14:57:49 41493 8192000000 10866616064 11295723520 1883967136 18.697 98 46 86 2 1900723664 4811424 11945104
14:58:38 64195 8192000000 10860957744 11320098816 1901113680 18.835 98 30 60 3 1920694112 11289152 8291280
14:59:49 34973 8192000000 10853771360 11300409344 1888958816 18.737 97 45 90 0 1915916688 13465824 13492048
15:00:36 81178 8192000000 10863528640 11323924480 1935486432 19.111 100 20 40 0 1952179200 10478896 6213872
15:02:04 91284 8192000000 10888419152 11325296640 1941182144 19.156 99 44 91 2 1961093120 7334112 12576864
15:03:48 22305 8192000000 10893001104 11338346496 1950581552 19.231 100 46 91 1 1974486960 10629856 13275552
15:04:20 38499 8192000000 10894906848 11359080448 1963851200 19.337 100 48 97 2 1993892784 16231856 13809728
15:06:05 55291 8192000000 10876275376 11344429056 1926859888 19.042 98 14 28 2 1941957568 11487344 3610336
15:07:06 18542 8192000000 10870243136 11343642624 1949019408 19.219 100 8 16 1 1960301472 9243792 2038272
15:07:31 37237 8192000000 10871393696 11337461760 1948617824 19.215 100 16 33 1 1964015744 10591856 4806064
15:08:16 41393 8192000000 10892880240 11353628672 1955030368 19.267 100 30 58 1 1975078368 11990592 8057408
15:09:14 77995 8192000000 10888272352 11353694208 1929819296 19.065 98 14 28 0 1945403440 11422832 4161312
15:10:39 75433 8192000000 10861655216 11327250432 1920348176 18.990 98 17 34 1 1940738304 15520944 4869184
15:12:15 61889 8192000000 10886435392 11354394624 1952539648 19.247 100 23 46 0 1971080512 12434464 6106400
15:13:23 46554 8192000000 10870127728 11340996608 1944373040 19.182 99 21 42 2 1960263248 10025824 5864384
15:14:46 82078 8192000000 10898825776 11360845824 1949675680 19.224 99 29 58 0 1976256480 17926416 8654384
15:17:13 48299 8192000000 10902759920 11368792064 1972293616 19.404 100 15 30 1 1985203328 8695520 4214192
15:18:09 52454 8192000000 10897321184 11360874496 1922962800 19.011 97 25 50 1 1943401984 13012128 7427056
15:19:13 69501 8192000000 10900165184 11359756288 1934505072 19.103 98 27 52 2 1959636928 16990288 8141568
15:21:34 74344 8192000000 10870529440 11337969664 1890407552 18.749 97 13 26 2 1904826768 10866624 3552592
15:22:56 44113 8192000000 10861819312 11335262208 1908769552 18.897 98 10 20 0 1922655872 11398192 2488128
15:24:26 23101 8192000000 10878949568 11333029888 1928197056 19.052 99 23 46 0 1942674032 8243456 6233520
15:24:58 18096 8192000000 10889334688 11335098368 1932393008 19.086 99 34 68 2 1950774816 9209296 9172512
15:25:26 12120 8192000000 10909142176 11342385152 1955159216 19.268 100 63 126 0 1982234272 9722800 17352256
15:25:47 39362 8192000000 10881783920 11331846144 1919651280 18.984 98 44 88 2 1946300160 14691232 11957648
15:26:47 28704 8192000000 10895409424 11345133568 1934997392 19.107 99 40 79 1 1962005568 15873024 11135152
15:27:21 71722 8192000000 10867922928 11330834432 1880794160 18.672 96 18 36 0 1903300480 16783008 5723312
15:28:40 81280 8192000000 10856040624 11329224704 1859482256 18.499 96 6 12 0 1875461344 14474560 1504528
15:30:38 64026 8192000000 10852469664 11311190016 1899012432 18.818 98 22 44 0 1918844016 13790144 6041440
15:31:49 25866 8192000000 10826276656 11293515776 1892471936 18.766 98 18 36 0 1912804960 15555568 4777456
15:32:26 7203 8192000000 10834783456 11305328640 1914479248 18.943 100 18 36 2 1933417696 13995488 4942960
15:33:07 52293 8192000000 10855166912 11325718528 1916756512 18.961 99 13 26 0 1926996608 6918112 3321984
15:34:20 26978 8192000000 10847615360 11312508928 1901607888 18.839 98 13 26 0 1913241728 8045440 3588400
15:34:53 69512 8192000000 10856446160 11315912704 1876188992 18.634 97 13 27 0 1894050864 14671088 3190784
15:36:25 37255 8192000000 10883994912 11329826816 1915197712 18.948 99 32 64 2 1936221744 11158800 9865232
15:37:54 84370 8192000000 10871351584 11314663424 1865735104 18.550 96 27 54 2 1887620208 13750576 8134528
15:39:28 50330 8192000000 10884137600 11338960896 1936789360 19.121 99 37 74 0 1958278032 11444560 10044112
15:40:28 37395 8192000000 10856091168 11319939072 1885248128 18.707 97 27 54 1 1903367088 10324336 7794624
15:41:11 39401 8192000000 10855987552 11305754624 1879012832 18.657 97 21 42 2 1894355904 9414624 5928448
15:42:06 81591 8192000000 10872319328 11329470464 1900161056 18.828 98 12 24 1 1917907696 14408320 3338320
15:43:34 75326 8192000000 10873867184 11340546048 1902472000 18.846 98 20 40 0 1925178960 16518608 6188352
15:44:56 80660 8192000000 10866460400 11335884800 1905910960 18.874 98 15 30 0 1920234720 10425360 3898400
15:46:22 37068 8192000000 10915203328 11352735744 1955237824 19.268 100 35 70 0 1980786976 16114208 9434944
15:47:07 20547 8192000000 10882473504 11329753088 1939519648 19.143 100 36 72 2 1959510256 9913856 10076752
15:47:37 30636 8192000000 10882676992 11342536704 1935819392 19.113 99 24 48 1 1952348576 9536720 6992464
15:48:19 131246 8192000000 10873699504 11337576448 1944356256 19.182 99 38 76 2 1965831952 10701184 10774512
15:50:37 74612 8192000000 10847120160 11315068928 1853293072 18.449 95 13 26 0 1864305744 7122928 3889744
15:51:58 42515 8192000000 10845123280 11298938880 1875834480 18.631 97 27 54 0 1891945872 8714352 7397040
15:52:47 58031 8192000000 10843251168 11318861824 1911369968 18.918 99 11 22 0 1925030320 10595136 3065216
15:53:52 42478 8192000000 10865840272 11341529088 1940240480 19.149 100 6 12 0 1950729712 8771632 1717600
15:54:40 30214 8192000000 10870034816 11347505152 1951311984 19.237 100 4 8 1 1964963952 12535328 1116640
15:55:21 86095 8192000000 10880969280 11356418048 1954788336 19.265 100 11 22 0 1970484000 12402864 3292800
15:57:11 60522 8192000000 10888078208 11356680192 1952204432 19.244 99 18 36 0 1966925440 10196096 4524912
15:58:18 55290 8192000000 10884955712 11370668032 1968706544 19.375 100 9 17 2 1984914896 14218832 1989520
15:59:21 33790 8192000000 10890741584 11351977984 1948924512 19.218 99 15 30 1 1960300592 7469040 3907040
16:00:11 96824 8192000000 10911398160 11380916224 1922412880 19.006 97 23 46 1 1939334624 10430960 6490784
16:01:55 36186 8192000000 10899456448 11354558464 1885394256 18.709 95 18 36 0 1901297008 11180288 4722464
16:02:38 88631 8192000000 10929736208 11372097536 1954228736 19.260 99 28 56 3 1976289888 14286224 7774928
16:04:14 34725 8192000000 10914225904 11362844672 1948630272 19.216 98 34 67 3 1967088880 9074096 9384512
16:04:55 17745 8192000000 10921980272 11382439936 1965623552 19.351 99 39 78 1 1987086944 10724368 10739024
16:05:20 42257 8192000000 10914251392 11381194752 1949037088 19.219 98 33 65 2 1972147216 13862544 9247584
16:06:16 53834 8192000000 10906677872 11365306368 1925724368 19.033 97 23 46 1 1944249952 12147344 6378240
16:07:18 54745 8192000000 10917656944 11372462080 1913388656 18.934 97 24 48 0 1929006816 8683504 6934656
16:08:22 60811 8192000000 10912483904 11384217600 1959364048 19.301 99 24 48 1 1983991840 17916224 6711568
16:09:33 73836 8192000000 10901338432 11378327552 1915356928 18.950 97 22 44 2 1943323872 21671296 6295648
16:10:56 114439 8192000000 10897535520 11365879808 1892472592 18.766 96 10 20 0 1910175008 14307776 3394640
16:12:59 40015 8192000000 10892783952 11342983168 1909033264 18.899 97 27 54 0 1923561248 6608864 7919120
16:13:55 103504 8192000000 10847164336 11313094656 1879294048 18.659 97 20 40 1 1891946112 7044224 5607840
16:15:44 61646 8192000000 10869949776 11335065600 1928316320 19.053 99 22 44 2 1945690896 10290928 7083648
16:16:53 52283 8192000000 10826746112 11298160640 1890370608 18.749 97 8 16 0 1903275216 10777360 2127248
16:17:54 52155 8192000000 10834265536 11310366720 1878056224 18.649 97 7 14 0 1890050528 10075200 1919104
16:18:53 50634 8192000000 10851024240 11315544064 1872459136 18.604 97 12 24 0 1886111152 10189120 3462896
16:19:55 57296 8192000000 10855835984 11321741312 1920231632 18.989 99 19 38 2 1936540400 10791632 5517136
16:21:07 79760 8192000000 10855024416 11335860224 1914593632 18.944 99 14 28 3 1928094720 10059120 3441968
16:22:33 29922 8192000000 10880250816 11322880000 1907205504 18.884 98 40 78 2 1926128320 7487232 11435584
16:23:11 32625 8192000000 10857473456 11312746496 1879154784 18.658 97 24 48 2 1893652368 7894336 6603248
16:23:52 44797 8192000000 10864716800 11330510848 1894373632 18.781 98 23 46 2 1911888304 10578624 6936048
16:24:43 54815 8192000000 10870035680 11297886208 1803385296 18.042 93 31 62 1 1822517184 9109696 10022192
16:25:45 21910 8192000000 10831982864 11286028288 1855074640 18.463 97 30 60 1 1872644112 8975280 8594192
16:26:22 51759 8192000000 9801419616 10145329152 913344448 10.030 48 16 32 0 922143424 4634544 4164432

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-12-2020 16:28:26 to 30-12-2020 16:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 97 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 30-12-2020 16:28:58 to 30-12-2020 16:28:59.

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          243633
MON$OLDEST_ACTIVE               243634
MON$OLDEST_SNAPSHOT             243634
MON$NEXT_TRANSACTION            243634
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                       2018432
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:110: 
:111: mscs-test-161.budzdorov.ru    Wed Dec 30 16:27:22 2020
:112:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:113: 
:114: 
:115: mscs-test-161.budzdorov.ru    Wed Dec 30 16:27:22 2020
:116:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:117: 
:118: 
:119: mscs-test-161.budzdorov.ru    Wed Dec 30 16:27:23 2020
:120:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:121: 
--- end of diff output ---

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

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