explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pxdBo

Settings
# exclusive inclusive rows x rows loops node
1. 53.766 502.566 ↓ 3.9 12,614 1

Gather (cost=39,400.55..340,914.60 rows=3,226 width=4) (actual time=74.372..502.566 rows=12,614 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 26.669 448.800 ↓ 3.1 4,205 3 / 3

Hash Join (cost=38,400.55..339,592.00 rows=1,344 width=4) (actual time=28.416..448.800 rows=4,205 loops=3)

  • Hash Cond: (t597_userrolehierarchy.c2582_user_role_id = t498_userroledim.sid)
3. 398.760 420.732 ↑ 1.4 223,735 3 / 3

Parallel Bitmap Heap Scan on t597_userrolehierarchy (cost=36,472.30..336,830.21 rows=317,527 width=8) (actual time=26.823..420.732 rows=223,735 loops=3)

  • Recheck Cond: ((c2583_ancestor_role_id = ANY ('{29152,1181}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Index Recheck: 1,565,995
  • Heap Blocks: exact=13,240 lossy=23,389
4. 21.972 21.972 ↑ 1.1 672,783 1 / 3

Bitmap Index Scan on idx_t597_userrolehierarchy_c2583_ancestor_role_id_end_s50463952 (cost=0.00..36,281.79 rows=762,065 width=0) (actual time=65.914..65.915 rows=672,783 loops=1)

  • Index Cond: ((c2583_ancestor_role_id = ANY ('{29152,1181}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
5. 0.105 1.399 ↓ 1.8 838 3 / 3

Hash (cost=1,922.55..1,922.55 rows=456 width=4) (actual time=1.399..1.399 rows=838 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 38kB
6. 1.150 1.294 ↓ 1.8 838 3 / 3

Bitmap Heap Scan on t498_userroledim (cost=69.35..1,922.55 rows=456 width=4) (actual time=0.205..1.294 rows=838 loops=3)

  • 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
7. 0.144 0.144 ↓ 2.0 1,038 3 / 3

Bitmap Index Scan on "idx_1_t498_userroledim_sid_start_stamp_end_stamp_(c2241_portalt" (cost=0.00..69.24 rows=527 width=0) (actual time=0.144..0.144 rows=1,038 loops=3)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
Planning time : 0.458 ms
Execution time : 503.119 ms