explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UJ2M

Settings
# exclusive inclusive rows x rows loops node
1. 63.388 616.014 ↑ 187.0 1 1

GroupAggregate (cost=12,230.15..685,004.43 rows=187 width=16) (actual time=616.014..616.014 rows=1 loops=1)

  • Group Key: site_id
  • Buffers: shared hit=269,590
2. 491.457 552.626 ↑ 1.0 328,955 1

Bitmap Heap Scan on "user" u (cost=12,230.15..683,308.63 rows=338,785 width=16) (actual time=132.419..552.626 rows=328,955 loops=1)

  • Recheck Cond: (site_id = 14)
  • Heap Blocks: exact=266,358
  • Buffers: shared hit=269,590
3. 61.169 61.169 ↑ 1.0 329,528 1

Bitmap Index Scan on ix_user_site_id (cost=0.00..12,145.45 rows=338,785 width=0) (actual time=61.168..61.169 rows=329,528 loops=1)

  • Index Cond: (site_id = 14)
  • Buffers: shared hit=3,232
Planning time : 0.077 ms
Execution time : 617.602 ms