explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LwCr

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3.638 ↓ 0.0 0 1

Nested Loop (cost=1.13..17.18 rows=1 width=239) (actual time=3.637..3.638 rows=0 loops=1)

2. 3.637 3.637 ↓ 0.0 0 1

Index Scan using idx_jobmetadata_routeid on jobitems ji (cost=0.56..8.58 rows=1 width=1,489) (actual time=3.637..3.637 rows=0 loops=1)

  • Index Cond: ((jobmetadata ->> 'routeid'::text) = '9382-0'::text)
3. 0.000 0.000 ↓ 0.0 0

Index Scan using unique_jobitemid on jobs j (cost=0.56..8.58 rows=1 width=63) (never executed)

  • Index Cond: (jobitemid = ji.id)
  • Filter: (jobstatuscode <> 'Released'::text)
Planning time : 6.687 ms