explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1jJX

Settings
# exclusive inclusive rows x rows loops node
1. 363.904 11,006.454 ↑ 1.0 1 1

Aggregate (cost=592,084.92..592,084.93 rows=1 width=8) (actual time=11,006.453..11,006.454 rows=1 loops=1)

2. 144.584 10,642.550 ↓ 11.8 1,301,913 1

Gather (cost=1,001.12..591,808.05 rows=110,745 width=4) (actual time=0.556..10,642.550 rows=1,301,913 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 186.398 10,497.966 ↓ 9.4 433,971 3 / 3

Nested Loop Semi Join (cost=1.12..579,733.55 rows=46,144 width=4) (actual time=0.444..10,497.966 rows=433,971 loops=3)

4. 1.223 8,138.995 ↓ 9.4 434,515 3 / 3

Nested Loop Semi Join (cost=0.56..540,755.11 rows=46,144 width=8) (actual time=0.372..8,138.995 rows=434,515 loops=3)

5. 6,397.428 6,397.428 ↑ 1.2 435,086 3 / 3

Parallel Seq Scan on screening_applicants sa (cost=0.00..240,808.33 rows=509,427 width=8) (actual time=0.273..6,397.428 rows=435,086 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,437,661
6. 1,740.344 1,740.344 ↑ 37.0 1 1,305,258 / 3

Index Only Scan using screening_transactions_screening_applicant_id_idx on screening_transactions st (cost=0.56..1.40 rows=37 width=4) (actual time=0.004..0.004 rows=1 loops=1,305,258)

  • Index Cond: (screening_applicant_id = sa.id)
  • Heap Fetches: 59,840
7. 434.515 2,172.573 ↑ 1.0 1 1,303,544 / 3

Nested Loop (cost=0.56..0.83 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=1,303,544)

8. 1,303.544 1,303.544 ↑ 1.0 1 1,303,544 / 3

Index Scan using pk_screenings on screenings s (cost=0.43..0.68 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1,303,544)

  • Index Cond: (id = sa.screening_id)
9. 434.515 434.515 ↑ 1.0 1 1,303,544 / 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=1,303,544)

  • Index Cond: (id = s.screening_recommendation_type_id)
  • Heap Fetches: 1,301,913
Planning time : 2.332 ms
Execution time : 11,055.377 ms