explain.depesz.com

A tool for finding a real cause for slow queries.

Result: W6Y

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

Nested Loop (cost=727316.32..729690.26 rows=66 width=697) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

HashAggregate (cost=727316.32..727324.52 rows=298 width=29) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=22.30..727312.60 rows=298 width=29) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=22.30..400493.95 rows=9221 width=61) (actual time=.. rows= loops=)

  • Hash Cond: ((p.po_date_post_day)::text = (to_char(((to_date(substr((public.tmp_posts.po_date_like)::text, 1, 8), 'YYYYMMDD'::text) - 1))::timestamp with time zone, 'YYYYMMDD'::text)))
5. 0.000 0.000 ↓ 0.0
→

Hash Semi Join (cost=10.90..399558.72 rows=221765 width=29) (actual time=.. rows= loops=)

  • Hash Cond: (p.po_pa_page_id = public.tmp_posts.po_pa_page_id)
6. 0.000 0.000 ↓ 0.0
→

Seq Scan on posts p (cost=0.00..376997.06 rows=7650906 width=29) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0
→

Hash (cost=10.65..10.65 rows=20 width=8) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0
→

HashAggregate (cost=10.25..10.45 rows=20 width=8) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0
→

Seq Scan on tmp_posts (cost=0.00..10.20 rows=20 width=8) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0
→

Hash (cost=11.15..11.15 rows=20 width=32) (actual time=.. rows= loops=)

11. 0.000 0.000 ↓ 0.0
→

HashAggregate (cost=10.50..10.95 rows=20 width=46) (actual time=.. rows= loops=)

12. 0.000 0.000 ↓ 0.0
→

Seq Scan on tmp_posts (cost=0.00..10.45 rows=20 width=46) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0
→

Index Scan using posts_likes_pk on posts_likes pl (cost=0.00..35.41 rows=2 width=25) (actual time=.. rows= loops=)

  • Index Cond: ((pl.id = p.id) AND ((pl.pol_date_day)::text = (p.po_date_post_day)::text))
14. 0.000 0.000 ↓ 0.0
→

Index Scan using pl_id_date_day_idx on pages_likes (cost=0.00..7.91 rows=1 width=601) (actual time=.. rows= loops=)

  • Index Cond: ((pages_likes.id = p.po_pa_page_id) AND ((pages_likes.pl_date_day)::text = (p.po_date_post_day)::text))