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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-18 19:27:04
DTS_END                         2020-11-18 19:27:04.8650
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/58018
TRN_ID                          238765
ATT_ID                          707
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: 9149.85 21310 1097982
customer order: creation 171.42 370 20570
customer order: refuse 14.22 354 1706
order to supplier: creation 44.93 1304 5392
order to supplier: removal 3.21 98824 385
invoice (draft): creation 45.27 3257 5432
invoice (draft): removal 50.83 652 6099
invoice accept: apply 42.76 19132 5131
invoice accept: cancel 45.73 740 5488
customer reserve: creation 3940.04 191 472805
customer reserve: removal 4504.83 57 540580
realization accept: apply 82.84 185 9941
realization accept: cancel 76.24 108 9149
payment from customer: creation 59.67 126 7160
payment from customer: removal 5.13 96 616
payment to supplier: creation 47.88 133 5745
payment to supplier: removal 3.32 51 398
service: total inventory turnovers 4.67 1207 560
service: total monetary turnovers 5.98 36 717
service: aggregate perf. data 0.87 19070 104
service: refresh index statistics 0.03 280298 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-11-2020 19:29:07 to 18-11-2020 19:29:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5179
TEST_TIME 2 3582
TEST_TIME 3 5014
TEST_TIME 4 6240
TEST_TIME 5 6788
TEST_TIME 6 7033
TEST_TIME 7 6773
TEST_TIME 8 6335
TEST_TIME 9 6659
TEST_TIME 10 6498
TEST_TIME 11 6560
TEST_TIME 12 6583
TEST_TIME 13 6466
TEST_TIME 14 6585
TEST_TIME 15 6702
TEST_TIME 16 6784
TEST_TIME 17 6866
TEST_TIME 18 6818
TEST_TIME 19 7064
TEST_TIME 20 7180
TEST_TIME 21 7407
TEST_TIME 22 7807
TEST_TIME 23 7878
TEST_TIME 24 8239
TEST_TIME 25 8594
TEST_TIME 26 8710
TEST_TIME 27 8704
TEST_TIME 28 8856
TEST_TIME 29 9642
TEST_TIME 30 10114
TEST_TIME 31 10214
TEST_TIME 32 10631
TEST_TIME 33 10439
TEST_TIME 34 10161
TEST_TIME 35 9981
TEST_TIME 36 9887
TEST_TIME 37 9898
TEST_TIME 38 9804
TEST_TIME 39 9699
TEST_TIME 40 9589
TEST_TIME 41 9576
TEST_TIME 42 9525
TEST_TIME 43 9533
TEST_TIME 44 9424
TEST_TIME 45 9385
TEST_TIME 46 9318
TEST_TIME 47 9195
TEST_TIME 48 9291
TEST_TIME 49 9213
TEST_TIME 50 9175
TEST_TIME 51 9215
TEST_TIME 52 9239
TEST_TIME 53 9240
TEST_TIME 54 9308
TEST_TIME 55 9321
TEST_TIME 56 9344
TEST_TIME 57 9413
TEST_TIME 58 9411
TEST_TIME 59 9398
TEST_TIME 60 9448
TEST_TIME 61 9501
TEST_TIME 62 9483
TEST_TIME 63 9525
TEST_TIME 64 9565
TEST_TIME 65 9452
TEST_TIME 66 9432
TEST_TIME 67 9386
TEST_TIME 68 9358
TEST_TIME 69 9354
TEST_TIME 70 9321
TEST_TIME 71 9281
TEST_TIME 72 9239
TEST_TIME 73 9221
TEST_TIME 74 9240
TEST_TIME 75 9248
TEST_TIME 76 9234
TEST_TIME 77 9171
TEST_TIME 78 9218
TEST_TIME 79 9334
TEST_TIME 80 9342
TEST_TIME 81 9320
TEST_TIME 82 9356
TEST_TIME 83 9371
TEST_TIME 84 9437
TEST_TIME 85 9421
TEST_TIME 86 9514
TEST_TIME 87 9490
TEST_TIME 88 9495
TEST_TIME 89 9483
TEST_TIME 90 9464
TEST_TIME 91 9440
TEST_TIME 92 9411
TEST_TIME 93 9332
TEST_TIME 94 9342
TEST_TIME 95 9297
TEST_TIME 96 9310
TEST_TIME 97 9296
TEST_TIME 98 9319
TEST_TIME 99 9354
TEST_TIME 100 9385
TEST_TIME 101 9362
TEST_TIME 102 9341
TEST_TIME 103 9407
TEST_TIME 104 9399
TEST_TIME 105 9362
TEST_TIME 106 9433
TEST_TIME 107 9456
TEST_TIME 108 9443
TEST_TIME 109 9461
TEST_TIME 110 9428
TEST_TIME 111 9358
TEST_TIME 112 9350
TEST_TIME 113 9292
TEST_TIME 114 9324
TEST_TIME 115 9301
TEST_TIME 116 9266
TEST_TIME 117 9270
TEST_TIME 118 9237
TEST_TIME 119 9227
TEST_TIME 120 9151

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-11-2020 19:29:11 to 18-11-2020 19:29:14.

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 1533749 1533749 0 0.00 0 22172 7 0 0
doc_list_biud 1533749 1533749 0 0.00 0 45880 25 0 0
sp_add_invoice_to_stock 5252 5131 121 2.30 31 236558 19133 0 121
sp_cancel_adding_invoice 5488 5488 0 0.00 4 60517 741 0 0
sp_cancel_client_order 1706 1706 0 0.00 4 14219 354 0 0
sp_cancel_customer_reserve 540580 540580 0 0.00 1 45882 57 0 0
sp_cancel_pay_from_customer 616 616 0 0.00 3 6906 96 0 0
sp_cancel_pay_to_supplier 398 398 0 0.00 3 1054 51 0 0
sp_cancel_supplier_invoice 6108 6099 9 0.14 2 31545 653 0 9
sp_cancel_supplier_order 385 385 0 0.00 7 1061839 98824 0 0
sp_cancel_write_off 9149 9149 0 0.00 1 11831 108 0 0
sp_client_order 20570 20570 0 0.00 3 58118 371 0 0
sp_customer_reserve 472805 472805 0 0.00 0 152103 192 0 0
sp_fill_shopping_cart 31389 31389 0 0.00 1 10722 37 0 0
sp_fill_shopping_cart_clo_res 472803 472803 0 0.00 0 20767 14 0 0
sp_get_clo_for_invoice 5127 5127 0 0.00 0 15592 262 0 0
sp_kill_cost_storno 15651 15651 0 0.00 0 11801 54 0 0
sp_kill_qstorno_ret_qs2qd 1096793 1096793 0 0.00 0 45878 30 0 0
sp_kill_qty_storno 578475 578475 0 0.00 0 45880 66 0 0
sp_lock_selected_doc 20584 20584 0 0.00 0 6884 5 0 0
sp_make_cost_storno 27973 27973 0 0.00 0 21953 61 0 0
sp_multiply_rows_for_pdistr 27973 27973 0 0.00 0 19013 30 0 0
sp_multiply_rows_for_qdistr 20570 20570 0 0.00 0 58102 165 0 0
sp_pay_from_customer 7160 7160 0 0.00 4 15548 126 0 0
sp_pay_to_supplier 5745 5745 0 0.00 4 23380 134 0 0
sp_payment_common 12905 12905 0 0.00 1 18336 34 0 0
sp_qd_handle_on_cancel_clo 1706 1706 0 0.00 0 14213 324 0 0
sp_qd_handle_on_invoice_upd_sts 10615 10615 0 0.00 0 39080 303 0 0
sp_qd_handle_on_reserve_upd_sts 9941 9941 0 0.00 0 20215 62 0 0
sp_reserve_write_off 9941 9941 0 0.00 6 20283 186 0 0
sp_supplier_invoice 5432 5432 0 0.00 5 60420 3257 0 0
sp_supplier_order 5392 5392 0 0.00 5 23566 1305 0 0
srv_aggregate_perf_data 104 104 0 0.00 2248 184026 19071 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1438 171726 32361 0 0
srv_find_qd_qs_mism 1049156 1049156 0 0.00 0 14854 6 0 0
srv_make_invnt_saldo 560 560 0 0.00 41 53783 1207 0 0
srv_make_money_saldo 717 717 0 0.00 1 8732 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 206156 436733 280299 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5131 5131 0 0.00 0 25634 185 0 0
t$perf-norm:sp_cancel_adding_invoice 373 373 0 0.00 0 6449 135 0 0
t$perf-norm:sp_cancel_client_order 1706 1706 0 0.00 0 3321 12 0 0
t$perf-norm:sp_cancel_customer_reserve 649 649 0 0.00 0 4924 36 0 0
t$perf-norm:sp_cancel_pay_from_customer 616 616 0 0.00 0 2513 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 398 398 0 0.00 0 696 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 1080 18 0 0
t$perf-norm:sp_cancel_supplier_order 385 385 0 0.00 0 24276 1527 0 0
t$perf-norm:sp_cancel_write_off 976 976 0 0.00 0 3540 12 0 0
t$perf-norm:sp_client_order 20570 20570 0 0.00 0 12420 19 0 0
t$perf-norm:sp_customer_reserve 1011 1011 0 0.00 0 4251 9 0 0
t$perf-norm:sp_pay_from_customer 7160 7160 0 0.00 0 10559 13 0 0
t$perf-norm:sp_pay_to_supplier 5745 5745 0 0.00 0 6038 8 0 0
t$perf-norm:sp_reserve_write_off 9941 9941 0 0.00 0 11095 13 0 0
t$perf-norm:sp_supplier_invoice 5432 5432 0 0.00 0 14770 25 0 0
t$perf-norm:sp_supplier_order 5392 5392 0 0.00 0 7284 18 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 993 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 812 14 0 0
t$perf-norm:srv_make_invnt_saldo 560 560 0 0.00 0 3805 32 0 0
t$perf-norm:srv_make_money_saldo 717 717 0 0.00 0 3724 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 2371 595 0 0
v_add_invoice_to_stock 10496 10254 242 2.30 0 4292 15 0 242
v_all_customers 37602 37602 0 0.00 0 18 1 0 0
v_all_suppliers 29768 29768 0 0.00 0 30 1 0 0
v_all_wares 41140 41140 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 746 746 0 0.00 0 7566 15 0 0
v_cancel_client_order 3412 3412 0 0.00 0 2158 5 0 0
v_cancel_customer_prepayment 1232 1232 0 0.00 0 2549 7 0 0
v_cancel_customer_reserve 1298 1298 0 0.00 0 536 3 0 0
v_cancel_payment_to_supplier 796 796 0 0.00 0 958 5 0 0
v_cancel_supplier_invoice 844 826 18 2.13 0 858 15 0 18
v_cancel_supplier_order 770 770 0 0.00 0 3664 13 0 0
v_cancel_write_off 1952 1952 0 0.00 0 3194 14 0 0
v_max_id_clo_ord 5389 5389 0 0.00 0 530 1 0 0
v_max_id_clo_res 1011 1011 0 0.00 0 1211 11 0 0
v_max_id_ord_sup 5430 5430 0 0.00 0 5302 5 0 0
v_max_non_paid_invoice 1679 1679 0 0.00 0 764 2 0 0
v_max_non_paid_realizn 3807 3807 0 0.00 0 5087 4 0 0
v_min_id_clo_ord 5389 5389 0 0.00 0 8395 10 0 0
v_min_id_clo_res 1011 1011 0 0.00 0 17115 32 0 0
v_min_id_ord_sup 5430 5430 0 0.00 0 4509 5 0 0
v_min_non_paid_invoice 5745 5745 0 0.00 0 18329 21 0 0
v_min_non_paid_realizn 7160 7160 0 0.00 0 14617 24 0 0
v_our_firm 10244 10244 0 0.00 0 16 1 0 0
v_reserve_write_off 19882 19882 0 0.00 0 4200 5 0 0
x_lock_depdocs_on_canc_invoice 11174 11174 0 0.00 0 28320 117 0 0
x_lock_depdocs_on_canc_sup_ord 385 385 0 0.00 0 10757 388 0 0
x_make_qstorno_1000_1200 5392 5392 0 0.00 1 23524 1224 0 0
x_make_qstorno_1200_2000 5432 5432 0 0.00 2 60412 3128 0 0
x_make_qstorno_2100_3300 472805 472805 0 0.00 0 152098 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-11-2020 19:29:15 to 18-11-2020 19:29:19.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:08 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:14 16759 8192000000 10250052192 10558836736 893221056 9.831 71 56 110 1 914020784 2638096 18161632
16:57:40 23795 8192000000 10341018864 10657071104 1388748864 14.495 100 80 160 0 1419043376 4790496 25504016
16:58:15 16084 8192000000 10369273392 10688581632 1422776896 14.797 100 89 178 0 1457255728 5724752 28754080
16:58:44 35623 8192000000 10394090160 10721968128 1446455552 15.007 100 85 170 2 1481487328 7346896 27684880
16:59:31 34051 8192000000 10430884400 10760941568 1484939008 15.345 100 86 172 0 1520396768 8122128 27335632
17:00:13 22783 8192000000 10450958656 10783232000 1506220592 15.530 100 89 178 0 1543290016 8718816 28350608
17:00:48 19176 8192000000 10470288512 10805362688 1520439712 15.654 100 90 180 1 1558385648 9369776 28576160
17:01:15 24241 8192000000 10483061392 10824589312 1534975632 15.780 100 81 162 0 1570527152 9929504 25622016
17:01:48 18333 8192000000 10494812064 10842968064 1557925360 15.978 100 81 165 0 1592650160 9855136 24869664
17:02:23 13319 8192000000 10519038448 10871922688 1580913872 16.176 100 77 154 2 1614339392 10022000 23403520
17:02:48 10965 8192000000 10532682048 10891112448 1604031072 16.374 100 79 158 1 1637797248 10622928 23143248
17:03:06 11486 8192000000 10561380640 10918989824 1619605216 16.507 100 79 159 1 1653934176 11377968 22950992
17:03:27 12144 8192000000 10597429344 10957557760 1647424432 16.743 100 79 158 3 1683156640 12228656 23503552
17:03:48 8943 8192000000 10616876112 10983911424 1672008000 16.950 100 75 150 3 1705065808 11759904 21297904
17:04:05 5695 8192000000 10634017232 11001282560 1691565408 17.114 100 80 160 0 1727984656 12759872 23659376
17:04:21 7942 8192000000 10653413328 11019763712 1705809200 17.234 100 84 168 0 1743624736 13287280 24528256
17:04:39 5680 8192000000 10661871728 11033608192 1722231152 17.371 100 81 160 1 1757219712 12487616 22500944
17:04:52 6209 8192000000 10680084560 11054665728 1734414464 17.472 100 75 152 0 1767763872 11888720 21460688
17:05:07 4712 8192000000 10679689312 11061194752 1750320688 17.604 100 65 131 1 1779921312 11210272 18390352
17:05:19 5114 8192000000 10688252464 11072528384 1757022800 17.660 100 68 134 0 1787638224 11766656 18848768
17:05:30 3557 8192000000 10711633664 11090849792 1773277168 17.794 100 82 164 2 1809382576 11979408 24126000
17:05:41 11022 8192000000 10706144032 11093368832 1777940928 17.833 100 73 144 0 1809576896 11706960 19929008
17:06:00 4338 8192000000 10735262144 11116527616 1787224176 17.909 100 79 159 1 1820682032 11493696 21964160
17:06:13 3026 8192000000 10741165792 11127947264 1806303168 18.066 100 84 169 1 1841792544 11702432 23786944
17:06:22 4091 8192000000 10757466976 11141287936 1813586688 18.125 100 84 168 0 1849752944 12170640 23995616
17:06:33 2887 8192000000 10764013920 11148816384 1818595472 18.166 100 84 168 1 1855774224 13759376 23419376
17:06:43 2722 8192000000 10770224320 11156738048 1828308272 18.246 100 82 160 2 1864345136 13442928 22593936
17:06:53 2075 8192000000 10777920608 11159793664 1833809840 18.290 100 91 182 2 1872747216 13429216 25508160
17:07:02 2447 8192000000 10778270544 11166257152 1839981184 18.341 100 88 175 0 1878896544 14617072 24298288
17:07:11 1686 8192000000 10794475424 11180670976 1845542688 18.386 100 87 171 0 1884503648 13902560 25058400
17:07:19 2893 8192000000 10796819280 11180867584 1849100592 18.415 100 90 180 1 1888593168 14600704 24891872
17:07:28 2188 8192000000 10791497552 11184754688 1851374448 18.433 100 93 185 1 1892089824 14631696 26083680
17:07:37 2568 8192000000 10791391760 11184435200 1856378960 18.474 100 83 167 2 1892800560 13247184 23174416
17:07:46 2719 8192000000 10795734912 11188813824 1858686560 18.493 100 83 165 1 1895309040 13844656 22777824
17:07:56 1479 8192000000 10809416256 11195527168 1860057664 18.504 100 94 188 2 1899822080 13236400 26528016
17:08:04 2303 8192000000 10815243792 11202236416 1864791648 18.542 100 91 182 3 1903612432 12725616 26095168
17:08:12 1559 8192000000 10812124672 11204968448 1868273040 18.570 100 79 159 0 1902048032 11036384 22738608
17:08:21 16279 8192000000 10765642384 11195580416 1865061936 18.544 100 56 112 0 1891461968 10831696 15568336
17:08:46 11694 8192000000 10790343232 11201617920 1869257520 18.578 100 56 112 3 1897635200 12262480 16115200
17:09:05 7806 8192000000 10813605840 11212066816 1874347360 18.619 100 72 143 2 1903558080 8901472 20309248
17:09:19 1412 8192000000 10823253008 11216707584 1882045072 18.682 100 94 191 1 1919755584 11132432 26578080
17:09:27 5931 8192000000 10819681584 11214454784 1878850880 18.656 100 73 146 2 1910308272 10991968 20465424
17:09:40 5195 8192000000 10802315120 11210801152 1878102800 18.650 100 59 118 3 1905873488 11049008 16721680
17:09:51 4008 8192000000 10800360592 11212779520 1879589056 18.662 100 54 109 2 1904792080 10461216 14741808
17:10:02 3614 8192000000 10788255952 11212402688 1878994480 18.657 100 41 82 1 1899795712 9361424 11439808
17:10:13 5007 8192000000 10800155664 11216846848 1881222400 18.675 100 34 68 2 1898345680 7600752 9522528
17:10:26 4990 8192000000 10790746416 11217092608 1882859408 18.688 100 41 81 2 1901577904 7138816 11579680
17:10:43 5408 8192000000 10793340912 11219582976 1888667520 18.735 100 44 86 2 1907037968 6295024 12075424
17:10:54 7573 8192000000 10799825552 11223969792 1883576976 18.694 100 22 44 1 1896606272 6483472 6545824
17:11:09 3536 8192000000 10803994512 11225300992 1890735712 18.752 100 46 93 1 1911797056 8050880 13010464
17:11:20 9540 8192000000 10799504368 11228332032 1888096528 18.730 100 17 34 1 1898417472 5974672 4346272
17:11:40 9472 8192000000 10802726688 11236306944 1891351952 18.757 100 23 46 0 1908090544 10606688 6131904
17:11:58 9559 8192000000 10808676032 11234516992 1896089120 18.795 100 30 61 2 1910622960 6167024 8366816
17:12:16 11605 8192000000 10799298752 11232608256 1893673216 18.775 100 18 35 3 1904113488 5363024 5077248
17:12:40 8427 8192000000 10806126912 11238875136 1898827504 18.817 100 31 58 3 1913745792 6543360 8374928
17:12:55 55466 8192000000 10826878496 11252801536 1904312528 18.861 100 31 61 5 1918773344 5012016 9448800
17:14:11 10024 8192000000 10819195472 11253018624 1903941632 18.858 100 20 40 0 1915070736 5693312 5435792
17:14:30 8297 8192000000 10832517264 11266957312 1909530384 18.903 100 27 55 2 1927532720 10561680 7440656
17:14:45 7725 8192000000 10822834848 11262685184 1909930496 18.906 100 29 56 1 1925077024 7351472 7795056
17:15:00 5013 8192000000 10824529424 11266912256 1911422512 18.918 100 25 48 3 1928133360 10312448 6398400
17:15:12 4962 8192000000 10833470000 11268505600 1912274704 18.925 100 20 41 0 1923840080 6025088 5540288
17:15:25 7820 8192000000 10827604848 11264430080 1913823744 18.937 100 27 55 0 1928321248 6373680 8123824
17:15:39 8702 8192000000 10799739072 11235508224 1875172640 18.626 98 18 36 0 1885866416 5540576 5153200
17:15:54 10083 8192000000 10815130352 11259781120 1909090960 18.899 100 22 44 1 1925103232 10500944 5511328
17:16:10 8511 8192000000 10828927808 11259920384 1906107040 18.875 100 26 52 2 1919264480 6019920 7137520
17:16:26 11612 8192000000 10821319968 11261161472 1891464688 18.758 99 20 39 3 1902811680 6339728 5007264
17:16:45 11480 8192000000 10813881648 11257286656 1892921376 18.769 99 16 31 3 1904476144 6694672 4860096
17:17:03 17542 8192000000 10824422512 11263115264 1890553728 18.750 99 15 30 3 1900156288 5352016 4250544
17:17:31 13384 8192000000 10782502592 11199483904 1760331232 17.687 92 20 39 1 1771861584 5684768 5845584
17:18:07 42252 8192000000 10765533200 11198386176 1807245168 18.073 96 33 64 1 1822211776 4685872 10280736
17:18:55 10718 8192000000 10750496272 11177222144 1758698832 17.674 94 26 52 0 1771847392 5997936 7150624
17:19:17 5310 8192000000 10751269632 11163136000 1769196720 17.760 96 45 90 1 1790006864 8097648 12712496
17:19:32 5000 8192000000 10727959904 11155349504 1792177040 17.950 98 20 40 2 1803793616 5441184 6175392
17:19:44 5837 8192000000 10723013408 11140415488 1741687248 17.533 95 27 54 1 1755684288 6027952 7969088
17:19:56 6678 8192000000 10721865600 11140816896 1765219936 17.728 97 17 32 1 1775375504 5256304 4899264
17:20:12 8389 8192000000 10715635936 11131002880 1754054432 17.635 97 30 60 2 1768599856 5662976 8882448
17:20:27 6149 8192000000 10726339344 11130400768 1756974160 17.659 97 30 60 1 1772787696 6028896 9784640
17:20:42 8047 8192000000 10693905904 11099406336 1700828480 17.192 95 22 44 0 1712490032 5265024 6396528
17:20:59 8405 8192000000 10682420448 11099365376 1737895696 17.501 98 23 46 0 1750158624 5260416 7002512
17:21:14 9762 8192000000 10674833328 11091922944 1704632448 17.224 96 18 37 2 1714858416 4867536 5358432
17:21:29 8059 8192000000 10688405328 11106312192 1765157280 17.727 99 29 57 1 1779538032 5582848 8797904
17:21:44 8185 8192000000 10697643488 11116789760 1783191776 17.876 100 25 50 0 1796560096 5130016 8238304
17:21:59 11404 8192000000 10710965424 11119992832 1746317872 17.571 97 33 64 1 1760933792 5300864 9315056
17:22:18 19835 8192000000 10731714656 11142627328 1786027248 17.899 99 28 56 0 1799719408 5610976 8081184
17:22:44 53268 8192000000 10764218224 11151503360 1812479776 18.116 100 51 103 4 1832568128 5182656 14905696
17:23:43 13053 8192000000 10720486704 11147730944 1794667136 17.970 99 11 22 0 1802843824 5494576 2682112
17:24:05 7024 8192000000 10741630464 11165429760 1827104960 18.236 100 33 64 2 1842893632 7567040 8221632
17:24:22 7832 8192000000 10751578720 11168587776 1829215744 18.253 100 24 46 3 1842192848 6211728 6765376
17:24:36 6529 8192000000 10748898816 11178618880 1837281456 18.319 100 26 52 2 1850224176 5852592 7090128
17:24:53 4513 8192000000 10761468160 11182071808 1843020560 18.365 100 36 72 2 1860818944 8022912 9775472
17:25:04 8282 8192000000 10754342736 11181481984 1843981312 18.373 100 23 46 1 1856304480 5391216 6931952
17:25:18 9592 8192000000 10767780128 11185750016 1847014528 18.398 100 18 37 0 1857621216 5010160 5596528
17:25:34 10533 8192000000 10766345200 11194568704 1853902160 18.454 100 29 58 1 1868329888 6105648 8322080
17:25:52 6849 8192000000 10767789744 11195932672 1853960352 18.454 100 15 30 1 1863481136 5406528 4114256
17:26:06 9800 8192000000 10777254688 11202187264 1858294896 18.489 100 30 60 0 1877421088 9708928 9417264
17:26:24 12699 8192000000 10789897984 11206709248 1860880736 18.510 100 21 40 0 1872457056 5118096 6458224
17:26:47 7377 8192000000 10773594672 11208179712 1862425440 18.523 100 26 52 1 1876491264 5956576 8109248
17:27:04 14087 8192000000 10814610416 11226996736 1883353648 18.692 100 36 72 1 1898203984 5015904 9834432
17:27:47 27594 8192000000 10829692672 11254661120 1897133424 18.803 100 35 72 0 1914651648 6852896 10665328
17:28:23 102085 8192000000 10851488176 11284475904 1922434160 19.006 100 38 76 1 1941728224 7834752 11459312
17:30:25 39008 8192000000 10858750656 11289972736 1931349040 19.078 100 37 74 0 1953102560 10494944 11258576
17:31:12 7665 8192000000 10861419648 11294380032 1937134320 19.124 100 47 92 1 1958678240 8558528 12985392
17:31:28 3920 8192000000 10879995648 11301363712 1944297728 19.181 100 68 136 2 1973795632 10404320 19093584
17:31:39 4928 8192000000 10887312624 11302686720 1940993840 19.155 100 61 122 0 1970294032 11850128 17450064
17:31:51 5794 8192000000 10878706816 11306012672 1944962864 19.186 100 52 104 1 1970376000 11051008 14362128
17:32:08 3685 8192000000 10891225456 11309604864 1951570800 19.239 100 61 122 1 1979245808 10539600 17135408
17:32:20 3696 8192000000 10894040176 11308118016 1935755744 19.113 99 56 111 0 1961376672 9797120 15823808
17:32:32 3672 8192000000 10884878288 11316240384 1955293840 19.269 100 67 132 4 1984901712 10849216 18758656
17:32:42 21327 8192000000 10898502192 11322171392 1958837696 19.297 100 53 105 0 1985784192 11884352 15062144
17:33:11 5489 8192000000 10909338576 11326877696 1973639568 19.414 100 84 163 0 2007357968 10788720 22929680
17:33:33 7794 8192000000 10911162432 11335634944 1969353152 19.380 100 65 130 1 1998988976 11295632 18340192
17:33:48 12103 8192000000 10916749776 11339186176 1975438160 19.429 100 67 133 0 2006454048 10647408 20368480
17:34:07 38321 8192000000 10906997936 11345227776 1975379152 19.428 100 54 107 1 2001307136 10950448 14977536
17:34:56 6021 8192000000 10926781120 11349725184 1982899392 19.488 100 69 137 2 2013589776 11043040 19647344
17:35:25 21580 8192000000 10919663712 11355820032 1984733856 19.502 100 48 96 1 2012778672 14598240 13446576
17:36:04 6403 8192000000 10920337808 11352662016 1968376304 19.373 99 44 88 1 1997633808 16185440 13072064
17:36:18 10184 8192000000 10914474544 11358257152 1980381680 19.468 100 42 84 0 2009564672 16615424 12567568
17:36:37 14681 8192000000 10904650272 11347525632 1974373136 19.420 100 35 70 1 1997950896 13778160 9799600
17:36:59 16496 8192000000 10897899840 11329601536 1960609792 19.311 99 31 61 0 1983331200 13879120 8842288
17:37:27 10071 8192000000 10908649616 11348918272 1973920688 19.417 100 48 96 0 2006829296 19302384 13606224
17:37:46 4696 8192000000 10923633744 11352031232 1980182864 19.466 100 57 115 0 2012963024 15698960 17081200
17:38:02 9817 8192000000 10934069280 11364265984 1988558512 19.532 100 52 102 3 2020633680 15811328 16263840
17:38:20 4004 8192000000 10943640144 11365842944 1995787408 19.589 100 63 126 0 2029522160 15534224 18200528
17:38:31 9407 8192000000 10931051360 11363696640 1989260880 19.538 100 58 112 3 2022316080 16450656 16604544
17:38:47 11998 8192000000 10921155360 11350712320 1971867648 19.400 99 58 114 1 2010086048 21777088 16441312
17:39:07 11223 8192000000 10913970784 11352399872 1973530432 19.413 100 48 96 0 2008058512 19749088 14778992
17:39:28 6149 8192000000 10926586576 11356499968 1965057104 19.346 99 55 110 3 2004520576 22552304 16911168
17:39:44 6394 8192000000 10932424928 11368972288 1983421664 19.492 100 52 104 1 2024586736 25927856 15237216
17:39:58 4986 8192000000 10930022624 11360038912 1985817232 19.511 100 62 123 3 2025525984 21566304 18142448
17:40:14 5102 8192000000 10926966688 11358126080 1965923616 19.353 99 60 119 2 2006927152 22647936 18355600
17:40:33 4358 8192000000 10936779408 11365937152 1978230704 19.451 100 53 105 0 2017730880 23629664 15870512
17:40:50 6018 8192000000 10931383376 11362578432 1982032992 19.481 100 53 106 1 2022554880 23899840 16622048
17:41:05 9904 8192000000 10951856144 11376979968 1973549296 19.414 99 58 115 0 2015749296 25374000 16826000
17:41:22 7453 8192000000 10940713632 11367927808 1987723600 19.526 100 64 121 0 2030749808 24456704 18569504
17:41:39 4240 8192000000 10943938080 11374583808 1989308304 19.538 100 63 124 0 2034556192 26436304 18811584
17:41:50 5672 8192000000 10944723808 11374538752 1991699728 19.557 100 60 120 1 2034818336 24888304 18230304
17:42:02 10652 8192000000 10946186448 11377090560 1990129712 19.545 100 67 135 2 2036779392 26744512 19905168
17:42:23 10549 8192000000 10957287280 11376852992 1987975568 19.528 100 57 115 3 2033186672 28002752 17208352
17:42:41 2737 8192000000 10942287680 11358687232 1971152032 19.395 99 68 135 2 2021586592 30359152 20075408
17:42:51 2937 8192000000 10942028928 11358650368 1975888080 19.432 100 77 154 0 2030842192 31441168 23512944
17:43:03 3721 8192000000 10939060608 11354861568 1953701712 19.256 99 83 161 2 2009647152 31998576 23946864
17:43:16 8078 8192000000 10919841456 11335725056 1947768144 19.209 99 66 132 3 2001635088 33921824 19945120
17:43:33 15818 8192000000 10920848576 11344023552 1942951360 19.170 99 66 133 1 1996682336 33267360 20463616
17:43:59 31201 8192000000 10928881936 11357085696 1953946976 19.258 99 54 107 0 2005894112 35787120 16160016
17:44:38 11333 8192000000 10897698384 11330170880 1923067568 19.011 98 40 80 1 1971041216 35331792 12641856
17:44:59 11079 8192000000 10902662848 11341254656 1952425648 19.246 100 47 92 3 2000560768 33268736 14866384
17:45:19 4029 8192000000 10891133792 11320442880 1917315856 18.965 98 51 103 3 1962816368 29885088 15615424
17:45:38 4471 8192000000 10924743792 11332145152 1947439936 19.206 100 77 149 2 2001440096 31162656 22837504
17:45:56 4430 8192000000 10926732320 11343208448 1954302544 19.261 100 76 150 1 2011608880 34358816 22947520
17:46:08 1435 8192000000 10934907104 11335249920 1952445168 19.246 100 86 174 0 2016888688 37989312 26454208
17:46:16 3658 8192000000 10923963008 11342422016 1949459408 19.222 100 65 130 1 2008150256 39159488 19531360
17:46:30 3712 8192000000 10925611152 11343806464 1931961680 19.083 99 69 135 0 1992619360 39857200 20800480
17:46:47 6132 8192000000 10950950592 11364581376 1963695424 19.335 100 81 162 0 2033719680 44674736 25349520
17:47:04 7893 8192000000 10937959344 11364487168 1966320800 19.356 100 47 94 5 2023726064 42381056 15024208
17:47:22 10797 8192000000 10932664720 11357417472 1956217056 19.276 100 61 121 1 2017996704 42757840 19021808
17:47:41 4740 8192000000 10951390240 11368579072 1967808064 19.368 100 68 134 3 2035224832 46185136 21231632
17:47:53 2097 8192000000 10960551536 11362545664 1965412944 19.349 100 91 185 1 2037786144 44740176 27633024
17:48:02 10249 8192000000 10924620800 11353681920 1933123008 19.092 99 51 102 1 1998725184 49727536 15874640
17:48:28 6897 8192000000 10914211984 11340001280 1947832336 19.209 100 52 103 3 2009556544 45639584 16084624
17:48:42 3807 8192000000 10929174464 11355750400 1956382272 19.277 100 62 124 2 2021223520 45185968 19655280
17:48:55 4642 8192000000 10888950304 11314761728 1905060496 18.867 99 50 100 2 1968233424 46563680 16609248
17:49:06 4154 8192000000 10898686016 11320565760 1917425104 18.966 100 50 98 1 1980967264 47957136 15585024
17:49:18 3818 8192000000 10909560576 11321909248 1921216592 18.997 100 75 148 0 1988560208 42989728 24353888
17:49:33 5881 8192000000 10889345984 11314696192 1919684016 18.984 100 53 106 0 1979857248 42638976 17534256
17:49:46 11845 8192000000 10897436544 11324506112 1927405392 19.046 100 42 84 1 1983555280 42362336 13787552
17:50:05 9765 8192000000 10909919312 11341369344 1939794048 19.145 100 40 80 1 1998854512 45729136 13331328
17:50:22 4240 8192000000 10923594320 11351642112 1945542112 19.191 100 46 92 2 2008599152 47489472 15567568
17:50:33 4392 8192000000 10903921488 11325775872 1911971488 18.922 99 54 108 1 1978902592 49646016 17285088
17:50:46 8887 8192000000 10893675440 11320651776 1908094256 18.891 99 41 82 0 1970476832 48699600 13682976
17:51:02 10742 8192000000 10895802832 11327262720 1911945136 18.922 99 31 61 0 1970919360 47579344 11394880
17:51:25 11916 8192000000 10906186304 11340046336 1931692480 19.080 100 43 86 0 1997470080 52075824 13701776
17:51:57 10917 8192000000 10906262032 11350544384 1941510512 19.159 100 37 74 0 2002968912 49016384 12442016
17:52:23 12188 8192000000 10908336720 11341914112 1926941488 19.042 99 34 68 0 1981698608 43514912 11242208
17:52:42 8885 8192000000 10924333328 11348774912 1945818768 19.193 100 56 110 4 2006312848 42629408 17864672
17:52:58 12574 8192000000 10923349632 11344670720 1932588144 19.088 99 44 88 4 1987245328 40326928 14330256
17:53:18 19555 8192000000 10911856496 11345022976 1927741968 19.049 99 36 72 1 1979741216 40261584 11737664
17:53:49 12832 8192000000 10919410064 11355742208 1949290272 19.221 100 38 74 1 2003687936 42443776 11953888
17:54:28 18882 8192000000 10915753344 11358056448 1934470720 19.103 99 30 60 3 1989847456 45219440 10157296
17:55:12 25513 8192000000 10921174512 11372048384 1931289360 19.077 99 33 66 0 1994890400 52165152 11435888
17:55:58 14755 8192000000 10910968240 11356540928 1935156096 19.108 100 23 46 2 1993158064 49630112 8371856
17:56:26 19918 8192000000 10897940768 11363688448 1936067408 19.115 100 22 44 2 2001318032 57069056 8181568
17:57:01 39773 8192000000 10875135760 11339792384 1873612960 18.613 97 17 34 0 1917934880 38563408 5758512
17:57:46 36599 8192000000 10886389952 11347341312 1928725616 19.057 100 19 38 1 1961507888 27207040 5575232
17:58:56 59765 8192000000 10893199296 11351552000 1950789968 19.233 100 17 32 1 1981266096 25439984 5036144
18:00:03 80526 8192000000 10863373136 11309535232 1896235056 18.796 97 14 28 0 1915258656 15672576 3351024
18:01:33 35217 8192000000 10887389936 11330695168 1956605376 19.279 100 46 92 3 1977561264 7578896 13376992
18:02:19 27267 8192000000 10889843632 11336769536 1959022096 19.298 100 37 73 1 1979560688 10210704 10327888
18:02:53 34703 8192000000 10913157104 11351093248 1967126608 19.363 100 43 86 0 1989575680 10265232 12183840
18:03:36 34087 8192000000 10902084464 11339538432 1929836912 19.066 98 28 54 0 1946522464 8276640 8408912
18:04:24 17320 8192000000 10891227184 11345973248 1960500624 19.310 100 30 59 2 1979466736 10313792 8652320
18:04:59 171726 8192000000 10904354576 11369820160 1944785216 19.185 99 17 34 1 1958713088 8734800 5193072
18:08:18 51806 8192000000 10896627952 11374489600 1974919232 19.424 100 8 16 0 1992035648 14785904 2330512
18:09:23 18969 8192000000 10905757856 11378024448 1973750432 19.415 100 8 16 1 1998399744 22273424 2375888
18:09:48 64500 8192000000 10903809072 11366608896 1958268064 19.292 99 21 40 1 1970919152 7102416 5548672
18:11:01 128173 8192000000 10905311344 11364106240 1953166608 19.252 99 30 60 3 1972249056 9660016 9422432
18:13:29 68414 8192000000 10890847536 11363356672 1955155024 19.268 99 15 30 2 1970919248 11224384 4539840
18:15:12 34786 8192000000 10917327984 11390234624 1987734144 19.526 100 21 42 2 2015635888 21882912 6018832
18:15:57 42639 8192000000 10906379536 11388444672 1971900304 19.401 99 19 38 0 1993746912 16229888 5616720
18:16:49 56266 8192000000 10912550912 11393966080 1984864304 19.503 100 9 18 1 2003874816 16418688 2591824
18:17:59 100503 8192000000 10901652368 11377512448 1955062480 19.267 98 14 28 0 1971832128 12872400 3897248
18:19:51 22603 8192000000 10909395824 11371294720 1968047408 19.370 99 29 58 0 1984463168 8034576 8381184
18:20:27 24847 8192000000 10920387568 11374407680 1954408384 19.262 98 25 49 2 1970021776 8312336 7301056
18:21:02 11490 8192000000 10931020816 11376742400 1958169552 19.291 98 54 107 1 1985417296 11714432 15533312
18:21:35 60122 8192000000 10890157312 11372535808 1941411728 19.158 98 23 46 2 1962413152 14655408 6346016
18:22:42 20963 8192000000 10913912480 11364999168 1960247744 19.308 99 32 64 0 1977855360 8559600 9048016
18:23:14 28529 8192000000 10890922816 11354767360 1945356992 19.189 99 34 68 3 1964962560 10111040 9494528
18:23:52 76386 8192000000 10904210400 11368546304 1967242976 19.364 100 26 52 1 1990759520 16389264 7127280
18:25:16 87530 8192000000 10914516640 11369254912 1915630240 18.952 97 17 34 0 1930481632 9751472 5099920
18:27:20 87233 8192000000 10923587232 11384233984 1963734560 19.336 99 12 24 0 1984587536 17302272 3550704
18:29:22 75741 8192000000 10875323360 11340587008 1836817520 18.315 93 8 16 0 1848880432 10543248 1519664
18:30:45 36830 8192000000 10872766944 11341406208 1918378512 18.974 98 29 58 1 1940704256 14021344 8304400
18:31:32 108158 8192000000 10881990768 11327692800 1878575616 18.654 96 38 76 2 1898434240 8274048 11584576
18:33:27 38058 8192000000 10854563680 11299913728 1871667440 18.598 96 30 60 0 1888329264 8380752 8281072
18:34:13 61005 8192000000 10862199248 11315826688 1906555008 18.879 98 27 54 0 1924857552 11231120 7071424
18:35:20 2154 8192000000 10870309520 11315650560 1932305072 19.085 100 44 88 1 1955103792 10445792 12352928
18:35:28 31588 8192000000 10855077824 11305295872 1888569328 18.734 98 26 52 1 1906102000 10028288 7504384
18:36:22 83955 8192000000 10813318992 11282403328 1821766608 18.192 95 13 26 0 1834263584 8734112 3762864
18:37:52 71870 8192000000 10814314736 11283165184 1864139088 18.537 98 13 25 1 1876115808 8050272 3926448
18:39:23 46541 8192000000 10800737712 11262603264 1856210640 18.473 98 9 18 0 1866948192 8440928 2296624
18:40:17 39285 8192000000 10799913152 11267575808 1865628768 18.549 99 10 20 0 1876567632 8082960 2855904
18:41:10 75715 8192000000 10803225520 11276324864 1819658384 18.175 96 9 18 1 1831543760 9170768 2714608
18:42:45 57900 8192000000 10811142400 11271049216 1849026672 18.414 98 22 44 3 1869031408 13664880 6339856
18:43:55 36637 8192000000 10837288384 11284144128 1892948704 18.770 100 29 58 2 1913061536 11707312 8405520
18:44:40 36256 8192000000 10851084432 11305578496 1899958304 18.826 99 45 90 5 1929503488 16600496 12944688
18:45:27 48864 8192000000 10850150752 11302055936 1880491296 18.669 98 18 36 0 1904999696 19639792 4868608
18:46:29 47283 8192000000 10838787296 11306053632 1905579328 18.871 100 19 38 0 1926345696 15124800 5641568
18:47:24 89082 8192000000 10863160304 11319042048 1918076784 18.971 100 15 30 0 1936814912 14985184 3752944
18:49:00 70399 8192000000 10860355616 11326767104 1909096672 18.899 99 17 34 2 1931793264 17869024 4827568
18:50:23 39383 8192000000 10896785472 11332698112 1933258512 19.093 100 31 62 1 1951360912 9767120 8335280
18:51:09 20032 8192000000 10895742480 11339415552 1946428400 19.198 100 45 88 1 1970495232 11439168 12627664
18:51:36 52164 8192000000 10887616736 11350126592 1938032256 19.131 100 26 52 2 1964063296 18910176 7120864
18:52:39 102936 8192000000 10893815040 11363987456 1942402768 19.166 100 15 30 1 1962813248 16396352 4014128
18:54:31 82821 8192000000 10889370160 11364814848 1938923296 19.138 99 18 37 1 1968443312 24228656 5291360
18:57:13 55161 8192000000 10889600288 11345846272 1923018288 19.011 98 37 74 1 1944234768 11127360 10089120
18:58:15 3524 8192000000 10921364656 11361808384 1975367424 19.428 100 87 173 2 2009368512 9120960 24880128
18:58:31 35321 8192000000 10894152400 11359457280 1972265504 19.403 100 39 78 1 1996314672 13795280 10253888
18:59:19 62185 8192000000 10887251728 11359805440 1970801232 19.392 100 7 14 0 1979849152 7238016 1809904
19:01:53 37278 8192000000 10899850864 11366928384 1955115728 19.267 99 7 14 1 1962999760 6300800 1583232
19:02:36 65680 8192000000 10882930416 11346890752 1900875296 18.833 96 17 34 2 1913193744 7832304 4486144
19:03:48 42311 8192000000 10891800256 11360026624 1947460816 19.206 99 20 40 2 1964352176 10550256 6341104
19:05:25 59747 8192000000 10916355744 11389534208 1978407776 19.452 100 21 40 1 1994351696 9581360 6362560
19:06:41 69991 8192000000 10904722144 11388772352 1965765344 19.352 99 18 36 1 1980521472 9852032 4904096
19:07:57 73882 8192000000 10924132432 11388547072 1952497920 19.246 98 26 52 2 1970864624 11128336 7238368
19:09:23 79563 8192000000 10919971776 11403288576 1974086896 19.418 99 19 38 1 1995095616 15594976 5413744
19:10:49 46335 8192000000 10911292432 11370270720 1952470896 19.246 98 21 40 1 1968277248 9846784 5959568
19:11:42 65450 8192000000 10905513840 11362213888 1897457520 18.806 96 25 50 0 1918020944 13317088 7246336
19:12:54 48350 8192000000 10884959184 11340169216 1895683568 18.792 96 35 70 1 1918223072 12864448 9675056
19:13:51 122490 8192000000 10905019312 11374325760 1941327008 19.157 99 11 22 0 1957291296 13123712 2840576
19:16:09 86861 8192000000 10884897552 11356999680 1901410112 18.838 96 19 38 1 1919553072 13104624 5038336
19:17:42 109057 8192000000 10875990048 11351302144 1922280416 19.005 98 23 46 2 1940937136 12382992 6273728
19:19:48 58308 8192000000 10894584528 11345125376 1935217408 19.109 98 43 86 3 1957940272 11125296 11597568
19:20:53 9566 8192000000 10888409808 11341672448 1940248240 19.149 99 42 84 1 1965586352 13889856 11448256
19:21:10 36125 8192000000 10873578464 11350470656 1950284576 19.229 100 22 45 1 1966243792 9430992 6528224
19:21:53 31098 8192000000 10886342752 11345117184 1951402192 19.238 100 24 46 3 1966227856 7838304 6987360
19:22:38 55708 8192000000 10844542416 11310972928 1836564320 18.313 94 10 20 0 1848007184 8651632 2791232
19:23:40 47812 8192000000 10856466320 11323854848 1918146416 18.972 99 17 34 0 1933680720 10481632 5052672
19:24:39 79322 8192000000 10843287408 11309195264 1865260880 18.546 96 16 32 2 1879617008 9752528 4603600
19:26:39 34643 8192000000 10105533040 10504663040 1215665696 12.922 63 6 12 0 1224132592 7150128 1316768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 121 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          239266
MON$OLDEST_ACTIVE               239267
MON$OLDEST_SNAPSHOT             239267
MON$NEXT_TRANSACTION            239267
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                       2024384
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.33391 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33391 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33391 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33391 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 ---
:15: 
:16: mscs-test-161.budzdorov.ru    Wed Nov 18 19:27:25 2020
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Wed Nov 18 19:27:27 2020
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Wed Nov 18 19:27:31 2020
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
:27: 
:28: mscs-test-161.budzdorov.ru    Wed Nov 18 19:27:31 2020
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:30: 
:31: 
:32: mscs-test-161.budzdorov.ru    Wed Nov 18 19:27:31 2020
:33:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:34: 
:35: 
:36: mscs-test-161.budzdorov.ru    Wed Nov 18 19:27:31 2020
:37:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:38: 
--- end of diff output ---

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

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