explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NLqG

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

Nested Loop (cost=0.28..15.72 rows=1 width=23) (actual time=0.043..0.043 rows=0 loops=1)

2. 0.001 0.043 ↓ 0.0 0 1

Nested Loop (cost=0.28..11.54 rows=1 width=15) (actual time=0.043..0.043 rows=0 loops=1)

3. 0.042 0.042 ↓ 0.0 0 1

Seq Scan on hr_employee e (cost=0.00..3.24 rows=1 width=10) (actual time=0.042..0.042 rows=0 loops=1)

  • Filter: (employee_id = '44271728338927659'::numeric)
  • Rows Removed by Filter: 99
4. 0.000 0.000 ↓ 0.0 0

Index Scan using crm_customer_pk on crm_customer c (cost=0.28..8.30 rows=1 width=14) (never executed)

  • Index Cond: (customer_id = '44271728338927659'::numeric)
5. 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
6. 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)