explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IyYj

Settings
# exclusive inclusive rows x rows loops node
1. 2.116 2.116 ↑ 1.3 158 1

Sort (cost=104.90..105.00 rows=202 width=1,121) (actual time=2.087..2.116 rows=158 loops=1)

  • Sort Key: day
  • Sort Method: quicksort Memory: 102kB
  • (actual time=0.069..1.885 rows=158 loops=1)
2. 0.000 0.000 ↓ 0.0

Index Scan using index_email_sequence_emails_on_email_sequence_id on email_sequence_emails (cost=0.08..103.35 rows=202 width=1,121) (actual rows= loops=)

  • Index Cond: (email_sequence_id = 119,449)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 2
Planning time : 1.222 ms
Execution time : 2.170 ms