# 440ms user time, 110ms system time, 30.42M rss, 4.11G vsz # Current date: Thu Jan 31 14:22:53 2019 # Overall: 200 total, 54 unique, 0.00 QPS, 6.51x concurrency _____________ # Time range: 2019-01-28 23:34:26 to 2019-01-31 00:54:41 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 1157073s 1s 62920s 5785s 58098s 15420s 21s # Lock time 483s 24us 54s 2s 21s 8s 1ms # Rows sent 27.51k 0 13.10k 140.88 24.84 1.24k 0.99 # Rows examine 14.59M 0 440.79k 74.71k 380.41k 112.46k 2.76k # Query size 663.41k 69 7.34k 3.32k 6.96k 2.43k 3.35k # Profile # Rank Query ID Response time Calls R/Call V/M # ==== ============================ ================= ===== ========== === # 1 0x2718AFB3E91A5749FFC976D... 308700.2355 26.7% 6 51450.0393 96... SELECT node node_field_data node__field_date_time node_field_data node__field_text_content node__field_text_intro node__field_text_teaser node__field_event_tags taxonomy_term_data taxonomy_term_field_data node__field_location node node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data node_field_data node__field_event_tags taxonomy_term_data taxonomy_term_field_data node_field_data node__field_location node node_field_data node__field_event_audience taxonomy_term_data taxonomy_term_field_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data taxonomy_term_field_data node_field_data node__field_date_time # 2 0xEDE544B5350E00B887A3210... 308697.0470 26.7% 6 51449.5078 96... SELECT node node_field_data node__field_date_time node_field_data node__field_text_content node__field_text_intro node__field_text_teaser node__field_event_tags taxonomy_term_data taxonomy_term_field_data node__field_location node node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data node_field_data node__field_event_tags taxonomy_term_data taxonomy_term_field_data node_field_data node__field_location node node_field_data node__field_event_audience taxonomy_term_data taxonomy_term_field_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data taxonomy_term_field_data node_field_data node__field_date_time # 3 0x215FB65C5130DB26C9E1431... 135166.7492 11.7% 14 9654.7678 45... SELECT node node_field_data node__field_date_time node__field_location node node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data node_field_data node__field_location node node_field_data node__field_event_audience taxonomy_term_data taxonomy_term_field_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data taxonomy_term_field_data node_field_data node__field_date_time # 4 0x4D637A9008CE8139BEA92A4... 83724.6809 7.2% 15 5581.6454 23... SELECT node node_field_data node__field_date_time node__field_event_type taxonomy_term_data node__field_location node node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data node_field_data node__field_event_type taxonomy_term_data taxonomy_term_field_data node_field_data node__field_location node node_field_data node__field_event_audience taxonomy_term_data taxonomy_term_field_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data taxonomy_term_field_data node_field_data node__field_date_time # 5 0x00ECDE02799A69009EAAE73... 58538.6009 5.1% 1 58538.6009 0.00 SELECT node node_field_data node__field_date_time node_field_data node__field_text_content node__field_text_intro node__field_text_teaser node__field_event_tags taxonomy_term_data taxonomy_term_field_data node__field_event_type taxonomy_term_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data node_field_data node__field_event_tags taxonomy_term_data taxonomy_term_field_data node_field_data node__field_event_type taxonomy_term_data taxonomy_term_field_data node_field_data node__field_event_audience taxonomy_term_data taxonomy_term_field_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data taxonomy_term_field_data node_field_data node__field_date_time # 6 0x08EE574409B2CFA6481F40A... 58200.6523 5.0% 1 58200.6523 0.00 SELECT node node_field_data node__field_date_time node_field_data node__field_text_content node__field_text_intro node__field_text_teaser node__field_event_tags taxonomy_term_data taxonomy_term_field_data node__field_event_type taxonomy_term_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data node_field_data node__field_event_tags taxonomy_term_data taxonomy_term_field_data node_field_data node__field_event_type taxonomy_term_data taxonomy_term_field_data node_field_data node__field_event_audience taxonomy_term_data taxonomy_term_field_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data taxonomy_term_field_data node_field_data node__field_date_time # 7 0xAF6A939F7E5E5CE3666DD61... 49716.8555 4.3% 1 49716.8555 0.00 SELECT node node_field_data node__field_date_time node_field_data node__field_text_content node__field_text_intro node__field_text_teaser node__field_event_tags taxonomy_term_data taxonomy_term_field_data node__field_event_type taxonomy_term_data node__field_location node node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data node_field_data node__field_event_tags taxonomy_term_data taxonomy_term_field_data node_field_data node__field_event_type taxonomy_term_data taxonomy_term_field_data node_field_data node__field_location node node_field_data node__field_event_audience taxonomy_term_data taxonomy_term_field_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data taxonomy_term_field_data node_field_data node__field_date_time # 8 0x1BB6231D635A40064FF147B... 49716.0636 4.3% 1 49716.0636 0.00 SELECT node node_field_data node__field_date_time node_field_data node__field_text_content node__field_text_intro node__field_text_teaser node__field_event_tags taxonomy_term_data taxonomy_term_field_data node__field_event_type taxonomy_term_data node__field_location node node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data node_field_data node__field_event_tags taxonomy_term_data taxonomy_term_field_data node_field_data node__field_event_type taxonomy_term_data taxonomy_term_field_data node_field_data node__field_location node node_field_data node__field_event_audience taxonomy_term_data taxonomy_term_field_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data taxonomy_term_field_data node_field_data node__field_date_time # 9 0x17B4216B9DCB3C1A380DA15... 49714.5379 4.3% 1 49714.5379 0.00 SELECT node node_field_data node__field_date_time node_field_data node__field_text_content node__field_text_intro node__field_text_teaser node__field_event_tags taxonomy_term_data taxonomy_term_field_data node__field_event_type taxonomy_term_data node__field_location node node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data node_field_data node__field_event_tags taxonomy_term_data taxonomy_term_field_data node_field_data node__field_event_type taxonomy_term_data taxonomy_term_field_data node_field_data node__field_location node node_field_data node__field_event_audience taxonomy_term_data taxonomy_term_field_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data taxonomy_term_field_data node_field_data node__field_date_time # 12 0xA9C1951A2F2881CE3C22CE5... 1386.3662 0.1% 11 126.0333 14.88 SELECT node node_field_data node__field_date_time node__field_event_type taxonomy_term_data node__field_location node node_field_data node__field_event_type taxonomy_term_data taxonomy_term_field_data node_field_data node__field_location node node_field_data node__field_date_time # 15 0xE0D6F25528DAFD731351139... 681.0624 0.1% 40 17.0266 16.30 DELETE polaris_search_data # 18 0xC071E786F6A6672AE5C4B91... 45.5653 0.0% 15 3.0377 0.11 SELECT watchdog # 20 0xF4C59915DDFA01C23231338... 21.1269 0.0% 18 1.1737 0.04 SELECT node node_field_data node__field_date_time node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data node_field_data node__field_event_audience taxonomy_term_data taxonomy_term_field_data node__field_event_audience taxonomy_term_data taxonomy_term__parent taxonomy_term_data taxonomy_term_field_data node_field_data node__field_date_time # MISC 0xMISC 52763.5830 4.6% 70 753.7655 0.0 <41 ITEMS> # Query 1: 0.00 QPS, 4.91x concurrency, ID 0x2718AFB3E91A5749FFC976DB661544D5 at byte 599981 # This item is included in the report because it matches --limit. # Scores: V/M = 9624.08 # Time range: 2019-01-30 05:25:34 to 22:54:21 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 6 # Exec time 26 308700s 242s 62920s 51450s 61003s 22252s 61003s # Lock time 0 33ms 1ms 24ms 6ms 23ms 8ms 3ms # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 5 37.11k 6.18k 6.18k 6.18k 6.18k 0 6.18k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_content'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_content`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_intro'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_intro`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_teaser'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_teaser`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_tags'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_tags`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_location'\G # SHOW CREATE TABLE `pantheon`.`node__field_location`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_audience'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_audience`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term__parent'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term__parent`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid LEFT JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid LEFT JOIN node__field_text_content node__field_text_content ON node__field_text_content.entity_id = base_table.nid LEFT JOIN node__field_text_intro node__field_text_intro ON node__field_text_intro.entity_id = base_table.nid LEFT JOIN node__field_text_teaser node__field_text_teaser ON node__field_text_teaser.entity_id = base_table.nid LEFT JOIN node__field_event_tags node__field_event_tags ON node__field_event_tags.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_tags.field_event_tags_target_id LEFT JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data.tid INNER JOIN node__field_location node__field_location ON node__field_location.entity_id = base_table.nid LEFT OUTER JOIN node node ON node.nid = node__field_location.field_location_target_id INNER JOIN node node_2 ON node_2.nid = node.nid LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = taxonomy_term_data_2.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_4 ON taxonomy_term_data_4.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_4.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_5 ON taxonomy_term_data_5.tid = taxonomy_term__parent.parent_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_6 ON taxonomy_term_data_6.tid = taxonomy_term_data_5.tid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = base_table.nid INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = base_table.nid INNER JOIN node_field_data node_field_data_6 ON node_field_data_6.nid = base_table.nid INNER JOIN node_field_data node_field_data_7 ON node_field_data_7.nid = base_table.nid INNER JOIN node_field_data node_field_data_8 ON node_field_data_8.nid = base_table.nid INNER JOIN node__field_event_tags node__field_event_tags_2 ON node__field_event_tags_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_7 ON taxonomy_term_data_7.tid = node__field_event_tags_2.field_event_tags_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_2 ON taxonomy_term_field_data_2.tid = taxonomy_term_data_7.tid INNER JOIN node_field_data node_field_data_9 ON node_field_data_9.nid = base_table.nid INNER JOIN node__field_location node__field_location_2 ON node__field_location_2.entity_id = base_table.nid LEFT OUTER JOIN node node_3 ON node_3.nid = node__field_location_2.field_location_target_id INNER JOIN node_field_data node_field_data_10 ON node_field_data_10.nid = node_3.nid INNER JOIN node_field_data node_field_data_11 ON node_field_data_11.nid = base_table.nid INNER JOIN node__field_event_audience node__field_event_audience_2 ON node__field_event_audience_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_8 ON taxonomy_term_data_8.tid = node__field_event_audience_2.field_event_audience_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_3 ON taxonomy_term_field_data_3.tid = taxonomy_term_data_8.tid INNER JOIN node__field_event_audience node__field_event_audience_3 ON node__field_event_audience_3.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_9 ON taxonomy_term_data_9.tid = node__field_event_audience_3.field_event_audience_target_id INNER JOIN taxonomy_term__parent taxonomy_term__parent_2 ON taxonomy_term__parent_2.entity_id = taxonomy_term_data_9.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_10 ON taxonomy_term_data_10.tid = taxonomy_term__parent_2.parent_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_4 ON taxonomy_term_field_data_4.tid = taxonomy_term_data_10.tid INNER JOIN node_field_data node_field_data_12 ON node_field_data_12.nid = base_table.nid INNER JOIN node_field_data node_field_data_13 ON node_field_data_13.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and ((node_field_data_2.title LIKE '%sew%' ESCAPE '\\') or (node__field_text_content.field_text_content_value LIKE '%sew%' ESCAPE '\\') or (node__field_text_intro.field_text_intro_value LIKE '%sew%' ESCAPE '\\') or (node__field_text_teaser.field_text_teaser_value LIKE '%sew%' ESCAPE '\\') or (taxonomy_term_field_data.name LIKE '%sew%' ESCAPE '\\')) and (node_2.uuid IN ('1c28abaa-f088-404f-925f-263838332601', 'ce465283-9203-49da-a342-5ff62af65c31', '2f900166-5d6e-4f46-a87a-916b4eacff16', '4ced26ce-f316-40be-8988-5a0776fce65e')) and ((taxonomy_term_data_3.uuid IN ('96887d69-800d-4e91-b434-d3d5167985d3')) or (taxonomy_term_data_6.uuid IN ('96887d69-800d-4e91-b434-d3d5167985d3')))) AND (node_field_data_3.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.status = '1') AND (node_field_data_6.status = '1') AND (node_field_data_7.status = '1') AND (node_field_data_8.status = '1') AND (taxonomy_term_field_data_2.status = '1') AND (node_field_data_9.status = '1') AND (node_field_data_10.status = '1') AND (node_field_data_11.status = '1') AND (taxonomy_term_field_data_3.status = '1') AND (taxonomy_term_field_data_4.status = '1') AND (node_field_data_12.status = '1') AND (node_field_data_13.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G # Query 2: 0.00 QPS, 4.91x concurrency, ID 0xEDE544B5350E00B887A3210A7E7DC177 at byte 606517 # This item is included in the report because it matches --limit. # Scores: V/M = 9624.18 # Time range: 2019-01-30 05:25:34 to 22:54:21 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 6 # Exec time 26 308697s 242s 62920s 51450s 61003s 22252s 61003s # Lock time 0 29ms 1ms 23ms 5ms 22ms 8ms 1ms # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 5 37.05k 6.17k 6.17k 6.17k 6.17k 0 6.17k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_content'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_content`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_intro'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_intro`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_teaser'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_teaser`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_tags'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_tags`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_location'\G # SHOW CREATE TABLE `pantheon`.`node__field_location`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_audience'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_audience`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term__parent'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term__parent`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid LEFT JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid LEFT JOIN node__field_text_content node__field_text_content ON node__field_text_content.entity_id = base_table.nid LEFT JOIN node__field_text_intro node__field_text_intro ON node__field_text_intro.entity_id = base_table.nid LEFT JOIN node__field_text_teaser node__field_text_teaser ON node__field_text_teaser.entity_id = base_table.nid LEFT JOIN node__field_event_tags node__field_event_tags ON node__field_event_tags.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_tags.field_event_tags_target_id LEFT JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data.tid INNER JOIN node__field_location node__field_location ON node__field_location.entity_id = base_table.nid LEFT OUTER JOIN node node ON node.nid = node__field_location.field_location_target_id INNER JOIN node node_2 ON node_2.nid = node.nid LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = taxonomy_term_data_2.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_4 ON taxonomy_term_data_4.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_4.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_5 ON taxonomy_term_data_5.tid = taxonomy_term__parent.parent_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_6 ON taxonomy_term_data_6.tid = taxonomy_term_data_5.tid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = base_table.nid INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = base_table.nid INNER JOIN node_field_data node_field_data_6 ON node_field_data_6.nid = base_table.nid INNER JOIN node_field_data node_field_data_7 ON node_field_data_7.nid = base_table.nid INNER JOIN node_field_data node_field_data_8 ON node_field_data_8.nid = base_table.nid INNER JOIN node__field_event_tags node__field_event_tags_2 ON node__field_event_tags_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_7 ON taxonomy_term_data_7.tid = node__field_event_tags_2.field_event_tags_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_2 ON taxonomy_term_field_data_2.tid = taxonomy_term_data_7.tid INNER JOIN node_field_data node_field_data_9 ON node_field_data_9.nid = base_table.nid INNER JOIN node__field_location node__field_location_2 ON node__field_location_2.entity_id = base_table.nid LEFT OUTER JOIN node node_3 ON node_3.nid = node__field_location_2.field_location_target_id INNER JOIN node_field_data node_field_data_10 ON node_field_data_10.nid = node_3.nid INNER JOIN node_field_data node_field_data_11 ON node_field_data_11.nid = base_table.nid INNER JOIN node__field_event_audience node__field_event_audience_2 ON node__field_event_audience_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_8 ON taxonomy_term_data_8.tid = node__field_event_audience_2.field_event_audience_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_3 ON taxonomy_term_field_data_3.tid = taxonomy_term_data_8.tid INNER JOIN node__field_event_audience node__field_event_audience_3 ON node__field_event_audience_3.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_9 ON taxonomy_term_data_9.tid = node__field_event_audience_3.field_event_audience_target_id INNER JOIN taxonomy_term__parent taxonomy_term__parent_2 ON taxonomy_term__parent_2.entity_id = taxonomy_term_data_9.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_10 ON taxonomy_term_data_10.tid = taxonomy_term__parent_2.parent_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_4 ON taxonomy_term_field_data_4.tid = taxonomy_term_data_10.tid INNER JOIN node_field_data node_field_data_12 ON node_field_data_12.nid = base_table.nid INNER JOIN node_field_data node_field_data_13 ON node_field_data_13.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and ((node_field_data_2.title LIKE '%s%' ESCAPE '\\') or (node__field_text_content.field_text_content_value LIKE '%s%' ESCAPE '\\') or (node__field_text_intro.field_text_intro_value LIKE '%s%' ESCAPE '\\') or (node__field_text_teaser.field_text_teaser_value LIKE '%s%' ESCAPE '\\') or (taxonomy_term_field_data.name LIKE '%s%' ESCAPE '\\')) and (node_2.uuid IN ('1c28abaa-f088-404f-925f-263838332601', 'ce465283-9203-49da-a342-5ff62af65c31', '2f900166-5d6e-4f46-a87a-916b4eacff16', '4ced26ce-f316-40be-8988-5a0776fce65e')) and ((taxonomy_term_data_3.uuid IN ('96887d69-800d-4e91-b434-d3d5167985d3')) or (taxonomy_term_data_6.uuid IN ('96887d69-800d-4e91-b434-d3d5167985d3')))) AND (node_field_data_3.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.status = '1') AND (node_field_data_6.status = '1') AND (node_field_data_7.status = '1') AND (node_field_data_8.status = '1') AND (taxonomy_term_field_data_2.status = '1') AND (node_field_data_9.status = '1') AND (node_field_data_10.status = '1') AND (node_field_data_11.status = '1') AND (taxonomy_term_field_data_3.status = '1') AND (taxonomy_term_field_data_4.status = '1') AND (node_field_data_12.status = '1') AND (node_field_data_13.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G # Query 3: 0.00 QPS, 1.97x concurrency, ID 0x215FB65C5130DB26C9E1431A5928D7CC at byte 265020 # This item is included in the report because it matches --limit. # Scores: V/M = 4571.08 # Time range: 2019-01-30 05:25:34 to 2019-01-31 00:29:25 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 7 14 # Exec time 11 135167s 245s 18248s 9655s 18014s 6643s 6158s # Lock time 0 46ms 624us 24ms 3ms 6ms 6ms 1ms # Rows sent 0 72 0 11 5.14 10.84 4.33 6.98 # Rows examine 0 28.83k 0 5.43k 2.06k 4.27k 1.71k 2.76k # Query size 8 56.51k 3.92k 4.23k 4.04k 4.07k 89.67 3.88k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_location'\G # SHOW CREATE TABLE `pantheon`.`node__field_location`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_audience'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_audience`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term__parent'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term__parent`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid INNER JOIN node__field_location node__field_location ON node__field_location.entity_id = base_table.nid LEFT OUTER JOIN node node ON node.nid = node__field_location.field_location_target_id INNER JOIN node node_2 ON node_2.nid = node.nid LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = taxonomy_term_data.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_3.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_4 ON taxonomy_term_data_4.tid = taxonomy_term__parent.parent_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_5 ON taxonomy_term_data_5.tid = taxonomy_term_data_4.tid INNER JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node__field_location node__field_location_2 ON node__field_location_2.entity_id = base_table.nid LEFT OUTER JOIN node node_3 ON node_3.nid = node__field_location_2.field_location_target_id INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = node_3.nid INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = base_table.nid INNER JOIN node__field_event_audience node__field_event_audience_2 ON node__field_event_audience_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_6 ON taxonomy_term_data_6.tid = node__field_event_audience_2.field_event_audience_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data_6.tid INNER JOIN node__field_event_audience node__field_event_audience_3 ON node__field_event_audience_3.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_7 ON taxonomy_term_data_7.tid = node__field_event_audience_3.field_event_audience_target_id INNER JOIN taxonomy_term__parent taxonomy_term__parent_2 ON taxonomy_term__parent_2.entity_id = taxonomy_term_data_7.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_8 ON taxonomy_term_data_8.tid = taxonomy_term__parent_2.parent_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_2 ON taxonomy_term_field_data_2.tid = taxonomy_term_data_8.tid INNER JOIN node_field_data node_field_data_6 ON node_field_data_6.nid = base_table.nid INNER JOIN node_field_data node_field_data_7 ON node_field_data_7.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and (node_2.uuid IN ('1c28abaa-f088-404f-925f-263838332601', 'ce465283-9203-49da-a342-5ff62af65c31')) and ((taxonomy_term_data_2.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')) or (taxonomy_term_data_5.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')))) AND (node_field_data_2.status = '1') AND (node_field_data_3.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.status = '1') AND (taxonomy_term_field_data.status = '1') AND (taxonomy_term_field_data_2.status = '1') AND (node_field_data_6.status = '1') AND (node_field_data_7.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G # Query 4: 0.00 QPS, 1.33x concurrency, ID 0x4D637A9008CE8139BEA92A4ADE60E49E at byte 528407 # This item is included in the report because it matches --limit. # Scores: V/M = 23341.76 # Time range: 2019-01-30 05:25:34 to 22:54:21 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 7 15 # Exec time 7 83725s 639s 49718s 5582s 4377s 11414s 2108s # Lock time 0 27ms 1ms 4ms 2ms 2ms 644us 2ms # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 12 85.56k 4.95k 6.87k 5.70k 6.63k 744.61 5.46k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_type'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_type`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_location'\G # SHOW CREATE TABLE `pantheon`.`node__field_location`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_audience'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_audience`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term__parent'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term__parent`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid INNER JOIN node__field_event_type node__field_event_type ON node__field_event_type.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_type.field_event_type_target_id INNER JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = taxonomy_term_data.tid INNER JOIN node__field_location node__field_location ON node__field_location.entity_id = base_table.nid LEFT OUTER JOIN node node ON node.nid = node__field_location.field_location_target_id INNER JOIN node node_2 ON node_2.nid = node.nid LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_4 ON taxonomy_term_data_4.tid = taxonomy_term_data_3.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_5 ON taxonomy_term_data_5.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_5.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_6 ON taxonomy_term_data_6.tid = taxonomy_term__parent.parent_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_7 ON taxonomy_term_data_7.tid = taxonomy_term_data_6.tid INNER JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node__field_event_type node__field_event_type_2 ON node__field_event_type_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_8 ON taxonomy_term_data_8.tid = node__field_event_type_2.field_event_type_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data_8.tid INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = base_table.nid INNER JOIN node__field_location node__field_location_2 ON node__field_location_2.entity_id = base_table.nid LEFT OUTER JOIN node node_3 ON node_3.nid = node__field_location_2.field_location_target_id INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = node_3.nid INNER JOIN node_field_data node_field_data_6 ON node_field_data_6.nid = base_table.nid INNER JOIN node__field_event_audience node__field_event_audience_2 ON node__field_event_audience_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_9 ON taxonomy_term_data_9.tid = node__field_event_audience_2.field_event_audience_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_2 ON taxonomy_term_field_data_2.tid = taxonomy_term_data_9.tid INNER JOIN node__field_event_audience node__field_event_audience_3 ON node__field_event_audience_3.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_10 ON taxonomy_term_data_10.tid = node__field_event_audience_3.field_event_audience_target_id INNER JOIN taxonomy_term__parent taxonomy_term__parent_2 ON taxonomy_term__parent_2.entity_id = taxonomy_term_data_10.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_11 ON taxonomy_term_data_11.tid = taxonomy_term__parent_2.parent_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_3 ON taxonomy_term_field_data_3.tid = taxonomy_term_data_11.tid INNER JOIN node_field_data node_field_data_7 ON node_field_data_7.nid = base_table.nid INNER JOIN node_field_data node_field_data_8 ON node_field_data_8.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and (taxonomy_term_data_2.uuid IN ('ad4a46da-4752-4f58-a44c-fb628c13aa75')) and (node_2.uuid IN ('1c28abaa-f088-404f-925f-263838332601', 'ce465283-9203-49da-a342-5ff62af65c31', '2f900166-5d6e-4f46-a87a-916b4eacff16')) and ((taxonomy_term_data_4.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')) or (taxonomy_term_data_7.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')))) AND (node_field_data_2.status = '1') AND (node_field_data_3.status = '1') AND (taxonomy_term_field_data.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.status = '1') AND (node_field_data_6.status = '1') AND (taxonomy_term_field_data_2.status = '1') AND (taxonomy_term_field_data_3.status = '1') AND (node_field_data_7.status = '1') AND (node_field_data_8.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G # Query 5: 0 QPS, 0x concurrency, ID 0x00ECDE02799A69009EAAE7331C887AB0 at byte 540842 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2019-01-30 22:54:21 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 1 # Exec time 5 58539s 58539s 58539s 58539s 58539s 0 58539s # Lock time 0 2ms 2ms 2ms 2ms 2ms 0 2ms # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 6.52k 6.52k 6.52k 6.52k 6.52k 0 6.52k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_content'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_content`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_intro'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_intro`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_teaser'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_teaser`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_tags'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_tags`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_type'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_type`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_audience'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_audience`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term__parent'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term__parent`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid LEFT JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid LEFT JOIN node__field_text_content node__field_text_content ON node__field_text_content.entity_id = base_table.nid LEFT JOIN node__field_text_intro node__field_text_intro ON node__field_text_intro.entity_id = base_table.nid LEFT JOIN node__field_text_teaser node__field_text_teaser ON node__field_text_teaser.entity_id = base_table.nid LEFT JOIN node__field_event_tags node__field_event_tags ON node__field_event_tags.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_tags.field_event_tags_target_id LEFT JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data.tid INNER JOIN node__field_event_type node__field_event_type ON node__field_event_type.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = node__field_event_type.field_event_type_target_id INNER JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = taxonomy_term_data_2.tid LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_4 ON taxonomy_term_data_4.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_5 ON taxonomy_term_data_5.tid = taxonomy_term_data_4.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_6 ON taxonomy_term_data_6.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_6.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_7 ON taxonomy_term_data_7.tid = taxonomy_term__parent.parent_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_8 ON taxonomy_term_data_8.tid = taxonomy_term_data_7.tid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = base_table.nid INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = base_table.nid INNER JOIN node_field_data node_field_data_6 ON node_field_data_6.nid = base_table.nid INNER JOIN node_field_data node_field_data_7 ON node_field_data_7.nid = base_table.nid INNER JOIN node_field_data node_field_data_8 ON node_field_data_8.nid = base_table.nid INNER JOIN node__field_event_tags node__field_event_tags_2 ON node__field_event_tags_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_9 ON taxonomy_term_data_9.tid = node__field_event_tags_2.field_event_tags_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_2 ON taxonomy_term_field_data_2.tid = taxonomy_term_data_9.tid INNER JOIN node_field_data node_field_data_9 ON node_field_data_9.nid = base_table.nid INNER JOIN node__field_event_type node__field_event_type_2 ON node__field_event_type_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_10 ON taxonomy_term_data_10.tid = node__field_event_type_2.field_event_type_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_3 ON taxonomy_term_field_data_3.tid = taxonomy_term_data_10.tid INNER JOIN node_field_data node_field_data_10 ON node_field_data_10.nid = base_table.nid INNER JOIN node__field_event_audience node__field_event_audience_2 ON node__field_event_audience_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_11 ON taxonomy_term_data_11.tid = node__field_event_audience_2.field_event_audience_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_4 ON taxonomy_term_field_data_4.tid = taxonomy_term_data_11.tid INNER JOIN node__field_event_audience node__field_event_audience_3 ON node__field_event_audience_3.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_12 ON taxonomy_term_data_12.tid = node__field_event_audience_3.field_event_audience_target_id INNER JOIN taxonomy_term__parent taxonomy_term__parent_2 ON taxonomy_term__parent_2.entity_id = taxonomy_term_data_12.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_13 ON taxonomy_term_data_13.tid = taxonomy_term__parent_2.parent_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_5 ON taxonomy_term_field_data_5.tid = taxonomy_term_data_13.tid INNER JOIN node_field_data node_field_data_11 ON node_field_data_11.nid = base_table.nid INNER JOIN node_field_data node_field_data_12 ON node_field_data_12.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and ((node_field_data_2.title LIKE '%s%' ESCAPE '\\') or (node__field_text_content.field_text_content_value LIKE '%s%' ESCAPE '\\') or (node__field_text_intro.field_text_intro_value LIKE '%s%' ESCAPE '\\') or (node__field_text_teaser.field_text_teaser_value LIKE '%s%' ESCAPE '\\') or (taxonomy_term_field_data.name LIKE '%s%' ESCAPE '\\')) and (taxonomy_term_data_3.uuid IN ('ad4a46da-4752-4f58-a44c-fb628c13aa75')) and ((taxonomy_term_data_5.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')) or (taxonomy_term_data_8.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')))) AND (node_field_data_3.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.status = '1') AND (node_field_data_6.status = '1') AND (node_field_data_7.status = '1') AND (node_field_data_8.status = '1') AND (taxonomy_term_field_data_2.status = '1') AND (node_field_data_9.status = '1') AND (taxonomy_term_field_data_3.status = '1') AND (node_field_data_10.status = '1') AND (taxonomy_term_field_data_4.status = '1') AND (taxonomy_term_field_data_5.status = '1') AND (node_field_data_11.status = '1') AND (node_field_data_12.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G # Query 6: 0 QPS, 0x concurrency, ID 0x08EE574409B2CFA6481F40A960AC41E5 at byte 533949 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2019-01-30 22:54:21 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 1 # Exec time 5 58201s 58201s 58201s 58201s 58201s 0 58201s # Lock time 0 2ms 2ms 2ms 2ms 2ms 0 2ms # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 6.53k 6.53k 6.53k 6.53k 6.53k 0 6.53k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_content'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_content`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_intro'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_intro`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_teaser'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_teaser`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_tags'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_tags`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_type'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_type`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_audience'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_audience`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term__parent'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term__parent`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid LEFT JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid LEFT JOIN node__field_text_content node__field_text_content ON node__field_text_content.entity_id = base_table.nid LEFT JOIN node__field_text_intro node__field_text_intro ON node__field_text_intro.entity_id = base_table.nid LEFT JOIN node__field_text_teaser node__field_text_teaser ON node__field_text_teaser.entity_id = base_table.nid LEFT JOIN node__field_event_tags node__field_event_tags ON node__field_event_tags.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_tags.field_event_tags_target_id LEFT JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data.tid INNER JOIN node__field_event_type node__field_event_type ON node__field_event_type.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = node__field_event_type.field_event_type_target_id INNER JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = taxonomy_term_data_2.tid LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_4 ON taxonomy_term_data_4.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_5 ON taxonomy_term_data_5.tid = taxonomy_term_data_4.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_6 ON taxonomy_term_data_6.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_6.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_7 ON taxonomy_term_data_7.tid = taxonomy_term__parent.parent_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_8 ON taxonomy_term_data_8.tid = taxonomy_term_data_7.tid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = base_table.nid INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = base_table.nid INNER JOIN node_field_data node_field_data_6 ON node_field_data_6.nid = base_table.nid INNER JOIN node_field_data node_field_data_7 ON node_field_data_7.nid = base_table.nid INNER JOIN node_field_data node_field_data_8 ON node_field_data_8.nid = base_table.nid INNER JOIN node__field_event_tags node__field_event_tags_2 ON node__field_event_tags_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_9 ON taxonomy_term_data_9.tid = node__field_event_tags_2.field_event_tags_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_2 ON taxonomy_term_field_data_2.tid = taxonomy_term_data_9.tid INNER JOIN node_field_data node_field_data_9 ON node_field_data_9.nid = base_table.nid INNER JOIN node__field_event_type node__field_event_type_2 ON node__field_event_type_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_10 ON taxonomy_term_data_10.tid = node__field_event_type_2.field_event_type_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_3 ON taxonomy_term_field_data_3.tid = taxonomy_term_data_10.tid INNER JOIN node_field_data node_field_data_10 ON node_field_data_10.nid = base_table.nid INNER JOIN node__field_event_audience node__field_event_audience_2 ON node__field_event_audience_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_11 ON taxonomy_term_data_11.tid = node__field_event_audience_2.field_event_audience_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_4 ON taxonomy_term_field_data_4.tid = taxonomy_term_data_11.tid INNER JOIN node__field_event_audience node__field_event_audience_3 ON node__field_event_audience_3.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_12 ON taxonomy_term_data_12.tid = node__field_event_audience_3.field_event_audience_target_id INNER JOIN taxonomy_term__parent taxonomy_term__parent_2 ON taxonomy_term__parent_2.entity_id = taxonomy_term_data_12.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_13 ON taxonomy_term_data_13.tid = taxonomy_term__parent_2.parent_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_5 ON taxonomy_term_field_data_5.tid = taxonomy_term_data_13.tid INNER JOIN node_field_data node_field_data_11 ON node_field_data_11.nid = base_table.nid INNER JOIN node_field_data node_field_data_12 ON node_field_data_12.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and ((node_field_data_2.title LIKE '%sew%' ESCAPE '\\') or (node__field_text_content.field_text_content_value LIKE '%sew%' ESCAPE '\\') or (node__field_text_intro.field_text_intro_value LIKE '%sew%' ESCAPE '\\') or (node__field_text_teaser.field_text_teaser_value LIKE '%sew%' ESCAPE '\\') or (taxonomy_term_field_data.name LIKE '%sew%' ESCAPE '\\')) and (taxonomy_term_data_3.uuid IN ('ad4a46da-4752-4f58-a44c-fb628c13aa75')) and ((taxonomy_term_data_5.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')) or (taxonomy_term_data_8.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')))) AND (node_field_data_3.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.status = '1') AND (node_field_data_6.status = '1') AND (node_field_data_7.status = '1') AND (node_field_data_8.status = '1') AND (taxonomy_term_field_data_2.status = '1') AND (node_field_data_9.status = '1') AND (taxonomy_term_field_data_3.status = '1') AND (node_field_data_10.status = '1') AND (taxonomy_term_field_data_4.status = '1') AND (taxonomy_term_field_data_5.status = '1') AND (node_field_data_11.status = '1') AND (node_field_data_12.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G # Query 7: 0 QPS, 0x concurrency, ID 0xAF6A939F7E5E5CE3666DD616D0254D6E at byte 520693 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2019-01-30 22:54:20 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 1 # Exec time 4 49717s 49717s 49717s 49717s 49717s 0 49717s # Lock time 0 4ms 4ms 4ms 4ms 4ms 0 4ms # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 1 7.33k 7.33k 7.33k 7.33k 7.33k 0 7.33k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_content'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_content`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_intro'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_intro`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_teaser'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_teaser`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_tags'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_tags`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_type'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_type`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_location'\G # SHOW CREATE TABLE `pantheon`.`node__field_location`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_audience'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_audience`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term__parent'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term__parent`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid LEFT JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid LEFT JOIN node__field_text_content node__field_text_content ON node__field_text_content.entity_id = base_table.nid LEFT JOIN node__field_text_intro node__field_text_intro ON node__field_text_intro.entity_id = base_table.nid LEFT JOIN node__field_text_teaser node__field_text_teaser ON node__field_text_teaser.entity_id = base_table.nid LEFT JOIN node__field_event_tags node__field_event_tags ON node__field_event_tags.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_tags.field_event_tags_target_id LEFT JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data.tid INNER JOIN node__field_event_type node__field_event_type ON node__field_event_type.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = node__field_event_type.field_event_type_target_id INNER JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = taxonomy_term_data_2.tid INNER JOIN node__field_location node__field_location ON node__field_location.entity_id = base_table.nid LEFT OUTER JOIN node node ON node.nid = node__field_location.field_location_target_id INNER JOIN node node_2 ON node_2.nid = node.nid LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_4 ON taxonomy_term_data_4.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_5 ON taxonomy_term_data_5.tid = taxonomy_term_data_4.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_6 ON taxonomy_term_data_6.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_6.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_7 ON taxonomy_term_data_7.tid = taxonomy_term__parent.parent_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_8 ON taxonomy_term_data_8.tid = taxonomy_term_data_7.tid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = base_table.nid INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = base_table.nid INNER JOIN node_field_data node_field_data_6 ON node_field_data_6.nid = base_table.nid INNER JOIN node_field_data node_field_data_7 ON node_field_data_7.nid = base_table.nid INNER JOIN node_field_data node_field_data_8 ON node_field_data_8.nid = base_table.nid INNER JOIN node__field_event_tags node__field_event_tags_2 ON node__field_event_tags_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_9 ON taxonomy_term_data_9.tid = node__field_event_tags_2.field_event_tags_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_2 ON taxonomy_term_field_data_2.tid = taxonomy_term_data_9.tid INNER JOIN node_field_data node_field_data_9 ON node_field_data_9.nid = base_table.nid INNER JOIN node__field_event_type node__field_event_type_2 ON node__field_event_type_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_10 ON taxonomy_term_data_10.tid = node__field_event_type_2.field_event_type_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_3 ON taxonomy_term_field_data_3.tid = taxonomy_term_data_10.tid INNER JOIN node_field_data node_field_data_10 ON node_field_data_10.nid = base_table.nid INNER JOIN node__field_location node__field_location_2 ON node__field_location_2.entity_id = base_table.nid LEFT OUTER JOIN node node_3 ON node_3.nid = node__field_location_2.field_location_target_id INNER JOIN node_field_data node_field_data_11 ON node_field_data_11.nid = node_3.nid INNER JOIN node_field_data node_field_data_12 ON node_field_data_12.nid = base_table.nid INNER JOIN node__field_event_audience node__field_event_audience_2 ON node__field_event_audience_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_11 ON taxonomy_term_data_11.tid = node__field_event_audience_2.field_event_audience_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_4 ON taxonomy_term_field_data_4.tid = taxonomy_term_data_11.tid INNER JOIN node__field_event_audience node__field_event_audience_3 ON node__field_event_audience_3.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_12 ON taxonomy_term_data_12.tid = node__field_event_audience_3.field_event_audience_target_id INNER JOIN taxonomy_term__parent taxonomy_term__parent_2 ON taxonomy_term__parent_2.entity_id = taxonomy_term_data_12.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_13 ON taxonomy_term_data_13.tid = taxonomy_term__parent_2.parent_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_5 ON taxonomy_term_field_data_5.tid = taxonomy_term_data_13.tid INNER JOIN node_field_data node_field_data_13 ON node_field_data_13.nid = base_table.nid INNER JOIN node_field_data node_field_data_14 ON node_field_data_14.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and ((node_field_data_2.title LIKE '%s%' ESCAPE '\\') or (node__field_text_content.field_text_content_value LIKE '%s%' ESCAPE '\\') or (node__field_text_intro.field_text_intro_value LIKE '%s%' ESCAPE '\\') or (node__field_text_teaser.field_text_teaser_value LIKE '%s%' ESCAPE '\\') or (taxonomy_term_field_data.name LIKE '%s%' ESCAPE '\\')) and (taxonomy_term_data_3.uuid IN ('ad4a46da-4752-4f58-a44c-fb628c13aa75')) and (node_2.uuid IN ('1c28abaa-f088-404f-925f-263838332601', 'ce465283-9203-49da-a342-5ff62af65c31', '2f900166-5d6e-4f46-a87a-916b4eacff16')) and ((taxonomy_term_data_5.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')) or (taxonomy_term_data_8.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')))) AND (node_field_data_3.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.status = '1') AND (node_field_data_6.status = '1') AND (node_field_data_7.status = '1') AND (node_field_data_8.status = '1') AND (taxonomy_term_field_data_2.status = '1') AND (node_field_data_9.status = '1') AND (taxonomy_term_field_data_3.status = '1') AND (node_field_data_10.status = '1') AND (node_field_data_11.status = '1') AND (node_field_data_12.status = '1') AND (taxonomy_term_field_data_4.status = '1') AND (taxonomy_term_field_data_5.status = '1') AND (node_field_data_13.status = '1') AND (node_field_data_14.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G # Query 8: 0 QPS, 0x concurrency, ID 0x1BB6231D635A40064FF147BFE945E3F7 at byte 512974 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2019-01-30 22:54:20 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 1 # Exec time 4 49716s 49716s 49716s 49716s 49716s 0 49716s # Lock time 0 2ms 2ms 2ms 2ms 2ms 0 2ms # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 1 7.34k 7.34k 7.34k 7.34k 7.34k 0 7.34k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_content'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_content`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_intro'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_intro`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_teaser'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_teaser`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_tags'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_tags`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_type'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_type`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_location'\G # SHOW CREATE TABLE `pantheon`.`node__field_location`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_audience'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_audience`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term__parent'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term__parent`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid LEFT JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid LEFT JOIN node__field_text_content node__field_text_content ON node__field_text_content.entity_id = base_table.nid LEFT JOIN node__field_text_intro node__field_text_intro ON node__field_text_intro.entity_id = base_table.nid LEFT JOIN node__field_text_teaser node__field_text_teaser ON node__field_text_teaser.entity_id = base_table.nid LEFT JOIN node__field_event_tags node__field_event_tags ON node__field_event_tags.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_tags.field_event_tags_target_id LEFT JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data.tid INNER JOIN node__field_event_type node__field_event_type ON node__field_event_type.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = node__field_event_type.field_event_type_target_id INNER JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = taxonomy_term_data_2.tid INNER JOIN node__field_location node__field_location ON node__field_location.entity_id = base_table.nid LEFT OUTER JOIN node node ON node.nid = node__field_location.field_location_target_id INNER JOIN node node_2 ON node_2.nid = node.nid LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_4 ON taxonomy_term_data_4.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_5 ON taxonomy_term_data_5.tid = taxonomy_term_data_4.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_6 ON taxonomy_term_data_6.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_6.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_7 ON taxonomy_term_data_7.tid = taxonomy_term__parent.parent_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_8 ON taxonomy_term_data_8.tid = taxonomy_term_data_7.tid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = base_table.nid INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = base_table.nid INNER JOIN node_field_data node_field_data_6 ON node_field_data_6.nid = base_table.nid INNER JOIN node_field_data node_field_data_7 ON node_field_data_7.nid = base_table.nid INNER JOIN node_field_data node_field_data_8 ON node_field_data_8.nid = base_table.nid INNER JOIN node__field_event_tags node__field_event_tags_2 ON node__field_event_tags_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_9 ON taxonomy_term_data_9.tid = node__field_event_tags_2.field_event_tags_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_2 ON taxonomy_term_field_data_2.tid = taxonomy_term_data_9.tid INNER JOIN node_field_data node_field_data_9 ON node_field_data_9.nid = base_table.nid INNER JOIN node__field_event_type node__field_event_type_2 ON node__field_event_type_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_10 ON taxonomy_term_data_10.tid = node__field_event_type_2.field_event_type_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_3 ON taxonomy_term_field_data_3.tid = taxonomy_term_data_10.tid INNER JOIN node_field_data node_field_data_10 ON node_field_data_10.nid = base_table.nid INNER JOIN node__field_location node__field_location_2 ON node__field_location_2.entity_id = base_table.nid LEFT OUTER JOIN node node_3 ON node_3.nid = node__field_location_2.field_location_target_id INNER JOIN node_field_data node_field_data_11 ON node_field_data_11.nid = node_3.nid INNER JOIN node_field_data node_field_data_12 ON node_field_data_12.nid = base_table.nid INNER JOIN node__field_event_audience node__field_event_audience_2 ON node__field_event_audience_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_11 ON taxonomy_term_data_11.tid = node__field_event_audience_2.field_event_audience_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_4 ON taxonomy_term_field_data_4.tid = taxonomy_term_data_11.tid INNER JOIN node__field_event_audience node__field_event_audience_3 ON node__field_event_audience_3.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_12 ON taxonomy_term_data_12.tid = node__field_event_audience_3.field_event_audience_target_id INNER JOIN taxonomy_term__parent taxonomy_term__parent_2 ON taxonomy_term__parent_2.entity_id = taxonomy_term_data_12.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_13 ON taxonomy_term_data_13.tid = taxonomy_term__parent_2.parent_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_5 ON taxonomy_term_field_data_5.tid = taxonomy_term_data_13.tid INNER JOIN node_field_data node_field_data_13 ON node_field_data_13.nid = base_table.nid INNER JOIN node_field_data node_field_data_14 ON node_field_data_14.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and ((node_field_data_2.title LIKE '%se%' ESCAPE '\\') or (node__field_text_content.field_text_content_value LIKE '%se%' ESCAPE '\\') or (node__field_text_intro.field_text_intro_value LIKE '%se%' ESCAPE '\\') or (node__field_text_teaser.field_text_teaser_value LIKE '%se%' ESCAPE '\\') or (taxonomy_term_field_data.name LIKE '%se%' ESCAPE '\\')) and (taxonomy_term_data_3.uuid IN ('ad4a46da-4752-4f58-a44c-fb628c13aa75')) and (node_2.uuid IN ('1c28abaa-f088-404f-925f-263838332601', 'ce465283-9203-49da-a342-5ff62af65c31', '2f900166-5d6e-4f46-a87a-916b4eacff16')) and ((taxonomy_term_data_5.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')) or (taxonomy_term_data_8.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')))) AND (node_field_data_3.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.status = '1') AND (node_field_data_6.status = '1') AND (node_field_data_7.status = '1') AND (node_field_data_8.status = '1') AND (taxonomy_term_field_data_2.status = '1') AND (node_field_data_9.status = '1') AND (taxonomy_term_field_data_3.status = '1') AND (node_field_data_10.status = '1') AND (node_field_data_11.status = '1') AND (node_field_data_12.status = '1') AND (taxonomy_term_field_data_4.status = '1') AND (taxonomy_term_field_data_5.status = '1') AND (node_field_data_13.status = '1') AND (node_field_data_14.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G # Query 9: 0 QPS, 0x concurrency, ID 0x17B4216B9DCB3C1A380DA15CA5F0786C at byte 505250 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2019-01-30 22:54:20 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 1 # Exec time 4 49715s 49715s 49715s 49715s 49715s 0 49715s # Lock time 0 3ms 3ms 3ms 3ms 3ms 0 3ms # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 1 7.34k 7.34k 7.34k 7.34k 7.34k 0 7.34k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_content'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_content`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_intro'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_intro`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_text_teaser'\G # SHOW CREATE TABLE `pantheon`.`node__field_text_teaser`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_tags'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_tags`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_type'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_type`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_location'\G # SHOW CREATE TABLE `pantheon`.`node__field_location`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_audience'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_audience`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term__parent'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term__parent`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid LEFT JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid LEFT JOIN node__field_text_content node__field_text_content ON node__field_text_content.entity_id = base_table.nid LEFT JOIN node__field_text_intro node__field_text_intro ON node__field_text_intro.entity_id = base_table.nid LEFT JOIN node__field_text_teaser node__field_text_teaser ON node__field_text_teaser.entity_id = base_table.nid LEFT JOIN node__field_event_tags node__field_event_tags ON node__field_event_tags.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_tags.field_event_tags_target_id LEFT JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data.tid INNER JOIN node__field_event_type node__field_event_type ON node__field_event_type.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = node__field_event_type.field_event_type_target_id INNER JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = taxonomy_term_data_2.tid INNER JOIN node__field_location node__field_location ON node__field_location.entity_id = base_table.nid LEFT OUTER JOIN node node ON node.nid = node__field_location.field_location_target_id INNER JOIN node node_2 ON node_2.nid = node.nid LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_4 ON taxonomy_term_data_4.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_5 ON taxonomy_term_data_5.tid = taxonomy_term_data_4.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_6 ON taxonomy_term_data_6.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_6.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_7 ON taxonomy_term_data_7.tid = taxonomy_term__parent.parent_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_8 ON taxonomy_term_data_8.tid = taxonomy_term_data_7.tid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = base_table.nid INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = base_table.nid INNER JOIN node_field_data node_field_data_6 ON node_field_data_6.nid = base_table.nid INNER JOIN node_field_data node_field_data_7 ON node_field_data_7.nid = base_table.nid INNER JOIN node_field_data node_field_data_8 ON node_field_data_8.nid = base_table.nid INNER JOIN node__field_event_tags node__field_event_tags_2 ON node__field_event_tags_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_9 ON taxonomy_term_data_9.tid = node__field_event_tags_2.field_event_tags_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_2 ON taxonomy_term_field_data_2.tid = taxonomy_term_data_9.tid INNER JOIN node_field_data node_field_data_9 ON node_field_data_9.nid = base_table.nid INNER JOIN node__field_event_type node__field_event_type_2 ON node__field_event_type_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_10 ON taxonomy_term_data_10.tid = node__field_event_type_2.field_event_type_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_3 ON taxonomy_term_field_data_3.tid = taxonomy_term_data_10.tid INNER JOIN node_field_data node_field_data_10 ON node_field_data_10.nid = base_table.nid INNER JOIN node__field_location node__field_location_2 ON node__field_location_2.entity_id = base_table.nid LEFT OUTER JOIN node node_3 ON node_3.nid = node__field_location_2.field_location_target_id INNER JOIN node_field_data node_field_data_11 ON node_field_data_11.nid = node_3.nid INNER JOIN node_field_data node_field_data_12 ON node_field_data_12.nid = base_table.nid INNER JOIN node__field_event_audience node__field_event_audience_2 ON node__field_event_audience_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_11 ON taxonomy_term_data_11.tid = node__field_event_audience_2.field_event_audience_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_4 ON taxonomy_term_field_data_4.tid = taxonomy_term_data_11.tid INNER JOIN node__field_event_audience node__field_event_audience_3 ON node__field_event_audience_3.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_12 ON taxonomy_term_data_12.tid = node__field_event_audience_3.field_event_audience_target_id INNER JOIN taxonomy_term__parent taxonomy_term__parent_2 ON taxonomy_term__parent_2.entity_id = taxonomy_term_data_12.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_13 ON taxonomy_term_data_13.tid = taxonomy_term__parent_2.parent_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_5 ON taxonomy_term_field_data_5.tid = taxonomy_term_data_13.tid INNER JOIN node_field_data node_field_data_13 ON node_field_data_13.nid = base_table.nid INNER JOIN node_field_data node_field_data_14 ON node_field_data_14.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and ((node_field_data_2.title LIKE '%sew%' ESCAPE '\\') or (node__field_text_content.field_text_content_value LIKE '%sew%' ESCAPE '\\') or (node__field_text_intro.field_text_intro_value LIKE '%sew%' ESCAPE '\\') or (node__field_text_teaser.field_text_teaser_value LIKE '%sew%' ESCAPE '\\') or (taxonomy_term_field_data.name LIKE '%sew%' ESCAPE '\\')) and (taxonomy_term_data_3.uuid IN ('ad4a46da-4752-4f58-a44c-fb628c13aa75')) and (node_2.uuid IN ('1c28abaa-f088-404f-925f-263838332601', 'ce465283-9203-49da-a342-5ff62af65c31', '2f900166-5d6e-4f46-a87a-916b4eacff16')) and ((taxonomy_term_data_5.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')) or (taxonomy_term_data_8.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b', 'eeb05b8f-b296-4f17-a39e-63278052a69b', '7b2ebbc0-fd6c-49ff-bc0e-b39d49ab9941')))) AND (node_field_data_3.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.status = '1') AND (node_field_data_6.status = '1') AND (node_field_data_7.status = '1') AND (node_field_data_8.status = '1') AND (taxonomy_term_field_data_2.status = '1') AND (node_field_data_9.status = '1') AND (taxonomy_term_field_data_3.status = '1') AND (node_field_data_10.status = '1') AND (node_field_data_11.status = '1') AND (node_field_data_12.status = '1') AND (taxonomy_term_field_data_4.status = '1') AND (taxonomy_term_field_data_5.status = '1') AND (node_field_data_13.status = '1') AND (node_field_data_14.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G # Query 12: 0.00 QPS, 0.03x concurrency, ID 0xA9C1951A2F2881CE3C22CE5201282742 at byte 282101 # This item is included in the report because it matches --outliers. # Scores: V/M = 14.88 # Time range: 2019-01-30 04:13:14 to 18:21:30 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 5 11 # Exec time 0 1386s 7s 154s 126s 151s 43s 144s # Lock time 0 15ms 507us 3ms 1ms 2ms 742us 1ms # Rows sent 0 121 11 11 11 11 0 11 # Rows examine 0 8.76k 470 934 815.09 918.49 142.31 918.49 # Query size 4 29.82k 2.65k 2.73k 2.71k 2.62k 0 2.62k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ###### # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_type'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_type`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_location'\G # SHOW CREATE TABLE `pantheon`.`node__field_location`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid INNER JOIN node__field_event_type node__field_event_type ON node__field_event_type.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_type.field_event_type_target_id INNER JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = taxonomy_term_data.tid INNER JOIN node__field_location node__field_location ON node__field_location.entity_id = base_table.nid LEFT OUTER JOIN node node ON node.nid = node__field_location.field_location_target_id INNER JOIN node node_2 ON node_2.nid = node.nid INNER JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node__field_event_type node__field_event_type_2 ON node__field_event_type_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = node__field_event_type_2.field_event_type_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data_3.tid INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = base_table.nid INNER JOIN node__field_location node__field_location_2 ON node__field_location_2.entity_id = base_table.nid LEFT OUTER JOIN node node_3 ON node_3.nid = node__field_location_2.field_location_target_id INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = node_3.nid INNER JOIN node_field_data node_field_data_6 ON node_field_data_6.nid = base_table.nid INNER JOIN node_field_data node_field_data_7 ON node_field_data_7.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and (taxonomy_term_data_2.uuid IN ('ad4a46da-4752-4f58-a44c-fb628c13aa75')) and (node_2.uuid IN ('1c28abaa-f088-404f-925f-263838332601', 'ce465283-9203-49da-a342-5ff62af65c31', '2f900166-5d6e-4f46-a87a-916b4eacff16'))) AND (node_field_data_2.status = '1') AND (node_field_data_3.status = '1') AND (taxonomy_term_field_data.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.status = '1') AND (node_field_data_6.status = '1') AND (node_field_data_7.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G # Query 15: 0.00 QPS, 0.00x concurrency, ID 0xE0D6F25528DAFD73135113960256FA84 at byte 8553 # This item is included in the report because it matches --outliers. # Scores: V/M = 16.30 # Time range: 2019-01-28 23:36:43 to 2019-01-31 00:33:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 20 40 # Exec time 0 681s 1s 56s 17s 45s 17s 7s # Lock time 99 483s 28us 54s 12s 42s 15s 2s # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 74 10.94M 202.54k 440.79k 280.11k 399.43k 81.26k 245.21k # Query size 0 2.74k 69 72 70.25 69.19 0.99 69.19 # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ #################################################### # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'polaris_search_data'\G # SHOW CREATE TABLE `pantheon`.`polaris_search_data`\G DELETE FROM polaris_search_data WHERE value LIKE '%1658%' ESCAPE '\\'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select * from polaris_search_data WHERE value LIKE '%1658%' ESCAPE '\\'\G # Query 18: 0.00 QPS, 0.00x concurrency, ID 0xC071E786F6A6672AE5C4B91C15484EBF at byte 10202 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.11 # Time range: 2019-01-28 23:34:26 to 2019-01-31 00:33:12 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 7 15 # Exec time 0 46s 2s 4s 3s 4s 582ms 3s # Lock time 0 2ms 24us 285us 122us 247us 93us 114us # Rows sent 0 15 1 1 1 1 0 1 # Rows examine 9 1.43M 97.66k 97.66k 97.66k 97.66k 0 97.66k # Query size 0 1.08k 74 74 74 74 0 74 # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'watchdog'\G # SHOW CREATE TABLE `pantheon`.`watchdog`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT w.wid AS wid FROM watchdog w ORDER BY wid DESC LIMIT 1 OFFSET 99999\G # Query 20: 0.00 QPS, 0.00x concurrency, ID 0xF4C59915DDFA01C232313384B1962AD2 at byte 222468 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.04 # Time range: 2019-01-30 09:05:08 to 2019-01-31 00:54:41 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 9 18 # Exec time 0 21s 1s 2s 1s 2s 223ms 1s # Lock time 0 18ms 272us 6ms 1ms 2ms 1ms 515us # Rows sent 0 198 11 11 11 11 0 11 # Rows examine 11 1.61M 26.72k 147.76k 91.78k 117.95k 36.43k 117.95k # Query size 8 59.57k 3.19k 3.50k 3.31k 3.35k 76.98 3.19k # String: # Databases pantheon # Hosts 10.128.0.245 # Users pantheon # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `pantheon` LIKE 'node'\G # SHOW CREATE TABLE `pantheon`.`node`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node_field_data'\G # SHOW CREATE TABLE `pantheon`.`node_field_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_date_time'\G # SHOW CREATE TABLE `pantheon`.`node__field_date_time`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'node__field_event_audience'\G # SHOW CREATE TABLE `pantheon`.`node__field_event_audience`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_data`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term__parent'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term__parent`\G # SHOW TABLE STATUS FROM `pantheon` LIKE 'taxonomy_term_field_data'\G # SHOW CREATE TABLE `pantheon`.`taxonomy_term_field_data`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT base_table.vid AS vid, base_table.nid AS nid, min(node__field_date_time_2.field_date_time_value) AS expression FROM node base_table INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid INNER JOIN node__field_date_time node__field_date_time ON node__field_date_time.entity_id = base_table.nid LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_2 ON taxonomy_term_data_2.tid = taxonomy_term_data.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_3 ON taxonomy_term_data_3.tid = node__field_event_audience.field_event_audience_target_id LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_3.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_4 ON taxonomy_term_data_4.tid = taxonomy_term__parent.parent_target_id LEFT JOIN taxonomy_term_data taxonomy_term_data_5 ON taxonomy_term_data_5.tid = taxonomy_term_data_4.tid INNER JOIN node_field_data node_field_data_2 ON node_field_data_2.nid = base_table.nid INNER JOIN node_field_data node_field_data_3 ON node_field_data_3.nid = base_table.nid INNER JOIN node__field_event_audience node__field_event_audience_2 ON node__field_event_audience_2.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_6 ON taxonomy_term_data_6.tid = node__field_event_audience_2.field_event_audience_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data_6.tid INNER JOIN node__field_event_audience node__field_event_audience_3 ON node__field_event_audience_3.entity_id = base_table.nid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_7 ON taxonomy_term_data_7.tid = node__field_event_audience_3.field_event_audience_target_id INNER JOIN taxonomy_term__parent taxonomy_term__parent_2 ON taxonomy_term__parent_2.entity_id = taxonomy_term_data_7.tid LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_8 ON taxonomy_term_data_8.tid = taxonomy_term__parent_2.parent_target_id INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_2 ON taxonomy_term_field_data_2.tid = taxonomy_term_data_8.tid INNER JOIN node_field_data node_field_data_4 ON node_field_data_4.nid = base_table.nid INNER JOIN node_field_data node_field_data_5 ON node_field_data_5.nid = base_table.nid LEFT JOIN node__field_date_time node__field_date_time_2 ON node__field_date_time_2.entity_id = base_table.nid WHERE ((node_field_data.status = '1') and (node__field_date_time.field_date_time_value > '2019-01-30T04:59:59.999Z') and ((taxonomy_term_data_2.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b')) or (taxonomy_term_data_5.uuid IN ('d6cbd673-97cd-4e42-90a5-7f1ce318efc5', 'b93cce96-c339-41c2-8063-2f2c9d45a00b')))) AND (node_field_data_2.status = '1') AND (node_field_data_3.status = '1') AND (taxonomy_term_field_data.status = '1') AND (taxonomy_term_field_data_2.status = '1') AND (node_field_data_4.status = '1') AND (node_field_data_5.type = 'event') GROUP BY base_table.vid, base_table.nid ORDER BY expression ASC LIMIT 11 OFFSET 0\G