explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DkE2 : Optimization for: plan #wpTh

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 7.167 2,348.546 ↑ 1.0 51 1

Limit (cost=1,384,278.78..1,384,278.91 rows=51 width=362) (actual time=2,348.515..2,348.546 rows=51 loops=1)

2. 930.535 2,341.379 ↑ 47.9 40,551 1

Sort (cost=1,384,177.53..1,389,031.40 rows=1,941,549 width=362) (actual time=2,332.038..2,341.379 rows=40,551 loops=1)

  • Sort Key: dm_dispute_requests_new.creation_date, dm_dispute_requests_new.dispute_request_id
  • Sort Method: top-N heapsort Memory: 24540kB
3. 1,410.844 1,410.844 ↑ 2.0 961,370 1

Index Scan using i_dm_dr_party_cid_dreq_cdate on dm_dispute_requests_new (cost=0.56..1,225,868.96 rows=1,941,549 width=362) (actual time=0.041..1,410.844 rows=961,370 loops=1)

  • Index Cond: ((party_customer_id = '608808520'::numeric) AND (disp_req_created_date >= '2018-04-15 00:00:00'::timestamp without time zone) AND (disp_req_created_date < '2019-04-15 20:11:47.768'::timestamp without time zone))
Planning time : 0.313 ms