Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.11.2020 16:31
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 17424772 kB
MemAvailable 31418036 kB
Buffers 0 kB
Cached 14223424 kB
SwapCached 2832 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-07 16:31:00
DTS_END                         2020-11-07 16:31:00.1460
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51950
TRN_ID                          242268
ATT_ID                          669
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: 9496.67 28072 1139600
customer order: creation 166.61 344 19993
customer order: refuse 13.88 318 1665
order to supplier: creation 46.11 1232 5533
order to supplier: removal 3.51 103812 421
invoice (draft): creation 44.41 3442 5329
invoice (draft): removal 55.28 785 6634
invoice accept: apply 41.35 16771 4962
invoice accept: cancel 49.86 771 5983
customer reserve: creation 3904.85 161 468582
customer reserve: removal 4879.61 59 585553
realization accept: apply 81.41 194 9769
realization accept: cancel 81.78 108 9814
payment from customer: creation 57.15 134 6858
payment from customer: removal 5.68 81 682
payment to supplier: creation 48.68 166 5841
payment to supplier: removal 3.65 81 438
service: total inventory turnovers 5.00 1009 600
service: total monetary turnovers 6.88 19 825
service: aggregate perf. data 0.95 16470 114
service: refresh index statistics 0.03 415476 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-11-2020 16:32:01 to 07-11-2020 16:32:03.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2645
TEST_TIME 2 3075
TEST_TIME 3 4019
TEST_TIME 4 4033
TEST_TIME 5 4209
TEST_TIME 6 4533
TEST_TIME 7 4611
TEST_TIME 8 4931
TEST_TIME 9 5293
TEST_TIME 10 5487
TEST_TIME 11 5535
TEST_TIME 12 5738
TEST_TIME 13 6102
TEST_TIME 14 5997
TEST_TIME 15 6030
TEST_TIME 16 6682
TEST_TIME 17 7097
TEST_TIME 18 7498
TEST_TIME 19 8034
TEST_TIME 20 7970
TEST_TIME 21 8752
TEST_TIME 22 8906
TEST_TIME 23 9442
TEST_TIME 24 9811
TEST_TIME 25 10648
TEST_TIME 26 11585
TEST_TIME 27 11232
TEST_TIME 28 11187
TEST_TIME 29 10961
TEST_TIME 30 10764
TEST_TIME 31 10865
TEST_TIME 32 10657
TEST_TIME 33 10513
TEST_TIME 34 10373
TEST_TIME 35 10274
TEST_TIME 36 10256
TEST_TIME 37 9988
TEST_TIME 38 9873
TEST_TIME 39 9904
TEST_TIME 40 9934
TEST_TIME 41 10011
TEST_TIME 42 10002
TEST_TIME 43 9916
TEST_TIME 44 9848
TEST_TIME 45 9908
TEST_TIME 46 9915
TEST_TIME 47 9878
TEST_TIME 48 9777
TEST_TIME 49 9952
TEST_TIME 50 9910
TEST_TIME 51 10020
TEST_TIME 52 10014
TEST_TIME 53 10038
TEST_TIME 54 9954
TEST_TIME 55 9853
TEST_TIME 56 9754
TEST_TIME 57 9740
TEST_TIME 58 9718
TEST_TIME 59 9732
TEST_TIME 60 9617
TEST_TIME 61 9554
TEST_TIME 62 9524
TEST_TIME 63 9386
TEST_TIME 64 9593
TEST_TIME 65 9567
TEST_TIME 66 9585
TEST_TIME 67 9533
TEST_TIME 68 9615
TEST_TIME 69 9639
TEST_TIME 70 9662
TEST_TIME 71 9700
TEST_TIME 72 9696
TEST_TIME 73 9774
TEST_TIME 74 9787
TEST_TIME 75 9770
TEST_TIME 76 9851
TEST_TIME 77 9856
TEST_TIME 78 9832
TEST_TIME 79 9773
TEST_TIME 80 9718
TEST_TIME 81 9660
TEST_TIME 82 9664
TEST_TIME 83 9635
TEST_TIME 84 9653
TEST_TIME 85 9620
TEST_TIME 86 9629
TEST_TIME 87 9576
TEST_TIME 88 9538
TEST_TIME 89 9596
TEST_TIME 90 9561
TEST_TIME 91 9577
TEST_TIME 92 9641
TEST_TIME 93 9602
TEST_TIME 94 9673
TEST_TIME 95 9705
TEST_TIME 96 9693
TEST_TIME 97 9715
TEST_TIME 98 9722
TEST_TIME 99 9736
TEST_TIME 100 9791
TEST_TIME 101 9782
TEST_TIME 102 9737
TEST_TIME 103 9669
TEST_TIME 104 9669
TEST_TIME 105 9658
TEST_TIME 106 9624
TEST_TIME 107 9635
TEST_TIME 108 9617
TEST_TIME 109 9585
TEST_TIME 110 9600
TEST_TIME 111 9543
TEST_TIME 112 9478
TEST_TIME 113 9492
TEST_TIME 114 9540
TEST_TIME 115 9534
TEST_TIME 116 9525
TEST_TIME 117 9585
TEST_TIME 118 9556
TEST_TIME 119 9576
TEST_TIME 120 9497

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-11-2020 16:32:04 to 07-11-2020 16:32:08.

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 1572155 1572155 0 0.00 0 20189 6 0 0
doc_list_biud 1572155 1572155 0 0.00 0 55241 28 0 0
sp_add_invoice_to_stock 5079 4962 117 2.30 35 177578 16771 0 117
sp_cancel_adding_invoice 5983 5983 0 0.00 5 82651 771 0 0
sp_cancel_client_order 1665 1665 0 0.00 4 16646 319 0 0
sp_cancel_customer_reserve 585553 585553 0 0.00 1 25642 59 0 0
sp_cancel_pay_from_customer 682 682 0 0.00 2 4920 82 0 0
sp_cancel_pay_to_supplier 438 438 0 0.00 3 7622 81 0 0
sp_cancel_supplier_invoice 6640 6634 6 0.09 2 24654 786 0 6
sp_cancel_supplier_order 421 421 0 0.00 7 1037137 103813 0 0
sp_cancel_write_off 9814 9814 0 0.00 1 10095 108 0 0
sp_client_order 19993 19993 0 0.00 3 17507 344 0 0
sp_customer_reserve 468582 468582 0 0.00 0 89953 161 0 0
sp_fill_shopping_cart 30846 30846 0 0.00 1 32815 41 0 0
sp_fill_shopping_cart_clo_res 468581 468581 0 0.00 0 15060 14 0 0
sp_get_clo_for_invoice 4961 4961 0 0.00 0 29394 295 0 0
sp_kill_cost_storno 16917 16917 0 0.00 0 6232 52 0 0
sp_kill_qstorno_ret_qs2qd 1187975 1187975 0 0.00 0 25636 32 0 0
sp_kill_qty_storno 624800 624800 0 0.00 0 55241 69 0 0
sp_lock_selected_doc 20398 20398 0 0.00 0 8120 7 0 0
sp_make_cost_storno 27429 27429 0 0.00 0 19133 67 0 0
sp_multiply_rows_for_pdistr 27429 27429 0 0.00 0 8104 32 0 0
sp_multiply_rows_for_qdistr 19993 19993 0 0.00 0 10799 162 0 0
sp_pay_from_customer 6858 6858 0 0.00 4 18954 135 0 0
sp_pay_to_supplier 5841 5841 0 0.00 5 16473 166 0 0
sp_payment_common 12699 12699 0 0.00 1 12167 35 0 0
sp_qd_handle_on_cancel_clo 1665 1665 0 0.00 0 5547 275 0 0
sp_qd_handle_on_invoice_upd_sts 10944 10944 0 0.00 0 55239 340 0 0
sp_qd_handle_on_reserve_upd_sts 9769 9769 0 0.00 0 12942 50 0 0
sp_reserve_write_off 9769 9769 0 0.00 6 20954 194 0 0
sp_supplier_invoice 5329 5329 0 0.00 6 106235 3443 0 0
sp_supplier_order 5533 5533 0 0.00 6 83562 1233 0 0
srv_aggregate_perf_data 115 114 1 0.86 1964 127496 16470 0 1
srv_fill_mon_cache_memory 157 157 0 0.00 1605 127324 34805 0 0
srv_find_qd_qs_mism 1091573 1091573 0 0.00 0 18540 5 0 0
srv_make_invnt_saldo 600 600 0 0.00 30 54197 1009 0 0
srv_make_money_saldo 825 825 0 0.00 1 533 19 0 0
srv_recalc_idx_stat 4 4 0 0.00 222775 634525 415476 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4962 4962 0 0.00 0 14925 165 0 0
t$perf-norm:sp_cancel_adding_invoice 407 407 0 0.00 0 1654 78 0 0
t$perf-norm:sp_cancel_client_order 1665 1665 0 0.00 0 5187 13 0 0
t$perf-norm:sp_cancel_customer_reserve 692 692 0 0.00 0 1748 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 682 682 0 0.00 0 1155 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 438 438 0 0.00 0 3751 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 380 380 0 0.00 0 7972 42 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 19266 1347 0 0
t$perf-norm:sp_cancel_write_off 983 983 0 0.00 0 8106 17 0 0
t$perf-norm:sp_client_order 19995 19995 0 0.00 0 17806 17 0 0
t$perf-norm:sp_customer_reserve 1014 1014 0 0.00 0 3987 9 0 0
t$perf-norm:sp_pay_from_customer 6858 6858 0 0.00 0 3991 8 0 0
t$perf-norm:sp_pay_to_supplier 5841 5841 0 0.00 0 8900 10 0 0
t$perf-norm:sp_reserve_write_off 9769 9769 0 0.00 0 8664 11 0 0
t$perf-norm:sp_supplier_invoice 5330 5330 0 0.00 0 20318 23 0 0
t$perf-norm:sp_supplier_order 5533 5533 0 0.00 0 4264 14 0 0
t$perf-norm:srv_aggregate_perf_data 114 114 0 0.00 0 789 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 1086 12 0 0
t$perf-norm:srv_make_invnt_saldo 600 600 0 0.00 0 1251 17 0 0
t$perf-norm:srv_make_money_saldo 825 825 0 0.00 0 826 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10156 9922 234 2.30 0 15852 22 0 234
v_all_customers 36172 36172 0 0.00 0 15 1 0 0
v_all_suppliers 30368 30368 0 0.00 0 19 1 0 0
v_all_wares 39986 39986 0 0.00 0 82 1 0 0
v_cancel_adding_invoice 814 814 0 0.00 0 213 5 0 0
v_cancel_client_order 3330 3330 0 0.00 0 15901 12 0 0
v_cancel_customer_prepayment 1364 1364 0 0.00 0 4568 9 0 0
v_cancel_customer_reserve 1384 1384 0 0.00 0 5967 11 0 0
v_cancel_payment_to_supplier 876 876 0 0.00 0 2618 10 0 0
v_cancel_supplier_invoice 772 760 12 1.55 0 9428 50 0 12
v_cancel_supplier_order 842 842 0 0.00 0 3827 12 0 0
v_cancel_write_off 1966 1966 0 0.00 0 9967 24 0 0
v_max_id_clo_ord 5533 5533 0 0.00 0 711 1 0 0
v_max_id_clo_res 1014 1014 0 0.00 0 2273 12 0 0
v_max_id_ord_sup 5320 5320 0 0.00 0 4932 5 0 0
v_max_non_paid_invoice 1510 1510 0 0.00 0 2445 6 0 0
v_max_non_paid_realizn 3818 3818 0 0.00 0 7464 8 0 0
v_min_id_clo_ord 5533 5533 0 0.00 0 3414 7 0 0
v_min_id_clo_res 1014 1014 0 0.00 0 4894 8 0 0
v_min_id_ord_sup 5320 5320 0 0.00 0 5362 8 0 0
v_min_non_paid_invoice 5841 5841 0 0.00 0 8918 18 0 0
v_min_non_paid_realizn 6858 6858 0 0.00 0 7953 18 0 0
v_our_firm 9894 9894 0 0.00 0 19 1 0 0
v_reserve_write_off 19538 19538 0 0.00 0 20316 10 0 0
x_lock_depdocs_on_canc_invoice 12237 12237 0 0.00 0 16510 111 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 3624 311 0 0
x_make_qstorno_1000_1200 5533 5533 0 0.00 1 77988 1157 0 0
x_make_qstorno_1200_2000 5329 5329 0 0.00 3 106196 3290 0 0
x_make_qstorno_2100_3300 468582 468582 0 0.00 0 89951 146 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-11-2020 16:32:09 to 07-11-2020 16:32:13.

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
14:01:04 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:01:10 15985 8192000000 10233000240 10536423424 855344608 9.454 68 51 104 0 874977056 2366768 17265680
14:01:34 23276 8192000000 10327120720 10643726336 1372839824 14.352 100 88 176 0 1407091472 4409216 29842432
14:02:04 37627 8192000000 10372623104 10692427776 1411303520 14.696 100 91 182 0 1447047040 5944224 29799296
14:02:49 34845 8192000000 10410734784 10736574464 1449507888 15.034 100 86 172 0 1484826544 7513936 27804720
14:03:36 28172 8192000000 10432791568 10765017088 1483095744 15.329 100 86 172 2 1518952784 8421712 27435328
14:04:14 22424 8192000000 10447222816 10783301632 1500493744 15.480 100 85 170 0 1536367920 8986288 26887888
14:04:45 9719 8192000000 10470707440 10808172544 1526952528 15.711 100 89 178 1 1564752928 10135312 27665088
14:05:05 16485 8192000000 10486244240 10831523840 1535290928 15.783 100 77 154 0 1568595872 9740336 23564608
14:05:34 14963 8192000000 10501925824 10855743488 1567162384 16.058 100 77 152 1 1600443296 10046496 23234416
14:05:59 12239 8192000000 10539168944 10892775424 1595232064 16.299 100 77 154 1 1629650192 11421584 22996544
14:06:19 12407 8192000000 10555035072 10915307520 1617424352 16.488 100 76 150 2 1651272512 11557312 22290848
14:06:44 10771 8192000000 10588988464 10949287936 1646334192 16.733 100 78 157 0 1681490880 12076480 23080208
14:07:02 10684 8192000000 10619189344 10982412288 1668112512 16.917 100 81 162 1 1703898496 12571776 23214208
14:07:22 7950 8192000000 10625408960 10996047872 1682795200 17.041 100 78 156 1 1717864352 12418768 22650384
14:07:39 9463 8192000000 10649128976 11019128832 1707839920 17.251 100 81 163 0 1743049552 12531504 22678128
14:07:57 8385 8192000000 10668020000 11039682560 1720795056 17.359 100 80 160 0 1756686288 13310144 22581088
14:08:13 8623 8192000000 10671199968 11048349696 1736175408 17.487 100 82 163 0 1771206304 12649392 22381504
14:08:28 5427 8192000000 10691208448 11064254464 1752224384 17.620 100 86 172 1 1789868384 13666256 23977744
14:08:41 4836 8192000000 10702015120 11080052736 1755026032 17.643 100 82 165 2 1791987024 13940816 23020176
14:08:54 4333 8192000000 10709765552 11087355904 1768105696 17.751 100 73 146 0 1801882928 13224112 20553120
14:09:07 2715 8192000000 10722947696 11099299840 1779470144 17.845 100 87 174 2 1817524448 13862352 24191952
14:09:16 3401 8192000000 10729114512 11106574336 1782629136 17.871 100 80 159 1 1818039744 13994304 21416304
14:09:26 3371 8192000000 10735996080 11113017344 1792301968 17.951 100 84 164 0 1828042016 13502128 22237920
14:09:36 4025 8192000000 10738208912 11120230400 1796302832 17.984 100 81 162 0 1833089008 13591680 23194496
14:09:46 2649 8192000000 10742791168 11125665792 1804992000 18.055 100 87 174 0 1847577696 17337376 25248320
14:09:56 2387 8192000000 10751005280 11135815680 1808240704 18.081 100 83 166 1 1844622560 12721552 23660304
14:10:05 4622 8192000000 10743298096 11135700992 1809409200 18.091 100 77 150 1 1842687344 12493040 20785104
14:10:18 5149 8192000000 10756510720 11147190272 1816188736 18.147 100 78 156 1 1851325840 13013824 22123280
14:10:29 2502 8192000000 10777874656 11162284032 1832056160 18.276 100 92 184 1 1872076240 13570400 26449680
14:10:38 2378 8192000000 10777259872 11167809536 1837455664 18.320 100 90 176 1 1876099504 12979136 25664704
14:10:47 2193 8192000000 10787498048 11176562688 1848802144 18.412 100 90 177 1 1886784752 13255392 24727216
14:10:56 2005 8192000000 10787938336 11173462016 1848145376 18.407 100 87 174 0 1885764048 13438080 24180592
14:11:05 1972 8192000000 10787731632 11181215744 1851120416 18.431 100 83 166 1 1886394032 11511248 23762368
14:11:14 2386 8192000000 10801089376 11188764672 1857959872 18.487 100 94 188 0 1897949728 12575216 27414640
14:11:23 2128 8192000000 10800198832 11187810304 1861514464 18.516 100 94 189 0 1901183136 12753744 26914928
14:11:31 1324 8192000000 10805353584 11195908096 1862911296 18.527 100 94 186 0 1903016240 13789856 26315088
14:11:39 1497 8192000000 10811080352 11200159744 1864415712 18.539 100 90 181 0 1903490016 13300688 25773616
14:11:47 26167 8192000000 10804002624 11194232832 1862182608 18.521 100 73 143 3 1892491200 10539744 19768848
14:12:19 21230 8192000000 10773128704 11188981760 1855883376 18.470 100 35 70 1 1874682672 8857968 9941328
14:12:47 6406 8192000000 10771396544 11196473344 1861705664 18.517 100 30 62 1 1877211168 7331872 8173632
14:13:01 6166 8192000000 10765363760 11193315328 1861481312 18.515 100 28 55 1 1875996544 6285616 8229616
14:13:14 3473 8192000000 10780759808 11196280832 1865160160 18.545 100 48 96 2 1884765888 5678768 13926960
14:13:26 11950 8192000000 10770452288 11200294912 1864188016 18.537 100 14 26 2 1874222848 5802448 4232384
14:13:46 12607 8192000000 10768795104 11203801088 1868530848 18.572 100 19 35 1 1879728576 6079200 5118528
14:14:05 8734 8192000000 10783956656 11209932800 1870493248 18.588 100 22 44 1 1883000992 6654544 5853200
14:14:22 11474 8192000000 10771675360 11211067392 1872638592 18.606 100 24 48 1 1885911152 6290928 6981632
14:14:40 7376 8192000000 10784899200 11213856768 1876854464 18.640 100 22 44 0 1889084336 5865504 6364368
14:14:53 8977 8192000000 10793384176 11217866752 1877210176 18.643 100 21 42 0 1889389904 6225088 5954640
14:15:14 10023 8192000000 10789127200 11218862080 1877801280 18.647 100 12 24 0 1886622112 5881456 2939376
14:15:37 11078 8192000000 10791336320 11222044672 1882584240 18.686 100 20 40 1 1893501088 5275664 5641184
14:15:56 65575 8192000000 10818515264 11240759296 1888895376 18.737 100 31 62 1 1904768096 6064160 9808560
14:17:14 12348 8192000000 10806253712 11242606592 1893202096 18.772 100 11 22 1 1901905568 5507680 3195792
14:17:34 4213 8192000000 10811373424 11244998656 1896685488 18.800 100 30 60 2 1911576896 7054368 7837040
14:17:46 6814 8192000000 10812938096 11246718976 1897642912 18.807 100 24 48 0 1911012976 6470352 6899712
14:18:01 6136 8192000000 10814485504 11248218112 1897135184 18.803 100 25 50 1 1910411408 6710528 6565696
14:18:13 8385 8192000000 10808556416 11248316416 1901933184 18.842 100 22 43 5 1914198784 6135712 6129888
14:18:28 5083 8192000000 10809499056 11251359744 1905829088 18.873 100 28 56 1 1919641984 5632320 8180576
14:18:40 5895 8192000000 10809504752 11252461568 1903185120 18.852 100 19 38 0 1914495616 6253296 5057200
14:18:54 6384 8192000000 10819054656 11249442816 1898655456 18.815 100 29 58 0 1913391424 5515168 9220800
14:19:06 9509 8192000000 10815953600 11245748224 1897176352 18.804 100 17 32 1 1907220224 5792432 4251440
14:19:24 8067 8192000000 10806508560 11237396480 1880176112 18.667 99 27 52 3 1894092128 6262752 7653264
14:19:40 11005 8192000000 10801304864 11234652160 1874631264 18.622 99 15 30 1 1885002800 6056768 4314768
14:19:59 8825 8192000000 10786908480 11226198016 1866783728 18.558 99 15 30 0 1876789840 5292944 4713168
14:20:14 13873 8192000000 10773855456 11205107712 1826806848 18.233 97 21 42 1 1837931584 5475696 5649040
14:20:35 24529 8192000000 10740925680 11166871552 1736982400 17.494 93 23 44 2 1747270032 4404832 5882800
14:21:42 17214 8192000000 10739572720 11174985728 1791861440 17.947 97 21 42 0 1803170256 4945552 6363264
14:22:06 12829 8192000000 10720982624 11138158592 1693301456 17.129 92 23 46 1 1705990384 5339024 7349904
14:22:31 4309 8192000000 10717313264 11127742464 1789791280 17.930 99 34 68 0 1806535040 6736576 10007184
14:22:41 4775 8192000000 10719685952 11136618496 1789094704 17.924 99 32 64 1 1805260128 6978080 9187344
14:22:54 6580 8192000000 10721450080 11139743744 1768398288 17.754 97 26 51 4 1781451056 5707520 7345248
14:23:09 6263 8192000000 10691320288 11094859776 1681465792 17.030 93 31 61 0 1695801984 5941952 8394240
14:23:24 5941 8192000000 10713824992 11134582784 1772158912 17.785 98 29 58 0 1788574864 7510112 8905840
14:23:37 10753 8192000000 10701248832 11117187072 1707038224 17.244 94 18 36 0 1718859472 5188736 6632512
14:23:55 10335 8192000000 10698609888 11116621824 1715227616 17.312 95 27 55 1 1729765216 5799728 8737872
14:24:13 9596 8192000000 10682185984 11103305728 1739390432 17.514 97 24 48 0 1752129200 5811584 6927184
14:24:29 8202 8192000000 10703234416 11116400640 1757192400 17.661 98 32 64 0 1773132976 6482752 9457824
14:24:46 8377 8192000000 10694913744 11112632320 1755108640 17.644 98 23 46 3 1768276576 6286848 6881088
14:25:01 7572 8192000000 10719641824 11141099520 1803155152 18.040 100 30 60 1 1817576320 4948688 9472480
14:25:15 8498 8192000000 10723620384 11137843200 1771436768 17.779 98 21 41 1 1782250768 5001296 5812704
14:25:32 64493 8192000000 10738086784 11166269440 1828676880 18.249 100 33 66 2 1844133136 5543936 9912320
14:26:42 10169 8192000000 10748444112 11167408128 1816623152 18.150 99 30 60 2 1831031696 6309616 8098928
14:27:00 7182 8192000000 10746109968 11174223872 1833403888 18.287 100 19 37 1 1844649344 5865280 5380176
14:27:13 7208 8192000000 10757417376 11182055424 1840318544 18.343 100 17 33 1 1850177760 5326160 4533056
14:27:28 5780 8192000000 10767023248 11190362112 1850163408 18.423 100 30 59 1 1865004192 6419680 8421104
14:27:41 6609 8192000000 10767593936 11194818560 1855668976 18.468 100 35 71 1 1871673376 5844064 10160336
14:27:54 6062 8192000000 10776230128 11200712704 1853943520 18.454 100 21 42 1 1865920304 6389792 5586992
14:28:10 4705 8192000000 10781614400 11201515520 1860414704 18.507 100 32 64 0 1876229824 6126752 9688368
14:28:21 7771 8192000000 10772976656 11201269760 1860754272 18.509 100 21 42 1 1872729456 5290448 6684736
14:28:37 7694 8192000000 10773950432 11207245824 1863820464 18.534 100 24 47 4 1875994144 5305552 6868128
14:28:52 8477 8192000000 10780703024 11207102464 1866979536 18.560 100 19 38 1 1879076576 6127744 5969296
14:29:07 8572 8192000000 10786523856 11213524992 1867288976 18.562 100 25 50 0 1880967232 5282032 8396224
14:29:23 8672 8192000000 10785328672 11213291520 1871252624 18.594 100 27 54 3 1884140912 5245376 7642912
14:29:41 11389 8192000000 10780768768 11214782464 1868023440 18.568 100 10 19 0 1875801584 5071632 2706512
14:29:58 12716 8192000000 10786778608 11224035328 1877659568 18.646 100 19 38 1 1889629968 6580672 5389728
14:30:19 55614 8192000000 10788248800 11223506944 1865875696 18.551 99 35 70 2 1883276192 5641648 11758848
14:31:23 86699 8192000000 10836105024 11262464000 1907370128 18.886 100 41 82 0 1927314912 8256896 11687888
14:33:01 32399 8192000000 10861241216 11286749184 1926749968 19.041 100 32 64 0 1945586944 9780608 9056368
14:33:44 31962 8192000000 10874241280 11302985728 1941133952 19.156 100 44 88 0 1968006976 14248384 12624640
14:34:23 22023 8192000000 10878807056 11313360896 1951562160 19.239 100 42 81 3 1978053104 13994592 12496352
14:34:53 32079 8192000000 10895416256 11327242240 1950937792 19.234 100 32 63 1 1974062208 14132880 8991536
14:35:36 37934 8192000000 10892293760 11326099456 1959966880 19.306 100 35 70 1 1986554432 16553216 10034336
14:36:21 11063 8192000000 10904951312 11335274496 1966489872 19.358 100 51 102 0 2000013648 18834192 14689584
14:36:39 6252 8192000000 10897434960 11327569920 1947267920 19.205 99 53 105 1 1981470736 18692656 15510160
14:36:59 8483 8192000000 10907156704 11332280320 1963047904 19.330 100 54 106 2 1997904528 19218032 15638592
14:37:18 18780 8192000000 10915855664 11346038784 1970295296 19.388 100 54 107 1 2008107456 22117472 15694688
14:37:59 11604 8192000000 10933744912 11364306944 1980108752 19.466 100 52 104 0 2021565792 25923136 15533904
14:38:20 10741 8192000000 10927163168 11361275904 1967473168 19.365 99 56 112 1 2014200288 29281520 17445600
14:38:39 7873 8192000000 10940405984 11368349696 1981672192 19.478 100 49 98 1 2031051872 34701408 14678272
14:39:10 6762 8192000000 10952750464 11376107520 1991699440 19.557 100 58 114 1 2040156704 31180208 17277056
14:39:24 10998 8192000000 10940468720 11372240896 1972808688 19.408 99 49 98 1 2019732016 32229904 14693424
14:39:44 11769 8192000000 10938077344 11369558016 1968874368 19.377 99 49 98 0 2015418144 31447344 15096432
14:40:05 7309 8192000000 10953252032 11382431744 1992864736 19.566 100 49 98 3 2043152384 35632304 14655344
14:40:19 4297 8192000000 10954723584 11388325888 1998033584 19.607 100 54 106 1 2050219136 36338048 15847504
14:40:36 3807 8192000000 10943546976 11370106880 1980034400 19.465 100 49 96 3 2029422288 34284576 15103312
14:40:58 7158 8192000000 10970633504 11393191936 1991688288 19.557 100 54 108 4 2045032688 37110656 16233744
14:41:12 3941 8192000000 10974456288 11396747264 1984008000 19.496 99 71 140 0 2046214256 40270944 21935312
14:41:23 2638 8192000000 10968374224 11385761792 1989602464 19.541 100 72 143 2 2050963808 39303456 22057888
14:41:33 4132 8192000000 10976110112 11398410240 1998795616 19.613 100 72 145 2 2061559312 41465104 21298592
14:41:46 3017 8192000000 10974645792 11393052672 1993994832 19.575 100 77 154 0 2060212800 42696208 23521760
14:41:59 4472 8192000000 10964783248 11392409600 1991891584 19.559 100 65 130 2 2056109920 43445344 20772992
14:42:14 5906 8192000000 10971935568 11397619712 1998067408 19.607 100 63 126 2 2060656288 43324208 19264672
14:42:30 3960 8192000000 10950558208 11368714240 1960444592 19.310 98 60 118 0 2021056912 41961088 18651232
14:42:41 8944 8192000000 10947893584 11371491328 1949075552 19.219 98 60 120 1 2010464656 42771360 18617744
14:43:00 3966 8192000000 10961051280 11384168448 1983907024 19.496 100 62 122 2 2048359152 44381504 20070624
14:43:13 6085 8192000000 10979648896 11397173248 1993912528 19.575 100 73 146 1 2061398944 44890896 22595520
14:43:29 5160 8192000000 10963977376 11385946112 1973425536 19.413 99 66 132 1 2039404320 45388192 20590592
14:43:41 2658 8192000000 10988024704 11403091968 1999465568 19.619 100 80 161 1 2071296144 46727008 25103568
14:43:51 7718 8192000000 10957792048 11371859968 1965111280 19.347 99 75 146 2 2034407600 47370320 21926000
14:44:11 2656 8192000000 10967487184 11374100480 1970538960 19.390 99 89 176 2 2045810976 48505360 26766656
14:44:21 8745 8192000000 10981785584 11400859648 1990847248 19.550 100 75 150 1 2067666672 53293520 23525904
14:44:41 4816 8192000000 10984647312 11411980288 1995015232 19.583 100 63 126 2 2066319904 50782656 20522016
14:44:55 6958 8192000000 10974488336 11397947392 1987109120 19.521 100 68 137 0 2058696288 49592960 21994208
14:45:10 3965 8192000000 10990742064 11409022976 1997021008 19.599 100 74 148 3 2071478672 50450384 24007280
14:45:24 6214 8192000000 10960702000 11375796224 1964504912 19.342 99 78 156 1 2040775648 51714400 24556336
14:45:40 6885 8192000000 10987140512 11404005376 1987646416 19.525 100 80 160 1 2066622688 53808864 25167408
14:45:53 3857 8192000000 10974331376 11392872448 1981266752 19.475 100 76 151 0 2064054640 58501200 24286688
14:46:04 7065 8192000000 10972294048 11384369152 1957630528 19.287 99 84 168 0 2044836176 60757936 26447712
14:46:20 2921 8192000000 10988584608 11394580480 1973299296 19.412 100 82 164 2 2062666160 63657520 25709344
14:46:34 2673 8192000000 10970939312 11379523584 1935084736 19.108 98 87 174 2 2029479712 67014400 27380576
14:46:47 2094 8192000000 10971792192 11377836032 1944521536 19.183 99 85 168 0 2038505280 67426736 26557008
14:46:58 2918 8192000000 10972341392 11385225216 1948088832 19.211 99 83 165 0 2041275280 67785440 25401008
14:47:08 2983 8192000000 10956681936 11363426304 1943537632 19.175 100 87 174 2 2036300512 66310992 26451888
14:47:17 2505 8192000000 10957920400 11371122688 1950710976 19.232 100 81 162 1 2043386848 67061200 25614672
14:47:27 2266 8192000000 10968618176 11375747072 1955699696 19.272 100 86 171 1 2050339200 68154080 26485424
14:47:35 2804 8192000000 10978211040 11383189504 1956668384 19.280 100 87 175 2 2055888816 71821984 27398448
14:47:45 1603 8192000000 10957289312 11354828800 1939689168 19.144 99 94 186 1 2036551184 66894544 29967472
14:47:55 3280 8192000000 10970269008 11384016896 1965094128 19.347 100 82 164 1 2059320176 68393344 25832704
14:48:07 3638 8192000000 10967658544 11386806272 1962555360 19.326 100 68 135 0 2051596208 67290416 21750432
14:48:21 4306 8192000000 10957748224 11366551552 1943506640 19.175 99 71 141 2 2037165536 70778304 22880592
14:48:32 1940 8192000000 10979988944 11391098880 1964676208 19.343 100 85 171 0 2064304080 72073248 27554624
14:48:41 5491 8192000000 10974959360 11389779968 1961875296 19.321 100 66 132 0 2055317488 72137248 21304944
14:48:54 6402 8192000000 10976759904 11396579328 1966398352 19.357 100 59 118 3 2055504896 69492912 19613632
14:49:13 5732 8192000000 10946939136 11373031424 1934645136 19.104 99 49 98 0 2016139472 65737824 15756512
14:49:29 3866 8192000000 10966978144 11387441152 1964583056 19.342 100 65 127 1 2051927648 66648416 20696176
14:49:43 2964 8192000000 10976220688 11391954944 1968196736 19.371 100 81 163 0 2060641568 65823584 26621248
14:49:55 4328 8192000000 10974110560 11390193664 1965382976 19.349 100 65 131 0 2052336288 65961568 20991744
14:50:06 6472 8192000000 10960958720 11383480320 1954880400 19.265 100 54 108 0 2040504640 68010768 17613472
14:50:21 4633 8192000000 10949230768 11380019200 1951305248 19.237 100 55 108 0 2038181840 68992512 17884080
14:50:36 7118 8192000000 10945962000 11376496640 1952837040 19.249 100 48 95 3 2034169088 65329024 16003024
14:50:50 5879 8192000000 10962518368 11394838528 1965552128 19.350 100 49 98 1 2043082688 61278320 16252240
14:51:02 7533 8192000000 10952107200 11383001088 1951662160 19.240 100 40 80 2 2031300672 66159520 13478992
14:51:16 11562 8192000000 10936488320 11372359680 1933518928 19.095 99 35 70 3 2011871328 66021248 12331152
14:51:35 22164 8192000000 10939085584 11371429888 1921177440 18.996 99 41 82 1 2006637408 71212576 14247392
14:52:13 11078 8192000000 10942424976 11389935616 1946794400 19.201 100 40 80 0 2037938032 76951536 14192096
14:52:45 20231 8192000000 10935917984 11377188864 1916473776 18.959 98 34 68 0 1992509184 63667120 12368288
14:53:19 12289 8192000000 10937867504 11384709120 1948137888 19.212 100 33 66 2 2023956800 64593376 11225536
14:53:38 21363 8192000000 10946679936 11394215936 1948085328 19.211 100 28 56 1 2027582432 68598736 10898368
14:54:07 17839 8192000000 10918462752 11367518208 1926934320 19.042 99 34 68 2 2006395328 67164080 12296928
14:54:47 21479 8192000000 10932156032 11392016384 1949874464 19.225 100 26 52 2 2026624736 66861664 9888608
14:55:15 21476 8192000000 10936876928 11392262144 1947941728 19.210 100 32 64 2 2026990000 67434880 11613392
14:55:43 9489 8192000000 10941053360 11403890688 1942860544 19.170 100 25 50 0 2027677040 74736176 10080320
14:56:03 16446 8192000000 10906105520 11356999680 1885997120 18.714 97 24 48 3 1958139072 63253968 8887984
14:56:28 38493 8192000000 10924190576 11393986560 1944305072 19.181 100 34 68 0 2016096288 60248832 11542384
14:57:13 69755 8192000000 10886082256 11359154176 1937577760 19.127 99 11 22 0 1962324736 21338448 3408528
14:58:43 42274 8192000000 10890106464 11354439680 1956717568 19.280 100 28 56 2 1977962512 13742880 7502064
14:59:55 97856 8192000000 10880059648 11343155200 1916922720 18.962 98 19 38 1 1938636368 16353728 5359920
15:01:40 18869 8192000000 10893985712 11353772032 1933155328 19.092 99 35 72 0 1969369360 26577984 9636048
15:02:15 75889 8192000000 10869140608 11334553600 1932151792 19.084 99 17 34 0 1954032688 17097632 4783264
15:03:37 80197 8192000000 10871049328 11337281536 1893405632 18.773 97 8 16 0 1904360656 9332144 1622880
15:05:49 44579 8192000000 10864519472 11335127040 1936297504 19.117 100 6 12 0 1953071280 15260704 1513072
15:06:40 34991 8192000000 10862506880 11315474432 1894756928 18.784 97 19 38 0 1909774128 9843968 5173232
15:07:26 75016 8192000000 10865721360 11331813376 1942044880 19.163 100 27 54 1 1961711504 11381936 8284688
15:09:38 111440 8192000000 10896253568 11372146688 1954561568 19.263 100 9 18 1 1978037104 21115008 2360528
15:11:36 66823 8192000000 10912526144 11380543488 1952115360 19.243 99 23 46 2 1979766672 20546160 7105152
15:12:56 127323 8192000000 10908442736 11366846464 1938909856 19.138 98 13 26 1 1958578992 16048352 3620784
15:15:10 30600 8192000000 10908644448 11373092864 1981585872 19.477 100 36 69 1 1998868000 8004096 9278032
15:15:59 64663 8192000000 10918225568 11390107648 1989893456 19.543 100 21 42 0 2006961440 11243168 5824816
15:17:11 34940 8192000000 10922165232 11386109952 1988481680 19.532 100 12 24 0 1999396640 7852880 3062080
15:17:57 53243 8192000000 10924946400 11383717888 1975612144 19.430 99 18 34 2 1989283536 8517520 5153872
15:19:02 55489 8192000000 10926842288 11387047936 1965363056 19.349 98 27 54 0 1983364064 10148944 7852064
15:20:04 80625 8192000000 10923156240 11391295488 1954281120 19.261 98 17 34 0 1975812880 16357184 5174576
15:21:37 80537 8192000000 10909935600 11397820416 1939652112 19.144 97 22 44 1 1957430624 11877264 5901248
15:23:05 98559 8192000000 10930093744 11411087360 1973725584 19.415 99 8 16 0 1990114848 14360304 2028960
15:25:02 98451 8192000000 10939351200 11396190208 1999385376 19.618 100 28 55 3 2018124704 10414784 8324544
15:27:18 46683 8192000000 10947305856 11405451264 1977205552 19.443 98 39 78 3 1994591104 6225904 11159648
15:28:18 66695 8192000000 10924154256 11405467648 1999227664 19.617 100 25 50 1 2020803200 14513200 7062336
15:29:32 11340 8192000000 10906979568 11382243328 1975319328 19.428 99 6 12 0 1991297552 13821280 2156944
15:30:17 25830 8192000000 10897873312 11368988672 1942487456 19.167 98 36 73 1 1968297264 15922336 9887472
15:31:08 42975 8192000000 10905184768 11369734144 1943027936 19.171 98 15 30 1 1959812512 13037808 3746768
15:32:06 57037 8192000000 10908448576 11381694464 1965903152 19.353 99 20 40 0 1988863616 17721680 5238784
15:33:10 29035 8192000000 10902956656 11384336384 1980082912 19.465 100 13 26 1 2003912176 20093968 3735296
15:33:47 25805 8192000000 10909432384 11389751296 1981520928 19.477 100 12 24 0 2003731312 19181424 3028960
15:35:06 45244 8192000000 10879661312 11364868096 1935491008 19.111 98 27 54 3 1954632032 11805424 7335600
15:35:59 54541 8192000000 10878100064 11357876224 1909447344 18.902 97 9 18 0 1920097744 8406768 2243632
15:37:00 44709 8192000000 10883621536 11354484736 1890130720 18.747 96 10 19 1 1902524288 9454256 2939312
15:38:06 30130 8192000000 10875537776 11326386176 1907017376 18.883 98 32 62 0 1926531984 10771312 8743296
15:38:46 62053 8192000000 10844383104 11313516544 1849255440 18.416 95 21 42 0 1867440160 12163504 6021216
15:40:20 33027 8192000000 10869698512 11310792704 1873530976 18.613 97 38 74 3 1892326912 8113680 10682256
15:41:00 13665 8192000000 10875403424 11311771648 1911028992 18.915 99 60 120 1 1937919824 9246016 17644816
15:41:22 42557 8192000000 10855271520 11313512448 1888472768 18.733 98 32 64 1 1912805744 15549392 8783584
15:42:12 67001 8192000000 10856679584 11321012224 1849001904 18.414 96 15 30 1 1865952608 13049952 3900752
15:43:25 46348 8192000000 10847416848 11304239104 1871465040 18.596 97 31 62 0 1890755824 10413472 8877312
15:44:25 102098 8192000000 10845736096 11325804544 1872534064 18.605 97 6 12 0 1887430272 13240144 1656064
15:46:21 64127 8192000000 10887159088 11353337856 1950554144 19.231 100 24 48 0 1971548752 14381584 6613024
15:47:32 28011 8192000000 10894563008 11351326720 1937471088 19.127 99 25 50 0 1958162000 13606464 7084448
15:48:08 57645 8192000000 10888719136 11353403392 1922009232 19.003 98 29 58 0 1944189856 14529104 7651520
15:49:12 103641 8192000000 10877428816 11331289088 1874299584 18.619 96 18 36 1 1891326704 12051088 4976032
15:51:09 85286 8192000000 10849022336 11301462016 1846650464 18.395 95 29 58 1 1865405984 10731520 8024000
15:52:40 46491 8192000000 10845851648 11304706048 1901383184 18.837 98 36 71 0 1923691968 12433072 9875712
15:53:35 17203 8192000000 10878647744 11325644800 1922504800 19.007 99 51 101 3 1949161984 11982224 14674960
15:54:00 43335 8192000000 10882543392 11343015936 1947285952 19.205 100 33 66 1 1967944144 11450368 9207824
15:54:49 52994 8192000000 10861399376 11340189696 1915649648 18.952 98 21 42 0 1932808352 11523584 5635120
15:55:55 45021 8192000000 10846502176 11319349248 1866240576 18.554 96 10 19 0 1879819264 10758160 2820528
15:56:47 43392 8192000000 10866366864 11334746112 1900224544 18.828 98 16 31 0 1915447744 10612624 4610576
15:57:37 56530 8192000000 10864430080 11345862656 1941137408 19.156 100 10 20 0 1956937136 12287184 3512544
15:58:44 56748 8192000000 10854779040 11335753728 1906394464 18.878 98 7 14 0 1920241744 11880000 1967280
15:59:47 63253 8192000000 10870161808 11356868608 1948350992 19.213 100 28 57 0 1967415056 11105808 7958256
16:00:58 46440 8192000000 10887661184 11356463104 1942493056 19.167 99 19 37 1 1956548976 8860080 5195840
16:01:51 40380 8192000000 10897639568 11359096832 1945770960 19.193 99 21 41 1 1960545088 8915024 5859104
16:02:52 34425 8192000000 10910545840 11372503040 1970316944 19.388 100 23 46 2 1985860544 9139664 6403936
16:03:44 51531 8192000000 10908955104 11385090048 1974008384 19.417 100 15 30 0 1989125456 11383024 3734048
16:04:43 51038 8192000000 10929329616 11397419008 1994884864 19.582 100 33 65 2 2016867216 13191328 8791024
16:05:47 97601 8192000000 10893590144 11357401088 1882188000 18.683 95 6 12 0 1896529776 12090816 2250960
16:07:33 71649 8192000000 10910855568 11396259840 1973217376 19.411 100 18 35 2 1987539216 9362736 4959104
16:08:53 92083 8192000000 10922593344 11399581696 1951923984 19.242 98 10 20 1 1963438176 9051216 2462976
16:10:33 100368 8192000000 10908904240 11391336448 1898496560 18.814 95 4 8 0 1912176576 12712736 967280
16:12:21 100804 8192000000 10884575664 11355688960 1885277296 18.708 95 16 32 2 1897278800 7744208 4257296
16:14:16 106932 8192000000 10907268128 11383975936 1931223264 19.077 98 25 50 1 1946987792 7698288 8066240
16:16:10 91379 8192000000 10875672912 11333378048 1826503760 18.231 92 28 56 4 1845342528 11454912 7383856
16:17:52 58701 8192000000 10877503696 11348340736 1921375360 18.998 98 16 32 0 1933239904 7289456 4575088
16:18:58 34985 8192000000 10866763856 11342651392 1927358704 19.046 98 15 30 0 1939924960 8614784 3951472
16:19:48 47669 8192000000 10878693344 11355250688 1957581136 19.287 100 10 20 0 1966990128 6749152 2659840
16:20:41 66912 8192000000 10887310288 11365539840 1930140832 19.068 98 18 36 1 1946139360 11085216 4913312
16:22:36 78782 8192000000 10879003200 11351576576 1948058272 19.211 99 17 33 1 1963415040 10277760 5079008
16:24:01 10303 8192000000 10903086112 11370762240 1969062672 19.378 100 22 42 0 1994473776 18792976 6618128
16:24:18 49282 8192000000 10866455584 11340259328 1876481696 18.637 95 14 28 0 1891745600 10950032 4313872
16:25:14 63579 8192000000 10823501600 11287601152 1774290048 17.802 91 17 34 1 1786630528 7595328 4745152
16:26:29 53615 8192000000 10846801904 11305254912 1879237792 18.659 98 22 44 3 1895855008 10801440 5815776
16:27:30 53038 8192000000 10833485712 11305697280 1860853472 18.510 97 16 32 0 1878591776 13167712 4570592
16:28:31 102710 8192000000 10854168752 11307548672 1893255040 18.772 98 24 48 0 1911169408 10846960 7067408
16:30:20 47791 8192000000 9187397248 9429884928 351681152 4.116 18 6 12 0 355872864 2766016 1425696

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 07-11-2020 16:32:14 to 07-11-2020 16:32:45.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-11-2020 16:32:46 to 07-11-2020 16:32:48.

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          242557
MON$OLDEST_ACTIVE               242558
MON$OLDEST_SNAPSHOT             242558
MON$NEXT_TRANSACTION            242558
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                       2020800
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sat Nov  7 16:31:14 2020
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Sat Nov  7 16:31:14 2020
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Sat Nov  7 16:31:15 2020
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:17: 
--- end of diff output ---

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

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