explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aUC9

Settings
# exclusive inclusive rows x rows loops node
1. 199.952 571.154 ↓ 1.2 128,160 1

Hash Join (cost=64,363.10..251,218.66 rows=105,072 width=4) (actual time=126.465..571.154 rows=128,160 loops=1)

  • Hash Cond: (t1156_userrolehierarchy.c4294_user_role_id = t961_userroledim.sid)
2. 255.422 349.016 ↓ 1.1 1,448,690 1

Bitmap Heap Scan on t1156_userrolehierarchy (cost=44,847.74..228,174.58 rows=1,344,256 width=8) (actual time=104.146..349.016 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
3. 93.594 93.594 ↓ 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=93.594..93.594 rows=1,449,600 loops=1)

  • Index Cond: ((c4295_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
4. 1.101 22.186 ↑ 2.9 7,010 1

Hash (cost=19,260.14..19,260.14 rows=20,417 width=4) (actual time=22.186..22.186 rows=7,010 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 503kB
5. 17.596 21.085 ↑ 2.9 7,010 1

Bitmap Heap Scan on t961_userroledim (cost=1,302.90..19,260.14 rows=20,417 width=4) (actual time=4.535..21.085 rows=7,010 loops=1)

  • Recheck Cond: ((end_stamp = '32503680000000'::bigint) AND ((c3644_portaltype IS NULL) OR (c3644_portaltype = 'None'::text)))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
  • Rows Removed by Filter: 27,775
  • Heap Blocks: exact=7,289
6. 3.489 3.489 ↓ 1.6 34,787 1

Bitmap Index Scan on ix_t961_userroledim_sid_timestamp_partial (cost=0.00..1,297.79 rows=21,377 width=0) (actual time=3.489..3.489 rows=34,787 loops=1)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
Planning time : 0.442 ms
Execution time : 576.399 ms