explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iBNW

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 9,163.816 ↑ 1.0 12 1

Limit (cost=1.14..330.96 rows=12 width=108) (actual time=9,163.482..9,163.816 rows=12 loops=1)

2. 0.009 9,163.812 ↑ 6,535.8 12 1

Nested Loop (cost=1.14..2,155,591.92 rows=78,429 width=108) (actual time=9,163.481..9,163.812 rows=12 loops=1)

3. 0.016 9,163.779 ↑ 6,535.8 12 1

Nested Loop (cost=0.86..2,132,645.67 rows=78,429 width=101) (actual time=9,163.465..9,163.779 rows=12 loops=1)

4. 9,163.571 9,163.571 ↑ 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=9,163.423..9,163.571 rows=12 loops=1)

  • Filter: (process_template_id = ANY ('{89,112}'::bigint[]))
  • Rows Removed by Filter: 17525193
5. 0.192 0.192 ↑ 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.016..0.016 rows=1 loops=12)

  • Index Cond: (id_uuid = p.filler_id_uuid)
6. 0.024 0.024 ↑ 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.002..0.002 rows=1 loops=12)

  • Index Cond: (id = p.workflow_state_id)