Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.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 17149192 kB
MemAvailable 31379568 kB
Buffers 0 kB
Cached 14567008 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-14 16:27:11
DTS_END                         2021-01-14 16:27:11.0840
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(127:13) ==> X_MAKE_QSTORNO_2100_3300(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49404
TRN_ID                          240166
ATT_ID                          729
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: 9176.19 21039 1101143
customer order: creation 172.26 347 20671
customer order: refuse 14.77 332 1772
order to supplier: creation 45.71 1357 5485
order to supplier: removal 3.37 96806 404
invoice (draft): creation 45.65 3506 5478
invoice (draft): removal 53.17 724 6380
invoice accept: apply 40.85 19299 4902
invoice accept: cancel 47.77 809 5732
customer reserve: creation 3760.83 192 451300
customer reserve: removal 4697.43 54 563692
realization accept: apply 84.30 183 10116
realization accept: cancel 80.13 102 9615
payment from customer: creation 59.90 124 7188
payment from customer: removal 5.82 91 698
payment to supplier: creation 48.60 141 5832
payment to supplier: removal 3.28 86 393
service: total inventory turnovers 4.83 1004 580
service: total monetary turnovers 6.73 31 808
service: aggregate perf. data 0.78 19997 93
service: refresh index statistics 0.03 275591 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-01-2021 16:29:18 to 14-01-2021 16:29:20.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6055
TEST_TIME 2 5944
TEST_TIME 3 5617
TEST_TIME 4 5280
TEST_TIME 5 5249
TEST_TIME 6 5799
TEST_TIME 7 6321
TEST_TIME 8 6555
TEST_TIME 9 6576
TEST_TIME 10 6524
TEST_TIME 11 6820
TEST_TIME 12 6912
TEST_TIME 13 6888
TEST_TIME 14 6905
TEST_TIME 15 6804
TEST_TIME 16 7332
TEST_TIME 17 7309
TEST_TIME 18 8325
TEST_TIME 19 8659
TEST_TIME 20 8553
TEST_TIME 21 9029
TEST_TIME 22 8819
TEST_TIME 23 8744
TEST_TIME 24 9547
TEST_TIME 25 9567
TEST_TIME 26 9938
TEST_TIME 27 10288
TEST_TIME 28 10757
TEST_TIME 29 10651
TEST_TIME 30 10597
TEST_TIME 31 10572
TEST_TIME 32 10664
TEST_TIME 33 10617
TEST_TIME 34 10335
TEST_TIME 35 10103
TEST_TIME 36 9965
TEST_TIME 37 10031
TEST_TIME 38 9863
TEST_TIME 39 9749
TEST_TIME 40 9882
TEST_TIME 41 9881
TEST_TIME 42 9882
TEST_TIME 43 9772
TEST_TIME 44 9685
TEST_TIME 45 9611
TEST_TIME 46 9539
TEST_TIME 47 9576
TEST_TIME 48 9530
TEST_TIME 49 9492
TEST_TIME 50 9380
TEST_TIME 51 9285
TEST_TIME 52 9354
TEST_TIME 53 9296
TEST_TIME 54 9228
TEST_TIME 55 9229
TEST_TIME 56 9372
TEST_TIME 57 9351
TEST_TIME 58 9318
TEST_TIME 59 9341
TEST_TIME 60 9421
TEST_TIME 61 9410
TEST_TIME 62 9516
TEST_TIME 63 9536
TEST_TIME 64 9497
TEST_TIME 65 9585
TEST_TIME 66 9529
TEST_TIME 67 9639
TEST_TIME 68 9576
TEST_TIME 69 9475
TEST_TIME 70 9454
TEST_TIME 71 9374
TEST_TIME 72 9358
TEST_TIME 73 9296
TEST_TIME 74 9224
TEST_TIME 75 9260
TEST_TIME 76 9283
TEST_TIME 77 9196
TEST_TIME 78 9339
TEST_TIME 79 9273
TEST_TIME 80 9339
TEST_TIME 81 9296
TEST_TIME 82 9358
TEST_TIME 83 9357
TEST_TIME 84 9385
TEST_TIME 85 9377
TEST_TIME 86 9376
TEST_TIME 87 9432
TEST_TIME 88 9409
TEST_TIME 89 9469
TEST_TIME 90 9466
TEST_TIME 91 9458
TEST_TIME 92 9432
TEST_TIME 93 9355
TEST_TIME 94 9339
TEST_TIME 95 9300
TEST_TIME 96 9261
TEST_TIME 97 9231
TEST_TIME 98 9203
TEST_TIME 99 9191
TEST_TIME 100 9199
TEST_TIME 101 9238
TEST_TIME 102 9264
TEST_TIME 103 9247
TEST_TIME 104 9246
TEST_TIME 105 9335
TEST_TIME 106 9290
TEST_TIME 107 9354
TEST_TIME 108 9329
TEST_TIME 109 9345
TEST_TIME 110 9387
TEST_TIME 111 9446
TEST_TIME 112 9458
TEST_TIME 113 9443
TEST_TIME 114 9398
TEST_TIME 115 9362
TEST_TIME 116 9325
TEST_TIME 117 9333
TEST_TIME 118 9290
TEST_TIME 119 9244
TEST_TIME 120 9178

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-01-2021 16:29:22 to 14-01-2021 16:29:25.

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 1520480 1520480 0 0.00 0 20914 6 0 0
doc_list_biud 1520479 1520479 0 0.00 0 41135 26 0 0
sp_add_invoice_to_stock 4951 4902 49 0.98 50 196909 19299 0 49
sp_cancel_adding_invoice 5732 5732 0 0.00 6 72936 810 0 0
sp_cancel_client_order 1772 1772 0 0.00 4 8838 332 0 0
sp_cancel_customer_reserve 563692 563692 0 0.00 1 24811 55 0 0
sp_cancel_pay_from_customer 698 698 0 0.00 3 5750 92 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 3 4436 87 0 0
sp_cancel_supplier_invoice 6383 6380 3 0.04 2 15095 725 0 3
sp_cancel_supplier_order 404 404 0 0.00 5 1014453 96807 0 0
sp_cancel_write_off 9615 9615 0 0.00 1 10281 102 0 0
sp_client_order 20671 20671 0 0.00 3 22696 347 0 0
sp_customer_reserve 451300 451300 0 0.00 0 53045 193 0 0
sp_fill_shopping_cart 31628 31628 0 0.00 1 14532 40 0 0
sp_fill_shopping_cart_clo_res 451296 451296 0 0.00 0 20317 14 0 0
sp_get_clo_for_invoice 4898 4898 0 0.00 0 31296 283 0 0
sp_kill_cost_storno 16438 16438 0 0.00 0 7159 53 0 0
sp_kill_qstorno_ret_qs2qd 1143783 1143783 0 0.00 0 22881 30 0 0
sp_kill_qty_storno 602609 602609 0 0.00 0 41135 65 0 0
sp_lock_selected_doc 20779 20779 0 0.00 0 8162 6 0 0
sp_make_cost_storno 28034 28034 0 0.00 0 20903 58 0 0
sp_multiply_rows_for_pdistr 28034 28034 0 0.00 0 7300 31 0 0
sp_multiply_rows_for_qdistr 20671 20671 0 0.00 0 15605 152 0 0
sp_pay_from_customer 7188 7188 0 0.00 4 25026 124 0 0
sp_pay_to_supplier 5832 5832 0 0.00 5 16972 142 0 0
sp_payment_common 13020 13020 0 0.00 2 25017 31 0 0
sp_qd_handle_on_cancel_clo 1772 1772 0 0.00 0 6178 300 0 0
sp_qd_handle_on_invoice_upd_sts 10630 10630 0 0.00 0 41134 334 0 0
sp_qd_handle_on_reserve_upd_sts 10116 10116 0 0.00 0 25395 50 0 0
sp_reserve_write_off 10116 10116 0 0.00 6 25430 184 0 0
sp_supplier_invoice 5478 5478 0 0.00 6 82127 3507 0 0
sp_supplier_order 5485 5485 0 0.00 5 38036 1358 0 0
srv_aggregate_perf_data 93 93 0 0.00 2611 223518 19998 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1050 132293 31976 0 0
srv_find_qd_qs_mism 1054493 1054493 0 0.00 0 14472 5 0 0
srv_make_invnt_saldo 580 580 0 0.00 40 49710 1004 0 0
srv_make_money_saldo 808 808 0 0.00 1 2255 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 114795 454956 275592 0 0
t$perf-abend:sp_add_invoice_to_stock 49 49 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4902 4902 0 0.00 0 10681 153 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 17286 127 0 0
t$perf-norm:sp_cancel_client_order 1772 1772 0 0.00 0 5042 20 0 0
t$perf-norm:sp_cancel_customer_reserve 689 689 0 0.00 0 532 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 698 698 0 0.00 0 2132 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 1743 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 400 400 0 0.00 0 450 11 0 0
t$perf-norm:sp_cancel_supplier_order 404 404 0 0.00 0 21036 1579 0 0
t$perf-norm:sp_cancel_write_off 989 989 0 0.00 0 3374 7 0 0
t$perf-norm:sp_client_order 20671 20671 0 0.00 0 11802 17 0 0
t$perf-norm:sp_customer_reserve 1046 1046 0 0.00 0 7777 21 0 0
t$perf-norm:sp_pay_from_customer 7188 7188 0 0.00 0 7269 8 0 0
t$perf-norm:sp_pay_to_supplier 5832 5832 0 0.00 0 20876 13 0 0
t$perf-norm:sp_reserve_write_off 10116 10116 0 0.00 0 17827 10 0 0
t$perf-norm:sp_supplier_invoice 5478 5478 0 0.00 0 5285 18 0 0
t$perf-norm:sp_supplier_order 5485 5485 0 0.00 0 9510 17 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 431 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 1644 17 0 0
t$perf-norm:srv_make_invnt_saldo 580 580 0 0.00 0 9763 36 0 0
t$perf-norm:srv_make_money_saldo 808 808 0 0.00 0 2777 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 9894 9796 98 0.99 0 6253 18 0 98
v_all_customers 37960 37960 0 0.00 0 16 1 0 0
v_all_suppliers 30322 30322 0 0.00 0 89 1 0 0
v_all_wares 41342 41342 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 1448 9 0 0
v_cancel_client_order 3544 3544 0 0.00 0 1906 3 0 0
v_cancel_customer_prepayment 1396 1396 0 0.00 0 1612 6 0 0
v_cancel_customer_reserve 1378 1378 0 0.00 0 2809 6 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 1770 7 0 0
v_cancel_supplier_invoice 806 800 6 0.74 0 1343 18 0 6
v_cancel_supplier_order 808 808 0 0.00 0 2975 11 0 0
v_cancel_write_off 1978 1978 0 0.00 0 4065 18 0 0
v_max_id_clo_ord 5485 5485 0 0.00 0 433 1 0 0
v_max_id_clo_res 1046 1046 0 0.00 0 3139 18 0 0
v_max_id_ord_sup 5472 5472 0 0.00 0 6887 6 0 0
v_max_non_paid_invoice 1628 1628 0 0.00 0 269 2 0 0
v_max_non_paid_realizn 3817 3817 0 0.00 0 3490 5 0 0
v_min_id_clo_ord 5485 5485 0 0.00 0 5352 12 0 0
v_min_id_clo_res 1046 1046 0 0.00 0 3449 13 0 0
v_min_id_ord_sup 5472 5472 0 0.00 0 4790 12 0 0
v_min_non_paid_invoice 5832 5832 0 0.00 0 7980 18 0 0
v_min_non_paid_realizn 7188 7188 0 0.00 0 5213 21 0 0
v_our_firm 10124 10124 0 0.00 0 16 1 0 0
v_reserve_write_off 20232 20232 0 0.00 0 20848 10 0 0
x_lock_depdocs_on_canc_invoice 11712 11712 0 0.00 0 15735 113 0 0
x_lock_depdocs_on_canc_sup_ord 404 404 0 0.00 0 5717 339 0 0
x_make_qstorno_1000_1200 5485 5485 0 0.00 2 37957 1272 0 0
x_make_qstorno_1200_2000 5478 5478 0 0.00 3 77872 3367 0 0
x_make_qstorno_2100_3300 451300 451300 0 0.00 0 53043 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-01-2021 16:29:26 to 14-01-2021 16:29:30.

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:14 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:21 29147 8192000000 10286209760 10598047744 889310720 9.792 68 52 107 1 908997680 2443328 17243632
13:58:01 15836 8192000000 10353433952 10671616000 1395332608 14.553 100 83 165 0 1426906672 4903952 26670112
13:58:34 35450 8192000000 10395616128 10719186944 1445538064 14.999 100 93 185 2 1483264896 6931888 30794944
13:59:27 19515 8192000000 10414771344 10743615488 1469606800 15.210 100 87 174 0 1505926288 8016464 28303024
13:59:58 18564 8192000000 10434610592 10766807040 1487264496 15.365 100 87 174 0 1524136752 8790576 28081680
14:00:28 15177 8192000000 10455045984 10790428672 1509202528 15.556 100 88 176 1 1546553024 9443072 27907424
14:00:56 15143 8192000000 10472496032 10811305984 1528726960 15.726 100 92 184 0 1567960992 10197984 29036048
14:01:20 14064 8192000000 10493738384 10834120704 1539506928 15.819 100 83 167 0 1575980704 10421328 26052448
14:01:46 17902 8192000000 10520413888 10872012800 1569726400 16.080 100 81 162 0 1605740720 10931296 25083024
14:02:11 8680 8192000000 10537203920 10890395648 1588842784 16.244 100 79 157 0 1623505408 11105664 23556960
14:02:30 10756 8192000000 10554460160 10911051776 1615108656 16.468 100 80 160 1 1650664080 11432208 24123216
14:02:48 9363 8192000000 10588798640 10947416064 1639466096 16.675 100 81 162 0 1675740992 12042960 24231936
14:03:06 9221 8192000000 10600214736 10963943424 1656848208 16.822 100 75 150 1 1691810128 12650896 22311024
14:03:23 9747 8192000000 10617336384 10980782080 1674708848 16.973 100 86 172 0 1713846448 13699024 25438576
14:03:39 7663 8192000000 10634629984 10998968320 1685154544 17.061 100 83 165 1 1723190512 13650112 24385856
14:03:54 9966 8192000000 10641043616 11010646016 1699857504 17.184 100 82 163 0 1736868400 13708656 23302240
14:04:12 8428 8192000000 10662502400 11033018368 1714897584 17.310 100 81 162 0 1751692272 13695344 23099344
14:04:30 6689 8192000000 10659939840 11040317440 1727465072 17.414 100 75 150 1 1762865648 14355552 21045024
14:04:46 4044 8192000000 10684504432 11057446912 1741095136 17.528 100 81 162 1 1777048912 12826224 23127552
14:04:57 5671 8192000000 10675009808 11061555200 1749076928 17.594 100 71 141 0 1779616400 11104496 19434976
14:05:10 6005 8192000000 10697795776 11079671808 1763162720 17.711 100 67 134 0 1792616048 10459520 18993808
14:05:24 4166 8192000000 10718416256 11099807744 1779911648 17.849 100 84 162 0 1814959664 11897360 23150656
14:05:35 3118 8192000000 10717523728 11102523392 1786909296 17.906 100 87 174 0 1824778272 13126208 24742768
14:05:44 2973 8192000000 10726493200 11107737600 1786174656 17.900 100 82 164 2 1821654064 12048080 23431328
14:05:55 8162 8192000000 10720051968 11111628800 1789535232 17.928 100 67 134 1 1820438656 12383632 18519792
14:06:13 2611 8192000000 10752127136 11137929216 1815994512 18.145 100 86 172 3 1851918880 11489008 24435360
14:06:22 3112 8192000000 10750193072 11139608576 1815172800 18.138 100 72 144 1 1847259552 11990240 20096512
14:06:32 3109 8192000000 10760673568 11145658368 1818882512 18.169 100 79 158 1 1853735616 12297488 22555616
14:06:42 2250 8192000000 10769116656 11154165760 1826229408 18.229 100 79 157 0 1860508096 12378128 21900560
14:06:51 2120 8192000000 10766523936 11152842752 1828427904 18.247 100 81 161 0 1865036880 13651552 22957424
14:07:00 4077 8192000000 10770699040 11157827584 1831454432 18.271 100 87 174 0 1870448336 14312176 24681728
14:07:10 3183 8192000000 10781145184 11169497088 1835329728 18.303 100 87 172 2 1874753040 14656048 24767264
14:07:20 1947 8192000000 10788449088 11172765696 1843389344 18.368 100 91 181 0 1881642944 12662048 25591552
14:07:29 2105 8192000000 10792970400 11177447424 1847560128 18.402 100 94 187 6 1887922288 14403568 25958592
14:07:38 2376 8192000000 10790994336 11177508864 1848940800 18.414 100 94 188 2 1890309104 15176864 26191440
14:07:47 2020 8192000000 10789632080 11180445696 1856546880 18.475 100 87 175 0 1895199744 14449728 24203136
14:07:56 1262 8192000000 10800809376 11189940224 1857549008 18.483 100 91 181 0 1897833808 14522288 25762512
14:08:04 1209 8192000000 10799453712 11190452224 1860033648 18.504 100 91 183 1 1899382352 13510000 25838704
14:08:12 4060 8192000000 10807612960 11196403712 1867446736 18.564 100 95 190 0 1907970928 13726288 26797904
14:08:22 1457 8192000000 10811371936 11198578688 1862973792 18.527 100 90 180 1 1901276000 13160992 25141216
14:08:30 1879 8192000000 10803001952 11196510208 1865026720 18.544 100 91 182 1 1905249552 14173728 26049104
14:08:39 23327 8192000000 10798711792 11198615552 1864264416 18.538 100 71 145 0 1896154304 11985840 19904048
14:09:08 7222 8192000000 10772251696 11196915712 1865168544 18.545 100 58 116 1 1892582448 11298880 16115024
14:09:23 6087 8192000000 10771352656 11196387328 1864614768 18.541 100 41 82 0 1884182352 7595280 11972304
14:09:38 5638 8192000000 10781941872 11202826240 1869134000 18.577 100 41 82 1 1888167584 7649680 11383904
14:09:53 3632 8192000000 10790922720 11207753728 1873108528 18.609 100 47 94 1 1894671168 8554800 13007840
14:10:03 10092 8192000000 10774333456 11204632576 1871341840 18.595 100 28 56 1 1886051408 6954864 7754704
14:10:19 7046 8192000000 10780107776 11206737920 1875204608 18.626 100 24 48 0 1888673344 6010400 7458336
14:10:33 10907 8192000000 10773629792 11209248768 1873368800 18.612 100 24 48 2 1886843216 6624528 6849888
14:10:52 7796 8192000000 10797234112 11215224832 1881117600 18.674 100 23 46 0 1893631520 6512352 6001568
14:11:07 9877 8192000000 10802385984 11224137728 1885197952 18.707 100 41 83 2 1904235104 8100320 10936832
14:11:24 8927 8192000000 10791830544 11221565440 1886644080 18.719 100 27 54 1 1900958288 6696832 7617376
14:11:41 10499 8192000000 10798007280 11223392256 1885440800 18.709 100 12 24 1 1894054736 5097712 3516224
14:12:02 14113 8192000000 10801127296 11237683200 1893141904 18.771 100 28 56 3 1912477920 11309008 8027008
14:12:42 31664 8192000000 10840633168 11246170112 1900022784 18.826 100 63 124 0 1925556992 5988128 19546080
14:13:20 1750 8192000000 10833254736 11246518272 1884141504 18.699 99 75 150 1 1920564992 15079104 21344384
14:13:30 4968 8192000000 10802094464 11236380672 1892901248 18.769 100 40 76 4 1912069344 8047392 11120704
14:13:43 3919 8192000000 10829184400 11246387200 1900246816 18.828 100 42 87 2 1918241792 6538224 11456752
14:13:54 4621 8192000000 10827483536 11251380224 1900905952 18.834 100 42 84 0 1921384864 8861360 11617552
14:14:06 3435 8192000000 10814572864 11245912064 1899837072 18.825 100 30 60 2 1914948784 6536560 8575152
14:14:19 7418 8192000000 10816682624 11248156672 1902325184 18.845 100 32 64 1 1918654144 6917696 9411264
14:14:36 4475 8192000000 10810448768 11248500736 1903552512 18.855 100 28 56 0 1917332016 5963456 7816048
14:14:49 11994 8192000000 10814663504 11254743040 1905734752 18.872 100 30 60 0 1920779744 5356464 9688528
14:15:08 48958 8192000000 10826259552 11258458112 1910119584 18.908 100 31 61 4 1925581392 6220368 9241440
14:16:03 8514 8192000000 10812213296 11239542784 1889203248 18.739 99 25 50 2 1902950176 6681968 7064960
14:16:21 6162 8192000000 10814903088 11246354432 1898150128 18.811 100 22 44 1 1909723616 5359728 6213760
14:16:37 5453 8192000000 10821156304 11252731904 1905693312 18.872 100 25 50 1 1919649072 6687600 7268160
14:16:49 7803 8192000000 10813515040 11248226304 1902051024 18.843 100 28 55 2 1914882400 5230112 7601264
14:17:04 5372 8192000000 10814608032 11249152000 1891142544 18.755 99 23 46 0 1904327456 6443728 6741184
14:17:18 5322 8192000000 10802347344 11230572544 1871846848 18.599 98 23 44 2 1884233408 5786928 6599632
14:17:30 8011 8192000000 10779141216 11211132928 1831208192 18.269 97 15 30 2 1840403888 5053568 4142128
14:17:44 11979 8192000000 10746647904 11172081664 1739544960 17.515 93 19 37 1 1750373952 4929712 5899280
14:18:02 9425 8192000000 10766517344 11194220544 1838538912 18.329 99 31 62 1 1854590368 7551792 8499664
14:18:18 7508 8192000000 10731918592 11148435456 1773799120 17.798 97 21 39 0 1784461952 4881888 5780944
14:18:34 7809 8192000000 10731814912 11150692352 1769687648 17.764 97 16 32 1 1779248960 5054112 4507200
14:18:48 9358 8192000000 10725264336 11145838592 1735447296 17.481 95 18 36 1 1750059424 9646480 4965648
14:19:05 56402 8192000000 10749213504 11131985920 1758855536 17.675 96 52 105 1 1780883136 5283760 16743840
14:20:08 12103 8192000000 10734074704 11154853888 1774634512 17.805 97 25 50 0 1788701904 6913968 7153424
14:20:27 8133 8192000000 10742708528 11159773184 1794388192 17.968 98 24 49 1 1807259920 5526992 7344736
14:20:45 6446 8192000000 10722871712 11142524928 1783822416 17.881 97 29 58 3 1798536992 6315792 8398784
14:20:58 5268 8192000000 10736553568 11149242368 1774975056 17.808 97 35 68 3 1791400912 6166480 10259376
14:21:10 4448 8192000000 10735157568 11153563648 1819020240 18.170 100 27 53 2 1832048016 6178464 6849312
14:21:22 4892 8192000000 10724612624 11138969600 1746448288 17.572 96 22 44 0 1758607760 5614448 6545024
14:21:34 9947 8192000000 10706328560 11125547008 1742742352 17.541 96 23 46 1 1755029952 4798656 7488944
14:21:50 7524 8192000000 10722092272 11145519104 1796316240 17.984 99 20 40 1 1808061344 5697312 6047792
14:22:04 8349 8192000000 10716667808 11131047936 1774829808 17.807 98 32 64 1 1789400480 5681824 8888848
14:22:19 3380 8192000000 10726960032 11146543104 1813091904 18.121 100 30 60 0 1828821248 6956496 8772848
14:22:32 9638 8192000000 10720120464 11135188992 1787448352 17.911 98 29 58 1 1802411376 5751632 9211392
14:22:49 6764 8192000000 10719888704 11142885376 1784086064 17.883 98 18 36 0 1794303200 5008192 5208944
14:23:05 9650 8192000000 10741697760 11155386368 1819466768 18.173 100 22 44 3 1831532544 5305056 6760720
14:23:21 15328 8192000000 10759026704 11174137856 1839177216 18.334 100 18 36 1 1854644320 9905568 5561536
14:23:43 55905 8192000000 10784775072 11191984128 1852928912 18.446 100 33 66 1 1869138576 6008240 10201424
14:24:45 9438 8192000000 10768556912 11194798080 1848068656 18.406 100 15 28 0 1861972240 10406688 3496896
14:25:01 10152 8192000000 10770130704 11195965440 1855496832 18.467 100 13 26 0 1864221936 5034448 3690656
14:25:20 8240 8192000000 10768539536 11203825664 1863910288 18.535 100 31 62 1 1879123712 6650576 8562848
14:25:35 5616 8192000000 10783745776 11208175616 1867949568 18.568 100 33 64 3 1883044560 6151968 8943024
14:25:49 11014 8192000000 10773201568 11206074368 1849687936 18.420 99 20 40 1 1861442944 6115248 5639760
14:26:09 6856 8192000000 10790097792 11219701760 1875986688 18.633 100 24 46 1 1887699888 5605120 6108080
14:26:22 7358 8192000000 10797363504 11221757952 1880041024 18.665 100 30 59 2 1893881264 4951232 8889008
14:26:38 11030 8192000000 10786720800 11222126592 1879714560 18.663 100 19 38 2 1891006176 5488304 5803312
14:27:02 18089 8192000000 10802879520 11233148928 1888275184 18.732 100 18 36 1 1898148368 4807456 5065728
14:27:35 16689 8192000000 10839800320 11257397248 1905764512 18.873 100 38 76 0 1922764800 5709776 11290512
14:28:02 3481 8192000000 10845689664 11265122304 1918096400 18.972 100 47 94 0 1938829072 7503504 13229168
14:28:12 9917 8192000000 10855951472 11276578816 1925173088 19.028 100 42 84 2 1945614992 8105088 12336816
14:28:29 5512 8192000000 10866797856 11278798848 1929391056 19.062 100 54 107 2 1954194240 9047744 15755440
14:28:45 12930 8192000000 10874887248 11291447296 1936989632 19.123 100 60 120 0 1965123856 11803712 16330512
14:29:09 24040 8192000000 10873155808 11292864512 1943112880 19.172 100 59 118 1 1970761760 10774784 16874096
14:29:45 39169 8192000000 10872535344 11306242048 1948528176 19.215 100 51 102 0 1974040256 10951008 14561072
14:30:31 87653 8192000000 10884976832 11318337536 1950735472 19.232 100 34 68 4 1973554848 11642832 11176544
14:32:05 19665 8192000000 10895145232 11329708032 1964663520 19.343 100 46 92 0 1990963392 12965616 13334256
14:32:35 11806 8192000000 10906059552 11337408512 1966116256 19.355 100 45 90 1 1995202592 16331312 12755024
14:32:59 9208 8192000000 10891888160 11335294976 1968339360 19.372 100 44 88 0 1999162240 17814192 13008688
14:33:15 31372 8192000000 10906866736 11344719872 1968965408 19.377 100 35 70 0 1997148240 17661328 10521504
14:34:04 8105 8192000000 10917831424 11348422656 1976778672 19.439 100 50 100 4 2008962384 17747936 14435776
14:34:21 2880 8192000000 10927579568 11351867392 1963930208 19.337 99 56 112 0 1999942272 19407280 16604784
14:34:37 20247 8192000000 10926178048 11360600064 1978693760 19.454 100 57 113 0 2013712048 19269392 15748896
14:35:05 3042 8192000000 10930595360 11355774976 1980600560 19.469 100 58 116 3 2016384720 19161200 16622960
14:35:15 3232 8192000000 10947166576 11363540992 1987841040 19.527 100 73 141 2 2026138000 18210176 20086784
14:35:26 3480 8192000000 10937707552 11364356096 1990211280 19.545 100 69 137 1 2029715936 19288544 20216112
14:35:38 9385 8192000000 10929962432 11361234944 1971273296 19.396 99 56 111 0 2006535008 19264608 15997104
14:35:58 4949 8192000000 10932825728 11365412864 1985878800 19.511 100 48 96 0 2017539488 17737568 13923120
14:36:10 23001 8192000000 10925295216 11360792576 1978932880 19.456 100 48 96 0 2012285360 18458320 14894160
14:36:41 20816 8192000000 10930916912 11377414144 1969751696 19.383 99 39 78 1 2002779168 21359712 11667760
14:37:10 3208 8192000000 10933148272 11367518208 1987771392 19.526 99 59 117 1 2024546656 19166848 17608416
14:37:23 2030 8192000000 10951788896 11386028032 2004048496 19.655 100 66 130 1 2042556864 19094336 19414032
14:37:37 8954 8192000000 10958193456 11387768832 1992457808 19.563 99 66 128 0 2035176176 24316848 18401520
14:37:53 3540 8192000000 10959340816 11389276160 1999720912 19.621 100 63 126 0 2044041184 24772608 19547664
14:38:04 2758 8192000000 10959587696 11379032064 1999043792 19.615 100 85 170 2 2047414080 23488176 24882112
14:38:13 4004 8192000000 10950848448 11378946048 1995753952 19.589 100 67 134 0 2041206368 24914416 20538000
14:38:24 4892 8192000000 10949548640 11374088192 1995991840 19.591 100 73 146 0 2044046912 26053856 22001216
14:38:35 5504 8192000000 10950850256 11377459200 1979165664 19.458 99 68 135 0 2025661072 26563072 19932336
14:38:52 3575 8192000000 10934378048 11362156544 1953732384 19.256 98 69 140 2 2001121456 26485808 20903264
14:39:04 5735 8192000000 10936355104 11365822464 1977525600 19.445 100 60 119 0 2022490224 26133792 18830832
14:39:17 8255 8192000000 10930427344 11355590656 1968871984 19.376 100 69 138 0 2017205520 26979744 21353792
14:39:34 4605 8192000000 10929671440 11354689536 1973201728 19.411 100 60 120 0 2016569424 25291856 18075840
14:39:46 6660 8192000000 10932604096 11350200320 1971267728 19.396 100 75 150 1 2020770688 25971152 23531808
14:40:02 3968 8192000000 10954873280 11373629440 1984513136 19.500 100 67 134 0 2031593136 26861408 20218592
14:40:16 10393 8192000000 10951659120 11379937280 1994307760 19.578 100 63 126 2 2042034784 28833712 18893312
14:40:33 16652 8192000000 10951846288 11377856512 1973771232 19.415 99 67 133 3 2020625776 27135984 19718560
14:41:05 4033 8192000000 10960054640 11387281408 2000344704 19.625 100 72 139 0 2051016496 29745744 20926048
14:41:17 8216 8192000000 10969344000 11388256256 1999546592 19.619 100 69 138 0 2051405856 30985392 20873872
14:41:35 4278 8192000000 10962943728 11388649472 1993440704 19.571 100 62 124 1 2045857728 33572192 18844832
14:41:46 3292 8192000000 10923635552 11348508672 1955606432 19.271 98 61 122 1 2007141968 32801872 18733664
14:41:56 3542 8192000000 10957895872 11377213440 1984194544 19.498 100 79 158 0 2040910720 32501808 24214368
14:42:07 3461 8192000000 10954786624 11368316928 1964970688 19.346 99 85 169 1 2025065568 34409952 25684928
14:42:17 2153 8192000000 10950981824 11363254272 1974214928 19.419 100 84 168 0 2036660256 36831104 25614224
14:42:28 5484 8192000000 10943572528 11357786112 1964825504 19.344 100 82 163 3 2027098656 37954976 24318176
14:42:56 2978 8192000000 10920292560 11332972544 1938752032 19.137 99 75 149 1 2004012288 42181520 23078736
14:43:07 2840 8192000000 10911531104 11319603200 1927085136 19.044 99 78 154 0 1993614048 42447952 24080960
14:43:17 1046 8192000000 10941887616 11353583616 1958990160 19.298 100 88 176 1 2028755920 42609712 27156048
14:43:24 6782 8192000000 10933167712 11337121792 1931692032 19.080 99 80 159 1 2000858240 43720576 25445632
14:43:39 1965 8192000000 10951911616 11361521664 1963753488 19.336 100 94 187 1 2037660256 44228496 29678272
14:43:49 4369 8192000000 10929567824 11349110784 1938109136 19.132 99 64 128 2 1999772272 41202016 20461120
14:44:01 2301 8192000000 10958125696 11370590208 1974779232 19.423 100 85 170 2 2043313440 41845008 26689200
14:44:11 4351 8192000000 10943323968 11363684352 1959886000 19.305 100 68 136 2 2025637824 44141568 21610256
14:44:34 5272 8192000000 10941018464 11363954688 1959983952 19.306 100 71 141 1 2029952512 46920256 23048304
14:44:48 5784 8192000000 10952760832 11370348544 1948737632 19.216 99 72 144 1 2022436048 50512064 23186352
14:45:03 2498 8192000000 10944745184 11362484224 1948903760 19.218 99 74 146 6 2026048272 53267920 23876592
14:45:13 3309 8192000000 10962862496 11381555200 1965223296 19.348 100 76 153 2 2045775856 55694864 24857696
14:45:23 1556 8192000000 10974474208 11382882304 1976093984 19.434 100 93 187 2 2061368064 56471744 28802336
14:45:33 1839 8192000000 10937275936 11350077440 1926651232 19.040 98 88 170 0 2004458672 50824352 26983088
14:45:43 7236 8192000000 10936972192 11363987456 1954802240 19.265 100 63 125 1 2019364432 45433904 19128288
14:46:00 6915 8192000000 10907469360 11347472384 1938462576 19.134 99 39 78 0 1994713360 43809824 12440960
14:46:30 11934 8192000000 10904072784 11344875520 1932131104 19.084 99 32 64 2 1978548512 36572368 9845040
14:46:50 6707 8192000000 10905484752 11337965568 1941262800 19.157 100 39 76 2 1992265216 38235744 12766672
14:47:04 6886 8192000000 10910253920 11338031104 1928028256 19.051 99 45 92 2 1981127440 38542880 14556304
14:47:19 1552 8192000000 10930924080 11341443072 1944409440 19.182 99 85 171 1 2010676208 40112848 26153920
14:47:29 6767 8192000000 10928160176 11338825728 1935250128 19.109 99 79 158 0 2001224896 41828064 24146704
14:47:42 2869 8192000000 10949041104 11363328000 1958483776 19.294 100 77 155 2 2027714448 45267856 23962816
14:47:53 5506 8192000000 10949703184 11370487808 1963029664 19.330 100 65 132 2 2029269824 46011008 20229152
14:48:07 11234 8192000000 10927719344 11376189440 1959403168 19.301 100 28 56 1 2015586064 46738992 9443904
14:48:29 10212 8192000000 10920078736 11345412096 1904383632 18.862 97 33 66 1 1958400544 42663536 11353376
14:48:51 10838 8192000000 10920337808 11350028288 1944513056 19.183 100 36 68 2 1993494624 37359072 11622496
14:49:31 14692 8192000000 10902943392 11341017088 1922779520 19.009 99 33 66 2 1975842944 41372528 11690896
14:49:54 10893 8192000000 10912118224 11347374080 1938397520 19.134 100 37 75 4 1999157920 48409136 12351264
14:50:11 15543 8192000000 10912522032 11345252352 1938463008 19.134 100 41 82 2 1997355952 44965808 13927136
14:50:34 3155 8192000000 10924292928 11336536064 1932058176 19.083 99 70 138 3 2001259056 46295616 22905264
14:50:46 2759 8192000000 10944533472 11367129088 1958108080 19.291 100 70 141 0 2029984880 49080064 22796736
14:50:58 4310 8192000000 10943085840 11375955968 1960352800 19.309 100 55 110 1 2028265216 49698784 18213632
14:51:09 8171 8192000000 10940663216 11376103424 1959604864 19.303 100 48 96 4 2023289920 48296944 15388112
14:51:28 8287 8192000000 10901655648 11351257088 1917644448 18.968 98 32 64 1 1966826448 38561632 10620368
14:51:51 11413 8192000000 10895757312 11348414464 1922291744 19.005 99 26 52 2 1966120320 35158368 8670208
14:52:13 17921 8192000000 10883612800 11338682368 1916914896 18.962 99 20 40 0 1960086752 36403424 6768432
14:52:41 27766 8192000000 10887742704 11340988416 1929076720 19.059 100 19 38 0 1974251472 38562016 6612736
14:53:16 19559 8192000000 10860285504 11331543040 1903128672 18.851 99 14 28 0 1949187296 41014064 5044560
14:54:18 29018 8192000000 10877067920 11338665984 1909179744 18.900 99 8 16 1 1946623824 34647136 2796944
14:55:03 33421 8192000000 10860744368 11316318208 1915595984 18.952 99 8 16 1 1934867280 16937136 2334160
14:55:49 82106 8192000000 10856123472 11311407104 1896881184 18.801 98 9 18 0 1910049280 10276576 2891520
14:57:18 98759 8192000000 10884724768 11329265664 1890070128 18.746 97 16 32 1 1905197424 10889296 4238000
14:59:05 73042 8192000000 10874259904 11323961344 1897691840 18.808 97 19 37 2 1916746944 13364720 5690384
15:00:29 118942 8192000000 10905471904 11343642624 1938364400 19.134 99 32 64 5 1958312320 11323488 8624432
15:03:07 74569 8192000000 10897430672 11351052288 1946985600 19.202 99 36 74 1 1965431712 8654256 9791856
15:04:29 94754 8192000000 10902909840 11367424000 1940518928 19.151 98 24 48 2 1960640128 13485056 6636144
15:06:12 58807 8192000000 10886609648 11355799552 1947236256 19.204 99 17 34 0 1971357824 18224752 5896816
15:07:18 44534 8192000000 10883478320 11352616960 1941533328 19.159 99 16 32 2 1958569680 11924736 5111616
15:08:08 36502 8192000000 10894045808 11362177024 1962395040 19.325 100 23 46 1 1982481024 13045328 7040656
15:09:01 74359 8192000000 10888923856 11352756224 1930570576 19.071 98 22 43 0 1949336992 13389296 5377120
15:10:31 25669 8192000000 10908842720 11371388928 1984541648 19.501 100 40 75 4 2004727968 9695184 10491136
15:11:10 38319 8192000000 10924426352 11386806272 1988585456 19.533 100 19 38 0 2006843360 12067056 6190848
15:12:43 40915 8192000000 10913095488 11381465088 1968806704 19.376 99 15 30 0 1983188176 9927344 4454128
15:13:38 53491 8192000000 10900493792 11384508416 1970781344 19.392 99 23 46 2 1991215184 13338912 7094928
15:14:49 41360 8192000000 10913081648 11375517696 1970644352 19.391 99 28 56 1 1988753664 10160320 7948992
15:15:38 44625 8192000000 10901486112 11367522304 1973472864 19.413 100 9 18 1 1984439456 8429712 2536880
15:16:39 30580 8192000000 10920354512 11384602624 1985748272 19.510 100 22 44 0 2001112560 9268032 6096256
15:17:21 94201 8192000000 10911045984 11389820928 1996077984 19.592 100 23 46 2 2014595856 11549504 6968368
15:19:17 56386 8192000000 10892162304 11386470400 1967919488 19.369 99 8 16 0 1985281600 15144000 2218112
15:20:20 29624 8192000000 10888160448 11357159424 1913259216 18.933 97 5 10 0 1924845920 10438288 1148416
15:21:04 41287 8192000000 10909920304 11369762816 1947277840 19.205 99 24 48 2 1966198048 11891136 7029072
15:21:55 88404 8192000000 10883378704 11365617664 1932963168 19.091 98 18 36 1 1958664352 20483456 5217728
15:23:29 44217 8192000000 10898683472 11365011456 1936025744 19.115 98 20 38 1 1949758384 8180960 5551680
15:24:23 44734 8192000000 10898486064 11358265344 1914999536 18.947 97 25 50 1 1931001856 8959264 7043056
15:25:17 14294 8192000000 10893399408 11332767744 1900548080 18.831 97 44 88 0 1922368960 9378160 12442720
15:25:41 36474 8192000000 10871207968 11335946240 1908058608 18.891 98 44 88 0 1934028640 14176176 11793856
15:26:28 55126 8192000000 10833046976 11292188672 1794373312 17.968 93 17 34 1 1813660672 14415792 4871568
15:27:31 73662 8192000000 10897051728 11360759808 1935259008 19.109 99 28 56 1 1957427904 14619600 7549296
15:28:53 60483 8192000000 10897535408 11375390720 1962509824 19.326 100 21 42 2 1989478816 20975632 5993360
15:30:10 43860 8192000000 10838461216 11286470656 1803696672 18.044 93 20 40 2 1821609024 11379024 6533328
15:31:01 39072 8192000000 10861724768 11320385536 1908930032 18.898 99 22 44 1 1932039360 17253472 5855856
15:33:04 49314 8192000000 10856443680 11306704896 1856177824 18.472 96 21 42 0 1871530656 9748320 5604512
15:34:01 25261 8192000000 10861353168 11317186560 1918093552 18.972 100 32 64 2 1939906368 12645712 9167104
15:34:37 46040 8192000000 10836342000 11286966272 1807154128 18.073 94 29 58 0 1825025376 9393376 8477872
15:35:32 92069 8192000000 10855350800 11305574400 1915945760 18.954 100 36 72 0 1936325840 10268032 10112048
15:37:30 85212 8192000000 10872767552 11330658304 1921950672 19.002 99 18 36 0 1938335632 11129648 5255312
15:39:01 37742 8192000000 10906431232 11360731136 1966151280 19.355 100 45 90 1 1991056016 12141680 12763056
15:40:44 58348 8192000000 10891207680 11356827648 1943834784 19.177 99 11 22 1 1964187424 16825168 3527472
15:41:52 55130 8192000000 10882102560 11355074560 1927989072 19.051 98 22 44 1 1953967248 18966960 7011216
15:43:02 34431 8192000000 10890779440 11363274752 1956137696 19.275 100 13 26 0 1979283312 19298976 3846640
15:43:56 37349 8192000000 10901802128 11364552704 1948768352 19.217 99 23 46 1 1969982080 14777408 6436320
15:44:40 91386 8192000000 10899556752 11398418432 1972193856 19.403 100 10 20 1 1997086176 21639584 3252736
15:46:17 36795 8192000000 10893610496 11355291648 1933641264 19.096 98 20 40 0 1949042352 9954704 5446384
15:47:06 51071 8192000000 10892123376 11359363072 1921196048 18.996 98 23 46 1 1941258320 13375056 6687216
15:48:09 74975 8192000000 10886474928 11362742272 1949602576 19.223 99 24 48 1 1968852816 11892944 7357296
15:49:32 56550 8192000000 10876823824 11351908352 1917876592 18.970 98 11 22 0 1934104080 13048112 3179376
15:50:50 82748 8192000000 10848423680 11287183360 1827376080 18.238 94 15 31 0 1846392512 14857616 4158816
15:52:19 50001 8192000000 10866275856 11323158528 1917889904 18.970 99 37 74 3 1940436368 11859008 10687456
15:53:20 60748 8192000000 10861900416 11341844480 1905174432 18.868 98 23 46 0 1924455056 12679616 6601008
15:54:30 78210 8192000000 10877953312 11344523264 1912544912 18.927 98 9 18 0 1923833360 8456672 2831776
15:55:55 23930 8192000000 10905308512 11356065792 1955093632 19.267 100 31 63 0 1974985648 10594368 9297648
15:56:29 124685 8192000000 10916076032 11380092928 1953055888 19.251 99 12 24 1 1976801904 20332832 3413184
15:58:43 60095 8192000000 10901104656 11373637632 1974017824 19.417 100 15 30 1 1988058752 10154032 3886896
16:00:11 90511 8192000000 10903030032 11371012096 1944733632 19.185 98 32 64 0 1961665424 7726768 9205024
16:01:48 46981 8192000000 10910946944 11386560512 1979804256 19.463 100 14 28 0 1994270816 9545776 4920784
16:02:47 91812 8192000000 10903156272 11380727808 1955740768 19.272 98 11 22 0 1977488560 18403312 3344480
16:04:25 24011 8192000000 10917916816 11400785920 1988936656 19.535 100 10 20 0 2011234848 19267344 3030848
16:04:55 40687 8192000000 10932376432 11407732736 1991853808 19.558 100 18 35 0 2016258864 19594624 4810432
16:05:51 51785 8192000000 10928072400 11409596416 1995368064 19.586 100 15 30 0 2021070992 20927184 4775744
16:07:05 73419 8192000000 10916868576 11408375808 1978463152 19.453 99 13 26 1 2002953760 20231584 4259024
16:08:25 47387 8192000000 10923553472 11392729088 1975475504 19.429 99 25 50 1 1993927184 11211296 7240384
16:09:21 22982 8192000000 10934674912 11389018112 1978216368 19.451 99 33 64 0 1997947744 11064880 8666496
16:09:55 18051 8192000000 10924218016 11370889216 1954308576 19.261 98 51 102 3 1980081184 10694160 15078448
16:10:22 40501 8192000000 10917440688 11387957248 1970962688 19.393 99 25 50 0 1990954208 12841232 7150288
16:11:08 86646 8192000000 10890623008 11367206912 1901318048 18.837 96 9 18 0 1925036416 20939648 2778720
16:12:44 46841 8192000000 10910319216 11359227904 1913456384 18.934 97 20 40 0 1926173760 7041568 5675808
16:13:39 46597 8192000000 10897096368 11372597248 1933410368 19.094 98 36 71 1 1955749568 12614896 9724304
16:14:35 124641 8192000000 10905780112 11373563904 1891992368 18.762 96 19 38 1 1916788560 19831072 4965120
16:19:06 132293 8192000000 10879693984 11364397056 1865753552 18.550 95 10 20 0 1885467600 16740976 2973072
16:22:13 68485 8192000000 10838817184 11285606400 1745618448 17.565 89 32 63 3 1762426688 8141904 8666336
16:23:40 36389 8192000000 10857188768 11318837248 1918801264 18.977 100 27 54 1 1936703968 10250336 7652368
16:24:49 47493 8192000000 10837623136 11313184768 1895442176 18.790 98 9 18 1 1908533392 10428432 2662784
16:25:45 51510 8192000000 10823379792 11295240192 1854405184 18.458 96 10 20 0 1867891248 10419472 3066592
16:26:47 33307 8192000000 9671970160 10008686592 811909552 9.017 42 6 12 0 821912656 8564912 1438192

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 14-01-2021 16:29:32 to 14-01-2021 16:30:04.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 49 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-01-2021 16:30:05 to 14-01-2021 16:30:07.

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          240533
MON$OLDEST_ACTIVE               240534
MON$OLDEST_SNAPSHOT             240534
MON$NEXT_TRANSACTION            240534
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                       2042976
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 ---
:906: 
:907: mscs-test-161.budzdorov.ru    Thu Jan 14 16:27:45 2021
:908:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:909: 
--- end of diff output ---

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

14.01.21 16:30:08. 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-14 16:30:10 No severe PSQL-related problems occured
14.01.21 16:30:11. End of report.