explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vJmR : Optimization for: plan #LvZ

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.032 6.729 ↑ 1.0 1 1

Sort (cost=1.39..1.39 rows=1 width=77) (actual time=6.728..6.729 rows=1 loops=1)

  • Sort Key: history_type_orderby
  • Sort Method: quicksort Memory: 25kB
  • Planning time: 15.692 ms
  • Execution time: 6.773 ms
2. 6.697 6.697 ↑ 1.0 1 1

Seq Scan on history_type (cost=0.00..1.38 rows=1 width=77) (actual time=6.696..6.697 rows=1 loops=1)

  • Filter: ((history_type_isactive IS TRUE) AND (history_type_id = 1))
  • Rows Removed by Filter: 29