Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.01.2021 19: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 17412256 kB
MemAvailable 31359316 kB
Buffers 0 kB
Cached 14316736 kB
SwapCached 4864 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-01-19 19:27:15
DTS_END                         2021-01-19 19:27:15.3670
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44584
TRN_ID                          236614
ATT_ID                          650
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: 9043.73 23202 1085248
customer order: creation 171.64 352 20597
customer order: refuse 14.54 358 1745
order to supplier: creation 44.77 1244 5372
order to supplier: removal 3.30 95052 396
invoice (draft): creation 44.78 3484 5373
invoice (draft): removal 49.73 758 5968
invoice accept: apply 42.28 17891 5074
invoice accept: cancel 44.99 732 5399
customer reserve: creation 3900.48 178 468057
customer reserve: removal 4437.54 56 532505
realization accept: apply 82.49 163 9899
realization accept: cancel 80.68 110 9681
payment from customer: creation 58.02 93 6962
payment from customer: removal 5.08 79 609
payment to supplier: creation 48.07 103 5768
payment to supplier: removal 3.51 97 421
service: total inventory turnovers 4.63 992 555
service: total monetary turnovers 6.48 60 778
service: aggregate perf. data 0.71 27164 85
service: refresh index statistics 0.03 315070 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4218
TEST_TIME 2 3691
TEST_TIME 3 4956
TEST_TIME 4 5491
TEST_TIME 5 5009
TEST_TIME 6 4957
TEST_TIME 7 5320
TEST_TIME 8 5767
TEST_TIME 9 5733
TEST_TIME 10 5945
TEST_TIME 11 5862
TEST_TIME 12 6107
TEST_TIME 13 6336
TEST_TIME 14 6722
TEST_TIME 15 7439
TEST_TIME 16 7639
TEST_TIME 17 7786
TEST_TIME 18 7945
TEST_TIME 19 8488
TEST_TIME 20 8645
TEST_TIME 21 8695
TEST_TIME 22 8892
TEST_TIME 23 9215
TEST_TIME 24 9527
TEST_TIME 25 10200
TEST_TIME 26 10298
TEST_TIME 27 10025
TEST_TIME 28 9995
TEST_TIME 29 10371
TEST_TIME 30 10519
TEST_TIME 31 10291
TEST_TIME 32 10116
TEST_TIME 33 10234
TEST_TIME 34 10066
TEST_TIME 35 9881
TEST_TIME 36 9708
TEST_TIME 37 9738
TEST_TIME 38 9724
TEST_TIME 39 9681
TEST_TIME 40 9651
TEST_TIME 41 9648
TEST_TIME 42 9471
TEST_TIME 43 9345
TEST_TIME 44 9535
TEST_TIME 45 9369
TEST_TIME 46 9251
TEST_TIME 47 9231
TEST_TIME 48 9160
TEST_TIME 49 9041
TEST_TIME 50 9009
TEST_TIME 51 8966
TEST_TIME 52 8919
TEST_TIME 53 8785
TEST_TIME 54 8757
TEST_TIME 55 8759
TEST_TIME 56 8712
TEST_TIME 57 8812
TEST_TIME 58 8815
TEST_TIME 59 8952
TEST_TIME 60 8976
TEST_TIME 61 8976
TEST_TIME 62 9077
TEST_TIME 63 9057
TEST_TIME 64 8964
TEST_TIME 65 9114
TEST_TIME 66 9110
TEST_TIME 67 9114
TEST_TIME 68 9096
TEST_TIME 69 9049
TEST_TIME 70 9204
TEST_TIME 71 9084
TEST_TIME 72 9051
TEST_TIME 73 9028
TEST_TIME 74 9000
TEST_TIME 75 8982
TEST_TIME 76 8935
TEST_TIME 77 8895
TEST_TIME 78 8895
TEST_TIME 79 8884
TEST_TIME 80 8817
TEST_TIME 81 8804
TEST_TIME 82 8752
TEST_TIME 83 8720
TEST_TIME 84 8710
TEST_TIME 85 8763
TEST_TIME 86 8752
TEST_TIME 87 8795
TEST_TIME 88 8785
TEST_TIME 89 8791
TEST_TIME 90 8873
TEST_TIME 91 8907
TEST_TIME 92 8896
TEST_TIME 93 8969
TEST_TIME 94 8960
TEST_TIME 95 8941
TEST_TIME 96 8989
TEST_TIME 97 9038
TEST_TIME 98 9024
TEST_TIME 99 8947
TEST_TIME 100 8903
TEST_TIME 101 8945
TEST_TIME 102 8925
TEST_TIME 103 8882
TEST_TIME 104 8859
TEST_TIME 105 8810
TEST_TIME 106 8862
TEST_TIME 107 8869
TEST_TIME 108 8845
TEST_TIME 109 8898
TEST_TIME 110 8895
TEST_TIME 111 8861
TEST_TIME 112 8866
TEST_TIME 113 8943
TEST_TIME 114 8942
TEST_TIME 115 8955
TEST_TIME 116 8980
TEST_TIME 117 8938
TEST_TIME 118 9002
TEST_TIME 119 9095
TEST_TIME 120 9044

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-01-2021 19:29:06 to 19-01-2021 19:29:09.

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 1517949 1517949 0 0.00 0 15133 6 0 0
doc_list_biud 1517949 1517949 0 0.00 0 66518 25 0 0
sp_add_invoice_to_stock 5171 5074 97 1.87 27 163414 17892 0 97
sp_cancel_adding_invoice 5399 5399 0 0.00 5 60977 733 0 0
sp_cancel_client_order 1745 1745 0 0.00 5 15637 359 0 0
sp_cancel_customer_reserve 532505 532505 0 0.00 1 33405 56 0 0
sp_cancel_pay_from_customer 609 609 0 0.00 3 4294 79 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 3 4476 98 0 0
sp_cancel_supplier_invoice 5981 5968 13 0.21 1 64505 759 0 13
sp_cancel_supplier_order 396 396 0 0.00 8 878999 95053 0 0
sp_cancel_write_off 9681 9681 0 0.00 1 7279 110 0 0
sp_client_order 20597 20597 0 0.00 3 56655 352 0 0
sp_customer_reserve 468057 468057 0 0.00 0 34172 178 0 0
sp_fill_shopping_cart 31331 31331 0 0.00 1 26514 43 0 0
sp_fill_shopping_cart_clo_res 468056 468056 0 0.00 0 18559 13 0 0
sp_get_clo_for_invoice 5073 5073 0 0.00 0 20412 315 0 0
sp_kill_cost_storno 16110 16110 0 0.00 0 8135 53 0 0
sp_kill_qstorno_ret_qs2qd 1081055 1081055 0 0.00 0 64409 30 0 0
sp_kill_qty_storno 570666 570666 0 0.00 0 66518 67 0 0
sp_lock_selected_doc 20659 20659 0 0.00 0 7939 4 0 0
sp_make_cost_storno 27702 27702 0 0.00 0 15107 46 0 0
sp_multiply_rows_for_pdistr 27702 27702 0 0.00 0 6506 23 0 0
sp_multiply_rows_for_qdistr 20597 20597 0 0.00 0 56646 152 0 0
sp_pay_from_customer 6962 6962 0 0.00 4 14572 93 0 0
sp_pay_to_supplier 5768 5768 0 0.00 5 6636 104 0 0
sp_payment_common 12730 12730 0 0.00 1 14567 22 0 0
sp_qd_handle_on_cancel_clo 1745 1745 0 0.00 0 15629 336 0 0
sp_qd_handle_on_invoice_upd_sts 10472 10472 0 0.00 0 66516 349 0 0
sp_qd_handle_on_reserve_upd_sts 9899 9899 0 0.00 0 19916 57 0 0
sp_reserve_write_off 9899 9899 0 0.00 6 20046 163 0 0
sp_supplier_invoice 5373 5373 0 0.00 6 68189 3484 0 0
sp_supplier_order 5372 5372 0 0.00 6 29567 1245 0 0
srv_aggregate_perf_data 85 85 0 0.00 2525 401265 27164 0 0
srv_fill_mon_cache_memory 154 154 0 0.00 1119 148821 34769 0 0
srv_find_qd_qs_mism 1037431 1037431 0 0.00 0 7098 5 0 0
srv_make_invnt_saldo 555 555 0 0.00 21 62141 993 0 0
srv_make_money_saldo 778 778 0 0.00 0 20907 60 0 0
srv_recalc_idx_stat 4 4 0 0.00 186744 646425 315070 0 0
t$perf-abend:sp_add_invoice_to_stock 97 97 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 5074 5074 0 0.00 0 15670 161 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 5115 114 0 0
t$perf-norm:sp_cancel_client_order 1745 1745 0 0.00 0 3610 14 0 0
t$perf-norm:sp_cancel_customer_reserve 707 707 0 0.00 0 4396 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 609 609 0 0.00 0 2171 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 875 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 404 404 0 0.00 0 1332 18 0 0
t$perf-norm:sp_cancel_supplier_order 396 396 0 0.00 0 23369 1649 0 0
t$perf-norm:sp_cancel_write_off 992 992 0 0.00 0 4153 10 0 0
t$perf-norm:sp_client_order 20597 20597 0 0.00 0 13327 17 0 0
t$perf-norm:sp_customer_reserve 974 974 0 0.00 0 4720 8 0 0
t$perf-norm:sp_pay_from_customer 6962 6962 0 0.00 0 8729 12 0 0
t$perf-norm:sp_pay_to_supplier 5768 5768 0 0.00 0 9901 13 0 0
t$perf-norm:sp_reserve_write_off 9899 9899 0 0.00 0 5719 12 0 0
t$perf-norm:sp_supplier_invoice 5373 5373 0 0.00 0 7235 21 0 0
t$perf-norm:sp_supplier_order 5372 5372 0 0.00 0 7305 15 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 132 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 133 3 0 0
t$perf-norm:srv_make_invnt_saldo 555 555 0 0.00 0 9042 34 0 0
t$perf-norm:srv_make_money_saldo 778 778 0 0.00 0 1225 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10336 10142 194 1.87 0 7197 20 0 194
v_all_customers 37508 37508 0 0.00 0 90 1 0 0
v_all_suppliers 29558 29558 0 0.00 0 21 1 0 0
v_all_wares 41194 41194 0 0.00 0 106 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 1537 11 0 0
v_cancel_client_order 3490 3490 0 0.00 0 3654 5 0 0
v_cancel_customer_prepayment 1218 1218 0 0.00 0 4287 13 0 0
v_cancel_customer_reserve 1414 1414 0 0.00 0 3105 7 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 2297 10 0 0
v_cancel_supplier_invoice 834 808 26 3.11 0 5832 23 0 26
v_cancel_supplier_order 792 792 0 0.00 0 2156 8 0 0
v_cancel_write_off 1984 1984 0 0.00 0 2480 14 0 0
v_max_id_clo_ord 5372 5372 0 0.00 0 4929 2 0 0
v_max_id_clo_res 974 974 0 0.00 0 1623 6 0 0
v_max_id_ord_sup 5361 5361 0 0.00 0 3773 5 0 0
v_max_non_paid_invoice 1722 1722 0 0.00 0 5666 7 0 0
v_max_non_paid_realizn 3631 3631 0 0.00 0 839 3 0 0
v_min_id_clo_ord 5372 5372 0 0.00 0 2911 4 0 0
v_min_id_clo_res 974 974 0 0.00 0 1432 3 0 0
v_min_id_ord_sup 5361 5361 0 0.00 0 6337 12 0 0
v_min_non_paid_invoice 5768 5768 0 0.00 0 5161 11 0 0
v_min_non_paid_realizn 6962 6962 0 0.00 0 14563 14 0 0
v_our_firm 10348 10348 0 0.00 0 12 1 0 0
v_reserve_write_off 19798 19798 0 0.00 0 8492 8 0 0
x_lock_depdocs_on_canc_invoice 10963 10963 0 0.00 0 12350 99 0 0
x_lock_depdocs_on_canc_sup_ord 396 396 0 0.00 0 7725 336 0 0
x_make_qstorno_1000_1200 5372 5372 0 0.00 1 29461 1164 0 0
x_make_qstorno_1200_2000 5373 5373 0 0.00 3 67522 3315 0 0
x_make_qstorno_2100_3300 468057 468057 0 0.00 0 34171 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-01-2021 19:29:10 to 19-01-2021 19:29:14.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:18 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:25 15965 8192000000 10225616432 10531397632 920443040 10.100 74 52 106 0 940726640 2504896 17778704
16:57:50 25852 8192000000 10338544320 10654875648 1374857312 14.371 100 80 159 0 1405332848 4472960 26002576
16:58:29 34954 8192000000 10393088224 10716622848 1439574176 14.946 100 92 184 1 1475641280 6457504 29609600
16:59:15 19247 8192000000 10404358176 10735063040 1463842368 15.160 100 90 180 1 1500701344 7851824 29007152
16:59:45 21422 8192000000 10427929232 10764034048 1485806496 15.352 100 87 174 0 1521563344 8037552 27719296
17:00:14 29622 8192000000 10454677408 10790203392 1501222768 15.487 100 91 182 0 1539045584 8705712 29117104
17:00:56 12710 8192000000 10463470544 10801250304 1519367312 15.645 100 87 174 0 1557039360 9771616 27900432
17:01:19 25202 8192000000 10484272512 10828238848 1534924768 15.780 100 80 159 1 1569734416 9699744 25109904
17:01:55 14185 8192000000 10508097424 10857230336 1558581776 15.984 100 74 148 1 1591366384 10252112 22532496
17:02:24 20293 8192000000 10559959664 10916274176 1612201104 16.443 100 80 160 0 1647025216 10915744 23908368
17:02:55 15339 8192000000 10583347952 10940309504 1633336208 16.623 100 78 156 1 1668133456 12124288 22672960
17:03:18 14233 8192000000 10606463632 10966859776 1657951728 16.832 100 86 172 1 1696815456 13419696 25444032
17:03:41 11768 8192000000 10614763280 10982662144 1672365520 16.953 100 89 178 2 1713310768 14694736 26250512
17:04:01 12036 8192000000 10618550864 10990936064 1684075056 17.052 100 76 153 0 1719281792 13217120 21989616
17:04:21 11859 8192000000 10637860560 11004686336 1694391152 17.138 100 85 167 2 1731410784 12852928 24166704
17:04:40 7169 8192000000 10645036688 11016630272 1703944064 17.218 100 80 160 2 1739856064 12646144 23265856
17:04:56 9199 8192000000 10655581312 11031552000 1716309600 17.321 100 76 152 1 1751579216 13561024 21708592
17:05:15 6065 8192000000 10663429296 11044564992 1729205776 17.429 100 74 148 0 1762747952 12814560 20727616
17:05:29 7204 8192000000 10675776368 11056136192 1739032352 17.511 100 72 144 1 1771475856 11975120 20468384
17:05:43 5605 8192000000 10685427952 11068727296 1749860720 17.600 100 82 164 3 1786715696 12889456 23965520
17:05:56 4595 8192000000 10694974848 11075182592 1759316320 17.679 100 80 161 0 1794741232 12953824 22471088
17:06:08 5681 8192000000 10709224080 11092422656 1768996288 17.759 100 79 158 1 1803968224 12504592 22467344
17:06:20 4041 8192000000 10716984512 11103580160 1776887808 17.824 100 79 159 3 1812493696 12744272 22861616
17:06:31 5074 8192000000 10731925072 11116072960 1793933200 17.964 100 78 157 1 1828886704 12537712 22415792
17:06:42 3749 8192000000 10744342000 11130081280 1806598160 18.068 100 79 158 1 1841078512 12182992 22297360
17:06:54 3907 8192000000 10748563344 11131801600 1811077888 18.105 100 72 144 3 1842137616 11049856 20009872
17:07:04 2881 8192000000 10752314672 11140620288 1817716528 18.159 100 69 138 0 1848214480 10592304 19905648
17:07:14 2460 8192000000 10760439136 11146678272 1826974976 18.235 100 89 180 0 1863413440 11439280 24999184
17:07:23 2356 8192000000 10772254384 11159687168 1830989808 18.267 100 89 179 2 1868286640 12896928 24399904
17:07:31 3412 8192000000 10777508896 11162914816 1833604512 18.289 100 84 166 0 1870414432 13153856 23656064
17:07:41 1363 8192000000 10770996608 11160293376 1837135472 18.317 100 91 184 0 1877133008 14095360 25902176
17:07:50 1828 8192000000 10780582784 11171684352 1843758352 18.371 100 88 177 1 1881719104 12912448 25048304
17:07:59 1810 8192000000 10791722800 11176955904 1846565296 18.394 100 87 174 0 1883805424 12838560 24401568
17:08:07 2734 8192000000 10790278672 11180003328 1848046672 18.406 100 94 188 1 1887870992 12859984 26964336
17:08:17 1831 8192000000 10794871280 11183005696 1850118080 18.423 100 85 172 2 1885921072 12313536 23489456
17:08:25 1604 8192000000 10797558496 11182243840 1851734512 18.436 100 90 179 1 1888697200 11869296 25093392
17:08:33 2088 8192000000 10808298208 11193978880 1858066640 18.488 100 95 190 2 1898506016 13548560 26890816
17:08:42 1193 8192000000 10805128800 11191828480 1860269632 18.505 100 94 186 1 1900303440 13892256 26141552
17:08:49 1842 8192000000 10804459904 11195215872 1864487984 18.540 100 89 178 1 1903010512 13949840 24572688
17:09:00 2560 8192000000 10805997984 11197710336 1866721536 18.558 100 83 165 0 1902394784 13105072 22568176
17:09:10 13848 8192000000 10797854368 11197583360 1864882272 18.543 100 78 157 2 1899028800 12276976 21869552
17:09:29 1040 8192000000 10808042128 11199217664 1866765488 18.558 100 86 173 1 1903636384 11699696 25171200
17:09:37 17827 8192000000 10807270112 11200417792 1868615856 18.573 100 69 138 1 1897688272 9358256 19714160
17:10:01 18325 8192000000 10778865072 11202080768 1865975264 18.552 100 51 102 2 1891368416 11246688 14146464
17:10:31 6377 8192000000 10787197776 11201798144 1867996096 18.568 100 47 94 0 1887359904 5461280 13902528
17:10:45 5843 8192000000 10790929200 11197657088 1867452592 18.564 100 36 70 3 1884405504 7679792 9273120
17:10:58 5225 8192000000 10782270064 11205955584 1871551168 18.597 100 47 94 1 1892051952 6582032 13918752
17:11:09 4965 8192000000 10802158608 11208867840 1876157456 18.634 100 53 106 5 1897882416 6424528 15300432
17:11:20 3785 8192000000 10796536528 11208126464 1873442512 18.612 100 33 66 0 1890427088 8113504 8871072
17:11:35 3781 8192000000 10791010848 11215372288 1875538608 18.629 100 38 77 2 1898300880 12019744 10742528
17:11:48 9185 8192000000 10778343440 11210264576 1874871600 18.624 100 29 56 2 1889646080 7201104 7573376
17:12:06 3302 8192000000 10794036432 11215704064 1876073648 18.633 100 28 54 1 1890564352 6622624 7868080
17:12:17 8649 8192000000 10791964816 11216048128 1879698672 18.663 100 32 64 1 1895492128 6754224 9039232
17:12:35 4517 8192000000 10792149664 11215679488 1880988448 18.673 100 27 54 2 1895123552 6457296 7677808
17:12:46 6558 8192000000 10779852416 11216158720 1878665456 18.654 100 25 51 1 1892452688 6012384 7774848
17:12:59 11409 8192000000 10793581424 11216515072 1880458832 18.669 100 25 50 1 1893847312 5990480 7398000
17:13:16 7787 8192000000 10791470992 11221438464 1880066960 18.666 100 22 44 2 1892789952 6659280 6063712
17:13:38 12183 8192000000 10796587760 11226976256 1882454544 18.685 100 14 26 2 1892155008 5845008 3855456
17:13:56 9251 8192000000 10799050736 11230531584 1888186112 18.731 100 17 34 0 1899622560 6024720 5411728
17:14:17 15398 8192000000 10800404560 11233034240 1895407664 18.789 100 30 60 1 1910079088 5576480 9094944
17:14:39 64152 8192000000 10843195600 11250085888 1901923728 18.842 100 55 111 0 1925074240 5713600 17436912
17:15:50 6037 8192000000 10825795312 11252297728 1902400176 18.846 100 45 90 0 1925383008 10710480 12272352
17:16:02 5540 8192000000 10824708304 11253981184 1902515296 18.847 100 36 69 2 1919072240 6986880 9570064
17:16:14 7292 8192000000 10825830880 11253329920 1902590928 18.847 100 35 70 0 1919520496 7225248 9704320
17:16:28 4472 8192000000 10833164576 11259002880 1902530752 18.847 100 34 68 4 1925071984 13286288 9254944
17:16:39 3813 8192000000 10826555040 11256979456 1906523744 18.879 100 50 100 3 1927649216 6469168 14656304
17:16:49 9063 8192000000 10806374672 11249184768 1900356320 18.829 100 18 36 0 1911108576 5797344 4954912
17:17:09 7644 8192000000 10802166496 11239124992 1878102096 18.650 99 23 46 2 1890747888 6447328 6198464
17:17:25 7739 8192000000 10794360656 11231735808 1852687232 18.444 98 29 58 1 1867460752 6491680 8281840
17:17:39 13198 8192000000 10802495792 11226058752 1852152496 18.440 98 27 54 0 1865535088 6036080 7346512
17:17:59 58453 8192000000 10796512416 11210924032 1824848672 18.217 97 33 64 1 1839009248 4354576 9806000
17:19:04 6570 8192000000 10738794992 11163754496 1807902768 18.079 97 16 32 1 1818979504 5810000 5266736
17:19:17 4851 8192000000 10776681024 11200094208 1842530544 18.361 99 45 90 1 1859380912 5503632 11346736
17:19:29 3885 8192000000 10771444560 11189948416 1842074832 18.358 99 44 88 0 1863067664 8721104 12271728
17:19:44 5799 8192000000 10715709920 11128991744 1784028944 17.883 97 34 69 1 1804698224 11045680 9623600
17:19:56 4038 8192000000 10756610272 11174961152 1823268160 18.204 99 39 77 0 1846287792 11955984 11063648
17:20:07 6461 8192000000 10746065760 11165110272 1802568800 18.035 98 30 60 3 1817400720 6256096 8575824
17:20:19 7603 8192000000 10755681088 11178151936 1805310624 18.057 98 18 36 2 1817163584 5880624 5972336
17:20:36 6891 8192000000 10707107872 11120578560 1722492000 17.373 94 26 52 2 1736154688 6069184 7593504
17:20:51 5388 8192000000 10723551472 11134795776 1757265296 17.662 97 26 51 1 1770250192 5592576 7392320
17:21:04 8507 8192000000 10685368016 11101761536 1707104464 17.245 94 27 54 1 1720693680 5520464 8068752
17:21:20 7915 8192000000 10695304064 11114303488 1753503856 17.631 98 21 42 2 1765250864 5447760 6299248
17:21:37 9909 8192000000 10684187872 11103408128 1681030048 17.026 93 21 41 2 1691473600 4821088 5622464
17:21:59 50404 8192000000 10711632928 11121565696 1779229952 17.843 99 30 60 0 1793197552 5748320 8219280
17:23:01 23317 8192000000 10705744112 11128573952 1733901648 17.468 96 24 49 0 1746676048 5717440 7056960
17:23:33 5189 8192000000 10723991744 11142209536 1807175072 18.073 100 31 62 2 1821762400 5899712 8687616
17:23:45 4622 8192000000 10712992144 11126173696 1758131200 17.669 97 31 62 4 1776564096 9819856 8613040
17:23:58 4698 8192000000 10718299920 11133190144 1793662384 17.962 99 27 54 3 1809269136 6504256 9102496
17:24:10 7881 8192000000 10732895984 11155865600 1819468112 18.173 100 28 56 2 1834094080 6582128 8043840
17:24:24 6413 8192000000 10752030560 11169841152 1829431072 18.255 100 36 72 1 1846648128 5699536 11517520
17:24:37 9259 8192000000 10755374304 11176185856 1835776240 18.306 100 30 59 3 1849984720 5307296 8901184
17:24:55 9711 8192000000 10763294880 11183775744 1839507008 18.337 100 17 34 2 1853844048 9464240 4872800
17:25:11 13297 8192000000 10758144272 11179929600 1841083136 18.350 100 14 28 0 1850503200 5356224 4063840
17:25:31 7206 8192000000 10760484192 11184893952 1846687824 18.395 100 34 66 4 1862320400 5014976 10617600
17:25:46 10277 8192000000 10765345104 11189510144 1849945696 18.422 100 23 46 2 1862976192 5817760 7212736
17:26:09 7190 8192000000 10789660048 11196387328 1853993504 18.455 100 39 78 2 1869697392 4286816 11417072
17:26:23 10288 8192000000 10757944176 11193925632 1852873200 18.445 100 16 32 1 1863380192 5762496 4744496
17:26:39 19686 8192000000 10776199184 11201503232 1855558704 18.467 100 22 44 4 1867026592 5337120 6130768
17:27:07 71976 8192000000 10803469264 11227684864 1872895344 18.608 100 23 46 0 1885403824 5592576 6915904
17:28:47 54046 8192000000 10848276704 11266048000 1904977936 18.866 100 38 76 3 1925429536 9621552 10830048
17:29:52 25013 8192000000 10846213504 11270434816 1916471072 18.959 100 46 92 0 1941747664 12074608 13201984
17:30:34 15987 8192000000 10864214848 11289522176 1922815664 19.009 100 45 90 0 1948538304 12276848 13445792
17:30:59 36877 8192000000 10872844304 11297091584 1936692544 19.120 100 39 78 0 1960001136 11992912 11315680
17:31:47 11089 8192000000 10877027168 11301199872 1939598384 19.144 100 46 92 2 1964218144 11251232 13368528
17:32:05 9939 8192000000 10892370624 11316576256 1949410864 19.222 100 56 112 0 1979114880 13475856 16228160
17:32:30 14323 8192000000 10900019360 11323469824 1953554048 19.255 100 53 107 0 1982711872 14231056 14926768
17:32:58 25768 8192000000 10905439456 11331289088 1963255680 19.332 100 51 101 3 1993235904 15293888 14686336
17:33:31 24901 8192000000 10911420176 11339087872 1966387936 19.357 100 48 96 0 1995263584 14610688 14264960
17:34:06 10142 8192000000 10908461904 11341303808 1969413600 19.381 100 39 78 0 1997442640 16669088 11359952
17:34:25 14346 8192000000 10913086784 11346632704 1972304400 19.404 100 50 100 2 2004390624 17079328 15006896
17:34:47 21458 8192000000 10918530192 11351560192 1977074544 19.442 100 48 94 2 2007438240 15869264 14494432
17:35:17 13281 8192000000 10918274592 11355549696 1979251456 19.459 100 44 85 0 2009137280 17026832 12858992
17:35:40 17575 8192000000 10916533824 11355279360 1985520352 19.508 100 44 88 1 2014587008 15865408 13201248
17:36:12 7612 8192000000 10917427072 11345100800 1970057040 19.386 99 62 122 3 2003051648 15511744 17482864
17:36:28 3993 8192000000 10937669904 11357319168 1987141776 19.521 100 74 146 0 2026611760 17794432 21675552
17:36:39 3780 8192000000 10949592112 11366674432 1992736480 19.565 100 73 145 2 2032689008 18742416 21210112
17:37:01 8197 8192000000 10940626496 11370078208 1994185920 19.577 100 62 124 3 2030838480 19208400 17444160
17:37:16 5586 8192000000 10946070992 11377201152 1997466960 19.603 100 57 114 0 2033916352 19434624 17014768
17:37:34 12252 8192000000 10941917600 11366703104 1990153648 19.545 100 64 128 2 2030601936 21139168 19309120
17:38:05 11973 8192000000 10940388896 11374632960 1990839472 19.550 100 53 106 1 2028334976 21497440 15998064
17:38:26 7188 8192000000 10945223232 11375140864 1992340736 19.562 100 56 112 1 2035693376 25600000 17752640
17:38:43 15858 8192000000 10933479216 11370938368 1981709056 19.478 100 52 104 1 2023788384 25325696 16753632
17:39:07 6704 8192000000 10934148848 11365605376 1965612144 19.351 99 51 99 2 2005984128 24650464 15721520
17:39:22 11401 8192000000 10947831456 11376668672 1987636512 19.525 100 60 120 3 2031054000 25612848 17804640
17:39:41 5996 8192000000 10954700752 11385368576 1997462320 19.603 100 63 124 1 2045243072 29092592 18688160
17:39:54 3565 8192000000 10972989792 11394269184 2004619584 19.659 100 85 167 0 2059652560 30464064 24568912
17:40:05 12552 8192000000 10962486080 11387752448 1992626448 19.565 100 77 153 0 2049276288 33484528 23165312
17:40:25 2565 8192000000 10958406224 11382210560 1978642848 19.454 99 69 137 0 2031716672 32029040 21044784
17:40:36 2572 8192000000 10970496016 11388174336 1996364960 19.594 100 79 158 1 2053942128 33708976 23868192
17:40:45 4563 8192000000 10970842544 11387604992 1996174448 19.593 100 81 159 2 2053754720 33739424 23840848
17:40:59 2863 8192000000 10974059488 11395440640 1999168272 19.616 100 79 157 0 2059763696 36253312 24342112
17:41:10 7011 8192000000 10966227312 11385176064 1987482160 19.524 100 71 143 1 2045939328 36528720 21928448
17:41:26 2032 8192000000 10968796576 11378958336 1972604656 19.406 99 86 167 2 2033579472 35954864 25019952
17:41:35 5470 8192000000 10958970912 11381989376 1988246432 19.530 100 73 145 1 2047389904 37627968 21515504
17:41:47 1112 8192000000 10974782608 11385917440 1990415232 19.547 100 93 185 2 2058214768 38971632 28827904
17:41:55 2091 8192000000 10963150064 11370647552 1975492736 19.429 100 92 184 3 2044131104 39630608 29007760
17:42:03 1263 8192000000 10961189312 11382079488 1981673216 19.478 100 86 170 5 2048945376 40438176 26833984
17:42:11 2350 8192000000 10954033440 11376357376 1978668320 19.454 100 69 137 2 2037694928 38120768 20905840
17:42:21 3354 8192000000 10959015328 11377197056 1982684992 19.486 100 75 150 1 2040205168 34196848 23323328
17:42:33 2521 8192000000 10947422640 11374997504 1979461664 19.460 100 62 123 0 2033346016 34839600 19044752
17:42:45 10047 8192000000 10935698464 11370946560 1976961648 19.441 100 44 88 3 2023053616 32242016 13849952
17:43:04 14574 8192000000 10947737152 11360133120 1938913616 19.138 98 56 111 0 1995823840 39957968 16952256
17:43:26 2012 8192000000 10934601344 11350208512 1956683088 19.280 99 83 163 1 2015865200 35129824 24052288
17:43:36 3385 8192000000 10926945072 11350708224 1955118224 19.267 99 60 118 2 2006627520 34461168 17048128
17:43:50 4523 8192000000 10945216592 11372490752 1974490960 19.421 100 58 117 1 2028451056 36446656 17513440
17:44:02 1282 8192000000 10932446656 11346558976 1953899696 19.258 99 68 137 0 2011579616 36728832 20951088
17:44:12 8889 8192000000 10930506800 11372642304 1966464464 19.357 100 36 72 0 2023975232 45582000 11928768
17:44:32 6472 8192000000 10921265104 11343032320 1949321040 19.221 100 53 103 3 1998694608 32804208 16569360
17:44:47 4547 8192000000 10966085040 11372261376 1969967280 19.385 100 80 156 1 2030170208 35814992 24387936
17:44:59 6191 8192000000 10963543488 11376099328 1975609216 19.430 100 86 174 0 2039265072 37468544 26187312
17:45:13 5016 8192000000 10951624912 11370020864 1973382880 19.412 100 75 148 1 2032452448 35930432 23139136
17:45:26 4603 8192000000 10948267664 11365564416 1970305536 19.388 100 70 136 2 2027868928 36048016 21515376
17:45:39 1426 8192000000 10921320896 11325018112 1934863440 19.106 99 81 162 0 1998504336 37632176 26008720
17:45:48 2584 8192000000 10938477760 11347968000 1940808160 19.153 99 84 169 0 2003634384 37776080 25050144
17:46:00 2100 8192000000 10939631200 11345149952 1951450144 19.238 100 92 184 1 2019721984 39871552 28400288
17:46:14 7620 8192000000 10894066640 11324407808 1917844816 18.970 99 48 95 0 1967714608 34969152 14900640
17:46:29 6114 8192000000 10897230560 11327340544 1933791248 19.097 100 52 102 1 1984229424 34082944 16355232
17:46:43 11345 8192000000 10902900912 11338125312 1937915056 19.130 100 39 78 1 1986174032 35296976 12962000
17:47:04 7106 8192000000 10901543616 11331186688 1937655552 19.128 100 44 88 5 1986916864 34624160 14637152
17:47:26 11304 8192000000 10882183072 11316330496 1921088704 18.996 100 39 76 0 1970752112 36271552 13391856
17:47:49 15446 8192000000 10885721200 11325284352 1925002288 19.027 100 27 53 2 1968525776 34018912 9504576
17:48:48 7997 8192000000 10899067856 11335700480 1923650848 19.016 99 37 74 0 1973664272 37130192 12883232
17:49:10 12760 8192000000 10888924752 11323842560 1894752480 18.784 98 31 61 2 1943832416 38770176 10309760
17:49:37 4599 8192000000 10895605920 11327262720 1921986640 19.003 100 34 67 1 1974824640 41371280 11466720
17:49:52 6968 8192000000 10878576096 11307229184 1878161104 18.650 98 35 69 0 1931128000 40486640 12480256
17:50:08 4302 8192000000 10894217456 11320254464 1917907520 18.970 100 52 103 1 1976978880 41732704 17338656
17:50:20 9611 8192000000 10920850368 11345612800 1932252368 19.085 100 48 97 3 1995025104 46673424 16099312
17:50:38 5433 8192000000 10923088224 11351846912 1942579360 19.167 100 54 108 2 2004914656 44796000 17539296
17:50:52 7047 8192000000 10934506864 11361849344 1946793360 19.201 100 63 124 1 2014373680 47876672 19703648
17:51:18 17628 8192000000 10910492528 11353219072 1922668544 19.008 99 28 56 0 1978384336 45713632 10002160
17:51:54 6200 8192000000 10909210208 11350097920 1938102096 19.132 100 40 80 2 1997810224 45286816 14421312
17:52:09 13593 8192000000 10912486816 11372916736 1947933568 19.210 100 36 72 1 2005267552 45790416 11543568
17:52:55 40875 8192000000 10876023664 11344941056 1923879280 19.018 99 28 55 3 1966428848 32505952 10043616
17:53:51 79296 8192000000 10890516176 11335155712 1917036832 18.963 99 29 58 2 1951194880 25131936 9026112
17:55:28 17648 8192000000 10855608480 11307716608 1894155888 18.779 99 21 42 1 1934223968 33202992 6865088
17:56:01 33929 8192000000 10839189904 11308417024 1875466032 18.628 98 19 38 1 1913145792 31775040 5904720
17:56:44 45406 8192000000 10843381504 11299835904 1873243728 18.611 98 11 22 3 1895995856 19340560 3411568
17:57:37 38590 8192000000 10845496096 11313303552 1905460736 18.870 99 12 24 1 1927349440 18199472 3689232
17:58:22 29037 8192000000 10855518336 11312623616 1910307488 18.909 99 18 36 0 1928410496 13091664 5011344
17:59:14 57140 8192000000 10845664656 11296755712 1893960592 18.778 98 27 54 2 1914152480 12537536 7654352
18:00:19 95853 8192000000 10857459840 11324682240 1911101280 18.915 99 10 20 1 1928738672 15263776 2373616
18:02:02 22125 8192000000 10868608496 11332804608 1939939360 19.146 100 16 32 1 1958950464 14993968 4017136
18:02:30 16524 8192000000 10871679744 11320467456 1925867552 19.034 99 20 40 0 1946349984 14902176 5580256
18:02:53 54443 8192000000 10895579600 11337793536 1935719696 19.113 99 41 82 3 1960525024 13084224 11721104
18:04:01 36090 8192000000 10885179168 11340423168 1957140128 19.283 100 43 86 2 1984996736 15637888 12218720
18:04:47 50627 8192000000 10890857216 11348201472 1939414992 19.142 99 17 34 2 1960054592 16161264 4478336
18:05:49 62423 8192000000 10896881072 11364589568 1962745152 19.328 100 10 20 0 1980096816 14822800 2528864
18:06:58 51490 8192000000 10871097392 11333955584 1900408928 18.830 97 7 14 0 1915186304 12720432 2056944
18:08:22 71199 8192000000 10878133824 11339227136 1926389568 19.038 99 17 34 1 1944399648 13234976 4775104
18:09:43 126834 8192000000 10883078032 11365568512 1957699664 19.288 100 32 64 1 1988275712 20802192 9773856
18:12:06 88532 8192000000 10882705280 11346075648 1946926592 19.202 100 10 20 1 1970535408 20792400 2816416
18:13:43 96929 8192000000 10886078560 11351560192 1963871792 19.337 100 23 45 2 1983522496 13672480 5978224
18:16:01 57436 8192000000 10914144720 11367997440 1975542304 19.429 100 41 81 2 1994979696 7610048 11827344
18:17:11 61515 8192000000 10889165680 11353735168 1956772384 19.280 99 19 38 0 1969569232 7409488 5387360
18:18:22 66580 8192000000 10894046064 11368783872 1980713008 19.470 100 11 22 0 1992068896 8271952 3083936
18:19:42 54011 8192000000 10895479104 11375280128 1985379264 19.507 100 11 22 0 1998558160 9775616 3403280
18:21:01 63537 8192000000 10882062976 11363627008 1924105664 19.020 97 10 20 2 1937651088 11077296 2468128
18:22:11 39458 8192000000 10880560944 11347345408 1912795856 18.929 97 13 26 0 1922798384 6327360 3675168
18:22:59 44987 8192000000 10923366352 11374485504 1977077008 19.442 100 33 66 0 1998652208 11764192 9811008
18:23:54 44828 8192000000 10898387808 11374227456 1960701456 19.312 99 15 30 1 1977479408 12351088 4426864
18:24:52 45513 8192000000 10907443360 11388252160 1978790128 19.455 100 14 28 1 1996441232 13827760 3823344
18:25:53 71880 8192000000 10913072304 11384877056 1962876688 19.329 99 11 22 1 1982097328 16018384 3202256
18:27:12 51297 8192000000 10905891776 11376230400 1950169632 19.228 98 20 39 1 1965407536 9990224 5247680
18:28:09 63794 8192000000 10887748192 11350319104 1867758336 18.566 94 23 46 1 1882664336 8352864 6553136
18:29:19 90035 8192000000 10893167984 11352588288 1923603472 19.016 98 11 22 1 1935196544 9191040 2402032
18:31:00 51821 8192000000 10912200928 11347992576 1906531216 18.879 97 34 69 2 1927193824 10981424 9681184
18:32:19 42207 8192000000 10875635168 11341307904 1919135392 18.980 98 28 56 2 1943717280 16434272 8147616
18:33:09 48576 8192000000 10902791760 11362967552 1947109648 19.203 99 24 48 0 1962139728 8451648 6578432
18:34:07 50374 8192000000 10883971936 11347476480 1916864544 18.962 97 18 36 1 1931968944 10350432 4753968
18:35:03 39332 8192000000 10869466752 11321647104 1801546912 18.027 92 19 38 1 1820073872 13443056 5083904
18:35:53 36536 8192000000 10899136816 11339051008 1927220448 19.045 99 48 96 3 1953611760 13002080 13389232
18:36:42 87362 8192000000 10866033744 11350106112 1890991808 18.754 97 21 42 1 1924814640 27656128 6166704
18:38:25 119768 8192000000 10866266912 11328270336 1866507584 18.556 96 25 49 3 1889260576 16008896 6744096
18:40:31 45757 8192000000 10848155648 11318833152 1915819872 18.953 99 32 64 1 1940850464 16219056 8811536
18:42:21 69059 8192000000 10866413648 11332579328 1927046016 19.043 99 17 30 2 1942410528 10820688 4543824
18:43:44 66181 8192000000 10856706256 11327373312 1909237088 18.901 98 10 20 0 1923031392 10964080 2830224
18:45:07 54806 8192000000 10807063232 11271192576 1795456528 17.977 93 23 46 1 1808337104 6550928 6329648
18:46:11 71213 8192000000 10802852544 11269177344 1855133872 18.464 97 13 26 0 1866095952 7391856 3570224
18:47:42 26157 8192000000 10815925456 11282051072 1886145760 18.715 99 14 28 0 1897729440 7594432 3989248
18:48:16 16767 8192000000 10791693584 11258953728 1880718144 18.671 99 15 29 2 1891812928 6846528 4248256
18:48:43 57891 8192000000 10810595616 11263827968 1858710336 18.493 98 15 30 0 1868992320 6102384 4179600
18:49:52 66576 8192000000 10824304240 11278753792 1877556384 18.645 99 17 33 2 1888057328 6009344 4491600
18:51:11 47498 8192000000 10833558032 11296501760 1879460432 18.661 98 18 36 1 1894076048 9101504 5514112
18:52:23 36322 8192000000 10838304112 11295559680 1895224096 18.788 99 22 43 2 1913302704 11724640 6353968
18:53:06 45469 8192000000 10850722928 11315740672 1920933680 18.994 100 15 30 1 1936878192 12004464 3940048
18:53:59 40484 8192000000 10854455104 11314212864 1893040704 18.770 98 13 26 0 1908769344 11829648 3898992
18:54:47 29720 8192000000 10875283312 11329396736 1940038912 19.147 100 35 70 1 1960952320 10994784 9918624
18:55:25 19230 8192000000 10866396288 11308691456 1912551632 18.927 98 33 66 0 1934318512 12118736 9648144
18:55:53 53285 8192000000 10878062224 11332014080 1932862880 19.090 99 45 89 1 1962057968 17296304 11898784
18:56:57 90913 8192000000 10873246192 11336036352 1875247968 18.627 96 16 32 2 1889611584 10052688 4310928
18:58:36 69075 8192000000 10898180704 11356262400 1941472320 19.159 99 14 28 0 1956986512 11885136 3629056
18:59:53 110022 8192000000 10865866160 11337662464 1862406992 18.523 95 10 20 0 1880990448 16360208 2223248
19:01:57 38968 8192000000 10917899968 11354779648 1971427056 19.397 100 43 82 1 1991526368 8978784 11120528
19:02:48 44851 8192000000 10911215616 11374989312 1971529136 19.398 100 32 64 0 1992189616 12061152 8599328
19:03:39 127186 8192000000 10896997088 11376975872 1918758720 18.977 97 9 18 0 1934078544 12811808 2508016
19:05:52 75664 8192000000 10916613520 11374809088 1982504096 19.485 100 21 42 3 1996138592 7123232 6511264
19:07:17 68744 8192000000 10930881008 11392135168 1995034144 19.584 100 32 63 3 2022024544 18745600 8244800
19:09:18 83542 8192000000 10905940528 11377844224 1970235328 19.387 99 13 26 0 1984614032 10663952 3714752
19:10:47 34948 8192000000 10899697952 11373957120 1961156608 19.315 99 6 12 1 1973815152 10862352 1796192
19:11:29 42962 8192000000 10909444848 11371311104 1957449280 19.286 99 8 16 0 1970961408 11311200 2200928
19:12:19 77894 8192000000 10899791504 11381067776 1961951072 19.322 99 16 32 0 1984698464 17829664 4917728
19:13:44 63039 8192000000 10868282224 11346497536 1891027088 18.754 96 5 10 1 1904771520 11993328 1751104
19:14:53 32519 8192000000 10903200192 11355193344 1946576720 19.199 99 30 61 1 1967159600 11952016 8630864
19:15:41 61192 8192000000 10873063056 11349770240 1910939472 18.914 97 22 44 2 1929796432 12465744 6391216
19:16:51 83443 8192000000 10871255408 11331588096 1883579472 18.694 96 14 28 0 1897029280 9285120 4164688
19:18:21 26089 8192000000 10904457088 11349778432 1944013888 19.179 99 33 66 1 1962081968 8578256 9489824
19:19:00 33163 8192000000 10914574368 11365007360 1964046688 19.338 100 39 78 0 1989202560 13698128 11457744
19:20:35 148821 8192000000 10897808208 11366076416 1874522256 18.621 95 8 16 0 1889354912 12746176 2086480
19:23:50 41668 8192000000 10911802256 11350712320 1886595248 18.718 95 50 99 1 1912408400 10897280 14915872
19:24:39 18209 8192000000 10906436560 11354202112 1928690624 19.056 98 41 82 0 1958481568 18568976 11221968
19:25:04 69279 8192000000 10894668944 11364069376 1917032544 18.963 98 29 58 1 1944518384 20100048 7385792
19:26:20 63823 8192000000 9057226176 9316720640 203511168 2.424 11 3 6 0 205987136 2053184 422784

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 19-01-2021 19:29:16 to 19-01-2021 19:29:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 97 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 19-01-2021 19:29:48 to 19-01-2021 19:29:50.

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          236901
MON$OLDEST_ACTIVE               236902
MON$OLDEST_SNAPSHOT             236902
MON$NEXT_TRANSACTION            236902
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                       2015232
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:63: 
:64: mscs-test-161.budzdorov.ru    Tue Jan 19 19:27:29 2021
:65:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:66: 
--- end of diff output ---

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

19.01.21 19:29:51. 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-01-19 19:29:53 No severe PSQL-related problems occured
19.01.21 19:29:55. End of report.