explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gQ8

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

Sort (cost=75,088.95..75,127.77 rows=15,528 width=88) (actual rows= loops=)

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

Subquery Scan on pg_stat_all_tables (cost=73,425.71..74,008.01 rows=15,528 width=88) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=73,425.71..73,736.27 rows=15,528 width=136) (actual rows= loops=)

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

Hash Left Join (cost=1,706.47..73,231.61 rows=15,528 width=136) (actual rows= loops=)

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

Hash Join (cost=89.45..71,095.60 rows=15,528 width=132) (actual rows= loops=)

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

Seq Scan on pg_class c (cost=0.00..70,756.02 rows=25,294 width=72) (actual rows= loops=)

  • Filter: (relkind = ANY ('{r,t,m}'::"char"[]))
7. 0.000 0.000 ↓ 0.0

Hash (cost=85.92..85.92 rows=283 width=68) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

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

  • Filter: ((nspname <> ALL ('{pg_catalog,information_schema}'::name[])) AND (nspname !~ '^pg_toast'::text))
9. 0.000 0.000 ↓ 0.0

Hash (cost=1,258.12..1,258.12 rows=28,712 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on pg_index i (cost=0.00..1,258.12 rows=28,712 width=8) (actual rows= loops=)