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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-10 16:27:14
DTS_END                         2021-01-10 16:27:14.6460
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/48442
TRN_ID                          236148
ATT_ID                          638
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: 9293.17 21792 1115181
customer order: creation 169.83 385 20379
customer order: refuse 14.35 376 1722
order to supplier: creation 44.90 1270 5388
order to supplier: removal 3.53 100181 424
invoice (draft): creation 45.23 3016 5427
invoice (draft): removal 52.83 812 6340
invoice accept: apply 41.83 17708 5019
invoice accept: cancel 48.32 849 5798
customer reserve: creation 3875.54 173 465065
customer reserve: removal 4703.66 60 564439
realization accept: apply 81.85 201 9822
realization accept: cancel 81.91 114 9829
payment from customer: creation 59.46 145 7135
payment from customer: removal 5.92 98 710
payment to supplier: creation 48.09 154 5771
payment to supplier: removal 3.53 73 423
service: total inventory turnovers 4.73 1238 568
service: total monetary turnovers 6.82 27 818
service: aggregate perf. data 0.83 17632 100
service: refresh index statistics 0.03 291327 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-01-2021 16:28:57 to 10-01-2021 16:28:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4058
TEST_TIME 2 4412
TEST_TIME 3 4402
TEST_TIME 4 4241
TEST_TIME 5 5301
TEST_TIME 6 4990
TEST_TIME 7 4938
TEST_TIME 8 5130
TEST_TIME 9 5385
TEST_TIME 10 5702
TEST_TIME 11 6341
TEST_TIME 12 6766
TEST_TIME 13 6883
TEST_TIME 14 7291
TEST_TIME 15 7133
TEST_TIME 16 7861
TEST_TIME 17 7680
TEST_TIME 18 7947
TEST_TIME 19 8279
TEST_TIME 20 8481
TEST_TIME 21 8795
TEST_TIME 22 9109
TEST_TIME 23 9038
TEST_TIME 24 9282
TEST_TIME 25 9481
TEST_TIME 26 9258
TEST_TIME 27 10129
TEST_TIME 28 11256
TEST_TIME 29 11004
TEST_TIME 30 10758
TEST_TIME 31 10812
TEST_TIME 32 10734
TEST_TIME 33 10543
TEST_TIME 34 10415
TEST_TIME 35 10275
TEST_TIME 36 10211
TEST_TIME 37 10065
TEST_TIME 38 9968
TEST_TIME 39 9904
TEST_TIME 40 10018
TEST_TIME 41 10025
TEST_TIME 42 9842
TEST_TIME 43 9735
TEST_TIME 44 9564
TEST_TIME 45 9494
TEST_TIME 46 9357
TEST_TIME 47 9251
TEST_TIME 48 9418
TEST_TIME 49 9606
TEST_TIME 50 9539
TEST_TIME 51 9443
TEST_TIME 52 9300
TEST_TIME 53 9235
TEST_TIME 54 9169
TEST_TIME 55 9067
TEST_TIME 56 9015
TEST_TIME 57 9047
TEST_TIME 58 9049
TEST_TIME 59 8992
TEST_TIME 60 9062
TEST_TIME 61 9152
TEST_TIME 62 9112
TEST_TIME 63 9190
TEST_TIME 64 9322
TEST_TIME 65 9309
TEST_TIME 66 9327
TEST_TIME 67 9410
TEST_TIME 68 9373
TEST_TIME 69 9529
TEST_TIME 70 9557
TEST_TIME 71 9538
TEST_TIME 72 9489
TEST_TIME 73 9379
TEST_TIME 74 9369
TEST_TIME 75 9297
TEST_TIME 76 9314
TEST_TIME 77 9347
TEST_TIME 78 9298
TEST_TIME 79 9252
TEST_TIME 80 9206
TEST_TIME 81 9137
TEST_TIME 82 9101
TEST_TIME 83 9129
TEST_TIME 84 9160
TEST_TIME 85 9158
TEST_TIME 86 9143
TEST_TIME 87 9176
TEST_TIME 88 9206
TEST_TIME 89 9242
TEST_TIME 90 9266
TEST_TIME 91 9260
TEST_TIME 92 9342
TEST_TIME 93 9345
TEST_TIME 94 9411
TEST_TIME 95 9396
TEST_TIME 96 9419
TEST_TIME 97 9393
TEST_TIME 98 9427
TEST_TIME 99 9363
TEST_TIME 100 9344
TEST_TIME 101 9278
TEST_TIME 102 9310
TEST_TIME 103 9276
TEST_TIME 104 9233
TEST_TIME 105 9227
TEST_TIME 106 9185
TEST_TIME 107 9167
TEST_TIME 108 9159
TEST_TIME 109 9158
TEST_TIME 110 9177
TEST_TIME 111 9178
TEST_TIME 112 9212
TEST_TIME 113 9211
TEST_TIME 114 9225
TEST_TIME 115 9230
TEST_TIME 116 9255
TEST_TIME 117 9254
TEST_TIME 118 9264
TEST_TIME 119 9330
TEST_TIME 120 9295

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-01-2021 16:29:01 to 10-01-2021 16:29:04.

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 1545375 1545375 0 0.00 0 16193 6 0 0
doc_list_biud 1545375 1545375 0 0.00 0 27652 28 0 0
sp_add_invoice_to_stock 5213 5019 194 3.72 33 177865 17709 0 194
sp_cancel_adding_invoice 5798 5798 0 0.00 5 60073 850 0 0
sp_cancel_client_order 1722 1722 0 0.00 4 11666 376 0 0
sp_cancel_customer_reserve 564439 564439 0 0.00 1 22368 60 0 0
sp_cancel_pay_from_customer 710 710 0 0.00 3 8195 98 0 0
sp_cancel_pay_to_supplier 423 423 0 0.00 3 3190 73 0 0
sp_cancel_supplier_invoice 6352 6340 12 0.18 1 21330 813 0 12
sp_cancel_supplier_order 424 424 0 0.00 6 991609 100181 0 0
sp_cancel_write_off 9829 9829 0 0.00 1 13935 115 0 0
sp_client_order 20379 20379 0 0.00 4 27895 386 0 0
sp_customer_reserve 465065 465065 0 0.00 0 63433 174 0 0
sp_fill_shopping_cart 31192 31192 0 0.00 1 13245 39 0 0
sp_fill_shopping_cart_clo_res 465060 465060 0 0.00 0 13982 14 0 0
sp_get_clo_for_invoice 5014 5014 0 0.00 0 28379 377 0 0
sp_kill_cost_storno 16760 16760 0 0.00 0 13905 55 0 0
sp_kill_qstorno_ret_qs2qd 1145471 1145471 0 0.00 0 22344 32 0 0
sp_kill_qty_storno 603388 603388 0 0.00 0 27651 70 0 0
sp_lock_selected_doc 20631 20631 0 0.00 0 9783 4 0 0
sp_make_cost_storno 27742 27742 0 0.00 0 15033 62 0 0
sp_multiply_rows_for_pdistr 27742 27742 0 0.00 0 9980 33 0 0
sp_multiply_rows_for_qdistr 20379 20379 0 0.00 0 23243 177 0 0
sp_pay_from_customer 7135 7135 0 0.00 4 18149 145 0 0
sp_pay_to_supplier 5771 5771 0 0.00 5 16939 155 0 0
sp_payment_common 12906 12906 0 0.00 1 18084 42 0 0
sp_qd_handle_on_cancel_clo 1722 1722 0 0.00 0 11659 345 0 0
sp_qd_handle_on_invoice_upd_sts 10812 10812 0 0.00 0 27648 317 0 0
sp_qd_handle_on_reserve_upd_sts 9822 9822 0 0.00 0 21395 58 0 0
sp_reserve_write_off 9822 9822 0 0.00 6 21474 202 0 0
sp_supplier_invoice 5427 5427 0 0.00 6 72567 3016 0 0
sp_supplier_order 5388 5388 0 0.00 5 36592 1270 0 0
srv_aggregate_perf_data 100 100 0 0.00 2500 115118 17632 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1151 129634 34489 0 0
srv_find_qd_qs_mism 1067365 1067365 0 0.00 0 10653 5 0 0
srv_make_invnt_saldo 568 568 0 0.00 46 127780 1238 0 0
srv_make_money_saldo 818 818 0 0.00 0 3284 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 168886 544119 291328 0 0
t$perf-abend:sp_add_invoice_to_stock 194 194 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5019 5019 0 0.00 0 21396 184 0 0
t$perf-norm:sp_cancel_adding_invoice 459 459 0 0.00 0 2015 68 0 0
t$perf-norm:sp_cancel_client_order 1722 1722 0 0.00 0 5171 15 0 0
t$perf-norm:sp_cancel_customer_reserve 658 658 0 0.00 0 320 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 710 710 0 0.00 0 6284 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 423 423 0 0.00 0 138 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 6849 28 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 24089 1469 0 0
t$perf-norm:sp_cancel_write_off 1000 1000 0 0.00 0 11401 25 0 0
t$perf-norm:sp_client_order 20379 20379 0 0.00 0 7514 20 0 0
t$perf-norm:sp_customer_reserve 986 986 0 0.00 0 7673 17 0 0
t$perf-norm:sp_pay_from_customer 7135 7135 0 0.00 0 8495 11 0 0
t$perf-norm:sp_pay_to_supplier 5771 5771 0 0.00 0 9712 17 0 0
t$perf-norm:sp_reserve_write_off 9822 9822 0 0.00 0 6177 12 0 0
t$perf-norm:sp_supplier_invoice 5427 5427 0 0.00 0 7125 22 0 0
t$perf-norm:sp_supplier_order 5388 5388 0 0.00 0 14018 18 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 1568 31 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 427 8 0 0
t$perf-norm:srv_make_invnt_saldo 568 568 0 0.00 0 1936 19 0 0
t$perf-norm:srv_make_money_saldo 818 818 0 0.00 0 1763 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10416 10028 388 3.72 0 17850 26 0 388
v_all_customers 37398 37398 0 0.00 0 28 1 0 0
v_all_suppliers 30226 30226 0 0.00 0 83 1 0 0
v_all_wares 40758 40758 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 918 918 0 0.00 0 1665 10 0 0
v_cancel_client_order 3444 3444 0 0.00 0 6855 10 0 0
v_cancel_customer_prepayment 1420 1420 0 0.00 0 7919 12 0 0
v_cancel_customer_reserve 1316 1316 0 0.00 0 1038 4 0 0
v_cancel_payment_to_supplier 846 846 0 0.00 0 977 5 0 0
v_cancel_supplier_invoice 822 798 24 2.91 0 1064 15 0 24
v_cancel_supplier_order 848 848 0 0.00 0 4976 13 0 0
v_cancel_write_off 2000 2000 0 0.00 0 8421 21 0 0
v_max_id_clo_ord 5388 5388 0 0.00 0 898 1 0 0
v_max_id_clo_res 986 986 0 0.00 0 1011 8 0 0
v_max_id_ord_sup 5425 5425 0 0.00 0 3355 4 0 0
v_max_non_paid_invoice 1471 1471 0 0.00 0 1242 5 0 0
v_max_non_paid_realizn 3674 3674 0 0.00 0 2781 4 0 0
v_min_id_clo_ord 5388 5388 0 0.00 0 3795 6 0 0
v_min_id_clo_res 986 986 0 0.00 0 3255 9 0 0
v_min_id_ord_sup 5425 5425 0 0.00 0 4592 7 0 0
v_min_non_paid_invoice 5771 5771 0 0.00 0 15783 27 0 0
v_min_non_paid_realizn 7135 7135 0 0.00 0 8948 30 0 0
v_our_firm 10282 10282 0 0.00 0 20 1 0 0
v_reserve_write_off 19644 19644 0 0.00 0 16567 10 0 0
x_lock_depdocs_on_canc_invoice 11739 11739 0 0.00 0 15497 123 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 24059 428 0 0
x_make_qstorno_1000_1200 5388 5388 0 0.00 1 36563 1193 0 0
x_make_qstorno_1200_2000 5427 5427 0 0.00 3 68578 2876 0 0
x_make_qstorno_2100_3300 465065 465065 0 0.00 0 63430 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-01-2021 16:29:05 to 10-01-2021 16:29:09.

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:17 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:23 26215 8192000000 10271473952 10577588224 931057840 10.205 72 54 110 0 951469456 2813664 17597952
13:57:58 13665 8192000000 10319017824 10633555968 1372169824 14.346 100 85 170 0 1406122240 4714272 29238144
13:58:22 23785 8192000000 10378908416 10699005952 1432256096 14.881 100 95 190 0 1468665216 5710496 30698624
13:58:59 31223 8192000000 10411129056 10737233920 1456113408 15.092 100 92 183 0 1492795312 7023360 29658544
13:59:38 26071 8192000000 10432572816 10763366400 1481722112 15.316 100 89 178 0 1518562224 7979056 28861056
14:00:15 11455 8192000000 10446681920 10778554368 1502599328 15.499 100 89 178 0 1539945408 8654400 28691680
14:00:36 22806 8192000000 10455626960 10793693184 1511352016 15.575 100 83 166 2 1546786864 9136672 26298176
14:01:09 16803 8192000000 10484100944 10821255168 1534185728 15.773 100 90 180 0 1572460048 10094112 28180208
14:01:37 20149 8192000000 10494612464 10846728192 1555144544 15.954 100 78 156 1 1589180944 10344768 23691632
14:02:08 11007 8192000000 10538452256 10891657216 1588495024 16.241 100 77 154 0 1622386656 10950608 22941024
14:02:33 18354 8192000000 10566814992 10922192896 1613080176 16.451 100 78 156 1 1647238480 11047296 23111008
14:03:00 14069 8192000000 10580873184 10943504384 1640939120 16.688 100 88 176 2 1679095312 11798192 26358000
14:03:21 11973 8192000000 10589678304 10954371072 1654930528 16.806 100 80 160 1 1690852864 12620912 23301424
14:03:42 7805 8192000000 10608621952 10974916608 1675548448 16.980 100 79 158 1 1711256352 13012560 22695344
14:03:58 9276 8192000000 10622790848 10993000448 1689101920 17.094 100 82 163 0 1725480096 12735424 23642752
14:04:17 9990 8192000000 10641573440 11015507968 1707495184 17.248 100 81 162 0 1744085120 13029488 23560448
14:04:38 5412 8192000000 10647461968 11025985536 1717726128 17.333 100 71 138 2 1750326656 12759344 19841184
14:04:50 7662 8192000000 10670057856 11050946560 1740395920 17.522 100 85 170 2 1777867776 12974064 24497792
14:05:05 5495 8192000000 10689361008 11066400768 1751404928 17.613 100 83 166 2 1787633072 13026592 23201552
14:05:18 5431 8192000000 10687306560 11068780544 1755467088 17.647 100 72 144 1 1788558544 12881264 20210192
14:05:30 5334 8192000000 10711275392 11089776640 1769579584 17.764 100 79 158 0 1804551840 12999120 21973136
14:05:43 3345 8192000000 10715774592 11095252992 1774326128 17.803 100 78 154 0 1808288832 12486848 21475856
14:05:53 10736 8192000000 10715966944 11101921280 1783198544 17.876 100 75 151 1 1816288080 12818928 20270608
14:06:13 3446 8192000000 10729394688 11116769280 1791701936 17.946 100 83 164 1 1827552672 12900240 22950496
14:06:23 2961 8192000000 10746305456 11134840832 1809153568 18.089 100 85 170 1 1846925776 13452848 24319360
14:06:33 4876 8192000000 10748760224 11134480384 1814171280 18.130 100 78 155 2 1849609952 12774192 22664480
14:06:44 3637 8192000000 10754393504 11143462912 1818434752 18.165 100 77 154 1 1852986176 11814656 22736768
14:06:56 4421 8192000000 10767944096 11156189184 1831799504 18.274 100 85 168 1 1866912432 11492400 23620528
14:07:07 2270 8192000000 10775173216 11161739264 1838012560 18.325 100 85 169 1 1873780880 11245904 24522416
14:07:16 3903 8192000000 10781159520 11166666752 1841733504 18.355 100 93 187 1 1880800752 12306176 26761072
14:07:26 3764 8192000000 10786818736 11173355520 1846283968 18.392 100 92 184 0 1884260912 11953440 26023504
14:07:36 2750 8192000000 10795461440 11180498944 1849168832 18.415 100 89 176 1 1888897696 14504176 25224688
14:07:46 2505 8192000000 10800857088 11186720768 1852124224 18.439 100 89 177 0 1891451872 14709312 24618336
14:07:55 2902 8192000000 10798797392 11187105792 1853520304 18.451 100 88 175 2 1892042848 14663488 23859056
14:08:04 3272 8192000000 10801713120 11188396032 1859860864 18.502 100 96 190 2 1900868848 14303952 26704032
14:08:14 1849 8192000000 10805722672 11192254464 1858231216 18.489 100 96 193 1 1900614032 14861616 27521200
14:08:22 2008 8192000000 10794112880 11180711936 1854993632 18.463 100 89 180 1 1893821264 14025792 24801840
14:08:31 2021 8192000000 10803406480 11188817920 1856973424 18.479 100 92 183 1 1896800928 13735424 26092080
14:08:39 2009 8192000000 10802978016 11191623680 1859745136 18.501 100 95 190 1 1900828112 13952768 27130208
14:08:48 1748 8192000000 10802646576 11195400192 1859084896 18.496 100 88 177 0 1897930480 13510672 25334912
14:08:56 1755 8192000000 10803437600 11197403136 1860995200 18.511 100 86 172 0 1898458768 13201536 24262032
14:09:04 1097 8192000000 10809892048 11199258624 1867046816 18.560 100 90 179 1 1906704800 14661056 24996928
14:09:12 8807 8192000000 10791346320 11196514304 1862946688 18.527 100 65 127 2 1892986768 12818432 17221648
14:09:28 4564 8192000000 10803336400 11199148032 1868552272 18.573 100 75 150 3 1900110640 10135280 21423088
14:09:39 17658 8192000000 10813262480 11209928704 1872146432 18.602 100 85 170 0 1907204256 11292736 23765088
14:10:03 1713 8192000000 10827283888 11219435520 1878758416 18.655 100 88 176 1 1915050384 11902240 24389728
14:10:11 12039 8192000000 10800054752 11206160384 1878004256 18.649 100 62 125 1 1907156752 10781712 18370784
14:10:31 4396 8192000000 10790874464 11207372800 1873726304 18.614 100 48 96 0 1895858624 8971968 13160352
14:10:42 6550 8192000000 10794872848 11213447168 1875551312 18.629 100 45 88 0 1898214064 10427792 12234960
14:10:56 1780 8192000000 10806326080 11212443648 1881937776 18.681 100 60 121 1 1907331328 7197568 18195984
14:11:05 5799 8192000000 10787814320 11207630848 1881661088 18.679 100 51 102 3 1907961968 12113008 14187872
14:11:18 5855 8192000000 10795065264 11213422592 1878055040 18.649 100 40 80 1 1897962416 8974336 10933040
14:11:32 7328 8192000000 10781852160 11212562432 1880768848 18.671 100 36 72 1 1898308160 7395840 10143472
14:11:50 4151 8192000000 10800495456 11219382272 1880442736 18.669 100 30 60 3 1895034304 6478608 8112960
14:12:00 7751 8192000000 10792367840 11219021824 1880078528 18.666 100 28 56 0 1899688256 12064192 7545536
14:12:19 4524 8192000000 10793341312 11216326656 1880731952 18.671 100 25 46 0 1893896528 6269136 6895440
14:12:33 8616 8192000000 10789521120 11221487616 1884464464 18.701 100 23 46 1 1897240624 6134400 6641760
14:12:50 10952 8192000000 10788363504 11222548480 1883971040 18.697 100 21 41 1 1895444240 5536304 5936896
14:13:12 10491 8192000000 10790232512 11222417408 1883649696 18.695 100 12 24 2 1892678688 5551808 3477184
14:13:32 11529 8192000000 10802418992 11225939968 1889469488 18.742 100 26 52 1 1902254992 5127968 7657536
14:13:51 63989 8192000000 10820736928 11245576192 1894281872 18.780 100 35 67 3 1909293808 5273264 9738672
14:15:02 9685 8192000000 10806432640 11242168320 1895019136 18.786 100 31 60 3 1909830928 6563744 8248048
14:15:20 8994 8192000000 10814295440 11252862976 1898166800 18.812 100 31 62 2 1914006608 7225760 8614048
14:15:37 2597 8192000000 10824345456 11243339776 1880992192 18.673 99 46 93 1 1900453312 6039408 13421712
14:15:46 5496 8192000000 10824086448 11243511808 1892110352 18.763 100 22 44 1 1904358576 6438528 5809696
14:15:58 4208 8192000000 10810284128 11240247296 1894892896 18.785 100 29 57 3 1909962912 6896896 8173120
14:16:10 9963 8192000000 10804408816 11242270720 1897657920 18.807 100 24 47 2 1910599168 6085904 6855344
14:16:28 6432 8192000000 10810193376 11243012096 1893476288 18.774 100 30 60 2 1908546848 7198928 7871632
14:16:41 5849 8192000000 10791947152 11227033600 1868598320 18.573 99 28 55 2 1886633456 9760752 8274384
14:16:55 8503 8192000000 10778412224 11208749056 1827034848 18.235 97 26 52 0 1840284240 5843552 7405840
14:17:10 6528 8192000000 10784930128 11221389312 1872254688 18.603 100 20 40 1 1884076944 6008592 5813664
14:17:23 8869 8192000000 10791634128 11227295744 1880222912 18.667 100 18 36 3 1892185632 5639776 6322944
14:17:38 7270 8192000000 10779383696 11207487488 1835313440 18.303 98 20 39 2 1847915424 6210800 6391184
14:17:55 11553 8192000000 10777020832 11208142848 1862730688 18.525 100 17 34 1 1873406064 5829312 4846064
14:18:13 8190 8192000000 10762663456 11195346944 1831140336 18.269 98 21 42 0 1843301856 5559392 6602128
14:18:29 7989 8192000000 10762236112 11187601408 1807026976 18.072 97 23 46 0 1819853392 5721840 7104576
14:18:45 19419 8192000000 10702286384 11129827328 1688737216 17.091 91 40 81 2 1705189968 4535504 11917248
14:19:25 35715 8192000000 10751780016 11150266368 1758424976 17.671 96 59 114 1 1780675712 5830560 16420176
14:20:07 8810 8192000000 10716816608 11144491008 1777543904 17.829 98 27 54 2 1792895536 7840176 7511456
14:20:22 7508 8192000000 10703353616 11122429952 1773818560 17.799 99 27 52 1 1792342512 10499664 8024288
14:20:38 8618 8192000000 10677281264 11094265856 1697937200 17.168 95 24 48 1 1710587568 5567952 7082416
14:20:56 4480 8192000000 10717421696 11114381312 1755674688 17.649 98 29 59 4 1769253984 5752560 7826736
14:21:10 9370 8192000000 10673673248 11084279808 1688652912 17.090 94 23 45 1 1701160496 5206176 7301408
14:21:29 9003 8192000000 10687079840 11104878592 1732353808 17.455 97 22 44 3 1744154512 5237968 6562736
14:21:45 7089 8192000000 10710402464 11128369152 1768400368 17.754 98 30 60 2 1783862576 7219184 8243024
14:21:58 8237 8192000000 10685896736 11093549056 1722777728 17.375 96 25 51 1 1734639664 5142000 6719936
14:22:14 5692 8192000000 10706114768 11127939072 1778319248 17.836 99 25 49 0 1791194960 5920880 6954832
14:22:27 10236 8192000000 10717155920 11142406144 1806916224 18.071 100 36 73 2 1823642784 5950800 10775760
14:22:46 9278 8192000000 10733037312 11162222592 1827224016 18.237 100 25 50 2 1841234768 5967168 8043584
14:23:01 12214 8192000000 10747783040 11164815360 1820231840 18.180 99 21 40 4 1830829024 4691696 5905488
14:23:21 12681 8192000000 10754877408 11182485504 1844867072 18.380 100 20 41 0 1856096624 5330400 5899152
14:23:44 17353 8192000000 10782886000 11198435328 1849417248 18.417 100 26 52 0 1862727216 5202432 8107536
14:24:07 57755 8192000000 10772598672 11198898176 1855510768 18.467 100 26 52 4 1869357552 6263664 7583120
14:25:14 7751 8192000000 10769529008 11200462848 1858884752 18.494 100 19 36 3 1870500832 5145984 6470096
14:25:30 9589 8192000000 10789099440 11210661888 1865083104 18.544 100 22 44 1 1880845568 9741248 6021216
14:25:48 10897 8192000000 10779717792 11208777728 1864848112 18.543 100 27 53 0 1879771200 6914704 8008384
14:26:07 3981 8192000000 10793257056 11216252928 1872034128 18.601 100 38 75 1 1889720384 6594704 11091552
14:26:21 5011 8192000000 10792018464 11210682368 1868076816 18.569 100 30 60 1 1883307872 6647424 8583632
14:26:35 5704 8192000000 10783177840 11214180352 1872718752 18.606 100 41 82 3 1890025456 5966752 11339952
14:26:46 8269 8192000000 10792675664 11221778432 1871249152 18.594 100 19 38 1 1886850912 10207792 5393968
14:27:01 7691 8192000000 10793152864 11226034176 1883581792 18.694 100 22 42 3 1898595568 9159248 5854528
14:27:17 3196 8192000000 10835683520 11243888640 1902720944 18.848 100 53 106 2 1921835328 4337456 14776928
14:27:35 22729 8192000000 10846972928 11262373888 1913424176 18.934 100 58 118 2 1937359520 7142512 16792832
14:28:25 17509 8192000000 10859536736 11280506880 1926229344 19.037 100 47 94 0 1953107680 13809392 13068944
14:28:52 19453 8192000000 10867876592 11291267072 1932637008 19.088 100 53 104 0 1962271200 15118000 14516192
14:29:20 23254 8192000000 10874253536 11297099776 1935889936 19.114 100 52 104 1 1965653040 15323936 14439168
14:29:57 32988 8192000000 10868948096 11305590784 1940568992 19.151 100 44 88 1 1969159840 16127776 12463072
14:31:17 50918 8192000000 10879717680 11321405440 1945566656 19.191 100 27 54 0 1973484448 19966016 7951776
14:32:16 64981 8192000000 10894334960 11332747264 1953855840 19.257 100 21 38 4 1985772608 25609392 6307376
14:33:31 9467 8192000000 10901466656 11334955008 1962058576 19.322 100 38 76 1 1991815616 18997856 10759184
14:33:48 10028 8192000000 10912856880 11339538432 1961887968 19.321 100 55 110 1 2003439856 25410736 16141152
14:34:11 9961 8192000000 10923568592 11344683008 1968204160 19.371 100 56 112 1 2008073648 23597152 16272336
14:34:29 8131 8192000000 10913644912 11344064512 1953530128 19.255 99 56 113 2 1994284816 24074176 16680512
14:35:18 17853 8192000000 10928736576 11359334400 1977534752 19.445 100 55 110 0 2018170512 23059344 17576416
14:35:45 26899 8192000000 10939233232 11362836480 1979813808 19.463 100 49 98 1 2019276624 24330992 15131824
14:36:24 9767 8192000000 10939917152 11371466752 1984989984 19.504 100 62 123 1 2034948240 30626240 19332016
14:36:44 7490 8192000000 10951029536 11380195328 1990182064 19.545 100 61 122 1 2041448224 31384304 19881856
14:37:00 8240 8192000000 10950214016 11387584512 1990400928 19.547 100 49 96 2 2033132704 28500384 14231392
14:37:17 4508 8192000000 10949292208 11382214656 1994721760 19.581 100 56 112 0 2039205760 27942400 16541600
14:37:29 5479 8192000000 10960483328 11386810368 2000823408 19.629 100 68 136 3 2051297808 29460816 21013584
14:37:43 7402 8192000000 10953834624 11382833152 1991491232 19.556 100 63 126 1 2041218064 30821920 18904912
14:37:57 4121 8192000000 10960718896 11386667008 1995362000 19.586 100 70 138 3 2048705520 32709264 20634256
14:38:09 5310 8192000000 10965124416 11386224640 1998935408 19.614 100 75 150 0 2048893664 27438656 22519600
14:38:21 6860 8192000000 10967075280 11389263872 2004718624 19.660 100 84 169 3 2059216912 29148592 25349696
14:38:38 3248 8192000000 10946292896 11364839424 1977997984 19.449 99 75 147 1 2027252320 28071872 21182464
14:38:48 7389 8192000000 10970755952 11389136896 2000497888 19.627 100 74 148 0 2053022368 29948704 22575776
14:39:03 5402 8192000000 10967773424 11397615616 2003836016 19.653 100 73 146 1 2055670016 29509120 22324880
14:39:17 9673 8192000000 10970248208 11401994240 2006263392 19.672 100 64 128 1 2058628944 32875200 19490352
14:39:39 7761 8192000000 10978664992 11412070400 2010327024 19.704 100 54 108 0 2060592064 33766688 16498352
14:39:54 11316 8192000000 10970692016 11412467712 2012665184 19.722 100 57 114 3 2063319008 33394064 17259760
14:40:25 8264 8192000000 10972282224 11408109568 1999137952 19.616 99 52 104 1 2044953856 29637232 16178672
14:40:45 3822 8192000000 10962643792 11393482752 2002979632 19.646 100 59 119 2 2049098704 28321984 17797088
14:40:56 2132 8192000000 10981153696 11399987200 2007221472 19.680 100 87 176 1 2062699616 29553072 25925072
14:41:06 7236 8192000000 10980610608 11404259328 2009777392 19.700 100 79 156 1 2063309648 30466528 23065728
14:41:21 2451 8192000000 10987623712 11407818752 2014114400 19.734 100 91 181 1 2071410640 31122848 26173392
14:41:31 3178 8192000000 10967858064 11396100096 2004164608 19.656 100 68 135 0 2056499408 32195824 20138976
14:41:43 13952 8192000000 10941701120 11391442944 1995672240 19.589 100 35 70 1 2036032304 29345280 11014784
14:42:05 7476 8192000000 10966778992 11402067968 2002970896 19.646 100 47 91 2 2050920384 32960096 14989392
14:42:20 6470 8192000000 10963261296 11403517952 2007203888 19.680 100 48 94 1 2053019328 30533216 15282224
14:42:35 3722 8192000000 10979709056 11408384000 1992508992 19.564 99 57 114 1 2045109392 34616048 17984352
14:42:48 9694 8192000000 10981671136 11406770176 1987504192 19.524 99 72 144 0 2050048256 39200736 23343328
14:43:05 5046 8192000000 10961870832 11396222976 1991808464 19.558 100 53 106 0 2048667376 40122144 16736768
14:43:18 1911 8192000000 10972418192 11394555904 1994140848 19.577 100 83 165 1 2058014512 38482000 25391664
14:43:27 8889 8192000000 10933812576 11377471488 1965094784 19.347 99 44 88 0 2016684944 37058096 14532064
14:43:54 15534 8192000000 10941500528 11371806720 1959344000 19.301 99 56 110 0 2009249072 33188096 16716976
14:44:22 1245 8192000000 10950938080 11380436992 1981539808 19.477 100 66 131 0 2040525856 38379456 20606592
14:44:32 7036 8192000000 10975854480 11398852608 1989326384 19.538 100 83 166 2 2059650704 45451456 24872864
14:44:48 4491 8192000000 10984502048 11397296128 1990041168 19.544 100 72 144 0 2054549472 41244992 23263312
14:44:59 4114 8192000000 10960546656 11380047872 1977168288 19.442 100 74 149 1 2043517344 42638256 23710800
14:45:12 4497 8192000000 10968502368 11385577472 1980304224 19.467 100 77 154 1 2047134368 43329648 23500496
14:45:23 1751 8192000000 10988778080 11400790016 1992927456 19.567 100 87 172 2 2066222976 46942496 26353024
14:45:33 2390 8192000000 10995581232 11410055168 1999668736 19.620 100 87 174 1 2074886768 48396176 26821856
14:45:43 2407 8192000000 10996129840 11409379328 1998848384 19.614 100 88 177 2 2073003696 47092928 27062384
14:45:53 1561 8192000000 10966045376 11384684544 1977812992 19.447 100 79 158 0 2049711888 47318640 24580256
14:46:01 5230 8192000000 10967659136 11392561152 1981948240 19.480 100 66 132 2 2045509488 43272736 20288512
14:46:13 1407 8192000000 10953166432 11369697280 1970749488 19.391 100 79 159 0 2036794432 41292864 24752080
14:46:24 1617 8192000000 10975273760 11391537152 1988875920 19.535 100 83 162 0 2056349200 41732592 25740688
14:46:32 4129 8192000000 10959057392 11371069440 1956480272 19.278 99 80 159 3 2021439920 40346896 24612752
14:46:44 1944 8192000000 10980892000 11391094784 1989481008 19.540 100 87 173 0 2058215392 42426448 26307936
14:46:53 1410 8192000000 10991733280 11399680000 1991405216 19.555 100 87 174 1 2060789888 42825440 26559232
14:47:02 1149 8192000000 10983561568 11389059072 1986245392 19.514 100 92 183 1 2058662160 44069872 28346896
14:47:10 4096 8192000000 10950235344 11376672768 1958954272 19.298 99 62 124 2 2023569952 43990064 20625616
14:47:26 12967 8192000000 10940048848 11375443968 1954911296 19.266 99 54 108 0 2018336848 45754000 17671552
14:47:49 11698 8192000000 10936966560 11370426368 1945547760 19.191 99 47 94 0 2007710576 46083712 16079104
14:48:13 8448 8192000000 10926279648 11368267776 1959428720 19.301 100 39 78 0 2018378112 45557296 13392096
14:48:30 2558 8192000000 10919571872 11327696896 1931071568 19.075 98 74 144 1 1989578288 36066704 22440016
14:48:41 2487 8192000000 10925472800 11346599936 1923631488 19.016 98 74 148 3 1985130864 37564592 23934784
14:48:52 7756 8192000000 10930921936 11358248960 1954802240 19.265 100 55 110 1 2013016320 40315632 17898448
14:49:08 7217 8192000000 10935907616 11359047680 1956427792 19.278 100 54 106 2 2014885648 41164256 17293600
14:49:22 12327 8192000000 10920434992 11353149440 1944891936 19.186 100 50 99 4 2003959616 42931088 16136592
14:49:50 8259 8192000000 10905137120 11338690560 1931557664 19.079 99 38 76 0 1985232384 40254944 13419776
14:50:11 10010 8192000000 10909455104 11346104320 1937280432 19.125 100 39 77 1 1990455824 40026480 13148912
14:50:29 7291 8192000000 10910790832 11340505088 1933756768 19.097 100 43 86 1 1989313328 40954112 14602448
14:50:48 4727 8192000000 10914949984 11342557184 1938904128 19.138 100 48 96 0 2000622496 45390288 16328080
14:51:03 18546 8192000000 10908610208 11349286912 1923754608 19.017 99 36 72 0 1980077136 43694592 12627936
14:52:09 17797 8192000000 10915783984 11362275328 1948863616 19.217 100 27 54 2 1999532784 41355824 9313344
14:52:33 30329 8192000000 10903260032 11352875008 1944237760 19.181 100 23 46 1 1990502304 38121264 8143280
14:53:11 28226 8192000000 10899020128 11349549056 1927982624 19.051 100 24 49 2 1986347488 48694000 9670864
14:53:57 26071 8192000000 10906550992 11368689664 1907256896 18.885 99 24 48 0 1977963760 60895552 9811312
14:54:30 8932 8192000000 10898059376 11358728192 1926231936 19.037 100 24 48 0 1988032160 52743872 9056352
14:54:52 50868 8192000000 10860628544 11321094144 1901348640 18.837 98 17 34 0 1955801584 48217568 6235376
14:55:50 46232 8192000000 10851991424 11298091008 1828446736 18.247 95 18 36 1 1847393456 13833920 5112800
14:56:43 25470 8192000000 10864319024 11288395776 1886874032 18.721 99 43 84 2 1915364224 16092928 12397264
14:57:20 82520 8192000000 10835811824 11285266432 1852153024 18.440 97 17 32 2 1875987664 18536080 5298560
14:59:05 21814 8192000000 10829784320 11284303872 1888047952 18.730 99 17 34 0 1912216256 19428832 4739472
14:59:36 31187 8192000000 10833137936 11304820736 1885682464 18.711 99 12 23 0 1906114704 17696448 2735792
15:00:14 76052 8192000000 10842990608 11300646912 1902042352 18.843 99 17 37 1 1915223456 8100080 5081024
15:01:36 105288 8192000000 10856414096 11312046080 1895288480 18.788 98 24 48 0 1914540560 12892240 6359840
15:03:39 29670 8192000000 10861331456 11305140224 1914190608 18.940 99 38 77 3 1936183872 10742736 11250528
15:04:20 38704 8192000000 10865859072 11318702080 1925146448 19.028 99 18 36 1 1939796976 9396112 5254416
15:05:05 56366 8192000000 10873225184 11334205440 1921118064 18.996 99 15 30 2 1940796880 15218000 4460816
15:06:07 101455 8192000000 10850805728 11307094016 1912279200 18.925 98 14 28 0 1932279952 15827488 4173264
15:08:26 65728 8192000000 10900268096 11348353024 1956494208 19.278 100 43 82 2 1978045168 8406592 13144368
15:09:38 129634 8192000000 10918199536 11365187584 1979232256 19.459 100 50 100 0 2008316176 15322736 13761184
15:12:17 18106 8192000000 10925155296 11384102912 1987963456 19.528 100 23 46 0 2011205904 16841424 6401024
15:12:58 66456 8192000000 10925414096 11374157824 1974602368 19.422 99 25 50 0 2006662256 24301216 7758672
15:14:28 64891 8192000000 10925587872 11404783616 1987353200 19.523 100 21 42 1 2019774256 26305024 6116032
15:15:39 28060 8192000000 10912502352 11399163904 1969588816 19.382 100 7 14 1 1998288256 26410416 2289024
15:16:14 45524 8192000000 10896799536 11394703360 1970798096 19.392 100 11 22 1 1992143648 18504960 2840592
15:17:33 63792 8192000000 10886669216 11365519360 1956603712 19.279 99 3 6 0 1965706192 8460528 641952
15:18:44 56440 8192000000 10908329968 11369168896 1976185936 19.434 100 23 47 3 1990640064 7107664 7346464
15:20:27 30032 8192000000 10903663296 11375538176 1982530464 19.485 100 16 30 0 1994495728 7231392 4733872
15:21:07 70744 8192000000 10891080848 11374764032 1968765984 19.376 99 9 18 0 1979135200 7688256 2680960
15:22:28 60239 8192000000 10898995632 11381374976 1967082864 19.362 99 8 16 0 1986209328 17132816 1993648
15:23:35 58159 8192000000 10907756624 11389419520 1979080208 19.457 100 9 18 0 1995187392 13575664 2531520
15:24:44 48902 8192000000 10915815568 11390803968 1972284560 19.404 99 9 18 1 1983029568 8282432 2462576
15:25:39 41643 8192000000 10923217504 11401134080 2004610800 19.659 100 21 42 2 2021619968 11023696 5985472
15:26:31 43779 8192000000 10933968880 11406475264 2006388256 19.673 100 27 54 0 2025618896 12135728 7094912
15:27:23 59723 8192000000 10926983504 11417788416 2005261328 19.664 100 13 26 1 2021156256 12347280 3547648
15:28:42 63981 8192000000 10947551168 11411533824 1987528848 19.524 99 13 26 0 2001959456 11113776 3316832
15:29:53 37063 8192000000 10944767408 11428077568 2010494368 19.705 100 20 40 1 2032603952 16433424 5676160
15:30:46 118452 8192000000 10933226240 11419250688 1929296368 19.061 96 17 34 0 1956040496 22329952 4414176
15:32:51 90673 8192000000 10916398624 11386130432 1909540400 18.903 96 18 36 1 1923859248 9363488 4955360
15:34:29 59160 8192000000 10938308576 11412738048 1989498480 19.540 100 16 32 0 2003472064 10075536 3898048
15:35:35 86425 8192000000 10908811776 11401924608 1931771024 19.081 97 19 38 1 1958763008 21633552 5358432
15:37:10 75553 8192000000 10917913520 11383697408 1932512960 19.087 97 20 40 1 1956813936 18824976 5476000
15:38:37 101859 8192000000 10875971552 11332194304 1857554720 18.483 94 23 46 1 1873960112 10719600 5685792
15:41:19 78303 8192000000 10875568656 11339337728 1859282608 18.497 94 31 62 1 1883773984 15574480 8916896
15:42:49 43874 8192000000 10840541024 11317424128 1892506480 18.766 98 22 44 1 1914728800 15337104 6885216
15:43:49 56706 8192000000 10823734128 11294380032 1815448096 18.140 94 17 34 0 1832748464 12494944 4805424
15:44:56 56227 8192000000 10841034400 11317067776 1903252896 18.852 99 2 4 0 1914394512 10730208 411408
15:45:58 40269 8192000000 10861121072 11320012800 1908976624 18.898 99 11 23 0 1922704848 10607120 3121104
15:46:46 64858 8192000000 10850039760 11316166656 1910574416 18.911 98 13 26 1 1923088016 9618464 2895136
15:47:57 106547 8192000000 10831672144 11290689536 1843371008 18.368 95 20 40 1 1862505472 12807184 6327280
15:49:50 32221 8192000000 10824374832 11291525120 1877109840 18.642 98 38 75 1 1903387712 15562320 10715552
15:50:28 54957 8192000000 10827346832 11304267776 1885162656 18.707 99 14 28 0 1904665440 15607568 3895216
15:52:13 33575 8192000000 10817781232 11281817600 1831304528 18.270 96 17 34 1 1844943216 8340512 5298176
15:52:56 38005 8192000000 10851240464 11306995712 1858808144 18.494 97 25 50 2 1878143888 12110928 7224816
15:53:45 53333 8192000000 10842507232 11294466048 1854188064 18.456 97 22 44 0 1874354544 13994224 6172256
15:54:46 30890 8192000000 10817372320 11282358272 1843069088 18.366 97 12 24 0 1862844848 15827792 3947968
15:55:23 45742 8192000000 10824553328 11287277568 1860133856 18.504 98 25 50 0 1876374544 9702368 6538320
15:56:35 75417 8192000000 10863407360 11321602048 1872187584 18.602 97 28 56 0 1891122608 11502368 7432656
15:57:58 35452 8192000000 10862956304 11313643520 1881934496 18.681 97 29 58 1 1899834592 10002288 7897808
15:58:41 69993 8192000000 10838748528 11307323392 1861820720 18.518 97 22 44 1 1877903168 10455008 5627440
16:00:01 89840 8192000000 10863913120 11328565248 1907578240 18.887 98 12 24 1 1922709872 11970496 3161136
16:01:40 116146 8192000000 10877213952 11345760256 1892367552 18.765 97 17 34 0 1907508256 11004752 4135952
16:03:42 59657 8192000000 10915513072 11364167680 1943522800 19.175 99 22 45 1 1962361504 12423312 6415392
16:04:48 42940 8192000000 10907418880 11360948224 1957935904 19.290 99 40 80 3 1984536880 15660976 10940000
16:05:46 108277 8192000000 10887127456 11351969792 1936167280 19.116 98 32 64 1 1952189616 6405280 9617056
16:07:42 62793 8192000000 10909499104 11368722432 1970713152 19.391 100 21 43 1 1983572976 6915424 5944400
16:08:52 49450 8192000000 10904295392 11380928512 1986997424 19.520 100 34 68 0 2005493840 9372576 9123840
16:10:02 53953 8192000000 10897251056 11381026816 1983998352 19.496 100 6 12 0 1992900176 7355648 1546176
16:11:02 47062 8192000000 10898803296 11384086528 1971857792 19.400 99 8 16 0 1981396208 7298112 2240304
16:12:07 66687 8192000000 10911257072 11390156800 1993599040 19.572 100 8 16 0 2003722080 7538608 2584432
16:13:26 76557 8192000000 10916187984 11393376256 1975325872 19.428 99 14 28 0 1990978560 11724160 3928528
16:14:49 42801 8192000000 10911423616 11386236928 1977391952 19.444 99 28 56 1 1993843360 8483264 7968144
16:15:44 45796 8192000000 10917347728 11388477440 1935061712 19.107 97 21 42 1 1956977744 16318864 5597168
16:16:38 51536 8192000000 10928290576 11386773504 1983221968 19.490 100 27 54 0 2000684784 9362784 8100032
16:17:37 64128 8192000000 10865236048 11342372864 1865913184 18.551 94 17 34 0 1879274224 8647872 4713168
16:18:53 60898 8192000000 10881586784 11352309760 1909334432 18.901 97 9 18 0 1921216272 9491616 2390224
16:20:01 39187 8192000000 10897278816 11373092864 1968972864 19.377 100 22 42 3 1990657360 15621136 6063360
16:20:46 47862 8192000000 10878440048 11346636800 1906298288 18.877 97 19 38 0 1926537456 14659280 5579888
16:21:48 46981 8192000000 10885489296 11352367104 1923738080 19.017 98 23 46 1 1945706800 15824352 6144368
16:22:42 35508 8192000000 10879396400 11334742016 1861131248 18.512 95 30 60 1 1879088832 9722208 8235376
16:23:27 57951 8192000000 10844506832 11322839040 1862599728 18.524 96 18 34 1 1877755888 10607120 4549040
16:24:32 81943 8192000000 10877049504 11348299776 1883353088 18.692 97 19 38 3 1904522128 16237072 4931968
16:26:24 67803 8192000000 9138727584 9395769344 282109728 3.329 15 2 4 0 290828752 8175680 543344

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 10-01-2021 16:29:11 to 10-01-2021 16:29:42.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 194 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-01-2021 16:29:43 to 10-01-2021 16:29:45.

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          237045
MON$OLDEST_ACTIVE               237046
MON$OLDEST_SNAPSHOT             237046
MON$NEXT_TRANSACTION            237046
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                       2012480
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

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

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

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