explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jXgv

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.020 ↑ 273.5 4 1

Sort (cost=111.97..114.71 rows=1,094 width=46) (actual time=0.019..0.020 rows=4 loops=1)

  • Sort Key: "voucherId
  • Sort Method: quicksort Memory: 25kB
2. 0.013 0.013 ↑ 273.5 4 1

Seq Scan on voucher_rates (cost=0.00..56.75 rows=1,094 width=46) (actual time=0.011..0.013 rows=4 loops=1)

  • Filter: ("totalCount" <> "purchasedCount")
  • Rows Removed by Filter: 2
Planning time : 0.054 ms
Execution time : 0.036 ms