explain.depesz.com

PostgreSQL's explain analyze made readable

Result: beCX

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.439 ↑ 1.0 10 1

Limit (cost=0.42..416.62 rows=10 width=295) (actual time=0.128..0.439 rows=10 loops=1)

  • Output: task_search.id, task_search.task_id, task_search.search_type, task_search.client_id, task_search.archived, task_search.document, task_search.document_vector, query.query
  • Buffers: shared hit=77
2. 0.325 0.435 ↑ 7.3 10 1

Nested Loop (cost=0.42..3,038.63 rows=73 width=295) (actual time=0.127..0.435 rows=10 loops=1)

  • Output: task_search.id, task_search.task_id, task_search.search_type, task_search.client_id, task_search.archived, task_search.document, task_search.document_vector, query.query
  • Join Filter: (task_search.document_vector @@ query.query)
  • Rows Removed by Join Filter: 68
  • Buffers: shared hit=77
3. 0.004 0.004 ↑ 1.0 1 1

Function Scan on query (cost=0.00..0.01 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=1)

  • Output: query.query
  • Function Call: '''0'':*'::tsquery
4. 0.106 0.106 ↑ 186.4 78 1

Index Scan using task_search_search_type_idx on public.task_search (cost=0.42..2,856.83 rows=14,543 width=263) (actual time=0.052..0.106 rows=78 loops=1)

  • Output: task_search.id, task_search.task_id, task_search.search_type, task_search.client_id, task_search.archived, task_search.document, task_search.document_vector
  • Index Cond: (task_search.search_type = 1)
  • Buffers: shared hit=15
Planning time : 0.322 ms
Execution time : 0.516 ms