#	exclusive	inclusive	rows x	rows	loops	node
1.	31.474	86,722.781	↑ 1.0	10,000	1	→ Nested Loop (cost=393.220..84,857.970 rows=10,000 width=764) (actual time=103.726..86,722.781 rows=10,000 loops=1)
2.	17.141	71.307	↑ 1.0	10,000	1	→ HashAggregate (cost=392.660..492.660 rows=10,000 width=61) (actual time=58.926..71.307 rows=10,000 loops=1) Group Key: seven.whiskey
3.	0.888	54.166	↑ 1.0	10,000	1	→ Limit (cost=0.000..267.660 rows=10,000 width=61) (actual time=22.314..54.166 rows=10,000 loops=1)
4.	53.278	53.278	↑ 1,003.8	10,000	1	→ Seq Scan on seven (cost=0.000..268,676.430 rows=10,038,043 width=61) (actual time=22.312..53.278 rows=10,000 loops=1)
5.	86,620.000	86,620.000	↑ 1.0	1	10,000	→ Index Scan using uniform on two (cost=0.560..8.440 rows=1 width=764) (actual time=8.662..8.662 rows=1 loops=10,000) Index Cond: ((november = 'victor'::text) AND (whiskey = seven.whiskey))

Nested Loop  (cost=393.220..84857.970 rows=10000 width=764) (actual time=103.726..86722.781 rows=10000 loops=1)
  ->  HashAggregate  (cost=392.660..492.660 rows=10000 width=61) (actual time=58.926..71.307 rows=10000 loops=1)
          Group Key: seven.whiskey
        ->  Limit  (cost=0.000..267.660 rows=10000 width=61) (actual time=22.314..54.166 rows=10000 loops=1)
              ->  Seq Scan on seven  (cost=0.000..268676.430 rows=10038043 width=61) (actual time=22.312..53.278 rows=10000 loops=1)
  ->  Index Scan using uniform on two  (cost=0.560..8.440 rows=1 width=764) (actual time=8.662..8.662 rows=1 loops=10000)
          Index Cond: ((november = 'victor'::text) AND (whiskey = seven.whiskey))

Per node type stats

node type	count	sum of times	% of query
HashAggregate	1	17.141 ms	0.0 %
Index Scan	1	86,620.000 ms	99.9 %
Limit	1	0.888 ms	0.0 %
Nested Loop	1	31.474 ms	0.0 %
Seq Scan	1	53.278 ms	0.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
seven	1	53.278 ms	0.1 %
Seq Scan	1	53.278 ms	100.0 %
two	1	86,620.000 ms	99.9 %
Index Scan	1	86,620.000 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dhfS : Select names

Color mode:

Visible columns:

Per node type stats

Per table stats