explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LH1C : un13

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2,570.824 ↓ 0.0 0 1

Limit (cost=0.56..261,283.40 rows=10 width=73) (actual time=2,570.824..2,570.824 rows=0 loops=1)

2. 2,570.821 2,570.821 ↓ 0.0 0 1

Index Scan using pg_class_relname_nsp_index on pg_class x (cost=0.56..418,053.11 rows=16 width=73) (actual time=2,570.821..2,570.821 rows=0 loops=1)

  • Filter: ((relname ~~* 'registration_system'::text) AND (relnamespace = ANY ('{16416,11}'::oid[])) AND (relkind = ANY ('{r,v,m}'::"char"[])))
  • Rows Removed by Filter: 34996
Planning time : 0.249 ms
Execution time : 2,570.846 ms