explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sl6s : test 2

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.349 ↑ 1.0 100 1

Limit (cost=0.56..13.96 rows=100 width=849) (actual time=0.115..0.349 rows=100 loops=1)

2. 0.334 0.334 ↑ 436,299.3 100 1

Index Scan Backward using ix_url_log_entry_current_log_time on url_log_entry_current (cost=0.56..5,842,871.32 rows=43,629,929 width=849) (actual time=0.114..0.334 rows=100 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)