explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5911

Settings
# exclusive inclusive rows x rows loops node
1. 2.838 191,757.695 ↓ 220.3 2,423 1

Nested Loop (cost=97.35..73,815.02 rows=11 width=38) (actual time=1,778.845..191,757.695 rows=2,423 loops=1)

2. 6.257 6.257 ↓ 1.2 6 1

Seq Scan on cpq_plan__c plan (cost=0.00..85.00 rows=5 width=27) (actual time=1.837..6.257 rows=6 loops=1)

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

Bitmap Heap Scan on cpq__c q (cost=97.35..14,745.96 rows=13 width=53) (actual time=295.425..31,958.100 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. 345.792 345.792 ↓ 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=57.632..57.632 rows=116,007 loops=6)

  • Index Cond: ((cpq_plan__c)::text = (plan.sfid)::text)
Planning time : 6.982 ms
Execution time : 191,758.196 ms