explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fGIQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 153.157 ↓ 0.0 0 1

Unique (cost=905,945.74..905,945.79 rows=1 width=202) (actual time=153.157..153.157 rows=0 loops=1)

2. 0.013 153.157 ↓ 0.0 0 1

Sort (cost=905,945.74..905,945.75 rows=1 width=202) (actual time=153.157..153.157 rows=0 loops=1)

  • Sort Key: mtae.money DESC, att.account_transaction_id, mtae.auditable_event_state_type_id, mtae.event_type, mtae.initiator_user_id, mtae.auto_release_on, mtae.trace_id, rd.additional_data, mtae.initiator_id, att.posted_on, mtae.money_currency, mtae.source_id, mtae.destination_id, ((att.reference)::character varying), mtae.description, att.created_on, mtae.payment_category_type_id, att.external_reference
  • Sort Method: quicksort Memory: 25kB
3. 0.001 153.144 ↓ 0.0 0 1

Nested Loop (cost=1,218.82..905,945.73 rows=1 width=202) (actual time=153.144..153.144 rows=0 loops=1)

4. 0.000 153.143 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,218.21..905,941.10 rows=1 width=202) (actual time=153.143..153.143 rows=0 loops=1)

5. 0.000 153.143 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,217.65..905,940.40 rows=1 width=187) (actual time=153.143..153.143 rows=0 loops=1)

6. 0.000 153.143 ↓ 0.0 0 1

Nested Loop (cost=1,217.22..905,939.88 rows=1 width=179) (actual time=153.142..153.143 rows=0 loops=1)

7. 25.031 162.054 ↓ 0.0 0 1

Gather (cost=1,216.79..905,936.49 rows=1 width=129) (actual time=153.142..162.054 rows=0 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
8. 0.022 137.023 ↓ 0.0 0 4 / 4

Nested Loop Left Join (cost=216.78..904,936.39 rows=1 width=129) (actual time=137.023..137.023 rows=0 loops=4)

  • Filter: ((mes.generic_payee_id = '2165544697'::bigint) OR (med.generic_payee_id = '2165544697'::bigint))
  • Rows Removed by Filter: 149
9. 0.171 136.703 ↑ 581.8 149 4 / 4

Nested Loop Left Join (cost=216.35..527,402.54 rows=86,684 width=129) (actual time=6.626..136.703 rows=149 loops=4)

10. 16.836 135.342 ↑ 581.8 149 4 / 4

Hash Join (cost=215.91..151,168.95 rows=86,684 width=113) (actual time=6.582..135.342 rows=149 loops=4)

  • Hash Cond: (mtae.initiator_id = ah.account_holder_id)
11. 116.697 116.697 ↑ 1.3 68,538 4 / 4

Parallel Index Scan using idx_money_transfer_auditable_event_event_type on money_transfer_auditable_event mtae (cost=0.56..150,718.44 rows=89,493 width=113) (actual time=0.048..116.697 rows=68,538 loops=4)

  • Index Cond: (event_type = ANY ('{4,7}'::integer[]))
12. 0.503 1.809 ↓ 1.0 3,954 4 / 4

Hash (cost=165.97..165.97 rows=3,950 width=8) (actual time=1.809..1.809 rows=3,954 loops=4)

  • Buckets: 4096 Batches: 1 Memory Usage: 187kB
13. 1.306 1.306 ↓ 1.0 3,954 4 / 4

Seq Scan on account_holder ah (cost=0.00..165.97 rows=3,950 width=8) (actual time=0.027..1.306 rows=3,954 loops=4)

  • Filter: ((parent_id IS NOT NULL) AND (parent_id <> 101))
  • Rows Removed by Filter: 127
14. 1.190 1.190 ↑ 1.0 1 595 / 4

Index Scan using monetary_endpoint_pkey on monetary_endpoint med (cost=0.44..4.34 rows=1 width=24) (actual time=0.008..0.008 rows=1 loops=595)

  • Index Cond: (mtae.destination_id = monetary_endpoint_id)
15. 0.297 0.297 ↑ 1.0 1 595 / 4

Index Scan using monetary_endpoint_pkey on monetary_endpoint mes (cost=0.44..4.34 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=595)

  • Index Cond: (mtae.source_id = monetary_endpoint_id)
16. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (auditable_event_id = mtae.money_transfer_event_id)
  • Filter: (processor_type_id = 41)
17. 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)
18. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rr.reconciliation_result_id = reconciliation_result_id)
19. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on account a (cost=0.60..4.62 rows=1 width=8) (never executed)

  • Recheck Cond: (((account_id = mes.account_id) AND (account_id = 197632)) OR ((account_id = med.account_id) AND (account_id = 197632)))
20. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=0.60..0.60 rows=1 width=0) (never executed)

21. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((account_id = mes.account_id) AND (account_id = 197632))
22. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((account_id = med.account_id) AND (account_id = 197632))
Planning time : 3.304 ms