explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bZru

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.028 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.28..12.47 rows=1 width=22) (actual time=0.028..0.028 rows=0 loops=1)

  • Join Filter: (prl_dtl.employee_id = c.customer_id)
2. 0.028 0.028 ↓ 0.0 0 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.028 rows=0 loops=1)

  • Index Cond: (customer_id = '44271728338927659'::numeric)
3. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.00..4.15 rows=1 width=18) (never executed)

  • Group Key: prl_dtl.employee_id
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on prl_dtl (cost=0.00..4.14 rows=1 width=10) (never executed)

  • Filter: (employee_id = '44271728338927659'::numeric)
Planning time : 0.193 ms
Execution time : 0.100 ms