explain.depesz.com

PostgreSQL's explain analyze made readable

Result: syGf

Settings
# exclusive inclusive rows x rows loops node
1. 0.071 68,339.715 ↑ 1.0 1 1

Sort (cost=74,483.52..74,483.53 rows=1 width=33) (actual time=68,339.714..68,339.715 rows=1 loops=1)

  • Output: resourcegr0_.id, resourcegr0_.bdatetime, resourcegr0_.edatetime, resourcegr0_.is_disabled, resourcegr0_.resource_id, resourcegr0_.group_id, resourcegr0_.role_id
  • Sort Key: resourcegr0_.edatetime
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=49414 read=4120 dirtied=29
  • I/O Timings: read=32515.368
2. 37.139 68,339.644 ↑ 1.0 1 1

Nested Loop (cost=0.86..74,483.51 rows=1 width=33) (actual time=1,637.342..68,339.644 rows=1 loops=1)

  • Output: resourcegr0_.id, resourcegr0_.bdatetime, resourcegr0_.edatetime, resourcegr0_.is_disabled, resourcegr0_.resource_id, resourcegr0_.group_id, resourcegr0_.role_id
  • Buffers: shared hit=49411 read=4120 dirtied=29
  • I/O Timings: read=32515.368
3. 67,123.085 67,123.085 ↓ 1.3 10,722 1

Index Scan using sr_res_group_id_is_system_ix on public.sr_res_group resourcegr1_ (cost=0.29..2,775.84 rows=8,347 width=4) (actual time=8.934..67,123.085 rows=10,722 loops=1)

  • Output: resourcegr1_.id, resourcegr1_.bdate, resourcegr1_.edate, resourcegr1_.is_system, resourcegr1_.name, resourcegr1_.org_id, resourcegr1_.department_id, resourcegr1_.responsible_id, resourcegr1_.is_available_in_electronic_queue, resourcegr1_.label_id, resourcegr1_.ignore_regclinic_check, resourcegr1_.note, resourcegr1_.blocked, resourcegr1_.block_comment, resourcegr1_.template_res_group_id, resourcegr1_.aud_who, resourcegr1_.aud_when, resourcegr1_.aud_source, resourcegr1_.aud_who_create, resourcegr1_.aud_when_create, resourcegr1_.aud_source_create, resourcegr1_.emergency, resourcegr1_.ignore_districts, resourcegr1_.service_template_id
  • Buffers: shared hit=6683 read=3945 dirtied=29
  • I/O Timings: read=31442.550
4. 1,179.420 1,179.420 ↓ 0.0 0 10,722

Index Scan using sr_res_group_relationship_resource_id_group_id_ix on public.sr_res_group_relationship resourcegr0_ (cost=0.57..8.58 rows=1 width=33) (actual time=0.110..0.110 rows=0 loops=10,722)

  • Output: resourcegr0_.id, resourcegr0_.bdatetime, resourcegr0_.edatetime, resourcegr0_.resource_id, resourcegr0_.group_id, resourcegr0_.role_id, resourcegr0_.is_disabled, resourcegr0_.aud_who, resourcegr0_.aud_when, resourcegr0_.aud_source, resourcegr0_.aud_who_create, resourcegr0_.aud_when_create, resourcegr0_.aud_source_create
  • Index Cond: ((resourcegr0_.resource_id = 239) AND (resourcegr0_.group_id = resourcegr1_.id))
  • Filter: ((resourcegr0_.group_id <> 100667717) AND ((resourcegr0_.bdatetime IS NULL) OR (resourcegr0_.bdatetime <= '2100-10-09 17:46:13.878'::timestamp without time zone)) AND ((resourcegr0_.edatetime IS NULL) OR (resourcegr0_.edatetime >= '2019-10-09 17:46:13.878'::timestamp without time zone)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=42728 read=175
  • I/O Timings: read=1072.818
Planning time : 78.335 ms
Execution time : 68,339.841 ms