explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mJnQ

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

HashAggregate (cost=2,755,694.16..2,756,788.16 rows=109,400 width=4) (actual rows= loops=)

  • Group Key: walls.id
2. 0.000 0.000 ↓ 0.0

Append (cost=1,000.00..2,755,420.66 rows=109,400 width=4) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..2,558,583.10 rows=98,242 width=4) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on walls (cost=0.00..2,547,758.90 rows=40,934 width=4) (actual rows= loops=)

  • Filter: ((updated_at >= '2020-03-15 17:00:00'::timestamp without time zone) AND (updated_at <= '2020-03-16 16:59:59'::timestamp without time zone))
5. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..37,376.34 rows=11,157 width=4) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on wall_likes (cost=0.00..35,260.64 rows=4,649 width=4) (actual rows= loops=)

  • Filter: ((created_at >= '2020-03-15 17:00:00'::timestamp without time zone) AND (created_at <= '2020-03-16 16:59:59'::timestamp without time zone))
7. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..158,367.21 rows=1 width=4) (actual rows= loops=)

  • Workers Planned: 2
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on wall_remakes (cost=0.00..157,367.11 rows=1 width=4) (actual rows= loops=)

  • Filter: ((created_at >= '2020-03-15 17:00:00'::timestamp without time zone) AND (created_at <= '2020-03-16 16:59:59'::timestamp without time zone))