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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16816836 kB
MemAvailable 31213720 kB
Buffers 0 kB
Cached 14851248 kB
SwapCached 4876 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-03 22:27:14
DTS_END                         2021-02-03 22:27:14.4180
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50436
TRN_ID                          247358
ATT_ID                          745
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: 9811.02 22893 1177322
customer order: creation 174.89 362 20987
customer order: refuse 16.20 366 1944
order to supplier: creation 46.59 1283 5591
order to supplier: removal 3.68 101318 442
invoice (draft): creation 46.22 3330 5546
invoice (draft): removal 57.41 803 6889
invoice accept: apply 43.11 18529 5173
invoice accept: cancel 52.60 830 6312
customer reserve: creation 3964.97 183 475796
customer reserve: removal 5092.12 58 611054
realization accept: apply 86.18 228 10341
realization accept: cancel 92.99 110 11159
payment from customer: creation 61.83 140 7419
payment from customer: removal 5.67 86 680
payment to supplier: creation 50.08 167 6010
payment to supplier: removal 3.64 81 437
service: total inventory turnovers 4.73 1157 568
service: total monetary turnovers 7.15 37 858
service: aggregate perf. data 0.93 16646 112
service: refresh index statistics 0.03 312151 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1953
TEST_TIME 2 3240
TEST_TIME 3 3316
TEST_TIME 4 3888
TEST_TIME 5 3881
TEST_TIME 6 4377
TEST_TIME 7 4458
TEST_TIME 8 4784
TEST_TIME 9 4991
TEST_TIME 10 5321
TEST_TIME 11 5487
TEST_TIME 12 5577
TEST_TIME 13 5655
TEST_TIME 14 5824
TEST_TIME 15 5955
TEST_TIME 16 6448
TEST_TIME 17 6708
TEST_TIME 18 7158
TEST_TIME 19 7376
TEST_TIME 20 7814
TEST_TIME 21 8233
TEST_TIME 22 8205
TEST_TIME 23 8306
TEST_TIME 24 8670
TEST_TIME 25 9099
TEST_TIME 26 9385
TEST_TIME 27 9874
TEST_TIME 28 9844
TEST_TIME 29 9683
TEST_TIME 30 9662
TEST_TIME 31 11116
TEST_TIME 32 11225
TEST_TIME 33 10975
TEST_TIME 34 11031
TEST_TIME 35 11066
TEST_TIME 36 11099
TEST_TIME 37 10902
TEST_TIME 38 10731
TEST_TIME 39 10535
TEST_TIME 40 10361
TEST_TIME 41 10391
TEST_TIME 42 10483
TEST_TIME 43 10438
TEST_TIME 44 10273
TEST_TIME 45 10260
TEST_TIME 46 10199
TEST_TIME 47 10176
TEST_TIME 48 10261
TEST_TIME 49 10248
TEST_TIME 50 10143
TEST_TIME 51 10163
TEST_TIME 52 10135
TEST_TIME 53 10054
TEST_TIME 54 10019
TEST_TIME 55 10008
TEST_TIME 56 9870
TEST_TIME 57 9903
TEST_TIME 58 9831
TEST_TIME 59 9880
TEST_TIME 60 9860
TEST_TIME 61 9889
TEST_TIME 62 9928
TEST_TIME 63 10037
TEST_TIME 64 10008
TEST_TIME 65 10016
TEST_TIME 66 10092
TEST_TIME 67 10189
TEST_TIME 68 10116
TEST_TIME 69 10195
TEST_TIME 70 10209
TEST_TIME 71 10212
TEST_TIME 72 10285
TEST_TIME 73 10189
TEST_TIME 74 10115
TEST_TIME 75 10077
TEST_TIME 76 10025
TEST_TIME 77 10078
TEST_TIME 78 10001
TEST_TIME 79 9940
TEST_TIME 80 9932
TEST_TIME 81 9948
TEST_TIME 82 9842
TEST_TIME 83 9823
TEST_TIME 84 9900
TEST_TIME 85 9878
TEST_TIME 86 9926
TEST_TIME 87 9986
TEST_TIME 88 9945
TEST_TIME 89 9930
TEST_TIME 90 9991
TEST_TIME 91 9934
TEST_TIME 92 10058
TEST_TIME 93 10067
TEST_TIME 94 10077
TEST_TIME 95 10116
TEST_TIME 96 10108
TEST_TIME 97 10147
TEST_TIME 98 10102
TEST_TIME 99 10018
TEST_TIME 100 10028
TEST_TIME 101 9993
TEST_TIME 102 9974
TEST_TIME 103 9946
TEST_TIME 104 9920
TEST_TIME 105 9912
TEST_TIME 106 9905
TEST_TIME 107 9836
TEST_TIME 108 9868
TEST_TIME 109 9856
TEST_TIME 110 9871
TEST_TIME 111 9837
TEST_TIME 112 9880
TEST_TIME 113 9847
TEST_TIME 114 9852
TEST_TIME 115 9859
TEST_TIME 116 9891
TEST_TIME 117 9873
TEST_TIME 118 9896
TEST_TIME 119 9883
TEST_TIME 120 9817

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-02-2021 22:28:04 to 03-02-2021 22:28:07.

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 1618029 1618029 0 0.00 0 55273 7 0 0
doc_list_biud 1618029 1618029 0 0.00 0 45645 28 0 0
sp_add_invoice_to_stock 5331 5173 158 2.96 29 193606 18529 0 158
sp_cancel_adding_invoice 6312 6312 0 0.00 5 79294 831 0 0
sp_cancel_client_order 1944 1944 0 0.00 5 13923 367 0 0
sp_cancel_customer_reserve 611054 611054 0 0.00 1 27470 58 0 0
sp_cancel_pay_from_customer 680 680 0 0.00 3 3530 87 0 0
sp_cancel_pay_to_supplier 437 437 0 0.00 3 4161 81 0 0
sp_cancel_supplier_invoice 6903 6889 14 0.20 2 45648 803 0 14
sp_cancel_supplier_order 442 442 0 0.00 10 1214912 101318 0 0
sp_cancel_write_off 11159 11159 0 0.00 1 9103 110 0 0
sp_client_order 20987 20987 0 0.00 3 18938 362 0 0
sp_customer_reserve 475796 475796 0 0.00 0 42771 183 0 0
sp_fill_shopping_cart 32113 32113 0 0.00 1 22409 36 0 0
sp_fill_shopping_cart_clo_res 475783 475783 0 0.00 0 17601 12 0 0
sp_get_clo_for_invoice 5157 5157 0 0.00 0 18984 267 0 0
sp_kill_cost_storno 18588 18588 0 0.00 0 5870 55 0 0
sp_kill_qstorno_ret_qs2qd 1240598 1240598 0 0.00 0 45644 32 0 0
sp_kill_qty_storno 653298 653298 0 0.00 0 45644 68 0 0
sp_lock_selected_doc 21589 21589 0 0.00 0 10718 9 0 0
sp_make_cost_storno 28927 28927 0 0.00 0 55147 98 0 0
sp_multiply_rows_for_pdistr 28927 28927 0 0.00 0 5973 27 0 0
sp_multiply_rows_for_qdistr 20987 20987 0 0.00 0 11779 152 0 0
sp_pay_from_customer 7419 7419 0 0.00 4 50611 141 0 0
sp_pay_to_supplier 6010 6010 0 0.00 5 50660 167 0 0
sp_payment_common 13429 13429 0 0.00 1 7836 28 0 0
sp_qd_handle_on_cancel_clo 1944 1944 0 0.00 0 13911 322 0 0
sp_qd_handle_on_invoice_upd_sts 11469 11469 0 0.00 0 14668 333 0 0
sp_qd_handle_on_reserve_upd_sts 10341 10341 0 0.00 0 10557 55 0 0
sp_reserve_write_off 10341 10341 0 0.00 7 54000 229 0 0
sp_supplier_invoice 5546 5546 0 0.00 8 112438 3330 0 0
sp_supplier_order 5591 5591 0 0.00 5 46332 1283 0 0
srv_aggregate_perf_data 112 112 0 0.00 3096 172526 16646 0 0
srv_fill_mon_cache_memory 175 175 0 0.00 1309 124529 29567 0 0
srv_find_qd_qs_mism 1128401 1128401 0 0.00 0 12108 5 0 0
srv_make_invnt_saldo 568 568 0 0.00 32 45588 1157 0 0
srv_make_money_saldo 858 858 0 0.00 1 8862 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 205696 409855 312151 0 0
t$perf-abend:sp_add_invoice_to_stock 158 158 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5173 5173 0 0.00 0 13964 159 0 0
t$perf-norm:sp_cancel_adding_invoice 455 455 0 0.00 0 13494 152 0 0
t$perf-norm:sp_cancel_client_order 1944 1944 0 0.00 0 9031 18 0 0
t$perf-norm:sp_cancel_customer_reserve 687 687 0 0.00 0 1376 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 680 680 0 0.00 0 2740 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 437 437 0 0.00 0 1886 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 412 412 0 0.00 0 3545 28 0 0
t$perf-norm:sp_cancel_supplier_order 442 442 0 0.00 0 19325 1604 0 0
t$perf-norm:sp_cancel_write_off 1034 1034 0 0.00 0 1092 4 0 0
t$perf-norm:sp_client_order 20987 20987 0 0.00 0 8167 16 0 0
t$perf-norm:sp_customer_reserve 1043 1043 0 0.00 0 447 5 0 0
t$perf-norm:sp_pay_from_customer 7419 7419 0 0.00 0 6628 9 0 0
t$perf-norm:sp_pay_to_supplier 6010 6010 0 0.00 0 20634 12 0 0
t$perf-norm:sp_reserve_write_off 10341 10341 0 0.00 0 8629 11 0 0
t$perf-norm:sp_supplier_invoice 5546 5546 0 0.00 0 4704 17 0 0
t$perf-norm:sp_supplier_order 5591 5591 0 0.00 0 22542 20 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 619 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 175 175 0 0.00 0 297 5 0 0
t$perf-norm:srv_make_invnt_saldo 568 568 0 0.00 0 1636 23 0 0
t$perf-norm:srv_make_money_saldo 858 858 0 0.00 0 1209 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10628 10312 316 2.97 0 7025 20 0 316
v_all_customers 38744 38744 0 0.00 0 64 1 0 0
v_all_suppliers 30720 30720 0 0.00 0 22 1 0 0
v_all_wares 41972 41972 0 0.00 0 33 1 0 0
v_cancel_adding_invoice 910 910 0 0.00 0 2006 11 0 0
v_cancel_client_order 3888 3888 0 0.00 0 6591 11 0 0
v_cancel_customer_prepayment 1360 1360 0 0.00 0 1495 5 0 0
v_cancel_customer_reserve 1374 1374 0 0.00 0 898 4 0 0
v_cancel_payment_to_supplier 874 874 0 0.00 0 1180 6 0 0
v_cancel_supplier_invoice 852 824 28 3.28 0 1169 14 0 28
v_cancel_supplier_order 884 884 0 0.00 0 1309 5 0 0
v_cancel_write_off 2068 2068 0 0.00 0 4701 20 0 0
v_max_id_clo_ord 5589 5589 0 0.00 0 2531 2 0 0
v_max_id_clo_res 1043 1043 0 0.00 0 1716 10 0 0
v_max_id_ord_sup 5538 5538 0 0.00 0 4288 4 0 0
v_max_non_paid_invoice 1777 1777 0 0.00 0 1675 3 0 0
v_max_non_paid_realizn 3749 3749 0 0.00 0 3890 6 0 0
v_min_id_clo_ord 5589 5589 0 0.00 0 2879 6 0 0
v_min_id_clo_res 1043 1043 0 0.00 0 7595 11 0 0
v_min_id_ord_sup 5538 5538 0 0.00 0 12092 12 0 0
v_min_non_paid_invoice 6010 6010 0 0.00 0 7659 15 0 0
v_min_non_paid_realizn 7419 7419 0 0.00 0 7833 20 0 0
v_our_firm 10568 10568 0 0.00 0 18 1 0 0
v_reserve_write_off 20680 20680 0 0.00 0 7411 9 0 0
x_lock_depdocs_on_canc_invoice 12789 12789 0 0.00 0 11585 111 0 0
x_lock_depdocs_on_canc_sup_ord 442 442 0 0.00 0 3491 309 0 0
x_make_qstorno_1000_1200 5591 5591 0 0.00 2 43438 1199 0 0
x_make_qstorno_1200_2000 5546 5546 0 0.00 2 112420 3204 0 0
x_make_qstorno_2100_3300 475796 475796 0 0.00 0 42770 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-02-2021 22:28:08 to 03-02-2021 22:28:12.

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:18 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:24 30059 8192000000 10306914592 10618343424 944772592 10.340 70 60 120 0 966933472 2835888 19324992
19:58:04 30582 8192000000 10369917824 10690232320 1411104448 14.694 100 85 170 0 1444649808 5624928 27920432
19:58:45 24951 8192000000 10396588000 10720043008 1449708128 15.035 100 92 185 0 1486923600 7093744 30121728
19:59:26 28363 8192000000 10426397088 10752884736 1468089712 15.197 100 88 177 0 1505160128 8255856 28814560
20:00:03 23636 8192000000 10443112320 10772578304 1489884608 15.388 100 91 180 1 1527390640 8608960 28897072
20:00:35 19826 8192000000 10455646144 10790154240 1511688608 15.578 100 90 180 0 1550136864 9642784 28805472
20:01:10 12504 8192000000 10467773088 10805522432 1525618096 15.699 100 88 176 0 1563739168 10013264 28107808
20:01:38 18124 8192000000 10511268608 10855739392 1558675920 15.985 100 80 160 1 1593532496 10572096 24284480
20:02:10 11275 8192000000 10541364864 10895970304 1592914128 16.279 100 78 156 0 1628012736 11180976 23917632
20:02:42 9673 8192000000 10579071632 10940284928 1639313136 16.674 100 80 160 1 1675060032 12091664 23655232
20:03:06 12557 8192000000 10598389328 10959904768 1657599824 16.829 100 85 171 0 1695652208 12794032 25258352
20:03:26 11420 8192000000 10599273056 10966720512 1662793008 16.872 100 79 156 4 1699107184 12678992 23635184
20:03:45 8775 8192000000 10617878496 10983636992 1677160368 16.993 100 78 156 1 1712670176 12761472 22748336
20:04:01 8390 8192000000 10627522464 10995269632 1690555904 17.106 100 82 164 2 1727509536 12826800 24126832
20:04:18 8629 8192000000 10652356656 11025784832 1707301824 17.246 100 68 137 0 1738299120 11570512 19426784
20:04:34 4696 8192000000 10647614640 11028164608 1720913888 17.360 100 73 146 2 1753573360 11508512 21150960
20:04:46 4733 8192000000 10680697024 11059941376 1741350240 17.530 100 75 150 1 1778283200 15387200 21545760
20:04:57 5273 8192000000 10696359888 11075407872 1757559216 17.664 100 82 164 1 1793526352 12923648 23043488
20:05:10 5671 8192000000 10704122480 11082375168 1766990832 17.742 100 80 160 1 1802542368 13647952 21903584
20:05:23 4124 8192000000 10716498048 11092754432 1776661840 17.822 100 87 175 0 1814723360 13803840 24257680
20:05:34 12659 8192000000 10717700080 11102093312 1782409600 17.869 100 78 156 1 1818348480 14811552 21127328
20:05:53 3337 8192000000 10724471712 11113140224 1787494816 17.911 100 73 147 0 1821927888 14114032 20319040
20:06:04 3942 8192000000 10748229632 11138052096 1813307136 18.123 100 81 160 1 1849256640 13104000 22845504
20:06:14 2752 8192000000 10766180752 11154149376 1822234528 18.196 100 80 159 1 1857491568 12705552 22551488
20:06:23 2478 8192000000 10777150624 11160698880 1831712048 18.273 100 86 173 0 1868714576 12848336 24154192
20:06:33 2311 8192000000 10772733264 11158503424 1836688448 18.314 100 88 176 1 1875381824 13726192 24967184
20:06:41 2115 8192000000 10781676352 11166932992 1843309728 18.368 100 90 179 1 1882025232 14147968 24567536
20:06:50 2473 8192000000 10787924464 11171336192 1845663456 18.387 100 92 185 1 1885257648 13863248 25730944
20:06:59 1791 8192000000 10781507840 11178237952 1848098816 18.407 100 87 174 0 1885813392 13221728 24492848
20:07:07 2539 8192000000 10794968208 11187957760 1849306400 18.416 100 81 160 1 1885862112 14065072 22490640
20:07:16 1931 8192000000 10791600416 11187245056 1852914400 18.446 100 85 170 0 1889252336 12254240 24083696
20:07:25 2300 8192000000 10802912416 11192942592 1856355024 18.474 100 86 168 4 1893556192 13091888 24109280
20:07:34 1576 8192000000 10803070272 11193565184 1862399024 18.523 100 93 186 0 1902619056 12975120 27244912
20:07:42 2084 8192000000 10809380208 11199524864 1869155792 18.577 100 94 185 0 1908547616 12569520 26822304
20:07:50 2047 8192000000 10801721728 11202293760 1866300704 18.554 100 73 148 0 1900582208 13010416 21271088
20:07:59 2231 8192000000 10797145248 11199750144 1871315952 18.595 100 62 124 2 1899924160 10750080 17858128
20:08:07 2796 8192000000 10802215872 11208167424 1871413616 18.596 100 65 130 1 1901421184 12250608 17756960
20:08:18 1878 8192000000 10806054112 11212464128 1873074656 18.609 100 66 132 1 1907662720 16420352 18167712
20:08:26 12338 8192000000 10798048592 11213799424 1877177584 18.642 100 50 100 0 1900512528 8353920 14981024
20:09:03 13934 8192000000 10805698368 11212832768 1880011488 18.665 100 44 89 0 1898593168 5104560 13477120
20:09:24 6489 8192000000 10790038464 11215716352 1878170544 18.650 100 28 54 1 1893544992 6786832 8587616
20:09:42 7697 8192000000 10782628080 11217494016 1880252160 18.667 100 27 55 1 1894945232 5992800 8700272
20:09:56 5368 8192000000 10796088512 11223769088 1883942432 18.697 100 34 67 0 1901916672 7572800 10401440
20:10:08 6981 8192000000 10792160112 11221196800 1884622000 18.702 100 37 70 3 1900582144 6457712 9502432
20:10:28 10289 8192000000 10789075552 11226435584 1887296464 18.724 100 20 40 2 1899892736 6812416 5783856
20:10:46 7847 8192000000 10798207840 11227398144 1889528144 18.742 100 22 45 1 1902141584 6318528 6294912
20:11:00 11626 8192000000 10798068128 11231117312 1891559296 18.758 100 19 38 1 1903118416 6051008 5508112
20:11:17 11392 8192000000 10802863872 11232030720 1890972944 18.754 100 13 26 0 1900520000 5812720 3734336
20:11:37 5842 8192000000 10800191872 11234480128 1891846016 18.761 100 16 32 0 1902231120 6053376 4331728
20:11:49 10149 8192000000 10807467376 11240939520 1892551600 18.766 100 12 24 1 1901186512 4987136 3647776
20:12:06 16444 8192000000 10812994896 11238744064 1896940928 18.802 100 35 71 0 1912441552 5978624 9522000
20:12:29 83669 8192000000 10817523504 11251617792 1900185328 18.828 100 23 45 1 1912203792 5492000 6526464
20:13:59 11997 8192000000 10826116992 11257774080 1907526976 18.887 100 22 45 2 1919341856 5272976 6541904
20:14:18 4237 8192000000 10828052912 11260866560 1909772816 18.905 100 36 69 3 1926694064 6794432 10126816
20:14:30 7446 8192000000 10828067744 11266576384 1910521232 18.911 100 22 45 1 1926438960 9461312 6456416
20:14:44 5529 8192000000 10830347024 11263762432 1909760592 18.905 100 21 41 4 1920893104 5252208 5880304
20:14:55 11170 8192000000 10821003040 11257798656 1909591264 18.903 100 21 40 0 1920981568 5988032 5402272
20:15:13 7315 8192000000 10815287472 11260899328 1910557440 18.911 100 26 52 0 1924127280 5916112 7653728
20:15:28 6897 8192000000 10817339808 11258769408 1908198608 18.892 100 16 32 0 1918025312 5327456 4499248
20:15:43 6687 8192000000 10815904768 11254718464 1892970704 18.770 99 25 47 2 1905661008 6100128 6590176
20:15:56 9920 8192000000 10815231088 11252146176 1903734400 18.856 100 23 46 0 1916664000 6623264 6306336
20:16:13 7993 8192000000 10809090752 11243270144 1861935792 18.519 98 25 51 2 1879063792 10553232 6574768
20:16:29 9234 8192000000 10797763888 11230642176 1854066432 18.455 98 19 37 2 1868965712 10047488 4851792
20:16:46 7853 8192000000 10780029696 11204308992 1864181536 18.537 100 20 39 1 1876107984 5919920 6006528
20:17:01 9520 8192000000 10786953040 11224023040 1875638400 18.630 100 15 30 2 1885717376 6068416 4010560
20:17:21 15701 8192000000 10766820464 11191922688 1805788544 18.061 96 27 54 2 1819312208 5710208 7813456
20:17:43 49176 8192000000 10808340320 11201576960 1826418080 18.230 97 63 125 4 1850435360 5110192 18907088
20:18:43 11463 8192000000 10746248640 11178524672 1786762400 17.905 96 13 26 0 1795843360 5463408 3617552
20:19:03 8180 8192000000 10735442720 11148759040 1745545568 17.565 95 19 38 0 1756325376 4952272 5827536
20:19:20 5024 8192000000 10731524448 11143987200 1769018880 17.759 97 40 80 2 1787731200 7398416 11313904
20:19:32 4091 8192000000 10712787728 11118489600 1734147216 17.470 96 36 72 0 1751783744 7496560 10139968
20:19:43 7143 8192000000 10711680496 11132276736 1780073200 17.850 99 21 42 0 1792099712 5943376 6083136
20:19:57 6880 8192000000 10669443744 11085070336 1722764896 17.375 96 24 47 2 1735189344 5873280 6551168
20:20:10 8096 8192000000 10669882880 11084697600 1676304304 16.986 94 20 41 2 1688333392 6038896 5990192
20:20:24 5794 8192000000 10691572928 11112787968 1763684032 17.715 99 32 63 1 1778733456 6065680 8983744
20:20:36 8270 8192000000 10694677680 11104120832 1736126656 17.486 97 24 48 4 1748689120 5457776 7104688
20:20:51 6732 8192000000 10725621392 11135164416 1800929424 18.022 100 34 67 5 1816799712 5252912 10617376
20:21:06 11555 8192000000 10707671216 11125899264 1753810976 17.633 97 24 47 2 1766302128 5582048 6909104
20:21:25 8087 8192000000 10728706144 11144237056 1793565200 17.961 99 23 48 2 1805182608 4902496 6714912
20:21:44 11825 8192000000 10716861120 11143438336 1794557024 17.969 99 24 47 2 1806883392 5354896 6971472
20:22:09 78181 8192000000 10731489472 11153797120 1782535408 17.870 98 37 73 2 1798320096 5026800 10757888
20:23:35 6883 8192000000 10745676560 11164315648 1810342080 18.099 99 27 54 1 1824813328 6702304 7768944
20:23:49 4934 8192000000 10758047840 11176194048 1833508016 18.288 100 36 72 0 1851579408 7930096 10141296
20:24:00 6596 8192000000 10766708336 11183214592 1842562848 18.362 100 31 62 1 1857622640 6151584 8908208
20:24:14 6895 8192000000 10759328224 11185377280 1843689632 18.371 100 32 64 1 1858787856 6682624 8415600
20:24:28 14172 8192000000 10755427632 11190521856 1850235568 18.424 100 28 55 2 1864620064 4987872 9396624
20:24:48 8196 8192000000 10770312752 11197026304 1857095088 18.480 100 23 46 3 1869767712 5969056 6703568
20:25:03 5146 8192000000 10773280144 11203801088 1857527408 18.483 100 32 64 1 1876824256 10238784 9058064
20:25:17 8245 8192000000 10775965776 11204575232 1858237520 18.489 100 11 22 1 1866868528 5273584 3357424
20:25:32 7974 8192000000 10779447216 11209363456 1863768912 18.534 100 13 27 0 1872912704 4893664 4250128
20:25:50 7773 8192000000 10785653744 11214372864 1866587648 18.557 100 21 42 0 1878107776 5667056 5853072
20:26:04 14945 8192000000 10789204352 11216637952 1873233952 18.610 100 25 50 1 1886512528 5675696 7602880
20:26:26 13346 8192000000 10786184896 11220602880 1872480288 18.604 100 12 24 0 1882037888 5996432 3561168
20:26:50 12328 8192000000 10796077824 11226583040 1875278944 18.627 100 9 18 1 1883529792 5536160 2714688
20:27:09 59905 8192000000 10836801024 11256860672 1892823120 18.769 100 33 66 1 1908523136 6728144 8971872
20:28:21 54998 8192000000 10836898800 11267264512 1908478064 18.894 100 32 62 2 1926392016 9107408 8806544
20:29:22 37644 8192000000 10845676480 11280465920 1919630896 18.984 100 32 63 0 1939615264 11279136 8705232
20:30:08 2807 8192000000 10865450240 11288866816 1928655776 19.056 100 50 100 2 1954923120 11554592 14712752
20:30:18 4232 8192000000 10875908368 11298066432 1933149216 19.092 100 52 103 4 1960325616 12656384 14520016
20:30:40 22023 8192000000 10876974640 11302948864 1916416944 18.958 99 42 84 1 1944986832 16986688 11583200
20:31:09 10580 8192000000 10881374368 11310747648 1936924304 19.122 100 49 95 1 1971886192 21436928 13524960
20:31:26 24498 8192000000 10894300944 11320029184 1944160112 19.180 100 50 97 1 1977423376 19429184 13834080
20:31:57 7399 8192000000 10898458016 11317899264 1947723648 19.208 100 54 107 0 1982209104 19007248 15478208
20:32:12 8143 8192000000 10894554064 11324682240 1954514992 19.262 100 62 122 1 1992463168 19348704 18599472
20:32:35 26943 8192000000 10905242464 11333734400 1959025104 19.298 100 55 109 1 1994968640 20209920 15733616
20:33:14 11330 8192000000 10918427744 11347345408 1967288416 19.364 100 60 120 3 2012663952 28049408 17326128
20:33:40 6698 8192000000 10921707904 11353309184 1968877392 19.377 100 45 90 0 2011126272 29156944 13091936
20:33:55 8676 8192000000 10922964480 11348176896 1955437184 19.270 99 61 122 0 1999406784 25423488 18546112
20:34:11 17236 8192000000 10931391424 11363803136 1977247200 19.443 100 59 116 0 2019890064 26184432 16458432
20:34:38 3925 8192000000 10932561488 11363553280 1981967760 19.480 100 59 117 3 2030113472 31059552 17086160
20:34:51 11827 8192000000 10934768848 11366547456 1984476720 19.500 100 54 106 3 2026912800 26554032 15882048
20:35:12 4850 8192000000 10925958272 11352031232 1947296496 19.205 98 56 112 0 1990982144 27290432 16395216
20:35:29 17179 8192000000 10908246128 11351998464 1969945712 19.385 100 43 86 4 2009900384 27277456 12677216
20:35:55 10401 8192000000 10925366784 11360174080 1975185744 19.427 100 50 100 0 2016524528 26572464 14766320
20:36:14 5740 8192000000 10938522768 11364544512 1963365392 19.333 99 59 118 1 2010526672 29393328 17767952
20:36:26 11091 8192000000 10923048208 11351769088 1959390880 19.301 99 62 123 1 2007862496 30399168 18072448
20:36:46 2495 8192000000 10956211968 11365634048 1980468800 19.468 100 74 146 2 2032987040 30649056 21869184
20:36:55 5599 8192000000 10952142272 11375435776 1984577616 19.501 100 63 125 1 2034607392 31775232 18254544
20:37:09 12120 8192000000 10954780928 11377324032 1988814336 19.534 100 71 141 3 2041865392 32284112 20766944
20:37:32 4524 8192000000 10972842672 11392012288 1998332480 19.610 100 74 148 0 2053807984 33222656 22252848
20:37:44 4668 8192000000 10958069776 11376263168 1977611472 19.446 99 64 125 0 2029043072 32612512 18819088
20:37:56 1784 8192000000 10970685856 11390140416 2000961840 19.630 100 79 160 1 2058215424 32985040 24268544
20:38:04 2507 8192000000 10981445328 11394457600 2000732976 19.629 100 84 167 1 2058692240 33335056 24624208
20:38:16 4166 8192000000 10952248240 11385438208 1981316912 19.475 99 65 130 2 2034960560 33750544 19893104
20:38:28 2461 8192000000 10967166144 11383504896 1994854992 19.582 100 65 126 1 2046522848 32795648 18872208
20:38:39 11372 8192000000 10966181120 11394699264 2001087984 19.631 100 73 146 3 2057393584 34468832 21836768
20:38:58 4642 8192000000 10973173408 11390152704 1985470688 19.508 99 74 148 1 2042913024 35302992 22139344
20:39:10 4788 8192000000 10970275408 11395452928 2001745568 19.636 100 64 128 1 2056859472 36103264 19010640
20:39:24 5720 8192000000 10972982144 11401338880 2007184592 19.679 100 60 121 0 2062670128 36810832 18674704
20:39:38 5395 8192000000 10972203408 11394633728 1999747936 19.621 100 63 126 0 2055157504 35673552 19736016
20:39:51 4279 8192000000 10922753312 11338510336 1926937888 19.042 96 70 140 1 1985206368 36214912 22053568
20:40:03 6109 8192000000 10956884016 11379363840 1982111296 19.481 100 77 151 0 2041852240 36539008 23201936
20:40:17 12965 8192000000 10953717312 11383484416 1988308368 19.530 100 62 123 0 2045189504 37680800 19200336
20:40:40 3920 8192000000 10965159600 11395403776 1993089552 19.568 100 58 116 2 2049145408 38452896 17602960
20:40:51 2435 8192000000 10947636000 11363737600 1968854784 19.376 99 73 145 2 2031094048 39691104 22548160
20:41:04 13557 8192000000 10962058912 11381911552 1982233952 19.482 100 81 162 1 2048830496 42269344 24327200
20:41:24 4929 8192000000 10963626832 11379683328 1979565728 19.461 100 82 164 0 2049256080 44050144 25640208
20:41:41 3950 8192000000 10959899376 11382198272 1982745664 19.486 100 72 144 1 2048047056 42811360 22490032
20:41:53 4932 8192000000 10967473536 11388194816 1986937024 19.520 100 73 146 0 2051400432 42032112 22431296
20:42:06 5231 8192000000 10967170976 11383001088 1978945024 19.456 100 75 150 2 2046125232 43763632 23416576
20:42:18 2877 8192000000 10948653616 11377389568 1974262080 19.419 100 59 118 1 2035810240 43092304 18455856
20:42:31 7795 8192000000 10955697392 11370688512 1939005984 19.139 98 75 150 2 2006819552 43856432 23957136
20:42:51 5166 8192000000 10949727040 11374931968 1966733216 19.360 100 58 117 0 2034260720 48596512 18930992
20:43:04 3994 8192000000 10966900400 11374366720 1953092464 19.251 99 78 155 0 2026850704 49072848 24685392
20:43:15 2530 8192000000 10941469136 11353657344 1944789520 19.185 99 84 168 1 2021095824 50451824 25854480
20:43:31 13200 8192000000 10922608320 11348353024 1915807744 18.953 98 75 149 6 1991398976 52277168 23314064
20:43:56 2978 8192000000 10908215184 11321577472 1910634448 18.912 99 73 146 0 1980140144 47033088 22472608
20:44:08 6136 8192000000 10919870704 11337707520 1935226560 19.109 100 71 142 1 2003914480 46167808 22520112
20:44:22 3271 8192000000 10911063456 11322671104 1922520448 19.007 99 75 149 3 1990582768 45426976 22635344
20:44:35 3247 8192000000 10933802368 11352428544 1949465360 19.222 100 82 163 3 2023212080 47508080 26238640
20:44:45 1572 8192000000 10937523680 11348008960 1930201568 19.068 99 85 171 2 2005337760 48207920 26928272
20:44:56 3590 8192000000 10924964128 11337539584 1918883840 18.978 99 90 180 2 1996561536 48958432 28719264
20:45:08 3916 8192000000 10924710736 11338190848 1943584816 19.175 100 87 173 2 2018706144 47533456 27587872
20:45:19 3635 8192000000 10923328992 11337576448 1938597888 19.136 100 75 150 2 2005103520 42735392 23770240
20:45:30 3806 8192000000 10927381104 11344941056 1945260368 19.189 100 66 133 4 2007910800 41080784 21569648
20:45:42 2961 8192000000 10945441792 11358150656 1956107424 19.275 100 80 157 2 2022789920 42128800 24553696
20:45:52 6033 8192000000 10948383888 11362619392 1955377184 19.269 100 82 164 0 2024748864 43309280 26062400
20:46:06 3511 8192000000 10946879536 11363024896 1944538336 19.183 99 77 154 0 2013591296 44973856 24079104
20:46:15 1860 8192000000 10944697200 11359985664 1942627328 19.168 99 80 160 1 2016772912 48736144 25409440
20:46:25 1928 8192000000 10930565504 11347595264 1933338832 19.094 99 79 154 1 2007384640 50080816 23964992
20:46:34 4033 8192000000 10946604736 11368660992 1952633872 19.247 100 72 143 1 2030764208 55012128 23118208
20:46:45 3401 8192000000 10964223360 11379335168 1961412128 19.317 100 74 146 0 2033001664 48331456 23258080
20:46:55 3786 8192000000 10957008784 11372847104 1947742704 19.208 99 78 156 0 2021874640 49956800 24175136
20:47:06 3147 8192000000 10973800608 11383836672 1967707696 19.367 100 79 157 2 2045296160 53574448 24014016
20:47:18 4658 8192000000 10959344864 11373391872 1954815008 19.265 100 77 152 2 2032978784 53783456 24380320
20:47:35 4410 8192000000 10961423936 11377143808 1943207840 19.172 99 74 148 0 2023727600 56803200 23716560
20:47:47 1309 8192000000 10960224640 11376197632 1958167296 19.291 100 76 148 1 2039266224 57156192 23942736
20:47:55 2885 8192000000 10961459344 11376918528 1959763328 19.304 100 79 159 2 2039155216 54739440 24652448
20:48:05 6257 8192000000 10941003440 11365826560 1961664784 19.319 100 56 112 0 2020698224 41961600 17071840
20:48:19 13080 8192000000 10925593680 11369893888 1960539312 19.310 100 34 68 1 2013478064 41707104 11231648
20:48:39 8419 8192000000 10943293200 11378802688 1964504480 19.342 100 43 87 2 2018268928 39769824 13994624
20:49:00 3808 8192000000 10944889424 11381710848 1972234176 19.403 100 42 84 1 2029234144 43415600 13584368
20:49:25 7582 8192000000 10956216144 11388944384 1971321920 19.396 100 51 102 2 2033993760 45629040 17042800
20:49:48 4900 8192000000 10967053872 11402317824 1980235728 19.467 100 52 100 1 2047361520 50683600 16442192
20:50:01 3107 8192000000 10978238448 11401224192 1963234016 19.332 99 66 133 3 2041815952 57156480 21425456
20:50:12 10154 8192000000 10969796480 11401211904 1979452800 19.460 100 54 108 4 2052014656 54851152 17710704
20:50:32 13333 8192000000 10961866528 11395944448 1969149216 19.379 100 51 102 0 2039870960 53887264 16834480
20:50:52 14357 8192000000 10973982080 11413479424 1980997280 19.473 100 43 86 0 2052991136 56960848 15033008
20:51:13 6693 8192000000 10956845376 11397591040 1972081264 19.402 100 38 76 2 2039902288 54189040 13631984
20:51:31 13232 8192000000 10954267408 11393425408 1958807904 19.297 99 35 70 4 2023296144 52071696 12416544
20:51:53 6952 8192000000 10955124448 11394576384 1969035440 19.378 100 41 82 0 2035826544 52837104 13954000
20:52:15 10990 8192000000 10952619952 11398557696 1969587792 19.382 100 32 64 1 2032153824 51506816 11059216
20:52:45 9572 8192000000 10944785472 11399487488 1966865744 19.361 100 33 66 1 2029113136 51209760 11037632
20:53:12 23471 8192000000 10945973184 11397988352 1954455424 19.262 99 26 52 0 2014392192 51237088 8699680
20:53:46 20371 8192000000 10936361408 11387613184 1964076368 19.338 100 25 50 1 2024151728 51348912 8726448
20:54:15 16126 8192000000 10925916944 11394465792 1961828240 19.321 100 20 40 0 2017215792 48419600 6967952
20:54:39 6532 8192000000 10934628976 11393843200 1960858640 19.313 100 27 54 2 2019678416 49322160 9497616
20:55:00 17793 8192000000 10929242176 11394310144 1960303472 19.308 100 21 42 2 2009606992 42434528 6868992
20:55:32 24713 8192000000 10912103264 11370024960 1920616272 18.992 98 18 36 0 1967830400 41528304 5685824
20:56:04 22237 8192000000 10918820656 11376021504 1942725392 19.168 100 20 40 2 2000166192 50262384 7178416
20:56:41 27259 8192000000 10912475088 11369177088 1926125328 19.036 99 20 40 3 1990949088 57327200 7496560
20:57:18 16525 8192000000 10943429376 11396194304 1943198880 19.172 100 24 47 2 2010206736 58686912 8320944
20:57:41 14999 8192000000 10953857520 11413254144 1959278448 19.300 100 23 46 0 2032245040 64444400 8522192
20:58:05 58964 8192000000 10896898880 11370962944 1964640096 19.343 100 15 30 0 1990000064 21001696 4358272
20:59:11 80156 8192000000 10901648960 11361374208 1948808304 19.217 99 9 18 0 1961301632 10496528 1996800
21:00:41 5818 8192000000 10942457984 11371036672 1985500944 19.508 100 65 131 3 2009233488 6948096 16784448
21:00:58 15480 8192000000 10926441568 11354984448 1962482576 19.326 99 57 115 2 1990450352 11638304 16329472
21:01:23 39247 8192000000 10904664224 11365810176 1947022624 19.203 99 8 16 0 1962647168 13247520 2377024
21:02:08 124513 8192000000 10876780448 11345661952 1867182144 18.561 95 7 14 0 1884963808 16295840 1485824
21:04:19 49064 8192000000 10913467776 11345530880 1942564272 19.167 99 34 65 1 1959073968 6181632 10328064
21:05:22 33625 8192000000 10916449504 11356454912 1969488016 19.381 100 43 86 1 1990420176 9139456 11792704
21:06:05 29319 8192000000 10902556960 11362922496 1970963904 19.393 100 32 64 0 1989324752 9497504 8863344
21:06:48 57153 8192000000 10928872624 11376582656 1974681632 19.423 100 39 79 1 1994794256 9320592 10792032
21:08:00 93298 8192000000 10912628784 11362693120 1939855568 19.146 98 25 50 2 1959356064 11974560 7525936
21:09:43 70616 8192000000 10905309536 11373469696 1952652656 19.248 99 35 69 0 1977000112 14530416 9817040
21:11:04 34379 8192000000 10907470256 11375194112 1977572800 19.445 100 17 31 4 1991661952 9162336 4926816
21:12:11 34281 8192000000 10920440032 11387817984 1987366928 19.523 100 16 32 0 2000133600 8110096 4656576
21:12:52 18673 8192000000 10926450800 11395252224 1994140192 19.576 100 25 49 1 2010079888 8774208 7165488
21:13:18 32077 8192000000 10925420368 11391533056 1976870624 19.440 99 26 53 3 1997952784 13371360 7710800
21:13:57 29120 8192000000 10943795856 11389235200 1981504032 19.477 99 48 95 2 2005723952 9835360 14384560
21:14:33 38052 8192000000 10953970992 11401908224 2004892144 19.661 100 59 117 3 2036103392 13807264 17403984
21:15:17 9924 8192000000 10954904912 11409870848 2004994496 19.662 100 47 94 3 2034961376 16349888 13616992
21:15:35 67368 8192000000 10902621168 11392237568 1955788352 19.273 98 10 20 0 1970267184 11733328 2745504
21:17:17 65926 8192000000 10892502592 11368353792 1947946368 19.210 98 11 22 0 1962009440 10648672 3414400
21:18:30 36038 8192000000 10906812512 11378647040 1958471760 19.294 99 20 39 0 1978137424 13576016 6089648
21:19:26 56424 8192000000 10906677328 11379769344 1961854032 19.321 99 15 30 0 1976058592 10245520 3959040
21:22:34 59595 8192000000 10879659648 11356913664 1912336192 18.925 97 17 33 1 1928408224 11433120 4638912
21:23:51 67614 8192000000 10871478912 11363864576 1923410640 19.014 98 22 44 1 1941294944 11056960 6827344
21:25:44 36182 8192000000 10870341728 11341623296 1898427632 18.814 97 23 46 1 1918484544 13201152 6855760
21:26:31 32137 8192000000 10858845584 11318185984 1886658336 18.719 97 12 24 1 1897402592 7935840 2808416
21:27:12 38488 8192000000 10863809584 11328684032 1869844112 18.583 96 20 40 0 1886259824 11462544 4953168
21:28:29 96841 8192000000 10854071424 11326930944 1824996720 18.219 93 12 24 0 1839093456 10507568 3589168
21:30:21 99581 8192000000 10893311520 11357134848 1844661456 18.379 95 16 32 0 1859332704 11072928 3598320
21:32:09 47899 8192000000 10850604688 11316457472 1816077984 18.146 93 21 42 1 1834725808 12939632 5708192
21:33:04 71059 8192000000 10865904304 11325161472 1832845472 18.283 95 12 24 1 1852156384 15611664 3699248
21:34:28 69588 8192000000 10872577888 11324559360 1840801072 18.347 95 24 48 1 1857524432 10131040 6592320
21:35:46 16305 8192000000 10883653184 11328954368 1906191312 18.876 98 56 110 2 1933209504 11680224 15337968
21:36:10 42026 8192000000 10867092912 11335266304 1927301504 19.045 100 40 80 2 1951589504 13551616 10736384
21:37:51 58406 8192000000 10875896256 11345645568 1873593488 18.613 96 19 38 1 1887775600 9241344 4940768
21:39:00 83707 8192000000 10881605376 11349348352 1944172256 19.180 100 5 10 1 1957797376 12322528 1302592
21:40:31 79325 8192000000 10885268112 11341316096 1914688704 18.944 98 31 62 2 1931684512 8351696 8644112
21:41:58 96610 8192000000 10874415968 11350028288 1929197488 19.060 99 20 40 1 1946529856 11502432 5829936
21:43:42 28632 8192000000 10884948832 11348422656 1934512464 19.103 99 33 66 3 1954267200 9775840 9978896
21:44:17 54980 8192000000 10864009680 11350683648 1933886640 19.098 99 16 32 1 1946715344 9058256 3770448
21:45:18 37819 8192000000 10858494912 11329564672 1890335696 18.748 97 14 27 1 1902302768 7840464 4126608
21:46:08 72801 8192000000 10851447392 11330191360 1889492336 18.742 97 19 38 1 1906355136 11224224 5638576
21:47:48 56749 8192000000 10874441360 11364167680 1944972288 19.186 100 11 21 1 1965421424 16702768 3746368
21:49:04 67823 8192000000 10897034240 11369213952 1941417312 19.158 99 20 40 2 1957708656 11014768 5276576
21:50:31 85509 8192000000 10889267424 11376250880 1943669968 19.176 99 16 32 0 1966538576 18242896 4625712
21:52:08 79372 8192000000 10913628704 11387744256 1954188704 19.260 99 19 38 3 1974671344 14702416 5780224
21:53:34 88044 8192000000 10898751104 11373846528 1915724800 18.953 97 14 28 1 1931178400 11027264 4426336
21:55:08 81414 8192000000 10913170672 11381444608 1925180272 19.028 98 15 29 4 1941238864 10904544 5154048
21:56:51 70795 8192000000 10913223248 11402244096 1967548272 19.366 100 15 30 0 1988152400 16495888 4108240
21:58:11 65768 8192000000 10918689408 11383934976 1945571456 19.191 98 21 41 1 1970163664 18888976 5703232
21:59:24 98576 8192000000 10925221600 11407577088 1993287600 19.570 100 18 36 2 2013917536 15649568 4980368
22:01:11 73365 8192000000 10926675424 11403997184 1958543792 19.294 98 23 44 2 1976376640 11729536 6103312
22:02:31 99159 8192000000 10935942864 11412508672 1958344432 19.293 98 19 38 0 1976501296 13528064 4628800
22:04:21 73645 8192000000 10913448544 11387019264 1918293888 18.973 96 8 16 0 1936280032 15757120 2229024
22:05:45 95098 8192000000 10913799584 11387236352 1966640784 19.359 99 18 36 1 1979787824 8080432 5066608
22:07:29 65071 8192000000 10899680176 11377881088 1941009264 19.155 98 25 50 1 1957720736 9471280 7240192
22:08:54 14794 8192000000 10912380928 11386945536 1978858400 19.456 100 21 41 4 1995546064 10630192 6057472
22:09:15 8883 8192000000 10899512304 11385774080 1978952288 19.456 100 9 18 0 1991067728 9613360 2502080
22:09:39 35942 8192000000 10876673248 11346862080 1843932224 18.373 93 12 23 0 1853477184 6274160 3270800
22:10:23 48490 8192000000 10868370368 11354963968 1923025792 19.011 99 15 30 0 1937837648 10502832 4309024
22:11:18 45766 8192000000 10880997584 11362807808 1938858496 19.138 99 12 24 2 1950281600 8202720 3220384
22:12:17 68843 8192000000 10893763568 11371319296 1924295024 19.021 98 23 47 0 1943829312 12997648 6536640
22:13:31 83952 8192000000 10878036592 11360526336 1944935264 19.186 99 15 30 1 1963858144 14049984 4872896
22:15:01 66763 8192000000 10865019824 11355250688 1879675104 18.662 96 11 22 1 1898481744 15040256 3766384
22:16:35 51976 8192000000 10856117664 11332538368 1874527936 18.621 97 24 48 2 1893428816 11411744 7489136
22:17:33 42031 8192000000 10855912336 11346436096 1915269936 18.949 99 13 26 3 1934454320 15081664 4102720
22:18:31 55025 8192000000 10868287392 11354820608 1889174368 18.739 97 16 30 2 1906146848 12580464 4392016
22:19:33 59005 8192000000 10814451920 11277828096 1806320288 18.066 93 20 40 0 1822127728 10425856 5381584
22:20:39 37300 8192000000 10858764656 11318173696 1875850512 18.632 98 37 74 3 1896033760 9548112 10635136
22:21:23 45722 8192000000 10866194864 11329196032 1903859920 18.857 98 18 36 0 1918945472 9846272 5239280
22:22:17 74557 8192000000 10856126560 11336155136 1857304384 18.481 96 33 67 1 1881380944 14575664 9500896
22:24:17 30631 8192000000 10848704816 11314884608 1901357664 18.837 99 27 54 0 1917975376 9179600 7438112
22:24:58 54858 8192000000 10832178112 11306672128 1851239984 18.432 97 21 42 1 1867801408 10570544 5990880
22:26:04 28609 8192000000 10844961248 11299602432 1877801952 18.647 98 33 66 0 1896615088 9977872 8835264
22:26:41 14598 8192000000 10874436416 11323965440 1902290592 18.845 99 50 101 2 1927357936 11401792 13665552

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 03-02-2021 22:28:14 to 03-02-2021 22:28:46.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 158 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-02-2021 22:28:47 to 03-02-2021 22:28:49.

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          247663
MON$OLDEST_ACTIVE               247664
MON$OLDEST_SNAPSHOT             247664
MON$NEXT_TRANSACTION            247664
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                       2056800
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.33411 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33411 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33411 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33411 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 ---
--- end of diff output ---

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

03.02.21 22:28:50. 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-03 22:28:52 No severe PSQL-related problems occured
03.02.21 22:28:54. End of report.