explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PS3h

Settings
# exclusive inclusive rows x rows loops node
1. 0.254 1,371.828 ↑ 2.7 9 1

Hash Join (cost=1,488.84..142,548.08 rows=24 width=195) (actual time=333.528..1,371.828 rows=9 loops=1)

  • Hash Cond: (invhw.manufacturer_id = invmanufacturer.manufacturer_id)
2. 0.275 1,360.091 ↑ 2.7 9 1

Hash Join (cost=710.77..141,769.68 rows=24 width=148) (actual time=321.800..1,360.091 rows=9 loops=1)

  • Hash Cond: (invhwcomponent.hw_id = invhw.hw_id)
3. 771.590 1,349.956 ↑ 2.7 9 1

Hash Join (cost=43.59..141,102.17 rows=24 width=84) (actual time=311.675..1,349.956 rows=9 loops=1)

  • Hash Cond: (invcomponent.component_id = invhwcomponent.component_id)
4. 578.329 578.329 ↑ 1.0 6,758,505 1

Seq Scan on invcomponent (cost=0.00..115,232.88 rows=6,886,788 width=20) (actual time=0.009..578.329 rows=6,758,505 loops=1)

5. 0.003 0.037 ↑ 2.7 9 1

Hash (cost=43.29..43.29 rows=24 width=64) (actual time=0.037..0.037 rows=9 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.034 0.034 ↑ 2.7 9 1

Index Scan using invhwcomponent_fk3_idx on invhwcomponent (cost=0.42..43.29 rows=24 width=64) (actual time=0.018..0.034 rows=9 loops=1)

  • Index Cond: (computer_id = '181011'::bigint)
7. 7.132 9.860 ↓ 1.0 19,138 1

Hash (cost=428.19..428.19 rows=19,119 width=64) (actual time=9.860..9.860 rows=19,138 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 2,208kB
8. 2.728 2.728 ↓ 1.0 19,138 1

Seq Scan on invhw (cost=0.00..428.19 rows=19,119 width=64) (actual time=0.003..2.728 rows=19,138 loops=1)

9. 8.160 11.483 ↓ 1.0 24,221 1

Hash (cost=475.81..475.81 rows=24,181 width=47) (actual time=11.483..11.483 rows=24,221 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 2,128kB
10. 3.323 3.323 ↓ 1.0 24,221 1

Seq Scan on invmanufacturer (cost=0.00..475.81 rows=24,181 width=47) (actual time=0.007..3.323 rows=24,221 loops=1)