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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17109672 kB
MemAvailable 31357000 kB
Buffers 0 kB
Cached 14575480 kB
SwapCached 4864 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-01-12 22:27:10
DTS_END                         2021-01-12 22:27:10.1330
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/55302
TRN_ID                          242153
ATT_ID                          630
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: 9330.79 21245 1119695
customer order: creation 179.03 331 21484
customer order: refuse 15.02 341 1802
order to supplier: creation 47.10 1323 5652
order to supplier: removal 3.41 111393 409
invoice (draft): creation 47.88 3352 5746
invoice (draft): removal 51.16 935 6139
invoice accept: apply 43.34 19034 5201
invoice accept: cancel 46.29 859 5555
customer reserve: creation 3998.28 189 479793
customer reserve: removal 4597.81 64 551737
realization accept: apply 86.78 170 10413
realization accept: cancel 80.43 112 9652
payment from customer: creation 60.73 112 7287
payment from customer: removal 6.08 94 730
payment to supplier: creation 50.48 126 6057
payment to supplier: removal 3.64 73 437
service: total inventory turnovers 5.29 1135 635
service: total monetary turnovers 7.25 34 870
service: aggregate perf. data 0.77 26884 92
service: refresh index statistics 0.03 258336 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-01-2021 22:28:34 to 12-01-2021 22:28:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6086
TEST_TIME 2 6646
TEST_TIME 3 5697
TEST_TIME 4 6775
TEST_TIME 5 6423
TEST_TIME 6 6605
TEST_TIME 7 6578
TEST_TIME 8 6665
TEST_TIME 9 7001
TEST_TIME 10 7083
TEST_TIME 11 6967
TEST_TIME 12 7316
TEST_TIME 13 7701
TEST_TIME 14 8048
TEST_TIME 15 8042
TEST_TIME 16 8272
TEST_TIME 17 8127
TEST_TIME 18 8167
TEST_TIME 19 8351
TEST_TIME 20 8510
TEST_TIME 21 8469
TEST_TIME 22 8394
TEST_TIME 23 9109
TEST_TIME 24 9414
TEST_TIME 25 9640
TEST_TIME 26 10096
TEST_TIME 27 10680
TEST_TIME 28 10683
TEST_TIME 29 11490
TEST_TIME 30 11562
TEST_TIME 31 12044
TEST_TIME 32 11882
TEST_TIME 33 11690
TEST_TIME 34 11464
TEST_TIME 35 11147
TEST_TIME 36 10973
TEST_TIME 37 11026
TEST_TIME 38 10872
TEST_TIME 39 10727
TEST_TIME 40 10615
TEST_TIME 41 10544
TEST_TIME 42 10584
TEST_TIME 43 10457
TEST_TIME 44 10359
TEST_TIME 45 10280
TEST_TIME 46 10253
TEST_TIME 47 10146
TEST_TIME 48 10089
TEST_TIME 49 10024
TEST_TIME 50 10032
TEST_TIME 51 9994
TEST_TIME 52 9886
TEST_TIME 53 9873
TEST_TIME 54 9838
TEST_TIME 55 9882
TEST_TIME 56 9822
TEST_TIME 57 9825
TEST_TIME 58 9865
TEST_TIME 59 9864
TEST_TIME 60 9903
TEST_TIME 61 9919
TEST_TIME 62 9955
TEST_TIME 63 9954
TEST_TIME 64 10000
TEST_TIME 65 9993
TEST_TIME 66 10001
TEST_TIME 67 9982
TEST_TIME 68 10021
TEST_TIME 69 9922
TEST_TIME 70 9841
TEST_TIME 71 9755
TEST_TIME 72 9737
TEST_TIME 73 9753
TEST_TIME 74 9720
TEST_TIME 75 9659
TEST_TIME 76 9640
TEST_TIME 77 9652
TEST_TIME 78 9645
TEST_TIME 79 9637
TEST_TIME 80 9677
TEST_TIME 81 9662
TEST_TIME 82 9616
TEST_TIME 83 9755
TEST_TIME 84 9719
TEST_TIME 85 9754
TEST_TIME 86 9704
TEST_TIME 87 9791
TEST_TIME 88 9808
TEST_TIME 89 9789
TEST_TIME 90 9794
TEST_TIME 91 9712
TEST_TIME 92 9697
TEST_TIME 93 9721
TEST_TIME 94 9672
TEST_TIME 95 9633
TEST_TIME 96 9600
TEST_TIME 97 9594
TEST_TIME 98 9567
TEST_TIME 99 9532
TEST_TIME 100 9532
TEST_TIME 101 9542
TEST_TIME 102 9525
TEST_TIME 103 9528
TEST_TIME 104 9518
TEST_TIME 105 9503
TEST_TIME 106 9581
TEST_TIME 107 9561
TEST_TIME 108 9604
TEST_TIME 109 9582
TEST_TIME 110 9558
TEST_TIME 111 9631
TEST_TIME 112 9546
TEST_TIME 113 9499
TEST_TIME 114 9463
TEST_TIME 115 9422
TEST_TIME 116 9364
TEST_TIME 117 9333
TEST_TIME 118 9370
TEST_TIME 119 9381
TEST_TIME 120 9335

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-01-2021 22:28:38 to 12-01-2021 22:28:41.

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 1563269 1563269 0 0.00 0 56791 7 0 0
doc_list_biud 1563268 1563268 0 0.00 0 48740 29 0 0
sp_add_invoice_to_stock 5263 5201 62 1.17 37 179367 19035 0 62
sp_cancel_adding_invoice 5555 5555 0 0.00 3 60715 859 0 0
sp_cancel_client_order 1802 1802 0 0.00 4 13663 341 0 0
sp_cancel_customer_reserve 551737 551737 0 0.00 1 48744 64 0 0
sp_cancel_pay_from_customer 730 730 0 0.00 3 4011 95 0 0
sp_cancel_pay_to_supplier 437 437 0 0.00 3 2977 74 0 0
sp_cancel_supplier_invoice 6142 6139 3 0.04 1 41481 936 0 3
sp_cancel_supplier_order 409 409 0 0.00 15 1182126 111394 0 0
sp_cancel_write_off 9652 9652 0 0.00 1 13459 112 0 0
sp_client_order 21484 21484 0 0.00 3 35290 331 0 0
sp_customer_reserve 479793 479793 0 0.00 0 86279 189 0 0
sp_fill_shopping_cart 32881 32881 0 0.00 1 10700 40 0 0
sp_fill_shopping_cart_clo_res 479781 479781 0 0.00 0 10963 12 0 0
sp_get_clo_for_invoice 5188 5188 0 0.00 0 28325 281 0 0
sp_kill_cost_storno 16374 16374 0 0.00 0 11275 61 0 0
sp_kill_qstorno_ret_qs2qd 1119674 1119674 0 0.00 0 48737 35 0 0
sp_kill_qty_storno 590895 590895 0 0.00 0 48738 75 0 0
sp_lock_selected_doc 21591 21591 0 0.00 0 8020 5 0 0
sp_make_cost_storno 28945 28945 0 0.00 0 56784 56 0 0
sp_multiply_rows_for_pdistr 28945 28945 0 0.00 0 25493 31 0 0
sp_multiply_rows_for_qdistr 21484 21484 0 0.00 0 22656 131 0 0
sp_pay_from_customer 7287 7287 0 0.00 4 25502 113 0 0
sp_pay_to_supplier 6057 6057 0 0.00 4 28277 127 0 0
sp_payment_common 13344 13344 0 0.00 1 25127 29 0 0
sp_qd_handle_on_cancel_clo 1802 1802 0 0.00 0 13657 319 0 0
sp_qd_handle_on_invoice_upd_sts 10743 10743 0 0.00 0 27470 355 0 0
sp_qd_handle_on_reserve_upd_sts 10413 10413 0 0.00 0 16712 54 0 0
sp_reserve_write_off 10413 10413 0 0.00 7 16756 170 0 0
sp_supplier_invoice 5746 5746 0 0.00 7 83606 3352 0 0
sp_supplier_order 5652 5652 0 0.00 5 34193 1323 0 0
srv_aggregate_perf_data 93 92 1 1.07 2967 368864 26885 0 1
srv_fill_mon_cache_memory 182 182 0 0.00 1147 122757 28194 0 0
srv_find_qd_qs_mism 1069831 1069831 0 0.00 0 9880 6 0 0
srv_make_invnt_saldo 635 635 0 0.00 28 112082 1135 0 0
srv_make_money_saldo 870 870 0 0.00 1 7591 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 126196 382618 258337 0 0
t$perf-abend:sp_add_invoice_to_stock 62 62 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 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 5201 5201 0 0.00 0 18700 173 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 0 12288 134 0 0
t$perf-norm:sp_cancel_client_order 1802 1802 0 0.00 0 8795 20 0 0
t$perf-norm:sp_cancel_customer_reserve 665 665 0 0.00 0 326 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 730 730 0 0.00 0 1865 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 437 437 0 0.00 0 2137 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 445 445 0 0.00 0 1277 20 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 33113 1739 0 0
t$perf-norm:sp_cancel_write_off 1074 1074 0 0.00 0 4694 13 0 0
t$perf-norm:sp_client_order 21484 21484 0 0.00 0 29449 20 0 0
t$perf-norm:sp_customer_reserve 1070 1070 0 0.00 0 4980 11 0 0
t$perf-norm:sp_pay_from_customer 7287 7287 0 0.00 0 3767 9 0 0
t$perf-norm:sp_pay_to_supplier 6057 6057 0 0.00 0 3789 11 0 0
t$perf-norm:sp_reserve_write_off 10413 10413 0 0.00 0 13438 12 0 0
t$perf-norm:sp_supplier_invoice 5746 5746 0 0.00 0 6449 21 0 0
t$perf-norm:sp_supplier_order 5652 5652 0 0.00 0 13430 19 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 36 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 182 182 0 0.00 0 689 10 0 0
t$perf-norm:srv_make_invnt_saldo 635 635 0 0.00 0 623 21 0 0
t$perf-norm:srv_make_money_saldo 870 870 0 0.00 0 4438 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10492 10368 124 1.18 0 5452 17 0 124
v_all_customers 38820 38820 0 0.00 0 66 1 0 0
v_all_suppliers 31380 31380 0 0.00 0 62 1 0 0
v_all_wares 42968 42968 0 0.00 0 63 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 1129 9 0 0
v_cancel_client_order 3604 3604 0 0.00 0 2304 4 0 0
v_cancel_customer_prepayment 1460 1460 0 0.00 0 1942 5 0 0
v_cancel_customer_reserve 1330 1330 0 0.00 0 365 3 0 0
v_cancel_payment_to_supplier 874 874 0 0.00 0 1225 5 0 0
v_cancel_supplier_invoice 896 890 6 0.66 0 1845 17 0 6
v_cancel_supplier_order 818 818 0 0.00 0 1251 5 0 0
v_cancel_write_off 2148 2148 0 0.00 0 3588 14 0 0
v_max_id_clo_ord 5652 5652 0 0.00 0 633 1 0 0
v_max_id_clo_res 1070 1070 0 0.00 0 6497 18 0 0
v_max_id_ord_sup 5745 5745 0 0.00 0 4763 6 0 0
v_max_non_paid_invoice 1764 1764 0 0.00 0 5936 7 0 0
v_max_non_paid_realizn 3954 3954 0 0.00 0 5005 5 0 0
v_min_id_clo_ord 5652 5652 0 0.00 0 3293 8 0 0
v_min_id_clo_res 1070 1070 0 0.00 0 7039 13 0 0
v_min_id_ord_sup 5745 5745 0 0.00 0 4596 5 0 0
v_min_non_paid_invoice 6057 6057 0 0.00 0 25122 18 0 0
v_min_non_paid_realizn 7287 7287 0 0.00 0 15459 20 0 0
v_our_firm 10814 10814 0 0.00 0 61 1 0 0
v_reserve_write_off 20826 20826 0 0.00 0 5018 6 0 0
x_lock_depdocs_on_canc_invoice 11249 11249 0 0.00 0 13217 123 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 5865 337 0 0
x_make_qstorno_1000_1200 5652 5652 0 0.00 2 34182 1231 0 0
x_make_qstorno_1200_2000 5746 5746 0 0.00 3 83519 3214 0 0
x_make_qstorno_2100_3300 479793 479793 0 0.00 0 86277 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-01-2021 22:28:42 to 12-01-2021 22:28:46.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:20 15897 8192000000 10205480160 10516094976 889100016 9.790 70 55 110 0 909832176 2520656 18211504
19:57:45 34311 8192000000 10342629536 10658398208 1389270848 14.499 100 93 186 1 1424070416 4947408 29852160
19:58:33 19637 8192000000 10374134304 10692288512 1425839520 14.824 100 88 176 0 1461543328 6672848 29030960
19:59:02 27564 8192000000 10387521936 10715086848 1441109072 14.959 100 91 182 1 1478794560 7771280 29914208
19:59:44 20970 8192000000 10425917632 10756374528 1480026112 15.302 100 92 184 0 1519275184 8683744 30565328
20:00:19 22397 8192000000 10435904992 10772078592 1488086448 15.372 100 82 164 0 1523673280 9098304 26488528
20:00:51 15809 8192000000 10456403744 10799497216 1505261472 15.522 100 83 166 1 1541744384 9271472 27211440
20:01:16 20141 8192000000 10497342096 10843643904 1549568880 15.906 100 83 166 3 1585319120 10317840 25432400
20:01:47 13657 8192000000 10528639568 10878652416 1575863712 16.133 100 82 164 1 1612443008 10864496 25714800
20:02:17 15280 8192000000 10545155392 10903003136 1602879216 16.364 100 76 150 0 1636893936 11468256 22546464
20:02:43 13226 8192000000 10567850208 10929807360 1627718320 16.576 100 80 160 0 1663746128 12106048 23921760
20:03:06 11957 8192000000 10590608544 10953953280 1647800896 16.746 100 77 154 1 1684366064 12547088 24018080
20:03:25 15418 8192000000 10612968448 10975756288 1665472656 16.895 100 84 168 1 1703610544 13126480 25011408
20:03:49 12056 8192000000 10633536560 11003367424 1689932112 17.101 100 78 156 0 1725417712 13138736 22346864
20:04:11 8121 8192000000 10645648224 11014696960 1702792336 17.208 100 85 170 1 1741023696 13320384 24910976
20:04:31 8052 8192000000 10664853856 11034341376 1712606688 17.291 100 75 150 1 1746920400 12427856 21885856
20:04:47 5849 8192000000 10660527456 11040354304 1727473984 17.414 100 73 146 0 1761404736 11867456 22063296
20:05:00 5494 8192000000 10668664432 11048488960 1738186256 17.504 100 63 124 0 1767666400 9988224 19491920
20:05:12 7470 8192000000 10694768256 11067924480 1756323200 17.654 100 80 159 2 1791475248 11665536 23486512
20:05:28 5260 8192000000 10704839920 11084783616 1770490720 17.771 100 78 155 0 1803412336 11275072 21646544
20:05:40 3525 8192000000 10714254448 11094241280 1774877168 17.807 100 81 162 0 1810703376 12745008 23081200
20:05:52 4461 8192000000 10720102016 11102199808 1779394848 17.844 100 82 165 3 1815617072 13449264 22772960
20:06:05 4097 8192000000 10727945088 11111809024 1794823888 17.971 100 85 170 1 1832973184 13843152 24306144
20:06:17 3833 8192000000 10741781968 11124609024 1803250880 18.041 100 81 162 0 1838864128 12575824 23037424
20:06:27 4654 8192000000 10750491424 11138494464 1810804704 18.102 100 83 166 2 1850663200 16723440 23135056
20:06:38 3968 8192000000 10751490368 11132579840 1815972208 18.145 100 85 169 2 1850650448 12275184 22403056
20:06:49 2275 8192000000 10763511536 11144863744 1819199904 18.171 100 90 181 0 1858040768 13831632 25009232
20:06:58 4691 8192000000 10762541664 11145572352 1818816352 18.168 100 82 163 0 1855148368 13764752 22567264
20:07:10 4902 8192000000 10764816944 11153240064 1827471808 18.239 100 84 166 1 1863896928 13295072 23130048
20:07:22 2316 8192000000 10787299136 11171065856 1838729056 18.330 100 89 178 1 1877692592 14284960 24678576
20:07:30 1840 8192000000 10788608864 11173797888 1843865488 18.372 100 94 187 2 1884693232 14724976 26102768
20:07:38 1313 8192000000 10793594240 11179962368 1848676064 18.411 100 88 175 2 1886998672 13554960 24767648
20:07:47 1948 8192000000 10797921136 11182096384 1852625360 18.443 100 91 181 1 1891712688 12597552 26489776
20:07:55 1926 8192000000 10802657552 11187384320 1857829520 18.486 100 94 184 0 1897973456 13376848 26767088
20:08:03 2152 8192000000 10804453872 11192250368 1860064480 18.504 100 89 178 0 1898534080 13368416 25101184
20:08:12 2468 8192000000 10814130016 11199467520 1864372448 18.539 100 90 181 0 1904239520 14595680 25271392
20:08:21 1694 8192000000 10813475808 11202138112 1868900288 18.575 100 98 195 2 1911143472 14946480 27296704
20:08:29 1133 8192000000 10816604320 11202793472 1872990896 18.608 100 92 183 1 1910062432 11742624 25328912
20:08:37 1285 8192000000 10817729536 11205361664 1874225184 18.618 100 89 178 2 1912085312 11809648 26050480
20:08:44 15011 8192000000 10803908176 11202998272 1869804864 18.583 100 70 138 0 1902190656 11439744 20946048
20:09:05 3141 8192000000 10807208512 11208708096 1872340048 18.603 100 72 144 0 1904664656 12143056 20181552
20:09:15 2364 8192000000 10795535456 11203289088 1872653392 18.606 100 54 108 1 1896487312 9315600 14518320
20:09:27 1470 8192000000 10805386880 11212750848 1879179792 18.658 100 65 129 0 1908241712 10783424 18278496
20:09:35 6732 8192000000 10783324080 11204583424 1874676176 18.622 100 33 65 2 1891515984 6902800 9937008
20:09:49 6288 8192000000 10790897872 11215134720 1880422880 18.669 100 29 56 2 1895174992 7213200 7538912
20:10:02 4049 8192000000 10811059264 11222200320 1886420656 18.717 100 49 95 2 1908665712 9233200 13011856
20:10:15 4287 8192000000 10803254544 11222478848 1885262176 18.708 100 41 83 0 1905895840 9661536 10972128
20:10:25 5690 8192000000 10801185312 11225264128 1886259888 18.716 100 37 74 0 1904522832 7805520 10457424
20:10:37 4483 8192000000 10801299184 11230814208 1888201792 18.731 100 26 52 0 1906938224 11335424 7401008
20:10:48 5095 8192000000 10796910752 11225452544 1890652800 18.751 100 30 60 1 1906117312 6910576 8553936
20:10:59 12728 8192000000 10804117200 11232755712 1897473648 18.806 100 35 69 2 1914824048 6377568 10972832
20:11:21 7814 8192000000 10815242336 11238166528 1901102832 18.835 100 28 55 3 1914924048 5936416 7884800
20:11:36 71561 8192000000 10822923168 11253727232 1904122560 18.859 100 33 66 1 1920196304 6348768 9724976
20:12:56 10334 8192000000 10817887664 11251232768 1903660608 18.856 100 26 52 1 1917415376 6378976 7375792
20:13:13 4909 8192000000 10818602832 11252854784 1904622864 18.863 100 23 46 0 1917099712 5891200 6585648
20:13:25 7130 8192000000 10824127072 11257724928 1906409776 18.878 100 24 48 1 1919085584 6336480 6339328
20:13:38 5736 8192000000 10826332304 11262410752 1911616256 18.920 100 36 72 1 1929018784 6696288 10706240
20:13:51 7417 8192000000 10830024544 11259658240 1911067664 18.915 100 33 66 2 1927090848 6522848 9500336
20:14:06 7887 8192000000 10815315440 11253329920 1892818528 18.768 99 20 40 0 1905070880 6342592 5909760
20:14:21 7308 8192000000 10820797600 11258363904 1905699200 18.872 100 18 36 2 1916362224 5684752 4978272
20:14:34 6818 8192000000 10838071504 11269586944 1914354800 18.942 100 20 40 3 1926421312 6014032 6052480
20:14:53 7988 8192000000 10838469952 11270365184 1919871776 18.986 100 18 36 1 1931403472 5588480 5943216
20:15:08 9785 8192000000 10830806736 11268632576 1902013888 18.842 99 27 52 4 1915445872 5615856 7816128
20:15:29 9208 8192000000 10840423776 11279777792 1920759376 18.993 100 25 50 0 1941940800 13753584 7427840
20:15:45 9503 8192000000 10823051344 11262124032 1899386864 18.821 99 24 45 1 1911274240 6109216 5778160
20:16:03 9022 8192000000 10819793232 11258646528 1894706976 18.784 99 16 32 0 1904590064 5007472 4875616
20:16:23 59237 8192000000 10826795392 11258470400 1896577744 18.799 99 37 74 3 1913284400 6539856 10166800
20:17:28 13735 8192000000 10782807232 11215769600 1824180848 18.212 96 25 50 1 1837551184 6370544 6999792
20:17:48 10541 8192000000 10810759024 11234504704 1875679536 18.630 99 31 60 2 1890409536 6696304 8033696
20:18:05 6023 8192000000 10800943168 11236618240 1878988448 18.657 99 35 69 0 1897101024 7123296 10989280
20:18:17 4720 8192000000 10764884752 11185364992 1821240080 18.188 97 39 78 3 1838628304 6319888 11068336
20:18:28 6771 8192000000 10748036288 11171311616 1755157456 17.644 94 35 70 1 1770929616 5515264 10256896
20:18:46 6874 8192000000 10733493936 11157196800 1763207552 17.711 96 23 46 2 1775753040 5784912 6760576
20:19:02 9729 8192000000 10745060128 11166420992 1778955872 17.841 97 29 58 2 1792884656 5401840 8526944
20:19:18 10252 8192000000 10727237392 11140796416 1729486720 17.431 95 31 62 0 1744658064 5398304 9773040
20:19:35 4613 8192000000 10729630448 11147153408 1795085600 17.974 99 31 62 0 1810665376 6621552 8958224
20:19:46 7451 8192000000 10708239584 11118837760 1719111472 17.345 95 26 52 2 1736534400 10351696 7071232
20:20:00 7875 8192000000 10702872032 11127525376 1780180720 17.851 99 26 52 2 1793793760 5982016 7631024
20:20:14 9384 8192000000 10671651728 11089244160 1704580736 17.223 95 16 31 2 1715015600 5475312 4959552
20:20:32 8121 8192000000 10721737664 11143483392 1787365728 17.910 99 27 56 4 1801555984 6032192 8158064
20:20:49 64498 8192000000 10727509056 11145502720 1746873792 17.576 96 30 60 1 1764969664 8621216 9474656
20:21:59 14050 8192000000 10719200016 11136376832 1742316944 17.538 96 17 34 0 1752863376 5545184 5001248
20:22:20 10975 8192000000 10733055376 11153854464 1810472624 18.100 100 28 57 1 1823843296 5540608 7830064
20:22:41 5422 8192000000 10750367328 11162914816 1823896448 18.210 100 36 72 0 1841095712 6321664 10877600
20:22:54 10160 8192000000 10746494400 11165810688 1830084784 18.260 100 24 48 1 1842130528 5125088 6920656
20:23:14 9055 8192000000 10730359488 11148337152 1799246496 18.008 98 37 72 2 1816662656 6877440 10538720
20:23:32 8565 8192000000 10728583488 11154313216 1789652176 17.929 98 15 30 0 1800402272 6180960 4569136
20:23:47 7571 8192000000 10748000240 11169353728 1831744640 18.274 100 27 54 3 1845421472 5614752 8062080
20:24:05 10534 8192000000 10766916192 11183964160 1843899168 18.373 100 31 62 1 1858555936 4958176 9698592
20:24:23 8552 8192000000 10759529072 11186905088 1847217808 18.400 100 30 59 2 1861689520 5144240 9327472
20:24:38 4554 8192000000 10765127648 11188527104 1848972784 18.414 100 27 53 4 1861964944 5794304 7197856
20:24:51 10288 8192000000 10763399968 11193946112 1852023232 18.439 100 21 40 1 1864226576 6564672 5638672
20:25:17 7945 8192000000 10779595536 11199062016 1855800912 18.469 100 30 60 0 1871127088 7177280 8148896
20:25:35 7313 8192000000 10771882800 11198963712 1856710256 18.477 100 25 50 1 1871167248 6776944 7680048
20:25:49 46197 8192000000 10772723328 11200139264 1858663664 18.492 100 30 59 0 1872867360 5659424 8544272
20:26:42 24493 8192000000 10779140944 11209105408 1863263360 18.530 100 23 46 3 1874405168 4865872 6275936
20:27:13 3596 8192000000 10796688976 11218776064 1880918928 18.673 100 36 72 2 1896932752 6373472 9640352
20:27:26 15442 8192000000 10821701696 11233464320 1889191872 18.739 100 44 88 3 1908187120 6471504 12523744
20:27:58 13899 8192000000 10836391856 11249942528 1902406672 18.846 100 56 112 0 1927310848 9414528 15489648
20:28:48 19778 8192000000 10851565600 11276484608 1918530336 18.975 100 52 104 0 1945417152 12692784 14194032
20:29:14 2661 8192000000 10869832976 11281154048 1927846608 19.050 100 66 133 1 1958441888 12205776 18389504
20:29:24 11782 8192000000 10861065360 11286601728 1927056112 19.043 100 52 104 1 1954483648 12815392 14612144
20:29:45 17335 8192000000 10863632928 11289464832 1930633744 19.072 100 44 88 0 1954961808 11645552 12682512
20:30:09 16913 8192000000 10876245536 11298189312 1937450752 19.126 100 52 103 2 1964635808 12758816 14426240
20:30:40 10464 8192000000 10888521792 11308023808 1946254208 19.197 100 65 130 3 1979355440 14450144 18651088
20:31:07 7084 8192000000 10887214432 11313221632 1949922048 19.226 100 55 111 1 1980155472 14206816 16026608
20:31:21 7973 8192000000 10895732848 11318874112 1953990000 19.258 100 59 118 0 1987163648 15417584 17756064
20:31:36 24073 8192000000 10885925232 11321081856 1956382880 19.277 100 44 88 1 1982572560 13219840 12969840
20:32:09 8629 8192000000 10900753616 11329642496 1962269392 19.324 100 52 104 2 1991918592 14026544 15622656
20:32:28 6729 8192000000 10905620736 11334983680 1970668944 19.391 100 53 106 1 2001686832 14914560 16103328
20:32:46 23529 8192000000 10907569488 11337891840 1968945792 19.377 100 51 102 2 1999610112 15632336 15031984
20:33:20 30957 8192000000 10918475232 11348353024 1974461168 19.421 100 53 105 3 2009227568 19339808 15426592
20:34:00 9775 8192000000 10922347984 11353612288 1979496272 19.461 100 48 95 1 2012488976 18758064 14234640
20:34:20 17597 8192000000 10928563008 11354722304 1977612864 19.446 100 50 100 0 2010373248 17213440 15546944
20:34:51 29895 8192000000 10926784496 11360264192 1980940480 19.472 100 53 106 2 2017136192 19997744 16197968
20:35:28 6609 8192000000 10933210768 11363622912 1988765760 19.534 100 55 109 5 2026210224 21472880 15971584
20:35:43 5426 8192000000 10937423120 11369177088 1990745392 19.550 100 57 114 2 2029819856 21943792 17130672
20:36:02 9306 8192000000 10941273600 11366600704 1970669936 19.391 99 52 98 3 2009420720 24015760 14735024
20:36:21 9943 8192000000 10918661296 11349147648 1946968640 19.202 98 53 107 0 1988069184 24630320 16470224
20:36:46 16459 8192000000 10940662896 11373391872 1987737952 19.526 100 55 110 2 2031661744 26927936 16995856
20:37:12 3809 8192000000 10953027264 11371966464 1988184736 19.529 100 56 112 0 2030663232 24615456 17863040
20:37:24 4653 8192000000 10955398896 11383169024 1998218080 19.609 100 68 136 0 2045145376 27240320 19686976
20:37:38 5087 8192000000 10964050608 11390353408 2001435808 19.634 100 63 126 0 2050545232 30227072 18882352
20:37:50 6418 8192000000 10959125312 11385667584 1996231824 19.593 100 65 128 2 2044684352 29619648 18832880
20:38:05 4703 8192000000 10976547952 11395919872 2002904032 19.646 100 73 145 1 2055831440 31467808 21459600
20:38:20 6042 8192000000 10980111888 11404886016 2008699984 19.691 100 77 153 1 2066164032 34510368 22953680
20:38:34 3369 8192000000 10984831952 11407331328 2011118688 19.710 100 75 149 0 2068447904 34766128 22563088
20:38:45 4443 8192000000 10989566208 11412578304 2014366080 19.736 100 74 143 1 2072129136 36356480 21406576
20:39:00 6806 8192000000 10965061920 11387949056 1977170992 19.442 98 74 148 0 2036262480 36368256 22723232
20:39:15 5022 8192000000 10965645312 11390750720 1985622032 19.509 99 86 168 1 2046896816 34380000 26894784
20:39:27 4848 8192000000 10959928960 11387146240 1973455184 19.413 99 67 134 4 2025913392 30980720 21477488
20:39:41 1696 8192000000 10969758048 11390410752 1997320704 19.602 100 80 160 1 2054118352 32314624 24483024
20:39:51 4458 8192000000 10963490208 11382251520 1976674592 19.438 99 85 169 1 2035362672 33301776 25386304
20:40:02 10969 8192000000 10950534304 11375398912 1978378656 19.452 100 61 121 0 2032830784 35412960 19039168
20:40:19 2315 8192000000 10961889488 11379335168 1967199248 19.363 99 84 167 0 2030622848 37094944 26328656
20:40:31 7654 8192000000 10954108176 11374534656 1975911520 19.432 100 74 148 2 2037651104 39006336 22733248
20:40:46 3897 8192000000 10949724064 11370496000 1972785760 19.408 100 75 150 1 2034952512 38962848 23203904
20:41:02 2765 8192000000 10961768352 11374608384 1974522288 19.421 100 81 153 1 2033329104 36141952 22664864
20:41:12 2083 8192000000 10956149808 11368484864 1971694976 19.399 100 86 170 2 2035530880 37128896 26707008
20:41:20 1397 8192000000 10948345184 11363082240 1968804656 19.376 100 89 177 1 2030054992 33856320 27394016
20:41:31 7017 8192000000 10943044432 11371053056 1973629136 19.414 100 66 132 3 2028754896 35183392 19942368
20:41:57 6662 8192000000 10935839632 11357294592 1962495392 19.326 100 78 157 2 2020824656 34552544 23776720
20:42:14 1412 8192000000 10939863808 11350028288 1950948768 19.234 99 88 176 2 2012453968 34028656 27476544
20:42:22 2376 8192000000 10932267152 11341266944 1946193680 19.196 99 87 174 1 2008550000 36172752 26183568
20:42:31 1775 8192000000 10933514416 11345616896 1939344736 19.142 99 87 174 1 2002082928 36811808 25926384
20:42:41 3094 8192000000 10938047696 11347439616 1952768960 19.249 100 78 151 1 2012151360 37067472 22314928
20:42:56 5018 8192000000 10900513936 11314397184 1916805968 18.961 98 76 152 0 1977358768 36726848 23825952
20:43:08 3669 8192000000 10932070016 11347460096 1952526912 19.247 100 81 162 2 2014804608 36808608 25469088
20:43:18 9581 8192000000 10917887632 11346219008 1947801376 19.209 100 65 130 4 2006222688 38176496 20244816
20:43:36 3515 8192000000 10916812480 11332075520 1931733056 19.081 99 66 132 0 1990930800 38654768 20542976
20:43:46 4547 8192000000 10923328656 11332501504 1923787792 19.017 99 77 151 3 1989051200 41611520 23651888
20:44:00 2489 8192000000 10936736016 11351244800 1955351136 19.269 100 78 156 1 2018958912 39772496 23835280
20:44:10 1676 8192000000 10935152992 11344048128 1944500416 19.183 100 79 158 2 2009209152 39137888 25570848
20:44:18 7093 8192000000 10940101584 11349954560 1951588144 19.239 100 89 173 3 2020125056 42669664 25867248
20:44:36 2903 8192000000 10951788400 11358765056 1957303984 19.285 100 86 171 1 2028288976 45210480 25774512
20:44:48 2543 8192000000 10948996320 11356061696 1946791344 19.201 99 82 164 0 2021745696 49219408 25734944
20:44:59 4659 8192000000 10938827136 11352035328 1950230032 19.228 100 84 167 1 2024249392 48132512 25886848
20:45:11 3994 8192000000 10900254688 11315494912 1918656384 18.976 99 69 137 2 1988778848 48058688 22063776
20:45:25 3572 8192000000 10938825792 11351339008 1946607136 19.199 100 79 158 2 2020214752 49069936 24537680
20:45:36 1942 8192000000 10938362608 11349823488 1944447840 19.182 100 75 151 1 2016783344 48810800 23524704
20:45:47 1146 8192000000 10963516608 11366600704 1959387328 19.301 100 94 189 3 2037837712 49244832 29205552
20:45:57 2604 8192000000 10967874736 11375210496 1965581632 19.350 100 86 172 1 2042410928 50320992 26508304
20:46:06 4957 8192000000 10971056160 11384991744 1970536432 19.390 100 86 168 1 2048438944 51777824 26124688
20:46:17 4432 8192000000 10971501232 11386953728 1977972112 19.449 100 70 140 0 2049355392 49335424 22047856
20:46:30 5140 8192000000 10970340896 11388936192 1978601792 19.454 100 70 139 0 2050259360 49600880 22056688
20:46:46 2252 8192000000 10991096304 11404550144 1993220544 19.569 100 90 180 1 2070577216 49567440 27789232
20:46:58 3475 8192000000 10999196400 11412508672 1997657984 19.604 100 86 172 1 2078839776 54679808 26501984
20:47:09 1803 8192000000 11006608448 11416395776 2001548800 19.635 100 93 185 0 2085543568 54778016 29216752
20:47:18 1967 8192000000 10988296064 11402256384 1985429024 19.508 100 93 187 4 2070111664 54621440 30061200
20:47:27 3343 8192000000 10965865712 11380088832 1965932080 19.353 100 88 173 1 2048669824 54707888 28029856
20:47:37 3255 8192000000 10990578160 11402313728 1983585344 19.493 100 87 174 0 2066683024 55428032 27669648
20:47:47 4402 8192000000 10973113264 11394572288 1973353632 19.412 100 70 139 0 2055402720 59398464 22650624
20:47:58 9132 8192000000 10972022080 11397242880 1974640016 19.422 100 50 100 1 2051015008 59102416 17272576
20:48:15 4027 8192000000 10956912160 11382628352 1937139696 19.124 98 65 128 2 2019568288 61109472 21319120
20:48:29 4206 8192000000 10978955408 11393351680 1968438368 19.373 100 80 160 1 2057596320 63212752 25945200
20:48:42 6922 8192000000 10959600752 11375321088 1942963824 19.170 99 68 134 1 2025246320 60556144 21726352
20:48:55 1508 8192000000 10965840912 11374407680 1952407216 19.246 99 86 172 1 2042005504 62382720 27215568
20:49:04 2057 8192000000 10961733488 11372113920 1928421760 19.054 98 82 165 2 2018529728 64410656 25697312
20:49:14 2393 8192000000 10969904320 11382120448 1958113872 19.291 100 74 147 3 2047004432 65978560 22912000
20:49:28 4392 8192000000 10944663568 11368050688 1936713040 19.121 99 63 126 3 2024503728 66804736 20985952
20:49:45 5340 8192000000 10961980624 11385188352 1953817088 19.257 100 64 128 1 2043750912 67929744 22004080
20:49:58 5850 8192000000 10960425376 11383848960 1952283296 19.245 100 71 139 2 2045540560 69247744 24009520
20:50:12 1451 8192000000 10985221552 11391594496 1955726256 19.272 100 85 166 3 2054486800 71523280 27237264
20:50:20 4607 8192000000 10969798816 11387764736 1958383424 19.293 100 77 154 3 2048346096 64495712 25466960
20:50:37 13204 8192000000 10955870432 11392565248 1959799104 19.304 100 54 108 0 2043497936 65476864 18221968
20:51:03 12834 8192000000 10946605488 11391000576 1957620464 19.287 100 44 86 0 2038070512 64526032 15924016
20:51:29 6771 8192000000 10966972000 11407462400 1972349904 19.404 100 48 96 2 2054066144 64872144 16844096
20:51:50 13394 8192000000 10959656464 11394441216 1950449504 19.230 99 41 84 0 2030475520 65068960 14957056
20:52:11 10107 8192000000 10956214576 11400249344 1966689392 19.359 100 43 86 1 2042174832 61104592 14380848
20:52:34 11830 8192000000 10965538256 11406659584 1971739136 19.399 100 47 95 1 2045595792 57406576 16450080
20:52:53 18650 8192000000 10939732848 11391672320 1930018608 19.067 98 37 74 2 2003054272 60321184 12714480
20:53:25 13312 8192000000 10941210288 11390259200 1961385520 19.317 100 36 72 1 2024588448 51491072 11711856
20:53:51 15135 8192000000 10931266672 11387834368 1944226672 19.180 99 28 56 1 2007982288 54289888 9465728
20:54:32 32301 8192000000 10920563632 11387658240 1954029584 19.259 100 23 46 0 2014706496 52584544 8092368
20:55:11 22734 8192000000 10920815712 11391500288 1946301088 19.197 100 18 36 1 2002118144 49163760 6653296
20:55:49 27342 8192000000 10922051568 11395272704 1949622528 19.223 100 19 38 3 2005824800 49254880 6947392
20:56:23 20748 8192000000 10899518352 11397136384 1926149696 19.036 99 11 22 0 1977297328 47069232 4078400
20:57:01 28246 8192000000 10894024464 11364184064 1941128160 19.156 100 12 24 1 1971872912 27094448 3650304
20:58:02 56066 8192000000 10905883152 11392868352 1956636400 19.279 100 5 10 0 1982613392 24729328 1247664
20:59:32 69416 8192000000 10913002048 11360948224 1902263664 18.844 96 16 30 0 1919004480 12552656 4188160
21:01:10 43322 8192000000 10877107296 11338657792 1940360800 19.150 99 8 16 0 1954127216 12039344 1727072
21:02:37 33506 8192000000 10892752944 11351674880 1937716048 19.129 99 51 96 1 1962101824 9490400 14895376
21:03:47 60692 8192000000 10901776416 11353759744 1954678928 19.264 99 44 88 1 1979468512 12139376 12650208
21:05:14 64724 8192000000 10902521808 11349807104 1938449376 19.134 99 37 75 1 1956334576 7845872 10039328
21:06:39 40334 8192000000 10897452176 11347660800 1944798512 19.185 99 30 61 1 1963231984 10162384 8271088
21:07:30 7170 8192000000 10902176352 11356909568 1967094448 19.362 100 39 75 1 1988649040 10601216 10953376
21:08:20 46663 8192000000 10899693056 11350495232 1951612448 19.239 99 28 57 1 1971978656 12750000 7616208
21:09:15 49025 8192000000 10894696512 11371278336 1973300144 19.412 100 21 43 0 1988906704 9281088 6325472
21:10:21 67000 8192000000 10898801616 11372843008 1971848800 19.400 100 9 18 0 1981340784 7050032 2441952
21:11:39 24305 8192000000 10896792304 11372920832 1977321536 19.443 100 7 14 0 1989431856 10063856 2046464
21:12:10 13230 8192000000 10900842928 11377795072 1980338784 19.467 100 9 18 0 1993322416 10533216 2450416
21:12:30 7078 8192000000 10903303840 11379179520 1980106768 19.466 100 6 12 0 1993174752 11404512 1663472
21:12:43 10893 8192000000 10901516064 11369783296 1975121904 19.426 100 9 18 0 1989454688 11708512 2624272
21:13:09 28846 8192000000 10905055216 11371974656 1959388768 19.301 99 18 36 1 1973925280 9742240 4794272
21:14:20 122757 8192000000 10899861792 11382161408 1962202816 19.324 99 16 32 0 1977454832 10544144 4707872
21:16:38 61640 8192000000 10886875744 11372138496 1940168448 19.148 98 17 34 0 1954962144 10048160 4745536
21:17:55 27085 8192000000 10882051328 11376181248 1955491568 19.270 99 13 26 0 1973846736 14254448 4100720
21:18:30 43757 8192000000 10892923280 11370921984 1962884592 19.329 99 18 36 2 1979986720 12239216 4862912
21:19:19 44217 8192000000 10872551904 11359268864 1930377664 19.070 98 16 32 1 1950876544 15855168 4643712
21:20:16 39688 8192000000 10884762528 11376615424 1962413984 19.325 100 2 4 1 1975003360 12428032 161344
21:21:02 16013 8192000000 10917793392 11371491328 1959854384 19.305 99 28 56 1 1977499264 10044976 7599904
21:21:24 59781 8192000000 10914843088 11394981888 1985715600 19.510 100 24 48 2 2002254624 9800752 6738272
21:22:32 57096 8192000000 10896037696 11373355008 1946055232 19.195 98 12 24 1 1956974896 7203552 3716112
21:23:37 13611 8192000000 10932801264 11384254464 1988669728 19.533 100 60 118 0 2015639808 9902848 17067232
21:24:01 46385 8192000000 10900829232 11380830208 1965328560 19.348 99 27 54 1 1983969664 11096800 7544304
21:24:54 26257 8192000000 10896112768 11355197440 1925196032 19.028 97 27 54 0 1943852512 11391120 7265360
21:25:26 77374 8192000000 10878519408 11358511104 1901536304 18.839 97 18 36 0 1922613872 15895648 5181920
21:26:50 18861 8192000000 10888829584 11338121216 1914219648 18.941 98 32 64 1 1931708576 8332944 9155984
21:27:16 28338 8192000000 10897481920 11355336704 1940286576 19.149 99 31 62 0 1961680464 12694608 8699280
21:27:51 57337 8192000000 10883849680 11354853376 1910253856 18.909 97 19 38 1 1927077936 11499632 5324448
21:29:00 87727 8192000000 10836845392 11299733504 1823036896 18.202 93 15 30 0 1843224032 16141296 4045840
21:30:41 71110 8192000000 10883136032 11347865600 1910873104 18.914 98 22 44 0 1931329168 14509264 5946800
21:31:59 43568 8192000000 10871936464 11318841344 1848824048 18.413 95 21 42 0 1862594944 7817280 5953616
21:32:49 39555 8192000000 10880874560 11324198912 1866547296 18.556 96 38 76 1 1887470720 10694992 10228432
21:33:35 56596 8192000000 10876197120 11333394432 1903027968 18.851 98 31 62 1 1929010832 16894816 9088048
21:34:38 31353 8192000000 10873322208 11320078336 1865335040 18.547 96 18 36 3 1881559104 11411920 4812144
21:35:20 103050 8192000000 10868492272 11338321920 1923675376 19.016 99 28 55 0 1947466336 15662912 8128048
21:37:20 64046 8192000000 10836206544 11298066432 1848743456 18.412 95 23 47 0 1861810944 6484048 6583440
21:38:31 31867 8192000000 10854065120 11310804992 1905650704 18.872 99 24 48 0 1919835984 7530512 6654768
21:39:09 22266 8192000000 10886418384 11338944512 1944073408 19.179 100 39 78 3 1967386544 11796144 11516992
21:39:45 59417 8192000000 10858242384 11330686976 1901636512 18.839 98 13 26 1 1918366112 12995552 3734048
21:40:50 26360 8192000000 10854010288 11338342400 1934670528 19.104 100 10 20 1 1953517648 15673920 3173200
21:41:51 78851 8192000000 10854384560 11317092352 1841557808 18.353 95 18 37 0 1859594048 12937600 5098640
21:43:21 85300 8192000000 10868278896 11345244160 1926862432 19.042 100 14 28 0 1940806320 10130192 3813696
21:44:52 66461 8192000000 10841884720 11320193024 1881552768 18.678 97 11 22 1 1896734944 11735664 3446512
21:46:05 65278 8192000000 10859470288 11327254528 1889100464 18.739 98 14 28 0 1906027696 13165808 3761424
21:47:22 91886 8192000000 10871848064 11342712832 1904165568 18.860 98 12 24 0 1919215920 12072496 2977856
21:49:05 26207 8192000000 10871218016 11332915200 1888472880 18.733 97 30 59 1 1907062144 9994576 8594688
21:49:37 83053 8192000000 10872587056 11355959296 1936943312 19.122 100 15 30 0 1958666400 17162240 4560848
21:51:08 35619 8192000000 10888941776 11349680128 1938122928 19.132 99 29 58 0 1960626656 14203216 8300512
21:51:56 61697 8192000000 10893220960 11365707776 1933654976 19.096 99 29 58 0 1960672512 18456624 8560912
21:53:07 29706 8192000000 10902933760 11358105600 1958064480 19.291 100 35 70 2 1980402352 12810928 9526944
21:54:00 38020 8192000000 10887824688 11375095808 1956435760 19.278 100 19 38 1 1977462032 15754560 5271712
21:54:50 83732 8192000000 10881854912 11355537408 1879792912 18.663 96 11 22 1 1897688000 15077520 2817568
21:56:25 27995 8192000000 10904556368 11357560832 1962851072 19.329 100 43 86 1 1985212048 10310000 12050976
21:57:05 24121 8192000000 10902118768 11362652160 1927362480 19.046 98 26 52 0 1945315840 10958352 6995008
21:57:40 114267 8192000000 10919049792 11379093504 1970201728 19.387 100 24 46 2 1991763696 14064400 7497568
21:59:41 67924 8192000000 10894237184 11368304640 1940514720 19.151 98 28 56 2 1964437968 16017216 7906032
22:00:56 26126 8192000000 10886933808 11373584384 1964370128 19.341 100 13 26 2 1981945184 14026896 3548160
22:01:50 65131 8192000000 10906360656 11386875904 1981364928 19.476 100 11 22 1 1997247088 13090256 2791904
22:03:01 69787 8192000000 10889254096 11371229184 1945383648 19.190 98 14 28 0 1958995936 9520576 4091712
22:04:28 60082 8192000000 10897688896 11375087616 1940016080 19.147 98 8 16 0 1948155808 5931824 2207904
22:05:52 67898 8192000000 10900528352 11377590272 1945878432 19.194 98 11 22 1 1955632208 6810240 2943536
22:07:08 81492 8192000000 10899514400 11389902848 1951328512 19.237 98 16 32 0 1967700304 11878336 4493456
22:08:41 36790 8192000000 10891118432 11364630528 1918981840 18.979 97 17 33 0 1930326608 6656704 4688064
22:09:24 43663 8192000000 10883848096 11346903040 1889080864 18.738 96 19 38 0 1902210192 7541264 5588064
22:10:57 39335 8192000000 10889828496 11356475392 1924475568 19.023 98 23 46 1 1942263456 12057296 5730592
22:11:49 68835 8192000000 10902491344 11372875776 1932652880 19.088 98 16 32 0 1954281776 16973488 4655408
22:13:05 120574 8192000000 10865443872 11349123072 1843390240 18.368 94 17 35 2 1863311200 15492800 4428160
22:15:14 104298 8192000000 10885009264 11339825152 1842943408 18.365 94 29 58 2 1861449520 11041520 7464592
22:17:09 40771 8192000000 10902701456 11350523904 1933913856 19.098 99 38 76 2 1956898768 12299920 10684992
22:18:01 24008 8192000000 10890626352 11350786048 1918673424 18.976 98 46 91 2 1948545280 16743632 13128224
22:18:33 103162 8192000000 10812109408 11266023424 1842986896 18.365 95 11 22 1 1859927424 14079328 2861200
22:20:24 67425 8192000000 10852054608 11313786880 1890767136 18.752 98 21 41 0 1905888032 8909376 6211520
22:22:02 92512 8192000000 10852251968 11325919232 1889209856 18.739 97 12 24 0 1905558192 12510608 3837728
22:23:40 95179 8192000000 10863500112 11336982528 1897642064 18.807 98 16 32 0 1918361168 15109072 5610032
22:25:22 67910 8192000000 10825762688 11322585088 1843487376 18.369 96 10 20 0 1866242576 19465040 3290160
22:26:36 41412 8192000000 9165378448 9414127616 332339776 3.898 17 2 4 0 336312304 3555552 416976

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 12-01-2021 22:28:48 to 12-01-2021 22:29:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 62 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

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

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          242429
MON$OLDEST_ACTIVE               242430
MON$OLDEST_SNAPSHOT             242430
MON$NEXT_TRANSACTION            242430
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                       2050656
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 ---
:824: 
:825: mscs-test-161.budzdorov.ru    Tue Jan 12 22:27:19 2021
:826:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:827: 
:828: 
:829: mscs-test-161.budzdorov.ru    Tue Jan 12 22:27:19 2021
:830:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:831: 
:832: 
:833: mscs-test-161.budzdorov.ru    Tue Jan 12 22:27:19 2021
:834:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:835: 
:836: 
:837: mscs-test-161.budzdorov.ru    Tue Jan 12 22:27:19 2021
:838:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:839: 
:840: 
:841: mscs-test-161.budzdorov.ru    Tue Jan 12 22:27:19 2021
:842:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:843: 
--- end of diff output ---

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

12.01.21 22:29:25. 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-01-12 22:29:27 No severe PSQL-related problems occured
12.01.21 22:29:29. End of report.