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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17235796 kB
MemAvailable 31508344 kB
Buffers 0 kB
Cached 14403688 kB
SwapCached 0 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-03-20 16:27:26
DTS_END                         2021-03-20 16:27:26.5100
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(141:26) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55042
TRN_ID                          238372
ATT_ID                          721
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: 9360.76 22756 1123291
customer order: creation 166.53 373 19983
customer order: refuse 14.18 389 1702
order to supplier: creation 45.08 1299 5409
order to supplier: removal 3.49 97045 419
invoice (draft): creation 44.37 3377 5324
invoice (draft): removal 56.28 730 6753
invoice accept: apply 40.06 18560 4807
invoice accept: cancel 50.23 837 6027
customer reserve: creation 3691.78 184 443013
customer reserve: removal 4953.25 53 594390
realization accept: apply 80.17 199 9620
realization accept: cancel 90.83 112 10900
payment from customer: creation 56.19 120 6743
payment from customer: removal 5.61 67 673
payment to supplier: creation 47.88 150 5746
payment to supplier: removal 3.31 119 397
service: total inventory turnovers 4.64 1287 557
service: total monetary turnovers 5.93 40 712
service: aggregate perf. data 0.93 15471 112
service: refresh index statistics 0.03 314700 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-03-2021 16:28:17 to 20-03-2021 16:28:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3130
TEST_TIME 2 3515
TEST_TIME 3 3406
TEST_TIME 4 3380
TEST_TIME 5 3513
TEST_TIME 6 3745
TEST_TIME 7 3734
TEST_TIME 8 4868
TEST_TIME 9 4998
TEST_TIME 10 5222
TEST_TIME 11 5542
TEST_TIME 12 5691
TEST_TIME 13 5611
TEST_TIME 14 5589
TEST_TIME 15 6159
TEST_TIME 16 6202
TEST_TIME 17 6589
TEST_TIME 18 6578
TEST_TIME 19 7234
TEST_TIME 20 7471
TEST_TIME 21 7726
TEST_TIME 22 8198
TEST_TIME 23 8756
TEST_TIME 24 8640
TEST_TIME 25 9006
TEST_TIME 26 9586
TEST_TIME 27 10205
TEST_TIME 28 10054
TEST_TIME 29 9857
TEST_TIME 30 10187
TEST_TIME 31 10171
TEST_TIME 32 10039
TEST_TIME 33 10130
TEST_TIME 34 10084
TEST_TIME 35 10142
TEST_TIME 36 10108
TEST_TIME 37 10089
TEST_TIME 38 10144
TEST_TIME 39 9945
TEST_TIME 40 9792
TEST_TIME 41 9920
TEST_TIME 42 9789
TEST_TIME 43 10052
TEST_TIME 44 9878
TEST_TIME 45 9791
TEST_TIME 46 9692
TEST_TIME 47 9584
TEST_TIME 48 9670
TEST_TIME 49 9786
TEST_TIME 50 9689
TEST_TIME 51 9607
TEST_TIME 52 9637
TEST_TIME 53 9594
TEST_TIME 54 9472
TEST_TIME 55 9457
TEST_TIME 56 9467
TEST_TIME 57 9360
TEST_TIME 58 9424
TEST_TIME 59 9322
TEST_TIME 60 9328
TEST_TIME 61 9342
TEST_TIME 62 9388
TEST_TIME 63 9355
TEST_TIME 64 9440
TEST_TIME 65 9402
TEST_TIME 66 9467
TEST_TIME 67 9522
TEST_TIME 68 9499
TEST_TIME 69 9441
TEST_TIME 70 9468
TEST_TIME 71 9561
TEST_TIME 72 9577
TEST_TIME 73 9537
TEST_TIME 74 9554
TEST_TIME 75 9530
TEST_TIME 76 9415
TEST_TIME 77 9454
TEST_TIME 78 9468
TEST_TIME 79 9402
TEST_TIME 80 9423
TEST_TIME 81 9356
TEST_TIME 82 9317
TEST_TIME 83 9300
TEST_TIME 84 9362
TEST_TIME 85 9355
TEST_TIME 86 9329
TEST_TIME 87 9306
TEST_TIME 88 9298
TEST_TIME 89 9389
TEST_TIME 90 9466
TEST_TIME 91 9450
TEST_TIME 92 9450
TEST_TIME 93 9547
TEST_TIME 94 9509
TEST_TIME 95 9544
TEST_TIME 96 9568
TEST_TIME 97 9663
TEST_TIME 98 9648
TEST_TIME 99 9689
TEST_TIME 100 9603
TEST_TIME 101 9575
TEST_TIME 102 9546
TEST_TIME 103 9515
TEST_TIME 104 9489
TEST_TIME 105 9481
TEST_TIME 106 9456
TEST_TIME 107 9455
TEST_TIME 108 9428
TEST_TIME 109 9360
TEST_TIME 110 9307
TEST_TIME 111 9350
TEST_TIME 112 9367
TEST_TIME 113 9369
TEST_TIME 114 9358
TEST_TIME 115 9368
TEST_TIME 116 9364
TEST_TIME 117 9377
TEST_TIME 118 9382
TEST_TIME 119 9406
TEST_TIME 120 9362

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 20-03-2021 16:28:20 to 20-03-2021 16:28:24.

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 1536869 1536869 0 0.00 0 18430 6 0 0
doc_list_biud 1536869 1536869 0 0.00 0 47762 27 0 0
sp_add_invoice_to_stock 4905 4807 98 1.99 30 209167 18561 0 98
sp_cancel_adding_invoice 6027 6027 0 0.00 5 69710 838 0 0
sp_cancel_client_order 1702 1702 0 0.00 4 20967 390 0 0
sp_cancel_customer_reserve 594390 594390 0 0.00 1 47765 54 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 3 2609 68 0 0
sp_cancel_pay_to_supplier 397 397 0 0.00 3 16475 119 0 0
sp_cancel_supplier_invoice 6758 6753 5 0.07 2 15431 730 0 5
sp_cancel_supplier_order 419 419 0 0.00 6 993214 97045 0 0
sp_cancel_write_off 10900 10900 0 0.00 1 17287 112 0 0
sp_client_order 19983 19983 0 0.00 4 39477 374 0 0
sp_customer_reserve 443013 443013 0 0.00 0 89236 184 0 0
sp_fill_shopping_cart 30709 30709 0 0.00 1 10713 38 0 0
sp_fill_shopping_cart_clo_res 443013 443013 0 0.00 0 11680 13 0 0
sp_get_clo_for_invoice 4806 4806 0 0.00 0 30801 289 0 0
sp_kill_cost_storno 17997 17997 0 0.00 0 16965 55 0 0
sp_kill_qstorno_ret_qs2qd 1206852 1206852 0 0.00 0 47656 29 0 0
sp_kill_qty_storno 634617 634617 0 0.00 0 47762 64 0 0
sp_lock_selected_doc 20084 20084 0 0.00 0 10868 6 0 0
sp_make_cost_storno 26915 26915 0 0.00 0 14391 51 0 0
sp_multiply_rows_for_pdistr 26915 26915 0 0.00 0 14743 33 0 0
sp_multiply_rows_for_qdistr 19983 19983 0 0.00 0 39284 162 0 0
sp_pay_from_customer 6743 6743 0 0.00 4 16354 121 0 0
sp_pay_to_supplier 5746 5746 0 0.00 4 20510 151 0 0
sp_payment_common 12489 12489 0 0.00 1 17065 39 0 0
sp_qd_handle_on_cancel_clo 1702 1702 0 0.00 0 20958 360 0 0
sp_qd_handle_on_invoice_upd_sts 10833 10833 0 0.00 0 30997 366 0 0
sp_qd_handle_on_reserve_upd_sts 9620 9620 0 0.00 0 11190 68 0 0
sp_reserve_write_off 9620 9620 0 0.00 6 22568 200 0 0
sp_supplier_invoice 5324 5324 0 0.00 7 98655 3377 0 0
sp_supplier_order 5409 5409 0 0.00 5 42086 1299 0 0
srv_aggregate_perf_data 112 112 0 0.00 2284 115751 15472 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1251 166552 33711 0 0
srv_find_qd_qs_mism 1078967 1078967 0 0.00 0 16860 5 0 0
srv_make_invnt_saldo 557 557 0 0.00 45 57970 1288 0 0
srv_make_money_saldo 712 712 0 0.00 1 8085 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 250134 443658 314701 0 0
t$perf-abend:sp_add_invoice_to_stock 98 98 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4808 4808 0 0.00 0 15930 176 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 1 9189 101 0 0
t$perf-norm:sp_cancel_client_order 1702 1702 0 0.00 0 4293 16 0 0
t$perf-norm:sp_cancel_customer_reserve 676 676 0 0.00 0 827 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 3449 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 397 397 0 0.00 0 504 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 417 417 0 0.00 0 2649 17 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 25281 1641 0 0
t$perf-norm:sp_cancel_write_off 970 970 0 0.00 0 2498 12 0 0
t$perf-norm:sp_client_order 19983 19983 0 0.00 0 12218 21 0 0
t$perf-norm:sp_customer_reserve 955 955 0 0.00 0 495 3 0 0
t$perf-norm:sp_pay_from_customer 6743 6743 0 0.00 0 6160 11 0 0
t$perf-norm:sp_pay_to_supplier 5746 5746 0 0.00 0 9072 12 0 0
t$perf-norm:sp_reserve_write_off 9620 9620 0 0.00 0 5626 11 0 0
t$perf-norm:sp_supplier_invoice 5324 5324 0 0.00 0 9940 25 0 0
t$perf-norm:sp_supplier_order 5409 5409 0 0.00 0 9959 18 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 5814 62 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 735 12 0 0
t$perf-norm:srv_make_invnt_saldo 557 557 0 0.00 0 5241 27 0 0
t$perf-norm:srv_make_money_saldo 712 712 0 0.00 0 1331 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 91 25 0 0
v_add_invoice_to_stock 9806 9610 196 1.99 0 7774 22 0 196
v_all_customers 36302 36302 0 0.00 0 24 1 0 0
v_all_suppliers 29868 29868 0 0.00 0 18 1 0 0
v_all_wares 39966 39966 0 0.00 0 13 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 455 5 0 0
v_cancel_client_order 3404 3404 0 0.00 0 4458 8 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 2592 9 0 0
v_cancel_customer_reserve 1352 1352 0 0.00 0 2583 8 0 0
v_cancel_payment_to_supplier 794 794 0 0.00 0 4960 17 0 0
v_cancel_supplier_invoice 844 834 10 1.18 0 5250 29 0 10
v_cancel_supplier_order 838 838 0 0.00 0 2099 9 0 0
v_cancel_write_off 1940 1940 0 0.00 0 6697 15 0 0
v_max_id_clo_ord 5407 5407 0 0.00 0 1636 1 0 0
v_max_id_clo_res 955 955 0 0.00 0 3536 20 0 0
v_max_id_ord_sup 5319 5319 0 0.00 0 2539 3 0 0
v_max_non_paid_invoice 1538 1538 0 0.00 0 785 3 0 0
v_max_non_paid_realizn 3682 3682 0 0.00 0 3213 5 0 0
v_min_id_clo_ord 5407 5407 0 0.00 0 7039 15 0 0
v_min_id_clo_res 955 955 0 0.00 0 4016 10 0 0
v_min_id_ord_sup 5319 5319 0 0.00 0 6750 9 0 0
v_min_non_paid_invoice 5746 5746 0 0.00 0 14279 30 0 0
v_min_non_paid_realizn 6743 6743 0 0.00 0 15788 27 0 0
v_our_firm 9784 9784 0 0.00 0 24 1 0 0
v_reserve_write_off 19240 19240 0 0.00 0 8186 10 0 0
x_lock_depdocs_on_canc_invoice 12363 12363 0 0.00 0 22492 109 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 13908 347 0 0
x_make_qstorno_1000_1200 5409 5409 0 0.00 1 42050 1211 0 0
x_make_qstorno_1200_2000 5324 5324 0 0.00 3 91895 3243 0 0
x_make_qstorno_2100_3300 443013 443013 0 0.00 0 89233 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-03-2021 16:28:25 to 20-03-2021 16:28:29.

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:30 6 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:36 11851 8192000000 10197717568 10499629056 810898448 9.007 65 50 100 0 830562848 2346544 17317856
13:57:56 25420 8192000000 10335664336 10649055232 1368888752 14.317 100 77 154 0 1398131456 4222560 25020144
13:58:40 25591 8192000000 10387163056 10709643264 1436111280 14.915 100 91 182 0 1472034480 6601728 29321472
13:59:16 18835 8192000000 10410604128 10737004544 1462785248 15.150 100 84 168 0 1497721936 7539872 27396816
13:59:44 30640 8192000000 10435107696 10764197888 1480741856 15.308 100 89 178 0 1517837712 8323696 28772160
14:00:23 10685 8192000000 10435466400 10768277504 1494556592 15.429 100 93 186 0 1533750544 9064464 30129488
14:00:45 15795 8192000000 10458109072 10790686720 1509832016 15.562 100 96 192 0 1550080384 9668880 30579488
14:01:14 19355 8192000000 10471339744 10809217024 1521617520 15.664 100 82 164 2 1557291136 9887664 25785952
14:01:47 15764 8192000000 10503783248 10845618176 1544912128 15.866 100 83 166 1 1581280128 10434128 25933872
14:02:14 8997 8192000000 10508454688 10859950080 1569013120 16.074 100 76 152 0 1603390416 10776656 23600640
14:02:36 15979 8192000000 10541010256 10895929344 1598601952 16.327 100 79 158 1 1634882032 11049584 25230496
14:02:59 7836 8192000000 10556838496 10918662144 1620877568 16.517 100 70 138 2 1652146400 10508432 20760400
14:03:18 10104 8192000000 10589521824 10953023488 1644998128 16.722 100 79 159 0 1681129664 11046272 25085264
14:03:40 7686 8192000000 10600955072 10971623424 1667973360 16.916 100 71 142 1 1699924768 10576704 21374704
14:03:55 8364 8192000000 10618709136 10991144960 1685292464 17.062 100 71 142 0 1716456704 10425408 20738832
14:04:10 10417 8192000000 10637516112 11013681152 1711284672 17.279 100 76 152 1 1744814080 11498736 22030672
14:04:30 9411 8192000000 10669691904 11044950016 1727735936 17.417 100 77 155 2 1762263216 12841264 21686016
14:04:48 6801 8192000000 10676470512 11054968832 1737818432 17.501 100 72 141 3 1769809360 12229456 19761472
14:05:03 5262 8192000000 10693002720 11072339968 1757161184 17.661 100 78 156 1 1791851968 12808464 21882320
14:05:15 5681 8192000000 10703477312 11081228288 1764724064 17.723 100 77 152 0 1799243520 12877728 21641728
14:05:29 5125 8192000000 10718728576 11094364160 1778124992 17.834 100 81 162 2 1814693680 14153984 22414704
14:05:41 3468 8192000000 10720736768 11100962816 1787332448 17.910 100 88 175 0 1826086816 14303072 24451296
14:05:53 9164 8192000000 10721590672 11109015552 1794165120 17.966 100 72 144 1 1827246304 13516528 19564656
14:06:11 2870 8192000000 10746697424 11129266176 1808961792 18.087 100 75 150 0 1843702176 13522928 21217456
14:06:20 2955 8192000000 10752389712 11139260416 1817102752 18.154 100 80 160 0 1853375040 13112496 23159792
14:06:30 3411 8192000000 10764923264 11150315520 1827149696 18.236 100 86 171 2 1865787648 13484144 25153808
14:06:40 2505 8192000000 10767225888 11152285696 1828193520 18.245 100 79 158 0 1864394064 13399088 22801456
14:06:49 2095 8192000000 10776157520 11161038848 1834823120 18.299 100 86 169 3 1870971664 12429280 23719264
14:06:58 2913 8192000000 10790555328 11173851136 1842869856 18.364 100 89 175 1 1881053296 13351008 24832432
14:07:07 2962 8192000000 10787498512 11171663872 1845435424 18.385 100 90 180 0 1884672144 13198432 26038288
14:07:16 2214 8192000000 10793963344 11178233856 1848095376 18.407 100 85 167 1 1883806432 12057856 23653200
14:07:25 2494 8192000000 10806361776 11192074240 1856611504 18.476 100 90 180 2 1894565696 12071648 25882544
14:07:33 2797 8192000000 10801830000 11189366784 1858970912 18.495 100 89 178 1 1897194096 13439712 24783472
14:07:43 1662 8192000000 10811107984 11195817984 1862166144 18.521 100 92 183 0 1905784992 17622416 25996432
14:07:51 1672 8192000000 10802967520 11189833728 1861593392 18.516 100 87 175 1 1898684688 11974320 25116976
14:07:59 1527 8192000000 10807540464 11195510784 1865165232 18.545 100 84 168 0 1900613136 11523904 23924000
14:08:07 2055 8192000000 10802480064 11197095936 1862418336 18.523 100 83 166 0 1898545392 12427536 23699520
14:08:15 1689 8192000000 10802169584 11195744256 1867971248 18.568 100 90 180 1 1906716784 13461248 25284288
14:08:23 13770 8192000000 10811387632 11202146304 1866596608 18.557 100 72 144 1 1897112464 10341568 20174288
14:08:43 5559 8192000000 10798352688 11199344640 1869997184 18.584 100 70 141 0 1900250336 11551104 18702048
14:08:56 10460 8192000000 10813495424 11205218304 1872621808 18.605 100 80 163 1 1907168720 11318800 23228112
14:09:13 1074 8192000000 10817049264 11212255232 1874581456 18.621 100 80 160 1 1909876528 13050672 22244400
14:09:21 28425 8192000000 10796446544 11200823296 1868871072 18.575 100 53 106 2 1891517776 7037552 15609152
14:09:56 7949 8192000000 10782986656 11202813952 1871422480 18.596 100 49 96 0 1892817248 7548640 13846128
14:10:13 5191 8192000000 10783314912 11203207168 1867396032 18.563 100 23 46 1 1880596480 6021808 7178640
14:10:26 7607 8192000000 10780271504 11209891840 1870987056 18.592 100 30 60 1 1887031168 7614864 8429248
14:10:43 7148 8192000000 10784326736 11208720384 1873795344 18.615 100 34 68 1 1890966336 7984240 9186752
14:10:57 5154 8192000000 10775633776 11207847936 1878083008 18.650 100 29 55 2 1892790400 5765472 8941920
14:11:11 9933 8192000000 10781004128 11212713984 1877390336 18.644 100 22 45 1 1890411568 6340928 6680304
14:11:30 8674 8192000000 10777896192 11213828096 1877481920 18.645 100 22 44 1 1889976560 6293968 6200672
14:11:46 9303 8192000000 10791778432 11219218432 1880224400 18.667 100 16 32 1 1889699184 5162080 4312704
14:12:02 7290 8192000000 10796191296 11226800128 1882457328 18.685 100 14 28 1 1896432480 9981344 3993808
14:12:16 12684 8192000000 10798418640 11229003776 1886909904 18.721 100 19 38 0 1898653616 6335472 5408240
14:12:35 10645 8192000000 10800391216 11230007296 1887235088 18.723 100 16 31 4 1901321344 9644208 4442048
14:12:53 8211 8192000000 10800511728 11231645696 1889931792 18.745 100 21 42 3 1902358752 6234688 6192272
14:13:08 8865 8192000000 10799759024 11229376512 1892776448 18.768 100 23 46 1 1905822368 5497696 7548224
14:13:25 67579 8192000000 10824508016 11252690944 1896890864 18.801 100 31 62 2 1911326448 5376032 9059552
14:14:39 8234 8192000000 10802169488 11245252608 1897591408 18.807 100 11 22 1 1906812576 5310336 3910832
14:14:53 8566 8192000000 10823880432 11253895168 1904729040 18.864 100 29 57 3 1919068992 6430544 7909408
14:15:09 6855 8192000000 10825352336 11258642432 1904420656 18.862 100 26 52 0 1919178000 7663040 7094304
14:15:22 7749 8192000000 10827844768 11256897536 1904218720 18.860 100 27 54 0 1917530704 5892400 7419584
14:15:37 7335 8192000000 10826138304 11256651776 1906121040 18.875 100 28 57 2 1920730208 6884960 7724208
14:15:55 3117 8192000000 10820873840 11255017472 1905783568 18.873 100 27 54 1 1919123088 6090592 7248928
14:16:06 5929 8192000000 10805147344 11229949952 1845847200 18.388 97 29 57 4 1859799600 6079104 7873296
14:16:20 8910 8192000000 10802909904 11242160128 1894279824 18.780 100 14 28 2 1903851200 5535072 4036304
14:16:35 9504 8192000000 10783630608 11216363520 1823894896 18.210 96 16 32 0 1838214768 9897744 4422128
14:16:53 5929 8192000000 10785521328 11214098432 1843629824 18.370 98 35 70 4 1859617424 4783760 11203840
14:17:08 8085 8192000000 10796496784 11230785536 1879607760 18.662 100 15 30 2 1892898816 9294224 3996832
14:17:25 10174 8192000000 10739930128 11174772736 1745424560 17.564 93 17 34 0 1755426944 5344528 4657856
14:17:42 8006 8192000000 10762687520 11191463936 1839879136 18.340 99 18 37 1 1851893280 6461488 5552656
14:17:56 23939 8192000000 10734804816 11163873280 1791875680 17.947 97 18 36 2 1802288544 5613104 4799760
14:18:50 26908 8192000000 10755538896 11174551552 1778676512 17.839 96 13 26 0 1787208608 5197104 3334992
14:19:26 8442 8192000000 10746173776 11156606976 1749722208 17.599 95 20 40 1 1760138208 4642944 5773056
14:19:42 6098 8192000000 10702895440 11112476672 1732076192 17.453 96 33 66 0 1748731472 6699920 9955360
14:19:55 5704 8192000000 10718433936 11132477440 1767368432 17.745 98 25 50 0 1781537920 6425008 7744480
14:20:11 6676 8192000000 10692798688 11104296960 1719342144 17.347 96 27 55 0 1733702096 6200720 8159232
14:20:26 6427 8192000000 10702756192 11114004480 1743543712 17.548 97 31 62 1 1758165552 5471904 9149936
14:20:40 4523 8192000000 10721547664 11136253952 1782876864 17.873 99 21 42 0 1794453040 5740016 5836160
14:20:54 9154 8192000000 10714668032 11140108288 1807926352 18.079 100 32 62 3 1826978592 9738656 9313584
14:21:13 8812 8192000000 10722611472 11144859648 1806548368 18.068 100 20 41 0 1818509488 5728496 6232624
14:21:28 8206 8192000000 10710088688 11128340480 1761436112 17.696 97 23 46 1 1773275440 5114960 6724368
14:21:42 9004 8192000000 10726854544 11131203584 1781981488 17.866 98 34 67 1 1797401296 5000624 10419184
14:21:59 9650 8192000000 10741656256 11151552512 1814024944 18.129 100 19 37 3 1824279904 5236416 5018544
14:22:17 5466 8192000000 10754644496 11165536256 1825181136 18.220 100 34 66 2 1840686944 5160448 10345360
14:22:31 7548 8192000000 10725035648 11142098944 1806985904 18.071 99 26 52 0 1821554000 5565808 9002288
14:22:44 24250 8192000000 10728302992 11157950464 1822918848 18.202 100 21 40 3 1835963104 5685840 7358416
14:23:18 57641 8192000000 10752109200 11173167104 1831576400 18.272 100 35 68 2 1847751168 6386976 9787792
14:24:25 8217 8192000000 10753412992 11178483712 1839006432 18.333 100 28 56 0 1853172960 6426320 7740208
14:24:41 5490 8192000000 10766011136 11188903936 1846287520 18.392 100 25 50 1 1860010656 6381904 7341232
14:24:52 11795 8192000000 10785972512 11200647168 1852449504 18.442 100 31 61 1 1868783472 5823856 10510112
14:25:11 4170 8192000000 10772264960 11199094784 1855663584 18.468 100 27 50 1 1868847920 6077552 7106784
14:25:22 6707 8192000000 10773585792 11200466944 1858769840 18.493 100 28 56 2 1872384144 6363088 7251216
14:25:38 12573 8192000000 10772740080 11202789376 1857736144 18.485 100 18 36 2 1868648800 5618848 5293808
14:25:57 7233 8192000000 10782545088 11211575296 1862329904 18.522 100 26 52 2 1879825072 10026912 7468256
14:26:13 9052 8192000000 10774900352 11207577600 1863488656 18.532 100 20 39 0 1875006320 5480688 6036976
14:26:31 7889 8192000000 10779298112 11212455936 1866450528 18.556 100 27 54 0 1880270080 5837088 7982464
14:26:50 9080 8192000000 10788728240 11219324928 1870458320 18.588 100 25 50 1 1883847440 6155232 7233888
14:27:12 14610 8192000000 10795807984 11233165312 1886719664 18.719 100 9 18 0 1893988448 4912352 2356432
14:27:58 23345 8192000000 10842697008 11260399616 1905088112 18.867 100 38 74 3 1921421408 5368176 10965120
14:28:39 12891 8192000000 10851807440 11271933952 1919819104 18.985 100 43 85 1 1940079808 7305200 12955504
14:29:16 53371 8192000000 10864863808 11291389952 1932189088 19.084 100 42 84 0 1953030384 8655296 12186000
14:30:25 41166 8192000000 10864166832 11296165888 1939444160 19.142 100 36 70 1 1958934336 8941440 10548736
14:31:14 13201 8192000000 10873167584 11303960576 1947061600 19.203 100 54 108 1 1972279760 10099552 15118608
14:31:34 37608 8192000000 10866666432 11305476096 1945876576 19.194 100 34 68 0 1965237632 8822000 10539056
14:32:26 9649 8192000000 10877221840 11314585600 1949936592 19.226 100 30 59 2 1972039792 13192032 8911168
14:32:43 20670 8192000000 10897362928 11324579840 1956718272 19.280 100 44 86 1 1980148240 10631136 12798832
14:33:23 12259 8192000000 10898758096 11328925696 1963590832 19.335 100 40 80 0 1987076496 11781616 11704048
14:33:45 16946 8192000000 10908572272 11339063296 1967276752 19.364 100 43 87 1 1992637376 12787216 12573408
14:34:18 14940 8192000000 10916528768 11350151168 1974128208 19.418 100 49 98 2 2006139424 17427856 14583360
14:34:41 10699 8192000000 10921867440 11359477760 1981456016 19.476 100 45 90 1 2016789168 21174224 14158928
14:35:01 17766 8192000000 10924766896 11364036608 1981329136 19.475 100 41 82 2 2014601072 21240816 12031120
14:35:28 2467 8192000000 10935759552 11361128448 1971647296 19.399 99 60 119 3 2007242736 18904400 16691040
14:35:38 4409 8192000000 10938140016 11369693184 1989795200 19.542 100 60 120 0 2028821104 20864112 18161792
14:35:55 6999 8192000000 10947815872 11370950656 1978386608 19.452 99 56 113 0 2013373776 18187808 16799360
14:36:13 3170 8192000000 10931860720 11361820672 1978934160 19.456 99 60 119 0 2016048032 19054336 18059536
14:36:23 12420 8192000000 10915995120 11352309760 1951842448 19.241 98 48 94 3 1984848752 17990736 15015568
14:36:46 1777 8192000000 10937689312 11363565568 1985102336 19.505 100 74 144 1 2025417040 18885264 21429440
14:36:55 15697 8192000000 10932325456 11358429184 1967921152 19.369 99 70 139 1 2011096112 22135680 21039280
14:37:19 4755 8192000000 10936624064 11363450880 1981934208 19.480 100 61 121 1 2023340144 22160576 19245360
14:37:32 7038 8192000000 10931151024 11362062336 1982409200 19.484 100 65 130 1 2024104352 21626928 20068224
14:37:54 15936 8192000000 10932380560 11363729408 1982275072 19.483 100 58 116 3 2021079760 21183408 17621280
14:38:19 7665 8192000000 10922051952 11358199808 1968371136 19.373 99 54 109 0 2006771728 22183168 16217424
14:38:37 5104 8192000000 10932709728 11366387712 1985869728 19.511 100 51 102 1 2023291472 21578208 15843536
14:38:51 2954 8192000000 10948208800 11378339840 1996709392 19.597 100 60 118 0 2033569952 19703408 17157152
14:39:04 6385 8192000000 10946406384 11378085888 1981895696 19.480 99 58 116 0 2019702016 20678160 17128160
14:39:21 6562 8192000000 10952830496 11383857152 2000781424 19.629 100 62 124 1 2040572976 21763296 18028256
14:39:35 3696 8192000000 10944200560 11374829568 1995702496 19.589 100 67 134 0 2037798400 22344336 19751568
14:39:54 6422 8192000000 10937490464 11371798528 1988359872 19.531 100 62 122 1 2027553472 21234768 17958832
14:40:07 5551 8192000000 10920826352 11346821120 1955070608 19.267 98 58 115 1 1993811344 21402784 17337952
14:40:21 11844 8192000000 10925661824 11355107328 1976473536 19.437 100 55 111 2 2014700304 21586528 16640240
14:40:42 10233 8192000000 10941856656 11373514752 1984893568 19.503 100 58 113 2 2028287456 26159952 17233936
14:41:04 7651 8192000000 10955366256 11380805632 1993581824 19.572 100 66 128 3 2040540912 27515920 19443168
14:41:22 3637 8192000000 10949508240 11361058816 1972412192 19.405 99 80 161 3 2027661488 30707504 24541792
14:41:37 4405 8192000000 10946174000 11370643456 1979147776 19.458 99 77 154 2 2034048560 32091312 22809472
14:41:57 2523 8192000000 10955815984 11373899776 1977482240 19.445 99 77 156 3 2035398144 34641264 23274640
14:42:07 2825 8192000000 10940327696 11359555584 1948466944 19.214 98 83 164 1 2009599456 35632224 25500288
14:42:17 2027 8192000000 10944908912 11371188224 1978318432 19.451 100 73 145 1 2035633056 33754272 23560352
14:42:27 3201 8192000000 10956342448 11379335168 1984429296 19.500 100 71 141 1 2039675600 33432720 21813584
14:42:39 4919 8192000000 10958316064 11380867072 1988176448 19.529 100 67 133 1 2041197952 32162208 20859296
14:42:54 3449 8192000000 10949104256 11374157824 1967668080 19.367 99 70 141 3 2023229216 33212096 22349040
14:43:07 5446 8192000000 10953012016 11369943040 1975152736 19.426 100 80 160 1 2033463056 33443472 24866848
14:43:23 6787 8192000000 10923942224 11348271104 1956275440 19.276 100 61 122 0 2008873376 33867376 18730560
14:43:37 1315 8192000000 10932229392 11334963200 1924523024 19.023 98 89 178 0 1986485536 33880432 28082080
14:43:46 4152 8192000000 10929656272 11348205568 1956590800 19.279 100 69 138 1 2013337664 34855344 21891520
14:43:57 2051 8192000000 10951956656 11369574400 1976619216 19.438 100 83 164 2 2038499536 36513888 25366432
14:44:07 2703 8192000000 10945585472 11358187520 1964999888 19.346 100 81 161 0 2026084192 36606928 24477376
14:44:17 3497 8192000000 10934674080 11343360000 1949737536 19.224 99 80 160 3 2007655520 33609936 24308048
14:44:29 3174 8192000000 10957728992 11370041344 1974490272 19.421 100 87 171 3 2036486544 35203856 26792416
14:44:38 1251 8192000000 10959122256 11374280704 1981121520 19.474 100 86 172 0 2044275696 36562560 26591616
14:44:46 1769 8192000000 10966663712 11381137408 1984523296 19.500 100 90 180 0 2049605440 37437328 27644816
14:44:58 5505 8192000000 10929772848 11348676608 1953149840 19.252 100 72 144 2 2013806496 38331664 22324992
14:45:13 6944 8192000000 10930768368 11352956928 1955216720 19.268 100 70 140 0 2016282064 39267152 21798192
14:45:33 3377 8192000000 10959311504 11372929024 1973238704 19.411 100 83 165 0 2040276832 41902304 25135824
14:45:45 2129 8192000000 10955448096 11366223872 1968131920 19.371 100 83 165 1 2036648768 42954048 25562800
14:45:56 6151 8192000000 10966192576 11384811520 1977781584 19.447 100 72 143 2 2046713648 45835488 23096576
14:46:11 3158 8192000000 10970203936 11387191296 1982789056 19.487 100 78 157 0 2049864240 42987648 24087536
14:46:21 2899 8192000000 10961214464 11380654080 1963586336 19.335 99 77 149 1 2031404720 43332496 24485888
14:46:32 2267 8192000000 10963703392 11377303552 1977980304 19.449 100 87 172 1 2046749376 41739568 27029504
14:46:42 2787 8192000000 10964996320 11380928512 1975468512 19.429 100 82 161 1 2045156704 43395168 26293024
14:46:51 3626 8192000000 10935997744 11355230208 1942312480 19.165 99 67 134 0 2004155024 40513264 21329280
14:47:04 9592 8192000000 10911755072 11350847488 1947830000 19.209 100 61 122 0 2009958480 42309344 19819136
14:47:27 10555 8192000000 10910759696 11345653760 1939269632 19.141 100 41 82 2 1995340224 41795056 14275536
14:47:45 12650 8192000000 10913242000 11347091456 1927096368 19.044 99 39 78 0 1984794656 43817248 13881040
14:48:05 11589 8192000000 10912418304 11347443712 1927272224 19.045 99 45 90 0 1987077664 44708592 15096848
14:48:36 10725 8192000000 10910033568 11343413248 1933488736 19.095 100 39 77 2 1991436480 44459408 13488336
14:48:53 5592 8192000000 10925848512 11339993088 1925950384 19.034 99 63 126 2 1995526848 48173120 21403344
14:49:06 2990 8192000000 10933995104 11354374144 1943619904 19.176 100 64 125 3 2010790336 46119488 21050944
14:49:24 3037 8192000000 10964237696 11376685056 1963674832 19.335 100 84 167 0 2035080560 44885216 26520512
14:49:34 3320 8192000000 10955123648 11370426368 1971082704 19.394 100 81 163 0 2035091888 38605984 25403200
14:49:44 5063 8192000000 10948042272 11376185344 1969370352 19.380 100 61 122 0 2029064704 40084176 19610176
14:50:01 20224 8192000000 10919175936 11370979328 1929536656 19.063 98 38 76 1 1985595888 42709104 13350128
14:50:38 19495 8192000000 10908029808 11351711744 1940345840 19.150 99 29 58 0 1985668624 35857936 9464848
14:51:38 20410 8192000000 10909145968 11352420352 1946664816 19.200 100 37 74 1 1995047056 36139216 12243024
14:52:12 26648 8192000000 10901977184 11342397440 1924226800 19.021 99 35 70 1 1974224416 37139600 12858016
14:52:45 8097 8192000000 10914340832 11344732160 1936622848 19.120 99 54 106 2 1982429184 29431280 16375056
14:53:05 23895 8192000000 10884896160 11340173312 1908961344 18.898 98 23 46 1 1945051920 27918992 8171584
14:53:36 27058 8192000000 10868984400 11325431808 1912827952 18.929 99 18 36 1 1947291568 27706848 6756768
14:54:12 23132 8192000000 10854603712 11323543552 1916421936 18.958 100 8 16 1 1937258352 17941536 2894880
14:54:43 16809 8192000000 10843330032 11312271360 1903632192 18.855 99 13 24 4 1918998656 11595472 3770992
14:55:24 54401 8192000000 10878584784 11327492096 1923481408 19.015 99 14 28 1 1936365744 8942784 3941552
14:56:30 19277 8192000000 10904770928 11335077888 1950418064 19.230 100 38 74 2 1971270384 10295568 10556752
14:57:05 60662 8192000000 10879702032 11349196800 1908457888 18.894 98 8 16 0 1920516832 9864128 2194816
14:59:19 72904 8192000000 10891958960 11353579520 1928051696 19.051 98 17 33 4 1944394016 11352144 4990176
15:00:39 166552 8192000000 10902334400 11362234368 1879941904 18.665 95 6 12 0 1898987152 17837200 1208048
15:03:32 40236 8192000000 10904314944 11366981632 1940835360 19.153 98 14 27 0 1956798080 12069536 3893184
15:04:18 52467 8192000000 10923168992 11392200704 1961632320 19.319 99 8 16 0 1981751856 17800560 2318976
15:05:17 132397 8192000000 10946013728 11391184896 1967212064 19.363 99 11 22 0 1983905008 13438352 3254592
15:07:57 68326 8192000000 10928261856 11401895936 1981047152 19.473 99 39 78 3 2005708944 14393424 10268368
15:09:20 36302 8192000000 10946834608 11409219584 2001396592 19.634 100 29 57 1 2025701376 15729616 8575168
15:10:26 80107 8192000000 10914861232 11409985536 1979699520 19.462 99 18 36 0 2009747184 24924224 5123440
15:12:22 35859 8192000000 10933870080 11399421952 1989573712 19.540 99 32 64 3 2010506528 11488032 9444784
15:13:16 34723 8192000000 10965587664 11417550848 2013728352 19.731 100 42 85 1 2037690720 11431568 12530800
15:13:58 61189 8192000000 10961347712 11420368896 2015746688 19.747 100 29 58 1 2042455872 18431856 8277328
15:15:16 41724 8192000000 10951229568 11416530944 1989571152 19.540 99 20 40 0 2013881088 17477840 6832096
15:16:06 35432 8192000000 10919301296 11388710912 1962123104 19.323 98 26 52 1 1981536096 11707568 7705424
15:16:51 119958 8192000000 10930905536 11406155776 1965262384 19.348 98 14 28 1 1980419040 10836816 4319840
15:19:32 32921 8192000000 10920982640 11396239360 1980398096 19.468 99 12 25 3 1993355792 9705904 3251792
15:20:11 34876 8192000000 10921248224 11403145216 1999448944 19.618 100 15 30 1 2013570816 9959472 4162400
15:20:53 93058 8192000000 10904221680 11401236480 1977523728 19.445 99 10 20 1 1991563440 11294192 2745520
15:22:33 41269 8192000000 10921519664 11390660608 1956599408 19.279 98 12 24 1 1968469840 8470880 3399552
15:24:04 64041 8192000000 10907284464 11395551232 1985327184 19.507 100 10 20 2 2003636304 15720432 2588688
15:25:17 74661 8192000000 10897646224 11394695168 1950200176 19.228 98 4 8 0 1965549840 14333824 1015840
15:26:39 71642 8192000000 10889240976 11378085888 1932954976 19.090 97 7 14 2 1950369392 15873488 1540928
15:28:04 60802 8192000000 10897257472 11368464384 1890425984 18.749 95 13 27 0 1904657648 10018176 4213488
15:29:23 68729 8192000000 10887880528 11363090432 1921308464 18.997 97 15 30 1 1936372720 10776368 4287888
15:31:09 47912 8192000000 10846963984 11319894016 1816857584 18.152 92 17 34 2 1833026560 11290224 4878752
15:32:03 39594 8192000000 10901610224 11357196288 1953750048 19.256 100 32 64 2 1974874528 12342560 8781920
15:32:52 30287 8192000000 10889537552 11353751552 1902153776 18.844 97 41 81 4 1925115312 11458992 11502544
15:33:41 31922 8192000000 10887941920 11348451328 1929862736 19.066 99 23 46 0 1949508464 13178608 6467120
15:34:29 44202 8192000000 10885146784 11348905984 1931088976 19.076 99 27 53 0 1952771520 14390160 7292384
15:35:20 32112 8192000000 10921306784 11372896256 1967624992 19.367 100 38 75 3 1987821664 9368320 10828352
15:36:01 22096 8192000000 10921465152 11371061248 1950612256 19.231 99 39 78 0 1972579216 10857264 11109696
15:36:32 30661 8192000000 10923741024 11372818432 1953873424 19.257 99 49 97 4 1984219760 17020224 13326112
15:37:12 16838 8192000000 10918329888 11378171904 1967469104 19.365 100 45 90 1 1995289392 14842496 12977792
15:37:36 45612 8192000000 10911326544 11388997632 1970075712 19.386 100 24 48 0 1993551712 16813792 6662208
15:38:31 80170 8192000000 10882831824 11363176448 1867819472 18.567 95 11 21 0 1887440688 16547936 3073280
15:39:57 23426 8192000000 10864435376 11324878848 1870160096 18.586 96 25 50 0 1884258224 7360624 6737504
15:40:27 19999 8192000000 10884644496 11339816960 1916819312 18.961 99 27 54 2 1932298368 8279520 7199536
15:40:55 41405 8192000000 10869770656 11330981888 1893283424 18.772 97 40 80 1 1915815328 11466704 11065200
15:41:42 118076 8192000000 10873726064 11329417216 1881887920 18.680 97 24 48 1 1898107216 9720384 6498912
15:43:59 95306 8192000000 10853682608 11343306752 1900551008 18.831 98 23 46 0 1924936624 17455376 6930240
15:45:42 32288 8192000000 10856108752 11350745088 1931210160 19.077 100 7 14 0 1948757552 15606112 1941280
15:46:28 96617 8192000000 10853119888 11341193216 1920461088 18.991 99 11 21 0 1938117248 14543232 3112928
15:48:10 55194 8192000000 10843482240 11319099392 1903285248 18.853 98 12 24 1 1921322992 14468144 3569600
15:50:05 61679 8192000000 10863110848 11330981888 1909510992 18.903 99 11 22 0 1931186816 18275024 3400800
15:51:16 94367 8192000000 10840191088 11320082432 1872804992 18.607 97 7 14 0 1887916432 13380480 1730960
15:52:56 54303 8192000000 10866061616 11311955968 1871112000 18.593 97 17 33 0 1883299184 7460576 4726608
15:54:01 33313 8192000000 10885346768 11331358720 1916926224 18.962 99 42 84 0 1941522352 11783584 12812544
15:54:41 21013 8192000000 10876413872 11339055104 1938381632 19.134 100 33 66 2 1962594256 14312976 9899648
15:55:14 73423 8192000000 10861818464 11352428544 1900584944 18.831 98 15 30 0 1921883120 16493408 4804768
15:56:37 106528 8192000000 10870994608 11343101952 1888797952 18.736 97 14 28 0 1908672432 16054304 3820176
15:58:30 74750 8192000000 10914636208 11379453952 1975145248 19.426 100 28 56 0 2002002160 18981040 7875872
15:59:55 73190 8192000000 10923914400 11408613376 1972614176 19.406 100 11 22 1 1998930656 23156416 3160064
16:02:12 89861 8192000000 10918186400 11404496896 1961700272 19.320 99 21 42 0 1978999648 11604480 5694896
16:03:48 118184 8192000000 10917455248 11392352256 1945092064 19.187 98 17 34 2 1968267856 18943280 4232512
16:05:52 98338 8192000000 10903774480 11388837888 1945426368 19.190 98 15 30 1 1961264112 11588512 4249232
16:07:47 81144 8192000000 10893175712 11359920128 1900328560 18.829 96 28 56 3 1915090352 6614704 8147088
16:09:14 65735 8192000000 10892177824 11365441536 1949309600 19.221 99 23 46 1 1968351296 12569616 6472080
16:10:29 14628 8192000000 10890286544 11358502912 1944572272 19.183 99 16 32 2 1958819232 10019712 4227248
16:10:51 35724 8192000000 10892817648 11355713536 1948211264 19.212 99 26 51 1 1963726528 8316416 7198848
16:11:39 105772 8192000000 10913906528 11394174976 1958784352 19.296 99 18 36 2 1973912224 9530400 5597472
16:13:42 81191 8192000000 10906168496 11395653632 1968444624 19.373 99 16 32 2 1983574544 10275264 4854656
16:15:12 77477 8192000000 10875270160 11356491776 1889158656 18.739 95 16 31 2 1902122144 8166944 4796544
16:17:10 64290 8192000000 10889080512 11369435136 1952061104 19.243 99 22 44 0 1970391824 12083232 6247488
16:19:00 68316 8192000000 10892183040 11371962368 1906246368 18.877 97 16 32 1 1921809648 10839824 4723456
16:20:44 50139 8192000000 10849198576 11312783360 1780857536 17.857 91 24 48 2 1795775568 8413664 6504368
16:21:41 72883 8192000000 10865551968 11337850880 1907051744 18.883 99 23 42 1 1925427904 12063856 6312304
16:23:06 45643 8192000000 10863896688 11330605056 1881874160 18.680 97 24 48 1 1900603104 11889360 6839584
16:23:59 58581 8192000000 10851683856 11327385600 1865377568 18.547 96 30 60 0 1889613232 15321584 8914080
16:25:04 55457 8192000000 10864440528 11327426560 1911333712 18.917 99 19 38 1 1928744944 12353232 5058000
16:26:06 23273 8192000000 10893967152 11350290432 1927621760 19.048 99 33 66 0 1951243600 14500032 9121808
16:26:41 60847 8192000000 9362549840 9651126272 484521808 5.584 26 3 6 0 489497072 4371616 603648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 20-03-2021 16:28:30 to 20-03-2021 16:29:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 98 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-03-2021 16:29:02 to 20-03-2021 16:29:04.

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          238697
MON$OLDEST_ACTIVE               238698
MON$OLDEST_SNAPSHOT             238698
MON$NEXT_TRANSACTION            238698
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                       2047200
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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'

20.03.21 16:29:05. 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-03-20 16:29:07 No severe PSQL-related problems occured
20.03.21 16:29:09. End of report.