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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17498040 kB
MemAvailable 31469092 kB
Buffers 0 kB
Cached 14161860 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-29 19:27:28
DTS_END                         2021-03-29 19:27:28.2090
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53900
TRN_ID                          244561
ATT_ID                          716
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: 9169.08 23190 1100289
customer order: creation 174.52 359 20942
customer order: refuse 15.58 342 1870
order to supplier: creation 45.61 1238 5473
order to supplier: removal 3.41 108385 409
invoice (draft): creation 46.82 3421 5618
invoice (draft): removal 50.62 871 6074
invoice accept: apply 42.98 19988 5157
invoice accept: cancel 45.97 730 5516
customer reserve: creation 3916.32 202 469958
customer reserve: removal 4521.20 63 542544
realization accept: apply 85.76 176 10291
realization accept: cancel 87.78 117 10533
payment from customer: creation 60.24 104 7229
payment from customer: removal 5.93 81 712
payment to supplier: creation 49.89 130 5987
payment to supplier: removal 3.81 54 457
service: total inventory turnovers 4.93 1159 592
service: total monetary turnovers 6.88 25 825
service: aggregate perf. data 0.82 21769 98
service: refresh index statistics 0.03 304590 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-03-2021 19:28:12 to 29-03-2021 19:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9457
TEST_TIME 2 5556
TEST_TIME 3 4859
TEST_TIME 4 4951
TEST_TIME 5 5406
TEST_TIME 6 5183
TEST_TIME 7 4946
TEST_TIME 8 4979
TEST_TIME 9 5263
TEST_TIME 10 5240
TEST_TIME 11 5336
TEST_TIME 12 5664
TEST_TIME 13 5852
TEST_TIME 14 5999
TEST_TIME 15 6115
TEST_TIME 16 6231
TEST_TIME 17 6460
TEST_TIME 18 6607
TEST_TIME 19 6948
TEST_TIME 20 7387
TEST_TIME 21 7768
TEST_TIME 22 7897
TEST_TIME 23 8108
TEST_TIME 24 8568
TEST_TIME 25 8692
TEST_TIME 26 9391
TEST_TIME 27 10717
TEST_TIME 28 10531
TEST_TIME 29 10244
TEST_TIME 30 10160
TEST_TIME 31 9975
TEST_TIME 32 9805
TEST_TIME 33 9621
TEST_TIME 34 9691
TEST_TIME 35 9712
TEST_TIME 36 9604
TEST_TIME 37 9534
TEST_TIME 38 9390
TEST_TIME 39 9462
TEST_TIME 40 9341
TEST_TIME 41 9344
TEST_TIME 42 9565
TEST_TIME 43 9531
TEST_TIME 44 9542
TEST_TIME 45 9613
TEST_TIME 46 9699
TEST_TIME 47 9590
TEST_TIME 48 9492
TEST_TIME 49 9636
TEST_TIME 50 9717
TEST_TIME 51 9653
TEST_TIME 52 9623
TEST_TIME 53 9652
TEST_TIME 54 9536
TEST_TIME 55 9462
TEST_TIME 56 9457
TEST_TIME 57 9358
TEST_TIME 58 9280
TEST_TIME 59 9197
TEST_TIME 60 9269
TEST_TIME 61 9248
TEST_TIME 62 9328
TEST_TIME 63 9282
TEST_TIME 64 9410
TEST_TIME 65 9384
TEST_TIME 66 9380
TEST_TIME 67 9465
TEST_TIME 68 9434
TEST_TIME 69 9446
TEST_TIME 70 9542
TEST_TIME 71 9512
TEST_TIME 72 9458
TEST_TIME 73 9664
TEST_TIME 74 9641
TEST_TIME 75 9587
TEST_TIME 76 9522
TEST_TIME 77 9474
TEST_TIME 78 9469
TEST_TIME 79 9443
TEST_TIME 80 9385
TEST_TIME 81 9372
TEST_TIME 82 9361
TEST_TIME 83 9298
TEST_TIME 84 9244
TEST_TIME 85 9222
TEST_TIME 86 9246
TEST_TIME 87 9271
TEST_TIME 88 9258
TEST_TIME 89 9270
TEST_TIME 90 9304
TEST_TIME 91 9303
TEST_TIME 92 9333
TEST_TIME 93 9322
TEST_TIME 94 9357
TEST_TIME 95 9344
TEST_TIME 96 9337
TEST_TIME 97 9343
TEST_TIME 98 9330
TEST_TIME 99 9353
TEST_TIME 100 9395
TEST_TIME 101 9353
TEST_TIME 102 9301
TEST_TIME 103 9250
TEST_TIME 104 9242
TEST_TIME 105 9195
TEST_TIME 106 9182
TEST_TIME 107 9116
TEST_TIME 108 9138
TEST_TIME 109 9137
TEST_TIME 110 9133
TEST_TIME 111 9107
TEST_TIME 112 9123
TEST_TIME 113 9169
TEST_TIME 114 9137
TEST_TIME 115 9204
TEST_TIME 116 9206
TEST_TIME 117 9178
TEST_TIME 118 9152
TEST_TIME 119 9160
TEST_TIME 120 9170

