explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XUj5

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.047 ↓ 0.0 0 1

Limit (cost=309,978.54..310,039.93 rows=50 width=211) (actual time=0.047..0.047 rows=0 loops=1)

  • Planning Time: 180.738 ms | Execution Time: 0.350 ms |
2. 0.001 0.046 ↓ 0.0 0 1

Unique (cost=309,978.54..310,712.85 rows=598 width=211) (actual time=0.046..0.046 rows=0 loops=1)

3. 0.001 0.045 ↓ 0.0 0 1

Nested Loop Left Join (cost=309,978.54..310,711.35 rows=598 width=211) (actual time=0.045..0.045 rows=0 loops=1)

4. 0.000 0.044 ↓ 0.0 0 1

Nested Loop Left Join (cost=309,977.98..310,286.64 rows=598 width=180) (actual time=0.044..0.044 rows=0 loops=1)

5. 0.003 0.044 ↓ 0.0 0 1

Merge Left Join (cost=309,977.54..309,981.64 rows=598 width=172) (actual time=0.043..0.044 rows=0 loops=1)

  • Merge Cond: (att.account_transaction_id = attppro.account_transaction_id)
6. 0.015 0.041 ↓ 0.0 0 1

Sort (cost=309,963.78..309,965.28 rows=598 width=164) (actual time=0.041..0.041 rows=0 loops=1)

  • Sort Key: att.account_transaction_id DESC
  • Sort Method: quicksort Memory: 25kB
7. 0.000 0.026 ↓ 0.0 0 1

Nested Loop (cost=3,307.67..309,936.20 rows=598 width=164) (actual time=0.026..0.026 rows=0 loops=1)

8. 0.000 0.026 ↓ 0.0 0 1

Nested Loop (cost=3,307.23..309,622.27 rows=588 width=114) (actual time=0.026..0.026 rows=0 loops=1)

9. 0.001 0.026 ↓ 0.0 0 1

Nested Loop (cost=3,306.05..306,617.74 rows=574 width=8) (actual time=0.026..0.026 rows=0 loops=1)

10. 0.025 0.025 ↓ 0.0 0 1

Index Only Scan using idx_account_account_holder on account a (cost=0.29..8.31 rows=1 width=8) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (account_holder_id = '154988'::bigint)
  • Heap Fetches: 0
11. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on monetary_endpoint me (cost=3,305.76..305,105.79 rows=150,364 width=16) (never executed)

  • Recheck Cond: (account_id = a.account_id)
12. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_monetary_endpoint_account_id (cost=0.00..3,268.17 rows=150,364 width=0) (never executed)

  • Index Cond: (account_id = a.account_id)
13. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on money_transfer_auditable_event mtae (cost=1.18..5.21 rows=2 width=114) (never executed)

  • Recheck Cond: ((destination_id = me.monetary_endpoint_id) OR (source_id = me.monetary_endpoint_id))
14. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=1.18..1.18 rows=2 width=0) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_money_transfer_auditable_event_source_destination (cost=0.00..0.59 rows=1 width=0) (never executed)

  • Index Cond: (destination_id = me.monetary_endpoint_id)
16. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_money_transfer_auditable_event_source_id (cost=0.00..0.59 rows=1 width=0) (never executed)

  • Index Cond: (source_id = me.monetary_endpoint_id)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using fki_transaction_event_id_fkey on account_transaction att (cost=0.43..0.52 rows=1 width=66) (never executed)

  • Index Cond: (auditable_event_id = mtae.money_transfer_event_id)
18. 0.000 0.000 ↓ 0.0 0

Sort (cost=13.76..14.31 rows=220 width=16) (never executed)

  • Sort Key: attppro.account_transaction_id DESC
19. 0.000 0.000 ↓ 0.0 0

Seq Scan on account_transaction_ppro_payment_method attppro (cost=0.00..5.20 rows=220 width=16) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_reconciliation_result_account_transaction_id on reconciliation_result rr (cost=0.43..0.50 rows=1 width=16) (never executed)

  • Index Cond: (att.account_transaction_id = account_transaction_id)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using reconciliation_data_reconciliation_result_id on reconciliation_data rd (cost=0.56..0.70 rows=1 width=31) (never executed)

  • Index Cond: (rr.reconciliation_result_id = reconciliation_result_id)