explain.depesz.com

A tool for finding a real cause for slow queries.

Result: nYG

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 40.313 69.479 ↑ 1.0 22,531 1

Hash Join (cost=1.09..1,428.58 rows=22,533 width=105) (actual time=0.034..69.479 rows=22,531 loops=1)

  • Hash Cond: (pk2012_services.srv_sdf_id_fk = pk2012_service_definitions.sdf_id)
2. 29.153 29.153 ↑ 1.0 22,531 1

Seq Scan on pk2012_services (cost=0.00..1,117.66 rows=22,533 width=95) (actual time=0.007..29.153 rows=22,531 loops=1)

  • Filter: ((srv_state)::text = 'Z'::text)
3. 0.005 0.013 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=26) (actual time=0.013..0.013 rows=4 loops=1)

4. 0.008 0.008 ↑ 1.0 4 1

Seq Scan on pk2012_service_definitions (cost=0.00..1.04 rows=4 width=26) (actual time=0.004..0.008 rows=4 loops=1)