explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ddXgc

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.815 ↑ 1.0 1 1

Nested Loop (cost=1.55..355.34 rows=1 width=92) (actual time=0.287..0.815 rows=1 loops=1)

2. 0.002 0.805 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.28..355.04 rows=1 width=100) (actual time=0.277..0.805 rows=1 loops=1)

  • Filter: ((NOT slr_united_dict.hidden) OR (slr_united_dict.id IS NULL))
3. 0.020 0.795 ↑ 1.0 1 1

Nested Loop (cost=0.85..319.23 rows=1 width=104) (actual time=0.267..0.795 rows=1 loops=1)

  • Join Filter: (slr_payment_type.payment_type_template_id = slr_payment_type_template_tags.paymenttypetemplate_id)
  • Rows Removed by Join Filter: 219
4. 0.021 0.021 ↓ 2.0 2 1

Seq Scan on slr_payment_type_template_tags (cost=0.00..2.36 rows=1 width=4) (actual time=0.019..0.021 rows=2 loops=1)

  • Filter: (paymenttypetag_id = 27)
  • Rows Removed by Filter: 109
5. 0.140 0.754 ↓ 1.5 110 2

Nested Loop (cost=0.85..315.95 rows=74 width=100) (actual time=0.015..0.377 rows=110 loops=2)

6. 0.138 0.138 ↓ 1.4 119 2

Index Scan using slr_dict_ro_ent_id_e5aeb6_idx on slr_dict_root (cost=0.42..95.34 rows=84 width=4) (actual time=0.008..0.069 rows=119 loops=2)

  • Index Cond: (ent_id = 4,806)
7. 0.476 0.476 ↑ 1.0 1 238

Index Scan using slr_payment_type_dict_root_id on slr_payment_type (cost=0.42..2.62 rows=1 width=100) (actual time=0.002..0.002 rows=1 loops=238)

  • Index Cond: (dict_root_id = slr_dict_root.id)
8. 0.008 0.008 ↑ 53.0 1 1

Index Scan using slr_united_dict_dict_root_id on slr_united_dict (cost=0.43..35.27 rows=53 width=9) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (slr_dict_root.id = dict_root_id)
9. 0.009 0.009 ↑ 1.0 1 1

Index Scan using slr_payment_type_template_pkey on slr_payment_type_template (cost=0.28..0.30 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = slr_payment_type.payment_type_template_id)
  • Filter: ((NOT hidden) AND ((algorithm_code)::text = ANY ('{PercentSurchargeTimesheet,PercentSurchargeTimesheetAnnualNorm}'::text[])) AND (algorithm_group <> 5))