explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DRVc

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

Nested Loop (cost=12.58..32.94 rows=1 width=2,965) (actual rows= loops=)

  • Join Filter: (employee_benefit.financing_method_id = financing_method.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.44..32.53 rows=1 width=4,041) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.30..23.98 rows=1 width=2,895) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=12.15..22.85 rows=1 width=2,793) (actual rows= loops=)

  • Hash Cond: (duplicate_benefit_order.employee_benefit_id = employee_benefit.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on duplicate_benefit_order (cost=0.00..10.50 rows=50 width=1,064) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=12.14..12.14 rows=1 width=1,745) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=10.39..12.14 rows=1 width=1,745) (actual rows= loops=)

  • Hash Cond: (benefit_provider_product_price_variant.financing_method_id = employee_benefit.financing_method_id)
8. 0.000 0.000 ↓ 0.0

Seq Scan on benefit_provider_product_price_variant (cost=0.00..1.54 rows=54 width=27) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=10.38..10.38 rows=1 width=1,718) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on employee_benefit (cost=0.00..10.38 rows=1 width=1,718) (actual rows= loops=)

  • Filter: ((employee_benefit_status)::text = 'ACTIVE'::text)
11. 0.000 0.000 ↓ 0.0

Index Scan using benefit_order_pkey on benefit_order (cost=0.15..1.12 rows=1 width=134) (actual rows= loops=)

  • Index Cond: (id = duplicate_benefit_order.benefit_order_id)
12. 0.000 0.000 ↓ 0.0

Index Scan using benefit_pkey on benefit (cost=0.14..8.16 rows=1 width=1,154) (actual rows= loops=)

  • Index Cond: (id = employee_benefit.benefit_id)
13. 0.000 0.000 ↓ 0.0

Index Scan using financing_method_pkey on financing_method (cost=0.14..0.38 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = benefit_provider_product_price_variant.financing_method_id)