explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fG9v

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.033 ↑ 273.5 4 1

WindowAgg (cost=111.97..166.67 rows=1,094 width=54) (actual time=0.029..0.033 rows=4 loops=1)

2. 0.008 0.021 ↑ 273.5 4 1

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

  • Sort Key: "voucherId", "orderIndex
  • Sort Method: quicksort Memory: 25kB
3. 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.012..0.013 rows=4 loops=1)

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