Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.06.2021 22: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 17070280 kB
MemAvailable 31410368 kB
Buffers 0 kB
Cached 14617872 kB
SwapCached 2440 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-18 22:27:39
DTS_END                         2021-06-18 22:27:39.7890
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54344
TRN_ID                          240837
ATT_ID                          625
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: 9198.80 24333 1103856
customer order: creation 168.95 359 20274
customer order: refuse 15.63 330 1875
order to supplier: creation 45.88 1342 5505
order to supplier: removal 3.45 112930 414
invoice (draft): creation 46.82 3862 5618
invoice (draft): removal 52.69 886 6323
invoice accept: apply 41.29 17234 4955
invoice accept: cancel 46.93 951 5632
customer reserve: creation 3813.94 168 457673
customer reserve: removal 4673.55 66 560826
realization accept: apply 83.53 190 10023
realization accept: cancel 76.16 102 9139
payment from customer: creation 58.86 142 7063
payment from customer: removal 5.93 69 712
payment to supplier: creation 48.99 133 5879
payment to supplier: removal 3.49 73 419
service: total inventory turnovers 5.03 1325 603
service: total monetary turnovers 6.74 42 809
service: aggregate perf. data 0.92 19226 110
service: refresh index statistics 0.03 327236 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-06-2021 22:29:06 to 18-06-2021 22:29:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2054
TEST_TIME 2 3274
TEST_TIME 3 3623
TEST_TIME 4 3878
TEST_TIME 5 4678
TEST_TIME 6 4554
TEST_TIME 7 4532
TEST_TIME 8 4893
TEST_TIME 9 5081
TEST_TIME 10 5341
TEST_TIME 11 5296
TEST_TIME 12 5494
TEST_TIME 13 5847
TEST_TIME 14 6104
TEST_TIME 15 6474
TEST_TIME 16 6693
TEST_TIME 17 6694
TEST_TIME 18 7390
TEST_TIME 19 7791
TEST_TIME 20 7825
TEST_TIME 21 7818
TEST_TIME 22 8373
TEST_TIME 23 8972
TEST_TIME 24 8900
TEST_TIME 25 8825
TEST_TIME 26 8734
TEST_TIME 27 8680
TEST_TIME 28 8687
TEST_TIME 29 9182
TEST_TIME 30 9593
TEST_TIME 31 10803
TEST_TIME 32 10833
TEST_TIME 33 10544
TEST_TIME 34 10549
TEST_TIME 35 10567
TEST_TIME 36 10443
TEST_TIME 37 10260
TEST_TIME 38 10066
TEST_TIME 39 9976
TEST_TIME 40 10023
TEST_TIME 41 10038
TEST_TIME 42 9920
TEST_TIME 43 9855
TEST_TIME 44 9888
TEST_TIME 45 9893
TEST_TIME 46 9784
TEST_TIME 47 9829
TEST_TIME 48 9777
TEST_TIME 49 9732
TEST_TIME 50 9715
TEST_TIME 51 9701
TEST_TIME 52 9608
TEST_TIME 53 9518
TEST_TIME 54 9486
TEST_TIME 55 9460
TEST_TIME 56 9407
TEST_TIME 57 9363
TEST_TIME 58 9299
TEST_TIME 59 9309
TEST_TIME 60 9268
TEST_TIME 61 9240
TEST_TIME 62 9274
TEST_TIME 63 9247
TEST_TIME 64 9141
TEST_TIME 65 9087
TEST_TIME 66 9200
TEST_TIME 67 9178
TEST_TIME 68 9211
TEST_TIME 69 9245
TEST_TIME 70 9306
TEST_TIME 71 9354
TEST_TIME 72 9397
TEST_TIME 73 9377
TEST_TIME 74 9452
TEST_TIME 75 9447
TEST_TIME 76 9565
TEST_TIME 77 9575
TEST_TIME 78 9643
TEST_TIME 79 9578
TEST_TIME 80 9475
TEST_TIME 81 9441
TEST_TIME 82 9410
TEST_TIME 83 9374
TEST_TIME 84 9336
TEST_TIME 85 9338
TEST_TIME 86 9297
TEST_TIME 87 9291
TEST_TIME 88 9254
TEST_TIME 89 9250
TEST_TIME 90 9251
TEST_TIME 91 9305
TEST_TIME 92 9322
TEST_TIME 93 9348
TEST_TIME 94 9412
TEST_TIME 95 9375
TEST_TIME 96 9384
TEST_TIME 97 9438
TEST_TIME 98 9467
TEST_TIME 99 9435
TEST_TIME 100 9437
TEST_TIME 101 9439
TEST_TIME 102 9492
TEST_TIME 103 9527
TEST_TIME 104 9500
TEST_TIME 105 9554
TEST_TIME 106 9468
TEST_TIME 107 9426
TEST_TIME 108 9370
TEST_TIME 109 9354
TEST_TIME 110 9357
TEST_TIME 111 9312
TEST_TIME 112 9275
TEST_TIME 113 9315
TEST_TIME 114 9287
TEST_TIME 115 9234
TEST_TIME 116 9215
TEST_TIME 117 9185
TEST_TIME 118 9200
TEST_TIME 119 9191
TEST_TIME 120 9207

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-06-2021 22:29:09 to 18-06-2021 22:29:13.

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 1527627 1527627 0 0.00 0 15093 6 0 0
doc_list_biud 1527618 1527618 0 0.00 0 21900 31 0 0
sp_add_invoice_to_stock 5115 4955 160 3.12 31 148414 17234 0 160
sp_cancel_adding_invoice 5632 5632 0 0.00 6 81147 951 0 0
sp_cancel_client_order 1875 1875 0 0.00 4 18595 331 0 0
sp_cancel_customer_reserve 560826 560826 0 0.00 1 21903 66 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 3 6336 70 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 1869 74 0 0
sp_cancel_supplier_invoice 6330 6323 7 0.11 2 19951 886 0 7
sp_cancel_supplier_order 414 414 0 0.00 9 961939 112931 0 0
sp_cancel_write_off 9139 9139 0 0.00 1 7676 103 0 0
sp_client_order 20274 20274 0 0.00 4 13646 360 0 0
sp_customer_reserve 457673 457673 0 0.00 0 96682 169 0 0
sp_fill_shopping_cart 31388 31388 0 0.00 1 30175 45 0 0
sp_fill_shopping_cart_clo_res 457668 457668 0 0.00 0 36147 14 0 0
sp_get_clo_for_invoice 4950 4950 0 0.00 0 36111 304 0 0
sp_kill_cost_storno 15902 15902 0 0.00 0 7368 58 0 0
sp_kill_qstorno_ret_qs2qd 1137528 1137528 0 0.00 0 21899 36 0 0
sp_kill_qty_storno 599178 599178 0 0.00 0 21899 77 0 0
sp_lock_selected_doc 20873 20873 0 0.00 0 10034 6 0 0
sp_make_cost_storno 27915 27915 0 0.00 0 15090 56 0 0
sp_multiply_rows_for_pdistr 27914 27914 0 0.00 0 7541 30 0 0
sp_multiply_rows_for_qdistr 20274 20274 0 0.00 0 12879 146 0 0
sp_pay_from_customer 7063 7063 0 0.00 4 43124 143 0 0
sp_pay_to_supplier 5879 5879 0 0.00 5 9376 133 0 0
sp_payment_common 12938 12938 0 0.00 1 40653 40 0 0
sp_qd_handle_on_cancel_clo 1875 1875 0 0.00 0 18588 305 0 0
sp_qd_handle_on_invoice_upd_sts 10581 10581 0 0.00 0 13684 370 0 0
sp_qd_handle_on_reserve_upd_sts 10020 10020 0 0.00 0 18038 62 0 0
sp_reserve_write_off 10023 10023 0 0.00 6 19482 191 0 0
sp_supplier_invoice 5618 5618 0 0.00 7 108956 3862 0 0
sp_supplier_order 5505 5505 0 0.00 5 30028 1343 0 0
srv_aggregate_perf_data 110 110 0 0.00 2415 168987 19227 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1289 160510 30892 0 0
srv_find_qd_qs_mism 1056371 1056371 0 0.00 0 13543 5 0 0
srv_make_invnt_saldo 603 603 0 0.00 36 159671 1326 0 0
srv_make_money_saldo 809 809 0 0.00 1 12622 42 0 0
srv_recalc_idx_stat 4 4 0 0.00 152775 479182 327236 0 0
t$perf-abend:sp_add_invoice_to_stock 160 160 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 4958 4958 0 0.00 0 13447 174 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 7705 130 0 0
t$perf-norm:sp_cancel_client_order 1875 1875 0 0.00 0 4140 12 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 1456 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 712 712 0 0.00 0 1145 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 4619 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 2590 22 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 26995 1738 0 0
t$perf-norm:sp_cancel_write_off 972 972 0 0.00 0 3679 18 0 0
t$perf-norm:sp_client_order 20274 20274 0 0.00 0 6711 19 0 0
t$perf-norm:sp_customer_reserve 963 963 0 0.00 0 2095 7 0 0
t$perf-norm:sp_pay_from_customer 7063 7063 0 0.00 0 4240 10 0 0
t$perf-norm:sp_pay_to_supplier 5879 5879 0 0.00 0 7005 14 0 0
t$perf-norm:sp_reserve_write_off 10023 10023 0 0.00 0 7510 12 0 0
t$perf-norm:sp_supplier_invoice 5618 5618 0 0.00 0 6796 16 0 0
t$perf-norm:sp_supplier_order 5505 5505 0 0.00 0 10340 20 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 465 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 1402 15 0 0
t$perf-norm:srv_make_invnt_saldo 603 603 0 0.00 0 1244 28 0 0
t$perf-norm:srv_make_money_saldo 809 809 0 0.00 0 977 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10218 9898 320 3.13 0 5117 20 0 320
v_all_customers 36450 36450 0 0.00 0 16 1 0 0
v_all_suppliers 30620 30620 0 0.00 0 49 1 0 0
v_all_wares 40534 40534 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 633 7 0 0
v_cancel_client_order 3750 3750 0 0.00 0 3486 5 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 2860 5 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 672 4 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 1751 9 0 0
v_cancel_supplier_invoice 842 828 14 1.66 0 2391 17 0 14
v_cancel_supplier_order 828 828 0 0.00 0 2348 7 0 0
v_cancel_write_off 1944 1944 0 0.00 0 2911 13 0 0
v_max_id_clo_ord 5504 5504 0 0.00 0 256 1 0 0
v_max_id_clo_res 963 963 0 0.00 0 4940 18 0 0
v_max_id_ord_sup 5617 5617 0 0.00 0 6152 5 0 0
v_max_non_paid_invoice 1684 1684 0 0.00 0 294 2 0 0
v_max_non_paid_realizn 3949 3949 0 0.00 0 7948 6 0 0
v_min_id_clo_ord 5504 5504 0 0.00 0 3859 8 0 0
v_min_id_clo_res 963 963 0 0.00 0 4186 7 0 0
v_min_id_ord_sup 5617 5617 0 0.00 0 9177 17 0 0
v_min_non_paid_invoice 5877 5877 0 0.00 0 7950 20 0 0
v_min_non_paid_realizn 7061 7061 0 0.00 0 40643 31 0 0
v_our_firm 10308 10308 0 0.00 0 83 1 0 0
v_reserve_write_off 20040 20040 0 0.00 0 5547 9 0 0
x_lock_depdocs_on_canc_invoice 11541 11541 0 0.00 0 18761 133 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 16704 420 0 0
x_make_qstorno_1000_1200 5505 5505 0 0.00 1 30012 1258 0 0
x_make_qstorno_1200_2000 5618 5618 0 0.00 3 103028 3696 0 0
x_make_qstorno_2100_3300 457673 457673 0 0.00 0 96681 153 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 18-06-2021 22:29:13 to 18-06-2021 22:29:18.

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
19:57:43 4 8192000000 8800800176 8812068864 6918192 0.084 2 1 2 0 7037568 56816 62560
19:57:49 13424 8192000000 10235965664 10536521728 915260224 10.049 73 38 73 1 930071104 2267376 12543504
19:58:13 29815 8192000000 10342251360 10657939456 1380216160 14.418 100 84 168 1 1411780112 4673296 26890656
19:58:51 38309 8192000000 10391915776 10715885568 1437688416 14.929 100 84 168 1 1471908016 6660272 27559328
19:59:48 19867 8192000000 10431015136 10762067968 1475707584 15.264 100 87 175 0 1511777104 7792928 28276592
20:00:16 15483 8192000000 10445970416 10778734592 1499217296 15.469 100 89 178 2 1536593600 8909392 28466912
20:00:52 20922 8192000000 10464925456 10803843072 1515976912 15.615 100 85 171 0 1552726000 9737184 27011904
20:01:30 18974 8192000000 10492935520 10837630976 1550763504 15.917 100 85 171 0 1587084592 10339584 25981504
20:01:55 16553 8192000000 10515646560 10862366720 1575661456 16.131 100 89 178 0 1613866736 10936928 27268352
20:02:23 19280 8192000000 10537239280 10891001856 1595671472 16.302 100 80 160 0 1630614368 11056864 23886032
20:02:54 15985 8192000000 10558409632 10915151872 1617740512 16.491 100 81 162 1 1653317936 11214736 24362688
20:03:21 9145 8192000000 10572136576 10933202944 1639934224 16.679 100 80 160 0 1675064464 10868656 24261584
20:03:41 8459 8192000000 10578601168 10945417216 1646202336 16.732 100 79 158 1 1685177296 15838752 23136208
20:03:59 11591 8192000000 10602147568 10966540288 1662586960 16.871 100 79 158 2 1696675296 11380752 22707584
20:04:20 8435 8192000000 10618440224 10986287104 1683401216 17.046 100 74 149 0 1716776160 11650320 21724624
20:04:36 6737 8192000000 10636562416 11003760640 1695961424 17.151 100 82 164 0 1733045744 12730528 24353792
20:04:49 8390 8192000000 10646241984 11019206656 1705756432 17.233 100 81 162 1 1742027312 12754480 23516400
20:05:06 10218 8192000000 10663772960 11036815360 1726561712 17.407 100 86 172 0 1765039760 13473872 25004176
20:05:26 4490 8192000000 10667825824 11044368384 1733629600 17.466 100 74 148 0 1767531424 12764864 21136960
20:05:39 6101 8192000000 10684462704 11059974144 1743172288 17.545 100 78 156 0 1778450192 13020112 22257792
20:05:52 4681 8192000000 10696684288 11076091904 1760865040 17.692 100 81 162 0 1797273616 13768480 22640096
20:06:04 4996 8192000000 10702258608 11081392128 1767702800 17.748 100 83 165 1 1805056272 14247408 23106064
20:06:16 5174 8192000000 10714660592 11094159360 1774221696 17.802 100 73 146 1 1808409584 13779696 20408192
20:06:27 3993 8192000000 10716021888 11101130752 1782591376 17.871 100 69 138 0 1814763200 12317024 19854800
20:06:40 4522 8192000000 10717791392 11103227904 1789785952 17.930 100 77 154 0 1823274192 11398128 22090112
20:06:51 4033 8192000000 10734821744 11118481408 1792102496 17.949 100 69 138 0 1823289536 11542736 19644304
20:07:02 3152 8192000000 10754816000 11136892928 1811882816 18.111 100 85 169 1 1848164368 12201616 24079936
20:07:12 3367 8192000000 10753691536 11140120576 1815439888 18.140 100 82 163 1 1850719904 12192672 23087344
20:07:22 3731 8192000000 10754576080 11139452928 1816638848 18.150 100 76 152 0 1850248208 12564624 21044736
20:07:32 2188 8192000000 10767256912 11149434880 1824843456 18.217 100 90 180 2 1863944176 13718768 25381952
20:07:42 1720 8192000000 10774605024 11156418560 1829631488 18.256 100 87 170 2 1867903440 14343936 23928016
20:07:51 2736 8192000000 10777273424 11162484736 1837434592 18.320 100 92 183 2 1877429472 14208608 25786272
20:08:00 1948 8192000000 10787350448 11172835328 1844119088 18.374 100 85 170 0 1881396320 13448528 23828704
20:08:08 1230 8192000000 10791446800 11176751104 1846757328 18.396 100 90 181 1 1886492736 14343920 25391488
20:08:16 2228 8192000000 10791772944 11186044928 1856816496 18.477 100 80 160 0 1891071184 11749088 22505600
20:08:25 1692 8192000000 10808413920 11193139200 1863056912 18.528 100 94 188 2 1902915488 13589616 26268960
20:08:33 2012 8192000000 10808120832 11195674624 1869069280 18.577 100 96 193 0 1909188912 12373104 27746528
20:08:41 1939 8192000000 10805074768 11197730816 1869202336 18.578 100 91 183 1 1907393968 12319840 25871792
20:08:49 2559 8192000000 10804592528 11203182592 1870139024 18.585 100 81 161 0 1904172048 11486272 22546752
20:09:03 21947 8192000000 10805848080 11206070272 1874284448 18.619 100 79 158 3 1908242448 11107776 22850224
20:09:34 9093 8192000000 10791456128 11202490368 1869491264 18.580 100 44 88 0 1891755696 10384048 11880384
20:09:50 9567 8192000000 10777087904 11203219456 1872118784 18.601 100 33 66 2 1890075008 8497056 9459168
20:10:09 3568 8192000000 10793567456 11211939840 1874922960 18.624 100 38 76 1 1894114464 8719584 10471920
20:10:22 8364 8192000000 10782829936 11207036928 1875422704 18.628 100 32 63 1 1890702832 6334064 8946064
20:10:39 4146 8192000000 10781206016 11208073216 1876862352 18.640 100 30 60 0 1892434592 7342768 8229472
20:10:50 9160 8192000000 10785159584 11211436032 1876885472 18.640 100 19 39 1 1887025744 5318896 4821376
20:11:08 9693 8192000000 10785970224 11218157568 1880196224 18.667 100 15 30 0 1889896288 5895760 3804304
20:11:27 5095 8192000000 10797032560 11225448448 1885332384 18.708 100 24 48 1 1898490272 6845552 6312336
20:11:38 6580 8192000000 10791816304 11220729856 1884593936 18.702 100 19 38 0 1896139168 6153296 5391936
20:11:51 6937 8192000000 10803430528 11229786112 1885711328 18.711 100 19 38 0 1900869136 10310656 4847152
20:12:06 11665 8192000000 10789248512 11222331392 1884935488 18.705 100 13 26 0 1899533440 10362848 4235104
20:12:24 6322 8192000000 10803171696 11230806016 1889283136 18.740 100 22 44 2 1901495472 6342896 5869440
20:12:40 17843 8192000000 10790287184 11229835264 1891555472 18.758 100 19 38 1 1902841968 5724016 5562480
20:13:08 45086 8192000000 10827643456 11240828928 1895334528 18.789 100 33 65 4 1909839520 5364960 9140032
20:14:25 6080 8192000000 10804431280 11243393024 1896331312 18.797 100 21 39 0 1908530400 5882368 6316720
20:14:39 6772 8192000000 10819539616 11250905088 1900282816 18.829 100 22 44 1 1912503888 6173728 6047344
20:14:56 6320 8192000000 10818459744 11246227456 1901019792 18.834 100 25 50 1 1914531552 5779456 7732304
20:15:10 7498 8192000000 10831321712 11256410112 1905305280 18.869 100 39 78 2 1924082960 7454272 11323408
20:15:24 2791 8192000000 10828917584 11258589184 1904579264 18.863 100 35 70 3 1921940384 7193840 10167280
20:15:34 6560 8192000000 10821152128 11255447552 1905596752 18.871 100 20 39 1 1917635040 6669744 5368544
20:15:48 3599 8192000000 10810367680 11243143168 1896858640 18.801 100 35 70 1 1914149936 7367184 9924112
20:16:00 7168 8192000000 10818904176 11248570368 1899601792 18.823 100 23 46 2 1912342864 5232864 7508208
20:16:13 8131 8192000000 10805482320 11243520000 1880645376 18.670 99 21 42 0 1892664464 6007184 6011904
20:16:28 5368 8192000000 10800866224 11239464960 1891197392 18.755 100 13 27 0 1900857552 5254144 4406016
20:16:41 8410 8192000000 10804368672 11243917312 1896759920 18.800 100 22 44 0 1909316896 6276016 6280960
20:16:59 9623 8192000000 10817339824 11244277760 1880263632 18.667 99 27 54 0 1894169344 6832240 7073472
20:17:17 10896 8192000000 10793019328 11235323904 1857841968 18.486 98 23 45 1 1871341968 6370176 7129824
20:17:36 14401 8192000000 10785475136 11211030528 1852742416 18.444 98 25 50 1 1865910192 5519296 7648480
20:17:59 60668 8192000000 10795580624 11222781952 1838465360 18.328 97 44 86 1 1857251264 5564160 13221744
20:19:06 10990 8192000000 10771425712 11208273920 1832318512 18.278 97 16 32 1 1842864288 5459952 5085824
20:19:29 8800 8192000000 10747869120 11174637568 1807569072 18.076 97 25 49 1 1820268144 5718560 6980512
20:19:45 7505 8192000000 10768306000 11192967168 1838217808 18.326 99 31 62 0 1854020304 7140640 8661856
20:20:02 5319 8192000000 10769990448 11187453952 1822056544 18.194 98 33 66 0 1837596544 5527888 10012112
20:20:14 7314 8192000000 10739691472 11155668992 1807125408 18.072 99 29 59 1 1821946928 5917984 8903536
20:20:31 5005 8192000000 10731493184 11148914688 1801908016 18.030 99 43 85 3 1825272048 11019648 12344384
20:20:42 7871 8192000000 10669833632 11086524416 1683215168 17.044 94 19 39 1 1694185888 5202912 5767808
20:20:57 9183 8192000000 10674326464 11088699392 1651348400 16.776 92 21 42 1 1667732640 9910704 6473536
20:21:13 8532 8192000000 10697403392 11111194624 1748147008 17.586 98 33 66 0 1763838240 5160944 10530288
20:21:32 10066 8192000000 10731432304 11150487552 1790119632 17.933 99 26 52 0 1803113440 5653840 7339968
20:21:49 8222 8192000000 10740538592 11159068672 1817654416 18.159 100 38 75 1 1838823312 10271088 10897808
20:22:03 14867 8192000000 10705447968 11121029120 1721900240 17.368 94 21 42 1 1732600992 4435584 6265168
20:22:27 8409 8192000000 10717473424 11141517312 1802072992 18.031 100 22 43 1 1818051216 10122672 5855552
20:22:44 8278 8192000000 10722527248 11154149376 1817518336 18.157 100 20 39 2 1830077456 6575328 5983792
20:23:00 47145 8192000000 10742831584 11161907200 1825429760 18.222 100 33 63 1 1840109552 5436000 9243792
20:23:57 15097 8192000000 10750870672 11175149568 1836922144 18.316 100 37 72 1 1853969520 6830304 10217072
20:24:20 10108 8192000000 10760684896 11180437504 1838815312 18.331 100 27 52 0 1852444672 6317680 7311680
20:24:36 4349 8192000000 10766366944 11194478592 1851244768 18.432 100 36 72 1 1869808992 8606112 9958112
20:24:47 7765 8192000000 10774380256 11195727872 1851069856 18.431 100 30 60 0 1866603664 6762672 8771136
20:25:01 6473 8192000000 10774062016 11197431808 1838064464 18.325 99 24 48 2 1851322528 6431088 6826976
20:25:16 6702 8192000000 10794083952 11210240000 1866027616 18.552 100 40 80 4 1885275808 6899984 12348208
20:25:32 8005 8192000000 10782611056 11204046848 1863183408 18.529 100 31 62 2 1882738224 10640432 8914384
20:25:50 6766 8192000000 10783307936 11214610432 1868160464 18.569 100 26 52 1 1881601728 5886688 7554576
20:26:04 7741 8192000000 10805005312 11225640960 1872757232 18.607 100 35 69 1 1892775248 9344720 10673296
20:26:20 7936 8192000000 10789266480 11220934656 1877427472 18.644 100 25 48 2 1888881712 5013872 6440368
20:26:37 7736 8192000000 10794376272 11226533888 1878241808 18.651 100 15 30 2 1887731888 5061840 4428240
20:26:51 10896 8192000000 10806624976 11230486528 1880270896 18.667 100 22 44 0 1892498128 5588160 6639072
20:27:08 13391 8192000000 10811082064 11239780352 1891452704 18.757 100 15 30 0 1900243376 4755376 4035296
20:27:33 50927 8192000000 10832918976 11255500800 1904751328 18.864 100 28 56 1 1921717088 9448816 7516944
20:29:12 27777 8192000000 10848894864 11273302016 1924231968 19.021 100 42 84 0 1942832672 7034912 11565792
20:29:46 24776 8192000000 10871154272 11296714752 1933085680 19.092 100 50 100 0 1960717872 13204448 14427744
20:30:19 17522 8192000000 10877880976 11301175296 1938234800 19.133 100 44 87 0 1963949760 13543168 12171792
20:30:52 5687 8192000000 10869757680 11300601856 1940036336 19.147 100 48 96 0 1965519712 11823376 13660000
20:31:08 5154 8192000000 10879475760 11307859968 1946543296 19.199 100 59 117 1 1975751296 11984384 17223616
20:31:21 11124 8192000000 10888434704 11318202368 1955888464 19.273 100 62 124 1 1986407904 13161232 17358208
20:31:40 21531 8192000000 10890722112 11321573376 1958145824 19.291 100 53 106 0 1986978352 13673088 15159440
20:32:26 4214 8192000000 10894078048 11324104704 1962003488 19.322 100 51 101 0 1989384160 12935408 14445264
20:32:41 4203 8192000000 10915044032 11333046272 1969126480 19.379 100 62 123 0 2001013952 13784128 18103344
20:32:52 3031 8192000000 10906607024 11334582272 1972758720 19.407 100 65 128 2 2005702240 13274032 19669488
20:33:03 8353 8192000000 10909201920 11337506816 1972945120 19.409 100 54 106 3 2001089776 13113888 15030768
20:33:21 5819 8192000000 10913151936 11345231872 1976734640 19.439 100 51 100 2 2004906800 13207968 14964192
20:33:37 2125 8192000000 10926243664 11346624512 1980742016 19.471 100 60 119 2 2011676640 14277696 16656928
20:33:47 20619 8192000000 10930477488 11358478336 1982519824 19.485 100 59 118 1 2015182368 15650352 17012192
20:34:15 17622 8192000000 10925154528 11357724672 1985608592 19.509 100 53 106 0 2017998480 16808944 15580944
20:34:51 10488 8192000000 10928503824 11362332672 1990204176 19.545 100 50 99 0 2021480128 16668064 14607888
20:35:14 26145 8192000000 10938269840 11374170112 1991088608 19.552 100 53 106 0 2030968096 23834640 16044848
20:35:53 8473 8192000000 10934939360 11372781568 1993902336 19.575 100 44 88 0 2027221120 19319552 13999232
20:36:10 16538 8192000000 10938047552 11371196416 1975900256 19.432 99 42 84 1 2008394848 19064192 13430400
20:36:36 7191 8192000000 10945954912 11372556288 1994794768 19.582 100 57 113 0 2030748528 19424640 16529120
20:36:51 4039 8192000000 10944897184 11373326336 1999204288 19.616 100 69 136 3 2041434880 21464208 20766384
20:37:11 18517 8192000000 10944056144 11384848384 2004249248 19.656 100 46 93 1 2037791392 19669072 13873072
20:37:43 14799 8192000000 10954677600 11393810432 2008642976 19.691 100 41 81 3 2039887568 18490784 12753808
20:38:06 8056 8192000000 10945401008 11379933184 1996012752 19.591 99 59 117 6 2032615344 19621920 16980672
20:38:21 3650 8192000000 10970283680 11396112384 2014722544 19.739 100 68 136 3 2056104720 21268656 20113520
20:38:32 7583 8192000000 10967889328 11397349376 2011265760 19.711 100 69 137 0 2056130752 23908496 20956496
20:38:50 9474 8192000000 10930417664 11348885504 1936927056 19.122 96 63 126 1 1981733248 25271504 19534688
20:39:10 6728 8192000000 10956853728 11385028608 1992133632 19.561 100 59 118 1 2033791696 23824736 17833328
20:39:24 2945 8192000000 10959534288 11389423616 1998509616 19.611 100 59 117 0 2045917936 28519680 18888640
20:39:36 6625 8192000000 10948928992 11385475072 1999131072 19.616 100 53 106 2 2039376048 23696400 16548576
20:39:50 2881 8192000000 10948242384 11382644736 1994804032 19.582 100 55 109 1 2038684016 26887520 16992464
20:40:01 8437 8192000000 10954057536 11383091200 1994051136 19.576 100 53 106 0 2039531696 28636848 16843712
20:40:19 3077 8192000000 10960250560 11379064832 1979799280 19.463 99 75 149 0 2031781792 29296240 22686272
20:40:29 5451 8192000000 10964010368 11390717952 1997841616 19.606 100 69 138 0 2050450944 31485712 21123616
20:40:45 9246 8192000000 10959933536 11396698112 2003331168 19.649 100 58 111 1 2049236528 28989648 16915712
20:41:03 2540 8192000000 10963580240 11385520128 1990340416 19.546 100 75 149 0 2044498480 31313760 22844304
20:41:13 3519 8192000000 10979218752 11399188480 2002729872 19.644 100 78 156 0 2060525168 33255696 24539600
20:41:23 1652 8192000000 10966358480 11388727296 1984565280 19.501 99 78 157 1 2041045664 32086048 24394336
20:41:32 5042 8192000000 10956084400 11380219904 1971530912 19.398 99 74 148 2 2027967872 33307728 23129232
20:41:47 4752 8192000000 10960710304 11384102912 1989083536 19.537 100 71 140 2 2044318208 34085216 21149456
20:41:59 3261 8192000000 10964796736 11396898816 1998836000 19.614 100 63 126 0 2054727680 35134272 20757408
20:42:11 3316 8192000000 10972553520 11391123456 1995424400 19.587 100 68 136 1 2052082192 35517616 21140176
20:42:24 3511 8192000000 10957533504 11374071808 1982073888 19.481 100 82 164 1 2039034272 32487760 24472624
20:42:36 2752 8192000000 10957702368 11370897408 1953469504 19.254 98 93 187 0 2014675792 33161328 28044960
20:42:46 3002 8192000000 10949947008 11363090432 1951923424 19.242 98 87 170 1 2010105248 32301312 25880512
20:42:59 3625 8192000000 10942922032 11364978688 1968802160 19.376 100 73 146 1 2027095808 34904816 23388832
20:43:12 5145 8192000000 10940492832 11365269504 1968749296 19.376 100 65 130 6 2024587392 35382624 20455472
20:43:27 5302 8192000000 10906126624 11333550080 1930826800 19.073 98 62 125 1 1987034096 36420160 19787136
20:43:39 7501 8192000000 10945179376 11362377728 1966979776 19.361 100 74 148 0 2026606432 34849552 24777104
20:43:54 5646 8192000000 10937193760 11362377728 1964282592 19.340 100 72 143 1 2024790848 37639136 22869120
20:44:09 4501 8192000000 10949112656 11377516544 1973987408 19.417 100 63 126 1 2033619888 39228800 20403680
20:44:22 7001 8192000000 10950183600 11376689152 1979715536 19.462 100 66 130 0 2041301408 40590032 20995840
20:44:44 8489 8192000000 10951462368 11379433472 1960862704 19.313 99 67 135 0 2024143536 41726256 21554576
20:45:01 2444 8192000000 10955337712 11379888128 1971627776 19.398 100 66 130 3 2035363536 42512240 21223520
20:45:13 4535 8192000000 10971397088 11387863040 1982409408 19.484 100 78 157 1 2048820992 41680640 24730944
20:45:26 1841 8192000000 10948720256 11368824832 1940841744 19.153 98 82 164 1 2008143808 42374176 24927888
20:45:35 1489 8192000000 10955583408 11374653440 1972477504 19.405 100 87 175 2 2041088048 41364544 27246000
20:45:43 1923 8192000000 10946228080 11369263104 1965163440 19.347 100 75 150 1 2030864992 42113712 23587840
20:45:53 1829 8192000000 10943557136 11359211520 1945877760 19.194 99 84 168 2 2011514464 40074576 25562128
20:46:02 1347 8192000000 10952470928 11360858112 1961280960 19.316 100 86 172 3 2028735008 41011040 26443008
20:46:11 2691 8192000000 10955936896 11367628800 1963750864 19.336 100 83 165 1 2030957376 41610272 25596240
20:46:21 1757 8192000000 10939388800 11345022976 1944214960 19.180 99 83 166 0 2014083024 44592608 25275456
20:46:29 8428 8192000000 10922567360 11361923072 1954316832 19.261 100 61 122 0 2017049360 43543808 19188720
20:46:47 20221 8192000000 10872854144 11311022080 1852646528 18.444 95 25 50 1 1901293536 39926512 8720496
20:47:14 9755 8192000000 10893495920 11320262656 1915072880 18.947 100 44 87 2 1967775936 38849104 13853952
20:47:30 13260 8192000000 10895706960 11330265088 1924356224 19.022 100 35 72 1 1975436576 39738032 11342320
20:47:52 8229 8192000000 10930016816 11349364736 1941302080 19.157 100 57 113 2 2001751904 42387120 18062704
20:48:10 6534 8192000000 10932061808 11353923584 1949118272 19.219 100 71 141 0 2018776032 46385984 23271776
20:48:28 3321 8192000000 10953535472 11369652224 1958734944 19.296 100 84 169 1 2035199888 49930272 26534672
20:48:39 2494 8192000000 10949543280 11361599488 1936379856 19.118 99 86 172 1 2015683024 51712160 27591008
20:48:48 3296 8192000000 10952508144 11358478336 1946502208 19.199 100 89 174 0 2026621120 53705648 26413264
20:48:58 1808 8192000000 10957170720 11368509440 1949494688 19.222 100 91 180 0 2037340432 59029424 28816320
20:49:07 1288 8192000000 10924928832 11336445952 1924508416 19.023 99 83 164 1 2004340384 53591232 26240736
20:49:18 6434 8192000000 10923404240 11346075648 1937539376 19.127 100 60 119 6 2003229680 46412480 19277824
20:49:31 4109 8192000000 10934599168 11350720512 1926116128 19.036 99 76 152 1 1999708496 48257536 25334832
20:49:42 3597 8192000000 10940656160 11358490624 1946878880 19.202 100 75 151 1 2020753008 48869360 25004768
20:49:52 10505 8192000000 10889619856 11324297216 1900919280 18.834 98 53 106 1 1967895360 49769408 17206672
20:50:14 10532 8192000000 10909372688 11331457024 1913348064 18.934 99 45 90 1 1979573648 50893664 15331920
20:50:32 10999 8192000000 10916937968 11358109696 1927541792 19.047 99 47 94 1 1996344160 53046096 15756272
20:50:54 14968 8192000000 10912950816 11366125568 1935751232 19.113 100 34 68 0 1990711344 43647488 11312624
20:51:19 9674 8192000000 10912925712 11347247104 1924526176 19.023 99 34 68 2 1976372064 40508304 11337584
20:51:43 16270 8192000000 10926367856 11362091008 1951848336 19.241 100 35 70 1 2004673600 41101392 11723872
20:52:12 23005 8192000000 10936861568 11378290688 1957557344 19.287 100 40 78 2 2015269952 45085472 12627136
20:52:49 16835 8192000000 10942885296 11386048512 1965429952 19.349 100 33 66 3 2023516112 47026672 11059488
20:53:26 9942 8192000000 10945586496 11393953792 1972698944 19.407 100 33 66 1 2030712944 46757488 11256512
20:53:46 16713 8192000000 10957832912 11406594048 1978549120 19.453 100 32 60 1 2040695744 51842560 10304064
20:54:09 11346 8192000000 10961409744 11402817536 1979099472 19.458 100 35 70 0 2041739936 50707904 11932560
20:54:29 6758 8192000000 10973598896 11411296256 1983190704 19.490 100 44 88 0 2053881136 55597328 15093104
20:54:53 9463 8192000000 10967496592 11415822336 1981372096 19.476 100 38 76 0 2053042336 58357904 13312336
20:55:15 12436 8192000000 10954244992 11395813376 1975466864 19.429 100 34 68 1 2044052608 56378192 12207552
20:55:47 13400 8192000000 10956731232 11404136448 1965108288 19.347 100 33 66 1 2040373872 62749584 12516000
20:56:08 14750 8192000000 10947570992 11402551296 1964923808 19.345 100 32 64 3 2040129264 63297088 11908368
20:56:51 21600 8192000000 10944224224 11406569472 1953096912 19.251 100 27 54 1 2023741424 60188752 10455760
20:57:33 53472 8192000000 10920733040 11382587392 1929104496 19.060 99 17 34 1 1995505248 59917568 6483184
20:58:35 43912 8192000000 10899906608 11337875456 1911604608 18.920 98 19 38 2 1943073248 25939408 5529232
20:59:25 23286 8192000000 10867849728 11323854848 1914949888 18.946 98 20 40 0 1932527024 12063600 5513536
21:00:15 42276 8192000000 10875615520 11320098816 1909706592 18.904 98 35 70 1 1930233216 10404688 10121936
21:01:08 10210 8192000000 10882462112 11323670528 1942243920 19.165 100 38 76 0 1965568384 11932192 11392272
21:01:30 32707 8192000000 10888937408 11339005952 1951378432 19.237 100 30 58 1 1968289680 7572720 9338528
21:02:11 61504 8192000000 10866002048 11331149824 1916476288 18.959 98 6 12 0 1924772192 7178576 1117328
21:03:22 43853 8192000000 10863343792 11331084288 1933498528 19.095 99 12 24 2 1944232336 7660416 3073392
21:04:12 33054 8192000000 10872075856 11331936256 1940611344 19.152 99 14 29 0 1952808160 8772320 3424496
21:04:54 93419 8192000000 10924768128 11373899776 1957221040 19.284 100 19 38 1 1979404880 16782480 5401360
21:06:33 69338 8192000000 10914134112 11360403456 1946367056 19.198 99 22 44 2 1966408480 14530896 5510528
21:08:22 84570 8192000000 10909210368 11363532800 1958309856 19.293 99 28 56 1 1981830288 15754752 7765680
21:10:18 57021 8192000000 10909929440 11372072960 1976835424 19.440 100 19 38 1 1994458912 12225136 5398352
21:11:29 37707 8192000000 10902286144 11375505408 1958907344 19.297 99 11 22 1 1974776976 12865120 3004512
21:12:18 90343 8192000000 10916523696 11376607232 1961783008 19.320 99 10 19 1 1976644576 12001840 2859728
21:13:56 160508 8192000000 10921398112 11382292480 1956752976 19.280 98 16 32 3 1974536384 13738640 4044768
21:16:44 62655 8192000000 10905257680 11375521792 1954935344 19.266 98 15 30 0 1967540928 8668544 3937040
21:17:53 127343 8192000000 10898458784 11359424512 1837477504 18.320 92 21 40 4 1852084672 8390528 6216640
21:21:05 57508 8192000000 10877367712 11337924608 1922304592 19.005 97 40 80 2 1941684464 8321728 11058144
21:22:10 15580 8192000000 10935789296 11366920192 1977764864 19.447 100 59 117 0 2001134720 7111760 16258096
21:22:34 17798 8192000000 10930944032 11382534144 1971054288 19.394 99 57 112 1 2002177392 14755728 16367376
21:22:59 102836 8192000000 10923976240 11393286144 1998163984 19.608 100 34 68 0 2017557872 9564992 9828896
21:24:52 12846 8192000000 10904005024 11374309376 1954691952 19.264 98 8 16 0 1964149248 7165280 2292016
21:25:21 29541 8192000000 10942763152 11392536576 1983031552 19.489 99 49 98 1 2006196848 8184224 14981072
21:25:58 34048 8192000000 10945492656 11393851392 1967858064 19.368 98 36 72 3 1990040880 11138048 11044768
21:26:44 48169 8192000000 10907114496 11381559296 1953848032 19.257 98 36 72 1 1978555552 14172608 10534912
21:27:39 66493 8192000000 10898139088 11368574976 1912981296 18.931 96 15 30 0 1936659056 19712064 3965696
21:29:59 58899 8192000000 10888547600 11361751040 1948632384 19.216 99 18 34 2 1960524048 7033088 4858576
21:31:40 24746 8192000000 10900763568 11369996288 1973711456 19.415 100 27 52 1 1995951216 14777792 7461968
21:32:11 45682 8192000000 10871019984 11340582912 1892346304 18.765 96 13 26 0 1908306128 12603856 3355968
21:33:03 46376 8192000000 10881484384 11338039296 1889303152 18.740 97 3 6 0 1899929648 9741648 884848
21:33:56 39552 8192000000 10893493664 11345166336 1905109664 18.867 97 25 47 1 1920655792 8968960 6577168
21:34:47 20016 8192000000 10899033936 11343372288 1924353984 19.022 98 64 128 0 1954279024 11308592 18616448
21:35:22 14762 8192000000 10917554304 11354329088 1943311712 19.173 99 65 128 3 1979715776 17520112 18883952
21:35:47 60322 8192000000 10898960512 11359215616 1934982752 19.107 99 27 54 1 1955751248 13270032 7498464
21:36:57 62115 8192000000 10878480032 11334160384 1878425344 18.652 96 14 28 1 1901205776 18792784 3987648
21:38:08 47168 8192000000 10893792368 11356282880 1958164128 19.291 100 25 50 1 1975517472 10649040 6704304
21:39:18 59703 8192000000 10894623296 11365101568 1925824640 19.033 98 19 38 0 1944508912 12444528 6239744
21:40:39 98924 8192000000 10871969104 11343601664 1875929184 18.632 96 17 34 1 1905220512 23632080 5659248
21:42:24 59870 8192000000 10892706512 11363774464 1934685680 19.104 99 15 31 0 1956225200 17154896 4384624
21:43:32 98905 8192000000 10863327200 11333033984 1792007184 17.948 92 9 18 0 1807608000 12741184 2859632
21:45:18 84105 8192000000 10860664448 11312177152 1858301152 18.490 96 12 22 2 1870203216 8232784 3669280
21:46:58 115311 8192000000 10867939424 11332714496 1931111056 19.076 100 33 64 0 1947803200 6967392 9724752
21:49:41 52999 8192000000 10897936528 11357577216 1957271248 19.284 100 39 76 1 1982713568 14934400 10507920
21:50:41 25347 8192000000 10895341024 11346874368 1924578688 19.024 98 39 78 1 1946614912 10932752 11103472
21:51:15 57518 8192000000 10887593712 11362918400 1961086224 19.315 100 14 28 1 1974828016 9730064 4011728
21:52:19 66436 8192000000 10873739696 11351175168 1903075920 18.851 97 16 32 0 1918334272 10350480 4907872
21:53:35 57227 8192000000 10878444224 11343716352 1897193280 18.804 97 19 38 1 1914832624 11894704 5744640
21:54:43 56131 8192000000 10895216272 11356938240 1960831792 19.313 100 20 40 0 1977719168 11197648 5689728
21:56:34 66251 8192000000 10874387168 11346104320 1942365072 19.166 99 14 28 0 1958573968 12227408 3981488
21:57:47 51934 8192000000 10884496240 11348463616 1913138576 18.932 97 8 16 0 1921641888 6478224 2025088
21:58:48 20093 8192000000 10904456960 11367505920 1973901712 19.416 100 44 85 4 1993713312 7854016 11957584
21:59:24 85965 8192000000 10911197632 11381497856 1919802688 18.985 97 18 36 0 1933645520 8756096 5086736
22:01:24 60788 8192000000 10913329536 11380301824 1962150000 19.323 99 13 26 0 1973295056 7569856 3575200
22:02:31 28273 8192000000 10943404048 11398942720 1997999520 19.607 100 45 90 1 2022796144 11546896 13249728
22:03:08 48843 8192000000 10926282000 11398103040 1982873456 19.487 99 27 54 1 2007989616 17684400 7431760
22:04:03 60646 8192000000 10914137936 11383156736 1926487184 19.039 97 17 35 1 1946239856 15106832 4645840
22:05:10 73570 8192000000 10917859344 11377594368 1943140064 19.172 98 22 44 1 1958867600 9510784 6216752
22:06:30 44667 8192000000 10899321984 11361951744 1949652768 19.224 98 26 52 3 1967976208 10992432 7331008
22:07:22 67148 8192000000 10892806416 11362291712 1919253968 18.981 97 32 63 1 1939502896 11444432 8804496
22:08:36 71599 8192000000 10914875328 11395571712 1980759712 19.471 100 17 34 1 1998896096 13366096 4770288
22:09:54 129111 8192000000 10913992432 11390365696 1890500624 18.750 95 15 31 2 1905706192 11283424 3922144
22:12:10 94331 8192000000 10895562656 11379519488 1942152512 19.164 98 15 30 0 1960499712 13970832 4376368
22:14:23 94233 8192000000 10890579568 11356631040 1931608304 19.080 98 12 24 1 1943152736 8059184 3485248
22:16:06 57353 8192000000 10854506768 11336970240 1882863248 18.688 96 13 25 0 1893651328 7681328 3106752
22:17:11 72027 8192000000 10854187312 11346419712 1903608288 18.855 98 7 14 0 1917053632 11500288 1945056
22:18:31 14326 8192000000 10845755040 11320037376 1900240848 18.828 98 12 24 2 1913062064 9389296 3431920
22:18:58 71747 8192000000 10861655840 11324461056 1890361424 18.749 97 21 42 1 1904936096 8477520 6097152
22:20:18 60882 8192000000 10852940128 11321757696 1876107056 18.634 97 13 26 0 1886825328 7289120 3429152
22:21:25 37175 8192000000 10853236352 11333910528 1915099264 18.948 99 10 20 3 1923665856 6038128 2528464
22:22:14 95504 8192000000 10865309168 11345276928 1895143040 18.787 97 15 30 2 1908469488 9219504 4106944
22:24:00 62771 8192000000 10881367168 11362463744 1954431440 19.262 100 13 26 1 1969596176 11213600 3951136
22:25:09 66333 8192000000 10831817808 11312361472 1850197296 18.424 95 8 16 0 1865956848 13292624 2466928
22:26:25 56644 8192000000 10859990336 11337969664 1901930992 18.842 98 17 34 1 1920679680 13422576 5326112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 18-06-2021 22:29:19 to 18-06-2021 22:29:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 160 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 18-06-2021 22:29:52 to 18-06-2021 22:29:54.

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          239589
MON$OLDEST_ACTIVE               241052
MON$OLDEST_SNAPSHOT             241052
MON$NEXT_TRANSACTION            241052
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                       2050272
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:44: 
:45: mscs-test-161.budzdorov.ru    Fri Jun 18 22:27:49 2021
:46:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:47: 
:48: 
:49: mscs-test-161.budzdorov.ru    Fri Jun 18 22:27:51 2021
:50:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:51: 
--- end of diff output ---

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

18.06.21 22:29:55. 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-18 22:29:57 No severe PSQL-related problems occured
18.06.21 22:29:59. End of report.