explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NlUm

Settings
# exclusive inclusive rows x rows loops node
1. 234.744 234.744 ↑ 1.0 128,160 1

Index Only Scan using idx_urhierachy_sid_c663_ancestor_role_id_50471331 on urhierachy urh199_ht0 (cost=0.43..103,446.05 rows=132,334 width=4) (actual time=1.538..234.744 rows=128,160 loops=1)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
  • Filter: (c663_ancestor_role_id = ANY ('{436,247157}'::integer[]))
  • Rows Removed by Filter: 712,495
  • Heap Fetches: 363
Planning time : 0.094 ms
Execution time : 240.542 ms