explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BaEO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Delete on mte_consolidated (cost=0.00..892.31 rows=2 width=6) (actual rows= loops=)

  • Delete on mte_consolidated
  • Delete on mte_consolidated_p2019_05
2. 0.000 0.000 ↓ 0.0

Seq Scan on mte_consolidated (cost=0.00..0.00 rows=1 width=6) (actual rows= loops=)

  • Filter: ((delivered_status_code IS NULL) AND (delivery_engine IS NULL) AND (application_id = 69) AND (sent_time = '2019-05-10 06:00:00'::timestamp without time zone) AND (dsid = '5885'::bigint) AND (carrier_id = '2'::smallint) AND (resale_id = '0'::bigint) AND (sub_account_id = '10281'::bigint) AND (user_id = 0) AND (campaign_id = 0) AND ((short_code)::text = '4001'::text) AND (detailed_message_status_code = 2))
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mte_consolidated_p2019_05 (cost=801.05..892.31 rows=1 width=6) (actual rows= loops=)

  • Recheck Cond: ((sub_account_id = '10281'::bigint) AND (dsid = '5885'::bigint))
  • Filter: ((delivered_status_code IS NULL) AND (delivery_engine IS NULL) AND (application_id = 69) AND (sent_time = '2019-05-10 06:00:00'::timestamp without time zone) AND (carrier_id = '2'::smallint) AND (resale_id = '0'::bigint) AND (user_id = 0) AND (campaign_id = 0) AND ((short_code)::text = '4001'::text) AND (detailed_message_status_code = 2))
4. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=801.05..801.05 rows=23 width=0) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mte_consolidated_p2019_05_sub_account_id_idx (cost=0.00..398.40 rows=4,530 width=0) (actual rows= loops=)

  • Index Cond: (sub_account_id = '10281'::bigint)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mte_consolidated_p2019_05_dsid_idx (cost=0.00..402.40 rows=4,530 width=0) (actual rows= loops=)

  • Index Cond: (dsid = '5885'::bigint)