explain.depesz.com

PostgreSQL's explain analyze made readable

Result: plRM

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

Limit (cost=0.42..608.96 rows=5 width=49) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.42..3,791,300.54 rows=31,151 width=49) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..3,777,234.29 rows=31,151 width=68) (actual rows= loops=)

  • Join Filter: ((a.recordtypeid)::text = (r.id)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on recordtype r (cost=0.00..8.49 rows=1 width=19) (actual rows= loops=)

  • Filter: ((namex)::text = 'Mosaic Complaint'::text)
5. 0.000 0.000 ↓ 0.0

Seq Scan on "case" a (cost=0.00..3,730,888.69 rows=3,706,969 width=87) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Only Scan using crdb_investigation_casename_ind on investigation i (cost=0.42..0.44 rows=1 width=19) (actual rows= loops=)