Calls
Queries that have the highest frequency of execution
Showing 10 entries
Query Exec time Prop exec time Calls
Sync io time
SELECT option_value FROM wp_options WHERE option_name = $1 LIMIT $2 13.459121 seconds 128854 0 seconds
SELECT a.attnum, a.attname, a.atttypmod, a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, a.attisdropped, a.attlen, a.attalign, a.attislocal, pg_catalog.format_type(t.oid,a.atttypmod) AS atttypname, array_to_string(a.attoptions, $1) AS attoptions, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE $2 END AS attcollation, a.attidentity, pg_catalog.array_to_string(ARRAY(SELECT pg_catalog.quote_ident(option_name) || $3 || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(attfdwoptions) ORDER BY option_name), $4) AS attfdwoptions ,CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE $5 END AS attmissingval FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = $6::pg_catalog.oid AND a.attnum > $7::pg_catalog.int2 ORDER BY a.attnum 24.941827 seconds 74652 0 seconds
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, t.relpages, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, $1) AS condef, (SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, (SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= $2) AS indstatcols,(SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= $3) AS indstatvals FROM pg_catalog.pg_index i JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) JOIN pg_catalog.pg_class t2 ON (t2.oid = i.indrelid) LEFT JOIN pg_catalog.pg_constraint c ON (i.indrelid = c.conrelid AND i.indexrelid = c.conindid AND c.contype IN ($4,$5,$6)) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE i.indrelid = $7::pg_catalog.oid AND (i.indisvalid OR t2.relkind = $8) AND i.indisready ORDER BY indexname 27.549993 seconds 73497 0 seconds
SELECT tableoid, oid, conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, conislocal, convalidated FROM pg_catalog.pg_constraint WHERE conrelid = $1::pg_catalog.oid AND contype = $2 ORDER BY conname 17.013577 seconds 71572 0 seconds
BEGIN 0.266091 seconds 62164 0 seconds
CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" bigint, "inserted_at" timestamp(0), PRIMARY KEY ("version")) 14.632079 seconds 62111 0 seconds
LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE 109.069991 seconds 62109 0 seconds
SELECT s0."version"::bigint FROM "schema_migrations" AS s0 3.483795 seconds 62109 0 seconds
COMMIT 0.217144 seconds 62109 0 seconds
SELECT t.tgname, t.tgfoid::pg_catalog.regproc AS tgfname, pg_catalog.pg_get_triggerdef(t.oid, $1) AS tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal FROM pg_catalog.pg_trigger t LEFT JOIN pg_catalog.pg_depend AS d ON d.classid = $2::pg_catalog.regclass AND d.refclassid = $3::pg_catalog.regclass AND d.objid = t.oid LEFT JOIN pg_catalog.pg_trigger AS pt ON pt.oid = refobjid WHERE t.tgrelid = $4::pg_catalog.oid AND (NOT t.tgisinternal) 1.332224 seconds 40849 0 seconds