explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nxLx

Settings
# exclusive inclusive rows x rows loops node
1. 0.165 1.261 ↑ 2.3 226 1

Hash Join (cost=197.96..227.91 rows=525 width=5,955) (actual time=1.125..1.261 rows=226 loops=1)

  • Hash Cond: ((process_instance.id_)::text = (process_variable.execution_id_)::text)
2.          

CTE process_variable

3. 0.215 0.619 ↓ 1.1 226 1

Hash Right Join (cost=25.69..160.20 rows=202 width=1,787) (actual time=0.240..0.619 rows=226 loops=1)

  • Hash Cond: ((payload.id_)::text = (var.bytearray_id_)::text)
4. 0.188 0.188 ↓ 1.0 1,214 1

Seq Scan on scp_ge_json payload (cost=0.00..127.66 rows=1,166 width=448) (actual time=0.011..0.188 rows=1,214 loops=1)

5. 0.057 0.216 ↓ 1.1 226 1

Hash (cost=23.16..23.16 rows=202 width=1,376) (actual time=0.216..0.216 rows=226 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 69kB
6. 0.159 0.159 ↓ 1.1 226 1

Seq Scan on act_ru_variable var (cost=0.00..23.16 rows=202 width=1,376) (actual time=0.015..0.159 rows=226 loops=1)

  • Filter: ((name_)::text = ANY ('{KEY_PROCESS_INSTANCE_NAME,KEY_PROCESS_INSTANCE_STATUS,KEY_INTERNAL_ORDER_DETAIL,KEY_INTERNAL_ORDER_LINE_OF_BUSINESS_APPROVAL_REJECTION}'::text[]))
  • Rows Removed by Filter: 231
7.          

CTE process_instance

8. 0.038 0.038 ↑ 6.8 76 1

Seq Scan on act_ru_execution exec (cost=0.00..31.20 rows=520 width=1,003) (actual time=0.016..0.038 rows=76 loops=1)

9. 0.066 0.066 ↑ 6.8 76 1

CTE Scan on process_instance (cost=0.00..10.40 rows=520 width=2,516) (actual time=0.017..0.066 rows=76 loops=1)

10. 0.141 1.030 ↓ 1.1 226 1

Hash (cost=4.04..4.04 rows=202 width=3,439) (actual time=1.030..1.030 rows=226 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 135kB
11. 0.889 0.889 ↓ 1.1 226 1

CTE Scan on process_variable (cost=0.00..4.04 rows=202 width=3,439) (actual time=0.243..0.889 rows=226 loops=1)

Planning time : 3,147.761 ms