Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.12.2020 19: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 17385452 kB
MemAvailable 31436156 kB
Buffers 0 kB
Cached 14283652 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-26 19:27:06
DTS_END                         2020-12-26 19:27:06.6950
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41688
TRN_ID                          236496
ATT_ID                          622
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: 9100.44 20474 1092053
customer order: creation 168.11 352 20173
customer order: refuse 13.98 372 1677
order to supplier: creation 43.62 1269 5234
order to supplier: removal 3.42 113222 410
invoice (draft): creation 44.39 3519 5327
invoice (draft): removal 53.23 828 6388
invoice accept: apply 39.36 19457 4723
invoice accept: cancel 48.54 822 5825
customer reserve: creation 3695.46 189 443455
customer reserve: removal 4698.92 65 563870
realization accept: apply 79.61 189 9553
realization accept: cancel 88.13 120 10576
payment from customer: creation 56.56 108 6787
payment from customer: removal 5.29 99 635
payment to supplier: creation 47.11 116 5653
payment to supplier: removal 3.23 84 387
service: total inventory turnovers 4.43 1107 532
service: total monetary turnovers 6.30 27 756
service: aggregate perf. data 0.73 26755 88
service: refresh index statistics 0.03 240786 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-12-2020 19:27:46 to 26-12-2020 19:27:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1858
TEST_TIME 2 3043
TEST_TIME 3 4534
TEST_TIME 4 4283
TEST_TIME 5 4443
TEST_TIME 6 4634
TEST_TIME 7 4704
TEST_TIME 8 5095
TEST_TIME 9 5365
TEST_TIME 10 6195
TEST_TIME 11 6441
TEST_TIME 12 6359
TEST_TIME 13 6638
TEST_TIME 14 6906
TEST_TIME 15 6814
TEST_TIME 16 7134
TEST_TIME 17 7440
TEST_TIME 18 7586
TEST_TIME 19 7811
TEST_TIME 20 8355
TEST_TIME 21 8447
TEST_TIME 22 8474
TEST_TIME 23 8612
TEST_TIME 24 9251
TEST_TIME 25 9424
TEST_TIME 26 10094
TEST_TIME 27 11190
TEST_TIME 28 10888
TEST_TIME 29 10629
TEST_TIME 30 10706
TEST_TIME 31 10628
TEST_TIME 32 10404
TEST_TIME 33 10249
TEST_TIME 34 10112
TEST_TIME 35 10022
TEST_TIME 36 9959
TEST_TIME 37 9825
TEST_TIME 38 9982
TEST_TIME 39 9887
TEST_TIME 40 9676
TEST_TIME 41 9582
TEST_TIME 42 9625
TEST_TIME 43 9591
TEST_TIME 44 9442
TEST_TIME 45 9348
TEST_TIME 46 9255
TEST_TIME 47 9233
TEST_TIME 48 9388
TEST_TIME 49 9263
TEST_TIME 50 9153
TEST_TIME 51 9097
TEST_TIME 52 9103
TEST_TIME 53 9146
TEST_TIME 54 9130
TEST_TIME 55 9152
TEST_TIME 56 9097
TEST_TIME 57 9073
TEST_TIME 58 9099
TEST_TIME 59 9091
TEST_TIME 60 9065
TEST_TIME 61 9011
TEST_TIME 62 9347
TEST_TIME 63 9343
TEST_TIME 64 9441
TEST_TIME 65 9410
TEST_TIME 66 9397
TEST_TIME 67 9457
TEST_TIME 68 9462
TEST_TIME 69 9434
TEST_TIME 70 9502
TEST_TIME 71 9486
TEST_TIME 72 9381
TEST_TIME 73 9348
TEST_TIME 74 9291
TEST_TIME 75 9277
TEST_TIME 76 9242
TEST_TIME 77 9257
TEST_TIME 78 9187
TEST_TIME 79 9140
TEST_TIME 80 9063
TEST_TIME 81 9053
TEST_TIME 82 9104
TEST_TIME 83 9160
TEST_TIME 84 9184
TEST_TIME 85 9185
TEST_TIME 86 9201
TEST_TIME 87 9211
TEST_TIME 88 9225
TEST_TIME 89 9225
TEST_TIME 90 9259
TEST_TIME 91 9350
TEST_TIME 92 9348
TEST_TIME 93 9367
TEST_TIME 94 9358
TEST_TIME 95 9372
TEST_TIME 96 9394
TEST_TIME 97 9348
TEST_TIME 98 9273
TEST_TIME 99 9311
TEST_TIME 100 9262
TEST_TIME 101 9269
TEST_TIME 102 9238
TEST_TIME 103 9189
TEST_TIME 104 9169
TEST_TIME 105 9142
TEST_TIME 106 9106
TEST_TIME 107 9090
TEST_TIME 108 9107
TEST_TIME 109 9096
TEST_TIME 110 9128
TEST_TIME 111 9125
TEST_TIME 112 9128
TEST_TIME 113 9172
TEST_TIME 114 9181
TEST_TIME 115 9159
TEST_TIME 116 9157
TEST_TIME 117 9163
TEST_TIME 118 9165
TEST_TIME 119 9175
TEST_TIME 120 9100

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-12-2020 19:27:50 to 26-12-2020 19:27:53.

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 1503592 1503592 0 0.00 0 22279 6 0 0
doc_list_biud 1503592 1503592 0 0.00 0 28004 30 0 0
sp_add_invoice_to_stock 4831 4723 108 2.23 29 205773 19458 0 108
sp_cancel_adding_invoice 5825 5825 0 0.00 5 73427 822 0 0
sp_cancel_client_order 1677 1677 0 0.00 4 14507 373 0 0
sp_cancel_customer_reserve 563870 563870 0 0.00 1 26256 65 0 0
sp_cancel_pay_from_customer 635 635 0 0.00 2 10255 100 0 0
sp_cancel_pay_to_supplier 387 387 0 0.00 2 11237 84 0 0
sp_cancel_supplier_invoice 6399 6388 11 0.17 2 19754 829 0 11
sp_cancel_supplier_order 410 410 0 0.00 10 1113595 113223 0 0
sp_cancel_write_off 10576 10576 0 0.00 1 11504 120 0 0
sp_client_order 20173 20173 0 0.00 3 53497 353 0 0
sp_customer_reserve 443455 443455 0 0.00 0 47200 190 0 0
sp_fill_shopping_cart 30711 30711 0 0.00 1 34226 39 0 0
sp_fill_shopping_cart_clo_res 443455 443455 0 0.00 0 16835 15 0 0
sp_get_clo_for_invoice 4723 4723 0 0.00 0 41165 389 0 0
sp_kill_cost_storno 17423 17423 0 0.00 0 5810 56 0 0
sp_kill_qstorno_ret_qs2qd 1145114 1145114 0 0.00 0 26248 35 0 0
sp_kill_qty_storno 603022 603022 0 0.00 0 28003 75 0 0
sp_lock_selected_doc 19855 19855 0 0.00 0 9966 9 0 0
sp_make_cost_storno 26716 26716 0 0.00 0 22277 51 0 0
sp_multiply_rows_for_pdistr 26716 26716 0 0.00 0 6376 28 0 0
sp_multiply_rows_for_qdistr 20173 20173 0 0.00 0 53481 142 0 0
sp_pay_from_customer 6787 6787 0 0.00 4 11213 108 0 0
sp_pay_to_supplier 5653 5653 0 0.00 5 22284 116 0 0
sp_payment_common 12440 12440 0 0.00 1 10426 26 0 0
sp_qd_handle_on_cancel_clo 1677 1677 0 0.00 0 14466 331 0 0
sp_qd_handle_on_invoice_upd_sts 10548 10548 0 0.00 0 28003 336 0 0
sp_qd_handle_on_reserve_upd_sts 9553 9553 0 0.00 0 19103 66 0 0
sp_reserve_write_off 9553 9553 0 0.00 7 19383 190 0 0
sp_supplier_invoice 5327 5327 0 0.00 6 81591 3519 0 0
sp_supplier_order 5234 5234 0 0.00 6 40618 1270 0 0
srv_aggregate_perf_data 88 88 0 0.00 2908 687264 26755 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 897 167216 32437 0 0
srv_find_qd_qs_mism 1046587 1046587 0 0.00 0 13758 6 0 0
srv_make_invnt_saldo 532 532 0 0.00 30 51617 1107 0 0
srv_make_money_saldo 756 756 0 0.00 0 1433 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 166860 367104 240786 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4723 4723 0 0.00 0 14477 157 0 0
t$perf-norm:sp_cancel_adding_invoice 414 414 0 0.00 0 2667 106 0 0
t$perf-norm:sp_cancel_client_order 1677 1677 0 0.00 0 3605 14 0 0
t$perf-norm:sp_cancel_customer_reserve 659 659 0 0.00 0 2483 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 635 635 0 0.00 0 2292 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 387 387 0 0.00 0 3448 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 407 407 0 0.00 0 14399 51 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 23052 1554 0 0
t$perf-norm:sp_cancel_write_off 990 990 0 0.00 0 1139 6 0 0
t$perf-norm:sp_client_order 20173 20173 0 0.00 0 12581 18 0 0
t$perf-norm:sp_customer_reserve 949 949 0 0.00 0 466 2 0 0
t$perf-norm:sp_pay_from_customer 6787 6787 0 0.00 0 8273 11 0 0
t$perf-norm:sp_pay_to_supplier 5653 5653 0 0.00 0 7434 9 0 0
t$perf-norm:sp_reserve_write_off 9553 9553 0 0.00 0 8664 10 0 0
t$perf-norm:sp_supplier_invoice 5327 5327 0 0.00 0 6871 19 0 0
t$perf-norm:sp_supplier_order 5234 5234 0 0.00 0 7763 15 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 86 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 365 8 0 0
t$perf-norm:srv_make_invnt_saldo 532 532 0 0.00 0 1893 26 0 0
t$perf-norm:srv_make_money_saldo 756 756 0 0.00 0 706 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 9662 9446 216 2.23 0 6409 19 0 216
v_all_customers 36722 36722 0 0.00 0 17 1 0 0
v_all_suppliers 29564 29564 0 0.00 0 59 1 0 0
v_all_wares 40346 40346 0 0.00 0 191 1 0 0
v_cancel_adding_invoice 828 828 0 0.00 0 1717 9 0 0
v_cancel_client_order 3354 3354 0 0.00 0 3930 9 0 0
v_cancel_customer_prepayment 1270 1270 0 0.00 0 2610 10 0 0
v_cancel_customer_reserve 1318 1318 0 0.00 0 2595 5 0 0
v_cancel_payment_to_supplier 774 774 0 0.00 0 1538 6 0 0
v_cancel_supplier_invoice 836 814 22 2.63 0 4067 21 0 22
v_cancel_supplier_order 820 820 0 0.00 0 1149 5 0 0
v_cancel_write_off 1980 1980 0 0.00 0 6873 22 0 0
v_max_id_clo_ord 5234 5234 0 0.00 0 145 1 0 0
v_max_id_clo_res 949 949 0 0.00 0 1933 9 0 0
v_max_id_ord_sup 5304 5304 0 0.00 0 4607 4 0 0
v_max_non_paid_invoice 1409 1409 0 0.00 0 345 2 0 0
v_max_non_paid_realizn 3565 3565 0 0.00 0 7656 6 0 0
v_min_id_clo_ord 5234 5234 0 0.00 0 4662 5 0 0
v_min_id_clo_res 949 949 0 0.00 0 3038 11 0 0
v_min_id_ord_sup 5304 5304 0 0.00 0 8945 12 0 0
v_min_non_paid_invoice 5653 5653 0 0.00 0 5492 14 0 0
v_min_non_paid_realizn 6787 6787 0 0.00 0 5437 14 0 0
v_our_firm 10068 10068 0 0.00 0 14 1 0 0
v_reserve_write_off 19106 19106 0 0.00 0 4083 8 0 0
x_lock_depdocs_on_canc_invoice 11806 11806 0 0.00 0 11795 129 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 18823 393 0 0
x_make_qstorno_1000_1200 5234 5234 0 0.00 2 40600 1195 0 0
x_make_qstorno_1200_2000 5327 5327 0 0.00 3 81520 3366 0 0
x_make_qstorno_2100_3300 443455 443455 0 0.00 0 47198 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-12-2020 19:27:54 to 26-12-2020 19:27:58.

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:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:18 19464 8192000000 10276892656 10582102016 1053292576 11.392 82 61 124 0 1077198432 2870448 21035408
16:57:47 17688 8192000000 10336333040 10651729920 1383109968 14.444 100 84 168 0 1415334688 5061088 27163632
16:58:24 24291 8192000000 10385068512 10709471232 1431525296 14.875 100 87 174 1 1466499296 6441824 28532176
16:59:00 15158 8192000000 10410809600 10738638848 1465905248 15.178 100 89 178 0 1502263632 7446432 28911952
16:59:36 15731 8192000000 10433856896 10765623296 1484897264 15.344 100 90 180 0 1522384768 8082048 29405456
17:00:02 22451 8192000000 10453480304 10789441536 1503137808 15.504 100 91 182 1 1541201888 8803152 29260928
17:00:32 15801 8192000000 10460775024 10804621312 1521607568 15.664 100 84 168 3 1557151168 8848384 26695216
17:00:57 18122 8192000000 10509528096 10855292928 1555508368 15.958 100 84 167 1 1590131456 8860784 25762304
17:01:23 19550 8192000000 10529778192 10879950848 1584136976 16.204 100 82 164 2 1618215616 9720336 24358304
17:01:50 10893 8192000000 10545314672 10900246528 1604690464 16.379 100 80 160 0 1638624368 10169744 23764160
17:02:10 20029 8192000000 10569026736 10928742400 1630170768 16.596 100 76 152 0 1662760240 10054272 22535200
17:02:41 13987 8192000000 10601548736 10960982016 1654742816 16.804 100 85 170 1 1691183504 11372960 25067728
17:03:06 8551 8192000000 10619845168 10983321600 1671312304 16.944 100 80 157 2 1705845168 11801360 22731504
17:03:23 14012 8192000000 10641499456 11007176704 1697275024 17.162 100 82 164 1 1733049168 12550624 23223520
17:03:44 9101 8192000000 10657337760 11028557824 1713923024 17.302 100 83 166 3 1750362432 12554000 23885408
17:04:01 6674 8192000000 10669009312 11042639872 1730806016 17.442 100 86 174 0 1768905184 13351920 24747248
17:04:15 6199 8192000000 10675695824 11052609536 1739666768 17.516 100 84 168 2 1777187488 13180816 24339904
17:04:27 5890 8192000000 10689139088 11063537664 1749309232 17.596 100 86 172 2 1786679152 13288048 24081872
17:04:40 6239 8192000000 10703148736 11075772416 1758200800 17.670 100 86 170 1 1796471648 14387888 23882960
17:04:54 4707 8192000000 10712385568 11086061568 1767611216 17.747 100 90 178 1 1806692624 14441712 24639696
17:05:05 4402 8192000000 10716008752 11091607552 1772429408 17.787 100 91 182 0 1813628512 15887104 25312000
17:05:16 4883 8192000000 10720412320 11094364160 1776418352 17.820 100 91 181 2 1816791024 15592432 24780240
17:05:28 4620 8192000000 10720891344 11097567232 1780119024 17.850 100 92 184 1 1821514480 16050832 25344624
17:05:40 4593 8192000000 10726043280 11105230848 1785794544 17.897 100 84 168 0 1824513840 15464640 23254656
17:05:52 3208 8192000000 10741876544 11115950080 1793122272 17.957 100 88 175 0 1831587536 14459696 24005568
17:06:02 2795 8192000000 10741592912 11121401856 1799891488 18.013 100 91 183 0 1839036672 14098544 25046640
17:06:11 8373 8192000000 10735704496 11121258496 1803211728 18.040 100 80 161 1 1839811744 14036368 22563648
17:06:26 5570 8192000000 10741219008 11128913920 1805502656 18.059 100 75 150 2 1839710976 12733696 21474624
17:06:38 2179 8192000000 10765886736 11150495744 1821086400 18.187 100 90 180 1 1858534576 12704688 24743488
17:06:47 2055 8192000000 10775006032 11158392832 1832312864 18.278 100 97 192 1 1872542928 13390000 26840064
17:06:55 2787 8192000000 10778004352 11158798336 1833509472 18.288 100 87 175 2 1871473872 13384464 24579936
17:07:04 1584 8192000000 10786072064 11170758656 1839303840 18.335 100 88 176 0 1877675600 13552800 24818960
17:07:12 2027 8192000000 10787633392 11171364864 1841945328 18.357 100 92 183 1 1880668256 12355552 26367376
17:07:20 1229 8192000000 10788586608 11176853504 1847023376 18.398 100 93 185 1 1888139488 13476432 27639680
17:07:28 1545 8192000000 10795017360 11179360256 1850106896 18.423 100 93 185 1 1889836512 13288192 26441424
17:07:36 1795 8192000000 10789952768 11180257280 1857661072 18.484 100 91 182 2 1895467568 12545040 25261456
17:07:44 2084 8192000000 10796091264 11188510720 1859472368 18.499 100 85 170 3 1896405632 12359168 24574096
17:07:52 1850 8192000000 10800261728 11191427072 1861041568 18.512 100 90 179 1 1899624848 13568448 25014832
17:08:00 1249 8192000000 10811021472 11199778816 1864940256 18.543 100 92 181 0 1904091504 12994096 26157152
17:08:08 1005 8192000000 10806830688 11199475712 1865870800 18.551 100 93 187 1 1905254176 13375584 26007792
17:08:26 30042 8192000000 10775648848 11198132224 1861843056 18.518 100 43 84 2 1881202096 7424672 11934368
17:09:02 7680 8192000000 10803092304 11202469888 1866238080 18.554 100 31 59 2 1880934432 5413136 9283216
17:09:18 8594 8192000000 10788281264 11214245888 1875015968 18.625 100 28 56 2 1889590624 6234528 8340128
17:09:32 6195 8192000000 10784548416 11214467072 1878100512 18.650 100 19 38 1 1889223552 5778016 5345024
17:09:47 5988 8192000000 10793633728 11218563072 1881474288 18.677 100 34 68 1 1899246528 8258240 9514000
17:10:01 4779 8192000000 10784914576 11216908288 1880839392 18.672 100 32 64 1 1896697472 6959936 8898144
17:10:13 10615 8192000000 10781576144 11215339520 1880829264 18.672 100 17 34 1 1891694480 6201024 4664192
17:10:30 9560 8192000000 10779702352 11215790080 1878878944 18.656 100 18 36 1 1889316128 5535952 4901232
17:10:50 13639 8192000000 10784187696 11218092032 1880317376 18.668 100 16 32 0 1891427424 6719824 4390224
17:11:11 13539 8192000000 10795507136 11225698304 1886015056 18.714 100 21 42 1 1897583376 5933216 5635104
17:11:34 9404 8192000000 10790558864 11229310976 1886608304 18.718 100 15 30 0 1897700640 7154560 3937776
17:11:50 59958 8192000000 10822932736 11247747072 1892839136 18.769 100 25 50 0 1905626160 5462784 7324240
17:12:56 21786 8192000000 10804717376 11246845952 1899291776 18.821 100 29 57 3 1912420176 6157504 6970896
17:13:24 6829 8192000000 10809442432 11246292992 1898554736 18.815 100 19 38 1 1909361664 5449920 5357008
17:13:39 5812 8192000000 10813578880 11246505984 1900983168 18.834 100 31 61 2 1916102496 6315952 8803376
17:13:55 4683 8192000000 10816605904 11251015680 1905223248 18.868 100 38 76 0 1922934256 6356976 11354032
17:14:09 4031 8192000000 10819180576 11247726592 1901903472 18.842 100 32 64 3 1918306320 6656992 9745856
17:14:22 9447 8192000000 10814802960 11251458048 1902502512 18.846 100 23 46 2 1915361344 5871664 6987168
17:14:39 6864 8192000000 10832862032 11266072576 1906358512 18.877 100 24 48 1 1923055584 10330672 6366400
17:14:55 8142 8192000000 10819975168 11255201792 1906983792 18.882 100 26 52 2 1920343760 5706176 7653792
17:15:09 9861 8192000000 10825931504 11259854848 1909589568 18.903 100 25 50 1 1922649248 5393792 7665888
17:15:25 11204 8192000000 10826445296 11254476800 1889704560 18.743 99 23 46 0 1902307456 6544448 6058448
17:15:43 7064 8192000000 10817729744 11246620672 1883259968 18.691 99 23 46 0 1896112976 6825616 6027392
17:15:57 4386 8192000000 10821825200 11248168960 1902327296 18.845 100 26 52 0 1915124592 5514176 7283120
17:16:08 15693 8192000000 10805386640 11235328000 1845746560 18.388 97 22 45 2 1857455920 5266944 6442416
17:16:30 7618 8192000000 10803996400 11234975744 1889340896 18.740 100 17 32 1 1899198368 5484016 4373456
17:16:47 26877 8192000000 10770172592 11211124736 1800538384 18.018 95 33 66 1 1815563184 5710976 9313824
17:17:20 43015 8192000000 10766532544 11193696256 1772858896 17.791 95 20 40 1 1783844304 5225168 5760240
17:18:11 11275 8192000000 10738084928 11172114432 1764193776 17.719 95 17 33 2 1774691792 5825184 4672832
17:18:28 6276 8192000000 10747222032 11158499328 1769651488 17.764 96 25 50 1 1784290960 7140480 7498992
17:18:41 5519 8192000000 10718992464 11134521344 1770799216 17.774 97 25 50 0 1785033120 6459792 7774112
17:18:54 6306 8192000000 10730780928 11147112448 1797337616 17.992 99 34 68 1 1813568688 6694496 9536576
17:19:07 6764 8192000000 10683679104 11094163456 1740308768 17.521 97 34 68 0 1756541296 5873728 10358800
17:19:20 7804 8192000000 10675500624 11080556544 1679538352 17.013 94 22 44 1 1692729056 6249808 6940896
17:19:37 7252 8192000000 10710515344 11120005120 1786129376 17.900 100 23 44 2 1799883408 5699328 8054704
17:19:53 6375 8192000000 10691803408 11113652224 1776922064 17.824 99 29 59 1 1791700992 6279808 8499120
17:20:06 7454 8192000000 10704545248 11121983488 1790516576 17.936 100 21 42 1 1802196256 5482672 6197008
17:20:21 10760 8192000000 10701395968 11115974656 1714695504 17.308 95 19 38 0 1725307888 5172224 5440160
17:20:39 8394 8192000000 10700465712 11115696128 1737772512 17.500 97 32 62 1 1752147536 4981360 9393664
17:20:54 6420 8192000000 10730544544 11142963200 1809092832 18.088 100 34 66 1 1824576096 5536752 9946512
17:21:08 6922 8192000000 10725432656 11146735616 1802453600 18.034 99 23 46 2 1815746400 6336880 6955920
17:21:21 9457 8192000000 10721241408 11143499776 1803190784 18.040 99 24 48 1 1815692784 5545488 6956512
17:21:40 11613 8192000000 10721641536 11147120640 1789238848 17.926 98 30 58 3 1803283072 5573376 8470848
17:21:58 65972 8192000000 10772777600 11185868800 1828640480 18.248 99 42 84 5 1846862704 5852560 12369664
17:23:11 7877 8192000000 10765292160 11192586240 1848250048 18.408 100 20 40 0 1859504496 5758320 5496128
17:23:27 9250 8192000000 10782150272 11200364544 1859945856 18.503 100 39 78 1 1882280768 11328896 11006016
17:23:45 4642 8192000000 10786065488 11207372800 1864808944 18.542 100 40 80 0 1882672000 6863808 10999248
17:23:56 3745 8192000000 10792160704 11208564736 1871560400 18.597 100 41 79 1 1889778656 7228720 10989536
17:24:10 10596 8192000000 10785664192 11212570624 1867064304 18.561 100 21 42 1 1879123120 5894880 6163936
17:24:28 6523 8192000000 10792751120 11217428480 1873176480 18.610 100 19 36 1 1883094992 5337568 4580944
17:24:42 5651 8192000000 10808638608 11225346048 1880249008 18.667 100 36 72 0 1897067920 6262256 10556656
17:24:54 9215 8192000000 10792557872 11218440192 1876933536 18.640 100 17 34 2 1887845184 5633824 5277824
17:25:10 9763 8192000000 10788252160 11221585920 1881167472 18.675 100 19 38 0 1892028784 5121824 5739488
17:25:27 9587 8192000000 10815797264 11234263040 1883928256 18.697 100 24 48 0 1900640928 9166256 7546416
17:25:45 8782 8192000000 10805505840 11233271808 1882397168 18.684 100 15 30 2 1892493488 5740272 4356048
17:26:01 9877 8192000000 10786966096 11228954624 1885920944 18.713 100 20 40 3 1897195536 5264640 6009952
17:26:18 10903 8192000000 10816336128 11242278912 1885705392 18.711 100 10 20 0 1898087488 9299536 3082560
17:26:37 25169 8192000000 10806525280 11238346752 1891810368 18.760 100 29 58 4 1905923472 5305088 8808016
17:27:36 72873 8192000000 10855736944 11278716928 1910622704 18.912 100 50 101 2 1931339200 5366656 15349840
17:28:56 10933 8192000000 10868151936 11288145920 1933783232 19.097 100 57 110 2 1959162848 8843856 16535760
17:29:18 19669 8192000000 10872735104 11296776192 1938929856 19.138 100 55 110 3 1964871600 10243936 15697808
17:29:45 31204 8192000000 10870213968 11296968704 1930324016 19.069 99 51 102 1 1955921760 11035168 14562576
17:30:24 9969 8192000000 10877606336 11305320448 1948070752 19.211 100 48 95 1 1972805632 10587760 14147120
17:30:56 8047 8192000000 10880185168 11313909760 1953377904 19.253 100 36 72 1 1972670496 8793200 10499392
17:31:16 22543 8192000000 10887515856 11323817984 1964835856 19.344 100 35 70 2 1984012944 8843664 10333424
17:31:52 11859 8192000000 10893052208 11323392000 1950938064 19.234 99 41 82 0 1973456560 10471792 12046704
17:32:12 19479 8192000000 10906350928 11332157440 1954240432 19.260 99 48 96 2 1980079744 12025424 13813888
17:32:44 12954 8192000000 10902502880 11335823360 1974024064 19.417 100 48 95 2 2000876912 13309712 13543136
17:33:15 5265 8192000000 10905672816 11337674752 1974152512 19.418 100 47 94 0 1999752112 11706896 13892704
17:33:32 10224 8192000000 10927207712 11352584192 1981347088 19.475 100 49 97 0 2007608848 12234784 14026976
17:33:50 2916 8192000000 10938368912 11356147712 1989272656 19.538 100 65 128 1 2021138384 13435472 18430256
17:34:01 9908 8192000000 10936105968 11362496512 1993787888 19.574 100 57 114 2 2025932960 15472128 16672944
17:34:21 9067 8192000000 10924249328 11355709440 1988372352 19.531 100 48 94 1 2018451248 15394064 14684832
17:34:39 16939 8192000000 10934750256 11369066496 1997121120 19.600 100 53 106 0 2032269888 19447504 15701264
17:35:07 27020 8192000000 10954510816 11382710272 2002386304 19.642 100 59 118 1 2040244176 19375248 18482624
17:35:54 5072 8192000000 10945343008 11369312256 1989787392 19.542 99 59 118 0 2031459248 23009968 18661888
17:36:05 4884 8192000000 10965909568 11389902848 2009990400 19.701 100 77 151 2 2055918864 22327952 23600512
17:36:17 7486 8192000000 10963655728 11389026304 2008474032 19.690 100 56 112 1 2047683552 22478816 16730704
17:36:32 2484 8192000000 10970956016 11397709824 2015238176 19.743 100 62 123 2 2060032144 26262224 18531744
17:36:45 6069 8192000000 10962852960 11392536576 1992114048 19.560 99 67 129 1 2039258576 27641584 19502944
17:36:58 3145 8192000000 10958213072 11388166144 1990607152 19.549 99 67 134 0 2039740640 28403088 20730400
17:37:10 9997 8192000000 10954401680 11392262144 2005327360 19.665 100 60 120 0 2051553952 27192384 19034208
17:37:28 3927 8192000000 10958546896 11391885312 2006030224 19.670 100 61 120 0 2050892544 26620592 18241728
17:37:39 2991 8192000000 10951329632 11370684416 1974775232 19.423 98 69 134 3 2022474032 26921760 20777040
17:37:48 3689 8192000000 10971554528 11389046784 1988752336 19.534 99 81 160 4 2040235632 26933568 24549728
17:38:00 4471 8192000000 10958775248 11390234624 2007045008 19.678 100 71 142 0 2055747968 26997536 21705424
17:38:12 2517 8192000000 10956913632 11381428224 1979799920 19.463 99 78 155 1 2031752432 27681168 24271344
17:38:23 4971 8192000000 10961851024 11379392512 1994502448 19.579 100 67 134 0 2039419648 24676832 20240368
17:38:37 13481 8192000000 10957613584 11384799232 2000176832 19.624 100 72 136 2 2045645280 25086176 20382272
17:39:08 4032 8192000000 10962606992 11389300736 1999362928 19.618 100 64 128 1 2048910144 30099216 19448000
17:39:22 7369 8192000000 10971435760 11395080192 2004028160 19.654 100 67 134 0 2055377232 31113248 20235824
17:39:40 5680 8192000000 10968216928 11398385664 2006967408 19.678 100 61 122 0 2057184912 31925152 18292352
17:39:54 8219 8192000000 10978558128 11406602240 2006603536 19.675 100 60 120 0 2060894512 35259152 19031824
17:40:12 8447 8192000000 10987321920 11413876736 2015477968 19.745 100 61 122 1 2070933456 36821184 18634304
17:40:29 2970 8192000000 10995130576 11420684288 2022481248 19.800 100 70 139 0 2077696640 34107904 21107488
17:40:42 4391 8192000000 10974000752 11397509120 2009056496 19.694 100 80 161 2 2069537072 35183600 25296976
17:40:54 4222 8192000000 10996114880 11409018880 2011484528 19.713 100 75 147 2 2071089152 35626816 23977808
17:41:05 2117 8192000000 10992564416 11403386880 2006713040 19.676 100 92 185 2 2071107488 36687984 27706464
17:41:16 3017 8192000000 10966985024 11376635904 1982168624 19.482 99 87 174 0 2046115200 37234000 26712576
17:41:30 3463 8192000000 10972881584 11392589824 1993139904 19.569 100 71 142 1 2054280784 39203088 21937792
17:41:40 5351 8192000000 10990391712 11412500480 2011508080 19.713 100 74 145 0 2073252144 39050512 22693552
17:41:53 2365 8192000000 10977811472 11392106496 1994527824 19.580 99 86 170 0 2059555888 39516496 25511568
17:42:04 1563 8192000000 10984221776 11405279232 1999957328 19.622 100 72 143 1 2066147120 44349632 21840160
17:42:12 5497 8192000000 10936727184 11359932416 1961552272 19.318 99 65 128 5 2022448112 40886288 20009552
17:42:24 8670 8192000000 10952108736 11366293504 1965544752 19.350 99 72 141 1 2029683216 41512240 22626224
17:42:40 7083 8192000000 10958787072 11384430592 1980802992 19.471 100 71 142 1 2047767136 44146768 22817376
17:42:56 6863 8192000000 10977131952 11404017664 1995032848 19.584 100 70 140 0 2064086208 47079872 21973488
17:43:12 5326 8192000000 10945805184 11363786752 1960131664 19.307 99 70 140 1 2027328848 44689808 22507376
17:43:25 3060 8192000000 10967403808 11382824960 1974097696 19.418 100 79 158 1 2045754384 45569872 26086816
17:43:35 2955 8192000000 10954391648 11358822400 1941365840 19.158 98 84 168 2 2015206896 47505856 26335200
17:43:46 4804 8192000000 10952226800 11369537536 1954269376 19.260 99 82 164 0 2028416624 48746160 25401088
17:43:58 4353 8192000000 10945879760 11363860480 1941306704 19.157 99 63 126 0 2011772640 49791104 20674832
17:44:09 2427 8192000000 10940493024 11362054144 1958115280 19.291 100 70 138 2 2026941232 46744320 22081632
17:44:23 1464 8192000000 10967965792 11372957696 1973711936 19.415 100 93 185 0 2051137792 48559984 28865872
17:44:33 2210 8192000000 10971000800 11375022080 1973613376 19.414 100 90 180 1 2049551216 47714432 28223408
17:44:43 4505 8192000000 10932989664 11348561920 1941459648 19.158 99 69 138 0 2011387232 47777664 22149920
17:44:56 6369 8192000000 10950951760 11368669184 1962388704 19.325 100 66 132 2 2033036368 49505968 21141696
17:45:09 3041 8192000000 10984553824 11392741376 1984535312 19.501 100 86 170 2 2062084288 50261312 27287664
17:45:19 5180 8192000000 10993083424 11404529664 1991423376 19.555 100 92 185 0 2073716080 54195136 28097568
17:45:33 3193 8192000000 11000963952 11410722816 1996823728 19.598 100 89 179 1 2078038880 54244640 26970512
17:45:43 891 8192000000 10984029936 11395452928 1983877632 19.495 99 85 170 0 2064776944 53720784 27178528
17:45:51 2309 8192000000 11002181200 11416104960 1997601664 19.604 100 83 166 2 2077676848 54340800 25734384
17:46:01 4947 8192000000 10996193056 11409526784 1990737200 19.550 100 85 170 1 2074116928 55963584 27416144
17:46:14 2980 8192000000 11005716256 11421323264 1999875520 19.622 100 81 162 0 2084116208 57513920 26726768
17:46:26 2226 8192000000 11007960000 11425579008 2002643248 19.644 100 87 172 1 2090396272 59036720 28716304
17:46:36 2004 8192000000 11017657008 11439280128 2009100224 19.694 100 82 164 2 2097406336 61776224 26529888
17:46:47 4914 8192000000 10991191024 11423129600 1983641904 19.494 99 67 134 0 2070941200 64972416 22326880
17:47:01 12516 8192000000 10983056496 11424456704 1995902896 19.590 100 43 86 1 2070912560 59850944 15158720
17:47:28 5557 8192000000 10977461552 11418460160 1986988816 19.520 100 41 83 1 2059455392 58164368 14302208
17:47:46 4388 8192000000 10973858640 11418865664 1996630944 19.596 100 41 82 1 2064653488 54336160 13686384
17:47:57 15482 8192000000 10982673296 11419856896 1988682384 19.533 100 44 88 1 2061376000 56719072 15974544
17:48:22 8778 8192000000 10949529456 11397844992 1955994960 19.274 98 44 88 1 2028737056 57956096 14786000
17:48:50 3182 8192000000 10971323536 11393404928 1963721376 19.336 99 66 129 3 2034899472 50512272 20665824
17:49:02 1964 8192000000 10998160000 11414228992 1999467392 19.619 100 83 164 0 2076986032 51971696 25546944
17:49:10 3198 8192000000 10998905008 11427504128 2002144352 19.640 100 66 132 0 2080348272 57398016 20805904
17:49:24 17915 8192000000 10961027248 11401023488 1950139312 19.228 98 38 76 1 2021395776 58098368 13158096
17:49:55 14787 8192000000 10966269344 11407323136 1968979632 19.377 100 36 72 1 2047011776 65439936 12592208
17:50:16 18593 8192000000 10954598144 11400368128 1963161424 19.331 100 37 74 0 2041264832 64891664 13211744
17:50:46 13880 8192000000 10942867120 11384995840 1909744672 18.905 97 38 75 0 1987581072 64508032 13328368
17:51:29 33936 8192000000 10928984336 11377864704 1952246768 19.244 100 28 56 1 2024434480 61866224 10321488
17:52:15 17129 8192000000 10921584336 11372617728 1929821632 19.065 99 33 66 2 2001595936 59559248 12215056
17:52:55 16237 8192000000 10922308192 11383795712 1930358576 19.070 100 21 42 1 2000995536 61991856 8645104
17:53:23 15687 8192000000 10926958048 11374407680 1919022144 18.979 99 29 58 0 1991453600 61554944 10876512
17:54:24 15254 8192000000 10895879552 11354906624 1946088256 19.195 100 23 46 1 1976380832 23395552 6897024
17:54:45 11234 8192000000 10883776240 11344523264 1946077680 19.195 100 22 44 1 1967993856 15511168 6405008
17:55:11 24922 8192000000 10875630464 11329810432 1935397232 19.110 99 40 80 0 1959331760 12678480 11256048
17:56:46 76969 8192000000 10872405376 11342520320 1947647088 19.208 100 14 28 0 1962726896 11070480 4009328
17:58:14 30570 8192000000 10873978992 11339309056 1932984016 19.091 99 14 28 1 1950993824 14355920 3653888
17:58:54 29756 8192000000 10834641920 11290882048 1867245472 18.562 96 15 29 1 1882232816 10430256 4557088
17:59:31 103319 8192000000 10878482768 11338379264 1934409440 19.102 99 28 58 1 1952385440 10734832 7241168
18:01:21 57433 8192000000 10891476176 11349204992 1942556080 19.167 99 13 26 1 1961542272 16147296 2838896
18:03:28 34052 8192000000 10895276448 11344203776 1941357872 19.158 99 17 34 1 1965923456 19270992 5294592
18:04:09 104806 8192000000 10884225664 11351109632 1944877216 19.186 99 17 33 0 1962216592 13051456 4287920
18:06:00 125943 8192000000 10903251344 11362222080 1971799104 19.400 100 16 32 0 1987325648 10734400 4792144
18:08:18 80763 8192000000 10907238000 11387088896 1978898384 19.456 100 24 45 3 1999978752 14253872 6826496
18:09:52 84769 8192000000 10907834976 11384328192 1986194992 19.514 100 6 12 1 1999874960 12163616 1516352
18:11:27 19833 8192000000 10917389280 11384606720 1996149296 19.592 100 19 38 1 2009187216 7501888 5536032
18:11:56 24593 8192000000 10936806736 11400343552 2002797520 19.645 100 32 62 1 2022525472 10689920 9038032
18:12:28 26037 8192000000 10941483936 11402989568 2008450208 19.689 100 30 60 0 2031562240 14244128 8867904
18:13:09 42433 8192000000 10939666752 11399024640 1973245664 19.411 98 50 101 1 2003499008 15858416 14394928
18:14:10 62784 8192000000 10928753600 11397656576 1998584736 19.612 100 17 34 0 2019894688 16346944 4963008
18:15:19 51215 8192000000 10926744112 11415195648 1996662816 19.596 100 9 18 1 2018720416 18917328 3140272
18:16:19 69182 8192000000 10915008320 11390943232 1964577120 19.342 98 12 24 0 1988180896 20147568 3456208
18:18:00 81602 8192000000 10924398016 11411488768 1997359504 19.602 100 17 34 2 2015944144 13285904 5298736
18:19:28 53446 8192000000 10921150656 11411038208 2003211376 19.648 100 17 34 2 2030299408 21554752 5533280
18:20:29 82802 8192000000 10917948944 11413143552 1980198496 19.466 99 10 20 0 2005654432 22629888 2826048
18:22:18 49350 8192000000 10908231296 11403292672 1987448944 19.524 100 7 14 0 2004808400 15802528 1556928
18:23:13 49679 8192000000 10916864800 11391016960 1975750960 19.431 99 14 28 1 1987307184 7740816 3815408
18:24:13 59491 8192000000 10923092896 11407847424 2002882624 19.645 100 18 36 0 2020575840 12900720 4792496
18:25:18 50345 8192000000 10920115056 11389079552 1958218608 19.292 98 16 33 1 1972401344 9925824 4256912
18:26:15 42492 8192000000 10939000848 11397857280 1959850400 19.305 98 29 58 2 1976328832 8550800 7927632
18:27:06 23416 8192000000 10916326144 11377782784 1949129008 19.220 98 36 72 1 1974964400 15976256 9859136
18:27:37 54777 8192000000 10937086928 11390767104 1927497248 19.047 97 29 58 3 1954976240 19795440 7683552
18:29:06 79509 8192000000 10894648912 11387527168 1920860128 18.994 97 14 28 0 1947718800 23033248 3825424
18:30:38 104067 8192000000 10896308000 11376140288 1914184880 18.940 97 7 14 0 1928490000 12679104 1626016
18:32:28 115883 8192000000 10903650800 11380137984 1865294096 18.546 94 15 30 0 1884833184 15560720 3978368
18:34:30 116795 8192000000 10905748240 11386802176 1871440048 18.596 95 12 23 3 1889370112 14940560 2989504
18:37:07 113495 8192000000 10876640768 11335315456 1777543312 17.829 90 13 26 0 1793241104 11987504 3710288
18:39:07 98944 8192000000 10875720240 11338244096 1896546048 18.799 97 30 60 0 1919637632 13730176 9361408
18:41:14 44793 8192000000 10877966480 11337695232 1933836800 19.098 99 28 55 0 1951841984 10098144 7907040
18:42:06 40833 8192000000 10884308992 11349479424 1951971344 19.242 100 22 44 0 1971289776 13305264 6013168
18:42:54 35458 8192000000 10872015184 11323424768 1916454320 18.958 98 22 44 1 1933470320 10395552 6620448
18:43:47 86947 8192000000 10810512880 11279581184 1745941312 17.568 90 11 22 0 1764877696 15952416 2983968
18:45:28 46942 8192000000 10858589744 11307675648 1893079232 18.771 99 21 43 4 1915027632 15932832 6015568
18:46:21 59383 8192000000 10837735248 11302354944 1866808256 18.558 97 18 37 2 1888759280 17049520 4901504
18:48:08 53796 8192000000 10837022096 11306741760 1880927120 18.673 98 10 20 0 1905032896 21179216 2926560
18:49:58 86296 8192000000 10862373504 11315859456 1862704016 18.525 97 18 36 0 1887843040 19679344 5459680
18:51:31 27769 8192000000 10848869872 11312078848 1870856656 18.591 97 14 27 2 1884603744 9910912 3836176
18:52:06 42846 8192000000 10859061200 11310305280 1906514208 18.879 99 23 46 0 1922660080 9334896 6810976
18:53:01 69603 8192000000 10866853680 11330744320 1937805168 19.129 100 19 38 1 1953723248 10113296 5804784
18:54:21 69464 8192000000 10878181504 11341062144 1915132656 18.948 98 23 46 0 1933920448 12444704 6343088
18:55:37 42737 8192000000 10868490400 11319599104 1890918736 18.753 97 26 53 0 1913845168 15591200 7335232
18:56:28 39988 8192000000 10878518080 11340288000 1940679040 19.152 100 30 60 0 1973493536 24675360 8139136
18:57:16 61723 8192000000 10905676464 11361214464 1949167616 19.220 100 27 55 1 1968744656 12150816 7426224
18:58:26 101515 8192000000 10912197552 11370999808 1951611472 19.239 99 20 40 1 1971120448 14720416 4788560
19:00:23 39336 8192000000 10908949904 11365502976 1956413968 19.278 99 26 51 3 1975458064 11723440 7320656
19:01:13 18213 8192000000 10923010576 11371085824 1977429152 19.444 100 34 68 1 1997825664 10789104 9607408
19:01:42 96061 8192000000 10913964096 11374481408 1930908144 19.074 97 33 66 0 1951629776 11492080 9229552
19:03:24 110511 8192000000 10910572784 11369619456 1925709600 19.033 97 18 36 0 1941716784 10777728 5229456
19:05:23 113241 8192000000 10895782832 11372806144 1926582832 19.040 97 38 75 0 1951202464 13434064 11185568
19:07:32 27892 8192000000 10892952064 11375554560 1963239056 19.332 100 8 16 0 1983798000 18351248 2207696
19:08:09 40729 8192000000 10879621296 11361828864 1962718672 19.328 100 29 55 2 1983341072 13314448 7307952
19:08:57 44511 8192000000 10893584704 11371806720 1971141952 19.395 100 9 18 1 1983661920 10173760 2346208
19:09:48 59052 8192000000 10894120720 11370864640 1962280256 19.324 99 11 22 0 1974801264 9528576 2992432
19:10:53 53164 8192000000 10878638880 11343855616 1943825808 19.177 98 14 28 0 1957359072 9502800 4030464
19:12:18 59288 8192000000 10898524112 11376467968 1980542128 19.469 100 25 50 0 2001458016 13336592 7579296
19:14:05 57953 8192000000 10897820352 11373932544 1962568112 19.326 99 15 30 1 1978311808 11442736 4300960
19:15:10 167216 8192000000 10910664224 11391172608 1950317760 19.229 98 6 11 0 1963060128 11665488 1076880
19:18:09 31525 8192000000 10933437856 11382718464 1958275856 19.292 98 31 61 4 1973693952 6823456 8594640
19:18:49 50037 8192000000 10924411968 11369226240 1932005616 19.083 97 29 59 0 1948340976 8789024 7546336
19:19:46 34794 8192000000 10903706944 11365634048 1921364960 18.998 97 22 44 2 1935199040 7923328 5910752
19:20:27 52400 8192000000 10901174448 11374342144 1958398192 19.293 99 19 37 1 1974500464 11143632 4958640
19:21:26 48649 8192000000 10910728256 11357380608 1929459888 19.063 98 38 77 0 1948284992 8154608 10670496
19:22:22 33540 8192000000 10889017888 11344367616 1909805392 18.905 97 27 54 1 1926228768 8701328 7722048
19:23:02 24565 8192000000 10921006864 11375161344 1968202400 19.371 100 33 66 0 1987939488 10651504 9085584
19:23:34 21196 8192000000 10886714640 11336282112 1907601744 18.887 97 38 76 0 1928234688 10180400 10452544
19:24:06 17300 8192000000 10888930384 11341455360 1947999408 19.211 100 29 58 2 1965787040 9748576 8039056
19:24:29 33473 8192000000 10867347856 11318611968 1888754496 18.736 97 36 72 0 1910932944 12363456 9814992
19:25:09 79876 8192000000 10881617120 11339771904 1880328960 18.668 96 26 51 3 1896294800 8531152 7434688
19:26:36 38219 8192000000 9258483520 9540284416 367752928 4.296 19 6 12 1 371878736 2273264 1852544

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 26-12-2020 19:28:00 to 26-12-2020 19:28:32.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-12-2020 19:28:33 to 26-12-2020 19:28:35.

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          236789
MON$OLDEST_ACTIVE               236790
MON$OLDEST_SNAPSHOT             236790
MON$NEXT_TRANSACTION            236790
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                       2025888
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:407: 
:408: mscs-test-161.budzdorov.ru    Sat Dec 26 19:27:20 2020
:409:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:410: 
:411: 
:412: mscs-test-161.budzdorov.ru    Sat Dec 26 19:27:20 2020
:413:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:414: 
--- end of diff output ---

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

26.12.20 19:28:36. 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-26 19:28:38 No severe PSQL-related problems occured
26.12.20 19:28:39. End of report.