#	rows x	node
1.	↓ 0.0	→ Merge Join (cost=0.00..3057.48 rows=16947 width=2035) (actual time=.. rows= loops=) Merge Cond: (sp.id = sm.picking_id)
2.	↓ 0.0	→ Index Scan using stock_picking_pkey on stock_picking sp (cost=0.00..363.51 rows=4147 width=826) (actual time=.. rows= loops=)
3.	↓ 0.0	→ Index Scan using stock_move_picking_id_index on stock_move sm (cost=0.00..5726.72 rows=39259 width=1209) (actual time=.. rows= loops=)

"Merge Join  (cost=0.00..3057.48 rows=16947 width=2035)"
"  Merge Cond: (sp.id = sm.picking_id)"
"  ->  Index Scan using stock_picking_pkey on stock_picking sp  (cost=0.00..363.51 rows=4147 width=826)"
"  ->  Index Scan using stock_move_picking_id_index on stock_move sm  (cost=0.00..5726.72 rows=39259 width=1209)"

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	0.000 ms	0.0 %
Merge Join	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
stock_move	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
stock_picking	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: YxL

Colorize:

Columns visibility:

Per node type stats

Per table stats