explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7muY

Settings
# exclusive inclusive rows x rows loops node
1. 0.057 0.636 ↓ 5.9 47 1

Sort (cost=67.07..67.09 rows=8 width=275) (actual time=0.632..0.636 rows=47 loops=1)

  • Sort Key: c.nspname, c.relname, c.attnum
  • Sort Method: quicksort Memory: 37kB
2. 0.031 0.579 ↓ 5.9 47 1

Subquery Scan on c (cost=66.33..66.95 rows=8 width=275) (actual time=0.500..0.579 rows=47 loops=1)

  • Filter: (c.attname ~~ '%'::text)
3. 0.060 0.548 ↓ 5.9 47 1

WindowAgg (cost=66.33..66.69 rows=8 width=641) (actual time=0.499..0.548 rows=47 loops=1)

4. 0.063 0.488 ↓ 5.9 47 1

Sort (cost=66.33..66.35 rows=8 width=641) (actual time=0.483..0.488 rows=47 loops=1)

  • Sort Key: a.attrelid, a.attnum
  • Sort Method: quicksort Memory: 37kB
5. 0.033 0.425 ↓ 5.9 47 1

Nested Loop Left Join (cost=1.94..66.21 rows=8 width=641) (actual time=0.068..0.425 rows=47 loops=1)

  • Join Filter: (a.attnum = dsc.objsubid)
6. 0.041 0.345 ↓ 5.9 47 1

Nested Loop Left Join (cost=1.65..31.39 rows=8 width=618) (actual time=0.061..0.345 rows=47 loops=1)

7. 0.008 0.257 ↓ 5.9 47 1

Nested Loop (cost=1.38..28.58 rows=8 width=219) (actual time=0.056..0.257 rows=47 loops=1)

8. 0.014 0.108 ↓ 5.9 47 1

Nested Loop (cost=1.10..25.63 rows=8 width=213) (actual time=0.048..0.108 rows=47 loops=1)

9. 0.004 0.051 ↑ 1.0 1 1

Nested Loop (cost=0.68..8.80 rows=1 width=132) (actual time=0.031..0.051 rows=1 loops=1)

  • Join Filter: (n.oid = c_1.relnamespace)
10. 0.016 0.016 ↑ 1.0 1 1

Index Scan using pg_namespace_nspname_index on pg_namespace n (cost=0.27..4.31 rows=1 width=68) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: ((nspname >= 'operations'::name) AND (nspname < 'operationt'::name))
  • Filter: (nspname ~~ 'operations_dm'::text)
11. 0.031 0.031 ↑ 1.0 1 1

Index Scan using pg_class_relname_nsp_index on pg_class c_1 (cost=0.41..4.45 rows=1 width=72) (actual time=0.012..0.031 rows=1 loops=1)

  • Index Cond: ((relname >= 'worker'::name) AND (relname < 'workes'::name))
  • Filter: (relname ~~ 'worker_data'::text)
  • Rows Removed by Filter: 17
12. 0.043 0.043 ↓ 5.2 47 1

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a (cost=0.42..16.57 rows=9 width=81) (actual time=0.015..0.043 rows=47 loops=1)

  • Index Cond: ((attrelid = c_1.oid) AND (attnum > 0))
  • Filter: (NOT attisdropped)
  • Rows Removed by Filter: 2
13. 0.141 0.141 ↑ 1.0 1 47

Index Scan using pg_type_oid_index on pg_type t (cost=0.28..0.34 rows=1 width=10) (actual time=0.003..0.003 rows=1 loops=47)

  • Index Cond: (oid = a.atttypid)
14. 0.047 0.047 ↓ 0.0 0 47

Index Scan using pg_attrdef_adrelid_adnum_index on pg_attrdef def (cost=0.28..0.32 rows=1 width=401) (actual time=0.001..0.001 rows=0 loops=47)

  • Index Cond: ((a.attrelid = adrelid) AND (a.attnum = adnum))
15. 0.047 0.047 ↓ 0.0 0 47

Index Scan using pg_description_o_c_o_index on pg_description dsc (cost=0.28..4.32 rows=1 width=39) (actual time=0.001..0.001 rows=0 loops=47)

  • Index Cond: (c_1.oid = objoid)