explain.depesz.com

PostgreSQL's explain analyze made readable

Result: msj8

Settings
# exclusive inclusive rows x rows loops node
1. 6.078 1,375.713 ↑ 1.0 101 1

Limit (cost=426,304.01..426,304.26 rows=101 width=314) (actual time=1,375.666..1,375.713 rows=101 loops=1)

2. 705.911 1,369.635 ↑ 5.9 143,901 1

Sort (cost=425,944.51..428,070.24 rows=850,294 width=314) (actual time=1,301.535..1,369.635 rows=143,901 loops=1)

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

Index Scan using index_namespaces_partial_on_type on namespaces (cost=0.42..92,258.74 rows=850,294 width=314) (actual time=0.073..663.724 rows=158,323 loops=1)

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