explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tpVv

Settings
# exclusive inclusive rows x rows loops node
1. 2.673 212,774.428 ↑ 1.0 1 1

Aggregate (cost=48,457.77..48,457.78 rows=1 width=0) (actual time=212,774.428..212,774.428 rows=1 loops=1)

2. 39,134.610 212,771.755 ↓ 13,184.0 13,184 1

Nested Loop Left Join (cost=154.34..48,457.77 rows=1 width=0) (actual time=23.316..212,771.755 rows=13,184 loops=1)

  • Join Filter: (c.reloftype = t.oid)
3. 13.509 69.785 ↓ 13,184.0 13,184 1

Hash Join (cost=71.45..44,473.33 rows=1 width=4) (actual time=4.338..69.785 rows=13,184 loops=1)

  • Hash Cond: (c.relnamespace = nc.oid)
  • Join Filter: (((CASE WHEN (nc.oid = pg_my_temp_schema()) THEN 'LOCAL TEMPORARY'::text WHEN (c.relkind = 'r'::"char") THEN 'BASE TABLE'::text WHEN (c.relkind = 'v'
4. 51.990 51.990 ↓ 1.4 13,384 1

Seq Scan on pg_class c (cost=0.00..44,366.39 rows=9,251 width=9) (actual time=0.014..51.990 rows=13,384 loops=1)

  • Filter: ((relkind = ANY ('{r,v,f}'::"char"[])) AND (pg_has_role(relowner, 'USAGE'::text) OR has_table_privilege(oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCA
5. 0.002 4.286 ↑ 8.0 1 1

Hash (cost=71.36..71.36 rows=8 width=4) (actual time=4.286..4.286 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
6. 4.284 4.284 ↑ 8.0 1 1

Seq Scan on pg_namespace nc (cost=0.00..71.36 rows=8 width=4) (actual time=4.284..4.284 rows=1 loops=1)

  • Filter: ((NOT pg_is_other_temp_schema(oid)) AND (((nspname)::information_schema.sql_identifier)::text = 'public'::text))
7. 101,239.319 173,567.360 ↑ 1.0 41,908 13,184

Hash Join (cost=82.89..3,460.59 rows=41,908 width=4) (actual time=0.001..13.165 rows=41,908 loops=13,184)

  • Hash Cond: (t.typnamespace = nt.oid)
8. 72,327.424 72,327.424 ↑ 1.0 41,908 13,184

Seq Scan on pg_type t (cost=0.00..2,749.08 rows=41,908 width=8) (actual time=0.001..5.486 rows=41,908 loops=13,184)

9. 0.391 0.617 ↑ 1.0 2,306 1

Hash (cost=54.06..54.06 rows=2,306 width=4) (actual time=0.617..0.617 rows=2,306 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 82kB
10. 0.226 0.226 ↑ 1.0 2,306 1

Seq Scan on pg_namespace nt (cost=0.00..54.06 rows=2,306 width=4) (actual time=0.000..0.226 rows=2,306 loops=1)