explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BD1p

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 5.685 ↓ 3.0 3 1

Result (cost=1.51..35.30 rows=1 width=1,156) (actual time=5.333..5.685 rows=3 loops=1)

  • One-Time Filter: (((current_database())::information_schema.sql_identifier)::text = 'number_ordering'::text)
2. 2.290 5.678 ↓ 3.0 3 1

Nested Loop Left Join (cost=1.51..35.30 rows=1 width=1,156) (actual time=5.327..5.678 rows=3 loops=1)

3. 0.002 0.235 ↓ 3.0 3 1

Nested Loop (cost=1.24..29.17 rows=1 width=1,521) (actual time=0.157..0.235 rows=3 loops=1)

4. 0.005 0.227 ↓ 3.0 3 1

Nested Loop Left Join (cost=1.11..29.01 rows=1 width=1,461) (actual time=0.155..0.227 rows=3 loops=1)

5. 0.004 0.216 ↓ 3.0 3 1

Nested Loop Left Join (cost=0.96..28.82 rows=1 width=1,429) (actual time=0.153..0.216 rows=3 loops=1)

  • Join Filter: (t.typtype = 'd'::"char")
6. 0.002 0.209 ↓ 3.0 3 1

Nested Loop (cost=0.55..28.32 rows=1 width=1,295) (actual time=0.150..0.209 rows=3 loops=1)

7. 0.003 0.195 ↓ 3.0 3 1

Nested Loop (cost=0.28..28.01 rows=1 width=439) (actual time=0.145..0.195 rows=3 loops=1)

8. 0.003 0.166 ↑ 1.0 1 1

Nested Loop (cost=0.00..23.17 rows=1 width=137) (actual time=0.123..0.166 rows=1 loops=1)

  • Join Filter: (c.relnamespace = nc.oid)
9. 0.120 0.120 ↑ 1.0 1 1

Seq Scan on pg_class c (cost=0.00..22.06 rows=1 width=77) (actual time=0.105..0.120 rows=1 loops=1)

  • Filter: ((relkind = ANY ('{r,v,f}'::""char""[])) AND (((relname)::information_schema.sql_identifier)::text = 'somos_replenisher_search_cache'::text))
  • Rows Removed by Filter: 448
10. 0.043 0.043 ↑ 1.0 1 1

Seq Scan on pg_namespace nc (cost=0.00..1.10 rows=1 width=68) (actual time=0.016..0.043 rows=1 loops=1)

  • Filter: ((NOT pg_is_other_temp_schema(oid)) AND (((nspname)::information_schema.sql_identifier)::text = 'public'::text))
  • Rows Removed by Filter: 17
11. 0.026 0.026 ↑ 1.0 3 1

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a (cost=0.28..4.81 rows=3 width=306) (actual time=0.020..0.026 rows=3 loops=1)

  • Index Cond: ((attrelid = c.oid) AND (attnum > 0))
  • Filter: ((NOT attisdropped) AND (pg_has_role(c.relowner, 'USAGE'::text) OR has_column_privilege(c.oid, attnum, 'SELECT, INSERT, UPDATE, REFERENCES'::text)))
12. 0.012 0.012 ↑ 1.0 1 3

Index Scan using pg_type_oid_index on pg_type t (cost=0.27..0.30 rows=1 width=860) (actual time=0.004..0.004 rows=1 loops=3)

  • Index Cond: (oid = a.atttypid)
13. 0.000 0.003 ↓ 0.0 0 3

Nested Loop (cost=0.41..0.49 rows=1 width=138) (actual time=0.001..0.001 rows=0 loops=3)

14. 0.003 0.003 ↓ 0.0 0 3

Index Scan using pg_type_oid_index on pg_type bt (cost=0.27..0.32 rows=1 width=78) (actual time=0.001..0.001 rows=0 loops=3)

  • Index Cond: (t.typbasetype = oid)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using pg_namespace_oid_index on pg_namespace nbt (cost=0.13..0.16 rows=1 width=68) (never executed)

  • Index Cond: (oid = bt.typnamespace)
16. 0.006 0.006 ↑ 1.0 1 3

Index Scan using pg_attrdef_adrelid_adnum_index on pg_attrdef ad (cost=0.15..0.17 rows=1 width=38) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: ((a.attrelid = adrelid) AND (a.attnum = adnum))
17. 0.006 0.006 ↑ 1.0 1 3

Index Scan using pg_namespace_oid_index on pg_namespace nt (cost=0.13..0.16 rows=1 width=68) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (oid = t.typnamespace)
18. 0.003 3.153 ↓ 0.0 0 3

Nested Loop (cost=0.27..0.74 rows=1 width=132) (actual time=1.051..1.051 rows=0 loops=3)

19. 3.141 3.141 ↓ 0.0 0 3

Index Scan using pg_collation_oid_index on pg_collation co (cost=0.13..0.15 rows=1 width=72) (actual time=1.047..1.047 rows=0 loops=3)

  • Index Cond: (a.attcollation = oid)
20. 0.009 0.009 ↓ 0.0 0 1

Index Scan using pg_namespace_oid_index on pg_namespace nco (cost=0.13..0.58 rows=1 width=68) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (oid = co.collnamespace)
  • Filter: ((nspname <> 'pg_catalog'::name) OR (co.collname <> 'default'::name))
  • Rows Removed by Filter: 1
Planning time : 5.082 ms
Execution time : 6.021 ms