#	exclusive	inclusive	rows x	rows	loops	node
1.	0.087	0.087	↑ 1.0	1	1	→ Index Scan using request_id_user_alias__create_timestamp_idx on request_debug (cost=0.00..8.27 rows=1 width=60) (actual time=0.084..0.087 rows=1 loops=1) Index Cond: ((request_id = 16600018::bigint) AND ((user_alias)::text = 'V3GN'::text) AND (create_timestamp = '2012-05-15 18:49:10.619'::timestamp without time zone))

"Index Scan using request_id_user_alias__create_timestamp_idx on request_debug  (cost=0.00..8.27 rows=1 width=60) (actual time=0.084..0.087 rows=1 loops=1)"
"  Index Cond: ((request_id = 16600018::bigint) AND ((user_alias)::text = 'V3GN'::text) AND (create_timestamp = '2012-05-15 18:49:10.619'::timestamp without time zone))"
"Total runtime: 0.154 ms"

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	0.087 ms	100.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
request_debug	1	0.087 ms	100.0 %
Index Scan	1	0.087 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: GAm

Colorize:

Columns visibility:

Per node type stats

Per table stats