explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MRPS

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

Limit (cost=0.86..1,159.59 rows=5 width=3,534) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..2,823,834.06 rows=12,185 width=3,534) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using manifestation_date_desc_idx on manifestation m0_ (cost=0.43..2,440,754.31 rows=229,941 width=1,834) (actual rows= loops=)

  • Filter: (downloadable AND (file IS NOT NULL) AND (NOT deleted) AND ((copyright_expiration_date IS NULL) OR (copyright_expiration_date >= '1600084818'::numeric)) AND ((provider)::text = 'public'::text))
4. 0.000 0.000 ↓ 0.0

Index Scan using replay_item_pkey on replay_item r1_ (cost=0.42..1.67 rows=1 width=1,696) (actual rows= loops=)

  • Index Cond: ((uuid)::text = (m0_.replay_item_id)::text)
  • Filter: ((NOT deleted) AND (replay_cu = 17,258))