explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Cxx : teete

Settings

Optimization(s) for this plan:

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

Sort (cost=56.09..56.11 rows=6 width=41) (actual rows= loops=)

  • Sort Key: eap.tldapplicationphaseid NULLS FIRST
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18.31..56.01 rows=6 width=41) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using pk_tld on tld (cost=0.14..2.37 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (tldid = 8)
  • Filter: (tldstatusid <> ALL ('{4,6}'::integer[]))
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=18.17..53.59 rows=6 width=41) (actual rows= loops=)

  • Hash Cond: (eap.tldapplicationphaseid = tap.tldapplicationphaseid)
5. 0.000 0.000 ↓ 0.0

Seq Scan on earlyaccessprice eap (cost=0.00..31.79 rows=1,379 width=33) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=18.12..18.12 rows=4 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on tldapplicationphase tap (cost=13.88..18.12 rows=4 width=16) (actual rows= loops=)

  • Recheck Cond: (tldid = 8)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ux_tldapplicationphase_applicationphaseid (cost=0.00..13.88 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (tldid = 8)