explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ntaB

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.421 ↓ 10.0 10 1

Limit (cost=0.42..4.46 rows=1 width=289) (actual time=0.111..0.421 rows=10 loops=1)

2. 0.309 0.417 ↓ 10.0 10 1

Nested Loop (cost=0.42..4.46 rows=1 width=289) (actual time=0.110..0.417 rows=10 loops=1)

  • Join Filter: (task_search.document_vector @@ query.query)
  • Rows Removed by Join Filter: 68
3. 0.108 0.108 ↓ 78.0 78 1

Index Scan using task_search_search_type_idx on task_search (cost=0.42..4.44 rows=1 width=257) (actual time=0.023..0.108 rows=78 loops=1)

  • Index Cond: (search_type = 1)
4. 0.000 0.000 ↑ 1.0 1 78

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

Planning time : 1.743 ms
Execution time : 0.476 ms