explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cdMJ

Settings
# exclusive inclusive rows x rows loops node
1. 239.806 529.777 ↑ 33.9 25 1

Hash Join (cost=76.47..61,812.92 rows=847 width=23) (actual time=148.527..529.777 rows=25 loops=1)

  • Hash Cond: (slr_payment_type.payment_type_template_id = slr_payment_type_template.id)
  • Join Filter: ((slr_payment_type.calculation_type = 8) OR ((slr_payment_type_template.algorithm_code)::text = 'AllowanceForNorth'::text))
  • Rows Removed by Join Filter: 526053
2. 288.972 288.972 ↑ 1.0 526,078 1

Seq Scan on slr_payment_type (cost=0.00..60,336.83 rows=533,183 width=10) (actual time=0.013..288.972 rows=526,078 loops=1)

3. 0.184 0.999 ↑ 1.0 634 1

Hash (cost=68.43..68.43 rows=643 width=23) (actual time=0.999..0.999 rows=634 loops=1)

4. 0.815 0.815 ↑ 1.0 634 1

Buckets: 1024 Batches: 1 Memory Usage: 44kB" -> Seq Scan on slr_payment_type_template (cost=0.00..68.43 rows=643 width=23) (actual time=0.009..0.815 rows=634 loops=1)