explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZVaX : 12121

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 955.018 ↓ 1.5 4,599 1

Finalize GroupAggregate (cost=58,942.55..59,739.81 rows=3,086 width=32) (actual time=942.303..955.018 rows=4,599 loops=1)

  • Group Key: rea.reaction_meddra_pt
2. 33.014 966.758 ↓ 1.4 8,637 1

Gather Merge (cost=58,942.55..59,662.66 rows=6,172 width=32) (actual time=942.287..966.758 rows=8,637 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 16.482 933.744 ↑ 1.1 2,879 3 / 3

Sort (cost=57,942.52..57,950.24 rows=3,086 width=32) (actual time=933.208..933.744 rows=2,879 loops=3)

  • Sort Key: rea.reaction_meddra_pt
  • Sort Method: quicksort Memory: 376kB
  • Worker 0: Sort Method: quicksort Memory: 319kB
  • Worker 1: Sort Method: quicksort Memory: 312kB
4. 153.854 917.262 ↑ 1.1 2,879 3 / 3

Partial HashAggregate (cost=57,732.81..57,763.67 rows=3,086 width=32) (actual time=916.257..917.262 rows=2,879 loops=3)

  • Group Key: rea.reaction_meddra_pt
5. 150.353 763.408 ↓ 2.3 40,662 3 / 3

Parallel Hash Join (cost=17,832.28..57,252.74 rows=17,457 width=24) (actual time=650.358..763.408 rows=40,662 loops=3)

  • Hash Cond: (ddv.report_sid = rea.report_sid)
6. 342.234 342.234 ↓ 3.6 10,025 3 / 3

Parallel Seq Scan on phv_drug ddv (cost=0.00..37,199.87 rows=2,798 width=24) (actual time=0.016..342.234 rows=10,025 loops=3)

  • Filter: ((drug_start_date IS NOT NULL) AND (drug_end_date IS NOT NULL) AND (drug_end_date > drug_start_date))
  • Rows Removed by Filter: 354,007
7. 164.749 270.821 ↑ 1.2 220,277 3 / 3

Parallel Hash (cost=12,507.46..12,507.46 rows=275,346 width=32) (actual time=270.821..270.821 rows=220,277 loops=3)

  • Buckets: 65,536 Batches: 16 Memory Usage: 3,360kB
8. 106.072 106.072 ↑ 1.2 220,277 3 / 3

Parallel Seq Scan on phv_reaction rea (cost=0.00..12,507.46 rows=275,346 width=32) (actual time=0.010..106.072 rows=220,277 loops=3)

Planning time : 0.220 ms
Execution time : 972.411 ms