explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Slbn

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 511,634.543 ↑ 1.0 101 1

Limit (cost=0.43..760.45 rows=101 width=499) (actual time=510,634.154..511,634.543 rows=101 loops=1)

2. 511,634.487 511,634.487 ↑ 1,157.4 101 1

Index Scan using productindex_bookingnumber on productindexdata this_ (cost=0.43..879,665.51 rows=116,900 width=499) (actual time=510,634.151..511,634.487 rows=101 loops=1)

  • Filter: ((issuedatetime >= '2019-01-01 00:00:00'::timestamp without time zone) AND (issuedatetime <= '2019-05-31 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1293262
Planning time : 3.980 ms
Execution time : 511,635.486 ms