explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SmU4 : https://paste.depesz.com/s/pE with index

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.016 ↓ 0.0 0 1

Limit (cost=105.85..107.59 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=1)

2. 0.001 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on domains (cost=71.18..10,913.07 rows=6,254 width=0) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: (to_tsvector('simple'::regconfig, (name)::text) @@ '''00z1iqf9ib6m9yugg1vs'':*'::tsquery)
  • Filter: ((deleted_at IS NULL) AND (parent_id IS NOT NULL) AND (domain_type <> 1))
3. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on depesz_test (cost=0.00..69.62 rows=7,963 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (to_tsvector('simple'::regconfig, (name)::text) @@ '''00z1iqf9ib6m9yugg1vs'':*'::tsquery)