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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17347140 kB
MemAvailable 31359856 kB
Buffers 0 kB
Cached 14315972 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-08 01:27:12
DTS_END                         2021-01-08 01:27:12.6010
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/35818
TRN_ID                          244380
ATT_ID                          673
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: 9210.35 23804 1105242
customer order: creation 180.93 369 21711
customer order: refuse 15.99 362 1919
order to supplier: creation 48.59 1294 5831
order to supplier: removal 3.51 93585 421
invoice (draft): creation 48.38 3257 5806
invoice (draft): removal 51.31 772 6157
invoice accept: apply 43.40 18446 5208
invoice accept: cancel 46.14 740 5537
customer reserve: creation 3983.01 184 477961
customer reserve: removal 4486.72 57 538406
realization accept: apply 86.89 159 10427
realization accept: cancel 82.27 110 9872
payment from customer: creation 60.69 89 7283
payment from customer: removal 5.26 69 631
payment to supplier: creation 51.25 116 6150
payment to supplier: removal 3.78 82 454
service: total inventory turnovers 5.23 852 627
service: total monetary turnovers 6.33 37 760
service: aggregate perf. data 0.64 28335 77
service: refresh index statistics 0.03 327161 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-01-2021 01:28:14 to 08-01-2021 01:28:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3750
TEST_TIME 2 4267
TEST_TIME 3 5221
TEST_TIME 4 5195
TEST_TIME 5 4874
TEST_TIME 6 5046
TEST_TIME 7 5715
TEST_TIME 8 5711
TEST_TIME 9 5643
TEST_TIME 10 5990
TEST_TIME 11 6283
TEST_TIME 12 6441
TEST_TIME 13 7184
TEST_TIME 14 7288
TEST_TIME 15 7549
TEST_TIME 16 7917
TEST_TIME 17 8102
TEST_TIME 18 8264
TEST_TIME 19 8217
TEST_TIME 20 8251
TEST_TIME 21 9042
TEST_TIME 22 9226
TEST_TIME 23 9106
TEST_TIME 24 9118
TEST_TIME 25 9589
TEST_TIME 26 10496
TEST_TIME 27 10925
TEST_TIME 28 10804
TEST_TIME 29 10725
TEST_TIME 30 10587
TEST_TIME 31 10468
TEST_TIME 32 10247
TEST_TIME 33 10205
TEST_TIME 34 10135
TEST_TIME 35 10023
TEST_TIME 36 9930
TEST_TIME 37 9918
TEST_TIME 38 9927
TEST_TIME 39 9984
TEST_TIME 40 9985
TEST_TIME 41 9902
TEST_TIME 42 9753
TEST_TIME 43 9669
TEST_TIME 44 9588
TEST_TIME 45 9600
TEST_TIME 46 9530
TEST_TIME 47 9583
TEST_TIME 48 9529
TEST_TIME 49 9518
TEST_TIME 50 9590
TEST_TIME 51 9590
TEST_TIME 52 9582
TEST_TIME 53 9683
TEST_TIME 54 9654
TEST_TIME 55 9711
TEST_TIME 56 9679
TEST_TIME 57 9734
TEST_TIME 58 9766
TEST_TIME 59 9809
TEST_TIME 60 9797
TEST_TIME 61 9659
TEST_TIME 62 9651
TEST_TIME 63 9571
TEST_TIME 64 9578
TEST_TIME 65 9502
TEST_TIME 66 9445
TEST_TIME 67 9474
TEST_TIME 68 9470
TEST_TIME 69 9422
TEST_TIME 70 9384
TEST_TIME 71 9442
TEST_TIME 72 9389
TEST_TIME 73 9399
TEST_TIME 74 9447
TEST_TIME 75 9545
TEST_TIME 76 9510
TEST_TIME 77 9605
TEST_TIME 78 9635
TEST_TIME 79 9565
TEST_TIME 80 9486
TEST_TIME 81 9405
TEST_TIME 82 9465
TEST_TIME 83 9456
TEST_TIME 84 9445
TEST_TIME 85 9400
TEST_TIME 86 9387
TEST_TIME 87 9361
TEST_TIME 88 9277
TEST_TIME 89 9318
TEST_TIME 90 9303
TEST_TIME 91 9311
TEST_TIME 92 9264
TEST_TIME 93 9282
TEST_TIME 94 9386
TEST_TIME 95 9388
TEST_TIME 96 9447
TEST_TIME 97 9457
TEST_TIME 98 9425
TEST_TIME 99 9419
TEST_TIME 100 9442
TEST_TIME 101 9464
TEST_TIME 102 9539
TEST_TIME 103 9513
TEST_TIME 104 9440
TEST_TIME 105 9361
TEST_TIME 106 9359
TEST_TIME 107 9401
TEST_TIME 108 9345
TEST_TIME 109 9300
TEST_TIME 110 9284
TEST_TIME 111 9306
TEST_TIME 112 9266
TEST_TIME 113 9248
TEST_TIME 114 9263
TEST_TIME 115 9266
TEST_TIME 116 9258
TEST_TIME 117 9252
TEST_TIME 118 9257
TEST_TIME 119 9277
TEST_TIME 120 9216

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-01-2021 01:28:18 to 08-01-2021 01:28:21.

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 1546276 1546276 0 0.00 0 22049 6 0 0
doc_list_biud 1546273 1546273 0 0.00 0 78877 25 0 0
sp_add_invoice_to_stock 5309 5208 101 1.90 26 196712 18447 0 101
sp_cancel_adding_invoice 5537 5537 0 0.00 6 60702 741 0 0
sp_cancel_client_order 1919 1919 0 0.00 4 10579 362 0 0
sp_cancel_customer_reserve 538406 538406 0 0.00 1 56084 57 0 0
sp_cancel_pay_from_customer 631 631 0 0.00 3 4348 69 0 0
sp_cancel_pay_to_supplier 454 454 0 0.00 3 1896 83 0 0
sp_cancel_supplier_invoice 6165 6157 8 0.12 1 78881 773 0 8
sp_cancel_supplier_order 421 421 0 0.00 14 919914 93585 0 0
sp_cancel_write_off 9872 9872 0 0.00 1 10040 110 0 0
sp_client_order 21711 21711 0 0.00 3 11256 370 0 0
sp_customer_reserve 477961 477961 0 0.00 0 90469 185 0 0
sp_fill_shopping_cart 33342 33342 0 0.00 1 10671 38 0 0
sp_fill_shopping_cart_clo_res 477951 477951 0 0.00 0 18002 14 0 0
sp_get_clo_for_invoice 5197 5197 0 0.00 0 38921 296 0 0
sp_kill_cost_storno 16494 16494 0 0.00 0 5675 56 0 0
sp_kill_qstorno_ret_qs2qd 1093262 1093262 0 0.00 0 78876 31 0 0
sp_kill_qty_storno 577936 577936 0 0.00 0 78877 67 0 0
sp_lock_selected_doc 21620 21620 0 0.00 0 9046 7 0 0
sp_make_cost_storno 29057 29057 0 0.00 0 19098 48 0 0
sp_multiply_rows_for_pdistr 29057 29057 0 0.00 0 5910 29 0 0
sp_multiply_rows_for_qdistr 21711 21711 0 0.00 0 11223 174 0 0
sp_pay_from_customer 7283 7283 0 0.00 4 5967 90 0 0
sp_pay_to_supplier 6150 6150 0 0.00 5 7295 117 0 0
sp_payment_common 13431 13431 0 0.00 1 5431 25 0 0
sp_qd_handle_on_cancel_clo 1919 1919 0 0.00 0 10572 335 0 0
sp_qd_handle_on_invoice_upd_sts 10734 10734 0 0.00 0 15624 300 0 0
sp_qd_handle_on_reserve_upd_sts 10427 10427 0 0.00 0 10472 52 0 0
sp_reserve_write_off 10427 10427 0 0.00 7 10662 159 0 0
sp_supplier_invoice 5806 5806 0 0.00 7 78730 3257 0 0
sp_supplier_order 5831 5831 0 0.00 5 21089 1295 0 0
srv_aggregate_perf_data 77 77 0 0.00 2935 730091 28335 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 735 127316 31809 0 0
srv_find_qd_qs_mism 1054850 1054850 0 0.00 0 22049 6 0 0
srv_make_invnt_saldo 627 627 0 0.00 30 54290 853 0 0
srv_make_money_saldo 760 760 0 0.00 1 3491 38 0 0
srv_recalc_idx_stat 4 4 0 0.00 136257 455005 327161 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5209 5209 0 0.00 0 8358 152 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 1 11863 144 0 0
t$perf-norm:sp_cancel_client_order 1919 1919 0 0.00 0 12043 23 0 0
t$perf-norm:sp_cancel_customer_reserve 721 721 0 0.00 0 1964 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 631 631 0 0.00 0 4705 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 454 454 0 0.00 0 2251 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 3047 22 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 20485 1505 0 0
t$perf-norm:sp_cancel_write_off 1017 1017 0 0.00 0 2755 7 0 0
t$perf-norm:sp_client_order 21711 21711 0 0.00 0 10928 19 0 0
t$perf-norm:sp_customer_reserve 1032 1032 0 0.00 0 2578 8 0 0
t$perf-norm:sp_pay_from_customer 7283 7283 0 0.00 0 11043 15 0 0
t$perf-norm:sp_pay_to_supplier 6150 6150 0 0.00 0 7868 10 0 0
t$perf-norm:sp_reserve_write_off 10427 10427 0 0.00 0 12237 9 0 0
t$perf-norm:sp_supplier_invoice 5806 5806 0 0.00 0 12654 18 0 0
t$perf-norm:sp_supplier_order 5831 5831 0 0.00 0 5121 15 0 0
t$perf-norm:srv_aggregate_perf_data 77 77 0 0.00 0 882 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 334 5 0 0
t$perf-norm:srv_make_invnt_saldo 627 627 0 0.00 0 1190 22 0 0
t$perf-norm:srv_make_money_saldo 760 760 0 0.00 0 878 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10596 10394 202 1.90 0 4726 16 0 202
v_all_customers 39782 39782 0 0.00 0 48 1 0 0
v_all_suppliers 31826 31826 0 0.00 0 68 1 0 0
v_all_wares 43418 43418 0 0.00 0 70 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 2195 9 0 0
v_cancel_client_order 3838 3838 0 0.00 0 3495 6 0 0
v_cancel_customer_prepayment 1262 1262 0 0.00 0 2100 6 0 0
v_cancel_customer_reserve 1442 1442 0 0.00 0 2968 6 0 0
v_cancel_payment_to_supplier 908 908 0 0.00 0 1605 5 0 0
v_cancel_supplier_invoice 842 826 16 1.90 0 495 12 0 16
v_cancel_supplier_order 842 842 0 0.00 0 1208 5 0 0
v_cancel_write_off 2034 2034 0 0.00 0 2697 13 0 0
v_max_id_clo_ord 5829 5829 0 0.00 0 204 1 0 0
v_max_id_clo_res 1032 1032 0 0.00 0 3961 19 0 0
v_max_id_ord_sup 5801 5801 0 0.00 0 5453 4 0 0
v_max_non_paid_invoice 1866 1866 0 0.00 0 2207 4 0 0
v_max_non_paid_realizn 3760 3760 0 0.00 0 1971 3 0 0
v_min_id_clo_ord 5829 5829 0 0.00 0 3527 5 0 0
v_min_id_clo_res 1032 1032 0 0.00 0 8994 34 0 0
v_min_id_ord_sup 5801 5801 0 0.00 0 7047 10 0 0
v_min_non_paid_invoice 6149 6149 0 0.00 0 5393 18 0 0
v_min_non_paid_realizn 7282 7282 0 0.00 0 3872 14 0 0
v_our_firm 10680 10680 0 0.00 0 13 1 0 0
v_reserve_write_off 20854 20854 0 0.00 0 2432 4 0 0
x_lock_depdocs_on_canc_invoice 11281 11281 0 0.00 0 19290 113 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 13408 330 0 0
x_make_qstorno_1000_1200 5831 5831 0 0.00 1 21071 1220 0 0
x_make_qstorno_1200_2000 5806 5806 0 0.00 2 78714 3117 0 0
x_make_qstorno_2100_3300 477961 477961 0 0.00 0 90468 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-01-2021 01:28:22 to 08-01-2021 01:28:26.

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
22:57:16 10 8192000000 8800795728 8812068864 6918096 0.084 2 1 2 0 7037472 56816 62560
22:57:23 16267 8192000000 10265055040 10574774272 931463104 10.209 73 50 100 0 950395936 2474992 16457840
22:57:46 27696 8192000000 10335151568 10654232576 1386275728 14.473 100 85 170 0 1419054336 4724224 28054384
22:58:26 20684 8192000000 10374331152 10699333632 1422459680 14.795 100 87 173 0 1456955728 6290320 28205728
22:59:00 23054 8192000000 10424093120 10751021056 1470323024 15.217 100 87 175 0 1506131648 7589760 28218864
22:59:31 25712 8192000000 10434225888 10770288640 1491446896 15.402 100 96 193 0 1531493728 8529472 31517360
23:00:05 33801 8192000000 10467464960 10804207616 1508631584 15.551 100 83 166 1 1544389888 8990656 26767648
23:00:51 13913 8192000000 10481123696 10821529600 1536403680 15.792 100 89 178 2 1574783712 9896160 28483872
23:01:18 11376 8192000000 10491575808 10836852736 1543885552 15.857 100 89 178 0 1582520000 10526416 28108032
23:01:38 19535 8192000000 10504959776 10857320448 1563015504 16.022 100 86 172 1 1600519888 10744384 26760000
23:02:13 16440 8192000000 10542073344 10897342464 1594624032 16.293 100 80 158 1 1629258864 10663296 23971536
23:02:39 11385 8192000000 10562893024 10921353216 1616906240 16.484 100 72 144 0 1650111072 11266464 21938368
23:03:00 9399 8192000000 10581697728 10944233472 1637016304 16.654 100 80 160 2 1674079104 12096784 24966016
23:03:22 9167 8192000000 10600673056 10962767872 1655900272 16.814 100 79 158 0 1691265472 11984768 23380432
23:03:41 11795 8192000000 10608751920 10974793728 1669405440 16.928 100 78 156 0 1705305568 12710192 23189936
23:04:03 9485 8192000000 10634483680 11002089472 1688120832 17.086 100 80 159 2 1723650048 12280448 23248768
23:04:21 10586 8192000000 10628638112 11005394944 1698450656 17.172 100 72 144 2 1731473648 12159696 20863296
23:04:39 8811 8192000000 10660322912 11036585984 1717669408 17.333 100 79 158 2 1752332256 11994880 22667968
23:04:55 7223 8192000000 10670499680 11048677376 1730305968 17.438 100 74 146 1 1763423808 11772512 21345328
23:05:12 4948 8192000000 10679373648 11053297664 1744267600 17.554 100 80 158 4 1778651136 12084208 22299328
23:05:23 4953 8192000000 10688501024 11066085376 1749823488 17.600 100 78 154 3 1783758352 12112608 21822256
23:05:35 6081 8192000000 10700296736 11078955008 1760487392 17.688 100 86 172 0 1798229632 13575136 24167104
23:05:48 3585 8192000000 10702215488 11085692928 1768432544 17.754 100 82 158 3 1803080880 12850848 21797488
23:05:58 3132 8192000000 10713537648 11094663168 1777548448 17.829 100 85 168 2 1814628656 13490288 23589920
23:06:09 3622 8192000000 10721241152 11102773248 1780390192 17.853 100 76 148 1 1813878368 12530928 20957248
23:06:19 4693 8192000000 10722968832 11110952960 1792126816 17.949 100 73 146 1 1824254832 11635760 20492256
23:06:31 4803 8192000000 10743027280 11127488512 1802021696 18.030 100 85 167 1 1837702256 11589552 24091008
23:06:42 3944 8192000000 10738019936 11123064832 1806603088 18.068 100 82 163 1 1840770864 11176016 22991760
23:06:53 4674 8192000000 10732511968 11124400128 1805287056 18.057 100 69 134 0 1833894368 10415056 18192256
23:07:04 4118 8192000000 10767367968 11148742656 1815474832 18.141 100 78 156 0 1849547584 12212944 21859808
23:07:15 3335 8192000000 10777509296 11163586560 1832507056 18.280 100 89 177 1 1869725408 12786816 24431536
23:07:24 2860 8192000000 10784021296 11172610048 1841120560 18.350 100 93 185 2 1880954416 14178240 25655616
23:07:34 1804 8192000000 10792611792 11179151360 1844012464 18.373 100 87 175 2 1883123648 14503232 24607952
23:07:43 2337 8192000000 10794440816 11180150784 1848673904 18.411 100 92 185 1 1890350608 15295376 26381328
23:07:51 1827 8192000000 10793260512 11180240896 1849060320 18.414 100 91 182 1 1889444400 15050512 25333568
23:08:00 1806 8192000000 10797824480 11184394240 1850719392 18.428 100 84 168 1 1889335776 15045632 23570752
23:08:08 1871 8192000000 10802598048 11192061952 1857962128 18.487 100 87 174 0 1896950944 13751056 25237760
23:08:16 2374 8192000000 10809064640 11196391424 1861702192 18.517 100 95 188 2 1902272464 14072672 26497600
23:08:26 1473 8192000000 10817446176 11203371008 1866003328 18.552 100 95 187 2 1908522832 14776384 27743120
23:08:34 1980 8192000000 10809919360 11201736704 1866755552 18.558 100 92 183 1 1905668064 12625696 26286816
23:08:42 1763 8192000000 10811950080 11203792896 1872101184 18.601 100 88 174 3 1910767840 13652736 25013920
23:08:50 16453 8192000000 10796093296 11201323008 1867268672 18.562 100 71 142 2 1900143536 13052960 19821904
23:09:15 7854 8192000000 10816150528 11209621504 1873228128 18.610 100 84 165 0 1908587184 12228528 23130528
23:09:29 2102 8192000000 10819387456 11213828096 1876467856 18.637 100 89 177 0 1914751008 12601584 25681568
23:09:37 3062 8192000000 10801020096 11216441344 1874135216 18.618 100 54 106 2 1903725920 14954528 14636176
23:09:48 3974 8192000000 10799044544 11212914688 1877291648 18.643 100 55 110 3 1901768384 9831632 14645104
23:09:58 2250 8192000000 10802309040 11213099008 1875885184 18.632 100 45 90 1 1898375168 9367296 13122688
23:10:07 4128 8192000000 10797839088 11215806464 1877299216 18.643 100 50 100 0 1900744208 9769984 13675008
23:10:18 2953 8192000000 10797789040 11212718080 1880220224 18.667 100 42 84 1 1900980896 9000496 11760176
23:10:29 9034 8192000000 10801319152 11216285696 1882576192 18.686 100 40 81 0 1899559376 6159808 10823376
23:10:46 3335 8192000000 10811048976 11222536192 1886712032 18.719 100 60 118 3 1910849056 6240256 17896768
23:10:56 59792 8192000000 10807947040 11230113792 1884842464 18.704 100 34 66 0 1899791920 4576544 10372912
23:12:02 2847 8192000000 10826519392 11242336256 1897061984 18.803 100 68 136 1 1927137952 10695840 19380128
23:12:13 4412 8192000000 10809367664 11237322752 1894413136 18.781 100 45 91 3 1915190128 8598784 12178208
23:12:25 5254 8192000000 10814927280 11240427520 1895268368 18.788 100 38 74 2 1914166304 8546032 10351904
23:12:37 4552 8192000000 10816868480 11242397696 1897362528 18.805 100 40 80 1 1916728688 8549344 10816816
23:12:48 5409 8192000000 10806108928 11241431040 1896682208 18.800 100 30 60 0 1911652240 6567344 8402688
23:13:01 7380 8192000000 10824535424 11243864064 1900597248 18.831 100 30 61 1 1914676480 5077296 9001936
23:13:17 6727 8192000000 10809266048 11242545152 1898785168 18.817 100 24 48 1 1911767520 6348832 6633520
23:13:31 6656 8192000000 10817531904 11252219904 1905366256 18.869 100 22 44 0 1921866112 10792608 5707248
23:13:46 9825 8192000000 10818438992 11253231616 1904483104 18.862 100 18 36 0 1915835808 6436688 4916016
23:14:02 8639 8192000000 10828297792 11259432960 1912783920 18.929 100 34 68 0 1928724016 6256704 9683392
23:14:18 7827 8192000000 10825563680 11258920960 1913308864 18.933 100 24 48 2 1925613568 5638032 6666672
23:14:38 7200 8192000000 10818054096 11259113472 1914846672 18.946 100 11 22 0 1923356928 5614016 2896240
23:14:53 12763 8192000000 10832684160 11268341760 1918362688 18.974 100 24 48 1 1930865376 5342448 7160240
23:15:13 61774 8192000000 10827241360 11262324736 1899223952 18.820 99 24 48 1 1911719312 5179728 7315632
23:16:24 10354 8192000000 10824421856 11259437056 1914405856 18.942 100 29 58 3 1929690368 6841824 8442688
23:16:40 7795 8192000000 10833454896 11264606208 1915703664 18.952 100 32 64 0 1931404624 6592032 9108928
23:16:55 11451 8192000000 10811362272 11251646464 1877764160 18.647 98 20 40 0 1888989296 5698480 5526656
23:17:14 7614 8192000000 10821697808 11249782784 1898970624 18.818 100 28 55 2 1912550896 6546864 7033408
23:17:28 8307 8192000000 10804557088 11232124928 1888542848 18.734 100 18 36 0 1899452688 5547584 5362256
23:17:43 7484 8192000000 10787637280 11221360640 1849051920 18.414 98 23 47 2 1861654320 5892768 6709632
23:17:57 7433 8192000000 10796113568 11233939456 1875381584 18.628 99 31 62 1 1890331264 6717008 8232672
23:18:12 7217 8192000000 10805163984 11234615296 1876253888 18.635 99 17 34 1 1886308032 5448016 4606128
23:18:27 5365 8192000000 10787323008 11212861440 1857639648 18.484 98 38 76 4 1875375968 6625920 11110400
23:18:38 5941 8192000000 10771586384 11198525440 1818202064 18.163 97 19 38 1 1829114768 5525872 5386832
23:18:54 11638 8192000000 10791085648 11219013632 1839416400 18.336 98 13 26 1 1848359264 5312368 3630496
23:19:12 6312 8192000000 10780166928 11206582272 1850553632 18.427 99 25 50 1 1864541600 7166320 6821648
23:19:25 14795 8192000000 10766514224 11185414144 1789274672 17.926 96 26 52 1 1802806992 5999984 7532336
23:19:48 66314 8192000000 10681707904 11088445440 1660470352 16.853 91 33 66 0 1675874944 5371584 10033008
23:21:03 11321 8192000000 10680288416 11095670784 1672427696 16.954 93 21 42 0 1683374976 4591264 6356016
23:21:21 7695 8192000000 10688155488 11100028928 1731554192 17.448 97 29 58 2 1745795248 5556624 8684432
23:21:35 8016 8192000000 10723683136 11133575168 1779867760 17.848 99 33 66 1 1796550816 7204512 9478544
23:21:52 3691 8192000000 10733729168 11141435392 1800375904 18.017 100 37 74 2 1822611824 12186336 10049584
23:22:04 4289 8192000000 10720490160 11133382656 1786863488 17.906 99 30 60 2 1800771536 4959088 8948960
23:22:18 6408 8192000000 10728722928 11135041536 1767755376 17.748 98 23 44 2 1783787472 9515888 6516208
23:22:31 9184 8192000000 10719533696 11134980096 1788887696 17.923 99 20 40 0 1799529584 4981936 5659952
23:22:47 10416 8192000000 10716920464 11137708032 1786703488 17.905 98 21 42 1 1798433968 5124240 6606240
23:23:08 9919 8192000000 10709020576 11128270848 1781621968 17.863 98 21 41 1 1793566416 6025680 5918768
23:23:28 7715 8192000000 10725658032 11143008256 1784209456 17.884 98 19 38 3 1794972176 5081168 5681552
23:23:46 7459 8192000000 10750743168 11165073408 1828616320 18.248 100 32 65 1 1843690992 4838144 10236528
23:23:59 10623 8192000000 10760008560 11173199872 1818580272 18.166 99 32 63 1 1837287728 9113552 9593904
23:24:17 10009 8192000000 10751344640 11175550976 1834164080 18.293 100 18 36 1 1844888976 5774992 4949904
23:24:33 21157 8192000000 10760127824 11188678656 1851732560 18.436 100 38 75 0 1868406800 5502752 11171488
23:25:01 47198 8192000000 10808262576 11210072064 1860808224 18.510 100 68 136 1 1887230896 6286000 20136672
23:25:55 7321 8192000000 10784066768 11196776448 1854770576 18.461 100 19 36 1 1865875152 5725840 5378736
23:26:09 7550 8192000000 10781346032 11205390336 1864528672 18.540 100 26 52 0 1877732336 5607200 7596464
23:26:23 6335 8192000000 10775469040 11206488064 1867603232 18.565 100 28 52 0 1881051360 5650576 7797552
23:26:38 7277 8192000000 10775965408 11209625600 1871417168 18.596 100 34 68 0 1888816128 5949264 11449696
23:26:51 7211 8192000000 10783023264 11214561280 1869374624 18.579 100 16 32 0 1879274928 5480880 4419424
23:27:05 8500 8192000000 10800246912 11226165248 1884447392 18.701 100 24 46 2 1896079232 5473088 6158752
23:27:30 26359 8192000000 10825279424 11245649920 1900779648 18.833 100 31 61 3 1915291984 6237744 8274592
23:28:04 24907 8192000000 10844202720 11262898176 1917194096 18.964 100 57 114 3 1942538304 9257664 16086544
23:28:46 14245 8192000000 10866149152 11283501056 1926782304 19.041 100 59 118 1 1956146592 13040016 16324272
23:29:08 4694 8192000000 10876037968 11287367680 1930425456 19.070 100 64 126 6 1960640400 13077472 17137472
23:29:21 23979 8192000000 10881721088 11294068736 1934977280 19.107 100 60 120 0 1967234768 15103552 17153936
23:29:56 14263 8192000000 10871365008 11295522816 1938519968 19.135 100 46 89 4 1964137968 12204096 13413904
23:30:19 13914 8192000000 10883570528 11308048384 1946793216 19.201 100 56 112 2 1980839920 17573056 16473648
23:30:42 59492 8192000000 10866103328 11306897408 1947406544 19.206 100 38 73 3 1970235504 11627888 11201072
23:33:53 20116 8192000000 10910872384 11343081472 1969770112 19.384 100 43 84 2 2000070064 17431760 12868192
23:34:25 13036 8192000000 10920955456 11343355904 1971283840 19.396 100 52 104 1 2004852480 17993440 15575200
23:34:46 4887 8192000000 10926087904 11351482368 1979396736 19.460 100 54 108 1 2016385104 21360672 15627696
23:34:58 5385 8192000000 10925582208 11352600576 1985014944 19.504 100 59 116 0 2020455392 18604528 16835920
23:35:10 5639 8192000000 10939762784 11360583680 1985989792 19.512 100 69 137 1 2025221264 19149312 20082160
23:35:26 7232 8192000000 10934398096 11360387072 1991129872 19.553 100 57 114 1 2028154256 20164320 16860064
23:35:40 4476 8192000000 10941105520 11368587264 1991546592 19.556 100 63 126 0 2030654080 20434928 18672560
23:35:54 5159 8192000000 10936815648 11368587264 1993080928 19.568 100 56 112 0 2030521040 20382848 17057264
23:36:08 3399 8192000000 10936626960 11364581376 1977564480 19.445 99 65 130 1 2017288240 20982656 18741104
23:36:21 2994 8192000000 10940937712 11371270144 1997154912 19.600 100 65 130 1 2038394048 21838464 19400672
23:36:34 6562 8192000000 10954715808 11381256192 2000098112 19.624 100 65 129 1 2041226576 22012704 19115760
23:36:51 4773 8192000000 10959913472 11380076544 2002090048 19.639 100 74 148 0 2049068544 24493024 22485472
23:37:05 3277 8192000000 10949457264 11377496064 2004135696 19.655 100 67 134 1 2047596720 24221792 19239232
23:37:15 5784 8192000000 10950256240 11368722432 1990986096 19.552 99 84 167 0 2041264480 25625392 24652992
23:37:30 8170 8192000000 10967181584 11392819200 2007482464 19.682 100 73 144 1 2056033696 27059760 21491472
23:37:50 2307 8192000000 10979997824 11391045632 2008746560 19.692 100 79 156 2 2058381424 25844976 23789888
23:38:00 2028 8192000000 10969283856 11387928576 2000992640 19.631 100 74 148 2 2051063888 27099200 22972048
23:38:09 4025 8192000000 10939796672 11356725248 1978933936 19.456 99 69 138 1 2027043952 27297488 20812528
23:38:21 11065 8192000000 10951703216 11378798592 1994288000 19.578 100 67 132 0 2041817584 27368080 20161504
23:38:40 8938 8192000000 10958232864 11386740736 2002350672 19.641 100 64 126 1 2050934976 28913488 19670816
23:39:04 6219 8192000000 10970579536 11395399680 2006622336 19.675 100 76 152 0 2058835696 29831504 22381856
23:39:18 4939 8192000000 10976770096 11395629056 2005031024 19.662 100 71 142 1 2058749184 31793712 21924448
23:39:34 9890 8192000000 10975411184 11403354112 2011140736 19.710 100 83 165 2 2068461376 32176432 25144208
23:39:52 4832 8192000000 11007678128 11423219712 2022201424 19.797 100 83 164 0 2086019920 39105184 24713312
23:40:04 8116 8192000000 11006021872 11428126720 2026568720 19.832 100 82 165 3 2093385600 41893152 24923728
23:40:18 2621 8192000000 11003005872 11430690816 2023371936 19.807 100 69 136 0 2088123968 43755248 20996784
23:40:30 8179 8192000000 10989611792 11423453184 2018665680 19.770 100 61 122 1 2079206160 41391056 19149424
23:40:45 3243 8192000000 10975605504 11413159936 1999950256 19.622 99 64 128 2 2057013568 37397552 19665760
23:40:56 4532 8192000000 10995908800 11421028352 2017570656 19.761 100 70 141 4 2075878544 36660272 21647616
23:41:10 2360 8192000000 11008940032 11427008512 2022866912 19.803 100 76 149 0 2084241008 38301408 23072688
23:41:21 1731 8192000000 11007446672 11424604160 2020889024 19.787 100 88 177 0 2086039616 38763296 26387296
23:41:31 4956 8192000000 11005786192 11426340864 2022054624 19.796 100 80 160 1 2087289616 40553872 24681120
23:41:43 3390 8192000000 11008668848 11436367872 2024603856 19.816 100 82 160 1 2091677296 41769696 25303744
23:41:55 5954 8192000000 11001793968 11427069952 2006849904 19.677 99 81 161 1 2072871824 41440800 24581120
23:42:08 1343 8192000000 11008890368 11429076992 2016795328 19.755 100 90 178 0 2086400144 42537072 27067744
23:42:16 1459 8192000000 11008694528 11429249024 2022574480 19.800 100 90 182 2 2097281296 45931792 28775024
23:42:25 3980 8192000000 11004851392 11427315712 2017567024 19.761 100 86 172 0 2093452608 49976208 25909376
23:42:36 4030 8192000000 10993489968 11427135488 2011795456 19.716 100 72 143 0 2082725264 49097696 21832112
23:42:47 4909 8192000000 11003978048 11422810112 2011439472 19.713 100 79 158 0 2080384208 44422000 24522736
23:43:00 2598 8192000000 10993655584 11417997312 2009758048 19.700 100 77 153 1 2077207296 44307888 23141360
23:43:11 5296 8192000000 10988166912 11418058752 2008529888 19.690 100 66 132 2 2074055392 44801008 20724496
23:43:26 7672 8192000000 10998415056 11425599488 2016629968 19.754 100 68 135 0 2084406752 47028768 20748016
23:43:42 735 8192000000 11014593968 11432534016 2017990304 19.764 100 86 173 2 2093146320 48174112 26981904
23:43:50 2006 8192000000 11003668608 11427753984 2012709904 19.723 100 88 178 2 2088052160 47123040 28219216
23:44:02 2433 8192000000 10990071328 11403833344 1994527728 19.580 99 90 180 2 2063264992 41530704 27206560
23:44:11 3864 8192000000 10980446960 11400953856 1995311152 19.586 100 80 160 1 2062699296 41523616 25864528
23:44:22 5487 8192000000 10994046240 11413954560 2003486288 19.650 100 83 166 0 2072863872 43823632 25553952
23:44:37 7686 8192000000 10980444192 11408769024 1986054368 19.513 99 73 144 2 2052645728 44527632 22063728
23:44:53 3518 8192000000 10972831696 11403161600 1993980336 19.575 100 66 132 1 2056430528 42433456 20016736
23:45:04 5804 8192000000 10979961200 11407839232 2000081232 19.623 100 65 128 2 2062491296 42607136 19802928
23:45:18 6263 8192000000 10958964624 11403022336 1988329584 19.531 100 49 99 2 2049019216 45583152 15106480
23:45:39 11283 8192000000 10946221920 11392835584 1965173904 19.347 99 38 76 2 2021493264 43960672 12358688
23:46:00 8273 8192000000 10962774640 11401674752 1982350576 19.483 100 40 80 0 2042952144 47289856 13311712
23:46:17 3863 8192000000 10969608464 11399946240 1984302432 19.499 100 71 139 1 2054490880 47526096 22662352
23:46:32 4023 8192000000 10961004688 11379937280 1954882912 19.265 99 62 114 0 2022143568 48845744 18414912
23:46:46 6268 8192000000 10918914960 11335790592 1910028848 18.907 98 70 140 0 1984016384 51659968 22327568
23:47:07 5419 8192000000 10921388624 11357720576 1935850432 19.114 100 51 101 1 2004612800 52196624 16565744
23:47:23 6009 8192000000 10925543920 11371384832 1950957600 19.234 100 43 85 1 2016681920 50911456 14812864
23:47:40 10231 8192000000 10919211712 11353337856 1931191072 19.076 99 40 80 1 1998868592 53653728 14023792
23:47:57 2625 8192000000 10952364512 11375841280 1956524192 19.278 100 81 162 2 2037246176 54632848 26089136
23:48:08 9313 8192000000 10913286704 11363418112 1931335920 19.078 99 42 84 1 1991614960 46585872 13693168
23:48:45 10516 8192000000 10898138336 11334770688 1904899376 18.866 98 38 76 1 1959094880 41757856 12437648
23:49:08 8251 8192000000 10881186816 11317854208 1893429888 18.773 98 30 58 2 1942200464 38875488 9895088
23:49:29 9425 8192000000 10883605600 11316477952 1899331840 18.821 99 32 64 0 1942548416 32746176 10470400
23:49:47 5563 8192000000 10880474416 11316695040 1924366976 19.022 100 46 92 1 1971660864 32124240 15169648
23:49:59 11235 8192000000 10890483984 11328593920 1931623856 19.080 100 30 60 2 1974369344 32381600 10363888
23:50:17 8703 8192000000 10886794784 11324542976 1914822496 18.945 99 31 62 1 1961462624 35990336 10649792
23:50:33 13592 8192000000 10906591584 11338149888 1936504496 19.119 100 38 78 1 1986360768 36364832 13491440
23:50:56 29485 8192000000 10873402432 11321393152 1913212880 18.932 99 28 56 1 1959679168 36666704 9799584
23:51:41 15715 8192000000 10887939952 11328012288 1902172048 18.844 99 30 60 2 1958868880 46080528 10616304
23:52:06 32098 8192000000 10888396336 11337371648 1921781616 19.001 100 28 56 0 1975244016 43344192 10118208
23:52:44 32908 8192000000 10874124704 11333468160 1884729600 18.703 98 20 40 2 1931736096 39383728 7622768
23:53:35 50316 8192000000 10847540928 11325030400 1911064416 18.915 100 12 24 1 1936918384 21851296 4002672
23:54:32 41818 8192000000 10833579152 11295236096 1890245648 18.748 99 12 24 3 1905325664 11914608 3165408
23:55:29 105083 8192000000 10831170512 11282034688 1815273488 18.139 95 31 64 1 1843999424 20413440 8312496
23:57:27 67790 8192000000 10835110176 11295338496 1880060576 18.666 98 15 30 1 1893392688 9369984 3962128
23:58:41 117606 8192000000 10879803440 11322974208 1875314672 18.627 97 24 49 0 1888968288 7438208 6215408
00:00:57 120124 8192000000 10888725104 11338768384 1912923712 18.930 98 29 58 0 1934749008 13684656 8140640
00:03:07 34339 8192000000 10893071696 11354091520 1964636240 19.343 100 24 47 0 1982113072 10785328 6691504
00:03:49 25749 8192000000 10898214800 11348475904 1953672864 19.256 99 19 37 1 1969898288 10889408 5336016
00:04:22 34491 8192000000 10928329504 11374567424 1980034272 19.465 100 45 90 1 2008307904 15050080 13223552
00:05:13 41571 8192000000 10917183776 11379789824 1981325280 19.475 100 40 80 2 2011487232 18330944 11831008
00:06:01 23081 8192000000 10916841440 11379208192 1964200032 19.339 99 30 60 0 1992745680 19464032 9081616
00:06:32 58998 8192000000 10904874240 11375054848 1960277424 19.308 99 20 41 0 1979821728 13908800 5635504
00:07:38 38404 8192000000 10868360496 11337519104 1934679248 19.104 98 16 33 0 1948487072 8968832 4838992
00:08:22 105183 8192000000 10885965424 11350872064 1928877872 19.058 98 12 24 0 1940961312 8765136 3318304
00:10:22 71850 8192000000 10884959072 11356712960 1951311776 19.237 99 21 40 0 1965196288 8428112 5456400
00:11:44 70240 8192000000 10881494528 11364786176 1951316720 19.237 99 8 16 0 1967964576 14290608 2357248
00:13:00 67316 8192000000 10884660096 11369828352 1949422784 19.222 99 10 20 0 1969132864 17088272 2621808
00:14:23 86398 8192000000 10902490432 11351306240 1916544560 18.959 97 16 32 2 1935406960 13988176 4874224
00:16:01 20250 8192000000 10898044000 11351986176 1954469968 19.262 99 33 66 0 1974874224 11175120 9229136
00:16:33 64728 8192000000 10899537632 11380727808 1950838048 19.233 99 13 26 0 1969685248 15294448 3552752
00:17:44 42902 8192000000 10915836416 11372838912 1940806384 19.153 98 27 54 0 1963269760 14543648 7919728
00:20:16 56416 8192000000 10936164752 11381473280 1966656320 19.359 99 22 45 1 1984812256 11847136 6308800
00:21:19 13271 8192000000 10933442992 11388219392 1990984128 19.552 100 29 58 0 2011818576 12880240 7954208
00:21:42 48464 8192000000 10928075968 11396141056 1992196928 19.561 100 17 34 1 2010818512 13604864 5016720
00:22:38 59022 8192000000 10910788560 11372826624 1910279776 18.909 96 18 36 1 1927475856 12043680 5152400
00:23:50 76708 8192000000 10883481520 11354841088 1889696720 18.743 96 27 52 2 1907587696 10379376 7511600
00:25:13 75663 8192000000 10905533200 11390595072 1976458432 19.437 100 15 30 0 1993796704 13356912 3981360
00:26:37 69787 8192000000 10882206416 11341869056 1842455856 18.361 93 13 26 3 1857159232 11451920 3251456
00:27:54 80943 8192000000 10876759648 11332435968 1918768720 18.977 98 14 28 0 1937795456 15328272 3698464
00:29:21 81306 8192000000 10884302416 11356762112 1923102048 19.012 98 23 46 1 1944854496 15439216 6313232
00:30:49 16440 8192000000 10869339872 11338899456 1916240608 18.957 98 13 25 1 1934473360 14825408 3407344
00:31:11 7449 8192000000 10919872416 11351293952 1959058672 19.299 100 47 87 0 1988082896 15431376 13592848
00:31:26 45568 8192000000 10852907328 11328802816 1877126400 18.642 96 17 34 2 1897664256 16107536 4430320
00:32:19 42286 8192000000 10844504512 11315331072 1906063248 18.875 98 12 25 0 1919514608 10095280 3356080
00:33:07 47927 8192000000 10843415424 11311206400 1863755088 18.534 96 16 32 0 1884366224 15417488 5193648
00:34:08 42047 8192000000 10840435184 11313860608 1908810256 18.897 99 9 18 0 1920807680 9587776 2409648
00:34:59 29072 8192000000 10849885712 11309322240 1862580064 18.524 96 16 32 0 1877554752 10318640 4656048
00:35:37 45824 8192000000 10843568432 11305336832 1836960752 18.316 95 32 64 0 1857814240 12144992 8708496
00:36:30 10956 8192000000 10866982048 11313229824 1925313328 19.029 100 51 103 0 1949542176 9212480 15016368
00:36:49 20592 8192000000 10842147632 11282599936 1858833392 18.494 97 48 97 0 1883359776 10997776 13528608
00:37:20 113620 8192000000 10849902240 11308183552 1842626416 18.362 96 17 34 0 1864048000 16269168 5152416
00:39:20 33970 8192000000 10859984464 11306278912 1883356560 18.692 98 35 70 3 1907959888 14770464 9832864
00:40:04 63947 8192000000 10859914112 11321761792 1885598368 18.710 98 16 32 1 1910627056 20043712 4984976
00:41:27 49932 8192000000 10885291008 11332214784 1918164448 18.972 99 25 50 0 1938724400 12789424 7770528
00:42:28 51120 8192000000 10828642160 11301543936 1820140480 18.179 94 17 34 3 1835811760 11238432 4432848
00:43:25 23114 8192000000 10882491728 11303723008 1897626640 18.807 99 49 98 2 1918337120 6310800 14399680
00:43:57 34670 8192000000 10886825456 11333513216 1933126784 19.092 100 41 82 1 1959836288 15337936 11371568
00:46:07 34717 8192000000 10899128528 11338891264 1942736672 19.169 100 34 68 1 1966208432 13673168 9798592
00:46:48 19240 8192000000 10904539376 11342430208 1936553584 19.119 99 46 92 0 1964292272 14872080 12866608
00:47:15 127316 8192000000 10882842672 11349798912 1952643424 19.248 100 30 58 1 1976329312 14888608 8797280
00:49:34 53858 8192000000 10873081696 11334602752 1932948816 19.090 99 24 48 1 1947686224 7398048 7339360
00:50:37 1331 8192000000 10874928912 11333738496 1946097600 19.195 100 35 70 0 1966041632 10097040 9846992
00:50:45 17243 8192000000 10870230864 11336912896 1944001648 19.179 100 17 34 0 1957765888 9166400 4597840
00:51:11 54480 8192000000 10854430144 11330899968 1937483120 19.127 100 10 20 2 1949231328 8949648 2798560
00:52:12 68428 8192000000 10863104704 11338194944 1941947376 19.162 100 8 16 0 1955462768 11463616 2051776
00:53:27 49900 8192000000 10874878992 11337031680 1918466672 18.975 98 20 39 1 1930230400 6758752 5004976
00:54:34 72529 8192000000 10845587344 11317002240 1913516688 18.935 98 16 32 0 1926123152 7642688 4963776
00:55:57 22678 8192000000 10845877136 11316862976 1927403376 19.046 99 18 36 0 1941131248 8448464 5279408
00:56:27 51233 8192000000 10854237232 11338530816 1923798848 19.017 99 5 10 0 1933040288 8199328 1042112
00:57:26 59115 8192000000 10857526576 11334623232 1905900768 18.874 98 9 18 0 1916572192 8662464 2008960
00:58:33 69176 8192000000 10902049424 11369787392 1955654160 19.271 99 21 42 0 1975261168 13625536 5981472
00:59:49 50164 8192000000 10913121504 11380236288 1979601232 19.462 100 38 76 1 2006373312 16532352 10239728
01:00:46 86270 8192000000 10922721472 11400388608 1962617152 19.327 99 24 48 3 1989645728 20087696 6940880
01:02:22 96639 8192000000 10878874688 11357954048 1873215840 18.610 95 13 26 0 1893311328 16522960 3572528
01:04:07 54776 8192000000 10895005872 11356917760 1914535440 18.943 97 15 30 1 1928626672 10303344 3787888
01:05:09 42399 8192000000 10913973456 11355308032 1932254832 19.085 98 35 70 0 1954076576 11952640 9869104
01:06:02 33584 8192000000 10917445168 11365154816 1943848352 19.177 98 45 90 1 1968317264 12097536 12371376
01:06:43 12046 8192000000 10910965104 11356368896 1945783936 19.193 99 43 86 0 1969861152 11992608 12084608
01:07:03 59580 8192000000 10890147760 11345338368 1874984336 18.625 95 27 54 1 1893808064 11567824 7255904
01:08:09 56353 8192000000 10906509120 11368439808 1925387856 19.030 98 32 64 3 1948957264 14667920 8901488
01:09:20 84307 8192000000 10906844128 11366375424 1929202688 19.061 98 16 32 0 1946316432 12423584 4690160
01:12:25 81741 8192000000 10893741440 11361665024 1943804432 19.177 98 31 62 1 1966718688 14129328 8784928
01:13:56 73638 8192000000 10851536816 11328008192 1865683376 18.549 95 7 12 1 1875773520 8584048 1506096
01:15:18 89430 8192000000 10869536016 11343568896 1930772144 19.073 99 9 18 0 1940047744 6412272 2863328
01:17:22 96919 8192000000 10870535184 11357708288 1939633888 19.144 99 19 38 2 1955440944 10468352 5338704
01:19:05 45960 8192000000 10877827184 11353624576 1939557824 19.143 99 16 32 0 1952264432 8182752 4523856
01:19:58 59717 8192000000 10876575856 11351699456 1931141184 19.076 98 15 30 0 1943018080 7547456 4329440
01:22:03 51715 8192000000 10859281872 11331637248 1893085584 18.771 97 6 12 0 1903450000 8749632 1614784
01:23:03 59529 8192000000 10879523664 11352641536 1930872752 19.074 99 23 46 0 1945314400 7597200 6844448
01:24:16 49345 8192000000 10865539392 11332182016 1911097632 18.915 98 20 39 1 1926972144 10062240 5812272
01:25:15 46079 8192000000 10865121712 11325313024 1901667008 18.840 98 28 56 0 1921766752 11844800 8254944
01:26:17 31200 8192000000 10874603056 11331366912 1905804544 18.873 98 50 99 1 1932900000 13009360 14086096
01:26:58 21089 8192000000 9510375680 9817182208 650798016 7.359 34 9 15 1 661683040 8702000 2183024

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-01-2021 01:29:01 to 08-01-2021 01:29:03.

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          244379
MON$OLDEST_ACTIVE               245407
MON$OLDEST_SNAPSHOT             245407
MON$NEXT_TRANSACTION            245407
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                       2017728
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 ---
:541: 
:542: mscs-test-161.budzdorov.ru    Fri Jan  8 01:27:24 2021
:543:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:544: 
:545: 
:546: mscs-test-161.budzdorov.ru    Fri Jan  8 01:27:28 2021
:547:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:548: 
:549: 
:550: mscs-test-161.budzdorov.ru    Fri Jan  8 01:27:28 2021
:551:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:552: 
:553: 
:554: mscs-test-161.budzdorov.ru    Fri Jan  8 01:27:28 2021
:555:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:556: 
--- end of diff output ---

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

08.01.21 01:29:04. 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-08 01:29:06 No severe PSQL-related problems occured
08.01.21 01:29:08. End of report.