Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.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 17488412 kB
MemAvailable 31467816 kB
Buffers 0 kB
Cached 14189148 kB
SwapCached 2872 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.7
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-03 22:26:56
DTS_END                         2020-11-03 22:26:56.7930
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/49912
TRN_ID                          238991
ATT_ID                          682
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: 9337.30 23070 1120476
customer order: creation 170.60 402 20472
customer order: refuse 14.88 380 1786
order to supplier: creation 45.89 1366 5507
order to supplier: removal 3.69 97657 443
invoice (draft): creation 45.09 3562 5411
invoice (draft): removal 55.16 734 6619
invoice accept: apply 41.38 18806 4966
invoice accept: cancel 49.28 778 5913
customer reserve: creation 3789.06 188 454687
customer reserve: removal 4839.18 59 580702
realization accept: apply 82.02 200 9842
realization accept: cancel 72.71 126 8725
payment from customer: creation 58.92 166 7070
payment from customer: removal 5.67 87 680
payment to supplier: creation 47.99 153 5759
payment to supplier: removal 3.61 98 433
service: total inventory turnovers 4.61 1168 553
service: total monetary turnovers 6.67 29 800
service: aggregate perf. data 0.87 20752 104
service: refresh index statistics 0.03 314686 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-11-2020 22:27:57 to 03-11-2020 22:27:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2507
TEST_TIME 2 2919
TEST_TIME 3 3392
TEST_TIME 4 2874
TEST_TIME 5 3015
TEST_TIME 6 3559
TEST_TIME 7 3654
TEST_TIME 8 4348
TEST_TIME 9 4924
TEST_TIME 10 5293
TEST_TIME 11 5546
TEST_TIME 12 5745
TEST_TIME 13 6137
TEST_TIME 14 6521
TEST_TIME 15 7012
TEST_TIME 16 7284
TEST_TIME 17 7781
TEST_TIME 18 7848
TEST_TIME 19 7902
TEST_TIME 20 8225
TEST_TIME 21 8279
TEST_TIME 22 8237
TEST_TIME 23 8696
TEST_TIME 24 8964
TEST_TIME 25 9211
TEST_TIME 26 9190
TEST_TIME 27 9520
TEST_TIME 28 10005
TEST_TIME 29 10632
TEST_TIME 30 10495
TEST_TIME 31 10245
TEST_TIME 32 10357
TEST_TIME 33 10057
TEST_TIME 34 9938
TEST_TIME 35 9861
TEST_TIME 36 10068
TEST_TIME 37 9986
TEST_TIME 38 9847
TEST_TIME 39 9742
TEST_TIME 40 9663
TEST_TIME 41 9712
TEST_TIME 42 9538
TEST_TIME 43 9655
TEST_TIME 44 9689
TEST_TIME 45 9591
TEST_TIME 46 9617
TEST_TIME 47 9715
TEST_TIME 48 9634
TEST_TIME 49 9671
TEST_TIME 50 9641
TEST_TIME 51 9633
TEST_TIME 52 9537
TEST_TIME 53 9696
TEST_TIME 54 9692
TEST_TIME 55 9724
TEST_TIME 56 9696
TEST_TIME 57 9538
TEST_TIME 58 9524
TEST_TIME 59 9566
TEST_TIME 60 9456
TEST_TIME 61 9411
TEST_TIME 62 9462
TEST_TIME 63 9371
TEST_TIME 64 9365
TEST_TIME 65 9399
TEST_TIME 66 9401
TEST_TIME 67 9384
TEST_TIME 68 9364
TEST_TIME 69 9448
TEST_TIME 70 9432
TEST_TIME 71 9448
TEST_TIME 72 9517
TEST_TIME 73 9471
TEST_TIME 74 9460
TEST_TIME 75 9537
TEST_TIME 76 9548
TEST_TIME 77 9576
TEST_TIME 78 9693
TEST_TIME 79 9620
TEST_TIME 80 9514
TEST_TIME 81 9510
TEST_TIME 82 9474
TEST_TIME 83 9390
TEST_TIME 84 9428
TEST_TIME 85 9452
TEST_TIME 86 9429
TEST_TIME 87 9421
TEST_TIME 88 9341
TEST_TIME 89 9310
TEST_TIME 90 9288
TEST_TIME 91 9284
TEST_TIME 92 9312
TEST_TIME 93 9326
TEST_TIME 94 9322
TEST_TIME 95 9327
TEST_TIME 96 9340
TEST_TIME 97 9366
TEST_TIME 98 9398
TEST_TIME 99 9411
TEST_TIME 100 9416
TEST_TIME 101 9435
TEST_TIME 102 9526
TEST_TIME 103 9554
TEST_TIME 104 9550
TEST_TIME 105 9499
TEST_TIME 106 9455
TEST_TIME 107 9417
TEST_TIME 108 9392
TEST_TIME 109 9374
TEST_TIME 110 9358
TEST_TIME 111 9315
TEST_TIME 112 9307
TEST_TIME 113 9245
TEST_TIME 114 9247
TEST_TIME 115 9241
TEST_TIME 116 9238
TEST_TIME 117 9278
TEST_TIME 118 9294
TEST_TIME 119 9323
TEST_TIME 120 9339

