explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pSk6

Settings
# exclusive inclusive rows x rows loops node
1. 21.124 901.248 ↑ 2.0 1 1

Gather Merge (cost=117,478.03..117,478.24 rows=2 width=144) (actual time=883.440..901.248 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 0.000 880.124 ↓ 0.0 0 2 / 2

Sort (cost=116,478.03..116,478.03 rows=2 width=144) (actual time=880.123..880.124 rows=0 loops=2)

  • Sort Key: o.offer_sent_date_time__c DESC
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
3. 269.374 881.021 ↓ 0.0 0 2 / 2

Parallel Hash Join (cost=41,319.91..116,478.02 rows=2 width=144) (actual time=808.557..881.021 rows=0 loops=2)

  • Hash Cond: ((o.accountid)::text = (a.sfid)::text)
  • Join Filter: (((o.public_id__c)::text = '5GxPGHccY2Kpn6BDY2W9YytSxn4aCboF8ddVc4sTayozZEST'::text) OR ((o.paymenthash__c)::text = '5GxPGHccY2Kpn6BDY2W9YytSxn4aCboF8ddVc4sTayozZEST'::text) OR ((a.public_id__c)::text = '5GxPGHccY2Kpn6BDY2W9YytSxn4aCboF8ddVc4sTayozZEST'::text))
  • Rows Removed by Join Filter: 281660
4. 311.447 311.447 ↑ 1.2 281,670 2 / 2

Parallel Seq Scan on opportunity o (cost=0.00..59,058.14 rows=331,379 width=109) (actual time=0.071..311.447 rows=281,670 loops=2)

5. 89.598 300.200 ↑ 1.2 281,350 2 / 2

Parallel Hash (cost=35,221.96..35,221.96 rows=335,986 width=89) (actual time=300.200..300.200 rows=281,350 loops=2)

  • Buckets: 262144 Batches: 4 Memory Usage: 12992kB
6. 210.602 210.602 ↑ 1.2 281,350 2 / 2

Parallel Seq Scan on account a (cost=0.00..35,221.96 rows=335,986 width=89) (actual time=0.049..210.602 rows=281,350 loops=2)

Planning time : 0.471 ms
Execution time : 903.203 ms