explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y2U6 : 12121

Settings
# exclusive inclusive rows x rows loops node
1. 0.312 619.178 ↑ 1.0 1 1

Aggregate (cost=59,305.10..59,305.11 rows=1 width=8) (actual time=619.178..619.178 rows=1 loops=1)

2. 0.000 618.866 ↓ 1.5 4,599 1

Finalize GroupAggregate (cost=58,500.12..59,266.53 rows=3,086 width=24) (actual time=598.808..618.866 rows=4,599 loops=1)

  • Group Key: rea.reaction_meddra_pt
3. 41.788 628.037 ↓ 1.4 8,651 1

Gather Merge (cost=58,500.12..59,220.24 rows=6,172 width=16) (actual time=598.799..628.037 rows=8,651 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 18.929 586.249 ↑ 1.1 2,884 3 / 3

Sort (cost=57,500.10..57,507.81 rows=3,086 width=16) (actual time=585.820..586.249 rows=2,884 loops=3)

  • Sort Key: rea.reaction_meddra_pt
  • Sort Method: quicksort Memory: 288kB
  • Worker 0: Sort Method: quicksort Memory: 261kB
  • Worker 1: Sort Method: quicksort Memory: 326kB
5. 21.944 567.320 ↑ 1.1 2,884 3 / 3

Partial HashAggregate (cost=57,290.38..57,321.24 rows=3,086 width=16) (actual time=565.270..567.320 rows=2,884 loops=3)

  • Group Key: rea.reaction_meddra_pt
6. 93.718 545.376 ↓ 2.3 40,662 3 / 3

Parallel Hash Join (cost=17,832.28..57,246.74 rows=17,457 width=16) (actual time=468.241..545.376 rows=40,662 loops=3)

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

Parallel Seq Scan on phv_drug ddv (cost=0.00..37,199.87 rows=2,798 width=16) (actual time=0.016..194.357 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
8. 137.053 257.301 ↑ 1.2 220,277 3 / 3

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

  • Buckets: 65,536 Batches: 16 Memory Usage: 3,328kB
9. 120.248 120.248 ↑ 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..120.248 rows=220,277 loops=3)

Planning time : 0.215 ms
Execution time : 636.459 ms