explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sBfFD

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 3.500 ↓ 0.0 0 1

Sort (cost=41.17..41.70 rows=211 width=13) (actual time=3.499..3.500 rows=0 loops=1)

  • Sort Key: name DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.002 3.493 ↓ 0.0 0 1

Bitmap Heap Scan on sale_order (cost=8.76..33.02 rows=211 width=13) (actual time=3.493..3.493 rows=0 loops=1)

  • Recheck Cond: (((origin)::text ~~ '%699268090%'::text) OR ((name)::text = '699268090'::text))
3. 0.002 3.491 ↓ 0.0 0 1

BitmapOr (cost=8.76..8.76 rows=211 width=0) (actual time=3.491..3.491 rows=0 loops=1)

4. 3.463 3.463 ↓ 0.0 0 1

Bitmap Index Scan on sale_order_origin_idx1 (cost=0.00..7.98 rows=210 width=0) (actual time=3.463..3.463 rows=0 loops=1)

  • Index Cond: ((origin)::text ~~ '%699268090%'::text)
5. 0.026 0.026 ↓ 0.0 0 1

Bitmap Index Scan on sale_order_name_uniq (cost=0.00..0.68 rows=1 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: ((name)::text = '699268090'::text)
Planning time : 0.274 ms
Execution time : 3.542 ms