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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17567064 kB
MemAvailable 31523840 kB
Buffers 0 kB
Cached 14154260 kB
SwapCached 3696 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 2020-12-20 22:27:08
DTS_END                         2020-12-20 22:27:08.6500
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(50:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/32922
TRN_ID                          250467
ATT_ID                          663
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: 9487.45 16194 1138494
customer order: creation 182.48 360 21898
customer order: refuse 15.67 251 1880
order to supplier: creation 48.97 1105 5876
order to supplier: removal 3.61 71816 433
invoice (draft): creation 47.70 2940 5724
invoice (draft): removal 53.08 572 6369
invoice accept: apply 43.84 15959 5261
invoice accept: cancel 47.98 664 5758
customer reserve: creation 4033.68 160 484042
customer reserve: removal 4701.94 44 564233
realization accept: apply 87.31 146 10477
realization accept: cancel 83.28 95 9994
payment from customer: creation 63.88 92 7665
payment from customer: removal 6.23 41 748
payment to supplier: creation 51.98 96 6237
payment to supplier: removal 3.67 50 440
service: total inventory turnovers 4.86 1016 583
service: total monetary turnovers 6.25 38 750
service: aggregate perf. data 1.02 14497 122
service: refresh index statistics 0.03 213939 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-12-2020 22:28:51 to 20-12-2020 22:28:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5221
TEST_TIME 2 6890
TEST_TIME 3 7303
TEST_TIME 4 7330
TEST_TIME 5 6778
TEST_TIME 6 7213
TEST_TIME 7 7551
TEST_TIME 8 7835
TEST_TIME 9 8199
TEST_TIME 10 8236
TEST_TIME 11 9152
TEST_TIME 12 9726
TEST_TIME 13 9916
TEST_TIME 14 10226
TEST_TIME 15 10572
TEST_TIME 16 11013
TEST_TIME 17 11038
TEST_TIME 18 11378
TEST_TIME 19 11724
TEST_TIME 20 12310
TEST_TIME 21 12629
TEST_TIME 22 12321
TEST_TIME 23 12131
TEST_TIME 24 11897
TEST_TIME 25 11536
TEST_TIME 26 11296
TEST_TIME 27 11295
TEST_TIME 28 11162
TEST_TIME 29 10967
TEST_TIME 30 10827
TEST_TIME 31 10622
TEST_TIME 32 10441
TEST_TIME 33 10607
TEST_TIME 34 10583
TEST_TIME 35 10424
TEST_TIME 36 10489
TEST_TIME 37 10429
TEST_TIME 38 10267
TEST_TIME 39 10321
TEST_TIME 40 10281
TEST_TIME 41 10534
TEST_TIME 42 10449
TEST_TIME 43 10445
TEST_TIME 44 10435
TEST_TIME 45 10488
TEST_TIME 46 10435
TEST_TIME 47 10342
TEST_TIME 48 10489
TEST_TIME 49 10425
TEST_TIME 50 10397
TEST_TIME 51 10204
TEST_TIME 52 10057
TEST_TIME 53 10049
TEST_TIME 54 9998
TEST_TIME 55 9945
TEST_TIME 56 9905
TEST_TIME 57 9835
TEST_TIME 58 9803
TEST_TIME 59 9791
TEST_TIME 60 9800
TEST_TIME 61 9787
TEST_TIME 62 9861
TEST_TIME 63 9803
TEST_TIME 64 9867
TEST_TIME 65 9892
TEST_TIME 66 10013
TEST_TIME 67 10031
TEST_TIME 68 10080
TEST_TIME 69 9982
TEST_TIME 70 9969
TEST_TIME 71 10088
TEST_TIME 72 10109
TEST_TIME 73 10042
TEST_TIME 74 9990
TEST_TIME 75 9917
TEST_TIME 76 9902
TEST_TIME 77 9883
TEST_TIME 78 9788
TEST_TIME 79 9803
TEST_TIME 80 9726
TEST_TIME 81 9719
TEST_TIME 82 9758
TEST_TIME 83 9796
TEST_TIME 84 9773
TEST_TIME 85 9739
TEST_TIME 86 9777
TEST_TIME 87 9792
TEST_TIME 88 9833
TEST_TIME 89 9884
TEST_TIME 90 9851
TEST_TIME 91 9905
TEST_TIME 92 9884
TEST_TIME 93 9904
TEST_TIME 94 9866
TEST_TIME 95 9923
TEST_TIME 96 9842
TEST_TIME 97 9787
TEST_TIME 98 9722
TEST_TIME 99 9735
TEST_TIME 100 9681
TEST_TIME 101 9616
TEST_TIME 102 9609
TEST_TIME 103 9621
TEST_TIME 104 9599
TEST_TIME 105 9581
TEST_TIME 106 9619
TEST_TIME 107 9612
TEST_TIME 108 9584
TEST_TIME 109 9597
TEST_TIME 110 9610
TEST_TIME 111 9588
TEST_TIME 112 9639
TEST_TIME 113 9610
TEST_TIME 114 9599
TEST_TIME 115 9663
TEST_TIME 116 9681
TEST_TIME 117 9653
TEST_TIME 118 9597
TEST_TIME 119 9565
TEST_TIME 120 9488

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-12-2020 22:28:55 to 20-12-2020 22:28:58.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1587202 1587202 0 0.00 0 13893 5 0 0
doc_list_biud 1587202 1587202 0 0.00 0 47730 20 0 0
sp_add_invoice_to_stock 5411 5261 150 2.77 23 145889 15959 0 150
sp_cancel_adding_invoice 5758 5758 0 0.00 5 70238 664 0 0
sp_cancel_client_order 1880 1880 0 0.00 4 17834 251 0 0
sp_cancel_customer_reserve 564233 564233 0 0.00 1 47747 45 0 0
sp_cancel_pay_from_customer 748 748 0 0.00 2 2706 42 0 0
sp_cancel_pay_to_supplier 440 440 0 0.00 3 5977 51 0 0
sp_cancel_supplier_invoice 6381 6369 12 0.18 2 14705 573 0 12
sp_cancel_supplier_order 433 433 0 0.00 5 825198 71816 0 0
sp_cancel_write_off 9994 9994 0 0.00 1 7313 95 0 0
sp_client_order 21898 21898 0 0.00 3 77886 361 0 0
sp_customer_reserve 484042 484042 0 0.00 0 48857 160 0 0
sp_fill_shopping_cart 33489 33489 0 0.00 1 11562 34 0 0
sp_fill_shopping_cart_clo_res 484039 484039 0 0.00 0 20493 13 0 0
sp_get_clo_for_invoice 5258 5258 0 0.00 0 36329 340 0 0
sp_kill_cost_storno 16940 16940 0 0.00 0 7133 37 0 0
sp_kill_qstorno_ret_qs2qd 1145262 1145262 0 0.00 0 47726 24 0 0
sp_kill_qty_storno 604402 604402 0 0.00 0 47730 53 0 0
sp_lock_selected_doc 21825 21825 0 0.00 0 7716 4 0 0
sp_make_cost_storno 29637 29637 0 0.00 0 9184 42 0 0
sp_multiply_rows_for_pdistr 29637 29637 0 0.00 0 12147 24 0 0
sp_multiply_rows_for_qdistr 21898 21898 0 0.00 0 77878 185 0 0
sp_pay_from_customer 7665 7665 0 0.00 4 14572 93 0 0
sp_pay_to_supplier 6237 6237 0 0.00 4 14529 97 0 0
sp_payment_common 13902 13902 0 0.00 1 14515 26 0 0
sp_qd_handle_on_cancel_clo 1880 1880 0 0.00 0 17824 230 0 0
sp_qd_handle_on_invoice_upd_sts 11016 11016 0 0.00 0 25515 262 0 0
sp_qd_handle_on_reserve_upd_sts 10477 10477 0 0.00 0 14205 54 0 0
sp_reserve_write_off 10477 10477 0 0.00 7 14223 147 0 0
sp_supplier_invoice 5724 5724 0 0.00 6 87103 2941 0 0
sp_supplier_order 5876 5876 0 0.00 5 35129 1105 0 0
srv_aggregate_perf_data 122 122 0 0.00 2775 113698 14497 0 0
srv_fill_mon_cache_memory 140 140 0 0.00 1437 156431 38534 0 0
srv_find_qd_qs_mism 1088262 1088262 0 0.00 0 13891 5 0 0
srv_make_invnt_saldo 583 583 0 0.00 28 63529 1016 0 0
srv_make_money_saldo 750 750 0 0.00 0 13672 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 142304 421997 213939 0 0
t$perf-abend:sp_add_invoice_to_stock 150 150 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5261 5261 0 0.00 0 14646 142 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 0 8328 124 0 0
t$perf-norm:sp_cancel_client_order 1880 1880 0 0.00 0 6205 17 0 0
t$perf-norm:sp_cancel_customer_reserve 724 724 0 0.00 0 6563 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 748 748 0 0.00 0 3027 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 440 440 0 0.00 0 1824 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 2170 10 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 22009 1255 0 0
t$perf-norm:sp_cancel_write_off 1035 1035 0 0.00 0 3290 13 0 0
t$perf-norm:sp_client_order 21898 21898 0 0.00 0 13428 17 0 0
t$perf-norm:sp_customer_reserve 1077 1077 0 0.00 0 13423 21 0 0
t$perf-norm:sp_pay_from_customer 7665 7665 0 0.00 0 6775 9 0 0
t$perf-norm:sp_pay_to_supplier 6237 6237 0 0.00 0 8320 10 0 0
t$perf-norm:sp_reserve_write_off 10477 10477 0 0.00 0 13434 16 0 0
t$perf-norm:sp_supplier_invoice 5724 5724 0 0.00 0 9490 17 0 0
t$perf-norm:sp_supplier_order 5876 5876 0 0.00 0 7377 15 0 0
t$perf-norm:srv_aggregate_perf_data 122 122 0 0.00 0 150 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 140 140 0 0.00 0 329 3 0 0
t$perf-norm:srv_make_invnt_saldo 583 583 0 0.00 0 2043 14 0 0
t$perf-norm:srv_make_money_saldo 750 750 0 0.00 0 3300 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 14 6 0 0
v_add_invoice_to_stock 10816 10516 300 2.77 0 6921 17 0 300
v_all_customers 40250 40250 0 0.00 0 24 0 0 0
v_all_suppliers 31928 31928 0 0.00 0 51 1 0 0
v_all_wares 43796 43796 0 0.00 0 470 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 655 6 0 0
v_cancel_client_order 3760 3760 0 0.00 0 2226 3 0 0
v_cancel_customer_prepayment 1496 1496 0 0.00 0 2671 4 0 0
v_cancel_customer_reserve 1448 1448 0 0.00 0 2263 6 0 0
v_cancel_payment_to_supplier 880 880 0 0.00 0 1385 5 0 0
v_cancel_supplier_invoice 852 828 24 2.81 0 242 12 0 24
v_cancel_supplier_order 866 866 0 0.00 0 1759 4 0 0
v_cancel_write_off 2070 2070 0 0.00 0 2171 12 0 0
v_max_id_clo_ord 5874 5874 0 0.00 0 300 1 0 0
v_max_id_clo_res 1077 1077 0 0.00 0 1452 12 0 0
v_max_id_ord_sup 5717 5717 0 0.00 0 6803 7 0 0
v_max_non_paid_invoice 1864 1864 0 0.00 0 515 2 0 0
v_max_non_paid_realizn 4003 4003 0 0.00 0 4408 5 0 0
v_min_id_clo_ord 5874 5874 0 0.00 0 2340 5 0 0
v_min_id_clo_res 1077 1077 0 0.00 0 6685 11 0 0
v_min_id_ord_sup 5717 5717 0 0.00 0 6904 10 0 0
v_min_non_paid_invoice 6237 6237 0 0.00 0 14506 16 0 0
v_min_non_paid_realizn 7665 7665 0 0.00 0 14509 18 0 0
v_our_firm 10870 10870 0 0.00 0 12 1 0 0
v_reserve_write_off 20952 20952 0 0.00 0 5525 4 0 0
x_lock_depdocs_on_canc_invoice 11713 11713 0 0.00 0 11445 94 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 7121 246 0 0
x_make_qstorno_1000_1200 5876 5876 0 0.00 2 35117 1039 0 0
x_make_qstorno_1200_2000 5724 5724 0 0.00 2 81225 2814 0 0
x_make_qstorno_2100_3300 484042 484042 0 0.00 0 40146 145 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:18 19650 8192000000 10239942720 10547445760 794188992 8.837 63 50 99 1 813827296 2275200 17363104
19:57:47 20465 8192000000 10342152688 10658906112 1383170640 14.445 100 84 167 1 1415477776 4516128 27791008
19:58:17 24247 8192000000 10366368688 10687619072 1419077184 14.765 100 87 174 0 1453639904 5878096 28684624
19:58:50 23693 8192000000 10386541536 10708742144 1443931408 14.984 100 92 184 1 1481238304 7139072 30167824
19:59:21 15675 8192000000 10399792144 10726465536 1449092432 15.030 100 87 174 2 1485979584 7820336 29066816
19:59:48 24721 8192000000 10440021712 10769776640 1480423312 15.305 100 88 176 1 1516912576 8252944 28236320
20:00:20 17523 8192000000 10443036384 10779615232 1501485824 15.489 100 89 178 1 1539261584 9232480 28543280
20:00:47 12446 8192000000 10462439472 10802921472 1518516000 15.637 100 82 164 1 1554541552 9637360 26388192
20:01:09 11498 8192000000 10491818896 10836475904 1551980816 15.927 100 87 172 1 1588944416 9697936 27265664
20:01:30 10762 8192000000 10519653200 10874265600 1570526864 16.087 100 71 142 0 1601998672 9450208 22021600
20:01:49 14720 8192000000 10547005920 10904956928 1603866960 16.372 100 75 150 1 1637010256 10253856 22889440
20:02:10 12100 8192000000 10568771472 10927120384 1629230976 16.588 100 83 166 0 1665278576 10940512 25107088
20:02:31 10131 8192000000 10595800928 10955280384 1653956368 16.798 100 88 176 3 1692265168 12064448 26244352
20:02:50 8271 8192000000 10615183328 10981281792 1672032144 16.950 100 80 160 0 1707946384 12391328 23522912
20:03:05 9365 8192000000 10627740512 10995625984 1684220656 17.053 100 79 158 0 1719532880 12386880 22925344
20:03:21 5040 8192000000 10637670944 11007635456 1700836640 17.192 100 83 166 4 1737529024 12766624 23925760
20:03:34 5059 8192000000 10664190800 11035217920 1718638688 17.341 100 79 157 1 1753513152 12277824 22596640
20:03:47 5782 8192000000 10677552560 11048361984 1733786544 17.467 100 83 166 2 1771330880 13925824 23618512
20:04:00 4976 8192000000 10685021920 11061391360 1746970432 17.576 100 87 170 1 1783346048 12955328 23420288
20:04:13 7660 8192000000 10691281888 11069988864 1754686448 17.640 100 77 153 2 1788853744 12638576 21528720
20:04:27 3298 8192000000 10712869776 11092357120 1771968336 17.783 100 86 172 0 1808782416 12738832 24075248
20:04:37 4900 8192000000 10719744000 11096305664 1780492288 17.854 100 85 169 0 1817522096 13239824 23789984
20:04:49 4458 8192000000 10719983312 11106181120 1789591088 17.928 100 81 162 1 1825135248 12760704 22783456
20:05:00 2344 8192000000 10721824704 11109277696 1793028896 17.957 100 80 158 0 1828883088 13251024 22603168
20:05:09 3111 8192000000 10745574928 11129520128 1806241472 18.065 100 87 174 0 1843941408 13026672 24673264
20:05:19 2136 8192000000 10745136736 11125387264 1811962864 18.112 100 90 180 1 1850412544 13172848 25276832
20:05:28 2818 8192000000 10758107984 11141693440 1814799120 18.135 100 85 171 2 1853573616 14677520 24096976
20:05:37 2493 8192000000 10759756320 11145445376 1822482272 18.198 100 92 184 0 1863480000 15136720 25861008
20:05:46 8455 8192000000 10746532912 11143323648 1824286512 18.213 100 77 154 1 1859408192 13467888 21653792
20:06:02 4087 8192000000 10773922640 11159715840 1830029008 18.260 100 83 164 0 1866697424 13444000 23224416
20:06:12 1838 8192000000 10791929248 11177897984 1849149200 18.415 100 85 171 2 1886381120 13394128 23837792
20:06:20 1911 8192000000 10799054064 11183636480 1857602704 18.484 100 95 189 1 1897112624 13312464 26197456
20:06:29 2567 8192000000 10804847264 11190980608 1859458240 18.499 100 95 190 0 1901056752 14204224 27394288
20:06:38 1434 8192000000 10802041776 11196514304 1859571680 18.500 100 88 172 1 1896402256 12863824 23966752
20:06:46 1535 8192000000 10814867520 11201179648 1863593584 18.532 100 94 188 2 1904396208 13662560 27140064
20:06:54 1285 8192000000 10811339344 11199127552 1868568912 18.573 100 93 187 1 1908399200 12704752 27125536
20:07:01 1457 8192000000 10818962928 11205189632 1866325936 18.555 100 92 184 1 1905488528 13167984 25994608
20:07:09 1446 8192000000 10816802912 11204927488 1870792864 18.591 100 95 192 2 1910657824 13139584 26725376
20:07:17 34812 8192000000 10793891504 11206217728 1864843072 18.543 100 53 106 5 1893328160 13229008 15256080
20:08:03 9860 8192000000 10779624384 11198717952 1869548960 18.581 100 27 54 5 1883950336 4320160 10081216
20:08:20 7230 8192000000 10789167056 11211300864 1869598400 18.581 100 29 58 2 1885530256 7695936 8235920
20:08:38 12777 8192000000 10775472976 11208921088 1871177520 18.594 100 14 28 1 1880623568 5236528 4209520
20:08:57 8093 8192000000 10790607072 11214716928 1876417568 18.636 100 22 45 1 1888706928 6305168 5984192
20:09:12 9137 8192000000 10781645088 11214012416 1875970976 18.633 100 20 37 2 1887341472 6088768 5281728
20:09:30 10580 8192000000 10793955792 11220037632 1878794640 18.655 100 23 46 1 1892008928 6566080 6648208
20:09:49 10832 8192000000 10785840240 11225391104 1883637104 18.694 100 20 40 1 1896920272 7688656 5594512
20:10:07 12907 8192000000 10796992384 11231256576 1888062960 18.730 100 20 40 2 1903941184 10499712 5378512
20:10:31 8388 8192000000 10809453952 11237445632 1894351232 18.781 100 31 60 1 1909617696 7073680 8192784
20:10:49 7455 8192000000 10812610384 11248812032 1895556144 18.791 100 28 54 3 1918282784 15354352 7372288
20:11:03 7479 8192000000 10797531472 11237138432 1892489904 18.766 100 3 6 0 1898993040 5267456 1235680
20:11:19 49521 8192000000 10819192832 11246710784 1900547648 18.831 100 31 62 0 1915162448 5278032 9336768
20:12:20 15554 8192000000 10858346144 11265810432 1911464064 18.918 100 62 125 2 1935692880 6117712 18111104
20:12:41 7918 8192000000 10809188416 11252273152 1903378528 18.853 100 20 40 0 1916176400 7296912 5500960
20:12:55 8094 8192000000 10830567584 11261313024 1905318064 18.869 100 24 48 1 1918063376 6120848 6624464
20:13:11 4225 8192000000 10837989808 11267444736 1913764448 18.937 100 35 70 0 1935495424 12576320 9154656
20:13:22 4636 8192000000 10831578032 11263361024 1911329728 18.917 100 33 66 2 1936335984 14798768 10207488
20:13:33 5070 8192000000 10826832320 11261136896 1912657584 18.928 100 23 46 0 1925331360 6513088 6160688
20:13:44 5715 8192000000 10830383744 11266912256 1911813616 18.921 100 29 59 1 1930824720 10291520 8719584
20:13:56 6256 8192000000 10823974080 11261915136 1910181856 18.908 100 31 63 1 1926426032 7169936 9074240
20:14:11 4941 8192000000 10831046208 11265220608 1914811184 18.945 100 35 70 3 1931814272 6200736 10802352
20:14:25 8786 8192000000 10833823136 11269488640 1916582528 18.959 100 30 58 2 1931298848 4910544 9805776
20:14:42 8755 8192000000 10823367872 11267190784 1915897824 18.954 100 23 46 2 1928219136 5760768 6560544
20:15:00 7049 8192000000 10834418528 11266682880 1912161296 18.924 100 18 35 3 1922936272 5910288 4864688
20:15:14 11837 8192000000 10822694384 11265830912 1917550032 18.967 100 23 46 1 1930560016 6444592 6565392
20:15:38 11616 8192000000 10801107248 11241496576 1872152272 18.602 98 23 44 1 1883502848 4907008 6443568
20:15:55 12451 8192000000 10784325472 11217551360 1777222592 17.827 93 26 53 1 1791153888 4726608 9204688
20:16:15 52638 8192000000 10793438864 11207794688 1801948240 18.030 95 42 84 1 1819921296 5743712 12229344
20:17:16 16704 8192000000 10762702640 11195314176 1810606944 18.101 97 20 40 5 1821434304 5262224 5565136
20:17:39 5516 8192000000 10741238112 11169574912 1779740128 17.847 96 22 42 4 1792897024 6249600 6907296
20:17:52 7028 8192000000 10718897296 11135987712 1766189776 17.736 96 19 36 2 1776893680 5116608 5587296
20:18:05 6255 8192000000 10710555296 11125735424 1764784160 17.724 97 22 44 0 1776633328 5676480 6172688
20:18:19 6121 8192000000 10684759456 11098132480 1715450272 17.314 95 21 42 1 1726674400 4865536 6358592
20:18:31 6603 8192000000 10689221008 11106189312 1688405872 17.088 94 24 49 0 1700792416 4673696 7712848
20:18:46 5105 8192000000 10723949856 11126272000 1759075824 17.677 98 26 52 4 1776057984 10051472 6930688
20:19:01 13580 8192000000 10694774240 11111317504 1696435744 17.155 94 18 36 1 1707441040 5552624 5452672
20:19:25 8672 8192000000 10732297680 11144884224 1806065936 18.064 100 27 54 3 1823757792 10023392 7668464
20:19:40 14361 8192000000 10712058000 11124592640 1746443520 17.572 96 26 50 2 1758965616 5484288 7037808
20:20:04 10638 8192000000 10708111504 11117441024 1753775952 17.633 97 20 40 0 1764936432 5096544 6063936
20:20:23 4654 8192000000 10739312432 11157884928 1814734864 18.135 100 23 46 1 1831661296 10177024 6749408
20:20:39 9294 8192000000 10725802416 11149635584 1785553728 17.895 98 12 24 2 1794140976 5139824 3447424
20:20:56 62739 8192000000 10736732736 11161370624 1810096544 18.097 99 26 53 2 1822729376 4636624 7996208
20:22:18 12205 8192000000 10747725472 11173195776 1814378848 18.132 99 18 35 1 1825146512 5727232 5040432
20:22:36 6462 8192000000 10759936304 11185963008 1846062544 18.390 100 33 62 2 1861188576 5553216 9572816
20:22:51 8682 8192000000 10771596336 11191320576 1849694464 18.420 100 22 44 1 1861267376 4661104 6911808
20:23:06 6795 8192000000 10762231952 11191463936 1853045984 18.447 100 30 58 1 1867719392 5945584 8727824
20:23:24 7661 8192000000 10767861184 11194937344 1854464672 18.458 100 27 54 2 1867995424 6028176 7502576
20:23:39 5532 8192000000 10774121328 11200786432 1860012592 18.503 100 25 50 1 1873303792 5849136 7442064
20:23:53 7646 8192000000 10775038576 11203776512 1860000320 18.503 100 13 26 1 1868925808 5505408 3420080
20:24:09 10492 8192000000 10772731472 11208650752 1866899344 18.559 100 22 43 2 1878927376 5703840 6324192
20:24:26 11752 8192000000 10783352784 11214024704 1873265408 18.611 100 16 32 1 1884065312 5749040 5050864
20:24:45 8481 8192000000 10798180832 11222503424 1880655008 18.670 100 16 32 0 1889896720 4800816 4440896
20:25:03 11673 8192000000 10803089456 11231899648 1879046832 18.657 100 17 34 3 1892821280 9185232 4589216
20:25:22 12754 8192000000 10789259696 11229261824 1881485056 18.677 100 15 29 1 1890973376 5479184 4009136
20:25:43 12475 8192000000 10810779792 11234013184 1886407152 18.717 100 30 59 1 1900882864 5232912 9242800
20:26:03 62492 8192000000 10808764032 11241377792 1891384720 18.757 100 16 32 2 1900101920 4605536 4111664
20:27:13 25138 8192000000 10830739232 11259281408 1909518640 18.903 100 26 51 2 1922211120 5547792 7144688
20:28:09 20635 8192000000 10861090016 11286724608 1928408880 19.054 100 36 70 2 1947864112 9680976 9774256
20:28:38 22104 8192000000 10886776704 11303931904 1941832048 19.161 100 59 119 2 1971283152 13243808 16207296
20:29:12 3565 8192000000 10888114816 11310559232 1950986704 19.234 100 56 110 5 1980399072 13556144 15856224
20:29:25 11072 8192000000 10889395408 11316457472 1954873744 19.265 100 49 99 2 1983490880 14492016 14125120
20:29:45 14390 8192000000 10897083712 11324923904 1961279936 19.316 100 57 113 2 1993473344 15175072 17018336
20:30:08 14957 8192000000 10902396784 11331170304 1962569968 19.326 100 38 76 1 1989560784 15792512 11198304
20:30:39 11098 8192000000 10909059520 11341459456 1972343632 19.404 100 48 94 0 2002242608 16324704 13574272
20:30:59 16434 8192000000 10917133248 11346096128 1976644816 19.438 100 49 98 1 2007753184 16662768 14445600
20:31:24 21541 8192000000 10916536608 11347697664 1981650128 19.478 100 47 93 0 2012106224 17007280 13448816
20:31:53 9918 8192000000 10928187664 11357679616 1987867280 19.527 100 55 109 1 2019733488 16313232 15552976
20:32:10 43597 8192000000 10938237312 11369353216 1989124848 19.537 100 51 101 2 2021412976 16948176 15339952
20:33:11 9364 8192000000 10932700096 11365154816 1989061456 19.536 100 42 84 0 2022378320 19847920 13468944
20:33:27 3717 8192000000 10943444320 11375267840 1997280848 19.601 100 58 116 1 2036154304 20836960 18036496
20:33:38 5027 8192000000 10947927152 11378810880 2000524384 19.627 100 59 118 0 2039338304 21361904 17452016
20:33:53 6035 8192000000 10952995184 11385516032 2002991856 19.646 100 55 107 1 2044317552 24908240 16417456
20:34:11 1986 8192000000 10964589904 11391721472 2011121152 19.710 100 76 151 4 2056582416 23720960 21740304
20:34:22 1636 8192000000 10966993184 11383791616 2005514192 19.666 100 64 126 1 2048215728 23714656 18986880
20:34:31 3101 8192000000 10957370672 11389607936 2006250192 19.672 100 66 132 1 2051510496 25234368 20025936
20:34:46 4654 8192000000 10959999440 11381936128 2002489664 19.642 100 69 136 0 2047349856 25096736 19763456
20:34:58 2155 8192000000 10975926464 11399335936 2007147648 19.679 100 75 150 0 2060576160 31250480 22178032
20:35:08 13079 8192000000 10962444720 11393851392 2007322608 19.680 100 65 131 2 2052840960 26439536 19078816
20:35:31 7142 8192000000 10959019264 11391242240 2005560800 19.667 100 68 135 0 2054589728 29017376 20011552
20:35:45 8722 8192000000 10954316208 11389874176 1986189920 19.514 99 51 100 1 2029647056 28021296 15435840
20:36:00 1659 8192000000 10969167456 11389083648 1986141552 19.513 99 88 179 1 2039350832 26716976 26492304
20:36:09 2731 8192000000 10952773168 11377311744 1991022800 19.552 100 71 141 3 2039030176 27109920 20897456
20:36:18 2327 8192000000 10968067120 11386253312 1999262208 19.617 100 91 184 4 2053702080 28238640 26201232
20:36:28 2909 8192000000 10955883616 11377152000 1986284128 19.514 100 75 149 1 2039100544 30482624 22333792
20:36:37 12305 8192000000 10962942448 11391971328 1997753104 19.605 100 76 152 3 2052505584 31238688 23513792
20:36:59 6873 8192000000 10954103104 11386658816 1992338016 19.562 100 66 132 1 2048479584 36491664 19649904
20:37:14 4601 8192000000 10955186736 11392847872 1996668048 19.596 100 58 116 1 2046738640 32235184 17835408
20:37:26 6837 8192000000 10985528336 11404001280 2003913600 19.654 100 72 146 0 2059998944 33515408 22569936
20:37:47 3801 8192000000 10971816784 11390943232 1979924480 19.464 99 76 150 2 2041831952 38691264 23216208
20:37:58 2576 8192000000 10957502944 11374002176 1963984304 19.338 99 83 164 1 2028968224 40482160 24501760
20:38:09 3464 8192000000 10952930544 11373219840 1976366880 19.436 100 79 158 0 2042958592 42336256 24255456
20:38:26 4997 8192000000 10952708096 11375980544 1980662144 19.470 100 74 144 1 2039603312 36060352 22880816
20:38:37 3929 8192000000 10925334192 11349803008 1947615152 19.207 99 64 128 2 2000298448 32490816 20192480
20:38:48 4604 8192000000 10904660400 11315662848 1910776784 18.913 98 79 159 2 1967637152 33032976 23827392
20:38:59 3772 8192000000 10912520448 11324588032 1921642576 19.000 98 78 157 0 1979225536 34627184 22955776
20:39:10 4851 8192000000 10927577744 11340791808 1948318176 19.213 100 79 158 2 2008005776 36150144 23537456
20:39:23 2585 8192000000 10894146128 11311976448 1924784768 19.025 99 66 132 1 1982143296 36352112 21006416
20:39:35 6108 8192000000 10880385056 11295879168 1869245248 18.578 97 64 127 1 1922973760 33841952 19886560
20:39:50 11761 8192000000 10834605168 11273158656 1851510480 18.434 97 45 90 2 1901667120 35069712 15086928
20:40:15 5416 8192000000 10867028800 11294228480 1902634432 18.847 100 41 80 5 1952425776 36474768 13316576
20:40:29 4281 8192000000 10893207888 11315556352 1923292160 19.013 100 60 120 1 1983544208 42076432 18175616
20:40:40 9328 8192000000 10882718896 11304562688 1903402736 18.854 99 53 105 0 1956404000 36299984 16701280
20:40:58 2003 8192000000 10901610672 11307282432 1917545360 18.967 99 79 160 3 1977615680 35723968 24346352
20:41:07 1436 8192000000 10936149664 11339571200 1943882272 19.178 100 98 196 1 2014105936 40985504 29238160
20:41:16 2522 8192000000 10925837216 11345371136 1949991360 19.226 100 70 140 2 2013236592 42229568 21015664
20:41:27 11253 8192000000 10906842896 11347976192 1952332560 19.245 100 41 82 1 2000727008 36040048 12354400
20:41:46 6543 8192000000 10911186928 11343294464 1948851216 19.217 100 41 82 1 1996557728 35313872 12392640
20:41:59 7356 8192000000 10905299104 11339993088 1939175504 19.140 100 45 90 2 1992854976 39715696 13963776
20:42:25 6928 8192000000 10896725744 11333918720 1930855696 19.074 100 43 86 1 1982433472 38118016 13459760
20:42:42 15300 8192000000 10900689824 11351588864 1941554960 19.159 100 26 52 2 1993316448 42972752 8788736
20:43:16 20154 8192000000 10894604528 11340562432 1902019600 18.843 98 25 50 2 1951522112 41093312 8409200
20:44:18 17432 8192000000 10887810272 11330322432 1909192528 18.900 99 28 56 0 1962524992 42792192 10540272
20:44:44 19056 8192000000 10901249536 11344281600 1932633904 19.088 100 32 63 1 1984023344 41302928 10086512
20:45:09 31412 8192000000 10888663728 11338162176 1918671968 18.976 99 24 48 1 1970471536 44132592 7666976
20:45:47 27245 8192000000 10850418320 11294068736 1859421360 18.499 96 21 42 3 1899704976 33728256 6555360
20:46:21 35953 8192000000 10851851120 11295887360 1839634240 18.338 96 17 34 0 1881036272 34932160 6469872
20:47:07 35778 8192000000 10854828128 11305332736 1869539600 18.581 98 20 40 0 1909658352 33458560 6660192
20:47:51 40708 8192000000 10831606608 11291447296 1871871200 18.599 98 21 43 0 1903548384 25329472 6347712
20:48:58 26344 8192000000 10839391680 11291086848 1915542224 18.951 100 30 57 0 1934191616 10182800 8466592
20:49:33 48327 8192000000 10871765104 11304382464 1893117216 18.771 98 32 64 0 1917981328 15377488 9486624
20:50:29 68251 8192000000 10863875216 11320668160 1929737488 19.065 100 27 54 0 1952264656 15417408 7109760
20:51:46 49925 8192000000 10883047168 11325132800 1928898704 19.058 99 24 47 0 1945129136 9920192 6310240
20:52:42 156431 8192000000 10862654256 11334414336 1912949728 18.930 98 21 42 0 1929444480 10441984 6052768
20:55:26 43752 8192000000 10881946704 11337789440 1936841424 19.122 99 22 41 0 1948128192 6040672 5246096
20:56:16 37076 8192000000 10893164608 11350016000 1950407568 19.230 99 38 75 3 1968361248 7403152 10550528
20:57:05 52068 8192000000 10907875440 11369197568 1977777136 19.447 100 13 26 1 1992438032 10429072 4231824
20:58:57 64393 8192000000 10928501216 11381374976 1976766288 19.439 99 24 48 1 2001897280 18180080 6950912
21:00:08 80354 8192000000 10920331984 11404763136 1993764672 19.574 100 18 36 0 2022577776 23321136 5491968
21:01:34 22714 8192000000 10917740896 11392978944 1993561536 19.572 100 7 15 0 2015911792 20198576 2151680
21:02:44 56644 8192000000 10909091536 11391770624 1971240016 19.395 99 9 18 0 1985767792 12405792 2121984
21:03:58 31461 8192000000 10930703744 11389419520 2000184464 19.624 100 17 34 0 2012029872 6614368 5231040
21:04:36 54279 8192000000 10930067712 11399245824 2004608624 19.659 100 13 26 2 2015759536 7760640 3390272
21:05:47 28144 8192000000 10949255648 11411120128 2015648272 19.746 100 46 92 3 2044340576 14792656 13899648
21:06:24 79286 8192000000 10948645520 11419877376 1990474560 19.548 99 22 44 1 2010517264 13759152 6283552
21:07:54 84512 8192000000 10936079344 11420626944 1993480208 19.571 99 13 26 1 2013484288 15951808 4052272
21:09:25 65813 8192000000 10942655120 11403333632 1988347536 19.531 99 21 42 0 2006160576 12268032 5545008
21:10:37 60590 8192000000 10955038048 11419930624 2011190464 19.711 100 28 56 1 2033456080 14477680 7787936
21:11:58 78474 8192000000 10923063600 11392913408 1951638224 19.240 97 17 34 2 1966595408 9868016 5089168
21:13:25 31640 8192000000 10938413456 11395039232 1983491504 19.492 99 35 70 3 2003541264 9436560 10613200
21:14:04 32423 8192000000 10939765376 11391713280 1959373840 19.301 98 34 68 0 1978725200 9577536 9773824
21:14:43 34690 8192000000 10936767520 11400847360 1986049920 19.513 99 41 82 0 2011274384 13996928 11227536
21:15:30 141865 8192000000 10905660384 11376979968 1832795120 18.282 92 3 6 0 1846499744 13100048 604576
21:18:20 101022 8192000000 10898635808 11371294720 1957980192 19.290 99 26 52 0 1976951104 11516448 7454464
21:20:08 56325 8192000000 10897553536 11376332800 1978345632 19.452 100 27 54 0 1997469472 11253392 7870448
21:21:13 72339 8192000000 10900944992 11382820864 1968699264 19.375 99 8 16 1 1981753632 10622224 2432144
21:22:54 56918 8192000000 10872245840 11342286848 1921569344 18.999 98 9 18 0 1933122960 8611904 2941712
21:24:06 59625 8192000000 10862301616 11332292608 1882465424 18.685 96 21 42 0 1905562112 17927248 5169440
21:25:12 56120 8192000000 10839907824 11295268864 1845146864 18.383 95 18 36 0 1858766688 8456208 5163616
21:26:50 61900 8192000000 10846523600 11290329088 1803188240 18.040 93 22 43 1 1815877184 7065072 5623872
21:27:58 33168 8192000000 10836965600 11296153600 1897790176 18.809 98 28 56 0 1913246576 8134672 7321728
21:28:42 74703 8192000000 10875422368 11334197248 1913856272 18.938 99 17 34 1 1930357696 11642160 4859264
21:30:04 42031 8192000000 10867857152 11330285568 1925125216 19.028 99 19 38 0 1941499616 11154176 5220224
21:30:52 65770 8192000000 10880014592 11339919360 1900746464 18.832 97 23 46 3 1921562832 14263760 6552608
21:33:19 87489 8192000000 10833301360 11294797824 1796319472 17.984 93 16 32 1 1810711472 10102464 4289536
21:34:54 64052 8192000000 10825820368 11293351936 1830658512 18.265 96 15 30 1 1852286752 17693344 3934896
21:36:50 38615 8192000000 10878466944 11318050816 1908275840 18.893 100 42 84 1 1934166192 14656928 11233424
21:37:36 62025 8192000000 10855372480 11314216960 1862994144 18.528 97 37 74 0 1893279744 20403520 9882080
21:38:44 80365 8192000000 10864810128 11326775296 1906347328 18.877 99 16 31 0 1926275920 15726912 4201680
21:40:11 112916 8192000000 10872081840 11333210112 1930729072 19.073 100 22 44 1 1945157968 8087504 6341392
21:42:10 62864 8192000000 10873606592 11328532480 1901832784 18.841 98 33 66 0 1921105696 10499728 8773184
21:43:20 1600 8192000000 10874791776 11327651840 1936995616 19.123 100 36 72 0 1961603776 14078944 10529216
21:43:28 38280 8192000000 10844524544 11322191872 1897326000 18.805 98 27 52 1 1917510480 12412336 7772144
21:44:13 30574 8192000000 10831689408 11309547520 1884571856 18.702 98 9 16 0 1898850080 12031520 2246704
21:44:51 35752 8192000000 10840925920 11317506048 1906497040 18.879 99 7 13 0 1920312800 11889520 1926240
21:45:33 47505 8192000000 10858102960 11331579904 1932257456 19.085 100 9 18 0 1949049280 13831696 2960128
21:46:27 39428 8192000000 10867992688 11342536704 1945086128 19.187 100 11 23 1 1960987360 12422320 3478912
21:47:13 77108 8192000000 10899940528 11374198784 1960613776 19.311 100 22 44 2 1978867584 11523200 6730608
21:48:43 85983 8192000000 10886271280 11373764608 1951164704 19.236 99 14 28 0 1974184224 18821824 4197696
21:50:20 50967 8192000000 10899772192 11371499520 1969200080 19.379 100 19 38 1 1985458240 11387104 4871056
21:51:17 61509 8192000000 10909153008 11377139712 1957766352 19.288 99 22 44 2 1978537520 14443360 6327808
21:52:30 63514 8192000000 10915363520 11395305472 1977417392 19.444 100 20 40 0 1998119312 14615184 6086736
21:54:08 57059 8192000000 10902194928 11368833024 1944764528 19.185 98 17 35 0 1963460720 13359040 5337152
21:55:12 65569 8192000000 10941318480 11394056192 1985157344 19.506 100 14 28 1 2000106288 10681600 4267344
21:56:25 93187 8192000000 10954262656 11401400320 1994635536 19.580 100 19 38 0 2018225312 17807824 5781952
21:58:04 39201 8192000000 10922866688 11399401472 1967117968 19.363 98 19 38 1 1981959664 9398752 5442944
21:59:04 95625 8192000000 10924966992 11399487488 1957351584 19.285 98 8 16 1 1970072928 10682736 2038608
22:00:57 48201 8192000000 10926063728 11387756544 1949894672 19.226 97 21 42 1 1973281424 16707792 6678960
22:01:51 89917 8192000000 10903707888 11393110016 1906792000 18.881 96 8 16 2 1925244016 16479904 1972112
22:04:03 81361 8192000000 10895866928 11367321600 1943608896 19.176 98 24 48 0 1958842800 7389936 7843968
22:05:30 35716 8192000000 10890523264 11364253696 1942700032 19.168 98 33 67 1 1960788608 8590944 9497632
22:07:16 61150 8192000000 10905750736 11386609664 1984436384 19.500 100 15 30 0 1997960816 9325616 4198816
22:08:45 74901 8192000000 10919331152 11392724992 1973567008 19.414 99 19 38 1 1993303952 13877536 5859408
22:10:19 78142 8192000000 10879559488 11357818880 1908124528 18.892 96 11 22 0 1922443168 10689760 3628880
22:11:49 34263 8192000000 10921431712 11381985280 1986815152 19.519 100 26 52 0 2001228000 7130560 7282288
22:12:29 33036 8192000000 10902966000 11379503104 1969087648 19.378 99 19 38 1 1983186624 9001536 5097440
22:13:17 87362 8192000000 10859354864 11333976064 1850103280 18.423 94 9 18 0 1862282720 9703568 2475872
22:14:50 39020 8192000000 10849997296 11291254784 1803153712 18.040 93 30 61 0 1820087328 8252688 8680928
22:15:37 72184 8192000000 10801819552 11265966080 1706870800 17.243 89 31 62 0 1724794768 8793312 9130656
22:16:55 51749 8192000000 10827414032 11296329728 1865328656 18.546 98 17 34 0 1880804048 10421824 5053568
22:17:53 41143 8192000000 10838551600 11285262336 1848645168 18.411 97 22 44 1 1863404784 7860128 6899488
22:18:42 66988 8192000000 10842954144 11311357952 1855165680 18.464 97 27 54 0 1873352064 10876400 7309984
22:20:52 34629 8192000000 10872646896 11325296640 1922345056 19.006 100 27 53 2 1942059296 11882080 7832160
22:21:38 74271 8192000000 10836849408 11311726592 1864405456 18.539 97 9 18 0 1886063680 18943536 2714688
22:23:07 67466 8192000000 10852007776 11328004096 1906978176 18.882 99 20 40 0 1921296416 8416928 5901312
22:24:21 110110 8192000000 10841217776 11298758656 1827983424 18.243 95 33 66 1 1845320288 8034384 9302480
22:26:46 38544 8192000000 9672159488 10007576576 814354240 9.041 43 5 10 0 821952688 6579840 1018608

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 20-12-2020 22:29:05 to 20-12-2020 22:29:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 150 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-12-2020 22:29:35 to 20-12-2020 22:29:37.

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          250371
MON$OLDEST_ACTIVE               250693
MON$OLDEST_SNAPSHOT             250693
MON$NEXT_TRANSACTION            250693
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                       2014656
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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    Sun Dec 20 22:27:36 2020
: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.12.20 22:29:38. 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
2020-12-20 22:29:40 No severe PSQL-related problems occured
20.12.20 22:29:42. End of report.