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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-21 16:31:27
DTS_END                         2020-11-21 16:31:27.1240
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/47846
TRN_ID                          234114
ATT_ID                          682
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: 9375.03 17371 1125004
customer order: creation 170.29 384 20435
customer order: refuse 14.39 361 1727
order to supplier: creation 45.06 1278 5407
order to supplier: removal 3.60 99256 432
invoice (draft): creation 45.60 3386 5472
invoice (draft): removal 55.18 787 6621
invoice accept: apply 41.43 17859 4972
invoice accept: cancel 49.83 808 5979
customer reserve: creation 3803.63 178 456435
customer reserve: removal 4846.42 57 581570
realization accept: apply 82.00 186 9840
realization accept: cancel 89.16 108 10699
payment from customer: creation 58.86 110 7063
payment from customer: removal 5.83 83 699
payment to supplier: creation 47.94 122 5753
payment to supplier: removal 3.53 102 423
service: total inventory turnovers 4.93 1192 591
service: total monetary turnovers 6.54 44 785
service: aggregate perf. data 0.81 19913 97
service: refresh index statistics 0.03 201197 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-11-2020 16:32:54 to 21-11-2020 16:32:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7327
TEST_TIME 2 5737
TEST_TIME 3 5046
TEST_TIME 4 5627
TEST_TIME 5 5723
TEST_TIME 6 5508
TEST_TIME 7 5569
TEST_TIME 8 5627
TEST_TIME 9 6112
TEST_TIME 10 6359
TEST_TIME 11 6593
TEST_TIME 12 6512
TEST_TIME 13 7082
TEST_TIME 14 7267
TEST_TIME 15 7410
TEST_TIME 16 7434
TEST_TIME 17 7509
TEST_TIME 18 8189
TEST_TIME 19 8406
TEST_TIME 20 9095
TEST_TIME 21 9198
TEST_TIME 22 9230
TEST_TIME 23 9360
TEST_TIME 24 9443
TEST_TIME 25 9442
TEST_TIME 26 10010
TEST_TIME 27 11176
TEST_TIME 28 10920
TEST_TIME 29 10882
TEST_TIME 30 10817
TEST_TIME 31 10734
TEST_TIME 32 10711
TEST_TIME 33 10659
TEST_TIME 34 10405
TEST_TIME 35 10191
TEST_TIME 36 10356
TEST_TIME 37 10142
TEST_TIME 38 10060
TEST_TIME 39 9958
TEST_TIME 40 10036
TEST_TIME 41 10094
TEST_TIME 42 9974
TEST_TIME 43 9874
TEST_TIME 44 9756
TEST_TIME 45 9670
TEST_TIME 46 9717
TEST_TIME 47 9646
TEST_TIME 48 9593
TEST_TIME 49 9482
TEST_TIME 50 9523
TEST_TIME 51 9509
TEST_TIME 52 9591
TEST_TIME 53 9632
TEST_TIME 54 9590
TEST_TIME 55 9583
TEST_TIME 56 9768
TEST_TIME 57 9841
TEST_TIME 58 9813
TEST_TIME 59 9912
TEST_TIME 60 9971
TEST_TIME 61 9919
TEST_TIME 62 9823
TEST_TIME 63 9791
TEST_TIME 64 9698
TEST_TIME 65 9692
TEST_TIME 66 9605
TEST_TIME 67 9592
TEST_TIME 68 9509
TEST_TIME 69 9508
TEST_TIME 70 9490
TEST_TIME 71 9487
TEST_TIME 72 9463
TEST_TIME 73 9437
TEST_TIME 74 9527
TEST_TIME 75 9515
TEST_TIME 76 9617
TEST_TIME 77 9745
TEST_TIME 78 9742
TEST_TIME 79 9692
TEST_TIME 80 9751
TEST_TIME 81 9845
TEST_TIME 82 9911
TEST_TIME 83 9859
TEST_TIME 84 9769
TEST_TIME 85 9711
TEST_TIME 86 9684
TEST_TIME 87 9679
TEST_TIME 88 9624
TEST_TIME 89 9568
TEST_TIME 90 9578
TEST_TIME 91 9576
TEST_TIME 92 9530
TEST_TIME 93 9551
TEST_TIME 94 9517
TEST_TIME 95 9542
TEST_TIME 96 9513
TEST_TIME 97 9518
TEST_TIME 98 9519
TEST_TIME 99 9516
TEST_TIME 100 9533
TEST_TIME 101 9525
TEST_TIME 102 9669
TEST_TIME 103 9710
TEST_TIME 104 9695
TEST_TIME 105 9690
TEST_TIME 106 9757
TEST_TIME 107 9714
TEST_TIME 108 9636
TEST_TIME 109 9620
TEST_TIME 110 9598
TEST_TIME 111 9557
TEST_TIME 112 9509
TEST_TIME 113 9505
TEST_TIME 114 9461
TEST_TIME 115 9509
TEST_TIME 116 9469
TEST_TIME 117 9475
TEST_TIME 118 9471
TEST_TIME 119 9449
TEST_TIME 120 9388

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-11-2020 16:32:58 to 21-11-2020 16:33:01.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1548443 1548443 0 0.00 0 18307 6 0 0
doc_list_biud 1548443 1548443 0 0.00 0 28662 28 0 0
sp_add_invoice_to_stock 5074 4972 102 2.01 36 238447 17859 0 102
sp_cancel_adding_invoice 5979 5979 0 0.00 4 74692 808 0 0
sp_cancel_client_order 1727 1727 0 0.00 4 17643 362 0 0
sp_cancel_customer_reserve 581570 581570 0 0.00 1 26671 58 0 0
sp_cancel_pay_from_customer 699 699 0 0.00 3 4607 84 0 0
sp_cancel_pay_to_supplier 423 423 0 0.00 3 7317 103 0 0
sp_cancel_supplier_invoice 6629 6621 8 0.12 1 28679 788 0 8
sp_cancel_supplier_order 432 432 0 0.00 10 921320 99257 0 0
sp_cancel_write_off 10699 10699 0 0.00 1 9842 108 0 0
sp_client_order 20435 20435 0 0.00 3 22812 385 0 0
sp_customer_reserve 456435 456435 0 0.00 0 45138 179 0 0
sp_fill_shopping_cart 31311 31311 0 0.00 1 11924 38 0 0
sp_fill_shopping_cart_clo_res 456414 456414 0 0.00 0 24658 12 0 0
sp_get_clo_for_invoice 4949 4949 0 0.00 0 40475 274 0 0
sp_kill_cost_storno 17800 17800 0 0.00 0 9408 58 0 0
sp_kill_qstorno_ret_qs2qd 1180892 1180892 0 0.00 0 28656 31 0 0
sp_kill_qty_storno 621817 621817 0 0.00 0 28659 68 0 0
sp_lock_selected_doc 20616 20616 0 0.00 0 8203 5 0 0
sp_make_cost_storno 27605 27605 0 0.00 0 18304 51 0 0
sp_multiply_rows_for_pdistr 27605 27605 0 0.00 0 8660 30 0 0
sp_multiply_rows_for_qdistr 20435 20435 0 0.00 0 22802 180 0 0
sp_pay_from_customer 7063 7063 0 0.00 4 12927 110 0 0
sp_pay_to_supplier 5753 5753 0 0.00 4 12608 122 0 0
sp_payment_common 12816 12816 0 0.00 1 12915 31 0 0
sp_qd_handle_on_cancel_clo 1727 1727 0 0.00 0 17631 323 0 0
sp_qd_handle_on_invoice_upd_sts 10928 10928 0 0.00 0 24894 328 0 0
sp_qd_handle_on_reserve_upd_sts 9840 9840 0 0.00 0 17510 66 0 0
sp_reserve_write_off 9840 9840 0 0.00 7 18312 187 0 0
sp_supplier_invoice 5472 5472 0 0.00 7 72330 3387 0 0
sp_supplier_order 5407 5407 0 0.00 5 27821 1278 0 0
srv_aggregate_perf_data 97 97 0 0.00 2505 186943 19914 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1203 126368 31066 0 0
srv_find_qd_qs_mism 1078170 1078170 0 0.00 0 14239 5 0 0
srv_make_invnt_saldo 591 591 0 0.00 31 85308 1192 0 0
srv_make_money_saldo 785 785 0 0.00 1 10134 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 132338 262113 201198 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 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4973 4973 0 0.00 0 14356 192 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 0 16288 141 0 0
t$perf-norm:sp_cancel_client_order 1727 1727 0 0.00 0 3450 14 0 0
t$perf-norm:sp_cancel_customer_reserve 679 679 0 0.00 0 1658 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 699 699 0 0.00 0 4053 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 423 423 0 0.00 0 281 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 419 419 0 0.00 0 7226 42 0 0
t$perf-norm:sp_cancel_supplier_order 432 432 0 0.00 0 35338 1821 0 0
t$perf-norm:sp_cancel_write_off 1031 1031 0 0.00 0 3468 9 0 0
t$perf-norm:sp_client_order 20435 20435 0 0.00 0 12614 20 0 0
t$perf-norm:sp_customer_reserve 959 959 0 0.00 0 14152 27 0 0
t$perf-norm:sp_pay_from_customer 7063 7063 0 0.00 0 14214 15 0 0
t$perf-norm:sp_pay_to_supplier 5753 5753 0 0.00 0 6720 16 0 0
t$perf-norm:sp_reserve_write_off 9840 9840 0 0.00 0 11624 15 0 0
t$perf-norm:sp_supplier_invoice 5472 5472 0 0.00 0 11717 22 0 0
t$perf-norm:sp_supplier_order 5407 5407 0 0.00 0 6550 20 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 253 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 3758 30 0 0
t$perf-norm:srv_make_invnt_saldo 591 591 0 0.00 0 958 20 0 0
t$perf-norm:srv_make_money_saldo 785 785 0 0.00 0 983 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10102 9898 204 2.01 0 6056 19 0 204
v_all_customers 37500 37500 0 0.00 0 18 1 0 0
v_all_suppliers 30306 30306 0 0.00 0 17 1 0 0
v_all_wares 40868 40868 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 1346 8 0 0
v_cancel_client_order 3454 3454 0 0.00 0 4356 8 0 0
v_cancel_customer_prepayment 1398 1398 0 0.00 0 1882 7 0 0
v_cancel_customer_reserve 1358 1358 0 0.00 0 2599 5 0 0
v_cancel_payment_to_supplier 846 846 0 0.00 0 2013 6 0 0
v_cancel_supplier_invoice 854 838 16 1.87 0 457 13 0 16
v_cancel_supplier_order 864 864 0 0.00 0 507 4 0 0
v_cancel_write_off 2062 2062 0 0.00 0 4727 16 0 0
v_max_id_clo_ord 5407 5407 0 0.00 0 244 1 0 0
v_max_id_clo_res 959 959 0 0.00 0 24948 38 0 0
v_max_id_ord_sup 5470 5470 0 0.00 0 3699 3 0 0
v_max_non_paid_invoice 1477 1477 0 0.00 0 7805 8 0 0
v_max_non_paid_realizn 3594 3594 0 0.00 0 6097 6 0 0
v_min_id_clo_ord 5407 5407 0 0.00 0 5285 8 0 0
v_min_id_clo_res 959 959 0 0.00 0 8840 24 0 0
v_min_id_ord_sup 5470 5470 0 0.00 0 5244 8 0 0
v_min_non_paid_invoice 5753 5753 0 0.00 0 11131 18 0 0
v_min_non_paid_realizn 7063 7063 0 0.00 0 12911 24 0 0
v_our_firm 10306 10306 0 0.00 0 19 1 0 0
v_reserve_write_off 19680 19680 0 0.00 0 4280 6 0 0
x_lock_depdocs_on_canc_invoice 12181 12181 0 0.00 0 16958 115 0 0
x_lock_depdocs_on_canc_sup_ord 432 432 0 0.00 0 12994 370 0 0
x_make_qstorno_1000_1200 5407 5407 0 0.00 1 27814 1199 0 0
x_make_qstorno_1200_2000 5472 5472 0 0.00 2 72323 3253 0 0
x_make_qstorno_2100_3300 456435 456435 0 0.00 0 45136 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-11-2020 16:33:02 to 21-11-2020 16:33:06.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:01:30 3 8192000000 8804576752 8816787456 10345712 0.126 2 2 3 0 10524160 66144 112304
14:01:37 2679 8192000000 9578934864 9757741056 573830784 6.546 48 34 75 1 585853536 1374816 10647936
14:01:47 23876 8192000000 10302121696 10618138624 1347693152 14.127 100 81 160 1 1377846480 3895072 26258256
14:02:21 36037 8192000000 10366138192 10691624960 1416530656 14.742 100 89 178 0 1455804064 10318400 28955008
14:03:08 25842 8192000000 10397534336 10727448576 1452612240 15.061 100 86 172 0 1487934144 7206160 28115744
14:03:42 10135 8192000000 10416063696 10745733120 1474881936 15.257 100 92 181 1 1512674224 7728848 30063440
14:04:05 28222 8192000000 10445895376 10780860416 1498369776 15.462 100 93 187 1 1537071584 8726032 29975776
14:04:42 16150 8192000000 10453934064 10791854080 1508747536 15.552 100 85 170 0 1545686288 9460160 27478592
14:05:22 15001 8192000000 10483424864 10827366400 1533468832 15.767 100 84 168 2 1570305456 9993936 26842688
14:05:52 10334 8192000000 10512231920 10858119168 1561773408 16.011 100 84 168 0 1598197024 10614096 25809520
14:06:16 15834 8192000000 10534774528 10885853184 1589012576 16.245 100 82 164 1 1625811136 11554640 25243920
14:06:41 8052 8192000000 10551607360 10905313280 1607219712 16.401 100 82 163 1 1643548688 11476672 24852304
14:06:58 18260 8192000000 10557437280 10916171776 1617178304 16.486 100 85 170 1 1654931472 12067680 25685488
14:07:39 12790 8192000000 10595009200 10961248256 1650925200 16.772 100 77 154 2 1686494352 12665392 22903760
14:08:01 12092 8192000000 10617399312 10984206336 1679139488 17.010 100 77 154 2 1713907344 12684288 22083568
14:08:20 6108 8192000000 10619084128 10988576768 1686839248 17.075 100 78 154 2 1722945040 13629280 22476512
14:08:34 7907 8192000000 10642048736 11010912256 1698359616 17.171 100 83 164 2 1735531888 12528304 24643968
14:08:50 9017 8192000000 10653440784 11025403904 1716863632 17.326 100 84 168 0 1754045344 13184496 23997216
14:09:08 7528 8192000000 10670691776 11043516416 1726385792 17.405 100 75 150 1 1761933792 13618080 21929920
14:09:22 4515 8192000000 10689270080 11060781056 1745209648 17.562 100 84 167 0 1782610704 13619616 23781440
14:09:35 3789 8192000000 10694751088 11068760064 1754201152 17.636 100 84 168 2 1791180192 13243792 23735248
14:09:45 5123 8192000000 10699960912 11081064448 1766496112 17.738 100 87 172 0 1803149440 12977984 23675344
14:09:57 6423 8192000000 10715810656 11096809472 1774965856 17.808 100 87 174 2 1813247440 13657728 24623856
14:10:11 3833 8192000000 10724131728 11100676096 1777029040 17.825 100 84 165 2 1814933168 14792336 23111792
14:10:21 3663 8192000000 10729396224 11107143680 1783117792 17.875 100 87 170 1 1821686736 14317280 24251664
14:10:31 2703 8192000000 10731376752 11112538112 1789900064 17.931 100 92 184 2 1830638848 14960896 25777888
14:10:41 1902 8192000000 10745367984 11127951360 1796384016 17.984 100 87 173 0 1834956672 13987584 24585072
14:10:50 3861 8192000000 10743254560 11125915648 1803353328 18.041 100 86 173 1 1841384320 13515408 24515584
14:11:00 2696 8192000000 10747698352 11133837312 1808384320 18.083 100 81 162 1 1844435120 12342384 23708416
14:11:09 2323 8192000000 10753767216 11140345856 1816617200 18.150 100 92 184 2 1855308160 12897424 25793536
14:11:19 6361 8192000000 10751516608 11141808128 1815429248 18.140 100 69 138 0 1846559600 12057088 19073264
14:11:32 3590 8192000000 10770442080 11153981440 1824030304 18.211 100 81 163 1 1858434112 12141968 22261840
14:11:42 2091 8192000000 10781338384 11168423936 1837661728 18.322 100 92 184 0 1876874320 12956144 26256448
14:11:51 1838 8192000000 10787396224 11174449152 1843492960 18.369 100 92 182 0 1882821120 14088128 25240032
14:12:00 2405 8192000000 10792875568 11177234432 1847270800 18.400 100 93 186 1 1889448704 16256256 25921648
14:12:09 2273 8192000000 10791669360 11178229760 1846699408 18.395 100 90 181 1 1886106416 14431888 24975120
14:12:17 2300 8192000000 10798069760 11185614848 1855405168 18.466 100 91 182 0 1894146352 13221248 25519936
14:12:26 1830 8192000000 10803606384 11187589120 1859258592 18.497 100 94 189 0 1898315888 13203664 25853632
14:12:34 2297 8192000000 10809585088 11198287872 1861463760 18.515 100 92 180 2 1899776928 13597856 24715312
14:12:43 1620 8192000000 10805678400 11192778752 1860336352 18.506 100 93 182 2 1899516656 13161712 26018592
14:12:52 7320 8192000000 10771230960 11187793920 1860758976 18.509 100 72 144 2 1894013328 12318752 20935600
14:13:05 18032 8192000000 10808905856 11200229376 1864866784 18.543 100 69 136 4 1894135936 9809600 19459552
14:13:29 1950 8192000000 10794638800 11202682880 1865599824 18.549 100 68 136 2 1896766352 12848400 18318128
14:13:38 3263 8192000000 10795326480 11202207744 1865415952 18.547 100 60 119 2 1892838640 10686144 16736544
14:13:54 6245 8192000000 10777228528 11196780544 1862608016 18.524 100 39 78 1 1881820592 7629248 11583328
14:14:09 6428 8192000000 10776135120 11195265024 1861300464 18.514 100 23 46 0 1878842896 11015600 6526832
14:14:23 6018 8192000000 10777450560 11198177280 1867564672 18.565 100 31 62 0 1882798096 6242832 8990592
14:14:35 5046 8192000000 10781613920 11201032192 1867204880 18.562 100 30 60 1 1882690960 7247472 8238608
14:14:50 4721 8192000000 10784872480 11208044544 1871178336 18.594 100 29 58 1 1887823392 7956480 8688576
14:15:01 11690 8192000000 10787417664 11209793536 1871375536 18.595 100 20 40 2 1883159392 6312928 5470928
14:15:19 8674 8192000000 10784848032 11211636736 1875256800 18.627 100 23 46 2 1888124320 6114928 6752592
14:15:34 66427 8192000000 10822119856 11224600576 1881326000 18.676 100 35 70 1 1895639472 4481264 9832208
14:16:46 4120 8192000000 10808134128 11234762752 1890053280 18.746 100 62 125 0 1917824016 9844256 17926480
14:16:57 9040 8192000000 10799057040 11228667904 1883736048 18.695 100 29 56 0 1897760336 6182864 7841424
14:17:12 5513 8192000000 10798059616 11230449664 1885026912 18.706 100 21 42 0 1897582480 6628160 5927408
14:17:25 4633 8192000000 10807170336 11234050048 1889493952 18.742 100 37 73 1 1906951632 7186464 10271216
14:17:39 6663 8192000000 10810691744 11236962304 1893014064 18.770 100 34 68 2 1909561168 7193216 9353888
14:17:52 3358 8192000000 10813689248 11243270144 1894628352 18.783 100 36 72 0 1915732752 11165264 9939136
14:18:02 4889 8192000000 10822916016 11245481984 1893467840 18.774 100 30 59 1 1908609152 7259920 7881392
14:18:13 9753 8192000000 10805597264 11237380096 1894511568 18.782 100 20 41 1 1906120624 6327376 5281680
14:18:29 7529 8192000000 10804841776 11239563264 1899320016 18.821 100 20 40 4 1910956544 6275648 5360880
14:18:47 9813 8192000000 10802611216 11241418752 1895770464 18.792 100 16 32 2 1906315776 5623088 4922224
14:19:05 11781 8192000000 10804787904 11244072960 1899055888 18.819 100 18 32 2 1910692624 5887088 5749648
14:19:23 26194 8192000000 10807801696 11251097600 1901938976 18.842 100 27 52 5 1914884224 5460256 7484992
14:20:18 24781 8192000000 10829545696 11260858368 1911305232 18.917 100 40 80 0 1930082800 7910176 10867392
14:20:50 11172 8192000000 10812879328 11248136192 1890006576 18.746 99 21 42 2 1901409168 6048800 5353792
14:21:13 9855 8192000000 10827080416 11259080704 1906267136 18.877 100 39 78 2 1924724672 6956048 11501488
14:21:29 6438 8192000000 10791463488 11223453696 1847130816 18.399 97 32 63 1 1867896704 11381536 9384352
14:21:47 7702 8192000000 10781356592 11213058048 1835223968 18.302 97 25 50 2 1847554208 5621136 6709104
14:22:03 6989 8192000000 10788762000 11216785408 1866521600 18.556 99 17 34 3 1876291360 5176624 4593136
14:22:20 7519 8192000000 10775226592 11202789376 1835034768 18.300 98 14 28 2 1844262448 5463600 3764080
14:22:35 8343 8192000000 10781110992 11206766592 1833442912 18.287 98 19 38 2 1848740928 9924160 5373856
14:22:53 5947 8192000000 10755943984 11173363712 1782875760 17.873 96 26 52 2 1796181120 5540688 7764672
14:23:09 6717 8192000000 10740672128 11145416704 1776158160 17.818 97 22 44 1 1788831840 6086672 6587008
14:23:22 9235 8192000000 10722522752 11152887808 1787974128 17.915 98 18 35 0 1798772544 5870016 4928400
14:23:40 11883 8192000000 10703382320 11120173056 1720805472 17.359 95 15 30 1 1729858544 5301088 3751984
14:24:00 19523 8192000000 10689528400 11106836480 1686867056 17.075 93 21 42 0 1698453872 5466768 6120048
14:25:05 21455 8192000000 10719305648 11122683904 1700848016 17.192 94 55 110 2 1723293488 6665248 15780224
14:25:35 12843 8192000000 10687018992 11103780864 1681064048 17.026 93 23 46 0 1693478848 6085600 6329200
14:25:56 7245 8192000000 10711004048 11121283072 1724990208 17.394 96 21 42 1 1736633920 6052688 5591024
14:26:10 10348 8192000000 10722948112 11137695744 1784666512 17.888 99 26 52 3 1798115472 5983520 7465440
14:26:28 8987 8192000000 10738501760 11148730368 1812984880 18.120 100 31 62 1 1827671648 6088448 8598320
14:26:46 7201 8192000000 10709874464 11139743744 1782311664 17.869 98 23 46 0 1795579712 6902128 6365920
14:26:59 6785 8192000000 10722323104 11139842048 1779795984 17.848 98 26 51 2 1791830560 5293360 6741216
14:27:12 5362 8192000000 10730992144 11154874368 1799898176 18.013 99 26 52 1 1817432480 10398000 7136304
14:27:24 7113 8192000000 10741422272 11161546752 1816260848 18.147 100 16 32 2 1826180880 5522496 4397536
14:27:37 11006 8192000000 10736222016 11162202112 1808456432 18.083 99 16 31 4 1818805456 5044544 5304480
14:27:55 8598 8192000000 10737454112 11162701824 1826868592 18.234 100 17 35 0 1837414656 5633232 4912832
14:28:11 6490 8192000000 10766508512 11177943040 1838109264 18.325 100 36 72 3 1854660400 5386624 11164512
14:28:26 15147 8192000000 10749554528 11179286528 1844440352 18.377 100 19 38 0 1855037696 5501408 5095936
14:28:47 13240 8192000000 10750962208 11185733632 1846548256 18.394 100 15 30 2 1856589520 5820768 4220496
14:29:13 25220 8192000000 10771556752 11199246336 1851726320 18.436 100 27 54 1 1865225200 5515552 7983328
14:30:11 17498 8192000000 10775867360 11198832640 1863149472 18.529 100 55 108 2 1885957280 5642304 17165504
14:30:36 18334 8192000000 10772320480 11202867200 1861001696 18.511 100 17 33 0 1871395472 5099168 5294608
14:31:02 8355 8192000000 10795158704 11218251776 1875132304 18.626 100 27 50 2 1886770096 5429440 6208352
14:31:17 10361 8192000000 10806334208 11230859264 1891034768 18.754 100 29 58 0 1904532752 6068064 7429920
14:31:34 20229 8192000000 10816258208 11237695488 1894636416 18.783 100 33 66 1 1909723824 5467552 9619856
14:32:10 13968 8192000000 10832863296 11256406016 1908963680 18.898 100 43 84 0 1928464112 7103312 12397120
14:32:35 17459 8192000000 10840920384 11261112320 1910629808 18.912 100 42 82 1 1929841712 7403456 11808448
14:32:59 13330 8192000000 10841488864 11266752512 1916431808 18.958 100 38 76 1 1935382976 8399760 10551408
14:33:23 18094 8192000000 10848942528 11278811136 1925899440 19.034 100 46 90 2 1947499584 8338480 13261664
14:33:50 31884 8192000000 10868617152 11299082240 1938252064 19.133 100 48 95 1 1963819616 11694592 13872960
14:34:35 17171 8192000000 10883468448 11309342720 1948288048 19.213 100 53 107 1 1976873760 13132512 15453200
14:35:03 20429 8192000000 10879233776 11320774656 1953688192 19.256 100 52 104 0 1985597024 16542512 15366320
14:36:00 10785 8192000000 10891610896 11320709120 1956151584 19.275 100 46 92 0 1983168448 13728400 13288464
14:36:23 43256 8192000000 10879961648 11330207744 1957746768 19.288 100 27 53 1 1980395808 13795584 8853456
14:37:35 17543 8192000000 10887879024 11332243456 1966358864 19.357 100 34 68 2 1989551888 12539712 10653312
14:38:04 8698 8192000000 10909449888 11342729216 1974228176 19.419 100 47 94 0 2001751488 13531936 13991376
14:38:19 9983 8192000000 10916399632 11350147072 1979097728 19.458 100 55 110 2 2010850160 15670576 16081856
14:38:39 10749 8192000000 10925934160 11357323264 1980829104 19.471 100 55 104 1 2011865568 15726256 15310208
14:38:57 15041 8192000000 10942139232 11364294656 1986684224 19.518 100 61 122 1 2022300592 17001776 18614592
14:39:19 13372 8192000000 10931378832 11362807808 1984028784 19.497 100 59 118 0 2019121664 17466112 17626768
14:39:51 5966 8192000000 10948548560 11371311104 1990663072 19.549 100 60 120 2 2027598000 19046736 17888192
14:40:04 1922 8192000000 10958412224 11377627136 1998399776 19.610 100 77 152 3 2040226096 19755536 22070784
14:40:13 9134 8192000000 10954149872 11378831360 2001528512 19.635 100 74 148 3 2043421072 20547408 21345152
14:40:30 5622 8192000000 10950095376 11368894464 1988116288 19.529 99 78 157 1 2031212512 19912352 23183872
14:40:47 7199 8192000000 10940829024 11369283584 1995427904 19.587 100 59 118 1 2030201696 17737680 17036112
14:41:01 6005 8192000000 10962290928 11383222272 2007450928 19.681 100 80 159 1 2050918528 19884128 23583472
14:41:14 2395 8192000000 10963919952 11388006400 2007917904 19.685 100 77 153 1 2051390864 21171680 22301280
14:41:26 12334 8192000000 10967435120 11394215936 2008182400 19.687 100 66 131 1 2050785264 23397312 19205552
14:41:45 7474 8192000000 10965922752 11393466368 2011803072 19.716 100 68 136 1 2056696048 24349120 20543856
14:42:03 14041 8192000000 10948822736 11384676352 1989476560 19.540 99 59 117 3 2028992960 22337936 17178464
14:42:29 8977 8192000000 10941548528 11377033216 1984354960 19.499 99 56 112 2 2022884288 20749232 17780096
14:42:45 1202 8192000000 10960031264 11384700928 2004237632 19.656 100 74 144 1 2048529104 21188416 23103056
14:42:53 3231 8192000000 10975356784 11391844352 2008539664 19.690 100 78 157 1 2056303424 23797920 23965840
14:43:04 5691 8192000000 10972816128 11400495104 2012848608 19.724 100 69 137 2 2056939840 23814512 20276720
14:43:28 1648 8192000000 10982886688 11406327808 2015822720 19.747 100 75 148 0 2064819248 26877408 22119120
14:43:38 5764 8192000000 10989364368 11412008960 2021008080 19.788 100 82 162 0 2074509136 29301520 24199536
14:43:55 4562 8192000000 10983268368 11412234240 2001894752 19.638 99 73 146 0 2057348672 33183824 22270096
14:44:07 1349 8192000000 10992730752 11414536192 2021446880 19.792 100 75 151 2 2078161296 33290304 23424112
14:44:16 1907 8192000000 10996031120 11420348416 2023993424 19.812 100 74 147 0 2079151296 32671536 22486336
14:44:26 2310 8192000000 10948589584 11377958912 1983631840 19.493 98 63 123 2 2030113008 28283888 18197280
14:44:38 6144 8192000000 10996014368 11411181568 2018323424 19.767 100 74 148 0 2071265472 30166448 22775600
14:44:52 2202 8192000000 10988287024 11414818816 2026453408 19.831 100 81 156 1 2080329456 28657920 25218128
14:45:00 3601 8192000000 10988308112 11407376384 2014090656 19.734 100 86 168 1 2068103760 29024464 24988640
14:45:11 1342 8192000000 10981778768 11391885312 1998888768 19.614 99 88 178 3 2056095392 30268160 26938464
14:45:20 3992 8192000000 10981498736 11402231808 1997829712 19.606 99 77 153 0 2051642240 30519520 23293008
14:45:30 2290 8192000000 10972063552 11391336448 1989292480 19.538 99 77 152 2 2044468912 31185664 23990768
14:45:39 3746 8192000000 10969041616 11392221184 2001189120 19.632 100 78 154 0 2061258160 36287616 23781424
14:45:51 1940 8192000000 10983991344 11395346432 2002362832 19.641 100 89 176 2 2060691952 32349888 25979232
14:46:00 2740 8192000000 10973496992 11388575744 1995227488 19.585 100 84 166 0 2055288080 34089024 25971568
14:46:11 3131 8192000000 10945778464 11366301696 1940387568 19.150 97 79 158 0 2000438832 34962336 25088928
14:46:30 5338 8192000000 10942249840 11365650432 1967674496 19.367 99 66 130 1 2025629568 37523936 20431136
14:46:45 6992 8192000000 10950189488 11378376704 1981382928 19.476 100 63 124 2 2037729904 36877184 19469792
14:47:08 3127 8192000000 10963561520 11382546432 1987815456 19.527 100 89 176 1 2049808352 34976928 27015968
14:47:20 5294 8192000000 10967435584 11389800448 1992704992 19.565 100 66 129 0 2048359488 35569152 20085344
14:47:33 2965 8192000000 10968809984 11390857216 1994395808 19.579 100 76 150 1 2056379952 37643632 24340512
14:47:46 3767 8192000000 10980034288 11400359936 2001940656 19.638 100 82 164 1 2066664368 39149760 25573952
14:48:01 3166 8192000000 10955921200 11379970048 1978990960 19.457 99 72 144 0 2042911168 40840944 23079264
14:48:13 5052 8192000000 10977528208 11402727424 1996168928 19.593 100 77 154 1 2061965792 41620096 24176768
14:48:25 2116 8192000000 10984468880 11400019968 1994802944 19.582 100 88 177 0 2067897984 44470576 28624464
14:48:36 3151 8192000000 10966279472 11379109888 1966171632 19.355 99 89 178 1 2041041456 46024960 28844864
14:48:46 2494 8192000000 10974774032 11386445824 1981646096 19.478 100 78 155 0 2052506576 45760432 25100048
14:48:58 3382 8192000000 10957914976 11389546496 1981176000 19.474 100 60 118 2 2046147248 45800688 19170560
14:49:12 1634 8192000000 10979927952 11397939200 1985649856 19.509 100 80 157 0 2059196864 48504432 25042576
14:49:20 2103 8192000000 10984812208 11399110656 1988201280 19.530 100 90 180 0 2058671696 42416832 28053584
14:49:30 2120 8192000000 10949974576 11358662656 1955999280 19.274 98 83 166 0 2022430880 40803040 25628560
14:49:40 4748 8192000000 10938601840 11360661504 1943549792 19.175 98 77 154 2 2008569440 40914560 24105088
14:49:52 5117 8192000000 10965271856 11389485056 1985422928 19.508 100 83 163 0 2053517584 42517120 25577536
14:50:05 2474 8192000000 10946484640 11362271232 1957070496 19.283 99 78 157 1 2020335296 38787248 24477552
14:50:15 6077 8192000000 10930492880 11350429696 1929733040 19.065 98 73 145 1 1990525216 37685584 23106592
14:50:29 1934 8192000000 10917904368 11333025792 1937966240 19.131 100 72 144 1 2000301904 38990448 23345216
14:50:37 3111 8192000000 10934897488 11345973248 1952989248 19.250 100 84 165 0 2019983024 40739856 26253920
14:50:48 4992 8192000000 10946485776 11359334400 1960202720 19.308 100 80 158 2 2028284944 42486224 25596000
14:51:02 4534 8192000000 10956357312 11367399424 1966314016 19.356 100 81 163 0 2036762144 44878096 25570032
14:51:14 6173 8192000000 10934756176 11344154624 1942479408 19.167 99 66 129 1 2006386064 43435168 20471488
14:51:28 7404 8192000000 10923485168 11350151168 1949066864 19.219 100 55 110 1 2009727536 42705104 17955568
14:51:47 16296 8192000000 10898154064 11342565376 1929214176 19.061 99 29 58 1 1975238224 36268912 9755136
14:52:13 10298 8192000000 10905922288 11343978496 1929986256 19.067 99 38 77 0 1980889584 38281104 12622224
14:52:33 8058 8192000000 10908073600 11344670720 1935195536 19.108 100 31 62 0 1985932592 40239088 10497968
14:52:49 15560 8192000000 10913186256 11359608832 1946290192 19.197 100 29 58 1 1995750400 39640080 9820128
14:53:16 16193 8192000000 10892999904 11336900608 1909097504 18.899 98 24 46 1 1951951232 34997008 7856720
14:53:41 16917 8192000000 10897076624 11340869632 1905252544 18.869 98 29 58 2 1951645648 36653696 9739408
14:54:05 12806 8192000000 10908858880 11351461888 1944435296 19.182 100 29 58 1 1991073376 37374704 9263376
14:54:27 11359 8192000000 10919521728 11359649792 1947334208 19.205 100 31 62 0 2001353424 43519856 10499360
14:54:48 23904 8192000000 10912873760 11357675520 1927623184 19.048 99 31 62 0 1981924448 43159792 11141472
14:55:18 19140 8192000000 10907502240 11356418048 1928011296 19.051 99 25 50 0 1984536752 47185856 9339600
14:56:16 18762 8192000000 10901948272 11353919488 1923943616 19.018 99 25 49 2 1975549392 42990928 8614848
14:56:41 15672 8192000000 10910070624 11353874432 1939960640 19.146 100 36 72 0 2000524080 48338144 12225296
14:57:04 20134 8192000000 10888345808 11343507456 1911900592 18.922 99 27 54 1 1964916288 42892960 10122736
14:57:53 65490 8192000000 10841968944 11307786240 1874411568 18.620 97 10 20 1 1901498480 24322336 2764576
14:59:05 37879 8192000000 10870506416 11314688000 1931859504 19.082 100 37 69 3 1950232128 8405328 9967296
14:59:57 79300 8192000000 10882848768 11329605632 1916745360 18.961 99 33 66 1 1934718016 9560208 8412448
15:01:24 102590 8192000000 10887256064 11330973696 1895583504 18.791 97 22 44 1 1912774560 11148592 6042464
15:03:13 118267 8192000000 10867622896 11333337088 1897689856 18.808 97 15 30 3 1911012400 9330240 3992304
15:05:19 73487 8192000000 10886364128 11341377536 1932363216 19.086 99 33 66 1 1951005664 8546032 10096416
15:06:40 61279 8192000000 10882433328 11353329664 1922275056 19.005 98 35 69 1 1949808560 17259184 10274320
15:07:49 81249 8192000000 10890616928 11346833408 1908725056 18.896 98 11 22 0 1925231488 12814064 3692368
15:09:16 43348 8192000000 10897250224 11335024640 1880742528 18.671 96 37 73 0 1904559936 13163312 10654096
15:10:09 34511 8192000000 10898843280 11344146432 1931661008 19.080 99 50 100 2 1962140768 16094432 14385328
15:11:14 37030 8192000000 10865918896 11336445952 1938453264 19.134 100 13 25 0 1959146240 17095024 3597952
15:11:59 37200 8192000000 10863233616 11332935680 1944132400 19.180 100 20 39 2 1962373440 12393408 5847632
15:13:29 71101 8192000000 10879743728 11344990208 1900580960 18.831 97 15 30 0 1915107200 10795440 3730800
15:14:46 35326 8192000000 10883486144 11353440256 1961356944 19.317 100 10 20 1 1972188304 7692768 3138592
15:15:28 24735 8192000000 10884132480 11351351296 1963432368 19.333 100 8 16 0 1975129712 9200576 2496768
15:15:59 25969 8192000000 10888694688 11355410432 1964993152 19.346 100 14 28 0 1977178496 7570096 4615248
15:16:31 61331 8192000000 10892591904 11358420992 1946948144 19.202 99 21 40 2 1960514400 6746896 6819360
15:17:43 47804 8192000000 10884453824 11361914880 1969281904 19.380 100 20 40 3 1987253296 12228048 5743344
15:18:40 46467 8192000000 10880474656 11360251904 1951099920 19.235 99 11 22 0 1962694608 8466128 3128560
15:20:32 65754 8192000000 10879654576 11360079872 1934123072 19.100 98 13 27 1 1949512144 11432880 3956192
15:21:43 31065 8192000000 10903598352 11361841152 1949272496 19.221 99 26 52 1 1965695984 9329152 7094336
15:22:24 28713 8192000000 10901420784 11366764544 1973562576 19.414 100 30 60 4 1993091568 11750320 7778672
15:23:17 38714 8192000000 10905555680 11364847616 1954019216 19.258 99 19 37 2 1969661040 10263856 5377968
15:24:04 35414 8192000000 10905804448 11374006272 1976364368 19.436 100 29 58 1 1993570208 9096672 8109168
15:24:47 48411 8192000000 10897109344 11354161152 1936974928 19.123 98 21 42 3 1958929072 16374320 5579824
15:25:47 42120 8192000000 10913835488 11387588608 1973684736 19.415 100 19 38 2 1992572464 13421040 5466688
15:26:40 52984 8192000000 10865165360 11335090176 1924098656 19.020 97 22 44 2 1952940816 22293216 6548944
15:28:32 63533 8192000000 10902783632 11372769280 1900038272 18.827 96 13 26 0 1918890272 15258672 3593328
15:29:48 53176 8192000000 10885228080 11355766784 1909699824 18.904 97 28 56 2 1930505584 12907808 7897952
15:31:52 80662 8192000000 10895120512 11356344320 1849024880 18.414 93 19 38 1 1863385504 9358448 5002176
15:34:07 76651 8192000000 10819745712 11270721536 1862962768 18.527 95 23 46 0 1878252816 9073840 6216208
15:35:33 61113 8192000000 10853139952 11331559424 1922722928 19.009 99 28 54 1 1939947952 9882624 7342400
15:36:41 49256 8192000000 10855700512 11335839744 1907792288 18.889 98 8 16 0 1918991904 8857984 2341632
15:38:12 48201 8192000000 10857885872 11339882496 1945335376 19.189 100 9 18 0 1956839184 8384416 3119392
15:39:18 49330 8192000000 10853495936 11330375680 1913599376 18.936 98 10 20 1 1924443984 8053680 2790928
15:40:19 61864 8192000000 10850571376 11330367488 1890524992 18.750 97 14 27 1 1905444304 10759792 4159520
15:41:27 44909 8192000000 10861569472 11329921024 1868933904 18.576 96 15 30 1 1888600080 15025440 4640736
15:42:19 41506 8192000000 10847732832 11312369664 1877659888 18.646 97 26 52 2 1900456384 14895632 7900864
15:43:18 59356 8192000000 10844092288 11304443904 1852879360 18.446 96 13 26 0 1871294352 14490288 3924704
15:44:51 62856 8192000000 10879500496 11349925888 1912704912 18.928 98 23 46 2 1932377344 12776400 6896032
15:46:00 49344 8192000000 10885861984 11347443712 1950526240 19.231 100 18 36 2 1969489440 13979392 4983808
15:47:00 31467 8192000000 10860182224 11322863616 1921869552 19.002 98 21 43 1 1944859152 16120480 6869120
15:47:47 35822 8192000000 10864999792 11351670784 1939761504 19.145 100 14 28 0 1959120928 15075984 4283440
15:48:49 74997 8192000000 10896615776 11347197952 1933782320 19.097 99 23 46 0 1951773936 11603104 6388512
15:50:17 76525 8192000000 10913292592 11358781440 1938568096 19.135 99 23 46 0 1961559984 15985424 7006464
15:51:43 23637 8192000000 10907908272 11366912000 1945086368 19.187 99 41 81 2 1973776304 16828112 11861824
15:52:13 45166 8192000000 10898643120 11363930112 1902061280 18.843 97 23 46 5 1927732320 19811376 5859664
15:53:04 89325 8192000000 10913044144 11357839360 1926609600 19.040 98 24 48 0 1950623456 17299168 6714688
15:54:41 118438 8192000000 10888416128 11352121344 1942606176 19.168 99 32 64 0 1963959600 11703776 9649648
15:56:46 41137 8192000000 10872701232 11340132352 1944461024 19.182 99 37 74 0 1966797344 12088944 10247376
15:58:14 39703 8192000000 10897952272 11356274688 1940450496 19.150 99 26 51 3 1958066656 9839040 7777120
15:59:02 44921 8192000000 10869613920 11347718144 1940546992 19.151 99 12 24 0 1955465776 10930592 3988192
15:59:53 23334 8192000000 10886350192 11356868608 1963336976 19.333 100 16 32 1 1978052048 10332272 4382800
16:00:27 48456 8192000000 10884540672 11364417536 1964814208 19.344 100 10 20 0 1979612240 11847136 2950896
16:01:36 54234 8192000000 10889819520 11367804928 1968424960 19.373 100 8 16 0 1977945536 7264976 2255600
16:02:38 60726 8192000000 10884728544 11355918336 1937188656 19.124 98 10 20 1 1946430240 6908816 2332768
16:03:47 72610 8192000000 10874003200 11362627584 1933900608 19.098 98 9 18 0 1944723136 8710000 2112528
16:05:06 85603 8192000000 10884750496 11357519872 1910632016 18.912 97 7 14 0 1924502640 12373792 1496832
16:06:38 70296 8192000000 10895483808 11363766272 1953665968 19.256 99 20 40 2 1970029584 10560976 5802640
16:07:56 13674 8192000000 10908883664 11366305792 1957533296 19.286 99 32 63 1 1978092480 12050608 8508576
16:08:21 8992 8192000000 10932940288 11379539968 1982496272 19.484 100 58 114 1 2008598000 10273856 15827872
16:08:36 25195 8192000000 10910691536 11377070080 1983801360 19.495 100 47 94 0 2008487648 11820624 12865664
16:09:13 25296 8192000000 10909135456 11368042496 1920733840 18.993 97 34 68 1 1940702880 10692144 9276896
16:09:44 41676 8192000000 10932347168 11391930368 1988089696 19.529 100 37 74 1 2015154784 15708496 11356592
16:10:32 54392 8192000000 10925938784 11404206080 1979897728 19.464 99 30 60 0 2009734928 21142368 8694832
16:11:39 95855 8192000000 10900283696 11373109248 1869602576 18.581 94 18 36 1 1894328688 19661904 5064208
16:13:26 52017 8192000000 10890354656 11371835392 1921333920 18.998 98 22 44 1 1957364080 29055808 6974352
16:14:26 126355 8192000000 10884995408 11361087488 1907648576 18.888 97 7 14 0 1928511024 18925584 1936864
16:16:42 51089 8192000000 10917468208 11383930880 1980822336 19.471 100 36 72 1 2002392032 11650000 9919696
16:18:17 123043 8192000000 10892887488 11366215680 1956718864 19.280 99 19 39 1 1976085424 14151008 5215552
16:22:09 73830 8192000000 10858913200 11333042176 1865305728 18.546 94 19 38 1 1882030992 11429312 5295952
16:23:29 44661 8192000000 10848553456 11318984704 1924340352 19.022 99 12 24 2 1939707408 11920608 3446448
16:24:47 64266 8192000000 10878778464 11353817088 1938590848 19.136 99 16 32 0 1958285776 15258368 4436560
16:25:58 57619 8192000000 10871953616 11344011264 1936494880 19.119 99 22 45 1 1952602560 9562752 6544928
16:27:05 86604 8192000000 10873672512 11352096768 1933913824 19.098 99 12 24 0 1946569424 9165728 3489872
16:29:22 43806 8192000000 10883547632 11339657216 1945487088 19.191 100 30 60 1 1963733696 9559776 8686832
16:30:13 40618 8192000000 10861855232 11330945024 1904838928 18.865 97 33 66 1 1923651808 9589536 9223344
16:31:06 32155 8192000000 9209335888 9459597312 377243280 4.402 19 5 8 1 382344480 3613968 1487232

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 21-11-2020 16:33:08 to 21-11-2020 16:33:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 102 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-11-2020 16:33:40 to 21-11-2020 16:33:42.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          234519
MON$OLDEST_ACTIVE               234520
MON$OLDEST_SNAPSHOT             234520
MON$NEXT_TRANSACTION            234520
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                       2035488
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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    Sat Nov 21 16:31:52 2020
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

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