explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Dao

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.002 0.088 ↑ 1.0 1 1

Nested Loop (cost=0.00..33.17 rows=1 width=126) (actual time=0.086..0.088 rows=1 loops=1)

2. 0.006 0.073 ↑ 1.0 1 1

Nested Loop (cost=0.00..24.89 rows=1 width=48) (actual time=0.072..0.073 rows=1 loops=1)

3. 0.019 0.050 ↑ 1.0 1 1

Nested Loop (cost=0.00..16.56 rows=1 width=27) (actual time=0.050..0.050 rows=1 loops=1)

  • Join Filter: ((r.request_effective_date >= ep.strt_dt) AND (r.request_effective_date <= ep.end_dt))
4. 0.014 0.014 ↑ 1.0 1 1

Index Scan using request_pkey on request r (cost=0.00..8.27 rows=1 width=36) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (request_id = 16335698::bigint)
5. 0.017 0.017 ↑ 1.0 1 1

Index Scan using fr705gix on edb_prod ep (cost=0.00..8.27 rows=1 width=23) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (prod_id = (r.product_specification_id)::bpchar)
6. 0.017 0.017 ↑ 1.0 1 1

Index Scan using fr703aix on edb_spec es (cost=0.00..8.32 rows=1 width=45) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (spec_id = (r.request_specification_id)::bpchar)
7. 0.013 0.013 ↑ 1.0 1 1

Index Scan using request_agreement_bak_pkey on request_agreement ra (cost=0.00..8.27 rows=1 width=86) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (request_id = 16335698::bigint)
  • Filter: ((external_reference)::text = '5311618583'::text)