Performance per minute, chart


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

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 1542874 1542874 0 0.00 0 37818 7 0 0
doc_list_biud 1542873 1542873 0 0.00 0 59300 28 0 0
sp_add_invoice_to_stock 5092 4966 126 2.47 26 214437 18806 0 126
sp_cancel_adding_invoice 5913 5913 0 0.00 4 77205 778 0 0
sp_cancel_client_order 1786 1786 0 0.00 4 13172 381 0 0
sp_cancel_customer_reserve 580702 580702 0 0.00 1 59304 60 0 0
sp_cancel_pay_from_customer 680 680 0 0.00 3 6846 87 0 0
sp_cancel_pay_to_supplier 433 433 0 0.00 3 7639 99 0 0
sp_cancel_supplier_invoice 6627 6619 8 0.12 2 14624 735 0 8
sp_cancel_supplier_order 443 443 0 0.00 8 788580 97657 0 0
sp_cancel_write_off 8725 8725 0 0.00 1 20895 126 0 0
sp_client_order 20472 20472 0 0.00 4 36749 403 0 0
sp_customer_reserve 454687 454687 0 0.00 0 74134 188 0 0
sp_fill_shopping_cart 31387 31387 0 0.00 1 17612 45 0 0
sp_fill_shopping_cart_clo_res 454683 454683 0 0.00 0 26538 15 0 0
sp_get_clo_for_invoice 4962 4962 0 0.00 0 40339 341 0 0
sp_kill_cost_storno 15751 15751 0 0.00 0 33420 66 0 0
sp_kill_qstorno_ret_qs2qd 1177191 1177191 0 0.00 0 59292 32 0 0
sp_kill_qty_storno 618992 618992 0 0.00 0 59299 70 0 0
sp_lock_selected_doc 20636 20636 0 0.00 0 6477 4 0 0
sp_make_cost_storno 27633 27633 0 0.00 0 35884 66 0 0
sp_multiply_rows_for_pdistr 27633 27633 0 0.00 0 21405 35 0 0
sp_multiply_rows_for_qdistr 20472 20472 0 0.00 0 33664 192 0 0
sp_pay_from_customer 7070 7070 0 0.00 4 29856 166 0 0
sp_pay_to_supplier 5759 5759 0 0.00 5 22110 154 0 0
sp_payment_common 12829 12829 0 0.00 1 22107 64 0 0
sp_qd_handle_on_cancel_clo 1786 1786 0 0.00 0 13166 343 0 0
sp_qd_handle_on_invoice_upd_sts 10875 10875 0 0.00 0 36684 321 0 0
sp_qd_handle_on_reserve_upd_sts 9842 9842 0 0.00 0 16851 56 0 0
sp_reserve_write_off 9842 9842 0 0.00 7 37834 200 0 0
sp_supplier_invoice 5411 5411 0 0.00 6 81592 3563 0 0
sp_supplier_order 5507 5507 0 0.00 5 56096 1367 0 0
srv_aggregate_perf_data 104 104 0 0.00 2957 192448 20752 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 716 141946 32996 0 0
srv_find_qd_qs_mism 1073963 1073963 0 0.00 0 16002 6 0 0
srv_make_invnt_saldo 553 553 0 0.00 30 71214 1169 0 0
srv_make_money_saldo 800 800 0 0.00 1 5432 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 221172 433051 314686 0 0
t$perf-abend:sp_add_invoice_to_stock 126 126 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4966 4966 0 0.00 0 11053 181 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 13486 145 0 0
t$perf-norm:sp_cancel_client_order 1786 1786 0 0.00 0 4546 18 0 0
t$perf-norm:sp_cancel_customer_reserve 658 658 0 0.00 0 2943 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 680 680 0 0.00 0 2243 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 433 433 0 0.00 0 3412 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 424 424 0 0.00 0 1258 16 0 0
t$perf-norm:sp_cancel_supplier_order 443 443 0 0.00 0 21265 1659 0 0
t$perf-norm:sp_cancel_write_off 983 983 0 0.00 0 4160 10 0 0
t$perf-norm:sp_client_order 20472 20472 0 0.00 0 13998 20 0 0
t$perf-norm:sp_customer_reserve 1016 1016 0 0.00 0 1787 6 0 0
t$perf-norm:sp_pay_from_customer 7070 7070 0 0.00 0 4738 12 0 0
t$perf-norm:sp_pay_to_supplier 5759 5759 0 0.00 0 5048 13 0 0
t$perf-norm:sp_reserve_write_off 9842 9842 0 0.00 0 8033 14 0 0
t$perf-norm:sp_supplier_invoice 5411 5411 0 0.00 0 5316 19 0 0
t$perf-norm:sp_supplier_order 5507 5507 0 0.00 0 6067 17 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 2364 37 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 2155 15 0 0
t$perf-norm:srv_make_invnt_saldo 553 553 0 0.00 0 2221 35 0 0
t$perf-norm:srv_make_money_saldo 800 800 0 0.00 0 695 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 47 22 0 0
v_add_invoice_to_stock 10176 9924 252 2.47 0 6381 18 0 252
v_all_customers 37302 37302 0 0.00 0 18 1 0 0
v_all_suppliers 30158 30158 0 0.00 0 20 1 0 0
v_all_wares 40944 40944 0 0.00 0 31 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 2440 8 0 0
v_cancel_client_order 3572 3572 0 0.00 0 4622 6 0 0
v_cancel_customer_prepayment 1360 1360 0 0.00 0 6804 17 0 0
v_cancel_customer_reserve 1316 1316 0 0.00 0 746 4 0 0
v_cancel_payment_to_supplier 866 866 0 0.00 0 3941 9 0 0
v_cancel_supplier_invoice 864 848 16 1.85 0 1415 18 0 16
v_cancel_supplier_order 886 886 0 0.00 0 1972 10 0 0
v_cancel_write_off 1966 1966 0 0.00 0 4986 18 0 0
v_max_id_clo_ord 5505 5505 0 0.00 0 565 1 0 0
v_max_id_clo_res 1016 1016 0 0.00 0 2063 9 0 0
v_max_id_ord_sup 5410 5410 0 0.00 0 5202 6 0 0
v_max_non_paid_invoice 1594 1594 0 0.00 0 1016 3 0 0
v_max_non_paid_realizn 3734 3734 0 0.00 0 8434 9 0 0
v_min_id_clo_ord 5505 5505 0 0.00 0 11121 18 0 0
v_min_id_clo_res 1016 1016 0 0.00 0 3137 8 0 0
v_min_id_ord_sup 5410 5410 0 0.00 0 6059 10 0 0
v_min_non_paid_invoice 5758 5758 0 0.00 0 20435 35 0 0
v_min_non_paid_realizn 7070 7070 0 0.00 0 20479 56 0 0
v_our_firm 10314 10314 0 0.00 0 31 1 0 0
v_reserve_write_off 19682 19682 0 0.00 0 9108 9 0 0
x_lock_depdocs_on_canc_invoice 12108 12108 0 0.00 0 13281 104 0 0
x_lock_depdocs_on_canc_sup_ord 443 443 0 0.00 0 19380 367 0 0
x_make_qstorno_1000_1200 5507 5507 0 0.00 2 56084 1270 0 0
x_make_qstorno_1200_2000 5411 5411 0 0.00 3 72671 3399 0 0
x_make_qstorno_2100_3300 454687 454687 0 0.00 0 74130 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-11-2020 22:28:05 to 03-11-2020 22:28:09.

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:00 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:06 21619 8192000000 10272189024 10582749184 1009280880 10.968 77 62 124 0 1033277328 3044480 20951968
19:57:34 36719 8192000000 10355644368 10672410624 1387838528 14.487 100 90 180 0 1423138720 5073440 30226752
19:58:19 23377 8192000000 10389753056 10714898432 1440938080 14.958 100 88 177 0 1476665968 6788480 28939408
19:58:54 22116 8192000000 10417460576 10745593856 1459259424 15.119 100 90 180 0 1496040976 7507872 29273680
19:59:25 18484 8192000000 10431114096 10763337728 1487878896 15.370 100 92 184 0 1526078672 8593056 29606720
19:59:52 27382 8192000000 10444390464 10779947008 1500093904 15.477 100 93 186 0 1539309968 9252816 29963248
20:00:28 10919 8192000000 10456033504 10793324544 1510530576 15.568 100 88 176 1 1548203472 9143632 28529264
20:00:49 15885 8192000000 10483187584 10822967296 1528443888 15.724 100 88 176 1 1565825024 9643664 27737472
20:01:18 20177 8192000000 10512472528 10863034368 1568937920 16.073 100 85 170 0 1605682352 10235760 26508672
20:01:47 16379 8192000000 10553663936 10907492352 1602669888 16.362 100 79 158 2 1637346064 10474544 24201632
20:02:12 13258 8192000000 10574521536 10931388416 1628580240 16.583 100 85 168 1 1665646992 11676656 25390096
20:02:35 16252 8192000000 10603137504 10961186816 1649900512 16.764 100 82 164 0 1687222368 12543312 24778544
20:03:01 9483 8192000000 10603841120 10970296320 1666115424 16.900 100 81 162 1 1702126176 11846448 24164304
20:03:21 10113 8192000000 10611419104 10984898560 1681252560 17.028 100 80 159 1 1716541120 11802800 23485760
20:03:40 9194 8192000000 10637128656 11010187264 1698433744 17.172 100 77 153 3 1732483760 11643232 22406784
20:03:58 5736 8192000000 10644383600 11019689984 1709552576 17.265 100 74 149 0 1743050944 12169104 21329264
20:04:12 6227 8192000000 10651950208 11033186304 1724090432 17.386 100 72 144 0 1757437200 12699200 20647568
20:04:26 13098 8192000000 10682009216 11055341568 1735625840 17.482 100 74 148 1 1769541360 12950832 20964688
20:04:45 7871 8192000000 10676297568 11062255616 1749784192 17.600 100 71 140 2 1782774880 12972112 20018576
20:05:01 4819 8192000000 10706645616 11082866688 1764719984 17.723 100 78 154 0 1798801120 12734256 21346880
20:05:13 6995 8192000000 10709774688 11086864384 1772027776 17.784 100 81 161 3 1807272848 13571344 21673728
20:05:27 9413 8192000000 10722734816 11105656832 1780662000 17.855 100 83 166 0 1818810688 14755072 23393616
20:05:43 6970 8192000000 10733776000 11116888064 1785062784 17.891 100 79 154 2 1820623424 14224576 21336064
20:05:56 3069 8192000000 10738324704 11127169024 1805517760 18.059 100 73 146 2 1840715120 13959072 21238288
20:06:07 3094 8192000000 10750217472 11142684672 1816144288 18.146 100 76 150 0 1850057056 12392128 21520640
20:06:16 2503 8192000000 10755492112 11147427840 1821916672 18.193 100 72 144 0 1854457360 11498096 21042592
20:06:26 2744 8192000000 10767049168 11157286912 1830463168 18.263 100 76 149 1 1862847264 10741104 21642992
20:06:36 3434 8192000000 10778333728 11166978048 1837038688 18.317 100 82 161 2 1870336448 10743776 22553984
20:06:48 2724 8192000000 10782540336 11172298752 1842699312 18.363 100 83 166 0 1878316064 12202080 23414672
20:06:57 2686 8192000000 10783224064 11177766912 1848499696 18.410 100 84 168 0 1885702512 13579184 23623632
20:07:06 2603 8192000000 10793107264 11183812608 1856044912 18.471 100 89 179 0 1895555312 14290544 25219856
20:07:16 1579 8192000000 10793461680 11184369664 1854448336 18.458 100 89 178 1 1893437440 14529072 24460032
20:07:24 2218 8192000000 10799151360 11187679232 1858219456 18.489 100 93 186 1 1897501872 14110688 25171728
20:07:33 2088 8192000000 10803159232 11192508416 1862125104 18.521 100 89 178 1 1900733232 13101328 25506800
20:07:42 2105 8192000000 10807735616 11195895808 1862351792 18.522 100 87 175 2 1900499344 13446400 24701152
20:07:50 2379 8192000000 10812332336 11197673472 1863766864 18.534 100 92 182 2 1903391552 13598112 26026576
20:07:59 1595 8192000000 10810688768 11198582784 1866065520 18.552 100 91 181 0 1906037824 14244016 25728288
20:08:07 1356 8192000000 10815368832 11204648960 1865783344 18.550 100 89 178 1 1907842816 16849296 25210176
20:08:15 1744 8192000000 10818112016 11204788224 1873810944 18.615 100 93 186 3 1913126080 12968768 26346368
20:08:23 1475 8192000000 10824034368 11210743808 1874163056 18.618 100 98 198 1 1915129872 13106624 27860192
20:08:31 1733 8192000000 10822046544 11213869056 1873530992 18.613 100 92 184 4 1914019664 13884160 26604512
20:08:39 3783 8192000000 10809309088 11208355840 1871923744 18.600 100 60 121 1 1899641968 10235840 17482384
20:08:50 6770 8192000000 10780893152 11209322496 1871663440 18.598 100 30 60 0 1892215152 12407216 8144496
20:09:24 11723 8192000000 10783087248 11208351744 1875844496 18.632 100 26 52 0 1890641984 7392720 7404768
20:09:43 6164 8192000000 10789780816 11210674176 1880522064 18.669 100 40 78 1 1898262960 6095696 11645200
20:09:58 6917 8192000000 10784228960 11213537280 1873972416 18.616 100 22 43 3 1887129792 7027568 6129808
20:10:11 8553 8192000000 10789288816 11213152256 1877355120 18.644 100 21 42 2 1889904048 6589728 5959200
20:10:28 7427 8192000000 10786174704 11217264640 1879129664 18.658 100 21 42 3 1891480768 6997488 5353616
20:10:47 12373 8192000000 10784457760 11218735104 1880522208 18.669 100 12 24 0 1889960352 6029232 3408912
20:11:05 11651 8192000000 10789652272 11221467136 1881109776 18.674 100 15 30 1 1890941808 5841248 3990784
20:11:23 10946 8192000000 10800009472 11228561408 1883159472 18.691 100 16 31 1 1893169168 4940736 5068960
20:11:47 19766 8192000000 10793505984 11230392320 1889660592 18.743 100 12 23 1 1898361584 5543872 3157120
20:12:17 17558 8192000000 10804843104 11238313984 1895502752 18.790 100 22 44 2 1906898784 5751808 5644224
20:12:41 55789 8192000000 10839979072 11253207040 1900569248 18.831 100 35 69 3 1916035744 5018912 10447584
20:13:50 8223 8192000000 10811094720 11250077696 1904392656 18.862 100 31 63 1 1919289856 6083984 8813216
20:14:04 4315 8192000000 10818163968 11252764672 1906259968 18.877 100 30 60 2 1921770880 7193904 8317008
20:14:17 4523 8192000000 10821599312 11253805056 1905566112 18.871 100 30 60 1 1921323584 7456304 8301168
20:14:28 7771 8192000000 10815980992 11257282560 1903462608 18.854 100 19 37 1 1914356144 5680256 5213280
20:14:43 5675 8192000000 10828342352 11256983552 1907606432 18.887 100 26 53 0 1921671632 6279152 7786048
20:14:56 7373 8192000000 10828521680 11258433536 1908539424 18.895 100 24 48 1 1921938848 6710432 6688992
20:15:14 6051 8192000000 10821639984 11258089472 1910887536 18.914 100 25 50 1 1924846048 6333168 7625344
20:15:29 5999 8192000000 10829299840 11263336448 1908100560 18.891 100 22 42 2 1920272176 5963984 6207632
20:15:44 7636 8192000000 10829087072 11266981888 1909971632 18.906 100 25 50 2 1926763040 9916784 6874624
20:15:58 4837 8192000000 10850292688 11267932160 1914185504 18.940 100 32 64 1 1929999040 6567392 9246144
20:16:12 15208 8192000000 10803379760 11235487744 1866706096 18.558 98 16 31 1 1876424096 5500736 4217264
20:16:34 5126 8192000000 10809409520 11246997504 1897801520 18.809 100 24 48 1 1910701568 6211104 6688944
20:16:47 11970 8192000000 10802337776 11236179968 1869113024 18.577 99 20 40 2 1885548720 11266880 5168816
20:17:12 9007 8192000000 10756189008 11183669248 1831098800 18.268 98 16 32 3 1840827488 5447376 4281312
20:17:32 62089 8192000000 10768310464 11197104128 1795900384 17.980 96 37 74 0 1812123744 5074032 11149328
20:18:41 12558 8192000000 10732474944 11151466496 1741034048 17.527 94 23 46 1 1757645344 9828752 6782544
20:19:00 7523 8192000000 10737205088 11156033536 1746082384 17.569 95 22 44 0 1758351168 5649824 6618960
20:19:15 7658 8192000000 10718619904 11127865344 1723138192 17.378 95 41 81 1 1742896128 7840912 11917024
20:19:28 7532 8192000000 10707830624 11123904512 1734037360 17.469 96 33 64 2 1749687392 6961824 8688208
20:19:45 4426 8192000000 10728601472 11144830976 1808406960 18.083 99 41 82 0 1827064624 6525712 12131952
20:19:57 8966 8192000000 10725027472 11143344128 1740554096 17.523 95 27 53 2 1753986176 5753712 7678368
20:20:17 9389 8192000000 10686206752 11100381184 1657938752 16.831 92 25 50 3 1670340016 5023712 7377552
20:20:34 6151 8192000000 10676356416 11091984384 1748726432 17.591 99 29 57 2 1762631184 5208736 8696016
20:20:49 6910 8192000000 10687328576 11106906112 1750164032 17.603 98 32 65 0 1765564800 5683824 9716944
20:21:09 8026 8192000000 10714737680 11127386112 1763724400 17.715 98 27 54 1 1778108000 6599872 7783728
20:21:30 8440 8192000000 10705144352 11099496448 1720672320 17.358 96 31 61 0 1735562368 6301040 8589008
20:21:45 9002 8192000000 10719729424 11139436544 1768570704 17.755 98 19 36 3 1783060736 9523488 4966544
20:22:00 11742 8192000000 10739664544 11156844544 1800588624 18.019 99 25 50 0 1813813600 6175312 7049664
20:22:18 12453 8192000000 10764246640 11169140736 1819060928 18.170 99 51 101 1 1838833904 5447968 14325008
20:22:46 45658 8192000000 10791037360 11180941312 1829556688 18.256 99 75 149 2 1858105088 5745040 22803360
20:23:37 14750 8192000000 10751351200 11185442816 1841137968 18.350 100 15 30 1 1851655984 5855504 4662512
20:24:00 8360 8192000000 10767575856 11193802752 1852837760 18.445 100 14 28 1 1862506080 5464320 4204000
20:24:14 9756 8192000000 10777574240 11202232320 1860793920 18.510 100 25 49 0 1874000784 5633120 7573744
20:24:30 11084 8192000000 10785384304 11211431936 1861095408 18.512 100 21 42 1 1877071008 10245424 5730176
20:24:48 8649 8192000000 10783675216 11210592256 1865819344 18.550 100 22 44 1 1877933936 5986208 6128384
20:25:03 6109 8192000000 10785234352 11209023488 1868203120 18.570 100 30 60 1 1882567232 5353008 9011104
20:25:17 8380 8192000000 10796796368 11219955712 1867416640 18.563 100 27 52 1 1884499152 9291808 7790704
20:25:35 17052 8192000000 10776952736 11213885440 1868754800 18.574 100 10 19 2 1877055200 5099200 3201200
20:25:58 7851 8192000000 10786847584 11219562496 1876010960 18.633 100 20 39 2 1886529856 5248720 5270176
20:26:16 15595 8192000000 10790224128 11221446656 1874487776 18.621 100 13 26 0 1884711824 5533200 4690848
20:26:39 15629 8192000000 10791567296 11228708864 1875371984 18.628 100 11 22 0 1888345792 10272592 2701216
20:27:04 21895 8192000000 10824354128 11241631744 1886525728 18.718 100 31 62 0 1900659536 4813248 9320560
20:27:35 5415 8192000000 10830243632 11253362688 1906285984 18.877 100 40 80 1 1924061648 6520560 11255104
20:27:54 36388 8192000000 10833482544 11265359872 1916314016 18.957 100 43 86 0 1935527568 6804224 12409328
20:28:47 29283 8192000000 10860888688 11294224384 1932985568 19.091 100 29 58 0 1949585104 8184400 8415136
20:29:30 141946 8192000000 10886912224 11325132800 1950589872 19.231 100 37 74 1 1972629920 11131264 10908784
20:32:03 26127 8192000000 10890443952 11332526080 1964007552 19.338 100 23 46 0 1983898048 12924800 6965696
20:32:43 6615 8192000000 10901958016 11339530240 1974327488 19.420 100 35 69 1 1999005728 14191600 10486640
20:33:20 15747 8192000000 10915620544 11353899008 1980686496 19.470 100 40 79 1 2008767504 16120800 11960208
20:33:44 29840 8192000000 10921734480 11361267712 1984557904 19.501 100 41 82 0 2015689792 17999408 13132480
20:34:21 43573 8192000000 10932089200 11372208128 1983531008 19.493 100 34 68 1 2018953984 24074448 11348528
20:35:16 11530 8192000000 10943562928 11378462720 1995053312 19.584 100 48 97 0 2029748864 19710176 14985376
20:35:36 19796 8192000000 10930700576 11375726592 1999483360 19.619 100 43 86 2 2031672848 18770272 13419216
20:36:03 10674 8192000000 10950506912 11390787584 2004829248 19.661 100 35 70 1 2031502176 15393792 11279136
20:36:29 8723 8192000000 10950415392 11389972480 2007154880 19.679 100 44 88 2 2038306560 17604976 13546704
20:36:44 4824 8192000000 10964955488 11396304896 2013230272 19.727 100 64 127 2 2051236512 17943952 20062288
20:36:57 9211 8192000000 10963095856 11398533120 2013887712 19.732 100 56 112 2 2048309584 17901984 16519888
20:37:19 2913 8192000000 10969510560 11401314304 2015048128 19.741 100 64 127 2 2054251488 19666176 19537184
20:37:32 5031 8192000000 10972728176 11407110144 2019118960 19.773 100 69 136 3 2060789744 20517280 21153504
20:37:47 2097 8192000000 10990698320 11414753280 2023008016 19.804 100 65 130 2 2063799392 21474704 19316672
20:38:00 3244 8192000000 10989134416 11416924160 2027687952 19.840 100 82 164 2 2075304096 22811792 24804352
20:38:10 3577 8192000000 10984270688 11420106752 2028867792 19.850 100 75 151 1 2075383984 23424624 23091568
20:38:22 3515 8192000000 10987213472 11413032960 2023475376 19.807 100 75 150 0 2071396544 24182816 23738352
20:38:33 1565 8192000000 10965557456 11398664192 2003837248 19.653 99 62 122 0 2045650672 23322176 18491248
20:38:42 5452 8192000000 10975201088 11404840960 2015915776 19.748 100 76 152 2 2064109360 24904112 23289472
20:39:00 7146 8192000000 10972652816 11399184384 1994903136 19.583 99 68 136 0 2042297376 26317456 21076784
20:39:15 4880 8192000000 10939373664 11370631168 1979400864 19.460 99 62 124 4 2025488944 26176736 19911344
20:39:28 16925 8192000000 10959214384 11395903488 2009879248 19.701 100 67 134 1 2053392720 22747808 20765664
20:39:53 4009 8192000000 10956381888 11381354496 1993406240 19.571 100 81 162 2 2042349136 23501472 25441424
20:40:05 4982 8192000000 10956707968 11377262592 1983787168 19.495 99 78 155 4 2032240960 24287088 24166704
20:40:17 3690 8192000000 10963242432 11387863040 1998616800 19.612 100 72 142 1 2046113952 24642192 22854960
20:40:30 4350 8192000000 10955655552 11377979392 1980752672 19.471 99 76 152 1 2030116624 25386048 23977904
20:40:43 6668 8192000000 10972059216 11398066176 2001534752 19.635 100 72 142 2 2049228464 24968288 22725424
20:41:01 5444 8192000000 10959726112 11383541760 1983231504 19.490 99 80 157 0 2031222768 22811856 25179408
20:41:24 4128 8192000000 10959160832 11384238080 1997996128 19.607 100 78 156 1 2044058960 22391408 23671424
20:41:35 4341 8192000000 10959993424 11381391360 1980051840 19.465 99 78 157 0 2027426400 22935280 24439280
20:41:47 4800 8192000000 10960480448 11383042048 1979563008 19.461 99 73 145 1 2026024832 24088816 22373008
20:41:58 4365 8192000000 10966938400 11394347008 1999612928 19.620 100 72 144 0 2046926800 25100176 22213696
20:42:12 3521 8192000000 10959134256 11376250880 1990848576 19.550 100 86 172 0 2041381920 24939728 25593616
20:42:22 1453 8192000000 10963479392 11373559808 1985106384 19.505 100 87 173 1 2037230544 26161936 25962224
20:42:31 1820 8192000000 10976716032 11388067840 1997986896 19.607 100 93 185 1 2052952912 26993968 27972048
20:42:40 1896 8192000000 10987378656 11400593408 2009489952 19.698 100 94 189 1 2063414224 26122528 27801744
20:42:48 1978 8192000000 10980525328 11393884160 1988055952 19.528 99 93 186 0 2042946688 26950320 27940416
20:42:57 3933 8192000000 10976211264 11400024064 2005383936 19.665 100 76 148 1 2058910640 30253072 23273632
20:43:09 1895 8192000000 10977333936 11394117632 1997693536 19.605 100 85 171 1 2056915696 32816304 26405856
20:43:17 2642 8192000000 10916757216 11329671168 1935767952 19.113 97 80 159 1 1994006032 33266656 24971424
20:43:28 2527 8192000000 10931037920 11345203200 1956783072 19.280 100 77 153 1 2009310752 29225600 23302080
20:43:37 6803 8192000000 10900206272 11328548864 1935827632 19.113 99 53 106 2 1979951856 27925712 16198512
20:44:03 11219 8192000000 10909845136 11346636800 1960717760 19.312 100 49 98 0 2004475984 28178032 15580192
20:44:25 10454 8192000000 10920538992 11356053504 1964162064 19.339 100 53 106 1 2011260304 30453024 16645216
20:44:43 9136 8192000000 10918519040 11351527424 1949777440 19.225 99 51 100 1 1997424544 31370656 16276448
20:44:59 6352 8192000000 10922891104 11343306752 1952567088 19.247 100 62 121 2 2005014224 32491536 19955600
20:45:12 2173 8192000000 10945774672 11361374208 1965850992 19.353 100 82 162 1 2027312960 35001440 26460528
20:45:27 5335 8192000000 10952162976 11373473792 1970551632 19.390 100 71 143 0 2030359008 37368272 22439104
20:45:40 6708 8192000000 10957304080 11372707840 1971892384 19.400 100 73 143 3 2031799504 38105104 21802016
20:45:55 3038 8192000000 10956521552 11380056064 1979692832 19.462 100 77 151 0 2041379088 38068448 23617808
20:46:05 1978 8192000000 10959187120 11377688576 1975340160 19.428 100 83 166 1 2041344480 39823456 26180864
20:46:15 2734 8192000000 10959397312 11384999936 1980666816 19.470 100 69 137 1 2040373264 38646096 21060352
20:46:25 1709 8192000000 10956628800 11371585536 1965807024 19.352 99 77 154 0 2028437344 38914960 23715360
20:46:35 715 8192000000 10985324224 11395551232 1994450208 19.579 100 87 173 0 2058867232 37336496 27080528
20:46:43 3656 8192000000 10972907200 11387383808 1988301120 19.530 100 80 158 1 2051052224 38459984 24291120
20:46:55 6393 8192000000 10955591008 11392712704 1986242048 19.514 100 56 112 3 2043308240 39650992 17415200
20:47:21 10773 8192000000 10937566304 11373002752 1966751072 19.360 99 47 94 1 2019886912 37446320 15689520
20:47:41 6134 8192000000 10911344752 11354943488 1942504416 19.167 99 39 78 2 1991477152 35868576 13104160
20:47:55 7132 8192000000 10937903216 11369820160 1965774480 19.352 100 46 92 0 2018221984 37465344 14982160
20:48:10 11076 8192000000 10930222080 11371847680 1945765328 19.193 99 38 76 0 2000348352 41234976 13348048
20:48:34 13397 8192000000 10917018240 11353387008 1937479584 19.127 99 42 84 1 1997090624 44212224 15398816
20:48:55 11122 8192000000 10925063920 11366514688 1953233904 19.252 100 33 66 2 2010068176 45066944 11767328
20:49:29 22700 8192000000 10887529216 11340705792 1888880512 18.737 97 31 62 1 1942917120 42834112 11202496
20:50:16 21878 8192000000 10888981248 11326144512 1876864112 18.640 97 32 66 0 1927175744 39038320 11273312
20:50:46 2614 8192000000 10915074848 11342266368 1933636944 19.096 100 60 121 1 1995671872 43004864 19030064
20:51:06 12472 8192000000 10896120224 11344338944 1932578800 19.087 100 27 54 1 1980482448 38797376 9106272
20:51:52 18582 8192000000 10909537728 11356495872 1933555136 19.095 99 24 48 0 1979152624 37293600 8303888
20:52:27 25121 8192000000 10917208736 11359449088 1944501680 19.183 100 24 48 1 1991384128 38750432 8132016
20:53:15 25124 8192000000 10916284640 11374129152 1943025088 19.171 100 26 52 2 2001511664 49621728 8864848
20:53:47 21998 8192000000 10906315424 11370405888 1922532320 19.007 99 20 40 2 1973639408 43868112 7238976
20:54:28 21879 8192000000 10902070048 11364196352 1932219824 19.085 100 16 32 0 1986668656 48492336 5956496
20:55:04 39185 8192000000 10870005312 11341967360 1901027264 18.835 98 17 34 0 1934565312 28196752 5341296
20:55:50 17256 8192000000 10877764416 11327787008 1924714064 19.025 99 31 60 2 1941759728 8181168 8864496
20:56:13 77039 8192000000 10859123904 11310137344 1907725840 18.888 99 22 44 4 1924744944 10357328 6661776
20:57:45 73368 8192000000 10878434272 11329347584 1885863328 18.712 97 31 62 2 1910418208 15943792 8611088
21:00:16 5259 8192000000 10922963936 11352969216 1968819616 19.376 100 84 169 0 2005615296 12191648 24604032
21:00:28 2607 8192000000 10925040816 11347636224 1965650816 19.351 100 84 169 1 2003906640 14633936 23621888
21:00:43 19460 8192000000 10899471584 11347558400 1947611216 19.207 99 52 104 0 1978082640 15803472 14667952
21:01:13 26985 8192000000 10897568032 11341074432 1953682560 19.256 100 40 80 1 1979560960 13857920 12020480
21:01:53 37320 8192000000 10876858528 11328143360 1925955120 19.035 99 32 65 1 1952361776 17463616 8943040
21:02:37 7650 8192000000 10879103584 11336024064 1943882160 19.178 100 27 54 0 1970376704 18697232 7797312
21:02:51 8582 8192000000 10836104432 11303329792 1906343648 18.877 99 15 31 1 1925420704 14928240 4148816
21:03:15 18165 8192000000 10855825888 11319984128 1915493376 18.951 99 13 24 2 1928248128 9312672 3442080
21:03:40 92785 8192000000 10873307056 11338952704 1918105104 18.972 98 22 44 1 1937052528 13081872 5865552
21:05:38 64860 8192000000 10864478432 11324026880 1925754976 19.033 99 13 26 1 1949212336 19737152 3720208
21:07:09 51732 8192000000 10860419520 11331297280 1907790432 18.889 98 16 32 0 1928096816 15411424 4894960
21:08:06 45207 8192000000 10880237280 11335962624 1943390112 19.174 100 26 54 1 1964525968 13506560 7629296
21:09:08 52872 8192000000 10880390304 11351691264 1957742144 19.288 100 17 34 1 1973368816 10861104 4765568
21:10:06 71211 8192000000 10908684768 11370483712 1947948256 19.210 99 20 39 0 1964658864 11149664 5560944
21:11:26 39086 8192000000 10912928560 11366404096 1974622608 19.422 100 29 58 1 1996544320 14539456 7382256
21:12:12 53178 8192000000 10900354992 11376742400 1956971408 19.282 99 23 46 1 1977096800 13429440 6695952
21:13:19 73958 8192000000 10913133696 11380793344 1967775504 19.368 100 10 17 1 1981994432 11650336 2568592
21:14:43 26566 8192000000 10920638720 11384705024 1985378096 19.507 100 28 56 1 2004444496 11368080 7698320
21:15:17 116156 8192000000 10922417648 11398537216 1987891040 19.527 100 12 24 0 2005544624 14890832 2762752
21:17:19 69464 8192000000 10931738592 11387068416 1938948048 19.138 97 30 60 0 1963335376 16445552 7941776
21:18:38 53099 8192000000 10915640768 11387424768 1971684064 19.399 99 26 52 1 1998198624 19109824 7404736
21:19:44 63179 8192000000 10916575456 11391307776 1958852464 19.297 99 19 38 2 1978192928 14147104 5193360
21:20:58 75591 8192000000 10914665728 11397480448 1983983104 19.496 100 15 30 1 2005688096 17573952 4131040
21:22:19 111316 8192000000 10929150480 11366449152 1917369696 18.966 96 33 66 0 1936615776 10015968 9230112
21:24:17 56707 8192000000 10938509040 11386576896 1989422928 19.539 100 26 52 1 2007423168 11444160 6556080
21:25:22 76213 8192000000 10915077264 11395862528 1968555232 19.374 99 17 32 2 1986347312 13187616 4604464
21:27:02 35217 8192000000 10911359360 11361976320 1923112848 19.012 96 39 76 1 1945365584 11387568 10865168
21:27:58 66879 8192000000 10891370880 11370921984 1941540080 19.159 98 16 32 0 1957257904 11268992 4448832
21:30:31 50596 8192000000 10841144560 11308232704 1815073392 18.137 92 12 23 3 1829655200 11528816 3052992
21:31:28 46536 8192000000 10852464896 11318476800 1831494256 18.272 94 22 42 1 1848106656 11009232 5603168
21:32:26 56709 8192000000 10854200784 11329093632 1919117616 18.980 99 21 42 0 1935510656 10216144 6176896
21:33:54 38093 8192000000 10866238736 11315187712 1886291984 18.716 97 26 50 0 1903831408 9821760 7717664
21:34:40 29029 8192000000 10894919520 11353796608 1954831744 19.265 100 30 60 3 1973635152 10300800 8502608
21:35:19 48834 8192000000 10861994320 11333025792 1876759776 18.639 96 16 32 0 1893874880 12489808 4625296
21:36:18 65567 8192000000 10852742224 11300229120 1807562304 18.076 93 31 62 1 1828985424 12846480 8576640
21:37:30 98516 8192000000 10848370032 11309973504 1869508784 18.580 97 19 38 2 1889729984 14589904 5631296
21:39:25 27212 8192000000 10871979008 11316961280 1912156832 18.924 99 31 62 2 1932373744 11621648 8595264
21:39:59 34971 8192000000 10862914624 11314151424 1895386416 18.789 98 36 72 0 1919842272 14771424 9684432
21:40:42 24099 8192000000 10882940880 11334000640 1933672688 19.096 100 37 74 1 1961763232 17629008 10461536
21:41:22 60541 8192000000 10881469648 11348250624 1930362256 19.070 99 22 44 0 1951911648 15907024 5642368
21:42:28 86145 8192000000 10856801488 11321249792 1809400464 18.091 93 17 34 1 1829654032 15671184 4582384
21:44:25 82808 8192000000 10866568736 11331657728 1918599072 18.976 100 9 18 1 1945233056 23624160 3009824
21:45:55 74820 8192000000 10858842176 11317895168 1921662992 19.000 99 37 73 1 1942096944 9378000 11055952
21:47:20 44973 8192000000 10887800496 11348062208 1947146080 19.204 100 39 78 4 1967288432 9364688 10777664
21:48:13 79715 8192000000 10884202272 11338461184 1897247520 18.804 97 35 70 0 1922891248 16007584 9636144
21:49:39 42605 8192000000 10877958032 11332145152 1928459952 19.055 99 50 100 1 1959110320 16498352 14152016
21:50:44 71304 8192000000 10839849072 11311546368 1834070784 18.293 95 10 20 0 1846422464 9473168 2878512
21:52:04 56780 8192000000 10835952944 11300331520 1885872048 18.712 98 10 20 0 1896340736 7724368 2744320
21:53:17 54681 8192000000 10841895584 11307831296 1890443664 18.749 98 17 34 0 1902504848 7454320 4606864
21:54:22 52411 8192000000 10836518624 11307184128 1908829984 18.897 99 8 16 0 1918815392 7714832 2270576
21:55:21 72087 8192000000 10821179456 11302612992 1900345584 18.829 99 9 18 0 1912564816 9515072 2704160
21:56:39 46565 8192000000 10856280416 11329605632 1925632992 19.032 100 16 32 1 1937455648 7578640 4244016
21:58:16 89704 8192000000 10892407440 11365842944 1923367312 19.014 98 11 22 0 1935191344 9287920 2536112
22:00:00 79672 8192000000 10899412720 11374133248 1970547280 19.390 100 12 24 0 1980888384 7419968 2921136
22:01:27 12421 8192000000 10935976224 11380158464 1968265168 19.372 99 51 100 0 1988841952 6266064 14310720
22:01:50 29345 8192000000 10916906112 11366649856 1945342112 19.189 98 46 91 1 1969474192 11113744 13018336
22:02:32 50564 8192000000 10893548016 11362590720 1935864832 19.114 98 27 54 0 1954271696 10884384 7522480
22:03:53 44988 8192000000 10898970688 11376648192 1971253296 19.395 100 23 46 1 1993804496 16034128 6517072
22:04:52 12979 8192000000 10924734384 11374051328 1974778480 19.423 100 44 86 0 1995666608 9143760 11744368
22:05:11 15771 8192000000 10934682704 11376148480 1983838560 19.495 100 64 127 0 2015544272 13703760 18001952
22:05:38 36643 8192000000 10908478272 11376988160 1961489952 19.318 99 38 76 1 1983959520 12150800 10318768
22:06:23 50601 8192000000 10928854656 11387060224 1960124640 19.307 99 36 72 0 1983216224 13037712 10053872
22:07:26 66751 8192000000 10912194576 11392294912 1965970496 19.353 99 27 54 0 1993496992 19856144 7670352
22:08:52 104649 8192000000 10902214720 11382661120 1924504240 19.023 97 11 22 0 1938583376 11301216 2777920
22:10:42 39131 8192000000 10932565632 11383660544 1989412224 19.539 100 37 72 1 2008534624 8385600 10736800
22:11:29 91571 8192000000 10907172880 11379965952 1971372624 19.396 99 35 70 0 1989965568 8937408 9655536
22:13:40 70741 8192000000 10935602752 11402768384 1982166624 19.482 99 38 76 2 2004946992 12112272 10668096
22:14:59 14932 8192000000 10895571456 11362664448 1936478832 19.119 98 39 79 1 1960562544 12744416 11339296
22:15:26 42697 8192000000 10847233472 11323830272 1887384128 18.725 96 15 29 0 1901409088 9612176 4412784
22:16:15 88955 8192000000 10855275472 11338371072 1932444688 19.086 99 11 22 0 1952566560 17270192 2851680
22:17:50 32795 8192000000 10847965216 11330981888 1874349728 18.619 96 13 27 1 1888323024 10216944 3756352
22:18:29 21800 8192000000 10864292912 11343417344 1931207664 19.077 99 21 42 1 1944451616 7763600 5480352
22:18:57 43963 8192000000 10890340944 11349602304 1918037952 18.971 98 27 53 1 1935428448 9349616 8040880
22:20:12 57468 8192000000 10887822416 11362971648 1960302400 19.308 100 17 33 1 1980509008 15213248 4993360
22:21:20 57955 8192000000 10874244048 11344482304 1859755584 18.501 95 19 38 0 1883354256 18099344 5499328
22:22:30 94628 8192000000 10886399728 11356049408 1927365184 19.046 99 12 24 2 1952158064 21515344 3277536
22:24:10 62087 8192000000 10872471376 11340746752 1917628528 18.968 98 21 42 1 1944789888 20558064 6603296
22:25:49 69733 8192000000 10461405632 10893864960 1507127056 15.538 77 17 34 1 1526022912 14006848 4889008

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 126 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

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          239068
MON$OLDEST_ACTIVE               240044
MON$OLDEST_SNAPSHOT             240044
MON$NEXT_TRANSACTION            240044
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                       2019648
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33384 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33384 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33384 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33384 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 ---
:32: 
:33: mscs-test-161.budzdorov.ru    Tue Nov  3 22:27:11 2020
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
:36: 
:37: mscs-test-161.budzdorov.ru    Tue Nov  3 22:27:16 2020
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
--- end of diff output ---

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

03.11.20 22:28:46. 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-03 22:28:48 No severe PSQL-related problems occured
03.11.20 22:28:49. End of report.