explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fYvU : Optimization for: plan #O5Ye

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 4,551.134 ↑ 1.0 1 1

Aggregate (cost=276,677.10..276,677.11 rows=1 width=8) (actual time=4,551.133..4,551.134 rows=1 loops=1)

2. 125.601 4,633.759 ↓ 12.4 95,834 1

Gather (cost=1,001.12..276,657.82 rows=7,712 width=4) (actual time=1.059..4,633.759 rows=95,834 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 21.004 4,508.158 ↓ 9.9 31,945 3 / 3

Nested Loop Semi Join (cost=1.12..274,886.62 rows=3,213 width=4) (actual time=0.834..4,508.158 rows=31,945 loops=3)

4. 22.902 4,071.310 ↓ 10.0 31,988 3 / 3

Nested Loop Semi Join (cost=0.56..263,898.58 rows=3,213 width=8) (actual time=0.599..4,071.310 rows=31,988 loops=3)

5. 3,792.293 3,792.293 ↑ 1.1 32,014 3 / 3

Parallel Seq Scan on screening_applicants sa (cost=0.00..240,808.33 rows=35,478 width=8) (actual time=0.510..3,792.293 rows=32,014 loops=3)

  • Filter: (((name_first)::text ~ '^(?:\\.*(?:Theodore|J|Thomas)\\.*)$'::text) OR ((name_middle)::text ~ '^(?:\\.*(?:Theodore|J|Thomas)\\.*)$'::text) OR ((name_last)::text ~ '^(?:\\.*(?:Theodore|J|Thomas)\\.*)$'::text))
  • Rows Removed by Filter: 1,840,732
6. 256.115 256.115 ↑ 37.0 1 96,043 / 3

Index Only Scan using screening_transactions_screening_applicant_id_idx on screening_transactions st (cost=0.56..3.51 rows=37 width=4) (actual time=0.008..0.008 rows=1 loops=96,043)

  • Index Cond: (screening_applicant_id = sa.id)
  • Heap Fetches: 4,810
7. 31.988 415.844 ↑ 1.0 1 95,964 / 3

Nested Loop (cost=0.56..3.41 rows=1 width=4) (actual time=0.013..0.013 rows=1 loops=95,964)

8. 351.868 351.868 ↑ 1.0 1 95,964 / 3

Index Scan using pk_screenings on screenings s (cost=0.43..3.25 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=95,964)

  • Index Cond: (id = sa.screening_id)
9. 31.988 31.988 ↑ 1.0 1 95,964 / 3

Index Only Scan using pk_screening_decision_types on screening_recommendation_types srt (cost=0.13..0.15 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=95,964)

  • Index Cond: (id = s.screening_recommendation_type_id)
  • Heap Fetches: 95,834
Planning time : 1.757 ms
Execution time : 4,663.241 ms