explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MMnT

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.153 ↑ 1.0 10 1

Limit (cost=0.00..8.53 rows=10 width=228) (actual time=0.149..0.153 rows=10 loops=1)

2. 0.150 0.150 ↑ 34,550.2 10 1

Seq Scan on p_inbox_201702 (cost=0.00..294,739.28 rows=345,502 width=228) (actual time=0.148..0.150 rows=10 loops=1)

  • Filter: ((datarilev >= '2017-02-02 00:00:00'::timestamp without time zone) AND (datarilev <= '2017-02-03 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 514
Planning time : 0.140 ms
Execution time : 0.188 ms