explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n46p

Settings
# exclusive inclusive rows x rows loops node
1. 0.087 1.018 ↓ 104.0 104 1

Sort (cost=34.35..34.36 rows=1 width=250) (actual time=1.009..1.018 rows=104 loops=1)

  • Sort Key: p.id
  • Sort Method: quicksort Memory: 48kB
2. 0.108 0.931 ↓ 104.0 104 1

Nested Loop (cost=22.29..34.34 rows=1 width=250) (actual time=0.179..0.931 rows=104 loops=1)

3. 0.365 0.511 ↓ 104.0 104 1

Bitmap Heap Scan on nsi_price_order p (cost=21.87..25.89 rows=1 width=108) (actual time=0.168..0.511 rows=104 loops=1)

  • Recheck Cond: ((date_sent >= '2019-04-08 00:00:00+03'::timestamp with time zone) AND (date_sent <= '2019-04-08 23:59:59+03'::timestamp with time zone) AND (status = 2))
  • Filter: ((only_list_email IS FALSE) AND (out_system_supplier IS NULL) AND (price_order_type = 1))
  • Rows Removed by Filter: 60
  • Heap Blocks: exact=156
4. 0.012 0.146 ↓ 0.0 0 1

BitmapAnd (cost=21.87..21.87 rows=1 width=0) (actual time=0.146..0.146 rows=0 loops=1)

5. 0.043 0.043 ↓ 2.0 179 1

Bitmap Index Scan on nsi_price_order_date_sent_idx (cost=0.00..5.18 rows=89 width=0) (actual time=0.043..0.043 rows=179 loops=1)

  • Index Cond: ((date_sent >= '2019-04-08 00:00:00+03'::timestamp with time zone) AND (date_sent <= '2019-04-08 23:59:59+03'::timestamp with time zone))
6. 0.091 0.091 ↓ 1.1 607 1

Bitmap Index Scan on nsi_price_order_status_idx (cost=0.00..16.44 rows=553 width=0) (actual time=0.091..0.091 rows=607 loops=1)

  • Index Cond: (status = 2)
7. 0.312 0.312 ↑ 1.0 1 104

Index Scan using contragents_pkey on contragents co (cost=0.42..8.44 rows=1 width=146) (actual time=0.003..0.003 rows=1 loops=104)

  • Index Cond: (id = p.customer_id)
Planning time : 0.415 ms