#	exclusive	inclusive	rows x	rows	loops	node
1.	35.060	64,607.813	↑ 1.0	10,000	1	→ Nested Loop (cost=393.250..84,858.010 rows=10,000 width=762) (actual time=32.897..64,607.813 rows=10,000 loops=1)
2.	19.668	32.753	↑ 1.0	10,000	1	→ HashAggregate (cost=392.690..492.690 rows=10,000 width=60) (actual time=17.926..32.753 rows=10,000 loops=1) Group Key: seven.whiskey
3.	1.072	13.085	↑ 1.0	10,000	1	→ Limit (cost=0.000..267.690 rows=10,000 width=60) (actual time=0.018..13.085 rows=10,000 loops=1)
4.	12.013	12.013	↑ 1,003.6	10,000	1	→ Seq Scan on seven (cost=0.000..268,655.220 rows=10,035,922 width=60) (actual time=0.016..12.013 rows=10,000 loops=1)
5.	64,540.000	64,540.000	↑ 1.0	1	10,000	→ Index Scan using uniform on two (cost=0.560..8.440 rows=1 width=762) (actual time=6.454..6.454 rows=1 loops=10,000) Index Cond: ((november = 'victor'::text) AND (whiskey = seven.whiskey))

Nested Loop  (cost=393.250..84858.010 rows=10000 width=762) (actual time=32.897..64607.813 rows=10000 loops=1)
  ->  HashAggregate  (cost=392.690..492.690 rows=10000 width=60) (actual time=17.926..32.753 rows=10000 loops=1)
          Group Key: seven.whiskey
        ->  Limit  (cost=0.000..267.690 rows=10000 width=60) (actual time=0.018..13.085 rows=10000 loops=1)
              ->  Seq Scan on seven  (cost=0.000..268655.220 rows=10035922 width=60) (actual time=0.016..12.013 rows=10000 loops=1)
  ->  Index Scan using uniform on two  (cost=0.560..8.440 rows=1 width=762) (actual time=6.454..6.454 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	19.668 ms	0.0 %
Index Scan	1	64,540.000 ms	99.9 %
Limit	1	1.072 ms	0.0 %
Nested Loop	1	35.060 ms	0.1 %
Seq Scan	1	12.013 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
seven	1	12.013 ms	0.0 %
Seq Scan	1	12.013 ms	100.0 %
two	1	64,540.000 ms	99.9 %
Index Scan	1	64,540.000 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fkSV : After the analyze

Color mode:

Visible columns:

Per node type stats

Per table stats