explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tGV

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 0.071 ↑ 1.0 19 1

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

  • Sort Key: foreign_name
  • Sort Method: quicksort Memory: 26kB
2. 0.041 0.041 ↑ 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.041 rows=19 loops=1)

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