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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-08 19:27:17
DTS_END                         2021-02-08 19:27:17.6960
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41316
TRN_ID                          243354
ATT_ID                          676
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: 9448.33 23634 1133800
customer order: creation 174.00 370 20880
customer order: refuse 14.76 356 1771
order to supplier: creation 47.38 1236 5685
order to supplier: removal 3.48 100631 417
invoice (draft): creation 46.54 3307 5585
invoice (draft): removal 53.61 773 6433
invoice accept: apply 42.81 16692 5137
invoice accept: cancel 48.36 786 5803
customer reserve: creation 3933.26 165 471991
customer reserve: removal 4781.64 57 573797
realization accept: apply 84.68 161 10162
realization accept: cancel 84.22 111 10106
payment from customer: creation 61.38 114 7366
payment from customer: removal 5.93 64 712
payment to supplier: creation 50.10 121 6012
payment to supplier: removal 3.59 87 431
service: total inventory turnovers 4.90 972 588
service: total monetary turnovers 6.78 22 814
service: aggregate perf. data 0.88 19464 106
service: refresh index statistics 0.03 327191 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-02-2021 19:28:08 to 08-02-2021 19:28:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8510
TEST_TIME 2 4747
TEST_TIME 3 4532
TEST_TIME 4 5045
TEST_TIME 5 5210
TEST_TIME 6 5356
TEST_TIME 7 5102
TEST_TIME 8 5474
TEST_TIME 9 5517
TEST_TIME 10 5556
TEST_TIME 11 5512
TEST_TIME 12 5674
TEST_TIME 13 5861
TEST_TIME 14 6049
TEST_TIME 15 6170
TEST_TIME 16 6527
TEST_TIME 17 7229
TEST_TIME 18 7661
TEST_TIME 19 8148
TEST_TIME 20 8256
TEST_TIME 21 8263
TEST_TIME 22 8811
TEST_TIME 23 8794
TEST_TIME 24 8866
TEST_TIME 25 9415
TEST_TIME 26 9960
TEST_TIME 27 10099
TEST_TIME 28 10242
TEST_TIME 29 10927
TEST_TIME 30 10694
TEST_TIME 31 10626
TEST_TIME 32 10375
TEST_TIME 33 10561
TEST_TIME 34 10485
TEST_TIME 35 10532
TEST_TIME 36 10515
TEST_TIME 37 10300
TEST_TIME 38 10238
TEST_TIME 39 10203
TEST_TIME 40 10128
TEST_TIME 41 10039
TEST_TIME 42 9983
TEST_TIME 43 9820
TEST_TIME 44 9991
TEST_TIME 45 9873
TEST_TIME 46 9988
TEST_TIME 47 9981
TEST_TIME 48 10012
TEST_TIME 49 10084
TEST_TIME 50 10082
TEST_TIME 51 10117
TEST_TIME 52 10171
TEST_TIME 53 10113
TEST_TIME 54 10084
TEST_TIME 55 10008
TEST_TIME 56 10067
TEST_TIME 57 10092
TEST_TIME 58 9923
TEST_TIME 59 9891
TEST_TIME 60 9788
TEST_TIME 61 9810
TEST_TIME 62 9735
TEST_TIME 63 9665
TEST_TIME 64 9626
TEST_TIME 65 9571
TEST_TIME 66 9537
TEST_TIME 67 9524
TEST_TIME 68 9532
TEST_TIME 69 9583
TEST_TIME 70 9560
TEST_TIME 71 9547
TEST_TIME 72 9572
TEST_TIME 73 9605
TEST_TIME 74 9682
TEST_TIME 75 9646
TEST_TIME 76 9611
TEST_TIME 77 9651
TEST_TIME 78 9634
TEST_TIME 79 9688
TEST_TIME 80 9633
TEST_TIME 81 9605
TEST_TIME 82 9554
TEST_TIME 83 9536
TEST_TIME 84 9459
TEST_TIME 85 9386
TEST_TIME 86 9399
TEST_TIME 87 9469
TEST_TIME 88 9440
TEST_TIME 89 9430
TEST_TIME 90 9440
TEST_TIME 91 9425
TEST_TIME 92 9394
TEST_TIME 93 9441
TEST_TIME 94 9526
TEST_TIME 95 9516
TEST_TIME 96 9487
TEST_TIME 97 9620
TEST_TIME 98 9625
TEST_TIME 99 9634
TEST_TIME 100 9713
TEST_TIME 101 9715
TEST_TIME 102 9660
TEST_TIME 103 9594
TEST_TIME 104 9620
TEST_TIME 105 9587
TEST_TIME 106 9584
TEST_TIME 107 9578
TEST_TIME 108 9530
TEST_TIME 109 9501
TEST_TIME 110 9455
TEST_TIME 111 9419
TEST_TIME 112 9432
TEST_TIME 113 9436
TEST_TIME 114 9425
TEST_TIME 115 9514
TEST_TIME 116 9479
TEST_TIME 117 9493
TEST_TIME 118 9459
TEST_TIME 119 9510
TEST_TIME 120 9453

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 08-02-2021 19:28:11 to 08-02-2021 19:28:15.

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 1570679 1570679 0 0.00 0 29826 6 0 0
doc_list_biud 1570679 1570679 0 0.00 0 71223 26 0 0
sp_add_invoice_to_stock 5247 5137 110 2.09 45 162074 16693 0 110
sp_cancel_adding_invoice 5803 5803 0 0.00 6 69384 786 0 0
sp_cancel_client_order 1771 1771 0 0.00 3 16157 357 0 0
sp_cancel_customer_reserve 573797 573797 0 0.00 1 71227 57 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 3 3605 64 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 2 4321 88 0 0
sp_cancel_supplier_invoice 6442 6433 9 0.13 1 14980 773 0 9
sp_cancel_supplier_order 417 417 0 0.00 7 1129292 100631 0 0
sp_cancel_write_off 10106 10106 0 0.00 1 13963 112 0 0
sp_client_order 20880 20880 0 0.00 3 70873 371 0 0
sp_customer_reserve 471991 471991 0 0.00 0 45406 166 0 0
sp_fill_shopping_cart 32143 32143 0 0.00 1 11762 40 0 0
sp_fill_shopping_cart_clo_res 471987 471987 0 0.00 0 17142 15 0 0
sp_get_clo_for_invoice 5129 5129 0 0.00 0 38631 302 0 0
sp_kill_cost_storno 17052 17052 0 0.00 0 11640 55 0 0
sp_kill_qstorno_ret_qs2qd 1164550 1164550 0 0.00 0 71158 31 0 0
sp_kill_qty_storno 613618 613618 0 0.00 0 71223 67 0 0
sp_lock_selected_doc 21188 21188 0 0.00 0 8143 5 0 0
sp_make_cost_storno 28669 28669 0 0.00 0 16091 47 0 0
sp_multiply_rows_for_pdistr 28669 28669 0 0.00 0 11239 28 0 0
sp_multiply_rows_for_qdistr 20880 20880 0 0.00 0 70821 176 0 0
sp_pay_from_customer 7366 7366 0 0.00 4 19083 114 0 0
sp_pay_to_supplier 6012 6012 0 0.00 5 17621 121 0 0
sp_payment_common 13378 13378 0 0.00 1 18648 31 0 0
sp_qd_handle_on_cancel_clo 1771 1771 0 0.00 0 16147 325 0 0
sp_qd_handle_on_invoice_upd_sts 10932 10932 0 0.00 0 30856 316 0 0
sp_qd_handle_on_reserve_upd_sts 10162 10162 0 0.00 0 15626 56 0 0
sp_reserve_write_off 10162 10162 0 0.00 6 16417 162 0 0
sp_supplier_invoice 5585 5585 0 0.00 7 100427 3308 0 0
sp_supplier_order 5685 5685 0 0.00 5 93583 1237 0 0
srv_aggregate_perf_data 106 106 0 0.00 2550 360463 19465 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 850 200339 32845 0 0
srv_find_qd_qs_mism 1084892 1084892 0 0.00 0 29807 5 0 0
srv_make_invnt_saldo 588 588 0 0.00 40 40871 972 0 0
srv_make_money_saldo 814 814 0 0.00 0 1364 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 261218 410786 327191 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5137 5137 0 0.00 0 14062 136 0 0
t$perf-norm:sp_cancel_adding_invoice 414 414 0 0.00 0 4607 85 0 0
t$perf-norm:sp_cancel_client_order 1771 1771 0 0.00 0 2566 10 0 0
t$perf-norm:sp_cancel_customer_reserve 684 684 0 0.00 0 512 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 712 712 0 0.00 0 2781 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 395 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 384 384 0 0.00 0 752 9 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 45453 1504 0 0
t$perf-norm:sp_cancel_write_off 1084 1084 0 0.00 0 493 4 0 0
t$perf-norm:sp_client_order 20880 20880 0 0.00 0 13140 15 0 0
t$perf-norm:sp_customer_reserve 1029 1029 0 0.00 0 962 5 0 0
t$perf-norm:sp_pay_from_customer 7366 7366 0 0.00 0 6060 9 0 0
t$perf-norm:sp_pay_to_supplier 6012 6012 0 0.00 0 4226 7 0 0
t$perf-norm:sp_reserve_write_off 10162 10162 0 0.00 0 6953 9 0 0
t$perf-norm:sp_supplier_invoice 5585 5585 0 0.00 0 8665 17 0 0
t$perf-norm:sp_supplier_order 5685 5685 0 0.00 0 5912 15 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 168 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 159 3 0 0
t$perf-norm:srv_make_invnt_saldo 588 588 0 0.00 0 6453 28 0 0
t$perf-norm:srv_make_money_saldo 814 814 0 0.00 0 5703 29 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10478 10258 220 2.09 0 4955 18 0 220
v_all_customers 38334 38334 0 0.00 0 29 1 0 0
v_all_suppliers 31128 31128 0 0.00 0 28 1 0 0
v_all_wares 41760 41760 0 0.00 0 60 1 0 0
v_cancel_adding_invoice 828 828 0 0.00 0 5599 15 0 0
v_cancel_client_order 3542 3542 0 0.00 0 4375 7 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 1109 5 0 0
v_cancel_customer_reserve 1368 1368 0 0.00 0 1601 7 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 2919 10 0 0
v_cancel_supplier_invoice 786 768 18 2.29 0 941 16 0 18
v_cancel_supplier_order 834 834 0 0.00 0 1830 8 0 0
v_cancel_write_off 2168 2168 0 0.00 0 2060 15 0 0
v_max_id_clo_ord 5684 5684 0 0.00 0 165 1 0 0
v_max_id_clo_res 1029 1029 0 0.00 0 1937 20 0 0
v_max_id_ord_sup 5579 5579 0 0.00 0 5074 5 0 0
v_max_non_paid_invoice 1711 1711 0 0.00 0 258 2 0 0
v_max_non_paid_realizn 3880 3880 0 0.00 0 1180 3 0 0
v_min_id_clo_ord 5684 5684 0 0.00 0 10128 6 0 0
v_min_id_clo_res 1029 1029 0 0.00 0 3056 14 0 0
v_min_id_ord_sup 5579 5579 0 0.00 0 6034 6 0 0
v_min_non_paid_invoice 6012 6012 0 0.00 0 16893 20 0 0
v_min_non_paid_realizn 7366 7366 0 0.00 0 11205 22 0 0
v_our_firm 10398 10398 0 0.00 0 19 1 0 0
v_reserve_write_off 20324 20324 0 0.00 0 4353 6 0 0
x_lock_depdocs_on_canc_invoice 11852 11852 0 0.00 0 10580 102 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 28540 367 0 0
x_make_qstorno_1000_1200 5685 5685 0 0.00 2 93551 1162 0 0
x_make_qstorno_1200_2000 5585 5585 0 0.00 3 100324 3155 0 0
x_make_qstorno_2100_3300 471991 471991 0 0.00 0 45405 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-02-2021 19:28:16 to 08-02-2021 19:28:20.

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
16:57:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:27 17655 8192000000 10244680304 10546831360 886612928 9.765 70 59 121 0 909303600 2454288 20236384
16:57:53 42711 8192000000 10345795184 10662719488 1380899296 14.425 100 87 174 0 1414324688 5051696 28373696
16:58:47 32563 8192000000 10386340016 10716852224 1435915152 14.914 100 82 164 2 1469511104 7039216 26556736
16:59:31 15799 8192000000 10404041712 10739343360 1467451264 15.191 100 80 160 1 1500282848 7249760 25581824
16:59:55 19745 8192000000 10457933488 10791579648 1498766864 15.465 100 88 176 0 1534551104 7834752 27949488
17:00:24 12108 8192000000 10472004800 10811625472 1534738272 15.778 100 89 178 0 1571158928 8631632 27789024
17:00:47 12848 8192000000 10488988416 10828832768 1545460944 15.871 100 90 180 0 1583423520 9627392 28335184
17:01:08 20428 8192000000 10505044992 10854526976 1561553600 16.010 100 87 173 1 1598056080 10081504 26420976
17:01:40 19044 8192000000 10519734800 10873896960 1576081792 16.135 100 75 150 1 1609189216 10108928 22998496
17:02:09 21157 8192000000 10547393072 10901037056 1602959824 16.365 100 86 171 1 1639728688 10740576 26028288
17:02:40 14375 8192000000 10563122992 10919833600 1620451840 16.514 100 84 168 0 1656803280 11120656 25230784
17:03:03 11541 8192000000 10580294816 10941874176 1637428288 16.658 100 78 156 0 1672338992 11056704 23854000
17:03:26 12627 8192000000 10586538192 10955415552 1652712464 16.787 100 78 154 1 1687009184 11478384 22818336
17:03:49 12996 8192000000 10609234208 10980286464 1672226336 16.952 100 76 152 1 1706327344 11799088 22301920
17:04:10 9069 8192000000 10634416304 11006390272 1701915968 17.201 100 74 146 4 1734173872 11654736 20603168
17:04:29 9930 8192000000 10655644896 11028291584 1711019184 17.277 100 75 150 2 1744794288 12406544 21368560
17:04:47 5711 8192000000 10672401792 11045240832 1728736080 17.425 100 84 168 0 1765998064 13189040 24072944
17:05:00 5680 8192000000 10690390544 11068276736 1744332352 17.555 100 73 145 1 1777015216 12460576 20222288
17:05:14 7158 8192000000 10704720096 11083030528 1764844912 17.724 100 77 154 3 1799245184 12512544 21887728
17:05:28 4460 8192000000 10705734960 11087515648 1772460608 17.787 100 76 152 0 1806539008 13280144 20798256
17:05:40 3596 8192000000 10730132864 11112058880 1789960640 17.931 100 87 174 0 1826992448 13109472 23922336
17:05:50 6416 8192000000 10728821568 11107971072 1788806624 17.922 100 77 154 1 1823588000 13115040 21666336
17:06:03 4151 8192000000 10728230848 11112185856 1795730768 17.979 100 84 167 0 1832614160 13760512 23122880
17:06:14 3241 8192000000 10727564624 11112386560 1801289472 18.024 100 88 174 3 1840221872 14662816 24269584
17:06:24 5767 8192000000 10740743344 11124789248 1800029904 18.014 100 81 161 2 1835391344 13662688 21698752
17:06:39 3853 8192000000 10761412352 11140792320 1816972064 18.153 100 86 172 1 1855039360 14389152 23678144
17:06:50 4168 8192000000 10764122288 11150237696 1820320432 18.180 100 82 164 0 1858333136 14257488 23755216
17:07:01 2712 8192000000 10765131424 11151339520 1828173120 18.244 100 90 182 0 1868450480 14749200 25528160
17:07:10 1577 8192000000 10775947168 11158454272 1833550768 18.288 100 87 172 0 1871689120 14335200 23803152
17:07:18 2081 8192000000 10772285760 11160203264 1835747104 18.306 100 99 199 1 1878684864 14458608 28479152
17:07:26 2195 8192000000 10784949584 11170775040 1841580336 18.354 100 89 178 3 1879803760 13126512 25096912
17:07:34 2886 8192000000 10797124368 11183575040 1847832160 18.405 100 93 185 3 1887964048 14061552 26070336
17:07:44 2059 8192000000 10794070464 11181268992 1847947840 18.405 100 91 185 0 1888474368 14707584 25818944
17:07:52 1614 8192000000 10791791712 11182260224 1852356768 18.441 100 92 184 3 1893119984 14078128 26685088
17:08:00 1937 8192000000 10797427648 11185127424 1852311152 18.441 100 93 185 2 1893442272 14543392 26587728
17:08:08 14639 8192000000 10781935744 11175514112 1850669904 18.428 100 72 144 2 1882269616 11191808 20407904
17:08:29 1453 8192000000 10792631504 11190099968 1856992944 18.479 100 82 166 0 1892904896 12568080 23343872
17:08:37 1860 8192000000 10786599504 11190059008 1856016336 18.471 100 66 132 0 1886162928 11856400 18290192
17:08:45 2949 8192000000 10778376000 11187286016 1858476928 18.491 100 55 110 1 1883481408 9845040 15159440
17:08:55 4178 8192000000 10763696032 11181625344 1851578960 18.435 100 37 74 1 1870974240 9234928 10160352
17:09:06 2944 8192000000 10764992608 11186135040 1855545040 18.467 100 30 60 0 1871727872 8002304 8180528
17:09:18 5641 8192000000 10778443264 11192242176 1864732544 18.542 100 51 102 0 1886679616 6619280 15327792
17:10:07 26190 8192000000 10772643808 11201179648 1864303584 18.538 100 37 74 0 1881629120 5861136 11464400
17:10:42 6861 8192000000 10779468656 11208122368 1866789776 18.558 100 34 68 0 1884265152 7910352 9565024
17:10:58 7989 8192000000 10782449408 11206303744 1867769824 18.566 100 26 52 2 1882095632 6840832 7484976
17:11:12 6771 8192000000 10780769424 11205959680 1867752592 18.566 100 25 50 1 1882050544 7451664 6846288
17:11:26 4590 8192000000 10790134608 11212771328 1871603392 18.597 100 38 75 2 1889817136 6906784 11306960
17:11:37 4398 8192000000 10788091696 11212513280 1872700672 18.606 100 31 60 0 1887495376 6576128 8218576
17:11:47 7174 8192000000 10803150272 11218579456 1874213200 18.618 100 30 60 0 1889409024 6976016 8219808
17:12:01 5688 8192000000 10793199984 11218280448 1879405456 18.660 100 30 60 2 1894203744 6132592 8665696
17:12:13 15509 8192000000 10786532576 11218227200 1876613536 18.638 100 11 22 2 1885164592 5661264 2889792
17:12:39 8148 8192000000 10794765472 11225321472 1885584592 18.710 100 23 46 1 1897870080 5178464 7107024
17:12:54 8870 8192000000 10796211120 11231326208 1888269456 18.732 100 34 69 3 1905672208 7790288 9612464
17:13:12 5875 8192000000 10793488736 11229323264 1886633744 18.719 100 19 37 2 1897704256 5569600 5500912
17:13:26 10984 8192000000 10795272288 11230461952 1887055920 18.722 100 20 40 1 1899157616 6502416 5599280
17:13:43 11676 8192000000 10799097456 11234844672 1891521936 18.758 100 19 37 1 1902464416 5823360 5119120
17:14:02 50172 8192000000 10808590400 11247108096 1898302496 18.813 100 20 40 1 1909685888 5132528 6250864
17:15:14 16586 8192000000 10801844144 11242381312 1895948896 18.794 100 16 32 1 1906422240 5844096 4629248
17:15:37 7597 8192000000 10824633776 11254947840 1901122720 18.835 100 31 61 1 1915977696 6388672 8466304
17:15:53 7426 8192000000 10825278672 11254607872 1901580560 18.839 100 33 65 0 1917495792 6484976 9430256
17:16:07 8570 8192000000 10823556144 11251548160 1882103568 18.682 99 32 64 3 1898194240 7011824 9078848
17:16:22 3733 8192000000 10816163904 11248943104 1896630800 18.799 100 32 64 1 1912695376 6456688 9607888
17:16:35 6991 8192000000 10803347328 11243782144 1893700544 18.776 100 22 44 1 1904932752 5620448 5611760
17:16:51 5842 8192000000 10816703008 11241091072 1889746960 18.744 100 26 52 2 1903002160 5648880 7606320
17:17:04 5895 8192000000 10819083280 11244687360 1895502336 18.790 100 30 60 2 1910884240 6682640 8699264
17:17:16 4700 8192000000 10824819008 11255414784 1898224816 18.812 100 27 54 1 1916545392 11115536 7205040
17:17:29 6033 8192000000 10804059200 11232702464 1884723280 18.703 100 22 45 0 1897146032 5488192 6934560
17:17:41 6259 8192000000 10773811232 11201564672 1795250784 17.975 95 23 46 1 1807856272 5925904 6679584
17:17:55 10682 8192000000 10777528528 11203596288 1825579696 18.223 98 22 43 2 1837670016 5348096 6742224
17:18:13 9839 8192000000 10747178416 11172745216 1772822464 17.790 95 22 44 0 1784900320 6009248 6068608
17:18:31 7669 8192000000 10727028080 11140067328 1747731568 17.583 95 22 44 1 1759726592 5272784 6722240
17:18:46 50504 8192000000 10720626128 11131695104 1748700400 17.591 96 22 45 0 1761809824 4869664 8239760
17:19:43 28285 8192000000 10668694528 11086024704 1598622528 16.328 88 16 32 2 1607848448 4359776 4866144
17:20:17 7555 8192000000 10672890576 11079630848 1710510416 17.273 96 35 70 0 1727172080 6473504 10188160
17:20:31 6674 8192000000 10681679536 11092701184 1707487936 17.248 95 29 58 0 1725765040 9398432 8878672
17:20:47 4653 8192000000 10710445120 11112103936 1762471728 17.705 99 31 63 2 1785993904 14257776 9264400
17:21:00 6663 8192000000 10711830432 11123507200 1779737552 17.847 99 30 60 2 1799427056 11281040 8408464
17:21:13 3758 8192000000 10711548064 11124174848 1794946064 17.972 100 38 72 2 1812809024 7129136 10733824
17:21:23 9009 8192000000 10727884352 11142389760 1799462144 18.009 100 32 64 3 1815196784 6049520 9685120
17:21:40 7113 8192000000 10711597168 11123748864 1760157312 17.686 98 24 48 0 1777038544 9789136 7092096
17:21:56 8680 8192000000 10715140864 11129327616 1769698144 17.765 98 22 44 1 1782002272 6164288 6139840
17:22:15 7462 8192000000 10747743904 11157413888 1815800704 18.143 100 25 50 2 1828999040 5721472 7476864
17:22:30 8477 8192000000 10735574656 11157262336 1815226384 18.139 100 38 76 1 1833029984 6614224 11189376
17:22:46 7726 8192000000 10727940720 11155513344 1808577104 18.084 99 20 40 2 1819162944 4827440 5758400
17:23:00 10942 8192000000 10737097776 11163369472 1825256480 18.221 100 23 46 0 1838132704 5954320 6921904
17:23:17 62857 8192000000 10752708192 11174731776 1833687440 18.289 100 22 44 0 1849812736 9639328 6485968
17:24:26 18159 8192000000 10739188624 11171545088 1819372224 18.173 99 18 36 3 1831576976 6009056 6195696
17:24:50 8807 8192000000 10755637488 11180539904 1839915264 18.340 100 20 40 0 1854482640 9759552 4807824
17:25:05 11793 8192000000 10768714640 11189305344 1847900448 18.405 100 34 68 0 1865076048 7771776 9403824
17:25:24 4253 8192000000 10766179760 11198734336 1851849440 18.437 100 43 86 1 1875843696 11863968 12130288
17:25:35 7062 8192000000 10776730112 11192958976 1852684016 18.444 100 26 49 6 1864943872 5027952 7231904
17:25:49 7980 8192000000 10786423840 11204513792 1855984752 18.471 100 26 50 3 1869101376 5838848 7277776
17:26:04 7524 8192000000 10778100256 11205562368 1864745840 18.542 100 28 55 2 1878180752 5443472 7991440
17:26:21 9078 8192000000 10782268256 11208912896 1866906576 18.559 100 22 45 0 1879282880 5820080 6556224
17:26:38 9236 8192000000 10787950080 11210526720 1868376192 18.571 100 31 62 1 1883347360 5687376 9283792
17:26:58 8887 8192000000 10799387296 11223445504 1872253408 18.603 100 33 66 4 1887576656 5725216 9598032
17:27:15 7456 8192000000 10802673280 11231293440 1887418896 18.725 100 13 25 2 1896230272 4616128 4195248
17:27:40 40382 8192000000 10840635760 11265363968 1910790784 18.913 100 41 82 1 1930077648 7353088 11933776
17:28:34 66925 8192000000 10845654960 11276701696 1921948160 19.002 100 41 82 1 1941328416 7763552 11616704
17:29:47 82938 8192000000 10847566080 11291226112 1925405424 19.030 100 25 50 1 1941258512 9008800 6844288
17:31:20 49133 8192000000 10878893824 11299852288 1923527360 19.015 99 46 93 2 1947067680 9281344 14258976
17:32:24 14293 8192000000 10881867712 11306622976 1946876768 19.202 100 48 96 0 1974342000 14123776 13341456
17:32:46 1376 8192000000 10892204448 11305689088 1940960208 19.154 99 68 136 3 1972994944 12038832 19995904
17:32:54 6486 8192000000 10893662576 11318669312 1957180704 19.284 100 59 118 0 1987031968 12753840 17097424
17:33:09 7727 8192000000 10893232992 11321892864 1958614768 19.295 100 59 116 0 1986872656 12024144 16233744
17:33:25 5454 8192000000 10894405392 11323179008 1963443632 19.333 100 61 121 1 1993780080 12934496 17401952
17:33:38 19252 8192000000 10900205328 11329368064 1966445536 19.357 100 55 108 2 1994588352 12115392 16027424
17:34:05 40769 8192000000 10912072080 11348905984 1973992288 19.417 100 55 110 1 2003942160 13828448 16121424
17:35:02 21260 8192000000 10916281328 11355033600 1978062320 19.449 100 44 86 1 2007638016 16415808 13159888
17:35:31 12591 8192000000 10925519568 11360428032 1987223680 19.522 100 43 86 0 2015388256 14952016 13212560
17:35:52 8293 8192000000 10932187680 11367186432 1992737856 19.565 100 48 95 0 2022355600 15015680 14602064
17:36:08 4215 8192000000 10942246032 11373182976 1997298896 19.601 100 58 116 0 2029754560 15412224 17043440
17:36:20 6039 8192000000 10936769888 11363655680 1976559856 19.437 99 64 128 0 2012907488 17174304 19173328
17:36:40 3354 8192000000 10934508992 11365122048 1991271088 19.554 100 67 132 2 2029385056 18725072 19388896
17:36:51 8966 8192000000 10945461504 11374071808 1995995440 19.591 100 64 128 0 2034694032 19967760 18730832
17:37:11 4316 8192000000 10961571120 11391590400 2002646560 19.644 100 55 109 0 2041021360 22041472 16333328
17:37:27 4136 8192000000 10971281728 11400478720 2010040112 19.702 100 67 133 2 2058666000 28822384 19803504
17:37:39 3597 8192000000 10964365648 11394183168 2013077584 19.726 100 66 133 1 2053712352 21130288 19504480
17:37:50 10867 8192000000 10958637968 11392937984 2012704432 19.723 100 54 108 0 2050602896 21391744 16506720
17:38:08 13157 8192000000 10953250528 11387076608 1993250656 19.569 99 60 120 1 2033543488 22577424 17715408
17:38:37 9154 8192000000 10970737072 11401019392 2015797184 19.747 100 61 121 2 2057619712 23963072 17859456
17:38:59 9458 8192000000 10970573984 11402489856 2003586976 19.651 99 53 106 1 2046205760 26326320 16292464
17:39:17 6194 8192000000 10968244864 11402158080 2002129776 19.640 99 63 125 2 2049034368 27249952 19654640
17:39:32 3478 8192000000 10977337488 11409182720 2016665632 19.754 100 58 116 3 2063473808 28905824 17902352
17:39:43 3167 8192000000 10987288848 11417735168 2020873952 19.787 100 65 126 2 2073498800 33402608 19222240
17:39:53 3715 8192000000 10997372784 11426680832 2033444864 19.886 100 75 148 4 2086675392 30519536 22710992
17:40:06 6122 8192000000 10993369248 11431788544 2031376944 19.869 100 70 140 2 2084534688 32171712 20986032
17:40:20 4945 8192000000 10978509776 11413426176 2020553872 19.785 100 58 116 2 2068017376 29322320 18141184
17:40:33 1856 8192000000 10969671520 11393699840 1984517312 19.500 98 73 146 1 2037606608 30099328 22989968
17:40:42 2981 8192000000 10994701776 11417079808 2019659952 19.777 100 76 151 0 2079477664 36282784 23534928
17:40:58 8784 8192000000 10999002528 11434188800 2025454192 19.823 100 63 126 2 2079392848 34220720 19717936
17:41:14 4207 8192000000 10991073600 11413491712 2011179744 19.711 99 76 150 3 2070781184 36597792 23003648
17:41:25 5521 8192000000 11002507552 11432116224 2027441520 19.839 100 77 151 1 2091908544 40567152 23899872
17:41:43 4392 8192000000 11017798480 11440668672 2033571680 19.887 100 84 165 1 2097890144 38327984 25990480
17:41:55 5171 8192000000 11002477504 11427278848 2024613072 19.816 100 83 164 1 2089091664 39012208 25466384
17:42:07 2225 8192000000 11016277312 11436756992 2030571536 19.863 100 88 174 0 2095852160 39022800 26257824
17:42:17 2263 8192000000 10993281968 11416383488 2008127472 19.687 99 82 162 1 2074996224 41762208 25106544
17:42:27 1348 8192000000 11011057840 11428478976 2021066432 19.789 100 86 170 1 2094288832 47232720 25989680
17:42:35 4936 8192000000 11014626032 11438112768 2026682864 19.833 100 82 162 2 2099911392 46755552 26472976
17:42:46 2134 8192000000 11006387824 11426574336 2015578960 19.745 100 83 166 1 2085503344 44040576 25883808
17:42:56 5916 8192000000 10995048832 11421216768 2012650272 19.722 100 76 152 3 2082614384 45450368 24513744
17:43:12 3506 8192000000 11003652240 11427618816 2016113008 19.750 100 74 148 1 2084681792 44928304 23640480
17:43:25 3642 8192000000 11012622368 11431452672 2002956752 19.646 99 79 158 0 2075795776 47356784 25482240
17:43:36 4327 8192000000 11009883376 11435864064 2016465920 19.752 100 73 146 1 2087483104 47084432 23932752
17:43:47 1683 8192000000 11014356656 11433111552 2014499680 19.737 100 91 182 0 2093775712 49627056 29648976
17:43:55 1664 8192000000 11002617632 11415670784 1990983744 19.552 99 93 184 2 2068161680 48439952 28737984
17:44:05 1719 8192000000 10987311920 11408527360 1992626240 19.565 100 82 161 1 2066663312 48553264 25483808
17:44:18 1671 8192000000 10995583968 11410694144 1997370096 19.602 100 93 187 2 2076654816 49948000 29336720
17:44:29 1685 8192000000 10989148272 11401736192 1987037248 19.520 100 93 186 0 2069299984 53177440 29085296
17:44:39 846 8192000000 10982739040 11395391488 1977936976 19.448 100 90 180 0 2059918848 53010672 28971200
17:44:48 1860 8192000000 10962956704 11375722496 1963814256 19.336 100 88 176 2 2044139424 51431040 28894128
17:44:56 3467 8192000000 10968943856 11400040448 1983019952 19.489 100 70 140 0 2060229744 54233024 22976768
17:45:19 7120 8192000000 10935547760 11373248512 1949987296 19.226 99 41 81 1 2007492336 43887264 13617776
17:45:37 7698 8192000000 10934448048 11363213312 1939249744 19.141 99 52 103 1 2002977072 46853328 16874000
17:45:52 5896 8192000000 10916127264 11345858560 1935722912 19.113 99 50 100 2 1997265840 45087360 16455568
17:46:05 11160 8192000000 10930587664 11365822464 1947094000 19.203 100 55 108 1 2012117712 48037200 16986512
17:46:22 17057 8192000000 10906435328 11349458944 1913522688 18.935 98 38 76 2 1969845120 43536336 12786096
17:46:50 4262 8192000000 10939686720 11367342080 1957008016 19.282 100 67 134 1 2024400800 46341120 21051664
17:47:04 6987 8192000000 10915717008 11347755008 1929026192 19.059 99 46 92 0 1986751840 43459488 14266160
17:47:20 8647 8192000000 10896760176 11332943872 1896441408 18.798 98 54 106 0 1956831936 43885008 16505520
17:47:58 8780 8192000000 10882425104 11319005184 1910795216 18.913 99 40 80 0 1967364368 44231456 12337696
17:48:13 13990 8192000000 10876601968 11324760064 1900697504 18.832 99 27 54 2 1953020000 42728368 9594128
17:48:36 6598 8192000000 10856498112 11280842752 1855497008 18.467 97 42 84 0 1914161264 45309040 13355216
17:48:57 2552 8192000000 10885493168 11306307584 1901112512 18.835 100 51 102 0 1966141712 48373776 16655424
17:49:23 14849 8192000000 10879535568 11330199552 1915329072 18.949 100 31 62 0 1971079696 45368256 10382368
17:49:53 17061 8192000000 10885846112 11331948544 1904842016 18.865 99 25 50 4 1957167728 44213584 8112128
17:50:28 8948 8192000000 10901396608 11341217792 1927234352 19.045 100 40 78 3 1988327584 48243872 12849360
17:50:44 16218 8192000000 10911004048 11353755648 1930448752 19.070 100 25 50 1 1986750016 47580160 8721104
17:51:06 20928 8192000000 10911752800 11354337280 1917617584 18.968 99 26 52 0 1974841664 48353168 8870912
17:51:40 21426 8192000000 10897782320 11337584640 1894149488 18.779 98 25 50 0 1956147296 53208256 8789552
17:52:08 25161 8192000000 10911300640 11364065280 1916108208 18.956 99 24 48 2 1979590592 55083728 8398656
17:52:39 30377 8192000000 10890068912 11348398080 1914033728 18.939 99 25 50 1 1977670960 54805040 8832192
17:53:27 18172 8192000000 10860627248 11322884096 1898762112 18.816 99 21 42 1 1936420128 30664976 6993040
17:54:24 60911 8192000000 10857235696 11309387776 1859857344 18.502 97 18 36 4 1896149488 30077392 6214752
17:55:32 19078 8192000000 10831132304 11291381760 1842659568 18.362 97 8 16 0 1878615440 32600656 3355216
17:56:00 32816 8192000000 10825570464 11298529280 1889192352 18.739 100 9 18 0 1925762688 33296736 3273600
17:56:41 71459 8192000000 10857310176 11301453824 1877639488 18.646 98 21 40 1 1891819104 8246160 5933456
17:58:04 200339 8192000000 10877268064 11335061504 1938920800 19.138 100 21 42 2 1957672704 12892336 5859568
18:02:11 50606 8192000000 10868127520 11340185600 1942954448 19.170 100 34 68 2 1969253984 17036064 9263472
18:03:13 34772 8192000000 10865320432 11321475072 1907209360 18.884 98 11 22 0 1922462144 12030352 3222432
18:03:56 66311 8192000000 10877478016 11339714560 1918711360 18.977 99 15 30 2 1934256848 11105488 4440000
18:05:09 45713 8192000000 10878696080 11340693504 1938282368 19.133 99 57 114 1 1969996528 14254704 17459456
18:06:07 31911 8192000000 10908480272 11346944000 1936708384 19.120 99 44 86 2 1964186000 14124608 13353008
18:06:51 47347 8192000000 10904268016 11364847616 1963389744 19.333 100 30 59 2 1986833920 14581696 8862480
18:07:48 67242 8192000000 10902299344 11373170688 1969370864 19.380 100 14 27 0 1993721408 20366448 3984096
18:09:02 71026 8192000000 10903678912 11377623040 1970689664 19.391 100 12 24 0 1995543488 21299328 3554496
18:10:19 31954 8192000000 10903861504 11371421696 1975267632 19.427 100 11 22 1 1998842544 20252032 3322880
18:10:57 42521 8192000000 10892133328 11376861184 1951519696 19.239 99 12 24 0 1979698656 24282864 3896096
18:11:46 32911 8192000000 10901361680 11374694400 1955196416 19.268 99 14 28 1 1973822544 14903632 3722496
18:12:30 47764 8192000000 10917347904 11380269056 1973493328 19.413 100 25 50 0 1998575520 17149248 7932944
18:13:34 43141 8192000000 10911893760 11388350464 1984038432 19.497 100 20 40 2 2004994224 14701824 6253968
18:14:31 81124 8192000000 10895977248 11364311040 1953065168 19.251 98 27 55 1 1971250832 10006672 8178992
18:15:59 87890 8192000000 10908008256 11397017600 1980453808 19.468 100 11 21 0 1997380080 13389168 3537104
18:17:33 39876 8192000000 10953894672 11404771328 2007390000 19.681 100 33 67 1 2026248656 9315696 9542960
18:18:19 37531 8192000000 10929330016 11397242880 1978275824 19.451 99 18 36 0 1991756208 8793664 4686720
18:19:03 84922 8192000000 10920463520 11399278592 1958531888 19.294 98 15 30 1 1973525104 10511824 4481392
18:20:35 39562 8192000000 10916652496 11378241536 1955919552 19.274 98 10 19 2 1966348576 8108912 2320112
18:21:25 46397 8192000000 10921244640 11386454016 1973294448 19.412 99 24 47 3 1989014512 9610176 6109888
18:22:20 14387 8192000000 10934357792 11392819200 1996911056 19.598 100 32 64 3 2013405920 7829504 8665360
18:22:43 23228 8192000000 10928390096 11384299520 1959047168 19.298 98 44 87 1 1982989216 11532176 12409872
18:23:14 26438 8192000000 10929153296 11387453440 1973677696 19.415 99 33 66 0 1999300176 16439776 9182704
18:23:47 39802 8192000000 10925731424 11400327168 1944814016 19.185 98 20 38 1 1972489088 22515344 5159728
18:24:54 142749 8192000000 10916212096 11390435328 1990926960 19.551 100 16 32 0 2012720000 17271376 4521664
18:27:25 23930 8192000000 10913870560 11376828416 1983410640 19.492 99 20 40 1 1996224688 7379904 5434144
18:27:56 44611 8192000000 10926130736 11406049280 2003778560 19.653 100 29 58 1 2024711120 13286816 7645744
18:28:56 26621 8192000000 10877538768 11351859200 1914456688 18.942 96 14 28 1 1924116912 5889120 3771104
18:29:32 49888 8192000000 10891462976 11364704256 1941513392 19.159 98 10 20 1 1950759408 6301168 2944848
18:30:29 49116 8192000000 10874982720 11348385792 1942508880 19.167 99 11 23 1 1952229840 7136480 2584480
18:31:27 43196 8192000000 10856124704 11333906432 1894760032 18.784 96 6 12 0 1902186864 5598128 1828704
18:32:34 59221 8192000000 10879913040 11342995456 1869624240 18.581 95 10 19 0 1881264384 9606160 2033984
18:33:42 27366 8192000000 10883004448 11330199552 1883601040 18.694 96 34 67 2 1902575728 9681376 9293312
18:34:45 29293 8192000000 10861715440 11328421888 1930803184 19.073 100 28 57 1 1953734288 15157440 7773664
18:35:32 60135 8192000000 10829739712 11305766912 1825599280 18.223 94 17 35 0 1840895216 10376768 4919168
18:36:47 27707 8192000000 10862797616 11319021568 1902007232 18.842 98 24 46 1 1915047696 5991152 7049312
18:37:25 32492 8192000000 10862599536 11313041408 1885807536 18.712 97 37 74 2 1905389808 9367728 10214544
18:38:05 19591 8192000000 10845038000 11297980416 1866748864 18.558 97 38 76 1 1889305664 11933728 10623072
18:38:31 38430 8192000000 10863671328 11313836032 1888979680 18.738 98 34 67 0 1911394560 13015648 9399232
18:39:16 36438 8192000000 10867866160 11323777024 1895410096 18.789 98 28 56 0 1916576944 12783680 8383168
18:40:13 71545 8192000000 10852166240 11316961280 1855606336 18.468 96 27 54 2 1884443424 20693168 8143920
18:41:32 64891 8192000000 10855126912 11316068352 1886762976 18.720 98 15 30 1 1901688208 10737840 4187392
18:42:43 27577 8192000000 10863654720 11308957696 1872543792 18.605 97 29 58 1 1887853056 7517840 7791424
18:43:23 16124 8192000000 10868699536 11312975872 1906878080 18.882 99 46 92 0 1930391536 11008608 12504848
18:43:47 21577 8192000000 10880595152 11323138048 1930106720 19.068 100 41 80 1 1952643040 11488592 11047728
18:44:21 52297 8192000000 10865413840 11330203648 1913023312 18.931 99 30 60 3 1931918304 11006464 7888528
18:45:22 25541 8192000000 10862069648 11308650496 1881240960 18.675 97 30 60 2 1898407200 8319536 8846704
18:45:59 19403 8192000000 10849099008 11297906688 1872880320 18.608 97 41 82 1 1897147152 12751760 11515072
18:46:24 116970 8192000000 10838329568 11308367872 1874187408 18.618 98 16 32 1 1892656272 13992512 4476352
18:48:27 68782 8192000000 10852556512 11317878784 1906324528 18.877 99 15 30 1 1919254048 7930240 4999280
18:50:37 51698 8192000000 10862227984 11336196096 1941959872 19.162 100 10 20 0 1955903872 10958080 2985920
18:51:34 82606 8192000000 10867896960 11337760768 1917880144 18.970 98 19 38 1 1935295312 11745632 5669536
18:53:04 52969 8192000000 10872740272 11342929920 1949506224 19.223 100 12 22 1 1964827552 12276096 3045232
18:54:07 80370 8192000000 10876956944 11359977472 1947552576 19.207 100 7 14 0 1965302880 15894224 1856080
18:55:48 29328 8192000000 10888587328 11361603584 1963293376 19.332 100 26 52 1 1979087824 8094800 7699648
18:56:28 62824 8192000000 10873928832 11343183872 1944881840 19.186 99 17 34 0 1958357504 8820800 4654864
18:57:38 55026 8192000000 10901532304 11369029632 1956823008 19.281 99 24 48 0 1975183360 11490656 6869696
18:58:39 33975 8192000000 10916858464 11378745344 1945974160 19.194 98 27 54 2 1968938208 15394672 7569376
18:59:37 72216 8192000000 10916765840 11401687040 1986669872 19.517 100 11 22 1 2006604064 16788400 3145792
19:01:40 47588 8192000000 10929270400 11385774080 1971007440 19.393 99 31 61 1 1992302080 12325504 8969136
19:02:35 44356 8192000000 10938385152 11402829824 1977171776 19.442 99 37 75 1 2000308272 12761552 10374944
19:03:25 30950 8192000000 10949625568 11419332608 2002035728 19.639 100 34 68 2 2034834224 23191760 9606736
19:04:12 83272 8192000000 10925492864 11415216128 1928408448 19.054 97 12 24 1 1962473632 30488672 3576512
19:05:51 59126 8192000000 10908287104 11379961856 1926824048 19.041 97 16 32 0 1952057248 20910272 4322928
19:07:04 80046 8192000000 10906121648 11380125696 1960550832 19.310 99 11 22 1 1979007168 14971776 3484560
19:08:41 126109 8192000000 10937012480 11388010496 1974191088 19.419 99 35 71 0 1992359760 8660096 9508576
19:10:58 72853 8192000000 10933844304 11395276800 1971638224 19.398 99 20 40 1 1987951120 10603568 5709328
19:12:21 50538 8192000000 10928108608 11386687488 1970606128 19.390 99 23 45 1 1988410928 11460432 6344368
19:13:18 30338 8192000000 10892535328 11350155264 1933125888 19.092 97 23 46 1 1949844000 10229936 6488176
19:14:06 51087 8192000000 10899222976 11382738944 1955979232 19.274 99 10 20 0 1969774192 10477520 3317440
19:15:08 75212 8192000000 10915759184 11402244096 1987068256 19.521 100 4 8 0 2001507504 13481056 958192
19:16:33 43687 8192000000 10901628464 11381161984 1947979840 19.210 98 5 10 0 1965132144 15783216 1369088
19:18:18 73961 8192000000 10860328560 11343900672 1873516608 18.613 95 13 26 2 1887634032 10574192 3543232
19:19:39 36463 8192000000 10858550784 11329548288 1902132640 18.843 98 25 50 4 1916774208 7209616 7431952
19:20:22 24348 8192000000 10864804160 11320492032 1873989792 18.617 97 13 24 0 1887006832 9606032 3411008
19:20:53 74758 8192000000 10849896416 11319549952 1882484896 18.685 97 22 45 0 1900843760 12169040 6189824
19:22:14 69123 8192000000 10824136096 11298209792 1816326144 18.148 94 19 38 2 1838191664 16024848 5840672
19:23:38 65186 8192000000 10821584512 11287400448 1841218256 18.351 96 18 34 0 1854628048 8644720 4765072
19:24:50 33324 8192000000 10827119184 11284045824 1811392800 18.107 95 19 38 0 1823598400 7522992 4682608
19:25:32 24836 8192000000 10857443232 11299016704 1829969584 18.259 95 49 98 2 1855115232 11318800 13826848
19:26:04 80032 8192000000 9794922336 10146820096 884289184 9.742 46 8 16 0 895876384 9650496 1936704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 08-02-2021 19:28:22 to 08-02-2021 19:28:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 110 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-02-2021 19:28:54 to 08-02-2021 19:28:56.

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          242649
MON$OLDEST_ACTIVE               243616
MON$OLDEST_SNAPSHOT             243616
MON$NEXT_TRANSACTION            243616
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                       2025760
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:99: 
:100: mscs-test-161.budzdorov.ru    Mon Feb  8 19:27:29 2021
:101:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:102: 
--- end of diff output ---

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

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