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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17248896 kB
MemAvailable 31205388 kB
Buffers 0 kB
Cached 14465800 kB
SwapCached 4780 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-09 22:27:13
DTS_END                         2021-02-09 22:27:13.7800
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/58880
TRN_ID                          240149
ATT_ID                          707
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: 8826.50 19502 1059180
customer order: creation 175.56 342 21067
customer order: refuse 14.73 354 1768
order to supplier: creation 46.66 1246 5599
order to supplier: removal 3.29 99423 395
invoice (draft): creation 46.50 3550 5580
invoice (draft): removal 47.98 842 5757
invoice accept: apply 42.12 18428 5054
invoice accept: cancel 43.21 855 5185
customer reserve: creation 3816.46 186 457975
customer reserve: removal 4293.19 60 515183
realization accept: apply 84.72 165 10166
realization accept: cancel 81.12 111 9734
payment from customer: creation 59.58 107 7150
payment from customer: removal 5.78 87 694
payment to supplier: creation 50.34 131 6041
payment to supplier: removal 3.58 129 430
service: total inventory turnovers 4.68 1230 562
service: total monetary turnovers 6.23 26 748
service: aggregate perf. data 0.73 23557 88
service: refresh index statistics 0.03 239201 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-02-2021 22:28:37 to 09-02-2021 22:28:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9420
TEST_TIME 2 7596
TEST_TIME 3 7703
TEST_TIME 4 7159
TEST_TIME 5 6825
TEST_TIME 6 6505
TEST_TIME 7 7185
TEST_TIME 8 7151
TEST_TIME 9 7640
TEST_TIME 10 7650
TEST_TIME 11 7671
TEST_TIME 12 7467
TEST_TIME 13 7398
TEST_TIME 14 7898
TEST_TIME 15 7749
TEST_TIME 16 7904
TEST_TIME 17 7781
TEST_TIME 18 8420
TEST_TIME 19 8466
TEST_TIME 20 8567
TEST_TIME 21 9355
TEST_TIME 22 9451
TEST_TIME 23 9623
TEST_TIME 24 9898
TEST_TIME 25 10027
TEST_TIME 26 10116
TEST_TIME 27 11341
TEST_TIME 28 11076
TEST_TIME 29 10901
TEST_TIME 30 10759
TEST_TIME 31 10629
TEST_TIME 32 10445
TEST_TIME 33 10302
TEST_TIME 34 10112
TEST_TIME 35 10036
TEST_TIME 36 10045
TEST_TIME 37 9915
TEST_TIME 38 9778
TEST_TIME 39 9691
TEST_TIME 40 9658
TEST_TIME 41 9508
TEST_TIME 42 9429
TEST_TIME 43 9469
TEST_TIME 44 9419
TEST_TIME 45 9360
TEST_TIME 46 9322
TEST_TIME 47 9207
TEST_TIME 48 9113
TEST_TIME 49 9027
TEST_TIME 50 9125
TEST_TIME 51 9198
TEST_TIME 52 9159
TEST_TIME 53 9219
TEST_TIME 54 9198
TEST_TIME 55 9180
TEST_TIME 56 9188
TEST_TIME 57 9269
TEST_TIME 58 9205
TEST_TIME 59 9355
TEST_TIME 60 9297
TEST_TIME 61 9291
TEST_TIME 62 9332
TEST_TIME 63 9391
TEST_TIME 64 9411
TEST_TIME 65 9303
TEST_TIME 66 9271
TEST_TIME 67 9240
TEST_TIME 68 9183
TEST_TIME 69 9162
TEST_TIME 70 9107
TEST_TIME 71 9101
TEST_TIME 72 9057
TEST_TIME 73 8955
TEST_TIME 74 8933
TEST_TIME 75 8932
TEST_TIME 76 8995
TEST_TIME 77 8925
TEST_TIME 78 8957
TEST_TIME 79 9016
TEST_TIME 80 9128
TEST_TIME 81 9203
TEST_TIME 82 9145
TEST_TIME 83 9127
TEST_TIME 84 9215
TEST_TIME 85 9202
TEST_TIME 86 9198
TEST_TIME 87 9221
TEST_TIME 88 9127
TEST_TIME 89 9107
TEST_TIME 90 9058
TEST_TIME 91 9054
TEST_TIME 92 9008
TEST_TIME 93 8975
TEST_TIME 94 8911
TEST_TIME 95 8978
TEST_TIME 96 8957
TEST_TIME 97 8951
TEST_TIME 98 8980
TEST_TIME 99 9004
TEST_TIME 100 9036
TEST_TIME 101 9081
TEST_TIME 102 9068
TEST_TIME 103 9078
TEST_TIME 104 9148
TEST_TIME 105 9089
TEST_TIME 106 9105
TEST_TIME 107 9158
TEST_TIME 108 9159
TEST_TIME 109 9105
TEST_TIME 110 9047
TEST_TIME 111 9026
TEST_TIME 112 9021
TEST_TIME 113 8971
TEST_TIME 114 8937
TEST_TIME 115 8907
TEST_TIME 116 8879
TEST_TIME 117 8856
TEST_TIME 118 8876
TEST_TIME 119 8879
TEST_TIME 120 8829

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 09-02-2021 22:28:40 to 09-02-2021 22:28:44.

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 1484667 1484667 0 0.00 0 13700 7 0 0
doc_list_biud 1484667 1484667 0 0.00 0 20953 27 0 0
sp_add_invoice_to_stock 5227 5054 173 3.30 30 177656 18428 0 173
sp_cancel_adding_invoice 5185 5185 0 0.00 5 49518 855 0 0
sp_cancel_client_order 1768 1768 0 0.00 5 11293 354 0 0
sp_cancel_customer_reserve 515183 515183 0 0.00 1 16684 60 0 0
sp_cancel_pay_from_customer 694 694 0 0.00 3 6046 87 0 0
sp_cancel_pay_to_supplier 430 430 0 0.00 2 14810 130 0 0
sp_cancel_supplier_invoice 5770 5757 13 0.22 2 18640 843 0 13
sp_cancel_supplier_order 395 395 0 0.00 10 909502 99423 0 0
sp_cancel_write_off 9734 9734 0 0.00 1 8108 111 0 0
sp_client_order 21067 21067 0 0.00 3 17890 343 0 0
sp_customer_reserve 457975 457975 0 0.00 0 68230 186 0 0
sp_fill_shopping_cart 32239 32239 0 0.00 1 15640 40 0 0
sp_fill_shopping_cart_clo_res 457970 457970 0 0.00 0 17532 13 0 0
sp_get_clo_for_invoice 5048 5048 0 0.00 0 27379 316 0 0
sp_kill_cost_storno 16043 16043 0 0.00 0 8428 55 0 0
sp_kill_qstorno_ret_qs2qd 1046252 1046252 0 0.00 0 18615 33 0 0
sp_kill_qty_storno 553236 553236 0 0.00 0 20952 71 0 0
sp_lock_selected_doc 21031 21031 0 0.00 0 9006 6 0 0
sp_make_cost_storno 28405 28405 0 0.00 0 13686 51 0 0
sp_multiply_rows_for_pdistr 28405 28405 0 0.00 0 9608 28 0 0
sp_multiply_rows_for_qdistr 21067 21067 0 0.00 0 17879 167 0 0
sp_pay_from_customer 7150 7150 0 0.00 4 10919 108 0 0
sp_pay_to_supplier 6041 6041 0 0.00 4 12639 132 0 0
sp_payment_common 13191 13191 0 0.00 1 9517 30 0 0
sp_qd_handle_on_cancel_clo 1768 1768 0 0.00 0 11288 320 0 0
sp_qd_handle_on_invoice_upd_sts 10233 10233 0 0.00 0 20949 318 0 0
sp_qd_handle_on_reserve_upd_sts 10166 10166 0 0.00 0 16771 54 0 0
sp_reserve_write_off 10166 10166 0 0.00 6 16792 165 0 0
sp_supplier_invoice 5580 5580 0 0.00 6 82100 3551 0 0
sp_supplier_order 5599 5599 0 0.00 5 27891 1246 0 0
srv_aggregate_perf_data 88 88 0 0.00 3144 259301 23557 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 1372 151166 30765 0 0
srv_find_qd_qs_mism 1011797 1011797 0 0.00 0 10834 6 0 0
srv_make_invnt_saldo 562 562 0 0.00 48 64005 1231 0 0
srv_make_money_saldo 748 748 0 0.00 1 1193 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 80144 433745 239202 0 0
t$perf-abend:sp_add_invoice_to_stock 173 173 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5054 5054 0 0.00 0 10503 162 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 4557 103 0 0
t$perf-norm:sp_cancel_client_order 1768 1768 0 0.00 0 10438 25 0 0
t$perf-norm:sp_cancel_customer_reserve 677 677 0 0.00 0 4643 26 0 0
t$perf-norm:sp_cancel_pay_from_customer 694 694 0 0.00 0 1527 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 430 430 0 0.00 0 3083 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 1028 14 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 31543 1873 0 0
t$perf-norm:sp_cancel_write_off 1036 1036 0 0.00 0 1130 6 0 0
t$perf-norm:sp_client_order 21067 21067 0 0.00 0 24572 19 0 0
t$perf-norm:sp_customer_reserve 978 978 0 0.00 0 1947 4 0 0
t$perf-norm:sp_pay_from_customer 7150 7150 0 0.00 0 23087 16 0 0
t$perf-norm:sp_pay_to_supplier 6041 6041 0 0.00 0 10715 17 0 0
t$perf-norm:sp_reserve_write_off 10166 10166 0 0.00 0 24576 17 0 0
t$perf-norm:sp_supplier_invoice 5580 5580 0 0.00 0 17866 25 0 0
t$perf-norm:sp_supplier_order 5599 5599 0 0.00 0 10617 21 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 484 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 1872 19 0 0
t$perf-norm:srv_make_invnt_saldo 562 562 0 0.00 0 3448 35 0 0
t$perf-norm:srv_make_money_saldo 748 748 0 0.00 0 1369 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 117 31 0 0
v_add_invoice_to_stock 10438 10092 346 3.31 0 6697 22 0 346
v_all_customers 38012 38012 0 0.00 0 34 1 0 0
v_all_suppliers 31046 31046 0 0.00 0 22 1 0 0
v_all_wares 42134 42134 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 319 6 0 0
v_cancel_client_order 3536 3536 0 0.00 0 4761 7 0 0
v_cancel_customer_prepayment 1388 1388 0 0.00 0 6039 14 0 0
v_cancel_customer_reserve 1354 1354 0 0.00 0 627 4 0 0
v_cancel_payment_to_supplier 860 860 0 0.00 0 2940 10 0 0
v_cancel_supplier_invoice 824 798 26 3.15 0 944 15 0 26
v_cancel_supplier_order 790 790 0 0.00 0 264 3 0 0
v_cancel_write_off 2072 2072 0 0.00 0 3400 17 0 0
v_max_id_clo_ord 5596 5596 0 0.00 0 3788 2 0 0
v_max_id_clo_res 978 978 0 0.00 0 2733 13 0 0
v_max_id_ord_sup 5575 5575 0 0.00 0 3485 5 0 0
v_max_non_paid_invoice 1689 1689 0 0.00 0 3490 6 0 0
v_max_non_paid_realizn 3972 3972 0 0.00 0 5373 6 0 0
v_min_id_clo_ord 5596 5596 0 0.00 0 3663 7 0 0
v_min_id_clo_res 978 978 0 0.00 0 3003 9 0 0
v_min_id_ord_sup 5575 5575 0 0.00 0 4081 6 0 0
v_min_non_paid_invoice 6041 6041 0 0.00 0 6746 17 0 0
v_min_non_paid_realizn 7150 7150 0 0.00 0 6092 18 0 0
v_our_firm 10478 10478 0 0.00 0 21 1 0 0
v_reserve_write_off 20332 20332 0 0.00 0 1719 4 0 0
x_lock_depdocs_on_canc_invoice 10543 10543 0 0.00 0 31469 142 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 15558 384 0 0
x_make_qstorno_1000_1200 5599 5599 0 0.00 2 27885 1162 0 0
x_make_qstorno_1200_2000 5580 5580 0 0.00 3 78578 3409 0 0
x_make_qstorno_2100_3300 457975 457975 0 0.00 0 68229 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-02-2021 22:28:45 to 09-02-2021 22:28:49.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:17 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:23 9121 8192000000 10148294000 10449559552 897588480 9.874 73 47 96 1 915103984 2306656 15208848
19:57:40 29413 8192000000 10319475664 10635735040 1375345584 14.375 100 85 170 0 1407856560 4220064 28290912
19:58:19 20665 8192000000 10375506832 10695798784 1425642048 14.823 100 89 176 1 1460138032 5381088 29114896
19:58:52 26226 8192000000 10413325776 10738585600 1466587600 15.184 100 86 171 1 1500651296 6455856 27607840
19:59:27 21007 8192000000 10435773632 10763522048 1490410928 15.392 100 88 176 0 1526547312 7418336 28718048
20:00:02 18104 8192000000 10454300208 10787962880 1509672672 15.560 100 88 176 1 1546215168 8234336 28308160
20:00:36 23067 8192000000 10478545328 10816077824 1528384496 15.723 100 86 172 0 1564143152 8752912 27005744
20:01:07 21248 8192000000 10479791056 10823503872 1544650112 15.864 100 88 176 1 1582112768 9487648 27975008
20:01:41 17733 8192000000 10511016416 10855776256 1563139216 16.023 100 83 166 0 1598537648 9333728 26064704
20:02:13 14879 8192000000 10527209680 10878103552 1590196064 16.256 100 78 156 1 1623697808 9607296 23894448
20:02:38 15974 8192000000 10563693120 10920128512 1619040336 16.502 100 76 152 0 1652083680 10043568 22999776
20:03:05 13367 8192000000 10588133504 10950049792 1645202080 16.724 100 78 157 0 1680325424 11376896 23746448
20:03:26 14089 8192000000 10609657200 10977005568 1667025616 16.908 100 81 161 2 1702452880 11599456 23827808
20:03:47 12767 8192000000 10639747216 11008282624 1697393408 17.163 100 83 166 2 1733506176 11859520 24253248
20:04:07 8830 8192000000 10659151216 11031781376 1711426704 17.281 100 67 134 2 1741958480 11149232 19382544
20:04:25 8930 8192000000 10679135024 11056422912 1742429616 17.539 100 82 164 0 1779324512 12676848 24218048
20:04:45 8540 8192000000 10694830416 11073957888 1755534368 17.647 100 72 142 2 1787979728 11727536 20717824
20:05:01 5393 8192000000 10700017008 11078070272 1765690336 17.731 100 81 161 0 1800275312 11882416 22702560
20:05:13 4725 8192000000 10709159984 11089145856 1771571520 17.780 100 82 161 1 1806854416 12541488 22741408
20:05:26 5502 8192000000 10722804720 11100803072 1778874832 17.840 100 84 166 2 1816437072 13079792 24482448
20:05:39 5209 8192000000 10722022912 11106328576 1787399312 17.910 100 85 169 1 1825005040 13099248 24506480
20:05:51 3943 8192000000 10731700992 11112488960 1789439600 17.927 100 80 157 3 1825448064 13254448 22754016
20:06:02 3927 8192000000 10734321360 11117375488 1799428896 18.009 100 82 165 1 1835434496 12335216 23670384
20:06:12 3457 8192000000 10732294912 11121741824 1806536608 18.068 100 75 150 1 1839919936 12315392 21067936
20:06:22 2852 8192000000 10742747104 11128975360 1813052736 18.121 100 84 168 3 1848597520 12665296 22879488
20:06:32 5623 8192000000 10751138384 11138633728 1814863024 18.136 100 74 148 1 1847829472 12788544 20177904
20:06:44 4238 8192000000 10763973584 11154092032 1821770368 18.192 100 81 161 1 1856399344 12186144 22442832
20:06:55 2752 8192000000 10776908096 11163332608 1839042032 18.333 100 82 164 1 1876088512 14097920 22948560
20:07:04 2901 8192000000 10788495680 11174273024 1844084576 18.374 100 89 177 4 1883845216 14421968 25338672
20:07:14 2566 8192000000 10789130384 11178676224 1848366656 18.409 100 92 184 2 1888907056 15428864 25111536
20:07:23 2155 8192000000 10799314640 11188219904 1852756320 18.445 100 93 187 2 1894582320 15631136 26194864
20:07:32 1917 8192000000 10803027392 11192020992 1858458352 18.491 100 91 182 1 1898820848 15295936 25066560
20:07:40 2134 8192000000 10808373984 11197923328 1864523168 18.540 100 92 183 3 1904530128 14422992 25583968
20:07:48 2055 8192000000 10810936832 11199000576 1866825472 18.559 100 94 187 0 1906430144 13382080 26222592
20:07:57 1971 8192000000 10812077376 11202867200 1869767024 18.582 100 90 181 2 1909334752 14285712 25282016
20:08:05 1869 8192000000 10819306640 11210248192 1878591904 18.654 100 90 180 2 1917635984 13568048 25476032
20:08:13 1519 8192000000 10824643120 11215233024 1880166192 18.666 100 97 194 1 1920814960 13786224 26862544
20:08:21 1599 8192000000 10826949888 11215265792 1884502624 18.701 100 94 188 0 1924793120 13720192 26570304
20:08:29 1541 8192000000 10828662848 11219120128 1884610288 18.702 100 86 173 1 1921496784 13164800 23721696
20:08:37 38700 8192000000 10805641648 11217317888 1886373072 18.717 100 78 156 1 1920693232 11941840 22378320
20:09:23 2197 8192000000 10813234960 11222814720 1890761120 18.752 100 75 150 2 1921381808 9474448 21146240
20:09:32 2232 8192000000 10817106672 11229949952 1889984720 18.746 100 62 124 3 1918314784 10601824 17728240
20:09:43 2950 8192000000 10813371648 11228442624 1886512144 18.718 100 46 91 1 1909158640 10626000 12020496
20:09:55 5221 8192000000 10805467312 11222069248 1885091184 18.706 100 36 72 1 1903665856 7806688 10767984
20:10:06 6239 8192000000 10801105520 11223019520 1885490528 18.709 100 37 74 2 1904373136 8742160 10140448
20:10:19 6149 8192000000 10809258688 11226017792 1886147104 18.715 100 34 67 0 1903007584 7093440 9767040
20:10:33 4746 8192000000 10802081536 11228241920 1891202912 18.755 100 38 76 0 1911421568 9350864 10867792
20:10:50 3131 8192000000 10798396176 11227160576 1889616752 18.743 100 29 58 3 1903804352 5884800 8302800
20:11:01 9308 8192000000 10800509584 11235389440 1892158272 18.763 100 21 42 0 1904378064 6244352 5975440
20:11:17 5825 8192000000 10801418336 11238117376 1896808400 18.801 100 25 50 0 1911028448 7256608 6963440
20:11:30 6056 8192000000 10813791840 11239694336 1900014544 18.826 100 28 54 1 1914158000 6932080 7211376
20:11:42 65243 8192000000 10826533040 11254534144 1907813344 18.889 100 38 76 0 1924314384 5022800 11478240
20:12:54 13711 8192000000 10813112080 11250515968 1904304272 18.861 100 26 52 0 1918815952 7452448 7059232
20:13:15 4904 8192000000 10824865680 11256573952 1909367360 18.902 100 35 70 1 1925529520 6481776 9680384
20:13:27 6196 8192000000 10814085168 11251179520 1906438288 18.878 100 23 46 2 1919378688 6249632 6690768
20:13:39 6646 8192000000 10827232576 11261497344 1909241264 18.901 100 28 56 3 1922580224 5640960 7698000
20:13:54 6580 8192000000 10820866752 11256987648 1910758128 18.913 100 33 66 1 1926172112 4775344 10638640
20:14:07 5625 8192000000 10830220944 11256455168 1909396208 18.902 100 18 36 1 1924097360 10046416 4654736
20:14:19 7586 8192000000 10818220192 11258449920 1912485808 18.927 100 34 68 2 1928892896 5811232 10595856
20:14:36 11323 8192000000 10820588320 11261603840 1890875520 18.753 99 16 33 1 1905041600 10026208 4139872
20:14:54 7891 8192000000 10827529600 11262468096 1909447024 18.902 100 23 47 1 1922049216 6016112 6586080
20:15:11 8578 8192000000 10819169584 11258761216 1895784128 18.792 99 22 44 2 1907948768 5864304 6300336
20:15:28 9818 8192000000 10826736512 11256311808 1896951744 18.802 99 17 34 0 1906871744 4899568 5020432
20:15:45 6407 8192000000 10823559776 11261440000 1896422000 18.798 99 23 46 0 1908658160 5978160 6258000
20:15:58 17110 8192000000 10829200384 11246305280 1879143248 18.658 98 26 52 2 1892211504 6032944 7035312
20:16:55 25075 8192000000 10810273680 11249496064 1875469776 18.629 98 26 50 2 1888606240 5733072 7403392
20:17:28 13788 8192000000 10816000848 11258171392 1908238112 18.893 100 19 37 0 1919996544 6184288 5574144
20:17:48 6067 8192000000 10812200992 11241881600 1868438640 18.572 98 25 50 1 1882098032 6477360 7182032
20:18:05 8818 8192000000 10791571728 11227803648 1860294576 18.506 98 20 40 1 1872463392 6447760 5721056
20:18:20 6001 8192000000 10779959808 11199533056 1809504656 18.092 96 28 56 0 1823419664 5365328 8549680
20:18:34 9229 8192000000 10772601120 11206602752 1809092272 18.088 96 27 54 1 1822926544 6251984 7582288
20:18:49 10923 8192000000 10745891632 11174363136 1739987488 17.519 93 17 34 1 1749733856 5231792 4514576
20:19:08 11229 8192000000 10735948128 11168624640 1814862880 18.136 99 25 50 1 1827395168 5575728 6956560
20:19:25 12930 8192000000 10744269920 11166195712 1732933392 17.460 94 17 34 0 1742728208 4955184 4839632
20:19:45 5990 8192000000 10707410080 11126792192 1750508896 17.606 96 21 42 0 1762102368 5580896 6012576
20:19:57 6759 8192000000 10705760688 11124383744 1780212656 17.851 99 32 64 2 1795810560 6088272 9509632
20:20:10 4900 8192000000 10713710320 11123642368 1764423296 17.721 98 35 70 1 1781214368 6430432 10360640
20:20:21 7432 8192000000 10680215456 11091103744 1730125312 17.437 97 18 36 1 1740536416 5913200 4497904
20:20:35 11137 8192000000 10685801328 11105087488 1707337088 17.246 95 21 42 1 1719326848 5236288 6753472
20:20:53 69005 8192000000 10728206656 11142164480 1702867648 17.209 94 41 85 0 1724150192 8839632 12442912
20:22:10 10666 8192000000 10720307136 11140722688 1766288448 17.736 98 12 24 0 1774613216 5246480 3078288
20:22:29 5659 8192000000 10734476144 11148361728 1800525360 18.018 99 39 78 2 1819661856 8225360 10911136
20:22:43 5033 8192000000 10732046960 11148230656 1813190608 18.122 100 19 37 0 1824772048 5831008 5750432
20:22:56 7343 8192000000 10729087536 11158044672 1809716144 18.094 99 23 47 1 1821614416 5095136 6803136
20:23:09 6352 8192000000 10759508384 11174825984 1835787760 18.307 100 31 62 1 1850542288 6557104 8197424
20:23:22 4403 8192000000 10774160176 11182112768 1836440608 18.312 100 25 50 2 1849361152 4808112 8112432
20:23:34 5884 8192000000 10764106176 11182350336 1845587248 18.386 100 30 60 0 1860983744 6268720 9127776
20:23:48 9997 8192000000 10768686800 11191332864 1850008224 18.422 100 27 52 4 1862715968 4914000 7793744
20:24:04 7511 8192000000 10765388736 11191873536 1851060544 18.431 100 19 38 0 1862645648 6141120 5443984
20:24:26 10742 8192000000 10772830240 11198042112 1858652224 18.492 100 32 64 4 1874321584 5744544 9924816
20:24:48 9795 8192000000 10775985680 11203743744 1864341632 18.538 100 30 60 1 1879645296 5867136 9436528
20:25:07 11095 8192000000 10777358240 11207688192 1868003200 18.568 100 15 30 1 1877972416 5253712 4715504
20:25:24 20450 8192000000 10782299488 11211583488 1871917712 18.600 100 27 55 3 1885735376 5877728 7939936
20:25:54 68482 8192000000 10790695904 11221622784 1879982560 18.665 100 29 58 1 1894657184 5785664 8888960
20:27:08 9523 8192000000 10817251904 11244871680 1895101408 18.787 100 24 48 2 1906819008 5307216 6410384
20:27:28 18312 8192000000 10844350400 11261988864 1912278304 18.925 100 53 105 3 1934967920 7244128 15445488
20:27:53 3056 8192000000 10871075904 11279683584 1925924960 19.034 100 72 143 0 1956572528 10501520 20146048
20:28:06 14257 8192000000 10861919216 11277369344 1928964000 19.059 100 58 113 2 1955357456 10837760 15555696
20:28:38 5947 8192000000 10869612400 11292237824 1931102944 19.076 100 51 102 0 1956406272 11353456 13949872
20:28:51 6618 8192000000 10877868752 11298799616 1940130176 19.148 100 58 116 1 1969363856 12838352 16395328
20:29:05 7484 8192000000 10879488720 11305623552 1944361136 19.182 100 60 118 2 1974346272 12550096 17435040
20:29:23 23339 8192000000 10870571648 11306270720 1928928528 19.058 99 52 104 1 1956775696 13190944 14656224
20:29:54 8688 8192000000 10884120064 11309981696 1949463760 19.222 100 58 109 4 1978176352 11965760 16746832
20:30:11 9672 8192000000 10887934000 11313971200 1952483088 19.246 100 51 100 2 1979659264 12977792 14198384
20:30:27 5507 8192000000 10893712912 11308388352 1942500240 19.167 99 63 128 3 1973614736 12970048 18144448
20:30:40 18321 8192000000 10895167392 11321552896 1956500576 19.278 100 55 110 1 1986064064 14027152 15536336
20:31:05 18150 8192000000 10890219344 11323142144 1959010688 19.298 100 54 109 0 1988971728 14658320 15302720
20:31:34 27646 8192000000 10891996448 11334103040 1961293344 19.316 100 38 76 3 1992065504 19561840 11210320
20:32:14 30884 8192000000 10909024656 11339177984 1969954272 19.385 100 51 100 1 1998806400 14187936 14664192
20:32:53 4097 8192000000 10906310528 11334230016 1953792112 19.257 99 57 115 3 1986546832 16166144 16588576
20:33:06 8062 8192000000 10919013056 11345727488 1975217328 19.427 100 67 134 2 2011727200 16008928 20500944
20:33:21 8166 8192000000 10915821408 11344154624 1974704704 19.423 100 63 126 4 2010803424 17789968 18308752
20:33:44 20232 8192000000 10925184848 11359346688 1981295952 19.475 100 55 110 0 2016020560 18674064 16050544
20:34:14 9195 8192000000 10924571376 11360923648 1984248128 19.498 100 48 96 0 2018425264 19773408 14403728
20:34:34 3524 8192000000 10934929120 11363864576 1990930304 19.551 100 66 129 2 2029129568 19496624 18702640
20:34:45 7782 8192000000 10931312512 11367723008 1990113616 19.545 100 54 106 2 2024458320 18672304 15672400
20:34:59 2399 8192000000 10958754768 11378167808 2002925872 19.646 100 85 170 2 2047443552 20207776 24309904
20:35:09 2317 8192000000 10964966704 11378008064 1981751872 19.479 99 85 172 1 2027977728 21563104 24662752
20:35:18 3214 8192000000 10954748944 11374510080 1996859520 19.598 100 78 152 1 2040193088 22155008 21178560
20:35:28 2666 8192000000 10948954544 11367895040 1988456128 19.532 100 77 154 1 2034106960 23285584 22365248
20:35:40 34408 8192000000 10953093456 11381567488 1994904208 19.583 100 60 120 0 2036980672 24667360 17409104
20:36:22 2072 8192000000 10935565360 11359232000 1982615712 19.485 99 69 138 2 2027124544 23628576 20880256
20:36:31 5179 8192000000 10948610672 11372183552 1991606400 19.556 100 71 142 1 2035014912 22611184 20797328
20:36:43 10875 8192000000 10941810736 11371388928 1992941200 19.567 100 71 141 2 2033758528 21463984 19353344
20:37:04 3127 8192000000 10943461984 11369099264 1978487328 19.453 99 78 156 2 2023123568 21958512 22677728
20:37:15 5834 8192000000 10946859168 11373527040 1992492320 19.563 100 75 150 0 2037400528 22935280 21972928
20:37:28 2295 8192000000 10956165664 11372662784 1993228480 19.569 100 85 171 3 2041165648 22989840 24947328
20:37:38 5232 8192000000 10949463696 11378814976 1994354064 19.578 100 68 135 2 2037161392 23617328 19190000
20:37:52 3170 8192000000 10957489968 11382747136 1999577360 19.619 100 72 143 2 2044222752 23400288 21245104
20:38:02 3857 8192000000 10951169808 11372195840 1978326688 19.451 99 75 148 0 2023595488 23792848 21475952
20:38:13 3393 8192000000 10957386944 11379040256 1996789296 19.597 100 81 162 0 2045339392 23792608 24757488
20:38:24 2681 8192000000 10968411312 11391016960 2008428208 19.689 100 87 174 2 2067144160 33301456 25414496
20:38:34 11131 8192000000 10957146752 11386957824 2001975136 19.638 100 65 130 2 2045964928 24219056 19770736
20:38:53 2529 8192000000 10957984688 11390787584 2003629968 19.651 100 64 128 1 2047560736 24930192 19000576
20:39:03 4844 8192000000 10961955680 11385204736 1987131296 19.521 99 66 132 2 2031386592 24554128 19701168
20:39:17 10353 8192000000 10947226160 11379572736 1990232624 19.546 100 68 136 0 2036344752 25749216 20362912
20:39:36 1370 8192000000 10952656864 11378446336 1990735248 19.550 100 78 155 0 2042440736 28001536 23703952
20:39:45 3734 8192000000 10953379056 11378388992 1985482304 19.508 100 71 140 0 2036342320 30019504 20840512
20:39:56 6750 8192000000 10953014400 11383373824 1987330064 19.523 100 62 124 0 2041503920 34958544 19215312
20:40:17 8572 8192000000 10963312592 11389808640 1991323952 19.554 100 65 130 2 2044046912 32488784 20234176
20:40:35 12052 8192000000 10950800528 11387445248 1979722944 19.463 99 59 118 2 2032427472 34344896 18359632
20:41:00 18761 8192000000 10951542656 11391299584 1974843200 19.424 99 51 100 2 2028319104 37317040 16158864
20:41:30 5769 8192000000 10968582688 11405860864 1999146960 19.616 100 48 94 0 2058595168 45136640 14311568
20:41:45 5311 8192000000 10956860736 11381071872 1973614320 19.414 99 61 123 0 2023854000 30778080 19461600
20:41:57 2002 8192000000 10929757872 11350011904 1961107136 19.315 99 67 134 4 2012145696 30219056 20819504
20:42:06 4258 8192000000 10934777248 11359514624 1955009696 19.266 99 66 131 0 2006058032 30643728 20404608
20:42:22 5067 8192000000 10947702320 11378913280 1982231904 19.482 100 61 122 0 2034467936 33277696 18958336
20:42:40 7671 8192000000 10963050048 11382763520 1983380832 19.491 100 70 140 3 2039466192 34367344 21718016
20:43:06 5412 8192000000 10938488224 11364634624 1958037040 19.290 99 59 118 0 2013154608 36534368 18583200
20:43:22 6052 8192000000 10948792928 11368640512 1975056096 19.426 100 75 148 0 2034400896 36365824 22978976
20:43:36 5815 8192000000 10947586016 11372695552 1959980368 19.306 99 77 155 2 2021572736 37091280 24501088
20:43:53 4157 8192000000 10955830160 11380154368 1982612128 19.485 100 78 155 1 2045187712 38065744 24509840
20:44:04 3092 8192000000 10972584448 11388420096 1989643376 19.541 100 88 177 1 2053525248 37007632 26874240
20:44:15 3185 8192000000 10965025456 11386929152 1986996656 19.520 100 73 145 1 2049945200 40151264 22797280
20:44:25 4786 8192000000 10957463104 11373760512 1972807456 19.408 100 79 158 0 2039791824 42378576 24605792
20:44:38 7290 8192000000 10962885104 11369078784 1956002192 19.274 99 83 165 2 2023610736 42329376 25279168
20:44:52 3979 8192000000 10968585440 11379896320 1974967728 19.425 100 86 171 2 2044629888 43566640 26095520
20:45:04 1490 8192000000 10975083552 11386703872 1983042720 19.489 100 86 170 2 2055310304 45357296 26910288
20:45:14 3080 8192000000 10967025728 11382022144 1974814288 19.424 100 85 170 3 2047547184 45772240 26960656
20:45:25 1760 8192000000 10973645184 11385462784 1978804720 19.455 100 93 183 3 2050228608 43284560 28139328
20:45:33 3888 8192000000 10981397760 11390443520 1985510592 19.508 100 80 157 0 2054232032 44166112 24555328
20:45:44 4144 8192000000 10981131424 11396997120 1989553200 19.540 100 89 177 0 2061311984 44654848 27103936
20:45:55 4495 8192000000 10969581648 11392847872 1995262416 19.585 100 80 160 0 2059370432 39861328 24246688
20:46:08 3797 8192000000 10961458672 11375611904 1970759984 19.391 100 82 164 0 2039391824 42487840 26144000
20:46:19 6095 8192000000 10945170144 11351023616 1948936672 19.218 99 78 157 4 2017355552 43733440 24685440
20:46:34 7821 8192000000 10905697184 11332456448 1932435280 19.086 99 61 122 0 1997168752 45206464 19527008
20:46:50 11109 8192000000 10915508544 11348856832 1943807520 19.177 100 51 103 1 2008450000 48024432 16618048
20:47:11 7745 8192000000 10919098976 11354497024 1944573408 19.183 100 49 98 0 2006296208 45161632 16561168
20:47:27 3994 8192000000 10906707648 11331813376 1915039904 18.947 98 64 128 0 1979995680 43772336 21183440
20:47:38 3052 8192000000 10902875872 11327807488 1907170496 18.884 98 50 101 0 1973710464 49662816 16877152
20:47:51 3177 8192000000 10953388288 11370766336 1956011920 19.274 100 74 148 1 2032423424 52448576 23962928
20:48:03 11842 8192000000 10934434944 11373420544 1960586448 19.311 100 44 87 0 2020454608 45298432 14569728
20:48:23 8456 8192000000 10919089200 11369906176 1956180896 19.276 100 36 72 0 2006323104 37750944 12391264
20:48:37 14516 8192000000 10907461040 11352588288 1922915600 19.010 98 35 70 5 1976098784 40579152 12604032
20:49:06 14582 8192000000 10907539936 11358523392 1952239712 19.244 100 33 66 2 2005359968 41718096 11402160
20:49:29 7664 8192000000 10931887472 11356819456 1956438000 19.278 100 40 78 2 2002577232 33805568 12333664
20:49:43 14564 8192000000 10915628160 11359854592 1946871232 19.202 99 29 58 0 1992898032 36528112 9498688
20:50:44 11858 8192000000 10916584080 11364225024 1960195872 19.308 100 30 60 0 2010357888 40556464 9605552
20:51:07 14129 8192000000 10899911440 11345567744 1944732640 19.185 100 30 60 1 1986419168 32177808 9508720
20:51:31 14141 8192000000 10901023664 11347640320 1947249216 19.205 100 32 64 1 1987535488 30379712 9906560
20:52:05 26863 8192000000 10889566624 11346829312 1942365392 19.166 100 21 42 1 1985430400 36039632 7025376
20:52:38 18980 8192000000 10891281424 11345022976 1935689296 19.112 100 20 40 1 1982328576 39239152 7400128
20:53:15 29414 8192000000 10899760720 11351769088 1918854848 18.978 99 18 36 0 1971263872 45143504 7265520
20:53:56 42290 8192000000 10855046688 11321384960 1886810608 18.720 98 22 44 2 1933001344 39021536 7169200
20:54:45 55320 8192000000 10869462592 11314929664 1906818032 18.881 99 22 44 2 1922242368 9349712 6074624
20:55:47 93305 8192000000 10848059168 11301814272 1875753168 18.631 97 39 75 0 1896129568 8269248 12107152
20:57:27 19224 8192000000 10869907280 11311165440 1933144256 19.092 100 31 63 1 1950363008 7869856 9348896
20:57:53 52042 8192000000 10870571872 11321196544 1927180128 19.044 99 17 35 0 1939019904 7234640 4605136
20:58:59 61273 8192000000 10877683216 11336749056 1944141216 19.180 99 25 49 0 1960132752 9783040 6208496
21:01:19 104587 8192000000 10888326592 11360366592 1952438224 19.246 99 16 32 0 1967354112 10348800 4567088
21:03:12 57437 8192000000 10891152624 11347968000 1964125440 19.339 100 21 41 0 1978721712 8533520 6062752
21:04:16 44824 8192000000 10840795424 11299663872 1906742176 18.880 97 21 42 1 1922385392 9682144 5961072
21:05:08 24538 8192000000 10857680080 11322028032 1942848384 19.169 100 13 27 0 1956694480 9672352 4173744
21:06:06 136934 8192000000 10869009840 11337465856 1897525136 18.806 97 13 26 0 1914194960 13056656 3613168
21:08:33 34011 8192000000 10884870160 11346333696 1956620976 19.279 100 24 48 1 1978360048 14554256 7184816
21:09:13 13389 8192000000 10889357920 11355152384 1971439008 19.397 100 32 63 1 1990035440 9393392 9203040
21:09:45 30695 8192000000 10906121200 11356852224 1974188192 19.419 100 43 83 2 1997750256 10169984 13392080
21:10:25 38694 8192000000 10892006448 11366813696 1977056176 19.441 100 35 67 2 1996374480 10011120 9307184
21:11:24 83483 8192000000 10900475904 11379871744 1985493184 19.508 100 15 30 0 2006134272 16875648 3765440
21:13:24 48491 8192000000 10909169872 11379531776 1988493680 19.532 100 29 58 2 2004487664 7712544 8281440
21:14:21 26458 8192000000 10902851472 11383234560 1988468528 19.532 100 9 18 0 2002393264 11484512 2440224
21:14:57 49730 8192000000 10905245360 11386187776 1990539920 19.548 100 17 34 0 2006655248 11554928 4560400
21:15:54 55013 8192000000 10913203696 11396173824 1991346000 19.554 100 7 14 0 2007993280 14204176 2443104
21:17:07 41571 8192000000 10906909632 11401617408 1972759024 19.407 99 7 14 0 1991617808 16696288 2162496
21:18:00 36391 8192000000 10919859696 11390590976 1988725376 19.534 100 19 37 0 2007507392 13542848 5239168
21:18:50 57368 8192000000 10911050864 11365654528 1942674992 19.168 98 16 32 1 1958882752 12084176 4123584
21:19:57 40210 8192000000 10892209120 11358904320 1938895024 19.138 98 30 60 1 1958011648 10745824 8370800
21:20:45 40376 8192000000 10882327552 11350982656 1936381248 19.118 98 25 50 0 1952956608 10117760 6457600
21:21:33 24795 8192000000 10913313376 11368923136 1957201312 19.284 99 31 60 2 1972491760 7126848 8163600
21:22:09 25622 8192000000 10918097088 11378909184 1983275968 19.491 100 32 64 0 2005611216 13193376 9141872
21:22:42 28403 8192000000 10913399056 11375026176 1966208528 19.355 99 33 66 2 1989253136 14300352 8744256
21:23:20 98251 8192000000 10883681488 11348877312 1883542608 18.694 95 16 32 0 1899054064 11327424 4184032
21:25:09 33881 8192000000 10917946192 11372666880 1958187376 19.292 99 39 78 0 1986599920 17467536 10945008
21:25:49 106106 8192000000 10881522176 11360468992 1894759856 18.784 96 23 46 1 1917196944 16099456 6337632
21:27:42 17976 8192000000 10878459968 11332104192 1892456096 18.766 96 26 52 0 1905142368 5700112 6986160
21:28:06 9159 8192000000 10901688160 11342258176 1944106144 19.180 99 58 109 1 1967363328 8565744 14691440
21:28:22 25165 8192000000 10885133536 11327291392 1890999264 18.754 96 52 104 1 1917436464 12314272 14122928
21:28:55 97340 8192000000 10854720320 11318829056 1818205392 18.163 93 22 44 1 1836003744 11797168 6001184
21:30:54 134451 8192000000 10836140144 11307929600 1833312896 18.286 95 12 24 0 1855492928 18860832 3319200
21:33:35 53186 8192000000 10860937472 11329687552 1907967216 18.890 99 24 48 0 1925577760 10731776 6878768
21:34:45 49335 8192000000 10870181504 11317755904 1921157616 18.996 99 32 64 2 1940307104 10413872 8735616
21:35:42 33315 8192000000 10856792416 11322277888 1911884960 18.922 99 34 67 1 1930711984 9227168 9599856
21:36:25 77540 8192000000 10838604576 11313627136 1873867936 18.616 97 10 20 3 1888645728 12004224 2773568
21:37:49 27605 8192000000 10845832016 11320102912 1929794320 19.065 100 5 10 0 1943732416 12820512 1117584
21:38:22 26050 8192000000 10830119520 11305185280 1853962432 18.454 96 4 8 0 1864173280 9158320 1052528
21:39:46 112893 8192000000 10864199440 11342745600 1930643296 19.072 99 11 22 0 1949823888 16663856 2516736
21:42:27 51225 8192000000 10893294448 11360055296 1951004272 19.234 100 21 42 2 1980458512 22783168 6671072
21:43:26 49059 8192000000 10883436576 11349950464 1885086192 18.706 96 18 36 0 1915445600 24569696 5789712
21:44:22 31076 8192000000 10897180656 11353657344 1935121792 19.108 99 33 66 1 1971510656 26027360 10361504
21:45:11 62650 8192000000 10907150112 11368955904 1954556080 19.263 100 17 34 0 1976696736 16541456 5599200
21:46:23 83620 8192000000 10878255104 11346227200 1907410768 18.886 97 18 36 2 1929934832 17247712 5276352
21:47:53 69170 8192000000 10872801984 11339644928 1925533936 19.031 99 12 24 0 1945647136 16587616 3525584
21:49:09 29472 8192000000 10882763808 11322155008 1895023824 18.786 97 29 58 1 1910782128 7949136 7809168
21:49:46 28987 8192000000 10849857312 11297402880 1908232608 18.892 98 48 96 0 1931384464 9328144 13823712
21:50:21 29963 8192000000 10876923840 11324968960 1898863568 18.817 98 36 72 1 1919629280 10439232 10326480
21:52:09 65662 8192000000 10876448672 11335938048 1899264576 18.820 97 15 30 1 1915355824 12191408 3899840
21:53:22 110046 8192000000 10862921888 11331747840 1892101136 18.763 97 14 28 0 1907497600 10945136 4451328
21:55:18 120480 8192000000 10884773216 11349852160 1931925504 19.082 99 23 46 1 1945995968 7895696 6174768
21:57:26 40648 8192000000 10888398640 11358912512 1952560480 19.247 99 16 32 0 1964439456 7533584 4345392
21:58:13 40025 8192000000 10865684160 11334316032 1937876112 19.130 98 8 16 1 1947716320 7631824 2208384
21:58:59 40004 8192000000 10864049952 11341381632 1930133728 19.068 98 16 32 1 1940728240 6526928 4067584
21:59:46 48422 8192000000 10888051008 11362177024 1966202256 19.355 100 10 20 0 1975492096 6767264 2522576
22:02:29 66812 8192000000 10908446832 11386789888 1960543376 19.310 99 6 10 1 1977130992 14561376 2026240
22:03:44 32027 8192000000 10920620320 11389468672 1989663024 19.541 100 29 57 3 2008208672 10369392 8176256
22:04:28 61281 8192000000 10896955536 11362902016 1905824160 18.873 96 21 42 0 1924933040 12925008 6183872
22:05:36 67075 8192000000 10907695136 11377688576 1952491728 19.246 99 14 28 0 1967545872 11167488 3886656
22:06:58 66870 8192000000 10895656928 11356995584 1878492656 18.653 95 21 42 0 1895531632 11106240 5932736
22:08:27 65492 8192000000 10910326848 11375755264 1951440640 19.238 99 10 20 2 1965956352 11658816 2856896
22:09:47 61744 8192000000 10891337696 11357835264 1926013584 19.035 98 17 33 1 1948155936 16811024 5331328
22:11:10 85548 8192000000 10907876560 11338121216 1873152032 18.610 96 32 63 0 1895473920 13087072 9234816
22:12:50 16043 8192000000 10891710720 11340918784 1945600816 19.191 100 49 99 0 1970456784 10790544 14065424
22:13:13 31157 8192000000 10909442016 11361816576 1931572352 19.079 99 32 64 1 1954793472 14578992 8642128
22:13:53 70887 8192000000 10888114880 11365699584 1894699376 18.784 97 17 34 1 1918126816 19385152 4042288
22:15:17 151166 8192000000 10842872624 11295850496 1815764272 18.143 93 20 40 0 1835370016 13936240 5669504
22:17:55 63481 8192000000 10845929728 11306254336 1870734240 18.590 97 19 38 2 1885821984 9811696 5276048
22:19:04 25699 8192000000 10847793936 11324887040 1922996064 19.011 100 13 26 0 1938909360 12630240 3283056
22:19:41 26848 8192000000 10837726768 11312984064 1908149264 18.892 99 5 10 0 1921095280 11457008 1489008
22:20:16 34603 8192000000 10835122304 11304673280 1890775696 18.752 98 9 18 0 1902760944 9459184 2526064
22:20:56 62528 8192000000 10813811456 11278434304 1843423408 18.369 96 8 13 2 1852547088 7246400 1877280
22:22:08 64932 8192000000 10856719344 11322953728 1927033888 19.043 100 26 50 3 1942250960 7572288 7644784
22:23:28 96073 8192000000 10850797024 11329003520 1919761120 18.985 99 19 38 1 1936759984 11186688 5812176
22:25:20 59923 8192000000 10823109408 11289903104 1808170128 18.081 94 10 20 0 1818533216 7633136 2729952
22:26:28 51833 8192000000 9151808752 9405218816 313541792 3.686 17 4 8 0 318384800 3787008 1056000

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 09-02-2021 22:28:51 to 09-02-2021 22:29:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 173 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-02-2021 22:29:23 to 09-02-2021 22:29:25.

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          240449
MON$OLDEST_ACTIVE               240450
MON$OLDEST_SNAPSHOT             240450
MON$NEXT_TRANSACTION            240450
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                       2014016
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 ---
:144: 
:145: mscs-test-161.budzdorov.ru    Tue Feb  9 22:27:26 2021
:146:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:147: 
--- end of diff output ---

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

09.02.21 22:29:26. 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-09 22:29:29 No severe PSQL-related problems occured
09.02.21 22:29:30. End of report.