explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ifh

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 83.764 ↑ 1.0 10 1

Limit (cost=1,102.79..1,147.58 rows=10 width=1,981) (actual time=18.305..83.764 rows=10 loops=1)

2. 72.521 83.750 ↑ 1,037.5 10 1

Bitmap Heap Scan on "order" o (cost=1,102.79..47,568.10 rows=10,375 width=1,981) (actual time=18.302..83.750 rows=10 loops=1)

  • Recheck Cond: (((sender_contragent_code)::text = '56090b33d83467dd84bd15ce'::text) OR ((payer_contragent_code)::text = '56090b33d83467dd84bd15ce'::text))
  • Filter: ((NOT deleted) AND (date_time_create >= '2019-08-07 00:00:00'::timestamp without time zone) AND (date_time_create <= '2019-09-07 23:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 20100
  • Heap Blocks: exact=18146
3. 0.003 11.229 ↓ 0.0 0 1

BitmapOr (cost=1,102.79..1,102.79 rows=41,917 width=0) (actual time=11.229..11.229 rows=0 loops=1)

4. 6.970 6.970 ↓ 1.1 22,137 1

Bitmap Index Scan on idx_order_sender_code (cost=0.00..529.51 rows=20,513 width=0) (actual time=6.970..6.970 rows=22,137 loops=1)

  • Index Cond: ((sender_contragent_code)::text = '56090b33d83467dd84bd15ce'::text)
5. 4.256 4.256 ↓ 1.0 22,256 1

Bitmap Index Scan on idx_order_payer_code (cost=0.00..568.09 rows=21,404 width=0) (actual time=4.256..4.256 rows=22,256 loops=1)

  • Index Cond: ((payer_contragent_code)::text = '56090b33d83467dd84bd15ce'::text)
Planning time : 0.710 ms
Execution time : 83.836 ms