explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ea5h

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,433.374 ↑ 1.0 1 1

Finalize Aggregate (cost=156,205.11..156,205.12 rows=1 width=8) (actual time=1,433.374..1,433.374 rows=1 loops=1)

2. 23.745 1,440.606 ↓ 1.5 3 1

Gather (cost=156,204.90..156,205.11 rows=2 width=8) (actual time=1,433.264..1,440.606 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.012 1,416.861 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=155,204.90..155,204.91 rows=1 width=8) (actual time=1,416.861..1,416.861 rows=1 loops=3)

4. 0.005 1,416.849 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.43..155,204.08 rows=328 width=0) (actual time=1,416.849..1,416.849 rows=0 loops=3)

5. 1,416.844 1,416.844 ↓ 0.0 0 3 / 3

Parallel Seq Scan on search_documents (cost=0.00..136,470.83 rows=3,000 width=8) (actual time=1,416.844..1,416.844 rows=0 loops=3)

  • Filter: (((searchable_type)::text = 'Customer'::text) AND ((tsvector @@ '''nak'' & ''tw30'''::tsquery) OR (fuzzy_search_string ~~ '%nak tw30%'::citext)))
  • Rows Removed by Filter: 766988
6. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using customers_pkey on customers (cost=0.43..6.24 rows=1 width=8) (never executed)

  • Index Cond: (id = search_documents.searchable_id)
  • Filter: ((deleted_at IS NULL) AND (seller_id = 22))
Planning time : 0.611 ms
Execution time : 1,440.864 ms