Created
September 14, 2019 19:07
-
-
Save ailabs-software/a137d3f44121ce1dbfeaa544a4c713b2 to your computer and use it in GitHub Desktop.
Top 85 queries by total_time
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT total_time, calls, (total_time/calls), query FROM pg_stat_statements ORDER BY total_time DESC; | |
| total_time | calls | ?column? | query | |
| ------------------+-----------+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| 661680271.675458 | 9892232 | 66.8888751977772 | UPDATE canalytics_contentagg SET dirty=?, timestamp=now() WHERE domain=$1 AND content_type=$2 AND content_id=$3 RETURNING domain; | |
| 319673901.74204 | 904181 | 353.550784347426 | SELECT socialite_message.*, person_id FROM socialite_message LEFT OUTER JOIN socialite_conversation ON(id=convo_id) WHERE socialite_message.domain=$1 AND active AND socialite_message.serial>$2 ORDER BY serial ASC; | |
| 283822080.536763 | 5197727 | 54.605038036196 | SELECT COUNT(*)::int AS count FROM publish_queue INNER JOIN publish ON(publish.id=publish_queue.publish_id) INNER JOIN canalytics_open ON(canalytics_open.domain=publish.domain AND canalytics_open.send_id=publish_queue.send_id) INNER JOIN mt_message ON (mt_message.id=mt_message_id) WHERE publish.domain=$1 AND publish.content_name=$2 AND publish.content_id=$3 AND mt_message.type=$4; | |
| 272101692.734702 | 5895158 | 46.1568108496333 | UPDATE canalytics_view SET open=?, visible=?, viewend_timestamp = now(), open_duration = open_duration + EXTRACT(? FROM (now() - viewbegan_timestamp) ), visible_duration = visible_duration + (CASE WHEN visible THEN EXTRACT(? FROM (now() - visiblebegan_timestamp) ) ELSE ? END) WHERE domain=$1 AND session_id = $2 AND open; | |
| 214840572.416001 | 184344 | 1165.43295369527 | SELECT maturation_timestamp FROM publish_queue LEFT OUTER JOIN publish ON(publish.id=publish_queue.publish_id) WHERE status_executed=? AND funded AND syndicated=$1 ORDER BY NOT maturation_timestamp IS NULL, maturation_timestamp ASC LIMIT ?; | |
| 201509815.825 | 2223886 | 90.6115762341237 | SELECT SUM(transaction_amount)::int AS amount FROM beancounter_ledger WHERE domain=$1 AND transaction_type=$2; | |
| 187482857.623988 | 2598835 | 72.1411161631992 | SELECT AVG(canalytics_view.visible_duration)::int AS val_avg FROM publish_queue INNER JOIN publish ON(publish.id=publish_queue.publish_id) INNER JOIN canalytics_view ON(canalytics_view.domain=publish_queue.domain AND canalytics_view.send_id=publish_queue.send_id) WHERE publish.domain=$1 AND publish.content_name=$2 AND publish.content_id=$3; | |
| 172701751.134174 | 2598823 | 66.453833575497 | SELECT AVG(canalytics_view.open_duration)::int AS val_avg FROM publish_queue INNER JOIN publish ON(publish.id=publish_queue.publish_id) INNER JOIN canalytics_view ON(canalytics_view.domain=publish_queue.domain AND canalytics_view.send_id=publish_queue.send_id) WHERE publish.domain=$1 AND publish.content_name=$2 AND publish.content_id=$3; | |
| 172398954.240012 | 2598814 | 66.3375502209899 | SELECT SUM(canalytics_view.open_duration)::int AS sum FROM publish_queue INNER JOIN publish ON(publish.id=publish_queue.publish_id) INNER JOIN canalytics_view ON(canalytics_view.domain=publish_queue.domain AND canalytics_view.send_id=publish_queue.send_id) WHERE publish.domain=$1 AND publish.content_name=$2 AND publish.content_id=$3 | |
| 162402462.399 | 359648 | 451.559475929242 | SELECT id FROM shorty WHERE story=$1; | |
| 141936060.952499 | 2598874 | 54.6144449298039 | SELECT COUNT(*)::int AS count FROM publish LEFT OUTER JOIN publish_queue ON(publish_queue.domain=publish.domain AND publish_id=publish.id AND status_executed=?) WHERE publish_queue.domain=$1 AND content_name=$2 AND content_id=$3; | |
| 137090659.220017 | 965871 | 141.934750313466 | SELECT page_url, COUNT(*)::int FROM siteanalytics_pageview WHERE domain=$1 AND date_trunc(?, pageview_timestamp at time zone ?) = $2::date GROUP BY page_url | |
| 132255159.92894 | 5197696 | 25.4449586757172 | SELECT COUNT(*)::int AS count FROM publish_queue INNER JOIN publish ON(publish.id=publish_queue.publish_id) INNER JOIN canalytics_open ON(canalytics_open.domain=publish.domain AND canalytics_open.send_id=publish_queue.send_id) WHERE publish.domain=$1 AND publish.content_name=$2 AND publish.content_id=$3 AND (canalytics_open.device_info->>?)=$4 | |
| 109157105.179245 | 28482888 | 3.83237490451268 | SELECT person_id, series_position_map, revolves_count_map, created::text AS created FROM ella_series_member WHERE domain=$1 AND series_id=$2 AND _series_positions <@ ARRAY[$3]::int[] AND _next_send_time < now() AND crm_personIsAutosendEligible(ella_series_member.domain, ella_series_member.person_id); | |
| 78893066.0900004 | 16311551 | 4.83663791934933 | SELECT id, enabled, type, title, cta_headline, cta_paragraph, photo_url, form_id, logic, native_position, native_logotype, native_action, native_action, native_custom, native_linkedpopup, native_gotourl, button_text, content FROM automation_ornament WHERE domain=$1 AND enabled=? AND (NOT EXISTS(SELECT ? FROM automation_ornament_magnet WHERE ornament_id=automation_ornament.id AND automation_ornament_magnet.enabled) OR EXISTS(SELECT ? FROM automation_ornament_magnet WHERE automation_ornament_magnet.domain=$1 AND ornament_id=automation_ornament.id AND automation_ornament_magnet.enabled AND (matchmode=? OR $2 ILIKE pagepath) ) ); | |
| 69740960.7160001 | 33068 | 2109.01659356478 | SELECT day AS x, COALESCE(y_count, ?)::int AS y FROM (SELECT day::date FROM generate_series( $2::date, $3::date, INTERVAL ?) day) d LEFT JOIN ( SELECT date_trunc(?, visit_timestamp) AS day, count(*) AS y_count FROM siteanalytics_visit WHERE visit_timestamp >= $2::date AND visit_timestamp <= ($3::date + INTERVAL ?) AND siteanalytics_visit.domain=$1 AND NOT(?) GROUP BY day) t USING (day) ORDER BY day; | |
| 68101426.6312079 | 481877 | 141.325331217734 | UPDATE socialite_message SET seen=? WHERE domain=$1 AND convo_id=$2; | |
| 67590239.1150566 | 47293004 | 1.42918050025024 | SELECT funnel_id FROM crm_funnel_stage WHERE domain=$1 AND id=$2 | |
| 65175290.3109477 | 1539316 | 42.3404228312755 | SELECT type, COUNT(*)::int FROM publish_queue INNER JOIN crm_contact ON(crm_contact.id=publish_queue.contact_id) WHERE publish_queue.domain=$1 AND publish_id=$2 GROUP BY type; | |
| 61922061.5263053 | 39466859 | 1.56896350749132 | SELECT pageview_id, page_url FROM siteanalytics_pageview WHERE domain=$1 AND visit_id=$2 ORDER BY pageview_timestamp DESC LIMIT ?; | |
| 60323016.6629964 | 1168841 | 51.609257942694 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND (crm_person.lastmodified_time::date = $2 AND (virtualfields->?) ILIKE $3) | |
| 58024127.4136208 | 15217703 | 3.81293598735767 | UPDATE siteanalytics_visit SET identity_id=$3 WHERE domain=$1 AND visitor_id=$2; | |
| 49912307.2196836 | 39472997 | 1.26446712976173 | SELECT visit_id FROM siteanalytics_visit WHERE domain=$1 AND visitor_id=$2 AND last_pageview_timestamp > now() - INTERVAL ? | |
| 43703198.1077324 | 5197682 | 8.40820929555374 | SELECT COUNT(*)::int AS count FROM publish_queue INNER JOIN publish ON(publish.id=publish_queue.publish_id) INNER JOIN canalytics_view ON(canalytics_view.domain=publish.domain AND canalytics_view.send_id=publish_queue.send_id) WHERE publish.domain=$1 AND publish.content_name=$2 AND publish.content_id=$3 AND open=?; | |
| 40944731.8559931 | 421227 | 97.2034837652694 | SELECT convo_id, socialite_message.timestamp, who, content, crm_person.fields$firstname, crm_person.fields$lastname FROM socialite_message LEFT OUTER JOIN socialite_conversation ON(id=convo_id) LEFT OUTER JOIN crm_person ON(crm_person.domain=$1 AND crm_person.id = $2) WHERE socialite_conversation.domain=$1 AND person_id=$2 AND active=? ORDER BY socialite_message.serial ASC; | |
| 40579585.4420003 | 117959 | 344.014322281473 | SELECT id FROM crm_person WHERE domain=$1 AND ($2 OR EXISTS(SELECT ? FROM crm_contact WHERE person_id=crm_person.id AND type=? AND lower(value)=lower($3) ) ) AND ($4 OR EXISTS(SELECT ? FROM crm_contact WHERE person_id=crm_person.id AND type=? AND lower(value)=lower($5) ) ); | |
| 39937299.522019 | 965872 | 41.3484390499145 | SELECT COUNT(*)::int AS total_visits FROM siteanalytics_visit WHERE domain=$1 AND date_trunc(?, visit_timestamp at time zone ?) = $2:: | |
| 38544187.8509966 | 24454615 | 1.57615189815896 | SELECT smartstage_on FROM crm_funnel_stage WHERE domain=$1 AND id=$2; | |
| 37580945.8939996 | 217398 | 172.867026807972 | SELECT id, fields$firstname AS firstname, fields$lastname AS lastname, profile_photo FROM crm_person WHERE domain=$1 AND (((COALESCE("fields$firstname", ?) || ? || COALESCE("fields$lastname", ?)) ILIKE $2 OR EXISTS(SELECT ? FROM crm_contact WHERE crm_contact.person_id=crm_person.id AND crm_contact.value ILIKE $2))) AND ? LIMIT ?; | |
| 36591202.581001 | 255269 | 143.343698533708 | SELECT COUNT(*)::int AS count FROM crm_person WHERE crm_person.domain=$1 AND (? AND (((COALESCE("fields$firstname", ?) || ? || COALESCE("fields$lastname", ?)) ILIKE $2 OR EXISTS(SELECT ? FROM crm_contact WHERE crm_contact.person_id=crm_person.id AND crm_contact.value ILIKE $2))) AND ?) | |
| 34332467.4520004 | 23192 | 1480.358203346 | SELECT * FROM (SELECT DISTINCT ON( COALESCE(person_id, siteanalytics_visit.visitor_id) ) * FROM siteanalytics_visit WHERE siteanalytics_visit.domain=$1 AND ( date_trunc(?::text, timezone(?::text, visit_timestamp)) >= $2::date AND ( date_trunc(?::text, timezone(?::text, visit_timestamp)) <= $3::date ) )ORDER BY COALESCE(person_id, siteanalytics_visit.visitor_id), last_pageview_timestamp DESC ) visit ORDER BY last_pageview_timestamp DESC OFFSET $4 LIMIT $5 | |
| 32730638.0810001 | 36006 | 909.032885657947 | SELECT * FROM ( + | |
| | | | SELECT DISTINCT ON(dtmp.person_id) dtmp.person_id AS d_person_id, dtmp.* FROM (SELECT timestamp AS sort_timestamp, timestamp::text AS timestamp, event_type, person_id, event_id FROM peoplestream_cache WHERE domain_id=$1 AND EXISTS(SELECT ? FROM crm_person WHERE crm_person.id = person_id AND ?)) AS dtmp ORDER BY dtmp.person_id, sort_timestamp DESC ) AS tmp ORDER BY sort_timestamp DESC LIMIT $2 | |
| 32472515.519 | 12175 | 2667.1470652156 | SELECT * FROM ( + | |
| | | | SELECT DISTINCT ON(dtmp.person_id) dtmp.person_id AS d_person_id, dtmp.* FROM (SELECT timestamp AS sort_timestamp, timestamp::text AS timestamp, event_type, person_id, event_id FROM peoplestream_cache WHERE domain_id=$1 AND EXISTS (SELECT ? FROM crm_group_junction WHERE peoplestream_cache.person_id=crm_group_junction.person_id AND group_id=ANY($2) ) AND EXISTS(SELECT ? FROM crm_person WHERE crm_person.id = person_id AND ?)) AS dtmp ORDER BY dtmp.person_id, sort_timestamp DESC ) AS tmp ORDER BY sort_timestamp DESC LIMIT $3 | |
| 29279372.5700001 | 102511 | 285.621763225411 | SELECT publish.* FROM publish WHERE EXISTS(SELECT ? FROM publish_queue WHERE publish.id=publish_queue.publish_id AND status_executed=? AND funded AND syndicated=$1 AND (maturation_timestamp IS NULL OR maturation_timestamp <= now() ) ) ORDER BY total ASC LIMIT ?; | |
| 28985341.924 | 48294 | 600.185156002816 | SELECT domain, id, type, locked, query_model FROM crm_group WHERE type=$1 AND locked!=? AND observe_epoch>=sync_epoch AND query_model IS NOT NULL; | |
| 26771254.2380065 | 2598884 | 10.3010577763403 | SELECT publish.issued FROM publish WHERE publish.domain=$1 AND publish.content_name=$2 AND publish.content_id=$3 ORDER BY publish.issued ASC LIMIT ? | |
| 24354317.9619997 | 95072 | 256.167094012955 | SELECT domain, content_type, content_id FROM canalytics_contentagg WHERE dirty=?; | |
| 22757804.2439939 | 21324524 | 1.06721276610882 | INSERT INTO siteanalytics_pageview(domain, visit_id, pageview_id, page_url, page_title, pageview_timestamp, pageview_state, _open_duration_began, open_duration, _visible_duration_began, visible_duration, visible) VALUES($1, $2, uuid_generate_v4(), $3, $4, now(), $5, now(), ?, now(), ?, ?) RETURNING pageview_id; | |
| 22269354.9950007 | 904404 | 24.6232380606462 | SELECT * FROM socialite_conversation WHERE domain=$1 AND active AND serial>$2 ORDER BY serial ASC; | |
| 21605494.5531059 | 2598878 | 8.31339314623691 | SELECT publish.issued FROM publish WHERE publish.domain=$1 AND publish.content_name=$2 AND publish.content_id=$3 ORDER BY publish.issued DESC LIMIT ? | |
| 21141757.1911238 | 21222140 | 0.996212313702757 | SELECT person_id FROM crm_group_junction WHERE domain=$1 AND group_id=$2; | |
| 18728553.0360041 | 10285166 | 1.82092861077829 | SELECT crm_funnel_stage.domain, crm_funnel_stage.funnel_id, crm_funnel_stage.id, crm_funnel_stage.position, crm_funnel_stage.directions, crm_funnel_stage.heatlevels AS "heatLevels", smartstage_on, smartstage_model, crm_group.title FROM crm_funnel_stage INNER JOIN crm_group ON(crm_group.domain=crm_funnel_stage.domain AND crm_group.id = crm_funnel_stage.id) WHERE crm_funnel_stage.domain=$1 AND funnel_id=$2 ORDER BY position; | |
| 18547084.6469998 | 95859 | 193.482976528024 | SELECT crm_person.* FROM crm_person WHERE crm_person.domain=$1 AND (? AND (((COALESCE("fields$firstname", ?) || ? || COALESCE("fields$lastname", ?)) ILIKE $4 OR EXISTS(SELECT ? FROM crm_contact WHERE crm_contact.person_id=crm_person.id AND crm_contact.value ILIKE $4))) AND ?) ORDER BY flag_purchased IS NOT TRUE ASC, flag_newlead IS NOT TRUE ASC, meta_hold IS NOT TRUE ASC, fields$firstname ASC OFFSET $2 LIMIT $3; | |
| 17923582.5859875 | 14064305 | 1.27440229616661 | SELECT guid, mediatype_format, field_document FROM mediasystem2_library WHERE domain=$1 AND mediatype_format=$2; | |
| 16419006.0410005 | 383663 | 42.7953856405242 | SELECT id, type, title, locked, locked_reason, mutate_time, (SELECT COUNT(*)::int FROM crm_group_junction WHERE id=group_id) AS count, sync_epoch, observe_epoch FROM crm_group WHERE domain=$1 ORDER BY title ASC; | |
| 16339836.9640016 | 12476804 | 1.30961718754271 | SELECT id FROM crm_funnel_stage WHERE domain=$1 AND funnel_id=$2 AND position=$3; | |
| 16173125.7179982 | 6416439 | 2.52057655624844 | SELECT id, lastmodified, title, meta_description, meta_author, moment_mode, document FROM brochure WHERE domain=$1 AND id=$2; | |
| 13396661.6400002 | 397601 | 33.6937322592252 | SELECT length("fields$lastname") AS fieldlengthcount FROM crm_person WHERE domain=$1 AND "fields$lastname" IS NOT NULL ORDER BY length("fields$lastname") DESC LIMIT ?; | |
| 11956628.2710303 | 1078565 | 11.0856816891242 | SELECT * FROM notifications WHERE domain=$1 AND event_type=$2 AND ($3 OR acknowledged=?) ORDER BY timestamp DESC LIMIT ?; | |
| 11932326.2410001 | 110980 | 107.517807181475 | SELECT id, title, count_views, count_submissions FROM crm_form WHERE domain=$1 AND ($2 OR title ILIKE $3) ORDER BY last_modified DESC NULLS LAST; | |
| 10277706.6010003 | 397601 | 25.849297665248 | SELECT length("fields$firstname") AS fieldlengthcount FROM crm_person WHERE domain=$1 AND "fields$firstname" IS NOT NULL ORDER BY length("fields$firstname") DESC LIMIT ?; | |
| 9749043.65999995 | 143296 | 68.0343042373824 | SELECT person_id FROM crm_contact WHERE domain=$1 AND EXISTS(SELECT ? FROM crm_person WHERE id=crm_contact.person_id AND domain=$1) AND (type, value) IN (SELECT unnest($2::crm_contact_type[]), unnest($3::text[])); | |
| 9740448.91199991 | 369483 | 26.3623736734841 | SELECT type, COUNT(*)::int FROM publish_queue INNER JOIN crm_contact ON(crm_contact.id=publish_queue.contact_id) WHERE publish_queue.domain=$1 AND publish_id=$2 GROUP BY type; | |
| 8606016.59610585 | 31567035 | 0.272626700483775 | UPDATE siteanalytics_visit SET last_pageview_timestamp = now() WHERE domain=$1 AND visit_id=$2; | |
| 8551702.64199996 | 4401 | 1943.12716246307 | SELECT status_executed_time FROM publish_queue LEFT OUTER JOIN publish ON(publish.id=publish_queue.publish_id) WHERE syndicated=? AND contact_id = $1 AND status_executed=? ORDER BY status_executed_time DESC LIMIT ? | |
| 8442393.15538655 | 532470860 | 0.0158551270869293 | SELECT "subscriber_timezone" AS prop FROM crm_person WHERE domain=$1 AND id=$2; | |
| 8211156.30900003 | 6886 | 1192.44210121987 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND (EXISTS(SELECT ? FROM publish_queue INNER JOIN publish ON (publish_id=publish.id) WHERE publish_queue.person_id=crm_person.id AND EXISTS(SELECT ? FROM mediaanalytic_play_session ca WHERE ca.send_id=publish_queue.send_id))) | |
| 7869105.37399996 | 27454 | 286.628738034529 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND ((virtualfields->?) ILIKE $2 AND crm_person.lastmodified_time::date BETWEEN SYMMETRIC $3 AND $4 AND (EXISTS(SELECT ? FROM publish_queue LEFT OUTER JOIN publish ON (publish_id=publish.id) WHERE publish_queue.person_id=crm_person.id AND content_name=$5 AND content_id=$6 AND publish.issued::date BETWEEN SYMMETRIC $3 AND $7) OR EXISTS(SELECT ? FROM publish_queue LEFT OUTER JOIN publish ON (publish_id=publish.id) WHERE publish_queue.person_id=crm_person.id AND content_name=$5 AND content_id=$8 AND publish.issued::date BETWEEN SYMMETRIC $3 AND $7) OR EXISTS(SELECT ? FROM publish_queue LEFT OUTER JOIN publish ON (publish_id=publish.id) WHERE publish_queue.person_id=crm_person.id AND content_name=$5 AND content_id=$9 AND publish.issued::date BETWEEN SYMMETRIC $3 AND $7))) | |
| 7687413.12900006 | 27206 | 282.56315257664 | SELECT DISTINCT ON(crm_contact.id) crm_contact.id AS contact_id, subscriber_subscribed, subscriber_interval, crm_contact.type AS contact_type, crm_person.id AS person_id FROM crm_person LEFT OUTER JOIN crm_group_junction ON(person_id=crm_person.id AND crm_group_junction.domain=$1) INNER JOIN crm_contact ON(crm_contact.person_id=crm_person.id AND crm_contact.active=? AND crm_contact.valid=?)WHERE crm_person.domain=$1 AND ($4 OR ARRAY[crm_person.id] <@ $2 OR ARRAY[crm_group_junction.group_id] <@ $3); | |
| 7640967.39724306 | 300333766 | 0.0254415862026085 | SELECT * FROM crm_person WHERE domain=$1 AND id=$2; | |
| 7561317.71024184 | 131331420 | 0.0575743238765091 | SELECT person_id, value FROM crm_contact WHERE domain=$1 AND active AND type=$2 AND person_id=ANY($3); | |
| 7502218.18709212 | 37774424 | 0.198605760000262 | UPDATE siteanalytics_pageview SET pageview_state=$2, open_duration = open_duration + EXTRACT(? FROM (now() - _open_duration_began) ), y1 = $3, y2 = $4 WHERE pageview_id=$1 AND NOT pageview_state=$2; | |
| 7186577.79499999 | 2274 | 3160.32444810905 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND (EXISTS(SELECT ? FROM publish_queue INNER JOIN publish ON(publish_queue.domain = publish.domain AND publish_queue.publish_id=publish.id) WHERE publish_queue.status_executed=? AND publish_queue.status_executed_time < now() + $2::interval AND ? AND publish_queue.person_id = crm_person.id ) AND NOT EXISTS(SELECT ? FROM canalytics_open ca INNER JOIN publish_queue ON(ca.domain = publish_queue.domain AND ca.send_id=publish_queue.send_id) INNER JOIN publish ON(publish_queue.domain = publish.domain AND publish_queue.publish_id=publish.id) WHERE publish_queue.person_id=crm_person.id AND ca.issued > now() + $2::interval AND ?)) | |
| 7056250.41599989 | 211178 | 33.4137571906159 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND ((virtualfields->?) ILIKE $2) | |
| 7039537.66000008 | 383745 | 18.3443110920014 | SELECT COUNT(*)::int AS count FROM crm_person WHERE crm_person.domain=$1; | |
| 6734957.98429371 | 289025500 | 0.0233022968018175 | SELECT * FROM crm_person WHERE domain=$1 AND id=$2; | |
| 6292262.55500055 | 1090127 | 5.77204541764451 | SELECT EXISTS(SELECT ? FROM peoplestream_cache WHERE domain_id=$1) AS exists; | |
| 6269731.4400005 | 7901666 | 0.793469559457525 | INSERT INTO siteanalytics_visit(domain, visitor_id, visit_id, visit_timestamp, last_pageview_timestamp, site_hostname, referrer, ip_address, user_agent, location_country, location_region, location_city, device_type, device_name, previous_visits) VALUES($1, $2, uuid_generate_v4(), now(), now(), $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) RETURNING visit_id; | |
| 6228919.70099995 | 65505 | 95.090751866269 | SELECT datawindow_map::text FROM siteanalytics_batch_window WHERE domain=$1 AND datawindow_date >= $2 AND datawindow_date <= $3; | |
| 6018107.967 | 6665 | 902.941930532633 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND (EXISTS(SELECT ? FROM crm_form_submission WHERE crm_form_submission.person_id=crm_person.id AND crm_form_submission.form_id=$2 AND crm_form_submission.timestamp::date = now()::date) OR EXISTS(SELECT ? FROM crm_form_submission WHERE crm_form_submission.person_id=crm_person.id AND crm_form_submission.form_id=$3 AND crm_form_submission.timestamp::date = now()::date) OR EXISTS(SELECT ? FROM crm_form_submission WHERE crm_form_submission.person_id=crm_person.id AND crm_form_submission.form_id=$4 AND crm_form_submission.timestamp::date = now()::date) OR EXISTS(SELECT ? FROM crm_form_submission WHERE crm_form_submission.person_id=crm_person.id AND crm_form_submission.form_id=$5 AND crm_form_submission.timestamp::date = now()::date)) | |
| 5799339.34621773 | 283350047 | 0.0204670491768711 | SELECT virtualfields->? AS fv FROM crm_person WHERE domain=$1 AND id=$2; | |
| 5790199.77772892 | 30119965 | 0.192237931807986 | SELECT id FROM account WHERE domain=$1 AND primary_user; | |
| 5536584.77700001 | 77972 | 71.0073459318731 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND (NOT EXISTS (SELECT ? FROM crm_group_junction WHERE group_id=ANY($2::uuid[]) AND person_id=crm_person.id )) | |
| 5495132.48899999 | 10692 | 513.948044238683 | SELECT COUNT(DISTINCT person_id)::int AS count FROM publish_queue INNER JOIN publish ON(publish.id=publish_id) WHERE publish_queue.domain=$1 AND content_name=$2 AND content_id=$3; | |
| 5430168.42999999 | 44927 | 120.866481848332 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND (EXISTS (SELECT ? FROM crm_group_junction WHERE group_id=$2 AND person_id=crm_person.id ) AND NOT EXISTS (SELECT ? FROM crm_group_junction WHERE group_id=$3 AND person_id=crm_person.id )) | |
| 5235943.21341169 | 69936445 | 0.0748671627991913 | SELECT id, fields$firstname AS firstname, fields$lastname AS lastname, fields$province AS location_province, fields$city AS location_city, profile_photo, subscriber_subscribed AS subscribed, subscriber_location, subscriber_timezone FROM crm_person WHERE domain=$1 AND id=ANY($2) AND ? | |
| 5153019.05499995 | 78432 | 65.7004673475106 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND ((virtualfields->?) ILIKE $2 AND NOT EXISTS (SELECT ? FROM crm_group_junction WHERE group_id=ANY($3::uuid[]) AND person_id=crm_person.id )) | |
| 4995952.77597694 | 20372672 | 0.24522815544161 | UPDATE account_session SET timestamp=now() WHERE session_id=$1 RETURNING user_id; | |
| 4528478.36800014 | 1812329 | 2.49870656376416 | SELECT id, lastmodified, title, meta_description, meta_author, moment_mode, document FROM brochure WHERE domain=$1 AND id=$2; | |
| 4352301.49100003 | 115562 | 37.6620471348715 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND (EXISTS(SELECT ? FROM canalytics_open_count ca WHERE crm_person.domain=ca.domain AND crm_person.id=ca.person_id AND content_name=$2 AND content_id=$3 AND agg=?)) | |
| 4011762.42099998 | 71934 | 55.7700450551892 | SELECT COUNT(*)::int AS count FROM cms_analytics_open WHERE domain=$1 AND site_id=$2 AND page_id=$3 AND repeats>?; | |
| 3916130.58699999 | 40291 | 97.196162592142 | SELECT id AS person_id FROM crm_person WHERE domain=$1 AND ((virtualfields->?) ILIKE $2 AND (crm_person.subscriber_subscribed)) | |
| 3842579.15878429 | 65665769 | 0.0585172338236729 | SELECT person_id, applied_timestamp FROM crm_group_junction WHERE domain=$1 AND group_id=$2 ORDER BY applied_timestamp ASC; | |
| 3762814.74000004 | 1437681 | 2.61728070413397 | SELECT title FROM brochure WHERE domain=$1 AND id=$2; | |
| (Top 85 queries by total_time) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment