explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tO32

Settings
# exclusive inclusive rows x rows loops node
1. 2,210.401 19,797.919 ↓ 1.0 1,601,703 1

Hash Join (cost=547,212.93..1,198,620.06 rows=1,570,427 width=324) (actual time=6,528.631..19,797.919 rows=1,601,703 loops=1)

  • Hash Cond: (component.id = component_extended.component_id)
2. 1,996.449 14,367.192 ↑ 1.1 1,601,813 1

Hash Join (cost=130,487.68..651,702.49 rows=1,795,406 width=55) (actual time=3,300.387..14,367.192 rows=1,601,813 loops=1)

  • Hash Cond: (component.enquiry_id = enquiry.id)
3. 9,080.443 9,080.443 ↑ 1.1 1,656,566 1

Seq Scan on component (cost=0.00..453,930.06 rows=1,860,910 width=39) (actual time=0.011..9,080.443 rows=1,656,566 loops=1)

  • Filter: active
  • Rows Removed by Filter: 30513
4. 560.783 3,290.300 ↓ 1.0 1,473,711 1

Hash (cost=103,473.45..103,473.45 rows=1,471,379 width=20) (actual time=3,290.300..3,290.300 rows=1,473,711 loops=1)

  • Buckets: 8192 Batches: 32 Memory Usage: 2264kB
5. 762.908 2,729.517 ↓ 1.0 1,473,711 1

Hash Right Join (cost=72,996.85..103,473.45 rows=1,471,379 width=20) (actual time=1,563.321..2,729.517 rows=1,473,711 loops=1)

  • Hash Cond: (translation.entity_id = enquiry.id)
6. 416.752 416.752 ↓ 1.0 310,408 1

Seq Scan on translation (cost=0.00..16,046.60 rows=305,510 width=8) (actual time=0.462..416.752 rows=310,408 loops=1)

  • Filter: (active AND ((entity_type)::text = 'enquiry'::text))
  • Rows Removed by Filter: 176004
7. 578.809 1,549.857 ↓ 1.0 1,473,678 1

Hash (cost=47,419.61..47,419.61 rows=1,471,379 width=16) (actual time=1,549.857..1,549.857 rows=1,473,678 loops=1)

  • Buckets: 16384 Batches: 32 Memory Usage: 2212kB
8. 971.048 971.048 ↓ 1.0 1,473,678 1

Seq Scan on enquiry (cost=0.00..47,419.61 rows=1,471,379 width=16) (actual time=0.005..971.048 rows=1,473,678 loops=1)

  • Filter: active
  • Rows Removed by Filter: 54972
9. 1,126.167 3,220.326 ↓ 1.0 1,685,394 1

Hash (cost=334,555.22..334,555.22 rows=1,656,322 width=273) (actual time=3,220.326..3,220.326 rows=1,685,394 loops=1)

  • Buckets: 2048 Batches: 128 Memory Usage: 1972kB
10. 2,094.159 2,094.159 ↓ 1.0 1,685,394 1

Seq Scan on component_extended (cost=0.00..334,555.22 rows=1,656,322 width=273) (actual time=0.010..2,094.159 rows=1,685,394 loops=1)

  • Filter: active