Symfony Profiler

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type != 'VIEW'

SELECT quote_ident(table_name) AS table_name,
                       table_schema AS schema_name
                FROM   information_schema.tables
                WHERE  table_schema NOT LIKE 'pg\_%'
                AND    table_schema != 'information_schema'
                AND    table_name != 'geometry_columns'
                AND    table_name != 'spatial_ref_sys'
                AND    table_type != 'VIEW';

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.first_name AS first_name_3,
  u0_.last_name AS last_name_4,
  u0_.gsm AS gsm_5,
  u0_.phone AS phone_6,
  u0_.activation_code AS activation_code_7,
  u0_.echopark_name AS echopark_name_8,
  u0_.echopark_main_community_id AS echopark_main_community_id_9,
  u0_.locale AS locale_10,
  u0_.validated AS validated_11,
  u0_.external_id AS external_id_12,
  u0_.created_at AS created_at_13,
  u0_.updated_at AS updated_at_14,
  u0_.deleted_at AS deleted_at_15,
  u0_.created_by AS created_by_16,
  u0_.updated_by AS updated_by_17,
  u0_.deleted_by AS deleted_by_18,
  u0_.enabled AS enabled_19,
  u0_.deleted AS deleted_20,
  a1_.id AS id_21,
  a1_.created_at AS created_at_22,
  a1_.updated_at AS updated_at_23,
  a1_.deleted_at AS deleted_at_24,
  a1_.created_by AS created_by_25,
  a1_.updated_by AS updated_by_26,
  a1_.deleted_by AS deleted_by_27,
  a1_.enabled AS enabled_28,
  a1_.deleted AS deleted_29,
  a2_.id AS id_30,
  a2_.name AS name_31,
  a2_.code AS code_32,
  a2_.created_at AS created_at_33,
  a2_.updated_at AS updated_at_34,
  a2_.deleted_at AS deleted_at_35,
  a2_.created_by AS created_by_36,
  a2_.updated_by AS updated_by_37,
  a2_.deleted_by AS deleted_by_38,
  a2_.enabled AS enabled_39,
  a2_.deleted AS deleted_40,
  u3_.id AS id_41,
  u3_.created_at AS created_at_42,
  u3_.updated_at AS updated_at_43,
  u3_.deleted_at AS deleted_at_44,
  u3_.created_by AS created_by_45,
  u3_.updated_by AS updated_by_46,
  u3_.deleted_by AS deleted_by_47,
  u3_.enabled AS enabled_48,
  u3_.deleted AS deleted_49,
  g4_.id AS id_50,
  g4_.name AS name_51,
  g4_.code AS code_52,
  g4_.created_at AS created_at_53,
  g4_.updated_at AS updated_at_54,
  g4_.deleted_at AS deleted_at_55,
  g4_.created_by AS created_by_56,
  g4_.updated_by AS updated_by_57,
  g4_.deleted_by AS deleted_by_58,
  g4_.enabled AS enabled_59,
  g4_.deleted AS deleted_60,
  a5_.id AS id_61,
  a5_.created_at AS created_at_62,
  a5_.updated_at AS updated_at_63,
  a5_.deleted_at AS deleted_at_64,
  a5_.created_by AS created_by_65,
  a5_.updated_by AS updated_by_66,
  a5_.deleted_by AS deleted_by_67,
  a5_.enabled AS enabled_68,
  a5_.deleted AS deleted_69,
  a6_.id AS id_70,
  a6_.name AS name_71,
  a6_.code AS code_72,
  a6_.created_at AS created_at_73,
  a6_.updated_at AS updated_at_74,
  a6_.deleted_at AS deleted_at_75,
  a6_.created_by AS created_by_76,
  a6_.updated_by AS updated_by_77,
  a6_.deleted_by AS deleted_by_78,
  a6_.enabled AS enabled_79,
  a6_.deleted AS deleted_80,
  u0_.company_id AS company_id_81,
  u0_.instance_id AS instance_id_82,
  a1_.authorization_id AS authorization_id_83,
  a1_.user_id AS user_id_84,
  u3_.user_id AS user_id_85,
  u3_.group_id AS group_id_86,
  g4_.company_id AS company_id_87,
  a5_.authorization_id AS authorization_id_88,
  a5_.group_id AS group_id_89
FROM
  users u0_
  LEFT JOIN authorizations__users a1_ ON u0_.id = a1_.user_id
  LEFT JOIN authorizations a2_ ON a1_.authorization_id = a2_.id
  LEFT JOIN users__groups u3_ ON u0_.id = u3_.user_id
  LEFT JOIN groups g4_ ON u3_.group_id = g4_.id
  LEFT JOIN authorizations__groups a5_ ON g4_.id = a5_.group_id
  LEFT JOIN authorizations a6_ ON a5_.authorization_id = a6_.id
