#	exclusive	inclusive	rows x	rows	loops	node
1.	0.004	8,921.850	↑ 1.0	12	1	→ Limit (cost=1.14..330.96 rows=12 width=108) (actual time=8,921.684..8,921.850 rows=12 loops=1)
2.	0.008	8,921.846	↑ 6,535.8	12	1	→ Nested Loop (cost=1.14..2,155,591.92 rows=78,429 width=108) (actual time=8,921.682..8,921.846 rows=12 loops=1)
3.	0.016	8,921.826	↑ 6,535.8	12	1	→ Nested Loop (cost=0.86..2,132,645.67 rows=78,429 width=101) (actual time=8,921.676..8,921.826 rows=12 loops=1)
4.	8,921.750	8,921.750	↑ 107,230.9	12	1	→ Index Scan Backward using pk_process on process p (cost=0.44..1,196,804.87 rows=1,286,771 width=48) (actual time=8,921.658..8,921.750 rows=12 loops=1) Filter: (process_template_id = ANY ('{89,112}'::bigint[])) Rows Removed by Filter: 17525193
5.	0.060	0.060	↑ 1.0	1	12	→ Index Scan using idx_entity_uuid on entity e (cost=0.43..0.72 rows=1 width=69) (actual time=0.005..0.005 rows=1 loops=12) Index Cond: (id_uuid = p.filler_id_uuid)
6.	0.012	0.012	↑ 1.0	1	12	→ Index Scan using pk_workflow_state on workflow_state ws (cost=0.28..0.29 rows=1 width=23) (actual time=0.001..0.001 rows=1 loops=12) Index Cond: (id = p.workflow_state_id)

 Limit  (cost=1.14..330.96 rows=12 width=108) (actual time=8921.684..8921.850 rows=12 loops=1)
   ->  Nested Loop  (cost=1.14..2155591.92 rows=78429 width=108) (actual time=8921.682..8921.846 rows=12 loops=1)
         ->  Nested Loop  (cost=0.86..2132645.67 rows=78429 width=101) (actual time=8921.676..8921.826 rows=12 loops=1)
               ->  Index Scan Backward using pk_process on process p  (cost=0.44..1196804.87 rows=1286771 width=48) (actual time=8921.658..8921.750 rows=12 loops=1)
                     Filter: (process_template_id = ANY ('{89,112}'::bigint[]))
                     Rows Removed by Filter: 17525193
               ->  Index Scan using idx_entity_uuid on entity e  (cost=0.43..0.72 rows=1 width=69) (actual time=0.005..0.005 rows=1 loops=12)
                     Index Cond: (id_uuid = p.filler_id_uuid)
         ->  Index Scan using pk_workflow_state on workflow_state ws  (cost=0.28..0.29 rows=1 width=23) (actual time=0.001..0.001 rows=1 loops=12)
               Index Cond: (id = p.workflow_state_id)
 Planning time: 0.403 ms
 Execution time: 8921.887 ms

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	0.072 ms	0.0 %
Index Scan Backward	1	8,921.750 ms	100.0 %
Limit	1	0.004 ms	0.0 %
Nested Loop	2	0.024 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
entity	1	0.060 ms	0.0 %
Index Scan	1	0.060 ms	100.0 %
process	1	8,921.750 ms	100.0 %
Index Scan Backward	1	8,921.750 ms	100.0 %
workflow_state	1	0.012 ms	0.0 %
Index Scan	1	0.012 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2O63

Color mode:

Visible columns:

Per node type stats

Per table stats