explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vvx1

Settings
# exclusive inclusive rows x rows loops node
1. 0.115 6,900.805 ↓ 1.0 42 1

Nested Loop (cost=458,599.80..458,926.60 rows=41 width=173) (actual time=6,900.062..6,900.805 rows=42 loops=1)

2.          

CTE validator_status_request_count

3. 0.195 6,900.141 ↓ 1.1 45 1

Finalize GroupAggregate (cost=458,591.47..458,599.24 rows=42 width=104) (actual time=6,899.946..6,900.141 rows=45 loops=1)

  • Group Key: r.validator_id
4. 0.000 6,899.946 ↓ 1.3 265 1

Sort (cost=458,591.47..458,591.99 rows=210 width=104) (actual time=6,899.924..6,899.946 rows=265 loops=1)

  • Sort Key: r.validator_id
  • Sort Method: quicksort Memory: 62kB
5. 638.160 6,899.991 ↓ 1.3 265 1

Gather (cost=458,561.95..458,583.37 rows=210 width=104) (actual time=6,899.684..6,899.991 rows=265 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
6. 2,077.824 6,261.831 ↓ 1.0 44 6

Partial HashAggregate (cost=457,561.95..457,562.37 rows=42 width=104) (actual time=6,261.816..6,261.831 rows=44 loops=6)

  • Group Key: r.validator_id
7. 1,927.252 4,184.007 ↑ 1.2 1,369,876 6

Hash Join (cost=89,061.20..317,029.51 rows=1,606,085 width=177) (actual time=1,510.511..4,184.007 rows=1,369,876 loops=6)

  • Hash Cond: (mrs.req_id = r.id)
8. 748.685 748.685 ↑ 1.2 1,369,879 6

Parallel Seq Scan on map_req_status mrs (cost=0.00..120,955.64 rows=1,606,085 width=169) (actual time=0.071..748.685 rows=1,369,879 loops=6)

  • Filter: (delete_date = '0'::numeric)
  • Rows Removed by Filter: 3069
9. 453.115 1,508.070 ↓ 1.0 1,336,350 6

Hash (cost=65,903.60..65,903.60 rows=1,332,208 width=16) (actual time=1,508.070..1,508.070 rows=1,336,350 loops=6)

  • Buckets: 32768 Batches: 64 Memory Usage: 1239kB
10. 1,054.955 1,054.955 ↓ 1.0 1,336,350 6

Seq Scan on request r (cost=0.00..65,903.60 rows=1,332,208 width=16) (actual time=0.036..1,054.955 rows=1,336,350 loops=6)

  • Filter: (delete_date = '0'::numeric)
  • Rows Removed by Filter: 28
11. 0.039 6,900.564 ↓ 1.0 42 1

Nested Loop (cost=0.29..314.18 rows=41 width=135) (actual time=6,899.985..6,900.564 rows=42 loops=1)

12. 6,900.165 6,900.165 ↓ 1.1 45 1

CTE Scan on validator_status_request_count vsrc (cost=0.00..0.84 rows=42 width=128) (actual time=6,899.948..6,900.165 rows=45 loops=1)

13. 0.360 0.360 ↑ 1.0 1 45

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

  • Index Cond: (national_code = vsrc.validator_id)
  • Filter: (delete_date = '0'::numeric)
  • Rows Removed by Filter: 0
14. 0.126 0.126 ↑ 1.0 1 42

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

  • Index Cond: (id = e.province_id)
  • Filter: (delete_date = '0'::numeric)
Planning time : 1.096 ms
Execution time : 6,901.249 ms