explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GCQR

Settings
# exclusive inclusive rows x rows loops node
1. 34.070 79.901 ↑ 1.0 15,888 1

Sort (cost=6,342.25..6,381.98 rows=15,890 width=177) (actual time=75.167..79.901 rows=15,888 loops=1)

  • Output: id, project_id, properties_id, segment_anonymous_id, customer_user_id, join_timestamp, created_at, updated_at, amp_user_id
  • Sort Key: users.join_timestamp
  • Sort Method: external merge Disk: 2,464kB
  • Buffers: shared hit=399 read=4,249, temp read=308 written=309
2. 45.831 45.831 ↑ 1.0 15,888 1

Seq Scan on public.users (cost=0.00..5,233.46 rows=15,890 width=177) (actual time=2.021..45.831 rows=15,888 loops=1)

  • Output: id, project_id, properties_id, segment_anonymous_id, customer_user_id, join_timestamp, created_at, updated_at, amp_user_id
  • Filter: (users.project_id = 1)
  • Rows Removed by Filter: 32,645
  • Buffers: shared hit=399 read=4,249
Planning time : 0.162 ms
Execution time : 85.095 ms