explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S2kV

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

WindowAgg (cost=15,078.32..32,831.98 rows=51,116 width=753) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=15,078.32..32,193.03 rows=51,116 width=745) (actual rows= loops=)

  • Group Key: entries._id
3. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=15,078.32..27,894.69 rows=104,554 width=741) (actual rows= loops=)

  • Merge Cond: (entries._id = "keyDates"."entryId")
4. 0.000 0.000 ↓ 0.0

Index Scan using entries_pkey on entries (cost=0.29..10,743.55 rows=51,116 width=713) (actual rows= loops=)

  • Filter: ("isValid" AND "isPublished")
5. 0.000 0.000 ↓ 0.0

Materialize (cost=15,077.97..15,677.87 rows=119,979 width=28) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=15,077.97..15,377.92 rows=119,979 width=28) (actual rows= loops=)

  • Sort Key: "keyDates"."entryId
7. 0.000 0.000 ↓ 0.0

Seq Scan on "entryKeyDates" "keyDates" (cost=0.00..2,082.79 rows=119,979 width=28) (actual rows= loops=)