explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kWMY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.088 ↑ 1.0 1 1

Limit (cost=1.79..7.75 rows=1 width=16) (actual time=0.087..0.088 rows=1 loops=1)

2.          

Initplan (forLimit)

3. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on state (cost=0.00..1.24 rows=1 width=4) (actual time=0.016..0.019 rows=1 loops=1)

  • Filter: ((code)::text = 'READY_TO_SEND'::text)
  • Rows Removed by Filter: 18
4. 0.084 0.084 ↑ 2.0 1 1

Index Scan using message_stateid_idx on message message1 (cost=0.56..12.48 rows=2 width=16) (actual time=0.084..0.084 rows=1 loops=1)

  • Index Cond: ((stateid = $0) AND ((orgcode)::text = '692'::text) AND ((orgtaxcode)::text = '5000000581'::text) AND ((orgkpp)::text = '310301001'::text))
Planning time : 0.240 ms
Execution time : 0.153 ms