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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17803740 kB
MemAvailable 31647264 kB
Buffers 0 kB
Cached 13915244 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-07 19:27:23
DTS_END                         2021-03-07 19:27:23.5680
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50974
TRN_ID                          227007
ATT_ID                          584
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: 9051.07 23950 1086128
customer order: creation 157.83 340 18940
customer order: refuse 13.57 353 1628
order to supplier: creation 42.41 1305 5089
order to supplier: removal 3.38 102591 406
invoice (draft): creation 42.57 3435 5108
invoice (draft): removal 51.97 729 6236
invoice accept: apply 39.59 19041 4751
invoice accept: cancel 47.41 742 5689
customer reserve: creation 3713.03 186 445564
customer reserve: removal 4654.58 59 558550
realization accept: apply 77.24 188 9269
realization accept: cancel 87.34 98 10481
payment from customer: creation 54.67 128 6560
payment from customer: removal 5.48 83 657
payment to supplier: creation 45.73 149 5488
payment to supplier: removal 3.05 95 366
service: total inventory turnovers 4.28 1091 513
service: total monetary turnovers 6.16 22 739
service: aggregate perf. data 0.75 22856 90
service: refresh index statistics 0.03 325510 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 07-03-2021 19:28:57 to 07-03-2021 19:29:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3270
TEST_TIME 2 4677
TEST_TIME 3 5856
TEST_TIME 4 5607
TEST_TIME 5 5927
TEST_TIME 6 5511
TEST_TIME 7 6118
TEST_TIME 8 5896
TEST_TIME 9 6267
TEST_TIME 10 6313
TEST_TIME 11 6675
TEST_TIME 12 6634
TEST_TIME 13 6985
TEST_TIME 14 7400
TEST_TIME 15 7367
TEST_TIME 16 7575
TEST_TIME 17 7905
TEST_TIME 18 8318
TEST_TIME 19 8322
TEST_TIME 20 8664
TEST_TIME 21 8881
TEST_TIME 22 9429
TEST_TIME 23 9463
TEST_TIME 24 9946
TEST_TIME 25 10080
TEST_TIME 26 10486
TEST_TIME 27 10765
TEST_TIME 28 10880
TEST_TIME 29 10673
TEST_TIME 30 10843
TEST_TIME 31 10616
TEST_TIME 32 10411
TEST_TIME 33 10206
TEST_TIME 34 10101
TEST_TIME 35 10001
TEST_TIME 36 10125
TEST_TIME 37 9959
TEST_TIME 38 9824
TEST_TIME 39 9795
TEST_TIME 40 9837
TEST_TIME 41 9719
TEST_TIME 42 9556
TEST_TIME 43 9500
TEST_TIME 44 9404
TEST_TIME 45 9400
TEST_TIME 46 9458
TEST_TIME 47 9306
TEST_TIME 48 9301
TEST_TIME 49 9295
TEST_TIME 50 9307
TEST_TIME 51 9218
TEST_TIME 52 9270
TEST_TIME 53 9340
TEST_TIME 54 9369
TEST_TIME 55 9362
TEST_TIME 56 9392
TEST_TIME 57 9424
TEST_TIME 58 9403
TEST_TIME 59 9496
TEST_TIME 60 9475
TEST_TIME 61 9427
TEST_TIME 62 9434
TEST_TIME 63 9362
TEST_TIME 64 9255
TEST_TIME 65 9238
TEST_TIME 66 9247
TEST_TIME 67 9217
TEST_TIME 68 9138
TEST_TIME 69 9054
TEST_TIME 70 9057
TEST_TIME 71 9082
TEST_TIME 72 9084
TEST_TIME 73 9079
TEST_TIME 74 9024
TEST_TIME 75 9069
TEST_TIME 76 9088
TEST_TIME 77 9096
TEST_TIME 78 9134
TEST_TIME 79 9109
TEST_TIME 80 9099
TEST_TIME 81 9227
TEST_TIME 82 9243
TEST_TIME 83 9230
TEST_TIME 84 9229
TEST_TIME 85 9193
TEST_TIME 86 9234
TEST_TIME 87 9154
TEST_TIME 88 9147
TEST_TIME 89 9091
TEST_TIME 90 9068
TEST_TIME 91 9020
TEST_TIME 92 8982
TEST_TIME 93 8961
TEST_TIME 94 9073
TEST_TIME 95 9087
TEST_TIME 96 9056
TEST_TIME 97 9070
TEST_TIME 98 9108
TEST_TIME 99 9114
TEST_TIME 100 9176
TEST_TIME 101 9139
TEST_TIME 102 9123
TEST_TIME 103 9168
TEST_TIME 104 9213
TEST_TIME 105 9221
TEST_TIME 106 9270
TEST_TIME 107 9253
TEST_TIME 108 9286
TEST_TIME 109 9251
TEST_TIME 110 9226
TEST_TIME 111 9221
TEST_TIME 112 9182
TEST_TIME 113 9164
TEST_TIME 114 9149
TEST_TIME 115 9124
TEST_TIME 116 9099
TEST_TIME 117 9086
TEST_TIME 118 9068
TEST_TIME 119 9067
TEST_TIME 120 9055

