explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DzWV

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 312.416 ↑ 1.0 100 1

Limit (cost=1,001.15..8,789.77 rows=100 width=80) (actual time=105.729..312.416 rows=100 loops=1)

2. 38.765 312.387 ↑ 45.8 100 1

Gather Merge (cost=1,001.15..357,953.67 rows=4,583 width=80) (actual time=105.727..312.387 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.117 273.622 ↑ 54.6 35 3 / 3

Nested Loop (cost=1.13..356,424.65 rows=1,910 width=80) (actual time=98.210..273.622 rows=35 loops=3)

4. 0.121 273.293 ↑ 54.6 35 3 / 3

Nested Loop (cost=0.98..356,114.40 rows=1,910 width=66) (actual time=98.179..273.293 rows=35 loops=3)

5. 169.257 169.257 ↑ 54.6 35 3 / 3

Parallel Index Scan using org_company_legal_name_0bc0425c on org_company (cost=0.55..342,026.79 rows=1,910 width=59) (actual time=91.098..169.257 rows=35 loops=3)

  • Filter: (search_vector @@ plainto_tsquery('investors'::text))
  • Rows Removed by Filter: 5744
6. 103.915 103.915 ↑ 1.0 1 106 / 3

Index Scan using shared_address_pkey on shared_address (cost=0.43..7.38 rows=1 width=7) (actual time=2.941..2.941 rows=1 loops=106)

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

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

  • Index Cond: ((alpha2)::text = (shared_address.country_id)::text)
Planning time : 14.252 ms
Execution time : 320.743 ms