explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 40Dd

Settings
# exclusive inclusive rows x rows loops node
1. 181.698 217.878 ↑ 1.0 303,101 1

Sort (cost=39,154.51..39,912.26 rows=303,101 width=17) (actual time=190.965..217.878 rows=303,101 loops=1)

  • Sort Key: id
  • Sort Method: external sort Disk: 8760kB
2. 36.180 36.180 ↑ 1.0 303,101 1

Seq Scan on test_insert (cost=0.00..5,342.01 rows=303,101 width=17) (actual time=0.038..36.180 rows=303,101 loops=1)