explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IeNm

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 1.609 ↑ 2.3 6 1

Sort (cost=148.00..148.03 rows=14 width=96) (actual time=1.609..1.609 rows=6 loops=1)

  • Sort Key: name
  • Sort Method: quicksort Memory: 25kB
2. 1.554 1.554 ↑ 2.3 6 1

Seq Scan on sys_bpmn_process_settings bpmnproces0_ (cost=0.00..147.73 rows=14 width=96) (actual time=0.024..1.554 rows=6 loops=1)

  • Filter: (actual_for_process AND (bpmn_process_id = ANY ('{1,2,3,4,5,6}'::bigint[])))
  • Rows Removed by Filter: 3366
Planning time : 0.175 ms
Execution time : 1.649 ms