explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qid

Settings
# exclusive inclusive rows x rows loops node
1. 1.565 2,981.292 ↓ 220.3 2,423 1

Nested Loop (cost=97.35..73,892.64 rows=11 width=34) (actual time=266.381..2,981.292 rows=2,423 loops=1)

2. 0.505 0.505 ↓ 1.2 6 1

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

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

Bitmap Heap Scan on cpq__c q (cost=97.35..14,761.49 rows=13 width=53) (actual time=44.309..496.537 rows=404 loops=6)

  • Recheck Cond: ((cpq_plan__c)::text = (plan.sfid)::text)
  • Filter: (((createddate)::date >= (CURRENT_DATE - 60)) AND (((createddate)::date + (plan.expiration_interval__c)::integer) = CURRENT_DATE) AND ((cpq_status__c)::text = ANY ('{Approved,In-Process,"No Bid","Task Required","Approval Required","Pending Approval","Quote MRC Required",Recalled,Rejected,Draft,"Unable To Quote"}'::text[])))
  • Rows Removed by Filter: 113,488
  • Heap Blocks: exact=270,272
4. 140.538 140.538 ↓ 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=23.423..23.423 rows=116,007 loops=6)

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