Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.11.2020 01: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 17397776 kB
MemAvailable 31404336 kB
Buffers 0 kB
Cached 14271108 kB
SwapCached 3484 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-15 01:26:59
DTS_END                         2020-11-15 01:26:59.9200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55524
TRN_ID                          242112
ATT_ID                          724
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: 8908.31 25955 1068997
customer order: creation 171.13 346 20535
customer order: refuse 15.10 356 1812
order to supplier: creation 45.99 1353 5519
order to supplier: removal 3.15 106832 378
invoice (draft): creation 46.63 3660 5595
invoice (draft): removal 49.62 850 5954
invoice accept: apply 42.06 19031 5047
invoice accept: cancel 45.08 843 5410
customer reserve: creation 3789.27 192 454712
customer reserve: removal 4408.48 59 529018
realization accept: apply 84.39 190 10127
realization accept: cancel 77.50 106 9300
payment from customer: creation 59.35 113 7122
payment from customer: removal 5.71 77 685
payment to supplier: creation 49.33 127 5919
payment to supplier: removal 3.08 57 370
service: total inventory turnovers 5.03 1236 604
service: total monetary turnovers 6.56 29 787
service: aggregate perf. data 0.83 17895 99
service: refresh index statistics 0.03 365754 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-11-2020 01:28:13 to 15-11-2020 01:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5253
TEST_TIME 2 4616
TEST_TIME 3 3619
TEST_TIME 4 3683
TEST_TIME 5 5132
TEST_TIME 6 5072
TEST_TIME 7 5400
TEST_TIME 8 6019
TEST_TIME 9 6089
TEST_TIME 10 6507
TEST_TIME 11 6436
TEST_TIME 12 6511
TEST_TIME 13 6636
TEST_TIME 14 7037
TEST_TIME 15 7380
TEST_TIME 16 7399
TEST_TIME 17 7592
TEST_TIME 18 7747
TEST_TIME 19 7836
TEST_TIME 20 8428
TEST_TIME 21 8576
TEST_TIME 22 8739
TEST_TIME 23 9024
TEST_TIME 24 9156
TEST_TIME 25 9344
TEST_TIME 26 9230
TEST_TIME 27 9521
TEST_TIME 28 10224
TEST_TIME 29 10379
TEST_TIME 30 10723
TEST_TIME 31 10409
TEST_TIME 32 10169
TEST_TIME 33 10255
TEST_TIME 34 10346
TEST_TIME 35 10152
TEST_TIME 36 10011
TEST_TIME 37 9894
TEST_TIME 38 9742
TEST_TIME 39 9632
TEST_TIME 40 9441
TEST_TIME 41 9508
TEST_TIME 42 9482
TEST_TIME 43 9353
TEST_TIME 44 9280
TEST_TIME 45 9183
TEST_TIME 46 9230
TEST_TIME 47 9150
TEST_TIME 48 9178
TEST_TIME 49 9206
TEST_TIME 50 9296
TEST_TIME 51 9180
TEST_TIME 52 9156
TEST_TIME 53 9201
TEST_TIME 54 9258
TEST_TIME 55 9262
TEST_TIME 56 9220
TEST_TIME 57 9251
TEST_TIME 58 9216
TEST_TIME 59 9350
TEST_TIME 60 9379
TEST_TIME 61 9330
TEST_TIME 62 9399
TEST_TIME 63 9411
TEST_TIME 64 9323
TEST_TIME 65 9245
TEST_TIME 66 9196
TEST_TIME 67 9188
TEST_TIME 68 9104
TEST_TIME 69 9064
TEST_TIME 70 8992
TEST_TIME 71 8910
TEST_TIME 72 8980
TEST_TIME 73 8940
TEST_TIME 74 8968
TEST_TIME 75 8958
TEST_TIME 76 8899
TEST_TIME 77 8933
TEST_TIME 78 8998
TEST_TIME 79 8969
TEST_TIME 80 8963
TEST_TIME 81 9030
TEST_TIME 82 8987
TEST_TIME 83 9029
TEST_TIME 84 9013
TEST_TIME 85 9008
TEST_TIME 86 9009
TEST_TIME 87 9058
TEST_TIME 88 9064
TEST_TIME 89 9120
TEST_TIME 90 9025
TEST_TIME 91 9004
TEST_TIME 92 8987
TEST_TIME 93 8956
TEST_TIME 94 8913
TEST_TIME 95 8855
TEST_TIME 96 8867
TEST_TIME 97 8888
TEST_TIME 98 8928
TEST_TIME 99 8952
TEST_TIME 100 8963
TEST_TIME 101 8933
TEST_TIME 102 9026
TEST_TIME 103 9006
TEST_TIME 104 9017
TEST_TIME 105 9012
TEST_TIME 106 9025
TEST_TIME 107 9068
TEST_TIME 108 9079
TEST_TIME 109 9094
TEST_TIME 110 9042
TEST_TIME 111 8989
TEST_TIME 112 8959
TEST_TIME 113 8941
TEST_TIME 114 8895
TEST_TIME 115 8857
TEST_TIME 116 8829
TEST_TIME 117 8832
TEST_TIME 118 8915
TEST_TIME 119 8935
TEST_TIME 120 8916
TEST_TIME 121 8843

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-11-2020 01:28:17 to 15-11-2020 01:28:20.

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 1489838 1489838 0 0.00 0 14700 7 0 0
doc_list_biud 1489838 1489838 0 0.00 0 59755 27 0 0
sp_add_invoice_to_stock 5195 5047 148 2.84 32 185600 19032 0 148
sp_cancel_adding_invoice 5410 5410 0 0.00 4 45273 844 0 0
sp_cancel_client_order 1812 1812 0 0.00 5 15470 356 0 0
sp_cancel_customer_reserve 529018 529018 0 0.00 1 59757 60 0 0
sp_cancel_pay_from_customer 685 685 0 0.00 3 2997 78 0 0
sp_cancel_pay_to_supplier 370 370 0 0.00 3 2579 58 0 0
sp_cancel_supplier_invoice 5965 5954 11 0.18 1 16932 851 0 11
sp_cancel_supplier_order 378 378 0 0.00 8 1112766 106832 0 0
sp_cancel_write_off 9300 9300 0 0.00 1 13650 107 0 0
sp_client_order 20535 20535 0 0.00 3 61422 346 0 0
sp_customer_reserve 454712 454712 0 0.00 0 61179 193 0 0
sp_fill_shopping_cart 31642 31642 0 0.00 1 11061 48 0 0
sp_fill_shopping_cart_clo_res 454701 454701 0 0.00 0 13533 14 0 0
sp_get_clo_for_invoice 5035 5035 0 0.00 0 26312 317 0 0
sp_kill_cost_storno 15765 15765 0 0.00 0 6146 55 0 0
sp_kill_qstorno_ret_qs2qd 1073668 1073668 0 0.00 0 59093 32 0 0
sp_kill_qty_storno 567034 567034 0 0.00 0 59755 71 0 0
sp_lock_selected_doc 20976 20976 0 0.00 0 6125 4 0 0
sp_make_cost_storno 28203 28203 0 0.00 0 14506 58 0 0
sp_multiply_rows_for_pdistr 28203 28203 0 0.00 0 4899 29 0 0
sp_multiply_rows_for_qdistr 20535 20535 0 0.00 0 61413 156 0 0
sp_pay_from_customer 7122 7122 0 0.00 4 11475 114 0 0
sp_pay_to_supplier 5919 5919 0 0.00 4 12220 127 0 0
sp_payment_common 13041 13041 0 0.00 1 7876 29 0 0
sp_qd_handle_on_cancel_clo 1812 1812 0 0.00 0 15463 332 0 0
sp_qd_handle_on_invoice_upd_sts 10445 10445 0 0.00 0 30845 365 0 0
sp_qd_handle_on_reserve_upd_sts 10127 10127 0 0.00 0 15201 73 0 0
sp_reserve_write_off 10127 10127 0 0.00 6 15228 191 0 0
sp_supplier_invoice 5595 5595 0 0.00 6 91098 3660 0 0
sp_supplier_order 5519 5519 0 0.00 6 33944 1353 0 0
srv_aggregate_perf_data 99 99 0 0.00 3212 158179 17896 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1069 172567 32133 0 0
srv_find_qd_qs_mism 1021392 1021392 0 0.00 0 14699 6 0 0
srv_make_invnt_saldo 604 604 0 0.00 33 105795 1237 0 0
srv_make_money_saldo 787 787 0 0.00 1 1248 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 249241 445533 365754 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5047 5047 0 0.00 0 14472 157 0 0
t$perf-norm:sp_cancel_adding_invoice 429 429 0 0.00 0 8686 106 0 0
t$perf-norm:sp_cancel_client_order 1812 1812 0 0.00 0 5178 17 0 0
t$perf-norm:sp_cancel_customer_reserve 704 704 0 0.00 0 9416 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 685 685 0 0.00 0 1067 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 370 370 0 0.00 0 3357 18 0 0
t$perf-norm:sp_cancel_supplier_invoice 423 423 0 0.00 0 3734 49 0 0
t$perf-norm:sp_cancel_supplier_order 378 378 0 0.00 0 27715 1990 0 0
t$perf-norm:sp_cancel_write_off 1014 1014 0 0.00 0 1418 6 0 0
t$perf-norm:sp_client_order 20535 20535 0 0.00 0 20395 23 0 0
t$perf-norm:sp_customer_reserve 1008 1008 0 0.00 0 12278 26 0 0
t$perf-norm:sp_pay_from_customer 7122 7122 0 0.00 0 11301 12 0 0
t$perf-norm:sp_pay_to_supplier 5919 5919 0 0.00 0 11879 15 0 0
t$perf-norm:sp_reserve_write_off 10127 10127 0 0.00 0 11689 13 0 0
t$perf-norm:sp_supplier_invoice 5595 5595 0 0.00 0 17657 28 0 0
t$perf-norm:sp_supplier_order 5519 5519 0 0.00 0 5501 18 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 37 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 370 6 0 0
t$perf-norm:srv_make_invnt_saldo 604 604 0 0.00 0 1290 22 0 0
t$perf-norm:srv_make_money_saldo 787 787 0 0.00 0 540 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 5 0 0
v_add_invoice_to_stock 10364 10068 296 2.85 0 10902 21 0 296
v_all_customers 37328 37328 0 0.00 0 20 1 0 0
v_all_suppliers 30790 30790 0 0.00 0 17 1 0 0
v_all_wares 41070 41070 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 858 858 0 0.00 0 895 7 0 0
v_cancel_client_order 3624 3624 0 0.00 0 2454 5 0 0
v_cancel_customer_prepayment 1370 1370 0 0.00 0 2981 6 0 0
v_cancel_customer_reserve 1408 1408 0 0.00 0 10447 16 0 0
v_cancel_payment_to_supplier 740 740 0 0.00 0 2544 7 0 0
v_cancel_supplier_invoice 868 846 22 2.53 0 2125 19 0 22
v_cancel_supplier_order 756 756 0 0.00 0 321 3 0 0
v_cancel_write_off 2028 2028 0 0.00 0 2320 14 0 0
v_max_id_clo_ord 5519 5519 0 0.00 0 692 2 0 0
v_max_id_clo_res 1008 1008 0 0.00 0 1027 5 0 0
v_max_id_ord_sup 5588 5588 0 0.00 0 4663 4 0 0
v_max_non_paid_invoice 1631 1631 0 0.00 0 377 2 0 0
v_max_non_paid_realizn 3910 3910 0 0.00 0 3063 5 0 0
v_min_id_clo_ord 5519 5519 0 0.00 0 3466 11 0 0
v_min_id_clo_res 1008 1008 0 0.00 0 8138 20 0 0
v_min_id_ord_sup 5588 5588 0 0.00 0 4665 5 0 0
v_min_non_paid_invoice 5919 5919 0 0.00 0 4447 16 0 0
v_min_non_paid_realizn 7122 7122 0 0.00 0 7873 19 0 0
v_our_firm 10166 10166 0 0.00 0 19 1 0 0
v_reserve_write_off 20254 20254 0 0.00 0 8208 7 0 0
x_lock_depdocs_on_canc_invoice 10941 10941 0 0.00 0 16033 139 0 0
x_lock_depdocs_on_canc_sup_ord 378 378 0 0.00 0 17633 448 0 0
x_make_qstorno_1000_1200 5519 5519 0 0.00 1 33924 1255 0 0
x_make_qstorno_1200_2000 5595 5595 0 0.00 3 81014 3489 0 0
x_make_qstorno_2100_3300 454712 454712 0 0.00 0 61176 175 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-11-2020 01:28:21 to 15-11-2020 01:28:25.

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
22:57:03 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:09 28059 8192000000 10284062496 10596016128 790372512 8.799 60 45 91 1 807416416 2370032 14673872
22:57:46 24733 8192000000 10351361360 10670616576 1397364352 14.572 100 86 173 0 1430618064 5039152 28214560
22:58:22 12736 8192000000 10379078224 10704924672 1436619552 14.920 100 91 181 1 1472782944 6699536 29463856
22:58:44 17184 8192000000 10404193584 10728714240 1454015232 15.073 100 85 170 0 1488800912 7118064 27667616
22:59:09 22598 8192000000 10425104720 10755493888 1474736560 15.255 100 88 175 0 1510252624 7651360 27864704
22:59:46 30006 8192000000 10450795712 10785472512 1500114864 15.477 100 97 194 0 1540200992 9096176 30989952
23:00:27 11181 8192000000 10450273424 10790809600 1512465520 15.585 100 88 176 0 1554104352 13883680 27755152
23:00:54 18458 8192000000 10478635440 10822696960 1536901312 15.797 100 85 170 0 1573105952 9555696 26648944
23:01:20 23391 8192000000 10502524880 10853634048 1559827360 15.995 100 77 154 0 1593268128 9769872 23670896
23:01:52 12964 8192000000 10541217552 10894893056 1587768880 16.235 100 77 154 0 1621472720 10191088 23512752
23:02:15 8892 8192000000 10545183280 10905276416 1607085040 16.400 100 75 150 0 1640570432 10696992 22788400
23:02:36 14592 8192000000 10575312752 10938327040 1629987104 16.595 100 76 152 2 1663920576 11294688 22638784
23:02:59 12062 8192000000 10603851184 10965295104 1652756896 16.788 100 81 162 0 1688493728 11437792 24299040
23:03:19 9667 8192000000 10611435376 10983006208 1673945936 16.966 100 75 150 1 1708922896 12474368 22502592
23:03:39 8813 8192000000 10638711744 11010568192 1694681840 17.141 100 71 143 0 1726695296 10994608 21018848
23:03:57 8956 8192000000 10655381312 11030257664 1719681152 17.350 100 80 160 0 1754134112 10806144 23646816
23:04:12 8631 8192000000 10678668320 11052896256 1733541712 17.465 100 77 154 1 1767735360 11605824 22587824
23:04:30 5759 8192000000 10686407472 11060191232 1742455280 17.539 100 74 146 2 1775581472 12267008 20859184
23:04:43 9613 8192000000 10702695008 11079553024 1761499984 17.697 100 84 168 1 1798289152 12354784 24434384
23:05:00 4532 8192000000 10709358384 11084967936 1764980608 17.726 100 82 164 0 1801240688 13437328 22822752
23:05:11 4487 8192000000 10717017008 11097116672 1775965296 17.816 100 83 167 1 1812399120 13002432 23431392
23:05:24 4332 8192000000 10723442608 11106283520 1785728912 17.897 100 79 157 2 1820182768 12406368 22047488
23:05:35 3400 8192000000 10731062400 11113254912 1790436880 17.935 100 82 164 1 1827412672 13216784 23759008
23:05:45 3679 8192000000 10737424576 11121676288 1797315056 17.992 100 86 172 1 1835716096 14600544 23800496
23:05:56 4412 8192000000 10741258176 11126292480 1800934928 18.022 100 84 168 1 1839460096 15264240 23260928
23:06:07 2762 8192000000 10746158208 11129044992 1805916944 18.062 100 88 176 0 1844976400 14947584 24111872
23:06:16 2258 8192000000 10752140096 11130617856 1807125488 18.072 100 86 169 2 1845056560 14250912 23680160
23:06:25 2348 8192000000 10754379792 11138613248 1815787712 18.143 100 88 175 2 1854695952 14335296 24572944
23:06:34 6086 8192000000 10756338592 11145330688 1811608320 18.109 100 68 133 0 1843475392 12838896 19028176
23:06:46 6194 8192000000 10764059920 11154448384 1823182864 18.204 100 83 167 1 1859567776 13545568 22839344
23:06:59 2278 8192000000 10788859920 11173265408 1840069264 18.341 100 92 183 4 1880021200 13675920 26276016
23:07:08 2414 8192000000 10791477488 11177467904 1846018400 18.390 100 89 178 2 1884269216 13671200 24579616
23:07:17 2375 8192000000 10791389424 11179495424 1851530832 18.435 100 90 180 0 1889766896 13504496 24731568
23:07:26 2212 8192000000 10805935664 11189035008 1856121488 18.472 100 92 184 1 1895817440 13944736 25751216
23:07:34 1550 8192000000 10807081104 11190931456 1858468128 18.491 100 88 174 1 1897642912 13720992 25453792
23:07:42 1458 8192000000 10806152768 11192635392 1858506976 18.491 100 91 182 0 1898989824 14048960 26433888
23:07:50 1258 8192000000 10808172000 11196325888 1862090992 18.520 100 95 191 1 1904953360 15381744 27480624
23:07:57 1266 8192000000 10805059088 11196284928 1870595232 18.589 100 96 191 0 1911769216 13689232 27484752
23:08:05 1363 8192000000 10815184608 11205386240 1868464016 18.572 100 90 183 1 1906382080 12197456 25720608
23:08:13 1205 8192000000 10822254448 11210534912 1876351104 18.636 100 94 188 1 1916661792 13622864 26687824
23:08:20 1417 8192000000 10820901408 11211747328 1876577536 18.637 100 92 186 0 1916140176 13583920 25978720
23:08:28 2256 8192000000 10807100752 11215523840 1877734096 18.647 100 69 138 1 1910334752 13139328 19461328
23:08:37 39789 8192000000 10799915216 11220070400 1874848704 18.623 100 44 88 1 1895112032 7499456 12763872
23:09:23 6071 8192000000 10791037440 11219501056 1880989312 18.673 100 34 68 1 1898427488 8083024 9355152
23:09:41 4807 8192000000 10803454352 11224899584 1888493248 18.734 100 54 109 4 1911297792 7256816 15547728
23:09:54 6447 8192000000 10801297968 11228168192 1884930080 18.705 100 34 64 3 1900566208 6211376 9424752
23:10:12 13240 8192000000 10804197760 11235905536 1889434784 18.741 100 17 34 1 1904964032 10829200 4700048
23:10:31 13083 8192000000 10796659056 11229683712 1889234032 18.740 100 15 31 1 1899694256 5807120 4653104
23:10:51 7473 8192000000 10807023216 11236630528 1890715376 18.752 100 17 34 4 1901163296 6171776 4276144
23:11:04 7461 8192000000 10806154656 11240124416 1895617584 18.791 100 19 36 1 1907039808 6015792 5406432
23:11:18 12084 8192000000 10803172704 11242242048 1900200512 18.828 100 19 38 1 1911586016 6296288 5089216
23:11:37 18530 8192000000 10801417488 11244687360 1898450736 18.814 100 15 30 1 1907908544 5514000 3943808
23:12:02 11656 8192000000 10806408448 11248005120 1902468208 18.846 100 18 36 2 1913012640 5713376 4831056
23:12:20 13592 8192000000 10813192656 11254444032 1904614976 18.863 100 14 28 1 1914431728 6188832 3627920
23:12:43 14494 8192000000 10818449008 11256197120 1913780320 18.937 100 23 46 2 1925651168 5681840 6189008
23:13:05 66098 8192000000 10852545600 11272478720 1919100720 18.980 100 42 85 0 1936826976 5468752 12257504
23:14:18 6377 8192000000 10829283488 11270680576 1919529648 18.983 100 32 62 2 1936729680 8865200 8334832
23:14:30 6873 8192000000 10840976160 11274317824 1923710304 19.017 100 34 67 0 1939563408 5923952 9929152
23:14:45 6485 8192000000 10828914528 11270737920 1919891552 18.986 100 24 44 1 1932229536 5257760 7080224
23:14:58 5560 8192000000 10826588624 11264233472 1902310832 18.845 99 35 70 0 1919193088 6950400 9931856
23:15:10 8229 8192000000 10833120912 11271512064 1919726672 18.985 100 31 62 1 1934583808 5923232 8933904
23:15:25 7010 8192000000 10816319200 11257729024 1893343776 18.773 99 28 57 1 1911760960 10248112 8169072
23:15:40 6571 8192000000 10842331216 11269263360 1911873344 18.922 100 31 62 1 1926808992 5958128 8977520
23:15:57 6099 8192000000 10815560704 11255885824 1889003280 18.738 99 21 42 3 1900829424 6109008 5717136
23:16:14 6431 8192000000 10816817328 11250012160 1902061744 18.843 100 26 52 2 1915757696 6113296 7582656
23:16:28 8835 8192000000 10821703152 11260846080 1907218496 18.884 100 26 52 1 1920400736 5627856 7554384
23:16:44 9832 8192000000 10830334672 11254362112 1880173152 18.667 98 31 62 0 1894408144 5672320 8562672
23:17:00 11662 8192000000 10809955776 11248078848 1865929504 18.551 98 18 36 1 1880410496 9498672 4982320
23:17:19 13053 8192000000 10771092688 11200987136 1752764736 17.624 92 11 22 1 1761427280 5423584 3238960
23:17:41 69619 8192000000 10754932688 11181531136 1802594016 18.035 96 25 50 1 1815091344 5125104 7372224
23:18:57 16674 8192000000 10738460480 11163504640 1776394240 17.820 95 19 39 2 1787902736 5220192 6288304
23:19:21 10336 8192000000 10723921632 11137728512 1725083648 17.395 94 24 48 0 1737801120 5910592 6806880
23:19:40 5248 8192000000 10738955792 11156385792 1814598448 18.134 100 37 75 0 1833488544 7714832 11175264
23:19:55 4076 8192000000 10757084784 11166904320 1816760176 18.151 99 40 80 1 1836172128 7416544 11995408
23:20:08 5618 8192000000 10716896512 11127533568 1782507712 17.870 98 22 42 2 1793919968 5192368 6219888
23:20:20 5834 8192000000 10735360224 11153784832 1802038784 18.031 99 25 50 1 1814921984 5407760 7475440
23:20:32 7015 8192000000 10701803040 11116998656 1722324928 17.372 95 31 62 1 1736501168 5680160 8496080
23:20:47 8283 8192000000 10686360336 11107381248 1753312176 17.629 98 18 36 2 1764448608 5625280 5511152
23:21:02 9576 8192000000 10699890848 11114094592 1733238272 17.462 96 32 63 4 1748744496 6695600 8810624
23:21:18 5620 8192000000 10697937056 11123822592 1789017168 17.924 100 21 42 1 1801493072 6637056 5838848
23:21:29 6420 8192000000 10727035696 11137880064 1793479424 17.960 99 38 76 3 1810348336 5170624 11698288
23:21:46 10157 8192000000 10732382608 11154202624 1817016576 18.153 100 17 34 1 1828646944 5579728 6050640
23:22:03 7344 8192000000 10741408000 11165315072 1814324096 18.131 99 22 43 0 1826530352 6134352 6071904
23:22:19 6090 8192000000 10747008896 11174436864 1835301328 18.303 100 21 42 3 1846878416 5885040 5692048
23:22:32 83207 8192000000 10740500240 11178332160 1818020384 18.162 99 20 41 0 1828406304 4836400 5549520
23:24:01 9683 8192000000 10768615968 11193102336 1850711536 18.428 100 39 77 0 1868869296 7029664 11128096
23:24:18 8986 8192000000 10766420592 11193958400 1853654144 18.452 100 28 55 0 1867810016 6064384 8091488
23:24:34 6337 8192000000 10762275696 11193327616 1853900352 18.454 100 25 50 1 1866861664 5757184 7204128
23:24:48 5823 8192000000 10771784608 11197440000 1853511024 18.451 100 21 42 1 1865627296 5810480 6305792
23:25:01 8060 8192000000 10765829536 11198492672 1858210288 18.489 100 35 70 0 1875005248 6414576 10380384
23:25:16 8250 8192000000 10771623696 11203506176 1862653584 18.525 100 19 38 1 1873682992 5328000 5701408
23:25:33 11464 8192000000 10777082896 11206832128 1863365792 18.531 100 14 28 2 1873087712 5898112 3823808
23:25:50 9238 8192000000 10783251776 11213594624 1872040192 18.601 100 29 58 0 1886273760 5888672 8344896
23:26:11 7805 8192000000 10785072064 11219578880 1873368816 18.612 100 19 38 0 1886297712 5787264 7141632
23:26:25 9724 8192000000 10784658560 11221254144 1875683648 18.630 100 17 34 1 1886600752 5420544 5496560
23:26:44 4383 8192000000 10794789888 11223035904 1878382880 18.652 100 26 51 1 1891926160 5692880 7850400
23:26:57 9037 8192000000 10799651056 11222028288 1863411664 18.531 99 26 52 0 1876490272 5957920 7120688
23:27:14 34202 8192000000 10826710592 11250270208 1905345760 18.869 100 45 90 0 1925573120 6285504 13941856
23:27:58 34146 8192000000 10849944624 11275694080 1920118208 18.988 100 38 76 0 1938340768 7753968 10468592
23:28:45 86420 8192000000 10860901248 11293556736 1937197968 19.124 100 51 101 1 1960871728 9273968 14399792
23:30:41 30826 8192000000 10878403424 11311996928 1946929072 19.202 100 41 82 1 1971501056 12630096 11941888
23:31:22 6760 8192000000 10882124032 11319889920 1952388000 19.245 100 34 68 3 1976407088 14262240 9756848
23:31:36 2471 8192000000 10888268016 11320053760 1956567824 19.279 100 42 84 1 1982885184 13149792 13167568
23:31:46 2736 8192000000 10905913984 11326562304 1963530672 19.334 100 56 110 3 1991937248 11751760 16654816
23:31:57 5926 8192000000 10905727984 11330899968 1967057968 19.362 100 56 110 1 1994753184 11608064 16087152
23:32:13 4120 8192000000 10909101376 11330043904 1968973968 19.377 100 60 118 0 1998052576 12203248 16875360
23:32:24 7341 8192000000 10901509520 11334098944 1971504496 19.397 100 52 104 1 2000236784 12887136 15845152
23:32:40 22090 8192000000 10907821952 11336429568 1964327712 19.340 100 46 92 1 1990327920 12885296 13114912
23:33:09 5002 8192000000 10911632112 11337646080 1969381024 19.381 100 52 104 0 2000817776 15818416 15618336
23:33:20 5757 8192000000 10912222288 11341070336 1974286656 19.419 100 59 118 1 2007689936 15550144 17853136
23:33:36 16726 8192000000 10919145552 11342819328 1966955856 19.361 100 61 121 2 2005071152 19897376 18217920
23:34:00 26192 8192000000 10914504432 11340476416 1939792144 19.145 98 59 118 1 1978118896 19995728 18331024
23:34:33 5347 8192000000 10928021136 11356377088 1976142656 19.434 100 64 126 0 2016033312 22073584 17817072
23:34:45 5386 8192000000 10929915120 11357016064 1981935680 19.480 100 68 135 1 2022578848 21305696 19337472
23:34:59 7378 8192000000 10944634544 11366772736 1987106656 19.521 100 66 132 0 2027841184 21285728 19448800
23:35:19 38418 8192000000 10935342224 11378196480 1990943216 19.551 100 50 100 3 2027532784 21904736 14684832
23:36:18 8316 8192000000 10953018208 11376910336 1981328080 19.475 99 57 114 1 2020305504 22017696 16959728
23:36:38 2197 8192000000 10948703600 11372916736 1991587008 19.556 100 68 134 0 2033958688 23565072 18806608
23:36:49 1745 8192000000 10952037520 11375202304 1992318672 19.562 100 72 143 3 2035200448 22391792 20489984
23:36:59 4241 8192000000 10957528784 11389030400 2001897232 19.638 100 60 119 2 2043824528 24117120 17810176
23:37:11 12050 8192000000 10964042432 11397398528 2008449664 19.689 100 57 114 0 2050091840 24530192 17111984
23:37:32 10315 8192000000 10958305392 11387449344 1989644816 19.541 99 61 122 0 2033269488 26039088 17585584
23:37:50 10820 8192000000 10956933472 11392319488 2006592400 19.675 100 63 122 0 2050741152 26306304 17842448
23:38:13 7980 8192000000 10933174128 11364970496 1975462336 19.429 99 57 114 0 2018655632 26297296 16896000
23:38:30 3246 8192000000 10956711664 11383599104 1998098272 19.608 100 67 134 3 2044419024 26357904 19962848
23:38:41 2800 8192000000 10967100480 11392495616 2001850944 19.637 100 72 141 2 2050061344 26877104 21333296
23:38:51 5042 8192000000 10977858272 11397152768 2008013200 19.686 100 74 150 4 2059079360 28006592 23059568
23:39:06 3435 8192000000 10942052400 11365994496 1951400512 19.238 98 73 146 1 2001182928 27235744 22546672
23:39:15 2040 8192000000 10928034192 11346386944 1946603808 19.199 98 84 165 2 2000300704 28080560 25616336
23:39:26 4559 8192000000 10946734352 11372638208 1983165120 19.490 100 70 140 2 2034036800 29470448 21401232
23:39:50 8065 8192000000 10940600160 11374370816 1968005152 19.370 99 64 128 1 2019342656 31343344 19994160
23:40:05 4653 8192000000 10955567888 11387404288 1993896976 19.575 100 61 122 1 2044232544 31148560 19187008
23:40:17 4462 8192000000 10962434912 11384823808 1984225616 19.498 99 74 148 2 2037093392 29592080 23275696
23:40:29 1982 8192000000 10977412896 11397570560 2006452304 19.674 100 83 165 1 2063201088 31543264 25205520
23:40:38 2573 8192000000 10983944544 11402113024 2006182224 19.671 100 89 176 0 2069466256 36611760 26672272
23:40:50 1676 8192000000 10990265152 11407007744 2008396912 19.689 100 86 172 2 2068229488 33826528 26006048
23:41:00 1280 8192000000 10992042736 11408392192 2010618032 19.706 100 90 180 1 2075567728 36834304 28115392
23:41:09 2509 8192000000 10954826512 11368681472 1964536912 19.342 98 85 168 2 2023994080 33369792 26087376
23:41:19 5971 8192000000 10948375632 11369840640 1975063888 19.426 99 79 155 1 2032877232 33580784 24232560
23:41:31 5892 8192000000 10962466128 11391807488 1993986432 19.575 100 67 131 1 2048035840 34471072 19578336
23:41:45 10321 8192000000 10948404528 11373748224 1965601520 19.351 99 65 129 2 2019466544 33754064 20110960
23:42:03 2322 8192000000 10959148928 11381481472 1994295920 19.578 100 70 140 1 2044186944 29243232 20647792
23:42:11 1067 8192000000 10973508288 11391250432 1997473184 19.603 100 72 144 2 2049668768 30084896 22110688
23:42:19 1982 8192000000 10963527216 11385479168 1993778576 19.574 100 71 142 0 2045462560 30269008 21414976
23:42:30 3184 8192000000 10962725040 11390189568 1994928000 19.583 100 71 141 0 2047426832 30342768 22156064
23:42:47 2667 8192000000 10944679072 11354902528 1956916624 19.282 99 79 158 1 2012808368 30769872 25121872
23:42:56 3065 8192000000 10947836368 11361382400 1963515584 19.334 99 91 180 1 2024841168 32884928 28440656
23:43:07 2555 8192000000 10925730352 11336642560 1949251296 19.221 100 89 177 0 2007746768 32212288 26283184
23:43:17 3445 8192000000 10900409168 11314491392 1926740352 19.041 99 68 135 0 1980974496 33566368 20667776
23:43:31 2128 8192000000 10921501968 11327164416 1923207696 19.013 99 74 147 1 1980508160 35294016 22006448
23:43:40 2002 8192000000 10935203584 11337338880 1943776656 19.177 100 91 182 0 2008655424 36793184 28085584
23:43:49 7024 8192000000 10924699632 11342946304 1945786688 19.193 100 80 159 1 2006999728 37256736 23956304
23:44:04 7116 8192000000 10909062528 11325042688 1909255696 18.901 98 72 143 1 1968013616 35788112 22969808
23:44:18 1685 8192000000 10924329472 11336777728 1943413520 19.174 100 79 157 0 2005621232 37606480 24601232
23:44:29 1961 8192000000 10928812752 11338149888 1942399536 19.166 100 86 169 3 2007193712 38896800 25897376
23:44:38 1933 8192000000 10928785776 11336839168 1928038272 19.051 99 81 162 2 1993767232 40329360 25399600
23:44:48 2650 8192000000 10919537424 11333201920 1937039216 19.123 100 74 142 2 1999448448 39047216 23362016
23:44:58 3144 8192000000 10902898064 11316498432 1921509360 18.999 99 68 136 3 1982024608 39941888 20573360
23:45:14 8187 8192000000 10910125056 11329581056 1931530432 19.079 100 61 123 0 1991092432 40420512 19141488
23:45:30 6170 8192000000 10867296368 11282227200 1882149632 18.682 98 69 138 0 1946221328 42991616 21080080
23:45:44 2914 8192000000 10929632768 11337367552 1934087376 19.100 100 85 169 1 2006201216 45552688 26561152
23:45:55 1960 8192000000 10936000000 11342303232 1938039360 19.131 100 84 168 1 2008907248 44377536 26490352
23:46:05 1282 8192000000 10924385664 11331104768 1931114800 19.076 100 83 166 0 2002205776 45289840 25801136
23:46:12 2662 8192000000 10933655616 11344629760 1942259392 19.165 100 88 175 1 2015256080 45012512 27984176
23:46:21 8020 8192000000 10878392816 11300147200 1899224432 18.820 98 71 142 0 1954396576 33059232 22112912
23:46:42 6613 8192000000 10901405264 11312070656 1911621328 18.920 99 70 136 4 1967183680 34006976 21555376
23:46:56 5567 8192000000 10911431776 11329241088 1938068352 19.131 100 69 139 1 1994537488 35527120 20942016
23:47:12 9315 8192000000 10888484848 11301187584 1897365792 18.805 99 70 139 0 1954911584 35895968 21649824
23:47:33 2676 8192000000 10902021968 11320197120 1925455072 19.031 100 68 136 1 1983459392 36436272 21568048
23:47:42 4556 8192000000 10890529904 11307433984 1915306960 18.949 99 73 145 4 1972859776 35036736 22516080
23:47:58 8096 8192000000 10903618304 11330777088 1930989216 19.075 100 54 109 1 1992026656 43239760 17797680
23:48:12 9183 8192000000 10891683920 11318452224 1915834256 18.953 99 44 88 0 1963887312 33861504 14191552
23:48:54 3623 8192000000 10926902512 11340005376 1950008512 19.227 100 82 164 2 2012567104 36358688 26199904
23:49:04 7578 8192000000 10926171584 11354644480 1952909264 19.250 100 63 126 2 2011332864 38940752 19482848
23:49:18 7342 8192000000 10915914336 11351142400 1951175072 19.236 100 42 84 2 1996669312 31870160 13624080
23:49:37 11812 8192000000 10913649328 11346214912 1936952400 19.122 99 37 71 2 1980510400 31520576 12037424
23:49:55 5436 8192000000 10922209056 11343765504 1953126336 19.251 100 52 100 3 1999192608 30652768 15413504
23:50:07 2422 8192000000 10939343072 11357577216 1967619584 19.367 100 76 150 0 2024507760 32882432 24005744
23:50:17 5678 8192000000 10947582688 11372396544 1972383376 19.404 100 75 152 0 2033350384 37181120 23785888
23:50:38 12502 8192000000 10918295632 11364036608 1960194208 19.308 100 28 56 1 2003420064 33401984 9823872
23:51:10 19458 8192000000 10925094656 11370029056 1957303488 19.285 100 29 58 2 2009995440 43245184 9446768
23:51:38 18367 8192000000 10916016224 11370135552 1952561856 19.247 100 29 56 1 2004059552 41606816 9890880
23:52:23 14531 8192000000 10926032048 11372576768 1960233808 19.308 100 36 72 3 2013118672 40755664 12129200
23:52:49 22927 8192000000 10925515920 11375476736 1955125984 19.267 100 33 66 1 2017536048 51117104 11292960
23:53:21 19200 8192000000 10922525360 11370541056 1957325616 19.285 100 34 68 0 2016139632 47013184 11800832
23:54:03 27140 8192000000 10904190896 11375054848 1949341472 19.221 100 25 50 1 2000227344 42433664 8452208
23:54:44 23504 8192000000 10881162304 11346481152 1907144352 18.884 98 12 24 2 1943410528 32064528 4201648
23:55:14 26563 8192000000 10890801280 11334868992 1902083264 18.843 98 29 58 2 1937845968 26563616 9199088
23:55:47 29216 8192000000 10870646608 11338321920 1923185968 19.012 100 8 16 0 1956593104 30598640 2808496
23:56:24 20834 8192000000 10855584768 11324256256 1911056032 18.915 99 27 55 1 1945892080 25221824 9614224
23:57:06 63759 8192000000 10903054736 11338125312 1952878016 19.249 100 50 100 1 1978310656 11537120 13895520
23:58:17 17398 8192000000 10898243424 11326722048 1901641696 18.839 97 54 108 2 1929305696 12361568 15302432
23:58:53 22486 8192000000 10906405680 11335995392 1938468224 19.135 99 49 100 2 1968758512 16061536 14228752
23:59:31 23548 8192000000 10883774432 11340791808 1932174320 19.084 99 30 60 1 1960571280 19759248 8637712
00:01:11 39204 8192000000 10887407296 11338629120 1955588368 19.271 100 12 24 3 1965284320 6599792 3096160
00:02:12 72943 8192000000 10896434704 11366723584 1965696368 19.351 100 10 20 0 1976261344 8285216 2279760
00:04:00 113184 8192000000 10896813088 11366055936 1969782928 19.384 100 17 34 1 1986203904 11429040 4991936
00:05:59 171397 8192000000 10885878608 11357646848 1899079552 18.819 96 24 48 0 1926739984 20510400 7150032
00:08:57 46357 8192000000 10886599824 11345956864 1939863152 19.146 99 19 38 1 1954505248 9267952 5374144
00:09:53 60257 8192000000 10895648320 11352817664 1944309456 19.181 99 20 40 0 1959315248 9193056 5812736
00:11:01 44872 8192000000 10899736320 11352936448 1967965936 19.369 100 38 76 0 1992601504 13468208 11167360
00:12:01 36131 8192000000 10896004080 11372113920 1969906928 19.385 100 20 40 0 1991377872 15508640 5962304
00:12:46 52378 8192000000 10896192800 11369287680 1974625664 19.422 100 12 24 0 1990064048 11437520 4000864
00:14:01 78696 8192000000 10896147440 11357736960 1930330144 19.070 98 21 42 2 1949224944 12608976 6285824
00:15:29 44092 8192000000 10887443232 11369037824 1971872784 19.400 100 24 48 0 1992154992 12672912 7609296
00:17:23 29516 8192000000 10927856704 11369111552 1974136960 19.418 100 35 71 0 1992116336 7962592 10016784
00:18:03 94140 8192000000 10899850032 11370360832 1957871728 19.289 99 20 38 2 1974574336 11370560 5332048
00:19:55 63685 8192000000 10914272256 11390877696 1982248560 19.482 100 23 45 1 2006287088 17571472 6467056
00:21:05 44158 8192000000 10912152144 11374231552 1948552224 19.215 98 23 46 2 1965691904 10212880 6926800
00:21:59 32216 8192000000 10903506800 11364442112 1943746496 19.177 98 24 48 2 1969421392 19504432 6170464
00:22:40 88520 8192000000 10906200752 11368824832 1937197040 19.124 98 25 50 2 1959766000 16042720 6526240
00:25:07 49379 8192000000 10886519008 11366981632 1897198336 18.804 96 29 58 2 1923124672 17621328 8305008
00:26:03 118287 8192000000 10883425696 11348205568 1817394080 18.156 92 15 30 2 1836240080 14420144 4425856
00:28:11 81715 8192000000 10885830608 11363753984 1924472432 19.023 98 11 22 0 1940584176 13755264 2356480
00:29:39 89413 8192000000 10877922560 11329458176 1846675392 18.395 94 26 50 2 1866023760 12432304 6916064
00:31:21 71359 8192000000 10864930048 11319062528 1852919072 18.446 95 38 75 0 1870330688 6563952 10847664
00:32:39 44250 8192000000 10834321152 11304865792 1899890960 18.825 98 21 40 1 1916270304 10145056 6234288
00:33:33 49055 8192000000 10854877936 11333189632 1936452080 19.118 100 10 20 1 1948418880 9098576 2868224
00:34:30 49866 8192000000 10849887856 11321851904 1917496128 18.967 98 13 26 0 1930578800 9387232 3695440
00:36:12 104623 8192000000 10887513840 11357986816 1910258736 18.909 97 18 36 1 1929318464 13836544 5223184
00:38:35 37348 8192000000 10869079680 11340906496 1932353760 19.086 99 34 69 2 1959976000 17571776 10050464
00:39:27 47781 8192000000 10875307808 11354591232 1956553184 19.279 100 19 38 1 1976612736 14796272 5263280
00:40:41 79652 8192000000 10853234064 11316391936 1843555440 18.370 95 12 24 1 1864323568 17055744 3712384
00:42:07 84417 8192000000 10867830160 11343499264 1867575472 18.565 96 23 46 1 1888666720 14827456 6263792
00:43:42 87651 8192000000 10823446416 11295539200 1814327952 18.131 94 12 24 1 1828209312 10432048 3449312
00:45:15 61592 8192000000 10833495392 11299151872 1859364864 18.498 97 15 30 0 1874994544 11222512 4407168
00:46:24 86126 8192000000 10865298576 11326578688 1880168128 18.666 97 21 41 1 1901733904 16006592 5559184
00:48:01 57211 8192000000 10879758368 11334377472 1898112416 18.811 98 13 26 0 1916445040 15021216 3311408
00:49:08 42942 8192000000 10877171024 11346100224 1907113632 18.883 98 19 38 0 1925494272 12848240 5532400
00:50:01 51393 8192000000 10893818672 11338334208 1951094800 19.235 100 42 76 0 1969610336 8786272 9729264
00:51:05 44781 8192000000 10884005504 11333824512 1914773856 18.945 98 25 50 1 1930123616 8531504 6818256
00:51:59 16678 8192000000 10899773024 11336196096 1916802464 18.961 98 39 76 2 1934815856 7711776 10301616
00:52:22 21471 8192000000 10870595776 11320074240 1901629008 18.839 98 40 79 1 1922222368 9091392 11501968
00:52:54 93546 8192000000 10869971072 11330314240 1896197536 18.796 98 14 28 0 1911659200 11506352 3955312
00:54:42 172567 8192000000 10864904480 11325501440 1889494464 18.742 97 7 14 0 1905162528 13830528 1837536
00:57:41 47737 8192000000 10870803040 11336724480 1943621376 19.176 100 28 56 1 1965286112 14091968 7572768
00:58:35 18555 8192000000 10858782944 11336929280 1942540704 19.167 100 14 28 0 1956152992 9772944 3839344
00:59:06 27971 8192000000 10846450080 11313590272 1924025680 19.019 99 13 27 1 1935249728 7802096 3421952
00:59:41 67816 8192000000 10872074800 11339640832 1914216320 18.940 98 8 16 0 1921626208 5596208 1813680
01:01:10 57321 8192000000 10844347680 11307212800 1873878624 18.616 96 8 16 0 1887362624 11522576 1961424
01:02:13 87978 8192000000 10866925232 11351887872 1943078448 19.171 100 12 24 0 1962982416 16525744 3378224
01:03:59 39548 8192000000 10865518416 11337785344 1932269856 19.085 99 21 42 0 1953421248 14541600 6609792
01:04:45 26566 8192000000 10893232544 11348852736 1941780912 19.161 99 29 58 1 1959562416 9546496 8235008
01:05:25 71095 8192000000 10872987392 11343618048 1923677424 19.016 98 20 40 2 1941535808 12161312 5697072
01:06:46 61414 8192000000 10893600480 11350917120 1916884304 18.962 98 28 56 2 1935441440 10702192 7854944
01:07:55 79296 8192000000 10896374496 11365519360 1928571504 19.055 98 27 54 0 1950645840 14678160 7396176
01:09:21 49776 8192000000 10880905440 11331891200 1885449744 18.709 96 25 50 1 1901553296 9187008 6916544
01:10:18 72962 8192000000 10879036896 11341115392 1934714624 19.105 99 18 36 0 1950452624 10919424 4818576
01:11:44 117312 8192000000 10886569392 11358167040 1878920816 18.656 96 18 35 0 1898152064 14394048 4837200
01:13:47 84287 8192000000 10894693712 11360079872 1936132800 19.116 99 8 16 0 1948574896 10438560 2003536
01:15:19 32521 8192000000 10902740688 11369263104 1950069600 19.227 99 48 95 0 1981131312 17028176 14033536
01:15:58 99506 8192000000 10926301008 11363311616 1971987344 19.401 100 35 71 1 1995643008 13432544 10223120
01:17:44 75747 8192000000 10883313008 11356708864 1923803152 19.017 97 26 50 2 1941041920 10343232 6895536
01:19:08 47138 8192000000 10883093200 11367202816 1947331392 19.205 99 14 28 0 1961486352 9969472 4185488
01:20:06 48638 8192000000 10898492880 11378880512 1974531488 19.421 100 7 14 1 1988230448 11933424 1765536
01:21:01 47002 8192000000 10887849232 11360694272 1915416592 18.950 97 11 22 1 1933379664 14723232 3239840
01:21:54 38220 8192000000 10869566288 11338891264 1884021520 18.698 96 13 25 1 1904878464 16840640 4016304
01:23:16 72603 8192000000 10854831520 11343671296 1905240672 18.868 98 16 32 0 1928473184 18346096 4886416
01:24:46 54583 8192000000 10852687088 11323199488 1892663744 18.767 98 8 16 0 1916996272 21989648 2342880
01:25:55 72186 8192000000 9875966688 10241781760 1002863168 10.906 52 9 18 1 1014344896 9213904 2267824

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 15-11-2020 01:28:27 to 15-11-2020 01:28:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 148 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-11-2020 01:28:59 to 15-11-2020 01:29:01.

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          242611
MON$OLDEST_ACTIVE               242612
MON$OLDEST_SNAPSHOT             242612
MON$NEXT_TRANSACTION            242612
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                       2023552
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 ---
:109: 
:110: mscs-test-161.budzdorov.ru    Sun Nov 15 01:27:20 2020
:111:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:112: 
--- end of diff output ---

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

15.11.20 01:29:02. 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-15 01:29:04 No severe PSQL-related problems occured
15.11.20 01:29:05. End of report.