Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.06.2021 01: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 58e1ddde69c44dad93d327777e5becec
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-05-09 08:45
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 4793.92
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 16807496 kB
MemAvailable 31395372 kB
Buffers 0 kB
Cached 14851492 kB
SwapCached 2976 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-06-17 01:27:39
DTS_END                         2021-06-17 01:27:39.9520
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53336
TRN_ID                          238607
ATT_ID                          678
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: 9246.63 22565 1109595
customer order: creation 164.81 332 19777
customer order: refuse 14.26 364 1711
order to supplier: creation 44.36 1336 5323
order to supplier: removal 3.40 109161 408
invoice (draft): creation 44.65 3550 5358
invoice (draft): removal 53.07 862 6368
invoice accept: apply 40.32 18260 4838
invoice accept: cancel 48.42 838 5810
customer reserve: creation 3750.68 178 450081
customer reserve: removal 4788.12 60 574574
realization accept: apply 80.08 198 9609
realization accept: cancel 88.82 101 10658
payment from customer: creation 57.80 133 6936
payment from customer: removal 5.43 87 652
payment to supplier: creation 47.34 167 5681
payment to supplier: removal 3.39 70 407
service: total inventory turnovers 4.37 1277 524
service: total monetary turnovers 6.50 57 780
service: aggregate perf. data 0.80 20531 96
service: refresh index statistics 0.03 293741 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-06-2021 01:28:59 to 17-06-2021 01:29:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2406
TEST_TIME 2 3326
TEST_TIME 3 3155
TEST_TIME 4 3228
TEST_TIME 5 4723
TEST_TIME 6 4195
TEST_TIME 7 4601
TEST_TIME 8 5292
TEST_TIME 9 5730
TEST_TIME 10 5947
TEST_TIME 11 6050
TEST_TIME 12 6455
TEST_TIME 13 6873
TEST_TIME 14 7425
TEST_TIME 15 7877
TEST_TIME 16 7896
TEST_TIME 17 8096
TEST_TIME 18 8230
TEST_TIME 19 8561
TEST_TIME 20 8692
TEST_TIME 21 8678
TEST_TIME 22 8544
TEST_TIME 23 8680
TEST_TIME 24 9013
TEST_TIME 25 9212
TEST_TIME 26 8979
TEST_TIME 27 8907
TEST_TIME 28 8999
TEST_TIME 29 9327
TEST_TIME 30 9738
TEST_TIME 31 9912
TEST_TIME 32 10263
TEST_TIME 33 10526
TEST_TIME 34 11160
TEST_TIME 35 10961
TEST_TIME 36 11136
TEST_TIME 37 11325
TEST_TIME 38 11128
TEST_TIME 39 10861
TEST_TIME 40 10723
TEST_TIME 41 10583
TEST_TIME 42 10463
TEST_TIME 43 10515
TEST_TIME 44 10400
TEST_TIME 45 10303
TEST_TIME 46 10291
TEST_TIME 47 10333
TEST_TIME 48 10259
TEST_TIME 49 10132
TEST_TIME 50 10014
TEST_TIME 51 9889
TEST_TIME 52 9856
TEST_TIME 53 9773
TEST_TIME 54 9735
TEST_TIME 55 9773
TEST_TIME 56 9632
TEST_TIME 57 9594
TEST_TIME 58 9561
TEST_TIME 59 9576
TEST_TIME 60 9456
TEST_TIME 61 9499
TEST_TIME 62 9613
TEST_TIME 63 9629
TEST_TIME 64 9627
TEST_TIME 65 9601
TEST_TIME 66 9591
TEST_TIME 67 9641
TEST_TIME 68 9628
TEST_TIME 69 9607
TEST_TIME 70 9678
TEST_TIME 71 9682
TEST_TIME 72 9695
TEST_TIME 73 9732
TEST_TIME 74 9714
TEST_TIME 75 9754
TEST_TIME 76 9652
TEST_TIME 77 9581
TEST_TIME 78 9606
TEST_TIME 79 9532
TEST_TIME 80 9536
TEST_TIME 81 9489
TEST_TIME 82 9487
TEST_TIME 83 9442
TEST_TIME 84 9436
TEST_TIME 85 9362
TEST_TIME 86 9337
TEST_TIME 87 9430
TEST_TIME 88 9408
TEST_TIME 89 9397
TEST_TIME 90 9415
TEST_TIME 91 9416
TEST_TIME 92 9367
TEST_TIME 93 9457
TEST_TIME 94 9475
TEST_TIME 95 9550
TEST_TIME 96 9537
TEST_TIME 97 9536
TEST_TIME 98 9577
TEST_TIME 99 9673
TEST_TIME 100 9629
TEST_TIME 101 9629
TEST_TIME 102 9645
TEST_TIME 103 9600
TEST_TIME 104 9538
TEST_TIME 105 9563
TEST_TIME 106 9514
TEST_TIME 107 9517
TEST_TIME 108 9495
TEST_TIME 109 9444
TEST_TIME 110 9454
TEST_TIME 111 9454
TEST_TIME 112 9437
TEST_TIME 113 9389
TEST_TIME 114 9351
TEST_TIME 115 9317
TEST_TIME 116 9293
TEST_TIME 117 9281
TEST_TIME 118 9296
TEST_TIME 119 9287
TEST_TIME 120 9249

