#	exclusive	inclusive	rows x	rows	loops	node
1.	0.046	40.274	↑ 1.0	1	1	→ Index Scan using m_productionline_pkey on m_productionline (cost=0.42..7.18 rows=1 width=819) (actual time=40.274..40.274 rows=1 loops=1) Index Cond: (m_productionline_id = '5000003'::numeric)
2.						SubPlan (forIndex Scan)
3.	40.219	40.219	↑ 1.0	1	1	→ Seq Scan on m_locator l (cost=0.00..2.04 rows=1 width=32) (actual time=40.216..40.219 rows=1 loops=1) Filter: (m_locator_id = m_productionline.m_locator_id) Rows Removed by Filter: 22
4.	0.009	0.009	↑ 1.0	1	1	→ Index Scan using m_product_pkey on m_product (cost=0.28..2.50 rows=1 width=2) (actual time=0.009..0.009 rows=1 loops=1) Index Cond: (m_product_id = m_productionline.m_product_id)

Index Scan using m_productionline_pkey on m_productionline  (cost=0.42..7.18 rows=1 width=819) (actual time=40.274..40.274 rows=1 loops=1)
  Index Cond: (m_productionline_id = '5000003'::numeric)
  SubPlan 1
    ->  Seq Scan on m_locator l  (cost=0.00..2.04 rows=1 width=32) (actual time=40.216..40.219 rows=1 loops=1)
          Filter: (m_locator_id = m_productionline.m_locator_id)
          Rows Removed by Filter: 22
  SubPlan 2
    ->  Index Scan using m_product_pkey on m_product  (cost=0.28..2.50 rows=1 width=2) (actual time=0.009..0.009 rows=1 loops=1)
          Index Cond: (m_product_id = m_productionline.m_product_id)
Planning time: 0.400 ms
Execution time: 40.351 ms

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	0.055 ms	0.1 %
Seq Scan	1	40.219 ms	99.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
m_locator	1	40.219 ms	99.9 %
Seq Scan	1	40.219 ms	100.0 %
m_product	1	0.009 ms	0.0 %
Index Scan	1	0.009 ms	100.0 %
m_productionline	1	0.046 ms	0.1 %
Index Scan	1	0.046 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CrZt

Color mode:

Visible columns:

Per node type stats

Per table stats