explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uiK8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=451,879,138,859.01..451,879,138,859.02 rows=1 width=8) (actual rows= loops=)

  • JIT:
  • Functions: 48
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
2.          

CTE russian_areas

3. 0.000 0.000 ↓ 0.0

Recursive Union (cost=0.06..279.21 rows=3,701 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Only Scan using area_pk on area (cost=0.06..0.18 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (area_id = 113)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.06..20.50 rows=370 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

WorkTable Scan on russian_areas russian_areas_1 (cost=0.00..0.20 rows=10 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using area_priority_indx on area area_1 (cost=0.06..1.66 rows=37 width=8) (actual rows= loops=)

  • Index Cond: (parent_id = russian_areas_1.area_id)
8. 0.000 0.000 ↓ 0.0

Merge Join (cost=150,067,687.22..7,183,419,749.69 rows=889,391,437,660,224 width=4) (actual rows= loops=)

  • Merge Cond: (r.area_id = russian_areas.area_id)
9. 0.000 0.000 ↓ 0.0

Sort (cost=1,996,157.36..2,010,436.40 rows=28,558,083 width=8) (actual rows= loops=)

  • Sort Key: r.area_id
10. 0.000 0.000 ↓ 0.0

Gather (cost=42,142.45..1,265,979.03 rows=28,558,083 width=8) (actual rows= loops=)

  • Workers Planned: 8
11. 0.000 0.000 ↓ 0.0

Parallel Hash Anti Join (cost=42,042.45..980,298.20 rows=3,569,760 width=8) (actual rows= loops=)

  • Hash Cond: (r.user_id = ebl.user_id)
12. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on resume r (cost=0.00..900,683.54 rows=3,569,781 width=8) (actual rows= loops=)

  • Filter: ((user_id IS NOT NULL) AND (NOT disabled) AND (is_finished = ANY ('{1,2,9}'::integer[])) AND (access_type = ANY ('{1,2,3,5}'::integer[])))
13. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=42,041.51..42,041.51 rows=90 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on employer_black_list ebl (cost=0.00..42,041.51 rows=90 width=4) (actual rows= loops=)

  • Filter: (employer_id = 362)
15. 0.000 0.000 ↓ 0.0

Materialize (cost=148,071,529.86..148,138,857.63 rows=67,327,776 width=4) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Sort (cost=148,071,529.86..148,105,193.75 rows=67,327,776 width=4) (actual rows= loops=)

  • Sort Key: russian_areas.area_id
17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=75.87..146,266,776.34 rows=67,327,776 width=4) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

HashAggregate (cost=75.87..77.87 rows=200 width=4) (actual rows= loops=)

  • Group Key: russian_areas.area_id
19. 0.000 0.000 ↓ 0.0

CTE Scan on russian_areas (cost=0.00..74.02 rows=3,701 width=4) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..986,757.76 rows=67,327,776 width=0) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on hhuser u (cost=0.00..899,704.99 rows=67,327,776 width=0) (actual rows= loops=)

  • Filter: (type = 0)