explain.depesz.com

PostgreSQL's explain analyze made readable

Result: My4T

Settings
# exclusive inclusive rows x rows loops node
1. 1.393 2,406.307 ↓ 220.3 2,423 1

Nested Loop (cost=97.41..73,887.24 rows=11 width=19) (actual time=191.422..2,406.307 rows=2,423 loops=1)

2. 1.026 1.026 ↓ 1.2 6 1

Index Scan using cpq_plan__c_sfid_key on cpq_plan__c plan (cost=0.06..157.23 rows=5 width=27) (actual time=0.090..1.026 rows=6 loops=1)

  • Filter: (expiration_interval__c IS NOT NULL)
  • Rows Removed by Filter: 2,661
3. 2,305.842 2,403.888 ↓ 31.1 404 6

Bitmap Heap Scan on cpq__c q (cost=97.35..14,745.96 rows=13 width=46) (actual time=32.707..400.648 rows=404 loops=6)

  • Recheck Cond: ((cpq_plan__c)::text = (plan.sfid)::text)
  • Filter: (((cpq_status__c)::text <> ALL ('{"Designing Solution","Order Pending",Ordered}'::text[])) AND ((createddate)::date >= (CURRENT_DATE - 60)) AND (((createddate)::date + (plan.expiration_interval__c)::integer) = CURRENT_DATE))
  • Rows Removed by Filter: 113,488
  • Heap Blocks: exact=270,272
4. 98.046 98.046 ↓ 14.9 116,007 6

Bitmap Index Scan on cpq__c_cpq_plan__c_idx (cost=0.00..97.35 rows=7,761 width=0) (actual time=16.341..16.341 rows=116,007 loops=6)

  • Index Cond: ((cpq_plan__c)::text = (plan.sfid)::text)
Planning time : 0.742 ms
Execution time : 2,406.518 ms