explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sEv

Settings
# exclusive inclusive rows x rows loops node
1. 3.184 23,453.347 ↑ 73.0 2 1

HashAggregate (cost=13,096.09..13,097.55 rows=146 width=4) (actual time=23,453.345..23,453.347 rows=2 loops=1)

  • Group Key: slr_specificity.id
2. 23,419.189 23,450.163 ↓ 6.3 23,960 1

Hash Right Join (cost=130.35..13,086.62 rows=3,790 width=4) (actual time=21,935.762..23,450.163 rows=23,960 loops=1)

  • Hash Cond: (slr_employee_specificity.specificity_id = slr_specificity.id)
  • Filter: ((slr_employee_specificity.employee_id = 597383) OR (slr_manning_table_specificity.manningtable_id = 209163) OR (slr_departmen_specificity.department_id = 29877))
  • Rows Removed by Filter: 129485707
3. 20.837 20.837 ↑ 1.0 31,490 1

Seq Scan on slr_employee_specificity (cost=0.00..485.90 rows=31,490 width=8) (actual time=0.019..20.837 rows=31,490 loops=1)

4. 4.685 10.137 ↓ 9.7 29,857 1

Hash (cost=92.05..92.05 rows=3,064 width=12) (actual time=10.137..10.137 rows=29,857 loops=1)

  • Buckets: 32768 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1537kB
5. 5.028 5.452 ↓ 9.7 29,857 1

Hash Right Join (cost=17.50..92.05 rows=3,064 width=12) (actual time=0.198..5.452 rows=29,857 loops=1)

  • Hash Cond: (slr_manning_table_specificity.specificity_id = slr_specificity.id)
6. 0.238 0.238 ↑ 1.0 2,248 1

Seq Scan on slr_manning_table_specificity (cost=0.00..35.48 rows=2,248 width=8) (actual time=0.006..0.238 rows=2,248 loops=1)

7. 0.048 0.186 ↓ 1.5 306 1

Hash (cost=15.01..15.01 rows=199 width=8) (actual time=0.186..0.186 rows=306 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
8. 0.062 0.138 ↓ 1.5 306 1

Hash Right Join (cost=8.29..15.01 rows=199 width=8) (actual time=0.068..0.138 rows=306 loops=1)

  • Hash Cond: (slr_departmen_specificity.specificity_id = slr_specificity.id)
9. 0.020 0.020 ↑ 1.0 199 1

Seq Scan on slr_departmen_specificity (cost=0.00..3.99 rows=199 width=8) (actual time=0.005..0.020 rows=199 loops=1)

10. 0.021 0.056 ↑ 1.0 146 1

Hash (cost=6.46..6.46 rows=146 width=4) (actual time=0.056..0.056 rows=146 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
11. 0.035 0.035 ↑ 1.0 146 1

Seq Scan on slr_specificity (cost=0.00..6.46 rows=146 width=4) (actual time=0.008..0.035 rows=146 loops=1)

Planning time : 0.511 ms
Execution time : 23,453.448 ms