explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Pvad

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 0.110 ↑ 1.7 3 1

Sort (cost=26.83..26.84 rows=5 width=136) (actual time=0.110..0.110 rows=3 loops=1)

  • Sort Key: pg_attribute.attnum
  • Sort Method: quicksort Memory: 25kB
  • Planning time: 0.550 ms
  • Execution time: 0.219 ms
2. 0.003 0.087 ↑ 1.7 3 1

Nested Loop Left Join (cost=0.85..26.77 rows=5 width=136) (actual time=0.072..0.087 rows=3 loops=1)

3. 0.004 0.063 ↑ 1.7 3 1

Nested Loop (cost=0.57..25.13 rows=5 width=76) (actual time=0.057..0.063 rows=3 loops=1)

4. 0.035 0.035 ↑ 1.0 1 1

Index Scan using pg_class_relname_nsp_index on pg_class (cost=0.28..8.30 rows=1 width=8) (actual time=0.034..0.035 rows=1 loops=1)

  • Index Cond: (relname = 'users_status'::name)
5. 0.024 0.024 ↑ 1.7 3 1

Index Scan using pg_attribute_relid_attnum_index on pg_attribute (cost=0.29..16.78 rows=5 width=80) (actual time=0.019..0.024 rows=3 loops=1)

  • Index Cond: ((attrelid = pg_class.oid) AND (attnum > 0))
  • Filter: (NOT attisdropped)
6. 0.021 0.021 ↑ 1.0 1 3

Index Scan using pg_type_oid_index on pg_type (cost=0.28..0.33 rows=1 width=68) (actual time=0.007..0.007 rows=1 loops=3)

  • Index Cond: (pg_attribute.atttypid = oid)