explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pNeN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 23,090.521 ↑ 670.7 6 1

Gather Merge (cost=4,356,810.46..4,357,279.96 rows=4,024 width=434) (actual time=23,090.375..23,090.521 rows=6 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.060 25,424.415 ↑ 1,006.0 2 3

Sort (cost=4,355,810.44..4,355,815.47 rows=2,012 width=434) (actual time=8,474.805..8,474.805 rows=2 loops=3)

  • Sort Key: bv.id
  • Sort Method: quicksort Memory: 28kB
3. 0.009 25,424.355 ↑ 1,006.0 2 3

Nested Loop Left Join (cost=3,816,416.78..4,355,700.04 rows=2,012 width=434) (actual time=8,363.700..8,474.785 rows=2 loops=3)

4. 0.009 25,424.292 ↑ 1,006.0 2 3

Nested Loop Left Join (cost=3,816,416.22..4,340,587.42 rows=2,012 width=376) (actual time=8,363.683..8,474.764 rows=2 loops=3)

5. 0.009 25,424.277 ↑ 1,006.0 2 3

Nested Loop Left Join (cost=3,816,415.79..4,325,864.14 rows=2,012 width=343) (actual time=8,363.681..8,474.759 rows=2 loops=3)

6. 0.006 25,424.226 ↑ 1,006.0 2 3

Nested Loop Left Join (cost=3,816,415.36..4,311,138.47 rows=2,012 width=372) (actual time=8,363.674..8,474.742 rows=2 loops=3)

7. 0.009 25,424.190 ↑ 1,006.0 2 3

Nested Loop Left Join (cost=3,816,414.94..4,296,260.04 rows=2,012 width=343) (actual time=8,363.665..8,474.730 rows=2 loops=3)

8. 0.009 25,424.157 ↑ 1,006.0 2 3

Nested Loop Left Join (cost=3,816,414.51..4,281,433.82 rows=2,012 width=310) (actual time=8,363.656..8,474.719 rows=2 loops=3)

9. 0.009 25,424.142 ↑ 1,006.0 2 3

Nested Loop Left Join (cost=3,816,414.08..4,266,607.61 rows=2,012 width=292) (actual time=8,363.655..8,474.714 rows=2 loops=3)

10. 0.020 25,424.115 ↑ 1,006.0 2 3

Hash Left Join (cost=3,816,413.65..4,251,781.39 rows=2,012 width=274) (actual time=8,363.649..8,474.705 rows=2 loops=3)

  • Hash Cond: (bv.transactions_id = trx.id)
11. 21,912.318 25,424.061 ↑ 1,006.0 2 3

Hash Left Join (cost=3,816,412.09..4,251,752.17 rows=2,012 width=226) (actual time=8,363.632..8,474.687 rows=2 loops=3)

  • Hash Cond: ((bv.auth_code = m.auth_code) AND (bv.nsu = m.requestid))
  • -> Hash (cost=2191260.10..2191260.10 rows=30321510 width=83) (actual time=21253.179..21253.179 rows=30321510 loops=1
12. 0.011 3,511.743 ↓ 0.0 0 3

Merge Join (cost=755,777.34..756,105.06 rows=2,012 width=202) (actual time=1,170.581..1,170.581 rows=0 loops=3)

  • Merge Cond: (bv.operation_id = po.filler_id)
  • Buckets: 32768 Batches: 1024 Memory Usage: 3524kB
  • -> Seq Scan on mmt_movement m (cost=0.00..2191260.10 rows=30321510 width=83) (actual time=0.009..12231.908 row
13. 3,511.653 3,511.653 ↓ 0.0 0 3

Sort (cost=623,669.11..623,715.98 rows=18,751 width=194) (actual time=1,170.551..1,170.551 rows=0 loops=3)

  • Sort Key: bv.operation_id
  • Sort Method: quicksort Memory: 25kB
  • -> Parallel Seq Scan on transaction bv (cost=0.00..620542.78 rows=18751 width=194) (actual time=870.590.
  • Filter: ((id_uuid)::text = '61a8e083-410b-4602-8fb0-60c8d523cb06'::text)
  • Rows Removed by Filter: 2917518
14. 0.079 0.079 ↑ 42,768.0 1 1

Sort (cost=132,108.23..132,215.15 rows=42,768 width=8) (actual time=0.078..0.079 rows=1 loops=1)

  • Sort Key: po.filler_id
  • Sort Method: quicksort Memory: 25kB
  • -> Bitmap Heap Scan on process po (cost=811.89..128818.47 rows=42768 width=8) (actual time=0.058..0.058
  • Recheck Cond: (process_template_id = 82)
  • Heap Blocks: exact=1
  • -> Bitmap Index Scan on idx_process_template_id (cost=0.00..801.20 rows=42768 width=0) (actual tim
  • Index Cond: (process_template_id = 82)
15. 0.008 0.034 ↑ 1.0 25 1

Hash (cost=1.25..1.25 rows=25 width=56) (actual time=0.034..0.034 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
16. 0.026 0.026 ↑ 1.0 25 1

Seq Scan on transactions trx (cost=0.00..1.25 rows=25 width=56) (actual time=0.022..0.026 rows=25 loops=1)

17. 0.018 0.018 ↑ 1.0 1 6

Index Scan using idx_entity_id on entity ec (cost=0.43..7.37 rows=1 width=34) (actual time=0.003..0.003 rows=1 loops=6)

  • Index Cond: (id = bv.entity_merchant_id)
18. 0.006 0.006 ↑ 1.0 1 6

Index Scan using idx_entity_id on entity ep (cost=0.43..7.37 rows=1 width=34) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (id = bv.entity_matrix_id)
19. 0.024 0.024 ↑ 1.0 1 6

Index Scan using idx_entity_id on entity ecard (cost=0.43..7.37 rows=1 width=49) (actual time=0.004..0.004 rows=1 loops=6)

  • Index Cond: (id = bv.entity_cardholder_id)
20. 0.030 0.030 ↑ 1.0 1 6

Index Scan using mmtw_card_id on mmtw_card c (cost=0.43..7.39 rows=1 width=45) (actual time=0.005..0.005 rows=1 loops=6)

  • Index Cond: (id = bv.origin_card_id)
21. 0.042 0.042 ↑ 1.0 1 6

Index Scan using pk_mmt_balance on mmt_balance ba (cost=0.43..7.32 rows=1 width=45) (actual time=0.007..0.007 rows=1 loops=6)

  • Index Cond: ((phone)::text = (c.phone)::text)
22. 0.006 0.006 ↑ 1.0 1 6

Index Scan using idx_entity_id on entity ecc (cost=0.43..7.32 rows=1 width=49) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (ba.entity_id = id)
23. 0.054 0.054 ↑ 1.0 1 6

Index Scan using idx_process_filler_id_uuid on process pecc (cost=0.56..7.49 rows=1 width=32) (actual time=0.008..0.009 rows=1 loops=6)

  • Index Cond: (filler_id_uuid = ecc.id_uuid)