explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hsBC

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,346.738 ↑ 3.6 14 1

Limit (cost=508,138.79..508,141.42 rows=50 width=211) (actual time=1,346.717..1,346.738 rows=14 loops=1)

2. 0.024 1,346.734 ↑ 289.4 14 1

Unique (cost=508,138.79..508,351.47 rows=4,051 width=211) (actual time=1,346.715..1,346.734 rows=14 loops=1)

3. 0.125 1,346.710 ↑ 253.2 16 1

Sort (cost=508,138.79..508,148.92 rows=4,051 width=211) (actual time=1,346.709..1,346.710 rows=16 loops=1)

  • Sort Key: att.account_transaction_id DESC, mtae.auditable_event_state_type_id, mtae.event_type, att.processor_type_id, mtae.initiator_user_id, mtae.auto_release_on, mtae.trace_id, rd.additional_data, mtae.initiator_id, att.posted_on, mtae.money_currency, mtae.money, mtae.source_id, mtae.destination_id, ((att.reference)::character varying), mtae.description, att.created_on, mtae.payment_category_type_id, att.external_reference, attppro.ppro_payment_method_id
  • Sort Method: quicksort Memory: 29kB
4. 0.000 1,346.585 ↑ 253.2 16 1

Nested Loop Left Join (cost=1,011.39..507,896.06 rows=4,051 width=211) (actual time=164.167..1,346.585 rows=16 loops=1)

5. 42.511 1,373.070 ↑ 253.2 16 1

Gather (cost=1,011.11..506,660.49 rows=4,051 width=187) (actual time=164.137..1,373.070 rows=16 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
6. 0.007 1,330.559 ↑ 337.7 3 5 / 5

Nested Loop Left Join (cost=11.11..505,255.39 rows=1,013 width=187) (actual time=151.645..1,330.559 rows=3 loops=5)

7. 0.006 1,330.546 ↑ 337.7 3 5 / 5

Nested Loop Left Join (cost=10.55..504,540.90 rows=1,013 width=172) (actual time=151.634..1,330.546 rows=3 loops=5)

8. 0.006 1,330.502 ↑ 337.7 3 5 / 5

Nested Loop (cost=10.12..504,024.53 rows=1,013 width=164) (actual time=151.607..1,330.502 rows=3 loops=5)

9. 0.014 1,330.432 ↑ 329.3 3 5 / 5

Nested Loop (cost=9.68..503,496.60 rows=988 width=114) (actual time=151.564..1,330.432 rows=3 loops=5)

10. 487.227 1,330.274 ↑ 321.0 3 5 / 5

Hash Join (cost=8.50..498,455.72 rows=963 width=8) (actual time=151.459..1,330.274 rows=3 loops=5)

  • Hash Cond: (me.account_id = a.account_id)
11. 842.930 842.930 ↑ 1.2 4,981,669 5 / 5

Parallel Seq Scan on monetary_endpoint me (cost=0.00..482,534.41 rows=6,061,442 width=16) (actual time=0.021..842.930 rows=4,981,669 loops=5)

12. 0.006 0.117 ↑ 1.4 5 5 / 5

Hash (cost=8.41..8.41 rows=7 width=8) (actual time=0.117..0.117 rows=5 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.111 0.111 ↑ 1.4 5 5 / 5

Index Only Scan using idx_account_account_holder on account a (cost=0.29..8.41 rows=7 width=8) (actual time=0.093..0.111 rows=5 loops=5)

  • Index Cond: (account_holder_id = '154988'::bigint)
  • Heap Fetches: 15
14. 0.019 0.144 ↑ 2.0 1 16 / 5

Bitmap Heap Scan on money_transfer_auditable_event mtae (cost=1.18..5.21 rows=2 width=114) (actual time=0.045..0.045 rows=1 loops=16)

  • Recheck Cond: ((destination_id = me.monetary_endpoint_id) OR (source_id = me.monetary_endpoint_id))
  • Heap Blocks: exact=3
15. 0.010 0.125 ↓ 0.0 0 16 / 5

BitmapOr (cost=1.18..1.18 rows=2 width=0) (actual time=0.039..0.039 rows=0 loops=16)

16. 0.058 0.058 ↑ 1.0 1 16 / 5

Bitmap Index Scan on idx_money_transfer_auditable_event_source_destination (cost=0.00..0.59 rows=1 width=0) (actual time=0.018..0.018 rows=1 loops=16)

  • Index Cond: (destination_id = me.monetary_endpoint_id)
17. 0.058 0.058 ↓ 0.0 0 16 / 5

Bitmap Index Scan on idx_money_transfer_auditable_event_source_id (cost=0.00..0.59 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=16)

  • Index Cond: (source_id = me.monetary_endpoint_id)
18. 0.064 0.064 ↑ 1.0 1 16 / 5

Index Scan using fki_transaction_event_id_fkey on account_transaction att (cost=0.43..0.52 rows=1 width=66) (actual time=0.020..0.020 rows=1 loops=16)

  • Index Cond: (auditable_event_id = mtae.money_transfer_event_id)
19. 0.038 0.038 ↓ 0.0 0 16 / 5

Index Scan using idx_reconciliation_result_account_transaction_id on reconciliation_result rr (cost=0.43..0.50 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=16)

  • Index Cond: (att.account_transaction_id = account_transaction_id)
20. 0.006 0.006 ↓ 0.0 0 16 / 5

Index Scan using reconciliation_data_reconciliation_result_id on reconciliation_data rd (cost=0.56..0.70 rows=1 width=31) (actual time=0.002..0.002 rows=0 loops=16)

  • Index Cond: (rr.reconciliation_result_id = reconciliation_result_id)
21. 0.064 0.064 ↓ 0.0 0 16

Index Only Scan using account_transaction_ppro_payment_method_unique on account_transaction_ppro_payment_method attppro (cost=0.27..0.29 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=16)

  • Index Cond: (account_transaction_id = att.account_transaction_id)
  • Heap Fetches: 1
Planning time : 6.559 ms
Execution time : 1,373.801 ms