explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z1vw

Settings
# exclusive inclusive rows x rows loops node
1. 419.682 828.749 ↑ 1.0 300,000 1

Hash Join (cost=44.65..50,747.43 rows=305,220 width=48) (actual time=0.086..828.749 rows=300,000 loops=1)

  • Buffers: shared hit=15,558 read=8,449
2. 409.048 409.048 ↑ 1.0 300,000 1

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

  • Filter: (transactionlabels."ClassifierId" = 'Affordability'::text)
  • Buffers: shared hit=15,557 read=8,449
3. 0.009 0.019 ↑ 154.0 10 1

Hash (cost=25.4..25.4 rows=1,540 width=12) (actual time=0.018..0.019 rows=10 loops=1)

  • Buffers: shared hit=1
4. 0.010 0.010 ↑ 154.0 10 1

Seq Scan on LabelSets labelsets (cost=0..25.4 rows=1,540 width=12) (actual time=0.004..0.01 rows=10 loops=1)

  • Buffers: shared hit=1
Planning time : 0.251 ms
Execution time : 993.892 ms