explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MmGT

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.634 ↓ 1.5 3 1

Limit (cost=241.15..241.15 rows=2 width=131) (actual time=2.633..2.634 rows=3 loops=1)

2.          

CTE not_active_nodes

3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on certnames certnames_1 (cost=0.00..1.03 rows=1 width=34) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((deactivated IS NOT NULL) OR (expired IS NOT NULL))
  • Rows Removed by Filter: 3
4. 0.014 2.633 ↓ 1.5 3 1

Sort (cost=240.12..240.12 rows=2 width=131) (actual time=2.633..2.633 rows=3 loops=1)

  • Sort Key: reports.end_time DESC
  • Sort Method: quicksort Memory: 25kB
5. 0.003 2.619 ↓ 1.5 3 1

Nested Loop Left Join (cost=1.09..240.11 rows=2 width=131) (actual time=2.596..2.619 rows=3 loops=1)

  • Join Filter: (reports_environment.id = reports.environment_id)
6. 0.002 2.610 ↓ 1.5 3 1

Nested Loop Left Join (cost=1.09..239.03 rows=2 width=119) (actual time=2.589..2.610 rows=3 loops=1)

  • Join Filter: (reports.status_id = report_statuses.id)
  • Rows Removed by Join Filter: 2
7. 0.003 2.605 ↓ 1.5 3 1

Nested Loop Left Join (cost=1.09..237.92 rows=2 width=119) (actual time=2.584..2.605 rows=3 loops=1)

  • Join Filter: (catalogs.certname = certnames.certname)
  • Rows Removed by Join Filter: 6
8. 0.140 2.590 ↓ 1.5 3 1

Hash Right Join (cost=1.09..236.79 rows=2 width=119) (actual time=2.573..2.590 rows=3 loops=1)

  • Hash Cond: ((reports.certname = certnames.certname) AND (reports.id = certnames.latest_report_id))
9. 0.074 2.425 ↑ 1.5 945 1

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

10. 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)

11. 0.323 0.323 ↓ 1.0 144 1

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

12. 0.219 0.219 ↓ 1.0 96 1

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

13. 0.275 0.275 ↓ 1.0 101 1

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

14. 0.308 0.308 ↓ 1.1 137 1

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

15. 0.245 0.245 ↓ 1.0 96 1

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

16. 0.241 0.241 ↓ 1.0 96 1

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

17. 0.209 0.209 ↓ 1.0 76 1

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

18. 0.048 0.048 ↑ 8.8 16 1

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

19. 0.136 0.136 ↑ 2.9 48 1

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

20. 0.129 0.129 ↑ 2.9 48 1

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

21. 0.126 0.126 ↑ 2.9 49 1

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

22. 0.091 0.091 ↑ 3.7 38 1

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

23. 0.003 0.025 ↓ 1.5 3 1

Hash (cost=1.06..1.06 rows=2 width=42) (actual time=0.025..0.025 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
24. 0.018 0.022 ↓ 1.5 3 1

Seq Scan on certnames (cost=0.02..1.06 rows=2 width=42) (actual time=0.021..0.022 rows=3 loops=1)

  • Filter: (NOT (hashed SubPlan 2))
25.          

SubPlan (for Seq Scan)

26. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on not_active_nodes (cost=0.00..0.02 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=1)

27. 0.007 0.012 ↑ 1.0 3 3

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

28. 0.005 0.005 ↑ 1.0 3 1

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

29. 0.001 0.003 ↑ 1.5 2 3

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

30. 0.002 0.002 ↑ 1.5 2 1

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

31. 0.004 0.006 ↑ 2.0 1 3

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

32. 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)