Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.11.2020 22: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 17528016 kB
MemAvailable 31628828 kB
Buffers 0 kB
Cached 14124464 kB
SwapCached 1168 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-11-28 22:26:59
DTS_END                         2020-11-28 22:26:59.4310
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/55318
TRN_ID                          246603
ATT_ID                          697
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: 9434.17 23524 1132100
customer order: creation 178.68 347 21441
customer order: refuse 15.83 316 1900
order to supplier: creation 48.19 1221 5783
order to supplier: removal 3.48 101392 417
invoice (draft): creation 48.12 3121 5774
invoice (draft): removal 53.58 733 6430
invoice accept: apply 43.36 16742 5203
invoice accept: cancel 48.58 779 5829
customer reserve: creation 3995.77 166 479492
customer reserve: removal 4690.27 60 562832
realization accept: apply 87.98 152 10557
realization accept: cancel 86.68 108 10402
payment from customer: creation 61.71 108 7405
payment from customer: removal 6.28 96 753
payment to supplier: creation 49.00 122 5880
payment to supplier: removal 3.56 88 427
service: total inventory turnovers 5.18 980 621
service: total monetary turnovers 7.03 40 843
service: aggregate perf. data 0.89 20067 107
service: refresh index statistics 0.03 323840 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-11-2020 22:28:08 to 28-11-2020 22:28:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2777
TEST_TIME 2 3830
TEST_TIME 3 3512
TEST_TIME 4 3307
TEST_TIME 5 3808
TEST_TIME 6 4015
TEST_TIME 7 4427
TEST_TIME 8 4482
TEST_TIME 9 4869
TEST_TIME 10 4937
TEST_TIME 11 4931
TEST_TIME 12 5054
TEST_TIME 13 5066
TEST_TIME 14 5411
TEST_TIME 15 5403
TEST_TIME 16 5621
TEST_TIME 17 6060
TEST_TIME 18 6266
TEST_TIME 19 6547
TEST_TIME 20 7024
TEST_TIME 21 7889
TEST_TIME 22 8015
TEST_TIME 23 8498
TEST_TIME 24 9383
TEST_TIME 25 10143
TEST_TIME 26 10678
TEST_TIME 27 10557
TEST_TIME 28 10569
TEST_TIME 29 10535
TEST_TIME 30 10474
TEST_TIME 31 10374
TEST_TIME 32 10180
TEST_TIME 33 10095
TEST_TIME 34 9919
TEST_TIME 35 9931
TEST_TIME 36 9825
TEST_TIME 37 9828
TEST_TIME 38 9706
TEST_TIME 39 9678
TEST_TIME 40 9818
TEST_TIME 41 9828
TEST_TIME 42 9674
TEST_TIME 43 9580
TEST_TIME 44 9602
TEST_TIME 45 9710
TEST_TIME 46 9597
TEST_TIME 47 9610
TEST_TIME 48 9646
TEST_TIME 49 9672
TEST_TIME 50 9600
TEST_TIME 51 9772
TEST_TIME 52 9804
TEST_TIME 53 9857
TEST_TIME 54 9795
TEST_TIME 55 9755
TEST_TIME 56 9790
TEST_TIME 57 9756
TEST_TIME 58 9917
TEST_TIME 59 9853
TEST_TIME 60 9725
TEST_TIME 61 9705
TEST_TIME 62 9633
TEST_TIME 63 9634
TEST_TIME 64 9636
TEST_TIME 65 9580
TEST_TIME 66 9628
TEST_TIME 67 9633
TEST_TIME 68 9564
TEST_TIME 69 9541
TEST_TIME 70 9540
TEST_TIME 71 9613
TEST_TIME 72 9674
TEST_TIME 73 9625
TEST_TIME 74 9673
TEST_TIME 75 9651
TEST_TIME 76 9688
TEST_TIME 77 9823
TEST_TIME 78 9818
TEST_TIME 79 9898
TEST_TIME 80 9926
TEST_TIME 81 9825
TEST_TIME 82 9771
TEST_TIME 83 9756
TEST_TIME 84 9734
TEST_TIME 85 9686
TEST_TIME 86 9652
TEST_TIME 87 9624
TEST_TIME 88 9595
TEST_TIME 89 9550
TEST_TIME 90 9530
TEST_TIME 91 9463
TEST_TIME 92 9506
TEST_TIME 93 9502
TEST_TIME 94 9508
TEST_TIME 95 9532
TEST_TIME 96 9517
TEST_TIME 97 9527
TEST_TIME 98 9498
TEST_TIME 99 9611
TEST_TIME 100 9575
TEST_TIME 101 9599
TEST_TIME 102 9655
TEST_TIME 103 9661
TEST_TIME 104 9667
TEST_TIME 105 9622
TEST_TIME 106 9680
TEST_TIME 107 9675
TEST_TIME 108 9590
TEST_TIME 109 9566
TEST_TIME 110 9536
TEST_TIME 111 9555
TEST_TIME 112 9516
TEST_TIME 113 9470
TEST_TIME 114 9439
TEST_TIME 115 9443
TEST_TIME 116 9417
TEST_TIME 117 9389
TEST_TIME 118 9379
TEST_TIME 119 9427
TEST_TIME 120 9440
TEST_TIME 121 9362

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 28-11-2020 22:28:11 to 28-11-2020 22:28:15.

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 1575210 1575210 0 0.00 0 15540 6 0 0
doc_list_biud 1575180 1575180 0 0.00 0 45829 27 0 0
sp_add_invoice_to_stock 5309 5203 106 1.99 34 183294 16743 0 106
sp_cancel_adding_invoice 5829 5829 0 0.00 4 67582 780 0 0
sp_cancel_client_order 1900 1900 0 0.00 4 8970 316 0 0
sp_cancel_customer_reserve 562832 562832 0 0.00 1 45830 60 0 0
sp_cancel_pay_from_customer 753 753 0 0.00 3 5233 96 0 0
sp_cancel_pay_to_supplier 427 427 0 0.00 3 6385 89 0 0
sp_cancel_supplier_invoice 6437 6430 7 0.10 1 20166 733 0 7
sp_cancel_supplier_order 417 417 0 0.00 7 950769 101393 0 0
sp_cancel_write_off 10402 10402 0 0.00 1 11913 109 0 0
sp_client_order 21441 21441 0 0.00 3 45160 348 0 0
sp_customer_reserve 479492 479492 0 0.00 0 83820 167 0 0
sp_fill_shopping_cart 32994 32994 0 0.00 1 14088 35 0 0
sp_fill_shopping_cart_clo_res 479488 479488 0 0.00 0 11720 13 0 0
sp_get_clo_for_invoice 5198 5198 0 0.00 0 22817 280 0 0
sp_kill_cost_storno 17411 17411 0 0.00 0 10050 56 0 0
sp_kill_qstorno_ret_qs2qd 1142913 1142913 0 0.00 0 45826 32 0 0
sp_kill_qty_storno 603547 603547 0 0.00 0 45829 69 0 0
sp_lock_selected_doc 21908 21908 0 0.00 0 9932 5 0 0
sp_make_cost_storno 29040 29040 0 0.00 0 13242 55 0 0
sp_multiply_rows_for_pdistr 29010 29010 0 0.00 0 6271 25 0 0
sp_multiply_rows_for_qdistr 21441 21441 0 0.00 0 36947 172 0 0
sp_pay_from_customer 7405 7405 0 0.00 4 8792 109 0 0
sp_pay_to_supplier 5880 5880 0 0.00 4 15402 122 0 0
sp_payment_common 13273 13273 0 0.00 1 15356 26 0 0
sp_qd_handle_on_cancel_clo 1900 1900 0 0.00 0 8959 294 0 0
sp_qd_handle_on_invoice_upd_sts 11020 11020 0 0.00 0 26818 305 0 0
sp_qd_handle_on_reserve_upd_sts 10546 10546 0 0.00 0 13806 45 0 0
sp_reserve_write_off 10557 10557 0 0.00 6 13821 152 0 0
sp_supplier_invoice 5774 5774 0 0.00 6 93509 3122 0 0
sp_supplier_order 5783 5783 0 0.00 5 57839 1222 0 0
srv_aggregate_perf_data 107 107 0 0.00 1850 385993 20068 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 914 150244 32408 0 0
srv_find_qd_qs_mism 1082140 1082140 0 0.00 0 15539 5 0 0
srv_make_invnt_saldo 621 621 0 0.00 23 49841 980 0 0
srv_make_money_saldo 843 843 0 0.00 0 14513 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 261117 359718 323841 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5204 5204 0 0.00 0 9960 153 0 0
t$perf-norm:sp_cancel_adding_invoice 468 468 0 0.00 0 3728 122 0 0
t$perf-norm:sp_cancel_client_order 1900 1900 0 0.00 0 2995 12 0 0
t$perf-norm:sp_cancel_customer_reserve 727 727 0 0.00 0 3685 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 753 753 0 0.00 0 3938 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 427 427 0 0.00 0 3054 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 427 427 0 0.00 0 3202 30 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 22603 1342 0 0
t$perf-norm:sp_cancel_write_off 1052 1052 0 0.00 0 4322 16 0 0
t$perf-norm:sp_client_order 21441 21441 0 0.00 0 5227 14 0 0
t$perf-norm:sp_customer_reserve 1011 1011 0 0.00 0 3387 10 0 0
t$perf-norm:sp_pay_from_customer 7405 7405 0 0.00 0 4712 8 0 0
t$perf-norm:sp_pay_to_supplier 5880 5880 0 0.00 0 6993 11 0 0
t$perf-norm:sp_reserve_write_off 10557 10557 0 0.00 0 5826 10 0 0
t$perf-norm:sp_supplier_invoice 5774 5774 0 0.00 0 7939 19 0 0
t$perf-norm:sp_supplier_order 5783 5783 0 0.00 0 4586 14 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 257 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 2650 24 0 0
t$perf-norm:srv_make_invnt_saldo 621 621 0 0.00 0 3937 25 0 0
t$perf-norm:srv_make_money_saldo 843 843 0 0.00 0 883 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10594 10382 212 2.00 0 5588 16 0 212
v_all_customers 39426 39426 0 0.00 0 23 1 0 0
v_all_suppliers 31594 31594 0 0.00 0 19 1 0 0
v_all_wares 42880 42880 0 0.00 0 213 1 0 0
v_cancel_adding_invoice 936 936 0 0.00 0 1329 7 0 0
v_cancel_client_order 3800 3800 0 0.00 0 3602 6 0 0
v_cancel_customer_prepayment 1506 1506 0 0.00 0 3874 16 0 0
v_cancel_customer_reserve 1454 1454 0 0.00 0 838 4 0 0
v_cancel_payment_to_supplier 854 854 0 0.00 0 5028 13 0 0
v_cancel_supplier_invoice 868 854 14 1.61 0 788 14 0 14
v_cancel_supplier_order 834 834 0 0.00 0 489 5 0 0
v_cancel_write_off 2104 2104 0 0.00 0 4940 15 0 0
v_max_id_clo_ord 5780 5780 0 0.00 0 1202 1 0 0
v_max_id_clo_res 1011 1011 0 0.00 0 4009 19 0 0
v_max_id_ord_sup 5774 5774 0 0.00 0 4011 2 0 0
v_max_non_paid_invoice 1630 1630 0 0.00 0 3435 4 0 0
v_max_non_paid_realizn 3803 3803 0 0.00 0 6272 4 0 0
v_min_id_clo_ord 5780 5780 0 0.00 0 3508 6 0 0
v_min_id_clo_res 1011 1011 0 0.00 0 4119 7 0 0
v_min_id_ord_sup 5774 5774 0 0.00 0 4253 7 0 0
v_min_non_paid_invoice 5873 5873 0 0.00 0 15352 17 0 0
v_min_non_paid_realizn 7398 7398 0 0.00 0 8760 16 0 0
v_our_firm 10644 10644 0 0.00 0 11 1 0 0
v_reserve_write_off 21092 21092 0 0.00 0 5098 6 0 0
x_lock_depdocs_on_canc_invoice 11832 11832 0 0.00 0 24855 105 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 16662 323 0 0
x_make_qstorno_1000_1200 5783 5783 0 0.00 1 57831 1148 0 0
x_make_qstorno_1200_2000 5774 5774 0 0.00 3 81702 2997 0 0
x_make_qstorno_2100_3300 479492 479492 0 0.00 0 83820 152 0 0

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

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
19:57:03 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:09 3767 8192000000 9830421616 10061070336 703359952 7.907 58 41 85 0 719755040 1961536 14433552
19:57:21 30086 8192000000 10304984864 10622476288 1352025472 14.166 100 83 167 0 1383913376 4345024 27542880
19:57:59 20226 8192000000 10349065952 10667044864 1405234656 14.642 100 88 176 0 1439371904 5523552 28613696
19:58:28 16825 8192000000 10371278576 10692128768 1424779264 14.815 100 89 178 0 1460482336 6552304 29150768
19:58:54 20126 8192000000 10392174496 10714902528 1433798256 14.895 100 84 168 0 1468439552 7162480 27478816
19:59:24 18434 8192000000 10414293440 10743005184 1462576432 15.149 100 88 176 0 1498700816 7655904 28468480
19:59:55 19299 8192000000 10435550224 10768973824 1488943072 15.380 100 84 168 1 1524043024 8351440 26748512
20:00:31 21343 8192000000 10468068576 10808176640 1516078096 15.616 100 88 176 0 1553342160 8902976 28361088
20:01:03 19850 8192000000 10498094000 10840788992 1543028480 15.850 100 81 163 0 1577617728 9089088 25500160
20:01:31 11331 8192000000 10516905056 10866229248 1565957408 16.048 100 79 158 2 1600223536 9860080 24406048
20:01:54 18076 8192000000 10540334352 10892832768 1599650944 16.336 100 81 162 0 1635148480 10679408 24818128
20:02:22 17628 8192000000 10571336592 10932150272 1632351952 16.615 100 79 156 1 1667024112 11284144 23388016
20:02:47 12939 8192000000 10590024864 10954088448 1648971984 16.756 100 79 158 2 1684067872 11307216 23788672
20:03:09 9178 8192000000 10603108000 10966921216 1660928272 16.857 100 78 156 1 1695737776 11766544 23042960
20:03:34 11275 8192000000 10621581600 10992463872 1683954256 17.051 100 75 150 0 1717719024 12015360 21749408
20:03:52 12567 8192000000 10637747184 11010289664 1697290976 17.162 100 67 134 0 1728120944 11481536 19348432
20:04:13 8592 8192000000 10655048656 11028201472 1722487968 17.373 100 77 154 1 1757708896 12541072 22679856
20:04:31 6058 8192000000 10673778096 11047772160 1733336880 17.463 100 76 151 0 1767085872 12450000 21298992
20:04:44 7260 8192000000 10685608928 11065389056 1744452944 17.556 100 72 144 2 1777988256 12465072 21070240
20:04:58 5854 8192000000 10693042592 11073306624 1756607408 17.656 100 72 145 1 1789766560 12944928 20214224
20:05:12 4423 8192000000 10702157936 11081080832 1767956912 17.750 100 82 164 0 1804786704 12836864 23992928
20:05:26 4990 8192000000 10712612528 11094921216 1777585584 17.830 100 74 146 3 1810695296 12759056 20350656
20:05:38 4969 8192000000 10722133216 11107135488 1790843856 17.939 100 83 166 0 1827478032 13075088 23559088
20:05:51 10852 8192000000 10731149568 11119120384 1795369696 17.976 100 65 131 0 1825617072 12428896 17818480
20:06:09 2966 8192000000 10742801312 11132461056 1798112688 17.998 100 66 131 0 1829182784 11871616 19198480
20:06:18 3258 8192000000 10757280528 11146833920 1819357264 18.172 100 82 164 0 1855808064 12872576 23578224
20:06:28 2592 8192000000 10760143072 11150209024 1824200160 18.212 100 81 159 0 1858259392 11778560 22280672
20:06:37 2228 8192000000 10765729216 11151679488 1832209376 18.277 100 83 167 0 1867675936 12440176 23026384
20:06:46 3338 8192000000 10769104912 11157155840 1834696704 18.298 100 85 170 0 1871427056 13512192 23218160
20:06:56 2276 8192000000 10782964272 11167371264 1834439424 18.296 100 86 170 2 1872497296 14117728 23940144
20:07:05 2177 8192000000 10770015776 11156226048 1837732304 18.322 100 80 160 2 1874042752 13906896 22403552
20:07:14 2093 8192000000 10785703696 11171991552 1844383728 18.376 100 94 186 1 1884510672 14131312 25995632
20:07:23 1390 8192000000 10782681248 11167625216 1842469584 18.361 100 89 178 2 1881801904 14598256 24734064
20:07:31 2596 8192000000 10785943264 11174125568 1846026480 18.390 100 82 163 1 1881768960 12950368 22792112
20:07:41 2020 8192000000 10796007424 11182620672 1850744464 18.428 100 93 185 0 1890350400 13102704 26503232
20:07:49 4246 8192000000 10798588720 11182657536 1852105184 18.439 100 90 180 1 1891615984 13485248 26025552
20:08:00 2289 8192000000 10792033648 11182153728 1851321760 18.433 100 80 158 3 1886655776 13285424 22048592
20:08:09 1661 8192000000 10801783488 11190366208 1858049968 18.487 100 91 182 1 1897619552 13739392 25830192
20:08:17 1666 8192000000 10801694352 11191607296 1858868736 18.494 100 87 173 2 1895671744 12602352 24200656
20:08:25 43195 8192000000 10782029504 11185942528 1856933760 18.478 100 42 83 0 1877936416 8838128 12164528
20:09:14 9834 8192000000 10790337200 11198582784 1867852176 18.567 100 64 128 1 1896193216 9889072 18451968
20:09:30 10208 8192000000 10776769056 11200241664 1865992672 18.552 100 37 74 0 1886173984 9633664 10547648
20:09:51 8303 8192000000 10782574848 11202453504 1868230720 18.570 100 27 54 1 1883396656 7187344 7978592
20:10:07 3739 8192000000 10778027264 11201601536 1867267888 18.562 100 29 56 1 1882402512 7042976 8091648
20:10:17 5479 8192000000 10787787472 11208294400 1871774912 18.599 100 30 60 1 1887755184 7721040 8259232
20:10:30 10012 8192000000 10786063472 11212390400 1875814864 18.631 100 30 62 1 1891560208 7039920 8705424
20:10:47 7837 8192000000 10789329456 11211259904 1876537088 18.637 100 20 39 0 1888043136 6020448 5485600
20:11:02 6871 8192000000 10798895184 11219120128 1882676736 18.687 100 37 73 1 1899996768 6577776 10742256
20:11:17 5513 8192000000 10798503168 11226542080 1890455952 18.749 100 44 89 1 1914126528 10618304 13052272
20:11:29 5433 8192000000 10794699952 11218210816 1885626272 18.711 100 30 61 1 1900865536 6403520 8835744
20:11:41 12417 8192000000 10787497872 11223314432 1885544944 18.710 100 13 26 2 1894639248 5513984 3580320
20:12:00 6912 8192000000 10802644832 11229372416 1888794960 18.736 100 23 46 4 1901637216 6325536 6516720
20:12:14 11301 8192000000 10791121088 11227631616 1890137568 18.747 100 13 26 1 1899418464 5512304 3768592
20:12:32 9944 8192000000 10798325088 11231047680 1893025440 18.770 100 12 24 1 1901925952 5532688 3367824
20:12:48 10878 8192000000 10798866048 11235618816 1898325504 18.813 100 20 40 2 1909544816 5393824 5825488
20:13:05 64530 8192000000 10836776672 11253002240 1903934432 18.858 100 38 76 2 1924049680 9439824 10675424
20:14:16 8568 8192000000 10827200320 11255226368 1903293152 18.853 100 31 62 1 1920472816 8640016 8539648
20:14:31 6121 8192000000 10821563728 11249868800 1903776960 18.857 100 26 52 3 1917545568 6354640 7413968
20:14:44 5324 8192000000 10820350944 11257286656 1906438880 18.878 100 27 54 0 1924064880 10016320 7609680
20:14:56 3800 8192000000 10823532144 11257913344 1909999088 18.907 100 38 75 2 1927699024 7558688 10141248
20:15:08 7567 8192000000 10832422128 11264565248 1917150736 18.964 100 35 70 0 1934171488 7129872 9890880
20:15:25 6218 8192000000 10836449696 11268886528 1914806976 18.945 100 20 40 2 1930614688 10346816 5460896
20:15:41 10862 8192000000 10831349968 11263332352 1901558752 18.839 99 25 50 2 1918984864 9854736 7571376
20:15:58 7206 8192000000 10806115904 11239669760 1857627264 18.484 97 24 48 1 1870248560 5648208 6973088
20:16:13 5993 8192000000 10811200800 11238780928 1863365408 18.531 98 24 48 3 1876394896 5768960 7260528
20:16:27 9804 8192000000 10810206176 11243343872 1894408064 18.781 100 27 54 2 1908863664 6527904 7927696
20:16:45 9158 8192000000 10803492048 11236196352 1875058896 18.625 99 18 36 2 1890063280 9877936 5126448
20:17:00 9514 8192000000 10808328016 11240898560 1893041120 18.770 100 21 42 3 1905477088 5495904 6940064
20:17:16 16298 8192000000 10806477984 11217518592 1822625984 18.199 96 20 38 1 1833134272 4694528 5813760
20:17:38 60876 8192000000 10746321184 11182096384 1767620048 17.747 94 30 58 0 1781616800 5401568 8595184
20:18:47 9742 8192000000 10739445712 11162853376 1766352032 17.737 95 22 44 3 1778857008 6574752 5930224
20:19:06 8140 8192000000 10729323776 11152478208 1787473120 17.911 98 16 32 1 1801556272 9530560 4552592
20:19:21 5797 8192000000 10750222496 11172171776 1799436512 18.009 98 30 60 1 1818651584 10599136 8615936
20:19:33 9540 8192000000 10700503792 11115896832 1728654752 17.424 94 24 46 1 1745199472 9341712 7203008
20:19:49 9124 8192000000 10704511152 11121537024 1776791680 17.823 99 23 46 1 1788802192 5759040 6251472
20:20:05 8717 8192000000 10693370288 11112853504 1742116800 17.536 97 20 39 2 1753407552 5126880 6163872
20:20:21 8628 8192000000 10690444112 11097915392 1705534816 17.231 95 25 52 1 1717052688 4343536 7174336
20:20:39 9775 8192000000 10678165840 11090440192 1705309680 17.230 96 33 66 1 1722199232 5955856 10933696
20:21:01 6674 8192000000 10687066576 11107799040 1752559648 17.623 98 25 50 0 1765785744 5577424 7648672
20:21:14 9176 8192000000 10709814592 11129925632 1788692608 17.921 100 23 46 1 1800945696 4965392 7287696
20:21:32 6864 8192000000 10742081744 11153178624 1813137792 18.122 100 36 70 2 1831877040 9092848 9646400
20:21:47 13396 8192000000 10726746032 11149357056 1768026816 17.751 97 15 30 3 1776584400 5010784 3546800
20:22:07 61003 8192000000 10760807264 11169087488 1828819696 18.250 100 37 73 0 1845589424 5171312 11598416
20:23:21 11502 8192000000 10736439872 11166670848 1821123024 18.187 99 19 38 1 1831622320 5220032 5279264
20:23:39 11359 8192000000 10773291152 11188977664 1845956256 18.389 100 17 34 2 1856613504 5916672 4740576
20:23:58 4470 8192000000 10776583408 11200348160 1853072432 18.447 100 23 43 1 1865989936 6598480 6319024
20:24:10 11892 8192000000 10780328336 11203145728 1856286160 18.473 100 19 38 0 1867889632 5857184 5746288
20:24:29 6490 8192000000 10783417472 11205672960 1863842864 18.534 100 35 70 1 1881330688 7432496 10055328
20:24:42 10033 8192000000 10782279648 11212058624 1862512704 18.524 100 28 55 3 1881097216 10046320 8538192
20:25:00 8602 8192000000 10776576768 11206713344 1864477360 18.540 100 34 68 3 1880470128 5586784 10405984
20:25:19 9967 8192000000 10787130816 11217059840 1867242096 18.562 100 27 55 3 1884765808 9916816 7606896
20:25:37 10635 8192000000 10791178320 11217047552 1874681120 18.622 100 33 64 2 1889524800 5334656 9509024
20:25:54 12124 8192000000 10798154304 11221831680 1872575088 18.605 100 30 60 1 1887611520 5464832 9571600
20:26:14 8665 8192000000 10795044160 11221200896 1872267888 18.603 100 22 43 5 1884230544 5922080 6040576
20:26:31 16478 8192000000 10786856096 11220701184 1875761952 18.631 100 14 28 0 1884849120 5243248 3843920
20:26:55 10604 8192000000 10817809328 11233714176 1887221680 18.723 100 40 76 3 1903849232 5047312 11580240
20:27:13 16272 8192000000 10838105904 11252310016 1905247936 18.868 100 46 92 0 1924854416 6798496 12807984
20:27:40 57867 8192000000 10832938160 11265839104 1916782784 18.961 100 43 87 0 1936732848 7868864 12081200
20:28:53 46536 8192000000 10862802080 11291275264 1930796096 19.073 100 34 67 2 1947910112 5969808 11144208
20:29:48 30437 8192000000 10877282352 11302526976 1945724352 19.192 100 48 96 0 1971398336 13058672 12615312
20:30:28 13994 8192000000 10878701616 11305709568 1949392688 19.222 100 53 106 3 1977018176 13380832 14244656
20:30:52 15181 8192000000 10895388720 11320147968 1956244544 19.276 100 52 105 1 1982807296 12528848 14033904
20:31:26 9222 8192000000 10893100752 11326341120 1961597200 19.319 100 39 78 0 1985651008 12375200 11678608
20:31:43 12000 8192000000 10912033760 11340713984 1965409904 19.349 100 46 92 2 1991996736 13769568 12817264
20:32:03 20390 8192000000 10912847808 11346542592 1975253712 19.427 100 56 111 1 2010126992 18646512 16226768
20:32:35 10776 8192000000 10911665520 11347869696 1980392144 19.468 100 49 95 2 2012696640 18103824 14200672
20:32:57 5793 8192000000 10931369776 11358683136 1985093904 19.505 100 47 95 1 2018988048 19256736 14637408
20:33:09 15455 8192000000 10924910512 11360837632 1991530864 19.556 100 55 108 3 2026093776 18463856 16099056
20:33:33 20362 8192000000 10926257312 11363172352 1956938592 19.282 98 51 102 0 1995043280 22791824 15312864
20:34:07 7014 8192000000 10941307936 11373481984 1994928896 19.583 100 53 106 1 2034060656 23268176 15863584
20:34:39 16444 8192000000 10952160416 11382059008 1997182320 19.601 100 51 101 0 2039251136 27133648 14935168
20:35:03 21631 8192000000 10953021984 11392565248 2003757536 19.652 100 43 85 1 2047035504 29665216 13612752
20:35:33 15500 8192000000 10949603760 11391488000 1985369616 19.507 99 45 90 2 2028439056 29416560 13652880
20:35:59 9497 8192000000 10950311248 11388047360 1988149520 19.529 99 48 94 0 2032075184 29938000 13987664
20:36:16 6909 8192000000 10948386352 11385954304 1980881392 19.472 99 49 98 0 2026427728 30361264 15185072
20:36:35 9446 8192000000 10962031456 11394830336 2003799424 19.653 100 56 110 0 2052016368 31624384 16592560
20:36:52 12149 8192000000 10967835360 11399741440 2008942896 19.693 100 55 110 1 2058193760 32483104 16767760
20:37:12 5005 8192000000 10976656432 11403149312 2009862208 19.700 100 69 133 3 2063780496 34582560 19335728
20:37:26 6327 8192000000 10981549376 11410423808 2013583344 19.730 100 64 124 0 2067891984 35959872 18348768
20:37:41 3523 8192000000 10974325776 11397160960 1998971328 19.615 99 63 125 2 2056298816 38712000 18615488
20:37:53 5833 8192000000 10993061584 11419574272 2018465296 19.768 100 65 130 1 2077508384 39459360 19583728
20:38:06 8347 8192000000 10994361328 11423227904 2022449920 19.799 100 60 116 1 2080076400 39829216 17797264
20:38:20 2175 8192000000 11002446832 11428732928 2027827536 19.842 100 74 147 2 2091090032 40957072 22305424
20:38:30 7580 8192000000 10991207152 11417751552 2003498544 19.650 99 75 150 1 2067580720 41804912 22277264
20:38:49 5159 8192000000 10976757136 11403751424 2006541568 19.674 100 67 133 2 2067926672 41241168 20143936
20:39:04 7336 8192000000 10997624416 11418484736 2000312272 19.625 99 68 136 1 2064646304 43801344 20532688
20:39:21 7634 8192000000 10997510000 11420921856 2014985248 19.741 100 68 137 0 2083669504 47516976 21167280
20:39:40 5212 8192000000 10990552032 11411714048 1993832176 19.574 99 69 134 4 2061102032 47000928 20268928
20:39:53 4709 8192000000 10996613088 11416371200 1999432880 19.618 99 73 144 0 2070744128 48573520 22737728
20:40:14 6821 8192000000 10989115232 11413757952 2009467776 19.697 100 64 126 2 2080122832 50463936 20191120
20:40:33 6707 8192000000 10988363152 11414429696 2005487504 19.666 100 62 123 1 2074474928 49292064 19695360
20:40:49 4317 8192000000 10988374384 11409461248 1990811136 19.550 99 64 127 1 2060942912 50048912 20082864
20:41:02 4738 8192000000 10978724336 11395432448 1989185088 19.537 100 77 151 3 2063049568 50324224 23540256
20:41:14 3932 8192000000 10987138176 11405213696 2000419568 19.626 100 78 156 2 2073323840 48783568 24120704
20:41:26 5926 8192000000 10987033584 11403878400 1997007440 19.599 100 73 146 2 2069467760 50223888 22236432
20:41:38 2389 8192000000 10997547104 11415457792 2010060080 19.702 100 83 166 1 2086545856 50595136 25890640
20:41:47 2708 8192000000 11008476480 11422953472 2016961920 19.756 100 84 167 1 2094389472 51236304 26191248
20:42:00 2510 8192000000 11003702096 11413671936 1993393840 19.571 99 83 168 3 2070694752 52002752 25298160
20:42:09 2849 8192000000 10991185712 11402088448 1970466320 19.389 98 83 163 1 2049460752 53753728 25240704
20:42:20 1718 8192000000 10981404352 11391221760 1958107232 19.291 98 83 166 2 2036891360 53393840 25390288
20:42:30 914 8192000000 10966357856 11370909696 1965591008 19.350 99 82 163 2 2047678176 56146304 25940864
20:42:40 3860 8192000000 10941432896 11351867392 1948092144 19.211 100 81 162 1 2030888720 56638336 26158240
20:42:51 1853 8192000000 10970655936 11371048960 1955522400 19.270 100 90 180 0 2042393568 58449040 28422128
20:43:00 1805 8192000000 10974691792 11383648256 1970286544 19.388 100 86 168 1 2056370320 58945744 27138032
20:43:11 2767 8192000000 10988911696 11395268608 1979645520 19.462 100 84 168 4 2066588944 59548368 27395056
20:43:21 3080 8192000000 10972174160 11380854784 1967897904 19.369 100 74 149 1 2055690016 63477568 24314544
20:43:32 1317 8192000000 10989423920 11392290816 1977991824 19.449 100 85 171 0 2066181696 61624704 26565168
20:43:43 2529 8192000000 10967856000 11379716096 1949553680 19.223 98 88 173 1 2039696768 61312224 28830864
20:43:54 1606 8192000000 10989763280 11393949696 1981628832 19.478 100 85 170 0 2070405408 61374624 27401952
20:44:02 4895 8192000000 10989035840 11395416064 1978595200 19.454 100 89 177 3 2069575456 62660864 28319392
20:44:13 2802 8192000000 10996821344 11406467072 1983743056 19.494 100 87 173 0 2077789776 65651408 28395312
20:44:23 2714 8192000000 10974147616 11383263232 1963728688 19.336 100 83 165 0 2057122352 67156464 26237200
20:44:33 1234 8192000000 10995333344 11401617408 1981163872 19.474 100 87 171 0 2076637392 67923536 27549984
20:44:41 1619 8192000000 11000698448 11406999552 1987304592 19.522 100 90 179 2 2085651056 69682272 28664192
20:44:50 2791 8192000000 10985482496 11392241664 1970759696 19.391 100 84 167 0 2066667920 68978768 26929456
20:45:02 1186 8192000000 10986771888 11396501504 1972414800 19.405 100 87 171 0 2069232720 69336144 27481776
20:45:12 2427 8192000000 10981252128 11400871936 1969051696 19.378 100 77 154 2 2065477472 70933808 25491968
20:45:24 6584 8192000000 10959647680 11382685696 1960381792 19.309 100 65 128 1 2046549728 64886480 21281456
20:45:40 2491 8192000000 10982983168 11394854912 1970682880 19.391 100 82 164 3 2064017840 67848704 25486256
20:45:52 1619 8192000000 10987241600 11389243392 1967604720 19.366 100 95 189 1 2068459872 70489952 30365200
20:46:00 2436 8192000000 10997348208 11401904128 1974087744 19.418 100 89 178 3 2075686448 72898304 28700400
20:46:10 2009 8192000000 10980725024 11405688832 1971697088 19.399 100 70 140 1 2066434192 71340704 23396400
20:46:22 4644 8192000000 10976053248 11401134080 1971909936 19.401 100 61 123 0 2058565888 66395584 20260368
20:46:37 15087 8192000000 10966027840 11396325376 1950755872 19.232 99 43 86 0 2032180176 66210672 15213632
20:46:58 6129 8192000000 10958172272 11400593408 1966064560 19.354 100 34 68 2 2047869200 69842240 11962400
20:47:12 15266 8192000000 10944121600 11384008704 1942694288 19.168 99 35 70 0 2016185712 61785136 11706288
20:47:51 21410 8192000000 10952639920 11397345280 1969825296 19.384 100 38 76 1 2036731072 53861376 13044400
20:48:19 32870 8192000000 10957177808 11400040448 1969188896 19.379 100 35 70 4 2037822064 56148144 12485024
20:49:03 19071 8192000000 10946469680 11403075584 1952600288 19.247 99 29 57 0 2024725600 61779984 10345328
20:49:32 16786 8192000000 10913326704 11362418688 1903423120 18.854 97 28 56 1 1971405152 57385472 10596560
20:50:09 33887 8192000000 10897610592 11364409344 1913593504 18.935 99 20 40 2 1975242704 53988720 7660480
20:51:35 30644 8192000000 10883252096 11350867968 1922751280 19.009 100 16 32 0 1972424416 44017328 5655808
20:52:24 47702 8192000000 10858841648 11333992448 1912791328 18.929 99 13 26 2 1936994848 20480304 3723216
20:53:26 22371 8192000000 10888514688 11329069056 1917796992 18.969 99 26 52 2 1938186928 12448560 7941376
20:53:56 63363 8192000000 10882974768 11348668416 1918939136 18.978 99 28 56 1 1945330800 17648368 8743296
20:55:15 37024 8192000000 10870762864 11335163904 1938389136 19.134 100 22 42 2 1957338336 13654176 5295024
20:55:59 41634 8192000000 10870865968 11329331200 1930304336 19.069 99 27 55 0 1944142928 6207424 7631168
20:56:47 58783 8192000000 10856845632 11308478464 1856723456 18.477 95 29 54 2 1870457328 5993552 7740320
20:57:52 50008 8192000000 10876489440 11305713664 1863881856 18.535 96 20 40 0 1878894864 9685760 5327248
20:58:57 111761 8192000000 10872025664 11321659392 1933351056 19.094 99 53 106 0 1962764096 13281840 16131200
21:01:20 106081 8192000000 10850341312 11300405248 1880162224 18.666 97 19 38 1 1897008176 11857440 4988512
21:03:13 24349 8192000000 10860675840 11318747136 1919326992 18.981 99 37 76 3 1941192224 10953104 10912128
21:03:44 44856 8192000000 10905700400 11344117760 1945307088 19.189 100 29 58 1 1968165440 14467216 8391136
21:04:55 41095 8192000000 10917723952 11360354304 1962886976 19.329 100 39 78 1 1995238672 21127568 11224128
21:05:45 34352 8192000000 10878958624 11339423744 1942631952 19.168 99 31 62 1 1966482336 15187792 8662592
21:06:29 49383 8192000000 10889658544 11357270016 1941903536 19.162 99 23 46 1 1965321312 16441792 6975984
21:08:32 74901 8192000000 10909392464 11375398912 1978014144 19.449 100 15 30 0 1995246736 13432096 3800496
21:10:08 73705 8192000000 10901207152 11358470144 1961675408 19.319 99 12 24 0 1982115344 16602208 3837728
21:11:28 46027 8192000000 10884777200 11365797888 1964906624 19.345 100 11 22 1 1976230624 8536144 2787856
21:12:22 39184 8192000000 10918665008 11375280128 1984866480 19.503 100 39 78 1 2003229392 6835520 11527392
21:13:16 63530 8192000000 10915120992 11387387904 1955467776 19.270 98 17 34 0 1973495184 13320800 4706608
21:14:29 54413 8192000000 10915703440 11371220992 1962086528 19.323 99 20 40 1 1981201920 13130192 5985200
21:15:39 69163 8192000000 10934332736 11392065536 1952290336 19.245 98 18 36 1 1967575824 10219552 5065936
21:18:11 111946 8192000000 10899466304 11381276672 1912473216 18.926 96 10 20 0 1928435408 13424256 2537936
21:20:09 90436 8192000000 10897242000 11357011968 1878214832 18.651 95 15 30 1 1894748208 12802304 3731072
21:21:47 81601 8192000000 10872831984 11339849728 1819189632 18.171 92 21 42 2 1834793936 9571728 6032576
21:23:22 70627 8192000000 10875674592 11353731072 1896718656 18.800 97 10 19 1 1917559088 18016960 2823472
21:24:40 92445 8192000000 10861834112 11328012288 1843545760 18.370 95 12 24 0 1859493872 12500528 3447584
21:26:45 119795 8192000000 10868558112 11329691648 1872920896 18.608 96 21 42 0 1893422384 14314704 6186784
21:29:07 40279 8192000000 10851384928 11318890496 1906911168 18.882 99 30 60 3 1931487504 15773664 8802672
21:30:53 40126 8192000000 10845783920 11317035008 1906873840 18.882 99 8 16 0 1916668192 7696000 2098352
21:31:39 45798 8192000000 10854702080 11334848512 1918432304 18.974 99 8 16 0 1931648832 11077888 2138640
21:32:43 41920 8192000000 10867416928 11323285504 1871022976 18.593 96 13 26 0 1882162176 6873712 4265488
21:33:32 41714 8192000000 10874924288 11339919360 1929628032 19.064 99 24 48 3 1943253856 7363104 6262720
21:34:26 31273 8192000000 10864537952 11325972480 1863335456 18.530 95 31 62 0 1880228496 8086608 8806432
21:35:09 49827 8192000000 10876358000 11334361088 1906237296 18.876 98 31 62 2 1927170960 11717184 9216480
21:36:05 32023 8192000000 10880763520 11339005952 1915698576 18.952 98 27 54 0 1941125264 17646848 7779840
21:36:43 79068 8192000000 10868697440 11341156352 1896974960 18.802 97 18 36 0 1917137744 14813856 5348928
21:38:09 49957 8192000000 10895795888 11346161664 1944984464 19.187 100 22 44 1 1966622368 14916912 6720992
21:39:06 28027 8192000000 10895734064 11354238976 1958811616 19.297 100 35 70 0 1978404656 9949424 9643616
21:39:43 31608 8192000000 10895923680 11351580672 1956797120 19.281 100 36 72 0 1981125536 14289424 10038992
21:40:25 45313 8192000000 10891712640 11359690752 1938516720 19.135 99 21 42 0 1958063488 13290368 6256400
21:41:35 90534 8192000000 10891604576 11363500032 1885381472 18.709 96 15 30 0 1907143920 17761264 4001184
21:43:16 150244 8192000000 10908137648 11390050304 1861280304 18.514 95 6 12 1 1883192352 20326688 1585360
21:45:52 123598 8192000000 10875622704 11342446592 1886642432 18.719 96 7 14 0 1906303568 17744864 1916272
21:48:29 66612 8192000000 10880247344 11358351360 1942184752 19.164 99 25 50 3 1961371344 12384624 6801968
21:49:48 6585 8192000000 10875278352 11349241856 1933525232 19.095 99 16 32 0 1947980304 10250656 4204416
21:50:20 8947 8192000000 10889121472 11348144128 1957807808 19.289 100 39 76 0 1975920544 7406336 10706400
21:50:40 40868 8192000000 10887847088 11353534464 1944169328 19.180 99 21 42 2 1957029248 6160416 6699504
21:51:53 50745 8192000000 10880393344 11361529856 1948312960 19.213 99 6 12 0 1957463984 7558864 1592160
21:53:00 54317 8192000000 10882824640 11361718272 1951687776 19.240 99 15 30 1 1964903760 8646624 4569360
21:54:02 66034 8192000000 10880974512 11357388800 1932416800 19.086 98 16 32 1 1945969376 8273648 5278928
21:56:09 23577 8192000000 10885978384 11346128896 1945027136 19.187 99 34 69 0 1960854640 6284608 9542896
21:56:42 40654 8192000000 10879630224 11351146496 1935783872 19.113 99 20 40 0 1948857712 7816112 5257728
21:57:40 59348 8192000000 10882517760 11363471360 1931923856 19.082 98 17 31 2 1953796736 17772960 4099920
21:58:45 59975 8192000000 10876066864 11363119104 1957386000 19.285 100 11 22 0 1978598032 18126832 3085200
21:59:54 56790 8192000000 10878425936 11353620480 1931678560 19.080 98 14 28 0 1943300288 7961472 3660256
22:00:57 33684 8192000000 10902648720 11369963520 1974332544 19.420 100 25 50 2 1989552864 8557296 6663024
22:01:44 38897 8192000000 10905017008 11364188160 1958766192 19.296 99 24 49 0 1972618608 7598336 6254080
22:02:31 34003 8192000000 10912322192 11375239168 1945079472 19.187 98 27 54 0 1965091856 13068416 6943968
22:03:14 63734 8192000000 10902415312 11375775744 1922649744 19.008 97 16 32 1 1939636848 12386704 4600400
22:04:27 47525 8192000000 10894170032 11369213952 1958849296 19.297 99 21 42 3 1977781920 13086848 5845776
22:06:04 16011 8192000000 10928490432 11372347392 1979725584 19.463 100 45 90 0 2002205024 9715296 12764144
22:06:29 12329 8192000000 10940956688 11381080064 1986844704 19.519 100 63 125 1 2014995040 10834576 17315760
22:06:50 16871 8192000000 10921191248 11369660416 1946076608 19.195 98 54 108 0 1972408848 11447520 14884720
22:07:16 42774 8192000000 10921942816 11388461056 1962410832 19.325 99 34 68 2 1986747136 14234528 10101776
22:08:30 76181 8192000000 10909094528 11380699136 1950179184 19.228 98 17 34 2 1967712160 12970368 4562608
22:09:57 42378 8192000000 10919019952 11381706752 1949050976 19.219 98 33 66 1 1968650688 10526816 9072896
22:10:48 33689 8192000000 10913428432 11352940544 1914695680 18.944 97 45 89 2 1936230912 8320224 13215008
22:11:29 20201 8192000000 10908188080 11347955712 1927382960 19.046 98 50 100 1 1954712656 13596240 13733456
22:11:58 67835 8192000000 10881304592 11358543872 1913570896 18.935 98 19 38 3 1936504432 17434272 5499264
22:13:12 125296 8192000000 10877498336 11337392128 1912454608 18.926 98 18 36 2 1926873280 8844240 5574432
22:15:35 37841 8192000000 10838923360 11312902144 1863225936 18.529 96 20 39 4 1879071760 10122448 5723376
22:17:56 53467 8192000000 10835689760 11313164288 1900997552 18.834 99 10 20 1 1912567232 9084816 2484864
22:19:04 59639 8192000000 10841557248 11311202304 1914985504 18.947 99 17 34 2 1928422528 8780576 4656448
22:20:16 78420 8192000000 10837234240 11315843072 1880503088 18.669 97 13 26 0 1894707392 10171248 4033056
22:21:53 56932 8192000000 10844538864 11316219904 1870238976 18.586 97 6 12 0 1885389664 13719536 1431152
22:22:58 21880 8192000000 10842749136 11305791488 1853868080 18.454 96 24 49 0 1870023664 8975680 7179904
22:23:27 46854 8192000000 10852239664 11322404864 1900133056 18.827 98 19 38 1 1917551824 11715552 5703216
22:24:20 48980 8192000000 10841139408 11314278400 1911152848 18.916 99 20 40 1 1930992032 13507344 6331840
22:25:37 45878 8192000000 10851909040 11322658816 1890131808 18.747 98 17 34 0 1910934944 15774816 5028320
22:26:30 43112 8192000000 9036376624 9234087936 203752896 2.426 11 4 8 0 208550080 3657808 1139376

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 28-11-2020 22:28:21 to 28-11-2020 22:28:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 106 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-11-2020 22:28:53 to 28-11-2020 22:28:55.

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          247942
MON$OLDEST_ACTIVE               247943
MON$OLDEST_SNAPSHOT             247943
MON$NEXT_TRANSACTION            247943
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                       2027424
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:54: 
:55: mscs-test-161.budzdorov.ru    Sat Nov 28 22:27:16 2020
:56:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:57: 
:58: 
:59: mscs-test-161.budzdorov.ru    Sat Nov 28 22:27:17 2020
:60:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:61: 
--- end of diff output ---

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

28.11.20 22:28:56. 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-11-28 22:28:58 No severe PSQL-related problems occured
28.11.20 22:29:00. End of report.