explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pgl8

Settings
# exclusive inclusive rows x rows loops node
1. 14.769 4,143.147 ↓ 47.4 83,649 1

Limit (cost=0.57..78.87 rows=1,765 width=95) (actual time=2.447..4,143.147 rows=83,649 loops=1)

2. 4,128.378 4,128.378 ↓ 47.4 83,649 1

Index Scan Backward using idx_tag_updatetime on "Tag" (cost=0.57..78.87 rows=1,765 width=95) (actual time=2.446..4,128.378 rows=83,649 loops=1)

  • Index Cond: (("updateTime" >= '1562130248865'::bigint) AND ("updateTime" < '1562130250865'::bigint))
Planning time : 3.892 ms