explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W8hm

Settings
# exclusive inclusive rows x rows loops node
1. 1.995 21,841.374 ↓ 3.2 1,661 1

Nested Loop Left Join (cost=492,775.40..1,168,722.26 rows=523 width=324) (actual time=19,766.115..21,841.374 rows=1,661 loops=1)

2. 2,058.125 21,777.922 ↓ 3.2 1,661 1

Hash Join (cost=492,774.98..1,168,468.89 rows=523 width=320) (actual time=19,766.094..21,777.922 rows=1,661 loops=1)

  • Hash Cond: (component.id = component_extended.component_id)
  • Join Filter: ((component_extended.last_modified_date > '2019-01-04 13:20:00'::timestamp without time zone) OR (component.last_modified_date > '2019-01-04 13:20:00'::timestamp without time zone) OR (enquiry.last_modified_date > '2019-01-04 13:20:00'::timestamp without time zone))
  • Rows Removed by Join Filter: 1600002
3. 2,248.803 16,473.866 ↑ 1.1 1,601,773 1

Hash Join (cost=74,433.85..606,261.07 rows=1,795,406 width=67) (actual time=1,328.930..16,473.866 rows=1,601,773 loops=1)

  • Hash Cond: (component.enquiry_id = enquiry.id)
4. 12,905.218 12,905.218 ↑ 1.1 1,656,560 1

Seq Scan on component (cost=0.00..453,930.06 rows=1,860,910 width=47) (actual time=0.012..12,905.218 rows=1,656,560 loops=1)

  • Filter: active
  • Rows Removed by Filter: 30513
5. 597.265 1,319.845 ↓ 1.0 1,473,672 1

Hash (cost=47,419.61..47,419.61 rows=1,471,379 width=24) (actual time=1,319.845..1,319.845 rows=1,473,672 loops=1)

  • Buckets: 8192 Batches: 32 Memory Usage: 2698kB
6. 722.580 722.580 ↓ 1.0 1,473,672 1

Seq Scan on enquiry (cost=0.00..47,419.61 rows=1,471,379 width=24) (actual time=0.004..722.580 rows=1,473,672 loops=1)

  • Filter: active
  • Rows Removed by Filter: 54972
7. 1,199.665 3,245.931 ↓ 1.0 1,685,388 1

Hash (cost=334,554.17..334,554.17 rows=1,656,317 width=281) (actual time=3,245.931..3,245.931 rows=1,685,388 loops=1)

  • Buckets: 2048 Batches: 256 Memory Usage: 1074kB
8. 2,046.266 2,046.266 ↓ 1.0 1,685,388 1

Seq Scan on component_extended (cost=0.00..334,554.17 rows=1,656,317 width=281) (actual time=0.010..2,046.266 rows=1,685,388 loops=1)

  • Filter: active
9. 61.457 61.457 ↓ 0.0 0 1,661

Index Scan using translation_entity_id_index on translation (cost=0.42..0.47 rows=1 width=8) (actual time=0.037..0.037 rows=0 loops=1,661)

  • Index Cond: (entity_id = enquiry.id)
  • Filter: (active AND ((entity_type)::text = 'enquiry'::text))