Performance per minute, chart


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

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 1496838 1496838 0 0.00 0 24301 6 0 0
doc_list_biud 1496838 1496838 0 0.00 0 89175 28 0 0
sp_add_invoice_to_stock 4833 4751 82 1.69 34 249692 19041 0 82
sp_cancel_adding_invoice 5689 5689 0 0.00 6 68867 743 0 0
sp_cancel_client_order 1628 1628 0 0.00 4 11966 354 0 0
sp_cancel_customer_reserve 558550 558550 0 0.00 1 89177 59 0 0
sp_cancel_pay_from_customer 657 657 0 0.00 2 5524 84 0 0
sp_cancel_pay_to_supplier 366 366 0 0.00 3 4947 96 0 0
sp_cancel_supplier_invoice 6245 6236 9 0.14 1 11902 729 0 9
sp_cancel_supplier_order 406 406 0 0.00 8 1002450 102591 0 0
sp_cancel_write_off 10481 10481 0 0.00 1 6717 99 0 0
sp_client_order 18940 18940 0 0.00 4 21754 340 0 0
sp_customer_reserve 445564 445564 0 0.00 0 110406 187 0 0
sp_fill_shopping_cart 29128 29128 0 0.00 1 34782 41 0 0
sp_fill_shopping_cart_clo_res 445554 445554 0 0.00 0 18148 14 0 0
sp_get_clo_for_invoice 4741 4741 0 0.00 0 27811 360 0 0
sp_kill_cost_storno 17193 17193 0 0.00 0 10272 57 0 0
sp_kill_qstorno_ret_qs2qd 1134223 1134223 0 0.00 0 89171 32 0 0
sp_kill_qty_storno 597000 597000 0 0.00 0 89173 69 0 0
sp_lock_selected_doc 19437 19437 0 0.00 0 7511 5 0 0
sp_make_cost_storno 26058 26058 0 0.00 0 24286 56 0 0
sp_multiply_rows_for_pdistr 26058 26058 0 0.00 0 7718 29 0 0
sp_multiply_rows_for_qdistr 18940 18940 0 0.00 0 10406 164 0 0
sp_pay_from_customer 6560 6560 0 0.00 4 20505 129 0 0
sp_pay_to_supplier 5488 5488 0 0.00 4 24319 150 0 0
sp_payment_common 12048 12048 0 0.00 1 15922 32 0 0
sp_qd_handle_on_cancel_clo 1628 1628 0 0.00 0 11957 323 0 0
sp_qd_handle_on_invoice_upd_sts 10430 10430 0 0.00 0 17842 312 0 0
sp_qd_handle_on_reserve_upd_sts 9269 9269 0 0.00 0 16047 71 0 0
sp_reserve_write_off 9269 9269 0 0.00 6 17794 189 0 0
sp_supplier_invoice 5108 5108 0 0.00 6 113501 3436 0 0
sp_supplier_order 5089 5089 0 0.00 5 36501 1306 0 0
srv_aggregate_perf_data 90 90 0 0.00 3214 377042 22856 0 0
srv_fill_mon_cache_memory 146 146 0 0.00 1611 164992 36835 0 0
srv_find_qd_qs_mism 1040393 1040393 0 0.00 0 11174 5 0 0
srv_make_invnt_saldo 513 513 0 0.00 43 79360 1092 0 0
srv_make_money_saldo 739 739 0 0.00 1 883 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 152897 422970 325510 0 0
t$perf-abend:sp_add_invoice_to_stock 82 82 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4752 4752 0 0.00 0 13359 212 0 0
t$perf-norm:sp_cancel_adding_invoice 390 390 0 0.00 1 9503 144 0 0
t$perf-norm:sp_cancel_client_order 1628 1628 0 0.00 0 5400 19 0 0
t$perf-norm:sp_cancel_customer_reserve 667 667 0 0.00 0 1084 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 657 657 0 0.00 0 642 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 366 366 0 0.00 0 423 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 395 395 0 0.00 0 487 12 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 17426 1519 0 0
t$perf-norm:sp_cancel_write_off 919 919 0 0.00 0 1618 7 0 0
t$perf-norm:sp_client_order 18940 18940 0 0.00 0 17652 20 0 0
t$perf-norm:sp_customer_reserve 889 889 0 0.00 0 6482 21 0 0
t$perf-norm:sp_pay_from_customer 6560 6560 0 0.00 0 8443 15 0 0
t$perf-norm:sp_pay_to_supplier 5488 5488 0 0.00 0 8523 14 0 0
t$perf-norm:sp_reserve_write_off 9269 9269 0 0.00 0 9660 18 0 0
t$perf-norm:sp_supplier_invoice 5108 5108 0 0.00 0 7275 22 0 0
t$perf-norm:sp_supplier_order 5089 5089 0 0.00 0 3830 17 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 467 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 146 146 0 0.00 0 760 15 0 0
t$perf-norm:srv_make_invnt_saldo 513 513 0 0.00 0 3563 31 0 0
t$perf-norm:srv_make_money_saldo 739 739 0 0.00 0 3767 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 69 20 0 0
v_add_invoice_to_stock 9644 9480 164 1.70 0 5937 17 0 164
v_all_customers 34556 34556 0 0.00 0 15 1 0 0
v_all_suppliers 28338 28338 0 0.00 0 114 1 0 0
v_all_wares 37880 37880 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 780 780 0 0.00 0 2877 11 0 0
v_cancel_client_order 3256 3256 0 0.00 0 2929 10 0 0
v_cancel_customer_prepayment 1314 1314 0 0.00 0 3893 10 0 0
v_cancel_customer_reserve 1334 1334 0 0.00 0 3891 10 0 0
v_cancel_payment_to_supplier 732 732 0 0.00 0 3945 9 0 0
v_cancel_supplier_invoice 808 790 18 2.22 0 1117 15 0 18
v_cancel_supplier_order 812 812 0 0.00 0 797 4 0 0
v_cancel_write_off 1838 1838 0 0.00 0 4858 15 0 0
v_max_id_clo_ord 5087 5087 0 0.00 0 549 1 0 0
v_max_id_clo_res 889 889 0 0.00 0 2292 12 0 0
v_max_id_ord_sup 5101 5101 0 0.00 0 5465 4 0 0
v_max_non_paid_invoice 1507 1507 0 0.00 0 1056 2 0 0
v_max_non_paid_realizn 3570 3570 0 0.00 0 1450 3 0 0
v_min_id_clo_ord 5087 5087 0 0.00 0 5010 6 0 0
v_min_id_clo_res 889 889 0 0.00 0 3775 14 0 0
v_min_id_ord_sup 5101 5101 0 0.00 0 5888 5 0 0
v_min_non_paid_invoice 5488 5488 0 0.00 0 15919 26 0 0
v_min_non_paid_realizn 6560 6560 0 0.00 0 13057 20 0 0
v_our_firm 9304 9304 0 0.00 0 15 1 0 0
v_reserve_write_off 18538 18538 0 0.00 0 3891 6 0 0
x_lock_depdocs_on_canc_invoice 11530 11530 0 0.00 0 13589 130 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 9861 408 0 0
x_make_qstorno_1000_1200 5089 5089 0 0.00 2 36408 1231 0 0
x_make_qstorno_1200_2000 5108 5108 0 0.00 2 107682 3284 0 0
x_make_qstorno_2100_3300 445564 445564 0 0.00 0 110403 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-03-2021 19:29:05 to 07-03-2021 19:29:09.

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:26 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:33 28158 8192000000 10272651696 10583420928 1024336544 11.114 78 64 128 0 1047883680 2939120 20608016
16:58:08 31252 8192000000 10335983184 10654875648 1387823392 14.486 100 86 172 0 1421328288 5084736 28420160
16:58:49 22389 8192000000 10367929968 10689409024 1424499104 14.813 100 86 172 0 1459766880 6386080 28881696
16:59:24 16231 8192000000 10421978272 10749644800 1473524304 15.245 100 87 174 1 1508406688 7122512 27759872
16:59:55 15743 8192000000 10433794624 10766049280 1488184768 15.373 100 90 180 1 1529544768 12432000 28928000
17:00:17 18092 8192000000 10443917376 10775007232 1500973984 15.485 100 94 188 1 1540220048 8878080 30367984
17:00:45 17221 8192000000 10449657776 10790256640 1513108784 15.590 100 86 172 1 1549903744 9192864 27602096
17:01:11 18421 8192000000 10481980656 10821726208 1527239328 15.713 100 85 170 0 1563905792 9458768 27207696
17:01:39 16993 8192000000 10507987504 10850574336 1557136656 15.972 100 87 174 0 1594497040 9979472 27380912
17:02:14 16508 8192000000 10524899872 10879475712 1582158864 16.187 100 77 154 1 1616541376 10566864 23815648
17:02:39 9339 8192000000 10548137008 10902544384 1605002784 16.382 100 75 150 0 1637756144 10122192 22631168
17:02:57 10617 8192000000 10578353856 10937294848 1628165152 16.579 100 78 156 0 1661762112 10880592 22716368
17:03:16 13745 8192000000 10608494176 10967592960 1661346480 16.860 100 86 172 1 1698399696 11951120 25102096
17:03:38 10599 8192000000 10619958192 10986631168 1678720736 17.007 100 78 154 3 1713628112 11926304 22981072
17:03:58 9345 8192000000 10639235280 11005165568 1697273984 17.162 100 90 179 1 1736711840 12972720 26465136
17:04:16 8375 8192000000 10644370816 11019243520 1711596496 17.282 100 77 154 0 1747078768 12688944 22793328
17:04:37 8296 8192000000 10668771440 11036663808 1724677792 17.391 100 85 170 3 1762660960 13637360 24345808
17:04:54 7335 8192000000 10683809088 11055591424 1738032432 17.502 100 86 173 1 1776977360 14662320 24282608
17:05:09 6440 8192000000 10684571152 11057963008 1748629328 17.590 100 87 175 3 1787669648 14268448 24771872
17:05:22 7220 8192000000 10700111808 11075665920 1755404288 17.646 100 86 172 0 1794760000 14952400 24403312
17:05:36 3815 8192000000 10711140016 11083350016 1762047264 17.701 100 86 172 2 1801676144 15700256 23928624
17:05:47 5964 8192000000 10714409680 11089567744 1772767472 17.790 100 87 173 1 1811570656 15016768 23786416
17:06:00 5002 8192000000 10725400432 11100430336 1777457584 17.829 100 76 152 2 1813065056 13625984 21981488
17:06:13 2096 8192000000 10724619664 11102355456 1784201680 17.884 100 86 170 2 1822550336 14931728 23416928
17:06:23 3024 8192000000 10740910480 11118796800 1789875600 17.931 100 85 169 3 1827318816 13903328 23539888
17:06:33 9430 8192000000 10730439232 11117670400 1794494768 17.969 100 79 154 2 1828550944 11523552 22532624
17:06:51 4523 8192000000 10746907728 11130155008 1801498976 18.026 100 77 153 0 1833998096 11974464 20524656
17:07:03 3526 8192000000 10770773776 11156172800 1823141744 18.203 100 81 163 0 1862302736 16876144 22284848
17:07:14 3498 8192000000 10772265024 11152801792 1827354176 18.238 100 88 176 1 1865517536 13752736 24410624
17:07:23 2768 8192000000 10779559488 11165900800 1837152112 18.318 100 93 182 4 1876571696 13879904 25539680
17:07:33 3411 8192000000 10779584432 11167469568 1838861792 18.332 100 83 164 2 1875929456 13599600 23468064
17:07:43 2338 8192000000 10785680080 11173240832 1847281968 18.400 100 93 186 1 1888019552 14464016 26273568
17:07:51 2665 8192000000 10791552496 11178340352 1856430976 18.474 100 92 180 2 1893657472 11775984 25450512
17:08:01 2228 8192000000 10803662672 11190673408 1861797600 18.518 100 91 178 1 1902882800 16304064 24781136
17:08:10 2610 8192000000 10803812560 11189747712 1861735568 18.517 100 92 186 0 1899971024 12160464 26074992
17:08:19 2540 8192000000 10809325088 11196960768 1866154688 18.553 100 89 176 2 1903694352 12524768 25014896
17:08:28 2410 8192000000 10813974368 11200569344 1869617680 18.581 100 98 196 1 1910694384 13759824 27316880
17:08:36 2075 8192000000 10820619536 11208503296 1872964064 18.608 100 98 196 1 1914508112 13130608 28413440
17:08:45 1737 8192000000 10816939584 11207856128 1874410176 18.620 100 98 196 2 1916463552 14075248 27978128
17:08:53 2438 8192000000 10818367120 11208224768 1874123760 18.618 100 91 183 1 1912119776 12423584 25572432
17:09:02 1787 8192000000 10824696640 11214680064 1879090736 18.658 100 93 187 0 1919109568 13380112 26638720
17:09:10 45269 8192000000 10810718960 11212468224 1876984160 18.641 100 75 149 3 1908957248 11346048 20627040
17:10:01 1600 8192000000 10829510288 11223166976 1887364016 18.725 100 92 186 0 1925563440 12317968 25881456
17:10:09 2866 8192000000 10805765696 11220824064 1882701856 18.687 100 70 140 0 1915291888 12741040 19848992
17:10:18 5632 8192000000 10796180256 11216609280 1882418960 18.685 100 45 91 0 1904405312 9499872 12486480
17:10:31 5260 8192000000 10790290064 11214983168 1878715824 18.655 100 34 68 2 1896746496 8675424 9355248
17:10:45 8928 8192000000 10791287280 11218419712 1882016368 18.681 100 33 64 0 1897963584 6369952 9577264
17:11:07 5660 8192000000 10794455056 11222794240 1886683664 18.719 100 29 58 1 1902839920 8091744 8064512
17:11:22 8043 8192000000 10794081952 11226853376 1888413520 18.733 100 19 38 2 1900045552 6516192 5115840
17:11:39 13422 8192000000 10797242784 11230785536 1893668816 18.775 100 28 55 4 1907901888 6569776 7663296
17:11:58 6711 8192000000 10805993504 11234594816 1896617136 18.799 100 26 52 1 1910517920 6337216 7563568
17:12:12 8927 8192000000 10818257088 11228504064 1896787840 18.800 100 26 52 2 1911374688 6607536 7979312
17:12:32 5322 8192000000 10813521456 11238608896 1901544192 18.839 100 34 68 0 1917819312 6220048 10055072
17:12:43 16618 8192000000 10802885680 11243204608 1902228800 18.844 100 18 36 2 1912872496 5768112 4875584
17:13:06 45077 8192000000 10849767056 11258617856 1917927232 18.970 100 61 124 3 1941640480 6829024 16884224
17:14:01 6071 8192000000 10809231136 11250413568 1906121648 18.876 100 21 44 0 1918374432 6392208 5860576
17:14:14 5002 8192000000 10829662880 11261317120 1911668320 18.920 100 35 68 2 1933277040 12318256 9290464
17:14:28 4332 8192000000 10831042464 11259109376 1913841280 18.937 100 38 76 0 1932206656 7944240 10421136
17:14:42 8599 8192000000 10828910896 11258449920 1913486992 18.935 100 26 51 0 1926971824 6157200 7327632
17:14:57 6276 8192000000 10828420640 11250548736 1893592288 18.775 99 28 55 2 1907190224 5276944 8320992
17:15:09 5639 8192000000 10827000496 11255070720 1907244384 18.885 100 28 56 2 1921069248 6366576 7458288
17:15:23 7560 8192000000 10831717264 11257085952 1909062544 18.899 100 26 53 2 1922584176 5792288 7729344
17:15:42 5980 8192000000 10823169360 11257790464 1915605600 18.952 100 33 66 3 1931510880 6285680 9619600
17:15:54 10366 8192000000 10816718256 11254218752 1910582752 18.911 100 27 51 2 1922857040 5559840 6714448
17:16:11 6283 8192000000 10822758208 11256975360 1912479216 18.927 100 19 38 1 1924062544 5972992 5610336
17:16:24 7458 8192000000 10812229328 11248873472 1893124704 18.771 99 27 54 4 1907174000 5780640 8268656
17:16:39 9865 8192000000 10824488800 11254521856 1892796112 18.768 99 20 40 2 1904052192 5199808 6056272
17:16:57 6800 8192000000 10801975680 11234082816 1866678256 18.557 98 28 56 1 1881067456 6270736 8118464
17:17:11 11014 8192000000 10823574256 11241103360 1878728688 18.655 99 41 79 2 1901214048 9523296 12962064
17:17:28 53282 8192000000 10822031072 11215060992 1816537024 18.149 96 60 121 1 1839497600 5338192 17622384
17:18:27 10921 8192000000 10755121776 11185369088 1799359632 18.009 96 23 46 2 1812607440 6859200 6388608
17:18:44 5343 8192000000 10760930048 11183067136 1819224784 18.171 98 32 65 1 1834850576 5862848 9762944
17:18:56 4346 8192000000 10756524432 11174088704 1837274976 18.319 99 36 72 2 1853843872 5899504 10669392
17:19:09 4663 8192000000 10775768176 11195273216 1841015920 18.349 99 45 90 0 1860519648 6970240 12533488
17:19:21 5369 8192000000 10762160864 11171561472 1784146848 17.884 96 33 65 0 1800137360 6865488 9125024
17:19:33 4153 8192000000 10742504576 11162169344 1774689344 17.806 96 33 66 3 1790579248 5896960 9992944
17:19:45 9895 8192000000 10740866656 11168702464 1832826640 18.282 100 35 70 1 1849938256 7008176 10103440
17:20:02 5842 8192000000 10753847584 11163340800 1765449936 17.729 96 41 82 2 1783373584 5118800 12804848
17:20:20 7233 8192000000 10698823184 11109707776 1767902960 17.750 98 29 58 1 1782064240 6159568 8001712
17:20:35 6121 8192000000 10688379072 11092299776 1763618880 17.714 98 23 46 0 1775905792 5615776 6671136
17:20:51 5874 8192000000 10712546016 11123408896 1778297888 17.835 99 34 68 0 1794155376 6363600 9493888
17:21:07 8989 8192000000 10686584800 11098996736 1730052160 17.436 96 23 46 2 1742381888 5427776 6901952
17:21:22 8094 8192000000 10693289904 11107700736 1735591968 17.482 97 24 44 2 1748497776 5322528 7583280
17:21:36 56038 8192000000 10735850032 11123101696 1750820112 17.608 97 55 111 7 1772058576 5154784 16083680
17:22:38 8172 8192000000 10700885056 11120787456 1774570112 17.805 99 24 48 2 1788638608 7043456 7025040
17:22:58 6660 8192000000 10723719584 11139133440 1807222288 18.073 100 37 75 4 1824681792 7519376 9940128
17:23:13 5654 8192000000 10714573392 11140685824 1798697456 18.003 99 20 41 1 1810674928 6546720 5430752
17:23:25 7339 8192000000 10711060080 11130740736 1799266688 18.008 99 26 52 6 1816756880 10062208 7427984
17:23:38 6660 8192000000 10719580432 11139260416 1799864464 18.013 99 24 48 1 1812156464 5212448 7079552
17:23:52 5871 8192000000 10741549472 11160711168 1826015744 18.227 100 26 52 2 1840193040 6275024 7902272
17:24:07 8890 8192000000 10748333136 11171897344 1831998288 18.276 100 28 55 2 1846158256 6086128 8073840
17:24:28 6136 8192000000 10755623312 11183546368 1843614272 18.370 100 29 56 1 1861890720 9934464 8341984
17:24:42 15361 8192000000 10765102800 11186651136 1842555248 18.362 100 16 32 0 1852368272 4949488 4863536
17:25:03 7076 8192000000 10773952176 11193307136 1849929296 18.422 100 32 64 2 1870096320 11261536 8905488
17:25:18 12862 8192000000 10778183840 11194228736 1855301360 18.465 100 24 48 1 1868285952 5772704 7211888
17:25:41 17120 8192000000 10772317488 11193425920 1859033568 18.495 100 27 54 1 1873265056 5040240 9191248
17:26:04 46297 8192000000 10792236880 11202056192 1866546848 18.556 100 56 113 1 1889191856 4949376 17695632
17:26:57 6233 8192000000 10795738112 11207331840 1866365664 18.555 100 42 82 1 1886122512 8228944 11527904
17:27:11 7311 8192000000 10792894096 11212845056 1874322448 18.619 100 28 56 3 1886807344 5096896 7388000
17:27:27 22404 8192000000 10806855072 11228336128 1888623120 18.735 100 47 94 3 1907413136 4880144 13909872
17:28:01 25401 8192000000 10829306944 11249332224 1900503168 18.830 100 43 87 0 1919570240 6949616 12117456
17:28:48 11090 8192000000 10854124832 11266154496 1912442624 18.926 100 63 125 0 1940484448 11119200 16922624
17:29:09 12033 8192000000 10843283616 11264204800 1917227872 18.965 100 60 120 1 1945259424 11682416 16349136
17:29:35 13439 8192000000 10859609920 11279724544 1921086672 18.996 100 56 113 0 1953372240 16188256 16097312
17:30:03 17189 8192000000 10860839632 11288694784 1926340864 19.038 100 52 101 4 1951438096 10533296 14563936
17:30:27 3401 8192000000 10863443088 11292135424 1934527264 19.103 100 52 105 1 1960430400 11110288 14792848
17:30:39 5787 8192000000 10872454864 11296260096 1936665872 19.120 100 50 97 3 1961268944 10562960 14040112
17:30:52 5628 8192000000 10879197408 11303092224 1944911200 19.186 100 64 130 1 1975547520 11509264 19127056
17:31:10 6650 8192000000 10874674368 11304398848 1942692848 19.168 100 52 100 2 1969381360 12114160 14574352
17:31:25 14466 8192000000 10882184304 11309842432 1949847424 19.225 100 57 112 1 1978390928 12449136 16094368
17:31:49 16515 8192000000 10895785072 11325177856 1956428432 19.278 100 47 94 0 1986729536 16575264 13725840
17:32:25 23945 8192000000 10889464912 11319652352 1955380384 19.269 100 43 84 2 1982109120 13862288 12866448
17:32:57 39297 8192000000 10880824688 11316797440 1937167360 19.124 99 48 96 0 1966721808 15369968 14184480
17:33:49 29873 8192000000 10886026784 11334971392 1959638080 19.303 100 37 74 1 1989213280 17784976 11790224
17:34:28 10796 8192000000 10897755600 11337314304 1965563312 19.350 100 35 68 2 1990922368 14640384 10718672
17:34:46 3799 8192000000 10917320384 11344883712 1975804080 19.431 100 67 134 2 2011601184 14525888 21271216
17:35:02 20574 8192000000 10912466720 11350953984 1976684096 19.438 100 43 85 1 2004076176 15141824 12250256
17:35:30 2479 8192000000 10937296816 11356405760 1983478624 19.492 100 64 126 1 2020303520 17895152 18929744
17:35:39 12254 8192000000 10933189312 11365523456 1986077712 19.513 100 61 121 0 2023861008 18645472 19137824
17:35:59 8557 8192000000 10934239184 11368513536 1993108608 19.568 100 59 118 1 2031898640 20788240 18001792
17:36:15 3724 8192000000 10935940384 11359309824 1984332128 19.499 100 63 126 0 2026178992 22511856 19335008
17:36:26 3363 8192000000 10947499120 11371499520 1992655440 19.565 100 73 146 0 2035967232 21822112 21489680
17:36:38 10846 8192000000 10937064976 11372060672 1991647024 19.557 100 54 108 0 2029880592 22408704 15824864
17:36:57 3365 8192000000 10965133168 11384672256 1999358224 19.618 100 70 138 1 2040339728 20685328 20296176
17:37:08 16831 8192000000 10946172640 11379453952 1998108512 19.608 100 49 96 0 2034817360 22314928 14393920
17:37:41 5769 8192000000 10959940720 11392028672 2006806864 19.676 100 69 138 3 2051089120 23210336 21071920
17:37:55 3044 8192000000 10950404272 11384246272 1989641600 19.541 99 63 126 1 2031878272 23084896 19151776
17:38:07 4565 8192000000 10944585312 11377037312 1997027632 19.599 100 58 116 2 2036180864 21571120 17582112
17:38:20 6628 8192000000 10957877856 11384827904 2002639440 19.644 100 68 133 0 2043872496 21897008 19336048
17:38:34 7641 8192000000 10972817648 11395497984 2011294064 19.712 100 76 152 0 2057156320 23343712 22518544
17:38:51 1956 8192000000 10960876176 11380248576 1999405792 19.618 100 88 176 1 2052156304 25755792 26994720
17:38:59 6361 8192000000 10952909840 11373244416 1964470912 19.342 98 70 136 1 2010535360 25780992 20283456
17:39:13 5866 8192000000 10955269760 11382669312 1999443728 19.618 100 70 139 1 2047168624 26233312 21491584
17:39:26 5306 8192000000 10953076704 11386486784 1997987344 19.607 100 62 123 1 2044454992 27125040 19342608
17:39:39 1851 8192000000 10959704592 11375951872 1986155392 19.513 99 70 140 0 2035575072 27642656 21777024
17:39:47 2199 8192000000 10983703792 11397029888 2005337040 19.665 100 86 171 2 2059673296 28587520 25748736
17:39:58 6147 8192000000 10969712672 11393605632 2003388640 19.649 100 75 151 0 2056188320 30327888 22471792
17:40:12 4105 8192000000 10971746608 11389353984 2001080928 19.631 100 81 162 3 2057414416 31481680 24851808
17:40:24 4573 8192000000 10983815296 11405307904 2013880304 19.732 100 86 172 0 2073278400 32388432 27009664
17:40:36 4634 8192000000 10983422224 11407323136 2015699184 19.746 100 83 165 1 2072210832 31306848 25204800
17:40:48 1835 8192000000 10987090176 11406598144 2016055504 19.749 100 82 163 2 2072057920 31671744 24330672
17:40:58 12577 8192000000 10988218672 11414896640 2017396880 19.760 100 72 144 2 2073761632 34001792 22362960
17:41:27 5599 8192000000 10987706864 11416657920 2019630816 19.777 100 58 117 2 2068261600 30346032 18284752
17:41:40 11342 8192000000 10975901440 11419549696 2021892928 19.795 100 55 110 0 2068693280 29511568 17288784
17:42:04 7007 8192000000 10979548112 11421839360 2022544816 19.800 100 54 108 1 2070458752 30980496 16933440
17:42:23 6890 8192000000 10979662928 11415355392 2015099584 19.742 100 63 124 3 2067594560 33564032 18930944
17:42:39 7627 8192000000 10984540560 11416444928 2014979952 19.741 100 62 124 0 2069280848 35000912 19299984
17:42:55 8981 8192000000 10969592448 11399733248 1988237776 19.530 99 65 129 0 2041437984 33559680 19640528
17:43:12 1609 8192000000 10981020064 11402027008 2002461888 19.642 100 75 149 0 2060318160 34738192 23118080
17:43:20 5354 8192000000 10980606848 11413041152 2009702448 19.699 100 71 142 1 2068625952 35987632 22935872
17:43:37 7758 8192000000 10982641664 11418234880 2017608016 19.761 100 66 131 1 2070942256 31665168 21669072
17:43:52 4588 8192000000 10981470032 11411677184 2011453728 19.713 100 61 122 2 2063202496 31970736 19778032
17:44:10 4222 8192000000 10962540128 11390930944 1990057344 19.544 99 67 134 1 2046676048 35369680 21249024
17:44:21 4137 8192000000 10949072960 11370835968 1947988656 19.210 98 74 146 1 2005793248 34795024 23009568
17:44:33 3482 8192000000 10939477232 11353939968 1954971280 19.266 99 85 168 1 2019602160 37848992 26781888
17:44:43 5246 8192000000 10965743536 11380346880 1978112768 19.450 100 85 168 0 2043631952 39558288 25960896
17:44:56 1709 8192000000 10972592864 11392552960 1989314480 19.538 100 79 157 0 2052401440 38247504 24839456
17:45:11 14587 8192000000 10934421104 11379961856 1977891744 19.448 100 39 78 2 2025628832 34449856 13287232
17:45:33 11751 8192000000 10907173680 11340972032 1921676240 19.000 97 46 92 2 1970694432 33710288 15307904
17:45:53 1684 8192000000 10948614224 11374804992 1974331424 19.420 100 69 136 2 2029605536 33873440 21400672
17:46:02 6863 8192000000 10908583776 11343388672 1920740240 18.993 98 47 94 0 1970339280 33794064 15804976
17:46:17 3316 8192000000 10877177760 11309473792 1879846016 18.664 97 58 114 0 1935027632 36766576 18415040
17:46:36 3378 8192000000 10900811760 11328454656 1913181552 18.932 99 61 121 1 1968340320 35615952 19542816
17:46:47 5583 8192000000 10927401632 11340984320 1940052400 19.147 100 75 150 2 2001913456 39040880 22820176
17:47:04 1887 8192000000 10924692320 11352829952 1947996384 19.211 100 58 116 1 2007089232 39717600 19375248
17:47:15 6892 8192000000 10928286432 11357818880 1955798192 19.273 100 57 115 0 2014352992 40684016 17870784
17:47:38 18505 8192000000 10911928672 11357671424 1933191344 19.092 99 37 73 1 1988686368 42901344 12593680
17:48:08 18547 8192000000 10922768880 11366719488 1955507488 19.270 100 36 72 1 2006613952 38677920 12428544
17:48:39 12769 8192000000 10919470416 11363663872 1950226480 19.228 100 41 82 1 2010805504 46562000 14017024
17:48:59 14954 8192000000 10904352032 11352944640 1929574864 19.063 99 29 57 2 1986348352 46466736 10306752
17:49:24 11544 8192000000 10914578656 11357802496 1943882464 19.178 100 32 64 0 1997045600 42125440 11037696
17:49:49 19096 8192000000 10910384624 11361738752 1951626000 19.239 100 33 66 3 1998890672 35974320 11290352
17:50:15 15276 8192000000 10899157392 11346051072 1932303440 19.085 99 27 53 2 1979904208 38326240 9274528
17:50:39 22113 8192000000 10910546368 11366993920 1926722400 19.041 99 22 44 1 1982455984 47433696 8299888
17:51:09 26295 8192000000 10913439280 11368374272 1926644256 19.040 99 26 52 0 1980699552 44805280 9250016
17:51:41 29437 8192000000 10873386224 11339505664 1902932304 18.850 98 29 58 1 1959925760 46666176 10327280
17:52:17 25668 8192000000 10883799136 11340292096 1907438848 18.886 99 21 42 3 1955747552 40596896 7711808
17:52:58 47918 8192000000 10877910496 11335004160 1901480640 18.838 99 21 42 3 1946909552 38799744 6629168
17:53:54 99315 8192000000 10805205344 11269521408 1713585184 17.299 90 22 44 0 1743916688 24290688 6040816
17:56:35 53900 8192000000 10819030592 11285635072 1897335184 18.805 100 31 62 0 1917304096 10512880 9456032
17:57:39 69328 8192000000 10826913840 11288289280 1874165296 18.618 98 10 20 0 1889636752 12602448 2869008
17:58:57 53460 8192000000 10839566224 11284283392 1856812224 18.477 97 19 38 1 1877656304 15840112 5003968
18:00:02 96096 8192000000 10853445968 11305836544 1901597232 18.839 99 17 34 3 1920159136 14251152 4310752
18:02:01 47358 8192000000 10861643424 11327553536 1932071616 19.083 100 13 26 1 1955119584 19095424 3952544
18:02:55 72974 8192000000 10868492816 11329220608 1935830000 19.113 100 18 36 0 1954617872 14299696 4488176
18:04:17 110241 8192000000 10847227728 11295506432 1862143952 18.521 96 28 56 1 1881472144 11759072 7569120
18:06:26 46586 8192000000 10871515520 11322503168 1918164496 18.972 99 34 67 2 1941196624 14462416 8569712
18:07:21 40630 8192000000 10856509648 11318300672 1926274768 19.037 99 47 95 0 1952100976 12668464 13157744
18:08:17 110313 8192000000 10892629360 11321745408 1897248224 18.804 97 53 104 2 1921426720 8165856 16012640
18:10:20 41364 8192000000 10884446416 11342352384 1956467968 19.278 100 35 70 0 1977488992 10700048 10320976
18:11:23 37546 8192000000 10905843376 11355918336 1974019664 19.417 100 38 76 1 1995634032 11050656 10563712
18:12:07 31662 8192000000 10903555840 11364257792 1976030016 19.433 100 33 66 0 2001066720 15078144 9958560
18:12:49 42614 8192000000 10889515296 11367100416 1974922624 19.424 100 23 46 0 1997437008 16063552 6450832
18:13:38 56389 8192000000 10886052224 11360575488 1957280048 19.284 99 17 34 2 1976294080 14129248 4884784
18:14:42 75137 8192000000 10896130064 11377307648 1970339344 19.388 100 18 36 1 1993432496 17730736 5362416
18:16:59 50620 8192000000 10914965712 11384348672 1984147888 19.498 100 31 60 0 2006865616 13960352 8757376
18:18:05 46410 8192000000 10928317456 11392253952 1993681088 19.573 100 17 34 0 2012785984 14002768 5102128
18:19:35 91300 8192000000 10924383600 11391918080 1976451760 19.437 99 11 21 0 2000493200 20464784 3576656
18:21:13 67380 8192000000 10944343328 11412328448 2007317424 19.680 100 19 38 2 2025748400 12888736 5542240
18:22:34 119115 8192000000 10925648496 11405840384 1955893200 19.273 97 20 40 3 1978241408 16781168 5567040
18:24:50 164992 8192000000 10938811296 11416162304 1951035264 19.235 97 11 22 2 1972434880 17885584 3514032
18:27:42 74679 8192000000 10942287520 11405901824 1972739584 19.407 98 18 36 0 1993592256 16115104 4737568
18:29:03 130405 8192000000 10917800272 11392102400 1974053856 19.418 98 28 56 2 1996243440 14460208 7729376
18:31:21 50280 8192000000 10943506576 11403788288 1991478016 19.555 99 33 65 0 2008804992 8993440 8333536
18:32:21 50836 8192000000 10932459872 11403198464 1988308608 19.530 99 41 80 1 2014014688 13858352 11847728
18:34:45 49355 8192000000 10902089728 11375083520 1944304096 19.181 98 14 28 3 1961176976 12410384 4462496
18:35:43 76051 8192000000 10893406752 11361382400 1939622208 19.144 97 24 48 0 1961071392 14300384 7148800
18:37:08 85507 8192000000 10893095120 11385180160 1944578192 19.183 98 8 15 1 1964299072 17538160 2182720
18:39:04 39665 8192000000 10917232528 11382390784 1984598768 19.501 100 26 52 3 2002911632 11457504 6855360
18:39:50 43916 8192000000 10901825344 11384426496 1943836400 19.177 98 16 32 0 1961710480 13739408 4134672
18:40:47 67490 8192000000 10894187760 11370401792 1939926480 19.146 98 16 32 0 1957441584 12551728 4963376
18:42:01 58291 8192000000 10893575600 11363602432 1898626976 18.815 96 15 30 1 1917918656 14801696 4489984
18:43:06 56787 8192000000 10898202208 11361349632 1949948048 19.226 99 18 36 0 1965327504 10366896 5012560
18:44:30 53114 8192000000 10874937728 11343155200 1888481104 18.734 96 32 64 0 1907962464 10412544 9068816
18:45:32 59727 8192000000 10877528016 11333070848 1823806112 18.209 93 32 64 2 1844054192 11123648 9124432
18:46:45 32557 8192000000 10860986336 11310174208 1887857840 18.729 97 46 92 1 1914730944 13712048 13161056
18:47:25 125457 8192000000 10837241808 11319578624 1797820288 17.996 93 22 44 0 1820547808 16443328 6284192
18:49:37 71937 8192000000 10857160048 11333386240 1915929712 18.954 100 10 20 1 1931254224 12522576 2801936
18:50:58 96587 8192000000 10870230096 11314212864 1832558160 18.280 94 33 62 1 1850188048 8742000 8887888
18:52:41 10436 8192000000 10857764544 11305304064 1893940768 18.778 98 41 81 1 1913363024 8563536 10858720
18:52:58 21969 8192000000 10876683328 11324977152 1927107616 19.044 100 35 70 2 1950039344 13314048 9617680
18:53:27 82464 8192000000 10845016192 11311984640 1876828256 18.639 97 17 34 0 1895813536 14196560 4788720
18:55:18 87506 8192000000 10855088816 11327729664 1898305520 18.813 98 13 26 1 1909961760 8356800 3299440
18:56:53 7117 8192000000 10873587664 11333591040 1941382384 19.158 100 42 83 4 1961110736 9149792 10578560
18:57:06 7655 8192000000 10864329408 11325652992 1937302048 19.125 100 31 62 2 1955906656 10500736 8103872
18:57:24 27087 8192000000 10880183584 11345670144 1939322128 19.141 99 21 42 3 1954117696 8600160 6195408
18:57:57 80703 8192000000 10860974752 11334111232 1920645024 18.992 98 14 28 0 1936421504 11796320 3980160
18:59:24 72283 8192000000 10877330032 11353563136 1909332624 18.901 98 14 28 1 1931911392 18756736 3822032
19:00:52 65361 8192000000 10868400992 11355291648 1923175600 19.012 99 14 28 0 1951403536 24054896 4173040
19:02:33 64189 8192000000 10880231696 11358248960 1917387072 18.966 98 16 32 1 1936024592 14466192 4171328
19:03:52 84003 8192000000 10899622336 11370373120 1944313184 19.181 99 19 39 1 1962425728 12458256 5654288
19:05:25 79221 8192000000 10905691136 11385516032 1956323024 19.277 99 18 36 2 1976212880 14504288 5385568
19:06:59 79190 8192000000 10912779408 11379929088 1942701792 19.168 98 16 32 1 1959557008 12099424 4755792
19:08:27 51985 8192000000 10925034432 11385335808 1966444240 19.357 99 28 56 1 1986657392 12636480 7576672
19:09:31 93437 8192000000 10927919776 11408482304 1991012016 19.552 100 24 48 1 2013430944 15298368 7120560
19:11:11 91723 8192000000 10950147952 11432607744 1971935104 19.401 99 15 30 0 1990761568 14865568 3960896
19:14:08 137901 8192000000 10925636800 11414609920 1883618112 18.694 94 11 20 1 1904605488 18568752 2418624
19:16:35 139132 8192000000 10893730176 11368783872 1921689904 19.000 96 19 37 0 1935955216 9706944 4558368
19:19:03 43400 8192000000 10921451136 11379343360 1962930992 19.329 99 44 90 1 1985683792 9832336 12920464
19:19:53 74285 8192000000 10908780176 11386834944 1962372896 19.325 99 18 34 1 1976105552 8559200 5173456
19:21:13 47264 8192000000 10907328112 11394150400 1989415792 19.539 100 16 32 0 2003553136 9150864 4986480
19:22:07 50264 8192000000 10918443408 11407790080 1978854320 19.456 99 17 34 1 1993684928 10099552 4731056
19:23:55 74592 8192000000 10924421888 11411943424 2000683776 19.628 100 23 45 1 2023981808 15782896 7515136
19:25:19 91131 8192000000 10929285120 11415965696 2003944592 19.654 100 17 35 0 2028198432 19315184 4938656
19:26:58 33243 8192000000 9318600176 9600724992 477075872 5.503 25 3 5 0 482545568 5035584 434112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 07-03-2021 19:29:11 to 07-03-2021 19:29:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 82 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-03-2021 19:29:42 to 07-03-2021 19:29:44.

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

07.03.21 19:29:45. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-03-07 19:29:48 No severe PSQL-related problems occured
07.03.21 19:29:49. End of report.