Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.01.2021 22: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 17197016 kB
MemAvailable 31286556 kB
Buffers 0 kB
Cached 14486616 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-23 22:27:09
DTS_END                         2021-01-23 22:27:09.8600
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52718
TRN_ID                          236673
ATT_ID                          695
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: 9288.78 18098 1114654
customer order: creation 172.08 371 20649
customer order: refuse 15.03 342 1804
order to supplier: creation 46.12 1265 5534
order to supplier: removal 3.43 104999 411
invoice (draft): creation 45.34 3282 5441
invoice (draft): removal 53.18 832 6381
invoice accept: apply 41.18 17529 4942
invoice accept: cancel 48.04 739 5765
customer reserve: creation 3857.93 170 462951
customer reserve: removal 4710.43 60 565252
realization accept: apply 83.74 176 10049
realization accept: cancel 84.88 104 10185
payment from customer: creation 58.31 119 6997
payment from customer: removal 5.98 67 718
payment to supplier: creation 47.31 108 5677
payment to supplier: removal 3.44 85 413
service: total inventory turnovers 5.04 934 605
service: total monetary turnovers 6.38 35 766
service: aggregate perf. data 0.92 16517 110
service: refresh index statistics 0.03 214220 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-01-2021 22:28:25 to 23-01-2021 22:28:27.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8729
TEST_TIME 2 6522
TEST_TIME 3 6587
TEST_TIME 4 6552
TEST_TIME 5 6347
TEST_TIME 6 6273
TEST_TIME 7 6184
TEST_TIME 8 6207
TEST_TIME 9 6153
TEST_TIME 10 6316
TEST_TIME 11 6318
TEST_TIME 12 6314
TEST_TIME 13 6713
TEST_TIME 14 6942
TEST_TIME 15 6914
TEST_TIME 16 7220
TEST_TIME 17 7585
TEST_TIME 18 8409
TEST_TIME 19 8270
TEST_TIME 20 8424
TEST_TIME 21 8765
TEST_TIME 22 8710
TEST_TIME 23 8898
TEST_TIME 24 9681
TEST_TIME 25 10312
TEST_TIME 26 10602
TEST_TIME 27 10475
TEST_TIME 28 11023
TEST_TIME 29 10881
TEST_TIME 30 10654
TEST_TIME 31 10504
TEST_TIME 32 10314
TEST_TIME 33 10373
TEST_TIME 34 10287
TEST_TIME 35 10114
TEST_TIME 36 10145
TEST_TIME 37 10021
TEST_TIME 38 10011
TEST_TIME 39 10003
TEST_TIME 40 10193
TEST_TIME 41 10103
TEST_TIME 42 9994
TEST_TIME 43 10022
TEST_TIME 44 9952
TEST_TIME 45 9850
TEST_TIME 46 9683
TEST_TIME 47 9650
TEST_TIME 48 9542
TEST_TIME 49 9524
TEST_TIME 50 9519
TEST_TIME 51 9547
TEST_TIME 52 9476
TEST_TIME 53 9489
TEST_TIME 54 9560
TEST_TIME 55 9574
TEST_TIME 56 9561
TEST_TIME 57 9689
TEST_TIME 58 9672
TEST_TIME 59 9689
TEST_TIME 60 9772
TEST_TIME 61 9866
TEST_TIME 62 9837
TEST_TIME 63 9811
TEST_TIME 64 9700
TEST_TIME 65 9604
TEST_TIME 66 9605
TEST_TIME 67 9499
TEST_TIME 68 9483
TEST_TIME 69 9475
TEST_TIME 70 9408
TEST_TIME 71 9369
TEST_TIME 72 9357
TEST_TIME 73 9378
TEST_TIME 74 9394
TEST_TIME 75 9366
TEST_TIME 76 9370
TEST_TIME 77 9414
TEST_TIME 78 9528
TEST_TIME 79 9486
TEST_TIME 80 9547
TEST_TIME 81 9517
TEST_TIME 82 9595
TEST_TIME 83 9631
TEST_TIME 84 9568
TEST_TIME 85 9558
TEST_TIME 86 9493
TEST_TIME 87 9475
TEST_TIME 88 9485
TEST_TIME 89 9458
TEST_TIME 90 9431
TEST_TIME 91 9381
TEST_TIME 92 9358
TEST_TIME 93 9366
TEST_TIME 94 9345
TEST_TIME 95 9352
TEST_TIME 96 9375
TEST_TIME 97 9438
TEST_TIME 98 9404
TEST_TIME 99 9414
TEST_TIME 100 9433
TEST_TIME 101 9437
TEST_TIME 102 9511
TEST_TIME 103 9483
TEST_TIME 104 9515
TEST_TIME 105 9563
TEST_TIME 106 9588
TEST_TIME 107 9524
TEST_TIME 108 9464
TEST_TIME 109 9460
TEST_TIME 110 9426
TEST_TIME 111 9393
TEST_TIME 112 9343
TEST_TIME 113 9366
TEST_TIME 114 9347
TEST_TIME 115 9321
TEST_TIME 116 9300
TEST_TIME 117 9341
TEST_TIME 118 9341
TEST_TIME 119 9366
TEST_TIME 120 9294

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-01-2021 22:28:28 to 23-01-2021 22:28:32.

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 1544245 1544245 0 0.00 0 21889 6 0 0
doc_list_biud 1544245 1544245 0 0.00 0 37937 28 0 0
sp_add_invoice_to_stock 5102 4942 160 3.13 61 161943 17530 0 160
sp_cancel_adding_invoice 5765 5765 0 0.00 5 53923 740 0 0
sp_cancel_client_order 1804 1804 0 0.00 4 8473 342 0 0
sp_cancel_customer_reserve 565252 565252 0 0.00 1 37938 60 0 0
sp_cancel_pay_from_customer 718 718 0 0.00 2 5664 67 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 3 4610 86 0 0
sp_cancel_supplier_invoice 6396 6381 15 0.23 1 21025 833 0 15
sp_cancel_supplier_order 411 411 0 0.00 12 1029286 105000 0 0
sp_cancel_write_off 10185 10185 0 0.00 1 8543 105 0 0
sp_client_order 20649 20649 0 0.00 3 26099 371 0 0
sp_customer_reserve 462951 462951 0 0.00 0 73264 171 0 0
sp_fill_shopping_cart 31615 31615 0 0.00 1 10565 38 0 0
sp_fill_shopping_cart_clo_res 462921 462921 0 0.00 0 10982 14 0 0
sp_get_clo_for_invoice 4912 4912 0 0.00 0 35582 295 0 0
sp_kill_cost_storno 17081 17081 0 0.00 0 7796 52 0 0
sp_kill_qstorno_ret_qs2qd 1147481 1147481 0 0.00 0 37934 33 0 0
sp_kill_qty_storno 604759 604759 0 0.00 0 37935 70 0 0
sp_lock_selected_doc 20758 20758 0 0.00 0 9253 5 0 0
sp_make_cost_storno 27635 27635 0 0.00 0 21867 48 0 0
sp_multiply_rows_for_pdistr 27635 27635 0 0.00 0 12792 28 0 0
sp_multiply_rows_for_qdistr 20649 20649 0 0.00 0 24803 185 0 0
sp_pay_from_customer 6997 6997 0 0.00 4 15485 119 0 0
sp_pay_to_supplier 5677 5677 0 0.00 4 9672 109 0 0
sp_payment_common 12674 12674 0 0.00 1 15479 30 0 0
sp_qd_handle_on_cancel_clo 1804 1804 0 0.00 0 8426 317 0 0
sp_qd_handle_on_invoice_upd_sts 10677 10677 0 0.00 0 21053 309 0 0
sp_qd_handle_on_reserve_upd_sts 10049 10049 0 0.00 0 15484 64 0 0
sp_reserve_write_off 10049 10049 0 0.00 6 15530 176 0 0
sp_supplier_invoice 5441 5441 0 0.00 6 90994 3282 0 0
sp_supplier_order 5534 5534 0 0.00 5 21635 1266 0 0
srv_aggregate_perf_data 110 110 0 0.00 2469 115059 16518 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1255 170555 33324 0 0
srv_find_qd_qs_mism 1067619 1067619 0 0.00 0 9085 5 0 0
srv_make_invnt_saldo 605 605 0 0.00 22 33740 935 0 0
srv_make_money_saldo 766 766 0 0.00 1 9716 36 0 0
srv_recalc_idx_stat 4 4 0 0.00 151133 302271 214221 0 0
t$perf-abend:sp_add_invoice_to_stock 160 160 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 4942 4942 0 0.00 0 8540 174 0 0
t$perf-norm:sp_cancel_adding_invoice 382 382 0 0.00 0 9708 122 0 0
t$perf-norm:sp_cancel_client_order 1804 1804 0 0.00 0 3837 16 0 0
t$perf-norm:sp_cancel_customer_reserve 681 681 0 0.00 0 2985 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 718 718 0 0.00 0 1816 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 2565 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 390 390 0 0.00 0 1627 17 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 16643 1483 0 0
t$perf-norm:sp_cancel_write_off 1001 1001 0 0.00 0 2507 6 0 0
t$perf-norm:sp_client_order 20649 20649 0 0.00 0 10552 16 0 0
t$perf-norm:sp_customer_reserve 973 973 0 0.00 0 6474 15 0 0
t$perf-norm:sp_pay_from_customer 6997 6997 0 0.00 0 11302 11 0 0
t$perf-norm:sp_pay_to_supplier 5677 5677 0 0.00 0 8136 13 0 0
t$perf-norm:sp_reserve_write_off 10049 10049 0 0.00 0 13680 12 0 0
t$perf-norm:sp_supplier_invoice 5441 5441 0 0.00 0 4962 18 0 0
t$perf-norm:sp_supplier_order 5534 5534 0 0.00 0 7922 19 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 101 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 1125 13 0 0
t$perf-norm:srv_make_invnt_saldo 605 605 0 0.00 0 10444 38 0 0
t$perf-norm:srv_make_money_saldo 766 766 0 0.00 0 3908 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 10138 9818 320 3.15 0 7873 18 0 320
v_all_customers 37636 37636 0 0.00 0 20 1 0 0
v_all_suppliers 30190 30190 0 0.00 0 18 1 0 0
v_all_wares 41298 41298 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 764 764 0 0.00 0 231 5 0 0
v_cancel_client_order 3608 3608 0 0.00 0 3585 5 0 0
v_cancel_customer_prepayment 1436 1436 0 0.00 0 465 4 0 0
v_cancel_customer_reserve 1362 1362 0 0.00 0 2181 5 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 2279 7 0 0
v_cancel_supplier_invoice 810 780 30 3.70 0 5445 24 0 30
v_cancel_supplier_order 822 822 0 0.00 0 215 3 0 0
v_cancel_write_off 2002 2002 0 0.00 0 2649 16 0 0
v_max_id_clo_ord 5533 5533 0 0.00 0 437 1 0 0
v_max_id_clo_res 973 973 0 0.00 0 3602 15 0 0
v_max_id_ord_sup 5433 5433 0 0.00 0 5008 4 0 0
v_max_non_paid_invoice 1548 1548 0 0.00 0 971 3 0 0
v_max_non_paid_realizn 3736 3736 0 0.00 0 3590 4 0 0
v_min_id_clo_ord 5533 5533 0 0.00 0 1520 5 0 0
v_min_id_clo_res 973 973 0 0.00 0 6550 12 0 0
v_min_id_ord_sup 5433 5433 0 0.00 0 6910 5 0 0
v_min_non_paid_invoice 5677 5677 0 0.00 0 4305 16 0 0
v_min_non_paid_realizn 6997 6997 0 0.00 0 7099 21 0 0
v_our_firm 10184 10184 0 0.00 0 14 1 0 0
v_reserve_write_off 20098 20098 0 0.00 0 3568 6 0 0
x_lock_depdocs_on_canc_invoice 11756 11756 0 0.00 0 11909 107 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 19736 414 0 0
x_make_qstorno_1000_1200 5534 5534 0 0.00 1 21630 1188 0 0
x_make_qstorno_1200_2000 5441 5441 0 0.00 3 80472 3149 0 0
x_make_qstorno_2100_3300 462951 462951 0 0.00 0 73263 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-01-2021 22:28:33 to 23-01-2021 22:28:37.

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:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:19 10019 8192000000 10193803920 10496622592 790214976 8.797 64 47 95 1 809402192 2394800 16792416
19:57:39 35643 8192000000 10346372112 10666565632 1376573936 14.386 100 86 172 1 1409125728 4507184 28044608
19:58:23 32930 8192000000 10391298640 10716180480 1437440832 14.927 100 86 172 1 1471969040 6715184 27813024
19:59:06 21001 8192000000 10408868864 10738053120 1465693424 15.176 100 90 180 0 1502964992 7992864 29278704
19:59:43 27032 8192000000 10434638048 10773241856 1491405088 15.401 100 86 173 0 1527506432 8575552 27525792
20:00:19 19585 8192000000 10453330608 10791116800 1511036048 15.572 100 87 174 1 1547614560 9105936 27472576
20:00:47 23583 8192000000 10493847424 10835853312 1541933280 15.840 100 91 182 2 1580198656 9744720 28520656
20:01:18 17706 8192000000 10494947824 10842873856 1553417216 15.939 100 82 164 1 1589126320 10239216 25469888
20:01:51 18231 8192000000 10516085440 10867798016 1573277296 16.110 100 84 169 0 1610070160 10699856 26093008
20:02:18 14490 8192000000 10534285088 10886254592 1597238416 16.316 100 89 178 0 1635454224 11349776 26866032
20:02:40 10706 8192000000 10538675408 10898399232 1601688048 16.354 100 83 166 1 1638241504 11833312 24720144
20:03:00 12040 8192000000 10572847248 10934571008 1633555840 16.625 100 82 164 0 1670600560 12394880 24649840
20:03:20 11285 8192000000 10594209344 10960297984 1652457616 16.785 100 80 158 2 1688245760 12384464 23403680
20:03:39 10945 8192000000 10608510592 10977173504 1670979376 16.941 100 81 162 2 1707358976 12224304 24155296
20:03:57 6783 8192000000 10616071488 10990153728 1684490160 17.055 100 78 156 1 1719634576 12259888 22884528
20:04:11 8457 8192000000 10635319696 11011833856 1697980928 17.168 100 72 144 1 1730062016 11398864 20682224
20:04:27 8151 8192000000 10653649232 11031216128 1719044928 17.344 100 74 148 2 1752400608 11875184 21480496
20:04:42 6187 8192000000 10669918912 11049226240 1732906752 17.460 100 75 149 1 1767303632 12895776 21501104
20:04:55 4853 8192000000 10685401888 11060600832 1747908880 17.584 100 79 157 2 1783243456 13124064 22210512
20:05:07 3947 8192000000 10691837552 11071258624 1758440000 17.671 100 76 152 0 1792801456 12704880 21656576
20:05:18 4954 8192000000 10706779632 11082006528 1761886704 17.700 100 76 152 1 1796972912 12492464 22593744
20:05:29 5112 8192000000 10716448704 11095126016 1770961328 17.775 100 85 171 0 1809193248 14279728 23952192
20:05:42 10411 8192000000 10717814160 11098411008 1774136864 17.801 100 71 142 1 1807320256 13512320 19671072
20:06:00 2945 8192000000 10737910800 11119595520 1794877840 17.972 100 85 170 1 1832180432 14251392 23051200
20:06:10 2914 8192000000 10741027552 11123314688 1803021744 18.039 100 86 172 0 1841182160 13866048 24294368
20:06:20 2818 8192000000 10742348432 11122237440 1803994224 18.047 100 86 173 2 1842088640 13756656 24337760
20:06:30 3112 8192000000 10743675296 11133370368 1815924080 18.144 100 74 148 1 1848505248 11549024 21032144
20:06:41 2591 8192000000 10764228288 11148726272 1825706784 18.224 100 89 179 1 1864410688 13571952 25131952
20:06:50 2062 8192000000 10777468464 11159629824 1832430096 18.279 100 90 180 0 1872887456 14263920 26193440
20:06:58 1451 8192000000 10770519472 11162271744 1835749920 18.306 100 88 177 1 1875211712 13681584 25780208
20:07:06 2251 8192000000 10781876128 11171307520 1842539552 18.361 100 85 169 0 1879347792 13762176 23046064
20:07:15 1756 8192000000 10789953360 11174924288 1845133696 18.383 100 92 184 0 1886232928 14753568 26345664
20:07:23 1667 8192000000 10794585296 11179659264 1852640064 18.444 100 91 182 4 1892543856 14705680 25198112
20:07:33 2518 8192000000 10796763584 11184259072 1857166224 18.480 100 92 183 0 1897581136 14622480 25792432
20:07:42 1548 8192000000 10801315120 11186298880 1861183168 18.513 100 96 192 4 1902488080 14118704 27186208
20:07:50 2029 8192000000 10807322064 11194912768 1861370048 18.514 100 95 190 0 1903295472 14587344 27338080
20:07:58 2020 8192000000 10807895536 11196784640 1862767856 18.526 100 85 163 2 1897576784 10984944 23823984
20:08:07 1592 8192000000 10814033872 11203620864 1873082544 18.609 100 94 191 0 1912429968 11111840 28235584
20:08:14 26878 8192000000 10801863360 11199139840 1865122480 18.545 100 52 104 0 1888647200 7602992 15921728
20:08:55 6099 8192000000 10783481712 11203067904 1869580752 18.581 100 47 93 1 1890478800 8097136 12800912
20:09:09 6221 8192000000 10800445632 11206184960 1870603024 18.589 100 34 68 0 1887499072 6955456 9940592
20:09:22 6046 8192000000 10799421792 11204526080 1870715264 18.590 100 40 81 1 1889969984 7135248 12119472
20:09:36 5033 8192000000 10769379248 11202777088 1868597184 18.573 100 23 46 0 1882154096 7360608 6196304
20:09:47 4913 8192000000 10785101392 11205890048 1871547360 18.597 100 36 72 1 1889124368 7053360 10523648
20:09:58 8883 8192000000 10769338208 11200229376 1868095200 18.569 100 17 34 3 1879503328 6406464 5001664
20:10:13 6740 8192000000 10777926544 11204194304 1867821824 18.567 100 17 33 1 1878768528 6061248 4885456
20:10:27 11328 8192000000 10781345024 11206590464 1871139744 18.593 100 17 34 0 1881469648 5265296 5064608
20:10:47 14957 8192000000 10773870000 11210203136 1873618480 18.614 100 14 28 1 1883567152 6275312 3673360
20:11:08 24877 8192000000 10782882816 11223363584 1876472816 18.637 100 24 45 4 1888580432 5432944 6674672
20:12:05 21608 8192000000 10841472736 11238117376 1891428288 18.757 100 70 138 3 1918217216 5195504 21593424
20:12:33 12713 8192000000 10799036944 11233214464 1888760256 18.736 100 31 61 2 1905071024 7766384 8544384
20:12:52 6689 8192000000 10805130960 11235901440 1889283984 18.740 100 26 51 2 1903595616 6406112 7905520
20:13:06 6556 8192000000 10805262944 11239194624 1892231824 18.764 100 26 53 1 1906288800 6967744 7089232
20:13:18 6320 8192000000 10808075792 11236945920 1891338672 18.757 100 23 46 1 1903844624 6080560 6425392
20:13:31 5820 8192000000 10809715328 11240042496 1895911280 18.793 100 27 54 2 1909992976 6405440 7676256
20:13:44 3962 8192000000 10810464384 11238207488 1895387728 18.789 100 33 66 1 1911357808 6458624 9511456
20:13:55 7974 8192000000 10803888448 11239546880 1893287952 18.772 100 22 45 3 1905326672 5558512 6480208
20:14:09 5136 8192000000 10805426448 11241492480 1895544832 18.790 100 18 36 3 1906584928 5708160 5331936
20:14:21 7428 8192000000 10818037632 11245727744 1899076304 18.819 100 30 61 1 1914402384 7087216 8238864
20:14:36 9824 8192000000 10807279824 11246546944 1897633152 18.807 100 22 44 0 1910806272 6798928 6374192
20:14:53 12886 8192000000 10815702096 11246862336 1899406048 18.822 100 18 36 2 1910370560 5784384 5180128
20:15:14 11269 8192000000 10808291536 11240988672 1881010288 18.673 99 16 32 0 1892400848 6676448 4714112
20:15:31 10897 8192000000 10812096128 11244576768 1893817040 18.777 100 11 21 0 1901958928 5240672 2901216
20:15:53 63106 8192000000 10802545328 11236769792 1864688144 18.541 98 40 80 0 1881638224 6276160 10673920
20:17:04 10924 8192000000 10799384032 11238670336 1890240720 18.748 100 24 48 2 1904034448 7261040 6532688
20:17:21 6798 8192000000 10800294032 11231363072 1882271392 18.683 99 35 71 2 1898483760 6665792 9546576
20:17:37 6486 8192000000 10796988272 11232620544 1888544608 18.734 100 23 47 0 1902057920 6305856 7207456
20:17:52 7784 8192000000 10787096272 11219709952 1864566368 18.540 99 34 68 3 1880609248 5615088 10427792
20:18:09 7206 8192000000 10771344432 11196821504 1827878000 18.242 98 30 60 1 1842118864 5768480 8472384
20:18:25 10197 8192000000 10730589568 11151769600 1747682224 17.582 94 17 35 1 1757752912 5337680 4733008
20:18:43 10545 8192000000 10743395632 11164266496 1796507856 17.985 98 24 48 0 1809649472 6307392 6834224
20:19:01 7906 8192000000 10735601408 11153457152 1714936752 17.310 93 27 54 2 1728363072 4827648 8598672
20:19:15 8743 8192000000 10704435120 11117735936 1660131808 16.850 91 22 45 0 1670513200 4016672 6364720
20:19:30 6639 8192000000 10685790592 11109883904 1749959328 17.601 98 23 47 1 1761931200 5708176 6263696
20:19:43 12676 8192000000 10686738464 11097620480 1718834704 17.342 96 23 44 1 1730599616 4838144 6926768
20:20:05 14136 8192000000 10712639712 11126988800 1732649664 17.458 96 35 70 2 1748867280 5444816 10772800
20:20:25 47620 8192000000 10676452944 11077627904 1711250544 17.279 95 32 65 1 1725837088 5616080 8970464
20:21:26 18520 8192000000 10678954496 11100745728 1727250688 17.413 96 26 52 3 1740303808 5599136 7453984
20:21:52 9034 8192000000 10710817856 11125485568 1789192848 17.925 100 27 54 2 1803148160 6275216 7680096
20:22:10 3379 8192000000 10725414240 11139260416 1792039440 17.949 99 43 86 1 1815989024 12006624 11942960
20:22:19 4989 8192000000 10704451952 11130888192 1788077968 17.916 99 33 66 3 1803891712 6601216 9212528
20:22:31 12117 8192000000 10739412880 11151364096 1797863280 17.996 99 25 49 1 1811033328 5952720 7217328
20:22:52 3853 8192000000 10744676192 11164401664 1820711520 18.184 100 20 39 0 1840266368 14514896 5039952
20:23:02 5346 8192000000 10753616800 11173269504 1830253376 18.261 100 35 70 1 1851324112 11271184 9799552
20:23:14 4768 8192000000 10736437168 11159470080 1811150480 18.105 99 34 68 3 1827235808 5953664 10131664
20:23:26 11356 8192000000 10753596608 11174395904 1832974000 18.284 100 20 40 0 1844659504 5607376 6078128
20:23:44 9625 8192000000 10754918832 11180826624 1843218240 18.367 100 19 38 2 1854591632 5829312 5544080
20:24:00 10629 8192000000 10771829344 11188125696 1844957280 18.381 100 26 50 0 1858105536 4873872 8274384
20:24:18 11326 8192000000 10766495104 11185471488 1849910880 18.421 100 22 44 0 1862228320 5905376 6412064
20:24:37 8794 8192000000 10778650224 11197419520 1850436096 18.426 100 24 48 0 1863025232 5320272 7268864
20:24:52 9549 8192000000 10773505440 11195662336 1855982288 18.471 100 17 34 0 1870504144 10246064 4275792
20:25:08 9761 8192000000 10770977920 11197837312 1858789056 18.493 100 19 37 3 1868718624 5327888 4601680
20:25:26 73558 8192000000 10785120256 11215364096 1867808496 18.567 100 28 57 1 1882033520 5646864 8578160
20:26:52 5517 8192000000 10793184256 11223887872 1878398656 18.652 100 45 90 1 1900656832 9575584 12682592
20:27:03 20349 8192000000 10828441376 11242033152 1891370704 18.757 100 43 86 0 1909370240 6824336 11175200
20:27:32 2952 8192000000 10847913552 11257090048 1906424656 18.878 100 60 118 3 1931361360 9488528 15448176
20:27:43 22105 8192000000 10859489360 11269185536 1916671952 18.960 100 71 140 0 1947668448 10976752 20019744
20:28:13 6933 8192000000 10858973664 11274125312 1923574096 19.015 100 65 130 1 1953204576 11497904 18132576
20:28:37 15994 8192000000 10859636880 11280265216 1927384208 19.046 100 53 103 2 1951030352 9825104 13821040
20:29:01 20803 8192000000 10858357280 11284099072 1930940656 19.074 100 42 81 1 1951810048 9584640 11284752
20:29:31 10550 8192000000 10870949344 11291734016 1938950256 19.138 100 51 100 3 1965323376 11513792 14859328
20:29:56 16990 8192000000 10869081344 11296919552 1939630768 19.144 100 43 85 0 1964806960 12909216 12266976
20:30:21 13852 8192000000 10885356336 11306774528 1943879824 19.178 100 48 96 2 1970010992 12194208 13936960
20:30:57 29516 8192000000 10876402448 11315900416 1951182032 19.236 100 35 70 0 1975375808 14041360 10152416
20:31:40 31620 8192000000 10902762176 11333169152 1961531024 19.318 100 47 94 0 1990884128 15194832 14158272
20:32:24 17502 8192000000 10899189552 11335446528 1966237728 19.356 100 44 86 0 1993627152 14734432 12654992
20:32:59 27864 8192000000 10904130272 11342188544 1975166960 19.426 100 43 86 0 2003945296 15808976 12969360
20:33:35 17212 8192000000 10918615536 11356594176 1984474096 19.500 100 38 77 0 2010556192 14210080 11872016
20:34:07 17337 8192000000 10928666880 11361439744 1992350848 19.562 100 58 114 3 2026725504 17230112 17144544
20:34:33 20046 8192000000 10932690944 11369074688 1993335184 19.570 100 54 108 1 2028155408 18852912 15967312
20:35:01 8866 8192000000 10940193808 11375591424 1995236496 19.585 100 44 86 4 2025862224 17514400 13111328
20:35:19 5806 8192000000 10950806592 11379781632 2003554432 19.651 100 56 112 2 2039000512 18785776 16660304
20:35:34 6648 8192000000 10968632384 11387719680 2011473472 19.713 100 66 133 0 2049961520 19514784 18973264
20:35:48 7161 8192000000 10948117856 11385937920 2012132288 19.718 100 55 110 1 2050040912 20182208 17726416
20:36:03 5344 8192000000 10962623632 11391180800 2014305600 19.735 100 56 113 0 2049821408 18368704 17147104
20:36:20 3089 8192000000 10967006992 11390373888 2011637488 19.714 100 64 121 2 2049727840 19388896 18701456
20:36:32 6334 8192000000 10964518528 11394961408 2015571168 19.745 100 60 120 1 2054947440 21164448 18211824
20:36:46 13428 8192000000 10952840928 11382452224 1997938592 19.606 100 62 124 3 2038803264 21991280 18873392
20:37:07 8643 8192000000 10954539792 11392233472 2009936368 19.701 100 49 98 1 2047782208 22821008 15024832
20:37:34 9420 8192000000 10948535824 11380576256 1969941968 19.385 98 49 95 1 2009650272 24591136 15117168
20:37:52 11162 8192000000 10974688624 11405414400 2012147984 19.718 100 57 108 0 2058095024 29170688 16776352
20:38:16 3189 8192000000 10970114144 11394736128 1996031312 19.591 99 55 108 1 2038549088 26040800 16476976
20:38:26 2939 8192000000 10985263152 11408932864 2019096096 19.773 100 73 146 1 2070211856 28184032 22931728
20:38:37 7036 8192000000 10997425216 11419848704 2026965040 19.835 100 77 151 2 2080500864 30581056 22954768
20:39:00 16075 8192000000 10982720400 11410944000 2006692944 19.675 99 63 125 1 2056663280 31170496 18799840
20:39:29 8791 8192000000 10993962896 11424452608 2025667888 19.825 100 56 111 0 2077555504 34164384 17723232
20:39:45 5917 8192000000 10995420064 11430850560 2031487232 19.870 100 65 130 2 2089111536 37634848 19989456
20:40:05 6191 8192000000 11006127376 11438940160 2033789024 19.888 100 65 130 2 2091480976 37689824 20002128
20:40:22 4095 8192000000 10988213344 11424505856 2011237152 19.711 99 60 119 2 2064695024 35529152 17928720
20:40:32 1954 8192000000 11000110560 11417645056 2017618592 19.761 100 84 168 1 2080719808 36521072 26580144
20:40:41 5261 8192000000 10991364736 11414364160 1998235344 19.609 99 75 150 1 2059136352 37543808 23357200
20:40:54 3656 8192000000 10995315200 11408084992 2007694304 19.683 99 83 165 2 2073548288 40853264 25000720
20:41:05 2202 8192000000 11014799744 11432456192 2026536896 19.831 100 83 166 2 2093191184 40622848 26031440
20:41:15 3205 8192000000 11003429328 11419492352 2017065440 19.757 100 87 172 0 2085205216 41251072 26888704
20:41:25 3569 8192000000 11003875760 11421675520 2018093232 19.765 100 86 172 2 2086915008 42350480 26471296
20:41:36 3687 8192000000 11008997360 11423600640 2002708704 19.644 99 82 165 0 2070722480 42277072 25736704
20:41:47 2721 8192000000 10976321984 11396956160 1994151792 19.577 99 78 155 1 2059701216 40997376 24552048
20:41:56 5445 8192000000 11006205936 11426660352 2020598960 19.785 100 76 152 2 2086852144 42135968 24117216
20:42:09 3460 8192000000 10976466656 11400486912 1974787552 19.423 98 81 160 2 2041961728 42826848 24347328
20:42:23 2698 8192000000 11004198320 11420602368 2010261232 19.704 100 86 172 0 2084591920 47331536 26999152
20:42:33 2645 8192000000 10993748096 11413893120 1992036992 19.560 99 77 155 0 2065779504 48790464 24952048
20:42:43 6436 8192000000 10979159680 11401699328 1992969824 19.567 100 71 141 1 2065313616 49669888 22673904
20:43:00 1939 8192000000 10976765152 11404607488 1982776848 19.487 99 72 143 1 2057916880 51452144 23687888
20:43:11 4658 8192000000 10975771056 11395862528 1963324976 19.332 98 64 128 0 2033808592 49040416 21443200
20:43:24 2890 8192000000 10964265104 11385982976 1959898576 19.305 99 66 131 2 2031555856 50135024 21522256
20:43:39 4656 8192000000 10967725152 11385626624 1975768256 19.431 100 68 138 2 2045828800 48799552 21260992
20:43:54 2886 8192000000 10978542400 11393249280 1974829888 19.424 99 77 153 0 2050835568 51353184 24652496
20:44:04 2426 8192000000 10987554720 11400712192 1984102000 19.497 100 81 162 1 2060368320 51237408 25028912
20:44:14 1808 8192000000 10986516624 11402977280 1987196768 19.522 100 78 153 1 2064412176 52588368 24627040
20:44:22 3798 8192000000 10977787280 11394752512 1977420672 19.444 100 79 158 0 2056853712 54423872 25009168
20:44:33 2147 8192000000 11000148944 11414044672 1994524608 19.580 100 84 168 2 2080501808 59861440 26115760
20:44:43 4085 8192000000 10975643424 11391664128 1978503232 19.453 100 79 159 3 2058142080 54061424 25577424
20:45:00 3000 8192000000 10958780352 11377717248 1961212752 19.316 99 78 156 2 2037807392 52546448 24048192
20:45:11 2744 8192000000 10984660112 11397038080 1981156560 19.474 100 70 140 1 2056200320 53104464 21939296
20:45:22 3795 8192000000 10975126784 11396800512 1985811696 19.511 100 78 157 1 2065489200 54588896 25088608
20:45:32 1253 8192000000 10988538800 11395952640 1969051664 19.378 99 93 185 0 2053040640 55805824 28183152
20:45:40 2476 8192000000 10988210880 11410030592 1990234352 19.546 100 83 166 0 2073073648 56683344 26155952
20:45:49 4117 8192000000 10973399376 11407736832 1987762736 19.526 100 57 114 0 2060067776 54029936 18275104
20:46:01 8965 8192000000 10947511952 11378606080 1954220784 19.260 98 49 98 2 2009696128 39624256 15851088
20:46:16 10786 8192000000 10956835456 11389132800 1978776320 19.455 100 47 94 0 2036050848 41897120 15377408
20:46:39 9987 8192000000 10943532528 11383349248 1975292912 19.427 100 49 97 1 2032903552 42597312 15013328
20:47:02 6308 8192000000 10915439536 11349884928 1930605136 19.072 98 48 96 1 1989638736 43861888 15171712
20:47:22 15094 8192000000 10929162304 11364732928 1951316976 19.237 100 40 80 2 2008643840 44031456 13295408
20:47:53 19554 8192000000 10914366992 11353665536 1935712848 19.113 99 36 73 4 1995875568 48042304 12120416
20:48:22 21719 8192000000 10938448416 11384250368 1961095728 19.315 100 33 66 1 2018720944 46296608 11328608
20:48:51 13229 8192000000 10939932336 11389177856 1972736608 19.407 100 34 68 2 2026284192 42320688 11226896
20:49:47 19556 8192000000 10934368672 11392602112 1951895200 19.242 99 31 62 1 2014276448 50115840 12265408
20:50:13 18847 8192000000 10926673088 11382231040 1943640144 19.176 99 30 60 1 2005771040 51635120 10495776
20:50:42 19018 8192000000 10923523040 11373170688 1937159248 19.124 99 31 62 0 2003828416 55374512 11294656
20:51:17 23950 8192000000 10933667216 11383545856 1946127456 19.196 100 28 56 1 2015574864 59315328 10132080
20:51:48 26625 8192000000 10920641952 11380342784 1915968304 18.955 98 31 62 5 1978965520 52270528 10726688
20:52:36 13135 8192000000 10893603408 11380236288 1939586368 19.143 100 14 28 0 1988845280 44141792 5117120
20:52:55 10288 8192000000 10886949632 11360559104 1936547232 19.119 100 10 20 0 1969261040 29161120 3552688
20:53:43 45109 8192000000 10885490896 11352596480 1940253008 19.149 100 10 20 1 1968231664 24099680 3878976
20:55:03 42108 8192000000 10862358352 11344801792 1903764096 18.857 98 25 48 0 1932326528 20775328 7787104
20:55:58 62960 8192000000 10862334848 11298451456 1806546224 18.068 93 18 36 1 1818283232 7028960 4708048
20:57:13 41754 8192000000 10883666448 11320684544 1905640080 18.872 98 52 107 2 1930356800 10439520 14277200
20:58:01 146533 8192000000 10866707872 11323490304 1850762672 18.428 95 29 57 0 1869214320 9727744 8723904
21:00:34 57370 8192000000 10908323648 11352657920 1957274928 19.284 100 42 81 3 1979783728 10885888 11622912
21:01:39 96019 8192000000 10910448544 11368861696 1956429904 19.278 99 45 89 0 1980757680 11987104 12340672
21:03:23 2512 8192000000 10926993808 11372806144 1980508592 19.469 100 52 102 1 2007631488 11839520 15283376
21:03:32 13674 8192000000 10919988304 11380391936 1982340720 19.483 100 29 58 2 2003182544 12297392 8544432
21:03:57 12838 8192000000 10907632672 11373506560 1961204064 19.316 99 13 26 1 1975252080 10430272 3617744
21:04:17 25660 8192000000 10907643504 11368329216 1959566576 19.303 99 22 44 1 1979428576 13582320 6279680
21:04:49 52010 8192000000 10904830800 11362508800 1939151568 19.140 98 34 65 0 1965546528 15957952 10437008
21:05:52 25959 8192000000 10919542416 11372130304 1980439696 19.468 100 55 106 1 2008978192 12643632 15894864
21:06:27 72883 8192000000 10896902816 11385688064 1954243296 19.260 99 28 56 0 1985856000 22678128 8934576
21:07:46 33491 8192000000 10896486576 11376263168 1967321504 19.364 100 7 14 1 1984768320 15238368 2208448
21:09:14 47234 8192000000 10901063712 11371356160 1954119360 19.259 99 14 28 0 1969843824 11539856 4184608
21:10:11 40354 8192000000 10891862016 11382501376 1970172960 19.387 100 9 18 1 1989976864 16958832 2845072
21:10:58 48281 8192000000 10886652112 11376959488 1970040064 19.386 100 8 17 1 1985584912 13227136 2317712
21:11:52 10817 8192000000 10878663328 11368476672 1961474192 19.318 100 3 6 1 1972678976 10681536 523248
21:12:09 52937 8192000000 10873396704 11343122432 1930284912 19.069 98 21 42 1 1944418912 8033728 6100272
21:13:12 50414 8192000000 10892670736 11357884416 1963591312 19.335 100 18 36 1 1978736640 9836672 5308656
21:14:13 58260 8192000000 10881158160 11364253696 1950254768 19.229 99 6 12 2 1959886048 8192304 1438976
21:15:18 30365 8192000000 10874820480 11355332608 1948111280 19.211 99 4 8 0 1957969104 8802480 1055344
21:16:11 53983 8192000000 10887562704 11367936000 1963471440 19.334 100 15 30 0 1977636688 9883728 4281520
21:17:23 22581 8192000000 10899696080 11370434560 1975899808 19.432 100 14 28 1 1986584256 6928944 3755504
21:17:59 38928 8192000000 10899362784 11375390720 1964387024 19.341 99 23 47 0 1978105696 7433968 6284704
21:18:45 45141 8192000000 10926052880 11389173760 1983020000 19.489 100 24 48 1 1997662896 8125600 6517296
21:19:41 40664 8192000000 10909952032 11379625984 1978708624 19.454 99 35 70 0 1999959232 11525904 9724704
21:20:38 38623 8192000000 10922309824 11395424256 1991044736 19.552 100 21 42 0 2009533024 12750528 5737760
21:21:58 14395 8192000000 10936456384 11396927488 2000027808 19.623 100 36 72 0 2019156624 9035024 10093792
21:22:21 33071 8192000000 10913622304 11380842496 1953278928 19.253 98 34 68 2 1977201456 14773632 9148896
21:23:01 75697 8192000000 10923788528 11386822656 1929500896 19.063 97 28 54 0 1955085328 18357696 7226736
21:24:58 56082 8192000000 10901194608 11353206784 1887624832 18.727 96 15 30 1 1903422624 11284576 4513216
21:26:00 42246 8192000000 10919561712 11376660480 1977114656 19.442 100 34 68 1 1997358128 10860560 9382912
21:26:55 63063 8192000000 10912122848 11389763584 1958576944 19.295 99 22 44 1 1988647760 24526896 5543920
21:28:04 119136 8192000000 10896670560 11355611136 1856092368 18.472 94 8 16 1 1877019760 19175376 1752016
21:30:42 80116 8192000000 10828001440 11266998272 1814779200 18.135 93 19 37 0 1832767776 12902688 5085888
21:32:09 32052 8192000000 10891649744 11330977792 1940996304 19.155 100 63 127 2 1968073456 9504880 17572272
21:32:47 57004 8192000000 10866048752 11348299776 1957150160 19.283 100 33 66 2 1977807872 10970560 9687152
21:33:51 56866 8192000000 10870585776 11344588800 1938340176 19.134 99 8 16 0 1951735392 10908896 2486320
21:34:56 62677 8192000000 10859799968 11337469952 1913967888 18.938 98 13 26 1 1929835712 12206720 3661104
21:36:05 13946 8192000000 10857680960 11338620928 1938404864 19.134 100 5 8 1 1951736064 12251888 1079312
21:36:27 29202 8192000000 10854536480 11343597568 1939518528 19.143 100 3 6 0 1952002560 11780976 703056
21:37:19 72001 8192000000 10857238752 11328012288 1868475312 18.572 96 15 30 0 1881484240 8388064 4620864
21:39:21 51031 8192000000 10872315088 11335802880 1927806608 19.049 100 25 50 1 1946743504 10977504 7959392
21:40:37 40004 8192000000 10834227888 11306831872 1852497808 18.442 96 24 48 1 1872552528 13053680 7001040
21:41:27 30640 8192000000 10849711904 11307335680 1881775888 18.679 98 16 33 0 1897262592 10990944 4495760
21:42:05 83158 8192000000 10852074800 11303194624 1796006320 17.981 93 26 50 2 1813802224 10510112 7285792
21:43:34 46534 8192000000 10845812176 11311247360 1862133456 18.521 97 37 74 0 1889323248 16675856 10513936
21:44:35 72667 8192000000 10853739584 11329851392 1908072384 18.891 100 19 38 0 1935852816 22003440 5776992
21:45:54 170555 8192000000 10868371424 11341004800 1878794768 18.655 97 13 26 0 1900103136 17744368 3564000
21:48:55 67213 8192000000 10891635360 11374546944 1929861376 19.066 99 29 58 2 1954979040 17057440 8060224
21:50:28 84382 8192000000 10899376944 11363631104 1915626112 18.952 98 14 28 1 1938896192 19689200 3580880
21:52:03 99280 8192000000 10852147776 11310039040 1875907264 18.632 96 30 60 1 1895241472 10402864 8931344
21:53:50 65264 8192000000 10863435600 11331670016 1923289168 19.013 99 29 58 2 1942460608 11279536 7891904
21:55:06 38929 8192000000 10839077680 11323703296 1911907440 18.922 99 27 54 0 1929712496 9895696 7909360
21:55:59 80247 8192000000 10852903440 11335364608 1938909024 19.138 100 10 20 0 1949470288 7622848 2938416
21:57:25 53946 8192000000 10876286784 11357401088 1952831680 19.249 100 13 26 1 1963487104 7078912 3576512
21:58:28 43052 8192000000 10865926688 11345842176 1924387568 19.022 98 5 10 0 1931703296 6411344 904384
21:59:30 39788 8192000000 10883861968 11363532800 1944075824 19.179 99 11 22 0 1952597248 5986736 2534688
22:00:16 49178 8192000000 10895702640 11372957696 1958652640 19.295 99 25 51 0 1973441248 7703360 7085248
22:01:16 41774 8192000000 10901823344 11370872832 1941534960 19.159 98 21 42 2 1955754800 8052496 6167344
22:02:09 58836 8192000000 10915232848 11389792256 1958532288 19.294 99 11 22 0 1972814400 11068016 3214096
22:03:20 76078 8192000000 10917439904 11386236928 1927310480 19.045 97 20 40 2 1946420352 13262848 5847024
22:04:57 69170 8192000000 10904852560 11369328640 1906627936 18.880 96 23 46 0 1925298880 12204064 6466880
22:06:17 56856 8192000000 10917363280 11393359872 1959289072 19.300 99 22 44 1 1976916624 11037376 6590176
22:07:31 95876 8192000000 10922250480 11393413120 1938112784 19.132 98 31 62 1 1959623408 12653712 8856912
22:09:14 46932 8192000000 10906724960 11386519552 1960816704 19.313 99 14 28 2 1981684192 16683456 4184032
22:10:07 69068 8192000000 10888658832 11357470720 1884223840 18.699 95 23 46 0 1904098880 13257808 6617232
22:11:27 55702 8192000000 10910014416 11381657600 1966899520 19.361 100 23 46 0 1988310080 14863968 6546592
22:12:32 124155 8192000000 10916670688 11415388160 1957587904 19.287 99 9 18 0 1988214144 28428464 2197776
22:15:05 91496 8192000000 10899970240 11380416512 1963485744 19.334 99 15 30 1 1981360544 13564624 4310176
22:16:43 23962 8192000000 10889442320 11378630656 1974094800 19.418 100 14 28 0 1989306160 11180880 4030480
22:17:14 13384 8192000000 10891469072 11364933632 1971271792 19.396 100 7 14 1 1984232112 11077248 1883072
22:17:35 74592 8192000000 10904657536 11387236352 1980039392 19.465 100 17 34 0 1993257904 8430512 4788000
22:18:55 83066 8192000000 10903056864 11377704960 1951127776 19.235 98 16 32 0 1967270560 11310736 4832048
22:20:41 64928 8192000000 10908334208 11385888768 1965449872 19.349 99 17 34 1 1986174848 15806272 4918704
22:21:56 82642 8192000000 10871578000 11359326208 1878567184 18.654 95 16 32 0 1895764752 12655456 4542112
22:23:37 122394 8192000000 10886762320 11353022464 1877113392 18.642 96 11 22 0 1890925168 10938176 2873600
22:25:46 50009 8192000000 10884669088 11352137728 1875708896 18.630 96 10 20 0 1887742304 9283024 2750384

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 23-01-2021 22:28:39 to 23-01-2021 22:29:10.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 160 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 23-01-2021 22:29:11 to 23-01-2021 22:29:13.

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          235240
MON$OLDEST_ACTIVE               236835
MON$OLDEST_SNAPSHOT             236835
MON$NEXT_TRANSACTION            236835
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                       2026976
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 ---
:328: 
:329: mscs-test-161.budzdorov.ru    Sat Jan 23 22:27:19 2021
:330:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:331: 
:332: 
:333: mscs-test-161.budzdorov.ru    Sat Jan 23 22:27:19 2021
:334:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:335: 
:336: 
:337: mscs-test-161.budzdorov.ru    Sat Jan 23 22:27:19 2021
:338:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:339: 
:340: 
:341: mscs-test-161.budzdorov.ru    Sat Jan 23 22:27:20 2021
:342:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:343: 
:344: 
:345: mscs-test-161.budzdorov.ru    Sat Jan 23 22:27:22 2021
:346:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:347: 
:348: 
:349: mscs-test-161.budzdorov.ru    Sat Jan 23 22:27:22 2021
:350:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:351: 
:352: 
:353: mscs-test-161.budzdorov.ru    Sat Jan 23 22:27:22 2021
:354:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:355: 
--- end of diff output ---

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

23.01.21 22:29:14. 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-23 22:29:16 No severe PSQL-related problems occured
23.01.21 22:29:17. End of report.