explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oppb : 12121

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 409.966 ↑ 138.0 2 1

Finalize GroupAggregate (cost=51,653.68..51,689.31 rows=276 width=32) (actual time=409.964..409.966 rows=2 loops=1)

  • Group Key: rea.reaction_meddra_pt
2. 8.576 410.319 ↑ 38.3 6 1

Gather Merge (cost=51,653.68..51,684.83 rows=230 width=32) (actual time=409.659..410.319 rows=6 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.436 401.743 ↑ 57.5 2 3 / 3

Partial GroupAggregate (cost=50,653.66..50,658.26 rows=115 width=32) (actual time=401.545..401.743 rows=2 loops=3)

  • Group Key: rea.reaction_meddra_pt
4. 0.288 401.307 ↓ 2.3 267 3 / 3

Sort (cost=50,653.66..50,653.94 rows=115 width=24) (actual time=401.278..401.307 rows=267 loops=3)

  • Sort Key: rea.reaction_meddra_pt
  • Sort Method: quicksort Memory: 52kB
  • Worker 0: Sort Method: quicksort Memory: 42kB
  • Worker 1: Sort Method: quicksort Memory: 42kB
5. 6.852 401.019 ↓ 2.3 267 3 / 3

Parallel Hash Join (cost=13,218.54..50,649.72 rows=115 width=24) (actual time=115.154..401.019 rows=267 loops=3)

  • Hash Cond: (ddv.report_sid = rea.report_sid)
6. 280.192 280.192 ↓ 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.013..280.192 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. 2.422 113.975 ↑ 1.1 1,607 3 / 3

Parallel Hash (cost=13,195.82..13,195.82 rows=1,817 width=32) (actual time=113.975..113.975 rows=1,607 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 448kB
8. 111.553 111.553 ↑ 1.1 1,607 3 / 3

Parallel Seq Scan on phv_reaction rea (cost=0.00..13,195.82 rows=1,817 width=32) (actual time=0.037..111.553 rows=1,607 loops=3)

  • Filter: ((reaction_meddra_pt)::text = ANY ('{""Abdominal pain"",""Abdominal pain upper""}'::text[]))
  • Rows Removed by Filter: 218,670
Planning time : 0.248 ms
Execution time : 410.386 ms