explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mpo

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.025 ↓ 2.5 5 1

Sort (cost=14.38..14.39 rows=2 width=204) (actual time=0.023..0.025 rows=5 loops=1)

  • Sort Key: createddatetimeutc DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.012 0.012 ↓ 2.5 5 1

Seq Scan on pricechecks pc (cost=0.00..14.38 rows=2 width=204) (actual time=0.009..0.012 rows=5 loops=1)

  • Filter: (tripnumber = 1)