explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9vkY

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

Limit (cost=2,572.29..2,572.41 rows=50 width=334) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=2,572.29..2,582.19 rows=3,960 width=334) (actual rows= loops=)

  • Sort Key: log.added_date DESC
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=127.64..2,440.74 rows=3,960 width=334) (actual rows= loops=)

  • Hash Cond: (log.added_by = performer.id)
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1.20..2,230.16 rows=3,960 width=270) (actual rows= loops=)

  • Hash Cond: (log.action_type = box_status.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on pd_box_history_log_tbl log (cost=0.00..2,174.51 rows=3,960 width=238) (actual rows= loops=)

  • Filter: (company_id = 1429)
6. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=36) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on pd_box_status_tbl box_status (cost=0.00..1.09 rows=9 width=36) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=98.97..98.97 rows=2,197 width=21) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on pd_user_tbl performer (cost=0.00..98.97 rows=2,197 width=21) (actual rows= loops=)