explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rLWJ

Settings
# exclusive inclusive rows x rows loops node
1. 28.841 47.781 ↑ 1.0 1 1

Aggregate (cost=2,944.69..2,944.70 rows=1 width=32) (actual time=47.781..47.781 rows=1 loops=1)

2.          

CTE timequery

3. 0.021 0.221 ↑ 15.0 1 1

GroupAggregate (cost=4.78..183.35 rows=15 width=35) (actual time=0.221..0.221 rows=1 loops=1)

  • Group Key: qa_form__c.qa_reviewer__c
4. 0.158 0.200 ↑ 1.9 11 1

Bitmap Heap Scan on qa_form__c (cost=4.78..182.65 rows=21 width=33) (actual time=0.061..0.200 rows=11 loops=1)

  • Recheck Cond: ((qa_reviewer__c)::text = '0030H00004tXKYFQA4'::text)
  • Filter: ((NOT dismiss_from_qa__c) AND ((shop_status__c)::text = 'Completed'::text))
  • Rows Removed by Filter: 35
  • Heap Blocks: exact=42
5. 0.042 0.042 ↓ 1.1 51 1

Bitmap Index Scan on hc_idx_qa_form__c_qa_reviewer__c (cost=0.00..4.77 rows=47 width=0) (actual time=0.041..0.042 rows=51 loops=1)

  • Index Cond: ((qa_reviewer__c)::text = '0030H00004tXKYFQA4'::text)
6.          

Initplan (forAggregate)

7. 0.226 0.226 ↑ 15.0 1 1

CTE Scan on timequery (cost=0.00..0.30 rows=15 width=8) (actual time=0.225..0.226 rows=1 loops=1)

8. 0.001 0.001 ↑ 15.0 1 1

CTE Scan on timequery timequery_1 (cost=0.00..0.30 rows=15 width=8) (actual time=0.001..0.001 rows=1 loops=1)

9. 18.713 18.713 ↑ 1.0 67,625 1

Index Only Scan using hc_idx_qa_form__c_shop_status__c on qa_form__c qa (cost=0.42..2,084.49 rows=67,625 width=12) (actual time=0.076..18.713 rows=67,625 loops=1)

  • Heap Fetches: 535