explain.depesz.com

PostgreSQL's explain analyze made readable

Result: az1E

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

Nested Loop (cost=458,599.80..458,926.60 rows=41 width=173) (actual rows= loops=)

2.          

CTE validator_status_request_count

3. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=458,591.47..458,599.24 rows=42 width=104) (actual rows= loops=)

  • Group Key: r.validator_id
4. 0.000 0.000 ↓ 0.0

Sort (cost=458,591.47..458,591.99 rows=210 width=104) (actual rows= loops=)

  • Sort Key: r.validator_id
5. 0.000 0.000 ↓ 0.0

Gather (cost=458,561.95..458,583.37 rows=210 width=104) (actual rows= loops=)

  • Workers Planned: 5
6. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=457,561.95..457,562.37 rows=42 width=104) (actual rows= loops=)

  • Group Key: r.validator_id
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=89,061.20..317,029.51 rows=1,606,085 width=177) (actual rows= loops=)

  • Hash Cond: (mrs.req_id = r.id)
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on map_req_status mrs (cost=0.00..120,955.64 rows=1,606,085 width=169) (actual rows= loops=)

  • Filter: (delete_date = '0'::numeric)
9. 0.000 0.000 ↓ 0.0

Hash (cost=65,903.60..65,903.60 rows=1,332,208 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on request r (cost=0.00..65,903.60 rows=1,332,208 width=16) (actual rows= loops=)

  • Filter: (delete_date = '0'::numeric)
11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..314.18 rows=41 width=135) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

CTE Scan on validator_status_request_count vsrc (cost=0.00..0.84 rows=42 width=128) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using idx_emp_national_code on employee e (cost=0.29..7.45 rows=1 width=39) (actual rows= loops=)

  • Index Cond: (national_code = vsrc.validator_id)
  • Filter: (delete_date = '0'::numeric)
14. 0.000 0.000 ↓ 0.0

Index Scan using idx_ide on combos c (cost=0.28..0.30 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = e.province_id)
  • Filter: (delete_date = '0'::numeric)