explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ln69

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 32.955 ↓ 0.0 0 1

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

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

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

  • 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. 29.854 32.952 ↓ 0.0 0 1

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

  • 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))
  • Rows Removed by Filter: 3906
  • Heap Blocks: exact=2430
4. 0.131 3.098 ↓ 0.0 0 1

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

5. 1.861 1.861 ↑ 1.0 4,474 1

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

  • Index Cond: (sub_account_id = '10281'::bigint)
6. 1.106 1.106 ↑ 1.0 4,494 1

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

  • Index Cond: (dsid = '5885'::bigint)
Planning time : 6.622 ms
Execution time : 33.039 ms