explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JtfE

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.077 ↑ 1.0 1 1

Limit (cost=0.56..13.73 rows=1 width=8) (actual time=0.077..0.077 rows=1 loops=1)

2. 0.008 0.075 ↑ 1.0 1 1

Nested Loop (cost=0.56..13.73 rows=1 width=8) (actual time=0.075..0.075 rows=1 loops=1)

3. 0.015 0.015 ↑ 1.0 1 1

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

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

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

  • Index Cond: ((stateid = state1.id) AND ((orgcode)::text = '692'::text) AND ((orgtaxcode)::text = '5000000581'::text) AND ((orgkpp)::text = '310301001'::text))
Planning time : 0.402 ms
Execution time : 0.142 ms