#	exclusive	inclusive	rows x	rows	loops	node
1.	5.382	420.815	↑ 1.0	10,000	1	→ Nested Loop (cost=393.250..27,802.410 rows=10,000 width=762) (actual time=51.168..420.815 rows=10,000 loops=1)
2.	12.421	55.433	↑ 1.0	10,000	1	→ HashAggregate (cost=392.690..492.690 rows=10,000 width=60) (actual time=50.951..55.433 rows=10,000 loops=1) Group Key: seven.whiskey
3.	1.416	43.012	↑ 1.0	10,000	1	→ Limit (cost=0.000..267.690 rows=10,000 width=60) (actual time=11.158..43.012 rows=10,000 loops=1)
4.	41.596	41.596	↑ 1,003.6	10,000	1	→ Seq Scan on seven (cost=0.000..268,655.220 rows=10,035,922 width=60) (actual time=11.155..41.596 rows=10,000 loops=1)
5.	360.000	360.000	↑ 1.0	1	10,000	→ Index Scan using uniform on two (cost=0.560..2.730 rows=1 width=762) (actual time=0.036..0.036 rows=1 loops=10,000) Index Cond: ((november = 'victor'::text) AND (whiskey = seven.whiskey))

Nested Loop  (cost=393.250..27802.410 rows=10000 width=762) (actual time=51.168..420.815 rows=10000 loops=1)
  ->  HashAggregate  (cost=392.690..492.690 rows=10000 width=60) (actual time=50.951..55.433 rows=10000 loops=1)
          Group Key: seven.whiskey
        ->  Limit  (cost=0.000..267.690 rows=10000 width=60) (actual time=11.158..43.012 rows=10000 loops=1)
              ->  Seq Scan on seven  (cost=0.000..268655.220 rows=10035922 width=60) (actual time=11.155..41.596 rows=10000 loops=1)
  ->  Index Scan using uniform on two  (cost=0.560..2.730 rows=1 width=762) (actual time=0.036..0.036 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	12.421 ms	3.0 %
Index Scan	1	360.000 ms	85.5 %
Limit	1	1.416 ms	0.3 %
Nested Loop	1	5.382 ms	1.3 %
Seq Scan	1	41.596 ms	9.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
seven	1	41.596 ms	9.9 %
Seq Scan	1	41.596 ms	100.0 %
two	1	360.000 ms	85.5 %
Index Scan	1	360.000 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bot : Optimized execution plan

Color mode:

Visible columns:

Per node type stats

Per table stats