explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GN2U : Optimization for: plan #fqp6

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.057 0.645 ↑ 1.0 65 1

Nested Loop (cost=0.99..276.25 rows=66 width=8) (actual time=0.358..0.645 rows=65 loops=1)

2. 0.052 0.523 ↑ 1.0 65 1

Nested Loop (cost=0.84..264.69 rows=66 width=8) (actual time=0.352..0.523 rows=65 loops=1)

3. 0.175 0.175 ↑ 1.0 74 1

Index Scan using slr_dict_ro_ent_id_e5aeb6_idx on slr_dict_root (cost=0.42..67.04 rows=75 width=4) (actual time=0.165..0.175 rows=74 loops=1)

  • Index Cond: (ent_id = 8018)
4. 0.296 0.296 ↑ 1.0 1 74

Index Scan using slr_payment_type_dict_root_id on slr_payment_type (cost=0.42..2.63 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=74)

  • Index Cond: (dict_root_id = slr_dict_root.id)
  • Filter: (payment_type_template_id IS NOT NULL)
5. 0.065 0.065 ↑ 1.0 1 65

Index Scan using slr_payment_type_template_pkey on slr_payment_type_template (cost=0.15..0.17 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=65)

  • Index Cond: (id = slr_payment_type.payment_type_template_id)