explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PLrn

Settings
# exclusive inclusive rows x rows loops node
1. 0.352 0.538 ↓ 3.5 7 1

Nested Loop Left Join (cost=1.63..27.46 rows=2 width=288) (actual time=0.144..0.538 rows=7 loops=1)

  • -> Index Scan using pg_tablespace_oid_index on pg_tablespace t (cost=0.13..0.23 rows=1 width=68) (actual time=0.001..0.001 rows=0 loop
2. 0.004 0.186 ↓ 3.5 7 1

Nested Loop (cost=1.50..27.01 rows=2 width=200) (actual time=0.079..0.186 rows=7 loops=1)

  • Index Cond: (oid = i.reltablespace)
3. 0.023 0.168 ↓ 1.2 7 1

Nested Loop (cost=1.23..23.24 rows=6 width=132) (actual time=0.075..0.168 rows=7 loops=1)

  • -> Index Scan using pg_index_indrelid_index on pg_index x (cost=0.14..0.53 rows=2 width=8) (actual time=0.002..0.002 rows=
4. 0.026 0.145 ↑ 1.5 8 1

Hash Join (cost=1.09..16.66 rows=12 width=132) (actual time=0.028..0.145 rows=8 loops=1)

  • Hash Cond: (c.relnamespace = n.oid)
  • Index Cond: (indrelid = c.oid)
5. 0.114 0.114 ↓ 1.1 78 1

Seq Scan on pg_class c (cost=0.00..15.26 rows=69 width=72) (actual time=0.007..0.114 rows=78 loops=1)

  • Filter: (relkind = ANY ('{r,m}'::"char"[]))
  • Rows Removed by Filter: 293
6. 0.001 0.005 ↑ 1.0 1 1

Hash (cost=1.07..1.07 rows=1 width=68) (actual time=0.005..0.005 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on pg_namespace n (cost=0.00..1.07 rows=1 width=68) (actual time=0.003..0.004 rows=1 loops=1)

  • Filter: (nspname = 'public'::name)
  • Rows Removed by Filter: 6
8. 0.014 0.014 ↑ 1.0 1 7

Index Scan using pg_class_oid_index on pg_class i (cost=0.27..0.63 rows=1 width=72) (actual time=0.002..0.002 rows=1 loops=7)

  • Index Cond: (oid = x.indexrelid)
  • Filter: (relkind = 'i'::"char")
Planning time : 0.552 ms
Execution time : 0.582 ms