explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jCPu

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.081 ↓ 2.0 2 1

Subquery Scan on query (cost=1,532.98..1,533.02 rows=1 width=40) (actual time=0.080..0.081 rows=2 loops=1)

2. 0.004 0.080 ↓ 2.0 2 1

GroupAggregate (cost=1,532.98..1,533.01 rows=1 width=59) (actual time=0.079..0.080 rows=2 loops=1)

  • Group Key: qa.qa_reviewer__c, (COALESCE(co.firstname, ''::character varying))
3. 0.015 0.076 ↓ 3.0 3 1

Sort (cost=1,532.98..1,532.99 rows=1 width=76) (actual time=0.076..0.076 rows=3 loops=1)

  • Sort Key: qa.qa_reviewer__c, (COALESCE(co.firstname, ''::character varying))
  • Sort Method: quicksort Memory: 25kB
4. 0.007 0.061 ↓ 3.0 3 1

Nested Loop (cost=6.13..1,532.97 rows=1 width=76) (actual time=0.034..0.061 rows=3 loops=1)

5. 0.007 0.015 ↑ 41.7 3 1

Bitmap Heap Scan on qa_form__c qa (cost=5.57..460.47 rows=125 width=44) (actual time=0.013..0.015 rows=3 loops=1)

  • Recheck Cond: ((completion_time__c >= '2019-05-01 04:00:00'::timestamp without time zone) AND (completion_time__c < '2019-05-11 04:00:00'::timestamp without time zone))
  • Heap Blocks: exact=6
6. 0.008 0.008 ↑ 20.8 6 1

Bitmap Index Scan on hc_idx_qa_form__c_completion_time__c (cost=0.00..5.54 rows=125 width=0) (actual time=0.008..0.008 rows=6 loops=1)

  • Index Cond: ((completion_time__c >= '2019-05-01 04:00:00'::timestamp without time zone) AND (completion_time__c < '2019-05-11 04:00:00'::timestamp without time zone))
7. 0.039 0.039 ↑ 1.0 1 3

Index Scan using contact_idx_sfid on contact co (cost=0.56..8.58 rows=1 width=26) (actual time=0.013..0.013 rows=1 loops=3)

  • Index Cond: ((sfid)::text = (qa.qa_reviewer__c)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)