explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GVwI

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

Nested Loop (cost=4.91..187.27 rows=58 width=4) (actual rows= loops=)

  • Filter: (calculation_type = 8)
2. 0.000 0.000 ↓ 0.0

Index Scan using slr_payment_type_template_algorithm_code_fc2cd163_like on slr_payment_type_template (cost=0.14..8.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((algorithm_code)::text = 'AllowanceForNorth'::text)
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on slr_payment_type (cost=4.76..178.49 rows=62 width=8) (actual rows= loops=)

  • Recheck Cond: (payment_type_template_id = slr_payment_type_template.id)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on slr_payment_type_payment_type_template_id (cost=0.00..4.75 rows=62 width=0) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Cond: (payment_type_template_id = slr_payment_type_template.id)Seq Scan on slr_payment_type (cost=0.00..558.41 rows=198 width=4) (actual rows= loops=)