explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SpFu

Settings
# exclusive inclusive rows x rows loops node
1. 0.133 0.937 ↓ 152.7 458 1

Sort (cost=14.89..14.90 rows=3 width=24) (actual time=0.903..0.937 rows=458 loops=1)

  • Sort Key: ready_for_production, placed
  • Sort Method: quicksort Memory: 60kB
2. 0.291 0.804 ↓ 152.7 458 1

Bitmap Heap Scan on sales_order (cost=4.29..14.87 rows=3 width=24) (actual time=0.586..0.804 rows=458 loops=1)

  • Recheck Cond: (state_id = 1)
  • Heap Blocks: exact=114
3. 0.513 0.513 ↓ 3,041.0 9,123 1

Bitmap Index Scan on sales_order_state_id_idx (cost=0.00..4.29 rows=3 width=0) (actual time=0.513..0.513 rows=9,123 loops=1)

Planning time : 0.106 ms
Execution time : 0.983 ms