Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.03.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 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 17506256 kB
MemAvailable 31499752 kB
Buffers 0 kB
Cached 14174520 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-27 22:27:23
DTS_END                         2021-03-27 22:27:23.8090
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_INVNT_SALDO(40:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52838
TRN_ID                          232866
ATT_ID                          657
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: 8957.26 21047 1074871
customer order: creation 170.77 395 20492
customer order: refuse 14.56 335 1747
order to supplier: creation 43.53 1312 5223
order to supplier: removal 3.36 99569 403
invoice (draft): creation 44.27 3399 5312
invoice (draft): removal 51.81 738 6217
invoice accept: apply 40.15 18901 4818
invoice accept: cancel 46.93 746 5631
customer reserve: creation 3696.77 188 443612
customer reserve: removal 4555.04 58 546605
realization accept: apply 81.13 177 9736
realization accept: cancel 83.37 114 10004
payment from customer: creation 57.91 112 6949
payment from customer: removal 5.46 77 655
payment to supplier: creation 47.14 133 5657
payment to supplier: removal 3.57 80 428
service: total inventory turnovers 4.68 1443 561
service: total monetary turnovers 6.16 33 739
service: aggregate perf. data 0.65 28478 78
service: refresh index statistics 0.03 264657 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-03-2021 22:28:51 to 27-03-2021 22:28:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6342
TEST_TIME 2 5996
TEST_TIME 3 5439
TEST_TIME 4 6117
TEST_TIME 5 5984
TEST_TIME 6 5661
TEST_TIME 7 5581
TEST_TIME 8 5457
TEST_TIME 9 5519
TEST_TIME 10 6333
TEST_TIME 11 6721
TEST_TIME 12 7001
TEST_TIME 13 7046
TEST_TIME 14 7098
TEST_TIME 15 7054
TEST_TIME 16 7323
TEST_TIME 17 7230
TEST_TIME 18 7530
TEST_TIME 19 8133
TEST_TIME 20 8287
TEST_TIME 21 8654
TEST_TIME 22 8931
TEST_TIME 23 9054
TEST_TIME 24 8828
TEST_TIME 25 9166
TEST_TIME 26 9788
TEST_TIME 27 10460
TEST_TIME 28 10532
TEST_TIME 29 10331
TEST_TIME 30 10155
TEST_TIME 31 10024
TEST_TIME 32 9863
TEST_TIME 33 9708
TEST_TIME 34 9569
TEST_TIME 35 9437
TEST_TIME 36 9575
TEST_TIME 37 9815
TEST_TIME 38 9692
TEST_TIME 39 9630
TEST_TIME 40 9480
TEST_TIME 41 9531
TEST_TIME 42 9476
TEST_TIME 43 9314
TEST_TIME 44 9121
TEST_TIME 45 9340
TEST_TIME 46 9197
TEST_TIME 47 9177
TEST_TIME 48 9089
TEST_TIME 49 9176
TEST_TIME 50 9106
TEST_TIME 51 9110
TEST_TIME 52 9131
TEST_TIME 53 9105
TEST_TIME 54 9108
TEST_TIME 55 9098
TEST_TIME 56 9339
TEST_TIME 57 9390
TEST_TIME 58 9339
TEST_TIME 59 9332
TEST_TIME 60 9397
TEST_TIME 61 9572
TEST_TIME 62 9562
TEST_TIME 63 9590
TEST_TIME 64 9452
TEST_TIME 65 9543
TEST_TIME 66 9488
TEST_TIME 67 9416
TEST_TIME 68 9342
TEST_TIME 69 9356
TEST_TIME 70 9287
TEST_TIME 71 9260
TEST_TIME 72 9247
TEST_TIME 73 9185
TEST_TIME 74 9137
TEST_TIME 75 9161
TEST_TIME 76 9142
TEST_TIME 77 9144
TEST_TIME 78 9167
TEST_TIME 79 9108
TEST_TIME 80 9176
TEST_TIME 81 9180
TEST_TIME 82 9166
TEST_TIME 83 9208
TEST_TIME 84 9201
TEST_TIME 85 9211
TEST_TIME 86 9238
TEST_TIME 87 9304
TEST_TIME 88 9294
TEST_TIME 89 9308
TEST_TIME 90 9346
TEST_TIME 91 9279
TEST_TIME 92 9207
TEST_TIME 93 9182
TEST_TIME 94 9157
TEST_TIME 95 9106
TEST_TIME 96 9131
TEST_TIME 97 9105
TEST_TIME 98 9157
TEST_TIME 99 9165
TEST_TIME 100 9125
TEST_TIME 101 9147
TEST_TIME 102 9252
TEST_TIME 103 9225
TEST_TIME 104 9217
TEST_TIME 105 9210
TEST_TIME 106 9279
TEST_TIME 107 9286
TEST_TIME 108 9272
TEST_TIME 109 9305
TEST_TIME 110 9256
TEST_TIME 111 9206
TEST_TIME 112 9150
TEST_TIME 113 9135
TEST_TIME 114 9111
TEST_TIME 115 9091
TEST_TIME 116 9080
TEST_TIME 117 9037
TEST_TIME 118 9037
TEST_TIME 119 9022
TEST_TIME 120 8961

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 27-03-2021 22:28:54 to 27-03-2021 22:28:58.

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 1485817 1485817 0 0.00 0 35638 7 0 0
doc_list_biud 1485817 1485817 0 0.00 0 70953 27 0 0
sp_add_invoice_to_stock 4970 4818 152 3.05 40 207447 18902 0 152
sp_cancel_adding_invoice 5631 5631 0 0.00 4 64025 747 0 0
sp_cancel_client_order 1747 1747 0 0.00 4 9462 336 0 0
sp_cancel_customer_reserve 546605 546605 0 0.00 1 70954 58 0 0
sp_cancel_pay_from_customer 655 655 0 0.00 2 4254 78 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 5581 81 0 0
sp_cancel_supplier_invoice 6231 6217 14 0.22 2 24259 738 0 14
sp_cancel_supplier_order 403 403 0 0.00 6 1116683 99569 0 0
sp_cancel_write_off 10004 10004 0 0.00 1 9297 115 0 0
sp_client_order 20492 20492 0 0.00 3 51951 395 0 0
sp_customer_reserve 443612 443612 0 0.00 0 119769 188 0 0
sp_fill_shopping_cart 31015 31015 0 0.00 1 25355 40 0 0
sp_fill_shopping_cart_clo_res 443589 443589 0 0.00 0 11764 14 0 0
sp_get_clo_for_invoice 4795 4795 0 0.00 0 35889 342 0 0
sp_kill_cost_storno 16718 16718 0 0.00 0 35612 61 0 0
sp_kill_qstorno_ret_qs2qd 1109834 1109834 0 0.00 0 70938 31 0 0
sp_kill_qty_storno 585138 585138 0 0.00 0 70953 68 0 0
sp_lock_selected_doc 20313 20313 0 0.00 0 8107 5 0 0
sp_make_cost_storno 27137 27137 0 0.00 0 16296 51 0 0
sp_multiply_rows_for_pdistr 27137 27137 0 0.00 0 14826 29 0 0
sp_multiply_rows_for_qdistr 20492 20492 0 0.00 0 30954 175 0 0
sp_pay_from_customer 6949 6949 0 0.00 4 19756 112 0 0
sp_pay_to_supplier 5657 5657 0 0.00 5 23751 133 0 0
sp_payment_common 12606 12606 0 0.00 2 23662 31 0 0
sp_qd_handle_on_cancel_clo 1747 1747 0 0.00 0 9440 302 0 0
sp_qd_handle_on_invoice_upd_sts 10426 10426 0 0.00 0 19247 316 0 0
sp_qd_handle_on_reserve_upd_sts 9736 9736 0 0.00 0 15114 60 0 0
sp_reserve_write_off 9736 9736 0 0.00 6 16346 177 0 0
sp_supplier_invoice 5312 5312 0 0.00 6 85585 3399 0 0
sp_supplier_order 5223 5223 0 0.00 5 47054 1313 0 0
srv_aggregate_perf_data 78 78 0 0.00 2747 401051 28479 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 868 184948 32941 0 0
srv_find_qd_qs_mism 1028641 1028641 0 0.00 0 14950 6 0 0
srv_make_invnt_saldo 561 561 0 0.00 42 96114 1444 0 0
srv_make_money_saldo 739 739 0 0.00 1 5898 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 129578 406210 264658 0 0
t$perf-abend:sp_add_invoice_to_stock 152 152 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4818 4818 0 0.00 0 11467 175 0 0
t$perf-norm:sp_cancel_adding_invoice 440 440 0 0.00 0 4348 77 0 0
t$perf-norm:sp_cancel_client_order 1747 1747 0 0.00 0 5250 13 0 0
t$perf-norm:sp_cancel_customer_reserve 691 691 0 0.00 0 5053 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 655 655 0 0.00 0 663 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 839 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 393 393 0 0.00 0 3397 28 0 0
t$perf-norm:sp_cancel_supplier_order 403 403 0 0.00 0 19447 1647 0 0
t$perf-norm:sp_cancel_write_off 1027 1027 0 0.00 0 874 4 0 0
t$perf-norm:sp_client_order 20492 20492 0 0.00 0 6978 18 0 0
t$perf-norm:sp_customer_reserve 1025 1025 0 0.00 0 714 4 0 0
t$perf-norm:sp_pay_from_customer 6949 6949 0 0.00 0 7116 11 0 0
t$perf-norm:sp_pay_to_supplier 5657 5657 0 0.00 0 6930 8 0 0
t$perf-norm:sp_reserve_write_off 9736 9736 0 0.00 0 10749 13 0 0
t$perf-norm:sp_supplier_invoice 5312 5312 0 0.00 0 7109 15 0 0
t$perf-norm:sp_supplier_order 5223 5223 0 0.00 0 10535 16 0 0
t$perf-norm:srv_aggregate_perf_data 78 78 0 0.00 0 151 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 567 14 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 2070 21 0 0
t$perf-norm:srv_make_money_saldo 739 739 0 0.00 0 722 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 9890 9586 304 3.07 0 8431 21 0 304
v_all_customers 37504 37504 0 0.00 0 22 1 0 0
v_all_suppliers 29150 29150 0 0.00 0 76 1 0 0
v_all_wares 40984 40984 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 880 880 0 0.00 0 154 5 0 0
v_cancel_client_order 3494 3494 0 0.00 0 3649 7 0 0
v_cancel_customer_prepayment 1310 1310 0 0.00 0 3941 9 0 0
v_cancel_customer_reserve 1382 1382 0 0.00 0 4141 12 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 1891 6 0 0
v_cancel_supplier_invoice 814 786 28 3.43 0 4063 22 0 28
v_cancel_supplier_order 806 806 0 0.00 0 624 4 0 0
v_cancel_write_off 2054 2054 0 0.00 0 3998 16 0 0
v_max_id_clo_ord 5223 5223 0 0.00 0 1013 1 0 0
v_max_id_clo_res 1025 1025 0 0.00 0 4219 17 0 0
v_max_id_ord_sup 5300 5300 0 0.00 0 5446 6 0 0
v_max_non_paid_invoice 1605 1605 0 0.00 0 3402 8 0 0
v_max_non_paid_realizn 3603 3603 0 0.00 0 1769 3 0 0
v_min_id_clo_ord 5223 5223 0 0.00 0 6260 5 0 0
v_min_id_clo_res 1025 1025 0 0.00 0 4644 20 0 0
v_min_id_ord_sup 5300 5300 0 0.00 0 5124 8 0 0
v_min_non_paid_invoice 5657 5657 0 0.00 0 23659 27 0 0
v_min_non_paid_realizn 6949 6949 0 0.00 0 3516 15 0 0
v_our_firm 10172 10172 0 0.00 0 17 1 0 0
v_reserve_write_off 19472 19472 0 0.00 0 7153 7 0 0
x_lock_depdocs_on_canc_invoice 11455 11455 0 0.00 0 8439 105 0 0
x_lock_depdocs_on_canc_sup_ord 403 403 0 0.00 0 6994 380 0 0
x_make_qstorno_1000_1200 5223 5223 0 0.00 1 47039 1235 0 0
x_make_qstorno_1200_2000 5312 5312 0 0.00 3 79453 3249 0 0
x_make_qstorno_2100_3300 443612 443612 0 0.00 0 119768 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-03-2021 22:28:59 to 27-03-2021 22:29:03.

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:26 7 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:32 7288 8192000000 10146238592 10443845632 821599008 9.115 67 49 102 0 840658000 2244320 16814672
19:57:48 16099 8192000000 10276889168 10585055232 1331694064 13.982 100 80 160 0 1361766000 3830960 26240976
19:58:16 27057 8192000000 10351663296 10667696128 1408567664 14.671 100 85 170 1 1441409392 5356432 27485296
19:58:51 32517 8192000000 10391758528 10714935296 1440329552 14.953 100 88 177 1 1476177696 6883504 28964640
19:59:32 18847 8192000000 10410772048 10736484352 1459896064 15.125 100 93 186 0 1498580000 8045120 30638816
20:00:12 25597 8192000000 10428189792 10758311936 1481823392 15.317 100 90 179 0 1520330128 9108304 29398432
20:00:50 14667 8192000000 10440248064 10774052864 1495622832 15.438 100 88 176 1 1533388176 9532368 28232976
20:01:32 11678 8192000000 10466954832 10806272000 1520566960 15.655 100 75 150 0 1557951232 13775040 23609232
20:01:52 15875 8192000000 10480643920 10826293248 1541281024 15.835 100 82 164 0 1577081600 9974912 25825664
20:02:19 10623 8192000000 10494406048 10845876224 1558742608 15.985 100 77 154 1 1591973536 9440976 23789952
20:02:40 9460 8192000000 10512124976 10867462144 1573445376 16.112 100 66 132 0 1603796096 9306704 21044016
20:02:59 12858 8192000000 10542054592 10898587648 1602654864 16.362 100 79 158 0 1637556224 10536336 24365024
20:03:24 6980 8192000000 10571135216 10929692672 1630078016 16.596 100 78 156 0 1665074736 11051632 23945088
20:03:40 15276 8192000000 10596996496 10960097280 1649572224 16.761 100 77 154 2 1684700016 12014000 23113792
20:04:03 6410 8192000000 10618347456 10979450880 1674529904 16.971 100 90 178 1 1713848432 12296720 27021808
20:04:19 6896 8192000000 10623242784 10992951296 1686956720 17.076 100 70 140 1 1718653952 11826928 19870304
20:04:34 8391 8192000000 10641675536 11011928064 1705053504 17.227 100 78 156 1 1739157312 12073056 22030752
20:04:49 7874 8192000000 10655472960 11028938752 1718019216 17.336 100 80 160 2 1753459712 12664096 22776400
20:05:06 5479 8192000000 10682803728 11053883392 1738498208 17.506 100 90 180 0 1776735056 12836208 25400640
20:05:19 6131 8192000000 10689928864 11063762944 1746081824 17.569 100 86 170 1 1784130592 14245392 23803376
20:05:32 5729 8192000000 10692652976 11068743680 1752195216 17.620 100 82 163 2 1789651984 13920352 23536416
20:05:45 4613 8192000000 10709366592 11086159872 1766157248 17.735 100 92 184 2 1806944320 14813200 25973872
20:05:57 3731 8192000000 10708774848 11088183296 1772078480 17.784 100 87 173 1 1809100464 13635840 23386144
20:06:08 3784 8192000000 10719454256 11096793088 1777051904 17.825 100 87 173 1 1815553680 14601936 23899840
20:06:18 3411 8192000000 10733687712 11108880384 1788359328 17.918 100 90 181 0 1827828816 14396944 25072544
20:06:29 1959 8192000000 10732741296 11111620608 1791027712 17.940 100 85 166 0 1827864464 12852256 23984496
20:06:38 3012 8192000000 10734183008 11116380160 1800008688 18.014 100 84 169 2 1836727776 13478512 23240576
20:06:47 3391 8192000000 10738594176 11121373184 1806490288 18.067 100 85 169 2 1842316368 13086016 22740064
20:06:58 8211 8192000000 10745212976 11131256832 1810912672 18.103 100 77 154 0 1845823024 13598416 21311936
20:07:14 4915 8192000000 10752939280 11138404352 1821237296 18.188 100 78 156 1 1856464960 14102704 21124960
20:07:25 2143 8192000000 10776606320 11160182784 1833714704 18.290 100 93 184 4 1874972464 14735696 26522064
20:07:34 3050 8192000000 10778658112 11167191040 1837250144 18.318 100 84 168 0 1875405568 13886960 24268464
20:07:43 2095 8192000000 10775578272 11166232576 1842090544 18.358 100 90 180 2 1880494224 13344048 25059632
20:07:51 2425 8192000000 10792504352 11178213376 1848866240 18.413 100 88 177 1 1886452960 12644016 24942704
20:08:00 2158 8192000000 10795083904 11180875776 1853492096 18.450 100 91 176 3 1891907472 12796160 25619216
20:08:08 1542 8192000000 10800039744 11184857088 1854958944 18.462 100 92 185 2 1892958224 12935904 25063376
20:08:17 1947 8192000000 10801462800 11189342208 1859978688 18.503 100 90 180 0 1898224608 13430448 24815472
20:08:27 2404 8192000000 10806945456 11195080704 1862269984 18.522 100 86 172 1 1899897312 12959456 24667872
20:08:35 1667 8192000000 10809256272 11196469248 1862980832 18.527 100 92 184 0 1902542992 13051344 26510816
20:08:44 2599 8192000000 10814126448 11201343488 1864518576 18.540 100 92 184 1 1902610544 12009296 26082672
20:08:52 27902 8192000000 10778502368 11191214080 1864913696 18.543 100 63 126 0 1893257072 10683184 17660192
20:09:27 2743 8192000000 10811774624 11204587520 1870679440 18.590 100 76 153 2 1902945968 9790576 22475952
20:09:37 4121 8192000000 10811085120 11206676480 1869123280 18.577 100 66 129 3 1897959296 10866752 17969264
20:09:48 3002 8192000000 10801136640 11206291456 1868875808 18.575 100 51 102 1 1894566432 10865408 14825216
20:09:58 3811 8192000000 10809034752 11218669568 1877328800 18.644 100 56 112 1 1903220048 10482992 15408256
20:10:10 3646 8192000000 10809404512 11216936960 1878263232 18.651 100 49 98 1 1902772352 11034016 13475104
20:10:21 3166 8192000000 10808073152 11224481792 1881167664 18.675 100 46 93 2 1907152992 13509168 12476160
20:10:31 2664 8192000000 10801936016 11219427328 1881970368 18.681 100 46 92 1 1903882304 9211152 12700784
20:10:40 5271 8192000000 10798302736 11219558400 1891808816 18.760 100 50 99 0 1914108976 7829872 14470288
20:10:53 11038 8192000000 10812259136 11222609920 1880725040 18.671 100 26 51 1 1894350224 5976912 7648272
20:11:12 52200 8192000000 10826121728 11232002048 1888829296 18.736 100 56 113 0 1911350752 5465872 17055584
20:12:11 1384 8192000000 10850776608 11250057216 1904675056 18.864 100 93 189 1 1941511552 9935024 26901472
20:12:18 4552 8192000000 10814169584 11238965248 1895266000 18.788 100 42 84 0 1917201424 10722400 11213024
20:12:31 7484 8192000000 10807131008 11237302272 1894514912 18.782 100 33 66 1 1911410496 7691520 9204064
20:12:49 5320 8192000000 10805142144 11235991552 1895657248 18.791 100 20 40 0 1905944816 5078208 5209360
20:13:02 8358 8192000000 10798245120 11235471360 1894851216 18.785 100 24 48 0 1907574080 5733408 6989456
20:13:18 4376 8192000000 10819514352 11244187648 1901473600 18.838 100 40 80 0 1920221984 7778160 10970224
20:13:30 4438 8192000000 10837835808 11258118144 1903345184 18.853 100 43 84 3 1927437168 12523120 11568864
20:13:45 4132 8192000000 10817788864 11246100480 1900947904 18.834 100 26 52 0 1915969568 7789744 7231920
20:13:55 6229 8192000000 10818319616 11245563904 1902015696 18.843 100 33 67 0 1918156416 5980096 10160624
20:14:09 13162 8192000000 10820622976 11247714304 1902649264 18.848 100 20 40 1 1915236768 6220384 6367120
20:14:32 7383 8192000000 10820597600 11248680960 1907163312 18.884 100 26 50 2 1920186336 5372112 7650912
20:14:49 16797 8192000000 10814853232 11249262592 1906971392 18.882 100 15 30 2 1917417088 5536736 4908960
20:15:14 11241 8192000000 10818583456 11254251520 1905836448 18.873 100 22 44 1 1918012912 6043296 6133168
20:15:31 63752 8192000000 10823120368 11263389696 1911686672 18.920 100 25 50 1 1924682352 5607584 7388096
20:16:44 10285 8192000000 10819624352 11253497856 1892563184 18.766 99 21 42 1 1904305648 5392688 6349776
20:17:00 6486 8192000000 10824270672 11256573952 1902853728 18.849 100 27 52 4 1916468528 6766928 6847872
20:17:14 8852 8192000000 10816151568 11236626432 1851807264 18.437 97 37 74 1 1869054816 7174848 10072704
20:17:31 5046 8192000000 10810679408 11232014336 1874325472 18.619 99 41 80 1 1891285472 5499648 11460352
20:17:43 5717 8192000000 10808783440 11229880320 1871967456 18.600 99 34 68 2 1887405344 5507424 9930464
20:17:55 5668 8192000000 10781496672 11216719872 1861690624 18.517 99 25 50 2 1874266880 5431696 7144560
20:18:09 5744 8192000000 10786559520 11211988992 1863823696 18.534 100 29 58 2 1877811488 5948336 8039456
20:18:24 9568 8192000000 10776296688 11207110656 1846098640 18.390 99 14 27 1 1856164784 5072352 4993792
20:18:41 10040 8192000000 10776600336 11200221184 1814637840 18.134 97 16 32 2 1824257584 5368368 4251376
20:18:58 10197 8192000000 10757268176 11187978240 1821733568 18.192 98 15 30 0 1831742288 5808544 4200176
20:19:14 5139 8192000000 10744646848 11163848704 1811224128 18.106 98 18 36 1 1822886912 6152992 5509792
20:19:25 9345 8192000000 10750248576 11179372544 1815652608 18.142 98 13 26 0 1825007376 5029344 4325424
20:19:41 11178 8192000000 10738845600 11163357184 1759601152 17.681 95 26 52 2 1773204784 5746672 7856960
20:20:01 12853 8192000000 10684572592 11072360448 1623283776 16.538 90 25 50 1 1635681232 5486672 6910784
20:20:23 62804 8192000000 10653509440 11070722048 1707433648 17.247 96 36 72 0 1722119504 4944576 9741280
20:21:33 14127 8192000000 10699151088 11106045952 1719352880 17.347 96 21 42 1 1731078864 6036224 5689760
20:21:56 7119 8192000000 10677848752 11094765568 1721562528 17.365 96 42 82 0 1740699264 7271744 11864992
20:22:12 6715 8192000000 10706922480 11121872896 1786944224 17.907 100 36 72 0 1804373712 7126784 10302704
20:22:26 6290 8192000000 10725742240 11137482752 1786729424 17.905 99 30 60 1 1802568432 7253760 8585248
20:22:40 5030 8192000000 10749468944 11158147072 1818987616 18.169 100 34 68 0 1834755696 5286480 10481600
20:22:51 8970 8192000000 10748358480 11159220224 1822958208 18.202 100 34 69 1 1838062880 5232080 9872592
20:23:07 8329 8192000000 10733080768 11148759040 1792734560 17.954 98 35 67 3 1809722800 7541040 9447200
20:23:27 8985 8192000000 10746709952 11169099776 1832253504 18.278 100 26 52 2 1845771808 5373968 8144336
20:23:43 7500 8192000000 10766030000 11179225088 1837798352 18.323 100 29 58 3 1851892512 5735280 8358880
20:23:58 14538 8192000000 10750257360 11178557440 1828743792 18.249 99 30 61 2 1847571984 10001456 8826736
20:24:19 14338 8192000000 10770201168 11191173120 1833345392 18.287 99 11 23 0 1841979168 5039680 3594096
20:24:44 7273 8192000000 10760440016 11187109888 1831135760 18.269 99 9 18 0 1838617728 5241120 2240848
20:25:01 21453 8192000000 10771017520 11201613824 1856740304 18.477 100 22 43 0 1869143904 5576416 6827184
20:25:30 47031 8192000000 10781810624 11195625472 1865893632 18.551 100 42 82 2 1883072160 4132592 13045936
20:26:26 13385 8192000000 10802934288 11205132288 1872123296 18.601 100 73 144 4 1900007824 6003152 21881376
20:26:46 5933 8192000000 10786276048 11209990144 1866279408 18.554 100 37 74 1 1885987264 9524576 10183280
20:27:02 10326 8192000000 10792020816 11220660224 1875069664 18.625 100 27 54 2 1888866144 5877024 7919456
20:27:18 8975 8192000000 10824606016 11235512320 1891328336 18.756 100 49 94 1 1911253792 6306448 13619008
20:27:37 10995 8192000000 10836541744 11248709632 1905013632 18.867 100 60 120 1 1930359616 8731728 16614256
20:28:07 7359 8192000000 10852955056 11262279680 1909733120 18.905 100 69 133 2 1937635856 9280160 18622576
20:28:21 7371 8192000000 10850247712 11269607424 1918050144 18.971 100 72 145 2 1950167312 11257744 20859424
20:28:42 28439 8192000000 10835851456 11266912256 1914760976 18.945 100 43 84 4 1935881872 8855840 12265056
20:29:19 14521 8192000000 10854181520 11281690624 1924383680 19.022 100 49 96 1 1950701904 12606384 13711840
20:29:51 9399 8192000000 10861323328 11289681920 1932608880 19.088 100 36 72 0 1952261744 8661616 10991248
20:30:09 14213 8192000000 10876301376 11302883328 1939192464 19.140 100 48 96 1 1962883792 9593936 14097392
20:30:46 13573 8192000000 10887980448 11314794496 1945109696 19.188 100 49 96 2 1973073056 14222784 13740576
20:31:07 23091 8192000000 10884153424 11319234560 1948591168 19.215 100 50 100 1 1977757712 14752896 14413648
20:31:38 16441 8192000000 10884650256 11323203584 1954662512 19.264 100 41 80 2 1979704208 12978304 12063392
20:32:02 13557 8192000000 10897602336 11330105344 1967157936 19.363 100 48 96 2 1993904656 12471120 14275600
20:32:51 15473 8192000000 10894429536 11338698752 1965754800 19.352 100 34 68 2 1994480000 18856560 9868640
20:33:28 5527 8192000000 10912958960 11345567744 1977089200 19.442 100 48 93 2 2004342400 14478400 12774800
20:33:44 7469 8192000000 10918828832 11350065152 1975827824 19.432 100 42 84 0 2003636768 15060256 12748688
20:33:59 10772 8192000000 10924369120 11358642176 1982996496 19.488 100 56 111 2 2015949760 16589600 16363664
20:34:19 5050 8192000000 10944697760 11367448576 1990519856 19.548 100 66 131 0 2027142672 17358576 19264240
20:34:33 3914 8192000000 10940154464 11368251392 1995635808 19.588 100 57 112 2 2029930464 17668240 16626416
20:34:47 5029 8192000000 10943019312 11375427584 1996991776 19.599 100 53 103 3 2030152400 18094480 15066144
20:35:01 19944 8192000000 10951724288 11384274944 2002858704 19.645 100 48 95 3 2034923088 18702960 13361424
20:35:28 4463 8192000000 10953232976 11387756544 2005789792 19.668 100 57 112 2 2043657568 20919824 16947952
20:35:42 6895 8192000000 10955439584 11389943808 2007815152 19.684 100 65 130 2 2049286592 22343664 19127776
20:35:56 6499 8192000000 10966118480 11391647744 2009739408 19.699 100 66 132 0 2051713376 23284912 18689056
20:36:09 9148 8192000000 10966895984 11396648960 2012208704 19.719 100 72 144 1 2057237552 24436784 20592064
20:36:34 9372 8192000000 10977363040 11403788288 2014204512 19.735 100 68 135 3 2061011472 26278720 20528240
20:36:53 8228 8192000000 10962840816 11396009984 1995791328 19.590 99 56 112 0 2039043184 26651936 16599920
20:37:09 9878 8192000000 10970442336 11404288000 2013027184 19.725 100 66 131 1 2059864544 27554752 19282608
20:37:29 3930 8192000000 10968519648 11403390976 2017799040 19.763 100 67 134 0 2061539552 24247936 19492576
20:37:42 8216 8192000000 10977556752 11409272832 2018803472 19.771 100 66 132 1 2061907248 23479520 19624256
20:38:03 2080 8192000000 10980659760 11409387520 2005700288 19.668 99 77 153 1 2056103136 28003520 22399328
20:38:13 3390 8192000000 10967480512 11400478720 1997429344 19.602 99 75 148 0 2044726816 25151984 22145488
20:38:23 5479 8192000000 10994149008 11410345984 2020519440 19.784 100 78 152 4 2071005264 26319120 24166704
20:38:35 2967 8192000000 10986552672 11410980864 2018667808 19.770 100 80 161 2 2070408496 26619552 25121136
20:38:45 3059 8192000000 10989220176 11406741504 2012682848 19.723 100 76 151 2 2064378304 29135952 22559504
20:38:55 2039 8192000000 10992484128 11415535616 2020678112 19.785 100 88 176 0 2078193360 30359072 27156176
20:39:04 3377 8192000000 10984683760 11409268736 2016523856 19.753 100 87 174 1 2072351984 29357392 26470736
20:39:14 7682 8192000000 10975916496 11402289152 1997010592 19.599 99 65 129 1 2044379840 28418592 18950656
20:39:30 2541 8192000000 10954352016 11382202368 1967585856 19.366 98 84 167 1 2022083264 29272800 25224608
20:39:40 1006 8192000000 10976743744 11399098368 2000876480 19.630 100 80 161 2 2056942832 32724576 23341776
20:39:51 6137 8192000000 10974680128 11393396736 1984185200 19.498 99 68 134 1 2033912848 30541424 19186224
20:40:08 6579 8192000000 10959923536 11390455808 1981167872 19.474 99 67 132 0 2031941024 31387856 19385296
20:40:27 7152 8192000000 10952591232 11391201280 1994249920 19.577 100 59 119 1 2042786816 30828912 17707984
20:40:43 7906 8192000000 10962133184 11397513216 1999067760 19.615 100 59 114 1 2047619120 31644544 16906816
20:40:59 5416 8192000000 10941193120 11370856448 1977472160 19.445 99 61 122 0 2025959824 30146128 18341536
20:41:13 3589 8192000000 10974256416 11399073792 1998523184 19.611 100 79 159 1 2052951904 29831344 24597376
20:41:25 9010 8192000000 10958707952 11378663424 1969487952 19.381 99 69 138 1 2023590384 33289056 20813376
20:41:41 4949 8192000000 10966140912 11382796288 1989091472 19.537 100 80 159 2 2047053120 34269520 23692128
20:41:54 5864 8192000000 10967003632 11386023936 1989826304 19.542 100 77 150 1 2048175264 34897344 23451616
20:42:08 3975 8192000000 10953995632 11373912064 1979886640 19.464 100 79 158 0 2040523168 36642912 23993616
20:42:26 5864 8192000000 10961123280 11391299584 1987634000 19.525 100 66 131 2 2045598688 37493712 20470976
20:42:40 5988 8192000000 10953988576 11376144384 1982755216 19.487 100 85 170 3 2045910112 37602976 25551920
20:42:59 11226 8192000000 10959439856 11394035712 1990857520 19.551 100 71 142 3 2052018704 39402368 21758816
20:43:33 4904 8192000000 10958672432 11386040320 1977279632 19.443 100 66 132 0 2040448448 42527808 20641008
20:43:47 2178 8192000000 10978239856 11397840896 1992579088 19.564 100 73 147 4 2056924496 41556352 22789056
20:43:59 12792 8192000000 10963194816 11391975424 1987165840 19.521 100 66 132 2 2048980576 40339264 21475472
20:44:21 4487 8192000000 10979868784 11407695872 1995925488 19.591 100 69 137 1 2059677776 42880224 20872064
20:44:32 3826 8192000000 10987067616 11408973824 1999395088 19.618 100 74 146 2 2066361056 43803984 23161984
20:44:43 3877 8192000000 10976065024 11401469952 1982485648 19.484 99 74 148 1 2051297248 45205840 23605760
20:44:55 4703 8192000000 10982211488 11406630912 1991157200 19.553 100 75 151 1 2060408560 45916736 23334624
20:45:11 5031 8192000000 10977414144 11400290304 1987541616 19.524 100 71 142 0 2056129792 46312944 22275232
20:45:23 4652 8192000000 10982175232 11407089664 1995956032 19.591 100 70 139 1 2063211840 45265808 21990000
20:45:35 4134 8192000000 10976730064 11393081344 1965785664 19.352 98 71 142 2 2035559760 46951872 22822224
20:45:48 1891 8192000000 10976415104 11393527808 1972488096 19.405 99 86 173 1 2047900768 48813056 26599616
20:45:57 3119 8192000000 10979030704 11400495104 1976994144 19.441 99 80 159 2 2051730640 48323440 26413056
20:46:07 3162 8192000000 10991462400 11402235904 1974526624 19.421 99 89 177 1 2052463824 50083648 27853552
20:46:17 3165 8192000000 10972531840 11394367488 1978194544 19.450 100 78 156 0 2056058624 52965088 24898992
20:46:27 2442 8192000000 10977545792 11401564160 1987117984 19.521 100 83 165 0 2066476496 53640560 25717952
20:46:37 4357 8192000000 10960050656 11391500288 1942448624 19.166 98 60 120 1 2016073920 53941104 19684192
20:46:53 3111 8192000000 10964714448 11398164480 1977014288 19.441 100 60 120 2 2049746384 51999600 20732496
20:47:17 5247 8192000000 10907231616 11336241152 1917531968 18.967 98 47 94 1 1972149472 39428576 15188928
20:47:32 3919 8192000000 10911355872 11348107264 1929774208 19.065 99 49 97 1 1986168064 40115552 16278304
20:47:43 12842 8192000000 10891033632 11328589824 1906240896 18.876 99 41 81 0 1964914320 44515680 14157744
20:48:05 5830 8192000000 10915965952 11340886016 1930848256 19.074 100 59 117 1 1991456000 41565216 19042528
20:48:19 1994 8192000000 10942361280 11355873280 1947548896 19.207 100 78 156 1 2016034496 43074720 25410880
20:48:28 3161 8192000000 10931857328 11355738112 1947321616 19.205 100 59 118 0 2008484528 42644352 18518560
20:48:47 13776 8192000000 10898511856 11341029376 1924398192 19.022 99 30 60 0 1972154736 36984784 10771760
20:49:09 18452 8192000000 10886319120 11334135808 1912774096 18.929 99 26 52 2 1959916496 37390288 9752112
20:49:38 10384 8192000000 10910796864 11352125440 1949669824 19.224 100 40 79 2 1994984896 33110208 12204864
20:50:18 12423 8192000000 10908001440 11349327872 1933527632 19.095 99 37 74 0 1981298464 35903504 11867328
20:50:39 11734 8192000000 10913801344 11355467776 1950351888 19.229 100 35 70 2 1997384240 35553696 11478656
20:51:02 14097 8192000000 10906294848 11348660224 1942005168 19.163 100 30 60 1 1988853632 36132816 10715648
20:51:23 14505 8192000000 10885281136 11324325888 1905762816 18.873 98 32 62 0 1958140496 41786064 10591616
20:51:47 29059 8192000000 10921961648 11366449152 1936823184 19.121 100 31 62 2 1999529056 51072944 11632928
20:52:24 20117 8192000000 10895672304 11345588224 1914136464 18.940 99 29 58 0 1972591552 47899040 10556048
20:52:51 15714 8192000000 10915551568 11355267072 1928792016 19.057 100 35 70 1 1989576320 49034640 11749664
20:53:13 37367 8192000000 10895216800 11355275264 1904311392 18.861 98 21 42 1 1948545104 36724224 7509488
20:53:57 51085 8192000000 10880029600 11344228352 1916075488 18.955 99 16 32 1 1960339568 38593472 5670608
20:54:54 19887 8192000000 10876756224 11342536704 1929481152 19.063 100 10 20 1 1948262496 15958560 2822784
20:55:21 18526 8192000000 10896738256 11321180160 1925980960 19.035 99 56 110 1 1954980928 13216272 15783696
20:55:46 76511 8192000000 10877403440 11317383168 1922029360 19.003 99 27 54 0 1937472704 7950064 7493280
20:57:19 84147 8192000000 10893881536 11347435520 1935360192 19.110 99 12 24 0 1944947888 6174592 3413104
20:58:56 184948 8192000000 10913927136 11361738752 1857648480 18.484 94 27 52 1 1878418848 12592432 8177936
21:02:17 81325 8192000000 10876688288 11342815232 1935432304 19.110 99 30 60 1 1966659280 21981296 9245680
21:03:45 80756 8192000000 10873554560 11353833472 1933137664 19.092 99 18 37 0 1957099696 18817344 5144688
21:05:13 112182 8192000000 10855464624 11324899328 1855761024 18.469 95 9 18 0 1875118544 17221296 2136224
21:07:12 35950 8192000000 10875977776 11332124672 1943449808 19.174 100 16 32 1 1960378848 11611808 5317232
21:08:24 49939 8192000000 10876152832 11356053504 1955362480 19.269 100 8 16 0 1971790544 13998048 2430016
21:09:21 24765 8192000000 10882284976 11356147712 1965981216 19.354 100 18 35 1 1987224112 15735888 5507008
21:10:20 91983 8192000000 10910243584 11368386560 1974228480 19.419 100 32 64 0 1999218944 15504336 9486128
21:12:17 64576 8192000000 10886646384 11370872832 1968352592 19.372 100 15 30 0 1987638672 14489392 4796688
21:13:29 24167 8192000000 10910377632 11358556160 1955912992 19.274 99 26 52 2 1974361152 11695264 6752896
21:14:04 66390 8192000000 10878024000 11354009600 1930464528 19.071 98 11 22 0 1947565920 14087792 3013600
21:15:19 75324 8192000000 10894391440 11374874624 1962660992 19.327 100 13 26 1 1984202960 17483376 4058592
21:16:41 50614 8192000000 10868785632 11341987840 1955576320 19.271 99 25 50 2 1975113856 12812272 6725264
21:17:39 63315 8192000000 10897483248 11378589696 1977115920 19.442 100 13 26 0 1989919568 9011664 3791984
21:18:50 63071 8192000000 10914392208 11379445760 1966479680 19.358 99 16 32 0 1984419232 13258848 4680704
21:20:03 75398 8192000000 10893433136 11370463232 1901919488 18.842 96 16 32 0 1922914928 16291376 4704064
21:21:25 52670 8192000000 10895582080 11372711936 1970897648 19.393 100 13 26 0 1992392496 17829392 3665456
21:22:25 49218 8192000000 10912649120 11381329920 1964794640 19.344 99 23 46 3 1986253184 14818688 6639856
21:23:27 70496 8192000000 10894559088 11378454528 1947575984 19.207 99 9 18 1 1975318048 25192480 2549584
21:24:44 100784 8192000000 10898304608 11363041280 1879761520 18.663 95 21 42 3 1898553792 12951872 5840400
21:26:56 72837 8192000000 10885788912 11355541504 1875625264 18.630 95 14 27 1 1898954064 19828768 3500032
21:28:15 79713 8192000000 10880529392 11360333824 1900180688 18.828 97 5 10 1 1925922544 24562208 1179648
21:29:41 96579 8192000000 10882432528 11352043520 1842831088 18.364 94 15 29 1 1860946544 14507136 3608320
21:32:05 102781 8192000000 10867199120 11351257088 1874912640 18.624 96 17 34 1 1903142976 23563904 4666432
21:33:54 19910 8192000000 10852255616 11337834496 1915862208 18.954 99 10 20 0 1935561200 16687168 3011824
21:34:33 40963 8192000000 10876992976 11349237760 1947872576 19.210 100 26 52 1 1963950112 8704368 7373168
21:36:54 44052 8192000000 10865492464 11344179200 1918813184 18.977 98 11 22 0 1933079888 11060448 3206256
21:37:46 45298 8192000000 10830378992 11298099200 1829766752 18.257 94 11 22 1 1846276704 13451664 3058288
21:39:21 46977 8192000000 10808324992 11280130048 1865281728 18.546 97 10 20 0 1874482784 6435536 2765520
21:40:17 31773 8192000000 10840397968 11303903232 1898197392 18.812 98 23 46 0 1918879616 14402224 6280000
21:41:00 21033 8192000000 10853843360 11313987584 1933077776 19.091 100 38 76 0 1952675008 8930704 10666528
21:41:40 81643 8192000000 10839620176 11319537664 1876676880 18.638 97 20 40 1 1892366032 10271744 5417408
21:43:56 61381 8192000000 10835593568 11309924352 1868614480 18.573 97 6 12 0 1879238960 8799920 1824560
21:45:05 51108 8192000000 10850935312 11327561728 1886508640 18.718 98 8 16 0 1899237504 10704912 2023952
21:46:02 31208 8192000000 10871538544 11332050944 1920245248 18.989 99 29 58 4 1938338864 10043088 8050528
21:46:40 72462 8192000000 10869128000 11344945152 1929178432 19.060 99 21 42 0 1956137200 20547568 6411200
21:47:59 36458 8192000000 10871553168 11340480512 1928974032 19.059 99 24 48 1 1953279104 17923856 6381216
21:48:46 49158 8192000000 10864868832 11322998784 1860903920 18.511 96 29 58 0 1881467104 12315856 8247328
21:50:03 52714 8192000000 10857100384 11320446976 1909203456 18.900 99 32 64 0 1935145264 16612208 9329600
21:51:07 40908 8192000000 10880783792 11345846272 1936840304 19.122 100 30 60 1 1960140016 15182432 8117280
21:51:55 16342 8192000000 10863027248 11306815488 1890864320 18.753 97 44 88 0 1916555232 14113456 11577456
21:52:20 12091 8192000000 10886738112 11330031616 1924834832 19.026 99 54 106 0 1950654896 11419600 14400464
21:52:40 40829 8192000000 10882622976 11338903552 1941178960 19.156 100 45 90 0 1967778176 13687168 12912048
21:53:32 99308 8192000000 10866610304 11338866688 1922409104 19.006 99 27 54 0 1942140240 12847568 6883568
21:55:29 50882 8192000000 10877692608 11321704448 1900827440 18.833 98 26 50 2 1918292768 10426288 7039040
21:56:28 77206 8192000000 10860280688 11329118208 1842757696 18.363 95 26 52 2 1866561008 16932080 6871232
21:57:57 122611 8192000000 10885119712 11333984256 1924814480 19.025 99 29 56 1 1942577728 10226512 7536736
22:00:06 55965 8192000000 10881134496 11350364160 1954801168 19.265 100 29 58 0 1971905584 8845136 8259280
22:01:35 44413 8192000000 10882942576 11359588352 1964095968 19.339 100 7 14 1 1974855024 9046144 1712912
22:02:26 20861 8192000000 10884976864 11361419264 1963175664 19.331 100 6 12 1 1976067888 11327184 1565040
22:02:53 71647 8192000000 10891739248 11370516480 1925651280 19.032 98 14 28 1 1939314288 9994704 3668304
22:04:23 64498 8192000000 10909034128 11388370944 1963468336 19.334 99 13 26 1 1983200672 16270736 3461600
22:05:37 63124 8192000000 10898568288 11373174784 1952001712 19.242 99 9 18 0 1967026480 12432400 2592368
22:06:46 63042 8192000000 10937363040 11393863680 1972444592 19.405 99 43 88 1 2001284992 16692432 12147968
22:08:00 65631 8192000000 10924543056 11407024128 1991029984 19.552 100 21 42 2 2018281152 21190480 6060688
22:09:12 90393 8192000000 10915331536 11379896320 1926948032 19.042 97 26 53 2 1948332208 13870384 7513792
22:11:03 95408 8192000000 10915009136 11371134976 1891038864 18.754 95 23 45 0 1911496528 13941184 6516480
22:12:45 51648 8192000000 10915490256 11375079424 1958817504 19.297 99 35 70 0 1987693584 19069648 9806432
22:13:47 182245 8192000000 10879745104 11349401600 1823588064 18.207 93 5 10 1 1843782224 18649728 1544432
22:17:07 153055 8192000000 10890554544 11354296320 1906658784 18.880 97 18 36 0 1921044336 9564416 4821136
22:19:48 9489 8192000000 10881982240 11354300416 1962343408 19.325 100 17 34 0 1975112688 8291040 4478240
22:20:25 73480 8192000000 10860804384 11349504000 1904827376 18.865 97 12 24 0 1917688016 9897232 2963408
22:21:44 28471 8192000000 10867329840 11355516928 1950243504 19.228 100 4 8 0 1961984384 10673648 1067232
22:22:23 5884 8192000000 10864693296 11358687232 1950873680 19.233 100 3 6 0 1961706576 10158400 674496
22:22:35 859 8192000000 10867725696 11360710656 1952580688 19.247 100 2 4 0 1963154464 10154016 419760
22:22:42 68299 8192000000 10864842192 11345154048 1885061232 18.706 96 17 34 3 1898016528 8408384 4546912
22:24:09 63684 8192000000 10851914560 11341377536 1910833104 18.913 98 4 8 0 1922997392 10851216 1313072
22:25:23 78336 8192000000 10861357296 11333431296 1873715648 18.614 96 13 26 1 1885702672 8100064 3886960
22:27:07 26075 8192000000 9056329792 9278689280 226118848 2.686 12 3 6 0 232576432 5843840 613744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 27-03-2021 22:29:05 to 27-03-2021 22:29:36.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-03-2021 22:29:37 to 27-03-2021 22:29:39.

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          233159
MON$OLDEST_ACTIVE               233160
MON$OLDEST_SNAPSHOT             233160
MON$NEXT_TRANSACTION            233160
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                       2012800
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 ---
:28: 
:29: mscs-test-161.budzdorov.ru    Sat Mar 27 22:27:35 2021
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
:32: 
:33: mscs-test-161.budzdorov.ru    Sat Mar 27 22:27:36 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
:36: 
:37: mscs-test-161.budzdorov.ru    Sat Mar 27 22:27:39 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
--- end of diff output ---

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

27.03.21 22:29:40. 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-27 22:29:42 No severe PSQL-related problems occured
27.03.21 22:29:43. End of report.