explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FpLj

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 327.858 ↓ 0.0 0 1

Limit (cost=0.56..240,581.13 rows=1 width=74) (actual time=327.858..327.858 rows=0 loops=1)

2. 327.856 327.856 ↓ 0.0 0 1

Index Scan using index_codes_on_resource_type_and_value on codes (cost=0.56..240,581.13 rows=1 width=74) (actual time=327.856..327.856 rows=0 loops=1)

  • Index Cond: ((value)::text = 'ccayz'::text)
  • Filter: (((type)::text = 'item_group_code'::text) AND ((format)::text = 'ref_number'::text))