Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.12.2020 16:32
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 17655932 kB
MemAvailable 31423516 kB
Buffers 0 kB
Cached 14019028 kB
SwapCached 4820 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-28 16:31:52
DTS_END                         2020-12-28 16:31:52.2650
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/43050
TRN_ID                          229279
ATT_ID                          631
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: 8795.70 22311 1055484
customer order: creation 169.42 365 20330
customer order: refuse 14.37 350 1724
order to supplier: creation 44.98 1341 5397
order to supplier: removal 3.53 102209 424
invoice (draft): creation 44.37 3328 5324
invoice (draft): removal 47.39 895 5687
invoice accept: apply 41.08 20939 4930
invoice accept: cancel 42.96 924 5155
customer reserve: creation 3823.10 208 458772
customer reserve: removal 4281.36 67 513763
realization accept: apply 80.85 184 9702
realization accept: cancel 75.09 127 9011
payment from customer: creation 58.25 115 6990
payment from customer: removal 5.32 91 638
payment to supplier: creation 47.89 133 5747
payment to supplier: removal 3.57 85 428
service: total inventory turnovers 4.70 1059 564
service: total monetary turnovers 6.73 28 808
service: aggregate perf. data 0.72 22035 86
service: refresh index statistics 0.03 291737 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 28-12-2020 16:32:40 to 28-12-2020 16:32:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2486
TEST_TIME 2 4374
TEST_TIME 3 3858
TEST_TIME 4 4364
TEST_TIME 5 4408
TEST_TIME 6 4464
TEST_TIME 7 4459
TEST_TIME 8 4697
TEST_TIME 9 4663
TEST_TIME 10 4498
TEST_TIME 11 4797
TEST_TIME 12 4712
TEST_TIME 13 4897
TEST_TIME 14 5153
TEST_TIME 15 5410
TEST_TIME 16 5827
TEST_TIME 17 6343
TEST_TIME 18 6933
TEST_TIME 19 6976
TEST_TIME 20 7240
TEST_TIME 21 7542
TEST_TIME 22 7906
TEST_TIME 23 8041
TEST_TIME 24 8134
TEST_TIME 25 8229
TEST_TIME 26 8367
TEST_TIME 27 8348
TEST_TIME 28 8500
TEST_TIME 29 8572
TEST_TIME 30 9812
TEST_TIME 31 9858
TEST_TIME 32 9721
TEST_TIME 33 9533
TEST_TIME 34 9682
TEST_TIME 35 9721
TEST_TIME 36 9529
TEST_TIME 37 9492
TEST_TIME 38 9434
TEST_TIME 39 9336
TEST_TIME 40 9221
TEST_TIME 41 9235
TEST_TIME 42 9194
TEST_TIME 43 9087
TEST_TIME 44 9038
TEST_TIME 45 8900
TEST_TIME 46 8951
TEST_TIME 47 8928
TEST_TIME 48 8818
TEST_TIME 49 8735
TEST_TIME 50 8767
TEST_TIME 51 8817
TEST_TIME 52 8770
TEST_TIME 53 8721
TEST_TIME 54 8608
TEST_TIME 55 8530
TEST_TIME 56 8538
TEST_TIME 57 8588
TEST_TIME 58 8510
TEST_TIME 59 8426
TEST_TIME 60 8369
TEST_TIME 61 8381
TEST_TIME 62 8420
TEST_TIME 63 8475
TEST_TIME 64 8442
TEST_TIME 65 8596
TEST_TIME 66 8604
TEST_TIME 67 8684
TEST_TIME 68 8677
TEST_TIME 69 8671
TEST_TIME 70 8680
TEST_TIME 71 8734
TEST_TIME 72 8832
TEST_TIME 73 8830
TEST_TIME 74 8810
TEST_TIME 75 8884
TEST_TIME 76 8890
TEST_TIME 77 8793
TEST_TIME 78 8790
TEST_TIME 79 8762
TEST_TIME 80 8799
TEST_TIME 81 8758
TEST_TIME 82 8688
TEST_TIME 83 8683
TEST_TIME 84 8684
TEST_TIME 85 8628
TEST_TIME 86 8689
TEST_TIME 87 8723
TEST_TIME 88 8703
TEST_TIME 89 8706
TEST_TIME 90 8707
TEST_TIME 91 8721
TEST_TIME 92 8791
TEST_TIME 93 8774
TEST_TIME 94 8805
TEST_TIME 95 8777
TEST_TIME 96 8791
TEST_TIME 97 8768
TEST_TIME 98 8828
TEST_TIME 99 8806
TEST_TIME 100 8838
TEST_TIME 101 8813
TEST_TIME 102 8779
TEST_TIME 103 8760
TEST_TIME 104 8720
TEST_TIME 105 8704
TEST_TIME 106 8695
TEST_TIME 107 8655
TEST_TIME 108 8607
TEST_TIME 109 8622
TEST_TIME 110 8691
TEST_TIME 111 8679
TEST_TIME 112 8705
TEST_TIME 113 8670
TEST_TIME 114 8686
TEST_TIME 115 8699
TEST_TIME 116 8737
TEST_TIME 117 8746
TEST_TIME 118 8740
TEST_TIME 119 8769
TEST_TIME 120 8798

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-12-2020 16:32:44 to 28-12-2020 16:32:47.

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 1478810 1478810 0 0.00 0 33093 8 0 0
doc_list_biud 1478806 1478806 0 0.00 0 38290 29 0 0
sp_add_invoice_to_stock 5032 4930 102 2.02 37 181639 20939 0 102
sp_cancel_adding_invoice 5155 5155 0 0.00 5 72704 925 0 0
sp_cancel_client_order 1724 1724 0 0.00 3 11386 351 0 0
sp_cancel_customer_reserve 513763 513763 0 0.00 1 34866 67 0 0
sp_cancel_pay_from_customer 638 638 0 0.00 3 6801 91 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 2 5841 86 0 0
sp_cancel_supplier_invoice 5702 5687 15 0.26 1 16838 895 0 15
sp_cancel_supplier_order 424 424 0 0.00 8 1080894 102209 0 0
sp_cancel_write_off 9011 9011 0 0.00 1 12804 127 0 0
sp_client_order 20330 20330 0 0.00 3 61583 366 0 0
sp_customer_reserve 458772 458772 0 0.00 0 46063 208 0 0
sp_fill_shopping_cart 31042 31042 0 0.00 1 20854 40 0 0
sp_fill_shopping_cart_clo_res 458764 458764 0 0.00 0 21778 13 0 0
sp_get_clo_for_invoice 4920 4920 0 0.00 0 24335 280 0 0
sp_kill_cost_storno 15232 15232 0 0.00 0 8101 69 0 0
sp_kill_qstorno_ret_qs2qd 1042648 1042648 0 0.00 0 34803 36 0 0
sp_kill_qty_storno 550385 550385 0 0.00 0 38290 78 0 0
sp_lock_selected_doc 20332 20332 0 0.00 0 8331 5 0 0
sp_make_cost_storno 27359 27359 0 0.00 0 15359 54 0 0
sp_multiply_rows_for_pdistr 27358 27358 0 0.00 0 7422 27 0 0
sp_multiply_rows_for_qdistr 20330 20330 0 0.00 0 61573 156 0 0
sp_pay_from_customer 6990 6990 0 0.00 4 9772 115 0 0
sp_pay_to_supplier 5747 5747 0 0.00 5 17485 134 0 0
sp_payment_common 12736 12736 0 0.00 1 17273 28 0 0
sp_qd_handle_on_cancel_clo 1724 1724 0 0.00 0 11381 318 0 0
sp_qd_handle_on_invoice_upd_sts 10074 10074 0 0.00 0 38290 356 0 0
sp_qd_handle_on_reserve_upd_sts 9702 9702 0 0.00 0 15062 62 0 0
sp_reserve_write_off 9702 9702 0 0.00 6 15761 184 0 0
sp_supplier_invoice 5324 5324 0 0.00 6 78242 3329 0 0
sp_supplier_order 5397 5397 0 0.00 5 33195 1341 0 0
srv_aggregate_perf_data 86 86 0 0.00 2627 404382 22036 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1493 134540 32220 0 0
srv_find_qd_qs_mism 1007703 1007703 0 0.00 0 32204 7 0 0
srv_make_invnt_saldo 564 564 0 0.00 29 55129 1059 0 0
srv_make_money_saldo 808 808 0 0.00 0 4962 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 123870 378373 291738 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 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 4930 4930 0 0.00 0 15538 197 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 5258 136 0 0
t$perf-norm:sp_cancel_client_order 1724 1724 0 0.00 0 2066 15 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 617 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 638 638 0 0.00 0 726 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 800 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 409 409 0 0.00 0 2732 15 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 18962 1549 0 0
t$perf-norm:sp_cancel_write_off 990 990 0 0.00 0 3341 11 0 0
t$perf-norm:sp_client_order 20330 20330 0 0.00 0 16872 20 0 0
t$perf-norm:sp_customer_reserve 935 935 0 0.00 0 6377 12 0 0
t$perf-norm:sp_pay_from_customer 6990 6990 0 0.00 0 9279 12 0 0
t$perf-norm:sp_pay_to_supplier 5747 5747 0 0.00 0 6328 12 0 0
t$perf-norm:sp_reserve_write_off 9702 9702 0 0.00 0 5618 10 0 0
t$perf-norm:sp_supplier_invoice 5324 5324 0 0.00 0 5927 20 0 0
t$perf-norm:sp_supplier_order 5397 5397 0 0.00 0 5389 15 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 88 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 1595 15 0 0
t$perf-norm:srv_make_invnt_saldo 564 564 0 0.00 0 995 21 0 0
t$perf-norm:srv_make_money_saldo 808 808 0 0.00 0 1079 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10040 9836 204 2.03 0 6918 20 0 204
v_all_customers 37058 37058 0 0.00 0 157 1 0 0
v_all_suppliers 29852 29852 0 0.00 0 125 1 0 0
v_all_wares 40660 40660 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 5480 17 0 0
v_cancel_client_order 3448 3448 0 0.00 0 6727 8 0 0
v_cancel_customer_prepayment 1276 1276 0 0.00 0 2406 5 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 938 4 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 5835 13 0 0
v_cancel_supplier_invoice 848 818 30 3.53 0 3696 19 0 30
v_cancel_supplier_order 848 848 0 0.00 0 3492 9 0 0
v_cancel_write_off 1980 1980 0 0.00 0 5845 16 0 0
v_max_id_clo_ord 5396 5396 0 0.00 0 2144 2 0 0
v_max_id_clo_res 935 935 0 0.00 0 3212 15 0 0
v_max_id_ord_sup 5316 5316 0 0.00 0 10439 5 0 0
v_max_non_paid_invoice 1533 1533 0 0.00 0 352 2 0 0
v_max_non_paid_realizn 3718 3718 0 0.00 0 1823 3 0 0
v_min_id_clo_ord 5396 5396 0 0.00 0 2976 6 0 0
v_min_id_clo_res 935 935 0 0.00 0 7778 12 0 0
v_min_id_ord_sup 5316 5316 0 0.00 0 5486 8 0 0
v_min_non_paid_invoice 5747 5747 0 0.00 0 17271 18 0 0
v_min_non_paid_realizn 6989 6989 0 0.00 0 3618 14 0 0
v_our_firm 10144 10144 0 0.00 0 157 1 0 0
v_reserve_write_off 19404 19404 0 0.00 0 5889 7 0 0
x_lock_depdocs_on_canc_invoice 10433 10433 0 0.00 0 23427 144 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 18221 390 0 0
x_make_qstorno_1000_1200 5397 5397 0 0.00 1 33177 1263 0 0
x_make_qstorno_1200_2000 5324 5324 0 0.00 3 76854 3177 0 0
x_make_qstorno_2100_3300 458772 458772 0 0.00 0 46051 192 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-12-2020 16:32:48 to 28-12-2020 16:32:52.

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
14:01:56 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:02 16899 8192000000 10232263488 10534141952 754907568 8.437 61 45 95 0 771446064 1855648 14682848
14:02:29 32529 8192000000 10350288992 10667347968 1390940832 14.514 100 87 174 0 1422789776 4624160 27224784
14:03:10 35400 8192000000 10392056480 10713481216 1433741056 14.894 100 87 173 1 1468492288 6940224 27811008
14:04:05 14145 8192000000 10404617280 10731028480 1461254176 15.137 100 87 174 1 1497475552 8175856 28045520
14:04:28 23170 8192000000 10420497360 10748461056 1477877424 15.283 100 91 181 0 1515567776 8916336 28774016
14:05:02 29300 8192000000 10441494000 10774323200 1491253536 15.400 100 93 186 0 1530733600 9769392 29710672
14:05:42 24649 8192000000 10455669744 10791972864 1506974704 15.537 100 90 180 0 1545448592 10264288 28209600
14:06:14 18658 8192000000 10474960624 10815365120 1523768672 15.683 100 76 152 0 1558083024 10261072 24053280
14:06:42 17311 8192000000 10490716640 10841030656 1551055296 15.919 100 82 164 2 1587199840 10622816 25521728
14:07:07 14213 8192000000 10510155216 10858958848 1574532624 16.121 100 81 162 1 1609872256 10687456 24652176
14:07:31 16307 8192000000 10536738128 10892673024 1599789184 16.338 100 78 156 0 1634206336 10936416 23480736
14:07:57 14546 8192000000 10557828368 10911969280 1613147936 16.452 100 78 156 3 1648224256 11427648 23648672
14:08:20 11615 8192000000 10572998720 10932969472 1625622384 16.558 100 76 152 0 1660448368 11501856 23324128
14:08:41 7720 8192000000 10577682368 10947485696 1645122848 16.723 100 72 144 0 1678021088 11997008 20901232
14:08:58 9412 8192000000 10600349104 10974343168 1659509488 16.845 100 64 128 2 1689550048 10967328 19073232
14:09:16 9290 8192000000 10626652576 10998685696 1690173328 17.103 100 74 148 0 1724189440 12015248 22000864
14:09:34 8795 8192000000 10649650960 11024326656 1710172192 17.270 100 73 142 1 1743645008 12126048 21346768
14:09:51 6812 8192000000 10661933008 11037487104 1724417216 17.389 100 68 136 1 1754550992 10810576 19323200
14:10:05 8165 8192000000 10674561408 11058143232 1746568704 17.573 100 69 138 3 1777284448 11084704 19631040
14:10:20 6380 8192000000 10695589168 11073400832 1754554256 17.639 100 78 155 0 1788158096 12163840 21440000
14:10:35 6605 8192000000 10700057904 11080941568 1766095920 17.735 100 77 154 1 1800925088 12498528 22330640
14:10:51 7043 8192000000 10711609744 11092078592 1777593504 17.830 100 75 148 1 1810647024 12452032 20601488
14:11:05 4257 8192000000 10738058688 11116449792 1794487504 17.969 100 89 178 0 1832796608 13657024 24652080
14:11:17 7362 8192000000 10732802512 11116335104 1792010080 17.948 100 80 160 2 1828212816 14252752 21949984
14:11:33 5906 8192000000 10730105904 11112992768 1795980464 17.981 100 78 157 1 1831190992 14399984 20810544
14:11:47 3014 8192000000 10750141376 11135397888 1817756448 18.159 100 88 174 1 1856525008 14437248 24331312
14:11:58 3541 8192000000 10761576416 11142799360 1818172944 18.163 100 90 180 3 1859555760 16265552 25117264
14:12:08 2716 8192000000 10759207680 11145433088 1821740416 18.192 100 89 178 1 1862036080 15687120 24608544
14:12:18 3379 8192000000 10763066496 11150106624 1823153760 18.203 100 87 174 1 1861841520 14063328 24624432
14:12:28 3419 8192000000 10767733968 11154812928 1828630512 18.248 100 91 180 3 1867807520 13922288 25254720
14:12:38 3512 8192000000 10775408944 11161538560 1830657792 18.265 100 92 184 0 1870227072 12646848 26922432
14:12:47 3546 8192000000 10782133936 11166404608 1839753504 18.339 100 88 176 2 1878041520 13564384 24723632
14:12:58 3219 8192000000 10786275088 11170660352 1842639200 18.362 100 87 174 0 1880609488 13448272 24522016
14:13:08 2592 8192000000 10786010000 11169767424 1843814624 18.372 100 94 186 0 1882297792 12053184 26429984
14:13:17 3171 8192000000 10788296144 11179425792 1842893312 18.364 100 81 162 1 1879461856 13255040 23313504
14:13:27 2012 8192000000 10794174624 11178319872 1848044512 18.406 100 94 186 1 1886534224 12729552 25760160
14:13:36 3757 8192000000 10800594176 11185180672 1851781568 18.437 100 93 186 2 1892311856 14419184 26111104
14:13:46 2561 8192000000 10797668416 11183661056 1853127328 18.448 100 93 187 0 1893040672 13551440 26361904
14:13:56 1547 8192000000 10809982768 11195826176 1857468448 18.483 100 96 192 0 1898581328 13962016 27150864
14:14:04 2153 8192000000 10804020352 11193683968 1861893712 18.519 100 89 176 3 1899054512 12887072 24273728
14:14:12 1541 8192000000 10805996784 11193344000 1861479104 18.515 100 89 178 1 1900701024 13434016 25787904
14:14:21 2728 8192000000 10808675520 11199340544 1862907536 18.527 100 89 178 2 1901822144 13766784 25147824
14:14:30 1039 8192000000 10812066144 11199000576 1864366752 18.539 100 97 196 1 1906474816 14949536 27158528
14:14:39 8835 8192000000 10804062880 11198517248 1865632544 18.549 100 83 166 1 1903457744 14822816 23002384
14:14:55 1642 8192000000 10803640432 11197755392 1867427264 18.563 100 81 161 1 1903004384 12395104 23182016
14:15:03 32725 8192000000 10804214224 11199750144 1865529776 18.548 100 67 134 0 1894622320 10182432 18910112
14:15:41 10663 8192000000 10784719872 11201044480 1868098384 18.569 100 71 142 3 1899230800 10612096 20520320
14:16:00 8106 8192000000 10772395456 11198537728 1865562704 18.548 100 37 74 1 1882914944 6885376 10466864
14:16:17 12662 8192000000 10785852544 11195707392 1865707824 18.550 100 37 74 0 1883172032 6544016 10920192
14:16:36 7951 8192000000 10773745312 11198521344 1861696000 18.517 100 16 32 1 1871721984 5752608 4273376
14:16:51 9137 8192000000 10763511952 11196555264 1865065888 18.544 100 15 30 0 1874468432 5456752 3945792
14:17:10 3301 8192000000 10775400048 11202572288 1870345888 18.587 100 38 76 1 1888473936 7117360 11010688
14:17:22 4314 8192000000 10784275376 11209670656 1868321920 18.571 100 28 56 1 1882597344 6121360 8154064
14:17:33 7391 8192000000 10779893152 11205074944 1868692384 18.574 100 26 52 0 1883535536 6566160 8276992
14:17:46 7616 8192000000 10781818192 11205881856 1866953360 18.560 100 19 38 2 1877721600 5547248 5220992
14:18:01 12750 8192000000 10775216688 11204886528 1869769840 18.582 100 19 38 1 1880516704 5391856 5355008
14:18:22 6254 8192000000 10777483440 11214938112 1880164800 18.666 100 32 61 0 1899539488 10648592 8726096
14:18:34 7785 8192000000 10776253152 11211800576 1876785776 18.639 100 20 40 1 1887797952 5527728 5484448
14:18:49 12093 8192000000 10783524128 11215622144 1878028640 18.649 100 20 40 1 1889661152 6369472 5263040
14:19:07 12317 8192000000 10781413248 11213873152 1879398896 18.660 100 15 30 1 1889105120 5618048 4088176
14:19:26 10164 8192000000 10775940176 11216941056 1880057104 18.666 100 14 27 0 1889853072 6071040 3724928
14:19:43 15917 8192000000 10819073952 11226238976 1885700848 18.711 100 24 48 3 1897991568 5455168 6835552
14:20:05 14343 8192000000 10812657232 11241852928 1891565824 18.758 100 24 48 1 1909442368 10250688 7625856
14:20:28 87955 8192000000 10806902512 11244572672 1896101904 18.795 100 29 56 1 1909757568 5362176 8293488
14:22:02 7959 8192000000 10815019040 11249188864 1903466240 18.854 100 39 78 0 1922146640 7957632 10722768
14:22:16 5212 8192000000 10817563104 11248754688 1899035520 18.819 100 26 52 3 1913364976 7023504 7305952
14:22:28 5567 8192000000 10797608096 11234689024 1875971280 18.633 99 30 60 0 1890725344 6375312 8378752
14:22:41 6359 8192000000 10792317840 11229126656 1888317056 18.732 100 21 42 1 1898828064 4773824 5737184
14:22:54 7317 8192000000 10806242000 11232161792 1884600944 18.702 100 34 68 4 1901194256 6447328 10145984
14:23:09 3679 8192000000 10796203648 11227758592 1877982832 18.649 100 22 44 2 1889794288 5802160 6009296
14:23:21 5299 8192000000 10806820096 11231715328 1879152656 18.658 100 19 38 2 1890293232 5009552 6131024
14:23:33 9118 8192000000 10755377200 11187589120 1800468848 18.018 96 18 36 0 1811170256 5396320 5305088
14:23:48 5235 8192000000 10772716928 11195580416 1854609312 18.460 100 40 81 4 1872353424 5533424 12210688
14:24:02 8401 8192000000 10766333312 11203371008 1842790720 18.364 99 20 37 2 1858673728 9522768 6360240
14:24:16 8254 8192000000 10765114496 11199897600 1837896096 18.324 99 18 36 2 1848331456 5563808 4871552
14:24:30 13094 8192000000 10748286096 11163697152 1784873696 17.890 97 15 30 2 1794575904 5515808 4186400
14:24:52 8169 8192000000 10719669280 11144687616 1752703248 17.624 96 24 49 0 1764653680 5463056 6487376
14:25:07 5959 8192000000 10695042768 11109376000 1709928096 17.268 95 17 34 0 1720158672 5499040 4731536
14:25:22 49399 8192000000 10709075664 11102691328 1684361024 17.054 93 22 43 1 1695828208 4552304 6914880
14:26:19 16313 8192000000 10729110768 11109892096 1783286048 17.877 99 78 159 2 1812175136 5189376 23699712
14:26:41 9115 8192000000 10647678880 11064029184 1674267664 16.969 94 18 36 0 1685423856 6463872 4692320
14:26:57 15118 8192000000 10672695328 11079938048 1590456688 16.258 89 22 44 1 1602029744 5341136 6231920
14:27:18 5469 8192000000 10694078624 11109367808 1777100464 17.826 100 37 74 0 1795833840 8455520 10277856
14:27:33 6001 8192000000 10704467216 11115565056 1759563440 17.681 98 39 76 4 1776569536 5632176 11373920
14:27:45 7860 8192000000 10681892224 11101798400 1743024944 17.544 98 15 31 0 1753344720 5372640 4947136
14:28:00 9372 8192000000 10713689600 11129278464 1793348848 17.959 100 39 78 2 1811170528 6801776 11019904
14:28:18 6844 8192000000 10699730416 11124613120 1750245024 17.604 97 26 52 1 1764341760 5826944 8269792
14:28:33 6343 8192000000 10726210240 11138129920 1803023056 18.039 100 21 42 1 1814934272 5288544 6622672
14:28:46 8036 8192000000 10725587728 11149012992 1816343168 18.148 100 23 46 1 1829053920 5915888 6794864
14:29:01 4924 8192000000 10748322384 11171106816 1830115440 18.260 100 26 52 0 1847278336 9232384 7930512
14:29:17 8377 8192000000 10766074656 11183206400 1839053296 18.333 100 25 50 1 1851973840 5965216 6955328
14:29:32 7209 8192000000 10765019216 11184914432 1844378240 18.376 100 19 38 2 1855453600 5418224 5657136
14:29:49 11605 8192000000 10772522496 11192971264 1850115776 18.423 100 24 45 3 1863096928 5314560 7666592
14:30:12 9431 8192000000 10769277792 11193634816 1859054352 18.496 100 34 68 1 1875732304 6145568 10532384
14:30:31 62170 8192000000 10782256288 11209142272 1867706320 18.566 100 26 52 1 1880120400 5619488 6794592
14:31:41 10804 8192000000 10791144096 11216441344 1877677072 18.646 100 25 50 0 1890021440 5572368 6772000
14:32:00 52458 8192000000 10828933648 11251486720 1897098896 18.803 100 45 88 1 1917013184 7192128 12722160
14:33:01 4219 8192000000 10848524848 11259523072 1908759456 18.897 100 56 112 2 1935402016 8820272 17822288
14:33:13 17720 8192000000 10851179824 11269177344 1915967984 18.955 100 52 106 0 1940802848 10094240 14740624
14:33:39 8399 8192000000 10859174672 11271856128 1926160032 19.036 100 64 129 2 1956207920 11117536 18930352
14:33:54 76032 8192000000 10865411712 11295649792 1926641168 19.040 100 47 94 0 1950511664 10686320 13184176
14:35:20 17175 8192000000 10871186352 11302940672 1938483360 19.135 100 48 96 2 1966410192 14136016 13790816
14:35:49 5961 8192000000 10882756560 11307585536 1943913280 19.178 100 52 104 1 1972716400 13144896 15658224
14:36:08 11909 8192000000 10880860960 11307773952 1950617408 19.231 100 53 106 1 1978681504 12579856 15484240
14:36:34 11802 8192000000 10884656608 11318886400 1954679056 19.264 100 42 84 1 1982573920 15605904 12288960
14:36:57 10529 8192000000 10900460928 11324592128 1958342368 19.293 100 37 74 0 1983032624 13504368 11185888
14:37:20 17650 8192000000 10905875616 11337101312 1968476896 19.373 100 44 88 1 2000239984 18749392 13013696
14:37:47 14292 8192000000 10912750144 11340124160 1969884736 19.385 100 49 96 0 1998561168 14333984 14342448
14:38:09 43957 8192000000 10905162496 11344191488 1969163680 19.379 100 33 66 2 1994966512 15487184 10315648
14:39:16 21520 8192000000 10911079440 11349028864 1974012384 19.417 100 33 66 2 2003296032 18497536 10786112
14:39:45 18057 8192000000 10912595952 11350839296 1976943232 19.440 100 35 70 1 2004627024 16288352 11395440
14:40:18 14040 8192000000 10919078528 11351474176 1963108560 19.331 99 43 86 1 1995307344 18769712 13429072
14:40:40 21961 8192000000 10927440624 11366191104 1980689760 19.470 100 45 89 2 2017327040 23593488 13043792
14:41:09 13505 8192000000 10939248080 11371065344 1987517536 19.524 100 44 88 0 2020977536 20089568 13370432
14:41:32 9391 8192000000 10943315888 11373965312 1991762464 19.558 100 51 102 2 2029437008 21854784 15819760
14:41:51 9256 8192000000 10942140128 11374292992 1993040832 19.568 100 55 109 0 2032439168 22780960 16617376
14:42:10 13319 8192000000 10945178992 11380056064 1998428480 19.610 100 53 107 0 2035093072 20285408 16379184
14:42:33 3237 8192000000 10950783456 11380826112 2001417216 19.634 100 59 118 1 2040851600 21628672 17805712
14:42:43 5242 8192000000 10956017728 11385630720 2004033136 19.655 100 54 108 1 2042725088 21834000 16857952
14:43:00 55327 8192000000 10959395280 11399245824 2005661424 19.667 100 45 90 2 2043520800 23917408 13941968
14:44:11 17129 8192000000 10964334672 11406794752 2013361776 19.728 100 50 100 0 2055358832 26049392 15947664
14:44:36 11845 8192000000 10979687520 11415240704 2015474448 19.745 100 56 112 0 2065117824 31791264 17852112
14:45:14 17412 8192000000 10968861360 11411603456 2020106256 19.781 100 53 104 0 2064084592 26912288 17066048
14:45:42 22532 8192000000 10965535792 11412709376 2013178880 19.727 100 43 86 1 2057700896 29396816 15125200
14:46:16 12438 8192000000 10980908112 11421233152 2018348384 19.767 100 45 90 2 2064304432 31392112 14563936
14:46:39 4572 8192000000 10988167408 11427024896 2024351232 19.814 100 51 100 2 2071966720 30977776 16637712
14:46:50 5462 8192000000 10997880592 11435806720 2032431904 19.878 100 66 130 2 2085502256 32048352 21022000
14:47:04 7174 8192000000 11006730528 11440222208 2038793376 19.928 100 63 126 0 2090342080 32332608 19216096
14:47:21 3521 8192000000 11013352224 11440078848 2036927264 19.913 100 82 162 0 2094499584 32528336 25043984
14:47:31 3360 8192000000 11007489328 11438227456 2034500976 19.894 100 88 174 2 2096231984 34163504 27567504
14:47:41 7200 8192000000 11002569776 11433066496 2033442848 19.886 100 77 152 0 2086899760 30823168 22633744
14:48:05 3371 8192000000 10998073328 11433701376 2028384224 19.846 100 73 146 1 2084948528 33736112 22828192
14:48:16 3829 8192000000 11008389232 11437174784 2033991152 19.890 100 77 154 2 2088660192 30693120 23975920
14:48:26 2928 8192000000 11010973808 11441315840 2036524832 19.910 100 75 150 1 2091370672 31720976 23124864
14:48:38 2853 8192000000 10986851808 11421442048 2017863728 19.763 99 69 137 0 2069440048 30754656 20821664
14:48:54 3536 8192000000 11012169440 11436908544 2036363200 19.908 100 79 155 1 2089019312 30548992 22107120
14:49:05 2867 8192000000 11026952448 11449278464 2043964224 19.968 100 82 164 3 2103140048 34498384 24677440
14:49:16 2455 8192000000 11013332224 11442925568 2027234640 19.837 99 82 163 2 2087144784 35486976 24423168
14:49:25 1842 8192000000 11012734480 11440377856 2020094864 19.781 99 84 167 2 2076264000 31538800 24630336
14:49:35 2210 8192000000 11017020800 11439816704 2037338672 19.916 100 90 181 2 2095850592 31999920 26512000
14:49:44 3726 8192000000 11004342960 11441037312 2036940240 19.913 100 76 152 4 2088111696 29672176 21499280
14:49:58 7880 8192000000 11000597296 11432599552 2015573456 19.745 99 68 136 1 2066530144 30256704 20699984
14:50:16 4661 8192000000 11013448192 11441852416 2036804720 19.912 100 85 169 0 2097059232 34728720 25525792
14:50:29 1982 8192000000 10997791648 11423580160 2018485504 19.768 100 85 171 2 2080390928 36180704 25724720
14:50:39 3902 8192000000 11022226848 11444310016 2030833696 19.865 100 86 172 1 2094118368 37408304 25876368
14:50:52 1658 8192000000 11013043024 11430715392 2022702928 19.801 100 87 171 0 2085665568 37415344 25547296
14:51:00 3365 8192000000 11007757168 11440488448 2011478032 19.713 99 80 160 1 2073324368 37484768 24361568
14:51:16 5695 8192000000 11000394944 11435200512 2021487504 19.792 100 64 128 1 2080358448 38335248 20535696
14:51:33 2311 8192000000 11011265216 11439427584 2030056416 19.859 100 83 166 0 2095009248 39105168 25847664
14:51:43 7955 8192000000 10998512016 11429232640 2021380016 19.791 100 65 130 1 2077898448 36597552 19920880
14:52:00 3263 8192000000 11000885632 11427758080 2020766976 19.786 100 85 167 4 2083996976 37723728 25506272
14:52:11 3159 8192000000 11004647952 11427995648 2017895776 19.764 100 84 167 1 2083615184 40495952 25223456
14:52:26 3923 8192000000 10986761440 11414179840 2004263440 19.656 100 68 136 0 2068855264 43101216 21490608
14:52:41 8065 8192000000 10987421264 11423428608 2009596304 19.698 100 63 126 1 2072430064 43035792 19797968
14:52:56 4764 8192000000 10964551360 11393949696 1982130384 19.482 99 73 144 1 2045163984 39574128 23459472
14:53:08 6435 8192000000 10985701984 11416092672 2009338016 19.696 100 70 138 2 2067317920 36666608 21313296
14:53:27 4196 8192000000 11005931696 11428052992 2004004464 19.654 99 92 185 2 2071011152 38413040 28593648
14:53:38 9260 8192000000 10992603424 11423956992 2010362864 19.704 100 69 138 1 2066976672 34964992 21648816
14:53:54 3175 8192000000 10997241296 11426070528 2021661264 19.793 100 84 166 2 2083432928 36488960 25282704
14:54:04 2052 8192000000 11010141200 11432988672 2026289184 19.830 100 66 131 1 2078813936 32256800 20267952
14:54:13 7409 8192000000 11003390240 11443068928 2032698752 19.880 100 54 108 1 2083894320 33993584 17201984
14:54:30 7112 8192000000 10981695856 11427381248 2016727040 19.754 100 52 104 1 2069887408 36502016 16658352
14:54:55 11152 8192000000 10985248400 11428487168 2018070928 19.765 100 52 104 2 2069933904 35823776 16039200
14:55:14 12068 8192000000 10966601584 11411308544 1989954288 19.543 99 46 92 2 2042397936 37926528 14517120
14:55:33 10986 8192000000 10970421856 11416604672 2004360208 19.657 100 41 81 0 2055561712 38200384 13001120
14:55:50 4056 8192000000 10975305632 11409158144 2004582352 19.659 100 64 128 0 2059137344 34216944 20338048
14:56:02 4616 8192000000 10992246976 11423506432 2014651872 19.738 100 73 140 2 2070190272 34793456 20744944
14:56:13 6292 8192000000 10983660048 11411468288 2004683232 19.660 100 58 116 0 2058983440 35792912 18507296
14:56:26 8372 8192000000 10966214544 11415126016 2004392624 19.657 100 44 88 0 2055010208 36523024 14094560
14:56:57 11937 8192000000 10936821760 11388190720 1965759200 19.352 99 28 56 4 2011661616 35948224 9954192
14:57:15 10628 8192000000 10954687424 11397545984 1984687312 19.502 100 40 80 2 2033104896 35301568 13116016
14:57:33 23028 8192000000 10924696496 11387265024 1949145616 19.220 98 26 52 2 1994099936 36014992 8939328
14:58:09 14993 8192000000 10934770096 11378302976 1952244960 19.244 99 30 60 1 2005421616 42094112 11082544
14:58:31 24405 8192000000 10921923584 11373953024 1923361568 19.014 98 26 52 1 1973439088 41035616 9041904
14:59:23 15339 8192000000 10907245488 11359932416 1944327744 19.181 100 21 42 3 1993129136 41088016 7713376
15:00:17 32843 8192000000 10906686544 11366699008 1897189248 18.804 97 28 56 2 1952674800 45583712 9901840
15:01:03 8196 8192000000 10964771088 11400298496 1971241792 19.395 100 74 146 2 2044445536 50019008 23184736
15:01:18 7719 8192000000 10929787232 11372781568 1956265744 19.276 100 42 82 2 2016854864 47269680 13319440
15:01:38 22098 8192000000 10879193296 11355893760 1928909712 19.058 99 17 34 1 1969345040 34814704 5620624
15:02:16 86581 8192000000 10886560944 11351621632 1901576416 18.839 97 41 85 2 1924040656 9987232 12477008
15:03:52 48438 8192000000 10801017600 11252555776 1848348736 18.409 95 23 46 0 1866975696 11644464 6982496
15:04:47 15346 8192000000 10847582656 11298144256 1894736224 18.784 99 32 64 1 1918236208 14146480 9353504
15:05:16 46356 8192000000 10830800816 11292905472 1857870928 18.486 97 23 46 0 1883227680 18909648 6447104
15:06:08 20996 8192000000 10835769600 11298516992 1908865280 18.898 100 18 36 1 1924587184 10877872 4844032
15:07:41 65227 8192000000 10861103328 11301273600 1885733136 18.711 98 20 42 1 1902059328 10178240 6147952
15:09:01 56508 8192000000 10853703616 11294199808 1887022752 18.722 98 36 73 1 1903811200 6949888 9838560
15:10:25 56924 8192000000 10830367296 11276021760 1865411984 18.547 97 33 66 2 1887920912 13187136 9321792
15:11:40 134540 8192000000 10852836272 11315511296 1881956688 18.681 98 14 28 0 1898681072 13028656 3695728
15:14:12 81375 8192000000 10852711856 11312128000 1908861904 18.898 99 22 44 0 1923416992 7549616 7005472
15:15:48 51297 8192000000 10878320704 11318161408 1904838080 18.865 98 33 66 0 1921950112 7358688 9753344
15:16:57 60304 8192000000 10857303616 11312140288 1932838912 19.090 100 24 48 1 1950439408 10876832 6723664
15:18:14 92003 8192000000 10877753680 11330285568 1941926688 19.162 100 28 56 0 1962017504 12055776 8035040
15:19:53 82882 8192000000 10893040752 11356389376 1955502368 19.270 100 15 30 1 1971494336 11472624 4519344
15:21:25 64401 8192000000 10866764608 11334524928 1927034432 19.043 98 36 68 1 1948347680 11352608 9960640
15:22:42 48403 8192000000 10873765952 11354091520 1954532368 19.263 100 9 18 0 1972799616 15514864 2752384
15:23:37 60679 8192000000 10871650672 11342200832 1938904608 19.138 99 13 26 1 1952840608 10060864 3875136
15:24:46 87478 8192000000 10896553552 11353227264 1956354864 19.277 100 20 40 1 1972733280 9662416 6716000
15:26:56 88258 8192000000 10883468048 11358912512 1967852784 19.368 100 18 36 0 1990006592 16955472 5198336
15:28:33 1492 8192000000 10915232608 11371274240 1978722592 19.455 100 47 94 2 2003432544 11778304 12931648
15:28:47 31473 8192000000 10879119600 11358556160 1969873792 19.384 100 14 29 2 1980835856 7063552 3898512
15:29:27 80414 8192000000 10903876112 11375144960 1980290528 19.467 100 20 40 1 1995003664 8620416 6092720
15:32:40 55264 8192000000 10885436640 11361656832 1951413984 19.238 99 8 16 0 1969614816 16132368 2068464
15:34:06 9839 8192000000 10881488816 11343921152 1944723616 19.184 98 32 64 4 1961620256 8019856 8876784
15:34:23 47214 8192000000 10906190928 11375435776 1941505280 19.159 98 20 40 1 1959585056 12499872 5579904
15:35:18 50818 8192000000 10911261008 11386130432 1984208272 19.498 100 22 44 0 2005734992 15125824 6400896
15:36:15 65330 8192000000 10887737472 11363700736 1949036448 19.219 98 14 28 0 1965382288 12214672 4131168
15:37:27 21357 8192000000 10904226144 11363885056 1955636656 19.271 99 20 40 0 1968022752 6470720 5915376
15:38:03 33205 8192000000 10898150784 11361189888 1935751984 19.113 98 29 58 3 1956552560 12666192 8134384
15:39:10 50154 8192000000 10912928224 11353337856 1939712272 19.144 98 31 62 1 1959076432 10834464 8529696
15:40:10 18865 8192000000 10908035040 11356246016 1947431568 19.206 99 44 88 0 1971644880 11887104 12326208
15:40:40 31051 8192000000 10918417696 11370418176 1976502048 19.437 100 42 84 1 2000369856 11834800 12033008
15:41:23 61039 8192000000 10866696032 11328290816 1873620400 18.614 95 19 38 3 1893407664 14518640 5268624
15:42:31 36116 8192000000 10886070896 11341766656 1930785200 19.073 99 27 54 2 1955494528 16466928 8242400
15:43:21 66184 8192000000 10883766544 11347693568 1868205712 18.570 95 17 34 0 1889328496 16204688 4918096
15:44:37 45020 8192000000 10880652640 11316379648 1847647840 18.403 95 36 73 0 1868560512 10498560 10414112
15:45:32 24912 8192000000 10899381504 11342110720 1933938592 19.098 99 58 117 2 1962666736 12502592 16225552
15:46:09 38316 8192000000 10848981712 11314135040 1884955152 18.705 97 23 46 0 1904435200 13132576 6347472
15:47:02 128011 8192000000 10887188240 11342057472 1944952048 19.186 100 19 38 0 1961795952 11400192 5443712
15:49:43 67326 8192000000 10902661920 11351109632 1913691424 18.936 97 40 80 3 1935232416 10490960 11050032
15:51:04 31760 8192000000 10890166480 11358457856 1961946624 19.322 100 39 78 1 1992483552 19789520 10747408
15:51:48 53327 8192000000 10897612176 11372883968 1972458832 19.405 100 22 44 1 1995780128 16758192 6563104
15:54:10 76444 8192000000 10875322000 11339325440 1920522208 18.991 98 17 34 0 1946050320 19927056 5601056
15:55:33 70432 8192000000 10876210592 11348152320 1939566720 19.143 99 13 25 1 1956082704 12112752 4403232
15:57:57 43136 8192000000 10876291088 11344523264 1928623152 19.056 98 27 54 1 1946970752 10349744 7997856
15:58:46 57360 8192000000 10864532192 11330191360 1893481680 18.774 97 15 30 1 1906972720 9430528 4060512
15:59:53 21789 8192000000 10906344048 11342061568 1934719680 19.105 99 44 85 0 1953597744 7192864 11685200
16:00:22 49618 8192000000 10844820208 11300306944 1839585264 18.337 95 24 48 1 1855387312 9533792 6268256
16:01:19 66047 8192000000 10862987232 11318448128 1856759856 18.477 96 19 38 0 1871065872 9388928 4917088
16:02:31 65486 8192000000 10850063440 11314016256 1865426160 18.547 96 26 52 2 1885151264 12090640 7634464
16:03:46 107535 8192000000 10852187504 11309146112 1807553312 18.076 94 9 18 1 1835454672 25873056 2028304
16:05:45 31369 8192000000 10874851136 11316838400 1918705296 18.976 99 19 38 4 1930961104 7467728 4788080
16:06:24 12610 8192000000 10870289616 11301416960 1899696496 18.824 98 53 105 0 1922951296 8725904 14528896
16:06:46 11234 8192000000 10886206192 11323613184 1936537088 19.119 100 50 98 1 1961129936 11189648 13403200
16:07:03 20812 8192000000 10887376176 11330490368 1940181920 19.148 100 46 92 0 1965141264 12566576 12392768
16:07:35 44321 8192000000 10910932544 11344379904 1935868576 19.114 99 43 84 0 1959643552 12277552 11497424
16:08:27 28158 8192000000 10918998592 11356835840 1947027024 19.203 99 52 104 0 1973477552 12018832 14431696
16:09:04 45107 8192000000 10904792864 11363868672 1971316288 19.396 100 51 102 0 2001371696 15999824 14055584
16:10:16 18803 8192000000 10910921840 11359801344 1973857472 19.416 100 37 74 1 1994080416 9454912 10768032
16:10:41 121687 8192000000 10887737232 11357495296 1909720160 18.904 97 21 42 0 1928357152 12932768 5704224
16:12:49 64273 8192000000 10883262352 11343130624 1938720848 19.137 99 12 24 0 1956715520 14570336 3424336
16:14:22 79764 8192000000 10899198336 11351162880 1950125680 19.227 99 29 58 1 1968285808 9660320 8499808
16:15:49 69214 8192000000 10883848720 11359879168 1969664720 19.383 100 10 20 0 1981144064 8534464 2944880
16:17:16 69263 8192000000 10878034192 11349323776 1932795152 19.089 98 6 12 0 1941521680 7108560 1617968
16:18:33 97021 8192000000 10907183776 11379441664 1966660336 19.359 99 15 30 0 1987675408 16490592 4524480
16:20:35 71795 8192000000 10904040880 11401699328 1965577232 19.350 99 14 28 0 1992692976 22848240 4267504
16:21:56 109552 8192000000 10854394736 11327184896 1836230944 18.310 93 8 16 3 1849035824 9946880 2858000
16:24:01 40874 8192000000 10886228544 11328262144 1876431024 18.636 96 29 58 0 1891248000 5986400 8830576
16:24:49 27545 8192000000 10885282704 11325239296 1929564512 19.063 99 48 96 1 1954180432 11215536 13400384
16:25:27 38918 8192000000 10860296736 11319685120 1901509216 18.838 98 26 52 2 1919773168 10874512 7389440
16:26:22 52242 8192000000 10886657680 11348316160 1935060368 19.107 99 12 24 2 1949328864 10830592 3437904
16:27:30 91367 8192000000 10869261968 11339653120 1833051616 18.284 94 14 28 0 1849347632 12358928 3937088
16:29:08 107700 8192000000 10893538448 11356082176 1912693872 18.928 98 18 34 0 1934452816 17026832 4732112
16:31:06 25108 8192000000 10909912496 11352166400 1946095712 19.195 99 56 112 0 1976663536 14613312 15954512
16:31:42 28766 8192000000 9023674816 9219522560 185335056 2.212 10 2 4 0 190679504 5008320 336128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 28-12-2020 16:32:54 to 28-12-2020 16:33:25.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 102 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 28-12-2020 16:33:26 to 28-12-2020 16:33:28.

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          228500
MON$OLDEST_ACTIVE               229596
MON$OLDEST_SNAPSHOT             229596
MON$NEXT_TRANSACTION            229596
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                       1996352
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Mon Dec 28 16:32:13 2020
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Mon Dec 28 16:32:13 2020
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
--- end of diff output ---

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

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