explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l66

Settings
# exclusive inclusive rows x rows loops node
1. 38.358 1,475.778 ↑ 187.0 1 1

GroupAggregate (cost=12,230.06..684,982.42 rows=187 width=16) (actual time=1,475.778..1,475.778 rows=1 loops=1)

  • Group Key: site_id
  • Buffers: shared hit=269577
2. 1,335.171 1,437.420 ↑ 1.0 328,945 1

Bitmap Heap Scan on "user" u (cost=12,230.06..683,286.68 rows=338,774 width=16) (actual time=110.339..1,437.420 rows=328,945 loops=1)

  • Recheck Cond: (site_id = 14)
  • Rows Removed by Index Recheck: 6837452
  • Heap Blocks: exact=32547 lossy=233798
  • Buffers: shared hit=269577
3. 102.249 102.249 ↑ 1.0 329,508 1

Bitmap Index Scan on ix_user_site_id (cost=0.00..12,145.37 rows=338,774 width=0) (actual time=102.249..102.249 rows=329,508 loops=1)

  • Index Cond: (site_id = 14)
  • Buffers: shared hit=3232
Planning time : 0.083 ms
Execution time : 1,476.520 ms