explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TuYE

Settings
# exclusive inclusive rows x rows loops node
1. 2.443 4,162.868 ↓ 220.3 2,423 1

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

2. 3.055 3.055 ↓ 1.2 6 1

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

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

Bitmap Heap Scan on cpq__c q (cost=97.35..14,745.96 rows=13 width=53) (actual time=59.366..692.895 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. 206.550 206.550 ↓ 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=34.425..34.425 rows=116,007 loops=6)

  • Index Cond: ((cpq_plan__c)::text = (plan.sfid)::text)
Planning time : 0.689 ms
Execution time : 4,163.106 ms