explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0J4t

Settings
# exclusive inclusive rows x rows loops node
1. 0.071 0.263 ↓ 0.0 0 1

Sort (cost=38,037.60..38,037.61 rows=1 width=1,596) (actual time=0.263..0.263 rows=0 loops=1)

  • Sort Key: accounting.entered_date
  • Sort Method: quicksort Memory: 25kB
2. 0.001 0.192 ↓ 0.0 0 1

Nested Loop Left Join (cost=7.95..38,037.59 rows=1 width=1,596) (actual time=0.192..0.192 rows=0 loops=1)

3. 0.000 0.191 ↓ 0.0 0 1

Nested Loop (cost=7.52..38,037.12 rows=1 width=466) (actual time=0.191..0.191 rows=0 loops=1)

4. 0.033 0.191 ↓ 0.0 0 1

Hash Right Join (cost=7.10..38,036.56 rows=1 width=440) (actual time=0.191..0.191 rows=0 loops=1)

  • Hash Cond: (mpad.acc_receiveid = acc_receive.acc_receiveid)
5. 0.000 0.000 ↓ 0.0 0

Seq Scan on misc_payment_additional_data mpad (cost=0.00..35,734.33 rows=612,033 width=378) (never executed)

6. 0.000 0.158 ↓ 0.0 0 1

Hash (cost=7.08..7.08 rows=1 width=66) (actual time=0.158..0.158 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
7. 0.006 0.158 ↓ 0.0 0 1

Nested Loop (cost=0.85..7.08 rows=1 width=66) (actual time=0.158..0.158 rows=0 loops=1)

8. 0.115 0.115 ↑ 1.0 1 1

Index Scan using acc_ar_custid_idx on acc_ar (cost=0.43..3.45 rows=1 width=12) (actual time=0.115..0.115 rows=1 loops=1)

  • Index Cond: (custid = 5,243,973)
9. 0.037 0.037 ↓ 0.0 0 1

Index Scan using acc_receive_acc_arid_idx on acc_receive (cost=0.43..3.59 rows=5 width=62) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: (acc_arid = acc_ar.acc_arid)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using accounting_pkey on accounting (cost=0.43..0.55 rows=1 width=34) (never executed)

  • Index Cond: (accountingid = acc_receive.accountingid)
  • Filter: ((pmtmethod <> 'acc_adj'::text) AND (pmtmethod <> 'Service Charge'::text))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using cc_holder_pkey on payment_holder (cost=0.42..0.46 rows=1 width=1,134) (never executed)

  • Index Cond: (payment_holder_id = accounting.payment_holder_id)
Planning time : 1.880 ms
Execution time : 0.692 ms