explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jPxwT

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=436.83..439.62 rows=1,115 width=136) (actual rows= loops=)

  • Sort Key: pg_stat_all_tables.last_analyze DESC
2. 0.000 0.000 ↓ 0.0

Subquery Scan on pg_stat_all_tables (cost=355.31..380.40 rows=1,115 width=136) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=355.31..369.25 rows=1,115 width=284) (actual rows= loops=)

  • Group Key: c.oid, n.nspname, c.relname
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=235.78..346.95 rows=1,115 width=132) (actual rows= loops=)

  • Hash Cond: (c.relnamespace = n.oid)
5. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=233.92..329.76 rows=1,115 width=72) (actual rows= loops=)

  • Hash Cond: (i.indrelid = c.oid)
6. 0.000 0.000 ↓ 0.0

Index Only Scan using pg_index_indrelid_index on pg_index i (cost=0.28..80.12 rows=2,656 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=219.71..219.71 rows=1,115 width=72) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on pg_class c (cost=0.00..219.71 rows=1,115 width=72) (actual rows= loops=)

  • Filter: ((relname !~~ 'pg_toast%'::text) AND (relkind = ANY ('{r,t,m}'::"char"[])))
9. 0.000 0.000 ↓ 0.0

Hash (cost=1.38..1.38 rows=38 width=68) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on pg_namespace n (cost=0.00..1.38 rows=38 width=68) (actual rows= loops=)