explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d40

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4.315 ↓ 1.5 361 1

Nested Loop Semi Join (cost=60.49..16,972.46 rows=234 width=4) (actual time=0.641..4.315 rows=361 loops=1)

  • Planning time: 0.945 ms
  • Execution time: 4.379 ms
2. 0.366 3.644 ↓ 1.5 361 1

Nested Loop Semi Join (cost=60.07..15,588.57 rows=234 width=8) (actual time=0.631..3.644 rows=361 loops=1)

3. 0.370 0.473 ↑ 2.0 935 1

Bitmap Heap Scan on t166_userrolehierarchy (cost=59.64..6,841.91 rows=1,861 width=8) (actual time=0.118..0.473 rows=935 loops=1)

  • Recheck Cond: ((c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=131
4. 0.103 0.103 ↑ 2.0 945 1

Bitmap Index Scan on ix_t166_userrolehierarchy_ancestor_end_start_timestamp (cost=0.00..59.17 rows=1,861 width=0) (actual time=0.103..0.103 rows=945 loops=1)

  • Index Cond: ((c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
5. 2.805 2.805 ↓ 0.0 0 935

Index Only Scan using ix_distinctclosedateowner_owner_closedate on distinctclosedateowner (cost=0.43..24.22 rows=6 width=4) (actual time=0.003..0.003 rows=0 loops=935)

  • Index Cond: ((ownerid = t166_userrolehierarchy.sid) AND (closedate <= 20190131) AND (closedate >= 20181101))
  • Heap Fetches: 361
6. 0.722 0.722 ↑ 1.0 1 361

Index Scan using ix_t67_userroledim_sid_timestamp_partial on t67_userroledim (cost=0.42..5.90 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=361)

  • Index Cond: ((sid = t166_userrolehierarchy.c662_user_role_id) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))