explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZfUY

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.521 ↑ 3.6 14 1

Limit (cost=309,859.88..309,921.35 rows=50 width=211) (actual time=0.461..0.521 rows=14 loops=1)

2. 0.008 0.519 ↑ 41.4 14 1

Unique (cost=309,859.88..310,571.73 rows=579 width=211) (actual time=0.460..0.519 rows=14 loops=1)

3. 0.014 0.511 ↑ 36.2 16 1

Nested Loop Left Join (cost=309,859.88..310,570.28 rows=579 width=211) (actual time=0.459..0.511 rows=16 loops=1)

4. 0.002 0.497 ↑ 36.2 16 1

Nested Loop Left Join (cost=309,859.32..310,159.00 rows=579 width=180) (actual time=0.454..0.497 rows=16 loops=1)

5. 0.018 0.463 ↑ 36.2 16 1

Merge Left Join (cost=309,858.88..309,863.86 rows=579 width=172) (actual time=0.448..0.463 rows=16 loops=1)

  • Merge Cond: (att.account_transaction_id = attppro.account_transaction_id)
6. 0.015 0.310 ↑ 36.2 16 1

Sort (cost=309,832.69..309,834.14 rows=579 width=164) (actual time=0.309..0.310 rows=16 loops=1)

  • Sort Key: att.account_transaction_id DESC
  • Sort Method: quicksort Memory: 29kB
7. 0.006 0.295 ↑ 36.2 16 1

Nested Loop (cost=3,315.67..309,806.12 rows=579 width=164) (actual time=0.081..0.295 rows=16 loops=1)

8. 0.020 0.241 ↑ 35.2 16 1

Nested Loop (cost=3,315.23..309,504.74 rows=564 width=114) (actual time=0.073..0.241 rows=16 loops=1)

9. 0.010 0.093 ↑ 34.4 16 1

Nested Loop (cost=3,314.05..306,625.74 rows=550 width=8) (actual time=0.052..0.093 rows=16 loops=1)

10. 0.038 0.038 ↓ 5.0 5 1

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

  • Index Cond: (account_holder_id = '154988'::bigint)
  • Heap Fetches: 3
11. 0.030 0.045 ↑ 50,121.3 3 5

Bitmap Heap Scan on monetary_endpoint me (cost=3,313.76..305,113.79 rows=150,364 width=16) (actual time=0.005..0.009 rows=3 loops=5)

  • Recheck Cond: (account_id = a.account_id)
  • Heap Blocks: exact=16
12. 0.015 0.015 ↑ 50,121.3 3 5

Bitmap Index Scan on idx_monetary_endpoint_account_id (cost=0.00..3,276.17 rows=150,364 width=0) (actual time=0.003..0.003 rows=3 loops=5)

  • Index Cond: (account_id = a.account_id)
13. 0.032 0.128 ↑ 2.0 1 16

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

  • Recheck Cond: ((destination_id = me.monetary_endpoint_id) OR (source_id = me.monetary_endpoint_id))
  • Heap Blocks: exact=16
14. 0.000 0.096 ↓ 0.0 0 16

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

15. 0.048 0.048 ↑ 1.0 1 16

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

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

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

  • Index Cond: (source_id = me.monetary_endpoint_id)
17. 0.048 0.048 ↑ 1.0 1 16

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

  • Index Cond: (auditable_event_id = mtae.money_transfer_event_id)
18. 0.080 0.135 ↑ 2.7 153 1

Sort (cost=26.20..27.23 rows=415 width=16) (actual time=0.128..0.135 rows=153 loops=1)

  • Sort Key: attppro.account_transaction_id DESC
  • Sort Method: quicksort Memory: 46kB
19. 0.055 0.055 ↓ 1.1 451 1

Seq Scan on account_transaction_ppro_payment_method attppro (cost=0.00..8.15 rows=415 width=16) (actual time=0.006..0.055 rows=451 loops=1)

20. 0.032 0.032 ↓ 0.0 0 16

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.002..0.002 rows=0 loops=16)

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

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

  • Index Cond: (rr.reconciliation_result_id = reconciliation_result_id)
Planning time : 2.968 ms
Execution time : 0.615 ms