Worst wikidata query
ActivePublic
Actions

Authored by jcrespo on Mar 3 2020, 2:40 PM.

Tags

None

Referenced Files

	F31659868: raw.txt
	Mar 3 2020, 2:40 PM

Subscribers

None

	root@db1126[sys]> select * FROM statement_analysis where digest = '81ad7906a006b7e1006791ae3930b533'\G
	************************* 1. row *************************
	query: SELECT `wbtl_id` , `wbtl_type_ ... ` = ? AND `wbxl_language` = ?
	==
	SELECT `wbtl_id` , `wbtl_type_id` , `wbxl_language` , `wbx_text` , `wbit_item_id`
	FROM SELECT `wbtl_id` , `wbtl_type_id` , `wbxl_language` , `wbx_text` , `wbit_item_id`
	WHERE ( `wbtl_text_in_lang_id` = `wbxl_id` ) AND ( `wbxl_text_id` = `wbx_id` ) AND `wbit_item_id` IN (...) AND ( `wbit_term_in_lang_id` = `wbtl_id` ) AND `wbtl_type_id` = ? AND `wbxl_language` = ?;
	==
	db: wikidatawiki
	full_scan:
	exec_count: 138666251
	err_count: 0
	warn_count: 0
	total_latency: 6.14 w
	max_latency: 14.55 s
	avg_latency: 26.79 ms
	lock_latency: 2.43 h
	rows_sent: 856716069
	rows_sent_avg: 6
	rows_examined: 273967143155
	rows_examined_avg: 1976
	rows_affected: 0
	rows_affected_avg: 0
	tmp_tables: 0
	tmp_disk_tables: 0
	rows_sorted: 0
	sort_merge_passes: 0
	digest: 81ad7906a006b7e1006791ae3930b533
	first_seen: 2020-02-25 14:34:56
	last_seen: 2020-03-03 14:38:59
	1 row in set (0.03 sec)

Worst wikidata queryActivePublicActions