explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NFE

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 4.407 ↑ 1.0 1 1

Limit (cost=13.75..13.75 rows=1 width=1,318) (actual time=4.407..4.407 rows=1 loops=1)

2. 1.051 4.406 ↑ 1.0 1 1

Sort (cost=13.75..13.75 rows=1 width=1,318) (actual time=4.406..4.406 rows=1 loops=1)

  • Sort Key: message1.created
  • Sort Method: top-N heapsort Memory: 27kB
3. 0.924 3.355 ↓ 931.0 931 1

Nested Loop (cost=0.56..13.74 rows=1 width=1,318) (actual time=0.077..3.355 rows=931 loops=1)

4. 0.020 0.020 ↑ 1.0 1 1

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

  • Filter: ((code)::text = 'READY_TO_SEND'::text)
  • Rows Removed by Filter: 18
5. 2.411 2.411 ↓ 465.5 931 1

Index Scan using message_stateid_idx on message message1 (cost=0.56..12.48 rows=2 width=1,318) (actual time=0.056..2.411 rows=931 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.303 ms
Execution time : 4.493 ms