explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 273T

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 65.384 ↑ 1.0 10 1

Limit (cost=1,638.10..1,682.86 rows=10 width=1,981) (actual time=17.453..65.384 rows=10 loops=1)

2. 54.329 65.374 ↑ 1,542.7 10 1

Bitmap Heap Scan on "order" o (cost=1,638.10..70,698.21 rows=15,427 width=1,981) (actual time=17.451..65.374 rows=10 loops=1)

  • Recheck Cond: (((sender_contragent_code)::text = '56090b33d83467dd84bd15ce'::text) OR ((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.002 11.045 ↓ 0.0 0 1

BitmapOr (cost=1,638.10..1,638.10 rows=62,353 width=0) (actual time=11.045..11.045 rows=0 loops=1)

4. 5.082 5.082 ↓ 1.1 22,137 1

Bitmap Index Scan on idx_order_sender_code (cost=0.00..529.32 rows=20,487 width=0) (actual time=5.081..5.082 rows=22,137 loops=1)

  • Index Cond: ((sender_contragent_code)::text = '56090b33d83467dd84bd15ce'::text)
5. 2.959 2.959 ↓ 1.1 22,137 1

Bitmap Index Scan on idx_order_sender_code (cost=0.00..529.32 rows=20,487 width=0) (actual time=2.958..2.959 rows=22,137 loops=1)

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

Bitmap Index Scan on idx_order_payer_code (cost=0.00..567.90 rows=21,378 width=0) (actual time=3.002..3.002 rows=22,256 loops=1)

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