explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fFJe

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 3.643 ↑ 1.0 1 1

Limit (cost=0.56..11,492.05 rows=1 width=8) (actual time=3.642..3.643 rows=1 loops=1)

2. 0.002 3.641 ↑ 121.0 1 1

Group (cost=0.56..1,390,470.85 rows=121 width=8) (actual time=3.640..3.641 rows=1 loops=1)

  • Group Key: day_id
3. 3.639 3.639 ↑ 221.0 1 1

Index Scan using index_report_daily_by_domain_action_results_on_day_id on report_daily_by_domain_action_results (cost=0.56..1,390,470.30 rows=221 width=4) (actual time=3.639..3.639 rows=1 loops=1)

  • Index Cond: ((day_id >= 20191231) AND (day_id <= 20200130))
  • Filter: ((messages_untrusted_count > 0) AND ((mpi_key)::text = 'd43417c6-43e3-40ca-8b1d-391492ed2048'::text))
  • Rows Removed by Filter: 12857
Planning time : 0.169 ms
Execution time : 3.675 ms