Performance per minute, chart


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

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 1534374 1534374 0 0.00 0 17846 7 0 0
doc_list_biud 1534371 1534371 0 0.00 0 39559 29 0 0
sp_add_invoice_to_stock 5243 5157 86 1.64 32 190471 19989 0 86
sp_cancel_adding_invoice 5516 5516 0 0.00 4 62387 730 0 0
sp_cancel_client_order 1870 1870 0 0.00 4 17430 342 0 0
sp_cancel_customer_reserve 542544 542544 0 0.00 1 35726 64 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 2 6207 82 0 0
sp_cancel_pay_to_supplier 457 457 0 0.00 3 1064 54 0 0
sp_cancel_supplier_invoice 6079 6074 5 0.08 2 18041 871 0 5
sp_cancel_supplier_order 409 409 0 0.00 8 1051896 108386 0 0
sp_cancel_write_off 10533 10533 0 0.00 1 8088 117 0 0
sp_client_order 20942 20942 0 0.00 3 22751 360 0 0
sp_customer_reserve 469958 469958 0 0.00 0 180298 202 0 0
sp_fill_shopping_cart 32029 32029 0 0.00 1 12057 37 0 0
sp_fill_shopping_cart_clo_res 469953 469953 0 0.00 0 18891 14 0 0
sp_get_clo_for_invoice 5152 5152 0 0.00 0 19685 275 0 0
sp_kill_cost_storno 17218 17218 0 0.00 0 8058 53 0 0
sp_kill_qstorno_ret_qs2qd 1102104 1102104 0 0.00 0 35711 35 0 0
sp_kill_qty_storno 582389 582389 0 0.00 0 39557 74 0 0
sp_lock_selected_doc 21387 21387 0 0.00 0 9454 5 0 0
sp_make_cost_storno 28659 28659 0 0.00 0 11796 52 0 0
sp_multiply_rows_for_pdistr 28659 28659 0 0.00 0 17839 29 0 0
sp_multiply_rows_for_qdistr 20942 20942 0 0.00 0 10852 163 0 0
sp_pay_from_customer 7229 7229 0 0.00 4 17851 105 0 0
sp_pay_to_supplier 5987 5987 0 0.00 5 11678 131 0 0
sp_payment_common 13216 13216 0 0.00 1 9199 29 0 0
sp_qd_handle_on_cancel_clo 1870 1870 0 0.00 0 17418 306 0 0
sp_qd_handle_on_invoice_upd_sts 10668 10668 0 0.00 0 39557 339 0 0
sp_qd_handle_on_reserve_upd_sts 10291 10291 0 0.00 0 12606 58 0 0
sp_reserve_write_off 10291 10291 0 0.00 6 13036 177 0 0
sp_supplier_invoice 5618 5618 0 0.00 7 87124 3422 0 0
sp_supplier_order 5473 5473 0 0.00 5 25741 1239 0 0
srv_aggregate_perf_data 98 98 0 0.00 2554 444454 21770 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1064 192415 33547 0 0
srv_find_qd_qs_mism 1051192 1051192 0 0.00 0 12209 7 0 0
srv_make_invnt_saldo 592 592 0 0.00 34 146836 1160 0 0
srv_make_money_saldo 825 825 0 0.00 0 1607 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 59915 456925 304590 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5157 5157 0 0.00 0 12964 150 0 0
t$perf-norm:sp_cancel_adding_invoice 402 402 0 0.00 0 2170 69 0 0
t$perf-norm:sp_cancel_client_order 1870 1870 0 0.00 0 1836 11 0 0
t$perf-norm:sp_cancel_customer_reserve 712 712 0 0.00 0 2558 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 712 712 0 0.00 0 3200 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 457 457 0 0.00 0 195 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 365 365 0 0.00 0 1015 18 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 43287 1667 0 0
t$perf-norm:sp_cancel_write_off 1017 1017 0 0.00 0 3471 18 0 0
t$perf-norm:sp_client_order 20942 20942 0 0.00 0 9390 18 0 0
t$perf-norm:sp_customer_reserve 1001 1001 0 0.00 0 1451 6 0 0
t$perf-norm:sp_pay_from_customer 7229 7229 0 0.00 0 6742 9 0 0
t$perf-norm:sp_pay_to_supplier 5987 5987 0 0.00 0 6177 9 0 0
t$perf-norm:sp_reserve_write_off 10291 10291 0 0.00 0 7098 10 0 0
t$perf-norm:sp_supplier_invoice 5618 5618 0 0.00 0 5405 16 0 0
t$perf-norm:sp_supplier_order 5473 5473 0 0.00 0 3365 14 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 401 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 340 4 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 8096 40 0 0
t$perf-norm:srv_make_money_saldo 825 825 0 0.00 0 8937 31 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10476 10304 172 1.64 0 4642 17 0 172
v_all_customers 37926 37926 0 0.00 0 94 1 0 0
v_all_suppliers 30808 30808 0 0.00 0 23 1 0 0
v_all_wares 41884 41884 0 0.00 0 13 1 0 0
v_cancel_adding_invoice 804 804 0 0.00 0 827 7 0 0
v_cancel_client_order 3740 3740 0 0.00 0 3736 6 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 6197 12 0 0
v_cancel_customer_reserve 1424 1424 0 0.00 0 2338 6 0 0
v_cancel_payment_to_supplier 914 914 0 0.00 0 831 5 0 0
v_cancel_supplier_invoice 740 730 10 1.35 0 3363 24 0 10
v_cancel_supplier_order 818 818 0 0.00 0 638 6 0 0
v_cancel_write_off 2034 2034 0 0.00 0 2890 15 0 0
v_max_id_clo_ord 5472 5472 0 0.00 0 1386 1 0 0
v_max_id_clo_res 1001 1001 0 0.00 0 2252 16 0 0
v_max_id_ord_sup 5615 5615 0 0.00 0 3730 3 0 0
v_max_non_paid_invoice 1670 1670 0 0.00 0 900 3 0 0
v_max_non_paid_realizn 3945 3945 0 0.00 0 4219 5 0 0
v_min_id_clo_ord 5472 5472 0 0.00 0 4701 7 0 0
v_min_id_clo_res 1001 1001 0 0.00 0 7335 17 0 0
v_min_id_ord_sup 5615 5615 0 0.00 0 7622 9 0 0
v_min_non_paid_invoice 5987 5987 0 0.00 0 9196 20 0 0
v_min_non_paid_realizn 7229 7229 0 0.00 0 7857 18 0 0
v_our_firm 10526 10526 0 0.00 0 13 1 0 0
v_reserve_write_off 20582 20582 0 0.00 0 3595 5 0 0
x_lock_depdocs_on_canc_invoice 11225 11225 0 0.00 0 20906 132 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 6165 342 0 0
x_make_qstorno_1000_1200 5473 5473 0 0.00 2 25686 1165 0 0
x_make_qstorno_1200_2000 5618 5618 0 0.00 3 77256 3283 0 0
x_make_qstorno_2100_3300 469958 469958 0 0.00 0 180291 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-03-2021 19:28:20 to 29-03-2021 19:28:24.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:31 5 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:38 9837 8192000000 10155466080 10448773120 758147408 8.470 62 45 90 1 776723936 2090528 16486000
16:57:56 32691 8192000000 10326041104 10636783616 1369430688 14.322 100 88 175 2 1402494528 4556464 28507376
16:58:41 14278 8192000000 10360101472 10672959488 1411470944 14.697 100 92 185 0 1447805968 6384896 29950128
16:59:06 16714 8192000000 10372235504 10692845568 1417690224 14.752 100 84 168 0 1452696128 7023904 27982000
16:59:42 7035 8192000000 10394013136 10717188096 1453368096 15.068 100 91 182 0 1490125312 7580256 29176960
16:59:59 19968 8192000000 10413992816 10740486144 1464730288 15.167 100 88 176 1 1501459408 8298224 28430896
17:00:27 26526 8192000000 10434299792 10763550720 1483815200 15.335 100 88 176 0 1520862448 8623920 28423328
17:01:08 18319 8192000000 10461518048 10793562112 1510338112 15.566 100 93 186 0 1549156400 9299008 29519280
17:01:36 19058 8192000000 10484442192 10831560704 1532330896 15.757 100 81 162 0 1567412160 10153760 24927504
17:02:04 14112 8192000000 10493339328 10848268288 1563246112 16.024 100 77 154 1 1597167008 9882928 24037968
17:02:27 12527 8192000000 10528574288 10885300224 1596165632 16.307 100 72 144 1 1627321936 9469344 21686960
17:02:48 10397 8192000000 10567416336 10926067712 1620308800 16.513 100 74 148 1 1652980048 10027856 22643392
17:03:07 11464 8192000000 10596774688 10958217216 1654861312 16.805 100 84 168 2 1691706848 11430640 25414896
17:03:26 10694 8192000000 10611518144 10971611136 1664601904 16.888 100 77 154 0 1698630096 11494032 22534160
17:03:46 10748 8192000000 10624588592 10996097024 1685178800 17.061 100 74 148 2 1717163456 11123984 20860672
17:04:04 9375 8192000000 10647935728 11016634368 1706227248 17.237 100 78 157 0 1740580304 12374528 21978528
17:04:21 7842 8192000000 10652699264 11023298560 1716202704 17.321 100 89 177 0 1754347296 13381648 24762944
17:04:37 4877 8192000000 10670477792 11042009088 1724943712 17.393 100 84 168 1 1762702432 14216848 23541872
17:04:49 6678 8192000000 10678345600 11054174208 1742507312 17.539 100 85 170 2 1780944624 14424256 24013056
17:05:06 4837 8192000000 10682404240 11062996992 1744832464 17.559 100 76 152 1 1780111536 13662432 21616640
17:05:17 5147 8192000000 10699032560 11078205440 1759078288 17.677 100 78 154 0 1794028688 13453136 21497264
17:05:30 3406 8192000000 10698648720 11082174464 1769875584 17.766 100 77 150 0 1804383312 13201024 21306704
17:05:42 2804 8192000000 10723192304 11100536832 1782024112 17.866 100 87 175 1 1819019808 12653280 24342416
17:05:51 4143 8192000000 10723391200 11104411648 1781945056 17.866 100 77 154 1 1816454336 13281168 21228112
17:06:02 2837 8192000000 10729948128 11106988032 1788557584 17.920 100 87 175 1 1826797792 13619232 24620976
17:06:11 11298 8192000000 10725693280 11113328640 1794334272 17.967 100 75 151 1 1829006192 14208384 20463536
17:06:29 3414 8192000000 10749515664 11137433600 1800511680 18.018 100 81 162 1 1836975024 13735008 22728336
17:06:39 1827 8192000000 10753928096 11142459392 1817263184 18.155 100 80 159 2 1853698160 13577360 22857616
17:06:49 2632 8192000000 10769211216 11151634432 1825956608 18.226 100 84 168 2 1863541120 13431088 24153424
17:06:57 2210 8192000000 10775496496 11158142976 1832350400 18.278 100 86 172 0 1868973008 12760288 23862320
17:07:06 1982 8192000000 10764850560 11153133568 1830795696 18.266 100 75 150 1 1864291456 12108752 21387008
17:07:15 1954 8192000000 10785881360 11168276480 1836514688 18.312 100 85 171 1 1874035712 13238448 24282576
17:07:23 2511 8192000000 10786387520 11170684928 1839535024 18.337 100 90 181 1 1881646320 17088048 25023248
17:07:33 2654 8192000000 10781490352 11172294656 1843668320 18.371 100 89 175 0 1881459728 13052384 24739024
17:07:43 2272 8192000000 10790342512 11174129664 1851504064 18.434 100 95 190 0 1891642608 13403776 26734768
17:07:51 1698 8192000000 10788548176 11173400576 1850922720 18.430 100 90 181 0 1889159440 12998800 25237920
17:08:00 1647 8192000000 10798633904 11182563328 1854915920 18.462 100 95 190 1 1897294016 15506288 26871808
17:08:07 1239 8192000000 10801291760 11185274880 1853403232 18.450 100 90 180 1 1893789824 14524656 25861936
17:08:15 1813 8192000000 10803322544 11192193024 1857193232 18.481 100 89 178 0 1896898944 13798624 25907088
17:08:23 27814 8192000000 10782332928 11187470336 1856609504 18.476 100 59 118 0 1884433760 11371952 16452304
17:09:15 1490 8192000000 10811730032 11205615616 1868299264 18.571 100 94 188 1 1907421440 11703712 27418464
17:09:22 4427 8192000000 10796511520 11199295488 1867000320 18.560 100 56 112 1 1893644400 10859456 15784624
17:09:34 2483 8192000000 10799740096 11199668224 1864056272 18.536 100 61 120 1 1890348864 9673920 16618672
17:09:45 4264 8192000000 10787225008 11200978944 1865534752 18.548 100 44 88 3 1886992928 8812544 12645632
17:09:57 3855 8192000000 10802129040 11208228864 1873494976 18.613 100 49 95 1 1892859376 5798592 13565808
17:10:07 7088 8192000000 10798110800 11211673600 1873497424 18.613 100 46 93 0 1894538992 8713200 12328368
17:10:21 4393 8192000000 10793925104 11215958016 1875610272 18.630 100 39 79 3 1895158432 9095024 10453136
17:10:35 5460 8192000000 10792360048 11215171584 1877579248 18.646 100 37 72 0 1896721040 8689584 10452208
17:10:48 54238 8192000000 10796960144 11218640896 1878871536 18.656 100 34 67 2 1894413056 5693424 9848096
17:11:52 9251 8192000000 10792662832 11220807680 1883249344 18.691 100 26 53 2 1896744320 6372496 7122480
17:12:11 5374 8192000000 10795929488 11222306816 1883659104 18.695 100 29 58 1 1898508720 6362400 8487216
17:12:28 7010 8192000000 10803948912 11229921280 1887253328 18.724 100 31 61 1 1903425120 6754464 9417328
17:12:41 13387 8192000000 10792576832 11229470720 1889916464 18.745 100 25 50 0 1902978448 6131328 6930656
17:13:05 9697 8192000000 10792576240 11227557888 1889757648 18.744 100 13 25 1 1898805200 5568064 3479488
17:13:21 9716 8192000000 10810045616 11229786112 1888875472 18.737 100 18 36 4 1899814256 5554752 5384032
17:13:38 9207 8192000000 10801012064 11232952320 1891131312 18.755 100 33 61 3 1905939680 5316048 9492320
17:13:56 6344 8192000000 10809455568 11238354944 1895864640 18.793 100 26 52 2 1910404880 6367344 8172896
17:14:09 7361 8192000000 10810899968 11239739392 1895766336 18.792 100 27 54 3 1909194768 5635376 7793056
17:14:27 7290 8192000000 10799738512 11236655104 1897381392 18.805 100 17 34 1 1907927616 5945856 4600368
17:14:41 16320 8192000000 10802437168 11241435136 1898593728 18.815 100 13 26 3 1907856128 5698288 3564112
17:15:04 19191 8192000000 10809553040 11245867008 1902543280 18.847 100 21 41 2 1915468352 5389696 7535376
17:15:32 56870 8192000000 10855988944 11256037376 1873450432 18.612 98 63 128 0 1897454096 6114976 17888688
17:16:35 7766 8192000000 10826555104 11257208832 1910472032 18.910 100 33 66 1 1927294864 8033312 8789520
17:16:49 10503 8192000000 10799147296 11235065856 1852280416 18.441 97 32 65 3 1867498864 6240128 8978320
17:17:06 6004 8192000000 10816384912 11236356096 1873673904 18.614 99 32 64 2 1892763488 10020640 9068944
17:17:19 5610 8192000000 10807559632 11236134912 1892507360 18.766 100 32 63 0 1907940000 6967200 8465440
17:17:33 6824 8192000000 10785616112 11219505152 1863459760 18.531 99 23 47 0 1875787568 5912016 6415792
17:17:46 5838 8192000000 10790428256 11207516160 1850009728 18.422 98 34 70 1 1865653136 4541472 11101936
17:17:58 9008 8192000000 10766584144 11200479232 1835298864 18.303 98 19 38 0 1846786304 5321088 6166352
17:18:16 6136 8192000000 10782423264 11210448896 1871079040 18.593 100 31 62 3 1887017088 6732784 9205264
17:18:30 9195 8192000000 10718802736 11136671744 1689644752 17.098 91 17 34 1 1699346752 4698448 5003552
17:18:51 61469 8192000000 10704029600 11133124608 1688838720 17.092 92 35 70 1 1704514048 5933632 9741696
17:19:59 7943 8192000000 10702588576 11119882240 1732083856 17.453 96 15 30 1 1741550288 5177168 4289264
17:20:14 7573 8192000000 10691493280 11101573120 1706179952 17.237 95 28 57 2 1720708672 6692528 7836192
17:20:30 7028 8192000000 10660336640 11076464640 1719889088 17.351 97 30 60 1 1736498816 7517120 9092608
17:20:43 4940 8192000000 10687458304 11097980928 1757723440 17.666 99 33 66 2 1773615504 6929248 8962816
17:20:57 3986 8192000000 10704065392 11113529344 1755143952 17.644 98 37 74 1 1771061584 5443184 10474448
17:21:08 7529 8192000000 10674238816 11089158144 1706267520 17.238 96 27 54 0 1720189392 6401296 7520576
17:21:21 5513 8192000000 10689942544 11113955328 1786808000 17.906 100 34 69 1 1803035056 6667584 9559472
17:21:34 11634 8192000000 10718487776 11130101760 1751618544 17.615 97 24 49 1 1763820944 5366944 6835456
17:21:53 6819 8192000000 10725693424 11145883648 1817298800 18.156 100 23 46 1 1829731616 5556496 6876320
17:22:10 9433 8192000000 10736395760 11161808896 1825659360 18.224 100 30 60 0 1841077904 6302224 9116320
17:22:31 7228 8192000000 10704870256 11115270144 1748560592 17.590 96 22 44 1 1763724784 9185792 5978400
17:22:45 6911 8192000000 10725115360 11149742080 1813002064 18.120 100 25 50 0 1825227504 4826064 7399376
17:23:01 52187 8192000000 10739370736 11150618624 1810628528 18.101 99 32 64 2 1824363152 4575728 9158896
17:24:00 20839 8192000000 10722207040 11144634368 1809324880 18.090 99 30 58 4 1823739888 6104064 8310944
17:24:29 7606 8192000000 10751596288 11159142400 1805389312 18.058 99 36 72 0 1821573664 6269072 9915280
17:24:43 5705 8192000000 10732887152 11163439104 1822737776 18.200 100 31 62 1 1843310640 11984800 8588064
17:24:58 4938 8192000000 10743200656 11166208000 1825762688 18.225 100 27 54 1 1840584896 6918944 7903264
17:25:11 5491 8192000000 10757792896 11175350272 1836127856 18.309 100 28 56 4 1850052064 6198016 7726192
17:25:29 9153 8192000000 10751361072 11173113856 1836521472 18.312 100 30 60 3 1851864144 6938544 8404128
17:25:46 7279 8192000000 10752433216 11177365504 1838730912 18.330 100 22 44 3 1850875792 5461584 6683296
17:26:02 8133 8192000000 10754300624 11180224512 1843656064 18.371 100 30 61 0 1857959312 5001600 9301648
17:26:17 12021 8192000000 10766252256 11185373184 1844448400 18.377 100 18 36 3 1854889472 5187216 5253856
17:26:37 10458 8192000000 10764481344 11192827904 1848056576 18.406 100 13 24 1 1857003008 5162080 3784352
17:26:55 10828 8192000000 10771277504 11194994688 1855239312 18.465 100 18 36 1 1866126976 5599120 5288544
17:27:13 15650 8192000000 10778258848 11209920512 1868480208 18.572 100 13 24 1 1876280400 4672736 3127456
17:27:40 10260 8192000000 10816808880 11234430976 1891231328 18.756 100 55 109 3 1913798240 6254240 16312672
17:27:59 11034 8192000000 10834120768 11249770496 1902045984 18.843 100 75 149 2 1932581600 8587360 21948256
17:28:26 45420 8192000000 10821922032 11250569216 1903568912 18.855 100 44 88 1 1922238176 5753424 12915840
17:29:20 54079 8192000000 10842436032 11269144576 1912103184 18.924 100 50 98 2 1934934736 8007312 14824240
17:30:30 31326 8192000000 10861516400 11291123712 1922094816 19.004 100 43 86 1 1949571904 15972000 11505088
17:31:33 26639 8192000000 10865279520 11293548544 1934073728 19.099 100 43 86 3 1958464272 12357008 12033536
17:32:10 17664 8192000000 10869387552 11300294656 1938820928 19.137 100 43 86 1 1966088384 14122368 13145088
17:32:38 26833 8192000000 10881177552 11317858304 1942576512 19.167 100 24 48 0 1963523024 14065168 6881344
17:33:11 17080 8192000000 10889821344 11321724928 1953591968 19.255 100 44 84 0 1982944272 15684992 13667312
17:33:36 11698 8192000000 10899757088 11326947328 1958495264 19.294 100 49 98 1 1990158864 16831232 14832368
17:34:01 14885 8192000000 10907607968 11336179712 1956661152 19.279 100 54 108 1 1993165424 20467152 16037120
17:34:38 23119 8192000000 10922229024 11352436736 1970484608 19.389 100 47 93 1 2010707744 26079456 14143680
17:35:16 26244 8192000000 10923651344 11355381760 1975763824 19.431 100 51 102 1 2015764224 24451872 15548528
17:35:53 12147 8192000000 10936133520 11360575488 1978505216 19.453 100 58 116 2 2022121680 25685792 17930672
17:36:18 15200 8192000000 10934050384 11367350272 1982097584 19.481 100 52 104 0 2023054688 25044176 15912928
17:36:45 7323 8192000000 10943934720 11368513536 1968379888 19.373 99 48 96 0 2008448832 25276192 14792752
17:36:58 5108 8192000000 10906575696 11326799872 1945660576 19.192 98 61 120 1 1989667360 26471200 17535584
17:37:12 27872 8192000000 10915732128 11341828096 1921583600 19.000 97 62 124 1 1968580800 27875968 19121232
17:37:57 7940 8192000000 10917234144 11347845120 1961811184 19.320 100 50 100 1 2005656928 28811360 15034384
17:38:15 9853 8192000000 10926458144 11359510528 1966555968 19.358 100 51 102 2 2010760192 28968672 15235552
17:38:35 5820 8192000000 10937084672 11363504128 1973638496 19.414 100 51 99 3 2019803984 31169040 14996448
17:38:48 4341 8192000000 10942217808 11361615872 1970949760 19.393 100 64 128 1 2022667760 31614640 20103360
17:39:03 8309 8192000000 10932697536 11359645696 1970578512 19.390 100 61 122 3 2021578656 32758640 18241504
17:39:22 11766 8192000000 10920202768 11348217856 1956792752 19.281 100 47 94 3 2003383600 32168800 14422048
17:39:40 12058 8192000000 10919009280 11350589440 1945705984 19.192 99 58 113 2 1995788336 32802448 17279904
17:40:02 1954 8192000000 10930000032 11353415680 1960089568 19.307 100 64 129 0 2012363984 32387344 19887072
17:40:12 3513 8192000000 10931457056 11358101504 1966598592 19.358 100 67 134 2 2023653728 36964176 20090960
17:40:24 9581 8192000000 10928935184 11363889152 1970220384 19.387 100 48 96 3 2018971152 33669200 15081568
17:40:41 7750 8192000000 10935693504 11360935936 1939642128 19.144 98 56 109 1 1991566112 35240400 16683584
17:40:57 2298 8192000000 10950763808 11364548608 1974057520 19.418 100 88 175 1 2035079440 34233952 26787968
17:41:10 4002 8192000000 10932726240 11354288128 1964303968 19.340 100 73 144 1 2019996720 34072608 21620144
17:41:24 6274 8192000000 10948513616 11368382464 1971050112 19.394 100 67 134 1 2028270256 36332752 20887392
17:41:42 5192 8192000000 10959666768 11378696192 1982578496 19.485 100 79 158 2 2044225952 36816048 24831408
17:41:55 2967 8192000000 10964934128 11383779328 1987475856 19.524 100 76 150 1 2049214816 38993632 22745328
17:42:07 5499 8192000000 10943522064 11364921344 1961395568 19.317 99 71 141 0 2021255600 38667056 21192976
17:42:20 1888 8192000000 10960209328 11377582080 1981093232 19.473 100 74 148 4 2044327920 40715200 22519488
17:42:30 2811 8192000000 10973503376 11385208832 1987632624 19.525 100 93 182 2 2058119600 42095744 28391232
17:42:40 2177 8192000000 10970437984 11378470912 1980789088 19.471 100 92 183 1 2052359040 43654576 27915376
17:42:49 7182 8192000000 10967837328 11383267328 1990258544 19.546 100 84 168 2 2059523808 44022368 25242896
17:43:03 2513 8192000000 10972473776 11389284352 1989239664 19.538 100 84 167 3 2058853840 44286064 25328112
17:43:13 3418 8192000000 10962680448 11374501888 1975678720 19.430 100 85 169 0 2046809248 45452512 25678016
17:43:23 2021 8192000000 10957727648 11367079936 1952875616 19.249 99 84 166 1 2024137856 45692080 25570160
17:43:32 1987 8192000000 10948982080 11353505792 1953159024 19.252 100 95 188 3 2028132096 46789584 28183488
17:43:42 6697 8192000000 10950279680 11362828288 1961256704 19.316 100 82 164 0 2034442560 48168480 25017376
17:43:56 6513 8192000000 10954187456 11371216896 1971643376 19.398 100 75 150 0 2043888016 49392768 22851872
17:44:13 1656 8192000000 10956597792 11362861056 1946880016 19.202 99 85 170 1 2025346416 51502624 26963776
17:44:22 4004 8192000000 10916531280 11319783424 1905566416 18.871 98 80 160 1 1985008352 52716704 26725232
17:44:34 4701 8192000000 10912597904 11329089536 1914337312 18.941 99 65 129 1 1984585840 50187584 20060944
17:44:49 6493 8192000000 10933291504 11351375872 1945741008 19.193 100 72 143 0 2019511744 51175488 22595248
17:45:05 3806 8192000000 10941477584 11349331968 1917164976 18.964 98 74 148 0 1993215088 52766368 23283744
17:45:16 6682 8192000000 10933021264 11342659584 1913491568 18.935 98 73 146 3 1991769184 55168928 23108688
17:45:33 7279 8192000000 10940105968 11351162880 1942726048 19.169 100 75 150 1 2023523216 57270496 23526672
17:45:49 3508 8192000000 10952499264 11361988608 1950664528 19.232 100 86 168 1 2035856096 58311920 26879648
17:45:59 1063 8192000000 10968037392 11368628224 1962212400 19.324 100 88 175 3 2045504416 56881344 26410672
17:46:09 3285 8192000000 10970288592 11376914432 1965625232 19.351 100 89 177 1 2049369376 56866688 26877456
17:46:24 2854 8192000000 10956936944 11373092864 1962552848 19.326 100 72 144 2 2036799616 51938704 22308064
17:46:34 3319 8192000000 10961369088 11369418752 1961193024 19.316 100 86 172 0 2040901584 51880208 27828352
17:46:46 4667 8192000000 10963987568 11372863488 1968606576 19.374 100 87 172 3 2047422960 52909104 25907280
17:46:57 4102 8192000000 10965048320 11375947776 1964046560 19.338 100 82 164 0 2045310544 55126480 26137504
17:47:12 1628 8192000000 10963087904 11375878144 1962528864 19.326 100 89 178 0 2046813744 56227024 28057856
17:47:20 1532 8192000000 10975384496 11381596160 1970731472 19.391 100 88 174 0 2049831696 51612176 27488048
17:47:28 1736 8192000000 10957364560 11366428672 1947324368 19.205 99 91 182 0 2029136416 52903936 28908112
17:47:38 4670 8192000000 10959701936 11367657472 1957575776 19.287 100 84 165 3 2038512688 54507376 26429536
17:47:50 9857 8192000000 10945534272 11371745280 1960690992 19.312 100 64 128 0 2035157552 52748960 21717600
17:48:13 8416 8192000000 10938284656 11371130880 1958987664 19.298 100 54 109 1 2030554032 52263168 19303200
17:48:43 6225 8192000000 10935140416 11364188160 1953069776 19.251 100 54 108 1 2021117344 50109488 17938080
17:48:58 7515 8192000000 10935204496 11371528192 1957097056 19.283 100 43 86 0 2023244176 51933808 14213312
17:49:27 9368 8192000000 10928836736 11355963392 1935046352 19.107 99 41 80 3 1997477344 49223408 13207584
17:49:45 12233 8192000000 10936883056 11372716032 1954883008 19.265 100 46 92 1 2023969216 53443024 15643184
17:50:10 15323 8192000000 10928157344 11363639296 1921364544 18.998 98 38 76 2 1994920928 59754160 13802224
17:50:34 26275 8192000000 10931139840 11373322240 1951947312 19.242 100 37 74 1 2018245296 53351424 12946560
17:51:19 23397 8192000000 10923294384 11372978176 1958553616 19.295 100 26 52 3 2012223488 44600512 9069360
17:51:58 9257 8192000000 10923982608 11365363712 1934044352 19.099 99 40 78 4 1995597200 47937264 13615584
17:52:23 14839 8192000000 10895820128 11342987264 1927936112 19.050 99 35 70 2 1987756384 47496336 12323936
17:52:48 25861 8192000000 10914550272 11370024960 1939533856 19.143 100 27 54 0 2006096144 56255344 10306944
17:53:55 23919 8192000000 10872538320 11314302976 1853792512 18.453 96 19 38 1 1906480480 46051200 6636768
17:54:26 12482 8192000000 10874181344 11325358080 1905703104 18.872 99 24 48 0 1953619840 39794288 8122448
17:54:46 23393 8192000000 10855480864 11308437504 1896037136 18.794 98 11 22 2 1915044032 16059376 2947520
17:55:16 72934 8192000000 10844272896 11286892544 1879646864 18.662 98 31 62 2 1896737536 8578832 8511840
17:56:55 121388 8192000000 10878842864 11319521280 1865628656 18.549 97 30 60 0 1885422240 11207312 8586272
17:59:32 94791 8192000000 10874103488 11331506176 1893846752 18.777 97 31 60 1 1916115936 14292080 7977104
18:01:35 27862 8192000000 10863706368 11323768832 1912801072 18.929 98 9 18 0 1926605248 11571808 2232368
18:02:11 28558 8192000000 10853009392 11316965376 1916826048 18.961 99 17 34 0 1936553520 14692736 5034736
18:02:46 25105 8192000000 10867471344 11330977792 1940347440 19.150 100 14 28 0 1961145232 16947248 3850544
18:03:28 192404 8192000000 10896110384 11358429184 1923745184 19.017 98 19 36 3 1944332272 14887648 5699440
18:08:07 30518 8192000000 10895605312 11350863872 1938332080 19.133 99 30 61 1 1967387808 19884736 9170992
18:09:24 35362 8192000000 10902071920 11367288832 1968593936 19.374 100 21 44 2 1991353840 16434800 6325104
18:10:18 59167 8192000000 10907205456 11370733568 1959340416 19.301 99 41 81 0 1981948704 10699984 11908304
18:11:30 96188 8192000000 10906476064 11380125696 1975288144 19.427 100 9 18 1 1991538096 13838256 2411696
18:13:17 66592 8192000000 10908704832 11387392000 1987503120 19.524 100 28 56 0 2011370832 15491856 8375856
18:14:31 34564 8192000000 10924339216 11368284160 1952691952 19.248 98 45 88 3 1975924976 11069776 12163248
18:15:21 14746 8192000000 10929063920 11376005120 1979255200 19.459 100 45 90 1 2004213616 12666928 12291488
18:15:43 17929 8192000000 10938031600 11382976512 1984878160 19.503 100 53 106 2 2014968000 15500752 14589088
18:16:07 38225 8192000000 10917678032 11387752448 1966399952 19.357 99 37 74 1 1995739776 18990672 10349152
18:17:03 127452 8192000000 10902622960 11365867520 1902100560 18.843 96 17 34 0 1920589584 14217744 4271280
18:19:17 53679 8192000000 10892353648 11356618752 1908672064 18.896 96 21 42 3 1924158992 9290176 6196752
18:20:22 36195 8192000000 10910441840 11357966336 1952116096 19.243 99 23 47 0 1966502672 7713008 6673568
18:21:10 112418 8192000000 10911840960 11373117440 1979517216 19.461 100 43 86 0 2004047056 12399664 12130176
18:23:10 61020 8192000000 10893696096 11359883264 1941507392 19.159 98 26 52 0 1959623824 10777280 7339152
18:24:31 13953 8192000000 10881352912 11331264512 1903077744 18.851 97 27 54 2 1923836016 12402000 8356272
18:24:53 65009 8192000000 10901872528 11364347904 1938629840 19.136 99 26 52 0 1964066720 18038448 7398432
18:26:14 80480 8192000000 10891405184 11370160128 1911749904 18.921 97 16 32 0 1944700096 28246080 4704112
18:28:25 79059 8192000000 10884051680 11376467968 1931857280 19.082 99 15 31 0 1953474992 17061968 4555744
18:29:50 74817 8192000000 10886743840 11359948800 1918480992 18.975 98 11 22 0 1944915824 23632880 2801952
18:31:12 68334 8192000000 10884561344 11356209152 1952895408 19.250 100 13 26 0 1970263936 14169088 3199440
18:32:26 31277 8192000000 10903708048 11356905472 1930802944 19.073 98 19 38 1 1942776864 6719216 5254704
18:33:07 28826 8192000000 10898794880 11362078720 1930560464 19.071 98 24 48 3 1946506992 9477552 6468976
18:33:43 51325 8192000000 10877965760 11346677760 1901675216 18.840 97 20 40 1 1918105760 10925024 5505520
18:34:55 49349 8192000000 10864428400 11315900416 1800130656 18.015 92 17 33 2 1816432912 11541456 4760800
18:35:56 32851 8192000000 10876266656 11322773504 1910090480 18.907 99 32 62 0 1932565328 13403456 9071392
18:36:35 120433 8192000000 10881463616 11350892544 1847997856 18.406 95 21 42 1 1869523184 15821216 5704112
18:38:45 67195 8192000000 10919420576 11363516416 1950728320 19.232 100 20 40 1 1974402032 18215456 5458256
18:40:01 103149 8192000000 10868637520 11328401408 1835856160 18.307 94 13 26 0 1862814976 23610416 3348400
18:41:50 55754 8192000000 10882648480 11316088832 1863865024 18.535 96 28 56 2 1881213376 9333488 8014864
18:42:54 12247 8192000000 10899303920 11333001216 1926688464 19.040 99 55 109 4 1952013632 10486080 14839088
18:43:12 7348 8192000000 10910908128 11336495104 1947333264 19.205 100 72 142 3 1980364320 12754224 20276832
18:43:36 77385 8192000000 10876565376 11329064960 1925992448 19.035 99 50 101 1 1954554000 14456832 14104720
18:45:00 84356 8192000000 10860505312 11323195392 1883281088 18.692 97 28 56 1 1901560768 10700480 7579200
18:46:31 37923 8192000000 10860582912 11322179584 1915873664 18.954 99 14 28 0 1928769728 8748480 4147584
18:47:19 35920 8192000000 10876493456 11335680000 1949201776 19.220 100 24 48 0 1964236288 8006432 7028080
18:48:02 69621 8192000000 10857681152 11340566528 1933116864 19.092 99 13 26 0 1950787120 13879632 3790624
18:49:18 47781 8192000000 10855566944 11323400192 1868922176 18.576 96 11 22 0 1879740048 7544320 3273552
18:50:14 34678 8192000000 10847748832 11305115648 1903833232 18.857 98 24 47 1 1920058400 9112496 7112672
18:51:03 62047 8192000000 10864210432 11334676480 1942654096 19.168 100 15 30 0 1957109024 9805808 4649120
18:52:14 52242 8192000000 10867323776 11345690624 1952636032 19.247 100 17 34 2 1968338352 10844208 4858112
18:53:20 38401 8192000000 10857910688 11327475712 1906903280 18.882 98 13 26 0 1918373904 7737328 3733296
18:54:04 50640 8192000000 10869534128 11330609152 1909440880 18.902 98 21 42 1 1924454336 8965280 6048176
18:55:07 38179 8192000000 10882271040 11346186240 1934151296 19.100 99 21 42 3 1952233952 12295312 5787344
18:55:53 89551 8192000000 10895474224 11371393024 1949153760 19.220 99 18 36 1 1967311360 12778032 5379568
18:57:30 42924 8192000000 10908658752 11371356160 1961022240 19.314 99 26 52 2 1976280384 7792672 7465472
18:58:19 71499 8192000000 10879070048 11349520384 1871692736 18.598 95 11 22 0 1884342656 10056464 2593456
18:59:40 53289 8192000000 10909657712 11376934912 1971046736 19.394 100 19 38 0 1986368064 10260352 5060976
19:00:41 65159 8192000000 10889802528 11359248384 1919204640 18.980 97 11 22 1 1931585984 9433040 2948304
19:01:53 47952 8192000000 10934784592 11374379008 1936661568 19.120 98 36 72 2 1954612736 8383248 9567920
19:02:49 17326 8192000000 10924524672 11377967104 1981399136 19.476 100 40 80 0 2002804896 10455104 10950656
19:03:15 14843 8192000000 10922625920 11377053696 1964763616 19.344 99 45 90 0 1987126912 10366080 11997216
19:03:38 41465 8192000000 10903829616 11365359616 1917344672 18.966 97 32 64 0 1936980224 10950368 8685184
19:04:27 31707 8192000000 10919554176 11362258944 1936779024 19.121 98 52 104 2 1963069264 11148384 15141856
19:05:05 27167 8192000000 10908747504 11357646848 1932226848 19.085 98 49 98 2 1957383904 11660272 13496784
19:05:40 16946 8192000000 10898472592 11346563072 1925853472 19.034 98 39 78 1 1946450064 10131712 10464880
19:06:08 19088 8192000000 10920005504 11371122688 1972098720 19.402 100 50 100 3 1997961344 12315840 13546784
19:06:41 77367 8192000000 10902867344 11387768832 1976294096 19.435 100 36 72 2 2005187904 18736160 10157648
19:10:04 70665 8192000000 10900781616 11363934208 1953507856 19.254 99 29 58 1 1974617568 12768256 8341456
19:11:53 62506 8192000000 10901454864 11382837248 1975417264 19.428 100 18 36 0 1995519600 14610080 5492256
19:13:05 63593 8192000000 10906430128 11389116416 1964712736 19.343 99 13 25 0 1982435248 14228256 3494256
19:14:15 56778 8192000000 10921260256 11396481024 1991327920 19.554 100 18 36 0 2010824608 14369984 5126704
19:15:21 90512 8192000000 10908991104 11401080832 1966998160 19.362 99 16 32 0 1989242416 16766144 5478112
19:17:09 93666 8192000000 10887872784 11361652736 1868167808 18.569 94 15 31 1 1885331104 12614864 4548432
19:18:50 62353 8192000000 10887211888 11368910848 1923210432 19.013 98 14 28 0 1939857184 12478768 4167984
19:19:59 48917 8192000000 10888992720 11365519360 1891265872 18.756 96 16 32 2 1911528848 15230928 5032048
19:20:57 40282 8192000000 10892899968 11361112064 1928360912 19.054 98 17 34 0 1940781744 7485472 4935360
19:21:50 57282 8192000000 10879855680 11365335040 1915260416 18.949 97 26 52 1 1933754960 10611344 7883200
19:22:59 89045 8192000000 10869283280 11337871360 1808229600 18.081 92 17 33 1 1822405072 9673152 4502320
19:24:39 24389 8192000000 10878272160 11334975488 1894714288 18.784 97 29 58 1 1915242544 12414864 8113392
19:25:15 86543 8192000000 10879675136 11351580672 1894637664 18.783 97 18 36 1 1914101248 14183824 5279760
19:26:55 44837 8192000000 9040466112 9240465408 206369312 2.457 11 3 6 0 207783792 958496 455984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 29-03-2021 19:28:26 to 29-03-2021 19:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 86 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-03-2021 19:28:57 to 29-03-2021 19:28:59.

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

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