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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17282512 kB
MemAvailable 31416592 kB
Buffers 0 kB
Cached 14433744 kB
SwapCached 4864 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-07 16:27:11
DTS_END                         2021-01-07 16:27:11.6970
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58268
TRN_ID                          247871
ATT_ID                          725
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9485.92 20685 1138310
customer order: creation 182.23 349 21868
customer order: refuse 15.84 367 1901
order to supplier: creation 47.88 1172 5746
order to supplier: removal 3.37 97851 404
invoice (draft): creation 48.85 3157 5862
invoice (draft): removal 52.16 722 6259
invoice accept: apply 45.09 15856 5411
invoice accept: cancel 47.10 776 5652
customer reserve: creation 4122.17 157 494660
customer reserve: removal 4613.08 57 553570
realization accept: apply 88.63 171 10636
realization accept: cancel 81.51 111 9781
payment from customer: creation 63.07 108 7568
payment from customer: removal 6.02 82 722
payment to supplier: creation 51.99 132 6239
payment to supplier: removal 3.83 68 460
service: total inventory turnovers 5.28 1093 633
service: total monetary turnovers 6.98 27 837
service: aggregate perf. data 0.81 24244 97
service: refresh index statistics 0.03 267206 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-01-2021 16:28:35 to 07-01-2021 16:28:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5689
TEST_TIME 2 5420
TEST_TIME 3 5659
TEST_TIME 4 5671
TEST_TIME 5 5011
TEST_TIME 6 4948
TEST_TIME 7 5164
TEST_TIME 8 5521
TEST_TIME 9 5738
TEST_TIME 10 6096
TEST_TIME 11 6260
TEST_TIME 12 7264
TEST_TIME 13 7237
TEST_TIME 14 7456
TEST_TIME 15 7743
TEST_TIME 16 8241
TEST_TIME 17 8651
TEST_TIME 18 9227
TEST_TIME 19 9347
TEST_TIME 20 9680
TEST_TIME 21 9795
TEST_TIME 22 9861
TEST_TIME 23 10106
TEST_TIME 24 10321
TEST_TIME 25 10597
TEST_TIME 26 10589
TEST_TIME 27 11518
TEST_TIME 28 11466
TEST_TIME 29 11540
TEST_TIME 30 11472
TEST_TIME 31 11237
TEST_TIME 32 11017
TEST_TIME 33 10888
TEST_TIME 34 10947
TEST_TIME 35 10849
TEST_TIME 36 10831
TEST_TIME 37 10597
TEST_TIME 38 10542
TEST_TIME 39 10483
TEST_TIME 40 10391
TEST_TIME 41 10393
TEST_TIME 42 10231
TEST_TIME 43 10408
TEST_TIME 44 10387
TEST_TIME 45 10337
TEST_TIME 46 10137
TEST_TIME 47 10216
TEST_TIME 48 10299
TEST_TIME 49 10198
TEST_TIME 50 10234
TEST_TIME 51 10211
TEST_TIME 52 10203
TEST_TIME 53 10348
TEST_TIME 54 10286
TEST_TIME 55 10312
TEST_TIME 56 10252
TEST_TIME 57 10333
TEST_TIME 58 10276
TEST_TIME 59 10394
TEST_TIME 60 10369
TEST_TIME 61 10393
TEST_TIME 62 10286
TEST_TIME 63 10294
TEST_TIME 64 10200
TEST_TIME 65 10156
TEST_TIME 66 10200
TEST_TIME 67 10119
TEST_TIME 68 10097
TEST_TIME 69 10039
TEST_TIME 70 9977
TEST_TIME 71 9940
TEST_TIME 72 9903
TEST_TIME 73 9871
TEST_TIME 74 9840
TEST_TIME 75 9739
TEST_TIME 76 9751
TEST_TIME 77 9708
TEST_TIME 78 9763
TEST_TIME 79 9734
TEST_TIME 80 9720
TEST_TIME 81 9755
TEST_TIME 82 9735
TEST_TIME 83 9805
TEST_TIME 84 9808
TEST_TIME 85 9818
TEST_TIME 86 9824
TEST_TIME 87 9841
TEST_TIME 88 9917
TEST_TIME 89 9914
TEST_TIME 90 9829
TEST_TIME 91 9824
TEST_TIME 92 9762
TEST_TIME 93 9774
TEST_TIME 94 9740
TEST_TIME 95 9678
TEST_TIME 96 9707
TEST_TIME 97 9674
TEST_TIME 98 9652
TEST_TIME 99 9643
TEST_TIME 100 9649
TEST_TIME 101 9675
TEST_TIME 102 9723
TEST_TIME 103 9742
TEST_TIME 104 9718
TEST_TIME 105 9759
TEST_TIME 106 9755
TEST_TIME 107 9794
TEST_TIME 108 9790
TEST_TIME 109 9801
TEST_TIME 110 9719
TEST_TIME 111 9702
TEST_TIME 112 9671
TEST_TIME 113 9679
TEST_TIME 114 9639
TEST_TIME 115 9585
TEST_TIME 116 9563
TEST_TIME 117 9558
TEST_TIME 118 9521
TEST_TIME 119 9564
TEST_TIME 120 9491

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-01-2021 16:28:38 to 07-01-2021 16:28:42.

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 1593995 1593995 0 0.00 0 27997 6 0 0
doc_list_biud 1593995 1593995 0 0.00 0 28044 25 0 0
sp_add_invoice_to_stock 5510 5411 99 1.79 41 134792 15856 0 99
sp_cancel_adding_invoice 5652 5652 0 0.00 4 69090 777 0 0
sp_cancel_client_order 1901 1901 0 0.00 4 17056 367 0 0
sp_cancel_customer_reserve 553570 553570 0 0.00 1 28048 57 0 0
sp_cancel_pay_from_customer 722 722 0 0.00 2 4375 82 0 0
sp_cancel_pay_to_supplier 460 460 0 0.00 3 3117 69 0 0
sp_cancel_supplier_invoice 6276 6259 17 0.27 1 15848 722 0 17
sp_cancel_supplier_order 404 404 0 0.00 5 1149296 97851 0 0
sp_cancel_write_off 9781 9781 0 0.00 1 26221 111 0 0
sp_client_order 21868 21868 0 0.00 3 101934 350 0 0
sp_customer_reserve 494660 494660 0 0.00 0 95306 158 0 0
sp_fill_shopping_cart 33469 33469 0 0.00 1 10603 37 0 0
sp_fill_shopping_cart_clo_res 494650 494650 0 0.00 0 12308 14 0 0
sp_get_clo_for_invoice 5397 5397 0 0.00 0 28748 308 0 0
sp_kill_cost_storno 16615 16615 0 0.00 0 6399 53 0 0
sp_kill_qstorno_ret_qs2qd 1123584 1123584 0 0.00 0 28041 31 0 0
sp_kill_qty_storno 593600 593600 0 0.00 0 28044 67 0 0
sp_lock_selected_doc 22168 22168 0 0.00 0 7772 5 0 0
sp_make_cost_storno 29840 29840 0 0.00 0 24319 47 0 0
sp_multiply_rows_for_pdistr 29840 29840 0 0.00 0 12237 30 0 0
sp_multiply_rows_for_qdistr 21868 21868 0 0.00 0 36738 176 0 0
sp_pay_from_customer 7568 7568 0 0.00 4 11694 109 0 0
sp_pay_to_supplier 6239 6239 0 0.00 5 25668 132 0 0
sp_payment_common 13807 13807 0 0.00 1 11926 33 0 0
sp_qd_handle_on_cancel_clo 1901 1901 0 0.00 0 17049 330 0 0
sp_qd_handle_on_invoice_upd_sts 11049 11049 0 0.00 0 22401 306 0 0
sp_qd_handle_on_reserve_upd_sts 10636 10636 0 0.00 0 25351 65 0 0
sp_reserve_write_off 10636 10636 0 0.00 6 25515 172 0 0
sp_supplier_invoice 5862 5862 0 0.00 5 103944 3158 0 0
sp_supplier_order 5746 5746 0 0.00 5 55694 1173 0 0
srv_aggregate_perf_data 98 97 1 1.02 2705 475801 24244 0 1
srv_fill_mon_cache_memory 165 165 0 0.00 1156 181997 33443 0 0
srv_find_qd_qs_mism 1086311 1086311 0 0.00 0 27996 5 0 0
srv_make_invnt_saldo 633 633 0 0.00 31 140419 1093 0 0
srv_make_money_saldo 837 837 0 0.00 1 4195 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 151303 321222 267206 0 0
t$perf-abend:sp_add_invoice_to_stock 99 99 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5411 5411 0 0.00 0 16047 169 0 0
t$perf-norm:sp_cancel_adding_invoice 443 443 0 0.00 0 7361 92 0 0
t$perf-norm:sp_cancel_client_order 1901 1901 0 0.00 0 1359 11 0 0
t$perf-norm:sp_cancel_customer_reserve 716 716 0 0.00 0 1059 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 722 722 0 0.00 0 3827 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 460 460 0 0.00 0 2172 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 421 421 0 0.00 0 6447 28 0 0
t$perf-norm:sp_cancel_supplier_order 404 404 0 0.00 0 28868 1737 0 0
t$perf-norm:sp_cancel_write_off 1069 1069 0 0.00 0 2294 7 0 0
t$perf-norm:sp_client_order 21868 21868 0 0.00 0 9758 17 0 0
t$perf-norm:sp_customer_reserve 1049 1049 0 0.00 0 4460 12 0 0
t$perf-norm:sp_pay_from_customer 7568 7568 0 0.00 0 8653 10 0 0
t$perf-norm:sp_pay_to_supplier 6239 6239 0 0.00 0 5627 13 0 0
t$perf-norm:sp_reserve_write_off 10636 10636 0 0.00 0 11285 11 0 0
t$perf-norm:sp_supplier_invoice 5862 5862 0 0.00 0 7273 17 0 0
t$perf-norm:sp_supplier_order 5746 5746 0 0.00 0 3238 16 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 5597 66 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 736 9 0 0
t$perf-norm:srv_make_invnt_saldo 633 633 0 0.00 0 5867 29 0 0
t$perf-norm:srv_make_money_saldo 837 837 0 0.00 0 6440 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10992 10794 198 1.80 0 4210 18 0 198
v_all_customers 40136 40136 0 0.00 0 12 1 0 0
v_all_suppliers 32232 32232 0 0.00 0 16 1 0 0
v_all_wares 43736 43736 0 0.00 0 33 1 0 0
v_cancel_adding_invoice 886 886 0 0.00 0 3391 9 0 0
v_cancel_client_order 3802 3802 0 0.00 0 4648 8 0 0
v_cancel_customer_prepayment 1444 1444 0 0.00 0 2258 7 0 0
v_cancel_customer_reserve 1432 1432 0 0.00 0 4701 12 0 0
v_cancel_payment_to_supplier 920 920 0 0.00 0 1633 7 0 0
v_cancel_supplier_invoice 876 842 34 3.88 0 3405 18 0 34
v_cancel_supplier_order 808 808 0 0.00 0 6234 25 0 0
v_cancel_write_off 2138 2138 0 0.00 0 4858 15 0 0
v_max_id_clo_ord 5746 5746 0 0.00 0 1380 1 0 0
v_max_id_clo_res 1049 1049 0 0.00 0 2047 13 0 0
v_max_id_ord_sup 5855 5855 0 0.00 0 4529 7 0 0
v_max_non_paid_invoice 1724 1724 0 0.00 0 472 2 0 0
v_max_non_paid_realizn 3976 3976 0 0.00 0 1728 3 0 0
v_min_id_clo_ord 5746 5746 0 0.00 0 3190 6 0 0
v_min_id_clo_res 1049 1049 0 0.00 0 4109 11 0 0
v_min_id_ord_sup 5855 5855 0 0.00 0 3836 4 0 0
v_min_non_paid_invoice 6239 6239 0 0.00 0 11923 27 0 0
v_min_non_paid_realizn 7568 7568 0 0.00 0 11006 18 0 0
v_our_firm 10784 10784 0 0.00 0 18 1 0 0
v_reserve_write_off 21270 21270 0 0.00 0 6230 5 0 0
x_lock_depdocs_on_canc_invoice 11490 11490 0 0.00 0 19674 100 0 0
x_lock_depdocs_on_canc_sup_ord 404 404 0 0.00 0 10278 357 0 0
x_make_qstorno_1000_1200 5746 5746 0 0.00 2 55676 1093 0 0
x_make_qstorno_1200_2000 5862 5862 0 0.00 2 103915 3027 0 0
x_make_qstorno_2100_3300 494660 494660 0 0.00 0 95304 142 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-01-2021 16:28:43 to 07-01-2021 16:28:47.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:15 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:21 9215 8192000000 10153480640 10448584704 819580912 9.094 65 55 111 1 839783024 2154848 18047264
13:57:39 32561 8192000000 10327054640 10640494592 1364937872 14.282 100 93 187 0 1400179376 4536368 30705136
13:58:19 21379 8192000000 10366962816 10684002304 1415988240 14.737 100 91 182 1 1452666048 6383024 30294784
13:58:53 21184 8192000000 10391102848 10716024832 1443592240 14.981 100 87 174 0 1480332432 7319232 29420960
13:59:26 15031 8192000000 10413683792 10742046720 1472594656 15.237 100 87 175 0 1509371088 7967648 28808784
13:59:57 20386 8192000000 10442797904 10772668416 1490451456 15.393 100 90 180 0 1528277856 8538352 29288048
14:00:25 21552 8192000000 10455635536 10788659200 1505430832 15.524 100 94 188 1 1545322960 9613024 30279104
14:01:06 16205 8192000000 10479957760 10820141056 1529347856 15.731 100 88 176 1 1567024640 9597984 28078800
14:01:40 9397 8192000000 10500077360 10846801920 1558694784 15.985 100 83 166 0 1594660080 10285648 25679648
14:02:00 11649 8192000000 10517557568 10869493760 1579179328 16.161 100 80 160 0 1614179296 10395744 24604224
14:02:21 12191 8192000000 10538543552 10892976128 1595001024 16.297 100 76 151 2 1629156464 11208000 22947440
14:02:42 11667 8192000000 10567547280 10921037824 1623108816 16.536 100 87 174 0 1660878208 11322416 26446976
14:03:03 11398 8192000000 10587134640 10946752512 1644260992 16.716 100 82 165 0 1680390256 12166272 23962992
14:03:21 8399 8192000000 10601346624 10963853312 1657854736 16.831 100 84 168 1 1695428944 13047856 24526352
14:03:37 8823 8192000000 10610647600 10977509376 1672420944 16.954 100 82 164 0 1709433968 13222128 23790896
14:03:54 12204 8192000000 10627084448 10996224000 1683578752 17.047 100 80 160 1 1719642544 12889104 23174688
14:04:15 6204 8192000000 10642949456 11011878912 1699265776 17.179 100 83 166 0 1736533136 13091392 24175968
14:04:30 6968 8192000000 10650775808 11026083840 1718404352 17.339 100 80 159 1 1754279264 13057136 22817776
14:04:45 6762 8192000000 10681737840 11052371968 1735928672 17.485 100 83 165 0 1771527376 12583232 23015472
14:04:59 6630 8192000000 10689452448 11066585088 1745172720 17.562 100 79 158 1 1784617008 17570080 21874208
14:05:13 4037 8192000000 10693933024 11072200704 1758142240 17.669 100 88 176 0 1796004320 13507760 24354320
14:05:23 4134 8192000000 10717395888 11093712896 1772349680 17.786 100 85 170 3 1810139376 13356560 24433136
14:05:34 4143 8192000000 10721653664 11100930048 1784012352 17.883 100 85 171 1 1820184496 12449136 23723008
14:05:45 3328 8192000000 10731649200 11112275968 1791392384 17.943 100 86 170 4 1828037344 12004912 24640048
14:05:56 2566 8192000000 10735534048 11116367872 1799905344 18.013 100 90 178 0 1837447536 13108144 24434048
14:06:05 2937 8192000000 10744681120 11125936128 1806156160 18.064 100 87 174 2 1844414464 13771488 24486816
14:06:15 7128 8192000000 10737783488 11125555200 1809955792 18.096 100 82 159 3 1843405840 11641376 21808672
14:06:29 5340 8192000000 10749375216 11140091904 1817453584 18.157 100 72 144 2 1848817664 11330464 20033616
14:06:41 3186 8192000000 10775084176 11164061696 1836864896 18.315 100 85 170 1 1873588576 12545760 24177920
14:06:51 2293 8192000000 10777188960 11167117312 1840772864 18.347 100 88 173 3 1878416720 12921088 24722768
14:06:59 2787 8192000000 10791702288 11176271872 1848412640 18.409 100 91 183 2 1887845936 12941184 26492112
14:07:09 2360 8192000000 10795202352 11181305856 1849716608 18.420 100 97 193 3 1890520736 13655008 27149120
14:07:17 1508 8192000000 10799052352 11182452736 1856346160 18.474 100 96 191 0 1897280720 14004112 26930448
14:07:25 2407 8192000000 10793263424 11179593728 1853820432 18.453 100 91 182 0 1893792352 13941408 26030512
14:07:34 1449 8192000000 10788782208 11182415872 1857524960 18.483 100 93 187 1 1897043040 12996240 26521840
14:07:42 1998 8192000000 10800900368 11189526528 1858510512 18.491 100 90 180 1 1895566064 11676064 25379488
14:07:50 1682 8192000000 10809279120 11195592704 1861696256 18.517 100 96 191 1 1902703776 14065392 26942128
14:07:58 1432 8192000000 10816636688 11205292032 1867914592 18.567 100 93 186 1 1907275200 12855952 26504656
14:08:06 1663 8192000000 10813364656 11201466368 1871298512 18.595 100 93 185 1 1911328016 14022992 26006512
14:08:14 1258 8192000000 10820540624 11207462912 1870609152 18.589 100 91 182 2 1909789584 13781200 25399232
14:08:21 29433 8192000000 10803978064 11205267456 1867065328 18.561 100 50 100 0 1895954272 14030448 14858496
14:08:57 2082 8192000000 10799737296 11210366976 1873102784 18.609 100 62 124 2 1901476528 11054256 17319488
14:09:06 2911 8192000000 10812052352 11213008896 1875170160 18.626 100 57 113 1 1902120672 10482208 16468304
14:09:15 4560 8192000000 10785671808 11205763072 1874728496 18.623 100 45 90 3 1896427408 9591024 12107888
14:09:26 6512 8192000000 10796197728 11212955648 1876894752 18.640 100 43 86 0 1897410544 8853184 11662608
14:09:39 9155 8192000000 10798489488 11214630912 1873748208 18.615 100 32 64 2 1890804480 8326208 8730064
14:09:56 12060 8192000000 10784927984 11209220096 1874864192 18.624 100 31 62 0 1889861184 6561424 8435568
14:10:19 7829 8192000000 10790466000 11218878464 1877894496 18.648 100 23 46 2 1899283824 15429360 5959968
14:10:35 5560 8192000000 10791061312 11216089088 1880172384 18.666 100 19 38 1 1892482928 6346624 5963920
14:10:49 8013 8192000000 10792145536 11222605824 1885826016 18.712 100 17 34 1 1897023264 6063168 5134080
14:11:03 11789 8192000000 10801939792 11223457792 1885675040 18.711 100 22 42 2 1898626416 5575344 7376032
14:11:21 54845 8192000000 10809710624 11231875072 1888783264 18.736 100 30 61 1 1902474432 5369264 8321904
14:12:23 22460 8192000000 10806933840 11241291776 1892950720 18.770 100 35 70 2 1910744048 7995568 9797760
14:12:53 4579 8192000000 10802849952 11234775040 1895002944 18.786 100 28 54 1 1908488640 5627824 7857872
14:13:04 7412 8192000000 10818888544 11244388352 1892829616 18.769 100 24 49 0 1906038976 6799056 6410304
14:13:18 6113 8192000000 10814493104 11247497216 1897065648 18.803 100 32 64 1 1921633152 15963280 8604224
14:13:30 6726 8192000000 10824105584 11249786880 1900959104 18.834 100 36 72 1 1918579680 7296960 10323616
14:13:45 4496 8192000000 10824567808 11258490880 1904551616 18.863 100 35 70 0 1927307104 13258016 9497472
14:13:57 6136 8192000000 10827856848 11255341056 1905457584 18.870 100 26 52 1 1919940336 7361776 7120976
14:14:09 6339 8192000000 10814756240 11252817920 1910081616 18.907 100 29 58 0 1924747840 6703376 7962848
14:14:23 7530 8192000000 10823009520 11254702080 1904881584 18.866 100 23 46 2 1918091024 6716352 6493088
14:14:38 8394 8192000000 10813028448 11249053696 1886966848 18.721 99 25 49 2 1899987760 6518912 6502000
14:14:52 6796 8192000000 10812074464 11247026176 1899802640 18.825 100 13 26 1 1909269104 5718576 3747888
14:15:09 7063 8192000000 10820578416 11253776384 1904522192 18.863 100 25 50 0 1918036832 5499760 8014880
14:15:24 13435 8192000000 10816145904 11250208768 1884124384 18.698 99 21 42 3 1895315088 5510688 5680016
14:15:45 9881 8192000000 10806004304 11245326336 1883994176 18.697 99 20 39 0 1894857120 5207392 5655552
14:16:05 63602 8192000000 10846748768 11250798592 1886009072 18.714 99 63 127 4 1909716224 4928656 18778496
14:17:15 6488 8192000000 10804579280 11224723456 1877827360 18.648 99 33 63 3 1893761632 7255600 8678672
14:17:28 5844 8192000000 10798838256 11236773888 1889317104 18.740 100 21 42 0 1902142608 6533664 6291840
14:17:41 7483 8192000000 10812949696 11240022016 1891256896 18.756 100 28 56 1 1905740016 6794448 7688672
14:17:55 6789 8192000000 10788860496 11217309696 1842893312 18.364 98 22 44 0 1859336704 10621584 5821808
14:18:08 9945 8192000000 10766024672 11178745856 1779188752 17.843 95 21 43 2 1793761392 9088768 5483872
14:18:25 5780 8192000000 10742106752 11155484672 1795052384 17.973 98 26 51 3 1808977008 5578016 8346608
14:18:41 9039 8192000000 10691171888 11100983296 1692994912 17.126 93 21 40 1 1703771008 4186128 6589968
14:18:57 7226 8192000000 10699573472 11113738240 1740049824 17.519 97 19 38 1 1751228240 5795456 5382960
14:19:12 4088 8192000000 10692442672 11099553792 1716830896 17.326 96 36 72 2 1732932496 5380000 10721600
14:19:25 14580 8192000000 10687544160 11104047104 1703590480 17.215 95 12 24 2 1713047120 5663936 3792704
14:19:49 10307 8192000000 10693144784 11104190464 1739571632 17.515 97 34 68 1 1755052912 5298976 10182304
14:20:05 8339 8192000000 10692188928 11110416384 1738794528 17.509 97 27 54 1 1752664464 5231600 8638336
14:20:23 47562 8192000000 10690821312 11094237184 1680929952 17.025 94 31 61 1 1695377552 5661072 8786528
14:21:18 30508 8192000000 10705535584 11123142656 1746112496 17.569 97 29 58 1 1760081776 5328384 8640896
14:21:59 5594 8192000000 10717117968 11132010496 1785620576 17.896 99 33 66 0 1802844208 7916320 9307312
14:22:11 3732 8192000000 10723240208 11137966080 1806027568 18.063 100 35 70 2 1823532736 7635888 9869280
14:22:21 4280 8192000000 10727818496 11141689344 1806301760 18.066 100 28 55 1 1821058080 7114864 7641456
14:22:32 6380 8192000000 10721013920 11142701056 1792127040 17.949 99 25 50 1 1805234192 5637344 7469808
14:22:49 4710 8192000000 10746366464 11159334912 1822525232 18.198 100 39 78 2 1840573856 6386496 11662128
14:23:03 6272 8192000000 10739647712 11162750976 1823974608 18.210 100 16 32 1 1834612016 6000560 4636848
14:23:18 7513 8192000000 10753841504 11170082816 1830013760 18.259 100 23 46 3 1842974320 6163232 6797328
14:23:34 6263 8192000000 10738574432 11174002688 1838479280 18.328 100 26 54 3 1852434800 6576080 7379440
14:23:48 5457 8192000000 10739606224 11167186944 1832639456 18.281 100 15 30 1 1842598528 5200176 4758896
14:24:00 7251 8192000000 10755939680 11183398912 1844925760 18.381 100 34 67 1 1860452016 5665472 9860784
14:24:14 11153 8192000000 10759975552 11189854208 1848269312 18.408 100 26 51 1 1861563760 5841392 7453056
14:24:33 7620 8192000000 10769884720 11193925632 1852353024 18.441 100 16 32 0 1862315840 5160144 4802672
14:24:50 10447 8192000000 10767735536 11201605632 1860853024 18.510 100 14 28 0 1870478640 5248880 4376736
14:25:09 13954 8192000000 10792982400 11207241728 1862969072 18.527 100 26 50 1 1876746912 5574448 8203392
14:25:31 71483 8192000000 10791034656 11224129536 1867469408 18.564 100 26 50 1 1879697232 5557360 6670464
14:26:51 7617 8192000000 10786702704 11218796544 1872563920 18.605 100 28 56 1 1887371568 7057472 7750176
14:27:06 1918 8192000000 10812208528 11230617600 1886878480 18.721 100 36 72 1 1902705872 5525280 10302112
14:27:16 25299 8192000000 10827210032 11246579712 1900602640 18.831 100 42 84 1 1918850768 5849344 12398784
14:27:51 20551 8192000000 10843943168 11261665280 1909455872 18.902 100 41 82 1 1927981696 6878704 11647120
14:28:44 5439 8192000000 10851523760 11278385152 1923982992 19.019 100 43 85 1 1946158640 10318512 11857136
14:28:58 16956 8192000000 10865501088 11290775552 1934236992 19.101 100 57 115 1 1961459456 11298208 15924256
14:29:23 15785 8192000000 10882595104 11298521088 1940603664 19.152 100 51 102 1 1968877296 13933360 14340272
14:29:46 4347 8192000000 10887256272 11304239104 1945202768 19.188 100 57 115 0 1975629632 14485440 15941424
14:30:02 14416 8192000000 10886648912 11315474432 1949963440 19.226 100 48 97 1 1978135584 14831856 13340288
14:30:26 38848 8192000000 10895785232 11326365696 1939041472 19.139 99 45 90 1 1966216240 14557536 12617232
14:31:13 25727 8192000000 10899554304 11333541888 1963943904 19.337 100 40 80 1 1991197424 15420304 11833216
14:31:47 8924 8192000000 10908847392 11342909440 1973740976 19.415 100 44 88 2 2001670320 14191808 13737536
14:32:05 20187 8192000000 10920527344 11352002560 1983440544 19.492 100 48 95 1 2013792368 16497472 13854352
14:32:36 11980 8192000000 10930816656 11355680768 1989338464 19.539 100 67 134 2 2027349088 18538208 19472416
14:33:12 47834 8192000000 10919114144 11365879808 1987163040 19.521 100 37 74 0 2017721296 19355584 11202672
14:34:07 34028 8192000000 10936003952 11375341568 1994567712 19.580 100 40 80 1 2028632128 21926608 12137808
14:34:48 15148 8192000000 10949538384 11383971840 1998035792 19.607 100 48 96 1 2033244704 20270736 14938176
14:35:13 25871 8192000000 10948981584 11385659392 1999094432 19.616 100 47 94 1 2036289952 22815696 14379824
14:35:54 10418 8192000000 10944010208 11383672832 2002401344 19.642 100 38 76 2 2035860080 21900272 11558464
14:36:12 2461 8192000000 10967336464 11388190720 2010926720 19.709 100 59 119 2 2049896832 20877280 18092832
14:36:23 3292 8192000000 10965844432 11391377408 2010735824 19.707 100 52 104 0 2048074352 21392224 15946304
14:36:38 4620 8192000000 10964774480 11400941568 2016159520 19.750 100 46 92 1 2050369440 20317264 13892656
14:36:49 2413 8192000000 10976559216 11401457664 2023518048 19.808 100 64 127 0 2063975696 21643648 18814000
14:36:59 3132 8192000000 10988781856 11406331904 2026540736 19.831 100 84 168 1 2076065792 24054432 25470624
14:37:11 7569 8192000000 10986118480 11415015424 2026919344 19.834 100 57 114 1 2068962704 24631472 17411888
14:37:26 1305 8192000000 10985454800 11397509120 2014228480 19.735 99 93 184 1 2067094608 25769072 27097056
14:37:34 2937 8192000000 10983659552 11408486400 2024731584 19.817 100 83 165 2 2076504160 26641248 25131328
14:37:44 2394 8192000000 10987283664 11411591168 2025230432 19.821 100 81 162 2 2076789312 26814112 24744768
14:37:53 3117 8192000000 10992380480 11411836928 2024017760 19.812 100 71 143 0 2072198608 27164576 21016272
14:38:03 6394 8192000000 10987934032 11416313856 2026105616 19.828 100 77 156 2 2081486880 31278848 24102416
14:38:23 7594 8192000000 10984471936 11412398080 2006044464 19.670 99 57 112 1 2056000320 31941728 18014128
14:38:38 7952 8192000000 10980571024 11411218432 2012962400 19.725 100 73 146 3 2069337584 33255440 23119744
14:38:53 7733 8192000000 10974945296 11406864384 2010144352 19.703 100 69 135 2 2065964720 34735984 21084384
14:39:08 3666 8192000000 10980923792 11414028288 2015781408 19.747 100 66 129 1 2070737776 33369776 21586592
14:39:20 5554 8192000000 10983326336 11412914176 2015721408 19.747 100 57 112 2 2065702752 32384384 17596960
14:39:33 8008 8192000000 10940350384 11376885760 1982055312 19.481 99 60 120 0 2033607456 32997088 18555056
14:39:49 3358 8192000000 10953057280 11380842496 1982943312 19.488 100 69 138 2 2035119920 31052464 21124144
14:40:01 4261 8192000000 10950173024 11378409472 1977344768 19.444 99 60 120 1 2024587600 28860336 18382496
14:40:12 4124 8192000000 10948020176 11373989888 1971304288 19.396 99 67 132 1 2022224192 30471408 20448496
14:40:24 10455 8192000000 10932417360 11361779712 1958943680 19.298 99 59 118 0 2007680896 30527408 18209808
14:40:48 7159 8192000000 10929808240 11362746368 1959522048 19.302 99 64 127 0 2010341888 31550096 19269744
14:41:05 4325 8192000000 10957685520 11384561664 1987652208 19.525 100 68 136 2 2042673008 34089376 20931424
14:41:18 11578 8192000000 10967359040 11395280896 1994810672 19.582 100 71 142 0 2053201952 35872848 22518432
14:41:36 3134 8192000000 10964749232 11380269056 1983574608 19.493 99 81 161 3 2043852384 35773984 24503792
14:41:47 1361 8192000000 10955908240 11374706688 1977852528 19.448 100 74 147 2 2037475376 37114960 22507888
14:41:56 2968 8192000000 10953801136 11366244352 1973760816 19.415 100 80 160 0 2036915056 38573360 24580880
14:42:06 1154 8192000000 10907221744 11319250944 1914928608 18.946 98 84 165 1 1980676816 39063008 26685200
14:42:14 3884 8192000000 10922094656 11342036992 1950656240 19.232 100 72 142 1 2013373984 39758944 22958800
14:42:25 1693 8192000000 10927723312 11339075584 1942723248 19.168 100 90 181 1 2011615808 40556240 28336320
14:42:34 3477 8192000000 10921807152 11326910464 1931419872 19.078 99 83 165 3 1999297840 42386080 25491888
14:42:45 11662 8192000000 10920497136 11344347136 1946939776 19.202 100 63 126 0 2007335536 40458336 19937424
14:43:14 1473 8192000000 10947464096 11360530432 1950087648 19.227 99 86 173 2 2014041424 36779440 27174336
14:43:23 2267 8192000000 10952069168 11367772160 1966851968 19.360 100 87 170 2 2033209200 39817872 26539360
14:43:32 4954 8192000000 10945159648 11361595392 1967737088 19.367 100 74 149 2 2026122768 35328352 23057328
14:43:47 3729 8192000000 10938836976 11358715904 1950784896 19.233 99 78 157 1 2013195904 37266992 25144016
14:43:58 2328 8192000000 10958040304 11365019648 1968216800 19.371 100 89 175 1 2035331344 38919648 28194896
14:44:12 4304 8192000000 10950243872 11372023808 1975430208 19.429 100 79 158 1 2040010112 39621952 24957952
14:44:22 3606 8192000000 10966803136 11378634752 1976478560 19.437 100 91 183 0 2044617120 39811488 28327072
14:44:33 11390 8192000000 10932409024 11356405760 1946493760 19.199 99 67 133 3 2007108480 39547216 21067504
14:44:52 6523 8192000000 10936673824 11349798912 1945685216 19.192 99 84 168 0 2006108592 34834992 25588384
14:45:05 1850 8192000000 10940377232 11347791872 1951066560 19.235 100 88 176 1 2013511248 35956976 26487712
14:45:16 2896 8192000000 10947730256 11362926592 1958752528 19.296 100 86 172 0 2024716112 39605680 26357904
14:45:26 4567 8192000000 10940687664 11352981504 1964337280 19.341 100 83 165 0 2024591472 35389488 24864704
14:45:39 3718 8192000000 10931659792 11353018368 1956905040 19.281 100 73 146 0 2019591552 40138832 22547680
14:45:54 14158 8192000000 10909730544 11352932352 1932920976 19.090 99 40 79 2 1987415888 41806688 12688224
14:46:17 6659 8192000000 10904871840 11340566528 1932068256 19.083 99 43 82 1 1979714176 34656288 12989632
14:46:30 5173 8192000000 10921682016 11345412096 1944442800 19.182 100 63 126 2 2001153984 36780528 19930656
14:46:42 6598 8192000000 10931038016 11359805440 1949570336 19.223 100 49 99 4 2005020560 40395536 15054688
14:47:01 25362 8192000000 10891962208 11329503232 1882603376 18.686 97 31 62 1 1933335792 39957584 10774832
14:47:38 9759 8192000000 10907588288 11337400320 1931530832 19.079 100 42 84 1 1986730352 41694896 13504624
14:47:55 12413 8192000000 10883811648 11319586816 1899234000 18.820 98 40 80 0 1950586592 38286528 13066064
14:48:14 3852 8192000000 10890679216 11314016256 1920822416 18.993 100 52 104 2 1971171936 35002928 15346592
14:48:27 12836 8192000000 10882393920 11322429440 1919686512 18.984 100 30 61 0 1966306640 36567312 10052816
14:48:47 7519 8192000000 10880512064 11321118720 1918158608 18.972 100 34 68 1 1967748096 38690592 10898896
14:49:07 11110 8192000000 10879007232 11323039744 1921474752 18.999 100 32 64 3 1970201296 38286528 10440016
14:49:24 9897 8192000000 10886482224 11323834368 1905582496 18.871 99 27 54 0 1955319936 40754944 8982496
14:50:00 12256 8192000000 10899778000 11344879616 1930804384 19.073 100 37 74 2 1984527344 41054896 12668064
14:50:21 10800 8192000000 10912527888 11350593536 1943629984 19.176 100 52 104 2 2001424448 41379120 16415344
14:50:42 21196 8192000000 10887670496 11334012928 1930649744 19.072 100 21 42 0 1974401632 36811136 6940752
14:51:11 22127 8192000000 10868437136 11310432256 1907675664 18.888 99 26 52 4 1957412240 40746448 8990128
14:52:16 43275 8192000000 10879921264 11345780736 1905126624 18.868 99 16 32 0 1950757648 40016192 5614832
14:53:06 17502 8192000000 10845764304 11282853888 1784328960 17.885 93 25 50 2 1830544176 38082576 8132640
14:53:35 41090 8192000000 10821512192 11275223040 1852944208 18.446 99 14 28 0 1894994464 37097904 4952352
14:54:22 39117 8192000000 10815962912 11251666944 1824918064 18.218 97 18 37 0 1842329744 12823696 4587984
14:55:08 36359 8192000000 10821310560 11268927488 1880736000 18.671 100 15 29 2 1895867776 10643472 4488304
14:55:51 17113 8192000000 10817101920 11276517376 1884396688 18.701 100 9 18 1 1902372448 15231600 2744160
14:56:16 19390 8192000000 10830337904 11290476544 1892578512 18.767 100 15 29 0 1911613568 14705744 4329312
14:56:42 72757 8192000000 10839839584 11300032512 1870848960 18.591 99 10 21 1 1890562464 17015200 2698304
14:58:05 41895 8192000000 10878591392 11315351552 1911669616 18.920 99 33 64 3 1928506320 8151920 8684784
14:59:26 181997 8192000000 10869329376 11326185472 1886244208 18.716 97 30 58 1 1908600656 13953568 8402880
15:02:34 46796 8192000000 10890135744 11345580032 1953803648 19.257 100 20 40 2 1968084928 8908160 5373120
15:03:30 87324 8192000000 10891831488 11340460032 1943681840 19.176 99 34 68 1 1960925840 7461456 9782544
15:05:16 42184 8192000000 10900553984 11362861056 1971048768 19.394 100 32 64 2 1990627680 10425392 9153520
15:06:21 27252 8192000000 10945392240 11385229312 1983284992 19.491 100 27 52 1 2006862336 16463952 7113392
15:06:57 22338 8192000000 10955644032 11395305472 1995708080 19.589 100 41 82 1 2022641088 14291200 12641808
15:07:27 69372 8192000000 10945414128 11411124224 2004247184 19.656 100 38 76 1 2034048304 18509120 11292000
15:08:44 28733 8192000000 10934558048 11401314304 1982905968 19.488 99 18 36 2 2009005648 20888384 5211296
15:09:20 61170 8192000000 10932731504 11404357632 1996361152 19.594 100 17 34 2 2025581824 23959136 5261536
15:10:32 51581 8192000000 10921598544 11410112512 1989172416 19.537 100 9 18 0 2014599968 22283216 3144336
15:11:30 5733 8192000000 10922321936 11411742720 1988715472 19.534 100 7 14 0 2014465584 23260096 2490016
15:11:46 20412 8192000000 10920158768 11394428928 1990913600 19.551 100 12 24 1 2009755936 15352608 3489728
15:12:14 107087 8192000000 10924381392 11388346368 1954169552 19.260 98 21 42 0 1975209920 14696592 6343776
15:14:08 47744 8192000000 10926020448 11404767232 1992023440 19.560 100 18 36 0 2011074592 14267248 4783904
15:15:02 59749 8192000000 10903874112 11381440512 1974046096 19.418 99 9 18 1 1989548656 13146752 2355808
15:16:08 27569 8192000000 10925070448 11375419392 1968636048 19.375 99 35 70 0 1984293312 6394112 9263152
15:16:48 6125 8192000000 10920740976 11367133184 1970180992 19.387 99 66 132 1 1998428528 8475904 19771632
15:17:04 63669 8192000000 10899676048 11376951296 1957902496 19.289 99 17 34 1 1970609104 7808144 4898464
15:18:14 77183 8192000000 10907929248 11372470272 1927495168 19.047 97 14 28 0 1944567552 13090752 3981632
15:19:39 75354 8192000000 10885418032 11354144768 1896277232 18.796 96 14 28 0 1915078400 14773264 4027904
15:21:04 69411 8192000000 10885225984 11348094976 1882809472 18.688 96 12 24 0 1900646256 14726064 3110720
15:22:20 56692 8192000000 10884329776 11341332480 1884728048 18.703 96 31 62 1 1909177936 15108800 9341088
15:23:28 94296 8192000000 10874909248 11350568960 1904432128 18.862 97 17 34 1 1919658544 10617232 4609184
15:25:10 75098 8192000000 10890801456 11362983936 1942460960 19.166 99 21 42 1 1962047760 13710848 5875952
15:26:35 72830 8192000000 10906209744 11373948928 1927458672 19.047 98 10 20 0 1946816560 16961920 2395968
15:27:55 115648 8192000000 10881267600 11346857984 1916213504 18.956 97 24 47 0 1941061600 18329216 6518880
15:30:06 59720 8192000000 10825000272 11282178048 1871727840 18.598 96 22 43 1 1884773808 7827792 5218176
15:31:14 42604 8192000000 10829756048 11285598208 1879677088 18.662 98 24 49 1 1892002736 5944320 6381328
15:32:04 24435 8192000000 10834556176 11277766656 1877722032 18.647 98 31 62 1 1894374800 8186112 8466656
15:32:39 65708 8192000000 10810545376 11292364800 1854681232 18.460 97 17 34 1 1869464768 10219360 4564176
15:33:51 83798 8192000000 10854519168 11331096576 1889340448 18.740 98 13 27 0 1909425824 16773792 3311584
15:35:24 57216 8192000000 10845639744 11321528320 1876520608 18.637 97 13 26 0 1899300416 19127952 3651856
15:36:27 58973 8192000000 10832013760 11311177728 1887923968 18.729 98 9 18 0 1905237248 14837648 2475632
15:37:32 49258 8192000000 10840169728 11307675648 1886333296 18.716 98 21 40 1 1905947904 13903680 5710928
15:38:40 73584 8192000000 10817732064 11287736320 1826826960 18.233 95 10 20 1 1836814528 7225408 2762160
15:40:00 23922 8192000000 10836383008 11287183360 1904112096 18.859 100 36 72 1 1923063984 7630416 11321472
15:40:34 50500 8192000000 10796992192 11273957376 1865480432 18.548 98 24 48 0 1881724432 9403376 6840624
15:41:32 75740 8192000000 10804445296 11275673600 1865935776 18.551 98 9 18 1 1875691840 7083136 2672928
15:42:57 116321 8192000000 10816400032 11287482368 1772208368 17.785 93 11 22 0 1782195328 6995040 2991920
15:45:00 68358 8192000000 10835077488 11307405312 1888859808 18.737 99 22 44 0 1909404352 14208432 6336112
15:46:25 66664 8192000000 10831078720 11299971072 1861179408 18.513 97 21 42 0 1879243088 11833600 6230080
15:47:39 30859 8192000000 10860362448 11305607168 1898601312 18.815 99 18 34 1 1911615440 8064096 4950032
15:48:21 35262 8192000000 10851607856 11314716672 1912179968 18.924 99 35 70 0 1933512384 10741344 10591072
15:49:11 92944 8192000000 10873934400 11337232384 1901874352 18.841 98 17 34 1 1919860384 13458496 4527536
15:50:52 99032 8192000000 10885960288 11345317888 1924152256 19.020 99 13 26 0 1941843344 14302592 3388496
15:52:45 14088 8192000000 10884549744 11332218880 1929250976 19.061 99 43 86 0 1952635376 10891616 12492784
15:53:07 18198 8192000000 10891581024 11338842112 1948253248 19.213 100 34 67 2 1967683216 10219872 9210096
15:53:33 16460 8192000000 10898478224 11344379904 1953736432 19.256 100 49 98 0 1978635456 11281072 13617952
15:53:57 84050 8192000000 10894538976 11364503552 1956185168 19.276 100 18 36 0 1976510752 15592160 4733424
15:55:27 74075 8192000000 10877788880 11351515136 1904223824 18.860 97 13 26 0 1924127456 16377584 3526048
15:56:47 120423 8192000000 10873739424 11350061056 1950238080 19.228 100 15 30 1 1968473008 13784928 4450000
15:58:59 44294 8192000000 10903354496 11351818240 1948991120 19.218 99 37 74 5 1966739872 7701712 10047040
15:59:53 24027 8192000000 10897760912 11353731072 1954964928 19.266 99 42 84 1 1977553808 11385472 11203408
16:00:33 68589 8192000000 10884517632 11365953536 1969267904 19.380 100 12 24 0 1984055616 11573008 3214704
16:01:58 34800 8192000000 10879178832 11357319168 1928684192 19.056 98 7 14 0 1940881232 10141216 2055824
16:02:39 35664 8192000000 10891078832 11361701888 1962015616 19.322 100 10 20 1 1976853616 11705248 3132752
16:03:23 43650 8192000000 10879626288 11366244352 1949068256 19.219 99 4 8 0 1960836384 10790560 977568
16:04:15 32944 8192000000 10885405744 11352350720 1931147472 19.076 98 20 39 0 1944702736 8091504 5463760
16:04:54 53248 8192000000 10902974400 11371941888 1956227456 19.276 99 21 43 0 1970440656 8533888 5679312
16:06:10 69152 8192000000 10914698144 11380944896 1962744560 19.328 99 25 50 0 1985325392 15605552 6975280
16:07:41 45174 8192000000 10889998016 11357638656 1898062768 18.811 96 14 28 1 1912447264 10357072 4027424
16:08:32 92840 8192000000 10885740976 11371528192 1952509792 19.246 99 15 31 0 1969070704 12331280 4229632
16:10:14 48247 8192000000 10863973808 11320745984 1905366896 18.869 97 11 22 0 1916887808 8426464 3094448
16:11:11 24023 8192000000 10891342256 11334836224 1887326528 18.724 96 46 92 1 1907554464 7764400 12463536
16:11:42 70349 8192000000 10875304480 11353182208 1909508768 18.903 98 15 30 0 1924272272 10651168 4112336
16:13:12 138486 8192000000 10886189248 11368603648 1839710688 18.338 94 22 44 0 1866749024 20772928 6265408
16:15:36 52254 8192000000 10872762480 11346726912 1901643504 18.840 97 13 27 1 1917329744 12188864 3497376
16:17:35 119159 8192000000 10866245296 11338375168 1843087360 18.366 94 19 39 0 1860363824 12127328 5149136
16:19:49 11983 8192000000 10841212304 11310379008 1915021056 18.947 99 17 34 0 1934754848 14747504 4986288
16:20:08 5762 8192000000 10842940272 11326242816 1928743376 19.057 100 7 14 0 1942120832 11177936 2199520
16:20:36 46828 8192000000 10853064176 11332870144 1928601808 19.056 100 11 22 1 1937771088 6483616 2685664
16:21:34 56732 8192000000 10853952240 11335946240 1925366640 19.030 99 7 14 0 1936738192 9498944 1872608
16:22:37 9880 8192000000 10856888608 11336134656 1943395056 19.174 100 8 16 0 1955898112 10245008 2258048
16:22:58 38743 8192000000 10830542176 11304361984 1859545136 18.500 96 15 30 1 1873548320 10180640 3822544
16:23:47 64815 8192000000 10830484304 11305668608 1898616720 18.815 99 24 48 0 1917392384 11770288 7005376
16:25:00 72013 8192000000 10841777488 11324043264 1887536736 18.726 98 7 14 0 1902712432 12747760 2427936
16:26:21 41842 8192000000 10841519184 11314339840 1904485072 18.862 99 12 24 0 1917269904 9428480 3356352
16:27:10 6626 8192000000 8923604160 9083162624 101695792 1.226 6 2 4 0 104564768 2717136 151840

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 07-01-2021 16:28:49 to 07-01-2021 16:29:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 99 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-01-2021 16:29:21 to 07-01-2021 16:29:23.

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          248190
MON$OLDEST_ACTIVE               248191
MON$OLDEST_SNAPSHOT             248191
MON$NEXT_TRANSACTION            248191
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                       2031776
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

07.01.21 16:29:24. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-01-07 16:29:27 No severe PSQL-related problems occured
07.01.21 16:29:28. End of report.