explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F7v7 : Simplified-3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=215,359,744.01..215,359,744.02 rows=1 width=8) (never executed)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,435,895.34..215,295,787.81 rows=25,582,482 width=8) (never executed)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,435,734.6..214,217,005.54 rows=25,316,822 width=12) (never executed)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on t644_adobe_product_to_sales_team_assignment__cdim aptsta (cost=136,199.75..3,593,724.32 rows=2,186,478 width=8) (never executed)

  • Filter: (((end_stamp = '32503680000000'::bigint) OR (end_stamp <= '1592570790000'::bigint)) AND ((end_stamp = '32503680000000'::bigint) OR (end_stamp <= '1592570790000'::bigint)))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on t644_adobe_product_to_sales_team_assignment__cdim_startstampsid (cost=0..135,653.13 rows=3,810,171 width=0) (never executed)

  • Index Cond: ((start_stamp >= '1585745190000'::bigint) AND (start_stamp <= '1592570790000'::bigint) AND (start_stamp >= '1585745190000'::bigint) AND (start_stamp <= '1592570790000'::bigint))
6. 0.000 0.000 ↓ 0.0

Hash (cost=10,246,028.08..10,246,028.08 rows=3,078,142 width=12) (never executed)

7. 0.000 0.000 ↓ 0.0

Gather (cost=9,842,137.12..10,246,028.08 rows=3,078,142 width=12) (never executed)

  • Workers Planned: 2
8. 0.000 0.000 ↓ 0.0

Merge Join (cost=9,841,137.12..9,937,213.88 rows=1,282,559 width=12) (never executed)

9. 0.000 0.000 ↓ 0.0

Sort (cost=9,476,035.2..9,514,288.04 rows=15,301,136 width=16) (never executed)

  • Sort Key: o.c7939_accountid
10. 0.000 0.000 ↓ 0.0

Seq Scan on t872_oppdim o (cost=0..7,127,072.78 rows=15,301,136 width=16) (never executed)

  • Filter: ((NOT c7841_isclosed) OR (c7841_isclosed AND c7842_iswon))
11. 0.000 0.000 ↓ 0.0

Materialize (cost=365,095.13..365,779.69 rows=136,912 width=4) (never executed)

12. 0.000 0.000 ↓ 0.0

Sort (cost=365,095.13..365,437.41 rows=136,912 width=4) (never executed)

  • Sort Key: a.sid
13. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on t646_accountdim a (cost=4,778.38..351,542.06 rows=136,912 width=4) (never executed)

  • Filter: ((end_stamp = '32503680000000'::bigint) OR (end_stamp <= '1592570790000'::bigint))
14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on t646_accountdim_startstampsid (cost=0..4,744.15 rows=179,959 width=0) (never executed)

  • Index Cond: ((start_stamp >= '1585745190000'::bigint) AND (start_stamp <= '1592570790000'::bigint))
15.          

SubPlan (for Hash Join)

16. 0.000 0.000 ↓ 0.0

Limit (cost=0.56..7.2 rows=1 width=8) (never executed)

17. 0.000 0.000 ↓ 0.0

Index Scan using idx_598_t872_oppdim_sid_end_stamp_start_stamp_null on t872_oppdim oppdim (cost=0.56..246.14 rows=37 width=8) (never executed)

  • Index Cond: ((sid = aptsta.c5717_opportunity__c) AND (start_stamp >= '1585745190000'::bigint) AND (start_stamp <= '1592570790000'::bigint))
  • Filter: (((NOT c7841_isclosed) OR (c7841_isclosed AND c7842_iswon)) AND ((end_stamp = '32503680000000'::bigint) OR (end_stamp <= '1592570790000'::bigint)))
18. 0.000 0.000 ↓ 0.0

Hash (cost=138.31..138.31 rows=1,794 width=4) (never executed)

19. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_t123_adobe_role__cdim_sid_end_stamp_start_stamp on t123_adobe_role__cdim aptstarf2 (cost=0.28..138.31 rows=1,794 width=4) (never executed)

  • Index Cond: ((end_stamp >= '1591015590000'::bigint) AND (start_stamp <= '1591015590000'::bigint))