explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Zv2

Settings
# exclusive inclusive rows x rows loops node
1. 401.712 807.088 ↑ 1.0 300,000 1

Hash Join (cost=1.23..47,647.98 rows=305,220 width=48) (actual time=0.089..807.088 rows=300,000 loops=1)

  • Buffers: shared hit=15750 read=8257
2. 405.344 405.344 ↑ 1.0 300,000 1

Seq Scan on TransactionLabels transactionlabels (cost=0..46,506 rows=305,220 width=48) (actual time=0.044..405.344 rows=300,000 loops=1)

  • Filter: (transactionlabels."ClassifierId" = 'Affordability'::text)
  • Buffers: shared hit=15749 read=8257
3. 0.011 0.032 ↑ 1.0 10 1

Hash (cost=1.1..1.1 rows=10 width=12) (actual time=0.031..0.032 rows=10 loops=1)

  • Buffers: shared hit=1
4. 0.021 0.021 ↑ 1.0 10 1

Seq Scan on LabelSets labelsets (cost=0..1.1 rows=10 width=12) (actual time=0.003..0.021 rows=10 loops=1)

  • Buffers: shared hit=1
Planning time : 0.132 ms
Execution time : 970.49 ms