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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-25 01:27:13
DTS_END                         2021-01-25 01:27:13.5600
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/42282
TRN_ID                          242525
ATT_ID                          710
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: 9035.92 20436 1084310
customer order: creation 174.65 360 20958
customer order: refuse 14.72 308 1766
order to supplier: creation 46.56 1302 5587
order to supplier: removal 3.31 95714 397
invoice (draft): creation 46.64 3432 5597
invoice (draft): removal 49.73 756 5967
invoice accept: apply 42.69 18605 5123
invoice accept: cancel 45.32 809 5438
customer reserve: creation 3890.38 188 466845
customer reserve: removal 4423.98 56 530878
realization accept: apply 85.74 162 10289
realization accept: cancel 80.30 111 9636
payment from customer: creation 60.61 114 7273
payment from customer: removal 5.58 65 670
payment to supplier: creation 49.75 125 5970
payment to supplier: removal 3.59 45 431
service: total inventory turnovers 4.93 861 592
service: total monetary turnovers 6.52 29 782
service: aggregate perf. data 0.89 19220 107
service: refresh index statistics 0.03 266449 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-01-2021 01:28:54 to 25-01-2021 01:28:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6008
TEST_TIME 2 5780
TEST_TIME 3 7003
TEST_TIME 4 6252
TEST_TIME 5 5721
TEST_TIME 6 5744
TEST_TIME 7 5803
TEST_TIME 8 6276
TEST_TIME 9 6396
TEST_TIME 10 6105
TEST_TIME 11 5937
TEST_TIME 12 6254
TEST_TIME 13 6168
TEST_TIME 14 6465
TEST_TIME 15 6484
TEST_TIME 16 6608
TEST_TIME 17 6597
TEST_TIME 18 6840
TEST_TIME 19 6925
TEST_TIME 20 7016
TEST_TIME 21 8318
TEST_TIME 22 8428
TEST_TIME 23 8392
TEST_TIME 24 8652
TEST_TIME 25 8645
TEST_TIME 26 8966
TEST_TIME 27 9254
TEST_TIME 28 9550
TEST_TIME 29 9664
TEST_TIME 30 9989
TEST_TIME 31 10359
TEST_TIME 32 10439
TEST_TIME 33 10174
TEST_TIME 34 10015
TEST_TIME 35 9892
TEST_TIME 36 10065
TEST_TIME 37 9958
TEST_TIME 38 9816
TEST_TIME 39 9884
TEST_TIME 40 9757
TEST_TIME 41 9920
TEST_TIME 42 9847
TEST_TIME 43 9740
TEST_TIME 44 9612
TEST_TIME 45 9535
TEST_TIME 46 9597
TEST_TIME 47 9412
TEST_TIME 48 9450
TEST_TIME 49 9352
TEST_TIME 50 9246
TEST_TIME 51 9246
TEST_TIME 52 9275
TEST_TIME 53 9324
TEST_TIME 54 9367
TEST_TIME 55 9371
TEST_TIME 56 9380
TEST_TIME 57 9398
TEST_TIME 58 9367
TEST_TIME 59 9467
TEST_TIME 60 9396
TEST_TIME 61 9474
TEST_TIME 62 9572
TEST_TIME 63 9572
TEST_TIME 64 9648
TEST_TIME 65 9675
TEST_TIME 66 9756
TEST_TIME 67 9625
TEST_TIME 68 9526
TEST_TIME 69 9464
TEST_TIME 70 9539
TEST_TIME 71 9513
TEST_TIME 72 9475
TEST_TIME 73 9474
TEST_TIME 74 9421
TEST_TIME 75 9364
TEST_TIME 76 9372
TEST_TIME 77 9300
TEST_TIME 78 9337
TEST_TIME 79 9348
TEST_TIME 80 9356
TEST_TIME 81 9342
TEST_TIME 82 9406
TEST_TIME 83 9388
TEST_TIME 84 9391
TEST_TIME 85 9359
TEST_TIME 86 9439
TEST_TIME 87 9476
TEST_TIME 88 9486
TEST_TIME 89 9497
TEST_TIME 90 9398
TEST_TIME 91 9359
TEST_TIME 92 9323
TEST_TIME 93 9328
TEST_TIME 94 9272
TEST_TIME 95 9228
TEST_TIME 96 9199
TEST_TIME 97 9249
TEST_TIME 98 9278
TEST_TIME 99 9239
TEST_TIME 100 9205
TEST_TIME 101 9284
TEST_TIME 102 9242
TEST_TIME 103 9251
TEST_TIME 104 9291
TEST_TIME 105 9293
TEST_TIME 106 9328
TEST_TIME 107 9323
TEST_TIME 108 9331
TEST_TIME 109 9313
TEST_TIME 110 9288
TEST_TIME 111 9216
TEST_TIME 112 9220
TEST_TIME 113 9216
TEST_TIME 114 9186
TEST_TIME 115 9175
TEST_TIME 116 9145
TEST_TIME 117 9110
TEST_TIME 118 9080
TEST_TIME 119 9109
TEST_TIME 120 9040

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-01-2021 01:28:58 to 25-01-2021 01:29:01.

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 1516783 1516783 0 0.00 0 26428 7 0 0
doc_list_biud 1516782 1516782 0 0.00 0 32283 25 0 0
sp_add_invoice_to_stock 5286 5123 163 3.08 32 200134 18606 0 163
sp_cancel_adding_invoice 5438 5438 0 0.00 4 39560 810 0 0
sp_cancel_client_order 1766 1766 0 0.00 4 8726 309 0 0
sp_cancel_customer_reserve 530878 530878 0 0.00 1 26393 56 0 0
sp_cancel_pay_from_customer 670 670 0 0.00 3 2889 66 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 2 828 45 0 0
sp_cancel_supplier_invoice 5982 5967 15 0.25 1 16441 757 0 15
sp_cancel_supplier_order 397 397 0 0.00 7 978556 95714 0 0
sp_cancel_write_off 9636 9636 0 0.00 1 21809 111 0 0
sp_client_order 20958 20958 0 0.00 3 30332 360 0 0
sp_customer_reserve 466845 466845 0 0.00 0 87658 188 0 0
sp_fill_shopping_cart 32133 32133 0 0.00 1 16381 36 0 0
sp_fill_shopping_cart_clo_res 466836 466836 0 0.00 0 15087 14 0 0
sp_get_clo_for_invoice 5114 5114 0 0.00 0 27656 306 0 0
sp_kill_cost_storno 16175 16175 0 0.00 0 11635 57 0 0
sp_kill_qstorno_ret_qs2qd 1077756 1077756 0 0.00 0 32280 31 0 0
sp_kill_qty_storno 569485 569485 0 0.00 0 32282 67 0 0
sp_lock_selected_doc 21180 21180 0 0.00 0 5419 4 0 0
sp_make_cost_storno 28646 28646 0 0.00 0 15109 53 0 0
sp_multiply_rows_for_pdistr 28646 28646 0 0.00 0 11659 27 0 0
sp_multiply_rows_for_qdistr 20958 20958 0 0.00 0 11338 161 0 0
sp_pay_from_customer 7273 7273 0 0.00 4 18939 114 0 0
sp_pay_to_supplier 5970 5970 0 0.00 5 13824 125 0 0
sp_payment_common 13243 13243 0 0.00 2 18933 35 0 0
sp_qd_handle_on_cancel_clo 1766 1766 0 0.00 0 6869 286 0 0
sp_qd_handle_on_invoice_upd_sts 10552 10552 0 0.00 0 26030 328 0 0
sp_qd_handle_on_reserve_upd_sts 10289 10289 0 0.00 0 27269 59 0 0
sp_reserve_write_off 10289 10289 0 0.00 6 27296 162 0 0
sp_supplier_invoice 5597 5597 0 0.00 6 71982 3433 0 0
sp_supplier_order 5587 5587 0 0.00 4 34054 1302 0 0
srv_aggregate_perf_data 107 107 0 0.00 2799 320782 19220 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1981 140419 33927 0 0
srv_find_qd_qs_mism 1035969 1035969 0 0.00 0 26427 6 0 0
srv_make_invnt_saldo 592 592 0 0.00 39 21637 862 0 0
srv_make_money_saldo 782 782 0 0.00 1 4081 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 175003 451235 266450 0 0
t$perf-abend:sp_add_invoice_to_stock 163 163 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5123 5123 0 0.00 0 12873 162 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 0 4784 110 0 0
t$perf-norm:sp_cancel_client_order 1766 1766 0 0.00 0 1843 10 0 0
t$perf-norm:sp_cancel_customer_reserve 682 682 0 0.00 0 331 4 0 0
t$perf-norm:sp_cancel_pay_from_customer 670 670 0 0.00 0 2229 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 11948 44 0 0
t$perf-norm:sp_cancel_supplier_invoice 412 412 0 0.00 0 1399 22 0 0
t$perf-norm:sp_cancel_supplier_order 397 397 0 0.00 0 40027 1604 0 0
t$perf-norm:sp_cancel_write_off 988 988 0 0.00 0 13025 28 0 0
t$perf-norm:sp_client_order 20958 20958 0 0.00 0 5376 15 0 0
t$perf-norm:sp_customer_reserve 1068 1068 0 0.00 0 404 3 0 0
t$perf-norm:sp_pay_from_customer 7273 7273 0 0.00 0 5146 8 0 0
t$perf-norm:sp_pay_to_supplier 5970 5970 0 0.00 0 5561 7 0 0
t$perf-norm:sp_reserve_write_off 10289 10289 0 0.00 0 5593 10 0 0
t$perf-norm:sp_supplier_invoice 5597 5597 0 0.00 0 9513 18 0 0
t$perf-norm:sp_supplier_order 5587 5587 0 0.00 0 9638 17 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 569 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 253 2 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 863 18 0 0
t$perf-norm:srv_make_money_saldo 782 782 0 0.00 0 1058 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 10552 10226 326 3.08 0 8401 18 0 326
v_all_customers 38302 38302 0 0.00 0 16 0 0 0
v_all_suppliers 30900 30900 0 0.00 0 13 1 0 0
v_all_wares 41916 41916 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 1102 7 0 0
v_cancel_client_order 3532 3532 0 0.00 0 8406 5 0 0
v_cancel_customer_prepayment 1340 1340 0 0.00 0 959 4 0 0
v_cancel_customer_reserve 1364 1364 0 0.00 0 8418 11 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 477 4 0 0
v_cancel_supplier_invoice 854 824 30 3.51 0 8332 25 0 30
v_cancel_supplier_order 794 794 0 0.00 0 1373 5 0 0
v_cancel_write_off 1976 1976 0 0.00 0 2643 12 0 0
v_max_id_clo_ord 5587 5587 0 0.00 0 2439 2 0 0
v_max_id_clo_res 1068 1068 0 0.00 0 3711 16 0 0
v_max_id_ord_sup 5588 5588 0 0.00 0 8690 5 0 0
v_max_non_paid_invoice 1695 1695 0 0.00 0 2506 5 0 0
v_max_non_paid_realizn 3886 3886 0 0.00 0 2870 4 0 0
v_min_id_clo_ord 5587 5587 0 0.00 0 4163 7 0 0
v_min_id_clo_res 1068 1068 0 0.00 0 6407 17 0 0
v_min_id_ord_sup 5588 5588 0 0.00 0 4353 5 0 0
v_min_non_paid_invoice 5970 5970 0 0.00 0 11661 23 0 0
v_min_non_paid_realizn 7273 7273 0 0.00 0 11971 22 0 0
v_our_firm 10388 10388 0 0.00 0 10 1 0 0
v_reserve_write_off 20578 20578 0 0.00 0 8483 5 0 0
x_lock_depdocs_on_canc_invoice 10993 10993 0 0.00 0 18270 105 0 0
x_lock_depdocs_on_canc_sup_ord 397 397 0 0.00 0 12606 371 0 0
x_make_qstorno_1000_1200 5587 5587 0 0.00 1 34033 1226 0 0
x_make_qstorno_1200_2000 5597 5597 0 0.00 3 71976 3304 0 0
x_make_qstorno_2100_3300 466845 466845 0 0.00 0 87654 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-01-2021 01:29:02 to 25-01-2021 01:29:06.

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:17 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:23 19015 8192000000 10260245328 10570772480 873619264 9.636 67 59 118 0 895494256 2424816 19450176
22:57:50 18488 8192000000 10342648448 10659811328 1397634912 14.574 100 86 172 1 1429747680 4784032 27328736
22:58:21 18794 8192000000 10384816144 10709725184 1443558240 14.981 100 88 176 0 1477937040 6177728 28201072
22:58:49 28409 8192000000 10408128080 10736410624 1467846336 15.195 100 95 189 2 1506508992 7209136 31453520
22:59:26 14959 8192000000 10441065152 10770010112 1488542800 15.376 100 90 180 1 1526274912 8262976 29469136
22:59:56 30567 8192000000 10454428432 10789269504 1508620048 15.551 100 90 180 0 1545849520 8554592 28674880
23:00:37 14708 8192000000 10467712784 10805686272 1522198768 15.669 100 86 172 0 1559035392 9472512 27364112
23:01:04 23578 8192000000 10494655264 10837782528 1544531600 15.863 100 84 168 0 1580506384 9787808 26186976
23:01:47 16990 8192000000 10524595648 10873753600 1577126544 16.143 100 80 160 1 1612547728 10658128 24763056
23:02:14 13055 8192000000 10546608128 10902646784 1607928912 16.407 100 75 150 0 1641029456 10936864 22163680
23:02:35 14596 8192000000 10575151152 10931908608 1633623584 16.626 100 80 160 1 1669177328 11338192 24215552
23:03:00 14142 8192000000 10595883648 10958499840 1652554688 16.786 100 75 150 0 1686136288 11696672 21884928
23:03:23 11273 8192000000 10603941984 10969513984 1669099376 16.926 100 80 160 2 1704294816 12005408 23190032
23:03:42 13011 8192000000 10627833136 10994003968 1690732096 17.107 100 72 144 0 1722472512 11148128 20592288
23:04:03 8179 8192000000 10648465584 11018084352 1711242128 17.279 100 86 172 0 1747989792 11662816 25084848
23:04:20 10477 8192000000 10655772016 11031691264 1720440736 17.356 100 71 142 1 1752577760 11900944 20236080
23:04:39 5552 8192000000 10673151840 11048292352 1737800368 17.500 100 82 165 2 1774246384 12681280 23764736
23:04:52 5752 8192000000 10673216352 11056263168 1746074048 17.569 100 72 144 0 1778543440 12471456 19997936
23:05:06 5905 8192000000 10711774864 11086843904 1762784672 17.707 100 75 146 3 1795117104 11729232 20603200
23:05:20 6193 8192000000 10712933136 11091030016 1775856704 17.815 100 79 158 3 1810371120 12931712 21582704
23:05:33 4162 8192000000 10718799312 11098972160 1785682048 17.896 100 81 162 0 1822542400 14494848 22365504
23:05:44 3987 8192000000 10737353136 11114909696 1796860560 17.988 100 89 178 1 1835865728 14024960 24980208
23:05:55 10964 8192000000 10735408928 11122683904 1798387744 18.001 100 73 146 1 1832338656 13543792 20407120
23:06:13 3336 8192000000 10752455632 11132862464 1807148064 18.073 100 72 144 0 1841379200 13410944 20820192
23:06:22 2860 8192000000 10757420768 11147431936 1820931184 18.185 100 74 147 3 1854164880 12834288 20399408
23:06:32 3116 8192000000 10759407376 11151118336 1827812016 18.241 100 82 165 1 1863594944 12534032 23248896
23:06:42 3608 8192000000 10769131072 11156590592 1831963584 18.275 100 84 167 2 1869638560 13644048 24030928
23:06:52 2790 8192000000 10777766896 11160858624 1834486704 18.296 100 88 178 1 1873185904 13613664 25085536
23:07:01 2530 8192000000 10777686736 11163377664 1839309248 18.335 100 90 180 3 1878359072 14456064 24593760
23:07:11 2965 8192000000 10785760224 11170316288 1840612880 18.346 100 85 169 2 1877435056 13999952 22822224
23:07:21 2256 8192000000 10788963344 11173986304 1844859008 18.380 100 89 178 0 1884309072 13753376 25696688
23:07:30 2471 8192000000 10790715712 11176570880 1848362736 18.409 100 83 167 1 1886137472 14246864 23527872
23:07:39 1599 8192000000 10797111920 11183751168 1852876384 18.445 100 93 186 1 1893170176 14048960 26244832
23:07:47 2248 8192000000 10806749664 11195510784 1862129648 18.521 100 97 194 3 1902977984 13904784 26943552
23:07:56 1407 8192000000 10809871584 11195645952 1861229616 18.513 100 93 187 0 1900897856 12892960 26775280
23:08:04 2146 8192000000 10805017120 11194044416 1864446976 18.539 100 85 170 0 1901468256 13351712 23669568
23:08:13 1360 8192000000 10814779248 11200974848 1869799072 18.583 100 94 188 1 1910031712 13816608 26416032
23:08:22 1355 8192000000 10818428416 11204317184 1869304528 18.579 100 92 184 1 1908052176 12574016 26173632
23:08:30 2369 8192000000 10813236112 11207520256 1873063392 18.609 100 87 176 2 1911028848 13308640 24656816
23:08:40 25158 8192000000 10793006848 11205136384 1868609072 18.573 100 52 103 1 1891993744 8808352 14576320
23:09:20 10158 8192000000 10803819280 11207913472 1872660000 18.606 100 72 144 2 1902881936 9070432 21151504
23:09:36 1637 8192000000 10818040976 11213594624 1877889584 18.648 100 79 156 2 1911914496 11722416 22302496
23:09:45 1075 8192000000 10826523600 11220873216 1885843248 18.712 100 96 196 0 1926010800 13307360 26860192
23:09:52 4417 8192000000 10805335520 11223097344 1877396560 18.644 100 57 114 1 1909999504 17324592 15278352
23:10:04 3917 8192000000 10799011184 11209125888 1876221184 18.635 100 40 79 0 1894818240 7478768 11118288
23:10:14 5515 8192000000 10792115984 11213590528 1877988144 18.649 100 46 92 0 1900559728 8760432 13811152
23:10:26 4721 8192000000 10793322784 11212075008 1878839248 18.656 100 40 80 0 1898759520 7893456 12026816
23:10:38 3808 8192000000 10804086048 11221934080 1884632352 18.702 100 59 117 1 1910493664 9019968 16841344
23:10:48 14984 8192000000 10790164656 11222126592 1880166080 18.666 100 21 42 3 1895767520 9813568 5787872
23:11:10 8509 8192000000 10789094896 11222777856 1883898128 18.697 100 25 50 1 1897106992 6674592 6534272
23:11:25 8104 8192000000 10799582944 11227959296 1889326448 18.740 100 30 60 3 1905521312 7159680 9035184
23:11:43 11921 8192000000 10789495968 11227463680 1887625488 18.727 100 13 26 2 1896828160 5382880 3819792
23:12:03 11640 8192000000 10801824064 11232620544 1893407872 18.773 100 21 40 0 1906685984 6401360 6876752
23:12:20 8303 8192000000 10823746352 11235237888 1894918672 18.785 100 24 47 3 1907417344 5568800 6929872
23:12:36 13583 8192000000 10814724480 11241959424 1900070576 18.827 100 25 51 0 1913163728 6251664 6841488
23:12:56 10237 8192000000 10812902688 11246518272 1901957088 18.842 100 25 49 1 1915876656 7163920 6755648
23:13:18 7606 8192000000 10838534464 11255177216 1913190512 18.932 100 40 79 3 1931021344 5676000 12154832
23:13:31 68183 8192000000 10828394304 11261251584 1909824688 18.905 100 31 61 1 1925128288 6442336 8861264
23:14:47 9975 8192000000 10849035200 11268395008 1910888912 18.914 100 28 57 1 1925064752 6307632 7868208
23:15:04 4904 8192000000 10831629152 11267305472 1914626224 18.944 100 34 68 0 1932030032 7425456 9978352
23:15:19 6075 8192000000 10837865632 11269120000 1917281824 18.965 100 41 83 2 1935695168 7619600 10793744
23:15:33 2792 8192000000 10834791296 11262136320 1901202208 18.836 99 41 83 0 1920474288 7700128 11571952
23:15:42 5314 8192000000 10827811728 11264839680 1914172112 18.940 100 37 74 2 1932944672 8598064 10174496
23:15:55 7712 8192000000 10835437488 11270209536 1918258496 18.973 100 24 48 1 1931038368 6248992 6530880
23:16:13 4561 8192000000 10860146192 11287494656 1923565136 19.015 100 34 68 1 1947561472 14755600 9240736
23:16:26 9765 8192000000 10833606416 11264020480 1913358048 18.934 100 26 50 0 1926689840 6178416 7153376
23:16:47 9192 8192000000 10819127920 11250794496 1874788672 18.623 98 20 40 0 1887401264 6059776 6552816
23:17:02 8116 8192000000 10806978928 11235913728 1862054736 18.520 98 26 51 1 1875724016 6579536 7089744
23:17:17 8837 8192000000 10804909904 11242369024 1874688304 18.622 99 17 33 4 1889325632 9737184 4900144
23:17:32 6673 8192000000 10785483408 11217219584 1835171616 18.301 97 20 40 1 1846620736 6387328 5061792
23:17:45 15515 8192000000 10751191280 11185520640 1787104304 17.908 95 19 36 3 1798028928 5896016 5028608
23:18:06 17645 8192000000 10765378656 11187187712 1789824720 17.930 96 29 60 2 1804177184 5130704 9221760
23:19:23 25807 8192000000 10717603152 11139768320 1630730416 16.601 88 23 46 2 1642785488 5631328 6423744
23:19:55 6598 8192000000 10719791680 11134758912 1756248608 17.653 97 29 55 3 1769516176 5733536 7534032
23:20:08 4831 8192000000 10704199616 11121782784 1782957008 17.874 100 29 58 0 1798365200 6783856 8624336
23:20:23 7996 8192000000 10721218064 11132981248 1756799024 17.658 97 25 50 3 1769996640 6097952 7099664
23:20:38 10771 8192000000 10690556320 11104317440 1720730736 17.358 95 23 46 2 1733609328 6119104 6759488
23:20:56 7574 8192000000 10694015136 11108724736 1723227552 17.379 96 19 38 1 1735224240 4996304 7000384
23:21:10 8338 8192000000 10692751104 11110797312 1773191968 17.793 99 32 64 2 1788110496 5717440 9201088
23:21:25 5407 8192000000 10698585008 11110817792 1779543376 17.846 99 31 62 0 1793975552 5106448 9325728
23:21:39 8165 8192000000 10717085376 11124269056 1754711920 17.641 97 33 66 2 1770845056 6548992 9584144
23:21:53 9757 8192000000 10710176832 11127586816 1754129424 17.636 97 20 39 1 1765432288 5533504 5769360
23:22:12 7402 8192000000 10736608048 11153891328 1813693616 18.126 100 29 58 1 1831716736 9714464 8308656
23:22:27 5125 8192000000 10726580128 11135246336 1796075760 17.982 99 30 58 1 1809501232 5048416 8377056
23:22:44 9484 8192000000 10712675216 11139387392 1792064720 17.949 99 13 26 0 1802458480 6285584 4108176
23:23:08 19923 8192000000 10741817120 11157872640 1823124848 18.203 100 27 54 3 1840926592 9701696 8100048
23:23:34 71488 8192000000 10740581504 11165368320 1814395888 18.132 99 19 38 1 1824326304 4491248 5439168
23:24:52 10178 8192000000 10773549824 11185467392 1845431216 18.385 100 28 56 3 1859876512 6574368 7870928
23:25:12 10266 8192000000 10772371664 11188989952 1842914256 18.365 100 19 38 1 1853538480 5396880 5227344
23:25:32 7300 8192000000 10785040528 11202011136 1858458736 18.491 100 41 81 1 1875763408 6102208 11202464
23:25:46 3607 8192000000 10785709312 11203760128 1864788240 18.542 100 38 74 2 1883795872 8560544 10447088
23:25:56 11098 8192000000 10795344832 11215278080 1866262160 18.554 100 27 56 2 1883852432 10477504 7112768
23:26:19 8193 8192000000 10782790368 11209408512 1865909280 18.551 100 35 70 1 1881608496 4985248 10713968
23:26:33 10184 8192000000 10786594064 11212869632 1867746720 18.566 100 23 46 3 1885282400 10184848 7350832
23:26:52 9802 8192000000 10789894704 11215101952 1869698288 18.582 100 19 37 0 1881175568 5032032 6445248
23:27:08 23057 8192000000 10822540192 11237212160 1893334032 18.773 100 35 69 2 1908448416 5102784 10011600
23:27:41 10877 8192000000 10840586512 11254124544 1904526752 18.863 100 49 96 2 1924937920 7458672 12952496
23:28:19 3246 8192000000 10850115920 11262484480 1913288656 18.933 100 56 111 1 1938266416 9648320 15329440
23:28:30 17857 8192000000 10858725584 11268128768 1921640384 19.000 100 68 136 1 1952682288 12363760 18678144
23:28:56 13250 8192000000 10849000144 11271110656 1923540544 19.015 100 63 126 2 1954586176 14924768 16120864
23:29:37 39356 8192000000 10844021680 11281547264 1924222432 19.021 100 36 72 0 1944132144 9223104 10686608
23:30:23 14001 8192000000 10855111792 11285909504 1929361696 19.062 100 44 88 2 1949800752 6051872 14387184
23:30:49 23272 8192000000 10862970592 11302330368 1937158240 19.124 100 37 74 0 1960009856 11622624 11228992
23:31:22 18750 8192000000 10883075664 11310297088 1950478672 19.230 100 45 89 1 1970907776 7665792 12763312
23:31:58 20454 8192000000 10887636512 11319521280 1954151952 19.260 100 45 90 1 1976127136 8989472 12985712
23:32:28 24088 8192000000 10896801376 11327754240 1961251840 19.316 100 48 96 2 1987982032 12547984 14182208
23:33:00 9257 8192000000 10904882368 11335335936 1966630464 19.359 100 38 76 3 1989930224 12435616 10864144
23:33:20 22227 8192000000 10911323472 11342942208 1971030176 19.394 100 53 107 1 2000709824 14156544 15523104
23:33:53 10236 8192000000 10910796912 11347263488 1976792592 19.439 100 45 88 3 2003799552 14388432 12618528
23:34:11 8392 8192000000 10921086448 11349704704 1981430752 19.476 100 58 117 1 2014543872 15840944 17272176
23:34:28 10429 8192000000 10930900880 11356319744 1979476096 19.461 100 52 106 1 2010610832 16440640 14694096
23:34:46 3766 8192000000 10926941184 11356553216 1982261760 19.483 100 52 104 4 2015464848 16586368 16616720
23:34:58 6341 8192000000 10933608112 11362406400 1987835840 19.527 100 61 122 0 2024587840 18227792 18524208
23:35:12 8486 8192000000 10940301920 11370397696 1990117648 19.545 100 57 112 1 2026983536 19200640 17665248
23:35:34 10652 8192000000 10937202224 11371089920 1991160192 19.553 100 52 103 1 2027954160 20790416 16003552
23:35:58 11201 8192000000 10938563680 11378872320 1993646320 19.573 100 47 91 3 2030998992 22955968 14396704
23:36:25 26380 8192000000 10936117168 11382706176 1996027968 19.591 100 31 60 0 2025073440 20194256 8851216
23:37:14 17668 8192000000 10933550960 11378089984 1995256992 19.585 100 29 58 0 2020135760 16271952 8606816
23:37:55 16183 8192000000 10930040416 11380080640 1997928400 19.606 100 36 72 1 2028444704 19863328 10652976
23:38:18 7625 8192000000 10949064896 11387744256 2005560400 19.667 100 41 82 1 2038338800 20441872 12336528
23:38:35 5938 8192000000 10961731328 11394879488 2012079680 19.718 100 65 129 2 2053597552 21429232 20088640
23:38:52 11668 8192000000 10954686304 11395670016 1997080480 19.600 99 42 84 2 2033550976 23884848 12585648
23:39:27 19186 8192000000 10947562512 11390959616 1995862336 19.590 99 41 82 1 2034637888 26345648 12429904
23:39:55 10690 8192000000 10957226720 11396128768 2012179664 19.719 100 50 99 2 2048985248 22130272 14675312
23:40:16 4338 8192000000 10966138336 11396210688 2008209568 19.687 100 60 119 0 2051156240 25170192 17776480
23:40:28 4932 8192000000 10979347664 11406176256 2016984080 19.756 100 67 134 1 2064001520 26881776 20135664
23:40:41 9341 8192000000 10985041456 11407572992 2013981120 19.733 100 68 136 2 2064012096 28857152 21173824
23:41:01 2045 8192000000 10991127968 11418869760 2023511104 19.808 100 71 141 1 2074978976 30059136 21408736
23:41:13 7251 8192000000 10993592672 11422642176 2026445872 19.831 100 69 137 1 2076581728 29620336 20515520
23:41:29 5510 8192000000 10978740768 11413975040 2010656768 19.707 99 64 128 1 2064793072 34069376 20066928
23:41:45 7626 8192000000 10960296800 11396206592 1976180864 19.434 99 51 101 0 2021517824 28850032 16486928
23:42:00 2007 8192000000 10950003840 11366223872 1965401776 19.349 99 79 159 4 2019529424 29230064 24897584
23:42:10 17927 8192000000 10942506672 11373621248 1981330048 19.475 100 62 123 2 2032648272 31419184 19899040
23:42:35 5533 8192000000 10961751632 11394998272 1992075104 19.560 100 66 131 1 2051448400 38958160 20415136
23:42:54 3469 8192000000 10962716304 11392860160 1984660768 19.502 99 69 137 0 2038344656 32516784 21167104
23:43:05 6855 8192000000 10967492720 11398897664 2004446720 19.658 100 61 121 0 2056382640 32643568 19292352
23:43:22 3324 8192000000 10970557696 11396620288 1985574032 19.509 99 76 152 1 2042960784 33025248 24361504
23:43:32 1978 8192000000 10981401008 11406168064 2005323072 19.665 100 72 141 0 2058851392 31848192 21680128
23:43:44 4446 8192000000 10972613632 11401211904 1987992032 19.528 99 63 126 2 2040659184 33046368 19620784
23:44:11 4591 8192000000 10968305856 11390001152 1991730864 19.557 100 74 150 1 2048492992 34208096 22554032
23:44:22 6822 8192000000 10954618368 11376279552 1981202544 19.474 100 70 140 0 2040056192 36313648 22540000
23:44:37 8782 8192000000 10939156704 11370782720 1962847024 19.329 99 57 114 2 2017227040 35909152 18470864
23:44:54 4965 8192000000 10935967120 11371057152 1974277824 19.419 100 47 94 0 2026392592 36250800 15863968
23:45:07 6998 8192000000 10945430800 11373588480 1972616096 19.406 100 60 120 0 2027659872 35420048 19623728
23:45:21 6940 8192000000 10960867952 11375931392 1978236944 19.451 100 74 148 1 2036351888 34361584 23753360
23:45:36 2360 8192000000 10967625632 11377680384 1979646672 19.462 100 76 151 0 2039919152 36356592 23915888
23:45:45 3637 8192000000 10959919728 11372081152 1962887712 19.329 99 92 184 1 2032232400 40632000 28712688
23:45:57 3633 8192000000 10950398720 11370704896 1974311968 19.420 100 70 140 1 2034660704 37283216 23065520
23:46:09 3326 8192000000 10947873344 11377156096 1974626432 19.422 100 56 110 1 2029480768 37077248 17777088
23:46:20 4867 8192000000 10936735808 11363553280 1937723120 19.129 98 58 115 2 1993856016 37621664 18511232
23:46:34 4564 8192000000 10944761184 11367915520 1967649024 19.367 100 69 138 0 2027408192 37685840 22073328
23:46:45 4691 8192000000 10951564176 11373301760 1953778864 19.257 99 68 136 2 2013954048 38669808 21505376
23:46:57 5002 8192000000 10953353824 11367104512 1967336032 19.364 100 72 144 0 2029776272 40064720 22375520
23:47:10 2309 8192000000 10968744288 11376148480 1976184144 19.434 100 85 169 1 2047691936 44668144 26839648
23:47:22 2844 8192000000 10972069168 11381854208 1973226224 19.411 100 87 175 0 2047986864 47706256 27054384
23:47:32 2345 8192000000 10963145760 11379359744 1970884256 19.392 100 80 160 1 2046413920 49519024 26010640
23:47:43 2220 8192000000 10925538096 11329679360 1919386352 18.982 98 86 172 2 1995674240 48760864 27527024
23:47:52 2999 8192000000 10944723152 11355267072 1947679168 19.208 100 83 166 0 2023479488 50075616 25724704
23:48:04 2648 8192000000 10933310176 11356590080 1949563008 19.223 100 71 142 0 2015880640 44425728 21891904
23:48:14 6197 8192000000 10923865600 11354624000 1951753376 19.240 100 59 118 1 2012198288 42307248 18137664
23:48:28 8897 8192000000 10904392816 11341963264 1948607344 19.215 100 34 68 0 1996813104 37293856 10911904
23:48:47 16249 8192000000 10883332656 11327426560 1926368672 19.038 99 34 68 1 1961898032 24705280 10824080
23:49:10 12719 8192000000 10897518704 11329368064 1922138768 19.004 99 44 83 1 1961199024 26038880 13021376
23:49:34 15259 8192000000 10886049616 11333140480 1935425408 19.110 100 27 54 0 1972543936 28958960 8159568
23:49:56 23610 8192000000 10891986960 11340603392 1942687568 19.168 100 21 42 0 1981026192 30987472 7351152
23:50:39 12927 8192000000 10898561712 11327516672 1929519296 19.063 100 39 77 1 1971058512 29874768 11664448
23:50:59 8031 8192000000 10907023360 11343273984 1944906416 19.186 100 41 82 0 1990558176 33148688 12503072
23:51:17 21405 8192000000 10895484368 11350667264 1937073312 19.123 99 44 88 1 1988147984 36988816 14085856
23:51:46 25480 8192000000 10888568784 11325112320 1891637168 18.759 97 23 47 0 1931676432 32287344 7751920
23:52:17 10557 8192000000 10900748912 11343609856 1937354832 19.126 100 30 58 3 1981590944 34175584 10060528
23:52:39 4983 8192000000 10900203520 11341508608 1937037488 19.123 100 40 76 1 1986690048 36757712 12894848
23:52:54 12228 8192000000 10900610880 11337957376 1917836528 18.970 99 30 58 1 1965082960 37418192 9828240
23:53:16 35278 8192000000 10876226944 11327115264 1893658656 18.775 98 29 58 1 1943105920 39263136 10184128
23:53:58 18189 8192000000 10882712656 11329466368 1910497712 18.911 99 22 44 0 1956823696 38736512 7589472
23:54:28 23216 8192000000 10864221728 11309506560 1870799264 18.591 97 23 46 2 1909174352 31063536 7311552
23:55:00 33236 8192000000 10878768400 11336093696 1928773536 19.057 100 23 46 1 1968093360 31566432 7753392
23:56:13 38297 8192000000 10865154944 11314991104 1880995888 18.673 98 20 41 1 1918623872 31159856 6468128
23:57:52 75643 8192000000 10871958192 11311484928 1857686208 18.485 96 18 36 0 1883127152 20282816 5158128
23:59:17 11105 8192000000 10865487648 11299598336 1925182192 19.028 100 38 77 1 1943435648 7332784 10920672
23:59:34 50920 8192000000 10888707984 11320582144 1900065760 18.827 98 28 55 1 1918176128 10459904 7650464
00:00:35 120213 8192000000 10890960032 11334889472 1923922576 19.018 99 33 64 2 1948755696 15467360 9365760
00:02:54 79953 8192000000 10889692864 11333931008 1925056816 19.027 99 26 51 2 1941709696 9417984 7234896
00:04:24 29056 8192000000 10917483328 11350994944 1955036240 19.267 100 47 94 0 1977076768 8758528 13282000
00:05:10 28475 8192000000 10894090880 11347996672 1960410384 19.309 100 35 67 3 1980464656 9832704 10221568
00:05:48 2857 8192000000 10905753168 11356540928 1964536000 19.342 100 40 80 0 1986714096 11356208 10821888
00:06:36 30349 8192000000 10888375792 11356979200 1963587744 19.335 100 12 21 3 1977217920 10240848 3389328
00:07:12 27078 8192000000 10897542288 11355828224 1948122240 19.212 99 19 37 1 1963273792 9779920 5371632
00:07:50 34628 8192000000 10907051552 11359637504 1971947264 19.401 100 48 94 1 2001205552 16355424 12902864
00:08:31 40921 8192000000 10884587088 11364352000 1963792464 19.336 100 14 28 0 1977719392 9795024 4131904
00:09:19 24032 8192000000 10878068256 11351793664 1932043616 19.083 98 16 32 2 1945766912 9615792 4107504
00:09:54 23221 8192000000 10879063152 11349823488 1949686064 19.224 99 13 26 2 1962599952 9207056 3706832
00:10:29 123256 8192000000 10917640896 11391029248 1980581776 19.469 100 20 40 0 1998991664 12849136 5560752
00:12:39 49746 8192000000 10917757856 11384692736 1986909360 19.519 100 18 36 0 2006886992 14344576 5633056
00:13:41 75055 8192000000 10924766112 11392905216 1987036096 19.520 100 10 20 0 1999649072 9597504 3015472
00:15:04 25012 8192000000 10918684576 11389362176 1991106688 19.553 100 15 30 0 2006689408 11251008 4331712
00:15:37 14452 8192000000 10912641200 11393765376 1993966752 19.575 100 21 40 2 2010196736 10583040 5646944
00:15:58 47500 8192000000 10908119072 11380518912 1959919040 19.305 98 10 20 0 1975567344 12915712 2732592
00:16:53 50159 8192000000 10913607872 11389513728 1990080512 19.544 100 14 28 0 2006437392 12032368 4324512
00:17:50 75317 8192000000 10891095408 11386982400 1953555984 19.255 98 4 8 0 1965053104 10502832 994288
00:19:12 21964 8192000000 10921749872 11387908096 1989099968 19.537 100 32 65 2 2006360848 7071136 10189744
00:19:42 69370 8192000000 10913244688 11388882944 1954891536 19.265 98 14 28 1 1967715104 8882144 3941424
00:20:58 48551 8192000000 10892251680 11374587904 1930744848 19.073 97 16 32 0 1943928768 8479296 4704624
00:21:53 29052 8192000000 10925370320 11395190784 1995891008 19.590 100 32 65 1 2012804464 7950256 8963200
00:22:28 49355 8192000000 10899774640 11370418176 1910045808 18.907 96 26 52 0 1930870544 13769344 7055392
00:23:28 45731 8192000000 10910478560 11375644672 1958928096 19.298 99 30 60 0 1976585696 8940576 8717024
00:24:23 22200 8192000000 10910598592 11372904448 1961946016 19.322 99 29 58 0 1978220896 8439584 7835296
00:24:53 63341 8192000000 10896052880 11361320960 1885224016 18.707 95 30 60 2 1907800384 13888256 8688112
00:26:08 60131 8192000000 10878129088 11336826880 1861912080 18.519 95 18 36 1 1878710400 11256064 5542256
00:27:15 46670 8192000000 10910978352 11369316352 1951248192 19.236 99 33 65 1 1976430080 15686112 9495776
00:28:10 67508 8192000000 10884501728 11374002176 1909421808 18.902 97 25 50 1 1940963264 24204784 7336672
00:29:50 40581 8192000000 10883369456 11336699904 1876839984 18.640 96 18 36 1 1892399296 10619472 4939840
00:30:42 54159 8192000000 10873391312 11333992448 1900625008 18.831 98 22 44 1 1924983360 18506384 5851968
00:31:45 94842 8192000000 10882590928 11363852288 1896385584 18.797 97 31 62 1 1920533008 15730128 8417296
00:33:51 104493 8192000000 10880277872 11338821632 1899492880 18.822 97 21 42 0 1916887136 11500032 5894224
00:36:18 56843 8192000000 10881759424 11346583552 1916353088 18.958 98 25 50 2 1940285760 16856176 7076496
00:37:29 39535 8192000000 10864525472 11348131840 1930073952 19.067 99 14 28 0 1953279792 18825216 4380624
00:38:21 95516 8192000000 10834769792 11316613120 1812555280 18.117 93 12 24 2 1834919840 18693152 3671408
00:40:03 39291 8192000000 10828018208 11317198848 1893133072 18.771 99 7 14 0 1916732384 21256176 2343136
00:40:49 26255 8192000000 10831984096 11304935424 1888328464 18.732 99 7 14 0 1906629072 16452768 1847840
00:41:33 100180 8192000000 10818777664 11293831168 1823183008 18.204 95 12 24 0 1835027184 8465760 3378416
00:43:19 62910 8192000000 10806566592 11260887040 1820654048 18.183 95 9 18 1 1835786736 12711552 2421136
00:44:35 40031 8192000000 10850609808 11300093952 1871417984 18.596 98 34 68 1 1893146768 12189184 9539600
00:45:21 42357 8192000000 10842721072 11307036672 1900896320 18.834 99 34 65 1 1922461632 12405456 9159856
00:46:13 71072 8192000000 10857548416 11301183488 1880604864 18.670 98 31 62 1 1899603664 10640048 8358752
00:47:31 51230 8192000000 10842875920 11294662656 1852051440 18.439 96 31 62 0 1868955856 8749584 8154832
00:48:35 90544 8192000000 10877770768 11329253376 1914288720 18.941 99 26 52 1 1936709904 15051424 7369760
00:50:14 38643 8192000000 10880883120 11330809856 1920945424 18.994 99 48 96 1 1945390800 10883616 13561760
00:51:03 89598 8192000000 10898983168 11352743936 1952378464 19.245 100 25 50 0 1973715584 14159872 7177248
00:52:39 68603 8192000000 10882021760 11367862272 1918808160 18.977 98 19 38 1 1943768768 19494080 5466528
00:53:54 61453 8192000000 10889816896 11366146048 1941072640 19.155 99 12 24 0 1963333120 19002608 3257872
00:55:04 130556 8192000000 10890911824 11363037184 1904243904 18.860 97 8 16 0 1921700160 15396864 2059392
00:57:39 101566 8192000000 10917571424 11383107584 1985850832 19.511 100 31 62 2 2002452576 8520784 8080960
00:59:26 47926 8192000000 10894589136 11360931840 1942880864 19.170 98 19 38 0 1958462912 10471200 5110848
01:00:26 38645 8192000000 10895156128 11378135040 1980824048 19.471 100 13 26 0 1992048688 7952800 3271840
01:01:11 63667 8192000000 10883080320 11357773824 1941432784 19.158 98 13 26 0 1950317616 5423760 3461072
01:02:26 86565 8192000000 10894317728 11371888640 1962858080 19.329 99 9 18 1 1973657520 8370704 2428736
01:04:27 62228 8192000000 10889241024 11369902080 1928680128 19.056 97 15 30 0 1942213696 8619920 4913648
01:05:45 104691 8192000000 10932481088 11405193216 1989827904 19.542 100 10 20 0 2014521008 22111200 2581904
01:07:39 91478 8192000000 10918713600 11387842560 1953138560 19.251 98 11 22 0 1973734016 17437024 3158432
01:09:29 38960 8192000000 10936636784 11389296640 1963616336 19.335 98 40 78 1 1986330080 11347344 11366400
01:10:20 20142 8192000000 10915495424 11366785024 1930740624 19.073 97 44 88 2 1955219104 11990752 12487728
01:10:55 49039 8192000000 10908339200 11370168320 1963755120 19.336 99 35 70 2 1987470320 13773712 9941488
01:11:56 47715 8192000000 10895136560 11346006016 1916527056 18.959 97 35 70 2 1937932880 12007056 9398768
01:12:55 95692 8192000000 10901589440 11372761088 1914866496 18.946 97 21 42 2 1937150272 16815120 5468656
01:14:38 50699 8192000000 10914148240 11378085888 1974409216 19.420 100 15 30 1 1989000048 10004336 4586496
01:15:45 45908 8192000000 10894368384 11362611200 1930322304 19.069 98 21 42 0 1946243856 10333216 5588336
01:17:10 140419 8192000000 10886448032 11349610496 1902688464 18.848 97 35 70 1 1928922688 16232944 10001280
01:19:40 82006 8192000000 10882012416 11349229568 1936319792 19.117 99 13 26 0 1949961488 9975408 3666288
01:21:09 76005 8192000000 10851802896 11333267456 1886332400 18.716 97 6 12 0 1895914240 8121280 1460560
01:22:36 57503 8192000000 10852720000 11334586368 1924310336 19.021 99 11 22 0 1935678496 8435568 2932592
01:23:39 36800 8192000000 10869294128 11342446592 1908309984 18.893 98 13 25 1 1922407856 11153216 2944656
01:24:30 80415 8192000000 10872608192 11339771904 1840391904 18.344 94 12 24 0 1857166160 13163248 3611008
01:25:56 53656 8192000000 10887537920 11354927104 1915093328 18.948 98 18 35 1 1936187872 15429008 5665536
01:26:56 36462 8192000000 9161129040 9401937920 322562256 3.788 17 6 7 2 329246432 4915808 1768368

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 25-01-2021 01:29:08 to 25-01-2021 01:29:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 163 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-01-2021 01:29:40 to 25-01-2021 01:29:42.

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          242907
MON$OLDEST_ACTIVE               242908
MON$OLDEST_SNAPSHOT             242908
MON$NEXT_TRANSACTION            242908
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                       2021184
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:401: 
:402: mscs-test-161.budzdorov.ru    Mon Jan 25 01:27:58 2021
:403:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:404: 
--- end of diff output ---

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

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