explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dtup

Settings
# exclusive inclusive rows x rows loops node
1. 0.367 0.731 ↑ 1.1 300 1

Sort (cost=73.300..74.130 rows=330 width=12) (actual time=0.613..0.731 rows=300 loops=1)

  • Sort Key: four
  • Sort Method: quicksort Memory: 39kB
2. 0.364 0.364 ↑ 1.1 300 1

Seq Scan on bravo (cost=0.000..59.500 rows=330 width=12) (actual time=0.014..0.364 rows=300 loops=1)

  • Filter: (quebec < 10000)
  • Rows Removed by Filter: 2700