Symfony Profiler

Query Metrics

12 Database Queries
9 Different statements
91.40 ms Query time
0 Invalid entities
0 Managed entities
Queries


SELECT CURRENT_DATABASE()
SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name)
SELECT current_schema()
SELECT CURRENT_DATABASE()
SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name)
SELECT n.nspname,
       c.relname,
       a.attname,
       t.typname,
       format_type(a.atttypid, a.atttypmod),
       bt.typname,
       format_type(bt.oid, t.typtypmod),
       a.attnotnull,
       a.attidentity,
       (    SELECT
        CASE
            WHEN a.attgenerated = 's' THEN NULL
            ELSE pg_get_expr(adbin, adrelid)
        END
     FROM pg_attrdef
     WHERE c.oid = pg_attrdef.adrelid
        AND pg_attrdef.adnum=a.attnum),
       dsc.description,
       CASE
           WHEN coll.collprovider = 'c'
               THEN coll.collcollate
           WHEN coll.collprovider = 'd'
               THEN NULL
           ELSE coll.collname
           END
FROM pg_attribute a
         JOIN pg_class c
              ON c.oid = a.attrelid
         JOIN pg_namespace n
              ON n.oid = c.relnamespace
         JOIN pg_type t
              ON t.oid = a.atttypid
         LEFT JOIN pg_type bt
                   ON t.typtype = 'd'
                       AND bt.oid = t.typbasetype
         LEFT JOIN pg_collation coll
                   ON coll.oid = a.attcollation
         LEFT JOIN pg_depend dep
                   ON dep.objid = c.oid
                       AND dep.deptype = 'e'
                       AND dep.classid = (SELECT oid FROM pg_class WHERE relname = 'pg_class')
         LEFT JOIN pg_description dsc
                   ON dsc.objoid = c.oid AND dsc.objsubid = a.attnum
         LEFT JOIN pg_inherits i
                   ON i.inhrelid = c.oid
         LEFT JOIN pg_class p
                   ON i.inhparent = p.oid
                       AND p.relkind = 'p'
WHERE n.nspname = ? AND c.relname = ? AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys')
  AND a.attnum > 0
  AND dep.refobjid IS NULL
  -- exclude partitions (tables that inherit from partitioned tables)
  AND p.oid IS NULL
ORDER BY n.nspname,
         c.relname,
         a.attnum
SELECT n.nspname,
       c.relname,
       CASE c.relpersistence WHEN 'u' THEN true ELSE false END,
       obj_description(c.oid, 'pg_class')
FROM pg_class c
         INNER JOIN pg_namespace n
                    ON n.oid = c.relnamespace
WHERE n.nspname = ? AND c.relname = ? AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys')
SELECT n.nspname,
       c.relname,
       ct.conname,
       a.attname
FROM pg_namespace n
         INNER JOIN pg_class c
                    ON c.relnamespace = n.oid
         INNER JOIN pg_constraint ct
                    ON ct.conrelid = c.oid
         INNER JOIN pg_index i
                    ON i.indrelid = c.oid
                        AND i.indexrelid = ct.conindid
         INNER JOIN LATERAL unnest(i.indkey) WITH ORDINALITY AS keys(attnum, ord)
                    ON true
         INNER JOIN
     pg_attribute a
     ON a.attrelid = c.oid
         AND a.attnum = keys.attnum
WHERE n.nspname = ? AND c.relname = ? AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys')
  AND ct.contype = 'p'
ORDER BY n.nspname,
         c.relname,
         ct.conname,
         keys.ord
SELECT n.nspname,
       c.relname,
       ic.relname,
       i.indisunique,
       pg_get_expr(indpred, indrelid),
       attname
FROM pg_index i
         JOIN pg_class AS c ON c.oid = i.indrelid
         JOIN pg_namespace n ON n.oid = c.relnamespace
         JOIN pg_class AS ic ON ic.oid = i.indexrelid
         JOIN LATERAL unnest(i.indkey) WITH ORDINALITY AS keys(attnum, ord)
              ON TRUE
         JOIN pg_attribute a
              ON a.attrelid = c.oid
                  AND a.attnum = keys.attnum
WHERE n.nspname = ? AND c.relname = ? AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys')
  AND i.indisprimary = false
ORDER BY n.nspname,
         c.relname,
         ic.relname,
         keys.ord
SELECT pkn.nspname,
           pkc.relname,
           r.conname,
           fkn.nspname,
           fkc.relname,
           r.confupdtype,
           r.confdeltype,
           r.condeferrable,
           r.condeferred,
           pka.attname,
           fka.attname
    FROM pg_constraint r
             JOIN pg_class fkc
                  ON fkc.oid = r.confrelid
             JOIN pg_namespace fkn
                  ON fkn.oid = fkc.relnamespace
             JOIN unnest(r.confkey) WITH ORDINALITY AS fk_attnum(attnum, ord)
                  ON TRUE
             JOIN pg_attribute fka
                  ON fka.attrelid = fkc.oid
                      AND fka.attnum = fk_attnum.attnum
             JOIN pg_class pkc
                  ON pkc.oid = r.conrelid
             JOIN pg_namespace pkn
                  ON pkn.oid = pkc.relnamespace
             JOIN unnest(r.conkey) WITH ORDINALITY AS pk_attnum(attnum, ord)
                  ON pk_attnum.ord = fk_attnum.ord
             JOIN pg_attribute pka
                  ON pka.attrelid = pkc.oid
                      AND pka.attnum = pk_attnum.attnum
    WHERE pkn.nspname = ? AND pkc.relname = ? AND pkn.nspname NOT LIKE 'pg\_%' AND pkn.nspname != 'information_schema' AND pkc.relkind IN ('r', 'p') AND pkc.relname NOT IN ('geometry_columns', 'spatial_ref_sys')
      AND r.contype = 'f'
    ORDER BY pkn.nspname,
             pkc.relname,
             r.conname
SELECT * FROM doctrine_migration_versions
SELECT CURRENT_DATABASE()
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Managed Entities

default entity manager

Class	Amount of managed objects
Entities Mapping

No loaded entities.
Symfony Profiler

GET https://dvz.baks.dev/static/js/main.js.map?gclid=1c12a5a4

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