Performance per minute, chart


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

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 1527191 1527191 0 0.00 0 23241 6 0 0
doc_list_biud 1527191 1527191 0 0.00 0 60175 29 0 0
sp_add_invoice_to_stock 4951 4838 113 2.28 31 193424 18261 0 113
sp_cancel_adding_invoice 5810 5810 0 0.00 3 69952 839 0 0
sp_cancel_client_order 1711 1711 0 0.00 4 11856 365 0 0
sp_cancel_customer_reserve 574574 574574 0 0.00 1 60177 60 0 0
sp_cancel_pay_from_customer 652 652 0 0.00 3 7438 88 0 0
sp_cancel_pay_to_supplier 407 407 0 0.00 3 2194 70 0 0
sp_cancel_supplier_invoice 6382 6368 14 0.21 1 21770 863 0 14
sp_cancel_supplier_order 408 408 0 0.00 8 973005 109162 0 0
sp_cancel_write_off 10658 10658 0 0.00 1 9577 102 0 0
sp_client_order 19777 19777 0 0.00 4 17360 333 0 0
sp_customer_reserve 450081 450081 0 0.00 0 117911 179 0 0
sp_fill_shopping_cart 30451 30451 0 0.00 1 16865 41 0 0
sp_fill_shopping_cart_clo_res 450079 450079 0 0.00 0 29263 14 0 0
sp_get_clo_for_invoice 4835 4835 0 0.00 0 25172 303 0 0
sp_kill_cost_storno 17527 17527 0 0.00 0 7427 59 0 0
sp_kill_qstorno_ret_qs2qd 1166582 1166582 0 0.00 0 60173 33 0 0
sp_kill_qty_storno 613973 613973 0 0.00 0 60175 71 0 0
sp_lock_selected_doc 20022 20022 0 0.00 0 9643 7 0 0
sp_make_cost_storno 27061 27061 0 0.00 0 23235 76 0 0
sp_multiply_rows_for_pdistr 27061 27061 0 0.00 0 14670 32 0 0
sp_multiply_rows_for_qdistr 19777 19777 0 0.00 0 14898 140 0 0
sp_pay_from_customer 6936 6936 0 0.00 4 20244 133 0 0
sp_pay_to_supplier 5681 5681 0 0.00 4 35728 167 0 0
sp_payment_common 12617 12617 0 0.00 1 21026 48 0 0
sp_qd_handle_on_cancel_clo 1711 1711 0 0.00 0 11850 340 0 0
sp_qd_handle_on_invoice_upd_sts 10645 10645 0 0.00 0 19151 364 0 0
sp_qd_handle_on_reserve_upd_sts 9609 9609 0 0.00 0 11098 53 0 0
sp_reserve_write_off 9609 9609 0 0.00 6 23277 198 0 0
sp_supplier_invoice 5358 5358 0 0.00 7 91903 3551 0 0
sp_supplier_order 5323 5323 0 0.00 5 42528 1337 0 0
srv_aggregate_perf_data 96 96 0 0.00 3129 203523 20532 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1459 181170 32266 0 0
srv_find_qd_qs_mism 1063748 1063748 0 0.00 0 17584 5 0 0
srv_make_invnt_saldo 524 524 0 0.00 36 97716 1278 0 0
srv_make_money_saldo 780 780 0 0.00 0 12545 58 0 0
srv_recalc_idx_stat 4 4 0 0.00 88606 506548 293742 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4838 4838 0 0.00 0 30321 211 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 0 4095 78 0 0
t$perf-norm:sp_cancel_client_order 1711 1711 0 0.00 0 6815 27 0 0
t$perf-norm:sp_cancel_customer_reserve 690 690 0 0.00 0 3510 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 652 652 0 0.00 0 3385 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 407 407 0 0.00 0 1597 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 372 372 0 0.00 0 1000 20 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 24075 1628 0 0
t$perf-norm:sp_cancel_write_off 933 933 0 0.00 0 690 4 0 0
t$perf-norm:sp_client_order 19777 19777 0 0.00 0 28707 22 0 0
t$perf-norm:sp_customer_reserve 976 976 0 0.00 0 3852 10 0 0
t$perf-norm:sp_pay_from_customer 6936 6936 0 0.00 0 27519 14 0 0
t$perf-norm:sp_pay_to_supplier 5681 5681 0 0.00 0 8373 15 0 0
t$perf-norm:sp_reserve_write_off 9609 9609 0 0.00 0 25288 16 0 0
t$perf-norm:sp_supplier_invoice 5358 5358 0 0.00 0 6680 19 0 0
t$perf-norm:sp_supplier_order 5323 5323 0 0.00 0 4695 18 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 509 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 194 3 0 0
t$perf-norm:srv_make_invnt_saldo 524 524 0 0.00 0 8767 54 0 0
t$perf-norm:srv_make_money_saldo 780 780 0 0.00 0 1081 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 9896 9670 226 2.28 0 5244 18 0 226
v_all_customers 36660 36660 0 0.00 0 15 1 0 0
v_all_suppliers 29488 29488 0 0.00 0 26 1 0 0
v_all_wares 39554 39554 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 265 6 0 0
v_cancel_client_order 3422 3422 0 0.00 0 2236 4 0 0
v_cancel_customer_prepayment 1304 1304 0 0.00 0 3299 6 0 0
v_cancel_customer_reserve 1380 1380 0 0.00 0 1519 4 0 0
v_cancel_payment_to_supplier 814 814 0 0.00 0 1372 6 0 0
v_cancel_supplier_invoice 772 744 28 3.62 0 1873 16 0 28
v_cancel_supplier_order 816 816 0 0.00 0 2458 8 0 0
v_cancel_write_off 1866 1866 0 0.00 0 2004 13 0 0
v_max_id_clo_ord 5322 5322 0 0.00 0 457 1 0 0
v_max_id_clo_res 976 976 0 0.00 0 4493 20 0 0
v_max_id_ord_sup 5352 5352 0 0.00 0 5846 5 0 0
v_max_non_paid_invoice 1611 1611 0 0.00 0 1987 4 0 0
v_max_non_paid_realizn 3451 3451 0 0.00 0 873 3 0 0
v_min_id_clo_ord 5322 5322 0 0.00 0 13827 12 0 0
v_min_id_clo_res 976 976 0 0.00 0 4263 8 0 0
v_min_id_ord_sup 5352 5352 0 0.00 0 5354 5 0 0
v_min_non_paid_invoice 5681 5681 0 0.00 0 18782 40 0 0
v_min_non_paid_realizn 6936 6936 0 0.00 0 6879 24 0 0
v_our_firm 9864 9864 0 0.00 0 11 1 0 0
v_reserve_write_off 19218 19218 0 0.00 0 7327 5 0 0
x_lock_depdocs_on_canc_invoice 11806 11806 0 0.00 0 19485 124 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 17606 444 0 0
x_make_qstorno_1000_1200 5323 5323 0 0.00 2 41645 1245 0 0
x_make_qstorno_1200_2000 5358 5358 0 0.00 3 91877 3411 0 0
x_make_qstorno_2100_3300 450081 450081 0 0.00 0 117910 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-06-2021 01:29:07 to 17-06-2021 01:29:11.

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
22:57:43 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
22:57:50 20806 8192000000 10292677840 10598072320 990910736 10.790 76 65 130 1 1015098624 2900960 21286928
22:58:22 29780 8192000000 10344482752 10662277120 1396222752 14.561 100 87 174 0 1429780000 5504992 28052256
22:59:08 19362 8192000000 10374110304 10698436608 1425281136 14.820 100 84 168 0 1460027408 7413488 27332784
22:59:37 16577 8192000000 10401647408 10728087552 1450081920 15.039 100 83 166 0 1484919424 8011744 26825760
23:00:14 27063 8192000000 10431041440 10763812864 1482296368 15.322 100 82 164 1 1517705280 9046064 26362848
23:00:54 16335 8192000000 10454413600 10794110976 1510120992 15.564 100 83 166 0 1546611040 10238112 26251936
23:01:28 12753 8192000000 10471292288 10813362176 1532841024 15.762 100 86 172 1 1571005088 10731776 27432288
23:01:56 15665 8192000000 10506373968 10852016128 1557841552 15.978 100 82 164 1 1593848256 10473936 25532768
23:02:21 9729 8192000000 10517536960 10869551104 1583748080 16.200 100 84 168 0 1619763376 10635280 25380016
23:02:41 12184 8192000000 10539787408 10894352384 1597700384 16.320 100 82 164 1 1633975328 11366912 24908032
23:03:04 10664 8192000000 10568600640 10922938368 1620189056 16.512 100 88 177 0 1658750512 11781952 26779504
23:03:27 10451 8192000000 10578902960 10937253888 1639014016 16.671 100 80 160 2 1675153600 12095472 24044112
23:03:46 9451 8192000000 10591781984 10953625600 1654872160 16.806 100 81 162 1 1692016864 12862480 24282224
23:04:02 8627 8192000000 10609532704 10973450240 1665890848 16.899 100 78 156 0 1701943504 13211888 22840768
23:04:20 6913 8192000000 10633362560 10998104064 1685540960 17.064 100 79 159 0 1720849696 12544304 22764432
23:04:36 6964 8192000000 10638308016 11007668224 1701413168 17.197 100 88 177 2 1740083424 13017392 25652864
23:04:49 7031 8192000000 10645479856 11019341824 1706015968 17.235 100 69 138 0 1738633840 12637088 19980784
23:05:05 4738 8192000000 10662446192 11033505792 1725684416 17.400 100 84 168 1 1762087952 12797600 23605936
23:05:17 4743 8192000000 10679103616 11048779776 1733289152 17.463 100 86 173 0 1771184384 12798640 25096592
23:05:31 5778 8192000000 10686665360 11058274304 1742514080 17.540 100 74 148 0 1775350928 12364592 20472256
23:05:43 6341 8192000000 10696223696 11070664704 1757866928 17.667 100 79 159 1 1792728688 12879472 21982288
23:05:57 4316 8192000000 10722272912 11095572480 1773840640 17.799 100 86 171 2 1812559632 14321216 24397776
23:06:08 3916 8192000000 10729642864 11105103872 1786479728 17.903 100 93 185 2 1826734816 14338160 25916928
23:06:19 4160 8192000000 10730227392 11109097472 1786604928 17.904 100 81 162 1 1824322912 14735136 22982848
23:06:29 3621 8192000000 10736143952 11113930752 1795088656 17.974 100 92 180 0 1834172096 14319584 24763856
23:06:40 3533 8192000000 10747665968 11129110528 1800891552 18.021 100 90 180 0 1840830928 14366320 25573056
23:06:51 2549 8192000000 10742156048 11119767552 1805203584 18.057 100 91 183 4 1845521616 15156064 25161968
23:07:00 3502 8192000000 10752050720 11135778816 1809429008 18.091 100 86 172 1 1847425424 13899232 24097184
23:07:10 5167 8192000000 10757564064 11140722688 1813590720 18.125 100 77 155 0 1849080944 14136368 21353856
23:07:22 2908 8192000000 10768068656 11154104320 1822302624 18.196 100 86 171 2 1859461328 13227584 23931120
23:07:31 1727 8192000000 10784640048 11169656832 1838801056 18.331 100 83 167 2 1873421648 11499200 23121392
23:07:39 2111 8192000000 10789508080 11173593088 1845436352 18.385 100 95 190 1 1885017200 12485904 27094944
23:07:48 1587 8192000000 10790989616 11177013248 1849100960 18.415 100 89 178 2 1886323728 11840288 25382480
23:07:55 2325 8192000000 10804933408 11188432896 1855822864 18.469 100 91 181 0 1894332944 13333072 25177008
23:08:04 1741 8192000000 10802993696 11188654080 1862239040 18.521 100 93 184 2 1901844432 13929760 25675632
23:08:12 1302 8192000000 10815756992 11199733760 1862487088 18.523 100 91 181 0 1901916496 14060960 25368448
23:08:20 2043 8192000000 10815009888 11201499136 1868582528 18.573 100 91 183 1 1906701408 12077872 26041008
23:08:28 1847 8192000000 10819230848 11209027584 1872143392 18.602 100 90 180 1 1911389376 13014112 26231872
23:08:36 1451 8192000000 10823769120 11211202560 1880990304 18.673 100 94 189 0 1920157952 12993536 26174112
23:08:44 1582 8192000000 10824751568 11215654912 1880266128 18.667 100 93 186 0 1919844400 13045760 26532512
23:08:52 1703 8192000000 10827045152 11215958016 1884145936 18.699 100 95 192 0 1925421536 14966896 26308704
23:09:00 1373 8192000000 10830425616 11218804736 1883713568 18.695 100 92 183 1 1923052608 14256512 25082528
23:09:08 18438 8192000000 10807011040 11206201344 1874056624 18.617 100 48 98 1 1898780656 11243968 13480064
23:09:35 5367 8192000000 10814912288 11215392768 1876825056 18.639 100 60 120 2 1901361072 8478640 16057376
23:09:46 7534 8192000000 10799221168 11216818176 1879022672 18.657 100 50 100 0 1903024096 10359728 13641696
23:10:01 5745 8192000000 10788232224 11214163968 1878318896 18.652 100 29 57 0 1893949488 7071056 8559536
23:10:15 8313 8192000000 10795685008 11219554304 1883192224 18.691 100 27 53 1 1898122592 7382688 7547680
23:10:30 8002 8192000000 10804648784 11223207936 1891062544 18.754 100 48 94 1 1911691952 6267376 14362032
23:10:46 6666 8192000000 10792408624 11222568960 1885469616 18.709 100 22 44 0 1897640976 6187904 5983456
23:10:59 13048 8192000000 10794047200 11226464256 1889620896 18.743 100 22 44 1 1902039680 5500704 6918080
23:11:21 9982 8192000000 10797950352 11227844608 1888620000 18.735 100 16 32 1 1899178768 6579056 3979712
23:11:37 13859 8192000000 10792749248 11229495296 1893749888 18.776 100 10 20 0 1902566608 6077872 2738848
23:11:57 9011 8192000000 10793825120 11230941184 1894914368 18.785 100 16 32 2 1905738352 6640192 4183792
23:12:12 19146 8192000000 10800487248 11237199872 1892263152 18.764 100 8 16 1 1899139744 4868960 2007632
23:12:38 11004 8192000000 10804441632 11235573760 1894721216 18.784 100 19 38 0 1906005008 5940320 5343472
23:12:56 18646 8192000000 10804586240 11243143168 1898450944 18.814 100 21 42 0 1909896064 4930592 6514528
23:13:35 41677 8192000000 10845200192 11257798656 1906507344 18.879 100 59 121 3 1928845968 4938272 17400352
23:14:23 4876 8192000000 10817870672 11257929728 1903494432 18.854 100 38 76 0 1923541696 9649536 10397728
23:14:34 8949 8192000000 10821362768 11250442240 1902940560 18.850 100 28 56 3 1917867920 7223952 7703408
23:14:50 6264 8192000000 10822531776 11251064832 1886487360 18.717 99 31 62 1 1902164032 6668016 9008656
23:15:03 3024 8192000000 10822043792 11253026816 1904651328 18.864 100 37 74 0 1924013568 8322160 11040080
23:15:14 3882 8192000000 10822505904 11252154368 1903775424 18.857 100 27 54 1 1918459360 6795120 7888816
23:15:29 8125 8192000000 10826719456 11248885760 1883299968 18.692 99 20 39 2 1894559392 5212704 6046720
23:15:45 8122 8192000000 10824993936 11251847168 1883741360 18.695 99 28 57 2 1898014608 6441472 7831776
23:16:01 10042 8192000000 10821568592 11254947840 1902859840 18.849 100 20 40 1 1914519040 6100384 5558816
23:16:21 6452 8192000000 10813879088 11245010944 1883035904 18.690 99 18 36 2 1893362032 4931120 5395008
23:16:36 8544 8192000000 10804401760 11230892032 1863297408 18.530 98 14 28 1 1872300576 5153616 3849552
23:16:55 8843 8192000000 10804730880 11239804928 1860994960 18.511 98 15 30 2 1870636256 5611440 4029856
23:17:11 16456 8192000000 10785700096 11220938752 1813258960 18.123 96 13 26 0 1822432608 5606256 3567392
23:17:35 25299 8192000000 10771525568 11210649600 1808017776 18.080 96 20 41 1 1819386208 5666288 5702144
23:18:19 41795 8192000000 10758361984 11179499520 1768646912 17.756 94 27 54 0 1780995520 5184064 7164544
23:19:09 10136 8192000000 10712531808 11142201344 1774421824 17.804 96 14 28 1 1783780784 5311472 4047488
23:19:27 6233 8192000000 10719038384 11133427712 1727788608 17.417 95 40 80 3 1747056816 7974944 11293264
23:19:43 7045 8192000000 10728077280 11158745088 1790846464 17.939 98 31 62 2 1804955968 5477600 8631904
23:19:56 5653 8192000000 10718711024 11141410816 1795105216 17.974 99 21 42 1 1806840192 5595968 6139008
23:20:08 6564 8192000000 10730801856 11148210176 1795231440 17.975 99 23 46 1 1807313248 5512464 6569344
23:20:23 9868 8192000000 10702825344 11116408832 1699315776 17.179 94 25 50 1 1712230672 5909360 7005536
23:20:39 10236 8192000000 10696013712 11105275904 1705235072 17.229 95 16 32 1 1714799872 4872304 4692496
23:20:56 12643 8192000000 10682272064 11104591872 1694729984 17.141 95 20 40 0 1706183840 5767776 5686080
23:21:22 10924 8192000000 10696741296 11118903296 1751813488 17.617 98 20 40 1 1766931712 9754640 5363584
23:21:42 4880 8192000000 10697057568 11109986304 1757744320 17.666 98 25 50 1 1770577200 5531248 7301632
23:21:53 7376 8192000000 10708372944 11126927360 1772577328 17.788 98 24 47 3 1790084352 9285920 8221104
23:22:06 12343 8192000000 10713245152 11138232320 1803912256 18.046 100 21 42 2 1815376160 5337104 6126800
23:22:28 6651 8192000000 10727409088 11150131200 1812889360 18.120 100 21 42 2 1826049920 6305536 6855024
23:22:41 8400 8192000000 10743876464 11167105024 1821937328 18.194 100 14 28 0 1831431280 5689312 3804640
23:22:55 18433 8192000000 10771753584 11180134400 1830254224 18.261 100 27 54 0 1845654992 4991360 10409408
23:23:22 64586 8192000000 10743965888 11175985152 1839360480 18.336 100 42 81 2 1856769856 5419888 11989488
23:24:34 13963 8192000000 10757446032 11189006336 1847128704 18.399 100 27 54 0 1860628496 6406592 7093200
23:24:54 5764 8192000000 10780094736 11194998784 1852810304 18.445 100 34 68 1 1869034144 6279264 9944576
23:25:07 7365 8192000000 10770881248 11199856640 1854499184 18.459 100 26 50 2 1867017120 5427088 7090848
23:25:20 7003 8192000000 10779540896 11203592192 1857046720 18.479 100 24 48 2 1868986304 5395920 6543664
23:25:37 8122 8192000000 10783393136 11209109504 1861180128 18.513 100 29 58 2 1874763584 4782784 8800672
23:25:51 4092 8192000000 10783084784 11209023488 1863520304 18.532 100 39 76 2 1881938656 7442512 10975840
23:26:03 8456 8192000000 10774584176 11207315456 1864003824 18.536 100 17 32 3 1873825952 5028512 4793616
23:26:21 5987 8192000000 10796446976 11223060480 1868961952 18.576 100 29 57 5 1887640704 10302176 8376576
23:26:36 9731 8192000000 10772117296 11203870720 1854376736 18.458 99 26 52 1 1867395504 5497488 7521280
23:26:53 11138 8192000000 10772772768 11198484480 1859787760 18.502 99 36 72 0 1876355920 4977456 11590704
23:27:10 16315 8192000000 10796292480 11230883840 1886856704 18.720 100 17 34 1 1896860544 4818880 5184960
23:27:32 10096 8192000000 10809401056 11239133184 1891775392 18.760 100 17 34 1 1901067568 4813808 4478368
23:28:11 44454 8192000000 10857662160 11272548352 1915053168 18.947 100 41 81 1 1934790496 7085456 12651872
23:29:07 48280 8192000000 10870230384 11291754496 1930143184 19.068 100 41 83 1 1949742464 7775216 11824064
23:30:05 98986 8192000000 10882457824 11309080576 1942442752 19.166 100 45 90 0 1966876096 11463968 12969376
23:31:54 67223 8192000000 10872324080 11328172032 1942778864 19.169 100 33 66 0 1968897808 16255984 9862960
23:33:59 12289 8192000000 10890379120 11319750656 1938775344 19.137 99 33 66 1 1962186928 13119456 10292128
23:34:18 4102 8192000000 10913848512 11332046848 1962188144 19.323 100 62 125 4 1996212080 15385584 18638352
23:34:34 2870 8192000000 10924177568 11341004800 1972756864 19.407 100 78 151 2 2013617872 18060224 22800784
23:34:45 5227 8192000000 10918441792 11337883648 1963541312 19.334 100 63 126 0 1999752496 18165328 18045856
23:34:59 3159 8192000000 10933952528 11351875584 1976190016 19.435 100 80 155 0 2018151712 19129584 22832112
23:35:10 4916 8192000000 10926588224 11346911232 1975102336 19.426 100 66 130 1 2012554560 18030448 19421776
23:35:22 8347 8192000000 10920838032 11351523328 1977187424 19.442 100 61 121 0 2013130816 18158048 17785344
23:35:38 4283 8192000000 10930236048 11353362432 1983975984 19.496 100 75 150 1 2025602816 18472544 23154288
23:35:53 11765 8192000000 10908633632 11331952640 1926796816 19.041 97 65 130 0 1964197120 18954848 18445456
23:36:11 5006 8192000000 10937128128 11356520448 1980090976 19.465 100 76 152 1 2021955632 20625200 21239456
23:36:23 8567 8192000000 10936994576 11357388800 1979797216 19.463 100 77 154 1 2021438768 19365008 22276544
23:36:41 11471 8192000000 10934381328 11359084544 1980208976 19.466 100 67 134 1 2019675424 19894416 19572032
23:37:00 10718 8192000000 10932432128 11365064704 1980503488 19.469 100 61 122 3 2018679472 19541264 18634720
23:37:20 14193 8192000000 10926286384 11366199296 1980820496 19.471 100 41 82 0 2012742272 18485040 13436736
23:37:43 20716 8192000000 10926554000 11363110912 1969654576 19.383 99 47 94 2 2001723712 17288000 14781136
23:38:11 4886 8192000000 10938902352 11373002752 1985776416 19.510 100 54 109 0 2024447296 22289072 16381808
23:38:26 5363 8192000000 10946086656 11373342720 1984225072 19.498 100 63 126 1 2024857664 21468464 19164128
23:38:42 9079 8192000000 10921452464 11351502848 1968624048 19.375 99 64 126 3 2007958128 20745136 18588944
23:38:59 2578 8192000000 10941897856 11364667392 1984494048 19.500 100 57 114 2 2023139568 21947184 16698336
23:39:11 5315 8192000000 10943431824 11377958912 1990718224 19.549 100 64 124 1 2031604304 22100352 18785728
23:39:23 1611 8192000000 10978680704 11402162176 2007775152 19.684 100 85 168 1 2064568320 32904768 23888400
23:39:32 2225 8192000000 10977445856 11396308992 2008625280 19.691 100 95 191 1 2060055440 22649040 28781120
23:39:45 12610 8192000000 10973209360 11402911744 2010346944 19.704 100 67 134 2 2054849088 25002944 19499200
23:40:07 4870 8192000000 10973385776 11407867904 2011982352 19.717 100 68 137 0 2056569136 24312272 20274512
23:40:19 1458 8192000000 10987021376 11403767808 2013012112 19.725 100 91 180 3 2064972352 25483792 26476448
23:40:27 1942 8192000000 10979595136 11404247040 2012266320 19.719 100 79 155 0 2061169680 26043424 22859936
23:40:36 2934 8192000000 10954043536 11388444672 1998569408 19.611 100 62 122 0 2041865440 24470448 18825584
23:40:48 6090 8192000000 10947287440 11382947840 1976796368 19.439 99 65 130 1 2023578064 27404544 19377152
23:41:10 9399 8192000000 10934018768 11383513088 1980990480 19.473 100 36 72 0 2021787504 28420192 12376832
23:41:30 9766 8192000000 10921558000 11372093440 1957857472 19.289 99 31 62 3 1998196944 29792224 10547248
23:41:48 10472 8192000000 10933828256 11376599040 1977228528 19.443 100 42 84 1 2018509856 28002464 13278864
23:42:06 2061 8192000000 10936920912 11364290560 1965103776 19.347 99 67 133 1 2014314560 29150144 20060640
23:42:17 3487 8192000000 10938509376 11372220416 1972820592 19.408 100 57 114 2 2021295792 30389632 18085568
23:42:27 2396 8192000000 10942074704 11376652288 1977359168 19.444 100 70 138 2 2027677392 28686160 21632064
23:42:36 9814 8192000000 10909678896 11355959296 1938402256 19.134 98 42 84 1 1976747808 25921392 12424160
23:42:55 4826 8192000000 10916622016 11349372928 1956854144 19.281 100 53 106 0 1996580944 23813088 15913712
23:43:10 3565 8192000000 10877468800 11302080512 1897218000 18.804 97 65 130 1 1944508992 26388448 20902544
23:43:25 1860 8192000000 10917507792 11338170368 1929294640 19.061 99 71 137 1 1978432576 28321328 20816608
23:43:35 2726 8192000000 10929734080 11347763200 1954875584 19.265 100 71 140 1 2007518512 31890240 20752688
23:43:44 1823 8192000000 10940237568 11354959872 1960526928 19.310 100 95 190 1 2021895392 32616000 28752464
23:43:52 3038 8192000000 10931857792 11348557824 1948872688 19.217 100 84 168 2 2007395952 33218736 25304528
23:44:05 3199 8192000000 10939701840 11355443200 1958380016 19.293 100 78 156 1 2017495872 35047840 24068016
23:44:21 6237 8192000000 10925777312 11347087360 1932681168 19.088 99 67 132 2 1988352416 35421552 20249696
23:44:39 4897 8192000000 10890057136 11310563328 1909282560 18.901 99 76 152 0 1966225792 33916224 23027008
23:44:54 2252 8192000000 10901617472 11311927296 1921407728 18.998 100 79 158 0 1981636640 34049712 26179200
23:45:05 2545 8192000000 10888186000 11305095168 1912275472 18.925 100 86 171 1 1976184496 37230864 26678160
23:45:17 4974 8192000000 10901002272 11319726080 1920214016 18.989 100 73 145 2 1980881728 38679952 21987760
23:45:30 2930 8192000000 10929685488 11337793536 1939004768 19.139 100 87 174 1 2004094512 38666032 26423712
23:45:40 4467 8192000000 10925963328 11343695872 1938425072 19.134 100 79 158 0 2002833904 40580624 23828208
23:45:52 2168 8192000000 10928598176 11339358208 1943664000 19.176 100 86 171 3 2009011200 38515504 26831696
23:46:02 3651 8192000000 10910947984 11322707968 1925500976 19.031 99 87 174 1 1992019968 39866448 26652544
23:46:13 1864 8192000000 10908323248 11331633152 1938199200 19.132 100 70 140 1 1993646000 34181264 21265536
23:46:22 2326 8192000000 10914163072 11332296704 1943730560 19.177 100 67 134 1 1995886448 31904096 20251792
23:46:32 3462 8192000000 10905157872 11334610944 1940387504 19.150 100 61 122 3 1992225232 33292416 18545312
23:46:45 6217 8192000000 10910976944 11343032320 1945522928 19.191 100 54 108 2 1995177200 33288288 16365984
23:46:58 4829 8192000000 10909491536 11332300800 1934231664 19.101 100 60 118 1 1986793296 33697680 18863952
23:47:09 8505 8192000000 10887140864 11312562176 1884913408 18.705 97 57 114 1 1939816032 37134640 17767984
23:47:25 5088 8192000000 10921048720 11334254592 1937610272 19.128 100 71 136 1 1994801664 36841376 20350016
23:47:36 7028 8192000000 10923958720 11350052864 1948909744 19.218 100 54 106 2 2004308448 39033584 16365120
23:47:52 8915 8192000000 10926097600 11358380032 1933721696 19.097 99 44 88 0 1986168768 38667440 13779632
23:48:11 8743 8192000000 10908933856 11336232960 1924364480 19.022 99 37 72 1 1974555888 38288400 11903008
23:48:30 7345 8192000000 10917867952 11351318528 1948108128 19.211 100 36 70 0 2002836672 43340128 11388416
23:48:44 5438 8192000000 10929934464 11360964608 1956202000 19.276 100 39 78 0 2008425888 39299840 12924048
23:48:59 3832 8192000000 10928044352 11358400512 1940706448 19.152 99 47 94 2 1995349168 39936096 14706624
23:49:15 2167 8192000000 10937999648 11354746880 1943513552 19.175 99 81 159 1 2013982192 44128704 26339936
23:49:26 3069 8192000000 10940245424 11365412864 1957912512 19.289 100 64 125 0 2023417712 45230352 20274848
23:49:43 1727 8192000000 10962473552 11383783424 1970661952 19.391 100 69 138 2 2039105152 47024704 21418496
23:49:55 5573 8192000000 10967180304 11392843776 1978749536 19.455 100 71 142 2 2050537712 48919552 22868624
23:50:11 10872 8192000000 10960522992 11394842624 1973811872 19.416 100 51 102 0 2043841008 53368112 16661024
23:50:29 4514 8192000000 10962044928 11395768320 1979879840 19.464 100 58 116 2 2051707936 52522000 19306096
23:50:46 4662 8192000000 10962050368 11394822144 1973774432 19.415 100 45 90 2 2039949136 51445552 14729152
23:50:57 5776 8192000000 10960100800 11389288448 1969789360 19.384 100 58 116 2 2042774096 53713904 19270832
23:51:14 5546 8192000000 10938476432 11373613056 1931945824 19.082 98 46 92 0 1998851872 51822032 15084016
23:51:29 13053 8192000000 10939051296 11383418880 1963034816 19.330 100 38 76 2 2025604656 49834464 12735376
23:51:52 15316 8192000000 10939993136 11389571072 1962431312 19.325 100 30 60 1 2022586464 49778720 10376432
23:52:14 20937 8192000000 10937264896 11386281984 1961817040 19.320 100 32 64 1 2026941872 53710624 11414208
23:52:42 10130 8192000000 10946867264 11395485696 1972044896 19.402 100 35 71 0 2030886704 47551568 11290240
23:53:00 9145 8192000000 10944468832 11388600320 1955258320 19.268 99 35 68 0 2014936816 47814128 11864368
23:53:18 25701 8192000000 10951927216 11394658304 1973712080 19.415 100 42 82 1 2036975456 49976320 13287056
23:54:04 12669 8192000000 10959513584 11401687040 1977359664 19.444 100 49 98 0 2048050464 54956768 15734032
23:54:24 16103 8192000000 10958183392 11406843904 1972475728 19.405 100 39 78 1 2042719488 56607104 13636656
23:54:52 27054 8192000000 10971823536 11418558464 1973693040 19.415 100 33 66 2 2047357056 61766656 11897360
23:55:46 15651 8192000000 10969690928 11425042432 1976891632 19.440 100 31 62 1 2056213344 67670512 11651200
23:56:12 3555 8192000000 10968113136 11431280640 1972695392 19.407 100 26 52 0 2050745824 68250016 9800416
23:56:22 4240 8192000000 10963092704 11436654592 1973056192 19.410 100 22 44 2 2044957024 63713936 8186896
23:56:34 7721 8192000000 10959851648 11423907840 1968199856 19.371 100 23 46 1 2041501824 64634016 8667952
23:56:49 11676 8192000000 10965229872 11426238464 1968971840 19.377 100 23 46 2 2042102832 64657504 8473488
23:57:17 12628 8192000000 10954061728 11410317312 1953829552 19.257 99 23 45 2 2021226688 59395776 8001360
23:57:36 26434 8192000000 10933448768 11389898752 1948781296 19.217 99 26 52 0 2009605504 51585104 9239104
23:58:17 45725 8192000000 10939140928 11376648192 1929612912 19.064 99 21 42 0 1986280384 49684672 6982800
23:59:10 23243 8192000000 10935955248 11390513152 1954841760 19.265 100 37 73 2 2021026928 54255328 11929840
23:59:39 25923 8192000000 10934026368 11379953664 1956816896 19.281 100 27 53 1 2006238400 40206352 9215152
00:00:17 29641 8192000000 10922031888 11381649408 1937867584 19.130 99 13 26 0 1988860960 46247408 4745968
00:00:53 65684 8192000000 10863457248 11324616704 1889880736 18.745 97 11 22 0 1905591888 13036768 2674384
00:02:05 44144 8192000000 10893562128 11344392192 1922660896 19.008 98 46 93 0 1951200080 14644704 13894480
00:02:58 92425 8192000000 10897372272 11389652992 1930553648 19.071 99 12 24 0 1973122384 39256656 3312080
00:04:37 88972 8192000000 10905391776 11363221504 1942358112 19.166 99 16 33 1 1963413888 17058560 3997216
00:06:16 75185 8192000000 10900962032 11337121792 1931517648 19.079 98 41 82 1 1952337824 9291056 11529120
00:07:37 66101 8192000000 10893969328 11341447168 1945306432 19.189 99 32 62 1 1962390608 8104864 8979312
00:09:02 70740 8192000000 10898069456 11366789120 1949028976 19.219 99 34 69 3 1972167200 13171808 9966416
00:10:26 32699 8192000000 10899368896 11378380800 1968995568 19.377 100 9 18 0 1984399888 12615312 2789008
00:11:05 60183 8192000000 10908986720 11373412352 1974274480 19.419 100 10 21 0 1991053072 14429904 2348688
00:12:33 181167 8192000000 10903478160 11389677568 1955315008 19.269 99 6 12 1 1973538848 16197104 2026736
00:15:52 39081 8192000000 10908820512 11384455168 1980029760 19.465 100 10 20 1 1992657872 9247456 3380656
00:16:50 125894 8192000000 10917683824 11394023424 1992035872 19.560 100 15 31 1 2006253536 9912544 4305120
00:20:09 61734 8192000000 10907937760 11387576320 1939348816 19.142 97 20 40 1 1959052944 14024128 5680000
00:21:26 98802 8192000000 10893776656 11383222272 1962325440 19.325 99 20 40 2 1977267088 9367200 5574448
00:23:12 27180 8192000000 10904502912 11385745408 1968151376 19.371 99 10 20 2 1979489872 8699792 2638704
00:23:45 29110 8192000000 10926349968 11397971968 1978332944 19.451 99 38 76 1 2004011248 14467840 11210464
00:24:26 52146 8192000000 10923885504 11405680640 1994895952 19.582 100 20 40 0 2013082832 12075360 6111520
00:25:25 30439 8192000000 10931233696 11395096576 1983579168 19.493 99 33 66 0 2003401488 10281952 9540368
00:26:08 75350 8192000000 10932401280 11406090240 1996916896 19.598 100 17 34 1 2013778400 11637792 5223712
00:27:30 93412 8192000000 10929785120 11423113216 1987353024 19.523 99 19 38 4 2011798416 18714720 5730672
00:29:32 69164 8192000000 10917054944 11416911872 1963377728 19.333 98 13 26 1 1984308656 17017648 3913280
00:30:48 25270 8192000000 10887466912 11356188672 1939655440 19.144 97 16 33 2 1953800096 9772352 4372304
00:31:26 48008 8192000000 10882195744 11354976256 1880847792 18.672 95 22 44 0 1897390896 10021600 6521504
00:32:21 25798 8192000000 10869076464 11323817984 1862728992 18.525 95 32 63 1 1883584576 12375312 8480272
00:32:54 27127 8192000000 10892907712 11346604032 1926322928 19.037 99 33 66 1 1946262400 10759280 9180192
00:33:29 62880 8192000000 10848436384 11306262528 1777959152 17.833 91 32 64 1 1799352576 12401216 8992208
00:34:41 42901 8192000000 10874748448 11317530624 1884274272 18.700 98 34 68 3 1902408400 8843952 9290176
00:35:32 112077 8192000000 10859284224 11330093056 1856211216 18.473 96 26 52 0 1878668240 15198896 7258128
00:37:32 70185 8192000000 10858994496 11317678080 1862352288 18.522 96 17 34 0 1880083888 13634960 4096640
00:38:48 88462 8192000000 10885732096 11344068608 1892313200 18.764 98 18 36 1 1916568752 19193184 5062368
00:40:33 44747 8192000000 10880676304 11333775360 1909088160 18.899 98 31 63 0 1934412544 16582352 8742032
00:41:24 20487 8192000000 10882560528 11340488704 1922814544 19.009 99 37 73 2 1945242384 12501472 9926368
00:42:34 119603 8192000000 10875527072 11344326656 1938077904 19.131 100 26 52 1 1955198160 10002960 7117296
00:44:40 140275 8192000000 10884514032 11340283904 1879358768 18.660 96 25 50 0 1897102480 10478976 7264736
00:47:16 23217 8192000000 10863947536 11336695808 1929826928 19.065 99 27 54 1 1947904752 9826144 8251680
00:47:59 99695 8192000000 10843085680 11319885824 1865185360 18.545 96 14 28 0 1882049264 12581552 4282352
00:49:47 57879 8192000000 10844496016 11324170240 1875483840 18.629 97 16 32 0 1897882432 17385824 5012768
00:50:51 68207 8192000000 10847197296 11326697472 1905355312 18.869 99 11 23 2 1919336624 10503296 3478016
00:52:06 55384 8192000000 10845641568 11311616000 1916456544 18.958 99 17 33 0 1933199152 11744000 4998608
00:53:14 68396 8192000000 10854492384 11333509120 1916975056 18.963 99 12 24 2 1934390480 13635264 3780160
00:55:02 77787 8192000000 10850259120 11323641856 1887480640 18.725 97 22 44 1 1903002608 10070768 5451200
00:56:30 40705 8192000000 10859556832 11331084288 1883243808 18.691 97 23 46 1 1897596320 8157296 6195216
00:57:21 70330 8192000000 10879914304 11350142976 1915725984 18.953 98 25 48 2 1931906848 9659856 6521008
00:58:37 59158 8192000000 10902648672 11364786176 1938640032 19.136 99 16 32 1 1954450384 11410640 4399712
00:59:43 23071 8192000000 10904209744 11365969920 1954975056 19.266 99 48 96 0 1983006928 14098912 13932960
01:00:14 48858 8192000000 10885140752 11360620544 1962247040 19.324 100 23 45 3 1980128960 11702416 6179504
01:02:56 45240 8192000000 10896057056 11362951168 1961736288 19.320 100 12 24 1 1976210880 10760912 3713680
01:03:54 73551 8192000000 10923657952 11380011008 1943858880 19.178 98 27 53 0 1964149792 11896592 8394320
01:05:17 133747 8192000000 10915204944 11411226624 1953919712 19.258 99 15 31 0 1979936992 21706800 4310480
01:07:37 35213 8192000000 10924645952 11382681600 1969639280 19.383 99 43 87 1 1989087008 7751360 11696368
01:08:20 72757 8192000000 10911572048 11392106496 1945346416 19.189 98 30 60 0 1965696992 12094544 8256032
01:09:49 113597 8192000000 10902770464 11376119808 1962659552 19.327 99 20 40 0 1978418880 10605344 5153984
01:12:01 52159 8192000000 10908100592 11381731328 1976761536 19.439 100 21 42 1 1995787808 13624384 5401888
01:13:05 39987 8192000000 10906495504 11362328576 1941031248 19.155 98 35 70 0 1958259376 7232368 9995760
01:13:52 34529 8192000000 10908117504 11368370176 1968514320 19.374 100 43 84 3 1988934032 8998496 11421216
01:14:33 97354 8192000000 10891006512 11376762880 1955278464 19.268 99 6 12 0 1965432352 8632128 1521760
01:16:56 50901 8192000000 10876590640 11358638080 1901141344 18.835 96 13 26 3 1912981888 8060944 3779600
01:17:55 54545 8192000000 10859435680 11344334848 1933514256 19.095 99 9 18 2 1946661056 10616128 2530672
01:18:55 49865 8192000000 10873805408 11368882176 1960775920 19.312 100 26 52 0 1980887536 12309408 7802208
01:19:51 71009 8192000000 10833492256 11313647616 1821913664 18.193 93 20 39 0 1835391520 7911616 5566240
01:21:16 54632 8192000000 10858406032 11330277376 1900470368 18.830 98 23 46 1 1916976928 9319584 7186976
01:22:19 64760 8192000000 10850773744 11333984256 1903860000 18.857 98 15 30 1 1917351552 9268416 4223136
01:23:45 67900 8192000000 10865208400 11349794816 1925835968 19.034 99 13 26 0 1937676176 8120784 3719424
01:25:00 56844 8192000000 10858159088 11333951488 1879572112 18.662 96 16 32 1 1892164480 7983712 4608656
01:26:04 46009 8192000000 10877039264 11345223680 1908447072 18.894 98 18 36 0 1921682144 8240336 4994736
01:27:04 42474 8192000000 9484407264 9802727424 589940240 6.717 30 12 23 1 597080704 3979536 3160928

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 17-06-2021 01:29:13 to 17-06-2021 01:29:45.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 17-06-2021 01:29:46 to 17-06-2021 01:29:47.

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          236682
MON$OLDEST_ACTIVE               238928
MON$OLDEST_SNAPSHOT             238928
MON$NEXT_TRANSACTION            238928
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                       2079264
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.33474 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33474 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33474 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33474 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 ---
:89: 
:90: mscs-test-161.budzdorov.ru    Thu Jun 17 01:27:50 2021
:91:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:92: 
:93: 
:94: mscs-test-161.budzdorov.ru    Thu Jun 17 01:27:55 2021
:95:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:96: 
:97: 
:98: mscs-test-161.budzdorov.ru    Thu Jun 17 01:27:59 2021
:99:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:100: 
--- end of diff output ---

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

17.06.21 01:29:48. 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-06-17 01:29:51 No severe PSQL-related problems occured
17.06.21 01:29:52. End of report.