explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d49r

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

Hash Join (cost=3,346.72..27,829.70 rows=439 width=118) (actual rows= loops=)

  • Hash Cond: (c0.platformid = p.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,345.65..27,825.86 rows=439 width=118) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,345.36..27,336.73 rows=439 width=110) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,344.79..26,663.17 rows=439 width=24) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,344.22..3,428.62 rows=8,440 width=8) (actual rows= loops=)

  • Group Key: m.contentobjectid
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,170.23..3,323.12 rows=8,440 width=8) (actual rows= loops=)

  • Hash Cond: (m.contentauthorid = c1.id)
7. 0.000 0.000 ↓ 0.0

Seq Scan on mention m (cost=0.00..1,960.15 rows=73,415 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=1,116.29..1,116.29 rows=4,315 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on contentauthor c1 (cost=72.75..1,116.29 rows=4,315 width=8) (actual rows= loops=)

  • Recheck Cond: (((emailaddress)::text = ANY ('{kyjah@awarehq.com}'::text[])) OR (emailaddress IS NULL))
10. 0.000 0.000 ↓ 0.0

BitmapOr (cost=72.75..72.75 rows=4,315 width=0) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on contentauthor_emailaddress_idx (cost=0.00..1.52 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((emailaddress)::text = ANY ('{kyjah@awarehq.com}'::text[]))
12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on contentauthor_emailaddress_idx (cost=0.00..69.07 rows=4,314 width=0) (actual rows= loops=)

  • Index Cond: (emailaddress IS NULL)
13. 0.000 0.000 ↓ 0.0

Index Scan using contentobject_pk on contentobject c (cost=0.57..2.75 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = m.contentobjectid)
  • Filter: ((contentdate >= '2020-06-06 00:00:00+00'::timestamp with time zone) AND (contentdate <= '2020-06-17 00:00:00+00'::timestamp with time zone))
14. 0.000 0.000 ↓ 0.0

Index Scan using searchindex_pk on searchindex s (cost=0.57..1.53 rows=1 width=94) (actual rows= loops=)

  • Index Cond: (id = c.id)
15. 0.000 0.000 ↓ 0.0

Index Scan using contentauthor_pk on contentauthor c0 (cost=0.29..1.11 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = c.contentauthorid)
16. 0.000 0.000 ↓ 0.0

Hash (cost=1.03..1.03 rows=3 width=8) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on platform p (cost=0.00..1.03 rows=3 width=8) (actual rows= loops=)