explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DKQp : Optimization for: Optimization for: plan #fqp6; plan #GN2U

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.059 0.521 ↑ 1.0 65 1

Nested Loop (cost=0.99..277.76 rows=66 width=8) (actual time=0.035..0.521 rows=65 loops=1)

2. 0.069 0.332 ↑ 1.0 65 1

Nested Loop (cost=0.84..266.20 rows=66 width=8) (actual time=0.031..0.332 rows=65 loops=1)

3. 0.041 0.041 ↑ 1.0 74 1

Index Scan using slr_dict_ro_ent_id_e5aeb6_idx on slr_dict_root (cost=0.42..68.55 rows=75 width=4) (actual time=0.014..0.041 rows=74 loops=1)

  • Index Cond: (ent_id = ANY ('{8018,NULL}'::integer[]))
4. 0.222 0.222 ↑ 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.003..0.003 rows=1 loops=74)

  • Index Cond: (dict_root_id = slr_dict_root.id)
  • Filter: (payment_type_template_id IS NOT NULL)
5. 0.130 0.130 ↑ 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.002..0.002 rows=1 loops=65)

  • Index Cond: (id = slr_payment_type.payment_type_template_id)