explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vmdc

Settings
# exclusive inclusive rows x rows loops node
1. 1.817 46.634 ↑ 11.7 33 1

HashAggregate (cost=3,848.56..3,852.42 rows=386 width=5) (actual time=46.600..46.634 rows=33 loops=1)

  • Group Key: ews_mrp_job_orders.name
2. 5.336 44.817 ↓ 5.2 2,007 1

Nested Loop Left Join (cost=101.55..3,847.60 rows=386 width=5) (actual time=0.872..44.817 rows=2,007 loops=1)

3. 6.518 33.460 ↓ 5.2 2,007 1

Nested Loop Left Join (cost=101.27..3,719.32 rows=386 width=4) (actual time=0.865..33.460 rows=2,007 loops=1)

4. 4.761 20.921 ↓ 5.2 2,007 1

Nested Loop (cost=100.98..3,590.81 rows=386 width=4) (actual time=0.856..20.921 rows=2,007 loops=1)

5. 5.005 10.170 ↓ 5.7 1,198 1

Hash Join (cost=100.56..1,597.20 rows=212 width=4) (actual time=0.835..10.170 rows=1,198 loops=1)

  • Hash Cond: (ews_attendance_day.location_id = hr_locations.id)
6. 4.648 5.117 ↓ 1.1 4,744 1

Bitmap Heap Scan on ews_attendance_day (cost=98.11..1,573.98 rows=4,458 width=6) (actual time=0.519..5.117 rows=4,744 loops=1)

  • Recheck Cond: ((sign_date >= '2019-07-01'::date) AND (sign_date <= '2019-07-31'::date))
  • Heap Blocks: exact=433
7. 0.469 0.469 ↓ 1.1 4,744 1

Bitmap Index Scan on ews_attendance_day_sign_date_index (cost=0.00..97.00 rows=4,458 width=0) (actual time=0.469..0.469 rows=4,744 loops=1)

  • Index Cond: ((sign_date >= '2019-07-01'::date) AND (sign_date <= '2019-07-31'::date))
8. 0.004 0.048 ↑ 1.0 1 1

Hash (cost=2.44..2.44 rows=1 width=4) (actual time=0.048..0.048 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.018 0.044 ↑ 1.0 1 1

Hash Join (cost=1.27..2.44 rows=1 width=4) (actual time=0.039..0.044 rows=1 loops=1)

  • Hash Cond: (hr_locations.location_id = ews_location.id)
10. 0.012 0.012 ↑ 1.0 11 1

Seq Scan on hr_locations (cost=0.00..1.11 rows=11 width=8) (actual time=0.004..0.012 rows=11 loops=1)

11. 0.005 0.014 ↑ 1.0 1 1

Hash (cost=1.26..1.26 rows=1 width=4) (actual time=0.014..0.014 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
12. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on ews_location (cost=0.00..1.26 rows=1 width=4) (actual time=0.007..0.009 rows=1 loops=1)

  • Filter: (partner_id = 5,628)
  • Rows Removed by Filter: 20
13. 5.990 5.990 ↑ 1.5 2 1,198

Index Scan using ews_attendance_ews_attendance_day_id_index on ews_attendance (cost=0.42..9.37 rows=3 width=10) (actual time=0.003..0.005 rows=2 loops=1,198)

  • Index Cond: (ews_attendance_day_id = ews_attendance_day.id)
  • Filter: (active AND (punch_out_time IS NOT NULL))
  • Rows Removed by Filter: 0
14. 6.021 6.021 ↑ 1.0 1 2,007

Index Scan using mrp_bom_pkey on mrp_bom (cost=0.29..0.32 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=2,007)

  • Index Cond: (id = ews_attendance.bom_id)
15. 6.021 6.021 ↑ 1.0 1 2,007

Index Scan using ews_mrp_job_orders_pkey on ews_mrp_job_orders (cost=0.28..0.32 rows=1 width=9) (actual time=0.002..0.003 rows=1 loops=2,007)

  • Index Cond: (id = mrp_bom.job_id)
Planning time : 0.914 ms
Execution time : 46.805 ms