explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9k3C

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.084 ↑ 1.0 1 1

Limit (cost=1.96..7.38 rows=1 width=1,301) (actual time=0.082..0.084 rows=1 loops=1)

2. 0.002 0.081 ↑ 179,964.0 1 1

Nested Loop Left Join (cost=1.96..974,626.42 rows=179,964 width=1,301) (actual time=0.081..0.081 rows=1 loops=1)

3. 0.001 0.075 ↑ 179,964.0 1 1

Nested Loop Left Join (cost=1.54..257,743.38 rows=179,964 width=1,100) (actual time=0.075..0.075 rows=1 loops=1)

4. 0.001 0.066 ↑ 179,964.0 1 1

Nested Loop Left Join (cost=1.26..204,543.26 rows=179,964 width=430) (actual time=0.066..0.066 rows=1 loops=1)

5. 0.002 0.057 ↑ 179,964.0 1 1

Nested Loop (cost=0.84..109,875.61 rows=179,964 width=311) (actual time=0.056..0.057 rows=1 loops=1)

6. 0.040 0.040 ↑ 179,964.0 1 1

Index Scan using company_updatedon_id on task_commitment_document d (cost=0.42..21,761.43 rows=179,964 width=110) (actual time=0.040..0.040 rows=1 loops=1)

  • Index Cond: (((company_id)::text = '10000'::text) AND (updated_on < timezone('UTC'::text, now())))
  • Filter: ((updated_on > '2019-07-03 00:00:00'::timestamp without time zone) OR ((updated_on = '2019-07-03 00:00:00'::timestamp without time zone) AND (id > 1602)))
7. 0.015 0.015 ↑ 1.0 1 1

Index Scan using pk_document_task on document_task "d.Task" (cost=0.42..0.49 rows=1 width=201) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (id = d.task_id)
8. 0.008 0.008 ↑ 1.0 1 1

Index Scan using pk_sale_tax_commitment_request on sale_tax_commitment_request "d.Task.SaleTaxCommitmentRequest" (cost=0.42..0.53 rows=1 width=119) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: ("d.Task".id = task_id)
9. 0.008 0.008 ↓ 0.0 0 1

Index Scan using pk_refund_tax_commitment_request on refund_tax_commitment_request "d.Task.RefundTaxCommitmentRequest" (cost=0.28..0.30 rows=1 width=670) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ("d.Task".id = task_id)
10. 0.004 0.004 ↓ 0.0 0 1

Index Scan using pk_document_task on document_task "d.Task.RefundTaxCommitmentRequest.TaskToRefund" (cost=0.42..3.98 rows=1 width=201) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ("d.Task.RefundTaxCommitmentRequest".task_id_to_refund = id)
Planning time : 1.392 ms
Execution time : 0.226 ms