explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IL6B : Test

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

Gather Motion 80:1 (slice4; segments: 80) (cost=0.00..1,724.00 rows=3 width=70) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,724.00 rows=1 width=70) (actual rows= loops=)

  • Hash Cond: cash_payment_state_msg.transmission_state_id = magnet_ref.ref_state.state_id
3. 0.000 0.000 ↓ 0.0

Redistribute Motion 80:80 (slice3; segments: 80) (cost=0.00..1,293.00 rows=1 width=66) (actual rows= loops=)

  • Hash Key: cash_payment_state_msg.transmission_state_id
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,293.00 rows=1 width=66) (actual rows= loops=)

  • Hash Cond: cash_payment_state_msg.agent_state_id = magnet_ref.ref_state.state_id
5. 0.000 0.000 ↓ 0.0

Redistribute Motion 80:80 (slice2; segments: 80) (cost=0.00..862.00 rows=1 width=20) (actual rows= loops=)

  • Hash Key: cash_payment_state_msg.agent_state_id
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.00 rows=1 width=20) (actual rows= loops=)

  • Hash Cond: cash_payment_state_msg.settlement_state_id = magnet_ref.ref_state.state_id
7. 0.000 0.000 ↓ 0.0

Redistribute Motion 80:80 (slice1; segments: 80) (cost=0.00..431.00 rows=1 width=20) (actual rows= loops=)

  • Hash Key: cash_payment_state_msg.settlement_state_id
8. 0.000 0.000 ↓ 0.0

Table Scan on cash_payment_state_msg (cost=0.00..431.00 rows=1 width=20) (actual rows= loops=)

  • Filter: date(upd_time_end) = '2900-01-01'::date
9. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Table Scan on ref_state (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: state_name::text <> ALL ('{SETTLEMENT_CLOSED,SETTLEMENT_FULLY_SETTLED,SETTLEMENT_CANCELLED}'::text[])
11. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=54) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Table Scan on ref_state (cost=0.00..431.00 rows=1 width=54) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=12) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Table Scan on ref_state (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)