explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mlAH

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

Hash Join (cost=0..0 rows=0 width=0) (actual rows=300,000 loops=1)

2. 0.000 0.000 ↓ 0.0 300,000 1

Seq Scan on TransactionLabels transactionlabels (cost=0..0 rows=0 width=0) (actual rows=300,000 loops=1)

  • Filter: ("ClassifierId" = 'Affordability'::text)
3. 0.000 0.000 ↓ 0.0 10 1

Hash (cost=0..0 rows=0 width=0) (actual rows=10 loops=1)

4. 0.000 0.000 ↓ 0.0 10 1

Seq Scan on LabelSets labelsets (cost=0..0 rows=0 width=0) (actual rows=10 loops=1)