Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.01.2021 19: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 17127432 kB
MemAvailable 31431412 kB
Buffers 0 kB
Cached 14572404 kB
SwapCached 4864 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-02 19:27:09
DTS_END                         2021-01-02 19:27:09.4850
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38314
TRN_ID                          239711
ATT_ID                          683
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: 9395.20 20958 1127424
customer order: creation 170.50 353 20460
customer order: refuse 14.88 334 1785
order to supplier: creation 45.04 1286 5405
order to supplier: removal 3.58 104838 429
invoice (draft): creation 45.44 2995 5453
invoice (draft): removal 54.93 839 6591
invoice accept: apply 41.29 15462 4955
invoice accept: cancel 50.43 752 6051
customer reserve: creation 3796.14 153 455537
customer reserve: removal 4872.39 59 584687
realization accept: apply 82.73 180 9928
realization accept: cancel 88.40 107 10608
payment from customer: creation 58.92 106 7070
payment from customer: removal 5.71 56 685
payment to supplier: creation 48.92 112 5870
payment to supplier: removal 3.43 76 412
service: total inventory turnovers 4.65 1085 558
service: total monetary turnovers 6.88 27 825
service: aggregate perf. data 0.93 20980 111
service: refresh index statistics 0.03 269357 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-01-2021 19:28:41 to 02-01-2021 19:28:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6069
TEST_TIME 2 6241
TEST_TIME 3 5690
TEST_TIME 4 5427
TEST_TIME 5 5410
TEST_TIME 6 5220
TEST_TIME 7 5258
TEST_TIME 8 5505
TEST_TIME 9 5797
TEST_TIME 10 6405
TEST_TIME 11 6547
TEST_TIME 12 7143
TEST_TIME 13 7427
TEST_TIME 14 7872
TEST_TIME 15 7770
TEST_TIME 16 8045
TEST_TIME 17 8351
TEST_TIME 18 8717
TEST_TIME 19 9128
TEST_TIME 20 9117
TEST_TIME 21 9491
TEST_TIME 22 9678
TEST_TIME 23 9741
TEST_TIME 24 10460
TEST_TIME 25 11037
TEST_TIME 26 11340
TEST_TIME 27 10976
TEST_TIME 28 10981
TEST_TIME 29 11184
TEST_TIME 30 11001
TEST_TIME 31 10893
TEST_TIME 32 10752
TEST_TIME 33 10549
TEST_TIME 34 10474
TEST_TIME 35 10481
TEST_TIME 36 10306
TEST_TIME 37 10441
TEST_TIME 38 10402
TEST_TIME 39 10321
TEST_TIME 40 10208
TEST_TIME 41 10308
TEST_TIME 42 10206
TEST_TIME 43 10243
TEST_TIME 44 10184
TEST_TIME 45 10187
TEST_TIME 46 10264
TEST_TIME 47 10110
TEST_TIME 48 9906
TEST_TIME 49 9897
TEST_TIME 50 9853
TEST_TIME 51 9853
TEST_TIME 52 9752
TEST_TIME 53 9708
TEST_TIME 54 9660
TEST_TIME 55 9655
TEST_TIME 56 9871
TEST_TIME 57 9765
TEST_TIME 58 9686
TEST_TIME 59 9661
TEST_TIME 60 9531
TEST_TIME 61 9619
TEST_TIME 62 9592
TEST_TIME 63 9596
TEST_TIME 64 9562
TEST_TIME 65 9600
TEST_TIME 66 9606
TEST_TIME 67 9653
TEST_TIME 68 9699
TEST_TIME 69 9710
TEST_TIME 70 9675
TEST_TIME 71 9775
TEST_TIME 72 9784
TEST_TIME 73 9738
TEST_TIME 74 9806
TEST_TIME 75 9794
TEST_TIME 76 9778
TEST_TIME 77 9723
TEST_TIME 78 9645
TEST_TIME 79 9681
TEST_TIME 80 9636
TEST_TIME 81 9632
TEST_TIME 82 9572
TEST_TIME 83 9604
TEST_TIME 84 9587
TEST_TIME 85 9559
TEST_TIME 86 9500
TEST_TIME 87 9447
TEST_TIME 88 9447
TEST_TIME 89 9405
TEST_TIME 90 9393
TEST_TIME 91 9439
TEST_TIME 92 9471
TEST_TIME 93 9444
TEST_TIME 94 9499
TEST_TIME 95 9502
TEST_TIME 96 9565
TEST_TIME 97 9574
TEST_TIME 98 9604
TEST_TIME 99 9622
TEST_TIME 100 9607
TEST_TIME 101 9643
TEST_TIME 102 9652
TEST_TIME 103 9742
TEST_TIME 104 9707
TEST_TIME 105 9658
TEST_TIME 106 9589
TEST_TIME 107 9644
TEST_TIME 108 9583
TEST_TIME 109 9591
TEST_TIME 110 9599
TEST_TIME 111 9598
TEST_TIME 112 9578
TEST_TIME 113 9539
TEST_TIME 114 9504
TEST_TIME 115 9453
TEST_TIME 116 9459
TEST_TIME 117 9435
TEST_TIME 118 9494
TEST_TIME 119 9468
TEST_TIME 120 9399

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-01-2021 19:28:45 to 02-01-2021 19:28:48.

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 1549614 1549614 0 0.00 0 11632 5 0 0
doc_list_biud 1549613 1549613 0 0.00 0 31990 29 0 0
sp_add_invoice_to_stock 5083 4955 128 2.51 56 157564 15462 0 128
sp_cancel_adding_invoice 6051 6051 0 0.00 5 70058 753 0 0
sp_cancel_client_order 1785 1785 0 0.00 4 13848 334 0 0
sp_cancel_customer_reserve 584687 584687 0 0.00 1 26901 60 0 0
sp_cancel_pay_from_customer 685 685 0 0.00 2 3399 57 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 5349 76 0 0
sp_cancel_supplier_invoice 6599 6591 8 0.12 2 21751 839 0 8
sp_cancel_supplier_order 429 429 0 0.00 6 982395 104839 0 0
sp_cancel_write_off 10608 10608 0 0.00 1 32096 107 0 0
sp_client_order 20460 20460 0 0.00 3 17111 353 0 0
sp_customer_reserve 455537 455537 0 0.00 0 86105 154 0 0
sp_fill_shopping_cart 31315 31315 0 0.00 1 10505 34 0 0
sp_fill_shopping_cart_clo_res 455532 455532 0 0.00 0 15437 11 0 0
sp_get_clo_for_invoice 4948 4948 0 0.00 0 23609 255 0 0
sp_kill_cost_storno 17756 17756 0 0.00 0 5339 53 0 0
sp_kill_qstorno_ret_qs2qd 1187002 1187002 0 0.00 0 31989 33 0 0
sp_kill_qty_storno 625025 625025 0 0.00 0 31990 71 0 0
sp_lock_selected_doc 20592 20592 0 0.00 0 7992 4 0 0
sp_make_cost_storno 27814 27814 0 0.00 0 10141 45 0 0
sp_multiply_rows_for_pdistr 27814 27814 0 0.00 0 9411 30 0 0
sp_multiply_rows_for_qdistr 20460 20460 0 0.00 0 17099 138 0 0
sp_pay_from_customer 7070 7070 0 0.00 4 10996 107 0 0
sp_pay_to_supplier 5870 5870 0 0.00 4 12092 112 0 0
sp_payment_common 12940 12940 0 0.00 1 10206 26 0 0
sp_qd_handle_on_cancel_clo 1785 1785 0 0.00 0 13818 307 0 0
sp_qd_handle_on_invoice_upd_sts 10997 10997 0 0.00 0 27172 343 0 0
sp_qd_handle_on_reserve_upd_sts 9928 9928 0 0.00 0 13896 62 0 0
sp_reserve_write_off 9928 9928 0 0.00 6 13954 180 0 0
sp_supplier_invoice 5453 5453 0 0.00 6 90305 2995 0 0
sp_supplier_order 5405 5405 0 0.00 5 87619 1287 0 0
srv_aggregate_perf_data 111 111 0 0.00 2440 469997 20980 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1183 166575 34878 0 0
srv_find_qd_qs_mism 1080303 1080303 0 0.00 0 11610 5 0 0
srv_make_invnt_saldo 558 558 0 0.00 20 45920 1086 0 0
srv_make_money_saldo 825 825 0 0.00 0 4713 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 135119 450978 269358 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4956 4956 0 0.00 0 14397 157 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 5933 99 0 0
t$perf-norm:sp_cancel_client_order 1785 1785 0 0.00 0 4867 14 0 0
t$perf-norm:sp_cancel_customer_reserve 662 662 0 0.00 0 2459 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 685 685 0 0.00 0 6807 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 4540 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 592 9 0 0
t$perf-norm:sp_cancel_supplier_order 429 429 0 0.00 0 18208 1730 0 0
t$perf-norm:sp_cancel_write_off 951 951 0 0.00 0 2739 11 0 0
t$perf-norm:sp_client_order 20460 20460 0 0.00 0 7855 18 0 0
t$perf-norm:sp_customer_reserve 975 975 0 0.00 0 3474 9 0 0
t$perf-norm:sp_pay_from_customer 7070 7070 0 0.00 0 6762 11 0 0
t$perf-norm:sp_pay_to_supplier 5870 5870 0 0.00 0 7140 9 0 0
t$perf-norm:sp_reserve_write_off 9928 9928 0 0.00 0 6998 13 0 0
t$perf-norm:sp_supplier_invoice 5453 5453 0 0.00 0 5630 17 0 0
t$perf-norm:sp_supplier_order 5405 5405 0 0.00 0 5943 18 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 470 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 1727 15 0 0
t$perf-norm:srv_make_invnt_saldo 558 558 0 0.00 0 3519 18 0 0
t$perf-norm:srv_make_money_saldo 825 825 0 0.00 0 3959 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 5 0 0
v_add_invoice_to_stock 10146 9890 256 2.52 0 4319 18 0 256
v_all_customers 36952 36952 0 0.00 0 74 1 0 0
v_all_suppliers 30380 30380 0 0.00 0 83 1 0 0
v_all_wares 40920 40920 0 0.00 0 97 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 4331 14 0 0
v_cancel_client_order 3570 3570 0 0.00 0 3918 8 0 0
v_cancel_customer_prepayment 1370 1370 0 0.00 0 3391 6 0 0
v_cancel_customer_reserve 1324 1324 0 0.00 0 2314 7 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 3339 13 0 0
v_cancel_supplier_invoice 786 770 16 2.03 0 493 14 0 16
v_cancel_supplier_order 858 858 0 0.00 0 922 4 0 0
v_cancel_write_off 1902 1902 0 0.00 0 3177 15 0 0
v_max_id_clo_ord 5405 5405 0 0.00 0 1324 2 0 0
v_max_id_clo_res 975 975 0 0.00 0 4127 20 0 0
v_max_id_ord_sup 5450 5450 0 0.00 0 3855 4 0 0
v_max_non_paid_invoice 1535 1535 0 0.00 0 267 2 0 0
v_max_non_paid_realizn 3896 3896 0 0.00 0 5057 7 0 0
v_min_id_clo_ord 5405 5405 0 0.00 0 6372 7 0 0
v_min_id_clo_res 975 975 0 0.00 0 1426 6 0 0
v_min_id_ord_sup 5450 5450 0 0.00 0 3809 7 0 0
v_min_non_paid_invoice 5870 5870 0 0.00 0 6777 15 0 0
v_min_non_paid_realizn 7070 7070 0 0.00 0 10201 17 0 0
v_our_firm 10316 10316 0 0.00 0 16 1 0 0
v_reserve_write_off 19856 19856 0 0.00 0 4305 6 0 0
x_lock_depdocs_on_canc_invoice 12257 12257 0 0.00 0 14553 105 0 0
x_lock_depdocs_on_canc_sup_ord 429 429 0 0.00 0 10646 378 0 0
x_make_qstorno_1000_1200 5405 5405 0 0.00 1 87607 1208 0 0
x_make_qstorno_1200_2000 5453 5453 0 0.00 3 86871 2880 0 0
x_make_qstorno_2100_3300 455537 455537 0 0.00 0 86067 140 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-01-2021 19:28:49 to 02-01-2021 19:28:53.

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
16:57:13 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:19 15149 8192000000 10247088928 10558586880 902114528 9.919 71 55 110 0 923563040 2664272 18784240
16:57:43 15210 8192000000 10332200944 10649104384 1388294048 14.491 100 89 178 0 1422844752 5188416 29362288
16:58:07 28778 8192000000 10380964432 10707623936 1431049600 14.871 100 88 176 0 1466747344 6656128 29041616
16:58:44 19191 8192000000 10399268752 10730770432 1453454224 15.068 100 80 160 1 1487057088 7426720 26176144
16:59:12 12152 8192000000 10424977920 10758451200 1483360416 15.331 100 82 165 0 1517520352 7639616 26520320
16:59:33 24589 8192000000 10464983584 10801659904 1509388784 15.558 100 82 164 0 1543538096 7857776 26291536
17:00:10 19292 8192000000 10484997984 10828853248 1540884704 15.831 100 87 174 0 1577625824 8900544 27840576
17:00:40 11504 8192000000 10499501152 10844135424 1559717440 15.994 100 81 162 0 1594386688 9027456 25641792
17:01:01 14536 8192000000 10527046624 10876383232 1579451040 16.163 100 82 164 0 1613609472 9123824 25034608
17:01:26 16930 8192000000 10541968480 10898747392 1603343296 16.368 100 81 160 1 1638375024 9944400 25087328
17:01:54 13319 8192000000 10558309312 10913185792 1621644320 16.524 100 78 156 0 1655267904 9777808 23845776
17:02:17 14844 8192000000 10580543872 10940280832 1640698336 16.686 100 78 156 1 1674588992 10243120 23647536
17:02:43 14305 8192000000 10607174320 10968186880 1659862800 16.848 100 80 160 1 1695168224 11174576 24130848
17:03:06 6984 8192000000 10617146768 10984751104 1676711984 16.990 100 86 171 3 1713515552 11895568 24908000
17:03:20 7032 8192000000 10631079200 10996301824 1690343920 17.104 100 75 148 1 1723607168 11587728 21675520
17:03:35 8475 8192000000 10653289424 11021393920 1704579856 17.223 100 81 161 0 1740410512 12188736 23641920
17:03:52 6620 8192000000 10654979776 11026219008 1714743056 17.308 100 83 165 1 1750900608 11903072 24254480
17:04:07 5739 8192000000 10675223200 11048316928 1734576384 17.474 100 84 167 0 1769958832 11751840 23630608
17:04:20 6741 8192000000 10681041248 11054350336 1741511072 17.531 100 84 167 1 1777128160 11948432 23668656
17:04:36 6328 8192000000 10693783792 11064975360 1750799088 17.608 100 83 165 1 1786917616 12899504 23219024
17:04:50 4808 8192000000 10702296352 11080851456 1765407616 17.729 100 88 174 1 1803210096 13491328 24311152
17:05:02 5630 8192000000 10721974080 11098300416 1776743408 17.823 100 79 157 2 1811406544 13234704 21428432
17:05:14 5233 8192000000 10721417888 11100815360 1780054576 17.850 100 86 170 1 1817200864 13645504 23500784
17:05:27 3509 8192000000 10724665808 11103875072 1786648880 17.904 100 88 176 1 1824626848 14369712 23608256
17:05:37 4327 8192000000 10734465376 11114385408 1794247776 17.967 100 90 179 0 1834583536 15398672 24937088
17:05:48 2716 8192000000 10733752288 11115319296 1792537216 17.953 100 90 180 1 1832658160 15184752 24936192
17:05:57 2317 8192000000 10738987504 11116240896 1800452512 18.018 100 95 190 0 1841462592 14246384 26763696
17:06:07 8293 8192000000 10742014912 11127885824 1801816016 18.029 100 80 158 1 1837804240 13418688 22569536
17:06:22 4219 8192000000 10750286256 11138809856 1814593600 18.133 100 88 175 1 1852906928 13653232 24660096
17:06:34 3533 8192000000 10756635360 11145252864 1825160128 18.220 100 89 179 2 1865708656 14879824 25668704
17:06:44 2012 8192000000 10778787520 11163291648 1831521248 18.272 100 92 184 0 1873124624 15282672 26320704
17:06:53 2734 8192000000 10791132656 11172544512 1839230816 18.335 100 93 186 1 1881558896 15300528 27027552
17:07:02 2183 8192000000 10780686208 11163049984 1843191232 18.367 100 84 166 1 1880593968 14269472 23133264
17:07:10 1770 8192000000 10790870640 11176894464 1847887072 18.405 100 92 181 1 1887469856 13211728 26371056
17:07:18 2060 8192000000 10794956416 11181088768 1853091104 18.447 100 88 174 1 1888379360 11373328 23914928
17:07:28 2217 8192000000 10806058624 11190841344 1857276496 18.481 100 92 184 1 1896659568 13315056 26068016
17:07:37 1533 8192000000 10798793648 11188842496 1860610416 18.508 100 96 191 2 1900847040 13285360 26951264
17:07:45 1554 8192000000 10813923376 11197743104 1861476880 18.515 100 97 194 2 1902759856 13353008 27929968
17:07:53 1721 8192000000 10810741840 11196481536 1865089200 18.545 100 87 176 1 1903634688 14218704 24326784
17:08:01 1518 8192000000 10816371936 11201503232 1869597488 18.581 100 92 182 0 1909529168 14295952 25635728
17:08:09 2839 8192000000 10817318896 11203137536 1867933584 18.568 100 88 177 1 1905908384 13196144 24778656
17:08:18 1985 8192000000 10823443600 11208896512 1874164144 18.618 100 95 191 0 1914921168 13986832 26770192
17:08:26 1560 8192000000 10817456256 11206193152 1874893616 18.624 100 94 189 1 1914157104 13335424 25928064
17:08:34 1734 8192000000 10819633664 11210330112 1875461744 18.628 100 89 178 2 1914749104 13633392 25653968
17:08:42 1039 8192000000 10819642912 11214516224 1878594816 18.654 100 90 182 0 1917333696 13483664 25255216
17:08:55 25133 8192000000 10822685760 11216416768 1877833488 18.648 100 78 158 0 1911715152 11472624 22409040
17:09:26 1843 8192000000 10804142864 11217526784 1876873952 18.640 100 60 120 1 1906431296 12791696 16765648
17:09:34 2627 8192000000 10809072224 11217305600 1878776448 18.655 100 70 141 0 1909699952 10884928 20038576
17:09:44 7457 8192000000 10786276608 11209113600 1871957856 18.600 100 25 49 3 1885981584 7378624 6645104
17:09:58 3758 8192000000 10805281184 11213119488 1879162624 18.658 100 50 100 3 1899541840 7043504 13335712
17:10:09 5002 8192000000 10798117616 11214282752 1876849152 18.640 100 37 75 0 1895483680 8393536 10240992
17:10:22 3720 8192000000 10799497520 11215183872 1881976720 18.681 100 52 103 2 1904007248 7314624 14715904
17:10:33 7917 8192000000 10781696704 11213185024 1875690752 18.630 100 21 41 0 1889073664 7490880 5892032
17:10:49 4911 8192000000 10782994432 11214438400 1877866496 18.648 100 25 49 3 1891876352 6025776 7984080
17:11:02 12212 8192000000 10781729008 11214524416 1879398224 18.660 100 21 42 1 1891712240 6717984 5596032
17:11:24 12169 8192000000 10782229856 11217035264 1882600272 18.686 100 31 61 2 1898904976 6769312 9535392
17:11:43 66375 8192000000 10800462432 11232112640 1884010144 18.697 100 30 58 1 1898243104 5115184 9117776
17:12:59 6181 8192000000 10798417568 11230023680 1885398112 18.709 100 28 56 1 1900130960 6651136 8081712
17:13:15 8039 8192000000 10806854912 11234680832 1889771744 18.744 100 33 66 2 1905454992 6312624 9370624
17:13:30 6159 8192000000 10802893360 11235352576 1890079456 18.746 100 29 58 3 1905622656 6904832 8638368
17:13:45 7750 8192000000 10802503936 11234938880 1889149968 18.739 100 19 38 2 1900606304 6301504 5154832
17:14:01 9579 8192000000 10790046048 11226959872 1883130672 18.690 100 23 45 1 1895985264 5953376 6901216
17:14:19 6091 8192000000 10799471168 11232518144 1887200448 18.723 100 23 46 0 1900291120 5815472 7275200
17:14:31 7049 8192000000 10809211808 11236110336 1890910816 18.753 100 16 33 1 1900800928 5078512 4811600
17:14:46 8468 8192000000 10802080304 11237912576 1892882912 18.769 100 23 45 1 1904746064 4811856 7051296
17:15:01 10125 8192000000 10811245952 11239694336 1874507792 18.621 99 15 30 1 1884405952 5471120 4427040
17:15:17 7246 8192000000 10800263360 11233783808 1873050384 18.609 99 17 34 1 1882959104 5710496 4198224
17:15:32 2935 8192000000 10805877568 11236995072 1891899120 18.761 100 37 72 1 1909133552 6712144 10522288
17:15:41 10179 8192000000 10797434416 11231199232 1868418032 18.571 99 17 34 0 1883225280 10147824 4659424
17:15:57 19919 8192000000 10790149216 11214913536 1843840992 18.372 98 17 34 1 1854021024 5372192 4807840
17:16:28 50248 8192000000 10774182128 11208667136 1826020976 18.227 97 31 62 0 1841287312 6005856 9260480
17:17:29 8717 8192000000 10785048256 11212177408 1838275808 18.327 98 20 40 1 1849513552 5738048 5499696
17:17:44 5814 8192000000 10772529312 11188117504 1818240256 18.163 97 31 62 1 1834771408 8253104 8278048
17:17:57 7427 8192000000 10796606800 11219165184 1871432816 18.596 100 30 60 2 1886687568 7101888 8152864
17:18:11 5692 8192000000 10772480400 11201093632 1828885216 18.250 98 30 59 2 1846709584 10163632 7660736
17:18:25 6263 8192000000 10731178080 11149291520 1797489664 17.993 97 23 46 2 1809272160 5130848 6651648
17:18:39 10076 8192000000 10730821104 11151507456 1751204672 17.612 95 26 50 1 1764104464 5137376 7762416
17:18:56 5684 8192000000 10749264560 11172724736 1824439392 18.214 99 27 54 1 1838288480 6268880 7580208
17:19:10 4466 8192000000 10740358992 11160915968 1824395520 18.214 100 22 44 2 1836833440 6601152 5836768
17:19:22 13804 8192000000 10734408656 11164745728 1788423312 17.919 97 22 44 1 1806389600 10146688 7819600
17:19:43 6298 8192000000 10713805456 11130372096 1788824048 17.922 98 25 50 4 1802037568 5950288 7263232
17:19:55 9759 8192000000 10701589120 11123220480 1741211952 17.529 96 27 56 0 1754984400 5436560 8335888
17:20:14 12954 8192000000 10731993168 11150454784 1805833104 18.062 100 16 32 0 1816730352 5825552 5071696
17:20:34 16646 8192000000 10699575920 11116683264 1698065360 17.169 94 15 30 1 1712028544 9899488 4063696
17:20:57 53836 8192000000 10696925872 11101216768 1735558080 17.482 96 26 53 2 1749415264 5313248 8543936
17:22:01 29353 8192000000 10685527264 11109064704 1746700560 17.574 96 24 47 1 1760029056 5503952 7824544
17:22:36 6410 8192000000 10733708096 11153063936 1798681232 18.003 99 23 46 1 1811614800 6030176 6903392
17:22:51 7277 8192000000 10731870144 11151179776 1816339424 18.148 100 25 50 0 1828606352 4501216 7765712
17:23:06 9282 8192000000 10750499760 11173453824 1835194608 18.302 100 36 74 1 1852066016 6506304 10365104
17:23:24 9120 8192000000 10751650576 11176640512 1839108992 18.334 100 24 48 2 1851415568 5218880 7087696
17:23:39 7323 8192000000 10763332944 11182981120 1842906736 18.364 100 25 47 1 1856298464 6705600 6686128
17:23:52 5540 8192000000 10750126384 11183616000 1842973040 18.365 100 17 34 0 1853267808 5475088 4819680
17:24:04 9048 8192000000 10763709136 11181256704 1842838704 18.364 100 27 54 0 1856285216 5040768 8405744
17:24:23 7824 8192000000 10769771424 11189825536 1848782832 18.412 100 23 46 0 1859960384 4979392 6198160
17:24:39 6597 8192000000 10763482272 11195670528 1855342768 18.466 100 30 61 2 1869916720 5861744 8712208
17:24:55 13176 8192000000 10775376976 11203108864 1862443328 18.523 100 24 48 1 1875029440 5587504 6998608
17:25:14 14874 8192000000 10775596000 11206877184 1864367856 18.539 100 20 40 0 1875646128 5515376 5762896
17:25:39 13510 8192000000 10787167376 11212414976 1866409136 18.555 100 22 44 3 1878269728 5862288 5998304
17:25:59 26448 8192000000 10778952896 11213271040 1871096512 18.593 100 24 48 1 1883773952 5070656 7606784
17:26:55 20448 8192000000 10786617024 11209191424 1864110096 18.537 99 27 54 1 1876579856 5365312 7104448
17:27:58 19550 8192000000 10837729552 11255476224 1903177760 18.852 100 46 92 3 1923210576 7871024 12161792
17:28:24 4286 8192000000 10841585008 11261480960 1912521344 18.927 100 56 108 2 1936380432 8483488 15375600
17:28:36 12484 8192000000 10862948640 11280035840 1924827904 19.026 100 53 107 0 1949502912 9484720 15190288
17:28:57 16558 8192000000 10845537648 11269054464 1913029760 18.931 99 51 102 0 1936929504 9979760 13919984
17:29:27 7347 8192000000 10871851264 11292000256 1936657024 19.120 100 58 117 3 1965064160 12135792 16271344
17:29:43 29143 8192000000 10859377808 11298480128 1936964224 19.123 100 39 78 0 1958648192 10670592 11013376
17:30:23 39419 8192000000 10872807520 11299848192 1932492896 19.087 99 37 74 1 1955132400 11728352 10911152
17:31:13 26606 8192000000 10889189024 11322417152 1957517120 19.286 100 43 86 0 1985108240 14485632 13105488
17:31:49 36174 8192000000 10888757216 11321241600 1945551824 19.191 99 44 88 1 1973345168 14394176 13399168
17:32:43 26580 8192000000 10905459488 11338813440 1966357392 19.357 100 35 70 0 1990996336 13917888 10721056
17:33:27 11137 8192000000 10905637616 11343298560 1976153648 19.434 100 40 80 1 2004983536 14834912 13994976
17:33:45 3980 8192000000 10913192800 11328794624 1962523104 19.326 99 52 104 1 1994830288 16105264 16201920
17:33:58 7331 8192000000 10934692688 11358400512 1984191392 19.498 100 64 128 2 2025396896 22647408 18558096
17:34:19 8470 8192000000 10939927328 11357630464 1981451984 19.476 100 62 124 3 2023363040 23749920 18161136
17:34:55 20255 8192000000 10925131120 11357130752 1980686656 19.470 100 45 88 3 2017262608 23165792 13410160
17:35:32 10732 8192000000 10932430992 11360264192 1980768320 19.471 100 48 96 0 2021488832 25094416 15626096
17:35:59 7372 8192000000 10920227296 11352801280 1972110032 19.402 99 56 112 3 2013464064 24091520 17262512
17:36:15 16201 8192000000 10933750800 11366305792 1971595856 19.398 99 46 93 1 2008282000 22584272 14101872
17:36:41 18587 8192000000 10957422784 11390705664 1999592944 19.620 100 51 103 0 2040207360 24885792 15728624
17:37:09 5406 8192000000 10956652672 11385229312 2000866800 19.630 100 55 106 0 2042489552 26159856 15462896
17:37:21 3435 8192000000 10971461840 11395170304 2008759296 19.692 100 59 117 2 2055245888 27985840 18500752
17:37:32 3475 8192000000 10961158816 11383087104 1973011136 19.409 98 62 122 3 2020354432 28893632 18449664
17:37:44 1183 8192000000 10964756240 11377455104 1987042688 19.520 99 74 147 0 2040557792 29604656 23910448
17:37:52 2946 8192000000 10973003440 11387113472 2002834768 19.645 100 74 148 0 2054150608 29122560 22193280
17:38:04 7247 8192000000 10978681248 11400089600 2010264336 19.704 100 78 153 2 2065156992 31180192 23712464
17:38:18 5433 8192000000 10976799632 11397660672 2008736768 19.692 100 84 168 1 2067775488 33814816 25223904
17:38:36 3893 8192000000 10963014560 11380514816 1983422352 19.492 99 81 159 2 2041496928 34413728 23660848
17:38:47 2421 8192000000 10978773936 11395936256 2003400912 19.650 100 88 173 1 2064664336 34047632 27215792
17:38:57 5817 8192000000 10966143856 11384455168 1979371424 19.460 99 78 156 1 2039160576 35376000 24413152
17:39:11 7019 8192000000 10967682944 11386478592 1995476368 19.587 100 75 146 4 2052050928 34309616 22264944
17:39:26 6582 8192000000 10976943536 11403710464 2004073168 19.655 100 68 136 2 2065370736 40208304 21089264
17:39:44 4696 8192000000 10951210480 11376590848 1988788992 19.534 100 56 112 1 2039717904 33585072 17343840
17:39:56 7867 8192000000 10947311216 11368148992 1972990848 19.409 99 67 131 0 2028048016 34272096 20785072
17:40:21 5192 8192000000 10979283888 11398623232 2006291344 19.672 100 71 139 3 2064430448 35686960 22452144
17:40:33 6404 8192000000 10975445360 11403661312 2006771168 19.676 100 62 121 1 2059703872 34341248 18591456
17:40:47 8112 8192000000 10973118096 11407134720 2010042048 19.702 100 56 111 0 2062403968 34438064 17923856
17:41:04 1619 8192000000 10962125568 11381477376 1988820640 19.534 99 67 134 1 2042886720 32069040 21997040
17:41:13 2969 8192000000 10972274416 11394109440 2008835552 19.692 100 86 171 2 2066962400 31902336 26224512
17:41:24 3806 8192000000 10970664320 11394875392 1991453008 19.555 99 76 151 0 2044221088 30268368 22499712
17:41:34 1682 8192000000 10956379408 11386462208 1983683040 19.494 99 58 113 0 2031044464 29555408 17806016
17:41:42 4899 8192000000 10957385392 11386417152 1994388464 19.578 100 57 114 4 2042618128 30609712 17619952
17:41:55 3252 8192000000 10963847280 11394203648 1999666624 19.620 100 63 126 1 2051286128 31925920 19693584
17:42:05 10116 8192000000 10964301440 11402743808 2003323968 19.649 100 53 106 2 2051923936 32045776 16554192
17:42:24 4223 8192000000 10977790480 11399454720 1989817616 19.542 99 67 133 4 2042281440 31815808 20648016
17:42:37 7076 8192000000 10961128448 11391594496 1994035200 19.576 100 59 118 2 2046146576 32926512 19184864
17:42:51 4295 8192000000 10950152304 11375538176 1976308672 19.435 99 63 126 1 2035436736 39119040 20009024
17:43:12 2357 8192000000 10954532480 11384520704 1978348640 19.452 99 74 149 0 2043045104 41919632 22776832
17:43:21 2053 8192000000 10978008832 11403735040 1998863808 19.614 100 72 144 1 2060408240 38788672 22755760
17:43:31 2707 8192000000 10962762528 11386224640 1991480592 19.555 100 81 162 0 2052126240 35657792 24987856
17:43:43 12729 8192000000 10971486768 11391139840 1988582592 19.533 100 63 124 2 2046308368 36959488 20766288
17:44:02 2403 8192000000 10975255280 11399933952 1998634912 19.612 100 70 140 1 2059554464 38801568 22117984
17:44:15 2734 8192000000 10991542704 11400466432 1999182336 19.616 100 84 167 0 2067536432 42458592 25895504
17:44:26 3124 8192000000 10976354320 11396759552 1979870608 19.464 99 65 129 1 2041273936 41037728 20365600
17:44:36 10305 8192000000 10959108736 11392565248 1967273696 19.364 99 56 112 2 2031718080 46905424 17538960
17:44:58 8342 8192000000 10955782832 11408785408 1989944176 19.543 100 44 88 0 2050110144 45948096 14217872
17:45:17 8078 8192000000 10949112112 11386359808 1974613744 19.422 99 42 83 1 2025136112 36449600 14072768
17:45:34 1544 8192000000 10981337104 11396505600 1994643232 19.580 100 87 173 4 2058132304 36338464 27150608
17:45:43 1617 8192000000 10976537200 11392192512 1991605472 19.556 100 85 170 0 2056744464 37514256 27624736
17:45:52 4187 8192000000 10965499584 11389267968 1988375568 19.531 100 70 139 1 2050186224 38557936 23252720
17:46:03 2017 8192000000 10984713808 11403239424 1999880528 19.622 100 81 163 0 2065854736 40726048 25248160
17:46:12 4196 8192000000 10990491568 11411066880 2000102672 19.624 100 77 154 1 2068053248 43729632 24220944
17:46:25 2783 8192000000 10986645440 11408433152 1993320976 19.570 99 89 175 1 2063993872 42920416 27752480
17:46:34 5750 8192000000 10965783776 11392147456 1981531504 19.477 99 73 145 0 2048829328 43749248 23548576
17:46:49 11491 8192000000 10970454048 11413463040 1999512048 19.619 100 51 102 2 2057002768 40448688 17042032
17:47:12 9564 8192000000 10965435936 11408605184 2001406304 19.634 100 54 108 1 2059394144 39581008 18406832
17:47:28 10790 8192000000 10962556336 11401887744 1994902816 19.583 100 47 91 4 2049748928 38579424 16266688
17:47:54 4995 8192000000 10970161360 11393466368 1974213136 19.419 99 61 120 1 2035723440 41925680 19584624
17:48:11 13160 8192000000 10956682704 11394777088 1983129280 19.489 100 43 86 0 2038763552 40989216 14645056
17:48:33 10172 8192000000 10962660224 11404861440 1987572368 19.525 100 38 76 0 2043962112 43551440 12838304
17:48:55 12547 8192000000 10911263248 11355365376 1921738048 19.001 97 37 74 1 1976734544 42486736 12509760
17:49:16 20289 8192000000 10919627152 11363561472 1949016960 19.219 99 30 60 0 1997674176 37862928 10794288
17:49:43 23682 8192000000 10910146608 11353387008 1935409072 19.110 99 28 56 2 1982459056 37996448 9053536
17:50:34 14681 8192000000 10914385840 11356180480 1935366784 19.110 100 29 58 1 1991389248 45718880 10303584
17:50:57 13074 8192000000 10897729616 11350790144 1929469376 19.063 100 25 50 2 1985593856 46586256 9538224
17:51:24 28073 8192000000 10856775648 11311771648 1857458992 18.483 97 24 48 2 1914937504 47817040 9661472
17:51:58 22784 8192000000 10867106992 11309391872 1867624688 18.565 98 27 52 2 1913493120 36594272 9274160
17:52:28 27117 8192000000 10879729888 11338989568 1916635024 18.960 100 29 58 2 1971482208 45375872 9471312
17:53:03 30248 8192000000 10887823920 11342635008 1928908000 19.058 100 22 44 0 1971393072 34358768 8126304
17:53:39 25213 8192000000 10882201584 11335847936 1940537984 19.151 100 20 40 2 1971557424 25081312 5938128
17:54:16 47916 8192000000 10890468992 11334094848 1931767472 19.081 99 29 59 0 1956474992 16159184 8548336
17:55:14 22035 8192000000 10862876608 11323891712 1920012192 18.987 99 23 46 1 1942054400 15117760 6924448
17:55:44 28258 8192000000 10862890368 11328393216 1914724000 18.945 99 11 22 2 1939503472 21304928 3474544
17:56:32 58210 8192000000 10862148656 11321884672 1892961104 18.770 98 9 18 0 1904228624 9151440 2116080
17:57:41 87106 8192000000 10888349776 11347701760 1948005952 19.211 100 5 10 0 1959791216 10691088 1094176
17:59:14 95294 8192000000 10880295744 11330269184 1911379984 18.918 97 25 50 3 1927916784 9448640 7088160
18:01:04 52924 8192000000 10889737888 11351822336 1945976336 19.194 99 29 57 1 1963279808 8172720 9130752
18:02:11 98119 8192000000 10849081264 11303518208 1778815024 17.840 91 12 24 1 1789332800 7877712 2640064
18:03:56 50581 8192000000 10871746544 11332022272 1936174816 19.116 100 15 30 0 1950483776 9922432 4386528
18:04:58 102613 8192000000 10896799952 11339898880 1910000480 18.907 98 11 22 0 1928137424 14779488 3357456
18:06:50 53655 8192000000 10919281872 11347595264 1954026176 19.259 100 33 66 0 1978130496 14586416 9517904
18:07:52 120054 8192000000 10910642000 11379404800 1946311728 19.197 99 35 70 0 1971359312 14641568 10406016
18:09:58 66730 8192000000 10895909248 11355860992 1933503536 19.095 98 18 36 2 1951903648 12586624 5813488
18:11:22 35452 8192000000 10913553936 11350032384 1950061776 19.227 99 34 68 1 1967754576 8153376 9539424
18:12:09 25085 8192000000 10900747120 11361669120 1951900880 19.242 99 21 40 3 1965862800 7960992 6000928
18:12:46 146261 8192000000 10892225312 11367460864 1903633104 18.856 96 14 28 1 1918410832 11042368 3735360
18:15:39 59704 8192000000 10929806224 11379261440 1973376576 19.412 100 29 57 1 1993788864 12105648 8306640
18:16:46 51625 8192000000 10943795184 11388223488 1994894928 19.582 100 41 82 0 2015881552 9590432 11396192
18:17:44 44197 8192000000 10912711712 11383443456 1951226224 19.236 98 44 88 0 1977788224 13917632 12644368
18:18:36 85294 8192000000 10934951312 11377766400 1917640848 18.968 97 22 43 0 1935985536 12363664 5981024
18:20:08 37355 8192000000 10923523520 11392053248 1981078640 19.473 100 24 48 1 2004770992 16323392 7368960
18:20:52 55643 8192000000 10935770336 11396108288 1967490896 19.366 99 18 36 1 1990954400 17588400 5875104
18:22:02 30954 8192000000 10960458064 11409375232 2002451216 19.642 100 64 128 5 2039985904 18198656 19336032
18:22:41 54076 8192000000 10929174176 11411849216 1974868576 19.424 99 24 48 0 2002444864 20241088 7335200
18:23:55 28827 8192000000 10918357648 11402764288 1990403680 19.547 100 10 20 0 2011684800 18380224 2900896
18:25:12 132031 8192000000 10889935776 11368808448 1896458912 18.798 95 10 21 0 1910113376 10576048 3078416
18:27:36 81820 8192000000 10894329904 11382910976 1930230288 19.069 98 7 14 0 1940543856 9050336 1263232
18:29:04 9023 8192000000 10907266304 11374149632 1980232512 19.467 100 14 27 1 1987688784 2748768 4707504
18:29:20 36176 8192000000 10894922416 11366338560 1957909136 19.289 99 21 43 1 1971725296 6826416 6989744
18:30:02 28236 8192000000 10891830640 11343814656 1919803520 18.985 97 23 44 1 1933807136 7902928 6100688
18:30:38 22604 8192000000 10876716592 11336146944 1905612176 18.871 97 27 51 2 1919818304 7552624 6653504
18:31:09 17584 8192000000 10850191040 11307765760 1908201792 18.892 98 28 57 0 1923855808 7833136 7820880
18:31:32 10288 8192000000 10866102032 11311882240 1909486288 18.903 98 43 86 1 1929716320 7687712 12542320
18:31:51 21542 8192000000 10891487184 11341373440 1914051184 18.939 98 60 120 0 1946657472 15847296 16758992
18:32:20 26356 8192000000 10860233824 11318005760 1888806400 18.736 97 27 54 0 1908892512 11977248 8108864
18:32:54 38793 8192000000 10872606192 11326365696 1873232624 18.610 97 18 36 0 1887242352 8950320 5059408
18:33:42 45426 8192000000 10863555376 11321663488 1899797296 18.825 98 32 64 1 1922603872 13428240 9378336
18:34:39 46854 8192000000 10845388128 11310743552 1876909200 18.640 97 11 22 0 1898966048 18843152 3213696
18:35:32 112346 8192000000 10881337392 11352244224 1906388672 18.878 98 13 26 0 1925994800 16202976 3403152
18:37:38 98450 8192000000 10881252368 11356536832 1912124736 18.924 98 13 26 1 1927455888 11840944 3490208
18:39:27 61480 8192000000 10891118896 11347099648 1877324896 18.643 96 13 26 2 1890151936 9559216 3267824
18:40:35 22713 8192000000 10883337120 11337777152 1940473392 19.151 99 37 73 0 1959686432 9611360 9601680
18:41:07 72524 8192000000 10870334992 11338641408 1875060736 18.625 96 10 18 0 1888989776 11864944 2064096
18:42:26 35716 8192000000 10881888192 11323707392 1894237792 18.780 97 49 97 2 1920287280 13584224 12465264
18:43:09 8575 8192000000 10866921888 11300929536 1914869792 18.946 99 62 126 0 1942512048 10351008 17291248
18:43:26 41579 8192000000 10862670576 11313909760 1870424256 18.588 97 51 98 0 1895846656 12057056 13365344
18:44:19 108408 8192000000 10856002768 11325624320 1922752496 19.009 100 23 46 0 1942076192 12594416 6729280
18:46:32 97218 8192000000 10867187360 11337125888 1900855536 18.833 98 28 56 3 1922183920 13251296 8077088
18:48:15 16315 8192000000 10862393504 11333550080 1934567648 19.103 100 13 26 0 1952660096 14187872 3904576
18:49:00 53924 8192000000 10849579152 11315302400 1883392880 18.692 97 23 46 3 1899989616 9255824 7340912
18:50:00 84248 8192000000 10856238880 11331555328 1908626576 18.896 99 7 14 0 1923357168 12816976 1913616
18:51:30 67504 8192000000 10863403904 11339489280 1937045280 19.123 100 12 24 2 1953164208 12072288 4046640
18:52:47 65808 8192000000 10857590560 11333578752 1928903136 19.058 99 17 34 1 1947588992 14462624 4223232
18:53:59 78264 8192000000 10860258016 11335606272 1919575360 18.983 99 7 14 1 1928217088 6849840 1791888
18:55:25 50289 8192000000 10863765328 11327995904 1922787840 19.009 99 14 28 0 1936077792 9125360 4164592
18:56:22 68869 8192000000 10853693408 11325067264 1888882288 18.737 97 15 30 1 1902328256 9477504 3968464
18:57:37 65020 8192000000 10883244752 11364421632 1937020672 19.123 99 16 32 1 1957337280 15740416 4576192
18:58:49 55758 8192000000 10871475568 11343122432 1940392448 19.150 99 20 40 1 1957971328 11333904 6244976
18:59:53 68698 8192000000 10886887040 11352350720 1889013616 18.738 96 13 26 3 1902980800 10575072 3392112
19:01:20 45295 8192000000 10882065984 11343020032 1908963136 18.898 97 29 58 0 1930660240 12572944 9124160
19:02:11 41795 8192000000 10901790432 11353849856 1944001824 19.179 99 27 51 4 1961783184 10332096 7449264
19:03:00 73304 8192000000 10888672480 11362865152 1918717792 18.977 98 34 68 2 1942230064 13725616 9786656
19:04:51 97287 8192000000 10901020368 11385438208 1930920528 19.074 98 14 28 0 1949693808 14984848 3788432
19:06:36 65336 8192000000 10914998432 11380641792 1942436752 19.166 98 23 46 1 1961572960 12775552 6360656
19:07:47 91296 8192000000 10899651536 11379961856 1899342576 18.821 96 22 44 2 1925886464 20457248 6086640
19:09:24 60430 8192000000 10933605680 11411877888 1985081072 19.505 100 13 27 0 2005722672 16874864 3766736
19:10:34 80183 8192000000 10921992672 11398688768 1929018480 19.059 97 7 14 1 1949140528 18165456 1956592
19:12:01 166575 8192000000 10925365136 11413176320 1982264320 19.483 100 17 33 2 1999312608 12379952 4668336
19:15:09 48129 8192000000 10937909104 11413782528 1999715808 19.620 100 20 40 0 2025263088 19640560 5906720
19:16:29 60250 8192000000 10913850352 11406073856 1958944144 19.298 98 16 32 1 1979866880 16188544 4734192
19:19:07 56304 8192000000 10922162880 11404922880 1976639632 19.438 99 12 24 0 1992605216 12604064 3361520
19:20:10 63367 8192000000 10908680816 11388375040 1916951632 18.962 96 6 12 0 1932043664 13383328 1708704
19:21:20 94348 8192000000 10902366192 11382198272 1920417648 18.990 97 12 24 1 1945606672 21701408 3487616
19:23:12 55719 8192000000 10854797664 11330957312 1891564848 18.758 96 17 34 1 1912983440 16714816 4703776
19:24:24 83844 8192000000 10867049440 11356483584 1900902032 18.834 97 10 20 0 1920145056 16576080 2666944
19:25:57 59549 8192000000 10890591680 11363217408 1925556128 19.031 98 12 25 0 1939133728 9772464 3805136
19:27:07 15655 8192000000 9491055808 9798209536 633444480 7.177 32 5 10 1 644062528 9413424 1204624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 02-01-2021 19:28:55 to 02-01-2021 19:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 128 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-01-2021 19:29:27 to 02-01-2021 19:29:29.

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          240650
MON$OLDEST_ACTIVE               240651
MON$OLDEST_SNAPSHOT             240651
MON$NEXT_TRANSACTION            240651
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                       2051552
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:235: 
:236: mscs-test-161.budzdorov.ru    Sat Jan  2 19:27:32 2021
:237:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:238: 
:239: 
:240: mscs-test-161.budzdorov.ru    Sat Jan  2 19:27:35 2021
:241:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:242: 
--- end of diff output ---

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

02.01.21 19:29:30. 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-02 19:29:32 No severe PSQL-related problems occured
02.01.21 19:29:34. End of report.