explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5uVM

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

Nested Loop Left Join (cost=0.42..15,245.04 rows=1 width=324) (actual time=78.905..78.905 rows=0 loops=1)

  • Join Filter: (dynamicadj0_.id = paymentfre2_.fk_adjustment_rule)
2. 0.001 78.905 ↓ 0.0 0 1

Nested Loop (cost=0.42..15,221.32 rows=1 width=212) (actual time=78.904..78.905 rows=0 loops=1)

3. 78.904 78.904 ↓ 0.0 0 1

Seq Scan on contract_payment_frequency_dynamic_adjustment_rule dynamicadj0_ (cost=0.00..15,212.88 rows=1 width=92) (actual time=78.904..78.904 rows=0 loops=1)

  • Filter: (fk_contract_payment_frequency = 231,321)
  • Rows Removed by Filter: 483,085
4. 0.000 0.000 ↓ 0.0 0

Index Scan using payment_frequency_dynamic_adjustment_rule_pkey on payment_frequency_dynamic_adjustment_rule abstractpa1_ (cost=0.42..8.44 rows=1 width=120) (never executed)

  • Index Cond: (id = dynamicadj0_.fk_dynamic_adjustment_rule)
5. 0.000 0.000 ↓ 0.0 0

Seq Scan on payment_frequency_adjustment_group_to_adjustment paymentfre2_ (cost=0.00..16.10 rows=610 width=104) (never executed)

Planning time : 0.588 ms
Execution time : 78.954 ms