explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j3bm

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 4.617 ↑ 1.0 1 1

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

2. 1.116 4.614 ↑ 1.0 1 1

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

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

Nested Loop (cost=0.56..13.74 rows=1 width=1,318) (actual time=0.065..3.498 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.015..0.020 rows=1 loops=1)

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

Index Scan using test_idx on message message1 (cost=0.56..12.48 rows=2 width=1,318) (actual time=0.043..2.497 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.310 ms
Execution time : 4.694 ms