explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f21E

Settings
# exclusive inclusive rows x rows loops node
1. 11.494 11.723 ↓ 2.0 2 1

GroupAggregate (cost=22.82..22.91 rows=1 width=284) (actual time=11.719..11.723 rows=2 loops=1)

  • Group Key: c.oid, n.nspname, c.relname
2. 0.017 0.229 ↓ 7.0 7 1

Sort (cost=22.82..22.82 rows=1 width=136) (actual time=0.227..0.229 rows=7 loops=1)

  • Sort Key: c.oid, n.nspname
  • Sort Method: quicksort Memory: 26kB
3. 0.005 0.212 ↓ 7.0 7 1

Nested Loop Left Join (cost=11.97..22.81 rows=1 width=136) (actual time=0.156..0.212 rows=7 loops=1)

4. 0.025 0.165 ↓ 2.0 2 1

Hash Join (cost=11.69..14.50 rows=1 width=132) (actual time=0.135..0.165 rows=2 loops=1)

  • Hash Cond: (n.oid = c.relnamespace)
5. 0.088 0.088 ↑ 1.1 40 1

Seq Scan on pg_namespace n (cost=0.00..2.69 rows=42 width=68) (actual time=0.022..0.088 rows=40 loops=1)

  • Filter: ((nspname <> ALL ('{pg_catalog,information_schema}'::name[])) AND (nspname !~ '^pg_toast'::text))
  • Rows Removed by Filter: 6
6. 0.004 0.052 ↓ 2.0 2 1

Hash (cost=11.68..11.68 rows=1 width=72) (actual time=0.052..0.052 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.032 0.048 ↓ 2.0 2 1

Bitmap Heap Scan on pg_class c (cost=4.30..11.68 rows=1 width=72) (actual time=0.036..0.048 rows=2 loops=1)

  • Recheck Cond: (relname = 'lotacao'::name)
  • Filter: (relkind = ANY ('{r,t,m}'::char[]))
  • Heap Blocks: exact=2
8. 0.016 0.016 ↑ 1.0 2 1

Bitmap Index Scan on pg_class_relname_nsp_index (cost=0.00..4.30 rows=2 width=0) (actual time=0.016..0.016 rows=2 loops=1)

  • Index Cond: (relname = 'lotacao'::name)
9. 0.042 0.042 ↓ 4.0 4 2

Index Scan using pg_index_indrelid_index on pg_index i (cost=0.28..8.30 rows=1 width=8) (actual time=0.015..0.021 rows=4 loops=2)

  • Index Cond: (c.oid = indrelid)