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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 17259104 kB
MemAvailable 31349552 kB
Buffers 0 kB
Cached 14464388 kB
SwapCached 4864 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-01-20 01:27:15
DTS_END                         2021-01-20 01:27:15.5570
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/48356
TRN_ID                          237542
ATT_ID                          605
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: 9124.50 21005 1094940
customer order: creation 167.76 387 20131
customer order: refuse 14.12 390 1694
order to supplier: creation 43.92 1262 5270
order to supplier: removal 3.53 104205 424
invoice (draft): creation 43.61 3532 5233
invoice (draft): removal 52.32 724 6278
invoice accept: apply 40.00 18258 4800
invoice accept: cancel 47.85 779 5742
customer reserve: creation 3746.24 178 449549
customer reserve: removal 4671.87 63 560624
realization accept: apply 80.47 191 9657
realization accept: cancel 88.02 114 10562
payment from customer: creation 56.39 127 6767
payment from customer: removal 5.27 99 632
payment to supplier: creation 47.65 150 5718
payment to supplier: removal 3.31 95 397
service: total inventory turnovers 4.76 1049 571
service: total monetary turnovers 6.46 30 775
service: aggregate perf. data 0.93 13675 112
service: refresh index statistics 0.03 274793 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-01-2021 01:29:01 to 20-01-2021 01:29:03.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5269
TEST_TIME 2 3910
TEST_TIME 3 4712
TEST_TIME 4 4986
TEST_TIME 5 5405
TEST_TIME 6 5538
TEST_TIME 7 5870
TEST_TIME 8 5742
TEST_TIME 9 5808
TEST_TIME 10 5895
TEST_TIME 11 6025
TEST_TIME 12 6298
TEST_TIME 13 6454
TEST_TIME 14 6670
TEST_TIME 15 7086
TEST_TIME 16 7399
TEST_TIME 17 7858
TEST_TIME 18 8143
TEST_TIME 19 8234
TEST_TIME 20 8375
TEST_TIME 21 8440
TEST_TIME 22 8530
TEST_TIME 23 8696
TEST_TIME 24 8804
TEST_TIME 25 9007
TEST_TIME 26 9093
TEST_TIME 27 9515
TEST_TIME 28 10716
TEST_TIME 29 11004
TEST_TIME 30 10888
TEST_TIME 31 10883
TEST_TIME 32 10691
TEST_TIME 33 10760
TEST_TIME 34 10464
TEST_TIME 35 10471
TEST_TIME 36 10332
TEST_TIME 37 10354
TEST_TIME 38 10279
TEST_TIME 39 10170
TEST_TIME 40 10054
TEST_TIME 41 9910
TEST_TIME 42 9837
TEST_TIME 43 9877
TEST_TIME 44 9704
TEST_TIME 45 9706
TEST_TIME 46 9702
TEST_TIME 47 9641
TEST_TIME 48 9562
TEST_TIME 49 9519
TEST_TIME 50 9351
TEST_TIME 51 9518
TEST_TIME 52 9410
TEST_TIME 53 9467
TEST_TIME 54 9564
TEST_TIME 55 9480
TEST_TIME 56 9606
TEST_TIME 57 9591
TEST_TIME 58 9599
TEST_TIME 59 9699
TEST_TIME 60 9642
TEST_TIME 61 9657
TEST_TIME 62 9701
TEST_TIME 63 9772
TEST_TIME 64 9754
TEST_TIME 65 9878
TEST_TIME 66 9870
TEST_TIME 67 9764
TEST_TIME 68 9690
TEST_TIME 69 9585
TEST_TIME 70 9554
TEST_TIME 71 9597
TEST_TIME 72 9559
TEST_TIME 73 9531
TEST_TIME 74 9478
TEST_TIME 75 9410
TEST_TIME 76 9373
TEST_TIME 77 9303
TEST_TIME 78 9314
TEST_TIME 79 9416
TEST_TIME 80 9407
TEST_TIME 81 9396
TEST_TIME 82 9432
TEST_TIME 83 9419
TEST_TIME 84 9418
TEST_TIME 85 9356
TEST_TIME 86 9419
TEST_TIME 87 9526
TEST_TIME 88 9512
TEST_TIME 89 9545
TEST_TIME 90 9536
TEST_TIME 91 9527
TEST_TIME 92 9452
TEST_TIME 93 9412
TEST_TIME 94 9386
TEST_TIME 95 9387
TEST_TIME 96 9350
TEST_TIME 97 9328
TEST_TIME 98 9271
TEST_TIME 99 9228
TEST_TIME 100 9256
TEST_TIME 101 9232
TEST_TIME 102 9209
TEST_TIME 103 9207
TEST_TIME 104 9246
TEST_TIME 105 9414
TEST_TIME 106 9374
TEST_TIME 107 9369
TEST_TIME 108 9327
TEST_TIME 109 9391
TEST_TIME 110 9357
TEST_TIME 111 9369
TEST_TIME 112 9381
TEST_TIME 113 9321
TEST_TIME 114 9280
TEST_TIME 115 9248
TEST_TIME 116 9232
TEST_TIME 117 9202
TEST_TIME 118 9181
TEST_TIME 119 9203
TEST_TIME 120 9127

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-01-2021 01:29:05 to 20-01-2021 01:29:08.

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 1510613 1510613 0 0.00 0 15935 6 0 0
doc_list_biud 1510612 1510612 0 0.00 0 55404 29 0 0
sp_add_invoice_to_stock 4951 4800 151 3.04 25 160641 18259 0 151
sp_cancel_adding_invoice 5742 5742 0 0.00 4 73841 779 0 0
sp_cancel_client_order 1694 1694 0 0.00 4 25664 390 0 0
sp_cancel_customer_reserve 560624 560624 0 0.00 1 55406 64 0 0
sp_cancel_pay_from_customer 632 632 0 0.00 3 7206 100 0 0
sp_cancel_pay_to_supplier 397 397 0 0.00 3 5562 96 0 0
sp_cancel_supplier_invoice 6291 6278 13 0.20 2 28774 725 0 13
sp_cancel_supplier_order 424 424 0 0.00 6 1116726 104205 0 0
sp_cancel_write_off 10562 10562 0 0.00 1 10368 114 0 0
sp_client_order 20131 20131 0 0.00 3 26680 387 0 0
sp_customer_reserve 449549 449549 0 0.00 0 69429 178 0 0
sp_fill_shopping_cart 30631 30631 0 0.00 1 18723 45 0 0
sp_fill_shopping_cart_clo_res 449546 449546 0 0.00 0 12555 14 0 0
sp_get_clo_for_invoice 4796 4796 0 0.00 0 28502 343 0 0
sp_kill_cost_storno 17333 17333 0 0.00 0 6771 58 0 0
sp_kill_qstorno_ret_qs2qd 1138512 1138512 0 0.00 0 55402 34 0 0
sp_kill_qty_storno 599777 599777 0 0.00 0 55404 72 0 0
sp_lock_selected_doc 20049 20049 0 0.00 0 6997 6 0 0
sp_make_cost_storno 26938 26938 0 0.00 0 15933 60 0 0
sp_multiply_rows_for_pdistr 26938 26938 0 0.00 0 8242 29 0 0
sp_multiply_rows_for_qdistr 20131 20131 0 0.00 0 24537 185 0 0
sp_pay_from_customer 6767 6767 0 0.00 4 15478 127 0 0
sp_pay_to_supplier 5718 5718 0 0.00 5 15941 150 0 0
sp_payment_common 12485 12485 0 0.00 1 10482 33 0 0
sp_qd_handle_on_cancel_clo 1694 1694 0 0.00 0 25658 354 0 0
sp_qd_handle_on_invoice_upd_sts 10538 10538 0 0.00 0 27079 312 0 0
sp_qd_handle_on_reserve_upd_sts 9657 9657 0 0.00 0 16384 62 0 0
sp_reserve_write_off 9657 9657 0 0.00 6 16437 191 0 0
sp_supplier_invoice 5233 5233 0 0.00 6 80870 3532 0 0
sp_supplier_order 5270 5270 0 0.00 4 70135 1263 0 0
srv_aggregate_perf_data 112 112 0 0.00 2604 95467 13675 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1111 155769 32220 0 0
srv_find_qd_qs_mism 1048440 1048440 0 0.00 0 14210 5 0 0
srv_make_invnt_saldo 571 571 0 0.00 27 61678 1050 0 0
srv_make_money_saldo 775 775 0 0.00 1 1606 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 229964 319023 274794 0 0
t$perf-abend:sp_add_invoice_to_stock 151 151 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4800 4800 0 0.00 0 16030 181 0 0
t$perf-norm:sp_cancel_adding_invoice 402 402 0 0.00 1 4650 72 0 0
t$perf-norm:sp_cancel_client_order 1694 1694 0 0.00 0 2617 10 0 0
t$perf-norm:sp_cancel_customer_reserve 678 678 0 0.00 0 6108 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 632 632 0 0.00 0 2850 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 397 397 0 0.00 0 97 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 384 384 0 0.00 0 1524 21 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 24228 1584 0 0
t$perf-norm:sp_cancel_write_off 985 985 0 0.00 0 2056 7 0 0
t$perf-norm:sp_client_order 20131 20131 0 0.00 0 21317 18 0 0
t$perf-norm:sp_customer_reserve 932 932 0 0.00 0 1625 6 0 0
t$perf-norm:sp_pay_from_customer 6767 6767 0 0.00 0 4578 5 0 0
t$perf-norm:sp_pay_to_supplier 5718 5718 0 0.00 0 18866 14 0 0
t$perf-norm:sp_reserve_write_off 9657 9657 0 0.00 0 6043 9 0 0
t$perf-norm:sp_supplier_invoice 5233 5233 0 0.00 0 7702 17 0 0
t$perf-norm:sp_supplier_order 5270 5270 0 0.00 0 4748 14 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 1630 29 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 58 1 0 0
t$perf-norm:srv_make_invnt_saldo 571 571 0 0.00 0 1308 24 0 0
t$perf-norm:srv_make_money_saldo 775 775 0 0.00 0 4362 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 9894 9592 302 3.05 0 6245 21 0 302
v_all_customers 36636 36636 0 0.00 0 24 1 0 0
v_all_suppliers 29248 29248 0 0.00 0 18 1 0 0
v_all_wares 40262 40262 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 804 804 0 0.00 0 271 6 0 0
v_cancel_client_order 3388 3388 0 0.00 0 5362 10 0 0
v_cancel_customer_prepayment 1264 1264 0 0.00 0 2554 10 0 0
v_cancel_customer_reserve 1356 1356 0 0.00 0 6381 19 0 0
v_cancel_payment_to_supplier 794 794 0 0.00 0 2815 7 0 0
v_cancel_supplier_invoice 794 768 26 3.27 0 2138 20 0 26
v_cancel_supplier_order 848 848 0 0.00 0 2170 7 0 0
v_cancel_write_off 1970 1970 0 0.00 0 3764 17 0 0
v_max_id_clo_ord 5269 5269 0 0.00 0 763 1 0 0
v_max_id_clo_res 932 932 0 0.00 0 3618 16 0 0
v_max_id_ord_sup 5230 5230 0 0.00 0 8174 6 0 0
v_max_non_paid_invoice 1593 1593 0 0.00 0 2370 5 0 0
v_max_non_paid_realizn 3452 3452 0 0.00 0 2239 3 0 0
v_min_id_clo_ord 5269 5269 0 0.00 0 9134 14 0 0
v_min_id_clo_res 932 932 0 0.00 0 7615 20 0 0
v_min_id_ord_sup 5230 5230 0 0.00 0 8406 10 0 0
v_min_non_paid_invoice 5718 5718 0 0.00 0 6754 24 0 0
v_min_non_paid_realizn 6767 6767 0 0.00 0 6775 18 0 0
v_our_firm 10256 10256 0 0.00 0 16 1 0 0
v_reserve_write_off 19314 19314 0 0.00 0 6541 6 0 0
x_lock_depdocs_on_canc_invoice 11636 11636 0 0.00 0 15756 128 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 10997 346 0 0
x_make_qstorno_1000_1200 5270 5270 0 0.00 1 70129 1181 0 0
x_make_qstorno_1200_2000 5233 5233 0 0.00 3 80840 3360 0 0
x_make_qstorno_2100_3300 449549 449549 0 0.00 0 69428 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-01-2021 01:29:09 to 20-01-2021 01:29:13.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:19 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:25 12751 8192000000 10227437744 10536009728 927573536 10.171 73 49 98 0 945813488 2664032 15575920
22:57:45 22598 8192000000 10334599104 10652602368 1387868192 14.487 100 81 162 0 1418692928 4600272 26224464
22:58:20 29101 8192000000 10391797392 10713853952 1436233616 14.916 100 89 178 0 1472301760 6496576 29571568
22:58:58 18697 8192000000 10409124512 10736664576 1467793392 15.194 100 86 172 0 1503013696 7581856 27638448
22:59:27 18911 8192000000 10430185056 10759680000 1491599632 15.403 100 95 191 0 1530571616 8498256 30473728
22:59:56 19329 8192000000 10436840144 10772414464 1496014000 15.441 100 89 178 0 1534237152 9123824 29099328
23:00:25 22591 8192000000 10460448352 10796183552 1507726208 15.544 100 82 164 0 1543247936 9304816 26216912
23:00:58 17811 8192000000 10475200000 10816745472 1528587408 15.725 100 85 170 0 1565063776 9849904 26626464
23:01:23 25133 8192000000 10507506544 10853900288 1552278432 15.930 100 87 174 1 1589893056 10021520 27593104
23:02:00 19491 8192000000 10526903072 10880192512 1586953648 16.228 100 81 162 0 1622446560 10487408 25005504
23:02:34 15773 8192000000 10565209088 10922811392 1626369744 16.564 100 83 166 0 1662644992 11583344 24691904
23:02:58 13853 8192000000 10585739536 10948878336 1647056464 16.739 100 86 172 0 1684906656 12589760 25260432
23:03:20 12934 8192000000 10604260272 10967117824 1662317552 16.868 100 87 173 3 1700615808 13133328 25164928
23:03:43 12735 8192000000 10623802960 10989821952 1675990064 16.984 100 83 166 2 1713720880 13252640 24478176
23:04:04 8725 8192000000 10636285344 11009089536 1695435488 17.147 100 76 151 3 1729726432 12175216 22115728
23:04:21 8167 8192000000 10649484528 11022888960 1712698208 17.291 100 77 154 2 1746378848 11744944 21935696
23:04:37 10662 8192000000 10664160032 11038085120 1724337488 17.388 100 84 168 0 1761794368 13183840 24273040
23:04:55 6599 8192000000 10668067168 11048841216 1733725184 17.466 100 70 140 0 1765824208 11590768 20508256
23:05:10 5932 8192000000 10688700704 11067547648 1756860512 17.658 100 87 174 0 1794638400 12588064 25189824
23:05:22 6904 8192000000 10706997248 11084443648 1770428752 17.771 100 83 166 1 1805965776 12068496 23468528
23:05:37 3494 8192000000 10698892640 11077611520 1768545024 17.755 100 84 168 4 1805665024 13486400 23633600
23:05:47 4327 8192000000 10716580624 11094237184 1779423392 17.845 100 86 172 1 1817576960 14433920 23719648
23:05:59 3017 8192000000 10726127008 11104464896 1783415984 17.878 100 81 162 2 1819452672 13663856 22372832
23:06:10 3622 8192000000 10721493968 11103436800 1786328816 17.902 100 86 173 2 1825078384 14556752 24192816
23:06:20 3759 8192000000 10733994560 11116040192 1796602080 17.986 100 82 165 3 1833121248 13226288 23292880
23:06:30 3755 8192000000 10744164240 11125411840 1805666448 18.060 100 91 182 4 1844229456 13325952 25237056
23:06:41 2755 8192000000 10746239456 11128954880 1810468624 18.100 100 87 175 0 1848780560 13655824 24656112
23:06:50 1678 8192000000 10752417728 11135791104 1816021120 18.145 100 89 174 3 1854595424 14733216 23841088
23:06:59 5865 8192000000 10760195072 11146854400 1815668576 18.142 100 78 156 0 1852202144 14962784 21570784
23:07:12 3740 8192000000 10776328176 11161350144 1821461696 18.190 100 79 157 1 1858498848 14601776 22435376
23:07:22 1666 8192000000 10783096080 11164266496 1839356352 18.336 100 92 185 1 1879050224 13981280 25712592
23:07:30 1448 8192000000 10782097088 11170086912 1842518704 18.361 100 91 182 1 1882185456 13362992 26303760
23:07:39 1831 8192000000 10791899984 11177631744 1846000752 18.390 100 94 188 3 1887228752 14522432 26705568
23:07:47 1096 8192000000 10787452240 11170885632 1849834352 18.421 100 95 193 1 1888853280 12178320 26840608
23:07:54 1270 8192000000 10792013632 11176644608 1847257264 18.400 100 88 177 1 1885039424 12988416 24793744
23:08:02 1228 8192000000 10796413872 11181731840 1852156944 18.440 100 92 184 4 1891250848 12153952 26939952
23:08:09 1430 8192000000 10806933888 11191865344 1857792992 18.485 100 98 195 0 1902898208 17383488 27721728
23:08:17 1476 8192000000 10803737136 11193982976 1861219856 18.513 100 93 186 2 1901108064 13383712 26504496
23:08:26 2216 8192000000 10788254704 11190325248 1858574192 18.492 100 70 141 1 1891079776 12971360 19534224
23:08:36 1841 8192000000 10790937904 11191676928 1861962768 18.519 100 62 123 1 1889563440 10675920 16924752
23:08:45 1701 8192000000 10776331648 11189227520 1858124608 18.488 100 51 101 0 1881965792 9959056 13882128
23:08:54 3920 8192000000 10771001248 11190427648 1859351680 18.498 100 41 83 1 1879879808 8251680 12276448
23:09:05 10532 8192000000 10780866128 11190943744 1864659584 18.541 100 39 79 1 1881402544 5738688 11004272
23:09:23 54620 8192000000 10821098496 11215679488 1871593584 18.597 100 58 114 1 1893748320 5390656 16764080
23:10:23 1282 8192000000 10832157328 11229589504 1889487600 18.742 100 95 193 1 1926081456 9639824 26954032
23:10:31 3151 8192000000 10806301200 11224563712 1880236864 18.667 100 48 97 0 1903799344 10778512 12783968
23:10:41 5895 8192000000 10783971568 11215429632 1877438960 18.644 100 27 54 3 1892715600 7862880 7413760
23:10:57 3067 8192000000 10805984976 11225092096 1883050080 18.690 100 44 86 3 1902074352 7087840 11936432
23:11:06 5057 8192000000 10805879680 11227832320 1883657744 18.695 100 35 70 1 1901884560 7962128 10264688
23:11:17 5623 8192000000 10792774144 11222740992 1882376480 18.684 100 42 84 6 1906370208 12122592 11871136
23:11:29 4345 8192000000 10791607504 11222695936 1883663504 18.695 100 39 78 3 1902297632 7449728 11184400
23:11:40 8984 8192000000 10797156432 11226005504 1884872496 18.704 100 30 60 0 1898829056 5533456 8423104
23:11:57 6909 8192000000 10802244400 11229614080 1886786384 18.720 100 38 76 1 1904982944 7669040 10527520
23:12:12 5886 8192000000 10798469664 11229184000 1886531600 18.718 100 22 42 2 1899054176 6311136 6211440
23:12:25 5492 8192000000 10793976848 11230969856 1888708496 18.735 100 30 59 2 1904047392 6200304 9138592
23:12:38 4714 8192000000 10809008512 11237986304 1890734208 18.752 100 33 66 0 1912164592 12147520 9282864
23:12:49 8061 8192000000 10801994416 11235708928 1889883632 18.745 100 29 58 1 1908997920 10835984 8278304
23:13:03 8435 8192000000 10804902960 11235463168 1888153616 18.731 100 21 39 1 1899324416 5203040 5967760
23:13:19 60694 8192000000 10806308112 11228422144 1875670528 18.630 99 31 64 0 1890166752 4942064 9554160
23:14:26 7832 8192000000 10812649696 11239673856 1892866528 18.769 100 32 62 1 1909559520 8123968 8569024
23:14:40 5862 8192000000 10814743760 11247681536 1900391872 18.829 100 30 60 2 1916055184 7102688 8560624
23:14:54 6202 8192000000 10819307408 11243278336 1898309968 18.813 100 32 62 2 1913961584 6697952 8953664
23:15:08 4896 8192000000 10823213552 11248693248 1901924576 18.842 100 37 74 0 1920317904 7531072 10862256
23:15:19 6706 8192000000 10831215184 11254849536 1906289232 18.877 100 47 95 1 1927271552 6860304 14122016
23:15:33 13364 8192000000 10825589440 11255767040 1904722640 18.864 100 18 36 1 1915404480 5647152 5034688
23:15:53 7739 8192000000 10818940000 11254329344 1906951376 18.882 100 21 40 2 1918980880 6106064 5923440
23:16:09 5858 8192000000 10812668880 11246862336 1885938240 18.713 99 33 66 0 1903059680 7707616 9413824
23:16:21 7382 8192000000 10807258736 11236036608 1860481152 18.507 98 28 56 1 1873592560 4709408 8402000
23:16:36 10581 8192000000 10798121536 11237982208 1873830304 18.615 99 18 36 0 1884762976 5507568 5425104
23:16:54 6570 8192000000 10785986464 11213152256 1847597312 18.403 98 20 40 1 1858430336 4898816 5934208
23:17:07 10355 8192000000 10770997712 11199778816 1820046016 18.178 97 23 46 2 1831986352 5162912 6777424
23:17:25 19743 8192000000 10756795232 11174572032 1721252000 17.363 92 15 30 0 1731125440 5072432 4801008
23:17:54 53884 8192000000 10750011440 11149189120 1749257648 17.595 94 37 70 4 1765422944 4544480 11620816
23:18:54 6742 8192000000 10731831216 11160920064 1796691728 17.987 98 22 44 1 1809529360 7107408 5730224
23:19:15 7372 8192000000 10698027184 11114692608 1717782032 17.334 94 27 54 0 1730942736 5242352 7918352
23:19:30 4263 8192000000 10714490672 11130585088 1802279680 18.033 100 46 90 0 1822547984 7326464 12941840
23:19:42 5396 8192000000 10687862816 11101749248 1738939888 17.510 97 24 48 3 1751794912 6116608 6738416
23:19:54 6915 8192000000 10687511296 11100024832 1756370992 17.654 98 29 58 3 1770868704 6256432 8241280
23:20:09 9009 8192000000 10672317040 11089932288 1733344000 17.463 97 16 32 1 1743364000 5022144 4997856
23:20:28 10104 8192000000 10694628640 11119788032 1749206432 17.595 97 22 44 0 1761794224 5840960 6746832
23:20:47 9856 8192000000 10716062560 11132067840 1781401152 17.861 99 23 46 1 1797845856 9895088 6549616
23:21:03 8667 8192000000 10704481168 11123896320 1766143120 17.735 98 23 46 1 1778166512 5033808 6989584
23:21:18 10177 8192000000 10702773520 11119706112 1748956224 17.593 97 22 45 1 1765059776 9632240 6471312
23:21:34 7668 8192000000 10741751280 11151220736 1775698832 17.814 98 23 46 1 1787689232 5349120 6641280
23:21:51 11003 8192000000 10736866848 11163955200 1824367008 18.213 100 25 50 2 1838291808 6890112 7034688
23:22:09 8436 8192000000 10733636896 11153825792 1815165216 18.138 99 17 33 2 1824747536 4424656 5157664
23:22:26 15964 8192000000 10748555776 11166846976 1815200736 18.138 99 17 34 1 1826043360 6339792 4502832
23:22:49 73245 8192000000 10751301248 11183747072 1837816608 18.323 100 29 58 0 1852473584 5413472 9243504
23:24:11 9113 8192000000 10768135680 11193221120 1851278832 18.433 100 27 54 3 1864988784 5833392 7876560
23:24:26 8771 8192000000 10772366064 11195244544 1855414576 18.466 100 29 56 2 1873962976 10589584 7958816
23:24:42 7180 8192000000 10763051152 11193647104 1855032240 18.463 100 31 62 2 1871054992 7064784 8957968
23:24:55 5218 8192000000 10769104992 11198865408 1858234592 18.489 100 27 54 3 1871882096 6006576 7640928
23:25:07 11705 8192000000 10774915760 11202379776 1860529952 18.508 100 17 34 1 1871213888 5923136 4760800
23:25:26 5939 8192000000 10778170848 11209527296 1865584512 18.549 100 27 54 1 1880127280 6280864 8261904
23:25:42 11666 8192000000 10778472432 11213156352 1870146640 18.585 100 19 38 0 1880689984 5218288 5325056
23:26:00 7476 8192000000 10781849104 11216650240 1874785632 18.623 100 19 38 3 1885709152 5919424 5004096
23:26:14 9174 8192000000 10791819376 11222274048 1875657728 18.630 100 25 50 0 1888781664 5551136 7572800
23:26:31 11577 8192000000 10793452736 11223330816 1879204992 18.659 100 30 60 0 1894464352 5465040 9794320
23:26:54 13949 8192000000 10798855408 11231424512 1881473312 18.677 100 10 19 1 1888460512 4827024 2160176
23:27:14 12900 8192000000 10828254896 11249360896 1903081968 18.851 100 25 49 0 1914954096 4921760 6950368
23:27:38 41731 8192000000 10846099504 11271860224 1919950192 18.986 100 44 88 0 1938975952 6152848 12872912
23:28:30 45941 8192000000 10851636208 11285655552 1936042128 19.115 100 40 81 1 1954995760 6946064 12007568
23:29:31 79061 8192000000 10877589152 11308544000 1942190784 19.164 100 34 68 1 1967147856 14458560 10498512
23:31:02 47242 8192000000 10861391024 11311603712 1946653056 19.200 100 15 30 1 1961344480 10673632 4017792
23:31:56 10500 8192000000 10873313888 11306983424 1932512896 19.087 99 34 68 1 1953011824 10096240 10402688
23:32:14 16762 8192000000 10888976000 11318005760 1954976000 19.266 100 39 78 3 1974765520 8808240 10981280
23:32:38 7399 8192000000 10894037136 11328024576 1962155984 19.323 100 50 100 0 1987645744 10567584 14922176
23:32:54 13535 8192000000 10911202400 11343048704 1973102256 19.410 100 59 114 2 1999650064 10136112 16411696
23:33:19 12812 8192000000 10922218512 11338477568 1973811824 19.416 100 64 122 0 2001650896 10894256 16944816
23:33:38 1579 8192000000 10921778672 11347148800 1981365856 19.476 100 64 128 1 2011606064 11054928 19185280
23:33:47 5825 8192000000 10932798912 11357974528 1986797296 19.518 100 68 132 2 2019536528 13151584 19587648
23:34:04 5226 8192000000 10934770320 11350171648 1987758544 19.526 100 76 151 1 2027628048 18302752 21566752
23:34:20 19387 8192000000 10936449824 11355041792 1972152992 19.403 99 64 126 1 2005276576 14173152 18950432
23:34:46 10294 8192000000 10923144000 11358519296 1989447744 19.539 100 52 104 0 2017784096 12794560 15541792
23:35:04 10732 8192000000 10931922032 11364651008 1993575088 19.572 100 49 98 1 2020566192 12069312 14921792
23:35:22 8183 8192000000 10951598144 11381100544 2006450800 19.674 100 58 116 0 2037635120 13628672 17555648
23:35:51 19400 8192000000 10951764624 11388121088 2008513040 19.690 100 47 93 1 2037238512 15250624 13474848
23:36:22 5758 8192000000 10942150176 11376349184 1992867696 19.566 99 57 114 0 2025709904 15244368 17597840
23:36:42 10506 8192000000 10950616048 11381555200 1992272384 19.562 99 54 107 1 2026419296 17895088 16251824
23:37:04 5491 8192000000 10950524544 11381276672 2000933344 19.630 100 59 118 1 2038526000 19979344 17613312
23:37:22 6378 8192000000 10941330688 11369578496 1988790144 19.534 100 63 126 0 2029449360 21371872 19287344
23:37:38 7302 8192000000 10924859328 11351404544 1976750496 19.439 99 60 120 2 2014351792 20123824 17477472
23:37:53 18881 8192000000 10937808400 11367796736 1987666256 19.525 100 61 122 0 2026256896 19974864 18615776
23:38:19 8915 8192000000 10949023216 11383750656 1995319104 19.586 100 54 108 0 2037730384 26022544 16388736
23:38:41 9123 8192000000 10943849088 11380473856 1993211440 19.569 100 62 124 1 2041250560 29227248 18811872
23:39:00 10093 8192000000 10949625392 11390484480 1998520672 19.611 100 43 86 0 2040061728 28185792 13355264
23:39:19 6402 8192000000 10962533136 11387351040 1999858688 19.622 100 57 111 0 2042772304 25651392 17262224
23:39:40 5569 8192000000 10931346592 11356893184 1962521328 19.326 99 63 124 1 2005698624 24254912 18922384
23:39:52 8208 8192000000 10945773072 11368726528 1971304944 19.396 99 64 126 1 2015440512 24865760 19269808
23:40:09 4582 8192000000 10944685728 11366883328 1983462368 19.492 100 71 143 0 2032245072 27097472 21685232
23:40:21 1772 8192000000 10955214672 11364814848 1972122432 19.402 99 90 182 0 2027165040 28706960 26335648
23:40:30 4068 8192000000 10958028960 11374714880 1987945392 19.528 100 84 166 3 2041720128 29512208 24262528
23:40:44 2126 8192000000 10946482480 11354193920 1968256176 19.372 99 86 167 2 2025130560 32001232 24873152
23:40:52 2362 8192000000 10968263344 11380731904 1991247904 19.554 100 87 172 1 2049886224 32763872 25874448
23:41:02 3391 8192000000 10966891072 11378413568 1990130976 19.545 100 85 168 1 2049196848 33893728 25172144
23:41:12 3530 8192000000 10964239264 11376230400 1982175232 19.482 100 87 173 1 2042013040 33157088 26680720
23:41:25 2522 8192000000 10951164656 11363639296 1978757408 19.455 100 88 176 2 2040838944 34304288 27777248
23:41:35 2942 8192000000 10942888192 11356753920 1970293360 19.388 100 76 150 2 2029738240 35439424 24005456
23:41:46 2135 8192000000 10945494320 11356844032 1965197232 19.347 100 88 177 0 2029775952 37198352 27380368
23:41:54 3244 8192000000 10946765456 11355295744 1964956240 19.345 100 88 173 1 2029673088 37848528 26868320
23:42:09 2709 8192000000 10940435456 11344216064 1950368896 19.229 100 90 176 2 2017795968 40291152 27135920
23:42:20 2805 8192000000 10921320288 11334934528 1945917424 19.194 100 76 153 0 2010844368 41364048 23562896
23:42:30 7153 8192000000 10933133440 11351719936 1955950128 19.274 100 78 156 2 2022004768 41137984 24916656
23:42:49 1861 8192000000 10923090304 11339333632 1946290880 19.197 100 73 147 1 2011886640 41311488 24284272
23:42:58 3379 8192000000 10949495728 11360182272 1961126416 19.315 100 82 165 1 2029608336 42699952 25781968
23:43:10 2557 8192000000 10949741744 11362516992 1961033936 19.314 100 81 163 1 2031532832 44323488 26175408
23:43:19 3501 8192000000 10950996608 11368181760 1964891200 19.345 100 78 156 2 2036246704 46186512 25168992
23:43:32 5252 8192000000 10948965824 11369005056 1966067040 19.354 100 70 138 1 2036243344 48469600 21706704
23:43:44 6930 8192000000 10946079984 11370885120 1970040384 19.386 100 68 137 2 2034774416 43937360 20796672
23:43:59 4483 8192000000 10969117136 11384733696 1976292944 19.435 100 73 146 1 2047299104 48036096 22970064
23:44:11 4773 8192000000 10958478768 11374100480 1967998112 19.370 100 79 156 2 2041554640 49492208 24064320
23:44:25 4314 8192000000 10979290416 11390500864 1976394256 19.436 100 91 180 2 2056886048 52557184 27934608
23:44:36 1308 8192000000 10974292352 11383279616 1973766336 19.415 100 84 168 1 2050728512 50012480 26949696
23:44:45 2386 8192000000 10982230416 11390566400 1985025680 19.504 100 84 168 1 2058831216 47464384 26341152
23:44:55 2674 8192000000 10987151408 11399667712 1992681632 19.565 100 84 168 0 2066658208 47724048 26252528
23:45:05 3680 8192000000 10992300336 11403161600 1992861552 19.566 100 89 177 3 2069342112 48952320 27528240
23:45:18 2385 8192000000 10972175040 11382530048 1973021648 19.409 99 87 175 0 2050301776 50392144 26887984
23:45:29 1108 8192000000 10991262016 11399852032 1990466208 19.547 100 89 176 0 2070195024 50983296 28745520
23:45:36 2538 8192000000 10992363888 11405447168 1991993600 19.560 100 89 177 4 2072788240 52862736 27931904
23:45:47 1325 8192000000 10983194176 11397599232 1975503360 19.429 99 91 182 0 2052961728 49381472 28076896
23:45:57 5031 8192000000 10978128944 11398193152 1988730672 19.534 100 73 146 2 2059492816 48034400 22727744
23:46:16 2515 8192000000 10967702256 11378823168 1969310880 19.380 99 76 152 0 2042402608 48759696 24332032
23:46:26 7442 8192000000 10959406976 11397386240 1986084592 19.513 100 54 108 0 2053286800 49804032 17398176
23:46:41 18681 8192000000 10975030000 11401859072 1988035776 19.528 100 54 108 3 2051513984 46638800 16839408
23:47:07 6388 8192000000 10963708144 11399610368 1984844352 19.503 100 53 106 3 2051603760 49519648 17239760
23:47:21 9587 8192000000 10957015168 11401859072 1986387888 19.515 100 45 90 1 2049441184 48168832 14884464
23:47:43 5129 8192000000 10972163520 11407204352 1992354976 19.562 100 44 86 0 2050795536 44726208 13714352
23:47:54 6335 8192000000 10959103248 11396517888 1969955824 19.385 99 44 88 2 2030612496 46030800 14625872
23:48:12 8278 8192000000 10958389216 11384848384 1964046528 19.338 99 59 117 1 2031301664 47490352 19764784
23:48:27 5249 8192000000 10937383152 11372404736 1944249840 19.181 99 48 96 2 2009154880 49435296 15469744
23:48:55 17154 8192000000 10933177392 11379335168 1943491632 19.175 99 30 60 2 2009119200 55132160 10495408
23:49:24 18209 8192000000 10928736224 11376570368 1954473408 19.262 100 31 63 1 2018292272 53469600 10349264
23:49:58 7639 8192000000 10912367664 11350982656 1929192880 19.060 99 34 68 1 1989300032 48700272 11406880
23:50:15 15922 8192000000 10926158976 11366858752 1947349488 19.205 100 36 72 3 2011601232 52842912 11408832
23:50:47 12484 8192000000 10922665232 11364548608 1947179440 19.204 100 36 70 1 2010276352 51515984 11580928
23:51:07 11088 8192000000 10921902720 11360980992 1933349152 19.094 99 41 81 1 1997590176 51255184 12985840
23:51:24 17308 8192000000 10899376000 11344084992 1908518528 18.895 98 29 58 1 1969046592 50808832 9719232
23:51:48 12734 8192000000 10911845616 11348250624 1933916928 19.098 100 26 52 3 1990355264 47323216 9115120
23:52:09 7475 8192000000 10917539840 11361099776 1936790096 19.121 100 30 60 0 2003409856 56472976 10146784
23:52:27 20448 8192000000 10914681728 11370557440 1940496368 19.151 100 29 58 2 2011038992 60310304 10232320
23:53:10 17994 8192000000 10916282416 11362353152 1931631760 19.080 100 26 53 0 1997879424 57158496 9089168
23:53:36 10000 8192000000 10912833024 11363315712 1911764064 18.921 99 21 42 2 1983382400 63514096 8104240
23:53:54 16890 8192000000 10904550000 11353104384 1907521200 18.887 99 25 50 0 1977361472 60703904 9136368
23:54:18 24135 8192000000 10901434928 11350515712 1906069040 18.875 99 32 64 1 1972446400 55008368 11368992
23:54:49 9472 8192000000 10882858944 11347484672 1883496640 18.693 98 23 46 0 1952044800 60204352 8343808
23:55:56 59447 8192000000 10840016112 11300470784 1842118768 18.358 96 6 12 1 1862808256 18931552 1757936
23:57:04 70372 8192000000 10845310400 11293769728 1884237536 18.699 98 27 54 0 1902900544 10419600 8243408
23:58:23 69845 8192000000 10856678800 11287408640 1852116624 18.439 96 32 64 0 1868318832 7479632 8722576
23:59:43 10488 8192000000 10882202720 11300683776 1907695968 18.888 99 48 95 1 1927731920 7107776 12928176
00:00:02 50084 8192000000 10861854048 11316740096 1916987248 18.963 99 23 46 2 1934912176 11455952 6468976
00:01:01 58737 8192000000 10858378080 11312939008 1914643392 18.944 99 18 36 1 1933977808 14632768 4701648
00:02:07 65420 8192000000 10886227344 11323654144 1899088592 18.819 98 30 60 0 1918907328 10795888 9022848
00:03:22 40460 8192000000 10882388736 11313364992 1922737008 19.009 99 33 67 3 1942634352 10249632 9647712
00:04:18 47147 8192000000 10869173456 11323740160 1918672288 18.976 99 28 55 0 1939748192 11947520 9128384
00:05:25 25657 8192000000 10860723664 11321470976 1937954432 19.130 100 8 16 0 1948393120 8501952 1936736
00:05:57 49802 8192000000 10858233696 11318616064 1929766368 19.065 99 19 37 0 1942040016 7393840 4879808
00:06:58 49408 8192000000 10872015664 11336376320 1950240688 19.228 100 10 20 1 1960592096 7380000 2971408
00:07:53 33165 8192000000 10877474864 11341594624 1952215344 19.244 100 9 17 0 1963308960 8418944 2674672
00:08:33 22738 8192000000 10886122560 11348930560 1959874304 19.305 100 16 32 1 1975301360 10724448 4702608
00:09:01 30152 8192000000 10889552576 11349454848 1963686944 19.335 100 11 22 0 1975486736 8778720 3021072
00:10:20 111416 8192000000 10902751888 11371507712 1970149872 19.387 100 12 24 1 1985050800 10992720 3908208
00:12:47 88274 8192000000 10884154272 11365531648 1961019072 19.314 99 20 39 2 1976759216 10085520 5654624
00:14:24 37722 8192000000 10906854336 11379179520 1983026576 19.489 100 13 26 0 1996998384 10371008 3600800
00:15:20 52841 8192000000 10910472080 11389579264 1976533136 19.437 99 33 67 0 2004131968 16362672 11236160
00:17:35 63473 8192000000 10919351040 11404894208 1992678864 19.565 100 17 34 0 2018156992 20413088 5065040
00:19:21 49926 8192000000 10908241840 11379523584 1980947792 19.472 99 9 18 0 1995407376 11956160 2503424
00:20:18 59928 8192000000 10925931568 11409211392 2002786112 19.645 100 18 36 1 2023273584 14908864 5578608
00:21:34 51250 8192000000 10941941456 11397169152 1967108480 19.363 98 19 38 0 1983211104 11104784 4997840
00:22:39 36095 8192000000 10937182432 11394813952 1973400096 19.412 99 31 62 0 1997399408 15101504 8897808
00:23:34 64592 8192000000 10916731104 11390881792 1966675088 19.359 99 16 32 0 1991084736 19732208 4677440
00:25:55 78332 8192000000 10899871200 11369385984 1908085472 18.891 96 9 18 2 1923151856 12682448 2383936
00:27:24 42537 8192000000 10888481712 11345002496 1881123888 18.674 95 29 57 2 1896597264 7757232 7716144
00:28:13 52357 8192000000 10904643312 11370057728 1968492608 19.373 100 17 34 1 1986677312 13689968 4494736
00:29:21 33504 8192000000 10886214272 11337609216 1860866464 18.510 94 20 40 1 1875120816 8981152 5273200
00:31:12 87818 8192000000 10887533056 11360276480 1927320912 19.045 99 31 62 2 1958091536 21633136 9137488
00:32:47 69625 8192000000 10886405360 11356200960 1908928000 18.898 98 12 24 0 1932031696 19920384 3183312
00:34:10 133313 8192000000 10868861472 11324551168 1845749584 18.388 94 25 50 4 1865123904 12431600 6942720
00:36:57 13083 8192000000 10874064752 11324583936 1931296768 19.077 99 41 82 0 1956106000 13081392 11727840
00:37:17 26015 8192000000 10888706480 11348721664 1951907024 19.242 100 21 40 1 1969010592 11450928 5652640
00:37:49 56583 8192000000 10859053392 11342311424 1926523232 19.039 98 25 49 0 1945179472 11272208 7384032
00:38:54 45826 8192000000 10864038080 11341910016 1943511936 19.175 100 5 10 1 1956113648 11333936 1267776
00:39:46 39783 8192000000 10848205184 11321110528 1892726288 18.768 97 10 20 0 1903444192 8122784 2595120
00:41:25 65519 8192000000 10872703184 11345403904 1941457968 19.158 99 19 38 0 1955686032 8599072 5628992
00:42:56 71505 8192000000 10893409584 11367641088 1967704544 19.367 100 22 42 0 1986069904 11191968 7173392
00:44:19 52259 8192000000 10882618080 11369619456 1953081872 19.251 99 26 52 3 1974621344 13435232 8104240
00:45:22 71864 8192000000 10854606496 11324477440 1861639520 18.517 95 16 32 2 1879623584 13236080 4747984
00:46:44 70165 8192000000 10873023424 11348430848 1897081840 18.803 98 11 22 1 1920222512 19754288 3386384
00:48:03 40310 8192000000 10877507744 11343568896 1934389392 19.102 99 38 76 2 1953325920 8417120 10519408
00:48:49 57360 8192000000 10880179296 11345731584 1898261824 18.812 97 23 46 2 1918719440 13777328 6680288
00:49:53 41374 8192000000 10865801200 11333738496 1910344352 18.909 98 25 50 1 1930893472 14066432 6482688
00:50:40 10593 8192000000 10867530848 11313786880 1894137408 18.779 97 54 104 2 1916565504 8274896 14153200
00:51:00 47774 8192000000 10865227808 11317497856 1845095280 18.382 95 30 60 0 1864146272 10744064 8306928
00:51:54 56128 8192000000 10899745952 11353022464 1933715936 19.097 99 32 64 2 1958131024 15501952 8913136
00:53:01 56304 8192000000 10892293184 11370467328 1943731744 19.177 99 29 58 1 1968626160 16468800 8425616
00:54:15 75978 8192000000 10853901840 11332276224 1855648816 18.468 95 14 28 1 1877264640 17878048 3737776
00:55:37 62219 8192000000 10882471376 11344388096 1905028688 18.867 98 20 40 1 1921868544 11284864 5554992
00:56:51 155768 8192000000 10865978576 11340357632 1840661520 18.346 94 24 48 3 1857686720 10667120 6358080
00:59:40 84873 8192000000 10891519760 11353960448 1956460576 19.278 100 31 62 0 1972572208 7688000 8423632
01:01:11 12670 8192000000 10894381600 11347652608 1946870480 19.202 99 39 77 1 1968226528 10452496 10903552
01:01:30 54181 8192000000 10898665088 11368574976 1967252304 19.364 100 35 70 2 1986716304 9900000 9564000
01:02:37 69392 8192000000 10864801584 11345207296 1932657440 19.088 98 5 10 1 1943002192 8995104 1349648
01:04:05 42539 8192000000 10883749776 11368419328 1969154032 19.379 100 13 26 0 1983598240 10925328 3518880
01:04:53 27273 8192000000 10868311120 11333844992 1910226448 18.908 97 11 22 0 1924705312 11623664 2855200
01:05:27 56925 8192000000 10896972288 11370127360 1955985184 19.274 99 16 32 0 1973731696 13500144 4246368
01:07:06 86473 8192000000 10900024704 11376664576 1920740336 18.993 97 10 20 1 1936402928 12604064 3058528
01:08:51 35000 8192000000 10900233600 11370618880 1924502592 19.023 97 23 46 2 1947708640 15699008 7507040
01:09:32 69791 8192000000 10916478544 11385925632 1962217632 19.324 99 25 50 0 1990900864 21404272 7278960
01:10:50 87859 8192000000 10919080496 11392507904 1945728816 19.192 98 24 48 3 1975851456 22396048 7726592
01:12:28 132618 8192000000 10884611840 11358433280 1874352928 18.619 95 14 28 0 1905807936 27385424 4069584
01:14:47 82343 8192000000 10905106512 11369738240 1901820816 18.841 96 34 68 2 1925445504 14116560 9508128
01:16:18 73268 8192000000 10898156064 11351785472 1889738896 18.744 96 23 44 2 1910524224 14382128 6403200
01:17:43 20165 8192000000 10905584896 11359088640 1962679328 19.327 100 42 84 0 1983932112 8609616 12643168
01:18:15 63275 8192000000 10906660064 11372621824 1955036368 19.267 99 24 48 0 1971218864 9499856 6682640
01:19:35 100662 8192000000 10890414224 11359870976 1929873248 19.066 98 17 34 1 1944492288 9674288 4944752
01:21:54 60966 8192000000 10876955616 11353522176 1933781552 19.097 98 25 49 2 1949435248 8641232 7012464
01:23:07 54453 8192000000 10852109856 11333640192 1926379072 19.038 99 7 14 0 1937378016 9024208 1974736
01:24:08 39847 8192000000 10833433968 11310628864 1902341888 18.845 98 12 24 0 1912954496 7107008 3505600
01:24:54 40198 8192000000 10854241952 11321053184 1916028384 18.955 99 11 22 2 1927610352 8509664 3072304
01:25:50 83490 8192000000 10864796192 11346919424 1909518816 18.903 98 16 30 2 1924263680 10544528 4200336

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 20-01-2021 01:29:15 to 20-01-2021 01:29:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 151 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 20-01-2021 01:29:48 to 20-01-2021 01:29:49.

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          236096
MON$OLDEST_ACTIVE               237657
MON$OLDEST_SNAPSHOT             237657
MON$NEXT_TRANSACTION            237657
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                       2028128
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:89: 
:90: mscs-test-161.budzdorov.ru    Wed Jan 20 01:27:23 2021
:91:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:92: 
:93: 
:94: mscs-test-161.budzdorov.ru    Wed Jan 20 01:27:25 2021
:95:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:96: 
:97: 
:98: mscs-test-161.budzdorov.ru    Wed Jan 20 01:27:27 2021
:99:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:100: 
:101: 
:102: mscs-test-161.budzdorov.ru    Wed Jan 20 01:27:27 2021
:103:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:104: 
:105: 
:106: mscs-test-161.budzdorov.ru    Wed Jan 20 01:27:28 2021
:107:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:108: 
:109: 
:110: mscs-test-161.budzdorov.ru    Wed Jan 20 01:27:29 2021
:111:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:112: 
--- end of diff output ---

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

20.01.21 01:29:51. 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-01-20 01:29:53 No severe PSQL-related problems occured
20.01.21 01:29:54. End of report.