explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LTSl

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 265.442 ↑ 1.0 1 1

Limit (cost=1,736.41..1,736.41 rows=1 width=63) (actual time=265.441..265.442 rows=1 loops=1)

2. 0.333 265.440 ↑ 2,930.0 1 1

Sort (cost=1,736.41..1,737.88 rows=2,930 width=63) (actual time=265.440..265.440 rows=1 loops=1)

  • Sort Key: ((field_values ->> 'f_K4JogvNSOX'::text)) DESC, iid DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 265.107 265.107 ↑ 4.7 621 1

Seq Scan on records "Record" (cost=0.00..1,733.48 rows=2,930 width=63) (actual time=0.421..265.107 rows=621 loops=1)

  • Filter: ((deleted_at IS NULL) AND ((field_values ->> 'f_4i6frCjORu'::text) IS NOT NULL) AND ((table_id)::text = 't_V9aaDdPAgp'::text) AND ((field_values ->> 'f_4i6frCjORu'::text) <> ''::text) AND ((field_values ->> 'f_O8rtPtspx5'::text) <> 'Investor'::text) AND ((field_values ->> 'f_m7BjAg9tqp'::text) <> 'Competitor'::text) AND ((field_values ->> 'f_4i6frCjORu'::text) !~~* '%clay.run%'::text) AND (((field_values ->> 'f_K4JogvNSOX'::text) IS NOT NULL) OR (((field_values ->> 'f_K4JogvNSOX'::text) IS NULL) AND (iid < 11889))))
  • Rows Removed by Filter: 13,065
Planning time : 0.130 ms
Execution time : 265.475 ms