explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QnJ1

Settings
# exclusive inclusive rows x rows loops node
1. 8,775.740 23,555.684 ↑ 1.0 5,406,907 1

Merge Join (cost=11.82..325,091.49 rows=5,455,474 width=48) (actual time=0.059..23,555.684 rows=5,406,907 loops=1)

  • Merge Cond: (e.docactionrequestid = "e.DocActionRequest".id)
2. 7,796.929 7,796.929 ↑ 1.0 6,184,159 1

Index Scan using ix_docunits_docactionrequestid on docunits e (cost=0.44..247,186.73 rows=6,209,280 width=48) (actual time=0.025..7,796.929 rows=6,184,159 loops=1)

  • Index Cond: (docactionrequestid IS NOT NULL)
3. 6,983.015 6,983.015 ↑ 1.0 2,704,764 1

Index Scan using docactionrequests_pkey on docactionrequests "e.DocActionRequest" (cost=0.43..128,169.10 rows=2,719,644 width=4) (actual time=0.026..6,983.015 rows=2,704,764 loops=1)

  • Filter: (type = 13)
  • Rows Removed by Filter: 388631