explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yObG : Optimization for: plan #5BJP

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.061 36,132.467 ↑ 1.0 100 1

Limit (cost=1,001.15..2,934.89 rows=100 width=80) (actual time=1,038.835..36,132.467 rows=100 loops=1)

2. 5,170.303 36,132.406 ↑ 201.9 100 1

Gather Merge (cost=1,001.15..391,364.20 rows=20,187 width=80) (actual time=1,038.833..36,132.406 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.330 30,962.103 ↑ 233.6 36 3 / 3

Nested Loop (cost=1.13..388,034.10 rows=8,411 width=80) (actual time=608.828..30,962.103 rows=36 loops=3)

4. 0.259 30,961.305 ↑ 233.6 36 3 / 3

Nested Loop (cost=0.98..386,667.83 rows=8,411 width=66) (actual time=608.761..30,961.305 rows=36 loops=3)

5. 29,943.794 29,943.794 ↑ 233.6 36 3 / 3

Parallel Index Scan using org_company_legal_name_0bc0425c on org_company (cost=0.55..342,026.79 rows=8,411 width=59) (actual time=571.538..29,943.794 rows=36 loops=3)

  • Filter: (search_vector @@ plainto_tsquery('international'::text))
  • Rows Removed by Filter: 10,397
6. 1,017.252 1,017.252 ↑ 1.0 1 108 / 3

Index Scan using shared_address_pkey on shared_address (cost=0.43..5.31 rows=1 width=7) (actual time=28.257..28.257 rows=1 loops=108)

  • Index Cond: (id = org_company.legal_address_id)
7. 0.468 0.468 ↑ 1.0 1 108 / 3

Index Scan using shared_country_alpha2_9e8fb7dd_like on shared_country (cost=0.14..0.16 rows=1 width=14) (actual time=0.013..0.013 rows=1 loops=108)

  • Index Cond: ((alpha2)::text = (shared_address.country_id)::text)
Planning time : 150.530 ms
Execution time : 36,132.694 ms