explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K3Lh

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.010 ↑ 1.0 1 1

Aggregate (cost=29.39..29.40 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=1)

2. 0.002 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on posts_post (cost=8.73..29.38 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((published_at IS NULL) OR (published_at <= '2020-08-05 03:50:08.871058+00'::timestamp with time zone))
  • Filter: ((to_tsvector(COALESCE(content, ''::text)) @@ plainto_tsquery('caterpillar'::text)) OR (similarity((title)::text, 'caterpillar'::text) >= '0.25'::double precision) OR (to_tsvector(COALESCE(search_terms, ''::text)) @@ plainto_tsquery('caterpillar'::text)))
3. 0.001 0.005 ↓ 0.0 0 1

BitmapOr (cost=8.73..8.73 rows=10 width=0) (actual time=0.005..0.005 rows=0 loops=1)

4. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on posts_post_collection_id_slug_status_published_at_676a712c_idx (cost=0.00..4.36 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (published_at IS NULL)
5. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on posts_post_collection_id_slug_status_published_at_676a712c_idx (cost=0.00..4.36 rows=10 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (published_at <= '2020-08-05 03:50:08.871058+00'::timestamp with time zone)
Planning time : 2.509 ms
Execution time : 0.663 ms