explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R1iF

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 55,226.456 ↑ 3.6 14 1

Limit (cost=1,003.15..250,317.39 rows=50 width=211) (actual time=55,225.732..55,226.456 rows=14 loops=1)

2. 0.011 55,226.454 ↑ 289.4 14 1

Unique (cost=1,003.15..20,200,443.26 rows=4,051 width=211) (actual time=55,225.730..55,226.454 rows=14 loops=1)

3. 0.447 55,226.443 ↑ 253.2 16 1

Nested Loop Left Join (cost=1,003.15..20,200,433.13 rows=4,051 width=211) (actual time=55,225.728..55,226.443 rows=16 loops=1)

  • Join Filter: (att.account_transaction_id = attppro.account_transaction_id)
  • Rows Removed by Join Filter: 7135
4. 0.015 55,224.380 ↑ 253.2 16 1

Nested Loop Left Join (cost=1,003.15..20,175,186.21 rows=4,051 width=187) (actual time=55,224.327..55,224.380 rows=16 loops=1)

5. 0.000 55,224.349 ↑ 253.2 16 1

Nested Loop Left Join (cost=1,002.59..20,172,328.96 rows=4,051 width=172) (actual time=55,224.302..55,224.349 rows=16 loops=1)

6. 161.683 55,370.451 ↑ 253.2 16 1

Gather Merge (cost=1,002.15..20,170,263.99 rows=4,051 width=164) (actual time=55,224.279..55,370.451 rows=16 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
7. 1,484.965 55,208.768 ↑ 337.7 3 5 / 5

Nested Loop (cost=2.10..20,168,781.42 rows=1,013 width=164) (actual time=33,169.617..55,208.768 rows=3 loops=5)

8. 3,197.545 48,762.106 ↑ 1.3 4,961,697 5 / 5

Nested Loop (cost=1.81..18,192,229.44 rows=6,374,606 width=172) (actual time=1.141..48,762.106 rows=4,961,697 loops=5)

9. 2,663.992 23,236.924 ↑ 1.3 2,480,849 5 / 5

Nested Loop (cost=0.87..2,303,234.41 rows=3,187,303 width=164) (actual time=0.865..23,236.924 rows=2,480,849 loops=5)

10. 10,649.538 10,649.538 ↑ 1.3 2,480,849 5 / 5

Parallel Index Scan Backward using transaction_pkey on account_transaction att (cost=0.43..502,677.83 rows=3,187,303 width=66) (actual time=0.335..10,649.538 rows=2,480,849 loops=5)

11. 9,923.394 9,923.394 ↑ 1.0 1 12,404,243 / 5

Index Scan using money_transfer_auditable_event_pkey on money_transfer_auditable_event mtae (cost=0.43..0.56 rows=1 width=114) (actual time=0.004..0.004 rows=1 loops=12,404,243)

  • Index Cond: (money_transfer_event_id = att.auditable_event_id)
12. 12,404.243 22,327.637 ↑ 1.0 2 12,404,243 / 5

Bitmap Heap Scan on monetary_endpoint me (cost=0.94..4.97 rows=2 width=16) (actual time=0.009..0.009 rows=2 loops=12,404,243)

  • Recheck Cond: ((mtae.destination_id = monetary_endpoint_id) OR (mtae.source_id = monetary_endpoint_id))
  • Heap Blocks: exact=2495446
13. 0.000 9,923.394 ↓ 0.0 0 12,404,243 / 5

BitmapOr (cost=0.94..0.94 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=12,404,243)

14. 7,442.546 7,442.546 ↑ 1.0 1 12,404,243 / 5

Bitmap Index Scan on monetary_endpoint_pkey (cost=0.00..0.47 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=12,404,243)

  • Index Cond: (mtae.destination_id = monetary_endpoint_id)
15. 4,961.697 4,961.697 ↑ 1.0 1 12,404,243 / 5

Bitmap Index Scan on monetary_endpoint_pkey (cost=0.00..0.47 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=12,404,243)

  • Index Cond: (mtae.source_id = monetary_endpoint_id)
16. 4,961.697 4,961.697 ↓ 0.0 0 24,808,486 / 5

Index Only Scan using idx_account_account_holder on account a (cost=0.29..0.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=24,808,486)

  • Index Cond: ((account_holder_id = '154988'::bigint) AND (account_id = me.account_id))
  • Heap Fetches: 15
17. 0.048 0.048 ↓ 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.003..0.003 rows=0 loops=16)

  • Index Cond: (att.account_transaction_id = account_transaction_id)
18. 0.016 0.016 ↓ 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.001..0.001 rows=0 loops=16)

  • Index Cond: (rr.reconciliation_result_id = reconciliation_result_id)
19. 0.315 1.616 ↓ 1.1 446 16

Materialize (cost=0.00..10.23 rows=415 width=16) (actual time=0.002..0.101 rows=446 loops=16)

20. 1.301 1.301 ↓ 1.1 446 1

Seq Scan on account_transaction_ppro_payment_method attppro (cost=0.00..8.15 rows=415 width=16) (actual time=0.013..1.301 rows=446 loops=1)

Planning time : 2.901 ms
Execution time : 55,372.766 ms