explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VtR

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 0.084 ↑ 1.0 19 1

Sort (cost=4.89..4.94 rows=19 width=38) (actual time=0.082..0.084 rows=19 loops=1)

  • Sort Key: foreign_name
  • Sort Method: quicksort Memory: 26kB
2. 0.042 0.042 ↑ 1.0 19 1

Seq Scan on data_source_variable variables0_ (cost=0.00..4.49 rows=19 width=38) (actual time=0.018..0.042 rows=19 loops=1)

  • Filter: (data_source_id = 1005)
  • Rows Removed by Filter: 196