explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2mlz

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.080 ↑ 1.0 1 1

Sort (cost=3.66..3.66 rows=1 width=145) (actual time=0.079..0.080 rows=1 loops=1)

  • Sort Key: ordering
  • Sort Method: quicksort Memory: 25kB
2. 0.058 0.058 ↑ 1.0 1 1

Seq Scan on cms_menu_item (cost=0.00..3.65 rows=1 width=145) (actual time=0.052..0.058 rows=1 loops=1)

  • Filter: ((type = 'A'::bpchar) AND (seo = '/home'::text))
  • Rows Removed by Filter: 109
Planning time : 0.404 ms
Execution time : 0.138 ms