#	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)

"Nested Loop  (cost=0.00..33.17 rows=1 width=126) (actual time=0.086..0.088 rows=1 loops=1)"
"  ->  Nested Loop  (cost=0.00..24.89 rows=1 width=48) (actual time=0.072..0.073 rows=1 loops=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))"
"              ->  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)"
"              ->  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)"
"        ->  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)"
"  ->  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)"

Per node type stats

node type	count	sum of times	% of query
Index Scan	4	0.061 ms	69.3 %
Nested Loop	3	0.027 ms	30.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
edb_prod	1	0.017 ms	19.3 %
Index Scan	1	0.017 ms	100.0 %
edb_spec	1	0.017 ms	19.3 %
Index Scan	1	0.017 ms	100.0 %
request	1	0.014 ms	15.9 %
Index Scan	1	0.014 ms	100.0 %
request_agreement	1	0.013 ms	14.8 %
Index Scan	1	0.013 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Dao

Colorize:

Columns visibility:

Per node type stats

Per table stats