Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.11.2020 22: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 17412228 kB
MemAvailable 31609532 kB
Buffers 0 kB
Cached 14261404 kB
SwapCached 2208 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-29 22:27:05
DTS_END                         2020-11-29 22:27:05.6930
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/41782
TRN_ID                          241926
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: 9262.58 20889 1111509
customer order: creation 173.38 355 20805
customer order: refuse 14.31 358 1717
order to supplier: creation 45.15 1537 5418
order to supplier: removal 3.74 103058 449
invoice (draft): creation 44.63 3443 5355
invoice (draft): removal 52.85 844 6342
invoice accept: apply 41.65 19184 4998
invoice accept: cancel 47.95 814 5754
customer reserve: creation 3833.19 190 459983
customer reserve: removal 4722.58 65 566709
realization accept: apply 82.21 202 9865
realization accept: cancel 71.87 123 8624
payment from customer: creation 58.18 128 6982
payment from customer: removal 5.85 112 702
payment to supplier: creation 49.69 131 5963
payment to supplier: removal 2.95 120 354
service: total inventory turnovers 4.91 948 589
service: total monetary turnovers 6.66 25 799
service: aggregate perf. data 0.81 24931 97
service: refresh index statistics 0.03 261207 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 29-11-2020 22:28:21 to 29-11-2020 22:28:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 13835
TEST_TIME 2 9778
TEST_TIME 3 8797
TEST_TIME 4 7930
TEST_TIME 5 8235
TEST_TIME 6 7740
TEST_TIME 7 7585
TEST_TIME 8 7318
TEST_TIME 9 7428
TEST_TIME 10 7516
TEST_TIME 11 7478
TEST_TIME 12 7347
TEST_TIME 13 7338
TEST_TIME 14 7730
TEST_TIME 15 7659
TEST_TIME 16 7671
TEST_TIME 17 7475
TEST_TIME 18 7385
TEST_TIME 19 7692
TEST_TIME 20 7854
TEST_TIME 21 8273
TEST_TIME 22 8447
TEST_TIME 23 8544
TEST_TIME 24 8618
TEST_TIME 25 8634
TEST_TIME 26 8703
TEST_TIME 27 8956
TEST_TIME 28 8809
TEST_TIME 29 9079
TEST_TIME 30 9800
TEST_TIME 31 9732
TEST_TIME 32 10268
TEST_TIME 33 10973
TEST_TIME 34 10676
TEST_TIME 35 10576
TEST_TIME 36 10591
TEST_TIME 37 10460
TEST_TIME 38 10321
TEST_TIME 39 10209
TEST_TIME 40 10150
TEST_TIME 41 10042
TEST_TIME 42 9980
TEST_TIME 43 10163
TEST_TIME 44 10156
TEST_TIME 45 10179
TEST_TIME 46 10149
TEST_TIME 47 10063
TEST_TIME 48 10019
TEST_TIME 49 9913
TEST_TIME 50 9910
TEST_TIME 51 9888
TEST_TIME 52 10012
TEST_TIME 53 9873
TEST_TIME 54 9762
TEST_TIME 55 9703
TEST_TIME 56 9734
TEST_TIME 57 9687
TEST_TIME 58 9626
TEST_TIME 59 9647
TEST_TIME 60 9644
TEST_TIME 61 9740
TEST_TIME 62 9657
TEST_TIME 63 9594
TEST_TIME 64 9494
TEST_TIME 65 9449
TEST_TIME 66 9385
TEST_TIME 67 9357
TEST_TIME 68 9501
TEST_TIME 69 9552
TEST_TIME 70 9521
TEST_TIME 71 9567
TEST_TIME 72 9565
TEST_TIME 73 9535
TEST_TIME 74 9535
TEST_TIME 75 9625
TEST_TIME 76 9663
TEST_TIME 77 9669
TEST_TIME 78 9674
TEST_TIME 79 9724
TEST_TIME 80 9637
TEST_TIME 81 9599
TEST_TIME 82 9547
TEST_TIME 83 9541
TEST_TIME 84 9486
TEST_TIME 85 9467
TEST_TIME 86 9441
TEST_TIME 87 9399
TEST_TIME 88 9397
TEST_TIME 89 9350
TEST_TIME 90 9312
TEST_TIME 91 9310
TEST_TIME 92 9370
TEST_TIME 93 9404
TEST_TIME 94 9411
TEST_TIME 95 9463
TEST_TIME 96 9473
TEST_TIME 97 9527
TEST_TIME 98 9546
TEST_TIME 99 9565
TEST_TIME 100 9549
TEST_TIME 101 9563
TEST_TIME 102 9598
TEST_TIME 103 9573
TEST_TIME 104 9552
TEST_TIME 105 9501
TEST_TIME 106 9534
TEST_TIME 107 9497
TEST_TIME 108 9492
TEST_TIME 109 9464
TEST_TIME 110 9438
TEST_TIME 111 9419
TEST_TIME 112 9355
TEST_TIME 113 9416
TEST_TIME 114 9388
TEST_TIME 115 9363
TEST_TIME 116 9331
TEST_TIME 117 9308
TEST_TIME 118 9288
TEST_TIME 119 9257
TEST_TIME 120 9276

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 29-11-2020 22:28:25 to 29-11-2020 22:28:29.

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 1535984 1535984 0 0.00 0 24471 6 0 0
doc_list_biud 1535983 1535983 0 0.00 0 24269 30 0 0
sp_add_invoice_to_stock 5132 4998 134 2.61 43 235879 19184 0 134
sp_cancel_adding_invoice 5754 5754 0 0.00 5 85539 815 0 0
sp_cancel_client_order 1717 1717 0 0.00 3 18061 358 0 0
sp_cancel_customer_reserve 566709 566709 0 0.00 1 21529 65 0 0
sp_cancel_pay_from_customer 702 702 0 0.00 3 8518 113 0 0
sp_cancel_pay_to_supplier 354 354 0 0.00 3 6966 121 0 0
sp_cancel_supplier_invoice 6352 6342 10 0.15 3 18581 844 0 10
sp_cancel_supplier_order 449 449 0 0.00 8 932342 103058 0 0
sp_cancel_write_off 8624 8624 0 0.00 1 24294 124 0 0
sp_client_order 20805 20805 0 0.00 3 17871 355 0 0
sp_customer_reserve 459983 459983 0 0.00 0 126195 190 0 0
sp_fill_shopping_cart 31575 31575 0 0.00 1 16827 40 0 0
sp_fill_shopping_cart_clo_res 459959 459959 0 0.00 0 15455 14 0 0
sp_get_clo_for_invoice 4971 4971 0 0.00 0 44952 284 0 0
sp_kill_cost_storno 15434 15434 0 0.00 0 8145 64 0 0
sp_kill_qstorno_ret_qs2qd 1148833 1148833 0 0.00 0 24266 35 0 0
sp_kill_qty_storno 604431 604431 0 0.00 0 24268 75 0 0
sp_lock_selected_doc 20492 20492 0 0.00 0 9656 7 0 0
sp_make_cost_storno 27781 27781 0 0.00 0 12956 64 0 0
sp_multiply_rows_for_pdistr 27780 27780 0 0.00 0 10186 29 0 0
sp_multiply_rows_for_qdistr 20805 20805 0 0.00 0 10466 146 0 0
sp_pay_from_customer 6982 6982 0 0.00 4 14281 128 0 0
sp_pay_to_supplier 5963 5963 0 0.00 4 13465 132 0 0
sp_payment_common 12944 12944 0 0.00 1 10205 34 0 0
sp_qd_handle_on_cancel_clo 1717 1717 0 0.00 0 18054 328 0 0
sp_qd_handle_on_invoice_upd_sts 10725 10725 0 0.00 0 11806 319 0 0
sp_qd_handle_on_reserve_upd_sts 9865 9865 0 0.00 0 12329 61 0 0
sp_reserve_write_off 9865 9865 0 0.00 7 15151 203 0 0
sp_supplier_invoice 5355 5355 0 0.00 6 112359 3443 0 0
sp_supplier_order 5418 5418 0 0.00 6 54102 1538 0 0
srv_aggregate_perf_data 97 97 0 0.00 3038 273597 24931 0 0
srv_fill_mon_cache_memory 174 174 0 0.00 1080 155056 29724 0 0
srv_find_qd_qs_mism 1063210 1063210 0 0.00 0 24469 5 0 0
srv_make_invnt_saldo 589 589 0 0.00 31 27873 949 0 0
srv_make_money_saldo 799 799 0 0.00 0 1700 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 89546 626912 261208 0 0
t$perf-abend:sp_add_invoice_to_stock 134 134 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4998 4998 0 0.00 0 15170 188 0 0
t$perf-norm:sp_cancel_adding_invoice 403 403 0 0.00 1 8447 109 0 0
t$perf-norm:sp_cancel_client_order 1717 1717 0 0.00 0 4583 14 0 0
t$perf-norm:sp_cancel_customer_reserve 657 657 0 0.00 0 9192 35 0 0
t$perf-norm:sp_cancel_pay_from_customer 702 702 0 0.00 0 8824 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 354 354 0 0.00 0 844 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 395 395 0 0.00 0 2926 41 0 0
t$perf-norm:sp_cancel_supplier_order 449 449 0 0.00 0 29581 1681 0 0
t$perf-norm:sp_cancel_write_off 980 980 0 0.00 0 3764 9 0 0
t$perf-norm:sp_client_order 20805 20805 0 0.00 0 6215 18 0 0
t$perf-norm:sp_customer_reserve 1009 1009 0 0.00 0 2177 6 0 0
t$perf-norm:sp_pay_from_customer 6982 6982 0 0.00 0 8239 15 0 0
t$perf-norm:sp_pay_to_supplier 5963 5963 0 0.00 0 4993 10 0 0
t$perf-norm:sp_reserve_write_off 9865 9865 0 0.00 0 8421 14 0 0
t$perf-norm:sp_supplier_invoice 5355 5355 0 0.00 0 6845 23 0 0
t$perf-norm:sp_supplier_order 5418 5418 0 0.00 0 4919 17 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 669 19 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 4378 31 0 0
t$perf-norm:srv_make_invnt_saldo 589 589 0 0.00 0 1893 22 0 0
t$perf-norm:srv_make_money_saldo 799 799 0 0.00 0 1311 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 17 6 0 0
v_add_invoice_to_stock 10206 9938 268 2.62 0 4832 22 0 268
v_all_customers 37132 37132 0 0.00 0 123 1 0 0
v_all_suppliers 30208 30208 0 0.00 0 19 1 0 0
v_all_wares 41608 41608 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 806 806 0 0.00 0 1521 9 0 0
v_cancel_client_order 3434 3434 0 0.00 0 4531 8 0 0
v_cancel_customer_prepayment 1404 1404 0 0.00 0 4726 19 0 0
v_cancel_customer_reserve 1314 1314 0 0.00 0 860 5 0 0
v_cancel_payment_to_supplier 708 708 0 0.00 0 5343 21 0 0
v_cancel_supplier_invoice 810 790 20 2.46 0 3120 22 0 20
v_cancel_supplier_order 898 898 0 0.00 0 2802 6 0 0
v_cancel_write_off 1960 1960 0 0.00 0 5322 18 0 0
v_max_id_clo_ord 5417 5417 0 0.00 0 1621 2 0 0
v_max_id_clo_res 1009 1009 0 0.00 0 1106 8 0 0
v_max_id_ord_sup 5354 5354 0 0.00 0 5089 5 0 0
v_max_non_paid_invoice 1629 1629 0 0.00 0 241 2 0 0
v_max_non_paid_realizn 3967 3967 0 0.00 0 7264 5 0 0
v_min_id_clo_ord 5417 5417 0 0.00 0 8088 12 0 0
v_min_id_clo_res 1009 1009 0 0.00 0 6893 16 0 0
v_min_id_ord_sup 5354 5354 0 0.00 0 7118 13 0 0
v_min_non_paid_invoice 5962 5962 0 0.00 0 7630 18 0 0
v_min_non_paid_realizn 6982 6982 0 0.00 0 9779 22 0 0
v_our_firm 10506 10506 0 0.00 0 23 1 0 0
v_reserve_write_off 19730 19730 0 0.00 0 5925 8 0 0
x_lock_depdocs_on_canc_invoice 11701 11701 0 0.00 0 24666 128 0 0
x_lock_depdocs_on_canc_sup_ord 449 449 0 0.00 0 3223 314 0 0
x_make_qstorno_1000_1200 5418 5418 0 0.00 2 53744 1448 0 0
x_make_qstorno_1200_2000 5355 5355 0 0.00 3 112038 3303 0 0
x_make_qstorno_2100_3300 459983 459983 0 0.00 0 126194 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-11-2020 22:28:29 to 29-11-2020 22:28:33.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:15 22065 8192000000 10285375904 10594881536 1121015776 12.037 87 68 138 1 1146763232 3092464 22654992
19:57:45 25127 8192000000 10334025360 10648121344 1386879456 14.478 100 86 171 1 1420032144 5056944 28095744
19:58:21 27138 8192000000 10381897744 10705428480 1427419936 14.838 100 87 174 0 1462194480 6457360 28317184
19:59:00 24002 8192000000 10415683952 10743554048 1467315760 15.190 100 91 182 0 1504269008 7508768 29444480
19:59:35 20952 8192000000 10424711728 10758332416 1481137968 15.311 100 87 174 1 1517000624 7673728 28188928
20:00:06 14389 8192000000 10443894064 10777661440 1498505312 15.463 100 86 172 0 1534307648 8114400 27687936
20:00:42 17780 8192000000 10481205216 10820403200 1531709136 15.752 100 86 172 0 1567778352 8726752 27342464
20:01:15 22863 8192000000 10511486848 10857365504 1563418960 16.026 100 87 174 1 1600185968 9765568 27001440
20:01:53 17448 8192000000 10545288480 10898350080 1600736976 16.346 100 78 156 0 1634062208 9952368 23372864
20:02:20 11880 8192000000 10563812944 10918768640 1621646608 16.524 100 84 168 1 1657503984 10452544 25404832
20:02:43 12198 8192000000 10571193792 10934312960 1634675392 16.635 100 70 140 0 1666518272 11119504 20723376
20:03:05 8949 8192000000 10588415280 10954100736 1652626640 16.787 100 70 140 0 1684116208 11134192 20355376
20:03:23 6869 8192000000 10605301056 10976759808 1672541440 16.955 100 74 148 0 1706039328 12024048 21473840
20:03:37 10263 8192000000 10632532416 11002650624 1692767920 17.125 100 79 159 2 1727874704 12483792 22622992
20:03:56 10943 8192000000 10654359600 11028340736 1708943856 17.260 100 73 145 2 1742202240 12659696 20598688
20:04:14 7257 8192000000 10675999200 11048189952 1731654000 17.449 100 79 158 1 1766426192 12730816 22041376
20:04:28 6601 8192000000 10670452880 11050110976 1741593520 17.532 100 73 146 0 1775141824 13023024 20525280
20:04:41 6604 8192000000 10678599168 11058057216 1750488272 17.606 100 76 151 1 1784335088 13052736 20794080
20:04:55 4413 8192000000 10695108768 11074834432 1759173888 17.678 100 77 154 0 1794335568 13651184 21510496
20:05:07 3851 8192000000 10700057408 11083505664 1768270656 17.753 100 76 153 0 1803359280 13537824 21550800
20:05:17 9632 8192000000 10711375312 11093295104 1774940512 17.808 100 66 133 0 1805206560 12771328 17494720
20:05:34 3248 8192000000 10727537648 11112042496 1791287680 17.942 100 79 158 0 1826560608 12714032 22558896
20:05:45 3299 8192000000 10731642480 11115659264 1797208752 17.991 100 83 164 1 1832409680 12432496 22768432
20:05:55 3520 8192000000 10730071584 11124236288 1803003888 18.039 100 71 142 0 1835693616 12110144 20579584
20:06:05 2701 8192000000 10745282704 11136053248 1813533856 18.125 100 76 152 0 1846368000 11383456 21450688
20:06:15 2239 8192000000 10759106128 11145297920 1825434432 18.222 100 82 160 2 1859731872 11776512 22520928
20:06:24 2432 8192000000 10767388864 11153608704 1827985104 18.243 100 88 176 1 1866762144 13343792 25433248
20:06:33 2412 8192000000 10780735440 11164016640 1834778736 18.298 100 82 165 2 1870612272 12637152 23196384
20:06:42 3811 8192000000 10783411344 11165687808 1841023520 18.349 100 84 168 2 1877566272 13143952 23398800
20:06:53 2910 8192000000 10783142160 11171319808 1843935328 18.373 100 87 174 0 1882450736 14167152 24348256
20:07:03 3104 8192000000 10782892112 11170091008 1845769120 18.388 100 78 156 1 1881183008 13679440 21734448
20:07:14 2032 8192000000 10796553440 11183505408 1850389456 18.425 100 85 170 0 1887959968 13195600 24374912
20:07:23 1597 8192000000 10794836672 11180859392 1854373264 18.458 100 88 174 0 1893063296 14012752 24677280
20:07:31 2969 8192000000 10800796560 11188600832 1856510496 18.475 100 92 183 3 1895918704 14503904 24904304
20:07:40 1985 8192000000 10780660448 11180130304 1857050176 18.479 100 75 150 0 1891243472 13416496 20776800
20:07:49 1470 8192000000 10803992160 11194249216 1861127968 18.512 100 95 188 4 1905682288 17697840 26856480
20:07:57 8837 8192000000 10794180304 11187060736 1861967184 18.519 100 79 158 0 1894619408 10597040 22055184
20:08:12 1994 8192000000 10794040240 11192725504 1863794672 18.534 100 79 158 0 1898412384 12001776 22615936
20:08:20 2810 8192000000 10792100448 11190620160 1862259536 18.522 100 66 134 0 1890466592 10020384 18186672
20:08:30 4443 8192000000 10792343136 11195797504 1862398448 18.523 100 55 109 1 1892265200 14288032 15578720
20:08:42 3636 8192000000 10782700224 11193270272 1864120656 18.537 100 63 127 4 1892087152 9587088 18379408
20:08:54 2619 8192000000 10796059136 11200102400 1870064848 18.585 100 67 134 2 1898869536 10459888 18344800
20:09:07 3044 8192000000 10777936720 11200724992 1868251776 18.570 100 41 80 1 1888716720 8900272 11564672
20:09:17 2517 8192000000 10789927136 11203190784 1876465776 18.637 100 42 84 0 1896369120 8282080 11621264
20:09:26 3020 8192000000 10779431664 11205783552 1873778000 18.615 100 40 80 0 1894836784 9330912 11727872
20:09:37 6176 8192000000 10799716512 11211448320 1875083440 18.625 100 33 67 0 1891213456 6422688 9707328
20:09:49 3114 8192000000 10796104128 11208216576 1880805040 18.672 100 35 70 2 1897840080 7903056 9131984
20:09:59 10466 8192000000 10788206848 11215216640 1878592080 18.654 100 29 58 0 1897914096 11449392 7872624
20:10:16 10141 8192000000 10781339152 11214217216 1881743936 18.679 100 29 58 1 1895990496 6212512 8034048
20:10:33 4618 8192000000 10799218432 11222220800 1891087680 18.755 100 33 67 4 1907623040 5842176 10693184
20:10:45 67650 8192000000 10805707648 11239145472 1892364688 18.765 100 34 69 1 1908754144 6246032 10143424
20:12:01 5652 8192000000 10820636960 11242799104 1895629408 18.791 100 29 58 1 1910185152 6357328 8198416
20:12:15 5388 8192000000 10813120016 11243819008 1900373008 18.829 100 38 76 1 1918118384 7022784 10722592
20:12:28 4503 8192000000 10827586768 11249483776 1902072848 18.843 100 34 68 1 1918985328 7144896 9767584
20:12:42 7528 8192000000 10815607872 11247390720 1901891360 18.842 100 27 54 0 1915489872 5624848 7973664
20:12:57 6871 8192000000 10812338448 11248590848 1902717120 18.848 100 22 43 3 1914878640 5691840 6469680
20:13:11 5250 8192000000 10830548240 11260833792 1911434576 18.918 100 31 62 2 1927810240 7476528 8899136
20:13:25 6972 8192000000 10818170336 11256721408 1913533712 18.935 100 21 42 2 1925107616 6037152 5536752
20:13:39 12498 8192000000 10838933440 11261259776 1911544992 18.919 100 25 50 1 1924361472 5669856 7146624
20:13:59 9332 8192000000 10829056544 11262218240 1914957328 18.946 100 22 45 1 1926565424 5458544 6149552
20:14:15 10787 8192000000 10823377056 11261571072 1914677328 18.944 100 21 43 2 1925796224 5278992 5839904
20:14:37 10250 8192000000 10821130864 11254321152 1894277632 18.780 99 18 33 1 1904657664 5403312 4976720
20:15:02 19624 8192000000 10817083680 11248803840 1877338816 18.644 98 24 47 3 1889780672 5174640 7267216
20:15:28 53354 8192000000 10809745344 11240808448 1868401280 18.571 98 30 60 0 1882863760 4878240 9584240
20:16:29 9037 8192000000 10804598128 11235758080 1878369712 18.652 99 25 50 1 1891653632 6594192 6689728
20:16:44 8646 8192000000 10816899520 11246219264 1879220448 18.659 99 26 52 1 1891466912 4527536 7718928
20:17:00 11731 8192000000 10761262304 11183714304 1771800960 17.782 94 21 42 1 1784058480 5355824 6901696
20:17:19 6073 8192000000 10756503408 11188965376 1835471936 18.304 99 28 56 1 1849713392 6594976 7646480
20:17:31 7452 8192000000 10752033328 11181912064 1789047216 17.924 96 20 40 1 1800015872 5182416 5786240
20:17:45 7447 8192000000 10776477808 11190562816 1818258224 18.163 98 24 49 0 1830152352 5361776 6532352
20:18:00 5879 8192000000 10740940320 11165732864 1791518240 17.944 97 27 54 2 1805998352 5949312 8530800
20:18:14 4663 8192000000 10737036128 11154694144 1791578496 17.945 98 21 42 1 1803782992 6139456 6065040
20:18:28 8394 8192000000 10704320064 11109580800 1675371328 16.978 93 20 40 2 1685930384 4950752 5608304
20:18:43 8656 8192000000 10694401184 11108028416 1724940832 17.393 96 26 50 0 1737465904 5740464 6784608
20:18:59 6297 8192000000 10650690048 11061211136 1673650576 16.964 94 31 62 2 1688606016 5441008 9514432
20:19:13 14306 8192000000 10682406128 11096735744 1722792720 17.375 97 26 52 1 1736031600 5697504 7541376
20:19:36 7797 8192000000 10687957328 11101974528 1740071024 17.519 98 27 54 0 1758087072 10163600 7852448
20:19:53 47205 8192000000 10682747488 11096039424 1738798768 17.509 97 30 60 1 1753453600 5944384 8710448
20:21:06 19043 8192000000 10702393248 11117174784 1743520512 17.548 97 31 62 1 1758742256 6045232 9176512
20:21:32 8169 8192000000 10715905264 11127943168 1778594880 17.838 99 31 62 2 1792344576 5606656 8143040
20:21:49 9737 8192000000 10741611552 11159322624 1821871040 18.193 100 37 74 0 1839947568 6918608 11157920
20:22:05 6782 8192000000 10717461360 11140014080 1795088784 17.974 99 28 56 0 1810321360 6610416 8622160
20:22:20 5790 8192000000 10742640608 11162677248 1827121744 18.236 100 36 72 3 1848248544 11460064 9666736
20:22:33 13613 8192000000 10742951952 11155128320 1810027248 18.096 99 27 54 0 1823852208 6224112 7600848
20:22:53 8295 8192000000 10736601520 11167293440 1828591072 18.248 100 22 43 2 1840457328 5968656 5897600
20:23:10 8428 8192000000 10752041280 11176128512 1836172896 18.310 100 27 54 0 1850044672 5608000 8263776
20:23:26 6994 8192000000 10762055728 11182936064 1846053840 18.390 100 32 64 0 1861864368 6288928 9521600
20:23:43 7748 8192000000 10755560208 11180122112 1843537520 18.370 100 20 40 2 1855425520 6264496 5623504
20:23:57 5796 8192000000 10769841680 11191451648 1848065536 18.406 100 29 58 1 1866440784 9768160 8607088
20:24:10 18728 8192000000 10764926368 11194384384 1854597952 18.459 100 28 57 1 1867385456 5106096 7681408
20:24:35 14786 8192000000 10785380352 11204079616 1863299360 18.530 100 36 70 1 1879909456 5980400 10629696
20:25:08 54825 8192000000 10785957440 11214139392 1868480496 18.572 100 24 48 1 1881456160 6021632 6954032
20:26:10 8460 8192000000 10786951984 11217403904 1870700464 18.590 100 25 50 2 1887270112 9480976 7088672
20:26:25 10518 8192000000 10786342928 11214827520 1871202352 18.594 100 25 48 1 1883902352 6099792 6600208
20:26:42 7921 8192000000 10784634016 11215400960 1874296704 18.619 100 24 47 3 1887378352 5969024 7112624
20:27:00 5821 8192000000 10804143680 11224858624 1882215888 18.683 100 36 72 1 1898564944 6946912 9402144
20:27:13 2638 8192000000 10827973120 11246764032 1899909248 18.826 100 54 108 0 1923218304 7754512 15554544
20:27:34 10399 8192000000 10827365360 11252240384 1901772544 18.841 100 34 68 2 1922257120 11786736 8697840
20:27:56 8979 8192000000 10849782016 11268849664 1918931904 18.978 100 53 106 0 1942313984 8448256 14933824
20:28:12 6212 8192000000 10856313136 11274502144 1926264400 19.037 100 50 100 2 1948278016 8135760 13877856
20:28:27 4409 8192000000 10867084192 11284758528 1931364512 19.078 100 59 119 2 1956960704 8650400 16945792
20:28:46 10526 8192000000 10867213680 11293597696 1936580160 19.119 100 52 104 1 1960663200 9126048 14956992
20:29:04 13653 8192000000 10876090704 11301216256 1942166512 19.164 100 52 103 0 1968033968 9832112 16035344
20:29:33 32324 8192000000 10870300976 11299930112 1942796768 19.169 100 54 108 1 1967086320 9275040 15014512
20:30:16 18962 8192000000 10890877472 11313115136 1950485472 19.230 100 57 114 0 1978160528 11228112 16446944
20:30:53 10631 8192000000 10888900000 11317301248 1954656624 19.264 100 50 100 0 1979447696 10498704 14292368
20:31:13 27624 8192000000 10882026080 11310231552 1933707072 19.097 99 47 94 2 1957704576 10931296 13066208
20:31:48 12466 8192000000 10881601760 11315081216 1950657888 19.232 100 52 104 1 1979321136 13507328 15155920
20:32:15 17738 8192000000 10891862560 11325054976 1957013936 19.282 100 34 66 0 1975858144 9247536 9596672
20:32:40 7358 8192000000 10898860720 11319721984 1959069584 19.299 100 59 119 0 1984467952 9094384 16303984
20:33:01 12817 8192000000 10908554736 11332857856 1966145008 19.355 100 53 104 3 1991927984 10830256 14952720
20:33:23 25315 8192000000 10907529744 11335753728 1949734704 19.224 99 49 98 2 1978513792 14988688 13790400
20:34:01 10621 8192000000 10915210592 11337986048 1972926672 19.409 100 69 136 0 2004385632 11900080 19558880
20:34:27 9808 8192000000 10900616176 11340214272 1971588304 19.398 100 48 96 1 1997026240 11371680 14066256
20:34:49 4427 8192000000 10925960768 11352190976 1982496512 19.484 100 60 118 1 2010455968 10687136 17272320
20:35:03 7666 8192000000 10911254560 11337162752 1971225920 19.395 100 59 118 0 2001302576 12955296 17121360
20:35:20 3387 8192000000 10910636928 11339231232 1969970128 19.385 100 71 140 3 2003226432 13066176 20190128
20:35:34 25335 8192000000 10890962896 11322703872 1926809712 19.041 98 51 102 1 1954138320 12898304 14430304
20:36:14 10472 8192000000 10899055760 11335688192 1963501872 19.334 100 40 79 3 1989303744 13293648 12508224
20:36:33 28111 8192000000 10887645664 11340570624 1966699152 19.359 100 28 56 1 1987947104 12849760 8398192
20:37:09 5636 8192000000 10903773072 11344076800 1966660032 19.359 100 38 72 1 1994132576 16437984 11034560
20:37:26 18727 8192000000 10894563072 11334623232 1946995248 19.203 99 44 88 0 1973995712 13919152 13081312
20:37:51 5126 8192000000 10888267760 11321421824 1937503632 19.127 99 46 93 3 1964415456 13121808 13790016
20:38:06 2450 8192000000 10903373824 11326525440 1922438592 19.006 98 73 145 1 1958052512 14441536 21172384
20:38:15 7790 8192000000 10899166752 11331416064 1958211744 19.292 100 51 102 2 1988478544 15009472 15257328
20:38:31 6907 8192000000 10897238752 11330248704 1962873552 19.329 100 60 119 1 2000181856 19888896 17419408
20:39:04 2692 8192000000 10897181376 11322609664 1920700896 18.992 98 52 101 0 1953096416 17399376 14996144
20:39:26 8083 8192000000 10915269664 11342622720 1969382944 19.381 100 55 109 1 2002475456 17237104 15855408
20:39:42 4563 8192000000 10941352928 11365777408 1982731632 19.486 100 65 129 0 2026642000 25211888 18698480
20:39:54 1701 8192000000 10949552560 11358371840 1981802016 19.479 100 75 151 0 2026208144 21707296 22698832
20:40:03 6675 8192000000 10911284528 11333681152 1948358192 19.213 99 61 122 0 1989569616 23071872 18139552
20:40:19 3541 8192000000 10918852064 11339902976 1960666368 19.311 100 69 139 1 2004636096 22368992 21600736
20:40:32 4934 8192000000 10921073264 11339722752 1949054320 19.219 99 75 149 3 1995235584 23460528 22720736
20:40:44 2508 8192000000 10919025136 11334524928 1942466320 19.166 99 75 149 6 1990652800 25353776 22832704
20:40:54 3135 8192000000 10919013824 11334619136 1956159792 19.276 100 71 141 1 2003675168 26306352 21209024
20:41:06 5951 8192000000 10920055760 11335147520 1954948688 19.266 100 77 152 1 2006866784 28299360 23618736
20:41:19 3129 8192000000 10923972256 11337478144 1952708944 19.248 100 77 153 4 2005268592 28388416 24171232
20:41:32 3262 8192000000 10908916224 11326717952 1951186704 19.236 100 68 136 1 1996197440 23897792 21112944
20:41:44 11565 8192000000 10908641920 11332554752 1937212752 19.125 99 63 126 0 1980505328 23970288 19322288
20:42:10 8224 8192000000 10905203808 11328176128 1933871584 19.098 99 60 121 2 1978121872 25948896 18301392
20:42:25 3937 8192000000 10887169168 11305074688 1908400544 18.894 98 63 127 0 1958212016 30955792 18855680
20:42:37 3008 8192000000 10899888352 11320279040 1938616912 19.136 100 72 142 1 1986602432 26707104 21278416
20:42:54 11763 8192000000 10890805872 11318652928 1927480896 19.047 99 58 114 1 1971272320 26233296 17558128
20:43:26 24097 8192000000 10868948192 11292139520 1889824800 18.744 97 48 96 2 1933646512 28843584 14978128
20:44:07 16734 8192000000 10881227392 11305840640 1926728848 19.041 100 56 112 1 1973374752 29740736 16905168
20:44:39 7537 8192000000 10927407424 11338403840 1951305376 19.237 100 81 161 1 2009134704 33697760 24131568
20:44:55 9680 8192000000 10906403696 11326853120 1936668720 19.120 100 56 112 0 1985934208 32201104 17064384
20:45:15 7108 8192000000 10911883504 11331407872 1947197232 19.204 100 62 124 1 2000043248 34196224 18649792
20:45:31 6980 8192000000 10915686768 11340513280 1937326128 19.125 99 56 112 0 1991962368 36943904 17692336
20:45:46 1080 8192000000 10901219952 11317215232 1916680864 18.960 99 63 127 1 1974417904 37732272 20004768
20:45:55 2843 8192000000 10914763392 11321257984 1925274704 19.029 100 68 133 0 1986631104 39829792 21526608
20:46:07 3622 8192000000 10911851280 11327172608 1929431632 19.062 100 65 130 0 1990283520 39735408 21116480
20:46:21 2284 8192000000 10916872560 11332022272 1938002672 19.131 100 72 143 0 1997638400 37478192 22157536
20:46:33 3658 8192000000 10897527072 11302715392 1880995856 18.673 97 73 145 1 1941227392 37831504 22400032
20:46:46 4276 8192000000 10880003936 11294916608 1903843888 18.857 99 68 136 0 1964600096 39699936 21056272
20:47:01 2687 8192000000 10885070128 11295531008 1902990832 18.850 99 64 125 2 1962871456 39725504 20155120
20:47:10 2048 8192000000 10883094128 11285872640 1888295728 18.732 99 74 146 1 1950166544 39272576 22598240
20:47:19 3251 8192000000 10885830544 11294121984 1901574832 18.839 100 73 145 1 1969659488 45782016 22302640
20:47:29 1734 8192000000 10899462224 11308208128 1917967872 18.971 100 76 151 3 1984125328 42382640 23774816
20:47:40 4720 8192000000 10909213840 11322839040 1929633376 19.064 100 63 125 1 1991498016 41863216 20001424
20:47:52 5654 8192000000 10904469008 11321786368 1925820512 19.033 100 64 128 0 1989480320 43468944 20190864
20:48:06 7629 8192000000 10890105200 11303780352 1904735680 18.864 99 56 112 1 1962434144 40295696 17402768
20:48:22 5812 8192000000 10906054912 11320041472 1927228704 19.045 100 64 125 1 1988996176 42090448 19677024
20:48:34 3200 8192000000 10927148272 11334467584 1936023232 19.115 100 78 154 3 2005283968 44075488 25185248
20:48:47 14355 8192000000 10896724624 11333390336 1931923984 19.082 100 46 92 0 1993703856 46533248 15246624
20:49:12 7253 8192000000 10918454880 11341119488 1942511744 19.167 100 51 99 0 2002105328 43836128 15757456
20:49:27 3396 8192000000 10929186960 11347152896 1952045936 19.243 100 65 129 1 2012059392 39349552 20663904
20:49:37 1397 8192000000 10939325808 11341402112 1948605120 19.215 100 81 162 2 2015426416 41228320 25592976
20:49:47 2870 8192000000 10943947280 11354370048 1956488192 19.278 100 80 160 2 2025152672 45087424 23577056
20:50:00 5776 8192000000 10932535968 11357380608 1958811040 19.297 100 57 114 1 2022311488 45149600 18350848
20:50:14 5274 8192000000 10945494560 11368366080 1962738576 19.328 100 51 101 1 2025153040 45925888 16488576
20:50:26 5225 8192000000 10950484768 11377283072 1971650848 19.399 100 60 119 1 2038254112 47747536 18855728
20:50:46 11043 8192000000 10952262160 11372822528 1964841360 19.345 100 47 93 0 2024996384 44369856 15785168
20:51:07 10306 8192000000 10952637552 11373375488 1970928752 19.393 100 61 122 1 2036500064 45525872 20045440
20:51:25 12117 8192000000 10955478032 11385462784 1974481984 19.421 100 46 91 2 2038066432 49118912 14465536
20:51:44 15212 8192000000 10964491728 11402403840 1984227984 19.498 100 47 94 1 2049292368 49476064 15588320
20:52:07 10920 8192000000 10971323408 11406602240 1989864192 19.543 100 45 90 0 2056039648 51086192 15089264
20:52:31 10741 8192000000 10981413840 11406528512 1993892384 19.575 100 49 99 2 2061842224 51586112 16363728
20:52:49 7071 8192000000 10985300864 11410837504 1997396880 19.602 100 66 132 1 2071179632 52631312 21151440
20:53:07 10584 8192000000 10966579200 11411783680 1994728560 19.581 100 46 90 0 2057482512 47664640 15089312
20:53:25 7064 8192000000 10970665232 11407560704 1993784560 19.574 100 44 88 0 2055468064 46574016 15109488
20:53:45 8162 8192000000 10984569312 11413561344 1998014384 19.607 100 48 95 1 2062851520 49349264 15487872
20:54:01 2458 8192000000 10988282864 11414581248 1995949216 19.591 100 63 123 1 2066459824 51090608 19420000
20:54:10 10722 8192000000 10977280592 11419205632 1994425408 19.579 100 40 80 1 2061025264 52922048 13677808
20:54:29 13111 8192000000 10975158560 11419717632 2001073024 19.631 100 40 80 1 2058090768 44118048 12899696
20:54:49 15450 8192000000 10979620848 11412951040 1988074896 19.529 99 48 94 2 2047491792 44375952 15040944
20:55:12 9736 8192000000 10979325392 11417088000 2000843904 19.629 100 44 89 0 2062013456 46624720 14544832
20:55:30 10461 8192000000 10982127376 11419054080 2002433952 19.642 100 46 92 2 2068446912 50444992 15567968
20:55:56 14108 8192000000 10980106848 11421839360 1987173632 19.521 100 35 70 2 2058748608 58486080 13088896
20:56:35 15898 8192000000 10960291488 11421249536 1972815168 19.408 100 28 56 2 2044034672 60581952 10637552
20:57:14 17712 8192000000 10976795456 11429838848 1987551072 19.524 100 25 50 0 2058126080 61569888 9005120
20:57:57 13069 8192000000 10948629744 11418255360 1965096864 19.347 99 27 54 0 2024364624 50353728 8914032
20:58:17 14269 8192000000 10945267024 11401162752 1973733664 19.415 100 19 38 0 2032152304 51684160 6734480
20:58:38 15851 8192000000 10940353040 11394224128 1947026368 19.203 99 17 34 0 2007506272 54289568 6190336
20:59:01 14974 8192000000 10944497968 11411873792 1963011264 19.330 100 16 32 0 2023787680 55246848 5529568
20:59:23 16461 8192000000 10942131376 11416702976 1965976016 19.354 100 12 24 0 2026297200 55965184 4356000
20:59:50 5668 8192000000 10950864944 11414650880 1975912400 19.432 100 19 33 1 2028770448 47438096 5419952
21:00:02 23381 8192000000 10922195680 11381334016 1957340512 19.285 99 19 38 0 1993161088 30206112 5614464
21:00:45 72685 8192000000 10920081808 11374141440 1957952560 19.290 99 23 44 2 1972414448 8681184 5780704
21:02:13 86238 8192000000 10902953648 11363708928 1946774752 19.201 98 38 76 1 1969177424 11846880 10555792
21:03:58 47873 8192000000 10904820896 11369295872 1943676016 19.176 98 10 20 0 1956855056 10229232 2949808
21:04:56 29174 8192000000 10905087824 11362844672 1961077248 19.315 99 10 20 1 1975120896 9851024 4192624
21:05:32 60810 8192000000 10892382288 11354370048 1938769728 19.137 98 14 28 0 1952378240 9889776 3718736
21:06:47 37908 8192000000 10898948448 11360137216 1950771024 19.233 99 16 32 3 1965305648 10005232 4529392
21:07:36 33070 8192000000 10919359152 11367772160 1965815920 19.352 99 41 82 3 1990086320 12347936 11922464
21:08:33 81436 8192000000 10927547680 11387424768 1984715616 19.502 100 23 46 2 2008898944 17140176 7043152
21:10:08 66375 8192000000 10928767904 11405975552 1991627488 19.557 100 20 40 1 2022409504 24504256 6277760
21:11:21 110470 8192000000 10929919568 11400916992 1956642944 19.279 98 9 18 0 1974736896 15760032 2333920
21:13:18 90448 8192000000 10959460336 11386834944 1969796704 19.384 99 27 53 0 1992112000 14562080 7753216
21:15:00 56456 8192000000 10919238448 11393499136 1991723600 19.557 100 10 20 1 2004580224 9985152 2871472
21:16:04 37265 8192000000 10927877824 11372965888 1903321280 18.853 95 31 62 0 1919846128 7397728 9127120
21:16:48 36200 8192000000 10923369248 11378774016 1980057456 19.465 100 33 65 2 2000371648 11408864 8905328
21:17:35 53233 8192000000 10930460800 11397713920 1976511856 19.437 99 12 24 1 1996743072 16787312 3443904
21:18:44 99084 8192000000 10912443280 11367530496 1894104592 18.779 95 10 20 0 1911567760 14294720 3168448
21:20:30 145694 8192000000 10908290080 11364323328 1945377072 19.190 98 40 79 2 1968952112 12163376 11411664
21:23:03 43586 8192000000 10922870224 11355340800 1936867968 19.122 98 49 90 2 1958564800 9057888 12638944
21:23:55 23238 8192000000 10917187856 11358654464 1931455200 19.079 98 47 89 2 1952472816 9173408 11844208
21:24:28 75544 8192000000 10848622064 11302264832 1910757744 18.913 97 28 56 0 1925641024 7447888 7435392
21:25:53 14099 8192000000 10919694304 11355934720 1956488960 19.278 99 71 143 4 1987048736 9093472 21466304
21:26:13 16605 8192000000 10902329520 11366993920 1970888480 19.392 100 38 76 1 1991022208 9683296 10450432
21:26:36 27874 8192000000 10887460544 11355951104 1953771584 19.257 99 16 32 0 1967958416 9840672 4346160
21:27:14 5652 8192000000 10928410336 11374755840 1986211168 19.514 100 56 112 0 2013807952 10300896 17295888
21:27:26 29759 8192000000 10907137360 11362308096 1930031232 19.067 97 56 108 2 1958314656 11540928 16742496
21:28:02 19573 8192000000 10919597456 11359723520 1951496496 19.238 99 57 104 4 1981261712 15037936 14727280
21:28:28 99553 8192000000 10866351168 11338674176 1794391024 17.968 92 10 20 0 1810931328 14389680 2150624
21:30:50 155056 8192000000 10844936480 11310497792 1780507328 17.854 91 12 24 0 1796547184 12971472 3068384
21:33:31 52754 8192000000 10888711632 11341189120 1940543552 19.151 100 28 55 2 1965593952 17189392 7861008
21:34:31 29599 8192000000 10872194880 11340423168 1906935904 18.882 98 20 40 0 1934488176 21320624 6231648
21:35:07 67453 8192000000 10863244448 11330613248 1884845552 18.704 97 16 33 0 1904935392 15554096 4535744
21:36:24 44046 8192000000 10864776160 11335073792 1938540752 19.135 100 11 22 1 1951812288 10315840 2955696
21:37:18 25223 8192000000 10887749392 11330002944 1901576864 18.839 97 30 60 3 1916801200 7153152 8071184
21:37:53 35113 8192000000 10862711008 11314651136 1887769936 18.728 97 27 54 1 1905422960 10288656 7364368
21:38:34 47199 8192000000 10861844544 11313520640 1882056800 18.682 97 21 42 0 1899380048 12053024 5270224
21:39:28 41433 8192000000 10848536496 11296796672 1863337216 18.530 97 36 70 3 1881388416 8181840 9869360
21:40:21 58585 8192000000 10860302944 11328217088 1911620384 18.920 99 22 44 2 1930509024 12515744 6372896
21:41:26 68383 8192000000 10848834448 11321303040 1888959056 18.737 98 7 14 0 1903182352 12042528 2180768
21:42:48 31967 8192000000 10882764704 11335372800 1926252448 19.037 99 41 82 3 1947533088 9789328 11491312
21:43:28 49919 8192000000 10880216096 11351851008 1946361840 19.197 100 26 52 2 1969904944 16061664 7481440
21:44:29 31782 8192000000 10898234592 11340984320 1918486432 18.975 98 29 58 1 1934340512 7278144 8575936
21:45:11 26852 8192000000 10882969856 11337879552 1878822736 18.656 96 35 71 0 1901647984 13221792 9603456
21:45:51 50102 8192000000 10880337440 11339694080 1886461664 18.717 97 17 34 0 1905430112 13767568 5200880
21:46:52 108684 8192000000 10883797728 11350884352 1958703680 19.296 100 45 90 1 1980620848 8846576 13070592
21:48:47 72695 8192000000 10889261840 11357876224 1963736368 19.336 100 26 52 3 1981184880 9688624 7759888
21:50:08 31262 8192000000 10891170064 11366973440 1965605552 19.351 100 15 30 0 1977762336 8296272 3860512
21:50:51 86179 8192000000 10894129296 11372552192 1958681200 19.296 99 15 30 2 1980242352 17448448 4112704
21:52:32 46023 8192000000 10890046864 11370078208 1970860832 19.392 100 7 15 0 1982185888 9302592 2022464
21:53:48 61416 8192000000 10895756944 11380072448 1981719312 19.478 100 11 22 0 1992758576 7805072 3234192
21:55:21 70839 8192000000 10906652288 11375181824 1964288784 19.340 99 16 32 0 1975660240 7280752 4090704
21:56:42 47696 8192000000 10901590848 11374993408 1950792944 19.233 98 16 31 1 1965083888 9709232 4581712
21:57:36 40121 8192000000 10944594480 11397722112 1953563168 19.255 98 34 66 0 1975803184 12787184 9452832
21:58:24 84807 8192000000 10928722016 11415023616 1982589744 19.485 99 18 36 2 2004315488 16461632 5264112
21:59:55 102994 8192000000 10918963392 11396263936 1965995888 19.354 98 18 36 0 1983587200 12367472 5223840
22:01:48 65320 8192000000 10917051408 11386253312 1943682528 19.176 97 23 46 1 1966514096 15646976 7184592
22:03:00 61823 8192000000 10922393440 11401256960 1958010304 19.290 98 16 32 1 1974883328 12552208 4320816
22:04:10 78560 8192000000 10913975200 11399094272 1916364944 18.958 96 10 20 0 1937908480 19006416 2537120
22:07:22 108260 8192000000 10901352448 11385552896 1860699008 18.509 93 24 48 1 1883993808 16984464 6310336
22:09:17 60391 8192000000 10896664176 11346558976 1886393216 18.717 95 10 20 0 1899662960 10599072 2670672
22:10:26 124833 8192000000 10887003328 11350474752 1921437120 18.998 98 29 56 3 1939474240 9956080 8081040
22:12:40 65664 8192000000 10872569056 11346841600 1923766400 19.017 98 13 26 0 1941531264 14520048 3244816
22:13:58 40497 8192000000 10885192160 11346624512 1926823024 19.041 98 24 48 3 1944839200 11534176 6482000
22:14:45 41196 8192000000 10874167680 11346739200 1935119664 19.108 99 14 27 1 1945835600 6858672 3857264
22:15:32 58028 8192000000 10871050016 11346518016 1947886928 19.210 99 12 24 2 1960057312 9239312 2931072
22:17:22 60898 8192000000 10906307024 11376095232 1954350608 19.261 99 17 35 1 1971008960 11053744 5604608
22:18:47 81230 8192000000 10906212000 11376230400 1973171328 19.411 100 12 24 1 1991422960 14297952 3953680
22:20:44 64722 8192000000 10887394720 11356319744 1940357568 19.150 98 15 30 0 1954205376 9974976 3872832
22:22:00 41602 8192000000 10828172272 11299016704 1816550512 18.149 92 19 38 1 1828194256 6510560 5133184
22:22:48 64650 8192000000 10832507264 11312041984 1922236928 19.005 100 14 28 0 1934943808 8957200 3749680
22:24:48 85710 8192000000 10866996720 11341709312 1872827584 18.607 96 10 20 0 1890465072 15145776 2491712
22:26:20 48626 8192000000 9010560288 9212579840 183810464 2.194 10 2 2 1 185182992 847680 524848

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 29-11-2020 22:28:35 to 29-11-2020 22:29:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 134 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-11-2020 22:29:09 to 29-11-2020 22:29:11.

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          242235
MON$OLDEST_ACTIVE               242236
MON$OLDEST_SNAPSHOT             242236
MON$NEXT_TRANSACTION            242236
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                       2044768
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:110: 
:111: mscs-test-161.budzdorov.ru    Sun Nov 29 22:27:11 2020
:112:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:113: 
--- end of diff output ---

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

29.11.20 22:29:12. 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-29 22:29:14 No severe PSQL-related problems occured
29.11.20 22:29:15. End of report.