explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QPai

Settings
# exclusive inclusive rows x rows loops node
1. 92.584 8,303.245 ↓ 4.4 29,393 1

Nested Loop (cost=38,364.11..95,078.90 rows=6,622 width=18) (actual time=3,527.569..8,303.245 rows=29,393 loops=1)

2. 86.720 3,654.746 ↓ 4.4 29,393 1

Hash Join (cost=38,363.54..38,565.95 rows=6,622 width=12) (actual time=3,519.485..3,654.746 rows=29,393 loops=1)

  • Hash Cond: ((s.recipe_type)::text = (r.type_name)::text)
3. 106.120 3,568.002 ↓ 3.7 48,428 1

Sort (cost=38,352.41..38,385.51 rows=13,243 width=39) (actual time=3,519.420..3,568.002 rows=48,428 loops=1)

  • Sort Key: s.last_seen_at
  • Sort Method: external merge Disk: 1952kB
4. 3,461.882 3,461.882 ↓ 3.7 48,428 1

Index Scan using idx_tree_id on stories s (cost=0.57..37,445.73 rows=13,243 width=39) (actual time=11.702..3,461.882 rows=48,428 loops=1)

  • Index Cond: (tree_id = 23165186)
5. 0.006 0.024 ↑ 11.7 3 1

Hash (cost=10.70..10.70 rows=35 width=516) (actual time=0.023..0.024 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.018 0.018 ↑ 11.7 3 1

Seq Scan on recipes r (cost=0.00..10.70 rows=35 width=516) (actual time=0.015..0.018 rows=3 loops=1)

  • Filter: (suppress_stories IS FALSE)
  • Rows Removed by Filter: 1
7. 4,555.915 4,555.915 ↑ 1.0 1 29,393

Index Scan using scores_pkey on scores ss (cost=0.57..8.53 rows=1 width=10) (actual time=0.155..0.155 rows=1 loops=29,393)

  • Index Cond: ((story_id = s.id) AND ((scorer_model)::text = 'something'::text))
Planning time : 2.995 ms
Execution time : 8,326.574 ms