explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c2iW

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.628 ↑ 1.0 3 1

Limit (cost=240.23..240.24 rows=3 width=131) (actual time=1.627..1.628 rows=3 loops=1)

2. 0.009 1.626 ↑ 1.0 3 1

Sort (cost=240.23..240.24 rows=3 width=131) (actual time=1.626..1.626 rows=3 loops=1)

  • Sort Key: reports.end_time DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.005 1.617 ↑ 1.0 3 1

Nested Loop Left Join (cost=1.07..240.20 rows=3 width=131) (actual time=1.593..1.617 rows=3 loops=1)

  • Join Filter: (reports_environment.id = reports.environment_id)
4. 0.004 1.609 ↑ 1.0 3 1

Nested Loop Left Join (cost=1.07..239.10 rows=3 width=119) (actual time=1.587..1.609 rows=3 loops=1)

  • Join Filter: (reports.status_id = report_statuses.id)
  • Rows Removed by Join Filter: 2
5. 0.005 1.596 ↑ 1.0 3 1

Nested Loop Left Join (cost=1.07..237.95 rows=3 width=119) (actual time=1.575..1.596 rows=3 loops=1)

  • Join Filter: (catalogs.certname = certnames.certname)
  • Rows Removed by Join Filter: 6
6. 0.148 1.582 ↑ 1.0 3 1

Hash Right Join (cost=1.07..236.78 rows=3 width=119) (actual time=1.566..1.582 rows=3 loops=1)

  • Hash Cond: ((reports.certname = certnames.certname) AND (reports.id = certnames.latest_report_id))
7. 0.083 1.420 ↑ 1.5 945 1

Append (cost=0.00..228.26 rows=1,418 width=126) (actual time=0.014..1.420 rows=945 loops=1)

8. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on reports (cost=0.00..0.00 rows=1 width=131) (actual time=0.001..0.001 rows=0 loops=1)

9. 0.230 0.230 ↓ 1.0 144 1

Seq Scan on reports_20200715z (cost=0.00..33.40 rows=140 width=122) (actual time=0.012..0.230 rows=144 loops=1)

10. 0.146 0.146 ↓ 1.0 96 1

Seq Scan on reports_20200716z (cost=0.00..20.93 rows=93 width=121) (actual time=0.024..0.146 rows=96 loops=1)

11. 0.122 0.122 ↓ 1.0 101 1

Seq Scan on reports_20200717z (cost=0.00..21.97 rows=97 width=122) (actual time=0.008..0.122 rows=101 loops=1)

12. 0.163 0.163 ↓ 1.1 137 1

Seq Scan on reports_20200718z (cost=0.00..29.27 rows=127 width=121) (actual time=0.008..0.163 rows=137 loops=1)

13. 0.117 0.117 ↓ 1.0 96 1

Seq Scan on reports_20200719z (cost=0.00..20.93 rows=93 width=121) (actual time=0.008..0.117 rows=96 loops=1)

14. 0.104 0.104 ↓ 1.0 96 1

Seq Scan on reports_20200720z (cost=0.00..20.93 rows=93 width=121) (actual time=0.007..0.104 rows=96 loops=1)

15. 0.094 0.094 ↓ 1.0 76 1

Seq Scan on reports_20200721z (cost=0.00..16.74 rows=74 width=121) (actual time=0.016..0.094 rows=76 loops=1)

16. 0.033 0.033 ↑ 8.8 16 1

Seq Scan on reports_20200724z (cost=0.00..11.40 rows=140 width=131) (actual time=0.007..0.033 rows=16 loops=1)

17. 0.052 0.052 ↑ 2.9 48 1

Seq Scan on reports_20200725z (cost=0.00..11.40 rows=140 width=131) (actual time=0.006..0.052 rows=48 loops=1)

18. 0.099 0.099 ↑ 2.9 48 1

Seq Scan on reports_20200726z (cost=0.00..11.40 rows=140 width=131) (actual time=0.007..0.099 rows=48 loops=1)

19. 0.094 0.094 ↑ 2.9 49 1

Seq Scan on reports_20200727z (cost=0.00..11.40 rows=140 width=131) (actual time=0.008..0.094 rows=49 loops=1)

20. 0.082 0.082 ↑ 3.7 38 1

Seq Scan on reports_20200728z (cost=0.00..11.40 rows=140 width=131) (actual time=0.012..0.082 rows=38 loops=1)

21. 0.004 0.014 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=42) (actual time=0.013..0.014 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
22. 0.010 0.010 ↑ 1.0 3 1

Seq Scan on certnames (cost=0.00..1.03 rows=3 width=42) (actual time=0.008..0.010 rows=3 loops=1)

23. 0.003 0.009 ↑ 1.0 3 3

Materialize (cost=0.00..1.04 rows=3 width=42) (actual time=0.003..0.003 rows=3 loops=3)

24. 0.006 0.006 ↑ 1.0 3 1

Seq Scan on catalogs (cost=0.00..1.03 rows=3 width=42) (actual time=0.005..0.006 rows=3 loops=1)

25. 0.001 0.009 ↑ 1.5 2 3

Materialize (cost=0.00..1.04 rows=3 width=16) (actual time=0.003..0.003 rows=2 loops=3)

26. 0.008 0.008 ↑ 1.5 2 1

Seq Scan on report_statuses (cost=0.00..1.03 rows=3 width=16) (actual time=0.008..0.008 rows=2 loops=1)

27. 0.001 0.003 ↑ 2.0 1 3

Materialize (cost=0.00..1.03 rows=2 width=22) (actual time=0.001..0.001 rows=1 loops=3)

28. 0.002 0.002 ↑ 2.0 1 1

Seq Scan on environments reports_environment (cost=0.00..1.02 rows=2 width=22) (actual time=0.002..0.002 rows=1 loops=1)