explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DODM

Settings
# exclusive inclusive rows x rows loops node
1. 9.626 9.626 ↓ 1,146.7 12,614 1

Index Scan using urhierarchy_c2583_ancestor_role_id_end_s50463952 on urhierarchy urh199_ht0 (cost=0.42..53.07 rows=11 width=4) (actual time=0.023..9.626 rows=12,614 loops=1)

  • Index Cond: ((c1479_ancestor_role_id = ANY ('{29152,1181}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
Planning time : 0.076 ms
Execution time : 10.107 ms