Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.12.2020 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 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 17457852 kB
MemAvailable 31466504 kB
Buffers 0 kB
Cached 14201960 kB
SwapCached 3696 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 2020-12-20 16:27:10
DTS_END                         2020-12-20 16:27:10.1130
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/57320
TRN_ID                          250249
ATT_ID                          725
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: 9620.07 17055 1154408
customer order: creation 184.61 328 22153
customer order: refuse 16.08 251 1930
order to supplier: creation 48.78 1151 5853
order to supplier: removal 3.49 78544 419
invoice (draft): creation 49.02 2948 5882
invoice (draft): removal 54.40 638 6528
invoice accept: apply 43.88 15099 5265
invoice accept: cancel 49.45 636 5934
customer reserve: creation 3981.73 153 477807
customer reserve: removal 4884.33 44 586120
realization accept: apply 89.07 156 10688
realization accept: cancel 76.64 101 9197
payment from customer: creation 62.83 98 7540
payment from customer: removal 6.18 66 741
payment to supplier: creation 52.86 106 6343
payment to supplier: removal 3.82 78 458
service: total inventory turnovers 5.24 1008 629
service: total monetary turnovers 6.72 26 806
service: aggregate perf. data 0.93 15530 111
service: refresh index statistics 0.03 224133 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-12-2020 16:28:04 to 20-12-2020 16:28:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11451
TEST_TIME 2 8466
TEST_TIME 3 7452
TEST_TIME 4 6842
TEST_TIME 5 6860
TEST_TIME 6 7122
TEST_TIME 7 7158
TEST_TIME 8 7624
TEST_TIME 9 7683
TEST_TIME 10 7850
TEST_TIME 11 8038
TEST_TIME 12 8884
TEST_TIME 13 9141
TEST_TIME 14 9774
TEST_TIME 15 9909
TEST_TIME 16 9798
TEST_TIME 17 11073
TEST_TIME 18 11766
TEST_TIME 19 11826
TEST_TIME 20 12143
TEST_TIME 21 12600
TEST_TIME 22 12423
TEST_TIME 23 12243
TEST_TIME 24 11917
TEST_TIME 25 11716
TEST_TIME 26 11408
TEST_TIME 27 11362
TEST_TIME 28 11224
TEST_TIME 29 10928
TEST_TIME 30 11122
TEST_TIME 31 10887
TEST_TIME 32 10806
TEST_TIME 33 10574
TEST_TIME 34 10425
TEST_TIME 35 10279
TEST_TIME 36 10406
TEST_TIME 37 10176
TEST_TIME 38 10127
TEST_TIME 39 10064
TEST_TIME 40 10081
TEST_TIME 41 10137
TEST_TIME 42 10074
TEST_TIME 43 10095
TEST_TIME 44 10128
TEST_TIME 45 10140
TEST_TIME 46 10031
TEST_TIME 47 10136
TEST_TIME 48 10127
TEST_TIME 49 10243
TEST_TIME 50 10296
TEST_TIME 51 10316
TEST_TIME 52 10238
TEST_TIME 53 10090
TEST_TIME 54 10027
TEST_TIME 55 9946
TEST_TIME 56 9965
TEST_TIME 57 9912
TEST_TIME 58 9843
TEST_TIME 59 9734
TEST_TIME 60 9718
TEST_TIME 61 9711
TEST_TIME 62 9702
TEST_TIME 63 9676
TEST_TIME 64 9710
TEST_TIME 65 9705
TEST_TIME 66 9826
TEST_TIME 67 9827
TEST_TIME 68 9953
TEST_TIME 69 9869
TEST_TIME 70 9892
TEST_TIME 71 9870
TEST_TIME 72 9941
TEST_TIME 73 9900
TEST_TIME 74 9961
TEST_TIME 75 9993
TEST_TIME 76 9931
TEST_TIME 77 9874
TEST_TIME 78 9809
TEST_TIME 79 9811
TEST_TIME 80 9741
TEST_TIME 81 9734
TEST_TIME 82 9667
TEST_TIME 83 9672
TEST_TIME 84 9640
TEST_TIME 85 9647
TEST_TIME 86 9663
TEST_TIME 87 9653
TEST_TIME 88 9622
TEST_TIME 89 9608
TEST_TIME 90 9639
TEST_TIME 91 9696
TEST_TIME 92 9726
TEST_TIME 93 9750
TEST_TIME 94 9737
TEST_TIME 95 9727
TEST_TIME 96 9782
TEST_TIME 97 9810
TEST_TIME 98 9820
TEST_TIME 99 9873
TEST_TIME 100 9820
TEST_TIME 101 9752
TEST_TIME 102 9690
TEST_TIME 103 9690
TEST_TIME 104 9663
TEST_TIME 105 9627
TEST_TIME 106 9561
TEST_TIME 107 9502
TEST_TIME 108 9545
TEST_TIME 109 9578
TEST_TIME 110 9570
TEST_TIME 111 9555
TEST_TIME 112 9569
TEST_TIME 113 9564
TEST_TIME 114 9568
TEST_TIME 115 9619
TEST_TIME 116 9609
TEST_TIME 117 9653
TEST_TIME 118 9721
TEST_TIME 119 9683
TEST_TIME 120 9628

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-12-2020 16:28:08 to 20-12-2020 16:28:11.

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 1597383 1597383 0 0.00 0 14305 5 0 0
doc_list_biud 1597383 1597383 0 0.00 0 51503 21 0 0
sp_add_invoice_to_stock 5389 5265 124 2.30 16 143806 15099 0 124
sp_cancel_adding_invoice 5934 5934 0 0.00 4 42799 637 0 0
sp_cancel_client_order 1930 1930 0 0.00 4 15446 252 0 0
sp_cancel_customer_reserve 586120 586120 0 0.00 1 51504 44 0 0
sp_cancel_pay_from_customer 741 741 0 0.00 2 6535 67 0 0
sp_cancel_pay_to_supplier 458 458 0 0.00 2 4232 78 0 0
sp_cancel_supplier_invoice 6540 6528 12 0.18 2 13205 638 0 12
sp_cancel_supplier_order 419 419 0 0.00 7 740351 78544 0 0
sp_cancel_write_off 9197 9197 0 0.00 1 8047 102 0 0
sp_client_order 22153 22153 0 0.00 3 12642 329 0 0
sp_customer_reserve 477807 477807 0 0.00 0 29504 154 0 0
sp_fill_shopping_cart 33887 33887 0 0.00 1 13695 39 0 0
sp_fill_shopping_cart_clo_res 477793 477793 0 0.00 0 9621 12 0 0
sp_get_clo_for_invoice 5246 5246 0 0.00 0 30041 287 0 0
sp_kill_cost_storno 16330 16330 0 0.00 0 5886 39 0 0
sp_kill_qstorno_ret_qs2qd 1188384 1188384 0 0.00 0 51501 24 0 0
sp_kill_qty_storno 626062 626062 0 0.00 0 51503 53 0 0
sp_lock_selected_doc 22130 22130 0 0.00 0 9031 5 0 0
sp_make_cost_storno 29817 29817 0 0.00 0 14299 43 0 0
sp_multiply_rows_for_pdistr 29817 29817 0 0.00 0 10500 21 0 0
sp_multiply_rows_for_qdistr 22153 22153 0 0.00 0 10934 153 0 0
sp_pay_from_customer 7540 7540 0 0.00 4 18476 99 0 0
sp_pay_to_supplier 6343 6343 0 0.00 4 18457 107 0 0
sp_payment_common 13883 13883 0 0.00 1 18463 31 0 0
sp_qd_handle_on_cancel_clo 1930 1930 0 0.00 0 15439 231 0 0
sp_qd_handle_on_invoice_upd_sts 11180 11180 0 0.00 0 17811 261 0 0
sp_qd_handle_on_reserve_upd_sts 10688 10688 0 0.00 0 12838 49 0 0
sp_reserve_write_off 10688 10688 0 0.00 6 12951 156 0 0
sp_supplier_invoice 5882 5882 0 0.00 6 73388 2949 0 0
sp_supplier_order 5853 5853 0 0.00 4 43322 1151 0 0
srv_aggregate_perf_data 111 111 0 0.00 2521 143458 15531 0 0
srv_fill_mon_cache_memory 150 150 0 0.00 1617 132786 37577 0 0
srv_find_qd_qs_mism 1104186 1104186 0 0.00 0 13447 5 0 0
srv_make_invnt_saldo 629 629 0 0.00 24 48177 1008 0 0
srv_make_money_saldo 806 806 0 0.00 1 8237 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 110652 358630 224133 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5265 5265 0 0.00 0 14599 145 0 0
t$perf-norm:sp_cancel_adding_invoice 459 459 0 0.00 0 1929 57 0 0
t$perf-norm:sp_cancel_client_order 1930 1930 0 0.00 0 5879 16 0 0
t$perf-norm:sp_cancel_customer_reserve 734 734 0 0.00 0 8364 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 741 741 0 0.00 0 1457 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 458 458 0 0.00 0 3143 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 2012 12 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 14942 1133 0 0
t$perf-norm:sp_cancel_write_off 1071 1071 0 0.00 0 5942 15 0 0
t$perf-norm:sp_client_order 22153 22153 0 0.00 0 9872 15 0 0
t$perf-norm:sp_customer_reserve 1034 1034 0 0.00 0 8363 20 0 0
t$perf-norm:sp_pay_from_customer 7540 7540 0 0.00 0 14454 13 0 0
t$perf-norm:sp_pay_to_supplier 6343 6343 0 0.00 0 7478 8 0 0
t$perf-norm:sp_reserve_write_off 10688 10688 0 0.00 0 7255 10 0 0
t$perf-norm:sp_supplier_invoice 5882 5882 0 0.00 0 8279 16 0 0
t$perf-norm:sp_supplier_order 5853 5853 0 0.00 0 5643 12 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 113 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 150 150 0 0.00 0 82 1 0 0
t$perf-norm:srv_make_invnt_saldo 629 629 0 0.00 0 2575 14 0 0
t$perf-norm:srv_make_money_saldo 806 806 0 0.00 0 1095 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10736 10488 248 2.30 0 6241 18 0 248
v_all_customers 39792 39792 0 0.00 0 44 0 0 0
v_all_suppliers 32344 32344 0 0.00 0 20 1 0 0
v_all_wares 44306 44306 0 0.00 0 79 1 0 0
v_cancel_adding_invoice 918 918 0 0.00 0 661 6 0 0
v_cancel_client_order 3860 3860 0 0.00 0 2385 5 0 0
v_cancel_customer_prepayment 1482 1482 0 0.00 0 6528 11 0 0
v_cancel_customer_reserve 1468 1468 0 0.00 0 2760 7 0 0
v_cancel_payment_to_supplier 916 916 0 0.00 0 2471 12 0 0
v_cancel_supplier_invoice 796 772 24 3.01 0 2592 20 0 24
v_cancel_supplier_order 838 838 0 0.00 0 652 4 0 0
v_cancel_write_off 2142 2142 0 0.00 0 8041 15 0 0
v_max_id_clo_ord 5853 5853 0 0.00 0 1377 2 0 0
v_max_id_clo_res 1034 1034 0 0.00 0 2816 12 0 0
v_max_id_ord_sup 5881 5881 0 0.00 0 5399 5 0 0
v_max_non_paid_invoice 1905 1905 0 0.00 0 659 2 0 0
v_max_non_paid_realizn 4082 4082 0 0.00 0 2123 5 0 0
v_min_id_clo_ord 5853 5853 0 0.00 0 2682 6 0 0
v_min_id_clo_res 1034 1034 0 0.00 0 1878 7 0 0
v_min_id_ord_sup 5881 5881 0 0.00 0 4786 9 0 0
v_min_non_paid_invoice 6343 6343 0 0.00 0 18413 21 0 0
v_min_non_paid_realizn 7540 7540 0 0.00 0 14385 19 0 0
v_our_firm 11430 11430 0 0.00 0 20 1 0 0
v_reserve_write_off 21376 21376 0 0.00 0 6956 8 0 0
x_lock_depdocs_on_canc_invoice 12076 12076 0 0.00 0 12277 99 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 24164 321 0 0
x_make_qstorno_1000_1200 5853 5853 0 0.00 2 43296 1089 0 0
x_make_qstorno_1200_2000 5882 5882 0 0.00 3 73352 2796 0 0
x_make_qstorno_2100_3300 477807 477807 0 0.00 0 29503 139 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-12-2020 16:28:12 to 20-12-2020 16:28:16.

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:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:20 13466 8192000000 10197743728 10500313088 932918896 10.223 75 59 121 0 955397136 2713360 19764880
13:57:42 24670 8192000000 10304647808 10616668160 1349783936 14.146 100 85 168 1 1381439792 4135744 27520112
13:58:14 30659 8192000000 10373460160 10690740224 1410001584 14.684 100 86 172 0 1444670192 6035296 28633312
13:58:52 5467 8192000000 10373488656 10697203712 1433318672 14.891 100 85 170 0 1468492208 6924800 28248736
13:59:06 15045 8192000000 10402988320 10730393600 1455755280 15.089 100 88 176 0 1492250496 7593344 28901872
13:59:37 22560 8192000000 10421151424 10756460544 1476377648 15.270 100 91 181 1 1518211216 12563104 29270464
14:00:18 26329 8192000000 10460182032 10799243264 1521072464 15.660 100 93 186 1 1559547808 9107568 29367776
14:00:59 18559 8192000000 10497592208 10841333760 1546826320 15.883 100 88 176 0 1583800048 9483312 27490416
14:01:25 17200 8192000000 10520182512 10867449856 1569883648 16.081 100 89 178 0 1608552688 10218416 28450624
14:01:50 8455 8192000000 10526977008 10883268608 1589930144 16.253 100 76 150 1 1623475136 10453312 23091680
14:02:12 11083 8192000000 10551811776 10906091520 1607170048 16.401 100 74 148 1 1640635712 10907488 22558176
14:02:33 10056 8192000000 10566901312 10929471488 1629455520 16.590 100 77 154 1 1663533824 10881824 23196480
14:02:51 10330 8192000000 10586549504 10948304896 1642687840 16.702 100 79 159 0 1677871328 11580176 23603312
14:03:12 9695 8192000000 10599436320 10966048768 1663033568 16.874 100 86 172 2 1700708400 11961216 25713616
14:03:28 8866 8192000000 10614778320 10984964096 1678758816 17.007 100 75 150 0 1712976576 12078096 22139664
14:03:46 5239 8192000000 10644030816 11016609792 1699091344 17.177 100 73 145 2 1731456944 11453712 20911888
14:04:00 6750 8192000000 10668342624 11041267712 1722145200 17.370 100 79 157 0 1756818624 12039696 22633728
14:04:14 6907 8192000000 10670333584 11054116864 1740881424 17.526 100 71 141 1 1772989360 11736160 20371776
14:04:30 4095 8192000000 10701990736 11077242880 1762923808 17.709 100 78 156 1 1797398144 11340816 23133520
14:04:40 3637 8192000000 10716085344 11097964544 1778847088 17.840 100 77 154 0 1812634240 11639680 22147472
14:04:51 3845 8192000000 10719746816 11105153024 1785613216 17.896 100 68 134 2 1817206384 11991392 19601776
14:05:02 2914 8192000000 10730662928 11113377792 1794181264 17.966 100 84 168 2 1829185584 11976224 23028096
14:05:11 3569 8192000000 10732032960 11119001600 1799407152 18.009 100 78 156 1 1834064896 12712160 21945584
14:05:22 4607 8192000000 10739135424 11128684544 1805575456 18.060 100 71 141 3 1836783408 11874688 19333264
14:05:34 2723 8192000000 10758862656 11144822784 1818057040 18.162 100 79 161 1 1853755696 13313248 22385408
14:05:43 2397 8192000000 10775402976 11159572480 1827353600 18.238 100 81 162 1 1864770560 14236160 23180800
14:05:52 2957 8192000000 10778503952 11161874432 1831754640 18.274 100 89 177 1 1871477152 14434176 25288336
14:06:02 2522 8192000000 10784716368 11170566144 1842474112 18.361 100 87 174 1 1880430128 13961504 23994512
14:06:11 1511 8192000000 10788660800 11173761024 1846010512 18.390 100 90 181 3 1886440032 14968352 25461168
14:06:19 1775 8192000000 10792798848 11181166592 1847448160 18.401 100 87 173 1 1890296016 18652016 24195840
14:06:28 1769 8192000000 10789761264 11176878080 1846042320 18.390 100 81 161 1 1881656432 12066880 23547232
14:06:36 1943 8192000000 10796066624 11181289472 1852675376 18.444 100 80 161 0 1888189728 12871744 22642608
14:06:44 1787 8192000000 10808318592 11193450496 1857328304 18.482 100 94 187 1 1897453616 13626912 26498400
14:06:53 1236 8192000000 10807277312 11195465728 1861328944 18.514 100 93 186 1 1900666560 12764560 26573056
14:07:00 1867 8192000000 10811573280 11197886464 1865817008 18.550 100 89 179 1 1903807840 12245376 25745456
14:07:09 2085 8192000000 10804239088 11200552960 1867355792 18.563 100 87 175 0 1905917728 13718416 24843520
14:07:18 30855 8192000000 10787129456 11200278528 1868356992 18.571 100 51 102 3 1890564560 7107152 15100416
14:07:55 9118 8192000000 10787439008 11204415488 1868836064 18.575 100 44 87 2 1887623872 6177104 12610704
14:08:11 9216 8192000000 10788691552 11208605696 1871082752 18.593 100 25 51 3 1885343296 6495936 7764608
14:08:27 5877 8192000000 10793069744 11217346560 1878936160 18.657 100 34 68 1 1899963696 11389920 9637616
14:08:41 9016 8192000000 10774244880 11210252288 1874326240 18.619 100 22 42 2 1887321408 6801664 6193504
14:08:57 11764 8192000000 10778495824 11211038720 1874853424 18.624 100 16 32 1 1886307936 6104864 5349648
14:09:17 13473 8192000000 10802745408 11228241920 1885158560 18.707 100 21 41 0 1896947456 6064048 5724848
14:09:37 9670 8192000000 10786647920 11224141824 1885643056 18.711 100 15 30 0 1895797968 6108624 4046288
14:09:53 13538 8192000000 10803696480 11236859904 1890712880 18.752 100 17 32 1 1905974272 10476208 4785184
14:10:14 16348 8192000000 10801615984 11237871616 1894931232 18.786 100 14 28 1 1904653248 5840976 3881040
14:10:39 15209 8192000000 10796569184 11234742272 1900653552 18.832 100 25 50 1 1915175648 7087808 7434288
14:11:00 48898 8192000000 10825524640 11249229824 1903293088 18.853 100 38 77 1 1920657808 6004016 11360704
14:11:57 26986 8192000000 10811289392 11250384896 1902748192 18.848 100 20 39 4 1913561200 4758256 6054752
14:12:30 7827 8192000000 10828967264 11257585664 1907827520 18.889 100 32 64 1 1923846144 7386320 8632304
14:12:48 5259 8192000000 10821745664 11257286656 1908220592 18.892 100 27 52 1 1922723040 6606928 7895520
14:13:03 6572 8192000000 10823844848 11256872960 1909229968 18.900 100 32 64 2 1924346560 6036416 9080176
14:13:16 8187 8192000000 10816930704 11258294272 1910889744 18.914 100 33 66 1 1927346576 7020832 9436000
14:13:31 5142 8192000000 10823345072 11258044416 1907415568 18.886 100 14 27 2 1916876640 5373456 4087616
14:13:43 11671 8192000000 10826118848 11266076672 1908084896 18.891 100 18 36 0 1919254656 6272112 4897648
14:14:01 11472 8192000000 10816451296 11255558144 1905775632 18.873 100 6 12 0 1912262064 4756304 1730128
14:14:18 9276 8192000000 10818167728 11257208832 1907234848 18.884 100 13 26 1 1916401248 5521904 3644496
14:14:34 13922 8192000000 10825339376 11260784640 1908492864 18.895 100 18 36 2 1920324048 5853664 5977520
14:14:55 11944 8192000000 10808699440 11247775744 1886181120 18.715 99 10 20 0 1893674864 4608000 2885744
14:15:14 8427 8192000000 10818370320 11251658752 1898454128 18.814 100 13 26 1 1907821984 5732976 3634880
14:15:28 14674 8192000000 10811146416 11249414144 1886799984 18.720 99 18 37 1 1897858848 5885392 5173472
14:15:49 55059 8192000000 10818278256 11240374272 1850978128 18.430 97 31 62 0 1865389072 5259520 9151424
14:16:52 24211 8192000000 10778699984 11203235840 1739065424 17.511 92 15 28 0 1747846224 5027184 3753616
14:17:23 11867 8192000000 10774534608 11207356416 1827483536 18.239 97 22 44 2 1839612880 5991680 6137664
14:17:44 5155 8192000000 10750928112 11173842944 1778932448 17.841 96 27 53 2 1793144480 6706080 7505952
14:17:56 6583 8192000000 10731952800 11158888448 1782393056 17.869 97 29 56 3 1796164128 6298144 7472928
14:18:11 9005 8192000000 10707816656 11132387328 1761604576 17.698 97 19 38 0 1773055904 6135456 5315872
14:18:31 7523 8192000000 10722696432 11144269824 1785255856 17.893 98 23 46 0 1797301376 5869376 6176144
14:18:44 7634 8192000000 10678823552 11093131264 1725762656 17.400 97 26 51 3 1738904032 5834208 7307168
14:18:59 9175 8192000000 10630097760 11024842752 1630472320 16.599 92 24 48 1 1643223328 5465776 7285232
14:19:15 5402 8192000000 10678331712 11086249984 1737034528 17.494 98 31 62 3 1752087152 5626912 9425712
14:19:28 6132 8192000000 10681384624 11091128320 1739607280 17.515 98 36 72 2 1756310528 6035520 10667728
14:19:42 9006 8192000000 10681629696 11092021248 1735610784 17.482 97 26 49 1 1748366528 5220560 7535184
14:19:59 6136 8192000000 10675672976 11088281600 1754319040 17.637 99 27 53 0 1768606224 6509328 7777856
14:20:12 13807 8192000000 10692860784 11119271936 1760613264 17.689 98 21 41 1 1772286288 5548176 6124848
14:20:32 69153 8192000000 10718538368 11142254592 1751900640 17.617 97 37 74 1 1771902912 9327312 10674960
14:21:55 7444 8192000000 10717731616 11141005312 1805637056 18.060 100 20 38 2 1817297584 5997936 5662592
14:22:09 6853 8192000000 10730359376 11154001920 1817873328 18.160 100 35 70 0 1834851296 7511040 9466928
14:22:22 5738 8192000000 10741777024 11165724672 1828583072 18.248 100 31 62 2 1844038208 6828928 8626208
14:22:34 6346 8192000000 10752006896 11169140736 1831843808 18.274 100 22 44 2 1843589744 5185552 6560384
14:22:47 6096 8192000000 10749148288 11176558592 1837542176 18.321 100 31 62 4 1853203024 6898160 8762688
14:23:01 7477 8192000000 10746385168 11174621184 1834571104 18.297 100 19 38 1 1844701616 5079312 5051200
14:23:18 9051 8192000000 10753705776 11182444544 1840155584 18.342 100 18 36 4 1851028800 5902448 4970768
14:23:36 20126 8192000000 10763771248 11195297792 1850065760 18.423 100 17 34 2 1860454016 4733904 5654352
14:24:05 11511 8192000000 10765402800 11199463424 1860023376 18.503 100 16 32 1 1870128656 5619664 4485616
14:24:24 14698 8192000000 10779443632 11206447104 1861364656 18.514 100 12 24 0 1870173888 5002144 3807088
14:24:47 7851 8192000000 10787700512 11209015296 1867600096 18.565 100 29 57 3 1883587712 6900400 9087216
14:25:02 11188 8192000000 10789749424 11212292096 1868722000 18.574 100 15 30 0 1878805680 5562032 4521648
14:25:22 21123 8192000000 10782491904 11214217216 1870954192 18.592 100 24 46 1 1883000848 5514576 6532080
14:26:19 52606 8192000000 10809657072 11231883264 1880924656 18.673 100 23 46 0 1897001936 10237232 5840048
14:27:22 12764 8192000000 10835440112 11249577984 1906041904 18.875 100 51 98 1 1926075792 6365520 13668368
14:27:42 24631 8192000000 10839888096 11266789376 1913924400 18.938 100 46 92 2 1935289984 8519824 12845760
14:28:15 6760 8192000000 10863045024 11285045248 1928903360 19.058 100 58 114 2 1956358720 11733152 15722208
14:28:29 5232 8192000000 10872874128 11287990272 1933063616 19.091 100 52 101 2 1957539328 10673872 13801840
14:28:41 7826 8192000000 10870724320 11293880320 1940252544 19.149 100 55 110 2 1967243168 11472256 15518368
14:28:56 4485 8192000000 10880440832 11303600128 1947526688 19.207 100 74 148 2 1980735424 11877184 21331552
14:29:09 15382 8192000000 10880672256 11306090496 1947970256 19.210 100 54 109 3 1976382960 12982368 15430336
14:29:35 16812 8192000000 10889673888 11315281920 1951226176 19.236 100 51 102 3 1978023696 12311648 14485872
14:29:59 17618 8192000000 10898663952 11325444096 1962534256 19.326 100 59 117 1 1992216688 13162624 16519808
14:30:23 5607 8192000000 10910428032 11333275648 1970670240 19.391 100 60 119 3 2001678544 14225040 16783264
14:30:36 5030 8192000000 10910419104 11333648384 1972872128 19.408 100 61 119 2 2003488896 13385536 17231232
14:30:50 26442 8192000000 10911946352 11342598144 1976126640 19.434 100 56 112 2 2007378928 13697152 17555136
14:31:51 10944 8192000000 10927019696 11357495296 1987173936 19.521 100 52 103 0 2017446112 14606032 15666144
14:32:09 13259 8192000000 10917211824 11356606464 1987503552 19.524 100 37 72 3 2015145712 15454400 12187760
14:32:48 15124 8192000000 10940858784 11374170112 1992513888 19.564 100 50 96 1 2026595056 18573600 15507568
14:33:11 18700 8192000000 10944374928 11381870592 2001401424 19.634 100 42 84 0 2033463056 19419680 12641952
14:33:38 7282 8192000000 10968262688 11396550656 2008437072 19.689 100 57 113 2 2050319392 25269696 16612624
14:33:53 5961 8192000000 10961839920 11391549440 2011600480 19.714 100 61 122 1 2049660560 19989408 18070672
14:34:06 2500 8192000000 10965663904 11398053888 2016012112 19.749 100 63 126 1 2059147216 25027616 18107488
14:34:19 6375 8192000000 10955095088 11386126336 1990443856 19.547 99 55 108 2 2031188608 25211744 15533008
14:34:35 2470 8192000000 10971774864 11394134016 2011034464 19.710 100 71 142 1 2054652576 22490064 21128048
14:34:44 3295 8192000000 10984636624 11399385088 2018249680 19.766 100 81 158 1 2064361776 22249936 23862160
14:34:55 8783 8192000000 10972017184 11399139328 2018172384 19.766 100 69 138 0 2062723040 24910976 19639680
14:35:11 1709 8192000000 10970132384 11384147968 2001425472 19.634 99 82 164 0 2053580240 27613328 24541440
14:35:20 2095 8192000000 10959876160 11384078336 1991003872 19.552 99 74 148 0 2038358688 25901904 21452912
14:35:29 7327 8192000000 10964395184 11387437056 2005563744 19.667 100 67 131 2 2051861728 26299424 19998560
14:35:45 3827 8192000000 10971080368 11387060224 2003794544 19.653 100 74 148 2 2052483968 27428048 21261376
14:36:01 2784 8192000000 10956799424 11380338688 1999459856 19.618 100 69 137 1 2047224000 27606976 20157168
14:36:11 5455 8192000000 10936812784 11358146560 1964109744 19.339 99 70 140 0 2013290864 28402144 20778976
14:36:23 2050 8192000000 10948247728 11359911936 1965277504 19.348 99 79 156 0 2017460032 28795776 23386752
14:36:32 4370 8192000000 10961567600 11374370816 1989778592 19.542 100 77 154 0 2043585696 30374736 23432368
14:36:44 15643 8192000000 10957444176 11381620736 1999392848 19.618 100 83 165 2 2056743312 32054240 25296224
14:37:10 10279 8192000000 10926055632 11356188672 1968487824 19.373 99 62 122 0 2021119152 32854816 19776512
14:37:28 3497 8192000000 10932980320 11354923008 1944017504 19.179 98 67 132 4 1997215600 32377200 20820896
14:37:40 5551 8192000000 10950818080 11367571456 1978730512 19.455 100 64 125 0 2034269168 35456896 20081760
14:37:52 2895 8192000000 10970041920 11386859520 1993956176 19.575 100 80 158 3 2056176560 37490912 24729472
14:38:01 7102 8192000000 10969848656 11390808064 1998061520 19.607 100 78 156 3 2063064944 40813696 24189728
14:38:18 3380 8192000000 10965446288 11387117568 1993611520 19.572 100 71 141 0 2057889440 41212176 23065744
14:38:30 9367 8192000000 10935680160 11366977536 1960127664 19.307 99 59 118 1 2018796928 39027856 19641408
14:38:49 7076 8192000000 10955407232 11379023872 1967262496 19.364 99 63 127 2 2028229232 39768512 21198224
14:39:02 1939 8192000000 10939910592 11352211456 1947264144 19.205 98 75 148 1 2011662208 41054512 23343552
14:39:12 2059 8192000000 10966279168 11376136192 1978167680 19.450 100 86 170 0 2045829680 41011088 26650912
14:39:21 2540 8192000000 10952500512 11370401792 1972555184 19.406 100 76 148 3 2038903824 43072064 23276576
14:39:30 1617 8192000000 10941206784 11353812992 1965479088 19.350 100 79 156 2 2026431472 35972448 24979936
14:39:42 5138 8192000000 10935417040 11347836928 1946107360 19.195 99 77 154 3 2007347536 37307248 23932928
14:39:53 4058 8192000000 10921635728 11338371072 1945857584 19.193 100 62 124 0 2003295440 37714544 19723312
14:40:04 7353 8192000000 10913650432 11352428544 1958699872 19.296 100 51 102 0 2012539456 37116672 16722912
14:40:22 9468 8192000000 10912416752 11337265152 1941522528 19.159 99 44 88 1 1986861104 30881056 14457520
14:40:50 8840 8192000000 10921123872 11345375232 1932520624 19.087 98 51 103 1 1983053184 34685824 15846736
14:41:08 5853 8192000000 10918548608 11350773760 1953385712 19.253 100 41 82 0 2005675184 37617760 14671712
14:41:25 7815 8192000000 10898462512 11333189632 1904438080 18.862 97 46 89 3 1953838336 35241088 14159168
14:41:41 7375 8192000000 10881321552 11311009792 1908936064 18.898 98 36 72 1 1955298128 34119184 12242880
14:41:55 12331 8192000000 10880221616 11319635968 1924319680 19.021 99 34 66 6 1971034560 35456048 11258832
14:42:27 9946 8192000000 10904925488 11343065088 1946502080 19.199 100 36 72 2 1993102768 34423456 12177232
14:42:44 25213 8192000000 10893759040 11330154496 1908983328 18.898 98 37 74 1 1955578368 34071264 12523776
14:43:21 10642 8192000000 10924964080 11356352512 1951674112 19.240 100 47 94 2 2006225600 38701520 15849968
14:43:45 19887 8192000000 10893234528 11343556608 1932207696 19.085 99 30 60 2 1990304784 46868720 11228368
14:44:15 18261 8192000000 10892069392 11339857920 1932188752 19.084 100 24 48 1 1989154640 47489904 9475984
14:44:42 7713 8192000000 10868252704 11317518336 1905151456 18.868 99 18 36 0 1950659824 39019696 6488672
14:45:01 33966 8192000000 10860494832 11318194176 1909590160 18.903 99 25 50 2 1954624384 36953792 8080432
14:46:11 20721 8192000000 10872733200 11321192448 1885736480 18.711 98 11 22 2 1921296848 32211008 3349360
14:46:38 48585 8192000000 10879840880 11335507968 1902498720 18.846 99 14 28 1 1938948800 31717440 4732640
14:47:43 40284 8192000000 10854363744 11311939584 1892703904 18.768 99 12 24 1 1929333024 32461104 4168016
14:48:30 26253 8192000000 10853637840 11316834304 1899048368 18.819 99 12 24 3 1922640720 20153168 3439184
14:49:04 80430 8192000000 10850146736 11305484288 1899474816 18.822 99 21 42 1 1924947808 18919360 6553632
14:51:11 31219 8192000000 10846622128 11304886272 1919397664 18.982 100 30 61 2 1936673424 9558464 7717296
14:52:01 99388 8192000000 10855882624 11308552192 1878678544 18.654 97 17 34 1 1894633152 11435568 4519040
14:53:57 84307 8192000000 10850432416 11321737216 1907332656 18.885 99 8 17 0 1924952624 15358928 2261040
14:55:33 72019 8192000000 10847238816 11299266560 1858381872 18.490 96 14 28 2 1874161696 11787280 3992544
14:57:28 52773 8192000000 10876276944 11328667648 1934034192 19.099 99 22 44 0 1953789760 13590752 6164816
14:58:29 51296 8192000000 10841468448 11297763328 1872838592 18.607 96 24 48 0 1888343664 8335440 7169632
14:59:27 116504 8192000000 10869168272 11320537088 1935792784 19.113 100 33 67 0 1950707696 6298160 8616752
15:01:33 6539 8192000000 10875327584 11326636032 1953574896 19.255 100 28 55 3 1970972000 10046368 7350736
15:01:51 42047 8192000000 10903309600 11357339648 1958236704 19.292 100 21 42 0 1973535456 9946336 5352416
15:02:46 68204 8192000000 10888999264 11360653312 1964573760 19.342 100 17 35 1 1983944144 14104688 5265696
15:04:00 54973 8192000000 10886466416 11369672704 1966866864 19.361 100 14 28 0 1983093264 12542992 3683408
15:05:03 41457 8192000000 10876730112 11348201472 1966096272 19.354 100 11 22 0 1975930320 6752944 3081104
15:06:19 47843 8192000000 10915884704 11365101568 1959168592 19.299 99 26 52 1 1973947216 7568880 7209744
15:07:16 63355 8192000000 10902055408 11379752960 1980171840 19.466 100 12 24 0 1992794096 9666224 2956032
15:08:26 57753 8192000000 10904355680 11383234560 1979717168 19.462 100 14 28 0 1996644784 12954608 3973008
15:09:30 42908 8192000000 10904296448 11372498944 1947111680 19.203 98 19 38 0 1964788416 12245856 5430880
15:10:32 43250 8192000000 10915417504 11379937280 1984646560 19.501 100 16 32 1 1997698640 9157680 3894400
15:11:27 46947 8192000000 10936629056 11380572160 1977172736 19.442 99 23 47 1 1991945280 8619456 6153088
15:12:22 57842 8192000000 10918413184 11383615488 1971910048 19.401 99 12 25 0 1982321904 7125664 3286192
15:13:28 25366 8192000000 10925034320 11375906816 1974387920 19.420 99 46 90 0 1998439008 11166016 12885072
15:14:13 73151 8192000000 10905847456 11370840064 1950102688 19.227 98 24 48 1 1974987616 17967056 6917872
15:15:36 113779 8192000000 10895518592 11370610688 1885246896 18.707 95 12 24 0 1910008704 21778048 2983760
15:17:36 132786 8192000000 10888482128 11346898944 1846077200 18.390 93 13 26 0 1860195536 10625984 3492352
15:19:55 79443 8192000000 10876161392 11334623232 1909638016 18.904 97 29 56 1 1924444288 6031216 8775056
15:21:20 90137 8192000000 10852229408 11321188352 1886598672 18.718 96 14 28 1 1898639264 8566272 3474320
15:22:57 42374 8192000000 10873786928 11335147520 1923888096 19.018 98 34 68 1 1943974736 10163840 9922800
15:23:45 53554 8192000000 10846537200 11326713856 1934517648 19.103 99 13 26 1 1944851200 6920624 3412928
15:24:59 36577 8192000000 10865540272 11341422592 1904128224 18.859 97 14 28 0 1914673904 6468464 4077216
15:25:44 54421 8192000000 10842720816 11313168384 1852616016 18.443 95 8 15 1 1862590544 7574224 2400304
15:26:45 48252 8192000000 10854564400 11320610816 1939458384 19.142 100 23 46 0 1954117792 8156928 6502480
15:27:42 49721 8192000000 10848762128 11330899968 1903045120 18.851 98 7 12 2 1912686256 8131664 1509472
15:28:39 47744 8192000000 10844630592 11305865216 1869627680 18.581 96 18 35 0 1881811840 7380112 4804048
15:29:39 32711 8192000000 10829459152 11295133696 1853938304 18.454 96 20 40 0 1867160304 7417792 5804208
15:30:18 31731 8192000000 10813535632 11271700480 1809496384 18.092 95 23 46 0 1825341360 9604864 6240112
15:30:58 28916 8192000000 10867180192 11316109312 1906029376 18.875 99 35 70 1 1928177776 11715104 10433296
15:31:33 55126 8192000000 10864011728 11324141568 1898205696 18.812 98 23 46 0 1919514512 14212176 7096640
15:32:35 49140 8192000000 10875220944 11345797120 1939851648 19.146 100 17 34 1 1963593648 18494816 5247184
15:33:31 49081 8192000000 10875306960 11321892864 1865443680 18.547 96 15 30 1 1881081248 11238240 4399328
15:34:28 22252 8192000000 10880274128 11329449984 1911228432 18.917 98 44 88 2 1933139152 9039168 12871552
15:35:01 76604 8192000000 10873252880 11338412032 1923090480 19.012 99 19 38 0 1939487392 11310704 5086208
15:36:26 46494 8192000000 10890803712 11349401600 1942595408 19.167 99 41 82 0 1965773424 11533008 11645008
15:37:33 19519 8192000000 10870545328 11320737792 1897475776 18.806 97 34 68 0 1915910480 8844448 9590256
15:37:59 30564 8192000000 10873369952 11321200640 1868772080 18.574 96 35 70 2 1888008432 9719744 9516608
15:38:39 95096 8192000000 10869154448 11328208896 1876135808 18.634 97 17 34 0 1895036400 14222320 4678272
15:40:20 107898 8192000000 10865070688 11315929088 1861221600 18.513 96 10 20 0 1879447312 15705312 2520400
15:42:17 75142 8192000000 10866255456 11334909952 1921498688 18.999 99 10 20 0 1938859040 14551696 2808656
15:43:52 93021 8192000000 10869335184 11332214784 1921522960 18.999 99 17 34 0 1936127296 10005280 4599056
15:45:34 64989 8192000000 10880049776 11365298176 1963329888 19.332 100 23 45 1 1983762176 13575248 6857040
15:46:45 28043 8192000000 10879174656 11365310464 1960101840 19.307 100 4 8 0 1975899072 14583552 1213680
15:47:20 14999 8192000000 10877486160 11364179968 1959966704 19.306 100 3 6 0 1974771200 13350272 1454224
15:47:41 32795 8192000000 10877424240 11356008448 1963949536 19.337 100 11 22 2 1979583696 12594816 3039344
15:48:25 28624 8192000000 10878924368 11354595328 1942324192 19.165 99 7 14 0 1951647856 7330288 1993376
15:49:03 92472 8192000000 10873354144 11338465280 1887125504 18.723 96 19 38 2 1907150608 14756384 5268720
15:50:42 60403 8192000000 10864150768 11347746816 1930766960 19.073 99 3 6 0 1941274256 9795968 711328
15:51:48 88010 8192000000 10883438016 11360751616 1926316704 19.037 98 23 45 2 1942440752 9357344 6766704
15:53:27 45919 8192000000 10895576112 11365363712 1969046976 19.378 100 26 52 2 1985077408 8551728 7478704
15:54:24 59215 8192000000 10844710032 11304472576 1830772656 18.266 93 19 38 1 1845526256 9932880 4820720
15:55:34 39490 8192000000 10874625888 11342114816 1945362400 19.190 100 25 49 0 1962105536 10219792 6523344
15:56:26 55466 8192000000 10898713280 11365273600 1921352912 18.998 98 20 40 2 1942416624 15060896 6002816
15:57:29 71975 8192000000 10885413264 11338448896 1933690560 19.096 98 19 37 1 1949518896 11072832 4755504
15:58:47 39244 8192000000 10908597456 11368878080 1930280624 19.069 98 12 24 0 1939999376 6850080 2868672
15:59:36 90903 8192000000 10905248976 11371765760 1924326032 19.021 97 10 20 0 1940730528 13710272 2694224
16:01:14 20783 8192000000 10921732240 11373858816 1965043168 19.346 99 36 72 0 1983416240 8689008 9684064
16:01:42 112405 8192000000 10891004048 11366674432 1883298768 18.692 95 24 48 0 1901116384 11868144 5949472
16:03:50 57498 8192000000 10913601536 11381788672 1951508576 19.238 99 21 42 1 1969029744 11823696 5697472
16:05:14 40012 8192000000 10902173552 11363590144 1951734720 19.240 99 40 80 0 1977760272 14806352 11219200
16:06:01 57625 8192000000 10902041472 11386953728 1968228784 19.371 100 20 40 2 1985851856 12066448 5556624
16:07:07 68137 8192000000 10898302864 11386257408 1964992432 19.346 100 3 6 0 1984278944 18706992 579520
16:08:29 98511 8192000000 10869411216 11331305472 1854573680 18.459 94 23 46 2 1875627296 14483504 6570112
16:10:14 29500 8192000000 10853192544 11326775296 1900067792 18.827 98 17 34 0 1920330096 15122352 5139952
16:11:02 47810 8192000000 10859593536 11331846144 1918118448 18.972 99 8 16 0 1933537856 13051600 2367808
16:12:03 49291 8192000000 10873655504 11352109056 1951745456 19.240 100 19 37 2 1967017888 10024448 5247984
16:13:05 51934 8192000000 10889400992 11348660224 1920724880 18.993 98 12 24 1 1936681680 12521808 3434992
16:14:03 99651 8192000000 10882419472 11369054208 1923020832 19.011 98 13 27 1 1941650784 14509648 4120304
16:15:49 45977 8192000000 10885646208 11385638912 1939440656 19.142 99 6 12 0 1961181856 19905280 1835920
16:17:16 40332 8192000000 10902571088 11373162496 1971941056 19.401 100 14 28 0 1989594816 13422240 4231520
16:18:06 40059 8192000000 10883949008 11351883776 1912090288 18.923 97 29 57 0 1935658000 14957440 8610272
16:18:52 41858 8192000000 10881538240 11345108992 1914624448 18.944 98 17 34 1 1937518192 18097584 4796160
16:19:41 53504 8192000000 10875215728 11339493376 1883035296 18.690 96 20 40 0 1903268432 14672592 5560544
16:20:41 87354 8192000000 10897393216 11372675072 1934636496 19.104 99 21 40 1 1961759904 20680080 6443328
16:22:21 54187 8192000000 10899262752 11358056448 1944546992 19.183 99 17 34 0 1966606336 16734256 5325088
16:23:21 39682 8192000000 10919274976 11379675136 1954116192 19.259 99 30 59 0 1980487328 17998000 8373136
16:24:55 91737 8192000000 10873718816 11328458752 1852273232 18.441 95 12 24 2 1873801056 18131536 3396288
16:26:34 46100 8192000000 9379237680 9663746048 524031968 6.012 27 9 18 0 532864144 6271296 2560880

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 20-12-2020 16:28:18 to 20-12-2020 16:28:48.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 20-12-2020 16:28:49 to 20-12-2020 16:28:50.

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          250806
MON$OLDEST_ACTIVE               252077
MON$OLDEST_SNAPSHOT             252077
MON$NEXT_TRANSACTION            252077
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                       2018816
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:138: 
:139: mscs-test-161.budzdorov.ru    Sun Dec 20 16:27:31 2020
:140:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:141: 
--- end of diff output ---

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

20.12.20 16:28:51. 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
2020-12-20 16:28:54 No severe PSQL-related problems occured
20.12.20 16:28:55. End of report.