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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-12 19:26:59
DTS_END                         2020-11-12 19:26:59.0260
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48102
TRN_ID                          235425
ATT_ID                          701
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: 8997.54 22657 1079705
customer order: creation 171.64 340 20597
customer order: refuse 14.38 362 1726
order to supplier: creation 45.13 1241 5416
order to supplier: removal 3.38 100695 406
invoice (draft): creation 45.32 3297 5438
invoice (draft): removal 49.73 820 5968
invoice accept: apply 41.24 19716 4949
invoice accept: cancel 44.91 809 5389
customer reserve: creation 3808.43 195 457012
customer reserve: removal 4485.65 59 538278
realization accept: apply 82.62 179 9914
realization accept: cancel 77.42 122 9290
payment from customer: creation 57.63 109 6916
payment from customer: removal 5.83 85 700
payment to supplier: creation 48.33 130 5800
payment to supplier: removal 3.53 71 424
service: total inventory turnovers 5.00 1038 600
service: total monetary turnovers 6.58 36 789
service: aggregate perf. data 0.74 23981 89
service: refresh index statistics 0.03 299860 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-11-2020 19:28:11 to 12-11-2020 19:28:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3299
TEST_TIME 2 3154
TEST_TIME 3 3161
TEST_TIME 4 3349
TEST_TIME 5 3874
TEST_TIME 6 3933
TEST_TIME 7 4378
TEST_TIME 8 4463
TEST_TIME 9 4740
TEST_TIME 10 5430
TEST_TIME 11 5790
TEST_TIME 12 5813
TEST_TIME 13 5880
TEST_TIME 14 5959
TEST_TIME 15 6096
TEST_TIME 16 6543
TEST_TIME 17 6571
TEST_TIME 18 6665
TEST_TIME 19 6777
TEST_TIME 20 7046
TEST_TIME 21 7634
TEST_TIME 22 7740
TEST_TIME 23 8585
TEST_TIME 24 8988
TEST_TIME 25 9361
TEST_TIME 26 9382
TEST_TIME 27 9681
TEST_TIME 28 9976
TEST_TIME 29 9982
TEST_TIME 30 10417
TEST_TIME 31 10457
TEST_TIME 32 10316
TEST_TIME 33 10116
TEST_TIME 34 9842
TEST_TIME 35 9949
TEST_TIME 36 9798
TEST_TIME 37 9663
TEST_TIME 38 9729
TEST_TIME 39 9748
TEST_TIME 40 9805
TEST_TIME 41 9671
TEST_TIME 42 9708
TEST_TIME 43 9629
TEST_TIME 44 9502
TEST_TIME 45 9365
TEST_TIME 46 9355
TEST_TIME 47 9400
TEST_TIME 48 9241
TEST_TIME 49 9231
TEST_TIME 50 9330
TEST_TIME 51 9204
TEST_TIME 52 9130
TEST_TIME 53 9135
TEST_TIME 54 9205
TEST_TIME 55 9181
TEST_TIME 56 9229
TEST_TIME 57 9250
TEST_TIME 58 9260
TEST_TIME 59 9357
TEST_TIME 60 9311
TEST_TIME 61 9326
TEST_TIME 62 9482
TEST_TIME 63 9416
TEST_TIME 64 9509
TEST_TIME 65 9482
TEST_TIME 66 9478
TEST_TIME 67 9373
TEST_TIME 68 9329
TEST_TIME 69 9270
TEST_TIME 70 9261
TEST_TIME 71 9158
TEST_TIME 72 9167
TEST_TIME 73 9135
TEST_TIME 74 9143
TEST_TIME 75 9122
TEST_TIME 76 9159
TEST_TIME 77 9107
TEST_TIME 78 9085
TEST_TIME 79 9162
TEST_TIME 80 9154
TEST_TIME 81 9178
TEST_TIME 82 9137
TEST_TIME 83 9181
TEST_TIME 84 9342
TEST_TIME 85 9338
TEST_TIME 86 9397
TEST_TIME 87 9426
TEST_TIME 88 9373
TEST_TIME 89 9280
TEST_TIME 90 9269
TEST_TIME 91 9292
TEST_TIME 92 9276
TEST_TIME 93 9238
TEST_TIME 94 9167
TEST_TIME 95 9129
TEST_TIME 96 9170
TEST_TIME 97 9137
TEST_TIME 98 9125
TEST_TIME 99 9185
TEST_TIME 100 9173
TEST_TIME 101 9150
TEST_TIME 102 9149
TEST_TIME 103 9160
TEST_TIME 104 9208
TEST_TIME 105 9176
TEST_TIME 106 9190
TEST_TIME 107 9232
TEST_TIME 108 9234
TEST_TIME 109 9241
TEST_TIME 110 9190
TEST_TIME 111 9146
TEST_TIME 112 9097
TEST_TIME 113 9089
TEST_TIME 114 9039
TEST_TIME 115 9012
TEST_TIME 116 9015
TEST_TIME 117 8992
TEST_TIME 118 9008
TEST_TIME 119 8991
TEST_TIME 120 8999
TEST_TIME 121 8925

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-11-2020 19:28:14 to 12-11-2020 19:28:18.

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 1502273 1502273 0 0.00 0 17969 6 0 0
doc_list_biud 1502271 1502271 0 0.00 0 57998 27 0 0
sp_add_invoice_to_stock 5024 4949 75 1.49 31 195522 19717 0 75
sp_cancel_adding_invoice 5389 5389 0 0.00 5 57530 810 0 0
sp_cancel_client_order 1726 1726 0 0.00 4 12852 362 0 0
sp_cancel_customer_reserve 538278 538278 0 0.00 1 57999 60 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 2 6895 85 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 3 8147 71 0 0
sp_cancel_supplier_invoice 5974 5968 6 0.10 2 25229 821 0 6
sp_cancel_supplier_order 406 406 0 0.00 5 1012778 100696 0 0
sp_cancel_write_off 9290 9290 0 0.00 1 11151 123 0 0
sp_client_order 20597 20597 0 0.00 3 32386 341 0 0
sp_customer_reserve 457012 457012 0 0.00 0 37829 196 0 0
sp_fill_shopping_cart 31449 31449 0 0.00 1 22056 39 0 0
sp_fill_shopping_cart_clo_res 457009 457009 0 0.00 0 16702 16 0 0
sp_get_clo_for_invoice 4946 4946 0 0.00 0 25307 266 0 0
sp_kill_cost_storno 15803 15803 0 0.00 0 7779 60 0 0
sp_kill_qstorno_ret_qs2qd 1092220 1092220 0 0.00 0 57990 32 0 0
sp_kill_qty_storno 575917 575917 0 0.00 0 57997 70 0 0
sp_lock_selected_doc 20677 20677 0 0.00 0 9988 6 0 0
sp_make_cost_storno 27576 27576 0 0.00 0 17753 54 0 0
sp_multiply_rows_for_pdistr 27576 27576 0 0.00 0 12661 30 0 0
sp_multiply_rows_for_qdistr 20597 20597 0 0.00 0 32377 163 0 0
sp_pay_from_customer 6916 6916 0 0.00 4 9848 110 0 0
sp_pay_to_supplier 5800 5800 0 0.00 4 18050 131 0 0
sp_payment_common 12716 12716 0 0.00 1 9812 29 0 0
sp_qd_handle_on_cancel_clo 1726 1726 0 0.00 0 12843 339 0 0
sp_qd_handle_on_invoice_upd_sts 10335 10335 0 0.00 0 29962 339 0 0
sp_qd_handle_on_reserve_upd_sts 9914 9914 0 0.00 0 14917 61 0 0
sp_reserve_write_off 9914 9914 0 0.00 6 14943 179 0 0
sp_supplier_invoice 5438 5438 0 0.00 7 82581 3298 0 0
sp_supplier_order 5416 5416 0 0.00 5 30265 1241 0 0
srv_aggregate_perf_data 89 89 0 0.00 2344 457094 23982 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1363 135311 32601 0 0
srv_find_qd_qs_mism 1032177 1032177 0 0.00 0 12708 6 0 0
srv_make_invnt_saldo 600 600 0 0.00 27 81969 1038 0 0
srv_make_money_saldo 789 789 0 0.00 1 4780 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 144045 399044 299860 0 0
t$perf-abend:sp_add_invoice_to_stock 75 75 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4949 4949 0 0.00 0 9885 173 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 1978 73 0 0
t$perf-norm:sp_cancel_client_order 1726 1726 0 0.00 0 5073 15 0 0
t$perf-norm:sp_cancel_customer_reserve 667 667 0 0.00 0 647 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 384 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 1183 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 417 417 0 0.00 0 561 15 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 26198 1572 0 0
t$perf-norm:sp_cancel_write_off 1052 1052 0 0.00 0 5672 18 0 0
t$perf-norm:sp_client_order 20597 20597 0 0.00 0 8102 19 0 0
t$perf-norm:sp_customer_reserve 958 958 0 0.00 0 7361 14 0 0
t$perf-norm:sp_pay_from_customer 6916 6916 0 0.00 0 10386 10 0 0
t$perf-norm:sp_pay_to_supplier 5800 5800 0 0.00 0 8398 11 0 0
t$perf-norm:sp_reserve_write_off 9914 9914 0 0.00 0 12306 11 0 0
t$perf-norm:sp_supplier_invoice 5438 5438 0 0.00 0 4256 20 0 0
t$perf-norm:sp_supplier_order 5416 5416 0 0.00 0 8390 19 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 1741 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 1528 21 0 0
t$perf-norm:srv_make_invnt_saldo 600 600 0 0.00 0 937 25 0 0
t$perf-norm:srv_make_money_saldo 789 789 0 0.00 0 5048 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 11 4 0 0
v_add_invoice_to_stock 10040 9890 150 1.49 0 5475 18 0 150
v_all_customers 37130 37130 0 0.00 0 20 1 0 0
v_all_suppliers 30278 30278 0 0.00 0 14 1 0 0
v_all_wares 41194 41194 0 0.00 0 31 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 2605 14 0 0
v_cancel_client_order 3452 3452 0 0.00 0 2387 5 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 2431 7 0 0
v_cancel_customer_reserve 1334 1334 0 0.00 0 1690 7 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 603 3 0 0
v_cancel_supplier_invoice 846 834 12 1.41 0 2386 16 0 12
v_cancel_supplier_order 812 812 0 0.00 0 1401 6 0 0
v_cancel_write_off 2104 2104 0 0.00 0 7637 15 0 0
v_max_id_clo_ord 5415 5415 0 0.00 0 1123 2 0 0
v_max_id_clo_res 958 958 0 0.00 0 5286 18 0 0
v_max_id_ord_sup 5437 5437 0 0.00 0 5237 5 0 0
v_max_non_paid_invoice 1513 1513 0 0.00 0 424 3 0 0
v_max_non_paid_realizn 3780 3780 0 0.00 0 6705 5 0 0
v_min_id_clo_ord 5415 5415 0 0.00 0 21842 26 0 0
v_min_id_clo_res 958 958 0 0.00 0 3053 8 0 0
v_min_id_ord_sup 5437 5437 0 0.00 0 6041 7 0 0
v_min_non_paid_invoice 5800 5800 0 0.00 0 8228 19 0 0
v_min_non_paid_realizn 6916 6916 0 0.00 0 6709 19 0 0
v_our_firm 10336 10336 0 0.00 0 17 1 0 0
v_reserve_write_off 19826 19826 0 0.00 0 3459 5 0 0
x_lock_depdocs_on_canc_invoice 10940 10940 0 0.00 0 11640 123 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 15809 455 0 0
x_make_qstorno_1000_1200 5416 5416 0 0.00 2 30246 1138 0 0
x_make_qstorno_1200_2000 5438 5438 0 0.00 3 82102 3175 0 0
x_make_qstorno_2100_3300 457012 457012 0 0.00 0 37827 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-11-2020 19:28:18 to 12-11-2020 19:28:22.

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
16:57:02 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:08 18740 8192000000 10242875968 10543734784 881909024 9.719 71 58 116 0 904254048 2607088 19737936
16:57:36 20234 8192000000 10318652752 10631688192 1359101696 14.229 100 81 162 0 1391063616 4571680 27390240
16:58:04 23044 8192000000 10350990960 10670002176 1397110576 14.569 100 83 166 0 1430704304 5748128 27845600
16:58:36 26538 8192000000 10384722176 10710286336 1435904048 14.913 100 88 176 0 1471356592 6259072 29193472
16:59:12 28587 8192000000 10417496048 10746380288 1471335824 15.225 100 92 184 1 1508534656 7264336 29934496
16:59:50 6097 8192000000 10420545840 10753171456 1481593312 15.315 100 83 166 0 1515917856 7690240 26634304
17:00:05 19456 8192000000 10445168448 10778333184 1496130704 15.442 100 89 178 0 1533447024 8359040 28957280
17:00:41 16961 8192000000 10478789696 10820718592 1522654448 15.673 100 79 158 0 1556148992 8647264 24847280
17:01:07 15312 8192000000 10489039136 10837090304 1553415696 15.939 100 77 155 1 1586560896 9279024 23866176
17:01:38 16338 8192000000 10533856096 10888388608 1582640544 16.191 100 76 152 0 1615206064 9486304 23079216
17:02:03 13239 8192000000 10563688272 10920316928 1616438064 16.480 100 78 155 1 1650426496 10865984 23122448
17:02:25 10411 8192000000 10593376768 10951311360 1643308688 16.708 100 79 159 0 1677802032 10760736 23732608
17:02:45 13106 8192000000 10603134928 10970537984 1669324432 16.927 100 84 168 2 1706072912 11982272 24766208
17:03:09 10896 8192000000 10630427968 10997477376 1686047664 17.068 100 85 170 0 1723586784 12731008 24808112
17:03:26 7760 8192000000 10640662928 11013935104 1706046256 17.236 100 81 162 1 1741875152 12794096 23034800
17:03:42 10428 8192000000 10660175680 11030343680 1717286192 17.330 100 76 151 1 1750767776 11936432 21545152
17:03:59 5830 8192000000 10678955152 11050147840 1740968640 17.527 100 74 148 2 1773760480 11874816 20917024
17:04:12 7554 8192000000 10689092080 11067002880 1752684752 17.624 100 81 160 1 1788712544 13091424 22936368
17:04:28 7517 8192000000 10702878432 11079417856 1765700528 17.732 100 90 178 0 1804485904 12876432 25908944
17:04:43 5375 8192000000 10714123536 11091972096 1775378768 17.811 100 82 164 0 1811450928 12869968 23202192
17:04:56 5731 8192000000 10725622000 11103600640 1784171744 17.884 100 85 169 1 1820721104 12675296 23874064
17:05:09 5082 8192000000 10724755680 11112001536 1791807376 17.947 100 82 164 2 1827222528 12583408 22831744
17:05:21 4985 8192000000 10739755424 11122561024 1801766704 18.028 100 90 180 1 1840197360 13269920 25160736
17:05:33 3900 8192000000 10741486896 11123019776 1805192720 18.056 100 84 168 0 1841985712 13160464 23632528
17:05:43 3940 8192000000 10753828752 11136897024 1808401120 18.083 100 84 169 1 1845443344 13495408 23546816
17:05:54 4481 8192000000 10745961952 11131670528 1810930080 18.103 100 86 172 0 1849414736 13598768 24885888
17:06:13 5633 8192000000 10749971904 11136368640 1813905184 18.128 100 80 160 1 1850320208 14225392 22189632
17:06:26 3466 8192000000 10771185040 11156492288 1828381264 18.246 100 93 185 0 1869642256 14038432 27222560
17:06:36 3415 8192000000 10783228256 11164430336 1838434144 18.328 100 86 170 1 1876238816 14085904 23718768
17:06:46 3564 8192000000 10781170320 11168137216 1838162544 18.326 100 90 182 2 1877762176 14248592 25351040
17:06:57 2187 8192000000 10792092960 11176316928 1846853232 18.397 100 89 177 2 1885742400 13761472 25127696
17:07:06 3144 8192000000 10795270800 11179745280 1851320864 18.433 100 84 167 1 1888492208 13802208 23369136
17:07:16 2322 8192000000 10792696992 11181109248 1855293904 18.465 100 93 186 0 1896229424 14651984 26283536
17:07:25 2888 8192000000 10800567808 11188236288 1855721200 18.469 100 91 182 0 1895828176 14368096 25738880
17:07:34 1770 8192000000 10803111408 11189383168 1860434176 18.507 100 95 190 1 1900481232 12977888 27069168
17:07:42 2045 8192000000 10798811136 11191160832 1865011408 18.544 100 88 174 0 1902069888 12523088 24535392
17:07:51 2176 8192000000 10810329808 11195068416 1865260864 18.546 100 95 186 1 1906172080 13580688 27330528
17:07:59 2261 8192000000 10812865280 11197763584 1864930128 18.543 100 85 171 0 1902266192 13041568 24294496
17:08:08 4102 8192000000 10807729904 11200172032 1867933360 18.568 100 80 161 2 1904014176 13229712 22851104
17:08:21 1996 8192000000 10820938160 11208323072 1873406848 18.612 100 92 184 0 1912006528 12067168 26532512
17:08:30 1438 8192000000 10816235904 11204730880 1875097728 18.626 100 90 180 2 1913454368 12690096 25666544
17:08:38 3051 8192000000 10817181872 11210928128 1873954096 18.616 100 85 170 4 1910130160 12049072 24126992
17:08:47 32361 8192000000 10807439248 11207712768 1876073488 18.633 100 73 146 1 1905986352 8571664 21341200
17:09:26 2108 8192000000 10825287232 11213205504 1882215744 18.683 100 91 182 0 1919773392 10637696 26919952
17:09:34 4659 8192000000 10791292896 11207688192 1873679584 18.614 100 40 80 1 1894911312 9696768 11534960
17:09:47 2508 8192000000 10810972912 11217301504 1879978752 18.665 100 66 131 3 1908975136 10667168 18329216
17:09:57 2112 8192000000 10814915744 11219972096 1882011424 18.681 100 65 130 1 1912906288 12627968 18266896
17:10:06 6273 8192000000 10804913488 11217809408 1885325024 18.708 100 52 104 0 1911220976 11731712 14164240
17:10:18 4553 8192000000 10812367040 11220897792 1887153056 18.723 100 56 112 1 1912719200 9881840 15684304
17:10:30 23766 8192000000 10816333680 11220348928 1886176896 18.715 100 49 97 1 1908952624 7672784 15102944
17:11:01 16146 8192000000 10817091168 11220480000 1891898672 18.761 100 71 144 4 1918758656 6413200 20446784
17:11:23 15186 8192000000 10791603648 11222396928 1888553120 18.734 100 47 92 2 1911922640 10318832 13050688
17:11:47 5797 8192000000 10807618688 11228856320 1892596064 18.767 100 44 88 1 1912222064 6799664 12826336
17:12:01 5839 8192000000 10806335008 11232374784 1893234112 18.772 100 26 52 0 1906804912 5701232 7869568
17:12:15 6734 8192000000 10806399104 11232219136 1895095696 18.787 100 28 55 3 1908305472 5864128 7345648
17:12:31 6449 8192000000 10818298784 11242213376 1897042368 18.802 100 29 58 2 1912053376 7445344 7565664
17:12:45 4031 8192000000 10819658256 11242172416 1899996000 18.826 100 37 72 0 1918196272 8399632 9800640
17:12:58 8074 8192000000 10819888016 11243069440 1905974048 18.874 100 42 83 2 1925603744 7973440 11656256
17:13:15 6195 8192000000 10804542384 11239231488 1902980640 18.850 100 27 54 3 1916859216 6134976 7743600
17:13:27 4824 8192000000 10805120064 11241938944 1906995296 18.883 100 34 68 1 1922843856 5491232 10357328
17:13:39 9989 8192000000 10811062880 11243491328 1906644208 18.880 100 17 34 1 1916966224 5321216 5000800
17:13:56 9247 8192000000 10814936368 11246780416 1906193808 18.876 100 19 38 1 1917973232 6629712 5149712
17:14:11 14082 8192000000 10810242736 11249156096 1908603792 18.895 100 18 38 0 1918865408 5327648 4933968
17:14:32 10348 8192000000 10828425808 11253387264 1911578016 18.919 100 25 50 1 1925011040 5680480 7752544
17:14:49 68102 8192000000 10848923648 11261640704 1913903648 18.938 100 38 76 2 1930741936 6196896 10641392
17:16:03 2835 8192000000 10836008672 11266195456 1918694864 18.976 100 53 106 2 1943336944 10115984 14526096
17:16:12 7754 8192000000 10802619200 11234140160 1855755472 18.469 97 20 40 0 1867904176 7010288 5138416
17:16:29 5456 8192000000 10824301504 11253387264 1904066000 18.859 100 35 71 2 1920296704 6120512 10110192
17:16:41 2605 8192000000 10841475216 11260256256 1909714400 18.904 100 45 89 3 1929533552 7461504 12357648
17:16:51 4613 8192000000 10831855744 11252813824 1876412240 18.636 98 38 76 1 1894405312 7175344 10817728
17:17:02 9478 8192000000 10804338352 11232243712 1826167680 18.228 96 32 64 2 1842687392 7451216 9068496
17:17:19 6221 8192000000 10805936288 11236216832 1877471280 18.645 99 21 42 0 1888740688 5324688 5944720
17:17:32 10454 8192000000 10797425728 11230007296 1885199264 18.707 100 20 40 1 1896441040 5640592 5601184
17:17:52 7959 8192000000 10776769648 11208654848 1845507328 18.386 98 13 26 1 1854814448 5626032 3681088
17:18:07 9988 8192000000 10784772960 11214770176 1857593136 18.484 99 20 38 1 1868994032 5140448 6260448
17:18:24 45677 8192000000 10803252208 11222016000 1858795120 18.494 99 36 72 0 1879514656 9785024 10934512
17:19:17 14962 8192000000 10736531344 11147071488 1729418688 17.431 93 30 60 2 1744260048 5118256 9723104
17:19:40 7915 8192000000 10720774512 11140485120 1763357504 17.712 97 30 58 6 1777750912 6033120 8360288
17:19:54 8527 8192000000 10680493824 11084840960 1626709968 16.567 90 33 66 0 1641647408 5795392 9142048
17:20:09 6250 8192000000 10705976464 11112194048 1753944464 17.634 98 39 77 2 1772319840 6529440 11845936
17:20:22 5528 8192000000 10717743072 11133816832 1798157696 17.999 100 33 66 1 1814525072 6356704 10010672
17:20:36 8289 8192000000 10729595920 11155718144 1814459600 18.132 100 17 33 1 1825445088 5814112 5171376
17:20:51 8644 8192000000 10739431888 11155746816 1798341664 18.000 98 24 48 2 1811241760 6229568 6670528
17:21:07 7020 8192000000 10699797664 11112599552 1718500528 17.340 95 27 54 2 1732211840 5735824 7975488
17:21:20 8404 8192000000 10690484400 11096715264 1721565008 17.365 96 42 80 3 1738857968 4983104 12309856
17:21:35 7932 8192000000 10698503664 11107168256 1720468432 17.356 96 14 28 1 1729471952 4962672 4040848
17:21:49 11381 8192000000 10702444304 11115069440 1759113120 17.677 98 21 42 0 1770756160 5591472 6051568
17:22:07 8303 8192000000 10709615040 11126583296 1780554576 17.854 99 27 55 1 1793525568 5209616 7761376
17:22:26 10316 8192000000 10718844800 11125764096 1796970128 17.989 100 22 44 1 1809074880 5529424 6575328
17:22:42 50595 8192000000 10764496512 11148468224 1803547856 18.043 99 69 136 4 1829117328 5317712 20251760
17:23:39 7273 8192000000 10729524480 11141459968 1798698400 18.003 99 34 68 1 1816596880 8690736 9207744
17:23:55 9417 8192000000 10720546624 11145908224 1802008704 18.030 99 28 57 3 1814984304 5966112 7009488
17:24:11 5758 8192000000 10727031520 11151564800 1822709344 18.200 100 40 80 0 1841596208 7330640 11556224
17:24:26 6688 8192000000 10725461504 11141865472 1808793024 18.086 99 32 62 2 1824643312 5818880 10031408
17:24:41 7038 8192000000 10740496672 11165786112 1832351072 18.278 100 22 44 1 1845814080 6756448 6706560
17:24:54 12592 8192000000 10721573664 11145867264 1811112544 18.105 99 22 44 0 1823821824 6262416 6446864
17:25:17 9092 8192000000 10741310640 11167547392 1831039008 18.268 100 18 36 2 1841697104 5856160 4801936
17:25:34 8664 8192000000 10758936304 11178250240 1841182576 18.350 100 34 68 0 1856903296 4998240 10722480
17:25:50 12887 8192000000 10759988320 11183534080 1842633552 18.362 100 15 30 1 1852748896 5434368 4680976
17:26:10 11187 8192000000 10767999712 11188510720 1850017392 18.422 100 27 54 2 1863278112 5249440 8011280
17:26:31 10216 8192000000 10755030848 11188580352 1850417952 18.426 100 16 32 2 1860767232 5562560 4786720
17:26:48 7969 8192000000 10765980336 11193647104 1854138240 18.456 100 29 58 1 1868567968 6226544 8203184
17:27:03 28069 8192000000 10797926176 11215953920 1874487184 18.621 100 35 70 1 1890046624 5102256 10457184
17:27:38 27597 8192000000 10822733056 11238883328 1899135520 18.819 100 74 148 1 1927814160 8370416 20308224
17:28:13 11549 8192000000 10836685600 11251388416 1899659984 18.824 100 51 102 0 1927988320 13880848 14447488
17:28:37 123528 8192000000 10844261632 11271966720 1911256112 18.917 100 50 98 3 1937892400 12478496 14157792
17:30:53 53151 8192000000 10845238608 11286757376 1923321184 19.013 100 33 64 1 1947508768 14892192 9295392
17:31:53 19035 8192000000 10849836048 11286650880 1930231296 19.069 100 33 66 0 1952116960 12344160 9541504
17:32:34 9663 8192000000 10891687184 11311161344 1948443296 19.214 100 64 128 2 1985486848 17834704 19208848
17:32:55 11757 8192000000 10891505920 11314483200 1949299696 19.221 100 59 118 1 1984000368 17305760 17394912
17:33:16 2598 8192000000 10897733856 11321221120 1953214032 19.252 100 47 94 1 1986383792 19060608 14109152
17:33:25 9701 8192000000 10913025536 11326599168 1959484752 19.302 100 61 120 1 1997131872 19983232 17663888
17:33:43 10945 8192000000 10899664048 11321491456 1943074800 19.171 99 57 114 2 1980947728 20929008 16943920
17:34:09 12717 8192000000 10904113888 11326103552 1954554528 19.263 100 52 103 2 1990603936 21226544 14822864
17:35:00 6282 8192000000 10915009040 11335430144 1960423392 19.309 100 55 109 0 1998831760 22529632 15878736
17:35:18 26012 8192000000 10921816080 11348717568 1969367696 19.380 100 50 100 1 2008311280 24445904 14497680
17:36:00 7775 8192000000 10907469504 11351560192 1971349440 19.396 100 42 84 1 2003851328 20391712 12110176
17:36:15 7150 8192000000 10926855760 11357016064 1977310448 19.443 100 46 92 0 2012265840 21674976 13280416
17:36:31 2618 8192000000 10934086080 11351695360 1972111264 19.402 100 76 150 2 2017354752 23010048 22233440
17:36:40 6392 8192000000 10933438448 11353100288 1975043984 19.425 100 66 130 2 2018407824 23573904 19789936
17:36:57 3772 8192000000 10929513600 11354595328 1975413840 19.428 100 65 128 0 2018065136 23484352 19166944
17:37:07 2036 8192000000 10944813568 11361034240 1985234400 19.506 100 74 148 1 2031962880 24711248 22017232
17:37:15 2309 8192000000 10958848752 11369205760 1988737536 19.534 100 86 170 1 2037175664 23592656 24845472
17:37:27 8565 8192000000 10935382384 11359592448 1969999504 19.385 99 68 135 2 2013773584 24323872 19450208
17:37:44 3629 8192000000 10940847248 11359338496 1987528400 19.524 100 81 163 2 2037548624 25683104 24337120
17:37:56 4445 8192000000 10948143792 11368468480 1986713888 19.518 100 77 154 4 2034296320 25281760 22300672
17:38:10 12547 8192000000 10956038992 11370840064 1988821376 19.534 100 72 142 3 2035880304 25856816 21202112
17:38:29 1358 8192000000 10955384176 11362353152 1976591936 19.438 99 88 176 1 2028916768 26250704 26074128
17:38:38 15834 8192000000 10938826880 11359895552 1973784688 19.415 99 67 134 1 2021384496 27519376 20080432
17:39:03 3326 8192000000 10960067056 11382390784 1996311296 19.594 100 74 148 2 2045789920 27562112 21916512
17:39:15 10978 8192000000 10964095440 11384889344 1998534944 19.611 100 65 130 0 2046501280 28540112 19426224
17:39:36 2301 8192000000 10969910400 11394494464 2004439376 19.658 100 68 137 3 2054636784 29772400 20425008
17:39:48 6624 8192000000 10976414352 11398909952 2010705984 19.707 100 70 140 1 2062207920 30227888 21274048
17:40:02 4498 8192000000 10972975760 11405312000 2013455488 19.729 100 60 119 0 2062671808 30896528 18319792
17:40:17 9433 8192000000 10976839968 11413196800 2017406304 19.760 100 56 111 2 2063957040 29572704 16978032
17:40:36 5668 8192000000 10977429200 11400466432 2012510768 19.721 100 67 134 0 2064625456 31306736 20807952
17:40:50 8674 8192000000 10974942672 11405213696 2013733408 19.731 100 66 131 0 2066125184 32555072 19836704
17:41:10 10089 8192000000 10977250928 11413237760 2015963792 19.748 100 59 118 1 2065909984 31745568 18200624
17:41:29 5222 8192000000 10978780928 11405434880 2013531120 19.729 100 57 114 0 2065109952 33618208 17960624
17:41:43 4074 8192000000 10974063168 11395624960 1991862816 19.559 99 67 133 2 2047024880 34488624 20673440
17:41:54 5917 8192000000 10974518992 11402952704 2007910880 19.685 100 58 116 2 2061748688 35433008 18404800
17:42:07 5000 8192000000 10991191824 11411914752 2013295984 19.727 100 81 159 2 2075484800 37028080 25160736
17:42:22 3644 8192000000 10983045712 11406204928 2007308160 19.680 100 75 151 2 2069062048 37540336 24213552
17:42:36 3052 8192000000 10976812720 11402326016 2011165776 19.711 100 73 142 1 2064592784 30957376 22469632
17:42:48 2295 8192000000 10985025248 11396235264 1994500272 19.579 99 74 147 2 2046150880 28111696 23538912
17:42:57 9293 8192000000 10967078064 11393400832 2004892512 19.661 100 59 117 0 2051449792 28443408 18113872
17:43:14 1460 8192000000 10971051664 11381542912 2000141344 19.624 99 82 163 2 2054016096 29014624 24860128
17:43:22 3041 8192000000 10960993824 11373326336 1988651584 19.533 99 75 150 1 2042892432 30328064 23912784
17:43:33 3397 8192000000 10965810272 11381702656 1993157552 19.569 100 79 156 1 2049754896 32112784 24484560
17:43:46 3086 8192000000 10968772832 11388305408 1994116784 19.576 100 74 148 0 2051244592 33501152 23626656
17:43:57 1605 8192000000 10965313376 11386851328 1996403088 19.594 100 69 138 1 2051427968 32976192 22048688
17:44:07 2699 8192000000 10969352112 11383054336 1992242304 19.562 100 89 178 1 2053261216 33083296 27935616
17:44:17 3118 8192000000 10947988128 11369320448 1975926080 19.432 99 73 141 1 2034077296 35291712 22859504
17:44:26 3294 8192000000 10962415280 11386294272 1991029728 19.552 100 69 140 3 2048222704 35051424 22141552
17:44:37 2266 8192000000 10978367520 11392733184 1994667728 19.581 100 87 175 1 2058453392 36655216 27130448
17:44:46 2308 8192000000 10974892736 11393241088 1994493168 19.579 100 79 158 1 2056194880 36858512 24843200
17:44:56 3157 8192000000 10977453808 11391000576 1993096160 19.568 100 84 167 2 2057744880 39163584 25485136
17:45:08 4162 8192000000 10948097136 11373481984 1963582960 19.335 99 70 140 2 2027003472 40211216 23209296
17:45:22 2710 8192000000 10963893680 11374854144 1955769280 19.272 99 78 155 0 2025787168 44536880 25481008
17:45:32 3467 8192000000 10961786480 11373068288 1956400416 19.277 99 82 161 1 2029390528 46747888 26242224
17:45:42 4234 8192000000 10942384832 11362267136 1958626640 19.295 100 74 148 0 2029617440 47852144 23138656
17:45:53 4886 8192000000 10966266448 11372949504 1971253040 19.395 100 80 155 2 2042707376 46898800 24555536
17:46:05 4198 8192000000 10961502464 11371372544 1956562960 19.279 99 86 171 0 2028618016 44478144 27576912
17:46:16 2611 8192000000 10962143504 11381420032 1979118688 19.458 100 84 166 1 2048603216 42964080 26520448
17:46:26 5890 8192000000 10977614752 11385618432 1983855184 19.495 100 86 171 0 2052743472 42312608 26575680
17:46:40 4200 8192000000 10975027680 11388628992 1984361712 19.499 100 83 166 0 2057223856 47158320 25703824
17:46:53 6971 8192000000 10961793024 11380813824 1971143104 19.395 99 79 157 2 2043269216 47250720 24875392
17:47:08 1889 8192000000 10984316096 11391180800 1985682640 19.510 100 94 190 3 2064724944 49434688 29607616
17:47:17 5410 8192000000 10944117440 11364102144 1953731728 19.256 99 66 132 2 2025108592 49524512 21852352
17:47:35 10764 8192000000 10925381600 11360800768 1945704608 19.192 99 45 90 1 2001159936 40088256 15367072
17:47:56 13212 8192000000 10932767280 11364511744 1963232880 19.332 100 55 109 0 2021529968 40251824 18045264
17:48:17 3708 8192000000 10940579632 11349954560 1943192864 19.172 99 72 144 4 2004679808 38601456 22885488
17:48:28 8553 8192000000 10939354256 11351642112 1946150000 19.196 99 65 128 1 2010156608 42589472 21417136
17:48:46 1823 8192000000 10964070512 11377410048 1972193952 19.403 100 75 147 4 2041581344 45497424 23889968
17:48:57 4542 8192000000 10941391488 11360411648 1954728016 19.264 100 72 141 3 2022596016 45073872 22794128
17:49:11 9394 8192000000 10933280912 11369771008 1956324800 19.277 100 49 95 3 2015506784 42688704 16493280
17:49:27 12978 8192000000 10915389808 11364278272 1956776816 19.280 100 33 66 2 2008044016 39466672 11800528
17:50:02 21287 8192000000 10915860192 11355418624 1955716256 19.272 100 29 59 2 1998501504 33244976 9540272
17:50:43 37568 8192000000 10905286704 11365400576 1955712464 19.272 100 24 48 2 1996612448 32764512 8135472
17:51:54 25051 8192000000 10890004096 11356962816 1942734736 19.169 100 14 28 1 1979403296 31918656 4749904
17:52:25 33479 8192000000 10884276272 11340877824 1902339808 18.845 98 19 37 3 1939621792 30848960 6433024
17:53:08 19619 8192000000 10904542528 11352756224 1925875728 19.034 99 31 63 1 1975731392 39997024 9858640
17:53:41 10916 8192000000 10910477856 11368693760 1954287392 19.261 100 28 56 1 2000765968 37535728 8942848
17:53:59 13581 8192000000 10902526368 11361378304 1947171152 19.204 100 20 40 0 1985231264 31487408 6572704
17:54:33 31158 8192000000 10885735632 11343818752 1925348416 19.030 99 13 26 0 1950181008 20370208 4462384
17:55:11 46236 8192000000 10871551088 11331756032 1912446672 18.926 99 9 18 0 1940281664 24545072 3289920
17:56:03 96935 8192000000 10870658032 11336179712 1900366048 18.829 98 16 30 2 1916947168 11885456 4695664
17:57:55 48991 8192000000 10854900128 11306459136 1871429776 18.596 96 22 43 2 1883726688 6419600 5877312
17:58:53 100390 8192000000 10892130256 11328278528 1927999072 19.051 99 31 62 0 1949346496 13055808 8291616
18:00:44 49440 8192000000 10848943952 11321634816 1903536928 18.855 98 27 55 1 1919062320 8478848 7046544
18:01:41 41243 8192000000 10870931536 11325583360 1940173184 19.148 100 20 39 2 1953310128 7970256 5166688
18:02:36 5800 8192000000 10883450192 11319259136 1937789264 19.129 100 45 87 0 1957002240 7490864 11722112
18:02:49 7770 8192000000 10874146976 11314761728 1932122208 19.084 99 58 112 2 1956144080 8566144 15455728
18:03:04 44863 8192000000 10887991088 11332714496 1910679488 18.912 98 29 58 0 1929471888 10257184 8535216
18:03:56 47089 8192000000 10883420048 11349508096 1953273808 19.253 100 37 75 1 1977544592 12912144 11358640
18:04:50 55991 8192000000 10865691808 11339816960 1926240176 19.037 99 14 28 1 1942609520 12521584 3847760
18:05:57 33924 8192000000 10873951904 11347935232 1945109808 19.188 100 15 30 2 1962420176 12413456 4896912
18:06:37 66653 8192000000 10887676320 11347509248 1952115632 19.243 100 25 50 1 1969982736 9683168 8183936
18:07:55 49091 8192000000 10862590128 11340177408 1933442464 19.094 99 14 28 0 1946154656 9050816 3661376
18:10:01 135311 8192000000 10855331040 11328901120 1907770400 18.889 98 23 46 0 1924105312 9183296 7151616
18:12:32 63988 8192000000 10872173616 11345276928 1939322656 19.141 99 22 44 0 1953067248 7635136 6109456
18:13:44 64281 8192000000 10881894144 11362406400 1963792896 19.336 100 10 20 1 1979866368 13126704 2946768
18:14:55 1719 8192000000 10895463776 11359813632 1964958144 19.345 100 16 30 4 1982282096 12840896 4483056
18:15:02 27837 8192000000 10899733056 11354497024 1951028096 19.235 99 31 62 2 1972617072 12236000 9352976
18:16:04 46652 8192000000 10884837072 11370008576 1964801136 19.344 100 19 38 2 1985882368 15590640 5490592
18:17:07 54793 8192000000 10898861152 11376631808 1972376624 19.404 100 7 14 0 1984798176 10709728 1711824
18:18:12 70913 8192000000 10903863328 11379220480 1950277888 19.229 98 13 26 1 1961971920 7952256 3741776
18:19:34 44517 8192000000 10910175520 11384864768 1988333104 19.531 100 17 34 0 2002739104 9602624 4803376
18:20:25 47809 8192000000 10933835360 11383480320 1956882112 19.281 98 33 66 0 1981541264 15274720 9384432
18:21:22 47651 8192000000 10918132528 11396767744 1988033808 19.528 100 22 44 1 2009368640 15165968 6168864
18:22:16 75748 8192000000 10905463408 11374301184 1931874128 19.082 97 12 24 1 1945817072 10970416 2972528
18:23:38 31194 8192000000 10917520480 11378589696 1962302288 19.324 99 29 58 1 1983660496 13122416 8235792
18:24:24 94627 8192000000 10903510016 11385176064 1942888672 19.170 98 24 47 2 1967381920 17282640 7210608
18:26:23 41628 8192000000 10899434560 11364982784 1945091984 19.187 98 27 54 1 1962337520 9908464 7337072
18:27:14 68022 8192000000 10882749872 11361468416 1917817504 18.969 97 19 38 2 1939458352 16359648 5281200
18:28:28 45142 8192000000 10907815360 11353681920 1909430560 18.902 97 18 36 1 1924957488 10830240 4696688
18:29:23 18532 8192000000 10895542768 11348946944 1932516928 19.087 98 28 56 1 1951248400 10679872 8051600
18:29:51 29695 8192000000 10905896688 11357396992 1907724736 18.888 97 29 58 1 1929984032 14101856 8157440
18:30:31 57624 8192000000 10895910592 11337912320 1889418384 18.741 96 36 70 0 1917283488 18544272 9320832
18:31:35 24893 8192000000 10888419216 11350142976 1936694032 19.120 99 47 93 2 1966656304 16687968 13274304
18:32:11 134858 8192000000 10857513584 11305836544 1855541632 18.467 95 34 68 3 1877055072 12351200 9162240
18:34:35 63141 8192000000 10887785040 11346649088 1952961680 19.250 100 39 79 1 1975156432 11622112 10572640
18:35:45 13525 8192000000 10887918096 11348344832 1951841792 19.241 100 32 64 0 1972744960 12030992 8872176
18:36:25 49310 8192000000 10873887248 11352084480 1950331152 19.229 100 16 32 0 1969383952 14445360 4607440
18:37:21 37870 8192000000 10863040032 11337121792 1915346192 18.950 98 9 18 0 1933376096 15379552 2650352
18:38:07 22880 8192000000 10868345056 11351248896 1947285200 19.205 100 8 14 1 1965180336 15746800 2148336
18:38:45 26969 8192000000 10864097072 11349618688 1925689536 19.032 99 8 16 0 1944470288 15914000 2866752
18:39:27 57751 8192000000 10842594096 11323564032 1922036800 19.003 99 8 16 0 1938062880 13918832 2107248
18:40:31 58157 8192000000 10867793136 11331047424 1895644960 18.791 97 15 30 1 1907667168 8162368 3859840
18:41:37 54375 8192000000 10859605536 11335458816 1912883856 18.930 98 13 26 0 1928663296 11990752 3788688
18:42:37 52709 8192000000 10886224880 11343458304 1930719392 19.073 99 12 24 1 1944519968 10513936 3286640
18:43:43 22652 8192000000 10882460880 11345301504 1930919664 19.074 98 41 82 2 1954259984 11624464 11715856
18:44:17 61160 8192000000 10868018896 11325759488 1859696016 18.501 95 18 36 1 1877606512 12809424 5101072
18:45:27 50949 8192000000 10844587872 11320156160 1891164544 18.755 98 17 34 1 1916275008 19567936 5542528
18:46:25 89174 8192000000 10879828768 11353292800 1896816816 18.801 98 16 32 0 1915675904 14507040 4352048
18:48:05 65472 8192000000 10900471360 11354914816 1894486736 18.782 97 18 36 1 1918507152 18955424 5064992
18:49:26 45866 8192000000 10886907360 11359805440 1947769280 19.209 100 19 38 1 1977185344 23657840 5758224
18:50:29 59637 8192000000 10891058400 11363139584 1924608336 19.024 99 12 24 1 1943825360 16120608 3096416
18:51:35 63773 8192000000 10907912608 11377061888 1930851024 19.074 99 23 46 2 1963194960 25616656 6727280
18:52:48 91495 8192000000 10886436336 11344760832 1876734672 18.639 96 16 32 2 1892162480 11286640 4141168
18:54:25 101970 8192000000 10870563760 11328843776 1891850144 18.761 97 32 64 0 1915405104 14522672 9032288
18:57:04 60395 8192000000 10852247760 11323752448 1872022432 18.601 97 21 42 0 1893602736 16287312 5292992
18:58:10 29872 8192000000 10859486576 11330203648 1911305824 18.917 99 13 25 0 1932699920 17704880 3689216
18:58:51 30907 8192000000 10858735904 11324547072 1942359664 19.166 100 24 46 5 1953557904 5112112 6086128
18:59:31 71207 8192000000 10849544736 11311849472 1878482352 18.653 96 14 28 1 1889171424 6587968 4101104
19:01:01 51040 8192000000 10836940768 11307708416 1916645920 18.960 99 10 20 0 1927524784 8031216 2847648
19:02:06 71590 8192000000 10850803568 11330412544 1914551072 18.943 99 4 8 1 1925248608 9774688 922848
19:03:24 52677 8192000000 10907912336 11356164096 1956898016 19.281 100 26 53 2 1971634544 6556144 8180384
19:04:23 66461 8192000000 10886672336 11357265920 1927513760 19.047 98 20 40 0 1944451584 11107280 5830544
19:06:08 51644 8192000000 10892219584 11357204480 1942621184 19.168 99 17 35 5 1956137440 8384336 5131920
19:07:10 45936 8192000000 10898648272 11358887936 1948324640 19.213 99 15 30 0 1961533072 9271584 3936848
19:08:11 31861 8192000000 10934715744 11377516544 1975963136 19.433 100 44 87 0 1997320640 9250944 12106560
19:08:50 64214 8192000000 10903016224 11366477824 1958125968 19.291 99 27 54 0 1977160864 11611520 7423376
19:10:14 75079 8192000000 10905898688 11370233856 1949789696 19.225 99 17 34 1 1970782032 16044944 4947392
19:11:41 40214 8192000000 10907814240 11363856384 1952161488 19.244 99 33 66 1 1974078784 12732400 9184896
19:12:30 44267 8192000000 10897953600 11363852288 1938795136 19.137 98 22 44 0 1957300160 12035040 6469984
19:13:23 92930 8192000000 10880202864 11353251840 1889616960 18.743 96 13 26 0 1903205696 9974032 3614704
19:15:03 67206 8192000000 10921795104 11368103936 1954171648 19.260 99 30 59 4 1972286720 9632864 8482208
19:16:19 105242 8192000000 10898920624 11372240896 1975060368 19.426 100 33 66 0 1992715984 8338352 9317264
19:18:52 55479 8192000000 10880703040 11351691264 1920116208 18.988 97 20 39 1 1933061760 7612768 5332784
19:21:00 55047 8192000000 10883467840 11361587200 1950183488 19.228 99 14 27 0 1964862464 10360512 4318464
19:22:02 41902 8192000000 10856198640 11342544896 1934766128 19.105 99 5 10 0 1944291904 8247296 1278480
19:22:58 112951 8192000000 10843420912 11315933184 1771986528 17.783 90 8 17 2 1790974608 16499648 2488432
19:25:01 74693 8192000000 10885344848 11352784896 1931297040 19.077 99 23 44 2 1956002896 18113120 6592736
19:26:23 41386 8192000000 9109727088 9334632448 262623104 3.106 14 4 7 0 268201344 4444736 1133504

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 12-11-2020 19:28:24 to 12-11-2020 19:28:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 75 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 12-11-2020 19:28:57 to 12-11-2020 19:28:59.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          235878
MON$OLDEST_ACTIVE               235879
MON$OLDEST_SNAPSHOT             235879
MON$NEXT_TRANSACTION            235879
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                       2013248
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:15: 
:16: mscs-test-161.budzdorov.ru    Thu Nov 12 19:27:13 2020
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Thu Nov 12 19:27:14 2020
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Thu Nov 12 19:27:18 2020
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
--- end of diff output ---

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

12.11.20 19:29:00. 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-12 19:29:02 No severe PSQL-related problems occured
12.11.20 19:29:04. End of report.