WHERE
  (
    u0_.enabled = 1
    AND u0_.deleted = 0
  )
  AND u0_.email = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.gsm AS gsm_5, u0_.phone AS phone_6, u0_.activation_code AS activation_code_7, u0_.echopark_name AS echopark_name_8, u0_.echopark_main_community_id AS echopark_main_community_id_9, u0_.locale AS locale_10, u0_.validated AS validated_11, u0_.external_id AS external_id_12, u0_.created_at AS created_at_13, u0_.updated_at AS updated_at_14, u0_.deleted_at AS deleted_at_15, u0_.created_by AS created_by_16, u0_.updated_by AS updated_by_17, u0_.deleted_by AS deleted_by_18, u0_.enabled AS enabled_19, u0_.deleted AS deleted_20, a1_.id AS id_21, a1_.created_at AS created_at_22, a1_.updated_at AS updated_at_23, a1_.deleted_at AS deleted_at_24, a1_.created_by AS created_by_25, a1_.updated_by AS updated_by_26, a1_.deleted_by AS deleted_by_27, a1_.enabled AS enabled_28, a1_.deleted AS deleted_29, a2_.id AS id_30, a2_.name AS name_31, a2_.code AS code_32, a2_.created_at AS created_at_33, a2_.updated_at AS updated_at_34, a2_.deleted_at AS deleted_at_35, a2_.created_by AS created_by_36, a2_.updated_by AS updated_by_37, a2_.deleted_by AS deleted_by_38, a2_.enabled AS enabled_39, a2_.deleted AS deleted_40, u3_.id AS id_41, u3_.created_at AS created_at_42, u3_.updated_at AS updated_at_43, u3_.deleted_at AS deleted_at_44, u3_.created_by AS created_by_45, u3_.updated_by AS updated_by_46, u3_.deleted_by AS deleted_by_47, u3_.enabled AS enabled_48, u3_.deleted AS deleted_49, g4_.id AS id_50, g4_.name AS name_51, g4_.code AS code_52, g4_.created_at AS created_at_53, g4_.updated_at AS updated_at_54, g4_.deleted_at AS deleted_at_55, g4_.created_by AS created_by_56, g4_.updated_by AS updated_by_57, g4_.deleted_by AS deleted_by_58, g4_.enabled AS enabled_59, g4_.deleted AS deleted_60, a5_.id AS id_61, a5_.created_at AS created_at_62, a5_.updated_at AS updated_at_63, a5_.deleted_at AS deleted_at_64, a5_.created_by AS created_by_65, a5_.updated_by AS updated_by_66, a5_.deleted_by AS deleted_by_67, a5_.enabled AS enabled_68, a5_.deleted AS deleted_69, a6_.id AS id_70, a6_.name AS name_71, a6_.code AS code_72, a6_.created_at AS created_at_73, a6_.updated_at AS updated_at_74, a6_.deleted_at AS deleted_at_75, a6_.created_by AS created_by_76, a6_.updated_by AS updated_by_77, a6_.deleted_by AS deleted_by_78, a6_.enabled AS enabled_79, a6_.deleted AS deleted_80, u0_.company_id AS company_id_81, u0_.instance_id AS instance_id_82, a1_.authorization_id AS authorization_id_83, a1_.user_id AS user_id_84, u3_.user_id AS user_id_85, u3_.group_id AS group_id_86, g4_.company_id AS company_id_87, a5_.authorization_id AS authorization_id_88, a5_.group_id AS group_id_89 FROM users u0_ LEFT JOIN authorizations__users a1_ ON u0_.id = a1_.user_id LEFT JOIN authorizations a2_ ON a1_.authorization_id = a2_.id LEFT JOIN users__groups u3_ ON u0_.id = u3_.user_id LEFT JOIN groups g4_ ON u3_.group_id = g4_.id LEFT JOIN authorizations__groups a5_ ON g4_.id = a5_.group_id LEFT JOIN authorizations a6_ ON a5_.authorization_id = a6_.id WHERE (u0_.enabled = 1 AND u0_.deleted = 0) AND u0_.email = 'root@eidetic.eu';

SELECT
  a.attnum,
  quote_ident(a.attname) AS field,
  t.typname AS type,
  format_type(a.atttypid, a.atttypmod) AS complete_type,
  (
    SELECT
      tc.collcollate
    FROM
      pg_catalog.pg_collation tc
    WHERE
      tc.oid = a.attcollation
  ) AS collation,
  (
    SELECT
      t1.typname
    FROM
      pg_catalog.pg_type t1
    WHERE
      t1.oid = t.typbasetype
  ) AS domain_type,
  (
    SELECT
      format_type(t2.typbasetype, t2.typtypmod)
    FROM
      pg_catalog.pg_type t2
    WHERE
      t2.typtype = 'd'
      AND t2.oid = a.atttypid
  ) AS domain_complete_type,
  a.attnotnull AS isnotnull,
  (
    SELECT
      't'
    FROM
      pg_index
    WHERE
      c.oid = pg_index.indrelid
      AND pg_index.indkey[0] = a.attnum
      AND pg_index.indisprimary = 't'
  ) AS pri,
  (
    SELECT
      pg_get_expr(adbin, adrelid)
    FROM
      pg_attrdef
    WHERE
      c.oid = pg_attrdef.adrelid
      AND pg_attrdef.adnum = a.attnum
  ) AS default,
  (
    SELECT
      pg_description.description
    FROM
      pg_description
    WHERE
      pg_description.objoid = c.oid
      AND a.attnum = pg_description.objsubid
  ) AS comment
