explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 24Ff

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 29,691.019 ↓ 0.0 0 1

Limit (cost=404.25..8,480.63 rows=20 width=259) (actual time=29,691.019..29,691.019 rows=0 loops=1)

2. 29,691.018 29,691.018 ↓ 0.0 0 1

Index Scan using logs_parent_idx on logs (cost=0.43..256,425.60 rows=635 width=259) (actual time=29,691.018..29,691.018 rows=0 loops=1)

  • Index Cond: (parent IS NULL)
  • Filter: ((COALESCE(updated, created) >= '1970-01-19 14:20:38+02'::timestamp with time zone) AND (COALESCE(updated, created) <= '1970-01-19 14:22:04+02'::timestamp with time zone))
  • Rows Removed by Filter: 124,979
Planning time : 0.171 ms
Execution time : 29,691.056 ms