explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Z7C

Settings
# exclusive inclusive rows x rows loops node
1. 1.171 747.001 ↑ 1.0 10,000 1

Limit (cost=0.56..192,793.54 rows=10,000 width=86) (actual time=0.115..747.001 rows=10,000 loops=1)

2. 745.830 745.830 ↑ 23.2 10,000 1

Index Scan Backward using controller_event_log_published_at_idx on controller_event_log (cost=0.56..4,464,179.74 rows=231,553 width=86) (actual time=0.114..745.830 rows=10,000 loops=1)

  • Index Cond: (published_at IS NOT NULL)
  • Filter: (((payload)::text ~ '[0-9]{1,2}\.[0-9]+,[0-9]{1,2}\.[0-9]+,[0-9]{1,2}\.[0-9]+,[0-9]{1,2}\.[0-9]+,[0-9]{1,2},[0-9]{1,2}\.[0-9]+,[0-9]{1,2}$'::text) AND ((topic)::text = 'gps'::text))
  • Rows Removed by Filter: 142679