explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eTYl

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.211 ↓ 0.0 0 1

Sort (cost=32.83..32.84 rows=1 width=128) (actual time=0.211..0.211 rows=0 loops=1)

  • Sort Key: (ts_rank(to_tsvector('simple'::regconfig, COALESCE(posts_1.description, ''::text)), '''asdad'''::tsquery, 0)) DESC, posts.id
  • Sort Method: quicksort Memory: 25kB
2. 0.001 0.206 ↓ 0.0 0 1

Nested Loop (cost=4.32..32.82 rows=1 width=128) (actual time=0.206..0.206 rows=0 loops=1)

3. 0.003 0.010 ↓ 1.7 5 1

Bitmap Heap Scan on posts (cost=4.17..11.28 rows=3 width=96) (actual time=0.010..0.010 rows=5 loops=1)

  • Recheck Cond: (user_id = 1)
  • Heap Blocks: exact=1
4. 0.007 0.007 ↓ 2.0 6 1

Bitmap Index Scan on index_posts_on_user_id (cost=0.00..4.17 rows=3 width=0) (actual time=0.007..0.007 rows=6 loops=1)

  • Index Cond: (user_id = 1)
5. 0.195 0.195 ↓ 0.0 0 5

Index Scan using posts_pkey on posts posts_1 (cost=0.15..7.09 rows=1 width=40) (actual time=0.039..0.039 rows=0 loops=5)

  • Index Cond: (id = posts.id)
  • Filter: (to_tsvector('simple'::regconfig, COALESCE(description, ''::text)) @@ '''asdad'''::tsquery)
  • Rows Removed by Filter: 1
Planning time : 0.199 ms