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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17271080 kB
MemAvailable 31448228 kB
Buffers 0 kB
Cached 14398664 kB
SwapCached 2540 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-26 01:27:09
DTS_END                         2020-12-26 01:27:09.4310
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58316
TRN_ID                          245271
ATT_ID                          641
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: 9743.06 21239 1169167
customer order: creation 176.71 325 21205
customer order: refuse 14.73 339 1768
order to supplier: creation 46.68 1242 5601
order to supplier: removal 3.66 92148 439
invoice (draft): creation 47.57 3340 5708
invoice (draft): removal 54.61 735 6553
invoice accept: apply 44.88 17192 5386
invoice accept: cancel 50.07 789 6008
customer reserve: creation 4114.07 172 493688
customer reserve: removal 4882.48 54 585897
realization accept: apply 87.14 157 10457
realization accept: cancel 86.25 100 10350
payment from customer: creation 61.52 104 7382
payment from customer: removal 5.73 67 688
payment to supplier: creation 50.60 125 6072
payment to supplier: removal 3.49 64 419
service: total inventory turnovers 5.01 971 601
service: total monetary turnovers 6.99 39 839
service: aggregate perf. data 0.85 21210 102
service: refresh index statistics 0.03 285612 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8985
TEST_TIME 2 6656
TEST_TIME 3 5256
TEST_TIME 4 5473
TEST_TIME 5 5142
TEST_TIME 6 5653
TEST_TIME 7 5453
TEST_TIME 8 5954
TEST_TIME 9 6605
TEST_TIME 10 6895
TEST_TIME 11 7710
TEST_TIME 12 8277
TEST_TIME 13 8237
TEST_TIME 14 8208
TEST_TIME 15 8176
TEST_TIME 16 8343
TEST_TIME 17 8426
TEST_TIME 18 8763
TEST_TIME 19 9158
TEST_TIME 20 9661
TEST_TIME 21 9626
TEST_TIME 22 9785
TEST_TIME 23 10341
TEST_TIME 24 10337
TEST_TIME 25 10431
TEST_TIME 26 10819
TEST_TIME 27 12025
TEST_TIME 28 12013
TEST_TIME 29 11871
TEST_TIME 30 11575
TEST_TIME 31 11554
TEST_TIME 32 11398
TEST_TIME 33 11262
TEST_TIME 34 11290
TEST_TIME 35 11255
TEST_TIME 36 11024
TEST_TIME 37 10936
TEST_TIME 38 10865
TEST_TIME 39 10942
TEST_TIME 40 10928
TEST_TIME 41 10952
TEST_TIME 42 10851
TEST_TIME 43 10750
TEST_TIME 44 10625
TEST_TIME 45 10724
TEST_TIME 46 10616
TEST_TIME 47 10529
TEST_TIME 48 10479
TEST_TIME 49 10480
TEST_TIME 50 10434
TEST_TIME 51 10374
TEST_TIME 52 10362
TEST_TIME 53 10360
TEST_TIME 54 10333
TEST_TIME 55 10469
TEST_TIME 56 10447
TEST_TIME 57 10482
TEST_TIME 58 10527
TEST_TIME 59 10459
TEST_TIME 60 10631
TEST_TIME 61 10606
TEST_TIME 62 10632
TEST_TIME 63 10484
TEST_TIME 64 10368
TEST_TIME 65 10330
TEST_TIME 66 10260
TEST_TIME 67 10247
TEST_TIME 68 10155
TEST_TIME 69 10183
TEST_TIME 70 10137
TEST_TIME 71 10176
TEST_TIME 72 10133
TEST_TIME 73 10162
TEST_TIME 74 10144
TEST_TIME 75 10275
TEST_TIME 76 10342
TEST_TIME 77 10307
TEST_TIME 78 10282
TEST_TIME 79 10343
TEST_TIME 80 10325
TEST_TIME 81 10399
TEST_TIME 82 10360
TEST_TIME 83 10259
TEST_TIME 84 10217
TEST_TIME 85 10166
TEST_TIME 86 10120
TEST_TIME 87 10154
TEST_TIME 88 10097
TEST_TIME 89 10043
TEST_TIME 90 10006
TEST_TIME 91 9985
TEST_TIME 92 9991
TEST_TIME 93 9981
TEST_TIME 94 9989
TEST_TIME 95 9993
TEST_TIME 96 9961
TEST_TIME 97 10042
TEST_TIME 98 10013
TEST_TIME 99 10026
TEST_TIME 100 10044
TEST_TIME 101 10004
TEST_TIME 102 10013
TEST_TIME 103 10061
TEST_TIME 104 10025
TEST_TIME 105 10047
TEST_TIME 106 10109
TEST_TIME 107 10087
TEST_TIME 108 10012
TEST_TIME 109 9982
TEST_TIME 110 9928
TEST_TIME 111 9918
TEST_TIME 112 9865
TEST_TIME 113 9902
TEST_TIME 114 9871
TEST_TIME 115 9827
TEST_TIME 116 9799
TEST_TIME 117 9783
TEST_TIME 118 9820
TEST_TIME 119 9825
TEST_TIME 120 9749

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 26-12-2020 01:28:17 to 26-12-2020 01:28:21.

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 1625522 1625522 0 0.00 0 24212 6 0 0
doc_list_biud 1625521 1625521 0 0.00 0 19987 25 0 0
sp_add_invoice_to_stock 5591 5386 205 3.66 34 172764 17193 0 205
sp_cancel_adding_invoice 6008 6008 0 0.00 5 59795 790 0 0
sp_cancel_client_order 1768 1768 0 0.00 4 12139 340 0 0
sp_cancel_customer_reserve 585897 585897 0 0.00 1 20004 55 0 0
sp_cancel_pay_from_customer 688 688 0 0.00 2 3133 67 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 4110 65 0 0
sp_cancel_supplier_invoice 6571 6553 18 0.27 2 13117 736 0 18
sp_cancel_supplier_order 439 439 0 0.00 8 1147023 92148 0 0
sp_cancel_write_off 10350 10350 0 0.00 1 9759 100 0 0
sp_client_order 21205 21205 0 0.00 3 12014 325 0 0
sp_customer_reserve 493688 493688 0 0.00 0 90786 172 0 0
sp_fill_shopping_cart 32509 32509 0 0.00 1 12413 35 0 0
sp_fill_shopping_cart_clo_res 493680 493680 0 0.00 0 19660 14 0 0
sp_get_clo_for_invoice 5376 5376 0 0.00 0 20662 277 0 0
sp_kill_cost_storno 17465 17465 0 0.00 0 10511 52 0 0
sp_kill_qstorno_ret_qs2qd 1189136 1189136 0 0.00 0 18744 30 0 0
sp_kill_qty_storno 626848 626848 0 0.00 0 19986 64 0 0
sp_lock_selected_doc 21730 21730 0 0.00 0 9006 6 0 0
sp_make_cost_storno 29287 29287 0 0.00 0 24209 50 0 0
sp_multiply_rows_for_pdistr 29287 29287 0 0.00 0 7031 29 0 0
sp_multiply_rows_for_qdistr 21205 21205 0 0.00 0 12007 153 0 0
sp_pay_from_customer 7382 7382 0 0.00 4 12310 105 0 0
sp_pay_to_supplier 6072 6072 0 0.00 5 11963 125 0 0
sp_payment_common 13454 13454 0 0.00 1 8786 24 0 0
sp_qd_handle_on_cancel_clo 1768 1768 0 0.00 0 12131 296 0 0
sp_qd_handle_on_invoice_upd_sts 11384 11384 0 0.00 0 18254 298 0 0
sp_qd_handle_on_reserve_upd_sts 10457 10457 0 0.00 0 14037 43 0 0
sp_reserve_write_off 10457 10457 0 0.00 6 24220 157 0 0
sp_supplier_invoice 5708 5708 0 0.00 7 90440 3341 0 0
sp_supplier_order 5601 5601 0 0.00 5 33779 1242 0 0
srv_aggregate_perf_data 103 102 1 0.97 2720 154414 21210 0 1
srv_fill_mon_cache_memory 168 168 0 0.00 850 132177 31163 0 0
srv_find_qd_qs_mism 1118909 1118909 0 0.00 0 17092 6 0 0
srv_make_invnt_saldo 601 601 0 0.00 44 35641 972 0 0
srv_make_money_saldo 839 839 0 0.00 0 7093 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 124992 402380 285613 0 0
t$perf-abend:sp_add_invoice_to_stock 205 205 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 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 5387 5387 0 0.00 0 7012 152 0 0
t$perf-norm:sp_cancel_adding_invoice 489 489 0 0.00 0 7065 85 0 0
t$perf-norm:sp_cancel_client_order 1768 1768 0 0.00 0 5899 16 0 0
t$perf-norm:sp_cancel_customer_reserve 693 693 0 0.00 0 922 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 688 688 0 0.00 0 1206 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 1888 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 789 12 0 0
t$perf-norm:sp_cancel_supplier_order 439 439 0 0.00 0 21579 1529 0 0
t$perf-norm:sp_cancel_write_off 975 975 0 0.00 0 3008 8 0 0
t$perf-norm:sp_client_order 21205 21205 0 0.00 0 9521 14 0 0
t$perf-norm:sp_customer_reserve 994 994 0 0.00 0 9548 20 0 0
t$perf-norm:sp_pay_from_customer 7382 7382 0 0.00 0 3184 9 0 0
t$perf-norm:sp_pay_to_supplier 6072 6072 0 0.00 0 7588 10 0 0
t$perf-norm:sp_reserve_write_off 10457 10457 0 0.00 0 17637 15 0 0
t$perf-norm:sp_supplier_invoice 5708 5708 0 0.00 0 3943 17 0 0
t$perf-norm:sp_supplier_order 5602 5602 0 0.00 0 4035 14 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 316 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 241 2 0 0
t$perf-norm:srv_make_invnt_saldo 601 601 0 0.00 0 1186 20 0 0
t$perf-norm:srv_make_money_saldo 839 839 0 0.00 0 779 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 11156 10746 410 3.67 0 5503 21 0 410
v_all_customers 38722 38722 0 0.00 0 14 1 0 0
v_all_suppliers 31292 31292 0 0.00 0 20 1 0 0
v_all_wares 42408 42408 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 978 978 0 0.00 0 2669 11 0 0
v_cancel_client_order 3536 3536 0 0.00 0 5882 10 0 0
v_cancel_customer_prepayment 1376 1376 0 0.00 0 3111 9 0 0
v_cancel_customer_reserve 1386 1386 0 0.00 0 2394 8 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 3522 9 0 0
v_cancel_supplier_invoice 894 858 36 4.02 0 2193 18 0 36
v_cancel_supplier_order 878 878 0 0.00 0 745 3 0 0
v_cancel_write_off 1950 1950 0 0.00 0 3145 16 0 0
v_max_id_clo_ord 5601 5601 0 0.00 0 436 1 0 0
v_max_id_clo_res 994 994 0 0.00 0 5368 16 0 0
v_max_id_ord_sup 5704 5704 0 0.00 0 4268 3 0 0
v_max_non_paid_invoice 1731 1731 0 0.00 0 1740 4 0 0
v_max_non_paid_realizn 3877 3877 0 0.00 0 2271 5 0 0
v_min_id_clo_ord 5601 5601 0 0.00 0 5381 11 0 0
v_min_id_clo_res 994 994 0 0.00 0 116 2 0 0
v_min_id_ord_sup 5704 5704 0 0.00 0 6388 6 0 0
v_min_non_paid_invoice 6072 6072 0 0.00 0 5936 13 0 0
v_min_non_paid_realizn 7382 7382 0 0.00 0 5666 12 0 0
v_our_firm 10696 10696 0 0.00 0 16 1 0 0
v_reserve_write_off 20914 20914 0 0.00 0 6089 7 0 0
x_lock_depdocs_on_canc_invoice 12132 12132 0 0.00 0 9919 107 0 0
x_lock_depdocs_on_canc_sup_ord 439 439 0 0.00 0 10233 318 0 0
x_make_qstorno_1000_1200 5601 5601 0 0.00 1 33773 1163 0 0
x_make_qstorno_1200_2000 5708 5708 0 0.00 3 90428 3226 0 0
x_make_qstorno_2100_3300 493687 493687 0 0.00 0 90763 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-12-2020 01:28:22 to 26-12-2020 01:28:26.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:13 4 8192000000 8802763536 8814428160 8233680 0.100 2 1 2 0 8353088 56848 62560
22:57:19 18010 8192000000 10236550288 10539659264 873368304 9.634 69 54 114 0 892786640 2291872 17126464
22:57:48 29877 8192000000 10323895264 10637819904 1370843760 14.335 100 82 164 0 1402695424 4884672 26966992
22:58:33 26888 8192000000 10370771200 10690961408 1417737632 14.753 100 89 178 0 1453142736 6468192 28936912
22:59:07 26074 8192000000 10394657408 10721402880 1450678160 15.044 100 92 184 2 1488619728 7704512 30237056
22:59:43 9304 8192000000 10401390560 10729066496 1460440992 15.130 100 90 180 0 1497809344 7942592 29425760
23:00:03 6019 8192000000 10415001232 10742124544 1471669328 15.228 100 92 184 0 1509878736 8502080 29707328
23:00:22 17539 8192000000 10426989456 10760003584 1484604048 15.342 100 84 168 0 1520235872 8588112 27043712
23:00:49 15770 8192000000 10454721392 10791358464 1508690704 15.552 100 87 174 0 1545197792 8542368 27964720
23:01:14 17248 8192000000 10488903264 10833821696 1525055840 15.694 100 74 148 1 1556937744 8530384 23351520
23:01:47 17729 8192000000 10535173824 10890588160 1593782160 16.286 100 77 154 1 1627213296 9614784 23816352
23:02:12 14956 8192000000 10567284656 10922156032 1621166160 16.520 100 83 166 0 1656682768 10187792 25328816
23:02:37 14948 8192000000 10588873616 10945855488 1645362368 16.725 100 86 172 1 1682528512 11679296 25486848
23:03:03 18784 8192000000 10598822336 10962542592 1655359584 16.810 100 76 152 3 1689910208 12131152 22419472
23:03:30 8908 8192000000 10611930736 10979631104 1669933632 16.933 100 77 154 1 1705361856 12938304 22489920
23:03:54 6125 8192000000 10636050912 11008770048 1691977776 17.118 100 69 138 1 1724578432 12224144 20376512
23:04:14 8952 8192000000 10653540048 11026505728 1710859728 17.276 100 75 150 0 1745006016 12522960 21623328
23:04:30 5514 8192000000 10655961792 11032219648 1724586592 17.390 100 77 153 2 1759179984 12683712 21909680
23:04:43 5901 8192000000 10664257232 11043258368 1734085424 17.469 100 78 156 2 1769338736 12864656 22388656
23:04:58 5676 8192000000 10682993456 11061211136 1742538304 17.540 100 73 144 2 1775859728 13055440 20265984
23:05:10 6306 8192000000 10696391552 11072098304 1755904336 17.650 100 79 156 0 1790168192 12614224 21649632
23:05:24 3807 8192000000 10699703376 11079712768 1765391216 17.729 100 80 160 2 1801688208 13640384 22656608
23:05:36 5449 8192000000 10713415392 11095232512 1771120352 17.776 100 80 159 4 1807012704 13670880 22221472
23:05:48 3955 8192000000 10720139456 11103064064 1780769424 17.856 100 86 172 1 1820101024 15143088 24188512
23:06:00 6349 8192000000 10720171504 11104288768 1785297648 17.893 100 76 152 1 1820951232 14841968 20811616
23:06:15 3126 8192000000 10744835360 11124752384 1799392288 18.009 100 84 168 0 1836574688 14118240 23064160
23:06:24 2609 8192000000 10747627760 11135229952 1808154752 18.081 100 76 152 0 1842680080 13153056 21372272
23:06:34 3942 8192000000 10755909152 11146969088 1820063520 18.178 100 83 167 0 1857000432 13728576 23208336
23:06:46 2870 8192000000 10764533440 11151486976 1823122768 18.203 100 84 165 1 1860167904 13441664 23603472
23:06:56 1521 8192000000 10775861360 11161219072 1831222224 18.269 100 88 176 0 1869440656 11962048 26256384
23:07:04 3111 8192000000 10777716528 11159433216 1834549376 18.296 100 84 168 2 1869892656 12745024 22598256
23:07:14 2346 8192000000 10781995312 11169648640 1839907472 18.340 100 89 178 2 1882111840 17575728 24628640
23:07:23 1966 8192000000 10787448528 11176247296 1844020048 18.374 100 89 178 0 1883844224 14260560 25563616
23:07:31 1837 8192000000 10788302592 11175657472 1849827840 18.421 100 91 183 1 1887146048 12612672 24705536
23:07:40 2580 8192000000 10801549232 11187990528 1852366288 18.441 100 88 175 1 1889500768 13003600 24130880
23:07:49 1690 8192000000 10802088672 11190071296 1853880688 18.454 100 88 174 3 1891232336 12771168 24580480
23:07:57 1807 8192000000 10803995120 11194335232 1861220752 18.513 100 91 182 1 1900135152 12914192 26000208
23:08:05 1960 8192000000 10804677168 11197374464 1863811824 18.534 100 91 183 1 1904025824 13956704 26257296
23:08:13 1642 8192000000 10811535600 11199971328 1867752704 18.566 100 98 197 2 1908137840 13874800 26510336
23:08:21 1305 8192000000 10819824112 11207598080 1868868880 18.575 100 94 187 1 1908897504 13278272 26750352
23:08:29 1928 8192000000 10815584544 11209392128 1872499184 18.604 100 93 184 1 1910921456 12661232 25761040
23:08:37 999 8192000000 10817381360 11208957952 1876066640 18.633 100 93 186 2 1914505312 12470384 25968288
23:08:45 32819 8192000000 10804938864 11206930432 1879735696 18.663 100 72 143 1 1909979520 10466768 19777056
23:09:25 2229 8192000000 10830198480 11223449600 1886844032 18.720 100 92 182 0 1928700048 15614048 26241968
23:09:34 2701 8192000000 10806872048 11217526784 1882477616 18.685 100 65 128 2 1911899488 11658848 17763024
23:09:44 6138 8192000000 10792609856 11215781888 1879255408 18.659 100 45 89 0 1901414112 9537264 12621440
23:10:00 6732 8192000000 10791469232 11217473536 1879343200 18.660 100 27 54 1 1893889600 7318304 7228096
23:10:13 6123 8192000000 10803938208 11219324928 1881926704 18.681 100 39 79 2 1899492832 6874656 10691472
23:10:26 3901 8192000000 10789935360 11220590592 1879423888 18.660 100 33 66 1 1897036064 8247184 9364992
23:10:38 7576 8192000000 10789678096 11216609280 1886510992 18.718 100 42 81 0 1907697584 9320272 11866320
23:10:54 60918 8192000000 10817196800 11234734080 1884784624 18.704 100 38 74 3 1905996272 10953648 10258000
23:12:02 5453 8192000000 10793821024 11231453184 1885081136 18.706 100 30 60 1 1901180432 7775296 8324000
23:12:15 7031 8192000000 10801934688 11233947648 1885970672 18.713 100 21 42 0 1898128976 6505552 5652752
23:12:28 10038 8192000000 10800975024 11233660928 1887637168 18.727 100 22 44 1 1899545680 5782080 6126432
23:12:48 7989 8192000000 10812059024 11236028416 1889415632 18.741 100 20 39 4 1901092912 6285808 5391472
23:13:04 8179 8192000000 10799677632 11236904960 1893232272 18.772 100 25 50 0 1906021760 6266288 6523200
23:13:19 7171 8192000000 10810710096 11244068864 1892442624 18.765 100 25 49 2 1904951152 5996432 6512096
23:13:32 11692 8192000000 10804566320 11244396544 1897795760 18.809 100 23 46 2 1910609712 6085568 6728384
23:13:52 10843 8192000000 10811745184 11249790976 1898781728 18.816 100 24 46 3 1914875616 9882720 6211168
23:14:11 11537 8192000000 10807930912 11247935488 1900719760 18.832 100 18 36 1 1912515184 6340464 5454960
23:14:30 7131 8192000000 10828168480 11256238080 1904513120 18.863 100 24 42 3 1915991616 5326736 6151760
23:14:43 4505 8192000000 10819287024 11257860096 1906831104 18.881 100 21 41 1 1918239360 5670672 5737584
23:15:00 8044 8192000000 10816923904 11255275520 1906857056 18.881 100 19 35 3 1917809856 5428352 5524448
23:15:14 4006 8192000000 10825613632 11260600320 1910378976 18.910 100 31 61 3 1925504432 6151968 8973488
23:15:28 67771 8192000000 10834210704 11241930752 1887231808 18.723 99 35 71 0 1903498336 5093136 11173392
23:16:42 5530 8192000000 10823148864 11259195392 1908340528 18.893 100 47 93 2 1931558208 10273824 12943856
23:16:55 6457 8192000000 10802445952 11238543360 1861099136 18.512 98 25 50 0 1874295952 6303968 6892848
23:17:07 4719 8192000000 10822835264 11250774016 1896006192 18.794 100 33 67 2 1915709632 10428496 9274944
23:17:21 6786 8192000000 10810762464 11237937152 1864207632 18.537 98 33 66 1 1880714480 6611936 9894912
23:17:35 7785 8192000000 10809782192 11240300544 1877688480 18.646 99 28 56 0 1892813776 6899456 8225840
23:17:52 6870 8192000000 10788384224 11217993728 1846496272 18.394 98 28 55 1 1860855376 6439520 7919584
23:18:05 8373 8192000000 10795431472 11222409216 1857642560 18.484 99 37 73 3 1875000160 7217040 10140560
23:18:20 7721 8192000000 10784557424 11207876608 1839051312 18.333 98 24 48 0 1851380416 5179312 7149792
23:18:35 7437 8192000000 10748494640 11170451456 1749237904 17.595 94 26 53 1 1762813232 6400784 7174544
23:18:49 7185 8192000000 10720224816 11143786496 1742033072 17.536 95 31 61 3 1756354336 5619648 8701616
23:19:03 11831 8192000000 10741846000 11150921728 1737045232 17.494 95 30 62 1 1750863744 5181872 8636640
23:19:21 59937 8192000000 10721913264 11144450048 1749500304 17.597 96 35 70 0 1765600064 6421376 9678384
23:20:27 18340 8192000000 10699159968 11120099328 1686760640 17.074 93 9 18 0 1694646400 4702240 3183520
23:20:52 8879 8192000000 10710014752 11121414144 1750322736 17.604 98 24 48 0 1762623504 6070608 6230160
23:21:07 3796 8192000000 10701634592 11112108032 1725580384 17.399 96 33 64 0 1744466496 10282944 8603168
23:21:18 4867 8192000000 10696260032 11105619968 1765278912 17.728 99 26 52 2 1778819424 5981296 7559216
23:21:28 5824 8192000000 10685779808 11082842112 1711966144 17.285 96 37 76 1 1728001888 6181376 9854368
23:21:40 5067 8192000000 10680163664 11097362432 1771443488 17.779 100 22 44 1 1783749168 5671008 6634672
23:21:53 7521 8192000000 10694479600 11109859328 1737436576 17.497 97 26 52 1 1750752560 5656960 7659024
23:22:09 12037 8192000000 10695021840 11107930112 1731201024 17.445 97 22 43 1 1743411248 5834288 6375936
23:22:28 6431 8192000000 10721660672 11134664704 1800747504 18.020 100 25 50 1 1813095536 5221040 7126992
23:22:41 9379 8192000000 10726161920 11147870208 1809806240 18.094 100 27 54 1 1827644432 10166592 7671600
23:22:57 7269 8192000000 10740162688 11155054592 1804680336 18.052 99 35 68 1 1820330656 5091840 10558480
23:23:14 4800 8192000000 10734128864 11158130688 1812397424 18.116 99 20 40 2 1824541200 6561280 5582496
23:23:26 24600 8192000000 10751308832 11174121472 1837247824 18.318 100 26 51 1 1850465648 5158448 8059376
23:24:14 35308 8192000000 10743735008 11170844672 1806988512 18.071 98 27 53 2 1819788976 4919344 7881120
23:25:02 5870 8192000000 10769232864 11189354496 1849605408 18.419 100 33 67 4 1865064112 5631248 9827456
23:25:16 7434 8192000000 10768218656 11196674048 1856520032 18.475 100 29 56 3 1870942480 6492976 7929472
23:25:32 8684 8192000000 10773437088 11199987712 1859046512 18.496 100 33 67 0 1875458080 7387024 9024544
23:25:47 7861 8192000000 10776072736 11201277952 1863244448 18.530 100 37 74 1 1880336256 6314976 10776832
23:26:03 10236 8192000000 10791856672 11215208448 1865398528 18.547 100 24 48 1 1877944976 5471328 7075120
23:26:23 4314 8192000000 10799966912 11225116672 1874524464 18.621 100 34 68 4 1895929216 11889712 9515040
23:26:36 7250 8192000000 10795776224 11219513344 1876966064 18.641 100 26 52 1 1890341856 6099664 7276128
23:26:52 16628 8192000000 10803124848 11231715328 1882176512 18.683 100 16 32 1 1892853952 5610304 5067136
23:27:17 26566 8192000000 10844673504 11259904000 1908660400 18.896 100 44 88 1 1928138672 6176176 13302096
23:27:53 33265 8192000000 10846133824 11272781824 1917447472 18.966 100 44 87 0 1939387392 9421856 12518064
23:28:36 5039 8192000000 10867203392 11289612288 1931347168 19.078 100 42 82 0 1954898640 11503088 12048384
23:28:53 3485 8192000000 10882881520 11301257216 1939734864 19.145 100 52 104 0 1966858848 12224912 14899072
23:29:05 3431 8192000000 10881518992 11304079360 1952760832 19.248 100 61 121 2 1983000032 12465120 17774080
23:29:17 22337 8192000000 10881444352 11312050176 1935214464 19.109 99 59 117 2 1965102592 13073056 16815072
23:30:19 43709 8192000000 10889224768 11323842560 1953125264 19.251 100 42 84 1 1984213376 19251376 11836736
23:31:11 22783 8192000000 10893368512 11330379776 1959349744 19.301 100 41 81 1 1990790896 19858912 11582240
23:31:51 4273 8192000000 10908758752 11339300864 1965764976 19.352 100 47 94 1 1998603376 19499728 13338672
23:32:03 7330 8192000000 10907033456 11340529664 1964360704 19.341 100 42 85 1 1996620896 20529008 11731184
23:32:34 39038 8192000000 10903973664 11353853952 1977324720 19.444 100 39 78 3 2012681424 23888656 11468048
23:33:39 3253 8192000000 10920799168 11358912512 1980880784 19.472 100 40 80 0 2012839936 19631216 12327936
23:33:52 9144 8192000000 10916604048 11345534976 1959501872 19.302 99 47 93 1 1994131296 20837392 13792032
23:34:11 10030 8192000000 10931916896 11363086336 1982211232 19.482 100 56 112 1 2021320816 22245360 16864224
23:34:28 17292 8192000000 10936961296 11366731776 1984378400 19.499 100 49 98 0 2026818592 27981104 14459088
23:35:04 5025 8192000000 10953224992 11383504896 1992609504 19.564 100 50 99 1 2040294912 32957472 14727936
23:35:16 7762 8192000000 10945031744 11375300608 1987321584 19.523 100 48 94 0 2031439104 29118288 14999232
23:35:35 3974 8192000000 10954963856 11382423552 1992279232 19.562 100 66 132 1 2043084336 31266672 19538432
23:35:47 3584 8192000000 10967694992 11389210624 2001643184 19.636 100 72 143 0 2052130672 30308688 20178800
23:35:59 5354 8192000000 10968993856 11396620288 2007643520 19.683 100 66 131 2 2059977232 31552928 20780784
23:36:11 1281 8192000000 10979303696 11393593344 2005737024 19.668 100 82 164 0 2064035120 33401888 24896208
23:36:20 3344 8192000000 10982091472 11401281536 2010695376 19.707 100 83 165 2 2070171104 34953936 24521792
23:36:34 8087 8192000000 10959131424 11396861952 2008887136 19.693 100 61 122 3 2057293600 29891248 18515216
23:36:52 8060 8192000000 10967784848 11400773632 2014855472 19.740 100 72 144 2 2068191904 30872864 22463568
23:37:09 8293 8192000000 10981240688 11412447232 2015968720 19.748 100 59 116 0 2067625584 33000912 18655952
23:37:25 5158 8192000000 10971639728 11406524416 2011928832 19.717 100 66 132 0 2066650416 33852432 20869152
23:37:37 3221 8192000000 10967734704 11401252864 1994946816 19.583 99 66 128 3 2047871744 32672336 20252592
23:37:50 2982 8192000000 10965485808 11391361024 1996273888 19.593 99 68 136 0 2050533136 33674352 20584896
23:38:01 3324 8192000000 10983844048 11401748480 2008528656 19.690 100 79 156 1 2067860784 35819328 23512800
23:38:16 1714 8192000000 10983698016 11402571776 2009326944 19.696 100 87 172 0 2068935744 33234416 26374384
23:38:25 5463 8192000000 10989907008 11410264064 2013898576 19.732 100 78 157 2 2070747632 32552224 24296832
23:38:41 3000 8192000000 10985866016 11408011264 2009870640 19.701 100 86 172 1 2069180864 32917248 26392976
23:38:51 7574 8192000000 10991109696 11415326720 2017924624 19.764 100 78 156 2 2075977344 34217264 23835456
23:39:10 13769 8192000000 10982201392 11421605888 2024165008 19.813 100 75 147 1 2079789424 32616528 23007888
23:39:37 4359 8192000000 10955135872 11385851904 1988499760 19.532 99 57 113 3 2033404720 27974064 16930896
23:39:50 1192 8192000000 10974612944 11389431808 1998469824 19.611 99 79 155 1 2048794064 27582752 22741488
23:39:58 3977 8192000000 10977948512 11396935680 2009202032 19.695 100 77 154 1 2062643392 29911904 23529456
23:40:09 7809 8192000000 10985730384 11406286848 2012405136 19.720 100 80 158 0 2066489520 30384112 23700272
23:40:23 2206 8192000000 10989079632 11409801216 2000865360 19.630 99 88 176 2 2061141280 33084544 27191376
23:40:33 2029 8192000000 10979216256 11404210176 1999861296 19.622 99 83 164 1 2058707504 34025360 24820848
23:40:41 1498 8192000000 10992504464 11411476480 2013988048 19.733 100 88 176 1 2075085840 34582448 26515344
23:40:50 3504 8192000000 10980283120 11401388032 2001840048 19.637 100 81 161 0 2060897904 34922896 24134960
23:41:01 1209 8192000000 10986365504 11400765440 2010191440 19.703 100 86 166 1 2069693200 34758384 24743376
23:41:09 2875 8192000000 10982623392 11409461248 2014945760 19.740 100 75 150 1 2072828368 35497376 22385232
23:41:23 4245 8192000000 10983785104 11414306816 2013398512 19.728 100 68 136 2 2069410736 35804512 20207712
23:41:36 4058 8192000000 10986810352 11414941696 2011799520 19.716 100 70 140 0 2070837408 37236624 21801264
23:41:49 4394 8192000000 10972843616 11395911680 1970662672 19.391 98 72 144 0 2031686544 38441520 22582352
23:42:01 6495 8192000000 10981338112 11408211968 2006996272 19.678 100 76 149 4 2068261504 38755760 22509472
23:42:15 3653 8192000000 10967542208 11392360448 1980618240 19.470 99 78 157 1 2045134160 38736960 25778960
23:42:27 2982 8192000000 10967767440 11383730176 1968053008 19.370 99 69 137 2 2029271408 39527808 21690592
23:42:38 2009 8192000000 10978294272 11387965440 1971800784 19.400 99 79 154 0 2035489968 39273440 24415744
23:42:47 1747 8192000000 10980270784 11392737280 1990723104 19.550 100 88 174 2 2060115872 42170544 27222224
23:42:59 3375 8192000000 10969467936 11392499712 1979166256 19.458 99 79 157 1 2045936224 42041152 24728816
23:43:10 4405 8192000000 10968673552 11393417216 1989943440 19.543 100 66 132 0 2050933696 40145296 20844960
23:43:25 1712 8192000000 10982691920 11392946176 1992690336 19.565 100 84 168 2 2062099728 43083680 26325712
23:43:34 3806 8192000000 10966396304 11382812672 1980842576 19.471 100 84 166 1 2048724768 42178512 25703680
23:43:45 4371 8192000000 10963073168 11375898624 1962918064 19.329 99 79 158 2 2030898976 43892944 24087968
23:43:56 3788 8192000000 10955694880 11366494208 1962425840 19.325 99 88 176 0 2040013536 51151856 26435840
23:44:07 5156 8192000000 10970689184 11383275520 1975551712 19.429 100 84 167 1 2049367536 49249696 24566128
23:44:20 1322 8192000000 10983020864 11392544768 1984945072 19.504 100 90 182 2 2064283056 51925952 27412032
23:44:30 1631 8192000000 10954854144 11359961088 1925934336 19.034 98 87 174 4 2007162960 53170016 28058608
23:44:38 4135 8192000000 10941123264 11349270528 1939465792 19.142 99 80 160 4 2020771904 56403120 24902992
23:44:51 1737 8192000000 10963815840 11377594368 1968920624 19.377 100 86 172 4 2052689264 55970000 27798640
23:45:01 2766 8192000000 10956088432 11360792576 1945363888 19.190 99 89 177 1 2032018512 58183744 28470880
23:45:12 3097 8192000000 10955670096 11363450880 1948548544 19.215 100 85 169 1 2035988752 59956192 27484016
23:45:23 6032 8192000000 10942924032 11362988032 1943597040 19.175 100 66 132 0 2026292464 61221328 21474096
23:45:36 19987 8192000000 10934030224 11365941248 1928276752 19.053 99 40 80 2 1997117776 54433952 14407072
23:46:05 2355 8192000000 10952421600 11366731776 1953244208 19.252 100 79 156 4 2037537328 58841408 25451712
23:46:13 2330 8192000000 10954720272 11368878080 1951689968 19.240 100 81 160 1 2038932480 61211392 26031120
23:46:26 846 8192000000 10973394064 11378188288 1961798528 19.320 100 91 181 0 2051094400 59997312 29298560
23:46:34 2777 8192000000 10946076304 11364085760 1947658624 19.208 100 74 148 1 2031738784 60630160 23450000
23:46:45 6770 8192000000 10932292928 11363008512 1941740544 19.161 100 48 96 2 2019043264 61259568 16043152
23:47:11 6592 8192000000 10934371488 11369746432 1952503808 19.246 100 41 82 1 2019380048 53254448 13621792
23:47:25 10229 8192000000 10940063376 11388133376 1958655088 19.295 100 30 60 1 2029210064 60672192 9882784
23:47:45 15377 8192000000 10930863904 11374641152 1944149456 19.180 99 31 62 1 2003925472 49428400 10347616
23:48:08 8385 8192000000 10947739760 11384721408 1965153072 19.347 100 40 80 1 2027464976 49701856 12610048
23:48:25 10330 8192000000 10956411616 11392270336 1966736352 19.360 100 41 82 1 2032715184 52456352 13522480
23:49:01 23160 8192000000 10950233504 11405078528 1966991424 19.362 100 37 74 3 2032007680 52500768 12515488
23:49:54 12125 8192000000 10969857936 11410690048 1978213328 19.451 100 43 86 2 2048986928 55495584 15278016
23:50:17 10099 8192000000 10960228384 11412185088 1979881168 19.464 100 32 64 1 2047053680 55538800 11633712
23:50:51 17006 8192000000 10938680704 11389792256 1971289488 19.396 100 23 46 2 2023065056 43680224 8095344
23:51:15 23860 8192000000 10954105200 11401900032 1968280752 19.372 99 32 64 2 2030262944 51258816 10723376
23:51:48 25097 8192000000 10944801200 11401773056 1974685728 19.423 100 20 40 0 2035858176 53802176 7370272
23:52:38 20047 8192000000 10936370016 11393871872 1949536080 19.223 100 28 56 2 2020985392 60659168 10790144
23:53:12 36985 8192000000 10912736000 11374977024 1924104976 19.020 99 18 36 0 1987020496 55998576 6916944
23:53:56 39271 8192000000 10871790208 11338194944 1874893488 18.624 97 10 20 1 1917014992 38401696 3719808
23:54:41 44876 8192000000 10862441856 11313020928 1887238752 18.724 98 12 24 0 1908286960 17625728 3422480
23:55:35 43553 8192000000 10864048464 11327856640 1905644512 18.872 99 11 22 1 1929130784 20256720 3229552
23:56:24 87103 8192000000 10878559392 11326332928 1902628112 18.847 98 33 66 1 1926392176 14079312 9684752
23:57:59 45765 8192000000 10903959632 11339173888 1958594704 19.295 100 37 75 1 1976838192 7880928 10362560
23:58:59 98188 8192000000 10878238384 11324661760 1919222528 18.981 98 32 63 2 1934612640 6370464 9019648
00:00:43 82798 8192000000 10906401488 11364143104 1954123280 19.259 99 16 32 0 1966734160 8296192 4314688
00:02:35 81905 8192000000 10909347456 11350024192 1925045728 19.027 98 37 74 1 1947395184 11836016 10513440
00:04:09 132162 8192000000 10927562784 11374092288 1960848432 19.313 99 24 47 1 1985378512 17759248 6770832
00:06:28 35096 8192000000 10931192352 11370528768 1982555888 19.485 100 39 75 2 2015360432 22148224 10656320
00:07:15 46892 8192000000 10918152608 11390349312 1981332976 19.475 100 31 61 1 2016127840 26180176 8614688
00:08:15 27598 8192000000 10902235328 11380862976 1979229088 19.459 100 6 12 0 1992044864 11276944 1538832
00:08:48 51664 8192000000 10899866880 11377635328 1982306192 19.483 100 5 10 0 1990459632 6888864 1264576
00:09:46 28367 8192000000 10897041536 11377266688 1966539568 19.358 99 5 10 0 1975519504 7648560 1331376
00:10:32 48761 8192000000 10910048368 11391954944 1972072640 19.402 99 16 32 1 1990999568 14457824 4469104
00:11:27 58424 8192000000 10914329392 11376885760 1960088464 19.307 99 17 33 4 1977597584 12553392 4955728
00:12:41 89611 8192000000 10914333808 11381055488 1977159584 19.442 100 17 35 1 1989627216 7807952 4659680
00:14:17 25732 8192000000 10906553360 11382083584 1991046928 19.552 100 36 72 2 2010991248 9681104 10263216
00:15:00 48678 8192000000 10901430784 11382984704 1974212384 19.419 99 16 32 1 1991536944 12808912 4515648
00:16:04 61992 8192000000 10924030336 11390033920 1984682064 19.502 100 13 26 2 1997991744 9939888 3369792
00:17:28 87315 8192000000 10914558400 11389378560 1970843632 19.392 99 18 36 0 1990775584 15270000 4661952
00:19:01 70663 8192000000 10906834160 11367284736 1900773984 18.833 95 14 28 0 1913328176 8815584 3738608
00:20:21 22884 8192000000 10917086208 11369009152 1924399520 19.022 97 50 100 2 1950759952 11972032 14388400
00:20:52 17890 8192000000 10899871968 11353628672 1951528032 19.239 99 46 92 3 1978532416 14231392 12772992
00:21:19 61977 8192000000 10894721632 11368628224 1950332448 19.229 99 19 38 0 1972434592 16882976 5219168
00:22:28 69210 8192000000 10875217264 11341438976 1867971664 18.568 95 8 16 0 1881306800 11244784 2090352
00:23:47 54921 8192000000 10891148096 11365322752 1918628016 18.976 98 31 60 1 1936790304 9578144 8584144
00:24:48 34955 8192000000 10896825648 11356311552 1922039264 19.003 98 27 53 1 1942751840 13247664 7464912
00:25:31 40779 8192000000 10888254160 11358081024 1942726592 19.169 99 21 42 0 1966204800 17440400 6037808
00:26:23 40637 8192000000 10907084352 11362025472 1926761984 19.041 98 37 74 1 1952959408 15750720 10446704
00:27:13 41039 8192000000 10907148016 11379712000 1929477856 19.063 98 22 44 2 1950219472 14932384 5809232
00:28:05 62137 8192000000 10878189072 11343253504 1846703216 18.395 94 19 37 4 1864110240 12199024 5208000
00:29:13 79646 8192000000 10856738048 11320963072 1849197840 18.416 95 10 20 2 1862035776 10557728 2280208
00:30:42 77208 8192000000 10867745056 11324514304 1926319984 19.037 99 26 52 0 1940689392 6722160 7647248
00:32:08 48671 8192000000 10867018608 11339194368 1936527472 19.119 99 17 33 0 1947614640 6366240 4720928
00:33:03 34038 8192000000 10848007648 11313745920 1893389152 18.773 97 18 35 0 1905282064 7138240 4754672
00:33:44 46873 8192000000 10864703696 11338702848 1937616240 19.128 100 11 22 0 1948707728 8205072 2886416
00:35:47 62378 8192000000 10863418352 11352109056 1884792336 18.704 96 8 16 0 1897119968 10011120 2316512
00:37:01 50345 8192000000 10902486192 11352387584 1946228576 19.196 100 37 74 0 1978533264 21386096 10918592
00:38:03 62524 8192000000 10862318032 11341201408 1873831856 18.615 96 17 34 2 1893812560 14842112 5138592
00:39:22 103640 8192000000 10888959088 11369406464 1911949648 18.922 98 17 34 1 1929188432 12339184 4899600
00:41:13 84376 8192000000 10889525776 11377590272 1921808352 19.001 98 15 30 0 1947188752 21098784 4281616
00:43:55 84897 8192000000 10887517984 11340435456 1879634192 18.662 96 14 28 0 1895270416 11879312 3756912
00:45:37 60522 8192000000 10873244064 11345379328 1868221744 18.570 96 22 44 1 1896647264 22506688 5918832
00:47:21 34672 8192000000 10901528016 11359399936 1933964704 19.099 99 30 60 0 1957378736 15124880 8289152
00:48:06 68467 8192000000 10888271088 11358965760 1931385552 19.078 99 21 42 1 1948968496 11984960 5597984
00:49:21 87747 8192000000 10877195456 11356848128 1939657056 19.144 99 10 20 0 1955574416 13200112 2717248
00:51:01 48725 8192000000 10880893616 11353612288 1944224752 19.180 99 25 50 1 1957270384 6263376 6782256
00:51:58 36698 8192000000 10899728736 11359272960 1936493168 19.119 98 35 69 2 1955131648 9016336 9622144
00:52:58 46467 8192000000 10898628224 11374850048 1974418352 19.420 100 21 42 2 1991391648 11195456 5777840
00:53:51 11816 8192000000 10893429968 11377102848 1973763296 19.415 100 11 22 1 1990505296 13739968 3002032
00:55:26 47282 8192000000 10893309408 11360931840 1937049248 19.123 98 17 34 0 1951799616 10124016 4626352
00:56:20 69920 8192000000 10912459424 11382304768 1979213536 19.458 100 28 54 3 1998215376 11160928 7840912
00:57:36 63418 8192000000 10888481312 11367059456 1962513168 19.326 99 10 20 1 1980348576 14554128 3281280
00:58:53 76707 8192000000 10899555568 11374829568 1947330288 19.205 98 19 38 0 1961423872 8702960 5390624
01:00:16 47809 8192000000 10916195536 11385610240 1972288480 19.404 99 17 35 0 1983147408 6615216 4243712
01:01:10 28002 8192000000 10910961264 11380080640 1953242976 19.252 98 19 38 1 1966067952 7833872 4991104
01:01:51 61614 8192000000 10907323856 11380379648 1952239424 19.244 98 10 20 0 1963152224 8288752 2624048
01:02:59 22424 8192000000 10928463216 11384274944 1977782144 19.447 99 42 83 1 1997088016 7890096 11415776
01:03:27 16017 8192000000 10898826944 11358486528 1952745648 19.248 98 37 74 1 1971388032 7977760 10664624
01:03:50 27508 8192000000 10920040752 11382931456 1968767760 19.376 99 41 80 1 1989793840 9658128 11367952
01:04:33 63364 8192000000 10914040064 11389779968 1950576080 19.231 98 13 26 0 1965815504 11294816 3944608
01:05:47 32826 8192000000 10922646384 11382902784 1939223872 19.141 97 43 86 3 1963688656 11947520 12517264
01:06:27 33220 8192000000 10925284560 11394117632 1972497392 19.405 99 34 68 3 1998118624 15737232 9884000
01:07:10 49235 8192000000 10896571088 11375718400 1947340768 19.205 98 17 34 2 1963935392 11707424 4887200
01:08:29 29898 8192000000 10919180240 11383361536 1953726672 19.256 98 28 56 2 1972542304 11095952 7719680
01:09:10 91777 8192000000 10902600448 11389763584 1945874464 19.194 98 17 34 1 1966232672 15880784 4477424
01:10:52 26053 8192000000 10899527696 11361677312 1929126736 19.060 97 36 71 1 1946405936 7293312 9985888
01:11:25 42023 8192000000 10924359616 11381673984 1929678576 19.064 98 30 60 2 1957432800 19819264 7934960
01:12:18 55111 8192000000 10895420880 11385106432 1950840752 19.233 99 9 18 0 1968852080 15462064 2549264
01:13:25 118493 8192000000 10836507952 11304157184 1806172272 18.065 92 17 34 0 1819800768 8829552 4798944
01:15:45 65671 8192000000 10850571328 11310546944 1882084240 18.682 97 20 40 1 1894315040 7524144 4706656
01:16:57 52930 8192000000 10822433792 11290841088 1899404416 18.822 98 22 44 1 1915574752 9688112 6482224
01:17:59 59442 8192000000 10855436448 11333914624 1899567424 18.823 98 12 24 0 1912975296 10120304 3287568
01:19:06 93351 8192000000 10865002320 11352416256 1940357792 19.150 100 6 12 0 1954823712 12986624 1479296
01:20:50 74847 8192000000 10842445632 11318726656 1864037968 18.536 96 7 14 0 1874822512 8405840 2378704
01:22:18 48448 8192000000 10825586896 11295338496 1855996896 18.471 96 13 27 1 1866001488 6629264 3375328
01:23:13 44288 8192000000 10862200416 11327926272 1930683200 19.072 100 17 34 0 1946284496 10823264 4778032
01:24:12 35155 8192000000 10860910624 11328102400 1916756256 18.961 99 27 54 2 1937974848 13200608 8017984
01:24:54 49895 8192000000 10852617424 11338014720 1904167600 18.860 98 14 28 1 1925717904 17718096 3832208
01:25:52 49822 8192000000 10857395056 11320709120 1859652064 18.500 96 18 36 2 1880779712 15845760 5281888
01:26:58 15571 8192000000 9051579040 9263280128 221858096 2.636 12 3 6 0 226319456 3770608 690752

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 26-12-2020 01:28:27 to 26-12-2020 01:28:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 205 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

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

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          245578
MON$OLDEST_ACTIVE               245579
MON$OLDEST_SNAPSHOT             245579
MON$NEXT_TRANSACTION            245579
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                       2039456
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
--- end of diff output ---

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

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