explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IJvh : Optimization for: plan #KK6

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 0.079 ↑ 2.0 1 1

Nested Loop (cost=0.28..12.50 rows=2 width=22) (actual time=0.077..0.079 rows=1 loops=1)

2. 0.021 0.021 ↑ 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.020..0.021 rows=1 loops=1)

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

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

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

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

  • Filter: (employee_id = '128120506933'::numeric)
  • Rows Removed by Filter: 169
Planning time : 0.184 ms
Execution time : 0.113 ms