explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KK6

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.005 1.298 ↑ 2.0 1 1

Nested Loop Left Join (cost=0.28..12.50 rows=2 width=22) (actual time=1.296..1.298 rows=1 loops=1)

  • Join Filter: (prl_dtl.employee_id = c.customer_id)
2. 0.029 0.029 ↑ 1.0 1 1

Index Scan using crm_customer_pk on crm_customer c (cost=0.28..8.30 rows=1 width=14) (actual time=0.028..0.029 rows=1 loops=1)

  • Index Cond: (customer_id = '128120506933'::numeric)
3. 1.213 1.264 ↑ 2.0 1 1

GroupAggregate (cost=0.00..4.17 rows=2 width=18) (actual time=1.264..1.264 rows=1 loops=1)

  • Group Key: prl_dtl.employee_id
4. 0.051 0.051 ↑ 1.0 2 1

Seq Scan on prl_dtl (cost=0.00..4.14 rows=2 width=10) (actual time=0.020..0.051 rows=2 loops=1)

  • Filter: (employee_id = '128120506933'::numeric)
  • Rows Removed by Filter: 169