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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 16965036 kB
MemAvailable 31292372 kB
Buffers 0 kB
Cached 14702852 kB
SwapCached 4868 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 22:27:12
DTS_END                         2021-01-20 22:27:12.7650
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34174
TRN_ID                          247748
ATT_ID                          698
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: 9419.35 22486 1130322
customer order: creation 175.59 326 21071
customer order: refuse 15.33 348 1839
order to supplier: creation 46.33 1272 5560
order to supplier: removal 3.41 108996 409
invoice (draft): creation 48.12 3580 5774
invoice (draft): removal 53.43 805 6411
invoice accept: apply 43.76 18867 5251
invoice accept: cancel 48.21 807 5785
customer reserve: creation 3959.33 190 475119
customer reserve: removal 4716.94 61 566033
realization accept: apply 86.05 177 10326
realization accept: cancel 88.73 117 10647
payment from customer: creation 60.43 103 7252
payment from customer: removal 6.02 60 722
payment to supplier: creation 51.23 117 6147
payment to supplier: removal 3.63 49 436
service: total inventory turnovers 4.74 1123 569
service: total monetary turnovers 7.18 23 862
service: aggregate perf. data 0.88 20168 105
service: refresh index statistics 0.03 292536 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-01-2021 22:27:55 to 20-01-2021 22:27:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9381
TEST_TIME 2 6799
TEST_TIME 3 6359
TEST_TIME 4 7015
TEST_TIME 5 7170
TEST_TIME 6 7420
TEST_TIME 7 7704
TEST_TIME 8 7433
TEST_TIME 9 7122
TEST_TIME 10 7105
TEST_TIME 11 7242
TEST_TIME 12 7541
TEST_TIME 13 7677
TEST_TIME 14 7938
TEST_TIME 15 7873
TEST_TIME 16 7875
TEST_TIME 17 7917
TEST_TIME 18 8058
TEST_TIME 19 8313
TEST_TIME 20 8166
TEST_TIME 21 8164
TEST_TIME 22 8340
TEST_TIME 23 8542
TEST_TIME 24 8710
TEST_TIME 25 8866
TEST_TIME 26 8968
TEST_TIME 27 8896
TEST_TIME 28 9201
TEST_TIME 29 9537
TEST_TIME 30 9729
TEST_TIME 31 9821
TEST_TIME 32 10076
TEST_TIME 33 10704
TEST_TIME 34 10514
TEST_TIME 35 10468
TEST_TIME 36 10429
TEST_TIME 37 10315
TEST_TIME 38 10201
TEST_TIME 39 10392
TEST_TIME 40 10419
TEST_TIME 41 10365
TEST_TIME 42 10318
TEST_TIME 43 10244
TEST_TIME 44 10059
TEST_TIME 45 10093
TEST_TIME 46 9977
TEST_TIME 47 9873
TEST_TIME 48 9854
TEST_TIME 49 9787
TEST_TIME 50 9775
TEST_TIME 51 9758
TEST_TIME 52 9882
TEST_TIME 53 9786
TEST_TIME 54 9741
TEST_TIME 55 9630
TEST_TIME 56 9685
TEST_TIME 57 9717
TEST_TIME 58 9707
TEST_TIME 59 9694
TEST_TIME 60 9657
TEST_TIME 61 9756
TEST_TIME 62 9768
TEST_TIME 63 9825
TEST_TIME 64 9850
TEST_TIME 65 9865
TEST_TIME 66 9881
TEST_TIME 67 9842
TEST_TIME 68 9886
TEST_TIME 69 9866
TEST_TIME 70 9856
TEST_TIME 71 9959
TEST_TIME 72 9839
TEST_TIME 73 9792
TEST_TIME 74 9714
TEST_TIME 75 9703
TEST_TIME 76 9673
TEST_TIME 77 9649
TEST_TIME 78 9650
TEST_TIME 79 9603
TEST_TIME 80 9534
TEST_TIME 81 9508
TEST_TIME 82 9493
TEST_TIME 83 9448
TEST_TIME 84 9447
TEST_TIME 85 9452
TEST_TIME 86 9474
TEST_TIME 87 9450
TEST_TIME 88 9590
TEST_TIME 89 9551
TEST_TIME 90 9593
TEST_TIME 91 9633
TEST_TIME 92 9661
TEST_TIME 93 9675
TEST_TIME 94 9662
TEST_TIME 95 9775
TEST_TIME 96 9778
TEST_TIME 97 9706
TEST_TIME 98 9671
TEST_TIME 99 9635
TEST_TIME 100 9608
TEST_TIME 101 9555
TEST_TIME 102 9487
TEST_TIME 103 9480
TEST_TIME 104 9510
TEST_TIME 105 9469
TEST_TIME 106 9436
TEST_TIME 107 9380
TEST_TIME 108 9303
TEST_TIME 109 9370
TEST_TIME 110 9322
TEST_TIME 111 9302
TEST_TIME 112 9397
TEST_TIME 113 9437
TEST_TIME 114 9441
TEST_TIME 115 9471
TEST_TIME 116 9437
TEST_TIME 117 9442
TEST_TIME 118 9477
TEST_TIME 119 9492
TEST_TIME 120 9424

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-01-2021 22:27:59 to 20-01-2021 22:28:02.

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 1569493 1569493 0 0.00 0 18628 6 0 0
doc_list_biud 1569492 1569492 0 0.00 0 44113 28 0 0
sp_add_invoice_to_stock 5362 5251 111 2.07 47 185337 18868 0 111
sp_cancel_adding_invoice 5785 5785 0 0.00 5 49801 808 0 0
sp_cancel_client_order 1839 1839 0 0.00 4 11366 348 0 0
sp_cancel_customer_reserve 566033 566033 0 0.00 1 44119 61 0 0
sp_cancel_pay_from_customer 722 722 0 0.00 2 1226 61 0 0
sp_cancel_pay_to_supplier 436 436 0 0.00 3 809 50 0 0
sp_cancel_supplier_invoice 6415 6411 4 0.06 1 31320 805 0 4
sp_cancel_supplier_order 409 409 0 0.00 6 988279 108996 0 0
sp_cancel_write_off 10647 10647 0 0.00 1 20629 117 0 0
sp_client_order 21071 21071 0 0.00 3 13664 326 0 0
sp_customer_reserve 475119 475119 0 0.00 0 119331 190 0 0
sp_fill_shopping_cart 32392 32392 0 0.00 1 17668 40 0 0
sp_fill_shopping_cart_clo_res 475101 475101 0 0.00 0 12402 12 0 0
sp_get_clo_for_invoice 5233 5233 0 0.00 0 35729 297 0 0
sp_kill_cost_storno 17590 17590 0 0.00 0 9789 58 0 0
sp_kill_qstorno_ret_qs2qd 1149533 1149533 0 0.00 0 43977 33 0 0
sp_kill_qty_storno 606683 606683 0 0.00 0 44112 72 0 0
sp_lock_selected_doc 21529 21529 0 0.00 0 11075 6 0 0
sp_make_cost_storno 28958 28958 0 0.00 0 18618 54 0 0
sp_multiply_rows_for_pdistr 28958 28958 0 0.00 0 6235 25 0 0
sp_multiply_rows_for_qdistr 21071 21071 0 0.00 0 13190 148 0 0
sp_pay_from_customer 7252 7252 0 0.00 4 9346 103 0 0
sp_pay_to_supplier 6147 6147 0 0.00 4 35614 118 0 0
sp_payment_common 13399 13399 0 0.00 1 35603 24 0 0
sp_qd_handle_on_cancel_clo 1839 1839 0 0.00 0 11361 314 0 0
sp_qd_handle_on_invoice_upd_sts 11018 11018 0 0.00 0 17583 368 0 0
sp_qd_handle_on_reserve_upd_sts 10326 10326 0 0.00 0 16389 59 0 0
sp_reserve_write_off 10326 10326 0 0.00 6 16419 177 0 0
sp_supplier_invoice 5774 5774 0 0.00 5 109165 3580 0 0
sp_supplier_order 5560 5560 0 0.00 4 27489 1272 0 0
srv_aggregate_perf_data 105 105 0 0.00 2910 317117 20169 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 1040 143639 29459 0 0
srv_find_qd_qs_mism 1080817 1080817 0 0.00 0 18382 6 0 0
srv_make_invnt_saldo 569 569 0 0.00 34 95533 1124 0 0
srv_make_money_saldo 862 862 0 0.00 0 1168 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 168857 408364 292537 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5251 5251 0 0.00 0 14142 173 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 1246 65 0 0
t$perf-norm:sp_cancel_client_order 1839 1839 0 0.00 0 1979 12 0 0
t$perf-norm:sp_cancel_customer_reserve 727 727 0 0.00 0 887 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 722 722 0 0.00 0 3444 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 436 436 0 0.00 0 1931 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 420 420 0 0.00 0 819 13 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 19530 1653 0 0
t$perf-norm:sp_cancel_write_off 1002 1002 0 0.00 0 2718 13 0 0
t$perf-norm:sp_client_order 21071 21071 0 0.00 0 5368 17 0 0
t$perf-norm:sp_customer_reserve 1030 1030 0 0.00 0 2657 12 0 0
t$perf-norm:sp_pay_from_customer 7252 7252 0 0.00 0 4575 8 0 0
t$perf-norm:sp_pay_to_supplier 6147 6147 0 0.00 0 4937 11 0 0
t$perf-norm:sp_reserve_write_off 10326 10326 0 0.00 0 11312 13 0 0
t$perf-norm:sp_supplier_invoice 5774 5774 0 0.00 0 6044 19 0 0
t$perf-norm:sp_supplier_order 5560 5560 0 0.00 0 4344 17 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 2989 43 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 247 5 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 1548 31 0 0
t$perf-norm:srv_make_money_saldo 862 862 0 0.00 0 1364 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 42 12 0 0
v_add_invoice_to_stock 10688 10466 222 2.07 0 8262 18 0 222
v_all_customers 38262 38262 0 0.00 0 36 1 0 0
v_all_suppliers 31242 31242 0 0.00 0 43 1 0 0
v_all_wares 42142 42142 0 0.00 0 52 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 1565 7 0 0
v_cancel_client_order 3678 3678 0 0.00 0 2784 6 0 0
v_cancel_customer_prepayment 1444 1444 0 0.00 0 853 5 0 0
v_cancel_customer_reserve 1454 1454 0 0.00 0 611 4 0 0
v_cancel_payment_to_supplier 872 872 0 0.00 0 469 4 0 0
v_cancel_supplier_invoice 848 840 8 0.94 0 242 13 0 8
v_cancel_supplier_order 818 818 0 0.00 0 2747 9 0 0
v_cancel_write_off 2004 2004 0 0.00 0 1506 12 0 0
v_max_id_clo_ord 5558 5558 0 0.00 0 700 1 0 0
v_max_id_clo_res 1030 1030 0 0.00 0 1659 10 0 0
v_max_id_ord_sup 5763 5763 0 0.00 0 4822 2 0 0
v_max_non_paid_invoice 1847 1847 0 0.00 0 1213 3 0 0
v_max_non_paid_realizn 3939 3939 0 0.00 0 883 3 0 0
v_min_id_clo_ord 5558 5558 0 0.00 0 3854 6 0 0
v_min_id_clo_res 1030 1030 0 0.00 0 4685 18 0 0
v_min_id_ord_sup 5763 5763 0 0.00 0 6958 10 0 0
v_min_non_paid_invoice 6147 6147 0 0.00 0 35597 20 0 0
v_min_non_paid_realizn 7252 7252 0 0.00 0 5237 11 0 0
v_our_firm 10506 10506 0 0.00 0 19 1 0 0
v_reserve_write_off 20652 20652 0 0.00 0 6348 5 0 0
x_lock_depdocs_on_canc_invoice 11776 11776 0 0.00 0 16839 125 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 25712 509 0 0
x_make_qstorno_1000_1200 5560 5560 0 0.00 1 27465 1193 0 0
x_make_qstorno_1200_2000 5774 5774 0 0.00 2 109094 3431 0 0
x_make_qstorno_2100_3300 475119 475119 0 0.00 0 119330 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-01-2021 22:28:03 to 20-01-2021 22:28:07.

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:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:23 19784 8192000000 10243937344 10550161408 954431264 10.435 75 58 116 0 977208640 2666752 20110624
19:57:53 23268 8192000000 10338938944 10658103296 1382894880 14.442 100 79 156 1 1413609024 4703216 26010928
19:58:26 24283 8192000000 10390248448 10711863296 1434183424 14.898 100 84 168 0 1467143232 6139104 26820704
19:58:58 19917 8192000000 10412216608 10739273728 1457853680 15.107 100 88 176 0 1493758656 7396640 28508336
19:59:28 15286 8192000000 10433099088 10764820480 1484084256 15.337 100 86 172 1 1520060304 8370208 27605840
19:59:53 25543 8192000000 10458022512 10793771008 1506633056 15.534 100 86 172 3 1542686832 8970816 27082960
20:00:27 17535 8192000000 10471814832 10810302464 1526785984 15.709 100 88 176 0 1564041392 9532400 27723008
20:00:53 27928 8192000000 10489615376 10833162240 1543800672 15.856 100 84 168 1 1579639648 9721248 26117728
20:01:34 14118 8192000000 10497510784 10846109696 1560133392 15.997 100 83 166 1 1595161072 9670656 25357024
20:01:59 20072 8192000000 10529805520 10880327680 1588783712 16.243 100 79 158 1 1622705696 10082480 23839504
20:02:28 16708 8192000000 10569200032 10925883392 1624801552 16.551 100 78 156 0 1658214896 10074560 23338784
20:02:53 12192 8192000000 10570565760 10932400128 1635516832 16.642 100 74 148 1 1667643616 10327216 21799568
20:03:15 14619 8192000000 10605683840 10969878528 1666533200 16.904 100 81 162 2 1701773584 11891216 23349168
20:03:40 7605 8192000000 10620553488 10988257280 1677487296 16.996 100 72 142 4 1709392848 11675392 20230160
20:03:56 9292 8192000000 10636797312 11008356352 1702390304 17.205 100 80 160 2 1737434208 12220960 22822944
20:04:13 8823 8192000000 10657236304 11028250624 1715231936 17.312 100 81 162 1 1750571936 12150944 23189056
20:04:31 3270 8192000000 10662777616 11036307456 1728626224 17.424 100 84 168 1 1765782112 13083600 24072288
20:04:42 5405 8192000000 10685706896 11060785152 1740722912 17.525 100 81 162 0 1776651264 13060784 22867568
20:04:56 4131 8192000000 10699459344 11075436544 1756916064 17.659 100 83 166 1 1794589408 14229216 23444128
20:05:08 5280 8192000000 10706358432 11081060352 1764508064 17.722 100 82 164 0 1802175776 15046336 22621376
20:05:21 4056 8192000000 10714137424 11088130048 1772232336 17.785 100 85 169 0 1809186256 13887856 23066064
20:05:32 4527 8192000000 10714763520 11095797760 1777403984 17.828 100 86 171 0 1815672256 14691584 23576688
20:05:44 2846 8192000000 10732034464 11107659776 1783540400 17.879 100 83 166 0 1821856864 14855504 23460960
20:05:54 5693 8192000000 10729910880 11112624128 1787038192 17.907 100 76 151 0 1822024768 13524240 21462336
20:06:07 4175 8192000000 10744633200 11125313536 1792354560 17.951 100 81 162 0 1828139296 13701120 22083616
20:06:19 2866 8192000000 10754543040 11138863104 1814767104 18.135 100 89 178 2 1854827760 14618368 25442288
20:06:28 1889 8192000000 10772823328 11155300352 1827196496 18.236 100 88 176 3 1866405920 12838272 26371152
20:06:36 3360 8192000000 10769607136 11152703488 1827650144 18.240 100 83 167 1 1864075136 11669504 24755488
20:06:46 2458 8192000000 10776832832 11166961664 1834558320 18.296 100 82 164 0 1870763136 11910976 24293840
20:06:55 1986 8192000000 10778736256 11167780864 1842424512 18.361 100 89 178 1 1881437504 12846352 26166640
20:07:04 1953 8192000000 10790908816 11176534016 1851905200 18.438 100 93 188 2 1891256000 13735936 25614864
20:07:12 2368 8192000000 10796381584 11181965312 1856057568 18.471 100 94 188 2 1897041136 14628528 26355040
20:07:21 1151 8192000000 10801154608 11184852992 1859758304 18.501 100 95 192 1 1899865232 13025904 27081024
20:07:29 2043 8192000000 10802327792 11191844864 1859504992 18.499 100 86 172 3 1897161744 13450576 24206176
20:07:37 1522 8192000000 10807156112 11193171968 1861424048 18.515 100 87 175 1 1898426576 12454160 24548368
20:07:45 1829 8192000000 10808601984 11196182528 1863087648 18.528 100 90 182 2 1902487904 14333776 25066480
20:07:53 1856 8192000000 10815176064 11200905216 1869955968 18.584 100 93 185 0 1911153936 14453680 26744288
20:08:01 1834 8192000000 10820496624 11207237632 1869085648 18.577 100 92 184 1 1909090224 14423680 25580896
20:08:10 1636 8192000000 10803129696 11201527808 1868251088 18.570 100 74 148 0 1901853424 13496816 20105520
20:08:18 3552 8192000000 10803281744 11205828608 1875380576 18.628 100 77 154 1 1909645936 12561152 21704208
20:08:28 2964 8192000000 10805118080 11207348224 1876894304 18.640 100 71 142 0 1906964720 10740944 19329472
20:08:37 25684 8192000000 10790888544 11208327168 1873673488 18.614 100 61 123 0 1900588336 8791136 18123712
20:09:09 9175 8192000000 10790113120 11207675904 1874516896 18.621 100 49 99 2 1895885088 6945856 14422336
20:09:25 9276 8192000000 10792218976 11218210816 1872543152 18.605 100 17 35 0 1886292064 9409696 4339216
20:09:42 4641 8192000000 10791657584 11215335424 1878843920 18.656 100 24 48 2 1892821920 6607280 7370720
20:09:56 8664 8192000000 10789003008 11215118336 1881213424 18.675 100 29 56 2 1897332544 8095008 8024112
20:10:13 7644 8192000000 10795637488 11225915392 1890056400 18.746 100 22 44 0 1902218032 5817648 6343984
20:10:30 9498 8192000000 10800835984 11232706560 1891407552 18.757 100 24 48 2 1908591200 10326368 6857280
20:10:46 9816 8192000000 10799502560 11229904896 1891868208 18.761 100 18 36 3 1902513376 6150368 4494800
20:11:05 13805 8192000000 10804473856 11232063488 1891247152 18.756 100 13 26 1 1900126336 5666720 3212464
20:11:26 10059 8192000000 10809980976 11240386560 1895026784 18.786 100 17 34 2 1905684048 5977184 4680080
20:11:47 6148 8192000000 10814946704 11247661056 1901757232 18.840 100 18 35 1 1912640064 5961328 4921504
20:12:00 10137 8192000000 10812882080 11247808512 1905754320 18.873 100 18 36 0 1917407936 6791424 4862192
20:12:17 10161 8192000000 10835838960 11253669888 1911633008 18.920 100 35 70 2 1928000704 6747264 9620432
20:12:38 73860 8192000000 10831456448 11265998848 1916024160 18.955 100 29 58 2 1934358896 9286672 9048064
20:13:58 7239 8192000000 10830606032 11269156864 1917014048 18.963 100 21 42 0 1928845504 5890720 5940736
20:14:17 7299 8192000000 10844463824 11276529664 1922667344 19.008 100 35 70 1 1939510096 7067344 9775408
20:14:30 7170 8192000000 10843487632 11274010624 1923520496 19.015 100 38 76 0 1942098720 7630272 10947952
20:14:45 8048 8192000000 10847018080 11276746752 1921737984 19.001 100 22 45 0 1934608624 5721792 7148848
20:15:01 8148 8192000000 10836983088 11267239936 1916791296 18.961 100 26 52 2 1930253776 6269744 7192736
20:15:21 13015 8192000000 10822802032 11264110592 1901132528 18.835 99 28 56 1 1915774992 6272528 8369936
20:15:41 9045 8192000000 10832604016 11267928064 1917191456 18.964 100 28 55 4 1934758640 9590256 7976928
20:15:58 14431 8192000000 10795979808 11227951104 1808469680 18.083 95 13 26 0 1821131776 8969056 3693040
20:16:19 6791 8192000000 10784061088 11214147584 1843301616 18.368 98 20 40 0 1855363088 5928304 6133168
20:16:32 10199 8192000000 10770790864 11195822080 1841526816 18.353 98 20 40 0 1852406880 5027904 5852160
20:16:49 9382 8192000000 10776495280 11209949184 1849382128 18.417 99 18 36 0 1868690320 14639168 4669024
20:17:06 49317 8192000000 10755502608 11165814784 1741967008 17.535 93 23 46 0 1758072416 9198384 6907024
20:18:22 13639 8192000000 10729372944 11155075072 1768148576 17.752 96 12 24 0 1777708512 6131648 3428288
20:18:42 7026 8192000000 10721079568 11140468736 1742035648 17.536 95 32 64 3 1762111456 10815440 9260368
20:18:55 7654 8192000000 10730283616 11158650880 1778078240 17.834 97 16 31 0 1787342816 5049472 4215104
20:19:09 6248 8192000000 10735547568 11147591680 1772715280 17.789 97 40 81 2 1791073984 6584064 11774640
20:19:23 3981 8192000000 10726008848 11145633792 1814096224 18.129 100 31 62 0 1829051888 6055888 8899776
20:19:36 7052 8192000000 10692940256 11110281216 1742830336 17.542 97 24 48 2 1756391552 6368304 7192912
20:19:49 10046 8192000000 10690105872 11098578944 1714041232 17.302 96 33 64 3 1729816816 5922544 9853040
20:20:05 8001 8192000000 10710957264 11118014464 1734480864 17.473 97 28 56 1 1747631904 5142096 8008944
20:20:20 10249 8192000000 10700143232 11113439232 1743131600 17.545 97 27 51 3 1756535920 5981552 7422768
20:20:40 10984 8192000000 10703087552 11117146112 1749415296 17.597 98 17 34 2 1758729024 4691024 4622704
20:20:57 13441 8192000000 10708569376 11126624256 1778139872 17.834 99 24 48 1 1790788048 5198848 7449328
20:21:17 10580 8192000000 10725656784 11143405568 1808333376 18.082 100 26 52 1 1821786192 5472800 7980016
20:21:33 30126 8192000000 10739792304 11164622848 1792240864 17.950 98 27 54 1 1805294896 5030864 8023168
20:22:38 25996 8192000000 10739427280 11165659136 1796281536 17.983 98 21 42 0 1811495520 9614288 5599696
20:23:11 7283 8192000000 10762184880 11183697920 1839273120 18.335 100 30 60 0 1854537584 7317360 7947104
20:23:28 8461 8192000000 10760676976 11185885184 1849320336 18.417 100 27 54 1 1862954448 5935152 7698960
20:23:46 8242 8192000000 10771245296 11196522496 1852713792 18.444 100 24 48 1 1866041872 6864976 6463104
20:24:05 8919 8192000000 10777131536 11204243456 1861751968 18.517 100 28 56 1 1875551984 5926832 7873184
20:24:22 5533 8192000000 10778151952 11204509696 1863178992 18.529 100 22 44 1 1875491152 6258032 6054128
20:24:34 7090 8192000000 10774385808 11204812800 1863636880 18.533 100 22 44 1 1877154960 7106912 6411168
20:24:48 6738 8192000000 10785388848 11211968512 1867481664 18.564 100 20 40 0 1879681616 5912880 6287072
20:25:02 7971 8192000000 10777051328 11205791744 1862224544 18.521 100 16 32 1 1872576736 5726464 4625728
20:25:20 10907 8192000000 10787041776 11213946880 1868018032 18.568 100 16 32 2 1877097984 4615376 4464576
20:25:41 7903 8192000000 10786377216 11216056320 1872264816 18.603 100 20 40 2 1883560544 5582400 5713328
20:25:57 10529 8192000000 10787054208 11219275776 1874432272 18.620 100 14 26 2 1883460752 5273664 3754816
20:26:14 13688 8192000000 10787211520 11221467136 1876371024 18.636 100 17 34 1 1887009360 5913440 4724896
20:26:48 62163 8192000000 10820214784 11247296512 1893487856 18.774 100 33 66 0 1908593280 5418576 9686848
20:27:57 16543 8192000000 10844527808 11265118208 1920166000 18.988 100 49 97 1 1940296144 5837168 14292976
20:28:21 12660 8192000000 10846783120 11277262848 1925888416 19.034 100 41 81 1 1944408432 6998640 11521376
20:28:51 22866 8192000000 10859165376 11287855104 1940422912 19.150 100 57 111 4 1965144672 8129504 16592256
20:29:22 10318 8192000000 10880110160 11303538688 1945927744 19.194 100 46 91 0 1967941488 9306656 12707088
20:29:39 24846 8192000000 10877015632 11304456192 1943716480 19.176 100 50 100 3 1969261136 11457616 14087040
20:30:14 27558 8192000000 10883610848 11313160192 1955232704 19.268 100 60 120 2 1984247280 11573104 17441472
20:30:50 10813 8192000000 10889631472 11319316480 1961152256 19.315 100 53 105 1 1987166352 11076144 14937952
20:31:08 6990 8192000000 10894201680 11321696256 1960522704 19.310 100 57 114 0 1989986672 12692816 16771152
20:31:28 2838 8192000000 10862299488 11277492224 1915464288 18.950 98 51 100 0 1941491712 11479888 14547536
20:31:37 9799 8192000000 10881123792 11307188224 1926831408 19.042 99 53 104 1 1953786064 12456400 14498256
20:31:59 4616 8192000000 10895264144 11311116288 1948375984 19.214 100 58 116 2 1977143376 11859616 16907776
20:32:10 18182 8192000000 10875720480 11299979264 1926695840 19.040 99 55 108 1 1954462704 12046208 15720656
20:32:37 16133 8192000000 10880663216 11311398912 1952137920 19.244 100 52 104 1 1979522512 12482368 14902224
20:33:07 9583 8192000000 10881630800 11316490240 1957922192 19.290 100 37 72 2 1978434496 9559904 10952400
20:33:26 3434 8192000000 10908655984 11332247552 1968234144 19.371 100 62 123 1 1998268592 11752304 18282144
20:33:38 19542 8192000000 10901606496 11336314880 1970955136 19.393 100 56 112 2 2000812224 13627728 16229360
20:34:04 4536 8192000000 10914922944 11341406208 1973415344 19.413 100 57 114 1 2002537520 12621536 16500640
20:34:18 17924 8192000000 10910834832 11338625024 1972256352 19.403 100 56 110 2 2001684288 13718032 15709904
20:34:50 1945 8192000000 10912851072 11323060224 1962161648 19.323 99 71 140 1 1992503504 10421184 19920672
20:34:59 17968 8192000000 10891660976 11316375552 1937945936 19.130 98 59 117 1 1966444768 11346912 17151920
20:35:25 8623 8192000000 10914851328 11337232384 1956396208 19.277 99 71 143 0 1990720928 14038496 20286224
20:35:40 3194 8192000000 10921830416 11343351808 1978851264 19.456 100 67 134 3 2011782640 14291360 18640016
20:35:51 6041 8192000000 10908189248 11333955584 1968718272 19.375 100 56 112 1 1998434160 13730224 15985664
20:36:06 8039 8192000000 10924276544 11341725696 1975270608 19.427 100 63 125 1 2006729392 13902848 17555936
20:36:27 15391 8192000000 10928501552 11352559616 1981483840 19.476 100 54 105 0 2010659024 13823456 15351728
20:36:49 4448 8192000000 10926399136 11347795968 1970458176 19.389 99 75 150 1 2007409200 14771344 22179680
20:37:05 13543 8192000000 10913294752 11337564160 1963725216 19.336 99 63 125 0 2000776064 18924944 18125904
20:37:27 12139 8192000000 10928792448 11357761536 1984354880 19.499 100 64 124 1 2024817056 20641472 19820704
20:37:48 2360 8192000000 10927415664 11352002560 1978285760 19.451 100 59 118 1 2015787376 20188000 17313616
20:38:00 4801 8192000000 10937699056 11362361344 1983007888 19.489 100 61 122 1 2026916592 25279248 18629456
20:38:14 3421 8192000000 10958554784 11375460352 1997461040 19.603 100 81 162 0 2044458432 21833840 25163552
20:38:24 10928 8192000000 10930116224 11357962240 1976928416 19.440 99 65 130 0 2019162016 22571904 19661696
20:38:44 12177 8192000000 10943995088 11367702528 1985148016 19.505 100 59 118 0 2026819616 24295888 17375712
20:39:07 2042 8192000000 10948981040 11371716608 1979688160 19.462 99 69 138 1 2025352560 24272336 21392064
20:39:17 1886 8192000000 10912148752 11326595072 1947323536 19.205 99 84 165 3 1997335008 25288112 24723360
20:39:26 13333 8192000000 10914133920 11342217216 1961449584 19.318 100 65 129 2 2006077792 25827248 18800960
20:39:52 12659 8192000000 10908015968 11338502144 1958049776 19.291 100 62 124 0 2002183056 25268528 18864752
20:40:16 12040 8192000000 10894853888 11324116992 1932579504 19.087 99 53 106 0 1974676576 25120848 16976224
20:40:36 3948 8192000000 10883799152 11309912064 1903833264 18.857 98 60 118 2 1950166336 27997840 18335232
20:40:48 15555 8192000000 10900731824 11329105920 1944813088 19.185 100 55 110 0 1992007408 30402928 16791392
20:41:12 3582 8192000000 10895793888 11315240960 1935273872 19.109 99 69 139 1 1987257936 30020912 21963152
20:41:25 6283 8192000000 10908227520 11336798208 1954139984 19.259 100 68 133 2 2006340176 30803344 21396848
20:41:43 4920 8192000000 10919342000 11345506304 1965860976 19.353 100 47 94 1 2006911392 25795312 15255104
20:41:58 23038 8192000000 10920574016 11354976256 1955298928 19.269 99 47 94 1 1992555648 22693552 14563168
20:42:36 11024 8192000000 10915509072 11329585152 1941677296 19.160 99 70 141 1 1989358992 26871728 20809968
20:42:55 6383 8192000000 10934201552 11353866240 1964834496 19.344 100 62 124 1 2014428752 30596048 18998208
20:43:10 5612 8192000000 10925846608 11343290368 1962090240 19.323 100 75 149 0 2014134512 29605344 22438928
20:43:24 4379 8192000000 10933852896 11343900672 1948348928 19.213 99 82 162 2 2003765504 30775248 24641328
20:43:35 1040 8192000000 10944235344 11348074496 1964042048 19.338 100 90 178 1 2022460016 31528352 26889616
20:43:43 5091 8192000000 10948435664 11361976320 1972778656 19.407 100 77 154 2 2028956080 32501232 23676192
20:43:55 3934 8192000000 10930600704 11342032896 1952474896 19.246 99 79 155 0 2008591968 33328352 22788720
20:44:07 2602 8192000000 10946872752 11361845248 1971635152 19.398 100 88 174 0 2032445648 35073744 25736752
20:44:20 4002 8192000000 10951007312 11357908992 1965303520 19.348 100 74 148 2 2023307488 34636032 23367936
20:44:32 20467 8192000000 10915728720 11340644352 1936430800 19.118 99 58 117 0 1990480592 35788832 18260960
20:44:59 2431 8192000000 10923540032 11329204224 1940289392 19.149 99 76 151 2 1997287568 34148736 22849440
20:45:10 13898 8192000000 10911333776 11336675328 1945192112 19.188 100 55 110 0 1996949872 34155824 17601936
20:45:39 6846 8192000000 10913304128 11338682368 1936747488 19.121 99 55 109 1 1985593504 31880336 16965680
20:45:55 5068 8192000000 10925747728 11344076800 1949570768 19.223 100 67 134 3 2005650256 35881056 20198432
20:46:10 3218 8192000000 10925201088 11342749696 1951134352 19.236 100 87 173 1 2016299904 39380800 25784752
20:46:20 2336 8192000000 10913042624 11318910976 1936840176 19.122 99 84 169 1 1996990032 34292000 25857856
20:46:30 2936 8192000000 10922323856 11336708096 1937954688 19.130 99 79 158 1 1997820192 36170736 23694768
20:46:40 3649 8192000000 10901476096 11316121600 1929411856 19.062 100 67 134 0 1984131152 34767456 19951840
20:46:53 6168 8192000000 10864833760 11281010688 1898969856 18.818 99 60 116 2 1952060160 35069888 18020416
20:47:07 6609 8192000000 10904430960 11321233408 1930027232 19.067 100 61 120 0 1985598672 37520432 18051008
20:47:25 7357 8192000000 10892395744 11302907904 1917503888 18.967 100 73 145 0 1980042688 39493568 23045232
20:47:41 9363 8192000000 10923571264 11329695744 1936202880 19.116 100 75 150 0 2001826304 42960496 22662928
20:48:00 2695 8192000000 10937758832 11346145280 1942909136 19.170 100 77 155 1 2013936672 48012512 23015024
20:48:10 7475 8192000000 10915239408 11334340608 1932496656 19.087 100 68 136 0 2000462416 46202224 21763536
20:48:25 6227 8192000000 10872731744 11295649792 1880153488 18.666 97 55 110 0 1942077472 43975824 17948160
20:48:40 7591 8192000000 10896061872 11313246208 1922031808 19.003 100 66 132 3 1988132672 45238096 20862768
20:49:02 5354 8192000000 10887295376 11303661568 1903361584 18.853 99 54 106 1 1966918208 45932928 17623696
20:49:17 3892 8192000000 10923209648 11329425408 1933540912 19.095 100 73 141 1 2000986000 43803904 23641184
20:49:29 3570 8192000000 10941805600 11346378752 1945984416 19.194 100 75 148 0 2016268096 45445776 24837904
20:49:41 3529 8192000000 10947355968 11358248960 1957146976 19.283 100 85 167 3 2029789744 46189472 26453296
20:49:51 5338 8192000000 10931356768 11357376512 1955183712 19.268 100 71 142 0 2026907216 49203216 22520288
20:50:05 15015 8192000000 10918609248 11358932992 1949756560 19.225 100 41 82 2 2010283264 46969728 13556976
20:50:31 6229 8192000000 10928104016 11364720640 1961839216 19.321 100 40 80 1 2018307056 42872080 13595760
20:50:52 3505 8192000000 10952532560 11373252608 1967669328 19.367 100 52 104 0 2029125872 44337328 17119216
20:51:02 6727 8192000000 10930516144 11365765120 1955239296 19.268 99 51 102 0 2020551056 48311648 17000112
20:51:21 7023 8192000000 10931859680 11359252480 1952461200 19.246 99 45 87 1 2017778896 49636112 15681584
20:51:38 6007 8192000000 10967210912 11390697472 1974781568 19.423 100 58 116 0 2050082416 56444656 18856192
20:51:56 10923 8192000000 10947816496 11386634240 1971962272 19.401 100 36 72 0 2032923312 48765664 12195376
20:52:16 8201 8192000000 10947505888 11386109952 1971490176 19.397 100 53 104 1 2038835984 50951456 16394352
20:52:36 12451 8192000000 10928571920 11363373056 1954441984 19.262 99 39 78 4 2016361200 48320704 13598512
20:53:14 15008 8192000000 10941830192 11393298432 1975908144 19.432 100 33 66 0 2035582560 48917184 10757232
20:53:36 7148 8192000000 10959475424 11392065536 1981789552 19.479 100 48 94 1 2040348432 43147648 15411232
20:53:50 19209 8192000000 10964020304 11405197312 1983925872 19.496 100 37 74 0 2042792288 46314848 12551568
20:54:33 7927 8192000000 10981209344 11412996096 1983776288 19.495 100 54 107 1 2058604304 56888496 17939520
20:54:47 9526 8192000000 10964223680 11398459392 1965775856 19.352 99 47 94 1 2035863664 54220192 15867616
20:55:04 10241 8192000000 10972806448 11409403904 1984152512 19.498 100 47 92 0 2057107680 56122320 16832848
20:55:21 6991 8192000000 10973816464 11416944640 1986042816 19.513 100 38 76 0 2059144432 59742976 13358640
20:56:02 8946 8192000000 10950285200 11405291520 1976219376 19.435 100 39 78 1 2042661408 52655616 13786416
20:56:23 7398 8192000000 10947561888 11398148096 1975546704 19.429 100 32 64 2 2034829472 47834512 11448256
20:57:41 33250 8192000000 10932990592 11393372160 1966629152 19.359 100 22 44 1 2012748160 38885504 7233504
20:58:24 37311 8192000000 10923789056 11381125120 1948504672 19.215 99 22 43 2 1993944944 38379984 7060288
20:59:10 34148 8192000000 10932129344 11397210112 1955632880 19.271 100 16 32 0 2011559488 50179040 5747568
20:59:51 12975 8192000000 10924338896 11409018880 1959197792 19.300 100 9 18 0 2008827088 46557248 3072048
21:00:12 9241 8192000000 10925176048 11383525376 1963250704 19.332 100 20 38 1 2006270192 36916368 6103120
21:00:30 52655 8192000000 10873788992 11322466304 1845963456 18.389 94 3 6 0 1856459920 10068352 428112
21:01:46 36006 8192000000 10897888496 11342340096 1959661744 19.303 100 51 102 1 1985042720 9789136 15591840
21:02:29 32716 8192000000 10912213280 11351175168 1961760096 19.320 100 17 34 2 1978501648 12380592 4360960
21:03:09 59186 8192000000 10912055984 11350691840 1951613024 19.239 99 18 36 1 1963862880 7723648 4526208
21:04:18 32447 8192000000 10916260768 11356200960 1942628192 19.168 98 31 63 1 1960602448 9535504 8438752
21:04:59 94033 8192000000 10922410352 11372859392 1977536928 19.445 100 12 24 0 1993318112 12187408 3593776
21:06:40 143635 8192000000 10916370896 11387195392 1966646736 19.359 99 10 19 2 1985942240 16545632 2749872
21:09:10 59008 8192000000 10939124176 11380686848 1961883888 19.321 98 33 66 1 1981027008 9026976 10116144
21:10:21 68889 8192000000 10917483312 11370446848 1957498192 19.286 98 30 60 1 1976019264 9106576 9414496
21:11:58 74508 8192000000 10914920736 11368112128 1965616592 19.351 99 39 77 0 1984127632 6893632 11617408
21:13:21 116263 8192000000 10893741136 11362238464 1908232528 18.892 96 32 64 1 1925827616 9154944 8440144
21:15:23 45153 8192000000 10928034896 11369226240 1946471120 19.198 98 28 56 3 1962945696 7783088 8691488
21:16:19 36733 8192000000 10926389312 11385737216 1973526240 19.413 99 30 60 2 1997219008 14723376 8969392
21:17:04 33952 8192000000 10937068720 11399352320 1998238208 19.609 100 39 74 2 2025856496 16218848 11399440
21:17:45 52230 8192000000 10924695184 11398090752 1964212944 19.340 98 21 43 1 1985143664 14226928 6703792
21:18:50 33837 8192000000 10919455440 11396259840 1974697072 19.423 99 14 28 0 1998285696 19005024 4583600
21:20:24 134636 8192000000 10878538336 11357671424 1853928560 18.454 93 11 22 1 1867372480 10061856 3382064
21:22:52 15252 8192000000 10900305824 11363319808 1950125216 19.227 99 25 50 0 1971525408 13539872 7860320
21:23:14 31767 8192000000 10871518656 11357683712 1943592000 19.175 99 14 28 0 1967064480 19436080 4036400
21:23:52 30318 8192000000 10886322976 11362316288 1932571952 19.087 99 8 16 0 1954417360 19744656 2100752
21:24:30 52444 8192000000 10890243872 11358793728 1925027520 19.027 98 9 18 1 1942161424 14719280 2414624
21:25:30 27751 8192000000 10895387696 11360280576 1950310752 19.229 99 25 50 3 1964789296 7456144 7022400
21:26:04 51884 8192000000 10876772064 11350769664 1905150288 18.868 97 12 24 0 1917022320 8247376 3624656
21:27:07 37378 8192000000 10903017136 11355910144 1929627824 19.064 98 25 50 0 1946932656 9936656 7368176
21:27:50 60003 8192000000 10853552688 11311198208 1863314336 18.530 95 22 44 1 1878454512 9535216 5604960
21:29:07 60616 8192000000 10853511504 11318308864 1890473472 18.750 97 19 38 0 1904478240 8600016 5404752
21:30:14 53151 8192000000 10860097760 11324432384 1884921536 18.705 97 13 26 0 1900514832 11961872 3631424
21:31:13 68495 8192000000 10871596160 11331846144 1871637392 18.598 96 15 30 1 1883764016 8117808 4008816
21:32:28 45846 8192000000 10894327136 11353092096 1933753600 19.097 99 12 24 1 1949813776 12194624 3865552
21:33:29 38197 8192000000 10871679216 11336019968 1911929648 18.922 98 18 36 2 1927203696 10371120 4902928
21:34:13 37490 8192000000 10895539888 11326406656 1885417232 18.709 97 35 68 1 1903786800 8819776 9549792
21:34:57 6448 8192000000 10896729536 11324866560 1920810480 18.993 99 70 139 2 1949124640 8956272 19357888
21:35:10 19877 8192000000 10877096064 11324370944 1907607744 18.887 98 51 102 2 1934718480 12703840 14406896
21:35:38 64616 8192000000 10868396768 11326619648 1880070416 18.666 97 23 44 2 1897680624 11151664 6458544
21:36:52 39491 8192000000 10904224176 11349164032 1928723824 19.057 99 19 38 2 1946158848 12305296 5129728
21:37:39 114224 8192000000 10874565264 11343437824 1931850896 19.082 99 13 26 0 1949722720 13973664 3898160
21:39:48 41259 8192000000 10877249520 11330535424 1916752224 18.961 98 53 106 2 1939155536 7445504 14957808
21:40:37 59357 8192000000 10864103840 11325120512 1885647104 18.711 97 22 44 0 1900509184 7943600 6918480
21:43:08 35077 8192000000 10858622368 11325702144 1912822784 18.929 98 23 46 0 1927746368 8144000 6779584
21:43:53 67536 8192000000 10851803280 11327979520 1908611440 18.895 98 15 30 0 1920011648 7403744 3996464
21:45:07 47220 8192000000 10847761840 11335688192 1906019872 18.875 98 14 28 1 1919476944 8807488 4649584
21:46:05 28191 8192000000 10836692416 11305811968 1864615280 18.541 96 17 34 1 1877289200 7679552 4994368
21:46:42 66376 8192000000 10845650848 11319910400 1894826096 18.785 98 11 22 1 1906816496 8162944 3827456
21:49:56 33922 8192000000 10862375360 11337584640 1914494032 18.943 98 16 33 1 1925600592 6362400 4744160
21:50:36 24111 8192000000 10885199456 11346939904 1933009808 19.091 99 48 94 0 1953705728 7445872 13250048
21:51:07 41767 8192000000 10891848944 11362373632 1953231744 19.252 100 22 44 2 1966334080 7555216 5547120
21:51:55 62226 8192000000 10898926752 11369902080 1946468384 19.198 99 18 36 2 1964513840 12444928 5600528
21:53:06 86913 8192000000 10914177520 11400073216 1971408208 19.397 100 19 37 2 1993376640 16430432 5538000
21:55:02 87383 8192000000 10897077120 11382308864 1950434992 19.230 99 16 32 0 1975410160 20513184 4461984
21:56:36 42592 8192000000 10902021424 11371458560 1957562912 19.287 99 26 52 1 1979527264 14204784 7759568
21:57:25 75916 8192000000 10926261600 11404066816 1962313152 19.324 99 23 46 2 1988799808 20020976 6465680
21:58:48 61132 8192000000 10888694800 11350114304 1875593232 18.630 95 12 24 1 1894628432 15374672 3660528
22:00:00 77520 8192000000 10901328736 11373170688 1902194112 18.844 97 20 40 1 1923132752 15894048 5044592
22:02:35 89781 8192000000 10890217360 11354869760 1869474176 18.580 95 12 24 0 1881886832 8829408 3583248
22:04:16 92213 8192000000 10893686832 11357204480 1944769744 19.185 99 25 50 0 1961211216 9681152 6760320
22:06:26 69120 8192000000 10886835392 11358945280 1931133968 19.076 98 12 23 2 1946121344 11538320 3449056
22:07:48 28216 8192000000 10875265440 11361144832 1936832224 19.121 99 7 14 0 1954287024 15423328 2031472
22:08:24 11306 8192000000 10877329504 11362021376 1950350192 19.229 100 9 17 0 1970276544 17214512 2711840
22:08:48 38110 8192000000 10872222112 11345035264 1926406224 19.038 99 8 16 0 1943820480 15128256 2286000
22:09:32 115652 8192000000 10884104112 11374116864 1932699232 19.088 99 9 18 0 1952756560 17240352 2816976
22:12:09 66193 8192000000 10866038880 11341795328 1882557584 18.686 96 16 32 3 1901559040 14538960 4462496
22:13:21 55214 8192000000 10855087616 11330215936 1886657344 18.719 97 27 53 1 1906316336 11845744 7813248
22:14:23 99268 8192000000 10870912960 11336847360 1887770400 18.728 97 26 53 0 1911887488 15726784 8390304
22:16:33 85378 8192000000 10870240592 11345530880 1881912128 18.681 97 10 20 0 1900949920 16510720 2527072
22:18:34 92499 8192000000 10853681200 11338887168 1842179552 18.359 95 14 28 0 1866553456 19553712 4820192
22:21:16 39133 8192000000 10879409072 11337662464 1906899344 18.882 98 31 62 2 1926957856 11681152 8377360
22:22:05 31280 8192000000 10874137136 11326799872 1887875120 18.729 97 54 108 1 1915549696 12084032 15590544
22:23:33 48300 8192000000 10870561680 11323883520 1874876752 18.624 97 35 70 2 1896307296 11280976 10149568
22:24:33 33203 8192000000 10891501808 11336974336 1927784208 19.049 100 46 92 1 1955235008 14693552 12757248
22:25:16 35440 8192000000 10873806288 11341316096 1934929024 19.106 100 43 85 2 1963468528 16592848 11946656
22:26:04 76685 8192000000 9153675968 9387356160 305444704 3.594 17 3 6 0 308176736 2157936 574096

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 22:28:09 to 20-01-2021 22:28:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 111 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-01-2021 22:28:42 to 20-01-2021 22:28:44.

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          248057
MON$OLDEST_ACTIVE               248058
MON$OLDEST_SNAPSHOT             248058
MON$NEXT_TRANSACTION            248058
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                       2054112
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 ---
:156: 
:157: mscs-test-161.budzdorov.ru    Wed Jan 20 22:27:22 2021
:158:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:159: 
--- end of diff output ---

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

20.01.21 22:28:45. 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 22:28:47 No severe PSQL-related problems occured
20.01.21 22:28:49. End of report.