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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16995952 kB
MemAvailable 31433976 kB
Buffers 0 kB
Cached 14655572 kB
SwapCached 4252 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-17 22:27:03
DTS_END                         2020-11-17 22:27:03.2940
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_MONEY_SALDO(33:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44080
TRN_ID                          249037
ATT_ID                          736
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: 9890.88 27432 1186906
customer order: creation 176.48 349 21177
customer order: refuse 15.08 330 1809
order to supplier: creation 47.98 1163 5758
order to supplier: removal 3.49 112556 419
invoice (draft): creation 46.63 3168 5595
invoice (draft): removal 57.13 818 6856
invoice accept: apply 44.11 17769 5293
invoice accept: cancel 51.88 785 6226
customer reserve: creation 4055.35 175 486642
customer reserve: removal 5074.23 60 608907
realization accept: apply 86.43 204 10372
realization accept: cancel 96.55 110 11586
payment from customer: creation 62.19 119 7463
payment from customer: removal 6.04 93 725
payment to supplier: creation 50.97 135 6116
payment to supplier: removal 3.78 118 454
service: total inventory turnovers 4.84 1256 581
service: total monetary turnovers 6.89 54 827
service: aggregate perf. data 0.80 23785 96
service: refresh index statistics 0.03 385602 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-11-2020 22:28:04 to 17-11-2020 22:28:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5179
TEST_TIME 2 3009
TEST_TIME 3 3426
TEST_TIME 4 3589
TEST_TIME 5 5202
TEST_TIME 6 5343
TEST_TIME 7 5047
TEST_TIME 8 5996
TEST_TIME 9 6630
TEST_TIME 10 7019
TEST_TIME 11 7051
TEST_TIME 12 7327
TEST_TIME 13 7879
TEST_TIME 14 8040
TEST_TIME 15 8457
TEST_TIME 16 8655
TEST_TIME 17 8810
TEST_TIME 18 8858
TEST_TIME 19 9083
TEST_TIME 20 9031
TEST_TIME 21 9009
TEST_TIME 22 9056
TEST_TIME 23 9558
TEST_TIME 24 9513
TEST_TIME 25 9473
TEST_TIME 26 10145
TEST_TIME 27 10362
TEST_TIME 28 10805
TEST_TIME 29 11374
TEST_TIME 30 11826
TEST_TIME 31 11855
TEST_TIME 32 11709
TEST_TIME 33 11609
TEST_TIME 34 11528
TEST_TIME 35 11438
TEST_TIME 36 11348
TEST_TIME 37 11276
TEST_TIME 38 11085
TEST_TIME 39 11145
TEST_TIME 40 10974
TEST_TIME 41 10887
TEST_TIME 42 11003
TEST_TIME 43 10991
TEST_TIME 44 10926
TEST_TIME 45 10727
TEST_TIME 46 10646
TEST_TIME 47 10675
TEST_TIME 48 10544
TEST_TIME 49 10545
TEST_TIME 50 10442
TEST_TIME 51 10359
TEST_TIME 52 10276
TEST_TIME 53 10165
TEST_TIME 54 10355
TEST_TIME 55 10293
TEST_TIME 56 10281
TEST_TIME 57 10295
TEST_TIME 58 10215
TEST_TIME 59 10273
TEST_TIME 60 10252
TEST_TIME 61 10271
TEST_TIME 62 10312
TEST_TIME 63 10346
TEST_TIME 64 10331
TEST_TIME 65 10343
TEST_TIME 66 10345
TEST_TIME 67 10280
TEST_TIME 68 10394
TEST_TIME 69 10391
TEST_TIME 70 10391
TEST_TIME 71 10439
TEST_TIME 72 10383
TEST_TIME 73 10375
TEST_TIME 74 10276
TEST_TIME 75 10204
TEST_TIME 76 10228
TEST_TIME 77 10184
TEST_TIME 78 10120
TEST_TIME 79 10107
TEST_TIME 80 10153
TEST_TIME 81 10133
TEST_TIME 82 10057
TEST_TIME 83 9972
TEST_TIME 84 10043
TEST_TIME 85 10047
TEST_TIME 86 10082
TEST_TIME 87 10066
TEST_TIME 88 10016
TEST_TIME 89 10011
TEST_TIME 90 10040
TEST_TIME 91 10030
TEST_TIME 92 10057
TEST_TIME 93 10151
TEST_TIME 94 10172
TEST_TIME 95 10143
TEST_TIME 96 10191
TEST_TIME 97 10217
TEST_TIME 98 10232
TEST_TIME 99 10181
TEST_TIME 100 10114
TEST_TIME 101 10141
TEST_TIME 102 10124
TEST_TIME 103 10058
TEST_TIME 104 10006
TEST_TIME 105 10010
TEST_TIME 106 9991
TEST_TIME 107 9972
TEST_TIME 108 9976
TEST_TIME 109 9910
TEST_TIME 110 9947
TEST_TIME 111 9895
TEST_TIME 112 9918
TEST_TIME 113 9913
TEST_TIME 114 9924
TEST_TIME 115 9907
TEST_TIME 116 9930
TEST_TIME 117 9895
TEST_TIME 118 9924
TEST_TIME 119 9979
TEST_TIME 120 9898

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 17-11-2020 22:28:07 to 17-11-2020 22:28:11.

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 1636112 1636112 0 0.00 0 27179 6 0 0
doc_list_biud 1636110 1636110 0 0.00 0 52708 28 0 0
sp_add_invoice_to_stock 5410 5293 117 2.16 38 185359 17769 0 117
sp_cancel_adding_invoice 6226 6226 0 0.00 5 72184 786 0 0
sp_cancel_client_order 1809 1809 0 0.00 4 10706 330 0 0
sp_cancel_customer_reserve 608907 608907 0 0.00 1 52710 60 0 0
sp_cancel_pay_from_customer 725 725 0 0.00 2 7185 93 0 0
sp_cancel_pay_to_supplier 454 454 0 0.00 3 7455 119 0 0
sp_cancel_supplier_invoice 6860 6856 4 0.05 2 27530 818 0 4
sp_cancel_supplier_order 419 419 0 0.00 7 1166103 112557 0 0
sp_cancel_write_off 11586 11586 0 0.00 1 22057 111 0 0
sp_client_order 21177 21177 0 0.00 3 15249 349 0 0
sp_customer_reserve 486642 486642 0 0.00 0 87782 176 0 0
sp_fill_shopping_cart 32530 32530 0 0.00 1 28174 40 0 0
sp_fill_shopping_cart_clo_res 486642 486642 0 0.00 0 21218 13 0 0
sp_get_clo_for_invoice 5277 5277 0 0.00 0 37644 264 0 0
sp_kill_cost_storno 18991 18991 0 0.00 0 22052 57 0 0
sp_kill_qstorno_ret_qs2qd 1236675 1236675 0 0.00 0 52703 32 0 0
sp_kill_qty_storno 651451 651451 0 0.00 0 52708 70 0 0
sp_lock_selected_doc 21699 21699 0 0.00 0 8503 5 0 0
sp_make_cost_storno 29228 29228 0 0.00 0 27159 74 0 0
sp_multiply_rows_for_pdistr 29226 29226 0 0.00 0 5753 26 0 0
sp_multiply_rows_for_qdistr 21177 21177 0 0.00 0 15026 157 0 0
sp_pay_from_customer 7463 7463 0 0.00 4 19463 120 0 0
sp_pay_to_supplier 6116 6116 0 0.00 4 18548 136 0 0
sp_payment_common 13578 13578 0 0.00 1 17787 29 0 0
sp_qd_handle_on_cancel_clo 1809 1809 0 0.00 0 10698 295 0 0
sp_qd_handle_on_invoice_upd_sts 11502 11502 0 0.00 0 44296 358 0 0
sp_qd_handle_on_reserve_upd_sts 10372 10372 0 0.00 0 16307 62 0 0
sp_reserve_write_off 10372 10372 0 0.00 6 27186 204 0 0
sp_supplier_invoice 5595 5595 0 0.00 6 99367 3169 0 0
sp_supplier_order 5758 5758 0 0.00 5 29275 1164 0 0
srv_aggregate_perf_data 97 96 1 1.03 2683 412280 23785 0 1
srv_fill_mon_cache_memory 173 173 0 0.00 1092 147695 30361 0 0
srv_find_qd_qs_mism 1136402 1136402 0 0.00 0 20080 5 0 0
srv_make_invnt_saldo 581 581 0 0.00 21 66667 1257 0 0
srv_make_money_saldo 827 827 0 0.00 1 16842 54 0 0
srv_recalc_idx_stat 4 4 0 0.00 331308 438959 385602 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5293 5293 0 0.00 0 12323 172 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 5810 83 0 0
t$perf-norm:sp_cancel_client_order 1809 1809 0 0.00 0 1334 11 0 0
t$perf-norm:sp_cancel_customer_reserve 701 701 0 0.00 0 1603 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 725 725 0 0.00 0 4119 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 454 454 0 0.00 0 3130 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 431 431 0 0.00 0 705 11 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 25014 1699 0 0
t$perf-norm:sp_cancel_write_off 1087 1087 0 0.00 0 3956 14 0 0
t$perf-norm:sp_client_order 21177 21177 0 0.00 0 11880 18 0 0
t$perf-norm:sp_customer_reserve 1084 1084 0 0.00 0 1159 7 0 0
t$perf-norm:sp_pay_from_customer 7463 7463 0 0.00 0 4545 9 0 0
t$perf-norm:sp_pay_to_supplier 6116 6116 0 0.00 0 10733 17 0 0
t$perf-norm:sp_reserve_write_off 10372 10372 0 0.00 0 7670 9 0 0
t$perf-norm:sp_supplier_invoice 5595 5595 0 0.00 0 12851 18 0 0
t$perf-norm:sp_supplier_order 5758 5758 0 0.00 0 18085 20 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 535 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 134 3 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 756 17 0 0
t$perf-norm:srv_make_money_saldo 827 827 0 0.00 0 2913 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 11 5 0 0
v_add_invoice_to_stock 10774 10540 234 2.17 0 7050 19 0 234
v_all_customers 38916 38916 0 0.00 0 19 1 0 0
v_all_suppliers 31722 31722 0 0.00 0 22 1 0 0
v_all_wares 42354 42354 0 0.00 0 88 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 6887 16 0 0
v_cancel_client_order 3618 3618 0 0.00 0 3252 6 0 0
v_cancel_customer_prepayment 1450 1450 0 0.00 0 7156 14 0 0
v_cancel_customer_reserve 1402 1402 0 0.00 0 1828 5 0 0
v_cancel_payment_to_supplier 908 908 0 0.00 0 7449 24 0 0
v_cancel_supplier_invoice 870 862 8 0.91 0 1929 16 0 8
v_cancel_supplier_order 838 838 0 0.00 0 3629 14 0 0
v_cancel_write_off 2174 2174 0 0.00 0 1973 15 0 0
v_max_id_clo_ord 5758 5758 0 0.00 0 931 1 0 0
v_max_id_clo_res 1084 1084 0 0.00 0 912 3 0 0
v_max_id_ord_sup 5595 5595 0 0.00 0 5040 4 0 0
v_max_non_paid_invoice 1606 1606 0 0.00 0 10839 10 0 0
v_max_non_paid_realizn 3877 3877 0 0.00 0 2791 5 0 0
v_min_id_clo_ord 5758 5758 0 0.00 0 9303 9 0 0
v_min_id_clo_res 1084 1084 0 0.00 0 1068 5 0 0
v_min_id_ord_sup 5595 5595 0 0.00 0 7041 8 0 0
v_min_non_paid_invoice 6114 6114 0 0.00 0 6752 16 0 0
v_min_non_paid_realizn 7463 7463 0 0.00 0 6708 16 0 0
v_our_firm 10610 10610 0 0.00 0 22 1 0 0
v_reserve_write_off 20744 20744 0 0.00 0 8869 8 0 0
x_lock_depdocs_on_canc_invoice 12651 12651 0 0.00 0 14027 125 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 12279 449 0 0
x_make_qstorno_1000_1200 5758 5758 0 0.00 1 29246 1082 0 0
x_make_qstorno_1200_2000 5595 5595 0 0.00 3 99265 3029 0 0
x_make_qstorno_2100_3300 486642 486642 0 0.00 0 87780 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-11-2020 22:28:12 to 17-11-2020 22:28:16.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:13 27640 8192000000 10296873712 10607058944 1038773184 11.253 77 65 130 0 1062754528 3225584 20755760
19:57:50 13112 8192000000 10326886400 10642890752 1389115264 14.498 100 89 178 0 1424036032 5417952 29502816
19:58:15 21014 8192000000 10368608368 10691260416 1417332432 14.749 100 84 168 0 1451742320 6203600 28206288
19:58:45 13125 8192000000 10396821872 10724573184 1456532432 15.095 100 85 170 0 1490887024 7093936 27260656
19:59:11 17248 8192000000 10421209568 10751066112 1474706528 15.255 100 88 176 0 1511324064 8078464 28539072
19:59:43 23913 8192000000 10445835408 10778574848 1497568096 15.455 100 92 184 1 1536518880 8916960 30033824
20:00:16 8797 8192000000 10455076592 10790830080 1509114272 15.556 100 88 176 0 1546550288 9063344 28372672
20:00:45 15320 8192000000 10481701776 10825621504 1538559712 15.811 100 87 175 2 1575112816 9343760 27209344
20:01:19 19519 8192000000 10509588224 10860122112 1560592752 16.001 100 77 154 1 1594978496 9780880 24604864
20:01:46 17026 8192000000 10536325568 10888568832 1588614592 16.242 100 81 162 0 1623592560 10036544 24941424
20:02:16 18411 8192000000 10570463216 10925461504 1620203440 16.512 100 83 166 1 1656204224 10178992 25821792
20:02:46 12946 8192000000 10588204400 10948141056 1644132656 16.715 100 77 153 2 1678508752 11200384 23175712
20:03:12 10869 8192000000 10607822336 10972319744 1663904864 16.882 100 81 162 1 1700068592 12112736 24050992
20:03:33 10085 8192000000 10624184816 10991210496 1678984960 17.009 100 75 150 0 1712513184 11741392 21786832
20:03:51 8058 8192000000 10632482064 11002187776 1699365232 17.180 100 79 158 1 1734741296 12363504 23012560
20:04:11 12129 8192000000 10653417408 11030691840 1721870704 17.368 100 84 168 1 1758534608 12509520 24154384
20:04:33 11510 8192000000 10680850032 11057278976 1733875440 17.468 100 75 151 1 1767852464 12693088 21283936
20:04:53 5972 8192000000 10688246480 11063214080 1750616064 17.607 100 82 164 3 1787725520 13713872 23395584
20:05:05 4807 8192000000 10703403072 11076616192 1758481024 17.672 100 89 178 0 1797585056 14055632 25048400
20:05:17 4920 8192000000 10702705520 11082522624 1763249584 17.711 100 79 158 2 1799066816 13629520 22187712
20:05:30 3472 8192000000 10708594624 11088678912 1771594000 17.780 100 77 154 0 1806551840 13797904 21159936
20:05:40 3803 8192000000 10714954128 11097751552 1779287200 17.844 100 83 165 0 1816530992 14096752 23147040
20:05:50 4091 8192000000 10728199536 11106459648 1785629504 17.896 100 94 189 1 1826232112 14564160 26038448
20:06:01 8386 8192000000 10726758672 11110490112 1785200176 17.892 100 77 154 0 1821271664 14737216 21334272
20:06:16 4893 8192000000 10727961872 11110637568 1792361008 17.951 100 77 155 2 1828336688 14307536 21668144
20:06:28 2583 8192000000 10752465488 11136290816 1812792704 18.119 100 80 159 2 1848701552 13485904 22422944
20:06:37 3168 8192000000 10753608368 11143364608 1814614928 18.134 100 73 146 2 1847688800 12452448 20621424
20:06:46 3170 8192000000 10764560976 11154255872 1831808272 18.274 100 91 182 1 1871201920 13476608 25917040
20:06:56 2356 8192000000 10769856736 11155574784 1834814528 18.299 100 91 180 2 1873349008 13592208 24942272
20:07:04 2159 8192000000 10779272672 11164393472 1835856736 18.307 100 86 172 1 1873891568 13956912 24077920
20:07:13 1873 8192000000 10781793024 11170750464 1844542384 18.378 100 91 180 2 1883514416 13106032 25866000
20:07:21 2950 8192000000 10790289696 11179212800 1847109408 18.399 100 91 182 1 1885229872 12720352 25400112
20:07:30 1121 8192000000 10801336192 11190419456 1853380496 18.450 100 95 194 2 1897082320 17182992 26518832
20:07:38 1247 8192000000 10802764240 11189444608 1857024288 18.479 100 96 192 2 1896429984 12594048 26811648
20:07:45 3304 8192000000 10803443968 11192987648 1858297552 18.489 100 89 177 0 1897078272 13753680 25027040
20:07:55 1973 8192000000 10806973888 11196334080 1863239008 18.530 100 89 178 0 1900312352 12139328 24934016
20:08:04 1969 8192000000 10816972016 11202637824 1867714144 18.566 100 95 191 4 1907683456 12946096 27023216
20:08:12 1807 8192000000 10812537872 11200966656 1868838240 18.575 100 93 188 1 1907679232 11604368 27236624
20:08:20 16226 8192000000 10781873408 11207364608 1867886688 18.567 100 61 122 0 1896808720 12619680 16302352
20:08:47 18010 8192000000 10814880768 11215286272 1873242752 18.611 100 68 137 1 1901693488 8994224 19456512
20:09:11 2936 8192000000 10806367680 11222847488 1882446816 18.685 100 67 134 3 1912666576 10709024 19510736
20:09:23 4091 8192000000 10790021184 11217100800 1879769984 18.663 100 38 76 2 1900013680 9161264 11082432
20:09:34 7348 8192000000 10791960528 11220611072 1880063744 18.666 100 25 50 2 1893378736 6568976 6746016
20:09:49 8963 8192000000 10798246528 11225559040 1881108592 18.674 100 28 55 2 1900785040 11661712 8014736
20:10:09 7416 8192000000 10800321488 11229118464 1887967808 18.729 100 36 72 1 1914256224 16787776 9500640
20:10:23 8452 8192000000 10793945088 11223543808 1885778464 18.712 100 28 56 1 1900528544 7095888 7654192
20:10:39 13340 8192000000 10793283936 11228016640 1884004336 18.697 100 18 36 2 1898846368 10466448 4375584
20:10:58 7323 8192000000 10800749408 11229290496 1890865472 18.753 100 35 71 1 1908467344 6342864 11259008
20:11:12 5970 8192000000 10800018544 11231055872 1888736480 18.736 100 22 44 1 1902477648 6872720 6868448
20:11:27 6789 8192000000 10787211024 11225944064 1888081776 18.730 100 12 23 3 1897154416 5641072 3431568
20:11:40 8112 8192000000 10791177808 11229425664 1891050768 18.754 100 17 34 2 1902163472 5741072 5371632
20:11:55 14441 8192000000 10802833264 11238809600 1894098752 18.779 100 6 12 0 1900967632 5372240 1496640
20:12:15 52964 8192000000 10811098400 11252989952 1901604112 18.839 100 20 40 1 1913833840 6040080 6189648
20:13:16 31755 8192000000 10818632000 11257626624 1908641280 18.896 100 23 46 0 1921135920 6163728 6330912
20:13:54 5927 8192000000 10827524624 11262132224 1910344768 18.909 100 29 59 1 1925265776 7284176 7636832
20:14:10 3888 8192000000 10833657888 11264987136 1912581296 18.927 100 32 64 2 1928943808 7650640 8711872
20:14:22 6397 8192000000 10845588576 11272089600 1912440944 18.926 100 32 63 1 1931645616 10539216 8665456
20:14:39 7144 8192000000 10820289312 11259199488 1897597200 18.807 99 21 41 5 1908899216 5398976 5903040
20:14:52 5302 8192000000 10822324352 11256885248 1890136608 18.747 99 21 43 3 1901902960 5993184 5773168
20:15:05 7187 8192000000 10823532784 11262554112 1907308784 18.885 100 22 44 1 1919935840 6219936 6407120
20:15:20 8613 8192000000 10837024128 11270746112 1914657280 18.944 100 25 49 3 1927854832 5630768 7566784
20:15:38 10399 8192000000 10835599456 11268874240 1913628288 18.936 100 18 36 1 1924208896 5845872 4734736
20:16:00 10618 8192000000 10831123888 11262910464 1911158208 18.916 100 25 50 1 1924246032 5336624 7751200
20:16:17 12963 8192000000 10819229952 11250057216 1884826400 18.704 99 14 28 1 1894520928 5691328 4003200
20:16:36 9252 8192000000 10810453968 11247951872 1885945440 18.713 99 19 38 0 1897071664 5559168 5567056
20:16:54 10829 8192000000 10794407232 11224125440 1821843776 18.193 96 19 38 1 1832639776 5273248 5522752
20:17:12 57162 8192000000 10792112784 11215732736 1820043680 18.178 96 48 96 3 1840381456 5599312 14738464
20:18:16 11902 8192000000 10773115744 11205668864 1816412240 18.148 97 22 44 1 1828429296 5421056 6596000
20:18:34 7769 8192000000 10767549936 11199496192 1844658576 18.379 99 25 50 3 1858263696 6549040 7056080
20:18:48 2426 8192000000 10773602800 11191222272 1836293760 18.311 99 48 95 2 1855472352 5199408 13979184
20:18:56 5803 8192000000 10756249248 11175370752 1811002192 18.104 98 32 64 0 1827059472 7044912 9012368
20:19:08 5808 8192000000 10747771568 11173613568 1820982576 18.186 98 31 62 1 1837074320 7323296 8768448
20:19:20 7612 8192000000 10714271712 11131691008 1728861920 17.426 94 25 49 1 1741331952 5342624 7127408
20:19:35 5319 8192000000 10696546064 11105193984 1729914784 17.435 96 40 80 3 1748795024 7652112 11228128
20:19:48 7013 8192000000 10718718128 11133698048 1758195488 17.669 97 20 40 0 1770292576 6227968 5869120
20:20:02 6099 8192000000 10685154320 11091369984 1732033216 17.452 97 27 54 1 1744333568 4787680 7512672
20:20:14 8768 8192000000 10662862208 11059847168 1670958848 16.941 94 25 50 2 1683462832 4887344 7616640
20:20:30 6621 8192000000 10694083040 11100004352 1750166432 17.603 99 19 38 1 1760383280 4728064 5488784
20:20:46 7888 8192000000 10710911584 11119992832 1758164816 17.669 98 29 58 2 1772626016 5751472 8709728
20:20:59 9911 8192000000 10710519088 11123322880 1750604560 17.607 97 32 64 2 1766565264 5670192 10290512
20:21:15 10232 8192000000 10696076064 11114827776 1753943520 17.634 98 18 36 2 1768746160 9749216 5053424
20:21:35 9883 8192000000 10707786624 11121930240 1762463008 17.705 98 19 38 3 1773804144 5223536 6117600
20:21:51 17256 8192000000 10727723136 11136339968 1771757888 17.782 98 28 57 0 1787646800 5257120 10631792
20:22:14 76941 8192000000 10736220752 11157061632 1807721472 18.077 99 33 66 1 1822333472 5251648 9360352
20:23:38 6117 8192000000 10737791120 11165999104 1825523344 18.223 100 19 34 1 1836308752 6043600 4741808
20:23:51 7705 8192000000 10745789664 11167170560 1829262640 18.253 100 30 62 2 1844303840 6617296 8423904
20:24:09 9993 8192000000 10756753648 11177472000 1837166816 18.318 100 27 52 1 1851661456 7104192 7390448
20:24:25 5516 8192000000 10752504960 11173384192 1837861488 18.323 100 23 45 2 1850953808 5567744 7524576
20:24:39 9205 8192000000 10766761456 11183820800 1843927520 18.373 100 32 63 1 1859823824 5749408 10146896
20:24:57 5167 8192000000 10757847824 11183411200 1844539856 18.378 100 20 40 0 1855928432 5527744 5860832
20:25:13 9111 8192000000 10768703264 11190296576 1848492560 18.410 100 24 47 1 1861281440 4937312 7851568
20:25:31 11412 8192000000 10764312864 11191042048 1850375216 18.425 100 13 26 0 1859932032 5848320 3708496
20:25:50 11082 8192000000 10773396320 11194810368 1853356384 18.449 100 19 38 2 1866074688 5275904 7442400
20:26:08 15161 8192000000 10766140624 11194322944 1852480176 18.442 100 13 26 0 1861736720 4962080 4294464
20:26:31 7015 8192000000 10778308032 11203289088 1859666432 18.501 100 27 53 2 1873669664 6739200 7264032
20:26:44 15964 8192000000 10779035152 11198423040 1859712704 18.501 100 18 36 1 1870282208 5099248 5470256
20:27:07 53972 8192000000 10816946160 11233247232 1880308048 18.668 100 34 68 1 1895870832 6166576 9396208
20:28:09 10438 8192000000 10836277728 11245301760 1896270000 18.796 100 53 103 2 1920820320 10105312 14445008
20:28:31 147694 8192000000 10839000624 11270717440 1892648320 18.767 99 39 78 1 1915137904 11731216 10758368
20:31:12 10785 8192000000 10854439776 11279835136 1923406192 19.014 100 34 67 1 1945082272 12495728 9180352
20:31:31 1558 8192000000 10870144496 11288330240 1934673904 19.104 100 63 118 5 1964980592 12540000 17766688
20:31:39 5104 8192000000 10886422288 11302264832 1942872208 19.170 100 73 145 0 1980511456 16430592 21208656
20:32:00 8493 8192000000 10890602560 11311755264 1945802144 19.193 100 59 118 0 1981588784 18418704 17367936
20:32:17 9082 8192000000 10885968112 11315724288 1945266032 19.189 100 48 97 0 1980304256 20217376 14820848
20:32:38 14148 8192000000 10868856192 11311353856 1946256560 19.197 100 35 70 1 1971340160 15274704 9808896
20:32:58 11978 8192000000 10877515552 11312173056 1947603296 19.207 100 41 81 0 1974512640 15114624 11794720
20:33:19 9493 8192000000 10897413392 11323424768 1955142320 19.267 100 41 82 1 1982967008 15255840 12568848
20:33:40 17985 8192000000 10894849488 11324268544 1960285008 19.308 100 42 84 2 1986848080 14136640 12426432
20:34:08 39831 8192000000 10903161824 11337637888 1963876400 19.337 100 41 81 3 1993694496 17919648 11898448
20:34:55 3804 8192000000 10918988992 11344855040 1972215552 19.403 100 53 106 1 2009152352 21003696 15933104
20:35:05 2908 8192000000 10933068752 11349958656 1974523152 19.421 100 75 149 0 2019099152 22417184 22158816
20:35:15 9267 8192000000 10931230896 11351572480 1975809040 19.432 100 69 140 1 2017509952 21555920 20144992
20:35:32 3102 8192000000 10934003008 11351953408 1975783616 19.431 100 61 122 1 2015773760 22028176 17961968
20:35:43 7938 8192000000 10932696240 11355795456 1979282032 19.459 100 65 130 1 2018715760 20937696 18496032
20:35:58 1865 8192000000 10944963568 11360296960 1988109104 19.529 100 86 172 0 2034689808 21468384 25112320
20:36:09 1761 8192000000 10949422736 11365048320 1989704720 19.541 100 89 179 0 2038815408 23078240 26032448
20:36:17 11201 8192000000 10940252944 11365613568 1985748448 19.510 100 69 136 1 2026946656 21863120 19335088
20:36:41 6291 8192000000 10945972368 11371339776 1989324768 19.538 100 65 130 0 2032772576 24750048 18697760
20:36:54 2473 8192000000 10950249584 11373821952 1992838464 19.566 100 72 144 1 2037550096 22633968 22077664
20:37:05 2069 8192000000 10950939152 11364405248 1985761248 19.510 100 77 152 0 2031328816 23226688 22340880
20:37:15 3397 8192000000 10953850320 11372122112 1986842080 19.519 100 69 138 0 2034013600 26460256 20711264
20:37:27 3656 8192000000 10951478064 11375480832 1980750768 19.471 99 81 162 1 2031008128 26022336 24235024
20:37:37 3901 8192000000 10961992560 11383357440 1997904896 19.606 100 74 147 0 2045467968 26026928 21536144
20:37:49 3103 8192000000 10965235312 11385458688 2002139696 19.640 100 74 147 0 2053799744 29638816 22021232
20:37:59 2181 8192000000 10965600256 11379712000 1981529264 19.477 99 71 142 1 2032432432 29510512 21392656
20:38:08 3605 8192000000 10938158544 11354783744 1948462320 19.214 98 78 154 0 2000505664 28960544 23082800
20:38:18 2820 8192000000 10949502800 11370590208 1984182912 19.498 100 76 153 2 2037317344 30178384 22956048
20:38:29 6130 8192000000 10944902784 11370364928 1980522832 19.469 100 65 129 1 2031481344 31266128 19692384
20:38:49 1901 8192000000 10960008272 11372507136 1985636352 19.509 100 69 135 2 2037983952 31754128 20593472
20:39:06 10636 8192000000 10973820880 11395465216 1993786976 19.574 100 64 128 1 2049699680 36455696 19457008
20:39:26 11281 8192000000 10966135072 11394375680 1991115328 19.553 100 60 121 3 2050052768 40720432 18217008
20:39:46 11404 8192000000 10956275872 11392040960 1993576800 19.572 100 48 96 0 2041251264 33538448 14136016
20:40:08 6586 8192000000 10955792384 11383791616 1989654032 19.541 100 62 124 1 2042774496 33459936 19660528
20:40:23 9002 8192000000 10960107424 11384541184 1989507696 19.540 100 74 149 0 2047027168 34068480 23450992
20:40:38 2994 8192000000 10973799552 11388223488 1989352176 19.539 100 78 154 3 2047880672 34863328 23665168
20:40:49 1693 8192000000 10972486384 11384135680 1976588672 19.438 99 83 164 2 2037229376 35683984 24956720
20:40:57 6071 8192000000 10952232256 11371331584 1961852112 19.321 99 84 167 1 2022308480 35725536 24730832
20:41:14 2762 8192000000 10957400736 11379281920 1983590320 19.493 100 76 151 3 2042578080 37009904 21977856
20:41:27 4956 8192000000 10954059968 11380658176 1982337488 19.483 100 68 136 0 2043815440 40225520 21252432
20:41:39 6380 8192000000 10969318688 11391553536 1991548048 19.556 100 76 148 1 2051021744 37129040 22344656
20:41:53 1180 8192000000 10983298240 11396984832 1996744864 19.597 100 88 177 1 2061624400 39237824 25641712
20:42:01 1805 8192000000 10983959664 11404562432 2001296960 19.633 100 79 158 1 2066554048 41512384 23744704
20:42:10 4028 8192000000 10970601312 11385176064 1960628576 19.311 98 86 170 0 2028289632 41845168 25815888
20:42:22 2300 8192000000 10954816256 11370790912 1963972448 19.338 99 85 170 0 2033370432 43753968 25644016
20:42:30 1090 8192000000 10944711888 11360628736 1945443312 19.190 98 83 167 0 2011130512 40263008 25424192
20:42:38 1208 8192000000 10956346336 11371712512 1970247296 19.387 100 91 179 1 2035758592 38593312 26917984
20:42:47 2334 8192000000 10954984112 11368452096 1968311968 19.372 100 83 162 3 2032228496 39319792 24596736
20:42:57 5901 8192000000 10919976688 11336056832 1936071536 19.115 99 75 150 2 1996881824 37893360 22916928
20:43:09 2288 8192000000 10933618352 11343249408 1947065488 19.203 100 80 158 0 2009148544 38274816 23808240
20:43:19 6597 8192000000 10917598016 11334344704 1939360064 19.142 99 79 156 2 2000984640 38160432 23464144
20:43:33 4891 8192000000 10919503408 11334103040 1924690352 19.024 99 81 162 0 1989020000 38946240 25383408
20:43:46 2362 8192000000 10909479952 11314880512 1923783872 19.017 100 79 157 3 1987372592 38736064 24852656
20:43:55 2935 8192000000 10926708656 11336327168 1937141344 19.124 100 74 147 0 2003006816 43511536 22353936
20:44:06 7128 8192000000 10918184272 11338555392 1935187168 19.108 100 70 139 1 2001684848 45364352 21133328
20:44:29 2526 8192000000 10909399616 11315245056 1907106656 18.883 98 73 144 0 1969852832 40694240 22051936
20:44:42 2595 8192000000 10928143568 11338780672 1936579040 19.119 100 71 142 3 2003693536 44989856 22124640
20:44:53 3527 8192000000 10928057888 11335364608 1930625504 19.072 99 77 154 0 2000156896 46127296 23404096
20:45:04 5397 8192000000 10939988208 11347009536 1948424048 19.214 100 74 146 0 2017483104 47107264 21951792
20:45:18 4062 8192000000 10951963056 11361243136 1953251936 19.252 100 74 145 1 2025948752 50394720 22302096
20:45:29 2452 8192000000 10957421680 11364655104 1961833888 19.321 100 80 160 1 2032597456 46688464 24075104
20:45:38 3383 8192000000 10956329776 11374559232 1970393920 19.389 100 84 161 1 2040878976 45934000 24551056
20:45:49 3237 8192000000 10948862112 11364859904 1949559264 19.223 99 78 154 0 2018081744 45646576 22875904
20:46:00 3006 8192000000 10966934512 11375890432 1969798176 19.384 100 88 174 1 2045580480 49513648 26268656
20:46:09 3159 8192000000 10977529888 11388559360 1977159104 19.442 100 83 165 2 2053315264 50707456 25448704
20:46:22 3084 8192000000 10978197552 11395096576 1983950672 19.496 100 79 158 0 2059041872 49977312 25113888
20:46:32 6686 8192000000 10978199328 11391811584 1976469728 19.437 100 85 169 1 2056771200 53497328 26804144
20:46:46 2778 8192000000 10970395440 11392405504 1979036496 19.457 100 68 136 1 2053109248 52604080 21468672
20:46:56 3220 8192000000 10915681248 11338108928 1930465552 19.071 99 54 108 1 1995456800 47629664 17361584
20:47:08 5993 8192000000 10933699824 11361275904 1953662080 19.256 100 52 104 0 2019633888 48824640 17147168
20:47:22 6747 8192000000 10920630528 11342340096 1935802960 19.113 99 47 92 1 2001059616 49578496 15678160
20:47:37 4893 8192000000 10952432880 11368714240 1955094272 19.267 100 76 148 1 2028797440 50282992 23420176
20:47:49 1736 8192000000 10930362512 11332870144 1928515968 19.055 99 78 156 1 2006025616 52543280 24966368
20:47:58 1627 8192000000 10968873392 11368730624 1960334416 19.309 100 88 175 1 2042167936 54984592 26848928
20:48:07 1650 8192000000 10961660064 11365818368 1941152032 19.156 99 90 180 0 2025581520 55417568 29011920
20:48:17 1631 8192000000 10965848560 11371266048 1958100016 19.291 100 81 162 2 2042863392 58898816 25864560
20:48:31 9038 8192000000 10945586336 11374989312 1954193984 19.260 100 45 90 0 2031278160 61469488 15614688
20:48:47 11152 8192000000 10949353056 11373182976 1940548944 19.151 99 49 98 0 2022964432 65929024 16486464
20:49:06 1528 8192000000 10989831872 11396931584 1973138368 19.410 100 82 163 1 2061703760 62344016 26221376
20:49:15 5172 8192000000 10986203632 11403362304 1977289632 19.443 100 67 134 1 2066371312 67542320 21539360
20:49:28 3129 8192000000 10985097808 11405082624 1976661952 19.438 100 61 121 2 2065951184 68854816 20434416
20:49:45 4192 8192000000 10986135680 11404533760 1974894112 19.424 100 72 138 0 2066239056 67691840 23653104
20:50:01 4784 8192000000 10982331264 11400998912 1959332304 19.301 99 71 140 0 2052762320 70240208 23189808
20:50:16 10813 8192000000 10967387200 11402776576 1971171840 19.395 100 44 88 2 2051242320 64886976 15183504
20:50:34 8242 8192000000 10962130752 11396997120 1975438720 19.429 100 46 89 2 2046641760 55910896 15292144
20:50:53 7880 8192000000 10959436992 11396726784 1957645264 19.287 99 40 79 0 2032699328 61190608 13863456
20:51:25 9833 8192000000 10965730432 11399806976 1975567344 19.430 100 47 94 1 2053042096 61186512 16288240
20:51:48 13261 8192000000 10972286720 11408814080 1974387024 19.420 100 44 88 2 2055553840 65749008 15417808
20:52:16 16054 8192000000 10967491152 11412406272 1978590448 19.454 100 35 70 0 2058488976 67626080 12272448
20:52:42 11994 8192000000 10973556384 11412709376 1967697040 19.367 100 35 70 1 2052727648 72183488 12847120
20:53:00 25189 8192000000 10970058608 11422375936 1963689696 19.335 100 35 70 4 2055134944 78527040 12918208
20:53:34 29115 8192000000 10944451536 11419877376 1954523808 19.262 100 30 60 1 2046208144 79993904 11690432
20:54:20 16338 8192000000 10938676448 11394371584 1934944480 19.106 100 20 40 1 2007880640 65246480 7689680
20:55:29 23381 8192000000 10892658224 11346960384 1889712736 18.743 98 24 48 1 1959871184 62089808 8068640
20:55:59 28320 8192000000 10863982976 11338235904 1901774480 18.841 99 17 34 0 1954538416 46848608 5915328
20:56:39 49173 8192000000 10855215536 11323531264 1920509520 18.991 100 21 40 1 1950472288 24256912 5705856
20:58:01 112865 8192000000 10879043600 11339792384 1887518144 18.726 97 6 12 0 1905976048 17102768 1355136
21:00:00 100626 8192000000 10876016144 11338031104 1910266544 18.909 98 12 25 0 1927743696 14417728 3059424
21:01:47 85842 8192000000 10883299776 11340042240 1916064880 18.955 98 11 20 4 1926661600 8220240 2376480
21:03:21 56472 8192000000 10876717920 11320401920 1885183952 18.707 96 9 18 0 1895267008 7483984 2599072
21:04:30 52327 8192000000 10906340560 11347353600 1939734912 19.145 99 38 73 2 1956803680 7452928 9615840
21:05:28 38718 8192000000 10932409200 11351027712 1951240000 19.236 99 48 94 0 1973951424 7970256 14741168
21:06:19 21238 8192000000 10876442432 11332804608 1933093536 19.092 99 25 50 0 1950234512 9918016 7222960
21:06:47 64906 8192000000 10894354816 11332784128 1912736112 18.929 98 17 34 1 1926860736 8531328 5593296
21:08:00 39418 8192000000 10894196640 11349536768 1959277728 19.300 100 24 48 1 1977056448 10141904 7636816
21:08:47 86431 8192000000 10902432384 11372548096 1941668864 19.160 99 8 16 0 1963097280 19300416 2128000
21:10:21 117320 8192000000 10899868848 11348418560 1937500448 19.127 98 16 32 0 1961074192 17961552 5612192
21:12:25 122561 8192000000 10888726736 11350114304 1943736752 19.177 99 21 40 3 1956247360 6299184 6211424
21:14:35 60588 8192000000 10917873600 11372097536 1962918480 19.329 99 27 53 2 1982196080 11040928 8236672
21:15:45 15929 8192000000 10923215616 11371384832 1973007040 19.409 100 56 112 2 2001259184 12534960 15717184
21:16:10 91209 8192000000 10915028176 11371343872 1962352224 19.325 99 25 50 1 1985046144 15584288 7109632
21:17:48 9504 8192000000 10901056208 11362119680 1946418736 19.198 98 32 64 4 1967812640 11842944 9550960
21:18:07 28286 8192000000 10903296848 11368259584 1972655616 19.407 100 17 34 1 1989758448 12099104 5003728
21:18:57 14677 8192000000 10930433424 11382575104 1980949440 19.472 100 25 50 1 2002690896 14564112 7177344
21:19:18 19993 8192000000 10910073040 11377811456 1966621344 19.359 99 26 52 0 1992011120 16713168 8676608
21:20:05 35210 8192000000 10948857632 11392135168 1970536000 19.390 99 54 108 1 2010678160 23340736 16801424
21:21:13 59241 8192000000 10890949136 11374624768 1928065840 19.051 98 16 32 0 1954830976 22140816 4624320
21:22:41 54276 8192000000 10892887456 11365883904 1943920080 19.178 99 20 40 1 1970127504 20221712 5985712
21:23:45 29928 8192000000 10882494240 11366580224 1917762432 18.969 98 8 16 0 1941648864 21413712 2472720
21:24:22 84767 8192000000 10879236624 11348860928 1925609776 19.032 98 20 41 0 1948083296 16413184 6060336
21:26:03 64208 8192000000 10873068704 11339444224 1897667296 18.808 97 12 24 1 1913439968 12326144 3446528
21:27:15 73878 8192000000 10843119648 11314438144 1808166768 18.081 93 16 32 2 1820066800 7709936 4190096
21:28:37 89218 8192000000 10852031488 11326226432 1847669520 18.403 96 11 22 1 1860516048 10096112 2750416
21:30:12 85113 8192000000 10858263696 11318894592 1824794864 18.217 94 11 22 1 1837821984 9888528 3138592
21:31:43 74737 8192000000 10865037456 11322982400 1869394032 18.579 97 19 38 0 1885987920 11777792 4816096
21:33:21 52886 8192000000 10879975520 11327442944 1841800096 18.355 95 26 52 3 1859683360 10844480 7038784
21:34:25 74461 8192000000 10841130608 11320729600 1839085184 18.333 95 19 38 0 1859487424 14228976 6173264
21:35:46 35770 8192000000 10851174592 11303358464 1913114592 18.932 100 17 34 1 1927122032 9925168 4082272
21:36:33 49066 8192000000 10847883280 11309944832 1888971328 18.737 98 12 24 0 1905837216 13496912 3368976
21:37:36 34620 8192000000 10871047648 11320471552 1902413664 18.846 98 24 48 0 1917013728 8091680 6508384
21:38:18 52849 8192000000 10867127312 11337936896 1905101408 18.867 98 21 42 2 1923001792 11371200 6529184
21:39:17 46434 8192000000 10872541312 11319476224 1886624336 18.719 97 19 38 2 1902682704 10983984 5074384
21:40:09 31892 8192000000 10879010064 11334549504 1927818640 19.049 99 35 70 2 1949228048 11587776 9821632
21:42:24 81391 8192000000 10870052448 11326033920 1915489248 18.951 98 29 58 0 1938167488 13710176 8968064
21:43:52 69990 8192000000 10890488256 11355615232 1942301504 19.165 99 27 54 0 1962635056 12911728 7421824
21:45:09 28849 8192000000 10902099696 11347091456 1957300256 19.285 100 26 52 0 1973713248 9226288 7186704
21:45:46 26309 8192000000 10903684000 11359727616 1970609712 19.390 100 51 100 2 1995965904 11397488 13958704
21:46:33 53007 8192000000 10889304592 11365801984 1950365744 19.229 99 23 47 0 1969545344 12079632 7099968
21:47:34 55162 8192000000 10873363776 11349037056 1911524688 18.919 97 20 41 1 1928941424 11554928 5861808
21:48:37 63586 8192000000 10885045104 11357282304 1964765712 19.344 100 14 28 1 1979932480 11124992 4041776
21:49:55 35659 8192000000 10894607520 11366129664 1970952976 19.393 100 13 26 1 1987903216 12676672 4273568
21:50:37 39989 8192000000 10891302176 11367194624 1948932448 19.218 99 13 25 1 1968139232 15104112 4102672
21:51:24 84116 8192000000 10882630624 11363766272 1937605152 19.128 99 6 12 1 1947626672 8482192 1539328
21:52:59 89797 8192000000 10873955552 11354222592 1880827888 18.672 96 12 22 0 1893972896 10063696 3081312
21:54:57 55240 8192000000 10910125024 11369586688 1968063728 19.370 100 21 42 1 1983243504 9178560 6001216
21:56:04 28726 8192000000 10922524000 11373887488 1955133632 19.267 99 39 78 1 1977436784 11646064 10657088
21:56:39 61850 8192000000 10898187888 11369271296 1952664016 19.248 99 24 49 0 1968586224 9801568 6120640
21:58:17 54760 8192000000 10927998128 11396243456 1983442816 19.492 100 15 30 2 2001742352 14169392 4130144
21:59:45 53618 8192000000 10904839536 11397595136 1969037632 19.378 99 12 24 0 1990221776 17712512 3471632
22:00:46 114084 8192000000 10880970096 11343687680 1820901744 18.185 92 9 18 0 1833658288 10725344 2031200
22:02:48 66759 8192000000 10881486608 11353899008 1889305232 18.740 96 8 16 0 1899704144 8680624 1718288
22:04:07 71448 8192000000 10894277920 11357065216 1900803024 18.833 97 20 40 1 1916548640 10623440 5122176
22:05:27 72730 8192000000 10911269472 11351097344 1890995216 18.754 96 31 61 0 1910792800 11497952 8299632
22:06:50 94764 8192000000 10908449280 11374698496 1952110352 19.243 99 22 43 0 1966976336 8876400 5989584
22:09:04 75062 8192000000 10907897936 11387105280 1951924704 19.242 99 18 36 0 1968146832 11545984 4676144
22:10:26 35991 8192000000 10903536944 11375599616 1968365616 19.372 100 16 32 0 1989903152 16991936 4545600
22:11:14 62609 8192000000 10908057472 11384864768 1954752848 19.264 99 19 38 0 1980380496 20459712 5167936
22:12:27 84066 8192000000 10879508800 11366223872 1893229856 18.772 96 17 34 0 1920833040 21979616 5623568
22:13:58 50939 8192000000 10880801696 11361169408 1937682976 19.128 99 11 21 2 1956735648 15237072 3815600
22:14:58 76198 8192000000 10897590384 11377872896 1961796928 19.320 100 12 24 1 1983395312 18262224 3336160
22:16:20 65714 8192000000 10898397440 11381403648 1958767728 19.296 99 21 42 1 1977552432 12705840 6078864
22:17:40 60213 8192000000 10870632960 11350036480 1867293824 18.562 95 5 10 0 1881100960 12223952 1583184
22:18:47 41016 8192000000 10886833888 11361222656 1940097056 19.148 99 25 50 1 1958755696 11953712 6704928
22:19:41 54800 8192000000 10850369568 11304017920 1781788240 17.864 91 19 38 1 1797423888 9861568 5774080
22:20:47 55860 8192000000 10858649232 11327594496 1909738272 18.905 99 35 70 2 1930381440 10397664 10245504
22:21:52 39173 8192000000 10872803424 11331411968 1902962896 18.850 98 24 47 3 1918203360 7934096 7306368
22:23:35 53895 8192000000 10840473824 11308732416 1826228976 18.229 94 21 42 2 1841751328 10253632 5268720
22:24:35 46193 8192000000 10854983680 11318697984 1875874512 18.632 97 31 62 1 1896545296 12262208 8408576
22:25:27 52158 8192000000 10866438960 11333881856 1914826864 18.945 99 14 28 0 1930610880 11141008 4643008
22:26:57 23314 8192000000 9086725856 9309622272 247885056 2.937 14 1 2 0 250621632 2674448 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 17-11-2020 22:28:17 to 17-11-2020 22:28:50.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 117 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 17-11-2020 22:28:51 to 17-11-2020 22:28:52.

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          249325
MON$OLDEST_ACTIVE               249326
MON$OLDEST_SNAPSHOT             249326
MON$NEXT_TRANSACTION            249326
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                       2071456
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 ---
:260: 
:261: mscs-test-161.budzdorov.ru    Tue Nov 17 22:27:23 2020
:262:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:263: 
:264: 
:265: mscs-test-161.budzdorov.ru    Tue Nov 17 22:27:23 2020
:266:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:267: 
--- end of diff output ---

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

17.11.20 22:28:53. 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-17 22:28:56 No severe PSQL-related problems occured
17.11.20 22:28:57. End of report.