explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hP61

Settings
# exclusive inclusive rows x rows loops node
1. 0.292 91,470.576 ↓ 3,001.0 3,001 1

Limit (cost=15,362.88..27,398.65 rows=1 width=8) (actual time=91,464.580..91,470.576 rows=3,001 loops=1)

  • Buffers: shared hit=10875 read=113325 dirtied=3943
2. 1.166 91,470.284 ↓ 3,001.0 3,001 1

Hash Join (cost=15,362.88..27,398.65 rows=1 width=8) (actual time=91,464.579..91,470.284 rows=3,001 loops=1)

  • Hash Cond: (sentry_groupenvironment.group_id = sentry_groupedmessage.id)
  • Buffers: shared hit=10875 read=113325 dirtied=3943
3. 4.605 4.605 ↑ 3.6 3,019 1

Index Only Scan using sentry_groupenvironment_environment_id_group_id_jtcunning on sentry_groupenvironment (cost=0.57..11,995.39 rows=10,918 width=4) (actual time=0.042..4.605 rows=3,019 loops=1)

  • Index Cond: (environment_id = 328784)
  • Heap Fetches: 1562
  • Buffers: shared hit=1925 read=8
4. 198.444 91,464.513 ↓ 15.1 113,177 1

Hash (cost=15,268.69..15,268.69 rows=7,490 width=8) (actual time=91,464.513..91,464.513 rows=113,177 loops=1)

  • Buckets: 131072 (originally 8192) Batches: 1 (originally 1) Memory Usage: 5445kB
  • Buffers: shared hit=8950 read=113317 dirtied=3943
5. 91,266.069 91,266.069 ↓ 15.1 113,177 1

Index Scan using sentry_groupedmessage_project_first_seen_status on sentry_groupedmessage (cost=0.57..15,268.69 rows=7,490 width=8) (actual time=0.883..91,266.069 rows=113,177 loops=1)

  • Index Cond: (project_id = 1293149)
  • Filter: (last_seen >= '2019-07-10 09:30:37.719322+00'::timestamp with time zone)
  • Rows Removed by Filter: 16
  • Buffers: shared hit=8950 read=113317 dirtied=3943
Planning time : 0.609 ms
Execution time : 91,470.799 ms