FROM
  pg_attribute a,
  pg_class c,
  pg_type t,
  pg_namespace n
WHERE
  n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )
  AND c.relname = 'doctrine_migration_versions'
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND a.attnum > 0
  AND a.attrelid = c.oid
  AND a.atttypid = t.oid
  AND n.oid = c.relnamespace
ORDER BY
  a.attnum

SELECT
                    a.attnum,
                    quote_ident(a.attname) AS field,
                    t.typname AS type,
                    format_type(a.atttypid, a.atttypmod) AS complete_type,
                    (SELECT tc.collcollate FROM pg_catalog.pg_collation tc WHERE tc.oid = a.attcollation) AS collation,
                    (SELECT t1.typname FROM pg_catalog.pg_type t1 WHERE t1.oid = t.typbasetype) AS domain_type,
                    (SELECT format_type(t2.typbasetype, t2.typtypmod) FROM
                      pg_catalog.pg_type t2 WHERE t2.typtype = 'd' AND t2.oid = a.atttypid) AS domain_complete_type,
                    a.attnotnull AS isnotnull,
                    (SELECT 't'
                     FROM pg_index
                     WHERE c.oid = pg_index.indrelid
                        AND pg_index.indkey[0] = a.attnum
                        AND pg_index.indisprimary = 't'
                    ) AS pri,
                    (SELECT pg_get_expr(adbin, adrelid)
                     FROM pg_attrdef
                     WHERE c.oid = pg_attrdef.adrelid
                        AND pg_attrdef.adnum=a.attnum
                    ) AS default,
                    (SELECT pg_description.description
                        FROM pg_description WHERE pg_description.objoid = c.oid AND a.attnum = pg_description.objsubid
                    ) AS comment
                    FROM pg_attribute a, pg_class c, pg_type t, pg_namespace n
                    WHERE n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false))
                        AND a.attnum > 0
                        AND a.attrelid = c.oid
                        AND a.atttypid = t.oid
                        AND n.oid = c.relnamespace
                    ORDER BY a.attnum;

SELECT
  quote_ident(relname) as relname,
  pg_index.indisunique,
  pg_index.indisprimary,
  pg_index.indkey,
  pg_index.indrelid,
  pg_get_expr(indpred, indrelid) AS
where
FROM
  pg_class,
  pg_index
WHERE
  oid IN (
    SELECT
      indexrelid
    FROM
      pg_index si,
      pg_class sc,
      pg_namespace sn
    WHERE
      sn.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
      AND sc.relname = 'doctrine_migration_versions'
      AND sn.nspname = ANY(
        current_schemas(false)
      )
      AND sc.oid = si.indrelid
      AND sc.relnamespace = sn.oid
  )
  AND pg_index.indexrelid = oid

SELECT quote_ident(relname) as relname, pg_index.indisunique, pg_index.indisprimary,
                       pg_index.indkey, pg_index.indrelid,
                       pg_get_expr(indpred, indrelid) AS where
                 FROM pg_class, pg_index
                 WHERE oid IN (
                    SELECT indexrelid
                    FROM pg_index si, pg_class sc, pg_namespace sn
                    WHERE sn.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND sc.relname = 'doctrine_migration_versions' AND sn.nspname = ANY(current_schemas(false))
                    AND sc.oid=si.indrelid AND sc.relnamespace = sn.oid
                 ) AND pg_index.indexrelid = oid;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT LIKE 'pg\_%'
  AND schema_name != 'information_schema'

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema';

SELECT
  quote_ident(r.conname) as conname,
  pg_catalog.pg_get_constraintdef(r.oid, true) as condef
FROM
  pg_catalog.pg_constraint r
WHERE
  r.conrelid = (
    SELECT
      c.oid
    FROM
      pg_catalog.pg_class c,
      pg_catalog.pg_namespace n
    WHERE
      n.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
      AND c.relname = 'doctrine_migration_versions'
      AND n.nspname = ANY(
        current_schemas(false)
      )
      AND n.oid = c.relnamespace
  )
  AND r.contype = 'f'

SELECT quote_ident(r.conname) as conname, pg_catalog.pg_get_constraintdef(r.oid, true) as condef
                  FROM pg_catalog.pg_constraint r
                  WHERE r.conrelid =
                  (
                      SELECT c.oid
                      FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n
                      WHERE n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false)) AND n.oid = c.relnamespace
                  )
                  AND r.contype = 'f';

SELECT
  attnum,
  attname
FROM
  pg_attribute
WHERE
  attrelid = 40830
  AND attnum IN (1)
ORDER BY
  attnum ASC

SELECT attnum, attname FROM pg_attribute WHERE attrelid=40830 AND attnum IN (1) ORDER BY attnum ASC;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  obj_description(
    'doctrine_migration_versions' : :regclass
  ) AS table_comment;

SELECT obj_description('doctrine_migration_versions'::regclass) AS table_comment;;

SHOW search_path

SHOW search_path;