explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MSmB

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 10,048.913 10,048.913 ↑ 4.6 117,938 1

Seq Scan on eventlog (cost=0.00..97,900.23 rows=541,412 width=7) (actual time=2.234..10,048.913 rows=117,938 loops=1)

  • Filter: ((object_name)::text = 'questionnaire_response'::text)
  • Rows Removed by Filter: 85,065
Planning time : 5.139 ms
Execution time : 10,072.110 ms