explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bk4Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 170.119 ↑ 1.0 10 1

Limit (cost=0.57..39.44 rows=10 width=4) (actual time=13.121..170.119 rows=10 loops=1)

2. 170.108 170.108 ↑ 34,870.8 10 1

Index Scan using idx_datarilev on p_inbox_nonpartizionata (cost=0.57..1,355,371.99 rows=348,708 width=4) (actual time=13.119..170.108 rows=10 loops=1)

  • Index Cond: ((datarilev >= '2017-02-02 00:00:00'::timestamp without time zone) AND (datarilev <= '2017-02-03 00:00:00'::timestamp without time zone))
Planning time : 0.216 ms
Execution time : 170.160 ms