explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uz5W

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.076 ↑ 1.0 1 1

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

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

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

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