explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bfHA

Settings
# exclusive inclusive rows x rows loops node
1. 336.459 432.794 ↓ 1.1 1,448,690 1

Bitmap Heap Scan on t1156_userrolehierarchy (cost=44,847.74..228,174.58 rows=1,344,256 width=4) (actual time=107.028..432.794 rows=1,448,690 loops=1)

  • Recheck Cond: ((c4295_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=62,949
2. 96.335 96.335 ↓ 1.1 1,449,600 1

Bitmap Index Scan on idx_t1156_userrolehierarchy_c4295_ancestor_role_id_end_50471331 (cost=0.00..44,511.68 rows=1,344,256 width=0) (actual time=96.335..96.335 rows=1,449,600 loops=1)

  • Index Cond: ((c4295_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
Planning time : 0.135 ms
Execution time : 485.584 ms