explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iftR

Settings
# exclusive inclusive rows x rows loops node
1. 0.188 11.489 ↑ 1.0 1 1

Aggregate (cost=1,951.86..1,951.87 rows=1 width=0) (actual time=11.489..11.489 rows=1 loops=1)

2. 1.174 11.301 ↓ 2,811.0 2,811 1

Hash Right Join (cost=1,362.63..1,951.86 rows=1 width=0) (actual time=11.117..11.301 rows=2,811 loops=1)

  • Hash Cond: (t.oid = c.reloftype)
3. 2.111 4.157 ↑ 1.0 10,117 1

Hash Join (cost=12.92..564.20 rows=10,117 width=4) (actual time=0.130..4.157 rows=10,117 loops=1)

  • Hash Cond: (t.typnamespace = nt.oid)
4. 1.941 1.941 ↑ 1.0 10,117 1

Seq Scan on pg_type t (cost=0.00..412.17 rows=10,117 width=8) (actual time=0.002..1.941 rows=10,117 loops=1)

5. 0.054 0.105 ↑ 1.0 352 1

Hash (cost=8.52..8.52 rows=352 width=4) (actual time=0.105..0.105 rows=352 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
6. 0.051 0.051 ↑ 1.0 352 1

Seq Scan on pg_namespace nt (cost=0.00..8.52 rows=352 width=4) (actual time=0.003..0.051 rows=352 loops=1)

7. 0.528 5.970 ↓ 2,811.0 2,811 1

Hash (cost=1,349.69..1,349.69 rows=1 width=4) (actual time=5.970..5.970 rows=2,811 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 99kB
8. 1.105 5.442 ↓ 2,811.0 2,811 1

Hash Join (cost=11.17..1,349.69 rows=1 width=4) (actual time=0.170..5.442 rows=2,811 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'::"char") THEN 'VIEW'::text WHEN (c.relkind = 'f'::"char") THEN 'FOREIGN TABLE'::text ELSE NULL::text END)::information_schema.character_data)::text = 'BASE TABLE'::text)
9. 4.202 4.202 ↓ 1.4 3,072 1

Seq Scan on pg_class c (cost=0.00..1,330.33 rows=2,146 width=9) (actual time=0.011..4.202 rows=3,072 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, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(oid, 'SELECT, INSERT, UPDATE, REFERENCES'::text)))
10. 0.001 0.135 ↑ 1.0 1 1

Hash (cost=11.16..11.16 rows=1 width=4) (actual time=0.135..0.135 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
11. 0.134 0.134 ↑ 1.0 1 1

Seq Scan on pg_namespace nc (cost=0.00..11.16 rows=1 width=4) (actual time=0.117..0.134 rows=1 loops=1)

  • Filter: ((NOT pg_is_other_temp_schema(oid)) AND (((nspname)::information_schema.sql_identifier)::text = 'public'::text))
Total runtime : 11.578 ms