pg_stat_monitor a lot of empty dublicates
General
Escalation
General
Escalation
Description
Environment
None
Attachments
2
- 29 Nov 2021, 09:36 PM
- 27 Sep 2021, 08:32 PM
Confluence content
Smart Checklist
Activity
Show:
naeem.akhter November 29, 2021 at 9:54 PMEdited
Only Anomaly in shared result is that there only total 3 calls (2+1=3) against queries like 'INSERT INTO t2 VALUES ********', where as there should be total 8 calls, just like in case of 'INSERT INTO t1 VALUES ********' (there are total, 1+4+3=8).
naeem.akhter November 29, 2021 at 9:36 PMEdited
I have done the verification regarding the duplicate queries, but I think we have a little confusion over what makes a query unique or distinct. So, just to clarify it, following are different columns/values that make up a key(primary/composite key) as a whole in PGSM, and that determines whether a query is unique or not.
bucket
queryid
userid
datname
client_ip
application_name
Verification of duplicates was done using following SQL script,
drop table if exists t1;
drop table if exists t2;
SELECT pg_stat_monitor_reset();
CREATE TABLE t1(a int);
CREATE TABLE t2(a int);
Set application_name = 'psql' ;
INSERT INTO t1 VALUES(generate_series(1,10));
ANALYZE t1;
SELECT count(*) FROM t1;
INSERT INTO t1 VALUES(generate_series(1,10000));
ANALYZE t1;
SELECT count(*) FROM t1;;
INSERT INTO t1 VALUES(generate_series(1,1000000));
ANALYZE t1;
SELECT count(*) FROM t1;
INSERT INTO t1 VALUES(generate_series(1,10000000));
ANALYZE t1;
SELECT count(*) FROM t1;
INSERT INTO t2 VALUES(generate_series(1,10));
ANALYZE t2;
SELECT count(*) FROM t2;
INSERT INTO t2 VALUES(generate_series(1,10000));
ANALYZE t2;
SELECT count(*) FROM t2;;
INSERT INTO t2 VALUES(generate_series(1,1000000));
ANALYZE t2;
SELECT count(*) FROM t2;
INSERT INTO t2 VALUES(generate_series(1,10000000));
ANALYZE t2;
SELECT count(*) FROM t2;
Set application_name = 'naeem' ;
INSERT INTO t1 VALUES(generate_series(1,10));
ANALYZE t1;
SELECT count(*) FROM t1;
INSERT INTO t1 VALUES(generate_series(1,10000));
ANALYZE t1;
SELECT count(*) FROM t1;
INSERT INTO t1 VALUES(generate_series(1,1000000));
ANALYZE t1;
SELECT count(*) FROM t1;
INSERT INTO t1 VALUES(generate_series(1,10000000));
ANALYZE t1;
SELECT count(*) FROM t1;
INSERT INTO t2 VALUES(generate_series(1,10));
ANALYZE t2;
SELECT count(*) FROM t2;
INSERT INTO t2 VALUES(generate_series(1,10000));
ANALYZE t2;
SELECT count(*) FROM t2;
INSERT INTO t2 VALUES(generate_series(1,1000000));
ANALYZE t2;
SELECT count(*) FROM t2;
INSERT INTO t2 VALUES(generate_series(1,10000000));
ANALYZE t2;
SELECT count(*) FROM t2;
Select bucket, queryid, userid, datname, client_ip, application_name, substr(query,0,50) as query,calls, total_exec_time,min_exec_time,max_exec_time,mean_exec_time, cmd_type_text, state from pg_stat_monitor order by query;No duplicates were found in the result! Screen shot of results (PG-230-2021-11-30-Naeem.png) has been uploaded into this ticket.
You might need to change following setting in postgresql.conf to reproduce same scenario.
pg_stat_monitor.pgsm_bucket_time=10
pg_stat_monitor.pgsm_query_shared_buffer=50Ibrar Ahmed November 26, 2021 at 12:38 PM
@naeem.akhter Please verify now, and update the complete ticket.
Vadim Tkachenko November 25, 2021 at 5:25 PM
after bulk loading data, I see just duplicate INSERTS
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, $7, $8, $9, $10 ),($11, $12, $13, $14, $15, $16, $17, $18, $19, $20 ),($21, $22, $23, $24, $25, $26, $27, $28, $29, $30 ),($31, $32, $33, $34, $35, $36, $37, $38, $39, $40 ),($41, $42, $43, $44, $45, $46, $47, $48, $49, $50 ),($51, $52, $53, $54, $55, $56, $57, $58, $59, $60 ),($61, $62, $63, $64, $65, $66, $67, $68, $69, $70 ),($71, $72, $73, $74, $75, $76, $77, $78, $79, $80 ),($81, $82, $83, $84, $85, $86, $87, $88, $89, $90 ),($91, $92, $93, $94, $95, $96, $97, $98, $99, $100 ),($101, $102, $103, $104, $105, $106, $107, $108, $109, $110 ),($111, $112, $113, $114, $115, $116, $117, $118, $119, $120 ),($121, $122, $123, $124, $125, $126, $127, $128, $129, $130 ),($131, $132, $133, $134, $135, $136, $137, $138, $139, $140 ),($141, $142, $143, $144, $145, $146, $147, $148, $149, $150 ),($151, $152, $153, $154, $155, $156, $15 |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 2
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, $7, $8, $9, $10 ),($11, $12, $13, $14, $15, $16, $17, $18, $19, $20 ),($21, $22, $23, $24, $25, $26, $27, $28, $29, $30 ),($31, $32, $33, $34, $35, $36, $37, $38, $39, $40 ),($41, $42, $43, $44, $45, $46, $47, $48, $49, $50 ),($51, $52, $53, $54, $55, $56, $57, $58, $59, $60 ),($61, $62, $63, $64, $65, $66, $67, $68, $69, $70 ),($71, $72, $73, $74, $75, $76, $77, $78, $79, $80 ),($81, $82, $83, $84, $85, $86, $87, $88, $89, $90 ),($91, $92, $93, $94, $95, $96, $97, $98, $99, $100 ),($101, $102, $103, $104, $105, $106, $107, $108, $109, $110 ),($111, $112, $113, $114, $115, $116, $117, $118, $119, $120 ),($121, $122, $123, $124, $125, $126, $127, $128, $129, $130 ),($131, $132, $133, $134, $135, $136, $137, $138, $139, $140 ),($141, $142, $143, $144, $145, $146, $147, $148, $149, $150 ),($151, $152, $153, $154, $155, $156, $15 |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, $7, $8, $9, $10 ),($11, $12, $13, $14, $15, $16, $17, $18, $19, $20 ),($21, $22, $23, $24, $25, $26, $27, $28, $29, $30 ),($31, $32, $33, $34, $35, $36, $37, $38, $39, $40 ),($41, $42, $43, $44, $45, $46, $47, $48, $49, $50 ),($51, $52, $53, $54, $55, $56, $57, $58, $59, $60 ),($61, $62, $63, $64, $65, $66, $67, $68, $69, $70 ),($71, $72, $73, $74, $75, $76, $77, $78, $79, $80 ),($81, $82, $83, $84, $85, $86, $87, $88, $89, $90 ),($91, $92, $93, $94, $95, $96, $97, $98, $99, $100 ),($101, $102, $103, $104, $105, $106, $107, $108, $109, $110 ),($111, $112, $113, $114, $115, $116, $117, $118, $119, $120 ),($121, $122, $123, $124, $125, $126, $127, $128, $129, $130 ),($131, $132, $133, $134, $135, $136, $137, $138, $139, $140 ),($141, $142, $143, $144, $145, $146, $147, $148, $149, $150 ),($151, $152, $153, $154, $155, $156, $15 |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 1
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, |
9 | 2021-11-25 12:19:00 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, +| 3
| | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139,
These lines are all identical and produced by identical INSERTS
Vadim Tkachenko November 25, 2021 at 4:46 PM
another example
select bucket, bucket_start_time, query,calls from pg_stat_monitor order by bucket desc;
8 | 2021-11-25 11:38:00 | SELECT c_discount, c_last, c_credit, w_tax +| 14645
| | FROM customer10, warehouse10 +|
| | WHERE w_id = 6 +|
| | AND c_w_id = w_id +|
| | AND c_d_id = 9 +|
| | AND c_id = 1228 |
Done
Details
Assignee
Diego FronzaDiego FronzaReporter
Vadim TkachenkoVadim TkachenkoLabels
Fix versions
Priority
Medium
Details
Details
Assignee
Diego Fronza
Diego FronzaReporter
Vadim Tkachenko
Vadim TkachenkoLabels
Fix versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created September 16, 2021 at 5:04 PM
Updated March 5, 2024 at 9:36 PM
Resolved September 29, 2021 at 1:13 PM
I load data under sysbench tpcc workload, and I see a lot of entries like
sbtest | 0 | 0 | 0 | 0 | INSERT INTO order_line2 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, + | | | | | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, sbtest | 0 | 0 | 0 | 0 | INSERT INTO order_line3 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, + | | | | | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, $7, $8, $9, $10 ),($11, $12, $13, $14, $15, $16, $17, $18, $19, $20 ),($21, $22, $23, $24, $25, $26, $27, $28, $29, $30 ),($31, $32, $33, $34, $35, $36, $37, $38, $39, $40 ),($41, $42, $43, $44, $45, $46, $47, $48, $49, $50 ),($51, $52, $53, $54, $55, $56, $57, $58, $59, $60 ),($61, $62, $63, $64, $65, $66, $67, $68, $69, $70 ),($71, $72, $73, $74, $75, $76, $77, $78, $79, $80 ),($81, $82, $83, $84, $85, $86, $87, $88, $89, $90 ),($91, $92, $93, $94, $95, $96, $97, $98, $99, $100 ),($101, $102, $103, $104, $105, $106, $107, $108, $109, $110 ),($111, $112, $113, $114, $115, $116, $117, $118, $119, $120 ),($121, $122, $123, $124, $125, $126, $127, $128, $129, $130 ),($131, $132, $133, $134, $135, $136, $137, $138, $139, $140 ),($141, $142, $143, $144, $145, $146, $147, $148, $149, $150 ),($151, $152, $153, $154, $155, $156, $15 sbtest | 0 | 0 | 0 | 0 | INSERT INTO order_line2 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, + | | | | | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, sbtest | 0 | 0 | 0 | 0 | INSERT INTO order_line2 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, + | | | | | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, sbtest | 0 | 0 | 0 | 0 | INSERT INTO order_line1 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, + | | | | | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139, sbtest | 0 | 0 | 0 | 0 | INSERT INTO order_line3 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_delivery_d, + | | | | | ol_quantity, ol_amount, ol_dist_info ) values($1, $2, $3, $4, $5, $6, NOW(), $7, $8, $9 ),($10, $11, $12, $13, $14, $15, NOW(), $16, $17, $18 ),($19, $20, $21, $22, $23, $24, NOW(), $25, $26, $27 ),($28, $29, $30, $31, $32, $33, NOW(), $34, $35, $36 ),($37, $38, $39, $40, $41, $42, NOW(), $43, $44, $45 ),($46, $47, $48, $49, $50, $51, NOW(), $52, $53, $54 ),($55, $56, $57, $58, $59, $60, NOW(), $61, $62, $63 ),($64, $65, $66, $67, $68, $69, NOW(), $70, $71, $72 ),($73, $74, $75, $76, $77, $78, NOW(), $79, $80, $81 ),($82, $83, $84, $85, $86, $87, NOW(), $88, $89, $90 ),($91, $92, $93, $94, $95, $96, NOW(), $97, $98, $99 ),($100, $101, $102, $103, $104, $105, NOW(), $106, $107, $108 ),($109, $110, $111, $112, $113, $114, NOW(), $115, $116, $117 ),($118, $119, $120, $121, $122, $123, NOW(), $124, $125, $126 ),($127, $128, $129, $130, $131, $132, NOW(), $133, $134, $135 ),($136, $137, $138, $139,it seems:
There are a lot of duplicate entries ( I do not show the full output, it is huge)
INSERT queries have 0 time entries