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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17214844 kB
MemAvailable 31414468 kB
Buffers 0 kB
Cached 14441732 kB
SwapCached 3456 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-11-13 16:27:02
DTS_END                         2020-11-13 16:27:02.0830
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33514
TRN_ID                          251976
ATT_ID                          727
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: 9523.42 18574 1142810
customer order: creation 190.43 316 22852
customer order: refuse 16.36 309 1963
order to supplier: creation 49.36 1226 5923
order to supplier: removal 3.60 82207 432
invoice (draft): creation 50.63 3104 6075
invoice (draft): removal 51.28 747 6153
invoice accept: apply 46.19 17413 5543
invoice accept: cancel 45.49 745 5459
customer reserve: creation 4245.52 173 509462
customer reserve: removal 4512.62 50 541514
realization accept: apply 91.56 156 10987
realization accept: cancel 77.70 109 9324
payment from customer: creation 64.70 112 7764
payment from customer: removal 6.33 80 760
payment to supplier: creation 54.61 110 6553
payment to supplier: removal 4.02 73 482
service: total inventory turnovers 5.27 1171 632
service: total monetary turnovers 6.94 31 833
service: aggregate perf. data 0.79 25725 95
service: refresh index statistics 0.03 237632 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-11-2020 16:27:51 to 13-11-2020 16:27:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9531
TEST_TIME 2 8784
TEST_TIME 3 7850
TEST_TIME 4 7333
TEST_TIME 5 7488
TEST_TIME 6 6827
TEST_TIME 7 6901
TEST_TIME 8 6667
TEST_TIME 9 7297
TEST_TIME 10 7601
TEST_TIME 11 7587
TEST_TIME 12 7985
TEST_TIME 13 8130
TEST_TIME 14 8514
TEST_TIME 15 8528
TEST_TIME 16 8519
TEST_TIME 17 8665
TEST_TIME 18 8789
TEST_TIME 19 9063
TEST_TIME 20 9166
TEST_TIME 21 9165
TEST_TIME 22 9247
TEST_TIME 23 9606
TEST_TIME 24 9832
TEST_TIME 25 9798
TEST_TIME 26 9796
TEST_TIME 27 10113
TEST_TIME 28 10520
TEST_TIME 29 10542
TEST_TIME 30 10671
TEST_TIME 31 10738
TEST_TIME 32 10656
TEST_TIME 33 11009
TEST_TIME 34 10836
TEST_TIME 35 10819
TEST_TIME 36 10692
TEST_TIME 37 10510
TEST_TIME 38 10478
TEST_TIME 39 10355
TEST_TIME 40 10358
TEST_TIME 41 10316
TEST_TIME 42 10280
TEST_TIME 43 10349
TEST_TIME 44 10382
TEST_TIME 45 10309
TEST_TIME 46 10399
TEST_TIME 47 10257
TEST_TIME 48 10172
TEST_TIME 49 10250
TEST_TIME 50 10100
TEST_TIME 51 10090
TEST_TIME 52 10070
TEST_TIME 53 10052
TEST_TIME 54 10079
TEST_TIME 55 10066
TEST_TIME 56 9963
TEST_TIME 57 9907
TEST_TIME 58 9842
TEST_TIME 59 9772
TEST_TIME 60 9856
TEST_TIME 61 9987
TEST_TIME 62 9963
TEST_TIME 63 9925
TEST_TIME 64 9884
TEST_TIME 65 9934
TEST_TIME 66 9930
TEST_TIME 67 9890
TEST_TIME 68 9834
TEST_TIME 69 9941
TEST_TIME 70 9952
TEST_TIME 71 9946
TEST_TIME 72 9893
TEST_TIME 73 9976
TEST_TIME 74 9988
TEST_TIME 75 9959
TEST_TIME 76 9950
TEST_TIME 77 9939
TEST_TIME 78 9829
TEST_TIME 79 9809
TEST_TIME 80 9760
TEST_TIME 81 9743
TEST_TIME 82 9737
TEST_TIME 83 9674
TEST_TIME 84 9629
TEST_TIME 85 9595
TEST_TIME 86 9588
TEST_TIME 87 9584
TEST_TIME 88 9603
TEST_TIME 89 9581
TEST_TIME 90 9552
TEST_TIME 91 9576
TEST_TIME 92 9632
TEST_TIME 93 9638
TEST_TIME 94 9621
TEST_TIME 95 9670
TEST_TIME 96 9642
TEST_TIME 97 9673
TEST_TIME 98 9651
TEST_TIME 99 9675
TEST_TIME 100 9708
TEST_TIME 101 9752
TEST_TIME 102 9767
TEST_TIME 103 9724
TEST_TIME 104 9660
TEST_TIME 105 9659
TEST_TIME 106 9615
TEST_TIME 107 9594
TEST_TIME 108 9569
TEST_TIME 109 9552
TEST_TIME 110 9530
TEST_TIME 111 9507
TEST_TIME 112 9496
TEST_TIME 113 9546
TEST_TIME 114 9541
TEST_TIME 115 9565
TEST_TIME 116 9549
TEST_TIME 117 9530
TEST_TIME 118 9595
TEST_TIME 119 9605
TEST_TIME 120 9525

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-11-2020 16:27:55 to 13-11-2020 16:27: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 1612687 1612687 0 0.00 0 43929 6 0 0
doc_list_biud 1612686 1612686 0 0.00 0 22186 22 0 0
sp_add_invoice_to_stock 5699 5543 156 2.73 46 193244 17414 0 156
sp_cancel_adding_invoice 5459 5459 0 0.00 3 65593 746 0 0
sp_cancel_client_order 1963 1963 0 0.00 4 10469 310 0 0
sp_cancel_customer_reserve 541514 541514 0 0.00 1 22189 50 0 0
sp_cancel_pay_from_customer 760 760 0 0.00 3 9018 80 0 0
sp_cancel_pay_to_supplier 482 482 0 0.00 3 3115 73 0 0
sp_cancel_supplier_invoice 6163 6153 10 0.16 2 18415 747 0 10
sp_cancel_supplier_order 432 432 0 0.00 8 832244 82207 0 0
sp_cancel_write_off 9324 9324 0 0.00 1 13612 110 0 0
sp_client_order 22852 22852 0 0.00 3 15850 316 0 0
sp_customer_reserve 509462 509462 0 0.00 0 53747 174 0 0
sp_fill_shopping_cart 34850 34850 0 0.00 1 15575 38 0 0
sp_fill_shopping_cart_clo_res 509458 509458 0 0.00 0 18114 12 0 0
sp_get_clo_for_invoice 5535 5535 0 0.00 0 20818 283 0 0
sp_kill_cost_storno 16025 16025 0 0.00 0 6262 52 0 0
sp_kill_qstorno_ret_qs2qd 1098937 1098937 0 0.00 0 22183 27 0 0
sp_kill_qty_storno 581361 581361 0 0.00 0 22186 60 0 0
sp_lock_selected_doc 22877 22877 0 0.00 0 7317 5 0 0
sp_make_cost_storno 30834 30834 0 0.00 0 13215 54 0 0
sp_multiply_rows_for_pdistr 30833 30833 0 0.00 0 6541 26 0 0
sp_multiply_rows_for_qdistr 22852 22852 0 0.00 0 11551 127 0 0
sp_pay_from_customer 7764 7764 0 0.00 4 15417 113 0 0
sp_pay_to_supplier 6553 6553 0 0.00 4 13225 111 0 0
sp_payment_common 14317 14317 0 0.00 1 15411 28 0 0
sp_qd_handle_on_cancel_clo 1963 1963 0 0.00 0 10461 287 0 0
sp_qd_handle_on_invoice_upd_sts 10988 10988 0 0.00 0 19773 319 0 0
sp_qd_handle_on_reserve_upd_sts 10987 10987 0 0.00 0 9478 48 0 0
sp_reserve_write_off 10987 10987 0 0.00 6 11124 156 0 0
sp_supplier_invoice 6075 6075 0 0.00 7 76374 3104 0 0
sp_supplier_order 5923 5923 0 0.00 5 27134 1227 0 0
srv_aggregate_perf_data 96 95 1 1.04 2321 581498 25726 0 1
srv_fill_mon_cache_memory 178 178 0 0.00 1261 124581 29765 0 0
srv_find_qd_qs_mism 1089246 1089246 0 0.00 0 43927 6 0 0
srv_make_invnt_saldo 632 632 0 0.00 43 194002 1171 0 0
srv_make_money_saldo 833 833 0 0.00 1 2962 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 135757 368995 237632 0 0
t$perf-abend:sp_add_invoice_to_stock 156 156 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5543 5543 0 0.00 0 17511 166 0 0
t$perf-norm:sp_cancel_adding_invoice 387 387 0 0.00 0 4010 95 0 0
t$perf-norm:sp_cancel_client_order 1963 1963 0 0.00 0 1324 11 0 0
t$perf-norm:sp_cancel_customer_reserve 742 742 0 0.00 0 464 5 0 0
t$perf-norm:sp_cancel_pay_from_customer 760 760 0 0.00 0 642 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 482 482 0 0.00 0 1613 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 425 425 0 0.00 0 2582 21 0 0
t$perf-norm:sp_cancel_supplier_order 432 432 0 0.00 0 25976 1682 0 0
t$perf-norm:sp_cancel_write_off 1171 1171 0 0.00 0 7564 11 0 0
t$perf-norm:sp_client_order 22852 22852 0 0.00 0 7802 15 0 0
t$perf-norm:sp_customer_reserve 1084 1084 0 0.00 0 6411 14 0 0
t$perf-norm:sp_pay_from_customer 7764 7764 0 0.00 0 6434 9 0 0
t$perf-norm:sp_pay_to_supplier 6553 6553 0 0.00 0 3643 9 0 0
t$perf-norm:sp_reserve_write_off 10987 10987 0 0.00 0 13710 12 0 0
t$perf-norm:sp_supplier_invoice 6075 6075 0 0.00 0 13675 23 0 0
t$perf-norm:sp_supplier_order 5923 5923 0 0.00 0 4343 16 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 496 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 178 178 0 0.00 0 3742 29 0 0
t$perf-norm:srv_make_invnt_saldo 632 632 0 0.00 0 663 15 0 0
t$perf-norm:srv_make_money_saldo 833 833 0 0.00 0 2684 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 11368 11056 312 2.74 0 6696 19 0 312
v_all_customers 41066 41066 0 0.00 0 19 1 0 0
v_all_suppliers 33586 33586 0 0.00 0 23 1 0 0
v_all_wares 45704 45704 0 0.00 0 33 1 0 0
v_cancel_adding_invoice 774 774 0 0.00 0 2033 9 0 0
v_cancel_client_order 3926 3926 0 0.00 0 4215 4 0 0
v_cancel_customer_prepayment 1520 1520 0 0.00 0 4450 9 0 0
v_cancel_customer_reserve 1484 1484 0 0.00 0 1215 3 0 0
v_cancel_payment_to_supplier 964 964 0 0.00 0 3094 10 0 0
v_cancel_supplier_invoice 870 850 20 2.29 0 405 15 0 20
v_cancel_supplier_order 864 864 0 0.00 0 197 3 0 0
v_cancel_write_off 2342 2342 0 0.00 0 3734 13 0 0
v_max_id_clo_ord 5923 5923 0 0.00 0 353 1 0 0
v_max_id_clo_res 1084 1084 0 0.00 0 3423 15 0 0
v_max_id_ord_sup 6075 6075 0 0.00 0 2770 4 0 0
v_max_non_paid_invoice 1758 1758 0 0.00 0 484 3 0 0
v_max_non_paid_realizn 4305 4305 0 0.00 0 3599 4 0 0
v_min_id_clo_ord 5923 5923 0 0.00 0 2939 6 0 0
v_min_id_clo_res 1084 1084 0 0.00 0 560 3 0 0
v_min_id_ord_sup 6075 6075 0 0.00 0 4836 5 0 0
v_min_non_paid_invoice 6553 6553 0 0.00 0 4736 14 0 0
v_min_non_paid_realizn 7764 7764 0 0.00 0 7433 19 0 0
v_our_firm 11556 11556 0 0.00 0 98 1 0 0
v_reserve_write_off 21974 21974 0 0.00 0 3842 4 0 0
x_lock_depdocs_on_canc_invoice 11187 11187 0 0.00 0 38824 115 0 0
x_lock_depdocs_on_canc_sup_ord 432 432 0 0.00 0 14644 323 0 0
x_make_qstorno_1000_1200 5923 5923 0 0.00 1 27127 1146 0 0
x_make_qstorno_1200_2000 6075 6075 0 0.00 3 63770 2965 0 0
x_make_qstorno_2100_3300 509462 509462 0 0.00 0 53741 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-11-2020 16:27:59 to 13-11-2020 16:28: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
13:57:05 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:12 7283 8192000000 10124863648 10416627712 808760192 8.985 67 50 100 1 828486944 2466496 17260256
13:57:26 25914 8192000000 10303308192 10614587392 1339960352 14.057 100 80 160 0 1370671184 4139536 26571296
13:58:02 25788 8192000000 10354602496 10672734208 1393675440 14.539 100 87 174 0 1428355856 5778832 28901584
13:58:41 9545 8192000000 10373195184 10692853760 1423809168 14.806 100 88 177 1 1459636896 6623280 29204448
13:59:05 35035 8192000000 10405663536 10732093440 1454393200 15.077 100 88 176 0 1490741424 7580048 28768176
13:59:50 24713 8192000000 10424368480 10758381568 1483069264 15.328 100 91 182 0 1521186160 8539760 29577136
14:00:33 12086 8192000000 10447168848 10783580160 1501641568 15.490 100 80 160 0 1536451424 9064800 25745056
14:00:53 14879 8192000000 10472478928 10809569280 1521883648 15.667 100 83 166 1 1557373792 9317040 26173104
14:01:16 16087 8192000000 10495750912 10842091520 1548765968 15.899 100 81 162 0 1583811552 9856976 25188608
14:01:42 14174 8192000000 10521110848 10874220544 1579629136 16.165 100 78 154 1 1613096512 9906896 23560480
14:02:04 15423 8192000000 10544472240 10900492288 1601943024 16.356 100 72 143 1 1633347472 10149520 21254928
14:02:30 13202 8192000000 10575623376 10930855936 1625803040 16.559 100 79 158 1 1659500304 10234704 23462560
14:02:52 7056 8192000000 10581361552 10943463424 1640364576 16.683 100 76 152 2 1674241312 11115552 22761184
14:03:10 11440 8192000000 10607159936 10974826496 1668945984 16.924 100 74 148 1 1701636320 10922288 21768048
14:03:29 11853 8192000000 10629374144 10998448128 1683282112 17.045 100 73 145 0 1715383792 11310864 20790816
14:03:49 9577 8192000000 10642427760 11010527232 1702818720 17.209 100 79 158 2 1737857504 12667936 22370848
14:04:05 9594 8192000000 10660049312 11029131264 1714086240 17.303 100 80 160 1 1750804096 14096192 22621664
14:04:21 5470 8192000000 10666799296 11036758016 1729807840 17.434 100 86 172 2 1768593504 14259456 24526208
14:04:33 6407 8192000000 10682896544 11055128576 1737407952 17.497 100 80 158 1 1774134496 14038960 22687584
14:04:48 6318 8192000000 10681963728 11061919744 1749028816 17.594 100 81 162 0 1786402160 14055392 23317952
14:05:01 4973 8192000000 10701223520 11075293184 1763474912 17.713 100 85 171 0 1801964016 14622320 23866784
14:05:13 5692 8192000000 10717678176 11096862720 1771199936 17.777 100 86 172 3 1809258544 13916496 24142112
14:05:25 3693 8192000000 10714693952 11095474176 1778009424 17.833 100 81 162 1 1813678672 13230112 22439136
14:05:37 5718 8192000000 10725271696 11107467264 1787311840 17.910 100 80 158 1 1822244672 12998784 21934048
14:05:49 3720 8192000000 10739575744 11118936064 1795103776 17.974 100 86 172 2 1832460784 13096288 24260720
14:05:59 5407 8192000000 10730554432 11119423488 1795684672 17.978 100 80 160 0 1831001136 13142960 22173504
14:06:11 6632 8192000000 10723864384 11117309952 1799127648 18.007 100 71 140 0 1831739680 13032896 19579136
14:06:24 5856 8192000000 10754675552 11139117056 1805959904 18.063 100 79 156 1 1840112336 12208032 21944400
14:06:37 2429 8192000000 10775575568 11157536768 1827076656 18.235 100 87 173 2 1865017504 13888736 24052112
14:06:46 2213 8192000000 10764534768 11151843328 1830790096 18.266 100 79 159 1 1866856752 13299392 22767264
14:06:55 3995 8192000000 10778992304 11165356032 1837253488 18.318 100 90 182 2 1875704832 13109424 25341920
14:07:06 1878 8192000000 10789068640 11172261888 1843940176 18.373 100 95 191 0 1884184448 13587568 26656704
14:07:14 2298 8192000000 10786533680 11178127360 1847399024 18.401 100 90 179 1 1885302096 12828976 25074096
14:07:22 2052 8192000000 10791834944 11176255488 1847184176 18.399 100 89 176 0 1884763120 12713616 24865328
14:07:31 2384 8192000000 10792537568 11178725376 1852661168 18.444 100 88 175 0 1889755024 12806096 24287760
14:07:40 2003 8192000000 10792042368 11183898624 1852990768 18.446 100 86 170 2 1889839920 13071424 23777728
14:07:49 1601 8192000000 10797169072 11185885184 1856323968 18.473 100 87 175 0 1895007344 13430192 25253184
14:07:57 1737 8192000000 10802790832 11189424128 1858223760 18.489 100 94 188 1 1898112432 13940528 25948144
14:08:06 1764 8192000000 10803488352 11190829056 1857063024 18.479 100 86 174 2 1894944304 13614736 24266544
14:08:14 1879 8192000000 10801051200 11187752960 1858243024 18.489 100 90 178 0 1897107360 12838880 26025456
14:08:22 1359 8192000000 10804659568 11192107008 1859622368 18.500 100 92 184 2 1900069344 13690432 26756544
14:08:30 26787 8192000000 10793613152 11188301824 1861329088 18.514 100 69 138 2 1891251360 9716032 20206240
14:09:03 3098 8192000000 10791005248 11194744832 1864225808 18.538 100 83 165 0 1899317648 11068128 24023712
14:09:14 4670 8192000000 10800399456 11201417216 1861364176 18.514 100 59 118 0 1888480144 10641152 16474816
14:09:26 4886 8192000000 10782132000 11198124032 1863472736 18.531 100 38 74 1 1882856592 8595168 10788688
14:09:39 5356 8192000000 10785440976 11203481600 1867788864 18.566 100 35 70 0 1885770400 8031664 9949872
14:09:51 6487 8192000000 10786148176 11204710400 1873378384 18.612 100 42 84 1 1893332192 8295248 11658560
14:10:04 4921 8192000000 10799176032 11209773056 1875380384 18.628 100 49 100 3 1895365408 6542032 13442992
14:10:16 7557 8192000000 10779946448 11212390400 1873398352 18.612 100 21 41 0 1886161296 6517296 6245648
14:10:36 4861 8192000000 10795803952 11219271680 1881504928 18.677 100 29 59 1 1896196640 6556592 8135120
14:10:48 14762 8192000000 10793702352 11224821760 1884154736 18.699 100 22 44 0 1897520864 7539040 5827088
14:11:09 12696 8192000000 10792261680 11229241344 1887264912 18.724 100 12 24 1 1900313120 9765344 3282864
14:11:32 6758 8192000000 10803271792 11232092160 1892156592 18.763 100 22 43 0 1904795536 5801792 6837152
14:11:46 58202 8192000000 10829030736 11247095808 1897091904 18.803 100 42 84 2 1915131920 5523632 12516384
14:12:51 19077 8192000000 10808152992 11240878080 1895890736 18.793 100 26 53 2 1909326192 6062608 7372848
14:13:16 6758 8192000000 10825168752 11250860032 1898842400 18.817 100 33 67 0 1915938784 7854240 9242144
14:13:31 4882 8192000000 10825495920 11250868224 1901929904 18.842 100 35 70 0 1918186400 6131936 10124560
14:13:43 4848 8192000000 10828215552 11251138560 1900769440 18.832 100 29 58 0 1914778096 6127520 7881136
14:13:56 4947 8192000000 10827076944 11253194752 1902873360 18.849 100 31 62 0 1918634976 6787136 8974480
14:14:08 5496 8192000000 10819284048 11252109312 1903553456 18.855 100 28 56 2 1918437296 6841920 8041920
14:14:20 4600 8192000000 10822696080 11253305344 1904275136 18.861 100 33 65 0 1919694608 5822176 9597296
14:14:35 6554 8192000000 10822054736 11256516608 1910858816 18.914 100 30 60 0 1924796336 5176240 8761280
14:14:50 7495 8192000000 10834805760 11265826816 1912871184 18.930 100 27 54 2 1926445344 5937328 7636832
14:15:05 10223 8192000000 10827555744 11259592704 1913156656 18.932 100 15 30 0 1924536336 5798944 5580736
14:15:21 8402 8192000000 10822589632 11254493184 1902549360 18.847 100 22 45 2 1913897056 4842944 6504752
14:15:39 9505 8192000000 10802633776 11233464320 1869481664 18.580 98 18 36 2 1881524768 5899408 6143696
14:15:55 10899 8192000000 10796669120 11232448512 1860818688 18.510 98 17 34 2 1871608576 5960672 4829216
14:16:14 25605 8192000000 10797784512 11228934144 1839095584 18.333 97 23 46 2 1850274816 5263984 5915248
14:17:17 14485 8192000000 10794392464 11229917184 1851868848 18.437 98 33 66 1 1868011552 6839024 9303680
14:17:38 10210 8192000000 10772594128 11207651328 1817501920 18.157 97 19 38 1 1828510656 5728224 5280512
14:17:58 5982 8192000000 10770687664 11194560512 1827688032 18.240 98 28 56 2 1841864704 5974288 8202384
14:18:13 5621 8192000000 10748396448 11164667904 1791557952 17.945 96 29 58 1 1805405744 5647376 8200416
14:18:25 5682 8192000000 10743997504 11165478912 1780311104 17.852 96 37 74 3 1797511824 7127856 10072864
14:18:41 7244 8192000000 10748978912 11154030592 1767091872 17.743 97 29 58 0 1786228160 11151968 7984320
14:18:55 4837 8192000000 10744309168 11162951680 1822057552 18.194 100 28 55 0 1836074016 6577360 7439104
14:19:07 9088 8192000000 10685979824 11100348416 1720376944 17.355 96 13 26 0 1729169648 5055600 3737104
14:19:24 5733 8192000000 10677463600 11097214976 1733459280 17.464 97 30 58 2 1747660944 5590256 8611408
14:19:37 7516 8192000000 10696073248 11112357888 1751882240 17.617 98 26 52 4 1769271280 10284656 7104384
14:19:53 4855 8192000000 10723367968 11135422464 1796562368 17.986 100 34 67 2 1812898176 7174736 9161072
14:20:07 7066 8192000000 10722103424 11137454080 1803289792 18.041 100 33 66 1 1819255600 6036672 9929136
14:20:21 10694 8192000000 10735783712 11139043328 1756657792 17.657 97 26 52 0 1769580896 4543456 8379648
14:20:39 7756 8192000000 10739195184 11153485824 1799047840 18.006 99 22 44 1 1810837424 5455232 6334352
14:20:53 6887 8192000000 10722721264 11142877184 1795310640 17.975 99 25 50 1 1809020656 6143520 7566496
14:21:09 66333 8192000000 10737273776 11148701696 1808045536 18.080 99 22 44 0 1819715008 5866544 5802928
14:22:22 11640 8192000000 10737718848 11155931136 1810035744 18.096 99 24 48 1 1822924496 6439248 6449504
14:22:40 6567 8192000000 10749600608 11164028928 1813557984 18.125 99 35 70 3 1831069008 7383136 10127888
14:22:53 4682 8192000000 10753147968 11167240192 1820139472 18.179 99 30 60 2 1835087424 6291680 8656272
14:23:07 4604 8192000000 10755689808 11166244864 1830260544 18.261 100 44 88 1 1850399776 6766768 13372464
14:23:21 8938 8192000000 10749767760 11173781504 1837502400 18.320 100 27 54 3 1851196464 5757632 7936432
14:23:38 7226 8192000000 10753511328 11178287104 1841747456 18.355 100 29 58 1 1856409744 5322224 9340064
14:23:53 9535 8192000000 10751206336 11175047168 1822806224 18.201 99 25 50 3 1835627664 5901792 6919648
14:24:15 9201 8192000000 10754916640 11180404736 1838089472 18.325 100 19 39 1 1849065408 5637232 5338704
14:24:34 10413 8192000000 10753163024 11183128576 1829881152 18.258 99 12 24 0 1838839984 5714960 3243872
14:24:50 6304 8192000000 10767064976 11193630720 1852683504 18.444 100 22 44 2 1865142928 6309344 6150080
14:25:03 7599 8192000000 10765079840 11190374400 1851087008 18.431 100 13 26 0 1860108960 5694656 3327296
14:25:17 13677 8192000000 10764621360 11194601472 1854547504 18.459 100 15 28 1 1864634256 5343664 4743088
14:25:39 11312 8192000000 10784556528 11204874240 1863393872 18.531 100 23 46 1 1876433680 5861680 7178128
14:25:57 88592 8192000000 10798459264 11221151744 1874281696 18.619 100 32 63 3 1889947680 5309760 10356224
14:27:46 10592 8192000000 10824960352 11245699072 1895463664 18.790 100 44 88 1 1915839376 7617616 12758096
14:28:04 9217 8192000000 10840029632 11254427648 1906718192 18.880 100 52 104 0 1930760448 9830064 14212192
14:28:20 4500 8192000000 10842281936 11258691584 1912635440 18.928 100 56 109 0 1937452160 9913824 14902896
14:28:32 12467 8192000000 10859122048 11272167424 1918431104 18.974 100 58 116 1 1944642992 9981920 16229968
14:28:53 7119 8192000000 10859562176 11278413824 1927520672 19.047 100 58 116 2 1954273840 10025440 16727728
14:29:09 1881 8192000000 10864735296 11282911232 1933514048 19.095 100 62 123 2 1961542576 10629520 17399008
14:29:19 5255 8192000000 10883145296 11294715904 1939457680 19.142 100 64 125 3 1967774064 9879216 18437168
14:29:31 4578 8192000000 10870089824 11292098560 1937300640 19.125 100 58 114 1 1963858576 10760400 15797536
14:29:44 26978 8192000000 10872351696 11299586048 1936355296 19.118 100 43 86 0 1958143728 10090000 11698432
14:30:24 12203 8192000000 10882648768 11307151360 1946423136 19.198 100 56 112 0 1973172560 11020080 15729344
14:30:45 3880 8192000000 10897843232 11313770496 1953606496 19.255 100 54 108 0 1980355200 11335456 15413248
14:30:56 22697 8192000000 10884246576 11312783360 1938161584 19.132 99 51 102 0 1965246656 12566080 14518992
14:31:28 13699 8192000000 10889638720 11321995264 1957191120 19.284 100 54 107 2 1991110240 18460080 15459040
14:31:51 14723 8192000000 10889025952 11323863040 1959101696 19.299 100 45 88 3 1986848640 13755024 13991920
14:32:17 19674 8192000000 10899916608 11333984256 1963098416 19.331 100 35 68 2 1982596784 9968032 9530336
14:32:49 14299 8192000000 10900595808 11333070848 1973671904 19.415 100 52 103 1 1999604160 11315360 14616896
14:33:14 10003 8192000000 10910399680 11341139968 1975315168 19.428 100 50 99 3 2001016032 11156992 14543872
14:33:32 37306 8192000000 10912161904 11350564864 1979630576 19.462 100 44 88 1 2006715248 13739728 13344944
14:34:22 10224 8192000000 10916999696 11350020096 1979552224 19.461 100 40 79 1 2003423984 12218960 11652800
14:34:41 7310 8192000000 10908705888 11350642688 1981328032 19.475 100 44 87 3 2006736752 12366176 13042544
14:34:56 11894 8192000000 10927970928 11358736384 1984811184 19.503 100 45 89 2 2011979520 13233552 13934784
14:35:18 5182 8192000000 10929663856 11357196288 1986500480 19.516 100 65 128 2 2018542208 13344624 18697104
14:35:34 15081 8192000000 10918268256 11345768448 1965822896 19.352 99 55 108 1 1998589152 16761600 16004656
14:35:58 6651 8192000000 10935533168 11360751616 1984632016 19.501 100 59 116 1 2021136608 18614960 17889632
14:36:13 1260 8192000000 10941078336 11351797760 1975687680 19.431 99 75 149 1 2018008736 19691840 22629216
14:36:22 5122 8192000000 10945569936 11371036672 1992185088 19.561 100 69 135 3 2035165872 21941552 21039232
14:36:35 6023 8192000000 10949361616 11371622400 1993776352 19.574 100 69 138 1 2035930048 21132800 21020896
14:36:49 9975 8192000000 10938321184 11366612992 1982411392 19.484 100 58 116 1 2022663200 23091264 17160544
14:37:11 12698 8192000000 10917070048 11336753152 1960004816 19.306 99 56 112 2 1995434944 18670768 16759360
14:37:31 2493 8192000000 10944635776 11360690176 1971008448 19.393 99 80 161 2 2014288736 19595168 23685120
14:37:41 3168 8192000000 10953129840 11372027904 1994576320 19.580 100 84 171 0 2038494144 18921888 24995936
14:37:55 4223 8192000000 10947708656 11372425216 1981765456 19.479 99 71 143 0 2022139904 19350944 21023504
14:38:09 7971 8192000000 10950204960 11377676288 1998337120 19.610 100 73 145 0 2039251504 20171872 20742512
14:38:26 6366 8192000000 10966889840 11393064960 1998650576 19.612 100 64 128 0 2043437168 25977072 18809520
14:38:38 1969 8192000000 10975271184 11393585152 2006861104 19.677 100 72 143 2 2053714000 25562528 21290368
14:38:47 6888 8192000000 10950916560 11370168320 1970225408 19.387 98 76 149 2 2018526192 25401312 22899472
14:39:00 3839 8192000000 10940412896 11364577280 1971465248 19.397 99 70 138 0 2017626240 26034624 20126368
14:39:12 2788 8192000000 10960194160 11381919744 1994751264 19.581 100 82 163 2 2047243280 27224784 25267232
14:39:22 2786 8192000000 10970382112 11382882304 1999039776 19.615 100 94 184 2 2055660384 29284640 27335968
14:39:31 4392 8192000000 10967811168 11386523648 1996459728 19.595 100 79 158 0 2050120016 30156480 23503808
14:39:45 3897 8192000000 10955803440 11381350400 1993655808 19.573 100 72 144 0 2044048704 28175520 22217376
14:39:59 3281 8192000000 10962837920 11381694464 1992563488 19.564 100 69 136 0 2040917344 27907600 20446256
14:40:10 1900 8192000000 10962106768 11374665728 1986407680 19.515 100 86 166 3 2039878128 28071344 25399104
14:40:20 2914 8192000000 10932485744 11341312000 1944852000 19.185 98 75 153 2 1994497840 27333824 22312016
14:40:29 2186 8192000000 10955388160 11362713600 1975370704 19.428 100 83 165 2 2028940640 28326384 25243552
14:40:38 3115 8192000000 10928499344 11342823424 1950016880 19.227 99 86 171 1 2004934096 28603280 26313936
14:40:48 5245 8192000000 10903211264 11317862400 1901846192 18.841 97 77 152 2 1953848016 29235040 22766784
14:41:03 2227 8192000000 10935954160 11341844480 1955426112 19.270 100 84 168 0 2011306048 30914176 24965760
14:41:12 2949 8192000000 10928834336 11342249984 1958274560 19.292 100 81 161 0 2012911936 30406656 24230720
14:41:22 8204 8192000000 10912567360 11330285568 1945669712 19.192 100 68 136 2 1995772192 29940480 20162000
14:41:37 4481 8192000000 10909027024 11327283200 1934339360 19.102 99 78 155 0 1986586176 29446464 22800352
14:41:53 2644 8192000000 10903861664 11326763008 1945272768 19.189 100 67 134 2 1996531776 30756976 20502032
14:42:04 23357 8192000000 10904289376 11335401472 1928995472 19.059 99 48 94 1 1975156160 31457744 14702944
14:42:33 11968 8192000000 10898044832 11328352256 1925580800 19.032 99 43 85 1 1970546960 31113664 13852496
14:42:55 2174 8192000000 10910115840 11319431168 1921825248 19.001 98 80 156 3 1977331984 30933920 24572816
14:43:05 2732 8192000000 10921033072 11335233536 1928927520 19.058 99 70 138 1 1981749184 31983536 20838128
14:43:16 4559 8192000000 10912922192 11332218880 1942129824 19.164 100 61 122 0 1994197152 33371808 18695520
14:43:27 6239 8192000000 10901852304 11309166592 1904363568 18.861 98 65 130 0 1957880976 33957680 19559728
14:43:40 3878 8192000000 10892294672 11314110464 1917302640 18.965 99 64 129 2 1972010512 35079024 19628848
14:43:52 6191 8192000000 10913758128 11335524352 1944041808 19.179 100 66 132 1 2000256160 36187984 20026368
14:44:08 11200 8192000000 10910810528 11340050432 1947392832 19.206 100 62 124 0 2001889200 35770896 18725472
14:44:26 1982 8192000000 10915240336 11325067264 1938345728 19.134 99 77 152 1 1994259440 32062432 23851280
14:44:37 2180 8192000000 10911465360 11317903360 1927076880 19.043 99 73 146 0 1983858448 33558336 23223232
14:44:48 7137 8192000000 10906236416 11325792256 1926747200 19.041 99 71 142 1 1981600240 33195264 21657776
14:45:04 2189 8192000000 10923949440 11339116544 1947420160 19.206 100 80 159 2 2004881984 33674832 23786992
14:45:14 3367 8192000000 10869605328 11283656704 1892197792 18.763 97 66 132 1 1945603264 32973248 20432224
14:45:30 6515 8192000000 10911890432 11330088960 1940350432 19.150 100 61 122 5 1993662064 34616672 18694960
14:45:43 9208 8192000000 10917803408 11343110144 1948920176 19.218 100 51 100 0 1999927376 35779136 15228064
14:45:59 2327 8192000000 10916351968 11338661888 1945963872 19.194 100 58 116 4 2002985488 38745536 18276080
14:46:25 3763 8192000000 10917895008 11338346496 1947237024 19.204 100 62 124 0 2003020992 36870608 18913360
14:46:35 5369 8192000000 10892201584 11316576256 1922339760 19.006 99 53 106 2 1973983472 35422960 16220752
14:46:49 8348 8192000000 10879570448 11320475648 1927677840 19.048 100 24 48 1 1969050912 33931744 7441328
14:47:08 19665 8192000000 10879538304 11312881664 1919155248 18.980 100 23 46 3 1962416288 35666464 7594576
14:47:42 11594 8192000000 10894376640 11336683520 1935114688 19.108 100 35 70 1 1986650640 40615664 10920288
14:48:00 20607 8192000000 10899111584 11334864896 1921583728 19.000 99 31 61 2 1967805552 37205888 9015936
14:48:28 9434 8192000000 10921196848 11359596544 1958146112 19.291 100 45 90 3 2008145216 36405440 13593664
14:48:49 7361 8192000000 10932315232 11367317504 1961901296 19.321 100 34 68 3 2011559344 39103200 10554848
14:49:03 11591 8192000000 10918846240 11361865728 1957706032 19.288 100 40 79 0 2010930784 40944272 12280480
14:49:24 15733 8192000000 10909958192 11355791360 1955966464 19.274 100 39 78 0 2011200112 42444944 12788704
14:49:48 9259 8192000000 10922945712 11359948800 1956926816 19.282 100 41 82 0 2009899360 39760608 13211936
14:50:04 10256 8192000000 10921782080 11351658496 1940555328 19.151 99 47 92 2 1996525232 40919424 15050480
14:50:23 2681 8192000000 10951334992 11364839424 1960785984 19.312 100 77 153 1 2026777728 43197120 22794624
14:50:32 9746 8192000000 10903442288 11341234176 1940426096 19.150 99 41 81 1 1991214688 38410640 12377952
14:50:53 19976 8192000000 10922263744 11371425792 1963079552 19.331 100 32 64 1 2011795088 38257504 10458032
14:51:24 12876 8192000000 10879971696 11316744192 1905780112 18.873 97 30 60 3 1948277168 32931488 9565568
14:51:43 25419 8192000000 10900248368 11338993664 1929203600 19.061 99 25 50 2 1970276144 33073904 7998640
14:52:30 20993 8192000000 10903463536 11349417984 1943771504 19.177 100 26 52 2 1990029952 37538928 8719520
14:53:02 14764 8192000000 10910829568 11358756864 1948041632 19.211 100 18 36 3 1993443712 39085472 6316608
14:53:24 9756 8192000000 10908031712 11346427904 1942503920 19.167 100 33 66 2 1990020128 36358688 11157520
14:53:47 26168 8192000000 10915066368 11367149568 1932099904 19.084 99 20 40 0 1983682640 44010128 7572608
14:54:27 15897 8192000000 10919260832 11359240192 1929092432 19.060 99 35 69 0 1988717312 48365856 11259024
14:54:50 14972 8192000000 10915504032 11357822976 1929802352 19.065 99 31 61 1 1983013952 43076048 10135552
14:55:18 11448 8192000000 10906204704 11354140672 1930468880 19.071 99 33 66 1 1990384336 49405520 10509936
14:55:37 63212 8192000000 10901843360 11355545600 1941604496 19.160 100 24 48 1 1982462064 33169792 7687776
14:56:52 19989 8192000000 10909115776 11359698944 1945967472 19.194 100 29 58 0 1989859952 34344416 9548064
14:57:23 18542 8192000000 10899712768 11372179456 1956787184 19.280 100 14 28 1 1990488640 29397616 4303840
14:57:49 21139 8192000000 10894741680 11358093312 1934806864 19.105 99 9 18 0 1969097088 30877008 3413216
14:58:20 35844 8192000000 10892801696 11359154176 1936178016 19.116 99 15 30 0 1975962864 34799440 4985408
14:59:04 20567 8192000000 10907251472 11381022720 1956768560 19.280 100 12 24 0 1994161248 33766384 3626304
14:59:31 18084 8192000000 10914326224 11385245696 1961976736 19.322 100 7 14 0 1998998608 34901856 2120016
15:00:01 102824 8192000000 10910153712 11346845696 1945889904 19.194 99 16 32 2 1962794544 12876768 4027872
15:01:51 22517 8192000000 10940294336 11356872704 1969856320 19.384 100 53 105 1 1991085040 5887440 15341280
15:02:20 20254 8192000000 10887703936 11343568896 1950226000 19.228 99 29 57 1 1966096736 7815808 8054928
15:02:47 39974 8192000000 10896307184 11349925888 1929333776 19.062 98 8 16 2 1939949040 8028992 2586272
15:03:33 89570 8192000000 10906995168 11351040000 1934570832 19.103 98 32 65 3 1951076016 7068832 9436352
15:05:09 80916 8192000000 10909191984 11350220800 1916145760 18.956 97 31 61 1 1930982416 7183808 7652848
15:06:41 97117 8192000000 10904310592 11362488320 1955699216 19.272 99 24 48 3 1975452992 13482624 6271152
15:08:27 28524 8192000000 10915029392 11370500096 1982248320 19.482 100 13 26 2 1994527248 8823552 3455376
15:09:02 46976 8192000000 10929149040 11387408384 1991071424 19.552 100 20 40 1 2004677936 7329232 6277280
15:10:29 62548 8192000000 10922176672 11396194304 1993541680 19.572 100 14 28 2 2010197600 12880224 3775696
15:11:40 77382 8192000000 10944625088 11410362368 1999610224 19.620 100 11 22 1 2023301952 20307536 3384192
15:14:00 79385 8192000000 10960448032 11395481600 1988209920 19.530 99 44 89 2 2012027408 10904000 12913488
15:15:46 117626 8192000000 10926930720 11403296768 1988924800 19.535 99 35 71 1 2014319872 14489248 10905824
15:17:52 10119 8192000000 10921061536 11395100672 1978281856 19.451 99 21 42 0 1996733408 12524400 5927152
15:18:09 18100 8192000000 10922903632 11393466368 1979934688 19.464 99 41 82 1 2005140800 13047728 12158384
15:18:34 20120 8192000000 10917516432 11391180800 1989740624 19.542 100 12 24 0 2004865584 11805152 3319808
15:19:03 51832 8192000000 10901177920 11352834048 1913594736 18.935 96 32 64 1 1933164944 10070272 9499936
15:20:02 18520 8192000000 10919149952 11370369024 1974630688 19.422 100 39 78 2 1997183328 10399216 12153424
15:20:32 16509 8192000000 10922220832 11358724096 1951225872 19.236 99 56 112 2 1975989648 8621440 16142336
15:20:56 8938 8192000000 10904796032 11360210944 1968992048 19.377 100 46 92 0 1992740336 10527360 13220928
15:21:18 38759 8192000000 10878385040 11344175104 1928001152 19.051 98 38 76 0 1948516176 10190576 10324448
15:22:05 43501 8192000000 10861372288 11337248768 1914074864 18.939 98 20 39 1 1930506640 9792752 6639024
15:22:58 18966 8192000000 10887415728 11357380608 1962587648 19.327 100 14 27 0 1975959808 9728992 3643168
15:23:28 70011 8192000000 10897417120 11376353280 1967501136 19.366 100 8 16 1 1979858576 10053152 2304288
15:24:44 52978 8192000000 10879444576 11354058752 1895307456 18.789 96 19 38 0 1911393488 10555968 5530064
15:25:47 88247 8192000000 10883079488 11356725248 1910709680 18.912 97 27 55 1 1931986064 12257296 9019088
15:27:45 69148 8192000000 10864372640 11329187840 1874117328 18.618 96 27 54 1 1899107824 17822528 7167968
15:29:10 102412 8192000000 10848428800 11323736064 1840461536 18.345 95 14 28 1 1857261360 13349040 3450784
15:31:01 42329 8192000000 10861980928 11325968384 1889140192 18.739 97 33 64 3 1904939264 6668048 9131024
15:31:56 50872 8192000000 10856280096 11323129856 1843790592 18.372 95 25 50 0 1858833888 7835248 7208048
15:32:53 44564 8192000000 10876468928 11336298496 1909216752 18.900 98 25 51 1 1924183088 8397264 6569072
15:33:43 49813 8192000000 10883388256 11347083264 1950194304 19.228 100 40 78 1 1975913696 13529712 12189680
15:35:09 16542 8192000000 10868133024 11320008704 1907737072 18.888 98 46 90 4 1930275664 9247904 13290688
15:35:38 20975 8192000000 10885739968 11333791744 1924550656 19.023 99 34 68 2 1945348288 10937648 9859984
15:36:11 25603 8192000000 10877114784 11333804032 1921476192 18.999 99 32 63 1 1942007920 11736864 8794864
15:36:46 73100 8192000000 10852322912 11303333888 1823563168 18.207 94 19 38 1 1841252688 11617616 6071904
15:38:12 55939 8192000000 10875663936 11326820352 1894326608 18.781 98 24 47 3 1912028832 10914784 6787440
15:39:17 119253 8192000000 10835710528 11294322688 1765283168 17.728 91 15 30 2 1786182256 16290304 4608784
15:41:30 68780 8192000000 10875381728 11328409600 1895235952 18.788 98 25 48 0 1911360272 9477408 6646912
15:42:45 75377 8192000000 10880333856 11347116032 1897779840 18.808 98 13 26 0 1916420896 15123152 3517904
15:44:07 114444 8192000000 10882414816 11330629632 1908159328 18.892 98 31 62 1 1935801920 19017088 8625504
15:46:42 62097 8192000000 10866005824 11327930368 1922890192 19.010 99 22 44 0 1938113728 9198336 6025200
15:48:51 56083 8192000000 10847298016 11321536512 1910647216 18.912 98 21 42 1 1925998896 8837184 6514496
15:49:56 23180 8192000000 10858464080 11330158592 1932386272 19.086 99 9 18 1 1942713872 8013616 2313984
15:50:28 40584 8192000000 10865037152 11336503296 1934196496 19.100 99 27 55 0 1949134800 7911744 7026560
15:51:17 58881 8192000000 10887168432 11349585920 1939852064 19.146 99 19 38 0 1955308672 9851232 5605376
15:52:25 70749 8192000000 10875934960 11356643328 1958070752 19.291 100 15 30 2 1974134736 10986976 5077008
15:54:01 66422 8192000000 10897518000 11379007488 1968786736 19.376 100 18 36 1 1988974928 14881040 5307152
15:55:14 51563 8192000000 10885430032 11361464320 1931245952 19.077 98 8 16 1 1946877600 13201504 2430144
15:56:12 36827 8192000000 10902610560 11366408192 1971470752 19.397 100 16 32 0 1984056448 7902240 4683456
15:57:00 23747 8192000000 10916709328 11368042496 1946298720 19.197 98 37 74 2 1966827184 9234880 11293584
15:57:33 25660 8192000000 10913337296 11374366720 1969346432 19.380 99 34 66 0 1988957920 10315296 9296192
15:58:06 49501 8192000000 10917058400 11386576896 1968234032 19.371 99 23 46 1 1985907056 11597248 6075776
15:59:03 62222 8192000000 10912962528 11373703168 1926115968 19.036 97 14 28 1 1938935440 9598320 3221152
16:00:15 62593 8192000000 10906858144 11379564544 1981197232 19.474 100 20 40 1 1997243728 11021168 5025328
16:01:25 34074 8192000000 10940102032 11391770624 1975007984 19.425 99 44 88 0 1998275584 10778384 12489216
16:02:05 43209 8192000000 10928572400 11405365248 1994657232 19.581 100 26 52 1 2016014224 14712384 6644608
16:03:03 56609 8192000000 10925347376 11375837184 1903519008 18.855 95 20 40 0 1917986848 9217792 5250048
16:04:12 60987 8192000000 10885883152 11342344192 1853594496 18.451 94 22 44 0 1867371504 7589696 6187312
16:05:19 10874 8192000000 10911426848 11354828800 1959409968 19.301 100 29 58 0 1979069088 12078944 7580176
16:05:41 14054 8192000000 10902662000 11351289856 1923494336 19.015 98 35 70 1 1946225872 13408944 9322592
16:06:01 30038 8192000000 10885876144 11350638592 1937400480 19.126 99 34 68 1 1960330528 13420320 9509728
16:06:42 90159 8192000000 10895495232 11380613120 1924743936 19.025 98 15 30 2 1943164720 14248224 4172560
16:08:18 54775 8192000000 10868678880 11349323776 1885421664 18.709 96 7 14 0 1905737328 18137216 2178448
16:09:20 124581 8192000000 10839501552 11301056512 1800728608 18.020 92 17 34 1 1819706752 14100960 4877184
16:11:37 71290 8192000000 10864134624 11335987200 1922750784 19.009 99 29 58 2 1943227392 11983200 8493408
16:12:55 29003 8192000000 10847857664 11326853120 1907701552 18.888 99 5 10 0 1919564384 10392576 1470256
16:13:34 52814 8192000000 10861759632 11339112448 1925265056 19.029 99 11 22 0 1940401104 12112480 3023568
16:15:31 52985 8192000000 10849297856 11326713856 1871011344 18.592 96 12 24 0 1891114512 16583824 3519344
16:16:30 56268 8192000000 10850518000 11321978880 1891120016 18.755 98 20 40 1 1914308128 17832128 5355984
16:17:39 101301 8192000000 10855651456 11334397952 1891379824 18.757 98 13 27 0 1911714480 16187856 4146800
16:19:26 63209 8192000000 10823006640 11294081024 1824953696 18.218 95 18 36 0 1849793840 19212320 5627824
16:21:06 53817 8192000000 10817231360 11270385664 1829120448 18.252 96 21 42 1 1846027440 10836048 6070944
16:22:12 66888 8192000000 10815323616 11287642112 1855977152 18.471 98 16 32 0 1868731504 8211504 4542848
16:23:26 42753 8192000000 10844114368 11299033088 1839217104 18.334 96 28 56 1 1859191296 12035792 7938400
16:24:57 57506 8192000000 10841860352 11327188992 1918205920 18.972 100 21 42 2 1941578688 16925312 6447456
16:26:02 65934 8192000000 8965178000 9324556288 66194320 0.801 4 1 2 0 66581552 320224 67008

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 13-11-2020 16:28:05 to 13-11-2020 16:28:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 156 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-11-2020 16:28:39 to 13-11-2020 16:28:41.

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          252287
MON$OLDEST_ACTIVE               252288
MON$OLDEST_SNAPSHOT             252288
MON$NEXT_TRANSACTION            252288
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                       2040800
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
--- end of diff output ---

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

13.11.20 16:28:42. 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-11-13 16:28:44 No severe PSQL-related problems occured
13.11.20 16:28:46. End of report.