explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5XfV : Grid Plan

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

Limit (cost=0..0.13 rows=10 width=797) (never executed)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..3.49418397562279e+18 rows=278,864,192,890,912,112,640 width=797) (never executed)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..8.38156448638912e+15 rows=77,269,103,045,417,600 width=519) (never executed)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..6.51019911362384e+15 rows=6,526,137,543 width=451) (never executed)

5. 0.000 0.000 ↓ 0.0

Seq Scan on t872_oppdim t872_oppdim (cost=0..7,398,378.54 rows=54,801,254 width=412) (never executed)

6. 0.000 0.000 ↓ 0.0

Materialize (cost=0..3,900,180.46 rows=31,658,497 width=55) (never executed)

7. 0.000 0.000 ↓ 0.0

Seq Scan on t644_adobe_product_to_sales_team_assignment__cdim t644_adobe_product_to_sales_team_assignment__cdim (cost=0..3,432,721.97 rows=31,658,497 width=55) (never executed)

8.          

SubPlan (for Nested Loop)

9. 0.000 0.000 ↓ 0.0

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

10. 0.000 0.000 ↓ 0.0

Index Scan using idx_598_t872_oppdim_sid_end_stamp_start_stamp_null on t872_oppdim t872_oppdim_1 (cost=0.56..209.05 rows=33 width=8) (never executed)

  • Index Cond: ((sid = t644_adobe_product_to_sales_team_assignment__cdim.c5717_opportunity__c) AND (end_stamp <= '1586912400000'::bigint) AND (start_stamp >= '1585699200000'::bigint))
  • Filter: ((NOT c7841_isclosed) OR (c7841_isclosed AND c7842_iswon))
11. 0.000 0.000 ↓ 0.0

Materialize (cost=0..774,657.16 rows=11,839,944 width=68) (never executed)

12. 0.000 0.000 ↓ 0.0

Seq Scan on t646_accountdim t646_accountdim (cost=0..576,707.44 rows=11,839,944 width=68) (never executed)

13. 0.000 0.000 ↓ 0.0

Materialize (cost=0..252.13 rows=3,609 width=14) (never executed)

14. 0.000 0.000 ↓ 0.0

Seq Scan on t123_adobe_role__cdim t123_adobe_role__cdim (cost=0..234.09 rows=3,609 width=14) (never executed)