Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.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 17175920 kB
MemAvailable 31428344 kB
Buffers 0 kB
Cached 14538608 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-06 16:27:11
DTS_END                         2021-01-06 16:27:11.0490
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42472
TRN_ID                          236691
ATT_ID                          637
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: 9575.87 25667 1149104
customer order: creation 169.05 377 20286
customer order: refuse 14.10 335 1692
order to supplier: creation 44.38 1294 5326
order to supplier: removal 3.42 113033 410
invoice (draft): creation 46.58 3133 5590
invoice (draft): removal 56.63 756 6795
invoice accept: apply 40.82 16432 4898
invoice accept: cancel 50.92 730 6110
customer reserve: creation 3879.12 157 465494
customer reserve: removal 4968.43 61 596211
realization accept: apply 83.62 209 10034
realization accept: cancel 88.83 127 10660
payment from customer: creation 59.43 142 7131
payment from customer: removal 5.43 96 652
payment to supplier: creation 49.63 156 5956
payment to supplier: removal 3.55 71 426
service: total inventory turnovers 4.53 1159 543
service: total monetary turnovers 6.53 34 784
service: aggregate perf. data 0.85 19823 102
service: refresh index statistics 0.03 355220 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-01-2021 16:28:46 to 06-01-2021 16:28:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5314
TEST_TIME 2 2824
TEST_TIME 3 2758
TEST_TIME 4 3441
TEST_TIME 5 4158
TEST_TIME 6 4444
TEST_TIME 7 4916
TEST_TIME 8 5275
TEST_TIME 9 5425
TEST_TIME 10 5673
TEST_TIME 11 5676
TEST_TIME 12 6449
TEST_TIME 13 6611
TEST_TIME 14 7045
TEST_TIME 15 7080
TEST_TIME 16 7599
TEST_TIME 17 7633
TEST_TIME 18 7904
TEST_TIME 19 8051
TEST_TIME 20 8442
TEST_TIME 21 8584
TEST_TIME 22 8942
TEST_TIME 23 8746
TEST_TIME 24 9117
TEST_TIME 25 8912
TEST_TIME 26 9002
TEST_TIME 27 9189
TEST_TIME 28 10994
TEST_TIME 29 11365
TEST_TIME 30 11167
TEST_TIME 31 10995
TEST_TIME 32 10914
TEST_TIME 33 10818
TEST_TIME 34 10679
TEST_TIME 35 10390
TEST_TIME 36 10474
TEST_TIME 37 10440
TEST_TIME 38 10412
TEST_TIME 39 10481
TEST_TIME 40 10265
TEST_TIME 41 10228
TEST_TIME 42 10173
TEST_TIME 43 10241
TEST_TIME 44 10273
TEST_TIME 45 10219
TEST_TIME 46 10149
TEST_TIME 47 10066
TEST_TIME 48 9941
TEST_TIME 49 9971
TEST_TIME 50 9956
TEST_TIME 51 9896
TEST_TIME 52 9783
TEST_TIME 53 9900
TEST_TIME 54 9911
TEST_TIME 55 9972
TEST_TIME 56 10008
TEST_TIME 57 9977
TEST_TIME 58 9915
TEST_TIME 59 9983
TEST_TIME 60 10117
TEST_TIME 61 10131
TEST_TIME 62 10154
TEST_TIME 63 10295
TEST_TIME 64 10359
TEST_TIME 65 10307
TEST_TIME 66 10283
TEST_TIME 67 10135
TEST_TIME 68 10113
TEST_TIME 69 10132
TEST_TIME 70 10106
TEST_TIME 71 10053
TEST_TIME 72 10019
TEST_TIME 73 9998
TEST_TIME 74 9935
TEST_TIME 75 9901
TEST_TIME 76 9865
TEST_TIME 77 9875
TEST_TIME 78 9910
TEST_TIME 79 9861
TEST_TIME 80 9842
TEST_TIME 81 9844
TEST_TIME 82 9884
TEST_TIME 83 9866
TEST_TIME 84 9908
TEST_TIME 85 9888
TEST_TIME 86 9958
TEST_TIME 87 9942
TEST_TIME 88 9995
TEST_TIME 89 10023
TEST_TIME 90 9956
TEST_TIME 91 9895
TEST_TIME 92 9864
TEST_TIME 93 9845
TEST_TIME 94 9814
TEST_TIME 95 9772
TEST_TIME 96 9764
TEST_TIME 97 9756
TEST_TIME 98 9751
TEST_TIME 99 9732
TEST_TIME 100 9757
TEST_TIME 101 9723
TEST_TIME 102 9826
TEST_TIME 103 9819
TEST_TIME 104 9792
TEST_TIME 105 9830
TEST_TIME 106 9852
TEST_TIME 107 9924
TEST_TIME 108 9911
TEST_TIME 109 9948
TEST_TIME 110 9892
TEST_TIME 111 9849
TEST_TIME 112 9805
TEST_TIME 113 9760
TEST_TIME 114 9783
TEST_TIME 115 9771
TEST_TIME 116 9719
TEST_TIME 117 9684
TEST_TIME 118 9632
TEST_TIME 119 9653
TEST_TIME 120 9583

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 06-01-2021 16:28:49 to 06-01-2021 16:28:53.

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 1578621 1578621 0 0.00 0 24570 6 0 0
doc_list_biud 1578621 1578621 0 0.00 0 68903 29 0 0
sp_add_invoice_to_stock 5035 4898 137 2.72 29 182176 16432 0 137
sp_cancel_adding_invoice 6110 6110 0 0.00 5 59962 731 0 0
sp_cancel_client_order 1692 1692 0 0.00 5 11526 336 0 0
sp_cancel_customer_reserve 596211 596211 0 0.00 1 68905 62 0 0
sp_cancel_pay_from_customer 652 652 0 0.00 3 11375 97 0 0
sp_cancel_pay_to_supplier 426 426 0 0.00 3 7390 71 0 0
sp_cancel_supplier_invoice 6805 6795 10 0.14 2 25039 757 0 10
sp_cancel_supplier_order 410 410 0 0.00 10 1127408 113034 0 0
sp_cancel_write_off 10660 10660 0 0.00 1 34595 127 0 0
sp_client_order 20286 20286 0 0.00 3 48963 378 0 0
sp_customer_reserve 465494 465494 0 0.00 0 94057 157 0 0
sp_fill_shopping_cart 31196 31196 0 0.00 1 10492 32 0 0
sp_fill_shopping_cart_clo_res 465489 465489 0 0.00 0 26127 15 0 0
sp_get_clo_for_invoice 4889 4889 0 0.00 0 40589 296 0 0
sp_kill_cost_storno 17848 17848 0 0.00 0 11365 58 0 0
sp_kill_qstorno_ret_qs2qd 1210287 1210287 0 0.00 0 68901 33 0 0
sp_kill_qty_storno 636801 636801 0 0.00 0 68903 72 0 0
sp_lock_selected_doc 20588 20588 0 0.00 0 8800 5 0 0
sp_make_cost_storno 28010 28010 0 0.00 0 24567 63 0 0
sp_multiply_rows_for_pdistr 28010 28010 0 0.00 0 24470 37 0 0
sp_multiply_rows_for_qdistr 20286 20286 0 0.00 0 48927 180 0 0
sp_pay_from_customer 7131 7131 0 0.00 4 17975 142 0 0
sp_pay_to_supplier 5956 5956 0 0.00 5 24576 157 0 0
sp_payment_common 13087 13087 0 0.00 1 11450 45 0 0
sp_qd_handle_on_cancel_clo 1692 1692 0 0.00 0 11517 309 0 0
sp_qd_handle_on_invoice_upd_sts 10999 10999 0 0.00 0 23598 333 0 0
sp_qd_handle_on_reserve_upd_sts 10034 10034 0 0.00 0 16653 74 0 0
sp_reserve_write_off 10034 10034 0 0.00 6 18077 210 0 0
sp_supplier_invoice 5590 5590 0 0.00 6 76730 3134 0 0
sp_supplier_order 5326 5326 0 0.00 6 30397 1295 0 0
srv_aggregate_perf_data 102 102 0 0.00 2602 220440 19823 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1139 176703 33315 0 0
srv_find_qd_qs_mism 1100632 1100632 0 0.00 0 23503 4 0 0
srv_make_invnt_saldo 543 543 0 0.00 27 89706 1160 0 0
srv_make_money_saldo 784 784 0 0.00 1 5173 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 197949 522952 355220 0 0
t$perf-abend:sp_add_invoice_to_stock 137 137 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4899 4899 0 0.00 0 24874 169 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 1 1678 62 0 0
t$perf-norm:sp_cancel_client_order 1692 1692 0 0.00 0 9283 16 0 0
t$perf-norm:sp_cancel_customer_reserve 686 686 0 0.00 0 753 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 652 652 0 0.00 0 1196 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 426 426 0 0.00 0 2998 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 393 393 0 0.00 0 395 8 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 21913 1843 0 0
t$perf-norm:sp_cancel_write_off 997 997 0 0.00 0 3644 9 0 0
t$perf-norm:sp_client_order 20286 20286 0 0.00 0 13063 17 0 0
t$perf-norm:sp_customer_reserve 1006 1006 0 0.00 0 184 2 0 0
t$perf-norm:sp_pay_from_customer 7131 7131 0 0.00 0 12314 8 0 0
t$perf-norm:sp_pay_to_supplier 5956 5956 0 0.00 0 10055 11 0 0
t$perf-norm:sp_reserve_write_off 10034 10034 0 0.00 0 7463 11 0 0
t$perf-norm:sp_supplier_invoice 5590 5590 0 0.00 0 13682 20 0 0
t$perf-norm:sp_supplier_order 5326 5326 0 0.00 0 10884 18 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 247 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 2061 37 0 0
t$perf-norm:srv_make_invnt_saldo 543 543 0 0.00 0 1681 19 0 0
t$perf-norm:srv_make_money_saldo 784 784 0 0.00 0 2593 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10052 9778 274 2.72 0 20154 22 0 274
v_all_customers 37412 37412 0 0.00 0 19 1 0 0
v_all_suppliers 30778 30778 0 0.00 0 25 1 0 0
v_all_wares 40570 40570 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 10256 25 0 0
v_cancel_client_order 3384 3384 0 0.00 0 10750 7 0 0
v_cancel_customer_prepayment 1304 1304 0 0.00 0 10714 14 0 0
v_cancel_customer_reserve 1372 1372 0 0.00 0 1406 4 0 0
v_cancel_payment_to_supplier 852 852 0 0.00 0 1927 6 0 0
v_cancel_supplier_invoice 806 786 20 2.48 0 20770 57 0 20
v_cancel_supplier_order 820 820 0 0.00 0 5455 20 0 0
v_cancel_write_off 1994 1994 0 0.00 0 15139 19 0 0
v_max_id_clo_ord 5324 5324 0 0.00 0 1379 1 0 0
v_max_id_clo_res 1006 1006 0 0.00 0 2202 11 0 0
v_max_id_ord_sup 5587 5587 0 0.00 0 3284 4 0 0
v_max_non_paid_invoice 1478 1478 0 0.00 0 185 2 0 0
v_max_non_paid_realizn 3613 3613 0 0.00 0 9309 9 0 0
v_min_id_clo_ord 5324 5324 0 0.00 0 7416 9 0 0
v_min_id_clo_res 1006 1006 0 0.00 0 4560 14 0 0
v_min_id_ord_sup 5587 5587 0 0.00 0 4499 5 0 0
v_min_non_paid_invoice 5956 5956 0 0.00 0 11447 34 0 0
v_min_non_paid_realizn 7131 7131 0 0.00 0 11383 33 0 0
v_our_firm 10194 10194 0 0.00 0 19 1 0 0
v_reserve_write_off 20068 20068 0 0.00 0 17943 9 0 0
x_lock_depdocs_on_canc_invoice 12512 12512 0 0.00 0 9685 101 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 9026 330 0 0
x_make_qstorno_1000_1200 5326 5326 0 0.00 1 30367 1222 0 0
x_make_qstorno_1200_2000 5590 5590 0 0.00 3 76711 3023 0 0
x_make_qstorno_2100_3300 465493 465493 0 0.00 0 94055 140 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-01-2021 16:28:54 to 06-01-2021 16:28:58.

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 8216 8192000000 10162681280 10458419200 814833040 9.046 65 53 107 0 834118880 2164896 17120944
13:57:37 26624 8192000000 10327459360 10640695296 1361338816 14.249 100 81 162 0 1392603056 4492000 26772240
13:58:21 20683 8192000000 10364493264 10684502016 1411192112 14.695 100 89 178 1 1447428784 6623648 29613024
13:58:51 26039 8192000000 10399545888 10724036608 1434192992 14.898 100 87 175 1 1470012944 7353568 28466384
13:59:26 19349 8192000000 10407453744 10737922048 1464074704 15.162 100 87 174 1 1500945568 8368304 28502560
13:59:58 20506 8192000000 10433193936 10762924032 1483497120 15.332 100 84 168 1 1519650496 8935648 27217728
14:00:27 11538 8192000000 10450705312 10788077568 1499860640 15.475 100 88 176 1 1537106592 9230752 28015200
14:00:50 8385 8192000000 10460963440 10799345664 1520105504 15.651 100 90 180 0 1558555952 9723200 28727248
14:01:09 14105 8192000000 10490086176 10833580032 1546812688 15.882 100 89 178 0 1584764320 10133184 27818448
14:01:32 16677 8192000000 10499147376 10846691328 1560313248 15.999 100 83 166 0 1595935408 10304688 25317472
14:02:02 16060 8192000000 10521607008 10875691008 1579590976 16.165 100 76 152 0 1612653664 9830848 23231840
14:02:28 12917 8192000000 10561329264 10919313408 1623106496 16.536 100 84 168 1 1660054464 10652464 26295504
14:02:51 13845 8192000000 10581840480 10940989440 1634239840 16.631 100 85 168 1 1671301376 11107744 25953792
14:03:13 8645 8192000000 10592842640 10953543680 1653721360 16.796 100 78 156 0 1688648688 11493008 23434320
14:03:29 10595 8192000000 10616530512 10981449728 1674795200 16.974 100 76 152 1 1709372144 12281376 22295568
14:03:48 10102 8192000000 10630599360 10996928512 1688027952 17.085 100 82 164 1 1725043936 12989296 24026688
14:04:06 9730 8192000000 10649972896 11019444224 1701913536 17.201 100 80 160 1 1738802800 13399376 23489888
14:04:23 9418 8192000000 10661612336 11035840512 1721207312 17.362 100 83 167 0 1758947536 13443840 24296384
14:04:44 5863 8192000000 10677227200 11051962368 1737029536 17.494 100 81 161 0 1773745792 14019200 22697056
14:04:57 5212 8192000000 10687130864 11060383744 1743559200 17.548 100 80 159 0 1780299392 14002176 22738016
14:05:09 4958 8192000000 10687277824 11066257408 1751583664 17.615 100 86 172 0 1789279312 13683712 24011936
14:05:22 3950 8192000000 10700441968 11077410816 1760884960 17.692 100 85 170 1 1798681040 14106304 23689776
14:05:33 4107 8192000000 10720668128 11094458368 1773688016 17.797 100 90 177 1 1812197872 13674336 24835520
14:05:44 2676 8192000000 10723627200 11103649792 1779844928 17.848 100 83 167 1 1816853760 13514960 23493872
14:05:53 2658 8192000000 10730298320 11114209280 1789290256 17.926 100 83 166 0 1826567552 13169472 24107824
14:06:03 2564 8192000000 10738941728 11121651712 1799877696 18.013 100 87 176 0 1837684304 13131024 24675584
14:06:12 3338 8192000000 10744879632 11130568704 1805286048 18.057 100 84 169 0 1843102416 14410800 23405568
14:06:22 3047 8192000000 10744203216 11128913920 1809066976 18.088 100 88 170 3 1846282416 14010080 23205360
14:06:31 3053 8192000000 10754819104 11137429504 1814813184 18.135 100 87 174 1 1852528272 13536624 24178464
14:06:48 5039 8192000000 10762680736 11149713408 1819449904 18.173 100 87 175 1 1857909648 13775440 24684304
14:07:00 1743 8192000000 10777992016 11161858048 1835137408 18.301 100 89 177 2 1873176048 13552832 24485808
14:07:09 1498 8192000000 10790532464 11171061760 1843428512 18.369 100 94 189 1 1884395696 13783360 27183824
14:07:17 2060 8192000000 10785704576 11172122624 1842564176 18.362 100 94 188 1 1882076576 13044976 26467424
14:07:25 2511 8192000000 10783874768 11176140800 1846704496 18.395 100 91 182 1 1885328592 12342096 26282000
14:07:34 2282 8192000000 10796199392 11183464448 1852858144 18.445 100 88 176 3 1889382704 11755808 24768752
14:07:43 1267 8192000000 10806654896 11192492032 1862232000 18.521 100 94 187 0 1901581008 12646528 26702480
14:07:50 1263 8192000000 10810886208 11195457536 1863277776 18.530 100 97 196 1 1904095808 13565264 27252768
14:07:58 1263 8192000000 10810105616 11196801024 1866525600 18.556 100 94 188 2 1905969184 13011968 26431616
14:08:06 1886 8192000000 10814703632 11206172672 1872431792 18.604 100 94 188 1 1912436944 12509856 27495296
14:08:14 1702 8192000000 10817458272 11206422528 1873190928 18.610 100 89 178 1 1910816224 11697632 25927664
14:08:22 40503 8192000000 10806728144 11209490432 1873450816 18.612 100 66 132 0 1901268272 8345616 19471840
14:09:09 2574 8192000000 10794038656 11210792960 1871784992 18.599 100 54 110 0 1896866096 9977904 15103200
14:09:17 8269 8192000000 10787492752 11208060928 1871870352 18.599 100 47 95 0 1895060144 10455328 12734464
14:09:35 7870 8192000000 10786666240 11207495680 1870649344 18.590 100 32 64 1 1887307632 7309392 9348896
14:09:51 4460 8192000000 10787910928 11213819904 1874858224 18.624 100 31 62 1 1891292480 7362752 9071504
14:10:03 8324 8192000000 10782834672 11211993088 1873380576 18.612 100 22 43 0 1886146208 6806240 5959392
14:10:20 4711 8192000000 10786104864 11214524416 1875966768 18.633 100 21 43 1 1888098960 6253696 5878496
14:10:31 11162 8192000000 10796449152 11220750336 1876948784 18.640 100 19 39 1 1888139424 6083920 5106720
14:10:51 9702 8192000000 10780976144 11215978496 1879585488 18.662 100 11 22 1 1888543216 5913040 3044688
14:11:08 8162 8192000000 10793432432 11222712320 1882251584 18.683 100 22 44 2 1895134784 6532480 6350720
14:11:29 12105 8192000000 10784545728 11224223744 1882360688 18.684 100 7 14 0 1889728928 5486864 1881376
14:11:48 6542 8192000000 10795608400 11231342592 1887546864 18.726 100 15 31 2 1901481056 9870320 4063872
14:12:02 10833 8192000000 10796785392 11234426880 1887694048 18.727 100 13 26 1 1901556064 10201168 3660848
14:12:27 9920 8192000000 10795654080 11231047680 1889911536 18.745 100 16 32 1 1900692496 6220992 4559968
14:12:48 5546 8192000000 10825324176 11245740032 1906530576 18.879 100 56 110 1 1927935040 5770656 15633808
14:13:01 67405 8192000000 10840770720 11256692736 1903981392 18.858 100 31 62 1 1918814912 5476880 9356640
14:14:14 8175 8192000000 10812476064 11251441664 1901493072 18.838 100 19 38 1 1913977248 7269888 5214288
14:14:33 5737 8192000000 10817765488 11257323520 1903823104 18.857 100 19 38 0 1915586336 6572016 5191216
14:14:49 6059 8192000000 10824723712 11254509568 1885917120 18.713 99 21 42 1 1897887344 5761024 6209200
14:15:02 6673 8192000000 10819615424 11252097024 1902899168 18.850 100 27 54 1 1916883712 6003712 7980832
14:15:15 6906 8192000000 10825471184 11257995264 1908218064 18.892 100 44 88 1 1928222768 7181184 12823520
14:15:30 5856 8192000000 10818756784 11253043200 1906756512 18.881 100 24 48 3 1919377440 5621632 6999296
14:15:43 5728 8192000000 10816317008 11253596160 1906689424 18.880 100 28 56 2 1920377232 5273040 8414768
14:15:58 8979 8192000000 10819094352 11254370304 1888871456 18.737 99 28 56 1 1902914368 6229952 7812960
14:16:13 8375 8192000000 10801003072 11240255488 1865714016 18.550 98 18 36 1 1876981328 6060032 5207280
14:16:28 7275 8192000000 10805213536 11245568000 1897498176 18.806 100 20 38 1 1909006752 5775792 5732784
14:16:47 7848 8192000000 10802312784 11236515840 1872986272 18.608 99 18 36 2 1883494016 4877632 5630112
14:17:05 12767 8192000000 10792899328 11231526912 1854741472 18.461 98 18 37 0 1865468832 5821968 4905392
14:17:24 23774 8192000000 10758966176 11176046592 1721751504 17.367 91 19 38 1 1732338320 4669920 5916896
14:17:54 45483 8192000000 10779324000 11174068224 1759319984 17.679 95 34 68 1 1775179312 5272256 10587072
14:18:49 11717 8192000000 10725050592 11155988480 1766989840 17.742 96 18 36 0 1777572064 5440304 5141920
14:19:15 6165 8192000000 10730079728 11145465856 1767712784 17.748 97 17 34 1 1778333296 5120224 5500288
14:19:29 4080 8192000000 10749919728 11165208576 1827226928 18.237 100 44 87 1 1847064336 8126704 11710704
14:19:40 8304 8192000000 10743560144 11159601152 1794294336 17.967 98 37 74 0 1811643648 6922416 10426896
14:19:57 6404 8192000000 10699973584 11123113984 1752624192 17.623 97 25 50 1 1765786400 5896752 7265456
14:20:12 10130 8192000000 10691128160 11104382976 1730546064 17.440 96 14 27 1 1739902976 5736128 3620784
14:20:28 5291 8192000000 10728374816 11134119936 1790070768 17.932 100 15 30 2 1800421968 5280448 5070752
14:20:41 7262 8192000000 10680677232 11097374720 1717770544 17.334 96 10 20 2 1726050432 5534992 2744896
14:20:55 5854 8192000000 10706238880 11120750592 1774905952 17.807 99 34 68 2 1791345568 5797344 10642272
14:21:09 8362 8192000000 10699482112 11115094016 1734947904 17.477 97 20 40 1 1746292912 5335104 6009904
14:21:24 9501 8192000000 10689834304 11107819520 1760651456 17.690 99 13 26 2 1770045696 5512224 3882016
14:21:40 9221 8192000000 10688403120 11110555648 1740552672 17.523 97 20 40 1 1751982704 5375808 6054224
14:22:00 14322 8192000000 10736664336 11155742720 1811512864 18.108 100 19 38 0 1822569488 5516608 5540016
14:22:21 15870 8192000000 10751799040 11171753984 1837908496 18.324 100 37 74 1 1853805616 5163904 10733216
14:22:43 67287 8192000000 10749555904 11171164160 1823911584 18.210 99 41 82 3 1842500592 5156592 13432416
14:23:58 15482 8192000000 10748941616 11179737088 1827556192 18.239 99 25 49 3 1841181936 6213200 7412544
14:24:24 6640 8192000000 10769539600 11192107008 1849381568 18.417 100 39 77 2 1868285792 7814848 11089376
14:24:37 5899 8192000000 10762188880 11187990528 1850376048 18.425 100 26 52 2 1864343920 6079408 7888464
14:24:49 7490 8192000000 10769851456 11192586240 1834313360 18.294 99 31 63 1 1850228016 7437728 8476928
14:25:03 8557 8192000000 10765203392 11198001152 1856763520 18.477 100 37 73 2 1874549120 7190928 10594672
14:25:23 6982 8192000000 10776860080 11204042752 1863165024 18.529 100 31 62 1 1877549072 5025280 9358768
14:25:37 6431 8192000000 10792019616 11212279808 1868100192 18.569 100 34 68 2 1884728944 7447808 9180944
14:25:54 12361 8192000000 10781667360 11215060992 1870284128 18.587 100 17 33 1 1880900688 5538576 5077984
14:26:13 7846 8192000000 10792135488 11218309120 1870885184 18.591 100 15 28 1 1880586624 5492688 4208752
14:26:28 9538 8192000000 10793069776 11223961600 1875577424 18.629 100 15 30 0 1885157216 5264352 4315440
14:26:46 15428 8192000000 10795802480 11227373568 1883420512 18.693 100 28 56 0 1897070784 5000112 8650160
14:27:07 38113 8192000000 10834200944 11258208256 1897764912 18.808 100 14 28 0 1910667744 9542000 3360832
14:27:56 24411 8192000000 10843420592 11273347072 1926407392 19.038 100 42 84 1 1945711728 6662128 12642208
14:28:34 21334 8192000000 10870418624 11291750400 1938006192 19.131 100 38 74 2 1959902208 10649936 11246080
14:29:19 116044 8192000000 10880764384 11315220480 1945845088 19.193 100 39 78 0 1975406160 17925072 11636000
14:31:26 16325 8192000000 10889014560 11321765888 1950622688 19.231 100 37 74 3 1981290816 20164208 10503920
14:31:55 12262 8192000000 10895694256 11327225856 1954052320 19.259 100 37 72 1 1986582592 22194880 10335392
14:32:21 19024 8192000000 10904973248 11341959168 1960613152 19.311 100 39 77 2 1993080688 21539008 10928528
14:32:55 7967 8192000000 10905595472 11338932224 1965570640 19.350 100 41 80 1 1998574608 21495360 11508608
14:33:10 16310 8192000000 10919536128 11351101440 1970380032 19.388 100 47 94 0 2006325680 21693088 14252560
14:33:43 24056 8192000000 10924940112 11357741056 1977237984 19.443 100 42 84 0 2013789904 23272112 13279808
14:34:15 11905 8192000000 10936466528 11370827776 1984641264 19.501 100 49 97 0 2023564160 25030944 13891952
14:34:34 21312 8192000000 10937989200 11378835456 1990047024 19.544 100 47 94 3 2030855520 26459376 14349120
14:35:05 12110 8192000000 10957367184 11385552896 1994908064 19.583 100 51 102 2 2034901280 24705920 15287296
14:35:25 5226 8192000000 10961436528 11389702144 2003087840 19.647 100 62 122 1 2048942784 27234576 18620368
14:35:38 2611 8192000000 10955223200 11385364480 1996926112 19.598 100 63 125 1 2041433200 26110288 18396800
14:35:48 5366 8192000000 10955619392 11387854848 1999489696 19.619 100 55 111 1 2041631600 25935584 16206320
14:36:03 9332 8192000000 10949085488 11381800960 1993356800 19.570 100 53 105 1 2034846176 25690432 15798944
14:36:19 4017 8192000000 10971054160 11392454656 2003728464 19.652 100 74 148 0 2052841248 27144912 21967872
14:36:30 5511 8192000000 10980184832 11402534912 2009720496 19.699 100 72 141 3 2060059712 29209552 21129664
14:36:50 5040 8192000000 10977203104 11400536064 2009810512 19.700 100 66 131 3 2057498176 28349872 19337792
14:37:04 3133 8192000000 10971624016 11403157504 2009669952 19.699 100 56 111 0 2054006448 27889856 16446640
14:37:14 4141 8192000000 10963791840 11397271552 2007706928 19.683 100 61 122 0 2054953312 28733920 18512464
14:37:26 5115 8192000000 10974975232 11404206080 2013038208 19.725 100 79 160 3 2066361392 28113584 25209600
14:37:38 10644 8192000000 10973966112 11406602240 2015965408 19.748 100 67 130 3 2067169776 31647008 19557360
14:38:15 4227 8192000000 10986534624 11412967424 2015373632 19.744 100 63 126 0 2068164640 32952336 19838672
14:38:26 12658 8192000000 10973994272 11399159808 1980394960 19.468 98 64 126 1 2032969088 32594480 19979648
14:38:48 5353 8192000000 10986064496 11414626304 2011142256 19.711 100 72 143 1 2067958400 35929552 20886592
14:39:02 5978 8192000000 10988918384 11421491200 2016027744 19.749 100 66 132 0 2072495712 36631600 19836368
14:39:17 6175 8192000000 10985523104 11413929984 2004421248 19.658 99 76 152 0 2066443984 39315824 22706912
14:39:32 4192 8192000000 10991066080 11419049984 2019598880 19.777 100 79 154 0 2077267584 34257104 23411600
14:39:43 7975 8192000000 10989578544 11427373056 2019827968 19.779 100 58 116 0 2074463888 36570304 18065616
14:39:58 3980 8192000000 10993088944 11425222656 2024059520 19.812 100 61 122 0 2075776032 31996336 19720176
14:40:09 10689 8192000000 10993055200 11434029056 2029039792 19.851 100 60 120 2 2081886928 33833392 19013744
14:40:27 5849 8192000000 11006074288 11437350912 2028669472 19.848 100 63 126 2 2084357584 35782736 19905376
14:40:40 5558 8192000000 11012745616 11445727232 2037118368 19.914 100 72 144 2 2095077920 35691728 22267824
14:40:52 1588 8192000000 11026002528 11451940864 2045458800 19.980 100 82 164 1 2109626560 38493040 25674720
14:41:01 2300 8192000000 11012158064 11431907328 2003349232 19.649 98 83 166 1 2069015072 39496816 26169024
14:41:10 1815 8192000000 11011264688 11431178240 2014838416 19.740 99 83 166 0 2079233504 38512512 25882576
14:41:19 2487 8192000000 11000092544 11416760320 2011522592 19.714 99 90 179 2 2078852640 39899776 27430272
14:41:29 5696 8192000000 11015494880 11435470848 2024266560 19.814 100 79 158 3 2089464864 41018800 24179504
14:41:42 4264 8192000000 11005017376 11437654016 2007344176 19.681 99 73 145 0 2066816384 37148848 22323360
14:41:55 5892 8192000000 10988629776 11418755072 2003682400 19.652 99 67 134 3 2061400176 37250800 20466976
14:42:11 3868 8192000000 11002342416 11430617088 2026144160 19.828 100 83 167 0 2092049680 40954448 24951072
14:42:22 2169 8192000000 11000657632 11420471296 1987530656 19.524 98 66 131 1 2049566832 41028032 21008144
14:42:33 2225 8192000000 11004968544 11427549184 2015595216 19.746 100 79 150 2 2082185376 42569280 24020880
14:42:43 5477 8192000000 10999519040 11419992064 2009145504 19.695 100 76 151 0 2077886608 45069248 23671856
14:42:58 3992 8192000000 11000434576 11425775616 2000161344 19.624 99 81 162 1 2071700864 46200896 25338624
14:43:11 3592 8192000000 10997608528 11424534528 1996635232 19.596 99 68 136 1 2064568480 47172224 20761024
14:43:22 2346 8192000000 11016109904 11433979904 2019410944 19.776 100 82 163 0 2089989744 45331968 25246832
14:43:31 1795 8192000000 11005952176 11420565504 1997257216 19.601 99 90 178 1 2066154320 40847104 28050000
14:43:39 3583 8192000000 10977419488 11409485824 1989798096 19.542 99 71 142 1 2054647712 42231696 22617920
14:43:51 5314 8192000000 10972512272 11397214208 1992804608 19.566 100 71 142 0 2056809728 41628352 22376768
14:44:03 6162 8192000000 10962810480 11391287296 1958481280 19.294 98 62 124 0 2020856416 42200656 20174480
14:44:17 5556 8192000000 10937320352 11365007360 1951802720 19.241 99 68 138 1 2016212512 43104224 21305568
14:44:31 9926 8192000000 10955566944 11377442816 1942757056 19.169 98 68 134 0 2008400176 43881536 21761584
14:44:49 3304 8192000000 10948313472 11367759872 1936042912 19.115 98 80 159 1 2005940896 44758672 25139312
14:45:00 4471 8192000000 10960788576 11381145600 1976044640 19.433 100 77 154 0 2044400640 42893280 25462720
14:45:13 1858 8192000000 10966725136 11380404224 1974892800 19.424 100 80 158 0 2042170320 42282592 24994928
14:45:22 3055 8192000000 10960259440 11379507200 1959744560 19.304 99 67 134 1 2024434416 43790608 20899248
14:45:33 1137 8192000000 10967968800 11378733056 1968287568 19.372 99 86 171 1 2039600688 44235712 27077408
14:45:40 4072 8192000000 10947212720 11361132544 1946336336 19.197 99 76 153 1 2014855744 44359792 24159616
14:45:51 1890 8192000000 10974761792 11379077120 1974129360 19.418 100 88 177 0 2046438784 44925504 27383920
14:45:59 2479 8192000000 10965130800 11378716672 1974261536 19.419 100 79 157 1 2043449168 45290208 23897424
14:46:10 2409 8192000000 10970820800 11390439424 1983159568 19.490 100 73 146 0 2053200688 47326768 22714352
14:46:21 18770 8192000000 10951932544 11391950848 1979720192 19.462 100 36 72 0 2035583392 42939728 12923472
14:46:48 6429 8192000000 10945987344 11379236864 1942774912 19.169 98 50 100 0 2004599616 45255472 16569232
14:47:04 15002 8192000000 10944499552 11370668032 1912305568 18.925 97 48 96 0 1976992384 48493072 16193744
14:47:27 21203 8192000000 10932273184 11372306432 1942291024 19.165 99 39 78 0 2006370960 50533568 13546368
14:48:07 10210 8192000000 10938240448 11372052480 1939764928 19.145 99 40 80 1 1998533520 45697808 13070784
14:48:24 5156 8192000000 10943213744 11374931968 1962328320 19.325 100 49 98 0 2027136560 48396416 16411824
14:48:42 11249 8192000000 10927278560 11362254848 1940461328 19.150 99 41 82 3 1996878912 42976208 13441376
14:49:09 9207 8192000000 10937166192 11377770496 1959070080 19.299 100 35 68 2 2013542864 42708800 11763984
14:49:34 8180 8192000000 10933853744 11358175232 1922041184 19.003 98 44 89 2 1982508320 45864032 14603104
14:49:48 9072 8192000000 10930270160 11379023872 1955313040 19.269 100 37 74 0 2020480000 53219888 11947072
14:50:23 12529 8192000000 10945353328 11384127488 1969565744 19.382 100 32 64 1 2020814672 40841632 10407296
14:50:42 13417 8192000000 10951949008 11393089536 1977494832 19.445 100 40 80 0 2034848176 43975584 13377760
14:51:21 24608 8192000000 10949605648 11408470016 1976258624 19.435 100 31 62 2 2036188704 49361264 10568816
14:51:53 14892 8192000000 10939317648 11395731456 1952220640 19.244 99 25 50 1 2007311520 46373600 8717280
14:52:28 25817 8192000000 10944836912 11394314240 1967724656 19.367 100 25 50 3 2027549136 50826800 8997680
14:53:04 10957 8192000000 10942265424 11386617856 1960726736 19.312 100 34 68 0 2022364528 49279888 12357904
14:53:22 16895 8192000000 10950229712 11400273920 1963811664 19.336 100 32 64 2 2032726560 57160464 11754432
14:53:46 10310 8192000000 10966326800 11420348416 1971083664 19.394 100 31 63 0 2042303616 59739424 11480528
14:54:02 6907 8192000000 10960231216 11412787200 1967991952 19.370 100 39 77 3 2039242304 57865120 13385232
14:54:21 14022 8192000000 10966285904 11418578944 1968919104 19.377 100 33 65 3 2049845344 68811264 12114976
14:54:54 9559 8192000000 10964956736 11437051904 1963919808 19.337 100 25 50 0 2042233680 68503088 9810784
14:55:31 38344 8192000000 10909770928 11384467456 1961583600 19.319 100 9 18 1 1987470000 23298768 2587632
14:56:45 94558 8192000000 10887664752 11325718528 1837536704 18.321 94 25 48 3 1858728336 15312272 5879360
14:58:29 82691 8192000000 10836022672 11282407424 1773471664 17.796 91 33 66 1 1789840880 7424192 8945024
15:00:11 97569 8192000000 10854568224 11314237440 1862829328 18.526 97 10 20 0 1875750160 10382656 2538176
15:02:57 39404 8192000000 10858374336 11309273088 1918709984 18.977 99 35 69 2 1941432304 12910848 9811472
15:04:01 87526 8192000000 10888557984 11338149888 1930220336 19.069 99 20 40 0 1947716496 11510048 5986112
15:05:39 161712 8192000000 10889935088 11347021824 1936669296 19.120 99 32 64 0 1963743408 17250016 9824096
15:08:27 78749 8192000000 10885041584 11356573696 1945435232 19.190 99 15 30 1 1961041920 10987504 4619184
15:10:03 38646 8192000000 10910545408 11345362944 1903895632 18.858 97 44 87 1 1928174960 11551536 12727792
15:10:49 40142 8192000000 10881525232 11348008960 1949327392 19.221 100 22 44 1 1972071952 16138256 6606304
15:12:00 33424 8192000000 10896235376 11363770368 1969677936 19.383 100 21 40 2 1984472416 9383424 5411056
15:12:40 37490 8192000000 10894966080 11370430464 1973873744 19.416 100 12 24 1 1987774768 9820400 4080624
15:13:43 54493 8192000000 10892083344 11367231488 1958089472 19.291 99 15 28 1 1971385648 9153664 4142512
15:15:20 41227 8192000000 10919766832 11386777600 1986734720 19.518 100 25 50 1 2009533152 15196816 7601616
15:16:15 51873 8192000000 10907929056 11391401984 1987314064 19.523 100 17 34 0 2004715344 12561488 4839792
15:17:17 58033 8192000000 10911699680 11387154432 1983011088 19.489 100 11 22 0 1993651392 8173440 2466864
15:18:23 43070 8192000000 10923167232 11402481664 1996750224 19.597 100 28 56 3 2021978432 17152720 8075488
15:19:16 65665 8192000000 10925926080 11406143488 1977976800 19.449 99 19 38 1 2005475248 21997936 5500512
15:20:50 51483 8192000000 10916624096 11407073280 1983485568 19.492 100 4 8 0 2002344704 17942240 916896
15:21:57 42633 8192000000 10921432128 11401564160 1977644080 19.446 99 14 28 1 1993510832 12144416 3722336
15:22:46 84307 8192000000 10924764048 11394617344 1962174864 19.323 98 12 24 0 1977572000 11800112 3597024
15:24:18 55752 8192000000 10915100832 11382337536 1938254864 19.133 97 25 50 3 1961848752 16787312 6806576
15:25:52 50843 8192000000 10941708240 11405594624 1967132608 19.363 99 30 60 1 1995031216 19065024 8833584
15:26:53 65274 8192000000 10904118160 11378479104 1930494272 19.071 97 11 22 1 1948027440 14999424 2533744
15:28:05 81291 8192000000 10872421504 11342331904 1809351168 18.091 91 15 29 1 1822504480 8368496 4784816
15:29:40 59364 8192000000 10896528336 11377876992 1964524240 19.342 100 13 26 0 1982849920 14208560 4117120
15:30:46 73632 8192000000 10888562624 11372699648 1892856576 18.769 96 13 26 1 1916492816 20012144 3624096
15:32:06 79340 8192000000 10885603376 11332915200 1825569424 18.223 93 12 24 0 1841393008 12162288 3661296
15:33:34 128987 8192000000 10846068240 11308494848 1820021264 18.178 94 26 52 1 1844056816 17160784 6874768
15:36:47 57657 8192000000 10840322944 11300605952 1834766880 18.298 95 45 90 0 1858874288 10550880 13556528
15:38:09 38981 8192000000 10835222928 11307425792 1899398896 18.821 99 19 38 0 1915053616 10243440 5411280
15:38:58 103371 8192000000 10847764464 11308318720 1804055504 18.047 94 13 26 1 1819473776 11611344 3806928
15:40:50 24236 8192000000 10834640752 11293630464 1907021104 18.883 100 33 66 1 1925836672 8951920 9863648
15:41:39 70750 8192000000 10833075072 11303067648 1877607808 18.646 98 27 54 2 1899282592 13824368 7850416
15:43:15 52843 8192000000 10818944320 11300040704 1897215024 18.804 100 7 14 0 1911761728 12609424 1937280
15:44:15 32852 8192000000 10829603536 11302690816 1904539968 18.863 100 9 18 0 1918479760 10938224 3001568
15:44:54 45419 8192000000 10835246560 11308269568 1881992608 18.681 98 16 32 0 1894825120 8146992 4685520
15:45:51 35264 8192000000 10821585136 11288866816 1863032032 18.528 97 15 30 2 1873007776 6522384 3453360
15:46:33 26172 8192000000 10841401200 11301085184 1910928592 18.914 100 52 104 2 1933741712 7979296 14833824
15:47:11 13763 8192000000 10862067984 11310850048 1918421136 18.974 100 41 81 3 1942121216 11454304 12245776
15:47:37 36717 8192000000 10850872272 11314925568 1884762736 18.704 98 27 54 0 1904837216 12667984 7406496
15:48:20 78024 8192000000 10841512576 11307257856 1814966336 18.137 95 17 34 0 1833899936 14303376 4630224
15:50:29 64921 8192000000 10862841056 11339071488 1905684320 18.872 99 13 26 0 1918762864 9652768 3425776
15:51:46 33362 8192000000 10858537232 11318276096 1897201536 18.804 98 16 33 1 1913770032 11530320 5038176
15:52:30 37232 8192000000 10876356208 11335352320 1915165104 18.948 99 30 60 1 1935889408 12508256 8216048
15:53:22 55709 8192000000 10874422672 11329642496 1917655664 18.968 99 16 32 1 1933639248 11687568 4296016
15:54:29 38964 8192000000 10879343904 11313393664 1893084032 18.771 98 35 68 2 1914122128 10921120 10116976
15:55:15 58408 8192000000 10848226992 11325472768 1902617552 18.847 99 29 58 2 1932389440 21680912 8090976
15:56:20 70155 8192000000 10860642368 11310051328 1894007600 18.778 98 15 30 0 1910879088 12372528 4498960
15:57:36 127922 8192000000 10846505296 11317420032 1921916864 19.002 99 19 38 0 1936236096 9205744 5113488
15:59:51 17498 8192000000 10880846064 11334901760 1948467936 19.214 100 30 60 1 1965389888 8143728 8778224
16:00:15 41953 8192000000 10860504752 11337801728 1928922048 19.058 99 13 26 0 1939033600 7211360 2900192
16:01:09 67885 8192000000 10879091424 11349905408 1949067008 19.219 100 7 14 1 1959279600 8346960 1865632
16:02:24 16739 8192000000 10879128144 11357716480 1955296592 19.269 100 5 10 1 1964685344 8400896 987856
16:02:52 32311 8192000000 10877099408 11351166976 1937975408 19.131 99 13 26 0 1950566464 9244304 3346752
16:03:31 49954 8192000000 10878081840 11353645056 1953501344 19.254 100 8 16 0 1965852832 10044592 2306896
16:04:27 29926 8192000000 10893824176 11364712448 1966745040 19.360 100 19 38 3 1979547040 7336480 5465520
16:05:03 60525 8192000000 10923343088 11391041536 1985095104 19.505 100 24 48 0 2003324736 11195312 7034320
16:06:17 53927 8192000000 10921257232 11378737152 1956360016 19.277 98 25 50 2 1982162640 18807792 6994832
16:07:17 65934 8192000000 10900943472 11357851648 1899433584 18.822 96 21 42 1 1920785904 15000000 6352320
16:08:36 92066 8192000000 10880483552 11350237184 1877893152 18.648 95 39 78 2 1906104912 16775264 11436496
16:10:15 50445 8192000000 10892795120 11347714048 1923901952 19.018 98 20 41 1 1943029440 13469632 5657856
16:11:18 55882 8192000000 10914099744 11373932544 1965142256 19.347 100 26 52 0 1985384496 12559072 7683168
16:12:23 89386 8192000000 10896183808 11368677376 1908636576 18.896 97 9 18 1 1930702144 19540720 2524848
16:14:02 57690 8192000000 10886946144 11358367744 1907098496 18.883 97 24 48 0 1928396032 13903248 7394288
16:15:15 64171 8192000000 10891077552 11341545472 1849263456 18.416 94 18 36 0 1864385520 10930128 4191936
16:16:26 176703 8192000000 10834726656 11301961728 1869427456 18.580 96 18 36 3 1885138864 10243152 5468256
16:19:30 80103 8192000000 10830130768 11288760320 1805927120 18.063 93 25 50 1 1822828720 9914576 6987024
16:20:59 51777 8192000000 10818793408 11293364224 1855440656 18.466 97 23 45 4 1869912512 7662528 6809328
16:22:02 74159 8192000000 10804526080 11282567168 1840794656 18.347 96 3 7 0 1851448528 9643184 1010688
16:23:23 36872 8192000000 10833423440 11299106816 1880448736 18.669 99 9 17 1 1892428128 9532096 2447296
16:24:18 97852 8192000000 10845357088 11319021568 1907495376 18.887 99 15 30 0 1925445856 13638672 4311808
16:26:03 51320 8192000000 10829247216 11296047104 1845240368 18.383 96 7 14 0 1860152832 12741584 2170880
16:27:08 8493 8192000000 9088909536 9311576064 257258880 3.044 14 3 5 0 261748000 3762784 726336

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 137 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-01-2021 16:29:32 to 06-01-2021 16:29:34.

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          240938
MON$OLDEST_ACTIVE               240939
MON$OLDEST_SNAPSHOT             240939
MON$NEXT_TRANSACTION            240939
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                       2048288
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 ---
:466: 
:467: mscs-test-161.budzdorov.ru    Wed Jan  6 16:27:21 2021
:468:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:469: 
:470: 
:471: mscs-test-161.budzdorov.ru    Wed Jan  6 16:27:21 2021
:472:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:473: 
:474: 
:475: mscs-test-161.budzdorov.ru    Wed Jan  6 16:27:23 2021
:476:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:477: 
--- end of diff output ---

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

06.01.21 16:29:35. 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-06 16:29:37 No severe PSQL-related problems occured
06.01.21 16:29:38. End of report.