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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17341556 kB
MemAvailable 31514512 kB
Buffers 0 kB
Cached 14367232 kB
SwapCached 2888 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-01 19:26:59
DTS_END                         2020-11-01 19:26:59.2790
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/44880
TRN_ID                          241513
ATT_ID                          690
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: 9402.65 25162 1128318
customer order: creation 168.82 387 20258
customer order: refuse 14.55 366 1746
order to supplier: creation 45.25 1479 5430
order to supplier: removal 3.53 97675 423
invoice (draft): creation 45.15 3595 5418
invoice (draft): removal 55.17 769 6620
invoice accept: apply 41.28 17450 4953
invoice accept: cancel 49.75 749 5970
customer reserve: creation 3832.27 171 459872
customer reserve: removal 4848.38 55 581806
realization accept: apply 81.40 196 9768
realization accept: cancel 87.08 106 10449
payment from customer: creation 59.58 116 7150
payment from customer: removal 5.97 82 716
payment to supplier: creation 49.13 114 5895
payment to supplier: removal 3.37 100 404
service: total inventory turnovers 4.65 1050 558
service: total monetary turnovers 6.42 42 770
service: aggregate perf. data 0.90 15276 108
service: refresh index statistics 0.03 363465 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-11-2020 19:29:19 to 01-11-2020 19:29:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4587
TEST_TIME 2 4839
TEST_TIME 3 3988
TEST_TIME 4 4416
TEST_TIME 5 4501
TEST_TIME 6 4370
TEST_TIME 7 4481
TEST_TIME 8 4307
TEST_TIME 9 4899
TEST_TIME 10 5208
TEST_TIME 11 5542
TEST_TIME 12 5738
TEST_TIME 13 5811
TEST_TIME 14 5887
TEST_TIME 15 6063
TEST_TIME 16 6044
TEST_TIME 17 6764
TEST_TIME 18 6908
TEST_TIME 19 7245
TEST_TIME 20 7401
TEST_TIME 21 7870
TEST_TIME 22 8441
TEST_TIME 23 8507
TEST_TIME 24 9003
TEST_TIME 25 8853
TEST_TIME 26 9015
TEST_TIME 27 9402
TEST_TIME 28 9428
TEST_TIME 29 9993
TEST_TIME 30 10402
TEST_TIME 31 10422
TEST_TIME 32 10285
TEST_TIME 33 10413
TEST_TIME 34 10458
TEST_TIME 35 10457
TEST_TIME 36 10473
TEST_TIME 37 10217
TEST_TIME 38 10072
TEST_TIME 39 9973
TEST_TIME 40 10007
TEST_TIME 41 10008
TEST_TIME 42 9856
TEST_TIME 43 9816
TEST_TIME 44 9692
TEST_TIME 45 9577
TEST_TIME 46 9731
TEST_TIME 47 9630
TEST_TIME 48 9546
TEST_TIME 49 9425
TEST_TIME 50 9399
TEST_TIME 51 9404
TEST_TIME 52 9416
TEST_TIME 53 9342
TEST_TIME 54 9335
TEST_TIME 55 9294
TEST_TIME 56 9251
TEST_TIME 57 9350
TEST_TIME 58 9526
TEST_TIME 59 9503
TEST_TIME 60 9483
TEST_TIME 61 9543
TEST_TIME 62 9549
TEST_TIME 63 9627
TEST_TIME 64 9595
TEST_TIME 65 9645
TEST_TIME 66 9689
TEST_TIME 67 9675
TEST_TIME 68 9716
TEST_TIME 69 9714
TEST_TIME 70 9586
TEST_TIME 71 9623
TEST_TIME 72 9544
TEST_TIME 73 9577
TEST_TIME 74 9507
TEST_TIME 75 9445
TEST_TIME 76 9454
TEST_TIME 77 9430
TEST_TIME 78 9393
TEST_TIME 79 9365
TEST_TIME 80 9346
TEST_TIME 81 9303
TEST_TIME 82 9379
TEST_TIME 83 9362
TEST_TIME 84 9490
TEST_TIME 85 9453
TEST_TIME 86 9485
TEST_TIME 87 9499
TEST_TIME 88 9514
TEST_TIME 89 9532
TEST_TIME 90 9611
TEST_TIME 91 9684
TEST_TIME 92 9679
TEST_TIME 93 9587
TEST_TIME 94 9525
TEST_TIME 95 9497
TEST_TIME 96 9460
TEST_TIME 97 9433
TEST_TIME 98 9440
TEST_TIME 99 9441
TEST_TIME 100 9429
TEST_TIME 101 9429
TEST_TIME 102 9435
TEST_TIME 103 9474
TEST_TIME 104 9475
TEST_TIME 105 9466
TEST_TIME 106 9521
TEST_TIME 107 9521
TEST_TIME 108 9495
TEST_TIME 109 9515
TEST_TIME 110 9548
TEST_TIME 111 9541
TEST_TIME 112 9501
TEST_TIME 113 9465
TEST_TIME 114 9433
TEST_TIME 115 9477
TEST_TIME 116 9414
TEST_TIME 117 9422
TEST_TIME 118 9436
TEST_TIME 119 9415
TEST_TIME 120 9407

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 01-11-2020 19:29:22 to 01-11-2020 19:29:26.

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 1553944 1553944 0 0.00 0 23386 6 0 0
doc_list_biud 1553944 1553944 0 0.00 0 39675 27 0 0
sp_add_invoice_to_stock 5066 4953 113 2.23 24 140365 17450 0 113
sp_cancel_adding_invoice 5970 5970 0 0.00 4 40597 749 0 0
sp_cancel_client_order 1746 1746 0 0.00 4 17142 367 0 0
sp_cancel_customer_reserve 581806 581806 0 0.00 1 31709 55 0 0
sp_cancel_pay_from_customer 716 716 0 0.00 3 6709 82 0 0
sp_cancel_pay_to_supplier 404 404 0 0.00 2 4883 100 0 0
sp_cancel_supplier_invoice 6629 6620 9 0.13 1 26276 769 0 9
sp_cancel_supplier_order 423 423 0 0.00 12 945149 97676 0 0
sp_cancel_write_off 10449 10449 0 0.00 1 25379 107 0 0
sp_client_order 20258 20258 0 0.00 3 28377 388 0 0
sp_customer_reserve 459872 459872 0 0.00 0 46168 171 0 0
sp_fill_shopping_cart 31093 31093 0 0.00 1 10545 39 0 0
sp_fill_shopping_cart_clo_res 459863 459863 0 0.00 0 12167 13 0 0
sp_get_clo_for_invoice 4944 4944 0 0.00 0 24254 299 0 0
sp_kill_cost_storno 17539 17539 0 0.00 0 23369 56 0 0
sp_kill_qstorno_ret_qs2qd 1181104 1181104 0 0.00 0 31590 30 0 0
sp_kill_qty_storno 621726 621726 0 0.00 0 39674 66 0 0
sp_lock_selected_doc 20480 20480 0 0.00 0 10689 8 0 0
sp_make_cost_storno 27757 27757 0 0.00 0 17096 53 0 0
sp_multiply_rows_for_pdistr 27757 27757 0 0.00 0 8104 28 0 0
sp_multiply_rows_for_qdistr 20258 20258 0 0.00 0 24556 171 0 0
sp_pay_from_customer 7150 7150 0 0.00 4 12902 117 0 0
sp_pay_to_supplier 5895 5895 0 0.00 5 11817 114 0 0
sp_payment_common 13045 13045 0 0.00 2 11121 32 0 0
sp_qd_handle_on_cancel_clo 1746 1746 0 0.00 0 17137 329 0 0
sp_qd_handle_on_invoice_upd_sts 10914 10914 0 0.00 0 39673 340 0 0
sp_qd_handle_on_reserve_upd_sts 9768 9768 0 0.00 0 28683 73 0 0
sp_reserve_write_off 9768 9768 0 0.00 6 28750 196 0 0
sp_supplier_invoice 5418 5418 0 0.00 6 106164 3595 0 0
sp_supplier_order 5430 5430 0 0.00 6 52805 1479 0 0
srv_aggregate_perf_data 108 108 0 0.00 2896 117613 15276 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1359 193530 32954 0 0
srv_find_qd_qs_mism 1080759 1080759 0 0.00 0 18496 5 0 0
srv_make_invnt_saldo 558 558 0 0.00 43 35352 1050 0 0
srv_make_money_saldo 770 770 0 0.00 1 13113 43 0 0
srv_recalc_idx_stat 4 4 0 0.00 180391 545077 363465 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4953 4953 0 0.00 0 16808 209 0 0
t$perf-norm:sp_cancel_adding_invoice 374 374 0 0.00 0 1769 65 0 0
t$perf-norm:sp_cancel_client_order 1746 1746 0 0.00 0 3384 15 0 0
t$perf-norm:sp_cancel_customer_reserve 729 729 0 0.00 0 3600 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 716 716 0 0.00 0 5770 33 0 0
t$perf-norm:sp_cancel_pay_to_supplier 404 404 0 0.00 0 3849 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 611 15 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 37995 1891 0 0
t$perf-norm:sp_cancel_write_off 978 978 0 0.00 0 7505 24 0 0
t$perf-norm:sp_client_order 20258 20258 0 0.00 0 35035 18 0 0
t$perf-norm:sp_customer_reserve 1036 1036 0 0.00 0 4421 14 0 0
t$perf-norm:sp_pay_from_customer 7150 7150 0 0.00 0 13958 14 0 0
t$perf-norm:sp_pay_to_supplier 5895 5895 0 0.00 0 8240 12 0 0
t$perf-norm:sp_reserve_write_off 9768 9768 0 0.00 0 34954 16 0 0
t$perf-norm:sp_supplier_invoice 5418 5418 0 0.00 0 10570 24 0 0
t$perf-norm:sp_supplier_order 5430 5430 0 0.00 0 4133 18 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 194 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 6716 91 0 0
t$perf-norm:srv_make_invnt_saldo 558 558 0 0.00 0 6127 33 0 0
t$perf-norm:srv_make_money_saldo 770 770 0 0.00 0 1558 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 264 68 0 0
v_add_invoice_to_stock 10114 9888 226 2.23 0 5374 20 0 226
v_all_customers 37258 37258 0 0.00 0 18 1 0 0
v_all_suppliers 30362 30362 0 0.00 0 31 1 0 0
v_all_wares 40516 40516 0 0.00 0 55 1 0 0
v_cancel_adding_invoice 748 748 0 0.00 0 198 5 0 0
v_cancel_client_order 3492 3492 0 0.00 0 4907 7 0 0
v_cancel_customer_prepayment 1432 1432 0 0.00 0 4064 9 0 0
v_cancel_customer_reserve 1458 1458 0 0.00 0 2385 5 0 0
v_cancel_payment_to_supplier 808 808 0 0.00 0 4638 15 0 0
v_cancel_supplier_invoice 814 796 18 2.21 0 4353 24 0 18
v_cancel_supplier_order 846 846 0 0.00 0 3990 14 0 0
v_cancel_write_off 1956 1956 0 0.00 0 8725 20 0 0
v_max_id_clo_ord 5428 5428 0 0.00 0 2993 2 0 0
v_max_id_clo_res 1036 1036 0 0.00 0 1796 17 0 0
v_max_id_ord_sup 5407 5407 0 0.00 0 4287 4 0 0
v_max_non_paid_invoice 1549 1549 0 0.00 0 913 4 0 0
v_max_non_paid_realizn 3759 3759 0 0.00 0 3126 4 0 0
v_min_id_clo_ord 5428 5428 0 0.00 0 4673 9 0 0
v_min_id_clo_res 1036 1036 0 0.00 0 1033 3 0 0
v_min_id_ord_sup 5407 5407 0 0.00 0 4896 7 0 0
v_min_non_paid_invoice 5895 5895 0 0.00 0 8801 19 0 0
v_min_non_paid_realizn 7150 7150 0 0.00 0 6590 23 0 0
v_our_firm 10040 10040 0 0.00 0 15 1 0 0
v_reserve_write_off 19536 19536 0 0.00 0 3120 6 0 0
x_lock_depdocs_on_canc_invoice 12192 12192 0 0.00 0 15117 111 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 8574 333 0 0
x_make_qstorno_1000_1200 5430 5430 0 0.00 1 52796 1397 0 0
x_make_qstorno_1200_2000 5418 5418 0 0.00 2 104452 3457 0 0
x_make_qstorno_2100_3300 459872 459872 0 0.00 0 46167 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-11-2020 19:29:27 to 01-11-2020 19:29:31.

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
16:57:03 1 8192000000 8798422528 8808923136 5084624 0.062 1 1 2 0 5202672 55488 62560
16:57:09 8192 8192000000 10176219040 10477621248 871903520 9.619 70 50 101 0 892388160 2545264 17939376
16:57:26 23724 8192000000 10334471616 10650599424 1356846512 14.209 100 76 151 3 1385676544 4358432 24471600
16:58:01 33549 8192000000 10391969440 10713374720 1433158528 14.889 100 86 172 0 1466707472 5907056 27641888
16:58:45 36407 8192000000 10426894864 10751913984 1466601920 15.184 100 94 188 1 1504922384 7645312 30675152
16:59:33 7467 8192000000 10435447920 10764468224 1490197440 15.391 100 91 182 0 1527597168 8223840 29175888
17:00:15 24507 8192000000 10456020304 10791866368 1509712384 15.561 100 85 170 0 1545819568 9132272 26974912
17:00:52 21979 8192000000 10478999824 10822877184 1535723488 15.787 100 87 174 0 1573052624 9931312 27397824
17:01:29 14946 8192000000 10503937648 10853306368 1560164912 15.998 100 81 162 1 1595148960 10042512 24941536
17:01:56 18466 8192000000 10539741296 10890297344 1589106256 16.246 100 78 156 1 1622848752 9963696 23778800
17:02:23 13694 8192000000 10574722384 10929156096 1622204064 16.529 100 83 166 0 1657653760 9755664 25694032
17:02:46 13391 8192000000 10595644240 10955018240 1648360896 16.751 100 78 156 1 1682504016 11365136 22777984
17:03:08 10633 8192000000 10625936144 10987298816 1678074496 17.001 100 85 170 1 1714630368 12152384 24403488
17:03:29 7709 8192000000 10643464768 11006517248 1699800096 17.183 100 89 178 0 1738630624 13244448 25586080
17:03:45 8953 8192000000 10644568736 11013619712 1709663424 17.266 100 87 172 0 1748962704 14186432 25112848
17:04:04 6760 8192000000 10661143808 11030016000 1714972304 17.310 100 84 168 1 1753017104 14021808 24022992
17:04:20 8872 8192000000 10673264848 11045126144 1729520288 17.432 100 85 170 1 1768409888 14612016 24277584
17:04:36 6326 8192000000 10689770432 11064446976 1750137328 17.603 100 87 174 0 1789582720 14406800 25038592
17:04:49 4493 8192000000 10708159392 11080409088 1764286288 17.720 100 87 175 0 1802067472 12840352 24940832
17:05:00 6320 8192000000 10703411136 11083198464 1767629232 17.747 100 80 160 0 1803781312 12761824 23390256
17:05:16 4974 8192000000 10716126928 11095412736 1773752976 17.798 100 82 164 0 1811338336 14016656 23568704
17:05:28 5470 8192000000 10724405600 11100966912 1782696816 17.872 100 88 174 2 1821553392 14367664 24488912
17:05:41 3444 8192000000 10718965760 11105443840 1791277328 17.942 100 77 154 1 1826387216 13097840 22012048
17:05:51 3676 8192000000 10729258192 11112427520 1799172784 18.007 100 83 166 1 1835258096 13716288 22369024
17:06:02 2858 8192000000 10747409520 11124342784 1801848416 18.029 100 80 159 0 1837281600 13066224 22366960
17:06:12 2214 8192000000 10744928176 11132235776 1812373792 18.115 100 86 171 0 1848813904 12336464 24103648
17:06:20 8635 8192000000 10745418336 11133698048 1815122544 18.138 100 75 150 0 1847405056 12003808 20278704
17:06:36 3267 8192000000 10770146576 11152142336 1823119312 18.203 100 89 179 0 1860665008 12525824 25019872
17:06:45 2496 8192000000 10781729504 11163025408 1834589440 18.297 100 92 187 0 1873654848 12317712 26747696
17:06:54 2486 8192000000 10775272304 11160244224 1836401536 18.312 100 89 179 0 1874046560 12865296 24779728
17:07:03 2191 8192000000 10792093072 11173453824 1840964176 18.349 100 90 180 2 1879984560 13631008 25389376
17:07:12 2044 8192000000 10799106272 11181453312 1850929728 18.430 100 92 185 0 1891892064 14772512 26189824
17:07:20 1478 8192000000 10798420096 11187142656 1853419104 18.450 100 90 179 2 1892463104 14197008 24846992
17:07:28 1223 8192000000 10805642592 11192725504 1861715856 18.517 100 95 190 1 1902201472 14459168 26026448
17:07:36 1888 8192000000 10810462512 11196977152 1862038784 18.520 100 89 176 1 1900513216 13730144 24744288
17:07:44 2163 8192000000 10805579440 11196289024 1865945936 18.551 100 93 185 1 1904566640 12351920 26268784
17:07:52 1735 8192000000 10816766784 11203698688 1871877904 18.599 100 94 192 0 1912462336 13328208 27256224
17:08:00 1577 8192000000 10820366816 11211112448 1874140336 18.618 100 90 180 1 1913071808 13007344 25924128
17:08:08 1595 8192000000 10819565248 11210080256 1879427088 18.660 100 96 193 0 1920858080 13901696 27529296
17:08:16 3600 8192000000 10805784176 11211878400 1878428800 18.652 100 81 163 2 1913091728 12472752 22190176
17:08:26 43227 8192000000 10796691376 11203919872 1871213712 18.594 100 52 104 2 1892635984 6791152 14631120
17:09:15 18826 8192000000 10795104000 11215388672 1876412112 18.636 100 62 125 3 1904816320 10894576 17509632
17:09:42 5778 8192000000 10780140288 11207761920 1870757312 18.590 100 18 36 0 1882588064 6494576 5336176
17:09:54 11269 8192000000 10788510240 11211890688 1876620672 18.638 100 29 58 0 1891971120 7097776 8252672
17:10:18 3743 8192000000 10780884144 11218116608 1880197312 18.667 100 20 40 1 1892415984 6488992 5729680
17:10:28 3481 8192000000 10796541920 11223044096 1888586448 18.734 100 31 62 1 1904098928 6755536 8756944
17:10:41 7698 8192000000 10801730240 11229978624 1884695488 18.703 100 15 30 1 1894208672 5597168 3916016
17:10:54 5610 8192000000 10798633776 11231125504 1894347696 18.781 100 36 72 1 1912670736 7958976 10364064
17:11:07 7369 8192000000 10811575664 11237314560 1898374288 18.813 100 32 64 2 1914441488 6716128 9351072
17:11:20 9352 8192000000 10806354368 11238133760 1897650736 18.807 100 26 52 3 1911233072 5812656 7769680
17:11:40 11151 8192000000 10811756512 11241426944 1899200464 18.820 100 16 32 3 1910008112 5771568 5036080
17:11:57 14126 8192000000 10802708400 11243638784 1900274848 18.829 100 15 30 1 1910733376 5931536 4526992
17:12:21 7842 8192000000 10804067968 11242467328 1901831120 18.841 100 16 31 1 1911749232 5246944 4671168
17:12:38 8527 8192000000 10814660288 11244306432 1902149520 18.844 100 18 36 1 1917447344 10302528 4995296
17:12:57 15375 8192000000 10808132336 11249541120 1907395360 18.886 100 14 28 1 1916179728 5298704 3485664
17:13:22 74089 8192000000 10819514864 11260424192 1911651296 18.920 100 33 66 3 1926614976 5285184 9678496
17:14:42 11207 8192000000 10818720464 11261923328 1908962144 18.898 100 10 20 1 1917153392 5513472 2677776
17:15:00 7993 8192000000 10835920512 11267252224 1913647408 18.936 100 35 69 4 1929773616 6275776 9850432
17:15:18 4208 8192000000 10842763728 11268808704 1914692432 18.944 100 33 66 3 1929320992 5346848 9281712
17:15:33 5426 8192000000 10825897536 11261865984 1894739296 18.784 99 31 61 3 1909704640 6413440 8551904
17:15:45 4394 8192000000 10834415904 11268112384 1911820272 18.921 100 32 64 1 1927809568 6618832 9370464
17:15:56 5558 8192000000 10830960496 11266134016 1913566928 18.935 100 28 56 0 1927680240 6044992 8068320
17:16:08 8849 8192000000 10822067824 11264688128 1892279904 18.764 99 20 41 0 1908135728 10144800 5711024
17:16:26 8054 8192000000 10801303696 11230650368 1862380784 18.523 98 19 38 1 1873825456 5605840 5838832
17:16:40 8099 8192000000 10793164208 11225157632 1836264176 18.310 97 20 40 0 1848694960 5559712 6871072
17:16:54 8161 8192000000 10789516688 11224113152 1878076816 18.650 100 27 54 1 1896103696 10183488 7843392
17:17:11 7157 8192000000 10785237600 11220156416 1849011968 18.414 98 21 42 0 1860643136 5699648 5931520
17:17:25 7662 8192000000 10763328256 11187625984 1802438080 18.034 97 16 32 1 1812326336 5355344 4532912
17:17:42 7730 8192000000 10743074976 11169316864 1778123856 17.834 96 31 60 1 1792296112 5664496 8507760
17:17:55 10216 8192000000 10751383712 11178278912 1775298400 17.811 96 14 28 0 1784288928 5527168 3463360
17:18:12 62598 8192000000 10763241536 11184189440 1785975808 17.899 97 36 71 0 1801577568 4710624 10891136
17:19:22 14684 8192000000 10700986144 11106349056 1647945456 16.747 90 15 27 0 1657194672 5043424 4205792
17:19:44 2926 8192000000 10691723824 11106631680 1749771376 17.600 98 36 72 1 1766886672 6903008 10212288
17:19:54 4648 8192000000 10699355840 11103244288 1751130720 17.611 98 32 65 2 1764973104 5394656 8447728
17:20:08 3742 8192000000 10697199344 11107643392 1742359744 17.538 97 27 54 0 1756108144 5558192 8190208
17:20:18 6268 8192000000 10691492608 11107147776 1754831856 17.642 98 23 43 0 1767044704 5726208 6486640
17:20:33 7234 8192000000 10680440096 11095777280 1758363600 17.671 99 26 51 1 1772085216 5377456 8344160
17:20:48 7216 8192000000 10698056656 11114119168 1756058704 17.652 98 28 56 0 1769548880 5566368 7923808
17:21:01 6217 8192000000 10703632768 11123048448 1790496176 17.936 100 32 63 3 1806115440 6399872 9219392
17:21:20 5010 8192000000 10727820160 11133431808 1800051184 18.014 100 44 88 1 1822875104 9683792 13140128
17:21:32 4033 8192000000 10733670304 11144110080 1809406624 18.091 100 38 74 2 1827863600 6574096 11882880
17:21:43 6836 8192000000 10727867040 11147067392 1814157008 18.130 100 41 82 3 1832540048 6101728 12281312
17:22:00 11259 8192000000 10750850032 11170787328 1832745568 18.282 100 36 70 1 1849324864 6252064 10327232
17:22:21 11863 8192000000 10757817760 11174084608 1835866192 18.307 100 23 46 3 1848063104 5181824 7015088
17:22:44 52571 8192000000 10768022480 11179528192 1847446880 18.401 100 34 69 3 1866927216 9602848 9877488
17:23:53 12899 8192000000 10754499808 11182350336 1845290448 18.384 100 25 50 1 1859061056 5882288 7888320
17:24:12 7700 8192000000 10774660640 11197214720 1857607072 18.484 100 32 65 1 1871389408 5933104 7849232
17:24:26 7178 8192000000 10777168752 11197952000 1856298160 18.473 100 28 56 0 1871171008 6516752 8356096
17:24:45 8774 8192000000 10790116144 11208646656 1862703760 18.525 100 33 66 0 1879108240 7617024 8787456
17:25:00 7007 8192000000 10784953168 11206762496 1865139680 18.545 100 36 72 3 1880606816 6089600 9377536
17:25:13 5502 8192000000 10774770368 11207639040 1865487360 18.548 100 24 48 1 1878815504 6449056 6879088
17:25:29 11067 8192000000 10771057200 11203817472 1866635744 18.557 100 14 28 1 1875707168 5585184 3486240
17:25:46 11367 8192000000 10783794944 11213967360 1870124960 18.585 100 17 34 0 1880406736 5458752 4823024
17:26:06 6223 8192000000 10796846096 11222814720 1875142272 18.626 100 19 39 0 1889781840 9586416 5053152
17:26:20 12399 8192000000 10794508448 11222929408 1873074064 18.609 100 9 18 2 1881318784 5303232 2941488
17:26:43 9842 8192000000 10781624896 11216855040 1876331600 18.635 100 16 32 0 1886461168 5201456 4928112
17:26:59 7209 8192000000 10799748064 11229552640 1882699152 18.687 100 25 49 0 1894934208 5111120 7123936
17:27:13 18336 8192000000 10846743280 11255930880 1905064032 18.867 100 55 109 2 1926944336 5865072 16015232
17:27:39 4961 8192000000 10856131008 11265458176 1918891152 18.978 100 67 134 1 1946828048 8981888 18955008
17:27:53 24110 8192000000 10853631200 11271032832 1921169392 18.996 100 57 113 2 1945938064 9433600 15335072
17:28:26 19894 8192000000 10857350368 11278204928 1926647600 19.040 100 42 84 0 1947576736 9058720 11870416
17:28:55 70231 8192000000 10873700112 11298222080 1937031440 19.123 100 52 103 0 1962046384 9965472 15049472
17:30:13 44918 8192000000 10864270128 11305574400 1943678480 19.176 100 34 68 1 1963108480 9708160 9721840
17:31:09 37180 8192000000 10870028896 11318644736 1951457616 19.238 100 26 52 1 1972249856 12930880 7861360
17:32:01 27190 8192000000 10899011104 11325681664 1954644432 19.263 100 31 62 0 1975228400 11629120 8954848
17:32:34 24995 8192000000 10907131344 11340701696 1969996848 19.385 100 53 105 1 2002566912 16722144 15847920
17:33:09 13221 8192000000 10901245904 11333181440 1968042464 19.370 100 40 78 0 1996528176 16633648 11852064
17:33:30 25259 8192000000 10914581920 11345354752 1970084064 19.386 100 41 80 2 1999430208 17252160 12093984
17:34:04 23538 8192000000 10931778848 11366899712 1978633456 19.454 100 34 68 2 2009834688 20756256 10444976
17:34:39 37372 8192000000 10930004192 11374698496 1987270336 19.522 100 32 64 0 2022793776 25008384 10515056
17:35:24 6102 8192000000 10925678640 11363627008 1984598064 19.501 100 37 75 0 2017462864 21199104 11665696
17:35:40 7804 8192000000 10945750848 11369656320 1991856192 19.558 100 64 125 1 2034781920 23795968 19129760
17:35:56 13162 8192000000 10948302384 11380133888 1991918624 19.559 100 49 98 4 2032276016 25449936 14907456
17:36:16 4350 8192000000 10948366848 11374637056 1989670256 19.541 100 65 130 5 2036405360 26499216 20235888
17:36:29 3941 8192000000 10956117840 11383877632 1994861152 19.582 100 62 125 1 2042306704 28073072 19372480
17:36:41 2306 8192000000 10966148192 11383263232 2002482512 19.642 100 86 167 1 2054060768 26716528 24861728
17:36:51 4223 8192000000 10958635984 11374645248 1986286688 19.514 99 84 169 0 2038269392 27459056 24523648
17:37:03 4736 8192000000 10943687728 11369402368 1982739024 19.486 99 63 125 1 2029628448 28326896 18562528
17:37:17 4170 8192000000 10956103728 11386085376 1999575888 19.619 100 60 120 1 2045168048 27938352 17653808
17:37:28 7803 8192000000 10965317088 11386650624 2003332832 19.649 100 62 124 0 2047690576 25709232 18648512
17:37:45 7400 8192000000 10953994320 11384516608 1987098160 19.521 99 64 128 1 2038453712 31867184 19488368
17:38:13 8877 8192000000 10948751968 11379064832 1995894496 19.590 100 65 129 0 2043169712 27089872 20185344
17:38:30 3945 8192000000 10941197312 11361357824 1963548608 19.334 99 65 131 1 2015646048 31767392 20330048
17:38:41 10717 8192000000 10930372896 11366711296 1984650736 19.502 100 52 104 2 2026636384 25792368 16193280
17:39:07 4592 8192000000 10930081760 11354861568 1967374752 19.365 99 56 110 0 2014886032 30658064 16853216
17:39:20 3487 8192000000 10948366400 11375554560 1989510096 19.540 100 64 128 2 2036597472 27122752 19964624
17:39:31 3952 8192000000 10963207904 11384786944 1998650128 19.612 100 65 129 0 2045595984 27641664 19304192
17:39:41 5200 8192000000 10971748928 11395510272 2011770944 19.715 100 72 142 1 2059895248 27329392 20794912
17:39:59 4593 8192000000 10960062176 11381334016 1993632608 19.572 100 76 148 0 2044665552 28540608 22492336
17:40:10 8577 8192000000 10970611824 11394560000 2005024592 19.662 100 69 138 1 2057791280 32144800 20621888
17:40:31 5904 8192000000 10964889504 11388551168 1980834736 19.471 99 61 122 0 2032962752 33227104 18900912
17:40:45 2220 8192000000 10977196640 11392892928 1997960960 19.607 100 66 131 0 2051717440 33576272 20180208
17:40:55 5178 8192000000 10968365712 11392057344 2004074944 19.655 100 76 151 1 2061014080 33364272 23574864
17:41:08 2469 8192000000 10933863488 11358302208 1963005472 19.330 98 65 129 0 2014125472 31066928 20053072
17:41:19 5052 8192000000 10953208688 11378741248 1973434640 19.413 99 66 129 1 2025460288 32247824 19777824
17:41:32 3065 8192000000 10956772656 11377262592 1985713696 19.510 100 66 131 1 2039337136 32658720 20964720
17:41:43 6835 8192000000 10964371728 11386810368 1992012336 19.560 100 70 140 1 2047881616 33249856 22619424
17:42:02 3919 8192000000 10952940656 11371417600 1978442544 19.452 100 67 133 0 2034352384 34412752 21497088
17:42:14 11593 8192000000 10919120576 11343204352 1942234160 19.165 98 62 123 2 1997070816 35506416 19330240
17:42:32 2376 8192000000 10941478128 11351650304 1940677904 19.152 98 75 150 0 2001641200 37258336 23704960
17:42:41 3401 8192000000 10958569968 11375263744 1976749632 19.439 100 77 154 0 2040138448 39293408 24095408
17:42:51 3874 8192000000 10941391824 11355541504 1958309792 19.293 99 78 155 4 2022448336 39920320 24218224
17:43:07 3576 8192000000 10954897168 11376209920 1977301056 19.443 100 80 160 1 2044266704 41047744 25917904
17:43:17 2801 8192000000 10945882000 11359592448 1958306960 19.293 100 74 148 0 2026742992 44502464 23933568
17:43:28 3418 8192000000 10958004496 11370688512 1970326624 19.388 100 84 166 1 2041422912 45787984 25308304
17:43:39 2540 8192000000 10957303520 11369824256 1967071600 19.362 100 79 158 0 2038489552 47109808 24308144
17:43:49 2032 8192000000 10960666480 11369033728 1973332144 19.412 100 96 193 0 2045175344 42482736 29360464
17:43:57 3744 8192000000 10955755584 11373977600 1976170064 19.434 100 80 161 2 2039709392 39455232 24084096
17:44:09 4954 8192000000 10947672736 11360055296 1962992864 19.330 100 81 163 1 2026574336 38662800 24918672
17:44:21 5942 8192000000 10946714720 11365908480 1966744832 19.360 100 72 144 3 2029107824 39808336 22554656
17:44:35 4306 8192000000 10958376256 11375620096 1978894080 19.456 100 76 151 3 2045751888 43009696 23848112
17:44:47 2625 8192000000 10951043424 11361812480 1955112016 19.267 99 85 170 1 2025300960 43366496 26822448
17:44:58 6539 8192000000 10937780224 11360440320 1955018768 19.266 100 61 122 2 2018650176 43730048 19901360
17:45:12 5332 8192000000 10923312048 11349975040 1951433088 19.238 100 56 112 0 2008406288 39025120 17948080
17:45:24 2528 8192000000 10916525744 11342172160 1928523104 19.055 99 54 105 1 1985535152 39811920 17200128
17:45:35 10097 8192000000 10917208096 11352178688 1950712176 19.232 100 49 98 0 2006966384 40516864 15737344
17:45:56 2511 8192000000 10942687424 11359563776 1960378368 19.309 100 70 139 0 2023592928 41304448 21910112
17:46:06 4428 8192000000 10946902960 11360980992 1959955792 19.306 100 80 160 1 2029883040 44315712 25611536
17:46:17 2929 8192000000 10957610000 11371753472 1966654320 19.359 100 73 142 4 2037413872 47792192 22967360
17:46:33 1359 8192000000 10921376640 11324477440 1916602304 18.960 98 84 168 2 1991261904 47297504 27362096
17:46:44 4699 8192000000 10936888576 11351887872 1949247792 19.220 100 76 150 0 2022554256 48220896 25085568
17:46:58 5811 8192000000 10930040512 11354169344 1932632416 19.088 99 55 109 1 1998958336 47863856 18462064
17:47:13 4329 8192000000 10931455776 11356037120 1947477328 19.206 100 62 124 0 2015195312 47599392 20118592
17:47:25 4845 8192000000 10930201776 11353829376 1943368576 19.174 100 61 120 1 2014733680 51796160 19568944
17:47:39 4337 8192000000 10933069632 11349667840 1937541216 19.127 100 74 144 2 2012406704 51301072 23564416
17:47:54 3674 8192000000 10918933632 11341901824 1932488000 19.087 100 59 117 2 2000403264 49043984 18871280
17:48:10 15005 8192000000 10876521840 11304325120 1872793072 18.607 97 37 73 3 1926849984 41427424 12629488
17:48:34 17968 8192000000 10876441024 11317321728 1916953296 18.962 100 33 66 1 1964694016 37137904 10602816
17:49:08 20346 8192000000 10883720624 11321225216 1920103408 18.988 100 25 50 1 1962754224 33645456 9005360
17:49:35 6462 8192000000 10876229184 11294306304 1896900848 18.801 98 46 90 2 1947537584 35747408 14889328
17:49:57 18411 8192000000 10891781040 11337187328 1932438656 19.086 100 35 70 1 1984914144 41154560 11320928
17:50:22 15667 8192000000 10902076128 11350745088 1942226688 19.165 100 27 54 3 1985951520 35244512 8480320
17:50:48 24528 8192000000 10900463056 11351707648 1942340256 19.165 100 28 56 2 1988145904 36725104 9080544
17:51:19 30106 8192000000 10876926592 11307798528 1897728704 18.808 98 33 66 1 1944157664 35568896 10860064
17:51:58 9315 8192000000 10892447840 11330273280 1929244816 19.061 100 34 68 0 1978907376 39009456 10653104
17:52:20 7629 8192000000 10903629280 11333083136 1924542896 19.023 100 44 84 2 1977803104 40125728 13134480
17:52:35 1981 8192000000 10952557568 11357843456 1951485456 19.238 100 86 172 1 2022553488 44879952 26188080
17:52:47 15033 8192000000 10918730592 11365453824 1949057616 19.219 100 41 82 0 2006648752 44368560 13222576
17:53:09 18693 8192000000 10911032352 11368198144 1945357104 19.189 100 21 40 1 1998210480 45178592 7674784
17:53:34 13578 8192000000 10911599184 11370332160 1945121632 19.188 100 20 40 0 1998614912 46555264 6938016
17:54:02 34338 8192000000 10892241376 11355492352 1925747904 19.033 99 16 31 1 1971208208 39917616 5542688
17:54:47 34951 8192000000 10919278144 11368267776 1941969920 19.162 100 24 48 1 1998833312 49011456 7851936
17:55:29 26761 8192000000 10902504800 11367133184 1946978720 19.202 100 23 46 2 2004083424 49151264 7953440
17:56:03 44235 8192000000 10875837120 11339685888 1893342176 18.773 97 13 26 1 1925300448 27359696 4598576
17:56:54 15191 8192000000 10848421264 11289808896 1894652288 18.783 98 25 51 4 1919574896 17460128 7462480
17:57:16 46321 8192000000 10879759696 11328032768 1946275520 19.197 100 22 44 0 1963557792 10619904 6662368
17:58:12 36094 8192000000 10898759632 11342540800 1943386656 19.174 99 34 68 1 1971224592 17845232 9992704
17:58:55 40218 8192000000 10898117232 11347398656 1944638208 19.184 99 30 60 0 1965127104 12134224 8354672
18:00:55 105479 8192000000 10914339936 11375865856 1973928032 19.417 100 15 30 0 1997932032 20333264 3670736
18:02:49 112540 8192000000 10903749312 11364032512 1970374816 19.388 100 20 40 0 1987788832 11610800 5803216
18:04:49 47877 8192000000 10890249232 11352694784 1958916944 19.297 99 21 42 0 1970901776 6535072 5449760
18:05:44 21030 8192000000 10914150288 11365130240 1974254048 19.419 100 31 63 0 1991582544 8040928 9287568
18:06:22 34360 8192000000 10896332288 11375644672 1977917408 19.448 100 23 46 2 1995820880 11078224 6825248
18:07:03 43967 8192000000 10921757424 11377541120 1986318480 19.515 100 36 71 4 2008866928 10895904 11652544
18:07:53 38587 8192000000 10891304736 11357310976 1947304240 19.205 98 23 46 1 1962539520 8871472 6363808
18:08:42 32162 8192000000 10926045792 11374587904 1986627696 19.517 100 43 85 2 2005780144 6986304 12166144
18:09:34 17170 8192000000 10912222912 11382026240 1985483776 19.508 100 25 49 1 2003330864 10792176 7054912
18:09:58 61427 8192000000 10912436208 11387985920 1988894192 19.535 100 11 22 0 2001712352 9399872 3418288
18:11:34 54265 8192000000 10900309984 11376873472 1980306384 19.467 100 19 38 1 1999270128 13174720 5789024
18:12:34 43965 8192000000 10914294624 11381665792 1965235824 19.348 99 15 29 0 1980144672 11297968 3610880
18:13:25 22115 8192000000 10903758448 11368148992 1950903936 19.234 98 24 46 2 1963493248 6127232 6462080
18:13:54 76388 8192000000 10904888928 11371716608 1967716672 19.367 99 21 42 1 1980364160 7242048 5405440
18:15:17 130664 8192000000 10896921024 11382632448 1975123840 19.426 99 31 62 1 1998727632 13827472 9776320
18:17:39 46373 8192000000 10929328272 11400077312 1991928896 19.559 100 24 47 1 2018137024 18954736 7253392
18:18:32 19455 8192000000 10898965840 11361869824 1945793184 19.193 98 22 44 2 1964286464 12274688 6218592
18:18:58 62881 8192000000 10896785232 11373699072 1938463024 19.134 98 31 62 0 1957148336 9613264 9072048
18:20:09 61105 8192000000 10883582560 11362975744 1932695200 19.088 98 9 18 0 1951428544 15805184 2928160
18:21:21 49214 8192000000 10893516640 11368652800 1952214416 19.244 99 19 37 0 1970022912 12083680 5724816
18:22:24 75011 8192000000 10906264640 11372179456 1895238000 18.788 96 16 32 2 1918673824 18958432 4477392
18:23:45 48516 8192000000 10865083920 11348668416 1916562608 18.959 98 15 30 0 1942484928 20883504 5038816
18:24:41 69919 8192000000 10874682464 11346980864 1905641008 18.872 98 9 18 0 1918893600 10796688 2455904
18:26:01 64313 8192000000 10896158816 11351347200 1927401712 19.046 98 27 52 2 1943076256 8737264 6937280
18:27:11 72602 8192000000 10876615600 11346890752 1867535472 18.564 95 17 34 0 1882515008 10702480 4277056
18:28:34 45028 8192000000 10889777840 11352911872 1915147872 18.948 98 15 30 1 1928308480 9360800 3799808
18:29:28 70465 8192000000 10897611552 11336396800 1866793136 18.558 95 21 42 1 1885194848 12639856 5761856
18:30:49 24509 8192000000 10889698864 11348185088 1944038192 19.179 99 44 88 0 1967168592 10500608 12629792
18:31:30 27399 8192000000 10882220800 11340304384 1900065728 18.827 97 21 42 0 1915065472 9483456 5516288
18:32:09 52339 8192000000 10872228896 11329658880 1865953632 18.552 96 20 40 0 1880772128 9146016 5672480
18:33:14 39811 8192000000 10872814384 11320029184 1890137376 18.747 97 33 66 0 1907827024 9426064 8263584
18:34:12 58178 8192000000 10859621376 11319169024 1854358240 18.458 96 18 36 1 1873680000 14489488 4832272
18:35:17 111282 8192000000 10867476768 11310104576 1851974592 18.438 96 25 49 2 1871523344 11805584 7743168
18:37:23 96097 8192000000 10840340832 11306704896 1839955248 18.340 95 21 42 1 1856533824 10640128 5938448
18:39:05 28647 8192000000 10835943264 11302481920 1876319472 18.635 98 20 40 1 1896302624 13990096 5993056
18:39:51 46853 8192000000 10831496272 11301150720 1893879408 18.777 99 18 37 0 1905275824 6077872 5318544
18:40:52 48656 8192000000 10831747440 11298332672 1864647856 18.541 97 9 18 1 1875781472 8361440 2772176
18:41:47 75670 8192000000 10848022992 11328622592 1924373968 19.022 100 16 32 1 1939662256 10623888 4664400
18:43:18 70415 8192000000 10828562240 11311050752 1902298496 18.845 99 9 18 0 1916562272 11552048 2711728
18:44:41 37435 8192000000 10847241392 11308163072 1907919664 18.890 99 20 39 0 1920878032 7168960 5789408
18:45:25 53718 8192000000 10849759648 11327475712 1911745888 18.921 99 4 8 0 1919479424 6736464 997072
18:46:25 49272 8192000000 10856230352 11324018688 1890844704 18.753 97 22 44 2 1906917392 10331104 5741584
18:47:20 36434 8192000000 10878255488 11337035776 1925835328 19.034 99 35 70 0 1946998656 11396432 9766896
18:48:09 44149 8192000000 10876332544 11351064576 1927220080 19.045 99 19 38 0 1945112336 12227680 5664576
18:49:13 124821 8192000000 10869853824 11357675520 1932546736 19.087 99 14 27 1 1951550736 14924976 4079024
18:51:24 49276 8192000000 10882445104 11346501632 1942289344 19.165 99 18 36 0 1959266128 11841696 5135088
18:52:38 48207 8192000000 10879900480 11355316224 1934707312 19.104 99 22 44 0 1957037104 16109072 6220720
18:53:33 28258 8192000000 10878572160 11337125888 1919247744 18.981 98 35 67 1 1936784176 8428496 9107936
18:54:09 77805 8192000000 10897572944 11368296448 1935316320 19.109 99 21 42 3 1950307664 9221616 5769728
18:56:28 87899 8192000000 10918155904 11414896640 1978686752 19.454 100 21 41 0 2003080816 18682736 5711328
18:58:04 115873 8192000000 10893360656 11366293504 1921347040 18.998 97 16 32 0 1943006688 17664704 3994944
19:00:51 63030 8192000000 10903259952 11387490304 1982869632 19.487 100 26 52 0 2001080160 10501968 7708560
19:02:03 83405 8192000000 10917053904 11408195584 1990955312 19.551 100 8 16 1 2006434624 13088000 2391312
19:03:50 64530 8192000000 10897975072 11371155456 1938406512 19.134 98 10 20 0 1952647392 11584096 2656784
19:05:00 68954 8192000000 10896626864 11371429888 1944641840 19.184 98 19 38 1 1967448720 17323680 5483200
19:06:18 46462 8192000000 10906968944 11381534720 1940009728 19.147 98 16 32 1 1956039536 11616320 4413488
19:07:11 32035 8192000000 10918800976 11383410688 1966677360 19.359 99 20 39 2 1982267344 10086192 5503792
19:07:54 42317 8192000000 10941221584 11390025728 1971947088 19.401 99 28 56 0 1989362832 8538912 8876832
19:08:45 34187 8192000000 10874023200 11340054528 1936070880 19.115 97 35 70 0 1957189984 11401968 9717136
19:09:30 193530 8192000000 10906152704 11400581120 1840858448 18.348 93 21 41 2 1861111744 14253232 6000064
19:12:50 100848 8192000000 10907848784 11366727680 1915495552 18.951 97 12 24 1 1931382000 13021008 2865440
19:14:48 18409 8192000000 10926375552 11366768640 1918233104 18.973 97 48 96 1 1942448416 10640352 13574960
19:15:13 46434 8192000000 10904521120 11364077568 1926326624 19.037 98 31 61 1 1948974496 13950320 8697552
19:16:09 55130 8192000000 10884649456 11341135872 1919438832 18.982 98 28 56 1 1939386336 12664624 7282880
19:17:25 94663 8192000000 10899013216 11358216192 1954834288 19.265 100 29 59 2 1982060272 19052752 8173232
19:19:06 60759 8192000000 10863231056 11332960256 1920756800 18.993 98 19 38 0 1932269216 6185056 5327360
19:20:17 51216 8192000000 10866599168 11326205952 1870623296 18.589 96 11 22 0 1883247616 9575760 3048560
19:21:22 65864 8192000000 10859489824 11347894272 1929701664 19.064 100 11 22 0 1954232208 20680128 3850416
19:22:41 31189 8192000000 10867068768 11353858048 1934673520 19.104 100 14 28 0 1962369184 23446224 4249440
19:23:18 26170 8192000000 10842306944 11322519552 1872584048 18.605 97 8 14 0 1894164352 19606768 1973536
19:24:05 70829 8192000000 10847073520 11322724352 1891785520 18.760 98 15 30 0 1905070800 8919616 4365664
19:26:06 48059 8192000000 10842396528 11316469760 1894299152 18.780 98 18 35 1 1908395728 8721136 5375440

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 01-11-2020 19:29:33 to 01-11-2020 19:30:04.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
user_exc 113 v_add_invoice_to_stock 335544517
user_exc 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-11-2020 19:30:05 to 01-11-2020 19:30:07.

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          241512
MON$OLDEST_ACTIVE               242009
MON$OLDEST_SNAPSHOT             242009
MON$NEXT_TRANSACTION            242009
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                       2039008
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.33383 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33383 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33383 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33383 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 ---
:157: 
:158: mscs-test-161.budzdorov.ru    Sun Nov  1 19:27:01 2020
:159:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:160: 
--- end of diff output ---

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

01.11.20 19:30:08. 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-01 19:30:10 No severe PSQL-related problems occured
01.11.20 19:30:11. End of report.