#	rows x	node
1.	↓ 0.0	→ Aggregate (cost=835.27..835.28 rows=1 width=32) (actual rows= loops=)
2.	↓ 0.0	→ Nested Loop (cost=28.92..826.92 rows=1,113 width=10) (actual rows= loops=)
3.	↓ 0.0	→ Seq Scan on products (cost=0.00..2.25 rows=1 width=14) (actual rows= loops=) Filter: (product_id = 1)
4.	↓ 0.0	→ Bitmap Heap Scan on line_items (cost=28.92..813.54 rows=1,113 width=12) (actual rows= loops=) Recheck Cond: (product_id = 1)
5.	↓ 0.0	→ Bitmap Index Scan on li_product (cost=0.00..28.64 rows=1,113 width=0) (actual rows= loops=) Index Cond: (product_id = 1)

                                       QUERY PLAN
-----------------------------------------------------------------------------------------
 Aggregate  (cost=835.27..835.28 rows=1 width=32)
   ->  Nested Loop  (cost=28.92..826.92 rows=1113 width=10)
         ->  Seq Scan on products  (cost=0.00..2.25 rows=1 width=14)
               Filter: (product_id = 1)
         ->  Bitmap Heap Scan on line_items  (cost=28.92..813.54 rows=1113 width=12)
               Recheck Cond: (product_id = 1)
               ->  Bitmap Index Scan on li_product  (cost=0.00..28.64 rows=1113 width=0)
                     Index Cond: (product_id = 1)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.000 ms	0.0 %
Bitmap Heap Scan	1	0.000 ms	0.0 %
Bitmap Index Scan	1	0.000 ms	0.0 %
Nested Loop	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
line_items	1	0.000 ms	0.0 %
Bitmap Heap Scan	1	0.000 ms	0.0 %
products	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2i5L : For Chris

Color mode:

Visible columns:

Per node type stats

Per table stats