explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uYMD

Settings
# exclusive inclusive rows x rows loops node
1. 1.039 5.140 ↓ 170.1 3,231 1

Hash Join (cost=2,182.91..18,222.80 rows=19 width=8) (actual time=1.689..5.140 rows=3,231 loops=1)

  • Hash Cond: (t597_userrolehierarchy.c2582_user_role_id = t498_userroledim.sid)
2. 2.593 2.932 ↑ 1.4 3,231 1

Bitmap Heap Scan on t597_userrolehierarchy (cost=217.91..16,246.19 rows=4,424 width=12) (actual time=0.511..2.932 rows=3,231 loops=1)

  • Recheck Cond: ((c2583_ancestor_role_id = 33,216) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=1,628
3. 0.339 0.339 ↑ 1.4 3,273 1

Bitmap Index Scan on idx_t597_userrolehierarchy_c2583_ancestor_role_id_end_s50463952 (cost=0.00..216.80 rows=4,424 width=0) (actual time=0.339..0.339 rows=3,273 loops=1)

  • Index Cond: ((c2583_ancestor_role_id = 33,216) AND (end_stamp = '32503680000000'::bigint))
4. 0.118 1.169 ↓ 1.8 837 1

Hash (cost=1,959.17..1,959.17 rows=466 width=4) (actual time=1.169..1.169 rows=837 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 38kB
5. 0.922 1.051 ↓ 1.8 837 1

Bitmap Heap Scan on t498_userroledim (cost=69.42..1,959.17 rows=466 width=4) (actual time=0.188..1.051 rows=837 loops=1)

  • Recheck Cond: ((end_stamp = '32503680000000'::bigint) AND ((c2241_portaltype IS NULL) OR (c2241_portaltype = 'None'::text)))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
  • Rows Removed by Filter: 200
  • Heap Blocks: exact=534
6. 0.129 0.129 ↓ 1.9 1,045 1

Bitmap Index Scan on "idx_1_t498_userroledim_sid_start_stamp_end_stamp_(c2241_portalt" (cost=0.00..69.31 rows=538 width=0) (actual time=0.129..0.129 rows=1,045 loops=1)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
Planning time : 0.487 ms
Execution time : 5.311 ms