explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VdqZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=492,775.40..1,168,720.80 rows=520 width=324) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=492,774.98..1,168,468.89 rows=520 width=320) (actual rows= loops=)

  • 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))
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=74,433.85..606,261.07 rows=1,795,406 width=67) (actual rows= loops=)

  • Hash Cond: (component.enquiry_id = enquiry.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on component (cost=0.00..453,930.06 rows=1,860,910 width=47) (actual rows= loops=)

  • Filter: active
5. 0.000 0.000 ↓ 0.0

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

6. 0.000 0.000 ↓ 0.0

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

  • Filter: active
7. 0.000 0.000 ↓ 0.0

Hash (cost=334,554.17..334,554.17 rows=1,656,317 width=281) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on component_extended (cost=0.00..334,554.17 rows=1,656,317 width=281) (actual rows= loops=)

  • Filter: active
9. 0.000 0.000 ↓ 0.0

Index Scan using translation_entity_id_index on translation (cost=0.42..0.47 rows=1 width=8) (actual rows= loops=)

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