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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17284848 kB
MemAvailable 31464064 kB
Buffers 0 kB
Cached 14411872 kB
SwapCached 100 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-04-07 01:27:26
DTS_END                         2021-04-07 01:27:26.1270
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/41408
TRN_ID                          240218
ATT_ID                          646
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: 9475.00 21429 1137000
customer order: creation 174.80 325 20976
customer order: refuse 14.96 389 1795
order to supplier: creation 46.07 1200 5528
order to supplier: removal 3.44 105232 413
invoice (draft): creation 46.50 3398 5580
invoice (draft): removal 52.92 788 6350
invoice accept: apply 42.09 17868 5051
invoice accept: cancel 48.13 830 5776
customer reserve: creation 4028.38 170 483405
customer reserve: removal 4713.41 60 565609
realization accept: apply 85.41 191 10249
realization accept: cancel 89.08 110 10690
payment from customer: creation 60.00 116 7200
payment from customer: removal 5.51 81 661
payment to supplier: creation 48.39 127 5807
payment to supplier: removal 3.73 56 447
service: total inventory turnovers 4.88 1030 586
service: total monetary turnovers 6.36 28 763
service: aggregate perf. data 0.92 15668 110
service: refresh index statistics 0.03 280914 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-04-2021 01:29:16 to 07-04-2021 01:29:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4036
TEST_TIME 2 3212
TEST_TIME 3 4828
TEST_TIME 4 4093
TEST_TIME 5 4249
TEST_TIME 6 5012
TEST_TIME 7 5084
TEST_TIME 8 5145
TEST_TIME 9 5280
TEST_TIME 10 5143
TEST_TIME 11 5458
TEST_TIME 12 6021
TEST_TIME 13 6068
TEST_TIME 14 6565
TEST_TIME 15 6652
TEST_TIME 16 6820
TEST_TIME 17 7144
TEST_TIME 18 7354
TEST_TIME 19 7633
TEST_TIME 20 7584
TEST_TIME 21 7816
TEST_TIME 22 8501
TEST_TIME 23 8685
TEST_TIME 24 8604
TEST_TIME 25 9099
TEST_TIME 26 9259
TEST_TIME 27 10618
TEST_TIME 28 10868
TEST_TIME 29 10734
TEST_TIME 30 10516
TEST_TIME 31 10317
TEST_TIME 32 10541
TEST_TIME 33 10653
TEST_TIME 34 10434
TEST_TIME 35 10267
TEST_TIME 36 10014
TEST_TIME 37 9949
TEST_TIME 38 9864
TEST_TIME 39 10021
TEST_TIME 40 9964
TEST_TIME 41 9883
TEST_TIME 42 9948
TEST_TIME 43 9922
TEST_TIME 44 9871
TEST_TIME 45 9831
TEST_TIME 46 9745
TEST_TIME 47 9705
TEST_TIME 48 9574
TEST_TIME 49 9650
TEST_TIME 50 9590
TEST_TIME 51 9586
TEST_TIME 52 9635
TEST_TIME 53 9603
TEST_TIME 54 9580
TEST_TIME 55 9685
TEST_TIME 56 9657
TEST_TIME 57 9634
TEST_TIME 58 9637
TEST_TIME 59 9790
TEST_TIME 60 9867
TEST_TIME 61 9887
TEST_TIME 62 9856
TEST_TIME 63 9941
TEST_TIME 64 10068
TEST_TIME 65 10145
TEST_TIME 66 10046
TEST_TIME 67 9972
TEST_TIME 68 9967
TEST_TIME 69 9891
TEST_TIME 70 9874
TEST_TIME 71 9836
TEST_TIME 72 9797
TEST_TIME 73 9750
TEST_TIME 74 9749
TEST_TIME 75 9690
TEST_TIME 76 9598
TEST_TIME 77 9597
TEST_TIME 78 9576
TEST_TIME 79 9486
TEST_TIME 80 9462
TEST_TIME 81 9422
TEST_TIME 82 9457
TEST_TIME 83 9441
TEST_TIME 84 9519
TEST_TIME 85 9483
TEST_TIME 86 9469
TEST_TIME 87 9526
TEST_TIME 88 9582
TEST_TIME 89 9616
TEST_TIME 90 9615
TEST_TIME 91 9681
TEST_TIME 92 9669
TEST_TIME 93 9704
TEST_TIME 94 9746
TEST_TIME 95 9757
TEST_TIME 96 9664
TEST_TIME 97 9670
TEST_TIME 98 9630
TEST_TIME 99 9630
TEST_TIME 100 9623
TEST_TIME 101 9587
TEST_TIME 102 9576
TEST_TIME 103 9556
TEST_TIME 104 9607
TEST_TIME 105 9580
TEST_TIME 106 9614
TEST_TIME 107 9588
TEST_TIME 108 9607
TEST_TIME 109 9585
TEST_TIME 110 9606
TEST_TIME 111 9671
TEST_TIME 112 9650
TEST_TIME 113 9686
TEST_TIME 114 9615
TEST_TIME 115 9572
TEST_TIME 116 9597
TEST_TIME 117 9563
TEST_TIME 118 9558
TEST_TIME 119 9547
TEST_TIME 120 9479

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-04-2021 01:29:19 to 07-04-2021 01:29:23.

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 1582316 1582316 0 0.00 0 27737 6 0 0
doc_list_biud 1582315 1582315 0 0.00 0 44226 27 0 0
sp_add_invoice_to_stock 5153 5051 102 1.97 26 211906 17869 0 102
sp_cancel_adding_invoice 5776 5776 0 0.00 5 78931 830 0 0
sp_cancel_client_order 1795 1795 0 0.00 4 36386 390 0 0
sp_cancel_customer_reserve 565609 565609 0 0.00 1 44229 60 0 0
sp_cancel_pay_from_customer 661 661 0 0.00 2 3859 81 0 0
sp_cancel_pay_to_supplier 447 447 0 0.00 2 2058 57 0 0
sp_cancel_supplier_invoice 6360 6350 10 0.15 1 29205 788 0 10
sp_cancel_supplier_order 413 413 0 0.00 5 1019806 105232 0 0
sp_cancel_write_off 10690 10690 0 0.00 1 10732 111 0 0
sp_client_order 20976 20976 0 0.00 3 42382 325 0 0
sp_customer_reserve 483405 483405 0 0.00 0 61328 171 0 0
sp_fill_shopping_cart 32082 32082 0 0.00 1 9861 36 0 0
sp_fill_shopping_cart_clo_res 483400 483400 0 0.00 0 13055 14 0 0
sp_get_clo_for_invoice 5046 5046 0 0.00 0 14818 285 0 0
sp_kill_cost_storno 17574 17574 0 0.00 0 12121 58 0 0
sp_kill_qstorno_ret_qs2qd 1148671 1148671 0 0.00 0 44224 32 0 0
sp_kill_qty_storno 605928 605928 0 0.00 0 44226 71 0 0
sp_lock_selected_doc 21113 21113 0 0.00 0 9895 6 0 0
sp_make_cost_storno 28302 28302 0 0.00 0 26585 52 0 0
sp_multiply_rows_for_pdistr 28302 28302 0 0.00 0 12513 30 0 0
sp_multiply_rows_for_qdistr 20976 20976 0 0.00 0 13276 146 0 0
sp_pay_from_customer 7200 7200 0 0.00 4 12911 117 0 0
sp_pay_to_supplier 5807 5807 0 0.00 5 13774 127 0 0
sp_payment_common 13007 13007 0 0.00 1 9538 27 0 0
sp_qd_handle_on_cancel_clo 1795 1795 0 0.00 0 36377 342 0 0
sp_qd_handle_on_invoice_upd_sts 10822 10822 0 0.00 0 43123 362 0 0
sp_qd_handle_on_reserve_upd_sts 10249 10249 0 0.00 0 37701 72 0 0
sp_reserve_write_off 10249 10249 0 0.00 6 38071 192 0 0
sp_supplier_invoice 5580 5580 0 0.00 6 91399 3399 0 0
sp_supplier_order 5528 5528 0 0.00 5 66135 1201 0 0
srv_aggregate_perf_data 110 110 0 0.00 3056 83123 15668 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 866 186940 31659 0 0
srv_find_qd_qs_mism 1087066 1087066 0 0.00 0 27735 5 0 0
srv_make_invnt_saldo 586 586 0 0.00 35 64138 1030 0 0
srv_make_money_saldo 763 763 0 0.00 1 1754 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 202420 443449 280915 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 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5052 5052 0 0.00 0 14340 184 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 0 3309 111 0 0
t$perf-norm:sp_cancel_client_order 1795 1795 0 0.00 0 5962 19 0 0
t$perf-norm:sp_cancel_customer_reserve 687 687 0 0.00 0 24544 59 0 0
t$perf-norm:sp_cancel_pay_from_customer 661 661 0 0.00 0 2823 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 447 447 0 0.00 0 1601 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 1134 19 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 29615 1773 0 0
t$perf-norm:sp_cancel_write_off 1002 1002 0 0.00 0 2569 13 0 0
t$perf-norm:sp_client_order 20976 20976 0 0.00 0 25936 23 0 0
t$perf-norm:sp_customer_reserve 1015 1015 0 0.00 0 7524 29 0 0
t$perf-norm:sp_pay_from_customer 7200 7200 0 0.00 0 6722 13 0 0
t$perf-norm:sp_pay_to_supplier 5807 5807 0 0.00 0 9568 24 0 0
t$perf-norm:sp_reserve_write_off 10249 10249 0 0.00 0 5837 12 0 0
t$perf-norm:sp_supplier_invoice 5580 5580 0 0.00 0 8725 24 0 0
t$perf-norm:sp_supplier_order 5528 5528 0 0.00 0 8854 19 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 698 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 3337 35 0 0
t$perf-norm:srv_make_invnt_saldo 586 586 0 0.00 0 2912 25 0 0
t$perf-norm:srv_make_money_saldo 763 763 0 0.00 0 5500 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 10296 10092 204 1.98 0 12929 23 0 204
v_all_customers 38360 38360 0 0.00 0 30 1 0 0
v_all_suppliers 30790 30790 0 0.00 0 19 1 0 0
v_all_wares 41952 41952 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 674 7 0 0
v_cancel_client_order 3590 3590 0 0.00 0 12886 12 0 0
v_cancel_customer_prepayment 1322 1322 0 0.00 0 3855 13 0 0
v_cancel_customer_reserve 1374 1374 0 0.00 0 1645 7 0 0
v_cancel_payment_to_supplier 894 894 0 0.00 0 2052 5 0 0
v_cancel_supplier_invoice 836 816 20 2.39 0 940 16 0 20
v_cancel_supplier_order 826 826 0 0.00 0 2246 10 0 0
v_cancel_write_off 2004 2004 0 0.00 0 4768 16 0 0
v_max_id_clo_ord 5528 5528 0 0.00 0 356 1 0 0
v_max_id_clo_res 1015 1015 0 0.00 0 4326 15 0 0
v_max_id_ord_sup 5578 5578 0 0.00 0 6016 7 0 0
v_max_non_paid_invoice 1518 1518 0 0.00 0 2336 5 0 0
v_max_non_paid_realizn 3779 3779 0 0.00 0 1800 4 0 0
v_min_id_clo_ord 5528 5528 0 0.00 0 4088 7 0 0
v_min_id_clo_res 1015 1015 0 0.00 0 1717 4 0 0
v_min_id_ord_sup 5578 5578 0 0.00 0 7424 7 0 0
v_min_non_paid_invoice 5807 5807 0 0.00 0 8979 17 0 0
v_min_non_paid_realizn 7200 7200 0 0.00 0 9533 15 0 0
v_our_firm 10434 10434 0 0.00 0 15 1 0 0
v_reserve_write_off 20498 20498 0 0.00 0 12934 8 0 0
x_lock_depdocs_on_canc_invoice 11718 11718 0 0.00 0 11843 116 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 8316 335 0 0
x_make_qstorno_1000_1200 5528 5528 0 0.00 2 66113 1122 0 0
x_make_qstorno_1200_2000 5580 5580 0 0.00 3 91384 3275 0 0
x_make_qstorno_2100_3300 483405 483405 0 0.00 0 61327 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-04-2021 01:29:24 to 07-04-2021 01:29:28.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:29 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:36 8955 8192000000 10194486528 10489602048 915613776 10.053 74 49 98 0 934954144 2510384 16829984
22:57:53 25489 8192000000 10326271088 10639859712 1354667152 14.189 100 82 164 0 1385678432 4154464 26856816
22:58:26 29973 8192000000 10383708400 10703069184 1431627856 14.876 100 90 179 1 1467151872 6030976 29493040
22:59:05 11813 8192000000 10402029552 10724847616 1458545712 15.113 100 91 183 0 1494994832 6683552 29765568
22:59:26 41860 8192000000 10440134640 10772312064 1488294304 15.374 100 88 176 0 1523421008 7172432 27954272
23:00:16 17943 8192000000 10457027696 10787741696 1512462288 15.585 100 93 186 0 1550655536 8205552 29987696
23:00:45 24294 8192000000 10472610608 10805223424 1522929776 15.676 100 87 174 0 1559574736 9039072 27605888
23:01:17 15220 8192000000 10485783584 10827649024 1548162960 15.894 100 85 171 0 1583752800 9042720 26547120
23:01:44 20523 8192000000 10511511728 10856951808 1564481904 16.035 100 84 168 0 1600392448 9580464 26330080
23:02:16 14791 8192000000 10533694224 10886688768 1595475888 16.301 100 78 156 0 1629635328 9703888 24455552
23:02:41 15955 8192000000 10549116192 10909523968 1622567552 16.532 100 73 146 0 1654025488 9428384 22029552
23:03:05 18704 8192000000 10590051664 10948726784 1644121056 16.715 100 80 160 1 1677711456 9911936 23678464
23:03:31 15910 8192000000 10609398160 10977759232 1661919232 16.865 100 71 142 0 1692746720 10166336 20661152
23:03:56 7082 8192000000 10630178720 10996842496 1694148096 17.136 100 82 165 0 1729715280 11733792 23833392
23:04:14 13406 8192000000 10652707904 11024412672 1706987712 17.244 100 75 150 1 1740151152 11801728 21361712
23:04:36 7997 8192000000 10660873568 11039621120 1731962448 17.452 100 75 152 1 1765897984 12351344 21584192
23:04:53 8093 8192000000 10685697920 11062878208 1748058864 17.586 100 82 164 0 1784082256 12485600 23537792
23:05:08 5997 8192000000 10692454592 11071475712 1754118480 17.636 100 76 152 0 1788579680 12761408 21699792
23:05:24 10917 8192000000 10698089440 11080724480 1764352752 17.720 100 72 144 1 1796371248 11604464 20414032
23:05:44 4111 8192000000 10717476864 11096530944 1775684288 17.814 100 72 141 1 1807619280 11686528 20248464
23:05:54 4418 8192000000 10721670288 11100819456 1786681936 17.904 100 78 155 2 1821383088 12611440 22089712
23:06:07 3912 8192000000 10729795744 11109576704 1793028304 17.957 100 80 158 1 1827585232 11941088 22615840
23:06:17 2357 8192000000 10736867536 11117707264 1799956960 18.014 100 83 162 0 1835762032 12464240 23340832
23:06:26 3842 8192000000 10746899024 11129434112 1804794192 18.053 100 86 169 1 1841940272 13384144 23761936
23:06:37 13259 8192000000 10738683104 11127746560 1806409072 18.066 100 74 148 1 1841446000 14039232 20997696
23:06:57 4021 8192000000 10751064256 11139305472 1808885760 18.087 100 75 150 1 1843332672 13304544 21142368
23:07:08 2931 8192000000 10764590672 11146706944 1824300160 18.213 100 80 159 1 1860206352 14109920 21796272
23:07:17 2885 8192000000 10770623344 11155316736 1829774560 18.257 100 85 171 3 1868896064 14994208 24127296
23:07:27 2654 8192000000 10780858016 11164901376 1833756608 18.290 100 85 170 2 1872960720 14752336 24451776
23:07:37 3906 8192000000 10785213504 11168108544 1841478064 18.353 100 93 184 0 1882199328 13766688 26954576
23:07:48 2488 8192000000 10788219440 11171164160 1844896848 18.381 100 92 184 0 1883859248 14102448 24859952
23:07:57 2601 8192000000 10785098672 11175964672 1848444752 18.409 100 92 183 0 1888872656 14464704 25963200
23:08:06 2496 8192000000 10797890864 11185651712 1855845408 18.470 100 90 180 2 1894425312 13409584 25170320
23:08:15 2137 8192000000 10799232416 11185442816 1855058352 18.463 100 93 187 0 1894966992 13608816 26299824
23:08:24 1634 8192000000 10800598768 11187273728 1858496848 18.491 100 87 174 1 1894828368 12266832 24064688
23:08:32 2154 8192000000 10803970576 11190185984 1863899360 18.535 100 89 179 1 1901118448 12165664 25053424
23:08:40 1883 8192000000 10811384000 11198971904 1866424640 18.555 100 90 179 1 1904229168 12825728 24978800
23:08:49 2533 8192000000 10808880880 11201179648 1868349408 18.571 100 90 181 0 1907743008 13740496 25653104
23:08:58 2033 8192000000 10813961952 11201794048 1871122112 18.593 100 95 190 0 1912414000 14450624 26841264
23:09:07 1436 8192000000 10816222128 11205074944 1874933136 18.624 100 87 173 0 1913018048 13868800 24216112
23:09:15 975 8192000000 10815932032 11208699904 1874750576 18.623 100 91 181 1 1913272176 12579008 25942592
23:09:22 20872 8192000000 10809839280 11205525504 1872786816 18.607 100 69 133 0 1901768304 10491696 18489792
23:09:50 19460 8192000000 10822375056 11213762560 1882312608 18.684 100 91 181 1 1919759008 11865152 25581248
23:10:16 2473 8192000000 10831534064 11223846912 1881629744 18.678 100 84 168 0 1918953616 12908864 24415008
23:10:25 1631 8192000000 10834275152 11224846336 1883641712 18.695 100 92 183 0 1923289488 12985088 26662688
23:10:33 9705 8192000000 10823246192 11216842752 1884651184 18.703 100 83 166 0 1924465968 15666208 24148576
23:10:49 5642 8192000000 10805332368 11222347776 1879822048 18.664 100 53 106 0 1910162848 16298176 14042624
23:11:02 2797 8192000000 10800967536 11216764928 1881322240 18.676 100 46 92 2 1903039664 8739616 12977808
23:11:12 2086 8192000000 10817764784 11227045888 1886373440 18.717 100 62 124 2 1912471024 8219152 17878432
23:11:23 4627 8192000000 10795965888 11220410368 1887791616 18.728 100 48 97 0 1910053376 8694320 13567440
23:11:38 5022 8192000000 10812464160 11223220224 1888754992 18.736 100 43 86 4 1909003120 7000304 13247824
23:11:52 6202 8192000000 10809578864 11227729920 1888787136 18.736 100 33 65 1 1905008832 7143648 9078048
23:12:09 5492 8192000000 10792483456 11225190400 1893646592 18.775 100 22 44 0 1906978064 6586528 6744944
23:12:21 1768 8192000000 10815045312 11227312128 1893665712 18.775 100 34 69 2 1909950896 6153136 10132048
23:12:29 5949 8192000000 10810839168 11234131968 1895918432 18.793 100 40 80 0 1915154960 8667584 10568944
23:12:42 9057 8192000000 10801406336 11230457856 1897214208 18.804 100 38 74 2 1914726688 7239344 10273136
23:13:02 4688 8192000000 10810520960 11237416960 1897310320 18.805 100 23 46 0 1910338112 6621136 6406656
23:13:16 7252 8192000000 10816229904 11240267776 1902878656 18.849 100 29 59 1 1917014976 6533248 7603072
23:13:32 5767 8192000000 10805270704 11240407040 1903123568 18.851 100 23 44 1 1915147456 5368336 6655552
23:13:45 3761 8192000000 10814517568 11236417536 1885052832 18.706 99 31 63 1 1900105136 6287984 8764320
23:13:55 6260 8192000000 10807673136 11238920192 1899075120 18.819 100 31 61 1 1914463760 7124368 8264272
23:14:08 11696 8192000000 10820149968 11245395968 1908119328 18.892 100 36 72 3 1924773408 6412688 10241392
23:14:28 84408 8192000000 10819463968 11254710272 1906464944 18.878 100 26 52 0 1919038704 4969920 7603840
23:16:01 9573 8192000000 10812455056 11252174848 1889464192 18.741 99 11 22 1 1897305968 5019728 2822048
23:16:17 5914 8192000000 10839622192 11266093056 1913297344 18.933 100 40 80 1 1931910128 7367840 11244944
23:16:32 5264 8192000000 10837506816 11269341184 1916239232 18.957 100 34 68 1 1933424256 7784064 9400960
23:16:46 4180 8192000000 10843555664 11268976640 1918337424 18.974 100 32 62 2 1933496528 5399008 9760096
23:16:56 6369 8192000000 10823164320 11253616640 1891293328 18.756 99 24 49 3 1904105536 5646720 7165488
23:17:12 4953 8192000000 10824592416 11255521280 1909377840 18.902 100 26 53 1 1922838144 6371104 7089200
23:17:24 6883 8192000000 10774138368 11202416640 1837339600 18.319 97 12 24 0 1845988000 5473888 3174512
23:17:40 5156 8192000000 10812740240 11237834752 1885993392 18.713 100 25 50 1 1900051488 6909632 7148464
23:17:53 7780 8192000000 10787918128 11219304448 1858270752 18.489 98 25 48 1 1872607888 7126992 7210144
23:18:07 13455 8192000000 10770388112 11199414272 1797086608 17.990 95 17 34 3 1806888336 5260496 4541232
23:18:26 6368 8192000000 10789834080 11224993792 1876776048 18.639 100 25 50 0 1890586512 6040592 7769872
23:18:43 10622 8192000000 10761844864 11187752960 1808916640 18.087 97 19 38 1 1820281168 5514368 5850160
23:19:00 10900 8192000000 10727566368 11149369344 1734966400 17.477 94 24 48 0 1747121600 4997616 7157584
23:19:18 61127 8192000000 10714991824 11119910912 1723755920 17.384 95 34 67 1 1742159408 8691968 9711520
23:20:28 8257 8192000000 10663224944 11083051008 1699406160 17.180 95 20 41 1 1711941984 6067952 6467872
23:20:42 8421 8192000000 10714196336 11133239296 1757614832 17.665 97 29 58 1 1771833296 6158304 8060160
23:20:59 6592 8192000000 10712221584 11130703872 1752454080 17.622 97 36 72 0 1773266992 11108448 9704464
23:21:16 5731 8192000000 10737073264 11148935168 1807216464 18.073 100 39 78 1 1825853504 7253264 11383776
23:21:30 8076 8192000000 10706876784 11120427008 1720727872 17.358 95 30 55 5 1733978848 4802832 8448144
23:21:46 5361 8192000000 10677002784 11094003712 1738834960 17.509 98 31 58 0 1753704368 6238304 8631104
23:21:59 5471 8192000000 10728419792 11139203072 1784818048 17.889 99 37 74 0 1802082144 5827920 11436176
23:22:12 5863 8192000000 10712415808 11128233984 1768461776 17.754 98 27 55 1 1782628240 5718112 8448352
23:22:24 7666 8192000000 10701533696 11120332800 1762553136 17.705 98 31 61 3 1777627952 5204960 9869856
23:22:41 8861 8192000000 10720490976 11133882368 1768565440 17.755 98 28 54 0 1786927632 9626672 8735520
23:23:00 7590 8192000000 10720001072 11144339456 1799238144 18.008 99 24 48 1 1811947568 5381552 7327872
23:23:14 11868 8192000000 10739798960 11153649664 1817549024 18.158 100 33 64 6 1832434400 5407728 9477648
23:23:33 12071 8192000000 10737893040 11163754496 1825201696 18.220 100 21 42 1 1837134320 5142448 6790176
23:23:51 14684 8192000000 10752085776 11170775040 1817278960 18.155 99 29 58 1 1831129776 5758192 8092624
23:24:14 61499 8192000000 10776195248 11181645824 1839332864 18.335 100 42 84 1 1856045952 4954256 11758832
23:25:22 8709 8192000000 10748391728 11184455680 1843449760 18.369 100 28 56 0 1858506176 7480432 7575984
23:25:37 10815 8192000000 10760928848 11190644736 1846965120 18.397 100 13 26 0 1855673776 5165680 3542976
23:25:57 5569 8192000000 10778262288 11195645952 1848117600 18.407 99 48 97 3 1869549488 7718672 13713216
23:26:13 5311 8192000000 10779503584 11202973696 1858336224 18.490 100 24 48 0 1871126432 5753136 7037072
23:26:29 8110 8192000000 10787482464 11206430720 1863748992 18.534 100 35 68 0 1880439488 6378624 10311872
23:26:43 7217 8192000000 10806997056 11225640960 1874518448 18.621 100 41 82 0 1897743200 10849120 12375632
23:26:58 13793 8192000000 10799668752 11225554944 1877505376 18.645 100 22 44 0 1888930448 5017264 6407808
23:27:17 30076 8192000000 10803255792 11232485376 1872073344 18.601 99 23 44 3 1883594848 5306624 6214880
23:27:57 26809 8192000000 10822751968 11244257280 1900011232 18.826 100 44 86 0 1918205360 6048416 12145712
23:28:32 14004 8192000000 10841883840 11254870016 1908109568 18.891 100 46 92 0 1929448144 8448352 12890224
23:28:56 13497 8192000000 10859166560 11275866112 1922227120 19.005 100 56 110 2 1948540544 9633856 16679568
23:29:34 74534 8192000000 10859882016 11288166400 1923739216 19.017 100 36 70 1 1943268224 9740192 9788816
23:30:56 10550 8192000000 10866497632 11293646848 1936191504 19.116 100 43 85 2 1958267904 9432176 12644224
23:31:19 25642 8192000000 10876527808 11309580288 1942774880 19.169 100 45 88 3 1964946064 9750640 12420544
23:31:55 28274 8192000000 10885706432 11317743616 1950174032 19.228 100 30 58 2 1969686880 11033920 8478928
23:32:31 32427 8192000000 10890151888 11329245184 1959113008 19.299 100 42 84 2 1986157344 13559216 13485120
23:33:11 29387 8192000000 10901646416 11338350592 1972896544 19.408 100 55 111 2 2004128896 14560864 16671488
23:33:52 16061 8192000000 10912551040 11350183936 1973488976 19.413 100 42 84 2 1998815440 11006208 14320256
23:34:21 16783 8192000000 10917999584 11347800064 1978850480 19.456 100 54 108 2 2009546896 14912368 15784048
23:34:47 6697 8192000000 10925033264 11352875008 1983712160 19.494 100 59 116 1 2015684896 15076944 16895792
23:35:01 9281 8192000000 10929755424 11361890304 1983869440 19.495 100 52 104 0 2014024704 15364320 14790944
23:35:18 11587 8192000000 10930601920 11363508224 1985624432 19.509 100 52 104 1 2016969488 15843264 15501792
23:35:45 11819 8192000000 10933918048 11367243776 1991733264 19.557 100 59 118 2 2028295664 17119040 19443360
23:36:04 7213 8192000000 10928071088 11368796160 1998038016 19.607 100 56 111 1 2030651808 16042832 16570960
23:36:22 12559 8192000000 10943622960 11377397760 1996197280 19.593 100 41 82 1 2025795824 17229568 12368976
23:36:42 7926 8192000000 10952823264 11384500224 2002085920 19.639 100 53 105 0 2039620736 21259856 16274960
23:37:02 10963 8192000000 10949376640 11389534208 2002052048 19.639 100 53 106 1 2040424048 21422080 16949920
23:37:24 12198 8192000000 10954678448 11390210048 2003791376 19.653 100 53 106 3 2042983392 22474144 16717872
23:37:50 22380 8192000000 10944853680 11386621952 1999489680 19.619 100 49 98 1 2039502528 24939936 15072912
23:38:23 6124 8192000000 10964241728 11399290880 2005918880 19.669 100 55 108 0 2050815616 28341456 16555280
23:38:38 7754 8192000000 10961065264 11396296704 1994201056 19.577 99 60 120 1 2040677408 27423696 19052656
23:38:58 2724 8192000000 10976752944 11411697664 2014679696 19.738 100 70 141 5 2067468096 31443840 21344560
23:39:08 5230 8192000000 10974393968 11406721024 1997354992 19.602 99 66 130 1 2047995568 31103040 19537536
23:39:22 2254 8192000000 10971187296 11401158656 2005272368 19.664 100 60 118 3 2055170000 32394080 17503552
23:39:32 1081 8192000000 10979269808 11407269888 2009412336 19.697 100 76 150 0 2063813008 32768800 21631872
23:39:41 3164 8192000000 10979784800 11401650176 2005058336 19.663 100 75 150 0 2061647648 33693248 22896064
23:39:51 3277 8192000000 10979927088 11399860224 2006497680 19.674 100 76 152 0 2064155440 34700336 22957424
23:40:02 5328 8192000000 10958062800 11384004608 1979908688 19.464 99 68 136 0 2036426384 35678752 20838944
23:40:14 3999 8192000000 10959190512 11385585664 1987592272 19.525 100 76 151 0 2047530656 35987360 23951024
23:40:31 3829 8192000000 10949296240 11378094080 1980724064 19.470 100 68 136 2 2040343168 37387504 22231600
23:40:43 5248 8192000000 10967455392 11391262720 1996241152 19.593 100 73 144 0 2055687088 37499136 21946800
23:40:56 1788 8192000000 10971985120 11392278528 1990752192 19.550 100 84 169 0 2056609616 39770208 26087216
23:41:05 4045 8192000000 10977903184 11400650752 1997432320 19.602 100 79 155 1 2061782464 40669024 23681120
23:41:17 2721 8192000000 10968437168 11383717888 1984646960 19.501 100 83 166 1 2049892752 39384896 25860896
23:41:29 5035 8192000000 10963977152 11389390848 1987325056 19.523 100 77 154 0 2051060272 40159296 23575920
23:41:43 3048 8192000000 10952820880 11375013888 1977203808 19.443 99 86 169 2 2042529392 39864256 25461328
23:41:52 1800 8192000000 10976271584 11394465792 1994062608 19.576 100 86 172 1 2061332624 40076112 27193904
23:42:02 4301 8192000000 10980426352 11399495680 2001036944 19.631 100 83 165 1 2067661456 41359024 25265488
23:42:15 7804 8192000000 10968457904 11398250496 1992485344 19.563 100 69 138 3 2056186816 41757056 21944416
23:42:32 5187 8192000000 10976250784 11400986624 1996641792 19.596 100 63 126 0 2059377520 43218496 19517232
23:42:47 4631 8192000000 10959503904 11386314752 1978369408 19.452 99 70 140 0 2043548912 43413584 21765920
23:43:03 2486 8192000000 10981077888 11405135872 1996902704 19.598 100 76 151 1 2064886480 44035872 23947904
23:43:15 3180 8192000000 10991508752 11408936960 1998484032 19.611 100 86 172 0 2067213056 42672880 26056144
23:43:25 2488 8192000000 10983905552 11398041600 1993021376 19.568 100 85 170 2 2063412112 43815712 26575024
23:43:37 2453 8192000000 10966479776 11384807424 1982317520 19.483 100 79 158 0 2052022592 45061696 24643376
23:43:48 2736 8192000000 10979885056 11390341120 1982735680 19.486 100 91 181 2 2059030928 47656352 28638896
23:43:57 3213 8192000000 10980921024 11402039296 1994034496 19.576 100 83 167 2 2067855104 47322592 26498016
23:44:08 2692 8192000000 10980383280 11404353536 1996023056 19.591 100 76 145 1 2064026560 44913712 23089792
23:44:21 1342 8192000000 10957632656 11368980480 1958819184 19.297 98 84 165 0 2027903984 44588336 24496464
23:44:29 2449 8192000000 10962341456 11378171904 1975189904 19.427 100 89 178 0 2045952064 42867040 27895120
23:44:38 1990 8192000000 10974636256 11385720832 1978417120 19.452 100 87 174 1 2049978464 44517984 27043360
23:44:48 2036 8192000000 10977979008 11388002304 1983106128 19.489 100 93 184 6 2055324224 43864112 28353984
23:44:58 4349 8192000000 10986141984 11400384512 1991766240 19.558 100 87 171 3 2064689776 46104608 26818928
23:45:11 5765 8192000000 10980562400 11400908800 1991150992 19.553 100 79 158 0 2064370992 47770096 25449904
23:45:26 3353 8192000000 10978573328 11389607936 1980455312 19.468 100 80 158 3 2053554560 48320352 24778896
23:45:39 3844 8192000000 10978891392 11399843840 1987226368 19.522 100 73 146 0 2062278368 51016304 24035696
23:45:52 3321 8192000000 10991175200 11410358272 1992064640 19.560 100 77 153 0 2071154608 54495808 24594160
23:46:02 4014 8192000000 10969778352 11388641280 1955819344 19.273 98 81 161 2 2032263968 50034688 26409936
23:46:14 3213 8192000000 10965244208 11386064896 1976155056 19.434 100 77 151 1 2051646048 51425408 24065584
23:46:31 1958 8192000000 10977858336 11395706880 1972980096 19.409 99 74 147 2 2052419536 54461872 24977568
23:46:41 6955 8192000000 10959826160 11384631296 1970159680 19.387 100 61 122 0 2042614624 52336048 20118896
23:46:56 4426 8192000000 10950055632 11370676224 1947427456 19.206 99 74 145 1 2020845280 50438928 22978896
23:47:10 1239 8192000000 10975481008 11385139200 1970237024 19.387 100 84 166 2 2050662688 53496112 26929552
23:47:19 3517 8192000000 10972816272 11393728512 1974645472 19.422 100 74 146 1 2053508832 55390576 23472784
23:47:33 11264 8192000000 10969201152 11385085952 1962539840 19.326 99 74 147 0 2044998992 58105760 24353392
23:47:52 4306 8192000000 10967674032 11379904512 1962263488 19.324 99 78 156 3 2045159344 57991984 24903872
23:48:05 1607 8192000000 10997719376 11413037056 1990000784 19.544 100 78 156 0 2075293200 59855360 25437056
23:48:16 5224 8192000000 11005622288 11424227328 1998365504 19.610 100 71 141 2 2082517776 61565504 22586768
23:48:30 2061 8192000000 10988010384 11400851456 1976258496 19.435 99 86 174 0 2066965200 62778576 27928128
23:48:40 2489 8192000000 10985602864 11409117184 1969497296 19.381 99 68 135 1 2056055616 63830560 22727760
23:48:52 13086 8192000000 10977281632 11420073984 1979481776 19.461 100 53 106 0 2061838768 63303408 19053584
23:49:17 23269 8192000000 10936690464 11369390080 1934891520 19.106 98 40 80 3 1998357264 49234976 14230768
23:49:50 8397 8192000000 10951114880 11383152640 1972544656 19.406 100 51 102 2 2034892528 45508240 16839632
23:50:07 10170 8192000000 10939015936 11381374976 1967858240 19.368 100 39 76 1 2022528464 42295808 12374416
23:50:28 16290 8192000000 10941844432 11393040384 1975187040 19.427 100 35 70 1 2033038288 46001968 11849280
23:50:56 23545 8192000000 10947577808 11400613888 1977996384 19.449 100 29 58 0 2035122016 46973952 10151680
23:51:43 12129 8192000000 10923254784 11374022656 1947055968 19.203 100 31 62 1 2011443408 53479296 10908144
23:52:05 8953 8192000000 10949033824 11386195968 1960857872 19.313 100 43 85 2 2029568304 53544464 15165968
23:52:20 10010 8192000000 10940196240 11380375552 1948987216 19.218 100 35 70 3 2015948592 54944912 12016464
23:52:38 23053 8192000000 10904482848 11362643968 1937543088 19.127 100 28 56 0 2007685088 60287184 9854816
23:53:10 18548 8192000000 10889646000 11349135360 1911678000 18.920 99 22 44 1 1968453104 48813840 7961264
23:54:02 28164 8192000000 10867178736 11335712768 1912113472 18.924 100 14 28 1 1969646992 52361360 5172160
23:54:37 61761 8192000000 10856700192 11327524864 1879718624 18.663 98 7 14 1 1907845680 25477120 2649936
23:55:54 87119 8192000000 10846537616 11286220800 1777930992 17.832 92 11 22 0 1792965072 11837888 3196192
23:57:27 27765 8192000000 10862157792 11286732800 1908931136 18.898 99 48 92 2 1930244640 7398480 13915024
23:58:04 8773 8192000000 10886357088 11306659840 1926838432 19.042 100 64 129 3 1954817664 9312096 18667136
23:58:20 15724 8192000000 10887769376 11317039104 1936117104 19.116 100 54 109 1 1964517616 12921024 15479488
23:58:54 18872 8192000000 10878577504 11330899968 1940907248 19.154 100 24 48 1 1961303840 13932944 6463648
23:59:29 53708 8192000000 10893852704 11353694208 1925955456 19.035 99 9 18 0 1946014192 17701952 2356784
00:00:34 186940 8192000000 10888421120 11333746688 1895782112 18.792 97 22 44 0 1912045280 10306992 5956176
00:03:54 72615 8192000000 10905585856 11368902656 1958352384 19.293 100 38 76 2 1985966096 15536560 12077152
00:05:16 67108 8192000000 10887518032 11360751616 1942759440 19.169 99 13 26 0 1964530624 17787600 3983584
00:06:30 866 8192000000 10879333216 11355037696 1949217888 19.220 100 10 20 0 1974342048 21786896 3337264
00:06:37 10004 8192000000 10889244080 11350519808 1958413344 19.293 100 29 56 1 1973039696 7286752 7339600
00:06:55 12568 8192000000 10893199600 11352518656 1964666192 19.343 100 23 46 1 1979131936 7548304 6917440
00:07:14 9471 8192000000 10880386320 11341242368 1943175616 19.172 99 15 30 0 1954527136 7152544 4198976
00:07:34 14643 8192000000 10928816768 11361099776 1970839936 19.392 100 58 113 2 1994883552 6825312 17218304
00:07:56 32362 8192000000 10917307776 11367673856 1977616448 19.446 100 38 74 2 1997032112 9775216 9640448
00:08:36 32567 8192000000 10915190592 11369340928 1962889808 19.329 99 48 93 4 1988308464 12606208 12812448
00:09:18 40738 8192000000 10896429184 11371114496 1975359184 19.428 100 19 38 1 1991126592 10578976 5188432
00:10:07 15528 8192000000 10909909120 11353505792 1939479376 19.143 98 30 61 1 1958679616 10332016 8868224
00:10:29 43532 8192000000 10886990928 11356815360 1946013120 19.195 99 18 36 0 1960095152 8685216 5396816
00:11:21 32019 8192000000 10884046624 11362435072 1964094608 19.339 100 6 12 1 1973109888 7463504 1551776
00:12:05 58411 8192000000 10908346624 11383877632 1985109504 19.505 100 20 40 1 2000762128 9755408 5897216
00:13:10 51590 8192000000 10906026912 11372187648 1950189152 19.228 98 15 30 1 1964334000 9809424 4335424
00:14:25 66463 8192000000 10912845696 11390029824 1986010784 19.512 100 15 30 1 2003562144 12699472 4851888
00:15:51 34172 8192000000 10913665616 11393171456 1982384832 19.484 100 20 40 0 2003443552 14341008 6717712
00:16:35 29397 8192000000 10922364064 11391242240 1990318320 19.546 100 36 72 0 2014412800 13642048 10452432
00:17:11 12184 8192000000 10921867104 11384827904 1989976224 19.544 100 46 90 4 2012182960 9203936 13002800
00:17:29 64587 8192000000 10920263616 11397804032 1997306768 19.601 100 21 42 1 2013374592 9799520 6268304
00:19:00 68440 8192000000 10895949152 11393175552 1971632896 19.398 99 9 18 1 1986885440 12744960 2507584
00:20:37 37747 8192000000 10919598288 11389739008 1970307824 19.388 99 33 66 2 1987728768 8415536 9005408
00:21:24 27426 8192000000 10925833552 11396362240 1976934256 19.440 99 40 80 1 2000074880 11494224 11646400
00:22:07 75362 8192000000 10904740512 11380670464 1905257424 18.869 96 12 24 0 1925210576 15842592 4110560
00:23:30 58256 8192000000 10895204816 11358101504 1881009232 18.673 95 27 54 3 1899918992 11722640 7187120
00:24:51 61711 8192000000 10916401568 11388739584 1970401088 19.389 100 20 40 1 1996109136 19482208 6225840
00:26:05 80163 8192000000 10910634480 11375833088 1921442192 18.998 97 10 20 3 1948101328 23728944 2930192
00:27:31 77694 8192000000 10925324160 11406127104 1948187808 19.212 98 9 18 0 1968512944 18042880 2282256
00:28:55 55467 8192000000 10906411648 11376103424 1912971008 18.930 96 16 32 1 1931068000 13999664 4097328
00:29:58 51511 8192000000 10895007472 11370962944 1925275120 19.029 97 18 36 1 1947382656 17039104 5068432
00:30:56 108681 8192000000 10890083104 11374620672 1847977632 18.406 94 9 18 0 1877962640 27407664 2577344
00:34:39 99379 8192000000 10854124544 11316887552 1897058560 18.803 97 28 55 0 1917149248 11998688 8092000
00:36:26 38813 8192000000 10866751952 11318775808 1896685216 18.800 97 46 90 1 1918651728 9246128 12720384
00:37:14 31299 8192000000 10891668304 11345940480 1945120080 19.188 100 50 100 0 1969143248 10238384 13784784
00:37:56 66217 8192000000 10863288000 11333406720 1904387808 18.862 98 20 40 1 1918098224 8074528 5635888
00:39:38 63928 8192000000 10847477904 11326648320 1899411568 18.822 98 18 36 0 1912210000 8237296 4561136
00:40:48 50687 8192000000 10830999632 11305672704 1873852416 18.615 97 9 18 1 1885179088 8813168 2513504
00:41:46 33804 8192000000 10840593056 11318153216 1916693008 18.960 100 7 13 0 1929221456 10858256 1670192
00:42:28 32457 8192000000 10841982464 11311239168 1905886560 18.874 99 5 10 1 1916376880 9327792 1162528
00:43:10 75493 8192000000 10842861824 11320471552 1919950032 18.986 100 18 36 1 1935514640 9675824 5888784
00:45:00 45587 8192000000 10830911104 11311656960 1892962912 18.770 98 22 44 2 1905184816 6457184 5764720
00:46:00 75806 8192000000 10812869552 11293851648 1849878704 18.421 96 7 14 0 1861490528 10003136 1608688
00:47:23 88195 8192000000 10829826736 11307991040 1833626864 18.289 96 11 22 0 1848961952 12247712 3087376
00:49:10 34699 8192000000 10824999824 11292852224 1859488896 18.499 98 16 32 2 1871425360 7245360 4691104
00:49:58 35876 8192000000 10810726864 11271069696 1882188480 18.683 98 19 38 0 1899366512 11753472 5424560
00:50:50 57866 8192000000 10849631920 11320963072 1920755824 18.993 100 38 75 1 1945901568 13740384 11405360
00:51:54 50947 8192000000 10844380528 11309588480 1865209104 18.545 97 16 32 2 1882407008 12555760 4642144
00:53:04 29942 8192000000 10861310976 11324284928 1909752448 18.905 99 20 40 3 1927899888 12548928 5598512
00:53:40 46788 8192000000 10866878768 11333988352 1913992512 18.939 99 26 52 1 1932819136 11280624 7546000
00:54:38 111524 8192000000 10883117200 11341172736 1914935104 18.946 99 13 27 0 1931598240 13349248 3313888
00:56:41 29171 8192000000 10889208320 11346898944 1950314480 19.229 100 34 68 0 1970611008 10712096 9584432
00:57:21 109552 8192000000 10896383376 11360997376 1902508640 18.846 97 26 52 3 1921871424 12340880 7021904
00:59:18 49925 8192000000 10902612800 11361693696 1924192000 19.020 98 25 50 1 1943653488 12995328 6466160
01:00:19 71482 8192000000 10918039552 11390550016 1971370656 19.396 100 12 24 0 1988666592 14289312 3006624
01:01:42 118629 8192000000 10909063936 11393892352 1981541456 19.477 100 10 20 1 2000711072 16312928 2856688
01:03:56 52960 8192000000 10904035888 11390636032 1981308928 19.475 100 15 28 1 1997703632 11699712 4694992
01:05:02 43882 8192000000 10933248016 11388375040 1975321728 19.428 100 5 10 0 1984558016 7997424 1238864
01:05:55 72447 8192000000 10902539680 11396882432 1983223584 19.490 100 14 27 0 1998382288 11082832 4075872
01:07:13 66745 8192000000 10907186192 11389845504 1985126384 19.505 100 8 16 0 1996137232 8850544 2160304
01:08:26 30844 8192000000 10903529936 11352403968 1911000384 18.915 96 28 57 0 1925885920 6869264 8016272
01:09:08 32664 8192000000 10906759808 11380908032 1960552080 19.310 99 30 58 3 1978960256 10287344 8120832
01:09:48 35649 8192000000 10912065168 11383521280 1970217712 19.387 100 15 31 1 1984997792 10728288 4051792
01:10:30 117942 8192000000 10883135456 11363160064 1840718304 18.347 93 23 46 0 1860367136 13380528 6268304
01:12:34 66185 8192000000 10877980640 11362177024 1937710256 19.128 99 11 22 0 1949775568 8929296 3136016
01:13:53 64946 8192000000 10921480064 11363946496 1890837984 18.753 96 36 71 0 1909327376 8142944 10346448
01:15:08 57877 8192000000 10885347152 11340926976 1890480416 18.750 97 24 48 0 1906797648 9714304 6602928
01:16:13 14334 8192000000 10870777584 11327426560 1928120736 19.052 100 31 60 2 1945220032 9064272 8035024
01:16:33 56138 8192000000 10882611664 11343818752 1918951280 18.978 99 35 70 5 1940693424 11924528 9817616
01:17:39 58885 8192000000 10833185296 11309731840 1836555024 18.313 95 9 18 2 1850471888 11480976 2435888
01:18:45 72242 8192000000 10864019648 11327246336 1848377888 18.409 96 14 28 0 1862293680 9925776 3990016
01:20:05 91952 8192000000 10831042000 11306528768 1869456560 18.580 97 13 26 1 1885445936 12557968 3431408
01:21:47 102884 8192000000 10842307440 11317764096 1850223600 18.424 96 25 50 1 1870196624 13323056 6649968
01:23:49 36284 8192000000 10837297056 11319828480 1877879888 18.648 98 10 20 0 1894631008 14406144 2344976
01:24:32 49077 8192000000 10861392064 11331334144 1918221040 18.973 100 24 48 2 1935515408 10994208 6300160
01:25:36 70715 8192000000 10843176912 11326308352 1898490592 18.814 99 11 22 2 1919779280 18350208 2938480
01:26:53 26945 8192000000 10815639840 11292876800 1882533440 18.686 98 8 16 0 1900010992 15264128 2213424

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 07-04-2021 01:29:30 to 07-04-2021 01:30:02.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-04-2021 01:30:03 to 07-04-2021 01:30:05.

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          237990
MON$OLDEST_ACTIVE               240333
MON$OLDEST_SNAPSHOT             240333
MON$NEXT_TRANSACTION            240333
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                       2033760
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.33441 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33441 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33441 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33441 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 ---
:41: 
:42: mscs-test-161.budzdorov.ru    Wed Apr  7 01:27:31 2021
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
:45: 
:46: mscs-test-161.budzdorov.ru    Wed Apr  7 01:27:41 2021
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
:49: 
:50: mscs-test-161.budzdorov.ru    Wed Apr  7 01:27:41 2021
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:52: 
--- end of diff output ---

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

07.04.21 01:30:06. 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-04-07 01:30:09 No severe PSQL-related problems occured
07.04.21 01:30:10. End of report.