explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 86S1

Settings
# exclusive inclusive rows x rows loops node
1. 5.711 1,236.057 ↑ 1.0 101 1

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

2. 693.327 1,230.346 ↑ 5.9 143,901 1

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

  • Sort Key: name, id
  • Sort Method: external merge Disk: 28160kB
3. 537.019 537.019 ↑ 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.042..537.019 rows=158,323 loops=1)

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