explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iS7M

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 11,279.061 ↓ 6.0 6 1

Sort (cost=2,418,757.60..2,418,757.61 rows=1 width=434) (actual time=11,279.060..11,279.061 rows=6 loops=1)

  • Sort Key: bv.id
  • Sort Method: quicksort Memory: 28kB
2. 0.011 11,279.041 ↓ 6.0 6 1

Nested Loop Left Join (cost=12.03..2,418,757.59 rows=1 width=434) (actual time=4,453.083..11,279.041 rows=6 loops=1)

3. 0.009 11,279.006 ↓ 6.0 6 1

Nested Loop Left Join (cost=11.47..2,418,750.08 rows=1 width=376) (actual time=4,453.065..11,279.006 rows=6 loops=1)

4. 0.010 11,278.985 ↓ 6.0 6 1

Nested Loop Left Join (cost=11.04..2,418,742.77 rows=1 width=343) (actual time=4,453.055..11,278.985 rows=6 loops=1)

5. 0.004 11,278.933 ↓ 6.0 6 1

Nested Loop Left Join (cost=10.62..2,418,735.45 rows=1 width=372) (actual time=4,453.033..11,278.933 rows=6 loops=1)

6. 0.006 11,278.905 ↓ 6.0 6 1

Nested Loop Left Join (cost=10.19..2,418,727.00 rows=1 width=343) (actual time=4,453.015..11,278.905 rows=6 loops=1)

7. 0.004 11,278.881 ↓ 6.0 6 1

Nested Loop Left Join (cost=9.76..2,418,718.56 rows=1 width=310) (actual time=4,453.003..11,278.881 rows=6 loops=1)

8. 0.007 11,278.865 ↓ 6.0 6 1

Nested Loop Left Join (cost=9.33..2,418,710.11 rows=1 width=292) (actual time=4,452.996..11,278.865 rows=6 loops=1)

9. 0.022 11,278.840 ↓ 6.0 6 1

Nested Loop Left Join (cost=8.91..2,418,701.67 rows=1 width=274) (actual time=4,452.981..11,278.840 rows=6 loops=1)

  • Join Filter: (trx.id = bv.transactions_id)
  • Rows Removed by Join Filter: 144
10. 0.057 11,278.800 ↓ 6.0 6 1

Nested Loop (cost=8.91..2,418,700.10 rows=1 width=226) (actual time=4,452.972..11,278.800 rows=6 loops=1)

  • -> Index Scan using ix_process_filler_id on process po (cost=0.44..20.19 rows=1 width=8) (actual time=0.008..0.008 rows=1
11. 11,278.681 11,278.743 ↓ 6.0 6 1

Hash Right Join (cost=8.47..2,418,679.90 rows=1 width=218) (actual time=4,452.934..11,278.743 rows=6 loops=1)

  • Hash Cond: ((m.auth_code = bv.auth_code) AND (m.requestid = bv.nsu))
  • -> Seq Scan on mmt_movement m (cost=0.00..2191260.10 rows=30321510 width=83) (actual time=0.005..5626.070 rows=30321
  • Index Cond: (filler_id = bv.operation_id)
  • Filter: (process_template_id = 82)
  • Rows Removed by Filter: 1
12. 0.062 0.062 ↑ 1.0 1 1

Hash (cost=8.45..8.45 rows=1 width=194) (actual time=0.062..0.062 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • -> Index Scan using idx_transaction_id_uuid on transaction bv (cost=0.43..8.45 rows=1 width=194) (actual time=
  • Index Cond: (id_uuid = '61a8e083-410b-4602-8fb0-60c8d523cb06'::uuid)
13. 0.018 0.018 ↑ 1.0 25 6

Seq Scan on transactions trx (cost=0.00..1.25 rows=25 width=56) (actual time=0.001..0.003 rows=25 loops=6)

14. 0.018 0.018 ↑ 1.0 1 6

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

  • Index Cond: (id = bv.entity_merchant_id)
15. 0.012 0.012 ↑ 1.0 1 6

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

  • Index Cond: (id = bv.entity_matrix_id)
16. 0.018 0.018 ↑ 1.0 1 6

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

  • Index Cond: (id = bv.entity_cardholder_id)
17. 0.024 0.024 ↑ 1.0 1 6

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

  • Index Cond: (id = bv.origin_card_id)
18. 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)
19. 0.012 0.012 ↑ 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.002..0.002 rows=1 loops=6)

  • Index Cond: (ba.entity_id = id)
20. 0.024 0.024 ↑ 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.004..0.004 rows=1 loops=6)

  • Index Cond: (filler_id_uuid = ecc.id_uuid)