explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bjrH

Settings
# exclusive inclusive rows x rows loops node
1. 50.113 169.994 ↓ 22.7 659 1

HashAggregate (cost=122,140.00..122,140.29 rows=29 width=32) (actual time=169.234..169.994 rows=659 loops=1)

2. 41.249 119.881 ↑ 1.1 34,841 1

Hash Join (cost=1,279.54..121,309.07 rows=36,930 width=32) (actual time=16.688..119.881 rows=34,841 loops=1)

  • Hash Cond: (t.mid_id = m.id)
3. 62.049 62.049 ↑ 1.1 34,841 1

Index Scan using idx_transaction_paymentstatus_paymenttime_mid_detaildtype2 on transaction t (cost=0.57..119,106.85 rows=36,930 width=26) (actual time=0.080..62.049 rows=34,841 loops=1)

  • Index Cond: ((paymentstatus = ANY ('{APPROVED,DEPOSITED,CLOSED,FDP_AUTHORIZED,FDP_CLEARING_ACCEPTED,FDP_CLEARING_READY,FDP_CLERAING_FAILED,FDP_ZERO_AMOUNT_OK}'::text[])) AND (paymenttime >= '2020-08-01 00:00:00'::timestamp without time zone) AND (paymenttime < '2020-08-02 00:00:00'::timestamp without time zone))
4. 7.516 16.583 ↑ 2.1 9,227 1

Hash (cost=1,031.21..1,031.21 rows=19,821 width=14) (actual time=16.583..16.583 rows=9,227 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 433kB
5. 9.067 9.067 ↑ 2.1 9,227 1

Seq Scan on mid m (cost=0.00..1,031.21 rows=19,821 width=14) (actual time=0.005..9.067 rows=9,227 loops=1)

Total runtime : 170.501 ms