explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oz8

Settings
# exclusive inclusive rows x rows loops node
1. 8,138.414 20,555.940 ↑ 1.0 5,406,907 1

Merge Join (cost=11.87..325,353.42 rows=5,460,271 width=48) (actual time=0.053..20,555.940 rows=5,406,907 loops=1)

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

Index Scan using ix_docunits_docactionrequestid on docunits e (cost=0.44..247,562.28 rows=6,214,740 width=48) (actual time=0.029..6,990.679 rows=6,184,159 loops=1)

  • Index Cond: (docactionrequestid IS NOT NULL)
3. 5,426.847 5,426.847 ↑ 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.018..5,426.847 rows=2,704,764 loops=1)

  • Filter: (type = 13)
  • Rows Removed by Filter: 388631
Planning time : 55.319 ms