explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R2BM

Settings
# exclusive inclusive rows x rows loops node
1. 5.826 5.826 ↓ 1.6 3,231 1

Index Only Scan using urhierarchy_sid_c2583_ancestor_role_id_e50463952 on urhierarchy urh199_ht0 (cost=0.42..6,627.76 rows=2,069 width=4) (actual time=0.231..5.826 rows=3,231 loops=1)

  • Index Cond: ((c1479_ancestor_role_id = 33,216) AND (end_stamp = '32503680000000'::bigint))
  • Heap Fetches: 0
Planning time : 0.417 ms
Execution time : 5.963 ms