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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17052692 kB
MemAvailable 31152164 kB
Buffers 0 kB
Cached 14628260 kB
SwapCached 4384 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-15 16:27:18
DTS_END                         2021-02-15 16:27:18.5090
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(131:22) ==> SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34842
TRN_ID                          233889
ATT_ID                          629
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: 9121.61 18929 1094593
customer order: creation 171.03 355 20524
customer order: refuse 13.86 336 1663
order to supplier: creation 45.55 1297 5466
order to supplier: removal 3.40 116121 408
invoice (draft): creation 44.80 3360 5376
invoice (draft): removal 50.62 890 6074
invoice accept: apply 41.61 19012 4993
invoice accept: cancel 46.19 797 5543
customer reserve: creation 3889.86 186 466783
customer reserve: removal 4519.71 68 542365
realization accept: apply 82.64 172 9917
realization accept: cancel 83.55 110 10026
payment from customer: creation 58.79 123 7055
payment from customer: removal 5.36 51 643
payment to supplier: creation 48.43 123 5811
payment to supplier: removal 3.48 59 417
service: total inventory turnovers 4.88 1024 586
service: total monetary turnovers 6.99 25 839
service: aggregate perf. data 0.83 20755 100
service: refresh index statistics 0.03 213720 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-02-2021 16:28:31 to 15-02-2021 16:28:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8722
TEST_TIME 2 7098
TEST_TIME 3 6740
TEST_TIME 4 7091
TEST_TIME 5 7561
TEST_TIME 6 7067
TEST_TIME 7 6748
TEST_TIME 8 6365
TEST_TIME 9 6435
TEST_TIME 10 6591
TEST_TIME 11 6351
TEST_TIME 12 6441
TEST_TIME 13 6691
TEST_TIME 14 6581
TEST_TIME 15 6811
TEST_TIME 16 6965
TEST_TIME 17 6945
TEST_TIME 18 6943
TEST_TIME 19 7386
TEST_TIME 20 7524
TEST_TIME 21 7716
TEST_TIME 22 8027
TEST_TIME 23 8611
TEST_TIME 24 8785
TEST_TIME 25 8646
TEST_TIME 26 8636
TEST_TIME 27 8985
TEST_TIME 28 9540
TEST_TIME 29 9871
TEST_TIME 30 11255
TEST_TIME 31 11095
TEST_TIME 32 10869
TEST_TIME 33 10767
TEST_TIME 34 10667
TEST_TIME 35 10525
TEST_TIME 36 10413
TEST_TIME 37 10223
TEST_TIME 38 10255
TEST_TIME 39 10089
TEST_TIME 40 9983
TEST_TIME 41 9933
TEST_TIME 42 9890
TEST_TIME 43 9714
TEST_TIME 44 9750
TEST_TIME 45 9631
TEST_TIME 46 9660
TEST_TIME 47 9502
TEST_TIME 48 9418
TEST_TIME 49 9336
TEST_TIME 50 9387
TEST_TIME 51 9429
TEST_TIME 52 9324
TEST_TIME 53 9217
TEST_TIME 54 9177
TEST_TIME 55 9139
TEST_TIME 56 9207
TEST_TIME 57 9224
TEST_TIME 58 9169
TEST_TIME 59 9159
TEST_TIME 60 9198
TEST_TIME 61 9310
TEST_TIME 62 9340
TEST_TIME 63 9359
TEST_TIME 64 9376
TEST_TIME 65 9306
TEST_TIME 66 9377
TEST_TIME 67 9345
TEST_TIME 68 9330
TEST_TIME 69 9410
TEST_TIME 70 9452
TEST_TIME 71 9493
TEST_TIME 72 9448
TEST_TIME 73 9336
TEST_TIME 74 9394
TEST_TIME 75 9304
TEST_TIME 76 9294
TEST_TIME 77 9299
TEST_TIME 78 9242
TEST_TIME 79 9283
TEST_TIME 80 9251
TEST_TIME 81 9224
TEST_TIME 82 9185
TEST_TIME 83 9144
TEST_TIME 84 9122
TEST_TIME 85 9131
TEST_TIME 86 9085
TEST_TIME 87 9062
TEST_TIME 88 9132
TEST_TIME 89 9170
TEST_TIME 90 9132
TEST_TIME 91 9256
TEST_TIME 92 9290
TEST_TIME 93 9293
TEST_TIME 94 9298
TEST_TIME 95 9338
TEST_TIME 96 9454
TEST_TIME 97 9484
TEST_TIME 98 9423
TEST_TIME 99 9490
TEST_TIME 100 9472
TEST_TIME 101 9441
TEST_TIME 102 9368
TEST_TIME 103 9346
TEST_TIME 104 9337
TEST_TIME 105 9295
TEST_TIME 106 9244
TEST_TIME 107 9255
TEST_TIME 108 9252
TEST_TIME 109 9213
TEST_TIME 110 9183
TEST_TIME 111 9176
TEST_TIME 112 9109
TEST_TIME 113 9132
TEST_TIME 114 9104
TEST_TIME 115 9105
TEST_TIME 116 9129
TEST_TIME 117 9187
TEST_TIME 118 9171
TEST_TIME 119 9177
TEST_TIME 120 9122

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-02-2021 16:28:35 to 15-02-2021 16:28:38.

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 1526367 1526367 0 0.00 0 11430 6 0 0
doc_list_biud 1526367 1526367 0 0.00 0 35685 31 0 0
sp_add_invoice_to_stock 5139 4993 146 2.84 24 173725 19012 0 146
sp_cancel_adding_invoice 5543 5543 0 0.00 5 76055 797 0 0
sp_cancel_client_order 1663 1663 0 0.00 4 10324 336 0 0
sp_cancel_customer_reserve 542365 542365 0 0.00 1 35686 69 0 0
sp_cancel_pay_from_customer 643 643 0 0.00 3 944 51 0 0
sp_cancel_pay_to_supplier 417 417 0 0.00 3 2020 59 0 0
sp_cancel_supplier_invoice 6083 6074 9 0.14 1 18517 891 0 9
sp_cancel_supplier_order 408 408 0 0.00 9 1224170 116122 0 0
sp_cancel_write_off 10026 10026 0 0.00 1 10903 110 0 0
sp_client_order 20524 20524 0 0.00 3 15513 355 0 0
sp_customer_reserve 466783 466783 0 0.00 0 53857 186 0 0
sp_fill_shopping_cart 31344 31344 0 0.00 1 20671 41 0 0
sp_fill_shopping_cart_clo_res 466780 466780 0 0.00 0 13796 14 0 0
sp_get_clo_for_invoice 4990 4990 0 0.00 0 24240 323 0 0
sp_kill_cost_storno 16629 16629 0 0.00 0 5901 59 0 0
sp_kill_qstorno_ret_qs2qd 1101238 1101238 0 0.00 0 35683 37 0 0
sp_kill_qty_storno 580985 580985 0 0.00 0 35685 79 0 0
sp_lock_selected_doc 20514 20514 0 0.00 0 6905 5 0 0
sp_make_cost_storno 27772 27772 0 0.00 0 8384 49 0 0
sp_multiply_rows_for_pdistr 27772 27772 0 0.00 0 8867 28 0 0
sp_multiply_rows_for_qdistr 20524 20524 0 0.00 0 12594 160 0 0
sp_pay_from_customer 7055 7055 0 0.00 4 12973 124 0 0
sp_pay_to_supplier 5811 5811 0 0.00 5 10939 124 0 0
sp_payment_common 12866 12866 0 0.00 1 7090 32 0 0
sp_qd_handle_on_cancel_clo 1663 1663 0 0.00 0 10315 309 0 0
sp_qd_handle_on_invoice_upd_sts 10532 10532 0 0.00 0 11145 350 0 0
sp_qd_handle_on_reserve_upd_sts 9917 9917 0 0.00 0 12350 60 0 0
sp_reserve_write_off 9917 9917 0 0.00 6 12434 173 0 0
sp_supplier_invoice 5376 5376 0 0.00 6 83388 3361 0 0
sp_supplier_order 5466 5466 0 0.00 5 31650 1297 0 0
srv_aggregate_perf_data 100 100 0 0.00 2626 263068 20756 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1096 135014 31526 0 0
srv_find_qd_qs_mism 1046725 1046725 0 0.00 0 11102 6 0 0
srv_make_invnt_saldo 586 586 0 0.00 47 92135 1025 0 0
srv_make_money_saldo 839 839 0 0.00 1 1176 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 111033 357363 213721 0 0
t$perf-abend:sp_add_invoice_to_stock 146 146 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4993 4993 0 0.00 0 12744 187 0 0
t$perf-norm:sp_cancel_adding_invoice 407 407 0 0.00 0 3759 103 0 0
t$perf-norm:sp_cancel_client_order 1663 1663 0 0.00 0 5804 19 0 0
t$perf-norm:sp_cancel_customer_reserve 676 676 0 0.00 0 2945 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 643 643 0 0.00 0 3871 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 417 417 0 0.00 0 923 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 376 376 0 0.00 0 505 9 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 21840 1704 0 0
t$perf-norm:sp_cancel_write_off 1018 1018 0 0.00 0 4989 14 0 0
t$perf-norm:sp_client_order 20524 20524 0 0.00 0 10934 20 0 0
t$perf-norm:sp_customer_reserve 937 937 0 0.00 0 986 4 0 0
t$perf-norm:sp_pay_from_customer 7055 7055 0 0.00 0 4909 9 0 0
t$perf-norm:sp_pay_to_supplier 5811 5811 0 0.00 0 6681 13 0 0
t$perf-norm:sp_reserve_write_off 9917 9917 0 0.00 0 9023 13 0 0
t$perf-norm:sp_supplier_invoice 5376 5376 0 0.00 0 8286 22 0 0
t$perf-norm:sp_supplier_order 5466 5466 0 0.00 0 7792 21 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 712 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 11196 71 0 0
t$perf-norm:srv_make_invnt_saldo 586 586 0 0.00 0 11898 45 0 0
t$perf-norm:srv_make_money_saldo 839 839 0 0.00 0 1001 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10270 9978 292 2.84 0 6890 17 0 292
v_all_customers 37678 37678 0 0.00 0 162 1 0 0
v_all_suppliers 30004 30004 0 0.00 0 196 1 0 0
v_all_wares 41048 41048 0 0.00 0 135 1 0 0
v_cancel_adding_invoice 814 814 0 0.00 0 1096 7 0 0
v_cancel_client_order 3326 3326 0 0.00 0 3471 5 0 0
v_cancel_customer_prepayment 1286 1286 0 0.00 0 361 4 0 0
v_cancel_customer_reserve 1352 1352 0 0.00 0 3269 11 0 0
v_cancel_payment_to_supplier 834 834 0 0.00 0 183 3 0 0
v_cancel_supplier_invoice 770 752 18 2.33 0 677 14 0 18
v_cancel_supplier_order 816 816 0 0.00 0 351 3 0 0
v_cancel_write_off 2036 2036 0 0.00 0 2597 13 0 0
v_max_id_clo_ord 5466 5466 0 0.00 0 7068 5 0 0
v_max_id_clo_res 937 937 0 0.00 0 2296 19 0 0
v_max_id_ord_sup 5354 5354 0 0.00 0 2771 4 0 0
v_max_non_paid_invoice 1629 1629 0 0.00 0 1697 4 0 0
v_max_non_paid_realizn 3757 3757 0 0.00 0 854 4 0 0
v_min_id_clo_ord 5466 5466 0 0.00 0 2967 6 0 0
v_min_id_clo_res 937 937 0 0.00 0 5325 18 0 0
v_min_id_ord_sup 5354 5354 0 0.00 0 3730 4 0 0
v_min_non_paid_invoice 5811 5811 0 0.00 0 5999 22 0 0
v_min_non_paid_realizn 7055 7055 0 0.00 0 7086 22 0 0
v_our_firm 9966 9966 0 0.00 0 15 1 0 0
v_reserve_write_off 19834 19834 0 0.00 0 4653 5 0 0
x_lock_depdocs_on_canc_invoice 11241 11241 0 0.00 0 11382 125 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 8734 348 0 0
x_make_qstorno_1000_1200 5466 5466 0 0.00 1 31635 1212 0 0
x_make_qstorno_1200_2000 5376 5376 0 0.00 3 82610 3211 0 0
x_make_qstorno_2100_3300 466783 466783 0 0.00 0 53854 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-02-2021 16:28:39 to 15-02-2021 16:28:43.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:22 6 8192000000 8810581344 8824197120 15178176 0.184 3 3 4 0 15416992 76800 162016
13:57:28 12203 8192000000 10217106496 10520580096 977829664 10.663 78 49 98 0 996863376 2689776 16343936
13:57:50 37189 8192000000 10354962624 10671443968 1388066464 14.489 100 86 172 0 1420146688 4318016 27762208
13:58:36 20245 8192000000 10390137056 10711437312 1435619472 14.911 100 93 185 2 1472262096 6577520 30065104
13:59:06 34578 8192000000 10414822304 10742484992 1465812432 15.177 100 92 184 0 1503762432 8002432 29947568
13:59:56 25910 8192000000 10448565440 10779136000 1498381424 15.462 100 90 180 1 1535906592 8945120 28580048
14:00:30 30161 8192000000 10467693360 10806468608 1518872096 15.640 100 92 184 0 1557389216 9425424 29091696
14:01:18 9127 8192000000 10485221280 10826973184 1542489296 15.845 100 86 172 0 1579415664 9754112 27172256
14:01:46 20654 8192000000 10508514448 10858782720 1565941376 16.047 100 83 163 0 1601169024 10158448 25069200
14:02:20 14160 8192000000 10542133440 10897559552 1599806144 16.338 100 79 158 0 1637971520 14371712 23793664
14:02:44 13846 8192000000 10560776624 10920501248 1621380736 16.522 100 73 146 0 1653571424 10384096 21806592
14:03:07 8358 8192000000 10571146560 10933776384 1640780464 16.686 100 74 147 1 1673113712 10548544 21784704
14:03:24 12528 8192000000 10606797488 10972786688 1664630576 16.888 100 77 154 2 1698857648 11273408 22953664
14:03:45 9926 8192000000 10624570784 10993119232 1683533632 17.047 100 81 163 0 1719343136 12034560 23774944
14:04:01 12019 8192000000 10639544816 11008679936 1700185040 17.187 100 80 158 1 1735461904 12858288 22418576
14:04:20 7660 8192000000 10650467520 11022770176 1707980432 17.252 100 75 150 0 1742048608 12734912 21333264
14:04:35 6853 8192000000 10667414192 11037888512 1721987024 17.369 100 74 148 1 1757376352 13595056 21794272
14:04:49 8124 8192000000 10685095056 11059650560 1742735920 17.541 100 85 171 2 1781080560 14422560 23922080
14:05:05 6837 8192000000 10695602592 11069730816 1750637840 17.607 100 84 168 5 1788914032 14110272 24165920
14:05:20 5782 8192000000 10692980224 11072086016 1760825504 17.691 100 80 161 0 1797137936 14406544 21905888
14:05:34 3004 8192000000 10705104928 11083882496 1768715344 17.756 100 82 164 0 1806461872 14423792 23322736
14:05:44 6070 8192000000 10706878208 11091521536 1773240656 17.794 100 74 145 1 1806898544 13655888 20002000
14:05:58 3275 8192000000 10711502688 11095715840 1778471952 17.837 100 80 160 0 1813694272 12641776 22580544
14:06:08 13398 8192000000 10706453360 11100798976 1785796368 17.897 100 74 148 2 1818567136 12339760 20431008
14:06:32 3097 8192000000 10745402480 11126546432 1807534864 18.076 100 88 176 1 1844798256 12017456 25245936
14:06:42 5092 8192000000 10743418480 11134283776 1813740064 18.126 100 81 159 1 1848682976 12828752 22114160
14:06:54 2447 8192000000 10765422464 11146444800 1817878784 18.160 100 85 171 2 1855434976 13437216 24118976
14:07:03 2387 8192000000 10764711568 11145576448 1822959552 18.202 100 87 174 1 1861776640 13964528 24852560
14:07:12 1907 8192000000 10770506608 11155886080 1832103440 18.276 100 90 182 0 1871089232 13265280 25720512
14:07:20 2731 8192000000 10785488128 11167899648 1835724864 18.306 100 90 183 2 1874654256 13752560 25176832
14:07:29 1274 8192000000 10784406608 11168354304 1844574688 18.378 100 94 188 2 1886395872 14451024 27370160
14:07:37 1544 8192000000 10786659520 11173408768 1845418672 18.385 100 87 174 2 1882481488 13214144 23848672
14:07:45 1284 8192000000 10798780096 11183779840 1851101504 18.431 100 96 192 2 1891410960 13158896 27150560
14:07:53 1615 8192000000 10799301904 11188326400 1858195712 18.489 100 96 193 0 1899011168 13530960 27284496
14:08:01 2240 8192000000 10801442768 11187040256 1859133632 18.496 100 93 186 1 1899371840 13297424 26940784
14:08:10 1522 8192000000 10813623696 11195846656 1860240032 18.505 100 95 190 1 1901967952 14768928 26958992
14:08:18 1682 8192000000 10810840832 11195092992 1862243232 18.521 100 96 190 2 1902962320 13088144 27630944
14:08:25 31585 8192000000 10776987792 11193950208 1856131440 18.472 100 53 106 0 1881717984 10416448 15170096
14:09:05 12739 8192000000 10761493328 11188850688 1859173360 18.497 100 22 44 1 1871191648 5490720 6527568
14:09:25 10178 8192000000 10777205152 11196411904 1861195376 18.513 100 25 51 1 1875653808 7767840 6690592
14:09:47 10091 8192000000 10781733088 11201667072 1868976448 18.576 100 21 42 1 1881008528 6309392 5722688
14:10:04 7989 8192000000 10780602224 11206230016 1870752800 18.590 100 27 54 2 1885536608 7073296 7710512
14:10:24 11612 8192000000 10775133744 11209256960 1875509072 18.629 100 16 32 0 1886181920 6378176 4294672
14:10:41 9607 8192000000 10780795488 11213099008 1875799824 18.631 100 20 40 2 1887006224 5927744 5278656
14:10:57 15703 8192000000 10790313184 11221573632 1879450288 18.661 100 15 31 2 1888862752 5420704 3991760
14:11:20 10140 8192000000 10789300224 11219533824 1882601456 18.686 100 15 28 3 1891708016 5141280 3965280
14:11:38 6139 8192000000 10794029440 11222691840 1886403776 18.717 100 34 67 1 1902894880 6681440 9809664
14:11:52 7504 8192000000 10791357888 11221995520 1885966736 18.713 100 30 60 1 1901193456 7529008 7697712
14:12:06 66809 8192000000 10803599536 11232690176 1886278016 18.716 100 26 52 0 1899317696 4932720 8106960
14:13:19 13483 8192000000 10801533312 11236667392 1889074416 18.738 100 26 52 1 1901903632 6155744 6673472
14:13:39 8006 8192000000 10820881168 11246788608 1895212384 18.788 100 43 87 0 1914690320 7933024 11544912
14:13:58 4059 8192000000 10807978896 11236966400 1890926416 18.753 100 34 66 1 1906829760 6148528 9754816
14:14:08 4497 8192000000 10828959344 11245232128 1898611664 18.815 100 42 84 0 1918223872 7246096 12366112
14:14:23 4977 8192000000 10831214320 11250102272 1900170928 18.828 100 35 69 2 1918199616 8192816 9835872
14:14:34 3839 8192000000 10810922960 11244998656 1898256848 18.812 100 24 48 1 1911334416 5992416 7085152
14:14:46 4689 8192000000 10832017376 11254394880 1902930272 18.850 100 35 70 3 1920483760 7496032 10057456
14:14:57 8689 8192000000 10813705744 11250540544 1905209376 18.868 100 27 55 2 1920152608 6615696 8327536
14:15:12 7503 8192000000 10827264784 11256672256 1907489264 18.886 100 32 65 1 1923624448 5871104 10264080
14:15:26 9182 8192000000 10812911584 11249238016 1898983712 18.818 100 26 51 1 1912842720 6186528 7672480
14:15:42 6172 8192000000 10822781056 11254132736 1902545888 18.847 100 27 54 1 1920504576 10413264 7545424
14:15:56 10065 8192000000 10817948880 11255607296 1907054768 18.883 100 21 41 2 1919225888 6109728 6061392
14:16:13 7595 8192000000 10811677728 11236880384 1869480784 18.580 98 24 49 3 1883134528 6551696 7102048
14:16:27 12645 8192000000 10801357712 11236474880 1883344544 18.692 99 31 62 0 1898209552 6586528 8278480
14:16:52 47897 8192000000 10822664608 11256131584 1902833888 18.849 100 27 55 2 1916307632 5160320 8313424
14:17:46 18536 8192000000 10773226144 11197566976 1770311632 17.770 93 21 42 1 1781472928 5244256 5917040
14:18:12 7950 8192000000 10788419472 11216617472 1842652128 18.362 98 27 54 1 1857472736 7292352 7528256
14:18:28 6082 8192000000 10777140368 11192651776 1768985536 17.759 94 36 71 2 1785691808 6624432 10081840
14:18:40 5295 8192000000 10765233152 11191848960 1822970496 18.202 98 27 52 2 1841801104 11044240 7786368
14:18:52 3910 8192000000 10756248352 11168735232 1759583136 17.681 95 28 55 1 1777879776 9648256 8648384
14:19:04 4959 8192000000 10758851696 11177529344 1827314608 18.237 99 46 92 0 1846980592 6523952 13142032
14:19:15 6486 8192000000 10731835392 11148259328 1715298512 17.313 93 39 79 0 1732270864 5605072 11367280
14:19:30 6496 8192000000 10723273968 11143938048 1761578608 17.697 97 23 45 1 1774833296 6998240 6256448
14:19:42 7335 8192000000 10725161856 11144036352 1751730096 17.616 96 34 68 3 1769013840 6528400 10755344
14:19:56 3456 8192000000 10727040800 11145748480 1776400144 17.820 98 18 37 0 1786814000 5675120 4738736
14:20:08 7361 8192000000 10737684576 11147808768 1808495680 18.084 100 28 56 2 1822740336 5798896 8445760
14:20:22 8497 8192000000 10724038432 11131191296 1749544560 17.598 97 32 60 0 1764610512 5471440 9594512
14:20:42 7795 8192000000 10690731536 11107033088 1732428832 17.456 96 21 42 1 1743483552 5414032 5640688
14:20:57 8494 8192000000 10690715984 11105292288 1749728016 17.599 98 34 68 0 1765110064 4850704 10531344
14:21:12 70251 8192000000 10689372016 11103649792 1656528960 16.820 92 40 78 2 1673100000 4956048 11614992
14:22:32 8218 8192000000 10721931984 11132497920 1781293984 17.860 99 44 88 0 1801603152 7197328 13111840
14:22:49 4674 8192000000 10710117376 11130441728 1783765344 17.880 99 49 98 2 1805686928 7622640 14298944
14:23:00 8284 8192000000 10735716128 11143389184 1794710064 17.970 99 39 77 3 1813229904 7730672 10789168
14:23:17 7202 8192000000 10747355264 11164536832 1818320688 18.164 100 37 73 3 1834623408 6022128 10280592
14:23:34 7599 8192000000 10747005936 11164844032 1827873152 18.242 100 23 45 2 1839894032 5966320 6054560
14:23:48 5126 8192000000 10740062704 11162955776 1813650384 18.126 99 24 47 2 1827249952 6155232 7444336
14:23:59 7888 8192000000 10738950144 11164532736 1813668624 18.126 99 25 50 0 1827043968 6332720 7042624
14:24:18 6912 8192000000 10743296800 11168260096 1830869888 18.266 100 14 28 0 1839753968 4781168 4102912
14:24:35 10414 8192000000 10755184112 11182645248 1841983792 18.357 100 32 65 1 1857270688 5586256 9700640
14:24:56 12984 8192000000 10768155248 11188187136 1844245168 18.375 100 19 37 0 1855236288 5695248 5295872
14:25:19 7130 8192000000 10764692880 11191566336 1849584928 18.419 100 18 36 1 1860383488 5759680 5038880
14:25:37 13523 8192000000 10766903552 11196411904 1853131872 18.448 100 15 30 0 1862148880 5044640 3972368
14:25:56 16722 8192000000 10774413552 11204210688 1857806960 18.485 100 22 42 2 1868701568 5101856 5792752
14:26:20 61972 8192000000 10806015936 11224076288 1870061264 18.585 100 45 89 3 1893403472 9610448 13731760
14:27:32 13218 8192000000 10823607776 11236794368 1891596080 18.759 100 67 134 0 1917924784 7038848 19289856
14:28:02 7187 8192000000 10828594704 11244384256 1899066288 18.819 100 52 104 2 1922044688 8688448 14289952
14:28:26 6857 8192000000 10839885104 11254448128 1905308256 18.869 100 61 123 2 1932963824 9792352 17863216
14:28:40 8057 8192000000 10838991392 11261640704 1911932480 18.922 100 47 94 0 1936115328 10977344 13205504
14:28:56 20125 8192000000 10840789264 11264761856 1896650576 18.799 99 48 96 1 1918330272 7981600 13698096
14:29:27 12966 8192000000 10858470784 11276914688 1919383152 18.982 100 51 101 1 1941430480 8804752 13242576
14:29:52 29673 8192000000 10859086016 11286654976 1923368992 19.014 100 59 118 0 1950765264 11069568 16326704
14:30:33 12039 8192000000 10861075648 11293200384 1927340096 19.046 100 45 90 1 1952837808 13098608 12399104
14:30:52 12136 8192000000 10874079728 11297095680 1933912656 19.098 100 59 118 2 1964300928 13418272 16970000
14:31:12 10139 8192000000 10876389728 11302150144 1938153520 19.132 100 56 110 1 1968786400 14461888 16170992
14:31:31 8660 8192000000 10879502656 11314708480 1942142656 19.164 100 50 99 1 1972132640 15019808 14970176
14:31:53 19058 8192000000 10878639456 11319177216 1946347712 19.197 100 38 76 1 1971586032 14512752 10725568
14:32:23 12503 8192000000 10898629088 11329904640 1954537056 19.263 100 43 86 2 1982354096 15004912 12812128
14:32:45 16201 8192000000 10902761888 11337859072 1963045152 19.330 100 53 103 4 1993232752 14911168 15276432
14:33:20 8324 8192000000 10914578224 11343470592 1967848848 19.368 100 57 110 2 1999544288 16485296 15210144
14:33:39 29736 8192000000 10900668256 11344048128 1970379856 19.388 100 44 88 0 1997717536 15062000 12275680
14:34:21 30444 8192000000 10909059504 11351560192 1968568656 19.374 100 39 77 0 1994831920 15297920 10965344
14:35:03 14093 8192000000 10920649088 11359191040 1982420784 19.484 100 43 84 0 2016518624 21579216 12518624
14:35:25 10870 8192000000 10932948832 11368419328 1992270960 19.562 100 55 108 2 2026208352 18025648 15911744
14:35:46 7376 8192000000 10953157840 11382276096 1999437312 19.618 100 57 114 1 2036131216 19797744 16896160
14:36:01 2376 8192000000 10953132016 11381223424 2004710624 19.660 100 70 139 2 2045127440 20744128 19672688
14:36:11 5955 8192000000 10963255952 11389751296 2004331936 19.657 100 65 130 1 2046447744 22650480 19465328
14:36:26 6212 8192000000 10957466592 11388440576 2006773280 19.676 100 57 113 0 2045959696 21762784 17423632
14:36:40 6175 8192000000 10956671152 11391967232 2004311536 19.657 100 60 119 0 2045351456 23079296 17960624
14:37:05 12087 8192000000 10949692576 11391324160 2005698960 19.668 100 49 98 0 2046721760 25452224 15570576
14:37:27 19336 8192000000 10942887008 11392208896 1985329568 19.507 99 39 78 2 2023050576 25660544 12060464
14:38:03 6629 8192000000 10958672992 11399475200 2004997648 19.662 100 42 84 1 2044935872 27751376 12186848
14:38:20 7911 8192000000 10958961968 11397177344 1990940128 19.551 99 54 108 0 2035550192 28671232 15938832
14:38:36 4482 8192000000 10949067728 11390316544 1980876464 19.472 99 50 100 3 2024678256 28906592 14895200
14:38:50 13103 8192000000 10946067712 11387494400 1996584288 19.596 100 48 94 0 2040670928 29679360 14407280
14:39:09 6461 8192000000 10967524592 11398254592 2007364032 19.681 100 77 153 2 2055325456 25510800 22450624
14:39:27 2334 8192000000 10984131664 11402317824 2012293152 19.720 100 81 157 2 2062480896 26805360 23382384
14:39:42 4133 8192000000 10977745360 11405443072 2016290896 19.751 100 73 148 0 2066057152 27363056 22403200
14:39:54 6562 8192000000 10979417264 11410317312 2017668064 19.762 100 72 144 2 2069370416 29499584 22202768
14:40:09 14677 8192000000 10978704592 11418718208 2020629120 19.785 100 68 136 2 2071526080 30392448 20504512
14:40:36 18706 8192000000 10954770160 11401195520 2001574592 19.635 100 45 90 0 2046061136 29800624 14685920
14:41:04 8420 8192000000 10946441696 11390128128 1990349648 19.547 99 40 80 0 2033466448 29894192 13222608
14:41:21 12589 8192000000 10973224384 11407728640 2005797792 19.668 100 62 122 1 2057244368 32528576 18918000
14:41:46 8512 8192000000 10992002144 11423772672 2022654768 19.801 100 79 156 1 2086136368 38860352 24621248
14:42:03 3648 8192000000 11009644352 11434336256 2032350432 19.877 100 86 171 2 2094350432 36414560 25585440
14:42:14 2364 8192000000 10992901424 11415789568 2007113392 19.679 99 83 164 0 2067946096 35914768 24917936
14:42:23 4200 8192000000 10998624032 11426992128 2025847696 19.826 100 80 160 2 2088458160 37925152 24685312
14:42:35 4825 8192000000 10996202736 11414294528 2003330784 19.649 99 86 171 2 2064310480 35430816 25548880
14:42:47 3654 8192000000 10999376848 11414556672 2016372000 19.752 100 90 178 0 2080191680 37228256 26591424
14:43:00 4135 8192000000 10974684912 11406561280 1987196464 19.522 99 71 142 0 2045620864 36795408 21628992
14:43:15 3555 8192000000 10967565216 11397574656 1991075392 19.552 100 71 142 3 2051928448 39152576 21700480
14:43:48 11563 8192000000 10963387248 11398094848 1992323888 19.562 100 71 141 3 2055760064 41503024 21933152
14:44:09 2702 8192000000 10987709424 11412615168 2002060736 19.639 100 80 161 2 2068778528 41902064 24815728
14:44:19 4217 8192000000 10979105280 11407261696 1996972704 19.599 100 72 141 2 2063700064 43807936 22919424
14:44:32 4235 8192000000 10993140384 11414728704 2002792272 19.645 100 82 164 0 2075946432 46805648 26348512
14:44:46 11474 8192000000 10991039376 11416158208 1984520960 19.500 99 66 132 0 2056209184 50216000 21472224
14:45:05 5428 8192000000 10976450848 11401252864 1983984640 19.496 100 69 138 2 2057703552 51500304 22218608
14:45:20 3347 8192000000 10981263808 11402407936 1982477440 19.484 100 77 154 2 2059103488 52695248 23930800
14:45:31 2638 8192000000 10964601904 11384135680 1968708912 19.375 100 78 156 1 2047158480 53982144 24467424
14:45:40 4668 8192000000 10944829264 11362967552 1951923008 19.242 99 71 140 2 2029245680 54935744 22386928
14:45:53 5906 8192000000 10956722016 11373367296 1952327264 19.245 99 73 145 1 2033614112 58098576 23188272
14:46:09 2667 8192000000 10981936736 11402829824 1984515856 19.500 100 87 173 1 2073916576 61811888 27588832
14:46:19 5921 8192000000 10967910160 11392073728 1974282640 19.419 100 69 138 1 2057000928 59699776 23018512
14:46:34 3883 8192000000 10969517040 11391213568 1969616912 19.382 100 75 148 0 2052753808 58908304 24228592
14:46:47 9682 8192000000 10963040064 11383652352 1955891200 19.273 99 74 149 1 2031837760 51730176 24216384
14:47:06 2185 8192000000 10981311696 11401764864 1982626496 19.485 100 75 148 1 2059258272 53003456 23628320
14:47:19 1886 8192000000 11001775712 11418140672 1994314944 19.578 100 84 169 1 2077841664 56301984 27224736
14:47:30 3918 8192000000 10982608400 11403112448 1987177584 19.521 100 85 170 1 2070933760 56810960 26945216
14:47:40 5349 8192000000 10995225168 11411812352 1986544624 19.516 100 83 164 0 2072549664 59053072 26951968
14:47:53 3752 8192000000 10996524240 11415863296 1990933584 19.551 100 79 156 1 2074670864 58206752 25530528
14:48:05 2235 8192000000 11005719088 11425763328 2001452224 19.634 100 88 174 0 2089985392 59787984 28745184
14:48:14 1742 8192000000 11014902320 11429924864 2003292000 19.649 100 88 178 1 2089992592 58546352 28154240
14:48:22 1969 8192000000 11006066832 11422433280 1999370208 19.618 100 91 180 2 2086734944 59200768 28163968
14:48:32 6543 8192000000 11014664640 11429335040 2001011056 19.631 100 85 170 1 2090878720 61929712 27937952
14:48:51 1095 8192000000 11003306400 11420172288 1991471680 19.555 100 88 172 1 2081662128 62990096 27200352
14:49:00 4549 8192000000 11013227392 11430408192 1997548944 19.603 100 81 162 0 2083528144 60099872 25879328
14:49:13 4547 8192000000 10990924688 11420180480 1994334832 19.578 100 71 142 1 2076802976 59356048 23112096
14:49:29 1289 8192000000 10973985024 11395911680 1967753376 19.368 100 77 154 0 2052543184 60074480 24715328
14:49:46 5497 8192000000 10973335648 11409256448 1967374096 19.365 99 52 105 0 2046274240 60228192 18671952
14:50:00 16161 8192000000 10976207408 11426131968 1986460336 19.516 100 51 102 0 2069278464 65328048 17490080
14:50:30 19239 8192000000 10955092064 11406921728 1974583280 19.422 99 42 84 0 2042594240 54363824 13647136
14:50:56 5026 8192000000 10979708400 11405840384 1984780800 19.503 100 58 115 2 2054003200 50677408 18544992
14:51:09 3600 8192000000 11007548640 11427422208 2003189312 19.648 100 75 151 2 2080514448 53395984 23929152
14:51:23 8073 8192000000 10980924368 11423621120 1991410048 19.555 100 46 92 3 2062545920 55739136 15396736
14:51:38 23044 8192000000 10972639840 11427323904 1989151296 19.537 100 37 74 0 2060238064 57721520 13365248
14:52:50 11201 8192000000 10969415232 11415924736 1954165120 19.260 98 32 64 0 2027642816 62159328 11318368
14:53:32 19615 8192000000 10978004688 11428667392 1981043152 19.473 100 32 64 1 2059806048 67079392 11683504
14:54:05 14821 8192000000 10969008896 11416825856 1954027888 19.259 99 42 84 0 2042843200 74130608 14684704
14:54:30 22165 8192000000 10947304576 11401773056 1948996544 19.218 99 34 68 3 2031771392 70229792 12545056
14:55:19 8328 8192000000 10942012160 11413520384 1950466528 19.230 100 21 42 0 2030520336 71825584 8228224
14:55:44 26368 8192000000 10948866496 11413282816 1956430784 19.278 100 21 42 1 2028470448 64056544 7983120
14:56:34 35807 8192000000 10945709104 11415126016 1958222608 19.292 100 15 30 0 2029821712 66124160 5474944
14:57:17 36949 8192000000 10883509136 11345932288 1917306128 18.965 98 7 14 1 1946374368 27658672 1409568
14:58:03 36388 8192000000 10894610544 11332923392 1938399632 19.134 98 34 66 0 1958487760 11622032 8466096
14:59:19 31963 8192000000 10886765584 11331850240 1903511936 18.855 97 37 74 0 1922362336 7251824 11598576
14:59:58 13155 8192000000 10874236064 11305910272 1885777264 18.712 96 53 104 2 1909845520 9260224 14808032
15:00:19 3746 8192000000 10896836512 11319689216 1937136256 19.124 100 51 100 1 1961926000 10767584 14022160
15:00:30 23838 8192000000 10881510832 11327373312 1922836432 19.010 99 22 44 0 1937091232 8468944 5785856
15:01:07 70223 8192000000 10889408768 11353403392 1952229568 19.244 100 16 32 1 1966545840 9505888 4810384
15:02:26 46616 8192000000 10892723200 11361927168 1967304480 19.364 100 12 24 1 1981937696 11307168 3326048
15:03:19 58361 8192000000 10905562544 11365617664 1955554720 19.271 99 25 50 2 1973396272 10444688 7396864
15:04:24 44760 8192000000 10901710704 11362258944 1951645296 19.240 99 26 52 0 1971499184 12542336 7311552
15:05:21 67903 8192000000 10908011376 11361050624 1948947232 19.218 99 11 23 2 1965044048 11999072 4097744
15:06:35 64607 8192000000 10922122752 11373871104 1981731824 19.478 100 28 56 2 2005301648 15710768 7859056
15:07:51 75495 8192000000 10905177520 11367133184 1944804368 19.185 98 25 51 0 1966501696 14669088 7028240
15:09:13 88052 8192000000 10916358464 11362689024 1957573120 19.287 99 22 42 0 1974067744 10345072 6149552
15:10:49 69339 8192000000 10883806544 11352072192 1920093568 18.988 97 37 74 3 1943088176 12081344 10913264
15:12:07 58195 8192000000 10901413552 11355734016 1950905680 19.234 99 21 42 0 1966295200 9089744 6299776
15:13:21 72187 8192000000 10901668144 11364368384 1970034128 19.386 100 19 38 0 1983743280 8359968 5349184
15:14:40 17761 8192000000 10906304880 11364888576 1977696448 19.446 100 19 38 0 1991631328 8569856 5365024
15:15:05 13596 8192000000 10909922032 11372146688 1981999344 19.481 100 23 46 2 1997346608 8660800 6686464
15:15:25 28111 8192000000 10901041024 11345297408 1963489120 19.334 99 52 104 3 1989416896 10863616 15064160
15:16:02 28148 8192000000 10900893856 11358674944 1973774032 19.415 100 48 94 0 1999622448 12269328 13579088
15:16:39 50170 8192000000 10922063808 11376746496 1986336928 19.515 100 59 117 1 2018274848 13926128 18011792
15:17:49 52271 8192000000 10907451312 11377254400 1980218608 19.466 100 9 18 0 1990738208 8095104 2424496
15:18:59 67784 8192000000 10901587440 11368706048 1951958928 19.242 98 9 18 0 1962879408 8437504 2482976
15:20:13 80191 8192000000 10887733136 11360223232 1945883136 19.194 98 13 26 0 1957738784 8269296 3586352
15:21:58 59404 8192000000 10904389680 11389239296 1977479040 19.445 100 11 22 1 1990501520 9830624 3191856
15:23:04 131289 8192000000 10891990320 11363856384 1909889072 18.906 96 11 22 0 1928244672 15490784 2864816
15:25:27 26099 8192000000 10893797264 11356573696 1925670112 19.032 97 26 52 0 1940557184 8058400 6828672
15:26:18 36028 8192000000 10916283792 11384922112 1981027152 19.473 100 30 60 1 2001635552 11984064 8624336
15:27:01 69104 8192000000 10929108768 11401498624 1981856592 19.479 99 19 38 0 1999434336 12603280 4974464
15:28:20 63990 8192000000 10922897840 11388067840 1918716480 18.977 96 14 28 1 1941458784 18116064 4626240
15:29:37 135013 8192000000 10882781248 11352838144 1777978784 17.833 89 9 18 0 1791441264 11004304 2458176
15:32:06 20928 8192000000 10890298016 11344351232 1926052576 19.035 98 43 86 0 1945485280 6802656 12630048
15:32:34 16271 8192000000 10903684992 11342696448 1912873184 18.930 97 47 92 0 1934957968 9356208 12728576
15:33:00 63679 8192000000 10882692352 11346022400 1894458528 18.782 97 18 36 0 1909332944 9983360 4891056
15:34:10 39330 8192000000 10899786752 11352305664 1944591456 19.183 99 33 66 0 1963168576 9687392 8889728
15:34:55 18906 8192000000 10905841616 11351150592 1954970016 19.266 100 45 90 4 1977615472 10575056 12070400
15:35:23 27167 8192000000 10908601488 11359281152 1962928048 19.329 100 58 116 2 1992428544 13972960 15527536
15:36:35 93448 8192000000 10833810112 11312144384 1800717792 18.020 92 9 18 0 1815857120 12099456 3039872
15:38:18 124966 8192000000 10825352928 11296231424 1785210960 17.892 93 10 20 0 1804374096 16430992 2732144
15:40:29 72564 8192000000 10832148528 11304038400 1865480976 18.548 97 23 46 0 1884457184 11560352 7415856
15:41:48 43337 8192000000 10837560624 11307614208 1898412256 18.814 99 16 32 1 1917182064 14400640 4369168
15:43:06 41043 8192000000 10862263824 11324915712 1933097264 19.092 100 35 69 3 1952042480 9429056 9516160
15:44:09 43549 8192000000 10844400752 11316674560 1881133776 18.674 97 23 46 0 1900096624 12468256 6494592
15:46:23 74529 8192000000 10846211520 11321806848 1902739376 18.848 98 22 44 0 1916875856 8143616 5992864
15:47:51 81654 8192000000 10855984880 11333484544 1919941856 18.986 99 10 19 0 1929659712 6706352 3011504
15:49:22 65746 8192000000 10850286032 11337555968 1907045104 18.883 98 12 24 0 1920958944 10425392 3488448
15:50:39 48716 8192000000 10855352160 11327299584 1921067232 18.995 99 15 30 0 1934620864 8845888 4707744
15:51:37 61886 8192000000 10861329680 11349553152 1926428400 19.038 99 9 18 0 1938628512 9819616 2380496
15:53:33 32534 8192000000 10873925232 11331637248 1926242496 19.037 99 17 34 1 1938836624 7934320 4659808
15:54:30 40987 8192000000 10881203392 11361644544 1953384112 19.253 100 19 36 2 1971656416 12474288 5798016
15:55:19 75126 8192000000 10875979616 11355451392 1918978496 18.979 98 14 28 1 1939494960 16208480 4307984
15:56:40 39293 8192000000 10892577648 11361280000 1947639840 19.208 99 16 32 3 1964123824 11554336 4929648
15:57:28 44581 8192000000 10871449296 11349692416 1891666256 18.759 96 14 28 1 1908345600 12787744 3891600
15:58:19 86304 8192000000 10877277952 11366567936 1915480864 18.951 98 10 20 0 1933191264 15241664 2468736
15:59:52 78210 8192000000 10906356176 11384168448 1937421904 19.126 98 13 25 1 1950067776 9653584 2992288
16:01:51 35341 8192000000 10943942656 11385569280 1976258400 19.435 100 28 54 1 2000146320 15910416 7977504
16:02:34 64764 8192000000 10903632864 11393794048 1980177248 19.466 100 14 28 0 2005256640 20962288 4117104
16:03:49 131591 8192000000 10932451632 11389935616 1892998640 18.770 95 29 58 2 1917458080 16376272 8083168
16:06:11 65792 8192000000 10914956320 11385229312 1965820016 19.352 99 31 62 1 1992922928 18786368 8316544
16:07:23 64751 8192000000 10925667424 11392434176 1966047872 19.354 99 37 74 0 1990593824 14085008 10460944
16:08:34 101190 8192000000 10898649424 11361685504 1894877440 18.785 96 15 30 1 1913489536 13275552 5336544
16:11:04 36999 8192000000 10900854768 11379949568 1955546848 19.271 99 13 26 0 1974518128 15323392 3647888
16:11:48 24503 8192000000 10894813504 11373608960 1952465520 19.246 99 7 14 0 1969048784 14005920 2577344
16:12:19 34165 8192000000 10888270816 11363274752 1954549280 19.263 99 19 38 1 1970271248 10486848 5235120
16:13:19 66563 8192000000 10896150592 11375210496 1965230704 19.348 99 10 20 0 1978196640 10210400 2755536
16:14:33 57994 8192000000 10901250896 11380264960 1961911440 19.321 99 17 33 1 1981861024 14977024 4972560
16:15:37 69408 8192000000 10906288160 11385397248 1945538192 19.191 98 12 24 0 1966466400 17601680 3326528
16:16:53 67510 8192000000 10899501840 11388448768 1985680688 19.510 100 16 31 0 2001833344 11207152 4945504
16:18:18 87399 8192000000 10895019536 11373453312 1945811712 19.193 98 10 20 0 1955004304 6631600 2560992
16:19:51 74225 8192000000 10874084576 11365007360 1899532496 18.823 96 17 34 0 1913359568 9375040 4452032
16:21:12 68500 8192000000 10900712304 11378642944 1936112768 19.116 98 12 24 1 1952234560 12817136 3304656
16:22:30 36045 8192000000 10916576912 11376508928 1935596288 19.112 98 21 42 2 1958456432 16927168 5932976
16:23:12 30175 8192000000 10898476736 11369947136 1917436416 18.966 97 36 72 1 1948019056 19845808 10736832
16:23:58 57307 8192000000 10871463984 11343192064 1866363136 18.555 95 18 36 1 1884907984 13881680 4663168
16:25:02 27746 8192000000 10864413104 11322785792 1890258160 18.748 97 23 46 1 1905499664 8810832 6430672
16:25:52 42031 8192000000 10878298736 11353264128 1915272960 18.949 98 27 55 1 1936479184 13123440 8082784
16:26:41 50657 8192000000 9159761792 9407545344 324383744 3.808 17 9 17 0 331735248 4420864 2930640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 15-02-2021 16:28:45 to 15-02-2021 16:29:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 146 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

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          236132
MON$OLDEST_ACTIVE               236133
MON$OLDEST_SNAPSHOT             236133
MON$NEXT_TRANSACTION            236133
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                       2029664
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

15.02.21 16:29:20. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-02-15 16:29:23 No severe PSQL-related problems occured
15.02.21 16:29:24. End of report.