Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.06.2021 16: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 17259840 kB
MemAvailable 31399436 kB
Buffers 0 kB
Cached 14382192 kB
SwapCached 40 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-11 16:27:37
DTS_END                         2021-06-11 16:27:37.1700
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/53740
TRN_ID                          235287
ATT_ID                          654
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: 9291.83 20379 1115020
customer order: creation 164.52 411 19742
customer order: refuse 13.60 359 1632
order to supplier: creation 43.75 1258 5250
order to supplier: removal 3.38 104077 405
invoice (draft): creation 44.19 3742 5303
invoice (draft): removal 54.64 716 6557
invoice accept: apply 39.27 19794 4712
invoice accept: cancel 50.03 795 6004
customer reserve: creation 3665.43 194 439851
customer reserve: removal 4917.39 56 590087
realization accept: apply 79.03 202 9483
realization accept: cancel 93.47 113 11216
payment from customer: creation 56.52 151 6782
payment from customer: removal 5.15 84 618
payment to supplier: creation 46.66 179 5599
payment to supplier: removal 3.28 132 393
service: total inventory turnovers 4.59 1070 551
service: total monetary turnovers 6.20 23 744
service: aggregate perf. data 0.73 23931 87
service: refresh index statistics 0.03 250292 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-06-2021 16:28:33 to 11-06-2021 16:28:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4468
TEST_TIME 2 3954
TEST_TIME 3 4448
TEST_TIME 4 5230
TEST_TIME 5 5552
TEST_TIME 6 5594
TEST_TIME 7 5768
TEST_TIME 8 6053
TEST_TIME 9 5961
TEST_TIME 10 5787
TEST_TIME 11 5828
TEST_TIME 12 5802
TEST_TIME 13 5941
TEST_TIME 14 6141
TEST_TIME 15 6091
TEST_TIME 16 6316
TEST_TIME 17 6556
TEST_TIME 18 6884
TEST_TIME 19 7193
TEST_TIME 20 7425
TEST_TIME 21 7896
TEST_TIME 22 8066
TEST_TIME 23 8241
TEST_TIME 24 8520
TEST_TIME 25 8912
TEST_TIME 26 9034
TEST_TIME 27 10050
TEST_TIME 28 10206
TEST_TIME 29 10127
TEST_TIME 30 9942
TEST_TIME 31 10175
TEST_TIME 32 9949
TEST_TIME 33 9868
TEST_TIME 34 9694
TEST_TIME 35 9663
TEST_TIME 36 9568
TEST_TIME 37 9462
TEST_TIME 38 9547
TEST_TIME 39 9601
TEST_TIME 40 9606
TEST_TIME 41 9479
TEST_TIME 42 9370
TEST_TIME 43 9359
TEST_TIME 44 9402
TEST_TIME 45 9435
TEST_TIME 46 9490
TEST_TIME 47 9435
TEST_TIME 48 9608
TEST_TIME 49 9579
TEST_TIME 50 9557
TEST_TIME 51 9613
TEST_TIME 52 9555
TEST_TIME 53 9594
TEST_TIME 54 9594
TEST_TIME 55 9523
TEST_TIME 56 9699
TEST_TIME 57 9596
TEST_TIME 58 9448
TEST_TIME 59 9459
TEST_TIME 60 9412
TEST_TIME 61 9427
TEST_TIME 62 9371
TEST_TIME 63 9271
TEST_TIME 64 9166
TEST_TIME 65 9139
TEST_TIME 66 9327
TEST_TIME 67 9326
TEST_TIME 68 9385
TEST_TIME 69 9350
TEST_TIME 70 9393
TEST_TIME 71 9476
TEST_TIME 72 9558
TEST_TIME 73 9495
TEST_TIME 74 9476
TEST_TIME 75 9609
TEST_TIME 76 9538
TEST_TIME 77 9714
TEST_TIME 78 9715
TEST_TIME 79 9681
TEST_TIME 80 9602
TEST_TIME 81 9546
TEST_TIME 82 9557
TEST_TIME 83 9556
TEST_TIME 84 9524
TEST_TIME 85 9510
TEST_TIME 86 9492
TEST_TIME 87 9433
TEST_TIME 88 9407
TEST_TIME 89 9355
TEST_TIME 90 9317
TEST_TIME 91 9291
TEST_TIME 92 9267
TEST_TIME 93 9295
TEST_TIME 94 9291
TEST_TIME 95 9283
TEST_TIME 96 9366
TEST_TIME 97 9357
TEST_TIME 98 9372
TEST_TIME 99 9400
TEST_TIME 100 9412
TEST_TIME 101 9412
TEST_TIME 102 9414
TEST_TIME 103 9492
TEST_TIME 104 9459
TEST_TIME 105 9467
TEST_TIME 106 9393
TEST_TIME 107 9371
TEST_TIME 108 9364
TEST_TIME 109 9292
TEST_TIME 110 9254
TEST_TIME 111 9291
TEST_TIME 112 9234
TEST_TIME 113 9293
TEST_TIME 114 9273
TEST_TIME 115 9265
TEST_TIME 116 9285
TEST_TIME 117 9278
TEST_TIME 118 9270
TEST_TIME 119 9326
TEST_TIME 120 9293

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-06-2021 16:28:37 to 11-06-2021 16:28:40.

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 1522593 1522593 0 0.00 0 24500 6 0 0
doc_list_biud 1522591 1522591 0 0.00 0 32061 28 0 0
sp_add_invoice_to_stock 4804 4712 92 1.91 22 185969 19795 0 92
sp_cancel_adding_invoice 6004 6004 0 0.00 5 57741 796 0 0
sp_cancel_client_order 1632 1632 0 0.00 4 22486 359 0 0
sp_cancel_customer_reserve 590087 590087 0 0.00 1 20153 56 0 0
sp_cancel_pay_from_customer 618 618 0 0.00 3 9432 85 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 3 12727 132 0 0
sp_cancel_supplier_invoice 6564 6557 7 0.10 2 15983 716 0 7
sp_cancel_supplier_order 405 405 0 0.00 11 922743 104078 0 0
sp_cancel_write_off 11216 11216 0 0.00 1 12595 113 0 0
sp_client_order 19742 19742 0 0.00 4 18023 411 0 0
sp_customer_reserve 439851 439851 0 0.00 0 54482 195 0 0
sp_fill_shopping_cart 30290 30290 0 0.00 1 13237 37 0 0
sp_fill_shopping_cart_clo_res 439849 439849 0 0.00 0 23394 14 0 0
sp_get_clo_for_invoice 4710 4710 0 0.00 0 35823 329 0 0
sp_kill_cost_storno 18231 18231 0 0.00 0 13363 56 0 0
sp_kill_qstorno_ret_qs2qd 1198352 1198352 0 0.00 0 20150 30 0 0
sp_kill_qty_storno 630094 630094 0 0.00 0 32059 66 0 0
sp_lock_selected_doc 19687 19687 0 0.00 0 10882 6 0 0
sp_make_cost_storno 26574 26574 0 0.00 0 22843 62 0 0
sp_multiply_rows_for_pdistr 26574 26574 0 0.00 0 16021 41 0 0
sp_multiply_rows_for_qdistr 19742 19742 0 0.00 0 18014 191 0 0
sp_pay_from_customer 6782 6782 0 0.00 4 16041 152 0 0
sp_pay_to_supplier 5599 5599 0 0.00 5 18015 180 0 0
sp_payment_common 12381 12381 0 0.00 2 11802 34 0 0
sp_qd_handle_on_cancel_clo 1632 1632 0 0.00 0 22478 328 0 0
sp_qd_handle_on_invoice_upd_sts 10714 10714 0 0.00 0 32055 345 0 0
sp_qd_handle_on_reserve_upd_sts 9483 9483 0 0.00 0 18120 77 0 0
sp_reserve_write_off 9483 9483 0 0.00 6 18168 202 0 0
sp_supplier_invoice 5303 5303 0 0.00 6 98243 3743 0 0
sp_supplier_order 5250 5250 0 0.00 6 26222 1259 0 0
srv_aggregate_perf_data 87 87 0 0.00 2809 477533 23932 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1074 151143 33147 0 0
srv_find_qd_qs_mism 1069650 1069650 0 0.00 0 23447 5 0 0
srv_make_invnt_saldo 551 551 0 0.00 37 39198 1071 0 0
srv_make_money_saldo 744 744 0 0.00 1 723 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 83535 402295 250293 0 0
t$perf-abend:sp_add_invoice_to_stock 92 92 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4712 4712 0 0.00 0 14753 206 0 0
t$perf-norm:sp_cancel_adding_invoice 396 396 0 0.00 0 4706 136 0 0
t$perf-norm:sp_cancel_client_order 1632 1632 0 0.00 0 4434 22 0 0
t$perf-norm:sp_cancel_customer_reserve 677 677 0 0.00 0 489 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 618 618 0 0.00 0 4039 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 4241 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 393 393 0 0.00 0 651 12 0 0
t$perf-norm:sp_cancel_supplier_order 405 405 0 0.00 0 26299 1755 0 0
t$perf-norm:sp_cancel_write_off 981 981 0 0.00 0 7617 18 0 0
t$perf-norm:sp_client_order 19742 19742 0 0.00 0 13478 22 0 0
t$perf-norm:sp_customer_reserve 907 907 0 0.00 0 718 3 0 0
t$perf-norm:sp_pay_from_customer 6782 6782 0 0.00 0 14103 15 0 0
t$perf-norm:sp_pay_to_supplier 5599 5599 0 0.00 0 6625 16 0 0
t$perf-norm:sp_reserve_write_off 9483 9483 0 0.00 0 9834 16 0 0
t$perf-norm:sp_supplier_invoice 5303 5303 0 0.00 0 8149 18 0 0
t$perf-norm:sp_supplier_order 5250 5250 0 0.00 0 15508 19 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 398 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 619 9 0 0
t$perf-norm:srv_make_invnt_saldo 551 551 0 0.00 0 885 15 0 0
t$perf-norm:srv_make_money_saldo 744 744 0 0.00 0 3298 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 9602 9418 184 1.91 0 13191 22 0 184
v_all_customers 36270 36270 0 0.00 0 52 1 0 0
v_all_suppliers 29252 29252 0 0.00 0 21 1 0 0
v_all_wares 39484 39484 0 0.00 0 35 1 0 0
v_cancel_adding_invoice 792 792 0 0.00 0 3839 16 0 0
v_cancel_client_order 3264 3264 0 0.00 0 5492 8 0 0
v_cancel_customer_prepayment 1236 1236 0 0.00 0 2164 10 0 0
v_cancel_customer_reserve 1354 1354 0 0.00 0 2689 12 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 12704 24 0 0
v_cancel_supplier_invoice 800 786 14 1.75 0 3430 21 0 14
v_cancel_supplier_order 810 810 0 0.00 0 6533 21 0 0
v_cancel_write_off 1962 1962 0 0.00 0 4874 17 0 0
v_max_id_clo_ord 5250 5250 0 0.00 0 288 1 0 0
v_max_id_clo_res 907 907 0 0.00 0 1341 8 0 0
v_max_id_ord_sup 5298 5298 0 0.00 0 2197 2 0 0
v_max_non_paid_invoice 1521 1521 0 0.00 0 291 3 0 0
v_max_non_paid_realizn 3438 3438 0 0.00 0 6239 5 0 0
v_min_id_clo_ord 5250 5250 0 0.00 0 12878 14 0 0
v_min_id_clo_res 907 907 0 0.00 0 2360 7 0 0
v_min_id_ord_sup 5298 5298 0 0.00 0 7322 6 0 0
v_min_non_paid_invoice 5599 5599 0 0.00 0 6946 19 0 0
v_min_non_paid_realizn 6782 6782 0 0.00 0 9036 24 0 0
v_our_firm 9902 9902 0 0.00 0 17 1 0 0
v_reserve_write_off 18966 18966 0 0.00 0 9062 9 0 0
x_lock_depdocs_on_canc_invoice 12168 12168 0 0.00 0 11972 107 0 0
x_lock_depdocs_on_canc_sup_ord 405 405 0 0.00 0 17105 395 0 0
x_make_qstorno_1000_1200 5250 5250 0 0.00 2 26210 1171 0 0
x_make_qstorno_1200_2000 5303 5303 0 0.00 2 98025 3619 0 0
x_make_qstorno_2100_3300 439851 439851 0 0.00 0 54481 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-06-2021 16:28:41 to 11-06-2021 16:28:45.

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
13:57:40 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:46 21745 8192000000 10251319024 10556563456 892296480 9.822 71 54 110 1 912415616 2350496 17768640
13:58:16 28055 8192000000 10340320432 10656690176 1379585440 14.413 100 79 158 0 1411422720 4748672 27088608
13:58:52 16422 8192000000 10367179584 10691309568 1429617408 14.858 100 82 165 0 1461647152 5488320 26541424
13:59:17 25093 8192000000 10396290704 10723627008 1452096480 15.056 100 82 164 1 1485337472 6276816 26964176
13:59:56 28604 8192000000 10427142016 10756050944 1477315152 15.278 100 84 168 0 1511627024 7071840 27240032
14:00:33 18233 8192000000 10446297712 10778877952 1503861392 15.510 100 85 170 0 1539236416 7603440 27771584
14:01:00 18998 8192000000 10465610016 10798006272 1520162816 15.652 100 92 184 0 1557912208 8348384 29401008
14:01:32 22487 8192000000 10484522480 10822524928 1543838944 15.857 100 91 181 0 1581490832 9174528 28477360
14:02:16 19919 8192000000 10510371296 10861445120 1561971888 16.013 100 71 142 0 1593599984 9684032 21944064
14:02:52 9977 8192000000 10531773184 10893283328 1595673936 16.302 100 63 126 2 1625041280 9868304 19499040
14:03:12 12868 8192000000 10585721264 10944266240 1645528032 16.727 100 86 171 1 1680989856 9821840 25639984
14:03:32 12321 8192000000 10609416096 10972655616 1666158752 16.901 100 74 148 1 1698443808 10347216 21937840
14:03:53 9611 8192000000 10634773408 10998288384 1686739056 17.074 100 81 162 0 1722786704 11930336 24117312
14:04:11 9284 8192000000 10634520256 11009773568 1696655120 17.157 100 71 142 1 1729241456 12145312 20441024
14:04:29 7639 8192000000 10660748032 11032420352 1720809296 17.359 100 79 158 3 1756781408 12649840 23322272
14:04:44 9885 8192000000 10671414224 11048640512 1732003792 17.452 100 69 139 0 1763029200 10845232 20180176
14:05:03 8845 8192000000 10688485136 11063525376 1749120272 17.594 100 82 164 0 1783886320 11739008 23027040
14:05:19 7798 8192000000 10700783568 11083042816 1764124512 17.718 100 79 158 0 1799474128 12980912 22368704
14:05:38 4461 8192000000 10709358416 11094577152 1775576896 17.813 100 79 155 2 1810173104 12958608 21637600
14:05:52 4568 8192000000 10722274960 11105185792 1782941248 17.874 100 81 162 1 1818995136 13687344 22366544
14:06:04 4625 8192000000 10744359008 11121315840 1797574736 17.994 100 92 185 0 1837912912 14755472 25582704
14:06:17 10086 8192000000 10729712608 11119632384 1797235456 17.991 100 82 162 2 1834454912 14457776 22761680
14:06:34 4323 8192000000 10744566176 11129237504 1797894496 17.997 100 73 147 2 1831740528 12988288 20857744
14:06:45 3962 8192000000 10753110048 11142008832 1816217712 18.147 100 79 158 2 1851342656 13096144 22028800
14:06:57 2556 8192000000 10766740752 11148701696 1821382736 18.189 100 91 182 1 1860928752 13887872 25658144
14:07:06 2875 8192000000 10777232912 11163938816 1831602064 18.272 100 86 172 3 1869217424 14030272 23585088
14:07:15 2987 8192000000 10770716304 11163049984 1837549472 18.321 100 86 170 3 1874669008 13403888 23715648
14:07:25 3892 8192000000 10784973760 11169050624 1839420688 18.336 100 90 178 0 1878382912 14549184 24413040
14:07:36 2264 8192000000 10785720848 11174666240 1844422336 18.377 100 88 177 0 1882339696 13535072 24382288
14:07:45 2995 8192000000 10799851776 11186384896 1851327184 18.433 100 89 176 0 1888895312 13847984 23720144
14:07:55 1918 8192000000 10797972752 11184881664 1852617536 18.443 100 90 180 3 1892319840 14621856 25080448
14:08:04 1464 8192000000 10810196544 11193618432 1858859488 18.494 100 89 180 0 1897982944 13828656 25294800
14:08:12 1900 8192000000 10807479056 11194757120 1863029584 18.528 100 93 187 1 1902503776 13331616 26142576
14:08:21 2538 8192000000 10802253168 11194961920 1863924624 18.535 100 76 152 1 1897877056 12825296 21127136
14:08:30 2286 8192000000 10807861040 11198283776 1867662736 18.565 100 93 186 1 1907330848 14230032 25438080
14:08:38 1631 8192000000 10804564160 11195506688 1864589472 18.540 100 86 172 1 1902692864 13571056 24532336
14:08:47 1282 8192000000 10809635296 11198214144 1865305024 18.546 100 89 173 2 1903882928 13239248 25338656
14:09:01 1402 8192000000 10814615984 11201597440 1869889264 18.583 100 88 175 2 1907891088 13754624 24247200
14:09:08 1865 8192000000 10821360320 11207135232 1873495760 18.613 100 92 184 1 1914245184 14179520 26569904
14:09:16 2045 8192000000 10824230992 11211239424 1876850944 18.640 100 89 181 0 1917288224 13219856 27217424
14:09:25 2539 8192000000 10823467696 11209207808 1873504928 18.613 100 84 167 2 1911659184 12945312 25208944
14:09:34 1494 8192000000 10817718000 11206418432 1876633024 18.638 100 88 178 1 1913807232 11878800 25295408
14:09:41 1177 8192000000 10825395184 11211485184 1878498624 18.653 100 92 184 1 1918664224 12718336 27447264
14:09:49 1997 8192000000 10825683408 11216687104 1878687184 18.655 100 90 180 1 1917863136 13217984 25957968
14:09:57 27740 8192000000 10802816048 11211010048 1880432960 18.669 100 69 138 2 1910769744 11297888 19038896
14:10:32 2583 8192000000 10794406192 11209924608 1875253456 18.627 100 62 124 2 1902691536 10092240 17345840
14:10:41 4885 8192000000 10803520224 11214147584 1874997200 18.625 100 41 81 1 1894303424 8129600 11176624
14:10:52 8055 8192000000 10787076432 11211010048 1875096240 18.625 100 23 45 1 1888289088 7338304 5854544
14:11:07 10263 8192000000 10791771472 11214057472 1878885856 18.656 100 18 36 2 1889377920 5650128 4841936
14:11:23 8806 8192000000 10788982624 11218313216 1879798176 18.663 100 25 50 0 1893360880 6897936 6664768
14:11:39 12158 8192000000 10785115872 11215736832 1881313728 18.676 100 18 34 2 1891796064 5335472 5146864
14:11:57 16043 8192000000 10784214400 11222482944 1883518240 18.694 100 14 27 0 1892752240 5208608 4025392
14:12:20 12605 8192000000 10794117472 11224707072 1885531840 18.710 100 18 36 2 1900776608 10135552 5109216
14:12:40 11325 8192000000 10793079264 11226324992 1888173200 18.731 100 15 26 1 1896990592 5401584 3415808
14:13:00 5682 8192000000 10799605664 11228708864 1892586048 18.767 100 29 57 1 1906577952 5894720 8097184
14:13:13 11053 8192000000 10808390576 11233447936 1890395632 18.749 100 27 54 2 1905033440 6989072 7648736
14:13:33 13981 8192000000 10801465344 11230654464 1903096288 18.851 100 42 86 1 1921751024 6219008 12435728
14:13:53 72118 8192000000 10809896656 11245723648 1895195184 18.788 100 24 48 1 1907486848 5201296 7090368
14:15:13 7656 8192000000 10814758704 11249917952 1898790368 18.817 100 28 54 2 1913369360 7359936 7219056
14:15:28 7784 8192000000 10823289312 11254587392 1901756640 18.840 100 14 28 1 1911522256 6008544 3757072
14:15:43 6220 8192000000 10826462928 11259572224 1910873440 18.914 100 32 62 4 1926719552 6838768 9007344
14:16:00 4004 8192000000 10813003408 11246968832 1891777104 18.760 99 31 62 0 1906685664 6174288 8734272
14:16:12 7818 8192000000 10821238640 11259142144 1905229344 18.868 100 20 40 0 1917216912 5502912 6484656
14:16:27 7414 8192000000 10808139616 11244462080 1895868912 18.793 100 24 49 1 1908729392 5577936 7282544
14:16:42 5070 8192000000 10810028304 11242442752 1877659712 18.646 99 22 44 2 1889728608 6020912 6047984
14:16:53 6979 8192000000 10782157264 11212365824 1842174368 18.359 97 21 42 2 1854875984 5851344 6850272
14:17:06 7248 8192000000 10807012368 11238666240 1872774528 18.607 99 22 44 3 1884772736 5583072 6415136
14:17:24 9006 8192000000 10796032096 11225657344 1864240800 18.538 99 22 45 1 1876180640 5613488 6326352
14:17:44 9494 8192000000 10784161936 11219107840 1862786864 18.526 99 26 52 0 1876592672 6022768 7783040
14:18:05 8207 8192000000 10760427280 11187716096 1785412208 17.894 95 24 48 1 1798365392 5800896 7152288
14:18:20 7796 8192000000 10758867680 11181699072 1821991232 18.194 99 18 36 2 1832490576 5084208 5415136
14:18:34 20326 8192000000 10708738912 11122028544 1704371600 17.222 92 27 54 3 1717226608 5133024 7721984
14:19:04 40478 8192000000 10744390240 11128823808 1766450736 17.738 97 54 105 2 1788060960 5924688 15685536
14:19:51 14417 8192000000 10727010752 11147882496 1749856112 17.600 96 18 36 1 1760864704 5158128 5850464
14:20:13 7276 8192000000 10706573296 11127017472 1715745952 17.317 95 19 38 1 1726883504 5597984 5539568
14:20:27 5543 8192000000 10675566864 11075969024 1694152416 17.136 95 42 84 5 1712896816 5775712 12968688
14:20:39 5388 8192000000 10693603536 11099111424 1766801552 17.741 100 38 76 5 1784758624 7242128 10714944
14:20:51 6076 8192000000 10699841760 11102482432 1721046128 17.361 96 41 83 2 1742686976 9786064 11854784
14:21:04 6528 8192000000 10693505248 11099332608 1740424192 17.522 98 27 54 0 1753366688 4835408 8107088
14:21:19 3979 8192000000 10694944528 11092484096 1749813472 17.600 98 37 74 2 1766934608 5229568 11891568
14:21:31 4155 8192000000 10699230032 11114815488 1759275776 17.678 98 30 60 1 1775014832 7239504 8499552
14:21:44 11128 8192000000 10714006000 11129147392 1794035984 17.965 99 32 63 3 1809095168 6436320 8622864
14:22:03 8226 8192000000 10709739472 11137130496 1771466400 17.779 97 19 39 1 1782132464 5238704 5427360
14:22:18 7766 8192000000 10744687536 11162640384 1818707088 18.167 100 28 56 1 1832932336 5298272 8926976
14:22:33 9049 8192000000 10751179040 11165798400 1781032544 17.858 97 34 68 1 1797284688 4815872 11436272
14:22:48 13459 8192000000 10761731808 11182108672 1838173696 18.326 100 36 71 4 1854473648 5048400 11251552
14:23:09 15844 8192000000 10763963184 11191312384 1847580688 18.402 100 31 63 0 1862831456 5191120 10059648
14:23:34 74671 8192000000 10759797696 11197292544 1854984704 18.463 100 30 60 1 1869754064 5467616 9301744
14:24:55 14159 8192000000 10772254864 11205386240 1863296816 18.530 100 22 43 1 1875078832 5722736 6059280
14:25:20 8284 8192000000 10788530384 11216433152 1869928688 18.584 100 33 66 3 1885670304 6560096 9181520
14:25:36 6210 8192000000 10800927232 11223371776 1876653520 18.638 100 30 60 3 1893694080 7887840 9152720
14:25:52 10769 8192000000 10796294096 11228028928 1882294368 18.684 100 17 34 0 1892110944 5161248 4655328
14:26:13 9491 8192000000 10798921392 11227336704 1883535504 18.694 100 31 62 4 1898707696 5222880 9949312
14:26:29 10891 8192000000 10799498912 11236425728 1884504400 18.701 100 23 47 0 1901483872 10250128 6729344
14:26:48 7006 8192000000 10801723120 11233665024 1887210944 18.723 100 25 50 3 1900213232 5261856 7740432
14:27:01 11791 8192000000 10807923872 11242180608 1897355424 18.805 100 20 41 1 1907549088 5188960 5004704
14:27:19 9869 8192000000 10820424064 11249807360 1905590480 18.871 100 25 50 1 1917741888 5035248 7116160
14:27:37 9280 8192000000 10841626656 11258474496 1911024528 18.915 100 36 69 2 1925651328 4908688 9718112
14:28:08 3984 8192000000 10860111728 11280470016 1926244912 19.037 100 60 118 3 1951744704 8164256 17335536
14:28:24 3488 8192000000 10870181008 11288772608 1934564912 19.103 100 77 156 1 1966621328 9635024 22421392
14:28:45 85048 8192000000 10867792016 11296473088 1921057360 18.995 99 44 88 1 1942703856 8360720 13285776
14:30:21 34074 8192000000 10874198928 11304030208 1942339232 19.165 100 42 85 1 1964265232 9059696 12866304
14:31:05 25237 8192000000 10885184224 11313205248 1952764496 19.248 100 52 103 0 1977993696 10840592 14388608
14:31:38 3907 8192000000 10892059840 11318181888 1955877424 19.273 100 64 128 1 1984625008 10366912 18380672
14:31:49 12864 8192000000 10905158720 11324575744 1959467344 19.302 100 63 126 2 1988671248 11640032 17563872
14:32:11 12316 8192000000 10906492480 11330719744 1961639200 19.319 100 57 114 0 1992011344 14758256 15613888
14:32:31 4816 8192000000 10906299984 11334221824 1969436464 19.381 100 72 139 1 2003982752 14824112 19722176
14:32:45 7312 8192000000 10917815984 11344461824 1974900864 19.424 100 64 128 1 2008329760 14819584 18609312
14:33:03 17718 8192000000 10931009264 11358482432 1984249648 19.498 100 61 123 0 2018626352 17280368 17096336
14:33:28 9129 8192000000 10910122512 11340738560 1963310608 19.332 99 67 135 1 1999492320 17209792 18971920
14:33:51 1074 8192000000 10921383328 11353571328 1978630592 19.454 100 55 110 0 2014026976 19268352 16128032
14:34:13 11494 8192000000 10919312032 11351629824 1959882704 19.305 99 63 123 1 1998437264 20371328 18183232
14:34:36 12327 8192000000 10927236048 11356704768 1975492928 19.429 100 52 104 1 2011845584 21138672 15213984
14:35:13 3245 8192000000 10914640320 11352330240 1973293728 19.412 100 50 100 0 2008145200 20095248 14756224
14:35:28 2588 8192000000 10918321840 11348049920 1975584624 19.430 100 64 129 1 2013953408 20153472 18215312
14:35:43 16146 8192000000 10908377776 11342192640 1953631712 19.255 99 43 86 2 1987504032 21292592 12579728
14:36:07 4164 8192000000 10904820144 11334971392 1952407648 19.246 99 54 104 0 1988034288 20653680 14972960
14:36:20 28462 8192000000 10911144016 11347693568 1965080848 19.346 100 43 85 2 1998684528 21414528 12189152
14:36:56 12547 8192000000 10904172832 11337777152 1933934704 19.098 98 44 87 1 1967139888 20420416 12784768
14:37:18 7702 8192000000 10923936048 11356606464 1976080368 19.434 100 57 111 3 2013670384 21140096 16449920
14:37:34 11167 8192000000 10940867824 11367501824 1984324032 19.499 100 57 114 0 2023616272 22740288 16551952
14:37:57 21332 8192000000 10939831600 11372326912 1989123952 19.537 100 56 113 1 2029247488 23723488 16400048
14:38:27 7596 8192000000 10942117408 11377491968 1993192192 19.569 100 53 106 3 2033303552 24208496 15902864
14:38:42 5099 8192000000 10949616080 11379744768 1995422304 19.587 100 55 110 1 2036247968 24351552 16474112
14:38:57 5300 8192000000 10949821408 11379548160 1996529216 19.595 100 59 118 1 2039876480 25423536 17923728
14:39:10 3699 8192000000 10952327280 11373199360 1974777616 19.423 99 69 136 1 2022664672 27673760 20213296
14:39:21 4798 8192000000 10941709184 11367460864 1982294576 19.483 100 75 150 2 2034347120 29479936 22572608
14:39:36 3081 8192000000 10918989440 11339866112 1959178208 19.300 99 68 135 1 2007723872 28738944 19806720
14:39:47 2517 8192000000 10895139168 11320745984 1942030592 19.163 99 65 130 5 1990848368 28492112 20325664
14:40:11 8697 8192000000 10936320880 11361402880 1970509376 19.389 100 60 119 1 2020901472 32542128 17849968
14:40:26 10275 8192000000 10945324736 11372281856 1976609648 19.438 100 56 112 1 2026727248 32861008 17256592
14:40:45 4440 8192000000 10938220736 11376185344 1981885392 19.480 100 50 100 0 2032166864 34391552 15889920
14:40:57 5440 8192000000 10933429072 11358814208 1943291856 19.173 98 57 113 0 1995836288 34942160 17602272
14:41:13 6580 8192000000 10936890016 11363024896 1973001424 19.409 100 58 116 3 2024145840 33380224 17764192
14:41:26 8432 8192000000 10949731184 11374686208 1981840592 19.479 100 65 130 1 2035985344 34349664 19795088
14:41:45 13964 8192000000 10945197104 11375087616 1984927888 19.504 100 51 102 3 2034486832 34245248 15313696
14:42:10 14858 8192000000 10944711296 11375927296 1951185424 19.236 98 48 95 0 2001621984 35900704 14535856
14:42:34 1525 8192000000 10971984192 11393671168 1993905792 19.575 100 67 129 1 2052391680 39083184 19402704
14:42:42 3792 8192000000 10957655312 11373101056 1955702240 19.272 98 70 136 0 2016725344 41130368 19892736
14:42:54 1842 8192000000 10971509360 11378950144 1980110448 19.466 100 82 160 0 2047970896 42409808 25450640
14:43:08 5298 8192000000 10951328144 11380797440 1979226336 19.459 100 52 104 1 2039136144 43220928 16688880
14:43:24 1812 8192000000 10963317424 11383791616 1983488320 19.492 100 79 157 3 2052354864 43621488 25245056
14:43:35 3542 8192000000 10958743184 11376021504 1964773328 19.344 99 75 150 1 2031163104 42413648 23976128
14:43:45 5236 8192000000 10959735296 11381526528 1980266384 19.467 100 67 134 0 2048429680 46953104 21210192
14:44:03 1946 8192000000 10961815216 11379580928 1965206464 19.347 99 72 143 3 2034206992 47165408 21835120
14:44:14 3511 8192000000 10956363776 11379023872 1975469216 19.429 100 72 144 0 2047536736 48768800 23298720
14:44:28 5234 8192000000 10952624112 11373236224 1966525824 19.358 100 69 138 0 2039626912 50889376 22211712
14:44:43 2684 8192000000 10969770752 11386957824 1981369600 19.476 100 81 159 1 2057488512 50265936 25852976
14:44:55 5306 8192000000 10958857008 11385982976 1963531664 19.334 99 65 130 1 2033988960 48838752 21618544
14:45:08 6422 8192000000 10978909056 11404398592 1991361760 19.555 100 73 145 2 2065724128 51242064 23120304
14:45:27 3749 8192000000 10971587584 11394916352 1976911952 19.440 99 79 158 1 2045424608 43587184 24925472
14:45:37 5986 8192000000 10986926704 11395551232 1991131424 19.553 100 82 161 0 2060651520 44580880 24939216
14:45:52 1723 8192000000 10980496240 11400855552 1991367456 19.555 100 67 134 0 2058046096 45253904 21424736
14:46:01 2555 8192000000 10983000768 11395727360 1990774176 19.550 100 81 160 2 2062212336 46003920 25434240
14:46:10 1209 8192000000 10984052288 11397496832 1984966928 19.504 100 92 182 1 2065499472 51205808 29326736
14:46:18 5719 8192000000 10947760752 11358584832 1941081760 19.155 98 83 166 0 2020490640 53339264 26069616
14:46:35 5610 8192000000 10961617504 11379666944 1964434272 19.341 100 69 137 0 2039816144 53107824 22274048
14:46:53 3406 8192000000 10979121952 11390869504 1976838112 19.440 100 81 163 1 2055247328 52008800 26400416
14:47:03 2802 8192000000 10958694816 11368943616 1963513280 19.334 100 84 163 0 2035599520 46064832 26021408
14:47:15 3540 8192000000 10972684192 11384303616 1972607952 19.406 100 77 153 1 2045488032 48136176 24743904
14:47:25 3706 8192000000 10958441328 11378450432 1967302320 19.364 100 75 148 1 2040309872 49804928 23202624
14:47:39 3492 8192000000 10973526080 11390803968 1977159328 19.442 100 80 161 0 2053740720 51275984 25305408
14:47:49 1834 8192000000 10980997664 11392000000 1980351680 19.467 100 89 179 2 2055599568 48191616 27056272
14:47:58 5221 8192000000 10968871552 11387084800 1976590160 19.438 100 69 136 1 2045584992 47972496 21022336
14:48:10 7469 8192000000 10940648656 11368517632 1950424192 19.230 99 67 134 1 2021757088 50851520 20481376
14:48:25 7050 8192000000 10942014400 11380133888 1965746288 19.352 100 58 116 1 2032701600 48605584 18349728
14:48:51 8669 8192000000 10927314272 11363893248 1944829264 19.185 99 42 84 0 2000988624 42411616 13747744
14:49:10 5932 8192000000 10933621456 11371880448 1967221248 19.363 100 51 100 2 2025240992 41112224 16907520
14:49:23 6529 8192000000 10907205296 11340914688 1935146992 19.108 99 40 81 1 1984096128 35837136 13112000
14:49:36 19101 8192000000 10928248896 11360555008 1951310784 19.237 100 43 86 1 2005121856 39816544 13994528
14:50:10 17352 8192000000 10899492992 11333414912 1901083792 18.835 98 42 80 3 1957079712 42025456 13970464
14:50:40 14926 8192000000 10870319184 11312033792 1902830704 18.849 99 30 60 3 1957228896 43358832 11039360
14:51:05 7503 8192000000 10888335008 11325526016 1914273424 18.941 100 38 76 2 1971610896 44027824 13309648
14:51:31 18138 8192000000 10888213936 11337371648 1929645120 19.064 100 30 60 2 1984976016 45285888 10045008
14:52:17 32594 8192000000 10894217888 11333869568 1894702272 18.784 98 31 62 2 1952187056 46142208 11342576
14:52:57 16307 8192000000 10888491408 11337793536 1921030224 18.995 100 22 44 0 1972418416 43138960 8249232
14:53:21 24123 8192000000 10880084384 11322486784 1896656448 18.799 99 27 54 1 1948456928 41915408 9885072
14:53:53 32751 8192000000 10891345776 11351183360 1918644592 18.976 100 21 42 2 1972914832 46691264 7578976
14:55:06 33623 8192000000 10873492992 11295940608 1882324592 18.684 98 31 61 0 1911785248 19922064 9538592
14:55:48 20789 8192000000 10832579472 11288969216 1867354016 18.563 98 21 42 2 1888205712 14792288 6059408
14:56:16 83224 8192000000 10849761680 11284451328 1856679776 18.476 97 21 42 1 1878818576 16119296 6019504
14:58:05 8996 8192000000 10874081296 11304779776 1922869920 19.010 100 52 100 1 1953024544 15901584 14253040
14:58:39 116066 8192000000 10850153808 11305922560 1907430400 18.886 99 25 51 1 1927592976 13012560 7150016
15:00:47 21626 8192000000 10862537584 11317714944 1938669680 19.136 100 30 60 1 1956318224 9326240 8322304
15:01:16 52328 8192000000 10903295792 11336683520 1937439056 19.126 99 61 118 4 1966074576 11778816 16856704
15:02:16 3558 8192000000 10919108336 11348803584 1964295904 19.340 100 65 128 2 1996183088 13217248 18669936
15:02:26 30492 8192000000 10906265120 11353497600 1963404992 19.333 100 39 78 1 1988267632 13634592 11228048
15:03:10 39400 8192000000 10924229968 11372716032 1979356432 19.460 100 41 82 2 2007306448 15941136 12008880
15:03:56 35105 8192000000 10931565072 11377893376 1985762032 19.510 100 28 56 0 2011574960 17840304 7972624
15:04:46 3547 8192000000 10926661520 11368837120 1971396800 19.397 99 68 138 1 2008693440 18444672 18851968
15:04:57 32480 8192000000 10909736080 11375599616 1977325824 19.444 100 34 68 0 2008488288 20613760 10548704
15:05:38 54581 8192000000 10902215776 11380359168 1970677488 19.391 100 16 32 2 1999978320 24060384 5240448
15:06:54 30397 8192000000 10896835088 11370582016 1953449392 19.254 99 13 26 0 1977916384 20369648 4097344
15:07:40 61465 8192000000 10898474384 11370102784 1957843232 19.289 99 11 22 0 1976412752 15234336 3335184
15:08:48 47816 8192000000 10892763472 11349938176 1958896864 19.297 99 19 39 1 1982563824 17162064 6504896
15:09:44 31199 8192000000 10893230896 11365019648 1971556368 19.398 100 18 36 0 1993008880 15621840 5830672
15:10:31 22715 8192000000 10908422688 11376742400 1971814032 19.400 100 20 39 0 1991517520 14278416 5425072
15:11:00 35821 8192000000 10896163408 11387609088 1970357088 19.388 100 5 10 1 1985629088 14009120 1262880
15:11:43 21231 8192000000 10896799424 11367276544 1973445600 19.413 100 10 20 0 1991236928 14858688 2932640
15:12:16 109779 8192000000 10925403872 11385188352 1980094480 19.465 100 8 16 0 2004100272 21674752 2331040
15:14:17 31084 8192000000 10937810000 11391098880 2004989104 19.662 100 51 102 0 2030904576 11293360 14622112
15:15:08 87047 8192000000 10926000224 11415511040 2002150896 19.640 100 19 38 1 2026612080 18840720 5620464
15:16:42 115320 8192000000 10889295696 11367129088 1900831792 18.833 95 14 29 0 1920853952 16454640 3567520
15:18:43 22357 8192000000 10894435888 11355111424 1924235552 19.021 97 30 58 0 1942098848 9454368 8408928
15:19:26 41516 8192000000 10924889296 11381272576 1983490416 19.492 100 26 52 0 2000088784 9471456 7126912
15:20:20 81228 8192000000 10887572624 11362099200 1913809392 18.937 97 19 38 0 1931416704 12330640 5276672
15:21:55 38612 8192000000 10931936976 11382992896 1990549008 19.548 100 30 60 2 2009864016 10885424 8429584
15:22:48 37451 8192000000 10924568304 11389558784 1985579088 19.509 100 23 46 3 2007157632 14680832 6897712
15:23:36 77264 8192000000 10903225760 11374563328 1943586288 19.175 98 10 20 0 1956836064 10830640 2419136
15:25:08 94634 8192000000 10905443216 11376082944 1941456944 19.158 98 30 60 1 1961988096 11977744 8553408
15:27:02 64461 8192000000 10879178912 11338997760 1916563168 18.959 97 25 50 0 1937716080 14312144 6840768
15:28:13 51530 8192000000 10875657184 11349696512 1951398192 19.238 99 26 52 3 1968708096 9331616 7978288
15:29:13 58720 8192000000 10879762016 11347652608 1910399632 18.910 97 18 37 0 1923481728 8407248 4674848
15:30:18 73888 8192000000 10893220896 11358453760 1956011152 19.274 99 27 54 0 1975399408 11801184 7587072
15:31:39 59959 8192000000 10895871440 11368972288 1954530144 19.263 99 13 26 2 1971175136 12732384 3912608
15:33:31 58688 8192000000 10898219568 11368243200 1934500112 19.103 98 12 24 1 1949920768 12058544 3362112
15:34:38 58392 8192000000 10892452336 11373015040 1917013984 18.963 97 10 20 1 1935636624 14983216 3639424
15:35:53 64611 8192000000 10907791264 11374415872 1942457072 19.166 98 21 42 0 1965238384 16243504 6537808
15:37:18 56616 8192000000 10915100592 11381395456 1924953776 19.027 97 24 48 1 1945313248 13437616 6921856
15:38:35 79778 8192000000 10877868256 11360075776 1851936800 18.438 94 13 26 0 1875655344 20164448 3554096
15:40:02 66462 8192000000 10917564912 11368747008 1919685456 18.984 98 24 48 2 1939660112 13269440 6705216
15:41:15 53780 8192000000 10887424720 11362127872 1908310272 18.893 97 30 60 0 1929250576 12081600 8858704
15:42:21 68771 8192000000 10887448752 11343728640 1917414592 18.966 98 28 56 2 1943048736 17903552 7730592
15:43:40 62387 8192000000 10885006256 11375820800 1931415152 19.078 99 14 28 0 1953173296 17717248 4040896
15:44:53 103339 8192000000 10863085808 11316592640 1781393856 17.861 91 19 38 1 1797807552 11521616 4892080
15:46:45 80885 8192000000 10876080880 11334234112 1939558288 19.143 100 38 76 0 1963545056 13283200 10703568
15:48:16 151143 8192000000 10880476400 11357298688 1901716144 18.840 97 33 67 1 1922763952 10736832 10310976
15:51:06 20162 8192000000 10872852224 11330830336 1908128768 18.892 98 24 48 0 1927673888 12415632 7129488
15:51:34 15006 8192000000 10822223360 11283234816 1899063488 18.819 99 8 14 0 1910161536 8241088 2856960
15:51:56 70689 8192000000 10841009776 11312332800 1891957936 18.762 98 20 40 0 1905249344 7701808 5589600
15:53:12 40944 8192000000 10857277968 11331784704 1937665712 19.128 100 14 28 0 1948398080 6658416 4073952
15:53:59 74804 8192000000 10863323728 11340914688 1932499712 19.087 99 13 26 2 1943798304 7791248 3507344
15:55:32 47240 8192000000 10881579376 11349590016 1935074912 19.107 99 27 54 2 1953722032 10863296 7783824
15:56:26 54182 8192000000 10897371136 11370737664 1961609152 19.319 100 16 32 1 1977484416 11465488 4409776
15:58:16 24420 8192000000 10881027648 11354718208 1949497184 19.222 99 36 71 3 1967370176 7894672 9978320
15:58:57 48081 8192000000 10892505344 11367870464 1955877760 19.273 99 17 34 0 1970824272 10811488 4135024
15:59:52 49190 8192000000 10889986880 11380379648 1960459504 19.310 99 13 26 2 1975881792 11896656 3525632
16:00:48 99345 8192000000 10908196352 11381837824 1920000528 18.987 97 14 28 1 1934715264 10745536 3969200
16:02:33 27613 8192000000 10926292128 11395002368 1991627040 19.557 100 33 65 3 2015216032 13516560 10072432
16:03:26 59364 8192000000 10911112688 11395895296 1982328448 19.483 100 8 16 0 1997006976 12369200 2309328
16:04:31 61538 8192000000 10902884096 11376848896 1911673968 18.920 96 17 34 1 1932431072 15753056 5004048
16:05:50 137376 8192000000 10905819472 11397689344 1916176864 18.956 97 21 42 0 1940159904 18519856 5463184
16:08:18 63521 8192000000 10937956704 11401977856 1925717520 19.033 97 29 57 1 1951049600 17071472 8260608
16:10:39 41475 8192000000 10928345408 11391684608 1987821792 19.527 100 21 42 0 2006455024 13006800 5626432
16:11:27 56020 8192000000 10915239072 11366682624 1896635360 18.799 95 38 76 0 1922031872 14714080 10682432
16:13:12 81191 8192000000 10887114048 11361595392 1951952496 19.242 100 26 52 0 1966908368 7787776 7168096
16:14:44 32009 8192000000 10904749056 11368714240 1970301232 19.388 100 28 56 1 1985363088 7498592 7563264
16:15:22 78139 8192000000 10902437168 11384164352 1979058416 19.457 100 22 44 1 2000211616 15032048 6121152
16:16:48 82538 8192000000 10916884144 11403276288 1983609968 19.493 100 12 24 0 2002004960 15473552 2921440
16:18:17 63800 8192000000 10901909680 11391094784 1928367872 19.054 97 11 22 0 1948517056 16814384 3334800
16:19:27 101950 8192000000 10878457232 11373273088 1951101856 19.235 99 13 26 1 1973085472 17750704 4232912
16:21:15 44333 8192000000 10904898816 11382837248 1969453968 19.381 100 8 17 0 1981766160 10228848 2083344
16:22:09 64258 8192000000 10881459344 11368333312 1907630320 18.888 96 30 60 1 1926152832 9859680 8662832
16:23:25 55794 8192000000 10897800448 11371876352 1951940560 19.242 99 14 28 1 1969832304 13538784 4352960
16:24:28 48518 8192000000 10899650912 11383791616 1953583376 19.255 99 19 38 0 1978439088 18501776 6353936
16:25:23 92771 8192000000 10874581376 11353927680 1897623008 18.807 96 13 26 1 1916181232 14899232 3658992
16:27:02 47626 8192000000 8867098208 9128718336 5226624 0.063 1 1 2 0 5351280 62528 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 11-06-2021 16:28:47 to 11-06-2021 16:29:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 92 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-06-2021 16:29:19 to 11-06-2021 16:29:21.

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

11.06.21 16:29:22. 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-11 16:29:24 No severe PSQL-related problems occured
11.06.21 16:29:26. End of report.