explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3weAQ

Settings
# exclusive inclusive rows x rows loops node
1. 1.595 2,384.706 ↓ 220.3 2,423 1

Nested Loop (cost=97.35..73,815.03 rows=11 width=34) (actual time=187.890..2,384.706 rows=2,423 loops=1)

2. 0.475 0.475 ↓ 1.2 6 1

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

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

Bitmap Heap Scan on cpq__c q (cost=97.35..14,745.96 rows=13 width=53) (actual time=31.229..397.106 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,271
4. 98.598 98.598 ↓ 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.433..16.433 rows=116,007 loops=6)

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