explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BcvI

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 9,840.033 ↑ 1.0 12 1

Limit (cost=1.14..323.51 rows=12 width=108) (actual time=9,839.639..9,840.033 rows=12 loops=1)

2. 0.013 9,840.030 ↑ 6,413.5 12 1

Nested Loop (cost=1.14..2,067,502.16 rows=76,962 width=108) (actual time=9,839.638..9,840.030 rows=12 loops=1)

3. 0.011 9,840.005 ↑ 6,413.5 12 1

Nested Loop (cost=0.86..2,044,980.75 rows=76,962 width=101) (actual time=9,839.630..9,840.005 rows=12 loops=1)

4. 9,839.754 9,839.754 ↑ 104,465.9 12 1

Index Scan using uk_process_id on process p (cost=0.44..1,181,084.84 rows=1,253,591 width=48) (actual time=9,839.596..9,839.754 rows=12 loops=1)

  • Filter: (process_template_id = ANY ('{89,112}'::bigint[]))
  • Rows Removed by Filter: 17555021
5. 0.240 0.240 ↑ 1.0 1 12

Index Scan using idx_entity_uuid on entity e (cost=0.43..0.68 rows=1 width=69) (actual time=0.020..0.020 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)