explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8kHK

Settings
# exclusive inclusive rows x rows loops node
1. 5.715 1,865.674 ↑ 1.0 101 1

Limit (cost=433,772.02..433,772.27 rows=101 width=314) (actual time=1,865.617..1,865.674 rows=101 loops=1)

2. 650.680 1,859.959 ↑ 5.9 143,901 1

Sort (cost=433,412.52..435,538.25 rows=850,294 width=314) (actual time=1,788.606..1,859.959 rows=143,901 loops=1)

  • Sort Key: name, id
  • Sort Method: external merge Disk: 28144kB
3. 1,209.279 1,209.279 ↑ 5.4 158,323 1

Index Scan using index_namespaces_on_type on namespaces (cost=0.43..99,726.75 rows=850,294 width=314) (actual time=0.056..1,209.279 rows=158,323 loops=1)

  • Index Cond: ((type)::text = 'Group'::text)
  • Filter: (visibility_level = 20)
  • Rows Removed by Filter: 859076
Planning time : 0.389 ms
Execution time : 1,870.843 ms