explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HRTRC

Settings
# exclusive inclusive rows x rows loops node
1. 2.330 2.839 ↑ 1.0 1,000 1

Sort (cost=75.33..77.83 rows=1,000 width=10) (actual time=2.549..2.839 rows=1,000 loops=1)

  • Sort Key: first_name
  • Sort Method: quicksort Memory: 71kB
2. 0.509 0.509 ↑ 1.0 1,000 1

Seq Scan on personas (cost=0.00..25.50 rows=1,000 width=10) (actual time=0.012..0.509 rows=1,000 loops=1)

  • Filter: (fecha_nacimiento > '1990-01-01'::date)
Planning time : 0.104 ms
Execution time : 3.095 ms