explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G2q5T

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

GroupAggregate (cost=98,575.63..100,809.66 rows=18,237 width=212) (actual rows= loops=)

  • Group Key: (count(request.shomare_parvande)), cc.field, e.role_id, e.name, e.family, e.national_code
2. 0.000 0.000 ↓ 0.0

Sort (cost=98,575.63..98,621.22 rows=18,237 width=76) (actual rows= loops=)

  • Sort Key: (count(request.shomare_parvande)) DESC, cc.field, e.role_id, e.name, e.family, e.national_code
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=56,104.55..96,472.95 rows=18,237 width=76) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=56,104.12..93,187.77 rows=3,025 width=68) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=56,103.83..92,230.47 rows=3,029 width=76) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=56,103.40..56,431.45 rows=43 width=68) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=56,103.13..56,418.17 rows=43 width=60) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=56,102.84..56,104.52 rows=42 width=16) (actual rows= loops=)

  • Group Key: request.validator_id
9. 0.000 0.000 ↓ 0.0

Sort (cost=56,102.84..56,103.26 rows=168 width=16) (actual rows= loops=)

  • Sort Key: request.validator_id
10. 0.000 0.000 ↓ 0.0

Gather (cost=56,079.41..56,096.63 rows=168 width=16) (actual rows= loops=)

  • Workers Planned: 4
11. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=55,079.41..55,079.83 rows=42 width=16) (actual rows= loops=)

  • Group Key: request.validator_id
12. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on request (cost=0.00..53,414.15 rows=333,052 width=14) (actual rows= loops=)

  • Filter: (delete_date = '0'::numeric)
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=44) (actual rows= loops=)

  • Index Cond: (national_code = request.validator_id)
14. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = e.province_id)
15. 0.000 0.000 ↓ 0.0

Index Scan using idx_validator_copy1 on request r (cost=0.43..560.27 rows=27,227 width=24) (actual rows= loops=)

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

Index Scan using union_pkey on ""union"" u (cost=0.29..0.31 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = r.union_id)
  • Filter: (delete_date = '0'::numeric)
17. 0.000 0.000 ↓ 0.0

Index Scan using idx_req_isnow on map_req_status mrs (cost=0.43..1.02 rows=7 width=16) (actual rows= loops=)

  • Index Cond: (req_id = r.id)
  • Filter: (delete_date = '0'::numeric)