explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vLD

Settings
# exclusive inclusive rows x rows loops node
1. 0.650 28.626 ↑ 1.0 1 1

Aggregate (cost=1,429.83..1,429.84 rows=1 width=8) (actual time=28.625..28.626 rows=1 loops=1)

2. 4.250 27.976 ↓ 1.1 7,478 1

Merge Join (cost=0.57..1,412.69 rows=6,855 width=0) (actual time=0.108..27.976 rows=7,478 loops=1)

  • Merge Cond: (pg_class.oid = pg_index.indrelid)
3. 10.631 10.631 ↑ 1.0 22,399 1

Index Only Scan using pg_class_oid_index on pg_class (cost=0.29..812.57 rows=22,399 width=4) (actual time=0.054..10.631 rows=22,399 loops=1)

  • Heap Fetches: 11625
4. 13.095 13.095 ↓ 1.1 7,478 1

Index Scan using pg_index_indrelid_index on pg_index (cost=0.29..458.43 rows=6,855 width=4) (actual time=0.023..13.095 rows=7,478 loops=1)

  • Filter: indisunique
  • Rows Removed by Filter: 2009