Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 31.12.2020 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 16958656 kB
MemAvailable 31410984 kB
Buffers 0 kB
Cached 14701632 kB
SwapCached 4820 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 2020-12-31 22:27:06
DTS_END                         2020-12-31 22:27:06.7000
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/37576
TRN_ID                          256224
ATT_ID                          692
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: 9653.03 19762 1158363
customer order: creation 187.68 324 22521
customer order: refuse 16.24 322 1949
order to supplier: creation 49.34 1330 5921
order to supplier: removal 3.63 88031 436
invoice (draft): creation 50.28 3408 6034
invoice (draft): removal 53.25 738 6390
invoice accept: apply 45.64 18067 5477
invoice accept: cancel 47.97 763 5756
customer reserve: creation 4152.34 182 498281
customer reserve: removal 4724.35 53 566922
realization accept: apply 91.26 176 10951
realization accept: cancel 87.43 111 10492
payment from customer: creation 65.60 120 7872
payment from customer: removal 6.45 88 774
payment to supplier: creation 54.33 124 6520
payment to supplier: removal 3.98 70 477
service: total inventory turnovers 5.08 1195 609
service: total monetary turnovers 7.48 31 898
service: aggregate perf. data 0.66 28023 79
service: refresh index statistics 0.03 252085 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-12-2020 22:27:49 to 31-12-2020 22:27:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5379
TEST_TIME 2 4409
TEST_TIME 3 5421
TEST_TIME 4 5713
TEST_TIME 5 5495
TEST_TIME 6 5897
TEST_TIME 7 6394
TEST_TIME 8 6372
TEST_TIME 9 6749
TEST_TIME 10 7178
TEST_TIME 11 7433
TEST_TIME 12 7648
TEST_TIME 13 7923
TEST_TIME 14 7823
TEST_TIME 15 8067
TEST_TIME 16 8172
TEST_TIME 17 8841
TEST_TIME 18 9433
TEST_TIME 19 9389
TEST_TIME 20 9359
TEST_TIME 21 9320
TEST_TIME 22 9360
TEST_TIME 23 9398
TEST_TIME 24 9916
TEST_TIME 25 10010
TEST_TIME 26 10144
TEST_TIME 27 10295
TEST_TIME 28 10101
TEST_TIME 29 10534
TEST_TIME 30 11188
TEST_TIME 31 11501
TEST_TIME 32 11467
TEST_TIME 33 11369
TEST_TIME 34 11427
TEST_TIME 35 11412
TEST_TIME 36 11355
TEST_TIME 37 11182
TEST_TIME 38 11201
TEST_TIME 39 11086
TEST_TIME 40 11027
TEST_TIME 41 11043
TEST_TIME 42 10895
TEST_TIME 43 10718
TEST_TIME 44 10606
TEST_TIME 45 10670
TEST_TIME 46 10559
TEST_TIME 47 10439
TEST_TIME 48 10483
TEST_TIME 49 10370
TEST_TIME 50 10341
TEST_TIME 51 10238
TEST_TIME 52 10456
TEST_TIME 53 10336
TEST_TIME 54 10265
TEST_TIME 55 10260
TEST_TIME 56 10211
TEST_TIME 57 10156
TEST_TIME 58 10155
TEST_TIME 59 10113
TEST_TIME 60 10062
TEST_TIME 61 10015
TEST_TIME 62 10032
TEST_TIME 63 9968
TEST_TIME 64 9975
TEST_TIME 65 10191
TEST_TIME 66 10133
TEST_TIME 67 10129
TEST_TIME 68 10162
TEST_TIME 69 10202
TEST_TIME 70 10218
TEST_TIME 71 10227
TEST_TIME 72 10241
TEST_TIME 73 10186
TEST_TIME 74 10124
TEST_TIME 75 10046
TEST_TIME 76 10019
TEST_TIME 77 10000
TEST_TIME 78 9995
TEST_TIME 79 9967
TEST_TIME 80 9900
TEST_TIME 81 9860
TEST_TIME 82 9861
TEST_TIME 83 9791
TEST_TIME 84 9767
TEST_TIME 85 9777
TEST_TIME 86 9741
TEST_TIME 87 9756
TEST_TIME 88 9734
TEST_TIME 89 9701
TEST_TIME 90 9693
TEST_TIME 91 9806
TEST_TIME 92 9795
TEST_TIME 93 9836
TEST_TIME 94 9866
TEST_TIME 95 9917
TEST_TIME 96 9879
TEST_TIME 97 9901
TEST_TIME 98 9922
TEST_TIME 99 9936
TEST_TIME 100 9920
TEST_TIME 101 9837
TEST_TIME 102 9778
TEST_TIME 103 9813
TEST_TIME 104 9794
TEST_TIME 105 9784
TEST_TIME 106 9734
TEST_TIME 107 9714
TEST_TIME 108 9668
TEST_TIME 109 9629
TEST_TIME 110 9676
TEST_TIME 111 9667
TEST_TIME 112 9645
TEST_TIME 113 9671
TEST_TIME 114 9716
TEST_TIME 115 9702
TEST_TIME 116 9716
TEST_TIME 117 9734
TEST_TIME 118 9734
TEST_TIME 119 9713
TEST_TIME 120 9655

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 31-12-2020 22:27:53 to 31-12-2020 22:27:56.

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 1619054 1619054 0 0.00 0 18183 7 0 0
doc_list_biud 1619054 1619054 0 0.00 0 18144 24 0 0
sp_add_invoice_to_stock 5593 5477 116 2.07 31 158984 18067 0 116
sp_cancel_adding_invoice 5756 5756 0 0.00 5 64015 763 0 0
sp_cancel_client_order 1949 1949 0 0.00 3 5999 323 0 0
sp_cancel_customer_reserve 566922 566922 0 0.00 1 20043 53 0 0
sp_cancel_pay_from_customer 774 774 0 0.00 3 8276 88 0 0
sp_cancel_pay_to_supplier 477 477 0 0.00 3 2768 70 0 0
sp_cancel_supplier_invoice 6407 6390 17 0.26 2 21416 739 0 17
sp_cancel_supplier_order 436 436 0 0.00 7 1007679 88032 0 0
sp_cancel_write_off 10492 10492 0 0.00 1 15571 112 0 0
sp_client_order 22521 22521 0 0.00 3 10861 324 0 0
sp_customer_reserve 498281 498281 0 0.00 0 107094 182 0 0
sp_fill_shopping_cart 34460 34460 0 0.00 1 15057 36 0 0
sp_fill_shopping_cart_clo_res 498272 498272 0 0.00 0 20237 12 0 0
sp_get_clo_for_invoice 5468 5468 0 0.00 0 27897 247 0 0
sp_kill_cost_storno 17499 17499 0 0.00 0 5521 56 0 0
sp_kill_qstorno_ret_qs2qd 1151162 1151162 0 0.00 0 18124 29 0 0
sp_kill_qty_storno 608364 608364 0 0.00 0 18144 63 0 0
sp_lock_selected_doc 22790 22790 0 0.00 0 8269 7 0 0
sp_make_cost_storno 30811 30811 0 0.00 0 18180 54 0 0
sp_multiply_rows_for_pdistr 30811 30811 0 0.00 0 10500 31 0 0
sp_multiply_rows_for_qdistr 22521 22521 0 0.00 0 10854 137 0 0
sp_pay_from_customer 7872 7872 0 0.00 4 14872 120 0 0
sp_pay_to_supplier 6520 6520 0 0.00 4 18189 125 0 0
sp_payment_common 14392 14392 0 0.00 1 11950 30 0 0
sp_qd_handle_on_cancel_clo 1949 1949 0 0.00 0 5169 294 0 0
sp_qd_handle_on_invoice_upd_sts 11224 11224 0 0.00 0 14782 323 0 0
sp_qd_handle_on_reserve_upd_sts 10951 10951 0 0.00 0 11558 48 0 0
sp_reserve_write_off 10951 10951 0 0.00 6 14866 177 0 0
sp_supplier_invoice 6034 6034 0 0.00 7 106847 3408 0 0
sp_supplier_order 5921 5921 0 0.00 5 31094 1331 0 0
srv_aggregate_perf_data 79 79 0 0.00 2891 330343 28024 0 0
srv_fill_mon_cache_memory 177 177 0 0.00 913 158993 30025 0 0
srv_find_qd_qs_mism 1105894 1105894 0 0.00 0 12968 6 0 0
srv_make_invnt_saldo 609 609 0 0.00 31 117130 1195 0 0
srv_make_money_saldo 898 898 0 0.00 1 4450 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 181467 362087 252085 0 0
t$perf-abend:sp_add_invoice_to_stock 116 116 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5477 5477 0 0.00 0 12257 154 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 1 7140 100 0 0
t$perf-norm:sp_cancel_client_order 1949 1949 0 0.00 0 14151 21 0 0
t$perf-norm:sp_cancel_customer_reserve 735 735 0 0.00 0 5791 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 774 774 0 0.00 0 959 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 477 477 0 0.00 0 2829 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 4216 24 0 0
t$perf-norm:sp_cancel_supplier_order 436 436 0 0.00 0 27999 1474 0 0
t$perf-norm:sp_cancel_write_off 1113 1113 0 0.00 0 2780 5 0 0
t$perf-norm:sp_client_order 22521 22521 0 0.00 0 8181 18 0 0
t$perf-norm:sp_customer_reserve 1061 1061 0 0.00 0 510 5 0 0
t$perf-norm:sp_pay_from_customer 7872 7872 0 0.00 0 8138 9 0 0
t$perf-norm:sp_pay_to_supplier 6520 6520 0 0.00 0 13755 14 0 0
t$perf-norm:sp_reserve_write_off 10951 10951 0 0.00 0 7748 13 0 0
t$perf-norm:sp_supplier_invoice 6034 6034 0 0.00 0 8210 20 0 0
t$perf-norm:sp_supplier_order 5921 5921 0 0.00 0 2327 14 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 325 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 492 7 0 0
t$perf-norm:srv_make_invnt_saldo 609 609 0 0.00 0 858 22 0 0
t$perf-norm:srv_make_money_saldo 898 898 0 0.00 0 1634 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 4 3 0 0
v_add_invoice_to_stock 11168 10936 232 2.07 0 3996 21 0 232
v_all_customers 40934 40934 0 0.00 0 56 1 0 0
v_all_suppliers 32980 32980 0 0.00 0 17 1 0 0
v_all_wares 45042 45042 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 756 6 0 0
v_cancel_client_order 3898 3898 0 0.00 0 3369 6 0 0
v_cancel_customer_prepayment 1548 1548 0 0.00 0 1833 7 0 0
v_cancel_customer_reserve 1470 1470 0 0.00 0 2028 6 0 0
v_cancel_payment_to_supplier 954 954 0 0.00 0 449 4 0 0
v_cancel_supplier_invoice 906 872 34 3.75 0 3679 27 0 34
v_cancel_supplier_order 872 872 0 0.00 0 1604 10 0 0
v_cancel_write_off 2226 2226 0 0.00 0 2236 13 0 0
v_max_id_clo_ord 5921 5921 0 0.00 0 1527 2 0 0
v_max_id_clo_res 1061 1061 0 0.00 0 4519 12 0 0
v_max_id_ord_sup 6018 6018 0 0.00 0 3329 4 0 0
v_max_non_paid_invoice 1969 1969 0 0.00 0 847 3 0 0
v_max_non_paid_realizn 4264 4264 0 0.00 0 7511 6 0 0
v_min_id_clo_ord 5921 5921 0 0.00 0 3669 6 0 0
v_min_id_clo_res 1061 1061 0 0.00 0 6572 10 0 0
v_min_id_ord_sup 6018 6018 0 0.00 0 9033 6 0 0
v_min_non_paid_invoice 6520 6520 0 0.00 0 10012 15 0 0
v_min_non_paid_realizn 7872 7872 0 0.00 0 6913 17 0 0
v_our_firm 11324 11324 0 0.00 0 24 1 0 0
v_reserve_write_off 21902 21902 0 0.00 0 3446 6 0 0
x_lock_depdocs_on_canc_invoice 11710 11710 0 0.00 0 18687 109 0 0
x_lock_depdocs_on_canc_sup_ord 436 436 0 0.00 0 16431 413 0 0
x_make_qstorno_1000_1200 5921 5921 0 0.00 2 31053 1244 0 0
x_make_qstorno_1200_2000 6034 6034 0 0.00 4 106515 3290 0 0
x_make_qstorno_2100_3300 498281 498281 0 0.00 0 107092 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-12-2020 22:27:57 to 31-12-2020 22:28:01.

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:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:16 26688 8192000000 10305146160 10620551168 1085500640 11.700 82 61 122 0 1107609200 3206528 18902032
19:57:52 27998 8192000000 10367558352 10690691072 1420303824 14.775 100 85 170 0 1452758768 5711312 26743632
19:58:30 24608 8192000000 10404610224 10728964096 1451415248 15.050 100 86 172 0 1485999136 7196800 27387088
19:59:08 33380 8192000000 10431897232 10761506816 1484981504 15.345 100 92 184 0 1522818160 8737120 29099536
19:59:58 23872 8192000000 10458778192 10794819584 1511207936 15.574 100 89 178 1 1548800352 9522000 28070416
20:00:32 9532 8192000000 10476304576 10813894656 1529987616 15.737 100 88 176 0 1567728672 10035520 27705536
20:00:54 21432 8192000000 10501913536 10844889088 1549951616 15.910 100 86 172 0 1587067760 10572464 26543680
20:01:24 21598 8192000000 10519151776 10866962432 1570354320 16.085 100 86 172 0 1607290560 10720528 26215712
20:01:54 10973 8192000000 10529722592 10878140416 1586487296 16.224 100 83 166 2 1623338416 11068512 25782608
20:02:15 14656 8192000000 10546028032 10903535616 1602437920 16.360 100 73 146 0 1634977104 10203712 22335472
20:02:44 10322 8192000000 10558386032 10920484864 1628664640 16.584 100 75 150 0 1661751792 10629440 22457712
20:03:02 16933 8192000000 10582776128 10951192576 1645361504 16.725 100 70 140 1 1677655616 11032768 21261344
20:03:26 10850 8192000000 10613287952 10979536896 1671958496 16.950 100 76 150 3 1705145760 10976784 22210480
20:03:46 9012 8192000000 10624972816 10996088832 1684732304 17.057 100 78 155 0 1719091280 11583328 22775648
20:04:04 9828 8192000000 10634440864 11004121088 1697799680 17.167 100 73 146 2 1730774304 11921056 21053568
20:04:21 7387 8192000000 10640385824 11015114752 1712107472 17.286 100 81 163 1 1748562864 13222848 23232544
20:04:35 6095 8192000000 10670371680 11044007936 1722825472 17.376 100 78 152 1 1756970400 12115120 22029808
20:04:50 6787 8192000000 10674592736 11050721280 1736096176 17.486 100 79 159 0 1772302864 13871088 22335600
20:05:04 5086 8192000000 10676918608 11053318144 1745298240 17.563 100 80 160 3 1781904720 14342448 22264032
20:05:16 5560 8192000000 10694082912 11070595072 1757943264 17.667 100 76 148 2 1791770240 13111040 20715936
20:05:28 2852 8192000000 10705421760 11085742080 1765798192 17.732 100 79 155 0 1800333568 12811776 21723600
20:05:38 5361 8192000000 10712511088 11098308608 1780052624 17.850 100 78 155 1 1814410912 12814336 21543952
20:05:50 6787 8192000000 10719862176 11100172288 1784589488 17.887 100 71 143 2 1816632768 12153472 19889808
20:06:04 3524 8192000000 10734923648 11122626560 1797890000 17.997 100 68 135 1 1828206000 11815968 18500032
20:06:14 2656 8192000000 10748199840 11132272640 1812102848 18.113 100 81 162 1 1847838800 11445808 24290144
20:06:24 3237 8192000000 10754892256 11143376896 1818517264 18.166 100 84 166 2 1855290080 13220096 23552720
20:06:34 2769 8192000000 10773399264 11157925888 1828942160 18.251 100 90 180 0 1868377920 13843856 25591904
20:06:43 3262 8192000000 10781973408 11168043008 1835425488 18.304 100 93 184 0 1875190448 13913104 25851856
20:06:53 1326 8192000000 10791606496 11178409984 1844575440 18.378 100 90 178 1 1883599552 14024400 24999712
20:07:01 2236 8192000000 10787610880 11175305216 1848125392 18.407 100 93 186 0 1888887648 14527152 26235104
20:07:10 1426 8192000000 10789889568 11178299392 1853813616 18.453 100 91 183 0 1893093776 13045888 26234272
20:07:17 2172 8192000000 10803014000 11189514240 1860238064 18.505 100 85 170 3 1897524256 13028208 24257984
20:07:26 2040 8192000000 10801717952 11190976512 1864980208 18.544 100 84 168 1 1901793648 12042960 24770480
20:07:34 2798 8192000000 10805959632 11195092992 1865626784 18.549 100 89 178 0 1904005856 13127344 25251728
20:07:44 2203 8192000000 10811530032 11201130496 1866203712 18.554 100 82 163 2 1902380192 12967856 23208624
20:07:53 1691 8192000000 10815035424 11202805760 1870283056 18.587 100 87 174 0 1908760320 13907808 24569456
20:08:01 7038 8192000000 10819664816 11210502144 1871737632 18.598 100 83 166 1 1910577136 14211856 24627648
20:08:14 24516 8192000000 10779460448 11199238144 1868576688 18.573 100 62 124 0 1897794512 11893760 17324064
20:08:46 5445 8192000000 10781672992 11201810432 1867998080 18.568 100 43 85 1 1891258784 10831184 12429520
20:08:59 10268 8192000000 10795609584 11209015296 1871642640 18.598 100 39 77 1 1890686864 8351040 10693184
20:09:18 6389 8192000000 10782991888 11210964992 1874537824 18.621 100 30 60 0 1890816512 7692000 8586688
20:09:36 4259 8192000000 10789095488 11213275136 1882628544 18.686 100 44 86 3 1902977536 7233264 13115728
20:09:51 9488 8192000000 10788511840 11221782528 1880957408 18.673 100 26 52 1 1899122464 11079040 7086016
20:10:08 7050 8192000000 10790612240 11224035328 1885450624 18.709 100 30 60 2 1900975696 7408000 8117072
20:10:25 4851 8192000000 10790788384 11224100864 1885862048 18.712 100 22 44 0 1897299488 5808192 5629248
20:10:37 7189 8192000000 10810605888 11235299328 1887584368 18.726 100 32 64 3 1908710016 12077728 9047920
20:10:53 9256 8192000000 10790085328 11222740992 1886594832 18.718 100 21 42 0 1898377376 6356944 5425600
20:11:12 11706 8192000000 10792144688 11226083328 1886452752 18.717 100 12 24 2 1895866640 5988800 3425088
20:11:30 5392 8192000000 10801241680 11229597696 1890124960 18.747 100 24 47 1 1904118704 7033552 6960192
20:11:47 6299 8192000000 10797990992 11231068160 1891519840 18.758 100 23 46 1 1904726688 6858496 6348352
20:11:59 53310 8192000000 10809988848 11250319360 1898199552 18.812 100 39 78 1 1915495536 4959328 12336656
20:13:05 19948 8192000000 10819078864 11252658176 1900662528 18.832 100 33 66 0 1915888080 6077648 9147904
20:13:31 8307 8192000000 10819486736 11248369664 1897332480 18.805 100 18 36 2 1908565728 6048368 5184880
20:13:47 7206 8192000000 10828463136 11255164928 1900857760 18.833 100 36 72 0 1922697280 11916560 9922960
20:14:02 6410 8192000000 10815473696 11250184192 1900203408 18.828 100 25 50 0 1914328000 7358736 6765856
20:14:17 6599 8192000000 10833389872 11258867712 1905558832 18.871 100 38 76 2 1924296512 7726208 11011472
20:14:31 2569 8192000000 10819433328 11254046720 1905984000 18.874 100 32 65 2 1921249504 6751984 8513520
20:14:41 4995 8192000000 10818493168 11256000512 1907119648 18.884 100 33 65 2 1923328352 6576912 9631792
20:14:53 12874 8192000000 10815442048 11252363264 1903603808 18.855 100 25 50 1 1917932320 6741760 7586752
20:15:13 8168 8192000000 10822036720 11260121088 1901924144 18.842 100 30 60 1 1920882976 10874576 8084256
20:15:29 7477 8192000000 10811154448 11248963584 1884539232 18.702 99 24 48 1 1897173760 6118640 6515888
20:15:43 7588 8192000000 10811496544 11247009792 1897472304 18.806 100 15 30 2 1907631024 4994896 5163824
20:15:58 14418 8192000000 10801347232 11239530496 1861807088 18.518 98 19 39 0 1876871712 9526896 5537728
20:16:19 6899 8192000000 10811266496 11243003904 1876208880 18.634 99 12 22 0 1885573696 4860416 4504400
20:16:33 16982 8192000000 10799626320 11237650432 1862862976 18.526 98 13 26 1 1879825056 13583168 3378912
20:17:00 58031 8192000000 10762922416 11201609728 1799121232 18.007 96 25 50 1 1811483488 4688352 7673904
20:18:08 8598 8192000000 10746966608 11169308672 1760892672 17.692 95 19 38 0 1771975824 5158368 5924784
20:18:25 10927 8192000000 10736214672 11151970304 1729117008 17.428 94 23 46 2 1741400512 5614832 6668672
20:18:42 5553 8192000000 10755030112 11174612992 1825506080 18.223 100 30 60 2 1841057904 6726256 8825568
20:18:54 5541 8192000000 10725318528 11136884736 1719172224 17.345 94 34 68 1 1736519936 7170896 10176816
20:19:06 9304 8192000000 10716774672 11141677056 1778411584 17.836 98 30 61 0 1793320320 6551728 8357008
20:19:23 5221 8192000000 10755930528 11172016128 1816060528 18.145 99 31 62 2 1830197696 5856544 8280624
20:19:36 10425 8192000000 10696778480 11113869312 1648719744 16.754 90 20 39 2 1659568736 4622144 6226848
20:19:56 8384 8192000000 10671041776 11080396800 1665266656 16.893 94 18 36 1 1675825552 4795856 5763040
20:20:10 9908 8192000000 10687405376 11102334976 1739100176 17.511 98 18 35 1 1749296256 5506480 4689600
20:20:26 9122 8192000000 10686439744 11105738752 1746494816 17.573 97 25 50 0 1759332496 5548240 7289440
20:20:41 10884 8192000000 10731682608 11146133504 1794444176 17.968 99 23 44 0 1805750752 4731792 6574784
20:20:58 7255 8192000000 10747359232 11163025408 1809371968 18.091 99 28 56 1 1827213872 9351376 8490528
20:21:12 9294 8192000000 10751678832 11171110912 1829280848 18.253 100 16 31 2 1838820400 4987584 4551968
20:21:28 10240 8192000000 10751166272 11173531648 1817877568 18.160 99 22 44 0 1831275952 5781888 7616496
20:21:46 70153 8192000000 10766951552 11185606656 1830647344 18.265 99 32 64 2 1845485776 4663712 10174720
20:23:02 5039 8192000000 10756565472 11191304192 1851191360 18.432 100 23 46 2 1863749792 6515616 6042816
20:23:14 9093 8192000000 10774354736 11202179072 1855818672 18.469 100 25 50 0 1869214304 6585936 6809696
20:23:30 5972 8192000000 10764325280 11185573888 1836555600 18.313 99 46 89 3 1855730496 5760672 13414224
20:23:43 7773 8192000000 10771074752 11197292544 1856340688 18.474 100 33 66 1 1873588672 7164384 10083600
20:23:58 9562 8192000000 10772709264 11202269184 1859842688 18.502 100 19 37 1 1875308752 10248640 5217424
20:24:17 9459 8192000000 10782426128 11205107712 1863462944 18.531 100 15 30 1 1873455920 5341664 4651312
20:24:33 10947 8192000000 10787254208 11212398592 1866626736 18.557 100 18 36 1 1877448768 5912768 4909264
20:24:50 10376 8192000000 10779543760 11209474048 1868727728 18.574 100 24 48 1 1880543200 5105232 6710240
20:25:14 5694 8192000000 10785715104 11218038784 1872559024 18.605 100 28 56 3 1886239328 6392208 7288096
20:25:29 8876 8192000000 10776137888 11214065664 1870978464 18.592 100 18 34 1 1881628784 5542304 5108016
20:25:48 9041 8192000000 10781901504 11219886080 1874488768 18.621 100 19 37 2 1885918368 5818080 5611520
20:26:03 10851 8192000000 10783442992 11220312064 1874917696 18.624 100 13 26 2 1884877792 6144016 3816080
20:26:20 10776 8192000000 10793741040 11225473024 1875219488 18.626 100 15 30 0 1885366864 5403808 4743568
20:26:39 82502 8192000000 10830487904 11249287168 1891087456 18.755 100 34 66 1 1905782368 5243120 9451792
20:28:14 9637 8192000000 10839494144 11261943808 1909843392 18.905 100 50 100 0 1931748112 7579024 14325696
20:28:33 31153 8192000000 10850987584 11275202560 1925356832 19.030 100 49 98 1 1949443920 10120288 13966800
20:29:14 20112 8192000000 10869493552 11287883776 1930808624 19.073 100 50 99 1 1955073584 10174096 14090864
20:29:45 18553 8192000000 10868529456 11292585984 1934010416 19.099 100 47 95 1 1958254496 11108864 13135216
20:30:12 3722 8192000000 10886301392 11304886272 1946847808 19.201 100 57 113 3 1975454288 12189712 16416768
20:30:23 32953 8192000000 10883470944 11316830208 1953634336 19.255 100 54 107 1 1982449840 13724304 15091200
20:31:07 22599 8192000000 10880360576 11320426496 1938214032 19.133 99 44 88 1 1963228928 12845968 12168928
20:31:38 21379 8192000000 10883071392 11319894016 1955019024 19.266 100 40 79 1 1977734240 10919552 11795664
20:32:10 15801 8192000000 10890471024 11322556416 1957453232 19.286 100 48 96 1 1984994000 13229856 14310912
20:32:35 2881 8192000000 10912244768 11333472256 1967272000 19.364 100 63 124 2 1998390080 13163888 17954192
20:32:46 13618 8192000000 10917867504 11338633216 1970525152 19.390 100 60 121 1 2002730752 15278208 16927392
20:33:06 18176 8192000000 10911264448 11334225920 1965652624 19.351 100 61 122 2 1999692912 16547760 17492528
20:33:34 11597 8192000000 10912894352 11347148800 1974973328 19.425 100 47 94 0 2004007856 14320592 14713936
20:34:00 19667 8192000000 10935503728 11362635776 1988922992 19.535 100 47 92 2 2018953984 15922976 14108016
20:34:28 7072 8192000000 10939785632 11368497152 1994446704 19.579 100 64 128 0 2029759744 15211936 20101104
20:34:52 7727 8192000000 10927383232 11368599552 1995441392 19.587 100 56 112 1 2027720592 15907424 16371776
20:35:08 5552 8192000000 10929686240 11363713024 1991790352 19.558 100 58 116 2 2023341280 13756784 17794144
20:35:26 6059 8192000000 10930503280 11360043008 1974819344 19.424 99 45 87 1 2003641184 14605392 14216448
20:35:40 19095 8192000000 10923726768 11356332032 1972393904 19.404 99 57 113 3 2005454384 15918592 17141888
20:36:11 12069 8192000000 10945951072 11374325760 1997860848 19.606 100 71 138 4 2037002944 18231184 20910912
20:36:30 3616 8192000000 10953856240 11379580928 1999647088 19.620 100 60 119 1 2036929440 19786832 17495520
20:36:43 3845 8192000000 10976965776 11399266304 2008368768 19.689 100 74 148 0 2053730304 23565600 21795936
20:36:56 2740 8192000000 10965464448 11390398464 2005876944 19.669 100 74 147 1 2050628000 22994848 21756208
20:37:07 2091 8192000000 10944610096 11359666176 1982307552 19.483 100 85 170 1 2031153344 23626400 25219392
20:37:15 1424 8192000000 10946985168 11358646272 1971022064 19.394 99 91 182 0 2018913552 22283760 25607728
20:37:23 2409 8192000000 10952056928 11363733504 1985059472 19.505 100 74 148 1 2029915216 23906304 20949440
20:37:33 5126 8192000000 10938002848 11366739968 1974363248 19.420 99 64 128 0 2016770288 23986128 18420912
20:37:45 8202 8192000000 10924650896 11346604032 1942623920 19.168 98 70 139 2 1987086848 24023744 20439184
20:38:02 3636 8192000000 10922421712 11344904192 1965196784 19.347 100 66 132 1 2010490640 25631472 19662384
20:38:12 6403 8192000000 10924338448 11348062208 1954557472 19.263 99 66 132 2 2001616176 26707984 20350720
20:38:26 2885 8192000000 10920410112 11343228928 1965340976 19.348 100 78 154 3 2014458400 25313760 23803664
20:38:39 3057 8192000000 10915095264 11326840832 1938080320 19.131 99 74 147 1 1985222992 24233680 22908992
20:38:50 8330 8192000000 10917768832 11343478784 1962766736 19.328 100 60 120 0 2006361168 25072752 18521680
20:39:07 2845 8192000000 10909341456 11320938496 1946855184 19.201 100 84 164 7 1995321376 22887312 25578880
20:39:17 4688 8192000000 10908186480 11323527168 1936791936 19.121 99 80 159 0 1983947792 23555696 23600160
20:39:29 13970 8192000000 10922297392 11336155136 1958090560 19.291 100 71 141 0 2003267184 24713552 20463072
20:39:49 8276 8192000000 10890558848 11314978816 1926332720 19.038 99 57 114 0 1967583472 24416064 16834688
20:40:05 4660 8192000000 10920681248 11336257536 1953990800 19.258 100 73 143 2 2000339472 25285040 21063632
20:40:23 2846 8192000000 10901578848 11314151424 1928078112 19.052 98 69 134 2 1967814816 19658192 20078512
20:40:33 18698 8192000000 10903451856 11320561664 1920843840 18.994 98 59 118 1 1959145584 20844912 17456832
20:41:04 4854 8192000000 10886568432 11306565632 1930435104 19.070 100 60 118 1 1971627632 23782816 17409712
20:41:18 8144 8192000000 10889248880 11308408832 1903749168 18.856 98 62 122 1 1946112672 23769600 18593904
20:41:37 8385 8192000000 10885293024 11303653376 1926039440 19.035 100 70 141 4 1971427856 25008832 20379584
20:41:55 5423 8192000000 10903062976 11322195968 1944327808 19.181 100 69 135 1 1990524048 25384448 20811792
20:42:10 6022 8192000000 10911791280 11324100608 1945894512 19.194 100 71 140 2 1994003136 26544624 21564000
20:42:27 5278 8192000000 10886264432 11304472576 1923532064 19.015 100 63 123 3 1970054224 27398384 19123776
20:42:39 1776 8192000000 10888243792 11298856960 1915933808 18.954 100 81 159 1 1969398224 29368016 24096400
20:42:50 1562 8192000000 10899320096 11297665024 1922845952 19.010 100 86 172 0 1976341184 27550880 25944352
20:42:59 10403 8192000000 10866732240 11286966272 1895203408 18.788 99 59 118 3 1942327728 28817168 18307152
20:43:16 2435 8192000000 10884836832 11300012032 1901229056 18.836 99 58 114 2 1947291200 28055984 18006160
20:43:26 2998 8192000000 10886989232 11296382976 1914395712 18.942 100 53 103 0 1960669104 29234784 17038608
20:43:37 6639 8192000000 10866902928 11289464832 1898821184 18.817 99 52 103 3 1945845184 31281568 15742432
20:43:55 4210 8192000000 10884893136 11297775616 1895780624 18.792 99 63 124 2 1952577424 37508240 19288560
20:44:06 1624 8192000000 10906481392 11309858816 1923502240 19.015 100 80 160 2 1983281968 34885984 24893744
20:44:14 3031 8192000000 10892824848 11314106368 1922877760 19.010 100 58 116 3 1977888720 37438464 17572496
20:44:27 6915 8192000000 10874381744 11311882240 1923295536 19.013 100 38 74 1 1963574688 28617424 11661728
20:44:46 2555 8192000000 10883839136 11310305280 1927439456 19.046 100 51 100 1 1969949920 27028896 15481568
20:44:58 5722 8192000000 10888128672 11299688448 1883221184 18.691 98 64 128 0 1935551200 31773696 20556320
20:45:10 5813 8192000000 10889575600 11309039616 1924194112 19.020 100 68 137 1 1975725952 29631808 21900032
20:45:23 3092 8192000000 10911153568 11325583360 1933984080 19.099 100 67 132 1 1985695184 31153984 20557120
20:45:34 3881 8192000000 10902462032 11314470912 1925405008 19.030 100 75 148 0 1980949184 32465232 23078944
20:45:45 4878 8192000000 10869390448 11302981632 1916333904 18.957 100 43 86 0 1959321344 29987024 13000416
20:46:18 3523 8192000000 10879837024 11287044096 1901409648 18.838 99 62 124 2 1942887264 23301536 18176080
20:46:28 3279 8192000000 10897011408 11304710144 1923743584 19.017 100 77 151 3 1969484064 24010848 21729632
20:46:38 4796 8192000000 10921412192 11323711488 1942091888 19.163 100 86 170 1 1995371552 27583872 25695792
20:46:50 4280 8192000000 10912041776 11330654208 1947501984 19.207 100 68 136 1 1997059888 28806480 20751424
20:47:04 4827 8192000000 10880941408 11302567936 1924825216 19.025 99 46 90 2 1964059744 25306624 13927904
20:47:17 4127 8192000000 10913882704 11343278080 1951779344 19.241 100 52 101 2 1996882688 29812832 15290512
20:47:35 4509 8192000000 10928145648 11340877824 1942296784 19.165 99 63 122 0 1990710480 29344960 19068736
20:47:47 4244 8192000000 10941486176 11356340224 1972231264 19.403 100 78 156 0 2028052384 32087904 23733216
20:47:59 4572 8192000000 10932517280 11361280000 1969607440 19.382 100 57 112 2 2021005056 34001904 17395712
20:48:15 5720 8192000000 10930521712 11362344960 1968482992 19.373 100 42 84 2 2014563072 32973872 13106208
20:48:29 4051 8192000000 10946651520 11370008576 1976700544 19.439 100 70 139 2 2031033280 33385600 20947136
20:48:41 3460 8192000000 10958958784 11369451520 1975462576 19.429 100 86 173 3 2037780544 35147680 27170288
20:48:52 1051 8192000000 10952343328 11369689088 1977053152 19.441 100 70 140 0 2035163216 35896032 22214032
20:49:02 2420 8192000000 10973815520 11381567488 1981933104 19.480 100 82 165 0 2047353040 39080016 26339920
20:49:15 11413 8192000000 10932495296 11372335104 1956473856 19.278 99 39 78 0 2006129952 37277872 12378224
20:49:49 10274 8192000000 10954181984 11384066048 1978016608 19.449 100 48 93 1 2038687136 45066384 15604144
20:50:07 4691 8192000000 10946185376 11385851904 1971791456 19.400 100 52 102 1 2034019840 45240672 16987712
20:50:19 7252 8192000000 10965505344 11389546496 1983213568 19.490 100 60 121 1 2042652096 40232000 19206528
20:50:36 2442 8192000000 10975963712 11396694016 1989204272 19.538 100 69 138 0 2052848304 41645536 21998496
20:50:45 3657 8192000000 10975690640 11384442880 1979969552 19.464 100 81 162 2 2048945312 42336848 26638912
20:50:57 912 8192000000 10985887584 11390648320 1988749088 19.534 100 97 194 2 2062143552 44295872 29098592
20:51:05 3421 8192000000 10973076144 11392843776 1985763248 19.510 100 69 138 2 2054805600 47916608 21125744
20:51:21 16493 8192000000 10957720592 11400089600 1988956496 19.536 100 41 82 0 2051257488 48085264 14215728
20:51:50 18124 8192000000 10945500160 11393998848 1979936096 19.464 100 29 58 0 2036897168 46335904 10625168
20:52:22 6984 8192000000 10960094656 11393368064 1987250096 19.522 100 51 103 1 2042508896 38702976 16555824
20:52:35 25413 8192000000 10942590832 11395346432 1965818384 19.352 99 43 86 2 2023972752 43852336 14302032
20:53:27 15934 8192000000 10952319776 11407892480 1984807728 19.503 100 31 61 0 2034926992 39611840 10507424
20:54:05 5257 8192000000 10945779552 11388485632 1958104976 19.291 99 30 60 1 2010780928 42387024 10288928
20:54:17 12253 8192000000 10949521104 11398230016 1980066912 19.465 100 35 68 0 2032357360 40807232 11483216
20:54:42 22281 8192000000 10944710752 11400597504 1987704128 19.526 100 35 71 3 2037219680 37087136 12428416
20:55:48 36966 8192000000 10939143280 11403247616 1957068672 19.283 99 29 58 0 2018590592 50866448 10655472
20:56:47 32785 8192000000 10915876560 11386806272 1952938704 19.250 100 17 34 3 2002889328 43541680 6408944
20:57:27 42010 8192000000 10909035232 11376340992 1955462704 19.270 100 8 16 0 1990938224 32841632 2633888
20:58:15 55087 8192000000 10910904400 11381620736 1975681792 19.430 100 10 20 0 1992939104 14633648 2623664
20:59:17 139811 8192000000 10893856640 11360153600 1844011696 18.373 93 9 18 0 1866255200 20030480 2213024
21:01:43 56886 8192000000 10924212096 11363733504 1972212992 19.403 100 29 58 0 1996861584 16604784 8043808
21:02:58 39870 8192000000 10934517792 11375316992 1961520912 19.318 99 9 18 1 1971391936 7419968 2451056
21:03:50 103967 8192000000 10916051040 11375742976 1926240496 19.037 97 17 34 1 1943196272 12314096 4641680
21:05:41 90143 8192000000 10923212992 11379703808 1955699520 19.272 98 28 56 0 1973935856 10763504 7472832
21:07:17 29071 8192000000 10918320320 11372933120 1965138080 19.347 99 29 57 0 1982451840 9422400 7891360
21:08:42 72696 8192000000 10905535776 11360485376 1904624032 18.863 96 16 32 0 1922236720 12763472 4849216
21:10:09 91240 8192000000 10906734848 11364532224 1938163520 19.132 98 31 60 2 1959279152 12251888 8863744
21:12:06 33465 8192000000 10912838112 11368660992 1965125664 19.347 99 44 88 0 1988197344 9417184 13654496
21:12:47 39008 8192000000 10893667152 11339390976 1913474080 18.935 97 33 64 2 1935037920 11363088 10200752
21:13:34 80586 8192000000 10883182976 11348893696 1926134928 19.036 98 23 46 1 1945492000 12392992 6964080
21:15:21 25926 8192000000 10848879360 11317022720 1899788240 18.825 98 11 22 0 1909134544 6593616 2752688
21:15:56 26720 8192000000 10865023472 11327946752 1909673360 18.904 98 26 52 3 1923925568 7067392 7184816
21:16:32 15221 8192000000 10881766576 11323949056 1888154384 18.731 97 44 89 0 1908423872 7693712 12575776
21:16:57 30230 8192000000 10893114096 11347812352 1944392080 19.182 100 56 111 1 1975953296 16109648 15451568
21:17:37 36447 8192000000 10895640336 11337580544 1929208864 19.061 99 55 110 1 1960335744 15008752 16118128
21:18:22 15943 8192000000 10874822688 11331596288 1927058864 19.043 99 43 85 1 1956122432 17215072 11848496
21:18:48 158992 8192000000 10840281856 11306967040 1823286816 18.205 94 18 36 2 1846568544 18090400 5191328
21:21:34 24055 8192000000 10862000080 11325665280 1926663936 19.040 100 11 20 1 1942196064 12757744 2774384
21:22:09 59449 8192000000 10857260032 11329687552 1904596368 18.863 98 15 30 1 1923563376 14620128 4346880
21:23:15 59642 8192000000 10857753248 11332616192 1919249296 18.981 99 13 26 0 1936077760 12839584 3988880
21:24:25 55871 8192000000 10875122400 11346341888 1921676032 19.000 99 23 46 2 1945001136 16544976 6780128
21:25:27 56515 8192000000 10872797328 11344187392 1928809856 19.057 99 12 24 0 1946631776 14699904 3122016
21:26:36 46620 8192000000 10879563568 11357552640 1950425664 19.230 100 11 22 0 1964936688 12085520 2425504
21:27:30 65011 8192000000 10826210880 11287752704 1793321152 17.959 92 8 15 1 1800333088 5335264 1676672
21:28:41 47835 8192000000 10864425232 11326554112 1900756928 18.832 99 17 34 1 1913128256 7844832 4526496
21:29:35 48364 8192000000 10850923344 11314327552 1855040592 18.463 96 13 26 0 1870148688 11217632 3890464
21:30:34 71736 8192000000 10851648944 11317178368 1859563248 18.500 96 21 42 1 1889513712 23414704 6535760
21:31:52 60531 8192000000 10839589040 11328524288 1865071952 18.544 97 15 30 2 1888678096 18927056 4679088
21:32:59 58009 8192000000 10851286352 11309379584 1849024608 18.414 96 24 48 0 1868469344 12802528 6642208
21:34:05 36154 8192000000 10871008192 11333115904 1903853040 18.857 99 22 44 1 1925652400 15590144 6209216
21:34:47 44436 8192000000 10849657152 11316928512 1892468592 18.766 98 20 40 0 1909045728 11123488 5453648
21:35:54 72138 8192000000 10849340928 11314868224 1873807520 18.615 97 19 38 2 1892160512 12691824 5661168
21:37:12 84735 8192000000 10854333184 11327840256 1890852768 18.753 98 14 28 0 1906434688 11526992 4054928
21:38:44 46393 8192000000 10891216288 11329220608 1916456384 18.958 99 35 67 3 1936529936 10612560 9460992
21:39:38 29350 8192000000 10878956240 11337826304 1940854416 19.154 100 44 88 1 1964824240 11268528 12701296
21:40:16 39518 8192000000 10904974592 11346857984 1953074880 19.251 100 37 73 0 1972719344 9255024 10389440
21:41:05 14602 8192000000 10887120432 11335360512 1929158160 19.060 99 37 74 1 1949591728 10362720 10070848
21:41:27 18271 8192000000 10881648704 11328151552 1927156752 19.044 99 43 86 3 1948875536 10089200 11629584
21:41:56 118519 8192000000 10889711264 11359182848 1952183856 19.244 100 28 56 0 1971546320 11642816 7719648
21:44:58 37055 8192000000 10872274640 11341193216 1923765360 19.017 98 33 66 0 1944190576 10769040 9656176
21:45:49 54695 8192000000 10868355216 11354836992 1943046544 19.171 100 10 20 1 1957737152 11848608 2842000
21:47:01 30660 8192000000 10871622368 11361624064 1947656080 19.208 100 4 8 1 1965211888 16326928 1228880
21:47:40 11279 8192000000 10869625824 11356258304 1931047152 19.075 99 6 13 1 1948456848 15714928 1694768
21:48:09 70673 8192000000 10870950080 11353120768 1955261024 19.268 100 17 34 0 1975845344 15037440 5546880
21:50:04 102749 8192000000 10879041600 11356532736 1947568640 19.207 99 17 34 1 1965577296 12989440 5019216
21:51:53 59836 8192000000 10879048176 11363180544 1959961584 19.306 100 8 16 0 1970475440 8460896 2052960
21:52:59 47294 8192000000 10878859040 11355336704 1940493184 19.151 99 10 20 0 1950652880 6968784 3190912
21:53:57 21528 8192000000 10886889344 11353673728 1958572576 19.295 100 30 58 0 1975008832 7621520 8814736
21:54:47 25410 8192000000 10905713184 11360722944 1944376000 19.182 99 25 50 0 1958779392 7374736 7028656
21:55:24 43898 8192000000 10890199024 11362516992 1942356768 19.166 99 20 40 0 1958210512 10110080 5743664
21:56:14 34744 8192000000 10899630736 11362140160 1933694912 19.096 98 42 80 0 1957801760 12977232 11129616
21:57:03 53846 8192000000 10885403872 11359985664 1921141504 18.996 98 30 61 1 1949156944 19676928 8338512
21:58:12 82403 8192000000 10883021520 11350646784 1909658944 18.904 98 8 16 0 1929888656 18539072 1690640
21:59:41 36962 8192000000 10888767408 11347693568 1923713968 19.017 98 26 52 0 1940340784 9130288 7496528
22:00:26 96412 8192000000 10898112848 11366408192 1928426208 19.054 98 18 36 0 1943952832 10754304 4772320
22:02:09 111102 8192000000 10892456480 11337498624 1866934848 18.559 95 11 22 1 1880102496 10299856 2867792
22:04:13 30852 8192000000 10879387584 11342229504 1933179616 19.092 99 19 38 0 1949900016 12074720 4645680
22:04:53 22524 8192000000 10900744048 11355013120 1940600544 19.152 99 36 72 2 1962552160 12032368 9919248
22:05:22 66273 8192000000 10865850368 11341049856 1878268432 18.651 96 25 49 1 1900614784 15775280 6571072
22:06:34 74218 8192000000 10866885984 11312320512 1806428800 18.067 93 28 55 1 1824739936 10632112 7679024
22:07:55 120642 8192000000 10863666288 11328647168 1896405392 18.797 98 29 58 3 1922705808 17937744 8362672
22:10:03 45523 8192000000 10853361520 11334742016 1907231968 18.884 99 11 22 1 1926841520 15918768 3690784
22:10:54 27609 8192000000 10829570480 11305017344 1882074960 18.682 98 11 22 0 1901942752 16366992 3500800
22:11:33 61200 8192000000 10829333728 11308498944 1859297920 18.498 97 14 28 0 1873375232 10253200 3824112
22:12:43 79408 8192000000 10848913280 11303309312 1886869216 18.721 98 10 18 0 1896820048 7200080 2750752
22:14:12 71510 8192000000 10856911280 11329253376 1902482272 18.846 98 13 24 1 1914230368 8175952 3572144
22:15:34 62777 8192000000 10839577296 11316969472 1860981808 18.511 96 7 14 1 1874259648 10525136 2752704
22:17:12 60176 8192000000 10832847344 11306590208 1851559552 18.435 96 11 22 0 1866569616 11725392 3284672
22:18:19 23796 8192000000 10840905584 11302137856 1879501024 18.661 98 34 68 0 1900298736 10867024 9930688
22:18:53 22001 8192000000 10854992048 11308634112 1891991248 18.762 98 51 100 2 1915657056 9192336 14473472
22:19:24 42956 8192000000 10871372576 11329069056 1912084144 18.923 99 37 74 2 1935087952 12214224 10789584
22:20:25 80528 8192000000 10856001488 11329232896 1913919968 18.938 99 24 48 3 1929433760 8612176 6901616
22:21:58 53348 8192000000 10867422512 11321053184 1868468752 18.572 97 9 18 1 1878669296 8108864 2091680
22:22:57 27774 8192000000 10866781712 11322494976 1927868720 19.050 100 46 92 2 1951515856 10355280 13291856
22:23:36 69398 8192000000 10840458096 11294621696 1856152880 18.472 96 33 67 1 1881213568 15771984 9288704
22:24:51 45095 8192000000 10882738800 11327213568 1910624960 18.912 99 46 91 1 1934412688 10439328 13348400
22:25:46 43124 8192000000 10860382464 11327778816 1910985584 18.915 99 20 40 1 1926443296 10025888 5431824
22:26:36 19719 8192000000 10880444512 11335651328 1943381088 19.174 100 28 56 1 1959084512 8181232 7522192
22:27:05 13482 8192000000 8976255168 9165500416 142881664 1.714 8 2 4 0 144248240 1238496 128080

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 31-12-2020 22:28:03 to 31-12-2020 22:28:36.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 116 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 31-12-2020 22:28:37 to 31-12-2020 22:28:39.

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          256531
MON$OLDEST_ACTIVE               256532
MON$OLDEST_SNAPSHOT             256532
MON$NEXT_TRANSACTION            256532
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                       2072096
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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'

31.12.20 22:28:40. 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
2020-12-31 22:28:42 No severe PSQL-related problems occured
31.12.20 22:28:43. End of report.