explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OnO

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 0.363 ↑ 1.0 1 1

Sort (cost=4.56..4.56 rows=1 width=133) (actual time=0.362..0.363 rows=1 loops=1)

  • Sort Key: pk_bint_capturing_fields_settings_id
  • Sort Method: quicksort Memory: 25kB
2. 0.311 0.311 ↑ 1.0 1 1

Seq Scan on tbl_capturing_fields_settings (cost=0.00..4.55 rows=1 width=133) (actual time=0.184..0.311 rows=1 loops=1)

  • Filter: ((vchr_attribute_name)::text ~~* '%Employee Grade%'::text)
  • Rows Removed by Filter: 123
Planning time : 64.831 ms
Execution time : 0.455 ms