explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0qss

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=1,508,269,848.58..1,508,269,848.59 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..1,257,054,365.93 rows=100,486,193,060 width=4) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on content_recordinguser u (cost=0.00..59,549.13 rows=933,713 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.57..917,672.60 rows=107,620 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using rsstuff_rsrecording_rec_end_62eb64cb_uniq on rsstuff_rsrecording r (cost=0.57..917,134.50 rows=107,620 width=4) (actual rows= loops=)

  • Index Cond: ((rec_end < now()) AND (rec_end > (now() - '1 day'::interval)))
  • Filter: (active AND (date_bound IS NOT NULL) AND (state <> 4))